APPS.PA_FORECAST_DTLS_PKG dependencies on PA_FORECAST_ITEMS_UTILS

Line 69: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');

65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: /* Checking for the empty table of record */
68: IF (p_forecast_dtls_tab.count = 0 ) THEN
69: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');
70: RAISE l_empty_tab_record;
71: END IF;
72:
73: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

Line 73: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

69: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');
70: RAISE l_empty_tab_record;
71: END IF;
72:
73: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');
74:
75: FOR l_J IN p_forecast_dtls_tab.FIRST..p_forecast_dtls_tab.LAST LOOP
76: l_forecast_item_id(l_j) := p_forecast_dtls_tab(l_j).forecast_item_id;
77: l_amount_type_id(l_j) := p_forecast_dtls_tab(l_j).amount_type_id;

Line 240: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

236: from pa_forecast_items fi
237: where fi.forecast_item_id = l_forecast_item_id(l_j);
238: -- End Bug 2592045
239:
240: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');
241: PA_DEBUG.Reset_Err_Stack;
242: EXCEPTION
243: WHEN l_empty_tab_record THEN
244: NULL;

Line 255: PA_FORECAST_ITEMS_UTILS.log_message('ERROR ....'||sqlerrm);

251: p_procedure_name => PA_DEBUG.G_Err_Stack);
252:
253: RAISE;
254:
255: PA_FORECAST_ITEMS_UTILS.log_message('ERROR ....'||sqlerrm);
256: END insert_rows;
257:
258: -- This procedure will update the record in pa_forecast_items table
259: -- Input parameters

Line 321: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');

317: x_return_status := FND_API.G_RET_STS_SUCCESS;
318:
319: /* Checking for the empty table of record */
320: IF (p_forecast_dtls_tab.count = 0 ) THEN
321: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');
322: RAISE l_empty_tab_record;
323: END IF;
324:
325: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

Line 325: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');

321: PA_FORECAST_ITEMS_UTILS.log_message('count 0 ... before return ... ');
322: RAISE l_empty_tab_record;
323: END IF;
324:
325: PA_FORECAST_ITEMS_UTILS.log_message('start of the forecast inser row .... ');
326:
327: FOR l_j IN p_forecast_dtls_tab.FIRST..p_forecast_dtls_tab.LAST LOOP
328: l_forecast_item_id(l_j) := p_forecast_dtls_tab(l_j).forecast_item_id;
329: l_amount_type_id(l_j) := p_forecast_dtls_tab(l_j).amount_type_id;

Line 431: PA_FORECAST_ITEMS_UTILS.log_message('end of update row .... ');

427: last_update_login = fnd_global.login_id
428: WHERE forecast_item_id = l_forecast_item_id(l_j)
429: AND line_num = l_line_num(l_j);
430:
431: PA_FORECAST_ITEMS_UTILS.log_message('end of update row .... ');
432: PA_DEBUG.Reset_Err_Stack;
433: EXCEPTION
434: WHEN l_empty_tab_record THEN
435: NULL;

Line 445: PA_FORECAST_ITEMS_UTILS.log_message('ERROR in update row '||sqlerrm);

441: (p_pkg_name => 'PA_FORECAST_DTLS_PKG.Update_Rows',
442: p_procedure_name => PA_DEBUG.G_Err_Stack);
443: RAISE;
444:
445: PA_FORECAST_ITEMS_UTILS.log_message('ERROR in update row '||sqlerrm);
446: END update_rows;
447:
448: END PA_FORECAST_DTLS_PKG;