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.CN_COMP_PLAN_PVT dependencies on STANDARD

Line 121: -- Standard Start of API savepoint

117: l_loading_status VARCHAR2 (50);
118: l_note_msg VARCHAR2 (240);
119: l_note_id NUMBER;
120: BEGIN
121: -- Standard Start of API savepoint
122: SAVEPOINT create_comp_plan;
123:
124: -- Standard call to check for call compatibility.
125: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

120: BEGIN
121: -- Standard Start of API savepoint
122: SAVEPOINT create_comp_plan;
123:
124: -- Standard call to check for call compatibility.
125: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
126: THEN
127: RAISE fnd_api.g_exc_unexpected_error;
128: END IF;

Line 298: -- Standard check of p_commit.

294: );
295: */
296:
297: -- End of API body.
298: -- Standard check of p_commit.
299: IF fnd_api.to_boolean (p_commit)
300: THEN
301: COMMIT WORK;
302: END IF;

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

300: THEN
301: COMMIT WORK;
302: END IF;
303:
304: -- Standard call to get message count and if count is 1, get message info.
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
306: EXCEPTION
307: WHEN fnd_api.g_exc_error
308: THEN

Line 409: -- Standard Start of API savepoint

405: l_note_msg VARCHAR2 (240);
406: l_note_id NUMBER;
407: l_consolidated_note VARCHAR2(2000);
408: BEGIN
409: -- Standard Start of API savepoint
410: SAVEPOINT update_comp_plan;
411:
412: -- Standard call to check for call compatibility.
413: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

408: BEGIN
409: -- Standard Start of API savepoint
410: SAVEPOINT update_comp_plan;
411:
412: -- Standard call to check for call compatibility.
413: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
414: THEN
415: RAISE fnd_api.g_exc_unexpected_error;
416: END IF;

Line 794: -- Standard check of p_commit.

790: );
791: END IF;
792:
793: -- End of API body.
794: -- Standard check of p_commit.
795: IF fnd_api.to_boolean (p_commit)
796: THEN
797: COMMIT WORK;
798: END IF;

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

796: THEN
797: COMMIT WORK;
798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.
801: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
802: EXCEPTION
803: WHEN fnd_api.g_exc_error
804: THEN

Line 868: -- Standard Start of API savepoint

864: l_note_id NUMBER;
865: l_org_id NUMBER := -999;
866: l_cp_name cn_comp_plans.NAME%TYPE := NULL;
867: BEGIN
868: -- Standard Start of API savepoint
869: SAVEPOINT delete_comp_plan;
870:
871: -- Standard call to check for call compatibility.
872: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

867: BEGIN
868: -- Standard Start of API savepoint
869: SAVEPOINT delete_comp_plan;
870:
871: -- Standard call to check for call compatibility.
872: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
873: THEN
874: RAISE fnd_api.g_exc_unexpected_error;
875: END IF;

Line 968: -- Standard check of p_commit.

964: );
965: END IF;
966:
967: -- End of API body.
968: -- Standard check of p_commit.
969: IF fnd_api.to_boolean (p_commit)
970: THEN
971: COMMIT WORK;
972: END IF;

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

970: THEN
971: COMMIT WORK;
972: END IF;
973:
974: -- Standard call to get message count and if count is 1, get message info.
975: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
976: EXCEPTION
977: WHEN fnd_api.g_exc_error
978: THEN

Line 1062: -- Standard Start of API savepoint

1058: AND status_code = DECODE (p_search_status, 'NULL', status_code, p_search_status)
1059: AND TRUNC (start_date) >= TRUNC (NVL (p_search_date, start_date))
1060: ORDER BY NAME;
1061: BEGIN
1062: -- Standard Start of API savepoint
1063: SAVEPOINT get_comp_plan_sum;
1064:
1065: -- Standard call to check for call compatibility.
1066: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1061: BEGIN
1062: -- Standard Start of API savepoint
1063: SAVEPOINT get_comp_plan_sum;
1064:
1065: -- Standard call to check for call compatibility.
1066: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1067: THEN
1068: RAISE fnd_api.g_exc_unexpected_error;
1069: END IF;

Line 1105: -- Standard check of p_commit.

1101: END IF;
1102: END LOOP;
1103:
1104: -- End of API body.
1105: -- Standard check of p_commit.
1106: IF fnd_api.to_boolean (p_commit)
1107: THEN
1108: COMMIT WORK;
1109: END IF;

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

1107: THEN
1108: COMMIT WORK;
1109: END IF;
1110:
1111: -- Standard call to get message count and if count is 1, get message info.
1112: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1113: EXCEPTION
1114: WHEN fnd_api.g_exc_error
1115: THEN

Line 1182: -- Standard Start of API savepoint

1178: WHERE comp_plan_id = p_comp_plan_id;
1179:
1180: l_comp_plan l_comp_plan_cr%ROWTYPE;
1181: BEGIN
1182: -- Standard Start of API savepoint
1183: SAVEPOINT get_comp_plan_dtl;
1184:
1185: -- Standard call to check for call compatibility.
1186: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1181: BEGIN
1182: -- Standard Start of API savepoint
1183: SAVEPOINT get_comp_plan_dtl;
1184:
1185: -- Standard call to check for call compatibility.
1186: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1187: THEN
1188: RAISE fnd_api.g_exc_unexpected_error;
1189: END IF;

Line 1243: -- Standard check of p_commit.

1239:
1240: CLOSE l_comp_plan_cr;
1241:
1242: -- End of API body.
1243: -- Standard check of p_commit.
1244: IF fnd_api.to_boolean (p_commit)
1245: THEN
1246: COMMIT WORK;
1247: END IF;

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

1245: THEN
1246: COMMIT WORK;
1247: END IF;
1248:
1249: -- Standard call to get message count and if count is 1, get message info.
1250: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1251: EXCEPTION
1252: WHEN fnd_api.g_exc_error
1253: THEN

Line 1327: -- Standard Start of API savepoint

1323:
1324: l_sales_role l_sales_role_cr%ROWTYPE;
1325: l_counter NUMBER;
1326: BEGIN
1327: -- Standard Start of API savepoint
1328: SAVEPOINT get_sales_role;
1329:
1330: -- Standard call to check for call compatibility.
1331: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1326: BEGIN
1327: -- Standard Start of API savepoint
1328: SAVEPOINT get_sales_role;
1329:
1330: -- Standard call to check for call compatibility.
1331: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1332: THEN
1333: RAISE fnd_api.g_exc_unexpected_error;
1334: END IF;

Line 1360: -- Standard check of p_commit.

1356: x_sales_role (l_counter).object_version_number := l_sales_role.object_version_number;
1357: END LOOP;
1358:
1359: -- End of API body.
1360: -- Standard check of p_commit.
1361: IF fnd_api.to_boolean (p_commit)
1362: THEN
1363: COMMIT WORK;
1364: END IF;

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

1362: THEN
1363: COMMIT WORK;
1364: END IF;
1365:
1366: -- Standard call to get message count and if count is 1, get message info.
1367: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1368: EXCEPTION
1369: WHEN fnd_api.g_exc_error
1370: THEN

Line 1453: -- Standard Start of API savepoint

1449: AND q.quota_id = qa.quota_id
1450: AND q.calc_formula_id = f.calc_formula_id
1451: AND f.formula_status = 'INCOMPLETE';
1452: BEGIN
1453: -- Standard Start of API savepoint
1454: SAVEPOINT validate_comp_plan;
1455:
1456: -- Standard call to check for call compatibility.
1457: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1452: BEGIN
1453: -- Standard Start of API savepoint
1454: SAVEPOINT validate_comp_plan;
1455:
1456: -- Standard call to check for call compatibility.
1457: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1458: THEN
1459: RAISE fnd_api.g_exc_unexpected_error;
1460: END IF;

Line 1557: -- Standard check of p_commit.

1553: --RAISE fnd_api.g_exc_error;
1554: END IF;
1555:
1556: -- End of API body.
1557: -- Standard check of p_commit.
1558: IF fnd_api.to_boolean (p_commit)
1559: THEN
1560: COMMIT WORK;
1561: END IF;

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

1559: THEN
1560: COMMIT WORK;
1561: END IF;
1562:
1563: -- Standard call to get message count and if count is 1, get message info.
1564: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1565: EXCEPTION
1566: WHEN fnd_api.g_exc_error
1567: THEN

Line 1815: -- Standard Start of API savepoint

1811: l_unique_name varchar2(30);
1812:
1813: BEGIN
1814:
1815: -- Standard Start of API savepoint
1816:
1817: SAVEPOINT duplicate_comp_plan;
1818:
1819: -- Standard call to check for call compatibility.

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

1815: -- Standard Start of API savepoint
1816:
1817: SAVEPOINT duplicate_comp_plan;
1818:
1819: -- Standard call to check for call compatibility.
1820:
1821: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1822: p_api_version ,
1823: l_api_name,

Line 1946: -- Standard check of p_commit.

1942: END LOOP;
1943:
1944:
1945:
1946: -- Standard check of p_commit.
1947:
1948: IF FND_API.To_Boolean( p_commit ) THEN
1949: COMMIT WORK;
1950: END IF;

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

1948: IF FND_API.To_Boolean( p_commit ) THEN
1949: COMMIT WORK;
1950: END IF;
1951:
1952: -- Standard call to get message count and if count is 1, get message info.
1953:
1954: FND_MSG_PUB.Count_And_Get
1955: (p_count => x_msg_count ,
1956: p_data => x_msg_data ,