DBA Data[Home] [Help]

APPS.BEN_ELPRO_CHECK_ELIGIBILITY dependencies on HR_UTILITY

Line 184: hr_utility.set_location('Entering: '||l_proc, 10);

180: ;
181: --
182: begin
183: --
184: hr_utility.set_location('Entering: '||l_proc, 10);
185: hr_utility.set_location('LE dt : '||p_lf_evt_ocrd_dt, 10);
186: hr_utility.set_location('Ef dt : '||p_effective_date, 10);
187: hr_utility.set_location('p_per_in_ler_id : '||p_per_in_ler_id, 10);
188: --

Line 185: hr_utility.set_location('LE dt : '||p_lf_evt_ocrd_dt, 10);

181: --
182: begin
183: --
184: hr_utility.set_location('Entering: '||l_proc, 10);
185: hr_utility.set_location('LE dt : '||p_lf_evt_ocrd_dt, 10);
186: hr_utility.set_location('Ef dt : '||p_effective_date, 10);
187: hr_utility.set_location('p_per_in_ler_id : '||p_per_in_ler_id, 10);
188: --
189: -- Getting eligibility profile compensation level by eligibility profile

Line 186: hr_utility.set_location('Ef dt : '||p_effective_date, 10);

182: begin
183: --
184: hr_utility.set_location('Entering: '||l_proc, 10);
185: hr_utility.set_location('LE dt : '||p_lf_evt_ocrd_dt, 10);
186: hr_utility.set_location('Ef dt : '||p_effective_date, 10);
187: hr_utility.set_location('p_per_in_ler_id : '||p_per_in_ler_id, 10);
188: --
189: -- Getting eligibility profile compensation level by eligibility profile
190: -- fonm

Line 187: hr_utility.set_location('p_per_in_ler_id : '||p_per_in_ler_id, 10);

183: --
184: hr_utility.set_location('Entering: '||l_proc, 10);
185: hr_utility.set_location('LE dt : '||p_lf_evt_ocrd_dt, 10);
186: hr_utility.set_location('Ef dt : '||p_effective_date, 10);
187: hr_utility.set_location('p_per_in_ler_id : '||p_per_in_ler_id, 10);
188: --
189: -- Getting eligibility profile compensation level by eligibility profile
190: -- fonm
191: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;

Line 199: hr_utility.set_location('FONM : '||l_effective_date, 10);

195: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
196: --
197: END IF;
198:
199: hr_utility.set_location('FONM : '||l_effective_date, 10);
200: hr_utility.set_location('per_in_ler_id : '||p_per_in_ler_id, 10);
201: --
202: ben_elp_cache.elpeoy_getcacdets
203: (p_effective_date => l_effective_date,

Line 200: hr_utility.set_location('per_in_ler_id : '||p_per_in_ler_id, 10);

196: --
197: END IF;
198:
199: hr_utility.set_location('FONM : '||l_effective_date, 10);
200: hr_utility.set_location('per_in_ler_id : '||p_per_in_ler_id, 10);
201: --
202: ben_elp_cache.elpeoy_getcacdets
203: (p_effective_date => l_effective_date,
204: p_business_group_id => p_business_group_id,

Line 342: hr_utility.set_location('Criteria Failed: '||l_proc,20);

338: not l_ok then
339: --
340: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'EOY';
341: fnd_message.set_name('BEN','BEN_92226_EOY_ELIG_PRFL_FAIL');
342: hr_utility.set_location('Criteria Failed: '||l_proc,20);
343: raise ben_evaluate_elig_profiles.g_criteria_failed;
344: --
345: end if;
346: --

Line 347: hr_utility.set_location('Leaving :'||l_proc,20);

343: raise ben_evaluate_elig_profiles.g_criteria_failed;
344: --
345: end if;
346: --
347: hr_utility.set_location('Leaving :'||l_proc,20);
348: --
349: end check_elig_othr_ptip_prte;
350: --
351:

Line 449: hr_utility.set_location('Entering: '||l_proc, 10);

445: --
446: l_effective_date date ;
447: begin
448: --
449: hr_utility.set_location('Entering: '||l_proc, 10);
450: --
451: -- fonm
452: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date) ;
453: if ben_manage_life_events.fonm = 'Y'

Line 459: hr_utility.set_location('FONM : '||l_effective_date, 10);

455: --
456: l_effective_date := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,l_effective_date);
457: --
458: END IF;
459: hr_utility.set_location('FONM : '||l_effective_date, 10);
460: --
461:
462: -- Getting eligibility profile compensation level by eligibility profile
463: --

Line 471: hr_utility.set_location('l_inst_count: '||l_inst_count, 10);

467: p_eligy_prfl_id => p_eligy_prfl_id,
468: p_inst_set => l_inst_dets,
469: p_inst_count => l_inst_count);
470: --
471: hr_utility.set_location('l_inst_count: '||l_inst_count, 10);
472: --
473: if l_inst_count > 0 then
474: --
475: -- Operation

Line 493: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);

489: l_rows_found := true;
490: --
491: -- Removed the nvls to resolve execute waiting problems for
492: --
493: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);
494: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);
495: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);
496: hr_utility.set_location('p_person_id '||p_person_id,44333);
497:

Line 494: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);

490: --
491: -- Removed the nvls to resolve execute waiting problems for
492: --
493: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);
494: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);
495: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);
496: hr_utility.set_location('p_person_id '||p_person_id,44333);
497:
498: open c1

Line 495: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);

491: -- Removed the nvls to resolve execute waiting problems for
492: --
493: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);
494: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);
495: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);
496: hr_utility.set_location('p_person_id '||p_person_id,44333);
497:
498: open c1
499: (c_ptip_id => l_inst_dets(l_insttorrw_num).ptip_id

Line 496: hr_utility.set_location('p_person_id '||p_person_id,44333);

492: --
493: hr_utility.set_location('ptip_id '|| l_inst_dets(l_insttorrw_num).ptip_id,44333);
494: hr_utility.set_location('p_business_group_id '||p_business_group_id,44333);
495: hr_utility.set_location('l_effective_date'||l_effective_date, 44333);
496: hr_utility.set_location('p_person_id '||p_person_id,44333);
497:
498: open c1
499: (c_ptip_id => l_inst_dets(l_insttorrw_num).ptip_id
500: ,c_bgp_id => p_business_group_id

Line 542: hr_utility.set_location('Criteria Failed: '||l_proc,20);

538: not l_ok then
539: --
540: ben_evaluate_elig_profiles.g_inelg_rsn_cd := 'ETD';
541: fnd_message.set_name('BEN','BEN_92226_ETD_ELIG_PRFL_FAIL');
542: hr_utility.set_location('Criteria Failed: '||l_proc,20);
543: raise ben_evaluate_elig_profiles.g_criteria_failed;
544: --
545: end if;
546: --

Line 547: hr_utility.set_location('Leaving :'||l_proc,20);

543: raise ben_evaluate_elig_profiles.g_criteria_failed;
544: --
545: end if;
546: --
547: hr_utility.set_location('Leaving :'||l_proc,20);
548: --
549: end check_elig_dpnt_othr_ptip;
550: --
551: end ben_elpro_check_eligibility;