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 243: FND_FILE.PUT_LINE(FND_FILE.LOG,' DB VErsion ='||l_db_version_str);

239: where index_name = 'IBE_CT_IMEDIA_SEARCH_IM';
240:
241:
242: DBMS_UTILITY.db_version(l_db_version_str, l_compatibility);
243: FND_FILE.PUT_LINE(FND_FILE.LOG,' DB VErsion ='||l_db_version_str);
244:
245: If (l_db_version_str is null) Then
246: l_db_version := 8;
247: Else

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

251:
252: if(l_index_exists > 0 )
253: then
254:
255: FND_FILE.PUT_LINE(FND_FILE.LOG,' Intermedia index exists , dropping intermedia index ');
256: ------dbms_output.put_line(' Intermedia index exists , dropping intermedia index ');
257: execute immediate 'drop index IBE_CT_IMEDIA_SEARCH_IM force';
258: end if ;
259:

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

256: ------dbms_output.put_line(' Intermedia index exists , dropping intermedia index ');
257: execute immediate 'drop index IBE_CT_IMEDIA_SEARCH_IM force';
258: end if ;
259:
260: FND_FILE.PUT_LINE(FND_FILE.LOG,' deleting data from Search table ');
261: --dbms_output.put_line(' deleting data from Search table ');
262:
263: /* Added by amahsehw - bug 12980419 - UNABLE TO SEARCH PRODUCT USING PRODUCT NUMBER
264: --truncatapplication_short_name

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

281: end if;
282:
283: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
284:
285: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
286: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
287: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
288:
289: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);

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

282:
283: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
284:
285: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
286: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
287: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
288:
289: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
290:

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

283: ----dbms_output.put_line(' Populating search table IBE_CT_IMEDIA_SEARCH');
284:
285: FND_FILE.PUT_LINE(FND_FILE.LOG,' Populating search table IBE_CT_IMEDIA_SEARCH');
286: FND_FILE.PUT_LINE(FND_FILE.LOG,' This may take a while depending on how many rows');
287: FND_FILE.PUT_LINE(FND_FILE.LOG,' you have in mtl_system_items_tl table');
288:
289: l_use_category_search := FND_PROFILE.VALUE_specific('IBE_USE_CATEGORY_SEARCH',671,0,671);
290:
291: /* Profile for fuzzy search is defaulted to 'No' so if found to be null

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

298: then
299: l_use_fuzzy_search := 'N' ;
300: end if ;
301:
302: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_USE_CATEGORY_SEARCH = ' || l_use_category_search );
303: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_FUZZY_SEARCH = ' || l_use_fuzzy_search );
304:
305: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
306: if (G_TEST_FLAG_ON) --{

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

299: l_use_fuzzy_search := 'N' ;
300: end if ;
301:
302: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_USE_CATEGORY_SEARCH = ' || l_use_category_search );
303: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_FUZZY_SEARCH = ' || l_use_fuzzy_search );
304:
305: --Get Search Category Set profile IBE_SEARCH_CATEGORY_SET;
306: if (G_TEST_FLAG_ON) --{
307: then

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

317: else
318: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
319: end if; --}
320:
321: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_CATEGORY_SET = ' || l_search_category_set);
322: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_WEB_STATUS = ' || l_search_web_status);
323:
324: -----------
325:

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

318: l_search_web_status := FND_PROFILE.VALUE_specific('IBE_SEARCH_WEB_STATUS',671,0,671);
319: end if; --}
320:
321: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_CATEGORY_SET = ' || l_search_category_set);
322: FND_FILE.PUT_LINE(FND_FILE.LOG,' IBE_SEARCH_WEB_STATUS = ' || l_search_web_status);
323:
324: -----------
325:
326:

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

576: for dropit in old_sub_lexers loop
577: ctx_ddl.drop_preference(dropit.pre_name);
578: end loop;
579:
580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating GLobal Lexer ');
581:
582: ctx_ddl.create_preference('ibe_global_lexer','multi_lexer');
583:
584: ctx_ddl.create_preference('ibe_lobs_blexer', 'basic_lexer');

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

635:
636: if(l_fuzzy_count = 1 )
637: then
638: Ctx_Ddl.Drop_Preference('IBE_STEM_FUZZY_PREF');
639: FND_FILE.PUT_LINE(FND_FILE.LOG,' Dropped existing IBE_STEM_FUZZY_PREF preference ');
640: end if ;
641:
642: Ctx_Ddl.Create_Preference('IBE_STEM_FUZZY_PREF', 'BASIC_WORDLIST');
643: /* Changed from l_base_language to 'AUTO' to support muliple languages fuzzy 06/07/01

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

650:
651:
652:
653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table with fuzzy ');
655: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
656: execute immediate l_create_fuzzy_index;
657:
658:

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

651:
652:
653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table with fuzzy ');
655: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
656: execute immediate l_create_fuzzy_index;
657:
658:
659: else

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

656: execute immediate l_create_fuzzy_index;
657:
658:
659: else
660: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table');
661: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
662:
663: execute immediate l_create_index;
664:

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

657:
658:
659: else
660: FND_FILE.PUT_LINE(FND_FILE.LOG,' Creating intermedia index on IBE_CT_IMEDIA_SEARCH table');
661: FND_FILE.PUT_LINE(FND_FILE.LOG,'This may take a while ');
662:
663: execute immediate l_create_index;
664:
665: end if;

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

663: execute immediate l_create_index;
664:
665: end if;
666:
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Intermedia Index created , procedure completed sucessfully');
668: ----dbms_output.put_line('Intermedia Index created , procedure completed sucessfully');
669: end Search_Move_Data;
670:
671: end ibe_search_setup_pvt ;