APPS.ECX_INBOUND_ENGINE_QH dependencies on WF_LOG_PKG

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

26: v_log_module_appl varchar2(240);
27: v_log_module_site varchar2(240);
28: begin
29: l_module := 'ecx.plsql.ecx_inbound_engine_qh';
30: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
31: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module || '.begin',
32: 'in dequeue');
33: end if;
34:

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

27: v_log_module_site varchar2(240);
28: begin
29: l_module := 'ecx.plsql.ecx_inbound_engine_qh';
30: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
31: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module || '.begin',
32: 'in dequeue');
33: end if;
34:
35: select upper(queue_name), upper(name), system_guid

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

45: x_from_agt := wf_agent_t(x_agent_name, x_sys_name);
46: x_to_agt := wf_agent_t(x_agent_name, x_sys_name);
47:
48: BEGIN
49: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
50: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
51: 'p_agent_guid' ||hextoraw(p_agent_guid));
52: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
53: 'System: ' || x_sys_name);

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

46: x_to_agt := wf_agent_t(x_agent_name, x_sys_name);
47:
48: BEGIN
49: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
50: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
51: 'p_agent_guid' ||hextoraw(p_agent_guid));
52: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
53: 'System: ' || x_sys_name);
54: end if;

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

48: BEGIN
49: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
50: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
51: 'p_agent_guid' ||hextoraw(p_agent_guid));
52: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
53: 'System: ' || x_sys_name);
54: end if;
55:
56: v_dequeueoptions.wait := 1;

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

106: p_event.from_agent := x_from_agt ;
107: p_event.to_agent := x_to_agt;
108: p_event.send_date := sysdate;
109:
110: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
111: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
112: 'After Dequeue. Message Id: ' || x_msgid);
113: end if;
114:

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

107: p_event.to_agent := x_to_agt;
108: p_event.send_date := sysdate;
109:
110: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
111: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
112: 'After Dequeue. Message Id: ' || x_msgid);
113: end if;
114:
115: EXCEPTION

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

113: end if;
114:
115: EXCEPTION
116: when no_messages then
117: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
118: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
119: 'No more messages in dequeue.');
120: end if;
121: p_event := NULL;

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

114:
115: EXCEPTION
116: when no_messages then
117: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
118: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
119: 'No more messages in dequeue.');
120: end if;
121: p_event := NULL;
122: return;

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

123: END;
124: exception
125: when others then
126: rollback to before_dequeue;
127: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
128: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
129: substr(sqlerrm, 1,2000));
130: end if;
131: Wf_Core.Context('Wf_Event_ECXMSG_QH', 'Dequeue', x_queue_name);

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

124: exception
125: when others then
126: rollback to before_dequeue;
127: if (wf_log_pkg.level_unexpected >= fnd_log.g_current_runtime_level) then
128: wf_log_pkg.string(wf_log_pkg.level_unexpected, l_module,
129: substr(sqlerrm, 1,2000));
130: end if;
131: Wf_Core.Context('Wf_Event_ECXMSG_QH', 'Dequeue', x_queue_name);
132: raise;

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

156:
157:
158: begin
159: l_module := 'ecx.plsql.ecx_inbound_engine_qh.enqueue';
160: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
161: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module || '.begin',
162: 'in enqueue');
163: end if;
164:

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

157:
158: begin
159: l_module := 'ecx.plsql.ecx_inbound_engine_qh.enqueue';
160: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
161: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module || '.begin',
162: 'in enqueue');
163: end if;
164:
165: -- Determine the out queue

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

189: fetch c_ecx_trigger_id into x_trigger_id;
190: close c_ecx_trigger_id;
191: end if;
192:
193: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
194: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
195: 'Trigger Id: ' || x_trigger_id);
196: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
197: 'Message Id: ' || v_message.msgid);

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

190: close c_ecx_trigger_id;
191: end if;
192:
193: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
194: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
195: 'Trigger Id: ' || x_trigger_id);
196: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
197: 'Message Id: ' || v_message.msgid);
198: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

192:
193: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
194: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
195: 'Trigger Id: ' || x_trigger_id);
196: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
197: 'Message Id: ' || v_message.msgid);
198: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
199: 'Debug Mode: ' || v_message.debug_mode);
200: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,

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

194: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
195: 'Trigger Id: ' || x_trigger_id);
196: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
197: 'Message Id: ' || v_message.msgid);
198: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
199: 'Debug Mode: ' || v_message.debug_mode);
200: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
201: 'Enqueuing on Queue: ' || x_out_queue);
202: end if;

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

196: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
197: 'Message Id: ' || v_message.msgid);
198: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
199: 'Debug Mode: ' || v_message.debug_mode);
200: wf_log_pkg.string(wf_log_pkg.level_statement, l_module,
201: 'Enqueuing on Queue: ' || x_out_queue);
202: end if;
203:
204: /*

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

240: );
241:
242: end;
243:
244: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
245: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module || '.end',
246: 'finished calling dbms_aq.enqueue');
247: end if;
248:

Line 245: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module || '.end',

241:
242: end;
243:
244: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
245: wf_log_pkg.string(wf_log_pkg.level_procedure, l_module || '.end',
246: 'finished calling dbms_aq.enqueue');
247: end if;
248:
249: exception