DBA Data[Home] [Help]

APPS.JTF_RS_TEAM_MEMBERS_PVT dependencies on FND_MSG_PUB

Line 105: fnd_msg_pub.initialize;

101:
102:
103: IF fnd_api.to_boolean(p_init_msg_list) THEN
104:
105: fnd_msg_pub.initialize;
106:
107: END IF;
108:
109:

Line 141: fnd_msg_pub.add;

137:
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139:
140: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
141: fnd_msg_pub.add;
142:
143: RAISE fnd_api.g_exc_unexpected_error;
144:
145: END IF;

Line 179: fnd_msg_pub.add;

175:
176: x_return_status := fnd_api.g_ret_sts_unexp_error;
177:
178: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
179: fnd_msg_pub.add;
180:
181: RAISE fnd_api.g_exc_unexpected_error;
182:
183: END IF;

Line 215: fnd_msg_pub.add;

211:
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213:
214: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
215: fnd_msg_pub.add;
216:
217: RAISE fnd_api.g_exc_unexpected_error;
218:
219: END IF;

Line 244: fnd_msg_pub.add;

240:
241: x_return_status := fnd_api.g_ret_sts_error;
242:
243: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_TEAM');
244: fnd_msg_pub.add;
245:
246: RAISE fnd_api.g_exc_unexpected_error;
247:
248: END IF;

Line 326: fnd_msg_pub.add;

322:
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324:
325: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
326: fnd_msg_pub.add;
327:
328: IF c_jtf_rs_team_members%ISOPEN THEN
329:
330: CLOSE c_jtf_rs_team_members;

Line 391: fnd_msg_pub.add;

387:
388: x_return_status := fnd_api.g_ret_sts_unexp_error;
389:
390: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
391: fnd_msg_pub.add;
392:
393: RAISE fnd_api.g_exc_unexpected_error;
394:
395: END IF;

Line 430: fnd_msg_pub.add;

426:
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
430: fnd_msg_pub.add;
431:
432: RAISE fnd_api.g_exc_unexpected_error;
433:
434: END IF;

Line 467: fnd_msg_pub.add;

463:
464: x_return_status := fnd_api.g_ret_sts_unexp_error;
465:
466: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
467: fnd_msg_pub.add;
468:
469: RAISE fnd_api.g_exc_unexpected_error;
470:
471: END IF;

Line 524: fnd_msg_pub.add;

520:
521: x_return_status := fnd_api.g_ret_sts_unexp_error;
522:
523: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
524: fnd_msg_pub.add;
525:
526: RAISE fnd_api.g_exc_unexpected_error;
527:
528: END IF;

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

562: COMMIT WORK;
563:
564: END IF;
565:
566: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
567:
568:
569: EXCEPTION
570:

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

578: ROLLBACK TO create_resource_member_pvt;
579:
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581:
582: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
583:
584:
585: WHEN OTHERS THEN
586:

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

593: ROLLBACK TO create_resource_member_pvt;
594:
595: x_return_status := fnd_api.g_ret_sts_unexp_error;
596:
597: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
598:
599:
600: END create_resource_team_members;
601:

Line 729: fnd_msg_pub.initialize;

725: RAISE fnd_api.g_exc_unexpected_error;
726: END IF;
727:
728: IF fnd_api.to_boolean(p_init_msg_list) THEN
729: fnd_msg_pub.initialize;
730: END IF;
731:
732: /* Make the pre processing call to the user hooks */
733:

Line 756: fnd_msg_pub.add;

752: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
753: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
756: fnd_msg_pub.add;
757: RAISE fnd_api.g_exc_unexpected_error;
758: END IF;
759: END IF;
760: END IF;

Line 784: fnd_msg_pub.add;

780: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
781: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
782: x_return_status := fnd_api.g_ret_sts_unexp_error;
783: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
784: fnd_msg_pub.add;
785: RAISE fnd_api.g_exc_unexpected_error;
786: END IF;
787: END IF;
788: END IF;

Line 810: fnd_msg_pub.add;

806: x_return_status => x_return_status);
807: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
808: x_return_status := fnd_api.g_ret_sts_unexp_error;
809: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
810: fnd_msg_pub.add;
811: RAISE fnd_api.g_exc_unexpected_error;
812: END IF;
813: END IF;
814: END IF;

Line 825: fnd_msg_pub.add;

821: IF c_rs_team_members_update%NOTFOUND THEN
822: CLOSE c_rs_team_members_update ;
823: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_MBR_ID');
824: fnd_message.set_token('P_TEAM_MBR_ID', p_team_member_id);
825: fnd_msg_pub.add;
826: x_return_status := fnd_api.g_ret_sts_unexp_error;
827: RAISE fnd_api.g_exc_unexpected_error;
828: END IF ;
829:

Line 840: fnd_msg_pub.add;

836: WHEN OTHERS THEN
837: x_return_status := fnd_api.g_ret_sts_unexp_error;
838:
839: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
840: fnd_msg_pub.add;
841:
842: RAISE fnd_api.g_exc_unexpected_error;
843: END;
844:

Line 887: fnd_msg_pub.add ;

883: WHEN NO_DATA_FOUND THEN
884: CLOSE c_rs_team_members_update ;
885: x_return_status := fnd_api.g_ret_sts_unexp_error ;
886: fnd_message.set_name('JTF','JTF_RS_TABLE_HANDLER_ERROR') ;
887: fnd_msg_pub.add ;
888: RAISE fnd_api.g_exc_unexpected_error ;
889: END ;
890:
891: IF c_rs_team_members_update%ISOPEN THEN

Line 918: fnd_msg_pub.add;

914:
915: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
916: x_return_status := fnd_api.g_ret_sts_unexp_error;
917: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
918: fnd_msg_pub.add;
919: RAISE fnd_api.g_exc_unexpected_error;
920: END IF;
921: END IF;
922: END IF;

Line 946: fnd_msg_pub.add;

942: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
943: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
944: x_return_status := fnd_api.g_ret_sts_unexp_error;
945: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
946: fnd_msg_pub.add;
947: RAISE fnd_api.g_exc_unexpected_error;
948: END IF;
949: END IF;
950: END IF;

Line 973: fnd_msg_pub.add;

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

Line 1021: fnd_msg_pub.add;

1017: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1018: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1019: x_return_status := fnd_api.g_ret_sts_unexp_error;
1020: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1021: fnd_msg_pub.add;
1022: RAISE fnd_api.g_exc_unexpected_error;
1023: END IF;
1024: END IF;
1025: END IF;

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

1028: IF fnd_api.to_boolean(p_commit) THEN
1029: COMMIT WORK;
1030: END IF;
1031:
1032: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1033:
1034: EXCEPTION
1035: WHEN fnd_api.g_exc_unexpected_error THEN
1036: ROLLBACK TO update_resource_member_pvt;

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

1034: EXCEPTION
1035: WHEN fnd_api.g_exc_unexpected_error THEN
1036: ROLLBACK TO update_resource_member_pvt;
1037: x_return_status := fnd_api.g_ret_sts_unexp_error;
1038: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1039: WHEN OTHERS THEN
1040: ROLLBACK TO update_resource_member_pvt;
1041: fnd_message.set_token('P_SQLCODE',SQLCODE) ;
1042: fnd_message.set_token('P_SQLERRM',SQLERRM) ;

Line 1044: fnd_msg_pub.add ;

1040: ROLLBACK TO update_resource_member_pvt;
1041: fnd_message.set_token('P_SQLCODE',SQLCODE) ;
1042: fnd_message.set_token('P_SQLERRM',SQLERRM) ;
1043: fnd_message.set_token('P_API_NAME',l_api_name) ;
1044: fnd_msg_pub.add ;
1045: x_return_status := fnd_api.g_ret_sts_unexp_error;
1046: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1047: END update_resource_team_members;
1048:

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

1042: fnd_message.set_token('P_SQLERRM',SQLERRM) ;
1043: fnd_message.set_token('P_API_NAME',l_api_name) ;
1044: fnd_msg_pub.add ;
1045: x_return_status := fnd_api.g_ret_sts_unexp_error;
1046: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1047: END update_resource_team_members;
1048:
1049: /* Procedure to delete the resource team members. */
1050:

Line 1125: fnd_msg_pub.initialize;

1121:
1122:
1123: IF fnd_api.to_boolean(p_init_msg_list) THEN
1124:
1125: fnd_msg_pub.initialize;
1126:
1127: END IF;
1128:
1129:

Line 1160: fnd_msg_pub.add;

1156:
1157: x_return_status := fnd_api.g_ret_sts_unexp_error;
1158:
1159: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1160: fnd_msg_pub.add;
1161:
1162: RAISE fnd_api.g_exc_unexpected_error;
1163:
1164: END IF;

Line 1198: fnd_msg_pub.add;

1194:
1195: x_return_status := fnd_api.g_ret_sts_unexp_error;
1196:
1197: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1198: fnd_msg_pub.add;
1199:
1200: RAISE fnd_api.g_exc_unexpected_error;
1201:
1202: END IF;

Line 1234: fnd_msg_pub.add;

1230:
1231: x_return_status := fnd_api.g_ret_sts_unexp_error;
1232:
1233: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1234: fnd_msg_pub.add;
1235:
1236: RAISE fnd_api.g_exc_unexpected_error;
1237:
1238: END IF;

Line 1264: fnd_msg_pub.add;

1260: END IF;
1261:
1262: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_MEMBER');
1263: fnd_message.set_token('P_TEAM_RESOURCE_ID', l_team_resource_id);
1264: fnd_msg_pub.add;
1265:
1266: x_return_status := fnd_api.g_ret_sts_unexp_error;
1267:
1268: RAISE fnd_api.g_exc_unexpected_error;

Line 1301: fnd_msg_pub.add;

1297:
1298: END IF;
1299:
1300: fnd_message.set_name('JTF', 'JTF_RS_ERROR_ROLE_COUNT');
1301: fnd_msg_pub.add;
1302:
1303: x_return_status := fnd_api.g_ret_sts_unexp_error;
1304:
1305: RAISE fnd_api.g_exc_unexpected_error;

Line 1320: fnd_msg_pub.add;

1316:
1317: END IF;
1318:
1319: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TEAM_ROLE_EXIST');
1320: fnd_msg_pub.add;
1321:
1322: x_return_status := fnd_api.g_ret_sts_unexp_error;
1323:
1324: RAISE fnd_api.g_exc_unexpected_error;

Line 1351: fnd_msg_pub.add;

1347:
1348: x_return_status := fnd_api.g_ret_sts_unexp_error;
1349:
1350: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1351: fnd_msg_pub.add;
1352:
1353: RAISE fnd_api.g_exc_unexpected_error;
1354:
1355: END;

Line 1402: fnd_msg_pub.add;

1398:
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400:
1401: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1402: fnd_msg_pub.add;
1403:
1404: RAISE fnd_api.g_exc_unexpected_error;
1405:
1406: END;

Line 1439: fnd_msg_pub.add;

1435:
1436: x_return_status := fnd_api.g_ret_sts_unexp_error;
1437:
1438: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1439: fnd_msg_pub.add;
1440:
1441: RAISE fnd_api.g_exc_unexpected_error;
1442:
1443: END IF;

Line 1477: fnd_msg_pub.add;

1473:
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475:
1476: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1477: fnd_msg_pub.add;
1478:
1479: RAISE fnd_api.g_exc_unexpected_error;
1480:
1481: END IF;

Line 1515: fnd_msg_pub.add;

1511:
1512: x_return_status := fnd_api.g_ret_sts_unexp_error;
1513:
1514: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1515: fnd_msg_pub.add;
1516:
1517: RAISE fnd_api.g_exc_unexpected_error;
1518:
1519: END IF;

Line 1572: fnd_msg_pub.add;

1568:
1569: x_return_status := fnd_api.g_ret_sts_unexp_error;
1570:
1571: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1572: fnd_msg_pub.add;
1573:
1574: RAISE fnd_api.g_exc_unexpected_error;
1575:
1576: END IF;

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

1586: COMMIT WORK;
1587:
1588: END IF;
1589:
1590: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1591:
1592:
1593: EXCEPTION
1594:

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

1602: ROLLBACK TO delete_resource_member_pvt;
1603:
1604: x_return_status := fnd_api.g_ret_sts_unexp_error;
1605:
1606: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1607:
1608:
1609: WHEN OTHERS THEN
1610:

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

1617: ROLLBACK TO delete_resource_member_pvt;
1618:
1619: x_return_status := fnd_api.g_ret_sts_unexp_error;
1620:
1621: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1622:
1623:
1624: END delete_resource_team_members;
1625: