DBA Data[Home] [Help]

APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_GENERATE_FORECAST_PUB

Line 1: PACKAGE BODY PA_GENERATE_FORECAST_PUB AS

1: PACKAGE BODY PA_GENERATE_FORECAST_PUB AS
2: /* $Header: PARRFGPB.pls 120.3 2006/03/22 20:40:29 nkumbi noship $ */
3:
4: FUNCTION Get_Person_Id(p_res_id NUMBER)
5: RETURN NUMBER IS

Line 114: PA_GENERATE_FORECAST_PUB.Set_Error_Details(

110: x_ret_status => l_ret_status );
111: -- l_msg_count := x_msg_count;
112: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
113:
114: PA_GENERATE_FORECAST_PUB.Set_Error_Details(
115: p_return_status => l_ret_status,
116: x_msg_count => l_msg_count,
117: x_msg_data => l_msg_data,
118: x_data => l_data,

Line 203: PA_GENERATE_FORECAST_PUB.Set_Error_Details(

199: l_ret_status := FND_API.G_RET_STS_ERROR;
200: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
201: p_msg_name => 'PA_FCST_IN_PROCESS');
202:
203: PA_GENERATE_FORECAST_PUB.Set_Error_Details(
204: p_return_status => l_ret_status,
205: x_msg_count => l_msg_count,
206: x_msg_data => l_msg_data,
207: x_data => l_data,

Line 544: l_budget_lines_tbl PA_GENERATE_FORECAST_PUB.budget_lines_tbl_type;

540: l_period_name_tot_flag varchar2(1);
541: l_current_index PLS_INTEGER;
542: l_current_index_tot PLS_INTEGER:=1;
543: l_cnt PLS_INTEGER;
544: l_budget_lines_tbl PA_GENERATE_FORECAST_PUB.budget_lines_tbl_type;
545: l_budget_lines_tot_tbl PA_GENERATE_FORECAST_PUB.budget_lines_tbl_type;
546:
547: /* Updating the ROLE LEVEL TOTAL in PA_RESOURCE_ASSIGNMENTS */
548: l_tot_quantity NUMBER;

Line 545: l_budget_lines_tot_tbl PA_GENERATE_FORECAST_PUB.budget_lines_tbl_type;

541: l_current_index PLS_INTEGER;
542: l_current_index_tot PLS_INTEGER:=1;
543: l_cnt PLS_INTEGER;
544: l_budget_lines_tbl PA_GENERATE_FORECAST_PUB.budget_lines_tbl_type;
545: l_budget_lines_tot_tbl PA_GENERATE_FORECAST_PUB.budget_lines_tbl_type;
546:
547: /* Updating the ROLE LEVEL TOTAL in PA_RESOURCE_ASSIGNMENTS */
548: l_tot_quantity NUMBER;
549: l_tot_revenue NUMBER;

Line 574: l_commit_size NUMBER:= PA_GENERATE_FORECAST_PUB.G_commit_cnt;

570: l_role_error_code_flag VARCHAR2(1);
571: l_prj_level_revenue NUMBER:=0;
572: l_process_fis_flag VARCHAR2(1);
573: l_asgmt_status_flag VARCHAR2(1);
574: l_commit_size NUMBER:= PA_GENERATE_FORECAST_PUB.G_commit_cnt;
575: l_commit_cnt NUMBER:= 0;
576: l_event_error_msg VARCHAR2(100);
577:
578: l_bl_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 623: PA_DEBUG.init_err_stack('PA_GENERATE_FORECAST_PUB.Generate_Forecast');

619: /*Code Changes for Bug No.2984871 start */
620: l_rowcount number :=0;
621: /*Code Changes for Bug No.2984871 end */
622: BEGIN
623: PA_DEBUG.init_err_stack('PA_GENERATE_FORECAST_PUB.Generate_Forecast');
624: x_return_status := FND_API.G_RET_STS_SUCCESS;
625: l_ret_status := FND_API.G_RET_STS_SUCCESS;
626:
627: l_counter := l_counter + 1;

Line 647: PA_GENERATE_FORECAST_PUB.Set_Error_Details(

643:
644: PA_DEBUG.g_err_stage := '200: after calling global';
645: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
646: IF l_ret_status <> FND_API.G_RET_STS_SUCCESS THEN
647: PA_GENERATE_FORECAST_PUB.Set_Error_Details(
648: p_return_status => l_ret_status,
649: x_msg_count => l_msg_count,
650: x_msg_data => l_msg_data,
651: x_data => l_data,

Line 738: PA_GENERATE_FORECAST_PUB.Set_Error_Details(

734: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
735: p_msg_name => 'PA_FCST_NOT_APPL_TMPL');
736: END IF;
737: IF l_role_error_code_flag = 'Y' THEN
738: PA_GENERATE_FORECAST_PUB.Set_Error_Details(
739: p_return_status => l_ret_status,
740: x_msg_count => l_msg_count,
741: x_msg_data => l_msg_data,
742: x_data => l_data,

Line 774: PA_GENERATE_FORECAST_PUB.Set_Error_Details(

770:
771: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
772: p_msg_name => l_error_msg );
773:
774: PA_GENERATE_FORECAST_PUB.Set_Error_Details(
775: p_return_status => l_ret_status,
776: x_msg_count => l_msg_count,
777: x_msg_data => l_msg_data,
778: x_data => l_data,

Line 793: PA_GENERATE_FORECAST_PUB.Maintain_Budget_Version(

789: PA_DEBUG.g_err_stage := '500: before calling budget version cursor';
790: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
791:
792: BEGIN
793: PA_GENERATE_FORECAST_PUB.Maintain_Budget_Version(
794: p_project_id => p_project_id,
795: p_plan_processing_code => 'P',
796: x_budget_version_id => l_budget_version_id,
797: x_msg_count => x_msg_count,

Line 807: PA_GENERATE_FORECAST_PUB.Set_Error_Details(

803: END;
804:
805: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
806: l_ret_status := x_return_status;
807: PA_GENERATE_FORECAST_PUB.Set_Error_Details(
808: p_return_status => l_ret_status,
809: x_msg_count => l_msg_count,
810: x_msg_data => l_msg_data,
811: x_data => l_data,

Line 2135: PA_GENERATE_FORECAST_PUB.Set_Error_Details(

2131: x_return_status => x_return_status );
2132: END IF;
2133: COMMIT;
2134:
2135: PA_GENERATE_FORECAST_PUB.Set_Error_Details(
2136: p_return_status => l_ret_status,
2137: x_msg_count => l_msg_count,
2138: x_msg_data => l_msg_data,
2139: x_data => l_data,

Line 2169: END PA_GENERATE_FORECAST_PUB;

2165: WHEN OTHERS THEN
2166: RETURN l_run_date;
2167: END get_forecast_gen_date;
2168:
2169: END PA_GENERATE_FORECAST_PUB;