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 866: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);

862: close c_pl_enrt_dt;
863: end if;
864: -- Get participant enrollment result information
865:
866: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
867: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
868: hr_utility.set_location('l_effective_dt'||l_effective_dt,11);
869: --
870: if l_choice_info.crntly_enrd_flag = 'Y' then

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

863: end if;
864: -- Get participant enrollment result information
865:
866: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
867: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
868: hr_utility.set_location('l_effective_dt'||l_effective_dt,11);
869: --
870: if l_choice_info.crntly_enrd_flag = 'Y' then
871: --

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

864: -- Get participant enrollment result information
865:
866: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
867: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
868: hr_utility.set_location('l_effective_dt'||l_effective_dt,11);
869: --
870: if l_choice_info.crntly_enrd_flag = 'Y' then
871: --
872: open c_prtt_result(l_choice_info.prtt_enrt_rslt_id,

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

906: --
907: -- Get benefit information
908: --
909: l_dflt_found:=false;
910: hr_utility.set_location(l_proc,20);
911: open c_bnft(l_choice_info.elig_per_elctbl_chc_id);
912: loop
913: hr_utility.set_location(l_proc,30);
914: --

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

909: l_dflt_found:=false;
910: hr_utility.set_location(l_proc,20);
911: open c_bnft(l_choice_info.elig_per_elctbl_chc_id);
912: loop
913: hr_utility.set_location(l_proc,30);
914: --
915: fetch c_bnft into l_bnft;
916: --
917: exit when c_bnft%notfound;

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

914: --
915: fetch c_bnft into l_bnft;
916: --
917: exit when c_bnft%notfound;
918: hr_utility.set_location(l_proc,40);
919: if l_bnft.dflt_flag='Y' then
920: hr_utility.set_location(l_proc,50);
921: l_dflt_bnft:=l_bnft;
922: l_dflt_found:=true;

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

916: --
917: exit when c_bnft%notfound;
918: hr_utility.set_location(l_proc,40);
919: if l_bnft.dflt_flag='Y' then
920: hr_utility.set_location(l_proc,50);
921: l_dflt_bnft:=l_bnft;
922: l_dflt_found:=true;
923: end if;
924: hr_utility.set_location(l_proc,60);

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

920: hr_utility.set_location(l_proc,50);
921: l_dflt_bnft:=l_bnft;
922: l_dflt_found:=true;
923: end if;
924: hr_utility.set_location(l_proc,60);
925: end loop;
926: hr_utility.set_location(l_proc,70);
927: close c_bnft;
928: if l_dflt_found=true then

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

922: l_dflt_found:=true;
923: end if;
924: hr_utility.set_location(l_proc,60);
925: end loop;
926: hr_utility.set_location(l_proc,70);
927: close c_bnft;
928: if l_dflt_found=true then
929: hr_utility.set_location(l_proc,80);
930: l_bnft:=l_dflt_bnft;

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

925: end loop;
926: hr_utility.set_location(l_proc,70);
927: close c_bnft;
928: if l_dflt_found=true then
929: hr_utility.set_location(l_proc,80);
930: l_bnft:=l_dflt_bnft;
931: end if;
932: hr_utility.set_location(l_proc,90);
933: --

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

928: if l_dflt_found=true then
929: hr_utility.set_location(l_proc,80);
930: l_bnft:=l_dflt_bnft;
931: end if;
932: hr_utility.set_location(l_proc,90);
933: --
934: -- Get Rate information
935: --
936: for l_count in 1..10 loop

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

982: end if;
983: close c_pl_enrt_dt;
984: end if;
985: */
986: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
987: hr_utility.set_location('bnft_val='||l_bnft.val,13);
988: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
989: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
990: if l_bnft.cvg_mlt_cd='SAAEAR' and

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

983: close c_pl_enrt_dt;
984: end if;
985: */
986: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
987: hr_utility.set_location('bnft_val='||l_bnft.val,13);
988: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
989: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
990: if l_bnft.cvg_mlt_cd='SAAEAR' and
991: l_rt_table(1).ann_rt_val is null then

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

984: end if;
985: */
986: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
987: hr_utility.set_location('bnft_val='||l_bnft.val,13);
988: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
989: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
990: if l_bnft.cvg_mlt_cd='SAAEAR' and
991: l_rt_table(1).ann_rt_val is null then
992: l_rt_table(1).ann_rt_val:=l_rt_table(1).dflt_val;

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

985: */
986: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
987: hr_utility.set_location('bnft_val='||l_bnft.val,13);
988: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
989: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
990: if l_bnft.cvg_mlt_cd='SAAEAR' and
991: l_rt_table(1).ann_rt_val is null then
992: l_rt_table(1).ann_rt_val:=l_rt_table(1).dflt_val;
993: end if;

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

990: if l_bnft.cvg_mlt_cd='SAAEAR' and
991: l_rt_table(1).ann_rt_val is null then
992: l_rt_table(1).ann_rt_val:=l_rt_table(1).dflt_val;
993: end if;
994: --hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
995: ben_election_information.election_information
996: (p_elig_per_elctbl_chc_id => l_choice_info.elig_per_elctbl_chc_id,
997: p_prtt_enrt_rslt_id => l_choice_info.prtt_enrt_rslt_id,
998: p_effective_date => l_effective_dt,

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

1135: ---
1136: end if ;
1137:
1138:
1139: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);
1140: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1141:
1142: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1143:

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

1136: end if ;
1137:
1138:
1139: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);
1140: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1141:
1142: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1143:
1144: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);

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

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

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

1286: --BUG 5529696
1287:
1288: elsif (l_cls_enrt_flag and l_prev_pgm_id = -99999) then
1289: --
1290: hr_utility.set_location ('inside -99999', 213);
1291: --
1292: open c_lf_evt_ocrd_dt (l_per_in_ler_id);
1293: --
1294: fetch c_lf_evt_ocrd_dt

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

1396: close c_choice_info;
1397: --
1398: --BUG 5529696
1399: --
1400: hr_utility.set_location('Leaving: '||l_proc,10);
1401: --
1402: end process_person;
1403: --
1404: procedure main(p_person_id in number,

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

1435: and epe.auto_enrt_flag = 'Y');
1436: --
1437: begin
1438: --
1439: hr_utility.set_location('Entering: '||l_proc,10);
1440: hr_utility.set_location('p_person_id'||p_person_id,10);
1441: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1442: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1443: hr_utility.set_location('p_mode'||p_mode,10);

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

1436: --
1437: begin
1438: --
1439: hr_utility.set_location('Entering: '||l_proc,10);
1440: hr_utility.set_location('p_person_id'||p_person_id,10);
1441: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1442: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1443: hr_utility.set_location('p_mode'||p_mode,10);
1444: hr_utility.set_location('p_effective_date'||p_effective_date,10);

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

1437: begin
1438: --
1439: hr_utility.set_location('Entering: '||l_proc,10);
1440: hr_utility.set_location('p_person_id'||p_person_id,10);
1441: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1442: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1443: hr_utility.set_location('p_mode'||p_mode,10);
1444: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1445: --

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

1438: --
1439: hr_utility.set_location('Entering: '||l_proc,10);
1440: hr_utility.set_location('p_person_id'||p_person_id,10);
1441: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1442: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1443: hr_utility.set_location('p_mode'||p_mode,10);
1444: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1445: --
1446: -- Code only runs in Life Event or Scheduled Enrollment mode

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

1439: hr_utility.set_location('Entering: '||l_proc,10);
1440: hr_utility.set_location('p_person_id'||p_person_id,10);
1441: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1442: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1443: hr_utility.set_location('p_mode'||p_mode,10);
1444: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1445: --
1446: -- Code only runs in Life Event or Scheduled Enrollment mode
1447: -- ABSENCES : Automatic enrollments should happen for absence mode.

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

1440: hr_utility.set_location('p_person_id'||p_person_id,10);
1441: hr_utility.set_location('p_ler_id'||p_ler_id,10);
1442: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1443: hr_utility.set_location('p_mode'||p_mode,10);
1444: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1445: --
1446: -- Code only runs in Life Event or Scheduled Enrollment mode
1447: -- ABSENCES : Automatic enrollments should happen for absence mode.
1448: --

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

1471: end loop;
1472: --
1473: close c_person_population;
1474: --
1475: hr_utility.set_location('Leaving: '||l_proc,10);
1476: --
1477: end main;
1478: --
1479: end ben_automatic_enrollments;