eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CARRY_FORWARD_ITEMS dependencies on HR_UTILITY

Line 158: -- hr_utility.trace_on(null,'trace');

154: l_dummy_date date;
155: l_prev_popl_id number := -1;
156:
157: begin
158: -- hr_utility.trace_on(null,'trace');
159: hr_utility.set_location('Entering '||l_proc,1);
160: hr_utility.set_location('p_effective_date '||p_effective_date,10);
161: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
162: g_debug := hr_utility.debug_enabled;

Line 159: hr_utility.set_location('Entering '||l_proc,1);

155: l_prev_popl_id number := -1;
156:
157: begin
158: -- hr_utility.trace_on(null,'trace');
159: hr_utility.set_location('Entering '||l_proc,1);
160: hr_utility.set_location('p_effective_date '||p_effective_date,10);
161: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
162: g_debug := hr_utility.debug_enabled;
163: --

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

156:
157: begin
158: -- hr_utility.trace_on(null,'trace');
159: hr_utility.set_location('Entering '||l_proc,1);
160: hr_utility.set_location('p_effective_date '||p_effective_date,10);
161: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
162: g_debug := hr_utility.debug_enabled;
163: --
164: l_effective_date := p_lf_evt_ocrd_dt;

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

157: begin
158: -- hr_utility.trace_on(null,'trace');
159: hr_utility.set_location('Entering '||l_proc,1);
160: hr_utility.set_location('p_effective_date '||p_effective_date,10);
161: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
162: g_debug := hr_utility.debug_enabled;
163: --
164: l_effective_date := p_lf_evt_ocrd_dt;
165: --

Line 162: g_debug := hr_utility.debug_enabled;

158: -- hr_utility.trace_on(null,'trace');
159: hr_utility.set_location('Entering '||l_proc,1);
160: hr_utility.set_location('p_effective_date '||p_effective_date,10);
161: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
162: g_debug := hr_utility.debug_enabled;
163: --
164: l_effective_date := p_lf_evt_ocrd_dt;
165: --
166: open c_pen;

Line 205: hr_utility.set_location('Delete A1'||l_pen_rec.prtt_enrt_rslt_id ,10);

201: l_datetrack_mode := hr_api.g_zap;
202: end if;
203:
204: l_pea_effective_date := greatest(l_effective_date-1,l_act_sus.effective_start_date);
205: hr_utility.set_location('Delete A1'||l_pen_rec.prtt_enrt_rslt_id ,10);
206:
207: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
208: (p_prtt_enrt_actn_id => l_act_sus.prtt_enrt_actn_id
209: ,p_business_group_id => p_business_group_id

Line 226: hr_utility.set_location ('Expired action items exist ..',10);

222: close c_get_actn_items_sus;
223: --
224: if l_act_item_expired THEN
225: --
226: hr_utility.set_location ('Expired action items exist ..',10);
227: open c_min_max_date (l_pen_rec.prtt_enrt_rslt_id);
228: fetch c_min_max_date into l_min_start_date,l_max_end_date;
229: close c_min_max_date;
230: --

Line 238: hr_utility.set_location('delete_enrollment 1'||l_pen_rec.prtt_enrt_rslt_id,10);

234:
235: if l_min_start_date <= l_effective_date and
236: l_max_end_date > l_effective_date
237: then
238: hr_utility.set_location('delete_enrollment 1'||l_pen_rec.prtt_enrt_rslt_id,10);
239: ben_prtt_enrt_result_api.delete_enrollment
240: (p_prtt_enrt_rslt_id => l_pen_rec.prtt_enrt_rslt_id
241: ,p_per_in_ler_id => p_per_in_ler_id
242: ,p_business_group_id => p_business_group_id

Line 251: hr_utility.set_location('delete_enrollment 2'

247: ,p_datetrack_mode => hr_api.g_delete
248: ,p_multi_row_validate => false --BUG 4718599 to be in sync with inelig
249: ,p_source => 'beninelg');
250: else
251: hr_utility.set_location('delete_enrollment 2'
252: ||l_pen_rec.prtt_enrt_rslt_id,10);
253: ben_prtt_enrt_result_api.delete_enrollment
254: (p_prtt_enrt_rslt_id => l_pen_rec.prtt_enrt_rslt_id
255: ,p_per_in_ler_id => p_per_in_ler_id

Line 293: hr_utility.set_location('OPtional delete_prtt_enrt_actn'||

289: l_object_version_number := l_pea_rec.object_version_number;
290: --
291: if l_pea_effective_date <> l_pea_rec.effective_end_date then
292: --
293: hr_utility.set_location('OPtional delete_prtt_enrt_actn'||
294: l_pea_rec.prtt_enrt_actn_id,10);
295: ben_prtt_enrt_actn_api.delete_prtt_enrt_actn
296: (p_prtt_enrt_actn_id => l_pea_rec.prtt_enrt_actn_id
297: ,p_business_group_id => p_business_group_id

Line 307: hr_utility.set_location('prtt_enrt_actn_id:'||

303: ,p_unsuspend_enrt_flag => 'N'
304: ,p_effective_start_date => l_effective_start_date
305: ,p_effective_end_date => l_effective_end_date);
306: --
307: hr_utility.set_location('prtt_enrt_actn_id:'||
308: l_pea_rec.prtt_enrt_actn_id, 10);
309: end if;
310: --
311: end loop;

Line 313: hr_utility.set_location('Leaving '||l_proc,1);

309: end if;
310: --
311: end loop;
312:
313: hr_utility.set_location('Leaving '||l_proc,1);
314:
315: end main;
316:
317: procedure reinstate_dpnt(p_pgm_id in number,

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

579: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
580:
581: begin
582: --
583: hr_utility.set_location('Entering: '||l_proc,10);
584: hr_utility.set_location('program : '||p_pgm_id,745);
585: hr_utility.set_location('plan : ' ||p_pl_id,745);
586: hr_utility.set_location('option : ' ||p_oipl_id,745);
587: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);

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

580:
581: begin
582: --
583: hr_utility.set_location('Entering: '||l_proc,10);
584: hr_utility.set_location('program : '||p_pgm_id,745);
585: hr_utility.set_location('plan : ' ||p_pl_id,745);
586: hr_utility.set_location('option : ' ||p_oipl_id,745);
587: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
588: hr_utility.set_location('eff date : ' ||p_effective_date,745 );

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

581: begin
582: --
583: hr_utility.set_location('Entering: '||l_proc,10);
584: hr_utility.set_location('program : '||p_pgm_id,745);
585: hr_utility.set_location('plan : ' ||p_pl_id,745);
586: hr_utility.set_location('option : ' ||p_oipl_id,745);
587: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
588: hr_utility.set_location('eff date : ' ||p_effective_date,745 );
589:

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

582: --
583: hr_utility.set_location('Entering: '||l_proc,10);
584: hr_utility.set_location('program : '||p_pgm_id,745);
585: hr_utility.set_location('plan : ' ||p_pl_id,745);
586: hr_utility.set_location('option : ' ||p_oipl_id,745);
587: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
588: hr_utility.set_location('eff date : ' ||p_effective_date,745 );
589:
590: ---- Pl ty and opt id is determined for pl type and opt validation # 2508745

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

583: hr_utility.set_location('Entering: '||l_proc,10);
584: hr_utility.set_location('program : '||p_pgm_id,745);
585: hr_utility.set_location('plan : ' ||p_pl_id,745);
586: hr_utility.set_location('option : ' ||p_oipl_id,745);
587: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
588: hr_utility.set_location('eff date : ' ||p_effective_date,745 );
589:
590: ---- Pl ty and opt id is determined for pl type and opt validation # 2508745
591: open c_pl_typ ;

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

584: hr_utility.set_location('program : '||p_pgm_id,745);
585: hr_utility.set_location('plan : ' ||p_pl_id,745);
586: hr_utility.set_location('option : ' ||p_oipl_id,745);
587: hr_utility.set_location('p_elig_per_elctbl_chc_id : ' ||p_elig_per_elctbl_chc_id,745);
588: hr_utility.set_location('eff date : ' ||p_effective_date,745 );
589:
590: ---- Pl ty and opt id is determined for pl type and opt validation # 2508745
591: open c_pl_typ ;
592: fetch c_pl_typ into l_pl_typ_id ;

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

595: open c_opt ;
596: fetch c_opt into l_opt_id ;
597: close c_opt ;
598:
599: hr_utility.set_location('option : ' ||l_opt_id,745);
600: hr_utility.set_location('pl type : ' ||l_pl_typ_id,745);
601:
602: if p_prev_prtt_enrt_rslt_id is not null then
603:

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

596: fetch c_opt into l_opt_id ;
597: close c_opt ;
598:
599: hr_utility.set_location('option : ' ||l_opt_id,745);
600: hr_utility.set_location('pl type : ' ||l_pl_typ_id,745);
601:
602: if p_prev_prtt_enrt_rslt_id is not null then
603:
604: l_rslt_id := p_prev_prtt_enrt_rslt_id ;

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

601:
602: if p_prev_prtt_enrt_rslt_id is not null then
603:
604: l_rslt_id := p_prev_prtt_enrt_rslt_id ;
605: hr_utility.set_location('p_prev_prtt_enrt_rslt_id after result',745 );
606: open c_previous_result_id_result ;
607: fetch c_previous_result_id_result into l_old_cvg_strt_dt ,l_pil_id;
608: if c_previous_result_id_result%notfound then
609: hr_utility.set_location('0 null : '||l_proc,745);

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

605: hr_utility.set_location('p_prev_prtt_enrt_rslt_id after result',745 );
606: open c_previous_result_id_result ;
607: fetch c_previous_result_id_result into l_old_cvg_strt_dt ,l_pil_id;
608: if c_previous_result_id_result%notfound then
609: hr_utility.set_location('0 null : '||l_proc,745);
610: end if ;
611: close c_previous_result_id_result;
612:
613: else

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

616: if p_oipl_id is not null then
617: open c_previous_ptip_oipl_result;
618: fetch c_previous_ptip_oipl_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
619: if c_previous_ptip_oipl_result%notfound then null;
620: hr_utility.set_location('1 null : '||l_proc,745);
621: end if;
622: close c_previous_ptip_oipl_result;
623: hr_utility.set_location('1 : '||l_proc,745);
624:

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

619: if c_previous_ptip_oipl_result%notfound then null;
620: hr_utility.set_location('1 null : '||l_proc,745);
621: end if;
622: close c_previous_ptip_oipl_result;
623: hr_utility.set_location('1 : '||l_proc,745);
624:
625: else
626: open c_previous_pgm_ptip_result;
627: fetch c_previous_pgm_ptip_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;

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

627: fetch c_previous_pgm_ptip_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
628: if c_previous_pgm_ptip_result%notfound then null;
629: end if;
630: close c_previous_pgm_ptip_result;
631: hr_utility.set_location('2 : '||l_proc,745);
632: end if;
633: else
634:
635: if p_oipl_id is not null then

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

635: if p_oipl_id is not null then
636: open c_previous_pl_oipl_result;
637: fetch c_previous_pl_oipl_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
638: if c_previous_pl_oipl_result%notfound then null;
639: hr_utility.set_location('3 null : '||l_proc,745);
640: end if;
641: close c_previous_pl_oipl_result;
642: hr_utility.set_location('3 : '||l_proc,745);
643: elsif p_oipl_id is null then

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

638: if c_previous_pl_oipl_result%notfound then null;
639: hr_utility.set_location('3 null : '||l_proc,745);
640: end if;
641: close c_previous_pl_oipl_result;
642: hr_utility.set_location('3 : '||l_proc,745);
643: elsif p_oipl_id is null then
644: open c_previous_pl_result;
645: fetch c_previous_pl_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
646: if c_previous_pl_result%notfound then null;

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

643: elsif p_oipl_id is null then
644: open c_previous_pl_result;
645: fetch c_previous_pl_result into l_rslt_id,l_old_cvg_strt_dt ,l_pil_id;
646: if c_previous_pl_result%notfound then null;
647: hr_utility.set_location('4 nul : '||l_proc,745);
648: end if;
649: close c_previous_pl_result;
650: hr_utility.set_location('4 : '||l_proc,745);
651: end if;

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

646: if c_previous_pl_result%notfound then null;
647: hr_utility.set_location('4 nul : '||l_proc,745);
648: end if;
649: close c_previous_pl_result;
650: hr_utility.set_location('4 : '||l_proc,745);
651: end if;
652: end if;
653: end if ; --- p_prev_prtt_enrt_rslt_id
654:

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

653: end if ; --- p_prev_prtt_enrt_rslt_id
654:
655: if l_rslt_id is not null and l_pil_id is not null then
656:
657: hr_utility.set_location('Reinstating dependent person id',99);
658: hr_utility.set_location('pil id '|| l_pil_id ,99);
659: hr_utility.set_location('rslt id '|| l_rslt_id ,99);
660: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);
661:

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

654:
655: if l_rslt_id is not null and l_pil_id is not null then
656:
657: hr_utility.set_location('Reinstating dependent person id',99);
658: hr_utility.set_location('pil id '|| l_pil_id ,99);
659: hr_utility.set_location('rslt id '|| l_rslt_id ,99);
660: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);
661:
662: --- # 2623034 Find out the maximum required dpnt

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

655: if l_rslt_id is not null and l_pil_id is not null then
656:
657: hr_utility.set_location('Reinstating dependent person id',99);
658: hr_utility.set_location('pil id '|| l_pil_id ,99);
659: hr_utility.set_location('rslt id '|| l_rslt_id ,99);
660: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);
661:
662: --- # 2623034 Find out the maximum required dpnt
663: --- Validate every groep of relation match with

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

656:
657: hr_utility.set_location('Reinstating dependent person id',99);
658: hr_utility.set_location('pil id '|| l_pil_id ,99);
659: hr_utility.set_location('rslt id '|| l_rslt_id ,99);
660: hr_utility.set_location('cvg start '|| l_old_cvg_strt_dt ,99);
661:
662: --- # 2623034 Find out the maximum required dpnt
663: --- Validate every groep of relation match with
664:

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

669: fetch c_total_rqmt into l_ttl_max_num, l_ttl_no_max_flag,l_dsgn_rqmt_id,l_grp_rlshp_cd;
670: if c_total_rqmt%notfound then
671: exit ;
672: end if;
673: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
674: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );
675: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );
676: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );
677: l_tot_elig_dpnt := 0 ;

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

670: if c_total_rqmt%notfound then
671: exit ;
672: end if;
673: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
674: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );
675: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );
676: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );
677: l_tot_elig_dpnt := 0 ;
678: open c_tot_elig_dpnt (l_pil_id,l_rslt_id,l_dsgn_rqmt_id,l_grp_rlshp_cd) ;

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

671: exit ;
672: end if;
673: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
674: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );
675: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );
676: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );
677: l_tot_elig_dpnt := 0 ;
678: open c_tot_elig_dpnt (l_pil_id,l_rslt_id,l_dsgn_rqmt_id,l_grp_rlshp_cd) ;
679: fetch c_tot_elig_dpnt into l_tot_elig_dpnt ;

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

672: end if;
673: hr_utility.set_location(' grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
674: hr_utility.set_location(' l_dsgn_rqmt_id ' || l_dsgn_rqmt_id, 99 );
675: hr_utility.set_location(' ttl_no_max_flag ' || l_ttl_no_max_flag, 99 );
676: hr_utility.set_location(' ttl_max_num ' || l_ttl_max_num, 99 );
677: l_tot_elig_dpnt := 0 ;
678: open c_tot_elig_dpnt (l_pil_id,l_rslt_id,l_dsgn_rqmt_id,l_grp_rlshp_cd) ;
679: fetch c_tot_elig_dpnt into l_tot_elig_dpnt ;
680: close c_tot_elig_dpnt ;

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

677: l_tot_elig_dpnt := 0 ;
678: open c_tot_elig_dpnt (l_pil_id,l_rslt_id,l_dsgn_rqmt_id,l_grp_rlshp_cd) ;
679: fetch c_tot_elig_dpnt into l_tot_elig_dpnt ;
680: close c_tot_elig_dpnt ;
681: hr_utility.set_location(' total eligible ' || l_tot_elig_dpnt, 99 );
682: if l_ttl_no_max_flag = 'N' and
683: nvl(l_tot_elig_dpnt,0) > l_ttl_max_num then
684: l_tot_rqmt_allow := 'N' ;
685: -- exit ;

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

685: -- exit ;
686: end if ;
687: End loop ;
688: close c_total_rqmt ;
689: hr_utility.set_location(' l_tot_rqmt_allow ' || l_tot_rqmt_allow, 99 );
690:
691:
692: if l_tot_rqmt_allow = 'Y' then
693: -- Create the dependents row.

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

692: if l_tot_rqmt_allow = 'Y' then
693: -- Create the dependents row.
694: for l_prev_pen_dpnts in c_prev_pen_dpnts(l_rslt_id,l_pil_id) loop
695: --
696: hr_utility.set_location('Reinstating dependent in loop ',99);
697: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);
698: if p_dpnt_cvg_strt_dt_cd is null then
699: --
700: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');

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

693: -- Create the dependents row.
694: for l_prev_pen_dpnts in c_prev_pen_dpnts(l_rslt_id,l_pil_id) loop
695: --
696: hr_utility.set_location('Reinstating dependent in loop ',99);
697: hr_utility.set_location('p_dpnt_cvg_strt_dt_cd '|| p_dpnt_cvg_strt_dt_cd,99);
698: if p_dpnt_cvg_strt_dt_cd is null then
699: --
700: fnd_message.set_name('BEN','BEN_92558_DPNT_CVG_CD');
701: fnd_message.raise_error;

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

719:
720: if l_cvg_strt_dt < p_enrt_cvg_strt_dt then
721: l_cvg_strt_dt := p_enrt_cvg_strt_dt;
722: end if;
723: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);
724: --hook the depenedent to the new enrollment result.
725: open c_epe_dpnt(p_elig_per_elctbl_chc_id,l_prev_pen_dpnts.dpnt_person_id);
726: fetch c_epe_dpnt into l_epe_dpnt_rec;
727: if c_epe_dpnt%notfound then

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

744: end loop;
745: End if ;
746: end if;
747: --
748: hr_utility.set_location('Leaving: '||l_proc,10);
749: --
750: end reinstate_dpnt;
751: --
752: ----------------------------------------------------------------------------------------

Line 810: hr_utility.set_location('Entering reinstate_prvdd_ctfn_items ', 10);

806: begin
807: --
808: l_effective_date := p_effective_date;
809: if (g_debug) then
810: hr_utility.set_location('Entering reinstate_prvdd_ctfn_items ', 10);
811: end if;
812: --
813: for l_prvdd_ctfns in c_prvdd_ctfns_past_pil
814: loop

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

813: for l_prvdd_ctfns in c_prvdd_ctfns_past_pil
814: loop
815: --
816: if (g_debug) then
817: hr_utility.set_location('l_effective_date ' || l_effective_date, 10);
818: hr_utility.set_location('l_prvdd_ctfns.effective_start_date ' || l_prvdd_ctfns.effective_start_date, 10);
819: hr_utility.set_location('l_prvdd_ctfns.effective_end_date ' || l_prvdd_ctfns.effective_end_date, 10);
820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);
821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);

Line 818: hr_utility.set_location('l_prvdd_ctfns.effective_start_date ' || l_prvdd_ctfns.effective_start_date, 10);

814: loop
815: --
816: if (g_debug) then
817: hr_utility.set_location('l_effective_date ' || l_effective_date, 10);
818: hr_utility.set_location('l_prvdd_ctfns.effective_start_date ' || l_prvdd_ctfns.effective_start_date, 10);
819: hr_utility.set_location('l_prvdd_ctfns.effective_end_date ' || l_prvdd_ctfns.effective_end_date, 10);
820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);
821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);
822: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id' || l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id, 10);

Line 819: hr_utility.set_location('l_prvdd_ctfns.effective_end_date ' || l_prvdd_ctfns.effective_end_date, 10);

815: --
816: if (g_debug) then
817: hr_utility.set_location('l_effective_date ' || l_effective_date, 10);
818: hr_utility.set_location('l_prvdd_ctfns.effective_start_date ' || l_prvdd_ctfns.effective_start_date, 10);
819: hr_utility.set_location('l_prvdd_ctfns.effective_end_date ' || l_prvdd_ctfns.effective_end_date, 10);
820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);
821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);
822: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id' || l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id, 10);
823: hr_utility.set_location('l_prvdd_ctfns.enrt_ctfn_recd_dt' || l_prvdd_ctfns.enrt_ctfn_recd_dt, 10);

Line 820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);

816: if (g_debug) then
817: hr_utility.set_location('l_effective_date ' || l_effective_date, 10);
818: hr_utility.set_location('l_prvdd_ctfns.effective_start_date ' || l_prvdd_ctfns.effective_start_date, 10);
819: hr_utility.set_location('l_prvdd_ctfns.effective_end_date ' || l_prvdd_ctfns.effective_end_date, 10);
820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);
821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);
822: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id' || l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id, 10);
823: hr_utility.set_location('l_prvdd_ctfns.enrt_ctfn_recd_dt' || l_prvdd_ctfns.enrt_ctfn_recd_dt, 10);
824: hr_utility.set_location('l_prvdd_ctfns.ENRT_CTFN_TYP_CD' || l_prvdd_ctfns.ENRT_CTFN_TYP_CD, 10);

Line 821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);

817: hr_utility.set_location('l_effective_date ' || l_effective_date, 10);
818: hr_utility.set_location('l_prvdd_ctfns.effective_start_date ' || l_prvdd_ctfns.effective_start_date, 10);
819: hr_utility.set_location('l_prvdd_ctfns.effective_end_date ' || l_prvdd_ctfns.effective_end_date, 10);
820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);
821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);
822: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id' || l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id, 10);
823: hr_utility.set_location('l_prvdd_ctfns.enrt_ctfn_recd_dt' || l_prvdd_ctfns.enrt_ctfn_recd_dt, 10);
824: hr_utility.set_location('l_prvdd_ctfns.ENRT_CTFN_TYP_CD' || l_prvdd_ctfns.ENRT_CTFN_TYP_CD, 10);
825: end if;

Line 822: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id' || l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id, 10);

818: hr_utility.set_location('l_prvdd_ctfns.effective_start_date ' || l_prvdd_ctfns.effective_start_date, 10);
819: hr_utility.set_location('l_prvdd_ctfns.effective_end_date ' || l_prvdd_ctfns.effective_end_date, 10);
820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);
821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);
822: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id' || l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id, 10);
823: hr_utility.set_location('l_prvdd_ctfns.enrt_ctfn_recd_dt' || l_prvdd_ctfns.enrt_ctfn_recd_dt, 10);
824: hr_utility.set_location('l_prvdd_ctfns.ENRT_CTFN_TYP_CD' || l_prvdd_ctfns.ENRT_CTFN_TYP_CD, 10);
825: end if;
826: --

Line 823: hr_utility.set_location('l_prvdd_ctfns.enrt_ctfn_recd_dt' || l_prvdd_ctfns.enrt_ctfn_recd_dt, 10);

819: hr_utility.set_location('l_prvdd_ctfns.effective_end_date ' || l_prvdd_ctfns.effective_end_date, 10);
820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);
821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);
822: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id' || l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id, 10);
823: hr_utility.set_location('l_prvdd_ctfns.enrt_ctfn_recd_dt' || l_prvdd_ctfns.enrt_ctfn_recd_dt, 10);
824: hr_utility.set_location('l_prvdd_ctfns.ENRT_CTFN_TYP_CD' || l_prvdd_ctfns.ENRT_CTFN_TYP_CD, 10);
825: end if;
826: --
827: if (l_effective_date > l_prvdd_ctfns.effective_start_date) then

Line 824: hr_utility.set_location('l_prvdd_ctfns.ENRT_CTFN_TYP_CD' || l_prvdd_ctfns.ENRT_CTFN_TYP_CD, 10);

820: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_actn_id ' || l_prvdd_ctfns.prtt_enrt_actn_id, 10);
821: hr_utility.set_location('l_prvdd_ctfns.prev_prtt_enrt_actn_id ' || l_prvdd_ctfns.prev_prtt_enrt_actn_id, 10);
822: hr_utility.set_location('l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id' || l_prvdd_ctfns.prtt_enrt_ctfn_prvdd_id, 10);
823: hr_utility.set_location('l_prvdd_ctfns.enrt_ctfn_recd_dt' || l_prvdd_ctfns.enrt_ctfn_recd_dt, 10);
824: hr_utility.set_location('l_prvdd_ctfns.ENRT_CTFN_TYP_CD' || l_prvdd_ctfns.ENRT_CTFN_TYP_CD, 10);
825: end if;
826: --
827: if (l_effective_date > l_prvdd_ctfns.effective_start_date) then
828: l_datetrack_mode := hr_api.g_update;

Line 1171: g_debug := hr_utility.debug_enabled;

1167: l_bnft_amt number;
1168: --
1169: begin
1170: --
1171: g_debug := hr_utility.debug_enabled;
1172: --
1173: hr_utility.set_location('Entering: '||l_proc,10);
1174: --
1175: -- ben_env_object.get(p_rec => l_rec);

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

1169: begin
1170: --
1171: g_debug := hr_utility.debug_enabled;
1172: --
1173: hr_utility.set_location('Entering: '||l_proc,10);
1174: --
1175: -- ben_env_object.get(p_rec => l_rec);
1176: --
1177: hr_utility.set_location('Effective date: '||p_effective_date,10);

Line 1177: hr_utility.set_location('Effective date: '||p_effective_date,10);

1173: hr_utility.set_location('Entering: '||l_proc,10);
1174: --
1175: -- ben_env_object.get(p_rec => l_rec);
1176: --
1177: hr_utility.set_location('Effective date: '||p_effective_date,10);
1178: --
1179: ben_sspndd_enrollment.g_cfw_flag := 'Y';
1180: --
1181: l_pen_count := 0;

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

1192: l_bnft := l_bnft_reset; -- BBULUSU CODE
1193: --
1194: fetch c_choice_info into l_choice_info;
1195: --
1196: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
1197: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
1198: --
1199: exit when c_choice_info%notfound;
1200: --

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

1193: --
1194: fetch c_choice_info into l_choice_info;
1195: --
1196: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
1197: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
1198: --
1199: exit when c_choice_info%notfound;
1200: --
1201: -- Get participant enrollment result information

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

1199: exit when c_choice_info%notfound;
1200: --
1201: -- Get participant enrollment result information
1202:
1203: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
1204: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
1205: --
1206: if l_choice_info.crntly_enrd_flag = 'Y' then
1207: --

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

1200: --
1201: -- Get participant enrollment result information
1202:
1203: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
1204: hr_utility.set_location('epe id : '||l_choice_info.elig_per_elctbl_chc_id,10);
1205: --
1206: if l_choice_info.crntly_enrd_flag = 'Y' then
1207: --
1208: open c_prtt_result(l_choice_info.prtt_enrt_rslt_id,

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

1240: --
1241: -- Get benefit information
1242: --
1243: l_dflt_found:=false;
1244: hr_utility.set_location(l_proc,20);
1245: open c_bnft(l_choice_info.elig_per_elctbl_chc_id, l_prtt_result.bnft_ordr_num );
1246: fetch c_bnft into l_bnft;
1247: close c_bnft;
1248: --

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

1247: close c_bnft;
1248: --
1249: /*
1250: loop
1251: hr_utility.set_location(l_proc,30);
1252: --
1253: fetch c_bnft into l_bnft;
1254: --
1255: exit when c_bnft%notfound;

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

1252: --
1253: fetch c_bnft into l_bnft;
1254: --
1255: exit when c_bnft%notfound;
1256: hr_utility.set_location(l_proc,40);
1257: if l_bnft.dflt_flag='Y' then
1258: hr_utility.set_location(l_proc,50);
1259: l_dflt_bnft:=l_bnft;
1260: l_dflt_found:=true;

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

1254: --
1255: exit when c_bnft%notfound;
1256: hr_utility.set_location(l_proc,40);
1257: if l_bnft.dflt_flag='Y' then
1258: hr_utility.set_location(l_proc,50);
1259: l_dflt_bnft:=l_bnft;
1260: l_dflt_found:=true;
1261: end if;
1262: hr_utility.set_location(l_proc,60);

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

1258: hr_utility.set_location(l_proc,50);
1259: l_dflt_bnft:=l_bnft;
1260: l_dflt_found:=true;
1261: end if;
1262: hr_utility.set_location(l_proc,60);
1263: end loop;
1264: hr_utility.set_location(l_proc,70);
1265: close c_bnft;
1266: */

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

1260: l_dflt_found:=true;
1261: end if;
1262: hr_utility.set_location(l_proc,60);
1263: end loop;
1264: hr_utility.set_location(l_proc,70);
1265: close c_bnft;
1266: */
1267: --
1268: hr_utility.set_location(l_proc||l_bnft.val,90);

Line 1268: hr_utility.set_location(l_proc||l_bnft.val,90);

1264: hr_utility.set_location(l_proc,70);
1265: close c_bnft;
1266: */
1267: --
1268: hr_utility.set_location(l_proc||l_bnft.val,90);
1269: hr_utility.set_location('ENB ID'||l_bnft.enrt_bnft_id,90);
1270: --
1271: -- Get Rate information
1272: --

Line 1269: hr_utility.set_location('ENB ID'||l_bnft.enrt_bnft_id,90);

1265: close c_bnft;
1266: */
1267: --
1268: hr_utility.set_location(l_proc||l_bnft.val,90);
1269: hr_utility.set_location('ENB ID'||l_bnft.enrt_bnft_id,90);
1270: --
1271: -- Get Rate information
1272: --
1273: for l_count in 1..10 loop

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

1319: --end if;
1320: close c_pl_enrt_dt;
1321: end if;
1322: --
1323: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
1324: hr_utility.set_location('bnft_val='||l_bnft.val,13);
1325: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
1326: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
1327: --

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

1320: close c_pl_enrt_dt;
1321: end if;
1322: --
1323: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
1324: hr_utility.set_location('bnft_val='||l_bnft.val,13);
1325: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
1326: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
1327: --
1328: if l_bnft.cvg_mlt_cd='SAAEAR' and

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

1321: end if;
1322: --
1323: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
1324: hr_utility.set_location('bnft_val='||l_bnft.val,13);
1325: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
1326: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
1327: --
1328: if l_bnft.cvg_mlt_cd='SAAEAR' and
1329: l_rt_table(1).ann_rt_val is null then

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

1322: --
1323: hr_utility.set_location('cvg_mlt_cd='||l_bnft.cvg_mlt_cd,13);
1324: hr_utility.set_location('bnft_val='||l_bnft.val,13);
1325: hr_utility.set_location('rate_val='||l_rt_table(1).dflt_val,13);
1326: hr_utility.set_location('ann_rt_val='||l_rt_table(1).ann_rt_val,13);
1327: --
1328: if l_bnft.cvg_mlt_cd='SAAEAR' and
1329: l_rt_table(1).ann_rt_val is null then
1330: l_rt_table(1).ann_rt_val:=l_rt_table(1).dflt_val;

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

1532: ---
1533: end if ;
1534:
1535:
1536: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);
1537: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1538:
1539: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1540:

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

1533: end if ;
1534:
1535:
1536: hr_utility.set_location('l_cryfwd_elig_dpnt_cd '||l_cryfwd_elig_dpnt_cd,744);
1537: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1538:
1539: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1540:
1541: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);

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

1537: hr_utility.set_location('l_prev_prtt_enrt_rslt_id '||l_prev_prtt_enrt_rslt_id,744);
1538:
1539: if l_datetrack_mode = hr_api.g_insert and l_cryfwd_elig_dpnt_cd = 'CFRRWP' then
1540:
1541: hr_utility.set_location('cvg strt cd: '||l_choice_info.dpnt_cvg_strt_dt_cd,10);
1542: -- p_effective_date is now changed to l_effective_dt , when ever LE reprocessed
1543: -- result created as on effective date and automeatic enrollment called with
1544: -- lE_ocurd_Dt as affective date so there is no result as on effective date (le_ocrd_dt)
1545: -- this is fixed sending l_effective_dt # 3042033

Line 1702: hr_utility.set_location('CRD FWD CERT l_crd_fwd_pen_id(i) ' || l_crd_fwd_pen_id(i) , 10);

1698: --
1699: if (l_crd_fwd_pen_id.COUNT > 0) then
1700: for i in l_crd_fwd_pen_id.FIRST..l_crd_fwd_pen_id.LAST loop
1701: --
1702: hr_utility.set_location('CRD FWD CERT l_crd_fwd_pen_id(i) ' || l_crd_fwd_pen_id(i) , 10);
1703: --
1704: reinstate_prvdd_ctfn_items(p_prtt_enrt_rslt_id => l_crd_fwd_pen_id(i)
1705: ,p_per_in_ler_id => p_per_in_ler_id
1706: ,p_business_group_id => p_business_group_id

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

1709: end loop;
1710: end if;
1711: --
1712: ben_sspndd_enrollment.g_cfw_flag := 'N';
1713: hr_utility.set_location('Leaving: '||l_proc,10);
1714: --
1715: exception
1716: when others then
1717: ben_sspndd_enrollment.g_cfw_flag := 'N';

Line 1788: hr_utility.set_location ('Entering ' || l_proc , 1230);

1784: l_prev_prtt_enrt_ctfn_prvdd_id number;
1785: --
1786: begin
1787: --
1788: hr_utility.set_location ('Entering ' || l_proc , 1230);
1789: l_per_in_ler_id := p_per_in_ler_id;
1790: l_prev_prtt_enrt_actn_id := -1;
1791: --
1792: for l_actn_item in c_actn_item_for_past_pil (l_per_in_ler_id) loop

Line 1866: hr_utility.set_location ('Leaving ' || l_proc, 1230);

1862: --
1863: end if;
1864: close c_check_prem_active;
1865: --
1866: hr_utility.set_location ('Leaving ' || l_proc, 1230);
1867: end unprocess_susp_enrt_past_pil;
1868: procedure carry_farward_results(
1869: p_person_id in number,
1870: p_per_in_ler_id in number,

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

1890: l_pen_sus c_pen_sus%rowtype;
1891: --
1892: begin
1893: --
1894: hr_utility.set_location('Entering: '||l_proc,10);
1895: hr_utility.set_location('p_person_id'||p_person_id,10);
1896: hr_utility.set_location('p_per_in_ler_id'||p_per_in_ler_id,10);
1897: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1898: hr_utility.set_location('p_mode'||p_mode,10);

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

1891: --
1892: begin
1893: --
1894: hr_utility.set_location('Entering: '||l_proc,10);
1895: hr_utility.set_location('p_person_id'||p_person_id,10);
1896: hr_utility.set_location('p_per_in_ler_id'||p_per_in_ler_id,10);
1897: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1898: hr_utility.set_location('p_mode'||p_mode,10);
1899: hr_utility.set_location('p_effective_date'||p_effective_date,10);

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

1892: begin
1893: --
1894: hr_utility.set_location('Entering: '||l_proc,10);
1895: hr_utility.set_location('p_person_id'||p_person_id,10);
1896: hr_utility.set_location('p_per_in_ler_id'||p_per_in_ler_id,10);
1897: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1898: hr_utility.set_location('p_mode'||p_mode,10);
1899: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1900: --

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

1893: --
1894: hr_utility.set_location('Entering: '||l_proc,10);
1895: hr_utility.set_location('p_person_id'||p_person_id,10);
1896: hr_utility.set_location('p_per_in_ler_id'||p_per_in_ler_id,10);
1897: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1898: hr_utility.set_location('p_mode'||p_mode,10);
1899: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1900: --
1901: if p_mode not in ('L','C', 'M') then

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

1894: hr_utility.set_location('Entering: '||l_proc,10);
1895: hr_utility.set_location('p_person_id'||p_person_id,10);
1896: hr_utility.set_location('p_per_in_ler_id'||p_per_in_ler_id,10);
1897: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1898: hr_utility.set_location('p_mode'||p_mode,10);
1899: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1900: --
1901: if p_mode not in ('L','C', 'M') then
1902: --

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

1895: hr_utility.set_location('p_person_id'||p_person_id,10);
1896: hr_utility.set_location('p_per_in_ler_id'||p_per_in_ler_id,10);
1897: hr_utility.set_location('p_business_group_id'||p_business_group_id,10);
1898: hr_utility.set_location('p_mode'||p_mode,10);
1899: hr_utility.set_location('p_effective_date'||p_effective_date,10);
1900: --
1901: if p_mode not in ('L','C', 'M') then
1902: --
1903: -- Wrong mode my friend!

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

1911: p_per_in_ler_id => p_per_in_ler_id,
1912: p_ler_id => p_ler_id,
1913: p_effective_date => p_effective_date);
1914: --
1915: hr_utility.set_location('Leaving: '||l_proc,10);
1916: --
1917: --Reopen the closed action items of the enrollment results for which there are no
1918: --electable choices exists in this life event.
1919: open c_pen_sus;