257: if g_debug then
258: hr_utility.set_location('l_proc'|| l_proc, 30);
259: end if;
260: --
261: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
262: 'Before xchg cursor';
263: ben_manage_cwb_life_events.g_error_log_rec.step_number := 61;
264: --
265: for xchg_rec in csr_xchg_recs_bm(p_group_pl_id, p_lf_evt_ocrd_dt) loop
259: end if;
260: --
261: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
262: 'Before xchg cursor';
263: ben_manage_cwb_life_events.g_error_log_rec.step_number := 61;
264: --
265: for xchg_rec in csr_xchg_recs_bm(p_group_pl_id, p_lf_evt_ocrd_dt) loop
266: --
267: if g_debug then
293: when others then
294: null;
295: end;
296: end loop;
297: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
298: 'After xchg cursor';
299: ben_manage_cwb_life_events.g_error_log_rec.step_number := 62;
300: --
301: elsif p_currency is not null then
295: end;
296: end loop;
297: ben_manage_cwb_life_events.g_error_log_rec.calling_proc :=
298: 'After xchg cursor';
299: ben_manage_cwb_life_events.g_error_log_rec.step_number := 62;
300: --
301: elsif p_currency is not null then
302: --
303: --Insert a new exchg rate defined through plan Admin