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_TERRITORY_PUB dependencies on STANDARD

Line 890: -- Standard Start of API savepoint

886: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
887: --
888:
889: BEGIN
890: -- Standard Start of API savepoint
891: SAVEPOINT create_territory_pub;
892:
893: -- Standard call to check for call compatibility.
894: IF NOT fnd_api.compatible_api_call (

Line 893: -- Standard call to check for call compatibility.

889: BEGIN
890: -- Standard Start of API savepoint
891: SAVEPOINT create_territory_pub;
892:
893: -- Standard call to check for call compatibility.
894: IF NOT fnd_api.compatible_api_call (
895: l_api_version_number,
896: p_api_version_number,
897: l_api_name,

Line 993: -- Standard check of p_commit.

989: --
990: -- End of API body.
991: --
992:
993: -- Standard check of p_commit.
994: IF fnd_api.to_boolean (p_commit)
995: THEN
996: COMMIT WORK;
997: END IF;

Line 1007: -- Standard call to get message count and if count is 1, get message info.

1003: fnd_message.set_name ('PROC_NAME', l_api_name);
1004: fnd_msg_pub.add;
1005: END IF;
1006:
1007: -- Standard call to get message count and if count is 1, get message info.
1008: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1009: EXCEPTION
1010: WHEN fnd_api.g_exc_error
1011: THEN

Line 1095: -- Standard Start of API savepoint

1091: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Territory';
1092: l_api_version_number CONSTANT NUMBER := 1.0;
1093: --l_return_status VARCHAR2(1);
1094: BEGIN
1095: -- Standard Start of API savepoint
1096: SAVEPOINT delete_territory_pub;
1097:
1098: -- Standard call to check for call compatibility.
1099: IF NOT fnd_api.compatible_api_call (

Line 1098: -- Standard call to check for call compatibility.

1094: BEGIN
1095: -- Standard Start of API savepoint
1096: SAVEPOINT delete_territory_pub;
1097:
1098: -- Standard call to check for call compatibility.
1099: IF NOT fnd_api.compatible_api_call (
1100: l_api_version_number,
1101: p_api_version_number,
1102: l_api_name,

Line 1149: -- Standard check of p_commit.

1145: THEN
1146: RAISE fnd_api.g_exc_unexpected_error;
1147: END IF;
1148:
1149: -- Standard check of p_commit.
1150: IF fnd_api.to_boolean (p_commit)
1151: THEN
1152: COMMIT WORK;
1153: END IF;

Line 1163: -- Standard call to get message count and if count is 1, get message info.

1159: fnd_message.set_name ('PROC_NAME', l_api_name);
1160: fnd_msg_pub.add;
1161: END IF;
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1165: EXCEPTION
1166: WHEN fnd_api.g_exc_error
1167: THEN

Line 1278: -- Standard Start of API savepoint

1274: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1275: BEGIN
1276: --dbms_output.put_line('Update_Territory PUB: Entering API');
1277:
1278: -- Standard Start of API savepoint
1279: SAVEPOINT update_territory_pub;
1280:
1281: -- Standard call to check for call compatibility.
1282: IF NOT fnd_api.compatible_api_call (

Line 1281: -- Standard call to check for call compatibility.

1277:
1278: -- Standard Start of API savepoint
1279: SAVEPOINT update_territory_pub;
1280:
1281: -- Standard call to check for call compatibility.
1282: IF NOT fnd_api.compatible_api_call (
1283: l_api_version_number,
1284: p_api_version_number,
1285: l_api_name,

Line 1395: -- Standard check for p_commit

1391: END IF;
1392:
1393: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1394:
1395: -- Standard check for p_commit
1396: IF fnd_api.to_boolean (p_commit)
1397: THEN
1398: COMMIT WORK;
1399: END IF;

Line 1491: -- Standard Start of API savepoint

1487: l_api_name CONSTANT VARCHAR2(30) := 'Deactivate_Territory';
1488: l_api_version_number CONSTANT NUMBER := 1.0;
1489: --l_return_status VARCHAR2(1);
1490: BEGIN
1491: -- Standard Start of API savepoint
1492: SAVEPOINT deactivate_territory_pub;
1493:
1494: -- Standard call to check for call compatibility.
1495: IF NOT fnd_api.compatible_api_call (

Line 1494: -- Standard call to check for call compatibility.

1490: BEGIN
1491: -- Standard Start of API savepoint
1492: SAVEPOINT deactivate_territory_pub;
1493:
1494: -- Standard call to check for call compatibility.
1495: IF NOT fnd_api.compatible_api_call (
1496: l_api_version_number,
1497: p_api_version_number,
1498: l_api_name,

Line 1544: -- Standard check of p_commit.

1540: THEN
1541: RAISE fnd_api.g_exc_unexpected_error;
1542: END IF;
1543:
1544: -- Standard check of p_commit.
1545: IF fnd_api.to_boolean (p_commit)
1546: THEN
1547: COMMIT WORK;
1548: END IF;

Line 1558: -- Standard call to get message count and if count is 1, get message info.

1554: fnd_message.set_name ('PROC_NAME', l_api_name);
1555: fnd_msg_pub.add;
1556: END IF;
1557:
1558: -- Standard call to get message count and if count is 1, get message info.
1559: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1560: EXCEPTION
1561: WHEN fnd_api.g_exc_error
1562: THEN

Line 1656: -- Standard Start of API savepoint

1652: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1653: --
1654:
1655: BEGIN
1656: -- Standard Start of API savepoint
1657: SAVEPOINT create_territory_pub;
1658:
1659: -- Standard call to check for call compatibility.
1660: IF NOT fnd_api.compatible_api_call (

Line 1659: -- Standard call to check for call compatibility.

1655: BEGIN
1656: -- Standard Start of API savepoint
1657: SAVEPOINT create_territory_pub;
1658:
1659: -- Standard call to check for call compatibility.
1660: IF NOT fnd_api.compatible_api_call (
1661: l_api_version_number,
1662: p_api_version_number,
1663: l_api_name,

Line 1733: -- Standard check of p_commit.

1729: --
1730: -- End of API body.
1731: --
1732:
1733: -- Standard check of p_commit.
1734: IF fnd_api.to_boolean (p_commit)
1735: THEN
1736: COMMIT WORK;
1737: END IF;

Line 1747: -- Standard call to get message count and if count is 1, get message info.

1743: fnd_message.set_name ('PROC_NAME', l_api_name);
1744: fnd_msg_pub.add;
1745: END IF;
1746:
1747: -- Standard call to get message count and if count is 1, get message info.
1748: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1749: EXCEPTION
1750: WHEN fnd_api.g_exc_error
1751: THEN

Line 1832: -- Standard Start of API savepoint

1828: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Terr_Qualifier';
1829: l_api_version_number CONSTANT NUMBER := 1.0;
1830: l_return_status VARCHAR2(1);
1831: BEGIN
1832: -- Standard Start of API savepoint
1833: SAVEPOINT delete_territory_pub;
1834:
1835: -- Standard call to check for call compatibility.
1836: IF NOT fnd_api.compatible_api_call (

Line 1835: -- Standard call to check for call compatibility.

1831: BEGIN
1832: -- Standard Start of API savepoint
1833: SAVEPOINT delete_territory_pub;
1834:
1835: -- Standard call to check for call compatibility.
1836: IF NOT fnd_api.compatible_api_call (
1837: l_api_version_number,
1838: p_api_version_number,
1839: l_api_name,

Line 1886: -- Standard check of p_commit.

1882: THEN
1883: RAISE fnd_api.g_exc_unexpected_error;
1884: END IF;
1885:
1886: -- Standard check of p_commit.
1887: IF fnd_api.to_boolean (p_commit)
1888: THEN
1889: COMMIT WORK;
1890: END IF;

Line 1900: -- Standard call to get message count and if count is 1, get message info.

1896: fnd_message.set_name ('PROC_NAME', l_api_name);
1897: fnd_msg_pub.add;
1898: END IF;
1899:
1900: -- Standard call to get message count and if count is 1, get message info.
1901: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1902: EXCEPTION
1903: WHEN fnd_api.g_exc_error
1904: THEN

Line 1993: -- Standard Start of API savepoint

1989: l_Terr_Qual_Id NUMBER;
1990: BEGIN
1991: --dbms_output.put_line('create_terr_value PUB: Entering API');
1992:
1993: -- Standard Start of API savepoint
1994: SAVEPOINT update_territory_pub;
1995:
1996: -- Standard call to check for call compatibility.
1997: IF NOT fnd_api.compatible_api_call (

Line 1996: -- Standard call to check for call compatibility.

1992:
1993: -- Standard Start of API savepoint
1994: SAVEPOINT update_territory_pub;
1995:
1996: -- Standard call to check for call compatibility.
1997: IF NOT fnd_api.compatible_api_call (
1998: l_api_version_number,
1999: p_api_version_number,
2000: l_api_name,

Line 2076: -- Standard check for p_commit

2072: END IF;
2073:
2074: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2075:
2076: -- Standard check for p_commit
2077: IF fnd_api.to_boolean (p_commit)
2078: THEN
2079: COMMIT WORK;
2080: END IF;

Line 2175: -- Standard Start of API savepoint

2171: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
2172: BEGIN
2173: --dbms_output.put_line('Update_Territory PUB: Entering API');
2174:
2175: -- Standard Start of API savepoint
2176: SAVEPOINT update_territory_pub;
2177:
2178: -- Standard call to check for call compatibility.
2179: IF NOT fnd_api.compatible_api_call (

Line 2178: -- Standard call to check for call compatibility.

2174:
2175: -- Standard Start of API savepoint
2176: SAVEPOINT update_territory_pub;
2177:
2178: -- Standard call to check for call compatibility.
2179: IF NOT fnd_api.compatible_api_call (
2180: l_api_version_number,
2181: p_api_version_number,
2182: l_api_name,

Line 2256: -- Standard check for p_commit

2252: END IF;
2253:
2254: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2255:
2256: -- Standard check for p_commit
2257: IF fnd_api.to_boolean (p_commit)
2258: THEN
2259: COMMIT WORK;
2260: END IF;

Line 2350: -- Standard Start of API savepoint

2346: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Terr_Value';
2347: l_api_version_number CONSTANT NUMBER := 1.0;
2348: l_return_status VARCHAR2(1);
2349: BEGIN
2350: -- Standard Start of API savepoint
2351: SAVEPOINT delete_territory_pub;
2352:
2353: -- Standard call to check for call compatibility.
2354: IF NOT fnd_api.compatible_api_call (

Line 2353: -- Standard call to check for call compatibility.

2349: BEGIN
2350: -- Standard Start of API savepoint
2351: SAVEPOINT delete_territory_pub;
2352:
2353: -- Standard call to check for call compatibility.
2354: IF NOT fnd_api.compatible_api_call (
2355: l_api_version_number,
2356: p_api_version_number,
2357: l_api_name,

Line 2405: -- Standard check of p_commit.

2401: THEN
2402: RAISE fnd_api.g_exc_unexpected_error;
2403: END IF;
2404:
2405: -- Standard check of p_commit.
2406: IF fnd_api.to_boolean (p_commit)
2407: THEN
2408: COMMIT WORK;
2409: END IF;

Line 2419: -- Standard call to get message count and if count is 1, get message info.

2415: fnd_message.set_name ('PROC_NAME', l_api_name);
2416: fnd_msg_pub.add;
2417: END IF;
2418:
2419: -- Standard call to get message count and if count is 1, get message info.
2420: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2421: EXCEPTION
2422: WHEN fnd_api.g_exc_error
2423: THEN

Line 2523: -- Standard Start of API savepoint

2519: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2520: --
2521:
2522: BEGIN
2523: -- Standard Start of API savepoint
2524: SAVEPOINT create_terrresource_pub;
2525:
2526: -- Standard call to check for call compatibility.
2527: IF NOT fnd_api.compatible_api_call (

Line 2526: -- Standard call to check for call compatibility.

2522: BEGIN
2523: -- Standard Start of API savepoint
2524: SAVEPOINT create_terrresource_pub;
2525:
2526: -- Standard call to check for call compatibility.
2527: IF NOT fnd_api.compatible_api_call (
2528: l_api_version_number,
2529: p_api_version_number,
2530: l_api_name,

Line 2602: -- Standard check of p_commit.

2598: --
2599: -- End of API body.
2600: --
2601:
2602: -- Standard check of p_commit.
2603: IF fnd_api.to_boolean (p_commit)
2604: THEN
2605: COMMIT WORK;
2606: END IF;

Line 2616: -- Standard call to get message count and if count is 1, get message info.

2612: fnd_message.set_name ('PROC_NAME', l_api_name);
2613: fnd_msg_pub.add;
2614: END IF;
2615:
2616: -- Standard call to get message count and if count is 1, get message info.
2617: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2618: EXCEPTION
2619: WHEN fnd_api.g_exc_error
2620: THEN

Line 2706: -- Standard Start of API savepoint

2702: l_api_name CONSTANT VARCHAR2(30) := 'Delete_TerrResource';
2703: l_api_version_number CONSTANT NUMBER := 1.0;
2704: l_return_status VARCHAR2(1);
2705: BEGIN
2706: -- Standard Start of API savepoint
2707: SAVEPOINT delete_terrresource_pub;
2708:
2709: -- Standard call to check for call compatibility.
2710: IF NOT fnd_api.compatible_api_call (

Line 2709: -- Standard call to check for call compatibility.

2705: BEGIN
2706: -- Standard Start of API savepoint
2707: SAVEPOINT delete_terrresource_pub;
2708:
2709: -- Standard call to check for call compatibility.
2710: IF NOT fnd_api.compatible_api_call (
2711: l_api_version_number,
2712: p_api_version_number,
2713: l_api_name,

Line 2761: -- Standard check of p_commit.

2757: THEN
2758: RAISE fnd_api.g_exc_unexpected_error;
2759: END IF;
2760:
2761: -- Standard check of p_commit.
2762: IF fnd_api.to_boolean (p_commit)
2763: THEN
2764: COMMIT WORK;
2765: END IF;

Line 2775: -- Standard call to get message count and if count is 1, get message info.

2771: fnd_message.set_name ('PROC_NAME', l_api_name);
2772: fnd_msg_pub.add;
2773: END IF;
2774:
2775: -- Standard call to get message count and if count is 1, get message info.
2776: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2777: EXCEPTION
2778: WHEN fnd_api.g_exc_error
2779: THEN

Line 2876: -- Standard Start of API savepoint

2872: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
2873: --
2874:
2875: BEGIN
2876: -- Standard Start of API savepoint
2877: SAVEPOINT update_terrresource_pub;
2878:
2879: -- Standard call to check for call compatibility.
2880: IF NOT fnd_api.compatible_api_call (

Line 2879: -- Standard call to check for call compatibility.

2875: BEGIN
2876: -- Standard Start of API savepoint
2877: SAVEPOINT update_terrresource_pub;
2878:
2879: -- Standard call to check for call compatibility.
2880: IF NOT fnd_api.compatible_api_call (
2881: l_api_version_number,
2882: p_api_version_number,
2883: l_api_name,

Line 2958: -- Standard check for p_commit

2954: END IF;
2955:
2956: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2957:
2958: -- Standard check for p_commit
2959: IF fnd_api.to_boolean (p_commit)
2960: THEN
2961: COMMIT WORK;
2962: END IF;