157: end if; -- if p_results_tbl.count is zero
158:
159: EXCEPTION
160: WHEN BIS_GNRL_SEARCH_ENGINE_PVT_OA.e_noIndexDefined THEN RAISE;
161: WHEN OTHERS THEN htp.p(SQLERRM);
162:
163: END results_page;
164:
165: -- *********************************************************
180:
181: --ICX_UTIL.getPrompts(191, 'BIS_BVC_PROMPTS, l_title, l_prompts);
182: --l_submit := l_prompts(5);
183:
184: htp.htmlopen;
185: htp.headopen;
186: htp.title( c_title );
187: htp.headclose;
188: htp.p('
181: --ICX_UTIL.getPrompts(191, 'BIS_BVC_PROMPTS, l_title, l_prompts);
182: --l_submit := l_prompts(5);
183:
184: htp.htmlopen;
185: htp.headopen;
186: htp.title( c_title );
187: htp.headclose;
188: htp.p('
182: --l_submit := l_prompts(5);
183:
184: htp.htmlopen;
185: htp.headopen;
186: htp.title( c_title );
187: htp.headclose;
188: htp.p('
194: , p_disp_mainmenu => 'Y'
195: , p_disp_menu => 'N'
196: );
197: htp.p('');
198: htp.p('
196: );
197: htp.p('
197: htp.p('
198: htp.p('
'); 202: htp.p(' '); 203: htp.p(' | ');
'); 202: htp.p(' '); 203: htp.p(' | ');
'); 216: htp.p('
Line 247: htp.p(' | ');|||||||||||||||||||||||||||||||
'); 246: htp.p(' '); 247: htp.p(' | ');
236: -- ****************** CLOSE FORM ******************************
237:
238: htp.p('
237:
238: htp.p('
244: htp.p('
246: htp.p('
');
247: htp.p(' ');
248: htp.p(' ');
249:
250: htp.p('
251:
252:
253: EXCEPTION
254: WHEN OTHERS THEN
255: htp.p( SQLERRM );
256:
257: END enter_query_page;
258:
259: -- **********************************************************
425: -- *********************************************************
426: ELSE -- If no keywords entered in the box
427: -- Print out the keywords entry box again for future tries
428: enter_query_page( p_keywords, p_lang );
429: htp.bodyClose;
430: htp.htmlClose;
431:
432: END IF; -- endif for l_length of the keywords entered not equal to zero
433: -- *********************************************************
426: ELSE -- If no keywords entered in the box
427: -- Print out the keywords entry box again for future tries
428: enter_query_page( p_keywords, p_lang );
429: htp.bodyClose;
430: htp.htmlClose;
431:
432: END IF; -- endif for l_length of the keywords entered not equal to zero
433: -- *********************************************************
434:
440: WHEN BIS_GNRL_SEARCH_ENGINE_PVT.e_noIndexDefined THEN
441: -- The following message need not be translated since this is a propagated error
442: -- due to undefined InterMedia domain Index. The Preferences and Indexes must
443: -- be created first, for the Business Views Catalog Search region to work !!
444: htp.p('
');
445: htp.p('ERROR : InterMedia Index Not Created in Language - '||p_lang||'
');
446: htp.p('Please run BISPBVI.sql in the Discoverer eul schema with appropriate Language code as parameter.'||'
');
447: WHEN OTHERS THEN
448: rollback;
441: -- The following message need not be translated since this is a propagated error
442: -- due to undefined InterMedia domain Index. The Preferences and Indexes must
443: -- be created first, for the Business Views Catalog Search region to work !!
444: htp.p('
');
445: htp.p('ERROR : InterMedia Index Not Created in Language - '||p_lang||'
');
446: htp.p('Please run BISPBVI.sql in the Discoverer eul schema with appropriate Language code as parameter.'||'
');
447: WHEN OTHERS THEN
448: rollback;
449: raise;
442: -- due to undefined InterMedia domain Index. The Preferences and Indexes must
443: -- be created first, for the Business Views Catalog Search region to work !!
444: htp.p('
');
445: htp.p('ERROR : InterMedia Index Not Created in Language - '||p_lang||'
');
446: htp.p('Please run BISPBVI.sql in the Discoverer eul schema with appropriate Language code as parameter.'||'
');
447: WHEN OTHERS THEN
448: rollback;
449: raise;
450: END query;
474: results_page( p_results_tbl => p_results_tbl
475: ,p_lang => p_lang);
476: */
477:
478: htp.headopen;
479: htp.p('');
482: htp.headclose;
477:
478: htp.headopen;
479: htp.p('');
482: htp.headclose;
483:
484: htp.p('');
485: htp.p('
478: htp.headopen;
479: htp.p('');
482: htp.headclose;
483:
484: htp.p('');
485: htp.p('
480: icx_admin_sig.help_win_script('ASKORA', null, 'FND');
481: htp.p('');
482: htp.headclose;
483:
484: htp.p('');
485: htp.p('
481: htp.p('');
482: htp.headclose;
483:
484: htp.p('');
485: htp.p('');
486: htp.p('
490: -- enter_query_page( p_keywords => p_keywords
491: -- , p_lang => p_lang);
492: htp.p('
491: -- , p_lang => p_lang);
492: htp.p('
492: htp.p('