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_UPGRADES dependencies on BSC_UPGRADES

Line 1: PACKAGE BODY BSC_UPGRADES AS

1: PACKAGE BODY BSC_UPGRADES AS
2: /* $Header: BSCUPGRB.pls 120.6.12000000.2 2007/06/19 13:33:16 ashankar ship $ */
3: --- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
4: --- All rights reserved.
5: ---

Line 57: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_UPGRADES';

53: --- objets (Only those for which the underlying view will be dropped)
54: --- 18-JUN-07 ashankar Bug#6129599 Added the API synch_measures_cds_to_pmf
55: ---===========================================================================
56:
57: G_PKG_NAME CONSTANT VARCHAR2(30):='BSC_UPGRADES';
58:
59:
60: FUNCTION Validate_And_Get_Short_Name
61: (

Line 1454: x_error_msg := 'BSC_UPGRADES.Synchronize_Dim_Objects Successfully Completed';

1450:
1451: END IF;
1452: END LOOP;
1453: COMMIT;
1454: x_error_msg := 'BSC_UPGRADES.Synchronize_Dim_Objects Successfully Completed';
1455: RETURN TRUE;
1456: EXCEPTION
1457: WHEN FND_API.G_EXC_ERROR THEN
1458: IF (c_bis_dim_objs%ISOPEN) THEN

Line 1735: x_error_msg := 'BSC_UPGRADES.Synchronize_Dimensions Successfully Completed';

1731: WHERE Short_Name = cd.short_name;
1732:
1733: END LOOP;
1734: COMMIT;
1735: x_error_msg := 'BSC_UPGRADES.Synchronize_Dimensions Successfully Completed';
1736: RETURN TRUE;
1737: EXCEPTION
1738: WHEN FND_API.G_EXC_ERROR THEN
1739: IF (c_bsc_dims%ISOPEN) THEN

Line 1790: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Synchronize_Dimensions ';

1786: CLOSE dim_obj_short_name;
1787: END IF;
1788: ROLLBACK TO BscSyncDimensions;
1789: IF (x_error_msg IS NOT NULL) THEN
1790: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Synchronize_Dimensions ';
1791: ELSE
1792: x_error_msg := SQLERRM||' at BSC_UPGRADES.Synchronize_Dimensions ';
1793: END IF;
1794: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_error_msg);

Line 1792: x_error_msg := SQLERRM||' at BSC_UPGRADES.Synchronize_Dimensions ';

1788: ROLLBACK TO BscSyncDimensions;
1789: IF (x_error_msg IS NOT NULL) THEN
1790: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Synchronize_Dimensions ';
1791: ELSE
1792: x_error_msg := SQLERRM||' at BSC_UPGRADES.Synchronize_Dimensions ';
1793: END IF;
1794: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_error_msg);
1795: RETURN FALSE;
1796: WHEN OTHERS THEN

Line 1808: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Synchronize_Dimensions ';

1804: CLOSE dim_obj_short_name;
1805: END IF;
1806: ROLLBACK TO BscSyncDimensions;
1807: IF (x_error_msg IS NOT NULL) THEN
1808: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Synchronize_Dimensions ';
1809: ELSE
1810: x_error_msg := SQLERRM||' at BSC_UPGRADES.Synchronize_Dimensions ';
1811: END IF;
1812: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_error_msg);

Line 1810: x_error_msg := SQLERRM||' at BSC_UPGRADES.Synchronize_Dimensions ';

1806: ROLLBACK TO BscSyncDimensions;
1807: IF (x_error_msg IS NOT NULL) THEN
1808: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Synchronize_Dimensions ';
1809: ELSE
1810: x_error_msg := SQLERRM||' at BSC_UPGRADES.Synchronize_Dimensions ';
1811: END IF;
1812: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_error_msg);
1813: RETURN FALSE;
1814: END Synchronize_Dimensions;

Line 2818: x_error_msg := 'BSC_UPGRADES.Update_Dim_Hide_Properties Successfully Completed';

2814: WHERE SHORT_NAME = l_dim_short_names(i);
2815: END LOOP;
2816:
2817: CLOSE cr_internal_dimensions;
2818: x_error_msg := 'BSC_UPGRADES.Update_Dim_Hide_Properties Successfully Completed';
2819: RETURN TRUE;
2820: EXCEPTION
2821: WHEN OTHERS THEN
2822: IF (cr_internal_dimensions%ISOPEN) THEN

Line 2827: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Update_Dim_Hide_Properties ';

2823: CLOSE cr_internal_dimensions;
2824: END IF;
2825: ROLLBACK TO BisHideInDesignUpdate;
2826: IF (x_error_msg IS NOT NULL) THEN
2827: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Update_Dim_Hide_Properties ';
2828: ELSE
2829: x_error_msg := SQLERRM||' at BSC_UPGRADES.Update_Dim_Hide_Properties ';
2830: END IF;
2831: RETURN FALSE;

Line 2829: x_error_msg := SQLERRM||' at BSC_UPGRADES.Update_Dim_Hide_Properties ';

2825: ROLLBACK TO BisHideInDesignUpdate;
2826: IF (x_error_msg IS NOT NULL) THEN
2827: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Update_Dim_Hide_Properties ';
2828: ELSE
2829: x_error_msg := SQLERRM||' at BSC_UPGRADES.Update_Dim_Hide_Properties ';
2830: END IF;
2831: RETURN FALSE;
2832: END Update_Dim_Hide_Properties;
2833:

Line 2876: x_error_msg := 'BSC_UPGRADES.Hide_Unused_Pmf_Import_Dim Successfully Completed';

2872: WHERE SHORT_NAME = l_dim_short_names(i);
2873: END LOOP;
2874: END LOOP;
2875: CLOSE cr_pmf_import_dims;
2876: x_error_msg := 'BSC_UPGRADES.Hide_Unused_Pmf_Import_Dim Successfully Completed';
2877: RETURN TRUE;
2878: EXCEPTION
2879: WHEN OTHERS THEN
2880: IF (cr_pmf_import_dims%ISOPEN) THEN

Line 2885: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Hide_Unused_Import_Dim';

2881: CLOSE cr_pmf_import_dims;
2882: END IF;
2883: ROLLBACK TO BisUpdateImportDim;
2884: IF (x_error_msg IS NOT NULL) THEN
2885: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Hide_Unused_Import_Dim';
2886: ELSE
2887: x_error_msg := SQLERRM||' at BSC_UPGRADES.Hide_Unused_Import_Dim';
2888: END IF;
2889: RETURN FALSE;

Line 2887: x_error_msg := SQLERRM||' at BSC_UPGRADES.Hide_Unused_Import_Dim';

2883: ROLLBACK TO BisUpdateImportDim;
2884: IF (x_error_msg IS NOT NULL) THEN
2885: x_error_msg := x_error_msg||' -> BSC_UPGRADES.Hide_Unused_Import_Dim';
2886: ELSE
2887: x_error_msg := SQLERRM||' at BSC_UPGRADES.Hide_Unused_Import_Dim';
2888: END IF;
2889: RETURN FALSE;
2890: END Hide_Unused_Import_Dim;
2891:

Line 2940: end BSC_UPGRADES;

2936: x_msg_data := SQLERRM||' at BSC_BIS_DIM_OBJ_PUB.Drop_Update_Dim_Obj_Views ';
2937: END IF;
2938: END Drop_Update_Dim_Obj_Views;
2939:
2940: end BSC_UPGRADES;