APPS.ECX_WORKFLOW_HTML dependencies on WF_CORE

Line 29: l_onmouseover varchar2(240) := wf_core.translate ('WFPREF_LOV');

25: admin_mode varchar2(1) := 'N';
26: l_media varchar2(240) := wfa_html.image_loc;
27: l_icon varchar2(40) := 'FNDILOV.gif';
28: l_text varchar2(240) := '';
29: l_onmouseover varchar2(240) := wf_core.translate ('WFPREF_LOV');
30: l_url varchar2(4000);
31: l_error_msg varchar2(240);
32: l_more_data BOOLEAN := TRUE;
33: l_queue_table varchar2(30);

Line 58: admin_role := wf_core.translate('WF_ADMIN_ROLE');

54: wfa_sec.GetSession(username);
55: username := upper(username);
56: wf_directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
57:
58: admin_role := wf_core.translate('WF_ADMIN_ROLE');
59: if (admin_role = '*' or
60: Wf_Directory.IsPerformer(username, admin_role)) then
61: admin_mode := 'Y';
62: else

Line 64: l_error_msg := wf_core.translate('WFPREF_INVALID_ADMIN');

60: Wf_Directory.IsPerformer(username, admin_role)) then
61: admin_mode := 'Y';
62: else
63:
64: l_error_msg := wf_core.translate('WFPREF_INVALID_ADMIN');
65:
66: end if;
67:
68: -- Check if Accessible

Line 75: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));

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);

Line 79: Message?p_queue_name='||p_queue_name||'&'||'p_type=ECXMSG', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE);

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:
82: IF (admin_mode = 'N') THEN
83: htp.center(htf.bold(l_error_msg));

Line 89: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');

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:
93: htp.tableHeader(cvalue=>''||

Line 94: wf_core.translate('MESSAGETYPE')||'',

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') || '"');
98: htp.tableHeader(cvalue=>''||

Line 99: wf_core.translate('MESSAGESTANDARD')||'',

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') || '"');
103: htp.tableHeader(cvalue=>''||

Line 104: wf_core.translate('TRANSACTIONTYPE')||'',

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') || '"');
108: htp.tableHeader(cvalue=>''||

Line 109: wf_core.translate('TRANSACTIONSUBTYPE')||'',

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') || '"');
113: htp.tableHeader(cvalue=>''||

Line 114: wf_core.translate('DOCUMENTNUMBER')||'',

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') || '"');
118: htp.tableHeader(cvalue=>''||

Line 119: wf_core.translate('PARTYID')||'',

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') || '"');
123: htp.tableHeader(cvalue=>''||

Line 124: wf_core.translate('PARTYSITEID')||'',

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') || '"');
128: htp.tableHeader(cvalue=>''||

Line 129: wf_core.translate('PARTYTYPE')||'',

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') || '"');
133: htp.tableHeader(cvalue=>''||

Line 134: wf_core.translate('PROTOCOLTYPE')||'',

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') || '"');
138: htp.tableHeader(cvalue=>''||

Line 139: wf_core.translate('PROTOCOLADDRESS')||'',

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') || '"');
143: htp.tableHeader(cvalue=>''||

Line 144: wf_core.translate('ATTRIBUTE1')||'',

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') || '"');
148: htp.tableHeader(cvalue=>''||

Line 149: wf_core.translate('ATTRIBUTE2')||'',

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') || '"');
153: htp.tableHeader(cvalue=>''||

Line 154: wf_core.translate('ATTRIBUTE3')||'',

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') || '"');
158: htp.tableHeader(cvalue=>''||

Line 159: wf_core.translate('ATTRIBUTE4')||'',

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') || '"');
163: htp.tableHeader(cvalue=>''||

Line 164: wf_core.translate('ATTRIBUTE5')||'',

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') || '"');
168: htp.tableHeader(cvalue=>''||

Line 169: wf_core.translate('MESSAGESTATE')||'',

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') || '"');
173: htp.tableHeader(cvalue=>''||

Line 174: wf_core.translate('XMLEVENTDATA')||'',

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') || '"');
178:

Line 177: wf_core.translate('XMLEVENTDATA') || '"');

173: htp.tableHeader(cvalue=>''||
174: 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',

Line 180: wf_core.translate('TXTEVENTDATA')||'',

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') || '"');
184: htp.tableRowClose;

Line 183: wf_core.translate('TXTEVENTDATA') || '"');

179: htp.tableHeader(cvalue=>''||
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:

Line 246: l_charmsgstate := (wf_core.translate('READY'));

242: EXIT WHEN l_qcontents%NOTFOUND;
243:
244: -- Convert Numeric Message State to characters
245: IF l_msgstate = 0 THEN
246: l_charmsgstate := (wf_core.translate('READY'));
247: ELSIF l_msgstate = 1 THEN
248: l_charmsgstate := (wf_core.translate('WAIT'));
249: ELSIF l_msgstate = 2 THEN
250: l_charmsgstate := (wf_core.translate('PROCESSED'));

Line 248: l_charmsgstate := (wf_core.translate('WAIT'));

244: -- Convert Numeric Message State to characters
245: IF l_msgstate = 0 THEN
246: l_charmsgstate := (wf_core.translate('READY'));
247: ELSIF l_msgstate = 1 THEN
248: l_charmsgstate := (wf_core.translate('WAIT'));
249: ELSIF l_msgstate = 2 THEN
250: l_charmsgstate := (wf_core.translate('PROCESSED'));
251: ELSIF l_msgstate = 3 THEN
252: l_charmsgstate := (wf_core.translate('EXPIRED'));

Line 250: l_charmsgstate := (wf_core.translate('PROCESSED'));

246: l_charmsgstate := (wf_core.translate('READY'));
247: ELSIF l_msgstate = 1 THEN
248: l_charmsgstate := (wf_core.translate('WAIT'));
249: ELSIF l_msgstate = 2 THEN
250: l_charmsgstate := (wf_core.translate('PROCESSED'));
251: ELSIF l_msgstate = 3 THEN
252: l_charmsgstate := (wf_core.translate('EXPIRED'));
253: ELSE
254: l_charmsgstate := (wf_core.translate('UNKNOWN'));

Line 252: l_charmsgstate := (wf_core.translate('EXPIRED'));

248: l_charmsgstate := (wf_core.translate('WAIT'));
249: ELSIF l_msgstate = 2 THEN
250: l_charmsgstate := (wf_core.translate('PROCESSED'));
251: ELSIF l_msgstate = 3 THEN
252: l_charmsgstate := (wf_core.translate('EXPIRED'));
253: ELSE
254: l_charmsgstate := (wf_core.translate('UNKNOWN'));
255: END IF;
256:

Line 254: l_charmsgstate := (wf_core.translate('UNKNOWN'));

250: l_charmsgstate := (wf_core.translate('PROCESSED'));
251: ELSIF l_msgstate = 3 THEN
252: l_charmsgstate := (wf_core.translate('EXPIRED'));
253: ELSE
254: l_charmsgstate := (wf_core.translate('UNKNOWN'));
255: END IF;
256:
257:
258: IF (upper(l_message.transaction_type) LIKE l_liketranstype

Line 271: wf_core.translate('MESSAGETYPE') || '"');

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;
275:

Line 279: wf_core.translate('MESSAGESTANDARD') || '"');

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=""');
282: end if;
283:

Line 287: wf_core.translate('TRANSACTIONTYPE') || '"');

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=""');
290: end if;
291:

Line 295: wf_core.translate('TRANSACTIONSUBTYPE') || '"');

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=""');
298: end if;
299:

Line 303: wf_core.translate('DOCUMENTNUMBER') || '"');

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=""');
306: end if;
307:

Line 310: wf_core.translate('PARTYID') || '"');

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;
314:

Line 317: wf_core.translate('PARTYSITEID') || '"');

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;
321:

Line 324: wf_core.translate('PARTYTYPE') || '"');

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;
328:

Line 331: wf_core.translate('PROTOCOLTYPE') || '"');

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;
335:

Line 339: wf_core.translate('PROTOCOLADDRESS') || '"');

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=""');
342: end if;
343:

Line 346: ="' || wf_core.translate('ATTRIBUTE1') || '"');

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;
350:

Line 353: ="' || wf_core.translate('ATTRIBUTE2') || '"');

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;
357:

Line 360: ="' || wf_core.translate('ATTRIBUTE3') || '"');

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;
364:

Line 367: ="' || wf_core.translate('ATTRIBUTE4') || '"');

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;
371:

Line 374: ="' || wf_core.translate('ATTRIBUTE5') || '"');

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;
378:

Line 380: wf_core.translate('MESSAGESTATE') || '"');

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
384: ='||l_msg_id

Line 387: alt="' || wf_core.translate('FIND') || '"

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||

Line 390: headers="' || wf_core.translate('XMLEVENTDATA') || '"');

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',

Line 396: alt="' || wf_core.translate('FIND') || '"

392: '/wf_event_html.EventDataContents?p_message_id
393: ='||l_msg_id
394: ||'&'||'p_queue_table='||'APPS.'||l_qtable||'&'||'p_mimetype=text',
395: ctext=>' 396: alt="' || wf_core.translate('FIND') || '"
397: BORDER=0>'),
398: 'center', cattributes=>'valign="MIDDLE"
399: headers="' || wf_core.translate('TXTEVENTDATA') || '"');
400: END IF;

Line 399: headers="' || wf_core.translate('TXTEVENTDATA') || '"');

395: ctext=>' 396: alt="' || wf_core.translate('FIND') || '"
397: BORDER=0>'),
398: 'center', cattributes=>'valign="MIDDLE"
399: headers="' || wf_core.translate('TXTEVENTDATA') || '"');
400: END IF;
401:
402: END LOOP;
403: CLOSE l_qcontents;

Line 416: Wf_Core.Context('ECX_WORKFLOW_HTML', 'ListECXMSGQueueMessages',

412:
413: exception
414: when others then
415: rollback;
416: Wf_Core.Context('ECX_WORKFLOW_HTML', 'ListECXMSGQueueMessages',
417: p_queue_name);
418: wfe_html_util.Error;
419: --raise;
420: end ListECXMSGQueueMessages;

Line 442: l_onmouseover varchar2(240) := wf_core.translate ('WFPREF_LOV');

438: admin_mode varchar2(1) := 'N';
439: l_media varchar2(240) := wfa_html.image_loc;
440: l_icon varchar2(40) := 'FNDILOV.gif';
441: l_text varchar2(240) := '';
442: l_onmouseover varchar2(240) := wf_core.translate ('WFPREF_LOV');
443: l_url varchar2(4000);
444: l_error_msg varchar2(240);
445: l_more_data BOOLEAN := TRUE;
446: l_queue_table varchar2(30);

Line 469: admin_role := wf_core.translate('WF_ADMIN_ROLE');

465: wfa_sec.GetSession(username);
466: username := upper(username);
467: wf_directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
468:
469: admin_role := wf_core.translate('WF_ADMIN_ROLE');
470: if (admin_role = '*' or
471: Wf_Directory.IsPerformer(username, admin_role)) then
472: admin_mode := 'Y';
473: else

Line 475: l_error_msg := wf_core.translate('WFPREF_INVALID_ADMIN');

471: Wf_Directory.IsPerformer(username, admin_role)) then
472: admin_mode := 'Y';
473: else
474:
475: l_error_msg := wf_core.translate('WFPREF_INVALID_ADMIN');
476:
477: end if;
478:
479: -- Check if Accessible

Line 486: htp.title(wf_core.translate('WFQUEUE_MESSAGE_TITLE'));

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)

Line 490: Message?p_queue_name='||p_queue_name||'&'||'p_type=INENGOBJ', wf_core.translate('WFQUEUE_MESSAGE_TITLE'), TRUE)

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;
493:
494: IF (admin_mode = 'N') THEN

Line 501: summary="' || wf_core.translate('WFQUEUE_MESSAGE_TITLE') || '"');

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')||'',
505: calign=>'Center',

Line 504: wf_core.translate('MESSAGEID')||'',

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') || '"');
508: htp.tableHeader(cvalue=>''||

Line 509: wf_core.translate('DEBUGMODE')||'',

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') || '"');
513: htp.tableHeader(cvalue=>''||

Line 514: wf_core.translate('MESSAGESTATE')||'',

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') || '"');
518: htp.tableRowClose;

Line 517: wf_core.translate('MESSAGESTATE') || '"');

513: htp.tableHeader(cvalue=>''||
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:

Line 567: l_charmsgstate := (wf_core.translate('READY'));

563: EXIT WHEN l_qcontents%NOTFOUND;
564:
565: -- Convert Numeric Message State to characters
566: IF l_msgstate = 0 THEN
567: l_charmsgstate := (wf_core.translate('READY'));
568: ELSIF l_msgstate = 1 THEN
569: l_charmsgstate := (wf_core.translate('WAIT'));
570: ELSIF l_msgstate = 2 THEN
571: l_charmsgstate := (wf_core.translate('PROCESSED'));

Line 569: l_charmsgstate := (wf_core.translate('WAIT'));

565: -- Convert Numeric Message State to characters
566: IF l_msgstate = 0 THEN
567: l_charmsgstate := (wf_core.translate('READY'));
568: ELSIF l_msgstate = 1 THEN
569: l_charmsgstate := (wf_core.translate('WAIT'));
570: ELSIF l_msgstate = 2 THEN
571: l_charmsgstate := (wf_core.translate('PROCESSED'));
572: ELSIF l_msgstate = 3 THEN
573: l_charmsgstate := (wf_core.translate('EXPIRED'));

Line 571: l_charmsgstate := (wf_core.translate('PROCESSED'));

567: l_charmsgstate := (wf_core.translate('READY'));
568: ELSIF l_msgstate = 1 THEN
569: l_charmsgstate := (wf_core.translate('WAIT'));
570: ELSIF l_msgstate = 2 THEN
571: l_charmsgstate := (wf_core.translate('PROCESSED'));
572: ELSIF l_msgstate = 3 THEN
573: l_charmsgstate := (wf_core.translate('EXPIRED'));
574: ELSE
575: l_charmsgstate := (wf_core.translate('UNKNOWN'));

Line 573: l_charmsgstate := (wf_core.translate('EXPIRED'));

569: l_charmsgstate := (wf_core.translate('WAIT'));
570: ELSIF l_msgstate = 2 THEN
571: l_charmsgstate := (wf_core.translate('PROCESSED'));
572: ELSIF l_msgstate = 3 THEN
573: l_charmsgstate := (wf_core.translate('EXPIRED'));
574: ELSE
575: l_charmsgstate := (wf_core.translate('UNKNOWN'));
576: END IF;
577:

Line 575: l_charmsgstate := (wf_core.translate('UNKNOWN'));

571: l_charmsgstate := (wf_core.translate('PROCESSED'));
572: ELSIF l_msgstate = 3 THEN
573: l_charmsgstate := (wf_core.translate('EXPIRED'));
574: ELSE
575: l_charmsgstate := (wf_core.translate('UNKNOWN'));
576: END IF;
577:
578:
579: IF (upper(l_message.msgid) LIKE l_likemsgid

Line 588: wf_core.translate('MESSAGEID') || '"');

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;
592:

Line 596: wf_core.translate('DEBUGMODE') || '"');

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=""');
599: end if;
600:

Line 602: wf_core.translate('MESSAGESTATE') || '"');

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;
606: CLOSE l_qcontents;

Line 619: Wf_Core.Context('ECX_WORKFLOW_HTML', 'ListECX_INENGOBJQueueMessages',

615:
616: exception
617: when others then
618: rollback;
619: Wf_Core.Context('ECX_WORKFLOW_HTML', 'ListECX_INENGOBJQueueMessages',
620: p_queue_name);
621: wfe_html_util.Error;
622: --raise;
623: end ListECX_INENGOBJQueueMessages;