709: p_api_type => G_API_TYPE,
710: p_msg_log => 'Entering Fpa_Project_Load_Pvt.Calc_Scenario_Wscores_Aw',
711: x_return_status => x_return_status);
712:
713: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
714: FND_LOG.String
715: ( FND_LOG.LEVEL_PROCEDURE,
716: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.begin',
717: 'Setting appropriate dimension limits.'
710: p_msg_log => 'Entering Fpa_Project_Load_Pvt.Calc_Scenario_Wscores_Aw',
711: x_return_status => x_return_status);
712:
713: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
714: FND_LOG.String
715: ( FND_LOG.LEVEL_PROCEDURE,
716: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.begin',
717: 'Setting appropriate dimension limits.'
718: );
711: x_return_status => x_return_status);
712:
713: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
714: FND_LOG.String
715: ( FND_LOG.LEVEL_PROCEDURE,
716: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.begin',
717: 'Setting appropriate dimension limits.'
718: );
719: END IF;
722: dbms_aw.execute('limit project_d to scenario_project_m');
723: dbms_aw.execute('limit planning_cycle_d to scenario_d');
724: dbms_aw.execute('limit strategic_obj_d to pc_obj_m');
725:
726: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
727: FND_LOG.String
728: ( FND_LOG.LEVEL_PROCEDURE,
729: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.',
730: 'Updating Approved Scores.'
723: dbms_aw.execute('limit planning_cycle_d to scenario_d');
724: dbms_aw.execute('limit strategic_obj_d to pc_obj_m');
725:
726: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
727: FND_LOG.String
728: ( FND_LOG.LEVEL_PROCEDURE,
729: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.',
730: 'Updating Approved Scores.'
731: );
724: dbms_aw.execute('limit strategic_obj_d to pc_obj_m');
725:
726: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
727: FND_LOG.String
728: ( FND_LOG.LEVEL_PROCEDURE,
729: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.',
730: 'Updating Approved Scores.'
731: );
732: END IF;
732: END IF;
733:
734: dbms_aw.execute('project_approved_obj_score_m = scenario_project_obj_score_m');
735:
736: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
737: FND_LOG.String
738: ( FND_LOG.LEVEL_PROCEDURE,
739: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.end',
740: 'Finished updating approved projects.'
733:
734: dbms_aw.execute('project_approved_obj_score_m = scenario_project_obj_score_m');
735:
736: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
737: FND_LOG.String
738: ( FND_LOG.LEVEL_PROCEDURE,
739: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.end',
740: 'Finished updating approved projects.'
741: );
734: dbms_aw.execute('project_approved_obj_score_m = scenario_project_obj_score_m');
735:
736: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
737: FND_LOG.String
738: ( FND_LOG.LEVEL_PROCEDURE,
739: 'FPA_Scorecard_Pvt.Update_Scenario_App_Scores.end',
740: 'Finished updating approved projects.'
741: );
742: END IF;
1102: return 'F';
1103:
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1107: FND_LOG.String(
1108: FND_LOG.LEVEL_PROCEDURE,
1109: 'fpa.sql.FPA_SCORECARD_PVT.Read_Only',
1110: 'EXCEPTION:'||sqlerrm||p_planning_cycle_id||','||p_scenario_id);
1103:
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1107: FND_LOG.String(
1108: FND_LOG.LEVEL_PROCEDURE,
1109: 'fpa.sql.FPA_SCORECARD_PVT.Read_Only',
1110: 'EXCEPTION:'||sqlerrm||p_planning_cycle_id||','||p_scenario_id);
1111: end if;
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1107: FND_LOG.String(
1108: FND_LOG.LEVEL_PROCEDURE,
1109: 'fpa.sql.FPA_SCORECARD_PVT.Read_Only',
1110: 'EXCEPTION:'||sqlerrm||p_planning_cycle_id||','||p_scenario_id);
1111: end if;
1112: return 'F';