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_UPDATE_DIM dependencies on BSC_UPDATE_LOG

Line 4312: BSC_UPDATE_LOG.Write_Errors_To_Log;

4308: WHEN e_unexpected_error THEN
4309: BSC_MESSAGE.flush;
4310: COMMIT;
4311:
4312: BSC_UPDATE_LOG.Write_Errors_To_Log;
4313:
4314: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR');
4315: RETCODE := 2; -- Request completed with errors
4316:

Line 4322: BSC_UPDATE_LOG.Write_Errors_To_Log;

4318: WHEN e_could_not_get_lock THEN
4319: BSC_MESSAGE.flush;
4320: COMMIT;
4321:
4322: BSC_UPDATE_LOG.Write_Errors_To_Log;
4323:
4324: ERRBUF := 'Loader could not get the required locks to continue.';
4325: RETCODE := 2; -- Request completed with errors
4326:

Line 4336: BSC_UPDATE_LOG.Write_Errors_To_Log;

4332: x_source => 'BSC_UPDATE_DIM.Refresh_Dbi_Dimension',
4333: x_mode => 'I');
4334: COMMIT;
4335:
4336: BSC_UPDATE_LOG.Write_Errors_To_Log;
4337:
4338: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UNEXPECTED_ERROR');
4339: RETCODE := 2; -- Request completed with errors
4340:

Line 4577: BSC_UPDATE_LOG.Write_Line_Log(x_dimension_table, BSC_UPDATE_LOG.OUTPUT);

4573: IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(x_dimension_table,
4574: x_checked_dimensions,
4575: x_num_checked_dimensions) THEN
4576:
4577: BSC_UPDATE_LOG.Write_Line_Log(x_dimension_table, BSC_UPDATE_LOG.OUTPUT);
4578:
4579: -- Add the dimension to the array x_checked dimensions
4580: x_num_checked_dimensions := x_num_checked_dimensions + 1;
4581: x_checked_dimensions(x_num_checked_dimensions) := x_dimension_table;

Line 4738: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_REFRESHING_EDW_DIM'), BSC_UPDATE_LOG.OUTPUT);

4734: h_num_checked_dimensions := 0;
4735:
4736: -- Refresh each dimension. It will be adding modified dimension in the array
4737: -- Also, it will delete from B, S tables the deleted dimension values
4738: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_REFRESHING_EDW_DIM'), BSC_UPDATE_LOG.OUTPUT);
4739: FOR h_i IN 1 .. x_num_dimension_tables LOOP
4740: IF NOT Refresh_EDW_Dimension(x_dimension_tables(h_i),
4741: h_mod_dimensions,
4742: h_num_mod_dimensions,

Line 4754: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_RECALC_KPI_DIMTABLES'), BSC_UPDATE_LOG.OUTPUT);

4750: -- that dimension.
4751: -- This procedure mark the affected KPIs with prototype 6 (Recalc data).
4752: -- Once the kpis are marked, Incremental changes will re calculate the data.
4753: IF h_num_mod_dimensions > 0 THEN
4754: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_RECALC_KPI_DIMTABLES'), BSC_UPDATE_LOG.OUTPUT);
4755: FOR h_i IN 1..h_num_mod_dimensions LOOP
4756:
4757: UPDATE BSC_KPIS_B K
4758: SET PROTOTYPE_FLAG = 6,

Line 5153: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);

5149: FETCH h_cursor INTO h_code;
5150: IF h_cursor%NOTFOUND THEN
5151: -- The default value wa deleted
5152: IF NOT h_header THEN
5153: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
5154: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5155: BSC_UPDATE_LOG.OUTPUT);
5156: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DFT_DIMVALUE_MISSING'), BSC_UPDATE_LOG.OUTPUT);
5157: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

Line 5154: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

5150: IF h_cursor%NOTFOUND THEN
5151: -- The default value wa deleted
5152: IF NOT h_header THEN
5153: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
5154: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5155: BSC_UPDATE_LOG.OUTPUT);
5156: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DFT_DIMVALUE_MISSING'), BSC_UPDATE_LOG.OUTPUT);
5157: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5158: BSC_UPDATE_LOG.OUTPUT);

Line 5155: BSC_UPDATE_LOG.OUTPUT);

5151: -- The default value wa deleted
5152: IF NOT h_header THEN
5153: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
5154: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5155: BSC_UPDATE_LOG.OUTPUT);
5156: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DFT_DIMVALUE_MISSING'), BSC_UPDATE_LOG.OUTPUT);
5157: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5158: BSC_UPDATE_LOG.OUTPUT);
5159: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'KPI_CODE'), C_INDICATOR_W)||

Line 5156: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DFT_DIMVALUE_MISSING'), BSC_UPDATE_LOG.OUTPUT);

5152: IF NOT h_header THEN
5153: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
5154: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5155: BSC_UPDATE_LOG.OUTPUT);
5156: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DFT_DIMVALUE_MISSING'), BSC_UPDATE_LOG.OUTPUT);
5157: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5158: BSC_UPDATE_LOG.OUTPUT);
5159: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'KPI_CODE'), C_INDICATOR_W)||
5160: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_TABLE_NAME'), C_DIMENSION_TABLE_W)||

Line 5157: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',

5153: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
5154: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5155: BSC_UPDATE_LOG.OUTPUT);
5156: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DFT_DIMVALUE_MISSING'), BSC_UPDATE_LOG.OUTPUT);
5157: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5158: BSC_UPDATE_LOG.OUTPUT);
5159: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'KPI_CODE'), C_INDICATOR_W)||
5160: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_TABLE_NAME'), C_DIMENSION_TABLE_W)||
5161: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DEFAULT_VALUE'), C_DEFAULT_VALUE_W),

Line 5158: BSC_UPDATE_LOG.OUTPUT);

5154: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5155: BSC_UPDATE_LOG.OUTPUT);
5156: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DFT_DIMVALUE_MISSING'), BSC_UPDATE_LOG.OUTPUT);
5157: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5158: BSC_UPDATE_LOG.OUTPUT);
5159: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'KPI_CODE'), C_INDICATOR_W)||
5160: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_TABLE_NAME'), C_DIMENSION_TABLE_W)||
5161: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DEFAULT_VALUE'), C_DEFAULT_VALUE_W),
5162: BSC_UPDATE_LOG.OUTPUT);

Line 5159: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'KPI_CODE'), C_INDICATOR_W)||

5155: BSC_UPDATE_LOG.OUTPUT);
5156: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DFT_DIMVALUE_MISSING'), BSC_UPDATE_LOG.OUTPUT);
5157: BSC_UPDATE_LOG.Write_Line_Log('+---------------------------------------------------------------------------+',
5158: BSC_UPDATE_LOG.OUTPUT);
5159: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'KPI_CODE'), C_INDICATOR_W)||
5160: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_TABLE_NAME'), C_DIMENSION_TABLE_W)||
5161: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DEFAULT_VALUE'), C_DEFAULT_VALUE_W),
5162: BSC_UPDATE_LOG.OUTPUT);
5163: h_header := TRUE;

Line 5162: BSC_UPDATE_LOG.OUTPUT);

5158: BSC_UPDATE_LOG.OUTPUT);
5159: BSC_UPDATE_LOG.Write_Line_Log(RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_BACKEND', 'KPI_CODE'), C_INDICATOR_W)||
5160: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_TABLE_NAME'), C_DIMENSION_TABLE_W)||
5161: RPAD(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DEFAULT_VALUE'), C_DEFAULT_VALUE_W),
5162: BSC_UPDATE_LOG.OUTPUT);
5163: h_header := TRUE;
5164: END IF;
5165:
5166: --Fix bug#4080680 do not use TO_CHAR(h_defualt_key_value)

Line 5167: BSC_UPDATE_LOG.Write_Line_Log(RPAD(TO_CHAR(h_indicator), C_INDICATOR_W)||

5163: h_header := TRUE;
5164: END IF;
5165:
5166: --Fix bug#4080680 do not use TO_CHAR(h_defualt_key_value)
5167: BSC_UPDATE_LOG.Write_Line_Log(RPAD(TO_CHAR(h_indicator), C_INDICATOR_W)||
5168: RPAD(h_level_table_name, C_DIMENSION_TABLE_W)||
5169: RPAD(h_default_key_value, C_DEFAULT_VALUE_W),
5170: BSC_UPDATE_LOG.OUTPUT);
5171: END IF;

Line 5170: BSC_UPDATE_LOG.OUTPUT);

5166: --Fix bug#4080680 do not use TO_CHAR(h_defualt_key_value)
5167: BSC_UPDATE_LOG.Write_Line_Log(RPAD(TO_CHAR(h_indicator), C_INDICATOR_W)||
5168: RPAD(h_level_table_name, C_DIMENSION_TABLE_W)||
5169: RPAD(h_default_key_value, C_DEFAULT_VALUE_W),
5170: BSC_UPDATE_LOG.OUTPUT);
5171: END IF;
5172: CLOSE h_cursor;
5173:
5174: FETCH c_indicators INTO h_indicator, h_level_table_name, h_default_key_value;

Line 5178: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);

5174: FETCH c_indicators INTO h_indicator, h_level_table_name, h_default_key_value;
5175: END LOOP;
5176: CLOSE c_indicators;
5177:
5178: BSC_UPDATE_LOG.Write_Line_Log('', BSC_UPDATE_LOG.OUTPUT);
5179:
5180: RETURN TRUE;
5181:
5182: EXCEPTION