DBA Data[Home] [Help]

APPS.PQH_PTX_UTL dependencies on PQH_PROCESS_BATCH_LOG

Line 93: pqh_process_batch_log.set_context_level (

89: --
90: for l_rec_no in l_warn_tab.first .. l_warn_tab.last
91: loop
92: --
93: pqh_process_batch_log.set_context_level (
94: p_txn_id => l_rec_no,
95: p_txn_table_route_id => null,
96: p_level => 1,
97: p_log_context => 'WARNING');

Line 99: pqh_process_batch_log.insert_log ( p_message_type_cd => 'WARNING',

95: p_txn_table_route_id => null,
96: p_level => 1,
97: p_log_context => 'WARNING');
98: --
99: pqh_process_batch_log.insert_log ( p_message_type_cd => 'WARNING',
100: p_message_text => l_warn_tab(l_rec_no).message_text);
101: end loop;
102: --
103: end if;

Line 1214: pqh_process_batch_log.start_log (

1210: l_name := l_ptx_rec.name;
1211: --
1212: -- Start Position Transaction Log
1213: --
1214: pqh_process_batch_log.start_log (
1215: p_batch_id => p_transaction_id,
1216: p_module_cd => 'POSITION_TRANSACTION' ,
1217: p_log_context => l_ptx_rec.name || ' - ' || l_ptx_rec.position_type ) ;
1218:

Line 2387: pqh_process_batch_log.end_log ;

2383: );
2384: --
2385: log_warnings(p_transaction_id);
2386: --
2387: pqh_process_batch_log.end_log ;
2388: --
2389: hr_utility.set_location('Leaving:'||l_proc, 1000);
2390: return(l_return);
2391: --

Line 2396: pqh_process_batch_log.set_context_level (

2392: EXCEPTION
2393: WHEN OTHERS THEN
2394: begin
2395: --
2396: pqh_process_batch_log.set_context_level (
2397: p_txn_id => p_transaction_id,
2398: p_txn_table_route_id => null,
2399: p_level => 1,
2400: p_log_context => 'ERROR');

Line 2402: pqh_process_batch_log.insert_log ( p_message_type_cd => 'ERROR',

2398: p_txn_table_route_id => null,
2399: p_level => 1,
2400: p_log_context => 'ERROR');
2401: --
2402: pqh_process_batch_log.insert_log ( p_message_type_cd => 'ERROR',
2403: p_message_text => SQLERRM );
2404: --
2405: log_warnings(p_transaction_id);
2406: --

Line 2407: pqh_process_batch_log.end_log ;

2403: p_message_text => SQLERRM );
2404: --
2405: log_warnings(p_transaction_id);
2406: --
2407: pqh_process_batch_log.end_log ;
2408: end;
2409: --
2410: rollback to apply_transaction;
2411: --