DBA Data[Home] [Help]

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 2464: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4572: CLOSE c_resource_update;
4573:
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

5168: IF c_assigned_to_group_id%NOTFOUND THEN
5169:
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;

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

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

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

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

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

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

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

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

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

5338: IF c_validate_user_id%FOUND THEN
5339:
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
6019: -- END IF;
6020: -- ELSE
6021: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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

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);
6023: fnd_message.set_token('P_SQLERRM',SQLERRM);
6024: fnd_message.set_token('P_API_NAME', l_api_name);
6025: FND_MSG_PUB.add;

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

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

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

6019: -- END IF;
6020: -- ELSE
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
6461: -- END IF;
6462: -- ELSE
6463: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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

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);
6465: fnd_message.set_token('P_SQLERRM',SQLERRM);
6466: fnd_message.set_token('P_API_NAME', l_api_name);
6467: FND_MSG_PUB.add;

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

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

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

6461: -- END IF;
6462: -- ELSE
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;

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

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