MAFinalRatingsPageCO

package xxcus.oracle.apps.per.selfservice.appraisals.webui;

import java.sql.Connection;
import java.sql.PreparedStatement;

import java.sql.ResultSet;

import oracle.apps.fnd.framework.OAException;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;
import oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean;
import oracle.apps.per.selfservice.appraisals.webui.MAFinalRatingsPageCO;


public class MAFinalRatingsPageCOEx extends MAFinalRatingsPageCO {
    public MAFinalRatingsPageCOEx() {
    }

    public void processFormRequest(OAPageContext pc, OAWebBean wb) {
        if (pc.getParameter("Continue") != null && pc.getParameter("OverallRating") != null && pc.getParameter("OverallRating") != "")
        {
            String rating = pc.getParameter("OverallRating");
            String sql = "Select step_value from PER_RATING_LEVELS_VL where rating_level_id =" + rating;
            String display_val = null;
            Integer intVal = 0;
            try {
                    Connection conn = pc.getApplicationModule(wb).getOADBTransaction().getJdbcConnection();
                    PreparedStatement ps = conn.prepareStatement(sql);
                    ResultSet rs = ps.executeQuery();
                    rs.next();
                    display_val = rs.getString(1).trim();
                   
                    intVal = Integer.parseInt(display_val)+1;
                }
                catch (Exception e) {
                    e.printStackTrace();
                }

                if (display_val.equals("1") || display_val.equals("2") || display_val.equals("4") || display_val.equals("5"))
                {
                    if (pc.getParameter("OverallComments").trim().equals(null) || pc.getParameter("OverallComments") == "")
                    {
                        throw new OAException("Overall Comments is mandatory !", OAException.ERROR);
                    }
                }
        }
        super.processFormRequest(pc,wb);
    }
}