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_MSG_PUB

Line 111: fnd_msg_pub.add;

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;
113:
114: WHEN OTHERS THEN
115: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 173: fnd_msg_pub.add;

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;
175:
176: WHEN OTHERS THEN
177: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 182: fnd_msg_pub.add;

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;
184:
185: END GET_FISCAL_MONTH;
186: -------------------------------------------------------------------------------

Line 235: fnd_msg_pub.add;

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;
237:
238: WHEN OTHERS THEN
239: fnd_message.set_name('AMS', 'API_DEBUG_MESSAGE');

Line 243: fnd_msg_pub.add;

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;
245:
246: END GET_FISCAL_QTR;
247: -------------------------------------------------------------------------------

Line 299: fnd_msg_pub.add;

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;
301:
302: WHEN OTHERS THEN
303: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 308: fnd_msg_pub.add;

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;
310:
311: END GET_FISCAL_YEAR;
312: -------------------------------------------------------------------------------

Line 364: fnd_msg_pub.add;

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;
366:
367: WHEN OTHERS THEN
368: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 373: fnd_msg_pub.add;

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;
375:
376: END GET_FISCAL_QTR_NUM;
377: -------------------------------------------------------------------------------

Line 430: fnd_msg_pub.add;

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;
432:
433: WHEN OTHERS THEN
434: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_name || ' ' || SQLERRM(SQLCODE));

Line 439: fnd_msg_pub.add;

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;
441:
442: END GET_PRE_PERIOD;
443: -------------------------------------------------------------------------------

Line 494: fnd_msg_pub.add;

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;
496:
497: WHEN OTHERS THEN
498: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_month || ' ' || SQLERRM(SQLCODE));

Line 503: fnd_msg_pub.add;

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;
505:
506: END GET_MONTH_ORDER;
507: -------------------------------------------------------------------------------

Line 559: fnd_msg_pub.add;

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;
561:
562: WHEN OTHERS THEN
563: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 568: fnd_msg_pub.add;

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;
570:
571: END GET_FISCAL_MONTH_NUM;
572: -------------------------------------------------------------------------------

Line 669: fnd_msg_pub.add;

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;
671:
672: WHEN OTHERS THEN
673: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 678: fnd_msg_pub.add;

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;
680:
681: END GET_FISCAL_ROLL_YEAR_START;
682:

Line 719: fnd_msg_pub.add;

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;
721:
722: WHEN OTHERS THEN
723: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 728: fnd_msg_pub.add;

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;
730:
731: END GET_PRE_FISCAL_ROLL_YEAR_START;
732:

Line 769: fnd_msg_pub.add;

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;
771:
772: WHEN OTHERS THEN
773: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 778: fnd_msg_pub.add;

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;
780:
781: END GET_PRE_FISCAL_ROLL_YEAR_END;
782: -------------------------------------------------------------------------------

Line 846: fnd_msg_pub.add;

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;
848:
849: WHEN OTHERS THEN
850: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 855: fnd_msg_pub.add;

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;
857:
858: END GET_FISCAL_YEAR_START;
859: -------------------------------------------------------------------------------

Line 923: fnd_msg_pub.add;

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;
925:
926: WHEN OTHERS THEN
927: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 932: fnd_msg_pub.add;

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;
934:
935: END GET_FISCAL_QTR_START;
936:

Line 1002: fnd_msg_pub.add;

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;
1004:
1005: WHEN OTHERS THEN
1006: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1011: fnd_msg_pub.add;

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;
1013:
1014: END GET_FISCAL_MONTH_START;
1015:

Line 1044: fnd_msg_pub.add;

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;
1046:
1047: WHEN OTHERS THEN
1048: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1053: fnd_msg_pub.add;

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;
1055:
1056: END GET_PRE_FISCAL_QTR_START;
1057:

Line 1101: fnd_msg_pub.add;

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;
1103:
1104: WHEN OTHERS THEN
1105: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1110: fnd_msg_pub.add;

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;
1112:
1113: END GET_PRE_FISCAL_QTR_END;
1114:

Line 1152: fnd_msg_pub.add;

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;
1154:
1155: WHEN OTHERS THEN
1156: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1161: fnd_msg_pub.add;

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;
1163:
1164: END GET_PRE_FISCAL_YEAR_START;
1165:

Line 1211: fnd_msg_pub.add;

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;
1213:
1214: END GET_PRE_FISCAL_YEAR_END;
1215:

Line 1250: fnd_msg_pub.add;

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;
1252:
1253: WHEN OTHERS THEN
1254: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1259: fnd_msg_pub.add;

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;
1261:
1262: END GET_PRE_FISCAL_MONTH_START;
1263:

Line 1308: fnd_msg_pub.add;

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;
1310:
1311: WHEN OTHERS THEN
1312: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1317: fnd_msg_pub.add;

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;
1319:
1320: END GET_PRE_FISCAL_MONTH_END;
1321: -------------------------------------------------------------------------------

Line 1385: fnd_msg_pub.add;

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;
1387:
1388: WHEN OTHERS THEN
1389: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1394: fnd_msg_pub.add;

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;
1396:
1397: END GET_FISCAL_MONTH_END;
1398: -------------------------------------------------------------------------------

Line 1462: fnd_msg_pub.add;

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;
1464:
1465: WHEN OTHERS THEN
1466: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1471: fnd_msg_pub.add;

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;
1473:
1474: END GET_FISCAL_QTR_END;
1475: -------------------------------------------------------------------------------

Line 1539: fnd_msg_pub.add;

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;
1541:
1542: WHEN OTHERS THEN
1543: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_input_date || ' ' || SQLERRM(SQLCODE));

Line 1548: fnd_msg_pub.add;

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;
1550:
1551: END GET_FISCAL_YEAR_END;
1552: -------------------------------------------------------------------------------

Line 1622: fnd_msg_pub.add;

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;
1624:
1625: WHEN OTHERS THEN
1626: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

Line 1631: fnd_msg_pub.add;

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;
1633:
1634: END GET_QTR_FROM_MONTH;
1635: -------------------------------------------------------------------------------

Line 1705: fnd_msg_pub.add;

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;
1707:
1708: WHEN OTHERS THEN
1709: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

Line 1714: fnd_msg_pub.add;

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;
1716:
1717: END GET_YEAR_FROM_MONTH;
1718: -------------------------------------------------------------------------------

Line 1788: fnd_msg_pub.add;

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;
1790:
1791: WHEN OTHERS THEN
1792: fnd_file.put_line(fnd_file.log,'ERROR-' || l_api_name || ' ' || p_period_name || ' ' || SQLERRM(SQLCODE));

Line 1797: fnd_msg_pub.add;

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;
1799:
1800: END GET_YEAR_FROM_QTR;
1801: END BIM_SET_OF_BOOKS;