APPS.BEN_CWB_XCHG_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_xchg_pkb.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: g_xchg_not_found varchar2(1) := 'N'; --global var to chk xchg rate
11: -- --------------------------------------------------------------------------
12: -- |----------------------< insert_into_ben_cwb_xchg >----------------------|
13: -- --------------------------------------------------------------------------

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

199: --
200: begin
201: --
202: if g_debug then
203: hr_utility.set_location('Entering:'|| l_proc, 10);
204: end if;
205: --
206: -- for the group_plan record
207:

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

213: -- check for refresh
214: if p_refresh_always = 'Y' then
215: --
216: if g_debug then
217: hr_utility.set_location('l_proc'|| l_proc, 20);
218: end if;
219: --
220: delete from ben_cwb_xchg
221: where group_pl_id = p_group_pl_id

Line 227: hr_utility.set_location(l_proc, 25);

223: --
224: for xchg_rec in csr_xchg_recs_rf(p_group_pl_id, p_lf_evt_ocrd_dt) loop
225: --
226: if g_debug then
227: hr_utility.set_location(l_proc, 25);
228: end if;
229: --
230: l_xchg_rec.currency := xchg_rec.lCurrency;
231: l_xchg_rec.group_pl_id := p_group_pl_id;

Line 258: hr_utility.set_location('l_proc'|| l_proc, 30);

254: end loop;
255: elsif p_refresh_always = 'N' then
256: --when refresh is N
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';

Line 268: hr_utility.set_location(l_proc, 35);

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
268: hr_utility.set_location(l_proc, 35);
269: end if;
270: --
271: l_xchg_rec.currency := xchg_rec.lCurrency;
272: l_xchg_rec.group_pl_id := p_group_pl_id;

Line 308: hr_utility.set_location('l_proc'|| l_proc, 40);

304: l_currency := p_currency;
305: l_xchg_rate := p_xchg_rate;
306: --
307: if g_debug then
308: hr_utility.set_location('l_proc'|| l_proc, 40);
309: end if;
310:
311: --
312: --if currency already exists

Line 345: hr_utility.set_location(' Leaving:'|| l_proc, 99);

341:
342: end if;
343: --
344: if g_debug then
345: hr_utility.set_location(' Leaving:'|| l_proc, 99);
346: end if;
347: --
348: end; -- of procedure insert_into_ben_cwb_xchg
349: --

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

370: l_proc varchar2(72) := g_package||'refresh_xchg_rates';
371: begin
372: --
373: if g_debug then
374: hr_utility.set_location('Entering:'|| l_proc, 10);
375: end if;
376: --
377:
378: --resetting value of global var

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

388: null);
389:
390: --
391: if g_debug then
392: hr_utility.set_location('l_proc'|| l_proc, 20);
393: end if;
394: --
395:
396: --Check for any null exchg rate returned

Line 404: hr_utility.set_location('Leaving:'|| l_proc, 99);

400: --
401:
402: --
403: if g_debug then
404: hr_utility.set_location('Leaving:'|| l_proc, 99);
405: end if;
406: --
407: end; -- of procedure refresh_xchg_rates
408: end BEN_CWB_XCHG_PKG;