DBA Data[Home] [Help]

APPS.PQH_GENERIC dependencies on PQH_PROCESS_BATCH_LOG

Line 387: pqh_process_batch_log.start_log (p_batch_id => p_copy_entity_txn_id,

383: end loop;
384: --
385: -- start error log
386: --
387: pqh_process_batch_log.start_log (p_batch_id => p_copy_entity_txn_id,
388: p_module_cd => nvl(l_transaction_short_name, 'ERROR- GEN CPY') ,
389: p_log_context => l_name ) ;
390: --
391: hr_utility.set_location(' '||l_proc ||' rec2', 5);

Line 402: pqh_process_batch_log.set_context_level (p_txn_id => rec2.src_copy_entity_result_id,

398: --
399: pqh_generic.g_result_id := rec2.copy_entity_result_id ;
400: l_reset_flag := 'Y' ;
401: --
402: pqh_process_batch_log.set_context_level (p_txn_id => rec2.src_copy_entity_result_id,
403: p_txn_table_route_id => l_cer1,-- trt for source
404: p_level => 1,
405: p_log_context => rec2.src_information1 );
406: --

Line 515: pqh_process_batch_log.set_context_level (p_txn_id => rec2.copy_entity_result_id,

511: , p_post_copy_function_name => l_post_copy_function_name );
512: --
513: for rec6 in c_tab_details(l_master_table_route_id) loop
514: --
515: pqh_process_batch_log.set_context_level (p_txn_id => rec2.copy_entity_result_id,
516: p_txn_table_route_id => l_cer2 , -- trt for target
517: p_level => 2,
518: p_log_context => rec2.information1 );
519: begin

Line 592: pqh_process_batch_log.end_log ;

588: end loop; --c_target
589: --
590: hr_utility.set_location('Leaving:'||l_proc, 10);
591: --
592: pqh_process_batch_log.end_log ;
593: --
594: End generic_fn;
595: --
596: -- Generic Function to be called from concurrent program

Line 1480: pqh_process_batch_log.set_context_level (p_txn_id => nvl(p_err_key, l_copy_entity_result_id),

1476: hr_utility.trace('Err :'||substr(v_err,255,255));
1477: hr_utility.trace('Err :'||substr(v_err,510,255));
1478: --
1479: if nvl(pqh_generic.g_level,1) = 2 then
1480: pqh_process_batch_log.set_context_level (p_txn_id => nvl(p_err_key, l_copy_entity_result_id),
1481: p_txn_table_route_id => p_table_route_id,
1482: p_level => 3,
1483: p_log_context => p_err_key);
1484: --

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

1481: p_txn_table_route_id => p_table_route_id,
1482: p_level => 3,
1483: p_log_context => p_err_key);
1484: --
1485: pqh_process_batch_log.insert_log ( p_message_type_cd => 'ERROR',
1486: p_message_text => pqh_generic.v_err );
1487: --
1488: l_status := 'DPT_ERR' ;
1489: update pqh_copy_entity_results

Line 1496: -- pqh_process_batch_log.set_context_level (p_txn_id => l_copy_entity_result_id,

1492: where copy_entity_result_id = l_copy_entity_result_id;
1493: else
1494: -- for target records the context is already set before starting the dyn calls
1495: --
1496: -- pqh_process_batch_log.set_context_level (p_txn_id => l_copy_entity_result_id,
1497: -- p_txn_table_route_id => p_table_route_id,
1498: -- p_level => 2,
1499: -- p_log_context => l_copy_entity_result_id );
1500: --

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

1497: -- p_txn_table_route_id => p_table_route_id,
1498: -- p_level => 2,
1499: -- p_log_context => l_copy_entity_result_id );
1500: --
1501: pqh_process_batch_log.insert_log ( p_message_type_cd => 'ERROR',
1502: p_message_text => pqh_generic.v_err );
1503: --
1504: l_status := 'TGT_ERR' ;
1505: update pqh_copy_entity_results