DBA Data[Home] [Help]

APPS.BIM_SET_OF_BOOKS dependencies on FND_MESSAGE

Line 107: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

103:
104: EXCEPTION
105: WHEN fnd_api.g_exc_unexpected_error THEN
106: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
107: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
108: fnd_message.set_token('ROW', l_api_name || ' ' ||
109: p_input_date || ' ' || p_org_id || ' '
110: || ' -- NO DATA FOUND -- ' );
111: fnd_msg_pub.add;

Line 108: fnd_message.set_token('ROW', l_api_name || ' ' ||

104: EXCEPTION
105: WHEN fnd_api.g_exc_unexpected_error THEN
106: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
107: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
108: fnd_message.set_token('ROW', l_api_name || ' ' ||
109: p_input_date || ' ' || p_org_id || ' '
110: || ' -- NO DATA FOUND -- ' );
111: fnd_msg_pub.add;
112: RAISE;

Line 169: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

165:
166: EXCEPTION
167: WHEN fnd_api.g_exc_unexpected_error THEN
168: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
169: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
170: fnd_message.set_token('ROW', l_api_name || ' ' ||
171: p_input_date || ' ' || p_org_id || ' '
172: || ' -- NO DATA FOUND -- ' );
173: fnd_msg_pub.add;

Line 170: fnd_message.set_token('ROW', l_api_name || ' ' ||

166: EXCEPTION
167: WHEN fnd_api.g_exc_unexpected_error THEN
168: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
169: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
170: fnd_message.set_token('ROW', l_api_name || ' ' ||
171: p_input_date || ' ' || p_org_id || ' '
172: || ' -- NO DATA FOUND -- ' );
173: fnd_msg_pub.add;
174: RAISE;

Line 178: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

174: RAISE;
175:
176: WHEN OTHERS THEN
177: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
178: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
179: fnd_message.set_token('ROW', l_api_name || ' ' ||
180: p_input_date || ' ' || p_org_id || ' '
181: || SQLERRM||' ' ||SQLCODE);
182: fnd_msg_pub.add;

Line 179: fnd_message.set_token('ROW', l_api_name || ' ' ||

175:
176: WHEN OTHERS THEN
177: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
178: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
179: fnd_message.set_token('ROW', l_api_name || ' ' ||
180: p_input_date || ' ' || p_org_id || ' '
181: || SQLERRM||' ' ||SQLCODE);
182: fnd_msg_pub.add;
183: RAISE;

Line 231: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

227: RETURN(l_qtr);
228:
229: EXCEPTION
230: WHEN fnd_api.g_exc_unexpected_error THEN
231: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
232: fnd_message.set_token('ROW', l_api_name || ' ' ||
233: p_input_date || ' ' || p_org_id || ' '
234: || ' -- NO DATA FOUND -- ' );
235: fnd_msg_pub.add;

Line 232: fnd_message.set_token('ROW', l_api_name || ' ' ||

228:
229: EXCEPTION
230: WHEN fnd_api.g_exc_unexpected_error THEN
231: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
232: fnd_message.set_token('ROW', l_api_name || ' ' ||
233: p_input_date || ' ' || p_org_id || ' '
234: || ' -- NO DATA FOUND -- ' );
235: fnd_msg_pub.add;
236: RAISE;

Line 239: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

235: fnd_msg_pub.add;
236: RAISE;
237:
238: WHEN OTHERS THEN
239: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
240: fnd_message.set_token('ROW', l_api_name || ' ' ||
241: p_input_date || ' ' || p_org_id || ' '
242: || SQLERRM||' ' ||SQLCODE);
243: fnd_msg_pub.add;

Line 240: fnd_message.set_token('ROW', l_api_name || ' ' ||

236: RAISE;
237:
238: WHEN OTHERS THEN
239: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
240: fnd_message.set_token('ROW', l_api_name || ' ' ||
241: p_input_date || ' ' || p_org_id || ' '
242: || SQLERRM||' ' ||SQLCODE);
243: fnd_msg_pub.add;
244: RAISE;

Line 295: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

291:
292: EXCEPTION
293: WHEN fnd_api.g_exc_unexpected_error THEN
294: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
295: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
296: fnd_message.set_token('ROW', l_api_name || ' ' ||
297: p_input_date || ' ' || p_org_id || ' '
298: || ' -- NO DATA FOUND -- ' );
299: fnd_msg_pub.add;

Line 296: fnd_message.set_token('ROW', l_api_name || ' ' ||

292: EXCEPTION
293: WHEN fnd_api.g_exc_unexpected_error THEN
294: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
295: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
296: fnd_message.set_token('ROW', l_api_name || ' ' ||
297: p_input_date || ' ' || p_org_id || ' '
298: || ' -- NO DATA FOUND -- ' );
299: fnd_msg_pub.add;
300: RAISE;

Line 304: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

300: RAISE;
301:
302: WHEN OTHERS THEN
303: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
304: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
305: fnd_message.set_token('ROW', l_api_name || ' ' ||
306: p_input_date || ' ' || p_org_id || ' '
307: || SQLERRM||' ' ||SQLCODE);
308: fnd_msg_pub.add;

Line 305: fnd_message.set_token('ROW', l_api_name || ' ' ||

301:
302: WHEN OTHERS THEN
303: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
304: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
305: fnd_message.set_token('ROW', l_api_name || ' ' ||
306: p_input_date || ' ' || p_org_id || ' '
307: || SQLERRM||' ' ||SQLCODE);
308: fnd_msg_pub.add;
309: RAISE;

Line 360: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

356:
357: EXCEPTION
358: WHEN fnd_api.g_exc_unexpected_error THEN
359: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
360: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
361: fnd_message.set_token('ROW', l_api_name || ' ' ||
362: p_input_date || ' ' || p_org_id || ' '
363: || ' -- NO DATA FOUND -- ' );
364: fnd_msg_pub.add;

Line 361: fnd_message.set_token('ROW', l_api_name || ' ' ||

357: EXCEPTION
358: WHEN fnd_api.g_exc_unexpected_error THEN
359: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
360: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
361: fnd_message.set_token('ROW', l_api_name || ' ' ||
362: p_input_date || ' ' || p_org_id || ' '
363: || ' -- NO DATA FOUND -- ' );
364: fnd_msg_pub.add;
365: RAISE;

Line 369: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

365: RAISE;
366:
367: WHEN OTHERS THEN
368: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
369: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
370: fnd_message.set_token('ROW', l_api_name || ' ' ||
371: p_input_date || ' ' || p_org_id || ' '
372: || SQLERRM||' ' ||SQLCODE);
373: fnd_msg_pub.add;

Line 370: fnd_message.set_token('ROW', l_api_name || ' ' ||

366:
367: WHEN OTHERS THEN
368: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
369: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
370: fnd_message.set_token('ROW', l_api_name || ' ' ||
371: p_input_date || ' ' || p_org_id || ' '
372: || SQLERRM||' ' ||SQLCODE);
373: fnd_msg_pub.add;
374: RAISE;

Line 426: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

422:
423: EXCEPTION
424: WHEN fnd_api.g_exc_unexpected_error THEN
425: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_name || ' ' || SQLERRM(SQLCODE));
426: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
427: fnd_message.set_token('ROW', l_api_name || ' ' ||
428: p_name || ' ' ||p_type||' '|| p_org_id || ' '
429: || ' -- NO DATA FOUND -- ' );
430: fnd_msg_pub.add;

Line 427: fnd_message.set_token('ROW', l_api_name || ' ' ||

423: EXCEPTION
424: WHEN fnd_api.g_exc_unexpected_error THEN
425: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_name || ' ' || SQLERRM(SQLCODE));
426: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
427: fnd_message.set_token('ROW', l_api_name || ' ' ||
428: p_name || ' ' ||p_type||' '|| p_org_id || ' '
429: || ' -- NO DATA FOUND -- ' );
430: fnd_msg_pub.add;
431: RAISE;

Line 435: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

431: RAISE;
432:
433: WHEN OTHERS THEN
434: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_name || ' ' || SQLERRM(SQLCODE));
435: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
436: fnd_message.set_token('ROW', l_api_name || ' ' ||
437: p_name || ' ' ||p_type||' '|| p_org_id || ' '
438: || SQLERRM||' ' ||SQLCODE);
439: fnd_msg_pub.add;

Line 436: fnd_message.set_token('ROW', l_api_name || ' ' ||

432:
433: WHEN OTHERS THEN
434: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_name || ' ' || SQLERRM(SQLCODE));
435: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
436: fnd_message.set_token('ROW', l_api_name || ' ' ||
437: p_name || ' ' ||p_type||' '|| p_org_id || ' '
438: || SQLERRM||' ' ||SQLCODE);
439: fnd_msg_pub.add;
440: RAISE;

Line 490: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

486: EXCEPTION
487: WHEN fnd_api.g_exc_unexpected_error THEN
488: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_month || ' ' || SQLERRM(SQLCODE));
489: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || SQLERRM(SQLCODE));
490: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
491: fnd_message.set_token('ROW', l_api_name || ' ' ||
492: p_month || ' ' || p_org_id || ' '
493: || ' -- NO DATA FOUND -- ' );
494: fnd_msg_pub.add;

Line 491: fnd_message.set_token('ROW', l_api_name || ' ' ||

487: WHEN fnd_api.g_exc_unexpected_error THEN
488: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_month || ' ' || SQLERRM(SQLCODE));
489: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || SQLERRM(SQLCODE));
490: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
491: fnd_message.set_token('ROW', l_api_name || ' ' ||
492: p_month || ' ' || p_org_id || ' '
493: || ' -- NO DATA FOUND -- ' );
494: fnd_msg_pub.add;
495: RAISE;

Line 499: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

495: RAISE;
496:
497: WHEN OTHERS THEN
498: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_month || ' ' || SQLERRM(SQLCODE));
499: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
500: fnd_message.set_token('ROW', l_api_name || ' ' ||
501: p_month || ' ' || p_org_id || ' '
502: || SQLERRM||' ' ||SQLCODE);
503: fnd_msg_pub.add;

Line 500: fnd_message.set_token('ROW', l_api_name || ' ' ||

496:
497: WHEN OTHERS THEN
498: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_month || ' ' || SQLERRM(SQLCODE));
499: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
500: fnd_message.set_token('ROW', l_api_name || ' ' ||
501: p_month || ' ' || p_org_id || ' '
502: || SQLERRM||' ' ||SQLCODE);
503: fnd_msg_pub.add;
504: RAISE;

Line 555: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

551:
552: EXCEPTION
553: WHEN fnd_api.g_exc_unexpected_error THEN
554: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
555: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
556: fnd_message.set_token('ROW', l_api_name || ' ' ||
557: p_input_date || ' ' || p_org_id || ' '
558: || ' -- NO DATA FOUND -- ' );
559: fnd_msg_pub.add;

Line 556: fnd_message.set_token('ROW', l_api_name || ' ' ||

552: EXCEPTION
553: WHEN fnd_api.g_exc_unexpected_error THEN
554: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
555: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
556: fnd_message.set_token('ROW', l_api_name || ' ' ||
557: p_input_date || ' ' || p_org_id || ' '
558: || ' -- NO DATA FOUND -- ' );
559: fnd_msg_pub.add;
560: RAISE;

Line 564: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

560: RAISE;
561:
562: WHEN OTHERS THEN
563: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
564: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
565: fnd_message.set_token('ROW', l_api_name || ' ' ||
566: p_input_date || ' ' || p_org_id || ' '
567: || SQLERRM||' ' ||SQLCODE);
568: fnd_msg_pub.add;

Line 565: fnd_message.set_token('ROW', l_api_name || ' ' ||

561:
562: WHEN OTHERS THEN
563: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
564: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
565: fnd_message.set_token('ROW', l_api_name || ' ' ||
566: p_input_date || ' ' || p_org_id || ' '
567: || SQLERRM||' ' ||SQLCODE);
568: fnd_msg_pub.add;
569: RAISE;

Line 665: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

661:
662: EXCEPTION
663: WHEN fnd_api.g_exc_unexpected_error THEN
664: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
665: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
666: fnd_message.set_token('ROW', l_api_name || ' ' ||
667: p_input_date || ' ' || p_org_id || ' '
668: || ' -- NO DATA FOUND -- ' );
669: fnd_msg_pub.add;

Line 666: fnd_message.set_token('ROW', l_api_name || ' ' ||

662: EXCEPTION
663: WHEN fnd_api.g_exc_unexpected_error THEN
664: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
665: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
666: fnd_message.set_token('ROW', l_api_name || ' ' ||
667: p_input_date || ' ' || p_org_id || ' '
668: || ' -- NO DATA FOUND -- ' );
669: fnd_msg_pub.add;
670: RAISE;

Line 674: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

670: RAISE;
671:
672: WHEN OTHERS THEN
673: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
674: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
675: fnd_message.set_token('ROW', l_api_name || ' ' ||
676: p_input_date || ' ' || p_org_id || ' '
677: || SQLERRM||' ' ||SQLCODE);
678: fnd_msg_pub.add;

Line 675: fnd_message.set_token('ROW', l_api_name || ' ' ||

671:
672: WHEN OTHERS THEN
673: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
674: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
675: fnd_message.set_token('ROW', l_api_name || ' ' ||
676: p_input_date || ' ' || p_org_id || ' '
677: || SQLERRM||' ' ||SQLCODE);
678: fnd_msg_pub.add;
679: RAISE;

Line 715: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

711:
712: EXCEPTION
713: WHEN fnd_api.g_exc_unexpected_error THEN
714: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
715: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
716: fnd_message.set_token('ROW', l_api_name || ' ' ||
717: p_input_date || ' ' || p_org_id || ' '
718: || ' -- NO DATA FOUND -- ' );
719: fnd_msg_pub.add;

Line 716: fnd_message.set_token('ROW', l_api_name || ' ' ||

712: EXCEPTION
713: WHEN fnd_api.g_exc_unexpected_error THEN
714: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
715: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
716: fnd_message.set_token('ROW', l_api_name || ' ' ||
717: p_input_date || ' ' || p_org_id || ' '
718: || ' -- NO DATA FOUND -- ' );
719: fnd_msg_pub.add;
720: RAISE;

Line 724: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

720: RAISE;
721:
722: WHEN OTHERS THEN
723: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
724: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
725: fnd_message.set_token('ROW', l_api_name || ' ' ||
726: p_input_date || ' ' || p_org_id || ' '
727: || SQLERRM||' ' ||SQLCODE);
728: fnd_msg_pub.add;

Line 725: fnd_message.set_token('ROW', l_api_name || ' ' ||

721:
722: WHEN OTHERS THEN
723: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
724: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
725: fnd_message.set_token('ROW', l_api_name || ' ' ||
726: p_input_date || ' ' || p_org_id || ' '
727: || SQLERRM||' ' ||SQLCODE);
728: fnd_msg_pub.add;
729: RAISE;

Line 765: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

761:
762: EXCEPTION
763: WHEN fnd_api.g_exc_unexpected_error THEN
764: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
765: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
766: fnd_message.set_token('ROW', l_api_name || ' ' ||
767: p_input_date || ' ' || p_org_id || ' '
768: || ' -- NO DATA FOUND -- ' );
769: fnd_msg_pub.add;

Line 766: fnd_message.set_token('ROW', l_api_name || ' ' ||

762: EXCEPTION
763: WHEN fnd_api.g_exc_unexpected_error THEN
764: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
765: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
766: fnd_message.set_token('ROW', l_api_name || ' ' ||
767: p_input_date || ' ' || p_org_id || ' '
768: || ' -- NO DATA FOUND -- ' );
769: fnd_msg_pub.add;
770: RAISE;

Line 774: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

770: RAISE;
771:
772: WHEN OTHERS THEN
773: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
774: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
775: fnd_message.set_token('ROW', l_api_name || ' ' ||
776: p_input_date || ' ' || p_org_id || ' '
777: || SQLERRM||' ' ||SQLCODE);
778: fnd_msg_pub.add;

Line 775: fnd_message.set_token('ROW', l_api_name || ' ' ||

771:
772: WHEN OTHERS THEN
773: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
774: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
775: fnd_message.set_token('ROW', l_api_name || ' ' ||
776: p_input_date || ' ' || p_org_id || ' '
777: || SQLERRM||' ' ||SQLCODE);
778: fnd_msg_pub.add;
779: RAISE;

Line 842: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

838:
839: EXCEPTION
840: WHEN fnd_api.g_exc_unexpected_error THEN
841: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
842: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
843: fnd_message.set_token('ROW', l_api_name || ' ' ||
844: p_input_date || ' ' || p_org_id || ' '
845: || ' -- NO DATA FOUND -- ' );
846: fnd_msg_pub.add;

Line 843: fnd_message.set_token('ROW', l_api_name || ' ' ||

839: EXCEPTION
840: WHEN fnd_api.g_exc_unexpected_error THEN
841: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
842: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
843: fnd_message.set_token('ROW', l_api_name || ' ' ||
844: p_input_date || ' ' || p_org_id || ' '
845: || ' -- NO DATA FOUND -- ' );
846: fnd_msg_pub.add;
847: RAISE;

Line 851: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

847: RAISE;
848:
849: WHEN OTHERS THEN
850: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
851: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
852: fnd_message.set_token('ROW', l_api_name || ' ' ||
853: p_input_date || ' ' || p_org_id || ' '
854: || SQLERRM||' ' ||SQLCODE);
855: fnd_msg_pub.add;

Line 852: fnd_message.set_token('ROW', l_api_name || ' ' ||

848:
849: WHEN OTHERS THEN
850: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
851: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
852: fnd_message.set_token('ROW', l_api_name || ' ' ||
853: p_input_date || ' ' || p_org_id || ' '
854: || SQLERRM||' ' ||SQLCODE);
855: fnd_msg_pub.add;
856: RAISE;

Line 919: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

915:
916: EXCEPTION
917: WHEN fnd_api.g_exc_unexpected_error THEN
918: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
919: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
920: fnd_message.set_token('ROW', l_api_name || ' ' ||
921: p_input_date || ' ' || p_org_id || ' '
922: || ' -- NO DATA FOUND -- ' );
923: fnd_msg_pub.add;

Line 920: fnd_message.set_token('ROW', l_api_name || ' ' ||

916: EXCEPTION
917: WHEN fnd_api.g_exc_unexpected_error THEN
918: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
919: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
920: fnd_message.set_token('ROW', l_api_name || ' ' ||
921: p_input_date || ' ' || p_org_id || ' '
922: || ' -- NO DATA FOUND -- ' );
923: fnd_msg_pub.add;
924: RAISE;

Line 928: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

924: RAISE;
925:
926: WHEN OTHERS THEN
927: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
928: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
929: fnd_message.set_token('ROW', l_api_name || ' ' ||
930: p_input_date || ' ' || p_org_id || ' '
931: || SQLERRM||' ' ||SQLCODE);
932: fnd_msg_pub.add;

Line 929: fnd_message.set_token('ROW', l_api_name || ' ' ||

925:
926: WHEN OTHERS THEN
927: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
928: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
929: fnd_message.set_token('ROW', l_api_name || ' ' ||
930: p_input_date || ' ' || p_org_id || ' '
931: || SQLERRM||' ' ||SQLCODE);
932: fnd_msg_pub.add;
933: RAISE;

Line 998: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

994:
995: EXCEPTION
996: WHEN fnd_api.g_exc_unexpected_error THEN
997: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
998: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
999: fnd_message.set_token('ROW', l_api_name || ' ' ||
1000: p_input_date || ' ' || p_org_id || ' '
1001: || ' -- NO DATA FOUND -- ' );
1002: fnd_msg_pub.add;

Line 999: fnd_message.set_token('ROW', l_api_name || ' ' ||

995: EXCEPTION
996: WHEN fnd_api.g_exc_unexpected_error THEN
997: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
998: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
999: fnd_message.set_token('ROW', l_api_name || ' ' ||
1000: p_input_date || ' ' || p_org_id || ' '
1001: || ' -- NO DATA FOUND -- ' );
1002: fnd_msg_pub.add;
1003: RAISE;

Line 1007: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1003: RAISE;
1004:
1005: WHEN OTHERS THEN
1006: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1007: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1008: fnd_message.set_token('ROW', l_api_name || ' ' ||
1009: p_input_date || ' ' || p_org_id || ' '
1010: || SQLERRM||' ' ||SQLCODE);
1011: fnd_msg_pub.add;

Line 1008: fnd_message.set_token('ROW', l_api_name || ' ' ||

1004:
1005: WHEN OTHERS THEN
1006: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1007: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1008: fnd_message.set_token('ROW', l_api_name || ' ' ||
1009: p_input_date || ' ' || p_org_id || ' '
1010: || SQLERRM||' ' ||SQLCODE);
1011: fnd_msg_pub.add;
1012: RAISE;

Line 1040: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1036:
1037: EXCEPTION
1038: WHEN fnd_api.g_exc_unexpected_error THEN
1039: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1040: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1041: fnd_message.set_token('ROW', l_api_name || ' ' ||
1042: p_input_date || ' ' || p_org_id || ' '
1043: || ' -- NO DATA FOUND -- ' );
1044: fnd_msg_pub.add;

Line 1041: fnd_message.set_token('ROW', l_api_name || ' ' ||

1037: EXCEPTION
1038: WHEN fnd_api.g_exc_unexpected_error THEN
1039: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1040: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1041: fnd_message.set_token('ROW', l_api_name || ' ' ||
1042: p_input_date || ' ' || p_org_id || ' '
1043: || ' -- NO DATA FOUND -- ' );
1044: fnd_msg_pub.add;
1045: RAISE;

Line 1049: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1045: RAISE;
1046:
1047: WHEN OTHERS THEN
1048: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1049: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1050: fnd_message.set_token('ROW', l_api_name || ' ' ||
1051: p_input_date || ' ' || p_org_id || ' '
1052: || SQLERRM||' ' ||SQLCODE);
1053: fnd_msg_pub.add;

Line 1050: fnd_message.set_token('ROW', l_api_name || ' ' ||

1046:
1047: WHEN OTHERS THEN
1048: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1049: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1050: fnd_message.set_token('ROW', l_api_name || ' ' ||
1051: p_input_date || ' ' || p_org_id || ' '
1052: || SQLERRM||' ' ||SQLCODE);
1053: fnd_msg_pub.add;
1054: RAISE;

Line 1097: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1093:
1094: EXCEPTION
1095: WHEN fnd_api.g_exc_unexpected_error THEN
1096: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1097: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1098: fnd_message.set_token('ROW', l_api_name || ' ' ||
1099: p_input_date || ' ' || p_org_id || ' '
1100: || ' -- NO DATA FOUND -- ' );
1101: fnd_msg_pub.add;

Line 1098: fnd_message.set_token('ROW', l_api_name || ' ' ||

1094: EXCEPTION
1095: WHEN fnd_api.g_exc_unexpected_error THEN
1096: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1097: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1098: fnd_message.set_token('ROW', l_api_name || ' ' ||
1099: p_input_date || ' ' || p_org_id || ' '
1100: || ' -- NO DATA FOUND -- ' );
1101: fnd_msg_pub.add;
1102: RAISE;

Line 1106: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1102: RAISE;
1103:
1104: WHEN OTHERS THEN
1105: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1106: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1107: fnd_message.set_token('ROW', l_api_name || ' ' ||
1108: p_input_date || ' ' || p_org_id || ' '
1109: || SQLERRM||' ' ||SQLCODE);
1110: fnd_msg_pub.add;

Line 1107: fnd_message.set_token('ROW', l_api_name || ' ' ||

1103:
1104: WHEN OTHERS THEN
1105: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1106: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1107: fnd_message.set_token('ROW', l_api_name || ' ' ||
1108: p_input_date || ' ' || p_org_id || ' '
1109: || SQLERRM||' ' ||SQLCODE);
1110: fnd_msg_pub.add;
1111: RAISE;

Line 1148: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1144:
1145: EXCEPTION
1146: WHEN fnd_api.g_exc_unexpected_error THEN
1147: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1148: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1149: fnd_message.set_token('ROW', l_api_name || ' ' ||
1150: p_input_date || ' ' || p_org_id || ' '
1151: || ' -- NO DATA FOUND -- ' );
1152: fnd_msg_pub.add;

Line 1149: fnd_message.set_token('ROW', l_api_name || ' ' ||

1145: EXCEPTION
1146: WHEN fnd_api.g_exc_unexpected_error THEN
1147: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1148: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1149: fnd_message.set_token('ROW', l_api_name || ' ' ||
1150: p_input_date || ' ' || p_org_id || ' '
1151: || ' -- NO DATA FOUND -- ' );
1152: fnd_msg_pub.add;
1153: RAISE;

Line 1157: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1153: RAISE;
1154:
1155: WHEN OTHERS THEN
1156: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1157: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1158: fnd_message.set_token('ROW', l_api_name || ' ' ||
1159: p_input_date || ' ' || p_org_id || ' '
1160: || SQLERRM||' ' ||SQLCODE);
1161: fnd_msg_pub.add;

Line 1158: fnd_message.set_token('ROW', l_api_name || ' ' ||

1154:
1155: WHEN OTHERS THEN
1156: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1157: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1158: fnd_message.set_token('ROW', l_api_name || ' ' ||
1159: p_input_date || ' ' || p_org_id || ' '
1160: || SQLERRM||' ' ||SQLCODE);
1161: fnd_msg_pub.add;
1162: RAISE;

Line 1207: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1203:
1204: EXCEPTION
1205: WHEN fnd_api.g_exc_unexpected_error THEN
1206: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1207: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1208: fnd_message.set_token('ROW', l_api_name || ' ' ||
1209: p_input_date || ' ' || p_org_id || ' '
1210: || ' -- NO DATA FOUND -- ' );
1211: fnd_msg_pub.add;

Line 1208: fnd_message.set_token('ROW', l_api_name || ' ' ||

1204: EXCEPTION
1205: WHEN fnd_api.g_exc_unexpected_error THEN
1206: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1207: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1208: fnd_message.set_token('ROW', l_api_name || ' ' ||
1209: p_input_date || ' ' || p_org_id || ' '
1210: || ' -- NO DATA FOUND -- ' );
1211: fnd_msg_pub.add;
1212: RAISE;

Line 1246: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1242:
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_unexpected_error THEN
1245: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1246: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1247: fnd_message.set_token('ROW', l_api_name || ' ' ||
1248: p_input_date || ' ' || p_org_id || ' '
1249: || ' -- NO DATA FOUND -- ' );
1250: fnd_msg_pub.add;

Line 1247: fnd_message.set_token('ROW', l_api_name || ' ' ||

1243: EXCEPTION
1244: WHEN fnd_api.g_exc_unexpected_error THEN
1245: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1246: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1247: fnd_message.set_token('ROW', l_api_name || ' ' ||
1248: p_input_date || ' ' || p_org_id || ' '
1249: || ' -- NO DATA FOUND -- ' );
1250: fnd_msg_pub.add;
1251: RAISE;

Line 1255: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1251: RAISE;
1252:
1253: WHEN OTHERS THEN
1254: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1255: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1256: fnd_message.set_token('ROW', l_api_name || ' ' ||
1257: p_input_date || ' ' || p_org_id || ' '
1258: || SQLERRM||' ' ||SQLCODE);
1259: fnd_msg_pub.add;

Line 1256: fnd_message.set_token('ROW', l_api_name || ' ' ||

1252:
1253: WHEN OTHERS THEN
1254: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1255: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1256: fnd_message.set_token('ROW', l_api_name || ' ' ||
1257: p_input_date || ' ' || p_org_id || ' '
1258: || SQLERRM||' ' ||SQLCODE);
1259: fnd_msg_pub.add;
1260: RAISE;

Line 1304: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1300:
1301: EXCEPTION
1302: WHEN fnd_api.g_exc_unexpected_error THEN
1303: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1304: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1305: fnd_message.set_token('ROW', l_api_name || ' ' ||
1306: p_input_date || ' ' || p_org_id || ' '
1307: || ' -- NO DATA FOUND -- ' );
1308: fnd_msg_pub.add;

Line 1305: fnd_message.set_token('ROW', l_api_name || ' ' ||

1301: EXCEPTION
1302: WHEN fnd_api.g_exc_unexpected_error THEN
1303: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1304: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1305: fnd_message.set_token('ROW', l_api_name || ' ' ||
1306: p_input_date || ' ' || p_org_id || ' '
1307: || ' -- NO DATA FOUND -- ' );
1308: fnd_msg_pub.add;
1309: RAISE;

Line 1313: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1309: RAISE;
1310:
1311: WHEN OTHERS THEN
1312: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1313: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1314: fnd_message.set_token('ROW', l_api_name || ' ' ||
1315: p_input_date || ' ' || p_org_id || ' '
1316: || SQLERRM||' ' ||SQLCODE);
1317: fnd_msg_pub.add;

Line 1314: fnd_message.set_token('ROW', l_api_name || ' ' ||

1310:
1311: WHEN OTHERS THEN
1312: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1313: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1314: fnd_message.set_token('ROW', l_api_name || ' ' ||
1315: p_input_date || ' ' || p_org_id || ' '
1316: || SQLERRM||' ' ||SQLCODE);
1317: fnd_msg_pub.add;
1318: RAISE;

Line 1381: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1377:
1378: EXCEPTION
1379: WHEN fnd_api.g_exc_unexpected_error THEN
1380: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1381: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1382: fnd_message.set_token('ROW', l_api_name || ' ' ||
1383: p_input_date || ' ' || p_org_id || ' '
1384: || ' -- NO DATA FOUND -- ' );
1385: fnd_msg_pub.add;

Line 1382: fnd_message.set_token('ROW', l_api_name || ' ' ||

1378: EXCEPTION
1379: WHEN fnd_api.g_exc_unexpected_error THEN
1380: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1381: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1382: fnd_message.set_token('ROW', l_api_name || ' ' ||
1383: p_input_date || ' ' || p_org_id || ' '
1384: || ' -- NO DATA FOUND -- ' );
1385: fnd_msg_pub.add;
1386: RAISE;

Line 1390: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1386: RAISE;
1387:
1388: WHEN OTHERS THEN
1389: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1390: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1391: fnd_message.set_token('ROW', l_api_name || ' ' ||
1392: p_input_date || ' ' || p_org_id || ' '
1393: || SQLERRM||' ' ||SQLCODE);
1394: fnd_msg_pub.add;

Line 1391: fnd_message.set_token('ROW', l_api_name || ' ' ||

1387:
1388: WHEN OTHERS THEN
1389: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1390: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1391: fnd_message.set_token('ROW', l_api_name || ' ' ||
1392: p_input_date || ' ' || p_org_id || ' '
1393: || SQLERRM||' ' ||SQLCODE);
1394: fnd_msg_pub.add;
1395: RAISE;

Line 1458: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1454:
1455: EXCEPTION
1456: WHEN fnd_api.g_exc_unexpected_error THEN
1457: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1458: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1459: fnd_message.set_token('ROW', l_api_name || ' ' ||
1460: p_input_date || ' ' || p_org_id || ' '
1461: || ' -- NO DATA FOUND -- ' );
1462: fnd_msg_pub.add;

Line 1459: fnd_message.set_token('ROW', l_api_name || ' ' ||

1455: EXCEPTION
1456: WHEN fnd_api.g_exc_unexpected_error THEN
1457: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1458: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1459: fnd_message.set_token('ROW', l_api_name || ' ' ||
1460: p_input_date || ' ' || p_org_id || ' '
1461: || ' -- NO DATA FOUND -- ' );
1462: fnd_msg_pub.add;
1463: RAISE;

Line 1467: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1463: RAISE;
1464:
1465: WHEN OTHERS THEN
1466: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1467: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1468: fnd_message.set_token('ROW', l_api_name || ' ' ||
1469: p_input_date || ' ' || p_org_id || ' '
1470: || SQLERRM||' ' ||SQLCODE);
1471: fnd_msg_pub.add;

Line 1468: fnd_message.set_token('ROW', l_api_name || ' ' ||

1464:
1465: WHEN OTHERS THEN
1466: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1467: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1468: fnd_message.set_token('ROW', l_api_name || ' ' ||
1469: p_input_date || ' ' || p_org_id || ' '
1470: || SQLERRM||' ' ||SQLCODE);
1471: fnd_msg_pub.add;
1472: RAISE;

Line 1535: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1531:
1532: EXCEPTION
1533: WHEN fnd_api.g_exc_unexpected_error THEN
1534: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1535: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1536: fnd_message.set_token('ROW', l_api_name || ' ' ||
1537: p_input_date || ' ' || p_org_id || ' '
1538: || ' -- NO DATA FOUND -- ' );
1539: fnd_msg_pub.add;

Line 1536: fnd_message.set_token('ROW', l_api_name || ' ' ||

1532: EXCEPTION
1533: WHEN fnd_api.g_exc_unexpected_error THEN
1534: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1535: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1536: fnd_message.set_token('ROW', l_api_name || ' ' ||
1537: p_input_date || ' ' || p_org_id || ' '
1538: || ' -- NO DATA FOUND -- ' );
1539: fnd_msg_pub.add;
1540: RAISE;

Line 1544: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1540: RAISE;
1541:
1542: WHEN OTHERS THEN
1543: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1544: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1545: fnd_message.set_token('ROW', l_api_name || ' ' ||
1546: p_input_date || ' ' || p_org_id || ' '
1547: || SQLERRM||' ' ||SQLCODE);
1548: fnd_msg_pub.add;

Line 1545: fnd_message.set_token('ROW', l_api_name || ' ' ||

1541:
1542: WHEN OTHERS THEN
1543: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
1544: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1545: fnd_message.set_token('ROW', l_api_name || ' ' ||
1546: p_input_date || ' ' || p_org_id || ' '
1547: || SQLERRM||' ' ||SQLCODE);
1548: fnd_msg_pub.add;
1549: RAISE;

Line 1618: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1614:
1615: EXCEPTION
1616: WHEN fnd_api.g_exc_unexpected_error THEN
1617: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1618: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1619: fnd_message.set_token('ROW', l_api_name || ' ' ||
1620: p_period_name || ' ' || p_org_id || ' '
1621: || ' -- NO DATA FOUND -- ' );
1622: fnd_msg_pub.add;

Line 1619: fnd_message.set_token('ROW', l_api_name || ' ' ||

1615: EXCEPTION
1616: WHEN fnd_api.g_exc_unexpected_error THEN
1617: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1618: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1619: fnd_message.set_token('ROW', l_api_name || ' ' ||
1620: p_period_name || ' ' || p_org_id || ' '
1621: || ' -- NO DATA FOUND -- ' );
1622: fnd_msg_pub.add;
1623: RAISE;

Line 1627: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1623: RAISE;
1624:
1625: WHEN OTHERS THEN
1626: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1627: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1628: fnd_message.set_token('ROW', l_api_name || ' ' ||
1629: p_period_name || ' ' || p_org_id || ' '
1630: || SQLERRM||' ' ||SQLCODE);
1631: fnd_msg_pub.add;

Line 1628: fnd_message.set_token('ROW', l_api_name || ' ' ||

1624:
1625: WHEN OTHERS THEN
1626: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1627: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1628: fnd_message.set_token('ROW', l_api_name || ' ' ||
1629: p_period_name || ' ' || p_org_id || ' '
1630: || SQLERRM||' ' ||SQLCODE);
1631: fnd_msg_pub.add;
1632: RAISE;

Line 1701: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1697:
1698: EXCEPTION
1699: WHEN fnd_api.g_exc_unexpected_error THEN
1700: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1701: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1702: fnd_message.set_token('ROW', l_api_name || ' ' ||
1703: p_period_name || ' ' || p_org_id || ' '
1704: || ' -- NO DATA FOUND -- ' );
1705: fnd_msg_pub.add;

Line 1702: fnd_message.set_token('ROW', l_api_name || ' ' ||

1698: EXCEPTION
1699: WHEN fnd_api.g_exc_unexpected_error THEN
1700: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1701: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1702: fnd_message.set_token('ROW', l_api_name || ' ' ||
1703: p_period_name || ' ' || p_org_id || ' '
1704: || ' -- NO DATA FOUND -- ' );
1705: fnd_msg_pub.add;
1706: RAISE;

Line 1710: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1706: RAISE;
1707:
1708: WHEN OTHERS THEN
1709: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1710: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1711: fnd_message.set_token('ROW', l_api_name || ' ' ||
1712: p_period_name || ' ' || p_org_id || ' '
1713: || SQLERRM||' ' ||SQLCODE);
1714: fnd_msg_pub.add;

Line 1711: fnd_message.set_token('ROW', l_api_name || ' ' ||

1707:
1708: WHEN OTHERS THEN
1709: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1710: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1711: fnd_message.set_token('ROW', l_api_name || ' ' ||
1712: p_period_name || ' ' || p_org_id || ' '
1713: || SQLERRM||' ' ||SQLCODE);
1714: fnd_msg_pub.add;
1715: RAISE;

Line 1784: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1780:
1781: EXCEPTION
1782: WHEN fnd_api.g_exc_unexpected_error THEN
1783: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1784: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1785: fnd_message.set_token('ROW', l_api_name || ' ' ||
1786: p_period_name || ' ' || p_org_id || ' '
1787: || ' -- NO DATA FOUND -- ' );
1788: fnd_msg_pub.add;

Line 1785: fnd_message.set_token('ROW', l_api_name || ' ' ||

1781: EXCEPTION
1782: WHEN fnd_api.g_exc_unexpected_error THEN
1783: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1784: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1785: fnd_message.set_token('ROW', l_api_name || ' ' ||
1786: p_period_name || ' ' || p_org_id || ' '
1787: || ' -- NO DATA FOUND -- ' );
1788: fnd_msg_pub.add;
1789: RAISE;

Line 1793: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

1789: RAISE;
1790:
1791: WHEN OTHERS THEN
1792: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1793: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1794: fnd_message.set_token('ROW', l_api_name || ' ' ||
1795: p_period_name || ' ' || p_org_id || ' '
1796: || SQLERRM||' ' ||SQLCODE);
1797: fnd_msg_pub.add;

Line 1794: fnd_message.set_token('ROW', l_api_name || ' ' ||

1790:
1791: WHEN OTHERS THEN
1792: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));
1793: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');
1794: fnd_message.set_token('ROW', l_api_name || ' ' ||
1795: p_period_name || ' ' || p_org_id || ' '
1796: || SQLERRM||' ' ||SQLCODE);
1797: fnd_msg_pub.add;
1798: RAISE;