DBA Data[Home] [Help]

APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on FND_MESSAGE

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

416:
417: -- role_name must exist in cn_roles
418: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
420: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
421: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
422: fnd_msg_pub.ADD;
423: END IF;
424: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';

Line 421: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);

417: -- role_name must exist in cn_roles
418: IF NOT valid_role_name(p_role_pay_groups_rec.role_name) THEN
419: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
420: fnd_message.set_name('CN', 'CN_RL_ASGN_ROLE_NOT_EXIST');
421: FND_MESSAGE.SET_TOKEN('ROLE_NAME',p_role_pay_groups_rec.role_name);
422: fnd_msg_pub.ADD;
423: END IF;
424: x_loading_status := 'CN_RL_ASGN_ROLE_NOT_EXIST';
425: RAISE fnd_api.g_exc_error;

Line 432: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');

428: END IF;
429: -- pay_group_name must exist in cn_pay_groups
430: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
431: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
432: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
433: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
434: fnd_msg_pub.ADD;
435: END IF;
436: x_loading_status := 'CN_RL_ASGN_PG_NOT_EXIST';

Line 433: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);

429: -- pay_group_name must exist in cn_pay_groups
430: IF NOT valid_pay_groups_name(p_role_pay_groups_rec.pay_groups_name,p_role_pay_groups_rec.org_id) THEN
431: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
432: fnd_message.set_name('CN', 'CN_RL_ASGN_PG_NOT_EXIST');
433: fnd_message.set_token('PAY_GROUP',p_role_pay_groups_rec.pay_groups_name);
434: fnd_msg_pub.ADD;
435: END IF;
436: x_loading_status := 'CN_RL_ASGN_PG_NOT_EXIST';
437: RAISE fnd_api.g_exc_error;

Line 458: fnd_message.set_name('CN', 'CN_INVALID_ROLE_PGRP_ASGN_DT');

454: THEN
455: --Error condition
456: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
457: THEN
458: fnd_message.set_name('CN', 'CN_INVALID_ROLE_PGRP_ASGN_DT');
459: fnd_msg_pub.add;
460: END IF;
461:
462: x_loading_status := 'CN_INVALID_ROLE_PGRP_ASGN_DT';

Line 490: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');

486: THEN
487: --Error condition
488: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
489: THEN
490: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
491: fnd_msg_pub.add;
492: END IF; */
493:
494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

Line 495: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');

491: fnd_msg_pub.add;
492: END IF; */
493:
494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
495: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
496: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);

Line 496: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);

492: END IF; */
493:
494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
495: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
496: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));

Line 497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);

493:
494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
495: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
496: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
501: fnd_message.set_token('START_DATE',l_rec.start_date);

Line 498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);

494: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
495: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
496: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
501: fnd_message.set_token('START_DATE',l_rec.start_date);
502: fnd_message.set_token('END_DATE',l_rec.end_date);

Line 499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);

495: fnd_message.set_name ('CN', 'CN_RL_ROLE_PAY_GROUP_OVERLAP_N');
496: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
501: fnd_message.set_token('START_DATE',l_rec.start_date);
502: fnd_message.set_token('END_DATE',l_rec.end_date);
503: fnd_msg_pub.ADD;

Line 500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));

496: fnd_message.set_token('CURRENT_PAY_GROUP ',p_role_pay_groups_rec.pay_groups_name);
497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
501: fnd_message.set_token('START_DATE',l_rec.start_date);
502: fnd_message.set_token('END_DATE',l_rec.end_date);
503: fnd_msg_pub.ADD;
504: END IF;

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

497: fnd_message.set_token('ROLE_NAME',p_role_pay_groups_rec.role_name);
498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
501: fnd_message.set_token('START_DATE',l_rec.start_date);
502: fnd_message.set_token('END_DATE',l_rec.end_date);
503: fnd_msg_pub.ADD;
504: END IF;
505:

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

498: fnd_message.set_token('ROLE_START_DATE',p_role_pay_groups_rec.start_date);
499: fnd_message.set_token('ROLE_END_DATE',p_role_pay_groups_rec.end_date);
500: FND_MESSAGE.SET_TOKEN('PAY_GROUP_NAME',get_pg_name(l_rec.pay_group_id));
501: fnd_message.set_token('START_DATE',l_rec.start_date);
502: fnd_message.set_token('END_DATE',l_rec.end_date);
503: fnd_msg_pub.ADD;
504: END IF;
505:
506: x_loading_status := 'CN_RL_ROLE_PAY_GROUP_OVERLAP';

Line 530: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');

526: THEN
527: --Error condition
528: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
529: THEN
530: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
531: fnd_msg_pub.add;
532: END IF;
533: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';
534: RAISE FND_API.G_EXC_ERROR;

Line 550: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');

546: THEN
547: --Error condition
548: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
549: THEN
550: fnd_message.set_name('CN', 'CN_OVERLAP_SRP_PGRP_ASGN');
551: fnd_msg_pub.add;
552: END IF;
553:
554: x_loading_status := 'CN_OVERLAP_SRP_PGRP_ASGN';

Line 639: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');

635: p_role_pay_groups_rec.end_date,
636: p_role_pay_groups_rec.org_id);
637: IF (x_role_pay_group_id IS NULL) THEN
638: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
639: FND_MESSAGE.SET_NAME('CN' ,'CN_RL_DEL_ROLE_PLAN_NOT_EXIST');
640: FND_MSG_PUB.Add;
641: END IF;
642: x_loading_status := 'CN_RL_DEL_ROLE_PLAN_NOT_EXIST';
643: RAISE FND_API.G_EXC_ERROR ;