APPS.ECX_OUT_WF_QH dependencies on FND_LOG

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

20: l_module varchar2(2000);
21:
22: begin
23: l_module := 'ecx.plsq.ecx_out_wf_qh.dequeue';
24: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
25: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
26: 'getting queue details');
27: end if;
28:

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

30: into x_queue_name, x_agent_name, x_sys_guid
31: from wf_agents
32: where guid = p_agent_guid;
33:
34: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
35: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
36: 'getting system name');
37: end if;
38:

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

69: p_event.error_subscription := null;
70: p_event.error_message := null;
71: p_event.error_stack := null;
72:
73: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
74: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
75: 'setting message props');
76: end if;
77:

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

92: p_event.AddParameterToList('ATTRIBUTE3', x_ecxmsg.attribute3);
93: p_event.AddParameterToList('ATTRIBUTE4', x_ecxmsg.attribute4);
94: p_event.AddParameterToList('ATTRIBUTE5', x_ecxmsg.attribute5);
95:
96: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
97: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
98: 'setting payload');
99: end if;
100: p_event.setEventData(x_ecxmsg.payload);

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

100: p_event.setEventData(x_ecxmsg.payload);
101:
102: exception
103: when no_messages then
104: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
105: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
106: 'No more messages in dequeue.');
107: end if;
108: ecx_out_wf_qh.navigation := dbms_aq.first_message;

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

138: l_module := 'ecx.plsql.ecx_out_wf_qh.enqueue.create_ecxmsg';
139: -- loop through the parameter list and construct x_ecxmsg object
140: i_param_list := p_event.getParameterList();
141: if (i_param_list is null) then
142: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
143: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
144: 'event object parameter list in empty');
145: end if;
146:

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

208: end if;
209: end loop;
210: end if;
211:
212: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
213: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
214: 'setting payload');
215: end if;
216: x_ecxmsg.payload := p_event.getEventData();

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

255: else
256: x_message_properties.correlation := i_protocol_type;
257: end if;
258:
259: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
260: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
261: 'Correlation id: '|| x_message_properties.correlation);
262: end if;
263:

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

281: if dbms_lob.istemporary(l_out_clob) = 1 then
282: dbms_lob.freetemporary(l_out_clob);
283: end if;
284:
285: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
286: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
287: 'Enqueued Message: ' || x_msgid);
288: end if;
289: exception

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

323: from dual;
324:
325: begin
326: l_module := 'ecx.plsql.ecx_out_wf_qh.enqueue';
327: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
328: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module ||'.begin',
329: 'Enqueue Message');
330: end if;
331:

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

363: -- set msgid
364: ecx_out_wf_qh.msgid := x_msgid;
365: wf_event.g_msgid := x_msgid;
366:
367: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
368: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
369: 'Enqueue Message Successfully');
370: end if;
371:

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

379: exception
380: when others then
381: -- If attr is not already defined, add a runtime attribute
382: -- with this name, then try the set again.
383: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
384: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
385: 'ECX_MSGID_ATTR is not defined!');
386: end if;
387: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then

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

389: wf_engine.AddItemAttr(itemtype => i_item_type,
390: itemkey => i_item_key,
391: aname => 'ECX_MSGID_ATTR',
392: text_value => x_msgid);
393: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
394: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
395: 'Created and set ECX_MSGID_ATTR ');
396: end if;
397: WF_CORE.Clear;