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;
91: END IF;
92:
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;
91: END IF;
92:
93: RAISE fnd_api.g_exc_error;
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;
107:
108: RAISE fnd_api.g_exc_error;
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;
125:
126: RAISE fnd_api.g_exc_error;
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);
140: fnd_msg_pub.ADD;
141: END IF;
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);
140: fnd_msg_pub.ADD;
141: END IF;
142:
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);
140: fnd_msg_pub.ADD;
141: END IF;
142:
143: RAISE fnd_api.g_exc_error;
196: x_msg_data := fnd_api.g_null_char;
197: x_msg_count := fnd_api.g_null_num;
198: select name into l_temp_old from cn_quotas_v where quota_id = p_quota_rule_new.quota_id;
199: IF (p_operation = 'create') THEN
200: fnd_message.set_name('CN','CNR12_NOTE_PE_PROD_UPDATE');
201: fnd_message.set_token('ELIG_PROD', p_quota_rule_new.revenue_class_name);
202: fnd_message.set_token('PE_NAME', l_temp_old);
203: l_plan_element_id := p_quota_rule_new.quota_id;
204: l_temp_new := 'CN_QUOTAS';
197: x_msg_count := fnd_api.g_null_num;
198: select name into l_temp_old from cn_quotas_v where quota_id = p_quota_rule_new.quota_id;
199: IF (p_operation = 'create') THEN
200: fnd_message.set_name('CN','CNR12_NOTE_PE_PROD_UPDATE');
201: fnd_message.set_token('ELIG_PROD', p_quota_rule_new.revenue_class_name);
202: fnd_message.set_token('PE_NAME', l_temp_old);
203: l_plan_element_id := p_quota_rule_new.quota_id;
204: l_temp_new := 'CN_QUOTAS';
205: END IF;
198: select name into l_temp_old from cn_quotas_v where quota_id = p_quota_rule_new.quota_id;
199: IF (p_operation = 'create') THEN
200: fnd_message.set_name('CN','CNR12_NOTE_PE_PROD_UPDATE');
201: fnd_message.set_token('ELIG_PROD', p_quota_rule_new.revenue_class_name);
202: fnd_message.set_token('PE_NAME', l_temp_old);
203: l_plan_element_id := p_quota_rule_new.quota_id;
204: l_temp_new := 'CN_QUOTAS';
205: END IF;
206: IF (p_operation = 'delete') THEN
203: l_plan_element_id := p_quota_rule_new.quota_id;
204: l_temp_new := 'CN_QUOTAS';
205: END IF;
206: IF (p_operation = 'delete') THEN
207: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ELIGPROD_DELETE');
208: fnd_message.set_token('PROD', p_quota_rule_new.revenue_class_name);
209: fnd_message.set_token('PE_NAME', l_temp_old);
210: l_plan_element_id := p_quota_rule_new.quota_id;
211: l_temp_new := 'CN_QUOTAS';
204: l_temp_new := 'CN_QUOTAS';
205: END IF;
206: IF (p_operation = 'delete') THEN
207: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ELIGPROD_DELETE');
208: fnd_message.set_token('PROD', p_quota_rule_new.revenue_class_name);
209: fnd_message.set_token('PE_NAME', l_temp_old);
210: l_plan_element_id := p_quota_rule_new.quota_id;
211: l_temp_new := 'CN_QUOTAS';
212: END IF;
205: END IF;
206: IF (p_operation = 'delete') THEN
207: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ELIGPROD_DELETE');
208: fnd_message.set_token('PROD', p_quota_rule_new.revenue_class_name);
209: fnd_message.set_token('PE_NAME', l_temp_old);
210: l_plan_element_id := p_quota_rule_new.quota_id;
211: l_temp_new := 'CN_QUOTAS';
212: END IF;
213: IF (p_operation = 'update') THEN
213: IF (p_operation = 'update') THEN
214: select NAME into l_temp_rc_old from cn_revenue_classes where
215: revenue_class_id = p_quota_rule_old.revenue_class_id
216: and org_id = p_quota_rule_old.org_id;
217: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_PROD_CHANGE');
218: fnd_message.set_token('PROD_OLD', l_temp_rc_old);
219: fnd_message.set_token('PROD_NEW', p_quota_rule_new.revenue_class_name);
220: l_plan_element_id := p_quota_rule_new.quota_id;
221: l_temp_new := 'CN_QUOTAS';
214: select NAME into l_temp_rc_old from cn_revenue_classes where
215: revenue_class_id = p_quota_rule_old.revenue_class_id
216: and org_id = p_quota_rule_old.org_id;
217: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_PROD_CHANGE');
218: fnd_message.set_token('PROD_OLD', l_temp_rc_old);
219: fnd_message.set_token('PROD_NEW', p_quota_rule_new.revenue_class_name);
220: l_plan_element_id := p_quota_rule_new.quota_id;
221: l_temp_new := 'CN_QUOTAS';
222: END IF;
215: revenue_class_id = p_quota_rule_old.revenue_class_id
216: and org_id = p_quota_rule_old.org_id;
217: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_PROD_CHANGE');
218: fnd_message.set_token('PROD_OLD', l_temp_rc_old);
219: fnd_message.set_token('PROD_NEW', p_quota_rule_new.revenue_class_name);
220: l_plan_element_id := p_quota_rule_new.quota_id;
221: l_temp_new := 'CN_QUOTAS';
222: END IF;
223: l_note_msg := fnd_message.get;
219: fnd_message.set_token('PROD_NEW', p_quota_rule_new.revenue_class_name);
220: l_plan_element_id := p_quota_rule_new.quota_id;
221: l_temp_new := 'CN_QUOTAS';
222: END IF;
223: l_note_msg := fnd_message.get;
224: jtf_notes_pub.create_note
225: (p_api_version => 1.0,
226: x_return_status => x_return_status,
227: x_msg_count => x_msg_count,
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;
352: END IF;
353:
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;
352: END IF;
353:
354: RAISE fnd_api.g_exc_error;
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;
365: END IF;
366:
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;
365: END IF;
366:
367: RAISE fnd_api.g_exc_error;
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;
383:
384: RAISE fnd_api.g_exc_error;
391: INTO l_rec;
392:
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;
392:
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:
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);
426: fnd_msg_pub.ADD;
427: END IF;
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);
426: fnd_msg_pub.ADD;
427: END IF;
428:
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);
426: fnd_msg_pub.ADD;
427: END IF;
428:
429: RAISE fnd_api.g_exc_error;
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;
441:
442: RAISE fnd_api.g_exc_error;
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;
453: END IF;
454:
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;
453: END IF;
454:
455: RAISE fnd_api.g_exc_error;
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;
465: END IF;
466:
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;
465: END IF;
466:
467: RAISE fnd_api.g_exc_error;
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;
477: END IF;
478:
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;
477: END IF;
478:
479: RAISE fnd_api.g_exc_error;
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'));
489: fnd_message.set_token ('INPUT3', ' ');
490: fnd_message.set_token ('INPUT4', ' ');
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'));
489: fnd_message.set_token ('INPUT3', ' ');
490: fnd_message.set_token ('INPUT4', ' ');
491: fnd_message.set_token ('INPUT5', ' ');
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'));
489: fnd_message.set_token ('INPUT3', ' ');
490: fnd_message.set_token ('INPUT4', ' ');
491: fnd_message.set_token ('INPUT5', ' ');
492: fnd_msg_pub.ADD;
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'));
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;
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'));
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:
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'));
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;
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;
505: END IF;
506:
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;
505: END IF;
506:
507: RAISE fnd_api.g_exc_error;
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'));
517: fnd_msg_pub.ADD;
518: END IF;
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'));
517: fnd_msg_pub.ADD;
518: END IF;
519:
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'));
517: fnd_msg_pub.ADD;
518: END IF;
519:
520: RAISE fnd_api.g_exc_error;
533: THEN
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:
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'));
557: fnd_message.set_token ('INPUT3', cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'));
558: fnd_message.set_token ('INPUT4', ' ');
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'));
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', ' ');
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'));
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;
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'));
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;
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'));
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:
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'));
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;
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;
594:
595: x_loading_status := 'INVALID_DATE_SEQUENCE';
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);
631: fnd_msg_pub.ADD;
632: END IF;
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);
631: fnd_msg_pub.ADD;
632: END IF;
633:
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);
631: fnd_msg_pub.ADD;
632: END IF;
633:
634: RAISE fnd_api.g_exc_error;