85: RETURN h_period_summary_table;
86:
87: EXCEPTION
88: WHEN e_unexpected_error THEN
89: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_SUMTBLE_PERIOD_CALC_FAILED'),
90: x_source => 'BSC_UPDATE_SUM.Calculate_Period_Summary_Table');
91: RETURN NULL;
92:
93: WHEN OTHERS THEN
90: x_source => 'BSC_UPDATE_SUM.Calculate_Period_Summary_Table');
91: RETURN NULL;
92:
93: WHEN OTHERS THEN
94: BSC_MESSAGE.Add(x_message => SQLERRM,
95: x_source => 'BSC_UPDATE_SUM.Calculate_Period_Summary_Table');
96: RETURN NULL;
97:
98: END Calculate_Period_Summary_Table;
456:
457: EXCEPTION
458: WHEN e_unexpected_error THEN
459: ROLLBACK;
460: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALC_FAILED'),
461: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table');
462: RETURN FALSE;
463:
464: WHEN OTHERS THEN
462: RETURN FALSE;
463:
464: WHEN OTHERS THEN
465: ROLLBACK;
466: BSC_MESSAGE.Add(x_message => SQLERRM,
467: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table');
468: RETURN FALSE;
469:
470: END Calculate_Sum_Table;
1062:
1063: EXCEPTION
1064: WHEN e_unexpected_error THEN
1065: ROLLBACK;
1066: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALC_FAILED'),
1067: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');
1068: RETURN FALSE;
1069:
1070: WHEN e_error_refresh THEN
1068: RETURN FALSE;
1069:
1070: WHEN e_error_refresh THEN
1071: ROLLBACK;
1072: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||h_mv_name||' '||h_error_refresh,
1073: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');
1074: RETURN FALSE;
1075:
1076: WHEN e_error_refresh_zero THEN
1074: RETURN FALSE;
1075:
1076: WHEN e_error_refresh_zero THEN
1077: ROLLBACK;
1078: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||h_mv_name||' '||h_error_refresh,
1079: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');
1080: RETURN FALSE;
1081:
1082: WHEN OTHERS THEN
1080: RETURN FALSE;
1081:
1082: WHEN OTHERS THEN
1083: ROLLBACK;
1084: BSC_MESSAGE.Add(x_message => SQLERRM,
1085: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');
1086: RETURN FALSE;
1087:
1088: END Calculate_Sum_Table_MV;
1185:
1186: EXCEPTION
1187: WHEN e_unexpected_error THEN
1188: ROLLBACK;
1189: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALC_FAILED'),
1190: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_AW');
1191: RETURN FALSE;
1192:
1193: WHEN OTHERS THEN
1191: RETURN FALSE;
1192:
1193: WHEN OTHERS THEN
1194: ROLLBACK;
1195: BSC_MESSAGE.Add(x_message => SQLERRM,
1196: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_AW');
1197: RETURN FALSE;
1198:
1199: END Calculate_Sum_Table_AW;
2115: RETURN TRUE;
2116: EXCEPTION
2117: WHEN e_unexpected_error THEN
2118: ROLLBACK;
2119: BSC_MESSAGE.Add(x_message => BSC_UPDATE_UTIL.Get_Message('BSC_SUMTABLE_CALC_FAILED'),
2120: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_Total');
2121: RETURN FALSE;
2122:
2123: WHEN OTHERS THEN
2121: RETURN FALSE;
2122:
2123: WHEN OTHERS THEN
2124: ROLLBACK;
2125: BSC_MESSAGE.Add(x_message => SQLERRM,
2126: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_Total');
2127: RETURN FALSE;
2128:
2129: END Calculate_Sum_Table_Total;
2209: RETURN h_ret;
2210:
2211: EXCEPTION
2212: WHEN OTHERS THEN
2213: BSC_MESSAGE.Add(x_message => SQLERRM,
2214: x_source => 'BSC_UPDATE_SUM.Get_Minimun_Origin_Period');
2215: RETURN NULL;
2216:
2217: END Get_Minimun_Origin_Period;
2256: RETURN TRUE;
2257:
2258: EXCEPTION
2259: WHEN OTHERS THEN
2260: BSC_MESSAGE.Add(x_message => SQLERRM,
2261: x_source => 'BSC_UPDATE_SUM.Get_Origin_Tables');
2262: RETURN FALSE;
2263:
2264: END Get_Origin_Tables;