eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_DEBUG

Line 48: PA_DEBUG.set_err_stack('Set_Error_Details');

44: l_data VARCHAR2(2000);
45: l_msg_index_out NUMBER;
46:
47: BEGIN
48: PA_DEBUG.set_err_stack('Set_Error_Details');
49: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
50: IF fnd_msg_pub.count_msg = 1 THEN
51: PA_INTERFACE_UTILS_PUB.Get_Messages (
52: p_encoded => FND_API.G_TRUE,

Line 64: PA_DEBUG.reset_err_stack;

60: ELSE
61: x_msg_count := fnd_msg_pub.count_msg;
62: END IF;
63: END IF;
64: PA_DEBUG.reset_err_stack;
65: RETURN;
66: EXCEPTION
67: WHEN OTHERS THEN
68: RAISE;

Line 104: PA_DEBUG.set_err_stack('Maintain_Budget_Version');

100: l_msg_count NUMBER;
101:
102:
103: BEGIN
104: PA_DEBUG.set_err_stack('Maintain_Budget_Version');
105: l_ret_status := FND_API.G_RET_STS_SUCCESS;
106:
107: PA_FORECAST_GLOBAL.Initialize_Global(
108: x_msg_count => x_msg_count,

Line 124: PA_DEBUG.reset_err_stack;

120:
121: x_msg_count := l_msg_count;
122: x_msg_data := l_msg_data;
123: x_return_status := l_ret_status;
124: PA_DEBUG.reset_err_stack;
125: RETURN;
126: END IF;
127:
128: l_fcst_def_bem := PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_def_bem;

Line 144: PA_DEBUG.g_err_stage := '630: before calling PA_BUDGET_VERSIONS_PKG.INSERT_ROW';

140: FETCH BUDGET_VERSION INTO
141: x_budget_version_id,
142: l_plan_processing_code;
143: IF BUDGET_VERSION%NOTFOUND THEN
144: PA_DEBUG.g_err_stage := '630: before calling PA_BUDGET_VERSIONS_PKG.INSERT_ROW';
145: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
146: PA_BUDGET_VERSIONS_PKG.Insert_Row(
147: X_ROWID => l_rowid,
148: X_BUDGET_VERSION_ID => x_budget_version_id,

Line 145: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

141: x_budget_version_id,
142: l_plan_processing_code;
143: IF BUDGET_VERSION%NOTFOUND THEN
144: PA_DEBUG.g_err_stage := '630: before calling PA_BUDGET_VERSIONS_PKG.INSERT_ROW';
145: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
146: PA_BUDGET_VERSIONS_PKG.Insert_Row(
147: X_ROWID => l_rowid,
148: X_BUDGET_VERSION_ID => x_budget_version_id,
149: X_PROJECT_ID => p_project_id,

Line 195: PA_DEBUG.g_err_stage := '660: after calling PA_BUDGET_VERSIONS_PKG.INSERT_ROW';

191: X_PM_PRODUCT_CODE => NULL,
192: X_PM_BUDGET_REFERENCE => NULL,
193: X_WF_STATUS_CODE => NULL,
194: X_PLAN_PROCESSING_CODE => p_plan_processing_code);
195: PA_DEBUG.g_err_stage := '660: after calling PA_BUDGET_VERSIONS_PKG.INSERT_ROW';
196: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
197: ELSE
198: IF l_plan_processing_code = 'P' THEN
199: l_ret_status := FND_API.G_RET_STS_ERROR;

Line 196: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

192: X_PM_BUDGET_REFERENCE => NULL,
193: X_WF_STATUS_CODE => NULL,
194: X_PLAN_PROCESSING_CODE => p_plan_processing_code);
195: PA_DEBUG.g_err_stage := '660: after calling PA_BUDGET_VERSIONS_PKG.INSERT_ROW';
196: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
197: ELSE
198: IF l_plan_processing_code = 'P' THEN
199: l_ret_status := FND_API.G_RET_STS_ERROR;
200: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 214: PA_DEBUG.reset_err_stack;

210: x_msg_count := l_msg_count;
211: x_msg_data := l_msg_data;
212: x_return_status := l_ret_status;
213: CLOSE BUDGET_VERSION;
214: PA_DEBUG.reset_err_stack;
215: RETURN;
216: END IF;
217: PA_DEBUG.g_err_stage := '680: before updating PA_BUDGET_VERSIONS';
218: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 217: PA_DEBUG.g_err_stage := '680: before updating PA_BUDGET_VERSIONS';

213: CLOSE BUDGET_VERSION;
214: PA_DEBUG.reset_err_stack;
215: RETURN;
216: END IF;
217: PA_DEBUG.g_err_stage := '680: before updating PA_BUDGET_VERSIONS';
218: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
219:
220: UPDATE PA_BUDGET_VERSIONS SET
221: PLAN_PROCESSING_CODE = p_plan_processing_code,

Line 218: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

214: PA_DEBUG.reset_err_stack;
215: RETURN;
216: END IF;
217: PA_DEBUG.g_err_stage := '680: before updating PA_BUDGET_VERSIONS';
218: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
219:
220: UPDATE PA_BUDGET_VERSIONS SET
221: PLAN_PROCESSING_CODE = p_plan_processing_code,
222: BUDGET_ENTRY_METHOD_CODE = l_fcst_def_bem

Line 226: PA_DEBUG.g_err_stage := '690: after updating PA_BUDGET_VERSIONS';

222: BUDGET_ENTRY_METHOD_CODE = l_fcst_def_bem
223: WHERE
224: BUDGET_VERSION_ID = x_budget_version_id;
225:
226: PA_DEBUG.g_err_stage := '690: after updating PA_BUDGET_VERSIONS';
227: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
228:
229: END IF;
230: CLOSE BUDGET_VERSION;

Line 227: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

223: WHERE
224: BUDGET_VERSION_ID = x_budget_version_id;
225:
226: PA_DEBUG.g_err_stage := '690: after updating PA_BUDGET_VERSIONS';
227: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
228:
229: END IF;
230: CLOSE BUDGET_VERSION;
231: x_return_status := l_ret_status;

Line 232: PA_DEBUG.reset_err_stack;

228:
229: END IF;
230: CLOSE BUDGET_VERSION;
231: x_return_status := l_ret_status;
232: PA_DEBUG.reset_err_stack;
233: RETURN;
234: EXCEPTION
235: WHEN OTHERS THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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 628: PA_DEBUG.g_err_stage := '100: before calling global';

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;
628: PA_DEBUG.g_err_stage := '100: before calling global';
629: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
630: l_commit_size := l_commit_size + 1;
631:
632: BEGIN

Line 629: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

625: l_ret_status := FND_API.G_RET_STS_SUCCESS;
626:
627: l_counter := l_counter + 1;
628: PA_DEBUG.g_err_stage := '100: before calling global';
629: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
630: l_commit_size := l_commit_size + 1;
631:
632: BEGIN
633: PA_FORECAST_GLOBAL.Initialize_Global(

Line 644: PA_DEBUG.g_err_stage := '200: after calling global';

640: END;
641:
642: l_ret_status := x_return_status;
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,

Line 645: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

641:
642: l_ret_status := x_return_status;
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,

Line 657: PA_DEBUG.Reset_Err_stack;

653:
654: x_msg_count := l_msg_count;
655: x_msg_data := l_msg_data;
656: x_return_status := l_ret_status;
657: PA_DEBUG.Reset_Err_stack;
658: RETURN;
659: END IF;
660:
661:

Line 668: PA_DEBUG.g_err_stage := '205: Project ID :'||p_project_id;

664: l_fcst_period_type:=PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_period_type;
665: l_fcst_opt_jobcostrate_sch_id:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_cost_rate_sch_id;
666:
667:
668: PA_DEBUG.g_err_stage := '205: Project ID :'||p_project_id;
669: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
670: PA_DEBUG.g_err_stage := '210: Default budget entry method :'||l_fcst_def_bem;
671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;

Line 669: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

665: l_fcst_opt_jobcostrate_sch_id:= PA_FORECAST_GLOBAL.G_implementation_details.G_fcst_cost_rate_sch_id;
666:
667:
668: PA_DEBUG.g_err_stage := '205: Project ID :'||p_project_id;
669: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
670: PA_DEBUG.g_err_stage := '210: Default budget entry method :'||l_fcst_def_bem;
671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;
673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 670: PA_DEBUG.g_err_stage := '210: Default budget entry method :'||l_fcst_def_bem;

666:
667:
668: PA_DEBUG.g_err_stage := '205: Project ID :'||p_project_id;
669: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
670: PA_DEBUG.g_err_stage := '210: Default budget entry method :'||l_fcst_def_bem;
671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;
673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;

Line 671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

667:
668: PA_DEBUG.g_err_stage := '205: Project ID :'||p_project_id;
669: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
670: PA_DEBUG.g_err_stage := '210: Default budget entry method :'||l_fcst_def_bem;
671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;
673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;
675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;

668: PA_DEBUG.g_err_stage := '205: Project ID :'||p_project_id;
669: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
670: PA_DEBUG.g_err_stage := '210: Default budget entry method :'||l_fcst_def_bem;
671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;
673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;
675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
676:

Line 673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

669: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
670: PA_DEBUG.g_err_stage := '210: Default budget entry method :'||l_fcst_def_bem;
671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;
673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;
675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
676:
677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;

Line 674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;

670: PA_DEBUG.g_err_stage := '210: Default budget entry method :'||l_fcst_def_bem;
671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;
673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;
675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
676:
677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;

Line 675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

671: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
672: PA_DEBUG.g_err_stage := '220: Default resource list :'||l_fcst_res_list;
673: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
674: PA_DEBUG.g_err_stage := '230: Forecasting Period Type :'||l_fcst_period_type;
675: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
676:
677: l_created_by := PA_FORECAST_GLOBAL.G_who_columns.G_created_by;
678: l_request_id := PA_FORECAST_GLOBAL.G_who_columns.G_request_id;
679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;

Line 683: PA_DEBUG.g_err_stage := '300: before fetching project cursor';

679: l_program_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_id;
680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
682: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
683: PA_DEBUG.g_err_stage := '300: before fetching project cursor';
684: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
685: /* l_role_error_code_flag is used here for only checking whether to
686: continue with forecasting process or not */
687: l_role_error_code_flag := 'N';

Line 684: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

680: l_program_application_id := PA_FORECAST_GLOBAL.G_who_columns.G_program_application_id;
681: l_creation_date := PA_FORECAST_GLOBAL.G_who_columns.G_creation_date;
682: l_program_update_date := PA_FORECAST_GLOBAL.G_who_columns.G_last_update_date;
683: PA_DEBUG.g_err_stage := '300: before fetching project cursor';
684: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
685: /* l_role_error_code_flag is used here for only checking whether to
686: continue with forecasting process or not */
687: l_role_error_code_flag := 'N';
688: OPEN PROJ_DETAILS;

Line 748: PA_DEBUG.reset_err_stack;

744:
745: x_msg_count := l_msg_count;
746: x_msg_data := l_msg_data;
747: x_return_status := l_ret_status;
748: PA_DEBUG.reset_err_stack;
749: CLOSE PROJ_DETAILS;
750: RETURN;
751: END IF;
752: CLOSE PROJ_DETAILS;

Line 753: PA_DEBUG.g_err_stage := '400: after fetching project cursor';

749: CLOSE PROJ_DETAILS;
750: RETURN;
751: END IF;
752: CLOSE PROJ_DETAILS;
753: PA_DEBUG.g_err_stage := '400: after fetching project cursor';
754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
755: PA_DEBUG.g_err_stage := '410: before calling for rev gen md';
756: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
757: BEGIN

Line 754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

750: RETURN;
751: END IF;
752: CLOSE PROJ_DETAILS;
753: PA_DEBUG.g_err_stage := '400: after fetching project cursor';
754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
755: PA_DEBUG.g_err_stage := '410: before calling for rev gen md';
756: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
757: BEGIN
758:

Line 755: PA_DEBUG.g_err_stage := '410: before calling for rev gen md';

751: END IF;
752: CLOSE PROJ_DETAILS;
753: PA_DEBUG.g_err_stage := '400: after fetching project cursor';
754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
755: PA_DEBUG.g_err_stage := '410: before calling for rev gen md';
756: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
757: BEGIN
758:
759: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method(

Line 756: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

752: CLOSE PROJ_DETAILS;
753: PA_DEBUG.g_err_stage := '400: after fetching project cursor';
754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
755: PA_DEBUG.g_err_stage := '410: before calling for rev gen md';
756: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
757: BEGIN
758:
759: PA_RATE_PVT_PKG.Get_Revenue_Generation_Method(
760: P_PROJECT_ID => p_project_id,

Line 784: PA_DEBUG.reset_err_stack;

780:
781: x_msg_count := l_msg_count;
782: x_msg_data := l_msg_data;
783: x_return_status := l_ret_status;
784: PA_DEBUG.reset_err_stack;
785: RETURN;
786: END IF;
787:
788:

Line 789: PA_DEBUG.g_err_stage := '500: before calling budget version cursor';

785: RETURN;
786: END IF;
787:
788:
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(

Line 790: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

786: END IF;
787:
788:
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,

Line 818: PA_DEBUG.g_err_stage := '550: The plan_processing_code may be P - PA_FCST_IN_PROCESS ';

814: x_msg_count := l_msg_count;
815: x_msg_data := l_msg_data;
816: x_return_status := l_ret_status;
817:
818: PA_DEBUG.g_err_stage := '550: The plan_processing_code may be P - PA_FCST_IN_PROCESS ';
819: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
820:
821: PA_DEBUG.reset_err_stack;
822: RETURN;

Line 819: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

815: x_msg_data := l_msg_data;
816: x_return_status := l_ret_status;
817:
818: PA_DEBUG.g_err_stage := '550: The plan_processing_code may be P - PA_FCST_IN_PROCESS ';
819: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
820:
821: PA_DEBUG.reset_err_stack;
822: RETURN;
823: END IF;

Line 821: PA_DEBUG.reset_err_stack;

817:
818: PA_DEBUG.g_err_stage := '550: The plan_processing_code may be P - PA_FCST_IN_PROCESS ';
819: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
820:
821: PA_DEBUG.reset_err_stack;
822: RETURN;
823: END IF;
824:
825: /* Deleting PA_BUDGET_LINES and PA_RESOURCE_ASSIGNMENTS */

Line 839: PA_DEBUG.g_err_stage := '690: Budget Version ID :'||l_budget_version_id;

835: /* Commit the changes so that no other process pick up the same project for Forecasting */
836:
837: COMMIT;
838:
839: PA_DEBUG.g_err_stage := '690: Budget Version ID :'||l_budget_version_id;
840: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
841: PA_DEBUG.g_err_stage := '695: return status :'||x_return_status;
842: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
843:

Line 840: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

836:
837: COMMIT;
838:
839: PA_DEBUG.g_err_stage := '690: Budget Version ID :'||l_budget_version_id;
840: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
841: PA_DEBUG.g_err_stage := '695: return status :'||x_return_status;
842: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
843:
844: PA_DEBUG.g_err_stage := '700: before fetching PA_PROJ_ASSIGNMENT cursor';

Line 841: PA_DEBUG.g_err_stage := '695: return status :'||x_return_status;

837: COMMIT;
838:
839: PA_DEBUG.g_err_stage := '690: Budget Version ID :'||l_budget_version_id;
840: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
841: PA_DEBUG.g_err_stage := '695: return status :'||x_return_status;
842: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
843:
844: PA_DEBUG.g_err_stage := '700: before fetching PA_PROJ_ASSIGNMENT cursor';
845: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 842: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

838:
839: PA_DEBUG.g_err_stage := '690: Budget Version ID :'||l_budget_version_id;
840: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
841: PA_DEBUG.g_err_stage := '695: return status :'||x_return_status;
842: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
843:
844: PA_DEBUG.g_err_stage := '700: before fetching PA_PROJ_ASSIGNMENT cursor';
845: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
846:

Line 844: PA_DEBUG.g_err_stage := '700: before fetching PA_PROJ_ASSIGNMENT cursor';

840: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
841: PA_DEBUG.g_err_stage := '695: return status :'||x_return_status;
842: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
843:
844: PA_DEBUG.g_err_stage := '700: before fetching PA_PROJ_ASSIGNMENT cursor';
845: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
846:
847: /* Set plan processing code to G - G(enerated Successfully) */
848:

Line 845: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

841: PA_DEBUG.g_err_stage := '695: return status :'||x_return_status;
842: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
843:
844: PA_DEBUG.g_err_stage := '700: before fetching PA_PROJ_ASSIGNMENT cursor';
845: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
846:
847: /* Set plan processing code to G - G(enerated Successfully) */
848:
849: l_plan_processing_code := 'G';

Line 875: PA_DEBUG.g_err_stage := '750: Assignment Id :'||l_prj_assignment_id;

871: END IF;
872: l_role_error_code := NULL;
873: l_role_error_code_flag := 'N';
874:
875: PA_DEBUG.g_err_stage := '750: Assignment Id :'||l_prj_assignment_id;
876: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
877:
878: /* The following check is added to avoid processing of assignment records if the status
879: is cancelled */

Line 876: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

872: l_role_error_code := NULL;
873: l_role_error_code_flag := 'N';
874:
875: PA_DEBUG.g_err_stage := '750: Assignment Id :'||l_prj_assignment_id;
876: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
877:
878: /* The following check is added to avoid processing of assignment records if the status
879: is cancelled */
880:

Line 903: PA_DEBUG.g_err_stage := '800: before fetching deflt jobid and job group id from roles';

899: END IF;
900:
901: IF l_process_fis_flag = 'Y' AND l_prj_assignment_type = 'OPEN_ASSIGNMENT' AND
902: ( l_prj_fcst_job_id IS NULL OR l_prj_fcst_job_group_id IS NULL ) THEN
903: PA_DEBUG.g_err_stage := '800: before fetching deflt jobid and job group id from roles';
904: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
905: BEGIN
906: SELECT PR.DEFAULT_JOB_ID,PJ.JOB_GROUP_ID INTO
907: l_prj_fcst_job_id,l_prj_fcst_job_group_id FROM

Line 904: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

900:
901: IF l_process_fis_flag = 'Y' AND l_prj_assignment_type = 'OPEN_ASSIGNMENT' AND
902: ( l_prj_fcst_job_id IS NULL OR l_prj_fcst_job_group_id IS NULL ) THEN
903: PA_DEBUG.g_err_stage := '800: before fetching deflt jobid and job group id from roles';
904: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
905: BEGIN
906: SELECT PR.DEFAULT_JOB_ID,PJ.JOB_GROUP_ID INTO
907: l_prj_fcst_job_id,l_prj_fcst_job_group_id FROM
908: PA_PROJECT_ROLE_TYPES PR, PER_JOBS PJ

Line 921: PA_DEBUG.g_err_stage := '850: after fetching PA_PROJ_ASSIGNMENT cursor';

917: WHEN OTHERS THEN
918: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id);
919: RAISE;
920: END;
921: PA_DEBUG.g_err_stage := '850: after fetching PA_PROJ_ASSIGNMENT cursor';
922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
923: END IF;
924:
925: PA_DEBUG.g_err_stage := '900: before fetching the RLM ID';

Line 922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

918: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id);
919: RAISE;
920: END;
921: PA_DEBUG.g_err_stage := '850: after fetching PA_PROJ_ASSIGNMENT cursor';
922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
923: END IF;
924:
925: PA_DEBUG.g_err_stage := '900: before fetching the RLM ID';
926: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 925: PA_DEBUG.g_err_stage := '900: before fetching the RLM ID';

921: PA_DEBUG.g_err_stage := '850: after fetching PA_PROJ_ASSIGNMENT cursor';
922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
923: END IF;
924:
925: PA_DEBUG.g_err_stage := '900: before fetching the RLM ID';
926: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
927:
928: l_parent_member_id := NULL;
929: l_track_as_labor_flag := NULL;

Line 926: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

922: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
923: END IF;
924:
925: PA_DEBUG.g_err_stage := '900: before fetching the RLM ID';
926: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
927:
928: l_parent_member_id := NULL;
929: l_track_as_labor_flag := NULL;
930: l_resource_list_member_id := NULL;

Line 943: PA_DEBUG.g_err_stage := '950: after fetching the RLM ID';

939: RLM.RESOURCE_LIST_ID = l_fcst_res_list AND
940: RLM.RESOURCE_ID = R.RESOURCE_ID AND
941: RT.RESOURCE_ID = R.RESOURCE_ID AND
942: RT.PROJECT_ROLE_ID = l_prj_project_role_id;
943: PA_DEBUG.g_err_stage := '950: after fetching the RLM ID';
944: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
945: PA_DEBUG.g_err_stage := '960: RLM ID from TABLE :'||l_resource_list_member_id;
946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
947: EXCEPTION

Line 944: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

940: RLM.RESOURCE_ID = R.RESOURCE_ID AND
941: RT.RESOURCE_ID = R.RESOURCE_ID AND
942: RT.PROJECT_ROLE_ID = l_prj_project_role_id;
943: PA_DEBUG.g_err_stage := '950: after fetching the RLM ID';
944: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
945: PA_DEBUG.g_err_stage := '960: RLM ID from TABLE :'||l_resource_list_member_id;
946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN

Line 945: PA_DEBUG.g_err_stage := '960: RLM ID from TABLE :'||l_resource_list_member_id;

941: RT.RESOURCE_ID = R.RESOURCE_ID AND
942: RT.PROJECT_ROLE_ID = l_prj_project_role_id;
943: PA_DEBUG.g_err_stage := '950: after fetching the RLM ID';
944: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
945: PA_DEBUG.g_err_stage := '960: RLM ID from TABLE :'||l_resource_list_member_id;
946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: l_resource_list_member_id := NULL;

Line 946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

942: RT.PROJECT_ROLE_ID = l_prj_project_role_id;
943: PA_DEBUG.g_err_stage := '950: after fetching the RLM ID';
944: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
945: PA_DEBUG.g_err_stage := '960: RLM ID from TABLE :'||l_resource_list_member_id;
946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: l_resource_list_member_id := NULL;
950: PA_DEBUG.g_err_stage := '1000: before calling PA_CREATE_RESOURCE.CREATE_RESOURCE_LIST_MEMBER';

Line 950: PA_DEBUG.g_err_stage := '1000: before calling PA_CREATE_RESOURCE.CREATE_RESOURCE_LIST_MEMBER';

946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: l_resource_list_member_id := NULL;
950: PA_DEBUG.g_err_stage := '1000: before calling PA_CREATE_RESOURCE.CREATE_RESOURCE_LIST_MEMBER';
951: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
952: PA_CREATE_RESOURCE.ADD_RESOUCE_LIST_MEMBER
953: (P_RESOURCE_LIST_ID => l_fcst_res_list,
954: P_RESOURCE_NAME => l_prj_meaning,

Line 951: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

947: EXCEPTION
948: WHEN NO_DATA_FOUND THEN
949: l_resource_list_member_id := NULL;
950: PA_DEBUG.g_err_stage := '1000: before calling PA_CREATE_RESOURCE.CREATE_RESOURCE_LIST_MEMBER';
951: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
952: PA_CREATE_RESOURCE.ADD_RESOUCE_LIST_MEMBER
953: (P_RESOURCE_LIST_ID => l_fcst_res_list,
954: P_RESOURCE_NAME => l_prj_meaning,
955: P_RESOURCE_TYPE_CODE => 'PROJECT_ROLE',

Line 978: PA_DEBUG.g_err_stage := '1050: after calling PA_CREATE_RESOURCE.CREATE_RESOURCE_LIST_MEMBER';

974: P_ERR_STAGE => l_err_stage,
975: P_ERR_STACK => l_err_stack,
976: P_PROJECT_ROLE_ID => l_prj_project_role_id,
977: P_RESOURCE_ID => l_resource_id);
978: PA_DEBUG.g_err_stage := '1050: after calling PA_CREATE_RESOURCE.CREATE_RESOURCE_LIST_MEMBER';
979: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
980: l_commit_cnt := l_commit_cnt + 1;
981: END;
982: END IF;

Line 979: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

975: P_ERR_STACK => l_err_stack,
976: P_PROJECT_ROLE_ID => l_prj_project_role_id,
977: P_RESOURCE_ID => l_resource_id);
978: PA_DEBUG.g_err_stage := '1050: after calling PA_CREATE_RESOURCE.CREATE_RESOURCE_LIST_MEMBER';
979: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
980: l_commit_cnt := l_commit_cnt + 1;
981: END;
982: END IF;
983: PA_DEBUG.g_err_stage := '1060: RLM ID from API :'||l_resource_list_member_id;

Line 983: PA_DEBUG.g_err_stage := '1060: RLM ID from API :'||l_resource_list_member_id;

979: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
980: l_commit_cnt := l_commit_cnt + 1;
981: END;
982: END IF;
983: PA_DEBUG.g_err_stage := '1060: RLM ID from API :'||l_resource_list_member_id;
984: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
985: l_current_index := 1;
986: l_tot_quantity := 0;
987: l_tot_revenue := 0;

Line 984: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

980: l_commit_cnt := l_commit_cnt + 1;
981: END;
982: END IF;
983: PA_DEBUG.g_err_stage := '1060: RLM ID from API :'||l_resource_list_member_id;
984: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
985: l_current_index := 1;
986: l_tot_quantity := 0;
987: l_tot_revenue := 0;
988: l_tot_bcost := 0;

Line 1013: PA_DEBUG.g_err_stage := '1100: before Fetching Forecasting cursor';

1009: l_plan_processing_code := 'E';
1010: END IF;
1011: END IF;
1012: END IF;
1013: PA_DEBUG.g_err_stage := '1100: before Fetching Forecasting cursor';
1014: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1015:
1016: IF l_process_fis_flag = 'Y' THEN
1017: IF l_fcst_period_type = 'PA' THEN

Line 1014: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1010: END IF;
1011: END IF;
1012: END IF;
1013: PA_DEBUG.g_err_stage := '1100: before Fetching Forecasting cursor';
1014: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1015:
1016: IF l_process_fis_flag = 'Y' THEN
1017: IF l_fcst_period_type = 'PA' THEN
1018: OPEN FCST_PA(l_prj_assignment_id);

Line 1071: PA_DEBUG.g_err_stage := '1100A: aft Fetching Fcst cursor : '||l_rt_exp_org_id_tab.count;

1067: l_rt_qty_tab,
1068: l_rt_forecast_item_id_tab;
1069: END IF;
1070: l_bulk_fetch_count := l_rt_exp_org_id_tab.count;
1071: PA_DEBUG.g_err_stage := '1100A: aft Fetching Fcst cursor : '||l_rt_exp_org_id_tab.count;
1072: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1073: IF l_bulk_fetch_count = 0 THEN
1074: EXIT;
1075: END IF;

Line 1072: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1068: l_rt_forecast_item_id_tab;
1069: END IF;
1070: l_bulk_fetch_count := l_rt_exp_org_id_tab.count;
1071: PA_DEBUG.g_err_stage := '1100A: aft Fetching Fcst cursor : '||l_rt_exp_org_id_tab.count;
1072: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1073: IF l_bulk_fetch_count = 0 THEN
1074: EXIT;
1075: END IF;
1076: /* Initial bill rate API will be called always, because of the

Line 1087: PA_DEBUG.g_err_stage := 'no data found in FI while getting exp type class';

1083: Pa_Forecast_Items WHERE
1084: Forecast_Item_Id = l_rt_forecast_item_id_tab(1);
1085: EXCEPTION
1086: WHEN NO_DATA_FOUND THEN
1087: PA_DEBUG.g_err_stage := 'no data found in FI while getting exp type class';
1088: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1089: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id );
1090: RAISE;
1091: END;

Line 1088: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1084: Forecast_Item_Id = l_rt_forecast_item_id_tab(1);
1085: EXCEPTION
1086: WHEN NO_DATA_FOUND THEN
1087: PA_DEBUG.g_err_stage := 'no data found in FI while getting exp type class';
1088: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1089: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id );
1090: RAISE;
1091: END;
1092: /* Added for Org Forecasting changes */

Line 1095: PA_DEBUG.g_err_stage := '1105: before calling init bill rate';

1091: END;
1092: /* Added for Org Forecasting changes */
1093: IF l_role_error_code IS NULL THEN
1094: BEGIN
1095: PA_DEBUG.g_err_stage := '1105: before calling init bill rate';
1096: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1097: PA_RATE_PVT_PKG.get_initial_bill_rate(
1098: p_assignment_type => l_prj_short_assignment_type,
1099: p_asgn_start_date => l_prj_start_date,

Line 1096: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1092: /* Added for Org Forecasting changes */
1093: IF l_role_error_code IS NULL THEN
1094: BEGIN
1095: PA_DEBUG.g_err_stage := '1105: before calling init bill rate';
1096: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1097: PA_RATE_PVT_PKG.get_initial_bill_rate(
1098: p_assignment_type => l_prj_short_assignment_type,
1099: p_asgn_start_date => l_prj_start_date,
1100: p_project_id => p_project_id,

Line 1148: PA_DEBUG.g_err_stage := '1105: after calling init bill rate';

1144: p_project_rev_exch_rt => l_prj_bil_ex_rate,
1145: p_project_cst_rt_date => l_prj_rate_date,
1146: p_project_cst_rt_type => l_prj_rate_type );
1147:
1148: PA_DEBUG.g_err_stage := '1105: after calling init bill rate';
1149: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1150: EXCEPTION
1151: WHEN OTHERS THEN
1152: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id );

Line 1149: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1145: p_project_cst_rt_date => l_prj_rate_date,
1146: p_project_cst_rt_type => l_prj_rate_type );
1147:
1148: PA_DEBUG.g_err_stage := '1105: after calling init bill rate';
1149: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1150: EXCEPTION
1151: WHEN OTHERS THEN
1152: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id );
1153: RAISE;

Line 1179: PA_DEBUG.g_err_stage := 'no data found in FI while getting exp type class';

1175: Pa_Forecast_Items WHERE
1176: Forecast_Item_Id = l_rt_forecast_item_id_tab(1);
1177: EXCEPTION
1178: WHEN NO_DATA_FOUND THEN
1179: PA_DEBUG.g_err_stage := 'no data found in FI while getting exp type class';
1180: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1181: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id );
1182: RAISE;
1183: END;

Line 1180: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1176: Forecast_Item_Id = l_rt_forecast_item_id_tab(1);
1177: EXCEPTION
1178: WHEN NO_DATA_FOUND THEN
1179: PA_DEBUG.g_err_stage := 'no data found in FI while getting exp type class';
1180: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1181: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id );
1182: RAISE;
1183: END;
1184: l_rt_system_linkage_tab.delete;

Line 1218: PA_DEBUG.g_err_stage := '1200: bef calling RATE API calc_rate_amount ';

1214: l_rt_others_rejct_reason_tab(l_tmp_idx) := NULL;
1215: END LOOP;
1216: /* Added for Org Forecasting changes */
1217:
1218: PA_DEBUG.g_err_stage := '1200: bef calling RATE API calc_rate_amount ';
1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1220: /* dbms_output.put_line('bef calling Rate API ');
1221: dbms_output.put_line('st dt :'||l_rt_start_date_tab.count);
1222: dbms_output.put_line(' p_projfunc_rev_rt_dt_code_tab ' || l_rt_pfunc_rev_rt_dt_code_tab.COUNT);

Line 1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1215: END LOOP;
1216: /* Added for Org Forecasting changes */
1217:
1218: PA_DEBUG.g_err_stage := '1200: bef calling RATE API calc_rate_amount ';
1219: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1220: /* dbms_output.put_line('bef calling Rate API ');
1221: dbms_output.put_line('st dt :'||l_rt_start_date_tab.count);
1222: dbms_output.put_line(' p_projfunc_rev_rt_dt_code_tab ' || l_rt_pfunc_rev_rt_dt_code_tab.COUNT);
1223: dbms_output.put_line(' p_projfunc_rev_rt_date_tab ' || l_rt_pfunc_rev_rt_date_tab.COUNT);

Line 1346: PA_DEBUG.g_err_stage := '1200: aft calling RATE API calc_rate_amount ';

1342: END IF;
1343: /*End of fix for bug 2420564*/
1344:
1345: /* dbms_output.put_line('aft calling Rate API '); */
1346: PA_DEBUG.g_err_stage := '1200: aft calling RATE API calc_rate_amount ';
1347: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1348: EXCEPTION
1349: WHEN OTHERS THEN
1350: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id );

Line 1347: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1343: /*End of fix for bug 2420564*/
1344:
1345: /* dbms_output.put_line('aft calling Rate API '); */
1346: PA_DEBUG.g_err_stage := '1200: aft calling RATE API calc_rate_amount ';
1347: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1348: EXCEPTION
1349: WHEN OTHERS THEN
1350: UPDATE_BUDG_VERSION(p_budget_version_id => l_budget_version_id );
1351: RAISE;

Line 1425: PA_DEBUG.g_err_stage := '1300: after calling RATE API';

1421: l_other_reject_reason := NULL;
1422: END IF;
1423:
1424:
1425: PA_DEBUG.g_err_stage := '1300: after calling RATE API';
1426: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1427:
1428: PA_DEBUG.g_err_stage := '1350: before checking in the PL/SQL TABLE';
1429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1426: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1422: END IF;
1423:
1424:
1425: PA_DEBUG.g_err_stage := '1300: after calling RATE API';
1426: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1427:
1428: PA_DEBUG.g_err_stage := '1350: before checking in the PL/SQL TABLE';
1429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1430:

Line 1428: PA_DEBUG.g_err_stage := '1350: before checking in the PL/SQL TABLE';

1424:
1425: PA_DEBUG.g_err_stage := '1300: after calling RATE API';
1426: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1427:
1428: PA_DEBUG.g_err_stage := '1350: before checking in the PL/SQL TABLE';
1429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1430:
1431: l_period_name_flag := 'N';
1432: FOR l_cnt IN 1 .. l_budget_lines_tbl.COUNT LOOP

Line 1429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1425: PA_DEBUG.g_err_stage := '1300: after calling RATE API';
1426: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1427:
1428: PA_DEBUG.g_err_stage := '1350: before checking in the PL/SQL TABLE';
1429: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1430:
1431: l_period_name_flag := 'N';
1432: FOR l_cnt IN 1 .. l_budget_lines_tbl.COUNT LOOP
1433: IF l_budget_lines_tbl(l_cnt).period_name = l_fcst_period_name THEN

Line 1458: PA_DEBUG.g_err_stage := '1400: after checking in the PL/SQL TABLE';

1454: l_budget_lines_tbl(l_current_index).other_rejection_code := l_other_reject_reason;
1455: l_current_index := l_current_index + 1;
1456: END IF;
1457:
1458: PA_DEBUG.g_err_stage := '1400: after checking in the PL/SQL TABLE';
1459: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1460:
1461: PA_DEBUG.g_err_stage := '1450: before checking in the PL/SQL TABLE for TOTALS';
1462: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1459: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1455: l_current_index := l_current_index + 1;
1456: END IF;
1457:
1458: PA_DEBUG.g_err_stage := '1400: after checking in the PL/SQL TABLE';
1459: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1460:
1461: PA_DEBUG.g_err_stage := '1450: before checking in the PL/SQL TABLE for TOTALS';
1462: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1463:

Line 1461: PA_DEBUG.g_err_stage := '1450: before checking in the PL/SQL TABLE for TOTALS';

1457:
1458: PA_DEBUG.g_err_stage := '1400: after checking in the PL/SQL TABLE';
1459: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1460:
1461: PA_DEBUG.g_err_stage := '1450: before checking in the PL/SQL TABLE for TOTALS';
1462: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1463:
1464: l_period_name_tot_flag := 'N';
1465: FOR l_cnt IN 1 .. l_budget_lines_tot_tbl.COUNT LOOP

Line 1462: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1458: PA_DEBUG.g_err_stage := '1400: after checking in the PL/SQL TABLE';
1459: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1460:
1461: PA_DEBUG.g_err_stage := '1450: before checking in the PL/SQL TABLE for TOTALS';
1462: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1463:
1464: l_period_name_tot_flag := 'N';
1465: FOR l_cnt IN 1 .. l_budget_lines_tot_tbl.COUNT LOOP
1466: IF l_budget_lines_tot_tbl(l_cnt).period_name = l_fcst_period_name THEN

Line 1491: PA_DEBUG.g_err_stage := '1500: before checking in the PL/SQL TABLE for TOTALS';

1487: l_tot_cost := l_tot_cost + l_projfunc_raw_cost;
1488: l_tot_revenue := l_tot_revenue + l_projfunc_raw_revenue;
1489: l_tot_bcost := l_tot_bcost + l_projfunc_burdened_cost;
1490:
1491: PA_DEBUG.g_err_stage := '1500: before checking in the PL/SQL TABLE for TOTALS';
1492: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1493:
1494: END LOOP; -- after arriving at pdwise totals
1495:

Line 1492: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1488: l_tot_revenue := l_tot_revenue + l_projfunc_raw_revenue;
1489: l_tot_bcost := l_tot_bcost + l_projfunc_burdened_cost;
1490:
1491: PA_DEBUG.g_err_stage := '1500: before checking in the PL/SQL TABLE for TOTALS';
1492: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1493:
1494: END LOOP; -- after arriving at pdwise totals
1495:
1496: /* Added for Bulk Insert */

Line 1560: PA_DEBUG.g_err_stage := '1525: bef populating tabs for BL ins for RLM 101';

1556: l_bl_rev_rej_tab.delete;
1557: l_bl_oth_rej_tab.delete;
1558:
1559:
1560: PA_DEBUG.g_err_stage := '1525: bef populating tabs for BL ins for RLM 101';
1561: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1562:
1563: FOR l_counter IN 1 .. L_BUDGET_LINES_TBL.COUNT LOOP
1564:

Line 1561: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1557: l_bl_oth_rej_tab.delete;
1558:
1559:
1560: PA_DEBUG.g_err_stage := '1525: bef populating tabs for BL ins for RLM 101';
1561: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1562:
1563: FOR l_counter IN 1 .. L_BUDGET_LINES_TBL.COUNT LOOP
1564:
1565: PA_DEBUG.g_err_stage := 'st dt :'||to_char(l_budget_lines_tbl(l_counter).start_date,

Line 1565: PA_DEBUG.g_err_stage := 'st dt :'||to_char(l_budget_lines_tbl(l_counter).start_date,

1561: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1562:
1563: FOR l_counter IN 1 .. L_BUDGET_LINES_TBL.COUNT LOOP
1564:
1565: PA_DEBUG.g_err_stage := 'st dt :'||to_char(l_budget_lines_tbl(l_counter).start_date,
1566: 'dd-mon-yyyy');
1567: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1568: l_bl_start_date_tab(l_counter) := l_budget_lines_tbl(l_counter).start_date;
1569: l_bl_end_date_tab(l_counter) := l_budget_lines_tbl(l_counter).end_date;

Line 1567: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1563: FOR l_counter IN 1 .. L_BUDGET_LINES_TBL.COUNT LOOP
1564:
1565: PA_DEBUG.g_err_stage := 'st dt :'||to_char(l_budget_lines_tbl(l_counter).start_date,
1566: 'dd-mon-yyyy');
1567: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1568: l_bl_start_date_tab(l_counter) := l_budget_lines_tbl(l_counter).start_date;
1569: l_bl_end_date_tab(l_counter) := l_budget_lines_tbl(l_counter).end_date;
1570: l_bl_pd_name_tab(l_counter) := l_budget_lines_tbl(l_counter).period_name;
1571: l_bl_qty_tab(l_counter) := l_budget_lines_tbl(l_counter).quantity;

Line 1581: PA_DEBUG.g_err_stage := '1530: aft populating tabs for BL ins for RLM 101 : ' ||

1577: l_bl_rev_rej_tab(l_counter) := l_budget_lines_tbl(l_counter).revenue_rejection_code;
1578: l_bl_oth_rej_tab(l_counter) := l_budget_lines_tbl(l_counter).other_rejection_code;
1579: END LOOP;
1580:
1581: PA_DEBUG.g_err_stage := '1530: aft populating tabs for BL ins for RLM 101 : ' ||
1582: L_BUDGET_LINES_TBL.COUNT;
1583: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1584:
1585: PA_DEBUG.g_err_stage := '1540: bef bulk ins into BL for RLM 101';

Line 1583: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1579: END LOOP;
1580:
1581: PA_DEBUG.g_err_stage := '1530: aft populating tabs for BL ins for RLM 101 : ' ||
1582: L_BUDGET_LINES_TBL.COUNT;
1583: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1584:
1585: PA_DEBUG.g_err_stage := '1540: bef bulk ins into BL for RLM 101';
1586: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1587: PA_DEBUG.g_err_stage := 'res asg id :'|| l_resource_assignment_id;

Line 1585: PA_DEBUG.g_err_stage := '1540: bef bulk ins into BL for RLM 101';

1581: PA_DEBUG.g_err_stage := '1530: aft populating tabs for BL ins for RLM 101 : ' ||
1582: L_BUDGET_LINES_TBL.COUNT;
1583: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1584:
1585: PA_DEBUG.g_err_stage := '1540: bef bulk ins into BL for RLM 101';
1586: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1587: PA_DEBUG.g_err_stage := 'res asg id :'|| l_resource_assignment_id;
1588: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1589:

Line 1586: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1582: L_BUDGET_LINES_TBL.COUNT;
1583: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1584:
1585: PA_DEBUG.g_err_stage := '1540: bef bulk ins into BL for RLM 101';
1586: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1587: PA_DEBUG.g_err_stage := 'res asg id :'|| l_resource_assignment_id;
1588: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1589:
1590: FORALL l_ins_temp IN 1 .. L_BUDGET_LINES_TBL.COUNT

Line 1587: PA_DEBUG.g_err_stage := 'res asg id :'|| l_resource_assignment_id;

1583: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1584:
1585: PA_DEBUG.g_err_stage := '1540: bef bulk ins into BL for RLM 101';
1586: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1587: PA_DEBUG.g_err_stage := 'res asg id :'|| l_resource_assignment_id;
1588: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1589:
1590: FORALL l_ins_temp IN 1 .. L_BUDGET_LINES_TBL.COUNT
1591: INSERT INTO PA_BUDGET_LINES(

Line 1588: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1584:
1585: PA_DEBUG.g_err_stage := '1540: bef bulk ins into BL for RLM 101';
1586: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1587: PA_DEBUG.g_err_stage := 'res asg id :'|| l_resource_assignment_id;
1588: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1589:
1590: FORALL l_ins_temp IN 1 .. L_BUDGET_LINES_TBL.COUNT
1591: INSERT INTO PA_BUDGET_LINES(
1592: BUDGET_LINE_ID, /* FPB2 */

Line 1643: PA_DEBUG.g_err_stage := '1550: aft bulk ins into BL for RLM 101 : '||

1639: /*Code Changes for Bug No.2984871 start */
1640: l_rowcount:=sql%rowcount;
1641: /*Code Changes for Bug No.2984871 end */
1642:
1643: PA_DEBUG.g_err_stage := '1550: aft bulk ins into BL for RLM 101 : '||
1644: l_rowcount;
1645: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1646: /* Bug 2984871: replaced sql%rowcount with l_rowcount */
1647: l_commit_cnt := l_commit_cnt + l_rowcount;

Line 1645: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1641: /*Code Changes for Bug No.2984871 end */
1642:
1643: PA_DEBUG.g_err_stage := '1550: aft bulk ins into BL for RLM 101 : '||
1644: l_rowcount;
1645: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1646: /* Bug 2984871: replaced sql%rowcount with l_rowcount */
1647: l_commit_cnt := l_commit_cnt + l_rowcount;
1648: IF l_commit_cnt >= l_commit_size THEN
1649: COMMIT;

Line 1697: PA_DEBUG.g_err_stage := '1800: after fetching all project assignments records';

1693: l_commit_cnt := 0;
1694: END IF;
1695: END LOOP; -- for Assignments
1696: CLOSE PROJ_ASSIGNMENTS;
1697: PA_DEBUG.g_err_stage := '1800: after fetching all project assignments records';
1698: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1699:
1700: l_prj_res_assignment_id := NULL;
1701: /* create res assignment record for RLM Is 103 for storing Periodwise TOTALS */

Line 1698: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1694: END IF;
1695: END LOOP; -- for Assignments
1696: CLOSE PROJ_ASSIGNMENTS;
1697: PA_DEBUG.g_err_stage := '1800: after fetching all project assignments records';
1698: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1699:
1700: l_prj_res_assignment_id := NULL;
1701: /* create res assignment record for RLM Is 103 for storing Periodwise TOTALS */
1702: PA_DEBUG.g_err_stage := '1900: before getting RA Id for RLM Id 103';

Line 1702: PA_DEBUG.g_err_stage := '1900: before getting RA Id for RLM Id 103';

1698: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1699:
1700: l_prj_res_assignment_id := NULL;
1701: /* create res assignment record for RLM Is 103 for storing Periodwise TOTALS */
1702: PA_DEBUG.g_err_stage := '1900: before getting RA Id for RLM Id 103';
1703: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1704: IF l_budget_lines_tot_tbl.count > 0 THEN
1705: BEGIN
1706: SELECT RESOURCE_ASSIGNMENT_ID

Line 1703: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1699:
1700: l_prj_res_assignment_id := NULL;
1701: /* create res assignment record for RLM Is 103 for storing Periodwise TOTALS */
1702: PA_DEBUG.g_err_stage := '1900: before getting RA Id for RLM Id 103';
1703: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1704: IF l_budget_lines_tot_tbl.count > 0 THEN
1705: BEGIN
1706: SELECT RESOURCE_ASSIGNMENT_ID
1707: INTO l_prj_res_assignment_id

Line 1748: PA_DEBUG.g_err_stage := '2000: after getting RA Id for RLM Id 103';

1744: NULL,
1745: -1 ); -- x_track_as_labor_flag
1746: END;
1747:
1748: PA_DEBUG.g_err_stage := '2000: after getting RA Id for RLM Id 103';
1749: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1750: /* Create budget lines to store periodwise totals from the table */
1751:
1752: PA_DEBUG.g_err_stage := '2100: bef populate tabs for ins into BL RLMId 103: '||

Line 1749: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1745: -1 ); -- x_track_as_labor_flag
1746: END;
1747:
1748: PA_DEBUG.g_err_stage := '2000: after getting RA Id for RLM Id 103';
1749: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1750: /* Create budget lines to store periodwise totals from the table */
1751:
1752: PA_DEBUG.g_err_stage := '2100: bef populate tabs for ins into BL RLMId 103: '||
1753: 'BL tot tbl cnt:'||l_budget_lines_tot_tbl.count;

Line 1752: PA_DEBUG.g_err_stage := '2100: bef populate tabs for ins into BL RLMId 103: '||

1748: PA_DEBUG.g_err_stage := '2000: after getting RA Id for RLM Id 103';
1749: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1750: /* Create budget lines to store periodwise totals from the table */
1751:
1752: PA_DEBUG.g_err_stage := '2100: bef populate tabs for ins into BL RLMId 103: '||
1753: 'BL tot tbl cnt:'||l_budget_lines_tot_tbl.count;
1754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1755:
1756: l_bl_start_date_tab.delete;

Line 1754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1750: /* Create budget lines to store periodwise totals from the table */
1751:
1752: PA_DEBUG.g_err_stage := '2100: bef populate tabs for ins into BL RLMId 103: '||
1753: 'BL tot tbl cnt:'||l_budget_lines_tot_tbl.count;
1754: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1755:
1756: l_bl_start_date_tab.delete;
1757: l_bl_end_date_tab.delete;
1758: l_bl_pd_name_tab.delete;

Line 1781: PA_DEBUG.g_err_stage := '2125:aft populating tables for insert into BL RLMId 103 and bef bulk ins';

1777: l_bl_revenue_tab(cnt_temp) := l_budget_lines_tot_tbl(cnt_temp).revenue;
1778: END IF;
1779: END LOOP;
1780:
1781: PA_DEBUG.g_err_stage := '2125:aft populating tables for insert into BL RLMId 103 and bef bulk ins';
1782: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1783:
1784: FORALL l_ins_temp IN 1 .. l_budget_lines_tot_tbl.count
1785: INSERT INTO PA_BUDGET_LINES(

Line 1782: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1778: END IF;
1779: END LOOP;
1780:
1781: PA_DEBUG.g_err_stage := '2125:aft populating tables for insert into BL RLMId 103 and bef bulk ins';
1782: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1783:
1784: FORALL l_ins_temp IN 1 .. l_budget_lines_tot_tbl.count
1785: INSERT INTO PA_BUDGET_LINES(
1786: BUDGET_LINE_ID, /* FPB2 */

Line 1830: PA_DEBUG.g_err_stage := '2200: after bulk inserting into BLines for RLMId 103:'||l_rowcount;

1826: /*Code Changes for Bug No.2984871 end */
1827: COMMIT;
1828:
1829: /* Bug 2984871: replaced SQL%ROWCOUNT with l_rowcount in the below line */
1830: PA_DEBUG.g_err_stage := '2200: after bulk inserting into BLines for RLMId 103:'||l_rowcount;
1831: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1832:
1833: PA_DEBUG.g_err_stage := '2300: before checking for REV GEN Md';
1834: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1831: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1827: COMMIT;
1828:
1829: /* Bug 2984871: replaced SQL%ROWCOUNT with l_rowcount in the below line */
1830: PA_DEBUG.g_err_stage := '2200: after bulk inserting into BLines for RLMId 103:'||l_rowcount;
1831: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1832:
1833: PA_DEBUG.g_err_stage := '2300: before checking for REV GEN Md';
1834: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1835:

Line 1833: PA_DEBUG.g_err_stage := '2300: before checking for REV GEN Md';

1829: /* Bug 2984871: replaced SQL%ROWCOUNT with l_rowcount in the below line */
1830: PA_DEBUG.g_err_stage := '2200: after bulk inserting into BLines for RLMId 103:'||l_rowcount;
1831: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1832:
1833: PA_DEBUG.g_err_stage := '2300: before checking for REV GEN Md';
1834: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1835:
1836: IF l_rev_gen_method = 'E' THEN
1837: IF l_project_value IS NULL THEN

Line 1834: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1830: PA_DEBUG.g_err_stage := '2200: after bulk inserting into BLines for RLMId 103:'||l_rowcount;
1831: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1832:
1833: PA_DEBUG.g_err_stage := '2300: before checking for REV GEN Md';
1834: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1835:
1836: IF l_rev_gen_method = 'E' THEN
1837: IF l_project_value IS NULL THEN
1838: PA_DEBUG.g_err_stage := '2400: no prj value : bef updating err msg in event Based';

Line 1838: PA_DEBUG.g_err_stage := '2400: no prj value : bef updating err msg in event Based';

1834: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1835:
1836: IF l_rev_gen_method = 'E' THEN
1837: IF l_project_value IS NULL THEN
1838: PA_DEBUG.g_err_stage := '2400: no prj value : bef updating err msg in event Based';
1839: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1840:
1841: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_NO_PRJ_VALUE'
1842: WHERE

Line 1839: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1835:
1836: IF l_rev_gen_method = 'E' THEN
1837: IF l_project_value IS NULL THEN
1838: PA_DEBUG.g_err_stage := '2400: no prj value : bef updating err msg in event Based';
1839: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1840:
1841: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_NO_PRJ_VALUE'
1842: WHERE
1843: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;

Line 1847: PA_DEBUG.g_err_stage := '2450: no prj value : aft updating err msg in event Based';

1843: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
1844:
1845: l_plan_processing_code := 'E';
1846:
1847: PA_DEBUG.g_err_stage := '2450: no prj value : aft updating err msg in event Based';
1848: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1849: ELSE
1850: l_prj_revenue_tab.delete;
1851: PA_DEBUG.g_err_stage := '2400: before calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';

Line 1848: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1844:
1845: l_plan_processing_code := 'E';
1846:
1847: PA_DEBUG.g_err_stage := '2450: no prj value : aft updating err msg in event Based';
1848: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1849: ELSE
1850: l_prj_revenue_tab.delete;
1851: PA_DEBUG.g_err_stage := '2400: before calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1852: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1851: PA_DEBUG.g_err_stage := '2400: before calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';

1847: PA_DEBUG.g_err_stage := '2450: no prj value : aft updating err msg in event Based';
1848: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1849: ELSE
1850: l_prj_revenue_tab.delete;
1851: PA_DEBUG.g_err_stage := '2400: before calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1852: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1853:
1854: BEGIN
1855: PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE(

Line 1852: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1848: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1849: ELSE
1850: l_prj_revenue_tab.delete;
1851: PA_DEBUG.g_err_stage := '2400: before calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1852: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1853:
1854: BEGIN
1855: PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE(
1856: p_project_id => p_project_id,

Line 1873: PA_DEBUG.g_err_stage := '2450: after calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';

1869: UPDATE_BUDG_VERSION( p_budget_version_id => l_budget_version_id );
1870: RAISE;
1871: END;
1872:
1873: PA_DEBUG.g_err_stage := '2450: after calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1874: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1875: IF l_event_error_msg IS NULL THEN
1876: PA_DEBUG.g_err_stage := '2500: before upserting in PA_BUDGET_LINES';
1877: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1874: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1870: RAISE;
1871: END;
1872:
1873: PA_DEBUG.g_err_stage := '2450: after calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1874: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1875: IF l_event_error_msg IS NULL THEN
1876: PA_DEBUG.g_err_stage := '2500: before upserting in PA_BUDGET_LINES';
1877: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1878:

Line 1876: PA_DEBUG.g_err_stage := '2500: before upserting in PA_BUDGET_LINES';

1872:
1873: PA_DEBUG.g_err_stage := '2450: after calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1874: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1875: IF l_event_error_msg IS NULL THEN
1876: PA_DEBUG.g_err_stage := '2500: before upserting in PA_BUDGET_LINES';
1877: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1878:
1879: FOR l_counter IN 1 .. l_prj_revenue_tab.count LOOP
1880: UPDATE PA_BUDGET_LINES SET REVENUE = l_prj_revenue_tab(l_counter).amount

Line 1877: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1873: PA_DEBUG.g_err_stage := '2450: after calling PA_RATE_PVT_PKG.CALC_EVENT_BASED_REVENUE';
1874: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1875: IF l_event_error_msg IS NULL THEN
1876: PA_DEBUG.g_err_stage := '2500: before upserting in PA_BUDGET_LINES';
1877: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1878:
1879: FOR l_counter IN 1 .. l_prj_revenue_tab.count LOOP
1880: UPDATE PA_BUDGET_LINES SET REVENUE = l_prj_revenue_tab(l_counter).amount
1881: WHERE

Line 1933: PA_DEBUG.g_err_stage := '2600: after upserting in PA_BUDGET_LINES for event based';

1929: l_commit_cnt := 0;
1930: END IF;
1931:
1932: END LOOP;
1933: PA_DEBUG.g_err_stage := '2600: after upserting in PA_BUDGET_LINES for event based';
1934: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1935: ELSE
1936: PA_DEBUG.g_err_stage := '2500: no prj value : bef updating err msg in Event Based';
1937: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1934: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1930: END IF;
1931:
1932: END LOOP;
1933: PA_DEBUG.g_err_stage := '2600: after upserting in PA_BUDGET_LINES for event based';
1934: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1935: ELSE
1936: PA_DEBUG.g_err_stage := '2500: no prj value : bef updating err msg in Event Based';
1937: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1938:

Line 1936: PA_DEBUG.g_err_stage := '2500: no prj value : bef updating err msg in Event Based';

1932: END LOOP;
1933: PA_DEBUG.g_err_stage := '2600: after upserting in PA_BUDGET_LINES for event based';
1934: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1935: ELSE
1936: PA_DEBUG.g_err_stage := '2500: no prj value : bef updating err msg in Event Based';
1937: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1938:
1939: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_PDS_NOT_DEFINED'
1940: WHERE

Line 1937: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1933: PA_DEBUG.g_err_stage := '2600: after upserting in PA_BUDGET_LINES for event based';
1934: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1935: ELSE
1936: PA_DEBUG.g_err_stage := '2500: no prj value : bef updating err msg in Event Based';
1937: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1938:
1939: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_PDS_NOT_DEFINED'
1940: WHERE
1941: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;

Line 1945: PA_DEBUG.g_err_stage := '2600: no prj value : aft updating err msg in Event Based';

1941: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
1942:
1943: l_plan_processing_code := 'E';
1944:
1945: PA_DEBUG.g_err_stage := '2600: no prj value : aft updating err msg in Event Based';
1946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1947:
1948: END IF; -- for if l_event_error_msg
1949: END IF; -- if the project value is null

Line 1946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1942:
1943: l_plan_processing_code := 'E';
1944:
1945: PA_DEBUG.g_err_stage := '2600: no prj value : aft updating err msg in Event Based';
1946: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1947:
1948: END IF; -- for if l_event_error_msg
1949: END IF; -- if the project value is null
1950: ELSIF l_rev_gen_method = 'C' THEN

Line 1955: PA_DEBUG.g_err_stage := '2700: Inside REV GEN MD C - before fetching BUDGET_LINES into Table';

1951: IF l_project_value IS NOT NULL THEN
1952: l_cost_cnt := 1;
1953: l_prj_cost_tab.delete;
1954: l_prj_revenue_tab.delete;
1955: PA_DEBUG.g_err_stage := '2700: Inside REV GEN MD C - before fetching BUDGET_LINES into Table';
1956: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1957: OPEN BUDGET_LINES(l_budget_version_id,p_project_id,l_prj_res_assignment_id);
1958: LOOP
1959: FETCH BUDGET_LINES INTO l_prj_cost_tab(l_cost_cnt).period_name,

Line 1956: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1952: l_cost_cnt := 1;
1953: l_prj_cost_tab.delete;
1954: l_prj_revenue_tab.delete;
1955: PA_DEBUG.g_err_stage := '2700: Inside REV GEN MD C - before fetching BUDGET_LINES into Table';
1956: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1957: OPEN BUDGET_LINES(l_budget_version_id,p_project_id,l_prj_res_assignment_id);
1958: LOOP
1959: FETCH BUDGET_LINES INTO l_prj_cost_tab(l_cost_cnt).period_name,
1960: l_prj_cost_tab(l_cost_cnt).start_date,

Line 1970: PA_DEBUG.g_err_stage := '2750: after fetching BUDGET_LINES into PL/SQL table';

1966: END LOOP;
1967:
1968: CLOSE BUDGET_LINES;
1969:
1970: PA_DEBUG.g_err_stage := '2750: after fetching BUDGET_LINES into PL/SQL table';
1971: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1972:
1973: PA_DEBUG.g_err_stage := '2800: before calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1974: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1971: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1967:
1968: CLOSE BUDGET_LINES;
1969:
1970: PA_DEBUG.g_err_stage := '2750: after fetching BUDGET_LINES into PL/SQL table';
1971: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1972:
1973: PA_DEBUG.g_err_stage := '2800: before calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1974: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1975: l_cost_based_error_code := NULL;

Line 1973: PA_DEBUG.g_err_stage := '2800: before calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';

1969:
1970: PA_DEBUG.g_err_stage := '2750: after fetching BUDGET_LINES into PL/SQL table';
1971: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1972:
1973: PA_DEBUG.g_err_stage := '2800: before calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1974: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1975: l_cost_based_error_code := NULL;
1976: BEGIN
1977: PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE(

Line 1974: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1970: PA_DEBUG.g_err_stage := '2750: after fetching BUDGET_LINES into PL/SQL table';
1971: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1972:
1973: PA_DEBUG.g_err_stage := '2800: before calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1974: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1975: l_cost_based_error_code := NULL;
1976: BEGIN
1977: PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE(
1978: p_project_id => p_project_id,

Line 1995: PA_DEBUG.g_err_stage := '2850: after calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';

1991: UPDATE_BUDG_VERSION( p_budget_version_id => l_budget_version_id );
1992: RAISE;
1993: END;
1994:
1995: PA_DEBUG.g_err_stage := '2850: after calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1996: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1997: IF l_cost_based_error_code IS NULL THEN
1998: PA_DEBUG.g_err_stage := '2900: bef upd PA_BUDGET_LINES for COST_BASED_REVENUE';
1999: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 1996: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1992: RAISE;
1993: END;
1994:
1995: PA_DEBUG.g_err_stage := '2850: after calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1996: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1997: IF l_cost_based_error_code IS NULL THEN
1998: PA_DEBUG.g_err_stage := '2900: bef upd PA_BUDGET_LINES for COST_BASED_REVENUE';
1999: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2000:

Line 1998: PA_DEBUG.g_err_stage := '2900: bef upd PA_BUDGET_LINES for COST_BASED_REVENUE';

1994:
1995: PA_DEBUG.g_err_stage := '2850: after calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1996: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1997: IF l_cost_based_error_code IS NULL THEN
1998: PA_DEBUG.g_err_stage := '2900: bef upd PA_BUDGET_LINES for COST_BASED_REVENUE';
1999: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2000:
2001: FOR l_cost_cnt IN 1 .. l_prj_revenue_tab.count LOOP
2002: UPDATE PA_BUDGET_LINES SET REVENUE = l_prj_revenue_tab(l_cost_cnt).amount

Line 1999: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

1995: PA_DEBUG.g_err_stage := '2850: after calling PA_RATE_PVT_PKG.CALC_COST_BASED_REVENUE';
1996: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
1997: IF l_cost_based_error_code IS NULL THEN
1998: PA_DEBUG.g_err_stage := '2900: bef upd PA_BUDGET_LINES for COST_BASED_REVENUE';
1999: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2000:
2001: FOR l_cost_cnt IN 1 .. l_prj_revenue_tab.count LOOP
2002: UPDATE PA_BUDGET_LINES SET REVENUE = l_prj_revenue_tab(l_cost_cnt).amount
2003: WHERE

Line 2013: PA_DEBUG.g_err_stage := '2950: after updating PA_BUDGET_LINES for COST_BASED_REVENUE';

2009: COMMIT;
2010: l_commit_cnt := 0;
2011: END IF;
2012: END LOOP;
2013: PA_DEBUG.g_err_stage := '2950: after updating PA_BUDGET_LINES for COST_BASED_REVENUE';
2014: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2015: ELSE
2016: l_plan_processing_code := 'E';
2017: PA_DEBUG.g_err_stage := '2900: bef upd PA_RES_ASG for err code n COST_BASED_REVENUE';

Line 2014: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2010: l_commit_cnt := 0;
2011: END IF;
2012: END LOOP;
2013: PA_DEBUG.g_err_stage := '2950: after updating PA_BUDGET_LINES for COST_BASED_REVENUE';
2014: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2015: ELSE
2016: l_plan_processing_code := 'E';
2017: PA_DEBUG.g_err_stage := '2900: bef upd PA_RES_ASG for err code n COST_BASED_REVENUE';
2018: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 2017: PA_DEBUG.g_err_stage := '2900: bef upd PA_RES_ASG for err code n COST_BASED_REVENUE';

2013: PA_DEBUG.g_err_stage := '2950: after updating PA_BUDGET_LINES for COST_BASED_REVENUE';
2014: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2015: ELSE
2016: l_plan_processing_code := 'E';
2017: PA_DEBUG.g_err_stage := '2900: bef upd PA_RES_ASG for err code n COST_BASED_REVENUE';
2018: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2019: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = l_cost_based_error_code
2020: WHERE
2021: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;

Line 2018: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2014: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2015: ELSE
2016: l_plan_processing_code := 'E';
2017: PA_DEBUG.g_err_stage := '2900: bef upd PA_RES_ASG for err code n COST_BASED_REVENUE';
2018: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2019: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = l_cost_based_error_code
2020: WHERE
2021: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
2022: END IF;

Line 2024: PA_DEBUG.g_err_stage := '2900: no prj value : bef updating err msg in Cost Based';

2020: WHERE
2021: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
2022: END IF;
2023: ELSE
2024: PA_DEBUG.g_err_stage := '2900: no prj value : bef updating err msg in Cost Based';
2025: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2026:
2027: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_NO_PRJ_VALUE'
2028: WHERE

Line 2025: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2021: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
2022: END IF;
2023: ELSE
2024: PA_DEBUG.g_err_stage := '2900: no prj value : bef updating err msg in Cost Based';
2025: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2026:
2027: UPDATE PA_RESOURCE_ASSIGNMENTS SET PLAN_ERROR_CODE = 'PA_FCST_NO_PRJ_VALUE'
2028: WHERE
2029: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;

Line 2033: PA_DEBUG.g_err_stage := '2950: no prj value : aft updating err msg in Cost Based';

2029: RESOURCE_ASSIGNMENT_ID =l_prj_res_assignment_id;
2030:
2031: l_plan_processing_code := 'E';
2032:
2033: PA_DEBUG.g_err_stage := '2950: no prj value : aft updating err msg in Cost Based';
2034: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2035:
2036: END IF; -- project value not null
2037: END IF; -- Rev gen method

Line 2034: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2030:
2031: l_plan_processing_code := 'E';
2032:
2033: PA_DEBUG.g_err_stage := '2950: no prj value : aft updating err msg in Cost Based';
2034: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2035:
2036: END IF; -- project value not null
2037: END IF; -- Rev gen method
2038: COMMIT;

Line 2039: PA_DEBUG.g_err_stage := '3000: before updating PA_RESOURCE_ASSIGNMENTS for REVENUE';

2035:
2036: END IF; -- project value not null
2037: END IF; -- Rev gen method
2038: COMMIT;
2039: PA_DEBUG.g_err_stage := '3000: before updating PA_RESOURCE_ASSIGNMENTS for REVENUE';
2040: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2041:
2042: /* Update Total Revenue in PA_RESOURCE_ASSIGNMENTS */
2043:

Line 2040: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2036: END IF; -- project value not null
2037: END IF; -- Rev gen method
2038: COMMIT;
2039: PA_DEBUG.g_err_stage := '3000: before updating PA_RESOURCE_ASSIGNMENTS for REVENUE';
2040: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2041:
2042: /* Update Total Revenue in PA_RESOURCE_ASSIGNMENTS */
2043:
2044: UPDATE PA_RESOURCE_ASSIGNMENTS RA SET

Line 2091: PA_DEBUG.g_err_stage := '3100: after updating PA_RESOURCE_ASSIGNMENTS for REVENUE';

2087: BUDGET_VERSION_ID = l_budget_version_id AND
2088: STANDARD_BILL_RATE <> 0 AND
2089: AVERAGE_BILL_RATE <> 0;
2090:
2091: PA_DEBUG.g_err_stage := '3100: after updating PA_RESOURCE_ASSIGNMENTS for REVENUE';
2092: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2093:
2094: PA_DEBUG.g_err_stage := '3200: before updating PA_BUDGET_VERSIONS for PLAN_PROCESSING_CODE';
2095: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 2092: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2088: STANDARD_BILL_RATE <> 0 AND
2089: AVERAGE_BILL_RATE <> 0;
2090:
2091: PA_DEBUG.g_err_stage := '3100: after updating PA_RESOURCE_ASSIGNMENTS for REVENUE';
2092: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2093:
2094: PA_DEBUG.g_err_stage := '3200: before updating PA_BUDGET_VERSIONS for PLAN_PROCESSING_CODE';
2095: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2096:

Line 2094: PA_DEBUG.g_err_stage := '3200: before updating PA_BUDGET_VERSIONS for PLAN_PROCESSING_CODE';

2090:
2091: PA_DEBUG.g_err_stage := '3100: after updating PA_RESOURCE_ASSIGNMENTS for REVENUE';
2092: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2093:
2094: PA_DEBUG.g_err_stage := '3200: before updating PA_BUDGET_VERSIONS for PLAN_PROCESSING_CODE';
2095: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2096:
2097: UPDATE PA_BUDGET_VERSIONS SET PLAN_PROCESSING_CODE = l_plan_processing_code,
2098: PLAN_RUN_DATE = SYSDATE

Line 2095: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2091: PA_DEBUG.g_err_stage := '3100: after updating PA_RESOURCE_ASSIGNMENTS for REVENUE';
2092: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2093:
2094: PA_DEBUG.g_err_stage := '3200: before updating PA_BUDGET_VERSIONS for PLAN_PROCESSING_CODE';
2095: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2096:
2097: UPDATE PA_BUDGET_VERSIONS SET PLAN_PROCESSING_CODE = l_plan_processing_code,
2098: PLAN_RUN_DATE = SYSDATE
2099: WHERE BUDGET_VERSION_ID = l_budget_version_id;

Line 2101: PA_DEBUG.g_err_stage := '3300: after updating PA_BUDGET_VERSIONS for PLAN_PROCESSING_CODE';

2097: UPDATE PA_BUDGET_VERSIONS SET PLAN_PROCESSING_CODE = l_plan_processing_code,
2098: PLAN_RUN_DATE = SYSDATE
2099: WHERE BUDGET_VERSION_ID = l_budget_version_id;
2100:
2101: PA_DEBUG.g_err_stage := '3300: after updating PA_BUDGET_VERSIONS for PLAN_PROCESSING_CODE';
2102: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2103: ELSE -- else for l_budget_lines_tot_tbl.count greater than zero
2104: /* The budget version record will be deleted if no forecast lines are generated,
2105: this change is made to avoid the error from the page. */

Line 2102: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2098: PLAN_RUN_DATE = SYSDATE
2099: WHERE BUDGET_VERSION_ID = l_budget_version_id;
2100:
2101: PA_DEBUG.g_err_stage := '3300: after updating PA_BUDGET_VERSIONS for PLAN_PROCESSING_CODE';
2102: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2103: ELSE -- else for l_budget_lines_tot_tbl.count greater than zero
2104: /* The budget version record will be deleted if no forecast lines are generated,
2105: this change is made to avoid the error from the page. */
2106: DELETE FROM PA_BUDGET_VERSIONS WHERE BUDGET_VERSION_ID = l_budget_version_id;

Line 2144: PA_DEBUG.g_err_stage := '3400: after Commiting';

2140: x_msg_index_out => l_msg_index_out );
2141: x_msg_count := l_msg_count;
2142: x_msg_data := l_msg_data;
2143: x_return_status := l_ret_status;
2144: PA_DEBUG.g_err_stage := '3400: after Commiting';
2145: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2146: PA_DEBUG.reset_err_stack;
2147: RETURN;
2148: EXCEPTION

Line 2145: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

2141: x_msg_count := l_msg_count;
2142: x_msg_data := l_msg_data;
2143: x_return_status := l_ret_status;
2144: PA_DEBUG.g_err_stage := '3400: after Commiting';
2145: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2146: PA_DEBUG.reset_err_stack;
2147: RETURN;
2148: EXCEPTION
2149: WHEN OTHERS THEN

Line 2146: PA_DEBUG.reset_err_stack;

2142: x_msg_data := l_msg_data;
2143: x_return_status := l_ret_status;
2144: PA_DEBUG.g_err_stage := '3400: after Commiting';
2145: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
2146: PA_DEBUG.reset_err_stack;
2147: RETURN;
2148: EXCEPTION
2149: WHEN OTHERS THEN
2150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;