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

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

418: l_prtt_rt_val_id2 number;
419: --
420: begin
421: --
422: hr_utility.set_location(' Entering: ' ||l_proc , 10);
423: --
424: --
425: open c_unrestricted;
426: fetch c_unrestricted into l_unrestricted;

Line 523: hr_utility.set_location('spcl_rates_flag: ' || l_use_spcl_rates_flag

519: end if;
520: --
521: close c_spcl_enrt_rslt;
522: --
523: hr_utility.set_location('spcl_rates_flag: ' || l_use_spcl_rates_flag
524: ||' ' || l_proc, 20);
525: --
526: end if;
527: --

Line 577: hr_utility.set_location('Using special rates : ' || l_proc, 20);

573: --
574: -- Since a special rate record was found, we have to use this rate
575: -- record instead of the normal rate.
576: --
577: hr_utility.set_location('Using special rates : ' || l_proc, 20);
578: --
579: l_use_enrt_rec := l_spcl_rt_rec;
580:
581: if ben_manage_life_events.fonm = 'Y' then

Line 609: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);

605: end if;
606:
607: for l_rollover_plan_rec in c_rollover_plan
608: loop
609: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
610: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
611: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
612:
613: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);

Line 610: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);

606:
607: for l_rollover_plan_rec in c_rollover_plan
608: loop
609: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
610: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
611: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
612:
613: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
614: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);

Line 611: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);

607: for l_rollover_plan_rec in c_rollover_plan
608: loop
609: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
610: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
611: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
612:
613: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
614: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
615: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);

Line 613: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);

609: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
610: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
611: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
612:
613: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
614: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
615: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
616:
617: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and

Line 614: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);

610: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
611: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
612:
613: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
614: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
615: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
616:
617: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and
618: nvl(l_enrt_rslt_rec.pl_id,-1) = nvl(l_rollover_plan_rec.pl_id,-1) and

Line 615: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);

611: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
612:
613: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
614: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
615: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
616:
617: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and
618: nvl(l_enrt_rslt_rec.pl_id,-1) = nvl(l_rollover_plan_rec.pl_id,-1) and
619: nvl(l_enrt_rslt_rec.oipl_id,-1) = nvl(l_rollover_plan_rec.oipl_id,-1))then

Line 657: hr_utility.set_location('Rate Code'||l_enrt_rt_rec.rt_mlt_cd ,112);

653: -- Not Calculate Mode: Call election_rate_information, only when
654: -- rate has not been already saved for the LE.
655: --
656: -- if p_calculate_only_mode or l_prv_rec.prtt_rt_val_id is null then
657: hr_utility.set_location('Rate Code'||l_enrt_rt_rec.rt_mlt_cd ,112);
658: if l_unrestricted = 'Y' and l_enrt_rt_rec.rt_mlt_cd = 'SAREC' then
659: l_prtt_rt_val_id2 := null;
660: open c_prv2 (l_enrt_rslt_rec.prtt_enrt_rslt_id, l_use_enrt_rec.acty_base_rt_id);
661: fetch c_prv2 into l_prtt_rt_val_id2;

Line 664: hr_utility.set_location('Prtt rate val'||l_prtt_rt_val_id,111);

660: open c_prv2 (l_enrt_rslt_rec.prtt_enrt_rslt_id, l_use_enrt_rec.acty_base_rt_id);
661: fetch c_prv2 into l_prtt_rt_val_id2;
662: close c_prv2;
663: end if;
664: hr_utility.set_location('Prtt rate val'||l_prtt_rt_val_id,111);
665: if not (l_prtt_rt_val_id2 is not null and
666: l_enrt_rt_rec.rt_mlt_cd = 'SAREC' and l_unrestricted = 'Y') then
667: ben_election_information.election_rate_information
668: (p_calculate_only_mode => p_calculate_only_mode

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

800: end loop;
801: --
802: end if;
803: --
804: hr_utility.set_location(' Leaving: ' ||l_proc , 10);
805: --
806: --
807: /*
808: ben_det_enrt_rates.end_prtt_rt_val

Line 819: hr_utility.set_location('Exception raised in ' || l_proc, 10);

815: */
816: exception
817: --
818: when others then
819: hr_utility.set_location('Exception raised in ' || l_proc, 10);
820: raise;
821: --
822: end p_det_enrt_rates;
823: --

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

982:
983: --
984: begin
985: --
986: hr_utility.set_location('Entering'||l_proc,10);
987: open c_unrestricted;
988: fetch c_unrestricted into l_unrestricted;
989: close c_unrestricted;
990: --

Line 1005: hr_utility.set_location('Inside Loop',11);

1001: loop
1002: --
1003: l_end_prtt_rt_val := false;
1004: -- only in OSB per_in_ler_id will be same for more than one prtt_rt_val
1005: hr_utility.set_location('Inside Loop',11);
1006:
1007:
1008: --if l_unrestricted = 'Y' then
1009: open c_elctbl_chc(l_enrt_rslt_rec.prtt_enrt_rslt_id);

Line 1076: -- hr_utility.set_location('Shell plan'||l_prtt_enrt_rslt_id,12);

1072: open c_prtt_enrt (l_enrt_rslt_rec.pgm_id);
1073: fetch c_prtt_enrt into l_prtt_enrt_rslt_id;
1074: close c_prtt_enrt;
1075: --
1076: -- hr_utility.set_location('Shell plan'||l_prtt_enrt_rslt_id,12);
1077:
1078: end if;
1079: --
1080: -- hr_utility.set_location('Decr pool id'||l_DECR_BNFT_PRVDR_POOL_ID,13);

Line 1080: -- hr_utility.set_location('Decr pool id'||l_DECR_BNFT_PRVDR_POOL_ID,13);

1076: -- hr_utility.set_location('Shell plan'||l_prtt_enrt_rslt_id,12);
1077:
1078: end if;
1079: --
1080: -- hr_utility.set_location('Decr pool id'||l_DECR_BNFT_PRVDR_POOL_ID,13);
1081: -- check for flex program
1082: if l_prtt_enrt_rslt_id is not null and
1083: ((l_end_prtt_rt_val) or l_DECR_BNFT_PRVDR_POOL_ID is null) then
1084: -- delete the debit ledger entry as the application is end dated

Line 1128: hr_utility.set_location('prtt rt val id'||l_prtt_rt_val.prtt_rt_val_id,11);

1124: ,p_rt_end_dt_rl => l_dummy_number
1125: ,p_acty_base_rt_id => l_prtt_rt_val.acty_base_rt_id
1126: ,p_effective_date => p_effective_date);
1127: --
1128: hr_utility.set_location('prtt rt val id'||l_prtt_rt_val.prtt_rt_val_id,11);
1129: ben_prtt_rt_val_api.update_prtt_rt_val
1130: (p_prtt_rt_val_id => l_prtt_rt_val.prtt_rt_val_id
1131: ,p_rt_end_dt => l_rt_end_dt
1132: ,p_ended_per_in_ler_id => p_per_in_ler_id

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

1139: end if;
1140: End loop; -- c_prtt_rt_val
1141: --
1142: End loop; -- c_prtt_enrt_rslt
1143: hr_utility.set_location('Leaving'||l_proc,10);
1144:
1145: End ;
1146:
1147: --

Line 1285: hr_utility.set_location('Entering'||l_proc,11);

1281:
1282: --
1283: begin
1284: --
1285: hr_utility.set_location('Entering'||l_proc,11);
1286: open c_unrestricted;
1287: fetch c_unrestricted into l_unrestricted;
1288: close c_unrestricted;
1289: --

Line 1411: hr_utility.set_location('Leaving'||l_proc,12);

1407: );
1408:
1409: end if;
1410: End loop;
1411: hr_utility.set_location('Leaving'||l_proc,12);
1412:
1413: end;
1414: --
1415: procedure det_enrt_rates_erl