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 FND_LOG

Line 44: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

40: begin
41: -- initialize declared variables
42: l_module := 'ecx.plsql.ecx_rule.outbound_rule';
43:
44: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
45: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
46: 'outbound_rule');
47: end if;
48: ecx_exception_type := null;

Line 57: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

53: party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
54: document_number := p_event.getValueForParameter('ECX_DOCUMENT_ID');
55: -- Bug #2183619
56: party_type := p_event.getValueForParameter('ECX_PARTY_TYPE');
57: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
58: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
59: 'Guid: ' || p_subscription_guid);
60: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
61: 'Transaction Type ' || transaction_type);

Line 79: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

75: open c_debug_level;
76: fetch c_debug_level into debug_level;
77: close c_debug_level;
78:
79: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
80: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
81: 'Debug Level ' || debug_level);
82: end if;
83:

Line 86: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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);
89: end if;
90:

Line 115: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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.');
118: end if;
119: return 'WARNING';

Line 123: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

119: return 'WARNING';
120: end if;
121: exception
122: when ecx_document.ecx_no_party_setup then
123: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
124: wf_log_pkg.string(wf_log_pkg.level_error, l_module,'No Party Setup');
125: end if;
126: ecx_exception_type := 'ecx_no_party_setup';
127: wf_core.token('ECX_PARTY_ID', party_id);

Line 133: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

129: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
130: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
131: wf_core.raise('ECX_NO_PARTY_SETUP');
132: when ecx_document.ecx_delivery_setup_error then
133: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
134: wf_log_pkg.string(wf_log_pkg.level_error, l_module,'Delivery Setup Error');
135: end if;
136: ecx_exception_type := 'ecx_delivery_setup_error';
137: wf_core.token('ECX_PARTY_ID', party_id);

Line 143: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

139: wf_core.token('ECX_TRANSACTION_TYPE', transaction_type);
140: wf_core.token('ECX_TRANSACTION_SUBTYPE', transaction_subtype);
141: wf_core.raise('ECX_DELIVERY_SETUP_ERROR');
142: when ecx_utils.program_exit then
143: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
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

Line 165: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

161: wf_event.setErrorInfo(p_event,'WARNING');
162: return 'WARNING';
163: end if;
164: wf_event.setErrorInfo(p_event,'ERROR');
165: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
166: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
167: 'ERRMSG ' || errmsg);
168: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
169: 'Unexpected Error');

Line 216: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

212:
213: begin
214: -- initialize declared variables
215: l_module := 'ecx.plsql.ecx_rule.inbound_rule';
216: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
217: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
218: 'inbound_rule');
219: end if;
220: debug_level := 0;

Line 226: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

222:
223: v_msgid := p_event.getValueForParameter('ECX_MSGID');
224: i_trigger_id := p_event.getValueForParameter('ECX_TRIGGER_ID');
225:
226: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
227: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'MsgId '|| v_msgid);
228: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
229: 'TriggerId '|| i_trigger_id);
230: end if;

Line 251: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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,
253: 'Transaction Type ' || l_transaction_type);
254: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
255: 'Transaction Subtype '||l_transaction_subtype);

Line 290: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

286: END;
287: /*End of changes for bug #2183619*/
288:
289: if i_queue_name is not null then
290: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
291: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
292: 'Queue name '||i_queue_name);
293: end if;
294:

Line 305: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

301: from wf_event_subscriptions
302: where guid = p_subscription_guid;
303: exception
304: when others then
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',

Line 325: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

321: p_event.addParameterToList('ECX_DIRECTION','IN');
322: return 'ERROR';
323: end;
324:
325: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
326: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
327: 'Parameters from Subscription are:'||r_myparams);
328: end if;
329: begin

Line 334: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

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;
338:

Line 348: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

344: end if;
345: end if;
346: exception
347: when others then
348: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
349: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
350: 'Warning in getting DEBUG Parameters.'||SQLERRM);
351: end if;
352: end;

Line 359: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

355: -- Get TRANSACTION_TYPE
356: if r_myparams is not null
357: then
358: r_transaction_type := wf_event_functions_pkg.subscriptionparameters(r_myparams,'ECX_TRANSACTION_TYPE');
359: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
360: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
361: 'ECX_TRANSACTION_TYPE:'||r_transaction_type);
362: end if;
363: end if;

Line 366: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

362: end if;
363: end if;
364: exception
365: when others then
366: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
367: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
368: 'Warning in getting TRANSACTION_TYPE Parameters.');
369: end if;
370: end;

Line 378: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

374: if r_myparams is not null
375: then
376: r_transaction_subtype :=
377: wf_event_functions_pkg.subscriptionparameters(r_myparams,'ECX_TRANSACTION_SUBTYPE');
378: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
379: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
380: 'ECX_TRANSACTION_SUBTYPE:'||r_transaction_subtype);
381: end if;
382: end if;

Line 385: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

381: end if;
382: end if;
383: exception
384: when others then
385: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
386: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
387: 'Warning in getting TRANSACTION_SUBTYPE Parameters.');
388: end if;
389: end;

Line 395: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

391: begin
392: -- Get PARTY_SITE_ID
393: if r_myparams is not null then
394: r_party_site_id := wf_event_functions_pkg.subscriptionparameters(r_myparams,'ECX_PARTY_SITE_ID');
395: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
396: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
397: 'ECX_PARTY_SITE_ID:'||r_party_site_id);
398: end if;
399: end if;

Line 402: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

398: end if;
399: end if;
400: exception
401: when others then
402: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
403: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
404: 'Warning in getting PARTY_SITE_ID Parameter.');
405: end if;
406: end;

Line 410: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

406: end;
407:
408: if r_transaction_type is not null
409: then
410: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
411: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
412: 'r_transaction_type'||r_transaction_type||'XX'||l_transaction_type);
413: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
414: 'r_dbg'||r_dbg);

Line 420: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

416: if r_transaction_type = l_transaction_type
417: then
418: debug_level := r_dbg;
419: end if;
420: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
421: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
422: 'debug_level'||debug_level);
423:
424: -- Check for transaction_subtype also

Line 438: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

434: then
435: debug_level := r_dbg;
436: end if;
437: end if;
438: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
439: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
440: 'debug_level'||debug_level);
441:
442: -- Check for party_site_id also

Line 457: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

453: then
454: debug_level := r_dbg;
455: end if;
456: end if;
457: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
458: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
459: 'debug_level'||debug_level);
460: end if;
461: end if;

Line 480: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

476: v_msgid_out,
477: ecx_utils.i_ret_code,
478: ecx_utils.i_errbuf
479: );
480: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
481: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
482: 'Processed successfully.');
483: end if;
484: return 'SUCCESS';

Line 498: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

494: ecx_utils.i_ret_code,
495: ecx_utils.i_errbuf,
496: ecx_utils.i_errparams);
497:
498: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
499: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
500: 'Error enqueuing to processing engine');
501: end if;
502: wf_event.setErrorInfo(p_event,'ERROR');

Line 525: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

521: v_msgid_out,
522: ecx_utils.i_ret_code,
523: ecx_utils.i_errbuf
524: );
525: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
526: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
527: 'Queue name not found');
528: end if;
529: wf_event.setErrorInfo(p_event,'ERROR');

Line 556: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

552: v_msgid_out,
553: ecx_utils.i_ret_code,
554: ecx_utils.i_errbuf
555: );
556: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
557: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
558: 'More than one row resulted while querying the queue name.');
559: end if;
560: wf_event.setErrorInfo(p_event,'ERROR');

Line 595: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

591: ecx_utils.i_ret_code,
592: ecx_utils.i_errbuf,
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||

Line 626: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

622: v_msgid_out,
623: ecx_utils.i_ret_code,
624: ecx_utils.i_errbuf
625: );
626: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
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');

Line 663: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

659: l_module Varchar2(2000);
660:
661: begin
662: l_module := 'ecx.plsql.ecx_rule.inbound_rule2';
663: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
664: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
665: 'inbound_rule2');
666: end if;
667: begin

Line 675: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

671: from wf_event_subscriptions
672: where guid = p_subscription_guid;
673: exception
674: when others then
675: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
676: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
677: 'Error in selecting parameters.');
678: end if;
679: wf_event.setErrorInfo(p_event,'ERROR');

Line 693: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

689: dbg := 0;
690: end if;
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');

Line 707: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

703: mapcode := wf_event_functions_pkg.
704: subscriptionparameters(myparams,'ECX_MAP_CODE');
705: exception
706: when others then
707: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
708: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
709: 'Error in getting ECX_MAP_CODE.');
710: end if;
711: wf_event.setErrorInfo(p_event,'ERROR');

Line 724: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

720: return 'SUCCESS';
721:
722: exception
723: when others then
724: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
725: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
726: 'Error in processing inbound rule2.');
727: end if;
728: wf_event.setErrorInfo(p_event,'ERROR');

Line 756: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

752: l_module varchar2(2000);
753:
754: begin
755: l_module := 'ecx.plsql.ecx_rule.CreateTPMessage.exec_wf';
756: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
757: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
758: 'exec_wf');
759: end if;
760:

Line 776: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

772:
773: -- Workflow --
774: if (l_wftype is not null) then
775:
776: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
777: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
778: 'Calling wf_engine.event()');
779: end if;
780:

Line 820: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

816:
817: -- Route --
818: /** single consumer queues do not need a To Agent **/
819: if (l_out_guid is not null) then
820: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
821: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
822: 'Routing...' || l_out_guid);
823: end if;
824:

Line 888: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

884: return;
885: end if;
886:
887: l_module := 'ecx.plsql.ecx_rule.ReceiveTPMessage.setEventParam';
888: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
889: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
890: 'setEventParam');
891: end if;
892:

Line 901: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

897: from ecx_tp_headers
898: where tp_header_id=ecx_utils.g_snd_tp_id;
899: exception
900: when others then
901: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
902: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
903: 'Unable to determine party_type:' || l_party_type);
904: end if;
905: end;

Line 917: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

913: p_event.addParameterToList('ECX_DIRECTION', ecx_utils.g_direction);
914: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
915: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE', ecx_utils.g_transaction_subtype);
916: p_event.addParameterToList('ECX_TP_HEADER_ID', ecx_utils.g_snd_tp_id);
917: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
918: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
919: 'Tp Header Id: '|| ecx_utils.g_snd_tp_id);
920: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
921: 'Mesage Type from doclogs: '|| p_message_type);

Line 962: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

958:
959: begin
960:
961: l_module := 'ecx.plsql.ecx_rule.ReceiveTPMessage.processTPMessage';
962: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
963: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
964: 'Starting inbound processing.');
965: end if;
966: savepoint before_processing;

Line 975: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

971: p_debug_mode
972: );
973: /*bug 16442475:New Project Inbound Messages processing at java*/
974: if ECX_UTIL_API.isInJavaProcessEnabled then
975: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
976: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
977: 'Event raised for Inbound messgae processing at middle tier(i.e. java).');
978: end if;
979: /*ecx_debug.setErrorInfo has been called at ecx_inbound_trig.raiseEvent(to the the current message)

Line 982: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

978: end if;
979: /*ecx_debug.setErrorInfo has been called at ecx_inbound_trig.raiseEvent(to the the current message)
980: as documnet number is not available here*/
981: else
982: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
983: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
984: 'Completed inbound processing.');
985: end if;
986:

Line 1023: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

1019: ecx_utils.i_ret_code,
1020: ecx_utils.i_errbuf);
1021: exception
1022: when others then
1023: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1024: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
1025: 'Error While Saving the Log: ' ||p_msgid);
1026: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
1027: 'Logging Error Message: '|| substr(SQLERRM,1,200));

Line 1031: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1027: 'Logging Error Message: '|| substr(SQLERRM,1,200));
1028: end if;
1029: end;
1030:
1031: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1032: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1033: 'Exception in inbound processing.');
1034: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1035: 'Error Type: '|| ecx_utils.error_type);

Line 1113: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1109: message_properties => l_messageproperties,
1110: payload => l_ecx_inengobj,
1111: msgid => x_msgid_out );
1112:
1113: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1114: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1115: 'Enqueued to '||p_queue_name|| ' successfully.');
1116: end if;
1117:

Line 1120: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then

1116: end if;
1117:
1118: exception
1119: when others then
1120: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1121: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
1122: 'Error enqueuing to processing engine');
1123: end if;
1124: ecx_debug.setErrorInfo(1,30,'ECX_PROCESSING_ENQ_ERROR',

Line 1138: fnd_log.g_current_runtime_level := fnd_log.level_unexpected;

1134: begin
1135:
1136: if (p_debug_mode = 0) or
1137: (p_debug_mode = 1) then
1138: fnd_log.g_current_runtime_level := fnd_log.level_unexpected;
1139: elsif (p_debug_mode = 2) then
1140: fnd_log.g_current_runtime_level := fnd_log.level_procedure;
1141: elsif (p_debug_mode = 3) then
1142: fnd_log.g_current_runtime_level := fnd_log.level_statement;

Line 1140: fnd_log.g_current_runtime_level := fnd_log.level_procedure;

1136: if (p_debug_mode = 0) or
1137: (p_debug_mode = 1) then
1138: fnd_log.g_current_runtime_level := fnd_log.level_unexpected;
1139: elsif (p_debug_mode = 2) then
1140: fnd_log.g_current_runtime_level := fnd_log.level_procedure;
1141: elsif (p_debug_mode = 3) then
1142: fnd_log.g_current_runtime_level := fnd_log.level_statement;
1143: end if;
1144:

Line 1142: fnd_log.g_current_runtime_level := fnd_log.level_statement;

1138: fnd_log.g_current_runtime_level := fnd_log.level_unexpected;
1139: elsif (p_debug_mode = 2) then
1140: fnd_log.g_current_runtime_level := fnd_log.level_procedure;
1141: elsif (p_debug_mode = 3) then
1142: fnd_log.g_current_runtime_level := fnd_log.level_statement;
1143: end if;
1144:
1145: end convertEcxToFndDebug;
1146:

Line 1283: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level)

1279:
1280: begin
1281:
1282: l_module := 'ecx.plsql.ecx_rule.TPPreProcessing';
1283: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level)
1284: then
1285: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
1286: 'Starting TPPreProcessing rule function.');
1287: end if;

Line 1318: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1314: l_std_code := p_event.getValueForParameter('ECX_MESSAGE_STANDARD');
1315: l_party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
1316: l_tp_user := p_event.getValueForParameter('ECX_TP_USER');
1317:
1318: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1320: 'l_tran_type: ' || l_tran_type);
1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1322: 'l_tran_subtype: ' || l_tran_subtype);

Line 1350: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)

1346: errmsg => p_errmsg);
1347:
1348: if(is_valid = 'N')
1349: then
1350: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1351: then
1352: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1353: ecx_debug.getMessage(ecx_utils.i_errbuf,
1354: ecx_utils.i_errparams));

Line 1359: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)

1355: end if;
1356: raise rule_exception;
1357: end if;
1358:
1359: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)
1360: then
1361: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1362: 'Validated User and TP Setup.');
1363: end if;

Line 1381: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)

1377: l_attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
1378: l_attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');
1379: l_attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
1380:
1381: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)
1382: then
1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1384: 'l_party_type: ' || l_party_type);
1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1406: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)

1402: -- insert into the doclog table.
1403: l_payload := p_event.getEventData();
1404: if (l_payload is null) or
1405: (dbms_lob.getlength(l_payload) = 0) then
1406: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1407: then
1408: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1409: 'Payload is null');
1410: end if;

Line 1442: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)

1438: returnval => p_errmsg);
1439:
1440: if(p_errmsg <> 'SUCCESS')
1441: then
1442: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1443: then
1444: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1445: ecx_debug.getMessage(ecx_utils.i_errbuf,
1446: ecx_utils.i_errparams));

Line 1545: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1541: from dual;
1542:
1543: begin
1544: l_module := 'ecx.plsql.ecx_rule.ReceiveTPMessage';
1545: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1546: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
1547: 'Starting ReceiveTPMessage rule function.');
1548: end if;
1549:

Line 1555: saved_fnd_runtime_debug := fnd_log.g_current_runtime_level;

1551: l_msgid := null;
1552: l_retcode := 0;
1553: l_retmsg := null;
1554:
1555: saved_fnd_runtime_debug := fnd_log.g_current_runtime_level;
1556:
1557: -- Get the data from the Event
1558: l_msgid := p_event.getValueForParameter('#MSG_ID');
1559: if l_msgid is null then

Line 1567: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1563: l_trigger_id := p_event.getValueForParameter('ECX_TRIGGER_ID');
1564: l_party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
1565: l_process_id := p_event.getValueForParameter('ECX_PROCESS_ID');
1566:
1567: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1568: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1569: 'l_process_id: ' || l_process_id);
1570: end if;
1571:

Line 1623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1619:
1620: -- Debug for parameter
1621: l_param_list := p_event.getParameterList();
1622:
1623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1624: for i in l_param_list.first..l_param_list.last loop
1625: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1626: l_param_list(i).GetName || ':' || l_param_list(i).GetValue);
1627: end loop;

Line 1739: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1735:
1736: if (l_retcode = 0) then
1737: isSavedToDocLogs := true;
1738:
1739: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1740: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1741: 'Saved Message to DocLogs');
1742: end if;
1743: end if;

Line 1746: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1742: end if;
1743: end if;
1744:
1745: if (l_retcode = 1) then
1746: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1747: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1748: 'Return Message: '|| l_retmsg);
1749: end if;
1750: elsif (l_retcode >= 2) then

Line 1751: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1747: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1748: 'Return Message: '|| l_retmsg);
1749: end if;
1750: elsif (l_retcode >= 2) then
1751: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1752: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1753: ecx_debug.getMessage(ecx_utils.i_errbuf, ecx_utils.i_errparams));
1754: end if;
1755: raise rule_exception;

Line 1767: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then

1763: if not isTPEnabled(l_transaction_type, l_transaction_subtype,
1764: l_message_code, l_message_type, l_party_site_id,
1765: l_queue_name, l_tp_header_id) then
1766:
1767: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1768: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1769: 'The Standard: '||l_message_code|| ',' ||
1770: 'Transaction Type: '||l_transaction_type|| ',' ||
1771: 'SubType:'||l_transaction_subtype|| ',' ||

Line 1785: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1781: 'p_party_site_id', l_party_site_id);
1782:
1783: raise rule_exception;
1784: end if;
1785: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1786: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Validated TP Setup.');
1787: end if;
1788: -- end if;
1789: -- In case the message is in Transaction queue, the message should be processed.

Line 1810: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1806: p_transaction_subtype => l_transaction_subtype,
1807: p_party_site_id => l_party_site_id,
1808: p_debug_mode => l_debug_mode);
1809:
1810: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1811: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1812: 'FND Debug level is set to '
1813: || fnd_log.g_current_runtime_level );
1814: end if;

Line 1813: || fnd_log.g_current_runtime_level );

1809:
1810: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1811: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1812: 'FND Debug level is set to '
1813: || fnd_log.g_current_runtime_level );
1814: end if;
1815: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1816: if (ecx_utils.i_ret_code <> 2) then
1817: if (ecx_utils.g_event is not null and

Line 1846: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1842: p_time_stamp => l_time_stamp,
1843: p_document_number => l_document_number,
1844: p_event => p_event);
1845:
1846: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1847: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1848: 'Dispatch ' ||p_event.event_name);
1849: end if;
1850: wf_event.dispatch('EXTERNAL', null, p_event);

Line 1869: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;

1865: ecx_utils.i_errbuf
1866: );
1867: end if;
1868:
1869: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;
1870:
1871: if (ecx_utils.i_ret_code = 2) then
1872: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1873: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Error.');

Line 1872: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1868:
1869: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;
1870:
1871: if (ecx_utils.i_ret_code = 2) then
1872: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1873: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Error.');
1874: end if;
1875: ecx_debug.setErrorInfo(2,30, 'ECX_IN_RULE_PROCESING_ERROR');
1876: raise rule_exception;

Line 1879: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

1875: ecx_debug.setErrorInfo(2,30, 'ECX_IN_RULE_PROCESING_ERROR');
1876: raise rule_exception;
1877: end if;
1878:
1879: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1880: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Success.');
1881: end if;
1882: return 'SUCCESS';
1883:

Line 1886: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;

1882: return 'SUCCESS';
1883:
1884: exception
1885: when others then
1886: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;
1887: ecx_errorlog.inbound_trigger(
1888: l_trigger_id,
1889: l_msgid,
1890: l_process_id,

Line 1933: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

1929: l_module varchar2(2000);
1930:
1931: begin
1932: l_module := 'ecx.plsql.ecx_rule.CreateTPMessage';
1933: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1934: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
1935: 'Starting CreateTPMessage rule function.');
1936: end if;
1937: return (exec_wf(p_subscription_guid, p_event, 'ECXSTD', 'OUTBOUND_B2B'));