APPS.PQH_APPLY_BUDGET dependencies on PQH_PROCESS_BATCH_LOG

Line 122: pqh_process_batch_log.start_log

118: hr_utility.set_location('Worksheet Mode : '||g_worksheet_mode_cd, 6);
119: hr_utility.set_location('Budget ID : '||g_budget_id, 7);
120:
121: -- Start the Log Process
122: pqh_process_batch_log.start_log
123: (
124: p_batch_id => g_worksheet_id,
125: p_module_cd => 'APPLY_BUDGET',
126: p_log_context => g_worksheet_name

Line 131: pqh_process_batch_log.set_context_level

127: );
128:
129: -- set wks id as the top most context level
130: -- set the context before inserting error
131: pqh_process_batch_log.set_context_level
132: (
133: p_txn_id => g_worksheet_id,
134: p_txn_table_route_id => g_table_route_id_wks,
135: p_level => 1,

Line 217: pqh_process_batch_log.end_log;

213: -- Populate the OUT variable p_budget_version_id
214: p_budget_version_id := g_budget_version_id;
215:
216: -- call the end log and stop
217: pqh_process_batch_log.end_log;
218:
219: -- commit the work;
220: -- commit;
221:

Line 227: pqh_process_batch_log.end_log;

223:
224: EXCEPTION
225: WHEN g_error_exception THEN
226: -- call the end log and stop
227: pqh_process_batch_log.end_log;
228: -- call the wf error
229: hr_utility.set_location('txn_cat :'||g_transaction_category_id||l_proc, 10);
230: hr_utility.set_location('txn_id :'||g_root_wks_dtl_id||l_proc, 10);
231: pqh_wf.set_apply_error(p_transaction_category_id => g_transaction_category_id,

Line 355: pqh_process_batch_log.set_context_level

351: p_log_context => l_log_context
352: );
353:
354: -- set the context
355: pqh_process_batch_log.set_context_level
356: (
357: p_txn_id => l_pqh_worksheet_details_rec.worksheet_detail_id,
358: p_txn_table_route_id => g_table_route_id_wdt,
359: p_level => 2,

Line 387: pqh_process_batch_log.set_context_level

383: p_log_context => l_log_context
384: );
385:
386: -- set the context
387: pqh_process_batch_log.set_context_level
388: (
389: p_txn_id => l_pqh_worksheet_periods_rec.worksheet_period_id,
390: p_txn_table_route_id => g_table_route_id_wpr,
391: p_level => 3,

Line 418: pqh_process_batch_log.set_context_level

414: p_log_context => l_log_context
415: );
416:
417: -- set the context
418: pqh_process_batch_log.set_context_level
419: (
420: p_txn_id => l_pqh_worksheet_budget_set_rec.worksheet_budget_set_id,
421: p_txn_table_route_id => g_table_route_id_wst,
422: p_level => 4,

Line 449: pqh_process_batch_log.set_context_level

445: p_log_context => l_log_context
446: );
447:
448: -- set the context
449: pqh_process_batch_log.set_context_level
450: (
451: p_txn_id => l_pqh_worksheet_bdgt_elmnt_rec.worksheet_bdgt_elmnt_id,
452: p_txn_table_route_id => g_table_route_id_wel,
453: p_level => 5,

Line 479: pqh_process_batch_log.set_context_level

475: p_log_context => l_log_context
476: );
477:
478: -- set the context
479: pqh_process_batch_log.set_context_level
480: (
481: p_txn_id => l_pqh_worksheet_fund_srcs_rec.worksheet_fund_src_id,
482: p_txn_table_route_id => g_table_route_id_wfs,
483: p_level => 6,

Line 780: pqh_process_batch_log.insert_log

776: EXCEPTION
777: WHEN others THEN
778: p_budget_version_id_o := null;
779: -- insert error into log table
780: pqh_process_batch_log.insert_log
781: (
782: p_message_type_cd => 'ERROR',
783: p_message_text => SQLERRM
784: );

Line 958: pqh_process_batch_log.insert_log

954:
955: p_budget_detail_id_o := null;
956:
957: -- insert error into log table
958: pqh_process_batch_log.insert_log
959: (
960: p_message_type_cd => 'ERROR',
961: p_message_text => SQLERRM
962: );

Line 1019: pqh_process_batch_log.insert_log

1015:
1016: p_budget_period_id_o := null;
1017:
1018: -- insert error into log table
1019: pqh_process_batch_log.insert_log
1020: (
1021: p_message_type_cd => 'ERROR',
1022: p_message_text => SQLERRM
1023: );

Line 1081: pqh_process_batch_log.insert_log

1077:
1078: p_budget_set_id_o := null;
1079:
1080: -- insert error into log table
1081: pqh_process_batch_log.insert_log
1082: (
1083: p_message_type_cd => 'ERROR',
1084: p_message_text => SQLERRM
1085: );

Line 1129: pqh_process_batch_log.insert_log

1125: WHEN others THEN
1126:
1127: p_budget_element_id_o := null;
1128: -- insert error into log table
1129: pqh_process_batch_log.insert_log
1130: (
1131: p_message_type_cd => 'ERROR',
1132: p_message_text => SQLERRM
1133: );

Line 1181: pqh_process_batch_log.insert_log

1177: WHEN others THEN
1178:
1179: p_budget_fund_src_id_o := null;
1180: -- insert error into log table
1181: pqh_process_batch_log.insert_log
1182: (
1183: p_message_type_cd => 'ERROR',
1184: p_message_text => SQLERRM
1185: );