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_BIS_KPI_MEAS_PUB dependencies on BSC_BIS_LOCKS_PUB

Line 1199: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

1195: SELECT short_name INTO l_temp_var
1196: FROM BSC_SYS_DIM_GROUPS_VL
1197: WHERE dim_group_id = l_dimension_id;
1198: -- START Granular Locking
1199: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
1200: ( p_Kpi_Id => p_Kpi_Id
1201: , p_Dim_Set_Id => p_dim_set_id
1202: , p_time_stamp => NULL
1203: , x_return_status => x_return_status

Line 1208: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Failed');

1204: , x_msg_count => x_msg_count
1205: , x_msg_data => x_msg_data
1206: );
1207: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1208: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Failed');
1209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1210: END IF;
1211: -- END Granular Locking
1212: BSC_BIS_KPI_MEAS_PUB.Unassign_Dims_From_Dim_Set

Line 1601: BSC_BIS_LOCKS_PUB.LOCK_KPI

1597: --dbms_output.PUT_LINE('l_bsc_dimset_rec.bsc_dim_set_id <'||l_bsc_dimset_rec.bsc_dim_set_id||'>');
1598:
1599: -- START Granular Locking
1600: -- Lock the underlying KPI, so that it is not deleted when assignment is being done.
1601: BSC_BIS_LOCKS_PUB.LOCK_KPI
1602: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
1603: , p_time_stamp => p_time_stamp
1604: , p_Full_Lock_Flag => FND_API.G_FALSE
1605: , x_return_status => x_return_status

Line 1610: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.CREATE_DIM_SET Failed: at BSC_BIS_LOCKS_PUB.LOCK_KPI');

1606: , x_msg_count => x_msg_count
1607: , x_msg_data => x_msg_data
1608: );
1609: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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

Line 1639: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

1635: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.CREATE_DIM_SET Failed: at BSC_DIMENSION_SETS_PUB.Create_Dim_Grp_Lev_In_Dset');
1636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1637: END IF;
1638: -- START: Granular Locking, Change time stamp of Dim Set & KPI
1639: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
1640: ( p_Kpi_Id => p_Kpi_Id
1641: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
1642: , x_return_status => x_return_status
1643: , x_msg_count => x_msg_count

Line 1647: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET Failed: SET_TIME_STAMP_DIM_SET');

1643: , x_msg_count => x_msg_count
1644: , x_msg_data => x_msg_data
1645: );
1646: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1647: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET Failed: SET_TIME_STAMP_DIM_SET');
1648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1649: END IF;
1650: -- END: Granular Locking, Change time stamp of Dim Set & KPI
1651: --for all shared indicator, repeat the steps above

Line 1656: BSC_BIS_LOCKS_PUB.LOCK_KPI

1652: FOR cd IN c_kpi_ids LOOP
1653: l_bsc_dimset_rec.Bsc_Kpi_Id := cd.indicator;
1654: --dbms_output.PUT_LINE('Within Shared Indicator Loop KPI_ID is <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');
1655: -- Lock the underlying KPI, so that it is not deleted when assignment is being done.
1656: BSC_BIS_LOCKS_PUB.LOCK_KPI
1657: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
1658: , p_time_stamp => NULL
1659: , p_Full_Lock_Flag => FND_API.G_FALSE
1660: , x_return_status => x_return_status

Line 1665: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.CREATE_DIM_SET Failed: at BSC_BIS_LOCKS_PUB.LOCK_KPI');

1661: , x_msg_count => x_msg_count
1662: , x_msg_data => x_msg_data
1663: );
1664: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1665: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.CREATE_DIM_SET Failed: at BSC_BIS_LOCKS_PUB.LOCK_KPI');
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668:
1669: SELECT NVL(MAX(dim_set_id) + 1, 0)

Line 1698: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

1694: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.CREATE_DIM_SET Failed: at BSC_DIMENSION_SETS_PUB.Create_Dim_Grp_Lev_In_Dset');
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;
1697: -- START: Granular Locking, Change time stamp of Dim Set & KPI
1698: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
1699: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
1700: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
1701: , x_return_status => x_return_status
1702: , x_msg_count => x_msg_count

Line 1706: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET Failed: SET_TIME_STAMP_DIM_SET');

1702: , x_msg_count => x_msg_count
1703: , x_msg_data => x_msg_data
1704: );
1705: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1706: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET Failed: SET_TIME_STAMP_DIM_SET');
1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1708: END IF;
1709: -- END: Granular Locking, Change time stamp of Dim Set & KPI
1710: END LOOP;

Line 2179: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

2175:
2176: -- START Granular Locking
2177: -- We need to call locking only in this API, since this is the lowermost API
2178: -- and all Update APIs will call this API eventually.
2179: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
2180: ( p_Kpi_Id => p_Kpi_Id
2181: , p_Dim_Set_Id => p_dim_set_id
2182: , p_time_stamp => p_time_stamp
2183: , x_return_status => x_return_status

Line 2188: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET');

2184: , x_msg_count => x_msg_count
2185: , x_msg_data => x_msg_data
2186: );
2187: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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

Line 2204: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

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
2205: ( p_Kpi_Id => p_Kpi_Id
2206: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
2207: , x_return_status => x_return_status
2208: , x_msg_count => x_msg_count

Line 2212: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET');

2208: , x_msg_count => x_msg_count
2209: , x_msg_data => x_msg_data
2210: );
2211: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2212: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET');
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215: -- END: Granular Locking, Change time stamp of Dim Set & KPI
2216: --for shared inidicators repeat the steps above

Line 2233: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

2229: END IF;
2230: -- START Granular Locking
2231: -- We need to call locking only in this API, since this is the lowermost API
2232: -- and all Update APIs will call this API eventually.
2233: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
2234: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
2235: , p_Dim_Set_Id => p_dim_set_id
2236: , p_time_stamp => NULL
2237: , x_return_status => x_return_status

Line 2242: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET');

2238: , x_msg_count => x_msg_count
2239: , x_msg_data => x_msg_data
2240: );
2241: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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

Line 2258: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

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
2259: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
2260: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
2261: , x_return_status => x_return_status
2262: , x_msg_count => x_msg_count

Line 2266: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET');

2262: , x_msg_count => x_msg_count
2263: , x_msg_data => x_msg_data
2264: );
2265: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2266: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET');
2267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2268: END IF;
2269: -- END: Granular Locking, Change time stamp of Dim Set & KPI
2270: END LOOP;

Line 2446: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

2442: END IF;
2443: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id; --number
2444: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Dim_Set_Id <'||l_bsc_dimset_rec.Bsc_Dim_Set_Id||'>');
2445: -- START Granular Locking
2446: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
2447: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
2448: , p_Dim_Set_Id => p_dim_set_id
2449: , p_time_stamp => NULL
2450: , x_return_status => x_return_status

Line 2455: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Delete_Dim_Set');

2451: , x_msg_count => x_msg_count
2452: , x_msg_data => x_msg_data
2453: );
2454: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2455: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Delete_Dim_Set');
2456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2457: END IF;
2458: -- END Granular Locking
2459: -- Aditya added for Incremental Changes

Line 2486: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

2482: FROM BSC_KPI_DIM_GROUPS
2483: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2484: AND dim_set_id = p_dim_set_id;
2485: IF (l_count <> 0) THEN
2486: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
2487: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
2488: , p_Dim_Set_Id => p_dim_set_id
2489: , p_time_stamp => NULL
2490: , x_return_status => x_return_status

Line 2495: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Delete_Dim_Set');

2491: , x_msg_count => x_msg_count
2492: , x_msg_data => x_msg_data
2493: );
2494: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2495: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Delete_Dim_Set');
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: END IF;
2498: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
2499: IF (NOT BSC_BIS_KPI_MEAS_PUB.is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN

Line 2708: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

2704: END IF;
2705: END LOOP;
2706:
2707: IF (l_dim_short_names IS NOT NULL) THEN
2708: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
2709: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
2710: , p_Dim_Set_Id => l_bsc_dimset_rec.bsc_dim_set_id
2711: , p_time_stamp => p_time_stamp
2712: , x_return_status => x_return_status

Line 2717: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Assign_Dims_To_Dim_Set');

2713: , x_msg_count => x_msg_count
2714: , x_msg_data => x_msg_data
2715: );
2716: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2717: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Assign_Dims_To_Dim_Set');
2718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2719: END IF;
2720: -- BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
2721: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Grp_Lev_In_Dset

Line 2735: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

2731: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Assign_Dims_To_Dim_Set Failed: at BSC_DIMENSION_SETS_PUB.Create_Dim_Grp_Lev_In_Dset');
2732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2733: END IF;
2734: -- START: Granular Locking, Change time stamp of Dim Set & KPI
2735: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
2736: ( p_Kpi_Id => p_Kpi_Id
2737: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
2738: , x_return_status => x_return_status
2739: , x_msg_count => x_msg_count

Line 2743: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET - Assign_Dims_To_Dim_Set');

2739: , x_msg_count => x_msg_count
2740: , x_msg_data => x_msg_data
2741: );
2742: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2743: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET - Assign_Dims_To_Dim_Set');
2744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2745: END IF;
2746: -- END: Granular Locking, Change time stamp of Dim Set & KPI
2747: --repeat the steps above for all the shared indicators

Line 2762: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

2758: FND_MSG_PUB.ADD;
2759: RAISE FND_API.G_EXC_ERROR;
2760: END IF;
2761: -- START Granular Locking
2762: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
2763: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
2764: , p_Dim_Set_Id => l_bsc_dimset_rec.bsc_dim_set_id
2765: , p_time_stamp => NULL -- Should not pass time_stamp here
2766: , x_return_status => x_return_status

Line 2771: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Assign_Dims_To_Dim_Set');

2767: , x_msg_count => x_msg_count
2768: , x_msg_data => x_msg_data
2769: );
2770: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2771: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Assign_Dims_To_Dim_Set');
2772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2773: END IF;
2774: --BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
2775: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Grp_Lev_In_Dset

Line 2789: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

2785: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Assign_Dims_To_Dim_Set Failed: at BSC_DIMENSION_SETS_PUB.Create_Dim_Grp_Lev_In_Dset');
2786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2787: END IF;
2788: -- START: Granular Locking, Change time stamp of Dim Set & KPI
2789: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
2790: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
2791: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
2792: , x_return_status => x_return_status
2793: , x_msg_count => x_msg_count

Line 2797: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET - Assign_Dims_To_Dim_Set');

2793: , x_msg_count => x_msg_count
2794: , x_msg_data => x_msg_data
2795: );
2796: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2797: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET - Assign_Dims_To_Dim_Set');
2798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2799: END IF;
2800: END LOOP;
2801: END IF;

Line 3192: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: END IF;
3191: -- START Granular Locking
3192: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
3193: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
3194: , p_Dim_Set_Id => p_dim_set_id
3195: , p_time_stamp => p_time_stamp
3196: , x_return_status => x_return_status

Line 3201: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Unassign_Dims_From_Dim_Set');

3197: , x_msg_count => x_msg_count
3198: , x_msg_data => x_msg_data
3199: );
3200: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3201: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Unassign_Dims_From_Dim_Set');
3202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3203: END IF;
3204: -- END Granular Locking
3205: IF(p_dim_short_names IS NOT NULL) THEN

Line 3246: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

3242: END LOOP;
3243: END IF;
3244:
3245: -- START: Granular Locking, Change time stamp of Dim Set & KPI
3246: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
3247: ( p_Kpi_Id => p_Kpi_Id
3248: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
3249: , x_return_status => x_return_status
3250: , x_msg_count => x_msg_count

Line 3254: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Unassign_Dims_From_Dim_Set Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET');

3250: , x_msg_count => x_msg_count
3251: , x_msg_data => x_msg_data
3252: );
3253: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3254: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Unassign_Dims_From_Dim_Set Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET');
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3256: END IF;
3257: --repeat the steps above for all the shared indicators
3258: FOR cd IN c_kpi_ids LOOP

Line 3282: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

3278: INTO l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id
3279: FROM BSC_SYS_DIM_GROUPS_VL
3280: WHERE short_name = l_dim_short_name;
3281: -- START Granular Locking
3282: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
3283: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
3284: , p_Dim_Set_Id => p_dim_set_id
3285: , p_time_stamp => NULL -- should not pass time_stamp here
3286: , x_return_status => x_return_status

Line 3291: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Unassign_Dims_From_Dim_Set');

3287: , x_msg_count => x_msg_count
3288: , x_msg_data => x_msg_data
3289: );
3290: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3291: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Unassign_Dims_From_Dim_Set');
3292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3293: END IF;
3294: -- END Granular Locking
3295: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id <'||l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id||'>');

Line 3311: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

3307: END IF;
3308: END IF;
3309: END LOOP;
3310: -- START: Granular Locking, Change time stamp of Dim Set & KPI
3311: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
3312: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
3313: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
3314: , x_return_status => x_return_status
3315: , x_msg_count => x_msg_count

Line 3319: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET - Unassign_Dims_From_Dim_Set');

3315: , x_msg_count => x_msg_count
3316: , x_msg_data => x_msg_data
3317: );
3318: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3319: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET - Unassign_Dims_From_Dim_Set');
3320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3321: END IF;
3322: -- END: Granular Locking, Change time stamp of Dim Set & KPI
3323: END IF;

Line 3516: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP

3512: FROM BSC_SYS_DIM_GROUPS_VL
3513: WHERE short_name = l_dim_short_name;
3514: --dbms_output.PUT_LINE('l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id <'||l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id||'>');
3515: -- START : Granular Locking
3516: BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP
3517: ( p_dim_group_id => l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id
3518: , p_time_stamp => NULL
3519: , x_return_status => x_return_status
3520: , x_msg_count => x_msg_count

Line 3524: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP Failed: at Create_Dim_Grp_Lev_In_Dset');

3520: , x_msg_count => x_msg_count
3521: , x_msg_data => x_msg_data
3522: );
3523: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3524: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_GROUP Failed: at Create_Dim_Grp_Lev_In_Dset');
3525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3526: END IF;
3527: -- END : Granular Locking
3528: BSC_DIMENSION_SETS_PUB.Create_Dim_Group_In_Dset--insert into BSC_KPI_DIM_GROUPS

Line 3586: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

3582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3583: END IF;
3584: END IF;
3585: -- START: Granular Locking, Change time stamp of Dim Set & KPI
3586: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
3587: ( p_Kpi_Id => p_Kpi_Id
3588: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
3589: , x_return_status => x_return_status
3590: , x_msg_count => x_msg_count

Line 3594: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET: at BSC_DIMENSION_SETS_PUB.Create_Dim_Grp_Lev_In_Dset');

3590: , x_msg_count => x_msg_count
3591: , x_msg_data => x_msg_data
3592: );
3593: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3594: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET: at BSC_DIMENSION_SETS_PUB.Create_Dim_Grp_Lev_In_Dset');
3595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3596: END IF;
3597: --dbms_output.PUT_LINE('END Setting TIME STAMP');
3598: -- END: Granular Locking, Change time stamp of Dim Set & KPI

Line 4271: BSC_BIS_LOCKS_PUB.LOCK_KPI

4267: END IF;
4268: END IF;
4269: --dbms_output.PUT_LINE('p_data_source '||l_data_source);
4270: -- START Granular Locking - Lock the KPI Under consideration
4271: BSC_BIS_LOCKS_PUB.LOCK_KPI
4272: ( p_Kpi_Id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4273: , p_time_stamp => p_time_stamp
4274: , p_Full_Lock_Flag => NULL
4275: , x_return_status => x_return_status

Line 4280: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');

4276: , x_msg_count => x_msg_count
4277: , x_msg_data => x_msg_data
4278: );
4279: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4280: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');
4281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4282: END IF;
4283: --ADDED BY PETER
4284: -- Save the old data set ID for comparison (3169904)

Line 4392: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL

4388: ELSE
4389: l_dim_obj_tmp_short_names := l_dim_obj_tmp_short_names ||',' || l_dim_obj_name;
4390: END IF;
4391:
4392: BSC_BIS_LOCKS_PUB.LOCK_DIM_LEVEL
4393: ( p_dim_level_id => NVL(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1)
4394: , p_time_stamp => NULL
4395: , x_return_status => x_return_status
4396: , x_msg_count => x_msg_count

Line 4401: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_CREATE_DIMENSION');

4397: , x_msg_data => x_msg_data
4398: );
4399: --dbms_output.PUT_LINE('locked @@ .. '|| l_dim_obj_name);
4400: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4401: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_CREATE_DIMENSION');
4402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4403: END IF;
4404: END IF;
4405: END LOOP;

Line 4644: BSC_BIS_LOCKS_PUB.LOCK_DATASET

4640: l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0 := l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id;
4641: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN
4642: l_Bsc_Anal_Opt_Rec.Bsc_Option_Name := l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name;
4643: END IF;
4644: BSC_BIS_LOCKS_PUB.LOCK_DATASET
4645: ( p_dataset_id => l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id
4646: , p_time_stamp => NULL
4647: , x_return_status => x_return_status
4648: , x_msg_count => x_msg_count

Line 4652: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

4648: , x_msg_count => x_msg_count
4649: , x_msg_data => x_msg_data
4650: );
4651: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4652: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4654: END IF;
4655: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4656: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);

Line 4712: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

4708: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4709: END IF;
4710: END IF;
4711: -- START Granular Locking added by Aditya
4712: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
4713: ( p_kpi_id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4714: , p_dim_set_id => l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id
4715: , x_return_status => x_return_status
4716: , x_msg_count => x_msg_count

Line 4723: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET

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
4725: , x_return_status => x_return_status
4726: , x_msg_count => x_msg_count
4727: , x_msg_data => x_msg_data

Line 4744: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET

4740: l_Bsc_Anal_Opt_Rec.Bsc_Option_Name := p_option0_Name;
4741: --dbms_output.PUT_LINE('BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options '||p_option0_Name);
4742: -- START Granular Locking
4743: IF (l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id IS NOT NULL) THEN
4744: BSC_BIS_LOCKS_PUB.LOCK_DIM_SET
4745: ( p_Kpi_Id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4746: , p_Dim_Set_Id => l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id
4747: , p_time_stamp => null
4748: , x_return_status => x_return_status

Line 4753: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Failed');

4749: , x_msg_count => x_msg_count
4750: , x_msg_data => x_msg_data
4751: );
4752: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4753: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Failed');
4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4755: END IF;
4756: END IF;
4757: -- Lock the Datasets before UPDATE

Line 4760: BSC_BIS_LOCKS_PUB.LOCK_DATASET

4756: END IF;
4757: -- Lock the Datasets before UPDATE
4758: -- IF (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL) THEN fiexed bug
4759: IF (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NOT NULL) THEN
4760: BSC_BIS_LOCKS_PUB.LOCK_DATASET
4761: ( p_dataset_id => l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id
4762: , p_time_stamp => NULL
4763: , x_return_status => x_return_status
4764: , x_msg_count => x_msg_count

Line 4768: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

4764: , x_msg_count => x_msg_count
4765: , x_msg_data => x_msg_data
4766: );
4767: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4768: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4770: END IF;
4771: END IF;
4772: -- END Granular Locking

Line 4891: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_KPI

4887: END LOOP;
4888: END IF;
4889: --END BY PETER
4890: -- START Granular Locking added by Aditya
4891: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_KPI
4892: ( p_kpi_id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4893: , x_return_status => x_return_status
4894: , x_msg_count => x_msg_count
4895: , x_msg_data => x_msg_data

Line 4898: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET Failed');

4894: , x_msg_count => x_msg_count
4895: , x_msg_data => x_msg_data
4896: );
4897: IF ((x_return_status = FND_API.G_RET_STS_ERROR) OR (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
4898: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET Failed');
4899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4900: END IF;
4901: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET
4902: ( p_dataset_id => l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id

Line 4901: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET

4897: IF ((x_return_status = FND_API.G_RET_STS_ERROR) OR (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
4898: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET Failed');
4899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4900: END IF;
4901: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET
4902: ( p_dataset_id => l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id
4903: , x_return_status => x_return_status
4904: , x_msg_count => x_msg_count
4905: , x_msg_data => x_msg_data

Line 4908: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET Failed');

4904: , x_msg_count => x_msg_count
4905: , x_msg_data => x_msg_data
4906: );
4907: IF ((x_return_status = FND_API.G_RET_STS_ERROR) OR (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
4908: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET Failed');
4909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4910: END IF;
4911: -- END Granular Locking added by Aditya
4912: END IF;

Line 5100: BSC_BIS_LOCKS_PUB.LOCK_KPI

5096: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN
5097: l_Bsc_Anal_Opt_Rec.Bsc_Option_Name := l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name;
5098: END IF;
5099: --START Granular Locking - Lock the KPI Under consideration
5100: BSC_BIS_LOCKS_PUB.LOCK_KPI
5101: ( p_Kpi_Id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
5102: , p_time_stamp => p_time_stamp
5103: , p_Full_Lock_Flag => NULL
5104: , x_return_status => x_return_status

Line 5109: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');

5105: , x_msg_count => x_msg_count
5106: , x_msg_data => x_msg_data
5107: );
5108: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5109: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');
5110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5111: END IF;
5112: -- END Granular Locking - Lock the KPI Under consideration
5113: IF (l_datasource = 'PMF') THEN

Line 5181: BSC_BIS_LOCKS_PUB.LOCK_DATASET

5177: l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0;
5178: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN
5179: l_Bsc_Anal_Opt_Rec.Bsc_Option_Name := l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name;
5180: END IF;
5181: BSC_BIS_LOCKS_PUB.LOCK_DATASET
5182: ( p_dataset_id => l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id
5183: , p_time_stamp => NULL
5184: , x_return_status => x_return_status
5185: , x_msg_count => x_msg_count

Line 5189: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');

5185: , x_msg_count => x_msg_count
5186: , x_msg_data => x_msg_data
5187: );
5188: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5189: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DATASET Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
5190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5191: END IF;
5192: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5193: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);

Line 5231: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET

5227: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5228: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Create_Analysis_Options');
5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5230: END IF;
5231: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET
5232: ( p_dataset_id => l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id
5233: , x_return_status => x_return_status
5234: , x_msg_count => x_msg_count
5235: , x_msg_data => x_msg_data

Line 5238: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET Failed');

5234: , x_msg_count => x_msg_count
5235: , x_msg_data => x_msg_data
5236: );
5237: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5238: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET Failed');
5239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5240: END IF;
5241: -- Added by ADRAO
5242: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_KPI

Line 5242: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_KPI

5238: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET Failed');
5239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5240: END IF;
5241: -- Added by ADRAO
5242: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_KPI
5243: ( p_kpi_id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
5244: , x_return_status => x_return_status
5245: , x_msg_count => x_msg_count
5246: , x_msg_data => x_msg_data

Line 5445: BSC_BIS_LOCKS_PUB.LOCK_KPI

5441: AND analysis_group_id = 0
5442: AND option_id = p_option_id;
5443:
5444: -- START Granular Locking - Lock the KPI Under consideration
5445: BSC_BIS_LOCKS_PUB.LOCK_KPI
5446: ( p_Kpi_Id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
5447: , p_time_stamp => NULL
5448: , p_Full_Lock_Flag => NULL
5449: , x_return_status => x_return_status

Line 5454: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');

5450: , x_msg_count => x_msg_count
5451: , x_msg_data => x_msg_data
5452: );
5453: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5454: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');
5455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5456: END IF;
5457: --Determine number of distinct dataset_id before delete.
5458: SELECT COUNT (DISTINCT dataset_id) INTO l_count

Line 5866: BSC_BIS_LOCKS_PUB.LOCK_KPI

5862: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Value := BSC_KPI_PUB.Benchmark_Kpi_Line_Graph;
5863: END IF;
5864: -- Set some default values.
5865: -- Added by ADRAO
5866: BSC_BIS_LOCKS_PUB.LOCK_KPI
5867: ( p_Kpi_Id => l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
5868: , p_time_stamp => p_time_stamp
5869: , p_Full_Lock_Flag => NULL
5870: , x_return_status => x_return_status

Line 5875: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');

5871: , x_msg_count => x_msg_count
5872: , x_msg_data => x_msg_data
5873: );
5874: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5875: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');
5876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5877: END IF;
5878: -- We need to check if there is an update on the Indicator name in order
5879: -- to prevent it. To do this we need to check if there is a different

Line 5979: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_KPI

5975: END IF;
5976: END IF;
5977:
5978: -- Added by ADRAO
5979: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_KPI
5980: ( p_kpi_id => l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
5981: , x_return_status => x_return_status
5982: , x_msg_count => x_msg_count
5983: , x_msg_data => x_msg_data

Line 6435: BSC_BIS_LOCKS_PUB.LOCK_KPI

6431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6432: END IF;
6433: FOR cn_bsc IN c_dim_group_id LOOP
6434: l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id := cn_bsc.Dim_Group_ID;
6435: BSC_BIS_LOCKS_PUB.LOCK_KPI
6436: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
6437: , p_time_stamp => NULL
6438: , p_Full_Lock_Flag => FND_API.G_FALSE
6439: , x_return_status => x_return_status

Line 6444: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.Lock_Dim_Group');

6440: , x_msg_count => x_msg_count
6441: , x_msg_data => x_msg_data
6442: );
6443: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6444: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.Lock_Dim_Group');
6445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6446: END IF;
6447: -- END : Granular Locking
6448: BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties--insert into BSC_KPI_DIM_LEVEL_PROPERTIES

Line 6490: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

6486: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
6487: END IF;
6488: --dbms_output.PUT_LINE('STRUCTURAL CHANGES');
6489: END IF;
6490: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
6491: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
6492: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
6493: , x_return_status => x_return_status
6494: , x_msg_count => x_msg_count

Line 6498: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');

6494: , x_msg_count => x_msg_count
6495: , x_msg_data => x_msg_data
6496: );
6497: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6498: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');
6499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6500: END IF;
6501: --reapeating the steps for shared KPIs also
6502: FOR cm IN c_kpi_ids LOOP

Line 6520: BSC_BIS_LOCKS_PUB.LOCK_KPI

6516: RAISE FND_API.G_EXC_ERROR;
6517: END IF;
6518: FOR cn_bsc IN c_dim_group_id LOOP
6519: l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id := cn_bsc.Dim_Group_ID;
6520: BSC_BIS_LOCKS_PUB.LOCK_KPI
6521: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
6522: , p_time_stamp => NULL
6523: , p_Full_Lock_Flag => FND_API.G_FALSE
6524: , x_return_status => x_return_status

Line 6529: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.Lock_Dim_Group');

6525: , x_msg_count => x_msg_count
6526: , x_msg_data => x_msg_data
6527: );
6528: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6529: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.Lock_Dim_Group');
6530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6531: END IF;
6532: -- END : Granular Locking
6533: BSC_DIMENSION_SETS_PUB.Create_Dim_Level_Properties--insert into BSC_KPI_DIM_LEVEL_PROPERTIES

Line 6575: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

6571: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
6572: END IF;
6573: --dbms_output.PUT_LINE('STRUCTURAL CHANGES');
6574: END IF;
6575: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
6576: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
6577: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
6578: , x_return_status => x_return_status
6579: , x_msg_count => x_msg_count

Line 6583: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');

6579: , x_msg_count => x_msg_count
6580: , x_msg_data => x_msg_data
6581: );
6582: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6583: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');
6584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6585: END IF;
6586: END LOOP;
6587: BSC_BIS_KPI_MEAS_PUB.Create_Default_Kpi_Dim_Object

Line 6685: BSC_BIS_LOCKS_PUB.LOCK_KPI

6681: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id;
6682: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id;
6683: FOR cn_bsc IN c_dim_group_id LOOP
6684: l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id := cn_bsc.Dim_Group_ID;
6685: BSC_BIS_LOCKS_PUB.LOCK_KPI
6686: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
6687: , p_time_stamp => NULL
6688: , p_Full_Lock_Flag => FND_API.G_FALSE
6689: , x_return_status => x_return_status

Line 6694: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.Lock_Dim_Group');

6690: , x_msg_count => x_msg_count
6691: , x_msg_data => x_msg_data
6692: );
6693: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6694: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.Lock_Dim_Group');
6695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6696: END IF;
6697: FOR cd IN c_dim_level_id LOOP
6698: l_bsc_dimset_rec.Bsc_Level_Id := cd.dim_level_id;

Line 6723: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

6719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6720: END IF;
6721: END LOOP;
6722: END LOOP;
6723: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
6724: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
6725: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
6726: , x_return_status => x_return_status
6727: , x_msg_count => x_msg_count

Line 6731: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');

6727: , x_msg_count => x_msg_count
6728: , x_msg_data => x_msg_data
6729: );
6730: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6731: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');
6732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6733: END IF;
6734: --for share KPIs
6735: FOR cm IN c_kpi_ids LOOP

Line 6739: BSC_BIS_LOCKS_PUB.LOCK_KPI

6735: FOR cm IN c_kpi_ids LOOP
6736: l_bsc_dimset_rec.Bsc_Kpi_Id := cm.indicator;
6737: FOR cn_bsc IN c_dim_group_id LOOP
6738: l_bsc_dimset_rec.Bsc_Dim_Level_Group_Id := cn_bsc.Dim_Group_ID;
6739: BSC_BIS_LOCKS_PUB.LOCK_KPI
6740: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
6741: , p_time_stamp => NULL
6742: , p_Full_Lock_Flag => FND_API.G_FALSE
6743: , x_return_status => x_return_status

Line 6748: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.Lock_Dim_Group');

6744: , x_msg_count => x_msg_count
6745: , x_msg_data => x_msg_data
6746: );
6747: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6748: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.Lock_Dim_Group');
6749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6750: END IF;
6751: FOR cd IN c_dim_level_id LOOP
6752: l_bsc_dimset_rec.Bsc_Level_Id := cd.dim_level_id;

Line 6777: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

6773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6774: END IF;
6775: END LOOP;
6776: END LOOP;
6777: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET
6778: ( p_Kpi_Id => l_bsc_dimset_rec.Bsc_Kpi_Id
6779: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id
6780: , x_return_status => x_return_status
6781: , x_msg_count => x_msg_count

Line 6785: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');

6781: , x_msg_count => x_msg_count
6782: , x_msg_data => x_msg_data
6783: );
6784: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6785: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET <'||x_msg_data||'>');
6786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6787: END IF;
6788: END LOOP;
6789: --create the default entry 'XXX' from BSC_KPI_DIM_LEVELS_B if exists

Line 7550: BSC_BIS_LOCKS_PUB.LOCK_KPI

7546: AND analysis_group_id = 0
7547: AND option_id = p_Option_0;
7548: -- START Granular Locking - Lock the KPI Under consideration
7549:
7550: BSC_BIS_LOCKS_PUB.LOCK_KPI
7551: ( p_Kpi_Id => l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
7552: , p_time_stamp => NULL
7553: , p_Full_Lock_Flag => NULL
7554: , x_return_status => x_return_status

Line 7559: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');

7555: , x_msg_count => x_msg_count
7556: , x_msg_data => x_msg_data
7557: );
7558: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7559: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_KPI - Failed');
7560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7561: END IF;
7562: --Determine number of distinct dataset_id before delete.
7563: /*SELECT COUNT (DISTINCT dataset_id) INTO l_count