APPS.OZF_MULTI_CURR_MIG_PVT dependencies on OZF_UTILITY_PVT

Line 218: ozf_utility_pvt.write_conc_log (' <===> mandatory columns are updated for <===>'||l_row_count||' rows updated');

214: AND plan_currency_code IS NULL;
215:
216: IF p_debug_flag = 'Y' THEN
217: l_row_count := sql%rowcount;
218: ozf_utility_pvt.write_conc_log (' <===> mandatory columns are updated for <===>'||l_row_count||' rows updated');
219: END IF;
220: /* Check if any rows are updated by the first sql. If Yes (first time when conc. prog is run), then generate the
221: report and re-calculate the 3 columns for which the definition has been modified
222: 1) plan_curr_amount

Line 233: ozf_utility_pvt.write_conc_log (' <===> Report Header Added <===>');

229: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_report_header_rec.column_val);
230: CLOSE c_report_header;
231:
232: IF p_debug_flag = 'Y' THEN
233: ozf_utility_pvt.write_conc_log (' <===> Report Header Added <===>');
234: END IF;
235:
236: OPEN c_report_offers;
237: FETCH c_report_offers BULK COLLECT INTO l_reportOfferRecTbl,l_planIdTbl;

Line 246: ozf_utility_pvt.write_conc_log (' <===> Report Completed <===>');

242: END LOOP;
243: CLOSE c_report_offers;
244:
245: IF p_debug_flag = 'Y' THEN
246: ozf_utility_pvt.write_conc_log (' <===> Report Completed <===>');
247: END IF;
248:
249: INSERT INTO OZF_MULTI_CURR_UTIL_BCK (SELECT utilization_id,
250: plan_curr_amount,

Line 260: ozf_utility_pvt.write_conc_log (' <===> Backup Completed <===>'||sql%rowcount||' rows inserted');

256: AND plan_type='OFFR'
257: AND last_updated_by = -2);
258:
259: IF p_debug_flag = 'Y' THEN
260: ozf_utility_pvt.write_conc_log (' <===> Backup Completed <===>'||sql%rowcount||' rows inserted');
261: END IF;
262:
263: UPDATE /* PARALLEL */ ozf_funds_utilized_all_b
264: SET plan_curr_amount = gl_currency_api.convert_closest_amount_sql(fund_request_currency_code,plan_currency_code,

Line 277: ozf_utility_pvt.write_conc_log (' <===> Update for plan_curr_amount/remaining exchange_rate Completed <===>'||sql%rowcount||' rows updated');

273: AND plan_type='OFFR'
274: AND last_updated_by = -2;
275:
276: IF p_debug_flag = 'Y' THEN
277: ozf_utility_pvt.write_conc_log (' <===> Update for plan_curr_amount/remaining exchange_rate Completed <===>'||sql%rowcount||' rows updated');
278: END IF;
279:
280: END IF;
281:

Line 286: ozf_utility_pvt.write_conc_log(' Mig_Utilization_Records: exception '||SQLERRM);

282:
283: EXCEPTION
284: WHEN fnd_api.g_exc_error THEN
285: ROLLBACK TO Mig_Utilization_Records;
286: ozf_utility_pvt.write_conc_log(' Mig_Utilization_Records: exception '||SQLERRM);
287: fnd_msg_pub.count_and_get (
288: p_count=> l_msg_count,
289: p_data=> l_msg_data,
290: p_encoded=> fnd_api.g_false

Line 295: ozf_utility_pvt.write_conc_log(' Mig_Utilization_Records: exception2 '||SQLERRM);

291: );
292:
293: WHEN fnd_api.g_exc_unexpected_error THEN
294: ROLLBACK TO Mig_Utilization_Records;
295: ozf_utility_pvt.write_conc_log(' Mig_Utilization_Records: exception2 '||SQLERRM);
296: fnd_msg_pub.count_and_get (
297: p_count=> l_msg_count,
298: p_data=> l_msg_data,
299: p_encoded=>fnd_api.g_false

Line 303: ozf_utility_pvt.write_conc_log(' Mig_Utilization_Records: exception '||SQLERRM);

299: p_encoded=>fnd_api.g_false
300: );
301: WHEN OTHERS THEN
302: ROLLBACK TO Mig_Utilization_Records;
303: ozf_utility_pvt.write_conc_log(' Mig_Utilization_Records: exception '||SQLERRM);
304: fnd_msg_pub.count_and_get (
305: p_count=> l_msg_count,
306: p_data=> l_msg_data,
307: p_encoded=> fnd_api.g_false

Line 310: ozf_utility_pvt.write_conc_log(SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254));

306: p_data=> l_msg_data,
307: p_encoded=> fnd_api.g_false
308: );
309: FOR I IN 1..l_msg_count LOOP
310: ozf_utility_pvt.write_conc_log(SUBSTR(FND_MSG_PUB.GET(P_MSG_INDEX => I, P_ENCODED => 'F'), 1, 254));
311: END LOOP;
312:
313: END Mig_Utilization_Records;
314: