150: l_error := SQLERRM;
151: retcode := 2;
152: FND_FILE.PUT_LINE(fnd_file.log,'No data found');
153: WHEN unequal_value THEN
154: errbuf := fnd_message.get;
155: l_error_stack := errbuf;
156: l_error := SQLERRM;
157: retcode := 2;
158: IF l_count_mth_taxcredit <> l_count_emp_recno THEN
240: , sysdate);
241: COMMIT;
242:
243: WHEN OTHERS THEN
244: errbuf := fnd_message.get;
245: l_error_stack := errbuf;
246: l_error := SQLERRM;
247: retcode := 2;
248: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
1429: , sysdate);
1430: COMMIT;
1431:
1432: WHEN OTHERS THEN
1433: errbuf := fnd_message.get;
1434: l_error_stack := errbuf;
1435: l_error := SQLERRM;
1436:
1437: /*Update interface table and set processed flag to 'No' to record that record has not been updated
1574: COMMIT;
1575:
1576: WHEN OTHERS THEN
1577:
1578: errbuf := fnd_message.get;
1579: l_error_stack := errbuf;
1580: l_error := SQLERRM;
1581: retcode := 2;
1582: /* The following command will be used to output the exception details to an output file*/