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 2413: fnd_msg_pub.initialize;

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

Line 2464: fnd_msg_pub.add;

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

Line 2524: fnd_msg_pub.add;

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

Line 2582: fnd_msg_pub.add;

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

Line 2611: fnd_msg_pub.add;

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

Line 2693: fnd_msg_pub.add;

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

Line 2707: fnd_msg_pub.add;

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

Line 2741: fnd_msg_pub.add;

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

Line 2752: fnd_msg_pub.add;

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

Line 2789: fnd_msg_pub.add;

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

Line 2801: fnd_msg_pub.add;

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

Line 2834: fnd_msg_pub.add;

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

Line 2845: fnd_msg_pub.add;

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

Line 2882: fnd_msg_pub.add;

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

Line 2894: fnd_msg_pub.add;

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

Line 2929: fnd_msg_pub.add;

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

Line 2940: fnd_msg_pub.add;

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

Line 2979: fnd_msg_pub.add;

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

Line 2993: fnd_msg_pub.add;

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

Line 3027: fnd_msg_pub.add;

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

Line 3038: fnd_msg_pub.add;

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

Line 3215: fnd_msg_pub.add;

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

Line 3274: fnd_msg_pub.add;

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

Line 3294: fnd_msg_pub.add;

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

Line 3341: fnd_msg_pub.add;

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

Line 3386: fnd_msg_pub.add;

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

Line 3460: fnd_msg_pub.add;

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

Line 3607: fnd_msg_pub.add;

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

Line 3672: fnd_msg_pub.add;

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

Line 3732: fnd_msg_pub.add;

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

Line 3792: fnd_msg_pub.add;

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

Line 3852: fnd_msg_pub.add;

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

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

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

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

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

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

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

Line 3898: -- FND_MSG_PUB.add;

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

Line 3902: -- FND_MSG_PUB.add;

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

Line 3909: FND_MSG_PUB.add;

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

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

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

Line 4388: fnd_msg_pub.initialize;

4384:
4385:
4386: IF fnd_api.to_boolean(p_init_msg_list) THEN
4387:
4388: fnd_msg_pub.initialize;
4389:
4390: END IF;
4391:
4392:

Line 4440: fnd_msg_pub.add;

4436: -- dbms_output.put_line('Returned Error status from the Pre Customer User Hook');
4437:
4438:
4439: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
4440: fnd_msg_pub.add;
4441:
4442: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
4443: RAISE FND_API.G_EXC_ERROR;
4444: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4499: fnd_msg_pub.add;

4495:
4496: -- dbms_output.put_line('Returned Error status from the Pre Vertical User Hook');
4497:
4498: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
4499: fnd_msg_pub.add;
4500:
4501: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
4502: RAISE FND_API.G_EXC_ERROR;
4503: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4557: fnd_msg_pub.add;

4553: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4554:
4555:
4556: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
4557: fnd_msg_pub.add;
4558:
4559: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
4560: RAISE FND_API.G_EXC_ERROR;
4561: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 4587: fnd_msg_pub.add;

4583: END IF;
4584:
4585: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
4586: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
4587: fnd_msg_pub.add;
4588:
4589: RAISE fnd_api.g_exc_error;
4590:
4591:

Line 4673: fnd_msg_pub.add;

4669:
4670: /* Resource Start Date out of range for the role related start dates of the resource */
4671:
4672: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');
4673: fnd_msg_pub.add;
4674:
4675: RAISE fnd_api.g_exc_error;
4676:
4677:

Line 4687: fnd_msg_pub.add;

4683:
4684: /* Resource End Date out of range for the role related End dates of the Resource */
4685:
4686: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');
4687: fnd_msg_pub.add;
4688:
4689: RAISE fnd_api.g_exc_error;
4690:
4691:

Line 4720: fnd_msg_pub.add;

4716: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4717: l_min_start_date < l_start_date_active THEN
4718:
4719: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');
4720: fnd_msg_pub.add;
4721:
4722: RAISE fnd_api.g_exc_error;
4723:
4724:

Line 4731: fnd_msg_pub.add;

4727: IF l_end_date_active <> FND_API.G_MISS_DATE AND
4728: l_end_date_active IS NOT NULL THEN
4729:
4730: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');
4731: fnd_msg_pub.add;
4732:
4733: RAISE fnd_api.g_exc_error;
4734:
4735:

Line 4764: fnd_msg_pub.add;

4760: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4761: l_min_start_date < l_start_date_active THEN
4762:
4763: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');
4764: fnd_msg_pub.add;
4765:
4766: RAISE fnd_api.g_exc_error;
4767:
4768:

Line 4776: fnd_msg_pub.add;

4772: l_max_end_date > l_end_date_active AND
4773: l_end_date_active IS NOT NULL ) THEN
4774:
4775: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');
4776: fnd_msg_pub.add;
4777:
4778: RAISE fnd_api.g_exc_error;
4779:
4780:

Line 4809: fnd_msg_pub.add;

4805: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4806: l_min_start_date < l_start_date_active THEN
4807:
4808: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');
4809: fnd_msg_pub.add;
4810:
4811: RAISE fnd_api.g_exc_error;
4812:
4813:

Line 4820: fnd_msg_pub.add;

4816: IF l_end_date_active <> FND_API.G_MISS_DATE AND
4817: l_end_date_active IS NOT NULL THEN
4818:
4819: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');
4820: fnd_msg_pub.add;
4821:
4822: RAISE fnd_api.g_exc_error;
4823:
4824:

Line 4856: fnd_msg_pub.add;

4852: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4853: l_min_start_date < l_start_date_active THEN
4854:
4855: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');
4856: fnd_msg_pub.add;
4857:
4858: RAISE fnd_api.g_exc_error;
4859:
4860:

Line 4868: fnd_msg_pub.add;

4864: l_max_end_date > l_end_date_active AND
4865: l_end_date_active IS NOT NULL ) THEN
4866:
4867: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');
4868: fnd_msg_pub.add;
4869:
4870: RAISE fnd_api.g_exc_error;
4871:
4872:

Line 4900: fnd_msg_pub.add;

4896: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4897: l_min_start_date < l_start_date_active THEN
4898:
4899: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');
4900: fnd_msg_pub.add;
4901:
4902: RAISE fnd_api.g_exc_error;
4903:
4904:

Line 4911: fnd_msg_pub.add;

4907: IF l_end_date_active <> FND_API.G_MISS_DATE AND
4908: l_end_date_active IS NOT NULL THEN
4909:
4910: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');
4911: fnd_msg_pub.add;
4912:
4913: RAISE fnd_api.g_exc_error;
4914:
4915:

Line 4948: fnd_msg_pub.add;

4944:
4945: /* Resource Start Date out of range for the salesrep related start dates of the resource */
4946:
4947: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');
4948: fnd_msg_pub.add;
4949:
4950: RAISE fnd_api.g_exc_error;
4951:
4952: END IF;

Line 4961: fnd_msg_pub.add;

4957:
4958: /* Resource End Date out of range for the salesrep related End dates of the Resource */
4959:
4960: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');
4961: fnd_msg_pub.add;
4962:
4963: RAISE fnd_api.g_exc_error;
4964:
4965:

Line 4995: fnd_msg_pub.add;

4991: IF l_start_date_active <> FND_API.G_MISS_DATE AND
4992: l_min_start_date < l_start_date_active THEN
4993:
4994: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');
4995: fnd_msg_pub.add;
4996:
4997: RAISE fnd_api.g_exc_error;
4998:
4999:

Line 5006: fnd_msg_pub.add;

5002: IF l_end_date_active <> FND_API.G_MISS_DATE AND
5003: l_end_date_active IS NOT NULL THEN
5004:
5005: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');
5006: fnd_msg_pub.add;
5007:
5008: RAISE fnd_api.g_exc_error;
5009:
5010:

Line 5183: fnd_msg_pub.add;

5179: -- dbms_output.put_line('Invalid Assigned To Group Id');
5180:
5181: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');
5182: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);
5183: fnd_msg_pub.add;
5184:
5185: RAISE fnd_api.g_exc_error;
5186:
5187:

Line 5242: fnd_msg_pub.add;

5238:
5239: -- dbms_output.put_line('Commissionable Flag should either be ''Y'' or ''N'' ');
5240:
5241: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
5242: fnd_msg_pub.add;
5243:
5244: RAISE fnd_api.g_exc_error;
5245:
5246:

Line 5262: fnd_msg_pub.add;

5258:
5259: -- dbms_output.put_line('Hold Payment should either be ''Y'' or ''N'' ');
5260:
5261: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
5262: fnd_msg_pub.add;
5263:
5264: RAISE fnd_api.g_exc_error;
5265:
5266:

Line 5308: fnd_msg_pub.add;

5304:
5305: IF resource_rec.category NOT IN ('EMPLOYEE', 'PARTY', 'SUPPLIER_CONTACT') AND l_user_id IS NOT NULL THEN
5306:
5307: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');
5308: fnd_msg_pub.add;
5309:
5310: RAISE fnd_api.g_exc_error;
5311:
5312:

Line 5353: fnd_msg_pub.add;

5349: -- dbms_output.put_line('duplicate user Id');
5350:
5351: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');
5352: fnd_message.set_token('P_USER_ID', l_user_id);
5353: fnd_msg_pub.add;
5354:
5355: RAISE fnd_api.g_exc_error;
5356:
5357:

Line 5429: fnd_msg_pub.add;

5425:
5426: if not(l_address_found)
5427: then
5428: fnd_message.set_name('JTF', 'JTF_RS_NOT_PRIMARY_ADDR');
5429: fnd_msg_pub.add;
5430: RAISE fnd_api.g_exc_error;
5431:
5432: end if;
5433: end if; -- end of nvl check

Line 5444: fnd_msg_pub.add;

5440: IF ( l_fs_setup_complete <> 'Y' and l_fs_setup_complete <>'N') THEN
5441: l_jtf_rs_flag_name := 'FS Setup Complete Flag';
5442: fnd_message.set_name('JTF', 'JTF_RS_YES_NO');
5443: fnd_message.set_token('JTF_RS_FLAG', l_jtf_rs_flag_name);
5444: fnd_msg_pub.add;
5445:
5446: RAISE fnd_api.g_exc_error;
5447: END IF;
5448: END IF;

Line 5471: fnd_msg_pub.add;

5467: -- dbms_output.put_line('Error in Locking the Row');
5468:
5469:
5470: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
5471: fnd_msg_pub.add;
5472:
5473: RAISE fnd_api.g_exc_error;
5474:
5475:

Line 5749: fnd_msg_pub.add;

5745:
5746: x_return_status := fnd_api.g_ret_sts_unexp_error;
5747:
5748: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
5749: fnd_msg_pub.add;
5750:
5751: RAISE fnd_api.g_exc_error;
5752:
5753:

Line 5815: fnd_msg_pub.add;

5811: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
5812:
5813:
5814: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
5815: fnd_msg_pub.add;
5816:
5817: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
5818: RAISE FND_API.G_EXC_ERROR;
5819: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5874: fnd_msg_pub.add;

5870: -- dbms_output.put_line('Returned Error status from the Post Vertical User Hook');
5871:
5872:
5873: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
5874: fnd_msg_pub.add;
5875:
5876: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
5877: RAISE FND_API.G_EXC_ERROR;
5878: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5934: fnd_msg_pub.add;

5930: -- dbms_output.put_line('Returned Error status from the Post Customer User Hook');
5931:
5932:
5933: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
5934: fnd_msg_pub.add;
5935:
5936: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
5937: RAISE FND_API.G_EXC_ERROR;
5938: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5995: fnd_msg_pub.add;

5991: -- dbms_output.put_line('Returned Error status from the Message Generation API');
5992:
5993:
5994: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
5995: fnd_msg_pub.add;
5996:
5997: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
5998: RAISE FND_API.G_EXC_ERROR;
5999: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

6014: COMMIT WORK;
6015:
6016: END IF;
6017:
6018: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6019:
6020: EXCEPTION
6021:
6022:

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

6022:
6023: WHEN fnd_api.g_exc_error THEN
6024: ROLLBACK TO update_resource_pvt;
6025: x_return_status := fnd_api.g_ret_sts_error;
6026: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6027: p_data => x_msg_data);
6028: WHEN fnd_api.g_exc_unexpected_error THEN
6029: ROLLBACK TO update_resource_pvt;
6030: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

6027: p_data => x_msg_data);
6028: WHEN fnd_api.g_exc_unexpected_error THEN
6029: ROLLBACK TO update_resource_pvt;
6030: x_return_status := fnd_api.g_ret_sts_unexp_error;
6031: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6032: p_data => x_msg_data);
6033: WHEN OTHERS THEN
6034: ROLLBACK TO update_resource_pvt;
6035: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls

Line 6041: -- FND_MSG_PUB.add;

6037: -- THEN
6038: -- IF(l_value = 'XMLGEN')
6039: -- THEN
6040: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
6041: -- FND_MSG_PUB.add;
6042: -- ELSIF(l_value = 'JTF_USR_HKS')
6043: -- THEN
6044: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
6045: -- FND_MSG_PUB.add;

Line 6045: -- FND_MSG_PUB.add;

6041: -- FND_MSG_PUB.add;
6042: -- ELSIF(l_value = 'JTF_USR_HKS')
6043: -- THEN
6044: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
6045: -- FND_MSG_PUB.add;
6046: -- END IF;
6047: -- ELSE
6048: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
6049: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 6052: FND_MSG_PUB.add;

6048: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
6049: fnd_message.set_token('P_SQLCODE',SQLCODE);
6050: fnd_message.set_token('P_SQLERRM',SQLERRM);
6051: fnd_message.set_token('P_API_NAME', l_api_name);
6052: FND_MSG_PUB.add;
6053: -- END IF;
6054: x_return_status := fnd_api.g_ret_sts_unexp_error;
6055: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6056: p_data => x_msg_data);

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

6051: fnd_message.set_token('P_API_NAME', l_api_name);
6052: FND_MSG_PUB.add;
6053: -- END IF;
6054: x_return_status := fnd_api.g_ret_sts_unexp_error;
6055: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6056: p_data => x_msg_data);
6057:
6058:
6059: END update_resource;

Line 6278: fnd_msg_pub.initialize;

6274:
6275:
6276: IF fnd_api.to_boolean(p_init_msg_list) THEN
6277:
6278: fnd_msg_pub.initialize;
6279:
6280: END IF;
6281:
6282:

Line 6306: fnd_msg_pub.add;

6302: x_return_status => x_return_status);
6303:
6304: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6305: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
6306: fnd_msg_pub.add;
6307: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6308: RAISE FND_API.G_EXC_ERROR;
6309: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6340: fnd_msg_pub.add;

6336: x_return_status => x_return_status);
6337:
6338: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6339: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
6340: fnd_msg_pub.add;
6341: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6342: RAISE FND_API.G_EXC_ERROR;
6343: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6344: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6373: fnd_msg_pub.add;

6369: x_return_status => x_return_status);
6370:
6371: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6372: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
6373: fnd_msg_pub.add;
6374:
6375: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6376: RAISE FND_API.G_EXC_ERROR;
6377: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 6441: fnd_msg_pub.add;

6437: p_resource_id => l_resource_id,
6438: x_return_status => x_return_status);
6439: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6440: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
6441: fnd_msg_pub.add;
6442: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6443: RAISE FND_API.G_EXC_ERROR;
6444: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6473: fnd_msg_pub.add;

6469: p_resource_id => l_resource_id,
6470: x_return_status => x_return_status);
6471: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6472: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
6473: fnd_msg_pub.add;
6474: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6475: RAISE FND_API.G_EXC_ERROR;
6476: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6506: fnd_msg_pub.add;

6502: x_return_status => x_return_status);
6503:
6504: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
6505: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
6506: fnd_msg_pub.add;
6507: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6508: RAISE FND_API.G_EXC_ERROR;
6509: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
6510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6565: fnd_msg_pub.add;

6561: -- dbms_output.put_line('Returned Error status from the Message Generation API');
6562:
6563:
6564: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
6565: fnd_msg_pub.add;
6566:
6567: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
6568: RAISE FND_API.G_EXC_ERROR;
6569: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

6584: COMMIT WORK;
6585:
6586: END IF;
6587:
6588: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6589:
6590: if (l_category = 'TBH') then
6591:
6592: /* Calling publish API to raise create resource event. */

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

6633:
6634: WHEN fnd_api.g_exc_error THEN
6635: ROLLBACK TO delete_resource_pvt;
6636: x_return_status := fnd_api.g_ret_sts_error;
6637: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6638: p_data => x_msg_data);
6639: WHEN fnd_api.g_exc_unexpected_error THEN
6640: ROLLBACK TO delete_resource_pvt;
6641: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

6638: p_data => x_msg_data);
6639: WHEN fnd_api.g_exc_unexpected_error THEN
6640: ROLLBACK TO delete_resource_pvt;
6641: x_return_status := fnd_api.g_ret_sts_unexp_error;
6642: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6643: p_data => x_msg_data);
6644: WHEN OTHERS THEN
6645: ROLLBACK TO delete_resource_pvt;
6646: -- The below lines removed as a part of fixing GSCC errors in R12 for jtfrspub.pls

Line 6652: -- FND_MSG_PUB.add;

6648: -- THEN
6649: -- IF(l_value = 'XMLGEN')
6650: -- THEN
6651: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');
6652: -- FND_MSG_PUB.add;
6653: -- ELSIF(l_value = 'JTF_USR_HKS')
6654: -- THEN
6655: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
6656: -- FND_MSG_PUB.add;

Line 6656: -- FND_MSG_PUB.add;

6652: -- FND_MSG_PUB.add;
6653: -- ELSIF(l_value = 'JTF_USR_HKS')
6654: -- THEN
6655: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');
6656: -- FND_MSG_PUB.add;
6657: -- END IF;
6658: -- ELSE
6659: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
6660: fnd_message.set_token('P_SQLCODE',SQLCODE);

Line 6663: FND_MSG_PUB.add;

6659: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
6660: fnd_message.set_token('P_SQLCODE',SQLCODE);
6661: fnd_message.set_token('P_SQLERRM',SQLERRM);
6662: fnd_message.set_token('P_API_NAME', l_api_name);
6663: FND_MSG_PUB.add;
6664: -- END IF;
6665: x_return_status := fnd_api.g_ret_sts_unexp_error;
6666: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6667: p_data => x_msg_data);

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

6662: fnd_message.set_token('P_API_NAME', l_api_name);
6663: FND_MSG_PUB.add;
6664: -- END IF;
6665: x_return_status := fnd_api.g_ret_sts_unexp_error;
6666: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
6667: p_data => x_msg_data);
6668:
6669: END delete_resource;
6670: