DBA Data[Home] [Help]

APPS.PA_FORECAST_HDR_PKG dependencies on PA_DEBUG

Line 80: PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Insert_Rows');

76: /* Bug 2390990 End */
77:
78: BEGIN
79:
80: PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Insert_Rows');
81:
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: /* Checking for the empty table of record */

Line 369: PA_DEBUG.Reset_Err_Stack;

365: trunc(sysdate) ,
366: 'N');
367:
368: -- PA_FORECAST_ITEMS_UTLS.log_message('end of the forecast inser row .... ');
369: PA_DEBUG.Reset_Err_Stack;
370: EXCEPTION
371: WHEN l_empty_tab_record THEN
372: NULL;
373: /* Bug 2390990 Begin */

Line 420: p_procedure_name => PA_DEBUG.G_Err_Stack);

416: x_msg_data := SQLERRM;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: FND_MSG_PUB.add_exc_msg
419: (p_pkg_name => 'PA_FORECAST_HDR_PKG.Insert_Rows',
420: p_procedure_name => PA_DEBUG.G_Err_Stack);
421:
422: RAISE;
423:
424: -- PA_FORECAST_ITEMS_UTLS.log_message('ERROR ....'||sqlerrm);

Line 501: PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Update_Rows');

497: /* Bug 2390990 End */
498:
499:
500: BEGIN
501: PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Update_Rows');
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503:
504: /* Checking for the empty table of record */
505: IF (nvl(p_forecast_hdr_tab.count,0) = 0 ) THEN

Line 748: PA_DEBUG.Reset_Err_Stack;

744: EXPFUNC_TRANSFER_PRICE = null
745: WHERE forecast_item_id = l_forecast_item_id(l_j);
746:
747: PA_FORECASTITEM_PVT.print_message('end of update row .... ');
748: PA_DEBUG.Reset_Err_Stack;
749: EXCEPTION
750: WHEN l_empty_tab_record THEN
751: NULL;
752: /* Bug 2390990 Begin */

Line 800: p_procedure_name => PA_DEBUG.G_Err_Stack);

796: x_msg_data := SQLERRM;
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: FND_MSG_PUB.add_exc_msg
799: (p_pkg_name => 'PA_FORECAST_HDR_PKG.Update_Rows',
800: p_procedure_name => PA_DEBUG.G_Err_Stack);
801: RAISE;
802:
803:
804: PA_FORECASTITEM_PVT.print_message('ERROR in update row '||sqlerrm);

Line 823: PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Update_Schedule_Rows');

819: l_forecast_txn_version_number PA_PLSQL_DATATYPES.NumTabTyp;
820:
821:
822: BEGIN
823: PA_DEBUG.Init_err_stack( 'PA_FORECAST_HDR_PKG.Update_Schedule_Rows');
824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825:
826: /* Checking for the empty table of record */
827: IF (nvl(p_schedule_tab.count,0) = 0 ) THEN

Line 854: PA_DEBUG.Reset_Err_Stack;

850: WHERE schedule_id = l_schedule_id(l_j)
851: AND forecast_txn_version_number = l_forecast_txn_version_number(l_j);
852:
853: PA_FORECASTITEM_PVT.print_message('after update');
854: PA_DEBUG.Reset_Err_Stack;
855: -- PA_FORECASTITEM_PVT.print_message('end of update schedule row .... ');
856: EXCEPTION
857: WHEN l_empty_tab_record THEN
858: NULL;

Line 865: p_procedure_name => PA_DEBUG.G_Err_Stack);

861: x_msg_data := SQLERRM;
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
863: FND_MSG_PUB.add_exc_msg
864: (p_pkg_name => 'PA_FORECAST_HDR_PKG.Update_Schedule_Rows',
865: p_procedure_name => PA_DEBUG.G_Err_Stack);
866: RAISE;
867:
868: PA_FORECASTITEM_PVT.print_message('ERROR in update row '||sqlerrm);
869: END update_schedule_rows;

Line 897: p_procedure_name => PA_DEBUG.G_Err_Stack);

893: x_msg_data := sqlerrm;
894: FND_MSG_PUB.add_exc_msg
895: (p_pkg_name =>
896: 'PA_FORECAST_HDR_PKG.update_rows',
897: p_procedure_name => PA_DEBUG.G_Err_Stack);
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899:
900: If x_msg_count = 1 THEN
901: pa_interface_utils_pub.get_messages