DBA Data[Home] [Help]

APPS.WF_EVENT_QH dependencies on FND_LOG

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

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

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

52:
53: -- Get the dedicated components correlation Id list
54: l_corrId_list := WF_CORE.getDedicatedComponentsCorrIds(x_agent_name, wf_event.account_name);
55:
56: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
57: wf_log_pkg.string(wf_log_pkg.level_statement,
58: 'wf.plsql.WF_EVENT_QH.dequeue.corr',
59: 'The dedicated components correlation ids list is:' || l_corrId_list);
60: end if;

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

67: end if;
68:
69: end if;
70:
71: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
72: if (wf_event.g_correlation is not null) then
73: wf_log_pkg.string(wf_log_pkg.level_procedure,
74: 'wf.plsql.WF_EVENT_QH.dequeue.corrid',
75: 'Dequeuing with Correlation:'|| x_dequeue_options.correlation);

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

107:
108: -- wf_event.navigation := dbms_aq.next_message;
109: EXCEPTION
110: when no_messages then
111: if (wf_log_pkg.level_event >= fnd_log.g_current_runtime_level) then
112: wf_log_pkg.string(wf_log_pkg.level_event,
113: 'wf.plsql.WF_EVENT_QH.dequeue.queue_empty',
114: 'No more messages in dequeue.');
115: end if;

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

135: END;
136:
137: -- Set the Receive Date
138: p_event.SetReceiveDate(sysdate);
139: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
140: wf_log_pkg.string(wf_log_pkg.level_procedure,
141: 'wf.plsql.WF_EVENT_QH.dequeue.End',
142: 'Finished');
143: end if;

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

222: /*
223: ** Set the Delay if required, also used for Deferred Agent
224: */
225: if (p_event.Send_Date > sysdate) then
226: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
227: wf_log_pkg.string(wf_log_pkg.level_statement,
228: 'wf.plsql.WF_EVENT_QH.enqueue.delay',
229: 'Delay Detected');
230: end if;

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

230: end if;
231:
232: delay := (p_event.Send_Date - sysdate) *24*60*60;
233:
234: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
235: wf_log_pkg.string(wf_log_pkg.level_statement,
236: 'wf.plsql.WF_EVENT_QH.enqueue.delay_time',
237: 'Delay ='||to_char(delay));
238: end if;

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

281: else
282: x_message_properties.correlation := l_q_correlation_id;
283: end if;
284: END IF;
285: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
286: wf_log_pkg.string(wf_log_pkg.level_statement,
287: 'wf.plsql.WF_EVENT_QH.enqueue.dbms_aq',
288: 'calling dbms_aq.enqueue');
289: end if;

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

297:
298: -- Storing the msgid.
299: WF_EVENT.g_msgid := x_msgid;
300:
301: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
302: wf_log_pkg.string(wf_log_pkg.level_procedure,
303: 'wf.plsql.WF_EVENT_QH.enqueue.End',
304: 'finished calling dbms_aq.enqueue');
305: end if;