DBA Data[Home] [Help]

APPS.CN_QUOTA_RULES_GRP dependencies on FND_MESSAGE

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

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:

Line 48: fnd_message.set_token ('PE_NAME', l_pe_rec.NAME);

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

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

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

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

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

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 151: fnd_message.set_token ('TOKEN1', NULL);

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;

Line 152: fnd_message.set_token ('TOKEN2', NULL);

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:

Line 153: fnd_message.set_token ('TOKEN3', NULL);

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

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

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

Line 196: fnd_message.set_name ('CN', 'PLN_QUOTA_REV_EXISTS');

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;

Line 197: fnd_message.set_token ('PLAN_NAME', p_pe_rec.NAME);

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:

Line 198: fnd_message.set_token ('REVENUE_CLASS_NAME', p_pe_rec.rev_class_name);

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

Line 260: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');

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

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

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

Line 291: fnd_message.set_name ('CN', 'CN_REV_CLASS_NOT_ASSIGNED');

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

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

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;

Line 313: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);

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:

Line 314: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);

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

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

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;

Line 333: fnd_message.set_token ('PLAN_NAME', p_new_pe_rec.NAME);

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:

Line 334: fnd_message.set_token ('REVENUE_CLASS_NAME', p_new_pe_rec.rev_class_name);

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

Line 545: fnd_message.set_name ('CN', 'CN_TRX_TYPE_NOT_EXISTS');

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

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

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:

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

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

Line 967: fnd_message.set_name ('CN', 'CN_REV_CLASS_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';

Line 982: fnd_message.set_name ('CN', 'CN_QUOTA_RULE_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;

Line 983: fnd_message.set_token ('PLAN_NAME', p_quota_name);

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:

Line 984: fnd_message.set_token ('REVENUE_CLASS_NAME', p_revenue_class_rec_tbl (i).rev_class_name);

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