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_MESSAGE

Line 59: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

55:
56: EXCEPTION
57: WHEN OTHERS
58: THEN
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;

Line 60: fnd_message.set_token('P_SQLCODE',SQLCODE);

56: EXCEPTION
57: WHEN OTHERS
58: THEN
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;

Line 61: fnd_message.set_token('P_SQLERRM',SQLERRM);

57: WHEN OTHERS
58: THEN
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:

Line 62: fnd_message.set_token('P_API_NAME', l_api_name);

58: THEN
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;

Line 271: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

267:
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;

Line 333: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

329:
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;

Line 394: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

390:
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;

Line 450: fnd_message.set_name('JTF', 'JTF_RS_NOT_PRIMARY_ADDR');

446: end if;
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;

Line 601: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

597: IF c_jtf_rs_resource_extns%ISOPEN THEN
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

Line 665: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

661:
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;

Line 721: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

717:
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;

Line 781: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

777:
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;

Line 841: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

837:
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;

Line 886: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');

882: -- IF NOT(jtf_resource_utl.check_access(l_value))
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');

Line 890: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');

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;
892: -- END IF;
893: -- ELSE
894: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 894: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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);
896: fnd_message.set_token('P_SQLERRM',SQLERRM);
897: fnd_message.set_token('P_API_NAME', l_api_name);
898: FND_MSG_PUB.add;

Line 895: fnd_message.set_token('P_SQLCODE',SQLCODE);

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

Line 896: fnd_message.set_token('P_SQLERRM',SQLERRM);

892: -- END IF;
893: -- ELSE
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;

Line 897: fnd_message.set_token('P_API_NAME', l_api_name);

893: -- ELSE
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,

Line 1227: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

1223:
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;

Line 1290: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

1286:
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;

Line 1351: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

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

Line 1408: fnd_message.set_name('JTF', 'JTF_RS_NOT_PRIMARY_ADDR');

1404: end if;
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;

Line 1627: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

1623: IF c_jtf_rs_resource_extns%ISOPEN THEN
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');

Line 1684: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

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

Line 1743: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

1739:
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;

Line 1804: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

1800: x_return_status => x_return_status);
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;

Line 1865: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

1861:
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;

Line 1962: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');

1958: -- IF NOT(jtf_resource_utl.check_access(l_value))
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');

Line 1966: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');

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;
1968: -- END IF;
1969: -- ELSE
1970: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1970: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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);
1972: fnd_message.set_token('P_SQLERRM',SQLERRM);
1973: fnd_message.set_token('P_API_NAME', l_api_name);
1974: FND_MSG_PUB.add;

Line 1971: fnd_message.set_token('P_SQLCODE',SQLCODE);

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

Line 1972: fnd_message.set_token('P_SQLERRM',SQLERRM);

1968: -- END IF;
1969: -- ELSE
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;

Line 1973: fnd_message.set_token('P_API_NAME', l_api_name);

1969: -- ELSE
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,

Line 2463: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

2459:
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;

Line 2523: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

2519:
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;

Line 2581: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

2577:
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;

Line 2609: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');

2605: CLOSE c_resource_update;
2606:
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;

Line 2610: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);

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

Line 2692: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');

2688: l_min_start_date < l_start_date_active THEN
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:

Line 2706: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');

2702: l_end_date_active IS NOT NULL ) THEN
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:

Line 2740: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');

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

Line 2751: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');

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

Line 2788: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');

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

Line 2800: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');

2796: IF ( l_end_date_active <> FND_API.G_MISS_DATE AND
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:

Line 2833: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');

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

Line 2844: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');

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

Line 2881: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');

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

Line 2893: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');

2889: IF ( l_end_date_active <> FND_API.G_MISS_DATE AND
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:

Line 2928: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');

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

Line 2939: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');

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

Line 2978: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');

2974: l_min_start_date < l_start_date_active THEN
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:

Line 2992: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');

2988: l_end_date_active IS NOT NULL ) THEN
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:

Line 3026: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');

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

Line 3037: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');

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

Line 3213: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');

3209: IF c_assigned_to_group_id%NOTFOUND THEN
3210:
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;

Line 3214: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);

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

Line 3273: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');

3269: IF l_commissionable_flag <> 'Y' AND l_commissionable_flag <> 'N' THEN
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:

Line 3293: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');

3289: IF l_hold_payment <> 'Y' AND l_hold_payment <> 'N' THEN
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:

Line 3340: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');

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

Line 3384: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');

3380: IF c_validate_user_id%FOUND THEN
3381:
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;

Line 3385: fnd_message.set_token('P_USER_ID', l_user_id);

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

Line 3459: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

3455: -- dbms_output.put_line('Error in Locking the Row');
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:

Line 3606: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

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

Line 3671: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

3667: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
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;

Line 3731: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

3727:
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;

Line 3791: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

3787:
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;

Line 3851: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

3847:
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;

Line 3897: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');

3893: -- IF NOT(jtf_resource_utl.check_access(l_value))
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');

Line 3901: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');

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;
3903: -- END IF;
3904: -- ELSE
3905: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 3905: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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);
3907: fnd_message.set_token('P_SQLERRM',SQLERRM);
3908: fnd_message.set_token('P_API_NAME', l_api_name);
3909: FND_MSG_PUB.add;

Line 3906: fnd_message.set_token('P_SQLCODE',SQLCODE);

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

Line 3907: fnd_message.set_token('P_SQLERRM',SQLERRM);

3903: -- END IF;
3904: -- ELSE
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;

Line 3908: fnd_message.set_token('P_API_NAME', l_api_name);

3904: -- ELSE
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,

Line 4439: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

4435:
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;

Line 4498: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

4494: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
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;

Line 4556: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

4552:
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;

Line 4585: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');

4581: CLOSE c_resource_update;
4582:
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;

Line 4586: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);

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

Line 4672: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');

4668: l_min_start_date < l_start_date_active THEN
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:

Line 4686: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');

4682: l_end_date_active IS NOT NULL ) THEN
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:

Line 4719: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_START_DATE');

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

Line 4730: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_ROLE_END_DATE');

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

Line 4763: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');

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

Line 4775: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');

4771: IF ( l_end_date_active <> FND_API.G_MISS_DATE AND
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:

Line 4808: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_START_DATE');

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

Line 4819: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_GMBR_END_DATE');

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

Line 4855: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');

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

Line 4867: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');

4863: IF ( l_end_date_active <> FND_API.G_MISS_DATE AND
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:

Line 4899: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_START_DATE');

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

Line 4910: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_TMBR_END_DATE');

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

Line 4947: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');

4943: l_min_start_date < l_start_date_active THEN
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:

Line 4960: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');

4956: l_end_date_active IS NOT NULL ) THEN
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:

Line 4994: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_START_DATE');

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

Line 5005: fnd_message.set_name('JTF', 'JTF_RS_ERR_RES_SRP_END_DATE');

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

Line 5181: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');

5177: IF c_assigned_to_group_id%NOTFOUND THEN
5178:
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;

Line 5182: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);

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

Line 5241: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');

5237: IF l_commissionable_flag <> 'Y' AND l_commissionable_flag <> 'N' THEN
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:

Line 5261: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');

5257: IF l_hold_payment <> 'Y' AND l_hold_payment <> 'N' THEN
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:

Line 5307: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');

5303: IF l_user_id <> fnd_api.g_miss_num THEN
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:

Line 5351: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');

5347: IF c_validate_user_id%FOUND THEN
5348:
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;

Line 5352: fnd_message.set_token('P_USER_ID', l_user_id);

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

Line 5428: fnd_message.set_name('JTF', 'JTF_RS_NOT_PRIMARY_ADDR');

5424: end if;
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;

Line 5442: fnd_message.set_name('JTF', 'JTF_RS_YES_NO');

5438: IF l_fs_setup_complete <> fnd_api.g_miss_char AND l_fs_setup_complete IS NOT NULL THEN
5439:
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;

Line 5443: fnd_message.set_token('JTF_RS_FLAG', l_jtf_rs_flag_name);

5439:
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;

Line 5470: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

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

Line 5748: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

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

Line 5814: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

5810:
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;

Line 5873: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

5869:
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;

Line 5933: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

5929:
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;

Line 5994: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

5990:
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;

Line 6040: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');

6036: -- IF NOT(jtf_resource_utl.check_access(l_value))
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');

Line 6044: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');

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;
6046: -- END IF;
6047: -- ELSE
6048: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 6048: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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);
6050: fnd_message.set_token('P_SQLERRM',SQLERRM);
6051: fnd_message.set_token('P_API_NAME', l_api_name);
6052: FND_MSG_PUB.add;

Line 6049: fnd_message.set_token('P_SQLCODE',SQLCODE);

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

Line 6050: fnd_message.set_token('P_SQLERRM',SQLERRM);

6046: -- END IF;
6047: -- ELSE
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;

Line 6051: fnd_message.set_token('P_API_NAME', l_api_name);

6047: -- ELSE
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,

Line 6305: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

6301: p_resource_id => l_resource_id,
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

Line 6339: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

6335: p_resource_id => l_resource_id,
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

Line 6372: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

6368: p_resource_id => l_resource_id,
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;

Line 6440: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

6436: jtf_rs_resource_cuhk.delete_resource_post(
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

Line 6472: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

6468: jtf_rs_resource_vuhk.delete_resource_post(
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

Line 6505: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

6501: p_resource_id => l_resource_id,
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

Line 6564: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

6560:
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;

Line 6651: -- fnd_message.set_name ('JTF', 'JTF_RS_XMLGEN_ERR');

6647: -- IF NOT(jtf_resource_utl.check_access(l_value))
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');

Line 6655: -- fnd_message.set_name ('JTF', 'JTF_RS_JUHK_ERR');

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;
6657: -- END IF;
6658: -- ELSE
6659: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 6659: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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);
6661: fnd_message.set_token('P_SQLERRM',SQLERRM);
6662: fnd_message.set_token('P_API_NAME', l_api_name);
6663: FND_MSG_PUB.add;

Line 6660: fnd_message.set_token('P_SQLCODE',SQLCODE);

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

Line 6661: fnd_message.set_token('P_SQLERRM',SQLERRM);

6657: -- END IF;
6658: -- ELSE
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;

Line 6662: fnd_message.set_token('P_API_NAME', l_api_name);

6658: -- ELSE
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,