OAF Validate Attachment Validation EIT Controller Extension for Specific Request Oracle apps R12

-
OAF Validate Attachment EIT Controller Extension for Specific EIT Request Oracle apps R12

Make sure to Give super.processFormRequest(oapagecontext, oawebbean); at the end the processformrequest

package xxrco.oracle.apps.per.selfservice.review.webui;

import oracle.apps.fnd.framework.OAException;
import oracle.apps.fnd.framework.OAFwkConstants;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;
import oracle.apps.per.selfservice.review.webui.ReviewCO;
import oracle.apps.fnd.framework.OAApplicationModule;
import oracle.apps.fnd.framework.webui.beans.message.OAMessageAttachmentLinkBean;
import oracle.apps.fnd.framework.server.OAViewDef;
import oracle.apps.fnd.framework.OAViewObject;

import oracle.cabo.ui.UIConstants;
import oracle.apps.per.selfservice.review.common.ReviewParams;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

import oracle.apps.fnd.framework.server.OADBTransaction;
import oracle.apps.fnd.framework.OARow;
import oracle.apps.fnd.framework.server.OAViewObjectImpl;
import oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean;

import oracle.apps.fnd.server.OAAttachmentsAMImpl;
import oracle.jdbc.OracleCallableStatement;
import oracle.jdbc.OraclePreparedStatement;
//import oracle.apps.per.selfservice.common.SSHRParams;
//import oracle.apps.per.selfservice.common.SSHRParams;


public class ReviewCOEX extends ReviewCO {
    public ReviewCOEX() {
    }
 
    public void processRequest(OAPageContext oapagecontext,
                               OAWebBean oawebbean) {
        super.processRequest(oapagecontext, oawebbean);
                oapagecontext.writeDiagnostics(this,
                                             "Enter the PR Method of SummaryCOEx0",
                                             OAFwkConstants.STATEMENT);
             
                /*OAMessageAttachmentLinkBean att = (OAMessageAttachmentLinkBean)oawebbean.findIndexedChildRecursive("att1");
                      if(att != null)
                      {
                        att.setAutoCommitEnabled(Boolean.TRUE);
                      }**/
    OAMessageAttachmentLinkBean oamessageattachmentlinkbean = (OAMessageAttachmentLinkBean)oawebbean.findChildRecursive("AttachmentLink");
 
                          if(oamessageattachmentlinkbean!=null){
                              if (oapagecontext.isLoggingEnabled(1))
                                  oapagecontext.writeDiagnostics(this,
                                                                 "oamessageattachmentlinkbean  is not null ", 1);
                              oamessageattachmentlinkbean.setAutoCommitEnabled(Boolean.TRUE);
                          }else{
                              if (oapagecontext.isLoggingEnabled(1))
                                  oapagecontext.writeDiagnostics(this,
                                                                 "oamessageattachmentlinkbean  is  null ", 1);
                          }
                 

            }

public void processFormRequest(OAPageContext oapagecontext, OAWebBean oawebbean) {

    OAApplicationModule oaapplicationmodule = oapagecontext.getApplicationModule(oawebbean);
 
    if (oapagecontext.isLoggingEnabled(1))
                oapagecontext.writeDiagnostics(this,
                                               "funcid is" + oapagecontext.getParameter("OAFunc"),
                                               1);
    if ("CUSTOM_EDU_REIMB_EIT".equals(oapagecontext.getParameter("OAFunc"))){
            if (oapagecontext.getParameter("HrSubmit") != null) {
                oapagecontext.writeDiagnostics("In XXReviewCO", "Action Submit 2", 1);
                OAMessageAttachmentLinkBean oamessageattachmentlinkbean =
                    (OAMessageAttachmentLinkBean)oawebbean.findChildRecursive("AttachmentLink");
                String s =
                    (String)oamessageattachmentlinkbean.getAttributeValue(oapagecontext.getRenderingContext(),
                                                                          UIConstants.TEXT_ATTR);
             
                oapagecontext.writeDiagnostics("In XXReviewCO", "Action Submit 2",
                                               2);
         
            //ReviewParams reviewparams = new ReviewParams(oapagecontext.getRootApplicationModule().getTransaction());
                //String s7 = reviewparams.getTxStatus();//getTransactionId();
                //String s1 = reviewparams.getItemKey();
                String s2 = "  BEGIN :1 := xxtff_attached_status;   END;";
               // if(oapagecontext.isLoggingEnabled(1))
                //    oapagecontext.writeDiagnostics(this, "item key"+s1, 1);
                Integer s3=0;
                OADBTransaction oadbtransaction;
                oadbtransaction = oaapplicationmodule.getOADBTransaction();
                OracleCallableStatement oraclecallablestatement = (OracleCallableStatement)oadbtransaction.createCallableStatement(s2, 1);
                try
                {
                    //oraclecallablestatement.setString(1, s1);                             
                    oraclecallablestatement.registerOutParameter(1,Types.NUMERIC);
                    oraclecallablestatement.execute();
                    s3 = oraclecallablestatement.getInt(1);
                }
                catch(Exception exception1)
                {
                    throw OAException.wrapperException(exception1);
                }
             
             
                if(oapagecontext.isLoggingEnabled(1))
                    oapagecontext.writeDiagnostics(this, "after calling procedure", 1);
                if(oapagecontext.isLoggingEnabled(1))
                    oapagecontext.writeDiagnostics(this, "result is"+s3, 1);
                if (s3 == 0) {
                    throw new OAException("Attachment is required for this request");
                }
            }
    }
    super.processFormRequest(oapagecontext, oawebbean);
}
}

Comments

  1. Oracle Apps KT1 February 2021 at 20:59

    Can you please share the code of procedure 'xxtff_attached_status'. We have similar requirement.

    Thanks,
    Afzal.

    ReplyDelete
  2. prakashraaj25 July 2022 at 00:39

    CREATE OR REPLACE function APPS.xxtff_attached_status(p_transaction_id varchar2) return varchar2
    AS
    l_val varchar2(100);
    l_count number;
    begin



    SELECT COUNT (pk1_value)
    INTO l_count
    FROM fnd_attached_documents
    WHERE pk1_value LIKE '%' || p_transaction_id;

    IF l_count = 0 THEN

    RETURN 0;

    ELSE

    RETURN 1;

    END IF;


    EXCEPTION WHEN OTHERS THEN

    RETURN 0;

    END;
    /

    ReplyDelete

Post a Comment

Popular posts from this blog

Run BI Report Web Service Multiple Parameter date format Oracle Fusion BI Report xmlpserver/services/v2/ReportService WSDL

-
Image
  Run BI Publisher Report WSDL Web Service with Multiple Parameter which includes date format in oracle fusion We will use the below WSDL web service for Running the BI Publisher Report to extract the output in PDF. https://e.oraclecloud.com/xmlpserver/services/v2/ReportService?wsdl Create Data Model Sql Query select username,user_id,start_date,active_flag  from PER_USERS where user_id = nvl(:p_user_id,user_id) and trunc(start_date) = nvl(:p_start_date,trunc(start_date))   Parameter p_user_id p_start_date Output from the Data Model     Save the Data model /Custom/Human Capital Management/FusionReports/XXHRReportWEbSrv.xdm Create the Report   Select the existing data model Select the View List and Make sure the Output Formats as PDF selected as option.   Incase of updating the template delete the existing template and upload the new template.   Report Stored Path: /Custom/Human Capital Management/FusionReports/XXHRReportWEbSrvReport.xdo https://e.o...
Read more

Programmatically Create/Update User and assign roles in oracle Fusion using the REST Web Services Part 1

-
Image
Programmatically Create/Update User and assign roles in oracle Fusion using the REST Web Services  Part 1 Below are the steps that will be covered in this Post to Manage the User information using  REST Web Service using the Postman Tool 1) POST method to create a user along with Password and email using below REST Web service      / hcmRestApi/scim/Users 2) GET method to query the user  using below REST Web service      /hcmRestApi/scim/Users/{id} 3) PATCH method to update and assign the Roles to the user using below REST Web service      /hcmCoreSetupApi/scim/Roles/ {id}  4) PATCH method to update the user information  using below REST Web service      /hcmRestApi/scim/Users/{id}        Three Operations  will be Performed in Postman Tool 1) POST Operation used for CREATION 2)  GET Operation used for QUERY 3)  PATCH Operation used for UPDATE   REST Web ...
Read more

Oracle Fusion Multiple attachment for an Employee for a Single Document type HDL - HCM Data Loader

-
Image
  Multiple attachment for an Employee for a Single Document type Oracle Fusion   HDL - HCM Data Loader for Loading Document of Records   In our example we are going to use “ Return to Work ” as the document type.   Preparation of the Attachment Folder Create a Folder “ BlobFiles ”. Place four attachment file 109_RTW .pdf , 110_CRT.pdf, Check.txt, First.docx inside “ BlobFiles ” folder. The attachment files can be .pdf, .txt, .docx etc… Folder name should be only “ BlobFiles ”. If you provide some other name then it will complete with error.   Preparation of the dat File The dat file should have the name “ DocumentsOfRecords.dat” with the below information.   METADATA|DocumentsOfRecord|PersonNumber|DocumentType|Country|DocumentCode|DocumentName MERGE|DocumentsOfRecord|5791|Return to Work||5791 RTW|RTW Certificate from Dr METADATA|DocumentAttachment|PersonNumber|DocumentType|Country|DocumentCode|DataTypeCode|URLorTextorFileName|...
Read more