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 CN_API

Line 32: l_quota_rule.revenue_class_id := cn_api.get_rev_class_id (l_quota_rule.revenue_class_name, l_quota_rule.org_id);

28: BEGIN
29: l_quota_rule.plan_element_name := LTRIM (RTRIM (p_quota_name));
30: l_quota_rule.revenue_class_name := LTRIM (RTRIM (p_revenue_class_rec.rev_class_name));
31: l_old_name := LTRIM (RTRIM (p_old_revenue_class_name));
32: l_quota_rule.revenue_class_id := cn_api.get_rev_class_id (l_quota_rule.revenue_class_name, l_quota_rule.org_id);
33:
34: -- API body
35: -- Store the User Input Value into The Local Variable.
36: -- Standard check of p_commit.

Line 39: IF ((cn_api.chk_miss_char_para (p_char_para => l_quota_rule.plan_element_name,

35: -- Store the User Input Value into The Local Variable.
36: -- Standard check of p_commit.
37: --+
38: -- Check if plan element name is missing or null even for Delete the Q Rule
39: IF ((cn_api.chk_miss_char_para (p_char_para => l_quota_rule.plan_element_name,
40: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
41: p_loading_status => l_loading_status,
42: x_loading_status => l_loading_status
43: )

Line 48: ELSIF ((cn_api.chk_null_char_para (p_char_para => l_quota_rule.plan_element_name,

44: ) = fnd_api.g_true
45: )
46: THEN
47: RAISE fnd_api.g_exc_error;
48: ELSIF ((cn_api.chk_null_char_para (p_char_para => l_quota_rule.plan_element_name,
49: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
50: p_loading_status => l_loading_status,
51: x_loading_status => l_loading_status
52: )

Line 60: IF ((cn_api.chk_miss_char_para (p_char_para => l_quota_rule.revenue_class_name,

56: RAISE fnd_api.g_exc_error;
57: END IF;
58:
59: -- Check rev class name is not miss, not null
60: IF ((cn_api.chk_miss_char_para (p_char_para => l_quota_rule.revenue_class_name,
61: p_para_name => cn_chk_plan_element_pkg.g_rev_cls_name,
62: p_loading_status => x_loading_status,
63: x_loading_status => l_loading_status
64: )

Line 69: ELSIF ((cn_api.chk_null_char_para (p_char_para => l_quota_rule.revenue_class_name,

65: ) = fnd_api.g_true
66: )
67: THEN
68: RAISE fnd_api.g_exc_error;
69: ELSIF ((cn_api.chk_null_char_para (p_char_para => l_quota_rule.revenue_class_name,
70: p_obj_name => cn_chk_plan_element_pkg.g_rev_cls_name,
71: p_loading_status => x_loading_status,
72: x_loading_status => l_loading_status
73: )

Line 97: l_quota_rule.revenue_class_id := cn_api.get_rev_class_id (l_quota_rule.revenue_class_name, l_quota_rule.org_id);

93: RAISE fnd_api.g_exc_error;
94: END IF;
95:
96: -- Get Revenue Class ID
97: l_quota_rule.revenue_class_id := cn_api.get_rev_class_id (l_quota_rule.revenue_class_name, l_quota_rule.org_id);
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

Line 116: l_old_revenue_class_id := cn_api.get_rev_class_id (l_old_name, l_quota_rule.org_id);

112: l_quota_rule.quota_rule_id := cn_chk_plan_element_pkg.get_quota_rule_id (l_quota_rule.quota_id, l_quota_rule.revenue_class_id);
113:
114: IF l_old_name IS NOT NULL
115: THEN
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)

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