1 2 Previous Next 16 Replies Latest reply on Oct 18, 2013 6:30 AM by bhuvanm

    How to set table cell color dynamically based on certain conditions

    949902

      Hello,

       

      My requirement is as follows:

      I have one simple table(not advance table) in the OAF page. Table consists of multiple columns and rows. Now based on first column value i want to color a cell.

       

      Eg. in the first row if values is "YES" then that cell should be colored out if it is "NO" then it should be as it is.

       

      for that i have written the below code using iterator in process request:

      if (value = "YES")

      {

                    CSSStyle csNum = new CSSStyle();
                     csNum.setProperty("background-color", "#FF0000"); //give Hexadecimal value for RED color
      OAMessageStyledTextBean bean =   (OAMessageStyledTextBean)oawebbean.findIndexedChildRecursive("CompName");
                    

      bean.setInlineStyle(csNum);

      }

      But this code is coloring out all the rows for that column whereas i want to color only to cell.

       

      Thanks in advance,

      sheetal

        • 1. Re: How to set table cell color dynamically based on certain conditions
          Mahesh112

          hi,

           

          As per my understanding, you are using table, so for that you have to take control of your table beam like :

           

          if (value = "YES")

          {

                       CSSStyle csNum = new CSSStyle();
                        csNum.setProperty("background-color", "#FF0000"); //give Hexadecimal value for RED color
          OATableBeanbean =   (OATableBean)oawebbean.findIndexedChildRecursive("CompName");
                       

          bean.setInlineStyle(csNum);

          }

          Why you are using messageStyledText beam?

          Please try the above and let me know.

           

          Regards

          Mahesh

          • 2. Re: How to set table cell color dynamically based on certain conditions
            949902

            If i use table bean then it will be applied to entire table. But i want to set color at cell level.

            • 3. Re: How to set table cell color dynamically based on certain conditions
              Gyan Darpan

              Hi,

               

              Use OADataBoundValueViewObject to color the cell based on condition.

               

              Cheers

              Gyan

              • 5. Re: How to set table cell color dynamically based on certain conditions
                949902

                Hello Gyan,

                 

                If i use OADataBoundValueViewObject then i need to extend my seeded VO. When i m trying to add a new column in Seeded VO, its throwing some error after deployment. my Seeded VO is CompetenceElementsVO.

                 

                Is there any other way to do it.

                 

                please help me.

                 

                Regards,

                sheetal mittal

                • 6. Re: How to set table cell color dynamically based on certain conditions
                  Gyan Darpan

                  Sheetal,

                   

                  You need to extend the View Object to achieve your requirement. Could you share the error you are getting after extending your view object.

                   

                  Cheers

                  Gyan

                  • 7. Re: How to set table cell color dynamically based on certain conditions
                    949902


                    Hi Gyan,

                     

                    Below error i got after extending CometenceElementsVO.Can you please suggest me why this error is coming:

                     

                    Exception Details.

                    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PCE.COMPETENCE_ELEMENT_ID, PCE.BUSINESS_GROUP_ID, PCE.COMPETENCE_ID, PCE.PROFICIENCY_LEVEL_ID, PCE.HIGH_PROFICIENCY_LEVEL_ID, PCE.WEIGHTING_LEVEL_ID, PCE.RATING_LEVEL_ID, PCE.PERSON_ID, PCE.ENTERPRISE_ID, PCE.JOB_ID, PCE.VALID_GRADE_ID, PCE.POSITION_ID, PCE.ORGANIZATION_ID, PCE.ASSESSMENT_ID, PCE.ASSESSMENT_TYPE_ID, PCE.COMMENTS, PCE.EFFECTIVE_DATE_FROM, PCE.EFFECTIVE_DATE_TO, PCE.LINE_SCORE, PCE.ATTRIBUTE_CATEGORY, PCE.ATTRIBUTE1, PCE.ATTRIBUTE2, PCE.ATTRIBUTE3, PCE.ATTRIBUTE4, PCE.ATTRIBUTE5, PCE.ATTRIBUTE6, PCE.ATTRIBUTE7, PCE.ATTRIBUTE8, PCE.ATTRIBUTE9, PCE.ATTRIBUTE10, PCE.ATTRIBUTE11, PCE.ATTRIBUTE12, PCE.ATTRIBUTE13, PCE.ATTRIBUTE14, PCE.ATTRIBUTE15, PCE.ATTRIBUTE16, PCE.ATTRIBUTE17, PCE.ATTRIBUTE18, PCE.ATTRIBUTE19, PCE.ATTRIBUTE20, PC.NAME, PC.COMPETENCE_ID AS COMPETENCE_ID1, PC.RATING_SCALE_ID, PC.COMPETENCE_ALIAS, DECODE(PCE3.TYPE,'ASSESSMENT','DisableCompDelete','ASSESSMENT_COMPETENCE','DisableCompDelete', nvl(( select distinct 'DisableCompDelete' from per_competence_elements where parent_competence_element_id = pce.competence_element_id),'EnableCompDelete')) AS DELETE_COMP, PCE.PARENT_COMPETENCE_ELEMENT_ID, PRL1.NAME AS PROF_LEVEL, PRL1.RATING_LEVEL_ID AS RATING_LEVEL_ID1, PRL2.NAME AS PERF_LEVEL, PRL2.RATING_LEVEL_ID AS RATING_LEVEL_ID2, PRL3.NAME AS WEIGH_LEVEL, PRL3.RATING_LEVEL_ID AS RATING_LEVEL_ID3, PCE.OBJECT_ID, PCE.OBJECT_NAME, PCE1.COMPETENCE_ELEMENT_ID AS REF1_COMP_ELEMENT_ID, PCE1.PROFICIENCY_LEVEL_ID AS REF1_PROF_LEVEL_ID, PCE1.WEIGHTING_LEVEL_ID AS REF1_WEIGH_LEVEL_ID, PCE1.RATING_LEVEL_ID AS REF1_PERF_LEVEL_ID, PCE1.COMMENTS AS REF1_COMMENTS, PCE1.ATTRIBUTE_CATEGORY AS REF1_ATTRIBUTE_CATEGORY, PCE1.ATTRIBUTE1 AS REF1_ATTRIBUTE1, PCE1.ATTRIBUTE2 AS REF1_ATTRIBUTE2, PCE1.ATTRIBUTE3 AS REF1_ATTRIBUTE3, PCE1.ATTRIBUTE4 AS REF1_ATTRIBUTE4, PCE1.ATTRIBUTE5 AS REF1_ATTRIBUTE5, PCE1.ATTRIBUTE6 AS REF1_ATTRIBUTE6, PCE1.ATTRIBUTE7 AS REF1_ATTRIBUTE7, PCE1.ATTRIBUTE8 AS REF1_ATTRIBUTE8, PCE1.ATTRIBUTE9 AS REF1_ATTRIBUTE9, PCE1.ATTRIBUTE10 AS REF1_ATTRIBUTE10, PCE1.ATTRIBUTE11 AS REF1_ATTRIBUTE11, PCE1.ATTRIBUTE12 AS REF1_ATTRIBUTE12, PCE1.ATTRIBUTE13 AS REF1_ATTRIBUTE13, PCE1.ATTRIBUTE14 AS REF1_ATTRIBUTE14, PCE1.ATTRIBUTE15 AS REF1_ATTRIBUTE15, PCE1.ATTRIBUTE16 AS REF1_ATTRIBUTE16, PCE1.ATTRIBUTE17 AS REF1_ATTRIBUTE17, PCE1.ATTRIBUTE18 AS REF1_ATTRIBUTE18, PCE1.ATTRIBUTE19 AS REF1_ATTRIBUTE19, PCE1.ATTRIBUTE20 AS REF1_ATTRIBUTE20, PCE2.COMPETENCE_ELEMENT_ID AS REF2_COMP_ELEMENT_ID, PCE2.PROFICIENCY_LEVEL_ID AS REF2_PROF_LEVEL_ID, PCE2.WEIGHTING_LEVEL_ID AS REF2_WEIGH_LEVEL_ID, PCE2.RATING_LEVEL_ID AS REF2_PERF_LEVEL_ID, PCE2.COMMENTS AS REF2_COMMENTS, PCE2.ATTRIBUTE_CATEGORY AS REF2_ATTRIBUTE_CATEGORY, PCE2.ATTRIBUTE1 AS REF2_ATTRIBUTE1, PCE2.ATTRIBUTE2 AS REF2_ATTRIBUTE2, PCE2.ATTRIBUTE3 AS REF2_ATTRIBUTE3, PCE2.ATTRIBUTE4 AS REF2_ATTRIBUTE4, PCE2.ATTRIBUTE5 AS REF2_ATTRIBUTE5, PCE2.ATTRIBUTE6 AS REF2_ATTRIBUTE6, PCE2.ATTRIBUTE7 AS REF2_ATTRIBUTE7, PCE2.ATTRIBUTE8 AS REF2_ATTRIBUTE8, PCE2.ATTRIBUTE9 AS REF2_ATTRIBUTE9, PCE2.ATTRIBUTE10 AS REF2_ATTRIBUTE10, PCE2.ATTRIBUTE11 AS REF2_ATTRIBUTE11, PCE2.ATTRIBUTE12 AS REF2_ATTRIBUTE12, PCE2.ATTRIBUTE13 AS REF2_ATTRIBUTE13, PCE2.ATTRIBUTE14 AS REF2_ATTRIBUTE14, PCE2.ATTRIBUTE15 AS REF2_ATTRIBUTE15, PCE2.ATTRIBUTE16 AS REF2_ATTRIBUTE16, PCE2.ATTRIBUTE17 AS REF2_ATTRIBUTE17, PCE2.ATTRIBUTE18 AS REF2_ATTRIBUTE18, PCE2.ATTRIBUTE19 AS REF2_ATTRIBUTE19, PCE2.ATTRIBUTE20 AS REF2_ATTRIBUTE20, PCE3.COMPETENCE_ELEMENT_ID AS PAR_COMP_ELEMENT_ID, PCE1.TYPE AS TYPE1, PCE2.TYPE AS TYPE2, PCE3.TYPE AS TYPE3, PCE.TYPE, (select decode(segment3,null,'OraErrorText','OraFieldtext') from PER_COMPETENCE_DEFINITIONS where COMPETENCE_DEFINITION_ID = pc.COMPETENCE_DEFINITION_ID and rownum=1) color FROM PER_COMPETENCE_ELEMENTS PCE, PER_COMPETENCES_VL PC, PER_RATING_LEVELS_VL PRL1, PER_RATING_LEVELS_VL PRL2, PER_RATING_LEVELS_VL PRL3, PER_COMPETENCE_ELEMENTS PCE1, PER_COMPETENCE_ELEMENTS PCE2, PER_COMPETENCE_ELEMENTS PCE3 WHERE PCE.COMPETENCE_ID = PC.COMPETENCE_ID AND PCE.PROFICIENCY_LEVEL_ID = PRL1.RATING_LEVEL_ID(+) AND PCE.RATING_LEVEL_ID = PRL2.RATING_LEVEL_ID(+) AND PCE.WEIGHTING_LEVEL_ID = PRL3.RATING_LEVEL_ID(+) AND PCE.COMPETENCE_ID = PCE1.COMPETENCE_ID AND PCE1.OBJECT_ID(+) = :1 AND PCE.ASSESSMENT_ID = PCE1.ASSESSMENT_ID(+) AND PCE1.OBJECT_NAME(+) = :2 AND PCE.COMPETENCE_ID = PCE2.COMPETENCE_ID AND PCE2.OBJECT_ID(+) = :3 AND PCE.ASSESSMENT_ID = PCE2.ASSESSMENT_ID(+) AND PCE2.OBJECT_NAME(+) = :4 AND PCE.PARENT_COMPETENCE_ELEMENT_ID = PCE3.COMPETENCE_ELEMENT_ID(+)) QRSLT WHERE (PCE.ASSESSMENT_ID = :5 AND PCE.OBJECT_ID = :6 AND PCE.OBJECT_NAME= :7) ORDER BY NAME at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797) at oracle.apps.per.selfservice.appraisals.webui.CompetenciesCO.processRequest(CompetenciesCO.java:58) at xxfahr.oracle.apps.xxfahr.webui.Ex32CompetenciesCO.processRequest(Ex32CompetenciesCO.java:41) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _OA._jspService(_OA.java:221) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _OA._jspService(_OA.java:221) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619) ## Detail 0 ## java.sql.SQLSyntaxErrorException: ORA-00904: "PCE"."OBJECT_NAME": invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439) at oracle.apps.per.selfservice.appraisals.server.CompetenceElementsVOImpl.initQuery(CompetenceElementsVOImpl.java:66) at oracle.apps.per.selfservice.appraisals.server.AssessmentsAMImpl.initAssessmentCompetencies(AssessmentsAMImpl.java:205) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797) at oracle.apps.per.selfservice.appraisals.webui.CompetenciesCO.processRequest(CompetenciesCO.java:58) at xxfahr.oracle.apps.xxfahr.webui.Ex32CompetenciesCO.processRequest(Ex32CompetenciesCO.java:41) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _OA._jspService(_OA.java:221) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _OA._jspService(_OA.java:221) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619) java.sql.SQLSyntaxErrorException: ORA-00904: "PCE"."OBJECT_NAME": invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439) at oracle.apps.per.selfservice.appraisals.server.CompetenceElementsVOImpl.initQuery(CompetenceElementsVOImpl.java:66) at oracle.apps.per.selfservice.appraisals.server.AssessmentsAMImpl.initAssessmentCompetencies(AssessmentsAMImpl.java:205) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797) at oracle.apps.per.selfservice.appraisals.webui.CompetenciesCO.processRequest(CompetenciesCO.java:58) at xxfahr.oracle.apps.xxfahr.webui.Ex32CompetenciesCO.processRequest(Ex32CompetenciesCO.java:41) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _OA._jspService(_OA.java:221) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _OA._jspService(_OA.java:221) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619)

                    • 8. Re: How to set table cell color dynamically based on certain conditions
                      Mahesh112

                      hi,

                       

                      check the below link :

                      https://forums.oracle.com/thread/2237704

                       

                      https://forums.oracle.com/thread/1776743

                       

                      check your new vo.xml file, all ok or not?

                       

                      Regards

                      Mahesh

                      • 9. Re: How to set table cell color dynamically based on certain conditions
                        Gyan Darpan

                        Sheetal,

                         

                        looking at your error java.sql.SQLSyntaxErrorException: ORA-00904: "PCE"."OBJECT_NAME": invalid identifier at oracle.jdbc.driver.T4CTTIoer.processError,

                         

                        it's look like positional parameter issue. Could you pls try to extend the VO once. If the error still exists, will extend the controller class and attach the attribute dynamically.

                         

                        Cheers

                        Gyan

                        • 10. Re: How to set table cell color dynamically based on certain conditions
                          949902

                          Hi Mahesh,

                           

                          I checked both the forum threads but it's still not working out. Let me know if we can add an attribute by using CO extension and do the same.

                           

                          Regards,

                          sheetal

                          • 11. Re: How to set table cell color dynamically based on certain conditions
                            949902

                            Hello Gyan,

                             

                            I checked my VO. xml file and removed VIEW_ATTR name and mapped it to column name but still its not working., Can you please tell me how can we add an attribute to VO by using CO exten and use it further to change the color.

                             

                            Regards,

                            sheetal

                            • 12. Re: How to set table cell color dynamically based on certain conditions
                              949902

                              Hello,

                               

                              I have tried adding a new VO attribute by code in controller. but its giving an error as null pointer in the below line:

                                      else if (vo.getCurrentRow().getAttribute("Color")==null)

                              please tell me where i m wrong..?

                               

                                   ViewObject vo =am.findViewObject("CompetenceElementsVO");
                                       if(vo==null)
                                       {
                                          vo= am.createViewObject("CompetenceElementsVO", "oracle.apps.per.selfservice.appraisals.server.CompetenceElementsVO");
                                       }
                                              else if (vo.getCurrentRow().getAttribute("Color")==null)
                                              {
                                                  vo.addDynamicAttribute("Color"); //Adding ViewAttribute to VO   
                                              }
                                          vo.reset();  
                                   vo.executeQuery();
                                   int fetchedRowCount = vo.getFetchedRowCount();
                                   RowSetIterator selectIter = vo.createRowSetIterator("selectIter");
                                   StringBuffer stringBuffer = new StringBuffer();  
                                     if (fetchedRowCount > 0)
                                      {
                                  selectIter.setRangeStart(0);
                                  selectIter.setRangeSize(fetchedRowCount);
                                   for (int i = 0; i < fetchedRowCount; i++)
                                   {
                                   CompetenceElementsVORowImpl rowi = (CompetenceElementsVORowImpl)selectIter.getRowAtRangeIndex(i);
                                    String StrCompId = rowi.getCompetenceId().toString();
                                       int output =0;
                                         String str_err_msg="";
                                         try
                                         {
                                           OADBTransaction dbtransaction = (OADBTransaction)am.getTransaction();
                                          CallableStatement cs  = dbtransaction.createCallableStatement("begin XXFAHR_PMS_OAF_VALIDATION_PKG.get_competence_type(:1,:2,:3);end;",1);
                                          cs.setString(1,StrCompId);
                                          cs.setString(2,strApprId);    
                                          cs.registerOutParameter(3, Types.INTEGER);  
                                          cs.execute();          
                                          output = cs.getInt(3); 
                                         }            
                                         catch (Exception e)
                                         {
                                           //throw new OAException("Error:"+str_err_msg,OAException.WARNING);
                                         }
                                                   stringBuffer.append("count="+fetchedRowCount+"--");                   

                                           if (output > 0)
                                             {            
                                           rowi.setAttribute("Color", "OraErrorText");
                                                 OAMessageStyledTextBean bean =   (OAMessageStyledTextBean)oawebbean.findIndexedChildRecursive("CompName");
                                                  OADataBoundValueViewObject tip = new OADataBoundValueViewObject(bean, "Color");
                                           bean.setAttributeValue(oracle.cabo.ui.UIConstants.SHORT_DESC_ATTR, tip);
                                           stringBuffer.append("red color="+rowi.getAttribute("Color")+"--");
                                       }
                                              else
                                              {
                                                  rowi.setAttribute("Color", "OraDataText");
                                                  OAMessageStyledTextBean bean =   (OAMessageStyledTextBean)oawebbean.findIndexedChildRecursive("CompName");
                                                  OADataBoundValueViewObject tip = new OADataBoundValueViewObject(bean, "Color");
                                                  bean.setAttributeValue(oracle.cabo.ui.UIConstants.SHORT_DESC_ATTR, tip);
                                                  stringBuffer.append("no color="+rowi.getAttribute("Color")+"--");
                                                
                                              }
                                            
                                            }
                                   }    
                                  selectIter.closeRowSetIterator();  

                              • 13. Re: How to set table cell color dynamically based on certain conditions
                                949902

                                Above Error has got resolved but still its not coloring out the desired rows.See the below code and tell me where i was going wrong in that...

                                 

                                     ViewObject vo =am.findViewObject("CompetenceElementsVO");            
                                                     if (vo != null) { 
                                                            try
                                                            { 
                                                              String transientAttr = vo.findAttributeDef("Color").toString(); 
                                                            } catch (Exception e)
                                                            { 
                                                              vo.addDynamicAttribute("Color"); 
                                                            } 
                                                          } 
                                                          else
                                                          {
                                                              vo= am.createViewObject("CompetenceElementsVO", "oracle.apps.per.selfservice.appraisals.server.CompetenceElementsVO");
                                                          }

                                            vo.reset();  
                                     vo.executeQuery();
                                     int fetchedRowCount = vo.getFetchedRowCount();
                                     RowSetIterator selectIter = vo.createRowSetIterator("selectIter");
                                     StringBuffer stringBuffer = new StringBuffer();  
                                       if (fetchedRowCount > 0)
                                        {
                                    selectIter.setRangeStart(0);
                                    selectIter.setRangeSize(fetchedRowCount);
                                     for (int i = 0; i < fetchedRowCount; i++)
                                     {
                                     CompetenceElementsVORowImpl rowi = (CompetenceElementsVORowImpl)selectIter.getRowAtRangeIndex(i);
                                      String StrCompId = rowi.getCompetenceId().toString();
                                         int output =0;
                                           String str_err_msg="";
                                           try
                                           {
                                             OADBTransaction dbtransaction = (OADBTransaction)am.getTransaction();
                                            CallableStatement cs  = dbtransaction.createCallableStatement("begin XXFAHR_PMS_OAF_VALIDATION_PKG.get_competence_type(:1,:2,:3);end;",1);
                                            cs.setString(1,StrCompId);
                                            cs.setString(2,strApprId);    
                                            cs.registerOutParameter(3, Types.INTEGER);  
                                            cs.execute();          
                                            output = cs.getInt(3); 
                                           }            
                                           catch (Exception e)
                                           {
                                             //throw new OAException("Error:"+str_err_msg,OAException.WARNING);
                                           }
                                                     stringBuffer.append("count="+fetchedRowCount+"--");                   

                                             if (output > 0)
                                               {            
                                             rowi.setAttribute("Color", "OraErrorText");
                                                   OAMessageStyledTextBean bean =   (OAMessageStyledTextBean)oawebbean.findIndexedChildRecursive("CompName");
                                                    OADataBoundValueViewObject tip = new OADataBoundValueViewObject(bean, "Color");
                                             bean.setAttributeValue(oracle.cabo.ui.UIConstants.SHORT_DESC_ATTR, tip);
                                             stringBuffer.append("red color="+rowi.getAttribute("Color")+"--");
                                         }

                                • 14. Re: How to set table cell color dynamically based on certain conditions
                                  Gyan Darpan

                                  Hi,

                                   

                                  Code looks fine, could you pls check the value for Output. I doubt that the flow of the code is going in the last block.

                                   

                                  Cheers

                                  Gyan

                                  1 2 Previous Next