eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_QUOTA_RULE_UPLIFT_PVT dependencies on FND_MSG_PUB

Line 168: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

164: EXCEPTION
165: WHEN fnd_api.g_exc_error
166: THEN
167: x_return_status := fnd_api.g_ret_sts_error;
168: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
169: WHEN fnd_api.g_exc_unexpected_error
170: THEN
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 172: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

168: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
169: WHEN fnd_api.g_exc_unexpected_error
170: THEN
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
173: WHEN OTHERS
174: THEN
175: x_return_status := fnd_api.g_ret_sts_unexp_error;
176: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

Line 176: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

172: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
173: WHEN OTHERS
174: THEN
175: x_return_status := fnd_api.g_ret_sts_unexp_error;
176: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
177: THEN
178: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
179: END IF;
180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 178: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');

174: THEN
175: x_return_status := fnd_api.g_ret_sts_unexp_error;
176: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
177: THEN
178: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
179: END IF;
180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
181:
182: END add_system_note;

Line 180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

176: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
177: THEN
178: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
179: END IF;
180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
181:
182: END add_system_note;
183:
184:

Line 237: fnd_msg_pub.initialize;

233:
234: -- Initialize message list if p_init_msg_list is set to TRUE.
235: IF fnd_api.to_boolean (p_init_msg_list)
236: THEN
237: fnd_msg_pub.initialize;
238: END IF;
239:
240: -- Initialize API return status to success
241: x_return_status := fnd_api.g_ret_sts_success;

Line 246: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

242:
243: -- if the Quota Rule uplift iD is null then Error message
244: IF p_quota_rule_uplift.quota_rule_uplift_id IS NULL
245: THEN
246: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
247: THEN
248: fnd_message.set_name ('CN', 'CN_INVALID_UPDATE_REC');
249: fnd_msg_pub.ADD;
250: END IF;

Line 249: fnd_msg_pub.ADD;

245: THEN
246: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
247: THEN
248: fnd_message.set_name ('CN', 'CN_INVALID_UPDATE_REC');
249: fnd_msg_pub.ADD;
250: END IF;
251:
252: RAISE fnd_api.g_exc_error;
253: END IF;

Line 270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

266: );
267:
268: IF (x_return_status <> fnd_api.g_ret_sts_success)
269: THEN
270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
271: THEN
272: fnd_message.set_name ('CN', 'CN_UPLIFT_DELETE_NOT_ALLOWED');
273: fnd_msg_pub.ADD;
274: END IF;

Line 273: fnd_msg_pub.ADD;

269: THEN
270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
271: THEN
272: fnd_message.set_name ('CN', 'CN_UPLIFT_DELETE_NOT_ALLOWED');
273: fnd_msg_pub.ADD;
274: END IF;
275:
276: RAISE fnd_api.g_exc_error;
277: END IF;

Line 294: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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
298: ROLLBACK TO validate_uplift;

Line 300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

296: WHEN fnd_api.g_exc_error
297: THEN
298: ROLLBACK TO validate_uplift;
299: x_return_status := fnd_api.g_ret_sts_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
301: WHEN fnd_api.g_exc_unexpected_error
302: THEN
303: ROLLBACK TO validate_uplift;
304: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

301: WHEN fnd_api.g_exc_unexpected_error
302: THEN
303: ROLLBACK TO validate_uplift;
304: x_return_status := fnd_api.g_ret_sts_unexp_error;
305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
306: WHEN OTHERS
307: THEN
308: ROLLBACK TO validate_uplift;
309: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 311: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

307: THEN
308: ROLLBACK TO validate_uplift;
309: x_return_status := fnd_api.g_ret_sts_unexp_error;
310:
311: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
312: THEN
313: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
314: END IF;
315:

Line 313: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

309: x_return_status := fnd_api.g_ret_sts_unexp_error;
310:
311: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
312: THEN
313: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
314: END IF;
315:
316: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
317: END validate_uplift;

Line 316: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

312: THEN
313: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
314: END IF;
315:
316: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
317: END validate_uplift;
318:
319: -- Start of comments
320: -- API name : Create_Quota_Uplift

Line 376: fnd_msg_pub.initialize;

372:
373: -- Initialize message list if p_init_msg_list is set to TRUE.
374: IF fnd_api.to_boolean (p_init_msg_list)
375: THEN
376: fnd_msg_pub.initialize;
377: END IF;
378:
379: -- Initialize API return status to success
380: x_return_status := fnd_api.g_ret_sts_success;

Line 388: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

384: -- 1. name can not be null
385: --clku
386: IF (p_quota_rule_uplift.start_date IS NULL) OR (p_quota_rule_uplift.start_date = fnd_api.g_miss_date)
387: THEN
388: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
389: THEN
390: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
391: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
392: fnd_msg_pub.ADD;

Line 392: fnd_msg_pub.ADD;

388: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
389: THEN
390: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
391: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
392: fnd_msg_pub.ADD;
393: END IF;
394:
395: RAISE fnd_api.g_exc_error;
396: END IF;

Line 427: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

423: WHERE qr.quota_rule_id = l_quota_rule_id AND q.quota_id = qr.quota_id;
424:
425: IF (l_rev_uplift_rec_tbl (1).start_date < l_start_date) OR (NVL (l_rev_uplift_rec_tbl (1).end_date, l_null_date) > l_end_date)
426: THEN
427: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
428: THEN
429: fnd_message.set_name ('CN', 'CN_RC_INVALID_DATE_RANGE');
430: fnd_msg_pub.ADD;
431: END IF;

Line 430: fnd_msg_pub.ADD;

426: THEN
427: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
428: THEN
429: fnd_message.set_name ('CN', 'CN_RC_INVALID_DATE_RANGE');
430: fnd_msg_pub.ADD;
431: END IF;
432:
433: RAISE fnd_api.g_exc_error;
434: END IF;

Line 498: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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
502: ROLLBACK TO create_quota_rule_uplift;

Line 504: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

500: WHEN fnd_api.g_exc_error
501: THEN
502: ROLLBACK TO create_quota_rule_uplift;
503: x_return_status := fnd_api.g_ret_sts_error;
504: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
505: WHEN fnd_api.g_exc_unexpected_error
506: THEN
507: ROLLBACK TO create_quota_rule_uplift;
508: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 509: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

505: WHEN fnd_api.g_exc_unexpected_error
506: THEN
507: ROLLBACK TO create_quota_rule_uplift;
508: x_return_status := fnd_api.g_ret_sts_unexp_error;
509: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
510: WHEN OTHERS
511: THEN
512: ROLLBACK TO create_quota_rule_uplift;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 515: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

511: THEN
512: ROLLBACK TO create_quota_rule_uplift;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514:
515: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
516: THEN
517: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
518: END IF;
519:

Line 517: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514:
515: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
516: THEN
517: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
518: END IF;
519:
520: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
521: END create_uplift;

Line 520: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

516: THEN
517: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
518: END IF;
519:
520: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
521: END create_uplift;
522:
523: -- Start of comments
524: -- API name : Update_Uplift

Line 588: fnd_msg_pub.initialize;

584:
585: -- Initialize message list if p_init_msg_list is set to TRUE.
586: IF fnd_api.to_boolean (p_init_msg_list)
587: THEN
588: fnd_msg_pub.initialize;
589: END IF;
590:
591: -- Initialize API return status to success
592: x_return_status := fnd_api.g_ret_sts_success;

Line 599: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

595:
596: -- 1. name can not be null
597: IF (p_quota_rule_uplift.start_date IS NULL)
598: THEN
599: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
600: THEN
601: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
602: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
603: fnd_msg_pub.ADD;

Line 603: fnd_msg_pub.ADD;

599: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
600: THEN
601: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
602: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
603: fnd_msg_pub.ADD;
604: END IF;
605:
606: RAISE fnd_api.g_exc_error;
607: END IF;

Line 620: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

616: AND ROWNUM = 1;
617:
618: IF l_temp_count <> 0
619: THEN
620: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
621: THEN
622: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
623: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
624: fnd_msg_pub.ADD;

Line 624: fnd_msg_pub.ADD;

620: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
621: THEN
622: fnd_message.set_name ('CN', 'CN_INPUT_MUST_UNIQUE');
623: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('SD', 'INPUT_TOKEN'));
624: fnd_msg_pub.ADD;
625: END IF;
626:
627: RAISE fnd_api.g_exc_error;
628: END IF;

Line 669: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

665: WHERE qr.quota_rule_id = l_quota_rule_id AND q.quota_id = qr.quota_id;
666:
667: IF l_old_quota_rule_uplift.object_version_number <> p_quota_rule_uplift.object_version_number
668: THEN
669: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
670: THEN
671:
672: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
673: fnd_msg_pub.ADD;

Line 673: fnd_msg_pub.ADD;

669: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
670: THEN
671:
672: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
673: fnd_msg_pub.ADD;
674: END IF;
675:
676: RAISE fnd_api.g_exc_error;
677: END IF;

Line 681: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

677: END IF;
678:
679: IF (l_rev_uplift_rec_tbl (1).start_date < l_start_date) OR (NVL (l_rev_uplift_rec_tbl (1).end_date, l_null_date) > l_end_date)
680: THEN
681: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
682: THEN
683: fnd_message.set_name ('CN', 'CN_RC_INVALID_DATE_RANGE');
684: fnd_msg_pub.ADD;
685: END IF;

Line 684: fnd_msg_pub.ADD;

680: THEN
681: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
682: THEN
683: fnd_message.set_name ('CN', 'CN_RC_INVALID_DATE_RANGE');
684: fnd_msg_pub.ADD;
685: END IF;
686:
687: RAISE fnd_api.g_exc_error;
688: END IF;

Line 759: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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
763: ROLLBACK TO update_quota_rule_uplift;

Line 765: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

761: WHEN fnd_api.g_exc_error
762: THEN
763: ROLLBACK TO update_quota_rule_uplift;
764: x_return_status := fnd_api.g_ret_sts_error;
765: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
766: WHEN fnd_api.g_exc_unexpected_error
767: THEN
768: ROLLBACK TO update_quota_rule_uplift;
769: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 770: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

766: WHEN fnd_api.g_exc_unexpected_error
767: THEN
768: ROLLBACK TO update_quota_rule_uplift;
769: x_return_status := fnd_api.g_ret_sts_unexp_error;
770: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
771: WHEN OTHERS
772: THEN
773: ROLLBACK TO update_quota_rule_uplift;
774: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 776: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

772: THEN
773: ROLLBACK TO update_quota_rule_uplift;
774: x_return_status := fnd_api.g_ret_sts_unexp_error;
775:
776: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
777: THEN
778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
779: END IF;
780:

Line 778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

774: x_return_status := fnd_api.g_ret_sts_unexp_error;
775:
776: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
777: THEN
778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
779: END IF;
780:
781: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
782: END update_uplift;

Line 781: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

777: THEN
778: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
779: END IF;
780:
781: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
782: END update_uplift;
783:
784: -- Start of comments
785: -- API name : Delete_Uplift

Line 837: fnd_msg_pub.initialize;

833:
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: IF fnd_api.to_boolean (p_init_msg_list)
836: THEN
837: fnd_msg_pub.initialize;
838: END IF;
839:
840: -- Initialize API return status to success
841: x_return_status := fnd_api.g_ret_sts_success;

Line 907: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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
911: ROLLBACK TO delete_quota_rule_uplift;

Line 913: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

909: WHEN fnd_api.g_exc_error
910: THEN
911: ROLLBACK TO delete_quota_rule_uplift;
912: x_return_status := fnd_api.g_ret_sts_error;
913: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
914: WHEN fnd_api.g_exc_unexpected_error
915: THEN
916: ROLLBACK TO delete_quota_rule_uplift;
917: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 918: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

914: WHEN fnd_api.g_exc_unexpected_error
915: THEN
916: ROLLBACK TO delete_quota_rule_uplift;
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
919: WHEN OTHERS
920: THEN
921: ROLLBACK TO delete_quota_rule_uplift;
922: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 924: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

920: THEN
921: ROLLBACK TO delete_quota_rule_uplift;
922: x_return_status := fnd_api.g_ret_sts_unexp_error;
923:
924: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
925: THEN
926: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
927: END IF;
928:

Line 926: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

922: x_return_status := fnd_api.g_ret_sts_unexp_error;
923:
924: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
925: THEN
926: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
927: END IF;
928:
929: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
930: END delete_uplift;

Line 929: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

925: THEN
926: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
927: END IF;
928:
929: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
930: END delete_uplift;
931:
932: END cn_quota_rule_uplift_pvt;