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_RESOURCE_PVT dependencies on FND_MSG_PUB

Line 63: FND_MSG_PUB.add;

59: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
60: fnd_message.set_token('P_SQLCODE',SQLCODE);
61: fnd_message.set_token('P_SQLERRM',SQLERRM);
62: fnd_message.set_token('P_API_NAME', l_api_name);
63: FND_MSG_PUB.add;
64: p_return_status := fnd_api.g_ret_sts_unexp_error;
65:
66: END;
67:

Line 217: fnd_msg_pub.initialize;

213:
214:
215: IF fnd_api.to_boolean(p_init_msg_list) THEN
216:
217: fnd_msg_pub.initialize;
218:
219: END IF;
220:
221:

Line 272: fnd_msg_pub.add;

268: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
269:
270:
271: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
272: fnd_msg_pub.add;
273:
274: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
275: RAISE FND_API.G_EXC_ERROR;
276: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 334: fnd_msg_pub.add;

330: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
331:
332:
333: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
334: fnd_msg_pub.add;
335:
336: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 395: fnd_msg_pub.add;

391: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
392:
393:
394: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
395: fnd_msg_pub.add;
396:
397: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
398: RAISE FND_API.G_EXC_ERROR;
399: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 451: fnd_msg_pub.add;

447:
448: if not(l_address_found)
449: then
450: fnd_message.set_name('JTF', 'JTF_RS_NOT_PRIMARY_ADDR');
451: fnd_msg_pub.add;
452: RAISE fnd_api.g_exc_error;
453:
454: end if;
455: end if;

Line 602: fnd_msg_pub.add;

598: CLOSE c_jtf_rs_resource_extns;
599: END IF;
600:
601: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
602: fnd_msg_pub.add;
603: RAISE fnd_api.g_exc_error;
604:
605: ELSE
606:

Line 666: fnd_msg_pub.add;

662: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
663:
664:
665: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
666: fnd_msg_pub.add;
667:
668: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
669: RAISE FND_API.G_EXC_ERROR;
670: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 722: fnd_msg_pub.add;

718: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
719:
720:
721: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
722: fnd_msg_pub.add;
723:
724: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
725: RAISE FND_API.G_EXC_ERROR;
726: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 782: fnd_msg_pub.add;

778: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
779:
780:
781: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
782: fnd_msg_pub.add;
783:
784: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
785: RAISE FND_API.G_EXC_ERROR;
786: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 842: fnd_msg_pub.add;

838: -- dbms_output.put_line('Returned Error status from the Message Generation API');
839:
840:
841: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
842: fnd_msg_pub.add;
843:
844: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

860: COMMIT WORK;
861:
862: END IF;
863:
864: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
865:
866:
867: EXCEPTION
868:

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

868:
869: WHEN fnd_api.g_exc_error THEN
870: ROLLBACK TO create_resource_pvt;
871: x_return_status := fnd_api.g_ret_sts_error;
872: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
873: p_data => x_msg_data);
874: WHEN fnd_api.g_exc_unexpected_error THEN
875: ROLLBACK TO create_resource_pvt;
876: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

873: p_data => x_msg_data);
874: WHEN fnd_api.g_exc_unexpected_error THEN
875: ROLLBACK TO create_resource_pvt;
876: x_return_status := fnd_api.g_ret_sts_unexp_error;
877: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
878: p_data => x_msg_data);
879: WHEN OTHERS THEN
880: ROLLBACK TO create_resource_pvt;
881: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls

Line 887: -- FND_MSG_PUB.add;

883: -- THEN
884: -- IF(l_value = 'XMLGEN')
885: -- THEN
886: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
887: -- FND_MSG_PUB.add;
888: -- ELSIF(l_value = 'JTF_USR_HKS')
889: -- THEN
890: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
891: -- FND_MSG_PUB.add;

Line 891: -- FND_MSG_PUB.add;

887: -- FND_MSG_PUB.add;
888: -- ELSIF(l_value = 'JTF_USR_HKS')
889: -- THEN
890: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
891: -- FND_MSG_PUB.add;
892: -- END IF;
893: -- ELSE
894: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
895: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 898: FND_MSG_PUB.add;

894: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
895: fnd_message.set_token('P_SQLCODE',SQLCODE);
896: fnd_message.set_token('P_SQLERRM',SQLERRM);
897: fnd_message.set_token('P_API_NAME', l_api_name);
898: FND_MSG_PUB.add;
899: -- END IF;
900: x_return_status := fnd_api.g_ret_sts_unexp_error;
901: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
902: p_data => x_msg_data);

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

897: fnd_message.set_token('P_API_NAME', l_api_name);
898: FND_MSG_PUB.add;
899: -- END IF;
900: x_return_status := fnd_api.g_ret_sts_unexp_error;
901: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
902: p_data => x_msg_data);
903:
904: END create_resource;
905:

Line 1167: fnd_msg_pub.initialize;

1163: RAISE fnd_api.g_exc_unexpected_error;
1164: END IF;
1165:
1166: IF fnd_api.to_boolean(p_init_msg_list) THEN
1167: fnd_msg_pub.initialize;
1168: END IF;
1169:
1170: IF l_category = 'EMPLOYEE' THEN
1171: OPEN c_asg(l_source_Id);

Line 1228: fnd_msg_pub.add;

1224: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
1225:
1226:
1227: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1228: fnd_msg_pub.add;
1229:
1230: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1231: RAISE FND_API.G_EXC_ERROR;
1232: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1291: fnd_msg_pub.add;

1287: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
1288:
1289:
1290: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1291: fnd_msg_pub.add;
1292:
1293: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1294: RAISE FND_API.G_EXC_ERROR;
1295: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1352: fnd_msg_pub.add;

1348: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1349:
1350:
1351: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1352: fnd_msg_pub.add;
1353:
1354: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1355: RAISE FND_API.G_EXC_ERROR;
1356: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1409: fnd_msg_pub.add;

1405:
1406: if not(l_address_found)
1407: then
1408: fnd_message.set_name('JTF', 'JTF_RS_NOT_PRIMARY_ADDR');
1409: fnd_msg_pub.add;
1410: RAISE fnd_api.g_exc_error;
1411:
1412: end if;
1413: end if;

Line 1628: fnd_msg_pub.add;

1624: CLOSE c_jtf_rs_resource_extns;
1625: END IF;
1626: x_return_status := fnd_api.g_ret_sts_unexp_error;
1627: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1628: fnd_msg_pub.add;
1629: RAISE fnd_api.g_exc_unexpected_error;
1630: ELSE
1631: -- dbms_output.put_line('Resource Successfully Created');
1632: x_resource_id := l_resource_id;

Line 1685: fnd_msg_pub.add;

1681: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1682: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
1683:
1684: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1685: fnd_msg_pub.add;
1686: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1687: RAISE FND_API.G_EXC_ERROR;
1688: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1744: fnd_msg_pub.add;

1740: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
1741:
1742:
1743: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1744: fnd_msg_pub.add;
1745:
1746: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1747: RAISE FND_API.G_EXC_ERROR;
1748: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1805: fnd_msg_pub.add;

1801:
1802: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1803:
1804: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1805: fnd_msg_pub.add;
1806:
1807: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1808: RAISE FND_API.G_EXC_ERROR;
1809: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1866: fnd_msg_pub.add;

1862: -- dbms_output.put_line('Returned Error status from the Message Generation API');
1863:
1864:
1865: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1866: fnd_msg_pub.add;
1867:
1868: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1869: RAISE FND_API.G_EXC_ERROR;
1870: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

1885: COMMIT WORK;
1886:
1887: END IF;
1888:
1889: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1890:
1891: /* Calling publish API to raise create resource event. */
1892: /* added by baianand on 11/04/2002 */
1893:

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

1944:
1945: WHEN fnd_api.g_exc_error THEN
1946: ROLLBACK TO create_resource_pvt;
1947: x_return_status := fnd_api.g_ret_sts_error;
1948: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1949: p_data => x_msg_data);
1950: WHEN fnd_api.g_exc_unexpected_error THEN
1951: ROLLBACK TO create_resource_pvt;
1952: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1949: p_data => x_msg_data);
1950: WHEN fnd_api.g_exc_unexpected_error THEN
1951: ROLLBACK TO create_resource_pvt;
1952: x_return_status := fnd_api.g_ret_sts_unexp_error;
1953: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1954: p_data => x_msg_data);
1955: WHEN OTHERS THEN
1956: ROLLBACK TO create_resource_pvt;
1957: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls

Line 1963: -- FND_MSG_PUB.add;

1959: -- THEN
1960: -- IF(l_value = 'XMLGEN')
1961: -- THEN
1962: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
1963: -- FND_MSG_PUB.add;
1964: -- ELSIF(l_value = 'JTF_USR_HKS')
1965: -- THEN
1966: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
1967: -- FND_MSG_PUB.add;

Line 1967: -- FND_MSG_PUB.add;

1963: -- FND_MSG_PUB.add;
1964: -- ELSIF(l_value = 'JTF_USR_HKS')
1965: -- THEN
1966: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
1967: -- FND_MSG_PUB.add;
1968: -- END IF;
1969: -- ELSE
1970: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1971: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 1974: FND_MSG_PUB.add;

1970: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1971: fnd_message.set_token('P_SQLCODE',SQLCODE);
1972: fnd_message.set_token('P_SQLERRM',SQLERRM);
1973: fnd_message.set_token('P_API_NAME', l_api_name);
1974: FND_MSG_PUB.add;
1975: -- END IF;
1976: x_return_status := fnd_api.g_ret_sts_unexp_error;
1977: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1978: p_data => x_msg_data);

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

1973: fnd_message.set_token('P_API_NAME', l_api_name);
1974: FND_MSG_PUB.add;
1975: -- END IF;
1976: x_return_status := fnd_api.g_ret_sts_unexp_error;
1977: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1978: p_data => x_msg_data);
1979:
1980: END create_resource;
1981:

Line 2414: fnd_msg_pub.initialize;

2410:
2411:
2412: IF fnd_api.to_boolean(p_init_msg_list) THEN
2413:
2414: fnd_msg_pub.initialize;
2415:
2416: END IF;
2417:
2418: /* Make the pre processing call to the user hooks */

Line 2465: fnd_msg_pub.add;

2461: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
2462:
2463:
2464: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
2465: fnd_msg_pub.add;
2466:
2467: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2468: RAISE FND_API.G_EXC_ERROR;
2469: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2525: fnd_msg_pub.add;

2521: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
2522:
2523:
2524: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
2525: fnd_msg_pub.add;
2526:
2527: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2528: RAISE FND_API.G_EXC_ERROR;
2529: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2583: fnd_msg_pub.add;

2579: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
2580:
2581:
2582: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
2583: fnd_msg_pub.add;
2584:
2585: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
2586: RAISE FND_API.G_EXC_ERROR;
2587: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 2612: fnd_msg_pub.add;

2608: END IF;
2609:
2610: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
2611: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
2612: fnd_msg_pub.add;
2613:
2614: RAISE fnd_api.g_exc_error;
2615:
2616:

Line 2694: fnd_msg_pub.add;

2690:
2691: /* Resource Start Date out of range for the role related start dates of the resource */
2692:
2693: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');
2694: fnd_msg_pub.add;
2695:
2696: RAISE fnd_api.g_exc_error;
2697:
2698:

Line 2708: fnd_msg_pub.add;

2704:
2705: /* Resource End Date out of range for the role related End dates of the Resource */
2706:
2707: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');
2708: fnd_msg_pub.add;
2709:
2710: RAISE fnd_api.g_exc_error;
2711:
2712:

Line 2742: fnd_msg_pub.add;

2738: IF l_start_date_active <> FND_API.G_MISS_DATE AND
2739: l_min_start_date < l_start_date_active THEN
2740:
2741: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');
2742: fnd_msg_pub.add;
2743:
2744: RAISE fnd_api.g_exc_error;
2745:
2746:

Line 2753: fnd_msg_pub.add;

2749: IF l_end_date_active <> FND_API.G_MISS_DATE AND
2750: l_end_date_active IS NOT NULL THEN
2751:
2752: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');
2753: fnd_msg_pub.add;
2754:
2755: RAISE fnd_api.g_exc_error;
2756:
2757:

Line 2790: fnd_msg_pub.add;

2786: IF l_start_date_active <> FND_API.G_MISS_DATE AND
2787: l_min_start_date < l_start_date_active THEN
2788:
2789: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');
2790: fnd_msg_pub.add;
2791:
2792: RAISE fnd_api.g_exc_error;
2793:
2794:

Line 2802: fnd_msg_pub.add;

2798: l_max_end_date > l_end_date_active AND
2799: l_end_date_active IS NOT NULL ) THEN
2800:
2801: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');
2802: fnd_msg_pub.add;
2803:
2804: RAISE fnd_api.g_exc_error;
2805:
2806: END IF;

Line 2835: fnd_msg_pub.add;

2831: IF l_start_date_active <> FND_API.G_MISS_DATE AND
2832: l_min_start_date < l_start_date_active THEN
2833:
2834: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');
2835: fnd_msg_pub.add;
2836:
2837: RAISE fnd_api.g_exc_error;
2838:
2839:

Line 2846: fnd_msg_pub.add;

2842: IF l_end_date_active <> FND_API.G_MISS_DATE AND
2843: l_end_date_active IS NOT NULL THEN
2844:
2845: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');
2846: fnd_msg_pub.add;
2847:
2848: RAISE fnd_api.g_exc_error;
2849:
2850:

Line 2883: fnd_msg_pub.add;

2879: IF l_start_date_active <> FND_API.G_MISS_DATE AND
2880: l_min_start_date < l_start_date_active THEN
2881:
2882: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');
2883: fnd_msg_pub.add;
2884:
2885: RAISE fnd_api.g_exc_error;
2886:
2887:

Line 2895: fnd_msg_pub.add;

2891: l_max_end_date > l_end_date_active AND
2892: l_end_date_active IS NOT NULL ) THEN
2893:
2894: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');
2895: fnd_msg_pub.add;
2896:
2897: RAISE fnd_api.g_exc_error;
2898:
2899:

Line 2930: fnd_msg_pub.add;

2926: IF l_start_date_active <> FND_API.G_MISS_DATE AND
2927: l_min_start_date < l_start_date_active THEN
2928:
2929: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');
2930: fnd_msg_pub.add;
2931:
2932: RAISE fnd_api.g_exc_error;
2933:
2934:

Line 2941: fnd_msg_pub.add;

2937: IF l_end_date_active <> FND_API.G_MISS_DATE AND
2938: l_end_date_active IS NOT NULL THEN
2939:
2940: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');
2941: fnd_msg_pub.add;
2942:
2943: RAISE fnd_api.g_exc_error;
2944:
2945:

Line 2980: fnd_msg_pub.add;

2976:
2977: /* Resource Start Date out of range for the salesrep related start dates of the resource */
2978:
2979: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');
2980: fnd_msg_pub.add;
2981:
2982: RAISE fnd_api.g_exc_error;
2983:
2984:

Line 2994: fnd_msg_pub.add;

2990:
2991: /* Resource End Date out of range for the salesrep related End dates of the Resource */
2992:
2993: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');
2994: fnd_msg_pub.add;
2995:
2996: RAISE fnd_api.g_exc_error;
2997:
2998:

Line 3028: fnd_msg_pub.add;

3024: IF l_start_date_active <> FND_API.G_MISS_DATE AND
3025: l_min_start_date < l_start_date_active THEN
3026:
3027: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');
3028: fnd_msg_pub.add;
3029:
3030: RAISE fnd_api.g_exc_error;
3031:
3032:

Line 3039: fnd_msg_pub.add;

3035: IF l_end_date_active <> FND_API.G_MISS_DATE AND
3036: l_end_date_active IS NOT NULL THEN
3037:
3038: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');
3039: fnd_msg_pub.add;
3040:
3041: RAISE fnd_api.g_exc_error;
3042:
3043:

Line 3216: fnd_msg_pub.add;

3212: -- dbms_output.put_line('Invalid Assigned To Group Id');
3213:
3214: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');
3215: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);
3216: fnd_msg_pub.add;
3217:
3218: RAISE fnd_api.g_exc_error;
3219:
3220:

Line 3275: fnd_msg_pub.add;

3271:
3272: -- dbms_output.put_line('Commissionable Flag should either be ''Y'' or ''N'' ');
3273:
3274: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
3275: fnd_msg_pub.add;
3276:
3277: RAISE fnd_api.g_exc_error;
3278:
3279:

Line 3295: fnd_msg_pub.add;

3291:
3292: -- dbms_output.put_line('Hold Payment should either be ''Y'' or ''N'' ');
3293:
3294: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
3295: fnd_msg_pub.add;
3296:
3297: RAISE fnd_api.g_exc_error;
3298:
3299:

Line 3342: fnd_msg_pub.add;

3338: /* Removed 'WORKER' from the below code to fix bug # 3455951 */
3339: IF resource_rec.category NOT IN ('EMPLOYEE', 'PARTY', 'SUPPLIER_CONTACT') AND l_user_id IS NOT NULL THEN
3340:
3341: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');
3342: fnd_msg_pub.add;
3343:
3344: RAISE fnd_api.g_exc_error;
3345:
3346:

Line 3387: fnd_msg_pub.add;

3383: -- dbms_output.put_line('duplicate user Id');
3384:
3385: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');
3386: fnd_message.set_token('P_USER_ID', l_user_id);
3387: fnd_msg_pub.add;
3388:
3389: RAISE fnd_api.g_exc_error;
3390:
3391: END IF;

Line 3461: fnd_msg_pub.add;

3457:
3458: x_return_status := fnd_api.g_ret_sts_unexp_error;
3459:
3460: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
3461: fnd_msg_pub.add;
3462:
3463: RAISE fnd_api.g_exc_error;
3464:
3465:

Line 3608: fnd_msg_pub.add;

3604:
3605: x_return_status := fnd_api.g_ret_sts_unexp_error;
3606:
3607: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
3608: fnd_msg_pub.add;
3609:
3610: RAISE fnd_api.g_exc_error;
3611:
3612:

Line 3673: fnd_msg_pub.add;

3669:
3670: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
3671:
3672: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
3673: fnd_msg_pub.add;
3674:
3675: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3676: RAISE FND_API.G_EXC_ERROR;
3677: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3733: fnd_msg_pub.add;

3729: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
3730:
3731:
3732: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
3733: fnd_msg_pub.add;
3734:
3735: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3736: RAISE FND_API.G_EXC_ERROR;
3737: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3793: fnd_msg_pub.add;

3789: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
3790:
3791:
3792: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
3793: fnd_msg_pub.add;
3794:
3795: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3796: RAISE FND_API.G_EXC_ERROR;
3797: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 3853: fnd_msg_pub.add;

3849: -- dbms_output.put_line('Returned Error status from the Message Generation API');
3850:
3851:
3852: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
3853: fnd_msg_pub.add;
3854:
3855: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
3856: RAISE FND_API.G_EXC_ERROR;
3857: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

3872: COMMIT WORK;
3873:
3874: END IF;
3875:
3876: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3877:
3878:
3879: EXCEPTION
3880:

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

3880:
3881: WHEN fnd_api.g_exc_error THEN
3882: ROLLBACK TO update_resource_pvt;
3883: x_return_status := fnd_api.g_ret_sts_error;
3884: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3885: p_data => x_msg_data);
3886: WHEN fnd_api.g_exc_unexpected_error THEN
3887: ROLLBACK TO update_resource_pvt;
3888: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3885: p_data => x_msg_data);
3886: WHEN fnd_api.g_exc_unexpected_error THEN
3887: ROLLBACK TO update_resource_pvt;
3888: x_return_status := fnd_api.g_ret_sts_unexp_error;
3889: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3890: p_data => x_msg_data);
3891: WHEN OTHERS THEN
3892: ROLLBACK TO update_resource_pvt;
3893: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls

Line 3899: -- FND_MSG_PUB.add;

3895: -- THEN
3896: -- IF(l_value = 'XMLGEN')
3897: -- THEN
3898: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
3899: -- FND_MSG_PUB.add;
3900: -- ELSIF(l_value = 'JTF_USR_HKS')
3901: -- THEN
3902: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
3903: -- FND_MSG_PUB.add;

Line 3903: -- FND_MSG_PUB.add;

3899: -- FND_MSG_PUB.add;
3900: -- ELSIF(l_value = 'JTF_USR_HKS')
3901: -- THEN
3902: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
3903: -- FND_MSG_PUB.add;
3904: -- END IF;
3905: -- ELSE
3906: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3907: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 3910: FND_MSG_PUB.add;

3906: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3907: fnd_message.set_token('P_SQLCODE',SQLCODE);
3908: fnd_message.set_token('P_SQLERRM',SQLERRM);
3909: fnd_message.set_token('P_API_NAME', l_api_name);
3910: FND_MSG_PUB.add;
3911: -- END IF;
3912: x_return_status := fnd_api.g_ret_sts_unexp_error;
3913: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3914: p_data => x_msg_data);

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

3909: fnd_message.set_token('P_API_NAME', l_api_name);
3910: FND_MSG_PUB.add;
3911: -- END IF;
3912: x_return_status := fnd_api.g_ret_sts_unexp_error;
3913: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3914: p_data => x_msg_data);
3915:
3916:
3917: END update_resource;

Line 4379: fnd_msg_pub.initialize;

4375:
4376:
4377: IF fnd_api.to_boolean(p_init_msg_list) THEN
4378:
4379: fnd_msg_pub.initialize;
4380:
4381: END IF;
4382:
4383:

Line 4431: fnd_msg_pub.add;

4427: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
4428:
4429:
4430: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
4431: fnd_msg_pub.add;
4432:
4433: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
4434: RAISE FND_API.G_EXC_ERROR;
4435: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4490: fnd_msg_pub.add;

4486:
4487: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
4488:
4489: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
4490: fnd_msg_pub.add;
4491:
4492: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
4493: RAISE FND_API.G_EXC_ERROR;
4494: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4548: fnd_msg_pub.add;

4544: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4545:
4546:
4547: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
4548: fnd_msg_pub.add;
4549:
4550: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
4551: RAISE FND_API.G_EXC_ERROR;
4552: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4578: fnd_msg_pub.add;

4574: END IF;
4575:
4576: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
4577: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
4578: fnd_msg_pub.add;
4579:
4580: RAISE fnd_api.g_exc_error;
4581:
4582:

Line 4664: fnd_msg_pub.add;

4660:
4661: /* Resource Start Date out of range for the role related start dates of the resource */
4662:
4663: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');
4664: fnd_msg_pub.add;
4665:
4666: RAISE fnd_api.g_exc_error;
4667:
4668:

Line 4678: fnd_msg_pub.add;

4674:
4675: /* Resource End Date out of range for the role related End dates of the Resource */
4676:
4677: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');
4678: fnd_msg_pub.add;
4679:
4680: RAISE fnd_api.g_exc_error;
4681:
4682:

Line 4711: fnd_msg_pub.add;

4707: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4708: l_min_start_date < l_start_date_active THEN
4709:
4710: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');
4711: fnd_msg_pub.add;
4712:
4713: RAISE fnd_api.g_exc_error;
4714:
4715:

Line 4722: fnd_msg_pub.add;

4718: IF l_end_date_active <> FND_API.G_MISS_DATE AND
4719: l_end_date_active IS NOT NULL THEN
4720:
4721: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');
4722: fnd_msg_pub.add;
4723:
4724: RAISE fnd_api.g_exc_error;
4725:
4726:

Line 4755: fnd_msg_pub.add;

4751: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4752: l_min_start_date < l_start_date_active THEN
4753:
4754: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');
4755: fnd_msg_pub.add;
4756:
4757: RAISE fnd_api.g_exc_error;
4758:
4759:

Line 4767: fnd_msg_pub.add;

4763: l_max_end_date > l_end_date_active AND
4764: l_end_date_active IS NOT NULL ) THEN
4765:
4766: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');
4767: fnd_msg_pub.add;
4768:
4769: RAISE fnd_api.g_exc_error;
4770:
4771:

Line 4800: fnd_msg_pub.add;

4796: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4797: l_min_start_date < l_start_date_active THEN
4798:
4799: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');
4800: fnd_msg_pub.add;
4801:
4802: RAISE fnd_api.g_exc_error;
4803:
4804:

Line 4811: fnd_msg_pub.add;

4807: IF l_end_date_active <> FND_API.G_MISS_DATE AND
4808: l_end_date_active IS NOT NULL THEN
4809:
4810: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');
4811: fnd_msg_pub.add;
4812:
4813: RAISE fnd_api.g_exc_error;
4814:
4815:

Line 4847: fnd_msg_pub.add;

4843: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4844: l_min_start_date < l_start_date_active THEN
4845:
4846: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');
4847: fnd_msg_pub.add;
4848:
4849: RAISE fnd_api.g_exc_error;
4850:
4851:

Line 4859: fnd_msg_pub.add;

4855: l_max_end_date > l_end_date_active AND
4856: l_end_date_active IS NOT NULL ) THEN
4857:
4858: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');
4859: fnd_msg_pub.add;
4860:
4861: RAISE fnd_api.g_exc_error;
4862:
4863:

Line 4891: fnd_msg_pub.add;

4887: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4888: l_min_start_date < l_start_date_active THEN
4889:
4890: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');
4891: fnd_msg_pub.add;
4892:
4893: RAISE fnd_api.g_exc_error;
4894:
4895:

Line 4902: fnd_msg_pub.add;

4898: IF l_end_date_active <> FND_API.G_MISS_DATE AND
4899: l_end_date_active IS NOT NULL THEN
4900:
4901: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');
4902: fnd_msg_pub.add;
4903:
4904: RAISE fnd_api.g_exc_error;
4905:
4906:

Line 4939: fnd_msg_pub.add;

4935:
4936: /* Resource Start Date out of range for the salesrep related start dates of the resource */
4937:
4938: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');
4939: fnd_msg_pub.add;
4940:
4941: RAISE fnd_api.g_exc_error;
4942:
4943: END IF;

Line 4952: fnd_msg_pub.add;

4948:
4949: /* Resource End Date out of range for the salesrep related End dates of the Resource */
4950:
4951: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');
4952: fnd_msg_pub.add;
4953:
4954: RAISE fnd_api.g_exc_error;
4955:
4956:

Line 4986: fnd_msg_pub.add;

4982: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4983: l_min_start_date < l_start_date_active THEN
4984:
4985: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');
4986: fnd_msg_pub.add;
4987:
4988: RAISE fnd_api.g_exc_error;
4989:
4990:

Line 4997: fnd_msg_pub.add;

4993: IF l_end_date_active <> FND_API.G_MISS_DATE AND
4994: l_end_date_active IS NOT NULL THEN
4995:
4996: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');
4997: fnd_msg_pub.add;
4998:
4999: RAISE fnd_api.g_exc_error;
5000:
5001:

Line 5174: fnd_msg_pub.add;

5170: -- dbms_output.put_line('Invalid Assigned To Group Id');
5171:
5172: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');
5173: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);
5174: fnd_msg_pub.add;
5175:
5176: RAISE fnd_api.g_exc_error;
5177:
5178:

Line 5233: fnd_msg_pub.add;

5229:
5230: -- dbms_output.put_line('Commissionable Flag should either be ''Y'' or ''N'' ');
5231:
5232: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
5233: fnd_msg_pub.add;
5234:
5235: RAISE fnd_api.g_exc_error;
5236:
5237:

Line 5253: fnd_msg_pub.add;

5249:
5250: -- dbms_output.put_line('Hold Payment should either be ''Y'' or ''N'' ');
5251:
5252: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
5253: fnd_msg_pub.add;
5254:
5255: RAISE fnd_api.g_exc_error;
5256:
5257:

Line 5299: fnd_msg_pub.add;

5295:
5296: IF resource_rec.category NOT IN ('EMPLOYEE', 'PARTY', 'SUPPLIER_CONTACT') AND l_user_id IS NOT NULL THEN
5297:
5298: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');
5299: fnd_msg_pub.add;
5300:
5301: RAISE fnd_api.g_exc_error;
5302:
5303:

Line 5344: fnd_msg_pub.add;

5340: -- dbms_output.put_line('duplicate user Id');
5341:
5342: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');
5343: fnd_message.set_token('P_USER_ID', l_user_id);
5344: fnd_msg_pub.add;
5345:
5346: RAISE fnd_api.g_exc_error;
5347:
5348:

Line 5420: fnd_msg_pub.add;

5416:
5417: if not(l_address_found)
5418: then
5419: fnd_message.set_name('JTF', 'JTF_RS_NOT_PRIMARY_ADDR');
5420: fnd_msg_pub.add;
5421: RAISE fnd_api.g_exc_error;
5422:
5423: end if;
5424: end if; -- end of nvl check

Line 5446: fnd_msg_pub.add;

5442: -- dbms_output.put_line('Error in Locking the Row');
5443:
5444:
5445: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
5446: fnd_msg_pub.add;
5447:
5448: RAISE fnd_api.g_exc_error;
5449:
5450:

Line 5722: fnd_msg_pub.add;

5718:
5719: x_return_status := fnd_api.g_ret_sts_unexp_error;
5720:
5721: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
5722: fnd_msg_pub.add;
5723:
5724: RAISE fnd_api.g_exc_error;
5725:
5726:

Line 5788: fnd_msg_pub.add;

5784: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
5785:
5786:
5787: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
5788: fnd_msg_pub.add;
5789:
5790: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
5791: RAISE FND_API.G_EXC_ERROR;
5792: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5847: fnd_msg_pub.add;

5843: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
5844:
5845:
5846: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
5847: fnd_msg_pub.add;
5848:
5849: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
5850: RAISE FND_API.G_EXC_ERROR;
5851: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5907: fnd_msg_pub.add;

5903: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
5904:
5905:
5906: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
5907: fnd_msg_pub.add;
5908:
5909: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
5910: RAISE FND_API.G_EXC_ERROR;
5911: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5968: fnd_msg_pub.add;

5964: -- dbms_output.put_line('Returned Error status from the Message Generation API');
5965:
5966:
5967: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
5968: fnd_msg_pub.add;
5969:
5970: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
5971: RAISE FND_API.G_EXC_ERROR;
5972: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

5987: COMMIT WORK;
5988:
5989: END IF;
5990:
5991: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5992:
5993: EXCEPTION
5994:
5995:

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

5995:
5996: WHEN fnd_api.g_exc_error THEN
5997: ROLLBACK TO update_resource_pvt;
5998: x_return_status := fnd_api.g_ret_sts_error;
5999: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6000: p_data => x_msg_data);
6001: WHEN fnd_api.g_exc_unexpected_error THEN
6002: ROLLBACK TO update_resource_pvt;
6003: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

6000: p_data => x_msg_data);
6001: WHEN fnd_api.g_exc_unexpected_error THEN
6002: ROLLBACK TO update_resource_pvt;
6003: x_return_status := fnd_api.g_ret_sts_unexp_error;
6004: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6005: p_data => x_msg_data);
6006: WHEN OTHERS THEN
6007: ROLLBACK TO update_resource_pvt;
6008: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls

Line 6014: -- FND_MSG_PUB.add;

6010: -- THEN
6011: -- IF(l_value = 'XMLGEN')
6012: -- THEN
6013: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
6014: -- FND_MSG_PUB.add;
6015: -- ELSIF(l_value = 'JTF_USR_HKS')
6016: -- THEN
6017: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
6018: -- FND_MSG_PUB.add;

Line 6018: -- FND_MSG_PUB.add;

6014: -- FND_MSG_PUB.add;
6015: -- ELSIF(l_value = 'JTF_USR_HKS')
6016: -- THEN
6017: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
6018: -- FND_MSG_PUB.add;
6019: -- END IF;
6020: -- ELSE
6021: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
6022: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 6025: FND_MSG_PUB.add;

6021: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
6022: fnd_message.set_token('P_SQLCODE',SQLCODE);
6023: fnd_message.set_token('P_SQLERRM',SQLERRM);
6024: fnd_message.set_token('P_API_NAME', l_api_name);
6025: FND_MSG_PUB.add;
6026: -- END IF;
6027: x_return_status := fnd_api.g_ret_sts_unexp_error;
6028: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6029: p_data => x_msg_data);

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

6024: fnd_message.set_token('P_API_NAME', l_api_name);
6025: FND_MSG_PUB.add;
6026: -- END IF;
6027: x_return_status := fnd_api.g_ret_sts_unexp_error;
6028: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6029: p_data => x_msg_data);
6030:
6031:
6032: END update_resource;

Line 6082: fnd_msg_pub.initialize;

6078:
6079:
6080: IF fnd_api.to_boolean(p_init_msg_list) THEN
6081:
6082: fnd_msg_pub.initialize;
6083:
6084: END IF;
6085:
6086:

Line 6110: fnd_msg_pub.add;

6106: x_return_status => x_return_status);
6107:
6108: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6109: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
6110: fnd_msg_pub.add;
6111: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6112: RAISE FND_API.G_EXC_ERROR;
6113: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6144: fnd_msg_pub.add;

6140: x_return_status => x_return_status);
6141:
6142: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6143: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
6144: fnd_msg_pub.add;
6145: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6146: RAISE FND_API.G_EXC_ERROR;
6147: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6177: fnd_msg_pub.add;

6173: x_return_status => x_return_status);
6174:
6175: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6176: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
6177: fnd_msg_pub.add;
6178:
6179: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6180: RAISE FND_API.G_EXC_ERROR;
6181: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 6245: fnd_msg_pub.add;

6241: p_resource_id => l_resource_id,
6242: x_return_status => x_return_status);
6243: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6244: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
6245: fnd_msg_pub.add;
6246: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6247: RAISE FND_API.G_EXC_ERROR;
6248: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6277: fnd_msg_pub.add;

6273: p_resource_id => l_resource_id,
6274: x_return_status => x_return_status);
6275: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6276: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
6277: fnd_msg_pub.add;
6278: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6279: RAISE FND_API.G_EXC_ERROR;
6280: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6310: fnd_msg_pub.add;

6306: x_return_status => x_return_status);
6307:
6308: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6309: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
6310: fnd_msg_pub.add;
6311: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6312: RAISE FND_API.G_EXC_ERROR;
6313: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6369: fnd_msg_pub.add;

6365: -- dbms_output.put_line('Returned Error status from the Message Generation API');
6366:
6367:
6368: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
6369: fnd_msg_pub.add;
6370:
6371: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6372: RAISE FND_API.G_EXC_ERROR;
6373: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

6388: COMMIT WORK;
6389:
6390: END IF;
6391:
6392: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6393:
6394: if (l_category = 'TBH') then
6395:
6396: /* Calling publish API to raise create resource event. */

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

6437:
6438: WHEN fnd_api.g_exc_error THEN
6439: ROLLBACK TO delete_resource_pvt;
6440: x_return_status := fnd_api.g_ret_sts_error;
6441: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6442: p_data => x_msg_data);
6443: WHEN fnd_api.g_exc_unexpected_error THEN
6444: ROLLBACK TO delete_resource_pvt;
6445: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

6442: p_data => x_msg_data);
6443: WHEN fnd_api.g_exc_unexpected_error THEN
6444: ROLLBACK TO delete_resource_pvt;
6445: x_return_status := fnd_api.g_ret_sts_unexp_error;
6446: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6447: p_data => x_msg_data);
6448: WHEN OTHERS THEN
6449: ROLLBACK TO delete_resource_pvt;
6450: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls

Line 6456: -- FND_MSG_PUB.add;

6452: -- THEN
6453: -- IF(l_value = 'XMLGEN')
6454: -- THEN
6455: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
6456: -- FND_MSG_PUB.add;
6457: -- ELSIF(l_value = 'JTF_USR_HKS')
6458: -- THEN
6459: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
6460: -- FND_MSG_PUB.add;

Line 6460: -- FND_MSG_PUB.add;

6456: -- FND_MSG_PUB.add;
6457: -- ELSIF(l_value = 'JTF_USR_HKS')
6458: -- THEN
6459: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
6460: -- FND_MSG_PUB.add;
6461: -- END IF;
6462: -- ELSE
6463: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
6464: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 6467: FND_MSG_PUB.add;

6463: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
6464: fnd_message.set_token('P_SQLCODE',SQLCODE);
6465: fnd_message.set_token('P_SQLERRM',SQLERRM);
6466: fnd_message.set_token('P_API_NAME', l_api_name);
6467: FND_MSG_PUB.add;
6468: -- END IF;
6469: x_return_status := fnd_api.g_ret_sts_unexp_error;
6470: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6471: p_data => x_msg_data);

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

6466: fnd_message.set_token('P_API_NAME', l_api_name);
6467: FND_MSG_PUB.add;
6468: -- END IF;
6469: x_return_status := fnd_api.g_ret_sts_unexp_error;
6470: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6471: p_data => x_msg_data);
6472:
6473: END delete_resource;
6474: