DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PVT dependencies on FND_MSG_PUB

Line 104: fnd_msg_pub.initialize;

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

Line 139: fnd_msg_pub.add;

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
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 182: fnd_msg_pub.add;

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;
186: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 227: fnd_msg_pub.add;

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;
231: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 268: fnd_msg_pub.add;

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:
272: /* This portion of the code was modified to accomodate the calls to Migration API */

Line 398: fnd_msg_pub.add;

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

Line 477: fnd_msg_pub.add;

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;
481: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 516: fnd_msg_pub.add;

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;
520: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 556: fnd_msg_pub.add;

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;
560: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 609: fnd_msg_pub.add;

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;
613: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

644: COMMIT WORK;
645:
646: END IF;
647:
648: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
649:
650: EXCEPTION
651:
652:

Line 656: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

652:
653: WHEN fnd_api.g_exc_error THEN
654: ROLLBACK TO create_resource_group_pvt;
655: x_return_status := fnd_api.g_ret_sts_error;
656: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
657: p_data => x_msg_data);
658: WHEN fnd_api.g_exc_unexpected_error THEN
659: ROLLBACK TO create_resource_group_pvt;
660: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 661: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

657: p_data => x_msg_data);
658: WHEN fnd_api.g_exc_unexpected_error THEN
659: ROLLBACK TO create_resource_group_pvt;
660: x_return_status := fnd_api.g_ret_sts_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');

Line 669: FND_MSG_PUB.add;

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

Line 671: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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);
673:
674: END create_resource_group;
675:

Line 1015: fnd_msg_pub.initialize;

1011:
1012:
1013: IF fnd_api.to_boolean(p_init_msg_list) THEN
1014:
1015: fnd_msg_pub.initialize;
1016:
1017: END IF;
1018:
1019: /* Make the pre processing call to the user hooks */

Line 1052: fnd_msg_pub.add;

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;
1056: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1099: fnd_msg_pub.add;

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;
1103: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1144: fnd_msg_pub.add;

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;
1148: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1174: fnd_msg_pub.add;

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:
1178: END IF;

Line 1190: fnd_msg_pub.add;

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:
1194: /* Validate that the Group Name is specified */

Line 1201: fnd_msg_pub.add;

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:
1205: END IF;

Line 1249: fnd_msg_pub.add;

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

Line 1259: fnd_msg_pub.add;

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:
1263: END IF;

Line 1291: fnd_msg_pub.add;

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

Line 1301: fnd_msg_pub.add;

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

Line 1337: fnd_msg_pub.add;

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:
1341: END IF;

Line 1346: fnd_msg_pub.add;

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

Line 1379: fnd_msg_pub.add;

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

Line 1389: fnd_msg_pub.add;

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

Line 1425: fnd_msg_pub.add;

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

Line 1435: fnd_msg_pub.add;

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

Line 1468: fnd_msg_pub.add;

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:
1472: END IF;

Line 1477: fnd_msg_pub.add;

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:
1481: END IF;

Line 1512: fnd_msg_pub.add;

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:
1516: END IF;

Line 1521: fnd_msg_pub.add;

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:
1525: END IF;

Line 1553: fnd_msg_pub.add;

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:
1557: END IF;

Line 1562: fnd_msg_pub.add;

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:
1566: END IF;

Line 1623: fnd_msg_pub.add;

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:
1627: END IF;

Line 1658: fnd_msg_pub.add;

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

Line 1784: fnd_msg_pub.add;

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

Line 1860: fnd_msg_pub.add;

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
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1905: fnd_msg_pub.add;

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;
1909: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1950: fnd_msg_pub.add;

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;
1954: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2010: fnd_msg_pub.add;

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;
2014: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

2028: COMMIT WORK;
2029:
2030: END IF;
2031:
2032: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2033:
2034:
2035: EXCEPTION
2036:

Line 2040: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2036:
2037: WHEN fnd_api.g_exc_error THEN
2038: ROLLBACK TO update_resource_group_pvt;
2039: x_return_status := fnd_api.g_ret_sts_error;
2040: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2041: p_data => x_msg_data);
2042: WHEN fnd_api.g_exc_unexpected_error THEN
2043: ROLLBACK TO update_resource_group_pvt;
2044: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2045: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

2041: p_data => x_msg_data);
2042: WHEN fnd_api.g_exc_unexpected_error THEN
2043: ROLLBACK TO update_resource_group_pvt;
2044: x_return_status := fnd_api.g_ret_sts_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');

Line 2053: FND_MSG_PUB.add;

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

Line 2055: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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);
2057:
2058: END update_resource_group;
2059: