eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_INBOUND_TRIG dependencies on STANDARD

Line 112: i_standard_code in varchar2,

108: end get_element_value;
109:
110: procedure getAttributes
111: (
112: i_standard_code in varchar2,
113: i_doc IN xmlDOM.DOMDocument,
114: i_standard_type in varchar2
115: )
116: is

Line 114: i_standard_type in varchar2

110: procedure getAttributes
111: (
112: i_standard_code in varchar2,
113: i_doc IN xmlDOM.DOMDocument,
114: i_standard_type in varchar2
115: )
116: is
117:
118: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';

Line 121: p_standard_code IN varchar2,

117:
118: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';
119: cursor get_attributes
120: (
121: p_standard_code IN varchar2,
122: p_standard_type IN varchar2
123: )
124: is
125: select attribute_name,

Line 122: p_standard_type IN varchar2

118: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';
119: cursor get_attributes
120: (
121: p_standard_code IN varchar2,
122: p_standard_type IN varchar2
123: )
124: is
125: select attribute_name,
126: element_tag_name

Line 127: from ecx_standard_attributes esa,

123: )
124: is
125: select attribute_name,
126: element_tag_name
127: from ecx_standard_attributes esa,
128: ecx_standards es
129: where es.standard_code = p_standard_code
130: and es.standard_type = nvl(p_standard_type, 'XML')
131: and esa.standard_id = es.standard_id;

Line 128: ecx_standards es

124: is
125: select attribute_name,
126: element_tag_name
127: from ecx_standard_attributes esa,
128: ecx_standards es
129: where es.standard_code = p_standard_code
130: and es.standard_type = nvl(p_standard_type, 'XML')
131: and esa.standard_id = es.standard_id;
132:

Line 129: where es.standard_code = p_standard_code

125: select attribute_name,
126: element_tag_name
127: from ecx_standard_attributes esa,
128: ecx_standards es
129: where es.standard_code = p_standard_code
130: and es.standard_type = nvl(p_standard_type, 'XML')
131: and esa.standard_id = es.standard_id;
132:
133: i_string varchar2(2000) := ' update ecx_doclogs set ';

Line 130: and es.standard_type = nvl(p_standard_type, 'XML')

126: element_tag_name
127: from ecx_standard_attributes esa,
128: ecx_standards es
129: where es.standard_code = p_standard_code
130: and es.standard_type = nvl(p_standard_type, 'XML')
131: and esa.standard_id = es.standard_id;
132:
133: i_string varchar2(2000) := ' update ecx_doclogs set ';
134:

Line 131: and esa.standard_id = es.standard_id;

127: from ecx_standard_attributes esa,
128: ecx_standards es
129: where es.standard_code = p_standard_code
130: and es.standard_type = nvl(p_standard_type, 'XML')
131: and esa.standard_id = es.standard_id;
132:
133: i_string varchar2(2000) := ' update ecx_doclogs set ';
134:
135: i_value varchar2(2000);

Line 143: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);

139: if (l_procedureEnabled) then
140: ecx_debug.push(i_method_name);
141: end if;
142: if(l_statementEnabled) then
143: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
144: end if;
145:
146: if i_standard_code is null
147: then

Line 146: if i_standard_code is null

142: if(l_statementEnabled) then
143: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
144: end if;
145:
146: if i_standard_code is null
147: then
148: if (l_procedureEnabled) then
149: ecx_debug.pop(i_method_name);
150: end if;

Line 157: for c1 in get_Attributes(p_standard_code=>i_standard_code, p_standard_type =>i_standard_type)

153: /** Initialize the attr table **/
154: i_attr_rec.DELETE;
155:
156: /** Get all the Attributes and capture the value **/
157: for c1 in get_Attributes(p_standard_code=>i_standard_code, p_standard_type =>i_standard_type)
158: loop
159: if ( c1.attribute_name is not null and c1.element_tag_name is not null)
160: then
161: i_attr_rec(i_attr_rec.COUNT + 1).attribute_name := c1.attribute_name;

Line 396: i_message_standard IN varchar2,

392: i_map_id IN pls_integer,
393: i_payload IN clob,
394: i_header_id IN pls_integer,
395: i_rcv_tp_id IN pls_integer,
396: i_message_standard IN varchar2,
397: i_xmldoc OUT NOCOPY CLOB,
398: i_message_type IN varchar2
399: )
400: is

Line 416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);

412: ecx_debug.log(l_statement,'ecx_utils.g_map_id',ecx_utils.g_map_id,i_method_name);
413: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
414: ecx_debug.log(l_statement,'i_header_id',i_header_id,i_method_name);
415: ecx_debug.log(l_statement,'i_rcv_tp_id',i_rcv_tp_id,i_method_name);
416: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
417: end if;
418: -- Set the Transaction direction
419: ecx_utils.g_rec_tp_id := i_rcv_tp_id;
420: ecx_utils.g_direction := 'IN';

Line 441: / Get all the attributes in a generic way for a given standard and save in ecx_doclogs/

437:
438: /** Assign it to the Global XML Document **/
439: ecx_utils.g_xmldoc := xmlDOM.makeNode(i_doc);
440:
441: /** Get all the attributes in a generic way for a given standard and save in ecx_doclogs**/
442: getAttributes (
443: i_message_standard,
444: i_doc,
445: i_message_type

Line 443: i_message_standard,

439: ecx_utils.g_xmldoc := xmlDOM.makeNode(i_doc);
440:
441: /** Get all the attributes in a generic way for a given standard and save in ecx_doclogs**/
442: getAttributes (
443: i_message_standard,
444: i_doc,
445: i_message_type
446: );
447:

Line 535: m_message_standard IN varchar2,

531:
532: procedure validate_message
533: (
534: m_msgid IN raw,
535: m_message_standard IN varchar2,
536: m_ext_type in varchar2,
537: m_ext_subtype in varchar2,
538: m_party_ext_code IN varchar2,
539: m_document_number IN varchar2,

Line 576: p_message_standard in varchar2,

572: (
573: p_ext_type IN varchar2,
574: p_ext_subtype IN varchar2,
575: p_party_ext_code in varchar2,
576: p_message_standard in varchar2,
577: p_message_type in varchar2
578: )
579: is
580: select etd.map_id map_id,

Line 586: ecx_standards es

582: etd.tp_header_id tp_header_id,
583: etd.confirmation confirmation
584: from ecx_tp_details etd,
585: ecx_ext_processes eep,
586: ecx_standards es
587: where etd.source_tp_location_code = p_party_ext_code
588: and eep.ext_type = p_ext_type
589: and eep.ext_subtype = p_ext_subtype
590: and eep.ext_process_id = etd.ext_process_id

Line 591: and eep.standard_id = es.standard_id

587: where etd.source_tp_location_code = p_party_ext_code
588: and eep.ext_type = p_ext_type
589: and eep.ext_subtype = p_ext_subtype
590: and eep.ext_process_id = etd.ext_process_id
591: and eep.standard_id = es.standard_id
592: and es.standard_code = p_message_standard
593: and es.standard_type = nvl(p_message_type, 'XML')
594: and eep.direction = 'IN';
595:

Line 592: and es.standard_code = p_message_standard

588: and eep.ext_type = p_ext_type
589: and eep.ext_subtype = p_ext_subtype
590: and eep.ext_process_id = etd.ext_process_id
591: and eep.standard_id = es.standard_id
592: and es.standard_code = p_message_standard
593: and es.standard_type = nvl(p_message_type, 'XML')
594: and eep.direction = 'IN';
595:
596: cursor get_routing_for_extcode

Line 593: and es.standard_type = nvl(p_message_type, 'XML')

589: and eep.ext_subtype = p_ext_subtype
590: and eep.ext_process_id = etd.ext_process_id
591: and eep.standard_id = es.standard_id
592: and es.standard_code = p_message_standard
593: and es.standard_type = nvl(p_message_type, 'XML')
594: and eep.direction = 'IN';
595:
596: cursor get_routing_for_extcode
597: (

Line 601: p_message_standard in varchar2,

597: (
598: p_ext_type IN varchar2,
599: p_ext_subtype IN varchar2,
600: p_party_ext_code in varchar2,
601: p_message_standard in varchar2,
602: p_message_type in varchar2
603: )
604: is
605: select etd.tp_header_id tp_header_id,

Line 609: ecx_standards es

605: select etd.tp_header_id tp_header_id,
606: etd.tp_detail_id tp_detail_id
607: from ecx_tp_details etd,
608: ecx_ext_processes eep,
609: ecx_standards es
610: where etd.source_tp_location_code = p_party_ext_code
611: and eep.ext_type = p_ext_type
612: and eep.ext_subtype = p_ext_subtype
613: and eep.ext_process_id = etd.ext_process_id

Line 614: and eep.standard_id = es.standard_id

610: where etd.source_tp_location_code = p_party_ext_code
611: and eep.ext_type = p_ext_type
612: and eep.ext_subtype = p_ext_subtype
613: and eep.ext_process_id = etd.ext_process_id
614: and eep.standard_id = es.standard_id
615: and es.standard_code = p_message_standard
616: and es.standard_type = nvl(p_message_type, 'XML')
617: and eep.direction = 'OUT';
618:

Line 615: and es.standard_code = p_message_standard

611: and eep.ext_type = p_ext_type
612: and eep.ext_subtype = p_ext_subtype
613: and eep.ext_process_id = etd.ext_process_id
614: and eep.standard_id = es.standard_id
615: and es.standard_code = p_message_standard
616: and es.standard_type = nvl(p_message_type, 'XML')
617: and eep.direction = 'OUT';
618:
619: cursor get_receiver_tp_id

Line 616: and es.standard_type = nvl(p_message_type, 'XML')

612: and eep.ext_subtype = p_ext_subtype
613: and eep.ext_process_id = etd.ext_process_id
614: and eep.standard_id = es.standard_id
615: and es.standard_code = p_message_standard
616: and es.standard_type = nvl(p_message_type, 'XML')
617: and eep.direction = 'OUT';
618:
619: cursor get_receiver_tp_id
620: (

Line 632: ecx_debug.log(l_statement,'m_message_standard',m_message_standard,i_method_name);

628: if (l_procedureEnabled) then
629: ecx_debug.push(i_method_name);
630: end if;
631: if(l_statementEnabled) then
632: ecx_debug.log(l_statement,'m_message_standard',m_message_standard,i_method_name);
633: ecx_debug.log(l_statement,'m_ext_type',m_ext_type,i_method_name);
634: ecx_debug.log(l_statement,'m_ext_subtype',m_ext_subtype,i_method_name);
635: ecx_debug.log(l_statement,'m_party_ext_code',m_party_ext_code,i_method_name);
636: ecx_debug.log(l_statement,'m_document_number',m_document_number,i_method_name);

Line 647: open c_tp_details ( m_ext_type, m_ext_subtype,m_party_ext_code,m_message_standard, m_message_type);

643: ecx_utils.g_ret_code := 0;
644:
645: --Check whether the Document has been enabled in the Exchange Server.
646: --If yes get the Map Id.
647: open c_tp_details ( m_ext_type, m_ext_subtype,m_party_ext_code,m_message_standard, m_message_type);
648: fetch c_tp_details
649: into i_map_id,
650: i_routing_id,
651: i_header_id,

Line 707: open get_routing_for_extcode ( m_ext_type,m_ext_subtype,m_routing_ext_code,m_message_standard, m_message_type);

703: then
704: if(l_statementEnabled) then
705: ecx_debug.log(l_statement,'Dynamic Routing1',m_routing_ext_code,i_method_name);
706: end if;
707: open get_routing_for_extcode ( m_ext_type,m_ext_subtype,m_routing_ext_code,m_message_standard, m_message_type);
708: fetch get_routing_for_extcode
709: into i_rcv_tp_id,i_routing_id;
710:
711: if get_routing_for_extcode%NOTFOUND

Line 790: open get_routing_for_extcode ( m_ext_type,m_ext_subtype,m_routing_ext_code,m_message_standard, m_message_type);

786: then
787: if(l_statementEnabled) then
788: ecx_debug.log(l_statement,'Dynamic Routing2',m_routing_ext_code,i_method_name);
789: end if;
790: open get_routing_for_extcode ( m_ext_type,m_ext_subtype,m_routing_ext_code,m_message_standard, m_message_type);
791: fetch get_routing_for_extcode
792: into i_rcv_tp_id,i_routing_id;
793:
794: if get_routing_for_extcode%NOTFOUND

Line 874: m_message_standard,

870: i_map_id,
871: m_payload,
872: i_header_id,
873: i_rcv_tp_id,
874: m_message_standard,
875: o_payload,
876: m_message_type
877: );
878: if(l_statementEnabled) then

Line 993: ecx_debug.log(l_statement,'Message Standard',v_message.message_standard,i_method_name);

989:
990: --Retrieve the Message Attributes
991:
992: if(l_statementEnabled) then
993: ecx_debug.log(l_statement,'Message Standard',v_message.message_standard,i_method_name);
994: ecx_debug.log(l_statement,'Message Type',v_message.message_type,i_method_name);
995: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
996: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
997: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);

Line 1011: v_message.message_standard,

1007: l_retcode,
1008: l_retmsg,
1009: i_msgid,
1010: v_message.message_type,
1011: v_message.message_standard,
1012: v_message.transaction_type,
1013: v_message.transaction_subtype,
1014: v_message.document_number,
1015: v_message.partyid,

Line 1080: i_standard_type varchar2(20);

1076: i_method_name varchar2(2000) := 'ecx_inbound_trig.put_on_outbound';
1077: e_qtimeout exception;
1078:
1079: i_out_msgid raw(16);
1080: i_standard_type varchar2(20);
1081: i_standard_code varchar2(20);
1082: i_ext_type varchar2(200);
1083: i_ext_subtype varchar2(200);
1084: i_source_code varchar2(200);

Line 1081: i_standard_code varchar2(20);

1077: e_qtimeout exception;
1078:
1079: i_out_msgid raw(16);
1080: i_standard_type varchar2(20);
1081: i_standard_code varchar2(20);
1082: i_ext_type varchar2(200);
1083: i_ext_subtype varchar2(200);
1084: i_source_code varchar2(200);
1085: i_destination_code varchar2(200);

Line 1112: select es.standard_type standard_type,

1108: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1109: end if;
1110:
1111: begin
1112: select es.standard_type standard_type,
1113: es.standard_code standard_code,
1114: source_tp_location_code source,
1115: external_tp_location_code destination,
1116: protocol_type,

Line 1113: es.standard_code standard_code,

1109: end if;
1110:
1111: begin
1112: select es.standard_type standard_type,
1113: es.standard_code standard_code,
1114: source_tp_location_code source,
1115: external_tp_location_code destination,
1116: protocol_type,
1117: protocol_address,

Line 1128: into i_standard_type,

1124: et.transaction_subtype,
1125: eth.party_id,
1126: eth.party_site_id,
1127: eth.party_type
1128: into i_standard_type,
1129: i_standard_code,
1130: i_source_code,
1131: i_destination_code,
1132: i_destination_type,

Line 1129: i_standard_code,

1125: eth.party_id,
1126: eth.party_site_id,
1127: eth.party_type
1128: into i_standard_type,
1129: i_standard_code,
1130: i_source_code,
1131: i_destination_code,
1132: i_destination_type,
1133: i_destination_address,

Line 1146: ecx_standards es,

1142: i_party_site_id,
1143: i_party_type
1144: from ecx_tp_details etd,
1145: ecx_ext_processes eep,
1146: ecx_standards es,
1147: ecx_transactions et,
1148: ecx_tp_headers eth
1149: where etd.tp_detail_id = i_tp_detail_id
1150: and es.standard_id = eep.standard_id

Line 1150: and es.standard_id = eep.standard_id

1146: ecx_standards es,
1147: ecx_transactions et,
1148: ecx_tp_headers eth
1149: where etd.tp_detail_id = i_tp_detail_id
1150: and es.standard_id = eep.standard_id
1151: and eep.ext_process_id = etd.ext_process_id
1152: and eep.transaction_id = et.transaction_id
1153: and eep.direction = 'OUT'
1154: and etd.tp_header_id = eth.tp_header_id;

Line 1191: 'p_standard', i_standard_code);

1187: ecx_debug.setErrorInfo(1,25,'ECX_PROTOCOL_ADDR_NULL',
1188: 'p_tp_location_code', i_source_code,
1189: 'p_transaction_type', i_ext_type,
1190: 'p_transaction_subtype', i_ext_subtype,
1191: 'p_standard', i_standard_code);
1192:
1193: raise ecx_utils.program_exit;
1194: end if;
1195: if (l_statementEnabled) then

Line 1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);

1192:
1193: raise ecx_utils.program_exit;
1194: end if;
1195: if (l_statementEnabled) then
1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);

Line 1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);

1193: raise ecx_utils.program_exit;
1194: end if;
1195: if (l_statementEnabled) then
1196: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1197: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1198: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1199: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1200: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1201: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);

Line 1219: i_event.addParameterToList('MESSAGE_TYPE', i_standard_type);

1215: i_event.addParameterToList('PARTY_SITE_ID', i_source_code);
1216: -- added this for passthrough logging purposes in ecx_out_wf_qh
1217: i_event.addParameterToList('INT_PARTY_SITE_ID', i_party_site_id);
1218: i_event.addParameterToList('DOCUMENT_NUMBER', i_document_number);
1219: i_event.addParameterToList('MESSAGE_TYPE', i_standard_type);
1220: i_event.addParameterToList('MESSAGE_STANDARD', i_standard_code);
1221: i_event.addParameterToList('TRANSACTION_TYPE', i_ext_type);
1222: i_event.addParameterToList('TRANSACTION_SUBTYPE', i_ext_subtype);
1223: i_event.addParameterToList('INT_TRANSACTION_TYPE', i_int_type);

Line 1220: i_event.addParameterToList('MESSAGE_STANDARD', i_standard_code);

1216: -- added this for passthrough logging purposes in ecx_out_wf_qh
1217: i_event.addParameterToList('INT_PARTY_SITE_ID', i_party_site_id);
1218: i_event.addParameterToList('DOCUMENT_NUMBER', i_document_number);
1219: i_event.addParameterToList('MESSAGE_TYPE', i_standard_type);
1220: i_event.addParameterToList('MESSAGE_STANDARD', i_standard_code);
1221: i_event.addParameterToList('TRANSACTION_TYPE', i_ext_type);
1222: i_event.addParameterToList('TRANSACTION_SUBTYPE', i_ext_subtype);
1223: i_event.addParameterToList('INT_TRANSACTION_TYPE', i_int_type);
1224: i_event.addParameterToList('INT_TRANSACTION_SUBTYPE', i_int_subtype);

Line 1324: i_standard_type varchar2(20);

1320: i_msgid raw(16);
1321: c_nummessages CONSTANT INTEGER :=1;
1322: e_qtimeout exception;
1323:
1324: i_standard_type varchar2(20);
1325: i_standard_code varchar2(20);
1326: i_ext_type varchar2(200);
1327: i_ext_subtype varchar2(200);
1328: i_source_code varchar2(200);

Line 1325: i_standard_code varchar2(20);

1321: c_nummessages CONSTANT INTEGER :=1;
1322: e_qtimeout exception;
1323:
1324: i_standard_type varchar2(20);
1325: i_standard_code varchar2(20);
1326: i_ext_type varchar2(200);
1327: i_ext_subtype varchar2(200);
1328: i_source_code varchar2(200);
1329: i_destination_code varchar2(200);

Line 1353: select es.standard_type standard_type,

1349: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1350: end if;
1351:
1352: begin
1353: select es.standard_type standard_type,
1354: es.standard_code standard_code,
1355: source_tp_location_code source,
1356: external_tp_location_code destination,
1357: protocol_type,

Line 1354: es.standard_code standard_code,

1350: end if;
1351:
1352: begin
1353: select es.standard_type standard_type,
1354: es.standard_code standard_code,
1355: source_tp_location_code source,
1356: external_tp_location_code destination,
1357: protocol_type,
1358: protocol_address,

Line 1364: into i_standard_type,

1360: password,
1361: hub_user_id,
1362: eep.ext_type ext_type,
1363: eep.ext_subtype ext_subtype
1364: into i_standard_type,
1365: i_standard_code,
1366: i_source_code,
1367: i_destination_code,
1368: i_destination_type,

Line 1365: i_standard_code,

1361: hub_user_id,
1362: eep.ext_type ext_type,
1363: eep.ext_subtype ext_subtype
1364: into i_standard_type,
1365: i_standard_code,
1366: i_source_code,
1367: i_destination_code,
1368: i_destination_type,
1369: i_destination_address,

Line 1377: ecx_standards es

1373: i_ext_type,
1374: i_ext_subtype
1375: from ecx_tp_details etd,
1376: ecx_ext_processes eep,
1377: ecx_standards es
1378: where etd.tp_detail_id = i_tp_detail_id
1379: and es.standard_id = eep.standard_id
1380: and eep.ext_process_id = etd.ext_process_id;
1381:

Line 1379: and es.standard_id = eep.standard_id

1375: from ecx_tp_details etd,
1376: ecx_ext_processes eep,
1377: ecx_standards es
1378: where etd.tp_detail_id = i_tp_detail_id
1379: and es.standard_id = eep.standard_id
1380: and eep.ext_process_id = etd.ext_process_id;
1381:
1382: exception
1383: when others then

Line 1423: 'p_standard', i_standard_code);

1419: ecx_debug.setErrorInfo(1,25,'ECX_PROTOCOL_ADDR_NULL',
1420: 'p_tp_location_code', i_source_code,
1421: 'p_transaction_type', i_ext_type,
1422: 'p_transaction_subtype', i_ext_subtype,
1423: 'p_standard', i_standard_code);
1424: raise ecx_utils.program_exit;
1425: end if;
1426:
1427: ecx_obfuscate.ecx_data_encrypt

Line 1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);

1441: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1442: raise ecx_utils.program_exit;
1443: end if;
1444: if(l_statementEnabled) then
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);

Line 1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);

1442: raise ecx_utils.program_exit;
1443: end if;
1444: if(l_statementEnabled) then
1445: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1446: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1447: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1448: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1449: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1450: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);

Line 1459: i_standard_type,

1455: --ecx_debug.log(3,'i_password',i_password);
1456:
1457: v_message:=system.ecxmsg
1458: (
1459: i_standard_type,
1460: i_standard_code,
1461: i_ext_type,
1462: i_ext_subtype,
1463: i_document_number,

Line 1460: i_standard_code,

1456:
1457: v_message:=system.ecxmsg
1458: (
1459: i_standard_type,
1460: i_standard_code,
1461: i_ext_type,
1462: i_ext_subtype,
1463: i_document_number,
1464: null,

Line 1512: v_message.message_standard,

1508: l_retcode,
1509: l_retmsg,
1510: i_msgid,
1511: v_message.message_type,
1512: v_message.message_standard,
1513: v_message.transaction_type,
1514: v_message.transaction_subtype,
1515: v_message.document_number,
1516: v_message.partyid,

Line 1765: m_message_standard varchar2(200);

1761: msg_not_found exception;
1762:
1763: m_transaction_type varchar2(200);
1764: m_transaction_subtype varchar2(200);
1765: m_message_standard varchar2(200);
1766: m_message_type varchar2(200);
1767: m_document_number varchar2(200);
1768: m_routing_ext_code varchar2(200);
1769: m_party_ext_code varchar2(200);

Line 1783: select message_standard,

1779: (
1780: p_msgid in raw
1781: )
1782: is
1783: select message_standard,
1784: message_type,
1785: transaction_type,
1786: transaction_subtype,
1787: party_site_id,

Line 1806: into m_message_standard,

1802: begin
1803:
1804: open get_msg (i_msgid);
1805: fetch get_msg
1806: into m_message_standard,
1807: m_message_type,
1808: m_transaction_type,
1809: m_transaction_subtype,
1810: m_party_ext_code,

Line 1830: select standard_id

1826: ecx_utils.g_transaction_type := m_transaction_type;
1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1830: select standard_id
1831: into ecx_utils.g_standard_id
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');

Line 1831: into ecx_utils.g_standard_id

1827: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1830: select standard_id
1831: into ecx_utils.g_standard_id
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then

Line 1832: from ecx_standards

1828: ecx_utils.g_msgid := i_msgid;
1829: begin
1830: select standard_id
1831: into ecx_utils.g_standard_id
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then
1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 1833: where standard_code = m_message_standard

1829: begin
1830: select standard_id
1831: into ecx_utils.g_standard_id
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then
1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1837: end if;

Line 1834: and standard_type = nvl(m_message_type, 'XML');

1830: select standard_id
1831: into ecx_utils.g_standard_id
1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then
1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1837: end if;
1838: exception

Line 1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

1832: from ecx_standards
1833: where standard_code = m_message_standard
1834: and standard_type = nvl(m_message_type, 'XML');
1835: if(l_statementEnabled) then
1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1837: end if;
1838: exception
1839: when others then
1840: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

Line 1840: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

1836: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1837: end if;
1838: exception
1839: when others then
1840: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1841: raise ecx_utils.program_exit;
1842: end;
1843: ecx_debug.module_enabled;
1844: g_instlmode := wf_core.translate('WF_INSTALL');

Line 1874: i_logfile := substr(m_message_standard,1,10)||'IN'||substr(m_transaction_type,1,20)||substr(m_transaction_subtype,1,20)||ecx_utils.g_run_id||'.log';

1870:
1871: --get the Log directory from the Profile Option.
1872: ecx_utils.getLogDirectory;
1873:
1874: i_logfile := substr(m_message_standard,1,10)||'IN'||substr(m_transaction_type,1,20)||substr(m_transaction_subtype,1,20)||ecx_utils.g_run_id||'.log';
1875:
1876: p_aflog_module_name := '';
1877: IF (m_message_standard is not null) THEN
1878: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';

Line 1877: IF (m_message_standard is not null) THEN

1873:
1874: i_logfile := substr(m_message_standard,1,10)||'IN'||substr(m_transaction_type,1,20)||substr(m_transaction_subtype,1,20)||ecx_utils.g_run_id||'.log';
1875:
1876: p_aflog_module_name := '';
1877: IF (m_message_standard is not null) THEN
1878: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
1879: END IF;
1880: p_aflog_module_name := p_aflog_module_name || 'in.';
1881: IF (m_transaction_type is not null) THEN

Line 1878: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';

1874: i_logfile := substr(m_message_standard,1,10)||'IN'||substr(m_transaction_type,1,20)||substr(m_transaction_subtype,1,20)||ecx_utils.g_run_id||'.log';
1875:
1876: p_aflog_module_name := '';
1877: IF (m_message_standard is not null) THEN
1878: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
1879: END IF;
1880: p_aflog_module_name := p_aflog_module_name || 'in.';
1881: IF (m_transaction_type is not null) THEN
1882: p_aflog_module_name := p_aflog_module_name||m_transaction_type||'.';

Line 1924: select standard_id

1920: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1921: ecx_utils.g_msgid := i_msgid;*/
1922:
1923: /*begin
1924: select standard_id
1925: into ecx_utils.g_standard_id
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');

Line 1925: into ecx_utils.g_standard_id

1921: ecx_utils.g_msgid := i_msgid;*/
1922:
1923: /*begin
1924: select standard_id
1925: into ecx_utils.g_standard_id
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then

Line 1926: from ecx_standards

1922:
1923: /*begin
1924: select standard_id
1925: into ecx_utils.g_standard_id
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then
1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 1927: where standard_code = m_message_standard

1923: /*begin
1924: select standard_id
1925: into ecx_utils.g_standard_id
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then
1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1931: end if;

Line 1928: and standard_type = nvl(m_message_type, 'XML');

1924: select standard_id
1925: into ecx_utils.g_standard_id
1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then
1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1931: end if;
1932: exception

Line 1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

1926: from ecx_standards
1927: where standard_code = m_message_standard
1928: and standard_type = nvl(m_message_type, 'XML');
1929: if(l_statementEnabled) then
1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1931: end if;
1932: exception
1933: when others then
1934: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

Line 1934: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

1930: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1931: end if;
1932: exception
1933: when others then
1934: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1935: raise ecx_utils.program_exit;
1936: enid;*/
1937: validate_message
1938: (

Line 1940: m_message_standard,

1936: enid;*/
1937: validate_message
1938: (
1939: i_msgid,
1940: m_message_standard,
1941: m_transaction_type,
1942: m_transaction_subtype,
1943: m_party_ext_code,
1944: m_document_number,

Line 2020: m_message_standard varchar2(200);

2016: msg_not_found exception;
2017:
2018: m_transaction_type varchar2(200);
2019: m_transaction_subtype varchar2(200);
2020: m_message_standard varchar2(200);
2021: m_message_type varchar2(200);
2022: m_document_number varchar2(200);
2023: m_routing_ext_code varchar2(200);
2024: m_party_ext_code varchar2(200);

Line 2039: select message_standard,

2035: (
2036: p_msgid in raw
2037: )
2038: is
2039: select message_standard,
2040: message_type,
2041: transaction_type,
2042: transaction_subtype,
2043: party_site_id,

Line 2073: into m_message_standard,

2069: -- /logging enabled
2070:
2071: open get_msg (i_msgid);
2072: fetch get_msg
2073: into m_message_standard,
2074: m_message_type,
2075: m_transaction_type,
2076: m_transaction_subtype,
2077: m_party_ext_code,

Line 2103: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';

2099:
2100: --get the Log directory from the Profile Option.
2101: ecx_utils.getLogDirectory;
2102:
2103: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2104:
2105: p_aflog_module_name := '';
2106: IF (m_message_standard is not null) THEN
2107: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';

Line 2106: IF (m_message_standard is not null) THEN

2102:
2103: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2104:
2105: p_aflog_module_name := '';
2106: IF (m_message_standard is not null) THEN
2107: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
2108: END IF;
2109: p_aflog_module_name := p_aflog_module_name || 'in.';
2110: IF (m_transaction_type is not null) THEN

Line 2107: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';

2103: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2104:
2105: p_aflog_module_name := '';
2106: IF (m_message_standard is not null) THEN
2107: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
2108: END IF;
2109: p_aflog_module_name := p_aflog_module_name || 'in.';
2110: IF (m_transaction_type is not null) THEN
2111: p_aflog_module_name := p_aflog_module_name||m_transaction_type||'.';

Line 2153: select standard_id

2149: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2150: ecx_utils.g_msgid := i_msgid;
2151:
2152: begin
2153: select standard_id
2154: into ecx_utils.g_standard_id
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');

Line 2154: into ecx_utils.g_standard_id

2150: ecx_utils.g_msgid := i_msgid;
2151:
2152: begin
2153: select standard_id
2154: into ecx_utils.g_standard_id
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then

Line 2155: from ecx_standards

2151:
2152: begin
2153: select standard_id
2154: into ecx_utils.g_standard_id
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then
2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 2156: where standard_code = m_message_standard

2152: begin
2153: select standard_id
2154: into ecx_utils.g_standard_id
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then
2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2160: end if;

Line 2157: and standard_type = nvl(m_message_type, 'XML');

2153: select standard_id
2154: into ecx_utils.g_standard_id
2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then
2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2160: end if;
2161: exception

Line 2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

2155: from ecx_standards
2156: where standard_code = m_message_standard
2157: and standard_type = nvl(m_message_type, 'XML');
2158: if(l_statementEnabled) then
2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2160: end if;
2161: exception
2162: when others then
2163: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

Line 2163: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

2159: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2160: end if;
2161: exception
2162: when others then
2163: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2164: raise ecx_utils.program_exit;
2165: end;
2166:
2167: validate_message

Line 2170: m_message_standard,

2166:
2167: validate_message
2168: (
2169: i_msgid,
2170: m_message_standard,
2171: m_transaction_type,
2172: m_transaction_subtype,
2173: m_party_ext_code,
2174: m_document_number,

Line 2232: i_message_standard IN varchar2,

2228: i_ret_code OUT NOCOPY pls_integer,
2229: i_errbuf OUT NOCOPY varchar2,
2230: i_log_file OUT NOCOPY varchar2,
2231: o_payload OUT NOCOPY CLOB,
2232: i_message_standard IN varchar2,
2233: i_message_type IN varchar2
2234: )
2235: is
2236: i_method_name varchar2(2000) := 'ecx_inbound_trig.processxml';

Line 2339: select standard_id

2335: raise ecx_utils.program_exit;
2336: end;
2337:
2338: begin
2339: select standard_id
2340: into ecx_utils.g_standard_id
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');

Line 2340: into ecx_utils.g_standard_id

2336: end;
2337:
2338: begin
2339: select standard_id
2340: into ecx_utils.g_standard_id
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then

Line 2341: from ecx_standards

2337:
2338: begin
2339: select standard_id
2340: into ecx_utils.g_standard_id
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then
2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 2342: where standard_code = i_message_standard

2338: begin
2339: select standard_id
2340: into ecx_utils.g_standard_id
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then
2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2346: end if;

Line 2343: and standard_type = nvl(i_message_type, 'XML');

2339: select standard_id
2340: into ecx_utils.g_standard_id
2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then
2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2346: end if;
2347: exception

Line 2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

2341: from ecx_standards
2342: where standard_code = i_message_standard
2343: and standard_type = nvl(i_message_type, 'XML');
2344: if(l_statementEnabled) then
2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2346: end if;
2347: exception
2348: when others then
2349: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

Line 2349: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

2345: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2346: end if;
2347: exception
2348: when others then
2349: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2350: raise ecx_utils.program_exit;
2351: end;
2352:
2353: processXMLData

Line 2359: i_message_standard,

2355: i_map_id,
2356: i_payload,
2357: null,
2358: null,
2359: i_message_standard,
2360: o_payload,
2361: i_message_type
2362: );
2363: