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 136: g_debug boolean := hr_utility.debug_enabled;

132: has not been updated with the current per_in_ler_id.
133: 115.62 23-Nov-11 velvanop Bug 13367099: Do not consider Imputed Income enrollment to determine Elections Made date
134: */
135: ------------------------------------------------------------------------------
136: g_debug boolean := hr_utility.debug_enabled;
137: g_package varchar2(80):='ben_proc_common_enrt_rslt.';
138: --
139: -- ---------------------------------------------------------------------------
140: -- This procedure was later added to update elctn made dt or assigned dt on pil_popl (yrathman)

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

194: l_new_elcns_made_dt date default null;
195: --
196: begin
197: --
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: -- Get the pil_elctbl_chc_popl object_version_number
201: --
202: if p_pgm_id is not null then

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

234: end if;
235: --
236: -- If enrollment method code is explicit, update the election made date.
237: --
238: hr_utility.set_location('enrt mthd cd'||p_enrt_mthd_cd||l_proc, 5);
239: if p_enrt_mthd_cd = 'E' then
240: --
241: hr_utility.set_location(l_proc, 10);
242: --

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

237: --
238: hr_utility.set_location('enrt mthd cd'||p_enrt_mthd_cd||l_proc, 5);
239: if p_enrt_mthd_cd = 'E' then
240: --
241: hr_utility.set_location(l_proc, 10);
242: --
243: -- Update election made date on pil_elctbl_chc_popl.
244: -- Bug 1644520 added the if condition to take the only first election
245: -- made date

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

275: -- enrollment date
276: --
277: elsif p_enrt_mthd_cd = 'D' then
278: --
279: hr_utility.set_location(l_proc, 20);
280: --
281: --
282: -- Update default assigned date on pil_elctbl_chc_popl.
283: --

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

292: --
293: --
294: elsif p_enrt_mthd_cd = 'A' then
295: --
296: hr_utility.set_location(l_proc, 20);
297: --
298: -- Update automatic enrollment assigned date on pil_elctbl_chc_popl.
299: --
300: ben_Pil_Elctbl_chc_Popl_api.update_Pil_Elctbl_chc_Popl

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

307: );
308: --
309: end if;
310: --
311: hr_utility.set_location(l_proc, 25);
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 30);
314: --
315: end set_elcn_made_or_asnd_dt;

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

309: end if;
310: --
311: hr_utility.set_location(l_proc, 25);
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 30);
314: --
315: end set_elcn_made_or_asnd_dt;
316: --
317: -- ------------------------------------------------------------------------------

Line 478: g_debug := hr_utility.debug_enabled;

474: l_datetrack_mode varchar2(30);
475: --
476: begin
477: --
478: g_debug := hr_utility.debug_enabled;
479: --
480: if (g_debug) then
481: hr_utility.set_location('Entering:'||l_proc, 5);
482: end if;

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

477: --
478: g_debug := hr_utility.debug_enabled;
479: --
480: if (g_debug) then
481: hr_utility.set_location('Entering:'||l_proc, 5);
482: end if;
483: --
484: -- Check to see if the per in ler id is being passed in. If not then
485: -- fetch it.

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

502: l_per_in_ler_id := p_per_in_ler_id;
503:
504: end if;
505: --
506: hr_utility.set_location(l_proc, 10);
507: --
508: -- process post enrollment rule for coverages
509: --
510: --

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

552: l_suspended_pen_id,
553: l_suspended_ovn;
554: close c_interim;
555: --
556: hr_utility.set_location('l_interim '|| l_interim, 10);
557: --
558: IF l_interim = 'Y' THEN
559: --
560: ben_sspndd_enrollment.g_interim_flag := 'Y';

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

558: IF l_interim = 'Y' THEN
559: --
560: ben_sspndd_enrollment.g_interim_flag := 'Y';
561: ben_sspndd_enrollment.g_use_new_result:=true;
562: hr_utility.set_location('Before ERL Interim call',20);
563: --
564: END IF;
565: --
566: --

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

564: END IF;
565: --
566: --
567: if (g_debug) then
568: hr_utility.set_location('Fetch entr_val_at_enrt rates for ERL enrollments ', 15);
569: end if;
570: -- 5621577 Fetch and populate existing rate values.
571: for l_count in 1..10 loop
572: -- Initialise array to null

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

587: l_rt_table(l_count).ann_val := l_rec.ann_rt_val;
588: l_rt_table(l_count).prtt_rt_val_id := l_rec.prtt_rt_val_id;
589: --
590: if (g_debug) then
591: hr_utility.set_location('Rate l_count '|| l_count, 15);
592: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
593: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
594: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
595: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);

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

588: l_rt_table(l_count).prtt_rt_val_id := l_rec.prtt_rt_val_id;
589: --
590: if (g_debug) then
591: hr_utility.set_location('Rate l_count '|| l_count, 15);
592: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
593: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
594: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
595: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);
596: end if;

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

589: --
590: if (g_debug) then
591: hr_utility.set_location('Rate l_count '|| l_count, 15);
592: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
593: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
594: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
595: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);
596: end if;
597: --

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

590: if (g_debug) then
591: hr_utility.set_location('Rate l_count '|| l_count, 15);
592: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
593: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
594: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
595: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);
596: end if;
597: --
598: end loop;

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

591: hr_utility.set_location('Rate l_count '|| l_count, 15);
592: hr_utility.set_location('l_rec.enrt_rt_id '|| l_rec.enrt_rt_id, 15);
593: hr_utility.set_location('l_rec.rt_val '|| l_rec.rt_val, 15);
594: hr_utility.set_location('l_rec.ann_val '|| l_rec.ann_rt_val, 15);
595: hr_utility.set_location('l_rec.prtt_rt_val_id '|| l_rec.prtt_rt_val_id, 15);
596: end if;
597: --
598: end loop;
599: --

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

758: ben_sspndd_enrollment.g_use_new_result:=false;
759: --
760: -- Now update the suspended enrollment with newly cteated interim id.
761: --
762: hr_utility.set_location('After ERL Interim call ELINF',20);
763: --
764: ben_prtt_enrt_result_api.get_ben_pen_upd_dt_mode
765: (p_effective_date => p_effective_date
766: ,p_base_key_value => l_suspended_pen_id

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

767: ,P_desired_datetrack_mode => hr_api.g_correction
768: ,P_datetrack_allow => l_datetrack_mode
769: );
770: --
771: hr_utility.set_location('After ERL Interim call BEPENDT',20);
772: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);
773: --
774: ben_prtt_enrt_result_api.update_prtt_enrt_result
775: (p_validate => FALSE,

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

768: ,P_datetrack_allow => l_datetrack_mode
769: );
770: --
771: hr_utility.set_location('After ERL Interim call BEPENDT',20);
772: hr_utility.set_location('l_datetrack_mode '||l_datetrack_mode,10);
773: --
774: ben_prtt_enrt_result_api.update_prtt_enrt_result
775: (p_validate => FALSE,
776: p_prtt_enrt_rslt_id => l_suspended_pen_id,

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

786: p_program_id => fnd_global.conc_program_id,
787: p_request_id => fnd_global.conc_request_id,
788: p_program_update_date => sysdate);
789: --
790: hr_utility.set_location('After ERL Interim BEPENUPD call',30);
791: END IF;
792: --
793: end if; --call election information
794: --

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

828: );
829: --
830: -- Determine imputed income
831: --
832: hr_utility.set_location(l_proc, 15);
833: --
834: l_call_imputed := true;
835: --
836: if p_pl_id is not null and p_pgm_id is null then

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

834: l_call_imputed := true;
835: --
836: if p_pl_id is not null and p_pgm_id is null then
837: --
838: hr_utility.set_location('PL id '||p_pl_id,16);
839: open c_pl(p_pl_id);
840: fetch c_pl into l_pln_name, l_SUBJ_TO_IMPTD_INCM_TYP_CD;
841: if c_pl%found and l_SUBJ_TO_IMPTD_INCM_TYP_CD is null then
842: l_call_imputed := false;

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

857: ,p_validate => p_validate);
858: --
859: end if;
860: --
861: hr_utility.set_location(' Leaving:'||l_proc, 20);
862: --
863: end process_post_results;
864: --
865: -- ------------------------------------------------------------------------------

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

903: l_global_pil_rec ben_global_enrt.g_global_pil_rec_type;
904: --
905: begin
906: --
907: hr_utility.set_location('Entering:'||l_proc, 5);
908: --
909: set_elcn_made_or_asnd_dt
910: (p_per_in_ler_id => p_per_in_ler_id
911: ,p_pgm_id => p_pgm_id

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

915: ,p_effective_date => p_effective_date
916: ,p_validate => p_validate
917: );
918: --
919: hr_utility.set_location(p_proc_cd, 25);
920: hr_utility.set_location(p_proc_cd2, 25);
921: --
922: -- Write communication.
923: --

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

916: ,p_validate => p_validate
917: );
918: --
919: hr_utility.set_location(p_proc_cd, 25);
920: hr_utility.set_location(p_proc_cd2, 25);
921: --
922: -- Write communication.
923: --
924: hr_utility.set_location(l_proc, 26);

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

920: hr_utility.set_location(p_proc_cd2, 25);
921: --
922: -- Write communication.
923: --
924: hr_utility.set_location(l_proc, 26);
925: --
926: if p_proc_cd is not null then
927: --
928: open c_pil_elctbl_chc_popl;

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

952: ,p_proc_cd5 => p_proc_cd5
953: ,p_effective_date => p_effective_date);
954: end if;
955: --
956: hr_utility.set_location(l_proc, 27);
957: --
958: -- Close enrollment i.e. update the per_in_ler to processed.
959: --
960: if p_cls_enrt_flag then

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

983: end if;*/
984: -- Bug 5997904
985: --
986: end if;
987: hr_utility.set_location(' Leaving:'||l_proc, 30);
988: --
989: end process_post_enrollment;
990: --
991: --

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

1011: l_cls_enrt_flag BOOLEAN;
1012: --
1013: begin
1014: --
1015: hr_utility.set_location('Entering:'||l_proc, 10);
1016: --
1017: if upper(p_validate) = 'TRUE'
1018: then
1019: l_validate := TRUE;

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

1027: else
1028: l_cls_enrt_flag := FALSE;
1029: end if;
1030: --
1031: hr_utility.set_location('Entering:'||l_proc, 20);
1032: --
1033: process_post_enrollment(
1034: p_per_in_ler_id => p_per_in_ler_id
1035: ,p_pgm_id => p_pgm_id

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

1042: ,p_effective_date => p_effective_date
1043: ,p_validate => l_validate
1044: );
1045: --
1046: hr_utility.set_location(' Leaving:'||l_proc, 30);
1047: --
1048: exception
1049: --
1050: when others then