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_PROC_COMMON_ENRT_RSLT dependencies on HR_UTILITY

Line 128: g_debug boolean := hr_utility.debug_enabled;

124: 115.57 19-Oct-08 sagnanas 7447088 - Added enrt_mthd_cd 'D' in cursor c_enrt_rslt
125: 115.58 28-Oct-08 sagnanas 7510533 - Commented pen.per_in_ler_id in cursor c_enrt_rslt
126: */
127: ------------------------------------------------------------------------------
128: g_debug boolean := hr_utility.debug_enabled;
129: g_package varchar2(80):='ben_proc_common_enrt_rslt.';
130: --
131: -- ---------------------------------------------------------------------------
132: -- This procedure was later added to update elctn made dt or assigned dt on pil_popl (yrathman)

Line 189: hr_utility.set_location('Entering:'||l_proc, 5);

185: l_new_elcns_made_dt date default null;
186: --
187: begin
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: -- Get the pil_elctbl_chc_popl object_version_number
192: --
193: if p_pgm_id is not null then

Line 229: hr_utility.set_location('enrt mthd cd'||p_enrt_mthd_cd||l_proc, 5);

225: end if;
226: --
227: -- If enrollment method code is explicit, update the election made date.
228: --
229: hr_utility.set_location('enrt mthd cd'||p_enrt_mthd_cd||l_proc, 5);
230: if p_enrt_mthd_cd = 'E' then
231: --
232: hr_utility.set_location(l_proc, 10);
233: --

Line 232: hr_utility.set_location(l_proc, 10);

228: --
229: hr_utility.set_location('enrt mthd cd'||p_enrt_mthd_cd||l_proc, 5);
230: if p_enrt_mthd_cd = 'E' then
231: --
232: hr_utility.set_location(l_proc, 10);
233: --
234: -- Update election made date on pil_elctbl_chc_popl.
235: -- Bug 1644520 added the if condition to take the only first election
236: -- made date

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

266: -- enrollment date
267: --
268: elsif p_enrt_mthd_cd = 'D' then
269: --
270: hr_utility.set_location(l_proc, 20);
271: --
272: --
273: -- Update default assigned date on pil_elctbl_chc_popl.
274: --

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

283: --
284: --
285: elsif p_enrt_mthd_cd = 'A' then
286: --
287: hr_utility.set_location(l_proc, 20);
288: --
289: -- Update automatic enrollment assigned date on pil_elctbl_chc_popl.
290: --
291: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

Line 302: hr_utility.set_location(l_proc, 25);

298: );
299: --
300: end if;
301: --
302: hr_utility.set_location(l_proc, 25);
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 30);
305: --
306: end set_elcn_made_or_asnd_dt;

Line 304: hr_utility.set_location(' Leaving:'||l_proc, 30);

300: end if;
301: --
302: hr_utility.set_location(l_proc, 25);
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 30);
305: --
306: end set_elcn_made_or_asnd_dt;
307: --
308: -- ------------------------------------------------------------------------------

Line 463: g_debug := hr_utility.debug_enabled;

459: l_datetrack_mode varchar2(30);
460: --
461: begin
462: --
463: g_debug := hr_utility.debug_enabled;
464: --
465: if (g_debug) then
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: end if;

Line 466: hr_utility.set_location('Entering:'||l_proc, 5);

462: --
463: g_debug := hr_utility.debug_enabled;
464: --
465: if (g_debug) then
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: end if;
468: --
469: -- Check to see if the per in ler id is being passed in. If not then
470: -- fetch it.

Line 491: hr_utility.set_location(l_proc, 10);

487: l_per_in_ler_id := p_per_in_ler_id;
488:
489: end if;
490: --
491: hr_utility.set_location(l_proc, 10);
492: --
493: -- process post enrollment rule for coverages
494: --
495: --

Line 541: hr_utility.set_location('l_interim '|| l_interim, 10);

537: l_suspended_pen_id,
538: l_suspended_ovn;
539: close c_interim;
540: --
541: hr_utility.set_location('l_interim '|| l_interim, 10);
542: --
543: IF l_interim = 'Y' THEN
544: --
545: ben_sspndd_enrollment.g_interim_flag := 'Y';

Line 547: hr_utility.set_location('Before ERL Interim call',20);

543: IF l_interim = 'Y' THEN
544: --
545: ben_sspndd_enrollment.g_interim_flag := 'Y';
546: ben_sspndd_enrollment.g_use_new_result:=true;
547: hr_utility.set_location('Before ERL Interim call',20);
548: --
549: END IF;
550: --
551: --

Line 553: hr_utility.set_location('Fetch entr_val_at_enrt rates for ERL enrollments ', 15);

549: END IF;
550: --
551: --
552: if (g_debug) then
553: hr_utility.set_location('Fetch entr_val_at_enrt rates for ERL enrollments ', 15);
554: end if;
555: -- 5621577 Fetch and populate existing rate values.
556: for l_count in 1..10 loop
557: -- Initialise array to null

Line 576: hr_utility.set_location('Rate l_count '|| l_count, 15);

572: l_rt_table(l_count).ann_val := l_rec.ann_rt_val;
573: l_rt_table(l_count).prtt_rt_val_id := l_rec.prtt_rt_val_id;
574: --
575: if (g_debug) then
576: hr_utility.set_location('Rate l_count '|| l_count, 15);
577: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
578: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
579: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
580: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);

Line 577: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);

573: l_rt_table(l_count).prtt_rt_val_id := l_rec.prtt_rt_val_id;
574: --
575: if (g_debug) then
576: hr_utility.set_location('Rate l_count '|| l_count, 15);
577: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
578: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
579: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
580: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);
581: end if;

Line 578: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);

574: --
575: if (g_debug) then
576: hr_utility.set_location('Rate l_count '|| l_count, 15);
577: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
578: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
579: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
580: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);
581: end if;
582: --

Line 579: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);

575: if (g_debug) then
576: hr_utility.set_location('Rate l_count '|| l_count, 15);
577: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
578: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
579: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
580: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);
581: end if;
582: --
583: end loop;

Line 580: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);

576: hr_utility.set_location('Rate l_count '|| l_count, 15);
577: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
578: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
579: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
580: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);
581: end if;
582: --
583: end loop;
584: --

Line 747: hr_utility.set_location('After ERL Interim call ELINF',20);

743: ben_sspndd_enrollment.g_use_new_result:=false;
744: --
745: -- Now update the suspended enrollment with newly cteated interim id.
746: --
747: hr_utility.set_location('After ERL Interim call ELINF',20);
748: --
749: ben_prtt_enrt_result_api.get_ben_pen_upd_dt_mode
750: (p_effective_date => p_effective_date
751: ,p_base_key_value => l_suspended_pen_id

Line 756: hr_utility.set_location('After ERL Interim call BEPENDT',20);

752: ,P_desired_datetrack_mode => hr_api.g_correction
753: ,P_datetrack_allow => l_datetrack_mode
754: );
755: --
756: hr_utility.set_location('After ERL Interim call BEPENDT',20);
757: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);
758: --
759: ben_prtt_enrt_result_api.update_prtt_enrt_result
760: (p_validate => FALSE,

Line 757: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);

753: ,P_datetrack_allow => l_datetrack_mode
754: );
755: --
756: hr_utility.set_location('After ERL Interim call BEPENDT',20);
757: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);
758: --
759: ben_prtt_enrt_result_api.update_prtt_enrt_result
760: (p_validate => FALSE,
761: p_prtt_enrt_rslt_id => l_suspended_pen_id,

Line 775: hr_utility.set_location('After ERL Interim BEPENUPD call',30);

771: p_program_id => fnd_global.conc_program_id,
772: p_request_id => fnd_global.conc_request_id,
773: p_program_update_date => sysdate);
774: --
775: hr_utility.set_location('After ERL Interim BEPENUPD call',30);
776: END IF;
777: --
778: end if; --call election information
779: --

Line 815: hr_utility.set_location(l_proc, 15);

811: );
812: --
813: -- Determine imputed income
814: --
815: hr_utility.set_location(l_proc, 15);
816: --
817: l_call_imputed := true;
818: --
819: if p_pl_id is not null and p_pgm_id is null then

Line 821: hr_utility.set_location('PL id '||p_pl_id,16);

817: l_call_imputed := true;
818: --
819: if p_pl_id is not null and p_pgm_id is null then
820: --
821: hr_utility.set_location('PL id '||p_pl_id,16);
822: open c_pl(p_pl_id);
823: fetch c_pl into l_pln_name, l_SUBJ_TO_IMPTD_INCM_TYP_CD;
824: if c_pl%found and l_SUBJ_TO_IMPTD_INCM_TYP_CD is null then
825: l_call_imputed := false;

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

840: ,p_validate => p_validate);
841: --
842: end if;
843: --
844: hr_utility.set_location(' Leaving:'||l_proc, 20);
845: --
846: end process_post_results;
847: --
848: -- ------------------------------------------------------------------------------

Line 890: hr_utility.set_location('Entering:'||l_proc, 5);

886: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
887: --
888: begin
889: --
890: hr_utility.set_location('Entering:'||l_proc, 5);
891: --
892: set_elcn_made_or_asnd_dt
893: (p_per_in_ler_id => p_per_in_ler_id
894: ,p_pgm_id => p_pgm_id

Line 902: hr_utility.set_location(p_proc_cd, 25);

898: ,p_effective_date => p_effective_date
899: ,p_validate => p_validate
900: );
901: --
902: hr_utility.set_location(p_proc_cd, 25);
903: hr_utility.set_location(p_proc_cd2, 25);
904: --
905: -- Write communication.
906: --

Line 903: hr_utility.set_location(p_proc_cd2, 25);

899: ,p_validate => p_validate
900: );
901: --
902: hr_utility.set_location(p_proc_cd, 25);
903: hr_utility.set_location(p_proc_cd2, 25);
904: --
905: -- Write communication.
906: --
907: hr_utility.set_location(l_proc, 26);

Line 907: hr_utility.set_location(l_proc, 26);

903: hr_utility.set_location(p_proc_cd2, 25);
904: --
905: -- Write communication.
906: --
907: hr_utility.set_location(l_proc, 26);
908: --
909: if p_proc_cd is not null then
910: --
911: open c_pil_elctbl_chc_popl;

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

935: ,p_proc_cd5 => p_proc_cd5
936: ,p_effective_date => p_effective_date);
937: end if;
938: --
939: hr_utility.set_location(l_proc, 27);
940: --
941: -- Close enrollment i.e. update the per_in_ler to processed.
942: --
943: if p_cls_enrt_flag then

Line 970: hr_utility.set_location(' Leaving:'||l_proc, 30);

966: end if;*/
967: -- Bug 5997904
968: --
969: end if;
970: hr_utility.set_location(' Leaving:'||l_proc, 30);
971: --
972: end process_post_enrollment;
973: --
974: --

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

994: l_cls_enrt_flag BOOLEAN;
995: --
996: begin
997: --
998: hr_utility.set_location('Entering:'||l_proc, 10);
999: --
1000: if upper(p_validate) = 'TRUE'
1001: then
1002: l_validate := TRUE;

Line 1014: hr_utility.set_location('Entering:'||l_proc, 20);

1010: else
1011: l_cls_enrt_flag := FALSE;
1012: end if;
1013: --
1014: hr_utility.set_location('Entering:'||l_proc, 20);
1015: --
1016: process_post_enrollment(
1017: p_per_in_ler_id => p_per_in_ler_id
1018: ,p_pgm_id => p_pgm_id

Line 1029: hr_utility.set_location(' Leaving:'||l_proc, 30);

1025: ,p_effective_date => p_effective_date
1026: ,p_validate => l_validate
1027: );
1028: --
1029: hr_utility.set_location(' Leaving:'||l_proc, 30);
1030: --
1031: exception
1032: --
1033: when others then