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 903: i_message_standard IN varchar2,

899: Main Call for Processing Outbound Documents
900: **/
901: procedure process_outbound_documents
902: (
903: i_message_standard IN varchar2,
904: i_transaction_type IN varchar2,
905: i_transaction_subtype IN varchar2,
906: i_tp_id IN varchar2,
907: i_tp_site_id IN varchar2,

Line 931: i_standard_id pls_integer;

927: i_logdir varchar2(200);
928: x_same_map BOOLEAN := FALSE;
929: i_tp_header_id pls_integer;
930: i_map_id pls_integer;
931: i_standard_id pls_integer;
932: i_parameterlist wf_parameter_list_t;
933: i_parameter wf_parameter_t;
934: counter number;
935: i_paramCount number;

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

957: ecx_debug.push(i_method_name );
958: end if;
959: if(l_statementEnabled) then
960: ecx_debug.log(l_statement,'ECX','ECX_START_OUTBOUND','MAP_ID',i_map_id,i_method_name);
961: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name);
962: ecx_debug.log(l_statement,'i_transaction_type',i_transaction_type,i_method_name);
963: ecx_debug.log(l_statement,'i_transaction_subtype',i_transaction_subtype,i_method_name);
964: ecx_debug.log(l_statement,'i_tp_id',i_tp_id,i_method_name);
965: ecx_debug.log(l_statement,'i_tp_site_id',i_tp_site_id,i_method_name);

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

990: ecx_utils.g_transaction_type := i_transaction_type;
991: ecx_utils.g_transaction_subtype := i_transaction_subtype;
992: ecx_utils.g_document_id := i_document_id;
993:
994: /** Check for Message Standard Code **/
995: begin
996: select standard_id
997: into i_standard_id
998: from ecx_standards

Line 996: select standard_id

992: ecx_utils.g_document_id := i_document_id;
993:
994: /** Check for Message Standard Code **/
995: begin
996: select standard_id
997: into i_standard_id
998: from ecx_standards
999: where standard_code = i_message_standard
1000: and standard_type = nvl(i_message_type, 'XML');

Line 997: into i_standard_id

993:
994: /** Check for Message Standard Code **/
995: begin
996: select standard_id
997: into i_standard_id
998: from ecx_standards
999: where standard_code = i_message_standard
1000: and standard_type = nvl(i_message_type, 'XML');
1001:

Line 998: from ecx_standards

994: /** Check for Message Standard Code **/
995: begin
996: select standard_id
997: into i_standard_id
998: from ecx_standards
999: where standard_code = i_message_standard
1000: and standard_type = nvl(i_message_type, 'XML');
1001:
1002: ecx_utils.g_standard_id := i_standard_id;

Line 999: where standard_code = i_message_standard

995: begin
996: select standard_id
997: into i_standard_id
998: from ecx_standards
999: where standard_code = i_message_standard
1000: and standard_type = nvl(i_message_type, 'XML');
1001:
1002: ecx_utils.g_standard_id := i_standard_id;
1003: exception

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

996: select standard_id
997: into i_standard_id
998: from ecx_standards
999: where standard_code = i_message_standard
1000: and standard_type = nvl(i_message_type, 'XML');
1001:
1002: ecx_utils.g_standard_id := i_standard_id;
1003: exception
1004: when others then

Line 1002: ecx_utils.g_standard_id := i_standard_id;

998: from ecx_standards
999: where standard_code = i_message_standard
1000: and standard_type = nvl(i_message_type, 'XML');
1001:
1002: ecx_utils.g_standard_id := i_standard_id;
1003: exception
1004: when others then
1005: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
1006: 'MESSAGE_STANDARD', i_message_standard);

Line 1006: 'MESSAGE_STANDARD', i_message_standard);

1002: ecx_utils.g_standard_id := i_standard_id;
1003: exception
1004: when others then
1005: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
1006: 'MESSAGE_STANDARD', i_message_standard);
1007: if(l_statementEnabled) then
1008: ecx_debug.log(l_statement,'ECX', 'ECX_CODE_CONVERSION_DISABLED',i_method_name,
1009: 'MESSAGE_STANDARD', i_message_standard);
1010: end if;

Line 1009: 'MESSAGE_STANDARD', i_message_standard);

1005: ecx_debug.setErrorInfo(1, 30, 'ECX_CODE_CONVERSION_DISABLED',
1006: 'MESSAGE_STANDARD', i_message_standard);
1007: if(l_statementEnabled) then
1008: ecx_debug.log(l_statement,'ECX', 'ECX_CODE_CONVERSION_DISABLED',i_method_name,
1009: 'MESSAGE_STANDARD', i_message_standard);
1010: end if;
1011: end;
1012:
1013: /** Check for Map Code **/

Line 1367: i_message_standard IN varchar2,

1363: i_party_type IN varchar2,
1364: i_document_id IN varchar2,
1365: i_map_code IN varchar2,
1366: i_message_type IN varchar2,
1367: i_message_standard IN varchar2,
1368: i_ext_type IN varchar2,
1369: i_ext_subtype IN varchar2,
1370: i_destination_code IN varchar2,
1371: i_destination_type IN varchar2,

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

1416: fetch get_run_s
1417: into ecx_utils.g_run_id;
1418: close get_run_s;
1419:
1420: ecx_utils.g_logfile :=i_message_standard||'OUT'||
1421: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1422:
1423: p_aflog_module_name := '';
1424: IF (i_message_standard is not null) THEN

Line 1424: IF (i_message_standard is not null) THEN

1420: ecx_utils.g_logfile :=i_message_standard||'OUT'||
1421: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1422:
1423: p_aflog_module_name := '';
1424: IF (i_message_standard is not null) THEN
1425: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';
1426: END IF;
1427: p_aflog_module_name := p_aflog_module_name || 'out.';
1428: IF (i_transaction_type is not null) THEN

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

1421: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1422:
1423: p_aflog_module_name := '';
1424: IF (i_message_standard is not null) THEN
1425: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';
1426: END IF;
1427: p_aflog_module_name := p_aflog_module_name || 'out.';
1428: IF (i_transaction_type is not null) THEN
1429: p_aflog_module_name := p_aflog_module_name||i_transaction_type||'.';

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

1462: ecx_debug.log(l_statement,'i_party_type',i_party_type,i_method_name );
1463: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1464: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1465: ecx_debug.log(l_statement,'i_message_type',i_message_type,i_method_name );
1466: ecx_debug.log(l_statement,'i_message_standard',i_message_standard,i_method_name );
1467: ecx_debug.log(l_statement,'i_ext_type',i_ext_type,i_method_name );
1468: ecx_debug.log(l_statement,'i_ext_subtype',i_ext_subtype,i_method_name );
1469: ecx_debug.log(l_statement,'i_destination_code',i_destination_code,i_method_name );
1470: ecx_debug.log(l_statement,'i_destination_address',i_destination_address,i_method_name );

Line 1493: i_message_standard,

1489: );
1490:
1491: process_outbound_documents
1492: (
1493: i_message_standard,
1494: i_transaction_type,
1495: i_transaction_subtype,
1496: i_party_id,
1497: i_party_site_id,

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

1507: ecx_utils.g_event.addParameterToList('PARTYID', i_destination_code);
1508: ecx_utils.g_event.addParameterToList('PARTY_SITE_ID', i_destination_code);
1509: ecx_utils.g_event.addParameterToList('DOCUMENT_NUMBER', ecx_utils.g_document_id);
1510: ecx_utils.g_event.addParameterToList('MESSAGE_TYPE', i_message_type);
1511: ecx_utils.g_event.addParameterToList('MESSAGE_STANDARD', i_message_standard);
1512: ecx_utils.g_event.addParameterToList('TRANSACTION_TYPE', i_ext_type);
1513: ecx_utils.g_event.addParameterToList('TRANSACTION_SUBTYPE', i_ext_subtype);
1514: ecx_utils.g_event.addParameterToList('PROTOCOL_TYPE', i_destination_type);
1515: ecx_utils.g_event.addParameterToList('PROTOCOL_ADDRESS', i_destination_address);

Line 1698: i_message_standard IN varchar2,

1694: i_parameter4 IN varchar2,
1695: i_parameter5 IN varchar2,
1696: i_map_code IN varchar2,
1697: i_message_type IN varchar2,
1698: i_message_standard IN varchar2,
1699: i_ext_type IN varchar2,
1700: i_ext_subtype IN varchar2,
1701: i_destination_code IN varchar2,
1702: i_destination_type IN varchar2,

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

1723:
1724: begin
1725: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1726: ecx_debug.g_v_module_name := 'ecx.plsql.';
1727: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1728: fnd_profile.get('AFLOG_ENABLED',logging_enabled);
1729: fnd_profile.get('AFLOG_MODULE',module);
1730: if(logging_enabled = 'Y' AND ((lower(module) like 'ecx%'
1731: AND instr(lower(ecx_debug.g_v_module_name),rtrim(lower(module),'%'))> 0)

Line 1766: i_message_standard ,

1762: i_party_type ,
1763: i_document_id ,
1764: i_map_code ,
1765: i_message_type ,
1766: i_message_standard ,
1767: i_ext_type ,
1768: i_ext_subtype ,
1769: i_destination_code ,
1770: i_destination_type ,

Line 1794: i_message_standard IN varchar2,

1790: end putmsg;
1791:
1792: procedure GETXML
1793: (
1794: i_message_standard IN varchar2,
1795: i_transaction_type IN varchar2,
1796: i_transaction_subtype IN varchar2,
1797: i_tp_id IN varchar2,
1798: i_tp_site_id IN varchar2,

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

1827:
1828: begin
1829: --To populate the global variable ecx_debug.g_v_module_name , need to call ecx_debug.module_enabled
1830: ecx_debug.g_v_module_name := 'ecx.plsql.';
1831: ecx_debug.module_enabled(i_message_standard,i_transaction_type,i_transaction_subtype,i_document_id);
1832:
1833: g_instlmode := wf_core.translate('WF_INSTALL');
1834:
1835: if(g_instlmode = 'EMBEDDED')

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

1858: fetch get_run_s
1859: into ecx_utils.g_run_id;
1860: close get_run_s;
1861:
1862: ecx_utils.g_logfile :=i_message_standard||'OUT'||
1863: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1864:
1865: p_aflog_module_name := '';
1866: IF (i_message_standard is not null) THEN

Line 1866: IF (i_message_standard is not null) THEN

1862: ecx_utils.g_logfile :=i_message_standard||'OUT'||
1863: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1864:
1865: p_aflog_module_name := '';
1866: IF (i_message_standard is not null) THEN
1867: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';
1868: END IF;
1869: p_aflog_module_name := p_aflog_module_name || 'out.';
1870: IF (i_transaction_type is not null) THEN

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

1863: i_transaction_type||i_transaction_subtype||i_document_id||ecx_utils.g_run_id||'.log';
1864:
1865: p_aflog_module_name := '';
1866: IF (i_message_standard is not null) THEN
1867: p_aflog_module_name := p_aflog_module_name||i_message_standard||'.';
1868: END IF;
1869: p_aflog_module_name := p_aflog_module_name || 'out.';
1870: IF (i_transaction_type is not null) THEN
1871: p_aflog_module_name := p_aflog_module_name||i_transaction_type||'.';

Line 1926: i_message_standard,

1922: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);
1923:
1924: process_outbound_documents
1925: (
1926: i_message_standard,
1927: i_transaction_type,
1928: i_transaction_subtype,
1929: i_tp_id,
1930: i_tp_site_id,