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.IBE_SEARCH_SETUP_PVT dependencies on FND_FILE

Line 205: FND_FILE.PUT_LINE(FND_FILE.LOG,' DB VErsion ='||l_db_version_str);

201: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';
202:
203:
204: DBMS_UTILITY.db_version(l_db_version_str, l_compatibility);
205: FND_FILE.PUT_LINE(FND_FILE.LOG,' DB VErsion ='||l_db_version_str);
206:
207: If (l_db_version_str is null) Then
208: l_db_version := 8;
209: Else

Line 217: FND_FILE.PUT_LINE(FND_FILE.LOG,' Intermedia index exists , dropping intermedia index ');

213:
214: if(l_index_exists > 0 )
215: then
216:
217: FND_FILE.PUT_LINE(FND_FILE.LOG,' Intermedia index exists , dropping intermedia index ');
218: ------dbms_output.put_line(' Intermedia index exists , dropping intermedia index ');
219: execute immediate 'drop index IBE_CT_IMEDIA_SEARCH_IM force';
220: end if ;
221:

Line 222: FND_FILE.PUT_LINE(FND_FILE.LOG,' deleting data from Search table ');

218: ------dbms_output.put_line(' Intermedia index exists , dropping intermedia index ');
219: execute immediate 'drop index IBE_CT_IMEDIA_SEARCH_IM force';
220: end if ;
221:
222: FND_FILE.PUT_LINE(FND_FILE.LOG,' deleting data from Search table ');
223: --dbms_output.put_line(' deleting data from Search table ');
224:
225:
226: --truncatapplication_short_name

Line 244: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');

240: end if;
241:
242: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
245: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
246: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
247:
248: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);

Line 245: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');

241:
242: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
245: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
246: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
247:
248: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
249:

Line 246: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');

242: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
243:
244: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
245: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
246: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
247:
248: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
249:
250: /* Profile for fuzzy search is defaulted to 'No' so if found to be null

Line 261: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_USE_CATEGORY_SEARCH = ' || l_use_category_search );

257: then
258: l_use_fuzzy_search := 'N' ;
259: end if ;
260:
261: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_USE_CATEGORY_SEARCH = ' || l_use_category_search );
262: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_FUZZY_SEARCH = ' || l_use_fuzzy_search );
263:
264: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
265: if (G_TEST_FLAG_ON) --{

Line 262: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_FUZZY_SEARCH = ' || l_use_fuzzy_search );

258: l_use_fuzzy_search := 'N' ;
259: end if ;
260:
261: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_USE_CATEGORY_SEARCH = ' || l_use_category_search );
262: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_FUZZY_SEARCH = ' || l_use_fuzzy_search );
263:
264: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
265: if (G_TEST_FLAG_ON) --{
266: then

Line 280: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_CATEGORY_SET = ' || l_search_category_set);

276: else
277: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
278: end if; --}
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_CATEGORY_SET = ' || l_search_category_set);
281: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_WEB_STATUS = ' || l_search_web_status);
282:
283: -----------
284:

Line 281: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_WEB_STATUS = ' || l_search_web_status);

277: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
278: end if; --}
279:
280: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_CATEGORY_SET = ' || l_search_category_set);
281: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_WEB_STATUS = ' || l_search_web_status);
282:
283: -----------
284:
285:

Line 539: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating GLobal Lexer ');

535: for dropit in old_sub_lexers loop
536: ctx_ddl.drop_preference(dropit.pre_name);
537: end loop;
538:
539: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating GLobal Lexer ');
540:
541: ctx_ddl.create_preference('ibe_global_lexer','multi_lexer');
542:
543: ctx_ddl.create_preference('ibe_lobs_blexer', 'basic_lexer');

Line 598: FND_FILE.PUT_LINE(FND_FILE.LOG,' Dropped existing IBE_STEM_FUZZY_PREF preference ');

594:
595: if(l_fuzzy_count = 1 )
596: then
597: Ctx_Ddl.Drop_Preference('IBE_STEM_FUZZY_PREF');
598: FND_FILE.PUT_LINE(FND_FILE.LOG,' Dropped existing IBE_STEM_FUZZY_PREF preference ');
599: end if ;
600:
601: Ctx_Ddl.Create_Preference('IBE_STEM_FUZZY_PREF', 'BASIC_WORDLIST');
602: /* Changed from l_base_language to 'AUTO' to support muliple languages fuzzy 06/07/01

Line 612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table with fuzzy ');

608:
609:
610:
611:
612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table with fuzzy ');
613: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
614: execute immediate l_create_fuzzy_index;
615:
616:

Line 613: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');

609:
610:
611:
612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table with fuzzy ');
613: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
614: execute immediate l_create_fuzzy_index;
615:
616:
617: else

Line 618: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table');

614: execute immediate l_create_fuzzy_index;
615:
616:
617: else
618: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table');
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
620:
621: execute immediate l_create_index;
622:

Line 619: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');

615:
616:
617: else
618: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table');
619: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
620:
621: execute immediate l_create_index;
622:
623: end if;

Line 625: FND_FILE.PUT_LINE(FND_FILE.LOG,'Intermedia Index created , procedure completed sucessfully');

621: execute immediate l_create_index;
622:
623: end if;
624:
625: FND_FILE.PUT_LINE(FND_FILE.LOG,'Intermedia Index created , procedure completed sucessfully');
626: ----dbms_output.put_line('Intermedia Index created , procedure completed sucessfully');
627: end Search_Move_Data;
628:
629: end ibe_search_setup_pvt ;