DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_BIS_KPI_MEAS_PUB

Line 2217: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet');

2213: --DBMS_OUTPUT.PUT_LINE('l_refresh_kpi_ids '||l_refresh_kpi_ids);
2214: IF (l_refresh_kpi_ids <> ',') THEN
2215: --DBMS_OUTPUT.PUT_LINE('Cascading changes to KPIs Part Starts Here');
2216: FOR cd IN c_kpi_dim_set LOOP
2217: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet');
2218: IF(NOT (l_source = 'PMF' AND cd.short_name IS NULL)) THEN
2219: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet
2220: ( p_commit => FND_API.G_FALSE
2221: , p_kpi_id => cd.Indicator

Line 2219: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet

2215: --DBMS_OUTPUT.PUT_LINE('Cascading changes to KPIs Part Starts Here');
2216: FOR cd IN c_kpi_dim_set LOOP
2217: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet');
2218: IF(NOT (l_source = 'PMF' AND cd.short_name IS NULL)) THEN
2219: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet
2220: ( p_commit => FND_API.G_FALSE
2221: , p_kpi_id => cd.Indicator
2222: , p_dim_set_id => cd.Dim_Set_Id
2223: , p_delete => TRUE -- delete before creating in cascading

Line 2230: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet');

2226: , x_msg_data => x_msg_data
2227: );
2228: END IF;
2229: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2230: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet');
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: END IF;
2233: END LOOP;
2234: --DBMS_OUTPUT.PUT_LINE('Cascading changes to KPIs Part Ends Here');

Line 4116: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN

4112: WHERE INDICATOR = l_kpi_id
4113: AND DIM_SET_ID = l_dimset_id
4114: AND PARENT_LEVEL_INDEX >= 0;
4115: --DBMS_OUTPUT.PUT_LINE('kpi_id :- '||l_kpi_id||'dimset_id :- '||l_dimset_id||'No of rels are :- '||l_no_rels );
4116: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
4117: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4120: FND_MSG_PUB.ADD;