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.JTF_RS_TEAM_USAGES_PVT dependencies on FND_API

Line 111: x_return_status := fnd_api.g_ret_sts_success;

107:
108:
109: SAVEPOINT create_rs_team_usage_pvt;
110:
111: x_return_status := fnd_api.g_ret_sts_success;
112:
113: -- DBMS_OUTPUT.put_line('Started Create Resource Team Usage Pvt ');
114:
115:

Line 116: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

112:
113: -- DBMS_OUTPUT.put_line('Started Create Resource Team Usage Pvt ');
114:
115:
116: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
117:
118: RAISE fnd_api.g_exc_unexpected_error;
119:
120: END IF;

Line 118: RAISE fnd_api.g_exc_unexpected_error;

114:
115:
116: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
117:
118: RAISE fnd_api.g_exc_unexpected_error;
119:
120: END IF;
121:
122:

Line 123: IF fnd_api.to_boolean(p_init_msg_list) THEN

119:
120: END IF;
121:
122:
123: IF fnd_api.to_boolean(p_init_msg_list) THEN
124:
125: fnd_msg_pub.initialize;
126:
127: END IF;

Line 153: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

149: p_team_id => l_team_id,
150: p_usage => l_usage,
151: x_return_status => x_return_status);
152:
153: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
154:
155: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
156:
157: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 157: x_return_status := fnd_api.g_ret_sts_unexp_error;

153: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
154:
155: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
156:
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158:
159: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
160: fnd_msg_pub.add;
161:

Line 162: RAISE fnd_api.g_exc_unexpected_error;

158:
159: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
160: fnd_msg_pub.add;
161:
162: RAISE fnd_api.g_exc_unexpected_error;
163:
164: END IF;
165:
166: END IF;

Line 189: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

185: p_team_id => l_team_id,
186: p_usage => l_usage,
187: x_return_status => x_return_status);
188:
189: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
190:
191: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
192:
193: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 193: x_return_status := fnd_api.g_ret_sts_unexp_error;

189: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
190:
191: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
192:
193: x_return_status := fnd_api.g_ret_sts_unexp_error;
194:
195: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
196: fnd_msg_pub.add;
197:

Line 198: RAISE fnd_api.g_exc_unexpected_error;

194:
195: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
196: fnd_msg_pub.add;
197:
198: RAISE fnd_api.g_exc_unexpected_error;
199:
200: END IF;
201:
202: END IF;

Line 224: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

220: p_team_id => l_team_id,
221: p_usage => l_usage,
222: x_return_status => x_return_status);
223:
224: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
225:
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227:
228: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

Line 226: x_return_status := fnd_api.g_ret_sts_unexp_error;

222: x_return_status => x_return_status);
223:
224: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
225:
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227:
228: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
229: fnd_msg_pub.add;
230:

Line 231: RAISE fnd_api.g_exc_unexpected_error;

227:
228: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
229: fnd_msg_pub.add;
230:
231: RAISE fnd_api.g_exc_unexpected_error;
232:
233: END IF;
234:
235: END IF;

Line 253: x_return_status := fnd_api.g_ret_sts_error;

249: IF l_check_count > 0 THEN
250:
251: -- dbms_output.put_line('Usage already assigned to the Team');
252:
253: x_return_status := fnd_api.g_ret_sts_error;
254:
255: fnd_message.set_name('JTF', 'JTF_RS_USAGE_EXISTS_TEAM');
256: fnd_msg_pub.add;
257:

Line 258: RAISE fnd_api.g_exc_unexpected_error;

254:
255: fnd_message.set_name('JTF', 'JTF_RS_USAGE_EXISTS_TEAM');
256: fnd_msg_pub.add;
257:
258: RAISE fnd_api.g_exc_unexpected_error;
259:
260: END IF;
261:
262:

Line 285: x_return_status := fnd_api.g_ret_sts_unexp_error;

281: CLOSE c_exclusive_team_check;
282:
283: END IF;
284:
285: x_return_status := fnd_api.g_ret_sts_unexp_error;
286:
287: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_TEAM_ERR');
288: fnd_msg_pub.add;
289:

Line 290: RAISE fnd_api.g_exc_unexpected_error;

286:
287: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_TEAM_ERR');
288: fnd_msg_pub.add;
289:
290: RAISE fnd_api.g_exc_unexpected_error;
291:
292: END IF;
293:
294:

Line 354: x_return_status := fnd_api.g_ret_sts_unexp_error;

350: IF c_jtf_rs_team_usages%NOTFOUND THEN
351:
352: -- dbms_output.put_line('Error in Table Handler');
353:
354: x_return_status := fnd_api.g_ret_sts_unexp_error;
355:
356: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
357: fnd_msg_pub.add;
358:

Line 365: RAISE fnd_api.g_exc_unexpected_error;

361: CLOSE c_jtf_rs_team_usages;
362:
363: END IF;
364:
365: RAISE fnd_api.g_exc_unexpected_error;
366:
367: ELSE
368:
369: -- dbms_output.put_line('Team Usage Successfully Created');

Line 409: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

405: p_team_id => l_team_id,
406: p_usage => l_usage,
407: x_return_status => x_return_status);
408:
409: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
410:
411: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
412:
413: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 413: x_return_status := fnd_api.g_ret_sts_unexp_error;

409: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
410:
411: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
412:
413: x_return_status := fnd_api.g_ret_sts_unexp_error;
414:
415: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
416: fnd_msg_pub.add;
417:

Line 418: RAISE fnd_api.g_exc_unexpected_error;

414:
415: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
416: fnd_msg_pub.add;
417:
418: RAISE fnd_api.g_exc_unexpected_error;
419:
420: END IF;
421:
422: END IF;

Line 445: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

441: p_team_id => l_team_id,
442: p_usage => l_usage,
443: x_return_status => x_return_status);
444:
445: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
446:
447: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
448:
449: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 449: x_return_status := fnd_api.g_ret_sts_unexp_error;

445: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
446:
447: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
448:
449: x_return_status := fnd_api.g_ret_sts_unexp_error;
450:
451: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
452: fnd_msg_pub.add;
453:

Line 454: RAISE fnd_api.g_exc_unexpected_error;

450:
451: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
452: fnd_msg_pub.add;
453:
454: RAISE fnd_api.g_exc_unexpected_error;
455:
456: END IF;
457:
458: END IF;

Line 481: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

477: p_team_id => l_team_id,
478: p_usage => l_usage,
479: x_return_status => x_return_status);
480:
481: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
482:
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484:
485: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

Line 483: x_return_status := fnd_api.g_ret_sts_unexp_error;

479: x_return_status => x_return_status);
480:
481: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
482:
483: x_return_status := fnd_api.g_ret_sts_unexp_error;
484:
485: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
486: fnd_msg_pub.add;
487:

Line 488: RAISE fnd_api.g_exc_unexpected_error;

484:
485: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
486: fnd_msg_pub.add;
487:
488: RAISE fnd_api.g_exc_unexpected_error;
489:
490: END IF;
491:
492: END IF;

Line 536: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

532: p_bind_data_id => l_bind_data_id,
533: x_return_code => x_return_status);
534:
535:
536: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
537:
538: -- dbms_output.put_line('Returned Error status from the Message Generation API');
539:
540: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 540: x_return_status := fnd_api.g_ret_sts_unexp_error;

536: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
537:
538: -- dbms_output.put_line('Returned Error status from the Message Generation API');
539:
540: x_return_status := fnd_api.g_ret_sts_unexp_error;
541:
542: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
543: fnd_msg_pub.add;
544:

Line 545: RAISE fnd_api.g_exc_unexpected_error;

541:
542: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
543: fnd_msg_pub.add;
544:
545: RAISE fnd_api.g_exc_unexpected_error;
546:
547: END IF;
548:
549: END IF;

Line 556: IF fnd_api.to_boolean(p_commit) THEN

552:
553: END IF;
554:
555:
556: IF fnd_api.to_boolean(p_commit) THEN
557:
558: COMMIT WORK;
559:
560: END IF;

Line 568: WHEN fnd_api.g_exc_unexpected_error THEN

564:
565: EXCEPTION
566:
567:
568: WHEN fnd_api.g_exc_unexpected_error THEN
569:
570: -- DBMS_OUTPUT.put_line (' ========================================== ');
571:
572: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');

Line 576: x_return_status := fnd_api.g_ret_sts_unexp_error;

572: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');
573:
574: ROLLBACK TO create_rs_team_usage_pvt;
575:
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577:
578: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
579:
580:

Line 591: x_return_status := fnd_api.g_ret_sts_unexp_error;

587: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
588:
589: ROLLBACK TO create_rs_team_usage_pvt;
590:
591: x_return_status := fnd_api.g_ret_sts_unexp_error;
592:
593: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
594:
595:

Line 640: x_return_status := fnd_api.g_ret_sts_success;

636:
637:
638: SAVEPOINT delete_team_usage_pvt;
639:
640: x_return_status := fnd_api.g_ret_sts_success;
641:
642: -- DBMS_OUTPUT.put_line(' Started Delete Team Usage Pvt ');
643:
644:

Line 645: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

641:
642: -- DBMS_OUTPUT.put_line(' Started Delete Team Usage Pvt ');
643:
644:
645: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
646:
647: RAISE fnd_api.g_exc_unexpected_error;
648:
649: END IF;

Line 647: RAISE fnd_api.g_exc_unexpected_error;

643:
644:
645: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
646:
647: RAISE fnd_api.g_exc_unexpected_error;
648:
649: END IF;
650:
651:

Line 652: IF fnd_api.to_boolean(p_init_msg_list) THEN

648:
649: END IF;
650:
651:
652: IF fnd_api.to_boolean(p_init_msg_list) THEN
653:
654: fnd_msg_pub.initialize;
655:
656: END IF;

Line 680: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

676: p_team_id => l_team_id,
677: p_usage => l_usage,
678: x_return_status => x_return_status);
679:
680: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
681:
682: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
683:
684: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 684: x_return_status := fnd_api.g_ret_sts_unexp_error;

680: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
681:
682: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
683:
684: x_return_status := fnd_api.g_ret_sts_unexp_error;
685:
686: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
687: fnd_msg_pub.add;
688:

Line 689: RAISE fnd_api.g_exc_unexpected_error;

685:
686: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
687: fnd_msg_pub.add;
688:
689: RAISE fnd_api.g_exc_unexpected_error;
690:
691: END IF;
692:
693: END IF;

Line 716: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

712: p_team_id => l_team_id,
713: p_usage => l_usage,
714: x_return_status => x_return_status);
715:
716: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
717:
718: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
719:
720: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 720: x_return_status := fnd_api.g_ret_sts_unexp_error;

716: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
717:
718: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
719:
720: x_return_status := fnd_api.g_ret_sts_unexp_error;
721:
722: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
723: fnd_msg_pub.add;
724:

Line 725: RAISE fnd_api.g_exc_unexpected_error;

721:
722: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
723: fnd_msg_pub.add;
724:
725: RAISE fnd_api.g_exc_unexpected_error;
726:
727: END IF;
728:
729: END IF;

Line 752: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

748: p_team_id => l_team_id,
749: p_usage => l_usage,
750: x_return_status => x_return_status);
751:
752: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
753:
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755:
756: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

Line 754: x_return_status := fnd_api.g_ret_sts_unexp_error;

750: x_return_status => x_return_status);
751:
752: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
753:
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755:
756: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
757: fnd_msg_pub.add;
758:

Line 759: RAISE fnd_api.g_exc_unexpected_error;

755:
756: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
757: fnd_msg_pub.add;
758:
759: RAISE fnd_api.g_exc_unexpected_error;
760:
761: END IF;
762:
763: END IF;

Line 789: x_return_status := fnd_api.g_ret_sts_unexp_error;

785: fnd_message.set_token('P_USAGE', l_usage);
786: fnd_message.set_token('P_TEAM_ID', l_team_id);
787: fnd_msg_pub.add;
788:
789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790:
791: RAISE fnd_api.g_exc_unexpected_error;
792:
793: END IF;

Line 791: RAISE fnd_api.g_exc_unexpected_error;

787: fnd_msg_pub.add;
788:
789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790:
791: RAISE fnd_api.g_exc_unexpected_error;
792:
793: END IF;
794:
795:

Line 822: x_return_status := fnd_api.g_ret_sts_unexp_error;

818: WHEN OTHERS THEN
819:
820: -- dbms_output.put_line('Error in Locking the Row');
821:
822: x_return_status := fnd_api.g_ret_sts_unexp_error;
823:
824: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
825: fnd_msg_pub.add;
826:

Line 827: RAISE fnd_api.g_exc_unexpected_error;

823:
824: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
825: fnd_msg_pub.add;
826:
827: RAISE fnd_api.g_exc_unexpected_error;
828:
829: END;
830:
831:

Line 849: x_return_status := fnd_api.g_ret_sts_unexp_error;

845: WHEN NO_DATA_FOUND THEN
846:
847: -- dbms_output.put_line('Error in Table Handler');
848:
849: x_return_status := fnd_api.g_ret_sts_unexp_error;
850:
851: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
852: fnd_msg_pub.add;
853:

Line 854: RAISE fnd_api.g_exc_unexpected_error;

850:
851: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
852: fnd_msg_pub.add;
853:
854: RAISE fnd_api.g_exc_unexpected_error;
855:
856: END;
857:
858:

Line 881: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

877: p_team_id => l_team_id,
878: p_usage => l_usage,
879: x_return_status => x_return_status);
880:
881: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
882:
883: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
884:
885: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 885: x_return_status := fnd_api.g_ret_sts_unexp_error;

881: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
882:
883: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
884:
885: x_return_status := fnd_api.g_ret_sts_unexp_error;
886:
887: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
888: fnd_msg_pub.add;
889:

Line 890: RAISE fnd_api.g_exc_unexpected_error;

886:
887: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
888: fnd_msg_pub.add;
889:
890: RAISE fnd_api.g_exc_unexpected_error;
891:
892: END IF;
893:
894: END IF;

Line 917: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

913: p_team_id => l_team_id,
914: p_usage => l_usage,
915: x_return_status => x_return_status);
916:
917: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
918:
919: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
920:
921: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 921: x_return_status := fnd_api.g_ret_sts_unexp_error;

917: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
918:
919: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
920:
921: x_return_status := fnd_api.g_ret_sts_unexp_error;
922:
923: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
924: fnd_msg_pub.add;
925:

Line 926: RAISE fnd_api.g_exc_unexpected_error;

922:
923: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
924: fnd_msg_pub.add;
925:
926: RAISE fnd_api.g_exc_unexpected_error;
927:
928: END IF;
929:
930: END IF;

Line 953: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

949: p_team_id => l_team_id,
950: p_usage => l_usage,
951: x_return_status => x_return_status);
952:
953: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
954:
955: x_return_status := fnd_api.g_ret_sts_unexp_error;
956:
957: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

Line 955: x_return_status := fnd_api.g_ret_sts_unexp_error;

951: x_return_status => x_return_status);
952:
953: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
954:
955: x_return_status := fnd_api.g_ret_sts_unexp_error;
956:
957: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
958: fnd_msg_pub.add;
959:

Line 960: RAISE fnd_api.g_exc_unexpected_error;

956:
957: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
958: fnd_msg_pub.add;
959:
960: RAISE fnd_api.g_exc_unexpected_error;
961:
962: END IF;
963:
964: END IF;

Line 1008: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1004: p_bind_data_id => l_bind_data_id,
1005: x_return_code => x_return_status);
1006:
1007:
1008: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1009:
1010: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1011:
1012: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1012: x_return_status := fnd_api.g_ret_sts_unexp_error;

1008: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1009:
1010: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1011:
1012: x_return_status := fnd_api.g_ret_sts_unexp_error;
1013:
1014: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1015: fnd_msg_pub.add;
1016:

Line 1017: RAISE fnd_api.g_exc_unexpected_error;

1013:
1014: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1015: fnd_msg_pub.add;
1016:
1017: RAISE fnd_api.g_exc_unexpected_error;
1018:
1019: END IF;
1020:
1021: END IF;

Line 1027: IF fnd_api.to_boolean(p_commit) THEN

1023: END IF;
1024: END IF;
1025:
1026:
1027: IF fnd_api.to_boolean(p_commit) THEN
1028:
1029: COMMIT WORK;
1030:
1031: END IF;

Line 1039: WHEN fnd_api.g_exc_unexpected_error THEN

1035:
1036: EXCEPTION
1037:
1038:
1039: WHEN fnd_api.g_exc_unexpected_error THEN
1040:
1041: -- DBMS_OUTPUT.put_line (' ========================================== ');
1042:
1043: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');

Line 1047: x_return_status := fnd_api.g_ret_sts_unexp_error;

1043: -- DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error ======= ======== ');
1044:
1045: ROLLBACK TO delete_team_usage_pvt;
1046:
1047: x_return_status := fnd_api.g_ret_sts_unexp_error;
1048:
1049: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1050:
1051:

Line 1062: x_return_status := fnd_api.g_ret_sts_unexp_error;

1058: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1059:
1060: ROLLBACK TO delete_team_usage_pvt;
1061:
1062: x_return_status := fnd_api.g_ret_sts_unexp_error;
1063:
1064: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1065:
1066: