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
292: it is set to 'No' in the next line
293: */
291: /* Profile for fuzzy search is defaulted to 'No' so if found to be null
292: it is set to 'No' in the next line
293: */
294:
295: l_use_fuzzy_search := FND_PROFILE.VALUE_specific('IBE_FUZZY_SEARCH',671,0,671);
296:
297: if(l_use_fuzzy_search is null )
298: then
299: l_use_fuzzy_search := 'N' ;
306: if (G_TEST_FLAG_ON) --{
307: then
308: l_search_category_set := G_TEST_SEARCH_CATEGORY_SET;
309: else
310: l_search_category_set := FND_PROFILE.VALUE_specific('IBE_SEARCH_CATEGORY_SET',671,0,671);
311: end if; --}
312:
313: --Get product status profile IBE_SEARCH_WEB_STATUS;
314: if (G_TEST_FLAG_ON)
314: if (G_TEST_FLAG_ON)
315: then
316: l_search_web_status := G_TEST_SEARCH_WEB_STATUS;
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);