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

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

298: l_effective_date date;
299: --
300: begin
301: --
302: hr_utility.set_location ('Entering '|| l_proc|| p_effective_date,10);
303: --
304: l_effective_date := p_effective_date;
305: --
306: open c_pel_pgm_id;

Line 313: hr_utility.set_location('PGM'|| l_pel_pgm_id.pgm_id,24);

309: exit when c_pel_pgm_id%NOTFOUND;
310: --
311: if l_pel_pgm_id.pgm_id is not null then
312: --
313: hr_utility.set_location('PGM'|| l_pel_pgm_id.pgm_id,24);
314: --
315: open c_pep_pgm_defer(l_pel_pgm_id.pgm_id);
316: loop
317: fetch c_pep_pgm_defer into l_pep_pgm_defer;

Line 322: hr_utility.set_location ('PEN'|| l_pep_pgm_defer.prtt_enrt_rslt_id,46000);

318: exit when c_pep_pgm_defer%NOTFOUND;
319: --
320: if c_pep_pgm_defer%found then
321: --
322: hr_utility.set_location ('PEN'|| l_pep_pgm_defer.prtt_enrt_rslt_id,46000);
323: --
324: if l_effective_date <= l_pep_pgm_defer.effective_start_date then
325: l_effective_date := l_pep_pgm_defer.effective_start_date + 1;
326: --

Line 353: hr_utility.set_location ('EPO PEN '|| l_epo_plip_defer.prtt_enrt_rslt_id||'DATE'||l_effective_date,10007);

349: loop
350: fetch c_epo_plip_defer into l_epo_plip_defer;
351: exit when c_epo_plip_defer%NOTFOUND;
352: --
353: hr_utility.set_location ('EPO PEN '|| l_epo_plip_defer.prtt_enrt_rslt_id||'DATE'||l_effective_date,10007);
354: --
355: if c_epo_plip_defer%found then
356: --
357: if l_effective_date <= l_epo_plip_defer.effective_start_date then

Line 399: hr_utility.set_location ('PEN'|| l_pep_pl_defer.prtt_enrt_rslt_id,46000);

395: exit when c_pep_pl_defer%NOTFOUND;
396: --
397: if c_pep_pl_defer%found then
398: --
399: hr_utility.set_location ('PEN'|| l_pep_pl_defer.prtt_enrt_rslt_id,46000);
400: --
401: if l_effective_date <= l_pep_pl_defer.effective_start_date then
402: l_effective_date := l_pep_pl_defer.effective_start_date + 1;
403: --

Line 430: hr_utility.set_location ('EPO PEN '|| l_epo_plip_defer.prtt_enrt_rslt_id,10007);

426: loop
427: fetch c_epo_plnip_defer into l_epo_plnip_defer;
428: exit when c_epo_plnip_defer%NOTFOUND;
429: --
430: hr_utility.set_location ('EPO PEN '|| l_epo_plip_defer.prtt_enrt_rslt_id,10007);
431: --
432: if l_effective_date <= l_epo_plnip_defer.effective_start_date then
433: l_effective_date := l_epo_plnip_defer.effective_start_date + 1;
434: --

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

465: end loop;
466: --
467: close c_pel_pgm_id;
468: --
469: hr_utility.set_location ('Leaving'||l_proc,10);
470: --
471: end defer_delete_enrollment;
472: --
473: --

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

773:
774: --
775: begin
776: --
777: hr_utility.set_location ('Entering '||l_proc,10);
778: hr_utility.set_location ('p_ler_id '||p_ler_id,10);
779: hr_utility.set_location ('p_pgm_id '||p_pgm_id,10);
780: hr_utility.set_location ('p_pl_id '||p_pl_id,10);
781: hr_utility.set_location ('p_oipl_id '||p_oipl_id,10);

Line 778: hr_utility.set_location ('p_ler_id '||p_ler_id,10);

774: --
775: begin
776: --
777: hr_utility.set_location ('Entering '||l_proc,10);
778: hr_utility.set_location ('p_ler_id '||p_ler_id,10);
779: hr_utility.set_location ('p_pgm_id '||p_pgm_id,10);
780: hr_utility.set_location ('p_pl_id '||p_pl_id,10);
781: hr_utility.set_location ('p_oipl_id '||p_oipl_id,10);
782: --

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

775: begin
776: --
777: hr_utility.set_location ('Entering '||l_proc,10);
778: hr_utility.set_location ('p_ler_id '||p_ler_id,10);
779: hr_utility.set_location ('p_pgm_id '||p_pgm_id,10);
780: hr_utility.set_location ('p_pl_id '||p_pl_id,10);
781: hr_utility.set_location ('p_oipl_id '||p_oipl_id,10);
782: --
783: -- Bug 5642702

Line 780: hr_utility.set_location ('p_pl_id '||p_pl_id,10);

776: --
777: hr_utility.set_location ('Entering '||l_proc,10);
778: hr_utility.set_location ('p_ler_id '||p_ler_id,10);
779: hr_utility.set_location ('p_pgm_id '||p_pgm_id,10);
780: hr_utility.set_location ('p_pl_id '||p_pl_id,10);
781: hr_utility.set_location ('p_oipl_id '||p_oipl_id,10);
782: --
783: -- Bug 5642702
784: -- If person is de-enroling at Program level then set variable G_DENROLING_FROM_PGM

Line 781: hr_utility.set_location ('p_oipl_id '||p_oipl_id,10);

777: hr_utility.set_location ('Entering '||l_proc,10);
778: hr_utility.set_location ('p_ler_id '||p_ler_id,10);
779: hr_utility.set_location ('p_pgm_id '||p_pgm_id,10);
780: hr_utility.set_location ('p_pl_id '||p_pl_id,10);
781: hr_utility.set_location ('p_oipl_id '||p_oipl_id,10);
782: --
783: -- Bug 5642702
784: -- If person is de-enroling at Program level then set variable G_DENROLING_FROM_PGM
785: -- so that we can obviate calls that create/update records in BEN_BNFT_PRVDD_LDGR_F table

Line 799: hr_utility.set_location ('g_denroling_from_pgm = ' || g_denroling_from_pgm, 15);

795: g_denroling_from_pgm := 'N';
796: --
797: end if;
798: --
799: hr_utility.set_location ('g_denroling_from_pgm = ' || g_denroling_from_pgm, 15);
800: --
801: --
802: -- Bug#3279350 - undelete the prtt_enrt_rslt deenrolled in the future for OSB
803: -- Bug# 3507652 - Added "p_ler_id = ben_manage_life_events.g_ler_id" to delete future end-dated enrollments

Line 807: hr_utility.set_location ('undelete prtt_enrt_rslts',10);

803: -- Bug# 3507652 - Added "p_ler_id = ben_manage_life_events.g_ler_id" to delete future end-dated enrollments
804: -- when running in 'Unrestricted Mode' as well.
805: if ((p_ler_id is null) or (p_ler_id = ben_manage_life_events.g_ler_id)) then
806: --
807: hr_utility.set_location ('undelete prtt_enrt_rslts',10);
808: if p_oipl_id is not null then
809: for l_pen in c_pen_oipl_2 loop
810: -- call undelete
811: open c_pen_max_esd(l_pen.prtt_enrt_rslt_id);

Line 888: hr_utility.set_location('l_typ_cd ='||l_typ_cd,10.5);

884: (p_person_id => p_person_id,
885: p_business_group_id => p_business_group_id,
886: p_ler_id => p_ler_id,
887: p_effective_date => p_effective_date);
888: hr_utility.set_location('l_typ_cd ='||l_typ_cd,10.5);
889: --
890: end if;
891: --
892: hr_utility.set_location('l_per_in_ler_id '||l_per_in_ler_id,10);

Line 892: hr_utility.set_location('l_per_in_ler_id '||l_per_in_ler_id,10);

888: hr_utility.set_location('l_typ_cd ='||l_typ_cd,10.5);
889: --
890: end if;
891: --
892: hr_utility.set_location('l_per_in_ler_id '||l_per_in_ler_id,10);
893: --
894: end if;
895: --
896: open c_per_in_ler;

Line 899: hr_utility.set_location('l_typ_cd ='||l_typ_cd,11.5);

895: --
896: open c_per_in_ler;
897: fetch c_per_in_ler into l_lf_evt_ocrd_dt, l_typ_cd;
898: close c_per_in_ler;
899: hr_utility.set_location('l_typ_cd ='||l_typ_cd,11.5);
900: -- Get enrt_perd_id from benmngle's parm list, if it exists.
901: -- Enrt_perd_id is in benmngle's popl_enrt_typ_cycl_id field.
902: ben_env_object.get(p_rec => l_env_rec);
903: benutils.get_batch_parameters(p_benefit_action_id => l_env_rec.benefit_action_id

Line 913: hr_utility.set_location('l_per_in_ler_id '||l_per_in_ler_id,11);

909: if l_benmngle_parm_rec.lf_evt_ocrd_dt is not null then
910:
911: /* l_param_lf_evt_ocrd_dt :=
912: to_date(l_benmngle_parm_rec.lf_evt_ocrd_dt,'YYYY/MM/DD HH24:MI:SS');
913: hr_utility.set_location('l_per_in_ler_id '||l_per_in_ler_id,11);
914: l_param_lf_evt_ocrd_dt :=
915: to_date(to_char(trunc(l_param_lf_evt_ocrd_dt),'DD/MM/RRRR'),'DD/MM/RRRR');
916: l_param_lf_evt_ocrd_dt := to_date(l_benmngle_parm_rec.lf_evt_ocrd_dt);
917: */

Line 925: hr_utility.set_location('l_per_in_ler_id '||l_per_in_ler_id,12);

921:
922:
923: end if;
924: --
925: hr_utility.set_location('l_per_in_ler_id '||l_per_in_ler_id,12);
926: if p_oipl_id is not null then
927: -- PB : 5422 :
928: -- if l_benmngle_parm_rec.popl_enrt_typ_cycl_id is null then
929: if l_param_lf_evt_ocrd_dt is null then

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

975: --
976: l_effective_date := least(nvl(l_lf_evt_ocrd_dt,p_effective_date), nvl(l_ENRT_PERD_STRT_DT,p_effective_date));-- 5257226 - 1;
977: -- Enrollments were getting end-dated 2 days prior if passed eff_dt-1, passing the eff_dt now.
978:
979: hr_utility.set_location('l_effective_date '||l_effective_date,10);
980: else
981: --
982:
983: -- PB : 5422 :

Line 1117: hr_utility.set_location('Effective Date'||l_effective_date,111);

1113: end loop;
1114: --
1115: end if;
1116: -- Bug 2200139 for Override Case look at the pen esd also
1117: hr_utility.set_location('Effective Date'||l_effective_date,111);
1118: hr_utility.set_location('l_typ_cd ='||l_typ_cd,111);
1119: if l_pen.enrt_mthd_cd = 'O' then
1120: l_effective_date := greatest(l_effective_date,
1121: greatest(l_procd_dt,l_pen.effective_start_date + 1));

Line 1118: hr_utility.set_location('l_typ_cd ='||l_typ_cd,111);

1114: --
1115: end if;
1116: -- Bug 2200139 for Override Case look at the pen esd also
1117: hr_utility.set_location('Effective Date'||l_effective_date,111);
1118: hr_utility.set_location('l_typ_cd ='||l_typ_cd,111);
1119: if l_pen.enrt_mthd_cd = 'O' then
1120: l_effective_date := greatest(l_effective_date,
1121: greatest(l_procd_dt,l_pen.effective_start_date + 1));
1122: else

Line 1129: hr_utility.set_location('l_typ_cd ='||l_typ_cd,123);

1125: -- if benmngle is in selection mode, no need to compute the effective date
1126: if l_benmngle_parm_rec.mode_cd = 'S' or l_benmngle_parm_rec.mode_cd = 'U' or
1127: l_typ_cd = 'ABS' or l_typ_cd = 'GSP' or
1128: l_effective_date < l_pen.enrt_cvg_strt_dt then
1129: hr_utility.set_location('l_typ_cd ='||l_typ_cd,123);
1130: l_effective_date := p_effective_date;
1131: end if;
1132: -- Bug#2641545 - not to lose the per in ler of enrollment the result record should be
1133: -- datetrack updated with per in ler of ineligible life event

Line 1141: hr_utility.set_location('Effective Date'||l_effective_date,111);

1137: elsif l_effective_date < l_pen.effective_start_date then
1138: l_effective_date := l_pen.effective_start_date;
1139: end if;
1140:
1141: hr_utility.set_location('Effective Date'||l_effective_date,111);
1142: --
1143: ben_provider_pools.recompute_flex_credits(
1144: p_prtt_enrt_rslt_id => l_pen.prtt_enrt_rslt_id,
1145: p_pgm_id => l_pen.pgm_id,

Line 1152: hr_utility.set_location(' BKKKK DELETING THE FUTURE CVG OIPL ',10);

1148: p_enrt_mthd_cd => 'E',
1149: p_business_group_id => p_business_group_id,
1150: p_effective_date => l_effective_date);
1151: --
1152: hr_utility.set_location(' BKKKK DELETING THE FUTURE CVG OIPL ',10);
1153:
1154: --
1155: /*
1156: if (l_per_in_ler_id IS NOT NULL) then

Line 1298: hr_utility.set_location('Beninelg: cvg_end_dt_cd='||l_enrt_cvg_end_dt_cd,1067);

1294: p_lf_evt_ocrd_dt => null,
1295: p_lee_rsn_id => l_lee_rsn_id
1296: );
1297: --
1298: hr_utility.set_location('Beninelg: cvg_end_dt_cd='||l_enrt_cvg_end_dt_cd,1067);
1299: if substr(nvl(l_enrt_cvg_end_dt_cd, '-1'), 1, 1) = 'W' then
1300: --
1301: l_ovn := l_pen.object_version_number;
1302: --

Line 1303: hr_utility.set_location('Before updating enrt result ',10);

1299: if substr(nvl(l_enrt_cvg_end_dt_cd, '-1'), 1, 1) = 'W' then
1300: --
1301: l_ovn := l_pen.object_version_number;
1302: --
1303: hr_utility.set_location('Before updating enrt result ',10);
1304: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1305: --
1306: dt_api.find_dt_upd_modes
1307: (p_effective_date => p_effective_date,

Line 1304: hr_utility.set_location('p_effective_date '||p_effective_date,10);

1300: --
1301: l_ovn := l_pen.object_version_number;
1302: --
1303: hr_utility.set_location('Before updating enrt result ',10);
1304: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1305: --
1306: dt_api.find_dt_upd_modes
1307: (p_effective_date => p_effective_date,
1308: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',

Line 1402: hr_utility.set_location('Effective Date'||l_effective_date,112);

1398: p_enrt_mthd_cd => 'E',
1399: p_business_group_id => p_business_group_id,
1400: p_effective_date => l_effective_date);
1401: --
1402: hr_utility.set_location('Effective Date'||l_effective_date,112);
1403: hr_utility.set_location(' BKKKK DELETING THE FUTURE CVG PLN ',10);
1404: --
1405: /*
1406: if (l_per_in_ler_id IS NOT NULL) then

Line 1403: hr_utility.set_location(' BKKKK DELETING THE FUTURE CVG PLN ',10);

1399: p_business_group_id => p_business_group_id,
1400: p_effective_date => l_effective_date);
1401: --
1402: hr_utility.set_location('Effective Date'||l_effective_date,112);
1403: hr_utility.set_location(' BKKKK DELETING THE FUTURE CVG PLN ',10);
1404: --
1405: /*
1406: if (l_per_in_ler_id IS NOT NULL) then
1407: ben_election_information.backout_future_coverage

Line 1440: hr_utility.set_location('l_pen.pgm_id: '||l_pen.pgm_id,10);

1436: ben_prtt_enrt_result_api.g_enrollment_change := TRUE;
1437: --
1438: -- Check if we should terminate COBRA eligibility.
1439: --
1440: hr_utility.set_location('l_pen.pgm_id: '||l_pen.pgm_id,10);
1441: hr_utility.set_location('l_pen.ptip_id: '||l_pen.ptip_id,10);
1442: --
1443: if l_pen.pgm_id is not null
1444: then

Line 1441: hr_utility.set_location('l_pen.ptip_id: '||l_pen.ptip_id,10);

1437: --
1438: -- Check if we should terminate COBRA eligibility.
1439: --
1440: hr_utility.set_location('l_pen.pgm_id: '||l_pen.pgm_id,10);
1441: hr_utility.set_location('l_pen.ptip_id: '||l_pen.ptip_id,10);
1442: --
1443: if l_pen.pgm_id is not null
1444: then
1445: ben_comp_object.get_object(p_pgm_id => l_pen.pgm_id,

Line 1447: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);

1443: if l_pen.pgm_id is not null
1444: then
1445: ben_comp_object.get_object(p_pgm_id => l_pen.pgm_id,
1446: p_rec => l_pgm_rec);
1447: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);
1448: if l_pgm_rec.pgm_typ_cd like 'COBRA%' then
1449: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);
1450: ben_cobra_requirements.g_cobra_enrollment_change := TRUE;
1451: end if;

Line 1449: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);

1445: ben_comp_object.get_object(p_pgm_id => l_pen.pgm_id,
1446: p_rec => l_pgm_rec);
1447: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);
1448: if l_pgm_rec.pgm_typ_cd like 'COBRA%' then
1449: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);
1450: ben_cobra_requirements.g_cobra_enrollment_change := TRUE;
1451: end if;
1452: end if;
1453: --

Line 1604: hr_utility.set_location('Before updating enrt result ',10);

1600: p_lf_evt_ocrd_dt => null,
1601: p_lee_rsn_id => l_lee_rsn_id
1602: );
1603: --
1604: hr_utility.set_location('Before updating enrt result ',10);
1605: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1606: --
1607: if substr(nvl(l_enrt_cvg_end_dt_cd, '-1'), 1, 1) = 'W' then
1608: --

Line 1605: hr_utility.set_location('p_effective_date '||p_effective_date,10);

1601: p_lee_rsn_id => l_lee_rsn_id
1602: );
1603: --
1604: hr_utility.set_location('Before updating enrt result ',10);
1605: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1606: --
1607: if substr(nvl(l_enrt_cvg_end_dt_cd, '-1'), 1, 1) = 'W' then
1608: --
1609: l_ovn := l_pen.object_version_number;

Line 1635: hr_utility.set_location('pen_id='||l_pen.prtt_enrt_rslt_id,1963);

1631: l_datetrack_mode := hr_api.g_correction;
1632: --
1633: end if;
1634: --
1635: hr_utility.set_location('pen_id='||l_pen.prtt_enrt_rslt_id,1963);
1636: ben_prtt_enrt_result_api.update_PRTT_ENRT_RESULT
1637: (p_validate => false
1638: ,p_prtt_enrt_rslt_id => l_pen.prtt_enrt_rslt_id
1639: ,p_effective_start_date => l_eff_strt

Line 1695: hr_utility.set_location('Effective Date'||l_effective_date,113);

1691: end if;
1692: */
1693:
1694:
1695: hr_utility.set_location('Effective Date'||l_effective_date,113);
1696: --
1697: hr_utility.set_location(' BKKKK DELETING THE FUTURE CVG PGM ',10);
1698: --
1699: /*

Line 1697: hr_utility.set_location(' BKKKK DELETING THE FUTURE CVG PGM ',10);

1693:
1694:
1695: hr_utility.set_location('Effective Date'||l_effective_date,113);
1696: --
1697: hr_utility.set_location(' BKKKK DELETING THE FUTURE CVG PGM ',10);
1698: --
1699: /*
1700: if (l_per_in_ler_id IS NOT NULL) then
1701: ben_election_information.backout_future_coverage

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

1731: --
1732: --
1733: -- Check if we should terminate COBRA eligibility.
1734: --
1735: hr_utility.set_location('p_pgm_id: '||p_pgm_id,10);
1736: hr_utility.set_location('l_pen.ptip_id: '||l_pen.ptip_id,10);
1737: --
1738: ben_comp_object.get_object(p_pgm_id => p_pgm_id,
1739: p_rec => l_pgm_rec);

Line 1736: hr_utility.set_location('l_pen.ptip_id: '||l_pen.ptip_id,10);

1732: --
1733: -- Check if we should terminate COBRA eligibility.
1734: --
1735: hr_utility.set_location('p_pgm_id: '||p_pgm_id,10);
1736: hr_utility.set_location('l_pen.ptip_id: '||l_pen.ptip_id,10);
1737: --
1738: ben_comp_object.get_object(p_pgm_id => p_pgm_id,
1739: p_rec => l_pgm_rec);
1740: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);

Line 1740: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);

1736: hr_utility.set_location('l_pen.ptip_id: '||l_pen.ptip_id,10);
1737: --
1738: ben_comp_object.get_object(p_pgm_id => p_pgm_id,
1739: p_rec => l_pgm_rec);
1740: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);
1741: if l_pgm_rec.pgm_typ_cd like 'COBRA%' then
1742: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,20);
1743: ben_cobra_requirements.g_cobra_enrollment_change := TRUE;
1744: end if;

Line 1742: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,20);

1738: ben_comp_object.get_object(p_pgm_id => p_pgm_id,
1739: p_rec => l_pgm_rec);
1740: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,10);
1741: if l_pgm_rec.pgm_typ_cd like 'COBRA%' then
1742: hr_utility.set_location('pgm_typ: '||l_pgm_rec.pgm_typ_cd,20);
1743: ben_cobra_requirements.g_cobra_enrollment_change := TRUE;
1744: end if;
1745: --
1746: -- end if;

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

1764: end if ;
1765: --
1766: end if;
1767: --
1768: hr_utility.set_location ('Leaving '||l_proc,10);
1769: --
1770: end main;
1771: --
1772: end ben_newly_ineligible;