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 466: hr_utility.set_location(' Entering: ' ||l_proc , 10);

462: l_prtt_rt_val_id2 number;
463: --
464: begin
465: --
466: hr_utility.set_location(' Entering: ' ||l_proc , 10);
467: --
468: --
469: open c_unrestricted;
470: fetch c_unrestricted into l_unrestricted;

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

498: --9817172
499: if (not l_process_this_result) then
500: for l_rollover_plan_rec in c_rollover_plan
501: loop
502: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
503: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
504: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
505:
506: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);

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

499: if (not l_process_this_result) then
500: for l_rollover_plan_rec in c_rollover_plan
501: loop
502: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
503: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
504: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
505:
506: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
507: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);

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

500: for l_rollover_plan_rec in c_rollover_plan
501: loop
502: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
503: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
504: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
505:
506: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
507: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
508: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);

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

502: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
503: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
504: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
505:
506: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
507: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
508: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
509:
510: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and

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

503: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
504: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
505:
506: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
507: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
508: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
509:
510: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and
511: nvl(l_enrt_rslt_rec.pl_id,-1) = nvl(l_rollover_plan_rec.pl_id,-1) and

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

504: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
505:
506: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
507: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
508: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
509:
510: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and
511: nvl(l_enrt_rslt_rec.pl_id,-1) = nvl(l_rollover_plan_rec.pl_id,-1) and
512: nvl(l_enrt_rslt_rec.oipl_id,-1) = nvl(l_rollover_plan_rec.oipl_id,-1))then

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

584: end if;
585: --
586: close c_spcl_enrt_rslt;
587: --
588: hr_utility.set_location('spcl_rates_flag: ' || l_use_spcl_rates_flag
589: ||' ' || l_proc, 20);
590: --
591: end if;
592: --

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

638: --
639: -- Since a special rate record was found, we have to use this rate
640: -- record instead of the normal rate.
641: --
642: hr_utility.set_location('Using special rates : ' || l_proc, 20);
643: --
644: l_use_enrt_rec := l_spcl_rt_rec;
645:
646: if ben_manage_life_events.fonm = 'Y' then

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

670: end if;
671:
672: for l_rollover_plan_rec in c_rollover_plan
673: loop
674: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
675: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
676: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
677:
678: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);

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

671:
672: for l_rollover_plan_rec in c_rollover_plan
673: loop
674: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
675: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
676: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
677:
678: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
679: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);

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

672: for l_rollover_plan_rec in c_rollover_plan
673: loop
674: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
675: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
676: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
677:
678: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
679: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
680: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);

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

674: hr_utility.set_location('l_enrt_rslt_rec.pgm_id' || l_enrt_rslt_rec.pgm_id, 1234);
675: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
676: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
677:
678: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
679: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
680: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
681:
682: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and

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

675: hr_utility.set_location('l_enrt_rslt_rec.pl_id' || l_enrt_rslt_rec.pl_id, 1234);
676: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
677:
678: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
679: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
680: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
681:
682: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and
683: nvl(l_enrt_rslt_rec.pl_id,-1) = nvl(l_rollover_plan_rec.pl_id,-1) and

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

676: hr_utility.set_location('l_enrt_rslt_rec.oipl_id' || l_enrt_rslt_rec.oipl_id, 1234);
677:
678: hr_utility.set_location('l_rollover_plan_rec.pgm_id' || l_rollover_plan_rec.pgm_id, 987);
679: hr_utility.set_location('l_rollover_plan_rec.pl_id' || l_rollover_plan_rec.pl_id, 987);
680: hr_utility.set_location('l_rollover_plan_rec.oipl_id' || l_rollover_plan_rec.oipl_id, 987);
681:
682: if (nvl(l_enrt_rslt_rec.pgm_id,-1) = nvl(l_rollover_plan_rec.pgm_id,-1) and
683: nvl(l_enrt_rslt_rec.pl_id,-1) = nvl(l_rollover_plan_rec.pl_id,-1) and
684: nvl(l_enrt_rslt_rec.oipl_id,-1) = nvl(l_rollover_plan_rec.oipl_id,-1))then

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

718: -- Not Calculate Mode: Call election_rate_information, only when
719: -- rate has not been already saved for the LE.
720: --
721: -- if p_calculate_only_mode or l_prv_rec.prtt_rt_val_id is null then
722: hr_utility.set_location('Rate Code'||l_enrt_rt_rec.rt_mlt_cd ,112);
723: if l_unrestricted = 'Y' and l_enrt_rt_rec.rt_mlt_cd = 'SAREC' then
724: l_prtt_rt_val_id2 := null;
725: open c_prv2 (l_enrt_rslt_rec.prtt_enrt_rslt_id, l_use_enrt_rec.acty_base_rt_id);
726: fetch c_prv2 into l_prtt_rt_val_id2;

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

725: open c_prv2 (l_enrt_rslt_rec.prtt_enrt_rslt_id, l_use_enrt_rec.acty_base_rt_id);
726: fetch c_prv2 into l_prtt_rt_val_id2;
727: close c_prv2;
728: end if;
729: hr_utility.set_location('Prtt rate val'||l_prtt_rt_val_id,111);
730: if not (l_prtt_rt_val_id2 is not null and
731: l_enrt_rt_rec.rt_mlt_cd = 'SAREC' and l_unrestricted = 'Y') then
732: ben_election_information.election_rate_information
733: (p_calculate_only_mode => p_calculate_only_mode

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

865: end loop;
866: --
867: end if;
868: --
869: hr_utility.set_location(' Leaving: ' ||l_proc , 10);
870: --
871: --
872: /*
873: ben_det_enrt_rates.end_prtt_rt_val

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

880: */
881: exception
882: --
883: when others then
884: hr_utility.set_location('Exception raised in ' || l_proc, 10);
885: raise;
886: --
887: end p_det_enrt_rates;
888: --

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

1047:
1048: --
1049: begin
1050: --
1051: hr_utility.set_location('Entering'||l_proc,10);
1052: open c_unrestricted;
1053: fetch c_unrestricted into l_unrestricted;
1054: close c_unrestricted;
1055: --

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

1066: loop
1067: --
1068: l_end_prtt_rt_val := false;
1069: -- only in OSB per_in_ler_id will be same for more than one prtt_rt_val
1070: hr_utility.set_location('Inside Loop',11);
1071:
1072:
1073: --if l_unrestricted = 'Y' then
1074: open c_elctbl_chc(l_enrt_rslt_rec.prtt_enrt_rslt_id);

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

1137: open c_prtt_enrt (l_enrt_rslt_rec.pgm_id);
1138: fetch c_prtt_enrt into l_prtt_enrt_rslt_id;
1139: close c_prtt_enrt;
1140: --
1141: -- hr_utility.set_location('Shell plan'||l_prtt_enrt_rslt_id,12);
1142:
1143: end if;
1144: --
1145: -- hr_utility.set_location('Decr pool id'||l_DECR_BNFT_PRVDR_POOL_ID,13);

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

1141: -- hr_utility.set_location('Shell plan'||l_prtt_enrt_rslt_id,12);
1142:
1143: end if;
1144: --
1145: -- hr_utility.set_location('Decr pool id'||l_DECR_BNFT_PRVDR_POOL_ID,13);
1146: -- check for flex program
1147: if l_prtt_enrt_rslt_id is not null and
1148: ((l_end_prtt_rt_val) or l_DECR_BNFT_PRVDR_POOL_ID is null) then
1149: -- delete the debit ledger entry as the application is end dated

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

1189: ,p_rt_end_dt_rl => l_dummy_number
1190: ,p_acty_base_rt_id => l_prtt_rt_val.acty_base_rt_id
1191: ,p_effective_date => p_effective_date);
1192: --
1193: hr_utility.set_location('prtt rt val id'||l_prtt_rt_val.prtt_rt_val_id,11);
1194: ben_prtt_rt_val_api.update_prtt_rt_val
1195: (p_prtt_rt_val_id => l_prtt_rt_val.prtt_rt_val_id
1196: ,p_rt_end_dt => l_rt_end_dt
1197: ,p_ended_per_in_ler_id => p_per_in_ler_id

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

1204: end if;
1205: End loop; -- c_prtt_rt_val
1206: --
1207: End loop; -- c_prtt_enrt_rslt
1208: hr_utility.set_location('Leaving'||l_proc,10);
1209:
1210: End ;
1211:
1212: --

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

1346:
1347: --
1348: begin
1349: --
1350: hr_utility.set_location('Entering'||l_proc,11);
1351: open c_unrestricted;
1352: fetch c_unrestricted into l_unrestricted;
1353: close c_unrestricted;
1354: --

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

1472: );
1473:
1474: end if;
1475: End loop;
1476: hr_utility.set_location('Leaving'||l_proc,12);
1477:
1478: end;
1479: --
1480: procedure det_enrt_rates_erl