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

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

71: having count(*) >= nvl(p_mn_dpnts_rqd_num, 0);
72: --
73: begin
74: --
75: hr_utility.set_location('Entering: '||l_proc,10);
76:
77: hr_utility.set_location('p_oipl_id ' || p_oipl_id ,99 ) ;
78: hr_utility.set_location('p_pl_id ' || p_pl_id ,99 );
79: hr_utility.set_location('p_opt_id ' || p_opt_id , 99 ) ;

Line 77: hr_utility.set_location('p_oipl_id ' || p_oipl_id ,99 ) ;

73: begin
74: --
75: hr_utility.set_location('Entering: '||l_proc,10);
76:
77: hr_utility.set_location('p_oipl_id ' || p_oipl_id ,99 ) ;
78: hr_utility.set_location('p_pl_id ' || p_pl_id ,99 );
79: hr_utility.set_location('p_opt_id ' || p_opt_id , 99 ) ;
80: -- hr_utility.set_location('Entering ' || l_package,10);
81: --FONM

Line 78: hr_utility.set_location('p_pl_id ' || p_pl_id ,99 );

74: --
75: hr_utility.set_location('Entering: '||l_proc,10);
76:
77: hr_utility.set_location('p_oipl_id ' || p_oipl_id ,99 ) ;
78: hr_utility.set_location('p_pl_id ' || p_pl_id ,99 );
79: hr_utility.set_location('p_opt_id ' || p_opt_id , 99 ) ;
80: -- hr_utility.set_location('Entering ' || l_package,10);
81: --FONM
82: if ben_manage_life_events.fonm = 'Y'

Line 79: hr_utility.set_location('p_opt_id ' || p_opt_id , 99 ) ;

75: hr_utility.set_location('Entering: '||l_proc,10);
76:
77: hr_utility.set_location('p_oipl_id ' || p_oipl_id ,99 ) ;
78: hr_utility.set_location('p_pl_id ' || p_pl_id ,99 );
79: hr_utility.set_location('p_opt_id ' || p_opt_id , 99 ) ;
80: -- hr_utility.set_location('Entering ' || l_package,10);
81: --FONM
82: if ben_manage_life_events.fonm = 'Y'
83: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

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

76:
77: hr_utility.set_location('p_oipl_id ' || p_oipl_id ,99 ) ;
78: hr_utility.set_location('p_pl_id ' || p_pl_id ,99 );
79: hr_utility.set_location('p_opt_id ' || p_opt_id , 99 ) ;
80: -- hr_utility.set_location('Entering ' || l_package,10);
81: --FONM
82: if ben_manage_life_events.fonm = 'Y'
83: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
84: --

Line 133: hr_utility.set_location( ' count ' || l_rlshp_count , 99 );

129: end loop;
130: end if;
131: end loop;
132: --
133: hr_utility.set_location( ' count ' || l_rlshp_count , 99 );
134: -- If there are no relationship rows, then the number of dependents
135: -- must meet the minimum number required for the comp object.
136: --
137: if l_found_rows = false then

Line 156: hr_utility.set_location('Leaving: '||l_proc,20);

152: end loop;
153: --
154: p_dpnt_elig_flag := l_dpnt_elig_flag;
155: --
156: hr_utility.set_location('Leaving: '||l_proc,20);
157: --
158: end check_dsgn_rqmts;
159: --
160: -- -----------------------------------------------------------------------------

Line 202: g_debug := hr_utility.debug_enabled;

198: --END FONM
199:
200: begin
201: --
202: g_debug := hr_utility.debug_enabled;
203: --
204: if g_debug then
205: hr_utility.set_location('Entering : ' || l_proc, 10);
206: end if;

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

201: --
202: g_debug := hr_utility.debug_enabled;
203: --
204: if g_debug then
205: hr_utility.set_location('Entering : ' || l_proc, 10);
206: end if;
207: --
208: if ben_manage_life_events.fonm = 'Y'
209: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

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

318: end if;
319: --
320: if g_debug then
321: --
322: hr_utility.set_location('Leaving : ' || l_proc, 10);
323: --
324: end if;
325: --
326: return l_return_date;

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

376: l_dummy varchar2(30) := NULL ;
377: l_dummy2 varchar2(30) := NULL;
378: BEGIN
379: --
380: hr_utility.set_location('Entering '||l_proc,10);
381: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,22);
382: hr_utility.set_location('p_current_per_in_ler_id'||p_current_per_in_ler_id,22);
383: hr_utility.set_location('p_elig_per_id'||p_elig_per_id,22);
384: hr_utility.set_location('p_elig_per_opt_id'||p_elig_per_opt_id,22);

Line 381: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,22);

377: l_dummy2 varchar2(30) := NULL;
378: BEGIN
379: --
380: hr_utility.set_location('Entering '||l_proc,10);
381: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,22);
382: hr_utility.set_location('p_current_per_in_ler_id'||p_current_per_in_ler_id,22);
383: hr_utility.set_location('p_elig_per_id'||p_elig_per_id,22);
384: hr_utility.set_location('p_elig_per_opt_id'||p_elig_per_opt_id,22);
385: hr_utility.set_location('p_effective_date '||p_effective_date,22);

Line 382: hr_utility.set_location('p_current_per_in_ler_id'||p_current_per_in_ler_id,22);

378: BEGIN
379: --
380: hr_utility.set_location('Entering '||l_proc,10);
381: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,22);
382: hr_utility.set_location('p_current_per_in_ler_id'||p_current_per_in_ler_id,22);
383: hr_utility.set_location('p_elig_per_id'||p_elig_per_id,22);
384: hr_utility.set_location('p_elig_per_opt_id'||p_elig_per_opt_id,22);
385: hr_utility.set_location('p_effective_date '||p_effective_date,22);
386: --

Line 383: hr_utility.set_location('p_elig_per_id'||p_elig_per_id,22);

379: --
380: hr_utility.set_location('Entering '||l_proc,10);
381: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,22);
382: hr_utility.set_location('p_current_per_in_ler_id'||p_current_per_in_ler_id,22);
383: hr_utility.set_location('p_elig_per_id'||p_elig_per_id,22);
384: hr_utility.set_location('p_elig_per_opt_id'||p_elig_per_opt_id,22);
385: hr_utility.set_location('p_effective_date '||p_effective_date,22);
386: --
387: open c_le(p_per_in_ler_id,p_effective_date);

Line 384: hr_utility.set_location('p_elig_per_opt_id'||p_elig_per_opt_id,22);

380: hr_utility.set_location('Entering '||l_proc,10);
381: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,22);
382: hr_utility.set_location('p_current_per_in_ler_id'||p_current_per_in_ler_id,22);
383: hr_utility.set_location('p_elig_per_id'||p_elig_per_id,22);
384: hr_utility.set_location('p_elig_per_opt_id'||p_elig_per_opt_id,22);
385: hr_utility.set_location('p_effective_date '||p_effective_date,22);
386: --
387: open c_le(p_per_in_ler_id,p_effective_date);
388: fetch c_le into l_dummy;

Line 385: hr_utility.set_location('p_effective_date '||p_effective_date,22);

381: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,22);
382: hr_utility.set_location('p_current_per_in_ler_id'||p_current_per_in_ler_id,22);
383: hr_utility.set_location('p_elig_per_id'||p_elig_per_id,22);
384: hr_utility.set_location('p_elig_per_opt_id'||p_elig_per_opt_id,22);
385: hr_utility.set_location('p_effective_date '||p_effective_date,22);
386: --
387: open c_le(p_per_in_ler_id,p_effective_date);
388: fetch c_le into l_dummy;
389: close c_le;

Line 392: hr_utility.set_location('Not Required '||l_proc,15);

388: fetch c_le into l_dummy;
389: close c_le;
390: --
391: IF NVL(l_dummy,'X') <> 'W' THEN
392: hr_utility.set_location('Not Required '||l_proc,15);
393: return ;
394: ELSE
395: open c_le(p_current_per_in_ler_id,p_effective_date);
396: fetch c_le into l_dummy2;

Line 400: hr_utility.set_location('Not Required '||l_proc,15);

396: fetch c_le into l_dummy2;
397: close c_le;
398: --
399: IF NVL(l_dummy2,'X') <> 'W' THEN
400: hr_utility.set_location('Not Required '||l_proc,15);
401: return ;
402: END IF;
403: --
404: END IF;

Line 414: hr_utility.set_location('Inserting into BEN_LE_CLSN_N_RSTR PEP: '||p_elig_per_id,20);

410: p_effective_date,
411: p_per_in_ler_id )
412: LOOP
413: --
414: hr_utility.set_location('Inserting into BEN_LE_CLSN_N_RSTR PEP: '||p_elig_per_id,20);
415: --
416: insert into BEN_LE_CLSN_N_RSTR (
417: PER_IN_LER_ENDED_ID,
418: BKUP_TBL_TYP_CD,

Line 647: hr_utility.set_location('Inserting into BEN_LE_CLSN_N_RSTR EPO: '||p_elig_per_opt_id,20);

643: p_effective_date,
644: p_per_in_ler_id )
645: LOOP
646: --
647: hr_utility.set_location('Inserting into BEN_LE_CLSN_N_RSTR EPO: '||p_elig_per_opt_id,20);
648: --
649: insert into BEN_LE_CLSN_N_RSTR (
650: PER_IN_LER_ENDED_ID,
651: BKUP_TBL_TYP_CD,

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

841: --
842: END LOOP;
843: END IF;
844: --
845: hr_utility.set_location('Leaving '||l_proc,10);
846: END save_to_restore ;
847: end ben_determine_eligibility3;