APPS.PQH_COMMITMENT_POSTING dependencies on PQH_PROCESS_BATCH_LOG

Line 287: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

283: UPDATE pqh_process_log
284: SET message_type_cd = 'ERROR',
285: message_text = p_message_text,
286: txn_table_route_id = g_table_route_id_bvr
287: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
288: --
289: -- commit the autonomous transaction
290: --
291: commit;

Line 438: pqh_process_batch_log.start_log

434: hr_utility.set_location('Batch Context : '||l_batch_context,7);
435: --
436: -- Start the Log Process
437: --
438: pqh_process_batch_log.start_log
439: (
440: p_batch_id => l_batch_id,
441: p_module_cd => 'COMMITMENT_GL_POSTING',
442: p_log_context => l_batch_context

Line 572: pqh_process_batch_log.start_log

568: hr_utility.set_location('Batch Context : '||l_batch_context,7);
569: --
570: -- Start the Log Process
571: --
572: pqh_process_batch_log.start_log
573: (
574: p_batch_id => l_batch_id,
575: p_module_cd => 'COMMITMENT_GL_POSTING',
576: p_log_context => l_batch_context

Line 2082: pqh_process_batch_log.set_context_level

2078: );
2079: --
2080: -- set the context
2081: --
2082: pqh_process_batch_log.set_context_level
2083: (
2084: p_txn_id => g_period_amt_tab(i).period_id,
2085: p_txn_table_route_id => g_table_route_id_bpr,
2086: p_level => 2,

Line 2097: pqh_process_batch_log.insert_log

2093: l_message_text := FND_MESSAGE.GET;
2094: --
2095: -- insert error into process log
2096: --
2097: pqh_process_batch_log.insert_log
2098: (
2099: p_message_type_cd => 'ERROR',
2100: p_message_text => l_message_text
2101: );

Line 2142: pqh_process_batch_log.set_context_level

2138: );
2139: --
2140: -- set the context
2141: --
2142: pqh_process_batch_log.set_context_level
2143: (
2144: p_txn_id => g_period_amt_tab(i).cost_allocation_keyflex_id,
2145: p_txn_table_route_id => g_table_route_id_bfs,
2146: p_level => 2,

Line 2155: pqh_process_batch_log.insert_log

2151: l_message_text := FND_MESSAGE.GET;
2152: --
2153: -- insert error
2154: --
2155: pqh_process_batch_log.insert_log
2156: (
2157: p_message_type_cd => 'ERROR',
2158: p_message_text => l_message_text
2159: );

Line 2889: pqh_process_batch_log.set_context_level

2885: hr_utility.set_location('Log Context : '||l_log_context,130);
2886: --
2887: -- set the context
2888: --
2889: pqh_process_batch_log.set_context_level
2890: (
2891: p_txn_id => l_packet_id,
2892: p_txn_table_route_id => g_table_route_id_glf,
2893: p_level => 1,

Line 2899: pqh_process_batch_log.insert_log

2895: );
2896: --
2897: -- insert error
2898: --
2899: pqh_process_batch_log.insert_log
2900: (
2901: p_message_type_cd => 'ERROR',
2902: p_message_text => l_packet_status_code||' : '||l_fc_message
2903: );

Line 3721: pqh_process_batch_log.set_context_level

3717: );
3718: --
3719: -- set the context
3720: --
3721: pqh_process_batch_log.set_context_level
3722: (
3723: p_txn_id => l_budget_details_rec.budget_detail_id,
3724: p_txn_table_route_id => g_table_route_id_bdt,
3725: p_level => 1,

Line 5043: pqh_process_batch_log.set_context_level

5039: (
5040: p_budget_period_id =>l_period_name,
5041: p_log_context => l_log_context
5042: );
5043: pqh_process_batch_log.set_context_level
5044: (
5045: p_txn_id => l_period_name,
5046: p_txn_table_route_id => g_table_route_id_bpr,
5047: p_level => 1,

Line 5052: pqh_process_batch_log.insert_log

5048: p_log_context => l_log_context
5049: );
5050:
5051: -- insert error
5052: pqh_process_batch_log.insert_log
5053: (
5054: p_message_type_cd => 'ERROR',
5055: p_message_text => fnd_message.get
5056: );