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_API

Line 73: RAISE fnd_api.g_exc_unexpected_error;

69: FETCH period_month INTO x_month, x_month_num;
70:
71: IF period_month%NOTFOUND THEN
72: CLOSE period_month;
73: RAISE fnd_api.g_exc_unexpected_error;
74: END IF;
75:
76: CLOSE period_month;
77:

Line 83: RAISE fnd_api.g_exc_unexpected_error;

79: FETCH period_quarter INTO x_quarter, x_quarter_num;
80:
81: IF period_quarter%NOTFOUND THEN
82: CLOSE period_quarter;
83: RAISE fnd_api.g_exc_unexpected_error;
84: END IF;
85:
86: CLOSE period_quarter;
87:

Line 93: RAISE fnd_api.g_exc_unexpected_error;

89: FETCH period_year INTO x_year;
90:
91: IF period_year%NOTFOUND THEN
92: CLOSE period_year;
93: RAISE fnd_api.g_exc_unexpected_error;
94: END IF;
95:
96: CLOSE period_year;
97:

Line 105: WHEN fnd_api.g_exc_unexpected_error THEN

101:
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 || ' '

Line 155: RAISE fnd_api.g_exc_unexpected_error;

151: FETCH period_info INTO l_month;
152:
153: IF period_info%NOTFOUND THEN
154: CLOSE period_info;
155: RAISE fnd_api.g_exc_unexpected_error;
156: END IF;
157:
158: CLOSE period_info;
159:

Line 167: WHEN fnd_api.g_exc_unexpected_error THEN

163:
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 || ' '

Line 218: RAISE fnd_api.g_exc_unexpected_error;

214: FETCH period_info INTO l_qtr;
215:
216: IF period_info%NOTFOUND THEN
217: CLOSE period_info;
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:
221: CLOSE period_info;
222:

Line 230: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 281: RAISE fnd_api.g_exc_unexpected_error;

277: FETCH period_info INTO l_year;
278:
279: IF period_info%NOTFOUND THEN
280: CLOSE period_info;
281: RAISE fnd_api.g_exc_unexpected_error;
282: END IF;
283:
284: CLOSE period_info;
285:

Line 293: WHEN fnd_api.g_exc_unexpected_error THEN

289:
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 || ' '

Line 346: RAISE fnd_api.g_exc_unexpected_error;

342: FETCH period_info INTO l_period_num;
343:
344: IF period_info%NOTFOUND THEN
345: CLOSE period_info;
346: RAISE fnd_api.g_exc_unexpected_error;
347: END IF;
348:
349: CLOSE period_info;
350:

Line 358: WHEN fnd_api.g_exc_unexpected_error THEN

354:
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 || ' '

Line 412: RAISE fnd_api.g_exc_unexpected_error;

408: FETCH period_name INTO l_name;
409:
410: IF period_name%NOTFOUND THEN
411: CLOSE period_name;
412: RAISE fnd_api.g_exc_unexpected_error;
413: END IF;
414:
415: CLOSE period_name;
416:

Line 424: WHEN fnd_api.g_exc_unexpected_error THEN

420:
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 || ' '

Line 475: RAISE fnd_api.g_exc_unexpected_error;

471: FETCH period_info INTO l_period_num;
472:
473: IF period_info%NOTFOUND THEN
474: CLOSE period_info;
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;
477:
478: CLOSE period_info;
479:

Line 487: WHEN fnd_api.g_exc_unexpected_error THEN

483:
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 || ' ' ||

Line 541: RAISE fnd_api.g_exc_unexpected_error;

537: FETCH period_info INTO l_period_num;
538:
539: IF period_info%NOTFOUND THEN
540: CLOSE period_info;
541: RAISE fnd_api.g_exc_unexpected_error;
542: END IF;
543:
544: CLOSE period_info;
545:

Line 553: WHEN fnd_api.g_exc_unexpected_error THEN

549:
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 || ' '

Line 619: RAISE fnd_api.g_exc_unexpected_error;

615: FETCH period_info INTO l_date;
616:
617: IF period_info%NOTFOUND THEN
618: CLOSE period_info;
619: RAISE fnd_api.g_exc_unexpected_error;
620: END IF;
621:
622: CLOSE period_info;
623:

Line 629: RAISE fnd_api.g_exc_unexpected_error;

625: FETCH period_info INTO l_date;
626:
627: IF period_info%NOTFOUND THEN
628: CLOSE period_info;
629: RAISE fnd_api.g_exc_unexpected_error;
630: END IF;
631:
632: CLOSE period_info;
633:

Line 639: RAISE fnd_api.g_exc_unexpected_error;

635: FETCH period_info INTO l_date;
636:
637: IF period_info%NOTFOUND THEN
638: CLOSE period_info;
639: RAISE fnd_api.g_exc_unexpected_error;
640: END IF;
641:
642: CLOSE period_info;
643:

Line 649: RAISE fnd_api.g_exc_unexpected_error;

645: FETCH period_info INTO l_date;
646:
647: IF period_info%NOTFOUND THEN
648: CLOSE period_info;
649: RAISE fnd_api.g_exc_unexpected_error;
650: END IF;
651:
652: CLOSE period_info;
653:

Line 663: WHEN fnd_api.g_exc_unexpected_error THEN

659:
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 || ' '

Line 713: WHEN fnd_api.g_exc_unexpected_error THEN

709: l_date := get_fiscal_roll_year_start(l_date, p_org_id);
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 || ' '

Line 763: WHEN fnd_api.g_exc_unexpected_error THEN

759: l_date :=l_date +l_delta;
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 || ' '

Line 828: RAISE fnd_api.g_exc_unexpected_error;

824: FETCH period_info INTO l_date;
825:
826: IF period_info%NOTFOUND THEN
827: CLOSE period_info;
828: RAISE fnd_api.g_exc_unexpected_error;
829: END IF;
830:
831: CLOSE period_info;
832:

Line 840: WHEN fnd_api.g_exc_unexpected_error THEN

836:
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 || ' '

Line 905: RAISE fnd_api.g_exc_unexpected_error;

901: FETCH period_info INTO l_date;
902:
903: IF period_info%NOTFOUND THEN
904: CLOSE period_info;
905: RAISE fnd_api.g_exc_unexpected_error;
906: END IF;
907:
908: CLOSE period_info;
909:

Line 917: WHEN fnd_api.g_exc_unexpected_error THEN

913:
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 || ' '

Line 984: RAISE fnd_api.g_exc_unexpected_error;

980: FETCH period_info INTO l_date;
981:
982: IF period_info%NOTFOUND THEN
983: CLOSE period_info;
984: RAISE fnd_api.g_exc_unexpected_error;
985: END IF;
986:
987: CLOSE period_info;
988:

Line 996: WHEN fnd_api.g_exc_unexpected_error THEN

992:
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 || ' '

Line 1038: WHEN fnd_api.g_exc_unexpected_error THEN

1034:
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 || ' '

Line 1095: WHEN fnd_api.g_exc_unexpected_error THEN

1091:
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 || ' '

Line 1146: WHEN fnd_api.g_exc_unexpected_error THEN

1142:
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 || ' '

Line 1205: WHEN fnd_api.g_exc_unexpected_error THEN

1201:
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 || ' '

Line 1244: WHEN fnd_api.g_exc_unexpected_error THEN

1240: l_date := get_fiscal_month_start(l_date, p_org_id);
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 || ' '

Line 1302: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 1367: RAISE fnd_api.g_exc_unexpected_error;

1363: FETCH period_info INTO l_date;
1364:
1365: IF period_info%NOTFOUND THEN
1366: CLOSE period_info;
1367: RAISE fnd_api.g_exc_unexpected_error;
1368: END IF;
1369:
1370: CLOSE period_info;
1371:

Line 1379: WHEN fnd_api.g_exc_unexpected_error THEN

1375:
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 || ' '

Line 1444: RAISE fnd_api.g_exc_unexpected_error;

1440: FETCH period_info INTO l_date;
1441:
1442: IF period_info%NOTFOUND THEN
1443: CLOSE period_info;
1444: RAISE fnd_api.g_exc_unexpected_error;
1445: END IF;
1446:
1447: CLOSE period_info;
1448:

Line 1456: WHEN fnd_api.g_exc_unexpected_error THEN

1452:
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 || ' '

Line 1521: RAISE fnd_api.g_exc_unexpected_error;

1517: FETCH period_info INTO l_date;
1518:
1519: IF period_info%NOTFOUND THEN
1520: CLOSE period_info;
1521: RAISE fnd_api.g_exc_unexpected_error;
1522: END IF;
1523:
1524: CLOSE period_info;
1525:

Line 1533: WHEN fnd_api.g_exc_unexpected_error THEN

1529:
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 || ' '

Line 1594: RAISE fnd_api.g_exc_unexpected_error;

1590: FETCH cur_period_date INTO l_period_date;
1591:
1592: IF cur_period_date%NOTFOUND THEN
1593: CLOSE cur_period_date;
1594: RAISE fnd_api.g_exc_unexpected_error;
1595: END IF;
1596:
1597: CLOSE cur_period_date;
1598:

Line 1604: RAISE fnd_api.g_exc_unexpected_error;

1600: FETCH cur_period_name INTO l_period_name;
1601:
1602: IF cur_period_name%NOTFOUND THEN
1603: CLOSE cur_period_name;
1604: RAISE fnd_api.g_exc_unexpected_error;
1605: END IF;
1606:
1607: CLOSE cur_period_name;
1608:

Line 1616: WHEN fnd_api.g_exc_unexpected_error THEN

1612:
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 || ' '

Line 1677: RAISE fnd_api.g_exc_unexpected_error;

1673: FETCH cur_period_date INTO l_period_date;
1674:
1675: IF cur_period_date%NOTFOUND THEN
1676: CLOSE cur_period_date;
1677: RAISE fnd_api.g_exc_unexpected_error;
1678: END IF;
1679:
1680: CLOSE cur_period_date;
1681:

Line 1687: RAISE fnd_api.g_exc_unexpected_error;

1683: FETCH cur_period_name INTO l_period_name;
1684:
1685: IF cur_period_name%NOTFOUND THEN
1686: CLOSE cur_period_name;
1687: RAISE fnd_api.g_exc_unexpected_error;
1688: END IF;
1689:
1690: CLOSE cur_period_name;
1691:

Line 1699: WHEN fnd_api.g_exc_unexpected_error THEN

1695:
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 || ' '

Line 1760: RAISE fnd_api.g_exc_unexpected_error;

1756: FETCH cur_period_date INTO l_period_date;
1757:
1758: IF cur_period_date%NOTFOUND THEN
1759: CLOSE cur_period_date;
1760: RAISE fnd_api.g_exc_unexpected_error;
1761: END IF;
1762:
1763: CLOSE cur_period_date;
1764:

Line 1770: RAISE fnd_api.g_exc_unexpected_error;

1766: FETCH cur_period_name INTO l_period_name;
1767:
1768: IF cur_period_name%NOTFOUND THEN
1769: CLOSE cur_period_name;
1770: RAISE fnd_api.g_exc_unexpected_error;
1771: END IF;
1772:
1773: CLOSE cur_period_name;
1774:

Line 1782: WHEN fnd_api.g_exc_unexpected_error THEN

1778:
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 || ' '