DBA Data[Home] [Help]

APPS.CN_QUOTA_RULE_PVT dependencies on FND_MESSAGE

Line 88: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');

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:

Line 89: fnd_message.set_token ('PE_NAME', p_quota_name);

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;

Line 104: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');

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;

Line 122: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');

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;

Line 137: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');

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;

Line 138: fnd_message.set_token ('PLAN_NAME', l_quota_rule.plan_element_name);

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:

Line 139: fnd_message.set_token ('REVENUE_CLASS_NAME', l_old_name);

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;

Line 200: fnd_message.set_name('CN','CNR12_NOTE_PE_PROD_UPDATE');

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';

Line 201: fnd_message.set_token('ELIG_PROD', p_quota_rule_new.revenue_class_name);

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;

Line 202: fnd_message.set_token('PE_NAME', l_temp_old);

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

Line 207: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ELIGPROD_DELETE');

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';

Line 208: fnd_message.set_token('PROD', p_quota_rule_new.revenue_class_name);

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;

Line 209: fnd_message.set_token('PE_NAME', l_temp_old);

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

Line 217: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_PROD_CHANGE');

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';

Line 218: fnd_message.set_token('PROD_OLD', l_temp_rc_old);

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;

Line 219: fnd_message.set_token('PROD_NEW', p_quota_rule_new.revenue_class_name);

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;

Line 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,

Line 349: fnd_message.set_name ('CN', 'CN_INPUT_CANT_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;
352: END IF;
353:

Line 350: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'));

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;

Line 362: fnd_message.set_name ('CN', 'CN_INPUT_CANT_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;
365: END IF;
366:

Line 363: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));

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;

Line 380: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');

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;

Line 395: fnd_message.set_name ('CN', 'CN_INVALID_DATA');

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;

Line 396: fnd_message.set_token ('OBJ_NAME', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));

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:

Line 423: fnd_message.set_name ('CN', '###CN_QUOTA_RULE_NOT_EXIST###');

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;

Line 424: fnd_message.set_token ('PLAN_NAME', p_quota_rule.quota_id);

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:

Line 425: fnd_message.set_token ('REVENUE_CLASS_NAME', p_quota_rule.revenue_class_name);

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;

Line 438: fnd_message.set_name ('CN', 'CN_REV_TARGET_GT_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;
441:
442: RAISE fnd_api.g_exc_error;

Line 450: fnd_message.set_name ('CN', 'CN_INPUT_CANT_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;
453: END IF;
454:

Line 451: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));

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;

Line 462: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

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:

Line 463: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));

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;

Line 474: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

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:

Line 475: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('ORGANIZATION', 'PE_OBJECT_TYPE'));

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;

Line 486: fnd_message.set_name ('CN', 'CN_INCONSISTENT_DATA');

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', ' ');

Line 487: fnd_message.set_token ('INPUT1', cn_api.get_lkup_meaning ('ORGANIZATION', 'PE_OBJECT_TYPE'));

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', ' ');

Line 488: fnd_message.set_token ('INPUT2', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));

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;

Line 489: fnd_message.set_token ('INPUT3', ' ');

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;

Line 490: fnd_message.set_token ('INPUT4', ' ');

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:

Line 491: fnd_message.set_token ('INPUT5', ' ');

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;

Line 502: fnd_message.set_name ('CN', 'CN_INPUT_CANT_NULL');

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:

Line 503: fnd_message.set_token ('INPUT_NAME', cn_api.get_lkup_meaning ('VARIABLES', 'PE_OBJECT_TYPE'));

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;

Line 514: fnd_message.set_name ('CN', 'CN_CANNOT_HAVE_REV_CLASS');

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;

Line 515: fnd_message.set_token ('OBJ_VALUE', 'MANUAL');

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:

Line 516: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (l_rec.incentive_type_code, 'QUOTA_TYPE'));

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;

Line 537: fnd_message.set_name ('CN', 'CN_RECORD_CHANGED');

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:

Line 554: fnd_message.set_name ('CN', 'CN_INCONSISTENT_DATA');

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', ' ');

Line 555: fnd_message.set_token ('INPUT1', cn_api.get_lkup_meaning ('RC_ASSIGN', 'PE_OBJECT_TYPE'));

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', ' ');

Line 556: fnd_message.set_token ('INPUT2', cn_api.get_lkup_meaning ('PE', 'INPUT_TOKEN'));

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;

Line 557: fnd_message.set_token ('INPUT3', cn_api.get_lkup_meaning ('RC', 'INPUT_TOKEN'));

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;

Line 558: fnd_message.set_token ('INPUT4', ' ');

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:

Line 559: fnd_message.set_token ('INPUT5', ' ');

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;

Line 591: fnd_message.set_name ('CN', 'CN_INVALID_DATE_SEQUENCE');

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';

Line 628: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXIST');

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;

Line 629: fnd_message.set_token ('PLAN_NAME', l_rec.NAME);

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:

Line 630: fnd_message.set_token ('REVENUE_CLASS_NAME', p_quota_rule.revenue_class_name);

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;