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 1332: --hr_utility.trace_on(NULL, 'REQID');

1328:
1329:
1330: BEGIN
1331:
1332: --hr_utility.trace_on(NULL, 'REQID');
1333: --g_debug := hr_utility.debug_enabled;
1334:
1335: IF g_debug THEN
1336: debug('Entering :'||l_proc_name, 10);

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

1329:
1330: BEGIN
1331:
1332: --hr_utility.trace_on(NULL, 'REQID');
1333: --g_debug := hr_utility.debug_enabled;
1334:
1335: IF g_debug THEN
1336: debug('Entering :'||l_proc_name, 10);
1337: debug('p_udt_id :'||to_char(p_udt_id), 20);

Line 1412: --hr_utility.trace_off;

1408:
1409: IF g_debug THEN
1410: debug('Leaving :'||l_proc_name, 90);
1411: END IF;
1412: --hr_utility.trace_off;
1413:
1414: EXCEPTION
1415: WHEN OTHERS THEN
1416: --hr_utility.trace_off;

Line 1416: --hr_utility.trace_off;

1412: --hr_utility.trace_off;
1413:
1414: EXCEPTION
1415: WHEN OTHERS THEN
1416: --hr_utility.trace_off;
1417: RAISE;
1418: END set_location_code;
1419:
1420: --

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

1702: || 'tpa_extract_process';
1703:
1704: BEGIN -- tpa_extract_process
1705:
1706: --hr_utility.trace_on(NULL, 'REQID');
1707: --g_debug := hr_utility.debug_enabled;
1708:
1709: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1710:

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

1703:
1704: BEGIN -- tpa_extract_process
1705:
1706: --hr_utility.trace_on(NULL, 'REQID');
1707: --g_debug := hr_utility.debug_enabled;
1708:
1709: l_effective_date := fnd_date.canonical_to_date(p_effective_date);
1710:
1711: -- Step 1) Get the master request id

Line 2235: --hr_utility.trace_off;

2231: debug('Completed master process.', 180);
2232: debug('Leaving :'||l_proc_name, 190);
2233: END IF;
2234:
2235: --hr_utility.trace_off;
2236:
2237: EXCEPTION
2238: WHEN OTHERS THEN
2239: IF g_debug THEN