1385: g_created_by NUMBER := fnd_global.user_id;
1386: g_last_update_login NUMBER := fnd_global.login_id;
1387: g_remove_this VARCHAR2 (1) := '#';
1388: BEGIN
1389: -- Standard Start of API savepoint
1390: SAVEPOINT create_plan_element;
1391:
1392: -- Standard call to check for call compatibility.
1393: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1388: BEGIN
1389: -- Standard Start of API savepoint
1390: SAVEPOINT create_plan_element;
1391:
1392: -- Standard call to check for call compatibility.
1393: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1394: THEN
1395: RAISE fnd_api.g_exc_unexpected_error;
1396: END IF;
1518: RAISE fnd_api.g_exc_error;
1519: END IF;
1520:
1521: -- End of API body.
1522: -- Standard check of p_commit.
1523: IF fnd_api.to_boolean (p_commit)
1524: THEN
1525: COMMIT WORK;
1526: END IF;
1524: THEN
1525: COMMIT WORK;
1526: END IF;
1527:
1528: -- Standard call to get message count and if count is 1, get message info.
1529: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1530: EXCEPTION
1531: WHEN fnd_api.g_exc_error
1532: THEN
1677: s_tot_performance_goal NUMBER;
1678: l_loading_status VARCHAR2 (100);
1679: x_loading_status VARCHAR (100);
1680: BEGIN
1681: -- Standard Start of API savepoint
1682: SAVEPOINT update_plan_element;
1683:
1684: -- Standard call to check for call compatibility.
1685: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1680: BEGIN
1681: -- Standard Start of API savepoint
1682: SAVEPOINT update_plan_element;
1683:
1684: -- Standard call to check for call compatibility.
1685: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1686: THEN
1687: RAISE fnd_api.g_exc_unexpected_error;
1688: END IF;
1968: RAISE fnd_api.g_exc_error;
1969: END IF;
1970:
1971: -- End of API body.
1972: -- Standard check of p_commit.
1973: IF fnd_api.to_boolean (p_commit)
1974: THEN
1975: COMMIT WORK;
1976: END IF;
1974: THEN
1975: COMMIT WORK;
1976: END IF;
1977:
1978: -- Standard call to get message count and if count is 1, get message info.
1979: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1980: EXCEPTION
1981: WHEN fnd_api.g_exc_error
1982: THEN
2036: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Plan_Element';
2037: l_api_version CONSTANT NUMBER := 1.0;
2038: l_quota_name cn_quotas.NAME%TYPE;
2039: BEGIN
2040: -- Standard Start of API savepoint
2041: SAVEPOINT delete_plan_element;
2042:
2043: -- Standard call to check for call compatibility.
2044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2039: BEGIN
2040: -- Standard Start of API savepoint
2041: SAVEPOINT delete_plan_element;
2042:
2043: -- Standard call to check for call compatibility.
2044: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2045: THEN
2046: RAISE fnd_api.g_exc_unexpected_error;
2047: END IF;
2091: RAISE fnd_api.g_exc_error;
2092: END IF;
2093:
2094: -- End of API body.
2095: -- Standard check of p_commit.
2096: IF fnd_api.to_boolean (p_commit)
2097: THEN
2098: COMMIT WORK;
2099: END IF;
2097: THEN
2098: COMMIT WORK;
2099: END IF;
2100:
2101: -- Standard call to get message count and if count is 1, get message info.
2102: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2103: EXCEPTION
2104: WHEN fnd_api.g_exc_error
2105: THEN
2176: l_quota_id NUMBER;
2177: l_payeechk NUMBER;
2178: l_uplift_dt_range NUMBER; --Added by hanaraya for bug 6505174
2179: BEGIN
2180: -- Standard Start of API savepoint
2181: SAVEPOINT validate_plan_element;
2182:
2183: -- Standard call to check for call compatibility.
2184: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2179: BEGIN
2180: -- Standard Start of API savepoint
2181: SAVEPOINT validate_plan_element;
2182:
2183: -- Standard call to check for call compatibility.
2184: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2185: THEN
2186: RAISE fnd_api.g_exc_unexpected_error;
2187: END IF;
2457: END IF; -- END OF DELETE VALIDATION
2458:
2459: -- End of API body.
2460: <
2461: -- Standard call to get message count and if count is 1, get message info.
2462: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2463: EXCEPTION
2464: WHEN fnd_api.g_exc_error
2465: THEN
2658: g_incomplete VARCHAR2 (30) := 'INCOMPLETE';
2659: g_complete VARCHAR2 (30) := 'COMPLETE';
2660: l_temp_status_code VARCHAR2 (30) := g_complete;
2661: BEGIN
2662: -- Standard Start of API savepoint
2663: SAVEPOINT validate_plan_element_2;
2664:
2665: -- Standard call to check for call compatibility.
2666: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2661: BEGIN
2662: -- Standard Start of API savepoint
2663: SAVEPOINT validate_plan_element_2;
2664:
2665: -- Standard call to check for call compatibility.
2666: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2667: THEN
2668: RAISE fnd_api.g_exc_unexpected_error;
2669: END IF;
2841: -- we just need to tell the comp plan that it is invalid
2842: x_status_code := l_temp_status_code;
2843:
2844: -- End of API body.
2845: -- Standard check of p_commit.
2846: IF fnd_api.to_boolean (p_commit)
2847: THEN
2848: COMMIT WORK;
2849: END IF;
2847: THEN
2848: COMMIT WORK;
2849: END IF;
2850:
2851: -- Standard call to get message count and if count is 1, get message info.
2852: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2853: EXCEPTION
2854: WHEN fnd_api.g_exc_error
2855: THEN