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

Line 102: fnd_msg_pub.add;

98: exception
99: when no_data_found then
100: fnd_message.set_name('JTF', 'JTF_RS_ROLE_NOTFOUND');
101: fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);
102: fnd_msg_pub.add;
103: return null ;
104: when too_many_rows then
105: fnd_message.set_name('JTF', 'JTF_RS_MORE_WF_ROLES');
106: fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);

Line 107: fnd_msg_pub.add;

103: return null ;
104: when too_many_rows then
105: fnd_message.set_name('JTF', 'JTF_RS_MORE_WF_ROLES');
106: fnd_message.set_token('P_RESOURCE_NAME', l_resource_name);
107: fnd_msg_pub.add;
108: return null ;
109: when others then
110: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_GET_ROLE_ERR');
111: fnd_msg_pub.add;

Line 111: fnd_msg_pub.add;

107: fnd_msg_pub.add;
108: return null ;
109: when others then
110: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_GET_ROLE_ERR');
111: fnd_msg_pub.add;
112: return null ;
113: END;
114:
115:

Line 472: fnd_msg_pub.initialize;

468:
469:
470: IF fnd_api.to_boolean(p_init_msg_list) THEN
471:
472: fnd_msg_pub.initialize;
473:
474: END IF;
475:
476:

Line 525: fnd_msg_pub.add;

521:
522: -- dbms_output.put_line('For OTHER category, source_id, address_id, contact_id and managing_emp_id should be all null');
523:
524: fnd_message.set_name('JTF', 'JTF_RS_OTHER_IDS_NOT_NULL');
525: fnd_msg_pub.add;
526: RAISE fnd_api.g_exc_error;
527:
528: END IF;
529:

Line 541: fnd_msg_pub.add;

537:
538: IF (l_source_id IS NULL) THEN
539: -- dbms_output.put_line('For PARTNER category, source_id should not be null');
540: fnd_message.set_name('JTF', 'JTF_RS_PARTNER_IDS_NULL');
541: fnd_msg_pub.add;
542: RAISE fnd_api.g_exc_error;
543: ELSE
544: IF G_RS_ID_PUB_FLAG = 'Y' THEN --This flag is checked for migration purpose.
545: OPEN c_validate_partner(l_source_id);

Line 550: fnd_msg_pub.add;

546: FETCH c_validate_partner INTO l_check_flag;
547: IF c_validate_partner%NOTFOUND THEN
548: -- dbms_output.put_line('Partner does not exist for the passed source_id');
549: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTNER_IDS');
550: fnd_msg_pub.add;
551: RAISE fnd_api.g_exc_error;
552: END IF;
553: CLOSE c_validate_partner;
554: ELSIF G_RS_ID_PUB_FLAG = 'N' THEN

Line 561: fnd_msg_pub.add;

557: JTF_RESOURCE_UTL.G_SOURCE_NAME := l_source_name;
558: IF c_validate_partner_migr%NOTFOUND THEN
559: -- dbms_output.put_line('Partner does not exist for the passed source_id');
560: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTNER_IDS');
561: fnd_msg_pub.add;
562: RAISE fnd_api.g_exc_error;
563: END IF;
564: CLOSE c_validate_partner_migr;
565: END IF;

Line 577: fnd_msg_pub.add;

573: IF c_validate_partner_address%NOTFOUND THEN
574: -- dbms_output.put_line('Invalid Partner Address Id');
575: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTNER_ADDRESS_ID');
576: fnd_message.set_token('P_ADDRESS_ID', l_address_id);
577: fnd_msg_pub.add;
578: RAISE fnd_api.g_exc_error;
579: END IF;
580: CLOSE c_validate_partner_address;
581: END IF;

Line 593: fnd_msg_pub.add;

589: IF c_validate_partner_contact%NOTFOUND THEN
590: -- dbms_output.put_line('Invalid Partner Contact Id');
591: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTNER_CONTACT_ID');
592: fnd_message.set_token('P_CONTACT_ID', l_contact_id);
593: fnd_msg_pub.add;
594: RAISE fnd_api.g_exc_error;
595: END IF;
596: CLOSE c_validate_partner_contact;
597: END IF;

Line 610: fnd_msg_pub.add;

606: IF l_category NOT IN ('OTHER' , 'PARTNER' , 'TBH', 'EMPLOYEE') THEN
607: IF l_source_id IS NULL THEN
608: -- dbms_output.put_line('Source Id should not be Null');
609: fnd_message.set_name('JTF', 'JTF_RS_SOURCE_ID_NULL');
610: fnd_msg_pub.add;
611: RAISE fnd_api.g_exc_error;
612: END IF;
613:
614: jtf_resource_utl.check_object_existence_migr(

Line 635: fnd_msg_pub.add;

631:
632: IF l_found = FALSE THEN
633: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SOURCE_ID');
634: fnd_message.set_token('P_SOURCE_ID', l_source_id);
635: fnd_msg_pub.add;
636: RAISE fnd_api.g_exc_error;
637: END IF;
638:
639: END IF;

Line 649: fnd_msg_pub.add;

645: if l_category = 'EMPLOYEE' THEN
646: -- First check is null check for source id
647: IF l_source_id IS NULL THEN
648: fnd_message.set_name('JTF', 'JTF_RS_SOURCE_ID_NULL');
649: fnd_msg_pub.add;
650: RAISE fnd_api.g_exc_error;
651: END IF;
652:
653: open c_emp_exist(l_source_id);

Line 661: fnd_msg_pub.add;

657: if(nvl(r_emp_exist.value , 'y') <> 'x')
658: then
659: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SOURCE_ID');
660: fnd_message.set_token('P_SOURCE_ID', l_source_id);
661: fnd_msg_pub.add;
662: RAISE fnd_api.g_exc_error;
663: end if;
664:
665: END IF; -- end of check l_category = 'EMPLOYEE'

Line 686: fnd_msg_pub.add;

682: -- dbms_output.put_line('Invalid Party Address');
683:
684: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTY_ADDRESS');
685: fnd_message.set_token('P_ADDRESS_ID', l_address_id);
686: fnd_msg_pub.add;
687:
688: RAISE fnd_api.g_exc_error;
689:
690: END IF;

Line 715: fnd_msg_pub.add;

711: -- dbms_output.put_line('Invalid Party Contact Id');
712:
713: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTY_CONTACT_ID');
714: fnd_message.set_token('P_CONTACT_ID', l_contact_id);
715: fnd_msg_pub.add;
716:
717: RAISE fnd_api.g_exc_error;
718:
719: END IF;

Line 745: fnd_msg_pub.add;

741:
742: -- dbms_output.put_line('For SUPPLIER_CONTACT category, address_id and contact_id should be null');
743:
744: fnd_message.set_name('JTF', 'JTF_RS_SC_IDS_NOT_NULL');
745: fnd_msg_pub.add;
746:
747: RAISE fnd_api.g_exc_error;
748:
749: END IF;

Line 767: fnd_msg_pub.add;

763:
764: -- dbms_output.put_line('For EMPLOYEE category, contact_id should be null');
765:
766: fnd_message.set_name('JTF', 'JTF_RS_EMP_IDS_NOT_NULL');
767: fnd_msg_pub.add;
768:
769: RAISE fnd_api.g_exc_error;
770:
771: END IF;

Line 805: fnd_msg_pub.add;

801:
802: -- dbms_output.put_line('Start Date Active cannot be null');
803:
804: fnd_message.set_name('JTF', 'JTF_RS_START_DATE_NULL');
805: fnd_msg_pub.add;
806:
807: RAISE fnd_api.g_exc_error;
808:
809: END IF;

Line 933: fnd_msg_pub.add;

929: -- dbms_output.put_line('Invalid Assigned To Group Id');
930:
931: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');
932: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);
933: fnd_msg_pub.add;
934: RAISE fnd_api.g_exc_error;
935:
936: END IF;
937:

Line 974: fnd_msg_pub.add;

970:
971: -- dbms_output.put_line('Commissionable Flag should either be ''Y'' or ''N'' ');
972:
973: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
974: fnd_msg_pub.add;
975:
976: RAISE fnd_api.g_exc_error;
977:
978: END IF;

Line 988: fnd_msg_pub.add;

984:
985: -- dbms_output.put_line('Hold Payment should either be ''Y'' or ''N'' ');
986:
987: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
988: fnd_msg_pub.add;
989: RAISE fnd_api.g_exc_error;
990:
991: END IF;
992:

Line 1023: fnd_msg_pub.add;

1019:
1020: IF l_user_id IS NOT NULL THEN
1021:
1022: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');
1023: fnd_msg_pub.add;
1024:
1025: RAISE fnd_api.g_exc_error;
1026:
1027: END IF;

Line 1063: fnd_msg_pub.add;

1059: -- dbms_output.put_line('duplicate user Id');
1060:
1061: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');
1062: fnd_message.set_token('P_USER_ID', l_user_id);
1063: fnd_msg_pub.add;
1064:
1065: RAISE fnd_api.g_exc_error;
1066:
1067: END IF;

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

1291: COMMIT WORK;
1292:
1293: END IF;
1294:
1295: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1296:
1297:
1298: EXCEPTION
1299:

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

1300:
1301: WHEN fnd_api.g_exc_error THEN
1302: ROLLBACK TO create_resource_pub;
1303: x_return_status := fnd_api.g_ret_sts_error;
1304: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1305: p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_resource_pub;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1305: p_data => x_msg_data);
1306: WHEN fnd_api.g_exc_unexpected_error THEN
1307: ROLLBACK TO create_resource_pub;
1308: x_return_status := fnd_api.g_ret_sts_unexp_error;
1309: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1310: p_data => x_msg_data);
1311: WHEN OTHERS THEN
1312: ROLLBACK TO create_resource_pub;
1313: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1317: FND_MSG_PUB.add;

1313: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1314: fnd_message.set_token('P_SQLCODE',SQLCODE);
1315: fnd_message.set_token('P_SQLERRM',SQLERRM);
1316: fnd_message.set_token('P_API_NAME', l_api_name);
1317: FND_MSG_PUB.add;
1318: x_return_status := fnd_api.g_ret_sts_unexp_error;
1319: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1320: p_data => x_msg_data);
1321:

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

1315: fnd_message.set_token('P_SQLERRM',SQLERRM);
1316: fnd_message.set_token('P_API_NAME', l_api_name);
1317: FND_MSG_PUB.add;
1318: x_return_status := fnd_api.g_ret_sts_unexp_error;
1319: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1320: p_data => x_msg_data);
1321:
1322: END create_resource;
1323:

Line 1571: fnd_msg_pub.initialize;

1567:
1568:
1569: IF fnd_api.to_boolean(p_init_msg_list) THEN
1570:
1571: fnd_msg_pub.initialize;
1572:
1573: END IF;
1574:
1575:

Line 1583: fnd_msg_pub.add;

1579:
1580: -- dbms_output.put_line('Resource Id and Resource Number are null');
1581:
1582: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
1583: fnd_msg_pub.add;
1584:
1585: RAISE fnd_api.g_exc_error;
1586:
1587: END IF;

Line 1602: fnd_msg_pub.add;

1598: -- dbms_output.put_line('Invalid or Inactive Resource');
1599:
1600: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
1601: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
1602: fnd_msg_pub.add;
1603:
1604: RAISE fnd_api.g_exc_error;
1605:
1606: END IF;

Line 1622: fnd_msg_pub.add;

1618: -- dbms_output.put_line('Invalid or Inactive Resource');
1619:
1620: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
1621: fnd_message.set_token('P_RESOURCE_NUMBER', l_resource_number);
1622: fnd_msg_pub.add;
1623:
1624: RAISE fnd_api.g_exc_error;
1625:
1626: END IF;

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

1687: COMMIT WORK;
1688:
1689: END IF;
1690:
1691: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1692:
1693:
1694:
1695: EXCEPTION

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

1695: EXCEPTION
1696: WHEN fnd_api.g_exc_error THEN
1697: ROLLBACK TO update_resource_pub;
1698: x_return_status := fnd_api.g_ret_sts_error;
1699: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1700: p_data => x_msg_data);
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1702: ROLLBACK TO update_resource_pub;
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1700: p_data => x_msg_data);
1701: WHEN fnd_api.g_exc_unexpected_error THEN
1702: ROLLBACK TO update_resource_pub;
1703: x_return_status := fnd_api.g_ret_sts_unexp_error;
1704: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1705: p_data => x_msg_data);
1706: WHEN OTHERS THEN
1707: ROLLBACK TO update_resource_pub;
1708: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1712: FND_MSG_PUB.add;

1708: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1709: fnd_message.set_token('P_SQLCODE',SQLCODE);
1710: fnd_message.set_token('P_SQLERRM',SQLERRM);
1711: fnd_message.set_token('P_API_NAME', l_api_name);
1712: FND_MSG_PUB.add;
1713: x_return_status := fnd_api.g_ret_sts_unexp_error;
1714: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1715: p_data => x_msg_data);
1716:

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

1710: fnd_message.set_token('P_SQLERRM',SQLERRM);
1711: fnd_message.set_token('P_API_NAME', l_api_name);
1712: FND_MSG_PUB.add;
1713: x_return_status := fnd_api.g_ret_sts_unexp_error;
1714: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1715: p_data => x_msg_data);
1716:
1717: END update_resource;
1718:

Line 1894: fnd_msg_pub.initialize;

1890:
1891:
1892: IF fnd_api.to_boolean(p_init_msg_list) THEN
1893:
1894: fnd_msg_pub.initialize;
1895:
1896: END IF;
1897:
1898:

Line 1906: fnd_msg_pub.add;

1902:
1903: -- dbms_output.put_line('Resource Id and Resource Number are null');
1904:
1905: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
1906: fnd_msg_pub.add;
1907:
1908: RAISE fnd_api.g_exc_error;
1909:
1910: END IF;

Line 1925: fnd_msg_pub.add;

1921: -- dbms_output.put_line('Invalid or Inactive Resource');
1922:
1923: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
1924: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
1925: fnd_msg_pub.add;
1926:
1927: RAISE fnd_api.g_exc_error;
1928:
1929: END IF;

Line 1945: fnd_msg_pub.add;

1941: -- dbms_output.put_line('Invalid or Inactive Resource');
1942:
1943: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
1944: fnd_message.set_token('P_RESOURCE_NUMBER', l_resource_number);
1945: fnd_msg_pub.add;
1946:
1947: RAISE fnd_api.g_exc_error;
1948:
1949:

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

2056: COMMIT WORK;
2057:
2058: END IF;
2059:
2060: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2061:
2062:
2063:
2064: EXCEPTION

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

2065:
2066: WHEN fnd_api.g_exc_error THEN
2067: ROLLBACK TO update_resource_pub;
2068: x_return_status := fnd_api.g_ret_sts_error;
2069: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2070: p_data => x_msg_data);
2071: WHEN fnd_api.g_exc_unexpected_error THEN
2072: ROLLBACK TO update_resource_pub;
2073: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2070: p_data => x_msg_data);
2071: WHEN fnd_api.g_exc_unexpected_error THEN
2072: ROLLBACK TO update_resource_pub;
2073: x_return_status := fnd_api.g_ret_sts_unexp_error;
2074: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2075: p_data => x_msg_data);
2076: WHEN OTHERS THEN
2077: ROLLBACK TO update_resource_pub;
2078: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 2082: FND_MSG_PUB.add;

2078: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2079: fnd_message.set_token('P_SQLCODE',SQLCODE);
2080: fnd_message.set_token('P_SQLERRM',SQLERRM);
2081: fnd_message.set_token('P_API_NAME', l_api_name);
2082: FND_MSG_PUB.add;
2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2085: p_data => x_msg_data);
2086:

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

2080: fnd_message.set_token('P_SQLERRM',SQLERRM);
2081: fnd_message.set_token('P_API_NAME', l_api_name);
2082: FND_MSG_PUB.add;
2083: x_return_status := fnd_api.g_ret_sts_unexp_error;
2084: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2085: p_data => x_msg_data);
2086:
2087:
2088: END update_resource;

Line 2131: fnd_msg_pub.initialize;

2127: RAISE fnd_api.g_exc_unexpected_error;
2128: END IF;
2129:
2130: IF fnd_api.to_boolean(p_init_msg_list) THEN
2131: fnd_msg_pub.initialize;
2132: END IF;
2133:
2134:
2135: /* Validate the Resource. */

Line 2138: fnd_msg_pub.add;

2134:
2135: /* Validate the Resource. */
2136: IF l_resource_id IS NULL THEN
2137: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
2138: fnd_msg_pub.add;
2139: RAISE fnd_api.g_exc_error;
2140:
2141: END IF;
2142:

Line 2150: fnd_msg_pub.add;

2146: FETCH res_cur INTO res_rec;
2147: IF res_cur%NOTFOUND THEN
2148: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
2149: fnd_message.set_token('P_RESOURCE_ID', l_resource_id);
2150: fnd_msg_pub.add;
2151: RAISE fnd_api.g_exc_error;
2152:
2153: END IF;
2154: IF res_rec.category <> 'TBH'

Line 2157: fnd_msg_pub.add;

2153: END IF;
2154: IF res_rec.category <> 'TBH'
2155: THEN
2156: fnd_message.set_name('JTF', 'JTF_RS_NOT_TBH');
2157: fnd_msg_pub.add;
2158: RAISE fnd_api.g_exc_error;
2159: END IF;
2160: CLOSE res_cur;
2161:

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

2185:
2186: IF fnd_api.to_boolean(p_commit) THEN
2187: COMMIT WORK;
2188: END IF;
2189: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2190:
2191: EXCEPTION
2192: WHEN fnd_api.g_exc_error THEN
2193: ROLLBACK TO delete_resource_pub;

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

2191: EXCEPTION
2192: WHEN fnd_api.g_exc_error THEN
2193: ROLLBACK TO delete_resource_pub;
2194: x_return_status := fnd_api.g_ret_sts_error;
2195: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2196: p_data => x_msg_data);
2197: WHEN fnd_api.g_exc_unexpected_error THEN
2198: ROLLBACK TO delete_resource_pub;
2199: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2196: p_data => x_msg_data);
2197: WHEN fnd_api.g_exc_unexpected_error THEN
2198: ROLLBACK TO delete_resource_pub;
2199: x_return_status := fnd_api.g_ret_sts_unexp_error;
2200: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2201: p_data => x_msg_data);
2202: WHEN OTHERS THEN
2203: ROLLBACK TO delete_resource_pub;
2204: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 2208: FND_MSG_PUB.add;

2204: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2205: fnd_message.set_token('P_SQLCODE',SQLCODE);
2206: fnd_message.set_token('P_SQLERRM',SQLERRM);
2207: fnd_message.set_token('P_API_NAME', l_api_name);
2208: FND_MSG_PUB.add;
2209: x_return_status := fnd_api.g_ret_sts_unexp_error;
2210: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2211: p_data => x_msg_data);
2212:

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

2206: fnd_message.set_token('P_SQLERRM',SQLERRM);
2207: fnd_message.set_token('P_API_NAME', l_api_name);
2208: FND_MSG_PUB.add;
2209: x_return_status := fnd_api.g_ret_sts_unexp_error;
2210: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
2211: p_data => x_msg_data);
2212:
2213: END delete_resource;
2214:

Line 2613: FND_MSG_PUB.Initialize;

2609:
2610: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2611: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2612: THEN
2613: FND_MSG_PUB.Initialize;
2614: END IF;
2615:
2616: /* Validate the Resource Category */
2617:

Line 2668: fnd_msg_pub.add;

2664:
2665: -- dbms_output.put_line('For OTHER category, source_id, address_id, contact_id and managing_emp_id should be all null');
2666:
2667: fnd_message.set_name('JTF', 'JTF_RS_OTHER_IDS_NOT_NULL');
2668: fnd_msg_pub.add;
2669:
2670: RAISE fnd_api.g_exc_error;
2671:
2672: END IF;

Line 2685: fnd_msg_pub.add;

2681:
2682: IF (l_source_id IS NULL) THEN
2683: -- dbms_output.put_line('For PARTNER category, source_id should not be null');
2684: fnd_message.set_name('JTF', 'JTF_RS_PARTNER_IDS_NULL');
2685: fnd_msg_pub.add;
2686: RAISE fnd_api.g_exc_error;
2687:
2688: ELSE
2689: OPEN c_validate_partner(l_source_id);

Line 2694: fnd_msg_pub.add;

2690: FETCH c_validate_partner INTO l_check_flag;
2691: IF c_validate_partner%NOTFOUND THEN
2692: -- dbms_output.put_line('Partner does not exist for the passed source_id');
2693: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTNER_IDS');
2694: fnd_msg_pub.add;
2695: RAISE fnd_api.g_exc_error;
2696:
2697: END IF;
2698: CLOSE c_validate_partner;

Line 2710: fnd_msg_pub.add;

2706: IF c_validate_partner_address%NOTFOUND THEN
2707: -- dbms_output.put_line('Invalid Partner Address Id');
2708: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTNER_ADDRESS_ID');
2709: fnd_message.set_token('P_ADDRESS_ID', l_address_id);
2710: fnd_msg_pub.add;
2711: RAISE fnd_api.g_exc_error;
2712:
2713: END IF;
2714: CLOSE c_validate_partner_address;

Line 2727: fnd_msg_pub.add;

2723: IF c_validate_partner_contact%NOTFOUND THEN
2724: -- dbms_output.put_line('Invalid Partner Contact Id');
2725: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTNER_CONTACT_ID');
2726: fnd_message.set_token('P_CONTACT_ID', l_contact_id);
2727: fnd_msg_pub.add;
2728: RAISE fnd_api.g_exc_error;
2729:
2730: END IF;
2731: CLOSE c_validate_partner_contact;

Line 2746: fnd_msg_pub.add;

2742: IF l_category NOT IN ('OTHER' , 'PARTNER' , 'TBH', 'EMPLOYEE') THEN
2743: IF l_source_id IS NULL THEN
2744: -- dbms_output.put_line('Source Id should not be Null');
2745: fnd_message.set_name('JTF', 'JTF_RS_SOURCE_ID_NULL');
2746: fnd_msg_pub.add;
2747: RAISE fnd_api.g_exc_error;
2748:
2749: END IF;
2750:

Line 2778: fnd_msg_pub.add;

2774: -- dbms_output.put_line('Invalid Source Id');
2775:
2776: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SOURCE_ID');
2777: fnd_message.set_token('P_SOURCE_ID', l_source_id);
2778: fnd_msg_pub.add;
2779:
2780: RAISE fnd_api.g_exc_error;
2781:
2782:

Line 2796: fnd_msg_pub.add;

2792: if l_category = 'EMPLOYEE' THEN
2793: -- First check is null check for source id
2794: IF l_source_id IS NULL THEN
2795: fnd_message.set_name('JTF', 'JTF_RS_SOURCE_ID_NULL');
2796: fnd_msg_pub.add;
2797: RAISE fnd_api.g_exc_error;
2798: END IF;
2799:
2800: open c_emp_exist(l_source_id);

Line 2808: fnd_msg_pub.add;

2804: if(nvl(r_emp_exist.value , 'y') <> 'x')
2805: then
2806: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SOURCE_ID');
2807: fnd_message.set_token('P_SOURCE_ID', l_source_id);
2808: fnd_msg_pub.add;
2809: RAISE fnd_api.g_exc_error;
2810: end if;
2811:
2812: END IF; -- end of check l_category = 'EMPLOYEE'

Line 2833: fnd_msg_pub.add;

2829: -- dbms_output.put_line('Invalid Party Address');
2830:
2831: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTY_ADDRESS');
2832: fnd_message.set_token('P_ADDRESS_ID', l_address_id);
2833: fnd_msg_pub.add;
2834:
2835: RAISE fnd_api.g_exc_error;
2836:
2837:

Line 2863: fnd_msg_pub.add;

2859: -- dbms_output.put_line('Invalid Party Contact Id');
2860:
2861: fnd_message.set_name('JTF', 'JTF_RS_ERR_PARTY_CONTACT_ID');
2862: fnd_message.set_token('P_CONTACT_ID', l_contact_id);
2863: fnd_msg_pub.add;
2864:
2865: RAISE fnd_api.g_exc_error;
2866:
2867: END IF;

Line 2893: fnd_msg_pub.add;

2889:
2890: -- dbms_output.put_line('For SUPPLIER_CONTACT category, address_id and contact_id should be null');
2891:
2892: fnd_message.set_name('JTF', 'JTF_RS_SC_IDS_NOT_NULL');
2893: fnd_msg_pub.add;
2894:
2895: RAISE fnd_api.g_exc_error;
2896:
2897: END IF;

Line 2915: fnd_msg_pub.add;

2911:
2912: -- dbms_output.put_line('For EMPLOYEE category, contact_id should be null');
2913:
2914: fnd_message.set_name('JTF', 'JTF_RS_EMP_IDS_NOT_NULL');
2915: fnd_msg_pub.add;
2916:
2917: RAISE fnd_api.g_exc_error;
2918:
2919:

Line 2957: fnd_msg_pub.add;

2953:
2954: -- dbms_output.put_line('Start Date Active cannot be null');
2955:
2956: fnd_message.set_name('JTF', 'JTF_RS_START_DATE_NULL');
2957: fnd_msg_pub.add;
2958:
2959: RAISE fnd_api.g_exc_error;
2960:
2961:

Line 3096: fnd_msg_pub.add;

3092: -- dbms_output.put_line('Invalid Assigned To Group Id');
3093:
3094: fnd_message.set_name('JTF', 'JTF_RS_ERR_ASSIGN_TO_GRP_ID');
3095: fnd_message.set_token('P_ASSIGNED_TO_GROUP_ID', l_assigned_to_group_id);
3096: fnd_msg_pub.add;
3097:
3098: RAISE fnd_api.g_exc_error;
3099:
3100:

Line 3141: fnd_msg_pub.add;

3137:
3138: -- dbms_output.put_line('Commissionable Flag should either be ''Y'' or ''N'' ');
3139:
3140: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
3141: fnd_msg_pub.add;
3142:
3143: RAISE fnd_api.g_exc_error;
3144:
3145:

Line 3156: fnd_msg_pub.add;

3152:
3153: -- dbms_output.put_line('Hold Payment should either be ''Y'' or ''N'' ');
3154:
3155: fnd_message.set_name('JTF', 'JTF_RS_INVALID_FLAG_VALUE');
3156: fnd_msg_pub.add;
3157:
3158: RAISE fnd_api.g_exc_error;
3159:
3160:

Line 3195: fnd_msg_pub.add;

3191:
3192: IF l_user_id IS NOT NULL THEN
3193:
3194: fnd_message.set_name('JTF', 'JTF_RS_USERID_ERROR');
3195: fnd_msg_pub.add;
3196:
3197: RAISE fnd_api.g_exc_error;
3198:
3199:

Line 3235: fnd_msg_pub.add;

3231: -- dbms_output.put_line('duplicate user Id');
3232:
3233: fnd_message.set_name('JTF', 'JTF_RS_ERR_DUPLICATE_USER_ID');
3234: fnd_message.set_token('P_USER_ID', l_user_id);
3235: fnd_msg_pub.add;
3236:
3237: RAISE fnd_api.g_exc_error;
3238:
3239:

Line 3468: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

3464: COMMIT WORK;
3465: END IF;
3466:
3467:
3468: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3469:
3470: EXCEPTION
3471: WHEN fnd_api.g_exc_error THEN
3472: ROLLBACK TO create_resource_sp;

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

3470: EXCEPTION
3471: WHEN fnd_api.g_exc_error THEN
3472: ROLLBACK TO create_resource_sp;
3473: x_return_status := fnd_api.g_ret_sts_error;
3474: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3475: p_data => x_msg_data);
3476: WHEN fnd_api.g_exc_unexpected_error THEN
3477: ROLLBACK TO create_resource_sp;
3478: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3475: p_data => x_msg_data);
3476: WHEN fnd_api.g_exc_unexpected_error THEN
3477: ROLLBACK TO create_resource_sp;
3478: x_return_status := fnd_api.g_ret_sts_unexp_error;
3479: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3480: p_data => x_msg_data);
3481: WHEN OTHERS THEN
3482: ROLLBACK TO create_resource_sp;
3483: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 3487: FND_MSG_PUB.add;

3483: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3484: fnd_message.set_token('P_SQLCODE',SQLCODE);
3485: fnd_message.set_token('P_SQLERRM',SQLERRM);
3486: fnd_message.set_token('P_API_NAME', l_api_name);
3487: FND_MSG_PUB.add;
3488: x_return_status := fnd_api.g_ret_sts_unexp_error;
3489: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3490: p_data => x_msg_data);
3491:

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

3485: fnd_message.set_token('P_SQLERRM',SQLERRM);
3486: fnd_message.set_token('P_API_NAME', l_api_name);
3487: FND_MSG_PUB.add;
3488: x_return_status := fnd_api.g_ret_sts_unexp_error;
3489: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
3490: p_data => x_msg_data);
3491:
3492: END;
3493: END jtf_rs_resource_pub;