162: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then
163: p_error_message:=BSC_IM_UTILS.g_status_message;
164: return false;
165: end if;
166: if BSC_MV_ADAPTER.create_mv_kpi(p_kpi,'BSC',g_options,g_number_options)=false then
167: p_error_message:=BSC_IM_UTILS.g_status_message;
168: return false;
169: end if;
170: return true;
194: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then
195: p_error_message:=BSC_IM_UTILS.g_status_message;
196: return false;
197: end if;
198: if BSC_MV_ADAPTER.drop_mv_kpi(p_kpi,'BSC',g_options,g_number_options)=false then
199: p_error_message:=BSC_MV_ADAPTER.g_status_message;
200: end if;
201: return true;
202: Exception when others then
195: p_error_message:=BSC_IM_UTILS.g_status_message;
196: return false;
197: end if;
198: if BSC_MV_ADAPTER.drop_mv_kpi(p_kpi,'BSC',g_options,g_number_options)=false then
199: p_error_message:=BSC_MV_ADAPTER.g_status_message;
200: end if;
201: return true;
202: Exception when others then
203: BSC_IM_UTILS.g_status_message:=sqlerrm;
214: if BSC_IM_UTILS.parse_values(p_option_string,',',g_options,g_number_options)=false then
215: p_error_message:=BSC_IM_UTILS.g_status_message;
216: return false;
217: end if;
218: if BSC_MV_ADAPTER.drop_mv(p_mv,g_options,g_number_options)=false then
219: p_error_message:=BSC_MV_ADAPTER.g_status_message;
220: end if;
221: return true;
222: Exception when others then
215: p_error_message:=BSC_IM_UTILS.g_status_message;
216: return false;
217: end if;
218: if BSC_MV_ADAPTER.drop_mv(p_mv,g_options,g_number_options)=false then
219: p_error_message:=BSC_MV_ADAPTER.g_status_message;
220: end if;
221: return true;
222: Exception when others then
223: BSC_IM_UTILS.g_status_message:=sqlerrm;
251: if BSC_BSC_ADAPTER.load_metadata_for_indicators(p_kpi,g_options,g_number_options)=false then
252: p_error_message:=BSC_IM_UTILS.g_status_message;
253: return false;
254: end if;
255: if BSC_MV_ADAPTER.refresh_mv_kpi(p_kpi,'BSC',g_options,g_number_options)=false then
256: p_error_message:=BSC_MV_ADAPTER.g_status_message;
257: return false;
258: end if;
259: return true;
252: p_error_message:=BSC_IM_UTILS.g_status_message;
253: return false;
254: end if;
255: if BSC_MV_ADAPTER.refresh_mv_kpi(p_kpi,'BSC',g_options,g_number_options)=false then
256: p_error_message:=BSC_MV_ADAPTER.g_status_message;
257: return false;
258: end if;
259: return true;
260: Exception when others then
299: end if;
300: end if;
301: */
302: BSC_BSC_ADAPTER.create_int_md_fk(p_mv);
303: if BSC_MV_ADAPTER.refresh_mv(p_mv,p_kpi,g_options,g_number_options)=false then
304: p_error_message:=BSC_MV_ADAPTER.g_status_message;
305: return false;
306: end if;
307: return true;
300: end if;
301: */
302: BSC_BSC_ADAPTER.create_int_md_fk(p_mv);
303: if BSC_MV_ADAPTER.refresh_mv(p_mv,p_kpi,g_options,g_number_options)=false then
304: p_error_message:=BSC_MV_ADAPTER.g_status_message;
305: return false;
306: end if;
307: return true;
308: Exception when others then
457: return false;
458: end if;
459: BSC_BSC_ADAPTER.set_globals(g_debug);
460: BSC_IM_INT_MD.set_globals(g_debug);
461: BSC_MV_ADAPTER.set_globals(g_debug);
462: return true;
463: Exception when others then
464: BSC_IM_UTILS.g_status_message:=sqlerrm;
465: write_to_log_file_n('Error in init_all '||sqlerrm);