505:
506: --dbms_output.put_line('big select statement executed');
507: -- Check whether workflow is being used for this project budget
508: -- If so, get the employee id based on the baselined_by_user_id
509: PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used
510: (p_draft_version_id => p_budget_version_id,
511: p_project_id => p_project_id,
512: p_budget_type_code => NULL,
513: p_pm_product_code => l_pm_product_code,
519: p_err_stack => l_msg_data);
520: If l_workflow_is_used = 'T' Then
521: v_emp_id := pa_utils.GetEmpIdFromUser(pa_budget_wf.g_baselined_by_user_id);
522: end if;
523: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used executed');
524: -- Verify budget rules if indicated
525: -- This API call is different from in PA_BUDGET_CORE.baseline
526: -- We need to set p_budget_type_code = null so that the verify API will use
527: -- p_fin_plan_type_id and p_version_type for the new budget model
1540: where budget_version_id = p_budget_version_id;
1541: --dbms_output.put_line('update pa_budget_versions statement executed');
1542: -- Check whether workflow is being used for this project budget
1543: -- If so, get the employee id based on the baselined_by_user_id
1544: PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used
1545: (p_draft_version_id => p_budget_version_id,
1546: p_project_id => p_project_id,
1547: p_budget_type_code => NULL,
1548: p_pm_product_code => l_pm_product_code,
1551: p_result => l_workflow_is_used,
1552: p_err_code => l_err_code,
1553: p_err_stage => l_err_stage,
1554: p_err_stack => l_err_stack);
1555: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used called');
1556: -- l_err_code = 0 ==> SUCCESS
1557: if l_err_code <> 0 then
1558: -- PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used returned errors
1559: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used: RETURNED ERRORS');
1554: p_err_stack => l_err_stack);
1555: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used called');
1556: -- l_err_code = 0 ==> SUCCESS
1557: if l_err_code <> 0 then
1558: -- PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used returned errors
1559: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used: RETURNED ERRORS');
1560: raise pa_fin_plan_pvt.check_wf_error;
1561: else
1562: If l_workflow_is_used = 'T' Then
1555: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used called');
1556: -- l_err_code = 0 ==> SUCCESS
1557: if l_err_code <> 0 then
1558: -- PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used returned errors
1559: --dbms_output.put_line('PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used: RETURNED ERRORS');
1560: raise pa_fin_plan_pvt.check_wf_error;
1561: else
1562: If l_workflow_is_used = 'T' Then
1563: v_emp_id := pa_utils.GetEmpIdFromUser(pa_budget_wf.g_baselined_by_user_id);