APPS.PQH_FR_SYNC_SAL_RATES dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled; -- check for debug enabled or not

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_fr_sync_sal_rates.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled; -- check for debug enabled or not
10: g_status varchar2(1) := 'S'; -- Status variable defaulted to success
11: -- point value for the salary as of the effective date
12: g_sal_point_rate pqh_fr_global_indices_f.basic_salary_rate%TYPE;
13: g_sal_point_currency pqh_fr_global_indices_f.currency_code%TYPE;

Line 72: g_debug := hr_utility.debug_enabled;

68: l_inm9 NUMBER;
69: l_inm10 NUMBER;
70: l_proc varchar2(72) := g_package||'sync_gsp_sal_rt_with_bareme';
71: BEGIN
72: g_debug := hr_utility.debug_enabled;
73: if g_debug then
74: hr_utility.set_location('Entering '||l_proc,10);
75: end if;
76: g_status := 'S';

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

70: l_proc varchar2(72) := g_package||'sync_gsp_sal_rt_with_bareme';
71: BEGIN
72: g_debug := hr_utility.debug_enabled;
73: if g_debug then
74: hr_utility.set_location('Entering '||l_proc,10);
75: end if;
76: g_status := 'S';
77: IF p_commit_mode = 'VALIDATE' THEN
78: SAVEPOINT sync_sal_rates;

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

198: COMMIT;
199: END IF;
200:
201: if g_debug then
202: hr_utility.set_location('Leaving '||l_proc,20);
203: end if;
204:
205: END sync_gsp_sal_rt_with_bareme;
206: --

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

215: WHERE p_effective_date BETWEEN effective_start_date AND effective_end_date;
216: l_proc varchar2(72) := g_package||'.sync_all_rates';
217: BEGIN
218: if g_debug then
219: hr_utility.set_location('Entering '||l_proc,10);
220: end if;
221: FOR l_glb_ind_rec IN csr_all_ib_inms
222: LOOP
223: sync_rates_for_ib(p_effective_date => p_effective_date,

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

224: p_ib => l_glb_ind_rec.gross_index,
225: p_inm => l_glb_ind_rec.increased_index);
226: END LOOP;
227: if g_debug then
228: hr_utility.set_location('Entering '||l_proc,10);
229: end if;
230: EXCEPTION
231: When Others THEN
232: fnd_file.put_line(fnd_file.log,SQLERRM);

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

267: l_proc varchar2(72) := g_package||'.sync_rates_for_ib';
268: BEGIN
269:
270: if g_debug then
271: hr_utility.set_location('Entering '||l_proc,10);
272: end if;
273:
274: FOR l_sp_rec IN csr_prog_points_with_ib
275: LOOP

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

311: p_ib => p_ib,
312: p_inm => p_inm);
313: */
314: if g_debug then
315: hr_utility.set_location('Leaving '||l_proc,20);
316: end if;
317: EXCEPTION
318: When Others THEN
319: fnd_file.put_line(fnd_file.log,SQLERRM);

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

334: AND type_of_record = 'INM';
335: l_proc varchar2(72) := g_package||'.get_bareme_point_value';
336: BEGIN
337: if g_debug then
338: hr_utility.set_location('Entering '||l_proc,10);
339: end if;
340: OPEN csr_point_value;
341: FETCH csr_point_value INTO p_basic_sal_rate,p_bareme_currency_cd;
342: CLOSE csr_point_value;

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

340: OPEN csr_point_value;
341: FETCH csr_point_value INTO p_basic_sal_rate,p_bareme_currency_cd;
342: CLOSE csr_point_value;
343: if g_debug then
344: hr_utility.set_location('Leaving '||l_proc,20);
345: end if;
346: END get_bareme_point_value;
347: --
348: -- ----------------------------------------------------------------------------

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

383: l_new_value NUMBER := 0;
384: l_proc varchar2(72) := g_package||'sync_rates_in_gsp_stage';
385: BEGIN
386: if g_debug then
387: hr_utility.set_location('Entering '||l_proc,10);
388: end if;
389: FOR l_sp_rec IN csr_sp_rows_in_stage
390: LOOP
391: --get the GL currency code and the corresponding currency value for each CET

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

419: WHERE copy_entity_result_id = l_hrrate_rec.copy_entity_result_id;
420: END LOOP;
421: END LOOP;
422: if g_debug then
423: hr_utility.set_location('Leaving '||l_proc,20);
424: end if;
425: EXCEPTION
426: When Others THEN
427: fnd_file.put_line(fnd_file.log,SQLERRM);