Project and Portfolio Management Practitioners Forum
cancel

How to get errors from a customized Oracle component to the user

Highlighted
jerome.vovard
Super Contributor.

How to get errors from a customized Oracle component to the user

Hi All,
I created a lot of customized Oracle components (Functions and Procedures) for my PPM instance. All of them return 'FAILURE' or 'SUCCESS'. I use its with some execution steps using a standard validation.
Then,if the user gets a 'Failed' transition into his request, its transaction details report will not show him the oracle error message. How could I do this? I mean, getting the oracle error message and put it to PPM transaction detail.
I found the knta_message package but I don't know how to use its functions.
Can you help me?