eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_SET_OF_BOOKS dependencies on FND_FILE

Line 106: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

102: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
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 -- ' );

Line 115: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

111: fnd_msg_pub.add;
112: RAISE;
113:
114: WHEN OTHERS THEN
115: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));
116: RAISE;
117:
118: END GET_FISCAL_DATA;
119:

Line 168: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

164: RETURN(l_month);
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 -- ' );

Line 177: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

173: fnd_msg_pub.add;
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);

Line 294: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

290: RETURN(l_year);
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 -- ' );

Line 303: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

299: fnd_msg_pub.add;
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);

Line 359: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

355: RETURN(l_period_num);
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 -- ' );

Line 368: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

364: fnd_msg_pub.add;
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);

Line 425: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_name || ' ' || SQLERRM(SQLCODE));

421: RETURN(l_name);
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 -- ' );

Line 434: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_name || ' ' || SQLERRM(SQLCODE));

430: fnd_msg_pub.add;
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);

Line 488: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_month || ' ' || SQLERRM(SQLCODE));

484: RETURN(l_period_num);
485:
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 || ' '

Line 489: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || SQLERRM(SQLCODE));

485:
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 -- ' );

Line 498: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_month || ' ' || SQLERRM(SQLCODE));

494: fnd_msg_pub.add;
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);

Line 554: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

550: RETURN(l_period_num);
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 -- ' );

Line 563: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

559: fnd_msg_pub.add;
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);

Line 664: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

660: RETURN(l_date);
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 -- ' );

Line 673: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

669: fnd_msg_pub.add;
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);

Line 714: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

710: RETURN(l_date);
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 -- ' );

Line 723: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

719: fnd_msg_pub.add;
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);

Line 764: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

760: RETURN(l_date);
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 -- ' );

Line 773: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

769: fnd_msg_pub.add;
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);

Line 841: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

837: RETURN(l_date);
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 -- ' );

Line 850: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

846: fnd_msg_pub.add;
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);

Line 918: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

914: RETURN(l_date);
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 -- ' );

Line 927: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

923: fnd_msg_pub.add;
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);

Line 997: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

993: RETURN(l_date);
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 -- ' );

Line 1006: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1002: fnd_msg_pub.add;
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);

Line 1039: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1035: RETURN(l_previous_fiscal_qtr_start);
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 -- ' );

Line 1048: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1044: fnd_msg_pub.add;
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);

Line 1096: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1092: RETURN(l_previous_fiscal_qtr_end);
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 -- ' );

Line 1105: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1101: fnd_msg_pub.add;
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);

Line 1147: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1143: RETURN(l_previous_fiscal_year_start);
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 -- ' );

Line 1156: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1152: fnd_msg_pub.add;
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);

Line 1206: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1202: RETURN(l_previous_fiscal_year_end);
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 -- ' );

Line 1245: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1241: RETURN(l_date);
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 -- ' );

Line 1254: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1250: fnd_msg_pub.add;
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);

Line 1303: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1299: RETURN(l_date);
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 -- ' );

Line 1312: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1308: fnd_msg_pub.add;
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);

Line 1380: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1376: RETURN(l_date);
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 -- ' );

Line 1389: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1385: fnd_msg_pub.add;
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);

Line 1457: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1453: RETURN(l_date);
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 -- ' );

Line 1466: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1462: fnd_msg_pub.add;
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);

Line 1534: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1530: RETURN(l_date);
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 -- ' );

Line 1543: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

1539: fnd_msg_pub.add;
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);

Line 1617: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

1613: RETURN(l_period_name);
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 -- ' );

Line 1626: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

1622: fnd_msg_pub.add;
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);

Line 1700: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

1696: RETURN(l_period_name);
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 -- ' );

Line 1709: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

1705: fnd_msg_pub.add;
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);

Line 1783: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

1779: RETURN(l_period_name);
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 -- ' );

Line 1792: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

1788: fnd_msg_pub.add;
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);