APPS.HXT_BATCH_PROCESS dependencies on DBMS_UTILITY

Line 745: hr_utility.trace(dbms_utility.format_error_backtrace);

741: EXCEPTION
742: WHEN others THEN
743: null;
744: -- Bug 10143866
745: hr_utility.trace(dbms_utility.format_error_backtrace);
746:
747: END;
748:
749: fnd_file.put_line (fnd_file.log, 'Assignment# = '|| l_assignment_no||

Line 1179: hr_utility.trace(dbms_utility.format_error_backtrace);

1175: b_we_have_batches := FALSE;
1176: END IF;
1177: -- Bug 10143866
1178: -- Added this logging in case of a NO_DATA_FOUND.
1179: hr_utility.trace(dbms_utility.format_error_backtrace);
1180: hr_utility.trace('Batch '||l_batch_id||' threw a NO_DATA_FOUND');
1181: hr_utility.trace('Backtrace this error to Batch validation log ');
1182: hr_utility.trace('Skipping to next batch ');
1183: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00

Line 1187: hr_utility.trace(dbms_utility.format_error_backtrace);

1183: WHEN g_lookup_not_found THEN --SIR517 PWM 18FEB00
1184: raise g_lookup_not_found ; --propogate to the next level
1185: WHEN g_rollback_error THEN
1186: -- Bug 10143866
1187: hr_utility.trace(dbms_utility.format_error_backtrace);
1188: FND_FILE.put_line(fnd_file.log,'Rollback errored out ');
1189: -- Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
1190: --commit;
1191: raise g_rollback_error;

Line 1194: hr_utility.trace(dbms_utility.format_error_backtrace);

1190: --commit;
1191: raise g_rollback_error;
1192: WHEN OTHERS THEN
1193: -- Bug 10143866
1194: hr_utility.trace(dbms_utility.format_error_backtrace);
1195: Set_Batch_Status(l_date_earned, l_batch_id, 'VE');
1196: Insert_Pay_Batch_Errors( l_batch_id,
1197: 'VE',
1198: sqlerrm,

Line 1305: hr_utility.trace(dbms_utility.format_error_backtrace);

1301: FND_FILE.put_line(fnd_file.log,errbuf);
1302: raise;
1303: WHEN OTHERS THEN
1304: -- Bug 10143866
1305: hr_utility.trace(dbms_utility.format_error_backtrace);
1306: retcode := 2;
1307: FND_MESSAGE.SET_NAME('HXT','HXT_39363_SYSTEM_ERROR');
1308: l_errbuf := FND_MESSAGE.GET;
1309: FND_MESSAGE.CLEAR;

Line 2421: hr_utility.trace(dbms_utility.format_error_backtrace);

2417: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2418: Insert_Pay_Batch_Errors( p_values_rec.batch_id, 'VE', '', l_return);
2419: p_sum_retcode := 3;
2420: -- Bug 10143866
2421: hr_utility.trace(dbms_utility.format_error_backtrace);
2422:
2423: RAISE g_error_ins_batch_lines; --SIR517 PWM 18FEB00 Re-raise the exception for the calling procedure
2424: END dtl_to_BEE;
2425:

Line 2571: hr_utility.trace(dbms_utility.format_error_backtrace);

2567: FND_MESSAGE.SET_TOKEN('SQLERR', sqlerrm);
2568: Insert_Pay_Batch_Errors( p_batch_id, 'VE', '', l_return);
2569: p_sum_retcode := 3;
2570: -- Bug 10143866
2571: hr_utility.trace(dbms_utility.format_error_backtrace);
2572:
2573: END sum_to_mix;
2574: --------------------------------------------------------------------------------
2575: PROCEDURE Transfer_To_Payroll( p_batch_id IN NUMBER

Line 2631: hr_utility.trace(dbms_utility.format_error_backtrace);

2627: '',
2628: l_return);
2629: p_pay_retcode := 3;
2630: -- Bug 10143866
2631: hr_utility.trace(dbms_utility.format_error_backtrace);
2632:
2633: END transfer_to_payroll;
2634: ---------------------------------------------
2635: FUNCTION Call_Gen_Error( p_batch_id IN NUMBER

Line 2691: hr_utility.trace(dbms_utility.format_error_backtrace);

2687: END IF;
2688: EXCEPTION
2689: WHEN OTHERS THEN
2690: -- Bug 10143866
2691: hr_utility.trace(dbms_utility.format_error_backtrace);
2692: RETURN(3);
2693:
2694:
2695: END Get_Transfer_Batch_Status;

Line 2983: hr_utility.trace(dbms_utility.format_error_backtrace);

2979: l_sql_error := sqlerrm;
2980: FND_FILE.put_line(fnd_file.log,'Error: '||sqlerrm);
2981: p_rollback_retcode := 3;
2982: -- Bug 10143866
2983: hr_utility.trace(dbms_utility.format_error_backtrace);
2984: RAISE g_rollback_error;
2985:
2986: END rollback_PayMIX;
2987: -------------------------------------------------------------------

Line 3011: hr_utility.trace(dbms_utility.format_error_backtrace);

3007: EXCEPTION
3008: WHEN OTHERS THEN
3009: p_return_code := 1;
3010: -- Bug 10143866
3011: hr_utility.trace(dbms_utility.format_error_backtrace);
3012:
3013: END Insert_Pay_Batch_Errors;
3014: ------------------------------------------------------------------
3015: -- end SPR C163, C166 by BC