DBA Data[Home] [Help]

APPS.BEN_CWB_REFRESH_PKG dependencies on BEN_BATCH_UTILS

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

115: end if;
116: --
117: --
118: if p_init_rank = 'Y' then
119: ben_batch_utils.WRITE('Initialising Rankings');
120: if g_debug then
121: hr_utility.set_location(l_proc, 21);
122: end if;
123: for l_ranking_info in c_ranking_info loop

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

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

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

132: end if;
133: --
134: if p_refresh_pl_dsgn_flag = 'Y' then
135: --
136: ben_batch_utils.WRITE('Refreshing Plan Design');
137: if g_debug then
138: hr_utility.set_location(l_proc, 30);
139: end if;
140: --

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

153: --
154: begin
155: savepoint before_refresh_xchg;
156: if p_refresh_xchg = 'Y' then
157: ben_batch_utils.WRITE('Initialising Refresh');
158: if g_debug then
159: hr_utility.set_location(l_proc, 21);
160: end if;
161: ben_cwb_xchg_pkg.insert_into_ben_cwb_xchg(p_group_pl_id

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

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

Line 171: ben_batch_utils.WRITE(SQLERRM);

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

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

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

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

178: end if;
179: --
180: if p_refresh_person_info_flag = 'Y' then
181: --
182: ben_batch_utils.WRITE('Refreshing Person Info');
183: if g_debug then
184: hr_utility.set_location(l_proc, 60);
185: end if;
186: --

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

202: end if;
203: --
204: if p_refresh_summary_flag = 'Y' then
205: --
206: ben_batch_utils.WRITE('Refreshing Summary');
207: if g_debug then
208: hr_utility.set_location(l_proc, 90);
209: end if;
210: --

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

227: -- if the summary is refreshed then there is no need to consolidate the
228: -- summary
229: if p_consolidate_summary_flag = 'Y' and p_refresh_summary_flag <> 'Y' then
230:
231: ben_batch_utils.WRITE('Consolidating Summary');
232: --
233: if g_debug then
234: hr_utility.set_location(l_proc, 120);
235: end if;

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

251: --
252: end if;
253: --
254: if p_refresh_rate_from_rule = 'Y' then
255: ben_batch_utils.WRITE('Refreshing worksheet rate start date');
256: --
257: -- Put row in fnd_sessions
258: --
259: dt_fndate.change_ses_date

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

258: --
259: dt_fndate.change_ses_date
260: (p_ses_date => l_effective_date,
261: p_commit => l_commit);
262: ben_batch_utils.WRITE ('Changing Session Date: '||l_effective_date);
263: ben_batch_utils.WRITE ('Commit on date : '||l_commit);
264:
265: for rec in c_formula_inputs(p_group_pl_id,l_lf_evt_ocrd_dt) loop
266:

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

259: dt_fndate.change_ses_date
260: (p_ses_date => l_effective_date,
261: p_commit => l_commit);
262: ben_batch_utils.WRITE ('Changing Session Date: '||l_effective_date);
263: ben_batch_utils.WRITE ('Commit on date : '||l_commit);
264:
265: for rec in c_formula_inputs(p_group_pl_id,l_lf_evt_ocrd_dt) loop
266:
267: l_object_version_number := rec.object_version_number;

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

280: ,p_effective_date => l_effective_date
281: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
282: ,p_returned_date => l_returned_date
283: );
284: -- ben_batch_utils.WRITE(rec.group_per_in_ler_id||' '||l_returned_date||' '||rec.oipl_id);
285: if g_debug then
286: hr_utility.set_location(' p_returned_date:'|| l_returned_date, 11);
287: hr_utility.set_location(' p_per_in_ler_id:'|| rec.group_per_in_ler_id, 22);
288: end if;

Line 322: ben_batch_utils.WRITE(SQLERRM);

318: end if;
319: --
320: exception
321: when others then
322: ben_batch_utils.WRITE(SQLERRM);
323: ben_batch_utils.WRITE('Process Errored : Rolled Back');
324: ROLLBACK;
325:
326: end refresh;

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

319: --
320: exception
321: when others then
322: ben_batch_utils.WRITE(SQLERRM);
323: ben_batch_utils.WRITE('Process Errored : Rolled Back');
324: ROLLBACK;
325:
326: end refresh;
327: