[Home] [Help]
1715: So we have to check for the validity of the List Button while creating a new Dimesnion set.
1716: This API will internally take care of Shared indiactors also.So don't need to call for
1717: Shared indiactors.
1718: /************************************************************/
1719: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
1720: (
1721: p_Kpi_Id => p_kpi_id
1722: , p_Dim_Level_Id => NULL
1723: , x_return_status => x_return_status
1724: , x_msg_count => x_msg_count
1725: , x_msg_data => x_msg_data
1726: );
1727: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1728: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set procedure Failed:at BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button');
1729: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1730: END IF;
1731:
1732: /********************************************************
3053: So when a dimension set is being updated it has to be validate that
3054: it contains all the common dimension objects.
3055: The validation is done for shared kpis also internally.
3056: /************************************************************/
3057: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
3058: (
3059: p_Kpi_Id => p_kpi_id
3060: , p_Dim_Level_Id => NULL
3061: , x_return_status => x_return_status
3062: , x_msg_count => x_msg_count
3063: , x_msg_data => x_msg_data
3064: );
3065: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3066: --dbms_output.PUT_LINE('BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button Failed: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set');
3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;
3069:
3070: IF (p_commit = FND_API.G_TRUE) THEN
3358: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Unassign_Dims_From_Dim_Set Failed: at BSC_DIMENSION_SETS_PUB.Create_Default_Kpi_Dim_Object');
3359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3360: END IF;
3361: IF (p_dim_short_names IS NOT NULL) THEN
3362: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
3363: (
3364: p_Kpi_Id => p_kpi_id
3365: , p_Dim_Level_Id => NULL
3366: , x_return_status => x_return_status
4672: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
4673: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4674: END LOOP;
4675:
4676: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
4677: (
4678: p_Kpi_Id => p_kpi_id
4679: , p_Dim_Level_Id => NULL
4680: , x_return_status => x_return_status
4681: , x_msg_count => x_msg_count
4682: , x_msg_data => x_msg_data
4683: );
4684: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4685: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed Failed: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button');
4686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4687: END IF;
4688: ELSE
4689: --dbms_output.PUT_LINE('ELSE');
5511: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Set');
5512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5513: END IF;
5514: -- Need to call procedure for list button logic.
5515: BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels
5516: ( p_commit => FND_API.G_FALSE
5517: , p_Tab_Id => l_tab_id
5518: , x_return_status => x_return_status
5519: , x_msg_count => x_msg_count
5519: , x_msg_count => x_msg_count
5520: , x_msg_data => x_msg_data
5521: );
5522: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5523: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels');
5524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5525: END IF;
5526: END IF;
5527: END IF;
5665: FROM BSC_TAB_INDICATORS
5666: WHERE indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5667: END IF;
5668: -- Need to call procedure for list button logic.
5669: BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels
5670: ( p_commit => FND_API.G_FALSE
5671: , p_Tab_Id => l_tab_id
5672: , x_return_status => x_return_status
5673: , x_msg_count => x_msg_count
5673: , x_msg_count => x_msg_count
5674: , x_msg_data => x_msg_data
5675: );
5676: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5677: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Analysis_Options Failed: at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels');
5678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5679: END IF;
5680: END IF;
5681:
5959: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5960: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
5961: END LOOP;
5962:
5963: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
5964: (
5965: p_Kpi_Id => p_kpi_id
5966: , p_Dim_Level_Id => NULL
5967: , x_return_status => x_return_status
5968: , x_msg_count => x_msg_count
5969: , x_msg_data => x_msg_data
5970: );
5971: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5972: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_Kpi Failed:at BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button');
5973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5974: END IF;
5975: END IF;
5976: END IF;
7698: END IF;
7699: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_kpi_id);
7700: END LOOP;
7701:
7702: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
7703: (
7704: p_Kpi_Id => p_kpi_id
7705: , p_Dim_Level_Id => NULL
7706: , x_return_status => x_return_status
7707: , x_msg_count => x_msg_count
7708: , x_msg_data => x_msg_data
7709: );
7710: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7711: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_KPI_Multi_Groups_Opts procedure Failed:at BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button');
7712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7713: END IF;
7714:
7715: -- Added for Start-to-End KPI Enhancement to maintain SHORT_NAME