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

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

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

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

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

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

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

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

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

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

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

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

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

1022: when others then
1023: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
1024: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
1025: 'Error While Saving the Log: ' ||p_msgid);
1026: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
1027: 'Logging Error Message: '|| substr(SQLERRM,1,200));
1028: end if;
1029: end;
1030:

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

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

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

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

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

1030:
1031: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level) then
1032: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1033: 'Exception in inbound processing.');
1034: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1035: 'Error Type: '|| ecx_utils.error_type);
1036: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1037: 'Return Code: '|| ecx_utils.i_ret_code);
1038: wf_log_pkg.string(wf_log_pkg.level_error, l_module,

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

1032: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1033: 'Exception in inbound processing.');
1034: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1035: 'Error Type: '|| ecx_utils.error_type);
1036: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1037: 'Return Code: '|| ecx_utils.i_ret_code);
1038: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1039: 'Error Message: '|| ecx_utils.i_errbuf);
1040: end if;

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

1034: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1035: 'Error Type: '|| ecx_utils.error_type);
1036: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1037: 'Return Code: '|| ecx_utils.i_ret_code);
1038: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1039: 'Error Message: '|| ecx_utils.i_errbuf);
1040: end if;
1041: raise;
1042: end processTPMessage;

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

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

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

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

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

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

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

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

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

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

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

1281:
1282: l_module := 'ecx.plsql.ecx_rule.TPPreProcessing';
1283: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level)
1284: then
1285: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
1286: 'Starting TPPreProcessing rule function.');
1287: end if;
1288:
1289: -- validate the inbound request

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

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

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

1315: l_party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
1316: l_tp_user := p_event.getValueForParameter('ECX_TP_USER');
1317:
1318: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1320: 'l_tran_type: ' || l_tran_type);
1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1322: 'l_tran_subtype: ' || l_tran_subtype);
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:
1318: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1319: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1320: 'l_tran_type: ' || l_tran_type);
1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1322: 'l_tran_subtype: ' || l_tran_subtype);
1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1324: 'l_std_type: ' || l_std_type);
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_tran_type: ' || l_tran_type);
1321: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1322: 'l_tran_subtype: ' || l_tran_subtype);
1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1324: 'l_std_type: ' || l_std_type);
1325: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1326: 'l_std_code: ' || l_std_code);
1327: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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_tran_subtype: ' || l_tran_subtype);
1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1324: 'l_std_type: ' || l_std_type);
1325: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1326: 'l_std_code: ' || l_std_code);
1327: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1328: 'l_party_site_id: ' || l_party_site_id);
1329: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

1323: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1324: 'l_std_type: ' || l_std_type);
1325: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1326: 'l_std_code: ' || l_std_code);
1327: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1328: 'l_party_site_id: ' || l_party_site_id);
1329: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1330: 'l_tp_user: ' || l_tp_user);
1331: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

1325: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1326: 'l_std_code: ' || l_std_code);
1327: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1328: 'l_party_site_id: ' || l_party_site_id);
1329: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1330: 'l_tp_user: ' || l_tp_user);
1331: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1332: 'l_trigger_id: ' || l_trigger_id);
1333: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

1327: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1328: 'l_party_site_id: ' || l_party_site_id);
1329: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1330: 'l_tp_user: ' || l_tp_user);
1331: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1332: 'l_trigger_id: ' || l_trigger_id);
1333: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1334: 'l_process_id: ' || l_process_id);
1335: end if;

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

1329: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1330: 'l_tp_user: ' || l_tp_user);
1331: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1332: 'l_trigger_id: ' || l_trigger_id);
1333: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1334: 'l_process_id: ' || l_process_id);
1335: end if;
1336:
1337: is_valid := ecx_trading_partner_pvt.validateTPUser(

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

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

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

1348: if(is_valid = 'N')
1349: then
1350: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1351: then
1352: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1353: ecx_debug.getMessage(ecx_utils.i_errbuf,
1354: ecx_utils.i_errparams));
1355: end if;
1356: raise rule_exception;

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

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

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

1357: end if;
1358:
1359: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)
1360: then
1361: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1362: 'Validated User and TP Setup.');
1363: end if;
1364:
1365: -- retrieve the event parameters and perform the logging.

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

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

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

1379: l_attribute5 := p_event.getValueForParameter('ECX_ATTRIBUTE5');
1380:
1381: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)
1382: then
1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1384: 'l_party_type: ' || l_party_type);
1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1386: 'l_protocol_type: ' || l_protocol_type);
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: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level)
1382: then
1383: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1384: 'l_party_type: ' || l_party_type);
1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1386: 'l_protocol_type: ' || l_protocol_type);
1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1388: 'l_protocol_address: ' || l_protocol_address);
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_party_type: ' || l_party_type);
1385: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1386: 'l_protocol_type: ' || l_protocol_type);
1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1388: 'l_protocol_address: ' || l_protocol_address);
1389: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1390: 'l_attribute1: ' || l_attribute1);
1391: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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_protocol_type: ' || l_protocol_type);
1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1388: 'l_protocol_address: ' || l_protocol_address);
1389: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1390: 'l_attribute1: ' || l_attribute1);
1391: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1392: 'l_attribute2: ' || l_attribute2);
1393: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

1387: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1388: 'l_protocol_address: ' || l_protocol_address);
1389: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1390: 'l_attribute1: ' || l_attribute1);
1391: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1392: 'l_attribute2: ' || l_attribute2);
1393: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1394: 'l_attribute3: ' || l_attribute3);
1395: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

1389: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1390: 'l_attribute1: ' || l_attribute1);
1391: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1392: 'l_attribute2: ' || l_attribute2);
1393: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1394: 'l_attribute3: ' || l_attribute3);
1395: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1396: 'l_attribute4: ' || l_attribute4);
1397: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

1391: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1392: 'l_attribute2: ' || l_attribute2);
1393: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1394: 'l_attribute3: ' || l_attribute3);
1395: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1396: 'l_attribute4: ' || l_attribute4);
1397: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1398: 'l_attribute5: ' || l_attribute5);
1399: end if;

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

1393: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1394: 'l_attribute3: ' || l_attribute3);
1395: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1396: 'l_attribute4: ' || l_attribute4);
1397: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1398: 'l_attribute5: ' || l_attribute5);
1399: end if;
1400:
1401: -- this to make sure that the payload has something before

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

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

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

1404: if (l_payload is null) or
1405: (dbms_lob.getlength(l_payload) = 0) then
1406: if (wf_log_pkg.level_error >= fnd_log.g_current_runtime_level)
1407: then
1408: wf_log_pkg.string(wf_log_pkg.level_error, l_module,
1409: 'Payload is null');
1410: end if;
1411: return 'ERROR';
1412: end if;

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

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

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

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

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

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

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

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

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

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

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

1564: l_party_site_id := p_event.getValueForParameter('ECX_PARTY_SITE_ID');
1565: l_process_id := p_event.getValueForParameter('ECX_PROCESS_ID');
1566:
1567: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
1568: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
1569: 'l_process_id: ' || l_process_id);
1570: end if;
1571:
1572: -- The first time to call the rule function should have

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1786: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Validated TP Setup.');

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

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

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

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

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

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

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

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

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

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

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

Line 1873: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Error.');

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

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

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

Line 1880: wf_log_pkg.string(wf_log_pkg.level_statement, l_module, 'Finished with Success.');

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

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

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

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

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