DBA Data[Home] [Help]

APPS.CN_QUOTA_RULE_UPLIFT_PVT dependencies on STANDARD

Line 225: -- Standard Start of API savepoint

221: l_api_version CONSTANT NUMBER := 1.0;
222: l_temp_count NUMBER;
223: l_loading_status VARCHAR2 (240);
224: BEGIN
225: -- Standard Start of API savepoint
226: SAVEPOINT validate_uplift;
227:
228: -- Standard call to check for call compatibility.
229: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 228: -- Standard call to check for call compatibility.

224: BEGIN
225: -- Standard Start of API savepoint
226: SAVEPOINT validate_uplift;
227:
228: -- Standard call to check for call compatibility.
229: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
230: THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;

Line 287: -- Standard check of p_commit.

283: RAISE fnd_api.g_exc_error;
284: END IF;
285:
286: -- End of API body.
287: -- Standard check of p_commit.
288: IF fnd_api.to_boolean (p_commit)
289: THEN
290: COMMIT WORK;
291: END IF;

Line 293: -- Standard call to get message count and if count is 1, get message info.

289: THEN
290: COMMIT WORK;
291: END IF;
292:
293: -- Standard call to get message count and if count is 1, get message info.
294: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
295: EXCEPTION
296: WHEN fnd_api.g_exc_error
297: THEN

Line 364: -- Standard Start of API savepoint

360: l_end_date DATE;
361: l_null_date CONSTANT DATE := TO_DATE ('31-12-9999', 'DD-MM-YYYY');
362: l_quota_id NUMBER;
363: BEGIN
364: -- Standard Start of API savepoint
365: SAVEPOINT create_quota_rule_uplift;
366:
367: -- Standard call to check for call compatibility.
368: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 367: -- Standard call to check for call compatibility.

363: BEGIN
364: -- Standard Start of API savepoint
365: SAVEPOINT create_quota_rule_uplift;
366:
367: -- Standard call to check for call compatibility.
368: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
369: THEN
370: RAISE fnd_api.g_exc_unexpected_error;
371: END IF;

Line 491: -- Standard check of p_commit.

487: RAISE fnd_api.g_exc_error;
488: END IF;
489:
490: -- End of API body.
491: -- Standard check of p_commit.
492: IF fnd_api.to_boolean (p_commit)
493: THEN
494: COMMIT WORK;
495: END IF;

Line 497: -- Standard call to get message count and if count is 1, get message info.

493: THEN
494: COMMIT WORK;
495: END IF;
496:
497: -- Standard call to get message count and if count is 1, get message info.
498: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
499: EXCEPTION
500: WHEN fnd_api.g_exc_error
501: THEN

Line 576: -- Standard Start of API savepoint

572: l_end_date DATE;
573: l_null_date CONSTANT DATE := TO_DATE ('31-12-9999', 'DD-MM-YYYY');
574: l_quota_id NUMBER;
575: BEGIN
576: -- Standard Start of API savepoint
577: SAVEPOINT update_quota_rule_uplift;
578:
579: -- Standard call to check for call compatibility.
580: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 579: -- Standard call to check for call compatibility.

575: BEGIN
576: -- Standard Start of API savepoint
577: SAVEPOINT update_quota_rule_uplift;
578:
579: -- Standard call to check for call compatibility.
580: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
581: THEN
582: RAISE fnd_api.g_exc_unexpected_error;
583: END IF;

Line 752: -- Standard check of p_commit.

748: END IF;
749:
750:
751: -- End of API body.
752: -- Standard check of p_commit.
753: IF fnd_api.to_boolean (p_commit)
754: THEN
755: COMMIT WORK;
756: END IF;

Line 758: -- Standard call to get message count and if count is 1, get message info.

754: THEN
755: COMMIT WORK;
756: END IF;
757:
758: -- Standard call to get message count and if count is 1, get message info.
759: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
760: EXCEPTION
761: WHEN fnd_api.g_exc_error
762: THEN

Line 825: -- Standard Start of API savepoint

821: l_quota_rule_id NUMBER;
822: l_quota_name cn_quotas.NAME%TYPE;
823: l_quota_id NUMBER;
824: BEGIN
825: -- Standard Start of API savepoint
826: SAVEPOINT delete_quota_rule_uplift;
827:
828: -- Standard call to check for call compatibility.
829: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 828: -- Standard call to check for call compatibility.

824: BEGIN
825: -- Standard Start of API savepoint
826: SAVEPOINT delete_quota_rule_uplift;
827:
828: -- Standard call to check for call compatibility.
829: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name)
830: THEN
831: RAISE fnd_api.g_exc_unexpected_error;
832: END IF;

Line 900: -- Standard check of p_commit.

896: RAISE fnd_api.g_exc_error;
897: END IF;
898:
899: -- End of API body.
900: -- Standard check of p_commit.
901: IF fnd_api.to_boolean (p_commit)
902: THEN
903: COMMIT WORK;
904: END IF;

Line 906: -- Standard call to get message count and if count is 1, get message info.

902: THEN
903: COMMIT WORK;
904: END IF;
905:
906: -- Standard call to get message count and if count is 1, get message info.
907: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
908: EXCEPTION
909: WHEN fnd_api.g_exc_error
910: THEN