DBA Data[Home] [Help]

APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on HR_UTILITY

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

535: -- End Bug 4873847
536: --
537: BEGIN
538: --
539: hr_utility.set_location ('Entering '||l_package,10);
540: --
541: ben_env_object.get(p_rec => l_env);
542: --
543: If (p_person_id is null) then

Line 695: hr_utility.set_location(l_package||' p_abr_id NN ',10);

691: close c_epe;
692: --
693: end if;
694: --
695: hr_utility.set_location(l_package||' p_abr_id NN ',10);
696: if p_acty_base_rt_id is not null then
697: --
698: -- FONM
699: open c_avr(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)))

Line 718: hr_utility.set_location(l_package||' p_aprm_id NN ',10);

714: close c_avr;
715: --
716: end if;
717: --
718: hr_utility.set_location(l_package||' p_aprm_id NN ',10);
719: if p_actl_prem_id is not null then
720: --
721: l_actl_prem_id := p_actl_prem_id;
722: --

Line 737: hr_utility.set_location(l_package||' p_cacm_id NN ',10);

733: close c_apv;
734: --
735: end if;
736: --
737: hr_utility.set_location(l_package||' p_cacm_id NN ',10);
738: if p_cvg_amt_calc_mthd_id is not null then
739: --
740: open c_bvr(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
741: --

Line 756: hr_utility.set_location(l_package||' l_avr_found OR ',10);

752: end if;
753: --
754: -- if one of these are found, then we are dealing with profiles, not rules.
755: --
756: hr_utility.set_location(l_package||' l_avr_found OR ',10);
757: if l_avr_found or l_apv_found or l_bvr_found then
758: --
759: hr_utility.set_location(l_package||' BERP_MN ',10);
760: ben_evaluate_rate_profiles.main

Line 759: hr_utility.set_location(l_package||' BERP_MN ',10);

755: --
756: hr_utility.set_location(l_package||' l_avr_found OR ',10);
757: if l_avr_found or l_apv_found or l_bvr_found then
758: --
759: hr_utility.set_location(l_package||' BERP_MN ',10);
760: ben_evaluate_rate_profiles.main
761: (p_currepe_row => p_currepe_row
762: ,p_per_row => p_per_row
763: ,p_asg_row => p_asg_row

Line 783: hr_utility.set_location(l_package||' Dn BERP_MN ',10);

779: ,p_ler_id => l_epe.ler_id
780: ,p_business_group_id => l_epe.business_group_id
781: ,p_vrbl_rt_prfl_id => l_vrbl_rt_prfl_id
782: ); -- this is output
783: hr_utility.set_location(l_package||' Dn BERP_MN ',10);
784: --
785: -- when l_vrbl_rt_prfl_id has no value in it, the person failed the criteria
786: -- and get out! So much for one exit point!
787: --

Line 826: hr_utility.set_location(l_package||' close c_vpf ',10);

822: --
823: end if;
824: --
825: close c_vpf;
826: hr_utility.set_location(l_package||' close c_vpf ',10);
827: --
828: if l_vpf.mlt_cd in ('CVG','CLANDCVG','APANDCVG','PRNTANDCVG') then
829: --
830: -- If the rates are being calculated for dummy imputed

Line 835: hr_utility.set_location(' plan id ' || p_pl_iD , 99);

831: -- income plan then do not raise error even if the
832: -- enrollment benefit row is not created, let the enrt row have
833: -- null val. On enrollment rate is recalculated anyway.
834: --
835: hr_utility.set_location(' plan id ' || p_pl_iD , 99);
836: open c_imp_inc_plan(l_epe.pl_id,
837: nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
838: fetch c_imp_inc_plan into l_imp_inc_plan;
839: close c_imp_inc_plan;

Line 841: hr_utility.set_location(' imp_inc_plan ' || l_imp_inc_plan , 99);

837: nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
838: fetch c_imp_inc_plan into l_imp_inc_plan;
839: close c_imp_inc_plan;
840: --
841: hr_utility.set_location(' imp_inc_plan ' || l_imp_inc_plan , 99);
842: if l_imp_inc_plan = 'N' then
843: --
844: if l_coverage_value is null then
845: --

Line 897: hr_utility.set_location(l_package||' l_vpf.mlt_cd 1 ',10);

893: end if;
894: --
895: end if;
896: --
897: hr_utility.set_location(l_package||' l_vpf.mlt_cd 1 ',10);
898: if l_vpf.mlt_cd in ('CL','CLANDCVG','FLFXPCL') then
899: --
900: if l_vpf.comp_lvl_fctr_id is null then
901: --

Line 942: hr_utility.set_location(' checking if program or plan ',70);

938: end if;
939: --
940: end if;
941: --
942: hr_utility.set_location(' checking if program or plan ',70);
943: --
944: if l_epe.pgm_id is not null then
945: open c_pgm(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
946: fetch c_pgm into l_pgm;

Line 957: hr_utility.set_location(' testing if plan ',80);

953: end if;
954: close c_pgm;
955: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
956: else
957: hr_utility.set_location(' testing if plan ',80);
958: open c_pln(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
959: fetch c_pln into l_pln;
960: if c_pln%notfound then
961: close c_pln;

Line 971: hr_utility.set_location(l_package||' l_vpf.mlt_cd 2 ',10);

967: close c_pln;
968: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;
969: end if;
970: --
971: hr_utility.set_location(l_package||' l_vpf.mlt_cd 2 ',10);
972: --
973: if l_vpf.mlt_cd in ('AP','APANDCVG') then
974: --
975: open c_enrt_prem;

Line 1004: hr_utility.set_location('premium re calculation over ',555666);

1000: p_ler_id => p_ler_id,
1001: p_bnft_amt => p_bnft_amt,
1002: p_business_group_id => p_business_group_id );
1003:
1004: hr_utility.set_location('premium re calculation over ',555666);
1005: l_actl_prem_value := ben_determine_actual_premium.g_computed_prem_val ;
1006: hr_utility.set_location('re calculation premium'||l_actl_prem_value,555666);
1007: ben_determine_actual_premium.g_computed_prem_val := null ;
1008:

Line 1006: hr_utility.set_location('re calculation premium'||l_actl_prem_value,555666);

1002: p_business_group_id => p_business_group_id );
1003:
1004: hr_utility.set_location('premium re calculation over ',555666);
1005: l_actl_prem_value := ben_determine_actual_premium.g_computed_prem_val ;
1006: hr_utility.set_location('re calculation premium'||l_actl_prem_value,555666);
1007: ben_determine_actual_premium.g_computed_prem_val := null ;
1008:
1009: end;
1010: end if;

Line 1046: hr_utility.set_location (' FNDMS_RE 2 ',150);

1042: else
1043: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1044: fnd_message.set_token('PROC',l_package);
1045: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1046: hr_utility.set_location (' FNDMS_RE 2 ',150);
1047: fnd_message.raise_error;
1048: end if;
1049: --
1050: end if;

Line 1057: hr_utility.set_location(l_package||' rt_typ_calc ELSIFs ',10);

1053: -- We now should have everything to do the calculation
1054: --
1055: -- Flat Amount
1056: --
1057: hr_utility.set_location(l_package||' rt_typ_calc ELSIFs ',10);
1058: if l_vpf.mlt_cd = 'FLFX' then
1059: --
1060: p_val := l_vpf.val;
1061: --

Line 1194: hr_utility.set_location(l_package||' FND 91572 ',10);

1190: --
1191: else
1192: --
1193: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1194: hr_utility.set_location(l_package||' FND 91572 ',10);
1195: fnd_message.set_token('PACKAGE',l_package);
1196: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1197: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1198: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

Line 1411: hr_utility.set_location('l_cwb_mn_elcn_val is '||l_cwb_mn_elcn_val,951);

1407: ,p_val => p_mn_elcn_val
1408: ,p_val_2 => l_compensation_value
1409: ,p_calculated_val => l_cwb_mn_elcn_val);
1410: --
1411: hr_utility.set_location('l_cwb_mn_elcn_val is '||l_cwb_mn_elcn_val,951);
1412: --
1413: benutils.rt_typ_calc
1414: (p_rt_typ_cd => l_vpf.rt_typ_cd
1415: ,p_val => p_mx_elcn_val

Line 1419: hr_utility.set_location('l_cwb_mx_elcn_val is '|| l_cwb_mx_elcn_val,951);

1415: ,p_val => p_mx_elcn_val
1416: ,p_val_2 => l_compensation_value
1417: ,p_calculated_val => l_cwb_mx_elcn_val);
1418: --
1419: hr_utility.set_location('l_cwb_mx_elcn_val is '|| l_cwb_mx_elcn_val,951);
1420: --
1421: -- 5371364 : Do not Operate (i.e multiply/divide..) the Increment Value.
1422: l_cwb_incrmt_elcn_val := p_incrmnt_elcn_val;
1423: /*

Line 1431: hr_utility.set_location('l_cwb_incrmt_elcn_val is '|| l_cwb_incrmt_elcn_val,951);

1427: ,p_val_2 => l_compensation_value
1428: ,p_calculated_val => l_cwb_incrmt_elcn_val);
1429: */
1430: --
1431: hr_utility.set_location('l_cwb_incrmt_elcn_val is '|| l_cwb_incrmt_elcn_val,951);
1432: --
1433: benutils.rt_typ_calc
1434: (p_rt_typ_cd => l_vpf.rt_typ_cd
1435: ,p_val => p_dflt_elcn_val

Line 1439: hr_utility.set_location('l_cwb_dflt_val is '|| l_cwb_dflt_val,951);

1435: ,p_val => p_dflt_elcn_val
1436: ,p_val_2 => l_compensation_value
1437: ,p_calculated_val => l_cwb_dflt_val);
1438: --
1439: hr_utility.set_location('l_cwb_dflt_val is '|| l_cwb_dflt_val,951);
1440: --
1441: if (l_vpf.rndg_cd is not null or
1442: l_vpf.rndg_rl is not null) then
1443:

Line 1482: hr_utility.set_location('doing rounding '||l_package,10);

1478: end if;
1479: --
1480: -- End Bug 4873847.
1481: --
1482: hr_utility.set_location('doing rounding '||l_package,10);
1483: --
1484: if (l_vpf.rndg_cd is not null or
1485: l_vpf.rndg_rl is not null)
1486: and p_val is not null then

Line 1511: hr_utility.set_location('Floor/Ceiling Rule Checking'||l_package,30);

1507: --
1508: close c_asg;
1509: end if;
1510: --
1511: hr_utility.set_location('Floor/Ceiling Rule Checking'||l_package,30);
1512: benutils.limit_checks
1513: (p_upr_lmt_val => l_vpf.upr_lmt_val,
1514: p_lwr_lmt_val => l_vpf.lwr_lmt_val,
1515: p_upr_lmt_calc_rl => l_vpf.upr_lmt_calc_rl,

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

1527: p_acty_base_rt_id => p_acty_base_rt_id,
1528: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1529: p_val => p_val);
1530: --
1531: hr_utility.set_location ('Leaving '||l_package,10);
1532: --
1533: end main;
1534: --
1535: end ben_determine_variable_rates;