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