DBA Data[Home] [Help]

APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_BIS_DIMENSION_PUB

Line 1174: AND A.Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim

1170: , BSC_SYS_DIM_LEVELS_BY_GROUP B
1171: , BSC_SYS_DIM_LEVELS_B C
1172: WHERE A.Dim_Group_ID = B.Dim_Group_ID
1173: AND C.Dim_Level_ID = B.Dim_Level_ID
1174: AND A.Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim
1175: AND A.Dim_Group_ID = l_dimension_id;
1176: BEGIN
1177: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Remove_Unused_PMF_Dimenison procedure');
1178: FND_MSG_PUB.Initialize;

Line 1227: BSC_BIS_DIMENSION_PUB.Delete_Dimension

1223: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_KPI_MEAS_PUB.Unassign_Dims_From_Dim_Set');
1224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1225: END IF;
1226: --now delete the dimension from system level, ie from BSC_SYS_DIM_GROUPS_TL table
1227: BSC_BIS_DIMENSION_PUB.Delete_Dimension
1228: ( p_commit => FND_API.G_FALSE
1229: , p_dim_short_name => l_temp_var
1230: , x_return_status => x_return_status
1231: , x_msg_count => x_msg_count

Line 1235: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_DIMENSION_PUB.Delete_Dimension');

1231: , x_msg_count => x_msg_count
1232: , x_msg_data => x_msg_data
1233: );
1234: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1235: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_DIMENSION_PUB.Delete_Dimension');
1236: x_return_status := FND_API.G_RET_STS_SUCCESS;
1237: x_msg_data := NULL;
1238: END IF;
1239: END IF;

Line 4437: BSC_BIS_DIMENSION_PUB.Create_Dimension

4433: END LOOP;
4434: --dbms_output.PUT_LINE('Unique Short Name Created '||l_dim_short_name);
4435: --dbms_output.PUT_LINE('l_dim_obj_short_names '||l_dim_obj_short_names);
4436: --dbms_output.PUT_LINE('CREATE DIMENSION GROUPS');
4437: BSC_BIS_DIMENSION_PUB.Create_Dimension
4438: ( p_commit => FND_API.G_FALSE
4439: , p_dim_short_name => l_dim_short_name
4440: , p_display_name => l_dim_short_name
4441: , p_description => l_dim_short_name

Line 4451: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_DIMENSION_PUB.Create_Dimension');

4447: , x_msg_count => x_msg_count
4448: , x_msg_data => x_msg_data
4449: );
4450: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4451: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_BIS_DIMENSION_PUB.Create_Dimension');
4452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4453: END IF;
4454:
4455: END IF;

Line 4720: --dbms_output.PUT_LINE('BSC_BIS_DIMENSION_PUB.CREATE_DIM_LEVEL_GROUP Failed: at BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group');

4716: , x_msg_count => x_msg_count
4717: , x_msg_data => x_msg_data
4718: );
4719: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4720: --dbms_output.PUT_LINE('BSC_BIS_DIMENSION_PUB.CREATE_DIM_LEVEL_GROUP Failed: at BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group');
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: END IF;
4723: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET
4724: ( p_dataset_id => l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id

Line 4730: --dbms_output.PUT_LINE('BSC_BIS_DIMENSION_PUB.CREATE_DIM_LEVEL_GROUP Failed: at BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group');

4726: , x_msg_count => x_msg_count
4727: , x_msg_data => x_msg_data
4728: );
4729: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4730: --dbms_output.PUT_LINE('BSC_BIS_DIMENSION_PUB.CREATE_DIM_LEVEL_GROUP Failed: at BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group');
4731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4732: END IF;
4733: -- END Granular Locking added by Aditya
4734: ELSIF (l_data_source = 'BSC') THEN

Line 5689: BSC_BIS_DIMENSION_PUB.Delete_Dimension

5685: CLOSE c_dim_short_name;
5686: --delete the imported dimensions if it is not used in any report
5687: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(l_dim_shortName, BSC_UTILITY.c_DIMENSION);
5688: IF(l_regions IS NULL AND l_dim_shortName IS NOT NULL) THEN
5689: BSC_BIS_DIMENSION_PUB.Delete_Dimension
5690: ( p_commit => FND_API.G_FALSE
5691: , p_dim_short_name => l_dim_shortName
5692: , x_return_status => x_return_status
5693: , x_msg_count => x_msg_count

Line 6343: AND B.Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim;

6339: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
6340: , BSC_SYS_DIM_GROUPS_VL B
6341: WHERE A.Dim_Group_Id = l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id
6342: AND A.Dim_Group_ID = B.Dim_Group_ID
6343: AND B.Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim;
6344: BEGIN
6345: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet procedure');
6346: FND_MSG_PUB.Initialize;
6347: x_return_status := FND_API.G_RET_STS_SUCCESS;