DBA Data[Home] [Help]

APPS.JTF_RS_TEAM_MEMBERS_PVT dependencies on FND_MESSAGE

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

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

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

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

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

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

Line 243: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS_TEAM');

239: -- dbms_output.put_line('Resource already exists in the team');
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:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

805: p_team_member_id => l_team_member_id,
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;

Line 823: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_MBR_ID');

819: FETCH c_rs_team_members_update
820: INTO rs_team_member_rec ;
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;

Line 824: fnd_message.set_token('P_TEAM_MBR_ID', p_team_member_id);

820: INTO rs_team_member_rec ;
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 ;

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

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

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

882: EXCEPTION
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:

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

913: x_return_status => x_return_status);
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;

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

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

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

968: x_return_status => x_return_status);
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1262: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TEAM_MEMBER');

1258: CLOSE c_team_member_id;
1259:
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;

Line 1263: fnd_message.set_token('P_TEAM_RESOURCE_ID', l_team_resource_id);

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

Line 1300: fnd_message.set_name('JTF', 'JTF_RS_ERROR_ROLE_COUNT');

1296: CLOSE c_related_role_count;
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:

Line 1319: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_TEAM_ROLE_EXIST');

1315: CLOSE c_related_role_count;
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:

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

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

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

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

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

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

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

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

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

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

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

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