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

Line 36: -- Standard check of p_commit.

32: l_quota_rule.revenue_class_id := cn_api.get_rev_class_id (l_quota_rule.revenue_class_name, l_quota_rule.org_id);
33:
34: -- API body
35: -- Store the User Input Value into The Local Variable.
36: -- Standard check of p_commit.
37: --+
38: -- Check if plan element name is missing or null even for Delete the Q Rule
39: IF ((cn_api.chk_miss_char_para (p_char_para => l_quota_rule.plan_element_name,
40: p_para_name => cn_chk_plan_element_pkg.g_pe_name,

Line 326: -- Standard Start of API savepoint

322: checkif_parent_revclass BOOLEAN := TRUE;
323: l_loading_status VARCHAR2 (2000);
324: x_loading_status varchar2(2000) ;
325: BEGIN
326: -- Standard Start of API savepoint
327: SAVEPOINT validate_quota_rule;
328:
329: -- Standard call to check for call compatibility.
330: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

325: BEGIN
326: -- Standard Start of API savepoint
327: SAVEPOINT validate_quota_rule;
328:
329: -- Standard call to check for call compatibility.
330: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
331: THEN
332: RAISE fnd_api.g_exc_unexpected_error;
333: END IF;

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

661: END IF;
662: END IF;
663: END IF;
664:
665: -- Standard call to get message count and if count is 1, get message info.
666: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
667: EXCEPTION
668: WHEN fnd_api.g_exc_error
669: THEN

Line 727: -- Standard Start of API savepoint

723: IS
724: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Quota_Rule';
725: l_api_version CONSTANT NUMBER := 1.0;
726: BEGIN
727: -- Standard Start of API savepoint
728: SAVEPOINT create_quota_rule;
729:
730: -- Standard call to check for call compatibility.
731: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

726: BEGIN
727: -- Standard Start of API savepoint
728: SAVEPOINT create_quota_rule;
729:
730: -- Standard call to check for call compatibility.
731: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
732: THEN
733: RAISE fnd_api.g_exc_unexpected_error;
734: END IF;

Line 811: -- Standard check of p_commit.

807: RAISE fnd_api.g_exc_error;
808: END IF;
809:
810: -- End of API body.
811: -- Standard check of p_commit.
812: IF fnd_api.to_boolean (p_commit)
813: THEN
814: COMMIT WORK;
815: END IF;

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

813: THEN
814: COMMIT WORK;
815: END IF;
816:
817: -- Standard call to get message count and if count is 1, get message info.
818: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
819: EXCEPTION
820: WHEN fnd_api.g_exc_error
821: THEN

Line 886: -- Standard Start of API savepoint

882: l_revclass_rec quota_rule_rec_type;
883: l_loading_status VARCHAR2 (80);
884: BEGIN
885: --
886: -- Standard Start of API savepoint
887: -- +
888: SAVEPOINT create_plan_element;
889:
890: --+

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

887: -- +
888: SAVEPOINT create_plan_element;
889:
890: --+
891: -- Standard call to check for call compatibility.
892: --+
893: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
894: THEN
895: RAISE fnd_api.g_exc_unexpected_error;

Line 994: -- Standard check of p_commit.

990: END LOOP; -- Revenue Class
991: END IF; -- Table Count is Not Zero
992:
993: -- End of API body.
994: -- Standard check of p_commit.
995: IF fnd_api.to_boolean (p_commit)
996: THEN
997: COMMIT WORK;
998: END IF;

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

997: COMMIT WORK;
998: END IF;
999:
1000: --+
1001: -- Standard call to get message count and if count is 1, get message info.
1002: --+
1003: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1004: EXCEPTION
1005: WHEN fnd_api.g_exc_error

Line 1074: -- Standard Start of API savepoint

1070:
1071: l_old_quota_rule l_old_quota_rule_cr%ROWTYPE;
1072: l_old_rec quota_rule_rec_type;
1073: BEGIN
1074: -- Standard Start of API savepoint
1075: SAVEPOINT update_quota_rule;
1076:
1077: -- Standard call to check for call compatibility.
1078: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

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

Line 1168: -- Standard check of p_commit.

1164: END IF;
1165:
1166:
1167: -- End of API body.
1168: -- Standard check of p_commit.
1169: IF fnd_api.to_boolean (p_commit)
1170: THEN
1171: COMMIT WORK;
1172: END IF;

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

1170: THEN
1171: COMMIT WORK;
1172: END IF;
1173:
1174: -- Standard call to get message count and if count is 1, get message info.
1175: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1176: EXCEPTION
1177: WHEN fnd_api.g_exc_error
1178: THEN

Line 1226: -- Standard Start of API savepoint

1222: l_rev_class_id_old NUMBER;
1223: l_loading_status VARCHAR2 (80);
1224: BEGIN
1225: --
1226: -- Standard Start of API savepoint
1227: -- +
1228: SAVEPOINT update_quota_rules;
1229:
1230: --+

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

1227: -- +
1228: SAVEPOINT update_quota_rules;
1229:
1230: --+
1231: -- Standard call to check for call compatibility.
1232: --+
1233: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1234: THEN
1235: RAISE fnd_api.g_exc_unexpected_error;

Line 1319: -- Standard check of p_commit.

1315: END LOOP; -- Revenue Class
1316: END IF; -- Table Count is Not Zero
1317:
1318: -- End of API body.
1319: -- Standard check of p_commit.
1320: IF fnd_api.to_boolean (p_commit)
1321: THEN
1322: COMMIT WORK;
1323: END IF;

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

1322: COMMIT WORK;
1323: END IF;
1324:
1325: --+
1326: -- Standard call to get message count and if count is 1, get message info.
1327: --+
1328: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1329: EXCEPTION
1330: WHEN fnd_api.g_exc_error

Line 1393: -- Standard Start of API savepoint

1389: l_quota_id NUMBER;
1390: l_revenue_class_id NUMBER;
1391: l_quota_name cn_quotas.NAME%TYPE;
1392: BEGIN
1393: -- Standard Start of API savepoint
1394: SAVEPOINT delete_quota_rule;
1395:
1396: -- Standard call to check for call compatibility.
1397: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1392: BEGIN
1393: -- Standard Start of API savepoint
1394: SAVEPOINT delete_quota_rule;
1395:
1396: -- Standard call to check for call compatibility.
1397: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1398: THEN
1399: RAISE fnd_api.g_exc_unexpected_error;
1400: END IF;

Line 1445: -- Standard check of p_commit.

1441: RAISE fnd_api.g_exc_error;
1442: END IF;
1443:
1444: -- End of API body.
1445: -- Standard check of p_commit.
1446: IF fnd_api.to_boolean (p_commit)
1447: THEN
1448: COMMIT WORK;
1449: END IF;

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

1447: THEN
1448: COMMIT WORK;
1449: END IF;
1450:
1451: -- Standard call to get message count and if count is 1, get message info.
1452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1453: EXCEPTION
1454: WHEN fnd_api.g_exc_error
1455: THEN

Line 1499: -- Standard Start of API savepoint

1495: l_api_version CONSTANT NUMBER := 1.0;
1496: l_loading_status VARCHAR2 (80);
1497: l_rec quota_rule_rec_type;
1498: BEGIN
1499: -- Standard Start of API savepoint
1500: SAVEPOINT delete_plan_element;
1501:
1502: -- Standard call to check for call compatibility.
1503: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

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

1498: BEGIN
1499: -- Standard Start of API savepoint
1500: SAVEPOINT delete_plan_element;
1501:
1502: -- Standard call to check for call compatibility.
1503: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1504: THEN
1505: RAISE fnd_api.g_exc_unexpected_error;
1506: END IF;

Line 1549: -- standard Commit

1545: END IF;
1546: END LOOP;
1547: END IF;
1548:
1549: -- standard Commit
1550: IF fnd_api.to_boolean (p_commit)
1551: THEN
1552: COMMIT WORK;
1553: END IF;

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

1552: COMMIT WORK;
1553: END IF;
1554:
1555: --+
1556: -- Standard call to get message count and if count is 1, get message info.
1557: --+
1558: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1559: EXCEPTION
1560: WHEN fnd_api.g_exc_error