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_SUM dependencies on BSC_UPDATE_SUM

Line 1: PACKAGE BODY BSC_UPDATE_SUM AS

1: PACKAGE BODY BSC_UPDATE_SUM AS
2: /* $Header: BSCDSUMB.pls 120.5 2006/04/03 14:08:22 meastmon noship $ */
3:
4:
5: /*===========================================================================+

Line 90: x_source => 'BSC_UPDATE_SUM.Calculate_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
94: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 95: 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;
99:

Line 461: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table');

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
465: ROLLBACK;

Line 467: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table');

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;
471:

Line 1067: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');

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
1071: ROLLBACK;

Line 1073: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');

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
1077: ROLLBACK;

Line 1078: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||h_mv_name||' '||h_error_refresh,

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

Line 1079: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');

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
1083: ROLLBACK;

Line 1085: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_MV');

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;
1089:

Line 1190: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_AW');

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
1194: ROLLBACK;

Line 1196: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_AW');

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;
1200:

Line 2120: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_Total');

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
2124: ROLLBACK;

Line 2126: x_source => 'BSC_UPDATE_SUM.Calculate_Sum_Table_Total');

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;
2130:

Line 2214: x_source => 'BSC_UPDATE_SUM.Get_Minimun_Origin_Period');

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;
2218:

Line 2261: x_source => 'BSC_UPDATE_SUM.Get_Origin_Tables');

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;
2265:

Line 2358: END BSC_UPDATE_SUM;

2354: commit; -- all autonomous transaction needs to commit
2355: RETURN h_b;
2356: END Refresh_Zero_MVs_AT;
2357:
2358: END BSC_UPDATE_SUM;