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

Line 20: hr_utility.set_location('Entering'||l_proc, 5);

16: l_proc varchar2(72) := g_package||'initialize_globals';
17: --
18: BEGIN
19: --
20: hr_utility.set_location('Entering'||l_proc, 5);
21: --
22: ben_ext_person.g_prem_actl_prem_id := null;
23: ben_ext_person.g_prem_mn_amt := null;
24: ben_ext_person.g_prem_mn_uom := null;

Line 38: hr_utility.set_location('Exiting'||l_proc, 15);

34: ben_ext_person.g_prem_year := null;
35: ben_ext_person.g_prtt_prem_by_mo_id := null;
36: ben_ext_person.g_prem_last_upd_date := null ;
37:
38: hr_utility.set_location('Exiting'||l_proc, 15);
39: --
40: End initialize_globals;
41:
42: -- ----------------------------------------------------------------------------

Line 77: hr_utility.set_location('Entering'||l_proc, 5);

73: --
74: BEGIN
75: --
76: --
77: hr_utility.set_location('Entering'||l_proc, 5);
78: --
79: -- Monthly Premium Informations
80: ben_ext_person.g_enrt_mntot_prem_amt := null ;
81: ben_ext_person.g_enrt_mntot_prem_cramt := null ;

Line 87: hr_utility.set_location('month'|| prem.mo_num,5381);

83: --
84: FOR prem IN c_mn_prem(p_prtt_enrt_rslt_id) LOOP
85: --
86:
87: hr_utility.set_location('month'|| prem.mo_num,5381);
88: hr_utility.set_location('year' || prem.yr_num,5381);
89: ---validating the month and year and update_date
90: ben_ext_evaluate_inclusion.evaluate_prem_incl
91: (p_last_update_date => prem.last_update_date,

Line 88: hr_utility.set_location('year' || prem.yr_num,5381);

84: FOR prem IN c_mn_prem(p_prtt_enrt_rslt_id) LOOP
85: --
86:
87: hr_utility.set_location('month'|| prem.mo_num,5381);
88: hr_utility.set_location('year' || prem.yr_num,5381);
89: ---validating the month and year and update_date
90: ben_ext_evaluate_inclusion.evaluate_prem_incl
91: (p_last_update_date => prem.last_update_date,
92: p_mo_num => prem.mo_num ,

Line 107: hr_utility.set_location('Exiting'||l_proc, 15);

103: END LOOP;
104: ben_ext_person.g_enrt_mntot_prem_amt := l_tot_val ;
105: ben_ext_person.g_enrt_mntot_prem_cramt := l_tot_cr_val ;
106: --
107: hr_utility.set_location('Exiting'||l_proc, 15);
108:
109: END; -- premium_total
110:
111:

Line 165: hr_utility.set_location('Entering'||l_proc, 5);

161:
162: --
163: BEGIN
164: --
165: hr_utility.set_location('Entering'||l_proc, 5);
166: --
167: -- Monthly Premium Informations
168: hr_utility.set_location('result idd' || p_prtt_enrt_rslt_id,5380);
169: --

Line 168: hr_utility.set_location('result idd' || p_prtt_enrt_rslt_id,5380);

164: --
165: hr_utility.set_location('Entering'||l_proc, 5);
166: --
167: -- Monthly Premium Informations
168: hr_utility.set_location('result idd' || p_prtt_enrt_rslt_id,5380);
169: --
170: FOR prem IN c_mn_prem(p_prtt_enrt_rslt_id) LOOP
171: --
172: hr_utility.set_location(' prtt prrem id' || prem.prtt_prem_by_mo_id,5380);

Line 172: hr_utility.set_location(' prtt prrem id' || prem.prtt_prem_by_mo_id,5380);

168: hr_utility.set_location('result idd' || p_prtt_enrt_rslt_id,5380);
169: --
170: FOR prem IN c_mn_prem(p_prtt_enrt_rslt_id) LOOP
171: --
172: hr_utility.set_location(' prtt prrem id' || prem.prtt_prem_by_mo_id,5380);
173: initialize_globals;
174: -- fetch premium information into globals
175: --
176: --l_include := 'Y';

Line 187: hr_utility.set_location(' month ' || prem.mo_num , 119);

183: p_include => l_include) ;
184: --end if ;
185: if l_include = 'Y' then
186: --
187: hr_utility.set_location(' month ' || prem.mo_num , 119);
188: hr_utility.set_location(' year ' || prem.yr_num , 119);
189:
190: ben_ext_person.g_prem_actl_prem_id := prem.actl_prem_id;
191: ben_ext_person.g_prem_mn_amt := prem.val;

Line 188: hr_utility.set_location(' year ' || prem.yr_num , 119);

184: --end if ;
185: if l_include = 'Y' then
186: --
187: hr_utility.set_location(' month ' || prem.mo_num , 119);
188: hr_utility.set_location(' year ' || prem.yr_num , 119);
189:
190: ben_ext_person.g_prem_actl_prem_id := prem.actl_prem_id;
191: ben_ext_person.g_prem_mn_amt := prem.val;
192: ben_ext_person.g_prem_mn_uom := prem.uom;

Line 207: hr_utility.set_location(' month ' || ben_ext_person.g_prem_month , 119);

203: ben_ext_person.g_prem_type := prem.actl_prem_typ_cd;
204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
206: --
207: hr_utility.set_location(' month ' || ben_ext_person.g_prem_month , 119);
208: hr_utility.set_location(' year ' || ben_ext_person.g_prem_year , 119);
209: -- format and write
210: --
211: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,

Line 208: hr_utility.set_location(' year ' || ben_ext_person.g_prem_year , 119);

204: ben_ext_person.g_prtt_prem_by_mo_id := prem.prtt_prem_by_mo_id;
205: ben_ext_person.g_prem_last_upd_date := prem.last_update_date;
206: --
207: hr_utility.set_location(' month ' || ben_ext_person.g_prem_month , 119);
208: hr_utility.set_location(' year ' || ben_ext_person.g_prem_year , 119);
209: -- format and write
210: --
211: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
212: p_ext_file_id => p_ext_file_id,

Line 226: hr_utility.set_location('Exiting'||l_proc, 15);

222: end if ;
223: --
224: END LOOP;
225: --
226: hr_utility.set_location('Exiting'||l_proc, 15);
227:
228: END; -- main
229: --
230: END; -- package