APPS.PQP_GB_TP_EXT_PROCESS dependencies on HR_UTILITY

Line 375: IF SQLCODE <> hr_utility.hr_error_number

371: p_dtl_count := NULL;
372: p_trl_count := NULL;
373: p_per_count := NULL;
374: p_err_count := NULL;
375: IF SQLCODE <> hr_utility.hr_error_number
376: THEN
377: debug_others (l_proc_name, l_proc_step);
378: IF g_debug
379: THEN

Line 1322: --hr_utility.trace_on(NULL, 'REQID');

1318:
1319:
1320: BEGIN
1321:
1322: --hr_utility.trace_on(NULL, 'REQID');
1323: --g_debug := hr_utility.debug_enabled;
1324:
1325: IF g_debug THEN
1326: debug('Entering :'||l_proc_name, 10);

Line 1323: --g_debug := hr_utility.debug_enabled;

1319:
1320: BEGIN
1321:
1322: --hr_utility.trace_on(NULL, 'REQID');
1323: --g_debug := hr_utility.debug_enabled;
1324:
1325: IF g_debug THEN
1326: debug('Entering :'||l_proc_name, 10);
1327: debug('p_udt_id :'||to_char(p_udt_id), 20);

Line 1402: --hr_utility.trace_off;

1398:
1399: IF g_debug THEN
1400: debug('Leaving :'||l_proc_name, 90);
1401: END IF;
1402: --hr_utility.trace_off;
1403:
1404: EXCEPTION
1405: WHEN OTHERS THEN
1406: --hr_utility.trace_off;

Line 1406: --hr_utility.trace_off;

1402: --hr_utility.trace_off;
1403:
1404: EXCEPTION
1405: WHEN OTHERS THEN
1406: --hr_utility.trace_off;
1407: RAISE;
1408: END set_location_code;
1409:
1410: --

Line 1696: --hr_utility.trace_on(NULL, 'REQID');

1692: || 'tpa_extract_process';
1693:
1694: BEGIN -- tpa_extract_process
1695:
1696: --hr_utility.trace_on(NULL, 'REQID');
1697: --g_debug := hr_utility.debug_enabled;
1698:
1699: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1700:

Line 1697: --g_debug := hr_utility.debug_enabled;

1693:
1694: BEGIN -- tpa_extract_process
1695:
1696: --hr_utility.trace_on(NULL, 'REQID');
1697: --g_debug := hr_utility.debug_enabled;
1698:
1699: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1700:
1701: -- Step 1) Get the master request id

Line 2225: --hr_utility.trace_off;

2221: debug('Completed master process.', 180);
2222: debug('Leaving :'||l_proc_name, 190);
2223: END IF;
2224:
2225: --hr_utility.trace_off;
2226:
2227: EXCEPTION
2228: WHEN OTHERS THEN
2229: IF g_debug THEN