DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_MANAGE_LIFE_EVENTS

Line 1825: RAISE ben_manage_life_events.g_record_error;

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
1829: hr_utility.set_location('close c_asg: ' || l_proc, 10);

Line 2521: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec

2517: --
2518: -------------------------
2519:
2520: procedure enrolment_requirements
2521: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
2522: ,p_run_mode in varchar2
2523: ,p_business_group_id in number
2524: ,p_effective_date in date
2525: ,p_lf_evt_ocrd_dt in date default null

Line 3147: ben_manage_life_events.g_irec_ass_rec.assignment_id,

3143: AND l_lf_evt_ocrd_dt BETWEEN ler.effective_start_date
3144: AND ler.effective_end_date
3145: and nvl(pil.assignment_id, -9999) = decode (p_run_mode,
3146: 'I',
3147: ben_manage_life_events.g_irec_ass_rec.assignment_id,
3148: nvl(pil.assignment_id, -9999) ); -- iRec
3149: --
3150: -- Bug 2200139 Get new the per_in_ler info for the Override Election.
3151: --

Line 3699: RAISE ben_manage_life_events.g_record_error;

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: --
3703: -- Get option information if an oipl_id is passed,

Line 3799: RAISE ben_manage_life_events.g_record_error;

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: --
3803: /* -- 4031733 - Cursor c_state populates l_state variable which is no longer

Line 3832: RAISE ben_manage_life_events.g_record_error;

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

Line 4220: RAISE ben_manage_life_events.g_record_error;

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: --
4224: CLOSE c_plip_info;

Line 4249: RAISE ben_manage_life_events.g_record_error;

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: --
4253: CLOSE c_ptip_info;

Line 4326: RAISE ben_manage_life_events.g_record_error;

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: --
4330: CLOSE c_ovrd_per_in_ler_info;

Line 4354: RAISE ben_manage_life_events.g_record_error;

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: --
4358: CLOSE c_per_in_ler_info;

Line 4377: RAISE ben_manage_life_events.g_record_error;

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: --
4381: CLOSE c_pl_popl_yr_period_current;

Line 5398: RAISE ben_manage_life_events.g_record_error;

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.
5402: --

Line 5514: RAISE ben_manage_life_events.g_record_error;

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: --
5518: END IF; -- 'D' Mode

Line 5996: RAISE ben_manage_life_events.g_record_error;

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: --
6000: ELSIF ( p_run_mode in ( 'C', 'W') AND p_run_mode <> 'D'

Line 6177: RAISE ben_manage_life_events.g_record_error;

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
6181: --

Line 6254: RAISE ben_manage_life_events.g_record_error;

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: --
6258: END IF; -- run mode

Line 6275: RAISE ben_manage_life_events.g_record_error;

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: --
6277: END IF;
6278: --
6279: -- if sched mode and l_crnt_enrt_cvg_strt_dt is not null then

Line 6918: RAISE ben_manage_life_events.g_record_error;

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: --
6920: END IF;
6921: --
6922: -- We need to determine if an electable choice has been written or not

Line 6987: if ben_manage_life_events.fonm = 'Y' then

6983: nvl(l_oipl_trk_inelig_per_flag,'N') = 'N') ) then
6984: hr_utility.set_location('By passing creation of epe for CWB'||l_proc,10);
6985: else
6986: */
6987: if ben_manage_life_events.fonm = 'Y' then
6988: if g_debug then
6989: hr_utility.set_location('fonm cvr strt dt',100);
6990: end if;
6991: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;

Line 6991: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;

6987: if ben_manage_life_events.fonm = 'Y' then
6988: if g_debug then
6989: hr_utility.set_location('fonm cvr strt dt',100);
6990: end if;
6991: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
6992: end if;
6993: if g_debug then
6994: hr_utility.set_location('EPEC_CRE: ' || l_proc, 10);
6995: end if;

Line 8260: RAISE ben_manage_life_events.g_record_error;

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
8264: --

Line 10193: RAISE ben_manage_life_events.g_record_error;

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: --
10197: CLOSE c_plip_info;

Line 10220: RAISE ben_manage_life_events.g_record_error;

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);
10224: if g_debug then