eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on FND_MESSAGE

Line 1820: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');

1816: OPEN c_asg;
1817: FETCH c_asg INTO l_asg;
1818: IF c_asg%NOTFOUND THEN
1819: CLOSE c_asg;
1820: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
1821: fnd_message.set_token('PROC', l_proc);
1822: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
1823: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
1824: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 1821: fnd_message.set_token('PROC', l_proc);

1817: FETCH c_asg INTO l_asg;
1818: IF c_asg%NOTFOUND THEN
1819: CLOSE c_asg;
1820: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
1821: fnd_message.set_token('PROC', l_proc);
1822: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
1823: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
1824: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
1825: RAISE ben_manage_life_events.g_record_error;

Line 1822: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

1818: IF c_asg%NOTFOUND THEN
1819: CLOSE c_asg;
1820: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
1821: fnd_message.set_token('PROC', l_proc);
1822: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
1823: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
1824: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
1825: RAISE ben_manage_life_events.g_record_error;
1826: END IF;

Line 1823: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

1819: CLOSE c_asg;
1820: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
1821: fnd_message.set_token('PROC', l_proc);
1822: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
1823: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
1824: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
1825: RAISE ben_manage_life_events.g_record_error;
1826: END IF;
1827: CLOSE c_asg;

Line 1824: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

1820: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
1821: fnd_message.set_token('PROC', l_proc);
1822: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
1823: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
1824: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
1825: RAISE ben_manage_life_events.g_record_error;
1826: END IF;
1827: CLOSE c_asg;
1828: if g_debug then

Line 3695: fnd_message.set_name('BEN', 'BEN_91458_DENRR_MODE_INVALID');

3691: -- iRec - Added mode 'I'
3692: --
3693: IF p_run_mode NOT IN ('L', 'C', 'U','W','V', 'M','G', 'I','D') THEN
3694: --
3695: fnd_message.set_name('BEN', 'BEN_91458_DENRR_MODE_INVALID');
3696: fnd_message.set_token('PROC', l_proc);
3697: fnd_message.set_token('MODE', p_run_mode);
3698: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3699: RAISE ben_manage_life_events.g_record_error;

Line 3696: fnd_message.set_token('PROC', l_proc);

3692: --
3693: IF p_run_mode NOT IN ('L', 'C', 'U','W','V', 'M','G', 'I','D') THEN
3694: --
3695: fnd_message.set_name('BEN', 'BEN_91458_DENRR_MODE_INVALID');
3696: fnd_message.set_token('PROC', l_proc);
3697: fnd_message.set_token('MODE', p_run_mode);
3698: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3699: RAISE ben_manage_life_events.g_record_error;
3700: --

Line 3697: fnd_message.set_token('MODE', p_run_mode);

3693: IF p_run_mode NOT IN ('L', 'C', 'U','W','V', 'M','G', 'I','D') THEN
3694: --
3695: fnd_message.set_name('BEN', 'BEN_91458_DENRR_MODE_INVALID');
3696: fnd_message.set_token('PROC', l_proc);
3697: fnd_message.set_token('MODE', p_run_mode);
3698: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3699: RAISE ben_manage_life_events.g_record_error;
3700: --
3701: END IF;

Line 3698: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

3694: --
3695: fnd_message.set_name('BEN', 'BEN_91458_DENRR_MODE_INVALID');
3696: fnd_message.set_token('PROC', l_proc);
3697: fnd_message.set_token('MODE', p_run_mode);
3698: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3699: RAISE ben_manage_life_events.g_record_error;
3700: --
3701: END IF;
3702: --

Line 3791: fnd_message.set_name('BEN', 'BEN_91737_ENRT_REQ_MISS_PARM');

3787: --
3788: if g_debug then
3789: hr_utility.set_location('error', 19);
3790: end if;
3791: fnd_message.set_name('BEN', 'BEN_91737_ENRT_REQ_MISS_PARM');
3792: fnd_message.set_token('PROC', l_proc);
3793: fnd_message.set_token('MODE', p_run_mode);
3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 3792: fnd_message.set_token('PROC', l_proc);

3788: if g_debug then
3789: hr_utility.set_location('error', 19);
3790: end if;
3791: fnd_message.set_name('BEN', 'BEN_91737_ENRT_REQ_MISS_PARM');
3792: fnd_message.set_token('PROC', l_proc);
3793: fnd_message.set_token('MODE', p_run_mode);
3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3796: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));

Line 3793: fnd_message.set_token('MODE', p_run_mode);

3789: hr_utility.set_location('error', 19);
3790: end if;
3791: fnd_message.set_name('BEN', 'BEN_91737_ENRT_REQ_MISS_PARM');
3792: fnd_message.set_token('PROC', l_proc);
3793: fnd_message.set_token('MODE', p_run_mode);
3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3796: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
3797: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

Line 3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

3790: end if;
3791: fnd_message.set_name('BEN', 'BEN_91737_ENRT_REQ_MISS_PARM');
3792: fnd_message.set_token('PROC', l_proc);
3793: fnd_message.set_token('MODE', p_run_mode);
3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3796: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
3797: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3798: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

Line 3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

3791: fnd_message.set_name('BEN', 'BEN_91737_ENRT_REQ_MISS_PARM');
3792: fnd_message.set_token('PROC', l_proc);
3793: fnd_message.set_token('MODE', p_run_mode);
3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3796: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
3797: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3798: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
3799: RAISE ben_manage_life_events.g_record_error;

Line 3796: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));

3792: fnd_message.set_token('PROC', l_proc);
3793: fnd_message.set_token('MODE', p_run_mode);
3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3796: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
3797: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3798: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
3799: RAISE ben_manage_life_events.g_record_error;
3800: --

Line 3797: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

3793: fnd_message.set_token('MODE', p_run_mode);
3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3796: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
3797: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3798: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
3799: RAISE ben_manage_life_events.g_record_error;
3800: --
3801: END IF;

Line 3798: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

3794: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
3795: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3796: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
3797: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3798: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
3799: RAISE ben_manage_life_events.g_record_error;
3800: --
3801: END IF;
3802: --

Line 3827: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');

3823: FETCH c_asg INTO l_rec_assignment_id, l_rec_organization_id;
3824: IF c_asg%NOTFOUND THEN
3825: CLOSE c_asg;
3826: hr_utility.set_location('error', 20);
3827: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
3828: fnd_message.set_token('PROC', l_proc);
3829: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3830: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
3831: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 3828: fnd_message.set_token('PROC', l_proc);

3824: IF c_asg%NOTFOUND THEN
3825: CLOSE c_asg;
3826: hr_utility.set_location('error', 20);
3827: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
3828: fnd_message.set_token('PROC', l_proc);
3829: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3830: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
3831: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3832: RAISE ben_manage_life_events.g_record_error;

Line 3829: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

3825: CLOSE c_asg;
3826: hr_utility.set_location('error', 20);
3827: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
3828: fnd_message.set_token('PROC', l_proc);
3829: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3830: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
3831: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3832: RAISE ben_manage_life_events.g_record_error;
3833: END IF;

Line 3830: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

3826: hr_utility.set_location('error', 20);
3827: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
3828: fnd_message.set_token('PROC', l_proc);
3829: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3830: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
3831: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3832: RAISE ben_manage_life_events.g_record_error;
3833: END IF;
3834: CLOSE c_asg;

Line 3831: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

3827: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
3828: fnd_message.set_token('PROC', l_proc);
3829: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3830: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
3831: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3832: RAISE ben_manage_life_events.g_record_error;
3833: END IF;
3834: CLOSE c_asg;
3835: hr_utility.set_location('close c_asg: ' || l_proc, 10);

Line 4215: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');

4211: l_plip_eed,
4212: l_plip_ordr_num;
4213: IF c_plip_info%NOTFOUND THEN
4214: --
4215: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
4216: fnd_message.set_token('PROC', l_proc);
4217: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4218: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
4219: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

Line 4216: fnd_message.set_token('PROC', l_proc);

4212: l_plip_ordr_num;
4213: IF c_plip_info%NOTFOUND THEN
4214: --
4215: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
4216: fnd_message.set_token('PROC', l_proc);
4217: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4218: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
4219: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4220: RAISE ben_manage_life_events.g_record_error;

Line 4217: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));

4213: IF c_plip_info%NOTFOUND THEN
4214: --
4215: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
4216: fnd_message.set_token('PROC', l_proc);
4217: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4218: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
4219: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4220: RAISE ben_manage_life_events.g_record_error;
4221: --

Line 4218: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

4214: --
4215: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
4216: fnd_message.set_token('PROC', l_proc);
4217: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4218: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
4219: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4220: RAISE ben_manage_life_events.g_record_error;
4221: --
4222: END IF;

Line 4219: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

4215: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
4216: fnd_message.set_token('PROC', l_proc);
4217: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4218: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
4219: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4220: RAISE ben_manage_life_events.g_record_error;
4221: --
4222: END IF;
4223: --

Line 4244: fnd_message.set_name('BEN', 'BEN_91462_PTIP_MISSING');

4240: l_ptip_ordr_num;
4241: --
4242: IF c_ptip_info%NOTFOUND THEN
4243: --
4244: fnd_message.set_name('BEN', 'BEN_91462_PTIP_MISSING');
4245: fnd_message.set_token('PROC', l_proc);
4246: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4247: fnd_message.set_token('PL_TYP_ID', TO_CHAR(l_pl_typ_id));
4248: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

Line 4245: fnd_message.set_token('PROC', l_proc);

4241: --
4242: IF c_ptip_info%NOTFOUND THEN
4243: --
4244: fnd_message.set_name('BEN', 'BEN_91462_PTIP_MISSING');
4245: fnd_message.set_token('PROC', l_proc);
4246: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4247: fnd_message.set_token('PL_TYP_ID', TO_CHAR(l_pl_typ_id));
4248: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4249: RAISE ben_manage_life_events.g_record_error;

Line 4246: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));

4242: IF c_ptip_info%NOTFOUND THEN
4243: --
4244: fnd_message.set_name('BEN', 'BEN_91462_PTIP_MISSING');
4245: fnd_message.set_token('PROC', l_proc);
4246: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4247: fnd_message.set_token('PL_TYP_ID', TO_CHAR(l_pl_typ_id));
4248: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4249: RAISE ben_manage_life_events.g_record_error;
4250: --

Line 4247: fnd_message.set_token('PL_TYP_ID', TO_CHAR(l_pl_typ_id));

4243: --
4244: fnd_message.set_name('BEN', 'BEN_91462_PTIP_MISSING');
4245: fnd_message.set_token('PROC', l_proc);
4246: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4247: fnd_message.set_token('PL_TYP_ID', TO_CHAR(l_pl_typ_id));
4248: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4249: RAISE ben_manage_life_events.g_record_error;
4250: --
4251: END IF;

Line 4248: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

4244: fnd_message.set_name('BEN', 'BEN_91462_PTIP_MISSING');
4245: fnd_message.set_token('PROC', l_proc);
4246: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4247: fnd_message.set_token('PL_TYP_ID', TO_CHAR(l_pl_typ_id));
4248: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4249: RAISE ben_manage_life_events.g_record_error;
4250: --
4251: END IF;
4252: --

Line 4320: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');

4316: l_ler_eed;
4317: --
4318: IF c_ovrd_per_in_ler_info%NOTFOUND THEN
4319: --
4320: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4321: fnd_message.set_token('PROC', l_proc);
4322: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4323: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4324: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 4321: fnd_message.set_token('PROC', l_proc);

4317: --
4318: IF c_ovrd_per_in_ler_info%NOTFOUND THEN
4319: --
4320: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4321: fnd_message.set_token('PROC', l_proc);
4322: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4323: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4324: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4325: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

Line 4322: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

4318: IF c_ovrd_per_in_ler_info%NOTFOUND THEN
4319: --
4320: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4321: fnd_message.set_token('PROC', l_proc);
4322: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4323: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4324: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4325: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4326: RAISE ben_manage_life_events.g_record_error;

Line 4323: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));

4319: --
4320: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4321: fnd_message.set_token('PROC', l_proc);
4322: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4323: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4324: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4325: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4326: RAISE ben_manage_life_events.g_record_error;
4327: --

Line 4324: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

4320: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4321: fnd_message.set_token('PROC', l_proc);
4322: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4323: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4324: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4325: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4326: RAISE ben_manage_life_events.g_record_error;
4327: --
4328: END IF;

Line 4325: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

4321: fnd_message.set_token('PROC', l_proc);
4322: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4323: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4324: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4325: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4326: RAISE ben_manage_life_events.g_record_error;
4327: --
4328: END IF;
4329: --

Line 4348: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');

4344: l_ler_eed;
4345: --
4346: IF c_per_in_ler_info%NOTFOUND THEN
4347: --
4348: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4349: fnd_message.set_token('PROC', l_proc);
4350: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4351: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4352: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 4349: fnd_message.set_token('PROC', l_proc);

4345: --
4346: IF c_per_in_ler_info%NOTFOUND THEN
4347: --
4348: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4349: fnd_message.set_token('PROC', l_proc);
4350: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4351: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4352: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4353: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

Line 4350: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

4346: IF c_per_in_ler_info%NOTFOUND THEN
4347: --
4348: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4349: fnd_message.set_token('PROC', l_proc);
4350: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4351: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4352: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4353: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4354: RAISE ben_manage_life_events.g_record_error;

Line 4351: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));

4347: --
4348: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4349: fnd_message.set_token('PROC', l_proc);
4350: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4351: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4352: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4353: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4354: RAISE ben_manage_life_events.g_record_error;
4355: --

Line 4352: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

4348: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
4349: fnd_message.set_token('PROC', l_proc);
4350: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4351: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4352: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4353: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4354: RAISE ben_manage_life_events.g_record_error;
4355: --
4356: END IF;

Line 4353: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

4349: fnd_message.set_token('PROC', l_proc);
4350: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4351: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4352: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4353: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4354: RAISE ben_manage_life_events.g_record_error;
4355: --
4356: END IF;
4357: --

Line 4375: fnd_message.set_name('BEN', 'BEN_91334_PLAN_YR_PERD');

4371: l_popl_yr_perd_ordr_num;
4372: --
4373: IF ((c_pl_popl_yr_period_current%NOTFOUND) and (p_run_mode not in ('G','D'))) THEN
4374: --
4375: fnd_message.set_name('BEN', 'BEN_91334_PLAN_YR_PERD');
4376: fnd_message.set_token('PROC', l_proc);
4377: RAISE ben_manage_life_events.g_record_error;
4378: --
4379: END IF;

Line 4376: fnd_message.set_token('PROC', l_proc);

4372: --
4373: IF ((c_pl_popl_yr_period_current%NOTFOUND) and (p_run_mode not in ('G','D'))) THEN
4374: --
4375: fnd_message.set_name('BEN', 'BEN_91334_PLAN_YR_PERD');
4376: fnd_message.set_token('PROC', l_proc);
4377: RAISE ben_manage_life_events.g_record_error;
4378: --
4379: END IF;
4380: --

Line 4399: fnd_message.set_name('BEN', 'BEN_91463_ELCTBL_CHC_EXISTS');

4395: --
4396: IF l_currepe_dets.elig_per_elctbl_chc_id is not null and
4397: p_run_mode not in ('U','R','D') THEN
4398: --
4399: fnd_message.set_name('BEN', 'BEN_91463_ELCTBL_CHC_EXISTS');
4400: fnd_message.set_token('PROC', l_proc);
4401: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
4402: if g_debug then
4403: hr_utility.set_location('Leaving: ' || l_proc, 20);

Line 4400: fnd_message.set_token('PROC', l_proc);

4396: IF l_currepe_dets.elig_per_elctbl_chc_id is not null and
4397: p_run_mode not in ('U','R','D') THEN
4398: --
4399: fnd_message.set_name('BEN', 'BEN_91463_ELCTBL_CHC_EXISTS');
4400: fnd_message.set_token('PROC', l_proc);
4401: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
4402: if g_debug then
4403: hr_utility.set_location('Leaving: ' || l_proc, 20);
4404: end if;

Line 4401: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

4397: p_run_mode not in ('U','R','D') THEN
4398: --
4399: fnd_message.set_name('BEN', 'BEN_91463_ELCTBL_CHC_EXISTS');
4400: fnd_message.set_token('PROC', l_proc);
4401: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
4402: if g_debug then
4403: hr_utility.set_location('Leaving: ' || l_proc, 20);
4404: end if;
4405: p_electable_flag := 'N';

Line 4928: fnd_message.set_name('BEN','BEN_92699_SEQ_NUM_NOT_EXST');

4924: l_cnt := l_cnt + 1;
4925: end loop;
4926: close c_opt_level;
4927: if not l_found then
4928: fnd_message.set_name('BEN','BEN_92699_SEQ_NUM_NOT_EXST');
4929: fnd_message.raise_error;
4930: end if;
4931: end if;
4932: --

Line 4929: fnd_message.raise_error;

4925: end loop;
4926: close c_opt_level;
4927: if not l_found then
4928: fnd_message.set_name('BEN','BEN_92699_SEQ_NUM_NOT_EXST');
4929: fnd_message.raise_error;
4930: end if;
4931: end if;
4932: --
4933: l_cnt := 1;

Line 4954: fnd_message.set_name('BEN','BEN_92699_SEQ_NUM_NOT_EXST');

4950: l_cnt := l_cnt + 1;
4951: end loop;
4952: close c_opt_level;
4953: if not l_found then
4954: fnd_message.set_name('BEN','BEN_92699_SEQ_NUM_NOT_EXST');
4955: fnd_message.raise_error;
4956: end if;
4957: end if;
4958: -- End of Logical Ordr Num

Line 4955: fnd_message.raise_error;

4951: end loop;
4952: close c_opt_level;
4953: if not l_found then
4954: fnd_message.set_name('BEN','BEN_92699_SEQ_NUM_NOT_EXST');
4955: fnd_message.raise_error;
4956: end if;
4957: end if;
4958: -- End of Logical Ordr Num
4959:

Line 5392: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');

5388: ELSE
5389: if g_debug then
5390: hr_utility.set_location('Did not find enrt_perd, raise error', 982);
5391: end if;
5392: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5393: fnd_message.set_token('PROC', l_proc);
5394: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5395: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5396: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 5393: fnd_message.set_token('PROC', l_proc);

5389: if g_debug then
5390: hr_utility.set_location('Did not find enrt_perd, raise error', 982);
5391: end if;
5392: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5393: fnd_message.set_token('PROC', l_proc);
5394: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5395: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5396: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5397: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

Line 5394: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));

5390: hr_utility.set_location('Did not find enrt_perd, raise error', 982);
5391: end if;
5392: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5393: fnd_message.set_token('PROC', l_proc);
5394: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5395: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5396: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5397: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5398: RAISE ben_manage_life_events.g_record_error;

Line 5395: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

5391: end if;
5392: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5393: fnd_message.set_token('PROC', l_proc);
5394: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5395: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5396: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5397: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5398: RAISE ben_manage_life_events.g_record_error;
5399: END IF;

Line 5396: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

5392: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5393: fnd_message.set_token('PROC', l_proc);
5394: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5395: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5396: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5397: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5398: RAISE ben_manage_life_events.g_record_error;
5399: END IF;
5400: --

Line 5397: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

5393: fnd_message.set_token('PROC', l_proc);
5394: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5395: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5396: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5397: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5398: RAISE ben_manage_life_events.g_record_error;
5399: END IF;
5400: --
5401: END IF; -- no enrt_perd info found.

Line 5508: fnd_message.set_name('BEN', 'BEN_91464_ENRT_TYP_CYCL_CD');

5504: l_rec_enrt_typ_cycl_cd := l_pgme_enrt_typ_cycl_cd;
5505: -- Bug 2200139 Override Enrollment
5506: ELSIF l_unrestricted_enrt_flag = 'N' and nvl(p_run_mode,'X') <> 'V' THEN
5507: -- If nothing found report an error.
5508: fnd_message.set_name('BEN', 'BEN_91464_ENRT_TYP_CYCL_CD');
5509: fnd_message.set_token('PROC', l_proc);
5510: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5511: fnd_message.set_token('PGM_ENRT_TYP_CYCL_CD', l_pgme_enrt_typ_cycl_cd);
5512: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

Line 5509: fnd_message.set_token('PROC', l_proc);

5505: -- Bug 2200139 Override Enrollment
5506: ELSIF l_unrestricted_enrt_flag = 'N' and nvl(p_run_mode,'X') <> 'V' THEN
5507: -- If nothing found report an error.
5508: fnd_message.set_name('BEN', 'BEN_91464_ENRT_TYP_CYCL_CD');
5509: fnd_message.set_token('PROC', l_proc);
5510: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5511: fnd_message.set_token('PGM_ENRT_TYP_CYCL_CD', l_pgme_enrt_typ_cycl_cd);
5512: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5513: fnd_message.set_token('PL_ENRT_TYP_CYCL_CD', l_ple_enrt_typ_cycl_cd);

Line 5510: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));

5506: ELSIF l_unrestricted_enrt_flag = 'N' and nvl(p_run_mode,'X') <> 'V' THEN
5507: -- If nothing found report an error.
5508: fnd_message.set_name('BEN', 'BEN_91464_ENRT_TYP_CYCL_CD');
5509: fnd_message.set_token('PROC', l_proc);
5510: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5511: fnd_message.set_token('PGM_ENRT_TYP_CYCL_CD', l_pgme_enrt_typ_cycl_cd);
5512: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5513: fnd_message.set_token('PL_ENRT_TYP_CYCL_CD', l_ple_enrt_typ_cycl_cd);
5514: RAISE ben_manage_life_events.g_record_error;

Line 5511: fnd_message.set_token('PGM_ENRT_TYP_CYCL_CD', l_pgme_enrt_typ_cycl_cd);

5507: -- If nothing found report an error.
5508: fnd_message.set_name('BEN', 'BEN_91464_ENRT_TYP_CYCL_CD');
5509: fnd_message.set_token('PROC', l_proc);
5510: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5511: fnd_message.set_token('PGM_ENRT_TYP_CYCL_CD', l_pgme_enrt_typ_cycl_cd);
5512: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5513: fnd_message.set_token('PL_ENRT_TYP_CYCL_CD', l_ple_enrt_typ_cycl_cd);
5514: RAISE ben_manage_life_events.g_record_error;
5515: --

Line 5512: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

5508: fnd_message.set_name('BEN', 'BEN_91464_ENRT_TYP_CYCL_CD');
5509: fnd_message.set_token('PROC', l_proc);
5510: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5511: fnd_message.set_token('PGM_ENRT_TYP_CYCL_CD', l_pgme_enrt_typ_cycl_cd);
5512: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5513: fnd_message.set_token('PL_ENRT_TYP_CYCL_CD', l_ple_enrt_typ_cycl_cd);
5514: RAISE ben_manage_life_events.g_record_error;
5515: --
5516: END IF;

Line 5513: fnd_message.set_token('PL_ENRT_TYP_CYCL_CD', l_ple_enrt_typ_cycl_cd);

5509: fnd_message.set_token('PROC', l_proc);
5510: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5511: fnd_message.set_token('PGM_ENRT_TYP_CYCL_CD', l_pgme_enrt_typ_cycl_cd);
5512: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5513: fnd_message.set_token('PL_ENRT_TYP_CYCL_CD', l_ple_enrt_typ_cycl_cd);
5514: RAISE ben_manage_life_events.g_record_error;
5515: --
5516: END IF;
5517: --

Line 5990: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');

5986: hr_utility.set_location(' Dn PFPF=Y ' || l_proc, 10);
5987: end if;
5988: ELSE
5989: --
5990: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5991: fnd_message.set_token('PROC', l_proc);
5992: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5993: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5994: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 5991: fnd_message.set_token('PROC', l_proc);

5987: end if;
5988: ELSE
5989: --
5990: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5991: fnd_message.set_token('PROC', l_proc);
5992: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5993: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5994: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5995: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

Line 5992: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));

5988: ELSE
5989: --
5990: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5991: fnd_message.set_token('PROC', l_proc);
5992: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5993: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5994: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5995: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5996: RAISE ben_manage_life_events.g_record_error;

Line 5993: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

5989: --
5990: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5991: fnd_message.set_token('PROC', l_proc);
5992: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5993: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5994: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5995: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5996: RAISE ben_manage_life_events.g_record_error;
5997: --

Line 5994: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

5990: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
5991: fnd_message.set_token('PROC', l_proc);
5992: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5993: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5994: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5995: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5996: RAISE ben_manage_life_events.g_record_error;
5997: --
5998: END IF; -- perd found and strt_dt_cd not null

Line 5995: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

5991: fnd_message.set_token('PROC', l_proc);
5992: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5993: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5994: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5995: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5996: RAISE ben_manage_life_events.g_record_error;
5997: --
5998: END IF; -- perd found and strt_dt_cd not null
5999: --

Line 6171: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');

6167: l_rec_enrt_perd_id := l_pgme_enrt_perd_id;
6168: --
6169: ELSE
6170: --
6171: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6172: fnd_message.set_token('PROC', l_proc);
6173: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6174: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6175: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 6172: fnd_message.set_token('PROC', l_proc);

6168: --
6169: ELSE
6170: --
6171: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6172: fnd_message.set_token('PROC', l_proc);
6173: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6174: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6175: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6176: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

Line 6173: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));

6169: ELSE
6170: --
6171: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6172: fnd_message.set_token('PROC', l_proc);
6173: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6174: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6175: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6176: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6177: RAISE ben_manage_life_events.g_record_error;

Line 6174: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

6170: --
6171: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6172: fnd_message.set_token('PROC', l_proc);
6173: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6174: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6175: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6176: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6177: RAISE ben_manage_life_events.g_record_error;
6178: --

Line 6175: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

6171: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6172: fnd_message.set_token('PROC', l_proc);
6173: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6174: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6175: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6176: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6177: RAISE ben_manage_life_events.g_record_error;
6178: --
6179: END IF; -- perd found and strt_dt_cd not null

Line 6176: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

6172: fnd_message.set_token('PROC', l_proc);
6173: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6174: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6175: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6176: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6177: RAISE ben_manage_life_events.g_record_error;
6178: --
6179: END IF; -- perd found and strt_dt_cd not null
6180: ELSIF (p_run_mode = 'M' AND l_unrestricted_enrt_flag = 'N') THEN -- ABS processing

Line 6248: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');

6244: hr_utility.set_location(' Dn RM L UEF N ' || l_proc, 20);
6245: end if;
6246: ELSE
6247: --
6248: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6249: fnd_message.set_token('PROC', l_proc);
6250: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6251: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6252: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 6249: fnd_message.set_token('PROC', l_proc);

6245: end if;
6246: ELSE
6247: --
6248: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6249: fnd_message.set_token('PROC', l_proc);
6250: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6251: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6252: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6253: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

Line 6250: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));

6246: ELSE
6247: --
6248: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6249: fnd_message.set_token('PROC', l_proc);
6250: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6251: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6252: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6253: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6254: RAISE ben_manage_life_events.g_record_error;

Line 6251: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

6247: --
6248: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6249: fnd_message.set_token('PROC', l_proc);
6250: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6251: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6252: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6253: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6254: RAISE ben_manage_life_events.g_record_error;
6255: --

Line 6252: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

6248: fnd_message.set_name('BEN', 'BEN_91335_PLAN_YR_ENRT_PERD');
6249: fnd_message.set_token('PROC', l_proc);
6250: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6251: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6252: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6253: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6254: RAISE ben_manage_life_events.g_record_error;
6255: --
6256: END IF; -- perd found and strt_dt_cd not null

Line 6253: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

6249: fnd_message.set_token('PROC', l_proc);
6250: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6251: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6252: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6253: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6254: RAISE ben_manage_life_events.g_record_error;
6255: --
6256: END IF; -- perd found and strt_dt_cd not null
6257: --

Line 6267: fnd_message.set_name('BEN', 'BEN_91735_END_BEFORE_STRT_DT');

6263: end if;
6264: -- Check to see if the start date is before the end date
6265: IF l_rec_enrt_perd_strt_dt > l_rec_enrt_perd_end_dt THEN
6266: --
6267: fnd_message.set_name('BEN', 'BEN_91735_END_BEFORE_STRT_DT');
6268: fnd_message.set_token('PROC', l_proc);
6269: fnd_message.set_token(
6270: 'ENRT_PERD_STRT_DT',
6271: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6268: fnd_message.set_token('PROC', l_proc);

6264: -- Check to see if the start date is before the end date
6265: IF l_rec_enrt_perd_strt_dt > l_rec_enrt_perd_end_dt THEN
6266: --
6267: fnd_message.set_name('BEN', 'BEN_91735_END_BEFORE_STRT_DT');
6268: fnd_message.set_token('PROC', l_proc);
6269: fnd_message.set_token(
6270: 'ENRT_PERD_STRT_DT',
6271: TO_CHAR(l_rec_enrt_perd_strt_dt));
6272: fnd_message.set_token(

Line 6269: fnd_message.set_token(

6265: IF l_rec_enrt_perd_strt_dt > l_rec_enrt_perd_end_dt THEN
6266: --
6267: fnd_message.set_name('BEN', 'BEN_91735_END_BEFORE_STRT_DT');
6268: fnd_message.set_token('PROC', l_proc);
6269: fnd_message.set_token(
6270: 'ENRT_PERD_STRT_DT',
6271: TO_CHAR(l_rec_enrt_perd_strt_dt));
6272: fnd_message.set_token(
6273: 'ENRT_PERD_END_DT',

Line 6272: fnd_message.set_token(

6268: fnd_message.set_token('PROC', l_proc);
6269: fnd_message.set_token(
6270: 'ENRT_PERD_STRT_DT',
6271: TO_CHAR(l_rec_enrt_perd_strt_dt));
6272: fnd_message.set_token(
6273: 'ENRT_PERD_END_DT',
6274: TO_CHAR(l_rec_enrt_perd_end_dt));
6275: RAISE ben_manage_life_events.g_record_error;
6276: --

Line 6588: fnd_message.set_name('BEN', 'BEN_92214_PGM_NOT_EFF_ON_STRT');

6584: hr_utility.set_location(
6585: 'Program not date effective on period start',
6586: 10);
6587: end if;
6588: fnd_message.set_name('BEN', 'BEN_92214_PGM_NOT_EFF_ON_STRT');
6589: fnd_message.set_token('PROC', l_proc);
6590: fnd_message.set_token(
6591: 'ENRT_PERD_STRT_DT',
6592: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6589: fnd_message.set_token('PROC', l_proc);

6585: 'Program not date effective on period start',
6586: 10);
6587: end if;
6588: fnd_message.set_name('BEN', 'BEN_92214_PGM_NOT_EFF_ON_STRT');
6589: fnd_message.set_token('PROC', l_proc);
6590: fnd_message.set_token(
6591: 'ENRT_PERD_STRT_DT',
6592: TO_CHAR(l_rec_enrt_perd_strt_dt));
6593: fnd_message.set_token(

Line 6590: fnd_message.set_token(

6586: 10);
6587: end if;
6588: fnd_message.set_name('BEN', 'BEN_92214_PGM_NOT_EFF_ON_STRT');
6589: fnd_message.set_token('PROC', l_proc);
6590: fnd_message.set_token(
6591: 'ENRT_PERD_STRT_DT',
6592: TO_CHAR(l_rec_enrt_perd_strt_dt));
6593: fnd_message.set_token(
6594: 'PGM_STRT_DT',

Line 6593: fnd_message.set_token(

6589: fnd_message.set_token('PROC', l_proc);
6590: fnd_message.set_token(
6591: 'ENRT_PERD_STRT_DT',
6592: TO_CHAR(l_rec_enrt_perd_strt_dt));
6593: fnd_message.set_token(
6594: 'PGM_STRT_DT',
6595: TO_CHAR(l_pgm_rec.effective_start_date));
6596: fnd_message.set_token(
6597: 'PGM_END_DT',

Line 6596: fnd_message.set_token(

6592: TO_CHAR(l_rec_enrt_perd_strt_dt));
6593: fnd_message.set_token(
6594: 'PGM_STRT_DT',
6595: TO_CHAR(l_pgm_rec.effective_start_date));
6596: fnd_message.set_token(
6597: 'PGM_END_DT',
6598: TO_CHAR(l_pgm_rec.effective_end_date));
6599: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6600: p_electable_flag := 'N';

Line 6599: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6595: TO_CHAR(l_pgm_rec.effective_start_date));
6596: fnd_message.set_token(
6597: 'PGM_END_DT',
6598: TO_CHAR(l_pgm_rec.effective_end_date));
6599: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6600: p_electable_flag := 'N';
6601: RETURN;
6602: end if;
6603: close c_pgm_requery;

Line 6615: fnd_message.set_name('BEN', 'BEN_92208_PLIP_NOT_EFF_ON_STRT');

6611: if c_plip_requery%notfound then
6612: if g_debug then
6613: hr_utility.set_location('Plip not date effective on period start', 10);
6614: end if;
6615: fnd_message.set_name('BEN', 'BEN_92208_PLIP_NOT_EFF_ON_STRT');
6616: fnd_message.set_token('PROC', l_proc);
6617: fnd_message.set_token(
6618: 'ENRT_PERD_STRT_DT',
6619: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6616: fnd_message.set_token('PROC', l_proc);

6612: if g_debug then
6613: hr_utility.set_location('Plip not date effective on period start', 10);
6614: end if;
6615: fnd_message.set_name('BEN', 'BEN_92208_PLIP_NOT_EFF_ON_STRT');
6616: fnd_message.set_token('PROC', l_proc);
6617: fnd_message.set_token(
6618: 'ENRT_PERD_STRT_DT',
6619: TO_CHAR(l_rec_enrt_perd_strt_dt));
6620: fnd_message.set_token('PLIP_STRT_DT', TO_CHAR(l_plip_esd));

Line 6617: fnd_message.set_token(

6613: hr_utility.set_location('Plip not date effective on period start', 10);
6614: end if;
6615: fnd_message.set_name('BEN', 'BEN_92208_PLIP_NOT_EFF_ON_STRT');
6616: fnd_message.set_token('PROC', l_proc);
6617: fnd_message.set_token(
6618: 'ENRT_PERD_STRT_DT',
6619: TO_CHAR(l_rec_enrt_perd_strt_dt));
6620: fnd_message.set_token('PLIP_STRT_DT', TO_CHAR(l_plip_esd));
6621: fnd_message.set_token('PLIP_END_DT', TO_CHAR(l_plip_eed));

Line 6620: fnd_message.set_token('PLIP_STRT_DT', TO_CHAR(l_plip_esd));

6616: fnd_message.set_token('PROC', l_proc);
6617: fnd_message.set_token(
6618: 'ENRT_PERD_STRT_DT',
6619: TO_CHAR(l_rec_enrt_perd_strt_dt));
6620: fnd_message.set_token('PLIP_STRT_DT', TO_CHAR(l_plip_esd));
6621: fnd_message.set_token('PLIP_END_DT', TO_CHAR(l_plip_eed));
6622: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6623: p_electable_flag := 'N';
6624: RETURN;

Line 6621: fnd_message.set_token('PLIP_END_DT', TO_CHAR(l_plip_eed));

6617: fnd_message.set_token(
6618: 'ENRT_PERD_STRT_DT',
6619: TO_CHAR(l_rec_enrt_perd_strt_dt));
6620: fnd_message.set_token('PLIP_STRT_DT', TO_CHAR(l_plip_esd));
6621: fnd_message.set_token('PLIP_END_DT', TO_CHAR(l_plip_eed));
6622: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6623: p_electable_flag := 'N';
6624: RETURN;
6625: end if;

Line 6622: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6618: 'ENRT_PERD_STRT_DT',
6619: TO_CHAR(l_rec_enrt_perd_strt_dt));
6620: fnd_message.set_token('PLIP_STRT_DT', TO_CHAR(l_plip_esd));
6621: fnd_message.set_token('PLIP_END_DT', TO_CHAR(l_plip_eed));
6622: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6623: p_electable_flag := 'N';
6624: RETURN;
6625: end if;
6626: close c_plip_requery;

Line 6649: fnd_message.set_name('BEN', 'BEN_92213_PTIP_NOT_EFF_ON_STRT');

6645: if c_ptip_requery%notfound then
6646: if g_debug then
6647: hr_utility.set_location('Ptip not date effective on period start', 10);
6648: end if;
6649: fnd_message.set_name('BEN', 'BEN_92213_PTIP_NOT_EFF_ON_STRT');
6650: fnd_message.set_token('PROC', l_proc);
6651: fnd_message.set_token(
6652: 'ENRT_PERD_STRT_DT',
6653: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6650: fnd_message.set_token('PROC', l_proc);

6646: if g_debug then
6647: hr_utility.set_location('Ptip not date effective on period start', 10);
6648: end if;
6649: fnd_message.set_name('BEN', 'BEN_92213_PTIP_NOT_EFF_ON_STRT');
6650: fnd_message.set_token('PROC', l_proc);
6651: fnd_message.set_token(
6652: 'ENRT_PERD_STRT_DT',
6653: TO_CHAR(l_rec_enrt_perd_strt_dt));
6654: fnd_message.set_token('PTIP_STRT_DT', TO_CHAR(l_ptip_esd));

Line 6651: fnd_message.set_token(

6647: hr_utility.set_location('Ptip not date effective on period start', 10);
6648: end if;
6649: fnd_message.set_name('BEN', 'BEN_92213_PTIP_NOT_EFF_ON_STRT');
6650: fnd_message.set_token('PROC', l_proc);
6651: fnd_message.set_token(
6652: 'ENRT_PERD_STRT_DT',
6653: TO_CHAR(l_rec_enrt_perd_strt_dt));
6654: fnd_message.set_token('PTIP_STRT_DT', TO_CHAR(l_ptip_esd));
6655: fnd_message.set_token('PTIP_END_DT', TO_CHAR(l_ptip_eed));

Line 6654: fnd_message.set_token('PTIP_STRT_DT', TO_CHAR(l_ptip_esd));

6650: fnd_message.set_token('PROC', l_proc);
6651: fnd_message.set_token(
6652: 'ENRT_PERD_STRT_DT',
6653: TO_CHAR(l_rec_enrt_perd_strt_dt));
6654: fnd_message.set_token('PTIP_STRT_DT', TO_CHAR(l_ptip_esd));
6655: fnd_message.set_token('PTIP_END_DT', TO_CHAR(l_ptip_eed));
6656: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6657: p_electable_flag := 'N';
6658: -- Bug fix 2008871 -- hnarayan

Line 6655: fnd_message.set_token('PTIP_END_DT', TO_CHAR(l_ptip_eed));

6651: fnd_message.set_token(
6652: 'ENRT_PERD_STRT_DT',
6653: TO_CHAR(l_rec_enrt_perd_strt_dt));
6654: fnd_message.set_token('PTIP_STRT_DT', TO_CHAR(l_ptip_esd));
6655: fnd_message.set_token('PTIP_END_DT', TO_CHAR(l_ptip_eed));
6656: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6657: p_electable_flag := 'N';
6658: -- Bug fix 2008871 -- hnarayan
6659: close c_ptip_requery;

Line 6656: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6652: 'ENRT_PERD_STRT_DT',
6653: TO_CHAR(l_rec_enrt_perd_strt_dt));
6654: fnd_message.set_token('PTIP_STRT_DT', TO_CHAR(l_ptip_esd));
6655: fnd_message.set_token('PTIP_END_DT', TO_CHAR(l_ptip_eed));
6656: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6657: p_electable_flag := 'N';
6658: -- Bug fix 2008871 -- hnarayan
6659: close c_ptip_requery;
6660: RETURN;

Line 6694: fnd_message.set_name('BEN', 'BEN_92207_OIPL_NOT_EFF_ON_STRT');

6690: if c_oipl_requery%notfound then
6691: if g_debug then
6692: hr_utility.set_location('Oipl not date effective on period start', 10);
6693: end if;
6694: fnd_message.set_name('BEN', 'BEN_92207_OIPL_NOT_EFF_ON_STRT');
6695: fnd_message.set_token('PROC', l_proc);
6696: fnd_message.set_token(
6697: 'ENRT_PERD_STRT_DT',
6698: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6695: fnd_message.set_token('PROC', l_proc);

6691: if g_debug then
6692: hr_utility.set_location('Oipl not date effective on period start', 10);
6693: end if;
6694: fnd_message.set_name('BEN', 'BEN_92207_OIPL_NOT_EFF_ON_STRT');
6695: fnd_message.set_token('PROC', l_proc);
6696: fnd_message.set_token(
6697: 'ENRT_PERD_STRT_DT',
6698: TO_CHAR(l_rec_enrt_perd_strt_dt));
6699: fnd_message.set_token(

Line 6696: fnd_message.set_token(

6692: hr_utility.set_location('Oipl not date effective on period start', 10);
6693: end if;
6694: fnd_message.set_name('BEN', 'BEN_92207_OIPL_NOT_EFF_ON_STRT');
6695: fnd_message.set_token('PROC', l_proc);
6696: fnd_message.set_token(
6697: 'ENRT_PERD_STRT_DT',
6698: TO_CHAR(l_rec_enrt_perd_strt_dt));
6699: fnd_message.set_token(
6700: 'OIPL_STRT_DT',

Line 6699: fnd_message.set_token(

6695: fnd_message.set_token('PROC', l_proc);
6696: fnd_message.set_token(
6697: 'ENRT_PERD_STRT_DT',
6698: TO_CHAR(l_rec_enrt_perd_strt_dt));
6699: fnd_message.set_token(
6700: 'OIPL_STRT_DT',
6701: TO_CHAR(l_oipl_rec.effective_start_date));
6702: fnd_message.set_token(
6703: 'OIPL_END_DT',

Line 6702: fnd_message.set_token(

6698: TO_CHAR(l_rec_enrt_perd_strt_dt));
6699: fnd_message.set_token(
6700: 'OIPL_STRT_DT',
6701: TO_CHAR(l_oipl_rec.effective_start_date));
6702: fnd_message.set_token(
6703: 'OIPL_END_DT',
6704: TO_CHAR(l_oipl_rec.effective_end_date));
6705: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6706: p_electable_flag := 'N';

Line 6705: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6701: TO_CHAR(l_oipl_rec.effective_start_date));
6702: fnd_message.set_token(
6703: 'OIPL_END_DT',
6704: TO_CHAR(l_oipl_rec.effective_end_date));
6705: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6706: p_electable_flag := 'N';
6707: RETURN;
6708: end if;
6709: close c_oipl_requery;

Line 6725: fnd_message.set_name('BEN', 'BEN_92212_OPT_NOT_EFF_ON_STRT');

6721: hr_utility.set_location(
6722: 'Option not date effective on period start',
6723: 10);
6724: end if;
6725: fnd_message.set_name('BEN', 'BEN_92212_OPT_NOT_EFF_ON_STRT');
6726: fnd_message.set_token('PROC', l_proc);
6727: fnd_message.set_token(
6728: 'ENRT_PERD_STRT_DT',
6729: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6726: fnd_message.set_token('PROC', l_proc);

6722: 'Option not date effective on period start',
6723: 10);
6724: end if;
6725: fnd_message.set_name('BEN', 'BEN_92212_OPT_NOT_EFF_ON_STRT');
6726: fnd_message.set_token('PROC', l_proc);
6727: fnd_message.set_token(
6728: 'ENRT_PERD_STRT_DT',
6729: TO_CHAR(l_rec_enrt_perd_strt_dt));
6730: fnd_message.set_token(

Line 6727: fnd_message.set_token(

6723: 10);
6724: end if;
6725: fnd_message.set_name('BEN', 'BEN_92212_OPT_NOT_EFF_ON_STRT');
6726: fnd_message.set_token('PROC', l_proc);
6727: fnd_message.set_token(
6728: 'ENRT_PERD_STRT_DT',
6729: TO_CHAR(l_rec_enrt_perd_strt_dt));
6730: fnd_message.set_token(
6731: 'OPT_STRT_DT',

Line 6730: fnd_message.set_token(

6726: fnd_message.set_token('PROC', l_proc);
6727: fnd_message.set_token(
6728: 'ENRT_PERD_STRT_DT',
6729: TO_CHAR(l_rec_enrt_perd_strt_dt));
6730: fnd_message.set_token(
6731: 'OPT_STRT_DT',
6732: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6733: fnd_message.set_token(
6734: 'OPT_END_DT',

Line 6733: fnd_message.set_token(

6729: TO_CHAR(l_rec_enrt_perd_strt_dt));
6730: fnd_message.set_token(
6731: 'OPT_STRT_DT',
6732: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6733: fnd_message.set_token(
6734: 'OPT_END_DT',
6735: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));
6736: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6737: p_electable_flag := 'N';

Line 6736: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6732: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_start_date));
6733: fnd_message.set_token(
6734: 'OPT_END_DT',
6735: TO_CHAR(ben_cobj_cache.g_opt_currow.effective_end_date));
6736: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6737: p_electable_flag := 'N';
6738: RETURN;
6739: end if;
6740: close c_opt_requery;

Line 6758: fnd_message.set_name('BEN', 'BEN_92211_PLAN_NOT_EFF_ON_STRT');

6754: hr_utility.set_location('perd_strt_dt=' || l_rec_enrt_perd_strt_dt, 1);
6755: hr_utility.set_location('strt_dt=' || l_plan_rec.effective_start_date, 1);
6756: hr_utility.set_location('end_dt=' || l_plan_rec.effective_end_date, 1);
6757: end if;
6758: fnd_message.set_name('BEN', 'BEN_92211_PLAN_NOT_EFF_ON_STRT');
6759: fnd_message.set_token('PROC', l_proc);
6760: fnd_message.set_token(
6761: 'ENRT_PERD_STRT_DT',
6762: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6759: fnd_message.set_token('PROC', l_proc);

6755: hr_utility.set_location('strt_dt=' || l_plan_rec.effective_start_date, 1);
6756: hr_utility.set_location('end_dt=' || l_plan_rec.effective_end_date, 1);
6757: end if;
6758: fnd_message.set_name('BEN', 'BEN_92211_PLAN_NOT_EFF_ON_STRT');
6759: fnd_message.set_token('PROC', l_proc);
6760: fnd_message.set_token(
6761: 'ENRT_PERD_STRT_DT',
6762: TO_CHAR(l_rec_enrt_perd_strt_dt));
6763: fnd_message.set_token(

Line 6760: fnd_message.set_token(

6756: hr_utility.set_location('end_dt=' || l_plan_rec.effective_end_date, 1);
6757: end if;
6758: fnd_message.set_name('BEN', 'BEN_92211_PLAN_NOT_EFF_ON_STRT');
6759: fnd_message.set_token('PROC', l_proc);
6760: fnd_message.set_token(
6761: 'ENRT_PERD_STRT_DT',
6762: TO_CHAR(l_rec_enrt_perd_strt_dt));
6763: fnd_message.set_token(
6764: 'PL_STRT_DT',

Line 6763: fnd_message.set_token(

6759: fnd_message.set_token('PROC', l_proc);
6760: fnd_message.set_token(
6761: 'ENRT_PERD_STRT_DT',
6762: TO_CHAR(l_rec_enrt_perd_strt_dt));
6763: fnd_message.set_token(
6764: 'PL_STRT_DT',
6765: TO_CHAR(l_plan_rec.effective_start_date));
6766: fnd_message.set_token(
6767: 'PL_END_DT',

Line 6766: fnd_message.set_token(

6762: TO_CHAR(l_rec_enrt_perd_strt_dt));
6763: fnd_message.set_token(
6764: 'PL_STRT_DT',
6765: TO_CHAR(l_plan_rec.effective_start_date));
6766: fnd_message.set_token(
6767: 'PL_END_DT',
6768: TO_CHAR(l_plan_rec.effective_end_date));
6769: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6770: p_electable_flag := 'N';

Line 6769: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6765: TO_CHAR(l_plan_rec.effective_start_date));
6766: fnd_message.set_token(
6767: 'PL_END_DT',
6768: TO_CHAR(l_plan_rec.effective_end_date));
6769: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6770: p_electable_flag := 'N';
6771: RETURN;
6772: end if;
6773: close c_plan_requery;

Line 6791: fnd_message.set_name('BEN', 'BEN_92206_PL_TYP_NOT_EFF_ON_ST');

6787: if c_pl_typ_requery%notfound then
6788: if g_debug then
6789: hr_utility.set_location('Pl_typ not date effective on period start', 10);
6790: end if;
6791: fnd_message.set_name('BEN', 'BEN_92206_PL_TYP_NOT_EFF_ON_ST');
6792: fnd_message.set_token('PROC', l_proc);
6793: fnd_message.set_token(
6794: 'ENRT_PERD_STRT_DT',
6795: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6792: fnd_message.set_token('PROC', l_proc);

6788: if g_debug then
6789: hr_utility.set_location('Pl_typ not date effective on period start', 10);
6790: end if;
6791: fnd_message.set_name('BEN', 'BEN_92206_PL_TYP_NOT_EFF_ON_ST');
6792: fnd_message.set_token('PROC', l_proc);
6793: fnd_message.set_token(
6794: 'ENRT_PERD_STRT_DT',
6795: TO_CHAR(l_rec_enrt_perd_strt_dt));
6796: fnd_message.set_token('PL_TYP_STRT_DT', TO_CHAR(l_pl_typ_esd));

Line 6793: fnd_message.set_token(

6789: hr_utility.set_location('Pl_typ not date effective on period start', 10);
6790: end if;
6791: fnd_message.set_name('BEN', 'BEN_92206_PL_TYP_NOT_EFF_ON_ST');
6792: fnd_message.set_token('PROC', l_proc);
6793: fnd_message.set_token(
6794: 'ENRT_PERD_STRT_DT',
6795: TO_CHAR(l_rec_enrt_perd_strt_dt));
6796: fnd_message.set_token('PL_TYP_STRT_DT', TO_CHAR(l_pl_typ_esd));
6797: fnd_message.set_token('PL_TYP_END_DT', TO_CHAR(l_pl_typ_eed));

Line 6796: fnd_message.set_token('PL_TYP_STRT_DT', TO_CHAR(l_pl_typ_esd));

6792: fnd_message.set_token('PROC', l_proc);
6793: fnd_message.set_token(
6794: 'ENRT_PERD_STRT_DT',
6795: TO_CHAR(l_rec_enrt_perd_strt_dt));
6796: fnd_message.set_token('PL_TYP_STRT_DT', TO_CHAR(l_pl_typ_esd));
6797: fnd_message.set_token('PL_TYP_END_DT', TO_CHAR(l_pl_typ_eed));
6798: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6799: p_electable_flag := 'N';
6800: RETURN;

Line 6797: fnd_message.set_token('PL_TYP_END_DT', TO_CHAR(l_pl_typ_eed));

6793: fnd_message.set_token(
6794: 'ENRT_PERD_STRT_DT',
6795: TO_CHAR(l_rec_enrt_perd_strt_dt));
6796: fnd_message.set_token('PL_TYP_STRT_DT', TO_CHAR(l_pl_typ_esd));
6797: fnd_message.set_token('PL_TYP_END_DT', TO_CHAR(l_pl_typ_eed));
6798: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6799: p_electable_flag := 'N';
6800: RETURN;
6801: end if;

Line 6798: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6794: 'ENRT_PERD_STRT_DT',
6795: TO_CHAR(l_rec_enrt_perd_strt_dt));
6796: fnd_message.set_token('PL_TYP_STRT_DT', TO_CHAR(l_pl_typ_esd));
6797: fnd_message.set_token('PL_TYP_END_DT', TO_CHAR(l_pl_typ_eed));
6798: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6799: p_electable_flag := 'N';
6800: RETURN;
6801: end if;
6802: close c_pl_typ_requery;

Line 6818: fnd_message.set_name('BEN', 'BEN_92210_LEE_RSN_NOT_EFF_ON_S');

6814: hr_utility.set_location(
6815: 'Lee_rsn not date effective on period start',
6816: 10);
6817: end if;
6818: fnd_message.set_name('BEN', 'BEN_92210_LEE_RSN_NOT_EFF_ON_S');
6819: fnd_message.set_token('PROC', l_proc);
6820: fnd_message.set_token(
6821: 'ENRT_PERD_STRT_DT',
6822: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6819: fnd_message.set_token('PROC', l_proc);

6815: 'Lee_rsn not date effective on period start',
6816: 10);
6817: end if;
6818: fnd_message.set_name('BEN', 'BEN_92210_LEE_RSN_NOT_EFF_ON_S');
6819: fnd_message.set_token('PROC', l_proc);
6820: fnd_message.set_token(
6821: 'ENRT_PERD_STRT_DT',
6822: TO_CHAR(l_rec_enrt_perd_strt_dt));
6823: fnd_message.set_token('LEE_RSN_STRT_DT', TO_CHAR(l_rec_lee_rsn_esd));

Line 6820: fnd_message.set_token(

6816: 10);
6817: end if;
6818: fnd_message.set_name('BEN', 'BEN_92210_LEE_RSN_NOT_EFF_ON_S');
6819: fnd_message.set_token('PROC', l_proc);
6820: fnd_message.set_token(
6821: 'ENRT_PERD_STRT_DT',
6822: TO_CHAR(l_rec_enrt_perd_strt_dt));
6823: fnd_message.set_token('LEE_RSN_STRT_DT', TO_CHAR(l_rec_lee_rsn_esd));
6824: fnd_message.set_token('LEE_RSN_END_DT', TO_CHAR(l_rec_lee_rsn_eed));

Line 6823: fnd_message.set_token('LEE_RSN_STRT_DT', TO_CHAR(l_rec_lee_rsn_esd));

6819: fnd_message.set_token('PROC', l_proc);
6820: fnd_message.set_token(
6821: 'ENRT_PERD_STRT_DT',
6822: TO_CHAR(l_rec_enrt_perd_strt_dt));
6823: fnd_message.set_token('LEE_RSN_STRT_DT', TO_CHAR(l_rec_lee_rsn_esd));
6824: fnd_message.set_token('LEE_RSN_END_DT', TO_CHAR(l_rec_lee_rsn_eed));
6825: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6826: p_electable_flag := 'N';
6827: RETURN;

Line 6824: fnd_message.set_token('LEE_RSN_END_DT', TO_CHAR(l_rec_lee_rsn_eed));

6820: fnd_message.set_token(
6821: 'ENRT_PERD_STRT_DT',
6822: TO_CHAR(l_rec_enrt_perd_strt_dt));
6823: fnd_message.set_token('LEE_RSN_STRT_DT', TO_CHAR(l_rec_lee_rsn_esd));
6824: fnd_message.set_token('LEE_RSN_END_DT', TO_CHAR(l_rec_lee_rsn_eed));
6825: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6826: p_electable_flag := 'N';
6827: RETURN;
6828: end if;

Line 6825: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6821: 'ENRT_PERD_STRT_DT',
6822: TO_CHAR(l_rec_enrt_perd_strt_dt));
6823: fnd_message.set_token('LEE_RSN_STRT_DT', TO_CHAR(l_rec_lee_rsn_esd));
6824: fnd_message.set_token('LEE_RSN_END_DT', TO_CHAR(l_rec_lee_rsn_eed));
6825: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6826: p_electable_flag := 'N';
6827: RETURN;
6828: end if;
6829: close c_lee_rsn_requery;

Line 6841: fnd_message.set_name('BEN', 'BEN_92209_LER_NOT_EFF_ON_STRT');

6837: if c_ler_requery%notfound then
6838: if g_debug then
6839: hr_utility.set_location('Ler not date effective on period start', 10);
6840: end if;
6841: fnd_message.set_name('BEN', 'BEN_92209_LER_NOT_EFF_ON_STRT');
6842: fnd_message.set_token('PROC', l_proc);
6843: fnd_message.set_token(
6844: 'ENRT_PERD_STRT_DT',
6845: TO_CHAR(l_rec_enrt_perd_strt_dt));

Line 6842: fnd_message.set_token('PROC', l_proc);

6838: if g_debug then
6839: hr_utility.set_location('Ler not date effective on period start', 10);
6840: end if;
6841: fnd_message.set_name('BEN', 'BEN_92209_LER_NOT_EFF_ON_STRT');
6842: fnd_message.set_token('PROC', l_proc);
6843: fnd_message.set_token(
6844: 'ENRT_PERD_STRT_DT',
6845: TO_CHAR(l_rec_enrt_perd_strt_dt));
6846: fnd_message.set_token('LER_STRT_DT', TO_CHAR(l_ler_esd));

Line 6843: fnd_message.set_token(

6839: hr_utility.set_location('Ler not date effective on period start', 10);
6840: end if;
6841: fnd_message.set_name('BEN', 'BEN_92209_LER_NOT_EFF_ON_STRT');
6842: fnd_message.set_token('PROC', l_proc);
6843: fnd_message.set_token(
6844: 'ENRT_PERD_STRT_DT',
6845: TO_CHAR(l_rec_enrt_perd_strt_dt));
6846: fnd_message.set_token('LER_STRT_DT', TO_CHAR(l_ler_esd));
6847: fnd_message.set_token('LER_END_DT', TO_CHAR(l_ler_eed));

Line 6846: fnd_message.set_token('LER_STRT_DT', TO_CHAR(l_ler_esd));

6842: fnd_message.set_token('PROC', l_proc);
6843: fnd_message.set_token(
6844: 'ENRT_PERD_STRT_DT',
6845: TO_CHAR(l_rec_enrt_perd_strt_dt));
6846: fnd_message.set_token('LER_STRT_DT', TO_CHAR(l_ler_esd));
6847: fnd_message.set_token('LER_END_DT', TO_CHAR(l_ler_eed));
6848: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6849: p_electable_flag := 'N';
6850: RETURN;

Line 6847: fnd_message.set_token('LER_END_DT', TO_CHAR(l_ler_eed));

6843: fnd_message.set_token(
6844: 'ENRT_PERD_STRT_DT',
6845: TO_CHAR(l_rec_enrt_perd_strt_dt));
6846: fnd_message.set_token('LER_STRT_DT', TO_CHAR(l_ler_esd));
6847: fnd_message.set_token('LER_END_DT', TO_CHAR(l_ler_eed));
6848: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6849: p_electable_flag := 'N';
6850: RETURN;
6851: end if;

Line 6848: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

6844: 'ENRT_PERD_STRT_DT',
6845: TO_CHAR(l_rec_enrt_perd_strt_dt));
6846: fnd_message.set_token('LER_STRT_DT', TO_CHAR(l_ler_esd));
6847: fnd_message.set_token('LER_END_DT', TO_CHAR(l_ler_eed));
6848: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
6849: p_electable_flag := 'N';
6850: RETURN;
6851: end if;
6852: close c_ler_requery;

Line 6913: fnd_message.set_name('BEN', 'BEN_91905_INVLD_CLS_ENRT_DT_CD');

6909: IF l_rec_cls_enrt_dt_to_use_cd IS NULL THEN
6910: --
6911: -- hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
6912: --
6913: fnd_message.set_name('BEN', 'BEN_91905_INVLD_CLS_ENRT_DT_CD');
6914: fnd_message.set_token('PROC', l_proc);
6915: fnd_message.set_token(
6916: 'CLS_ENRT_DT_TO_USE_CD',
6917: l_rec_cls_enrt_dt_to_use_cd);

Line 6914: fnd_message.set_token('PROC', l_proc);

6910: --
6911: -- hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
6912: --
6913: fnd_message.set_name('BEN', 'BEN_91905_INVLD_CLS_ENRT_DT_CD');
6914: fnd_message.set_token('PROC', l_proc);
6915: fnd_message.set_token(
6916: 'CLS_ENRT_DT_TO_USE_CD',
6917: l_rec_cls_enrt_dt_to_use_cd);
6918: RAISE ben_manage_life_events.g_record_error;

Line 6915: fnd_message.set_token(

6911: -- hr_utility.set_location('Invalid cls_enrt_dt_cd', 10);
6912: --
6913: fnd_message.set_name('BEN', 'BEN_91905_INVLD_CLS_ENRT_DT_CD');
6914: fnd_message.set_token('PROC', l_proc);
6915: fnd_message.set_token(
6916: 'CLS_ENRT_DT_TO_USE_CD',
6917: l_rec_cls_enrt_dt_to_use_cd);
6918: RAISE ben_manage_life_events.g_record_error;
6919: --

Line 7184: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');

7180: if g_debug then
7181: hr_utility.set_location('FND mess: ' || l_proc, 10);
7182: end if;
7183: --
7184: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7185: fnd_message.set_token('PERSON_ID', p_person_id);
7186: fnd_message.set_token('LER_NAME', l_ler_name);
7187: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7188: fnd_message.set_token('PLAN_NAME', l_pl_name);

Line 7185: fnd_message.set_token('PERSON_ID', p_person_id);

7181: hr_utility.set_location('FND mess: ' || l_proc, 10);
7182: end if;
7183: --
7184: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7185: fnd_message.set_token('PERSON_ID', p_person_id);
7186: fnd_message.set_token('LER_NAME', l_ler_name);
7187: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7188: fnd_message.set_token('PLAN_NAME', l_pl_name);
7189: fnd_message.set_token('OIPL_NAME', l_oipl_name);

Line 7186: fnd_message.set_token('LER_NAME', l_ler_name);

7182: end if;
7183: --
7184: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7185: fnd_message.set_token('PERSON_ID', p_person_id);
7186: fnd_message.set_token('LER_NAME', l_ler_name);
7187: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7188: fnd_message.set_token('PLAN_NAME', l_pl_name);
7189: fnd_message.set_token('OIPL_NAME', l_oipl_name);
7190: --

Line 7187: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);

7183: --
7184: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7185: fnd_message.set_token('PERSON_ID', p_person_id);
7186: fnd_message.set_token('LER_NAME', l_ler_name);
7187: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7188: fnd_message.set_token('PLAN_NAME', l_pl_name);
7189: fnd_message.set_token('OIPL_NAME', l_oipl_name);
7190: --
7191: if g_debug then

Line 7188: fnd_message.set_token('PLAN_NAME', l_pl_name);

7184: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7185: fnd_message.set_token('PERSON_ID', p_person_id);
7186: fnd_message.set_token('LER_NAME', l_ler_name);
7187: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7188: fnd_message.set_token('PLAN_NAME', l_pl_name);
7189: fnd_message.set_token('OIPL_NAME', l_oipl_name);
7190: --
7191: if g_debug then
7192: hr_utility.set_location('Dn FND mess: ' || l_proc, 10);

Line 7189: fnd_message.set_token('OIPL_NAME', l_oipl_name);

7185: fnd_message.set_token('PERSON_ID', p_person_id);
7186: fnd_message.set_token('LER_NAME', l_ler_name);
7187: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7188: fnd_message.set_token('PLAN_NAME', l_pl_name);
7189: fnd_message.set_token('OIPL_NAME', l_oipl_name);
7190: --
7191: if g_debug then
7192: hr_utility.set_location('Dn FND mess: ' || l_proc, 10);
7193: end if;

Line 7194: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

7190: --
7191: if g_debug then
7192: hr_utility.set_location('Dn FND mess: ' || l_proc, 10);
7193: end if;
7194: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
7195: --
7196: -- if choice is created for an oipl create one for plan it belongs to
7197: -- first find out if it already exists.
7198: --

Line 7415: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');

7411: --
7412: if g_debug then
7413: hr_utility.set_location('FND Mess: ' || l_proc, 10);
7414: end if;
7415: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7416: fnd_message.set_token('PERSON_ID', p_person_id);
7417: fnd_message.set_token('LER_NAME', l_ler_name);
7418: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7419: fnd_message.set_token('PLAN_NAME', l_pl_name);

Line 7416: fnd_message.set_token('PERSON_ID', p_person_id);

7412: if g_debug then
7413: hr_utility.set_location('FND Mess: ' || l_proc, 10);
7414: end if;
7415: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7416: fnd_message.set_token('PERSON_ID', p_person_id);
7417: fnd_message.set_token('LER_NAME', l_ler_name);
7418: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7419: fnd_message.set_token('PLAN_NAME', l_pl_name);
7420: fnd_message.set_token('OIPL_NAME', ' ');

Line 7417: fnd_message.set_token('LER_NAME', l_ler_name);

7413: hr_utility.set_location('FND Mess: ' || l_proc, 10);
7414: end if;
7415: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7416: fnd_message.set_token('PERSON_ID', p_person_id);
7417: fnd_message.set_token('LER_NAME', l_ler_name);
7418: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7419: fnd_message.set_token('PLAN_NAME', l_pl_name);
7420: fnd_message.set_token('OIPL_NAME', ' ');
7421: if g_debug then

Line 7418: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);

7414: end if;
7415: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7416: fnd_message.set_token('PERSON_ID', p_person_id);
7417: fnd_message.set_token('LER_NAME', l_ler_name);
7418: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7419: fnd_message.set_token('PLAN_NAME', l_pl_name);
7420: fnd_message.set_token('OIPL_NAME', ' ');
7421: if g_debug then
7422: hr_utility.set_location('Dn FND Mess: ' || l_proc, 10);

Line 7419: fnd_message.set_token('PLAN_NAME', l_pl_name);

7415: fnd_message.set_name('BEN', 'BEN_91736_EPE_CHC_CREATED');
7416: fnd_message.set_token('PERSON_ID', p_person_id);
7417: fnd_message.set_token('LER_NAME', l_ler_name);
7418: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7419: fnd_message.set_token('PLAN_NAME', l_pl_name);
7420: fnd_message.set_token('OIPL_NAME', ' ');
7421: if g_debug then
7422: hr_utility.set_location('Dn FND Mess: ' || l_proc, 10);
7423: end if;

Line 7420: fnd_message.set_token('OIPL_NAME', ' ');

7416: fnd_message.set_token('PERSON_ID', p_person_id);
7417: fnd_message.set_token('LER_NAME', l_ler_name);
7418: fnd_message.set_token('COMP_LVL_CD', l_comp_lvl_cd);
7419: fnd_message.set_token('PLAN_NAME', l_pl_name);
7420: fnd_message.set_token('OIPL_NAME', ' ');
7421: if g_debug then
7422: hr_utility.set_location('Dn FND Mess: ' || l_proc, 10);
7423: end if;
7424: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

Line 7424: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));

7420: fnd_message.set_token('OIPL_NAME', ' ');
7421: if g_debug then
7422: hr_utility.set_location('Dn FND Mess: ' || l_proc, 10);
7423: end if;
7424: benutils.write(p_text => SUBSTR(fnd_message.get, 1, 128));
7425: if g_debug then
7426: hr_utility.set_location('Dn FND GetMess: ' || l_proc, 10);
7427: end if;
7428: --

Line 8255: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');

8251: OPEN c_asg;
8252: FETCH c_asg INTO l_asg;
8253: IF c_asg%NOTFOUND THEN
8254: CLOSE c_asg;
8255: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8256: fnd_message.set_token('PROC', l_proc);
8257: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
8258: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
8259: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 8256: fnd_message.set_token('PROC', l_proc);

8252: FETCH c_asg INTO l_asg;
8253: IF c_asg%NOTFOUND THEN
8254: CLOSE c_asg;
8255: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8256: fnd_message.set_token('PROC', l_proc);
8257: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
8258: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
8259: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
8260: RAISE ben_manage_life_events.g_record_error;

Line 8257: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

8253: IF c_asg%NOTFOUND THEN
8254: CLOSE c_asg;
8255: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8256: fnd_message.set_token('PROC', l_proc);
8257: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
8258: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
8259: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
8260: RAISE ben_manage_life_events.g_record_error;
8261: END IF;

Line 8258: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

8254: CLOSE c_asg;
8255: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8256: fnd_message.set_token('PROC', l_proc);
8257: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
8258: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
8259: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
8260: RAISE ben_manage_life_events.g_record_error;
8261: END IF;
8262: CLOSE c_asg;

Line 8259: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

8255: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
8256: fnd_message.set_token('PROC', l_proc);
8257: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
8258: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
8259: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
8260: RAISE ben_manage_life_events.g_record_error;
8261: END IF;
8262: CLOSE c_asg;
8263: IF (p_oipl_id IS NULL) THEN

Line 10188: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');

10184: --
10185: FETCH c_plip_info INTO l_use_dflt_flag;
10186: IF c_plip_info%NOTFOUND THEN
10187: --
10188: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
10189: fnd_message.set_token('PROC', l_proc);
10190: fnd_message.set_token('PGM_ID', TO_CHAR(l_pgm_id));
10191: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
10192: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

Line 10189: fnd_message.set_token('PROC', l_proc);

10185: FETCH c_plip_info INTO l_use_dflt_flag;
10186: IF c_plip_info%NOTFOUND THEN
10187: --
10188: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
10189: fnd_message.set_token('PROC', l_proc);
10190: fnd_message.set_token('PGM_ID', TO_CHAR(l_pgm_id));
10191: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
10192: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
10193: RAISE ben_manage_life_events.g_record_error;

Line 10190: fnd_message.set_token('PGM_ID', TO_CHAR(l_pgm_id));

10186: IF c_plip_info%NOTFOUND THEN
10187: --
10188: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
10189: fnd_message.set_token('PROC', l_proc);
10190: fnd_message.set_token('PGM_ID', TO_CHAR(l_pgm_id));
10191: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
10192: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
10193: RAISE ben_manage_life_events.g_record_error;
10194: --

Line 10191: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));

10187: --
10188: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
10189: fnd_message.set_token('PROC', l_proc);
10190: fnd_message.set_token('PGM_ID', TO_CHAR(l_pgm_id));
10191: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
10192: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
10193: RAISE ben_manage_life_events.g_record_error;
10194: --
10195: END IF;

Line 10192: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));

10188: fnd_message.set_name('BEN', 'BEN_91461_PLIP_MISSING');
10189: fnd_message.set_token('PROC', l_proc);
10190: fnd_message.set_token('PGM_ID', TO_CHAR(l_pgm_id));
10191: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
10192: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
10193: RAISE ben_manage_life_events.g_record_error;
10194: --
10195: END IF;
10196: --

Line 10215: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');

10211: CLOSE c_asg;
10212: if g_debug then
10213: hr_utility.set_location('error', 20);
10214: end if;
10215: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
10216: fnd_message.set_token('PROC', l_proc);
10217: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
10218: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
10219: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

Line 10216: fnd_message.set_token('PROC', l_proc);

10212: if g_debug then
10213: hr_utility.set_location('error', 20);
10214: end if;
10215: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
10216: fnd_message.set_token('PROC', l_proc);
10217: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
10218: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
10219: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
10220: RAISE ben_manage_life_events.g_record_error;

Line 10217: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));

10213: hr_utility.set_location('error', 20);
10214: end if;
10215: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
10216: fnd_message.set_token('PROC', l_proc);
10217: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
10218: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
10219: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
10220: RAISE ben_manage_life_events.g_record_error;
10221: END IF;

Line 10218: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));

10214: end if;
10215: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
10216: fnd_message.set_token('PROC', l_proc);
10217: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
10218: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
10219: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
10220: RAISE ben_manage_life_events.g_record_error;
10221: END IF;
10222: CLOSE c_asg;

Line 10219: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));

10215: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
10216: fnd_message.set_token('PROC', l_proc);
10217: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
10218: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
10219: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
10220: RAISE ben_manage_life_events.g_record_error;
10221: END IF;
10222: CLOSE c_asg;
10223: --hr_utility.set_location('Before call to l_use_dflt_flag ',5550);