22: error_name varchar2(30);
23: error_message varchar2(2000);
24: error_stack varchar2(32000);
25: begin
26: htp.htmlOpen;
27: htp.headOpen;
28: htp.title(wf_core.translate('ERROR'));
29: htp.headClose;
30:
23: error_message varchar2(2000);
24: error_stack varchar2(32000);
25: begin
26: htp.htmlOpen;
27: htp.headOpen;
28: htp.title(wf_core.translate('ERROR'));
29: htp.headClose;
30:
31: begin
24: error_stack varchar2(32000);
25: begin
26: htp.htmlOpen;
27: htp.headOpen;
28: htp.title(wf_core.translate('ERROR'));
29: htp.headClose;
30:
31: begin
32: wfa_sec.Header(TRUE);
25: begin
26: htp.htmlOpen;
27: htp.headOpen;
28: htp.title(wf_core.translate('ERROR'));
29: htp.headClose;
30:
31: begin
32: wfa_sec.Header(TRUE);
33: exception
31: begin
32: wfa_sec.Header(TRUE);
33: exception
34: when others then
35: htp.bodyOpen;
36: end;
37:
38: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
39:
34: when others then
35: htp.bodyOpen;
36: end;
37:
38: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
39:
40: wf_core.get_error(error_name, error_message, error_stack);
41:
42: if (error_name is not null) then
39:
40: wf_core.get_error(error_name, error_message, error_stack);
41:
42: if (error_name is not null) then
43: htp.p(error_message);
44: else
45: htp.p(sqlerrm);
46: end if;
47:
41:
42: if (error_name is not null) then
43: htp.p(error_message);
44: else
45: htp.p(sqlerrm);
46: end if;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
44: else
45: htp.p(sqlerrm);
46: end if;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
45: htp.p(sqlerrm);
46: end if;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:
46: end if;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:
54: wfa_sec.Footer;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:
54: wfa_sec.Footer;
55: htp.htmlClose;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:
54: wfa_sec.Footer;
55: htp.htmlClose;
56: end Error;
57:
58: --
59: -- GetPlugSession
281: length(userenv('LANGUAGE')));
282:
283:
284: -- From User Field
285: htp.tableRowOpen;
286: htp.tableData(cvalue=>wf_core.translate('NOTIF_FROM'), calign=>'right');
287:
288: IF (fromuser = '*') THEN
289:
282:
283:
284: -- From User Field
285: htp.tableRowOpen;
286: htp.tableData(cvalue=>wf_core.translate('NOTIF_FROM'), calign=>'right');
287:
288: IF (fromuser = '*') THEN
289:
290: htp.tableData(htf.formText(cname=>'fromuser', csize=>'30',
286: htp.tableData(cvalue=>wf_core.translate('NOTIF_FROM'), calign=>'right');
287:
288: IF (fromuser = '*') THEN
289:
290: htp.tableData(htf.formText(cname=>'fromuser', csize=>'30',
291: cvalue=>'', cmaxlength=>'30'));
292:
293: ELSE
294:
291: cvalue=>'', cmaxlength=>'30'));
292:
293: ELSE
294:
295: htp.tableData(htf.formText(cname=>'fromuser', csize=>'30',
296: cvalue=>fromuser, cmaxlength=>'30'));
297:
298: END IF;
299:
296: cvalue=>fromuser, cmaxlength=>'30'));
297:
298: END IF;
299:
300: htp.tableRowClose;
301:
302:
303: -- Type field
304: htp.tableRowOpen;
300: htp.tableRowClose;
301:
302:
303: -- Type field
304: htp.tableRowOpen;
305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');
306: htp.p('
301:
302:
303: -- Type field
304: htp.tableRowOpen;
305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');
306: htp.p('
302:
303: -- Type field
304: htp.tableRowOpen;
305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');
306: htp.p('
303: -- Type field
304: htp.tableRowOpen;
305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');
306: htp.p('
309: for ittype_list in itcurs(username) loop
310:
311: IF (ittype_list.message_type = ittype) THEN
312:
313: htp.formSelectOption(cvalue=>ittype_list.display_name,
314: cselected => 'SELECTED',
315: cattributes=>'value='||ittype_list.message_type);
316:
317: ELSE
315: cattributes=>'value='||ittype_list.message_type);
316:
317: ELSE
318:
319: htp.formSelectOption(cvalue=>ittype_list.display_name,
320: cattributes=>'value='||ittype_list.message_type);
321:
322: END IF;
323:
324: end loop;
325:
326: IF (ittype = '*') THEN
327:
328: htp.formSelectOption(cvalue=>wf_core.translate('ALL'),
329: cselected => 'SELECTED',
330: cattributes=>'value=*');
331:
332: ELSE
330: cattributes=>'value=*');
331:
332: ELSE
333:
334: htp.formSelectOption(cvalue=>wf_core.translate('ALL'),
335: cattributes=>'value=*');
336:
337: END IF;
338:
335: cattributes=>'value=*');
336:
337: END IF;
338:
339: htp.formSelectClose;
340: htp.p('
336:
337: END IF;
338:
339: htp.formSelectClose;
340: htp.p('');
341: htp.tableRowClose;
342:
343: -- Sent in the last N days field
344: htp.tableRowOpen;
337: END IF;
338:
339: htp.formSelectClose;
340: htp.p('');
341: htp.tableRowClose;
342:
343: -- Sent in the last N days field
344: htp.tableRowOpen;
345: htp.tableData(cvalue=>wf_core.translate('NOTIF_SENT'), calign=>'right');
340: htp.p('');
341: htp.tableRowClose;
342:
343: -- Sent in the last N days field
344: htp.tableRowOpen;
345: htp.tableData(cvalue=>wf_core.translate('NOTIF_SENT'), calign=>'right');
346:
347: IF (beg_sent IS NOT NULL) THEN
348:
341: htp.tableRowClose;
342:
343: -- Sent in the last N days field
344: htp.tableRowOpen;
345: htp.tableData(cvalue=>wf_core.translate('NOTIF_SENT'), calign=>'right');
346:
347: IF (beg_sent IS NOT NULL) THEN
348:
349: lbeg_sent := TO_DATE(beg_sent, 'MM/DD/YYYY') - TO_DATE('01/01/2000', 'MM/DD/YYYY');
354:
355: END IF;
356:
357:
358: htp.tableData(htf.formText(cname=>'beg_sent', csize=>'5',
359: cvalue=>lbeg_sent, cmaxlength=>'5'));
360:
361:
362: htp.tableRowClose;
358: htp.tableData(htf.formText(cname=>'beg_sent', csize=>'5',
359: cvalue=>lbeg_sent, cmaxlength=>'5'));
360:
361:
362: htp.tableRowClose;
363:
364: -- Skip a line
365: htp.tableRowOpen;
366:
361:
362: htp.tableRowClose;
363:
364: -- Skip a line
365: htp.tableRowOpen;
366:
367: htp.tableData(cvalue=>' ');
368:
369: htp.tableRowClose;
363:
364: -- Skip a line
365: htp.tableRowOpen;
366:
367: htp.tableData(cvalue=>' ');
368:
369: htp.tableRowClose;
370:
371: -- High Priority Items
365: htp.tableRowOpen;
366:
367: htp.tableData(cvalue=>' ');
368:
369: htp.tableRowClose;
370:
371: -- High Priority Items
372: htp.tableRowOpen;
373:
368:
369: htp.tableRowClose;
370:
371: -- High Priority Items
372: htp.tableRowOpen;
373:
374: htp.tableData(cvalue=>' ');
375:
376: IF (INSTR(priority, 'H') > 0) THEN
370:
371: -- High Priority Items
372: htp.tableRowOpen;
373:
374: htp.tableData(cvalue=>' ');
375:
376: IF (INSTR(priority, 'H') > 0) THEN
377:
378: lchecked := 'Y';
382: lchecked := null;
383:
384: END IF;
385:
386: htp.tableData(
387: cvalue=>htf.formcheckbox(
388: cname=>'HPRIORITY',
389: cvalue=>'H',
390: cchecked=>lchecked)||
390: cchecked=>lchecked)||
391: ' '||wf_core.translate('HIGH_MESSAGES')||' ',
392: calign=>'left');
393:
394: htp.tableRowClose;
395:
396: -- Medium Priority Items
397: htp.tableRowOpen;
398:
393:
394: htp.tableRowClose;
395:
396: -- Medium Priority Items
397: htp.tableRowOpen;
398:
399: htp.tableData(cvalue=>' ');
400:
401: IF (INSTR(priority, 'M') > 0) THEN
395:
396: -- Medium Priority Items
397: htp.tableRowOpen;
398:
399: htp.tableData(cvalue=>' ');
400:
401: IF (INSTR(priority, 'M') > 0) THEN
402:
403: lchecked := 'Y';
407: lchecked := null;
408:
409: END IF;
410:
411: htp.tableData(
412: cvalue=>htf.formcheckbox(
413: cname=>'MPRIORITY',
414: cvalue=>'M',
415: cchecked=>lchecked)||
415: cchecked=>lchecked)||
416: ' '||wf_core.translate('MEDIUM_MESSAGES')||' ',
417: calign=>'left');
418:
419: htp.tableRowClose;
420:
421: -- Low Priority Items
422: htp.tableRowOpen;
423:
418:
419: htp.tableRowClose;
420:
421: -- Low Priority Items
422: htp.tableRowOpen;
423:
424: htp.tableData(cvalue=>' ');
425:
426: IF (INSTR(priority, 'L') > 0) THEN
420:
421: -- Low Priority Items
422: htp.tableRowOpen;
423:
424: htp.tableData(cvalue=>' ');
425:
426: IF (INSTR(priority, 'L') > 0) THEN
427:
428: lchecked := 'Y';
432: lchecked := null;
433:
434: END IF;
435:
436: htp.tableData(
437: cvalue=>htf.formcheckbox(
438: cname=>'LPRIORITY',
439: cvalue=>'L',
440: cchecked=>lchecked)||
440: cchecked=>lchecked)||
441: ' '||wf_core.translate('LOW_MESSAGES')||' ',
442: calign=>'left');
443:
444: htp.tableRowClose;
445:
446: htp.tableClose;
447:
448:
442: calign=>'left');
443:
444: htp.tableRowClose;
445:
446: htp.tableClose;
447:
448:
449: exception
450: when others then
762:
763: fetch wl_cursor into notrec;
764: if wl_cursor%NOTFOUND then
765: /*
766: htp.p(lorderkey||':'||lstatus||':'||luser
767: ||':'||lfromuser||':'||littype||':'||lsubject||':'||lbeg_sent
768: ||':'||lend_sent||':'||lbeg_due||':'||lend_due||':'||lpriority
769: ||':'||ldbm);
770: */
768: ||':'||lend_sent||':'||lbeg_due||':'||lend_due||':'||lpriority
769: ||':'||ldbm);
770: */
771: close wl_cursor;
772: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
773: htp.tableRowOpen;
774: htp.p('
769: ||':'||ldbm);
770: */
771: close wl_cursor;
772: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
773: htp.tableRowOpen;
774: htp.p('
770: */
771: close wl_cursor;
772: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
773: htp.tableRowOpen;
774: htp.p('
784: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||
785: 'p_plug_id='||plug_id, 'FNDALERT.gif');
786:
787: END IF;
788: htp.p('
785: 'p_plug_id='||plug_id, 'FNDALERT.gif');
786:
787: END IF;
788: htp.p('');
789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));
793: htp.br;
786:
787: END IF;
788: htp.p('');
789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));
793: htp.br;
794:
788: htp.p('');
789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));
793: htp.br;
794:
795: return;
796:
789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));
793: htp.br;
794:
795: return;
796:
797: end if;
795: return;
796:
797: end if;
798: /*
799: htp.p(lorderkey||':'||lstatus||':'||luser
800: ||':'||lfromuser||':'||littype||':'||lsubject||':'||lbeg_sent
801: ||':'||lend_sent||':'||lbeg_due||':'||lend_due||':'||lpriority
802: ||':'||ldbm);
803: */
804:
805: -- If this is a plug then show title bar a customize reference
806: IF (plug_id IS NOT NULL) THEN
807:
808: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
809: htp.tableRowOpen;
810: htp.p('
805: -- If this is a plug then show title bar a customize reference
806: IF (plug_id IS NOT NULL) THEN
807:
808: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
809: htp.tableRowOpen;
810: htp.p('
806: IF (plug_id IS NOT NULL) THEN
807:
808: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
809: htp.tableRowOpen;
810: htp.p('
820: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||
821: 'p_plug_id='||plug_id, 'FNDALERT.gif');
822: end if;
823:
824: htp.p('
821: 'p_plug_id='||plug_id, 'FNDALERT.gif');
822: end if;
823:
824: htp.p('');
825: htp.p(' ');
826: htp.tableRowClose;
827: htp.tableClose;
828:
829: END IF;
822: end if;
823:
824: htp.p('');
825: htp.p('
823:
824: htp.p('');
825: htp.p('
828:
829: END IF;
830:
831: -- There are some notifications for the user. Construct the page.
832: htp.tableOpen('border=0 cellpadding=1 cellspacing=0 width=100%');
833:
834: IF (l_worklist_col_definition.count > 1) THEN
835:
836: -- Column headers
833:
834: IF (l_worklist_col_definition.count > 1) THEN
835:
836: -- Column headers
837: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbgcolor);
838:
839: htp.tabledata(cvalue=>' ');
840:
841: FOR l_record_num IN 1..l_worklist_col_definition.count LOOP
835:
836: -- Column headers
837: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbgcolor);
838:
839: htp.tabledata(cvalue=>' ');
840:
841: FOR l_record_num IN 1..l_worklist_col_definition.count LOOP
842:
843: IF (l_worklist_col_definition(l_record_num).column_name =
842:
843: IF (l_worklist_col_definition(l_record_num).column_name =
844: 'MESSAGE_TYPE') THEN
845:
846: htp.tableData(''||wf_core.translate('TYPE')||'', 'Left');
847:
848: END IF;
849:
850: IF (l_worklist_col_definition(l_record_num).column_name =
849:
850: IF (l_worklist_col_definition(l_record_num).column_name =
851: 'SUBJECT') THEN
852:
853: htp.tableData(''||wf_core.translate('SUBJECT')||'', 'Left');
854:
855: END IF;
856:
857: IF (l_worklist_col_definition(l_record_num).column_name =
856:
857: IF (l_worklist_col_definition(l_record_num).column_name =
858: 'BEGIN_DATE') THEN
859:
860: htp.tableData(''||wf_core.translate('BEGIN_DATE')||'', 'Left');
861:
862: END IF;
863:
864: IF (l_worklist_col_definition(l_record_num).column_name =
863:
864: IF (l_worklist_col_definition(l_record_num).column_name =
865: 'DUE_DATE') THEN
866:
867: htp.tableData(''||wf_core.translate('DUE_DATE')||'', 'Left');
868:
869: END IF;
870:
871: END LOOP;
869: END IF;
870:
871: END LOOP;
872:
873: htp.tableRowClose;
874:
875: -- Print line
876: /*
877: htp.p('
879: htp.p('
899: end if;
900: end if;
901:
902: -- Displaying a row
903: htp.tableRowOpen(cvalign=>'TOP', cattributes=>'bgcolor=white');
904:
905: IF (n_priority IS NULL) THEN
906:
907: htp.tableData(cvalue=>' ');
903: htp.tableRowOpen(cvalign=>'TOP', cattributes=>'bgcolor=white');
904:
905: IF (n_priority IS NULL) THEN
906:
907: htp.tableData(cvalue=>' ');
908:
909: ELSE
910:
911: htp.tableData(cvalue=>htf.img(curl=>n_priority));
907: htp.tableData(cvalue=>' ');
908:
909: ELSE
910:
911: htp.tableData(cvalue=>htf.img(curl=>n_priority));
912:
913: END IF;
914:
915: FOR l_record_num IN 1..l_worklist_col_definition.count LOOP
916:
917: IF (l_worklist_col_definition(l_record_num).column_name =
918: 'MESSAGE_TYPE') THEN
919:
920: htp.tableData(cvalue=>''||
921: notrec.message_type, calign=>'left');
922:
923: END IF;
924:
929:
930: Wfa_Html_Util.GetDenormalizedValues(notrec.nid, userenv('LANG'),
931: nf_from_user, nf_to_user, nf_subject);
932:
933: htp.tableData(cvalue=>''||
934: htf.anchor(owa_util.get_owa_service_path||
935: Wfa_Sec.DetailURL(notrec.nid),
936: ctext=>nf_subject, cattributes=>'TARGET="_top"'),
937: calign=>'left');
937: calign=>'left');
938:
939: else
940:
941: htp.tableData( cvalue=>''||
942: htf.anchor(owa_util.get_owa_service_path||
943: Wfa_Sec.DetailURL(notrec.nid),
944: ctext=>notrec.subject, cattributes=>'TARGET="_top"'),
945: calign=>'left');
950:
951: IF (l_worklist_col_definition(l_record_num).column_name =
952: 'BEGIN_DATE') THEN
953:
954: htp.tableData(cvalue=>''||
955: to_char(notrec.begin_date ), calign=>'left',
956: cnowrap=>1);
957:
958: END IF;
959:
960: IF (l_worklist_col_definition(l_record_num).column_name =
961: 'DUE_DATE') THEN
962:
963: htp.tableData(cvalue=>''||
964: nvl(to_char(notrec.due_date), '
'),
965: calign=>'left', cnowrap=>1);
966:
967: END IF;
967: END IF;
968:
969: END LOOP;
970:
971: htp.tableRowClose;
972:
973: <
974: fetch wl_cursor into notrec;
975: exit when wl_cursor%NOTFOUND;
975: exit when wl_cursor%NOTFOUND;
976: end loop;
977: close wl_cursor;
978:
979: htp.tableClose;
980:
981: exception
982: when others then
983: rollback;
1146:
1147: END IF;
1148:
1149: -- Page title
1150: htp.htmlOpen;
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1147: END IF;
1148:
1149: -- Page title
1150: htp.htmlOpen;
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1155: htp.p('
1148:
1149: -- Page title
1150: htp.htmlOpen;
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1155: htp.p('
1150: htp.htmlOpen;
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1155: htp.p('
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1155: htp.p('');
1156:
1157: -- Open body and draw standard header
1158: if (p_plug_id =0) then
1159: icx_plug_utilities.toolbar(p_text => wf_core.translate('WF_EDIT_WORKLIST_TITLE'),
1164: p_disp_mainmenu => 'N',
1165: p_disp_menu => 'N');
1166: end if;
1167:
1168: htp.tableopen;
1169:
1170: htp.tablerowopen;
1171:
1172: htp.p('
1166: end if;
1167:
1168: htp.tableopen;
1169:
1170: htp.tablerowopen;
1171:
1172: htp.p('
1168: htp.tableopen;
1169:
1170: htp.tablerowopen;
1171:
1172: htp.p('
1170: htp.tablerowopen;
1171:
1172: htp.p('
1172: htp.p('
1174: htp.p('
1176: htp.p('
1178: htp.tablerowclose;
1179:
1180: htp.tableclose;
1181:
1182: htp.tableopen(calign=>'CENTER');
1183:
1184: htp.tablerowopen;
1185:
1186: htp.p('
1180: htp.tableclose;
1181:
1182: htp.tableopen(calign=>'CENTER');
1183:
1184: htp.tablerowopen;
1185:
1186: htp.p('
1182: htp.tableopen(calign=>'CENTER');
1183:
1184: htp.tablerowopen;
1185:
1186: htp.p('