DBA Data[Home] [Help]

APPS.JTF_TERRITORY_PUB dependencies on STANDARD

Line 812: -- Standard Start of API savepoint

808: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
809: --
810:
811: BEGIN
812: -- Standard Start of API savepoint
813: SAVEPOINT create_territory_pub;
814:
815: -- Standard call to check for call compatibility.
816: IF NOT fnd_api.compatible_api_call (

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

811: BEGIN
812: -- Standard Start of API savepoint
813: SAVEPOINT create_territory_pub;
814:
815: -- Standard call to check for call compatibility.
816: IF NOT fnd_api.compatible_api_call (
817: l_api_version_number,
818: p_api_version_number,
819: l_api_name,

Line 915: -- Standard check of p_commit.

911: --
912: -- End of API body.
913: --
914:
915: -- Standard check of p_commit.
916: IF fnd_api.to_boolean (p_commit)
917: THEN
918: COMMIT WORK;
919: END IF;

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

925: fnd_message.set_name ('PROC_NAME', l_api_name);
926: fnd_msg_pub.add;
927: END IF;
928:
929: -- Standard call to get message count and if count is 1, get message info.
930: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
931: EXCEPTION
932: WHEN fnd_api.g_exc_error
933: THEN

Line 1017: -- Standard Start of API savepoint

1013: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Territory';
1014: l_api_version_number CONSTANT NUMBER := 1.0;
1015: l_return_status VARCHAR2(1);
1016: BEGIN
1017: -- Standard Start of API savepoint
1018: SAVEPOINT delete_territory_pub;
1019:
1020: -- Standard call to check for call compatibility.
1021: IF NOT fnd_api.compatible_api_call (

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

1016: BEGIN
1017: -- Standard Start of API savepoint
1018: SAVEPOINT delete_territory_pub;
1019:
1020: -- Standard call to check for call compatibility.
1021: IF NOT fnd_api.compatible_api_call (
1022: l_api_version_number,
1023: p_api_version_number,
1024: l_api_name,

Line 1070: -- Standard check of p_commit.

1066: THEN
1067: RAISE fnd_api.g_exc_unexpected_error;
1068: END IF;
1069:
1070: -- Standard check of p_commit.
1071: IF fnd_api.to_boolean (p_commit)
1072: THEN
1073: COMMIT WORK;
1074: END IF;

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

1080: fnd_message.set_name ('PROC_NAME', l_api_name);
1081: fnd_msg_pub.add;
1082: END IF;
1083:
1084: -- Standard call to get message count and if count is 1, get message info.
1085: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1086: EXCEPTION
1087: WHEN fnd_api.g_exc_error
1088: THEN

Line 1207: -- Standard Start of API savepoint

1203: l_terr_values_tbl jtf_territory_pvt.terr_values_tbl_type;
1204: BEGIN
1205: --dbms_output.put_line('Update_Territory PUB: Entering API');
1206:
1207: -- Standard Start of API savepoint
1208: SAVEPOINT upadate_territory_pub;
1209:
1210: -- Standard call to check for call compatibility.
1211: IF NOT fnd_api.compatible_api_call (

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

1206:
1207: -- Standard Start of API savepoint
1208: SAVEPOINT upadate_territory_pub;
1209:
1210: -- Standard call to check for call compatibility.
1211: IF NOT fnd_api.compatible_api_call (
1212: l_api_version_number,
1213: p_api_version_number,
1214: l_api_name,

Line 1320: -- Standard check for p_commit

1316: END IF;
1317:
1318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1319:
1320: -- Standard check for p_commit
1321: IF fnd_api.to_boolean (p_commit)
1322: THEN
1323: COMMIT WORK;
1324: END IF;

Line 1416: -- Standard Start of API savepoint

1412: l_api_name CONSTANT VARCHAR2(30) := 'Deactivate_Territory';
1413: l_api_version_number CONSTANT NUMBER := 1.0;
1414: l_return_status VARCHAR2(1);
1415: BEGIN
1416: -- Standard Start of API savepoint
1417: SAVEPOINT deactivate_territory_pub;
1418:
1419: -- Standard call to check for call compatibility.
1420: IF NOT fnd_api.compatible_api_call (

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

1415: BEGIN
1416: -- Standard Start of API savepoint
1417: SAVEPOINT deactivate_territory_pub;
1418:
1419: -- Standard call to check for call compatibility.
1420: IF NOT fnd_api.compatible_api_call (
1421: l_api_version_number,
1422: p_api_version_number,
1423: l_api_name,

Line 1469: -- Standard check of p_commit.

1465: THEN
1466: RAISE fnd_api.g_exc_unexpected_error;
1467: END IF;
1468:
1469: -- Standard check of p_commit.
1470: IF fnd_api.to_boolean (p_commit)
1471: THEN
1472: COMMIT WORK;
1473: END IF;

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

1479: fnd_message.set_name ('PROC_NAME', l_api_name);
1480: fnd_msg_pub.add;
1481: END IF;
1482:
1483: -- Standard call to get message count and if count is 1, get message info.
1484: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1485: EXCEPTION
1486: WHEN fnd_api.g_exc_error
1487: THEN

Line 1584: -- Standard Start of API savepoint

1580: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1581: --
1582:
1583: BEGIN
1584: -- Standard Start of API savepoint
1585: SAVEPOINT create_terrresource_pub;
1586:
1587: -- Standard call to check for call compatibility.
1588: IF NOT fnd_api.compatible_api_call (

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

1583: BEGIN
1584: -- Standard Start of API savepoint
1585: SAVEPOINT create_terrresource_pub;
1586:
1587: -- Standard call to check for call compatibility.
1588: IF NOT fnd_api.compatible_api_call (
1589: l_api_version_number,
1590: p_api_version_number,
1591: l_api_name,

Line 1661: -- Standard check of p_commit.

1657: --
1658: -- End of API body.
1659: --
1660:
1661: -- Standard check of p_commit.
1662: IF fnd_api.to_boolean (p_commit)
1663: THEN
1664: COMMIT WORK;
1665: END IF;

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

1671: fnd_message.set_name ('PROC_NAME', l_api_name);
1672: fnd_msg_pub.add;
1673: END IF;
1674:
1675: -- Standard call to get message count and if count is 1, get message info.
1676: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1677: EXCEPTION
1678: WHEN fnd_api.g_exc_error
1679: THEN

Line 1765: -- Standard Start of API savepoint

1761: l_api_name CONSTANT VARCHAR2(30) := 'Delete_TerrResource';
1762: l_api_version_number CONSTANT NUMBER := 1.0;
1763: l_return_status VARCHAR2(1);
1764: BEGIN
1765: -- Standard Start of API savepoint
1766: SAVEPOINT delete_terrresource_pub;
1767:
1768: -- Standard call to check for call compatibility.
1769: IF NOT fnd_api.compatible_api_call (

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

1764: BEGIN
1765: -- Standard Start of API savepoint
1766: SAVEPOINT delete_terrresource_pub;
1767:
1768: -- Standard call to check for call compatibility.
1769: IF NOT fnd_api.compatible_api_call (
1770: l_api_version_number,
1771: p_api_version_number,
1772: l_api_name,

Line 1819: -- Standard check of p_commit.

1815: THEN
1816: RAISE fnd_api.g_exc_unexpected_error;
1817: END IF;
1818:
1819: -- Standard check of p_commit.
1820: IF fnd_api.to_boolean (p_commit)
1821: THEN
1822: COMMIT WORK;
1823: END IF;

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

1829: fnd_message.set_name ('PROC_NAME', l_api_name);
1830: fnd_msg_pub.add;
1831: END IF;
1832:
1833: -- Standard call to get message count and if count is 1, get message info.
1834: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1835: EXCEPTION
1836: WHEN fnd_api.g_exc_error
1837: THEN

Line 1934: -- Standard Start of API savepoint

1930: l_terrrsc_access_out_tbl jtf_territory_resource_pvt.terrrsc_access_out_tbl_type;
1931: --
1932:
1933: BEGIN
1934: -- Standard Start of API savepoint
1935: SAVEPOINT upadate_terrresource_pub;
1936:
1937: -- Standard call to check for call compatibility.
1938: IF NOT fnd_api.compatible_api_call (

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

1933: BEGIN
1934: -- Standard Start of API savepoint
1935: SAVEPOINT upadate_terrresource_pub;
1936:
1937: -- Standard call to check for call compatibility.
1938: IF NOT fnd_api.compatible_api_call (
1939: l_api_version_number,
1940: p_api_version_number,
1941: l_api_name,

Line 2015: -- Standard check for p_commit

2011: END IF;
2012:
2013: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2014:
2015: -- Standard check for p_commit
2016: IF fnd_api.to_boolean (p_commit)
2017: THEN
2018: COMMIT WORK;
2019: END IF;