[Home] [Help]
1496: CLOSE c_bsc_dim_objs;
1497: END IF;
1498: ROLLBACK TO BscSyncDimeObjects;
1499: IF (x_error_msg IS NOT NULL) THEN
1500: x_error_msg := x_error_msg||' -> BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';
1501: ELSE
1502: x_error_msg := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';
1503: END IF;
1504: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_error_msg);
1498: ROLLBACK TO BscSyncDimeObjects;
1499: IF (x_error_msg IS NOT NULL) THEN
1500: x_error_msg := x_error_msg||' -> BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';
1501: ELSE
1502: x_error_msg := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';
1503: END IF;
1504: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_error_msg);
1505: RETURN FALSE;
1506: WHEN OTHERS THEN
1511: CLOSE c_bsc_dim_objs;
1512: END IF;
1513: ROLLBACK TO BscSyncDimeObjects;
1514: IF (x_error_msg IS NOT NULL) THEN
1515: x_error_msg := x_error_msg||' -> BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';
1516: ELSE
1517: x_error_msg := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';
1518: END IF;
1519: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_error_msg);
1513: ROLLBACK TO BscSyncDimeObjects;
1514: IF (x_error_msg IS NOT NULL) THEN
1515: x_error_msg := x_error_msg||' -> BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';
1516: ELSE
1517: x_error_msg := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';
1518: END IF;
1519: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_error_msg);
1520: RETURN FALSE;
1521: END Synchronize_Dim_Objects;
1563: FROM BIS_LEVELS A
1564: WHERE A.dimension_id = l_dimension_id;
1565:
1566:
1567: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
1568: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1569: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1570:
1571: l_flag BOOLEAN;
1651: AND dim_group_id = (SELECT Dim_Group_Id
1652: FROM BSC_SYS_DIM_GROUPS_VL WHERE SHORT_NAME = cd.Short_Name);
1653:
1654: IF (l_count = 0) THEN
1655: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object
1656: (
1657: p_commit => FND_API.G_FALSE
1658: , p_dim_short_name => cd.Short_Name
1659: , p_dim_obj_short_name => dim_cn.Short_Name
1701: l_bis_dimension_rec.Last_Updated_By := cd.Last_Updated_By;
1702: l_bis_dimension_rec.Last_Update_Date := cd.Last_Update_Date;
1703: l_bis_dimension_rec.Last_Update_Login := cd.Last_Update_Login;
1704:
1705: BIS_DIMENSION_PUB.Create_Dimension
1706: ( p_api_version => 1.0
1707: , p_commit => FND_API.G_FALSE
1708: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1709: , p_Dimension_Rec => l_bis_dimension_rec
2000: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2001: )
2002: IS
2003:
2004: l_Dim_Grp_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
2005: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2006:
2007: cursor installed_languages_cursor is
2008: select L.language_code
2022: FROM BSC_SYS_DIM_GROUPS_TL
2023: WHERE SHORT_NAME = p_dim_short_name
2024: AND LANGUAGE = cd.language_code;
2025:
2026: BIS_DIMENSION_PUB.Translate_Dim_By_Given_Lang
2027: (
2028: p_commit => FND_API.G_FALSE
2029: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2030: , p_Dimension_Rec => l_Dim_Grp_Rec
2849: short_name
2850: FROM
2851: bsc_sys_dim_groups_vl grp
2852: WHERE
2853: bsc_bis_dimension_pub.get_dimension_source(short_name)='PMF' AND
2854: short_name LIKE 'DGRP_%' AND
2855: name = short_name AND
2856: bis_util.is_seeded(created_by,'T','F') = 'F' AND
2857: (SELECT COUNT(1) FROM bsc_kpi_dim_groups WHERE dim_group_id = grp.dim_group_id) = 0;