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_DOC_PKG dependencies on FND_LOG

Line 52: BSC_METADATA_OPTIMIZER_PKG.g_log_level := FND_LOG.g_current_runtime_level;

48: IF (FND_PROFILE.VALUE('BIS_PMF_DEBUG') = 'Y') THEN
49: BSC_METADATA_OPTIMIZER_PKG.g_debug := TRUE;
50: BSC_METADATA_OPTIMIZER_PKG.g_log_level := fnd_profile.value('AFLOG_LEVEL');
51: ELSE -- IF BIS_PMF_DEBUG is set, then enable logging automatically
52: BSC_METADATA_OPTIMIZER_PKG.g_log_level := FND_LOG.g_current_runtime_level;
53: END IF;
54:
55: IF BSC_METADATA_OPTIMIZER_PKG.g_dir is null THEN
56: BSC_METADATA_OPTIMIZER_PKG.g_dir:=BSC_METADATA_OPTIMIZER_PKG.getUtlFileDir;

Line 150: bsc_mo_helper_pkg.writeTmp('TableName :' ||TableName||', pos='||pos, fnd_log.level_statement, true);

146: Return MVName;
147: EXCEPTION WHEN OTHERS THEN
148: g_error := sqlerrm;
149: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in Documentation.GetSumTableMVName :' ||g_error);
150: bsc_mo_helper_pkg.writeTmp('TableName :' ||TableName||', pos='||pos, fnd_log.level_statement, true);
151: raise;
152: End ;
153: --****************************************************************************
154: -- WRITELINETEXTFILE

Line 175: BSC_MO_HELPER_PKG.writeTmp('Inside WriteDocHeader', FND_LOG.LEVEL_PROCEDURE);

171: --****************************************************************************
172: PROCEDURE WriteDocHeader IS
173: BEGIN
174: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
175: BSC_MO_HELPER_PKG.writeTmp('Inside WriteDocHeader', FND_LOG.LEVEL_PROCEDURE);
176: END IF;
177:
178: WriteLineTextFile( '+---------------------------------------------------------------------------+');
179: WriteLineTextFile( 'Oracle Balanced Scorecard: Version : ' || BSC_METADATA_OPTIMIZER_PKG.VERSION);

Line 187: BSC_MO_HELPER_PKG.writeTmp('Completed WriteDocHeader', FND_LOG.LEVEL_PROCEDURE);

183: -- Changed 'Metadata Optimizer' to 'Generated Database' in the following statement
184: WriteLineTextFile( 'Module: Generate Database');
185: WriteLineTextFile( '+---------------------------------------------------------------------------+');
186: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
187: BSC_MO_HELPER_PKG.writeTmp('Completed WriteDocHeader', FND_LOG.LEVEL_PROCEDURE);
188: END IF;
189:
190: End ;
191: --****************************************************************************

Line 306: bsc_mo_helper_pkg.writeTmp('Inside DocResult', FND_LOG.LEVEL_PROCEDURE);

302: l_fields DBMS_SQL.VARCHAR2_TABLE;
303: l_sumLevelChangedMsg VARCHAR2(1000);
304: BEGIN
305: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
306: bsc_mo_helper_pkg.writeTmp('Inside DocResult', FND_LOG.LEVEL_PROCEDURE);
307: END IF;
308: WriteLineTextFile (BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'METADATA_OPTIMIZER_RESULT'));
309: WriteLineTextFile (StrX('-', Length(BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'METADATA_OPTIMIZER_RESULT'))));
310: --Bug#3306248

Line 506: bsc_mo_helper_pkg.writeTmp('Completed DocResult', FND_LOG.LEVEL_PROCEDURE);

502: EXIT WHEN l_index1 = BSC_METADATA_OPTIMIZER_PKG.gIndicators.last;
503: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_index1);
504: END LOOP;
505: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
506: bsc_mo_helper_pkg.writeTmp('Completed DocResult', FND_LOG.LEVEL_PROCEDURE);
507: END IF;
508: EXCEPTION WHEN OTHERS THEN
509: BSC_MO_HELPER_PKG.TerminateWithMsg(sqlerrm, 'DocResult');
510: bsc_mo_helper_pkg.writeTmp('Exception in DocResult, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);

Line 510: bsc_mo_helper_pkg.writeTmp('Exception in DocResult, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);

506: bsc_mo_helper_pkg.writeTmp('Completed DocResult', FND_LOG.LEVEL_PROCEDURE);
507: END IF;
508: EXCEPTION WHEN OTHERS THEN
509: BSC_MO_HELPER_PKG.TerminateWithMsg(sqlerrm, 'DocResult');
510: bsc_mo_helper_pkg.writeTmp('Exception in DocResult, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);
511: bsc_mo_helper_pkg.TerminateWithError('BSC_RESULT_REPORT_FAILED', 'DocResult');
512: raise;
513: End;
514:

Line 805: BSC_MO_HELPER_PKG.writeTmp('Processing column:'||rsColumn_Name, FND_LOG.LEVEL_STATEMENT);

801: ELSE
802: Linea := Linea || StrFix(rsData_Length, SIZELENGTH);
803: End If;
804: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
805: BSC_MO_HELPER_PKG.writeTmp('Processing column:'||rsColumn_Name, FND_LOG.LEVEL_STATEMENT);
806: END IF;
807: If BSC_MO_INDICATOR_PKG.keyFieldExists(Table_Keys, rsColumn_Name) Then
808: BSC_MO_HELPER_PKG.writeTmp('Its a key', FND_LOG.LEVEL_STATEMENT);
809: If Tabla.Type = 0 Then -- input table

Line 808: BSC_MO_HELPER_PKG.writeTmp('Its a key', FND_LOG.LEVEL_STATEMENT);

804: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
805: BSC_MO_HELPER_PKG.writeTmp('Processing column:'||rsColumn_Name, FND_LOG.LEVEL_STATEMENT);
806: END IF;
807: If BSC_MO_INDICATOR_PKG.keyFieldExists(Table_Keys, rsColumn_Name) Then
808: BSC_MO_HELPER_PKG.writeTmp('Its a key', FND_LOG.LEVEL_STATEMENT);
809: If Tabla.Type = 0 Then -- input table
810: Linea := Linea || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'USER_CODE');
811: Else
812: Linea := Linea || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'CODE');

Line 915: BSC_MO_HELPER_PKG.writeTmp('Inside WriteInputAndSystemTables', FND_LOG.LEVEL_PROCEDURE);

911: arrMvs DBMS_SQL.VARCHAR2_TABLE;
912: numMVs NUMBER := 0;
913: BEGIn
914: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
915: BSC_MO_HELPER_PKG.writeTmp('Inside WriteInputAndSystemTables', FND_LOG.LEVEL_PROCEDURE);
916: END IF;
917: --Input tables
918: WriteLineTextFile (BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'INPUT_TABLES_DESCRIPTION'));
919: WriteLineTextFile (StrX('-', Length(BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_BACKEND', 'INPUT_TABLES_DESCRIPTION'))));

Line 944: bsc_mo_helper_pkg.writeTmp('SYNONYM', FND_LOG.LEVEL_STATEMENT);

940: --BSC-MV Note: If the table is a base table then write the description of the table.
941: --If not then write the description of the MV (if exists)
942: If BSC_MO_LOADER_CONFIG_PKG.isBasicTable(l_table.Name) Then
943: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
944: bsc_mo_helper_pkg.writeTmp('SYNONYM', FND_LOG.LEVEL_STATEMENT);
945: END IF;
946: writeTableDescription (l_table);
947: l_table.dbObjectType := 'SYNONYM';
948: Else

Line 972: BSC_MO_HELPER_PKG.writeTmp('Completed WriteInputAndSystemTables', FND_LOG.LEVEL_PROCEDURE);

968: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gTables.next(l_index1);
969: END LOOP;
970: END IF;
971: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
972: BSC_MO_HELPER_PKG.writeTmp('Completed WriteInputAndSystemTables', FND_LOG.LEVEL_PROCEDURE);
973: END IF;
974: EXCEPTION WHEN OTHERS THEN
975: BSC_MO_HELPER_PKG.TerminateWithMsg(sqlerrm);
976: bsc_mo_helper_pkg.writeTmp('Exception in WriteInputAndSystemTables, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);

Line 976: bsc_mo_helper_pkg.writeTmp('Exception in WriteInputAndSystemTables, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);

972: BSC_MO_HELPER_PKG.writeTmp('Completed WriteInputAndSystemTables', FND_LOG.LEVEL_PROCEDURE);
973: END IF;
974: EXCEPTION WHEN OTHERS THEN
975: BSC_MO_HELPER_PKG.TerminateWithMsg(sqlerrm);
976: bsc_mo_helper_pkg.writeTmp('Exception in WriteInputAndSystemTables, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);
977: bsc_mo_helper_pkg.TerminateWithError('BSC_DATATABLE_DOC_FAILED', 'WriteInputAndSystemTables');
978: raise;
979: End ;
980: --****************************************************************************

Line 1007: bsc_mo_helper_pkg.writeTmp('Inside SetNeedCod0InOriTables', FND_LOG.LEVEL_PROCEDURE);

1003:
1004:
1005: BEGIN
1006: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1007: bsc_mo_helper_pkg.writeTmp('Inside SetNeedCod0InOriTables', FND_LOG.LEVEL_PROCEDURE);
1008: END IF;
1009: numTablesOri := 0;
1010: For i IN 0..numTablesCod0 - 1 LOOP
1011: l_table_index_in_gTables := BSC_MO_HELPER_PKG.findIndex(BSC_METADATA_OPTIMIZER_PKG.gTables, arrTablesCod0(i));

Line 1048: bsc_mo_helper_pkg.writeTmp('Completed SetNeedCod0InOriTables', FND_LOG.LEVEL_PROCEDURE);

1044: If numTablesOri > 0 Then
1045: SetNeedCod0InOriTables(arrTablesOri, numTablesOri);
1046: End If;
1047: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1048: bsc_mo_helper_pkg.writeTmp('Completed SetNeedCod0InOriTables', FND_LOG.LEVEL_PROCEDURE);
1049: END IF;
1050: EXCEPTION WHEN OTHERS THEN
1051: g_error := sqlerrm;
1052: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in Documentation.writeTableDescription :' ||g_error);

Line 1122: BSC_MO_HELPER_PKG.writeTmp(sqlerrm, fnd_log.level_statement, true);

1118: return l_result_string;
1119: EXCEPTION WHEN OTHERS THEN
1120: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in ReplaceStr, param1= '||p_string||', param2='||p_replace_from||',param3='||p_replace_to);
1121: BSC_MO_HELPER_PKG.TerminateWithMsg(sqlerrm);
1122: BSC_MO_HELPER_PKG.writeTmp(sqlerrm, fnd_log.level_statement, true);
1123: raise;
1124: End ;
1125:
1126: FUNCTION getIndicsForTable (l_tableName IN VARCHAR2, l_num OUT NOCOPY NUMBER) RETURN VARCHAR2 IS

Line 1295: bsc_mo_helper_pkg.writeTmp('Inside inicalltables '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE);

1291:
1292: BEGIN
1293: --Set gTablas = New Collection
1294: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1295: bsc_mo_helper_pkg.writeTmp('Inside inicalltables '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE);
1296: END IF;
1297: if (g_mode = 1) then --
1298: if (BSC_METADATA_OPTIMIZER_PKG.gGAA_RUN_MODE<>0) then
1299: l_stmt := l_stmt||

Line 1496: bsc_mo_helper_pkg.writeTmp('Completed inicalltables '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE);

1492: If numTablesCod0 > 0 Then
1493: SetNeedCod0InOriTables( arrTablesCod0, numTablesCod0);
1494: End If;
1495: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1496: bsc_mo_helper_pkg.writeTmp('Completed inicalltables '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE);
1497: END IF;
1498: Exception when others then
1499: bsc_mo_helper_pkg.writeTmp('l_stmt='||l_stmt, fnd_log.level_exception, true);
1500: BSC_MO_HELPER_PKG.TerminateWithMsg(' Exception in inicalltables:'||sqlerrm||', dumping gTables ');

Line 1499: bsc_mo_helper_pkg.writeTmp('l_stmt='||l_stmt, fnd_log.level_exception, true);

1495: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1496: bsc_mo_helper_pkg.writeTmp('Completed inicalltables '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_PROCEDURE);
1497: END IF;
1498: Exception when others then
1499: bsc_mo_helper_pkg.writeTmp('l_stmt='||l_stmt, fnd_log.level_exception, true);
1500: BSC_MO_HELPER_PKG.TerminateWithMsg(' Exception in inicalltables:'||sqlerrm||', dumping gTables ');
1501: bsc_mo_helper_pkg.write_this(bsc_metadata_optimizer_pkg.gTables, FND_LOG.LEVEL_EXCEPTION, true);
1502: raise;
1503: End;

Line 1501: bsc_mo_helper_pkg.write_this(bsc_metadata_optimizer_pkg.gTables, FND_LOG.LEVEL_EXCEPTION, true);

1497: END IF;
1498: Exception when others then
1499: bsc_mo_helper_pkg.writeTmp('l_stmt='||l_stmt, fnd_log.level_exception, true);
1500: BSC_MO_HELPER_PKG.TerminateWithMsg(' Exception in inicalltables:'||sqlerrm||', dumping gTables ');
1501: bsc_mo_helper_pkg.write_this(bsc_metadata_optimizer_pkg.gTables, FND_LOG.LEVEL_EXCEPTION, true);
1502: raise;
1503: End;
1504:
1505: --****************************************************************************

Line 1533: bsc_mo_helper_pkg.writeTmp('Inside InicAllIndicadores', FND_LOG.LEVEL_PROCEDURE);

1529: cRow c1%ROWTYPE;
1530: l_impl_type number;
1531: BEGIN
1532: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1533: bsc_mo_helper_pkg.writeTmp('Inside InicAllIndicadores', FND_LOG.LEVEL_PROCEDURE);
1534: END IF;
1535:
1536: gDocIndicators.delete;
1537: OPEN C1;

Line 1564: bsc_mo_helper_pkg.writeTmp('Completed InicAllIndicadores', FND_LOG.LEVEL_PROCEDURE);

1560:
1561: END Loop;
1562: Close c1;
1563: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1564: bsc_mo_helper_pkg.writeTmp('Completed InicAllIndicadores', FND_LOG.LEVEL_PROCEDURE);
1565: END IF;
1566: EXCEPTION WHEN OTHERS THEN
1567: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in InicAllIndicadores :'||sqlerrm);
1568: bsc_mo_helper_pkg.writeTmp('Exception in InicAllIndicadores, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);

Line 1568: bsc_mo_helper_pkg.writeTmp('Exception in InicAllIndicadores, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);

1564: bsc_mo_helper_pkg.writeTmp('Completed InicAllIndicadores', FND_LOG.LEVEL_PROCEDURE);
1565: END IF;
1566: EXCEPTION WHEN OTHERS THEN
1567: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in InicAllIndicadores :'||sqlerrm);
1568: bsc_mo_helper_pkg.writeTmp('Exception in InicAllIndicadores, g_stack = '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);
1569: bsc_mo_helper_pkg.TerminateWithError('BSC_KPI_INIT_FAILED', 'InicAllIndicadores');
1570: raise;
1571: End ;
1572:

Line 1612: bsc_mo_helper_pkg.writeTmp(sqlerrm, fnd_log.level_statement, true);

1608: END LOOP;
1609:
1610: return l_return;
1611: EXCEPTION WHEN OTHERS THEN
1612: bsc_mo_helper_pkg.writeTmp(sqlerrm, fnd_log.level_statement, true);
1613: bsc_mo_helper_pkg.WriteTmp ('Exception FindRelationIndex, dimTable is '||dimTable||', CampoRel='||CampoRel, FND_LOG.LEVEL_UNEXPECTED, true);
1614: bsc_mo_helper_pkg.TerminateWithError('BSC_DIMTABLE_DESCR_FAILED', 'FindAuxillaryIndex');
1615: raise;
1616: End;

Line 1613: bsc_mo_helper_pkg.WriteTmp ('Exception FindRelationIndex, dimTable is '||dimTable||', CampoRel='||CampoRel, FND_LOG.LEVEL_UNEXPECTED, true);

1609:
1610: return l_return;
1611: EXCEPTION WHEN OTHERS THEN
1612: bsc_mo_helper_pkg.writeTmp(sqlerrm, fnd_log.level_statement, true);
1613: bsc_mo_helper_pkg.WriteTmp ('Exception FindRelationIndex, dimTable is '||dimTable||', CampoRel='||CampoRel, FND_LOG.LEVEL_UNEXPECTED, true);
1614: bsc_mo_helper_pkg.TerminateWithError('BSC_DIMTABLE_DESCR_FAILED', 'FindAuxillaryIndex');
1615: raise;
1616: End;
1617:

Line 1665: bsc_mo_helper_pkg.writeTmp(sqlerrm, fnd_log.level_statement, true);

1661:
1662: Return -1;
1663:
1664: EXCEPTION WHEN OTHERS THEN
1665: bsc_mo_helper_pkg.writeTmp(sqlerrm, fnd_log.level_statement, true);
1666: bsc_mo_helper_pkg.WriteTmp ('Exception FindAuxillaryIndex, g_stack is '||g_stack, FND_LOG.LEVEL_UNEXPECTED,true);
1667: bsc_mo_helper_pkg.TerminateWithError('BSC_DIMTABLE_DESCR_FAILED', 'FindAuxillaryIndex');
1668: raise;
1669: End;

Line 1666: bsc_mo_helper_pkg.WriteTmp ('Exception FindAuxillaryIndex, g_stack is '||g_stack, FND_LOG.LEVEL_UNEXPECTED,true);

1662: Return -1;
1663:
1664: EXCEPTION WHEN OTHERS THEN
1665: bsc_mo_helper_pkg.writeTmp(sqlerrm, fnd_log.level_statement, true);
1666: bsc_mo_helper_pkg.WriteTmp ('Exception FindAuxillaryIndex, g_stack is '||g_stack, FND_LOG.LEVEL_UNEXPECTED,true);
1667: bsc_mo_helper_pkg.TerminateWithError('BSC_DIMTABLE_DESCR_FAILED', 'FindAuxillaryIndex');
1668: raise;
1669: End;
1670:

Line 1749: bsc_mo_helper_pkg.WriteTmp ('Inside WriteMNDescription', FND_LOG.LEVEL_PROCEDURE);

1745: ORDER BY COLUMN_ID;
1746: cRow c1%ROWTYPE;
1747: BEGIN
1748: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1749: bsc_mo_helper_pkg.WriteTmp ('Inside WriteMNDescription', FND_LOG.LEVEL_PROCEDURE);
1750: END IF;
1751: --Table name
1752: If InputTableFlag Then
1753: --Input table

Line 1846: bsc_mo_helper_pkg.WriteTmp ('Completed WriteMNDescription', FND_LOG.LEVEL_PROCEDURE);

1842: Close c1;
1843: WriteLineTextFile ('');
1844: WriteLineTextFile ('');
1845: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1846: bsc_mo_helper_pkg.WriteTmp ('Completed WriteMNDescription', FND_LOG.LEVEL_PROCEDURE);
1847: END IF;
1848: EXCEPTION WHEN OTHERS THEN
1849: g_error := sqlerrm;
1850: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in Documentation.WriteMNDescription :' ||g_error);

Line 2089: BSC_MO_HELPER_PKG.writeTmp('l_stmt = '||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);

2085: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2086: bsc_mo_helper_pkg.writeTmp('Completed WriteDimDescription');
2087: END IF;
2088: EXCEPTION WHEN OTHERS THEN
2089: BSC_MO_HELPER_PKG.writeTmp('l_stmt = '||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);
2090: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception WriteDimDescription, Error is '||sqlerrm);
2091: bsc_mo_helper_pkg.WriteTmp ('Exception WriteDimDescription, g_stack is '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);
2092: bsc_mo_helper_pkg.TerminateWithError('BSC_DIMTABLE_DESCR_FAILED', 'WriteDimDescription');
2093: raise;

Line 2091: bsc_mo_helper_pkg.WriteTmp ('Exception WriteDimDescription, g_stack is '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);

2087: END IF;
2088: EXCEPTION WHEN OTHERS THEN
2089: BSC_MO_HELPER_PKG.writeTmp('l_stmt = '||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);
2090: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception WriteDimDescription, Error is '||sqlerrm);
2091: bsc_mo_helper_pkg.WriteTmp ('Exception WriteDimDescription, g_stack is '||g_stack, FND_LOG.LEVEL_UNEXPECTED, true);
2092: bsc_mo_helper_pkg.TerminateWithError('BSC_DIMTABLE_DESCR_FAILED', 'WriteDimDescription');
2093: raise;
2094: End ;
2095: --****************************************************************************

Line 2154: BSC_MO_HELPER_PKG.writeTmp('Starting InicAllIndicadores', FND_LOG.LEVEL_STATEMENT);

2150: --Open file of description of system tables (dimension, input and system tables)
2151: g_mode := pMode;
2152: Initialize;
2153: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2154: BSC_MO_HELPER_PKG.writeTmp('Starting InicAllIndicadores', FND_LOG.LEVEL_STATEMENT);
2155: END IF;
2156: --Initialize collection gIndicadores with ALL indicators
2157: InicAllIndicadores;
2158: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 2159: BSC_MO_HELPER_PKG.writeTmp('Starting InicAllTables', FND_LOG.LEVEL_STATEMENT);

2155: END IF;
2156: --Initialize collection gIndicadores with ALL indicators
2157: InicAllIndicadores;
2158: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2159: BSC_MO_HELPER_PKG.writeTmp('Starting InicAllTables', FND_LOG.LEVEL_STATEMENT);
2160: END IF;
2161: --Initialize collection gTablas with ALL tables
2162: InicAllTables;
2163: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 2164: BSC_MO_HELPER_PKG.writeTmp('Inside Documentation', FND_LOG.LEVEL_PROCEDURE);

2160: END IF;
2161: --Initialize collection gTablas with ALL tables
2162: InicAllTables;
2163: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2164: BSC_MO_HELPER_PKG.writeTmp('Inside Documentation', FND_LOG.LEVEL_PROCEDURE);
2165: END IF;
2166: writeDocHeader;
2167: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2168: BSC_MO_HELPER_PKG.writeTmp('Wrote Doc Header', FND_LOG.LEVEL_STATEMENT);

Line 2168: BSC_MO_HELPER_PKG.writeTmp('Wrote Doc Header', FND_LOG.LEVEL_STATEMENT);

2164: BSC_MO_HELPER_PKG.writeTmp('Inside Documentation', FND_LOG.LEVEL_PROCEDURE);
2165: END IF;
2166: writeDocHeader;
2167: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2168: BSC_MO_HELPER_PKG.writeTmp('Wrote Doc Header', FND_LOG.LEVEL_STATEMENT);
2169: END IF;
2170: WriteLineTextFile( '');
2171: WriteLineTextFile( BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'TIME') || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'SYMBOL_COLON') || to_Char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
2172: WriteLineTextFile( '');

Line 2176: BSC_MO_HELPER_PKG.writeTmp('Calling DocumentDimensionTables', FND_LOG.LEVEL_STATEMENT);

2172: WriteLineTextFile( '');
2173: --Description of data tables
2174: IF (pMode = 2) THEN
2175: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2176: BSC_MO_HELPER_PKG.writeTmp('Calling DocumentDimensionTables', FND_LOG.LEVEL_STATEMENT);
2177: END IF;
2178: DocumentDimensionTables;
2179: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2180: BSC_MO_HELPER_PKG.writeTmp('Calling WriteInputAndSystemTables', FND_LOG.LEVEL_STATEMENT);

Line 2180: BSC_MO_HELPER_PKG.writeTmp('Calling WriteInputAndSystemTables', FND_LOG.LEVEL_STATEMENT);

2176: BSC_MO_HELPER_PKG.writeTmp('Calling DocumentDimensionTables', FND_LOG.LEVEL_STATEMENT);
2177: END IF;
2178: DocumentDimensionTables;
2179: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2180: BSC_MO_HELPER_PKG.writeTmp('Calling WriteInputAndSystemTables', FND_LOG.LEVEL_STATEMENT);
2181: END IF;
2182: WriteInputAndSystemTables;
2183: return;
2184: END IF;

Line 2192: BSC_MO_HELPER_PKG.writeTmp('Starting DocResult '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT);

2188: WriteLineTextFile( '');
2189: WriteLineTextFile( BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'TIME') || BSC_MO_HELPER_PKG.Get_LookUp_Value('BSC_UI_COMMON', 'SYMBOL_COLON') || ' ' || to_char(sysdate, 'MMMM DD, YYYY HH:MM:SS'));
2190: WriteLineTextFile( '');
2191: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2192: BSC_MO_HELPER_PKG.writeTmp('Starting DocResult '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT);
2193: END IF;
2194: -- to be called from BSC_METADATA_OPTIMIZER_PKG.Documentation
2195: DocResult;
2196: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 2197: BSC_MO_HELPER_PKG.writeTmp('Done with DocResult', FND_LOG.LEVEL_STATEMENT);

2193: END IF;
2194: -- to be called from BSC_METADATA_OPTIMIZER_PKG.Documentation
2195: DocResult;
2196: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2197: BSC_MO_HELPER_PKG.writeTmp('Done with DocResult', FND_LOG.LEVEL_STATEMENT);
2198: END IF;
2199: End If;
2200: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2201: BSC_MO_HELPER_PKG.writeTmp('Completed Documentation', FND_LOG.LEVEL_PROCEDURE);

Line 2201: BSC_MO_HELPER_PKG.writeTmp('Completed Documentation', FND_LOG.LEVEL_PROCEDURE);

2197: BSC_MO_HELPER_PKG.writeTmp('Done with DocResult', FND_LOG.LEVEL_STATEMENT);
2198: END IF;
2199: End If;
2200: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
2201: BSC_MO_HELPER_PKG.writeTmp('Completed Documentation', FND_LOG.LEVEL_PROCEDURE);
2202: END IF;
2203: EXCEPTION WHEN OTHERS THEN
2204: g_error := sqlerrm;
2205: BSC_MO_HELPER_PKG.TerminateWithMsg('Exception in Documentation.Documentation :' ||g_error);