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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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