Message Oracle PLS-00166 - bad format for date, time, timestamp or interval literal

ERRORbad format for date, time, timestamp or interval literal
CAUSEThe contents of the date, time, timestamp or interval literal did not match the expected format.
ACTIONCorrect the format for the date, datetime, or interval literal.