APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on HR_UTILITY

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

287: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
288:
289: begin
290: --
291: hr_utility.set_location('Entering: '||l_proc,10);
292: hr_utility.set_location('program : '||p_pgm_id,745);
293: hr_utility.set_location('plan : ' ||p_pl_id,745);
294: hr_utility.set_location('option : ' ||p_oipl_id,745);
295: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);

Line 292: hr_utility.set_location('program : '||p_pgm_id,745);

288:
289: begin
290: --
291: hr_utility.set_location('Entering: '||l_proc,10);
292: hr_utility.set_location('program : '||p_pgm_id,745);
293: hr_utility.set_location('plan : ' ||p_pl_id,745);
294: hr_utility.set_location('option : ' ||p_oipl_id,745);
295: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
296: hr_utility.set_location('eff date : ' ||p_effective_date,745 );

Line 293: hr_utility.set_location('plan : ' ||p_pl_id,745);

289: begin
290: --
291: hr_utility.set_location('Entering: '||l_proc,10);
292: hr_utility.set_location('program : '||p_pgm_id,745);
293: hr_utility.set_location('plan : ' ||p_pl_id,745);
294: hr_utility.set_location('option : ' ||p_oipl_id,745);
295: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
296: hr_utility.set_location('eff date : ' ||p_effective_date,745 );
297:

Line 294: hr_utility.set_location('option : ' ||p_oipl_id,745);

290: --
291: hr_utility.set_location('Entering: '||l_proc,10);
292: hr_utility.set_location('program : '||p_pgm_id,745);
293: hr_utility.set_location('plan : ' ||p_pl_id,745);
294: hr_utility.set_location('option : ' ||p_oipl_id,745);
295: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
296: hr_utility.set_location('eff date : ' ||p_effective_date,745 );
297:
298: ---- Pl ty and opt id is determined for pl type and opt validation # 2508745

Line 295: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);

291: hr_utility.set_location('Entering: '||l_proc,10);
292: hr_utility.set_location('program : '||p_pgm_id,745);
293: hr_utility.set_location('plan : ' ||p_pl_id,745);
294: hr_utility.set_location('option : ' ||p_oipl_id,745);
295: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
296: hr_utility.set_location('eff date : ' ||p_effective_date,745 );
297:
298: ---- Pl ty and opt id is determined for pl type and opt validation # 2508745
299: open c_pl_typ ;

Line 296: hr_utility.set_location('eff date : ' ||p_effective_date,745 );

292: hr_utility.set_location('program : '||p_pgm_id,745);
293: hr_utility.set_location('plan : ' ||p_pl_id,745);
294: hr_utility.set_location('option : ' ||p_oipl_id,745);
295: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
296: hr_utility.set_location('eff date : ' ||p_effective_date,745 );
297:
298: ---- Pl ty and opt id is determined for pl type and opt validation # 2508745
299: open c_pl_typ ;
300: fetch c_pl_typ into l_pl_typ_id ;

Line 307: hr_utility.set_location('option : ' ||l_opt_id,745);

303: open c_opt ;
304: fetch c_opt into l_opt_id ;
305: close c_opt ;
306:
307: hr_utility.set_location('option : ' ||l_opt_id,745);
308: hr_utility.set_location('pl type : ' ||l_pl_typ_id,745);
309:
310: if p_prev_prtt_enrt_rslt_id is not null then
311:

Line 308: hr_utility.set_location('pl type : ' ||l_pl_typ_id,745);

304: fetch c_opt into l_opt_id ;
305: close c_opt ;
306:
307: hr_utility.set_location('option : ' ||l_opt_id,745);
308: hr_utility.set_location('pl type : ' ||l_pl_typ_id,745);
309:
310: if p_prev_prtt_enrt_rslt_id is not null then
311:
312: l_rslt_id := p_prev_prtt_enrt_rslt_id ;

Line 313: hr_utility.set_location('p_prev_prtt_enrt_rslt_id after result',745 );

309:
310: if p_prev_prtt_enrt_rslt_id is not null then
311:
312: l_rslt_id := p_prev_prtt_enrt_rslt_id ;
313: hr_utility.set_location('p_prev_prtt_enrt_rslt_id after result',745 );
314: open c_previous_result_id_result ;
315: fetch c_previous_result_id_result into l_old_cvg_strt_dt ,l_pil_id;
316: if c_previous_result_id_result%notfound then
317: hr_utility.set_location('0 null : '||l_proc,745);

Line 317: hr_utility.set_location('0 null : '||l_proc,745);

313: hr_utility.set_location('p_prev_prtt_enrt_rslt_id after result',745 );
314: open c_previous_result_id_result ;
315: fetch c_previous_result_id_result into l_old_cvg_strt_dt ,l_pil_id;
316: if c_previous_result_id_result%notfound then
317: hr_utility.set_location('0 null : '||l_proc,745);
318: end if ;
319: close c_previous_result_id_result;
320:
321: else

Line 328: hr_utility.set_location('1 null : '||l_proc,745);

324: if p_oipl_id is not null then
325: open c_previous_ptip_oipl_result;
326: fetch c_previous_ptip_oipl_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
327: if c_previous_ptip_oipl_result%notfound then null;
328: hr_utility.set_location('1 null : '||l_proc,745);
329: end if;
330: close c_previous_ptip_oipl_result;
331: hr_utility.set_location('1 : '||l_proc,745);
332:

Line 331: hr_utility.set_location('1 : '||l_proc,745);

327: if c_previous_ptip_oipl_result%notfound then null;
328: hr_utility.set_location('1 null : '||l_proc,745);
329: end if;
330: close c_previous_ptip_oipl_result;
331: hr_utility.set_location('1 : '||l_proc,745);
332:
333: else
334: open c_previous_pgm_ptip_result;
335: fetch c_previous_pgm_ptip_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;

Line 339: hr_utility.set_location('2 : '||l_proc,745);

335: fetch c_previous_pgm_ptip_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
336: if c_previous_pgm_ptip_result%notfound then null;
337: end if;
338: close c_previous_pgm_ptip_result;
339: hr_utility.set_location('2 : '||l_proc,745);
340: end if;
341: else
342:
343: if p_oipl_id is not null then

Line 347: hr_utility.set_location('3 null : '||l_proc,745);

343: if p_oipl_id is not null then
344: open c_previous_pl_oipl_result;
345: fetch c_previous_pl_oipl_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
346: if c_previous_pl_oipl_result%notfound then null;
347: hr_utility.set_location('3 null : '||l_proc,745);
348: end if;
349: close c_previous_pl_oipl_result;
350: hr_utility.set_location('3 : '||l_proc,745);
351: elsif p_oipl_id is null then

Line 350: hr_utility.set_location('3 : '||l_proc,745);

346: if c_previous_pl_oipl_result%notfound then null;
347: hr_utility.set_location('3 null : '||l_proc,745);
348: end if;
349: close c_previous_pl_oipl_result;
350: hr_utility.set_location('3 : '||l_proc,745);
351: elsif p_oipl_id is null then
352: open c_previous_pl_result;
353: fetch c_previous_pl_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
354: if c_previous_pl_result%notfound then null;

Line 355: hr_utility.set_location('4 nul : '||l_proc,745);

351: elsif p_oipl_id is null then
352: open c_previous_pl_result;
353: fetch c_previous_pl_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
354: if c_previous_pl_result%notfound then null;
355: hr_utility.set_location('4 nul : '||l_proc,745);
356: end if;
357: close c_previous_pl_result;
358: hr_utility.set_location('4 : '||l_proc,745);
359: end if;

Line 358: hr_utility.set_location('4 : '||l_proc,745);

354: if c_previous_pl_result%notfound then null;
355: hr_utility.set_location('4 nul : '||l_proc,745);
356: end if;
357: close c_previous_pl_result;
358: hr_utility.set_location('4 : '||l_proc,745);
359: end if;
360: end if;
361: end if ; --- p_prev_prtt_enrt_rslt_id
362:

Line 365: hr_utility.set_location('Reinstating dependent person id',99);

361: end if ; --- p_prev_prtt_enrt_rslt_id
362:
363: if l_rslt_id is not null and l_pil_id is not null then
364:
365: hr_utility.set_location('Reinstating dependent person id',99);
366: hr_utility.set_location('pil id '|| l_pil_id ,99);
367: hr_utility.set_location('rslt id '|| l_rslt_id ,99);
368: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);
369:

Line 366: hr_utility.set_location('pil id '|| l_pil_id ,99);

362:
363: if l_rslt_id is not null and l_pil_id is not null then
364:
365: hr_utility.set_location('Reinstating dependent person id',99);
366: hr_utility.set_location('pil id '|| l_pil_id ,99);
367: hr_utility.set_location('rslt id '|| l_rslt_id ,99);
368: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);
369:
370: --- # 2623034 Find out the maximum required dpnt

Line 367: hr_utility.set_location('rslt id '|| l_rslt_id ,99);

363: if l_rslt_id is not null and l_pil_id is not null then
364:
365: hr_utility.set_location('Reinstating dependent person id',99);
366: hr_utility.set_location('pil id '|| l_pil_id ,99);
367: hr_utility.set_location('rslt id '|| l_rslt_id ,99);
368: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);
369:
370: --- # 2623034 Find out the maximum required dpnt
371: --- Validate every groep of relation match with

Line 368: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);

364:
365: hr_utility.set_location('Reinstating dependent person id',99);
366: hr_utility.set_location('pil id '|| l_pil_id ,99);
367: hr_utility.set_location('rslt id '|| l_rslt_id ,99);
368: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);
369:
370: --- # 2623034 Find out the maximum required dpnt
371: --- Validate every groep of relation match with
372:

Line 381: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );

377: fetch c_total_rqmt into l_ttl_max_num, l_ttl_no_max_flag,l_dsgn_rqmt_id,l_grp_rlshp_cd;
378: if c_total_rqmt%notfound then
379: exit ;
380: end if;
381: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
382: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );
383: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );
384: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );
385: l_tot_elig_dpnt := 0 ;

Line 382: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );

378: if c_total_rqmt%notfound then
379: exit ;
380: end if;
381: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
382: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );
383: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );
384: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );
385: l_tot_elig_dpnt := 0 ;
386: open c_tot_elig_dpnt (l_pil_id,l_rslt_id,l_dsgn_rqmt_id,l_grp_rlshp_cd) ;

Line 383: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );

379: exit ;
380: end if;
381: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
382: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );
383: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );
384: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );
385: l_tot_elig_dpnt := 0 ;
386: open c_tot_elig_dpnt (l_pil_id,l_rslt_id,l_dsgn_rqmt_id,l_grp_rlshp_cd) ;
387: fetch c_tot_elig_dpnt into l_tot_elig_dpnt ;

Line 384: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );

380: end if;
381: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
382: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );
383: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );
384: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );
385: l_tot_elig_dpnt := 0 ;
386: open c_tot_elig_dpnt (l_pil_id,l_rslt_id,l_dsgn_rqmt_id,l_grp_rlshp_cd) ;
387: fetch c_tot_elig_dpnt into l_tot_elig_dpnt ;
388: close c_tot_elig_dpnt ;

Line 389: hr_utility.set_location(' total eligible ' || l_tot_elig_dpnt, 99 );

385: l_tot_elig_dpnt := 0 ;
386: open c_tot_elig_dpnt (l_pil_id,l_rslt_id,l_dsgn_rqmt_id,l_grp_rlshp_cd) ;
387: fetch c_tot_elig_dpnt into l_tot_elig_dpnt ;
388: close c_tot_elig_dpnt ;
389: hr_utility.set_location(' total eligible ' || l_tot_elig_dpnt, 99 );
390: if l_ttl_no_max_flag = 'N' and
391: nvl(l_tot_elig_dpnt,0) > l_ttl_max_num then
392: l_tot_rqmt_allow := 'N' ;
393: -- exit ;

Line 397: hr_utility.set_location(' l_tot_rqmt_allow ' || l_tot_rqmt_allow, 99 );

393: -- exit ;
394: end if ;
395: End loop ;
396: close c_total_rqmt ;
397: hr_utility.set_location(' l_tot_rqmt_allow ' || l_tot_rqmt_allow, 99 );
398:
399:
400: if l_tot_rqmt_allow = 'Y' then
401: -- Create the dependents row.

Line 404: hr_utility.set_location('Reinstating dependent in loop ',99);

400: if l_tot_rqmt_allow = 'Y' then
401: -- Create the dependents row.
402: for l_prev_pen_dpnts in c_prev_pen_dpnts(l_rslt_id,l_pil_id) loop
403: --
404: hr_utility.set_location('Reinstating dependent in loop ',99);
405: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);
406: if p_dpnt_cvg_strt_dt_cd is null then
407: --
408: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');

Line 405: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);

401: -- Create the dependents row.
402: for l_prev_pen_dpnts in c_prev_pen_dpnts(l_rslt_id,l_pil_id) loop
403: --
404: hr_utility.set_location('Reinstating dependent in loop ',99);
405: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);
406: if p_dpnt_cvg_strt_dt_cd is null then
407: --
408: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');
409: fnd_message.raise_error;

Line 431: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);

427:
428: if l_cvg_strt_dt < p_enrt_cvg_strt_dt then
429: l_cvg_strt_dt := p_enrt_cvg_strt_dt;
430: end if;
431: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);
432: --hook the depenedent to the new enrollment result.
433: open c_epe_dpnt(p_elig_per_elctbl_chc_id,l_prev_pen_dpnts.dpnt_person_id);
434: fetch c_epe_dpnt into l_epe_dpnt_rec;
435: if c_epe_dpnt%notfound then

Line 440: hr_utility.set_location(' g_cfw_dpnt_flag '||ben_sspndd_enrollment.g_cfw_dpnt_flag,122);

436: null;
437: else
438: --
439: ben_sspndd_enrollment.g_cfw_dpnt_flag := 'Y' ;
440: hr_utility.set_location(' g_cfw_dpnt_flag '||ben_sspndd_enrollment.g_cfw_dpnt_flag,122);
441: --
442: ben_ELIG_DPNT_api.process_dependent(
443: p_elig_dpnt_id => l_epe_dpnt_rec.elig_dpnt_id,
444: p_business_group_id => p_business_group_id,

Line 456: hr_utility.set_location(' g_cfw_dpnt_flag '||ben_sspndd_enrollment.g_cfw_dpnt_flag,122);

452: p_object_version_number => l_object_version_number,
453: p_multi_row_actn => TRUE );
454: --
455: ben_sspndd_enrollment.g_cfw_dpnt_flag := 'N' ;
456: hr_utility.set_location(' g_cfw_dpnt_flag '||ben_sspndd_enrollment.g_cfw_dpnt_flag,122);
457: --
458: end if;
459: close c_epe_dpnt;
460: end loop;

Line 464: hr_utility.set_location('Leaving: '||l_proc,10);

460: end loop;
461: End if ;
462: end if;
463: --
464: hr_utility.set_location('Leaving: '||l_proc,10);
465: --
466: end reinstate_dpnt;
467:
468:

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

801:
802: --
803: begin
804: --
805: hr_utility.set_location('Entering: '||l_proc,10);
806:
807: -- a call to get the benmngle effective run date.
808: ben_env_object.get(p_rec => l_rec);
809: hr_utility.set_location('Effective date: '||l_rec.effective_date,10);

Line 809: hr_utility.set_location('Effective date: '||l_rec.effective_date,10);

805: hr_utility.set_location('Entering: '||l_proc,10);
806:
807: -- a call to get the benmngle effective run date.
808: ben_env_object.get(p_rec => l_rec);
809: hr_utility.set_location('Effective date: '||l_rec.effective_date,10);
810:
811: --
812: -- Check if we need to close the enrollment, we only do this if all
813: -- electable choices for a per_in_ler are autoutomatic.

Line 821: hr_utility.set_location('Per in Ler will not be closed : '||l_proc,10);

817: --
818: fetch c_elctbl_epe into l_dummy;
819: if c_elctbl_epe%found then
820: --
821: hr_utility.set_location('Per in Ler will not be closed : '||l_proc,10);
822: l_cls_enrt_flag := false;
823: --
824: else
825: --

Line 826: hr_utility.set_location('Per in Ler will be closed : '||l_proc,10);

822: l_cls_enrt_flag := false;
823: --
824: else
825: --
826: hr_utility.set_location('Per in Ler will be closed : '||l_proc,10);
827: l_cls_enrt_flag := true;
828: --
829: end if;
830: --

Line 873: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);

869: close c_pl_enrt_dt;
870: end if;
871: -- Get participant enrollment result information
872:
873: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
874: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
875: hr_utility.set_location('l_effective_dt'||l_effective_dt,11);
876: --
877: if l_choice_info.crntly_enrd_flag = 'Y' then

Line 874: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);

870: end if;
871: -- Get participant enrollment result information
872:
873: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
874: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
875: hr_utility.set_location('l_effective_dt'||l_effective_dt,11);
876: --
877: if l_choice_info.crntly_enrd_flag = 'Y' then
878: --

Line 875: hr_utility.set_location('l_effective_dt'||l_effective_dt,11);

871: -- Get participant enrollment result information
872:
873: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
874: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
875: hr_utility.set_location('l_effective_dt'||l_effective_dt,11);
876: --
877: if l_choice_info.crntly_enrd_flag = 'Y' then
878: --
879: open c_prtt_result(l_choice_info.prtt_enrt_rslt_id,

Line 917: hr_utility.set_location(l_proc,20);

913: --
914: -- Get benefit information
915: --
916: l_dflt_found:=false;
917: hr_utility.set_location(l_proc,20);
918: open c_bnft(l_choice_info.elig_per_elctbl_chc_id);
919: loop
920: hr_utility.set_location(l_proc,30);
921: --

Line 920: hr_utility.set_location(l_proc,30);

916: l_dflt_found:=false;
917: hr_utility.set_location(l_proc,20);
918: open c_bnft(l_choice_info.elig_per_elctbl_chc_id);
919: loop
920: hr_utility.set_location(l_proc,30);
921: --
922: fetch c_bnft into l_bnft;
923: --
924: exit when c_bnft%notfound;

Line 925: hr_utility.set_location(l_proc,40);

921: --
922: fetch c_bnft into l_bnft;
923: --
924: exit when c_bnft%notfound;
925: hr_utility.set_location(l_proc,40);
926: if l_bnft.dflt_flag='Y' then
927: hr_utility.set_location(l_proc,50);
928: l_dflt_bnft:=l_bnft;
929: l_dflt_found:=true;

Line 927: hr_utility.set_location(l_proc,50);

923: --
924: exit when c_bnft%notfound;
925: hr_utility.set_location(l_proc,40);
926: if l_bnft.dflt_flag='Y' then
927: hr_utility.set_location(l_proc,50);
928: l_dflt_bnft:=l_bnft;
929: l_dflt_found:=true;
930: end if;
931: hr_utility.set_location(l_proc,60);

Line 931: hr_utility.set_location(l_proc,60);

927: hr_utility.set_location(l_proc,50);
928: l_dflt_bnft:=l_bnft;
929: l_dflt_found:=true;
930: end if;
931: hr_utility.set_location(l_proc,60);
932: end loop;
933: hr_utility.set_location(l_proc,70);
934: close c_bnft;
935: if l_dflt_found=true then

Line 933: hr_utility.set_location(l_proc,70);

929: l_dflt_found:=true;
930: end if;
931: hr_utility.set_location(l_proc,60);
932: end loop;
933: hr_utility.set_location(l_proc,70);
934: close c_bnft;
935: if l_dflt_found=true then
936: hr_utility.set_location(l_proc,80);
937: l_bnft:=l_dflt_bnft;

Line 936: hr_utility.set_location(l_proc,80);

932: end loop;
933: hr_utility.set_location(l_proc,70);
934: close c_bnft;
935: if l_dflt_found=true then
936: hr_utility.set_location(l_proc,80);
937: l_bnft:=l_dflt_bnft;
938: end if;
939: hr_utility.set_location(l_proc,90);
940: --

Line 939: hr_utility.set_location(l_proc,90);

935: if l_dflt_found=true then
936: hr_utility.set_location(l_proc,80);
937: l_bnft:=l_dflt_bnft;
938: end if;
939: hr_utility.set_location(l_proc,90);
940: --
941: -- Get Rate information
942: --
943: for l_count in 1..10 loop

Line 993: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);

989: end if;
990: close c_pl_enrt_dt;
991: end if;
992: */
993: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
994: hr_utility.set_location('bnft_val='||l_bnft.val,13);
995: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
996: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
997: if l_bnft.cvg_mlt_cd='SAAEAR' and

Line 994: hr_utility.set_location('bnft_val='||l_bnft.val,13);

990: close c_pl_enrt_dt;
991: end if;
992: */
993: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
994: hr_utility.set_location('bnft_val='||l_bnft.val,13);
995: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
996: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
997: if l_bnft.cvg_mlt_cd='SAAEAR' and
998: l_rt_table(1).ann_rt_val is null then

Line 995: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);

991: end if;
992: */
993: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
994: hr_utility.set_location('bnft_val='||l_bnft.val,13);
995: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
996: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
997: if l_bnft.cvg_mlt_cd='SAAEAR' and
998: l_rt_table(1).ann_rt_val is null then
999: l_rt_table(1).ann_rt_val:=l_rt_table(1).dflt_val;

Line 996: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);

992: */
993: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
994: hr_utility.set_location('bnft_val='||l_bnft.val,13);
995: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
996: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
997: if l_bnft.cvg_mlt_cd='SAAEAR' and
998: l_rt_table(1).ann_rt_val is null then
999: l_rt_table(1).ann_rt_val:=l_rt_table(1).dflt_val;
1000: end if;

Line 1001: --hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);

997: if l_bnft.cvg_mlt_cd='SAAEAR' and
998: l_rt_table(1).ann_rt_val is null then
999: l_rt_table(1).ann_rt_val:=l_rt_table(1).dflt_val;
1000: end if;
1001: --hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
1002: ben_election_information.election_information
1003: (p_elig_per_elctbl_chc_id => l_choice_info.elig_per_elctbl_chc_id,
1004: p_prtt_enrt_rslt_id => l_choice_info.prtt_enrt_rslt_id,
1005: p_effective_date => l_effective_dt,

Line 1146: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);

1142: ---
1143: end if ;
1144:
1145:
1146: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);
1147: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1148:
1149: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1150:

Line 1147: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);

1143: end if ;
1144:
1145:
1146: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);
1147: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1148:
1149: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1150:
1151: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);

Line 1151: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);

1147: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1148:
1149: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1150:
1151: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
1152: -- p_effective_date is now changed to l_effective_dt , when ever LE reprocessed
1153: -- result created as on effective date and automeatic enrollment called with
1154: -- lE_ocurd_Dt as affective date so there is no result as on effective date (le_ocrd_dt)
1155: -- this is fixed sending l_effective_dt # 3042033

Line 1297: hr_utility.set_location ('inside -99999', 213);

1293: --BUG 5529696
1294:
1295: elsif (l_cls_enrt_flag and l_prev_pgm_id = -99999) then
1296: --
1297: hr_utility.set_location ('inside -99999', 213);
1298: --
1299: open c_lf_evt_ocrd_dt (l_per_in_ler_id);
1300: --
1301: fetch c_lf_evt_ocrd_dt

Line 1407: hr_utility.set_location('Leaving: '||l_proc,10);

1403: close c_choice_info;
1404: --
1405: --BUG 5529696
1406: --
1407: hr_utility.set_location('Leaving: '||l_proc,10);
1408: --
1409: end process_person;
1410: --
1411: procedure main(p_person_id in number,

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

1442: and epe.auto_enrt_flag = 'Y');
1443: --
1444: begin
1445: --
1446: hr_utility.set_location('Entering: '||l_proc,10);
1447: hr_utility.set_location('p_person_id'||p_person_id,10);
1448: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1449: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1450: hr_utility.set_location('p_mode'||p_mode,10);

Line 1447: hr_utility.set_location('p_person_id'||p_person_id,10);

1443: --
1444: begin
1445: --
1446: hr_utility.set_location('Entering: '||l_proc,10);
1447: hr_utility.set_location('p_person_id'||p_person_id,10);
1448: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1449: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1450: hr_utility.set_location('p_mode'||p_mode,10);
1451: hr_utility.set_location('p_effective_date'||p_effective_date,10);

Line 1448: hr_utility.set_location('p_ler_id'||p_ler_id,10);

1444: begin
1445: --
1446: hr_utility.set_location('Entering: '||l_proc,10);
1447: hr_utility.set_location('p_person_id'||p_person_id,10);
1448: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1449: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1450: hr_utility.set_location('p_mode'||p_mode,10);
1451: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1452: --

Line 1449: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);

1445: --
1446: hr_utility.set_location('Entering: '||l_proc,10);
1447: hr_utility.set_location('p_person_id'||p_person_id,10);
1448: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1449: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1450: hr_utility.set_location('p_mode'||p_mode,10);
1451: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1452: --
1453: -- Code only runs in Life Event or Scheduled Enrollment mode

Line 1450: hr_utility.set_location('p_mode'||p_mode,10);

1446: hr_utility.set_location('Entering: '||l_proc,10);
1447: hr_utility.set_location('p_person_id'||p_person_id,10);
1448: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1449: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1450: hr_utility.set_location('p_mode'||p_mode,10);
1451: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1452: --
1453: -- Code only runs in Life Event or Scheduled Enrollment mode
1454: -- ABSENCES : Automatic enrollments should happen for absence mode.

Line 1451: hr_utility.set_location('p_effective_date'||p_effective_date,10);

1447: hr_utility.set_location('p_person_id'||p_person_id,10);
1448: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1449: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1450: hr_utility.set_location('p_mode'||p_mode,10);
1451: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1452: --
1453: -- Code only runs in Life Event or Scheduled Enrollment mode
1454: -- ABSENCES : Automatic enrollments should happen for absence mode.
1455: --

Line 1482: hr_utility.set_location('Leaving: '||l_proc,10);

1478: end loop;
1479: --
1480: close c_person_population;
1481: --
1482: hr_utility.set_location('Leaving: '||l_proc,10);
1483: --
1484: end main;
1485: --
1486: end ben_automatic_enrollments;