DBA Data[Home] [Help]

APPS.ECX_OUTBOUND dependencies on STANDARD

Line 281: p_standard_id => ecx_utils.g_standard_id

277: p_msg_data => i_msg_data,
278: p_level => i,
279: p_tbl => ecx_utils.g_source,
280: p_tp_id => ecx_utils.g_rec_tp_id,
281: p_standard_id => ecx_utils.g_standard_id
282: );
283:
284: --Check the Status of the Code Conversion API and take appropriate action.
285: IF (

Line 857: i_message_standard IN varchar2,

853: Main Call for Processing Outbound Documents
854: **/
855: procedure process_outbound_documents
856: (
857: i_message_standard IN varchar2,
858: i_transaction_type IN varchar2,
859: i_transaction_subtype IN varchar2,
860: i_tp_id IN varchar2,
861: i_tp_site_id IN varchar2,

Line 885: i_standard_id pls_integer;

881: i_logdir varchar2(200);
882: x_same_map BOOLEAN := FALSE;
883: i_tp_header_id pls_integer;
884: i_map_id pls_integer;
885: i_standard_id pls_integer;
886: i_parameterlist wf_parameter_list_t;
887: i_parameter wf_parameter_t;
888: counter number;
889: i_paramCount number;

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

911: ecx_debug.push(i_method_name );
912: end if;
913: if(l_statementEnabled) then
914: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
915: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
916: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
917: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
918: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
919: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);

Line 948: /** Check for Message Standard Code **/

944: ecx_utils.g_transaction_type := i_transaction_type;
945: ecx_utils.g_transaction_subtype := i_transaction_subtype;
946: ecx_utils.g_document_id := i_document_id;
947:
948: /** Check for Message Standard Code **/
949: begin
950: select standard_id
951: into i_standard_id
952: from ecx_standards

Line 950: select standard_id

946: ecx_utils.g_document_id := i_document_id;
947:
948: /** Check for Message Standard Code **/
949: begin
950: select standard_id
951: into i_standard_id
952: from ecx_standards
953: where standard_code = i_message_standard
954: and standard_type = nvl(i_message_type, 'XML');

Line 951: into i_standard_id

947:
948: /** Check for Message Standard Code **/
949: begin
950: select standard_id
951: into i_standard_id
952: from ecx_standards
953: where standard_code = i_message_standard
954: and standard_type = nvl(i_message_type, 'XML');
955:

Line 952: from ecx_standards

948: /** Check for Message Standard Code **/
949: begin
950: select standard_id
951: into i_standard_id
952: from ecx_standards
953: where standard_code = i_message_standard
954: and standard_type = nvl(i_message_type, 'XML');
955:
956: ecx_utils.g_standard_id := i_standard_id;

Line 953: where standard_code = i_message_standard

949: begin
950: select standard_id
951: into i_standard_id
952: from ecx_standards
953: where standard_code = i_message_standard
954: and standard_type = nvl(i_message_type, 'XML');
955:
956: ecx_utils.g_standard_id := i_standard_id;
957: exception

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

950: select standard_id
951: into i_standard_id
952: from ecx_standards
953: where standard_code = i_message_standard
954: and standard_type = nvl(i_message_type, 'XML');
955:
956: ecx_utils.g_standard_id := i_standard_id;
957: exception
958: when others then

Line 956: ecx_utils.g_standard_id := i_standard_id;

952: from ecx_standards
953: where standard_code = i_message_standard
954: and standard_type = nvl(i_message_type, 'XML');
955:
956: ecx_utils.g_standard_id := i_standard_id;
957: exception
958: when others then
959: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
960: 'MESSAGE_STANDARD', i_message_standard);

Line 960: 'MESSAGE_STANDARD', i_message_standard);

956: ecx_utils.g_standard_id := i_standard_id;
957: exception
958: when others then
959: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
960: 'MESSAGE_STANDARD', i_message_standard);
961: if(l_statementEnabled) then
962: ecx_debug.log(l_statement,'ECX', 'ECX_CODE_CONVERSION_DISABLED',i_method_name,
963: 'MESSAGE_STANDARD', i_message_standard);
964: end if;

Line 963: 'MESSAGE_STANDARD', i_message_standard);

959: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
960: 'MESSAGE_STANDARD', i_message_standard);
961: if(l_statementEnabled) then
962: ecx_debug.log(l_statement,'ECX', 'ECX_CODE_CONVERSION_DISABLED',i_method_name,
963: 'MESSAGE_STANDARD', i_message_standard);
964: end if;
965: end;
966:
967: /** Check for Map Code **/

Line 1332: i_message_standard IN varchar2,

1328: i_party_type IN varchar2,
1329: i_document_id IN varchar2,
1330: i_map_code IN varchar2,
1331: i_message_type IN varchar2,
1332: i_message_standard IN varchar2,
1333: i_ext_type IN varchar2,
1334: i_ext_subtype IN varchar2,
1335: i_destination_code IN varchar2,
1336: i_destination_type IN varchar2,

Line 1385: ecx_utils.g_logfile :=i_message_standard||'OUT'||

1381: fetch get_run_s
1382: into ecx_utils.g_run_id;
1383: close get_run_s;
1384:
1385: ecx_utils.g_logfile :=i_message_standard||'OUT'||
1386: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1387:
1388: p_aflog_module_name := '';
1389: IF (i_message_standard is not null) THEN

Line 1389: IF (i_message_standard is not null) THEN

1385: ecx_utils.g_logfile :=i_message_standard||'OUT'||
1386: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1387:
1388: p_aflog_module_name := '';
1389: IF (i_message_standard is not null) THEN
1390: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';
1391: END IF;
1392: p_aflog_module_name := p_aflog_module_name || 'out.';
1393: IF (i_transaction_type is not null) THEN

Line 1390: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';

1386: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1387:
1388: p_aflog_module_name := '';
1389: IF (i_message_standard is not null) THEN
1390: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';
1391: END IF;
1392: p_aflog_module_name := p_aflog_module_name || 'out.';
1393: IF (i_transaction_type is not null) THEN
1394: p_aflog_module_name := p_aflog_module_name||i_transaction_type||'.';

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

1427: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1428: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1429: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1430: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1431: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1432: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1433: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1434: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1435: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );

Line 1458: i_message_standard,

1454: );
1455:
1456: process_outbound_documents
1457: (
1458: i_message_standard,
1459: i_transaction_type,
1460: i_transaction_subtype,
1461: i_party_id,
1462: i_party_site_id,

Line 1476: ecx_utils.g_event.addParameterToList('MESSAGE_STANDARD', i_message_standard);

1472: ecx_utils.g_event.addParameterToList('PARTYID', i_destination_code);
1473: ecx_utils.g_event.addParameterToList('PARTY_SITE_ID', i_destination_code);
1474: ecx_utils.g_event.addParameterToList('DOCUMENT_NUMBER', ecx_utils.g_document_id);
1475: ecx_utils.g_event.addParameterToList('MESSAGE_TYPE', i_message_type);
1476: ecx_utils.g_event.addParameterToList('MESSAGE_STANDARD', i_message_standard);
1477: ecx_utils.g_event.addParameterToList('TRANSACTION_TYPE', i_ext_type);
1478: ecx_utils.g_event.addParameterToList('TRANSACTION_SUBTYPE', i_ext_subtype);
1479: ecx_utils.g_event.addParameterToList('PROTOCOL_TYPE', i_destination_type);
1480: ecx_utils.g_event.addParameterToList('PROTOCOL_ADDRESS', i_destination_address);

Line 1663: i_message_standard IN varchar2,

1659: i_parameter4 IN varchar2,
1660: i_parameter5 IN varchar2,
1661: i_map_code IN varchar2,
1662: i_message_type IN varchar2,
1663: i_message_standard IN varchar2,
1664: i_ext_type IN varchar2,
1665: i_ext_subtype IN varchar2,
1666: i_destination_code IN varchar2,
1667: i_destination_type IN varchar2,

Line 1692: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);

1688:
1689: begin
1690: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1691: ecx_debug.g_v_module_name := 'ecx.plsql.';
1692: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1693: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1694: fnd_profile.get('AFLOG_MODULE',module);
1695: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1696: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)

Line 1731: i_message_standard ,

1727: i_party_type ,
1728: i_document_id ,
1729: i_map_code ,
1730: i_message_type ,
1731: i_message_standard ,
1732: i_ext_type ,
1733: i_ext_subtype ,
1734: i_destination_code ,
1735: i_destination_type ,

Line 1759: i_message_standard IN varchar2,

1755: end putmsg;
1756:
1757: procedure GETXML
1758: (
1759: i_message_standard IN varchar2,
1760: i_transaction_type IN varchar2,
1761: i_transaction_subtype IN varchar2,
1762: i_tp_id IN varchar2,
1763: i_tp_site_id IN varchar2,

Line 1796: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);

1792:
1793: begin
1794: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1795: ecx_debug.g_v_module_name := 'ecx.plsql.';
1796: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1797:
1798: g_instlmode := wf_core.translate('WF_INSTALL');
1799:
1800: if(g_instlmode = 'EMBEDDED')

Line 1827: ecx_utils.g_logfile :=i_message_standard||'OUT'||

1823: fetch get_run_s
1824: into ecx_utils.g_run_id;
1825: close get_run_s;
1826:
1827: ecx_utils.g_logfile :=i_message_standard||'OUT'||
1828: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1829:
1830: p_aflog_module_name := '';
1831: IF (i_message_standard is not null) THEN

Line 1831: IF (i_message_standard is not null) THEN

1827: ecx_utils.g_logfile :=i_message_standard||'OUT'||
1828: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1829:
1830: p_aflog_module_name := '';
1831: IF (i_message_standard is not null) THEN
1832: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';
1833: END IF;
1834: p_aflog_module_name := p_aflog_module_name || 'out.';
1835: IF (i_transaction_type is not null) THEN

Line 1832: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';

1828: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1829:
1830: p_aflog_module_name := '';
1831: IF (i_message_standard is not null) THEN
1832: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';
1833: END IF;
1834: p_aflog_module_name := p_aflog_module_name || 'out.';
1835: IF (i_transaction_type is not null) THEN
1836: p_aflog_module_name := p_aflog_module_name||i_transaction_type||'.';

Line 1891: i_message_standard,

1887: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);
1888:
1889: process_outbound_documents
1890: (
1891: i_message_standard,
1892: i_transaction_type,
1893: i_transaction_subtype,
1894: i_tp_id,
1895: i_tp_site_id,