DBA Data[Home] [Help]

APPS.WF_ERROR_QH dependencies on FND_LOG

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

19: into x_queue_name, x_agent_name
20: from wf_agents
21: where guid = p_agent_guid;
22:
23: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
24: wf_log_pkg.string(wf_log_pkg.level_procedure,
25: 'wf.plsql.WF_ERROR_QH.dequeue.Begin',
26: 'Dequeuing '||x_queue_name||' on '||x_agent_name);
27: end if;

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

39: x_dequeue_options.correlation := wf_event.g_correlation;
40: end if;
41: end if;
42:
43: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
44: if (wf_event.g_correlation is not null) then
45: wf_log_pkg.string(wf_log_pkg.level_procedure,
46: 'wf.plsql.WF_ERROR_QH.dequeue.corrid',
47: 'Dequeuing with Correlation ' || x_dequeue_options.correlation);

Line 69: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then

65: wf_event.navigation := dbms_aq.next_message;
66: EXCEPTION
67: when no_messages then
68:
69: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
70: wf_log_pkg.string(wf_log_pkg.level_event,
71: 'wf.plsql.WF_ERROR_QH.dequeue.queue_empty',
72: 'No more messages in dequeue.');
73: end if;

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

130: x_protocol varchar2(30);
131: x_protocol_num number := 0;
132: begin
133:
134: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
135: wf_log_pkg.string(wf_log_pkg.level_procedure,
136: 'wf.plsql.WF_ERROR_QH.enqueue.Begin',
137: 'Entered Enqueue ');
138: end if;

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

148: where agt.name = x_out_agent_name
149: and sys.name = x_out_system_name
150: and sys.guid = agt.system_guid;
151:
152: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
153: wf_log_pkg.string(wf_log_pkg.level_statement,
154: 'wf.plsql.WF_ERROR_QH.enqueue.Enqueuing',
155: 'Enqueuing on Queue: '||x_out_queue);
156: end if;

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

169: x_message_properties.correlation := wf_event.account_name||
170: ':'||p_event.event_name;
171: end if;
172:
173: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
174: wf_log_pkg.string(wf_log_pkg.level_statement,
175: 'wf.plsql.WF_ERROR_QH.enqueue.dbms_qa',
176: 'calling dbms_aq.enqueue');
177: end if;

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

182: message_properties => x_message_properties,
183: payload => p_event,
184: msgid => x_msgid); /* OUT*/
185:
186: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
187: wf_log_pkg.string(wf_log_pkg.level_statement,
188: 'wf.plsql.WF_ERROR_QH.enqueue.done',
189: 'finished calling dbms_aq.enqueue');
190: end if;