[Home] [Help]
544: RAISE fnd_api.g_exc_error;
545: END IF;
546:
547: -- End of API body.
548: -- Standard call to get message count and if count is 1, get message info.
549: --+
550: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
551: EXCEPTION
552: WHEN fnd_api.g_exc_error
596: l_uplift_date_seq_rec_tbl uplift_date_seq_rec_tbl_type;
597: l_loading_status VARCHAR2 (80);
598: BEGIN
599: --
600: -- Standard Start of API savepoint
601: -- +
602: SAVEPOINT create_quota_rule_uplift;
603:
604: --+
601: -- +
602: SAVEPOINT create_quota_rule_uplift;
603:
604: --+
605: -- Standard call to check for call compatibility.
606: --+
607: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
608: THEN
609: RAISE fnd_api.g_exc_unexpected_error;
739: END LOOP;
740: END IF; -- Table Count is Not Zero
741:
742: -- End of API body.
743: -- Standard check of p_commit.
744: IF fnd_api.to_boolean (p_commit)
745: THEN
746: COMMIT WORK;
747: END IF;
748:
749: <
750: NULL;
751: --+
752: -- Standard call to get message count and if count is 1, get message info.
753: --+
754: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
755: EXCEPTION
756: WHEN fnd_api.g_exc_error
803: l_uplift_date_seq_rec_tbl uplift_date_seq_rec_tbl_type;
804: l_loading_status VARCHAR2 (80);
805: BEGIN
806: --
807: -- Standard Start of API savepoint
808: -- +
809: SAVEPOINT update_quota_rule_uplift;
810:
811: --+
808: -- +
809: SAVEPOINT update_quota_rule_uplift;
810:
811: --+
812: -- Standard call to check for call compatibility.
813: --+
814: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
815: THEN
816: RAISE fnd_api.g_exc_unexpected_error;
943: END LOOP;
944: END IF; -- Table Count is Not Zero
945:
946: -- End of API body.
947: -- Standard check of p_commit.
948: --+
949: IF fnd_api.to_boolean (p_commit)
950: THEN
951: COMMIT WORK;
951: COMMIT WORK;
952: END IF;
953:
954: --+
955: -- Standard call to get message count and if count is 1, get message info.
956: --+
957: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
958: EXCEPTION
959: WHEN fnd_api.g_exc_error
1005: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;
1006: l_date_msg VARCHAR2 (100);
1007: l_loading_status VARCHAR2 (80);
1008: BEGIN
1009: -- Standard Start of API savepoint
1010: SAVEPOINT delete_quota_rule_uplift;
1011:
1012: -- Standard call to check for call compatibility.
1013: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1008: BEGIN
1009: -- Standard Start of API savepoint
1010: SAVEPOINT delete_quota_rule_uplift;
1011:
1012: -- Standard call to check for call compatibility.
1013: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1014: THEN
1015: RAISE fnd_api.g_exc_unexpected_error;
1016: END IF;
1026: x_loading_status := 'CN_DELETED';
1027:
1028: -- API body
1029: -- Store the User Input Value into The Local Variable.
1030: -- Standard check of p_commit.
1031: --+
1032: IF (p_rev_uplift_rec_tbl.COUNT <> 0)
1033: THEN
1034: -- Loop through each record we get from the Procedure call
1136: END LOOP;
1137: END IF; -- Table Count is Not Zero
1138:
1139: -- End of API body.
1140: -- Standard check of p_commit.
1141: --+
1142: IF fnd_api.to_boolean (p_commit)
1143: THEN
1144: COMMIT WORK;
1144: COMMIT WORK;
1145: END IF;
1146:
1147: --+
1148: -- Standard call to get message count and if count is 1, get message info.
1149: --+
1150: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1151: EXCEPTION
1152: WHEN fnd_api.g_exc_error