[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;
757: END LOOP;
758: END IF; -- Table Count is Not Zero
759:
760: -- End of API body.
761: -- Standard check of p_commit.
762: IF fnd_api.to_boolean (p_commit)
763: THEN
764: COMMIT WORK;
765: END IF;
766:
767: <
768: NULL;
769: --+
770: -- Standard call to get message count and if count is 1, get message info.
771: --+
772: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
773: EXCEPTION
774: WHEN fnd_api.g_exc_error
821: l_uplift_date_seq_rec_tbl uplift_date_seq_rec_tbl_type;
822: l_loading_status VARCHAR2 (80);
823: BEGIN
824: --
825: -- Standard Start of API savepoint
826: -- +
827: SAVEPOINT update_quota_rule_uplift;
828:
829: --+
826: -- +
827: SAVEPOINT update_quota_rule_uplift;
828:
829: --+
830: -- Standard call to check for call compatibility.
831: --+
832: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
833: THEN
834: RAISE fnd_api.g_exc_unexpected_error;
961: END LOOP;
962: END IF; -- Table Count is Not Zero
963:
964: -- End of API body.
965: -- Standard check of p_commit.
966: --+
967: IF fnd_api.to_boolean (p_commit)
968: THEN
969: COMMIT WORK;
969: COMMIT WORK;
970: END IF;
971:
972: --+
973: -- Standard call to get message count and if count is 1, get message info.
974: --+
975: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
976: EXCEPTION
977: WHEN fnd_api.g_exc_error
1023: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type;
1024: l_date_msg VARCHAR2 (100);
1025: l_loading_status VARCHAR2 (80);
1026: BEGIN
1027: -- Standard Start of API savepoint
1028: SAVEPOINT delete_quota_rule_uplift;
1029:
1030: -- Standard call to check for call compatibility.
1031: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1026: BEGIN
1027: -- Standard Start of API savepoint
1028: SAVEPOINT delete_quota_rule_uplift;
1029:
1030: -- Standard call to check for call compatibility.
1031: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
1032: THEN
1033: RAISE fnd_api.g_exc_unexpected_error;
1034: END IF;
1044: x_loading_status := 'CN_DELETED';
1045:
1046: -- API body
1047: -- Store the User Input Value into The Local Variable.
1048: -- Standard check of p_commit.
1049: --+
1050: IF (p_rev_uplift_rec_tbl.COUNT <> 0)
1051: THEN
1052: -- Loop through each record we get from the Procedure call
1154: END LOOP;
1155: END IF; -- Table Count is Not Zero
1156:
1157: -- End of API body.
1158: -- Standard check of p_commit.
1159: --+
1160: IF fnd_api.to_boolean (p_commit)
1161: THEN
1162: COMMIT WORK;
1162: COMMIT WORK;
1163: END IF;
1164:
1165: --+
1166: -- Standard call to get message count and if count is 1, get message info.
1167: --+
1168: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1169: EXCEPTION
1170: WHEN fnd_api.g_exc_error