eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GL_POSTING dependencies on PQH_PROCESS_BATCH_LOG

Line 236: pqh_process_batch_log.set_context_level

232: p_log_context => l_log_context
233: );
234:
235: -- set the context
236: pqh_process_batch_log.set_context_level
237: (
238: p_txn_id => l_budget_details_rec.budget_detail_id,
239: p_txn_table_route_id => g_table_route_id_bdt,
240: p_level => 1,

Line 517: pqh_process_batch_log.start_log

513:
514: hr_utility.set_location('Batch Context : '||l_batch_context,7);
515:
516: -- Start the Log Process
517: pqh_process_batch_log.start_log
518: (
519: p_batch_id => l_batch_id,
520: p_module_cd => 'GL_POSTING',
521: p_log_context => l_batch_context

Line 876: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

872: message_text = l_message_text,
873: txn_table_route_id = g_table_route_id_bvr
874: -- batch_status = 'ERROR',
875: -- batch_end_date = sysdate
876: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
877:
878: -- commit the update work
879: commit;
880: */

Line 1128: pqh_process_batch_log.set_context_level

1124: p_log_context => l_log_context
1125: );
1126:
1127: -- set the context
1128: pqh_process_batch_log.set_context_level
1129: (
1130: p_txn_id => g_period_amt_tab(i).period_id,
1131: p_txn_table_route_id => g_table_route_id_bpr,
1132: p_level => 2,

Line 1142: pqh_process_batch_log.insert_log

1138: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_BUDGET_PERIOD');
1139: l_message_text := FND_MESSAGE.GET;
1140:
1141: -- insert error
1142: pqh_process_batch_log.insert_log
1143: (
1144: p_message_type_cd => 'ERROR',
1145: p_message_text => l_message_text
1146: );

Line 1176: pqh_process_batch_log.set_context_level

1172: p_log_context => l_log_context
1173: );
1174:
1175: -- set the context
1176: pqh_process_batch_log.set_context_level
1177: (
1178: p_txn_id => g_period_amt_tab(i).cost_allocation_keyflex_id,
1179: p_txn_table_route_id => g_table_route_id_bfs,
1180: p_level => 2,

Line 1190: pqh_process_batch_log.insert_log

1186: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_GL_BUDGET_ACCOUNT');
1187: l_message_text := FND_MESSAGE.GET;
1188:
1189: -- insert error
1190: pqh_process_batch_log.insert_log
1191: (
1192: p_message_type_cd => 'ERROR',
1193: p_message_text => l_message_text
1194: );

Line 1848: pqh_process_batch_log.set_context_level

1844:
1845: hr_utility.set_location('Log Context : '||l_log_context,130);
1846:
1847: -- set the context
1848: pqh_process_batch_log.set_context_level
1849: (
1850: p_txn_id => l_packet_id,
1851: p_txn_table_route_id => g_table_route_id_glf,
1852: p_level => 1,

Line 1857: pqh_process_batch_log.insert_log

1853: p_log_context => l_log_context
1854: );
1855:
1856: -- insert error
1857: pqh_process_batch_log.insert_log
1858: (
1859: p_message_type_cd => 'ERROR',
1860: p_message_text => l_packet_status_code||' : '||l_fc_message
1861: );

Line 2806: START WITH process_log_id = pqh_process_batch_log.g_master_process_log_id

2802: CURSOR csr_status (p_message_type_cd IN VARCHAR2 ) IS
2803: SELECT COUNT(*)
2804: FROM pqh_process_log
2805: WHERE message_type_cd = p_message_type_cd
2806: START WITH process_log_id = pqh_process_batch_log.g_master_process_log_id
2807: CONNECT BY PRIOR process_log_id = master_process_log_id;
2808:
2809: CURSOR csr_batch_rec IS
2810: SELECT *

Line 2812: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

2808:
2809: CURSOR csr_batch_rec IS
2810: SELECT *
2811: FROM pqh_process_log
2812: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2813:
2814:
2815: BEGIN
2816:

Line 2874: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

2870: message_text = fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED'),
2871: txn_table_route_id = g_table_route_id_bvr,
2872: batch_status = l_status,
2873: batch_end_date = sysdate
2874: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2875: ELSE
2876: -- there were errors in the batch header record i.e the root node
2877: -- so only update the batch status and end date
2878: UPDATE pqh_process_log

Line 2882: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

2878: UPDATE pqh_process_log
2879: SET batch_status = l_status,
2880: batch_end_date = sysdate,
2881: txn_table_route_id = g_table_route_id_bvr
2882: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2883: END IF;
2884:
2885:
2886:

Line 2928: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;

2924: message_text = p_message_text,
2925: txn_table_route_id = g_table_route_id_bvr
2926: -- batch_status = 'ERROR',
2927: -- batch_end_date = sysdate
2928: WHERE process_log_id = pqh_process_batch_log.g_master_process_log_id;
2929:
2930: /*
2931: commit the autonomous transaction
2932: */

Line 6010: pqh_process_batch_log.set_context_level

6006: (
6007: p_budget_period_id =>l_period_name,
6008: p_log_context => l_log_context
6009: );
6010: pqh_process_batch_log.set_context_level
6011: (
6012: p_txn_id => l_period_name,
6013: p_txn_table_route_id => g_table_route_id_bpr,
6014: p_level => 1,

Line 6019: pqh_process_batch_log.insert_log

6015: p_log_context => l_log_context
6016: );
6017:
6018: -- insert error
6019: pqh_process_batch_log.insert_log
6020: (
6021: p_message_type_cd => 'ERROR',
6022: p_message_text => fnd_message.get
6023: );