I have created a Custom Integrator using Manage Integrator Function from Desktop Integration Manager Responsibility in R12.1.3. I have created Interface of type Procedure and API return type as NULL.
Now when i am raising error in PL/SQL procedure (raise_application_error), the custom error message which i am raising is not appearing. Instead 'SQL Exception Occurred in PL/SQL upload' always on the xl sheet while uploading data.
Where as same PL/SQL Procedure is displaying correct error message, i f i am creating an integrator using Create Document feature as in previous EBS Versions.
Do i need to do any thing specific to display custom error messages in R12.1.3.
Please check the 'API Returns' is setted with 'FND Message Code' in Interfaces define(Step 2 of 5).