DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PVT dependencies on FND_MESSAGE

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

132: x_return_status => x_return_status);
133:
134: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
135:
136: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
137: fnd_msg_pub.add;
138: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

175: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
176:
177: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
178:
179: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
180: fnd_msg_pub.add;
181:
182: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;

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

220:
221: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
222:
223:
224: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
225: fnd_msg_pub.add;
226:
227: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
228: RAISE FND_API.G_EXC_ERROR;

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

376:
377: END IF;
378:
379:
380: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
381: fnd_msg_pub.add;
382:
383: RAISE fnd_api.g_exc_error;
384:

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

455:
456: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
457:
458:
459: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
460: fnd_msg_pub.add;
461:
462: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
463: RAISE FND_API.G_EXC_ERROR;

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

494:
495: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
496:
497:
498: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
499: fnd_msg_pub.add;
500:
501: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
502: RAISE FND_API.G_EXC_ERROR;

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

534:
535: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
536:
537:
538: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
539: fnd_msg_pub.add;
540:
541: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
542: RAISE FND_API.G_EXC_ERROR;

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

587:
588: -- dbms_output.put_line('Returned Error status from the Message Generation API');
589:
590:
591: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
592: fnd_msg_pub.add;
593:
594: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
595: RAISE FND_API.G_EXC_ERROR;

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

644: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
645: p_data => x_msg_data);
646: WHEN OTHERS THEN
647: ROLLBACK TO create_resource_group_pvt;
648: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
649: fnd_message.set_token('P_SQLCODE',SQLCODE);
650: fnd_message.set_token('P_SQLERRM',SQLERRM);
651: fnd_message.set_token('P_API_NAME', l_api_name);
652: FND_MSG_PUB.add;

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

645: p_data => x_msg_data);
646: WHEN OTHERS THEN
647: ROLLBACK TO create_resource_group_pvt;
648: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
649: fnd_message.set_token('P_SQLCODE',SQLCODE);
650: fnd_message.set_token('P_SQLERRM',SQLERRM);
651: fnd_message.set_token('P_API_NAME', l_api_name);
652: FND_MSG_PUB.add;
653: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

646: WHEN OTHERS THEN
647: ROLLBACK TO create_resource_group_pvt;
648: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
649: fnd_message.set_token('P_SQLCODE',SQLCODE);
650: fnd_message.set_token('P_SQLERRM',SQLERRM);
651: fnd_message.set_token('P_API_NAME', l_api_name);
652: FND_MSG_PUB.add;
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

647: ROLLBACK TO create_resource_group_pvt;
648: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
649: fnd_message.set_token('P_SQLCODE',SQLCODE);
650: fnd_message.set_token('P_SQLERRM',SQLERRM);
651: fnd_message.set_token('P_API_NAME', l_api_name);
652: FND_MSG_PUB.add;
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
655: p_data => x_msg_data);

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

1025: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1026:
1027: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1028:
1029: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1030: fnd_msg_pub.add;
1031:
1032: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1033: RAISE FND_API.G_EXC_ERROR;

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

1072:
1073: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1074:
1075:
1076: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1077: fnd_msg_pub.add;
1078:
1079: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1080: RAISE FND_API.G_EXC_ERROR;

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

1117:
1118: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1119:
1120:
1121: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1122: fnd_msg_pub.add;
1123:
1124: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1125: RAISE FND_API.G_EXC_ERROR;

Line 1150: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');

1146: CLOSE c_group_update;
1147:
1148: END IF;
1149:
1150: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
1151: fnd_message.set_token('P_GROUP_ID', l_group_id);
1152: fnd_msg_pub.add;
1153:
1154: RAISE fnd_api.g_exc_error;

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

1147:
1148: END IF;
1149:
1150: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
1151: fnd_message.set_token('P_GROUP_ID', l_group_id);
1152: fnd_msg_pub.add;
1153:
1154: RAISE fnd_api.g_exc_error;
1155:

Line 1164: fnd_message.set_name('JTF', 'JTF_RS_GROUP_NAME_NULL');

1160: IF group_rec.group_name IS NULL THEN
1161:
1162: -- dbms_output.put_line('Group Name cannot be null');
1163:
1164: fnd_message.set_name('JTF', 'JTF_RS_GROUP_NAME_NULL');
1165: fnd_msg_pub.add;
1166:
1167: RAISE fnd_api.g_exc_error;
1168:

Line 1212: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');

1208: IF l_min_start_date IS NOT NULL THEN
1209:
1210: IF l_min_start_date < l_start_date_active THEN
1211:
1212: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1213: fnd_msg_pub.add;
1214:
1215: RAISE fnd_api.g_exc_error;
1216:

Line 1222: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');

1218: END IF;
1219:
1220: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN
1221:
1222: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1223: fnd_msg_pub.add;
1224:
1225: RAISE fnd_api.g_exc_error;
1226:

Line 1254: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');

1250: IF l_min_start_date IS NOT NULL THEN
1251:
1252: IF l_min_start_date < l_start_date_active THEN
1253:
1254: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1255: fnd_msg_pub.add;
1256:
1257: RAISE fnd_api.g_exc_error;
1258:

Line 1264: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');

1260: END IF;
1261:
1262: IF l_end_date_active IS NOT NULL THEN
1263:
1264: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1265: fnd_msg_pub.add;
1266:
1267: RAISE fnd_api.g_exc_error;
1268:

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

1296: IF l_min_start_date IS NOT NULL THEN
1297:
1298: IF l_min_start_date < l_start_date_active THEN
1299:
1300: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');
1301: fnd_msg_pub.add;
1302:
1303: RAISE fnd_api.g_exc_error;
1304:

Line 1309: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');

1305: END IF;
1306:
1307: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN
1308:
1309: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');
1310: fnd_msg_pub.add;
1311:
1312: RAISE fnd_api.g_exc_error;
1313:

Line 1342: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');

1338: IF l_min_start_date IS NOT NULL THEN
1339:
1340: IF l_min_start_date < l_start_date_active THEN
1341:
1342: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');
1343: fnd_msg_pub.add;
1344:
1345: RAISE fnd_api.g_exc_error;
1346:

Line 1352: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');

1348: END IF;
1349:
1350: IF l_end_date_active IS NOT NULL THEN
1351:
1352: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');
1353: fnd_msg_pub.add;
1354:
1355: RAISE fnd_api.g_exc_error;
1356:

Line 1388: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');

1384: IF l_min_start_date IS NOT NULL THEN
1385:
1386: IF l_min_start_date < l_start_date_active THEN
1387:
1388: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');
1389: fnd_msg_pub.add;
1390:
1391: RAISE fnd_api.g_exc_error;
1392:

Line 1398: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');

1394: END IF;
1395:
1396: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN
1397:
1398: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');
1399: fnd_msg_pub.add;
1400:
1401: RAISE fnd_api.g_exc_error;
1402:

Line 1431: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');

1427: IF l_min_start_date IS NOT NULL THEN
1428:
1429: IF l_min_start_date < l_start_date_active THEN
1430:
1431: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');
1432: fnd_msg_pub.add;
1433:
1434: RAISE fnd_api.g_exc_error;
1435:

Line 1440: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');

1436: END IF;
1437:
1438: IF l_end_date_active IS NOT NULL THEN
1439:
1440: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');
1441: fnd_msg_pub.add;
1442:
1443: RAISE fnd_api.g_exc_error;
1444:

Line 1475: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');

1471: IF l_min_start_date IS NOT NULL THEN
1472:
1473: IF l_min_start_date < l_start_date_active THEN
1474:
1475: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1476: fnd_msg_pub.add;
1477:
1478: RAISE fnd_api.g_exc_error;
1479:

Line 1484: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');

1480: END IF;
1481:
1482: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN
1483:
1484: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1485: fnd_msg_pub.add;
1486:
1487: RAISE fnd_api.g_exc_error;
1488:

Line 1516: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');

1512: IF l_min_start_date IS NOT NULL THEN
1513:
1514: IF l_min_start_date < l_start_date_active THEN
1515:
1516: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1517: fnd_msg_pub.add;
1518:
1519: RAISE fnd_api.g_exc_error;
1520:

Line 1525: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');

1521: END IF;
1522:
1523: IF l_end_date_active IS NOT NULL THEN
1524:
1525: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1526: fnd_msg_pub.add;
1527:
1528: RAISE fnd_api.g_exc_error;
1529:

Line 1569: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_GROUP');

1565: CLOSE c_exclusive_group_check;
1566:
1567: END IF;
1568:
1569: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_GROUP');
1570: fnd_msg_pub.add;
1571:
1572: RAISE fnd_api.g_exc_error;
1573:

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

1600:
1601: -- dbms_output.put_line('Error in Locking the Row');
1602:
1603:
1604: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1605: fnd_msg_pub.add;
1606:
1607: RAISE fnd_api.g_exc_error;
1608:

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

1724:
1725: END IF;
1726:
1727:
1728: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1729: fnd_msg_pub.add;
1730:
1731: RAISE fnd_api.g_exc_error;
1732:

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

1800:
1801: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1802:
1803:
1804: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1805: fnd_msg_pub.add;
1806: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1845:
1846: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1847:
1848:
1849: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1850: fnd_msg_pub.add;
1851:
1852: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1853: RAISE FND_API.G_EXC_ERROR;

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

1890:
1891: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1892:
1893:
1894: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1895: fnd_msg_pub.add;
1896:
1897: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1898: RAISE FND_API.G_EXC_ERROR;

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

1950:
1951: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1952:
1953:
1954: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1955: fnd_msg_pub.add;
1956:
1957: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1958: RAISE FND_API.G_EXC_ERROR;

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

1990: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1991: p_data => x_msg_data);
1992: WHEN OTHERS THEN
1993: ROLLBACK TO update_resource_group_pvt;
1994: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1995: fnd_message.set_token('P_SQLCODE',SQLCODE);
1996: fnd_message.set_token('P_SQLERRM',SQLERRM);
1997: fnd_message.set_token('P_API_NAME', l_api_name);
1998: FND_MSG_PUB.add;

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

1991: p_data => x_msg_data);
1992: WHEN OTHERS THEN
1993: ROLLBACK TO update_resource_group_pvt;
1994: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1995: fnd_message.set_token('P_SQLCODE',SQLCODE);
1996: fnd_message.set_token('P_SQLERRM',SQLERRM);
1997: fnd_message.set_token('P_API_NAME', l_api_name);
1998: FND_MSG_PUB.add;
1999: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1992: WHEN OTHERS THEN
1993: ROLLBACK TO update_resource_group_pvt;
1994: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1995: fnd_message.set_token('P_SQLCODE',SQLCODE);
1996: fnd_message.set_token('P_SQLERRM',SQLERRM);
1997: fnd_message.set_token('P_API_NAME', l_api_name);
1998: FND_MSG_PUB.add;
1999: x_return_status := fnd_api.g_ret_sts_unexp_error;
2000: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

1993: ROLLBACK TO update_resource_group_pvt;
1994: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1995: fnd_message.set_token('P_SQLCODE',SQLCODE);
1996: fnd_message.set_token('P_SQLERRM',SQLERRM);
1997: fnd_message.set_token('P_API_NAME', l_api_name);
1998: FND_MSG_PUB.add;
1999: x_return_status := fnd_api.g_ret_sts_unexp_error;
2000: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2001: p_data => x_msg_data);