This discussion is archived
1 Reply Latest reply: May 20, 2013 8:27 PM by Leno Sun RSS

EBS 12.1.3: Unable to throw custom error messages back to Excel document

855401 Newbie
Currently Being Moderated
Hi Gurus,

We are on 12.1.3 using Desktop Integration Framework.
I created a API Procedure based custom Integrator.
In the PLSQL procedure, I have raise_application_error(-20009, ‘Custom Error’) but this message never comes through.
It always shows a ‘SQL exception occurred during PL/SQL upload’.

When it is a success, it shows a green smiley which is fine.
But when there is a explicit raise_application_error in plsql proc, I would like the error message to flow all the way back to Excel document.

1.) What should I be using 'API Procedure or API Function' in the Custom Integrator,
2.) Should it return Error Message or FND Message?

Has it worked for anyone in 12.1.3?
Please let me know.

Thanks
Vinod

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points