1: PACKAGE BODY BSC_OBJ_ANALYSIS_OPTIONS_PUB AS
2: /* $Header: BSCPOAOB.pls 120.2.12000000.2 2007/07/27 09:48:46 akoduri noship $ */
3:
4:
5: /************************************************************************************
140: WHEN OTHERS THEN
141: ROLLBACK TO Check_UserLevel_Values_PVT;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF (x_msg_data IS NOT NULL) THEN
144: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_UserLevel_Values ';
145: ELSE
146: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_UserLevel_Values ';
147: END IF;
148: END Check_UserLevel_Values;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF (x_msg_data IS NOT NULL) THEN
144: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_UserLevel_Values ';
145: ELSE
146: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_UserLevel_Values ';
147: END IF;
148: END Check_UserLevel_Values;
149:
150: /************************************************************************************
200: WHEN OTHERS THEN
201: ROLLBACK TO Update_Change_DimSet_PVT;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: IF (x_msg_data IS NOT NULL) THEN
204: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Change_DimSet ';
205: ELSE
206: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Change_DimSet ';
207: END IF;
208: END Update_Change_DimSet;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: IF (x_msg_data IS NOT NULL) THEN
204: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Change_DimSet ';
205: ELSE
206: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Change_DimSet ';
207: END IF;
208: END Update_Change_DimSet;
209:
210:
319: WHEN OTHERS THEN
320: ROLLBACK TO Update_Default_Flag_Val_PVT;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: IF (x_msg_data IS NOT NULL) THEN
323: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Default_Flag_Val ';
324: ELSE
325: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Default_Flag_Val ';
326: END IF;
327: END Update_Default_Flag_Value;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: IF (x_msg_data IS NOT NULL) THEN
323: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Default_Flag_Val ';
324: ELSE
325: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Default_Flag_Val ';
326: END IF;
327: END Update_Default_Flag_Value;
328:
329:
421: WHEN OTHERS THEN
422: ROLLBACK TO Check_YTD_Apply_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF (x_msg_data IS NOT NULL) THEN
425: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Val_If_YTD_Apply ';
426: ELSE
427: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Val_If_YTD_Apply ';
428: END IF;
429: END Check_YTD_Apply;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF (x_msg_data IS NOT NULL) THEN
425: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Val_If_YTD_Apply ';
426: ELSE
427: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Val_If_YTD_Apply ';
428: END IF;
429: END Check_YTD_Apply;
430:
431:
649: WHEN OTHERS THEN
650: ROLLBACK TO Check_Default_Props_PVT;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: IF (x_msg_data IS NOT NULL) THEN
653: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_Default_Props ';
654: ELSE
655: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_Default_Props ';
656: END IF;
657: END Check_Default_Props;
651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
652: IF (x_msg_data IS NOT NULL) THEN
653: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_Default_Props ';
654: ELSE
655: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_Default_Props ';
656: END IF;
657: END Check_Default_Props;
658:
659: /************************************************************************************
917: WHEN OTHERS THEN
918: ROLLBACK TO Update_Analayis_Option_PUB;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: IF (x_msg_data IS NOT NULL) THEN
921: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_Strucural_Flag_Change ';
922: ELSE
923: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_Strucural_Flag_Change ';
924: END IF;
925: END Check_Strucural_Flag_Change;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: IF (x_msg_data IS NOT NULL) THEN
921: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_Strucural_Flag_Change ';
922: ELSE
923: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Check_Strucural_Flag_Change ';
924: END IF;
925: END Check_Strucural_Flag_Change;
926:
927: /************************************************************************************
1370: WHEN OTHERS THEN
1371: ROLLBACK TO Update_Analayis_Option_PUB;
1372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1373: IF (x_msg_data IS NOT NULL) THEN
1374: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Analysis_Option_UI ';
1375: ELSE
1376: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Analysis_Option_UI ';
1377: END IF;
1378: END Update_Analysis_Option_UI;
1372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1373: IF (x_msg_data IS NOT NULL) THEN
1374: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Analysis_Option_UI ';
1375: ELSE
1376: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Analysis_Option_UI ';
1377: END IF;
1378: END Update_Analysis_Option_UI;
1379:
1380: /************************************************************************************
1525: WHEN OTHERS THEN
1526: ROLLBACK TO Delete_Mind_Options_PVT;
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: IF (x_msg_data IS NOT NULL) THEN
1529: x_msg_data := x_msg_data||' ->BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Mind_Options ';
1530: ELSE
1531: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Mind_Options ';
1532: END IF;
1533: END Delete_Mind_Options;
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: IF (x_msg_data IS NOT NULL) THEN
1529: x_msg_data := x_msg_data||' ->BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Mind_Options ';
1530: ELSE
1531: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Mind_Options ';
1532: END IF;
1533: END Delete_Mind_Options;
1534:
1535: /************************************************************************************
1624: WHEN OTHERS THEN
1625: ROLLBACK TO Delete_Mind_Data_PVT;
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1627: IF (x_msg_data IS NOT NULL) THEN
1628: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Mind_Data ';
1629: ELSE
1630: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Mind_Data ';
1631: END IF;
1632: END Delete_Mind_Data;
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1627: IF (x_msg_data IS NOT NULL) THEN
1628: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Mind_Data ';
1629: ELSE
1630: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Mind_Data ';
1631: END IF;
1632: END Delete_Mind_Data;
1633:
1634: /************************************************************************************
1767: WHEN OTHERS THEN
1768: ROLLBACK TO Renumerate_Options_PVT;
1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1770: IF (x_msg_data IS NOT NULL) THEN
1771: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Renumerate_Options ';
1772: ELSE
1773: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Renumerate_Options ';
1774: END IF;
1775: END Renumerate_Options;
1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1770: IF (x_msg_data IS NOT NULL) THEN
1771: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Renumerate_Options ';
1772: ELSE
1773: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Renumerate_Options ';
1774: END IF;
1775: END Renumerate_Options;
1776:
1777: /************************************************************************************
1843: WHEN OTHERS THEN
1844: ROLLBACK TO Update_Ana_Opt_Count_PVT;
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846: IF (x_msg_data IS NOT NULL) THEN
1847: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Analysis_Opt_Count ';
1848: ELSE
1849: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Analysis_Opt_Count ';
1850: END IF;
1851: END Update_Analysis_Opt_Count;
1845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1846: IF (x_msg_data IS NOT NULL) THEN
1847: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Analysis_Opt_Count ';
1848: ELSE
1849: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Update_Analysis_Opt_Count ';
1850: END IF;
1851: END Update_Analysis_Opt_Count;
1852:
1853: /************************************************************************************
2067: WHEN OTHERS THEN
2068: ROLLBACK TO BscObjDeleteAnaOptWrap;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070: IF (x_msg_data IS NOT NULL) THEN
2071: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Analysis_Option_Wrap ';
2072: ELSE
2073: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Analysis_Option_Wrap ';
2074: END IF;
2075: END Delete_Analysis_Option_Wrap;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2070: IF (x_msg_data IS NOT NULL) THEN
2071: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Analysis_Option_Wrap ';
2072: ELSE
2073: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Analysis_Option_Wrap ';
2074: END IF;
2075: END Delete_Analysis_Option_Wrap;
2076:
2077: /************************************************************************************
2165: WHEN OTHERS THEN
2166: ROLLBACK TO Reset_Group_Defaults_PVT;
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2168: IF (x_msg_data IS NOT NULL) THEN
2169: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Reset_Group_Defaults ';
2170: ELSE
2171: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Reset_Group_Defaults ';
2172: END IF;
2173: END Reset_Group_Defaults;
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2168: IF (x_msg_data IS NOT NULL) THEN
2169: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Reset_Group_Defaults ';
2170: ELSE
2171: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Reset_Group_Defaults ';
2172: END IF;
2173: END Reset_Group_Defaults;
2174:
2175: /************************************************************************************
2283: WHEN OTHERS THEN
2284: ROLLBACK TO Remove_Empty_Groups_PVT;
2285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2286: IF (x_msg_data IS NOT NULL) THEN
2287: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Remove_Empty_Groups ';
2288: ELSE
2289: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Remove_Empty_Groups ';
2290: END IF;
2291: END Remove_Empty_Groups;
2285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2286: IF (x_msg_data IS NOT NULL) THEN
2287: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Remove_Empty_Groups ';
2288: ELSE
2289: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Remove_Empty_Groups ';
2290: END IF;
2291: END Remove_Empty_Groups;
2292:
2293: /************************************************************************************
2664: WHEN OTHERS THEN
2665: ROLLBACK TO Delete_Analysis_Opt_UI_PVT;
2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2667: IF (x_msg_data IS NOT NULL) THEN
2668: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Analysis_Option_UI ';
2669: ELSE
2670: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Analysis_Option_UI ';
2671: END IF;
2672:
2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2667: IF (x_msg_data IS NOT NULL) THEN
2668: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Analysis_Option_UI ';
2669: ELSE
2670: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Delete_Analysis_Option_UI ';
2671: END IF;
2672:
2673: END Delete_Analysis_Option_UI;
2674:
2725: WHEN OTHERS THEN
2726: ROLLBACK TO Create_Analysis_Group_PVT;
2727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2728: IF (x_msg_data IS NOT NULL) THEN
2729: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Create_Analysis_Group ';
2730: ELSE
2731: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Create_Analysis_Group ';
2732: END IF;
2733: END Create_Analysis_Group;
2727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2728: IF (x_msg_data IS NOT NULL) THEN
2729: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Create_Analysis_Group ';
2730: ELSE
2731: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Create_Analysis_Group ';
2732: END IF;
2733: END Create_Analysis_Group;
2734:
2735: /************************************************************************************
2967: WHEN OTHERS THEN
2968: ROLLBACK TO Generate_Ana_Meas_Combs_PVT;
2969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2970: IF (x_msg_data IS NOT NULL) THEN
2971: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Generate_Analysis_Meas_Combs ';
2972: ELSE
2973: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Generate_Analysis_Meas_Combs ';
2974: END IF;
2975: END Generate_Analysis_Meas_Combs;
2969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2970: IF (x_msg_data IS NOT NULL) THEN
2971: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Generate_Analysis_Meas_Combs ';
2972: ELSE
2973: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Generate_Analysis_Meas_Combs ';
2974: END IF;
2975: END Generate_Analysis_Meas_Combs;
2976:
2977: /************************************************************************************
3098: WHEN OTHERS THEN
3099: ROLLBACK TO Populate_Ana_Meas_Combs_PVT;
3100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3101: IF (x_msg_data IS NOT NULL) THEN
3102: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Populate_Analysis_Meas_Combs ';
3103: ELSE
3104: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Populate_Analysis_Meas_Combs ';
3105: END IF;
3106: END Populate_Analysis_Meas_Combs;
3100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3101: IF (x_msg_data IS NOT NULL) THEN
3102: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Populate_Analysis_Meas_Combs ';
3103: ELSE
3104: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Populate_Analysis_Meas_Combs ';
3105: END IF;
3106: END Populate_Analysis_Meas_Combs;
3107:
3108: /************************************************************************************
3405: WHEN OTHERS THEN
3406: ROLLBACK TO Create_Analayis_OptionObjPUB;
3407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3408: IF (x_msg_data IS NOT NULL) THEN
3409: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Create_Analayis_Option ';
3410: ELSE
3411: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Create_Analayis_Option ';
3412: END IF;
3413: END Create_Analysis_Option_UI;
3407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3408: IF (x_msg_data IS NOT NULL) THEN
3409: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Create_Analayis_Option ';
3410: ELSE
3411: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Create_Analayis_Option ';
3412: END IF;
3413: END Create_Analysis_Option_UI;
3414:
3415: /************************************************************************************
3583: x_return_status := FND_API.G_RET_STS_ERROR;
3584: WHEN OTHERS THEN
3585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3586: IF (x_msg_data IS NOT NULL) THEN
3587: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Validate_Delete_Analysis_Option ';
3588: ELSE
3589: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Validate_Delete_Analysis_Option ';
3590: END IF;
3591: END Val_Delete_Analysis_Option;
3585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3586: IF (x_msg_data IS NOT NULL) THEN
3587: x_msg_data := x_msg_data||' -> BSC_OBJ_ANALYSIS_OPTIONS_PUB.Validate_Delete_Analysis_Option ';
3588: ELSE
3589: x_msg_data := SQLERRM||' at BSC_OBJ_ANALYSIS_OPTIONS_PUB.Validate_Delete_Analysis_Option ';
3590: END IF;
3591: END Val_Delete_Analysis_Option;
3592:
3593: /************************************************************************************
4296: WHEN OTHERS THEN
4297: RETURN NULL;
4298: END Get_Kpi_Property;
4299:
4300: END BSC_OBJ_ANALYSIS_OPTIONS_PUB;