Oracle Message PLS-00621 - at least one operand in the COALESCE expression must not be NULL

ERROR	at least one operand in the COALESCE expression must not be NULL
CAUSE	All the operands in the COALESCE expression are the literal NULL.
ACTION	Change at least one operand in the COALESCE expression to be non-NULL.