122: RETURN TRUE;
123:
124: EXCEPTION
125: WHEN e_unexpected_error THEN
126: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_ADD_REL_TABLES_FAILED'),
127: x_source => 'BSC_UPDATE_INC.Add_Related_Tables');
128: RETURN FALSE;
129:
130: WHEN OTHERS THEN
127: x_source => 'BSC_UPDATE_INC.Add_Related_Tables');
128: RETURN FALSE;
129:
130: WHEN OTHERS THEN
131: BSC_MESSAGE.Add(x_message => SQLERRM,
132: x_source => 'BSC_UPDATE_INC.Add_Related_Tables');
133: RETURN FALSE;
134:
135: END Add_Related_Tables;
377: RETURN TRUE;
378:
379: EXCEPTION
380: WHEN e_unexpected_error THEN
381: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_INCR_CHANGE_REV_FAILED'),
382: x_source => 'BSC_UPDATE_INC.Do_Incremental');
383: RETURN FALSE;
384:
385: --LOCKING
383: RETURN FALSE;
384:
385: --LOCKING
386: WHEN e_could_not_get_lock THEN
387: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
388: x_source => 'BSC_UPDATE_INC.Do_Incremental');
389: RETURN FALSE;
390:
391: WHEN e_error_load_rpt_cal THEN
388: x_source => 'BSC_UPDATE_INC.Do_Incremental');
389: RETURN FALSE;
390:
391: WHEN e_error_load_rpt_cal THEN
392: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,
393: x_source => 'BSC_UPDATE_INC.Do_Incremental');
394: RETURN FALSE;
395:
396: WHEN OTHERS THEN
393: x_source => 'BSC_UPDATE_INC.Do_Incremental');
394: RETURN FALSE;
395:
396: WHEN OTHERS THEN
397: BSC_MESSAGE.Add(x_message => SQLERRM,
398: x_source => 'BSC_UPDATE_INC.Do_Incremental');
399: RETURN FALSE;
400:
401: END Do_Incremental;
447: RETURN TRUE;
448:
449: EXCEPTION
450: WHEN OTHERS THEN
451: BSC_MESSAGE.Add(x_message => SQLERRM,
452: x_source => 'BSC_UPDATE_INC.Get_Changed_Calendars');
453: RETURN FALSE;
454:
455: END Get_Changed_Calendars;
512:
513: RETURN TRUE;
514: EXCEPTION
515: WHEN OTHERS THEN
516: BSC_MESSAGE.Add(x_message => SQLERRM,
517: x_source => 'BSC_UPDATE_INC.Get_Color_Indics_Incremental');
518: RETURN FALSE;
519:
520: END Get_Color_Indics_Incremental;
583: RETURN TRUE;
584:
585: EXCEPTION
586: WHEN e_unexpected_error THEN
587: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_ITABLES_FAILED'),
588: x_source => 'BSC_UPDATE_INC.Get_Input_Tables');
589: RETURN FALSE;
590:
591: WHEN OTHERS THEN
588: x_source => 'BSC_UPDATE_INC.Get_Input_Tables');
589: RETURN FALSE;
590:
591: WHEN OTHERS THEN
592: BSC_MESSAGE.Add(x_message => SQLERRM,
593: x_source => 'BSC_UPDATE_INC.Get_Input_Tables');
594: RETURN FALSE;
595: END Get_Input_Tables;
596:
658:
659: RETURN TRUE;
660: EXCEPTION
661: WHEN e_unexpected_error THEN
662: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_RETR_INCR_ITABLES_FAILED'),
663: x_source => 'BSC_UPDATE_INC.Get_Input_Tables_Incremental');
664: RETURN FALSE;
665:
666: WHEN OTHERS THEN
663: x_source => 'BSC_UPDATE_INC.Get_Input_Tables_Incremental');
664: RETURN FALSE;
665:
666: WHEN OTHERS THEN
667: BSC_MESSAGE.Add(x_message => SQLERRM,
668: x_source => 'BSC_UPDATE_INC.Get_Input_Tables_Incremental');
669: RETURN FALSE;
670:
671: END Get_Input_Tables_Incremental;
712: RETURN TRUE;
713:
714: EXCEPTION
715: WHEN e_unexpected_error THEN
716: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),
717: x_source => 'BSC_UPDATE_INC.Purge_Data_All_Indicators');
718: RETURN FALSE;
719:
720: WHEN OTHERS THEN
717: x_source => 'BSC_UPDATE_INC.Purge_Data_All_Indicators');
718: RETURN FALSE;
719:
720: WHEN OTHERS THEN
721: BSC_MESSAGE.Add(x_message => SQLERRM,
722: x_source => 'BSC_UPDATE_INC.Purge_Data_All_Indicators');
723: RETURN FALSE;
724:
725: END Purge_Data_All_Indicators;
773:
774: EXCEPTION
775: --LOCKING
776: WHEN e_could_not_get_lock THEN
777: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
778: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');
779: RETURN FALSE;
780:
781: WHEN e_unexpected_error THEN
778: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');
779: RETURN FALSE;
780:
781: WHEN e_unexpected_error THEN
782: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),
783: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');
784: RETURN FALSE;
785:
786: WHEN OTHERS THEN
783: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');
784: RETURN FALSE;
785:
786: WHEN OTHERS THEN
787: BSC_MESSAGE.Add(x_message => SQLERRM,
788: x_source => 'BSC_UPDATE_INC.Purge_Data_Indicators_Calendar');
789: RETURN FALSE;
790:
791: END Purge_Data_Indicators_Calendar;
802: Begin
803: return Purge_Indicators_Data(x_purge_indicators,x_num_purge_indicators,'N');
804: EXCEPTION
805: WHEN e_unexpected_error THEN
806: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),
807: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
808: RETURN FALSE;
809:
810: WHEN OTHERS THEN
807: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
808: RETURN FALSE;
809:
810: WHEN OTHERS THEN
811: BSC_MESSAGE.Add(x_message => SQLERRM,
812: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
813: RETURN FALSE;
814:
815: END Purge_Indicators_Data;
1319:
1320: EXCEPTION
1321: --LOCKING
1322: WHEN e_could_not_get_lock THEN
1323: BSC_MESSAGE.Add(x_message => 'Loader could not get the required locks to continue.',
1324: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
1325: RETURN FALSE;
1326:
1327: WHEN e_unexpected_error THEN
1324: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
1325: RETURN FALSE;
1326:
1327: WHEN e_unexpected_error THEN
1328: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_PURGE_KPIS_FAILED'),
1329: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
1330: RETURN FALSE;
1331:
1332: WHEN OTHERS THEN
1329: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
1330: RETURN FALSE;
1331:
1332: WHEN OTHERS THEN
1333: BSC_MESSAGE.Add(x_message => SQLERRM,
1334: x_source => 'BSC_UPDATE_INC.Purge_Indicators_Data');
1335: RETURN FALSE;
1336:
1337: END Purge_Indicators_Data;
1396:
1397: RETURN TRUE;
1398: EXCEPTION
1399: WHEN OTHERS THEN
1400: BSC_MESSAGE.Add(x_message => SQLERRM,
1401: x_source => 'BSC_UPDATE_INC.Reset_Flag_Indicators');
1402: RETURN FALSE;
1403: END Reset_Flag_Indicators;
1404: