Base64 Encoding, Decoding

Base64 Encoding, Decoding

SCC_COMMON_UTILITIES.UTIL.Base64Wrapper.OnExecute

 (This Appl package has all the methods needed for base64 encode and decode)

class Base64Wrapper

   method Base64Wrapper();

   method encode(&filename As string) Returns string;

   method decode(&filename As string, &base64data As string) Returns boolean;

   rem method getErrorDetails() Returns string;

private

   instance JavaObject &joB64;

end-class;

method base64Encode

   Local number &nbr_retcode;

   Local File &file;

      &nbr_retcode = GetAttachment(&fileURL, &sysfilename, &tempFilename);

   %This.delay();

   If &nbr_retcode > 0 Then

      throw CreateException(18179, 207, "", &displayFilename);

   End-If;

   &Base64String = &b64w.encode(&tempFilename);

   %This.cleanupTempFile();

   end-method;;

method Base64Wrapper

   rem &joB64 = CreateJavaObject("com.peoplesoft.hrms.hrs.base64Utils");

   &joB64 = CreateJavaObject("com.peoplesoft.hr.sa.base64Utils");

end-method;

method encode

   /+ &filename as String +/

   /+ Returns String +/ 

   Local string &filedata;

   &filedata = &joB64.base64Encode(&filename);

   Return &filedata;

end-method;

method decode

   /+ &filename as String, +/

   /+ &base64data as String +/

   /+ Returns Boolean +/

   Return &joB64.base64Decode(&filename, &base64data);

   end-method;

/*method getErrorDetails

   /+ Returns String +/

   Return &joB64.getErrorDetails();

end-method;*/

HRS_HROI_RESUMEEXTRACT:Util(Application Package)

HRS_HROI:UTIL:Base64Wrapper;

class Base64Wrapper

   method Base64Wrapper();

   method encode(&filename As string) Returns string;

   method decode(&filename As string, &base64data As string) Returns boolean;

private

   instance JavaObject &joB64;

end-class;

method Base64Wrapper

   &joB64 = CreateJavaObject("com.peoplesoft.hrms.hrs.base64Utils");

end-method;

method encode

   /+ &filename as String +/

   /+ Returns String +/

      Local string &filedata; 

      &filedata = &joB64.base64Encode(&filename);

   Return &filedata;

end-method;

method decode

   /+ &filename as String, +/

   /+ &base64data as String +/

   /+ Returns Boolean +/

   Return &joB64.base64Decode(&filename, &base64data);

   end-method;;

INTEGRATION BROKER TABLES.

INTEGRATION BROKER TABLES.
--------------IB Gateway----------
Select * From PSGATEWAY ;
Select * From PSCONN ;
Select * From PSNODECONPROP ;
Select * From PSCONNPROP ;
Select * From PSCONNPROPIDVW;
Select * From PSCONPROPNAMEVW;
Select * From PSCONPROPVALVW ;
Select * From PSCONPROPDATAVW;
-----------Routings----------
Select * From PSIBRTNGDEFN where ROUTINGDEFNNAME like 'CG%';
Select * From PSRTNGDFNCONPRP where ROUTINGDEFNNAME like 'CG%';
Select * From PSRTNGDFNPARMVW  where ROUTINGDEFNNAME like 'CG%';
Select * From PSRTNGDFNPROP  where ROUTINGDEFNNAME like 'CG%';
Select * From PSRTNGDFNPARM  where ROUTINGDEFNNAME like 'CG%';
Select * From PSIBRTNGDEFN  where ROUTINGDEFNNAME like 'CG%';
---Service-------------
Select * From PSAUTHWS ;
Select * From PSSERVICE;
Select * From PSIBWSDL ;
Select * From PSOPRVERDFN ;
select * from PSIBMSGSERV_VW ;
select * from PSIBRTNGSERV_VW ;-- IB Service Routings
Select * From PSOPERATION;
Select * From PSSERVICEOPR_VW;
Select * From PSOPRVERDFNPARM;
Select * From PSOPERATIONAC;-- IB Service App. Class
Select * From PSHUBNODEVW ;---Routings---
Select * From PSIBRTNGDEFN;
Select * From PSRTNGDFNPARM ;
Select * From PSRTNGDFNCONPRP ;
Select * From PSOPRGENRTGPARM0;-- IB Service Routing Parameters
-----QUES---------------
Select * From PSQUEUEDEFN;
Select * From PSOPRVERDFN;
Select * From PSOPRVERDFNPARM;
Select * From PSSRVQUEUE_VW;
------MSG DEFN-------
Select * From PSMSGVER;
 Select * From PSMSGDEFN;
Select * From PSMSGPARTS ;
Select * From PSMSGPARTS_VW;
Select * From PSOPRVERDFNM_VW;
------NODE-------------
Select * From PSMSGNODEDEFN;
Select * From PSNODECONPROP;
Select * From PSNODEURITEXT;
Select * From PSIBRTNGDEFN ;
Select * From PSNODEPROP ;
Select * From PSMSGATTR ;
 ---Schemas---
Select * FROM PSIBMSGSCHEMA;
Select * FROM PSIBSCMADFN;
Select * FROM PSIBSCMADATA;
--Connectors-----
Select * From PSCONN ;
-------MSG--------
Select * From PSCONPROPVALVW ;
Select * From PSCONNPROPIDVW;
Select * from PSNODEVW;
Select * from PS_AMM_ARCH_PUB ;
Select * from PSAUTHWS_VW;
Select * from PSAUTHWS_VW1;
Select * from PSAUTHWS_VW2 ;
Select * from PSIBUSERCOMP;
---------------------------
Select * From PSCONTNAMEVW;
Select * From PSCODESETGROUP;
Select * From PSCONNGATEWAYVW;
Select * From PSCONNIDVW;
-----Handlers----
Select * from PSOPRHDLR;

READ TRACE as described below.

 READ TRACE as described below.

 PSAPPSRV.1033 1-525 16.50.10 0.000 Cur#1.CRMDEV1 RC=0 Dur=0.000 COM Stmt=SELECT
"1-525"    >>>sequential line counter for the process.
"16.50.10" >>>time stamp
"0.000"    >>>time  elapsed since the previous line was written to the trace file.
"Cur#1"    >>> number of the cursor for the statement
"CRMDEV1"  >>>name of the instance in which the statement was executed.
"RC=0"     >>> Return Code
"Dur=0.000">>>duration of the statement.
.