DBA Data[Home] [Help]

APPS.WF_EVENT_QH dependencies on FND_LOG

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

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

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

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

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

80:
81: wf_event.navigation := dbms_aq.next_message;
82: EXCEPTION
83: when no_messages then
84: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
85: wf_log_pkg.string(wf_log_pkg.level_event,
86: 'wf.plsql.WF_EVENT_QH.dequeue.queue_empty',
87: 'No more messages in dequeue.');
88: end if;

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

118: END;
119:
120: -- Set the Receive Date
121: p_event.SetReceiveDate(sysdate);
122: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
123: wf_log_pkg.string(wf_log_pkg.level_procedure,
124: 'wf.plsql.WF_EVENT_QH.dequeue.End',
125: 'Finished');
126: end if;

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

205: /*
206: ** Set the Delay if required, also used for Deferred Agent
207: */
208: if (p_event.Send_Date > sysdate) then
209: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
210: wf_log_pkg.string(wf_log_pkg.level_statement,
211: 'wf.plsql.WF_EVENT_QH.enqueue.delay',
212: 'Delay Detected');
213: end if;

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

213: end if;
214:
215: delay := (p_event.Send_Date - sysdate) *24*60*60;
216:
217: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
218: wf_log_pkg.string(wf_log_pkg.level_statement,
219: 'wf.plsql.WF_EVENT_QH.enqueue.delay_time',
220: 'Delay ='||to_char(delay));
221: end if;

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

264: else
265: x_message_properties.correlation := l_q_correlation_id;
266: end if;
267: END IF;
268: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
269: wf_log_pkg.string(wf_log_pkg.level_statement,
270: 'wf.plsql.WF_EVENT_QH.enqueue.dbms_aq',
271: 'calling dbms_aq.enqueue');
272: end if;

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

280:
281: -- Storing the msgid.
282: WF_EVENT.g_msgid := x_msgid;
283:
284: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
285: wf_log_pkg.string(wf_log_pkg.level_procedure,
286: 'wf.plsql.WF_EVENT_QH.enqueue.End',
287: 'finished calling dbms_aq.enqueue');
288: end if;