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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2036: hr_utility.set_location

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

Line 2051: hr_utility.set_location

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

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

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

Line 2070: hr_utility.set_location ( l_epo.elig_per_opt_id

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

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

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

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

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

Line 2126: hr_utility.set_location ( 'per_in_ler_id'

2122: || ' to '
2123: || l_pep.end_date,
2124: 9909
2125: );
2126: hr_utility.set_location ( 'per_in_ler_id'
2127: || ' : '
2128: || 'elig_per_opt_id'
2129: || ' : '
2130: || 'effective_start_date'

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

2132: || 'effective_end_date',
2133: 12.12
2134: );
2135:
2136: hr_utility.set_location ( '=>l_pep.elig_per_id '
2137: || l_pep.elig_per_id
2138: || ' '
2139: || l_pep.object_version_number,
2140: 12.12

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

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

Line 2163: hr_utility.set_location

2159: END LOOP;
2160:
2161: CLOSE get_pep;
2162:
2163: hr_utility.set_location
2164: ('Leaving ben_manage_unres_life_events.end_date_elig_per_rows',
2165: 20
2166: );
2167: END end_date_elig_per_rows;