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_RULE dependencies on STANDARD

Line 6: -- Standard XML Gateway Subscription rule function

2: -- $Header: ECXRULEB.pls 120.2.12010000.1 2008/07/25 07:32:08 appldev ship $
3: --
4: --
5: -- rule (PUBLIC)
6: -- Standard XML Gateway Subscription rule function
7: -- IN:
8: -- p_subscription_guid - GUID of Subscription to be processed
9: -- p_event - Event to be processes
10: -- NOTE:

Line 176: -- Standard XML Gateway Subscription rule function

172: end outbound_rule;
173:
174:
175: -- Inbound_Rule (PUBLIC)
176: -- Standard XML Gateway Subscription rule function
177: -- IN:
178: -- p_subscription_guid - GUID of Subscription to be processed
179: -- p_event - Event to be processes
180: -- NOTE: Determines the Inbound Transaction Queue

Line 182: -- Standard inbound_rule function

178: -- p_subscription_guid - GUID of Subscription to be processed
179: -- p_event - Event to be processes
180: -- NOTE: Determines the Inbound Transaction Queue
181: --
182: -- Standard inbound_rule function
183:
184: function inbound_rule(
185: p_subscription_guid in raw,
186: p_event in out nocopy wf_event_t

Line 192: l_standard_code varchar2(2000);

188: is
189:
190: l_transaction_type varchar2(240);
191: l_transaction_subtype varchar2(240);
192: l_standard_code varchar2(2000);
193: l_standard_type varchar2(2000);
194: i_queue_name varchar2(2000);
195: v_ect_inengobj system.ecx_inengobj;
196: v_enqueueoptions dbms_aq.enqueue_options_t;

Line 193: l_standard_type varchar2(2000);

189:
190: l_transaction_type varchar2(240);
191: l_transaction_subtype varchar2(240);
192: l_standard_code varchar2(2000);
193: l_standard_type varchar2(2000);
194: i_queue_name varchar2(2000);
195: v_ect_inengobj system.ecx_inengobj;
196: v_enqueueoptions dbms_aq.enqueue_options_t;
197: v_messageproperties dbms_aq.message_properties_t;

Line 245: l_standard_code := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');

241:
242: -- Get the data from the Event
243: l_transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
244: l_transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
245: l_standard_code := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
246: l_standard_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');
247: -- we should pickup from event subscription and not from p_event VS
248: --debug_level := p_event.getValueForParameter('ECX_DEBUG_LEVEL');
249: --Party_site_id added for Bug #2183619

Line 246: l_standard_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');

242: -- Get the data from the Event
243: l_transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
244: l_transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
245: l_standard_code := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
246: l_standard_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');
247: -- we should pickup from event subscription and not from p_event VS
248: --debug_level := p_event.getValueForParameter('ECX_DEBUG_LEVEL');
249: --Party_site_id added for Bug #2183619
250: l_party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');

Line 257: 'Standard Code ' || l_standard_code);

253: 'Transaction Type ' || l_transaction_type);
254: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
255: 'Transaction Subtype '||l_transaction_subtype);
256: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
257: 'Standard Code ' || l_standard_code);
258: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
259: 'Debug Mode ' || debug_level);
260: --Party_site_id added for Bug #2183619
261: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 273: ecx_standards es,

269: tp_header_id
270: into i_queue_name,
271: l_tp_header_id
272: from ecx_ext_processes eep,
273: ecx_standards es,
274: ecx_tp_details etd
275: where eep.ext_type = l_transaction_type
276: and eep.ext_subtype = l_transaction_subtype
277: and eep.direction = 'IN'

Line 278: and eep.standard_id = es.standard_id

274: ecx_tp_details etd
275: where eep.ext_type = l_transaction_type
276: and eep.ext_subtype = l_transaction_subtype
277: and eep.direction = 'IN'
278: and eep.standard_id = es.standard_id
279: and es.standard_code = l_standard_code
280: and es.standard_type = l_standard_type
281: and etd.ext_process_id = eep.ext_process_id
282: and etd.source_tp_location_code = l_party_site_id;

Line 279: and es.standard_code = l_standard_code

275: where eep.ext_type = l_transaction_type
276: and eep.ext_subtype = l_transaction_subtype
277: and eep.direction = 'IN'
278: and eep.standard_id = es.standard_id
279: and es.standard_code = l_standard_code
280: and es.standard_type = l_standard_type
281: and etd.ext_process_id = eep.ext_process_id
282: and etd.source_tp_location_code = l_party_site_id;
283: Exception

Line 280: and es.standard_type = l_standard_type

276: and eep.ext_subtype = l_transaction_subtype
277: and eep.direction = 'IN'
278: and eep.standard_id = es.standard_id
279: and es.standard_code = l_standard_code
280: and es.standard_type = l_standard_type
281: and etd.ext_process_id = eep.ext_process_id
282: and etd.source_tp_location_code = l_party_site_id;
283: Exception
284: WHEN NO_DATA_FOUND THEN

Line 577: 'p_standard_code',

573: return 'ERROR';
574: when invalid_tp_setup then
575:
576: ecx_debug.setErrorInfo(2,30,'ECX_RULE_INVALID_TP_SETUP',
577: 'p_standard_code',
578: l_standard_code,
579: 'p_transaction_type',
580: l_transaction_type,
581: 'p_transaction_subtype',

Line 578: l_standard_code,

574: when invalid_tp_setup then
575:
576: ecx_debug.setErrorInfo(2,30,'ECX_RULE_INVALID_TP_SETUP',
577: 'p_standard_code',
578: l_standard_code,
579: 'p_transaction_type',
580: l_transaction_type,
581: 'p_transaction_subtype',
582: l_transaction_subtype,

Line 597: 'The Standard:'||l_standard_code||

593: ecx_utils.i_errparams);
594:
595: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
596: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
597: 'The Standard:'||l_standard_code||
598: ' Transaction Type:'||l_transaction_type||
599: ' SubType:'||l_transaction_subtype||
600: ' Location Code'||l_party_site_id||
601: ' is not enabled in the XML Gateway Server. Pls check your Setup');

Line 716: ECX_STANDARD.ProcessXmlCover(i_map_code=> mapcode,

712: return 'ERROR';
713: end;
714:
715: -- process
716: ECX_STANDARD.ProcessXmlCover(i_map_code=> mapcode,
717: i_inpayload => p_event.GetEventData(),
718: i_debug_level => dbg);
719:
720: return 'SUCCESS';

Line 762: priority, parameters, map_code, standard_type, standard_code

758: 'exec_wf');
759: end if;
760:
761: select out_agent_guid, to_agent_guid, wf_process_type, wf_process_name,
762: priority, parameters, map_code, standard_type, standard_code
763: into l_out_guid, l_to_guid, l_wftype, l_wfname, l_pri, l_subparams,
764: l_map_code, l_std_type, l_std_code
765: from wf_event_subscriptions
766: where guid = p_subscription_guid;

Line 790: if p_event.getValueForParameter('ECX_MESSAGE_STANDARD') is null then

786: wf_event.AddParameterToList('ECX_MAP_CODE', l_map_code, l_paramlist);
787: end if;
788: end if;
789:
790: if p_event.getValueForParameter('ECX_MESSAGE_STANDARD') is null then
791: if l_std_code is not null then
792: wf_event.AddParameterToList('ECX_MESSAGE_STANDARD', l_std_code, l_paramlist);
793: end if;
794: end if;

Line 792: wf_event.AddParameterToList('ECX_MESSAGE_STANDARD', l_std_code, l_paramlist);

788: end if;
789:
790: if p_event.getValueForParameter('ECX_MESSAGE_STANDARD') is null then
791: if l_std_code is not null then
792: wf_event.AddParameterToList('ECX_MESSAGE_STANDARD', l_std_code, l_paramlist);
793: end if;
794: end if;
795:
796: if p_event.getValueForParameter('ECX_MESSAGE_TYPE') is null then

Line 925: p_event.addParameterToList('ECX_MESSAGE_STANDARD', p_message_code);

921: 'Mesage Type from doclogs: '|| p_message_type);
922: end if;
923: p_event.addParameterToList('ECX_MSGID', p_msgid);
924: p_event.addParameterToList('ECX_MESSAGE_TYPE', p_message_type);
925: p_event.addParameterToList('ECX_MESSAGE_STANDARD', p_message_code);
926: p_event.addParameterToList('ECX_DOCUMENT_ID', p_document_number);
927: p_event.addParameterToList('ECX_PARTY_ID', p_party_id);
928: p_event.addParameterToList('ECX_PARTY_SITE_ID', p_party_site_id);
929: p_event.addParameterToList('ECX_PARTY_TYPE', l_party_type);

Line 1040: p_standard_code in varchar2,

1036:
1037: function isTPEnabled (
1038: p_transaction_type in varchar2,
1039: p_transaction_subtype in varchar2,
1040: p_standard_code in varchar2,
1041: p_standard_type in varchar2,
1042: p_party_site_id in varchar2,
1043: x_queue_name out nocopy varchar2,
1044: x_tp_header_id out nocopy number)

Line 1041: p_standard_type in varchar2,

1037: function isTPEnabled (
1038: p_transaction_type in varchar2,
1039: p_transaction_subtype in varchar2,
1040: p_standard_code in varchar2,
1041: p_standard_type in varchar2,
1042: p_party_site_id in varchar2,
1043: x_queue_name out nocopy varchar2,
1044: x_tp_header_id out nocopy number)
1045:

Line 1057: ecx_standards es,

1053: tp_header_id
1054: into x_queue_name,
1055: x_tp_header_id
1056: from ecx_ext_processes eep,
1057: ecx_standards es,
1058: ecx_tp_details etd
1059: where eep.ext_type = p_transaction_type
1060: and eep.ext_subtype = p_transaction_subtype
1061: and eep.direction = 'IN'

Line 1062: and eep.standard_id = es.standard_id

1058: ecx_tp_details etd
1059: where eep.ext_type = p_transaction_type
1060: and eep.ext_subtype = p_transaction_subtype
1061: and eep.direction = 'IN'
1062: and eep.standard_id = es.standard_id
1063: and es.standard_code = p_standard_code
1064: and es.standard_type = p_standard_type
1065: and etd.ext_process_id = eep.ext_process_id
1066: and etd.source_tp_location_code = p_party_site_id;

Line 1063: and es.standard_code = p_standard_code

1059: where eep.ext_type = p_transaction_type
1060: and eep.ext_subtype = p_transaction_subtype
1061: and eep.direction = 'IN'
1062: and eep.standard_id = es.standard_id
1063: and es.standard_code = p_standard_code
1064: and es.standard_type = p_standard_type
1065: and etd.ext_process_id = eep.ext_process_id
1066: and etd.source_tp_location_code = p_party_site_id;
1067:

Line 1064: and es.standard_type = p_standard_type

1060: and eep.ext_subtype = p_transaction_subtype
1061: and eep.direction = 'IN'
1062: and eep.standard_id = es.standard_id
1063: and es.standard_code = p_standard_code
1064: and es.standard_type = p_standard_type
1065: and etd.ext_process_id = eep.ext_process_id
1066: and etd.source_tp_location_code = p_party_site_id;
1067:
1068: return true;

Line 1224: -- Standard XML Gateway Subscription to perform User to TP and TP to

1220: end setDebugMode;
1221:
1222: --
1223: -- TPPreProcessing
1224: -- Standard XML Gateway Subscription to perform User to TP and TP to
1225: -- transaction validation and also to perform the initial logging
1226: -- IN:
1227: -- p_subscription_guid - GUID of Subscription to be processed
1228: -- p_event - Event to be processed

Line 1306: l_std_code := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');

1302:
1303: l_tran_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
1304: l_tran_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
1305: l_std_type := p_event.getValueForParameter('ECX_MESSAGE_TYPE');
1306: l_std_code := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
1307: l_party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
1308: l_tp_user := p_event.getValueForParameter('ECX_TP_USER');
1309:
1310: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 1332: p_standard_code => l_std_code,

1328:
1329: is_valid := ecx_trading_partner_pvt.validateTPUser(
1330: p_transaction_type => l_tran_type,
1331: p_transaction_subtype => l_tran_subtype,
1332: p_standard_code => l_std_code,
1333: p_standard_type => l_std_type,
1334: p_party_site_id => l_party_site_id,
1335: p_user_name => l_tp_user,
1336: x_tp_header_id => p_tp_header_id,

Line 1333: p_standard_type => l_std_type,

1329: is_valid := ecx_trading_partner_pvt.validateTPUser(
1330: p_transaction_type => l_tran_type,
1331: p_transaction_subtype => l_tran_subtype,
1332: p_standard_code => l_std_code,
1333: p_standard_type => l_std_type,
1334: p_party_site_id => l_party_site_id,
1335: p_user_name => l_tp_user,
1336: x_tp_header_id => p_tp_header_id,
1337: retcode => p_ret_code,

Line 1413: message_standard => l_std_code,

1409: err_msg => null,
1410: receipt_msgid => l_msgid,
1411: trigger_id => l_trigger_id,
1412: message_type => l_std_type,
1413: message_standard => l_std_code,
1414: transaction_type => l_tran_type,
1415: transaction_subtype => l_tran_subtype,
1416: document_number => l_doc_number,
1417: partyid => l_party_id,

Line 1470: p_event.addParameterToList('ECX_MESSAGE_STANDARD',l_std_code);

1466: p_event.AddParameterToList('ECX_PARTY_ID',l_party_id);
1467: p_event.AddParameterToList('ECX_PARTY_SITE_ID',l_party_site_id);
1468: p_event.AddParameterToList('ECX_PARTY_TYPE',l_party_type);
1469: p_event.addParameterToList('ECX_DIRECTION','IN');
1470: p_event.addParameterToList('ECX_MESSAGE_STANDARD',l_std_code);
1471: p_event.addParameterToList('ECX_MESSAGE_TYPE', l_std_type);
1472: p_event.addParameterToList('ECX_DOCUMENT_NUMBER', l_doc_number);
1473: return 'ERROR';
1474: end TPPreProcessing;

Line 1479: -- Standard XML Gateway Subscription rule function for inbound B2B

1475:
1476:
1477:
1478: -- ReceiveTPMessage
1479: -- Standard XML Gateway Subscription rule function for inbound B2B
1480: -- IN:
1481: -- p_subscription_guid - GUID of Subscription to be processed
1482: -- p_event - Event to be processes
1483: -- NOTE: Determines the Inbound Transaction Queue

Line 1485: -- Standard B2B inbound function

1481: -- p_subscription_guid - GUID of Subscription to be processed
1482: -- p_event - Event to be processes
1483: -- NOTE: Determines the Inbound Transaction Queue
1484: --
1485: -- Standard B2B inbound function
1486:
1487: function ReceiveTPMessage(
1488: p_subscription_guid in raw,
1489: p_event in out nocopy wf_event_t

Line 1673: l_message_code := nvl(p_event.getValueForParameter('ECX_MESSAGE_STANDARD'), 'OAG');

1669: end if;
1670:
1671: l_transaction_type := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
1672: l_transaction_subtype := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');
1673: l_message_code := nvl(p_event.getValueForParameter('ECX_MESSAGE_STANDARD'), 'OAG');
1674: l_message_type := nvl(p_event.getValueForParameter('ECX_MESSAGE_TYPE'), 'XML');
1675: l_document_number := p_event.getValueForParameter('ECX_DOCUMENT_NUMBER');
1676: if(l_document_number is null) then
1677: l_document_number := l_trigger_id;

Line 1761: 'The Standard: '||l_message_code|| ',' ||

1757: l_queue_name, l_tp_header_id) then
1758:
1759: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1760: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1761: 'The Standard: '||l_message_code|| ',' ||
1762: 'Transaction Type: '||l_transaction_type|| ',' ||
1763: 'SubType:'||l_transaction_subtype|| ',' ||
1764: 'Location Code'||l_party_site_id||
1765: ' is not enabled in the XML Gateway Server. '||

Line 1770: 'p_standard_code', l_message_code,

1766: ' Pls check your Setup');
1767: end if;
1768:
1769: ecx_debug.setErrorInfo(2,30,'ECX_RULE_INVALID_TP_SETUP',
1770: 'p_standard_code', l_message_code,
1771: 'p_transaction_type', l_transaction_type,
1772: 'p_transaction_subtype', l_transaction_subtype,
1773: 'p_party_site_id', l_party_site_id);
1774:

Line 1906: p_event.addParameterToList('ECX_MESSAGE_STANDARD',l_message_code);

1902: p_event.AddParameterToList('ECX_PARTY_ID',l_party_id);
1903: p_event.AddParameterToList('ECX_PARTY_SITE_ID',l_party_site_id);
1904: p_event.AddParameterToList('ECX_PARTY_TYPE',l_party_type);
1905: p_event.addParameterToList('ECX_DIRECTION','IN');
1906: p_event.addParameterToList('ECX_MESSAGE_STANDARD',l_message_code);
1907: p_event.addParameterToList('ECX_MESSAGE_TYPE', l_message_type);
1908: p_event.addParameterToList('ECX_DOCUMENT_ID', l_document_number);
1909:
1910: return 'ERROR';