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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;