DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_USAGES_PVT dependencies on FND_MESSAGE

Line 162: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

158: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
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:

Line 199: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

195: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
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:

Line 234: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

230: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
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:

Line 261: fnd_message.set_name('JTF', 'JTF_RS_USAGE_EXISTS');

257: -- dbms_output.put_line('Usage already assigned to the Group');
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:

Line 293: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_GROUP_ERR');

289: END IF;
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:

Line 362: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

358: -- dbms_output.put_line('Error in Table Handler');
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:

Line 421: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

417: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
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:

Line 459: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

455: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
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:

Line 495: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

491: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
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:

Line 552: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

548: -- dbms_output.put_line('Returned Error status from the Message Generation API');
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:

Line 600: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

596: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
597:
598: ROLLBACK TO create_rs_group_usage_pvt;
599:
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;

Line 601: fnd_message.set_token('P_SQLCODE',SQLCODE);

597:
598: ROLLBACK TO create_rs_group_usage_pvt;
599:
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:

Line 602: fnd_message.set_token('P_SQLERRM',SQLERRM);

598: ROLLBACK TO create_rs_group_usage_pvt;
599:
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;

Line 603: fnd_message.set_token('P_API_NAME',l_api_name);

599:
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:

Line 713: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

709: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
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:

Line 750: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

746: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
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:

Line 785: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

781: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
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:

Line 813: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_USAGE');

809: CLOSE c_group_usage_id;
810:
811: END IF;
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:

Line 814: fnd_message.set_token('P_USAGE', l_usage);

810:
811: END IF;
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;

Line 815: fnd_message.set_token('P_GROUP_ID', l_group_id);

811: END IF;
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:

Line 845: fnd_message.set_name('JTF', 'JTF_RS_GRP_USAGE_DEL_ERROR');

841: OPEN c_usage_name(l_usage);
842: FETCH c_usage_name INTO l_usage_name;
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;

Line 846: fnd_message.set_token('P_USAGE', l_usage_name);

842: FETCH c_usage_name INTO l_usage_name;
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;

Line 872: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

868: -- dbms_output.put_line('Error in Locking the Row');
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:

Line 899: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

895: -- dbms_output.put_line('Error in Table Handler');
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:

Line 936: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

932: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
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:

Line 973: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

969: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
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:

Line 1008: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

1004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
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:

Line 1065: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

1061: -- dbms_output.put_line('Returned Error status from the Message Generation API');
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:

Line 1119: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1115: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1116:
1117: ROLLBACK TO delete_group_usage_pvt;
1118:
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;

Line 1120: fnd_message.set_token('P_SQLCODE',SQLCODE);

1116:
1117: ROLLBACK TO delete_group_usage_pvt;
1118:
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:

Line 1121: fnd_message.set_token('P_SQLERRM',SQLERRM);

1117: ROLLBACK TO delete_group_usage_pvt;
1118:
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;

Line 1122: fnd_message.set_token('P_API_NAME',l_api_name);

1118:
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: