Function to remove unwanted characters etc in the output of xml tags in XML PUBLISHER













create or replace FUNCTION XXCUST_ENCODE_TO_XML

( p_value IN VARCHAR2

) RETURN VARCHAR2 AS

/*    +====================================================================+

--    Name:              XXCUST_ENCODE_TO_XML

--    Created by:        Unknown

--    Creation Date:     Unknown

--    Script:            XXCUST_ENCODE_TO_XML.sql

--    Description:       This procedure strips out special characters out of a character string

--

--    Change History:

--    ___________________________________________________________________________

--    Date          Name              Ticket#   PVCS Ver    Comments

--    ___________________________________________________________________________

--    +====================================================================*/


res varchar2(32000);

BEGIN

res:=p_value;


    IF (INSTR(res,'&' ) != 0) THEN

      res:=REPLACE(NVL(res,NULL),'&','&');

  END IF;


  IF (INSTR(res,'''' ) != 0) THEN

      res:= REPLACE(NVL(res,NULL),'''',''');

  END IF;

  IF (INSTR(res,'~' ) != 0) THEN

      res:= REPLACE(NVL(res,NULL),'~','');

  END IF;

  IF (INSTR(res,'�' ) != 0) THEN

      res:=REPLACE(NVL(res,NULL),'�','N');

  END IF;

 IF (INSTR(res,'<' ) != 0) THEN

      res:=REPLACE(NVL(res,NULL),'<','&lt;');

  END IF;

 IF (INSTR(res,'>' ) != 0) THEN

      res:=REPLACE(NVL(res,NULL),'>','&gt;');

  END IF;

  IF (INSTR(res,'�' ) != 0) THEN

      res:=REPLACE(NVL(res,NULL),'�','&deg;');

  END IF;

  IF (INSTR(res,'"' ) != 0) THEN

      res:=REPLACE(NVL(res,NULL),'"','&quot;');

  END IF;

  IF (INSTR(res,CHR(10)) != 0) THEN

      res:=REPLACE(NVL(res,NULL),CHR(10),' ');

  END IF;

  IF (INSTR(res,CHR(13)) != 0) THEN

      res:=REPLACE(NVL(res,NULL),CHR(13),' ');

  END IF;

 --IF (INSTR(res,'�' ) != 0) THEN

   --   res:=REPLACE(NVL(res,NULL),'�','N');

  --END IF;

  return res;

EXCEPTION WHEN OTHERS THEN

    FND_FILE.PUT_LINE(FND_FILE.LOG,' XXCUST_ENCODE_TO_XML ERROR: '||SQLCODE||', '||SQLERRM||', p_value: '||p_value);

    return p_value;

END XXCUST_ENCODE_TO_XML;


Comments

Post a Comment

Popular posts from this blog

AD_ZD_TABLE : Steps to follow while creating table in R12.2.*

Image
  *********** * GRANTS * ********** Team – do not use Grant statements in the SQL scripts while migrating through STAT , instead use  EXEC AD_ZD.GRANT_PRIVS. Manual steps run in DEV Environment: 1. As XXCUST, manually Create/Alter custom table in EBSDEV or EBSPROJ (XXCUST schema for all custom tables). 2. In EBSDEV/EBSPROJ: If creating the table, run:  AD_ZD_TABLE.UPGRADE (‘SCHEMA’,’TABLE’); If altering the table, run: AD_ZD_TABLE.PATCH (‘SCHEMA’,’TABLE’); 3. Insert at least one row of data in the custom table. * This is mandatory for XDF to extract the table definition and for successful Stat archive set creation. 4. As table owner, grant privileges on new/altered table and editioned view to APPS, primarily so AD_ZD.GRANT_PRIVS can be run for privileges. GRANT ALL ON SCHEMA.TABLE TO APPS WITH GRANT OPTION; GRANT ALL ON SCHEMA.EDITIONED_VIEW# TO APPS WITH GRANT OPTION; 5. If additional privileges are required on the new/altered table, the following needs to be run as APPS: ex
Read more

OAF page to UPLOAD the data from excel sheet to the database table

Image
   UPLOAD BUTTON (logic below): Excel sheet column structure: Table Structure: Code inside Controller: public void processFormRequest(OAPageContext  pageContext,  OAWebBean    webBean) {      super.processFormRequest(pageContext, webBean);      OAApplicationModule  am = (OAApplicationModule)pageContext.getApplicationModule(webBean);      String   filename   = null;      String   fname       = null;      String   ext            = null;     pageContext.writeDiagnostics(this,"Inside PFR..",1);      if(pageContext.getParameter("UploadBtn") != null)   //ID of the Upload button       {                DataObject   upload  =  pageContext.getNamedDataObject("FileUpload");  //import oracle.cabo.ui.data.DataObject; //"FileUpload" is the ID of the item with style "messageFileUpload".                 try {                       filename = (String)upload.selectValue(null, "UPLOAD_FILE_NAME");                       int mid =  filename.lastIn
Read more

Initiating a webservice API from Plsql package !!

Image
create or replace PACKAGE      xxat_3pl_webservice_pkg AS --=============================================================================================== -- Program name         Creation Date     Original Version   Created by   JIRA -- xx_webapi_dhl_fnc    ***********       1.0                 -- ----------------------------------------------------------------------------------------------- -- Description: -- This function will use a dummy waybill number for 3PL carriers and get the original waybill number. -- This program uses SOA platform to post and get the information from 3PL carrier. -- -- Parameter    : p_waybill_dummy_no      IN     Scan SHIP by user -- -- ----------------------------------------------------------------------------------------------- -- Modification History: -- Modified Date     Version    Done by               Change Description -- **-***-****       1.1         -- ===============================================================================================
Read more