[Home] [Help]
355: RAISE fnd_api.g_exc_error;
356: END IF;
357:
358: -- End of API body.
359: -- Standard call to get message count and if count is 1, get message info.
360: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
361: EXCEPTION
362: WHEN fnd_api.g_exc_error
363: THEN
409: l_meaning cn_lookups.meaning%TYPE;
410: l_loading_status VARCHAR2 (80);
411: BEGIN
412: --
413: -- Standard Start of API savepoint
414: -- +
415: SAVEPOINT create_plan_element;
416:
417: --+
414: -- +
415: SAVEPOINT create_plan_element;
416:
417: --+
418: -- Standard call to check for call compatibility.
419: --+
420: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
421: THEN
422: RAISE fnd_api.g_exc_unexpected_error;
597: END LOOP; -- Revenue Class
598: END IF; -- Table Count is Not Zero
599:
600: -- End of API body.
601: -- Standard check of p_commit.
602: IF fnd_api.to_boolean (p_commit)
603: THEN
604: COMMIT WORK;
605: END IF;
604: COMMIT WORK;
605: END IF;
606:
607: --+
608: -- Standard call to get message count and if count is 1, get message info.
609: --+
610: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
611: EXCEPTION
612: WHEN fnd_api.g_exc_error
661: l_rev_class_id_old NUMBER;
662: l_loading_status VARCHAR2 (80);
663: BEGIN
664: --
665: -- Standard Start of API savepoint
666: -- +
667: SAVEPOINT update_plan_element;
668:
669: --+
666: -- +
667: SAVEPOINT update_plan_element;
668:
669: --+
670: -- Standard call to check for call compatibility.
671: --+
672: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
673: THEN
674: RAISE fnd_api.g_exc_unexpected_error;
830: END LOOP; -- Revenue Class
831: END IF; -- Table Count is Not Zero
832:
833: -- End of API body.
834: -- Standard check of p_commit.
835: IF fnd_api.to_boolean (p_commit)
836: THEN
837: COMMIT WORK;
838: END IF;
837: COMMIT WORK;
838: END IF;
839:
840: --+
841: -- Standard call to get message count and if count is 1, get message info.
842: --+
843: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
844: EXCEPTION
845: WHEN fnd_api.g_exc_error
889: l_api_version CONSTANT NUMBER := 1.0;
890: l_rev_rec cn_quota_rules%ROWTYPE;
891: l_loading_status VARCHAR2 (80);
892: BEGIN
893: -- Standard Start of API savepoint
894: SAVEPOINT delete_plan_element;
895:
896: -- Standard call to check for call compatibility.
897: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
892: BEGIN
893: -- Standard Start of API savepoint
894: SAVEPOINT delete_plan_element;
895:
896: -- Standard call to check for call compatibility.
897: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
898: THEN
899: RAISE fnd_api.g_exc_unexpected_error;
900: END IF;
910: x_loading_status := 'CN_DELETED';
911:
912: -- API body
913: -- Store the User Input Value into The Local Variable.
914: -- Standard check of p_commit.
915: --+
916: -- Check if plan element name is missing or null even for Delete the Q Rule
917: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name,
918: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
1002: END IF;
1003: END LOOP;
1004: END IF;
1005:
1006: -- standard Commit
1007: IF fnd_api.to_boolean (p_commit)
1008: THEN
1009: COMMIT WORK;
1010: END IF;
1009: COMMIT WORK;
1010: END IF;
1011:
1012: --+
1013: -- Standard call to get message count and if count is 1, get message info.
1014: --+
1015: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1016: EXCEPTION
1017: WHEN fnd_api.g_exc_error