Wa alaikum assalam wr wb Asif,
Thanks for the reply.
We tested the link provided, its not working too, actually we tested the link before posting here in oracle forums.
So we decided to raise an message error if reason field is null, it is working fine. (alternate solution )
Thanks a lot akhi.
Glad to know you managed to solve the issue.
Thanks for the update. You may mark your reply as answered and close the thread as this might help others seeking answer to the same question.