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

210: and pil.business_group_id = p_business_group_id;
211: --
212: begin
213: --
214: hr_utility.set_location('Entering : ' || l_proc, 10);
215: --
216: open c_get_lf_evt_ocrd_dt;
217: fetch c_get_lf_evt_ocrd_dt into l_lf_evt_ocrd_dt;
218: close c_get_lf_evt_ocrd_dt;

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

242: and crp.init_evt_flag = 'Y';
243: --
244: begin
245: --
246: hr_utility.set_location('Entering : ' || l_proc, 10);
247: --
248: open c_chk_init_evt;
249: fetch c_chk_init_evt into l_exists;
250: if c_chk_init_evt%found then

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

291: and psl.business_group_id = p_business_group_id;
292: --
293: begin
294: --
295: hr_utility.set_location('Entering : ' || l_proc, 10);
296: --
297: open c_chk_dsbld;
298: fetch c_chk_dsbld into l_registered_disabled_flag;
299: if c_chk_dsbld%found then

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

367: l_poe_rec c_get_dsblty_max_poe%rowtype;
368: --
369: begin
370: --
371: hr_utility.set_location('Entering : ' || l_proc, 10);
372: --
373: open c_get_dsblty_ler;
374: fetch c_get_dsblty_ler into l_dsblty_ler_id;
375: if c_get_dsblty_ler%found then

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

372: --
373: open c_get_dsblty_ler;
374: fetch c_get_dsblty_ler into l_dsblty_ler_id;
375: if c_get_dsblty_ler%found then
376: hr_utility.set_location('Found disability event' , 10);
377: close c_get_dsblty_ler;
378: --
379: -- Get disability period of enrollment.
380: --

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

593: l_state_rec c_state%rowtype;
594: --
595: begin
596: --
597: hr_utility.set_location('Entering:'|| l_proc, 10);
598: hr_utility.set_location('p_pgm_id:'|| p_pgm_id, 10);
599: hr_utility.set_location('p_ptip_id:'|| p_ptip_id, 10);
600: p_dsbld_apls := false;
601: p_update := true;

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

594: --
595: begin
596: --
597: hr_utility.set_location('Entering:'|| l_proc, 10);
598: hr_utility.set_location('p_pgm_id:'|| p_pgm_id, 10);
599: hr_utility.set_location('p_ptip_id:'|| p_ptip_id, 10);
600: p_dsbld_apls := false;
601: p_update := true;
602: --

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

595: begin
596: --
597: hr_utility.set_location('Entering:'|| l_proc, 10);
598: hr_utility.set_location('p_pgm_id:'|| p_pgm_id, 10);
599: hr_utility.set_location('p_ptip_id:'|| p_ptip_id, 10);
600: p_dsbld_apls := false;
601: p_update := true;
602: --
603: -- Check if a maximum period of enrollment exists for the life event.

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

630: if l_eligible then
631: --
632: -- Calculate start and end dates.
633: --
634: hr_utility.set_location('mx_poe_det_dt_cd:'|| l_poe_rec.mx_poe_det_dt_cd, 10);
635: if (l_poe_rec.mx_poe_det_dt_cd = 'CBRQED'
636: or l_poe_rec.mx_poe_det_dt_cd is null) then
637: --
638: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);

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

634: hr_utility.set_location('mx_poe_det_dt_cd:'|| l_poe_rec.mx_poe_det_dt_cd, 10);
635: if (l_poe_rec.mx_poe_det_dt_cd = 'CBRQED'
636: or l_poe_rec.mx_poe_det_dt_cd is null) then
637: --
638: hr_utility.set_location('p_lf_evt_ocrd_dt:'|| p_lf_evt_ocrd_dt, 10);
639: p_cbr_elig_perd_strt_dt := p_lf_evt_ocrd_dt;
640: --
641: elsif l_poe_rec.mx_poe_det_dt_cd = 'ECSD' then
642: --

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

644: fetch c_get_enrt_cvg_strt_dt into l_enrt_cvg_strt_dt;
645: if l_enrt_cvg_strt_dt is null then
646: close c_get_enrt_cvg_strt_dt;
647: --
648: hr_utility.set_location('Person ID:'|| p_person_id, 10);
649: hr_utility.set_location('per_in_ler :'|| p_per_in_ler_id, 10);
650: hr_utility.set_location('business_group_id :'|| p_business_group_id, 10);
651: --
652: -- Problem with eligibility setup. The person has to be

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

645: if l_enrt_cvg_strt_dt is null then
646: close c_get_enrt_cvg_strt_dt;
647: --
648: hr_utility.set_location('Person ID:'|| p_person_id, 10);
649: hr_utility.set_location('per_in_ler :'|| p_per_in_ler_id, 10);
650: hr_utility.set_location('business_group_id :'|| p_business_group_id, 10);
651: --
652: -- Problem with eligibility setup. The person has to be
653: -- previously enrolled to be eligible for the COBRA program.

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

646: close c_get_enrt_cvg_strt_dt;
647: --
648: hr_utility.set_location('Person ID:'|| p_person_id, 10);
649: hr_utility.set_location('per_in_ler :'|| p_per_in_ler_id, 10);
650: hr_utility.set_location('business_group_id :'|| p_business_group_id, 10);
651: --
652: -- Problem with eligibility setup. The person has to be
653: -- previously enrolled to be eligible for the COBRA program.
654: --

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

661: fnd_message.raise_error;
662: else
663: close c_get_enrt_cvg_strt_dt;
664: p_cbr_elig_perd_strt_dt := l_enrt_cvg_strt_dt;
665: hr_utility.set_location('l_enrt_cvg_strt_dt prtn:'|| l_enrt_cvg_strt_dt, 10);
666: end if;
667: elsif l_poe_rec.mx_poe_det_dt_cd = 'RL' then
668: --
669: -- Get the location info for rule context.

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

1011: close c_get_enddsblty_ler;
1012: --
1013: end if;
1014: --
1015: hr_utility.set_location(' Leaving:'||l_proc, 70);
1016: --
1017: end determine_cobra_elig_dates;
1018: --
1019: -- ----------------------------------------------------------------------------

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

1061: l_regn_id number;
1062: --
1063: begin
1064: --
1065: hr_utility.set_location('Entering : ' || l_proc, 10);
1066: --
1067: if p_mx_poe_rl is not null then
1068: --
1069: -- Get the location info for rule context.

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

1101: l_return_date
1102: := fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);
1103: else
1104: --
1105: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);
1106: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);
1107: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);
1108: l_return_date := benutils.derive_date
1109: (p_date => p_cbr_elig_perd_strt_dt

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

1102: := fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);
1103: else
1104: --
1105: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);
1106: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);
1107: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);
1108: l_return_date := benutils.derive_date
1109: (p_date => p_cbr_elig_perd_strt_dt
1110: ,p_uom => p_mx_poe_uom

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

1103: else
1104: --
1105: hr_utility.set_location('p_cbr_elig_perd_strt_dt : ' || p_cbr_elig_perd_strt_dt, 10);
1106: hr_utility.set_location('p_mx_poe_uom : ' || p_mx_poe_uom, 10);
1107: hr_utility.set_location('p_mx_poe_val : ' || p_mx_poe_val, 10);
1108: l_return_date := benutils.derive_date
1109: (p_date => p_cbr_elig_perd_strt_dt
1110: ,p_uom => p_mx_poe_uom
1111: ,p_min => null

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

1113: ,p_value => null
1114: ) - 1;
1115: end if;
1116: --
1117: hr_utility.set_location('l_return_date : ' || l_return_date, 10);
1118: hr_utility.set_location('Leaving : ' || l_proc, 10);
1119: return l_return_date;
1120: end get_cbr_elig_end_dt;
1121: --

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

1114: ) - 1;
1115: end if;
1116: --
1117: hr_utility.set_location('l_return_date : ' || l_return_date, 10);
1118: hr_utility.set_location('Leaving : ' || l_proc, 10);
1119: return l_return_date;
1120: end get_cbr_elig_end_dt;
1121: --
1122: -- ----------------------------------------------------------------------------

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

1142: and pgm.business_group_id=p_business_group_id;
1143: --
1144: begin
1145: --
1146: hr_utility.set_location('Entering : ' || l_proc, 10);
1147: --
1148: open c_chk_pgm_typ;
1149: fetch c_chk_pgm_typ into l_exists;
1150: if c_chk_pgm_typ%found then

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

1152: end if;
1153: close c_chk_pgm_typ;
1154: --
1155: return l_update;
1156: hr_utility.set_location('Leaving : ' || l_proc, 10);
1157: --
1158: end chk_pgm_typ;
1159: -- ----------------------------------------------------------------------------
1160: -- |-------------------------< chk_enrld_or_cvrd >-----------------------------

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

1255:
1256: --
1257: begin
1258: --
1259: hr_utility.set_location('Entering : ' || l_proc, 10);
1260: --
1261: -- Check if enrolled.
1262: --
1263: open c_chk_enrld;

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

1263: open c_chk_enrld;
1264: fetch c_chk_enrld into l_exists;
1265: if c_chk_enrld%found then
1266: l_enrld_or_cvrd := true;
1267: hr_utility.set_location('Enrolled', 10);
1268: else
1269: --
1270: -- Check if covered.
1271: --

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

1277: close c_chk_cvrd;
1278: end if;
1279: close c_chk_enrld;
1280: --
1281: hr_utility.set_location('Leaving : ' || l_proc, 10);
1282: return l_enrld_or_cvrd;
1283: --
1284: end chk_enrld_or_cvrd;
1285: -- ----------------------------------------------------------------------------

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

1343: group by pdp.dpnt_person_id;
1344: --
1345: begin
1346: --
1347: hr_utility.set_location('Entering : ' || l_proc, 10);
1348: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);
1349: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);
1350: hr_utility.set_location('p_person_id : ' || p_person_id, 10);
1351: --

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

1344: --
1345: begin
1346: --
1347: hr_utility.set_location('Entering : ' || l_proc, 10);
1348: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);
1349: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);
1350: hr_utility.set_location('p_person_id : ' || p_person_id, 10);
1351: --
1352: open c_get_enrt_cvg_thru_dt;

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

1345: begin
1346: --
1347: hr_utility.set_location('Entering : ' || l_proc, 10);
1348: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);
1349: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);
1350: hr_utility.set_location('p_person_id : ' || p_person_id, 10);
1351: --
1352: open c_get_enrt_cvg_thru_dt;
1353: fetch c_get_enrt_cvg_thru_dt into l_enrt_cvg_thru_dt;

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

1346: --
1347: hr_utility.set_location('Entering : ' || l_proc, 10);
1348: hr_utility.set_location('p_pgm_id : ' || p_pgm_id, 10);
1349: hr_utility.set_location('p_ptip_id : ' || p_ptip_id, 10);
1350: hr_utility.set_location('p_person_id : ' || p_person_id, 10);
1351: --
1352: open c_get_enrt_cvg_thru_dt;
1353: fetch c_get_enrt_cvg_thru_dt into l_enrt_cvg_thru_dt;
1354: close c_get_enrt_cvg_thru_dt;

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

1436: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
1437: --
1438: begin
1439: --
1440: hr_utility.set_location('Entering : ' || l_proc, 10);
1441: --
1442: l_arra_event := false;
1443: --
1444: -- Check for Stimulus life event.

Line 1450: hr_utility.set_location('arra event found : ' || l_proc, 10);

1446: open c_get_ler_info;
1447: fetch c_get_ler_info into l_ler_rec;
1448: if c_get_ler_info%found then
1449: close c_get_ler_info;
1450: hr_utility.set_location('arra event found : ' || l_proc, 10);
1451: --
1452: -- Check if the person was previously eligible for
1453: -- for COBRA.
1454: --

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

1544: end if;
1545: --
1546: elsif l_epe_rec.poe_lvl_cd = 'PTIP' then
1547: --
1548: hr_utility.set_location('poe_lvl_cd : ' || l_epe_rec.poe_lvl_cd, 10);
1549: hr_utility.set_location('l_ptip_id : ' || l_ptip_id, 10);
1550: hr_utility.set_location('l_epe_rec.ptip_id : ' || l_epe_rec.ptip_id, 10);
1551: --
1552: if nvl(l_ptip_id,-1) <> l_epe_rec.ptip_id then

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

1545: --
1546: elsif l_epe_rec.poe_lvl_cd = 'PTIP' then
1547: --
1548: hr_utility.set_location('poe_lvl_cd : ' || l_epe_rec.poe_lvl_cd, 10);
1549: hr_utility.set_location('l_ptip_id : ' || l_ptip_id, 10);
1550: hr_utility.set_location('l_epe_rec.ptip_id : ' || l_epe_rec.ptip_id, 10);
1551: --
1552: if nvl(l_ptip_id,-1) <> l_epe_rec.ptip_id then
1553: --

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

1546: elsif l_epe_rec.poe_lvl_cd = 'PTIP' then
1547: --
1548: hr_utility.set_location('poe_lvl_cd : ' || l_epe_rec.poe_lvl_cd, 10);
1549: hr_utility.set_location('l_ptip_id : ' || l_ptip_id, 10);
1550: hr_utility.set_location('l_epe_rec.ptip_id : ' || l_epe_rec.ptip_id, 10);
1551: --
1552: if nvl(l_ptip_id,-1) <> l_epe_rec.ptip_id then
1553: --
1554: -- Determine cobra eligibility start and end dates.

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

1619: end if;
1620: end loop;
1621: end if; -- l_arra_event
1622: --
1623: hr_utility.set_location('Leaving : ' || l_proc, 10);
1624: --
1625: end update_cobra_elig_info;
1626: --
1627: -- ----------------------------------------------------------------------------

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

1664: and ctr.business_group_id = p_business_group_id;
1665: --
1666: begin
1667: --
1668: hr_utility.set_location('Entering : ' || l_proc, 10);
1669: --
1670: l_effective_date := p_lf_evt_ocrd_dt - 1;
1671: --
1672: -- only applies to dependents of the covered employee.

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

1671: --
1672: -- only applies to dependents of the covered employee.
1673: --
1674: if p_mx_poe_apls_cd = 'ACDPNT' then
1675: hr_utility.set_location('ACDPNT : ' || l_proc, 10);
1676: --
1677: -- If qualified beneficiary exists,
1678: --
1679: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);

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

1675: hr_utility.set_location('ACDPNT : ' || l_proc, 10);
1676: --
1677: -- If qualified beneficiary exists,
1678: --
1679: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);
1680: hr_utility.set_location('p_cvrd_emp_person_id : ' || p_cvrd_emp_person_id, 10);
1681: hr_utility.set_location('p_quald_bnf_person_id : ' || p_quald_bnf_person_id, 10);
1682: if p_cbr_quald_bnf_id is not null then
1683: --

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

1676: --
1677: -- If qualified beneficiary exists,
1678: --
1679: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);
1680: hr_utility.set_location('p_cvrd_emp_person_id : ' || p_cvrd_emp_person_id, 10);
1681: hr_utility.set_location('p_quald_bnf_person_id : ' || p_quald_bnf_person_id, 10);
1682: if p_cbr_quald_bnf_id is not null then
1683: --
1684: -- Check if the person is a covered dependent.

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

1677: -- If qualified beneficiary exists,
1678: --
1679: hr_utility.set_location('p_cbr_quald_bnf_id : ' || p_cbr_quald_bnf_id, 10);
1680: hr_utility.set_location('p_cvrd_emp_person_id : ' || p_cvrd_emp_person_id, 10);
1681: hr_utility.set_location('p_quald_bnf_person_id : ' || p_quald_bnf_person_id, 10);
1682: if p_cbr_quald_bnf_id is not null then
1683: --
1684: -- Check if the person is a covered dependent.
1685: --

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

1737: else
1738: l_eligible := true;
1739: end if;
1740: --
1741: hr_utility.set_location('Leaving : ' || l_proc, 10);
1742: return l_eligible;
1743: end check_max_poe_eligibility;
1744: -- ----------------------------------------------------------------------------
1745: -- |-------------------------< update_dpnt_cobra_info >-----------------------------

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

1850: l_cvrd_emp_rec c_get_cvrd_emp_person_id%rowtype;
1851: --
1852: begin
1853: --
1854: hr_utility.set_location('Entering : ' || l_proc, 10);
1855: hr_utility.set_location('p_prtt_enrt_rslt_id : ' || p_prtt_enrt_rslt_id, 10);
1856: --
1857: -- Check for arra event
1858: --

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

1851: --
1852: begin
1853: --
1854: hr_utility.set_location('Entering : ' || l_proc, 10);
1855: hr_utility.set_location('p_prtt_enrt_rslt_id : ' || p_prtt_enrt_rslt_id, 10);
1856: --
1857: -- Check for arra event
1858: --
1859: l_arra_event := false;

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

1873: l_ptip_id := l_pen_rec.ptip_id;
1874: l_pgm_id := l_pen_rec.pgm_id;
1875: l_enrld_person_id := l_pen_rec.person_id;
1876: --
1877: hr_utility.set_location('pgm_id : ' || l_pen_rec.pgm_id, 10);
1878: hr_utility.set_location('ptip_id : ' || l_pen_rec.ptip_id, 10);
1879: --
1880: if chk_pgm_typ(p_pgm_id => l_pgm_id
1881: ,p_effective_date => p_effective_date

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

1874: l_pgm_id := l_pen_rec.pgm_id;
1875: l_enrld_person_id := l_pen_rec.person_id;
1876: --
1877: hr_utility.set_location('pgm_id : ' || l_pen_rec.pgm_id, 10);
1878: hr_utility.set_location('ptip_id : ' || l_pen_rec.ptip_id, 10);
1879: --
1880: if chk_pgm_typ(p_pgm_id => l_pgm_id
1881: ,p_effective_date => p_effective_date
1882: ,p_business_group_id => p_business_group_id

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

1880: if chk_pgm_typ(p_pgm_id => l_pgm_id
1881: ,p_effective_date => p_effective_date
1882: ,p_business_group_id => p_business_group_id
1883: ) = false then
1884: hr_utility.set_location('Leaving - Not found : ' || l_proc, 10);
1885: return;
1886: end if;
1887: --
1888: -- Get the life event occurred date.

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

1928: l_pl_typ_id := l_pen_rec.pl_typ_id;
1929: end if;
1930: --
1931: else
1932: hr_utility.set_location('Initial qualifying event', 10);
1933: l_quald_bnf_flag := 'Y';
1934: --
1935: -- Normally, a cobra qualified beneficiary row would exist
1936: -- if benmngle was run for the related life event. In the event

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

1960: ,p_dsbld_apls => l_dsbld_apls
1961: ,p_update => l_update
1962: );
1963: --
1964: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1965: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1966: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1967: l_cqb_ptip_id := null;
1968: l_pl_typ_id := null;

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

1961: ,p_update => l_update
1962: );
1963: --
1964: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1965: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1966: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1967: l_cqb_ptip_id := null;
1968: l_pl_typ_id := null;
1969: --

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

1962: );
1963: --
1964: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
1965: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
1966: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
1967: l_cqb_ptip_id := null;
1968: l_pl_typ_id := null;
1969: --
1970: elsif l_poe_lvl_cd = 'PTIP' then

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

2071: );
2072: end if;
2073: else -- quald bnf found.
2074: --
2075: hr_utility.set_location('Quald bnf exists', 10);
2076: --
2077: close c_get_cbr_quald_bnf;
2078: --
2079: if l_cqb_rec.quald_bnf_flag = 'Y' then

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

2084: open c_get_poe_lvl_cd;
2085: fetch c_get_poe_lvl_cd into l_poe_lvl_cd;
2086: close c_get_poe_lvl_cd;
2087: --
2088: hr_utility.set_location('POE LVL '||l_poe_lvl_cd, 10);
2089: if (l_poe_lvl_cd = 'PGM' or
2090: l_poe_lvl_cd is null) then
2091: --
2092: determine_cobra_elig_dates

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

2107: ,p_dsbld_apls => l_dsbld_apls
2108: ,p_update => l_update
2109: );
2110: --
2111: hr_utility.set_location('elig_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
2112: hr_utility.set_location('elig_end_dt '||l_cbr_elig_perd_end_dt, 10);
2113: hr_utility.set_location('old_elig_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
2114: l_cqb_ptip_id := null;
2115: l_pl_typ_id := null;

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

2108: ,p_update => l_update
2109: );
2110: --
2111: hr_utility.set_location('elig_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
2112: hr_utility.set_location('elig_end_dt '||l_cbr_elig_perd_end_dt, 10);
2113: hr_utility.set_location('old_elig_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
2114: l_cqb_ptip_id := null;
2115: l_pl_typ_id := null;
2116: --

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

2109: );
2110: --
2111: hr_utility.set_location('elig_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
2112: hr_utility.set_location('elig_end_dt '||l_cbr_elig_perd_end_dt, 10);
2113: hr_utility.set_location('old_elig_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
2114: l_cqb_ptip_id := null;
2115: l_pl_typ_id := null;
2116: --
2117: elsif l_poe_lvl_cd = 'PTIP' then

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

2137: ,p_cvrd_emp_person_id => l_cvrd_emp_person_id
2138: ,p_dsbld_apls => l_dsbld_apls
2139: ,p_update => l_update
2140: );
2141: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
2142: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
2143: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
2144: end if;
2145: --

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

2138: ,p_dsbld_apls => l_dsbld_apls
2139: ,p_update => l_update
2140: );
2141: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
2142: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
2143: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
2144: end if;
2145: --
2146: update_cobra_info

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

2139: ,p_update => l_update
2140: );
2141: hr_utility.set_location('l_cbr_elig_perd_strt_dt '||l_cbr_elig_perd_strt_dt, 10);
2142: hr_utility.set_location('l_cbr_elig_perd_end_dt '||l_cbr_elig_perd_end_dt, 10);
2143: hr_utility.set_location('l_old_cbr_elig_perd_end_dt '||l_old_cbr_elig_perd_end_dt, 10);
2144: end if;
2145: --
2146: update_cobra_info
2147: (p_per_in_ler_id => p_per_in_ler_id

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

2159: ,p_validate => p_validate
2160: );
2161: else -- if qual bnf flag = 'N'
2162: --
2163: hr_utility.set_location('quald_bnf_flag N', 10);
2164: --
2165: -- If it is the initial event, person is now a qualified beneficiary.
2166: --
2167: if (chk_init_evt(p_per_in_ler_id => p_per_in_ler_id

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

2259: end if; -- End check initial event.
2260: end if;
2261: end if;
2262: --
2263: hr_utility.set_location('Leaving : ' || l_proc, 10);
2264: end update_dpnt_cobra_info;
2265: -- ----------------------------------------------------------------------------
2266: -- |-------------------------< chk_cobra_eligibility >-------------------------
2267: -- ----------------------------------------------------------------------------

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

2338: l_crp_rec c_chk_init_evt%rowtype;
2339: --
2340: begin
2341: --
2342: hr_utility.set_location('Entering : ' || l_proc, 10);
2343: --
2344: -- Only update COBRA information if person is enrolling
2345: -- in a COBRA program.
2346: --

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

2347: if chk_pgm_typ(p_pgm_id => p_pgm_id
2348: ,p_effective_date => p_effective_date
2349: ,p_business_group_id => p_business_group_id
2350: ) = false then
2351: hr_utility.set_location('Leaving : ' || l_proc, 15);
2352: return;
2353: end if;
2354: --
2355: -- If it is the initial event, the Loss of Eligibility temporal

Line 2446: hr_utility.set_location('l_pdp_rec.dpnt_person_id : ' || l_pdp_rec.dpnt_person_id, 10);

2442: open c_get_ptnl_evt(l_pdp_rec.dpnt_person_id);
2443: fetch c_get_ptnl_evt into l_exists;
2444: if c_get_ptnl_evt%notfound then
2445: close c_get_ptnl_evt;
2446: hr_utility.set_location('l_pdp_rec.dpnt_person_id : ' || l_pdp_rec.dpnt_person_id, 10);
2447: --
2448: -- The maximum enrollment coverage end date is the
2449: -- cobra eligibility end date for the person.
2450: --

Line 2479: hr_utility.set_location('ptnl found ' , 10);

2475: ,p_validate => p_validate
2476: );
2477: end if;
2478: else
2479: hr_utility.set_location('ptnl found ' , 10);
2480: close c_get_ptnl_evt;
2481: end if; -- c_get_curr_evt. 14332963
2482: end if; -- end enrld in pgm or ptip.
2483: end loop;

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

2485: else
2486: close c_chk_init_evt;
2487: end if;
2488: --
2489: hr_utility.set_location('Leaving : ' || l_proc, 10);
2490: end chk_cobra_eligibility;
2491: -- ----------------------------------------------------------------------------
2492: -- |-------------------------< update_cobra_info >-----------------------------
2493: -- ----------------------------------------------------------------------------

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

2702: l_crp2_rec c_get_cvrd_emp_pil%rowtype;
2703: l_cqb_rec c_get_quald_bnf%rowtype;
2704: begin
2705: --
2706: hr_utility.set_location('Entering : ' || l_proc, 10);
2707: --
2708: l_cbr_elig_perd_end_dt := p_cbr_elig_perd_end_dt;
2709: --
2710: if p_cbr_quald_bnf_id is null then

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

2708: l_cbr_elig_perd_end_dt := p_cbr_elig_perd_end_dt;
2709: --
2710: if p_cbr_quald_bnf_id is null then
2711: --
2712: hr_utility.set_location('New Event : ' || l_proc, 10);
2713: --
2714: -- New qualifying event.
2715: --
2716: if p_cvrd_emp_person_id is null then

Line 2737: hr_utility.set_location('Covered Employee Not found : ' || l_proc, 10);

2733: -- 9690964 - arra Check if person has
2734: -- a qualified beneficiary row from the
2735: -- initial qualifying event.
2736: --
2737: hr_utility.set_location('Covered Employee Not found : ' || l_proc, 10);
2738: open c_get_quald_bnf;
2739: fetch c_get_quald_bnf into l_cqb_rec;
2740: if c_get_quald_bnf%found then
2741: l_cvrd_emp_person_id := l_cqb_rec.cvrd_emp_person_id;

Line 2761: hr_utility.set_location('Covered Employee : ' || l_cvrd_emp_person_id, 10);

2757: close c_chk_cvrd_emp;
2758: else
2759: l_cvrd_emp_person_id := p_cvrd_emp_person_id;
2760: end if;
2761: hr_utility.set_location('Covered Employee : ' || l_cvrd_emp_person_id, 10);
2762: --
2763: if p_quald_bnf_flag = 'Y' then
2764: if p_person_id <> l_cvrd_emp_person_id then
2765: --

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

2778: end if;
2779: --
2780: -- Write cobra qualified beneficiary row.
2781: --
2782: hr_utility.set_location('Inserting quald bnf: ' || l_proc, 10);
2783: hr_utility.set_location('l_cbr_elig_perd_end_dt: ' || l_cbr_elig_perd_end_dt, 10);
2784: --
2785: ben_cbr_quald_bnf_api.create_cbr_quald_bnf
2786: (p_validate => p_validate

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

2779: --
2780: -- Write cobra qualified beneficiary row.
2781: --
2782: hr_utility.set_location('Inserting quald bnf: ' || l_proc, 10);
2783: hr_utility.set_location('l_cbr_elig_perd_end_dt: ' || l_cbr_elig_perd_end_dt, 10);
2784: --
2785: ben_cbr_quald_bnf_api.create_cbr_quald_bnf
2786: (p_validate => p_validate
2787: ,p_cbr_quald_bnf_id => l_cbr_quald_bnf_id

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

2835: end if;
2836: --
2837: else -- If person is not a qualified beneficiary.
2838: --
2839: hr_utility.set_location('Not a qualified beneficiary: '||l_cvrd_emp_person_id, 10);
2840: --
2841: -- Create a COBRA per in ler id using the covered employee initial
2842: -- life events. This is needed since the form now has to check
2843: -- if the per_in_ler is backed out before it displays the qualified

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

2860: ,p_object_version_number => l_object_version_number
2861: ,p_effective_date => p_effective_date
2862: );
2863: else
2864: hr_utility.set_location('Did not find covered employee: '||l_cvrd_emp_person_id, 10);
2865: hr_utility.set_location('ptip_id : '||p_ptip_id, 10);
2866: hr_utility.set_location('pgm_id : '||p_pgm_id, 10);
2867: close c_get_cvrd_emp_pil;
2868: end if;

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

2861: ,p_effective_date => p_effective_date
2862: );
2863: else
2864: hr_utility.set_location('Did not find covered employee: '||l_cvrd_emp_person_id, 10);
2865: hr_utility.set_location('ptip_id : '||p_ptip_id, 10);
2866: hr_utility.set_location('pgm_id : '||p_pgm_id, 10);
2867: close c_get_cvrd_emp_pil;
2868: end if;
2869: --

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

2862: );
2863: else
2864: hr_utility.set_location('Did not find covered employee: '||l_cvrd_emp_person_id, 10);
2865: hr_utility.set_location('ptip_id : '||p_ptip_id, 10);
2866: hr_utility.set_location('pgm_id : '||p_pgm_id, 10);
2867: close c_get_cvrd_emp_pil;
2868: end if;
2869: --
2870: end if;

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

2910: end if;
2911: --
2912: l_object_version_number := p_cqb_object_version_number;
2913: --
2914: hr_utility.set_location('l_cbr_elig_perd_end_dt : '||l_cbr_elig_perd_end_dt, 10);
2915: hr_utility.set_location('p_old_cbr_elig_perd_end_dt : '||p_old_cbr_elig_perd_end_dt, 10);
2916: if l_cbr_elig_perd_end_dt is not null then
2917: --
2918: if p_old_cbr_elig_perd_end_dt <> l_cbr_elig_perd_end_dt then

Line 2915: hr_utility.set_location('p_old_cbr_elig_perd_end_dt : '||p_old_cbr_elig_perd_end_dt, 10);

2911: --
2912: l_object_version_number := p_cqb_object_version_number;
2913: --
2914: hr_utility.set_location('l_cbr_elig_perd_end_dt : '||l_cbr_elig_perd_end_dt, 10);
2915: hr_utility.set_location('p_old_cbr_elig_perd_end_dt : '||p_old_cbr_elig_perd_end_dt, 10);
2916: if l_cbr_elig_perd_end_dt is not null then
2917: --
2918: if p_old_cbr_elig_perd_end_dt <> l_cbr_elig_perd_end_dt then
2919: --

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

2916: if l_cbr_elig_perd_end_dt is not null then
2917: --
2918: if p_old_cbr_elig_perd_end_dt <> l_cbr_elig_perd_end_dt then
2919: --
2920: hr_utility.set_location('l_cbr_elig_perd_end_dt update: '||l_cbr_elig_perd_end_dt, 10);
2921: --
2922: --
2923: -- If the cobra eligibility start date is the start of time (01/01/0001), set the
2924: -- qualified beneficiary flag to 'N' instead of updating the eligiblity end date.

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

2942: ,p_effective_date => p_effective_date
2943: );
2944: --
2945: if p_dsbld_apls = true then
2946: hr_utility.set_location('Disabled: ' || l_cbr_elig_perd_end_dt, 10);
2947: for l_dpnt_rec in c_get_all_quald_dpnts loop
2948: if l_cbr_elig_perd_end_dt > l_dpnt_rec.cbr_elig_perd_end_dt
2949: then
2950: hr_utility.set_location('Dpnt dsbld : ' || l_cbr_elig_perd_end_dt, 10);

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

2946: hr_utility.set_location('Disabled: ' || l_cbr_elig_perd_end_dt, 10);
2947: for l_dpnt_rec in c_get_all_quald_dpnts loop
2948: if l_cbr_elig_perd_end_dt > l_dpnt_rec.cbr_elig_perd_end_dt
2949: then
2950: hr_utility.set_location('Dpnt dsbld : ' || l_cbr_elig_perd_end_dt, 10);
2951: --
2952: l_object_version_number := l_dpnt_rec.object_version_number;
2953: --
2954: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

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

2970: open c_get_cnt_num(l_dpnt_rec.cbr_quald_bnf_id);
2971: fetch c_get_cnt_num into l_cnt_num;
2972: close c_get_cnt_num;
2973: --
2974: hr_utility.set_location('l_cnt_num : ' || l_cnt_num, 10);
2975: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
2976: (p_validate => p_validate
2977: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
2978: ,p_init_evt_flag => 'N'

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

3015: open c_get_cnt_num(p_cbr_quald_bnf_id);
3016: fetch c_get_cnt_num into l_cnt_num;
3017: close c_get_cnt_num;
3018: --
3019: hr_utility.set_location('l_cnt_num : ' || l_cnt_num, 10);
3020: ben_cbr_per_in_ler_api.create_cbr_per_in_ler
3021: (p_validate => p_validate
3022: ,p_cbr_per_in_ler_id => l_cbr_per_in_ler_id
3023: ,p_init_evt_flag => 'N'

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

3038: --
3039: end if; -- end date is not null
3040: end if; -- qual_bnf flag = 'Y'
3041: end if;
3042: hr_utility.set_location('Leaving : ' || l_proc, 10);
3043: end update_cobra_info;
3044: -- ----------------------------------------------------------------------------
3045: -- |-------------------------< end_prtt_cobra_eligibility >-------------------------
3046: -- ----------------------------------------------------------------------------

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

3155: --
3156: begin
3157: g_cobra_enrollment_change := FALSE;
3158: --
3159: hr_utility.set_location('Entering : ' || l_proc, 10);
3160: --
3161: -- Get life event occurred date.
3162: --
3163: l_lf_evt_ocrd_dt := get_lf_evt_ocrd_dt

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

3170: for l_cqb_rec in c_get_cbr_quald_bnf loop
3171: l_cbr_quald_bnf_id := l_cqb_rec.cbr_quald_bnf_id;
3172: l_cqb_object_version_number := l_cqb_rec.object_version_number;
3173: l_cqb_quald_bnf_flag := l_cqb_rec.quald_bnf_flag;
3174: hr_utility.set_location('l_effective_date: ' || l_effective_date, 10);
3175: hr_utility.set_location('cqb_ptip_id: ' || l_cqb_rec.ptip_id, 10);
3176: hr_utility.set_location('cqb_pgm_id: ' || l_cqb_rec.pgm_id, 10);
3177: --
3178: -- If life event occurred date + 1 = to the cobra eligibility

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

3171: l_cbr_quald_bnf_id := l_cqb_rec.cbr_quald_bnf_id;
3172: l_cqb_object_version_number := l_cqb_rec.object_version_number;
3173: l_cqb_quald_bnf_flag := l_cqb_rec.quald_bnf_flag;
3174: hr_utility.set_location('l_effective_date: ' || l_effective_date, 10);
3175: hr_utility.set_location('cqb_ptip_id: ' || l_cqb_rec.ptip_id, 10);
3176: hr_utility.set_location('cqb_pgm_id: ' || l_cqb_rec.pgm_id, 10);
3177: --
3178: -- If life event occurred date + 1 = to the cobra eligibility
3179: -- end date, we are processing a loss of eligibility event

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

3172: l_cqb_object_version_number := l_cqb_rec.object_version_number;
3173: l_cqb_quald_bnf_flag := l_cqb_rec.quald_bnf_flag;
3174: hr_utility.set_location('l_effective_date: ' || l_effective_date, 10);
3175: hr_utility.set_location('cqb_ptip_id: ' || l_cqb_rec.ptip_id, 10);
3176: hr_utility.set_location('cqb_pgm_id: ' || l_cqb_rec.pgm_id, 10);
3177: --
3178: -- If life event occurred date + 1 = to the cobra eligibility
3179: -- end date, we are processing a loss of eligibility event
3180: -- or the max period of enrollment is reached so the COBRA

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

3192: ,p_ptip_id => l_cqb_rec.ptip_id
3193: ,p_person_id => p_person_id
3194: ,p_effective_date => p_effective_date
3195: ,p_business_group_id => p_business_group_id)) = false then
3196: hr_utility.set_location('Not enrolled: ', 10);
3197: --
3198: -- if person is not enroll then check if the person has no electable choices
3199: -- a COBRA program.
3200: --

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

3204: fetch c_chk_elctbl_chc into l_exists;
3205: if c_chk_elctbl_chc%notfound then
3206: close c_chk_elctbl_chc;
3207: --
3208: hr_utility.set_location('No choices found: ', 10);
3209: --
3210: l_cbr_elig_perd_end_dt := get_max_cvg_thru_dt
3211: (p_person_id => p_person_id
3212: ,p_lf_evt_ocrd_dt => l_effective_date

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

3215: ,p_per_in_ler_id => p_per_in_ler_id
3216: ,p_effective_date => p_effective_date
3217: ,p_business_group_id => p_business_group_id
3218: );
3219: hr_utility.set_location('l_cbr_elig_perd_end_dt : ' || l_cbr_elig_perd_end_dt, 10);
3220:
3221: --
3222: -- Write a cobra per_in_ler row for the person if the cobra eligibility
3223: -- period end date is not equal to the cobra eligibility end date

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

3242: l_cbr_inelg_rsn_cd := 'PLE';
3243: else
3244: l_cbr_inelg_rsn_cd := hr_api.g_varchar2;
3245: end if;
3246: hr_utility.set_location('l_ler_typ: '||l_typ_cd, 10);
3247: end if;
3248: close c_get_ler_type;
3249: --
3250: end_cobra_eligibility

Line 3265: hr_utility.set_location('l_pdp_rec: '||l_pdp_rec.dpnt_person_id, 10);

3261: --
3262: -- Bug 12386329. End cobra eligibility for covered dependents.
3263: --
3264: for l_pdp_rec in c_get_cvrd_dpnt loop
3265: hr_utility.set_location('l_pdp_rec: '||l_pdp_rec.dpnt_person_id, 10);
3266: --
3267: -- Get the cobra qualified beneficiary row for the dependent
3268: --
3269: for l_dpnt_cqb_rec in c_get_dpnt_cbr_quald_bnf(l_pdp_rec.dpnt_person_id) loop

Line 3270: hr_utility.set_location('l_cqb: '||l_dpnt_cqb_rec.quald_bnf_person_id, 10);

3266: --
3267: -- Get the cobra qualified beneficiary row for the dependent
3268: --
3269: for l_dpnt_cqb_rec in c_get_dpnt_cbr_quald_bnf(l_pdp_rec.dpnt_person_id) loop
3270: hr_utility.set_location('l_cqb: '||l_dpnt_cqb_rec.quald_bnf_person_id, 10);
3271: --
3272: -- If person is no longer enrolled or covered in the COBRA program
3273: -- or plan type in program,then set the cobra eligibility end date
3274: -- to the maximum coverage end date of the enrollment results.

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

3316: -- end 12386329
3317: end if;
3318: --
3319: else
3320: hr_utility.set_location('Choices found: ', 10);
3321: close c_chk_elctbl_chc;
3322: end if;
3323: end if;
3324: end loop;

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

3322: end if;
3323: end if;
3324: end loop;
3325: --
3326: hr_utility.set_location('Leaving : ' || l_proc, 10);
3327: end end_prtt_cobra_eligibility;
3328: --
3329: -- ----------------------------------------------------------------------------
3330: -- |-------------------------< end_cobra_eligibility >-------------------------

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

3368: and crp.per_in_ler_id = p_per_in_ler_id;
3369: --
3370: begin
3371: --
3372: hr_utility.set_location('Entering : ' || l_proc, 10);
3373: --
3374: -- If cobra per in ler exists, update the row.
3375: --
3376: open c_chk_cbr_per_in_ler;

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

3402: end if;
3403: --
3404: l_cqb_object_version_number := p_cqb_object_version_number;
3405: --
3406: hr_utility.set_location('p_cbr_elig_perd_end_dt'||p_cbr_elig_perd_end_dt, 20);
3407: hr_utility.set_location('p_quald_bnf_flag'||p_quald_bnf_flag, 30);
3408: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
3409: (p_validate => p_validate
3410: ,p_cbr_quald_bnf_id => p_cbr_quald_bnf_id

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

3403: --
3404: l_cqb_object_version_number := p_cqb_object_version_number;
3405: --
3406: hr_utility.set_location('p_cbr_elig_perd_end_dt'||p_cbr_elig_perd_end_dt, 20);
3407: hr_utility.set_location('p_quald_bnf_flag'||p_quald_bnf_flag, 30);
3408: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
3409: (p_validate => p_validate
3410: ,p_cbr_quald_bnf_id => p_cbr_quald_bnf_id
3411: ,p_quald_bnf_flag => p_quald_bnf_flag

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

3415: ,p_object_version_number => l_cqb_object_version_number
3416: ,p_effective_date => p_effective_date
3417: );
3418: --
3419: hr_utility.set_location('Leaving : ' || l_proc, 10);
3420: end end_cobra_eligibility;
3421: --
3422: --
3423: -- ----------------------------------------------------------------------------

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

3477:
3478: l_proc varchar2(80) := g_package||'.compute_period_rate';
3479: begin
3480:
3481: hr_utility.set_location('Entering : ' || l_proc, 10);
3482:
3483: l_balance := p_ann_rt_val - p_rate_ytd;
3484:
3485: l_notional_months := MONTHS_BETWEEN(LAST_DAY(p_plan_year_end_dt),

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

3499: l_first_pp_adjustment:= l_balance - (l_per_month_amt * l_notional_months);
3500:
3501: l_return_amt := l_first_pp_adjustment + (l_months_remaining * l_per_month_amt);
3502:
3503: hr_utility.set_location('l_return_amt'|| l_return_amt, 10);
3504: hr_utility.set_location('Leaving : ' || l_proc, 10);
3505:
3506: return l_return_amt;
3507:

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

3500:
3501: l_return_amt := l_first_pp_adjustment + (l_months_remaining * l_per_month_amt);
3502:
3503: hr_utility.set_location('l_return_amt'|| l_return_amt, 10);
3504: hr_utility.set_location('Leaving : ' || l_proc, 10);
3505:
3506: return l_return_amt;
3507:
3508: end compute_period_rate;

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

3668: l_rate_ytd number;
3669: l_proc varchar2(80) := g_package||'.get_amount_due';
3670: begin
3671:
3672: hr_utility.set_location('Entering : ' || l_proc, 10);
3673:
3674: open c_current_result_info(c_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id);
3675: fetch c_current_result_info into l_result_rec;
3676: close c_current_result_info;

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

3707:
3708: l_months_remaining := MONTHS_BETWEEN(LAST_DAY(l_plan_year_end_dt)
3709: ,ADD_MONTHS(LAST_DAY(p_rt_strt_dt),-1));
3710:
3711: hr_utility.set_location('l_months_remaining ' || l_months_remaining, 10);
3712:
3713: if l_get_abr_info.entr_ann_val_flag='Y' or
3714: l_prnt_ann_rt = 'Y' or
3715: l_mlt_cd = 'SAREC' then

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

3741: ,p_rndg_cd => l_get_abr_info.rndg_cd
3742: ,p_rndg_rl => l_get_abr_info.rndg_rl
3743: ,p_plan_year_end_dt => l_plan_year_end_dt);
3744:
3745: hr_utility.set_location('l_rate_ytd '|| l_rate_ytd, 10);
3746:
3747: l_rt_strt_dt := r_rates.rt_strt_dt;
3748: l_rt_end_dt := r_rates.rt_end_dt;
3749: l_ann_rt_val := r_rates.ann_rt_val;

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

3762: ,p_rndg_cd => l_get_abr_info.rndg_cd
3763: ,p_rndg_rl => l_get_abr_info.rndg_rl
3764: ,p_plan_year_end_dt => l_plan_year_end_dt);
3765:
3766: hr_utility.set_location('l_rate_ytd '|| l_rate_ytd, 20);
3767: end if;
3768:
3769: l_balance := p_ann_rt_val - l_rate_ytd;
3770:

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

3890: p_per_month_amt := l_per_month_amt;
3891: p_first_month_amt := l_prorated_first_mth_amt;
3892: p_last_month_amt := l_prorated_last_mth_amt;
3893:
3894: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);
3895: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);
3896: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);
3897:
3898: hr_utility.set_location('Leaving : ' || l_proc, 10);

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

3891: p_first_month_amt := l_prorated_first_mth_amt;
3892: p_last_month_amt := l_prorated_last_mth_amt;
3893:
3894: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);
3895: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);
3896: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);
3897:
3898: hr_utility.set_location('Leaving : ' || l_proc, 10);
3899:

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

3892: p_last_month_amt := l_prorated_last_mth_amt;
3893:
3894: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);
3895: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);
3896: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);
3897:
3898: hr_utility.set_location('Leaving : ' || l_proc, 10);
3899:
3900: end get_amount_due;

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

3894: hr_utility.set_location('p_per_month_amt ' || p_per_month_amt, 10);
3895: hr_utility.set_location('p_first_month_amt ' || p_first_month_amt, 10);
3896: hr_utility.set_location('p_last_month_amt ' || p_last_month_amt, 10);
3897:
3898: hr_utility.set_location('Leaving : ' || l_proc, 10);
3899:
3900: end get_amount_due;
3901: --
3902: procedure get_due_and_payment_amt(p_person_id in number

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

3963: l_proc varchar2(80) := g_package||'.get_due_and_payment_amt';
3964:
3965: begin
3966:
3967: hr_utility.set_location('Entering : ' || l_proc, 10);
3968:
3969: ben_element_entry.get_abr_assignment
3970: (p_person_id => p_person_id
3971: ,p_effective_date => p_effective_date

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

4017: -- Set Out variables
4018: p_amt_due := l_amt_due;
4019: p_prev_pymts := l_prev_pymts;
4020:
4021: hr_utility.set_location('Leaving : ' || l_proc, 10);
4022:
4023: end get_due_and_payment_amt;
4024: --
4025: function get_comp_object_name(p_pl_id in number

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

4177: l_proc varchar2(80) := g_package||'.get_unpaid_rate';
4178:
4179: begin
4180:
4181: hr_utility.set_location('Entering : ' || l_proc, 10);
4182:
4183: open c_rates(c_person_id => p_person_id
4184: ,c_pgm_id => p_pgm_id
4185: ,c_pl_typ_id => p_pl_typ_id

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

4315: -- Set Out variables
4316: p_rt_strt_dt := l_rt_strt_dt;
4317: p_elm_chg_warning := l_warning;
4318:
4319: hr_utility.set_location('p_rt_strt_dt ' ||p_rt_strt_dt, 10);
4320: hr_utility.set_location('Leaving : ' || l_proc, 10);
4321: end get_unpaid_rate;
4322: --
4323: -- ----------------------------------------------------------------------------

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

4316: p_rt_strt_dt := l_rt_strt_dt;
4317: p_elm_chg_warning := l_warning;
4318:
4319: hr_utility.set_location('p_rt_strt_dt ' ||p_rt_strt_dt, 10);
4320: hr_utility.set_location('Leaving : ' || l_proc, 10);
4321: end get_unpaid_rate;
4322: --
4323: -- ----------------------------------------------------------------------------
4324: -- |-------------------------< get_costing_details >---------------------------

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

4739:
4740: l_proc varchar2(80) := g_package||'.allocate_payment';
4741: begin
4742:
4743: hr_utility.set_location('Entering : ' || l_proc, 10);
4744:
4745: l_amount_paid_bal := ABS(p_amount_paid);
4746:
4747: open c_pen(p_prtt_enrt_rslt_id,p_effective_date,p_acty_base_rt_id);

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

5188: elsif p_amount_paid < 0 then
5189: p_excess_amount := - l_amount_paid_bal;
5190: end if;
5191:
5192: hr_utility.set_location('Leaving : ' || l_proc, 10);
5193: end allocate_payment;
5194:
5195: END ben_cobra_requirements;