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.BSC_MO_HELPER_PKG dependencies on BSC_MO_HELPER_PKG

Line 1: Package Body BSC_MO_HELPER_PKG AS

1: Package Body BSC_MO_HELPER_PKG AS
2: /* $Header: BSCMOHPB.pls 120.39 2007/05/18 13:05:50 amitgupt ship $ */
3: g_write_count number := 0;
4: newline VARCHAR2(10):='
5: ';

Line 265: bsc_mo_helper_pkg.writeTmp('Exception in is_Base_Table for '||p_table||':'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

261: ELSE
262: return true;
263: END IF;
264: EXCEPTION WHEN OTHERS THEN
265: bsc_mo_helper_pkg.writeTmp('Exception in is_Base_Table for '||p_table||':'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
266: raise;
267: End ;
268:
269:

Line 289: BSC_MO_HELPER_PKG.TerminateWithMsg(l_error);

285: bsc_utility.do_rollback;
286: BSC_METADATA_OPTIMIZER_PKG.g_errbuf := l_error;
287: BSC_METADATA_OPTIMIZER_PKG.g_retcode := 2;
288: BSC_METADATA_OPTIMIZER_PKG.logProgress('CHECKERROR', apiName);
289: BSC_MO_HELPER_PKG.TerminateWithMsg(l_error);
290: raise BSC_METADATA_OPTIMIZER_PKG.optimizer_exception;
291: END IF;
292:
293: END;

Line 315: bsc_mo_helper_pkg.writeTmp('EXCEPTION in getTablespaceClauseTbl', FND_LOG.LEVEL_UNEXPECTED, true);

311: CLOSE cTableSpace;
312: RETURN l_return_value;
313:
314: EXCEPTION WHEN others then
315: bsc_mo_helper_pkg.writeTmp('EXCEPTION in getTablespaceClauseTbl', FND_LOG.LEVEL_UNEXPECTED, true);
316: RAISE;
317: END;
318:
319: FUNCTION getTablespaceClauseIdx RETURN VARCHAR2 IS

Line 326: bsc_mo_helper_pkg.writeTmp('Inside getTablespaceClauseIdx', FND_LOG.LEVEL_PROCEDURE);

322:
323: cv CurTyp;
324: BEGIN
325: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
326: bsc_mo_helper_pkg.writeTmp('Inside getTablespaceClauseIdx', FND_LOG.LEVEL_PROCEDURE);
327: END IF;
328:
329: l_stmt := 'SELECT BSC_APPS.Get_Tablespace_Clause_Idx FROM DUAL';
330:

Line 336: bsc_mo_helper_pkg.writeTmp('Completed getTablespaceClauseIdx, returning '||l_return_value, FND_LOG.LEVEL_PROCEDURE);

332: FETCH cv INTO l_return_value;
333: CLOSE cv;
334:
335: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
336: bsc_mo_helper_pkg.writeTmp('Completed getTablespaceClauseIdx, returning '||l_return_value, FND_LOG.LEVEL_PROCEDURE);
337: END IF;
338:
339: RETURN l_return_value;
340:

Line 342: bsc_mo_helper_pkg.writeTmp('EXCEPTION in getTablespaceClauseIdx', FND_LOG.LEVEL_UNEXPECTED, true);

338:
339: RETURN l_return_value;
340:
341: EXCEPTION WHEN others then
342: bsc_mo_helper_pkg.writeTmp('EXCEPTION in getTablespaceClauseIdx', FND_LOG.LEVEL_UNEXPECTED, true);
343: RAISE;
344: END;
345:
346: FUNCTION getStorageClause RETURN VARCHAR2 IS

Line 354: bsc_mo_helper_pkg.writeTmp('Inside getStorageClause', FND_LOG.LEVEL_PROCEDURE);

350: SELECT BSC_APPS.Get_Storage_Clause FROM DUAL;
351:
352: BEGIN
353: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
354: bsc_mo_helper_pkg.writeTmp('Inside getStorageClause', FND_LOG.LEVEL_PROCEDURE);
355: END IF;
356:
357: OPEN cStorage;
358: FETCH cStorage INTO l_return_value;

Line 362: bsc_mo_helper_pkg.writeTmp('Completed getStorageClause, returning '||l_return_value, FND_LOG.LEVEL_PROCEDURE);

358: FETCH cStorage INTO l_return_value;
359: CLOSE cStorage;
360:
361: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
362: bsc_mo_helper_pkg.writeTmp('Completed getStorageClause, returning '||l_return_value, FND_LOG.LEVEL_PROCEDURE);
363: END IF;
364:
365: RETURN l_return_value;
366:

Line 368: bsc_mo_helper_pkg.writeTmp('EXCEPTION in getStorageClause', FND_LOG.LEVEL_UNEXPECTED, true);

364:
365: RETURN l_return_value;
366:
367: EXCEPTION WHEN others then
368: bsc_mo_helper_pkg.writeTmp('EXCEPTION in getStorageClause', FND_LOG.LEVEL_UNEXPECTED, true);
369: RAISE;
370: END;
371:
372:

Line 1497: BSC_MO_HELPER_PKG.write_this(pTable, 1, FND_LOG.LEVEL_UNEXPECTED, true);

1493: l_stack := l_stack ||newline||'Adding gTables('||l_temp1||') = '||lTable.name;
1494: BSC_METADATA_OPTIMIZER_PKG.gTables_counter := BSC_METADATA_OPTIMIZER_PKG.gTables_counter + 1;
1495: EXCEPTION WHEN OTHERS THEN
1496: writeTmp('Exception in addTable : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1497: BSC_MO_HELPER_PKG.write_this(pTable, 1, FND_LOG.LEVEL_UNEXPECTED, true);
1498: writeTmp('l_stack is : '||l_stack, FND_LOG.LEVEL_UNEXPECTED, true);
1499: raise;
1500: END;
1501:

Line 1527: --BSC_MO_HELPER_PKG.writeTmp('Adding gTables thru PROC '||proc||

1523: IF findIndex(BSC_METADATA_OPTIMIZER_PKG.gTables, lTable.name) >=0 THEN -- exists
1524: return;
1525: END IF;
1526: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1527: --BSC_MO_HELPER_PKG.writeTmp('Adding gTables thru PROC '||proc||
1528: -- ', gTables('||BSC_METADATA_OPTIMIZER_PKG.gTables_counter||') is '||lTable.name||' with Data = '||pData.count||', Keys='||pKeyFields.count, FND_LOG.LEVEL_STATEMENT);
1529: null;
1530: END IF;
1531:

Line 1644: BSC_MO_HELPER_PKG.writeTmp('Inside SaveOptimizationMode');

1640: i NUMBER;
1641: l_error VARCHAR2(400);
1642: BEGIN
1643: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1644: BSC_MO_HELPER_PKG.writeTmp('Inside SaveOptimizationMode');
1645: END IF;
1646:
1647: IF (BSC_METADATA_OPTIMIZER_PKG.gINdicators.count = 0) THEN
1648: return;

Line 1662: BSC_MO_HELPER_PKG.writeTmp('Completed SaveOptimizationMode');

1658: EXIT WHEN i = BSC_METADATA_OPTIMIZER_PKG.gIndicators.last;
1659: i := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(i);
1660: END LOOP;
1661: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1662: BSC_MO_HELPER_PKG.writeTmp('Completed SaveOptimizationMode');
1663: END IF;
1664:
1665:
1666: EXCEPTION WHEN OTHERS THEN

Line 1692: BSC_MO_HELPER_PKG.writeTmp('Inside table_column_exists', FND_LOG.LEVEL_STATEMENT);

1688: WHERE TABLE_NAME = p_table AND COLUMN_NAME = upper(p_column) AND OWNER = p3;
1689: l_error VARCHAR2(400);
1690: BEGIN
1691: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1692: BSC_MO_HELPER_PKG.writeTmp('Inside table_column_exists', FND_LOG.LEVEL_STATEMENT);
1693: END IF;
1694:
1695: OPEN C1(UPPER(BSC_METADATA_OPTIMIZER_PKG.gBSCSchema));
1696: FETCH c1 INTO l_table;

Line 1700: BSC_MO_HELPER_PKG.writeTmp('Completed table_column_exists, returning TRUE', FND_LOG.LEVEL_STATEMENT);

1696: FETCH c1 INTO l_table;
1697: IF (c1%FOUND) THEN
1698: CLOSE c1;
1699: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1700: BSC_MO_HELPER_PKG.writeTmp('Completed table_column_exists, returning TRUE', FND_LOG.LEVEL_STATEMENT);
1701: END IF;
1702:
1703: return true;
1704: END IF;

Line 1707: BSC_MO_HELPER_PKG.writeTmp('Completed table_column_exists, returning FALSE', FND_LOG.LEVEL_STATEMENT);

1703: return true;
1704: END IF;
1705: CLOSE c1;
1706: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1707: BSC_MO_HELPER_PKG.writeTmp('Completed table_column_exists, returning FALSE', FND_LOG.LEVEL_STATEMENT);
1708: END IF;
1709:
1710: return false;
1711: EXCEPTION WHEN OTHERS THEN

Line 2311: BSC_MO_HELPER_PKG.writeTmp('Inside InitArrReservedWords', FND_LOG.LEVEL_PROCEDURE);

2307:
2308: PROCEDURE InitArrReservedWords IS
2309: BEGIN
2310: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2311: BSC_MO_HELPER_PKG.writeTmp('Inside InitArrReservedWords', FND_LOG.LEVEL_PROCEDURE);
2312: END IF;
2313:
2314: BSC_METADATA_OPTIMIZER_PKG.gNumArrReservedWords := 556;
2315:

Line 2874: BSC_MO_HELPER_PKG.writeTmp('Completed InitArrReservedWords', FND_LOG.LEVEL_PROCEDURE);

2870: BSC_METADATA_OPTIMIZER_PKG.gArrReservedWords(554) := 'XID';
2871: BSC_METADATA_OPTIMIZER_PKG.gArrReservedWords(555) := 'XOR';
2872:
2873: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2874: BSC_MO_HELPER_PKG.writeTmp('Completed InitArrReservedWords', FND_LOG.LEVEL_PROCEDURE);
2875: END IF;
2876:
2877: End;
2878:

Line 2929: BSC_MO_HELPER_PKG.writeTmp('Inside InitLOV', FND_LOG.LEVEL_PROCEDURE);

2925: cRow c1%ROWTYPE;
2926:
2927: BEGIN
2928: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2929: BSC_MO_HELPER_PKG.writeTmp('Inside InitLOV', FND_LOG.LEVEL_PROCEDURE);
2930: END IF;
2931: OPEN c1;
2932: LOOP
2933: FETCH c1 INTO cRow;

Line 2935: FieldLOV := bsc_mo_helper_pkg.new_clsMeasureLOV;

2931: OPEN c1;
2932: LOOP
2933: FETCH c1 INTO cRow;
2934: EXIT WHEN c1%NOTFOUND;
2935: FieldLOV := bsc_mo_helper_pkg.new_clsMeasureLOV;
2936: FieldLOV.fieldName := cRow.MEASURE_COL;
2937: FieldLOV.source := nvl(cRow.Source, 'BSC');
2938: IF (cRow.HELP IS NOT NULL) THEN
2939: FieldLOV.Description := cRow.HELP;

Line 2957: BSC_MO_HELPER_PKG.writeTmp('Completed InitLOV', FND_LOG.LEVEL_PROCEDURE);

2953: BSC_METADATA_OPTIMIZER_PKG.gLOV(BSC_METADATA_OPTIMIZER_PKG.gLOV.Count) := FieldLOV;
2954: END Loop;
2955: CLOSE c1;
2956: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2957: BSC_MO_HELPER_PKG.writeTmp('Completed InitLOV', FND_LOG.LEVEL_PROCEDURE);
2958: END IF;
2959: return;
2960: exception when others then
2961: bsc_mo_helper_pkg.writeTmp('Exception in InitLOV : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

Line 2961: bsc_mo_helper_pkg.writeTmp('Exception in InitLOV : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

2957: BSC_MO_HELPER_PKG.writeTmp('Completed InitLOV', FND_LOG.LEVEL_PROCEDURE);
2958: END IF;
2959: return;
2960: exception when others then
2961: bsc_mo_helper_pkg.writeTmp('Exception in InitLOV : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
2962: TerminateWithError('BSC_VAR_LIST_INIT_FAILED', 'InitLOV');
2963: raise;
2964: End;
2965:

Line 3549: bsc_mo_helper_pkg.writeTmp('Updating prototype_flag for '||l_indicator ||' to 4');

3545: WHERE INDICATOR = l_indicator
3546: AND prototype_flag not in (2,3);
3547: IF (SQL%rowcount>0) THEN
3548: l_stack := l_stack ||'updated '||l_indicator||' to 4';
3549: bsc_mo_helper_pkg.writeTmp('Updating prototype_flag for '||l_indicator ||' to 4');
3550: END IF;
3551: IF (length(l_stack)>30000) THEN
3552: l_stack := substr(l_stack, 20000);
3553: END IF;

Line 3886: bsc_mo_helper_pkg.writeTmp('# Periodicities = '||BSC_METADATA_OPTIMIZER_PKG.gPeriodicities.count);

3882: END LOOP;
3883: CLOSE cPeriods;
3884:
3885: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
3886: bsc_mo_helper_pkg.writeTmp('# Periodicities = '||BSC_METADATA_OPTIMIZER_PKG.gPeriodicities.count);
3887: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gPeriodicities);
3888: END IF;
3889:
3890:

Line 3887: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gPeriodicities);

3883: CLOSE cPeriods;
3884:
3885: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
3886: bsc_mo_helper_pkg.writeTmp('# Periodicities = '||BSC_METADATA_OPTIMIZER_PKG.gPeriodicities.count);
3887: bsc_mo_helper_pkg.write_this(BSC_METADATA_OPTIMIZER_PKG.gPeriodicities);
3888: END IF;
3889:
3890:
3891: --Completes the source of periodicities. For example

Line 4858: BSC_METADATA_OPTIMIZER_PKG.gBscSchema := BSC_MO_HELPER_PKG.getBSCSchema;

4854: uIndex := 1;
4855: nIndex := 1;
4856:
4857: IF (BSC_METADATA_OPTIMIZER_PKG.gBscSchema IS NULL) THEN
4858: BSC_METADATA_OPTIMIZER_PKG.gBscSchema := BSC_MO_HELPER_PKG.getBSCSchema;
4859: END IF;
4860:
4861: IF (BSC_METADATA_OPTIMIZER_PKG.gStorageClause IS NULL) THEN
4862: BSC_METADATA_OPTIMIZER_PKG.gStorageClause := getStorageClause;

Line 5161: BSC_METADATA_OPTIMIZER_PKG.gApplsysSchema := BSC_MO_HELPER_PKG.getApplsysSchema;

5157: x_object_name IN VARCHAR2
5158: ) IS
5159: BEGIN
5160: IF (BSC_METADATA_OPTIMIZER_PKG.gApplsysSchema IS NULL) THEN
5161: BSC_METADATA_OPTIMIZER_PKG.gApplsysSchema := BSC_MO_HELPER_PKG.getApplsysSchema;
5162: END IF;
5163: BSC_APPS.DO_DDL(x_statement=>x_statement ,
5164: x_statement_type => x_statement_type,
5165: x_object_name=> x_object_name);

Line 5525: bsc_mo_helper_pkg.writeTmp( 'Exception in InitInfoOldSystem '||l_ERROR, FND_LOG.LEVEL_UNEXPECTED, true);

5521: writeTmp( 'Compl InitInfoOldSystem, time is '||get_time);
5522: END IF;
5523: EXCEPTION WHEN OTHERS THEN
5524: l_ERROR := sqlerrm;
5525: bsc_mo_helper_pkg.writeTmp( 'Exception in InitInfoOldSystem '||l_ERROR, FND_LOG.LEVEL_UNEXPECTED, true);
5526: RAISE;
5527: END;
5528:
5529:

Line 5561: bsc_mo_helper_pkg.dropTable('BSC_TMP_OPT_KPI_DATA');

5557: BEGIN
5558: writeTmp( 'Inside deletePreviousRunTables, time is '||get_time, FND_LOG.LEVEL_STATEMENT, true);
5559: -- drop UI table used for getRelatedIndicators
5560: begin
5561: bsc_mo_helper_pkg.dropTable('BSC_TMP_OPT_KPI_DATA');
5562: exception when others then
5563: null;
5564: end;
5565: strWhereInIndics := Get_New_Big_In_Cond_Number( 1, 'INDICATOR');

Line 5622: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

5618: FETCH cv INTO mv_name;
5619: EXIT WHEN cv%NOTFOUND;
5620: writeTmp('Drop mv '||mv_name, 1, true);
5621: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5622: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5623: END LOOP;
5624: CLOSE cv;
5625: --BSC-MV Note: Drop all MV used for targets for those KPIs
5626: l_stmt := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME

Line 5637: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

5633: LOOP
5634: FETCH cv INTO mv_name;
5635: EXIT WHEN cv%NOTFOUND;
5636: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5637: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5638: END LOOP;
5639: Close cv;
5640: --BSC-MV Note: Drop all tables created for projections
5641: l_stmt := 'SELECT DISTINCT PROJECTION_DATA FROM BSC_KPI_DATA_TABLES WHERE ('|| strWhereInIndics || ')

Line 5700: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

5696: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5697: IF (bsc_metadata_optimizer_pkg.g_log) then
5698: writeTmp('Dropping summary mv '||mv_name, fnd_log.level_statement, false);
5699: END IF;
5700: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5701: END LOOP;
5702: CLOSE cv;
5703:
5704: --BSC-MV Note: Drop all MV used for targets for those KPIs

Line 5719: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');

5715: FETCH cv INTO mv_name;
5716: EXIT WHEN cv%NOTFOUND;
5717: BSC_BIA_WRAPPER.Drop_Summary_MV_VB(mv_name);
5718: writeTmp('Dropping mv '||mv_name, fnd_log.level_statement, false);
5719: BSC_MO_HELPER_PKG.CheckError('BSC_BIA_WRAPPER.Drop_Summary_MV_VB');
5720: END LOOP;
5721: Close cv;
5722: END IF;
5723: --BSC-MV Note: Do NOT drop tables created for projections. For non-structural

Line 5805: bsc_mo_helper_pkg.writeTmp( 'Exception in deletePreviousRunTables '||l_ERROR, FND_LOG.LEVEL_UNEXPECTED, true);

5801:
5802: writeTmp( 'Compl deletePreviousRunTables, system time is '||get_time, FND_LOG.LEVEL_STATEMENT, true);
5803: EXCEPTION WHEN OTHERS THEN
5804: l_ERROR := sqlerrm;
5805: bsc_mo_helper_pkg.writeTmp( 'Exception in deletePreviousRunTables '||l_ERROR, FND_LOG.LEVEL_UNEXPECTED, true);
5806: RAISE;
5807: End;
5808:
5809: --****************************************************************************

Line 5877: BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE_UTIL.Populate_Calendar_Tables');

5873: --BSC_SYS_PERIODS_TL, etc
5874: IF Calendar.Source = 'BSC' THEN
5875: --BSC Calendar
5876: BSC_UPDATE_UTIL.Populate_Calendar_Tables(Calendar.Code);
5877: BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE_UTIL.Populate_Calendar_Tables');
5878: End IF;
5879: EXIT WHEN l_index1 = BSC_METADATA_OPTIMIZER_PKG.gCalendars.last;
5880: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gCalendars.next(l_index1);
5881: END LOOP;

Line 5903: BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE_UTIL.Populate_Calendar_Tables');

5899: WHERE CALENDAR_ID = Calendar.Code );
5900: IF Calendar.Source = 'BSC' THEN
5901: --BSC Calendar
5902: BSC_UPDATE_UTIL.Populate_Calendar_Tables(Calendar.Code);
5903: BSC_MO_HELPER_PKG.CheckError('BSC_UPDATE_UTIL.Populate_Calendar_Tables');
5904: End IF;
5905:
5906: --BIS DIMENSIONS: We cannot call Populate_Calendar_Tables for BIS Calendars
5907: --The API that imported the BIS Calendars already populated BSC_DB_CALENDAR and

Line 6050: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, p_Table_name );

6046: l_stmt := 'alter table '||p_Table_name ||' drop column '||p_column_name;
6047: --writeTmp(l_stmt);
6048: IF (table_column_exists(p_table_name, p_column_name)) THEN
6049: writeTmp(l_stmt);
6050: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, p_Table_name );
6051: ELSE
6052: writeTmp(p_table_name||'.'||p_column_name||' doesnt exist, so not calling alter table as this was possibly dropped earlier');
6053: END IF;
6054: DELETE bsc_db_tables_cols

Line 6255: BSC_MO_HELPER_PKG.writeTmp('Inside cleanDatabase '||get_time, FND_LOG.LEVEL_PROCEDURE);

6251: l_table_name VARCHAR2(100);
6252: l_owner VARCHAR2(100);
6253: BEGIN
6254: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6255: BSC_MO_HELPER_PKG.writeTmp('Inside cleanDatabase '||get_time, FND_LOG.LEVEL_PROCEDURE);
6256: END IF;
6257: -- Applicable only for MV architecture and non-upgrade scenario
6258: IF (bsc_metadata_optimizer_pkg.g_bsc_mv and bsc_metadata_optimizer_pkg.g_Sum_Level_Change<>1) then
6259: -- Bug 4318566:drop unused MV logs

Line 6263: BSC_MO_HELPER_PKG.writeTmp('Dropped unused mv logs '||get_time, FND_LOG.LEVEL_PROCEDURE);

6259: -- Bug 4318566:drop unused MV logs
6260: drop_unused_mvlogs;
6261: END IF;
6262: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6263: BSC_MO_HELPER_PKG.writeTmp('Dropped unused mv logs '||get_time, FND_LOG.LEVEL_PROCEDURE);
6264: END IF;
6265:
6266: numAllTables := 0;
6267: --Get all the tables used by all indicators

Line 6285: BSC_MO_HELPER_PKG.writeTmp('numAllTables = '||numAllTables||', arrAllTables.count = '||arrAllTables.count||' '||get_time);

6281: --Tables that are in BSC_DB_TABLES (excluding input tables for dimensions) and are not
6282: --in the array arrAllTables() are not used. We need to delete those tables from database
6283: -- and BSC metadata.
6284: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6285: BSC_MO_HELPER_PKG.writeTmp('numAllTables = '||numAllTables||', arrAllTables.count = '||arrAllTables.count||' '||get_time);
6286: END IF;
6287: --So far the array arrAllTables() contains all input, base and summary tables
6288: --used in the whole system
6289: --Tables that are in BSC_DB_TABLES (excluding input tables for dimensions) and are not

Line 6303: BSC_MO_HELPER_PKG.writeTmp('l_stmt = '||l_stmt||' '||get_time);

6299: l_stmt := 'SELECT DISTINCT TABLE_NAME FROM BSC_DB_TABLES WHERE TABLE_TYPE <> :1
6300: minus
6301: select upper(value_v) from bsc_tmp_big_in_cond where variable_id=:2 and session_id = :3';
6302: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6303: BSC_MO_HELPER_PKG.writeTmp('l_stmt = '||l_stmt||' '||get_time);
6304: END IF;
6305:
6306: OPEN cv FOR L_stmt using 2, 1, bsc_metadata_optimizer_pkg.g_session_id;
6307: LOOP

Line 6310: BSC_MO_HELPER_PKG.writeTmp('after fetch '||get_time);

6306: OPEN cv FOR L_stmt using 2, 1, bsc_metadata_optimizer_pkg.g_session_id;
6307: LOOP
6308: FETCH cv INTO l_table;
6309: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6310: BSC_MO_HELPER_PKG.writeTmp('after fetch '||get_time);
6311: END IF;
6312: EXIT WHEN CV%NOTFOUND;
6313: arrNotUsedTables(arrNotUsedTables.count) := l_table;
6314: END Loop;

Line 6372: BSC_MO_HELPER_PKG.writeTmp('Deleted invalid entries from metadata tables '||get_time, FND_LOG.LEVEL_PROCEDURE);

6368: EXECUTE IMMEDIATE ' DELETE FROM BSC_DB_CALCULATIONS WHERE table_name IN '||l_drop_these;
6369: END IF;
6370: END IF;
6371: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6372: BSC_MO_HELPER_PKG.writeTmp('Deleted invalid entries from metadata tables '||get_time, FND_LOG.LEVEL_PROCEDURE);
6373: END IF;
6374: -- If the system is in summary tables mode, then bsc_kpi_properties.implementation_type should be 1
6375: -- clean up any corruption caused by foll. case
6376: -- System in in Summary tables. User changes MV level to 2. User sets KPI as AW impl.

Line 6382: BSC_MO_HELPER_PKG.writeTmp('Updated kpi_properties '||get_time, FND_LOG.LEVEL_PROCEDURE);

6378: IF (BSC_METADATA_OPTIMIZER_PKG.g_BSC_mv=false) THEN
6379: UPDATE BSC_KPI_PROPERTIES set property_value = 1 where property_code = BSC_METADATA_OPTIMIZER_PKG.IMPL_TYPE;
6380: END IF;
6381: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6382: BSC_MO_HELPER_PKG.writeTmp('Updated kpi_properties '||get_time, FND_LOG.LEVEL_PROCEDURE);
6383: END IF;
6384: --DropTable(BSC_METADATA_OPTIMIZER_PKG.g_kpi_tmp_table);
6385: DropTable(BSC_METADATA_OPTIMIZER_PKG.g_dbmeasure_tmp_table );
6386: DropTable(BSC_METADATA_OPTIMIZER_PKG.g_period_circ_check);

Line 6394: BSC_MO_HELPER_PKG.writeTmp('Dropped temp tables '||get_time, FND_LOG.LEVEL_PROCEDURE);

6390: DropTable(BSC_METADATA_OPTIMIZER_PKG.g_db_table_rels_last);
6391: DropTable(BSC_METADATA_OPTIMIZER_PKG.g_kpi_data_last);
6392: DropTable(BSC_METADATA_OPTIMIZER_PKG.g_db_tables_cols_last);
6393: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6394: BSC_MO_HELPER_PKG.writeTmp('Dropped temp tables '||get_time, FND_LOG.LEVEL_PROCEDURE);
6395: END IF;
6396: OPEN cDropThese;
6397: LOOP
6398: FETCH cDropThese INTO l_table_name, l_owner;

Line 6400: BSC_MO_HELPER_PKG.writeTmp('After fetching cursor time is '||get_time, FND_LOG.LEVEL_PROCEDURE);

6396: OPEN cDropThese;
6397: LOOP
6398: FETCH cDropThese INTO l_table_name, l_owner;
6399: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6400: BSC_MO_HELPER_PKG.writeTmp('After fetching cursor time is '||get_time, FND_LOG.LEVEL_PROCEDURE);
6401: END IF;
6402: EXIT WHEN cDropThese%NOTFOUND;
6403: IF (l_owner = BSC_METADATA_OPTIMIZER_PKG.gAppsSchema) THEN -- table in apps schema
6404: execute immediate 'drop table '||l_table_name;

Line 6408: BSC_MO_HELPER_PKG.writeTmp('Dropped left over table '||l_table_name||' '||get_time, FND_LOG.LEVEL_STATEMENT, false);

6404: execute immediate 'drop table '||l_table_name;
6405: ELSE
6406: DropTable(l_table_name);
6407: END IF;
6408: BSC_MO_HELPER_PKG.writeTmp('Dropped left over table '||l_table_name||' '||get_time, FND_LOG.LEVEL_STATEMENT, false);
6409: END LOOP;
6410: CLOSE cDropThese;
6411: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6412: BSC_MO_HELPER_PKG.writeTmp('Completed cleanDatabase '||get_time, FND_LOG.LEVEL_PROCEDURE);

Line 6412: BSC_MO_HELPER_PKG.writeTmp('Completed cleanDatabase '||get_time, FND_LOG.LEVEL_PROCEDURE);

6408: BSC_MO_HELPER_PKG.writeTmp('Dropped left over table '||l_table_name||' '||get_time, FND_LOG.LEVEL_STATEMENT, false);
6409: END LOOP;
6410: CLOSE cDropThese;
6411: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
6412: BSC_MO_HELPER_PKG.writeTmp('Completed cleanDatabase '||get_time, FND_LOG.LEVEL_PROCEDURE);
6413: END IF;
6414: EXCEPTION WHEN OTHERS THEN
6415: writeTmp('Exception in cleanDatabase:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
6416: raise;

Line 6457: BSC_MO_HELPER_PKG.TerminateWithMsg( 'Dumping stack contents ');

6453: l_chunk VARCHAR2(256);
6454: l_varchar2_table DBMS_SQL.VARCHAR2_TABLE;
6455: BEGIN
6456: fnd_file.put_line(FND_FILE.LOG, ' ');
6457: BSC_MO_HELPER_PKG.TerminateWithMsg( 'Dumping stack contents ');
6458: fnd_file.put_line(FND_FILE.LOG, '-------------START OF STACK CONTENTS------------ ');
6459: IF g_stack.count = 0 THEN
6460: return;
6461: END IF;

Line 6581: BSC_MO_HELPER_PKG.writeTmp('Inside UpdateFlags '||get_time, FND_LOG.LEVEL_PROCEDURE, true);

6577: i NUMBER;
6578: l_index NUMBER;
6579: BEGIN
6580:
6581: BSC_MO_HELPER_PKG.writeTmp('Inside UpdateFlags '||get_time, FND_LOG.LEVEL_PROCEDURE, true);
6582:
6583: IF (BSC_METADATA_OPTIMIZER_PKG.gIndicators.count>0) THEN
6584: i := BSC_METADATA_OPTIMIZER_PKG.gIndicators.first;
6585: END IF;

Line 6665: BSC_MO_HELPER_PKG.writeTmp('Completed UpdateFlags'||get_time, FND_LOG.LEVEL_PROCEDURE, true);

6661: DropAppsTables;
6662: End IF;
6663: execute immediate 'delete bsc_tmp_opt_ui_kpis where process_id=:1' using BSC_METADATA_OPTIMIZER_PKG.g_processID;
6664:
6665: BSC_MO_HELPER_PKG.writeTmp('Completed UpdateFlags'||get_time, FND_LOG.LEVEL_PROCEDURE, true);
6666: EXCEPTION WHEN OTHERS THEN
6667: writeTmp('Exception in UpdateFlags:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
6668: raise;
6669:

Line 6900: IF (BSC_MO_HELPER_PKG.findIndex(l_groups, levels(i).group_id) = -1 ) THEN -- new entry

6896: BEGIN
6897: i := levels.first;
6898: LOOP
6899: EXIT WHEN levels.count=0;
6900: IF (BSC_MO_HELPER_PKG.findIndex(l_groups, levels(i).group_id) = -1 ) THEN -- new entry
6901: l_groups(l_count) := levels(i).group_id;
6902: l_count := l_count+1;
6903: END IF;
6904: EXIT WHEN i = levels.last;

Line 6918: IF (BSC_MO_HELPER_PKG.findIndex(l_groups, levels(i).group_id) = -1 ) THEN -- new entry

6914: BEGIN
6915: i := levels.first;
6916: LOOP
6917: EXIT WHEN levels.count=0;
6918: IF (BSC_MO_HELPER_PKG.findIndex(l_groups, levels(i).group_id) = -1 ) THEN -- new entry
6919: l_groups(l_count) := levels(i).group_id;
6920: l_count := l_count+1;
6921: END IF;
6922: EXIT WHEN i = levels.last;

Line 7175: bsc_mo_helper_pkg.writeTmp('Inside InitializeMasterTables', FND_LOG.LEVEL_PROCEDURE, false);

7171:
7172:
7173:
7174: BEGIN
7175: bsc_mo_helper_pkg.writeTmp('Inside InitializeMasterTables', FND_LOG.LEVEL_PROCEDURE, false);
7176: OPEN c1;
7177: LOOP
7178: FETCH c1 INTO cRow1;
7179: EXIT when c1%NOTFOUND;

Line 7180: masterTable := bsc_mo_helper_pkg.new_clsMasterTable;

7176: OPEN c1;
7177: LOOP
7178: FETCH c1 INTO cRow1;
7179: EXIT when c1%NOTFOUND;
7180: masterTable := bsc_mo_helper_pkg.new_clsMasterTable;
7181: masterTable.Name := cRow1.LEVEL_TABLE_NAME;
7182: masterTable.keyName := cRow1.LEVEL_PK_COL;
7183: IF (cRow1.Table_TYPE = 1) THEN
7184: masterTable.userTable := true;

Line 7225: bsc_mo_helper_pkg.writeTmp('Starting MN ');--commit;

7221: l_count_master := l_count_master + 1;
7222: END LOOP;
7223: CLOSE c1;
7224: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
7225: bsc_mo_helper_pkg.writeTmp('Starting MN ');--commit;
7226: END IF;
7227: --gRelacionesMN
7228: --EDW Note: There are no M-N Relations in EDW
7229: --BSC-PMF Integration: There are no M-N Relations in PMF

Line 7250: bsc_mo_helper_pkg.writeTmp('Completed InitializeMasterTables', FND_LOG.LEVEL_PROCEDURE, false);

7246: BSC_METADATA_OPTIMIZER_PKG.gRelationsMN(bsc_metadata_optimizer_pkg.gRelationsMN.count):= RelMN;
7247: CLOSE C5;
7248: END Loop;
7249: CLOSE c4;
7250: bsc_mo_helper_pkg.writeTmp('Completed InitializeMasterTables', FND_LOG.LEVEL_PROCEDURE, false);
7251: Exception when others then
7252: bsc_mo_helper_pkg.writeTmp('exception in InitializeMasterTables', FND_LOG.LEVEL_UNEXPECTED, true);
7253: bsc_mo_helper_pkg.writeTmp('gMasterTables are ', FND_LOG.LEVEL_EXCEPTION, true);
7254: bsc_mo_helper_pkg.write_this(bsc_metadata_optimizer_pkg.gMasterTable, FND_LOG.LEVEL_EXCEPTION, true);

Line 7252: bsc_mo_helper_pkg.writeTmp('exception in InitializeMasterTables', FND_LOG.LEVEL_UNEXPECTED, true);

7248: END Loop;
7249: CLOSE c4;
7250: bsc_mo_helper_pkg.writeTmp('Completed InitializeMasterTables', FND_LOG.LEVEL_PROCEDURE, false);
7251: Exception when others then
7252: bsc_mo_helper_pkg.writeTmp('exception in InitializeMasterTables', FND_LOG.LEVEL_UNEXPECTED, true);
7253: bsc_mo_helper_pkg.writeTmp('gMasterTables are ', FND_LOG.LEVEL_EXCEPTION, true);
7254: bsc_mo_helper_pkg.write_this(bsc_metadata_optimizer_pkg.gMasterTable, FND_LOG.LEVEL_EXCEPTION, true);
7255: raise;
7256:

Line 7253: bsc_mo_helper_pkg.writeTmp('gMasterTables are ', FND_LOG.LEVEL_EXCEPTION, true);

7249: CLOSE c4;
7250: bsc_mo_helper_pkg.writeTmp('Completed InitializeMasterTables', FND_LOG.LEVEL_PROCEDURE, false);
7251: Exception when others then
7252: bsc_mo_helper_pkg.writeTmp('exception in InitializeMasterTables', FND_LOG.LEVEL_UNEXPECTED, true);
7253: bsc_mo_helper_pkg.writeTmp('gMasterTables are ', FND_LOG.LEVEL_EXCEPTION, true);
7254: bsc_mo_helper_pkg.write_this(bsc_metadata_optimizer_pkg.gMasterTable, FND_LOG.LEVEL_EXCEPTION, true);
7255: raise;
7256:
7257: END;

Line 7254: bsc_mo_helper_pkg.write_this(bsc_metadata_optimizer_pkg.gMasterTable, FND_LOG.LEVEL_EXCEPTION, true);

7250: bsc_mo_helper_pkg.writeTmp('Completed InitializeMasterTables', FND_LOG.LEVEL_PROCEDURE, false);
7251: Exception when others then
7252: bsc_mo_helper_pkg.writeTmp('exception in InitializeMasterTables', FND_LOG.LEVEL_UNEXPECTED, true);
7253: bsc_mo_helper_pkg.writeTmp('gMasterTables are ', FND_LOG.LEVEL_EXCEPTION, true);
7254: bsc_mo_helper_pkg.write_this(bsc_metadata_optimizer_pkg.gMasterTable, FND_LOG.LEVEL_EXCEPTION, true);
7255: raise;
7256:
7257: END;
7258:

Line 7299: writeTmp('In bsc_mo_helper_pkg.load_reporting_calendars '||get_time);

7295:
7296: cv CurTyp;
7297:
7298: BEGIN
7299: writeTmp('In bsc_mo_helper_pkg.load_reporting_calendars '||get_time);
7300: IF BSC_METADATA_OPTIMIZER_PKG.g_bsc_mv THEN
7301: writeTmp('going to loop for calendars');
7302: FOR i IN cCalendars LOOP
7303: open cv for l_lud_stmt using i.calendar_id;

Line 7317: BSC_MO_HELPER_PKG.TerminateWithMsg(l_error_message);

7313: writeTmp('Attempting to refresh Calendar id '||i.calendar_id ||
7314: ' changed, calling load reporting calendar for this:'||get_time);
7315: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar(i.calendar_id, l_error_message) THEN
7316: writeTmp('Error Loading reporting calendar :'||l_error_message, FND_LOG.LEVEL_UNEXPECTED, true);
7317: BSC_MO_HELPER_PKG.TerminateWithMsg(l_error_message);
7318: raise BSC_METADATA_OPTIMIZER_PKG.optimizer_exception;
7319: END IF;
7320: writeTmp('Done refreshing Calendar id '||i.calendar_id ||' '||get_time);
7321: -- AW_INTEGRATION: Call aw api to import calendar into aw world

Line 7362: END BSC_MO_HELPER_PKG;

7358: RETURN p_table_name||'_N' || p_index_type;
7359: END IF;
7360: END;
7361:
7362: END BSC_MO_HELPER_PKG;