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

Line 171: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_INCR_CHANGES_REVISION'), BSC_UPDATE_LOG.OUTPUT);

167: h_num_input_tables := 0;
168: h_num_color_indicators := 0;
169: h_num_changed_calendars := 0;
170:
171: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_INCR_CHANGES_REVISION'), BSC_UPDATE_LOG.OUTPUT);
172:
173: -- Check for Fiscal year changes in all calendars
174:
175: -- Initialize the array h_changed_calendars with the code of the calendars

Line 182: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_FISCAL_YEAR_CHANGE'), BSC_UPDATE_LOG.OUTPUT);

178: RAISE e_unexpected_error;
179: END IF;
180:
181: IF h_num_changed_calendars > 0 THEN
182: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_FISCAL_YEAR_CHANGE'), BSC_UPDATE_LOG.OUTPUT);
183: END IF;
184:
185: FOR h_i IN 1..h_num_changed_calendars LOOP
186: h_calendar_id := h_changed_calendars(h_i);

Line 192: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'CALENDAR_NAME')||

188: -- The beginning fiscal year or month was changed. This action invalidates
189: -- the current data for indicators using this calnedar.
190: -- BSC Loader will delete all current data for affected KPIs and recalculate the
191: -- calendar tables.
192: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'CALENDAR_NAME')||
193: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||
194: BSC_UPDATE_UTIL.Get_Calendar_Name(h_calendar_id), BSC_UPDATE_LOG.OUTPUT);
195:
196: IF BSC_UPDATE_UTIL.Get_Calendar_EDW_Flag(h_calendar_id) = 0 THEN

Line 194: BSC_UPDATE_UTIL.Get_Calendar_Name(h_calendar_id), BSC_UPDATE_LOG.OUTPUT);

190: -- BSC Loader will delete all current data for affected KPIs and recalculate the
191: -- calendar tables.
192: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'CALENDAR_NAME')||
193: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||
194: BSC_UPDATE_UTIL.Get_Calendar_Name(h_calendar_id), BSC_UPDATE_LOG.OUTPUT);
195:
196: IF BSC_UPDATE_UTIL.Get_Calendar_EDW_Flag(h_calendar_id) = 0 THEN
197: -- This is just for BSC Calendars
198: --LOCKING: Lock the calendar

Line 205: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INIT')||

201: END IF;
202:
203: -- Fix bug#3822940 We need to validate that this is not a DBI calendar
204: IF BSC_UPDATE_UTIL.Get_Calendar_Source(h_calendar_id) = 'BSC' THEN
205: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INIT')||
206: ' ('||BSC_UPDATE_UTIL.Get_Calendar_Name(h_calendar_id)||')', BSC_UPDATE_LOG.OUTPUT);
207: --LOCKING: Call the autonomous transaction function
208: IF NOT BSC_UPDATE_UTIL.Init_Calendar_Tables_AT(h_calendar_id) THEN
209: RAISE e_unexpected_error;

Line 206: ' ('||BSC_UPDATE_UTIL.Get_Calendar_Name(h_calendar_id)||')', BSC_UPDATE_LOG.OUTPUT);

202:
203: -- Fix bug#3822940 We need to validate that this is not a DBI calendar
204: IF BSC_UPDATE_UTIL.Get_Calendar_Source(h_calendar_id) = 'BSC' THEN
205: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INIT')||
206: ' ('||BSC_UPDATE_UTIL.Get_Calendar_Name(h_calendar_id)||')', BSC_UPDATE_LOG.OUTPUT);
207: --LOCKING: Call the autonomous transaction function
208: IF NOT BSC_UPDATE_UTIL.Init_Calendar_Tables_AT(h_calendar_id) THEN
209: RAISE e_unexpected_error;
210: END IF;

Line 212: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INITIALIZED'), BSC_UPDATE_LOG.OUTPUT);

208: IF NOT BSC_UPDATE_UTIL.Init_Calendar_Tables_AT(h_calendar_id) THEN
209: RAISE e_unexpected_error;
210: END IF;
211:
212: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_INITIALIZED'), BSC_UPDATE_LOG.OUTPUT);
213: END IF;
214:
215: -- We need to load reporting calendar and load calendar into aw
216: IF BSC_APPS.bsc_mv THEN

Line 286: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_SUMTAB_RECALC_REQUIRED'),

282: RAISE e_unexpected_error;
283: END IF;
284:
285: IF h_num_input_tables > 0 THEN
286: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_SUMTAB_RECALC_REQUIRED'),
287: BSC_UPDATE_LOG.OUTPUT);
288: IF NOT BSC_UPDATE.Process_Input_Tables(h_input_tables, h_num_input_tables, 1) THEN
289: RAISE e_unexpected_error;
290: END IF;

Line 287: BSC_UPDATE_LOG.OUTPUT);

283: END IF;
284:
285: IF h_num_input_tables > 0 THEN
286: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_SUMTAB_RECALC_REQUIRED'),
287: BSC_UPDATE_LOG.OUTPUT);
288: IF NOT BSC_UPDATE.Process_Input_Tables(h_input_tables, h_num_input_tables, 1) THEN
289: RAISE e_unexpected_error;
290: END IF;
291: END IF;

Line 313: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_RECALC_REQUIRED'),

309:
310: --LOCKING: Commit to release locks
311: COMMIT;
312:
313: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_RECALC_REQUIRED'),
314: BSC_UPDATE_LOG.OUTPUT);
315: FOR h_i IN 1 .. h_num_color_indicators LOOP
316: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||' '||h_color_indicators(h_i),
317: BSC_UPDATE_LOG.OUTPUT);

Line 314: BSC_UPDATE_LOG.OUTPUT);

310: --LOCKING: Commit to release locks
311: COMMIT;
312:
313: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_RECALC_REQUIRED'),
314: BSC_UPDATE_LOG.OUTPUT);
315: FOR h_i IN 1 .. h_num_color_indicators LOOP
316: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||' '||h_color_indicators(h_i),
317: BSC_UPDATE_LOG.OUTPUT);
318:

Line 316: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||' '||h_color_indicators(h_i),

312:
313: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_RECALC_REQUIRED'),
314: BSC_UPDATE_LOG.OUTPUT);
315: FOR h_i IN 1 .. h_num_color_indicators LOOP
316: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||' '||h_color_indicators(h_i),
317: BSC_UPDATE_LOG.OUTPUT);
318:
319: --LOCKING: Lock indicator color
320: IF NOT BSC_UPDATE_LOCK.Lock_Color_Indicator(h_color_indicators(h_i)) THEN

Line 317: BSC_UPDATE_LOG.OUTPUT);

313: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPICOLOR_RECALC_REQUIRED'),
314: BSC_UPDATE_LOG.OUTPUT);
315: FOR h_i IN 1 .. h_num_color_indicators LOOP
316: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC')||' '||h_color_indicators(h_i),
317: BSC_UPDATE_LOG.OUTPUT);
318:
319: --LOCKING: Lock indicator color
320: IF NOT BSC_UPDATE_LOCK.Lock_Color_Indicator(h_color_indicators(h_i)) THEN
321: RAISE e_could_not_get_lock;

Line 334: BSC_UPDATE_LOG.Write_Line_log(h_message,

330: COMMIT;
331:
332: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC_COMPLETED');
333: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'INDICATOR', TO_CHAR(h_color_indicators(h_i)));
334: BSC_UPDATE_LOG.Write_Line_log(h_message,
335: BSC_UPDATE_LOG.OUTPUT);
336:
337:
338: --LOCKING: Lock the update period of the indicator

Line 335: BSC_UPDATE_LOG.OUTPUT);

331:
332: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_CALC_COMPLETED');
333: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'INDICATOR', TO_CHAR(h_color_indicators(h_i)));
334: BSC_UPDATE_LOG.Write_Line_log(h_message,
335: BSC_UPDATE_LOG.OUTPUT);
336:
337:
338: --LOCKING: Lock the update period of the indicator
339: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicator(h_color_indicators(h_i)) THEN

Line 375: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_INCR_CHANGES_VERIF'), BSC_UPDATE_LOG.OUTPUT);

371:
372: --LOCKING: commit to release locks
373: COMMIT;
374:
375: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_INCR_CHANGES_VERIF'), BSC_UPDATE_LOG.OUTPUT);
376:
377: RETURN TRUE;
378:
379: EXCEPTION

Line 931: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPIDATA_DELETION'), BSC_UPDATE_LOG.OUTPUT);

927: FOR h_i IN 1 .. h_num_purge_tables LOOP
928: BSC_APPS.Add_Value_Big_In_Cond(2, h_purge_tables(h_i));
929: END LOOP;
930:
931: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPIDATA_DELETION'), BSC_UPDATE_LOG.OUTPUT);
932:
933: FOR h_i IN 1 .. x_num_purge_indicators LOOP
934: BSC_UPDATE_LOG.Write_Line_log(x_purge_indicators(h_i), BSC_UPDATE_LOG.OUTPUT);
935: END LOOP;

Line 934: BSC_UPDATE_LOG.Write_Line_log(x_purge_indicators(h_i), BSC_UPDATE_LOG.OUTPUT);

930:
931: BSC_UPDATE_LOG.Write_Line_log(BSC_UPDATE_UTIL.Get_Message('BSC_KPIDATA_DELETION'), BSC_UPDATE_LOG.OUTPUT);
932:
933: FOR h_i IN 1 .. x_num_purge_indicators LOOP
934: BSC_UPDATE_LOG.Write_Line_log(x_purge_indicators(h_i), BSC_UPDATE_LOG.OUTPUT);
935: END LOOP;
936:
937: -- Add to the condition string of the indicators the interrelated
938: -- indicators

Line 949: BSC_UPDATE_LOG.Write_Line_log(h_indicator, BSC_UPDATE_LOG.OUTPUT);

945: FETCH h_cursor INTO h_indicator;
946: WHILE h_cursor%FOUND LOOP
947: BSC_APPS.Add_Value_Big_In_Cond(1, h_indicator);
948:
949: BSC_UPDATE_LOG.Write_Line_log(h_indicator, BSC_UPDATE_LOG.OUTPUT);
950:
951: --AW_INTEGRATION: We need to truncate the cubes of the Aw indicators.
952: --I am going to add aw kpis in the array h_aw_indicators to be truncated later.
953: IF BSC_UPDATE_UTIL.Get_Kpi_Impl_Type(h_indicator) = 2 THEN

Line 1017: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);

1013: COMMIT;
1014:
1015: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_DELETION');
1016: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_purge_tables(h_i));
1017: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);
1018:
1019: BSC_APPS.Add_Value_Big_In_Cond(3, h_purge_tables(h_i));
1020: END IF;
1021: ELSE

Line 1044: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);

1040: COMMIT;
1041:
1042: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_DELETION');
1043: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_purge_tables(h_i));
1044: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);
1045:
1046: BSC_APPS.Add_Value_Big_In_Cond(3, h_purge_tables(h_i));
1047: END IF;
1048: END IF;

Line 1081: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);

1077: COMMIT;
1078:
1079: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_DELETION');
1080: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_purge_tables(h_i));
1081: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);
1082: END IF;
1083: ELSE
1084: -- We can truncate all tables no matter if it is an input table
1085: --LOCKING: Lock the table

Line 1105: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);

1101: COMMIT;
1102:
1103: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_DELETION');
1104: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_purge_tables(h_i));
1105: BSC_UPDATE_LOG.Write_Line_log(h_message, BSC_UPDATE_LOG.OUTPUT);
1106: END IF;
1107: END IF;
1108: END LOOP;
1109: