Gateway Standard XML

Purpose

T is necessary to execute gateway summary operations.

Syntax

DECLARE

n_count NUMBER;

r_count NUMBER;

e_count NUMBER;

BEGIN

select count(*)

into n_count

from Gwtm_Standard_Xml

where xml_name = 'NO_ROUTE_CONTROL_MSG';

select count(*)

into r_count

from Gwtm_Standard_Xml

where xml_name = 'ROUTE_CONTROL_MSG';

select count(*) into e_count

from Gwtm_Standard_Xml

where xml_name = 'ERROR_MSG';

IF n_count = 0

THEN

insert into Gwtm_Standard_Xml (XML_NAME, MESSAGE)

values ('NO_ROUTE_CONTROL_MSG', '<?xml version="1.0"?>

<FCUBS_CONTROL_METADATA>

<COMM_DET>

<GATEWAY>GATEWAY</GATEWAY>

<REQ_QUEUE>REQ_QUEUE</REQ_QUEUE>

<REQ_Q_MSG_ID>REQ_Q_MSG_ID</REQ_Q_MSG_ID>

<REQ_Q_CORR_ID>REQ_Q_CORR_ID</REQ_Q_CORR_ID>

<RESP_QUEUE>RESP_QUEUE</RESP_QUEUE>

<IS_ROUTE_REQ>IS_ROUTE_REQ</IS_ROUTE_REQ>

<CONNECTION_NAME>CONNECTION_NAME</CONNECTION_NAME>

<CORRELATION_PATTERN>CORRELATION_PATTERN</CORRELATION_PATTERN>

<MSG_XCHANGE_PATTERN>MSG_XCHANGE_PATTERN</MSG_XCHANGE_PATTERN>

<MSG_ID>MSG_ID</MSG_ID> <CORREL_ID>CORREL_ID</CORREL_ID>

<GEN_REQ_MSG_REF>GEN_REQ_MSG_REF</GEN_REQ_MSG_REF>

<GEN_RESP_MSG_REF>GEN_RESP_MSG_REF</GEN_RESP_MSG_REF>

<SOURCE_USER>SOURCE_USER</SOURCE_USER>

<IS_RESP_Q_MSG_ID_REQ>IS_RESP_Q_MSG_ID_REQ</IS_RESP_Q_MSG_ID_REQ>

<RESP_Q_MSG_ID>RESP_Q_MSG_ID</RESP_Q_MSG_ID>

<RESP_Q_CORREL_ID>RESP_Q_CORREL_ID</RESP_Q_CORREL_ID>

<BRN_APP_DATE>BRN_APP_DATE</BRN_APP_DATE>

<FC_TRN_REF_NO>FC_TRN_REF_NO</FC_TRN_REF_NO>

<ERR_CODE>ERR_CODE</ERR_CODE>

<ERR_PARAM>ERR_PARAM</ERR_PARAM>

<XSD_NAME>XSD_NAME</XSD_NAME>

<XSD_VAL_REQD>XSD_VAL_REQD</XSD_VAL_REQD>

<FORMAT>FORMAT</FORMAT>

</COMM_DET>

<MSG_PROC_DET>

<UBSCOMP>UBSCOMP</UBSCOMP>

<SOURCE>SOURCE</SOURCE>

<SERVICE>SERVICE</SERVICE>

<OPERATION>OPERATION</OPERATION>

<SOURCE_OPERATION>SOURCE_OPERATION</SOURCE_OPERATION>

<USERID>USERID</USERID>

<BRANCH>BRANCH</BRANCH>

<FUNCTIONID>FUNCTIONID</FUNCTIONID>

<ACTION>ACTION</ACTION>

<MULTITRIPID>MULTITRIPID</MULTITRIPID>

</MSG_ROC_DET>

</FCUBS_CONTROL_METADATA> ');

END IF;

IF r_count = 0

THEN

insert into Gwtm_Standard_Xml (XML_NAME, MESSAGE)

values ('ROUTE_CONTROL_MSG', '<?xml version="1.0"?>

<FCUBS_CONTROL_METADATA>

<COMM_DET>

<GATEWAY>GATEWAY</GATEWAY>

<REQ_QUEUE>REQ_QUEUE</REQ_QUEUE>

<REQ_Q_MSG_ID>REQ_Q_MSG_ID</REQ_Q_MSG_ID>

<REQ_Q_CORR_ID>REQ_Q_CORR_ID</REQ_Q_CORR_ID>

<RESP_QUEUE>RESP_QUEUE</RESP_QUEUE>

<IS_ROUTE_REQ>IS_ROUTE_REQ</IS_ROUTE_REQ>

<CONNECTION_NAME>CONNECTION_NAME</CONNECTION_NAME>

<CORRELATION_PATTERN>CORRELATION_PATTERN</CORRELATION_PATTERN>

<MSG_XCHANGE_PATTERN>MSG_XCHANGE_PATTERN</MSG_XCHANGE_PATTERN>

<MSG_ID>MSG_ID</MSG_ID>

<CORREL_ID>CORREL_ID</CORREL_ID>

<GEN_REQ_MSG_REF>GEN_REQ_MSG_REF</GEN_REQ_MSG_REF>

<GEN_RESP_MSG_REF>GEN_RESP_MSG_REF</GEN_RESP_MSG_REF>

<SOURCE_USER>SOURCE_USER</SOURCE_USER>

<IS_RESP_Q_MSG_ID_REQ>IS_RESP_Q_MSG_ID_REQ</IS_RESP_Q_MSG_ID_REQ>

<RESP_Q_MSG_ID>RESP_Q_MSG_ID</RESP_Q_MSG_ID>

<RESP_Q_CORREL_ID>RESP_Q_CORREL_ID</RESP_Q_CORREL_ID>

<BRN_APP_DATE>BRN_APP_DATE</BRN_APP_DATE>

<FC_TRN_REF_NO>FC_TRN_REF_NO</FC_TRN_REF_NO>

<ERR_CODE>ERR_CODE</ERR_CODE>

<ERR_PARAM>ERR_PARAM</ERR_PARAM>

<XSD_NAME>XSD_NAME</XSD_NAME>

<XSD_VAL_REQD>XSD_VAL_REQD</XSD_VAL_REQD>

<FORMAT>FORMAT</FORMAT> <DISTRIBUTED_INSTALLATION>DISTRIBUTED_INSTALLATION</DISTRIBUTED_INSTALLATION>

</COMM_DET>

<MSG_PROC_DET>

<UBSCOMP>UBSCOMP</UBSCOMP>

<SOURCE>SOURCE</SOURCE>

<SERVICE>SERVICE</SERVICE>

<OPERATION>OPERATION</OPERATION>

<SOURCE_OPERATION>SOURCE_OPERATION</SOURCE_OPERATION>

<USERID>USERID</USERID>

<BRANCH>BRANCH</BRANCH>

<FUNCTIONID>FUNCTIONID</FUNCTIONID>

<ACTION>ACTION</ACTION>

<MULTITRIPID>MULTITRIPID</MULTITRIPID>

</MSG_PROC_DET>

</FCUBS_CONTROL_METADATA> ');

END IF;

IF e_count = 0

THEN

insert into Gwtm_Standard_Xml (XML_NAME, MESSAGE)

values ('ERROR_MSG', '<?xml version="1.0"?>

<FCUBS_RES_ENV>

<FCUBS_HEADER>

<SOURCE>SOURCE</SOURCE>

<UBSCOMP>UBSCOMP</UBSCOMP>

<MSGID>MSGID</MSGID>

<CORRELID>CORRELID</CORRELID>

<USERID>USERID</USERID>

<BRANCH>BRANCH</BRANCH>

<MODULEID>MODULEID</MODULEID>

<SERVICE>SERVICE</SERVICE>

<OPERATION>OPERATION</OPERATION>

<SOURCE_OPERATION>SOURCE_OPERATION</SOURCE_OPERATION>

<SOURCE_USERID>SOURCE_USERID</SOURCE_USERID>

<DESTINATION>DESTINATION</DESTINATION>

<MSGSTAT>FAILURE</MSGSTAT>

</FCUBS_HEADER>

<FCUBS_BODY>

<FCUBS_ERROR_RESP>

<ERROR> <ECODE>ECODE</ECODE>

<EDESC>EDESC</EDESC>

</ERROR>

</FCUBS_ERROR_RESP>

</FCUBS_BODY>

</FCUBS_RES_ENV> ');

END IF;

END;

/

COMMIT;

/