DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_MANAGE_LIFE_EVENTS

Line 1798: RAISE ben_manage_life_events.g_record_error;

1794: fnd_message.set_token('PROC', l_proc);
1795: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
1796: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
1797: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
1798: RAISE ben_manage_life_events.g_record_error;
1799: END IF;
1800: CLOSE c_asg;
1801: if g_debug then
1802: hr_utility.set_location('close c_asg: ' || l_proc, 10);

Line 2494: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec

2490: --
2491: -------------------------
2492:
2493: procedure enrolment_requirements
2494: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
2495: ,p_run_mode in varchar2
2496: ,p_business_group_id in number
2497: ,p_effective_date in date
2498: ,p_lf_evt_ocrd_dt in date default null

Line 3101: ben_manage_life_events.g_irec_ass_rec.assignment_id,

3097: AND l_lf_evt_ocrd_dt BETWEEN ler.effective_start_date
3098: AND ler.effective_end_date
3099: and nvl(pil.assignment_id, -9999) = decode (p_run_mode,
3100: 'I',
3101: ben_manage_life_events.g_irec_ass_rec.assignment_id,
3102: nvl(pil.assignment_id, -9999) ); -- iRec
3103: --
3104: -- Bug 2200139 Get new the per_in_ler info for the Override Election.
3105: --

Line 3641: RAISE ben_manage_life_events.g_record_error;

3637: fnd_message.set_name('BEN', 'BEN_91458_DENRR_MODE_INVALID');
3638: fnd_message.set_token('PROC', l_proc);
3639: fnd_message.set_token('MODE', p_run_mode);
3640: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3641: RAISE ben_manage_life_events.g_record_error;
3642: --
3643: END IF;
3644: --
3645: -- Get option information if an oipl_id is passed,

Line 3741: RAISE ben_manage_life_events.g_record_error;

3737: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3738: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
3739: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3740: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
3741: RAISE ben_manage_life_events.g_record_error;
3742: --
3743: END IF;
3744: --
3745: /* -- 4031733 - Cursor c_state populates l_state variable which is no longer

Line 3774: RAISE ben_manage_life_events.g_record_error;

3770: fnd_message.set_token('PROC', l_proc);
3771: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
3772: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
3773: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
3774: RAISE ben_manage_life_events.g_record_error;
3775: END IF;
3776: CLOSE c_asg;
3777: hr_utility.set_location('close c_asg: ' || l_proc, 10);
3778: --

Line 4130: RAISE ben_manage_life_events.g_record_error;

4126: fnd_message.set_token('PROC', l_proc);
4127: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4128: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
4129: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4130: RAISE ben_manage_life_events.g_record_error;
4131: --
4132: END IF;
4133: --
4134: CLOSE c_plip_info;

Line 4159: RAISE ben_manage_life_events.g_record_error;

4155: fnd_message.set_token('PROC', l_proc);
4156: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
4157: fnd_message.set_token('PL_TYP_ID', TO_CHAR(l_pl_typ_id));
4158: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4159: RAISE ben_manage_life_events.g_record_error;
4160: --
4161: END IF;
4162: --
4163: CLOSE c_ptip_info;

Line 4236: RAISE ben_manage_life_events.g_record_error;

4232: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4233: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4234: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4235: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4236: RAISE ben_manage_life_events.g_record_error;
4237: --
4238: END IF;
4239: --
4240: CLOSE c_ovrd_per_in_ler_info;

Line 4264: RAISE ben_manage_life_events.g_record_error;

4260: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
4261: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
4262: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
4263: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
4264: RAISE ben_manage_life_events.g_record_error;
4265: --
4266: END IF;
4267: --
4268: CLOSE c_per_in_ler_info;

Line 4287: RAISE ben_manage_life_events.g_record_error;

4283: IF ((c_pl_popl_yr_period_current%NOTFOUND) and (p_run_mode not in ('G','D'))) THEN
4284: --
4285: fnd_message.set_name('BEN', 'BEN_91334_PLAN_YR_PERD');
4286: fnd_message.set_token('PROC', l_proc);
4287: RAISE ben_manage_life_events.g_record_error;
4288: --
4289: END IF;
4290: --
4291: CLOSE c_pl_popl_yr_period_current;

Line 5308: RAISE ben_manage_life_events.g_record_error;

5304: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5305: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5306: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5307: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5308: RAISE ben_manage_life_events.g_record_error;
5309: END IF;
5310: --
5311: END IF; -- no enrt_perd info found.
5312: --

Line 5424: RAISE ben_manage_life_events.g_record_error;

5420: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5421: fnd_message.set_token('PGM_ENRT_TYP_CYCL_CD', l_pgme_enrt_typ_cycl_cd);
5422: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5423: fnd_message.set_token('PL_ENRT_TYP_CYCL_CD', l_ple_enrt_typ_cycl_cd);
5424: RAISE ben_manage_life_events.g_record_error;
5425: --
5426: END IF;
5427: --
5428: END IF; -- 'D' Mode

Line 5868: RAISE ben_manage_life_events.g_record_error;

5864: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
5865: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
5866: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
5867: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
5868: RAISE ben_manage_life_events.g_record_error;
5869: --
5870: END IF; -- perd found and strt_dt_cd not null
5871: --
5872: ELSIF ( p_run_mode in ( 'C', 'W') AND p_run_mode <> 'D'

Line 6049: RAISE ben_manage_life_events.g_record_error;

6045: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6046: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6047: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6048: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6049: RAISE ben_manage_life_events.g_record_error;
6050: --
6051: END IF; -- perd found and strt_dt_cd not null
6052: ELSIF (p_run_mode = 'M' AND l_unrestricted_enrt_flag = 'N') THEN -- ABS processing
6053: --

Line 6126: RAISE ben_manage_life_events.g_record_error;

6122: fnd_message.set_token('PGM_ID', TO_CHAR(p_pgm_id));
6123: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
6124: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
6125: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
6126: RAISE ben_manage_life_events.g_record_error;
6127: --
6128: END IF; -- perd found and strt_dt_cd not null
6129: --
6130: END IF; -- run mode

Line 6147: RAISE ben_manage_life_events.g_record_error;

6143: TO_CHAR(l_rec_enrt_perd_strt_dt));
6144: fnd_message.set_token(
6145: 'ENRT_PERD_END_DT',
6146: TO_CHAR(l_rec_enrt_perd_end_dt));
6147: RAISE ben_manage_life_events.g_record_error;
6148: --
6149: END IF;
6150: --
6151: -- if sched mode and l_crnt_enrt_cvg_strt_dt is not null then

Line 6784: RAISE ben_manage_life_events.g_record_error;

6780: fnd_message.set_token('PROC', l_proc);
6781: fnd_message.set_token(
6782: 'CLS_ENRT_DT_TO_USE_CD',
6783: l_rec_cls_enrt_dt_to_use_cd);
6784: RAISE ben_manage_life_events.g_record_error;
6785: --
6786: END IF;
6787: --
6788: -- We need to determine if an electable choice has been written or not

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

6849: nvl(l_oipl_trk_inelig_per_flag,'N') = 'N') ) then
6850: hr_utility.set_location('By passing creation of epe for CWB'||l_proc,10);
6851: else
6852: */
6853: if ben_manage_life_events.fonm = 'Y' then
6854: if g_debug then
6855: hr_utility.set_location('fonm cvr strt dt',100);
6856: end if;
6857: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;

Line 6857: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;

6853: if ben_manage_life_events.fonm = 'Y' then
6854: if g_debug then
6855: hr_utility.set_location('fonm cvr strt dt',100);
6856: end if;
6857: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
6858: end if;
6859: if g_debug then
6860: hr_utility.set_location('EPEC_CRE: ' || l_proc, 10);
6861: end if;

Line 8123: RAISE ben_manage_life_events.g_record_error;

8119: fnd_message.set_token('PROC', l_proc);
8120: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
8121: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
8122: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
8123: RAISE ben_manage_life_events.g_record_error;
8124: END IF;
8125: CLOSE c_asg;
8126: IF (p_oipl_id IS NULL) THEN
8127: --

Line 10039: RAISE ben_manage_life_events.g_record_error;

10035: fnd_message.set_token('PROC', l_proc);
10036: fnd_message.set_token('PGM_ID', TO_CHAR(l_pgm_id));
10037: fnd_message.set_token('PL_ID', TO_CHAR(l_pl_id));
10038: fnd_message.set_token('BG_ID', TO_CHAR(p_business_group_id));
10039: RAISE ben_manage_life_events.g_record_error;
10040: --
10041: END IF;
10042: --
10043: CLOSE c_plip_info;

Line 10066: RAISE ben_manage_life_events.g_record_error;

10062: fnd_message.set_token('PROC', l_proc);
10063: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
10064: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_lf_evt_ocrd_dt));
10065: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effective_date));
10066: RAISE ben_manage_life_events.g_record_error;
10067: END IF;
10068: CLOSE c_asg;
10069: --hr_utility.set_location('Before call to l_use_dflt_flag ',5550);
10070: if g_debug then