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

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

193: and pil.business_group_id = p_business_group_id;
194: --
195: begin
196: --
197: hr_utility.set_location('Entering : ' || l_proc, 10);
198: --
199: open c_get_lf_evt_ocrd_dt;
200: fetch c_get_lf_evt_ocrd_dt into l_lf_evt_ocrd_dt;
201: close c_get_lf_evt_ocrd_dt;

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

225: and crp.init_evt_flag = 'Y';
226: --
227: begin
228: --
229: hr_utility.set_location('Entering : ' || l_proc, 10);
230: --
231: open c_chk_init_evt;
232: fetch c_chk_init_evt into l_exists;
233: if c_chk_init_evt%found then

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

274: and psl.business_group_id = p_business_group_id;
275: --
276: begin
277: --
278: hr_utility.set_location('Entering : ' || l_proc, 10);
279: --
280: open c_chk_dsbld;
281: fetch c_chk_dsbld into l_registered_disabled_flag;
282: if c_chk_dsbld%found then

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

350: l_poe_rec c_get_dsblty_max_poe%rowtype;
351: --
352: begin
353: --
354: hr_utility.set_location('Entering : ' || l_proc, 10);
355: --
356: open c_get_dsblty_ler;
357: fetch c_get_dsblty_ler into l_dsblty_ler_id;
358: if c_get_dsblty_ler%found then

Line 359: hr_utility.set_location('Found disability event' , 10);

355: --
356: open c_get_dsblty_ler;
357: fetch c_get_dsblty_ler into l_dsblty_ler_id;
358: if c_get_dsblty_ler%found then
359: hr_utility.set_location('Found disability event' , 10);
360: close c_get_dsblty_ler;
361: --
362: -- Get disability period of enrollment.
363: --

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

575: l_state_rec c_state%rowtype;
576: --
577: begin
578: --
579: hr_utility.set_location('Entering:'|| l_proc, 10);
580: hr_utility.set_location('p_pgm_id:'|| p_pgm_id, 10);
581: hr_utility.set_location('p_ptip_id:'|| p_ptip_id, 10);
582: p_dsbld_apls := false;
583: p_update := true;

Line 580: hr_utility.set_location('p_pgm_id:'|| p_pgm_id, 10);

576: --
577: begin
578: --
579: hr_utility.set_location('Entering:'|| l_proc, 10);
580: hr_utility.set_location('p_pgm_id:'|| p_pgm_id, 10);
581: hr_utility.set_location('p_ptip_id:'|| p_ptip_id, 10);
582: p_dsbld_apls := false;
583: p_update := true;
584: --

Line 581: hr_utility.set_location('p_ptip_id:'|| p_ptip_id, 10);

577: begin
578: --
579: hr_utility.set_location('Entering:'|| l_proc, 10);
580: hr_utility.set_location('p_pgm_id:'|| p_pgm_id, 10);
581: hr_utility.set_location('p_ptip_id:'|| p_ptip_id, 10);
582: p_dsbld_apls := false;
583: p_update := true;
584: --
585: -- Check if a maximum period of enrollment exists for the life event.

Line 616: hr_utility.set_location('mx_poe_det_dt_cd:'|| l_poe_rec.mx_poe_det_dt_cd, 10);

612: if l_eligible then
613: --
614: -- Calculate start and end dates.
615: --
616: hr_utility.set_location('mx_poe_det_dt_cd:'|| l_poe_rec.mx_poe_det_dt_cd, 10);
617: if (l_poe_rec.mx_poe_det_dt_cd = 'CBRQED'
618: or l_poe_rec.mx_poe_det_dt_cd is null) then
619: --
620: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);

Line 620: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);

616: hr_utility.set_location('mx_poe_det_dt_cd:'|| l_poe_rec.mx_poe_det_dt_cd, 10);
617: if (l_poe_rec.mx_poe_det_dt_cd = 'CBRQED'
618: or l_poe_rec.mx_poe_det_dt_cd is null) then
619: --
620: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);
621: p_cbr_elig_perd_strt_dt := p_lf_evt_ocrd_dt;
622: --
623: elsif l_poe_rec.mx_poe_det_dt_cd = 'ECSD' then
624: --

Line 630: hr_utility.set_location('Person ID:'|| p_person_id, 10);

626: fetch c_get_enrt_cvg_strt_dt into l_enrt_cvg_strt_dt;
627: if l_enrt_cvg_strt_dt is null then
628: close c_get_enrt_cvg_strt_dt;
629: --
630: hr_utility.set_location('Person ID:'|| p_person_id, 10);
631: hr_utility.set_location('per_in_ler :'|| p_per_in_ler_id, 10);
632: hr_utility.set_location('business_group_id :'|| p_business_group_id, 10);
633: --
634: -- Problem with eligibility setup. The person has to be

Line 631: hr_utility.set_location('per_in_ler :'|| p_per_in_ler_id, 10);

627: if l_enrt_cvg_strt_dt is null then
628: close c_get_enrt_cvg_strt_dt;
629: --
630: hr_utility.set_location('Person ID:'|| p_person_id, 10);
631: hr_utility.set_location('per_in_ler :'|| p_per_in_ler_id, 10);
632: hr_utility.set_location('business_group_id :'|| p_business_group_id, 10);
633: --
634: -- Problem with eligibility setup. The person has to be
635: -- previously enrolled to be eligible for the COBRA program.

Line 632: hr_utility.set_location('business_group_id :'|| p_business_group_id, 10);

628: close c_get_enrt_cvg_strt_dt;
629: --
630: hr_utility.set_location('Person ID:'|| p_person_id, 10);
631: hr_utility.set_location('per_in_ler :'|| p_per_in_ler_id, 10);
632: hr_utility.set_location('business_group_id :'|| p_business_group_id, 10);
633: --
634: -- Problem with eligibility setup. The person has to be
635: -- previously enrolled to be eligible for the COBRA program.
636: --

Line 647: hr_utility.set_location('l_enrt_cvg_strt_dt prtn:'|| l_enrt_cvg_strt_dt, 10);

643: fnd_message.raise_error;
644: else
645: close c_get_enrt_cvg_strt_dt;
646: p_cbr_elig_perd_strt_dt := l_enrt_cvg_strt_dt;
647: hr_utility.set_location('l_enrt_cvg_strt_dt prtn:'|| l_enrt_cvg_strt_dt, 10);
648: end if;
649: elsif l_poe_rec.mx_poe_det_dt_cd = 'RL' then
650: --
651: -- Get the location info for rule context.

Line 997: hr_utility.set_location(' Leaving:'||l_proc, 70);

993: close c_get_enddsblty_ler;
994: --
995: end if;
996: --
997: hr_utility.set_location(' Leaving:'||l_proc, 70);
998: --
999: end determine_cobra_elig_dates;
1000: --
1001: -- ----------------------------------------------------------------------------

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

1043: l_regn_id number;
1044: --
1045: begin
1046: --
1047: hr_utility.set_location('Entering : ' || l_proc, 10);
1048: --
1049: if p_mx_poe_rl is not null then
1050: --
1051: -- Get the location info for rule context.

Line 1087: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);

1083: l_return_date
1084: := fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);
1085: else
1086: --
1087: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);
1088: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);
1089: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);
1090: l_return_date := benutils.derive_date
1091: (p_date => p_cbr_elig_perd_strt_dt

Line 1088: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);

1084: := fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);
1085: else
1086: --
1087: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);
1088: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);
1089: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);
1090: l_return_date := benutils.derive_date
1091: (p_date => p_cbr_elig_perd_strt_dt
1092: ,p_uom => p_mx_poe_uom

Line 1089: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);

1085: else
1086: --
1087: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);
1088: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);
1089: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);
1090: l_return_date := benutils.derive_date
1091: (p_date => p_cbr_elig_perd_strt_dt
1092: ,p_uom => p_mx_poe_uom
1093: ,p_min => null

Line 1099: hr_utility.set_location('l_return_date : ' || l_return_date, 10);

1095: ,p_value => null
1096: ) - 1;
1097: end if;
1098: --
1099: hr_utility.set_location('l_return_date : ' || l_return_date, 10);
1100: hr_utility.set_location('Leaving : ' || l_proc, 10);
1101: return l_return_date;
1102: end get_cbr_elig_end_dt;
1103: --

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

1096: ) - 1;
1097: end if;
1098: --
1099: hr_utility.set_location('l_return_date : ' || l_return_date, 10);
1100: hr_utility.set_location('Leaving : ' || l_proc, 10);
1101: return l_return_date;
1102: end get_cbr_elig_end_dt;
1103: --
1104: -- ----------------------------------------------------------------------------

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

1124: and pgm.business_group_id=p_business_group_id;
1125: --
1126: begin
1127: --
1128: hr_utility.set_location('Entering : ' || l_proc, 10);
1129: --
1130: open c_chk_pgm_typ;
1131: fetch c_chk_pgm_typ into l_exists;
1132: if c_chk_pgm_typ%found then

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

1134: end if;
1135: close c_chk_pgm_typ;
1136: --
1137: return l_update;
1138: hr_utility.set_location('Leaving : ' || l_proc, 10);
1139: --
1140: end chk_pgm_typ;
1141: -- ----------------------------------------------------------------------------
1142: -- |-------------------------< chk_enrld_or_cvrd >-----------------------------

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

1237:
1238: --
1239: begin
1240: --
1241: hr_utility.set_location('Entering : ' || l_proc, 10);
1242: --
1243: -- Check if enrolled.
1244: --
1245: open c_chk_enrld;

Line 1249: hr_utility.set_location('Enrolled', 10);

1245: open c_chk_enrld;
1246: fetch c_chk_enrld into l_exists;
1247: if c_chk_enrld%found then
1248: l_enrld_or_cvrd := true;
1249: hr_utility.set_location('Enrolled', 10);
1250: else
1251: --
1252: -- Check if covered.
1253: --

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

1259: close c_chk_cvrd;
1260: end if;
1261: close c_chk_enrld;
1262: --
1263: hr_utility.set_location('Leaving : ' || l_proc, 10);
1264: return l_enrld_or_cvrd;
1265: --
1266: end chk_enrld_or_cvrd;
1267: -- ----------------------------------------------------------------------------

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

1325: group by pdp.dpnt_person_id;
1326: --
1327: begin
1328: --
1329: hr_utility.set_location('Entering : ' || l_proc, 10);
1330: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);
1331: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);
1332: hr_utility.set_location('p_person_id : ' || p_person_id, 10);
1333: --

Line 1330: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);

1326: --
1327: begin
1328: --
1329: hr_utility.set_location('Entering : ' || l_proc, 10);
1330: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);
1331: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);
1332: hr_utility.set_location('p_person_id : ' || p_person_id, 10);
1333: --
1334: open c_get_enrt_cvg_thru_dt;

Line 1331: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);

1327: begin
1328: --
1329: hr_utility.set_location('Entering : ' || l_proc, 10);
1330: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);
1331: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);
1332: hr_utility.set_location('p_person_id : ' || p_person_id, 10);
1333: --
1334: open c_get_enrt_cvg_thru_dt;
1335: fetch c_get_enrt_cvg_thru_dt into l_enrt_cvg_thru_dt;

Line 1332: hr_utility.set_location('p_person_id : ' || p_person_id, 10);

1328: --
1329: hr_utility.set_location('Entering : ' || l_proc, 10);
1330: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);
1331: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);
1332: hr_utility.set_location('p_person_id : ' || p_person_id, 10);
1333: --
1334: open c_get_enrt_cvg_thru_dt;
1335: fetch c_get_enrt_cvg_thru_dt into l_enrt_cvg_thru_dt;
1336: close c_get_enrt_cvg_thru_dt;

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

1386: order by epe.pgm_id, epe.ptip_id;
1387: --
1388: begin
1389: --
1390: hr_utility.set_location('Entering : ' || l_proc, 10);
1391: --
1392: for l_epe_rec in c_get_epe loop
1393: --
1394: -- A person can only be eligible in one COBRA program.

Line 1463: hr_utility.set_location('poe_lvl_cd : ' || l_epe_rec.poe_lvl_cd, 10);

1459: end if;
1460: --
1461: elsif l_epe_rec.poe_lvl_cd = 'PTIP' then
1462: --
1463: hr_utility.set_location('poe_lvl_cd : ' || l_epe_rec.poe_lvl_cd, 10);
1464: hr_utility.set_location('l_ptip_id : ' || l_ptip_id, 10);
1465: hr_utility.set_location('l_epe_rec.ptip_id : ' || l_epe_rec.ptip_id, 10);
1466: --
1467: if nvl(l_ptip_id,-1) <> l_epe_rec.ptip_id then

Line 1464: hr_utility.set_location('l_ptip_id : ' || l_ptip_id, 10);

1460: --
1461: elsif l_epe_rec.poe_lvl_cd = 'PTIP' then
1462: --
1463: hr_utility.set_location('poe_lvl_cd : ' || l_epe_rec.poe_lvl_cd, 10);
1464: hr_utility.set_location('l_ptip_id : ' || l_ptip_id, 10);
1465: hr_utility.set_location('l_epe_rec.ptip_id : ' || l_epe_rec.ptip_id, 10);
1466: --
1467: if nvl(l_ptip_id,-1) <> l_epe_rec.ptip_id then
1468: --

Line 1465: hr_utility.set_location('l_epe_rec.ptip_id : ' || l_epe_rec.ptip_id, 10);

1461: elsif l_epe_rec.poe_lvl_cd = 'PTIP' then
1462: --
1463: hr_utility.set_location('poe_lvl_cd : ' || l_epe_rec.poe_lvl_cd, 10);
1464: hr_utility.set_location('l_ptip_id : ' || l_ptip_id, 10);
1465: hr_utility.set_location('l_epe_rec.ptip_id : ' || l_epe_rec.ptip_id, 10);
1466: --
1467: if nvl(l_ptip_id,-1) <> l_epe_rec.ptip_id then
1468: --
1469: -- Determine cobra eligibility start and end dates.

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

1533: --
1534: end if;
1535: end loop;
1536: --
1537: hr_utility.set_location('Leaving : ' || l_proc, 10);
1538: --
1539: end update_cobra_elig_info;
1540: --
1541: -- ----------------------------------------------------------------------------

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

1578: and ctr.business_group_id = p_business_group_id;
1579: --
1580: begin
1581: --
1582: hr_utility.set_location('Entering : ' || l_proc, 10);
1583: --
1584: l_effective_date := p_lf_evt_ocrd_dt - 1;
1585: --
1586: -- only applies to dependents of the covered employee.

Line 1589: hr_utility.set_location('ACDPNT : ' || l_proc, 10);

1585: --
1586: -- only applies to dependents of the covered employee.
1587: --
1588: if p_mx_poe_apls_cd = 'ACDPNT' then
1589: hr_utility.set_location('ACDPNT : ' || l_proc, 10);
1590: --
1591: -- If qualified beneficiary exists,
1592: --
1593: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);

Line 1593: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);

1589: hr_utility.set_location('ACDPNT : ' || l_proc, 10);
1590: --
1591: -- If qualified beneficiary exists,
1592: --
1593: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);
1594: hr_utility.set_location('p_cvrd_emp_person_id : ' || p_cvrd_emp_person_id, 10);
1595: hr_utility.set_location('p_quald_bnf_person_id : ' || p_quald_bnf_person_id, 10);
1596: if p_cbr_quald_bnf_id is not null then
1597: --

Line 1594: hr_utility.set_location('p_cvrd_emp_person_id : ' || p_cvrd_emp_person_id, 10);

1590: --
1591: -- If qualified beneficiary exists,
1592: --
1593: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);
1594: hr_utility.set_location('p_cvrd_emp_person_id : ' || p_cvrd_emp_person_id, 10);
1595: hr_utility.set_location('p_quald_bnf_person_id : ' || p_quald_bnf_person_id, 10);
1596: if p_cbr_quald_bnf_id is not null then
1597: --
1598: -- Check if the person is a covered dependent.

Line 1595: hr_utility.set_location('p_quald_bnf_person_id : ' || p_quald_bnf_person_id, 10);

1591: -- If qualified beneficiary exists,
1592: --
1593: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);
1594: hr_utility.set_location('p_cvrd_emp_person_id : ' || p_cvrd_emp_person_id, 10);
1595: hr_utility.set_location('p_quald_bnf_person_id : ' || p_quald_bnf_person_id, 10);
1596: if p_cbr_quald_bnf_id is not null then
1597: --
1598: -- Check if the person is a covered dependent.
1599: --

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

1651: else
1652: l_eligible := true;
1653: end if;
1654: --
1655: hr_utility.set_location('Leaving : ' || l_proc, 10);
1656: return l_eligible;
1657: end check_max_poe_eligibility;
1658: -- ----------------------------------------------------------------------------
1659: -- |-------------------------< update_dpnt_cobra_info >-----------------------------

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

1747: l_pen_rec c_get_pgm_id%rowtype;
1748: --
1749: begin
1750: --
1751: hr_utility.set_location('Entering : ' || l_proc, 10);
1752: hr_utility.set_location('p_prtt_enrt_rslt_id : ' || p_prtt_enrt_rslt_id, 10);
1753: --
1754: -- Get program id and enrolled person_id from enrollment result.
1755: --

Line 1752: hr_utility.set_location('p_prtt_enrt_rslt_id : ' || p_prtt_enrt_rslt_id, 10);

1748: --
1749: begin
1750: --
1751: hr_utility.set_location('Entering : ' || l_proc, 10);
1752: hr_utility.set_location('p_prtt_enrt_rslt_id : ' || p_prtt_enrt_rslt_id, 10);
1753: --
1754: -- Get program id and enrolled person_id from enrollment result.
1755: --
1756: open c_get_pgm_id;

Line 1764: hr_utility.set_location('pgm_id : ' || l_pen_rec.pgm_id, 10);

1760: l_ptip_id := l_pen_rec.ptip_id;
1761: l_pgm_id := l_pen_rec.pgm_id;
1762: l_enrld_person_id := l_pen_rec.person_id;
1763: --
1764: hr_utility.set_location('pgm_id : ' || l_pen_rec.pgm_id, 10);
1765: hr_utility.set_location('ptip_id : ' || l_pen_rec.ptip_id, 10);
1766: --
1767: if chk_pgm_typ(p_pgm_id => l_pgm_id
1768: ,p_effective_date => p_effective_date

Line 1765: hr_utility.set_location('ptip_id : ' || l_pen_rec.ptip_id, 10);

1761: l_pgm_id := l_pen_rec.pgm_id;
1762: l_enrld_person_id := l_pen_rec.person_id;
1763: --
1764: hr_utility.set_location('pgm_id : ' || l_pen_rec.pgm_id, 10);
1765: hr_utility.set_location('ptip_id : ' || l_pen_rec.ptip_id, 10);
1766: --
1767: if chk_pgm_typ(p_pgm_id => l_pgm_id
1768: ,p_effective_date => p_effective_date
1769: ,p_business_group_id => p_business_group_id

Line 1771: hr_utility.set_location('Leaving - Not found : ' || l_proc, 10);

1767: if chk_pgm_typ(p_pgm_id => l_pgm_id
1768: ,p_effective_date => p_effective_date
1769: ,p_business_group_id => p_business_group_id
1770: ) = false then
1771: hr_utility.set_location('Leaving - Not found : ' || l_proc, 10);
1772: return;
1773: end if;
1774: --
1775: -- Get the life event occurred date.

Line 1818: hr_utility.set_location('Initial qualifying event', 10);

1814: l_pl_typ_id := l_pen_rec.pl_typ_id;
1815: end if;
1816: --
1817: else
1818: hr_utility.set_location('Initial qualifying event', 10);
1819: l_quald_bnf_flag := 'Y';
1820: --
1821: -- Normally, a cobra qualified beneficiary row would exist
1822: -- if benmngle was run for the related life event. In the event

Line 1850: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);

1846: ,p_dsbld_apls => l_dsbld_apls
1847: ,p_update => l_update
1848: );
1849: --
1850: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1851: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1852: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1853: l_cqb_ptip_id := null;
1854: l_pl_typ_id := null;

Line 1851: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);

1847: ,p_update => l_update
1848: );
1849: --
1850: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1851: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1852: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1853: l_cqb_ptip_id := null;
1854: l_pl_typ_id := null;
1855: --

Line 1852: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);

1848: );
1849: --
1850: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1851: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1852: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1853: l_cqb_ptip_id := null;
1854: l_pl_typ_id := null;
1855: --
1856: elsif l_poe_lvl_cd = 'PTIP' then

Line 1919: hr_utility.set_location('Quald bnf exists', 10);

1915: ,p_validate => p_validate
1916: );
1917: else -- quald bnf found.
1918: --
1919: hr_utility.set_location('Quald bnf exists', 10);
1920: --
1921: close c_get_cbr_quald_bnf;
1922: --
1923: if l_cqb_rec.quald_bnf_flag = 'Y' then

Line 1932: hr_utility.set_location('POE LVL '||l_poe_lvl_cd, 10);

1928: open c_get_poe_lvl_cd;
1929: fetch c_get_poe_lvl_cd into l_poe_lvl_cd;
1930: close c_get_poe_lvl_cd;
1931: --
1932: hr_utility.set_location('POE LVL '||l_poe_lvl_cd, 10);
1933: if (l_poe_lvl_cd = 'PGM' or
1934: l_poe_lvl_cd is null) then
1935: --
1936: determine_cobra_elig_dates

Line 1955: hr_utility.set_location('elig_strt_dt '||l_cbr_elig_perd_strt_dt, 10);

1951: ,p_dsbld_apls => l_dsbld_apls
1952: ,p_update => l_update
1953: );
1954: --
1955: hr_utility.set_location('elig_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1956: hr_utility.set_location('elig_end_dt '||l_cbr_elig_perd_end_dt, 10);
1957: hr_utility.set_location('old_elig_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1958: l_cqb_ptip_id := null;
1959: l_pl_typ_id := null;

Line 1956: hr_utility.set_location('elig_end_dt '||l_cbr_elig_perd_end_dt, 10);

1952: ,p_update => l_update
1953: );
1954: --
1955: hr_utility.set_location('elig_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1956: hr_utility.set_location('elig_end_dt '||l_cbr_elig_perd_end_dt, 10);
1957: hr_utility.set_location('old_elig_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1958: l_cqb_ptip_id := null;
1959: l_pl_typ_id := null;
1960: --

Line 1957: hr_utility.set_location('old_elig_end_dt '||l_old_cbr_elig_perd_end_dt, 10);

1953: );
1954: --
1955: hr_utility.set_location('elig_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1956: hr_utility.set_location('elig_end_dt '||l_cbr_elig_perd_end_dt, 10);
1957: hr_utility.set_location('old_elig_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1958: l_cqb_ptip_id := null;
1959: l_pl_typ_id := null;
1960: --
1961: elsif l_poe_lvl_cd = 'PTIP' then

Line 1985: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);

1981: ,p_cvrd_emp_person_id => l_cvrd_emp_person_id
1982: ,p_dsbld_apls => l_dsbld_apls
1983: ,p_update => l_update
1984: );
1985: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1986: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1987: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1988: end if;
1989: --

Line 1986: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);

1982: ,p_dsbld_apls => l_dsbld_apls
1983: ,p_update => l_update
1984: );
1985: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1986: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1987: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1988: end if;
1989: --
1990: update_cobra_info

Line 1987: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);

1983: ,p_update => l_update
1984: );
1985: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1986: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1987: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1988: end if;
1989: --
1990: update_cobra_info
1991: (p_per_in_ler_id => p_per_in_ler_id

Line 2007: hr_utility.set_location('quald_bnf_flag N', 10);

2003: ,p_validate => p_validate
2004: );
2005: else -- if qual bnf flag = 'N'
2006: --
2007: hr_utility.set_location('quald_bnf_flag N', 10);
2008: --
2009: -- If it is the initial event, person is now a qualified beneficiary.
2010: --
2011: if (chk_init_evt(p_per_in_ler_id => p_per_in_ler_id

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

2103: end if; -- End check initial event.
2104: end if;
2105: end if;
2106: --
2107: hr_utility.set_location('Leaving : ' || l_proc, 10);
2108: end update_dpnt_cobra_info;
2109: -- ----------------------------------------------------------------------------
2110: -- |-------------------------< chk_cobra_eligibility >-------------------------
2111: -- ----------------------------------------------------------------------------

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

2171: l_crp_rec c_chk_init_evt%rowtype;
2172: --
2173: begin
2174: --
2175: hr_utility.set_location('Entering : ' || l_proc, 10);
2176: --
2177: -- Only update COBRA information if person is enrolling
2178: -- in a COBRA program.
2179: --

Line 2184: hr_utility.set_location('Leaving : ' || l_proc, 15);

2180: if chk_pgm_typ(p_pgm_id => p_pgm_id
2181: ,p_effective_date => p_effective_date
2182: ,p_business_group_id => p_business_group_id
2183: ) = false then
2184: hr_utility.set_location('Leaving : ' || l_proc, 15);
2185: return;
2186: end if;
2187: --
2188: -- If it is the initial event, the Loss of Eligibility temporal

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

2305: else
2306: close c_chk_init_evt;
2307: end if;
2308: --
2309: hr_utility.set_location('Leaving : ' || l_proc, 10);
2310: end chk_cobra_eligibility;
2311: -- ----------------------------------------------------------------------------
2312: -- |-------------------------< update_cobra_info >-----------------------------
2313: -- ----------------------------------------------------------------------------

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

2467: l_crp_rec c_check_cbr_per_in_ler%rowtype;
2468: l_crp2_rec c_get_cvrd_emp_pil%rowtype;
2469: begin
2470: --
2471: hr_utility.set_location('Entering : ' || l_proc, 10);
2472: --
2473: l_cbr_elig_perd_end_dt := p_cbr_elig_perd_end_dt;
2474: --
2475: if p_cbr_quald_bnf_id is null then

Line 2477: hr_utility.set_location('New Event : ' || l_proc, 10);

2473: l_cbr_elig_perd_end_dt := p_cbr_elig_perd_end_dt;
2474: --
2475: if p_cbr_quald_bnf_id is null then
2476: --
2477: hr_utility.set_location('New Event : ' || l_proc, 10);
2478: --
2479: -- New qualifying event.
2480: --
2481: if p_cvrd_emp_person_id is null then

Line 2523: hr_utility.set_location('Inserting quald bnf: ' || l_proc, 10);

2519: end if;
2520: --
2521: -- Write cobra qualified beneficiary row.
2522: --
2523: hr_utility.set_location('Inserting quald bnf: ' || l_proc, 10);
2524: hr_utility.set_location('l_cbr_elig_perd_end_dt: ' || l_cbr_elig_perd_end_dt, 10);
2525: --
2526: ben_cbr_quald_bnf_api.create_cbr_quald_bnf
2527: (p_validate => p_validate

Line 2524: hr_utility.set_location('l_cbr_elig_perd_end_dt: ' || l_cbr_elig_perd_end_dt, 10);

2520: --
2521: -- Write cobra qualified beneficiary row.
2522: --
2523: hr_utility.set_location('Inserting quald bnf: ' || l_proc, 10);
2524: hr_utility.set_location('l_cbr_elig_perd_end_dt: ' || l_cbr_elig_perd_end_dt, 10);
2525: --
2526: ben_cbr_quald_bnf_api.create_cbr_quald_bnf
2527: (p_validate => p_validate
2528: ,p_cbr_quald_bnf_id => l_cbr_quald_bnf_id

Line 2580: hr_utility.set_location('Not a qualified beneficiary: '||l_cvrd_emp_person_id, 10);

2576: end if;
2577: --
2578: else -- If person is not a qualified beneficiary.
2579: --
2580: hr_utility.set_location('Not a qualified beneficiary: '||l_cvrd_emp_person_id, 10);
2581: --
2582: -- Create a COBRA per in ler id using the covered employee initial
2583: -- life events. This is needed since the form now has to check
2584: -- if the per_in_ler is backed out before it displays the qualified

Line 2605: hr_utility.set_location('Did not find covered employee: '||l_cvrd_emp_person_id, 10);

2601: ,p_object_version_number => l_object_version_number
2602: ,p_effective_date => p_effective_date
2603: );
2604: else
2605: hr_utility.set_location('Did not find covered employee: '||l_cvrd_emp_person_id, 10);
2606: hr_utility.set_location('ptip_id : '||p_ptip_id, 10);
2607: hr_utility.set_location('pgm_id : '||p_pgm_id, 10);
2608: close c_get_cvrd_emp_pil;
2609: end if;

Line 2606: hr_utility.set_location('ptip_id : '||p_ptip_id, 10);

2602: ,p_effective_date => p_effective_date
2603: );
2604: else
2605: hr_utility.set_location('Did not find covered employee: '||l_cvrd_emp_person_id, 10);
2606: hr_utility.set_location('ptip_id : '||p_ptip_id, 10);
2607: hr_utility.set_location('pgm_id : '||p_pgm_id, 10);
2608: close c_get_cvrd_emp_pil;
2609: end if;
2610: --

Line 2607: hr_utility.set_location('pgm_id : '||p_pgm_id, 10);

2603: );
2604: else
2605: hr_utility.set_location('Did not find covered employee: '||l_cvrd_emp_person_id, 10);
2606: hr_utility.set_location('ptip_id : '||p_ptip_id, 10);
2607: hr_utility.set_location('pgm_id : '||p_pgm_id, 10);
2608: close c_get_cvrd_emp_pil;
2609: end if;
2610: --
2611: end if;

Line 2651: hr_utility.set_location('l_cbr_elig_perd_end_dt update: '||l_cbr_elig_perd_end_dt, 10);

2647: if l_cbr_elig_perd_end_dt is not null then
2648: --
2649: if p_old_cbr_elig_perd_end_dt <> l_cbr_elig_perd_end_dt then
2650: --
2651: hr_utility.set_location('l_cbr_elig_perd_end_dt update: '||l_cbr_elig_perd_end_dt, 10);
2652: --
2653: --
2654: -- If the cobra eligibility start date is the start of time (01/01/0001), set the
2655: -- qualified beneficiary flag to 'N' instead of updating the eligiblity end date.

Line 2677: hr_utility.set_location('Disabled: ' || l_cbr_elig_perd_end_dt, 10);

2673: ,p_effective_date => p_effective_date
2674: );
2675: --
2676: if p_dsbld_apls = true then
2677: hr_utility.set_location('Disabled: ' || l_cbr_elig_perd_end_dt, 10);
2678: for l_dpnt_rec in c_get_all_quald_dpnts loop
2679: if l_cbr_elig_perd_end_dt > l_dpnt_rec.cbr_elig_perd_end_dt
2680: then
2681: hr_utility.set_location('Dpnt dsbld : ' || l_cbr_elig_perd_end_dt, 10);

Line 2681: hr_utility.set_location('Dpnt dsbld : ' || l_cbr_elig_perd_end_dt, 10);

2677: hr_utility.set_location('Disabled: ' || l_cbr_elig_perd_end_dt, 10);
2678: for l_dpnt_rec in c_get_all_quald_dpnts loop
2679: if l_cbr_elig_perd_end_dt > l_dpnt_rec.cbr_elig_perd_end_dt
2680: then
2681: hr_utility.set_location('Dpnt dsbld : ' || l_cbr_elig_perd_end_dt, 10);
2682: --
2683: l_object_version_number := l_dpnt_rec.object_version_number;
2684: --
2685: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

Line 2705: hr_utility.set_location('l_cnt_num : ' || l_cnt_num, 10);

2701: open c_get_cnt_num(l_dpnt_rec.cbr_quald_bnf_id);
2702: fetch c_get_cnt_num into l_cnt_num;
2703: close c_get_cnt_num;
2704: --
2705: hr_utility.set_location('l_cnt_num : ' || l_cnt_num, 10);
2706: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
2707: (p_validate => p_validate
2708: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
2709: ,p_init_evt_flag => 'N'

Line 2750: hr_utility.set_location('l_cnt_num : ' || l_cnt_num, 10);

2746: open c_get_cnt_num(p_cbr_quald_bnf_id);
2747: fetch c_get_cnt_num into l_cnt_num;
2748: close c_get_cnt_num;
2749: --
2750: hr_utility.set_location('l_cnt_num : ' || l_cnt_num, 10);
2751: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
2752: (p_validate => p_validate
2753: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
2754: ,p_init_evt_flag => 'N'

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

2769: --
2770: end if; -- end date is not null
2771: end if; -- qual_bnf flag = 'Y'
2772: end if;
2773: hr_utility.set_location('Leaving : ' || l_proc, 10);
2774: end update_cobra_info;
2775: -- ----------------------------------------------------------------------------
2776: -- |-------------------------< end_prtt_cobra_eligibility >-------------------------
2777: -- ----------------------------------------------------------------------------

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

2852: --
2853: begin
2854: g_cobra_enrollment_change := FALSE;
2855: --
2856: hr_utility.set_location('Entering : ' || l_proc, 10);
2857: --
2858: -- Get life event occurred date.
2859: --
2860: l_lf_evt_ocrd_dt := get_lf_evt_ocrd_dt

Line 2871: hr_utility.set_location('l_effective_date: ' || l_effective_date, 10);

2867: for l_cqb_rec in c_get_cbr_quald_bnf loop
2868: l_cbr_quald_bnf_id := l_cqb_rec.cbr_quald_bnf_id;
2869: l_cqb_object_version_number := l_cqb_rec.object_version_number;
2870: l_cqb_quald_bnf_flag := l_cqb_rec.quald_bnf_flag;
2871: hr_utility.set_location('l_effective_date: ' || l_effective_date, 10);
2872: hr_utility.set_location('cqb_ptip_id: ' || l_cqb_rec.ptip_id, 10);
2873: hr_utility.set_location('cqb_pgm_id: ' || l_cqb_rec.pgm_id, 10);
2874: --
2875: -- If life event occurred date + 1 = to the cobra eligibility

Line 2872: hr_utility.set_location('cqb_ptip_id: ' || l_cqb_rec.ptip_id, 10);

2868: l_cbr_quald_bnf_id := l_cqb_rec.cbr_quald_bnf_id;
2869: l_cqb_object_version_number := l_cqb_rec.object_version_number;
2870: l_cqb_quald_bnf_flag := l_cqb_rec.quald_bnf_flag;
2871: hr_utility.set_location('l_effective_date: ' || l_effective_date, 10);
2872: hr_utility.set_location('cqb_ptip_id: ' || l_cqb_rec.ptip_id, 10);
2873: hr_utility.set_location('cqb_pgm_id: ' || l_cqb_rec.pgm_id, 10);
2874: --
2875: -- If life event occurred date + 1 = to the cobra eligibility
2876: -- end date, we are processing a loss of eligibility event

Line 2873: hr_utility.set_location('cqb_pgm_id: ' || l_cqb_rec.pgm_id, 10);

2869: l_cqb_object_version_number := l_cqb_rec.object_version_number;
2870: l_cqb_quald_bnf_flag := l_cqb_rec.quald_bnf_flag;
2871: hr_utility.set_location('l_effective_date: ' || l_effective_date, 10);
2872: hr_utility.set_location('cqb_ptip_id: ' || l_cqb_rec.ptip_id, 10);
2873: hr_utility.set_location('cqb_pgm_id: ' || l_cqb_rec.pgm_id, 10);
2874: --
2875: -- If life event occurred date + 1 = to the cobra eligibility
2876: -- end date, we are processing a loss of eligibility event
2877: -- or the max period of enrollment is reached so the COBRA

Line 2893: hr_utility.set_location('Not enrolled: ', 10);

2889: ,p_ptip_id => l_cqb_rec.ptip_id
2890: ,p_person_id => p_person_id
2891: ,p_effective_date => p_effective_date
2892: ,p_business_group_id => p_business_group_id)) = false then
2893: hr_utility.set_location('Not enrolled: ', 10);
2894: --
2895: -- if person is not enroll then check if the person has no electable choices
2896: -- a COBRA program.
2897: --

Line 2905: hr_utility.set_location('No choices found: ', 10);

2901: fetch c_chk_elctbl_chc into l_exists;
2902: if c_chk_elctbl_chc%notfound then
2903: close c_chk_elctbl_chc;
2904: --
2905: hr_utility.set_location('No choices found: ', 10);
2906: --
2907: l_cbr_elig_perd_end_dt := get_max_cvg_thru_dt
2908: (p_person_id => p_person_id
2909: ,p_lf_evt_ocrd_dt => l_effective_date

Line 2916: hr_utility.set_location('l_cbr_elig_perd_end_dt : ' || l_cbr_elig_perd_end_dt, 10);

2912: ,p_per_in_ler_id => p_per_in_ler_id
2913: ,p_effective_date => p_effective_date
2914: ,p_business_group_id => p_business_group_id
2915: );
2916: hr_utility.set_location('l_cbr_elig_perd_end_dt : ' || l_cbr_elig_perd_end_dt, 10);
2917:
2918: --
2919: -- Write a cobra per_in_ler row for the person if the cobra eligibility
2920: -- period end date is not equal to the cobra eligibility end date

Line 2943: hr_utility.set_location('l_ler_typ: '||l_typ_cd, 10);

2939: l_cbr_inelg_rsn_cd := 'PLE';
2940: else
2941: l_cbr_inelg_rsn_cd := hr_api.g_varchar2;
2942: end if;
2943: hr_utility.set_location('l_ler_typ: '||l_typ_cd, 10);
2944: end if;
2945: close c_get_ler_type;
2946: --
2947: end_cobra_eligibility

Line 2961: hr_utility.set_location('Choices found: ', 10);

2957: );
2958: end if;
2959: --
2960: else
2961: hr_utility.set_location('Choices found: ', 10);
2962: close c_chk_elctbl_chc;
2963: end if;
2964: end if;
2965: end loop;

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

2963: end if;
2964: end if;
2965: end loop;
2966: --
2967: hr_utility.set_location('Leaving : ' || l_proc, 10);
2968: end end_prtt_cobra_eligibility;
2969: --
2970: -- ----------------------------------------------------------------------------
2971: -- |-------------------------< end_cobra_eligibility >-------------------------

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

3009: and crp.per_in_ler_id = p_per_in_ler_id;
3010: --
3011: begin
3012: --
3013: hr_utility.set_location('Entering : ' || l_proc, 10);
3014: --
3015: -- If cobra per in ler exists, update the row.
3016: --
3017: open c_chk_cbr_per_in_ler;

Line 3047: hr_utility.set_location('p_cbr_elig_perd_end_dt'||p_cbr_elig_perd_end_dt, 20);

3043: end if;
3044: --
3045: l_cqb_object_version_number := p_cqb_object_version_number;
3046: --
3047: hr_utility.set_location('p_cbr_elig_perd_end_dt'||p_cbr_elig_perd_end_dt, 20);
3048: hr_utility.set_location('p_quald_bnf_flag'||p_quald_bnf_flag, 30);
3049: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
3050: (p_validate => p_validate
3051: ,p_cbr_quald_bnf_id => p_cbr_quald_bnf_id

Line 3048: hr_utility.set_location('p_quald_bnf_flag'||p_quald_bnf_flag, 30);

3044: --
3045: l_cqb_object_version_number := p_cqb_object_version_number;
3046: --
3047: hr_utility.set_location('p_cbr_elig_perd_end_dt'||p_cbr_elig_perd_end_dt, 20);
3048: hr_utility.set_location('p_quald_bnf_flag'||p_quald_bnf_flag, 30);
3049: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
3050: (p_validate => p_validate
3051: ,p_cbr_quald_bnf_id => p_cbr_quald_bnf_id
3052: ,p_quald_bnf_flag => p_quald_bnf_flag

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

3056: ,p_object_version_number => l_cqb_object_version_number
3057: ,p_effective_date => p_effective_date
3058: );
3059: --
3060: hr_utility.set_location('Leaving : ' || l_proc, 10);
3061: end end_cobra_eligibility;
3062: --
3063: --
3064: -- ----------------------------------------------------------------------------

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

3118:
3119: l_proc varchar2(80) := g_package||'.compute_period_rate';
3120: begin
3121:
3122: hr_utility.set_location('Entering : ' || l_proc, 10);
3123:
3124: l_balance := p_ann_rt_val - p_rate_ytd;
3125:
3126: l_notional_months := MONTHS_BETWEEN(LAST_DAY(p_plan_year_end_dt),

Line 3144: hr_utility.set_location('l_return_amt'|| l_return_amt, 10);

3140: l_first_pp_adjustment:= l_balance - (l_per_month_amt * l_notional_months);
3141:
3142: l_return_amt := l_first_pp_adjustment + (l_months_remaining * l_per_month_amt);
3143:
3144: hr_utility.set_location('l_return_amt'|| l_return_amt, 10);
3145: hr_utility.set_location('Leaving : ' || l_proc, 10);
3146:
3147: return l_return_amt;
3148:

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

3141:
3142: l_return_amt := l_first_pp_adjustment + (l_months_remaining * l_per_month_amt);
3143:
3144: hr_utility.set_location('l_return_amt'|| l_return_amt, 10);
3145: hr_utility.set_location('Leaving : ' || l_proc, 10);
3146:
3147: return l_return_amt;
3148:
3149: end compute_period_rate;

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

3309: l_rate_ytd number;
3310: l_proc varchar2(80) := g_package||'.get_amount_due';
3311: begin
3312:
3313: hr_utility.set_location('Entering : ' || l_proc, 10);
3314:
3315: open c_current_result_info(c_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id);
3316: fetch c_current_result_info into l_result_rec;
3317: close c_current_result_info;

Line 3352: hr_utility.set_location('l_months_remaining ' || l_months_remaining, 10);

3348:
3349: l_months_remaining := MONTHS_BETWEEN(LAST_DAY(l_plan_year_end_dt)
3350: ,ADD_MONTHS(LAST_DAY(p_rt_strt_dt),-1));
3351:
3352: hr_utility.set_location('l_months_remaining ' || l_months_remaining, 10);
3353:
3354: if l_get_abr_info.entr_ann_val_flag='Y' or
3355: l_prnt_ann_rt = 'Y' or
3356: l_mlt_cd = 'SAREC' then

Line 3386: hr_utility.set_location('l_rate_ytd '|| l_rate_ytd, 10);

3382: ,p_rndg_cd => l_get_abr_info.rndg_cd
3383: ,p_rndg_rl => l_get_abr_info.rndg_rl
3384: ,p_plan_year_end_dt => l_plan_year_end_dt);
3385:
3386: hr_utility.set_location('l_rate_ytd '|| l_rate_ytd, 10);
3387:
3388: l_rt_strt_dt := r_rates.rt_strt_dt;
3389: l_rt_end_dt := r_rates.rt_end_dt;
3390: l_ann_rt_val := r_rates.ann_rt_val;

Line 3407: hr_utility.set_location('l_rate_ytd '|| l_rate_ytd, 20);

3403: ,p_rndg_cd => l_get_abr_info.rndg_cd
3404: ,p_rndg_rl => l_get_abr_info.rndg_rl
3405: ,p_plan_year_end_dt => l_plan_year_end_dt);
3406:
3407: hr_utility.set_location('l_rate_ytd '|| l_rate_ytd, 20);
3408: end if;
3409:
3410: l_balance := p_ann_rt_val - l_rate_ytd;
3411:

Line 3535: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);

3531: p_per_month_amt := l_per_month_amt;
3532: p_first_month_amt := l_prorated_first_mth_amt;
3533: p_last_month_amt := l_prorated_last_mth_amt;
3534:
3535: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);
3536: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);
3537: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);
3538:
3539: hr_utility.set_location('Leaving : ' || l_proc, 10);

Line 3536: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);

3532: p_first_month_amt := l_prorated_first_mth_amt;
3533: p_last_month_amt := l_prorated_last_mth_amt;
3534:
3535: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);
3536: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);
3537: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);
3538:
3539: hr_utility.set_location('Leaving : ' || l_proc, 10);
3540:

Line 3537: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);

3533: p_last_month_amt := l_prorated_last_mth_amt;
3534:
3535: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);
3536: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);
3537: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);
3538:
3539: hr_utility.set_location('Leaving : ' || l_proc, 10);
3540:
3541: end get_amount_due;

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

3535: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);
3536: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);
3537: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);
3538:
3539: hr_utility.set_location('Leaving : ' || l_proc, 10);
3540:
3541: end get_amount_due;
3542: --
3543: procedure get_due_and_payment_amt(p_person_id in number

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

3604: l_proc varchar2(80) := g_package||'.get_due_and_payment_amt';
3605:
3606: begin
3607:
3608: hr_utility.set_location('Entering : ' || l_proc, 10);
3609:
3610: ben_element_entry.get_abr_assignment
3611: (p_person_id => p_person_id
3612: ,p_effective_date => p_effective_date

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

3658: -- Set Out variables
3659: p_amt_due := l_amt_due;
3660: p_prev_pymts := l_prev_pymts;
3661:
3662: hr_utility.set_location('Leaving : ' || l_proc, 10);
3663:
3664: end get_due_and_payment_amt;
3665: --
3666: function get_comp_object_name(p_pl_id in number

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

3818: l_proc varchar2(80) := g_package||'.get_unpaid_rate';
3819:
3820: begin
3821:
3822: hr_utility.set_location('Entering : ' || l_proc, 10);
3823:
3824: open c_rates(c_person_id => p_person_id
3825: ,c_pgm_id => p_pgm_id
3826: ,c_pl_typ_id => p_pl_typ_id

Line 3960: hr_utility.set_location('p_rt_strt_dt ' ||p_rt_strt_dt, 10);

3956: -- Set Out variables
3957: p_rt_strt_dt := l_rt_strt_dt;
3958: p_elm_chg_warning := l_warning;
3959:
3960: hr_utility.set_location('p_rt_strt_dt ' ||p_rt_strt_dt, 10);
3961: hr_utility.set_location('Leaving : ' || l_proc, 10);
3962: end get_unpaid_rate;
3963: --
3964: -- ----------------------------------------------------------------------------

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

3957: p_rt_strt_dt := l_rt_strt_dt;
3958: p_elm_chg_warning := l_warning;
3959:
3960: hr_utility.set_location('p_rt_strt_dt ' ||p_rt_strt_dt, 10);
3961: hr_utility.set_location('Leaving : ' || l_proc, 10);
3962: end get_unpaid_rate;
3963: --
3964: -- ----------------------------------------------------------------------------
3965: -- |-------------------------< get_costing_details >---------------------------

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

4380:
4381: l_proc varchar2(80) := g_package||'.allocate_payment';
4382: begin
4383:
4384: hr_utility.set_location('Entering : ' || l_proc, 10);
4385:
4386: l_amount_paid_bal := ABS(p_amount_paid);
4387:
4388: open c_pen(p_prtt_enrt_rslt_id,p_effective_date,p_acty_base_rt_id);

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

4829: elsif p_amount_paid < 0 then
4830: p_excess_amount := - l_amount_paid_bal;
4831: end if;
4832:
4833: hr_utility.set_location('Leaving : ' || l_proc, 10);
4834: end allocate_payment;
4835:
4836: END ben_cobra_requirements;