121: FROM cn_srp_roles
122: WHERE srp_role_id = p_srp_role_id
123: AND salesrep_id = l_salesrep_id)
124: AND language = USERENV('LANG');
125: fnd_message.set_name('CN', 'CN_SRP_OUTSIDE_PAYGRP_DATE');
126: FND_MESSAGE.SET_TOKEN('SALES_REP_NAME', l_salesrep_name);
127: FND_MESSAGE.SET_TOKEN('ROLE_NAME', l_role_name);
128: fnd_msg_pub.ADD;
129: END IF;
122: WHERE srp_role_id = p_srp_role_id
123: AND salesrep_id = l_salesrep_id)
124: AND language = USERENV('LANG');
125: fnd_message.set_name('CN', 'CN_SRP_OUTSIDE_PAYGRP_DATE');
126: FND_MESSAGE.SET_TOKEN('SALES_REP_NAME', l_salesrep_name);
127: FND_MESSAGE.SET_TOKEN('ROLE_NAME', l_role_name);
128: fnd_msg_pub.ADD;
129: END IF;
130: RAISE FND_API.G_EXC_ERROR ;
123: AND salesrep_id = l_salesrep_id)
124: AND language = USERENV('LANG');
125: fnd_message.set_name('CN', 'CN_SRP_OUTSIDE_PAYGRP_DATE');
126: FND_MESSAGE.SET_TOKEN('SALES_REP_NAME', l_salesrep_name);
127: FND_MESSAGE.SET_TOKEN('ROLE_NAME', l_role_name);
128: fnd_msg_pub.ADD;
129: END IF;
130: RAISE FND_API.G_EXC_ERROR ;
131: END IF;
439:
440: -- role_name must exist in cn_roles
441: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
443: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
444: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
445: fnd_msg_pub.ADD;
446: END IF;
447: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
440: -- role_name must exist in cn_roles
441: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
443: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
444: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
445: fnd_msg_pub.ADD;
446: END IF;
447: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
448: RAISE fnd_api.g_exc_error;
451: END IF;
452: -- pay_group_name must exist in cn_pay_groups
453: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
455: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
456: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
457: fnd_msg_pub.ADD;
458: END IF;
459: x_loading_status := 'CN_RL_ASGN_PG_NOT_EXIST';
452: -- pay_group_name must exist in cn_pay_groups
453: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
455: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
456: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
457: fnd_msg_pub.ADD;
458: END IF;
459: x_loading_status := 'CN_RL_ASGN_PG_NOT_EXIST';
460: RAISE fnd_api.g_exc_error;
477: THEN
478: --Error condition
479: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
480: THEN
481: fnd_message.set_name('CN', 'CN_INVALID_ROLE_PGRP_ASGN_DT');
482: fnd_msg_pub.add;
483: END IF;
484:
485: x_loading_status := 'CN_INVALID_ROLE_PGRP_ASGN_DT';
509: THEN
510: --Error condition
511: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
512: THEN
513: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
514: fnd_msg_pub.add;
515: END IF; */
516:
517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
514: fnd_msg_pub.add;
515: END IF; */
516:
517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
518: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
519: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
520: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
515: END IF; */
516:
517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
518: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
519: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
520: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
523: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
516:
517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
518: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
519: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
520: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
523: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
524: fnd_message.set_token('START_DATE',l_rec.start_date);
517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
518: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
519: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
520: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
523: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
524: fnd_message.set_token('START_DATE',l_rec.start_date);
525: fnd_message.set_token('END_DATE',l_rec.end_date);
518: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
519: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
520: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
523: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
524: fnd_message.set_token('START_DATE',l_rec.start_date);
525: fnd_message.set_token('END_DATE',l_rec.end_date);
526: fnd_msg_pub.ADD;
519: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
520: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
523: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
524: fnd_message.set_token('START_DATE',l_rec.start_date);
525: fnd_message.set_token('END_DATE',l_rec.end_date);
526: fnd_msg_pub.ADD;
527: END IF;
520: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
523: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
524: fnd_message.set_token('START_DATE',l_rec.start_date);
525: fnd_message.set_token('END_DATE',l_rec.end_date);
526: fnd_msg_pub.ADD;
527: END IF;
528:
521: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
522: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
523: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
524: fnd_message.set_token('START_DATE',l_rec.start_date);
525: fnd_message.set_token('END_DATE',l_rec.end_date);
526: fnd_msg_pub.ADD;
527: END IF;
528:
529: x_loading_status := 'CN_RL_ROLE_PAY_GROUP_OVERLAP';
549: THEN
550: --Error condition
551: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
552: THEN
553: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
554: fnd_msg_pub.add;
555: END IF;
556: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
557: RAISE FND_API.G_EXC_ERROR;
569: THEN
570: --Error condition
571: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
572: THEN
573: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
574: fnd_msg_pub.add;
575: END IF;
576:
577: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
658: p_role_pay_groups_rec.end_date,
659: p_role_pay_groups_rec.org_id);
660: IF (x_role_pay_group_id IS NULL) THEN
661: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
662: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
663: FND_MSG_PUB.Add;
664: END IF;
665: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
666: RAISE FND_API.G_EXC_ERROR ;