APPS.HXT_RETRO_PROCESS dependencies on HR_UTILITY

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXT_RETRO_PROCESS AS
2: /* $Header: hxtrprc.pkb 120.7 2011/08/22 09:53:58 asrajago ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: FUNCTION Call_Gen_Error( p_batch_id IN NUMBER
5: , p_location IN VARCHAR2
6: , p_error_text IN VARCHAR2
7: , p_oracle_error_text IN VARCHAR2 default NULL ) RETURN NUMBER;

Line 160: g_debug := hr_utility.debug_enabled;

156:
157: /********Bug: 4620315 **********/
158:
159: BEGIN
160: g_debug := hr_utility.debug_enabled;
161: -- commented out. using sysdate view, now. RTF
162: -- insert into fnd_sessions values (userenv('SESSIONID'), trunc(SYSDATE));
163: -- commit;
164: --HXT_UTIL.DEBUG('Start process.');-- debug only --HXT115

Line 295: hr_utility.trace('Populating del_empty_batches record: '||'batchid: '||batch_rec.batch_id||

291:
292: IF (p_merge_flag = '1' and l_loop_flag = TRUE) THEN
293:
294: IF g_debug THEN
295: hr_utility.trace('Populating del_empty_batches record: '||'batchid: '||batch_rec.batch_id||
296: ' ovn '||batch_rec.object_version_number);
297: END IF;
298:
299: l_cnt := NVL(l_del_empty_batches.LAST,0) +1;

Line 463: -- hr_utility.trace(dbms_utility.format_error_backtrace);

459: -- Bug 10143866
460: -- Added this logging in case of a NO_DATA_FOUND.
461: -- For cts having RDBMS 10g onwards, uncomment the below line to
462: -- backtrace to the exact spot.
463: -- hr_utility.trace(dbms_utility.format_error_backtrace);
464: hr_utility.trace('Batch '||batch_rec.batch_id||' threw a NO_DATA_FOUND');
465: hr_utility.trace('Backtrace this error to Batch validation log ');
466: hr_utility.trace('Skipping to next batch ');
467: WHEN OTHERS THEN

Line 464: hr_utility.trace('Batch '||batch_rec.batch_id||' threw a NO_DATA_FOUND');

460: -- Added this logging in case of a NO_DATA_FOUND.
461: -- For cts having RDBMS 10g onwards, uncomment the below line to
462: -- backtrace to the exact spot.
463: -- hr_utility.trace(dbms_utility.format_error_backtrace);
464: hr_utility.trace('Batch '||batch_rec.batch_id||' threw a NO_DATA_FOUND');
465: hr_utility.trace('Backtrace this error to Batch validation log ');
466: hr_utility.trace('Skipping to next batch ');
467: WHEN OTHERS THEN
468: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');

Line 465: hr_utility.trace('Backtrace this error to Batch validation log ');

461: -- For cts having RDBMS 10g onwards, uncomment the below line to
462: -- backtrace to the exact spot.
463: -- hr_utility.trace(dbms_utility.format_error_backtrace);
464: hr_utility.trace('Batch '||batch_rec.batch_id||' threw a NO_DATA_FOUND');
465: hr_utility.trace('Backtrace this error to Batch validation log ');
466: hr_utility.trace('Skipping to next batch ');
467: WHEN OTHERS THEN
468: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
469: HXT_UTIL.DEBUG('Other exception.'||sqlerrm);

Line 466: hr_utility.trace('Skipping to next batch ');

462: -- backtrace to the exact spot.
463: -- hr_utility.trace(dbms_utility.format_error_backtrace);
464: hr_utility.trace('Batch '||batch_rec.batch_id||' threw a NO_DATA_FOUND');
465: hr_utility.trace('Backtrace this error to Batch validation log ');
466: hr_utility.trace('Skipping to next batch ');
467: WHEN OTHERS THEN
468: HXT_BATCH_PROCESS.Set_batch_status(l_date_earned, batch_rec.batch_id, 'VE');
469: HXT_UTIL.DEBUG('Other exception.'||sqlerrm);
470: l_index := null;

Line 548: hr_utility.trace('before calling merge_batches proc');

544:
545: IF p_merge_flag = '1' and p_process_mode = 'V' THEN
546:
547: IF g_debug THEN
548: hr_utility.trace('before calling merge_batches proc');
549: END IF;
550:
551: HXT_BATCH_PROCESS.merge_batches (p_merge_batch_name,
552: l_merge_batches,