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 WF_LOG_PKG

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 45: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.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;
49:

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 58: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
62: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 60: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
62: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
63: 'Transaction Subtype ' || transaction_subtype);
64: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 62: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
62: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
63: 'Transaction Subtype ' || transaction_subtype);
64: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
65: 'Party Id ' || party_id);
66: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 64: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

60: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
61: 'Transaction Type ' || transaction_type);
62: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
63: 'Transaction Subtype ' || transaction_subtype);
64: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
65: 'Party Id ' || party_id);
66: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
67: 'Party Site Id ' || party_site_id);
68: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 66: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

62: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
63: 'Transaction Subtype ' || transaction_subtype);
64: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
65: 'Party Id ' || party_id);
66: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
67: 'Party Site Id ' || party_site_id);
68: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
69: 'Document Id ' || document_number);
70: --Bug #2183619

Line 68: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

64: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
65: 'Party Id ' || party_id);
66: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
67: 'Party Site Id ' || party_site_id);
68: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
69: 'Document Id ' || document_number);
70: --Bug #2183619
71: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
72: 'party_type' || party_type);

Line 71: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

67: 'Party Site Id ' || party_site_id);
68: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
69: 'Document Id ' || document_number);
70: --Bug #2183619
71: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
72: 'party_type' || party_type);
73: end if;
74:
75: open c_debug_level;

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 80: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
84: i_debug_level := wf_event_functions_pkg.subscriptionparameters(debug_level, 'ECX_DEBUG_LEVEL');

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 87: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
91: begin

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 116: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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';
120: end if;

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 124: wf_log_pkg.string(wf_log_pkg.level_error, l_module,'No Party Setup');

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);
128: wf_core.token('ECX_PARTY_SITE_ID', party_site_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 134: wf_log_pkg.string(wf_log_pkg.level_error, l_module,'Delivery Setup Error');

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);
138: wf_core.token('ECX_PARTY_SITE_ID', party_site_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 144: wf_log_pkg.string(wf_log_pkg.level_error, l_module,'Program Exit');

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
148: wf_core.token('ECX_ERRMSG',ecx_debug.getMessage(ecx_utils.i_errbuf,

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 166: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

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');
170: end if;

Line 168: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

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');
170: end if;
171: return 'ERROR';
172: end outbound_rule;

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 217: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',

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;
221: r_dbg :=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 227: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'MsgId '|| v_msgid);

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

Line 228: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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;
231:
232: ecx_debug.setErrorInfo(10,10, 'ECX_PROCESSING_RULE');

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 252: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
256: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 254: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
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,

Line 256: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
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

Line 258: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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,
262: 'party_site_id ' || l_party_site_id );

Line 261: 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,
262: 'party_site_id ' || l_party_site_id );
263: end if;
264:
265: /*start of changes for Bug#2183619*/

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 291: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
295: -- Enqueue the Event on the Inbound Engine

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 306: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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',
310: 'p_guid',

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 326: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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
330: -- Get debug level, and default if not found

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 335: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
339: if r_dbg is null

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 349: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

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 360: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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;
364: exception

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 367: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

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 379: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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;
383: exception

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 386: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

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 396: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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;
400: exception

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 403: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

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 411: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

Line 413: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
415: end if;
416: if r_transaction_type = l_transaction_type
417: then

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 421: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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
425: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 425: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

421: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
422: 'debug_level'||debug_level);
423:
424: -- Check for transaction_subtype also
425: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
426: 'r_transaction_subtype'||r_transaction_subtype||
427: 'XX'|| l_transaction_subtype);
428: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
429: 'r_dbg'||r_dbg);

Line 428: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

424: -- Check for transaction_subtype also
425: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
426: 'r_transaction_subtype'||r_transaction_subtype||
427: 'XX'|| l_transaction_subtype);
428: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
429: 'r_dbg'||r_dbg);
430: end if;
431: if r_transaction_subtype is not null
432: then

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 439: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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
443: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 443: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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
443: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
444: 'r_party_site_id'||r_party_site_id);
445: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
446: 'l_party_site_id'||l_party_site_id);
447: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 445: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

441:
442: -- Check for party_site_id also
443: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
444: 'r_party_site_id'||r_party_site_id);
445: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
446: 'l_party_site_id'||l_party_site_id);
447: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
448: 'r_dbg'||r_dbg);
449: end if;

Line 447: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

443: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
444: 'r_party_site_id'||r_party_site_id);
445: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
446: 'l_party_site_id'||l_party_site_id);
447: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
448: 'r_dbg'||r_dbg);
449: end if;
450: if r_party_site_id is not null
451: then

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 458: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

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 481: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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';
485: exception

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 499: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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');
503: --p_event.setErrorMessage('Error enqueuing to processing engine: ' || i_queue_name);

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 526: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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');
530: -- MLS

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 557: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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');
561: -- MLS

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 596: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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||
600: ' Location Code'||l_party_site_id||

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 627: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

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');
631: p_event.setErrorMessage(ecx_debug.getMessage(ecx_utils.i_errbuf,

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 664: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',

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
668: -- Get Params

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 676: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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');
680: return '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 694: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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');
698: return '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 708: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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');
712: return '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 725: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

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');
729: return '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 757: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',

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:
761: select out_agent_guid, to_agent_guid, wf_process_type, wf_process_name,

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 777: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
781: l_paramlist := p_event.Parameter_List;

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 821: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
825: p_event.From_Agent := wf_event.newAgent(l_out_guid);

Line 834: if (wf_log_pkg.wf_debug_flag = TRUE) then

830: wf_event.send(p_event);
831: end if;
832:
833: -- Debug --
834: if (wf_log_pkg.wf_debug_flag = TRUE) then
835: begin
836: l_res := wf_rule.log(p_subscription_guid, p_event);
837: exception
838: when others then null;

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 889: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',

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:
893: if ecx_utils.g_snd_tp_id is not null then

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 902: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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;
906: end if;

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 918: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

Line 920: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
922: end if;
923: p_event.addParameterToList('ECX_MSGID', p_msgid);
924: p_event.addParameterToList('ECX_MESSAGE_TYPE', 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 963: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',

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

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 975: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
979: if(ecx_utils.g_ret_code = 1 )

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 1016: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

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

Line 1018: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

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));
1020: end if;
1021: end;
1022:

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 1024: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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);
1028: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

Line 1026: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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);
1028: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1029: 'Return Code: '|| ecx_utils.i_ret_code);
1030: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

Line 1028: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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);
1028: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1029: 'Return Code: '|| ecx_utils.i_ret_code);
1030: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1031: 'Error Message: '|| ecx_utils.i_errbuf);
1032: end if;

Line 1030: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

1026: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1027: 'Error Type: '|| ecx_utils.error_type);
1028: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1029: 'Return Code: '|| ecx_utils.i_ret_code);
1030: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1031: 'Error Message: '|| ecx_utils.i_errbuf);
1032: end if;
1033: raise;
1034: end processTPMessage;

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 1106: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
1110: exception

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 1113: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,

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',
1117: 'p_queue_name', p_queue_name);

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 1277: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.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;
1280:
1281: -- validate the inbound request

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 1311: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
1315: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1313: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
1315: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1316: 'l_std_type: ' || l_std_type);
1317: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1315: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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);
1315: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1316: 'l_std_type: ' || l_std_type);
1317: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1318: 'l_std_code: ' || l_std_code);
1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1317: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1313: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1314: 'l_tran_subtype: ' || l_tran_subtype);
1315: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1316: 'l_std_type: ' || l_std_type);
1317: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1318: 'l_std_code: ' || l_std_code);
1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1320: 'l_party_site_id: ' || l_party_site_id);
1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1315: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1316: 'l_std_type: ' || l_std_type);
1317: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1318: 'l_std_code: ' || l_std_code);
1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1320: 'l_party_site_id: ' || l_party_site_id);
1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1322: 'l_tp_user: ' || l_tp_user);
1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1317: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1318: 'l_std_code: ' || l_std_code);
1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1320: 'l_party_site_id: ' || l_party_site_id);
1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1322: 'l_tp_user: ' || l_tp_user);
1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1324: 'l_trigger_id: ' || l_trigger_id);
1325: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1320: 'l_party_site_id: ' || l_party_site_id);
1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1322: 'l_tp_user: ' || l_tp_user);
1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1324: 'l_trigger_id: ' || l_trigger_id);
1325: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1326: 'l_process_id: ' || l_process_id);
1327: end if;

Line 1325: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1322: 'l_tp_user: ' || l_tp_user);
1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1324: 'l_trigger_id: ' || l_trigger_id);
1325: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1326: 'l_process_id: ' || l_process_id);
1327: end if;
1328:
1329: is_valid := ecx_trading_partner_pvt.validateTPUser(

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 1344: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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));
1347: end if;
1348: raise rule_exception;

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 1353: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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;
1356:
1357: -- retrieve the event parameters and perform the logging.

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 1375: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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,
1378: 'l_protocol_type: ' || l_protocol_type);
1379: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1377: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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,
1378: 'l_protocol_type: ' || l_protocol_type);
1379: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1380: 'l_protocol_address: ' || l_protocol_address);
1381: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1379: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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,
1378: 'l_protocol_type: ' || l_protocol_type);
1379: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1380: 'l_protocol_address: ' || l_protocol_address);
1381: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1382: 'l_attribute1: ' || l_attribute1);
1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1381: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1377: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1378: 'l_protocol_type: ' || l_protocol_type);
1379: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1380: 'l_protocol_address: ' || l_protocol_address);
1381: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1382: 'l_attribute1: ' || l_attribute1);
1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1384: 'l_attribute2: ' || l_attribute2);
1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1379: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1380: 'l_protocol_address: ' || l_protocol_address);
1381: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1382: 'l_attribute1: ' || l_attribute1);
1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1384: 'l_attribute2: ' || l_attribute2);
1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1386: 'l_attribute3: ' || l_attribute3);
1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1381: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1382: 'l_attribute1: ' || l_attribute1);
1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1384: 'l_attribute2: ' || l_attribute2);
1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1386: 'l_attribute3: ' || l_attribute3);
1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1388: 'l_attribute4: ' || l_attribute4);
1389: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

Line 1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1384: 'l_attribute2: ' || l_attribute2);
1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1386: 'l_attribute3: ' || l_attribute3);
1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1388: 'l_attribute4: ' || l_attribute4);
1389: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1390: 'l_attribute5: ' || l_attribute5);
1391: end if;

Line 1389: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1386: 'l_attribute3: ' || l_attribute3);
1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1388: 'l_attribute4: ' || l_attribute4);
1389: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1390: 'l_attribute5: ' || l_attribute5);
1391: end if;
1392:
1393: -- this to make sure that the payload has something before

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 1400: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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;
1403: return 'ERROR';
1404: 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 1436: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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));
1439: end if;
1440: raise rule_exception;

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 1538: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',

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:
1542: -- initialize declared variables

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 1560: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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:
1564: -- The first time to call the rule function should have

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 1617: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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;
1620: end if;
1621:

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 1732: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

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 1739: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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
1743: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) 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 1744: 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;
1748: end if;

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 1760: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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|| ',' ||
1764: 'Location Code'||l_party_site_id||

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 1778: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Validated TP Setup.');

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.
1782: -- Hence the queue name should be null.

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 1803: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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;
1807: processTPMessage(l_msgid, l_debug_mode, l_process_id);

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 1839: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

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 1865: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Error.');

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;
1869: end if;

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 1872: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Success.');

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:
1876: exception

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'));

Line 1926: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',

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'));
1930: