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

Line 183: 25 Sep 00 mhoyes 115.69 - Commented out nocopy highly executed hr_utility

179: 20-Jul-00 bbulusu 115.68 Bug Fix 5368. Was not checking
180: for enter at enrollment when
181: comparing enrolled benefit amount
182: to null computed value.
183: 25 Sep 00 mhoyes 115.69 - Commented out nocopy highly executed hr_utility
184: .set_locations.
185: 07 Nov 00 mhoyes 115.70 - Referenced electable choice performance
186: APIs.
187: - Referenced comp object loop electable

Line 390: hr_utility.set_location ('Entering '||l_package,10);

386: l_package varchar2(80) := g_package||'.round_val';
387: l_val number;
388: BEGIN
389: --
390: hr_utility.set_location ('Entering '||l_package,10);
391: --
392: if (p_rndg_cd is not null or
393: p_rndg_rl is not null) then
394: --

Line 407: hr_utility.set_location ('Leaving '||l_package,10);

403: l_val := p_val;
404: --
405: end if;
406: return l_val;
407: hr_utility.set_location ('Leaving '||l_package,10);
408: --
409: END round_val;
410: --
411: ------------------------------------------------------------------------------

Line 738: hr_utility.set_location ('Entering '||l_package,10);

734:
735:
736: BEGIN
737: --
738: hr_utility.set_location ('Entering '||l_package,10);
739: --
740: -- FONM
741: if ben_manage_life_events.fonm = 'Y' then
742: --

Line 754: hr_utility.set_location ('close c_state ',10);

750: --
751: fetch c_state into l_state;
752: --
753: close c_state;
754: hr_utility.set_location ('close c_state ',10);
755: --
756: open c_asg(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date))); -- FONM
757: --
758: fetch c_asg into l_asg; -- doesn't matter if null

Line 761: hr_utility.set_location ('close c_asg ',10);

757: --
758: fetch c_asg into l_asg; -- doesn't matter if null
759: --
760: close c_asg;
761: hr_utility.set_location ('close c_asg ',10);
762: --
763: if p_elig_per_elctbl_chc_id is not null then
764: --
765: open c_epe;

Line 770: hr_utility.set_location ('close c_epe ',10);

766: --
767: fetch c_epe into l_epe;
768: --
769: close c_epe;
770: hr_utility.set_location ('close c_epe ',10);
771: --
772: end if;
773: --
774: if l_epe.oipl_id is not null then

Line 781: hr_utility.set_location ('close c_opt ',10);

777: --
778: fetch c_opt into l_opt;
779: --
780: close c_opt;
781: hr_utility.set_location ('close c_opt ',10);
782: --
783: end if;
784: --
785: -- check boundaries

Line 787: hr_utility.set_location ('limit_checks ',10);

783: end if;
784: --
785: -- check boundaries
786: --
787: hr_utility.set_location ('limit_checks ',10);
788: l_old_val:=l_val;
789: --- bug:1433393 when the vapro not exist then the benefir amount assigned to the
790: --- old_val,
791: --- whne there is no vapro the max limit of benefit is validated to decide

Line 819: hr_utility.set_location ('Dn limit_checks ',10);

815: p_opt_id => l_opt.opt_id,
816: p_ler_id => l_epe.ler_id,
817: p_val => l_val,
818: p_state => l_state.region_2);
819: hr_utility.set_location ('Dn limit_checks ',10);
820: end if ;
821: --
822: -- If the value has been changed due to limits
823: -- and the value has been lowered then we have

Line 829: hr_utility.set_location('old='||l_old_val||' new='||

825: -- written at this same level. If so make this electable
826: -- choice not electable. Do this only for the non Range
827: -- cvg_mlt_cd's.
828: --
829: hr_utility.set_location('old='||l_old_val||' new='||
830: l_val||' limit='|| p_ultmt_upr_lmt,31);
831: hr_utility.set_location('per in ler id '|| l_epe.per_in_ler_id,31);
832: hr_utility.set_location('mult code '|| p_cvg_mlt_cd,31);
833: hr_utility.set_location('pl '|| l_epe.pl_id,31);

Line 831: hr_utility.set_location('per in ler id '|| l_epe.per_in_ler_id,31);

827: -- cvg_mlt_cd's.
828: --
829: hr_utility.set_location('old='||l_old_val||' new='||
830: l_val||' limit='|| p_ultmt_upr_lmt,31);
831: hr_utility.set_location('per in ler id '|| l_epe.per_in_ler_id,31);
832: hr_utility.set_location('mult code '|| p_cvg_mlt_cd,31);
833: hr_utility.set_location('pl '|| l_epe.pl_id,31);
834: hr_utility.set_location('pgm '|| l_epe.pgm_id,31);
835:

Line 832: hr_utility.set_location('mult code '|| p_cvg_mlt_cd,31);

828: --
829: hr_utility.set_location('old='||l_old_val||' new='||
830: l_val||' limit='|| p_ultmt_upr_lmt,31);
831: hr_utility.set_location('per in ler id '|| l_epe.per_in_ler_id,31);
832: hr_utility.set_location('mult code '|| p_cvg_mlt_cd,31);
833: hr_utility.set_location('pl '|| l_epe.pl_id,31);
834: hr_utility.set_location('pgm '|| l_epe.pgm_id,31);
835:
836: if l_val

Line 833: hr_utility.set_location('pl '|| l_epe.pl_id,31);

829: hr_utility.set_location('old='||l_old_val||' new='||
830: l_val||' limit='|| p_ultmt_upr_lmt,31);
831: hr_utility.set_location('per in ler id '|| l_epe.per_in_ler_id,31);
832: hr_utility.set_location('mult code '|| p_cvg_mlt_cd,31);
833: hr_utility.set_location('pl '|| l_epe.pl_id,31);
834: hr_utility.set_location('pgm '|| l_epe.pgm_id,31);
835:
836: if l_val 837: p_cvg_mlt_cd not like '%RNG' and

Line 834: hr_utility.set_location('pgm '|| l_epe.pgm_id,31);

830: l_val||' limit='|| p_ultmt_upr_lmt,31);
831: hr_utility.set_location('per in ler id '|| l_epe.per_in_ler_id,31);
832: hr_utility.set_location('mult code '|| p_cvg_mlt_cd,31);
833: hr_utility.set_location('pl '|| l_epe.pl_id,31);
834: hr_utility.set_location('pgm '|| l_epe.pgm_id,31);
835:
836: if l_val 837: p_cvg_mlt_cd not like '%RNG' and
838: l_epe.elctbl_flag='Y' then

Line 865: hr_utility.set_location('other oipl ' ,90);

861: -- more than one option in same Plan is reduced
862: -- due to Upper Limit, then only one of them is retained
863: -- as Electable.
864: --
865: hr_utility.set_location('other oipl ' ,90);
866: open c_other_oipl_cvg;
867: fetch c_other_oipl_cvg into l_other_cvg;
868: close c_other_oipl_cvg;
869: /* Bug#3585768 - Enrollment limitation will be enforced at the time of enrollment

Line 909: hr_utility.set_location(' other cal ' || l_other_cvg,99);

905: fetch c_other_pl_cvg into l_other_cvg;
906: close c_other_pl_cvg;
907: */
908: end if;
909: hr_utility.set_location(' other cal ' || l_other_cvg,99);
910: if l_other_cvg=l_val then
911: --
912: open c_unrest(l_epe.ler_id);
913: fetch c_unrest into l_dummy;

Line 949: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);

945: p_effective_date => p_effective_date -- FONM : no need to pass cvg or rt dates.
946: );
947: --
948: l_epe.elctbl_flag:='N';
949: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
950: end if;
951: end if;
952: end if;
953: end if;

Line 963: hr_utility.set_location('l_cf_bnft_result.prtt_enrt_rslt_id '||l_cf_bnft_result.prtt_enrt_rslt_id,39);

959: --
960: open c_cf_bnft_result(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date))) ;
961: fetch c_cf_bnft_result into l_cf_bnft_result ;
962: close c_cf_bnft_result ;
963: hr_utility.set_location('l_cf_bnft_result.prtt_enrt_rslt_id '||l_cf_bnft_result.prtt_enrt_rslt_id,39);
964: hr_utility.set_location('l_epe.prtt_enrt_rslt_id '||l_epe.prtt_enrt_rslt_id,39);
965: --
966: l_prtt_enrt_rslt_id := NVL(l_cf_bnft_result.prtt_enrt_rslt_id,l_epe.prtt_enrt_rslt_id);
967: --

Line 964: hr_utility.set_location('l_epe.prtt_enrt_rslt_id '||l_epe.prtt_enrt_rslt_id,39);

960: open c_cf_bnft_result(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date))) ;
961: fetch c_cf_bnft_result into l_cf_bnft_result ;
962: close c_cf_bnft_result ;
963: hr_utility.set_location('l_cf_bnft_result.prtt_enrt_rslt_id '||l_cf_bnft_result.prtt_enrt_rslt_id,39);
964: hr_utility.set_location('l_epe.prtt_enrt_rslt_id '||l_epe.prtt_enrt_rslt_id,39);
965: --
966: l_prtt_enrt_rslt_id := NVL(l_cf_bnft_result.prtt_enrt_rslt_id,l_epe.prtt_enrt_rslt_id);
967: --
968: if g_old_val <> nvl(l_val,-1) or

Line 1014: hr_utility.set_location('l_prtt_enrt_rslt_id '||l_prtt_enrt_rslt_id,39);

1010: l_prtt_enrt_rslt_id := null;
1011: --
1012: end if;
1013: --
1014: hr_utility.set_location('l_prtt_enrt_rslt_id '||l_prtt_enrt_rslt_id,39);
1015: hr_utility.set_location('l_crnt_enrld_flag'||l_crnt_enrld_flag,39);
1016: --
1017: if not p_calculate_only_mode then
1018: --

Line 1015: hr_utility.set_location('l_crnt_enrld_flag'||l_crnt_enrld_flag,39);

1011: --
1012: end if;
1013: --
1014: hr_utility.set_location('l_prtt_enrt_rslt_id '||l_prtt_enrt_rslt_id,39);
1015: hr_utility.set_location('l_crnt_enrld_flag'||l_crnt_enrld_flag,39);
1016: --
1017: if not p_calculate_only_mode then
1018: --
1019: open c_unrest(l_epe.ler_id);

Line 1107: hr_utility.set_location ('Leaving '||l_package,10);

1103: p_enb_valrow.mx_wout_ctfn_val := p_mx_wout_ctfn_val;
1104: p_enb_valrow.incrmt_val := p_incrmt_val;
1105: p_enb_valrow.dflt_val := p_dflt_val;
1106: --
1107: hr_utility.set_location ('Leaving '||l_package,10);
1108: --
1109: END write_coverage;
1110: --
1111: ------------------------------------------------------------------------

Line 1122: hr_utility.set_location ('Entering '||l_package,10);

1118: l_package varchar2(80) := g_package||'.combine_with_variable_val';
1119: --
1120: BEGIN
1121: --
1122: hr_utility.set_location ('Entering '||l_package,10);
1123: --
1124: if p_vr_val is null then
1125: --
1126: p_combined_val := p_val;

Line 1168: hr_utility.set_location ('Leaving '||l_package,10);

1164: p_combined_val := p_vr_val;
1165: --
1166: end if;
1167: --
1168: hr_utility.set_location ('Leaving '||l_package,10);
1169: --
1170: END combine_with_variable_val;
1171: --
1172: ----------------------------------------------------------------------------

Line 1238: hr_utility.set_location ('Entering '||l_package,10);

1234: l_person_id number;
1235:
1236: BEGIN
1237: --
1238: hr_utility.set_location ('Entering '||l_package,10);
1239: --
1240: l_max_possible_amt := p_mx_cvg_wcfn_amt;
1241: l_mn_amt := p_mn_cvg_rqd_amt;
1242: l_mx_amt := p_mx_cvg_alwd_amt;

Line 1253: hr_utility.set_location ('l_max_possible_amt '||l_max_possible_amt,111);

1249: --Bug 3695079
1250: --l_max_possible_amt amount should be the min of p_mx_cvg_wcfn_amt and p_mx_cvg_incr_wcf_alwd_amt
1251: --p_mx_cvg_incr_wcf_alwd_amt is defined otherwise we need to take only p_mx_cvg_wcfn_amt
1252: --
1253: hr_utility.set_location ('l_max_possible_amt '||l_max_possible_amt,111);
1254: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt '||p_mx_cvg_incr_wcf_alwd_amt,111);
1255: if p_mx_cvg_incr_wcf_alwd_amt IS NOT NULL then
1256: --
1257: if l_max_possible_amt IS NULL OR

Line 1254: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt '||p_mx_cvg_incr_wcf_alwd_amt,111);

1250: --l_max_possible_amt amount should be the min of p_mx_cvg_wcfn_amt and p_mx_cvg_incr_wcf_alwd_amt
1251: --p_mx_cvg_incr_wcf_alwd_amt is defined otherwise we need to take only p_mx_cvg_wcfn_amt
1252: --
1253: hr_utility.set_location ('l_max_possible_amt '||l_max_possible_amt,111);
1254: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt '||p_mx_cvg_incr_wcf_alwd_amt,111);
1255: if p_mx_cvg_incr_wcf_alwd_amt IS NOT NULL then
1256: --
1257: if l_max_possible_amt IS NULL OR
1258: nvl(l_max_possible_amt,0) > (p_mx_cvg_incr_wcf_alwd_amt + nvl(p_crnt_bnft_amt,0)) then

Line 1260: hr_utility.set_location ('l_max_possible_amt inside '||l_max_possible_amt,111);

1256: --
1257: if l_max_possible_amt IS NULL OR
1258: nvl(l_max_possible_amt,0) > (p_mx_cvg_incr_wcf_alwd_amt + nvl(p_crnt_bnft_amt,0)) then
1259: l_max_possible_amt := p_mx_cvg_incr_wcf_alwd_amt + nvl(p_crnt_bnft_amt,0);
1260: hr_utility.set_location ('l_max_possible_amt inside '||l_max_possible_amt,111);
1261: end if;
1262: --
1263: end if;
1264: --

Line 1340: hr_utility.set_location ('Plan PL_ID -> '||p_pl_id ,33);

1336: --
1337: end if;
1338: --
1339:
1340: hr_utility.set_location ('Plan PL_ID -> '||p_pl_id ,33);
1341: hr_utility.set_location ('p_mx_cvg_wcfn_amt -> '||p_mx_cvg_wcfn_amt ,33);
1342: hr_utility.set_location ('p_mx_cvg_wcfn_mlt_num -> '||p_mx_cvg_wcfn_mlt_num ,33);
1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);
1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);

Line 1341: hr_utility.set_location ('p_mx_cvg_wcfn_amt -> '||p_mx_cvg_wcfn_amt ,33);

1337: end if;
1338: --
1339:
1340: hr_utility.set_location ('Plan PL_ID -> '||p_pl_id ,33);
1341: hr_utility.set_location ('p_mx_cvg_wcfn_amt -> '||p_mx_cvg_wcfn_amt ,33);
1342: hr_utility.set_location ('p_mx_cvg_wcfn_mlt_num -> '||p_mx_cvg_wcfn_mlt_num ,33);
1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);
1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);
1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);

Line 1342: hr_utility.set_location ('p_mx_cvg_wcfn_mlt_num -> '||p_mx_cvg_wcfn_mlt_num ,33);

1338: --
1339:
1340: hr_utility.set_location ('Plan PL_ID -> '||p_pl_id ,33);
1341: hr_utility.set_location ('p_mx_cvg_wcfn_amt -> '||p_mx_cvg_wcfn_amt ,33);
1342: hr_utility.set_location ('p_mx_cvg_wcfn_mlt_num -> '||p_mx_cvg_wcfn_mlt_num ,33);
1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);
1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);
1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);
1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);

Line 1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);

1339:
1340: hr_utility.set_location ('Plan PL_ID -> '||p_pl_id ,33);
1341: hr_utility.set_location ('p_mx_cvg_wcfn_amt -> '||p_mx_cvg_wcfn_amt ,33);
1342: hr_utility.set_location ('p_mx_cvg_wcfn_mlt_num -> '||p_mx_cvg_wcfn_mlt_num ,33);
1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);
1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);
1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);
1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);
1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);

Line 1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);

1340: hr_utility.set_location ('Plan PL_ID -> '||p_pl_id ,33);
1341: hr_utility.set_location ('p_mx_cvg_wcfn_amt -> '||p_mx_cvg_wcfn_amt ,33);
1342: hr_utility.set_location ('p_mx_cvg_wcfn_mlt_num -> '||p_mx_cvg_wcfn_mlt_num ,33);
1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);
1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);
1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);
1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);
1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);
1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);

Line 1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);

1341: hr_utility.set_location ('p_mx_cvg_wcfn_amt -> '||p_mx_cvg_wcfn_amt ,33);
1342: hr_utility.set_location ('p_mx_cvg_wcfn_mlt_num -> '||p_mx_cvg_wcfn_mlt_num ,33);
1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);
1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);
1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);
1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);
1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);
1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);
1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);

Line 1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);

1342: hr_utility.set_location ('p_mx_cvg_wcfn_mlt_num -> '||p_mx_cvg_wcfn_mlt_num ,33);
1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);
1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);
1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);
1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);
1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);
1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);
1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);
1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);

Line 1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);

1343: hr_utility.set_location ('p_mx_cvg_mlt_incr_num -> '||p_mx_cvg_mlt_incr_num ,33);
1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);
1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);
1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);
1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);
1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);
1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);
1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);
1351: hr_utility.set_location ('p_ordr_num -> '||p_ordr_num ,33);

Line 1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);

1344: hr_utility.set_location ('p_mx_cvg_mlt_incr_wcf_num -> '||p_mx_cvg_mlt_incr_wcf_num ,33);
1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);
1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);
1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);
1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);
1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);
1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);
1351: hr_utility.set_location ('p_ordr_num -> '||p_ordr_num ,33);
1352: hr_utility.set_location ('p_crnt_ordr_num -> '||p_crnt_ordr_num ,33);

Line 1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);

1345: hr_utility.set_location ('p_mx_cvg_incr_alwd_amt -> '||p_mx_cvg_incr_alwd_amt ,33);
1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);
1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);
1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);
1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);
1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);
1351: hr_utility.set_location ('p_ordr_num -> '||p_ordr_num ,33);
1352: hr_utility.set_location ('p_crnt_ordr_num -> '||p_crnt_ordr_num ,33);
1353: --Bug No:4436573 Debugging purpose

Line 1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);

1346: hr_utility.set_location ('p_mx_cvg_incr_wcf_alwd_amt -> '||p_mx_cvg_incr_wcf_alwd_amt,33);
1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);
1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);
1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);
1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);
1351: hr_utility.set_location ('p_ordr_num -> '||p_ordr_num ,33);
1352: hr_utility.set_location ('p_crnt_ordr_num -> '||p_crnt_ordr_num ,33);
1353: --Bug No:4436573 Debugging purpose
1354: hr_utility.set_location ('p_cvg_mlt_cd -> '||p_cvg_mlt_cd ,33);

Line 1351: hr_utility.set_location ('p_ordr_num -> '||p_ordr_num ,33);

1347: hr_utility.set_location ('p_mx_cvg_rl -> '||p_mx_cvg_rl ,33);
1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);
1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);
1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);
1351: hr_utility.set_location ('p_ordr_num -> '||p_ordr_num ,33);
1352: hr_utility.set_location ('p_crnt_ordr_num -> '||p_crnt_ordr_num ,33);
1353: --Bug No:4436573 Debugging purpose
1354: hr_utility.set_location ('p_cvg_mlt_cd -> '||p_cvg_mlt_cd ,33);
1355: --End Bug No:4436573

Line 1352: hr_utility.set_location ('p_crnt_ordr_num -> '||p_crnt_ordr_num ,33);

1348: hr_utility.set_location ('p_mn_cvg_rl -> '||p_mn_cvg_rl ,33);
1349: hr_utility.set_location ('p_combined_val -> '||p_combined_val ,33);
1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);
1351: hr_utility.set_location ('p_ordr_num -> '||p_ordr_num ,33);
1352: hr_utility.set_location ('p_crnt_ordr_num -> '||p_crnt_ordr_num ,33);
1353: --Bug No:4436573 Debugging purpose
1354: hr_utility.set_location ('p_cvg_mlt_cd -> '||p_cvg_mlt_cd ,33);
1355: --End Bug No:4436573
1356: --

Line 1354: hr_utility.set_location ('p_cvg_mlt_cd -> '||p_cvg_mlt_cd ,33);

1350: hr_utility.set_location ('p_crnt_bnft_amt -> '||p_crnt_bnft_amt ,33);
1351: hr_utility.set_location ('p_ordr_num -> '||p_ordr_num ,33);
1352: hr_utility.set_location ('p_crnt_ordr_num -> '||p_crnt_ordr_num ,33);
1353: --Bug No:4436573 Debugging purpose
1354: hr_utility.set_location ('p_cvg_mlt_cd -> '||p_cvg_mlt_cd ,33);
1355: --End Bug No:4436573
1356: --
1357: if p_combined_val is null then
1358: --

Line 1408: hr_utility.set_location(' IK1 p_combined_val - nvl(p_crnt_bnft_amt,0))'||(p_combined_val - nvl(p_crnt_bnft_amt,0)),99);

1404: --
1405: elsif (p_combined_val - nvl(p_crnt_bnft_amt,0))
1406: <= p_mx_cvg_incr_wcf_alwd_amt then
1407: --
1408: hr_utility.set_location(' IK1 p_combined_val - nvl(p_crnt_bnft_amt,0))'||(p_combined_val - nvl(p_crnt_bnft_amt,0)),99);
1409: hr_utility.set_location('IK1 p_mx_cvg_incr_wcf_alwd_amt'||p_mx_cvg_incr_wcf_alwd_amt,99);
1410: p_ctfn_rqd := 'Y';
1411: p_write_rec := true;
1412: --

Line 1409: hr_utility.set_location('IK1 p_mx_cvg_incr_wcf_alwd_amt'||p_mx_cvg_incr_wcf_alwd_amt,99);

1405: elsif (p_combined_val - nvl(p_crnt_bnft_amt,0))
1406: <= p_mx_cvg_incr_wcf_alwd_amt then
1407: --
1408: hr_utility.set_location(' IK1 p_combined_val - nvl(p_crnt_bnft_amt,0))'||(p_combined_val - nvl(p_crnt_bnft_amt,0)),99);
1409: hr_utility.set_location('IK1 p_mx_cvg_incr_wcf_alwd_amt'||p_mx_cvg_incr_wcf_alwd_amt,99);
1410: p_ctfn_rqd := 'Y';
1411: p_write_rec := true;
1412: --
1413: elsif (p_ordr_num - nvl(p_crnt_ordr_num,0))<= p_mx_cvg_mlt_incr_wcf_num then

Line 1426: hr_utility.set_location (' p_write_rec ',10);

1422: --
1423: end if;
1424: --
1425: if p_write_rec then
1426: hr_utility.set_location (' p_write_rec ',10);
1427: end if ;
1428:
1429: hr_utility.set_location (' p_no_mx_cvg_amt_apls_flag'|| p_no_mx_cvg_amt_apls_flag,10);
1430:

Line 1429: hr_utility.set_location (' p_no_mx_cvg_amt_apls_flag'|| p_no_mx_cvg_amt_apls_flag,10);

1425: if p_write_rec then
1426: hr_utility.set_location (' p_write_rec ',10);
1427: end if ;
1428:
1429: hr_utility.set_location (' p_no_mx_cvg_amt_apls_flag'|| p_no_mx_cvg_amt_apls_flag,10);
1430:
1431: -- This Certification condition is not based on increases,
1432: -- but based on a fixed amount. (Bug 1142060)
1433: -- no max flag is validated for # 2736519

Line 1443: hr_utility.set_location ('IK l_mx_amt '||l_mx_amt,20);

1439: -- benefit amount of 75,000. Now we need certification only for the
1440: -- amount more than 75,000 even if there are no increases defined by
1441: -- the customer.
1442: --
1443: hr_utility.set_location ('IK l_mx_amt '||l_mx_amt,20);
1444: hr_utility.set_location ('IK p_crnt_bnft_amt '||p_crnt_bnft_amt,20);
1445: --
1446: if p_entr_val_at_enrt_flag = 'N' then
1447: --

Line 1444: hr_utility.set_location ('IK p_crnt_bnft_amt '||p_crnt_bnft_amt,20);

1440: -- amount more than 75,000 even if there are no increases defined by
1441: -- the customer.
1442: --
1443: hr_utility.set_location ('IK l_mx_amt '||l_mx_amt,20);
1444: hr_utility.set_location ('IK p_crnt_bnft_amt '||p_crnt_bnft_amt,20);
1445: --
1446: if p_entr_val_at_enrt_flag = 'N' then
1447: --
1448: l_mx_amt := greatest(l_mx_amt,nvl(p_crnt_bnft_amt,0));

Line 1455: hr_utility.set_location ('IK I am Here'||p_combined_val,99);

1451: --
1452: if p_write_rec and
1453: ( p_combined_val > l_mx_amt or p_no_mx_cvg_amt_apls_flag = 'Y') then
1454: --
1455: hr_utility.set_location ('IK I am Here'||p_combined_val,99);
1456: hr_utility.set_location ('IK l_mx_amt'||l_mx_amt ,99);
1457: p_check_received:=true;
1458: p_ctfn_rqd := 'Y';
1459: --

Line 1456: hr_utility.set_location ('IK l_mx_amt'||l_mx_amt ,99);

1452: if p_write_rec and
1453: ( p_combined_val > l_mx_amt or p_no_mx_cvg_amt_apls_flag = 'Y') then
1454: --
1455: hr_utility.set_location ('IK I am Here'||p_combined_val,99);
1456: hr_utility.set_location ('IK l_mx_amt'||l_mx_amt ,99);
1457: p_check_received:=true;
1458: p_ctfn_rqd := 'Y';
1459: --
1460: end if;

Line 1462: hr_utility.set_location ('p_ctfn_rqd '||p_ctfn_rqd,09);

1458: p_ctfn_rqd := 'Y';
1459: --
1460: end if;
1461: --
1462: hr_utility.set_location ('p_ctfn_rqd '||p_ctfn_rqd,09);
1463: --
1464: if p_write_rec and p_entr_val_at_enrt_flag = 'Y' and
1465: (l_mx_amt < l_max_possible_amt
1466: or l_max_possible_amt is not null)

Line 1468: hr_utility.set_location ('IK ENTRVALENRT case',99);

1464: if p_write_rec and p_entr_val_at_enrt_flag = 'Y' and
1465: (l_mx_amt < l_max_possible_amt
1466: or l_max_possible_amt is not null)
1467: then
1468: hr_utility.set_location ('IK ENTRVALENRT case',99);
1469: p_ctfn_rqd := 'Y';
1470: end if;
1471: --
1472: if p_cvg_mlt_cd = 'ERL' then

Line 1486: hr_utility.set_location ('p_ctfn_rqd '||p_ctfn_rqd,10);

1482: END if;
1483: --
1484: END if;
1485: --
1486: hr_utility.set_location ('p_ctfn_rqd '||p_ctfn_rqd,10);
1487: hr_utility.set_location ('Leaving '||l_package,10);
1488: --
1489: END chk_bnft_ctfn;
1490: --

Line 1487: hr_utility.set_location ('Leaving '||l_package,10);

1483: --
1484: END if;
1485: --
1486: hr_utility.set_location ('p_ctfn_rqd '||p_ctfn_rqd,10);
1487: hr_utility.set_location ('Leaving '||l_package,10);
1488: --
1489: END chk_bnft_ctfn;
1490: --
1491: ------------------------------------------------------------------------------

Line 1948: hr_utility.set_location('IK l_combined_val '||l_combined_val,20);

1944: --
1945: -- ctfn's at the option level are written in benchctf.pkb
1946: -- don't write them at the bnft level too. Bug 1277371.
1947: --
1948: hr_utility.set_location('IK l_combined_val '||l_combined_val,20);
1949: hr_utility.set_location('IK l_enrt_bnft_id '||l_enrt_bnft_id,20);
1950: hr_utility.set_location('IK p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,20);
1951: --
1952: if l_ler_bnft_rstrn_id is not null then

Line 1949: hr_utility.set_location('IK l_enrt_bnft_id '||l_enrt_bnft_id,20);

1945: -- ctfn's at the option level are written in benchctf.pkb
1946: -- don't write them at the bnft level too. Bug 1277371.
1947: --
1948: hr_utility.set_location('IK l_combined_val '||l_combined_val,20);
1949: hr_utility.set_location('IK l_enrt_bnft_id '||l_enrt_bnft_id,20);
1950: hr_utility.set_location('IK p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,20);
1951: --
1952: if l_ler_bnft_rstrn_id is not null then
1953: for l_ctfn in c_ler_rstrn_ctfn(nvl(l_fonm_cvg_strt_dt,l_effective_date)) loop -- FONM

Line 1950: hr_utility.set_location('IK p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,20);

1946: -- don't write them at the bnft level too. Bug 1277371.
1947: --
1948: hr_utility.set_location('IK l_combined_val '||l_combined_val,20);
1949: hr_utility.set_location('IK l_enrt_bnft_id '||l_enrt_bnft_id,20);
1950: hr_utility.set_location('IK p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,20);
1951: --
1952: if l_ler_bnft_rstrn_id is not null then
1953: for l_ctfn in c_ler_rstrn_ctfn(nvl(l_fonm_cvg_strt_dt,l_effective_date)) loop -- FONM
1954: l_ctfn_received:='N';

Line 1988: hr_utility.set_location('IK Else Write CTFN',99);

1984: end if;
1985: end loop;
1986: --
1987: else
1988: hr_utility.set_location('IK Else Write CTFN',99);
1989: --
1990: for l_ctfn in c_pl_rstrn_ctfn ( nvl(l_fonm_cvg_strt_dt, l_effective_date)) loop -- FONM
1991: l_ctfn_received:='N';
1992: if l_check_received then

Line 1993: hr_utility.set_location('IK Check ctfn TRUE',89);

1989: --
1990: for l_ctfn in c_pl_rstrn_ctfn ( nvl(l_fonm_cvg_strt_dt, l_effective_date)) loop -- FONM
1991: l_ctfn_received:='N';
1992: if l_check_received then
1993: hr_utility.set_location('IK Check ctfn TRUE',89);
1994: open c_ctfn_received(
1995: p_pgm_id =>l_epe.pgm_id,
1996: p_pl_id =>l_epe.pl_id,
1997: p_enrt_ctfn_typ_cd =>l_ctfn.enrt_ctfn_typ_cd,

Line 2006: hr_utility.set_location('IK l_ctfn_received=N',99) ;

2002: close c_ctfn_received;
2003: end if;
2004: if l_ctfn_received='N' then
2005: --
2006: hr_utility.set_location('IK l_ctfn_received=N',99) ;
2007: --
2008: ben_determine_chc_ctfn.write_ctfn
2009: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
2010: p_enrt_bnft_id => l_enrt_bnft_id,

Line 2033: hr_utility.set_location ('Entering '||l_package,10);

2029: end write_ctfn;
2030: --
2031: BEGIN
2032: --
2033: hr_utility.set_location ('Entering '||l_package,10);
2034: --
2035: --
2036: -- Bug 1895846
2037: open c_epe_in_pndg ;

Line 2042: hr_utility.set_location ('Suspended or Pending work flow records exist ' , 10);

2038: --
2039: fetch c_epe_in_pndg into l_dummy ;
2040: if c_epe_in_pndg%found then
2041: --
2042: hr_utility.set_location ('Suspended or Pending work flow records exist ' , 10);
2043: hr_utility.set_location ('Leaving '||l_package,10);
2044: close c_epe_in_pndg ;
2045: return ;
2046: --

Line 2043: hr_utility.set_location ('Leaving '||l_package,10);

2039: fetch c_epe_in_pndg into l_dummy ;
2040: if c_epe_in_pndg%found then
2041: --
2042: hr_utility.set_location ('Suspended or Pending work flow records exist ' , 10);
2043: hr_utility.set_location ('Leaving '||l_package,10);
2044: close c_epe_in_pndg ;
2045: return ;
2046: --
2047: end if;

Line 2111: hr_utility.set_location ('pl_id '||ben_epe_cache.g_currcobjepe_row.pl_id,10);

2107: --
2108: -- Walk the comp object tree for the electable choice and get
2109: -- the appropriate coverage details
2110: --
2111: hr_utility.set_location ('pl_id '||ben_epe_cache.g_currcobjepe_row.pl_id,10);
2112: hr_utility.set_location ('elig choice id'||p_elig_per_elctbl_chc_id,11);
2113: ben_cvg_cache.epecobjtree_getcvgdets
2114: (p_epe_id => p_elig_per_elctbl_chc_id
2115: ,p_epe_pl_id => ben_epe_cache.g_currcobjepe_row.pl_id

Line 2112: hr_utility.set_location ('elig choice id'||p_elig_per_elctbl_chc_id,11);

2108: -- Walk the comp object tree for the electable choice and get
2109: -- the appropriate coverage details
2110: --
2111: hr_utility.set_location ('pl_id '||ben_epe_cache.g_currcobjepe_row.pl_id,10);
2112: hr_utility.set_location ('elig choice id'||p_elig_per_elctbl_chc_id,11);
2113: ben_cvg_cache.epecobjtree_getcvgdets
2114: (p_epe_id => p_elig_per_elctbl_chc_id
2115: ,p_epe_pl_id => ben_epe_cache.g_currcobjepe_row.pl_id
2116: ,p_epe_plip_id => ben_epe_cache.g_currcobjepe_row.plip_id

Line 2130: hr_utility.set_location ('open c_epe ',10);

2126: --
2127: end if;
2128: */
2129: --
2130: hr_utility.set_location ('open c_epe ',10);
2131: open c_epe;
2132: --
2133: fetch c_epe into l_epe;
2134: --

Line 2147: hr_utility.set_location ('close c_epe ',10);

2143: --
2144: end if;
2145: --
2146: close c_epe;
2147: hr_utility.set_location ('close c_epe ',10);
2148: hr_utility.set_location ('pl_id'||l_epe.pl_id,10);
2149: if p_calculate_only_mode then
2150: ben_cvg_cache.epecobjtree_getcvgdets
2151: (p_epe_id => p_elig_per_elctbl_chc_id

Line 2148: hr_utility.set_location ('pl_id'||l_epe.pl_id,10);

2144: end if;
2145: --
2146: close c_epe;
2147: hr_utility.set_location ('close c_epe ',10);
2148: hr_utility.set_location ('pl_id'||l_epe.pl_id,10);
2149: if p_calculate_only_mode then
2150: ben_cvg_cache.epecobjtree_getcvgdets
2151: (p_epe_id => p_elig_per_elctbl_chc_id
2152: ,p_epe_pl_id => l_epe.pl_id

Line 2175: hr_utility.set_location('No Coverage For EPE_ID = ' || p_elig_per_elctbl_chc_id, 8787);

2171: --
2172: if l_dummy = 'Y'
2173: then
2174: --
2175: hr_utility.set_location('No Coverage For EPE_ID = ' || p_elig_per_elctbl_chc_id, 8787);
2176: l_enrt_bnft_id := ben_manage_unres_life_events.enb_exists(p_elig_per_elctbl_chc_id,1);
2177: hr_utility.set_location('l_enrt_bnft_id = ' || l_enrt_bnft_id, 8787);
2178: --
2179: IF l_enrt_bnft_id is not null

Line 2177: hr_utility.set_location('l_enrt_bnft_id = ' || l_enrt_bnft_id, 8787);

2173: then
2174: --
2175: hr_utility.set_location('No Coverage For EPE_ID = ' || p_elig_per_elctbl_chc_id, 8787);
2176: l_enrt_bnft_id := ben_manage_unres_life_events.enb_exists(p_elig_per_elctbl_chc_id,1);
2177: hr_utility.set_location('l_enrt_bnft_id = ' || l_enrt_bnft_id, 8787);
2178: --
2179: IF l_enrt_bnft_id is not null
2180: THEN
2181: --

Line 2327: hr_utility.set_location (' BDVR_MN ',10);

2323: end if;
2324: --
2325: end if;
2326: --
2327: hr_utility.set_location (' BDVR_MN ',10);
2328:
2329: ben_determine_variable_rates.main -- FONM procedure have to take care of it
2330: (p_person_id => l_epe.person_id,
2331: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,

Line 2349: hr_utility.set_location (' Dn BDVR_MN ',10);

2345: p_ultmt_upr_lmt => l_ultmt_upr_lmt,
2346: p_ultmt_lwr_lmt => l_ultmt_lwr_lmt,
2347: p_ultmt_upr_lmt_calc_rl => l_ultmt_upr_lmt_calc_rl,
2348: p_ultmt_lwr_lmt_calc_rl => l_ultmt_lwr_lmt_calc_rl ); -- output
2349: hr_utility.set_location (' Dn BDVR_MN ',10);
2350: -- this variabl intialisation used to chek whether the benefit crossed the max limit
2351: -- in benefit write. if the vapro defined then then ultimate level is used
2352: -- if there is no vapro then benefit level used for the validation bug:1433393
2353:

Line 2354: hr_utility.set_location(' treatment code ' || l_vr_trtmt_cd ||' ' || l_vr_val , 999);

2350: -- this variabl intialisation used to chek whether the benefit crossed the max limit
2351: -- in benefit write. if the vapro defined then then ultimate level is used
2352: -- if there is no vapro then benefit level used for the validation bug:1433393
2353:
2354: hr_utility.set_location(' treatment code ' || l_vr_trtmt_cd ||' ' || l_vr_val , 999);
2355:
2356: if l_vr_val is not null or l_vr_trtmt_cd is not null then
2357: l_vapro_exist := 'Y' ;
2358: --- Tilak : this code is not validating whether the enter at enrollemt is defined

Line 2404: hr_utility.set_location('min max ' || l_mn_elcn_val ||' ' || l_mx_elcn_val|| ' '|| l_vapro_exist , 999);

2400:
2401: ---
2402: end if ;
2403:
2404: hr_utility.set_location('min max ' || l_mn_elcn_val ||' ' || l_mx_elcn_val|| ' '|| l_vapro_exist , 999);
2405: --
2406: l_ccm_max_val := l_mx_elcn_val; /* Bug 3828288 */
2407: --
2408: --Bug 6054310 -- This condition should only be there for NSVU

Line 2426: hr_utility.set_location ('l_ler_id '||l_ler_id,55);

2422: -- pay_mag_utils.lookup_jurisdiction_code
2423: -- (p_state => l_state.region_2);
2424: -- end if;
2425:
2426: hr_utility.set_location ('l_ler_id '||l_ler_id,55);
2427: hr_utility.set_location ('l_pl_id '||l_pl_id,55);
2428: hr_utility.set_location ('l_oipl_id '||l_oipl_id,55);
2429: hr_utility.set_location ('l_business_group_id '||l_business_group_id,55);
2430: hr_utility.set_location ('l_cvg(0).bnft_or_option_rstrctn_cd '||

Line 2427: hr_utility.set_location ('l_pl_id '||l_pl_id,55);

2423: -- (p_state => l_state.region_2);
2424: -- end if;
2425:
2426: hr_utility.set_location ('l_ler_id '||l_ler_id,55);
2427: hr_utility.set_location ('l_pl_id '||l_pl_id,55);
2428: hr_utility.set_location ('l_oipl_id '||l_oipl_id,55);
2429: hr_utility.set_location ('l_business_group_id '||l_business_group_id,55);
2430: hr_utility.set_location ('l_cvg(0).bnft_or_option_rstrctn_cd '||
2431: l_cvg(0).bnft_or_option_rstrctn_cd,33);

Line 2428: hr_utility.set_location ('l_oipl_id '||l_oipl_id,55);

2424: -- end if;
2425:
2426: hr_utility.set_location ('l_ler_id '||l_ler_id,55);
2427: hr_utility.set_location ('l_pl_id '||l_pl_id,55);
2428: hr_utility.set_location ('l_oipl_id '||l_oipl_id,55);
2429: hr_utility.set_location ('l_business_group_id '||l_business_group_id,55);
2430: hr_utility.set_location ('l_cvg(0).bnft_or_option_rstrctn_cd '||
2431: l_cvg(0).bnft_or_option_rstrctn_cd,33);
2432:

Line 2429: hr_utility.set_location ('l_business_group_id '||l_business_group_id,55);

2425:
2426: hr_utility.set_location ('l_ler_id '||l_ler_id,55);
2427: hr_utility.set_location ('l_pl_id '||l_pl_id,55);
2428: hr_utility.set_location ('l_oipl_id '||l_oipl_id,55);
2429: hr_utility.set_location ('l_business_group_id '||l_business_group_id,55);
2430: hr_utility.set_location ('l_cvg(0).bnft_or_option_rstrctn_cd '||
2431: l_cvg(0).bnft_or_option_rstrctn_cd,33);
2432:
2433: l_pl_id := l_epe.pl_id;

Line 2430: hr_utility.set_location ('l_cvg(0).bnft_or_option_rstrctn_cd '||

2426: hr_utility.set_location ('l_ler_id '||l_ler_id,55);
2427: hr_utility.set_location ('l_pl_id '||l_pl_id,55);
2428: hr_utility.set_location ('l_oipl_id '||l_oipl_id,55);
2429: hr_utility.set_location ('l_business_group_id '||l_business_group_id,55);
2430: hr_utility.set_location ('l_cvg(0).bnft_or_option_rstrctn_cd '||
2431: l_cvg(0).bnft_or_option_rstrctn_cd,33);
2432:
2433: l_pl_id := l_epe.pl_id;
2434: l_ler_id := l_epe.ler_id;

Line 2445: hr_utility.set_location ('c_ler_rstrn not found ',33);

2441: --
2442: open c_ler_rstrn( nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))); -- FONM
2443: fetch c_ler_rstrn into l_rstrn;
2444: if c_ler_rstrn%notfound then
2445: hr_utility.set_location ('c_ler_rstrn not found ',33);
2446: close c_ler_rstrn;
2447:
2448: open c_pl_rstrn( nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date))); -- FONM;
2449: fetch c_pl_rstrn into l_rstrn;

Line 2452: hr_utility.set_location ('c_pl_rstrn not found ',33);

2448: open c_pl_rstrn( nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date))); -- FONM;
2449: fetch c_pl_rstrn into l_rstrn;
2450:
2451: if c_pl_rstrn%notfound then
2452: hr_utility.set_location ('c_pl_rstrn not found ',33);
2453: l_rstrn_found := false;
2454: else
2455: hr_utility.set_location ('c_pl_rstrn found ',33);
2456: hr_utility.set_location ('l_rstrn.ler_bnft_rstrn_id '||l_rstrn.ler_bnft_rstrn_id,33);

Line 2455: hr_utility.set_location ('c_pl_rstrn found ',33);

2451: if c_pl_rstrn%notfound then
2452: hr_utility.set_location ('c_pl_rstrn not found ',33);
2453: l_rstrn_found := false;
2454: else
2455: hr_utility.set_location ('c_pl_rstrn found ',33);
2456: hr_utility.set_location ('l_rstrn.ler_bnft_rstrn_id '||l_rstrn.ler_bnft_rstrn_id,33);
2457: l_rstrn_found := true;
2458: end if;
2459: close c_pl_rstrn;

Line 2456: hr_utility.set_location ('l_rstrn.ler_bnft_rstrn_id '||l_rstrn.ler_bnft_rstrn_id,33);

2452: hr_utility.set_location ('c_pl_rstrn not found ',33);
2453: l_rstrn_found := false;
2454: else
2455: hr_utility.set_location ('c_pl_rstrn found ',33);
2456: hr_utility.set_location ('l_rstrn.ler_bnft_rstrn_id '||l_rstrn.ler_bnft_rstrn_id,33);
2457: l_rstrn_found := true;
2458: end if;
2459: close c_pl_rstrn;
2460: else

Line 2461: hr_utility.set_location ('c_ler_rstrn found ',33);

2457: l_rstrn_found := true;
2458: end if;
2459: close c_pl_rstrn;
2460: else
2461: hr_utility.set_location ('c_ler_rstrn found ',33);
2462: hr_utility.set_location ('l_rstrn.ler_bnft_rstrn_id '||l_rstrn.ler_bnft_rstrn_id,33);
2463: l_ler_bnft_rstrn_id := l_rstrn.ler_bnft_rstrn_id;
2464: l_rstrn_found := true;
2465: close c_ler_rstrn;

Line 2462: hr_utility.set_location ('l_rstrn.ler_bnft_rstrn_id '||l_rstrn.ler_bnft_rstrn_id,33);

2458: end if;
2459: close c_pl_rstrn;
2460: else
2461: hr_utility.set_location ('c_ler_rstrn found ',33);
2462: hr_utility.set_location ('l_rstrn.ler_bnft_rstrn_id '||l_rstrn.ler_bnft_rstrn_id,33);
2463: l_ler_bnft_rstrn_id := l_rstrn.ler_bnft_rstrn_id;
2464: l_rstrn_found := true;
2465: close c_ler_rstrn;
2466: end if;

Line 2510: hr_utility.set_location(' l_dflt_to_asn_pndg_ctfn_cd ' || l_dflt_to_asn_pndg_ctfn_cd,99095);

2506: ,p_interim_epe_id => l_interim_elctbl_chc_id
2507: ,p_interim_bnft_amt => l_interim_bnft_amt
2508: );
2509:
2510: hr_utility.set_location(' l_dflt_to_asn_pndg_ctfn_cd ' || l_dflt_to_asn_pndg_ctfn_cd,99095);
2511:
2512: IF l_interim_elctbl_chc_id IS NOT NULL THEN
2513: --
2514: l_dflt_to_asn_pndg_ctfn_cd := null;

Line 2515: hr_utility.set_location(' l_dflt_to_asn_pndg_ctfn_cd ' || l_dflt_to_asn_pndg_ctfn_cd,99096);

2511:
2512: IF l_interim_elctbl_chc_id IS NOT NULL THEN
2513: --
2514: l_dflt_to_asn_pndg_ctfn_cd := null;
2515: hr_utility.set_location(' l_dflt_to_asn_pndg_ctfn_cd ' || l_dflt_to_asn_pndg_ctfn_cd,99096);
2516: --
2517: END IF;
2518: --
2519: l_rstrn.dflt_to_asn_pndg_ctfn_cd := l_DFLT_TO_ASN_PNDG_CTFN_CD ;

Line 2521: hr_utility.set_location('SSARAKR l_dflt_to_asn_pndg_ctfn_cd ' || l_rstrn.dflt_to_asn_pndg_ctfn_cd,99097);

2517: END IF;
2518: --
2519: l_rstrn.dflt_to_asn_pndg_ctfn_cd := l_DFLT_TO_ASN_PNDG_CTFN_CD ;
2520:
2521: hr_utility.set_location('SSARAKR l_dflt_to_asn_pndg_ctfn_cd ' || l_rstrn.dflt_to_asn_pndg_ctfn_cd,99097);
2522:
2523: End if;
2524:
2525: /* Supriya Ends bug 5529258 */

Line 2533: hr_utility.set_location ('l_incr_r_decr_cd '||l_incr_r_decr_cd,33);

2529: else
2530: l_incr_r_decr_cd := l_cvg(0).cvg_incr_r_decr_only_cd;
2531: end if;
2532:
2533: hr_utility.set_location ('l_incr_r_decr_cd '||l_incr_r_decr_cd,33);
2534: --
2535: -- We check increases only if the restriction code is 'BNFT', so make
2536: -- the "increases" values nulll.
2537: --

Line 2549: hr_utility.set_location (' open c_current_enrt ',10);

2545: l_rstrn.mx_cvg_incr_wcf_alwd_amt := null;
2546: --
2547: end if;
2548: --
2549: hr_utility.set_location (' open c_current_enrt ',10);
2550: open c_current_enrt(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date))); -- FONM;
2551: fetch c_current_enrt into l_crnt_ordr_num,
2552: l_bnft_amt,
2553: l_current_enrt_present;

Line 2583: hr_utility.set_location ('formula default='||ben_enrolment_requirements.g_dflt_elcn_val,744);

2579: --- then use the value for l_dflt_elcn_val
2580: if l_dflt_enrt_cd = 'RL' and ben_enrolment_requirements.g_dflt_elcn_val is not null then
2581: l_dflt_elcn_val:=ben_enrolment_requirements.g_dflt_elcn_val;
2582: --- once the value used nullify the value
2583: hr_utility.set_location ('formula default='||ben_enrolment_requirements.g_dflt_elcn_val,744);
2584: ben_enrolment_requirements.g_dflt_elcn_val := null ;
2585: end if ;
2586: --
2587: -- if this choice is a default and dflt_enrt_cd says

Line 2594: hr_utility.set_location ('dflt_val='||l_bnft_amt,10);

2590: --
2591: if (l_dflt_enrt_cd in ('NSDCS','NNCS') and
2592: l_epe.dflt_flag='Y' and
2593: l_bnft_amt is not null) then
2594: hr_utility.set_location ('dflt_val='||l_bnft_amt,10);
2595: l_dflt_elcn_val:= l_bnft_amt;
2596: end if;
2597: --
2598: l_cvg_amount := l_bnft_amt;

Line 2599: hr_utility.set_location (' Dn EPE ELSIFs ',10);

2595: l_dflt_elcn_val:= l_bnft_amt;
2596: end if;
2597: --
2598: l_cvg_amount := l_bnft_amt;
2599: hr_utility.set_location (' Dn EPE ELSIFs ',10);
2600: if l_cvg(0).cvg_mlt_cd = 'FLFX' then
2601: --
2602: l_ctfn_rqd := 'N';
2603: l_write_rec := true;

Line 2615: hr_utility.set_location ('limit_checks ' ,10);

2611: );
2612: l_cvg_amount := l_val ;
2613: --
2614: ---bug validate the limit for benefir amount
2615: hr_utility.set_location ('limit_checks ' ,10);
2616: benutils.limit_checks
2617: (p_lwr_lmt_val => l_cvg(0).lwr_lmt_val,
2618: p_lwr_lmt_calc_rl => l_cvg(0).lwr_lmt_calc_rl,
2619: p_upr_lmt_val => l_cvg(0).upr_lmt_val,

Line 2634: hr_utility.set_location (' CMC FLFX ',10);

2630: p_ler_id => l_epe.ler_id,
2631: p_val => l_val,
2632: p_state => l_state.region_2);
2633:
2634: hr_utility.set_location (' CMC FLFX ',10);
2635: --
2636: ben_determine_coverage.combine_with_variable_val
2637: (p_vr_val => l_vr_val,
2638: p_val => l_val,

Line 2644: hr_utility.set_location ('l_dflt_enrt_cd'||l_dflt_enrt_cd,353235);

2640: p_combined_val => l_combined_val);
2641: --
2642: --rtagarra
2643: --
2644: hr_utility.set_location ('l_dflt_enrt_cd'||l_dflt_enrt_cd,353235);
2645: hr_utility.set_location ('FLAG' || l_cvg(0).entr_val_at_enrt_flag,23542345);
2646: hr_utility.set_location ('l_bnft_amt ' ||l_bnft_amt,34534);
2647: hr_utility.set_location ('l_combined_val ' || l_combined_val,345345);
2648: --

Line 2645: hr_utility.set_location ('FLAG' || l_cvg(0).entr_val_at_enrt_flag,23542345);

2641: --
2642: --rtagarra
2643: --
2644: hr_utility.set_location ('l_dflt_enrt_cd'||l_dflt_enrt_cd,353235);
2645: hr_utility.set_location ('FLAG' || l_cvg(0).entr_val_at_enrt_flag,23542345);
2646: hr_utility.set_location ('l_bnft_amt ' ||l_bnft_amt,34534);
2647: hr_utility.set_location ('l_combined_val ' || l_combined_val,345345);
2648: --
2649: if l_dflt_enrt_cd in ('NSDCS','NNCS','NDCSEDR','NNCSEDR') and l_cvg(0).entr_val_at_enrt_flag = 'Y' then

Line 2646: hr_utility.set_location ('l_bnft_amt ' ||l_bnft_amt,34534);

2642: --rtagarra
2643: --
2644: hr_utility.set_location ('l_dflt_enrt_cd'||l_dflt_enrt_cd,353235);
2645: hr_utility.set_location ('FLAG' || l_cvg(0).entr_val_at_enrt_flag,23542345);
2646: hr_utility.set_location ('l_bnft_amt ' ||l_bnft_amt,34534);
2647: hr_utility.set_location ('l_combined_val ' || l_combined_val,345345);
2648: --
2649: if l_dflt_enrt_cd in ('NSDCS','NNCS','NDCSEDR','NNCSEDR') and l_cvg(0).entr_val_at_enrt_flag = 'Y' then
2650: --

Line 2647: hr_utility.set_location ('l_combined_val ' || l_combined_val,345345);

2643: --
2644: hr_utility.set_location ('l_dflt_enrt_cd'||l_dflt_enrt_cd,353235);
2645: hr_utility.set_location ('FLAG' || l_cvg(0).entr_val_at_enrt_flag,23542345);
2646: hr_utility.set_location ('l_bnft_amt ' ||l_bnft_amt,34534);
2647: hr_utility.set_location ('l_combined_val ' || l_combined_val,345345);
2648: --
2649: if l_dflt_enrt_cd in ('NSDCS','NNCS','NDCSEDR','NNCSEDR') and l_cvg(0).entr_val_at_enrt_flag = 'Y' then
2650: --
2651: hr_utility.set_location ('INSIDE 1 IF',53453245);

Line 2651: hr_utility.set_location ('INSIDE 1 IF',53453245);

2647: hr_utility.set_location ('l_combined_val ' || l_combined_val,345345);
2648: --
2649: if l_dflt_enrt_cd in ('NSDCS','NNCS','NDCSEDR','NNCSEDR') and l_cvg(0).entr_val_at_enrt_flag = 'Y' then
2650: --
2651: hr_utility.set_location ('INSIDE 1 IF',53453245);
2652: --
2653: if l_bnft_amt is not null then
2654: --
2655: hr_utility.set_location ('INSIDE 2 IF',53453245);

Line 2655: hr_utility.set_location ('INSIDE 2 IF',53453245);

2651: hr_utility.set_location ('INSIDE 1 IF',53453245);
2652: --
2653: if l_bnft_amt is not null then
2654: --
2655: hr_utility.set_location ('INSIDE 2 IF',53453245);
2656: if l_bnft_amt between l_cvg(0).mn_val and l_cvg(0).mx_val then
2657: --
2658: hr_utility.set_location ('INSIDE 3 IF',53453245);
2659: l_combined_val := l_bnft_amt ;

Line 2658: hr_utility.set_location ('INSIDE 3 IF',53453245);

2654: --
2655: hr_utility.set_location ('INSIDE 2 IF',53453245);
2656: if l_bnft_amt between l_cvg(0).mn_val and l_cvg(0).mx_val then
2657: --
2658: hr_utility.set_location ('INSIDE 3 IF',53453245);
2659: l_combined_val := l_bnft_amt ;
2660: --
2661: end if;
2662: --

Line 2713: hr_utility.set_location(' l_rstrn.mx_cvg_alwd_amt '||l_rstrn.mx_cvg_alwd_amt,189);

2709: end if;
2710: --
2711: --BUG 4627840 -- We are ignoring the rule here.
2712: --
2713: hr_utility.set_location(' l_rstrn.mx_cvg_alwd_amt '||l_rstrn.mx_cvg_alwd_amt,189);
2714: hr_utility.set_location(' l_mx_cvg_wout_ctfn_val '||l_mx_cvg_wout_ctfn_val,189);
2715: hr_utility.set_location(' l_rstrn.mx_cvg_wcfn_amt '||l_rstrn.mx_cvg_wcfn_amt,189);
2716: --
2717: l_cvg_rstn_max_wout_cert := nvl(l_rstrn.mx_cvg_alwd_amt,l_mx_cvg_wout_ctfn_val);

Line 2714: hr_utility.set_location(' l_mx_cvg_wout_ctfn_val '||l_mx_cvg_wout_ctfn_val,189);

2710: --
2711: --BUG 4627840 -- We are ignoring the rule here.
2712: --
2713: hr_utility.set_location(' l_rstrn.mx_cvg_alwd_amt '||l_rstrn.mx_cvg_alwd_amt,189);
2714: hr_utility.set_location(' l_mx_cvg_wout_ctfn_val '||l_mx_cvg_wout_ctfn_val,189);
2715: hr_utility.set_location(' l_rstrn.mx_cvg_wcfn_amt '||l_rstrn.mx_cvg_wcfn_amt,189);
2716: --
2717: l_cvg_rstn_max_wout_cert := nvl(l_rstrn.mx_cvg_alwd_amt,l_mx_cvg_wout_ctfn_val);
2718: l_cvg_rstn_max_with_cert := l_rstrn.mx_cvg_wcfn_amt;

Line 2715: hr_utility.set_location(' l_rstrn.mx_cvg_wcfn_amt '||l_rstrn.mx_cvg_wcfn_amt,189);

2711: --BUG 4627840 -- We are ignoring the rule here.
2712: --
2713: hr_utility.set_location(' l_rstrn.mx_cvg_alwd_amt '||l_rstrn.mx_cvg_alwd_amt,189);
2714: hr_utility.set_location(' l_mx_cvg_wout_ctfn_val '||l_mx_cvg_wout_ctfn_val,189);
2715: hr_utility.set_location(' l_rstrn.mx_cvg_wcfn_amt '||l_rstrn.mx_cvg_wcfn_amt,189);
2716: --
2717: l_cvg_rstn_max_wout_cert := nvl(l_rstrn.mx_cvg_alwd_amt,l_mx_cvg_wout_ctfn_val);
2718: l_cvg_rstn_max_with_cert := l_rstrn.mx_cvg_wcfn_amt;
2719: --

Line 2729: hr_utility.set_location('l_bnft_amt '||l_bnft_amt,188);

2725: --Bug 5236985 Added the l_cvg_rstn_max_with_cert not null condition
2726: --This necessary if the l_rstrn.mx_cvg_wcfn_amt is made null in the subsequent life events
2727: if l_cvg(0).entr_val_at_enrt_flag = 'Y' and l_bnft_amt > l_cvg_rstn_max_wout_cert and l_cvg_rstn_max_with_cert is not null then
2728: l_cvg_rstn_max_wout_cert := l_bnft_amt ;
2729: hr_utility.set_location('l_bnft_amt '||l_bnft_amt,188);
2730: hr_utility.set_location('l_cvg_rstn_max_wout_cert '||l_cvg_rstn_max_wout_cert,188);
2731: end if;
2732: --
2733: if l_rstrn.mx_cvg_incr_alwd_amt is not null then

Line 2730: hr_utility.set_location('l_cvg_rstn_max_wout_cert '||l_cvg_rstn_max_wout_cert,188);

2726: --This necessary if the l_rstrn.mx_cvg_wcfn_amt is made null in the subsequent life events
2727: if l_cvg(0).entr_val_at_enrt_flag = 'Y' and l_bnft_amt > l_cvg_rstn_max_wout_cert and l_cvg_rstn_max_with_cert is not null then
2728: l_cvg_rstn_max_wout_cert := l_bnft_amt ;
2729: hr_utility.set_location('l_bnft_amt '||l_bnft_amt,188);
2730: hr_utility.set_location('l_cvg_rstn_max_wout_cert '||l_cvg_rstn_max_wout_cert,188);
2731: end if;
2732: --
2733: if l_rstrn.mx_cvg_incr_alwd_amt is not null then
2734: l_cvg_rstn_max_wout_cert := l_bnft_amt + l_rstrn.mx_cvg_incr_alwd_amt;

Line 2743: hr_utility.set_location('crtfn ' || l_rstrn.mx_cvg_wcfn_amt,199);

2739: l_cvg_rstn_max_incr_with_cert := l_bnft_amt + l_rstrn.mx_cvg_incr_wcf_alwd_amt ; /* Bug 3828288 */
2740: end if;
2741: end if;
2742: end if;
2743: hr_utility.set_location('crtfn ' || l_rstrn.mx_cvg_wcfn_amt,199);
2744: hr_utility.set_location('min val ' || l_mn_elcn_val,199);
2745: hr_utility.set_location('max val ' || l_mx_elcn_val,199);
2746: --
2747: if l_write_rec then

Line 2744: hr_utility.set_location('min val ' || l_mn_elcn_val,199);

2740: end if;
2741: end if;
2742: end if;
2743: hr_utility.set_location('crtfn ' || l_rstrn.mx_cvg_wcfn_amt,199);
2744: hr_utility.set_location('min val ' || l_mn_elcn_val,199);
2745: hr_utility.set_location('max val ' || l_mx_elcn_val,199);
2746: --
2747: if l_write_rec then
2748: --

Line 2745: hr_utility.set_location('max val ' || l_mx_elcn_val,199);

2741: end if;
2742: end if;
2743: hr_utility.set_location('crtfn ' || l_rstrn.mx_cvg_wcfn_amt,199);
2744: hr_utility.set_location('min val ' || l_mn_elcn_val,199);
2745: hr_utility.set_location('max val ' || l_mx_elcn_val,199);
2746: --
2747: if l_write_rec then
2748: --
2749: -- Bug 3828288

Line 2798: hr_utility.set_location('l_ultmt_lwr_lmt_calc_rl = ' || l_ultmt_lwr_lmt_calc_rl, 9999);

2794: p_cvg_rstn_max_wout_cert => l_cvg_rstn_max_wout_cert,
2795: p_mx_val_wcfn => l_mx_val_wcfn,
2796: p_mx_val_wo_cfn => l_mx_val_wo_cfn
2797: );
2798: hr_utility.set_location('l_ultmt_lwr_lmt_calc_rl = ' || l_ultmt_lwr_lmt_calc_rl, 9999);
2799: if l_ultmt_lwr_lmt_calc_rl is not null then
2800: --
2801: l_ult_lwr_outputs := benutils.formula
2802: (p_formula_id => l_ultmt_lwr_lmt_calc_rl,

Line 2836: hr_utility.set_location('l_mn_elcn_val = ' || l_mn_elcn_val, 9999);

2832: -- if (l_rstrn_mn_cvg_rqd_amt > l_mn_elcn_val) then
2833: -- l_mn_elcn_val := l_rstrn_mn_cvg_rqd_amt;
2834: -- end if;
2835: --End Bug 4644489
2836: hr_utility.set_location('l_mn_elcn_val = ' || l_mn_elcn_val, 9999);
2837: hr_utility.set_location('l_ultmt_lwr_lmt = ' || l_ultmt_lwr_lmt, 9999);
2838: hr_utility.set_location('l_rstrn_mn_cvg_rqd_amt = ' || l_rstrn_mn_cvg_rqd_amt, 9999);
2839: hr_utility.set_location('l_mx_val_wcfn = ' || l_mx_val_wcfn, 9999);
2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);

Line 2837: hr_utility.set_location('l_ultmt_lwr_lmt = ' || l_ultmt_lwr_lmt, 9999);

2833: -- l_mn_elcn_val := l_rstrn_mn_cvg_rqd_amt;
2834: -- end if;
2835: --End Bug 4644489
2836: hr_utility.set_location('l_mn_elcn_val = ' || l_mn_elcn_val, 9999);
2837: hr_utility.set_location('l_ultmt_lwr_lmt = ' || l_ultmt_lwr_lmt, 9999);
2838: hr_utility.set_location('l_rstrn_mn_cvg_rqd_amt = ' || l_rstrn_mn_cvg_rqd_amt, 9999);
2839: hr_utility.set_location('l_mx_val_wcfn = ' || l_mx_val_wcfn, 9999);
2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);
2841: -- Bug 3828288

Line 2838: hr_utility.set_location('l_rstrn_mn_cvg_rqd_amt = ' || l_rstrn_mn_cvg_rqd_amt, 9999);

2834: -- end if;
2835: --End Bug 4644489
2836: hr_utility.set_location('l_mn_elcn_val = ' || l_mn_elcn_val, 9999);
2837: hr_utility.set_location('l_ultmt_lwr_lmt = ' || l_ultmt_lwr_lmt, 9999);
2838: hr_utility.set_location('l_rstrn_mn_cvg_rqd_amt = ' || l_rstrn_mn_cvg_rqd_amt, 9999);
2839: hr_utility.set_location('l_mx_val_wcfn = ' || l_mx_val_wcfn, 9999);
2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);
2841: -- Bug 3828288
2842: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);

Line 2839: hr_utility.set_location('l_mx_val_wcfn = ' || l_mx_val_wcfn, 9999);

2835: --End Bug 4644489
2836: hr_utility.set_location('l_mn_elcn_val = ' || l_mn_elcn_val, 9999);
2837: hr_utility.set_location('l_ultmt_lwr_lmt = ' || l_ultmt_lwr_lmt, 9999);
2838: hr_utility.set_location('l_rstrn_mn_cvg_rqd_amt = ' || l_rstrn_mn_cvg_rqd_amt, 9999);
2839: hr_utility.set_location('l_mx_val_wcfn = ' || l_mx_val_wcfn, 9999);
2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);
2841: -- Bug 3828288
2842: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);
2843: hr_utility.set_location('l_cvg_amount = ' || l_cvg_amount, 9999);

Line 2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);

2836: hr_utility.set_location('l_mn_elcn_val = ' || l_mn_elcn_val, 9999);
2837: hr_utility.set_location('l_ultmt_lwr_lmt = ' || l_ultmt_lwr_lmt, 9999);
2838: hr_utility.set_location('l_rstrn_mn_cvg_rqd_amt = ' || l_rstrn_mn_cvg_rqd_amt, 9999);
2839: hr_utility.set_location('l_mx_val_wcfn = ' || l_mx_val_wcfn, 9999);
2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);
2841: -- Bug 3828288
2842: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);
2843: hr_utility.set_location('l_cvg_amount = ' || l_cvg_amount, 9999);
2844: hr_utility.set_location('l_dflt_elcn_val = ' || l_dflt_elcn_val, 9999);

Line 2842: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);

2838: hr_utility.set_location('l_rstrn_mn_cvg_rqd_amt = ' || l_rstrn_mn_cvg_rqd_amt, 9999);
2839: hr_utility.set_location('l_mx_val_wcfn = ' || l_mx_val_wcfn, 9999);
2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);
2841: -- Bug 3828288
2842: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);
2843: hr_utility.set_location('l_cvg_amount = ' || l_cvg_amount, 9999);
2844: hr_utility.set_location('l_dflt_elcn_val = ' || l_dflt_elcn_val, 9999);
2845: --
2846: ben_determine_coverage.write_coverage

Line 2843: hr_utility.set_location('l_cvg_amount = ' || l_cvg_amount, 9999);

2839: hr_utility.set_location('l_mx_val_wcfn = ' || l_mx_val_wcfn, 9999);
2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);
2841: -- Bug 3828288
2842: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);
2843: hr_utility.set_location('l_cvg_amount = ' || l_cvg_amount, 9999);
2844: hr_utility.set_location('l_dflt_elcn_val = ' || l_dflt_elcn_val, 9999);
2845: --
2846: ben_determine_coverage.write_coverage
2847: (p_calculate_only_mode => p_calculate_only_mode,

Line 2844: hr_utility.set_location('l_dflt_elcn_val = ' || l_dflt_elcn_val, 9999);

2840: hr_utility.set_location('l_mx_val_wo_cfn = ' || l_mx_val_wo_cfn, 9999);
2841: -- Bug 3828288
2842: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);
2843: hr_utility.set_location('l_cvg_amount = ' || l_cvg_amount, 9999);
2844: hr_utility.set_location('l_dflt_elcn_val = ' || l_dflt_elcn_val, 9999);
2845: --
2846: ben_determine_coverage.write_coverage
2847: (p_calculate_only_mode => p_calculate_only_mode,
2848: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,

Line 2905: hr_utility.set_location('benefit row'||l_cvg(0).bnft_or_option_rstrctn_cd,111);

2901: --
2902: end if;
2903:
2904:
2905: hr_utility.set_location('benefit row'||l_cvg(0).bnft_or_option_rstrctn_cd,111);
2906: hr_utility.set_location('oipl id '||l_epe.oipl_id,111);
2907:
2908: if l_rstrn_found and l_cvg(0).bnft_or_option_rstrctn_cd = 'BNFT' and
2909: l_cvg(0).entr_val_at_enrt_flag = 'Y' then

Line 2906: hr_utility.set_location('oipl id '||l_epe.oipl_id,111);

2902: end if;
2903:
2904:
2905: hr_utility.set_location('benefit row'||l_cvg(0).bnft_or_option_rstrctn_cd,111);
2906: hr_utility.set_location('oipl id '||l_epe.oipl_id,111);
2907:
2908: if l_rstrn_found and l_cvg(0).bnft_or_option_rstrctn_cd = 'BNFT' and
2909: l_cvg(0).entr_val_at_enrt_flag = 'Y' then
2910: -- if l_epe.oipl_id is null then /*ENH*/

Line 2953: hr_utility.set_location (' open c_current_enrt ',10);

2949: close c_current_enrt_in_oipl;
2950: end if;
2951: end if;
2952: ---------------
2953: hr_utility.set_location (' open c_current_enrt ',10);
2954: --open c_current_enrt_in_pln(l_epe.pl_id) ;
2955: -- fetch c_current_enrt_in_pln into l_current_plan_id,l_current_oipl_id ;
2956: --
2957: -- if c_current_enrt_in_pln%found then

Line 2977: hr_utility.set_location('interim row',111);

2973: l_interim_bnft_val := null ; -- l_dflt_elcn_val ;
2974: end if ;
2975: --close c_current_enrt_in_pln;
2976: --
2977: hr_utility.set_location('interim row',111);
2978: --CF Changes
2979: --
2980: if l_current_plan_id = l_epe.pl_id and
2981: nvl(l_current_oipl_id,-1) = nvl(l_epe.oipl_id,-1) then

Line 3111: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);

3107: );
3108: --
3109: end if;
3110: l_epe.elctbl_flag:='N';
3111: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
3112: end if;
3113: ben_determine_coverage.write_coverage
3114: (p_calculate_only_mode => p_calculate_only_mode,
3115: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,

Line 3166: hr_utility.set_location (' CMC CL ',10);

3162: --
3163: l_ctfn_rqd := 'N';
3164: l_write_rec := true;
3165: --
3166: hr_utility.set_location (' CMC CL ',10);
3167: benutils.rt_typ_calc
3168: (p_val => l_cvg(0).val,
3169: p_val_2 => l_compensation_value,
3170: p_rt_typ_cd => l_cvg(0).rt_typ_cd,

Line 3183: hr_utility.set_location ('limit_checks ',10);

3179: );
3180: --
3181: l_cvg_amount := l_val ;
3182: ---bug validate the limit for benefir amount
3183: hr_utility.set_location ('limit_checks ',10);
3184: benutils.limit_checks
3185: (p_lwr_lmt_val => l_cvg(0).lwr_lmt_val,
3186: p_lwr_lmt_calc_rl => l_cvg(0).lwr_lmt_calc_rl,
3187: p_upr_lmt_val => l_cvg(0).upr_lmt_val,

Line 3203: hr_utility.set_location (' rndg is'||l_val,10);

3199: p_val => l_val,
3200: p_state => l_state.region_2);
3201:
3202: ---
3203: hr_utility.set_location (' rndg is'||l_val,10);
3204: ben_determine_coverage.combine_with_variable_val
3205: (p_vr_val => l_vr_val,
3206: p_val => l_val,
3207: p_vr_trtmt_cd => l_vr_trtmt_cd,

Line 3210: hr_utility.set_location (' varb is'||l_combined_val,10);

3206: p_val => l_val,
3207: p_vr_trtmt_cd => l_vr_trtmt_cd,
3208: p_combined_val => l_combined_val);
3209: --
3210: hr_utility.set_location (' varb is'||l_combined_val,10);
3211: --
3212: if l_rstrn_found then
3213: --
3214: ben_determine_coverage.chk_bnft_ctfn

Line 3347: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);

3343: --
3344: end if;
3345: --
3346: l_epe.elctbl_flag:='N';
3347: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
3348: end if;
3349: ben_determine_coverage.write_coverage
3350: (p_calculate_only_mode => p_calculate_only_mode,
3351: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,

Line 3399: hr_utility.set_location (' CMC FLRNG ',10);

3395: end if;
3396: --
3397: elsif l_cvg(0).cvg_mlt_cd = 'FLRNG' then
3398: --
3399: hr_utility.set_location (' CMC FLRNG ',10);
3400: --
3401: hr_utility.set_location ('l_cvg-0.mx_val '||l_cvg(0).mx_val,33);
3402: hr_utility.set_location ('l_cvg-0.mn_val '||l_cvg(0).mn_val,33);
3403: --

Line 3401: hr_utility.set_location ('l_cvg-0.mx_val '||l_cvg(0).mx_val,33);

3397: elsif l_cvg(0).cvg_mlt_cd = 'FLRNG' then
3398: --
3399: hr_utility.set_location (' CMC FLRNG ',10);
3400: --
3401: hr_utility.set_location ('l_cvg-0.mx_val '||l_cvg(0).mx_val,33);
3402: hr_utility.set_location ('l_cvg-0.mn_val '||l_cvg(0).mn_val,33);
3403: --
3404: if l_cvg(0).lwr_lmt_calc_rl is not NULL then
3405: --

Line 3402: hr_utility.set_location ('l_cvg-0.mn_val '||l_cvg(0).mn_val,33);

3398: --
3399: hr_utility.set_location (' CMC FLRNG ',10);
3400: --
3401: hr_utility.set_location ('l_cvg-0.mx_val '||l_cvg(0).mx_val,33);
3402: hr_utility.set_location ('l_cvg-0.mn_val '||l_cvg(0).mn_val,33);
3403: --
3404: if l_cvg(0).lwr_lmt_calc_rl is not NULL then
3405: --
3406: l_lwr_outputs := benutils.formula

Line 3456: hr_utility.set_location ('l_lwr_val :'||l_lwr_val,32);

3452: end if;
3453:
3454: i := nvl(l_lwr_val,l_cvg(0).mn_val);
3455:
3456: hr_utility.set_location ('l_lwr_val :'||l_lwr_val,32);
3457: hr_utility.set_location ('l_upr_val :'||l_upr_val,32);
3458:
3459: while i <= nvl(l_upr_val,l_cvg(0).mx_val) loop
3460: --

Line 3457: hr_utility.set_location ('l_upr_val :'||l_upr_val,32);

3453:
3454: i := nvl(l_lwr_val,l_cvg(0).mn_val);
3455:
3456: hr_utility.set_location ('l_lwr_val :'||l_lwr_val,32);
3457: hr_utility.set_location ('l_upr_val :'||l_upr_val,32);
3458:
3459: while i <= nvl(l_upr_val,l_cvg(0).mx_val) loop
3460: --
3461: hr_utility.set_location ('i = '||i,33);

Line 3461: hr_utility.set_location ('i = '||i,33);

3457: hr_utility.set_location ('l_upr_val :'||l_upr_val,32);
3458:
3459: while i <= nvl(l_upr_val,l_cvg(0).mx_val) loop
3460: --
3461: hr_utility.set_location ('i = '||i,33);
3462: --
3463: l_ctfn_rqd := 'N';
3464: l_write_rec := true;
3465: --

Line 3491: hr_utility.set_location ('limit_checks ',10);

3487: p_rndg_rl => l_cvg(0).rndg_rl
3488: );
3489: l_cvg_amount := l_val ;
3490: --validate the limit for benefir amount
3491: hr_utility.set_location ('limit_checks ',10);
3492: benutils.limit_checks
3493: (p_lwr_lmt_val => l_cvg(0).lwr_lmt_val,
3494: p_lwr_lmt_calc_rl => l_cvg(0).lwr_lmt_calc_rl,
3495: p_upr_lmt_val => l_cvg(0).upr_lmt_val,

Line 3603: hr_utility.set_location('Writing coverage ',35);

3599: end if;
3600: --
3601: if l_write_rec then
3602: --
3603: hr_utility.set_location('Writing coverage ',35);
3604: --
3605: ben_determine_coverage.write_coverage
3606: (p_calculate_only_mode => p_calculate_only_mode,
3607: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,

Line 3680: hr_utility.set_location (' CMC CLRNG ',10);

3676: end loop;
3677: --
3678: elsif l_cvg(0).cvg_mlt_cd = 'CLRNG' then
3679: --
3680: hr_utility.set_location (' CMC CLRNG ',10);
3681: i := l_cvg(0).mn_val;
3682: --
3683: while i <= l_cvg(0).mx_val loop
3684: --

Line 3713: hr_utility.set_location ('limit_checks ',10);

3709: p_rndg_rl => l_cvg(0).rndg_rl
3710: );
3711: l_cvg_amount := l_val ;
3712: --validate the limit for benefir amount
3713: hr_utility.set_location ('limit_checks ',10);
3714: benutils.limit_checks
3715: (p_lwr_lmt_val => l_cvg(0).lwr_lmt_val,
3716: p_lwr_lmt_calc_rl => l_cvg(0).lwr_lmt_calc_rl,
3717: p_upr_lmt_val => l_cvg(0).upr_lmt_val,

Line 3885: hr_utility.set_location (' CMC FLFXPCL ',10);

3881: --
3882: end loop;
3883: --
3884: elsif l_cvg(0).cvg_mlt_cd = 'FLFXPCL' then
3885: hr_utility.set_location (' CMC FLFXPCL ',10);
3886: --
3887: l_ctfn_rqd := 'N';
3888: l_write_rec := true;
3889: --

Line 3896: hr_utility.set_location (' l_calculated_val ' || l_calculated_val,10);

3892: p_val_2 => l_compensation_value,
3893: p_rt_typ_cd => l_cvg(0).rt_typ_cd,
3894: p_calculated_val => l_calculated_val);
3895: --
3896: hr_utility.set_location (' l_calculated_val ' || l_calculated_val,10);
3897: hr_utility.set_location (' l_cvg(0).val '|| l_cvg(0).val,10);
3898: --
3899: l_calculated_val := l_calculated_val + l_cvg(0).val;
3900: --

Line 3897: hr_utility.set_location (' l_cvg(0).val '|| l_cvg(0).val,10);

3893: p_rt_typ_cd => l_cvg(0).rt_typ_cd,
3894: p_calculated_val => l_calculated_val);
3895: --
3896: hr_utility.set_location (' l_calculated_val ' || l_calculated_val,10);
3897: hr_utility.set_location (' l_cvg(0).val '|| l_cvg(0).val,10);
3898: --
3899: l_calculated_val := l_calculated_val + l_cvg(0).val;
3900: --
3901: l_val := round_val(

Line 3910: hr_utility.set_location ('limit_checks ',10);

3906: p_rndg_rl => l_cvg(0).rndg_rl
3907: );
3908: l_cvg_amount := l_val ;
3909: --validate the limit for benefir amount
3910: hr_utility.set_location ('limit_checks ',10);
3911:
3912: l_tot_val := l_val ;
3913: --
3914: hr_utility.set_location (' l_tot_val ' || l_tot_val,10);

Line 3914: hr_utility.set_location (' l_tot_val ' || l_tot_val,10);

3910: hr_utility.set_location ('limit_checks ',10);
3911:
3912: l_tot_val := l_val ;
3913: --
3914: hr_utility.set_location (' l_tot_val ' || l_tot_val,10);
3915: --
3916: benutils.limit_checks
3917: (p_lwr_lmt_val => l_cvg(0).lwr_lmt_val,
3918: p_lwr_lmt_calc_rl => l_cvg(0).lwr_lmt_calc_rl,

Line 4073: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);

4069: );
4070: --
4071: end if;
4072: l_epe.elctbl_flag:='N';
4073: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
4074: end if;
4075: ben_determine_coverage.write_coverage
4076: (p_calculate_only_mode => p_calculate_only_mode,
4077: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,

Line 4124: hr_utility.set_location (' CMC FLPCLRNG ',10);

4120: --
4121: end if;
4122: --
4123: elsif l_cvg(0).cvg_mlt_cd = 'FLPCLRNG' then
4124: hr_utility.set_location (' CMC FLPCLRNG ',10);
4125: --
4126: i := l_cvg(0).mn_val;
4127: --
4128: while i <= l_cvg(0).mx_val loop

Line 4162: hr_utility.set_location ('limit_checks ',10);

4158:
4159: l_tot_val := l_val+l_cvg(0).val; -- 3095224
4160:
4161:
4162: hr_utility.set_location ('limit_checks ',10);
4163: benutils.limit_checks
4164: (p_lwr_lmt_val => l_cvg(0).lwr_lmt_val,
4165: p_lwr_lmt_calc_rl => l_cvg(0).lwr_lmt_calc_rl,
4166: p_upr_lmt_val => l_cvg(0).upr_lmt_val,

Line 4337: hr_utility.set_location (' CMC CLPFLRNG ',10);

4333: --
4334: end loop;
4335: --
4336: elsif l_cvg(0).cvg_mlt_cd = 'CLPFLRNG' then
4337: hr_utility.set_location (' CMC CLPFLRNG ',10);
4338: --
4339: benutils.rt_typ_calc
4340: (p_val => l_cvg(0).val,
4341: p_val_2 => l_compensation_value,

Line 4357: hr_utility.set_location ('limit_checks ',10);

4353: l_cvg_amount := l_val ;
4354:
4355: /* moved the limit check to inside the loop to enforce the limit on compensation + range
4356: --validate the limit for benefir amount
4357: hr_utility.set_location ('limit_checks ',10);
4358: benutils.limit_checks
4359: (p_lwr_lmt_val => l_cvg(0).lwr_lmt_val,
4360: p_lwr_lmt_calc_rl => l_cvg(0).lwr_lmt_calc_rl,
4361: p_upr_lmt_val => l_cvg(0).upr_lmt_val,

Line 4557: hr_utility.set_location (' CMC SAAEAR ',10);

4553:
4554: end loop;
4555:
4556: elsif l_cvg(0).cvg_mlt_cd = 'SAAEAR' then
4557: hr_utility.set_location (' CMC SAAEAR ',10);
4558: l_ctfn_rqd := 'N';
4559: l_write_rec := true;
4560:
4561: ben_determine_coverage.write_coverage

Line 4609: hr_utility.set_location (' CMC NSVU ',10);

4605: );
4606: --
4607: elsif l_cvg(0).cvg_mlt_cd = 'NSVU' then
4608: --
4609: hr_utility.set_location (' CMC NSVU ',10);
4610: --
4611: l_ctfn_rqd := 'N';
4612: l_write_rec := true;
4613: --

Line 4764: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);

4760: --
4761: end if;
4762: --
4763: l_epe.elctbl_flag:='N';
4764: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
4765: end if;
4766: ben_determine_coverage.write_coverage
4767: (p_calculate_only_mode => p_calculate_only_mode,
4768: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,

Line 4811: hr_utility.set_location (' CMC RL ',10);

4807: --
4808: --End Bug 5933576
4809: --
4810: elsif l_cvg(0).cvg_mlt_cd in ('RL','ERL') then
4811: hr_utility.set_location (' CMC RL ',10);
4812: --
4813: if l_epe.oipl_id is not null and l_opt.opt_id is null
4814: then
4815: open c_opt(l_epe.oipl_id, nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date))); -- FONM

Line 4855: hr_utility.set_location ('limit_checks ',10);

4851: p_rndg_rl => l_cvg(0).rndg_rl
4852: );
4853: l_cvg_amount := l_val ;
4854: --validate the limit for benefir amount
4855: hr_utility.set_location ('limit_checks ',10);
4856: benutils.limit_checks
4857: (p_lwr_lmt_val => l_cvg(0).lwr_lmt_val,
4858: p_lwr_lmt_calc_rl => l_cvg(0).lwr_lmt_calc_rl,
4859: p_upr_lmt_val => l_cvg(0).upr_lmt_val,

Line 5011: hr_utility.set_location (' Current Same Calculations ',10);

5007: -- This following routine need to create an additional benefit row, if
5008: -- tne interim enrollment code is 'Same'
5009: -- this row will be used for assigning the interim coverage
5010: --
5011: hr_utility.set_location (' Current Same Calculations ',10);
5012:
5013: l_interim_cd := substr(l_rstrn.dflt_to_asn_pndg_ctfn_cd,4,2) ;
5014: l_current_level_cd := substr(l_rstrn.dflt_to_asn_pndg_ctfn_cd,2,2);
5015: --

Line 5016: hr_utility.set_location (' l_interim_cd '||l_interim_cd,22);

5012:
5013: l_interim_cd := substr(l_rstrn.dflt_to_asn_pndg_ctfn_cd,4,2) ;
5014: l_current_level_cd := substr(l_rstrn.dflt_to_asn_pndg_ctfn_cd,2,2);
5015: --
5016: hr_utility.set_location (' l_interim_cd '||l_interim_cd,22);
5017: hr_utility.set_location (' l_current_level_cd '||l_current_level_cd,22);
5018: --
5019: l_current_plan_id := null ;
5020: l_current_oipl_id := null ;

Line 5017: hr_utility.set_location (' l_current_level_cd '||l_current_level_cd,22);

5013: l_interim_cd := substr(l_rstrn.dflt_to_asn_pndg_ctfn_cd,4,2) ;
5014: l_current_level_cd := substr(l_rstrn.dflt_to_asn_pndg_ctfn_cd,2,2);
5015: --
5016: hr_utility.set_location (' l_interim_cd '||l_interim_cd,22);
5017: hr_utility.set_location (' l_current_level_cd '||l_current_level_cd,22);
5018: --
5019: l_current_plan_id := null ;
5020: l_current_oipl_id := null ;
5021: --

Line 5030: hr_utility.set_location(' l_create_current_enb := true PLTYP',222);

5026: open c_current_enrt_in_pl_typ(l_epe.pl_typ_id,
5027: nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))) ; -- FONM
5028: fetch c_current_enrt_in_pl_typ into l_current_plan_id,l_current_oipl_id ;
5029: if c_current_enrt_in_pl_typ%found then
5030: hr_utility.set_location(' l_create_current_enb := true PLTYP',222);
5031: l_create_current_enb := true ;
5032: end if;
5033: close c_current_enrt_in_pl_typ;
5034: --

Line 5057: hr_utility.set_location (' l_current_plan_id '||l_current_plan_id,222);

5053: close c_current_enrt_in_oipl;
5054: end if;
5055: end if;
5056: --
5057: hr_utility.set_location (' l_current_plan_id '||l_current_plan_id,222);
5058: hr_utility.set_location (' l_epe.pl_id '||l_epe.pl_id,222);
5059: hr_utility.set_location (' l_current_oipl_id '||l_current_oipl_id,222);
5060: hr_utility.set_location (' l_epe.oipl_id '||l_epe.oipl_id,222);
5061: hr_utility.set_location (' Date '||nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),222);

Line 5058: hr_utility.set_location (' l_epe.pl_id '||l_epe.pl_id,222);

5054: end if;
5055: end if;
5056: --
5057: hr_utility.set_location (' l_current_plan_id '||l_current_plan_id,222);
5058: hr_utility.set_location (' l_epe.pl_id '||l_epe.pl_id,222);
5059: hr_utility.set_location (' l_current_oipl_id '||l_current_oipl_id,222);
5060: hr_utility.set_location (' l_epe.oipl_id '||l_epe.oipl_id,222);
5061: hr_utility.set_location (' Date '||nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),222);
5062: --

Line 5059: hr_utility.set_location (' l_current_oipl_id '||l_current_oipl_id,222);

5055: end if;
5056: --
5057: hr_utility.set_location (' l_current_plan_id '||l_current_plan_id,222);
5058: hr_utility.set_location (' l_epe.pl_id '||l_epe.pl_id,222);
5059: hr_utility.set_location (' l_current_oipl_id '||l_current_oipl_id,222);
5060: hr_utility.set_location (' l_epe.oipl_id '||l_epe.oipl_id,222);
5061: hr_utility.set_location (' Date '||nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),222);
5062: --
5063: if l_create_current_enb and l_current_plan_id = l_epe.pl_id

Line 5060: hr_utility.set_location (' l_epe.oipl_id '||l_epe.oipl_id,222);

5056: --
5057: hr_utility.set_location (' l_current_plan_id '||l_current_plan_id,222);
5058: hr_utility.set_location (' l_epe.pl_id '||l_epe.pl_id,222);
5059: hr_utility.set_location (' l_current_oipl_id '||l_current_oipl_id,222);
5060: hr_utility.set_location (' l_epe.oipl_id '||l_epe.oipl_id,222);
5061: hr_utility.set_location (' Date '||nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),222);
5062: --
5063: if l_create_current_enb and l_current_plan_id = l_epe.pl_id
5064: and nvl(l_current_oipl_id,-1) = nvl(l_epe.oipl_id,-1) then

Line 5061: hr_utility.set_location (' Date '||nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),222);

5057: hr_utility.set_location (' l_current_plan_id '||l_current_plan_id,222);
5058: hr_utility.set_location (' l_epe.pl_id '||l_epe.pl_id,222);
5059: hr_utility.set_location (' l_current_oipl_id '||l_current_oipl_id,222);
5060: hr_utility.set_location (' l_epe.oipl_id '||l_epe.oipl_id,222);
5061: hr_utility.set_location (' Date '||nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date)),222);
5062: --
5063: if l_create_current_enb and l_current_plan_id = l_epe.pl_id
5064: and nvl(l_current_oipl_id,-1) = nvl(l_epe.oipl_id,-1) then
5065: --

Line 5066: hr_utility.set_location ('l_person_id '||l_person_id,222);

5062: --
5063: if l_create_current_enb and l_current_plan_id = l_epe.pl_id
5064: and nvl(l_current_oipl_id,-1) = nvl(l_epe.oipl_id,-1) then
5065: --
5066: hr_utility.set_location ('l_person_id '||l_person_id,222);
5067: --
5068: open c_current_enb(l_epe.pl_id,l_epe.oipl_id,
5069: nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))) ; -- FONM
5070: fetch c_current_enb into l_current_enb ;

Line 5072: hr_utility.set_location('SAME interim row',111);

5068: open c_current_enb(l_epe.pl_id,l_epe.oipl_id,
5069: nvl(l_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date))) ; -- FONM
5070: fetch c_current_enb into l_current_enb ;
5071: if c_current_enb%found and not p_calculate_only_mode then
5072: hr_utility.set_location('SAME interim row',111);
5073: ben_enrt_bnft_api.create_enrt_bnft
5074: (p_validate => false,
5075: p_dflt_flag => 'N',
5076: p_val_has_bn_prortd_flag => 'N', -- change when prorating

Line 5109: hr_utility.set_location ('Leaving '||l_package,10);

5105: close c_current_enb ;
5106: end if;
5107: --
5108: end if;
5109: hr_utility.set_location ('Leaving '||l_package,10);
5110: --
5111: end main;
5112: --
5113: end ben_determine_coverage;