366: l_submit:=icx_cabo.g_plsql_agent||'OracleON.IC'; --mputman added 1747066
367:
368: if instr(l_icx_custom_call,'LONG') > 0
369: then
370: fnd_message.set_name('ICX','ICX_OPEN_QUERY2');
371: l_message := icx_util.replace_quotes(fnd_message.get);
372:
373: if p_lines_now = 1
374: then
367:
368: if instr(l_icx_custom_call,'LONG') > 0
369: then
370: fnd_message.set_name('ICX','ICX_OPEN_QUERY2');
371: l_message := icx_util.replace_quotes(fnd_message.get);
372:
373: if p_lines_now = 1
374: then
375: htp.p('function submitFunction() {
424: end if;
425:
426:
427: ELSE -- end block blind
428: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
429: l_message := icx_util.replace_quotes(fnd_message.get);
430:
431: if p_lines_now = 1
432: then
425:
426:
427: ELSE -- end block blind
428: fnd_message.set_name('ICX','ICX_OPEN_QUERY');
429: l_message := icx_util.replace_quotes(fnd_message.get);
430:
431: if p_lines_now = 1
432: then
433: htp.p('function submitFunction() {
516: */
517:
518: if l_data_type1 = 'V'
519: then
520: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');
521: l_message := fnd_message.get;
522: else
523: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
524: l_message := fnd_message.get;
517:
518: if l_data_type1 = 'V'
519: then
520: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');
521: l_message := fnd_message.get;
522: else
523: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
524: l_message := fnd_message.get;
525: end if;
519: then
520: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');
521: l_message := fnd_message.get;
522: else
523: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
524: l_message := fnd_message.get;
525: end if;
526:
527: /*
520: fnd_message.set_name('ICX','ICX_FIND_VARCHAR2');
521: l_message := fnd_message.get;
522: else
523: fnd_message.set_name('ICX','ICX_FIND_NUMBER');
524: l_message := fnd_message.get;
525: end if;
526:
527: /*
528: htp.tableOpen('BORDER=0');
557: htp.nl;
558:
559: if p_lines_now > 1
560: then
561: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
562: htp.p(fnd_message.get);htp.nl;
563:
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
558:
559: if p_lines_now > 1
560: then
561: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
562: htp.p(fnd_message.get);htp.nl;
563:
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
566:
560: then
561: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
562: htp.p(fnd_message.get);htp.nl;
563:
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
566:
567: fnd_message.set_name('ICX','ICX_FIND_OR');
568: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
561: fnd_message.set_name('ICX','ICX_FIND_AND_OR_TEXT');
562: htp.p(fnd_message.get);htp.nl;
563:
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
566:
567: fnd_message.set_name('ICX','ICX_FIND_OR');
568: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
569: end if;
563:
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
566:
567: fnd_message.set_name('ICX','ICX_FIND_OR');
568: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
569: end if;
570:
571: htp.p('');
564: fnd_message.set_name('ICX','ICX_FIND_AND');
565: htp.p(htf.formRadio('o','AND','CHECKED')||fnd_message.get);htp.nl;
566:
567: fnd_message.set_name('ICX','ICX_FIND_OR');
568: htp.p(htf.formRadio('o','OR')||fnd_message.get);htp.nl;
569: end if;
570:
571: htp.p('');
572:
602: end if;
603:
604: if l_matchcase_view = 'Hidden'
605: then
606: fnd_message.set_name('ICX','ICX_MATCHCASE_VIEW');
607: l_message := fnd_message.get;
608: htp.p(l_message);
609: htp.p(htf.formHidden('m','CHECKED'));
610: htp.nl;
603:
604: if l_matchcase_view = 'Hidden'
605: then
606: fnd_message.set_name('ICX','ICX_MATCHCASE_VIEW');
607: l_message := fnd_message.get;
608: htp.p(l_message);
609: htp.p(htf.formHidden('m','CHECKED'));
610: htp.nl;
611: end if;
746:
747: if ak_query_pkg.g_results_table.COUNT = 0
748: then
749: htp.p('');
750: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
752: l_message := fnd_message.get;
753:
754: htp.strong(l_message);htp.nl;
747: if ak_query_pkg.g_results_table.COUNT = 0
748: then
749: htp.p('');
750: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
752: l_message := fnd_message.get;
753:
754: htp.strong(l_message);htp.nl;
755:
748: then
749: htp.p('');
750: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
751: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(0).name);
752: l_message := fnd_message.get;
753:
754: htp.strong(l_message);htp.nl;
755:
756: else
813: htp.p('');
814:
815: if ak_query_pkg.g_regions_table(r).total_result_count = 0
816: then
817: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
818: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
819: l_message := fnd_message.get;
820:
821: htp.strong(l_message);htp.nl;
814:
815: if ak_query_pkg.g_regions_table(r).total_result_count = 0
816: then
817: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
818: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
819: l_message := fnd_message.get;
820:
821: htp.strong(l_message);htp.nl;
822:
815: if ak_query_pkg.g_regions_table(r).total_result_count = 0
816: then
817: fnd_message.set_name('ICX','ICX_NO_RECORDS_FOUND');
818: fnd_message.set_token('NAME_OF_REGION_TOKEN',ak_query_pkg.g_regions_table(r).name);
819: l_message := fnd_message.get;
820:
821: htp.strong(l_message);htp.nl;
822:
823: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
822:
823: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
824: and ak_query_pkg.g_regions_table(r).total_result_count > 1
825: then
826: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
827: l_message := fnd_message.get;
828:
829: htp.strong(l_message);
830: l_continue := FALSE;
823: elsif ak_query_pkg.g_regions_table(r).region_style = 'FORM'
824: and ak_query_pkg.g_regions_table(r).total_result_count > 1
825: then
826: fnd_message.set_name('ICX','ICX_LIMIT_ROWS_ONE');
827: l_message := fnd_message.get;
828:
829: htp.strong(l_message);
830: l_continue := FALSE;
831: else