APPS.CN_ROLE_PMT_PLANS_PVT dependencies on FND_MESSAGE

Line 183: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');

179:
180: -- role_name must exist in cn_roles
181: IF NOT valid_role_name(p_role_pmt_plan_rec.role_name) THEN
182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
183: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
184: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pmt_plan_rec.role_name);
185: fnd_msg_pub.ADD;
186: END IF;
187: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';

Line 184: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pmt_plan_rec.role_name);

180: -- role_name must exist in cn_roles
181: IF NOT valid_role_name(p_role_pmt_plan_rec.role_name) THEN
182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
183: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
184: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pmt_plan_rec.role_name);
185: fnd_msg_pub.ADD;
186: END IF;
187: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
188: RAISE fnd_api.g_exc_error;

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

192:
193: -- pmt_plan_id must exist in cn_pmt_plans
194: IF NOT valid_pmt_plan_id(p_role_pmt_plan_rec.pmt_plan_id, p_role_pmt_plan_rec.org_id) THEN
195: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
196: fnd_message.set_name('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
197: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);
198: fnd_msg_pub.ADD;
199: END IF;
200: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';

Line 197: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);

193: -- pmt_plan_id must exist in cn_pmt_plans
194: IF NOT valid_pmt_plan_id(p_role_pmt_plan_rec.pmt_plan_id, p_role_pmt_plan_rec.org_id) THEN
195: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
196: fnd_message.set_name('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
197: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);
198: fnd_msg_pub.ADD;
199: END IF;
200: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';
201: RAISE fnd_api.g_exc_error;

Line 214: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');

210:
211: IF (l_pp_cur%notfound) THEN
212: -- normally this won't happen as it has been valided previously
213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
214: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
215: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);
216: fnd_msg_pub.ADD;
217: END IF;
218: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';

Line 215: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);

211: IF (l_pp_cur%notfound) THEN
212: -- normally this won't happen as it has been valided previously
213: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
214: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
215: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec.pmt_plan_name);
216: fnd_msg_pub.ADD;
217: END IF;
218: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';
219: CLOSE l_pp_cur;

Line 229: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');

225: p_role_pmt_plan_rec.end_date,
226: l_pp_rec.start_date,
227: l_pp_rec.end_date) THEN
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
229: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
230: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
233: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);

Line 230: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);

226: l_pp_rec.start_date,
227: l_pp_rec.end_date) THEN
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
229: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
230: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
233: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
234: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);

Line 231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);

227: l_pp_rec.end_date) THEN
228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
229: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
230: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
233: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
234: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
235: fnd_msg_pub.ADD;

Line 232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);

228: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
229: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
230: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
233: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
234: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
235: fnd_msg_pub.ADD;
236: END IF;

Line 233: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);

229: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
230: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
233: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
234: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
235: fnd_msg_pub.ADD;
236: END IF;
237: x_loading_status := 'CN_RL_PP_DATE_RANGE_NOT_WITHIN';

Line 234: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);

230: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
231: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
232: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
233: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
234: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
235: fnd_msg_pub.ADD;
236: END IF;
237: x_loading_status := 'CN_RL_PP_DATE_RANGE_NOT_WITHIN';
238: CLOSE l_pp_cur;

Line 247: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');

243: IF ( p_role_pmt_plan_rec.start_date < l_pp_rec.start_date )
244: THEN
245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
246: THEN
247: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
248: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
250: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
251: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);

Line 248: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);

244: THEN
245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
246: THEN
247: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
248: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
250: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
251: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
252: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);

Line 249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);

245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
246: THEN
247: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
248: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
250: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
251: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
252: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
253: fnd_msg_pub.ADD;

Line 250: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);

246: THEN
247: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
248: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
250: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
251: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
252: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
253: fnd_msg_pub.ADD;
254: END IF;

Line 251: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);

247: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
248: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
250: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
251: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
252: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
253: fnd_msg_pub.ADD;
254: END IF;
255:

Line 252: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);

248: FND_MESSAGE.SET_TOKEN('START_DATE',p_role_pmt_plan_rec.start_date);
249: FND_MESSAGE.SET_TOKEN('END_DATE',p_role_pmt_plan_rec.end_date);
250: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
251: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
252: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',p_role_pmt_plan_rec.pmt_plan_name);
253: fnd_msg_pub.ADD;
254: END IF;
255:
256: x_loading_status := 'CN_RL_PP_SD_LESS_THAN_PP_SD';

Line 292: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');

288:
289: THEN
290:
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
292: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
294: fnd_message.set_token('START_DATE',l_rec.start_date);
295: fnd_message.set_token('END_DATE',l_rec.end_date);
296: fnd_msg_pub.ADD;

Line 293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));

289: THEN
290:
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
292: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
294: fnd_message.set_token('START_DATE',l_rec.start_date);
295: fnd_message.set_token('END_DATE',l_rec.end_date);
296: fnd_msg_pub.ADD;
297: END IF;

Line 294: fnd_message.set_token('START_DATE',l_rec.start_date);

290:
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
292: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
294: fnd_message.set_token('START_DATE',l_rec.start_date);
295: fnd_message.set_token('END_DATE',l_rec.end_date);
296: fnd_msg_pub.ADD;
297: END IF;
298: x_loading_status := 'CN_RL_ROLE_PMT_PLAN_OVERLAP';

Line 295: fnd_message.set_token('END_DATE',l_rec.end_date);

291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
292: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
293: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
294: fnd_message.set_token('START_DATE',l_rec.start_date);
295: fnd_message.set_token('END_DATE',l_rec.end_date);
296: fnd_msg_pub.ADD;
297: END IF;
298: x_loading_status := 'CN_RL_ROLE_PMT_PLAN_OVERLAP';
299: RAISE fnd_api.g_exc_error;

Line 412: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');

408: p_role_pmt_plan_rec_old.org_id);
409:
410: IF (x_role_pmt_plan_id_old IS NULL) THEN
411: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
412: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
413: fnd_msg_pub.ADD;
414: END IF;
415: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';
416: RAISE fnd_api.g_exc_error;

Line 470: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');

466: IF (l_old_cur%notfound) THEN
467: -- normally, this should not happen as the existance has
468: -- been validated previously
469: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
470: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
471: fnd_msg_pub.ADD;
472: END IF;
473: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';
474: CLOSE l_old_cur;

Line 489: fnd_message.set_name('CN', 'CN_RL_INVALID_DATE_RANGE');

485: tmp_end_date := p_role_pmt_plan_rec_new.end_date;
486: END IF;
487: IF (tmp_end_date IS NOT NULL) AND (tmp_start_date > tmp_end_date) THEN
488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
489: fnd_message.set_name('CN', 'CN_RL_INVALID_DATE_RANGE');
490: fnd_message.set_token('START_DATE',tmp_start_date);
491: fnd_message.set_token('END_DATE',tmp_end_date);
492: fnd_msg_pub.ADD;
493: END IF;

Line 490: fnd_message.set_token('START_DATE',tmp_start_date);

486: END IF;
487: IF (tmp_end_date IS NOT NULL) AND (tmp_start_date > tmp_end_date) THEN
488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
489: fnd_message.set_name('CN', 'CN_RL_INVALID_DATE_RANGE');
490: fnd_message.set_token('START_DATE',tmp_start_date);
491: fnd_message.set_token('END_DATE',tmp_end_date);
492: fnd_msg_pub.ADD;
493: END IF;
494: x_loading_status := 'CN_RL_INVALID_DATE_RANGE';

Line 491: fnd_message.set_token('END_DATE',tmp_end_date);

487: IF (tmp_end_date IS NOT NULL) AND (tmp_start_date > tmp_end_date) THEN
488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
489: fnd_message.set_name('CN', 'CN_RL_INVALID_DATE_RANGE');
490: fnd_message.set_token('START_DATE',tmp_start_date);
491: fnd_message.set_token('END_DATE',tmp_end_date);
492: fnd_msg_pub.ADD;
493: END IF;
494: x_loading_status := 'CN_RL_INVALID_DATE_RANGE';
495: CLOSE l_old_cur;

Line 506: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');

502: IF (p_role_pmt_plan_rec_new.role_name <> fnd_api.g_miss_char) THEN
503: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec_new.role_name);
504: IF (x_role_id IS NULL) THEN
505: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
506: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
507: fnd_message.set_token('ROLE_NAME',p_role_pmt_plan_rec_new.role_name);
508: fnd_msg_pub.ADD;
509: END IF;
510: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';

Line 507: fnd_message.set_token('ROLE_NAME',p_role_pmt_plan_rec_new.role_name);

503: x_role_id := cn_api.get_role_id(p_role_pmt_plan_rec_new.role_name);
504: IF (x_role_id IS NULL) THEN
505: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
506: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
507: fnd_message.set_token('ROLE_NAME',p_role_pmt_plan_rec_new.role_name);
508: fnd_msg_pub.ADD;
509: END IF;
510: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
511: RAISE fnd_api.g_exc_error;

Line 520: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');

516: IF (l_old_cur%notfound) THEN
517: -- normally, this should not happen as the existance has
518: -- been validated previously
519: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
520: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
521: fnd_msg_pub.ADD;
522: END IF;
523: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';
524: CLOSE l_old_cur;

Line 538: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');

534: IF (p_role_pmt_plan_rec_new.pmt_plan_name <> fnd_api.g_miss_char) THEN
535: x_pmt_plan_id := cn_api.get_pp_id(p_role_pmt_plan_rec_new.pmt_plan_name,p_role_pmt_plan_rec_new.org_id);
536: IF (x_pmt_plan_id IS NULL) THEN
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
538: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
539: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec_new.pmt_plan_name);
540: fnd_msg_pub.ADD;
541: END IF;
542: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';

Line 539: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec_new.pmt_plan_name);

535: x_pmt_plan_id := cn_api.get_pp_id(p_role_pmt_plan_rec_new.pmt_plan_name,p_role_pmt_plan_rec_new.org_id);
536: IF (x_pmt_plan_id IS NULL) THEN
537: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
538: fnd_message.set_name ('CN', 'CN_RL_ASGN_PP_NOT_EXIST');
539: fnd_message.set_token('PMT_PLAN',p_role_pmt_plan_rec_new.pmt_plan_name);
540: fnd_msg_pub.ADD;
541: END IF;
542: x_loading_status := 'CN_RL_ASGN_PP_NOT_EXIST';
543: RAISE fnd_api.g_exc_error;

Line 552: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');

548: IF (l_old_cur%notfound) THEN
549: -- normally, this should not happen as the existance has
550: -- been validated previously
551: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
552: fnd_message.set_name ('CN', 'CN_RL_UPD_ROLE_PP_NOT_EXIST');
553: fnd_msg_pub.ADD;
554: END IF;
555: x_loading_status := 'CN_RL_UPD_ROLE_PP_NOT_EXIST';
556: CLOSE l_old_cur;

Line 580: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');

576: tmp_end_date,
577: l_pp_rec.start_date,
578: l_pp_rec.end_date) THEN
579: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
580: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);

Line 581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);

577: l_pp_rec.start_date,
578: l_pp_rec.end_date) THEN
579: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
580: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));

Line 582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);

578: l_pp_rec.end_date) THEN
579: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
580: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
586: fnd_msg_pub.ADD;

Line 583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);

579: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
580: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
586: fnd_msg_pub.ADD;
587: END IF;

Line 584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);

580: fnd_message.set_name ('CN', 'CN_RL_PP_DATE_RANGE_NOT_WITHIN');
581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
586: fnd_msg_pub.ADD;
587: END IF;
588: x_loading_status := 'CN_RL_PP_DATE_RANGE_NOT_WITHIN';

Line 585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));

581: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
582: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
583: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
584: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
585: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
586: fnd_msg_pub.ADD;
587: END IF;
588: x_loading_status := 'CN_RL_PP_DATE_RANGE_NOT_WITHIN';
589: CLOSE l_pp_cur;

Line 598: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');

594: IF ( tmp_start_date < l_pp_rec.start_date )
595: THEN
596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
597: THEN
598: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);

Line 599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);

595: THEN
596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
597: THEN
598: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));

Line 600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);

596: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
597: THEN
598: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
604: fnd_msg_pub.ADD;

Line 601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);

597: THEN
598: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
604: fnd_msg_pub.ADD;
605: END IF;

Line 602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);

598: fnd_message.set_name ('CN', 'CN_RL_PP_SD_LESS_THAN_PP_SD');
599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
604: fnd_msg_pub.ADD;
605: END IF;
606:

Line 603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));

599: FND_MESSAGE.SET_TOKEN('START_DATE',tmp_start_date);
600: FND_MESSAGE.SET_TOKEN('END_DATE',tmp_end_date);
601: FND_MESSAGE.SET_TOKEN('PP_START_DATE',l_pp_rec.start_date);
602: FND_MESSAGE.SET_TOKEN('PP_END_DATE',l_pp_rec.end_date);
603: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(x_pmt_plan_id));
604: fnd_msg_pub.ADD;
605: END IF;
606:
607: x_loading_status := 'CN_RL_PP_SD_LESS_THAN_PP_SD';

Line 626: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');

622: l_rec.end_date,
623: tmp_start_date,
624: tmp_end_date) THEN
625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
626: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
628: fnd_message.set_token('START_DATE',l_rec.start_date);
629: fnd_message.set_token('END_DATE',l_rec.end_date);
630: fnd_msg_pub.ADD;

Line 627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));

623: tmp_start_date,
624: tmp_end_date) THEN
625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
626: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
628: fnd_message.set_token('START_DATE',l_rec.start_date);
629: fnd_message.set_token('END_DATE',l_rec.end_date);
630: fnd_msg_pub.ADD;
631: END IF;

Line 628: fnd_message.set_token('START_DATE',l_rec.start_date);

624: tmp_end_date) THEN
625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
626: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
628: fnd_message.set_token('START_DATE',l_rec.start_date);
629: fnd_message.set_token('END_DATE',l_rec.end_date);
630: fnd_msg_pub.ADD;
631: END IF;
632: x_loading_status := 'CN_RL_ROLE_PMT_PLAN_OVERLAP';

Line 629: fnd_message.set_token('END_DATE',l_rec.end_date);

625: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
626: fnd_message.set_name ('CN', 'CN_RL_ROLE_PMT_PLAN_OVERLAP');
627: FND_MESSAGE.SET_TOKEN('PMT_PLAN_NAME',cn_api.get_pp_name(l_rec.pmt_plan_id));
628: fnd_message.set_token('START_DATE',l_rec.start_date);
629: fnd_message.set_token('END_DATE',l_rec.end_date);
630: fnd_msg_pub.ADD;
631: END IF;
632: x_loading_status := 'CN_RL_ROLE_PMT_PLAN_OVERLAP';
633: RAISE fnd_api.g_exc_error;

Line 739: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PP_NOT_EXIST');

735: p_role_pmt_plan_rec.end_date,
736: p_role_pmt_plan_rec.org_id);*/
737: IF (x_role_pmt_plan_id IS NULL) THEN
738: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
739: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PP_NOT_EXIST');
740: FND_MSG_PUB.Add;
741: END IF;
742: x_loading_status := 'CN_RL_DEL_ROLE_PP_NOT_EXIST';
743: RAISE FND_API.G_EXC_ERROR ;