eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_QUESTIONS_ADMIN dependencies on WF_CORE

Line 9: dm_base_url varchar2(240) := wf_core.translate('WF_WEB_AGENT');

5: ** We need need to fetch URL prefix from WF_WEB_AGENT in wf_resources
6: ** since this function gets called from the forms environment
7: ** which doesn't know anything about the cgi variables.
8: */
9: dm_base_url varchar2(240) := wf_core.translate('WF_WEB_AGENT');
10:
11: --
12: -- Error (PRIVATE)
13: -- Print a page with an error message.

Line 15: -- 1. wf_core errors

11: --
12: -- Error (PRIVATE)
13: -- Print a page with an error message.
14: -- Errors are retrieved from these sources in order:
15: -- 1. wf_core errors
16: -- 2. Oracle errors
17: -- 3. Unspecified INTERNAL error
18: --
19: procedure Error

Line 27: htp.title(wf_core.translate('ERROR'));

23: error_stack varchar2(32000);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
30: begin
31: wfa_sec.Header(background_only=>TRUE);

Line 37: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));

33: when others then
34: htp.bodyOpen;
35: end;
36:
37: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
38:
39: wf_core.get_error(error_name, error_message, error_stack);
40:
41: if (error_name is not null) then

Line 39: wf_core.get_error(error_name, error_message, error_stack);

35: end;
36:
37: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
38:
39: wf_core.get_error(error_name, error_message, error_stack);
40:
41: if (error_name is not null) then
42: htp.p(error_message);
43: else

Line 48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);

44: htp.p(sqlerrm);
45: end if;
46:
47: htp.hr;
48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
49: htp.br;
50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
51: replace(error_stack,wf_core.newline,'
'));
52:

Line 50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||

46:
47: htp.hr;
48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
49: htp.br;
50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
51: replace(error_stack,wf_core.newline,'
'));
52:
53: wfa_sec.Footer;
54: htp.htmlClose;

Line 51: replace(error_stack,wf_core.newline,'
'));

47: htp.hr;
48: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
49: htp.br;
50: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
51: replace(error_stack,wf_core.newline,'
'));
52:
53: wfa_sec.Footer;
54: htp.htmlClose;
55:

Line 156: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');

152: l_username varchar2(80);
153: l_media varchar2(240) := wfa_html.image_loc;
154: l_icon varchar2(30) := 'FNDILOV.gif';
155: l_text varchar2(30) := '';
156: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');
157: l_url varchar2(4000);
158: l_error_msg varchar2(240);
159:
160: BEGIN

Line 168: htp.title(wf_core.translate('ICX_FIND_QUESTIONS_TITLE'));

164:
165: -- Set page title
166: htp.htmlOpen;
167: htp.headOpen;
168: htp.title(wf_core.translate('ICX_FIND_QUESTIONS_TITLE'));
169: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
170: fnd_document_management.get_open_dm_display_window;
171: wf_lov.OpenLovWinHtml;
172:

Line 176: wfa_sec.Header(FALSE, '', wf_core.translate('ICX_FIND_QUESTIONS_TITLE'), TRUE);

172:
173: htp.headClose;
174:
175: -- Page header
176: wfa_sec.Header(FALSE, '', wf_core.translate('ICX_FIND_QUESTIONS_TITLE'), TRUE);
177:
178: htp.tableopen(calign=>'CENTER');
179:
180: htp.p('

');

Line 184: htp.tableData(cvalue=>wf_core.translate('ICX_APPLICATION'),

180: htp.p('');
181:
182: -- Application Name
183: htp.tableRowOpen;
184: htp.tableData(cvalue=>wf_core.translate('ICX_APPLICATION'),
185: calign=>'right');
186:
187: -- add LOV here: Note:bottom is name of frame.
188: -- Note: The REPLACE function replaces all the space characters with

Line 192: '&p_display_name='||wf_core.translate('ICX_APPLICATION')||

188: -- Note: The REPLACE function replaces all the space characters with
189: -- the proper escape sequence.
190: l_url := 'javascript:fnd_open_dm_display_window('||''''||
191: REPLACE('wf_lov.display_lov?p_lov_name='||'questions'||
192: '&p_display_name='||wf_core.translate('ICX_APPLICATION')||
193: '&p_validation_callback=icx_questions_admin.application_lov'||
194: '&p_dest_hidden_field=top.opener.document.ICX_FIND_QUESTIONS.p_application_short_name.value'||
195: '&p_current_value=top.opener.document.ICX_FIND_QUESTIONS.p_application_short_name.value'||
196: '&p_dest_display_field=top.opener.document.ICX_FIND_QUESTIONS.p_application_short_name.value',

Line 210: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),

206:
207:
208: -- Question Code
209: htp.tableRowOpen;
210: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
211: calign=>'right');
212:
213: htp.tableData(htf.formText(cname=>'p_question_code', csize=>'25',
214: cvalue=>null, cmaxlength=>'30'));

Line 220: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),

216: htp.tableRowClose;
217:
218: -- Question
219: htp.tableRowOpen;
220: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
221: calign=>'right');
222:
223: htp.tableData(htf.formText(cname=>'p_question', csize=>'50',
224: cvalue=>null, cmaxlength=>'240'));

Line 241: wf_core.translate ('FIND'),

237:
238: htp.p('');
239:
240: wfa_html.create_reg_button ('javascript:document.ICX_FIND_QUESTIONS.submit()',
241: wf_core.translate ('FIND'),
242: wfa_html.image_loc,
243: 'fndfind.gif',
244: wf_core.translate ('FIND'));
245:

Line 244: wf_core.translate ('FIND'));

240: wfa_html.create_reg_button ('javascript:document.ICX_FIND_QUESTIONS.submit()',
241: wf_core.translate ('FIND'),
242: wfa_html.image_loc,
243: 'fndfind.gif',
244: wf_core.translate ('FIND'));
245:
246: htp.p('');
247:
248: htp.tableRowClose;

Line 260: wf_core.context('icx_questions_admin', 'find_questions');

256:
257:
258: exception
259: when others then
260: wf_core.context('icx_questions_admin', 'find_questions');
261: icx_questions_admin.error;
262:
263: END find_questions;
264:

Line 325: htp.title(wf_core.translate('ICX_QUESTIONS_TITLE'));

321: -- Set page title
322: htp.htmlOpen;
323: htp.headOpen;
324: htp.p('');
325: htp.title(wf_core.translate('ICX_QUESTIONS_TITLE'));
326: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
327: htp.headClose;
328: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_QUESTIONS_TITLE'), FALSE);
329: htp.br;

Line 328: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_QUESTIONS_TITLE'), FALSE);

324: htp.p('');
325: htp.title(wf_core.translate('ICX_QUESTIONS_TITLE'));
326: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
327: htp.headClose;
328: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_QUESTIONS_TITLE'), FALSE);
329: htp.br;
330:
331: -- Column headers
332: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');

Line 336: wf_core.translate('ICX_APPLICATION')||'',

332: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
333: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
334:
335: htp.tableHeader(cvalue=>''||
336: wf_core.translate('ICX_APPLICATION')||'',
337: calign=>'Center');
338: htp.tableHeader(cvalue=>''||
339: wf_core.translate('ICX_QUESTION_CODE')||'',
340: calign=>'Center');

Line 339: wf_core.translate('ICX_QUESTION_CODE')||'',

335: htp.tableHeader(cvalue=>''||
336: wf_core.translate('ICX_APPLICATION')||'',
337: calign=>'Center');
338: htp.tableHeader(cvalue=>''||
339: wf_core.translate('ICX_QUESTION_CODE')||'',
340: calign=>'Center');
341: htp.tableHeader(cvalue=>''||
342: wf_core.translate('ICX_QUESTION')||'',
343: calign=>'Center');

Line 342: wf_core.translate('ICX_QUESTION')||'',

338: htp.tableHeader(cvalue=>''||
339: wf_core.translate('ICX_QUESTION_CODE')||'',
340: calign=>'Center');
341: htp.tableHeader(cvalue=>''||
342: wf_core.translate('ICX_QUESTION')||'',
343: calign=>'Center');
344: htp.tableHeader(cvalue=>''||
345: wf_core.translate('ICX_EDIT_FUNCTIONS')||'',
346: calign=>'Center');

Line 345: wf_core.translate('ICX_EDIT_FUNCTIONS')||'',

341: htp.tableHeader(cvalue=>''||
342: wf_core.translate('ICX_QUESTION')||'',
343: calign=>'Center');
344: htp.tableHeader(cvalue=>''||
345: wf_core.translate('ICX_EDIT_FUNCTIONS')||'',
346: calign=>'Center');
347: htp.tableHeader(cvalue=>''||
348: wf_core.translate('DELETE')||'',
349: calign=>'Center');

Line 348: wf_core.translate('DELETE')||'',

344: htp.tableHeader(cvalue=>''||
345: wf_core.translate('ICX_EDIT_FUNCTIONS')||'',
346: calign=>'Center');
347: htp.tableHeader(cvalue=>''||
348: wf_core.translate('DELETE')||'',
349: calign=>'Center');
350: htp.tableRowClose;
351: htp.tableRowOpen;
352: htp.tableRowClose;

Line 403: l_text := wf_core.translate ('WFDM_CREATE');

399: l_url := wfa_html.base_url||'/icx_questions_admin.edit_question'||
400: '?p_insert=TRUE'||
401: '&p_find_criteria='||l_find_criteria;
402: l_icon := 'FNDADD11.gif';
403: l_text := wf_core.translate ('WFDM_CREATE');
404: l_onmouseover := wf_core.translate ('WFDM_CREATE');
405:
406: htp.p('');
407:

Line 404: l_onmouseover := wf_core.translate ('WFDM_CREATE');

400: '?p_insert=TRUE'||
401: '&p_find_criteria='||l_find_criteria;
402: l_icon := 'FNDADD11.gif';
403: l_text := wf_core.translate ('WFDM_CREATE');
404: l_onmouseover := wf_core.translate ('WFDM_CREATE');
405:
406: htp.p('');
407:
408: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 421: wf_core.context('icx_questions_admin', 'DISPLAY_QUESTIONS');

417: htp.htmlClose;
418:
419: exception
420: when others then
421: wf_core.context('icx_questions_admin', 'DISPLAY_QUESTIONS');
422: icx_questions_admin.error;
423: end DISPLAY_QUESTIONS;
424:
425: --

Line 450: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');

446: l_username varchar2(80);
447: l_media varchar2(240) := wfa_html.image_loc;
448: l_icon varchar2(30) := 'FNDILOV.gif';
449: l_text varchar2(30) := '';
450: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');
451: l_url varchar2(4000);
452: l_error_msg varchar2(240);
453:
454: BEGIN

Line 487: htp.title(wf_core.translate('ICX_EDIT_QUESTION_TITLE'));

483:
484: -- Set page title
485: htp.htmlOpen;
486: htp.headOpen;
487: htp.title(wf_core.translate('ICX_EDIT_QUESTION_TITLE'));
488: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
489: fnd_document_management.get_open_dm_display_window;
490: wf_lov.OpenLovWinHtml;
491:

Line 495: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions', wf_core.translate('ICX_EDIT_QUESTION_TITLE'), TRUE);

491:
492: htp.headClose;
493:
494: -- Page header
495: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions', wf_core.translate('ICX_EDIT_QUESTION_TITLE'), TRUE);
496:
497: -- Print the error message if there is one
498: if (P_ERROR_MESSAGE IS NOT NULL) THEN
499:

Line 501: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');

497: -- Print the error message if there is one
498: if (P_ERROR_MESSAGE IS NOT NULL) THEN
499:
500: htp.br;
501: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');
502: htp.br;
503:
504: end if;
505:

Line 523: htp.tableData(cvalue=>wf_core.translate('ICX_APPLICATION'),

519: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
520:
521: -- Application Name
522: htp.tableRowOpen;
523: htp.tableData(cvalue=>wf_core.translate('ICX_APPLICATION'),
524: calign=>'right');
525:
526: -- add LOV here: Note:bottom is name of frame.
527: -- Note: The REPLACE function replaces all the space characters with

Line 531: '&p_display_name='||wf_core.translate('ICX_APPLICATION')||

527: -- Note: The REPLACE function replaces all the space characters with
528: -- the proper escape sequence.
529: l_url := 'javascript:fnd_open_dm_display_window('||''''||
530: REPLACE('wf_lov.display_lov?p_lov_name='||'questions'||
531: '&p_display_name='||wf_core.translate('ICX_APPLICATION')||
532: '&p_validation_callback=icx_questions_admin.application_lov'||
533: '&p_dest_hidden_field=top.opener.document.ICX_EDIT_QUESTION.p_application_short_name.value'||
534: '&p_current_value=top.opener.document.ICX_EDIT_QUESTION.p_application_short_name.value'||
535: '&p_dest_display_field=top.opener.document.ICX_EDIT_QUESTION.p_application_short_name.value',

Line 549: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),

545:
546:
547: -- Question Code
548: htp.tableRowOpen;
549: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
550: calign=>'right');
551:
552: IF (P_INSERT = 'FALSE') THEN
553:

Line 570: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),

566: htp.tableRowClose;
567:
568: -- question
569: htp.tableRowOpen;
570: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION'),
571: calign=>'right', cattributes=>'VALIGN="TOP"');
572:
573: htp.p ('');
574:

Line 599: l_text := wf_core.translate ('WFMON_OK');

595: htp.tableRowOpen;
596:
597: l_url := 'javascript:document.ICX_EDIT_QUESTION.submit()';
598: l_icon := 'FNDJLFOK.gif';
599: l_text := wf_core.translate ('WFMON_OK');
600: l_onmouseover := wf_core.translate ('WFMON_OK');
601:
602: htp.p('');
603:

Line 600: l_onmouseover := wf_core.translate ('WFMON_OK');

596:
597: l_url := 'javascript:document.ICX_EDIT_QUESTION.submit()';
598: l_icon := 'FNDJLFOK.gif';
599: l_text := wf_core.translate ('WFMON_OK');
600: l_onmouseover := wf_core.translate ('WFMON_OK');
601:
602: htp.p('');
603:
604: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 610: l_text := wf_core.translate ('CANCEL');

606: htp.p('');
607:
608: l_url := icx_questions_admin.get_display_syntax (p_find_criteria);
609: l_icon := 'FNDJLFCN.gif';
610: l_text := wf_core.translate ('CANCEL');
611: l_onmouseover := wf_core.translate ('CANCEL');
612:
613: htp.p('');
614:

Line 611: l_onmouseover := wf_core.translate ('CANCEL');

607:
608: l_url := icx_questions_admin.get_display_syntax (p_find_criteria);
609: l_icon := 'FNDJLFCN.gif';
610: l_text := wf_core.translate ('CANCEL');
611: l_onmouseover := wf_core.translate ('CANCEL');
612:
613: htp.p('');
614:
615: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 631: wf_core.context('icx_questions_admin', 'edit_question');

627:
628:
629: exception
630: when others then
631: wf_core.context('icx_questions_admin', 'edit_question');
632: icx_questions_admin.error;
633:
634: END edit_question;
635:

Line 727: wf_core.context('icx_questions_admin', 'insert_question');

723:
724:
725: exception
726: when others then
727: wf_core.context('icx_questions_admin', 'insert_question');
728: icx_questions_admin.error;
729:
730: END insert_question;
731:

Line 800: wf_core.context('icx_questions_admin', 'update_question');

796: end if;
797:
798: exception
799: when others then
800: wf_core.context('icx_questions_admin', 'update_question');
801: icx_questions_admin.error;
802:
803: END update_question;
804:

Line 834: htp.title(wf_core.translate('ICX_CONFIRMTITLE'));

830: -- Set page title
831: htp.htmlOpen;
832: htp.headOpen;
833: htp.p('');
834: htp.title(wf_core.translate('ICX_CONFIRMTITLE'));
835: wfa_html.create_help_function('wf/links/dmn.htm?DMND');
836: htp.headClose;
837: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_CONFIRMTITLE'), FALSE);
838: htp.br;

Line 837: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_CONFIRMTITLE'), FALSE);

833: htp.p('');
834: htp.title(wf_core.translate('ICX_CONFIRMTITLE'));
835: wfa_html.create_help_function('wf/links/dmn.htm?DMND');
836: htp.headClose;
837: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_CONFIRMTITLE'), FALSE);
838: htp.br;
839:
840: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
841: htp.tableOpen(calign=>'CENTER');

Line 844: htp.tabledata(wf_core.translate('ICX_CONFIRM_DELETE_MESSAGE') || ': ' ||

840: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
841: htp.tableOpen(calign=>'CENTER');
842: htp.tableRowOpen;
843: htp.tabledata('');
844: htp.tabledata(wf_core.translate('ICX_CONFIRM_DELETE_MESSAGE') || ': ' ||
845: ''||p_question_code||'');
846: htp.tableRowClose;
847: htp.tableClose;
848: htp.br;

Line 857: l_text := wf_core.translate ('WFMON_OK');

853: '?p_application_id='||p_application_id||
854: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
855: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
856: l_icon := 'FNDJLFOK.gif';
857: l_text := wf_core.translate ('WFMON_OK');
858: l_onmouseover := wf_core.translate ('WFMON_OK');
859:
860: htp.p('');
861: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 858: l_onmouseover := wf_core.translate ('WFMON_OK');

854: '&p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
855: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
856: l_icon := 'FNDJLFOK.gif';
857: l_text := wf_core.translate ('WFMON_OK');
858: l_onmouseover := wf_core.translate ('WFMON_OK');
859:
860: htp.p('');
861: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
862: htp.p('');

Line 866: l_text := wf_core.translate ('CANCEL');

862: htp.p('');
863:
864: l_url := icx_questions_admin.get_display_syntax (p_find_criteria);
865: l_icon := 'FNDJLFCN.gif';
866: l_text := wf_core.translate ('CANCEL');
867: l_onmouseover := wf_core.translate ('CANCEL');
868:
869: htp.p('');
870: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 867: l_onmouseover := wf_core.translate ('CANCEL');

863:
864: l_url := icx_questions_admin.get_display_syntax (p_find_criteria);
865: l_icon := 'FNDJLFCN.gif';
866: l_text := wf_core.translate ('CANCEL');
867: l_onmouseover := wf_core.translate ('CANCEL');
868:
869: htp.p('');
870: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
871: htp.p('');

Line 882: wf_core.context('icx_questions_admin', 'question_confirm_delete');

878:
879: exception
880: when others then
881: rollback;
882: wf_core.context('icx_questions_admin', 'question_confirm_delete');
883: icx_questions_admin.Error;
884: END Question_Confirm_Delete;
885:
886:

Line 911: wf_core.context('icx_questions_admin', 'delete_question');

907: bclose_header=>TRUE);
908:
909: exception
910: when others then
911: wf_core.context('icx_questions_admin', 'delete_question');
912: icx_questions_admin.error;
913:
914: END delete_question;
915:

Line 971: wf_lov.g_define_rec.add_attr1_title := wf_core.translate ('ICX_APPLICATION_FULLNAME');

967: WHERE application_short_name like UPPER(p_display_value||'%');
968:
969: wf_lov.g_define_rec.total_rows := l_total_rows;
970:
971: wf_lov.g_define_rec.add_attr1_title := wf_core.translate ('ICX_APPLICATION_FULLNAME');
972:
973: open c_application_lov (p_display_value||'%');
974:
975: LOOP

Line 1012: wf_core.context('Wfa_Html', 'wf_user_val');

1008:
1009: exception
1010: when others then
1011: rollback;
1012: wf_core.context('Wfa_Html', 'wf_user_val');
1013: raise;
1014: end application_lov;
1015:
1016: --

Line 1059: htp.title(wf_core.translate('ICX_FUNCTIONS_TITLE'));

1055: -- Set page title
1056: htp.htmlOpen;
1057: htp.headOpen;
1058: htp.p('');
1059: htp.title(wf_core.translate('ICX_FUNCTIONS_TITLE'));
1060: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1061: htp.headClose;
1062: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_FUNCTIONS_TITLE'), FALSE);
1063: htp.br;

Line 1062: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_FUNCTIONS_TITLE'), FALSE);

1058: htp.p('');
1059: htp.title(wf_core.translate('ICX_FUNCTIONS_TITLE'));
1060: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1061: htp.headClose;
1062: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions',wf_core.translate('ICX_FUNCTIONS_TITLE'), FALSE);
1063: htp.br;
1064:
1065: -- Column headers
1066: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');

Line 1070: wf_core.translate('ICX_QUESTION')||'',

1066: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
1067: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1068:
1069: htp.tableHeader(cvalue=>''||
1070: wf_core.translate('ICX_QUESTION')||'',
1071: calign=>'Center');
1072: htp.tableHeader(cvalue=>''||
1073: wf_core.translate('ICX_FUNCTION')||'',
1074: calign=>'Center');

Line 1073: wf_core.translate('ICX_FUNCTION')||'',

1069: htp.tableHeader(cvalue=>''||
1070: wf_core.translate('ICX_QUESTION')||'',
1071: calign=>'Center');
1072: htp.tableHeader(cvalue=>''||
1073: wf_core.translate('ICX_FUNCTION')||'',
1074: calign=>'Center');
1075: htp.tableHeader(cvalue=>''||
1076: wf_core.translate('ICX_USER_FUNCTION')||'',
1077: calign=>'Center');

Line 1076: wf_core.translate('ICX_USER_FUNCTION')||'',

1072: htp.tableHeader(cvalue=>''||
1073: wf_core.translate('ICX_FUNCTION')||'',
1074: calign=>'Center');
1075: htp.tableHeader(cvalue=>''||
1076: wf_core.translate('ICX_USER_FUNCTION')||'',
1077: calign=>'Center');
1078: htp.tableHeader(cvalue=>''||
1079: wf_core.translate('DELETE')||'',
1080: calign=>'Center');

Line 1079: wf_core.translate('DELETE')||'',

1075: htp.tableHeader(cvalue=>''||
1076: wf_core.translate('ICX_USER_FUNCTION')||'',
1077: calign=>'Center');
1078: htp.tableHeader(cvalue=>''||
1079: wf_core.translate('DELETE')||'',
1080: calign=>'Center');
1081: htp.tableRowClose;
1082: htp.tableRowOpen;
1083: htp.tableRowClose;

Line 1129: l_text := wf_core.translate ('WFDM_CREATE');

1125: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1126: '&p_insert=TRUE'||
1127: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1128: l_icon := 'FNDADD11.gif';
1129: l_text := wf_core.translate ('WFDM_CREATE');
1130: l_onmouseover := wf_core.translate ('WFDM_CREATE');
1131:
1132: htp.p('');
1133:

Line 1130: l_onmouseover := wf_core.translate ('WFDM_CREATE');

1126: '&p_insert=TRUE'||
1127: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1128: l_icon := 'FNDADD11.gif';
1129: l_text := wf_core.translate ('WFDM_CREATE');
1130: l_onmouseover := wf_core.translate ('WFDM_CREATE');
1131:
1132: htp.p('');
1133:
1134: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 1140: l_text := wf_core.translate ('ICX_RETURN_TO_QUESTIONS');

1136: htp.p('');
1137:
1138: l_url := icx_questions_admin.get_display_syntax (p_find_criteria);
1139: l_icon := 'FNDJLFCN.gif';
1140: l_text := wf_core.translate ('ICX_RETURN_TO_QUESTIONS');
1141: l_onmouseover := wf_core.translate ('ICX_RETURN_TO_QUESTIONS');
1142:
1143: htp.p('');
1144:

Line 1141: l_onmouseover := wf_core.translate ('ICX_RETURN_TO_QUESTIONS');

1137:
1138: l_url := icx_questions_admin.get_display_syntax (p_find_criteria);
1139: l_icon := 'FNDJLFCN.gif';
1140: l_text := wf_core.translate ('ICX_RETURN_TO_QUESTIONS');
1141: l_onmouseover := wf_core.translate ('ICX_RETURN_TO_QUESTIONS');
1142:
1143: htp.p('');
1144:
1145: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 1158: wf_core.context('icx_questions_admin', 'DISPLAY_FUNCTIONS');

1154: htp.htmlClose;
1155:
1156: exception
1157: when others then
1158: wf_core.context('icx_questions_admin', 'DISPLAY_FUNCTIONS');
1159: icx_questions_admin.error;
1160: end DISPLAY_FUNCTIONS;
1161:
1162:

Line 1186: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');

1182: l_username varchar2(80);
1183: l_media varchar2(240) := wfa_html.image_loc;
1184: l_icon varchar2(30) := 'FNDILOV.gif';
1185: l_text varchar2(30) := '';
1186: l_onmouseover varchar2(30) := wf_core.translate ('WFPREF_LOV');
1187: l_url varchar2(4000);
1188: l_error_msg varchar2(240);
1189:
1190: BEGIN

Line 1216: htp.title(wf_core.translate('ICX_EDIT_FUNCTION_TITLE'));

1212:
1213: -- Set page title
1214: htp.htmlOpen;
1215: htp.headOpen;
1216: htp.title(wf_core.translate('ICX_EDIT_FUNCTION_TITLE'));
1217: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
1218: fnd_document_management.get_open_dm_display_window;
1219: wf_lov.OpenLovWinHtml;
1220:

Line 1224: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions', wf_core.translate('ICX_EDIT_FUNCTION_TITLE'), TRUE);

1220:
1221: htp.headClose;
1222:
1223: -- Page header
1224: wfa_sec.Header(FALSE, 'icx_questions_admin.find_questions', wf_core.translate('ICX_EDIT_FUNCTION_TITLE'), TRUE);
1225:
1226: -- Print the error message if there is one
1227: if (P_ERROR_MESSAGE IS NOT NULL) THEN
1228:

Line 1230: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');

1226: -- Print the error message if there is one
1227: if (P_ERROR_MESSAGE IS NOT NULL) THEN
1228:
1229: htp.br;
1230: htp.p(''||wf_core.translate(P_ERROR_MESSAGE)||'');
1231: htp.br;
1232:
1233: end if;
1234:

Line 1253: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),

1249: htp.formHidden(cname=>'p_find_criteria', cvalue=>p_find_criteria);
1250:
1251: -- Question Code
1252: htp.tableRowOpen;
1253: htp.tableData(cvalue=>wf_core.translate('ICX_QUESTION_CODE'),
1254: calign=>'right');
1255:
1256: htp.formHidden(cname=>'p_question_code', cvalue=>p_question_code);
1257:

Line 1266: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION'),

1262: htp.tableRowClose;
1263:
1264: -- Function Name
1265: htp.tableRowOpen;
1266: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION'),
1267: calign=>'right');
1268:
1269: -- add LOV here: Note:bottom is name of frame.
1270: -- Note: The REPLACE function replaces all the space characters with

Line 1274: '&p_display_name='||wf_core.translate('ICX_FUNCTION')||

1270: -- Note: The REPLACE function replaces all the space characters with
1271: -- the proper escape sequence.
1272: l_url := 'javascript:fnd_open_dm_display_window('||''''||
1273: REPLACE('wf_lov.display_lov?p_lov_name='||'functions'||
1274: '&p_display_name='||wf_core.translate('ICX_FUNCTION')||
1275: '&p_validation_callback=icx_questions_admin.function_lov'||
1276: '&p_dest_hidden_field=top.opener.document.ICX_EDIT_FUNCTION.p_function_name.value'||
1277: '&p_current_value=top.opener.document.ICX_EDIT_FUNCTION.p_function_name.value'||
1278: '&p_dest_display_field=top.opener.document.ICX_EDIT_FUNCTION.p_function_name.value',

Line 1292: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION_DESCRIPTION'),

1288: htp.tablerowclose;
1289:
1290: -- Function Desciption
1291: htp.tableRowOpen;
1292: htp.tableData(cvalue=>wf_core.translate('ICX_FUNCTION_DESCRIPTION'),
1293: calign=>'right');
1294:
1295: htp.tableData(htf.formText(cname=>'p_user_function_name', csize=>'40',
1296: cvalue=>l_user_function_name, cmaxlength=>'240'));

Line 1312: l_text := wf_core.translate ('WFMON_OK');

1308: htp.tableRowOpen;
1309:
1310: l_url := 'javascript:document.ICX_EDIT_FUNCTION.submit()';
1311: l_icon := 'FNDJLFOK.gif';
1312: l_text := wf_core.translate ('WFMON_OK');
1313: l_onmouseover := wf_core.translate ('WFMON_OK');
1314:
1315: htp.p('');
1316:

Line 1313: l_onmouseover := wf_core.translate ('WFMON_OK');

1309:
1310: l_url := 'javascript:document.ICX_EDIT_FUNCTION.submit()';
1311: l_icon := 'FNDJLFOK.gif';
1312: l_text := wf_core.translate ('WFMON_OK');
1313: l_onmouseover := wf_core.translate ('WFMON_OK');
1314:
1315: htp.p('');
1316:
1317: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 1325: l_text := wf_core.translate ('CANCEL');

1321: l_url := wfa_html.base_url||'/'||'icx_questions_admin.display_functions'||
1322: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1323: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1324: l_icon := 'FNDJLFCN.gif';
1325: l_text := wf_core.translate ('CANCEL');
1326: l_onmouseover := wf_core.translate ('CANCEL');
1327:
1328: htp.p('');
1329:

Line 1326: l_onmouseover := wf_core.translate ('CANCEL');

1322: '?p_question_code='||wfa_html.conv_special_url_chars(p_question_code)||
1323: '&p_find_criteria='||wfa_html.conv_special_url_chars(p_find_criteria);
1324: l_icon := 'FNDJLFCN.gif';
1325: l_text := wf_core.translate ('CANCEL');
1326: l_onmouseover := wf_core.translate ('CANCEL');
1327:
1328: htp.p('');
1329:
1330: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 1346: wf_core.context('icx_questions_admin', 'edit_function');

1342:
1343:
1344: exception
1345: when others then
1346: wf_core.context('icx_questions_admin', 'edit_function');
1347: icx_questions_admin.error;
1348:
1349: END edit_function;
1350:

Line 1406: wf_lov.g_define_rec.add_attr1_title := wf_core.translate ('ICX_USER_FUNCTION');

1402: WHERE FND.FUNCTION_NAME like upper(p_display_value||'%');
1403:
1404: wf_lov.g_define_rec.total_rows := l_total_rows;
1405:
1406: wf_lov.g_define_rec.add_attr1_title := wf_core.translate ('ICX_USER_FUNCTION');
1407:
1408: open c_function_lov (p_display_value||'%');
1409:
1410: LOOP

Line 1447: wf_core.context('Wfa_Html', 'wf_user_val');

1443:
1444: exception
1445: when others then
1446: rollback;
1447: wf_core.context('Wfa_Html', 'wf_user_val');
1448: raise;
1449: end function_lov;
1450:
1451:

Line 1537: wf_core.context('icx_questions_admin', 'insert_function');

1533: end if;
1534:
1535: exception
1536: when others then
1537: wf_core.context('icx_questions_admin', 'insert_function');
1538: icx_questions_admin.error;
1539:
1540: END insert_function;
1541:

Line 1618: wf_core.context('icx_questions_admin', 'update_function');

1614: end if;
1615:
1616: exception
1617: when others then
1618: wf_core.context('icx_questions_admin', 'update_function');
1619: icx_questions_admin.error;
1620:
1621: END update_function;
1622:

Line 1653: wf_core.context('icx_questions_admin', 'delete_function');

1649: bclose_header=>TRUE);
1650:
1651: exception
1652: when others then
1653: wf_core.context('icx_questions_admin', 'delete_function');
1654: icx_questions_admin.error;
1655:
1656: END delete_function;
1657: