68: -- Check if Accessible
69: wf_event_html.isAccessible('AGENTS');
70:
71: -- Set page title
72: htp.htmlOpen;
73: htp.headOpen;
74: htp.p('
75: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
76: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
69: wf_event_html.isAccessible('AGENTS');
70:
71: -- Set page title
72: htp.htmlOpen;
73: htp.headOpen;
74: htp.p('
75: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
76: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
77: htp.headClose;
70:
71: -- Set page title
72: htp.htmlOpen;
73: htp.headOpen;
74: htp.p('
75: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
76: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
77: htp.headClose;
78: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECXMSGQueue
71: -- Set page title
72: htp.htmlOpen;
73: htp.headOpen;
74: htp.p('
75: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
76: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
77: htp.headClose;
78: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECXMSGQueue
79: Message?p_queue_name='||p_queue_name||'&'||'p_type=ECXMSG', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
73: htp.headOpen;
74: htp.p('
75: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
76: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
77: htp.headClose;
78: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECXMSGQueue
79: Message?p_queue_name='||p_queue_name||'&'||'p_type=ECXMSG', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
80: htp.br;
81:
76: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
77: htp.headClose;
78: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECXMSGQueue
79: Message?p_queue_name='||p_queue_name||'&'||'p_type=ECXMSG', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
80: htp.br;
81:
82: IF (admin_mode = 'N') THEN
83: htp.center(htf.bold(l_error_msg));
84: return;
79: Message?p_queue_name='||p_queue_name||'&'||'p_type=ECXMSG', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);
80: htp.br;
81:
82: IF (admin_mode = 'N') THEN
83: htp.center(htf.bold(l_error_msg));
84: return;
85: END IF;
86:
87: -- Column headers
84: return;
85: END IF;
86:
87: -- Column headers
88: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
89: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
90: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
91:
92:
86:
87: -- Column headers
88: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
89: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
90: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
91:
92:
93: htp.tableHeader(cvalue=>''||
94: wf_core.translate('MESSAGETYPE')||'',
89: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
90: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
91:
92:
93: htp.tableHeader(cvalue=>''||
94: wf_core.translate('MESSAGETYPE')||'',
95: calign=>'Center',
96: cattributes=>'id="' ||
97: wf_core.translate('MESSAGETYPE') || '"');
94: wf_core.translate('MESSAGETYPE')||'',
95: calign=>'Center',
96: cattributes=>'id="' ||
97: wf_core.translate('MESSAGETYPE') || '"');
98: htp.tableHeader(cvalue=>''||
99: wf_core.translate('MESSAGESTANDARD')||'',
100: calign=>'Center',
101: cattributes=>'id="' ||
102: wf_core.translate('MESSAGESTANDARD') || '"');
99: wf_core.translate('MESSAGESTANDARD')||'',
100: calign=>'Center',
101: cattributes=>'id="' ||
102: wf_core.translate('MESSAGESTANDARD') || '"');
103: htp.tableHeader(cvalue=>''||
104: wf_core.translate('TRANSACTIONTYPE')||'',
105: calign=>'Center',
106: cattributes=>'id="' ||
107: wf_core.translate('TRANSACTIONTYPE') || '"');
104: wf_core.translate('TRANSACTIONTYPE')||'',
105: calign=>'Center',
106: cattributes=>'id="' ||
107: wf_core.translate('TRANSACTIONTYPE') || '"');
108: htp.tableHeader(cvalue=>''||
109: wf_core.translate('TRANSACTIONSUBTYPE')||'',
110: calign=>'Center',
111: cattributes=>'id="' ||
112: wf_core.translate('TRANSACTIONSUBTYPE') || '"');
109: wf_core.translate('TRANSACTIONSUBTYPE')||'',
110: calign=>'Center',
111: cattributes=>'id="' ||
112: wf_core.translate('TRANSACTIONSUBTYPE') || '"');
113: htp.tableHeader(cvalue=>''||
114: wf_core.translate('DOCUMENTNUMBER')||'',
115: calign=>'Center',
116: cattributes=>'id="' ||
117: wf_core.translate('DOCUMENTNUMBER') || '"');
114: wf_core.translate('DOCUMENTNUMBER')||'',
115: calign=>'Center',
116: cattributes=>'id="' ||
117: wf_core.translate('DOCUMENTNUMBER') || '"');
118: htp.tableHeader(cvalue=>''||
119: wf_core.translate('PARTYID')||'',
120: calign=>'Center',
121: cattributes=>'id="' ||
122: wf_core.translate('PARTYID') || '"');
119: wf_core.translate('PARTYID')||'',
120: calign=>'Center',
121: cattributes=>'id="' ||
122: wf_core.translate('PARTYID') || '"');
123: htp.tableHeader(cvalue=>''||
124: wf_core.translate('PARTYSITEID')||'',
125: calign=>'Center',
126: cattributes=>'id="' ||
127: wf_core.translate('PARTYSITEID') || '"');
124: wf_core.translate('PARTYSITEID')||'',
125: calign=>'Center',
126: cattributes=>'id="' ||
127: wf_core.translate('PARTYSITEID') || '"');
128: htp.tableHeader(cvalue=>''||
129: wf_core.translate('PARTYTYPE')||'',
130: calign=>'Center',
131: cattributes=>'id="' ||
132: wf_core.translate('PARTYTYPE') || '"');
129: wf_core.translate('PARTYTYPE')||'',
130: calign=>'Center',
131: cattributes=>'id="' ||
132: wf_core.translate('PARTYTYPE') || '"');
133: htp.tableHeader(cvalue=>''||
134: wf_core.translate('PROTOCOLTYPE')||'',
135: calign=>'Center',
136: cattributes=>'id="' ||
137: wf_core.translate('PROTOCOLTYPE') || '"');
134: wf_core.translate('PROTOCOLTYPE')||'',
135: calign=>'Center',
136: cattributes=>'id="' ||
137: wf_core.translate('PROTOCOLTYPE') || '"');
138: htp.tableHeader(cvalue=>''||
139: wf_core.translate('PROTOCOLADDRESS')||'',
140: calign=>'Center',
141: cattributes=>'id="' ||
142: wf_core.translate('PROTOCOLADDRESS') || '"');
139: wf_core.translate('PROTOCOLADDRESS')||'',
140: calign=>'Center',
141: cattributes=>'id="' ||
142: wf_core.translate('PROTOCOLADDRESS') || '"');
143: htp.tableHeader(cvalue=>''||
144: wf_core.translate('ATTRIBUTE1')||'',
145: calign=>'Center',
146: cattributes=>'id="' ||
147: wf_core.translate('ATTRIBUTE1') || '"');
144: wf_core.translate('ATTRIBUTE1')||'',
145: calign=>'Center',
146: cattributes=>'id="' ||
147: wf_core.translate('ATTRIBUTE1') || '"');
148: htp.tableHeader(cvalue=>''||
149: wf_core.translate('ATTRIBUTE2')||'',
150: calign=>'Center',
151: cattributes=>'id="' ||
152: wf_core.translate('ATTRIBUTE2') || '"');
149: wf_core.translate('ATTRIBUTE2')||'',
150: calign=>'Center',
151: cattributes=>'id="' ||
152: wf_core.translate('ATTRIBUTE2') || '"');
153: htp.tableHeader(cvalue=>''||
154: wf_core.translate('ATTRIBUTE3')||'',
155: calign=>'Center',
156: cattributes=>'id="' ||
157: wf_core.translate('ATTRIBUTE3') || '"');
154: wf_core.translate('ATTRIBUTE3')||'',
155: calign=>'Center',
156: cattributes=>'id="' ||
157: wf_core.translate('ATTRIBUTE3') || '"');
158: htp.tableHeader(cvalue=>''||
159: wf_core.translate('ATTRIBUTE4')||'',
160: calign=>'Center',
161: cattributes=>'id="' ||
162: wf_core.translate('ATTRIBUTE4') || '"');
159: wf_core.translate('ATTRIBUTE4')||'',
160: calign=>'Center',
161: cattributes=>'id="' ||
162: wf_core.translate('ATTRIBUTE4') || '"');
163: htp.tableHeader(cvalue=>''||
164: wf_core.translate('ATTRIBUTE5')||'',
165: calign=>'Center',
166: cattributes=>'id="' ||
167: wf_core.translate('ATTRIBUTE5') || '"');
164: wf_core.translate('ATTRIBUTE5')||'',
165: calign=>'Center',
166: cattributes=>'id="' ||
167: wf_core.translate('ATTRIBUTE5') || '"');
168: htp.tableHeader(cvalue=>''||
169: wf_core.translate('MESSAGESTATE')||'',
170: calign=>'Center',
171: cattributes=>'id="' ||
172: wf_core.translate('MESSAGESTATE') || '"');
169: wf_core.translate('MESSAGESTATE')||'',
170: calign=>'Center',
171: cattributes=>'id="' ||
172: wf_core.translate('MESSAGESTATE') || '"');
173: htp.tableHeader(cvalue=>''||
174: wf_core.translate('XMLEVENTDATA')||'',
175: calign=>'Center',
176: cattributes=>'id="' ||
177: wf_core.translate('XMLEVENTDATA') || '"');
175: calign=>'Center',
176: cattributes=>'id="' ||
177: wf_core.translate('XMLEVENTDATA') || '"');
178:
179: htp.tableHeader(cvalue=>''||
180: wf_core.translate('TXTEVENTDATA')||'',
181: calign=>'Center',
182: cattributes=>'id="' ||
183: wf_core.translate('TXTEVENTDATA') || '"');
180: wf_core.translate('TXTEVENTDATA')||'',
181: calign=>'Center',
182: cattributes=>'id="' ||
183: wf_core.translate('TXTEVENTDATA') || '"');
184: htp.tableRowClose;
185: htp.tableRowOpen;
186: htp.tableRowClose;
187:
188: -- Determine the Queue Table based on the Queue Name
181: calign=>'Center',
182: cattributes=>'id="' ||
183: wf_core.translate('TXTEVENTDATA') || '"');
184: htp.tableRowClose;
185: htp.tableRowOpen;
186: htp.tableRowClose;
187:
188: -- Determine the Queue Table based on the Queue Name
189: SELECT queue_table INTO l_qtable
182: cattributes=>'id="' ||
183: wf_core.translate('TXTEVENTDATA') || '"');
184: htp.tableRowClose;
185: htp.tableRowOpen;
186: htp.tableRowClose;
187:
188: -- Determine the Queue Table based on the Queue Name
189: SELECT queue_table INTO l_qtable
190: FROM all_queues
261: OR l_message.document_number IS NULL )
262: AND ( upper(l_message.party_site_id) LIKE l_likepartysiteid
263: OR l_message.party_site_id IS NULL ) THEN
264:
265: htp.tableRowOpen(null, 'TOP');
266:
267: htp.p('');
268:
269: if l_message.message_type is not null then
263: OR l_message.party_site_id IS NULL ) THEN
264:
265: htp.tableRowOpen(null, 'TOP');
266:
267: htp.p('');
268:
269: if l_message.message_type is not null then
270: htp.tableData(l_message.message_type, 'left', cattributes=>'headers="' ||
271: wf_core.translate('MESSAGETYPE') || '"');
266:
267: htp.p('');
268:
269: if l_message.message_type is not null then
270: htp.tableData(l_message.message_type, 'left', cattributes=>'headers="' ||
271: wf_core.translate('MESSAGETYPE') || '"');
272: else
273: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
274: end if;
269: if l_message.message_type is not null then
270: htp.tableData(l_message.message_type, 'left', cattributes=>'headers="' ||
271: wf_core.translate('MESSAGETYPE') || '"');
272: else
273: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
274: end if;
275:
276: if l_message.message_standard is not null then
277: htp.tableData(l_message.message_standard, 'left', cattributes=>'headers="'
273: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
274: end if;
275:
276: if l_message.message_standard is not null then
277: htp.tableData(l_message.message_standard, 'left', cattributes=>'headers="'
278: ||
279: wf_core.translate('MESSAGESTANDARD') || '"');
280: else
281: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
277: htp.tableData(l_message.message_standard, 'left', cattributes=>'headers="'
278: ||
279: wf_core.translate('MESSAGESTANDARD') || '"');
280: else
281: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
282: end if;
283:
284: if l_message.transaction_type is not null then
285: htp.tableData(l_message.transaction_type, 'left', cattributes=>'headers="'
281: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
282: end if;
283:
284: if l_message.transaction_type is not null then
285: htp.tableData(l_message.transaction_type, 'left', cattributes=>'headers="'
286: ||
287: wf_core.translate('TRANSACTIONTYPE') || '"');
288: else
289: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
285: htp.tableData(l_message.transaction_type, 'left', cattributes=>'headers="'
286: ||
287: wf_core.translate('TRANSACTIONTYPE') || '"');
288: else
289: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
290: end if;
291:
292: if l_message.transaction_subtype is not null then
293: htp.tableData(l_message.transaction_subtype, 'left', cattributes=>'headers
289: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
290: end if;
291:
292: if l_message.transaction_subtype is not null then
293: htp.tableData(l_message.transaction_subtype, 'left', cattributes=>'headers
294: ="' ||
295: wf_core.translate('TRANSACTIONSUBTYPE') || '"');
296: else
297: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
293: htp.tableData(l_message.transaction_subtype, 'left', cattributes=>'headers
294: ="' ||
295: wf_core.translate('TRANSACTIONSUBTYPE') || '"');
296: else
297: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
298: end if;
299:
300: if l_message.document_number is not null then
301: htp.tableData(l_message.document_number, 'left', cattributes=>'headers="'
297: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
298: end if;
299:
300: if l_message.document_number is not null then
301: htp.tableData(l_message.document_number, 'left', cattributes=>'headers="'
302: ||
303: wf_core.translate('DOCUMENTNUMBER') || '"');
304: else
305: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
301: htp.tableData(l_message.document_number, 'left', cattributes=>'headers="'
302: ||
303: wf_core.translate('DOCUMENTNUMBER') || '"');
304: else
305: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
306: end if;
307:
308: if l_message.partyid is not null then
309: htp.tableData(l_message.partyid, 'left', cattributes=>'headers="' ||
305: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
306: end if;
307:
308: if l_message.partyid is not null then
309: htp.tableData(l_message.partyid, 'left', cattributes=>'headers="' ||
310: wf_core.translate('PARTYID') || '"');
311: else
312: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
313: end if;
308: if l_message.partyid is not null then
309: htp.tableData(l_message.partyid, 'left', cattributes=>'headers="' ||
310: wf_core.translate('PARTYID') || '"');
311: else
312: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
313: end if;
314:
315: if l_message.party_site_id is not null then
316: htp.tableData(l_message.party_site_id, 'left', cattributes=>'headers="' ||
312: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
313: end if;
314:
315: if l_message.party_site_id is not null then
316: htp.tableData(l_message.party_site_id, 'left', cattributes=>'headers="' ||
317: wf_core.translate('PARTYSITEID') || '"');
318: else
319: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
320: end if;
315: if l_message.party_site_id is not null then
316: htp.tableData(l_message.party_site_id, 'left', cattributes=>'headers="' ||
317: wf_core.translate('PARTYSITEID') || '"');
318: else
319: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
320: end if;
321:
322: if l_message.party_type is not null then
323: htp.tableData(l_message.party_type, 'left', cattributes=>'headers="' ||
319: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
320: end if;
321:
322: if l_message.party_type is not null then
323: htp.tableData(l_message.party_type, 'left', cattributes=>'headers="' ||
324: wf_core.translate('PARTYTYPE') || '"');
325: else
326: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
327: end if;
322: if l_message.party_type is not null then
323: htp.tableData(l_message.party_type, 'left', cattributes=>'headers="' ||
324: wf_core.translate('PARTYTYPE') || '"');
325: else
326: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
327: end if;
328:
329: if l_message.protocol_type is not null then
330: htp.tableData(l_message.protocol_type, 'left', cattributes=>'headers="' ||
326: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
327: end if;
328:
329: if l_message.protocol_type is not null then
330: htp.tableData(l_message.protocol_type, 'left', cattributes=>'headers="' ||
331: wf_core.translate('PROTOCOLTYPE') || '"');
332: else
333: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
334: end if;
329: if l_message.protocol_type is not null then
330: htp.tableData(l_message.protocol_type, 'left', cattributes=>'headers="' ||
331: wf_core.translate('PROTOCOLTYPE') || '"');
332: else
333: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
334: end if;
335:
336: if l_message.protocol_address is not null then
337: htp.tableData(l_message.protocol_address, 'left', cattributes=>'headers="'
333: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
334: end if;
335:
336: if l_message.protocol_address is not null then
337: htp.tableData(l_message.protocol_address, 'left', cattributes=>'headers="'
338: ||
339: wf_core.translate('PROTOCOLADDRESS') || '"');
340: else
341: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
337: htp.tableData(l_message.protocol_address, 'left', cattributes=>'headers="'
338: ||
339: wf_core.translate('PROTOCOLADDRESS') || '"');
340: else
341: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
342: end if;
343:
344: if l_message.attribute1 is not null then
345: htp.tableData(l_message.attribute1,'left', cattributes=>'headers
341: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
342: end if;
343:
344: if l_message.attribute1 is not null then
345: htp.tableData(l_message.attribute1,'left', cattributes=>'headers
346: ="' || wf_core.translate('ATTRIBUTE1') || '"');
347: else
348: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
349: end if;
344: if l_message.attribute1 is not null then
345: htp.tableData(l_message.attribute1,'left', cattributes=>'headers
346: ="' || wf_core.translate('ATTRIBUTE1') || '"');
347: else
348: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
349: end if;
350:
351: if l_message.attribute2 is not null then
352: htp.tableData(l_message.attribute2,'left', cattributes=>'headers
348: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
349: end if;
350:
351: if l_message.attribute2 is not null then
352: htp.tableData(l_message.attribute2,'left', cattributes=>'headers
353: ="' || wf_core.translate('ATTRIBUTE2') || '"');
354: else
355: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
356: end if;
351: if l_message.attribute2 is not null then
352: htp.tableData(l_message.attribute2,'left', cattributes=>'headers
353: ="' || wf_core.translate('ATTRIBUTE2') || '"');
354: else
355: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
356: end if;
357:
358: if l_message.attribute3 is not null then
359: htp.tableData(l_message.attribute3,'left', cattributes=>'headers
355: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
356: end if;
357:
358: if l_message.attribute3 is not null then
359: htp.tableData(l_message.attribute3,'left', cattributes=>'headers
360: ="' || wf_core.translate('ATTRIBUTE3') || '"');
361: else
362: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
363: end if;
358: if l_message.attribute3 is not null then
359: htp.tableData(l_message.attribute3,'left', cattributes=>'headers
360: ="' || wf_core.translate('ATTRIBUTE3') || '"');
361: else
362: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
363: end if;
364:
365: if l_message.attribute4 is not null then
366: htp.tableData(l_message.attribute4,'left', cattributes=>'headers
362: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
363: end if;
364:
365: if l_message.attribute4 is not null then
366: htp.tableData(l_message.attribute4,'left', cattributes=>'headers
367: ="' || wf_core.translate('ATTRIBUTE4') || '"');
368: else
369: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
370: end if;
365: if l_message.attribute4 is not null then
366: htp.tableData(l_message.attribute4,'left', cattributes=>'headers
367: ="' || wf_core.translate('ATTRIBUTE4') || '"');
368: else
369: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
370: end if;
371:
372: if l_message.attribute5 is not null then
373: htp.tableData(l_message.attribute5,'left', cattributes=>'headers
369: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
370: end if;
371:
372: if l_message.attribute5 is not null then
373: htp.tableData(l_message.attribute5,'left', cattributes=>'headers
374: ="' || wf_core.translate('ATTRIBUTE5') || '"');
375: else
376: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
377: end if;
372: if l_message.attribute5 is not null then
373: htp.tableData(l_message.attribute5,'left', cattributes=>'headers
374: ="' || wf_core.translate('ATTRIBUTE5') || '"');
375: else
376: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
377: end if;
378:
379: htp.tableData(l_charmsgstate,'center', cattributes=>'headers="' ||
380: wf_core.translate('MESSAGESTATE') || '"');
375: else
376: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
377: end if;
378:
379: htp.tableData(l_charmsgstate,'center', cattributes=>'headers="' ||
380: wf_core.translate('MESSAGESTATE') || '"');
381:
382: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
383: '/wf_event_html.EventDataContents?p_message_id
378:
379: htp.tableData(l_charmsgstate,'center', cattributes=>'headers="' ||
380: wf_core.translate('MESSAGESTATE') || '"');
381:
382: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
383: '/wf_event_html.EventDataContents?p_message_id
384: ='||l_msg_id
385: ||'&'||'p_queue_table='||'APPS.'||l_qtable||'&'||'p_mimetype=text/xml',
386: ctext=>'
387: alt="' || wf_core.translate('FIND') || '"
388: BORDER=0>'),
389: 'center', cattributes=>'valign="MIDDLE"
390: headers="' || wf_core.translate('XMLEVENTDATA') || '"');
391: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
392: '/wf_event_html.EventDataContents?p_message_id
393: ='||l_msg_id
394: ||'&'||'p_queue_table='||'APPS.'||l_qtable||'&'||'p_mimetype=text',
395: ctext=>'
401:
402: END LOOP;
403: CLOSE l_qcontents;
404:
405: htp.tableclose;
406:
407: htp.br;
408:
409: wfa_sec.Footer;
403: CLOSE l_qcontents;
404:
405: htp.tableclose;
406:
407: htp.br;
408:
409: wfa_sec.Footer;
410:
411: htp.htmlClose;
407: htp.br;
408:
409: wfa_sec.Footer;
410:
411: htp.htmlClose;
412:
413: exception
414: when others then
415: rollback;
479: -- Check if Accessible
480: wf_event_html.isAccessible('AGENTS');
481:
482: -- Set page title
483: htp.htmlOpen;
484: htp.headOpen;
485: htp.p('
486: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
487: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
480: wf_event_html.isAccessible('AGENTS');
481:
482: -- Set page title
483: htp.htmlOpen;
484: htp.headOpen;
485: htp.p('
486: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
487: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
488: htp.headClose;
481:
482: -- Set page title
483: htp.htmlOpen;
484: htp.headOpen;
485: htp.p('
486: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
487: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
488: htp.headClose;
489: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECX_INENGOBJQueue
482: -- Set page title
483: htp.htmlOpen;
484: htp.headOpen;
485: htp.p('
486: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
487: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
488: htp.headClose;
489: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECX_INENGOBJQueue
490: Message?p_queue_name='||p_queue_name||'&'||'p_type=INENGOBJ', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE)
484: htp.headOpen;
485: htp.p('
486: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));
487: wfa_html.create_help_function('wf/links/t_l.htm?T_LQUEM');
488: htp.headClose;
489: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECX_INENGOBJQueue
490: Message?p_queue_name='||p_queue_name||'&'||'p_type=INENGOBJ', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE)
491: ;
492: htp.br;
488: htp.headClose;
489: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wf_event_html.FindECX_INENGOBJQueue
490: Message?p_queue_name='||p_queue_name||'&'||'p_type=INENGOBJ', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE)
491: ;
492: htp.br;
493:
494: IF (admin_mode = 'N') THEN
495: htp.center(htf.bold(l_error_msg));
496: return;
491: ;
492: htp.br;
493:
494: IF (admin_mode = 'N') THEN
495: htp.center(htf.bold(l_error_msg));
496: return;
497: END IF;
498:
499: -- Column headers
496: return;
497: END IF;
498:
499: -- Column headers
500: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
501: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
502: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
503: htp.tableHeader(cvalue=>''||
504: wf_core.translate('MESSAGEID')||'',
498:
499: -- Column headers
500: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
501: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
502: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
503: htp.tableHeader(cvalue=>''||
504: wf_core.translate('MESSAGEID')||'',
505: calign=>'Center',
506: cattributes=>'id="' ||
499: -- Column headers
500: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"
501: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');
502: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
503: htp.tableHeader(cvalue=>''||
504: wf_core.translate('MESSAGEID')||'',
505: calign=>'Center',
506: cattributes=>'id="' ||
507: wf_core.translate('MESSAGEID') || '"');
504: wf_core.translate('MESSAGEID')||'',
505: calign=>'Center',
506: cattributes=>'id="' ||
507: wf_core.translate('MESSAGEID') || '"');
508: htp.tableHeader(cvalue=>''||
509: wf_core.translate('DEBUGMODE')||'',
510: calign=>'Center',
511: cattributes=>'id="' ||
512: wf_core.translate('DEBUGMODE') || '"');
509: wf_core.translate('DEBUGMODE')||'',
510: calign=>'Center',
511: cattributes=>'id="' ||
512: wf_core.translate('DEBUGMODE') || '"');
513: htp.tableHeader(cvalue=>''||
514: wf_core.translate('MESSAGESTATE')||'',
515: calign=>'Center',
516: cattributes=>'id="' ||
517: wf_core.translate('MESSAGESTATE') || '"');
514: wf_core.translate('MESSAGESTATE')||'',
515: calign=>'Center',
516: cattributes=>'id="' ||
517: wf_core.translate('MESSAGESTATE') || '"');
518: htp.tableRowClose;
519: htp.tableRowOpen;
520: htp.tableRowClose;
521:
522: -- Determine the Queue Table based on the Queue Name
515: calign=>'Center',
516: cattributes=>'id="' ||
517: wf_core.translate('MESSAGESTATE') || '"');
518: htp.tableRowClose;
519: htp.tableRowOpen;
520: htp.tableRowClose;
521:
522: -- Determine the Queue Table based on the Queue Name
523: SELECT queue_table INTO l_qtable
516: cattributes=>'id="' ||
517: wf_core.translate('MESSAGESTATE') || '"');
518: htp.tableRowClose;
519: htp.tableRowOpen;
520: htp.tableRowClose;
521:
522: -- Determine the Queue Table based on the Queue Name
523: SELECT queue_table INTO l_qtable
524: FROM all_queues
578:
579: IF (upper(l_message.msgid) LIKE l_likemsgid
580: OR l_message.msgid IS NULL) THEN
581:
582: htp.tableRowOpen(null, 'TOP');
583:
584: htp.p('');
585:
586: if l_message.msgid is not null then
580: OR l_message.msgid IS NULL) THEN
581:
582: htp.tableRowOpen(null, 'TOP');
583:
584: htp.p('');
585:
586: if l_message.msgid is not null then
587: htp.tableData(l_message.msgid, 'left', cattributes=>'headers="' ||
588: wf_core.translate('MESSAGEID') || '"');
583:
584: htp.p('');
585:
586: if l_message.msgid is not null then
587: htp.tableData(l_message.msgid, 'left', cattributes=>'headers="' ||
588: wf_core.translate('MESSAGEID') || '"');
589: else
590: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
591: end if;
586: if l_message.msgid is not null then
587: htp.tableData(l_message.msgid, 'left', cattributes=>'headers="' ||
588: wf_core.translate('MESSAGEID') || '"');
589: else
590: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
591: end if;
592:
593: if l_message.debug_mode is not null then
594: htp.tableData(l_message.debug_mode, 'left', cattributes=>'headers="'
590: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
591: end if;
592:
593: if l_message.debug_mode is not null then
594: htp.tableData(l_message.debug_mode, 'left', cattributes=>'headers="'
595: ||
596: wf_core.translate('DEBUGMODE') || '"');
597: else
598: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
594: htp.tableData(l_message.debug_mode, 'left', cattributes=>'headers="'
595: ||
596: wf_core.translate('DEBUGMODE') || '"');
597: else
598: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
599: end if;
600:
601: htp.tableData(l_charmsgstate,'center', cattributes=>'headers="' ||
602: wf_core.translate('MESSAGESTATE') || '"');
597: else
598: htp.tableData('&'||'nbsp','left',cattributes=>'headers=""');
599: end if;
600:
601: htp.tableData(l_charmsgstate,'center', cattributes=>'headers="' ||
602: wf_core.translate('MESSAGESTATE') || '"');
603: END IF;
604:
605: END LOOP;
604:
605: END LOOP;
606: CLOSE l_qcontents;
607:
608: htp.tableclose;
609:
610: htp.br;
611:
612: wfa_sec.Footer;
606: CLOSE l_qcontents;
607:
608: htp.tableclose;
609:
610: htp.br;
611:
612: wfa_sec.Footer;
613:
614: htp.htmlClose;
610: htp.br;
611:
612: wfa_sec.Footer;
613:
614: htp.htmlClose;
615:
616: exception
617: when others then
618: rollback;