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

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_refresh_pkg.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- --------------------------------------------------------------------------
12: -- |------------------------------< refresh >-------------------------------|
13: -- --------------------------------------------------------------------------

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

91: --
92: begin
93: --
94: if g_debug then
95: hr_utility.set_location('Entering:'|| l_proc, 10);
96: end if;
97: --
98: l_effective_date :=trunc(to_date(p_effective_date,'yyyy/mm/dd hh24:mi:ss'));
99: l_lf_evt_ocrd_dt :=trunc(to_date(p_lf_evt_ocrd_dt,'yyyy/mm/dd hh24:mi:ss'));

Line 103: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);

99: l_lf_evt_ocrd_dt :=trunc(to_date(p_lf_evt_ocrd_dt,'yyyy/mm/dd hh24:mi:ss'));
100: l_ranks_initialised := 0;
101:
102: if g_debug then
103: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
104: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
105: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
106: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
107: hr_utility.set_location('Refresh Person Info :'||

Line 104: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);

100: l_ranks_initialised := 0;
101:
102: if g_debug then
103: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
104: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
105: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
106: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
107: hr_utility.set_location('Refresh Person Info :'||
108: p_refresh_person_info_flag, 20);

Line 105: hr_utility.set_location('Eff Date :'||l_effective_date, 20);

101:
102: if g_debug then
103: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
104: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
105: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
106: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
107: hr_utility.set_location('Refresh Person Info :'||
108: p_refresh_person_info_flag, 20);
109: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);

Line 106: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);

102: if g_debug then
103: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
104: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
105: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
106: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
107: hr_utility.set_location('Refresh Person Info :'||
108: p_refresh_person_info_flag, 20);
109: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
110: hr_utility.set_location('Consolidate Summary:'||

Line 107: hr_utility.set_location('Refresh Person Info :'||

103: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
104: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
105: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
106: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
107: hr_utility.set_location('Refresh Person Info :'||
108: p_refresh_person_info_flag, 20);
109: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
110: hr_utility.set_location('Consolidate Summary:'||
111: p_consolidate_summary_flag, 20);

Line 109: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);

105: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
106: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
107: hr_utility.set_location('Refresh Person Info :'||
108: p_refresh_person_info_flag, 20);
109: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
110: hr_utility.set_location('Consolidate Summary:'||
111: p_consolidate_summary_flag, 20);
112: hr_utility.set_location('Initialising Rankings:'||
113: p_init_rank, 20);

Line 110: hr_utility.set_location('Consolidate Summary:'||

106: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
107: hr_utility.set_location('Refresh Person Info :'||
108: p_refresh_person_info_flag, 20);
109: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
110: hr_utility.set_location('Consolidate Summary:'||
111: p_consolidate_summary_flag, 20);
112: hr_utility.set_location('Initialising Rankings:'||
113: p_init_rank, 20);
114: hr_utility.set_location('Refresh Exchange Rate:'||

Line 112: hr_utility.set_location('Initialising Rankings:'||

108: p_refresh_person_info_flag, 20);
109: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
110: hr_utility.set_location('Consolidate Summary:'||
111: p_consolidate_summary_flag, 20);
112: hr_utility.set_location('Initialising Rankings:'||
113: p_init_rank, 20);
114: hr_utility.set_location('Refresh Exchange Rate:'||
115: p_refresh_xchg, 20);
116: end if;

Line 114: hr_utility.set_location('Refresh Exchange Rate:'||

110: hr_utility.set_location('Consolidate Summary:'||
111: p_consolidate_summary_flag, 20);
112: hr_utility.set_location('Initialising Rankings:'||
113: p_init_rank, 20);
114: hr_utility.set_location('Refresh Exchange Rate:'||
115: p_refresh_xchg, 20);
116: end if;
117: --
118: --

Line 122: hr_utility.set_location(l_proc, 21);

118: --
119: if p_init_rank = 'Y' then
120: ben_batch_utils.WRITE('Initialising Rankings');
121: if g_debug then
122: hr_utility.set_location(l_proc, 21);
123: end if;
124: for l_ranking_info in c_ranking_info loop
125: hr_assignment_extra_info_api.delete_assignment_extra_info
126: (p_validate => false

Line 139: hr_utility.set_location(l_proc, 30);

135: if p_refresh_pl_dsgn_flag = 'Y' then
136: --
137: ben_batch_utils.WRITE('Refreshing Plan Design');
138: if g_debug then
139: hr_utility.set_location(l_proc, 30);
140: end if;
141: --
142: ben_cwb_pl_dsgn_pkg.refresh_pl_dsgn
143: (p_group_pl_id => p_group_pl_id

Line 150: hr_utility.set_location(l_proc, 40);

146: ,p_refresh_always => 'Y');
147: commit;
148: --
149: if g_debug then
150: hr_utility.set_location(l_proc, 40);
151: end if;
152: --
153: end if;
154: --

Line 160: hr_utility.set_location(l_proc, 21);

156: savepoint before_refresh_xchg;
157: if p_refresh_xchg = 'Y' then
158: ben_batch_utils.WRITE('Initialising Refresh');
159: if g_debug then
160: hr_utility.set_location(l_proc, 21);
161: end if;
162: ben_cwb_xchg_pkg.insert_into_ben_cwb_xchg(p_group_pl_id
163: ,l_lf_evt_ocrd_dt
164: ,l_effective_date

Line 178: hr_utility.set_location(l_proc, 50);

174: rollback to before_refresh_xchg;
175: end;
176: --
177: if g_debug then
178: hr_utility.set_location(l_proc, 50);
179: end if;
180: --
181: if p_refresh_person_info_flag = 'Y' then
182: --

Line 185: hr_utility.set_location(l_proc, 60);

181: if p_refresh_person_info_flag = 'Y' then
182: --
183: ben_batch_utils.WRITE('Refreshing Person Info');
184: if g_debug then
185: hr_utility.set_location(l_proc, 60);
186: end if;
187: --
188: ben_cwb_person_info_pkg.refresh_person_info_group_pl
189: (p_group_pl_id => p_group_pl_id

Line 196: hr_utility.set_location(l_proc, 70);

192: --
193: commit;
194: --
195: if g_debug then
196: hr_utility.set_location(l_proc, 70);
197: end if;
198: --
199: end if;
200: --

Line 202: hr_utility.set_location(l_proc, 80);

198: --
199: end if;
200: --
201: if g_debug then
202: hr_utility.set_location(l_proc, 80);
203: end if;
204: --
205: if p_refresh_summary_flag = 'Y' then
206: --

Line 209: hr_utility.set_location(l_proc, 90);

205: if p_refresh_summary_flag = 'Y' then
206: --
207: ben_batch_utils.WRITE('Refreshing Summary');
208: if g_debug then
209: hr_utility.set_location(l_proc, 90);
210: end if;
211: --
212: ben_cwb_summary_pkg.refresh_summary_group_pl
213: (p_group_pl_id => p_group_pl_id

Line 219: hr_utility.set_location(l_proc, 100);

215: --
216: commit;
217: --
218: if g_debug then
219: hr_utility.set_location(l_proc, 100);
220: end if;
221: --
222: end if;
223: --

Line 236: hr_utility.set_location(l_proc, 105);

232: --
233: commit;
234: --
235: if g_debug then
236: hr_utility.set_location(l_proc, 105);
237: end if;
238: --
239: end if;
240: if g_debug then

Line 241: hr_utility.set_location(l_proc, 110);

237: end if;
238: --
239: end if;
240: if g_debug then
241: hr_utility.set_location(l_proc, 110);
242: end if;
243: --
244: -- if the summary is refreshed then there is no need to consolidate the
245: -- summary

Line 251: hr_utility.set_location(l_proc, 120);

247:
248: ben_batch_utils.WRITE('Consolidating Summary');
249: --
250: if g_debug then
251: hr_utility.set_location(l_proc, 120);
252: end if;
253: --
254: for rec in csr_person_ids(p_group_pl_id,l_lf_evt_ocrd_dt) loop
255: --

Line 257: hr_utility.set_location(l_proc, 130);

253: --
254: for rec in csr_person_ids(p_group_pl_id,l_lf_evt_ocrd_dt) loop
255: --
256: if g_debug then
257: hr_utility.set_location(l_proc, 130);
258: end if;
259: --
260: ben_cwb_summary_pkg.consolidate_summary_rec
261: (p_person_id => rec.person_id);

Line 266: hr_utility.set_location(l_proc, 140);

262: end loop;
263: commit;
264: --
265: if g_debug then
266: hr_utility.set_location(l_proc, 140);
267: end if;
268: --
269: end if;
270: --

Line 303: hr_utility.set_location(' p_returned_date:'|| l_returned_date, 11);

299: ,p_returned_date => l_returned_date
300: );
301: -- ben_batch_utils.WRITE(rec.group_per_in_ler_id||' '||l_returned_date||' '||rec.oipl_id);
302: if g_debug then
303: hr_utility.set_location(' p_returned_date:'|| l_returned_date, 11);
304: hr_utility.set_location(' p_per_in_ler_id:'|| rec.group_per_in_ler_id, 22);
305: end if;
306:
307: BEN_CWB_PERSON_RATES_API.update_person_rate(

Line 304: hr_utility.set_location(' p_per_in_ler_id:'|| rec.group_per_in_ler_id, 22);

300: );
301: -- ben_batch_utils.WRITE(rec.group_per_in_ler_id||' '||l_returned_date||' '||rec.oipl_id);
302: if g_debug then
303: hr_utility.set_location(' p_returned_date:'|| l_returned_date, 11);
304: hr_utility.set_location(' p_per_in_ler_id:'|| rec.group_per_in_ler_id, 22);
305: end if;
306:
307: BEN_CWB_PERSON_RATES_API.update_person_rate(
308: p_group_per_in_ler_id => rec.group_per_in_ler_id

Line 334: hr_utility.set_location(' Leaving:'|| l_proc, 999);

330: --
331: end if;
332:
333: if g_debug then
334: hr_utility.set_location(' Leaving:'|| l_proc, 999);
335: end if;
336: --
337: exception
338: when others then