[Home] [Help]
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;
1944: RAISE fnd_api.g_exc_error;
1945: END IF;
1946:
1947: -- End of API body.
1948: -- Standard check of p_commit.
1949: IF fnd_api.to_boolean (p_commit)
1950: THEN
1951: COMMIT WORK;
1952: END IF;
1950: THEN
1951: COMMIT WORK;
1952: END IF;
1953:
1954: -- Standard call to get message count and if count is 1, get message info.
1955: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1956: EXCEPTION
1957: WHEN fnd_api.g_exc_error
1958: THEN
2012: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Plan_Element';
2013: l_api_version CONSTANT NUMBER := 1.0;
2014: l_quota_name cn_quotas.NAME%TYPE;
2015: BEGIN
2016: -- Standard Start of API savepoint
2017: SAVEPOINT delete_plan_element;
2018:
2019: -- Standard call to check for call compatibility.
2020: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2015: BEGIN
2016: -- Standard Start of API savepoint
2017: SAVEPOINT delete_plan_element;
2018:
2019: -- Standard call to check for call compatibility.
2020: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2021: THEN
2022: RAISE fnd_api.g_exc_unexpected_error;
2023: END IF;
2067: RAISE fnd_api.g_exc_error;
2068: END IF;
2069:
2070: -- End of API body.
2071: -- Standard check of p_commit.
2072: IF fnd_api.to_boolean (p_commit)
2073: THEN
2074: COMMIT WORK;
2075: END IF;
2073: THEN
2074: COMMIT WORK;
2075: END IF;
2076:
2077: -- Standard call to get message count and if count is 1, get message info.
2078: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2079: EXCEPTION
2080: WHEN fnd_api.g_exc_error
2081: THEN
2152: l_quota_id NUMBER;
2153: l_payeechk NUMBER;
2154: l_uplift_dt_range NUMBER; --Added by hanaraya for bug 6505174
2155: BEGIN
2156: -- Standard Start of API savepoint
2157: SAVEPOINT validate_plan_element;
2158:
2159: -- Standard call to check for call compatibility.
2160: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2155: BEGIN
2156: -- Standard Start of API savepoint
2157: SAVEPOINT validate_plan_element;
2158:
2159: -- Standard call to check for call compatibility.
2160: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2161: THEN
2162: RAISE fnd_api.g_exc_unexpected_error;
2163: END IF;
2433: END IF; -- END OF DELETE VALIDATION
2434:
2435: -- End of API body.
2436: <
2437: -- Standard call to get message count and if count is 1, get message info.
2438: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2439: EXCEPTION
2440: WHEN fnd_api.g_exc_error
2441: THEN
2634: g_incomplete VARCHAR2 (30) := 'INCOMPLETE';
2635: g_complete VARCHAR2 (30) := 'COMPLETE';
2636: l_temp_status_code VARCHAR2 (30) := g_complete;
2637: BEGIN
2638: -- Standard Start of API savepoint
2639: SAVEPOINT validate_plan_element_2;
2640:
2641: -- Standard call to check for call compatibility.
2642: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2637: BEGIN
2638: -- Standard Start of API savepoint
2639: SAVEPOINT validate_plan_element_2;
2640:
2641: -- Standard call to check for call compatibility.
2642: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
2643: THEN
2644: RAISE fnd_api.g_exc_unexpected_error;
2645: END IF;
2817: -- we just need to tell the comp plan that it is invalid
2818: x_status_code := l_temp_status_code;
2819:
2820: -- End of API body.
2821: -- Standard check of p_commit.
2822: IF fnd_api.to_boolean (p_commit)
2823: THEN
2824: COMMIT WORK;
2825: END IF;
2823: THEN
2824: COMMIT WORK;
2825: END IF;
2826:
2827: -- Standard call to get message count and if count is 1, get message info.
2828: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2829: EXCEPTION
2830: WHEN fnd_api.g_exc_error
2831: THEN