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

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

160: l_elig_per_elctbl_chc_id number;
161: --
162: begin
163: --
164: hr_utility.set_location ('Entering '||l_package,10);
165: -- need to update the pending flag to 'N' as the flag is not being reset by process
166: --after unpending
167: open c_elig_per_elctbl_chc_2;
168: loop

Line 225: hr_utility.set_location ('sspndd epe = '||l_epe_rec.elig_per_elctbl_chc_id,20);

221: ,p_effective_date => p_effective_date
222: );
223: --
224: /*
225: hr_utility.set_location ('sspndd epe = '||l_epe_rec.elig_per_elctbl_chc_id,20);
226: update ben_elig_per_elctbl_chc
227: set in_pndg_wkflow_flag = 'S'
228: where elig_per_elctbl_chc_id = l_epe_rec.elig_per_elctbl_chc_id;
229: */

Line 254: hr_utility.set_location ('Leaving '||l_package,30);

250: end loop ;
251: close c_elig_per_elctbl_chc_3;
252:
253: --
254: hr_utility.set_location ('Leaving '||l_package,30);
255:
256: end update_in_pend_flag;
257: --
258: procedure delete_elctbl_choice

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

441: l_dummy varchar2(10);
442: l_count number := 1;
443: begin
444: --
445: hr_utility.set_location ('Entering '||l_package,10);
446: g_unrest_epe_instance.delete;
447: g_unrest_enb_instance.delete;
448: g_unrest_ecr_instance.delete;
449: g_unrest_egd_instance.delete;

Line 527: hr_utility.set_location('epe count'|| t_epe_tbl.count,10);

523: fetch c_epe bulk collect into t_epe_tbl;
524: close c_epe;
525: --
526: --
527: hr_utility.set_location('epe count'|| t_epe_tbl.count,10);
528: if t_epe_tbl.count > 0 then
529: /*
530: forall i in 1..t_epe_tbl.last
531: delete from ben_enrt_rt

Line 565: hr_utility.set_location (' within loop'||t_epe_tbl(i),10);

561: delete from ben_elig_per_elctbl_chc
562: where elig_per_elctbl_chc_id = t_epe_tbl(i);
563: */
564: for i in 1..t_epe_tbl.last loop
565: hr_utility.set_location (' within loop'||t_epe_tbl(i),10);
566: open c_epe_ch (t_epe_tbl(i));
567: fetch c_epe_ch into g_unrest_epe_instance(i);
568: --
569: update ben_elig_per_elctbl_chc set prtt_enrt_rslt_id = null

Line 577: hr_utility.set_location (' within enb',10);

573: end loop;
574: --
575: l_cnt := 1;
576: for i in 1..t_epe_tbl.last loop
577: hr_utility.set_location (' within enb',10);
578: open c_enb_ch (t_epe_tbl(i));
579: loop
580: fetch c_enb_ch into g_unrest_enb_instance_row;
581: if c_enb_ch%found then

Line 593: hr_utility.set_location (' within ecr',10);

589: end loop;
590: --
591: l_cnt := 1;
592: for i in 1..t_epe_tbl.last loop
593: hr_utility.set_location (' within ecr',10);
594: open c_ecr_ch (t_epe_tbl(i));
595: loop
596: fetch c_ecr_ch into g_unrest_ecr_instance_row;
597: if c_ecr_ch%found then

Line 598: hr_utility.set_location ('enrt id'||g_unrest_ecr_instance_row.enrt_rt_id,11);

594: open c_ecr_ch (t_epe_tbl(i));
595: loop
596: fetch c_ecr_ch into g_unrest_ecr_instance_row;
597: if c_ecr_ch%found then
598: hr_utility.set_location ('enrt id'||g_unrest_ecr_instance_row.enrt_rt_id,11);
599: g_unrest_ecr_instance(l_cnt) := g_unrest_ecr_instance_row;
600: l_cnt := l_cnt + 1;
601: else
602: exit;

Line 610: hr_utility.set_location (' within ecr',10);

606: end loop;
607: --
608: l_cnt := 1;
609: for i in 1..t_epe_tbl.last loop
610: hr_utility.set_location (' within ecr',10);
611: open c_epr_ch (t_epe_tbl(i));
612: loop
613: fetch c_epr_ch into g_unrest_epr_instance_row;
614: if c_epr_ch%found then

Line 615: hr_utility.set_location ('prem id'||g_unrest_epr_instance_row.enrt_prem_id,11);

611: open c_epr_ch (t_epe_tbl(i));
612: loop
613: fetch c_epr_ch into g_unrest_epr_instance_row;
614: if c_epr_ch%found then
615: hr_utility.set_location ('prem id'||g_unrest_epr_instance_row.enrt_prem_id,11);
616: g_unrest_epr_instance(l_cnt) := g_unrest_epr_instance_row;
617: l_cnt := l_cnt + 1;
618: else
619: exit;

Line 627: hr_utility.set_location (' within ecc',10);

623: end loop;
624: --
625: l_cnt := 1;
626: for i in 1..t_epe_tbl.last loop
627: hr_utility.set_location (' within ecc',10);
628: open c_ecc_ch (t_epe_tbl(i));
629: loop
630: fetch c_ecc_ch into g_unrest_ecc_instance_row;
631: if c_ecc_ch%found then

Line 632: hr_utility.set_location ('Chc ctfn id'||g_unrest_ecc_instance_row.elctbl_chc_ctfn_id,11);

628: open c_ecc_ch (t_epe_tbl(i));
629: loop
630: fetch c_ecc_ch into g_unrest_ecc_instance_row;
631: if c_ecc_ch%found then
632: hr_utility.set_location ('Chc ctfn id'||g_unrest_ecc_instance_row.elctbl_chc_ctfn_id,11);
633: g_unrest_ecc_instance(l_cnt) := g_unrest_ecc_instance_row;
634: l_cnt := l_cnt + 1;
635: else
636: exit;

Line 644: hr_utility.set_location (' within egd ',10);

640: end loop;
641: --
642: l_cnt := 1;
643: for i in 1..t_epe_tbl.last loop
644: hr_utility.set_location (' within egd ',10);
645: open c_egd_ch (t_epe_tbl(i));
646: loop
647: fetch c_egd_ch into g_unrest_egd_instance_row;
648: if c_egd_ch%found then

Line 685: hr_utility.set_location ('Leaving '||l_package,11);

681: -- reset_elctbl_chc_inpng_flag(p_rec.per_in_ler_id);
682: --
683: end if;
684: --
685: hr_utility.set_location ('Leaving '||l_package,11);
686: --
687: -- Reset p_rec to null if exception
688: --
689: exception

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

773: l_oiplip_id number;
774: --
775: begin
776: --
777: hr_utility.set_location ('Entering '||l_package,10);
778: --
779: ben_elig_per_elc_chc_api.CreOrSel_pil_elctbl_chc_popl
780: (p_per_in_ler_id => p_per_in_ler_id
781: ,p_effective_date => p_effective_date

Line 1369: hr_utility.set_location('Obj version'||l_object_version_number,10);

1365: end loop;
1366: --
1367: end if;
1368: --
1369: hr_utility.set_location('Obj version'||l_object_version_number,10);
1370: --
1371: update ben_enrt_prem set val = p_val, uom=p_uom
1372: where enrt_prem_id = p_enrt_prem_id;
1373: /*

Line 1554: hr_utility.set_location('Elig per chc id'||l_elig_per_elctbl_chc_id,10);

1550: --
1551: end if;
1552: --
1553: end if;
1554: hr_utility.set_location('Elig per chc id'||l_elig_per_elctbl_chc_id,10);
1555: return l_elig_per_elctbl_chc_id;
1556:
1557: end;
1558: --

Line 1580: hr_utility.set_location('ENrt Bnft id'||l_enrt_bnft_id,10);

1576: exit;
1577: end if;
1578: end loop;
1579: end if;
1580: hr_utility.set_location('ENrt Bnft id'||l_enrt_bnft_id,10);
1581: return l_enrt_bnft_id;
1582:
1583: end;
1584: --

Line 1595: hr_utility.set_location('Count '||g_unrest_ecr_instance.count,1);

1591: l_enrt_rt_id number;
1592: --
1593: begin
1594: --
1595: hr_utility.set_location('Count '||g_unrest_ecr_instance.count,1);
1596: hr_utility.set_location('Electable choice Id'||p_ELIG_PER_ELCTBL_CHC_ID,2);
1597: hr_utility.set_location('Act base rt id'||p_acty_base_rt_id,3);
1598: hr_utility.set_location('Benefit Id'||p_enrt_bnft_id,4);
1599:

Line 1596: hr_utility.set_location('Electable choice Id'||p_ELIG_PER_ELCTBL_CHC_ID,2);

1592: --
1593: begin
1594: --
1595: hr_utility.set_location('Count '||g_unrest_ecr_instance.count,1);
1596: hr_utility.set_location('Electable choice Id'||p_ELIG_PER_ELCTBL_CHC_ID,2);
1597: hr_utility.set_location('Act base rt id'||p_acty_base_rt_id,3);
1598: hr_utility.set_location('Benefit Id'||p_enrt_bnft_id,4);
1599:
1600:

Line 1597: hr_utility.set_location('Act base rt id'||p_acty_base_rt_id,3);

1593: begin
1594: --
1595: hr_utility.set_location('Count '||g_unrest_ecr_instance.count,1);
1596: hr_utility.set_location('Electable choice Id'||p_ELIG_PER_ELCTBL_CHC_ID,2);
1597: hr_utility.set_location('Act base rt id'||p_acty_base_rt_id,3);
1598: hr_utility.set_location('Benefit Id'||p_enrt_bnft_id,4);
1599:
1600:
1601: if g_unrest_ecr_instance.count > 0 then

Line 1598: hr_utility.set_location('Benefit Id'||p_enrt_bnft_id,4);

1594: --
1595: hr_utility.set_location('Count '||g_unrest_ecr_instance.count,1);
1596: hr_utility.set_location('Electable choice Id'||p_ELIG_PER_ELCTBL_CHC_ID,2);
1597: hr_utility.set_location('Act base rt id'||p_acty_base_rt_id,3);
1598: hr_utility.set_location('Benefit Id'||p_enrt_bnft_id,4);
1599:
1600:
1601: if g_unrest_ecr_instance.count > 0 then
1602: --

Line 1615: hr_utility.set_location('ENrt Rate id'||l_enrt_rt_id,10);

1611: exit;
1612: end if;
1613: end loop;
1614: end if;
1615: hr_utility.set_location('ENrt Rate id'||l_enrt_rt_id,10);
1616: return l_enrt_rt_id;
1617:
1618: end;
1619: --

Line 1644: hr_utility.set_location('ENrt Premium id'||l_enrt_prem_id,10);

1640: exit;
1641: end if;
1642: end loop;
1643: end if;
1644: hr_utility.set_location('ENrt Premium id'||l_enrt_prem_id,10);
1645: return l_enrt_prem_id;
1646:
1647: end;
1648:

Line 1660: hr_utility.set_location('Egd Exists',10);

1656: l_elig_dpnt_id number;
1657: --
1658: begin
1659: --
1660: hr_utility.set_location('Egd Exists',10);
1661: hr_utility.set_location('Egd count'||g_unrest_egd_instance.count,11);
1662: if g_unrest_egd_instance.count > 0 then
1663: --
1664: for i in g_unrest_egd_instance.first..g_unrest_egd_instance.last loop

Line 1661: hr_utility.set_location('Egd count'||g_unrest_egd_instance.count,11);

1657: --
1658: begin
1659: --
1660: hr_utility.set_location('Egd Exists',10);
1661: hr_utility.set_location('Egd count'||g_unrest_egd_instance.count,11);
1662: if g_unrest_egd_instance.count > 0 then
1663: --
1664: for i in g_unrest_egd_instance.first..g_unrest_egd_instance.last loop
1665: hr_utility.set_location('per_in ler id'||g_unrest_egd_instance(i).PER_IN_LER_ID,12);

Line 1665: hr_utility.set_location('per_in ler id'||g_unrest_egd_instance(i).PER_IN_LER_ID,12);

1661: hr_utility.set_location('Egd count'||g_unrest_egd_instance.count,11);
1662: if g_unrest_egd_instance.count > 0 then
1663: --
1664: for i in g_unrest_egd_instance.first..g_unrest_egd_instance.last loop
1665: hr_utility.set_location('per_in ler id'||g_unrest_egd_instance(i).PER_IN_LER_ID,12);
1666: --
1667: if g_unrest_egd_instance(i).PER_IN_LER_ID = p_PER_IN_LER_ID and
1668: nvl(g_unrest_egd_instance(i).ELIG_PER_ID,-100) = nvl(p_ELIG_PER_ID,-100) and
1669: nvl(g_unrest_egd_instance(i).ELIG_PER_OPT_ID,-1) = nvl(p_ELIG_PER_OPT_ID,-1) and

Line 1677: hr_utility.set_location('Elig dpnt id'||l_elig_dpnt_id,10);

1673: exit;
1674: end if;
1675: end loop;
1676: end if;
1677: hr_utility.set_location('Elig dpnt id'||l_elig_dpnt_id,10);
1678: return l_elig_dpnt_id;
1679:
1680: end;
1681: --

Line 1706: hr_utility.set_location('Chc Cert id'||l_enrt_ctfn_id,10);

1702: exit;
1703: end if;
1704: end loop;
1705: end if;
1706: hr_utility.set_location('Chc Cert id'||l_enrt_ctfn_id,10);
1707: return l_enrt_ctfn_id;
1708: --
1709: end;
1710: --

Line 1907: hr_utility.set_location ('Delete Elig Id '||g_unrest_epe_instance(i).elig_per_elctbl_chc_id,11);

1903: for i in g_unrest_epe_instance.first..g_unrest_epe_instance.last loop
1904: --
1905: if g_unrest_epe_instance(i).mark_delete is null then
1906: --
1907: hr_utility.set_location ('Delete Elig Id '||g_unrest_epe_instance(i).elig_per_elctbl_chc_id,11);
1908: delete from ben_elig_per_elctbl_chc where elig_per_elctbl_chc_id =
1909: g_unrest_epe_instance(i).elig_per_elctbl_chc_id;
1910: --
1911: end if;

Line 1941: hr_utility.set_location ('Delete Elig Id in clear_epe '||g_unrest_epe_instance(i).elig_per_elctbl_chc_id,11);

1937: if g_unrest_epe_instance(i).mark_delete is null
1938: and g_unrest_epe_instance(i).comp_lvl_cd in ('OIPL','PLAN') then
1939: -- and g_unrest_epe_instance(i).elctbl_flag = 'Y' -- bug 4761065 : Need to delete epe regardless whether its elctbl_flag is Y/N .
1940: --
1941: hr_utility.set_location ('Delete Elig Id in clear_epe '||g_unrest_epe_instance(i).elig_per_elctbl_chc_id,11);
1942: delete from ben_elig_per_elctbl_chc where elig_per_elctbl_chc_id =
1943: g_unrest_epe_instance(i).elig_per_elctbl_chc_id;
1944: --
1945: else

Line 2039: hr_utility.set_location

2035: future_epo_rec get_future_epo%ROWTYPE;
2036: ---- end bug 5658405
2037: /***/
2038: BEGIN
2039: hr_utility.set_location
2040: ('Entering ben_manage_unres_life_events.end_date_elig_per_rows',
2041: 10
2042: );
2043:

Line 2054: hr_utility.set_location

2050: EXIT WHEN get_pep%NOTFOUND;
2051:
2052: /**get its child **/
2053: -- OPEN get_epo (l_pep.elig_per_id);
2054: hr_utility.set_location
2055: ( '******************* l_pep.elig_per_id '
2056: || l_pep.elig_per_id,
2057: 12.12
2058: );

Line 2067: hr_utility.set_location ( 'End-dating elig_per_opt_id '

2063: FETCH get_epo
2064: INTO l_epo;
2065:
2066: EXIT WHEN get_epo%NOTFOUND;
2067: hr_utility.set_location ( 'End-dating elig_per_opt_id '
2068: || l_epo.elig_per_opt_id
2069: || ' to '
2070: || l_pep.end_date,
2071: 9909

Line 2073: hr_utility.set_location ( l_epo.elig_per_opt_id

2069: || ' to '
2070: || l_pep.end_date,
2071: 9909
2072: );
2073: hr_utility.set_location ( l_epo.elig_per_opt_id
2074: || ' : '
2075: || TO_CHAR (l_pep.end_date)
2076: || ' : '
2077: || l_epo.object_version_number

Line 2106: hr_utility.set_location ( 'End-dating elig_per_opt_id update'

2102: FETCH get_future_epo
2103: INTO future_epo_rec;
2104:
2105: EXIT WHEN get_future_epo%NOTFOUND;
2106: hr_utility.set_location ( 'End-dating elig_per_opt_id update'
2107: || future_epo_rec.elig_per_opt_id
2108: || ' to '
2109: || l_pep.end_date,
2110: 9909

Line 2123: hr_utility.set_location ( 'End-dating elig_per_id '

2119: END LOOP;
2120:
2121: CLOSE get_future_epo;
2122:
2123: hr_utility.set_location ( 'End-dating elig_per_id '
2124: || l_pep.elig_per_id
2125: || ' to '
2126: || l_pep.end_date,
2127: 9909

Line 2129: hr_utility.set_location ( 'per_in_ler_id'

2125: || ' to '
2126: || l_pep.end_date,
2127: 9909
2128: );
2129: hr_utility.set_location ( 'per_in_ler_id'
2130: || ' : '
2131: || 'elig_per_opt_id'
2132: || ' : '
2133: || 'effective_start_date'

Line 2139: hr_utility.set_location ( '=>l_pep.elig_per_id '

2135: || 'effective_end_date',
2136: 12.12
2137: );
2138:
2139: hr_utility.set_location ( '=>l_pep.elig_per_id '
2140: || l_pep.elig_per_id
2141: || ' '
2142: || l_pep.object_version_number,
2143: 12.12

Line 2154: hr_utility.set_location ( 'After ending pep '

2150: p_effective_start_date => l_effective_start_date,
2151: p_effective_end_date => l_effective_end_date,
2152: p_datetrack_mode => 'DELETE'
2153: );
2154: hr_utility.set_location ( 'After ending pep '
2155: || l_pep.elig_per_id
2156: || ' '
2157: || TO_CHAR (l_effective_start_date)
2158: || ' '

Line 2166: hr_utility.set_location

2162: END LOOP;
2163:
2164: CLOSE get_pep;
2165:
2166: hr_utility.set_location
2167: ('Leaving ben_manage_unres_life_events.end_date_elig_per_rows',
2168: 20
2169: );
2170: END end_date_elig_per_rows;