DBA Data[Home] [Help]

APPS.BSC_UPGRADES dependencies on BSC_BIS_DIMENSION_PUB

Line 1500: x_error_msg := x_error_msg||' -> BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';

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);

Line 1502: x_error_msg := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';

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

Line 1515: x_error_msg := x_error_msg||' -> BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';

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);

Line 1517: x_error_msg := SQLERRM||' at BSC_BIS_DIMENSION_PUB.Synchronize_Dim_Objects ';

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;

Line 1655: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object

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

Line 2853: bsc_bis_dimension_pub.get_dimension_source(short_name)='PMF' AND

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;