DBA Data[Home] [Help]

APPS.PA_FORECAST_DTLS_PKG dependencies on PA_DEBUG

Line 64: PA_DEBUG.Init_err_stack( 'PA_FORECAST_DTLS_PKG.Insert_Rows');

60: l_line_num_reversed PA_PLSQL_DATATYPES.NumTabTyp;
61:
62:
63: BEGIN
64: PA_DEBUG.Init_err_stack( 'PA_FORECAST_DTLS_PKG.Insert_Rows');
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

Line 241: PA_DEBUG.Reset_Err_Stack;

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;
245: WHEN OTHERS THEN

Line 251: p_procedure_name => PA_DEBUG.G_Err_Stack);

247: x_msg_data := SQLERRM;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: FND_MSG_PUB.add_exc_msg
250: (p_pkg_name => 'PA_FORECAST_DTLS_PKG.Insert_Rows',
251: p_procedure_name => PA_DEBUG.G_Err_Stack);
252:
253: RAISE;
254:
255: PA_FORECAST_ITEMS_UTILS.log_message('ERROR ....'||sqlerrm);

Line 316: PA_DEBUG.Init_err_stack( 'PA_FORECAST_DTLS_PKG.Update_Rows');

312:
313:
314: BEGIN
315:
316: PA_DEBUG.Init_err_stack( 'PA_FORECAST_DTLS_PKG.Update_Rows');
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

Line 432: PA_DEBUG.Reset_Err_Stack;

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;
436: WHEN OTHERS THEN

Line 442: p_procedure_name => PA_DEBUG.G_Err_Stack);

438: x_msg_data := SQLERRM;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: FND_MSG_PUB.add_exc_msg
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;