DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_USAGES_PVT dependencies on FND_MSG_PUB

Line 129: fnd_msg_pub.initialize;

125:
126:
127: IF fnd_api.to_boolean(p_init_msg_list) THEN
128:
129: fnd_msg_pub.initialize;
130:
131: END IF;
132:
133:

Line 163: fnd_msg_pub.add;

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

Line 200: fnd_msg_pub.add;

196:
197: x_return_status := fnd_api.g_ret_sts_unexp_error;
198:
199: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
200: fnd_msg_pub.add;
201:
202: RAISE fnd_api.g_exc_unexpected_error;
203:
204: END IF;

Line 235: fnd_msg_pub.add;

231:
232: x_return_status := fnd_api.g_ret_sts_unexp_error;
233:
234: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
235: fnd_msg_pub.add;
236:
237: RAISE fnd_api.g_exc_unexpected_error;
238:
239: END IF;

Line 262: fnd_msg_pub.add;

258:
259: x_return_status := fnd_api.g_ret_sts_error;
260:
261: fnd_message.set_name('JTF', 'JTF_RS_USAGE_EXISTS');
262: fnd_msg_pub.add;
263:
264: RAISE fnd_api.g_exc_unexpected_error;
265:
266: END IF;

Line 294: fnd_msg_pub.add;

290:
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292:
293: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_GROUP_ERR');
294: fnd_msg_pub.add;
295:
296: RAISE fnd_api.g_exc_unexpected_error;
297:
298: END IF;

Line 363: fnd_msg_pub.add;

359:
360: x_return_status := fnd_api.g_ret_sts_unexp_error;
361:
362: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
363: fnd_msg_pub.add;
364:
365: IF c_jtf_rs_group_usages%ISOPEN THEN
366:
367: CLOSE c_jtf_rs_group_usages;

Line 422: fnd_msg_pub.add;

418:
419: x_return_status := fnd_api.g_ret_sts_unexp_error;
420:
421: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
422: fnd_msg_pub.add;
423:
424: RAISE fnd_api.g_exc_unexpected_error;
425:
426: END IF;

Line 460: fnd_msg_pub.add;

456:
457: x_return_status := fnd_api.g_ret_sts_unexp_error;
458:
459: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
460: fnd_msg_pub.add;
461:
462: RAISE fnd_api.g_exc_unexpected_error;
463:
464: END IF;

Line 496: fnd_msg_pub.add;

492:
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494:
495: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
496: fnd_msg_pub.add;
497:
498: RAISE fnd_api.g_exc_unexpected_error;
499:
500: END IF;

Line 553: fnd_msg_pub.add;

549:
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551:
552: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
553: fnd_msg_pub.add;
554:
555: RAISE fnd_api.g_exc_unexpected_error;
556:
557: END IF;

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

567: COMMIT WORK;
568:
569: END IF;
570:
571: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
572:
573:
574: EXCEPTION
575:

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

583: ROLLBACK TO create_rs_group_usage_pvt;
584:
585: x_return_status := fnd_api.g_ret_sts_unexp_error;
586:
587: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
588:
589:
590: WHEN OTHERS THEN
591:

Line 604: FND_MSG_PUB.add;

600: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
601: fnd_message.set_token('P_SQLCODE',SQLCODE);
602: fnd_message.set_token('P_SQLERRM',SQLERRM);
603: fnd_message.set_token('P_API_NAME',l_api_name);
604: FND_MSG_PUB.add;
605:
606: x_return_status := fnd_api.g_ret_sts_unexp_error;
607:
608: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

604: FND_MSG_PUB.add;
605:
606: x_return_status := fnd_api.g_ret_sts_unexp_error;
607:
608: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
609:
610:
611: END create_group_usage;
612:

Line 680: fnd_msg_pub.initialize;

676:
677:
678: IF fnd_api.to_boolean(p_init_msg_list) THEN
679:
680: fnd_msg_pub.initialize;
681:
682: END IF;
683:
684:

Line 714: fnd_msg_pub.add;

710:
711: x_return_status := fnd_api.g_ret_sts_unexp_error;
712:
713: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
714: fnd_msg_pub.add;
715:
716: RAISE fnd_api.g_exc_unexpected_error;
717:
718: END IF;

Line 751: fnd_msg_pub.add;

747:
748: x_return_status := fnd_api.g_ret_sts_unexp_error;
749:
750: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
751: fnd_msg_pub.add;
752:
753: RAISE fnd_api.g_exc_unexpected_error;
754:
755: END IF;

Line 786: fnd_msg_pub.add;

782:
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784:
785: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
786: fnd_msg_pub.add;
787:
788: RAISE fnd_api.g_exc_unexpected_error;
789:
790: END IF;

Line 816: fnd_msg_pub.add;

812:
813: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_USAGE');
814: fnd_message.set_token('P_USAGE', l_usage);
815: fnd_message.set_token('P_GROUP_ID', l_group_id);
816: fnd_msg_pub.add;
817:
818: x_return_status := fnd_api.g_ret_sts_unexp_error;
819:
820: RAISE fnd_api.g_exc_unexpected_error;

Line 847: fnd_msg_pub.add;

843: CLOSE c_usage_name;
844:
845: fnd_message.set_name('JTF', 'JTF_RS_GRP_USAGE_DEL_ERROR');
846: fnd_message.set_token('P_USAGE', l_usage_name);
847: fnd_msg_pub.add;
848:
849: x_return_status := fnd_api.g_ret_sts_error;
850: RAISE fnd_api.g_exc_error;
851:

Line 873: fnd_msg_pub.add;

869:
870: x_return_status := fnd_api.g_ret_sts_unexp_error;
871:
872: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
873: fnd_msg_pub.add;
874:
875: RAISE fnd_api.g_exc_unexpected_error;
876:
877: END;

Line 900: fnd_msg_pub.add;

896:
897: x_return_status := fnd_api.g_ret_sts_unexp_error;
898:
899: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
900: fnd_msg_pub.add;
901:
902: RAISE fnd_api.g_exc_unexpected_error;
903:
904: END;

Line 937: fnd_msg_pub.add;

933:
934: x_return_status := fnd_api.g_ret_sts_unexp_error;
935:
936: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
937: fnd_msg_pub.add;
938:
939: RAISE fnd_api.g_exc_unexpected_error;
940:
941: END IF;

Line 974: fnd_msg_pub.add;

970:
971: x_return_status := fnd_api.g_ret_sts_unexp_error;
972:
973: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
974: fnd_msg_pub.add;
975:
976: RAISE fnd_api.g_exc_unexpected_error;
977:
978: END IF;

Line 1009: fnd_msg_pub.add;

1005:
1006: x_return_status := fnd_api.g_ret_sts_unexp_error;
1007:
1008: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1009: fnd_msg_pub.add;
1010:
1011: RAISE fnd_api.g_exc_unexpected_error;
1012:
1013: END IF;

Line 1066: fnd_msg_pub.add;

1062:
1063: x_return_status := fnd_api.g_ret_sts_unexp_error;
1064:
1065: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1066: fnd_msg_pub.add;
1067:
1068: RAISE fnd_api.g_exc_unexpected_error;
1069:
1070: END IF;

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

1080: COMMIT WORK;
1081:
1082: END IF;
1083:
1084: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1085:
1086:
1087: EXCEPTION
1088:

Line 1094: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1090: WHEN fnd_api.g_exc_error THEN
1091:
1092: ROLLBACK TO delete_group_usage_pvt;
1093: x_return_status := fnd_api.g_ret_sts_error;
1094: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1095:
1096: WHEN fnd_api.g_exc_unexpected_error THEN
1097:
1098: -- DBMS_OUTPUT.put_line (' ========================================== ');

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

1102: ROLLBACK TO delete_group_usage_pvt;
1103:
1104: x_return_status := fnd_api.g_ret_sts_unexp_error;
1105:
1106: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1107:
1108:
1109: WHEN OTHERS THEN
1110:

Line 1123: FND_MSG_PUB.add;

1119: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1120: fnd_message.set_token('P_SQLCODE',SQLCODE);
1121: fnd_message.set_token('P_SQLERRM',SQLERRM);
1122: fnd_message.set_token('P_API_NAME',l_api_name);
1123: FND_MSG_PUB.add;
1124:
1125: x_return_status := fnd_api.g_ret_sts_unexp_error;
1126:
1127: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1123: FND_MSG_PUB.add;
1124:
1125: x_return_status := fnd_api.g_ret_sts_unexp_error;
1126:
1127: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1128:
1129:
1130: END delete_group_usage;
1131: