DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PVT dependencies on FND_MSG_PUB

Line 102: fnd_msg_pub.initialize;

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

Line 137: fnd_msg_pub.add;

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

Line 180: fnd_msg_pub.add;

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

Line 225: fnd_msg_pub.add;

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

Line 381: fnd_msg_pub.add;

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

Line 460: fnd_msg_pub.add;

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

Line 499: fnd_msg_pub.add;

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

Line 539: fnd_msg_pub.add;

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

Line 592: fnd_msg_pub.add;

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

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

627: COMMIT WORK;
628:
629: END IF;
630:
631: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
632:
633: EXCEPTION
634:
635:

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

635:
636: WHEN fnd_api.g_exc_error THEN
637: ROLLBACK TO create_resource_group_pvt;
638: x_return_status := fnd_api.g_ret_sts_error;
639: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
640: p_data => x_msg_data);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: ROLLBACK TO create_resource_group_pvt;
643: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

640: p_data => x_msg_data);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: ROLLBACK TO create_resource_group_pvt;
643: x_return_status := fnd_api.g_ret_sts_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');

Line 652: FND_MSG_PUB.add;

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

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

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);
656:
657: END create_resource_group;
658:

Line 993: fnd_msg_pub.initialize;

989:
990:
991: IF fnd_api.to_boolean(p_init_msg_list) THEN
992:
993: fnd_msg_pub.initialize;
994:
995: END IF;
996:
997: /* Make the pre processing call to the user hooks */

Line 1030: fnd_msg_pub.add;

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

Line 1077: fnd_msg_pub.add;

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

Line 1122: fnd_msg_pub.add;

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

Line 1152: fnd_msg_pub.add;

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

Line 1165: fnd_msg_pub.add;

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

Line 1213: fnd_msg_pub.add;

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

Line 1223: fnd_msg_pub.add;

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

Line 1255: fnd_msg_pub.add;

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

Line 1265: fnd_msg_pub.add;

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

Line 1301: fnd_msg_pub.add;

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

Line 1310: fnd_msg_pub.add;

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

Line 1343: fnd_msg_pub.add;

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

Line 1353: fnd_msg_pub.add;

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

Line 1389: fnd_msg_pub.add;

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

Line 1399: fnd_msg_pub.add;

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

Line 1432: fnd_msg_pub.add;

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

Line 1441: fnd_msg_pub.add;

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

Line 1476: fnd_msg_pub.add;

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

Line 1485: fnd_msg_pub.add;

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

Line 1517: fnd_msg_pub.add;

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

Line 1526: fnd_msg_pub.add;

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

Line 1570: fnd_msg_pub.add;

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

Line 1605: fnd_msg_pub.add;

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

Line 1729: fnd_msg_pub.add;

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

Line 1805: fnd_msg_pub.add;

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

Line 1850: fnd_msg_pub.add;

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

Line 1895: fnd_msg_pub.add;

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

Line 1955: fnd_msg_pub.add;

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

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

1973: COMMIT WORK;
1974:
1975: END IF;
1976:
1977: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1978:
1979:
1980: EXCEPTION
1981:

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

1981:
1982: WHEN fnd_api.g_exc_error THEN
1983: ROLLBACK TO update_resource_group_pvt;
1984: x_return_status := fnd_api.g_ret_sts_error;
1985: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1986: p_data => x_msg_data);
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: ROLLBACK TO update_resource_group_pvt;
1989: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1986: p_data => x_msg_data);
1987: WHEN fnd_api.g_exc_unexpected_error THEN
1988: ROLLBACK TO update_resource_group_pvt;
1989: x_return_status := fnd_api.g_ret_sts_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');

Line 1998: FND_MSG_PUB.add;

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

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

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);
2002:
2003: END update_resource_group;
2004: