Oracle Error Message
PLS-00617: at least one result in the CASE expression must not be NULL
Reason for the Error
All the results in the CASE expression are the literal NULL.
Solution
Change at least one result in the CASE expression to be non-NULL.