DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PVT dependencies on FND_MESSAGE

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

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

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

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

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

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

Line 267: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');

263: value before creating Resource Group.
264: */
265:
266: IF l_exclusive_flag <> 'Y' AND l_exclusive_flag <> 'N' THEN
267: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
268: fnd_msg_pub.add;
269: RAISE fnd_api.g_exc_error;
270: END IF;
271:

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

393:
394: END IF;
395:
396:
397: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
398: fnd_msg_pub.add;
399:
400: RAISE fnd_api.g_exc_error;
401:

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

472:
473: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
474:
475:
476: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
477: fnd_msg_pub.add;
478:
479: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
480: RAISE FND_API.G_EXC_ERROR;

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

511:
512: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
513:
514:
515: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
516: fnd_msg_pub.add;
517:
518: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
519: RAISE FND_API.G_EXC_ERROR;

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

551:
552: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
553:
554:
555: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
556: fnd_msg_pub.add;
557:
558: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
559: RAISE FND_API.G_EXC_ERROR;

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

604:
605: -- dbms_output.put_line('Returned Error status from the Message Generation API');
606:
607:
608: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
609: fnd_msg_pub.add;
610:
611: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
612: RAISE FND_API.G_EXC_ERROR;

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

661: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
662: p_data => x_msg_data);
663: WHEN OTHERS THEN
664: ROLLBACK TO create_resource_group_pvt;
665: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
666: fnd_message.set_token('P_SQLCODE',SQLCODE);
667: fnd_message.set_token('P_SQLERRM',SQLERRM);
668: fnd_message.set_token('P_API_NAME', l_api_name);
669: FND_MSG_PUB.add;

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

662: p_data => x_msg_data);
663: WHEN OTHERS THEN
664: ROLLBACK TO create_resource_group_pvt;
665: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
666: fnd_message.set_token('P_SQLCODE',SQLCODE);
667: fnd_message.set_token('P_SQLERRM',SQLERRM);
668: fnd_message.set_token('P_API_NAME', l_api_name);
669: FND_MSG_PUB.add;
670: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

663: WHEN OTHERS THEN
664: ROLLBACK TO create_resource_group_pvt;
665: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
666: fnd_message.set_token('P_SQLCODE',SQLCODE);
667: fnd_message.set_token('P_SQLERRM',SQLERRM);
668: fnd_message.set_token('P_API_NAME', l_api_name);
669: FND_MSG_PUB.add;
670: x_return_status := fnd_api.g_ret_sts_unexp_error;
671: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

664: ROLLBACK TO create_resource_group_pvt;
665: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
666: fnd_message.set_token('P_SQLCODE',SQLCODE);
667: fnd_message.set_token('P_SQLERRM',SQLERRM);
668: fnd_message.set_token('P_API_NAME', l_api_name);
669: FND_MSG_PUB.add;
670: x_return_status := fnd_api.g_ret_sts_unexp_error;
671: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
672: p_data => x_msg_data);

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

1047: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1048:
1049: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1050:
1051: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1052: fnd_msg_pub.add;
1053:
1054: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1055: RAISE FND_API.G_EXC_ERROR;

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

1094:
1095: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1096:
1097:
1098: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1099: fnd_msg_pub.add;
1100:
1101: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1102: RAISE FND_API.G_EXC_ERROR;

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

1139:
1140: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1141:
1142:
1143: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1144: fnd_msg_pub.add;
1145:
1146: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1147: RAISE FND_API.G_EXC_ERROR;

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

1168: CLOSE c_group_update;
1169:
1170: END IF;
1171:
1172: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
1173: fnd_message.set_token('P_GROUP_ID', l_group_id);
1174: fnd_msg_pub.add;
1175:
1176: RAISE fnd_api.g_exc_error;

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

1169:
1170: END IF;
1171:
1172: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
1173: fnd_message.set_token('P_GROUP_ID', l_group_id);
1174: fnd_msg_pub.add;
1175:
1176: RAISE fnd_api.g_exc_error;
1177:

Line 1189: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');

1185: value before creating Resource Group.
1186: */
1187:
1188: IF group_rec.exclusive_flag <> 'Y' AND group_rec.exclusive_flag <> 'N' AND group_rec.exclusive_flag <> fnd_api.g_miss_char THEN
1189: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
1190: fnd_msg_pub.add;
1191: RAISE fnd_api.g_exc_error;
1192: END IF;
1193:

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

1196: IF group_rec.group_name IS NULL THEN
1197:
1198: -- dbms_output.put_line('Group Name cannot be null');
1199:
1200: fnd_message.set_name('JTF', 'JTF_RS_GROUP_NAME_NULL');
1201: fnd_msg_pub.add;
1202:
1203: RAISE fnd_api.g_exc_error;
1204:

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

1244: IF l_min_start_date IS NOT NULL THEN
1245:
1246: IF l_min_start_date < l_start_date_active THEN
1247:
1248: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1249: fnd_msg_pub.add;
1250:
1251: RAISE fnd_api.g_exc_error;
1252:

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

1254: END IF;
1255:
1256: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN
1257:
1258: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_END_DATE');
1259: fnd_msg_pub.add;
1260:
1261: RAISE fnd_api.g_exc_error;
1262:

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

1286: IF l_min_start_date IS NOT NULL THEN
1287:
1288: IF l_min_start_date < l_start_date_active THEN
1289:
1290: fnd_message.set_name('JTF', 'JTF_RS_ERR_ROLE_START_DATE');
1291: fnd_msg_pub.add;
1292:
1293: RAISE fnd_api.g_exc_error;
1294:

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

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

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

1332: IF l_min_start_date IS NOT NULL THEN
1333:
1334: IF l_min_start_date < l_start_date_active THEN
1335:
1336: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');
1337: fnd_msg_pub.add;
1338:
1339: RAISE fnd_api.g_exc_error;
1340:

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

1341: END IF;
1342:
1343: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN
1344:
1345: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_END_DATE');
1346: fnd_msg_pub.add;
1347:
1348: RAISE fnd_api.g_exc_error;
1349:

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

1374: IF l_min_start_date IS NOT NULL THEN
1375:
1376: IF l_min_start_date < l_start_date_active THEN
1377:
1378: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_MBR_START_DATE');
1379: fnd_msg_pub.add;
1380:
1381: RAISE fnd_api.g_exc_error;
1382:

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

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

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

1420: IF l_min_start_date IS NOT NULL THEN
1421:
1422: IF l_min_start_date < l_start_date_active THEN
1423:
1424: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');
1425: fnd_msg_pub.add;
1426:
1427: RAISE fnd_api.g_exc_error;
1428:

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

1430: END IF;
1431:
1432: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN
1433:
1434: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');
1435: fnd_msg_pub.add;
1436:
1437: RAISE fnd_api.g_exc_error;
1438:

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

1463: IF l_min_start_date IS NOT NULL THEN
1464:
1465: IF l_min_start_date < l_start_date_active THEN
1466:
1467: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_START_DATE');
1468: fnd_msg_pub.add;
1469:
1470: RAISE fnd_api.g_exc_error;
1471:

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

1472: END IF;
1473:
1474: IF l_end_date_active IS NOT NULL THEN
1475:
1476: fnd_message.set_name('JTF', 'JTF_RS_ERR_GRP_REL_END_DATE');
1477: fnd_msg_pub.add;
1478:
1479: RAISE fnd_api.g_exc_error;
1480:

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

1507: IF l_min_start_date IS NOT NULL THEN
1508:
1509: IF l_min_start_date < l_start_date_active THEN
1510:
1511: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1512: fnd_msg_pub.add;
1513:
1514: RAISE fnd_api.g_exc_error;
1515:

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

1516: END IF;
1517:
1518: IF ( l_max_end_date > l_end_date_active AND l_end_date_active IS NOT NULL ) THEN
1519:
1520: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1521: fnd_msg_pub.add;
1522:
1523: RAISE fnd_api.g_exc_error;
1524:

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

1548: IF l_min_start_date IS NOT NULL THEN
1549:
1550: IF l_min_start_date < l_start_date_active THEN
1551:
1552: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_START_DATE');
1553: fnd_msg_pub.add;
1554:
1555: RAISE fnd_api.g_exc_error;
1556:

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

1557: END IF;
1558:
1559: IF l_end_date_active IS NOT NULL THEN
1560:
1561: fnd_message.set_name('JTF', 'JTF_RS_ERR_TEAM_MBR_END_DATE');
1562: fnd_msg_pub.add;
1563:
1564: RAISE fnd_api.g_exc_error;
1565:

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

1618: CLOSE c_exclusive_group_check;
1619:
1620: END IF;
1621:
1622: fnd_message.set_name('JTF', 'JTF_RS_EXCLUSIVE_GROUP');
1623: fnd_msg_pub.add;
1624:
1625: RAISE fnd_api.g_exc_error;
1626:

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

1653:
1654: -- dbms_output.put_line('Error in Locking the Row');
1655:
1656:
1657: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1658: fnd_msg_pub.add;
1659:
1660: RAISE fnd_api.g_exc_error;
1661:

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

1779:
1780: END IF;
1781:
1782:
1783: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1784: fnd_msg_pub.add;
1785:
1786: RAISE fnd_api.g_exc_error;
1787:

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

1855:
1856: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1857:
1858:
1859: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1860: fnd_msg_pub.add;
1861: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1862: RAISE FND_API.G_EXC_ERROR;
1863: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1900:
1901: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1902:
1903:
1904: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1905: fnd_msg_pub.add;
1906:
1907: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;

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

1945:
1946: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1947:
1948:
1949: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1950: fnd_msg_pub.add;
1951:
1952: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1953: RAISE FND_API.G_EXC_ERROR;

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

2005:
2006: -- dbms_output.put_line('Returned Error status from the Message Generation API');
2007:
2008:
2009: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
2010: fnd_msg_pub.add;
2011:
2012: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2013: RAISE FND_API.G_EXC_ERROR;

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

2045: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2046: p_data => x_msg_data);
2047: WHEN OTHERS THEN
2048: ROLLBACK TO update_resource_group_pvt;
2049: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2050: fnd_message.set_token('P_SQLCODE',SQLCODE);
2051: fnd_message.set_token('P_SQLERRM',SQLERRM);
2052: fnd_message.set_token('P_API_NAME', l_api_name);
2053: FND_MSG_PUB.add;

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

2046: p_data => x_msg_data);
2047: WHEN OTHERS THEN
2048: ROLLBACK TO update_resource_group_pvt;
2049: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2050: fnd_message.set_token('P_SQLCODE',SQLCODE);
2051: fnd_message.set_token('P_SQLERRM',SQLERRM);
2052: fnd_message.set_token('P_API_NAME', l_api_name);
2053: FND_MSG_PUB.add;
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2047: WHEN OTHERS THEN
2048: ROLLBACK TO update_resource_group_pvt;
2049: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2050: fnd_message.set_token('P_SQLCODE',SQLCODE);
2051: fnd_message.set_token('P_SQLERRM',SQLERRM);
2052: fnd_message.set_token('P_API_NAME', l_api_name);
2053: FND_MSG_PUB.add;
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;
2055: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

2048: ROLLBACK TO update_resource_group_pvt;
2049: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2050: fnd_message.set_token('P_SQLCODE',SQLCODE);
2051: fnd_message.set_token('P_SQLERRM',SQLERRM);
2052: fnd_message.set_token('P_API_NAME', l_api_name);
2053: FND_MSG_PUB.add;
2054: x_return_status := fnd_api.g_ret_sts_unexp_error;
2055: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2056: p_data => x_msg_data);