eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUP_MEMBERS_PVT dependencies on FND_MSG_PUB

Line 44: fnd_msg_pub.initialize;

40: END IF;
41:
42:
43: IF fnd_api.to_boolean(p_init_msg_list) THEN
44: fnd_msg_pub.initialize;
45: END IF;
46:
47: --assign the value;
48: jtf_rs_group_members_pvt.g_moved_fr_group_id := p_group_id;

Line 57: FND_MSG_PUB.add;

53: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
54: fnd_message.set_token('P_SQLCODE',SQLCODE);
55: fnd_message.set_token('P_SQLERRM',SQLERRM);
56: fnd_message.set_token('P_API_NAME',l_api_name);
57: FND_MSG_PUB.add;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;
59: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
60:
61: END assign_value_to_global;

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

55: fnd_message.set_token('P_SQLERRM',SQLERRM);
56: fnd_message.set_token('P_API_NAME',l_api_name);
57: FND_MSG_PUB.add;
58: x_return_status := fnd_api.g_ret_sts_unexp_error;
59: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
60:
61: END assign_value_to_global;
62:
63: /* Procedure to create the resource group members

Line 155: fnd_msg_pub.initialize;

151:
152:
153: IF fnd_api.to_boolean(p_init_msg_list) THEN
154:
155: fnd_msg_pub.initialize;
156:
157: END IF;
158:
159:

Line 188: fnd_msg_pub.add;

184:
185: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
186:
187: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
188: fnd_msg_pub.add;
189:
190: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
191: RAISE FND_API.G_EXC_ERROR;
192: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 227: fnd_msg_pub.add;

223:
224: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
225:
226: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_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 265: fnd_msg_pub.add;

261: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
262:
263:
264: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
265: fnd_msg_pub.add;
266:
267: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
268: RAISE FND_API.G_EXC_ERROR;
269: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 298: fnd_msg_pub.add;

294:
295: x_return_status := fnd_api.g_ret_sts_error;
296:
297: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_EXISTS');
298: fnd_msg_pub.add;
299:
300: RAISE fnd_api.g_exc_error;
301:
302: END IF;

Line 403: fnd_msg_pub.add;

399: -- dbms_output.put_line('Error in Table Handler');
400:
401:
402: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
403: fnd_msg_pub.add;
404:
405: IF c_jtf_rs_group_members%ISOPEN THEN
406:
407: CLOSE c_jtf_rs_group_members;

Line 443: fnd_msg_pub.add;

439:
440: IF c_jtf_rs_active_grp_mbrs%NOTFOUND THEN
441:
442: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
443: fnd_msg_pub.add;
444:
445: IF c_jtf_rs_active_grp_mbrs%ISOPEN THEN
446:
447: CLOSE c_jtf_rs_active_grp_mbrs;

Line 515: fnd_msg_pub.add;

511: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
512:
513:
514: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
515: fnd_msg_pub.add;
516:
517: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: 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 Vertical User Hook');
553:
554:
555: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
556: fnd_msg_pub.add;
557:
558:
559: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
560: RAISE FND_API.G_EXC_ERROR;

Line 596: fnd_msg_pub.add;

592: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
593:
594:
595: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
596: fnd_msg_pub.add;
597:
598:
599: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;

Line 658: fnd_msg_pub.add;

654:
655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656:
657: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
658: fnd_msg_pub.add;
659:
660:
661: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
662: RAISE FND_API.G_EXC_ERROR;

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

693: COMMIT WORK;
694:
695: END IF;
696:
697: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
698:
699: EXCEPTION
700:
701:

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

701:
702: WHEN fnd_api.g_exc_error THEN
703: ROLLBACK TO create_resource_member_pvt;
704: x_return_status := fnd_api.g_ret_sts_error;
705: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
706: p_data => x_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: ROLLBACK TO create_resource_member_pvt;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

706: p_data => x_msg_data);
707: WHEN fnd_api.g_exc_unexpected_error THEN
708: ROLLBACK TO create_resource_member_pvt;
709: x_return_status := fnd_api.g_ret_sts_unexp_error;
710: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
711: p_data => x_msg_data);
712: WHEN OTHERS THEN
713: ROLLBACK TO create_resource_member_pvt;
714: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 718: FND_MSG_PUB.add;

714: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
715: fnd_message.set_token('P_SQLCODE',SQLCODE);
716: fnd_message.set_token('P_SQLERRM',SQLERRM);
717: fnd_message.set_token('P_API_NAME', l_api_name);
718: FND_MSG_PUB.add;
719: x_return_status := fnd_api.g_ret_sts_unexp_error;
720: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
721: p_data => x_msg_data);
722:

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

716: fnd_message.set_token('P_SQLERRM',SQLERRM);
717: fnd_message.set_token('P_API_NAME', l_api_name);
718: FND_MSG_PUB.add;
719: x_return_status := fnd_api.g_ret_sts_unexp_error;
720: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
721: p_data => x_msg_data);
722:
723: END create_resource_group_members;
724:

Line 816: fnd_msg_pub.initialize;

812: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
813: RAISE fnd_api.g_exc_unexpected_error;
814: END IF;
815: IF fnd_api.to_boolean(p_init_msg_list) THEN
816: fnd_msg_pub.initialize;
817: END IF;
818:
819: /* Make the pre processing call to the user hooks */
820:

Line 847: fnd_msg_pub.add;

843:
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
847: fnd_msg_pub.add;
848:
849: RAISE fnd_api.g_exc_unexpected_error;
850:
851: END IF;

Line 883: fnd_msg_pub.add;

879:
880: x_return_status := fnd_api.g_ret_sts_unexp_error;
881:
882: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
883: fnd_msg_pub.add;
884:
885: RAISE fnd_api.g_exc_unexpected_error;
886:
887: END IF;

Line 917: fnd_msg_pub.add;

913:
914: x_return_status := fnd_api.g_ret_sts_unexp_error;
915:
916: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
917: fnd_msg_pub.add;
918:
919: RAISE fnd_api.g_exc_unexpected_error;
920:
921: END IF;

Line 933: fnd_msg_pub.add;

929: IF c_rs_group_members_update%NOTFOUND THEN
930: CLOSE c_rs_group_members_update;
931: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_MBR_ID');
932: fnd_message.set_token('P_GRP_MBR_ID', p_group_member_id);
933: fnd_msg_pub.add;
934: x_return_status := fnd_api.g_ret_sts_unexp_error;
935: RAISE fnd_api.g_exc_unexpected_error;
936: END IF;
937:

Line 1011: fnd_msg_pub.add;

1007: WHEN NO_DATA_FOUND THEN
1008: CLOSE c_rs_group_members_update;
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1011: fnd_msg_pub.add;
1012: RAISE fnd_api.g_exc_unexpected_error;
1013: END;
1014:
1015: /* Make the post processing call to the user hooks */

Line 1043: fnd_msg_pub.add;

1039:
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041:
1042: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1043: fnd_msg_pub.add;
1044:
1045: RAISE fnd_api.g_exc_unexpected_error;
1046:
1047: END IF;

Line 1079: fnd_msg_pub.add;

1075:
1076: x_return_status := fnd_api.g_ret_sts_unexp_error;
1077:
1078: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1079: fnd_msg_pub.add;
1080:
1081: RAISE fnd_api.g_exc_unexpected_error;
1082:
1083: END IF;

Line 1113: fnd_msg_pub.add;

1109:
1110: x_return_status := fnd_api.g_ret_sts_unexp_error;
1111:
1112: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1113: fnd_msg_pub.add;
1114:
1115: RAISE fnd_api.g_exc_unexpected_error;
1116:
1117: END IF;

Line 1170: fnd_msg_pub.add;

1166:
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168:
1169: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1170: fnd_msg_pub.add;
1171:
1172: RAISE fnd_api.g_exc_unexpected_error;
1173:
1174: END IF;

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

1184: COMMIT WORK;
1185:
1186: END IF;
1187:
1188: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1189:
1190: EXCEPTION
1191: WHEN fnd_api.g_exc_unexpected_error THEN
1192: --DBMS_OUTPUT.put_line (' ========================================== ');

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

1192: --DBMS_OUTPUT.put_line (' ========================================== ');
1193: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
1194: ROLLBACK TO update_rs_group_members_pvt;
1195: x_return_status := fnd_api.g_ret_sts_unexp_error;
1196: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1197: WHEN OTHERS THEN
1198: --DBMS_OUTPUT.put_line (' ========================================== ');
1199: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Resource Role Pub =============');
1200: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 1206: FND_MSG_PUB.add;

1202: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1203: fnd_message.set_token('P_SQLCODE',SQLCODE);
1204: fnd_message.set_token('P_SQLERRM',SQLERRM);
1205: fnd_message.set_token('P_API_NAME',l_api_name);
1206: FND_MSG_PUB.add;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1209:
1210: END;

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

1204: fnd_message.set_token('P_SQLERRM',SQLERRM);
1205: fnd_message.set_token('P_API_NAME',l_api_name);
1206: FND_MSG_PUB.add;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1209:
1210: END;
1211:
1212:

Line 1289: fnd_msg_pub.initialize;

1285:
1286:
1287: IF fnd_api.to_boolean(p_init_msg_list) THEN
1288:
1289: fnd_msg_pub.initialize;
1290:
1291: END IF;
1292:
1293:

Line 1321: fnd_msg_pub.add;

1317:
1318: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1319:
1320: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1321: fnd_msg_pub.add;
1322:
1323:
1324: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1325: RAISE FND_API.G_EXC_ERROR;

Line 1362: fnd_msg_pub.add;

1358:
1359: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1360:
1361: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1362: fnd_msg_pub.add;
1363:
1364:
1365: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1366: RAISE FND_API.G_EXC_ERROR;

Line 1401: fnd_msg_pub.add;

1397: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1398:
1399:
1400: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1401: fnd_msg_pub.add;
1402:
1403: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1404: RAISE FND_API.G_EXC_ERROR;
1405: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1435: fnd_msg_pub.add;

1431: END IF;
1432:
1433: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP_MEMBER');
1434: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
1435: fnd_msg_pub.add;
1436:
1437: RAISE fnd_api.g_exc_error;
1438:
1439: END IF;

Line 1471: fnd_msg_pub.add;

1467:
1468: END IF;
1469:
1470: fnd_message.set_name('JTF', 'JTF_RS_ERROR_ROLE_COUNT');
1471: fnd_msg_pub.add;
1472:
1473: RAISE fnd_api.g_exc_error;
1474:
1475: ELSE

Line 1488: fnd_msg_pub.add;

1484:
1485: END IF;
1486:
1487: fnd_message.set_name('JTF', 'JTF_RS_ACTIVE_ROLE_EXIST');
1488: fnd_msg_pub.add;
1489:
1490: x_return_status := fnd_api.g_ret_sts_unexp_error;
1491:
1492: RAISE fnd_api.g_exc_error;

Line 1519: fnd_msg_pub.add;

1515:
1516: x_return_status := fnd_api.g_ret_sts_unexp_error;
1517:
1518: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1519: fnd_msg_pub.add;
1520:
1521: RAISE fnd_api.g_exc_error;
1522:
1523: END;

Line 1596: fnd_msg_pub.add;

1592:
1593: -- dbms_output.put_line('Error in Table Handler');
1594:
1595: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1596: fnd_msg_pub.add;
1597:
1598: RAISE fnd_api.g_exc_error;
1599:
1600: END;

Line 1631: fnd_msg_pub.add;

1627: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1628:
1629:
1630: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1631: fnd_msg_pub.add;
1632:
1633:
1634: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1635: RAISE FND_API.G_EXC_ERROR;

Line 1671: fnd_msg_pub.add;

1667:
1668: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1669:
1670: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1671: fnd_msg_pub.add;
1672:
1673:
1674: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1675: RAISE FND_API.G_EXC_ERROR;

Line 1709: fnd_msg_pub.add;

1705:
1706: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1707:
1708: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1709: fnd_msg_pub.add;
1710:
1711:
1712: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1713: RAISE FND_API.G_EXC_ERROR;

Line 1769: fnd_msg_pub.add;

1765:
1766: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1767:
1768: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1769: fnd_msg_pub.add;
1770:
1771:
1772: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1773: RAISE FND_API.G_EXC_ERROR;

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

1788: COMMIT WORK;
1789:
1790: END IF;
1791:
1792: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1793:
1794:
1795: EXCEPTION
1796:

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

1796:
1797: WHEN fnd_api.g_exc_error THEN
1798: ROLLBACK TO delete_resource_member_pvt;
1799: x_return_status := fnd_api.g_ret_sts_error;
1800: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1801: p_data => x_msg_data);
1802: WHEN fnd_api.g_exc_unexpected_error THEN
1803: ROLLBACK TO delete_resource_member_pvt;
1804: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1801: p_data => x_msg_data);
1802: WHEN fnd_api.g_exc_unexpected_error THEN
1803: ROLLBACK TO delete_resource_member_pvt;
1804: x_return_status := fnd_api.g_ret_sts_unexp_error;
1805: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1806: p_data => x_msg_data);
1807: WHEN OTHERS THEN
1808: ROLLBACK TO delete_resource_member_pvt;
1809: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1813: FND_MSG_PUB.add;

1809: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1810: fnd_message.set_token('P_SQLCODE',SQLCODE);
1811: fnd_message.set_token('P_SQLERRM',SQLERRM);
1812: fnd_message.set_token('P_API_NAME', l_api_name);
1813: FND_MSG_PUB.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1816: p_data => x_msg_data);
1817:

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

1811: fnd_message.set_token('P_SQLERRM',SQLERRM);
1812: fnd_message.set_token('P_API_NAME', l_api_name);
1813: FND_MSG_PUB.add;
1814: x_return_status := fnd_api.g_ret_sts_unexp_error;
1815: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1816: p_data => x_msg_data);
1817:
1818: END delete_resource_group_members;
1819: