DBA Data[Home] [Help]

APPS.XNB_QUEUE_HANDLERS_PKG dependencies on XNB_DEBUG

Line 45: xnb_debug.log('ecx_to_jms','Begin of ecx_to_jms Handler');

41: --------------------------------------------------------------------------------------
42: -- DEQUEUE FROM XML GATEWAY OUTBOUND QUEUE
43: --
44: -------------------------------------------------------------------------------------
45: xnb_debug.log('ecx_to_jms','Begin of ecx_to_jms Handler');
46: l_more_messages := TRUE;
47: l_ecx_dequeue_options.wait := 1;
48:
49: WHILE (l_more_messages) LOOP

Line 62: xnb_debug.log('ecx_to_jms','After DEqueue from ECX_outbound');

58: ,message_properties => l_ecx_message_properties
59: ,payload => l_ecx_message
60: ,msgid => l_ecx_message_handle);
61: COMMIT;
62: xnb_debug.log('ecx_to_jms','After DEqueue from ECX_outbound');
63: --------------------------------------------------------------------------------------
64: -- TRANSFORM FROM SYSTEM.ECXMSG TO SYS.AQ$_JMS_TEXT_MESSAGE
65: -- Create JMS text message and set properties
66: --

Line 133: xnb_debug.log('ecx_to_jms','After Enqueue into XNB_JMS_OUTBOUND');

129: ,msgid => l_jms_message_handle);
130:
131: COMMIT;
132:
133: xnb_debug.log('ecx_to_jms','After Enqueue into XNB_JMS_OUTBOUND');
134:
135: EXCEPTION
136:
137: WHEN NO_NEW_MESSAGES THEN

Line 138: xnb_debug.log('XNB_QUEUE_HANDLERS_PKG.ecx_to_jms_handler','No New Message in ECX_OUTBOUND');

134:
135: EXCEPTION
136:
137: WHEN NO_NEW_MESSAGES THEN
138: xnb_debug.log('XNB_QUEUE_HANDLERS_PKG.ecx_to_jms_handler','No New Message in ECX_OUTBOUND');
139: l_more_messages := FALSE;
140: END;
141:
142: END LOOP;

Line 147: xnb_debug.log('XNB_QUEUE_HANDLERS_PKG.ecx_to_jms_handler',l_error_msg);

143:
144: EXCEPTION
145: WHEN OTHERS THEN
146: l_error_msg := SQLERRM;
147: xnb_debug.log('XNB_QUEUE_HANDLERS_PKG.ecx_to_jms_handler',l_error_msg);
148:
149: END ecx_to_jms_handler;
150:
151:

Line 191: xnb_debug.log('jms_to_ecx','Begin of jms_to_ecx_handler Handler');

187: --
188: -------------------------------------------------------------------------------------
189: l_more_messages := TRUE;
190: l_jms_dequeue_options.wait := 1;
191: xnb_debug.log('jms_to_ecx','Begin of jms_to_ecx_handler Handler');
192:
193: WHILE (l_more_messages) LOOP
194:
195: BEGIN

Line 208: xnb_debug.log('jms_to_ecx','After Dequeu from inbound');

204: ,message_properties => l_jms_message_properties
205: ,payload => l_jms_message
206: ,msgid => l_jms_message_handle);
207: COMMIT;
208: xnb_debug.log('jms_to_ecx','After Dequeu from inbound');
209:
210: --------------------------------------------------------------------------------------
211: -- TRANSFORM FROM SYS.AQ$_JMS_TEXT_MESSAGE TO SYSTEM.ECXMSG
212: -- Create ECX text message and set Headers

Line 231: xnb_debug.log('jms_to_ecx',' AFTER REtreivING Payload'||l_payload_length);

227: -------------------------------------------------------------------------------------
228:
229: l_payload_length := l_jms_message.TEXT_LEN;
230:
231: xnb_debug.log('jms_to_ecx',' AFTER REtreivING Payload'||l_payload_length);
232:
233: -------------------------------------------------------------------------------------
234: -- If the length of the message is more than 4000 it has to be represented
235: -- as a CLOB in the JMS message otherwise as a VARCHAR

Line 241: xnb_debug.log('jms_to_ecx','Inside If payload > 4000');

237: -------------------------------------------------------------------------------------
238:
239: IF (l_payload_length) > 4000 THEN
240:
241: xnb_debug.log('jms_to_ecx','Inside If payload > 4000');
242: l_ecx_message := SYSTEM.ECXMSG( l_jms_message.GET_STRING_PROPERTY(g_ecx_message_type), --MESSAGE_TYPE
243: l_jms_message.GET_STRING_PROPERTY(g_ecx_message_standard), --MESSAGE_STAND
244: l_jms_message.GET_STRING_PROPERTY(g_ecx_transaction_type), --TRANSACTION_T
245: l_jms_message.GET_STRING_PROPERTY(g_ecx_transaction_subtype), --TRANSACTION_S

Line 264: xnb_debug.log('jms_to_ecx','Inside Else');

260:
261:
262: ELSE
263:
264: xnb_debug.log('jms_to_ecx','Inside Else');
265:
266:
267: l_ecx_message := SYSTEM.ECXMSG( l_jms_message.GET_STRING_PROPERTY(g_ecx_message_type), --MESSAGE_TYPE
268: l_jms_message.GET_STRING_PROPERTY(g_ecx_message_standard), --MESSAGE_STAND

Line 289: xnb_debug.log('jms_to_ecx','Before Enqueue');

285:
286:
287: END IF;
288:
289: xnb_debug.log('jms_to_ecx','Before Enqueue');
290: ------------------------------------------------------------
291: -- ENQUEUE ON ECX INBOUND QUEUE
292: --
293: ------------------------------------------------------------

Line 301: xnb_debug.log('jms_to_ecx','After Enqueue');

297: ,message_properties => l_ecx_message_properties
298: ,payload => l_ecx_message
299: ,msgid => l_ecx_message_handle);
300:
301: xnb_debug.log('jms_to_ecx','After Enqueue');
302:
303: COMMIT;
304:
305: EXCEPTION

Line 308: xnb_debug.log('XNB_QUEUE_HANDLERS_PKG.jms_to_ecx_handler','No New Message in XNB_JMS_INBOUND');

304:
305: EXCEPTION
306:
307: WHEN NO_NEW_MESSAGES THEN
308: xnb_debug.log('XNB_QUEUE_HANDLERS_PKG.jms_to_ecx_handler','No New Message in XNB_JMS_INBOUND');
309: l_more_messages := FALSE;
310: END;
311:
312: END LOOP;

Line 317: xnb_debug.log('XNB_QUEUE_HANDLERS_PKG.jms_to_ecx_handler',l_error_msg);

313:
314: EXCEPTION
315: WHEN OTHERS THEN
316: l_error_msg := SQLERRM;
317: xnb_debug.log('XNB_QUEUE_HANDLERS_PKG.jms_to_ecx_handler',l_error_msg);
318:
319: END jms_to_ecx_handler;
320:
321: END XNB_QUEUE_HANDLERS_PKG;