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.EAM_TEXT_INDEX_PVT dependencies on FND_LOG

Line 83: IF ( g_Log_File_Flag AND p_Log_Type >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

79: , p_Log_Type IN NUMBER
80: , p_Module IN VARCHAR2 )
81: IS
82: BEGIN
83: IF ( g_Log_File_Flag AND p_Log_Type >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
84: FOR l IN 0 .. ( FLOOR( (NVL(LENGTH(p_Buffer),0) - 1)/240 ) ) LOOP
85: FND_LOG.STRING(p_Log_Type, p_module, SUBSTRB(p_Buffer, l*240 + 1, 240));
86: --FND_FILE.Put_Line (FND_FILE.Log, SUBSTRB(p_Buffer, l*240 + 1, 240));
87: END LOOP;

Line 85: FND_LOG.STRING(p_Log_Type, p_module, SUBSTRB(p_Buffer, l*240 + 1, 240));

81: IS
82: BEGIN
83: IF ( g_Log_File_Flag AND p_Log_Type >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
84: FOR l IN 0 .. ( FLOOR( (NVL(LENGTH(p_Buffer),0) - 1)/240 ) ) LOOP
85: FND_LOG.STRING(p_Log_Type, p_module, SUBSTRB(p_Buffer, l*240 + 1, 240));
86: --FND_FILE.Put_Line (FND_FILE.Log, SUBSTRB(p_Buffer, l*240 + 1, 240));
87: END LOOP;
88: END IF;
89:

Line 190: Log_Line (l_api_name || ': standalone execution', FND_LOG.LEVEL_EVENT, l_api_name);

186:
187: IF ( NVL(FND_GLOBAL.CONC_REQUEST_ID,-1) < 0 ) THEN
188: g_Conc_Req_flag := FALSE;
189: FND_FILE.Put_Names (g_Log_File, g_Out_File, g_Log_Dir);
190: Log_Line (l_api_name || ': standalone execution', FND_LOG.LEVEL_EVENT, l_api_name);
191: ELSE
192: Log_Line (l_api_name || ': concurrent request', FND_LOG.LEVEL_EVENT, l_api_name);
193: END IF;
194:

Line 192: Log_Line (l_api_name || ': concurrent request', FND_LOG.LEVEL_EVENT, l_api_name);

188: g_Conc_Req_flag := FALSE;
189: FND_FILE.Put_Names (g_Log_File, g_Out_File, g_Log_Dir);
190: Log_Line (l_api_name || ': standalone execution', FND_LOG.LEVEL_EVENT, l_api_name);
191: ELSE
192: Log_Line (l_api_name || ': concurrent request', FND_LOG.LEVEL_EVENT, l_api_name);
193: END IF;
194:
195: Log_Line (l_api_name || ': log mode: ' || g_Log_Mode, FND_LOG.LEVEL_EVENT, l_api_name);
196: Log_Line (l_api_name || ': dump directory: ' || g_Dump_Dir, FND_LOG.LEVEL_EVENT, l_api_name);

Line 195: Log_Line (l_api_name || ': log mode: ' || g_Log_Mode, FND_LOG.LEVEL_EVENT, l_api_name);

191: ELSE
192: Log_Line (l_api_name || ': concurrent request', FND_LOG.LEVEL_EVENT, l_api_name);
193: END IF;
194:
195: Log_Line (l_api_name || ': log mode: ' || g_Log_Mode, FND_LOG.LEVEL_EVENT, l_api_name);
196: Log_Line (l_api_name || ': dump directory: ' || g_Dump_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
197: Log_Line (l_api_name || ': CTX log directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
198:
199: RETURN (NULL);

Line 196: Log_Line (l_api_name || ': dump directory: ' || g_Dump_Dir, FND_LOG.LEVEL_EVENT, l_api_name);

192: Log_Line (l_api_name || ': concurrent request', FND_LOG.LEVEL_EVENT, l_api_name);
193: END IF;
194:
195: Log_Line (l_api_name || ': log mode: ' || g_Log_Mode, FND_LOG.LEVEL_EVENT, l_api_name);
196: Log_Line (l_api_name || ': dump directory: ' || g_Dump_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
197: Log_Line (l_api_name || ': CTX log directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
198:
199: RETURN (NULL);
200:

Line 197: Log_Line (l_api_name || ': CTX log directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);

193: END IF;
194:
195: Log_Line (l_api_name || ': log mode: ' || g_Log_Mode, FND_LOG.LEVEL_EVENT, l_api_name);
196: Log_Line (l_api_name || ': dump directory: ' || g_Dump_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
197: Log_Line (l_api_name || ': CTX log directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
198:
199: RETURN (NULL);
200:
201: END set_Log_Mode;

Line 245: Log_Line (l_api_name || ': begin', FND_LOG.LEVEL_EVENT, l_api_name);

241: --Lang_ISO_List Lang_ISO_List_type :=
242: -- Lang_ISO_List_type ('EN', '', 'DE', 'SV', 'NO', 'FR', '', '');
243:
244: BEGIN
245: Log_Line (l_api_name || ': begin', FND_LOG.LEVEL_EVENT, l_api_name);
246:
247: l_return_status := G_STATUS_SUCCESS;
248:
249: ------------------------------

Line 253: Log_Line (l_api_name || ': dropping all existing preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);

249: ------------------------------
250: -- Drop existing preferences
251: ------------------------------
252:
253: Log_Line (l_api_name || ': dropping all existing preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);
254:
255: FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
256: FROM ctxsys.ctx_preferences
257: WHERE pre_name = 'EAM_ASSET_MULTI_LEXER' )

Line 311: Log_Line (l_api_name || ': querying tablespace parameters ...', FND_LOG.LEVEL_EVENT, l_api_name);

307: ------------------------------
308: -- Index tables use the same tablespaces used by other EAM tables and indexes
309: -- or use logical tablespace for indexes (TRANSACTION_INDEXES).
310:
311: Log_Line (l_api_name || ': querying tablespace parameters ...', FND_LOG.LEVEL_EVENT, l_api_name);
312:
313: SELECT 'tablespace ' || tablespace_name ||
314: ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
315: INTO tspace_tbl_param

Line 327: Log_Line (l_api_name || ': creating STORAGE preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

323: WHERE owner = g_Prod_Schema
324: AND index_name = 'EAM_ASSET_TEXT_U1'
325: AND table_name = 'EAM_ASSET_TEXT';
326:
327: Log_Line (l_api_name || ': creating STORAGE preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
328:
329: ad_ctx_ddl.create_preference (g_Pref_Owner || '.EAM_ASSET_STORAGE', 'BASIC_STORAGE');
330:
331: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EAM_ASSET_STORAGE',

Line 361: Log_Line (l_api_name || ': creating DATASTORE preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

357: --------------------------------
358: -- Create DATASTORE preference
359: --------------------------------
360:
361: Log_Line (l_api_name || ': creating DATASTORE preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
362:
363: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EAM_ASSET_DATASTORE', 'USER_DATASTORE');
364:
365: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EAM_ASSET_DATASTORE', 'OUTPUT_TYPE', 'CLOB');

Line 375: --Log_Line (l_api_name || ': creating SECTION_GROUP preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

371: ------------------------------------
372: -- Create SECTION GROUP preference
373: ------------------------------------
374:
375: --Log_Line (l_api_name || ': creating SECTION_GROUP preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
376:
377: ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.EAM_ASSET_SECTION_GROUP', 'AUTO_SECTION_GROUP');
378:
379: -------------------------------

Line 383: Log_Line (l_api_name || ': creating STOPLIST preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

379: -------------------------------
380: -- Create STOPLIST preference
381: -------------------------------
382:
383: Log_Line (l_api_name || ': creating STOPLIST preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
384:
385: -- This should create stoplist equivalent to CTXSYS.EMPTY_STOPLIST
386: ad_ctx_ddl.Create_Stoplist (g_Pref_Owner || '.EAM_ASSET_STOPLIST');
387:

Line 392: Log_Line (l_api_name || ': creating WORDLIST preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

388: -------------------------------
389: -- Create WORDLIST preference
390: -------------------------------
391:
392: Log_Line (l_api_name || ': creating WORDLIST preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
393:
394: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EAM_ASSET_WORDLIST', 'BASIC_WORDLIST');
395:
396: -- Enable prefix indexing to improve performance for wildcard searches

Line 418: Log_Line (l_api_name || ': creating language-specific LEXER preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);

414: -----------------------------------------------
415: -- Create language-specific LEXER preferences
416: -----------------------------------------------
417:
418: Log_Line (l_api_name || ': creating language-specific LEXER preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);
419: Lexer_Name := g_Pref_Owner || '.EAM_ASSET_LEXER_BASIC';
420:
421: /*
422: FOR i IN Lang_Code_List.FIRST .. Lang_Code_List.LAST

Line 550: Log_Line (l_api_name || ': creating MULTI_LEXER preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

546: ----------------------------------
547: -- Create MULTI_LEXER preference
548: ----------------------------------
549: /*
550: Log_Line (l_api_name || ': creating MULTI_LEXER preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
551:
552: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EAM_ASSET_MULTI_LEXER', 'MULTI_LEXER');
553:
554: FOR i IN Lang_Code_List.FIRST .. Lang_Code_List.LAST

Line 580: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);

576: END LOOP;*/
577:
578: x_return_status := l_return_status;
579:
580: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);
581:
582: EXCEPTION
583:
584: WHEN G_EXC_ERROR THEN

Line 588: Log_Line (l_api_name || ': Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

584: WHEN G_EXC_ERROR THEN
585: x_return_status := G_STATUS_ERROR;
586:
587: WHEN others THEN
588: Log_Line (l_api_name || ': Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
589: x_return_status := G_STATUS_UNEXP_ERROR;
590:
591: END Set_Asset_Index_Preferences;
592:

Line 636: Log_Line (l_api_name || ': begin: Index_Name=' || p_Index_Name || ' Action=' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);

632: l_index_parallel VARCHAR2(30) := NULL;
633: sql_stmt VARCHAR2(32767);
634: BEGIN
635:
636: Log_Line (l_api_name || ': begin: Index_Name=' || p_Index_Name || ' Action=' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);
637:
638: l_return_status := G_STATUS_SUCCESS;
639:
640: IF ( p_Action NOT IN (1,2,4) ) THEN

Line 641: Log_Line (l_api_name || ': Error: invalid value for parameter p_Action: ' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);

637:
638: l_return_status := G_STATUS_SUCCESS;
639:
640: IF ( p_Action NOT IN (1,2,4) ) THEN
641: Log_Line (l_api_name || ': Error: invalid value for parameter p_Action: ' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);
642: RAISE G_EXC_ERROR;
643: END IF;
644:
645: -- Check for existing indexes in the EAM product, APPS Universal, and interMedia schemas.

Line 657: Log_Line (l_api_name || ': Error: index exists in wrong schema: ' || index_rec.owner, FND_LOG.LEVEL_EVENT, l_api_name);

653: -- Check index schema
654: --
655: IF ( index_rec.owner <> g_Index_Owner )
656: THEN
657: Log_Line (l_api_name || ': Error: index exists in wrong schema: ' || index_rec.owner, FND_LOG.LEVEL_EVENT, l_api_name);
658: BEGIN
659: Log_Line (l_api_name || ': dropping index: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
660: EXECUTE IMMEDIATE 'DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE';
661: EXCEPTION

Line 659: Log_Line (l_api_name || ': dropping index: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);

655: IF ( index_rec.owner <> g_Index_Owner )
656: THEN
657: Log_Line (l_api_name || ': Error: index exists in wrong schema: ' || index_rec.owner, FND_LOG.LEVEL_EVENT, l_api_name);
658: BEGIN
659: Log_Line (l_api_name || ': dropping index: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
660: EXECUTE IMMEDIATE 'DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE';
661: EXCEPTION
662: WHEN others THEN
663: Log_Line (l_api_name || ': Error: DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

Line 663: Log_Line (l_api_name || ': Error: DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

659: Log_Line (l_api_name || ': dropping index: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
660: EXECUTE IMMEDIATE 'DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE';
661: EXCEPTION
662: WHEN others THEN
663: Log_Line (l_api_name || ': Error: DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
664: l_return_status := G_STATUS_ERROR;
665: END;
666:
667: ELSE

Line 680: || ' domidx_opstatus=' || index_rec.domidx_opstatus, FND_LOG.LEVEL_EVENT, l_api_name);

676: l_index_valid := FALSE;
677: Log_Line (l_api_name || ': Warning: existing index status is invalid:'
678: || ' status=' || index_rec.status
679: || ' domidx_status=' || index_rec.domidx_status
680: || ' domidx_opstatus=' || index_rec.domidx_opstatus, FND_LOG.LEVEL_EVENT, l_api_name);
681: ELSE
682: Log_Line (l_api_name || ': valid index exists: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
683: END IF;
684:

Line 682: Log_Line (l_api_name || ': valid index exists: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);

678: || ' status=' || index_rec.status
679: || ' domidx_status=' || index_rec.domidx_status
680: || ' domidx_opstatus=' || index_rec.domidx_opstatus, FND_LOG.LEVEL_EVENT, l_api_name);
681: ELSE
682: Log_Line (l_api_name || ': valid index exists: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
683: END IF;
684:
685: END IF; -- index owner
686:

Line 700: Log_Line (l_api_name || ': Error: cannot execute Create because the index exists.', FND_LOG.LEVEL_EVENT, l_api_name);

696:
697: IF ( p_Action = 1 ) THEN
698: IF ( l_index_exists ) THEN
699: IF ( l_index_valid ) THEN
700: Log_Line (l_api_name || ': Error: cannot execute Create because the index exists.', FND_LOG.LEVEL_EVENT, l_api_name);
701: Request_Log ('EAM_TEXT_INDEX_EXISTS');
702: l_return_status := G_STATUS_WARNING;
703: l_create_index := FALSE;
704: ELSE

Line 715: Log_Line (l_api_name || ': Upgrade: skipping index creation because valid index exists.', FND_LOG.LEVEL_EVENT, l_api_name);

711: /*
712: ELSIF ( p_Action = 'UPGRADE' ) THEN
713: IF ( l_index_exists ) THEN
714: IF ( l_index_valid ) THEN
715: Log_Line (l_api_name || ': Upgrade: skipping index creation because valid index exists.', FND_LOG.LEVEL_EVENT, l_api_name);
716: l_create_index := FALSE;
717: ELSE
718: l_drop_index := TRUE;
719: END IF;

Line 727: Log_Line (l_api_name || ': Warning: cannot execute Drop because the index does not exist.', FND_LOG.LEVEL_EVENT, l_api_name);

723: l_create_index := FALSE;
724: IF ( l_index_exists ) THEN
725: l_drop_index := TRUE;
726: ELSE
727: Log_Line (l_api_name || ': Warning: cannot execute Drop because the index does not exist.', FND_LOG.LEVEL_EVENT, l_api_name);
728: Request_Log ('EAM_TEXT_INDEX_NOT_EXISTS');
729: l_return_status := G_STATUS_WARNING;
730: END IF;
731:

Line 736: Log_Line (l_api_name || ': dropping index: ' || g_Index_Owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);

732: END IF; -- Action
733:
734: IF ( l_drop_index ) THEN
735: BEGIN
736: Log_Line (l_api_name || ': dropping index: ' || g_Index_Owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
737: request_log('EAM_TEXT_DROP');
738: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
739: IF ( l_index_valid ) THEN
740: Log_Line (l_api_name || ': existing index has been successfully dropped.', FND_LOG.LEVEL_EVENT, l_api_name);

Line 740: Log_Line (l_api_name || ': existing index has been successfully dropped.', FND_LOG.LEVEL_EVENT, l_api_name);

736: Log_Line (l_api_name || ': dropping index: ' || g_Index_Owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
737: request_log('EAM_TEXT_DROP');
738: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
739: IF ( l_index_valid ) THEN
740: Log_Line (l_api_name || ': existing index has been successfully dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
741: ELSE
742: Log_Line (l_api_name || ': invalid index has been dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
743: END IF;
744: EXCEPTION

Line 742: Log_Line (l_api_name || ': invalid index has been dropped.', FND_LOG.LEVEL_EVENT, l_api_name);

738: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
739: IF ( l_index_valid ) THEN
740: Log_Line (l_api_name || ': existing index has been successfully dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
741: ELSE
742: Log_Line (l_api_name || ': invalid index has been dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
743: END IF;
744: EXCEPTION
745: WHEN others THEN
746: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

Line 746: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

742: Log_Line (l_api_name || ': invalid index has been dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
743: END IF;
744: EXCEPTION
745: WHEN others THEN
746: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
747: l_return_status := G_STATUS_ERROR;
748: END;
749: END IF; -- drop index
750:

Line 759: Log_Line (': calling Set_Asset_Index_Preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);

755: -- Build index
756:
757: IF ( l_create_index ) THEN
758:
759: Log_Line (': calling Set_Asset_Index_Preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);
760: request_log('EAM_TEXT_INDEX_PREF');
761: Set_Asset_Index_Preferences
762: (
763: p_Index_Name => p_Index_Name

Line 771: log_Line ('Re-created Text Index preferences.', FND_LOG.LEVEL_EVENT, l_api_name);

767: IF ( l_return_status NOT IN (G_STATUS_SUCCESS, G_STATUS_WARNING) ) THEN
768: RAISE G_EXC_ERROR;
769: END IF;
770:
771: log_Line ('Re-created Text Index preferences.', FND_LOG.LEVEL_EVENT, l_api_name);
772:
773: -- Determine index memory parameter value
774: --ctxsys.CTX_ADM.Set_Parameter ('MAX_INDEX_MEMORY', l_Index_Memory);
775: BEGIN

Line 781: Log_Line (l_api_name || ': Error: MAX_INDEX_MEMORY parameter record not found.', FND_LOG.LEVEL_EVENT, l_api_name);

777: FROM ctx_parameters
778: WHERE par_name = 'MAX_INDEX_MEMORY';
779: EXCEPTION
780: WHEN no_data_found THEN
781: Log_Line (l_api_name || ': Error: MAX_INDEX_MEMORY parameter record not found.', FND_LOG.LEVEL_EVENT, l_api_name);
782: RAISE G_EXC_ERROR;
783: END;
784:
785: IF ( TO_NUMBER(l_Index_Memory) > TO_NUMBER(l_Index_Memory_Max) ) THEN

Line 789: Log_Line (l_api_name || ': CTX index_memory: ' || l_Index_Memory, FND_LOG.LEVEL_EVENT, l_api_name);

785: IF ( TO_NUMBER(l_Index_Memory) > TO_NUMBER(l_Index_Memory_Max) ) THEN
786: l_Index_Memory := l_Index_Memory_Max;
787: END IF;
788:
789: Log_Line (l_api_name || ': CTX index_memory: ' || l_Index_Memory, FND_LOG.LEVEL_EVENT, l_api_name);
790:
791: -- Decide whether parallel indexing can be used, depending on DB version.
792:
793: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN

Line 795: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);

791: -- Decide whether parallel indexing can be used, depending on DB version.
792:
793: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
794: l_index_parallel := c_parallel_clause;
795: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);
796: END IF;
797:
798: -- Start logging indexing progress
799:

Line 802: Log_Line (l_api_name || ': CTX Log_Directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);

798: -- Start logging indexing progress
799:
800: IF ( g_Log_Dir IS NOT NULL ) THEN
801: BEGIN
802: Log_Line (l_api_name || ': CTX Log_Directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
803: ctxsys.CTX_ADM.Set_Parameter ( 'LOG_DIRECTORY', g_Log_Dir );
804: Log_Line (l_api_name || ': CTX Start_Log', FND_LOG.LEVEL_EVENT, l_api_name);
805: CTX_OUTPUT.Start_Log ( LOWER(p_Index_Name) || '.log' );
806: ctx_Log_File_Name := CTX_OUTPUT.LogFileName;

Line 804: Log_Line (l_api_name || ': CTX Start_Log', FND_LOG.LEVEL_EVENT, l_api_name);

800: IF ( g_Log_Dir IS NOT NULL ) THEN
801: BEGIN
802: Log_Line (l_api_name || ': CTX Log_Directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
803: ctxsys.CTX_ADM.Set_Parameter ( 'LOG_DIRECTORY', g_Log_Dir );
804: Log_Line (l_api_name || ': CTX Start_Log', FND_LOG.LEVEL_EVENT, l_api_name);
805: CTX_OUTPUT.Start_Log ( LOWER(p_Index_Name) || '.log' );
806: ctx_Log_File_Name := CTX_OUTPUT.LogFileName;
807: Log_Line (l_api_name || ': CTX LogFileName: ' || ctx_Log_File_Name, FND_LOG.LEVEL_EVENT, l_api_name);
808: EXCEPTION

Line 807: Log_Line (l_api_name || ': CTX LogFileName: ' || ctx_Log_File_Name, FND_LOG.LEVEL_EVENT, l_api_name);

803: ctxsys.CTX_ADM.Set_Parameter ( 'LOG_DIRECTORY', g_Log_Dir );
804: Log_Line (l_api_name || ': CTX Start_Log', FND_LOG.LEVEL_EVENT, l_api_name);
805: CTX_OUTPUT.Start_Log ( LOWER(p_Index_Name) || '.log' );
806: ctx_Log_File_Name := CTX_OUTPUT.LogFileName;
807: Log_Line (l_api_name || ': CTX LogFileName: ' || ctx_Log_File_Name, FND_LOG.LEVEL_EVENT, l_api_name);
808: EXCEPTION
809: WHEN others THEN
810: Log_Line (l_api_name || ': Warning: CTX Start_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
811: l_return_status := G_STATUS_WARNING;

Line 810: Log_Line (l_api_name || ': Warning: CTX Start_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

806: ctx_Log_File_Name := CTX_OUTPUT.LogFileName;
807: Log_Line (l_api_name || ': CTX LogFileName: ' || ctx_Log_File_Name, FND_LOG.LEVEL_EVENT, l_api_name);
808: EXCEPTION
809: WHEN others THEN
810: Log_Line (l_api_name || ': Warning: CTX Start_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
811: l_return_status := G_STATUS_WARNING;
812: END;
813: END IF;
814:

Line 845: Log_Line (l_api_name || ': creating index ' || g_Index_Owner || '.' || p_Index_Name || ' ...', FND_LOG.LEVEL_EVENT, l_api_name);

841: ' '')'
842: || ' ' || l_index_parallel
843: ;
844:
845: Log_Line (l_api_name || ': creating index ' || g_Index_Owner || '.' || p_Index_Name || ' ...', FND_LOG.LEVEL_EVENT, l_api_name);
846: --Log_Line (l_api_name || ': sql_stmt = ' || sql_stmt || ' /* End SQL */');
847:
848: EXECUTE IMMEDIATE sql_stmt;
849:

Line 850: Log_Line (l_api_name || ': done creating index.', FND_LOG.LEVEL_EVENT, l_api_name);

846: --Log_Line (l_api_name || ': sql_stmt = ' || sql_stmt || ' /* End SQL */');
847:
848: EXECUTE IMMEDIATE sql_stmt;
849:
850: Log_Line (l_api_name || ': done creating index.', FND_LOG.LEVEL_EVENT, l_api_name);
851:
852: EXCEPTION
853:
854: WHEN others THEN

Line 855: Log_Line (l_api_name || ': Error creating index ' || g_Index_Owner || '.' || p_Index_Name || ': ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

851:
852: EXCEPTION
853:
854: WHEN others THEN
855: Log_Line (l_api_name || ': Error creating index ' || g_Index_Owner || '.' || p_Index_Name || ': ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
856:
857: -- Drop the index in case of an error during index creation to prevent the table lock.
858: BEGIN
859: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';

Line 862: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

858: BEGIN
859: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
860: EXCEPTION
861: WHEN others THEN
862: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
863: RAISE G_EXC_ERROR;
864: END;
865:
866: RAISE G_EXC_ERROR;

Line 871: Log_Line (l_api_name || ': calling Incremental_Sync', FND_LOG.LEVEL_EVENT, l_api_name);

867:
868: END; -- execute sql
869: END IF; -- create index
870: /*
871: Log_Line (l_api_name || ': calling Incremental_Sync', FND_LOG.LEVEL_EVENT, l_api_name);
872:
873: eam_text_util.Incremental_Sync
874: (
875: p_Index_Name => p_Index_Name

Line 886: Log_Line (l_api_name || ': CTX End_Log', FND_LOG.LEVEL_EVENT, l_api_name);

882:
883: IF ( ctx_Log_File_Name IS NOT NULL ) THEN
884: BEGIN
885: CTX_OUTPUT.End_Log;
886: Log_Line (l_api_name || ': CTX End_Log', FND_LOG.LEVEL_EVENT, l_api_name);
887: EXCEPTION
888: WHEN others THEN
889: Log_Line (l_api_name || ': Warning: CTX End_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
890: l_return_status := G_STATUS_WARNING;

Line 889: Log_Line (l_api_name || ': Warning: CTX End_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

885: CTX_OUTPUT.End_Log;
886: Log_Line (l_api_name || ': CTX End_Log', FND_LOG.LEVEL_EVENT, l_api_name);
887: EXCEPTION
888: WHEN others THEN
889: Log_Line (l_api_name || ': Warning: CTX End_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
890: l_return_status := G_STATUS_WARNING;
891: END;
892: END IF;
893:

Line 894: log_Line ('Completed building Asset Text Index.', FND_LOG.LEVEL_EVENT, l_api_name);

890: l_return_status := G_STATUS_WARNING;
891: END;
892: END IF;
893:
894: log_Line ('Completed building Asset Text Index.', FND_LOG.LEVEL_EVENT, l_api_name);
895:
896: -- Check the created index status
897:
898: SELECT idx_docid_count, idx_status

Line 905: Log_Line (l_api_name || ': Error: Index status is ' || l_idx_status || '.', FND_LOG.LEVEL_EVENT, l_api_name);

901: WHERE idx_owner = g_Prod_Schema AND idx_name = 'EAM_ASSET_TEXT_CTX1'
902: AND idx_table = 'EAM_ASSET_TEXT';
903:
904: IF NOT( l_idx_status = 'INDEXED' ) THEN
905: Log_Line (l_api_name || ': Error: Index status is ' || l_idx_status || '.', FND_LOG.LEVEL_EVENT, l_api_name);
906: l_return_status := G_STATUS_ERROR;
907: END IF;
908:
909: IF ( NVL(l_idx_docid_count, 0) = 0 ) THEN

Line 910: Log_Line (l_api_name || ': Error: Indexed document count is ' || TO_CHAR(l_idx_docid_count) || '.', FND_LOG.LEVEL_EVENT, l_api_name);

906: l_return_status := G_STATUS_ERROR;
907: END IF;
908:
909: IF ( NVL(l_idx_docid_count, 0) = 0 ) THEN
910: Log_Line (l_api_name || ': Error: Indexed document count is ' || TO_CHAR(l_idx_docid_count) || '.', FND_LOG.LEVEL_EVENT, l_api_name);
911: l_return_status := G_STATUS_ERROR;
912: END IF;
913:
914: IF ( l_return_status NOT IN (G_STATUS_SUCCESS, G_STATUS_WARNING) ) THEN

Line 921: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);

917:
918: END IF; -- build index
919:
920: x_return_status := l_return_status;
921: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);
922:
923: EXCEPTION
924:
925: WHEN G_EXC_ERROR THEN

Line 929: Log_Line (l_api_name || ': Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

925: WHEN G_EXC_ERROR THEN
926: x_return_status := G_STATUS_ERROR;
927:
928: WHEN others THEN
929: Log_Line (l_api_name || ': Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
930: x_return_status := G_STATUS_UNEXP_ERROR;
931:
932: END Process_Asset_Text_Index;
933:

Line 967: Log_Line (l_api_name || ': begin', FND_LOG.LEVEL_EVENT, l_api_name);

963: --Lang_ISO_List Lang_ISO_List_type :=
964: -- Lang_ISO_List_type ('EN', '', 'DE', 'SV', 'NO', 'FR', '', '');
965:
966: BEGIN
967: Log_Line (l_api_name || ': begin', FND_LOG.LEVEL_EVENT, l_api_name);
968:
969: l_return_status := G_STATUS_SUCCESS;
970:
971: ------------------------------

Line 975: Log_Line (l_api_name || ': dropping all existing preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);

971: ------------------------------
972: -- Drop existing preferences
973: ------------------------------
974:
975: Log_Line (l_api_name || ': dropping all existing preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);
976:
977: FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
978: FROM ctxsys.ctx_preferences
979: WHERE pre_name = 'EAM_WORK_ORDER_MULTI_LEXER' )

Line 1033: Log_Line (l_api_name || ': querying tablespace parameters ...', FND_LOG.LEVEL_EVENT, l_api_name);

1029: ------------------------------
1030: -- Index tables use the same tablespaces used by other EAM tables and indexes
1031: -- or use logical tablespace for indexes (TRANSACTION_INDEXES).
1032:
1033: Log_Line (l_api_name || ': querying tablespace parameters ...', FND_LOG.LEVEL_EVENT, l_api_name);
1034:
1035: SELECT 'tablespace ' || tablespace_name ||
1036: ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
1037: INTO tspace_tbl_param

Line 1049: Log_Line (l_api_name || ': creating STORAGE preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

1045: WHERE owner = g_Prod_Schema
1046: AND index_name = 'EAM_WORK_ORDER_TEXT_U1'
1047: AND table_name = 'EAM_WORK_ORDER_TEXT';
1048:
1049: Log_Line (l_api_name || ': creating STORAGE preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
1050:
1051: ad_ctx_ddl.create_preference (g_Pref_Owner || '.EAM_WORK_ORDER_STORAGE', 'BASIC_STORAGE');
1052:
1053: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.EAM_WORK_ORDER_STORAGE',

Line 1083: Log_Line (l_api_name || ': creating DATASTORE preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

1079: --------------------------------
1080: -- Create DATASTORE preference
1081: --------------------------------
1082:
1083: Log_Line (l_api_name || ': creating DATASTORE preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
1084:
1085: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EAM_WORK_ORDER_DATASTORE', 'USER_DATASTORE');
1086:
1087: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.EAM_WORK_ORDER_DATASTORE', 'OUTPUT_TYPE', 'CLOB');

Line 1097: --Log_Line (l_api_name || ': creating SECTION_GROUP preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

1093: ------------------------------------
1094: -- Create SECTION GROUP preference
1095: ------------------------------------
1096:
1097: --Log_Line (l_api_name || ': creating SECTION_GROUP preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
1098:
1099: ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.EAM_WORK_ORDER_SECTION_GROUP', 'AUTO_SECTION_GROUP');
1100:
1101: -------------------------------

Line 1105: Log_Line (l_api_name || ': creating STOPLIST preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

1101: -------------------------------
1102: -- Create STOPLIST preference
1103: -------------------------------
1104:
1105: Log_Line (l_api_name || ': creating STOPLIST preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
1106:
1107: -- This should create stoplist equivalent to CTXSYS.EMPTY_STOPLIST
1108: ad_ctx_ddl.Create_Stoplist (g_Pref_Owner || '.EAM_WORK_ORDER_STOPLIST');
1109:

Line 1114: Log_Line (l_api_name || ': creating WORDLIST preference ...', FND_LOG.LEVEL_EVENT, l_api_name);

1110: -------------------------------
1111: -- Create WORDLIST preference
1112: -------------------------------
1113:
1114: Log_Line (l_api_name || ': creating WORDLIST preference ...', FND_LOG.LEVEL_EVENT, l_api_name);
1115:
1116: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.EAM_WORK_ORDER_WORDLIST', 'BASIC_WORDLIST');
1117:
1118: -- Enable prefix indexing to improve performance for wildcard searches

Line 1140: Log_Line (l_api_name || ': creating language-specific LEXER preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);

1136: -----------------------------------------------
1137: -- Create language-specific LEXER preferences
1138: -----------------------------------------------
1139:
1140: Log_Line (l_api_name || ': creating language-specific LEXER preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);
1141: /* For now we will use basic lexer */
1142: Lexer_Name := g_Pref_Owner || '.EAM_WORK_ORDER_LEXER_BASIC';
1143:
1144: /*

Line 1304: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);

1300: END LOOP;*/
1301:
1302: x_return_status := l_return_status;
1303:
1304: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);
1305:
1306: EXCEPTION
1307:
1308: WHEN G_EXC_ERROR THEN

Line 1312: Log_Line (l_api_name || ': Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1308: WHEN G_EXC_ERROR THEN
1309: x_return_status := G_STATUS_ERROR;
1310:
1311: WHEN others THEN
1312: Log_Line (l_api_name || ': Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1313: x_return_status := G_STATUS_UNEXP_ERROR;
1314:
1315: END Set_Wo_Index_Preferences;
1316:

Line 1361: Log_Line (l_api_name || ': begin: Index_Name=' || p_Index_Name || ' Action=' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);

1357: l_index_parallel VARCHAR2(30) := NULL;
1358: sql_stmt VARCHAR2(32767);
1359: BEGIN
1360:
1361: Log_Line (l_api_name || ': begin: Index_Name=' || p_Index_Name || ' Action=' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);
1362:
1363: l_return_status := G_STATUS_SUCCESS;
1364:
1365: IF ( p_Action NOT IN (1,2,4) ) THEN

Line 1366: Log_Line (l_api_name || ': Error: invalid value for parameter p_Action: ' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);

1362:
1363: l_return_status := G_STATUS_SUCCESS;
1364:
1365: IF ( p_Action NOT IN (1,2,4) ) THEN
1366: Log_Line (l_api_name || ': Error: invalid value for parameter p_Action: ' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);
1367: RAISE G_EXC_ERROR;
1368: END IF;
1369:
1370: -- Check for existing indexes in the EAM product, APPS Universal, and interMedia schemas.

Line 1382: Log_Line (l_api_name || ': Error: index exists in wrong schema: ' || index_rec.owner, FND_LOG.LEVEL_EVENT, l_api_name);

1378: -- Check index schema
1379: --
1380: IF ( index_rec.owner <> g_Index_Owner )
1381: THEN
1382: Log_Line (l_api_name || ': Error: index exists in wrong schema: ' || index_rec.owner, FND_LOG.LEVEL_EVENT, l_api_name);
1383: BEGIN
1384: Log_Line (l_api_name || ': dropping index: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1385: EXECUTE IMMEDIATE 'DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE';
1386: EXCEPTION

Line 1384: Log_Line (l_api_name || ': dropping index: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);

1380: IF ( index_rec.owner <> g_Index_Owner )
1381: THEN
1382: Log_Line (l_api_name || ': Error: index exists in wrong schema: ' || index_rec.owner, FND_LOG.LEVEL_EVENT, l_api_name);
1383: BEGIN
1384: Log_Line (l_api_name || ': dropping index: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1385: EXECUTE IMMEDIATE 'DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE';
1386: EXCEPTION
1387: WHEN others THEN
1388: Log_Line (l_api_name || ': Error: DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

Line 1388: Log_Line (l_api_name || ': Error: DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1384: Log_Line (l_api_name || ': dropping index: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1385: EXECUTE IMMEDIATE 'DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE';
1386: EXCEPTION
1387: WHEN others THEN
1388: Log_Line (l_api_name || ': Error: DROP INDEX ' || index_rec.owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1389: l_return_status := G_STATUS_ERROR;
1390: END;
1391:
1392: ELSE

Line 1405: || ' domidx_opstatus=' || index_rec.domidx_opstatus, FND_LOG.LEVEL_EVENT, l_api_name);

1401: l_index_valid := FALSE;
1402: Log_Line (l_api_name || ': Warning: existing index status is invalid:'
1403: || ' status=' || index_rec.status
1404: || ' domidx_status=' || index_rec.domidx_status
1405: || ' domidx_opstatus=' || index_rec.domidx_opstatus, FND_LOG.LEVEL_EVENT, l_api_name);
1406: ELSE
1407: Log_Line (l_api_name || ': valid index exists: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1408: END IF;
1409:

Line 1407: Log_Line (l_api_name || ': valid index exists: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);

1403: || ' status=' || index_rec.status
1404: || ' domidx_status=' || index_rec.domidx_status
1405: || ' domidx_opstatus=' || index_rec.domidx_opstatus, FND_LOG.LEVEL_EVENT, l_api_name);
1406: ELSE
1407: Log_Line (l_api_name || ': valid index exists: ' || index_rec.owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1408: END IF;
1409:
1410: END IF; -- index owner
1411:

Line 1425: Log_Line (l_api_name || ': Error: cannot execute Create because the index exists.', FND_LOG.LEVEL_EVENT, l_api_name);

1421:
1422: IF ( p_Action = 1 ) THEN
1423: IF ( l_index_exists ) THEN
1424: IF ( l_index_valid ) THEN
1425: Log_Line (l_api_name || ': Error: cannot execute Create because the index exists.', FND_LOG.LEVEL_EVENT, l_api_name);
1426: Request_Log ('EAM_TEXT_INDEX_EXISTS');
1427: l_return_status := G_STATUS_WARNING;
1428: l_create_index := FALSE;
1429: ELSE

Line 1440: Log_Line (l_api_name || ': Upgrade: skipping index creation because valid index exists.', FND_LOG.LEVEL_EVENT, l_api_name);

1436: /*
1437: ELSIF ( p_Action = 'UPGRADE' ) THEN
1438: IF ( l_index_exists ) THEN
1439: IF ( l_index_valid ) THEN
1440: Log_Line (l_api_name || ': Upgrade: skipping index creation because valid index exists.', FND_LOG.LEVEL_EVENT, l_api_name);
1441: l_create_index := FALSE;
1442: ELSE
1443: l_drop_index := TRUE;
1444: END IF;

Line 1452: Log_Line (l_api_name || ': Warning: cannot execute Drop because the index does not exist.', FND_LOG.LEVEL_EVENT, l_api_name);

1448: l_create_index := FALSE;
1449: IF ( l_index_exists ) THEN
1450: l_drop_index := TRUE;
1451: ELSE
1452: Log_Line (l_api_name || ': Warning: cannot execute Drop because the index does not exist.', FND_LOG.LEVEL_EVENT, l_api_name);
1453: Request_Log ('EAM_TEXT_INDEX_NOT_EXISTS');
1454: l_return_status := G_STATUS_WARNING;
1455: END IF;
1456:

Line 1461: Log_Line (l_api_name || ': dropping index: ' || g_Index_Owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);

1457: END IF; -- Action
1458:
1459: IF ( l_drop_index ) THEN
1460: BEGIN
1461: Log_Line (l_api_name || ': dropping index: ' || g_Index_Owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1462: request_log('EAM_TEXT_DROP');
1463: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
1464: IF ( l_index_valid ) THEN
1465: Log_Line (l_api_name || ': existing index has been successfully dropped.', FND_LOG.LEVEL_EVENT, l_api_name);

Line 1465: Log_Line (l_api_name || ': existing index has been successfully dropped.', FND_LOG.LEVEL_EVENT, l_api_name);

1461: Log_Line (l_api_name || ': dropping index: ' || g_Index_Owner || '.' || p_Index_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1462: request_log('EAM_TEXT_DROP');
1463: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
1464: IF ( l_index_valid ) THEN
1465: Log_Line (l_api_name || ': existing index has been successfully dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
1466: ELSE
1467: Log_Line (l_api_name || ': invalid index has been dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
1468: END IF;
1469: EXCEPTION

Line 1467: Log_Line (l_api_name || ': invalid index has been dropped.', FND_LOG.LEVEL_EVENT, l_api_name);

1463: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
1464: IF ( l_index_valid ) THEN
1465: Log_Line (l_api_name || ': existing index has been successfully dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
1466: ELSE
1467: Log_Line (l_api_name || ': invalid index has been dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
1468: END IF;
1469: EXCEPTION
1470: WHEN others THEN
1471: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

Line 1471: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1467: Log_Line (l_api_name || ': invalid index has been dropped.', FND_LOG.LEVEL_EVENT, l_api_name);
1468: END IF;
1469: EXCEPTION
1470: WHEN others THEN
1471: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1472: l_return_status := G_STATUS_ERROR;
1473: END;
1474: END IF; -- drop index
1475:

Line 1484: Log_Line ('Calling Set_Wo_Index_Preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);

1480: -- Build index
1481:
1482: IF ( l_create_index ) THEN
1483:
1484: Log_Line ('Calling Set_Wo_Index_Preferences ...', FND_LOG.LEVEL_EVENT, l_api_name);
1485: request_log('EAM_TEXT_INDEX_PREF');
1486: Set_Wo_Index_Preferences
1487: (
1488: p_Index_Name => p_Index_Name

Line 1496: log_Line ('Re-created Text Index preferences.', FND_LOG.LEVEL_EVENT, l_api_name);

1492: IF ( l_return_status NOT IN (G_STATUS_SUCCESS, G_STATUS_WARNING) ) THEN
1493: RAISE G_EXC_ERROR;
1494: END IF;
1495:
1496: log_Line ('Re-created Text Index preferences.', FND_LOG.LEVEL_EVENT, l_api_name);
1497:
1498: -- Determine index memory parameter value
1499: --ctxsys.CTX_ADM.Set_Parameter ('MAX_INDEX_MEMORY', l_Index_Memory);
1500: BEGIN

Line 1506: Log_Line (l_api_name || ': Error: MAX_INDEX_MEMORY parameter record not found.', FND_LOG.LEVEL_EVENT, l_api_name);

1502: FROM ctx_parameters
1503: WHERE par_name = 'MAX_INDEX_MEMORY';
1504: EXCEPTION
1505: WHEN no_data_found THEN
1506: Log_Line (l_api_name || ': Error: MAX_INDEX_MEMORY parameter record not found.', FND_LOG.LEVEL_EVENT, l_api_name);
1507: RAISE G_EXC_ERROR;
1508: END;
1509:
1510: IF ( TO_NUMBER(l_Index_Memory) > TO_NUMBER(l_Index_Memory_Max) ) THEN

Line 1514: Log_Line (l_api_name || ': CTX index_memory: ' || l_Index_Memory, FND_LOG.LEVEL_EVENT, l_api_name);

1510: IF ( TO_NUMBER(l_Index_Memory) > TO_NUMBER(l_Index_Memory_Max) ) THEN
1511: l_Index_Memory := l_Index_Memory_Max;
1512: END IF;
1513:
1514: Log_Line (l_api_name || ': CTX index_memory: ' || l_Index_Memory, FND_LOG.LEVEL_EVENT, l_api_name);
1515:
1516: -- Decide whether parallel indexing can be used, depending on DB version.
1517:
1518: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN

Line 1520: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);

1516: -- Decide whether parallel indexing can be used, depending on DB version.
1517:
1518: IF ( eam_text_util.get_DB_Version_Num >= 9.2 ) THEN
1519: l_index_parallel := c_parallel_clause;
1520: Log_Line (l_api_name || ': DB version: ' || eam_text_util.get_DB_Version_Str || ', using parallel clause: ' || l_index_parallel, FND_LOG.LEVEL_EVENT, l_api_name);
1521: END IF;
1522:
1523: -- Start logging indexing progress
1524:

Line 1527: Log_Line (l_api_name || ': CTX Log_Directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);

1523: -- Start logging indexing progress
1524:
1525: IF ( g_Log_Dir IS NOT NULL ) THEN
1526: BEGIN
1527: Log_Line (l_api_name || ': CTX Log_Directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
1528: ctxsys.CTX_ADM.Set_Parameter ( 'LOG_DIRECTORY', g_Log_Dir );
1529: Log_Line (l_api_name || ': CTX Start_Log', FND_LOG.LEVEL_EVENT, l_api_name);
1530: CTX_OUTPUT.Start_Log ( LOWER(p_Index_Name) || '.log' );
1531: ctx_Log_File_Name := CTX_OUTPUT.LogFileName;

Line 1529: Log_Line (l_api_name || ': CTX Start_Log', FND_LOG.LEVEL_EVENT, l_api_name);

1525: IF ( g_Log_Dir IS NOT NULL ) THEN
1526: BEGIN
1527: Log_Line (l_api_name || ': CTX Log_Directory: ' || g_Log_Dir, FND_LOG.LEVEL_EVENT, l_api_name);
1528: ctxsys.CTX_ADM.Set_Parameter ( 'LOG_DIRECTORY', g_Log_Dir );
1529: Log_Line (l_api_name || ': CTX Start_Log', FND_LOG.LEVEL_EVENT, l_api_name);
1530: CTX_OUTPUT.Start_Log ( LOWER(p_Index_Name) || '.log' );
1531: ctx_Log_File_Name := CTX_OUTPUT.LogFileName;
1532: Log_Line (l_api_name || ': CTX LogFileName: ' || ctx_Log_File_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1533: EXCEPTION

Line 1532: Log_Line (l_api_name || ': CTX LogFileName: ' || ctx_Log_File_Name, FND_LOG.LEVEL_EVENT, l_api_name);

1528: ctxsys.CTX_ADM.Set_Parameter ( 'LOG_DIRECTORY', g_Log_Dir );
1529: Log_Line (l_api_name || ': CTX Start_Log', FND_LOG.LEVEL_EVENT, l_api_name);
1530: CTX_OUTPUT.Start_Log ( LOWER(p_Index_Name) || '.log' );
1531: ctx_Log_File_Name := CTX_OUTPUT.LogFileName;
1532: Log_Line (l_api_name || ': CTX LogFileName: ' || ctx_Log_File_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1533: EXCEPTION
1534: WHEN others THEN
1535: Log_Line (l_api_name || ': Warning: CTX Start_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1536: l_return_status := G_STATUS_WARNING;

Line 1535: Log_Line (l_api_name || ': Warning: CTX Start_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1531: ctx_Log_File_Name := CTX_OUTPUT.LogFileName;
1532: Log_Line (l_api_name || ': CTX LogFileName: ' || ctx_Log_File_Name, FND_LOG.LEVEL_EVENT, l_api_name);
1533: EXCEPTION
1534: WHEN others THEN
1535: Log_Line (l_api_name || ': Warning: CTX Start_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1536: l_return_status := G_STATUS_WARNING;
1537: END;
1538: END IF;
1539:

Line 1570: Log_Line (l_api_name || ': creating index ' || g_Index_Owner || '.' || p_Index_Name || ' ...', FND_LOG.LEVEL_EVENT, l_api_name);

1566: ' '')'
1567: || ' ' || l_index_parallel
1568: ;
1569:
1570: Log_Line (l_api_name || ': creating index ' || g_Index_Owner || '.' || p_Index_Name || ' ...', FND_LOG.LEVEL_EVENT, l_api_name);
1571: --Log_Line (l_api_name || ': sql_stmt = ' || sql_stmt || ' /* End SQL */');
1572:
1573: EXECUTE IMMEDIATE sql_stmt;
1574:

Line 1575: Log_Line (l_api_name || ': done creating index.', FND_LOG.LEVEL_EVENT, l_api_name );

1571: --Log_Line (l_api_name || ': sql_stmt = ' || sql_stmt || ' /* End SQL */');
1572:
1573: EXECUTE IMMEDIATE sql_stmt;
1574:
1575: Log_Line (l_api_name || ': done creating index.', FND_LOG.LEVEL_EVENT, l_api_name );
1576:
1577: EXCEPTION
1578:
1579: WHEN others THEN

Line 1580: Log_Line (l_api_name || ': Error creating index ' || g_Index_Owner || '.' || p_Index_Name || ': ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1576:
1577: EXCEPTION
1578:
1579: WHEN others THEN
1580: Log_Line (l_api_name || ': Error creating index ' || g_Index_Owner || '.' || p_Index_Name || ': ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1581:
1582: -- Drop the index in case of an error during index creation to prevent the table lock.
1583: BEGIN
1584: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';

Line 1587: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1583: BEGIN
1584: EXECUTE IMMEDIATE 'DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE';
1585: EXCEPTION
1586: WHEN others THEN
1587: Log_Line (l_api_name || ': Error: DROP INDEX ' || g_Index_Owner || '.' || p_Index_Name || ' FORCE: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1588: RAISE G_EXC_ERROR;
1589: END;
1590:
1591: RAISE G_EXC_ERROR;

Line 1611: Log_Line (l_api_name || ': CTX End_Log', FND_LOG.LEVEL_EVENT, l_api_name);

1607:
1608: IF ( ctx_Log_File_Name IS NOT NULL ) THEN
1609: BEGIN
1610: CTX_OUTPUT.End_Log;
1611: Log_Line (l_api_name || ': CTX End_Log', FND_LOG.LEVEL_EVENT, l_api_name);
1612: EXCEPTION
1613: WHEN others THEN
1614: Log_Line (l_api_name || ': Warning: CTX End_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1615: l_return_status := G_STATUS_WARNING;

Line 1614: Log_Line (l_api_name || ': Warning: CTX End_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1610: CTX_OUTPUT.End_Log;
1611: Log_Line (l_api_name || ': CTX End_Log', FND_LOG.LEVEL_EVENT, l_api_name);
1612: EXCEPTION
1613: WHEN others THEN
1614: Log_Line (l_api_name || ': Warning: CTX End_Log: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1615: l_return_status := G_STATUS_WARNING;
1616: END;
1617: END IF;
1618:

Line 1628: Log_Line (l_api_name || ': Error: Index status is ' || l_idx_status || '.', FND_LOG.LEVEL_EVENT, l_api_name);

1624: WHERE idx_owner = g_Prod_Schema AND idx_name = 'EAM_WORK_ORDER_TEXT_CTX1'
1625: AND idx_table = 'EAM_WORK_ORDER_TEXT';
1626:
1627: IF NOT( l_idx_status = 'INDEXED' ) THEN
1628: Log_Line (l_api_name || ': Error: Index status is ' || l_idx_status || '.', FND_LOG.LEVEL_EVENT, l_api_name);
1629: l_return_status := G_STATUS_ERROR;
1630: END IF;
1631:
1632: IF ( NVL(l_idx_docid_count, 0) = 0 ) THEN

Line 1633: Log_Line (l_api_name || ': Error: Indexed document count is ' || TO_CHAR(l_idx_docid_count) || '.', FND_LOG.LEVEL_EVENT, l_api_name);

1629: l_return_status := G_STATUS_ERROR;
1630: END IF;
1631:
1632: IF ( NVL(l_idx_docid_count, 0) = 0 ) THEN
1633: Log_Line (l_api_name || ': Error: Indexed document count is ' || TO_CHAR(l_idx_docid_count) || '.', FND_LOG.LEVEL_EVENT, l_api_name);
1634: l_return_status := G_STATUS_ERROR;
1635: END IF;
1636:
1637: IF ( l_return_status NOT IN (G_STATUS_SUCCESS, G_STATUS_WARNING) ) THEN

Line 1644: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);

1640:
1641: END IF; -- build index
1642:
1643: x_return_status := l_return_status;
1644: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);
1645:
1646: EXCEPTION
1647:
1648: WHEN G_EXC_ERROR THEN

Line 1652: Log_Line (l_api_name || ': Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1648: WHEN G_EXC_ERROR THEN
1649: x_return_status := G_STATUS_ERROR;
1650:
1651: WHEN others THEN
1652: Log_Line (l_api_name || ': Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1653: x_return_status := G_STATUS_UNEXP_ERROR;
1654:
1655: END Process_Wo_Text_Index;
1656:

Line 1699: Log_Line ('Begin : Action=' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);

1695: set_Log_Mode ('FILE');
1696: --set_Log_Mode ('SQLPLUS');
1697: END IF;
1698:
1699: Log_Line ('Begin : Action=' || p_Action, FND_LOG.LEVEL_EVENT, l_api_name);
1700:
1701: l_return_status := G_STATUS_SUCCESS;
1702:
1703: IF (p_optlevel IS NOT NULL) THEN

Line 1714: Log_Line ('Calling Process_Asset_Text_Index ...', FND_LOG.LEVEL_EVENT, l_api_name);

1710:
1711: IF p_text_context = 1 THEN
1712: l_Index_Name := 'EAM_ASSET_TEXT_CTX1';
1713:
1714: Log_Line ('Calling Process_Asset_Text_Index ...', FND_LOG.LEVEL_EVENT, l_api_name);
1715:
1716: IF (p_Action IN (1,2,4)) THEN
1717: Process_Asset_Text_Index
1718: (

Line 1724: Log_Line ('Calling Optimize_Index ...', FND_LOG.LEVEL_EVENT, l_api_name);

1720: , p_Action => p_Action
1721: , x_return_status => l_return_status
1722: );
1723: ELSIF (p_Action = 3) THEN
1724: Log_Line ('Calling Optimize_Index ...', FND_LOG.LEVEL_EVENT, l_api_name);
1725: request_log('EAM_TEXT_OPTIMIZE');
1726: Optimize_Index
1727: (
1728: x_return_status => l_return_status

Line 1738: Log_Line ('Calling Process_Wo_Text_Index ...', FND_LOG.LEVEL_EVENT, l_api_name);

1734: ELSE --for workorders
1735:
1736: l_Index_Name := 'EAM_WORK_ORDER_TEXT_CTX1';
1737:
1738: Log_Line ('Calling Process_Wo_Text_Index ...', FND_LOG.LEVEL_EVENT, l_api_name);
1739:
1740: IF (p_Action IN (1,2,4)) THEN
1741: Process_Wo_Text_Index
1742: (

Line 1748: Log_Line ('Calling Optimize_Index ...', FND_LOG.LEVEL_EVENT, l_api_name);

1744: , p_Action => p_Action
1745: , x_return_status => l_return_status
1746: );
1747: ELSIF (p_Action = 3) THEN
1748: Log_Line ('Calling Optimize_Index ...', FND_LOG.LEVEL_EVENT, l_api_name);
1749: request_log('EAM_TEXT_OPTIMIZE');
1750: Optimize_Index
1751: (
1752: x_return_status => l_return_status

Line 1758: Log_Line ('Calling Eam_Text_Util.Process_Status_Update_Event ...', FND_LOG.LEVEL_EVENT, l_api_name);

1754: , p_maxtime => p_maxtime
1755: , p_index_name => l_Index_Name
1756: );
1757: ELSIF (p_action = 5) THEN
1758: Log_Line ('Calling Eam_Text_Util.Process_Status_Update_Event ...', FND_LOG.LEVEL_EVENT, l_api_name);
1759:
1760: Eam_Text_Util.Process_Status_Update_Event(p_status_id => p_dummy1, --User Defined Status Id whose status code has been updated
1761: p_commit => FND_API.G_TRUE,
1762: x_return_status => l_return_status);

Line 1764: Log_Line ('after calling update status event ...Return Status is : '|| l_return_status, FND_LOG.LEVEL_EVENT, l_api_name);

1760: Eam_Text_Util.Process_Status_Update_Event(p_status_id => p_dummy1, --User Defined Status Id whose status code has been updated
1761: p_commit => FND_API.G_TRUE,
1762: x_return_status => l_return_status);
1763:
1764: Log_Line ('after calling update status event ...Return Status is : '|| l_return_status, FND_LOG.LEVEL_EVENT, l_api_name);
1765: END IF;
1766:
1767: END IF;
1768:

Line 1790: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);

1786: IF NOT(g_Conc_Req_flag) THEN
1787: FND_FILE.Close;
1788: END IF;
1789:
1790: Log_Line (l_api_name || ': end', FND_LOG.LEVEL_EVENT, l_api_name);
1791:
1792: EXCEPTION
1793:
1794: WHEN G_EXC_ERROR THEN

Line 1795: Log_Line (l_api_name || ': Error.', FND_LOG.LEVEL_EVENT, l_api_name);

1791:
1792: EXCEPTION
1793:
1794: WHEN G_EXC_ERROR THEN
1795: Log_Line (l_api_name || ': Error.', FND_LOG.LEVEL_EVENT, l_api_name);
1796: RETCODE := G_RETCODE_ERROR;
1797: ERRBUF := FND_MESSAGE.Get_String('EAM', 'EAM_TEXT_INDEX_FAILURE');
1798: ERRBUF := substr(ERRBUF || '(' || G_PKG_NAME || '.' ||G_PKG_NAME||'):'|| SQLERRM,1,240);
1799: log_line(ERRBUF, FND_LOG.LEVEL_EVENT, l_api_name);

Line 1799: log_line(ERRBUF, FND_LOG.LEVEL_EVENT, l_api_name);

1795: Log_Line (l_api_name || ': Error.', FND_LOG.LEVEL_EVENT, l_api_name);
1796: RETCODE := G_RETCODE_ERROR;
1797: ERRBUF := FND_MESSAGE.Get_String('EAM', 'EAM_TEXT_INDEX_FAILURE');
1798: ERRBUF := substr(ERRBUF || '(' || G_PKG_NAME || '.' ||G_PKG_NAME||'):'|| SQLERRM,1,240);
1799: log_line(ERRBUF, FND_LOG.LEVEL_EVENT, l_api_name);
1800:
1801: IF NOT(g_Conc_Req_flag) THEN
1802: FND_FILE.Close;
1803: END IF;

Line 1806: Log_Line (l_api_name || ': Unexpected Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);

1802: FND_FILE.Close;
1803: END IF;
1804:
1805: WHEN others THEN
1806: Log_Line (l_api_name || ': Unexpected Error: ' || SQLERRM, FND_LOG.LEVEL_EVENT, l_api_name);
1807: RETCODE := G_RETCODE_ERROR;
1808: ERRBUF := FND_MESSAGE.Get_String('EAM', 'EAM_CP_FAILURE');
1809: ERRBUF := substr(ERRBUF || '(' || G_PKG_NAME || '.' ||G_PKG_NAME||'):'|| SQLERRM,1,240);
1810:

Line 1837: log_line(l_api_name ||' : Started AD_CTX_DDL.Optimize_Index..', FND_LOG.LEVEL_EVENT, l_api_name);

1833: l_maxtime NUMBER := NVL(p_maxtime,AD_CTX_DDL.Maxtime_Unlimited);
1834:
1835: BEGIN
1836:
1837: log_line(l_api_name ||' : Started AD_CTX_DDL.Optimize_Index..', FND_LOG.LEVEL_EVENT, l_api_name);
1838: log_line(l_api_name ||' : Optimization Level :'||p_optlevel, FND_LOG.LEVEL_EVENT, l_api_name);
1839: log_line(l_api_name ||' : Maximum Optimization Time :'||p_maxtime, FND_LOG.LEVEL_EVENT, l_api_name);
1840:
1841: x_return_status := G_STATUS_SUCCESS;

Line 1838: log_line(l_api_name ||' : Optimization Level :'||p_optlevel, FND_LOG.LEVEL_EVENT, l_api_name);

1834:
1835: BEGIN
1836:
1837: log_line(l_api_name ||' : Started AD_CTX_DDL.Optimize_Index..', FND_LOG.LEVEL_EVENT, l_api_name);
1838: log_line(l_api_name ||' : Optimization Level :'||p_optlevel, FND_LOG.LEVEL_EVENT, l_api_name);
1839: log_line(l_api_name ||' : Maximum Optimization Time :'||p_maxtime, FND_LOG.LEVEL_EVENT, l_api_name);
1840:
1841: x_return_status := G_STATUS_SUCCESS;
1842:

Line 1839: log_line(l_api_name ||' : Maximum Optimization Time :'||p_maxtime, FND_LOG.LEVEL_EVENT, l_api_name);

1835: BEGIN
1836:
1837: log_line(l_api_name ||' : Started AD_CTX_DDL.Optimize_Index..', FND_LOG.LEVEL_EVENT, l_api_name);
1838: log_line(l_api_name ||' : Optimization Level :'||p_optlevel, FND_LOG.LEVEL_EVENT, l_api_name);
1839: log_line(l_api_name ||' : Maximum Optimization Time :'||p_maxtime, FND_LOG.LEVEL_EVENT, l_api_name);
1840:
1841: x_return_status := G_STATUS_SUCCESS;
1842:
1843: -- Maxtime should be null for FAST Optimize mode

Line 1852: log_line(l_api_name ||' : Completed AD_CTX_DDL.Optimize_Index..', FND_LOG.LEVEL_EVENT, l_api_name);

1848: AD_CTX_DDL.Optimize_Index ( idx_name => g_Index_Owner ||'.'|| p_index_name
1849: , optlevel => NVL(p_optlevel,AD_CTX_DDL.Optlevel_Full)
1850: , maxtime => l_maxtime);
1851:
1852: log_line(l_api_name ||' : Completed AD_CTX_DDL.Optimize_Index..', FND_LOG.LEVEL_EVENT, l_api_name);
1853:
1854:
1855: EXCEPTION
1856: WHEN OTHERS THEN

Line 1858: log_line(l_api_name ||' : Index optimization has failed ...', FND_LOG.LEVEL_EVENT, l_api_name);

1854:
1855: EXCEPTION
1856: WHEN OTHERS THEN
1857: x_return_status := G_STATUS_UNEXP_ERROR;
1858: log_line(l_api_name ||' : Index optimization has failed ...', FND_LOG.LEVEL_EVENT, l_api_name);
1859: -- conc_status := FND_CONCURRENT.set_completion_status('ERROR', l_err_msg);
1860:
1861: END Optimize_Index;
1862: -- End : Concurrent Program for Optimize iM index