121:
122:
123: IF fnd_api.to_boolean(p_init_msg_list) THEN
124:
125: fnd_msg_pub.initialize;
126:
127: END IF;
128:
129:
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:
162: RAISE fnd_api.g_exc_unexpected_error;
163:
164: END IF;
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:
198: RAISE fnd_api.g_exc_unexpected_error;
199:
200: END IF;
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:
231: RAISE fnd_api.g_exc_unexpected_error;
232:
233: END IF;
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:
258: RAISE fnd_api.g_exc_unexpected_error;
259:
260: 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:
290: RAISE fnd_api.g_exc_unexpected_error;
291:
292: END IF;
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:
359: IF c_jtf_rs_team_usages%ISOPEN THEN
360:
361: CLOSE c_jtf_rs_team_usages;
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:
418: RAISE fnd_api.g_exc_unexpected_error;
419:
420: END IF;
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:
454: RAISE fnd_api.g_exc_unexpected_error;
455:
456: END IF;
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:
488: RAISE fnd_api.g_exc_unexpected_error;
489:
490: END IF;
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:
545: RAISE fnd_api.g_exc_unexpected_error;
546:
547: END IF;
558: COMMIT WORK;
559:
560: END IF;
561:
562: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
563:
564:
565: EXCEPTION
566:
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:
581: WHEN OTHERS THEN
582:
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:
596: END create_team_usage;
597:
650:
651:
652: IF fnd_api.to_boolean(p_init_msg_list) THEN
653:
654: fnd_msg_pub.initialize;
655:
656: END IF;
657:
658:
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:
689: RAISE fnd_api.g_exc_unexpected_error;
690:
691: END IF;
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:
725: RAISE fnd_api.g_exc_unexpected_error;
726:
727: END IF;
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:
759: RAISE fnd_api.g_exc_unexpected_error;
760:
761: END IF;
783:
784: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_USAGE');
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;
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:
827: RAISE fnd_api.g_exc_unexpected_error;
828:
829: END;
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:
854: RAISE fnd_api.g_exc_unexpected_error;
855:
856: END;
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:
890: RAISE fnd_api.g_exc_unexpected_error;
891:
892: END IF;
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:
926: RAISE fnd_api.g_exc_unexpected_error;
927:
928: END IF;
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:
960: RAISE fnd_api.g_exc_unexpected_error;
961:
962: END IF;
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:
1017: RAISE fnd_api.g_exc_unexpected_error;
1018:
1019: END IF;
1029: COMMIT WORK;
1030:
1031: END IF;
1032:
1033: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1034:
1035:
1036: EXCEPTION
1037:
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:
1052: WHEN OTHERS THEN
1053:
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:
1067: END delete_team_usage;
1068: