APPS.BSC_BIS_DIMENSION_PUB dependencies on BIS_DIMENSION_PUB

Line 1: PACKAGE BODY BSC_BIS_DIMENSION_PUB AS

1: PACKAGE BODY BSC_BIS_DIMENSION_PUB AS
2: /* $Header: BSCGPMDB.pls 120.9 2007/08/02 13:39:22 psomesul ship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 132: p_dim_obj_objs_tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type

128: FUNCTION get_kpi_flag_change (
129: p_old_default IN VARCHAR2,
130: p_new_default IN VARCHAR2,
131: p_indicator IN bsc_kpis_b.indicator%TYPE,
132: p_dim_obj_objs_tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type
133: )
134: RETURN NUMBER;
135:
136: /*********************************************************************************/

Line 326: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag procedure');

322: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
323: WHERE Dim_Level_Id = l_Bsc_Dim_Obj_ID
324: AND Dim_Group_Id = l_Bsc_Group_ID;
325: BEGIN
326: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag procedure');
327: IF (c_Bis_Levels%ISOPEN) THEN
328: CLOSE c_Bis_Levels;
329: END IF;
330: OPEN c_Bis_Levels;

Line 335: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);

331: FETCH c_Bis_Levels
332: INTO l_Dim_Short_Name;
333: CLOSE c_Bis_Levels;
334:
335: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
336: l_Bsc_Dim_Obj_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
337:
338: IF (c_All_Pri_Flag%ISOPEN) THEN
339: CLOSE c_All_Pri_Flag;

Line 345: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag procedure');

341: OPEN c_All_Pri_Flag;
342: FETCH c_All_Pri_Flag INTO l_All_Flag;
343: CLOSE c_All_Pri_Flag;
344: RETURN NVL(l_All_Flag, -1);
345: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag procedure');
346: EXCEPTION
347: WHEN OTHERS THEN
348: RETURN -1;
349: END Get_Primary_All_Flag;

Line 392: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag procedure');

388: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
389: WHERE Dim_Group_Id = l_Bsc_Group_ID
390: AND Dim_Level_Id = l_Bsc_Level_ID;
391: BEGIN
392: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag procedure');
393: SAVEPOINT SyncPMFAllInPMD;
394: IF (BSC_BIS_DIM_OBJ_PUB.Get_Dim_Obj_Source(NULL, p_Dim_Obj_Short_Name) = 'PMF') THEN
395: l_Bsc_Level_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
396:

Line 406: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);

402: INTO l_Dim_Short_Name;
403: CLOSE c_Bis_Levels;
404:
405: --sync up all values
406: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
407: IF (c_Total_Flag%ISOPEN) THEN
408: CLOSE c_Total_Flag;
409: END IF;
410: OPEN c_Total_Flag;

Line 424: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag procedure');

420: COMMIT;
421: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');
422: END IF;
423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag procedure');
425: EXCEPTION
426: WHEN OTHERS THEN
427: ROLLBACK TO SyncPMFAllInPMD;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 430: x_msg_data := SQLERRM||' -> BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag ';

426: WHEN OTHERS THEN
427: ROLLBACK TO SyncPMFAllInPMD;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF (x_msg_data IS NULL) THEN
430: x_msg_data := SQLERRM||' -> BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag ';
431: END IF;
432: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
433: END Sync_All_Enable_Flag;
434: --=========================================================================================

Line 514: l_Old_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Old_Dim_Short_Name);

510: FETCH c_Bis_Levels
511: INTO l_Old_Dim_Short_Name;
512: CLOSE c_Bis_Levels;
513:
514: l_Old_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Old_Dim_Short_Name);
515:
516: l_Bsc_Level_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
517:
518:

Line 540: l_Dim_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;

536: OPEN c_Dim_Short_Name;
537: FETCH c_Dim_Short_Name INTO l_Dim_Short_Name;
538: CLOSE c_Dim_Short_Name;
539: ELSE
540: l_Dim_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;
541: END IF;
542: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(l_Dim_Short_Name);
543:
544: IF (c_Dim_Level_Info%ISOPEN) THEN

Line 542: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(l_Dim_Short_Name);

538: CLOSE c_Dim_Short_Name;
539: ELSE
540: l_Dim_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;
541: END IF;
542: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(l_Dim_Short_Name);
543:
544: IF (c_Dim_Level_Info%ISOPEN) THEN
545: CLOSE c_Dim_Level_Info;
546: END IF;

Line 610: x_msg_data := SQLERRM||' -> BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis ';

606: WHEN OTHERS THEN
607: ROLLBACK TO SyncPMFBSCDimsInPMD;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: IF (x_msg_data IS NULL) THEN
610: x_msg_data := SQLERRM||' -> BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis ';
611: END IF;
612:
613: END Sync_Dimensions_In_Bis;
614: /*********************************************************************************/

Line 616: ( p_MTab_Tbl IN BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type

612:
613: END Sync_Dimensions_In_Bis;
614: /*********************************************************************************/
615: PROCEDURE Delete_Dim_Objs_In_DSet
616: ( p_MTab_Tbl IN BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type
617: , x_return_status OUT NOCOPY VARCHAR2
618: , x_msg_count OUT NOCOPY NUMBER
619: , x_msg_data OUT NOCOPY VARCHAR2
620: ) IS

Line 638: ( p_MTab_Tbl IN BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type

634: END LOOP;
635: END Delete_Dim_Objs_In_DSet;
636: /*********************************************************************************/
637: PROCEDURE Create_Dim_Objs_In_DSet
638: ( p_MTab_Tbl IN BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type
639: , p_kpi_flag_change IN VARCHAR2 := NULL
640: , p_delete IN BOOLEAN := FALSE
641: , x_return_status OUT NOCOPY VARCHAR2
642: , x_msg_count OUT NOCOPY NUMBER

Line 671: ( p_MTab_Tbl IN BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type

667:
668: ***********************************************************************************/
669:
670: PROCEDURE Create_Dim_Objs_In_DSet
671: ( p_MTab_Tbl IN BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type
672: , p_delete IN BOOLEAN := FALSE
673: , p_old_default IN VARCHAR2
674: , p_new_default IN VARCHAR2
675: , p_dim_obj_short_name IN VARCHAR2

Line 676: , p_dim_obj_objs_tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type

672: , p_delete IN BOOLEAN := FALSE
673: , p_old_default IN VARCHAR2
674: , p_new_default IN VARCHAR2
675: , p_dim_obj_short_name IN VARCHAR2
676: , p_dim_obj_objs_tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type
677: , x_return_status OUT NOCOPY VARCHAR2
678: , x_msg_count OUT NOCOPY NUMBER
679: , x_msg_data OUT NOCOPY VARCHAR2
680: ) IS

Line 717: , x_MTab_Tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type

713: /*********************************************************************************/
714: PROCEDURE Store_Dim_Set_Records
715: ( p_dim_group_id IN NUMBER
716: , p_dim_short_name IN VARCHAR2
717: , x_MTab_Tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type
718: ) IS
719: CURSOR c_dim_set_kpi IS
720: SELECT DISTINCT A.indicator INDICATOR
721: , A.dim_set_id DIM_SET_ID

Line 744: x_dim_obj_objs_tbl OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type

740: /*********************************************************************************/
741:
742: PROCEDURE store_dim_obj_objectives (
743: p_dim_obj_short_name IN VARCHAR2,
744: x_dim_obj_objs_tbl OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type
745: ) IS
746: l_count NUMBER;
747: CURSOR c_dim_obj_objectives IS
748: SELECT a.indicator indicator, a.kpi_measure_id

Line 857: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';

853: WHEN NO_DATA_FOUND THEN
854: ROLLBACK TO CreateBSCDimensionPMD;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: IF (x_msg_data IS NOT NULL) THEN
857: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';
858: ELSE
859: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';
860: END IF;
861:

Line 859: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';

855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: IF (x_msg_data IS NOT NULL) THEN
857: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';
858: ELSE
859: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';
860: END IF;
861:
862: WHEN OTHERS THEN
863: ROLLBACK TO CreateBSCDimensionPMD;

Line 866: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';

862: WHEN OTHERS THEN
863: ROLLBACK TO CreateBSCDimensionPMD;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: IF (x_msg_data IS NOT NULL) THEN
866: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';
867: ELSE
868: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';
869: END IF;
870:

Line 868: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';

864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: IF (x_msg_data IS NOT NULL) THEN
866: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';
867: ELSE
868: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';
869: END IF;
870:
871: END Create_Dimension;
872:

Line 888: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

884: , x_return_status OUT NOCOPY VARCHAR2
885: , x_msg_count OUT NOCOPY NUMBER
886: , x_msg_data OUT NOCOPY VARCHAR2
887: ) IS
888: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
889: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
890: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
891:
892: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

Line 947: l_alias := BSC_BIS_DIMENSION_PUB.get_Next_Alias(l_alias);

943: IF (l_count = 0) THEN
944: l_flag := FALSE;
945: l_dim_short_name := l_temp_var;
946: END IF;
947: l_alias := BSC_BIS_DIMENSION_PUB.get_Next_Alias(l_alias);
948: l_temp_var := l_dim_short_name||l_alias;
949: END LOOP;
950: IF(p_application_id = -1 OR p_application_id IS NULL) THEN
951: l_application_id := 271;

Line 1128: BIS_DIMENSION_PUB.Create_Dimension

1124: l_bis_dimension_rec.Dimension_Name := l_pmf_disp_name;
1125: l_bis_dimension_rec.Description := p_description;
1126: l_bis_dimension_rec.Application_ID := l_application_id;
1127: l_bis_dimension_rec.Hide := p_hide;
1128: BIS_DIMENSION_PUB.Create_Dimension
1129: ( p_api_version => 1.0
1130: , p_commit => FND_API.G_FALSE
1131: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1132: , p_Dimension_Rec => l_bis_dimension_rec

Line 1149: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects

1145: END IF;
1146:
1147: END IF;
1148: IF (p_dim_obj_short_names IS NOT NULL) THEN
1149: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects
1150: ( p_commit => FND_API.G_FALSE
1151: , p_dim_short_name => l_dim_short_name
1152: , p_dim_obj_short_names => p_dim_obj_short_names
1153: , p_create_view => p_create_view

Line 1197: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';

1193: WHEN NO_DATA_FOUND THEN
1194: ROLLBACK TO CreateBSCDimensionPMD;
1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: IF (x_msg_data IS NOT NULL) THEN
1197: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';
1198: ELSE
1199: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';
1200: END IF;
1201:

Line 1199: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';

1195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1196: IF (x_msg_data IS NOT NULL) THEN
1197: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';
1198: ELSE
1199: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';
1200: END IF;
1201:
1202: WHEN OTHERS THEN
1203: ROLLBACK TO CreateBSCDimensionPMD;

Line 1206: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';

1202: WHEN OTHERS THEN
1203: ROLLBACK TO CreateBSCDimensionPMD;
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: IF (x_msg_data IS NOT NULL) THEN
1206: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';
1207: ELSE
1208: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';
1209: END IF;
1210:

Line 1208: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';

1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: IF (x_msg_data IS NOT NULL) THEN
1206: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Create_Dimension ';
1207: ELSE
1208: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Create_Dimension ';
1209: END IF;
1210:
1211: END Create_Dimension;
1212: /*********************************************************************************

Line 1233: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;

1229: l_All_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE;
1230:
1231: l_assigns VARCHAR2(32000);
1232: l_assign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
1233: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
1234: l_MTab_DimRels1 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1235: l_MTab_DimRels2 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1236:
1237: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;

Line 1234: l_MTab_DimRels1 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;

1230:
1231: l_assigns VARCHAR2(32000);
1232: l_assign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
1233: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
1234: l_MTab_DimRels1 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1235: l_MTab_DimRels2 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1236:
1237: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
1238: l_count NUMBER;

Line 1235: l_MTab_DimRels2 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;

1231: l_assigns VARCHAR2(32000);
1232: l_assign BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
1233: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
1234: l_MTab_DimRels1 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1235: l_MTab_DimRels2 BSC_BIS_DIMENSION_PUB.Dim_Obj_Table_Type;
1236:
1237: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
1238: l_count NUMBER;
1239: l_count1 NUMBER;

Line 1308: BSC_BIS_DIMENSION_PUB.Store_Dim_Set_Records

1304: END IF;
1305: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: END IF;
1308: BSC_BIS_DIMENSION_PUB.Store_Dim_Set_Records
1309: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
1310: , p_dim_short_name => p_dim_short_name
1311: , x_MTab_Tbl => l_MTab_Tbl
1312: );

Line 1313: BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet

1309: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
1310: , p_dim_short_name => p_dim_short_name
1311: , x_MTab_Tbl => l_MTab_Tbl
1312: );
1313: BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet
1314: ( p_MTab_Tbl => l_MTab_Tbl
1315: , x_return_status => x_return_status
1316: , x_msg_count => x_msg_count
1317: , x_msg_data => x_msg_data

Line 1338: IF (NOT BSC_BIS_DIMENSION_PUB.is_Relation_Exists(l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id, l_dim_level_id)) THEN

1334: FND_MSG_PUB.ADD;
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337:
1338: IF (NOT BSC_BIS_DIMENSION_PUB.is_Relation_Exists(l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id, l_dim_level_id)) THEN
1339: l_struct_change := TRUE;
1340:
1341: IF (l_Source_Type = 'BSC') THEN
1342: l_All_Flag := -1;

Line 1345: l_All_Flag := BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag(l_dim_obj_name);

1341: IF (l_Source_Type = 'BSC') THEN
1342: l_All_Flag := -1;
1343:
1344: ELSE
1345: l_All_Flag := BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag(l_dim_obj_name);
1346:
1347: END IF;
1348: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object
1349: ( p_commit => FND_API.G_FALSE

Line 1348: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object

1344: ELSE
1345: l_All_Flag := BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag(l_dim_obj_name);
1346:
1347: END IF;
1348: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object
1349: ( p_commit => FND_API.G_FALSE
1350: , p_dim_short_name => p_dim_short_name
1351: , p_dim_obj_short_name => l_dim_obj_name
1352: , p_comp_flag => -111 -- this value is acting like a flag

Line 1446: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet

1442: END IF;
1443: l_tab_index := l_tab_index + 1;
1444: END LOOP;
1445: IF (l_struct_change) THEN
1446: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet
1447: ( p_MTab_Tbl => l_MTab_Tbl
1448: , x_return_status => x_return_status
1449: , x_msg_count => x_msg_count
1450: , x_msg_data => x_msg_data

Line 1453: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet

1449: , x_msg_count => x_msg_count
1450: , x_msg_data => x_msg_data
1451: );
1452: ELSE
1453: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet
1454: ( p_MTab_Tbl => l_MTab_Tbl
1455: , p_kpi_flag_change => BSC_DESIGNER_PVT.G_ActionFlag.Normal
1456: , x_return_status => x_return_status
1457: , x_msg_count => x_msg_count

Line 1492: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';

1488:
1489: WHEN NO_DATA_FOUND THEN
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1491: IF (x_msg_data IS NOT NULL) THEN
1492: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';
1493: ELSE
1494: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';
1495: END IF;
1496:

Line 1494: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';

1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1491: IF (x_msg_data IS NOT NULL) THEN
1492: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';
1493: ELSE
1494: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';
1495: END IF;
1496:
1497: WHEN OTHERS THEN
1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1500: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';

1496:
1497: WHEN OTHERS THEN
1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1499: IF (x_msg_data IS NOT NULL) THEN
1500: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';
1501: ELSE
1502: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';
1503: END IF;
1504:

Line 1502: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';

1498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1499: IF (x_msg_data IS NOT NULL) THEN
1500: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';
1501: ELSE
1502: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects ';
1503: END IF;
1504:
1505: END Assign_Dimension_Objects;
1506: /*********************************************************************************

Line 1528: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;

1524: ) IS
1525: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
1526: l_dim_lvl_name VARCHAR2(400);
1527: l_default VARCHAR2(3);
1528: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
1529: l_dim_obj_objs_tbl BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type;
1530: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1531: l_count NUMBER;
1532: l_comp_count NUMBER;

Line 1529: l_dim_obj_objs_tbl BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type;

1525: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
1526: l_dim_lvl_name VARCHAR2(400);
1527: l_default VARCHAR2(3);
1528: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
1529: l_dim_obj_objs_tbl BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type;
1530: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1531: l_count NUMBER;
1532: l_comp_count NUMBER;
1533:

Line 1696: IF NOT (BSC_BIS_DIMENSION_PUB.Attmpt_Recr_View(

1692: END IF;
1693: -- Can test with 'LEGAL ENTITY', 'EDW_HR_PERM_SPSR1_L9'
1694: l_Rolling_Period := BIS_UTILITIES_PVT.Is_Rolling_Period_Level(p_dim_obj_short_name);
1695: IF (p_create_view = 1 AND l_Rolling_Period = 0) THEN
1696: IF NOT (BSC_BIS_DIMENSION_PUB.Attmpt_Recr_View(
1697: p_dim_lvl_shrt_name => p_dim_obj_short_name
1698: , x_dim_lvl_name => l_dim_lvl_name)) THEN
1699: FND_MESSAGE.SET_NAME('BSC','BSC_UNAVAILABLE_LEVEL');
1700: FND_MESSAGE.SET_TOKEN('BSC_LEVEL', l_dim_lvl_name, TRUE);

Line 1725: BSC_BIS_DIMENSION_PUB.Store_Dim_Set_Records

1721: IF (p_comp_flag IS NOT NULL) AND (p_comp_flag = -111) THEN
1722: l_do_not_cascade := FALSE;
1723: END IF;
1724: IF (l_do_not_cascade) THEN
1725: BSC_BIS_DIMENSION_PUB.Store_Dim_Set_Records
1726: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
1727: , p_dim_short_name => p_dim_short_name
1728: , x_MTab_Tbl => l_MTab_Tbl
1729: );

Line 1735: BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet

1731: store_dim_obj_objectives
1732: ( p_dim_obj_short_name => p_dim_obj_short_name
1733: , x_dim_obj_objs_tbl => l_dim_obj_objs_tbl
1734: );
1735: BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet
1736: ( p_MTab_Tbl => l_MTab_Tbl
1737: , x_return_status => x_return_status
1738: , x_msg_count => x_msg_count
1739: , x_msg_data => x_msg_data

Line 1742: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists

1738: , x_msg_count => x_msg_count
1739: , x_msg_data => x_msg_data
1740: );
1741: END IF;
1742: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists
1743: (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id, l_bsc_dimension_rec.Bsc_Level_Id)) THEN
1744: l_bsc_dimension_rec.Bsc_Dim_Level_Index := NULL;
1745:
1746: -- START Added by Aditya for Incremental Changes

Line 1780: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet

1776: , x_msg_count => x_msg_count
1777: , x_msg_data => x_msg_data
1778: );
1779: /*IF (p_default_value <> l_default) THEN
1780: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet
1781: ( p_MTab_Tbl => l_MTab_Tbl
1782: , p_kpi_flag_change => BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color
1783: , x_return_status => x_return_status
1784: , x_msg_count => x_msg_count

Line 1790: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet

1786: );
1787:
1788: ----DEBUG('4..'||get_default_value());
1789: ELSE
1790: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet
1791: ( p_MTab_Tbl => l_MTab_Tbl
1792: , p_kpi_flag_change => BSC_DESIGNER_PVT.G_ActionFlag.Normal
1793: , x_return_status => x_return_status
1794: , x_msg_count => x_msg_count

Line 1802: l_Dim_Grp_Id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);

1798: END IF;*/
1799: END IF;
1800: ELSE
1801: --if Dimension is already assigned to "UNASSIGNED" Dimension
1802: l_Dim_Grp_Id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);
1803: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists(l_Dim_Grp_Id, l_bsc_dimension_rec.Bsc_Level_Id)) THEN
1804:
1805: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
1806: SET Dim_Group_ID = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id

Line 1803: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists(l_Dim_Grp_Id, l_bsc_dimension_rec.Bsc_Level_Id)) THEN

1799: END IF;
1800: ELSE
1801: --if Dimension is already assigned to "UNASSIGNED" Dimension
1802: l_Dim_Grp_Id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);
1803: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists(l_Dim_Grp_Id, l_bsc_dimension_rec.Bsc_Level_Id)) THEN
1804:
1805: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
1806: SET Dim_Group_ID = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
1807: WHERE Dim_Level_ID = l_bsc_dimension_rec.Bsc_Level_Id

Line 1824: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet

1820: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END IF;
1823: IF (l_do_not_cascade) THEN
1824: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet
1825: ( p_MTab_Tbl => l_MTab_Tbl
1826: , x_return_status => x_return_status
1827: , x_msg_count => x_msg_count
1828: , x_msg_data => x_msg_data

Line 1834: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis

1830: ----DEBUG('8..'||get_default_value());
1831: END IF;
1832: END IF;
1833: --sync up with BIS Dimensions
1834: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis
1835: ( p_commit => FND_API.G_FALSE
1836: , p_Dim_Obj_Short_Name => p_dim_obj_short_name
1837: , p_Sync_Flag => TRUE
1838: , x_return_status => x_return_status

Line 1881: IF (p_dim_short_name IS NOT NULL AND p_dim_short_name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN

1877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1878: END IF;
1879: END IF;
1880:
1881: IF (p_dim_short_name IS NOT NULL AND p_dim_short_name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
1882: -- Bug 4997042
1883: BSC_BIS_DIM_OBJ_PUB.Cascade_Dim_Props_Into_Dim_Grp (
1884: p_Dim_Obj_Short_Name => p_dim_obj_short_name
1885: , p_Dim_Short_Name => p_dim_short_name

Line 1989: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';

1985: END IF;
1986: ROLLBACK TO AssBSCDimObjectPMD;
1987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1988: IF (x_msg_data IS NOT NULL) THEN
1989: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';
1990: ELSE
1991: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';
1992: END IF;
1993:

Line 1991: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';

1987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1988: IF (x_msg_data IS NOT NULL) THEN
1989: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';
1990: ELSE
1991: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';
1992: END IF;
1993:
1994: WHEN OTHERS THEN
1995: IF (cr_bsc_dim_id%ISOPEN) THEN

Line 2007: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';

2003: END IF;
2004: ROLLBACK TO AssBSCDimObjectPMD;
2005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2006: IF (x_msg_data IS NOT NULL) THEN
2007: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';
2008: ELSE
2009: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';
2010: END IF;
2011:

Line 2009: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';

2005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2006: IF (x_msg_data IS NOT NULL) THEN
2007: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';
2008: ELSE
2009: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object ';
2010: END IF;
2011:
2012: END Assign_Dimension_Object;
2013:

Line 2032: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;

2028: l_Dim_Grp_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
2029: l_Source_Type BSC_SYS_DIM_LEVELS_B.Source%TYPE;
2030: l_dim_obj_names VARCHAR2(32000);
2031: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2032: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
2033: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;
2034: l_kpi_cascade BOOLEAN := FALSE;
2035: l_count NUMBER;
2036: -- START Granular Locking Declaration added by Aditya

Line 2058: IF (p_dim_short_name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN

2054: WHERE Dimension_Id = l_Bis_Group_ID;
2055: BEGIN
2056: SAVEPOINT UnAssBSCDimObjectPMD;
2057:
2058: IF (p_dim_short_name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
2059: FND_MSG_PUB.Initialize;
2060: x_return_status := FND_API.G_RET_STS_SUCCESS;
2061: IF (p_dim_short_name IS NULL) THEN
2062: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

Line 2105: l_Source_Type := NVL(BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(p_dim_short_name), 'BSC');

2101: END IF;
2102: END IF;
2103: -- End Granular Locking
2104: IF (p_dim_obj_short_names IS NOT NULL) THEN
2105: l_Source_Type := NVL(BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(p_dim_short_name), 'BSC');
2106: /* -- Changed the position because must to go at the final when the metadata had
2107: -- been updated
2108: BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply
2109: ( p_Tab_Id => NULL

Line 2117: BSC_BIS_DIMENSION_PUB.Store_Dim_Set_Records

2113: );
2114: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2116: END IF;*/
2117: BSC_BIS_DIMENSION_PUB.Store_Dim_Set_Records
2118: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
2119: , p_dim_short_name => p_dim_short_name
2120: , x_MTab_Tbl => l_MTab_Tbl
2121: );

Line 2122: BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet

2118: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
2119: , p_dim_short_name => p_dim_short_name
2120: , x_MTab_Tbl => l_MTab_Tbl
2121: );
2122: BSC_BIS_DIMENSION_PUB.Delete_Dim_Objs_In_DSet
2123: ( p_MTab_Tbl => l_MTab_Tbl
2124: , x_return_status => x_return_status
2125: , x_msg_count => x_msg_count
2126: , x_msg_data => x_msg_data

Line 2145: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists

2141: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);
2142: FND_MSG_PUB.ADD;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END IF;
2145: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists
2146: (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id, l_bsc_dimension_rec.Bsc_Level_Id)) THEN
2147: l_kpi_cascade := TRUE;
2148: IF (l_Dim_Obj_Source = 'PMF') THEN
2149: IF (BSC_BIS_DIMENSION_PUB.Get_Number_Of_Dimensions(l_bsc_dimension_rec.Bsc_Level_Id) = 1) THEN

Line 2149: IF (BSC_BIS_DIMENSION_PUB.Get_Number_Of_Dimensions(l_bsc_dimension_rec.Bsc_Level_Id) = 1) THEN

2145: IF (BSC_BIS_DIMENSION_PUB.is_Relation_Exists
2146: (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id, l_bsc_dimension_rec.Bsc_Level_Id)) THEN
2147: l_kpi_cascade := TRUE;
2148: IF (l_Dim_Obj_Source = 'PMF') THEN
2149: IF (BSC_BIS_DIMENSION_PUB.Get_Number_Of_Dimensions(l_bsc_dimension_rec.Bsc_Level_Id) = 1) THEN
2150: l_Dim_Grp_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);
2151: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
2152: SET Dim_Group_Id = l_Dim_Grp_ID
2153: WHERE Dim_Group_Id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id

Line 2150: l_Dim_Grp_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);

2146: (l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id, l_bsc_dimension_rec.Bsc_Level_Id)) THEN
2147: l_kpi_cascade := TRUE;
2148: IF (l_Dim_Obj_Source = 'PMF') THEN
2149: IF (BSC_BIS_DIMENSION_PUB.Get_Number_Of_Dimensions(l_bsc_dimension_rec.Bsc_Level_Id) = 1) THEN
2150: l_Dim_Grp_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);
2151: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
2152: SET Dim_Group_Id = l_Dim_Grp_ID
2153: WHERE Dim_Group_Id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
2154: AND Dim_Level_Id = l_bsc_dimension_rec.Bsc_Level_Id;

Line 2158: (BSC_BIS_DIMENSION_PUB.Get_Number_Of_Dimensions(l_bsc_dimension_rec.Bsc_Level_Id) <> 1)) THEN

2154: AND Dim_Level_Id = l_bsc_dimension_rec.Bsc_Level_Id;
2155: END IF;
2156: END IF;
2157: IF ((l_Dim_Obj_Source = 'BSC') OR
2158: (BSC_BIS_DIMENSION_PUB.Get_Number_Of_Dimensions(l_bsc_dimension_rec.Bsc_Level_Id) <> 1)) THEN
2159: BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group
2160: ( p_commit => FND_API.G_FALSE
2161: , p_Dim_Grp_Rec => l_bsc_dimension_rec
2162: , x_return_status => x_return_status

Line 2174: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet

2170: END IF;
2171: END LOOP;
2172: --Update BSC_KPI_DIM_LEVELS_B with the current status
2173: IF (l_kpi_cascade) THEN
2174: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet
2175: ( p_MTab_Tbl => l_MTab_Tbl
2176: , x_return_status => x_return_status
2177: , x_msg_count => x_msg_count
2178: , x_msg_data => x_msg_data

Line 2181: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet

2177: , x_msg_count => x_msg_count
2178: , x_msg_data => x_msg_data
2179: );
2180: ELSE
2181: BSC_BIS_DIMENSION_PUB.Create_Dim_Objs_In_DSet
2182: ( p_MTab_Tbl => l_MTab_Tbl
2183: , p_kpi_flag_change => BSC_DESIGNER_PVT.G_ActionFlag.Normal
2184: , x_return_status => x_return_status
2185: , x_msg_count => x_msg_count

Line 2190: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(p_dim_short_name);

2186: , x_msg_data => x_msg_data
2187: );
2188: END IF;
2189: --sync up Dimensions in BIS
2190: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(p_dim_short_name);
2191: FOR cd IN cr_bis_dim_ids LOOP
2192: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis
2193: ( p_commit => FND_API.G_FALSE
2194: , p_Dim_Obj_Short_Name => cd.Short_Name

Line 2192: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis

2188: END IF;
2189: --sync up Dimensions in BIS
2190: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(p_dim_short_name);
2191: FOR cd IN cr_bis_dim_ids LOOP
2192: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis
2193: ( p_commit => FND_API.G_FALSE
2194: , p_Dim_Obj_Short_Name => cd.Short_Name
2195: , p_Sync_Flag => TRUE
2196: , x_return_status => x_return_status

Line 2277: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';

2273: END IF;
2274: ROLLBACK TO UnAssBSCDimObjectPMD;
2275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2276: IF (x_msg_data IS NOT NULL) THEN
2277: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';
2278: ELSE
2279: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';
2280: END IF;
2281:

Line 2279: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';

2275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2276: IF (x_msg_data IS NOT NULL) THEN
2277: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';
2278: ELSE
2279: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';
2280: END IF;
2281:
2282: WHEN OTHERS THEN
2283: IF (cr_bsc_dimension_id%ISOPEN) THEN

Line 2292: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';

2288: END IF;
2289: ROLLBACK TO UnAssBSCDimObjectPMD;
2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2291: IF (x_msg_data IS NOT NULL) THEN
2292: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';
2293: ELSE
2294: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';
2295: END IF;
2296:

Line 2294: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';

2290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2291: IF (x_msg_data IS NOT NULL) THEN
2292: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';
2293: ELSE
2294: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects ';
2295: END IF;
2296:
2297: END UnAssign_Dimension_Objects;
2298:

Line 2434: BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects

2430: END IF;
2431: END LOOP;
2432: IF (l_unassign_dim_objs IS NOT NULL) THEN
2433:
2434: BSC_BIS_DIMENSION_PUB.UnAssign_Dimension_Objects
2435: ( p_commit => FND_API.G_FALSE
2436: , p_dim_short_name => p_dim_short_name
2437: , p_dim_obj_short_names => l_unassign_dim_objs
2438: , p_time_stamp => p_time_stamp -- Granular Locking

Line 2462: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects

2458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2459: END IF;
2460: END IF;
2461: IF (p_assign_dim_obj_names IS NOT NULL) THEN
2462: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects
2463: ( p_commit => FND_API.G_FALSE
2464: , p_dim_short_name => p_dim_short_name
2465: , p_dim_obj_short_names => p_assign_dim_obj_names
2466: , p_time_stamp => p_time_stamp -- Granular Locking

Line 2477: BSC_BIS_DIMENSION_PUB.Remove_Empty_Dims_For_DimSet

2473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2474: END IF;
2475: END IF;
2476: -- Bug 3784852 validate empty dimension after unassign dim objs and remove those from dim sets for all objectives
2477: BSC_BIS_DIMENSION_PUB.Remove_Empty_Dims_For_DimSet
2478: ( p_commit => FND_API.G_FALSE
2479: , p_dim_short_names => p_dim_short_name
2480: , p_time_stamp => p_time_stamp -- Granular Locking
2481: , x_return_status => x_return_status

Line 2518: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';

2514:
2515: WHEN NO_DATA_FOUND THEN
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2517: IF (x_msg_data IS NOT NULL) THEN
2518: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';
2519: ELSE
2520: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';
2521: END IF;
2522:

Line 2520: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';

2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2517: IF (x_msg_data IS NOT NULL) THEN
2518: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';
2519: ELSE
2520: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';
2521: END IF;
2522:
2523: WHEN OTHERS THEN
2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2526: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';

2522:
2523: WHEN OTHERS THEN
2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2525: IF (x_msg_data IS NOT NULL) THEN
2526: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';
2527: ELSE
2528: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';
2529: END IF;
2530:

Line 2528: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';

2524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2525: IF (x_msg_data IS NOT NULL) THEN
2526: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';
2527: ELSE
2528: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs ';
2529: END IF;
2530:
2531: END Assign_Unassign_Dim_Objs;
2532: /*********************************************************************************

Line 2547: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

2543: , x_return_status OUT NOCOPY VARCHAR2
2544: , x_msg_count OUT NOCOPY NUMBER
2545: , x_msg_data OUT NOCOPY VARCHAR2
2546: )IS
2547: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
2548: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2549: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
2550: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2551: l_application_id BIS_DIMENSIONS.Application_Id%TYPE;

Line 2656: BIS_DIMENSION_PUB.Create_Dimension

2652: l_bis_dimension_rec.Description := p_description;
2653:
2654: l_bis_dimension_rec.Hide := p_Hide;
2655:
2656: BIS_DIMENSION_PUB.Create_Dimension
2657: ( p_api_version => 1.0
2658: , p_commit => FND_API.G_FALSE
2659: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2660: , p_Dimension_Rec => l_bis_dimension_rec

Line 2688: BIS_DIMENSION_PUB.Update_Dimension

2684: l_bis_dimension_rec.Description := p_description;
2685:
2686: l_bis_dimension_rec.Hide := p_Hide;
2687:
2688: BIS_DIMENSION_PUB.Update_Dimension
2689: ( p_api_version => 1.0
2690: , p_commit => FND_API.G_FALSE
2691: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2692: , p_Dimension_Rec => l_bis_dimension_rec

Line 2816: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

2812: END IF;
2813: ROLLBACK TO UpdateBSCDimensionPMD;
2814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2815: IF (x_msg_data IS NOT NULL) THEN
2816: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
2817: ELSE
2818: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
2819: END IF;
2820:

Line 2818: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

2814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2815: IF (x_msg_data IS NOT NULL) THEN
2816: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
2817: ELSE
2818: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
2819: END IF;
2820:
2821: WHEN OTHERS THEN
2822: IF (cr_bis_dim_id%ISOPEN) THEN

Line 2831: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

2827: END IF;
2828: ROLLBACK TO UpdateBSCDimensionPMD;
2829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2830: IF (x_msg_data IS NOT NULL) THEN
2831: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
2832: ELSE
2833: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
2834: END IF;
2835:

Line 2833: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

2829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2830: IF (x_msg_data IS NOT NULL) THEN
2831: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
2832: ELSE
2833: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
2834: END IF;
2835:
2836: END Update_Dimension;
2837:

Line 2988: BSC_BIS_DIMENSION_PUB.Update_Dimension

2984: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2986: END IF;
2987: -- End Granular Locking
2988: BSC_BIS_DIMENSION_PUB.Update_Dimension
2989: ( p_commit => FND_API.G_FALSE
2990: , p_dim_short_name => p_dim_short_name
2991: , p_display_name => p_display_name
2992: , p_description => p_description

Line 3003: BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs

2999: );
3000: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3002: END IF;
3003: BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs
3004: ( p_commit => FND_API.G_FALSE
3005: , p_dim_short_name => p_dim_short_name
3006: , p_assign_dim_obj_names => p_assign_dim_obj_names
3007: , p_unassign_dim_obj_names => p_unassign_dim_obj_names

Line 3077: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

3073: CLOSE cr_bsc_dim_id;
3074: END IF;
3075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3076: IF (x_msg_data IS NOT NULL) THEN
3077: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3078: ELSE
3079: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3080: END IF;
3081:

Line 3079: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

3075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3076: IF (x_msg_data IS NOT NULL) THEN
3077: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3078: ELSE
3079: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3080: END IF;
3081:
3082: WHEN OTHERS THEN
3083: IF (cr_bsc_dim_id%ISOPEN) THEN

Line 3088: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

3084: CLOSE cr_bsc_dim_id;
3085: END IF;
3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3087: IF (x_msg_data IS NOT NULL) THEN
3088: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3089: ELSE
3090: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3091: END IF;
3092:

Line 3090: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3087: IF (x_msg_data IS NOT NULL) THEN
3088: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3089: ELSE
3090: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3091: END IF;
3092:
3093: END Update_Dimension;
3094:

Line 3185: BSC_BIS_DIMENSION_PUB.Update_Dimension

3181: ELSE
3182: l_unassign_dim_obj_names := l_unassign_dim_obj_names||', '||cd.short_name;
3183: END IF;
3184: END LOOP;
3185: BSC_BIS_DIMENSION_PUB.Update_Dimension
3186: ( p_commit => FND_API.G_FALSE
3187: , p_dim_short_name => p_dim_short_name
3188: , p_display_name => p_display_name
3189: , p_description => p_description

Line 3287: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

3283: CLOSE cr_bsc_dim_id;
3284: END IF;
3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3286: IF (x_msg_data IS NOT NULL) THEN
3287: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3288: ELSE
3289: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3290: END IF;
3291:

Line 3289: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3286: IF (x_msg_data IS NOT NULL) THEN
3287: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3288: ELSE
3289: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3290: END IF;
3291:
3292: WHEN OTHERS THEN
3293: IF (cr_bsc_dim_id%ISOPEN) THEN

Line 3298: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';

3294: CLOSE cr_bsc_dim_id;
3295: END IF;
3296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3297: IF (x_msg_data IS NOT NULL) THEN
3298: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3299: ELSE
3300: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3301: END IF;
3302:

Line 3300: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';

3296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3297: IF (x_msg_data IS NOT NULL) THEN
3298: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3299: ELSE
3300: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Update_Dimension ';
3301: END IF;
3302:
3303: END Update_Dimension;
3304: /*********************************************************************************

Line 3316: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

3312: , x_msg_data OUT NOCOPY VARCHAR2
3313: ) IS
3314:
3315: l_delete BOOLEAN := TRUE;
3316: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
3317: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3318: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
3319: l_Dim_Obj_Short_Name BIS_LEVELS.Short_Name%TYPE;
3320: l_count NUMBER;

Line 3353: IF (p_dim_short_name = BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN

3349: FND_MSG_PUB.ADD;
3350: RAISE FND_API.G_EXC_ERROR;
3351: END IF;
3352: --UNASSIGNED group can't be deleted
3353: IF (p_dim_short_name = BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
3354: FND_MESSAGE.SET_NAME('BSC','BSC_B_CAN_NOT_DELETE_GROUP');
3355: FND_MSG_PUB.ADD;
3356: RAISE FND_API.G_EXC_ERROR;
3357: END IF;

Line 3372: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(p_dim_short_name);

3368: END IF;
3369: CLOSE cr_bis_dim_short_name;
3370:
3371: --sync up Dimensions in BIS
3372: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(p_dim_short_name);
3373: FOR cd IN cr_bis_dim_ids LOOP
3374: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis
3375: ( p_commit => FND_API.G_FALSE
3376: , p_Dim_Obj_Short_Name => cd.Short_Name

Line 3374: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis

3370:
3371: --sync up Dimensions in BIS
3372: l_Bis_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bis_Dimension_ID(p_dim_short_name);
3373: FOR cd IN cr_bis_dim_ids LOOP
3374: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis
3375: ( p_commit => FND_API.G_FALSE
3376: , p_Dim_Obj_Short_Name => cd.Short_Name
3377: , p_Sync_Flag => FALSE
3378: , x_return_status => x_return_status

Line 3400: BIS_DIMENSION_PUB.Delete_Dimension

3396: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bis_dimension_rec.Dimension_Name);
3397: FND_MSG_PUB.ADD;
3398: RAISE FND_API.G_EXC_ERROR;
3399: END IF;
3400: BIS_DIMENSION_PUB.Delete_Dimension
3401: ( p_commit => FND_API.G_FALSE
3402: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3403: , p_Dimension_Rec => l_bis_dimension_rec
3404: , x_return_status => x_return_status

Line 3550: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Delete_Dimension ';

3546: END IF;
3547: ROLLBACK TO DeleteBSCDimensionsPMD;
3548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3549: IF (x_msg_data IS NOT NULL) THEN
3550: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Delete_Dimension ';
3551: ELSE
3552: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Delete_Dimension ';
3553: END IF;
3554:

Line 3552: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Delete_Dimension ';

3548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3549: IF (x_msg_data IS NOT NULL) THEN
3550: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Delete_Dimension ';
3551: ELSE
3552: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Delete_Dimension ';
3553: END IF;
3554:
3555: WHEN OTHERS THEN
3556: IF (cr_bis_dim_short_name%ISOPEN) THEN

Line 3565: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Delete_Dimension ';

3561: END IF;
3562: ROLLBACK TO DeleteBSCDimensionsPMD;
3563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3564: IF (x_msg_data IS NOT NULL) THEN
3565: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Delete_Dimension ';
3566: ELSE
3567: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Delete_Dimension ';
3568: END IF;
3569:

Line 3567: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Delete_Dimension ';

3563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3564: IF (x_msg_data IS NOT NULL) THEN
3565: x_msg_data := x_msg_data||' -> BSC_BIS_DIMENSION_PUB.Delete_Dimension ';
3566: ELSE
3567: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Delete_Dimension ';
3568: END IF;
3569:
3570: END Delete_Dimension;
3571: /*******************************************************************************

Line 3618: ELSIF (BSC_BIS_DIMENSION_PUB.Unassigned_Dim = p_short_Name) THEN

3614: AND TL.Short_Name = p_short_Name;
3615: BEGIN
3616: IF (p_short_Name IS NULL) THEN
3617: RETURN NULL;
3618: ELSIF (BSC_BIS_DIMENSION_PUB.Unassigned_Dim = p_short_Name) THEN
3619: RETURN 'PMF';
3620: ELSE
3621: IF (c_Dim_Obj_Data_Source%ISOPEN) THEN
3622: CLOSE c_Dim_Obj_Data_Source;

Line 3694: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Get_Lvl_Dtls ';

3690: EXCEPTION
3691: WHEN OTHERS THEN
3692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3693: IF (x_msg_data IS NULL) THEN
3694: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Get_Lvl_Dtls ';
3695: END IF;
3696: END Get_Lvl_Dtls;
3697: /*******************************************************************************
3698: ********************************************************************************/

Line 3737: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Get_Spec_Edw_Dtls ';

3733: EXCEPTION
3734: WHEN OTHERS THEN
3735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3736: IF (x_msg_data IS NULL) THEN
3737: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Get_Spec_Edw_Dtls ';
3738: END IF;
3739: END Get_Spec_Edw_Dtls;
3740: /*******************************************************************************
3741: ********************************************************************************/

Line 3784: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Get_Gene_Edw_Dtls ';

3780: CLOSE dl_value;
3781: END IF;
3782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3783: IF (x_msg_data IS NULL) THEN
3784: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Get_Gene_Edw_Dtls ';
3785: END IF;
3786: END Get_Gene_Edw_Dtls;
3787:
3788: /***************************************************************************

Line 4348: l_dim_group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_dim_short_name);

4344: WHILE (is_more(p_dim_obj_short_names => l_dim_short_names
4345: , p_dim_obj_name => l_dim_short_name )
4346: ) LOOP
4347:
4348: l_dim_group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_dim_short_name);
4349:
4350: SELECT count(dim_level_id) into l_count
4351: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
4352: WHERE dim_group_id = l_dim_group_id;

Line 4398: l_dim_group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_dim_short_name);

4394: WHILE (is_more( p_dim_obj_short_names => l_dim_short_names
4395: , p_dim_obj_name => l_dim_short_name )
4396: ) LOOP
4397:
4398: l_dim_group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_dim_short_name);
4399:
4400:
4401:
4402:

Line 4403: l_dim_name:= BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_Name(l_dim_short_name);

4399:
4400:
4401:
4402:
4403: l_dim_name:= BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_Name(l_dim_short_name);
4404:
4405:
4406:
4407: SELECT count(dim_level_id) into l_count

Line 4411: IF ((l_count =1) AND (BSC_BIS_DIMENSION_PUB.Is_Dimension_in_Ind( l_dim_group_id))) THEN

4407: SELECT count(dim_level_id) into l_count
4408: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
4409: WHERE dim_group_id = l_dim_group_id;
4410:
4411: IF ((l_count =1) AND (BSC_BIS_DIMENSION_PUB.Is_Dimension_in_Ind( l_dim_group_id))) THEN
4412:
4413:
4414: l_return_value:= l_return_value||l_dim_name||',';
4415: END IF;

Line 4428: Called in: 1.) BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs 2.) BSC_BIS_DIM_OBJ_PUB.Assign_Unassign_Dimensions

4424:
4425: END Dim_With_Single_Dim_Obj;
4426: /**************************************************************************************************************
4427: Summry: Check the passing list of dimensions, cascading remove empty BSC dimension from dim set
4428: Called in: 1.) BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs 2.) BSC_BIS_DIM_OBJ_PUB.Assign_Unassign_Dimensions
4429: ****************************************************************************************************************/
4430: PROCEDURE Remove_Empty_Dims_For_DimSet
4431: ( p_commit IN VARCHAR2 := FND_API.G_FALSE -- mdamle 06/06/2005 - Set default p_commit to false for dim. group apis called from EO
4432: , p_dim_short_names IN VARCHAR2

Line 4470: l_source :=BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(l_dim_short_name);

4466: -- For each dimension
4467: WHILE (is_more(p_dim_obj_short_names => l_dim_short_names
4468: , p_dim_obj_name => l_dim_short_name )
4469: ) LOOP
4470: l_source :=BSC_BIS_DIMENSION_PUB.Get_Dimension_Source(l_dim_short_name);
4471:
4472:
4473: -- check if it is bsc dimension
4474: IF ( l_source= 'BSC' or l_source is NULL) THEN --only need to unassign dimension from dim set for BSC

Line 4476: l_dim_group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_dim_short_name);

4472:
4473: -- check if it is bsc dimension
4474: IF ( l_source= 'BSC' or l_source is NULL) THEN --only need to unassign dimension from dim set for BSC
4475:
4476: l_dim_group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_dim_short_name);
4477:
4478:
4479: -- check if empty dimension
4480: SELECT count(dim_level_id) into l_count

Line 4559: IF ((p_dim_short_name = BSC_BIS_DIMENSION_PUB.Unassigned_Dim) AND

4555: l_dim_obj_name := CD.NAME;
4556: IF(l_source IS NULL) THEN
4557: l_source := CD.source;
4558: END IF;
4559: IF ((p_dim_short_name = BSC_BIS_DIMENSION_PUB.Unassigned_Dim) AND
4560: (l_source = 'BSC')) THEN
4561:
4562: EXIT;
4563: END IF;

Line 4592: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.is_Valid_Dim_Grp_Rels ';

4588: EXCEPTION
4589: WHEN OTHERS THEN
4590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4591: IF (x_msg_data IS NULL) THEN
4592: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.is_Valid_Dim_Grp_Rels ';
4593: END IF;
4594:
4595: RETURN l_true;
4596: END check_sametype_dimobjs ;

Line 4678: p_dim_obj_objs_tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type

4674: FUNCTION get_kpi_flag_change (
4675: p_old_default IN VARCHAR2,
4676: p_new_default IN VARCHAR2,
4677: p_indicator IN bsc_kpis_b.indicator%TYPE,
4678: p_dim_obj_objs_tbl IN OUT NOCOPY BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type
4679: )
4680: RETURN NUMBER IS
4681:
4682: l_color_change NUMBER;

Line 4722: END BSC_BIS_DIMENSION_PUB;

4718:
4719: RETURN l_result;
4720:
4721: END get_kpi_flag_change;
4722: END BSC_BIS_DIMENSION_PUB;