DBA Data[Home] [Help]

APPS.JTF_RS_TEAM_USAGES_PVT dependencies on FND_MSG_PUB

Line 125: fnd_msg_pub.initialize;

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:

Line 160: fnd_msg_pub.add;

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;

Line 196: fnd_msg_pub.add;

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;

Line 229: fnd_msg_pub.add;

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;

Line 256: fnd_msg_pub.add;

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;

Line 288: fnd_msg_pub.add;

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;

Line 357: fnd_msg_pub.add;

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;

Line 416: fnd_msg_pub.add;

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;

Line 452: fnd_msg_pub.add;

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;

Line 486: fnd_msg_pub.add;

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;

Line 543: fnd_msg_pub.add;

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;

Line 562: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 578: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 593: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 654: fnd_msg_pub.initialize;

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:

Line 687: fnd_msg_pub.add;

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;

Line 723: fnd_msg_pub.add;

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;

Line 757: fnd_msg_pub.add;

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;

Line 787: fnd_msg_pub.add;

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;

Line 825: fnd_msg_pub.add;

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;

Line 852: fnd_msg_pub.add;

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;

Line 888: fnd_msg_pub.add;

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;

Line 924: fnd_msg_pub.add;

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;

Line 958: fnd_msg_pub.add;

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;

Line 1015: fnd_msg_pub.add;

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;

Line 1033: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 1049: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:

Line 1064: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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: