480: l_status VARCHAR2(120);
481: l_msg_count NUMBER;
482: l_err_stack VARCHAR2(250);
483:
484: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
485: /* Added for FP */
486: l_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
487: l_msg_data VARCHAR2(2000);
488: l_funding_bl_tab pa_fp_auto_baseline_pkg.funding_bl_tab;
735: pa_debug.g_err_stage:= 'return status is -'||l_return_status;
736: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
737: END IF;
738:
739: IF x_err_code = 0 and l_return_status = FND_API.G_RET_STS_SUCCESS then
740: IF l_plan_type_id is NULL THEN /* For bug 4198840*/
741: --dbms_output.put_line ('calling summerize ' );
742: IF P_PA_DEBUG_MODE = 'Y' THEN
743: pa_debug.g_err_stage:= 'Calling budget_utils summarize_project_totals';
828: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
829: pa_debug.g_err_stage:= 'return status - '||l_return_status;
830: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
831: END IF;
832: if x_err_code <> 0 or l_return_status <> FND_API.G_RET_STS_SUCCESS then
833: rollback to temp_pt;
834: IF P_PA_DEBUG_MODE = 'Y' THEN
835: pa_debug.g_err_stage:= 'Rolling back';
836: pa_debug.write('create_line: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);