182: ;
183: --
184: begin
185: --
186: hr_utility.set_location('Entering: '||l_proc, 10);
187: hr_utility.set_location('LE dt : '||p_lf_evt_ocrd_dt, 10);
188: hr_utility.set_location('Ef dt : '||p_effective_date, 10);
189: --
190: -- Getting eligibility profile compensation level by eligibility profile
183: --
184: begin
185: --
186: hr_utility.set_location('Entering: '||l_proc, 10);
187: hr_utility.set_location('LE dt : '||p_lf_evt_ocrd_dt, 10);
188: hr_utility.set_location('Ef dt : '||p_effective_date, 10);
189: --
190: -- Getting eligibility profile compensation level by eligibility profile
191: -- fonm
184: begin
185: --
186: hr_utility.set_location('Entering: '||l_proc, 10);
187: hr_utility.set_location('LE dt : '||p_lf_evt_ocrd_dt, 10);
188: hr_utility.set_location('Ef dt : '||p_effective_date, 10);
189: --
190: -- Getting eligibility profile compensation level by eligibility profile
191: -- fonm
192: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
196: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
197: --
198: END IF;
199:
200: hr_utility.set_location('FONM : '||l_effective_date, 10);
201: hr_utility.set_location('per_in_ler_id : '||p_per_in_ler_id, 10);
202: --
203: ben_elp_cache.elpeoy_getcacdets
204: (p_effective_date => l_effective_date,
197: --
198: END IF;
199:
200: hr_utility.set_location('FONM : '||l_effective_date, 10);
201: hr_utility.set_location('per_in_ler_id : '||p_per_in_ler_id, 10);
202: --
203: ben_elp_cache.elpeoy_getcacdets
204: (p_effective_date => l_effective_date,
205: p_business_group_id => p_business_group_id,
340: not l_ok then
341: --
342: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EOY';
343: fnd_message.set_name('BEN','BEN_92226_EOY_ELIG_PRFL_FAIL');
344: hr_utility.set_location('Criteria Failed: '||l_proc,20);
345: raise ben_evaluate_elig_profiles.g_criteria_failed;
346: --
347: end if;
348: --
345: raise ben_evaluate_elig_profiles.g_criteria_failed;
346: --
347: end if;
348: --
349: hr_utility.set_location('Leaving :'||l_proc,20);
350: --
351: end check_elig_othr_ptip_prte;
352: --
353:
432: --
433: l_effective_date date ;
434: begin
435: --
436: hr_utility.set_location('Entering: '||l_proc, 10);
437: --
438: -- fonm
439: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
440: if ben_manage_life_events.fonm = 'Y'
442: --
443: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
444: --
445: END IF;
446: hr_utility.set_location('FONM : '||l_effective_date, 10);
447: --
448:
449: -- Getting eligibility profile compensation level by eligibility profile
450: --
454: p_eligy_prfl_id => p_eligy_prfl_id,
455: p_inst_set => l_inst_dets,
456: p_inst_count => l_inst_count);
457: --
458: hr_utility.set_location('l_inst_count: '||l_inst_count, 10);
459: --
460: if l_inst_count > 0 then
461: --
462: -- Operation
476: l_rows_found := true;
477: --
478: -- Removed the nvls to resolve execute waiting problems for
479: --
480: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);
481: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);
482: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);
483: hr_utility.set_location('p_person_id '||p_person_id,44333);
484:
477: --
478: -- Removed the nvls to resolve execute waiting problems for
479: --
480: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);
481: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);
482: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);
483: hr_utility.set_location('p_person_id '||p_person_id,44333);
484:
485: open c1
478: -- Removed the nvls to resolve execute waiting problems for
479: --
480: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);
481: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);
482: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);
483: hr_utility.set_location('p_person_id '||p_person_id,44333);
484:
485: open c1
486: (c_ptip_id => l_inst_dets(l_insttorrw_num).ptip_id
479: --
480: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);
481: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);
482: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);
483: hr_utility.set_location('p_person_id '||p_person_id,44333);
484:
485: open c1
486: (c_ptip_id => l_inst_dets(l_insttorrw_num).ptip_id
487: ,c_bgp_id => p_business_group_id
525: not l_ok then
526: --
527: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ETD';
528: fnd_message.set_name('BEN','BEN_92226_ETD_ELIG_PRFL_FAIL');
529: hr_utility.set_location('Criteria Failed: '||l_proc,20);
530: raise ben_evaluate_elig_profiles.g_criteria_failed;
531: --
532: end if;
533: --
530: raise ben_evaluate_elig_profiles.g_criteria_failed;
531: --
532: end if;
533: --
534: hr_utility.set_location('Leaving :'||l_proc,20);
535: --
536: end check_elig_dpnt_othr_ptip;
537: --
538: end ben_elpro_check_eligibility;