DBA Data[Home] [Help]

APPS.PA_FORECAST_HDR_PKG dependencies on PA_FORECAST_HDR_PKG

Line 1: PACKAGE BODY PA_FORECAST_HDR_PKG as

1: PACKAGE BODY PA_FORECAST_HDR_PKG as
2: --/* $Header: PARFFIHB.pls 120.2 2005/08/19 16:51:21 mwasowic noship $ */
3: l_empty_tab_record EXCEPTION; -- Variable to raise the exception if the passing table of records is empty
4:
5:

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 419: (p_pkg_name => 'PA_FORECAST_HDR_PKG.Insert_Rows',

415: x_msg_count := 1;
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:

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 799: (p_pkg_name => 'PA_FORECAST_HDR_PKG.Update_Rows',

795: x_msg_count := 1;
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:

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 864: (p_pkg_name => 'PA_FORECAST_HDR_PKG.Update_Schedule_Rows',

860: x_msg_count := 1;
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);

Line 896: 'PA_FORECAST_HDR_PKG.update_rows',

892: x_msg_count := 1;
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

Line 920: END PA_FORECAST_HDR_PKG;

916: RAISE;
917:
918: END update_rows;
919:
920: END PA_FORECAST_HDR_PKG;