DBA Data[Home] [Help]

APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on HR_UTILITY

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

569: -- End Bug 4873847
570: --
571: BEGIN
572: --
573: hr_utility.set_location ('Entering '||l_package,10);
574: --
575: ben_env_object.get(p_rec => l_env);
576: --
577: If (p_person_id is null) then

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

725: close c_epe;
726: --
727: end if;
728: --
729: hr_utility.set_location(l_package||' p_abr_id NN ',10);
730: if p_acty_base_rt_id is not null then
731: --
732: -- FONM
733: open c_avr(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)))

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

748: close c_avr;
749: --
750: end if;
751: --
752: hr_utility.set_location(l_package||' p_aprm_id NN ',10);
753: if p_actl_prem_id is not null then
754: --
755: l_actl_prem_id := p_actl_prem_id;
756: --

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

767: close c_apv;
768: --
769: end if;
770: --
771: hr_utility.set_location(l_package||' p_cacm_id NN ',10);
772: if p_cvg_amt_calc_mthd_id is not null then
773: --
774: open c_bvr(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
775: --

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

786: end if;
787: --
788: -- if one of these are found, then we are dealing with profiles, not rules.
789: --
790: hr_utility.set_location(l_package||' l_avr_found OR ',10);
791: if l_avr_found or l_apv_found or l_bvr_found then
792: --
793: hr_utility.set_location(l_package||' BERP_MN ',10);
794: ben_evaluate_rate_profiles.main

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

789: --
790: hr_utility.set_location(l_package||' l_avr_found OR ',10);
791: if l_avr_found or l_apv_found or l_bvr_found then
792: --
793: hr_utility.set_location(l_package||' BERP_MN ',10);
794: ben_evaluate_rate_profiles.main
795: (p_currepe_row => p_currepe_row
796: ,p_per_row => p_per_row
797: ,p_asg_row => p_asg_row

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

813: ,p_ler_id => l_epe.ler_id
814: ,p_business_group_id => l_epe.business_group_id
815: ,p_vrbl_rt_prfl_id => l_vrbl_rt_prfl_id
816: ); -- this is output
817: hr_utility.set_location(l_package||' Dn BERP_MN ',10);
818: --
819: -- when l_vrbl_rt_prfl_id has no value in it, the person failed the criteria
820: -- and get out! So much for one exit point!
821: --

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

857: end if;
858: --
859: close c_vpf;
860: p_entr_val_at_enrt_flag := l_vpf.no_mn_elcn_val_dfnd_flag; -- Bug 7414757
861: hr_utility.set_location(l_package||' close c_vpf ',10);
862: --
863: if l_vpf.mlt_cd in ('CVG','CLANDCVG','APANDCVG','PRNTANDCVG') then
864: --
865: -- If the rates are being calculated for dummy imputed

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

866: -- income plan then do not raise error even if the
867: -- enrollment benefit row is not created, let the enrt row have
868: -- null val. On enrollment rate is recalculated anyway.
869: --
870: hr_utility.set_location(' plan id ' || p_pl_iD , 99);
871: open c_imp_inc_plan(l_epe.pl_id,
872: nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
873: fetch c_imp_inc_plan into l_imp_inc_plan;
874: close c_imp_inc_plan;

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

872: nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
873: fetch c_imp_inc_plan into l_imp_inc_plan;
874: close c_imp_inc_plan;
875: --
876: hr_utility.set_location(' imp_inc_plan ' || l_imp_inc_plan , 99);
877: if l_imp_inc_plan = 'N' then
878: --
879: if l_coverage_value is null then
880: --

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

928: end if;
929: --
930: end if;
931: --
932: hr_utility.set_location(l_package||' l_vpf.mlt_cd 1 ',10);
933: if l_vpf.mlt_cd in ('CL','CLANDCVG','FLFXPCL') then
934: --
935: if l_vpf.comp_lvl_fctr_id is null then
936: --

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

973: end if;
974: --
975: end if;
976: --
977: hr_utility.set_location(' checking if program or plan ',70);
978: --
979: if l_epe.pgm_id is not null then
980: open c_pgm(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
981: fetch c_pgm into l_pgm;

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

988: end if;
989: close c_pgm;
990: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
991: else
992: hr_utility.set_location(' testing if plan ',80);
993: open c_pln(nvl(l_fonm_cvg_strt_dt, nvl(p_lf_evt_ocrd_dt,p_effective_date)));
994: fetch c_pln into l_pln;
995: if c_pln%notfound then
996: close c_pln;

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

1002: close c_pln;
1003: l_acty_ref_perd_cd := l_pln.nip_acty_ref_perd_cd;
1004: end if;
1005: --
1006: hr_utility.set_location(l_package||' l_vpf.mlt_cd 2 ',10);
1007: --
1008: if l_vpf.mlt_cd in ('AP','APANDCVG') then
1009: --
1010: open c_enrt_prem;

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

1035: p_ler_id => p_ler_id,
1036: p_bnft_amt => p_bnft_amt,
1037: p_business_group_id => p_business_group_id );
1038:
1039: hr_utility.set_location('premium re calculation over ',555666);
1040: l_actl_prem_value := ben_determine_actual_premium.g_computed_prem_val ;
1041: hr_utility.set_location('re calculation premium'||l_actl_prem_value,555666);
1042: ben_determine_actual_premium.g_computed_prem_val := null ;
1043:

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

1037: p_business_group_id => p_business_group_id );
1038:
1039: hr_utility.set_location('premium re calculation over ',555666);
1040: l_actl_prem_value := ben_determine_actual_premium.g_computed_prem_val ;
1041: hr_utility.set_location('re calculation premium'||l_actl_prem_value,555666);
1042: ben_determine_actual_premium.g_computed_prem_val := null ;
1043:
1044: end;
1045: end if;

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

1077: else
1078: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
1079: fnd_message.set_token('PROC',l_package);
1080: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
1081: hr_utility.set_location (' FNDMS_RE 2 ',150);
1082: fnd_message.raise_error;
1083: end if;
1084: --
1085: end if;

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

1088: -- We now should have everything to do the calculation
1089: --
1090: -- Flat Amount
1091: --
1092: hr_utility.set_location(l_package||' rt_typ_calc ELSIFs ',10);
1093: if l_vpf.mlt_cd = 'FLFX' then
1094: --
1095: /* Bug 9306764: Added if..else condition.If VAPRO is 'Enter value at Enrollment',then 'VAL' column will be NULL.
1096: Take the Default value of the VAPRO*/

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

1233: --
1234: else
1235: --
1236: fnd_message.set_name('BEN','BEN_91572_BENVRBRT_MLT_CD');
1237: hr_utility.set_location(l_package||' FND 91572 ',10);
1238: fnd_message.set_token('PACKAGE',l_package);
1239: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
1240: fnd_message.set_token('PGM_ID',to_char(l_epe.pgm_id));
1241: fnd_message.set_token('PL_TYP_ID',to_char(l_epe.pl_typ_id));

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

1449: ,p_val => p_mn_elcn_val
1450: ,p_val_2 => l_compensation_value
1451: ,p_calculated_val => l_cwb_mn_elcn_val);
1452: --
1453: hr_utility.set_location('l_cwb_mn_elcn_val is '||l_cwb_mn_elcn_val,951);
1454: --
1455: benutils.rt_typ_calc
1456: (p_rt_typ_cd => l_vpf.rt_typ_cd
1457: ,p_val => p_mx_elcn_val

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

1457: ,p_val => p_mx_elcn_val
1458: ,p_val_2 => l_compensation_value
1459: ,p_calculated_val => l_cwb_mx_elcn_val);
1460: --
1461: hr_utility.set_location('l_cwb_mx_elcn_val is '|| l_cwb_mx_elcn_val,951);
1462: --
1463: -- 5371364 : Do not Operate (i.e multiply/divide..) the Increment Value.
1464: l_cwb_incrmt_elcn_val := p_incrmnt_elcn_val;
1465: /*

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

1469: ,p_val_2 => l_compensation_value
1470: ,p_calculated_val => l_cwb_incrmt_elcn_val);
1471: */
1472: --
1473: hr_utility.set_location('l_cwb_incrmt_elcn_val is '|| l_cwb_incrmt_elcn_val,951);
1474: --
1475: benutils.rt_typ_calc
1476: (p_rt_typ_cd => l_vpf.rt_typ_cd
1477: ,p_val => p_dflt_elcn_val

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

1477: ,p_val => p_dflt_elcn_val
1478: ,p_val_2 => l_compensation_value
1479: ,p_calculated_val => l_cwb_dflt_val);
1480: --
1481: hr_utility.set_location('l_cwb_dflt_val is '|| l_cwb_dflt_val,951);
1482: --
1483: if (l_vpf.rndg_cd is not null or
1484: l_vpf.rndg_rl is not null) then
1485:

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

1520: end if;
1521: --
1522: -- End Bug 4873847.
1523: --
1524: hr_utility.set_location('doing rounding '||l_package,10);
1525: --
1526: if (l_vpf.rndg_cd is not null or
1527: l_vpf.rndg_rl is not null)
1528: and p_val is not null then

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

1549: --
1550: close c_asg;
1551: end if;
1552: --
1553: hr_utility.set_location('Floor/Ceiling Rule Checking'||l_package,30);
1554: benutils.limit_checks
1555: (p_upr_lmt_val => l_vpf.upr_lmt_val,
1556: p_lwr_lmt_val => l_vpf.lwr_lmt_val,
1557: p_upr_lmt_calc_rl => l_vpf.upr_lmt_calc_rl,

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

1569: p_acty_base_rt_id => p_acty_base_rt_id,
1570: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1571: p_val => p_val);
1572: --
1573: hr_utility.set_location ('Leaving '||l_package,10);
1574: --
1575: end main;
1576: --
1577: end ben_determine_variable_rates;