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 974: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

970: p_msgid,
971: p_debug_mode
972: );
973:
974: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
975: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
976: 'Completed inbound processing.');
977: end if;
978:

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

1011: ecx_utils.i_ret_code,
1012: ecx_utils.i_errbuf);
1013: exception
1014: when others then
1015: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1016: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
1017: 'Error While Saving the Log: ' ||p_msgid);
1018: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
1019: 'Logging Error Message: '|| substr(SQLERRM,1,200));

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

1019: 'Logging Error Message: '|| substr(SQLERRM,1,200));
1020: end if;
1021: end;
1022:
1023: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1024: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1025: 'Exception in inbound processing.');
1026: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1027: 'Error Type: '|| ecx_utils.error_type);

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

1101: message_properties => l_messageproperties,
1102: payload => l_ecx_inengobj,
1103: msgid => x_msgid_out );
1104:
1105: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1106: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1107: 'Enqueued to '||p_queue_name|| ' successfully.');
1108: end if;
1109:

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

1108: end if;
1109:
1110: exception
1111: when others then
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',

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

1126: begin
1127:
1128: if (p_debug_mode = 0) or
1129: (p_debug_mode = 1) then
1130: fnd_log.g_current_runtime_level := fnd_log.level_unexpected;
1131: elsif (p_debug_mode = 2) then
1132: fnd_log.g_current_runtime_level := fnd_log.level_procedure;
1133: elsif (p_debug_mode = 3) then
1134: fnd_log.g_current_runtime_level := fnd_log.level_statement;

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

1128: if (p_debug_mode = 0) or
1129: (p_debug_mode = 1) then
1130: fnd_log.g_current_runtime_level := fnd_log.level_unexpected;
1131: elsif (p_debug_mode = 2) then
1132: fnd_log.g_current_runtime_level := fnd_log.level_procedure;
1133: elsif (p_debug_mode = 3) then
1134: fnd_log.g_current_runtime_level := fnd_log.level_statement;
1135: end if;
1136:

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

1130: fnd_log.g_current_runtime_level := fnd_log.level_unexpected;
1131: elsif (p_debug_mode = 2) then
1132: fnd_log.g_current_runtime_level := fnd_log.level_procedure;
1133: elsif (p_debug_mode = 3) then
1134: fnd_log.g_current_runtime_level := fnd_log.level_statement;
1135: end if;
1136:
1137: end convertEcxToFndDebug;
1138:

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

1271:
1272: begin
1273:
1274: l_module := 'ecx.plsql.ecx_rule.TPPreProcessing';
1275: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level)
1276: then
1277: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
1278: 'Starting TPPreProcessing rule function.');
1279: end if;

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

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
1311: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1312: 'l_tran_type: ' || l_tran_type);
1313: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1314: 'l_tran_subtype: ' || l_tran_subtype);

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

1338: errmsg => p_errmsg);
1339:
1340: if(is_valid = 'N')
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));

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

1347: end if;
1348: raise rule_exception;
1349: end if;
1350:
1351: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)
1352: then
1353: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1354: 'Validated User and TP Setup.');
1355: end if;

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

1369: l_attribute3 := p_event.getValueForParameter('ECX_ATTRIBUTE3');
1370: l_attribute4 := p_event.getValueForParameter('ECX_ATTRIBUTE4');
1371: l_attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
1372:
1373: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)
1374: then
1375: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1376: 'l_party_type: ' || l_party_type);
1377: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

1394: -- insert into the doclog table.
1395: l_payload := p_event.getEventData();
1396: if (l_payload is null) or
1397: (dbms_lob.getlength(l_payload) = 0) then
1398: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1399: then
1400: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1401: 'Payload is null');
1402: end if;

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

1430: returnval => p_errmsg);
1431:
1432: if(p_errmsg <> 'SUCCESS')
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));

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

1533: from dual;
1534:
1535: begin
1536: l_module := 'ecx.plsql.ecx_rule.ReceiveTPMessage';
1537: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1538: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
1539: 'Starting ReceiveTPMessage rule function.');
1540: end if;
1541:

Line 1547: saved_fnd_runtime_debug := fnd_log.g_current_runtime_level;

1543: l_msgid := null;
1544: l_retcode := 0;
1545: l_retmsg := null;
1546:
1547: saved_fnd_runtime_debug := fnd_log.g_current_runtime_level;
1548:
1549: -- Get the data from the Event
1550: l_msgid := p_event.getValueForParameter('#MSG_ID');
1551: if l_msgid is null then

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

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:
1559: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1560: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1561: 'l_process_id: ' || l_process_id);
1562: end if;
1563:

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

1611:
1612: -- Debug for parameter
1613: l_param_list := p_event.getParameterList();
1614:
1615: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1616: for i in l_param_list.first..l_param_list.last loop
1617: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1618: l_param_list(i).GetName || ':' || l_param_list(i).GetValue);
1619: end loop;

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

1727:
1728: if (l_retcode = 0) then
1729: isSavedToDocLogs := true;
1730:
1731: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1732: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1733: 'Saved Message to DocLogs');
1734: end if;
1735: end if;

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

1734: end if;
1735: end if;
1736:
1737: if (l_retcode = 1) then
1738: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1739: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1740: 'Return Message: '|| l_retmsg);
1741: end if;
1742: elsif (l_retcode >= 2) then

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

1739: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1740: 'Return Message: '|| l_retmsg);
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;

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

1755: if not isTPEnabled(l_transaction_type, l_transaction_subtype,
1756: l_message_code, l_message_type, l_party_site_id,
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|| ',' ||

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

1773: 'p_party_site_id', l_party_site_id);
1774:
1775: raise rule_exception;
1776: end if;
1777: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1778: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Validated TP Setup.');
1779: end if;
1780: -- end if;
1781: -- In case the message is in Transaction queue, the message should be processed.

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

1798: p_transaction_subtype => l_transaction_subtype,
1799: p_party_site_id => l_party_site_id,
1800: p_debug_mode => l_debug_mode);
1801:
1802: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1803: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1804: 'FND Debug level is set to '
1805: || fnd_log.g_current_runtime_level );
1806: end if;

Line 1805: || fnd_log.g_current_runtime_level );

1801:
1802: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1803: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1804: 'FND Debug level is set to '
1805: || fnd_log.g_current_runtime_level );
1806: end if;
1807: processTPMessage(l_msgid, l_debug_mode, l_process_id);
1808: if (ecx_utils.i_ret_code <> 2) then
1809: if (ecx_utils.g_event is not null and

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

1834: p_time_stamp => l_time_stamp,
1835: p_document_number => l_document_number,
1836: p_event => p_event);
1837:
1838: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1839: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1840: 'Dispatch ' ||p_event.event_name);
1841: end if;
1842: wf_event.dispatch('EXTERNAL', null, p_event);

Line 1861: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;

1857: ecx_utils.i_errbuf
1858: );
1859: end if;
1860:
1861: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;
1862:
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.');

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

1860:
1861: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;
1862:
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;

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

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
1872: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Success.');
1873: end if;
1874: return 'SUCCESS';
1875:

Line 1878: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;

1874: return 'SUCCESS';
1875:
1876: exception
1877: when others then
1878: fnd_log.g_current_runtime_level := saved_fnd_runtime_debug;
1879: ecx_errorlog.inbound_trigger(
1880: l_trigger_id,
1881: l_msgid,
1882: l_process_id,

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

1921: l_module varchar2(2000);
1922:
1923: begin
1924: l_module := 'ecx.plsql.ecx_rule.CreateTPMessage';
1925: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
1926: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
1927: 'Starting CreateTPMessage rule function.');
1928: end if;
1929: return (exec_wf(p_subscription_guid, p_event, 'ECXSTD', 'OUTBOUND_B2B'));