report error messages from custom integratror from Importer PL/SQL back to the rows.
I need to report error messages from custom integratror from Importer PL/SQL back to the rows. I tried two approaches
1) Approach One
I tried to use the below statements in the PL/SQL called in the importer and used the return Type as FND Message Code. But this does not return any error message. I did define the message using application developer
fnd_message.set_name('BNE','WEB ADI ERROR');
fnd_message.set_token('MSG',l_msg);
fnd_message.raise_error;
2) Approach Two
I defined the Error Row Definition to define the error rows and the the error message rule. With this approach the parameters passed from the interface table is not being recognized in the error message lookup rule.