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_UPLIFTS_GRP dependencies on FND_MSG_PUB

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

149: IF p_pe_rec.NAME IS NOT NULL AND p_pe_rec.quota_id IS NULL
150: THEN
151: -- Error, check the msg level and add an error message to the
152: -- API message list
153: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
154: THEN
155: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
156: fnd_message.set_token ('PE_NAME', p_pe_rec.NAME);
157: fnd_msg_pub.ADD;

Line 157: fnd_msg_pub.ADD;

153: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
154: THEN
155: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
156: fnd_message.set_token ('PE_NAME', p_pe_rec.NAME);
157: fnd_msg_pub.ADD;
158: END IF;
159:
160: x_loading_status := 'PLN_NOT_EXIST';
161: RAISE fnd_api.g_exc_error;

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

190: IF p_pe_rec.rev_class_name IS NOT NULL AND p_pe_rec.rev_class_id IS NULL
191: THEN
192: -- Error, check the msg level and add an error message to the
193: -- API message list
194: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
195: THEN
196: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
197: fnd_msg_pub.ADD;
198: END IF;

Line 197: fnd_msg_pub.ADD;

193: -- API message list
194: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
195: THEN
196: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
197: fnd_msg_pub.ADD;
198: END IF;
199:
200: x_loading_status := 'REV_CLASS_NOT_EXIST';
201: RAISE fnd_api.g_exc_error;

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

232: IF (TRUNC (p_pe_rec.rev_uplift_end_date) < TRUNC (p_pe_rec.rev_uplift_start_date))
233: THEN
234: -- Error, check the msg level and add an error message to the
235: -- API message list
236: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
237: THEN
238: fnd_message.set_name ('CN', 'CN_INVALID_DATE_RANGE');
239: fnd_msg_pub.ADD;
240: END IF;

Line 239: fnd_msg_pub.ADD;

235: -- API message list
236: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
237: THEN
238: fnd_message.set_name ('CN', 'CN_INVALID_DATE_RANGE');
239: fnd_msg_pub.ADD;
240: END IF;
241:
242: x_loading_status := 'INVALID_DATE_RANGE';
243: RAISE fnd_api.g_exc_error;

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

310: END IF;
311:
312: -- Error, check the msg level and add an error message to the
313: -- API message list
314: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
315: THEN
316: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_EXISTS');
317: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
318: fnd_message.set_token ('REVENUE_CLASS_NAME', p_pe_rec.rev_class_name);

Line 320: fnd_msg_pub.ADD;

316: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_EXISTS');
317: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
318: fnd_message.set_token ('REVENUE_CLASS_NAME', p_pe_rec.rev_class_name);
319: fnd_message.set_token ('START_DATE', l_date_msg);
320: fnd_msg_pub.ADD;
321: END IF;
322:
323: x_loading_status := 'QUOTA_UPLIFT_EXISTS';
324: RETURN;

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

345: EXCEPTION
346: WHEN fnd_api.g_exc_error
347: THEN
348: x_return_status := fnd_api.g_ret_sts_error;
349: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
350: WHEN fnd_api.g_exc_unexpected_error
351: THEN
352: x_return_status := fnd_api.g_ret_sts_unexp_error;
353: x_loading_status := 'UNEXPECTED_ERR';

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

350: WHEN fnd_api.g_exc_unexpected_error
351: THEN
352: x_return_status := fnd_api.g_ret_sts_unexp_error;
353: x_loading_status := 'UNEXPECTED_ERR';
354: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
355: WHEN OTHERS
356: THEN
357: x_return_status := fnd_api.g_ret_sts_unexp_error;
358: x_loading_status := 'UNEXPECTED_ERR';

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

356: THEN
357: x_return_status := fnd_api.g_ret_sts_unexp_error;
358: x_loading_status := 'UNEXPECTED_ERR';
359:
360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
361: THEN
362: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
363: END IF;
364:

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

358: x_loading_status := 'UNEXPECTED_ERR';
359:
360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
361: THEN
362: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
363: END IF;
364:
365: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
366: END valid_quota_rule_uplift;

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

361: THEN
362: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
363: END IF;
364:
365: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
366: END valid_quota_rule_uplift;
367:
368: -- ----------------------------------------------------------------------------+
369: -- Procedure: Check Valid Update

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

460: IF p_rev_class_name_old IS NOT NULL AND l_rev_class_id_old IS NULL
461: THEN
462: -- Error, check the msg level and add an error message to the
463: -- API message list
464: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
465: THEN
466: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
467: fnd_msg_pub.ADD;
468: END IF;

Line 467: fnd_msg_pub.ADD;

463: -- API message list
464: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
465: THEN
466: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
467: fnd_msg_pub.ADD;
468: END IF;
469:
470: x_loading_status := 'REV_CLASS_NOT_EXIST';
471: RAISE fnd_api.g_exc_error;

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

493: ELSE
494: l_date_msg := p_start_date_old;
495: END IF;
496:
497: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
498: THEN
499: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_NOT_EXIST');
500: fnd_message.set_token ('PLAN_NAME', p_quota_name);
501: fnd_message.set_token ('REVENUE_CLASS_NAME', p_rev_class_name_old);

Line 503: fnd_msg_pub.ADD;

499: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_NOT_EXIST');
500: fnd_message.set_token ('PLAN_NAME', p_quota_name);
501: fnd_message.set_token ('REVENUE_CLASS_NAME', p_rev_class_name_old);
502: fnd_message.set_token ('START_DATE', l_date_msg);
503: fnd_msg_pub.ADD;
504: END IF;
505:
506: x_loading_status := 'QUOTA_RULE_UPLIFT_NOT_EXIST';
507: RAISE fnd_api.g_exc_error;

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

510: -- Chances for duplicate record in the database is
511: -- case 1 if the old quota rule id
512: IF x_quota_rule_uplift_id IS NOT NULL AND x_quota_rule_uplift_id <> l_quota_rule_uplift_id_old
513: THEN
514: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
515: THEN
516: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_EXISTS');
517: fnd_msg_pub.ADD;
518: END IF;

Line 517: fnd_msg_pub.ADD;

513: THEN
514: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
515: THEN
516: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_EXISTS');
517: fnd_msg_pub.ADD;
518: END IF;
519:
520: x_loading_status := 'QUOTA_UPLIFT_EXISTS';
521: RAISE fnd_api.g_exc_error;

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

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
553: THEN
554: x_return_status := fnd_api.g_ret_sts_error;

Line 555: 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
553: THEN
554: x_return_status := fnd_api.g_ret_sts_error;
555: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
556: WHEN fnd_api.g_exc_unexpected_error
557: THEN
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559: x_loading_status := 'UNEXPECTED_ERR';

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

556: WHEN fnd_api.g_exc_unexpected_error
557: THEN
558: x_return_status := fnd_api.g_ret_sts_unexp_error;
559: x_loading_status := 'UNEXPECTED_ERR';
560: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
561: WHEN OTHERS
562: THEN
563: x_return_status := fnd_api.g_ret_sts_unexp_error;
564: x_loading_status := 'UNEXPECTED_ERR';

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

562: THEN
563: x_return_status := fnd_api.g_ret_sts_unexp_error;
564: x_loading_status := 'UNEXPECTED_ERR';
565:
566: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
567: THEN
568: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
569: END IF;
570:

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

564: x_loading_status := 'UNEXPECTED_ERR';
565:
566: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
567: THEN
568: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
569: END IF;
570:
571: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
572: END check_valid_update;

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

567: THEN
568: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
569: END IF;
570:
571: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
572: END check_valid_update;
573:
574: -- ----------------------------------------------------------------------------+
575: --

Line 617: fnd_msg_pub.initialize;

613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: -- +
615: IF fnd_api.to_boolean (p_init_msg_list)
616: THEN
617: fnd_msg_pub.initialize;
618: END IF;
619:
620: -- +
621: -- Initialize API return status to success

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

743: x_loading_status := l_loading_status;
744:
745: IF (x_return_status <> fnd_api.g_ret_sts_success)
746: THEN
747: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
748: THEN
749: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
750: fnd_msg_pub.ADD;
751: END IF;

Line 750: fnd_msg_pub.ADD;

746: THEN
747: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
748: THEN
749: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
750: fnd_msg_pub.ADD;
751: END IF;
752:
753: x_loading_status := 'CN_UPLIFT_UPDATE_NOT_ALLOWED';
754: RAISE fnd_api.g_exc_error;

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

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
775: THEN
776: ROLLBACK TO create_quota_rule_uplift;

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

774: WHEN fnd_api.g_exc_error
775: THEN
776: ROLLBACK TO create_quota_rule_uplift;
777: x_return_status := fnd_api.g_ret_sts_error;
778: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
779: WHEN fnd_api.g_exc_unexpected_error
780: THEN
781: ROLLBACK TO create_quota_rule_uplift;
782: x_loading_status := 'UNEXPECTED_ERR';

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

780: THEN
781: ROLLBACK TO create_quota_rule_uplift;
782: x_loading_status := 'UNEXPECTED_ERR';
783: x_return_status := fnd_api.g_ret_sts_unexp_error;
784: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
785: WHEN OTHERS
786: THEN
787: ROLLBACK TO create_quota_rule_uplift;
788: x_loading_status := 'UNEXPECTED_ERR';

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

787: ROLLBACK TO create_quota_rule_uplift;
788: x_loading_status := 'UNEXPECTED_ERR';
789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790:
791: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
792: THEN
793: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
794: END IF;
795:

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

789: x_return_status := fnd_api.g_ret_sts_unexp_error;
790:
791: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
792: THEN
793: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
794: END IF;
795:
796: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
797: END create_quota_rule_uplift;

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

792: THEN
793: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
794: END IF;
795:
796: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
797: END create_quota_rule_uplift;
798:
799: -- ----------------------------------------------------------------------------+
800: --

Line 842: fnd_msg_pub.initialize;

838: -- Initialize message list if p_init_msg_list is set to TRUE.
839: -- +
840: IF fnd_api.to_boolean (p_init_msg_list)
841: THEN
842: fnd_msg_pub.initialize;
843: END IF;
844:
845: -- +
846: -- Initialize API return status to success

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

947: x_loading_status := l_loading_status;
948: */
949: IF (x_return_status <> fnd_api.g_ret_sts_success)
950: THEN
951: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
952: THEN
953: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
954: fnd_msg_pub.ADD;
955: END IF;

Line 954: fnd_msg_pub.ADD;

950: THEN
951: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
952: THEN
953: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
954: fnd_msg_pub.ADD;
955: END IF;
956:
957: x_loading_status := 'INVALID_DATE_SEQUENCE';
958: RAISE fnd_api.g_exc_error;

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

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
978: THEN
979: ROLLBACK TO update_quota_rule_uplift;

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

977: WHEN fnd_api.g_exc_error
978: THEN
979: ROLLBACK TO update_quota_rule_uplift;
980: x_return_status := fnd_api.g_ret_sts_error;
981: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
982: WHEN fnd_api.g_exc_unexpected_error
983: THEN
984: ROLLBACK TO update_quota_rule_uplift;
985: x_loading_status := 'UNEXPECTED_ERR';

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

983: THEN
984: ROLLBACK TO update_quota_rule_uplift;
985: x_loading_status := 'UNEXPECTED_ERR';
986: x_return_status := fnd_api.g_ret_sts_unexp_error;
987: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
988: WHEN OTHERS
989: THEN
990: ROLLBACK TO update_quota_rule_uplift;
991: x_loading_status := 'UNEXPECTED_ERR';

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

990: ROLLBACK TO update_quota_rule_uplift;
991: x_loading_status := 'UNEXPECTED_ERR';
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:
994: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
995: THEN
996: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
997: END IF;
998:

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

992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:
994: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
995: THEN
996: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
997: END IF;
998:
999: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1000: END update_quota_rule_uplift;

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

995: THEN
996: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
997: END IF;
998:
999: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1000: END update_quota_rule_uplift;
1001:
1002: -- ----------------------------------------------------------------------------+
1003: --

Line 1039: fnd_msg_pub.initialize;

1035:
1036: -- Initialize message list if p_init_msg_list is set to TRUE.
1037: IF fnd_api.to_boolean (p_init_msg_list)
1038: THEN
1039: fnd_msg_pub.initialize;
1040: END IF;
1041:
1042: -- Initialize API return status to success
1043: x_return_status := fnd_api.g_ret_sts_success;

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

1081: END IF;
1082: */
1083: l_date_msg := l_pe_rec.rev_uplift_start_date;
1084:
1085: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1086: THEN
1087: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_NOT_EXIST');
1088: fnd_message.set_token ('PLAN_NAME', l_pe_rec.NAME);
1089: fnd_message.set_token ('REVENUE_CLASS_NAME', l_pe_rec.rev_class_name);

Line 1091: fnd_msg_pub.ADD;

1087: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_NOT_EXIST');
1088: fnd_message.set_token ('PLAN_NAME', l_pe_rec.NAME);
1089: fnd_message.set_token ('REVENUE_CLASS_NAME', l_pe_rec.rev_class_name);
1090: fnd_message.set_token ('START_DATE', l_date_msg);
1091: fnd_msg_pub.ADD;
1092: END IF;
1093:
1094: x_loading_status := 'QUOTA_UPLIFT_NOT_EXIST';
1095: RAISE fnd_api.g_exc_error;

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

1109: x_loading_status := l_loading_status;
1110:
1111: IF (x_return_status <> fnd_api.g_ret_sts_success)
1112: THEN
1113: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1114: THEN
1115: fnd_message.set_name ('CN', 'CN_UPLIFT_DELETE_NOT_ALLOWED');
1116: fnd_msg_pub.ADD;
1117: END IF;

Line 1116: fnd_msg_pub.ADD;

1112: THEN
1113: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1114: THEN
1115: fnd_message.set_name ('CN', 'CN_UPLIFT_DELETE_NOT_ALLOWED');
1116: fnd_msg_pub.ADD;
1117: END IF;
1118:
1119: x_loading_status := 'CN_UPLIFT_DELETE_NOT_ALLOWED';
1120: RAISE fnd_api.g_exc_error;

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

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
1171: THEN
1172: ROLLBACK TO delete_quota_rule_uplift;

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

1170: WHEN fnd_api.g_exc_error
1171: THEN
1172: ROLLBACK TO delete_quota_rule_uplift;
1173: x_return_status := fnd_api.g_ret_sts_error;
1174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1175: WHEN fnd_api.g_exc_unexpected_error
1176: THEN
1177: ROLLBACK TO delete_quota_rule_uplift;
1178: x_loading_status := 'UNEXPECTED_ERR';

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

1176: THEN
1177: ROLLBACK TO delete_quota_rule_uplift;
1178: x_loading_status := 'UNEXPECTED_ERR';
1179: x_return_status := fnd_api.g_ret_sts_unexp_error;
1180: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1181: WHEN OTHERS
1182: THEN
1183: ROLLBACK TO delete_quota_rule_uplift;
1184: x_loading_status := 'UNEXPECTED_ERR';

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

1183: ROLLBACK TO delete_quota_rule_uplift;
1184: x_loading_status := 'UNEXPECTED_ERR';
1185: x_return_status := fnd_api.g_ret_sts_unexp_error;
1186:
1187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1188: THEN
1189: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1190: END IF;
1191:

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

1185: x_return_status := fnd_api.g_ret_sts_unexp_error;
1186:
1187: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1188: THEN
1189: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1190: END IF;
1191:
1192: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1193: END delete_quota_rule_uplift;

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

1188: THEN
1189: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1190: END IF;
1191:
1192: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1193: END delete_quota_rule_uplift;
1194: END cn_quota_rule_uplifts_grp;