43: WHEN NO_DATA_FOUND
44: THEN
45: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
46: THEN
47: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
48: fnd_message.set_token ('PE_NAME', l_pe_rec.NAME);
49: fnd_msg_pub.ADD;
50: END IF;
51:
44: THEN
45: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
46: THEN
47: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
48: fnd_message.set_token ('PE_NAME', l_pe_rec.NAME);
49: fnd_msg_pub.ADD;
50: END IF;
51:
52: x_loading_status := 'CN_PLN_NOT_EXIST';
144: IF (p_pe_rec.incentive_type_code NOT IN ('COMMISSION', 'BONUS'))
145: THEN
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);
145: THEN
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);
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;
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;
155: END IF;
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;
155: END IF;
156:
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;
155: END IF;
156:
157: x_loading_status := 'CN_CANNOT_HAVE_REV_CLASS';
164: IF p_pe_rec.rev_class_id IS NULL AND p_pe_rec.rev_class_name IS NOT NULL
165: THEN
166: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
167: THEN
168: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
169: fnd_msg_pub.ADD;
170: END IF;
171:
172: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
192: -- Error, check the msg level and add an error message to the
193: -- API message list
194: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
195: THEN
196: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXISTS');
197: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
198: fnd_message.set_token ('REVENUE_CLASS_NAME', p_pe_rec.rev_class_name);
199: fnd_msg_pub.ADD;
200: END IF;
193: -- API message list
194: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
195: THEN
196: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXISTS');
197: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
198: fnd_message.set_token ('REVENUE_CLASS_NAME', p_pe_rec.rev_class_name);
199: fnd_msg_pub.ADD;
200: END IF;
201:
194: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
195: THEN
196: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXISTS');
197: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);
198: fnd_message.set_token ('REVENUE_CLASS_NAME', p_pe_rec.rev_class_name);
199: fnd_msg_pub.ADD;
200: END IF;
201:
202: x_loading_status := 'PLN_QUOTA_REV_EXISTS';
256: IF p_rev_class_name_old IS NULL
257: THEN
258: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
259: THEN
260: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
261: fnd_msg_pub.ADD;
262: END IF;
263:
264: x_loading_status := 'REV_CLASS_NOT_ASSIGNED';
268: IF x_rev_class_id_old IS NULL AND p_rev_class_name_old IS NOT NULL
269: THEN
270: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
271: THEN
272: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
273: fnd_msg_pub.ADD;
274: END IF;
275:
276: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
287: IF l_same_pe = 0
288: THEN
289: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
290: THEN
291: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');
292: fnd_msg_pub.ADD;
293: END IF;
294:
295: x_loading_status := 'REV_CLASS_NOT_ASSIGNED';
308: IF l_same_pe > 0
309: THEN
310: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
311: THEN
312: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXIST');
313: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
314: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);
315: fnd_msg_pub.ADD;
316: END IF;
309: THEN
310: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
311: THEN
312: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXIST');
313: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
314: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);
315: fnd_msg_pub.ADD;
316: END IF;
317:
310: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
311: THEN
312: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXIST');
313: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
314: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);
315: fnd_msg_pub.ADD;
316: END IF;
317:
318: x_loading_status := 'PLN_QUOTA_REV_EXISTS';
328: IF x_quota_rule_id_old IS NULL
329: THEN
330: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
331: THEN
332: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
333: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
334: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);
335: fnd_msg_pub.ADD;
336: END IF;
329: THEN
330: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
331: THEN
332: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
333: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
334: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);
335: fnd_msg_pub.ADD;
336: END IF;
337:
330: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
331: THEN
332: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
333: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);
334: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);
335: fnd_msg_pub.ADD;
336: END IF;
337:
338: x_loading_status := 'QUOTA_RULE_NOT_EXIST';
541: IF l_meaning IS NULL
542: THEN
543: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
544: THEN
545: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXISTS');
546: fnd_msg_pub.ADD;
547: END IF;
548:
549: x_loading_status := 'CN_TRX_TYPE_NOT_EXISTS';
941: IF l_rev_rec.quota_id IS NULL AND p_quota_name IS NOT NULL
942: THEN
943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
944: THEN
945: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
946: fnd_message.set_token ('PE_NAME', p_quota_name);
947: fnd_msg_pub.ADD;
948: END IF;
949:
942: THEN
943: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
944: THEN
945: fnd_message.set_name ('CN', 'CN_PLN_NOT_EXIST');
946: fnd_message.set_token ('PE_NAME', p_quota_name);
947: fnd_msg_pub.ADD;
948: END IF;
949:
950: x_loading_status := 'CN_PLN_NOT_EXIST';
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
965: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
966: THEN
967: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_EXIST');
968: fnd_msg_pub.ADD;
969: END IF;
970:
971: x_loading_status := 'CN_REV_CLASS_NOT_EXIST';
978: IF l_rev_rec.quota_rule_id IS NULL
979: THEN
980: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
981: THEN
982: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
983: fnd_message.set_token ('PLAN_NAME', p_quota_name);
984: fnd_message.set_token ('REVENUE_CLASS_NAME', p_revenue_class_rec_tbl (i).rev_class_name);
985: fnd_msg_pub.ADD;
986: END IF;
979: THEN
980: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
981: THEN
982: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
983: fnd_message.set_token ('PLAN_NAME', p_quota_name);
984: fnd_message.set_token ('REVENUE_CLASS_NAME', p_revenue_class_rec_tbl (i).rev_class_name);
985: fnd_msg_pub.ADD;
986: END IF;
987:
980: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
981: THEN
982: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_NOT_EXIST');
983: fnd_message.set_token ('PLAN_NAME', p_quota_name);
984: fnd_message.set_token ('REVENUE_CLASS_NAME', p_revenue_class_rec_tbl (i).rev_class_name);
985: fnd_msg_pub.ADD;
986: END IF;
987:
988: x_loading_status := 'QUOTA_RULE_NOT_EXIST';