118: IF (l_objective_kpis.disable_color IS NULL OR l_objective_kpis.disable_color <> 'T') THEN
119: IF(l_ag_report = FALSE OR (l_ag_report = TRUE and l_objective_kpis.source <> 'CDS')) THEN
120: l_message := BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_KPI_START');
121: l_message := BSC_UPDATE_UTIL.Replace_Token(l_message, 'KPI_MEASURE_ID', TO_CHAR(l_objective_kpis.kpi_measure_id));
122: BSC_UPDATE_LOG.Write_Line_log(l_message, BSC_UPDATE_LOG.OUTPUT);
123:
124: -- color per each combination of dimension of different families
125: -- in the tab list
126:
166: END IF;
167:
168: l_message := BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_KPI_COMPLETE');
169: l_message := BSC_UPDATE_UTIL.Replace_Token(l_message, 'KPI_MEASURE_ID', TO_CHAR(l_objective_kpis.kpi_measure_id));
170: BSC_UPDATE_LOG.Write_Line_log(l_message, BSC_UPDATE_LOG.OUTPUT);
171:
172: COMMIT;
173:
174: ELSE
173:
174: ELSE
175: l_message := BSC_UPDATE_UTIL.Get_Message('BSC_COLOR_KPI_SKIP');
176: l_message := BSC_UPDATE_UTIL.Replace_Token(l_message, 'KPI_MEASURE_ID', TO_CHAR(l_objective_kpis.kpi_measure_id));
177: BSC_UPDATE_LOG.Write_Line_log(l_message, BSC_UPDATE_LOG.OUTPUT);
178: END IF;
179: END IF;
180: END LOOP;
181:
959: CLOSE c_table_columns;
960:
961: FOR h_i IN 1..h_aw_limit_tbl.LAST LOOP
962: h_aw_limit_rec := h_aw_limit_tbl(h_i);
963: BSC_UPDATE_LOG.Write_Line_log(h_aw_limit_rec.parameter_name||' '||
964: h_aw_limit_rec.parameter_value||' '||
965: h_aw_limit_rec.dimension, BSC_UPDATE_LOG.OUTPUT);
966: END LOOP;
967: -- Now we are ready to limit the dimensions of the indicator
961: FOR h_i IN 1..h_aw_limit_tbl.LAST LOOP
962: h_aw_limit_rec := h_aw_limit_tbl(h_i);
963: BSC_UPDATE_LOG.Write_Line_log(h_aw_limit_rec.parameter_name||' '||
964: h_aw_limit_rec.parameter_value||' '||
965: h_aw_limit_rec.dimension, BSC_UPDATE_LOG.OUTPUT);
966: END LOOP;
967: -- Now we are ready to limit the dimensions of the indicator
968: bsc_aw_read.limit_dimensions(x_indic_code, x_dim_set_id, h_aw_limit_tbl);
969: END IF;