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_CALC dependencies on BSC_UPDATE_CALC

Line 1: PACKAGE BODY BSC_UPDATE_CALC AS

1: PACKAGE BODY BSC_UPDATE_CALC AS
2: /* $Header: BSCDCALB.pls 120.6 2006/03/07 13:37:07 meastmon noship $ */
3:
4:
5: /*===========================================================================+

Line 115: X_Source => 'BSC_UPDATE_CALC.Apply_Filters');

111: EXCEPTION
112: WHEN e_unexpected_error THEN
113: BSC_MESSAGE.Add(
114: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_APPLY_FILTER_FAILED'),
115: X_Source => 'BSC_UPDATE_CALC.Apply_Filters');
116: RETURN FALSE;
117:
118: WHEN OTHERS THEN
119: BSC_MESSAGE.Add(

Line 121: X_Source => 'BSC_UPDATE_CALC.Apply_Filters');

117:
118: WHEN OTHERS THEN
119: BSC_MESSAGE.Add(
120: X_Message => SQLERRM,
121: X_Source => 'BSC_UPDATE_CALC.Apply_Filters');
122: RETURN FALSE;
123: END Apply_Filters;
124:
125:

Line 394: X_Source => 'BSC_UPDATE_CALC.Calculate_Profit');

390: EXCEPTION
391: WHEN e_unexpected_error THEN
392: BSC_MESSAGE.Add(
393: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_PROFIT_CALC_FAILED'),
394: X_Source => 'BSC_UPDATE_CALC.Calculate_Profit');
395: RETURN FALSE;
396:
397: WHEN OTHERS THEN
398: BSC_MESSAGE.Add(

Line 400: X_Source => 'BSC_UPDATE_CALC.Calculate_Profit');

396:
397: WHEN OTHERS THEN
398: BSC_MESSAGE.Add(
399: X_Message => SQLERRM,
400: X_Source => 'BSC_UPDATE_CALC.Calculate_Profit');
401: RETURN FALSE;
402:
403: END Calculate_Profit;
404:

Line 764: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_Avg_Last_Year');

760: EXCEPTION
761: WHEN e_unexpected_error THEN
762: BSC_MESSAGE.Add(
763: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_PROJ_ALY_FAILED'),
764: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_Avg_Last_Year');
765: RETURN FALSE;
766:
767: WHEN OTHERS THEN
768: BSC_MESSAGE.Add(

Line 770: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_Avg_Last_Year');

766:
767: WHEN OTHERS THEN
768: BSC_MESSAGE.Add(
769: X_Message => SQLERRM,
770: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_Avg_Last_Year');
771: RETURN FALSE;
772:
773: END Calculate_Proj_Avg_Last_Year;
774:

Line 1239: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_3_Periods_Perf');

1235: EXCEPTION
1236: WHEN e_unexpected_error THEN
1237: BSC_MESSAGE.Add(
1238: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_PROJ_THREEMONTH_FAILED'),
1239: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_3_Periods_Perf');
1240: RETURN FALSE;
1241:
1242: WHEN OTHERS THEN
1243: BSC_MESSAGE.Add(

Line 1245: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_3_Periods_Perf');

1241:
1242: WHEN OTHERS THEN
1243: BSC_MESSAGE.Add(
1244: X_Message => SQLERRM,
1245: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_3_Periods_Perf');
1246: RETURN FALSE;
1247:
1248: END Calculate_Proj_3_Periods_Perf;
1249:

Line 1366: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_User_Defined');

1362: EXCEPTION
1363: WHEN e_unexpected_error THEN
1364: BSC_MESSAGE.Add(
1365: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_PROJ_UD_FAILED'),
1366: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_User_Defined');
1367: RETURN FALSE;
1368:
1369: WHEN OTHERS THEN
1370: BSC_MESSAGE.Add(

Line 1372: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_User_Defined');

1368:
1369: WHEN OTHERS THEN
1370: BSC_MESSAGE.Add(
1371: X_Message => SQLERRM,
1372: X_Source => 'BSC_UPDATE_CALC.Calculate_Proj_User_Defined');
1373: RETURN FALSE;
1374:
1375: END Calculate_Proj_User_Defined;
1376:

Line 1591: X_Source => 'BSC_UPDATE_CALC.Calculate_Projection');

1587: WHEN e_unexpected_error THEN
1588: ROLLBACK;
1589: BSC_MESSAGE.Add(
1590: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_PROJ_FAILED'),
1591: X_Source => 'BSC_UPDATE_CALC.Calculate_Projection');
1592: RETURN FALSE;
1593:
1594: WHEN OTHERS THEN
1595: ROLLBACK;

Line 1598: X_Source => 'BSC_UPDATE_CALC.Calculate_Projection');

1594: WHEN OTHERS THEN
1595: ROLLBACK;
1596: BSC_MESSAGE.Add(
1597: X_Message => SQLERRM,
1598: X_Source => 'BSC_UPDATE_CALC.Calculate_Projection');
1599: RETURN FALSE;
1600:
1601: END Calculate_Projection;
1602:

Line 1884: X_Source => 'BSC_UPDATE_CALC.Calculate_Zero_Code');

1880: WHEN e_unexpected_error THEN
1881: ROLLBACK;
1882: BSC_MESSAGE.Add(
1883: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_ZEROCODE_CALC_FAILED'),
1884: X_Source => 'BSC_UPDATE_CALC.Calculate_Zero_Code');
1885: RETURN FALSE;
1886:
1887: WHEN OTHERS THEN
1888: ROLLBACK;

Line 1891: X_Source => 'BSC_UPDATE_CALC.Calculate_Zero_Code');

1887: WHEN OTHERS THEN
1888: ROLLBACK;
1889: BSC_MESSAGE.Add(
1890: X_Message => SQLERRM,
1891: X_Source => 'BSC_UPDATE_CALC.Calculate_Zero_Code');
1892: RETURN FALSE;
1893:
1894: END Calculate_Zero_Code;
1895:

Line 1994: X_Source => 'BSC_UPDATE_CALC.Create_Proj_Temps');

1990: EXCEPTION
1991: WHEN e_unexpected_error THEN
1992: BSC_MESSAGE.Add(
1993: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_PROJ_TTABLES_FAILED'),
1994: X_Source => 'BSC_UPDATE_CALC.Create_Proj_Temps');
1995: RETURN FALSE;
1996:
1997: WHEN OTHERS THEN
1998: BSC_MESSAGE.Add(

Line 2000: X_Source => 'BSC_UPDATE_CALC.Create_Proj_Temps');

1996:
1997: WHEN OTHERS THEN
1998: BSC_MESSAGE.Add(
1999: X_Message => SQLERRM,
2000: X_Source => 'BSC_UPDATE_CALC.Create_Proj_Temps');
2001: RETURN FALSE;
2002:
2003: END Create_Proj_Temps;
2004:

Line 2234: X_Source => 'BSC_UPDATE_CALC.Init_Projection_Table');

2230: EXCEPTION
2231: WHEN OTHERS THEN
2232: BSC_MESSAGE.Add(
2233: X_Message => SQLERRM,
2234: X_Source => 'BSC_UPDATE_CALC.Init_Projection_Table');
2235: RETURN FALSE;
2236:
2237: END Init_Projection_Table;
2238:

Line 2325: X_Source => 'BSC_UPDATE_CALC.Delete_Projection');

2321: EXCEPTION
2322: WHEN OTHERS THEN
2323: BSC_MESSAGE.Add(
2324: X_Message => SQLERRM,
2325: X_Source => 'BSC_UPDATE_CALC.Delete_Projection');
2326: RETURN FALSE;
2327:
2328: END Delete_Projection;
2329:

Line 2486: X_Source => 'BSC_UPDATE_CALC.Delete_Projection_Base_Table');

2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: BSC_MESSAGE.Add(
2485: X_Message => SQLERRM,
2486: X_Source => 'BSC_UPDATE_CALC.Delete_Projection_Base_Table');
2487: RETURN FALSE;
2488:
2489: END Delete_Projection_Base_Table;
2490:

Line 2510: X_Source => 'BSC_UPDATE_CALC.Drop_Proj_Temps');

2506: EXCEPTION
2507: WHEN e_unexpected_error THEN
2508: BSC_MESSAGE.Add(
2509: X_Message => SQLERRM,
2510: X_Source => 'BSC_UPDATE_CALC.Drop_Proj_Temps');
2511: RETURN FALSE;
2512:
2513: WHEN OTHERS THEN
2514: BSC_MESSAGE.Add(

Line 2516: X_Source => 'BSC_UPDATE_CALC.Drop_Proj_Temps');

2512:
2513: WHEN OTHERS THEN
2514: BSC_MESSAGE.Add(
2515: X_Message => SQLERRM,
2516: X_Source => 'BSC_UPDATE_CALC.Drop_Proj_Temps');
2517: RETURN FALSE;
2518:
2519: END Drop_Proj_Temps;
2520:

Line 2563: X_Source => 'BSC_UPDATE_CALC.Get_Zero_Code_Calc_Method');

2559: EXCEPTION
2560: WHEN OTHERS THEN
2561: BSC_MESSAGE.Add(
2562: X_Message => SQLERRM,
2563: X_Source => 'BSC_UPDATE_CALC.Get_Zero_Code_Calc_Method');
2564: RETURN NULL;
2565:
2566: END Get_Zero_Code_Calc_Method;
2567:

Line 2696: X_Source => 'BSC_UPDATE_CALC.Merge_Data_From_Tables');

2692: EXCEPTION
2693: WHEN OTHERS THEN
2694: BSC_MESSAGE.Add(
2695: X_Message => SQLERRM,
2696: X_Source => 'BSC_UPDATE_CALC.Merge_Data_From_Tables');
2697: RETURN FALSE;
2698:
2699: END Merge_Data_From_Tables;
2700:

Line 2813: X_Source => 'BSC_UPDATE_CALC.Merge_Projection');

2809: ROLLBACK;
2810:
2811: BSC_MESSAGE.Add(
2812: X_Message => SQLERRM,
2813: X_Source => 'BSC_UPDATE_CALC.Merge_Projection');
2814: RETURN FALSE;
2815: END Merge_Projection;
2816:
2817:

Line 2928: X_Source => 'BSC_UPDATE_CALC.Refresh_EDW_Views');

2924: EXCEPTION
2925: WHEN e_unexpected_error THEN
2926: BSC_MESSAGE.Add(
2927: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_REFRESH_EDW_VIEWS_FAILED'),
2928: X_Source => 'BSC_UPDATE_CALC.Refresh_EDW_Views');
2929: RETURN FALSE;
2930:
2931: WHEN OTHERS THEN
2932: BSC_MESSAGE.Add(

Line 2934: X_Source => 'BSC_UPDATE_CALC.Refresh_EDW_Views');

2930:
2931: WHEN OTHERS THEN
2932: BSC_MESSAGE.Add(
2933: X_Message => SQLERRM,
2934: X_Source => 'BSC_UPDATE_CALC.Refresh_EDW_Views');
2935: RETURN FALSE;
2936:
2937: END Refresh_EDW_Views;
2938:

Line 3361: X_Source => 'BSC_UPDATE_CALC.Rollup_Projection');

3357: WHEN e_unexpected_error THEN
3358: ROLLBACK;
3359: BSC_MESSAGE.Add(
3360: X_Message => BSC_UPDATE_UTIL.Get_Message('BSC_PROJ_FAILED'),
3361: X_Source => 'BSC_UPDATE_CALC.Rollup_Projection');
3362: RETURN FALSE;
3363:
3364: WHEN OTHERS THEN
3365: ROLLBACK;

Line 3369: X_Source => 'BSC_UPDATE_CALC.Rollup_Projection');

3365: ROLLBACK;
3366:
3367: BSC_MESSAGE.Add(
3368: X_Message => SQLERRM,
3369: X_Source => 'BSC_UPDATE_CALC.Rollup_Projection');
3370: RETURN FALSE;
3371:
3372: END Rollup_Projection;
3373:

Line 3408: X_Source => 'BSC_UPDATE_CALC.Table_Has_Profit_Calc');

3404: EXCEPTION
3405: WHEN OTHERS THEN
3406: BSC_MESSAGE.Add(
3407: X_Message => SQLERRM,
3408: X_Source => 'BSC_UPDATE_CALC.Table_Has_Profit_Calc');
3409: RETURN NULL;
3410:
3411: END Table_Has_Profit_Calc;
3412:

Line 3466: X_Source => 'BSC_UPDATE_CALC.Table_Has_Proj_Calc');

3462: EXCEPTION
3463: WHEN OTHERS THEN
3464: BSC_MESSAGE.Add(
3465: X_Message => SQLERRM,
3466: X_Source => 'BSC_UPDATE_CALC.Table_Has_Proj_Calc');
3467: RETURN NULL;
3468:
3469: END Table_Has_Proj_Calc;
3470:

Line 3472: END BSC_UPDATE_CALC;

3468:
3469: END Table_Has_Proj_Calc;
3470:
3471:
3472: END BSC_UPDATE_CALC;