APPS.IBE_SEARCHUPDATE_PVT dependencies on FND_FILE

Line 233: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inserting into IBE_SECTION_SEARCH_PART' );

229: for v_CompoundData in compCur loop --{
230: open allTopLevelSections(v_CompoundData.MSITE_ID,v_CompoundData.MSITE_ROOT_SECTION_ID);
231: fetch allTopLevelSections bulk collect into l_toplevel_section_tbl;
232: close allTopLevelSections;
233: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inserting into IBE_SECTION_SEARCH_PART' );
234:
235: forall l_count2 in 1..l_toplevel_section_tbl.count
236: -- removed on 08/28/01 the minus for parent sections , this is because
237: -- anyway the parent sections cannot have items , look at bug 1917056

Line 329: FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling Alter table exchange partition' );

325: where inventory_item_id = r2.inventory_item_id
326: and minisite_id = x_msite_ids(i).msite_id;
327: END LOOP; -- end loop r2
328: END LOOP; -- end loop i
329: FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling Alter table exchange partition' );
330:
331: if (fnd_installation.get_app_info(l_application_short_name,
332: l_status_AppInfo ,
333: l_industry_AppInfo ,

Line 430: FND_FILE.PUT_LINE(FND_FILE.LOG,' the loop index after insert is = ' || l_tmp );

426: )t ;
427:
428: commit;
429:
430: FND_FILE.PUT_LINE(FND_FILE.LOG,' the loop index after insert is = ' || l_tmp );
431: ----dbms_output.put_line(' the loop index after insert is = ' || l_tmp );
432: ----dbms_output.put_line('sequence value='||l_sequence);
433: l_sequence:=l_sequence+1;
434: l_tmp:=l_tmp+1;

Line 446: FND_FILE.PUT_LINE(FND_FILE.LOG,' Sync the intermedia index' );

442:
443: if(l_index_exists > 0 ) then
444: ----dbms_output.put_line('Before synchronizing the index');
445: --Synchronize the IBE_CT_IMEDIA_SEARCH_IM index by calling inter media synchronize procedure;
446: FND_FILE.PUT_LINE(FND_FILE.LOG,' Sync the intermedia index' );
447:
448: ctx_ddl.sync_index('IBE_CT_IMEDIA_SEARCH_IM');
449:
450: End if;

Line 455: FND_FILE.PUT_LINE(FND_FILE.LOG,'Procedure completed sucessfully');

451: End if;
452: End if;
453:
454: --==========end ab =======================================
455: FND_FILE.PUT_LINE(FND_FILE.LOG,'Procedure completed sucessfully');
456: end loadMsitesSectionItemsTable;
457:
458:
459: end IBE_SearchUpdate_PVT ;