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 BEN_BATCH_UTILS

Line 120: ben_batch_utils.WRITE('Initialising Rankings');

116: end if;
117: --
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

Line 132: ben_batch_utils.WRITE ('Number of Employees with Rankings Initialized: '||l_ranks_initialised);

128: ,p_object_version_number => l_ranking_info.object_version_number);
129: l_ranks_initialised := l_ranks_initialised + 1;
130: end loop;
131: commit;
132: ben_batch_utils.WRITE ('Number of Employees with Rankings Initialized: '||l_ranks_initialised);
133: end if;
134: --
135: if p_refresh_pl_dsgn_flag = 'Y' then
136: --

Line 137: ben_batch_utils.WRITE('Refreshing Plan Design');

133: end if;
134: --
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: --

Line 158: ben_batch_utils.WRITE('Initialising Refresh');

154: --
155: begin
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

Line 168: ben_batch_utils.WRITE('Completed Refresh');

164: ,l_effective_date
165: ,'Y'
166: );
167: commit;
168: ben_batch_utils.WRITE('Completed Refresh');
169: end if;
170: exception
171: when others then
172: ben_batch_utils.WRITE(SQLERRM);

Line 172: ben_batch_utils.WRITE(SQLERRM);

168: ben_batch_utils.WRITE('Completed Refresh');
169: end if;
170: exception
171: when others then
172: ben_batch_utils.WRITE(SQLERRM);
173: ben_batch_utils.WRITE('Exchange Rate refresh failed');
174: rollback to before_refresh_xchg;
175: end;
176: --

Line 173: ben_batch_utils.WRITE('Exchange Rate refresh failed');

169: end if;
170: exception
171: when others then
172: ben_batch_utils.WRITE(SQLERRM);
173: ben_batch_utils.WRITE('Exchange Rate refresh failed');
174: rollback to before_refresh_xchg;
175: end;
176: --
177: if g_debug then

Line 183: ben_batch_utils.WRITE('Refreshing Person Info');

179: end if;
180: --
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: --

Line 207: ben_batch_utils.WRITE('Refreshing Summary');

203: end if;
204: --
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: --

Line 226: ben_batch_utils.WRITE('Refreshing Mail Burst Flag');

222: end if;
223: --
224: if p_refresh_mail_burst_flag = 'Y' then
225: --
226: ben_batch_utils.WRITE('Refreshing Mail Burst Flag');
227: --
228: UPDATE ben_cwb_person_info
229: SET email_status = 'N'
230: WHERE lf_evt_ocrd_dt = trunc(to_date(p_lf_evt_ocrd_dt,'yyyy/mm/dd hh24:mi:ss'))

Line 248: ben_batch_utils.WRITE('Consolidating Summary');

244: -- if the summary is refreshed then there is no need to consolidate the
245: -- summary
246: if p_consolidate_summary_flag = 'Y' and p_refresh_summary_flag <> 'Y' then
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;

Line 272: ben_batch_utils.WRITE('Refreshing worksheet rate start date');

268: --
269: end if;
270: --
271: if p_refresh_rate_from_rule = 'Y' then
272: ben_batch_utils.WRITE('Refreshing worksheet rate start date');
273: --
274: -- Put row in fnd_sessions
275: --
276: dt_fndate.change_ses_date

Line 279: ben_batch_utils.WRITE ('Changing Session Date: '||l_effective_date);

275: --
276: dt_fndate.change_ses_date
277: (p_ses_date => l_effective_date,
278: p_commit => l_commit);
279: ben_batch_utils.WRITE ('Changing Session Date: '||l_effective_date);
280: ben_batch_utils.WRITE ('Commit on date : '||l_commit);
281:
282: for rec in c_formula_inputs(p_group_pl_id,l_lf_evt_ocrd_dt) loop
283:

Line 280: ben_batch_utils.WRITE ('Commit on date : '||l_commit);

276: dt_fndate.change_ses_date
277: (p_ses_date => l_effective_date,
278: p_commit => l_commit);
279: ben_batch_utils.WRITE ('Changing Session Date: '||l_effective_date);
280: ben_batch_utils.WRITE ('Commit on date : '||l_commit);
281:
282: for rec in c_formula_inputs(p_group_pl_id,l_lf_evt_ocrd_dt) loop
283:
284: l_object_version_number := rec.object_version_number;

Line 301: -- ben_batch_utils.WRITE(rec.group_per_in_ler_id||' '||l_returned_date||' '||rec.oipl_id);

297: ,p_effective_date => l_effective_date
298: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
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;

Line 339: ben_batch_utils.WRITE(SQLERRM);

335: end if;
336: --
337: exception
338: when others then
339: ben_batch_utils.WRITE(SQLERRM);
340: ben_batch_utils.WRITE('Process Errored : Rolled Back');
341: ROLLBACK;
342:
343: end refresh;

Line 340: ben_batch_utils.WRITE('Process Errored : Rolled Back');

336: --
337: exception
338: when others then
339: ben_batch_utils.WRITE(SQLERRM);
340: ben_batch_utils.WRITE('Process Errored : Rolled Back');
341: ROLLBACK;
342:
343: end refresh;
344: