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 AMS_UTILITY_PVT

Line 67: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

63: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
64:
65: BEGIN
66:
67: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
68: OPEN period_month;
69: FETCH period_month INTO x_month, x_month_num;
70:
71: IF period_month%NOTFOUND THEN

Line 98: --ams_utility_pvt.debug_message('fiscal year --' || x_year);

94: END IF;
95:
96: CLOSE period_year;
97:
98: --ams_utility_pvt.debug_message('fiscal year --' || x_year);
99: --ams_utility_pvt.debug_message('fiscal quarter --' || x_quarter);
100: --ams_utility_pvt.debug_message('fiscal month --' || x_month);
101:
102: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

Line 99: --ams_utility_pvt.debug_message('fiscal quarter --' || x_quarter);

95:
96: CLOSE period_year;
97:
98: --ams_utility_pvt.debug_message('fiscal year --' || x_year);
99: --ams_utility_pvt.debug_message('fiscal quarter --' || x_quarter);
100: --ams_utility_pvt.debug_message('fiscal month --' || x_month);
101:
102: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
103:

Line 100: --ams_utility_pvt.debug_message('fiscal month --' || x_month);

96: CLOSE period_year;
97:
98: --ams_utility_pvt.debug_message('fiscal year --' || x_year);
99: --ams_utility_pvt.debug_message('fiscal quarter --' || x_quarter);
100: --ams_utility_pvt.debug_message('fiscal month --' || x_month);
101:
102: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
103:
104: EXCEPTION

Line 102: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

98: --ams_utility_pvt.debug_message('fiscal year --' || x_year);
99: --ams_utility_pvt.debug_message('fiscal quarter --' || x_quarter);
100: --ams_utility_pvt.debug_message('fiscal month --' || x_month);
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));

Line 149: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

145: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
146:
147: BEGIN
148:
149: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
150: OPEN period_info;
151: FETCH period_info INTO l_month;
152:
153: IF period_info%NOTFOUND THEN

Line 160: --ams_utility_pvt.debug_message('fiscal month --' || l_month);

156: END IF;
157:
158: CLOSE period_info;
159:
160: --ams_utility_pvt.debug_message('fiscal month --' || l_month);
161:
162: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
163:
164: RETURN(l_month);

Line 162: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

158: CLOSE period_info;
159:
160: --ams_utility_pvt.debug_message('fiscal month --' || l_month);
161:
162: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
163:
164: RETURN(l_month);
165:
166: EXCEPTION

Line 212: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

208: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
209: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
210: BEGIN
211:
212: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
213: OPEN period_info;
214: FETCH period_info INTO l_qtr;
215:
216: IF period_info%NOTFOUND THEN

Line 223: --ams_utility_pvt.debug_message('fiscal quarter --' || l_qtr);

219: END IF;
220:
221: CLOSE period_info;
222:
223: --ams_utility_pvt.debug_message('fiscal quarter --' || l_qtr);
224:
225: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
226:
227: RETURN(l_qtr);

Line 225: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

221: CLOSE period_info;
222:
223: --ams_utility_pvt.debug_message('fiscal quarter --' || l_qtr);
224:
225: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
226:
227: RETURN(l_qtr);
228:
229: EXCEPTION

Line 275: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

271: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
272:
273: BEGIN
274:
275: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
276: OPEN period_info;
277: FETCH period_info INTO l_year;
278:
279: IF period_info%NOTFOUND THEN

Line 286: --ams_utility_pvt.debug_message('fisical year --' || l_year);

282: END IF;
283:
284: CLOSE period_info;
285:
286: --ams_utility_pvt.debug_message('fisical year --' || l_year);
287:
288: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
289:
290: RETURN(l_year);

Line 288: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

284: CLOSE period_info;
285:
286: --ams_utility_pvt.debug_message('fisical year --' || l_year);
287:
288: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
289:
290: RETURN(l_year);
291:
292: EXCEPTION

Line 340: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

336: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
337:
338: BEGIN
339:
340: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
341: OPEN period_info;
342: FETCH period_info INTO l_period_num;
343:
344: IF period_info%NOTFOUND THEN

Line 351: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);

347: END IF;
348:
349: CLOSE period_info;
350:
351: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);
352:
353: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
354:
355: RETURN(l_period_num);

Line 353: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

349: CLOSE period_info;
350:
351: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);
352:
353: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
354:
355: RETURN(l_period_num);
356:
357: EXCEPTION

Line 406: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

402: AND UPPER(period_type) =p_type;
403:
404: BEGIN
405:
406: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
407: OPEN period_name;
408: FETCH period_name INTO l_name;
409:
410: IF period_name%NOTFOUND THEN

Line 417: --ams_utility_pvt.debug_message('fisical month --' || l_month);

413: END IF;
414:
415: CLOSE period_name;
416:
417: --ams_utility_pvt.debug_message('fisical month --' || l_month);
418:
419: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
420:
421: RETURN(l_name);

Line 419: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

415: CLOSE period_name;
416:
417: --ams_utility_pvt.debug_message('fisical month --' || l_month);
418:
419: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
420:
421: RETURN(l_name);
422:
423: EXCEPTION

Line 469: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

465: AND b.period_type=month_type
466: AND b.period_name =p_month;
467: BEGIN
468:
469: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
470: OPEN period_info;
471: FETCH period_info INTO l_period_num;
472:
473: IF period_info%NOTFOUND THEN

Line 480: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);

476: END IF;
477:
478: CLOSE period_info;
479:
480: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);
481:
482: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
483:
484: RETURN(l_period_num);

Line 482: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

478: CLOSE period_info;
479:
480: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);
481:
482: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
483:
484: RETURN(l_period_num);
485:
486: EXCEPTION

Line 535: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

531: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
532:
533: BEGIN
534:
535: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
536: OPEN period_info;
537: FETCH period_info INTO l_period_num;
538:
539: IF period_info%NOTFOUND THEN

Line 546: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);

542: END IF;
543:
544: CLOSE period_info;
545:
546: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);
547:
548: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
549:
550: RETURN(l_period_num);

Line 548: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

544: CLOSE period_info;
545:
546: --ams_utility_pvt.debug_message('fisical quarter period num--' || l_period_num);
547:
548: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
549:
550: RETURN(l_period_num);
551:
552: EXCEPTION

Line 612: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

608: AND TRUNC(v_date) <= TRUNC(b.end_date);
609:
610: BEGIN
611:
612: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
613:
614: OPEN period_info(p_input_date);
615: FETCH period_info INTO l_date;
616:

Line 654: --ams_utility_pvt.debug_message('fisical year --' || l_year);

650: END IF;
651:
652: CLOSE period_info;
653:
654: --ams_utility_pvt.debug_message('fisical year --' || l_year);
655: --ams_utility_pvt.debug_message('fisical quarter --' || l_qtr);
656: --ams_utility_pvt.debug_message('fisical month --' || l_month);
657:
658: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

Line 655: --ams_utility_pvt.debug_message('fisical quarter --' || l_qtr);

651:
652: CLOSE period_info;
653:
654: --ams_utility_pvt.debug_message('fisical year --' || l_year);
655: --ams_utility_pvt.debug_message('fisical quarter --' || l_qtr);
656: --ams_utility_pvt.debug_message('fisical month --' || l_month);
657:
658: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
659:

Line 656: --ams_utility_pvt.debug_message('fisical month --' || l_month);

652: CLOSE period_info;
653:
654: --ams_utility_pvt.debug_message('fisical year --' || l_year);
655: --ams_utility_pvt.debug_message('fisical quarter --' || l_qtr);
656: --ams_utility_pvt.debug_message('fisical month --' || l_month);
657:
658: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
659:
660: RETURN(l_date);

Line 658: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

654: --ams_utility_pvt.debug_message('fisical year --' || l_year);
655: --ams_utility_pvt.debug_message('fisical quarter --' || l_qtr);
656: --ams_utility_pvt.debug_message('fisical month --' || l_month);
657:
658: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
659:
660: RETURN(l_date);
661:
662: EXCEPTION

Line 704: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

700:
701:
702: BEGIN
703:
704: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
705: l_date :=get_fiscal_roll_year_start(p_input_date, p_org_id);
706:
707: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
708: l_date := l_date-1;

Line 707: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

703:
704: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
705: l_date :=get_fiscal_roll_year_start(p_input_date, p_org_id);
706:
707: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
708: l_date := l_date-1;
709: l_date := get_fiscal_roll_year_start(l_date, p_org_id);
710: RETURN(l_date);
711:

Line 753: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

749: l_delta NUMBER;
750:
751: BEGIN
752:
753: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
754: l_date :=get_fiscal_roll_year_start(p_input_date, p_org_id);
755: l_delta :=p_input_date- l_date;
756: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
757: l_date := l_date-1;

Line 756: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

752:
753: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
754: l_date :=get_fiscal_roll_year_start(p_input_date, p_org_id);
755: l_delta :=p_input_date- l_date;
756: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
757: l_date := l_date-1;
758: l_date := get_fiscal_roll_year_start(l_date, p_org_id);
759: l_date :=l_date +l_delta;
760: RETURN(l_date);

Line 822: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

818: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
819:
820: BEGIN
821:
822: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
823: OPEN period_info;
824: FETCH period_info INTO l_date;
825:
826: IF period_info%NOTFOUND THEN

Line 833: --ams_utility_pvt.debug_message('fisical year --' || l_date);

829: END IF;
830:
831: CLOSE period_info;
832:
833: --ams_utility_pvt.debug_message('fisical year --' || l_date);
834:
835: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
836:
837: RETURN(l_date);

Line 835: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

831: CLOSE period_info;
832:
833: --ams_utility_pvt.debug_message('fisical year --' || l_date);
834:
835: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
836:
837: RETURN(l_date);
838:
839: EXCEPTION

Line 899: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

895: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
896:
897: BEGIN
898:
899: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
900: OPEN period_info;
901: FETCH period_info INTO l_date;
902:
903: IF period_info%NOTFOUND THEN

Line 910: --ams_utility_pvt.debug_message('fisical year --' || l_date);

906: END IF;
907:
908: CLOSE period_info;
909:
910: --ams_utility_pvt.debug_message('fisical year --' || l_date);
911:
912: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
913:
914: RETURN(l_date);

Line 912: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

908: CLOSE period_info;
909:
910: --ams_utility_pvt.debug_message('fisical year --' || l_date);
911:
912: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
913:
914: RETURN(l_date);
915:
916: EXCEPTION

Line 978: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

974: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
975:
976: BEGIN
977:
978: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
979: OPEN period_info;
980: FETCH period_info INTO l_date;
981:
982: IF period_info%NOTFOUND THEN

Line 989: --ams_utility_pvt.debug_message('fisical year --' || l_date);

985: END IF;
986:
987: CLOSE period_info;
988:
989: --ams_utility_pvt.debug_message('fisical year --' || l_date);
990:
991: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
992:
993: RETURN(l_date);

Line 991: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

987: CLOSE period_info;
988:
989: --ams_utility_pvt.debug_message('fisical year --' || l_date);
990:
991: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
992:
993: RETURN(l_date);
994:
995: EXCEPTION

Line 1235: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

1231: l_date DATE;
1232:
1233: BEGIN
1234:
1235: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1236: l_date :=get_fiscal_month_start(p_input_date, p_org_id);
1237:
1238: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1239: l_date := l_date-1;

Line 1238: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

1234:
1235: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1236: l_date :=get_fiscal_month_start(p_input_date, p_org_id);
1237:
1238: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1239: l_date := l_date-1;
1240: l_date := get_fiscal_month_start(l_date, p_org_id);
1241: RETURN(l_date);
1242:

Line 1286: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

1282: l_delta NUMBER;
1283:
1284: BEGIN
1285:
1286: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1287: l_date :=get_fiscal_month_start(p_input_date, p_org_id);
1288: l_date1 :=get_fiscal_month_end(p_input_date, p_org_id);
1289: l_delta :=p_input_date- l_date;
1290: l_date := l_date-1;

Line 1298: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

1294: l_date :=l_date +l_delta;
1295: ELSE
1296: l_date := l_date2;
1297: END IF;
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

Line 1361: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

1357: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
1358:
1359: BEGIN
1360:
1361: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1362: OPEN period_info;
1363: FETCH period_info INTO l_date;
1364:
1365: IF period_info%NOTFOUND THEN

Line 1372: --ams_utility_pvt.debug_message('fisical year --' || l_date);

1368: END IF;
1369:
1370: CLOSE period_info;
1371:
1372: --ams_utility_pvt.debug_message('fisical year --' || l_date);
1373:
1374: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1375:
1376: RETURN(l_date);

Line 1374: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

1370: CLOSE period_info;
1371:
1372: --ams_utility_pvt.debug_message('fisical year --' || l_date);
1373:
1374: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1375:
1376: RETURN(l_date);
1377:
1378: EXCEPTION

Line 1438: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

1434: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
1435:
1436: BEGIN
1437:
1438: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1439: OPEN period_info;
1440: FETCH period_info INTO l_date;
1441:
1442: IF period_info%NOTFOUND THEN

Line 1449: --ams_utility_pvt.debug_message('fisical year --' || l_date);

1445: END IF;
1446:
1447: CLOSE period_info;
1448:
1449: --ams_utility_pvt.debug_message('fisical year --' || l_date);
1450:
1451: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1452:
1453: RETURN(l_date);

Line 1451: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

1447: CLOSE period_info;
1448:
1449: --ams_utility_pvt.debug_message('fisical year --' || l_date);
1450:
1451: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1452:
1453: RETURN(l_date);
1454:
1455: EXCEPTION

Line 1515: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

1511: AND TRUNC(p_input_date) <= TRUNC(b.end_date);
1512:
1513: BEGIN
1514:
1515: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1516: OPEN period_info;
1517: FETCH period_info INTO l_date;
1518:
1519: IF period_info%NOTFOUND THEN

Line 1526: --ams_utility_pvt.debug_message('fisical year --' || l_date);

1522: END IF;
1523:
1524: CLOSE period_info;
1525:
1526: --ams_utility_pvt.debug_message('fisical year --' || l_date);
1527:
1528: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1529:
1530: RETURN(l_date);

Line 1528: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

1524: CLOSE period_info;
1525:
1526: --ams_utility_pvt.debug_message('fisical year --' || l_date);
1527:
1528: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1529:
1530: RETURN(l_date);
1531:
1532: EXCEPTION

Line 1588: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

1584: AND TRUNC(l_start_date) >= TRUNC(b.start_date)
1585: AND TRUNC(l_start_date) <= TRUNC(b.end_date);
1586: BEGIN
1587:
1588: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1589: OPEN cur_period_date;
1590: FETCH cur_period_date INTO l_period_date;
1591:
1592: IF cur_period_date%NOTFOUND THEN

Line 1609: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);

1605: END IF;
1606:
1607: CLOSE cur_period_name;
1608:
1609: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);
1610:
1611: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1612:
1613: RETURN(l_period_name);

Line 1611: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

1607: CLOSE cur_period_name;
1608:
1609: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);
1610:
1611: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1612:
1613: RETURN(l_period_name);
1614:
1615: EXCEPTION

Line 1671: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

1667: AND TRUNC(l_start_date) >= TRUNC(b.start_date)
1668: AND TRUNC(l_start_date) <= TRUNC(b.end_date);
1669: BEGIN
1670:
1671: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1672: OPEN cur_period_date;
1673: FETCH cur_period_date INTO l_period_date;
1674:
1675: IF cur_period_date%NOTFOUND THEN

Line 1692: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);

1688: END IF;
1689:
1690: CLOSE cur_period_name;
1691:
1692: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);
1693:
1694: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1695:
1696: RETURN(l_period_name);

Line 1694: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

1690: CLOSE cur_period_name;
1691:
1692: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);
1693:
1694: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1695:
1696: RETURN(l_period_name);
1697:
1698: EXCEPTION

Line 1754: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');

1750: AND TRUNC(l_start_date) >= TRUNC(b.start_date)
1751: AND TRUNC(l_start_date) <= TRUNC(b.end_date);
1752: BEGIN
1753:
1754: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'START');
1755: OPEN cur_period_date;
1756: FETCH cur_period_date INTO l_period_date;
1757:
1758: IF cur_period_date%NOTFOUND THEN

Line 1775: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);

1771: END IF;
1772:
1773: CLOSE cur_period_name;
1774:
1775: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);
1776:
1777: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1778:
1779: RETURN(l_period_name);

Line 1777: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');

1773: CLOSE cur_period_name;
1774:
1775: --ams_utility_pvt.debug_message('fiscal quarter period name--' || l_period_name);
1776:
1777: ams_utility_pvt.debug_message('PUBLIC API: ' || l_api_name || 'END');
1778:
1779: RETURN(l_period_name);
1780:
1781: EXCEPTION