[Home] [Help]
1610: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.CREATE_DIM_SET Failed: at BSC_BIS_LOCKS_PUB.LOCK_KPI');
1611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1612: END IF;
1613: -- END Granular Locking
1614: BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl--INSERT INTO BSC_KPI_DIM_SETS_TL
1615: ( p_commit => FND_API.G_FALSE
1616: , p_Dim_Set_Rec => l_bsc_dimset_rec
1617: , x_return_status => x_return_status
1618: , x_msg_count => x_msg_count
1618: , x_msg_count => x_msg_count
1619: , x_msg_data => x_msg_data
1620: );
1621: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1622: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.CREATE_DIM_SET Failed: at BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl');
1623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1624: END IF;
1625: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Grp_Lev_In_Dset
1626: ( p_commit => FND_API.G_FALSE
1669: SELECT NVL(MAX(dim_set_id) + 1, 0)
1670: INTO l_bsc_dimset_rec.bsc_dim_set_id
1671: FROM BSC_KPI_DIM_SETS_VL
1672: WHERE indicator = l_bsc_dimset_rec.bsc_kpi_id;
1673: BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl--INSERT INTO BSC_KPI_DIM_SETS_TL
1674: ( p_commit => FND_API.G_FALSE
1675: , p_Dim_Set_Rec => l_bsc_dimset_rec
1676: , x_return_status => x_return_status
1677: , x_msg_count => x_msg_count
1677: , x_msg_count => x_msg_count
1678: , x_msg_data => x_msg_data
1679: );
1680: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1681: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.CREATE_DIM_SET Failed: at BSC_DIMENSION_SETS_PUB.Create_Bsc_Kpi_Dim_Sets_Tl');
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Grp_Lev_In_Dset
1685: ( p_commit => FND_API.G_FALSE
2188: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET');
2189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2190: END IF;
2191: -- END Granular Locking
2192: BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl
2193: ( p_commit => FND_API.G_FALSE
2194: , p_Dim_Set_Rec => l_bsc_dimset_rec
2195: , x_return_status => x_return_status
2196: , x_msg_count => x_msg_count
2196: , x_msg_count => x_msg_count
2197: , x_msg_data => x_msg_data
2198: );
2199: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2200: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set Failed: at BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl');
2201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2202: END IF;
2203: -- START: Granular Locking, Change time stamp of Dim Set & KPI
2204: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
2242: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET');
2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2244: END IF;
2245: -- END Granular Locking
2246: BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl
2247: ( p_commit => FND_API.G_FALSE
2248: , p_Dim_Set_Rec => l_bsc_dimset_rec
2249: , x_return_status => x_return_status
2250: , x_msg_count => x_msg_count
2250: , x_msg_count => x_msg_count
2251: , x_msg_data => x_msg_data
2252: );
2253: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2254: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set Failed: at BSC_DIMENSION_SETS_PUB.Update_Bsc_Kpi_Dim_Sets_Tl');
2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2256: END IF;
2257: -- START: Granular Locking, Change time stamp of Dim Set & KPI
2258: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
4088: l_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
4089: l_dim_obj_short_names VARCHAR2(32000);
4090: l_default_short_names VARCHAR2(32000);
4091: l_view_by_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
4092: l_dim_set_id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE;
4093:
4094: l_dim_obj_names VARCHAR2(32000);
4095: l_dim_obj_name VARCHAR2(30);
4096: l_index NUMBER := 0;