1574: EXCEPTION
1575: WHEN OTHERS
1576: THEN
1577: -- Bug 9394444
1578: hr_utility.trace(dbms_utility.format_error_backtrace);
1579: IF g_debug
1580: THEN
1581: hr_utility.TRACE ('sqlerrm is ' || SQLERRM);
1582: hr_utility.TRACE ('sqlcode is ' || SQLCODE);
6114: fnd_message.raise_error;
6115: WHEN OTHERS
6116: THEN
6117: -- Bug 9394444
6118: hr_utility.trace(dbms_utility.format_error_backtrace);
6119: audit_transaction
6120: (p_mode => 'I' -- Insert
6121: ,
6122: p_transaction_process_id => g_retrieval_process_id,
8466: EXCEPTION
8467: WHEN OTHERS
8468: THEN
8469: -- Bug 9394444
8470: hr_utility.trace(dbms_utility.format_error_backtrace);
8471: IF g_debug
8472: THEN
8473: hr_utility.TRACE ( 'query EXCEPTION is '
8474: || SUBSTR (SQLERRM, 1, 60)
8850: fnd_message.raise_error;
8851: WHEN OTHERS
8852: THEN
8853: -- Bug 9394444
8854: hr_utility.trace(dbms_utility.format_error_backtrace);
8855: audit_transaction
8856: (p_mode => 'I' -- Insert
8857: ,
8858: p_transaction_process_id => g_retrieval_process_id,