DBA Data[Home] [Help]

APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on DBMS_UTILITY

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

266: RETURN l_display_value;
267: EXCEPTION
268: WHEN OTHERS
269: THEN
270: hr_utility.trace(dbms_utility.format_error_backtrace);
271: hr_utility.set_message ('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
272: hr_utility.set_message_token
273: ('UNIT_OF_MEASURE',
274: hr_general.decode_lookup ('UNITS',

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

1187: RETURN l_new_batch;
1188: EXCEPTION
1189: WHEN OTHERS
1190: THEN
1191: hr_utility.trace(dbms_utility.format_error_backtrace);
1192: fnd_message.set_name (g_hxc_app_short_name,
1193: 'HXC_HRPAY_RET_BATCH_HDR_API'
1194: );
1195: set_transaction_detail (p_tbb_idx => p_det_tbb_idx,

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

1531: hr_utility.set_location ('Leaving:' || l_proc, 100);
1532: EXCEPTION
1533: WHEN OTHERS
1534: THEN
1535: hr_utility.trace(dbms_utility.format_error_backtrace);
1536: fnd_message.set_name (g_hxc_app_short_name,
1537: 'HXC_HRPAY_RET_BATCH_LINE_API'
1538: );
1539: set_transaction_detail (p_tbb_idx => p_det_tbb_idx,

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

1890: WHEN OTHERS
1891: THEN
1892: set_sqlerror_trx_detail (p_tbb_idx => l_det_tbb_idx);
1893: l_det_tbb_idx := p_tbb_tbl.NEXT (l_det_tbb_idx);
1894: hr_utility.trace(dbms_utility.format_error_backtrace);
1895: END processing_tbb;
1896: END LOOP process_all_detail_tbb;
1897:
1898: set_successfull_trx (g_bee_retrieval_process);

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

2230: EXCEPTION
2231: WHEN OTHERS
2232: THEN
2233:
2234: hr_utility.trace(dbms_utility.format_error_backtrace);
2235: set_sqlerror_trx (g_bee_retrieval_process);
2236: hxc_generic_retrieval_utils.set_parent_statuses;
2237: hxc_generic_retrieval_pkg.update_transaction_status
2238: (p_process => g_bee_retrieval_process,

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

2253: THEN
2254: fnd_message.raise_error;
2255: END IF;
2256: END IF;
2257: hr_utility.trace(dbms_utility.format_error_backtrace);
2258:
2259: RETURN;
2260: END process_non_otlr_employees;
2261:

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

2748: EXCEPTION
2749: WHEN OTHERS THEN
2750: l_sqlmsg := SUBSTR(SQLERRM,1,1500)||SQLCODE;
2751: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);
2752: hr_utility.trace(dbms_utility.format_error_backtrace);
2753: RAISE;
2754:
2755: END;
2756:

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

2901: NULL;
2902: WHEN others THEN
2903: l_sqlmsg := SUBSTR(SQLERRM,1,1500)||SQLCODE;
2904: hr_utility.trace('Sql error in make_adjustments :'||l_sqlmsg);
2905: hr_utility.trace(dbms_utility.format_error_backtrace);
2906: RAISE;
2907: END;
2908:
2909: