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 729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

725: x_loading_status := l_loading_status;
726:
727: IF (x_return_status <> fnd_api.g_ret_sts_success)
728: THEN
729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
730: THEN
731: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
732: fnd_msg_pub.ADD;
733: END IF;

Line 732: fnd_msg_pub.ADD;

728: THEN
729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
730: THEN
731: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
732: fnd_msg_pub.ADD;
733: END IF;
734:
735: x_loading_status := 'CN_UPLIFT_UPDATE_NOT_ALLOWED';
736: RAISE fnd_api.g_exc_error;

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

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
757: THEN
758: ROLLBACK TO create_quota_rule_uplift;

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

756: WHEN fnd_api.g_exc_error
757: THEN
758: ROLLBACK TO create_quota_rule_uplift;
759: x_return_status := fnd_api.g_ret_sts_error;
760: 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_unexpected_error
762: THEN
763: ROLLBACK TO create_quota_rule_uplift;
764: x_loading_status := 'UNEXPECTED_ERR';

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

762: THEN
763: ROLLBACK TO create_quota_rule_uplift;
764: x_loading_status := 'UNEXPECTED_ERR';
765: x_return_status := fnd_api.g_ret_sts_unexp_error;
766: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
767: WHEN OTHERS
768: THEN
769: ROLLBACK TO create_quota_rule_uplift;
770: x_loading_status := 'UNEXPECTED_ERR';

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

769: ROLLBACK TO create_quota_rule_uplift;
770: x_loading_status := 'UNEXPECTED_ERR';
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772:
773: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
774: THEN
775: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
776: END IF;
777:

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

771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772:
773: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
774: THEN
775: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
776: END IF;
777:
778: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
779: END 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: THEN
775: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
776: END IF;
777:
778: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
779: END create_quota_rule_uplift;
780:
781: -- ----------------------------------------------------------------------------+
782: --

Line 824: fnd_msg_pub.initialize;

820: -- Initialize message list if p_init_msg_list is set to TRUE.
821: -- +
822: IF fnd_api.to_boolean (p_init_msg_list)
823: THEN
824: fnd_msg_pub.initialize;
825: END IF;
826:
827: -- +
828: -- Initialize API return status to success

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

929: x_loading_status := l_loading_status;
930: */
931: IF (x_return_status <> fnd_api.g_ret_sts_success)
932: THEN
933: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
934: THEN
935: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
936: fnd_msg_pub.ADD;
937: END IF;

Line 936: fnd_msg_pub.ADD;

932: THEN
933: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
934: THEN
935: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
936: fnd_msg_pub.ADD;
937: END IF;
938:
939: x_loading_status := 'INVALID_DATE_SEQUENCE';
940: RAISE fnd_api.g_exc_error;

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

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
960: THEN
961: ROLLBACK TO update_quota_rule_uplift;

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

959: WHEN fnd_api.g_exc_error
960: THEN
961: ROLLBACK TO update_quota_rule_uplift;
962: x_return_status := fnd_api.g_ret_sts_error;
963: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
964: WHEN fnd_api.g_exc_unexpected_error
965: THEN
966: ROLLBACK TO update_quota_rule_uplift;
967: x_loading_status := 'UNEXPECTED_ERR';

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

965: THEN
966: ROLLBACK TO update_quota_rule_uplift;
967: x_loading_status := 'UNEXPECTED_ERR';
968: x_return_status := fnd_api.g_ret_sts_unexp_error;
969: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
970: WHEN OTHERS
971: THEN
972: ROLLBACK TO update_quota_rule_uplift;
973: x_loading_status := 'UNEXPECTED_ERR';

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

972: ROLLBACK TO update_quota_rule_uplift;
973: x_loading_status := 'UNEXPECTED_ERR';
974: x_return_status := fnd_api.g_ret_sts_unexp_error;
975:
976: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
977: THEN
978: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
979: END IF;
980:

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

974: x_return_status := fnd_api.g_ret_sts_unexp_error;
975:
976: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
977: THEN
978: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
979: END IF;
980:
981: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
982: END 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: THEN
978: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
979: END IF;
980:
981: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
982: END update_quota_rule_uplift;
983:
984: -- ----------------------------------------------------------------------------+
985: --

Line 1021: fnd_msg_pub.initialize;

1017:
1018: -- Initialize message list if p_init_msg_list is set to TRUE.
1019: IF fnd_api.to_boolean (p_init_msg_list)
1020: THEN
1021: fnd_msg_pub.initialize;
1022: END IF;
1023:
1024: -- Initialize API return status to success
1025: x_return_status := fnd_api.g_ret_sts_success;

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

1063: END IF;
1064: */
1065: l_date_msg := l_pe_rec.rev_uplift_start_date;
1066:
1067: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1068: THEN
1069: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_NOT_EXIST');
1070: fnd_message.set_token ('PLAN_NAME', l_pe_rec.NAME);
1071: fnd_message.set_token ('REVENUE_CLASS_NAME', l_pe_rec.rev_class_name);

Line 1073: fnd_msg_pub.ADD;

1069: fnd_message.set_name ('CN', 'CN_QUOTA_UPLIFT_NOT_EXIST');
1070: fnd_message.set_token ('PLAN_NAME', l_pe_rec.NAME);
1071: fnd_message.set_token ('REVENUE_CLASS_NAME', l_pe_rec.rev_class_name);
1072: fnd_message.set_token ('START_DATE', l_date_msg);
1073: fnd_msg_pub.ADD;
1074: END IF;
1075:
1076: x_loading_status := 'QUOTA_UPLIFT_NOT_EXIST';
1077: RAISE fnd_api.g_exc_error;

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

1091: x_loading_status := l_loading_status;
1092:
1093: IF (x_return_status <> fnd_api.g_ret_sts_success)
1094: THEN
1095: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1096: THEN
1097: fnd_message.set_name ('CN', 'CN_UPLIFT_DELETE_NOT_ALLOWED');
1098: fnd_msg_pub.ADD;
1099: END IF;

Line 1098: fnd_msg_pub.ADD;

1094: THEN
1095: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1096: THEN
1097: fnd_message.set_name ('CN', 'CN_UPLIFT_DELETE_NOT_ALLOWED');
1098: fnd_msg_pub.ADD;
1099: END IF;
1100:
1101: x_loading_status := 'CN_UPLIFT_DELETE_NOT_ALLOWED';
1102: RAISE fnd_api.g_exc_error;

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

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
1153: THEN
1154: ROLLBACK TO delete_quota_rule_uplift;

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

1152: WHEN fnd_api.g_exc_error
1153: THEN
1154: ROLLBACK TO delete_quota_rule_uplift;
1155: x_return_status := fnd_api.g_ret_sts_error;
1156: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1157: WHEN fnd_api.g_exc_unexpected_error
1158: THEN
1159: ROLLBACK TO delete_quota_rule_uplift;
1160: x_loading_status := 'UNEXPECTED_ERR';

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

1158: THEN
1159: ROLLBACK TO delete_quota_rule_uplift;
1160: x_loading_status := 'UNEXPECTED_ERR';
1161: x_return_status := fnd_api.g_ret_sts_unexp_error;
1162: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1163: WHEN OTHERS
1164: THEN
1165: ROLLBACK TO delete_quota_rule_uplift;
1166: x_loading_status := 'UNEXPECTED_ERR';

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

1165: ROLLBACK TO delete_quota_rule_uplift;
1166: x_loading_status := 'UNEXPECTED_ERR';
1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168:
1169: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1170: THEN
1171: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1172: END IF;
1173:

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

1167: x_return_status := fnd_api.g_ret_sts_unexp_error;
1168:
1169: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1170: THEN
1171: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1172: END IF;
1173:
1174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1175: END 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: THEN
1171: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1172: END IF;
1173:
1174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1175: END delete_quota_rule_uplift;
1176: END cn_quota_rule_uplifts_grp;