APPS.CN_QUOTA_RULES_GRP dependencies on CN_API

Line 34: l_pe_rec.rev_class_id := cn_api.get_rev_class_id (l_pe_rec.rev_class_name,p_revenue_class_rec.org_id);

30: x_loading_status := p_loading_status;
31: l_pe_rec.NAME := LTRIM (RTRIM (p_quota_name));
32: l_pe_rec.org_id := p_revenue_class_rec.org_id;
33: l_pe_rec.rev_class_name := LTRIM (RTRIM (p_revenue_class_rec.rev_class_name));
34: l_pe_rec.rev_class_id := cn_api.get_rev_class_id (l_pe_rec.rev_class_name,p_revenue_class_rec.org_id);
35:
36: -- Get the Plan Information for further use.
37: BEGIN
38: SELECT quota_id, quota_type_code, incentive_type_code, credit_type_id

Line 100: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.NAME,

96:
97: -- API body
98: -- check for required data in Quotas.
99: -- Check MISS and NULL ( Revenue class Name, Quota Name )
100: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.NAME,
101: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
102: p_loading_status => x_loading_status,
103: x_loading_status => l_loading_status
104: )

Line 109: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.NAME,

105: ) = fnd_api.g_true
106: )
107: THEN
108: RAISE fnd_api.g_exc_error;
109: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.NAME,
110: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
111: p_loading_status => x_loading_status,
112: x_loading_status => l_loading_status
113: )

Line 121: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.rev_class_name,

117: RAISE fnd_api.g_exc_error;
118: END IF;
119:
120: -- Check rev class name is not miss, not null
121: IF ((cn_api.chk_miss_char_para (p_char_para => p_pe_rec.rev_class_name,
122: p_para_name => cn_chk_plan_element_pkg.g_rev_cls_name,
123: p_loading_status => x_loading_status,
124: x_loading_status => l_loading_status
125: )

Line 130: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.rev_class_name,

126: ) = fnd_api.g_true
127: )
128: THEN
129: RAISE fnd_api.g_exc_error;
130: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_pe_rec.rev_class_name,
131: p_obj_name => cn_chk_plan_element_pkg.g_rev_cls_name,
132: p_loading_status => x_loading_status,
133: x_loading_status => l_loading_status
134: )

Line 150: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));

146: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
147: THEN
148: fnd_message.set_name ('CN', 'CN_CANNOT_HAVE_REV_CLASS');
149: fnd_message.set_token ('OBJ_VALUE', 'MANUAL');
150: fnd_message.set_token ('PLAN_TYPE', cn_api.get_lkup_meaning (p_pe_rec.quota_type_code, 'QUOTA_TYPE'));
151: fnd_message.set_token ('TOKEN1', NULL);
152: fnd_message.set_token ('TOKEN2', NULL);
153: fnd_message.set_token ('TOKEN3', NULL);
154: fnd_msg_pub.ADD;

Line 253: x_rev_class_id_old := cn_api.get_rev_class_id (p_rev_class_name_old,p_new_pe_rec.org_id);

249: -- Initialize API return status to success
250: x_return_status := fnd_api.g_ret_sts_success;
251: x_loading_status := p_loading_status;
252: -- get old revenue class id using old revenue class name
253: x_rev_class_id_old := cn_api.get_rev_class_id (p_rev_class_name_old,p_new_pe_rec.org_id);
254:
255: -- Old revenue class exists and valid in the database
256: IF p_rev_class_name_old IS NULL
257: THEN

Line 539: l_meaning := cn_api.get_lkup_meaning (p_trx_factor_rec_tbl (i).trx_type, 'TRX TYPES');

535: FOR i IN p_trx_factor_rec_tbl.FIRST .. p_trx_factor_rec_tbl.LAST
536: LOOP
537: IF (p_trx_factor_rec_tbl.EXISTS (i)) AND (p_trx_factor_rec_tbl (i).rev_class_name = l_pe_rec.rev_class_name)
538: THEN
539: l_meaning := cn_api.get_lkup_meaning (p_trx_factor_rec_tbl (i).trx_type, 'TRX TYPES');
540:
541: IF l_meaning IS NULL
542: THEN
543: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

Line 917: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name,

913: -- Store the User Input Value into The Local Variable.
914: -- Standard check of p_commit.
915: --+
916: -- Check if plan element name is missing or null even for Delete the Q Rule
917: IF ((cn_api.chk_miss_char_para (p_char_para => p_quota_name,
918: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
919: p_loading_status => x_loading_status,
920: x_loading_status => l_loading_status
921: )

Line 926: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,

922: ) = fnd_api.g_true
923: )
924: THEN
925: RAISE fnd_api.g_exc_error;
926: ELSIF ((cn_api.chk_null_char_para (p_char_para => p_quota_name,
927: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
928: p_loading_status => x_loading_status,
929: x_loading_status => l_loading_status
930: )

Line 960: l_rev_rec.revenue_class_id := cn_api.get_rev_class_id (p_revenue_class_rec_tbl (i).rev_class_name,p_revenue_class_rec_tbl (i).org_id);

956: THEN
957: FOR i IN 1 .. p_revenue_class_rec_tbl.COUNT
958: LOOP
959: -- Get Revenue Class ID
960: l_rev_rec.revenue_class_id := cn_api.get_rev_class_id (p_revenue_class_rec_tbl (i).rev_class_name,p_revenue_class_rec_tbl (i).org_id);
961:
962: -- Raise an Error if the Revenue Class iD is Null and Name IS not NUll
963: IF l_rev_rec.revenue_class_id IS NULL AND p_revenue_class_rec_tbl (i).rev_class_name IS NOT NULL
964: THEN