APPS.PQH_BUDGET_DATA_MIGRATION dependencies on PQH_PROCESS_BATCH_LOG

Line 100: pqh_process_batch_log.start_log

96: FETCH per_budget_cur INTO l_per_budget_rec;
97: EXIT WHEN per_budget_cur%NOTFOUND;
98:
99: -- Start the Log Process
100: pqh_process_batch_log.start_log
101: (
102: p_batch_id => l_per_budget_rec.budget_id,
103: p_module_cd => 'MIGRATE_BUDGETS',
104: p_log_context => l_per_budget_rec.name

Line 115: pqh_process_batch_log.set_context_level

111: p_log_context => l_log_context
112: );
113:
114: -- set the context
115: pqh_process_batch_log.set_context_level
116: (
117: p_txn_id => l_per_budget_rec.budget_id,
118: p_txn_table_route_id => g_table_route_id_p_bgt,
119: p_level => 1,

Line 153: pqh_process_batch_log.set_context_level

149: p_log_context => l_log_context
150: );
151:
152: -- set the context
153: pqh_process_batch_log.set_context_level
154: (
155: p_txn_id => l_per_budget_ver_rec.budget_version_id,
156: p_txn_table_route_id => g_table_route_id_p_bvr,
157: p_level => 2,

Line 184: pqh_process_batch_log.set_context_level

180: p_log_context => l_log_context
181: );
182:
183: -- set the context
184: pqh_process_batch_log.set_context_level
185: (
186: p_txn_id => l_per_budget_elmnt_rec.budget_element_id,
187: p_txn_table_route_id => g_table_route_id_p_bdt,
188: p_level => 3,

Line 217: pqh_process_batch_log.set_context_level

213: p_log_context => l_log_context
214: );
215:
216: -- set the context
217: pqh_process_batch_log.set_context_level
218: (
219: p_txn_id => l_per_budget_val_rec.budget_value_id,
220: p_txn_table_route_id => g_table_route_id_p_bpr,
221: p_level => 4,

Line 259: pqh_process_batch_log.end_log;

255:
256:
257:
258: -- end the log for thr current budget id
259: pqh_process_batch_log.end_log;
260:
261: END LOOP; -- loop 1
262: CLOSE per_budget_cur;
263:

Line 277: pqh_process_batch_log.end_log;

273:
274: EXCEPTION
275: WHEN g_error_exception THEN
276: -- call the end log and stop
277: pqh_process_batch_log.end_log;
278: WHEN others THEN
279: raise;
280: END extract_data;
281:

Line 437: pqh_process_batch_log.insert_log

433:
434: p_budget_id_o := null;
435: p_tot_budget_val_o := null;
436: -- insert error into log table
437: pqh_process_batch_log.insert_log
438: (
439: p_message_type_cd => 'ERROR',
440: p_message_text => SQLERRM
441: );

Line 509: pqh_process_batch_log.insert_log

505: EXCEPTION
506: WHEN others THEN
507: p_budget_version_id_o := null;
508: -- insert error into log table
509: pqh_process_batch_log.insert_log
510: (
511: p_message_type_cd => 'ERROR',
512: p_message_text => SQLERRM
513: );

Line 593: pqh_process_batch_log.insert_log

589: WHEN others THEN
590: p_budget_detail_id_o := null;
591: p_budget_unit1_value_o := null;
592: -- insert error into log table
593: pqh_process_batch_log.insert_log
594: (
595: p_message_type_cd => 'ERROR',
596: p_message_text => SQLERRM
597: );

Line 666: pqh_process_batch_log.insert_log

662: EXCEPTION
663: WHEN others THEN
664: p_budget_period_id_o := null;
665: -- insert error into log table
666: pqh_process_batch_log.insert_log
667: (
668: p_message_type_cd => 'ERROR',
669: p_message_text => SQLERRM
670: );

Line 1555: pqh_process_batch_log.insert_log

1551: FND_MESSAGE.SET_NAME('PQH','PQH_INVALID_PER_BUDGET');
1552: l_message_text_out := FND_MESSAGE.GET;
1553:
1554: -- insert error into log table
1555: pqh_process_batch_log.insert_log
1556: (
1557: p_message_type_cd => 'ERROR',
1558: p_message_text => l_message_text_out
1559: );