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.