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 ECX_DEBUG

Line 84: i_debug_level := wf_event_functions_pkg.subscriptionparameters(debug_level, 'ECX_DEBUG_LEVEL');

80: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
81: 'Debug Level ' || debug_level);
82: end if;
83:
84: i_debug_level := wf_event_functions_pkg.subscriptionparameters(debug_level, 'ECX_DEBUG_LEVEL');
85:
86: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
87: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
88: 'Debug Level from subscription' || i_debug_level);

Line 113: p_event.setErrorMessage(retcode||':'||ecx_debug.getMessage(errmsg,

109: return(wf_rule.default_rule(p_subscription_guid,p_event));
110: else
111: wf_event.setErrorInfo(p_event,'WARNING');
112: -- MLS
113: p_event.setErrorMessage(retcode||':'||ecx_debug.getMessage(errmsg,
114: ecx_utils.i_errparams));
115: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
116: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
117: 'Resultout is FALSE- no delivery required.');

Line 148: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

144: wf_log_pkg.string(wf_log_pkg.level_error, l_module,'Program Exit');
145: end if;
146: ecx_exception_type := 'program_exit';
147: -- Get the MLS message
148: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,
149: ecx_utils.i_errparams));
150: wf_core.raise('ECX_PROGRAM_EXIT');
151: when others then
152: wf_core.raise('ECX_EVENT_ERROR');

Line 232: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_RULE');

228: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
229: 'TriggerId '|| i_trigger_id);
230: end if;
231:
232: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_RULE');
233: ecx_errorlog.inbound_trigger(
234: i_trigger_id,
235: v_msgid,
236: null,

Line 248: --debug_level := p_event.getValueForParameter('ECX_DEBUG_LEVEL');

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');
251: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
252: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 309: ecx_debug.setErrorInfo(1,30,'ECX_PARAM_SELECT_ERROR',

305: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
306: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
307: 'Error in selecting parameters.');
308: end if;
309: ecx_debug.setErrorInfo(1,30,'ECX_PARAM_SELECT_ERROR',
310: 'p_guid',
311: p_subscription_guid);
312: wf_event.setErrorInfo(p_event,'ERROR');
313: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 313: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

309: ecx_debug.setErrorInfo(1,30,'ECX_PARAM_SELECT_ERROR',
310: 'p_guid',
311: p_subscription_guid);
312: wf_event.setErrorInfo(p_event,'ERROR');
313: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
314: ecx_utils.i_errparams));
315: p_event.event_key := v_msgid;
316: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
317: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 333: r_dbg := wf_event_functions_pkg.subscriptionparameters(r_myparams,'ECX_DEBUG_LEVEL');

329: begin
330: -- Get debug level, and default if not found
331: if r_myparams is not null
332: then
333: r_dbg := wf_event_functions_pkg.subscriptionparameters(r_myparams,'ECX_DEBUG_LEVEL');
334: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
335: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
336: 'ECX_DEBUG_LEVEL:'||r_dbg||'XX');
337: end if;

Line 336: 'ECX_DEBUG_LEVEL:'||r_dbg||'XX');

332: then
333: r_dbg := wf_event_functions_pkg.subscriptionparameters(r_myparams,'ECX_DEBUG_LEVEL');
334: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
335: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
336: 'ECX_DEBUG_LEVEL:'||r_dbg||'XX');
337: end if;
338:
339: if r_dbg is null
340: then

Line 472: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_MESSAGE');

468: message_properties => v_messageproperties,
469: payload => v_ect_inengobj,
470: msgid => v_msgid_out );
471:
472: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_MESSAGE');
473: ecx_errorlog.inbound_trigger(
474: i_trigger_id,
475: v_msgid,
476: v_msgid_out,

Line 487: ecx_debug.setErrorInfo(1,30,'ECX_PROCESSING_ENQ_ERROR',

483: end if;
484: return 'SUCCESS';
485: exception
486: when others then
487: ecx_debug.setErrorInfo(1,30,'ECX_PROCESSING_ENQ_ERROR',
488: 'p_queue_name',
489: i_queue_name);
490: ecx_errorlog.inbound_trigger(
491: i_trigger_id,

Line 505: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

501: end if;
502: wf_event.setErrorInfo(p_event,'ERROR');
503: --p_event.setErrorMessage('Error enqueuing to processing engine: ' || i_queue_name);
504: -- MLS
505: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
506: ecx_utils.i_errparams));
507: p_event.event_key := v_msgid;
508: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
509: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 517: ecx_debug.setErrorInfo(1,30,'ECX_NO_PROCESSING_QUEUE');

513: p_event.addParameterToList('ECX_DIRECTION','IN');
514: return 'ERROR';
515: end;
516: else
517: ecx_debug.setErrorInfo(1,30,'ECX_NO_PROCESSING_QUEUE');
518: ecx_errorlog.inbound_trigger(
519: i_trigger_id,
520: v_msgid,
521: v_msgid_out,

Line 532: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

528: end if;
529: wf_event.setErrorInfo(p_event,'ERROR');
530: -- MLS
531: --p_event.setErrorMessage('Unable to determine processing engine queue.');
532: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
533: ecx_utils.i_errparams));
534: p_event.event_key := v_msgid;
535: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
536: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 548: ecx_debug.setErrorInfo(2,30, 'ECX_MANY_PROCESSING_QUEUES');

544: exception
545: /* start of changes for bug #2183619*/
546: when too_many_rows then
547:
548: ecx_debug.setErrorInfo(2,30, 'ECX_MANY_PROCESSING_QUEUES');
549: ecx_errorlog.inbound_trigger(
550: i_trigger_id,
551: v_msgid,
552: v_msgid_out,

Line 563: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

559: end if;
560: wf_event.setErrorInfo(p_event,'ERROR');
561: -- MLS
562: --p_event.setErrorMessage('More than one row resulted while querying the Queue Name.');
563: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
564: ecx_utils.i_errparams));
565: p_event.event_key := v_msgid;
566: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
567: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 576: ecx_debug.setErrorInfo(2,30,'ECX_RULE_INVALID_TP_SETUP',

572:
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,

Line 605: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

601: ' is not enabled in the XML Gateway Server. Pls check your Setup');
602: end if;
603: wf_event.setErrorInfo(p_event,'ERROR');
604: -- MLS
605: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
606: ecx_utils.i_errparams));
607: p_event.event_key := v_msgid;
608: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
609: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 618: ecx_debug.setErrorInfo(2,30, 'ECX_IN_RULE_PROCESING_ERROR');

614:
615: return 'ERROR';
616: /* end of changes for bug #2183619*/
617: when others then
618: ecx_debug.setErrorInfo(2,30, 'ECX_IN_RULE_PROCESING_ERROR');
619: ecx_errorlog.inbound_trigger(
620: i_trigger_id,
621: v_msgid,
622: v_msgid_out,

Line 631: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

627: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
628: 'Error in processing inbound rule.');
629: end if;
630: wf_event.setErrorInfo(p_event,'ERROR');
631: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
632: ecx_utils.i_errparams));
633: p_event.event_key := v_msgid;
634: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
635: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 686: subscriptionparameters(myparams,'ECX_DEBUG_LEVEL');

682:
683: begin
684: -- Get debug level, and default if not found
685: dbg := wf_event_functions_pkg.
686: subscriptionparameters(myparams,'ECX_DEBUG_LEVEL');
687:
688: if dbg is null then
689: dbg := 0;
690: end if;

Line 695: 'Error in getting ECX_DEBUG_LEVEL.');

691: exception
692: when others then
693: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
694: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
695: 'Error in getting ECX_DEBUG_LEVEL.');
696: end if;
697: wf_event.setErrorInfo(p_event,'ERROR');
698: return 'ERROR';
699: end;

Line 908: p_event.addParameterToList('ECX_DEBUG_LEVEL', p_debug_mode);

904: end if;
905: end;
906: end if;
907:
908: p_event.addParameterToList('ECX_DEBUG_LEVEL', p_debug_mode);
909: p_event.addParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
910: p_event.addParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);
911: p_event.addParameterToList('ECX_ERROR_PARAMS',ecx_utils.i_errparams);
912: p_event.addParameterToList('ECX_ERROR_TYPE',ecx_utils.error_type);

Line 981: ecx_debug.setErrorInfo(1, 10, 'ECX_MESSAGE_PROCESSED_WARNING');

977: end if;
978:
979: if(ecx_utils.g_ret_code = 1 )
980: then
981: ecx_debug.setErrorInfo(1, 10, 'ECX_MESSAGE_PROCESSED_WARNING');
982: else
983: ecx_debug.setErrorInfo(0, 10, 'ECX_MESSAGE_PROCESSED');
984: end if;
985:

Line 983: ecx_debug.setErrorInfo(0, 10, 'ECX_MESSAGE_PROCESSED');

979: if(ecx_utils.g_ret_code = 1 )
980: then
981: ecx_debug.setErrorInfo(1, 10, 'ECX_MESSAGE_PROCESSED_WARNING');
982: else
983: ecx_debug.setErrorInfo(0, 10, 'ECX_MESSAGE_PROCESSED');
984: end if;
985:
986: ecx_errorlog.inbound_engine(p_process_id,
987: ecx_utils.i_ret_code,

Line 1095: l_debug_mode := p_event.getValueForParameter('ECX_DEBUG_LEVEL');

1091: return;
1092: end if;
1093:
1094: l_module := 'ecx.plsq.ecx_rule.ReceiveTPMessage.enqueue_msg';
1095: l_debug_mode := p_event.getValueForParameter('ECX_DEBUG_LEVEL');
1096:
1097: l_ecx_inengobj := system.ecx_inengobj(p_msgid_in, l_debug_mode);
1098:
1099: dbms_aq.enqueue(queue_name => p_queue_name,

Line 1116: ecx_debug.setErrorInfo(1,30,'ECX_PROCESSING_ENQ_ERROR',

1112: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1113: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
1114: 'Error enqueuing to processing engine');
1115: end if;
1116: ecx_debug.setErrorInfo(1,30,'ECX_PROCESSING_ENQ_ERROR',
1117: 'p_queue_name', p_queue_name);
1118: raise;
1119: end enqueue_msg;
1120:

Line 1177: 'ECX_DEBUG_LEVEL');

1173: return;
1174: end if;
1175:
1176: l_debug_level := wf_event_functions_pkg.subscriptionparameters(l_sub_param,
1177: 'ECX_DEBUG_LEVEL');
1178:
1179: -- if no ecx_debug_level is specified, then it should use the profile option.
1180: if l_debug_level is null then
1181: return;

Line 1179: -- if no ecx_debug_level is specified, then it should use the profile option.

1175:
1176: l_debug_level := wf_event_functions_pkg.subscriptionparameters(l_sub_param,
1177: 'ECX_DEBUG_LEVEL');
1178:
1179: -- if no ecx_debug_level is specified, then it should use the profile option.
1180: if l_debug_level is null then
1181: return;
1182: end if;
1183:

Line 1345: ecx_debug.getMessage(ecx_utils.i_errbuf,

1341: then
1342: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1343: then
1344: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1345: ecx_debug.getMessage(ecx_utils.i_errbuf,
1346: ecx_utils.i_errparams));
1347: end if;
1348: raise rule_exception;
1349: end if;

Line 1437: ecx_debug.getMessage(ecx_utils.i_errbuf,

1433: then
1434: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1435: then
1436: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1437: ecx_debug.getMessage(ecx_utils.i_errbuf,
1438: ecx_utils.i_errparams));
1439: end if;
1440: raise rule_exception;
1441: end if;

Line 1456: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

1452: ecx_utils.i_errparams
1453: );
1454:
1455: wf_event.setErrorInfo(p_event,'ERROR');
1456: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1457: ecx_utils.i_errparams));
1458: p_event.event_key := l_msgid;
1459: p_event.AddParameterToList('ECX_RETURN_CODE', ecx_utils.i_ret_code);
1460: p_event.AddParameterToList('ECX_ERROR_MSG',ecx_utils.i_errbuf);

Line 1554: l_debug_mode := p_event.getValueForParameter('ECX_DEBUG_LEVEL');

1550: l_msgid := p_event.getValueForParameter('#MSG_ID');
1551: if l_msgid is null then
1552: l_msgid := p_event.getValueForParameter('ECX_MSGID');
1553: end if;
1554: l_debug_mode := p_event.getValueForParameter('ECX_DEBUG_LEVEL');
1555: l_trigger_id := p_event.getValueForParameter('ECX_TRIGGER_ID');
1556: l_party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
1557: l_process_id := p_event.getValueForParameter('ECX_PROCESS_ID');
1558:

Line 1582: ecx_debug.setErrorInfo(10, 10,'ECX_DEQUEUED_LOGGED');

1578: fetch c_ecx_trigger_id into l_trigger_id;
1579: close c_ecx_trigger_id;
1580: end;
1581: p_event.AddParameterToList('ECX_TRIGGER_ID', l_trigger_id);
1582: ecx_debug.setErrorInfo(10, 10,'ECX_DEQUEUED_LOGGED');
1583: isTPCheck := false;
1584:
1585: else
1586: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_RULE');

Line 1586: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_RULE');

1582: ecx_debug.setErrorInfo(10, 10,'ECX_DEQUEUED_LOGGED');
1583: isTPCheck := false;
1584:
1585: else
1586: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_RULE');
1587: isTPCheck := true;
1588: if l_trigger_id is null then
1589: begin
1590: select max(trigger_id) into l_trigger_id

Line 1745: ecx_debug.getMessage(ecx_utils.i_errbuf, ecx_utils.i_errparams));

1741: end if;
1742: elsif (l_retcode >= 2) then
1743: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1744: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1745: ecx_debug.getMessage(ecx_utils.i_errbuf, ecx_utils.i_errparams));
1746: end if;
1747: raise rule_exception;
1748: end if;
1749: end; -- save to doc_logs

Line 1769: ecx_debug.setErrorInfo(2,30,'ECX_RULE_INVALID_TP_SETUP',

1765: ' is not enabled in the XML Gateway Server. '||
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);

Line 1851: ecx_debug.setErrorInfo(10, 10, 'ECX_PROCESSING_MESSAGE');

1847: enqueue_msg(p_event, l_queue_name, l_msgid, l_process_id);
1848: p_event.setCorrelationId(l_process_id);
1849: --p_event.setEventKey(l_process_id);
1850:
1851: ecx_debug.setErrorInfo(10, 10, 'ECX_PROCESSING_MESSAGE');
1852: ecx_errorlog.inbound_trigger(
1853: l_trigger_id,
1854: l_msgid,
1855: l_process_id,

Line 1867: ecx_debug.setErrorInfo(2,30, 'ECX_IN_RULE_PROCESING_ERROR');

1863: if (ecx_utils.i_ret_code = 2) then
1864: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1865: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Error.');
1866: end if;
1867: ecx_debug.setErrorInfo(2,30, 'ECX_IN_RULE_PROCESING_ERROR');
1868: raise rule_exception;
1869: end if;
1870:
1871: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

Line 1889: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

1885: ecx_utils.i_errparams
1886: );
1887:
1888: wf_event.setErrorInfo(p_event,'ERROR');
1889: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,
1890: ecx_utils.i_errparams));
1891: if (p_event.event_key is null)
1892: then
1893: p_event.event_key := l_msgid;