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

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

82:
83: -- Raise an Error If quota id is null but name is not null
84: IF l_quota_rule.quota_id IS NULL AND l_quota_rule.plan_element_name IS NOT NULL
85: THEN
86: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
87: THEN
88: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
89: fnd_message.set_token ('PE_NAME', p_quota_name);
90: fnd_msg_pub.ADD;

Line 90: fnd_msg_pub.ADD;

86: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
87: THEN
88: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
89: fnd_message.set_token ('PE_NAME', p_quota_name);
90: fnd_msg_pub.ADD;
91: END IF;
92:
93: RAISE fnd_api.g_exc_error;
94: END IF;

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

98:
99: -- Raise an Error if the Revenue Class iD is Null and Name IS not NUll
100: IF l_quota_rule.revenue_class_id IS NULL AND l_quota_rule.revenue_class_name IS NOT NULL
101: THEN
102: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
103: THEN
104: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
105: fnd_msg_pub.ADD;
106: END IF;

Line 105: fnd_msg_pub.ADD;

101: THEN
102: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
103: THEN
104: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
105: fnd_msg_pub.ADD;
106: END IF;
107:
108: RAISE fnd_api.g_exc_error;
109: END IF;

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

116: l_old_revenue_class_id := cn_api.get_rev_class_id (l_old_name, l_quota_rule.org_id);
117:
118: IF l_old_revenue_class_id IS NULL
119: THEN
120: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
121: THEN
122: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
123: fnd_msg_pub.ADD;
124: END IF;

Line 123: fnd_msg_pub.ADD;

119: THEN
120: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
121: THEN
122: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
123: fnd_msg_pub.ADD;
124: END IF;
125:
126: RAISE fnd_api.g_exc_error;
127: END IF;

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

131: p_rev_class_id => l_old_revenue_class_id);
132:
133: IF l_old_quota_rule_id IS NULL
134: THEN
135: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
136: THEN
137: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
138: fnd_message.set_token ('PLAN_NAME', l_quota_rule.plan_element_name);
139: fnd_message.set_token ('REVENUE_CLASS_NAME', l_old_name);

Line 140: fnd_msg_pub.ADD;

136: THEN
137: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
138: fnd_message.set_token ('PLAN_NAME', l_quota_rule.plan_element_name);
139: fnd_message.set_token ('REVENUE_CLASS_NAME', l_old_name);
140: fnd_msg_pub.ADD;
141: END IF;
142:
143: RAISE fnd_api.g_exc_error;
144: END IF;

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

237: EXCEPTION
238: WHEN fnd_api.g_exc_error
239: THEN
240: x_return_status := fnd_api.g_ret_sts_error;
241: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
242: WHEN fnd_api.g_exc_unexpected_error
243: THEN
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

241: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
242: WHEN fnd_api.g_exc_unexpected_error
243: THEN
244: x_return_status := fnd_api.g_ret_sts_unexp_error;
245: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
246: WHEN OTHERS
247: THEN
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

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

245: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
246: WHEN OTHERS
247: THEN
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
250: THEN
251: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
252: END IF;
253: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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

247: THEN
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
250: THEN
251: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
252: END IF;
253: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
254:
255: END add_system_note;

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

249: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
250: THEN
251: fnd_msg_pub.add_exc_msg (g_pkg_name, 'add_system_note');
252: END IF;
253: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
254:
255: END add_system_note;
256:
257:

Line 338: fnd_msg_pub.initialize;

334:
335: -- Initialize message list if p_init_msg_list is set to TRUE.
336: IF fnd_api.to_boolean (p_init_msg_list)
337: THEN
338: fnd_msg_pub.initialize;
339: END IF;
340:
341: -- init the return status
342: x_return_status := fnd_api.g_ret_sts_success;

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

343:
344: -- revenue class cannot be null
345: IF p_quota_rule.revenue_class_id IS NULL
346: THEN
347: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
348: THEN
349: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
350: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'));
351: fnd_msg_pub.ADD;

Line 351: fnd_msg_pub.ADD;

347: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
348: THEN
349: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
350: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'));
351: fnd_msg_pub.ADD;
352: END IF;
353:
354: RAISE fnd_api.g_exc_error;
355: END IF;

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

356:
357: -- quota_id cannot be null
358: IF p_quota_rule.quota_id IS NULL
359: THEN
360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
361: THEN
362: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
363: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));
364: fnd_msg_pub.ADD;

Line 364: fnd_msg_pub.ADD;

360: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
361: THEN
362: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
363: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));
364: fnd_msg_pub.ADD;
365: END IF;
366:
367: RAISE fnd_api.g_exc_error;
368: END IF;

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

374: WHERE revenue_class_id = p_quota_rule.revenue_class_id;
375: EXCEPTION
376: WHEN NO_DATA_FOUND
377: THEN
378: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
379: THEN
380: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
381: fnd_msg_pub.ADD;
382: END IF;

Line 381: fnd_msg_pub.ADD;

377: THEN
378: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
379: THEN
380: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
381: fnd_msg_pub.ADD;
382: END IF;
383:
384: RAISE fnd_api.g_exc_error;
385: END;

Line 397: fnd_msg_pub.ADD;

393: IF quota_csr%NOTFOUND
394: THEN
395: fnd_message.set_name ('CN', 'CN_INVALID_DATA');
396: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));
397: fnd_msg_pub.ADD;
398:
399: CLOSE quota_csr;
400:
401: RAISE fnd_api.g_exc_error;

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

417: WHERE quota_rule_id = p_quota_rule.quota_rule_id;
418: EXCEPTION
419: WHEN NO_DATA_FOUND
420: THEN
421: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
422: THEN
423: fnd_message.set_name ('CN', '###CN_QUOTA_RULE_NOT_EXIST###');
424: fnd_message.set_token ('PLAN_NAME', p_quota_rule.quota_id);
425: fnd_message.set_token ('REVENUE_CLASS_NAME', p_quota_rule.revenue_class_name);

Line 426: fnd_msg_pub.ADD;

422: THEN
423: fnd_message.set_name ('CN', '###CN_QUOTA_RULE_NOT_EXIST###');
424: fnd_message.set_token ('PLAN_NAME', p_quota_rule.quota_id);
425: fnd_message.set_token ('REVENUE_CLASS_NAME', p_quota_rule.revenue_class_name);
426: fnd_msg_pub.ADD;
427: END IF;
428:
429: RAISE fnd_api.g_exc_error;
430: END;

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

432: ELSE
433: -- target, payment_amount and performance_goal cannot be null or less than zero
434: IF p_quota_rule.target < 0
435: THEN
436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
437: THEN
438: fnd_message.set_name ('CN', 'CN_REV_TARGET_GT_ZERO');
439: fnd_msg_pub.ADD;
440: END IF;

Line 439: fnd_msg_pub.ADD;

435: THEN
436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
437: THEN
438: fnd_message.set_name ('CN', 'CN_REV_TARGET_GT_ZERO');
439: fnd_msg_pub.ADD;
440: END IF;
441:
442: RAISE fnd_api.g_exc_error;
443: END IF;

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

444:
445: -- 1. name can not be null
446: IF (p_quota_rule.target IS NULL)
447: THEN
448: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
449: THEN
450: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
451: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));
452: fnd_msg_pub.ADD;

Line 452: fnd_msg_pub.ADD;

448: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
449: THEN
450: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
451: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));
452: fnd_msg_pub.ADD;
453: END IF;
454:
455: RAISE fnd_api.g_exc_error;
456: END IF;

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

456: END IF;
457:
458: IF (p_quota_rule.payment_amount IS NULL)
459: THEN
460: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
461: THEN
462: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
463: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));
464: fnd_msg_pub.ADD;

Line 464: fnd_msg_pub.ADD;

460: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
461: THEN
462: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
463: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));
464: fnd_msg_pub.ADD;
465: END IF;
466:
467: RAISE fnd_api.g_exc_error;
468: END IF;

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

468: END IF;
469:
470: IF (p_quota_rule.org_id IS NULL)
471: THEN
472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
473: THEN
474: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
475: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('ORGANIZATION', 'PE_OBJECT_TYPE'));
476: fnd_msg_pub.ADD;

Line 476: fnd_msg_pub.ADD;

472: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
473: THEN
474: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
475: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('ORGANIZATION', 'PE_OBJECT_TYPE'));
476: fnd_msg_pub.ADD;
477: END IF;
478:
479: RAISE fnd_api.g_exc_error;
480: END IF;

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

480: END IF;
481:
482: IF (p_quota_rule.org_id <> l_rec.org_id)
483: THEN
484: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
485: THEN
486: fnd_message.set_name ('CN', 'CN_INCONSISTENT_DATA');
487: fnd_message.set_token ('INPUT1', cn_api.get_lkup_meaning ('ORGANIZATION', 'PE_OBJECT_TYPE'));
488: fnd_message.set_token ('INPUT2', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));

Line 492: fnd_msg_pub.ADD;

488: fnd_message.set_token ('INPUT2', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));
489: fnd_message.set_token ('INPUT3', ' ');
490: fnd_message.set_token ('INPUT4', ' ');
491: fnd_message.set_token ('INPUT5', ' ');
492: fnd_msg_pub.ADD;
493: END IF;
494:
495: RAISE fnd_api.g_exc_error;
496: END IF;

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

496: END IF;
497:
498: IF (p_quota_rule.performance_goal IS NULL)
499: THEN
500: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
501: THEN
502: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
503: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));
504: fnd_msg_pub.ADD;

Line 504: fnd_msg_pub.ADD;

500: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
501: THEN
502: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');
503: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));
504: fnd_msg_pub.ADD;
505: END IF;
506:
507: RAISE fnd_api.g_exc_error;
508: END IF;

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

508: END IF;
509:
510: IF l_rec.incentive_type_code NOT IN ('COMMISSION', 'BONUS')
511: THEN
512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
513: THEN
514: fnd_message.set_name ('CN', 'CN_CANNOT_HAVE_REV_CLASS');
515: fnd_message.set_token ('OBJ_VALUE', 'MANUAL');
516: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (l_rec.incentive_type_code, 'QUOTA_TYPE'));

Line 517: fnd_msg_pub.ADD;

513: THEN
514: fnd_message.set_name ('CN', 'CN_CANNOT_HAVE_REV_CLASS');
515: fnd_message.set_token ('OBJ_VALUE', 'MANUAL');
516: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (l_rec.incentive_type_code, 'QUOTA_TYPE'));
517: fnd_msg_pub.ADD;
518: END IF;
519:
520: RAISE fnd_api.g_exc_error;
521: END IF;

Line 538: fnd_msg_pub.ADD;

534: -- check the object version number
535: IF NVL (p_quota_rule.object_version_number, -1) <> p_old_quota_rule.object_version_number
536: THEN
537: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');
538: fnd_msg_pub.ADD;
539: RAISE fnd_api.g_exc_error;
540: END IF;
541:
542: -- cannot change the planelement assignment of a quota_rule_assignment

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

548: AND qr.quota_rule_id = p_quota_rule.quota_rule_id;
549:
550: IF l_same_pe = 0
551: THEN
552: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
553: THEN
554: fnd_message.set_name ('CN', 'CN_INCONSISTENT_DATA');
555: fnd_message.set_token ('INPUT1', cn_api.get_lkup_meaning ('RC_ASSIGN', 'PE_OBJECT_TYPE'));
556: fnd_message.set_token ('INPUT2', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));

Line 560: fnd_msg_pub.ADD;

556: fnd_message.set_token ('INPUT2', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));
557: fnd_message.set_token ('INPUT3', cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'));
558: fnd_message.set_token ('INPUT4', ' ');
559: fnd_message.set_token ('INPUT5', ' ');
560: fnd_msg_pub.ADD;
561: END IF;
562:
563: RAISE fnd_api.g_exc_error;
564: END IF;

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

585: x_loading_status := l_loading_status;
586:
587: IF (x_return_status <> fnd_api.g_ret_sts_success)
588: THEN
589: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
590: THEN
591: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
592: fnd_msg_pub.ADD;
593: END IF;

Line 592: fnd_msg_pub.ADD;

588: THEN
589: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
590: THEN
591: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');
592: fnd_msg_pub.ADD;
593: END IF;
594:
595: x_loading_status := 'INVALID_DATE_SEQUENCE';
596: RAISE fnd_api.g_exc_error;

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

622: END IF; -- if update end
623:
624: IF l_temp_count <> 0
625: THEN
626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
627: THEN
628: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXIST');
629: fnd_message.set_token ('PLAN_NAME', l_rec.NAME);
630: fnd_message.set_token ('REVENUE_CLASS_NAME', p_quota_rule.revenue_class_name);

Line 631: fnd_msg_pub.ADD;

627: THEN
628: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXIST');
629: fnd_message.set_token ('PLAN_NAME', l_rec.NAME);
630: fnd_message.set_token ('REVENUE_CLASS_NAME', p_quota_rule.revenue_class_name);
631: fnd_msg_pub.ADD;
632: END IF;
633:
634: RAISE fnd_api.g_exc_error;
635: END IF;

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

651: -- for any other p_quota_rule.rev_class_id already saved in the database
652: -- for the p_quota_rule.quota_id
653: IF (NOT l_ret_val)
654: THEN
655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
656: THEN
657: fnd_msg_pub.ADD;
658: END IF;
659:

Line 657: fnd_msg_pub.ADD;

653: IF (NOT l_ret_val)
654: THEN
655: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
656: THEN
657: fnd_msg_pub.ADD;
658: END IF;
659:
660: RAISE fnd_api.g_exc_error;
661: END IF;

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

662: END IF;
663: END IF;
664:
665: -- Standard call to get message count and if count is 1, get message info.
666: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
667: EXCEPTION
668: WHEN fnd_api.g_exc_error
669: THEN
670: ROLLBACK TO validate_quota_rule;

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

668: WHEN fnd_api.g_exc_error
669: THEN
670: ROLLBACK TO validate_quota_rule;
671: x_return_status := fnd_api.g_ret_sts_error;
672: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
673: WHEN fnd_api.g_exc_unexpected_error
674: THEN
675: ROLLBACK TO validate_quota_rule;
676: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

673: WHEN fnd_api.g_exc_unexpected_error
674: THEN
675: ROLLBACK TO validate_quota_rule;
676: x_return_status := fnd_api.g_ret_sts_unexp_error;
677: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
678: WHEN OTHERS
679: THEN
680: ROLLBACK TO validate_quota_rule;
681: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

679: THEN
680: ROLLBACK TO validate_quota_rule;
681: x_return_status := fnd_api.g_ret_sts_unexp_error;
682:
683: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
684: THEN
685: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
686: END IF;
687:

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

681: x_return_status := fnd_api.g_ret_sts_unexp_error;
682:
683: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
684: THEN
685: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
686: END IF;
687:
688: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
689: END validate_quota_rule;

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

684: THEN
685: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
686: END IF;
687:
688: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
689: END validate_quota_rule;
690:
691: -- Start of comments
692: -- API name : Create_Quota_Rule

Line 739: fnd_msg_pub.initialize;

735:
736: -- Initialize message list if p_init_msg_list is set to TRUE.
737: IF fnd_api.to_boolean (p_init_msg_list)
738: THEN
739: fnd_msg_pub.initialize;
740: END IF;
741:
742: -- Initialize API return status to success
743: x_return_status := fnd_api.g_ret_sts_success;

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

814: COMMIT WORK;
815: END IF;
816:
817: -- Standard call to get message count and if count is 1, get message info.
818: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
819: EXCEPTION
820: WHEN fnd_api.g_exc_error
821: THEN
822: ROLLBACK TO create_quota_rule;

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

820: WHEN fnd_api.g_exc_error
821: THEN
822: ROLLBACK TO create_quota_rule;
823: x_return_status := fnd_api.g_ret_sts_error;
824: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
825: WHEN fnd_api.g_exc_unexpected_error
826: THEN
827: ROLLBACK TO create_quota_rule;
828: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

825: WHEN fnd_api.g_exc_unexpected_error
826: THEN
827: ROLLBACK TO create_quota_rule;
828: x_return_status := fnd_api.g_ret_sts_unexp_error;
829: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
830: WHEN OTHERS
831: THEN
832: ROLLBACK TO create_quota_rule;
833: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

831: THEN
832: ROLLBACK TO create_quota_rule;
833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834:
835: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
836: THEN
837: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
838: END IF;
839:

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

833: x_return_status := fnd_api.g_ret_sts_unexp_error;
834:
835: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
836: THEN
837: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
838: END IF;
839:
840: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
841: END create_quota_rule;

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

836: THEN
837: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
838: END IF;
839:
840: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
841: END create_quota_rule;
842:
843: -- Start of comments
844: -- API name : Create_Quota_Rules

Line 903: fnd_msg_pub.initialize;

899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: -- +
901: IF fnd_api.to_boolean (p_init_msg_list)
902: THEN
903: fnd_msg_pub.initialize;
904: END IF;
905:
906: -- +
907: -- Initialize API return status to success

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

999:
1000: --+
1001: -- Standard call to get message count and if count is 1, get message info.
1002: --+
1003: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1004: EXCEPTION
1005: WHEN fnd_api.g_exc_error
1006: THEN
1007: ROLLBACK TO create_quota_rules;

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

1005: WHEN fnd_api.g_exc_error
1006: THEN
1007: ROLLBACK TO create_quota_rules;
1008: x_return_status := fnd_api.g_ret_sts_error;
1009: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1010: WHEN fnd_api.g_exc_unexpected_error
1011: THEN
1012: ROLLBACK TO create_quota_rules;
1013: x_loading_status := 'UNEXPECTED_ERR';

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

1011: THEN
1012: ROLLBACK TO create_quota_rules;
1013: x_loading_status := 'UNEXPECTED_ERR';
1014: x_return_status := fnd_api.g_ret_sts_unexp_error;
1015: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1016: WHEN OTHERS
1017: THEN
1018: ROLLBACK TO create_quota_rules;
1019: x_loading_status := 'UNEXPECTED_ERR';

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

1018: ROLLBACK TO create_quota_rules;
1019: x_loading_status := 'UNEXPECTED_ERR';
1020: x_return_status := fnd_api.g_ret_sts_unexp_error;
1021:
1022: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1023: THEN
1024: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1025: END IF;
1026:

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

1020: x_return_status := fnd_api.g_ret_sts_unexp_error;
1021:
1022: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1023: THEN
1024: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1025: END IF;
1026:
1027: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1028: END create_quota_rules;

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

1023: THEN
1024: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1025: END IF;
1026:
1027: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1028: END create_quota_rules;
1029:
1030: -- Start of comments
1031: -- API name : Update_Quota_Rule

Line 1086: fnd_msg_pub.initialize;

1082:
1083: -- Initialize message list if p_init_msg_list is set to TRUE.
1084: IF fnd_api.to_boolean (p_init_msg_list)
1085: THEN
1086: fnd_msg_pub.initialize;
1087: END IF;
1088:
1089: -- Initialize API return status to success
1090: x_return_status := fnd_api.g_ret_sts_success;

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

1171: COMMIT WORK;
1172: END IF;
1173:
1174: -- Standard call to get message count and if count is 1, get message info.
1175: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1176: EXCEPTION
1177: WHEN fnd_api.g_exc_error
1178: THEN
1179: ROLLBACK TO update_quota_rule;

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

1177: WHEN fnd_api.g_exc_error
1178: THEN
1179: ROLLBACK TO update_quota_rule;
1180: x_return_status := fnd_api.g_ret_sts_error;
1181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1182: WHEN fnd_api.g_exc_unexpected_error
1183: THEN
1184: ROLLBACK TO update_quota_rule;
1185: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1182: WHEN fnd_api.g_exc_unexpected_error
1183: THEN
1184: ROLLBACK TO update_quota_rule;
1185: x_return_status := fnd_api.g_ret_sts_unexp_error;
1186: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1187: WHEN OTHERS
1188: THEN
1189: ROLLBACK TO update_quota_rule;
1190: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1188: THEN
1189: ROLLBACK TO update_quota_rule;
1190: x_return_status := fnd_api.g_ret_sts_unexp_error;
1191:
1192: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1193: THEN
1194: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1195: END IF;
1196:

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

1190: x_return_status := fnd_api.g_ret_sts_unexp_error;
1191:
1192: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1193: THEN
1194: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1195: END IF;
1196:
1197: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1198: END update_quota_rule;

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

1193: THEN
1194: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1195: END IF;
1196:
1197: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1198: END update_quota_rule;
1199:
1200: --|-------------------------------------------------------------------------+
1201: --| Procedure Name: Update_Quota_Rules

Line 1243: fnd_msg_pub.initialize;

1239: -- Initialize message list if p_init_msg_list is set to TRUE.
1240: -- +
1241: IF fnd_api.to_boolean (p_init_msg_list)
1242: THEN
1243: fnd_msg_pub.initialize;
1244: END IF;
1245:
1246: -- +
1247: -- Initialize API return status to success

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

1324:
1325: --+
1326: -- Standard call to get message count and if count is 1, get message info.
1327: --+
1328: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1329: EXCEPTION
1330: WHEN fnd_api.g_exc_error
1331: THEN
1332: ROLLBACK TO update_quota_rules;

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

1330: WHEN fnd_api.g_exc_error
1331: THEN
1332: ROLLBACK TO update_quota_rules;
1333: x_return_status := fnd_api.g_ret_sts_error;
1334: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1335: WHEN fnd_api.g_exc_unexpected_error
1336: THEN
1337: ROLLBACK TO update_quota_rules;
1338: x_loading_status := 'UNEXPECTED_ERR';

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

1336: THEN
1337: ROLLBACK TO update_quota_rules;
1338: x_loading_status := 'UNEXPECTED_ERR';
1339: x_return_status := fnd_api.g_ret_sts_unexp_error;
1340: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1341: WHEN OTHERS
1342: THEN
1343: ROLLBACK TO update_quota_rules;
1344: x_loading_status := 'UNEXPECTED_ERR';

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

1343: ROLLBACK TO update_quota_rules;
1344: x_loading_status := 'UNEXPECTED_ERR';
1345: x_return_status := fnd_api.g_ret_sts_unexp_error;
1346:
1347: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1348: THEN
1349: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1350: END IF;
1351:

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

1345: x_return_status := fnd_api.g_ret_sts_unexp_error;
1346:
1347: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1348: THEN
1349: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1350: END IF;
1351:
1352: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1353: END update_quota_rules;

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

1348: THEN
1349: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1350: END IF;
1351:
1352: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1353: END update_quota_rules;
1354:
1355: -- Start of comments
1356: -- API name : Delete_Quota_Rule

Line 1405: fnd_msg_pub.initialize;

1401:
1402: -- Initialize message list if p_init_msg_list is set to TRUE.
1403: IF fnd_api.to_boolean (p_init_msg_list)
1404: THEN
1405: fnd_msg_pub.initialize;
1406: END IF;
1407:
1408: -- Initialize API return status to success
1409: x_return_status := fnd_api.g_ret_sts_success;

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

1448: COMMIT WORK;
1449: END IF;
1450:
1451: -- Standard call to get message count and if count is 1, get message info.
1452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1453: EXCEPTION
1454: WHEN fnd_api.g_exc_error
1455: THEN
1456: ROLLBACK TO delete_quota_rule;

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

1454: WHEN fnd_api.g_exc_error
1455: THEN
1456: ROLLBACK TO delete_quota_rule;
1457: x_return_status := fnd_api.g_ret_sts_error;
1458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1459: WHEN fnd_api.g_exc_unexpected_error
1460: THEN
1461: ROLLBACK TO delete_quota_rule;
1462: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1459: WHEN fnd_api.g_exc_unexpected_error
1460: THEN
1461: ROLLBACK TO delete_quota_rule;
1462: x_return_status := fnd_api.g_ret_sts_unexp_error;
1463: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1464: WHEN OTHERS
1465: THEN
1466: ROLLBACK TO delete_quota_rule;
1467: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1465: THEN
1466: ROLLBACK TO delete_quota_rule;
1467: x_return_status := fnd_api.g_ret_sts_unexp_error;
1468:
1469: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1470: THEN
1471: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1472: END IF;
1473:

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

1467: x_return_status := fnd_api.g_ret_sts_unexp_error;
1468:
1469: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1470: THEN
1471: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1472: END IF;
1473:
1474: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1475: END delete_quota_rule;

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

1470: THEN
1471: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1472: END IF;
1473:
1474: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1475: END delete_quota_rule;
1476:
1477: --|-------------------------------------------------------------------------+
1478: --| Procedure Name: Delete_Quota_Rules

Line 1511: fnd_msg_pub.initialize;

1507:
1508: -- Initialize message list if p_init_msg_list is set to TRUE.
1509: IF fnd_api.to_boolean (p_init_msg_list)
1510: THEN
1511: fnd_msg_pub.initialize;
1512: END IF;
1513:
1514: -- Initialize API return status to success
1515: x_return_status := fnd_api.g_ret_sts_success;

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

1554:
1555: --+
1556: -- Standard call to get message count and if count is 1, get message info.
1557: --+
1558: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1559: EXCEPTION
1560: WHEN fnd_api.g_exc_error
1561: THEN
1562: ROLLBACK TO delete_plan_element;

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

1560: WHEN fnd_api.g_exc_error
1561: THEN
1562: ROLLBACK TO delete_plan_element;
1563: x_return_status := fnd_api.g_ret_sts_error;
1564: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1565: WHEN fnd_api.g_exc_unexpected_error
1566: THEN
1567: ROLLBACK TO delete_plan_element;
1568: x_loading_status := 'UNEXPECTED_ERR';

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

1566: THEN
1567: ROLLBACK TO delete_plan_element;
1568: x_loading_status := 'UNEXPECTED_ERR';
1569: x_return_status := fnd_api.g_ret_sts_unexp_error;
1570: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1571: WHEN OTHERS
1572: THEN
1573: ROLLBACK TO delete_plan_element;
1574: x_loading_status := 'UNEXPECTED_ERR';

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

1573: ROLLBACK TO delete_plan_element;
1574: x_loading_status := 'UNEXPECTED_ERR';
1575: x_return_status := fnd_api.g_ret_sts_unexp_error;
1576:
1577: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1578: THEN
1579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1580: END IF;
1581:

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

1575: x_return_status := fnd_api.g_ret_sts_unexp_error;
1576:
1577: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1578: THEN
1579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1580: END IF;
1581:
1582: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1583: END delete_quota_rules;

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

1578: THEN
1579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1580: END IF;
1581:
1582: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
1583: END delete_quota_rules;
1584: END cn_quota_rule_pvt;