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 300: -- Standard check of p_commit.

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

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

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

Line 412: -- Standard Start of API savepoint

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

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

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

Line 803: -- Standard check of p_commit.

799: );
800: END IF;
801:
802: -- End of API body.
803: -- Standard check of p_commit.
804: IF fnd_api.to_boolean (p_commit)
805: THEN
806: COMMIT WORK;
807: END IF;

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

805: THEN
806: COMMIT WORK;
807: END IF;
808:
809: -- Standard call to get message count and if count is 1, get message info.
810: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
811: EXCEPTION
812: WHEN fnd_api.g_exc_error
813: THEN

Line 877: -- Standard Start of API savepoint

873: l_note_id NUMBER;
874: l_org_id NUMBER := -999;
875: l_cp_name cn_comp_plans.NAME%TYPE := NULL;
876: BEGIN
877: -- Standard Start of API savepoint
878: SAVEPOINT delete_comp_plan;
879:
880: -- Standard call to check for call compatibility.
881: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

876: BEGIN
877: -- Standard Start of API savepoint
878: SAVEPOINT delete_comp_plan;
879:
880: -- Standard call to check for call compatibility.
881: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
882: THEN
883: RAISE fnd_api.g_exc_unexpected_error;
884: END IF;

Line 978: -- Standard check of p_commit.

974: );
975: END IF;
976:
977: -- End of API body.
978: -- Standard check of p_commit.
979: IF fnd_api.to_boolean (p_commit)
980: THEN
981: COMMIT WORK;
982: END IF;

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

980: THEN
981: COMMIT WORK;
982: END IF;
983:
984: -- Standard call to get message count and if count is 1, get message info.
985: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
986: EXCEPTION
987: WHEN fnd_api.g_exc_error
988: THEN

Line 1072: -- Standard Start of API savepoint

1068: AND status_code = DECODE (p_search_status, 'NULL', status_code, p_search_status)
1069: AND TRUNC (start_date) >= TRUNC (NVL (p_search_date, start_date))
1070: ORDER BY NAME;
1071: BEGIN
1072: -- Standard Start of API savepoint
1073: SAVEPOINT get_comp_plan_sum;
1074:
1075: -- Standard call to check for call compatibility.
1076: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1071: BEGIN
1072: -- Standard Start of API savepoint
1073: SAVEPOINT get_comp_plan_sum;
1074:
1075: -- Standard call to check for call compatibility.
1076: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1077: THEN
1078: RAISE fnd_api.g_exc_unexpected_error;
1079: END IF;

Line 1115: -- Standard check of p_commit.

1111: END IF;
1112: END LOOP;
1113:
1114: -- End of API body.
1115: -- Standard check of p_commit.
1116: IF fnd_api.to_boolean (p_commit)
1117: THEN
1118: COMMIT WORK;
1119: END IF;

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

1117: THEN
1118: COMMIT WORK;
1119: END IF;
1120:
1121: -- Standard call to get message count and if count is 1, get message info.
1122: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1123: EXCEPTION
1124: WHEN fnd_api.g_exc_error
1125: THEN

Line 1192: -- Standard Start of API savepoint

1188: WHERE comp_plan_id = p_comp_plan_id;
1189:
1190: l_comp_plan l_comp_plan_cr%ROWTYPE;
1191: BEGIN
1192: -- Standard Start of API savepoint
1193: SAVEPOINT get_comp_plan_dtl;
1194:
1195: -- Standard call to check for call compatibility.
1196: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1191: BEGIN
1192: -- Standard Start of API savepoint
1193: SAVEPOINT get_comp_plan_dtl;
1194:
1195: -- Standard call to check for call compatibility.
1196: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1197: THEN
1198: RAISE fnd_api.g_exc_unexpected_error;
1199: END IF;

Line 1255: -- Standard check of p_commit.

1251:
1252: CLOSE l_comp_plan_cr;
1253:
1254: -- End of API body.
1255: -- Standard check of p_commit.
1256: IF fnd_api.to_boolean (p_commit)
1257: THEN
1258: COMMIT WORK;
1259: END IF;

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

1257: THEN
1258: COMMIT WORK;
1259: END IF;
1260:
1261: -- Standard call to get message count and if count is 1, get message info.
1262: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1263: EXCEPTION
1264: WHEN fnd_api.g_exc_error
1265: THEN

Line 1339: -- Standard Start of API savepoint

1335:
1336: l_sales_role l_sales_role_cr%ROWTYPE;
1337: l_counter NUMBER;
1338: BEGIN
1339: -- Standard Start of API savepoint
1340: SAVEPOINT get_sales_role;
1341:
1342: -- Standard call to check for call compatibility.
1343: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1338: BEGIN
1339: -- Standard Start of API savepoint
1340: SAVEPOINT get_sales_role;
1341:
1342: -- Standard call to check for call compatibility.
1343: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1344: THEN
1345: RAISE fnd_api.g_exc_unexpected_error;
1346: END IF;

Line 1372: -- Standard check of p_commit.

1368: x_sales_role (l_counter).object_version_number := l_sales_role.object_version_number;
1369: END LOOP;
1370:
1371: -- End of API body.
1372: -- Standard check of p_commit.
1373: IF fnd_api.to_boolean (p_commit)
1374: THEN
1375: COMMIT WORK;
1376: END IF;

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

1374: THEN
1375: COMMIT WORK;
1376: END IF;
1377:
1378: -- Standard call to get message count and if count is 1, get message info.
1379: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1380: EXCEPTION
1381: WHEN fnd_api.g_exc_error
1382: THEN

Line 1465: -- Standard Start of API savepoint

1461: AND q.quota_id = qa.quota_id
1462: AND q.calc_formula_id = f.calc_formula_id
1463: AND f.formula_status = 'INCOMPLETE';
1464: BEGIN
1465: -- Standard Start of API savepoint
1466: SAVEPOINT validate_comp_plan;
1467:
1468: -- Standard call to check for call compatibility.
1469: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1464: BEGIN
1465: -- Standard Start of API savepoint
1466: SAVEPOINT validate_comp_plan;
1467:
1468: -- Standard call to check for call compatibility.
1469: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1470: THEN
1471: RAISE fnd_api.g_exc_unexpected_error;
1472: END IF;

Line 1571: -- Standard check of p_commit.

1567: --RAISE fnd_api.g_exc_error;
1568: END IF;
1569:
1570: -- End of API body.
1571: -- Standard check of p_commit.
1572: IF fnd_api.to_boolean (p_commit)
1573: THEN
1574: COMMIT WORK;
1575: END IF;

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

1573: THEN
1574: COMMIT WORK;
1575: END IF;
1576:
1577: -- Standard call to get message count and if count is 1, get message info.
1578: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1579: EXCEPTION
1580: WHEN fnd_api.g_exc_error
1581: THEN

Line 1834: -- Standard Start of API savepoint

1830: l_unique_name varchar2(30);
1831:
1832: BEGIN
1833:
1834: -- Standard Start of API savepoint
1835:
1836: SAVEPOINT duplicate_comp_plan;
1837:
1838: -- Standard call to check for call compatibility.

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

1834: -- Standard Start of API savepoint
1835:
1836: SAVEPOINT duplicate_comp_plan;
1837:
1838: -- Standard call to check for call compatibility.
1839:
1840: IF NOT FND_API.Compatible_API_Call (l_api_version ,
1841: p_api_version ,
1842: l_api_name,

Line 1969: -- Standard check of p_commit.

1965: END LOOP;
1966:
1967:
1968:
1969: -- Standard check of p_commit.
1970:
1971: IF FND_API.To_Boolean( p_commit ) THEN
1972: COMMIT WORK;
1973: END IF;

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

1971: IF FND_API.To_Boolean( p_commit ) THEN
1972: COMMIT WORK;
1973: END IF;
1974:
1975: -- Standard call to get message count and if count is 1, get message info.
1976:
1977: FND_MSG_PUB.Count_And_Get
1978: (p_count => x_msg_count ,
1979: p_data => x_msg_data ,