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 536: m_message_standard IN varchar2,

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

Line 577: p_message_standard in varchar2,

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

Line 587: ecx_standards es

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

Line 592: and eep.standard_id = es.standard_id

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

Line 593: and es.standard_code = p_message_standard

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

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

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

Line 602: p_message_standard in varchar2,

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

Line 610: ecx_standards es

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

Line 615: and eep.standard_id = es.standard_id

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

Line 616: and es.standard_code = p_message_standard

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

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

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

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

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

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

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

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

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

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

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

Line 888: m_message_standard,

884: i_map_id,
885: m_payload,
886: i_header_id,
887: i_rcv_tp_id,
888: m_message_standard,
889: o_payload,
890: m_message_type
891: );
892: if(l_statementEnabled) then

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

1004:
1005: --Retrieve the Message Attributes
1006:
1007: if(l_statementEnabled) then
1008: ecx_debug.log(l_statement,'Message Standard',v_message.message_standard,i_method_name);
1009: ecx_debug.log(l_statement,'Message Type',v_message.message_type,i_method_name);
1010: ecx_debug.log(l_statement,'Transaction Type',v_message.transaction_type,i_method_name);
1011: ecx_debug.log(l_statement,'Transaction Sub Type',v_message.transaction_subtype,i_method_name);
1012: ecx_debug.log(l_statement,'Party Id',v_message.partyid,i_method_name);

Line 1026: v_message.message_standard,

1022: l_retcode,
1023: l_retmsg,
1024: i_msgid,
1025: v_message.message_type,
1026: v_message.message_standard,
1027: v_message.transaction_type,
1028: v_message.transaction_subtype,
1029: v_message.document_number,
1030: v_message.partyid,

Line 1095: i_standard_type varchar2(20);

1091: i_method_name varchar2(2000) := 'ecx_inbound_trig.put_on_outbound';
1092: e_qtimeout exception;
1093:
1094: i_out_msgid raw(16);
1095: i_standard_type varchar2(20);
1096: i_standard_code varchar2(20);
1097: i_ext_type varchar2(200);
1098: i_ext_subtype varchar2(200);
1099: i_source_code varchar2(200);

Line 1096: i_standard_code varchar2(20);

1092: e_qtimeout exception;
1093:
1094: i_out_msgid raw(16);
1095: i_standard_type varchar2(20);
1096: i_standard_code varchar2(20);
1097: i_ext_type varchar2(200);
1098: i_ext_subtype varchar2(200);
1099: i_source_code varchar2(200);
1100: i_destination_code varchar2(200);

Line 1127: select es.standard_type standard_type,

1123: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1124: end if;
1125:
1126: begin
1127: select es.standard_type standard_type,
1128: es.standard_code standard_code,
1129: source_tp_location_code source,
1130: external_tp_location_code destination,
1131: protocol_type,

Line 1128: es.standard_code standard_code,

1124: end if;
1125:
1126: begin
1127: select es.standard_type standard_type,
1128: es.standard_code standard_code,
1129: source_tp_location_code source,
1130: external_tp_location_code destination,
1131: protocol_type,
1132: protocol_address,

Line 1143: into i_standard_type,

1139: et.transaction_subtype,
1140: eth.party_id,
1141: eth.party_site_id,
1142: eth.party_type
1143: into i_standard_type,
1144: i_standard_code,
1145: i_source_code,
1146: i_destination_code,
1147: i_destination_type,

Line 1144: i_standard_code,

1140: eth.party_id,
1141: eth.party_site_id,
1142: eth.party_type
1143: into i_standard_type,
1144: i_standard_code,
1145: i_source_code,
1146: i_destination_code,
1147: i_destination_type,
1148: i_destination_address,

Line 1161: ecx_standards es,

1157: i_party_site_id,
1158: i_party_type
1159: from ecx_tp_details etd,
1160: ecx_ext_processes eep,
1161: ecx_standards es,
1162: ecx_transactions et,
1163: ecx_tp_headers eth
1164: where etd.tp_detail_id = i_tp_detail_id
1165: and es.standard_id = eep.standard_id

Line 1165: and es.standard_id = eep.standard_id

1161: ecx_standards es,
1162: ecx_transactions et,
1163: ecx_tp_headers eth
1164: where etd.tp_detail_id = i_tp_detail_id
1165: and es.standard_id = eep.standard_id
1166: and eep.ext_process_id = etd.ext_process_id
1167: and eep.transaction_id = et.transaction_id
1168: and eep.direction = 'OUT'
1169: and etd.tp_header_id = eth.tp_header_id;

Line 1206: 'p_standard', i_standard_code);

1202: ecx_debug.setErrorInfo(1,25,'ECX_PROTOCOL_ADDR_NULL',
1203: 'p_tp_location_code', i_source_code,
1204: 'p_transaction_type', i_ext_type,
1205: 'p_transaction_subtype', i_ext_subtype,
1206: 'p_standard', i_standard_code);
1207:
1208: raise ecx_utils.program_exit;
1209: end if;
1210: if (l_statementEnabled) then

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

1207:
1208: raise ecx_utils.program_exit;
1209: end if;
1210: if (l_statementEnabled) then
1211: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1212: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1213: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1214: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1215: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);

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

1208: raise ecx_utils.program_exit;
1209: end if;
1210: if (l_statementEnabled) then
1211: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1212: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1213: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1214: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1215: ecx_debug.log(l_statement,'i_int_type', i_int_type,i_method_name);
1216: ecx_debug.log(l_statement,'i_int_subtype', i_int_subtype,i_method_name);

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

1230: i_event.addParameterToList('PARTY_SITE_ID', i_source_code);
1231: -- added this for passthrough logging purposes in ecx_out_wf_qh
1232: i_event.addParameterToList('INT_PARTY_SITE_ID', i_party_site_id);
1233: i_event.addParameterToList('DOCUMENT_NUMBER', i_document_number);
1234: i_event.addParameterToList('MESSAGE_TYPE', i_standard_type);
1235: i_event.addParameterToList('MESSAGE_STANDARD', i_standard_code);
1236: i_event.addParameterToList('TRANSACTION_TYPE', i_ext_type);
1237: i_event.addParameterToList('TRANSACTION_SUBTYPE', i_ext_subtype);
1238: i_event.addParameterToList('INT_TRANSACTION_TYPE', i_int_type);

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

1231: -- added this for passthrough logging purposes in ecx_out_wf_qh
1232: i_event.addParameterToList('INT_PARTY_SITE_ID', i_party_site_id);
1233: i_event.addParameterToList('DOCUMENT_NUMBER', i_document_number);
1234: i_event.addParameterToList('MESSAGE_TYPE', i_standard_type);
1235: i_event.addParameterToList('MESSAGE_STANDARD', i_standard_code);
1236: i_event.addParameterToList('TRANSACTION_TYPE', i_ext_type);
1237: i_event.addParameterToList('TRANSACTION_SUBTYPE', i_ext_subtype);
1238: i_event.addParameterToList('INT_TRANSACTION_TYPE', i_int_type);
1239: i_event.addParameterToList('INT_TRANSACTION_SUBTYPE', i_int_subtype);

Line 1339: i_standard_type varchar2(20);

1335: i_msgid raw(16);
1336: c_nummessages CONSTANT INTEGER :=1;
1337: e_qtimeout exception;
1338:
1339: i_standard_type varchar2(20);
1340: i_standard_code varchar2(20);
1341: i_ext_type varchar2(200);
1342: i_ext_subtype varchar2(200);
1343: i_source_code varchar2(200);

Line 1340: i_standard_code varchar2(20);

1336: c_nummessages CONSTANT INTEGER :=1;
1337: e_qtimeout exception;
1338:
1339: i_standard_type varchar2(20);
1340: i_standard_code varchar2(20);
1341: i_ext_type varchar2(200);
1342: i_ext_subtype varchar2(200);
1343: i_source_code varchar2(200);
1344: i_destination_code varchar2(200);

Line 1368: select es.standard_type standard_type,

1364: ecx_debug.log(l_statement,'i_tp_detail_id',i_tp_detail_id,i_method_name);
1365: end if;
1366:
1367: begin
1368: select es.standard_type standard_type,
1369: es.standard_code standard_code,
1370: source_tp_location_code source,
1371: external_tp_location_code destination,
1372: protocol_type,

Line 1369: es.standard_code standard_code,

1365: end if;
1366:
1367: begin
1368: select es.standard_type standard_type,
1369: es.standard_code standard_code,
1370: source_tp_location_code source,
1371: external_tp_location_code destination,
1372: protocol_type,
1373: protocol_address,

Line 1379: into i_standard_type,

1375: password,
1376: hub_user_id,
1377: eep.ext_type ext_type,
1378: eep.ext_subtype ext_subtype
1379: into i_standard_type,
1380: i_standard_code,
1381: i_source_code,
1382: i_destination_code,
1383: i_destination_type,

Line 1380: i_standard_code,

1376: hub_user_id,
1377: eep.ext_type ext_type,
1378: eep.ext_subtype ext_subtype
1379: into i_standard_type,
1380: i_standard_code,
1381: i_source_code,
1382: i_destination_code,
1383: i_destination_type,
1384: i_destination_address,

Line 1392: ecx_standards es

1388: i_ext_type,
1389: i_ext_subtype
1390: from ecx_tp_details etd,
1391: ecx_ext_processes eep,
1392: ecx_standards es
1393: where etd.tp_detail_id = i_tp_detail_id
1394: and es.standard_id = eep.standard_id
1395: and eep.ext_process_id = etd.ext_process_id;
1396:

Line 1394: and es.standard_id = eep.standard_id

1390: from ecx_tp_details etd,
1391: ecx_ext_processes eep,
1392: ecx_standards es
1393: where etd.tp_detail_id = i_tp_detail_id
1394: and es.standard_id = eep.standard_id
1395: and eep.ext_process_id = etd.ext_process_id;
1396:
1397: exception
1398: when others then

Line 1438: 'p_standard', i_standard_code);

1434: ecx_debug.setErrorInfo(1,25,'ECX_PROTOCOL_ADDR_NULL',
1435: 'p_tp_location_code', i_source_code,
1436: 'p_transaction_type', i_ext_type,
1437: 'p_transaction_subtype', i_ext_subtype,
1438: 'p_standard', i_standard_code);
1439: raise ecx_utils.program_exit;
1440: end if;
1441:
1442: ecx_obfuscate.ecx_data_encrypt

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

1456: ecx_debug.setErrorInfo(o_retcode,30,o_retmsg);
1457: raise ecx_utils.program_exit;
1458: end if;
1459: if(l_statementEnabled) then
1460: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1461: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1462: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1463: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1464: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);

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

1457: raise ecx_utils.program_exit;
1458: end if;
1459: if(l_statementEnabled) then
1460: ecx_debug.log(l_statement,'i_standard_type',i_standard_type,i_method_name);
1461: ecx_debug.log(l_statement,'i_standard_code',i_standard_code,i_method_name);
1462: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name);
1463: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name);
1464: ecx_debug.log(l_statement,'i_source_code',i_source_code,i_method_name);
1465: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name);

Line 1474: i_standard_type,

1470: --ecx_debug.log(3,'i_password',i_password);
1471:
1472: v_message:=system.ecxmsg
1473: (
1474: i_standard_type,
1475: i_standard_code,
1476: i_ext_type,
1477: i_ext_subtype,
1478: i_document_number,

Line 1475: i_standard_code,

1471:
1472: v_message:=system.ecxmsg
1473: (
1474: i_standard_type,
1475: i_standard_code,
1476: i_ext_type,
1477: i_ext_subtype,
1478: i_document_number,
1479: null,

Line 1527: v_message.message_standard,

1523: l_retcode,
1524: l_retmsg,
1525: i_msgid,
1526: v_message.message_type,
1527: v_message.message_standard,
1528: v_message.transaction_type,
1529: v_message.transaction_subtype,
1530: v_message.document_number,
1531: v_message.partyid,

Line 1780: m_message_standard varchar2(200);

1776: msg_not_found exception;
1777:
1778: m_transaction_type varchar2(200);
1779: m_transaction_subtype varchar2(200);
1780: m_message_standard varchar2(200);
1781: m_message_type varchar2(200);
1782: m_document_number varchar2(200);
1783: m_routing_ext_code varchar2(200);
1784: m_party_ext_code varchar2(200);

Line 1798: select message_standard,

1794: (
1795: p_msgid in raw
1796: )
1797: is
1798: select message_standard,
1799: message_type,
1800: transaction_type,
1801: transaction_subtype,
1802: party_site_id,

Line 1821: into m_message_standard,

1817: begin
1818:
1819: open get_msg (i_msgid);
1820: fetch get_msg
1821: into m_message_standard,
1822: m_message_type,
1823: m_transaction_type,
1824: m_transaction_subtype,
1825: m_party_ext_code,

Line 1845: select standard_id

1841: ecx_utils.g_transaction_type := m_transaction_type;
1842: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1843: ecx_utils.g_msgid := i_msgid;
1844: begin
1845: select standard_id
1846: into ecx_utils.g_standard_id
1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');

Line 1846: into ecx_utils.g_standard_id

1842: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1843: ecx_utils.g_msgid := i_msgid;
1844: begin
1845: select standard_id
1846: into ecx_utils.g_standard_id
1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');
1850: if(l_statementEnabled) then

Line 1847: from ecx_standards

1843: ecx_utils.g_msgid := i_msgid;
1844: begin
1845: select standard_id
1846: into ecx_utils.g_standard_id
1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');
1850: if(l_statementEnabled) then
1851: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 1848: where standard_code = m_message_standard

1844: begin
1845: select standard_id
1846: into ecx_utils.g_standard_id
1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');
1850: if(l_statementEnabled) then
1851: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1852: end if;

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

1845: select standard_id
1846: into ecx_utils.g_standard_id
1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');
1850: if(l_statementEnabled) then
1851: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1852: end if;
1853: exception

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

1847: from ecx_standards
1848: where standard_code = m_message_standard
1849: and standard_type = nvl(m_message_type, 'XML');
1850: if(l_statementEnabled) then
1851: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1852: end if;
1853: exception
1854: when others then
1855: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

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

1851: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1852: end if;
1853: exception
1854: when others then
1855: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1856: raise ecx_utils.program_exit;
1857: end;
1858: ecx_debug.module_enabled;
1859: g_instlmode := wf_core.translate('WF_INSTALL');

Line 1889: 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';

1885:
1886: --get the Log directory from the Profile Option.
1887: ecx_utils.getLogDirectory;
1888:
1889: 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';
1890:
1891: p_aflog_module_name := '';
1892: IF (m_message_standard is not null) THEN
1893: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';

Line 1892: IF (m_message_standard is not null) THEN

1888:
1889: 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';
1890:
1891: p_aflog_module_name := '';
1892: IF (m_message_standard is not null) THEN
1893: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
1894: END IF;
1895: p_aflog_module_name := p_aflog_module_name || 'in.';
1896: IF (m_transaction_type is not null) THEN

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

1889: 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';
1890:
1891: p_aflog_module_name := '';
1892: IF (m_message_standard is not null) THEN
1893: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
1894: END IF;
1895: p_aflog_module_name := p_aflog_module_name || 'in.';
1896: IF (m_transaction_type is not null) THEN
1897: p_aflog_module_name := p_aflog_module_name||m_transaction_type||'.';

Line 1939: select standard_id

1935: ecx_utils.g_transaction_subtype := m_transaction_subtype;
1936: ecx_utils.g_msgid := i_msgid;*/
1937:
1938: /*begin
1939: select standard_id
1940: into ecx_utils.g_standard_id
1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');

Line 1940: into ecx_utils.g_standard_id

1936: ecx_utils.g_msgid := i_msgid;*/
1937:
1938: /*begin
1939: select standard_id
1940: into ecx_utils.g_standard_id
1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');
1944: if(l_statementEnabled) then

Line 1941: from ecx_standards

1937:
1938: /*begin
1939: select standard_id
1940: into ecx_utils.g_standard_id
1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');
1944: if(l_statementEnabled) then
1945: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 1942: where standard_code = m_message_standard

1938: /*begin
1939: select standard_id
1940: into ecx_utils.g_standard_id
1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');
1944: if(l_statementEnabled) then
1945: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1946: end if;

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

1939: select standard_id
1940: into ecx_utils.g_standard_id
1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');
1944: if(l_statementEnabled) then
1945: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1946: end if;
1947: exception

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

1941: from ecx_standards
1942: where standard_code = m_message_standard
1943: and standard_type = nvl(m_message_type, 'XML');
1944: if(l_statementEnabled) then
1945: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1946: end if;
1947: exception
1948: when others then
1949: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

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

1945: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
1946: end if;
1947: exception
1948: when others then
1949: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
1950: raise ecx_utils.program_exit;
1951: enid;*/
1952: validate_message
1953: (

Line 1955: m_message_standard,

1951: enid;*/
1952: validate_message
1953: (
1954: i_msgid,
1955: m_message_standard,
1956: m_transaction_type,
1957: m_transaction_subtype,
1958: m_party_ext_code,
1959: m_document_number,

Line 2035: m_message_standard varchar2(200);

2031: msg_not_found exception;
2032:
2033: m_transaction_type varchar2(200);
2034: m_transaction_subtype varchar2(200);
2035: m_message_standard varchar2(200);
2036: m_message_type varchar2(200);
2037: m_document_number varchar2(200);
2038: m_routing_ext_code varchar2(200);
2039: m_party_ext_code varchar2(200);

Line 2054: select message_standard,

2050: (
2051: p_msgid in raw
2052: )
2053: is
2054: select message_standard,
2055: message_type,
2056: transaction_type,
2057: transaction_subtype,
2058: party_site_id,

Line 2088: into m_message_standard,

2084: -- /logging enabled
2085:
2086: open get_msg (i_msgid);
2087: fetch get_msg
2088: into m_message_standard,
2089: m_message_type,
2090: m_transaction_type,
2091: m_transaction_subtype,
2092: m_party_ext_code,

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

2114:
2115: --get the Log directory from the Profile Option.
2116: ecx_utils.getLogDirectory;
2117:
2118: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2119:
2120: p_aflog_module_name := '';
2121: IF (m_message_standard is not null) THEN
2122: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';

Line 2121: IF (m_message_standard is not null) THEN

2117:
2118: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2119:
2120: p_aflog_module_name := '';
2121: IF (m_message_standard is not null) THEN
2122: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
2123: END IF;
2124: p_aflog_module_name := p_aflog_module_name || 'in.';
2125: IF (m_transaction_type is not null) THEN

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

2118: i_logfile := m_message_standard||'IN'||m_transaction_type||m_transaction_subtype||ecx_utils.g_run_id||'.log';
2119:
2120: p_aflog_module_name := '';
2121: IF (m_message_standard is not null) THEN
2122: p_aflog_module_name := p_aflog_module_name||m_message_standard||'.';
2123: END IF;
2124: p_aflog_module_name := p_aflog_module_name || 'in.';
2125: IF (m_transaction_type is not null) THEN
2126: p_aflog_module_name := p_aflog_module_name||m_transaction_type||'.';

Line 2168: select standard_id

2164: ecx_utils.g_transaction_subtype := m_transaction_subtype;
2165: ecx_utils.g_msgid := i_msgid;
2166:
2167: begin
2168: select standard_id
2169: into ecx_utils.g_standard_id
2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');

Line 2169: into ecx_utils.g_standard_id

2165: ecx_utils.g_msgid := i_msgid;
2166:
2167: begin
2168: select standard_id
2169: into ecx_utils.g_standard_id
2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');
2173: if(l_statementEnabled) then

Line 2170: from ecx_standards

2166:
2167: begin
2168: select standard_id
2169: into ecx_utils.g_standard_id
2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');
2173: if(l_statementEnabled) then
2174: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 2171: where standard_code = m_message_standard

2167: begin
2168: select standard_id
2169: into ecx_utils.g_standard_id
2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');
2173: if(l_statementEnabled) then
2174: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2175: end if;

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

2168: select standard_id
2169: into ecx_utils.g_standard_id
2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');
2173: if(l_statementEnabled) then
2174: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2175: end if;
2176: exception

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

2170: from ecx_standards
2171: where standard_code = m_message_standard
2172: and standard_type = nvl(m_message_type, 'XML');
2173: if(l_statementEnabled) then
2174: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2175: end if;
2176: exception
2177: when others then
2178: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

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

2174: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2175: end if;
2176: exception
2177: when others then
2178: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2179: raise ecx_utils.program_exit;
2180: end;
2181:
2182: validate_message

Line 2185: m_message_standard,

2181:
2182: validate_message
2183: (
2184: i_msgid,
2185: m_message_standard,
2186: m_transaction_type,
2187: m_transaction_subtype,
2188: m_party_ext_code,
2189: m_document_number,

Line 2247: i_message_standard IN varchar2,

2243: i_ret_code OUT NOCOPY pls_integer,
2244: i_errbuf OUT NOCOPY varchar2,
2245: i_log_file OUT NOCOPY varchar2,
2246: o_payload OUT NOCOPY CLOB,
2247: i_message_standard IN varchar2,
2248: i_message_type IN varchar2
2249: )
2250: is
2251: i_method_name varchar2(2000) := 'ecx_inbound_trig.processxml';

Line 2354: select standard_id

2350: raise ecx_utils.program_exit;
2351: end;
2352:
2353: begin
2354: select standard_id
2355: into ecx_utils.g_standard_id
2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');

Line 2355: into ecx_utils.g_standard_id

2351: end;
2352:
2353: begin
2354: select standard_id
2355: into ecx_utils.g_standard_id
2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');
2359: if(l_statementEnabled) then

Line 2356: from ecx_standards

2352:
2353: begin
2354: select standard_id
2355: into ecx_utils.g_standard_id
2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');
2359: if(l_statementEnabled) then
2360: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);

Line 2357: where standard_code = i_message_standard

2353: begin
2354: select standard_id
2355: into ecx_utils.g_standard_id
2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');
2359: if(l_statementEnabled) then
2360: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2361: end if;

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

2354: select standard_id
2355: into ecx_utils.g_standard_id
2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');
2359: if(l_statementEnabled) then
2360: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2361: end if;
2362: exception

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

2356: from ecx_standards
2357: where standard_code = i_message_standard
2358: and standard_type = nvl(i_message_type, 'XML');
2359: if(l_statementEnabled) then
2360: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2361: end if;
2362: exception
2363: when others then
2364: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');

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

2360: ecx_debug.log(l_statement,'Standard id',ecx_utils.g_standard_id,i_method_name);
2361: end if;
2362: exception
2363: when others then
2364: ecx_debug.setErrorInfo(1,30,'ECX_UNSUPPORTED_STANDARD');
2365: raise ecx_utils.program_exit;
2366: end;
2367:
2368: /*bug16442475 return status to notified and will set to complete from java*/

Line 2393: i_message_standard,

2389: i_map_id,
2390: i_payload,
2391: null,
2392: null,
2393: i_message_standard,
2394: o_payload,
2395: i_message_type
2396: );
2397: --ecx_utils.i_ret_code :=0;

Line 2594: l_event.addParameterToList('STANDARD_ID', ecx_utils.g_standard_id);

2590: l_event.addParameterToList('SENDER_TP_ID', ecx_utils.g_snd_tp_id);
2591: l_event.addParameterToList('RECV_TP_ID', i_rcv_tp_id);
2592: l_event.addParameterToList('MAP_CODE', i_map_id);
2593: l_event.addParameterToList('LOGFILE', ecx_utils.g_logfile);
2594: l_event.addParameterToList('STANDARD_ID', ecx_utils.g_standard_id);
2595: l_event.addParameterToList('ITEM_TYPE', ecx_utils.g_item_type);
2596: l_event.addParameterToList('ITEM_KEY', ecx_utils.g_item_key);
2597: l_event.addParameterToList('ACTIVITY_ID', ecx_utils.g_activity_id);
2598: l_event.addParameterToList('NO_ROUTING', i_no_routing);