4: --
5: -- Error (PRIVATE)
6: -- Print a page with an error message.
7: -- Errors are retrieved from these sources in order:
8: -- 1. wf_core errors
9: -- 2. Oracle errors
10: -- 3. Unspecified INTERNAL error
11: --
12: procedure Error
140:
141: IF (p_jscript_tag = 'Y') THEN
142:
143: htp.p(' ');
144: htp.p('');
145: END IF;
146:
147: exception
148: when others then
145: END IF;
146:
147: exception
148: when others then
149: Wf_Core.Context('wf_lov', 'OpenLovWinHtml');
150: raise;
151:
152: end OpenLovWinHtml;
153:
201:
202: exception
203: when others then
204: rollback;
205: wf_core.context('Wf_Lov', 'GenerateLovURL',
206: p_form_name ,
207: p_query_plsql ,
208: p_query_params ,
209: p_column_names ,
242:
243: exception
244: when others then
245: rollback;
246: wf_core.context('Wf_Lov', 'create_reg_button',when_pressed_url,onmouseover,
247: icon_top,icon_name,show_text);
248: wf_lov.Error;
249:
250: end CreateButton;
304: htp.title(window_title);
305:
306: ELSE
307:
308: htp.title(wf_core.translate('WFPREF_LOV'));
309:
310: END IF;
311:
312: htp.p('');
424: htp.p('');
425: htp.p('');
476:
477: htp.p('');
478:
479: htp.p('');
497:
498: htp.p('helper();');
499:
500: htp.p(' ');
501: htp.p('');
502:
503: l_url := 'javascript:cancel_lov()';
504: l_icon := 'FNDJLFCN.gif';
505: l_text := wf_core.translate ('CANCEL');
501: htp.p('');
502:
503: l_url := 'javascript:cancel_lov()';
504: l_icon := 'FNDJLFCN.gif';
505: l_text := wf_core.translate ('CANCEL');
506: l_onmouseover := wf_core.translate ('CANCEL');
507:
508: CreateButton (l_url, l_onmouseover, l_media, l_icon, l_text);
509:
502:
503: l_url := 'javascript:cancel_lov()';
504: l_icon := 'FNDJLFCN.gif';
505: l_text := wf_core.translate ('CANCEL');
506: l_onmouseover := wf_core.translate ('CANCEL');
507:
508: CreateButton (l_url, l_onmouseover, l_media, l_icon, l_text);
509:
510: l_url := 'javascript:set_value()';
508: CreateButton (l_url, l_onmouseover, l_media, l_icon, l_text);
509:
510: l_url := 'javascript:set_value()';
511: l_icon := 'FNDJLFOK.gif';
512: l_text := wf_core.translate ('WFMON_OK');
513: l_onmouseover := wf_core.translate ('WFMON_OK');
514:
515: CreateButton (l_url, l_onmouseover, l_media, l_icon, l_text);
516:
509:
510: l_url := 'javascript:set_value()';
511: l_icon := 'FNDJLFOK.gif';
512: l_text := wf_core.translate ('WFMON_OK');
513: l_onmouseover := wf_core.translate ('WFMON_OK');
514:
515: CreateButton (l_url, l_onmouseover, l_media, l_icon, l_text);
516:
517: htp.p('');
521:
522: exception
523: when others then
524: rollback;
525: wf_core.context('Wf_Pref', 'lang_lov_applet');
526: wf_lov.error;
527:
528: end LovApplet;
529:
555: * in l_display_name
556: */
557:
558: if (p_display_key='Y') then
559: l_display_name := wf_core.translate(p_display_name);
560: end if;
561:
562: /*
563: ** Set the title for the window
644:
645: exception
646: when others then
647: rollback;
648: wf_core.context('Wf_Lov', 'display_lov');
649: wf_lov.error;
650:
651: end display_lov;
652:
670:
671: WFA_SEC.GetSession(username);
672:
673: if (p_display_key='Y') then
674: l_display_name := wf_core.translate(p_display_name);
675: end if;
676:
677: htp.headopen;
678:
710: htp.p('function fnd_launch_query()
711: {
712: if (document.WF_FIND.p_current_value.value == "")
713: {
714: alert("'||wf_core.translate('WFLOV_NO_CRITERIA')||'");
715: document.WF_FIND.p_current_value.focus();
716: }
717: else
718: {
726: }');
727:
728: htp.p('');
729:
730: htp.p('');
731:
732: htp.headclose;
733:
734: htp.p('
739: htp.tableOpen(cattributes=>'summary=""');
740:
741: htp.tableRowOpen;
742: htp.tableData(cvalue=>'',
745: calign=>'right',
746: cattributes=>'id=""');
747:
750: cattributes=>'id="i_current_value"'),
751: cattributes=>'id=""');
752:
753: htp.p ('');
754: htp.p('');
755:
756: htp.p('
755:
756: htp.p('
758: wfa_html.create_reg_button ('javascript:fnd_launch_query();',
759: wf_core.translate ('FIND'),
760: wfa_html.image_loc,
761: 'fndfind.gif',
762: wf_core.translate ('FIND'));
763:
764: htp.p('
765:
766: htp.p('
768: wfa_html.create_reg_button ('javascript:document.WF_FIND.reset();',
769: wf_core.translate ('CLEAR'),
770: wfa_html.image_loc,
771: 'fndfind.gif',
772: wf_core.translate ('CLEAR'));
773:
774: htp.p('
780:
781: exception
782: when others then
783: rollback;
784: wf_core.context('Wf_Lov', 'display_lov_find');
785: wf_lov.error;
786:
787: end display_lov_find;
788:
827:
828: htp.p ('');
919:
920: htp.p('');
921:
922: htp.headclose;
923:
924: htp.p('
948: htp.p('');
951:
952: htp.p('');
953:
954: end if;
955:
956:
1052: */
1053: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%" SUMMARY=""');
1054: htp.tableRowOpen;
1055:
1056: wf_core.clear;
1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));
1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');
1060:
1053: htp.tableOpen(cborder => 'BORDER=0', cattributes => 'WIDTH="100%" SUMMARY=""');
1054: htp.tableRowOpen;
1055:
1056: wf_core.clear;
1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));
1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');
1060:
1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1054: htp.tableRowOpen;
1055:
1056: wf_core.clear;
1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));
1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');
1060:
1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1062: '', cattributes=>'id=""');
1055:
1056: wf_core.clear;
1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));
1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');
1060:
1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1062: '', cattributes=>'id=""');
1063:
1057: Wf_Core.Token('START_REC', p_start_row);
1058: Wf_Core.Token('END_REC', TO_CHAR(TO_NUMBER(p_start_row) + wf_lov.g_value_tbl.count - 1));
1059: Wf_Core.Token('TOTAL_REC', ''||TO_CHAR(wf_lov.g_define_rec.total_rows)||'');
1060:
1061: htp.tabledata('' || Wf_Core.Translate('RECORD_MSG') ||
1062: '', cattributes=>'id=""');
1063:
1064: htp.tableRowClose;
1065: htp.tableClose;
1251: TO_CHAR(l_start_row)||
1252: ')">');
1253:
1254: htp.p('');
1256:
1257: htp.p(''||wf_core.translate('PREVIOUS')||'');
1258:
1259: htp.p('');
1253:
1254: htp.p('');
1256:
1257: htp.p(''||wf_core.translate('PREVIOUS')||'');
1258:
1259: htp.p('');
1260:
1261: END IF;
1275: TO_CHAR(l_start_row)||
1276: ')">');
1277:
1278: htp.p('');
1280:
1281: htp.p(''||wf_core.translate('NEXT')||'');
1282:
1283: htp.p('');
1277:
1278: htp.p('');
1280:
1281: htp.p(''||wf_core.translate('NEXT')||'');
1282:
1283: htp.p('');
1284: end if;
1285:
1317:
1318: exception
1319: when others then
1320: rollback;
1321: wf_core.context('Wf_Lov', 'Display_Lov_Details' );
1322: raise;
1323: end display_lov_details;
1324:
1325: /*
1400:
1401: /*
1402: ** Set the title for the window
1403: */
1404: htp.title(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name);
1405:
1406: htp.headopen;
1407: -- hardcode to /OA_HTML/ for ssp
1408: htp.p('');
1447: htp.p('function fnd_launch_query()
1448: {
1449: if (document.WF_FIND.p_current_value.value == "")
1450: {
1451: alert("'||wf_core.translate('WFLOV_NO_CRITERIA')||'");
1452: document.WF_FIND.p_current_value.focus();
1453: }
1454: else
1455: {
1488:
1489:
1490: htp.p('');
1491:
1492: htp.p('');
1493:
1494:
1495: htp.headclose;
1496:
1501: htp.p('
'); 1505: htp.p(wf_core.translate('SELECT')||'&'||'nbsp;'||p_display_name); 1506: htp.p(' | |
'||wf_core.translate('WFLOV_SEARCH')||'&'||'nbsp;');
1512: htp.tableRowOpen; | 1525: 1526: htp.p(' | ');'||wf_core.translate('WFLOV_GO')||' | ');
  | '||wf_core.translate('WFLOV_GO')||' | ');
  | |
  | |
  | |
  | |
  | |
  | '||wf_core.translate('WFLOV_NO_MATCH')||' | ');
  | |
  | '||wf_core.translate('WFLOV_NO_MATCH')||' | ');
  | '||wf_core.translate('WFLOV_NO_MATCH')||' | ');'||wf_core.translate('WFLOV_NO_MATCH')||' | ');'||wf_core.translate('WFLOV_NO_MATCH')||' | ');'||wf_core.translate('WFLOV_CLICK')||' | ');'||wf_core.translate('WFLOV_CLICK')||' | ');'||wf_lov.g_value_tbl(ii).display_value||' | ');'||wf_lov.g_value_tbl(ii).display_value||' | ');'||wf_lov.g_value_tbl(ii).add_attr1_value||' | ');
1918: htp.p('
1919: -- htp.p('
1928:
1929: exception
1930: when others then
1931: rollback;
1932: wf_core.context('Wf_Lov', 'display_lov_no_frame');
1933: wf_lov.error;
1934:
1935: end display_lov_no_frame;
1936:
1962:
1963: l_display_name varchar2(4000) := NULL;
1964: BEGIN
1965:
1966: -- From wf_core.get_message
1967: begin
1968: select TEXT
1969: into l_display_name
1970: from WF_RESOURCES
1992:
1993: exception
1994: when others then
1995: rollback;
1996: wf_core.context('Wf_Lov', 'display_lov_no_frame_key');
1997: wf_lov.error;
1998:
1999: end display_lov_no_frame_key;
2000: