I need help please ---- and please do not tell me about the 'White' paper on error messages. I have read the white paper and I think i have followed what they suggested --- of course, I did not enter a number to determine what lines are in error.
I have a new integrator where users are entering new ap invoice lines into a spreadsheet. The integrator loads directly to a custom table.
The Importer handles the rest of the work.
I have a pl/sql package that has 3 procedures. The first procedure edits the data entered into the custom table. Any errors are noted, by invoice line, in the custom table The second procedure checks for any errors for the batch --- and IS TRYING to return the errors to the layout. If no errors are found, the second procedure will also load the AP invoices into the Oracle AP Invoice interface tables. Again, if no errors are found, the second procedure calls the third procedure to kick off the concurrent program to Import the invoices.
That's the theory.
Integrator: loads data from EXCEL layout to a custom table
Importer: PRE_IMPORT Rules - calls first procedure to edit the data in custom table. It also marks any errors it find, in the custom table.
IMPORT Rule -- calls second procedure to load into Oracle AP Interface tables -- but only if there are no errors. PL/SQL API Defn - says to return 'Error Messages'.
Import Rule - Error Definition - reads the custom table for any error\_cds in this particular batch.
- Error Lookup - (Yes, I did load several Error messages in fnd\_lookups). Select statement on fnd\_lookups for custom lookup type and error code that was returned.
I do think the error is happening at the Error Lookup stage - based on the message below.
Can anyone please help?
Thank you
Eileen
