APPS.BSC_UTILITY dependencies on FND_API

Line 984: WHEN FND_API.G_EXC_ERROR THEN

980:
981: return l_timestamp;
982:
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: rollback;
986: x_return_status := FND_API.G_RET_STS_ERROR;
987: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
988: ,p_data => x_msg_data);

Line 986: x_return_status := FND_API.G_RET_STS_ERROR;

982:
983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: rollback;
986: x_return_status := FND_API.G_RET_STS_ERROR;
987: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: rollback;

Line 989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

985: rollback;
986: x_return_status := FND_API.G_RET_STS_ERROR;
987: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: rollback;
991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
992: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
993: ,p_data => x_msg_data);

Line 991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

987: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: rollback;
991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
992: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
993: ,p_data => x_msg_data);
994: WHEN NO_DATA_FOUND THEN
995: rollback;

Line 996: x_return_status := FND_API.G_RET_STS_ERROR;

992: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
993: ,p_data => x_msg_data);
994: WHEN NO_DATA_FOUND THEN
995: rollback;
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
998: ,p_data => x_msg_data);
999: WHEN OTHERS THEN
1000: rollback;

Line 1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

998: ,p_data => x_msg_data);
999: WHEN OTHERS THEN
1000: rollback;
1001: FND_MSG_PUB.Initialize;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1004: ,p_data => x_msg_data);
1005:
1006: end get_system_timestamp;

Line 1048: WHEN FND_API.G_EXC_ERROR THEN

1044:
1045: end if;
1046:
1047: EXCEPTION
1048: WHEN FND_API.G_EXC_ERROR THEN
1049: rollback;
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1052: ,p_data => x_msg_data);

Line 1050: x_return_status := FND_API.G_RET_STS_ERROR;

1046:
1047: EXCEPTION
1048: WHEN FND_API.G_EXC_ERROR THEN
1049: rollback;
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1052: ,p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: rollback;

Line 1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1049: rollback;
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1052: ,p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: rollback;
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1057: ,p_data => x_msg_data);

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1051: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1052: ,p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: rollback;
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1057: ,p_data => x_msg_data);
1058: WHEN NO_DATA_FOUND THEN
1059: rollback;

Line 1060: x_return_status := FND_API.G_RET_STS_ERROR;

1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1057: ,p_data => x_msg_data);
1058: WHEN NO_DATA_FOUND THEN
1059: rollback;
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1062: ,p_data => x_msg_data);
1063: WHEN OTHERS THEN
1064: rollback;

Line 1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1061: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1062: ,p_data => x_msg_data);
1063: WHEN OTHERS THEN
1064: rollback;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1067: ,p_data => x_msg_data);
1068:
1069: end get_session_error;

Line 1568: RETURN FND_API.G_TRUE;

1564: );
1565:
1566: IF (l_Function_Return = TRUE) THEN
1567: IF( (l_Status = 'L') OR (l_Status = 'S') OR (l_Status = 'I')) THEN
1568: RETURN FND_API.G_TRUE;
1569: ELSE
1570: RETURN FND_API.G_FALSE;
1571: END IF;
1572: ELSE

Line 1570: RETURN FND_API.G_FALSE;

1566: IF (l_Function_Return = TRUE) THEN
1567: IF( (l_Status = 'L') OR (l_Status = 'S') OR (l_Status = 'I')) THEN
1568: RETURN FND_API.G_TRUE;
1569: ELSE
1570: RETURN FND_API.G_FALSE;
1571: END IF;
1572: ELSE
1573: RETURN FND_API.G_FALSE;
1574: END IF;

Line 1573: RETURN FND_API.G_FALSE;

1569: ELSE
1570: RETURN FND_API.G_FALSE;
1571: END IF;
1572: ELSE
1573: RETURN FND_API.G_FALSE;
1574: END IF;
1575:
1576: EXCEPTION
1577: WHEN OTHERS THEN

Line 1578: RETURN FND_API.G_FALSE;

1574: END IF;
1575:
1576: EXCEPTION
1577: WHEN OTHERS THEN
1578: RETURN FND_API.G_FALSE;
1579:
1580: END Is_BSC_Licensed;
1581:
1582:

Line 1601: RETURN FND_API.G_TRUE;

1597: INTO l_Profile_Value
1598: FROM DUAL;
1599:
1600: IF (TO_NUMBER(NVL(l_Profile_Value, '-1')) >= 0) THEN
1601: RETURN FND_API.G_TRUE;
1602: ELSE
1603: RETURN FND_API.G_FALSE;
1604: END IF;
1605:

Line 1603: RETURN FND_API.G_FALSE;

1599:
1600: IF (TO_NUMBER(NVL(l_Profile_Value, '-1')) >= 0) THEN
1601: RETURN FND_API.G_TRUE;
1602: ELSE
1603: RETURN FND_API.G_FALSE;
1604: END IF;
1605:
1606: EXCEPTION
1607: WHEN NO_DATA_FOUND THEN

Line 1608: RETURN FND_API.G_FALSE;

1604: END IF;
1605:
1606: EXCEPTION
1607: WHEN NO_DATA_FOUND THEN
1608: RETURN FND_API.G_FALSE;
1609:
1610: WHEN OTHERS THEN
1611: RETURN FND_API.G_FALSE;
1612:

Line 1611: RETURN FND_API.G_FALSE;

1607: WHEN NO_DATA_FOUND THEN
1608: RETURN FND_API.G_FALSE;
1609:
1610: WHEN OTHERS THEN
1611: RETURN FND_API.G_FALSE;
1612:
1613: END Is_Adv_Sum_Enabled;
1614:
1615:

Line 1634: RETURN FND_API.G_TRUE;

1630: FROM BSC_SYS_INIT
1631: WHERE property_code = 'ADV_SUM_LEVEL';
1632:
1633: IF (TO_NUMBER(NVL(l_Profile_Value, '-1')) >= 0) THEN
1634: RETURN FND_API.G_TRUE;
1635: ELSE
1636: RETURN FND_API.G_FALSE;
1637: END IF;
1638:

Line 1636: RETURN FND_API.G_FALSE;

1632:
1633: IF (TO_NUMBER(NVL(l_Profile_Value, '-1')) >= 0) THEN
1634: RETURN FND_API.G_TRUE;
1635: ELSE
1636: RETURN FND_API.G_FALSE;
1637: END IF;
1638:
1639: EXCEPTION
1640: WHEN NO_DATA_FOUND THEN

Line 1641: RETURN FND_API.G_FALSE;

1637: END IF;
1638:
1639: EXCEPTION
1640: WHEN NO_DATA_FOUND THEN
1641: RETURN FND_API.G_FALSE;
1642:
1643: WHEN OTHERS THEN
1644: RETURN FND_API.G_FALSE;
1645:

Line 1644: RETURN FND_API.G_FALSE;

1640: WHEN NO_DATA_FOUND THEN
1641: RETURN FND_API.G_FALSE;
1642:
1643: WHEN OTHERS THEN
1644: RETURN FND_API.G_FALSE;
1645:
1646: END Is_Init_Adv_Sum_Enabled;
1647:
1648:

Line 1662: IF (Is_Adv_Sum_Enabled = FND_API.G_TRUE) THEN

1658: RETURN VARCHAR2 IS
1659: l_Profile_Value VARCHAR2(10);
1660: BEGIN
1661:
1662: IF (Is_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1663: RETURN FND_API.G_TRUE;
1664: ELSIF (Is_Init_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1665: RETURN FND_API.G_TRUE;
1666: ELSE

Line 1663: RETURN FND_API.G_TRUE;

1659: l_Profile_Value VARCHAR2(10);
1660: BEGIN
1661:
1662: IF (Is_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1663: RETURN FND_API.G_TRUE;
1664: ELSIF (Is_Init_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1665: RETURN FND_API.G_TRUE;
1666: ELSE
1667: RETURN FND_API.G_FALSE;

Line 1664: ELSIF (Is_Init_Adv_Sum_Enabled = FND_API.G_TRUE) THEN

1660: BEGIN
1661:
1662: IF (Is_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1663: RETURN FND_API.G_TRUE;
1664: ELSIF (Is_Init_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1665: RETURN FND_API.G_TRUE;
1666: ELSE
1667: RETURN FND_API.G_FALSE;
1668: END IF;

Line 1665: RETURN FND_API.G_TRUE;

1661:
1662: IF (Is_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1663: RETURN FND_API.G_TRUE;
1664: ELSIF (Is_Init_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1665: RETURN FND_API.G_TRUE;
1666: ELSE
1667: RETURN FND_API.G_FALSE;
1668: END IF;
1669:

Line 1667: RETURN FND_API.G_FALSE;

1663: RETURN FND_API.G_TRUE;
1664: ELSIF (Is_Init_Adv_Sum_Enabled = FND_API.G_TRUE) THEN
1665: RETURN FND_API.G_TRUE;
1666: ELSE
1667: RETURN FND_API.G_FALSE;
1668: END IF;
1669:
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN

Line 1672: RETURN FND_API.G_FALSE;

1668: END IF;
1669:
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: RETURN FND_API.G_FALSE;
1673:
1674: WHEN OTHERS THEN
1675: RETURN FND_API.G_FALSE;
1676:

Line 1675: RETURN FND_API.G_FALSE;

1671: WHEN NO_DATA_FOUND THEN
1672: RETURN FND_API.G_FALSE;
1673:
1674: WHEN OTHERS THEN
1675: RETURN FND_API.G_FALSE;
1676:
1677: END Is_Adv_Summarization_Enabled;
1678:
1679:

Line 1796: WHEN FND_API.G_EXC_ERROR THEN

1792:
1793: RETURN l_ret_val;
1794:
1795: EXCEPTION
1796: WHEN FND_API.G_EXC_ERROR THEN
1797: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1798: ,p_data => l_msg_data);
1799: RAISE;
1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1796: WHEN FND_API.G_EXC_ERROR THEN
1797: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1798: ,p_data => l_msg_data);
1799: RAISE;
1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1801: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1802: ,p_data => l_msg_data);
1803: RAISE;
1804: WHEN NO_DATA_FOUND THEN

Line 1907: l_Return := FND_API.G_FALSE;

1903: l_Return VARCHAR2(1);
1904: l_Count NUMBER;
1905: BEGIN
1906: l_Count := 0;
1907: l_Return := FND_API.G_FALSE;
1908:
1909: SELECT COUNT(1) INTO l_Count
1910: FROM BSC_SYS_INIT B
1911: WHERE B.PROPERTY_CODE = c_MIXED_DIM_OBJS

Line 1915: l_Return := FND_API.G_TRUE;

1911: WHERE B.PROPERTY_CODE = c_MIXED_DIM_OBJS
1912: AND B.PROPERTY_VALUE > 0;
1913:
1914: IF (l_Count > 0) THEN
1915: l_Return := FND_API.G_TRUE;
1916: END IF;
1917:
1918: RETURN l_Return;
1919:

Line 1922: RETURN FND_API.G_FALSE;

1918: RETURN l_Return;
1919:
1920: EXCEPTION
1921: WHEN OTHERS THEN
1922: RETURN FND_API.G_FALSE;
1923: END is_Mix_Dim_Objects_Allowed;
1924:
1925: FUNCTION get_valid_bsc_master_tbl_name
1926: (

Line 1978: RETURN FND_API.G_TRUE;

1974:
1975: EXECUTE IMMEDIATE l_Sql INTO l_Count USING p_Dimension_Short_Name, p_Dimension_Object_Short_Name;
1976:
1977: IF (l_Count <> 0) THEN
1978: RETURN FND_API.G_TRUE;
1979: END IF;
1980:
1981: RETURN FND_API.G_FALSE;
1982:

Line 1981: RETURN FND_API.G_FALSE;

1977: IF (l_Count <> 0) THEN
1978: RETURN FND_API.G_TRUE;
1979: END IF;
1980:
1981: RETURN FND_API.G_FALSE;
1982:
1983: EXCEPTION
1984: WHEN OTHERS THEN
1985: RETURN FND_API.G_FALSE;

Line 1985: RETURN FND_API.G_FALSE;

1981: RETURN FND_API.G_FALSE;
1982:
1983: EXCEPTION
1984: WHEN OTHERS THEN
1985: RETURN FND_API.G_FALSE;
1986: END Is_Time_Period_Type;
1987:
1988:
1989: /*

Line 2010: RETURN FND_API.G_TRUE;

2006:
2007: EXECUTE IMMEDIATE l_sql INTO l_Count USING p_dimension_short_name;
2008:
2009: IF (l_count <> 0) THEN
2010: RETURN FND_API.G_TRUE;
2011: END IF;
2012:
2013: RETURN FND_API.G_FALSE;
2014:

Line 2013: RETURN FND_API.G_FALSE;

2009: IF (l_count <> 0) THEN
2010: RETURN FND_API.G_TRUE;
2011: END IF;
2012:
2013: RETURN FND_API.G_FALSE;
2014:
2015: EXCEPTION
2016: WHEN OTHERS THEN
2017: RETURN FND_API.G_FALSE;

Line 2017: RETURN FND_API.G_FALSE;

2013: RETURN FND_API.G_FALSE;
2014:
2015: EXCEPTION
2016: WHEN OTHERS THEN
2017: RETURN FND_API.G_FALSE;
2018: END is_dim_time_period_type;
2019:
2020:
2021: /*

Line 2039: RETURN FND_API.G_TRUE;

2035:
2036: EXECUTE IMMEDIATE l_Sql INTO l_Count USING p_Dimension_Object_Short_Name;
2037:
2038: IF (l_Count <> 0) THEN
2039: RETURN FND_API.G_TRUE;
2040: END IF;
2041:
2042: RETURN FND_API.G_FALSE;
2043:

Line 2042: RETURN FND_API.G_FALSE;

2038: IF (l_Count <> 0) THEN
2039: RETURN FND_API.G_TRUE;
2040: END IF;
2041:
2042: RETURN FND_API.G_FALSE;
2043:
2044: EXCEPTION
2045: WHEN OTHERS THEN
2046: RETURN FND_API.G_FALSE;

Line 2046: RETURN FND_API.G_FALSE;

2042: RETURN FND_API.G_FALSE;
2043:
2044: EXCEPTION
2045: WHEN OTHERS THEN
2046: RETURN FND_API.G_FALSE;
2047: END Is_Dim_Object_Periodicity_Type;
2048:
2049: /*********************************************************************************
2050: API TO CHECK IF DIMENSION/DIMENSION OBJECTS SHOULD BE ALLOWED AT THE

Line 2074: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2070: l_dim_sname VARCHAR2(30);
2071: l_dim_obj_sname VARCHAR2(30);
2072: BEGIN
2073: FND_MSG_PUB.Initialize;
2074: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: IF ((p_Entity_Short_Names IS NULL) OR (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE)) THEN
2077: RETURN;
2078: END IF;

Line 2076: IF ((p_Entity_Short_Names IS NULL) OR (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE)) THEN

2072: BEGIN
2073: FND_MSG_PUB.Initialize;
2074: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: IF ((p_Entity_Short_Names IS NULL) OR (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE)) THEN
2077: RETURN;
2078: END IF;
2079:
2080: l_temp_snames := p_Entity_Short_Names;

Line 2099: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2095: , x_Return_Status => x_Return_Status
2096: , x_Msg_Count => x_Msg_Count
2097: , x_Msg_Data => x_Msg_Data
2098: );
2099: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2101: END IF;
2102:
2103: l_Entity_Name := null;

Line 2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2096: , x_Msg_Count => x_Msg_Count
2097: , x_Msg_Data => x_Msg_Data
2098: );
2099: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2101: END IF;
2102:
2103: l_Entity_Name := null;
2104: Enable_Dimension_Entity (

Line 2113: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2109: , x_Return_Status => x_Return_Status
2110: , x_Msg_Count => x_Msg_Count
2111: , x_Msg_Data => x_Msg_Data
2112: );
2113: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116: END IF;
2117:

Line 2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2110: , x_Msg_Count => x_Msg_Count
2111: , x_Msg_Data => x_Msg_Data
2112: );
2113: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116: END IF;
2117:
2118: ELSE

Line 2130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2126: , x_Return_Status => x_Return_Status
2127: , x_Msg_Count => x_Msg_Count
2128: , x_Msg_Data => x_Msg_Data
2129: );
2130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2132: END IF;
2133: END IF;
2134: END LOOP;

Line 2131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2127: , x_Msg_Count => x_Msg_Count
2128: , x_Msg_Data => x_Msg_Data
2129: );
2130: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2132: END IF;
2133: END IF;
2134: END LOOP;
2135:

Line 2141: ( p_encoded => FND_API.G_FALSE

2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: IF (x_msg_data IS NULL) THEN
2140: FND_MSG_PUB.Count_And_Get
2141: ( p_encoded => FND_API.G_FALSE
2142: , p_count => x_msg_count
2143: , p_data => x_msg_data
2144: );
2145: END IF;

Line 2146: x_Return_Status := FND_API.G_RET_STS_ERROR;

2142: , p_count => x_msg_count
2143: , p_data => x_msg_data
2144: );
2145: END IF;
2146: x_Return_Status := FND_API.G_RET_STS_ERROR;
2147: END Enable_Dimensions_Entity;
2148:
2149: FUNCTION Get_Name(
2150: p_Entity_Type IN VARCHAR2

Line 2319: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2315: l_Return_Msg VARCHAR2(30);
2316: BEGIN
2317: -- pick the name if it is null.
2318: FND_MSG_PUB.Initialize;
2319: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: IF ((p_Entity_Short_Name IS NULL) OR (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE)) THEN
2322: RETURN;
2323: END IF;

Line 2321: IF ((p_Entity_Short_Name IS NULL) OR (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE)) THEN

2317: -- pick the name if it is null.
2318: FND_MSG_PUB.Initialize;
2319: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: IF ((p_Entity_Short_Name IS NULL) OR (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE)) THEN
2322: RETURN;
2323: END IF;
2324:
2325: IF(p_Entity_Type = c_DIMENSION_OBJECT) THEN

Line 2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2339: END IF;
2340: FND_MESSAGE.SET_NAME('BIS','BIS_DIMOBJ_ASSIGN_PERIODS');
2341: FND_MESSAGE.SET_TOKEN('DIMOBJ', l_tmp_EntityName);
2342: FND_MSG_PUB.ADD;
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: END IF;
2345:
2346: ELSIF (p_Entity_Type = c_DIMENSION) THEN
2347: l_Sql := ' SELECT COUNT(1) FROM BIS_DIMENSIONS D, BSC_SYS_CALENDARS_B C '

Line 2361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2357: END IF;
2358: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_ASSIGN_PERIODS');
2359: FND_MESSAGE.SET_TOKEN('DIM', l_tmp_EntityName);
2360: FND_MSG_PUB.ADD;
2361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2362: END IF;
2363:
2364: l_Return_Msg := Is_Internal_Dim(p_Entity_Short_Name);
2365:

Line 2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2371: END IF;
2372: FND_MESSAGE.SET_NAME('BIS',l_Return_Msg);
2373: FND_MESSAGE.SET_TOKEN('DIM', l_tmp_EntityName);
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: END IF;
2377:
2378: END IF;
2379:

Line 2384: ( p_encoded => FND_API.G_FALSE

2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: IF (x_msg_data IS NULL) THEN
2383: FND_MSG_PUB.Count_And_Get
2384: ( p_encoded => FND_API.G_FALSE
2385: , p_count => x_msg_count
2386: , p_data => x_msg_data
2387: );
2388: END IF;

Line 2389: x_Return_Status := FND_API.G_RET_STS_ERROR;

2385: , p_count => x_msg_count
2386: , p_data => x_msg_data
2387: );
2388: END IF;
2389: x_Return_Status := FND_API.G_RET_STS_ERROR;
2390: END Enable_Dimension_Entity;
2391:
2392: /*
2393: Verify whether the comma(,) separated dimensions are not internal

Line 2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2413: l_Entity_Name := Get_Name(c_DIMENSION, l_Short_Name);
2414: FND_MESSAGE.SET_NAME('BIS',l_Return_Msg);
2415: FND_MESSAGE.SET_TOKEN('DIM', l_Entity_Name);
2416: FND_MSG_PUB.ADD;
2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2418: END IF;
2419: END LOOP;
2420:
2421: EXCEPTION

Line 2425: ( p_encoded => FND_API.G_FALSE

2421: EXCEPTION
2422: WHEN OTHERS THEN
2423: IF (x_msg_data IS NULL) THEN
2424: FND_MSG_PUB.Count_And_Get
2425: ( p_encoded => FND_API.G_FALSE
2426: , p_count => x_msg_count
2427: , p_data => x_msg_data
2428: );
2429: END IF;

Line 2430: x_Return_Status := FND_API.G_RET_STS_ERROR;

2426: , p_count => x_msg_count
2427: , p_data => x_msg_data
2428: );
2429: END IF;
2430: x_Return_Status := FND_API.G_RET_STS_ERROR;
2431: END Check_Weighted_Dimension;
2432:
2433:
2434: FUNCTION Is_More

Line 2481: RETURN FND_API.G_FALSE;

2477: l_Return_Msg VARCHAR2(30);
2478: BEGIN
2479: l_Return_Msg := Is_Internal_Dim(p_Short_Name);
2480: IF (l_Return_Msg IS NULL) THEN
2481: RETURN FND_API.G_FALSE;
2482: ELSE
2483: RETURN FND_API.G_TRUE;
2484: END IF;
2485:

Line 2483: RETURN FND_API.G_TRUE;

2479: l_Return_Msg := Is_Internal_Dim(p_Short_Name);
2480: IF (l_Return_Msg IS NULL) THEN
2481: RETURN FND_API.G_FALSE;
2482: ELSE
2483: RETURN FND_API.G_TRUE;
2484: END IF;
2485:
2486: EXCEPTION
2487: WHEN OTHERS THEN

Line 2488: RETURN FND_API.G_TRUE;

2484: END IF;
2485:
2486: EXCEPTION
2487: WHEN OTHERS THEN
2488: RETURN FND_API.G_TRUE;
2489: END Is_Internal_Dimension;
2490:
2491:
2492: /****************************************************************************************************

Line 2539: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2535: TYPE ref_cur IS REF CURSOR;
2536: c_regions_dim_obj ref_cur;
2537: BEGIN
2538: FND_MSG_PUB.Initialize;
2539: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2540: IF (p_Short_Names IS NOT NULL) THEN
2541: x_region_codes := FND_TABLE_OF_VARCHAR2_30();
2542: l_sql := 'SELECT DISTINCT REGION_CODE FROM ak_region_items WHERE node_query_flag = ''Y'' AND node_display_flag = ''N'' AND SUBSTR(attribute2,INSTR(attribute2,''+'') +1 ,LENGTH(attribute2)) IN (' ;
2543: l_short_names := p_Short_Names;

Line 2566: ( p_encoded => FND_API.G_FALSE

2562: EXCEPTION
2563: WHEN OTHERS THEN
2564: IF (x_msg_data IS NULL) THEN
2565: FND_MSG_PUB.Count_And_Get
2566: ( p_encoded => FND_API.G_FALSE
2567: , p_count => x_msg_count
2568: , p_data => x_msg_data
2569: );
2570: END IF;

Line 2571: x_Return_Status := FND_API.G_RET_STS_ERROR;

2567: , p_count => x_msg_count
2568: , p_data => x_msg_data
2569: );
2570: END IF;
2571: x_Return_Status := FND_API.G_RET_STS_ERROR;
2572: END Is_Dim_Obj_In_AKReport;
2573:
2574: /****************************************************************************************************
2575: Checkes if Report a Dimension or Dimension+Dimension Object is used in a Report.

Line 2705: RETURN FND_API.G_TRUE;

2701: WHERE B.SHORT_NAME = p_Short_Name
2702: AND BIS_UTIL.is_Seeded(B.CREATED_BY,'Y','N') = 'Y';
2703:
2704: IF (l_Count <> 0 AND NOT BIS_UTIL.Is_Internal_Customer) THEN
2705: RETURN FND_API.G_TRUE;
2706: END IF;
2707:
2708: RETURN FND_API.G_FALSE;
2709:

Line 2708: RETURN FND_API.G_FALSE;

2704: IF (l_Count <> 0 AND NOT BIS_UTIL.Is_Internal_Customer) THEN
2705: RETURN FND_API.G_TRUE;
2706: END IF;
2707:
2708: RETURN FND_API.G_FALSE;
2709:
2710: EXCEPTION
2711: WHEN OTHERS THEN
2712: RETURN FND_API.G_TRUE;

Line 2712: RETURN FND_API.G_TRUE;

2708: RETURN FND_API.G_FALSE;
2709:
2710: EXCEPTION
2711: WHEN OTHERS THEN
2712: RETURN FND_API.G_TRUE;
2713: END Is_Measure_Seeded;
2714:
2715:
2716: /****************************************************************

Line 2805: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

2801: , x_Return_Status => x_Return_Status
2802: , x_Msg_Count => x_Msg_Count
2803: , x_Msg_Data => x_Msg_Data
2804: );
2805: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2807: END IF;
2808:
2809: /*

Line 2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2802: , x_Msg_Count => x_Msg_Count
2803: , x_Msg_Data => x_Msg_Data
2804: );
2805: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2807: END IF;
2808:
2809: /*
2810: -- STEP#2 of algorithm

Line 2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2814: -- BIS_PLSQL_INVALID_PARAMETERS
2815: -- The PL/SQL Function provided has been defined with invalid parameters
2816: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_INVALID_PARAMETERS');
2817: FND_MSG_PUB.ADD;
2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2819: END IF;
2820: */
2821:
2822: -- STEP#2 of algorithm

Line 2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2836: (l_Parameter_2 IS NULL) AND
2837: (l_Parameter_3 IS NULL)) THEN
2838: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_INVALID_FUNC_NAME');
2839: FND_MSG_PUB.ADD;
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842:
2843: /*
2844: Perform validations here from STEP#2

Line 2868: IF ((x_Return_Status <> FND_API.G_RET_STS_SUCCESS) OR (l_Custom_Sql IS NULL)) THEN

2864: , x_Msg_Data => x_Msg_Data
2865: );
2866: -- BIS_ERR_OBTAIN_RPT_QUERY - There was an error when extracting Report Query using the Default
2867: -- parameter values. Please verify if your PL/SQL API returns a SQL for the default parameters.
2868: IF ((x_Return_Status <> FND_API.G_RET_STS_SUCCESS) OR (l_Custom_Sql IS NULL)) THEN
2869: FND_MESSAGE.SET_NAME('BIS','BIS_ERR_OBTAIN_RPT_QUERY');
2870: FND_MSG_PUB.ADD;
2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2872: END IF;

Line 2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2867: -- parameter values. Please verify if your PL/SQL API returns a SQL for the default parameters.
2868: IF ((x_Return_Status <> FND_API.G_RET_STS_SUCCESS) OR (l_Custom_Sql IS NULL)) THEN
2869: FND_MESSAGE.SET_NAME('BIS','BIS_ERR_OBTAIN_RPT_QUERY');
2870: FND_MSG_PUB.ADD;
2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2872: END IF;
2873:
2874: BSC_UTILITY.Validate_Sql_String (
2875: p_Sql_String => l_Custom_Sql

Line 2884: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

2880: );
2881: -- BIS_ERR_WITH_REPORT_SQL
2882: -- The Report Query returned from the PL/SQL procedure has the following
2883: -- error(s) : ERROR
2884: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2885: FND_MESSAGE.SET_NAME('BIS','BIS_ERR_WITH_REPORT_SQL');
2886: FND_MESSAGE.SET_TOKEN('ERROR', x_Msg_Data);
2887: FND_MSG_PUB.ADD;
2888: x_Msg_Data := NULL;

Line 2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2885: FND_MESSAGE.SET_NAME('BIS','BIS_ERR_WITH_REPORT_SQL');
2886: FND_MESSAGE.SET_TOKEN('ERROR', x_Msg_Data);
2887: FND_MSG_PUB.ADD;
2888: x_Msg_Data := NULL;
2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2890: END IF;
2891:
2892: l_Custom_Cols := Sort_String(l_Custom_Cols);
2893: l_View_Cols := Sort_String(l_View_Cols);

Line 2902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2898: -- PL/SQL procedure.
2899: IF ((l_Custom_Cols IS NULL) OR (l_Custom_Cols <> l_View_Cols)) THEN
2900: FND_MESSAGE.SET_NAME('BIS','BIS_ERR_COLS_RPT_MISMATCH');
2901: FND_MSG_PUB.ADD;
2902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2903: END IF;
2904:
2905: -- Finally the PL/SQL is OK - return that the PL/SQL has passed the validation.
2906: IF ((x_Return_Status = FND_API.G_RET_STS_SUCCESS) OR (x_Msg_Data IS NULL)) THEN

Line 2906: IF ((x_Return_Status = FND_API.G_RET_STS_SUCCESS) OR (x_Msg_Data IS NULL)) THEN

2902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2903: END IF;
2904:
2905: -- Finally the PL/SQL is OK - return that the PL/SQL has passed the validation.
2906: IF ((x_Return_Status = FND_API.G_RET_STS_SUCCESS) OR (x_Msg_Data IS NULL)) THEN
2907: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_PACKAGE_IS_VALID');
2908: FND_MSG_PUB.ADD;
2909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2910: END IF;

Line 2909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2905: -- Finally the PL/SQL is OK - return that the PL/SQL has passed the validation.
2906: IF ((x_Return_Status = FND_API.G_RET_STS_SUCCESS) OR (x_Msg_Data IS NULL)) THEN
2907: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_PACKAGE_IS_VALID');
2908: FND_MSG_PUB.ADD;
2909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2910: END IF;
2911:
2912: EXCEPTION
2913: WHEN FND_API.G_EXC_ERROR THEN

Line 2913: WHEN FND_API.G_EXC_ERROR THEN

2909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2910: END IF;
2911:
2912: EXCEPTION
2913: WHEN FND_API.G_EXC_ERROR THEN
2914: IF (x_msg_data IS NULL) THEN
2915: FND_MSG_PUB.Count_And_Get
2916: ( p_encoded => FND_API.G_FALSE
2917: , p_count => x_msg_count

Line 2916: ( p_encoded => FND_API.G_FALSE

2912: EXCEPTION
2913: WHEN FND_API.G_EXC_ERROR THEN
2914: IF (x_msg_data IS NULL) THEN
2915: FND_MSG_PUB.Count_And_Get
2916: ( p_encoded => FND_API.G_FALSE
2917: , p_count => x_msg_count
2918: , p_data => x_msg_data
2919: );
2920: END IF;

Line 2921: x_Return_Status := FND_API.G_RET_STS_ERROR;

2917: , p_count => x_msg_count
2918: , p_data => x_msg_data
2919: );
2920: END IF;
2921: x_Return_Status := FND_API.G_RET_STS_ERROR;
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: IF (x_msg_data IS NULL) THEN
2924: FND_MSG_PUB.Count_And_Get
2925: ( p_encoded => FND_API.G_FALSE

Line 2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2918: , p_data => x_msg_data
2919: );
2920: END IF;
2921: x_Return_Status := FND_API.G_RET_STS_ERROR;
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: IF (x_msg_data IS NULL) THEN
2924: FND_MSG_PUB.Count_And_Get
2925: ( p_encoded => FND_API.G_FALSE
2926: , p_count => x_msg_count

Line 2925: ( p_encoded => FND_API.G_FALSE

2921: x_Return_Status := FND_API.G_RET_STS_ERROR;
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: IF (x_msg_data IS NULL) THEN
2924: FND_MSG_PUB.Count_And_Get
2925: ( p_encoded => FND_API.G_FALSE
2926: , p_count => x_msg_count
2927: , p_data => x_msg_data
2928: );
2929: END IF;

Line 2930: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2926: , p_count => x_msg_count
2927: , p_data => x_msg_data
2928: );
2929: END IF;
2930: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: WHEN NO_DATA_FOUND THEN
2932: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2933: IF (x_msg_data IS NOT NULL) THEN
2934: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';

Line 2932: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2928: );
2929: END IF;
2930: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2931: WHEN NO_DATA_FOUND THEN
2932: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2933: IF (x_msg_data IS NOT NULL) THEN
2934: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';
2935: ELSE
2936: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';

Line 2939: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

2935: ELSE
2936: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';
2937: END IF;
2938: WHEN OTHERS THEN
2939: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
2940: IF (x_msg_data IS NOT NULL) THEN
2941: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_Plsql_For_Report ';
2942: ELSE
2943: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_Plsql_For_Report ';

Line 3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3133: -- The PL/SQL "Package_Name.Function_Name" specification is incorrect or does not exist.
3134: IF (INSTR(p_Plsql_Function, '.') = 0) THEN
3135: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_INVALID_FUNC_NAME');
3136: FND_MSG_PUB.ADD;
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: END IF;
3139:
3140: l_Package_Name := UPPER(SUBSTR(p_Plsql_Function, 1, INSTR(p_Plsql_Function, '.')-1));
3141: l_Function_Name := UPPER(SUBSTR(p_Plsql_Function, INSTR(p_Plsql_Function, '.')+1));

Line 3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3150: -- The PL/SQL procedure or function does not exist in the database
3151: IF (l_Count = 0) THEN
3152: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_PKG_NOT_EXIST');
3153: FND_MSG_PUB.ADD;
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: END IF;
3156:
3157: SELECT COUNT(1) INTO l_Count
3158: FROM USER_OBJECTS A

Line 3167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3163: -- The PL/SQL package has errors.
3164: IF (l_Count <> 0) THEN
3165: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_PKG_HAS_ERRORS');
3166: FND_MSG_PUB.ADD;
3167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3168: END IF;
3169:
3170: EXCEPTION
3171: WHEN FND_API.G_EXC_ERROR THEN

Line 3171: WHEN FND_API.G_EXC_ERROR THEN

3167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3168: END IF;
3169:
3170: EXCEPTION
3171: WHEN FND_API.G_EXC_ERROR THEN
3172: IF (x_msg_data IS NULL) THEN
3173: FND_MSG_PUB.Count_And_Get
3174: ( p_encoded => FND_API.G_FALSE
3175: , p_count => x_msg_count

Line 3174: ( p_encoded => FND_API.G_FALSE

3170: EXCEPTION
3171: WHEN FND_API.G_EXC_ERROR THEN
3172: IF (x_msg_data IS NULL) THEN
3173: FND_MSG_PUB.Count_And_Get
3174: ( p_encoded => FND_API.G_FALSE
3175: , p_count => x_msg_count
3176: , p_data => x_msg_data
3177: );
3178: END IF;

Line 3179: x_Return_Status := FND_API.G_RET_STS_ERROR;

3175: , p_count => x_msg_count
3176: , p_data => x_msg_data
3177: );
3178: END IF;
3179: x_Return_Status := FND_API.G_RET_STS_ERROR;
3180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3181: IF (x_msg_data IS NULL) THEN
3182: FND_MSG_PUB.Count_And_Get
3183: ( p_encoded => FND_API.G_FALSE

Line 3180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3176: , p_data => x_msg_data
3177: );
3178: END IF;
3179: x_Return_Status := FND_API.G_RET_STS_ERROR;
3180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3181: IF (x_msg_data IS NULL) THEN
3182: FND_MSG_PUB.Count_And_Get
3183: ( p_encoded => FND_API.G_FALSE
3184: , p_count => x_msg_count

Line 3183: ( p_encoded => FND_API.G_FALSE

3179: x_Return_Status := FND_API.G_RET_STS_ERROR;
3180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3181: IF (x_msg_data IS NULL) THEN
3182: FND_MSG_PUB.Count_And_Get
3183: ( p_encoded => FND_API.G_FALSE
3184: , p_count => x_msg_count
3185: , p_data => x_msg_data
3186: );
3187: END IF;

Line 3188: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3184: , p_count => x_msg_count
3185: , p_data => x_msg_data
3186: );
3187: END IF;
3188: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3189: WHEN NO_DATA_FOUND THEN
3190: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3191: IF (x_msg_data IS NOT NULL) THEN
3192: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';

Line 3190: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3186: );
3187: END IF;
3188: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3189: WHEN NO_DATA_FOUND THEN
3190: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3191: IF (x_msg_data IS NOT NULL) THEN
3192: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';
3193: ELSE
3194: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';

Line 3197: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3193: ELSE
3194: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';
3195: END IF;
3196: WHEN OTHERS THEN
3197: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: IF (x_msg_data IS NOT NULL) THEN
3199: x_msg_data := x_msg_data||' -> BSC_UTILITY.Validate_PLSQL ';
3200: ELSE
3201: x_msg_data := SQLERRM||' at BSC_UTILITY.Validate_PLSQL ';

Line 3252: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

3248: l_Measure_Columns VARCHAR2(4096);
3249: BEGIN
3250: FND_MSG_PUB.Initialize;
3251: l_Table_Count := 0;
3252: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3253:
3254: BSC_UTILITY.Parse_String
3255: (
3256: p_List => p_Attribute_Code

Line 3524: WHEN FND_API.G_EXC_ERROR THEN

3520: l_Sql := 'BEGIN ' || p_Plsql_Function || ' (:1, :2, :3); END;';
3521: EXECUTE IMMEDIATE l_Sql USING l_PMV_Query_Table, OUT x_Custom_Sql, OUT x_Custom_Output;
3522:
3523: EXCEPTION
3524: WHEN FND_API.G_EXC_ERROR THEN
3525: IF (x_msg_data IS NULL) THEN
3526: FND_MSG_PUB.Count_And_Get
3527: ( p_encoded => FND_API.G_FALSE
3528: , p_count => x_msg_count

Line 3527: ( p_encoded => FND_API.G_FALSE

3523: EXCEPTION
3524: WHEN FND_API.G_EXC_ERROR THEN
3525: IF (x_msg_data IS NULL) THEN
3526: FND_MSG_PUB.Count_And_Get
3527: ( p_encoded => FND_API.G_FALSE
3528: , p_count => x_msg_count
3529: , p_data => x_msg_data
3530: );
3531: END IF;

Line 3532: x_Return_Status := FND_API.G_RET_STS_ERROR;

3528: , p_count => x_msg_count
3529: , p_data => x_msg_data
3530: );
3531: END IF;
3532: x_Return_Status := FND_API.G_RET_STS_ERROR;
3533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3534: IF (x_msg_data IS NULL) THEN
3535: FND_MSG_PUB.Count_And_Get
3536: ( p_encoded => FND_API.G_FALSE

Line 3533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3529: , p_data => x_msg_data
3530: );
3531: END IF;
3532: x_Return_Status := FND_API.G_RET_STS_ERROR;
3533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3534: IF (x_msg_data IS NULL) THEN
3535: FND_MSG_PUB.Count_And_Get
3536: ( p_encoded => FND_API.G_FALSE
3537: , p_count => x_msg_count

Line 3536: ( p_encoded => FND_API.G_FALSE

3532: x_Return_Status := FND_API.G_RET_STS_ERROR;
3533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3534: IF (x_msg_data IS NULL) THEN
3535: FND_MSG_PUB.Count_And_Get
3536: ( p_encoded => FND_API.G_FALSE
3537: , p_count => x_msg_count
3538: , p_data => x_msg_data
3539: );
3540: END IF;

Line 3541: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3537: , p_count => x_msg_count
3538: , p_data => x_msg_data
3539: );
3540: END IF;
3541: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3542: WHEN NO_DATA_FOUND THEN
3543: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3544: IF (x_msg_data IS NOT NULL) THEN
3545: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';

Line 3543: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3539: );
3540: END IF;
3541: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3542: WHEN NO_DATA_FOUND THEN
3543: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3544: IF (x_msg_data IS NOT NULL) THEN
3545: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';
3546: ELSE
3547: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';

Line 3550: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3546: ELSE
3547: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';
3548: END IF;
3549: WHEN OTHERS THEN
3550: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3551: IF (x_msg_data IS NOT NULL) THEN
3552: x_msg_data := x_msg_data||' -> BSC_UTILITY.Obtain_Report_Query ';
3553: ELSE
3554: x_msg_data := SQLERRM||' at BSC_UTILITY.Obtain_Report_Query ';

Line 3638: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

3634: ORDER BY A.COLUMN_NAME;
3635:
3636: BEGIN
3637: FND_MSG_PUB.Initialize;
3638: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3639:
3640: -- Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, since it can return negative value
3641: l_Temp_View_Name := 'BIS_TMP_' || TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME) || '_V';
3642:

Line 3666: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3662: BSC_UTILITY.Do_Ddl_AT(l_Sql_View, AD_DDL.DROP_VIEW, l_Temp_View_Name, 'APPS', 'BIS');
3663:
3664: EXCEPTION
3665: WHEN OTHERS THEN
3666: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3667: x_Msg_Data := SQLERRM;
3668: END Validate_Sql_String;
3669:
3670: -- Sorts a comma separated string using a Enhanced Bubble Sort (Very bad - but ok for now)

Line 3726: l_convertible := FND_API.G_FALSE;

3722: l_convertible VARCHAR2(10);
3723: l_obj_attached VARCHAR2(10);
3724: l_formula_meas VARCHAR2(10);
3725: BEGIN
3726: l_convertible := FND_API.G_FALSE;
3727:
3728: l_obj_attached := is_attached_to_objective
3729: ( p_dataset_id => p_dataset_id
3730: , p_region_code => p_region_code

Line 3733: IF (l_obj_attached = FND_API.G_FALSE) THEN

3729: ( p_dataset_id => p_dataset_id
3730: , p_region_code => p_region_code
3731: );
3732:
3733: IF (l_obj_attached = FND_API.G_FALSE) THEN
3734: l_formula_meas := is_formula_measure
3735: ( p_dataset_id => p_dataset_id
3736: );
3737: END IF;

Line 3739: IF (l_obj_attached = FND_API.G_FALSE AND l_formula_meas = FND_API.G_FALSE) THEN

3735: ( p_dataset_id => p_dataset_id
3736: );
3737: END IF;
3738:
3739: IF (l_obj_attached = FND_API.G_FALSE AND l_formula_meas = FND_API.G_FALSE) THEN
3740: l_convertible := FND_API.G_TRUE;
3741: END IF;
3742:
3743: RETURN l_convertible;

Line 3740: l_convertible := FND_API.G_TRUE;

3736: );
3737: END IF;
3738:
3739: IF (l_obj_attached = FND_API.G_FALSE AND l_formula_meas = FND_API.G_FALSE) THEN
3740: l_convertible := FND_API.G_TRUE;
3741: END IF;
3742:
3743: RETURN l_convertible;
3744: EXCEPTION

Line 3746: RETURN FND_API.G_FALSE;

3742:
3743: RETURN l_convertible;
3744: EXCEPTION
3745: WHEN OTHERS THEN
3746: RETURN FND_API.G_FALSE;
3747: END is_bsc_measure_convertible;
3748:
3749: -- Returns 'T' if the p_dataset_id is attached to any objective except the objective for p_region_code
3750: FUNCTION is_attached_to_objective (

Line 3766: l_attached := FND_API.G_FALSE;

3762: AND m.dataset_id = p_dataset_id
3763: AND k.short_name <> p_region_code;
3764:
3765: BEGIN
3766: l_attached := FND_API.G_FALSE;
3767:
3768: IF (c_attached_obj%ISOPEN) THEN
3769: CLOSE c_attached_obj;
3770: END IF;

Line 3774: l_attached := FND_API.G_TRUE;

3770: END IF;
3771: OPEN c_attached_obj;
3772: FETCH c_attached_obj INTO l_obj_count;
3773: IF (l_obj_count > 0) THEN
3774: l_attached := FND_API.G_TRUE;
3775: END IF;
3776: CLOSE c_attached_obj;
3777:
3778: RETURN l_attached;

Line 3784: RETURN FND_API.G_FALSE;

3780: WHEN OTHERS THEN
3781: IF (c_attached_obj%ISOPEN) THEN
3782: CLOSE c_attached_obj;
3783: END IF;
3784: RETURN FND_API.G_FALSE;
3785: END is_attached_to_objective;
3786:
3787: -- Wrapper over BSC_BIS_MEASURE_PUB.Is_Src_Col_In_Formulas to return a VARCHAR so that it can be used in a SQL query.
3788: FUNCTION Is_Src_Col_In_Formulas (

Line 3794: RETURN FND_API.G_TRUE;

3790: ) RETURN VARCHAR2
3791: IS
3792: BEGIN
3793: IF (BSC_BIS_MEASURE_PUB.Is_Src_Col_In_Formulas(p_Source_Col)) THEN
3794: RETURN FND_API.G_TRUE;
3795: END IF;
3796: RETURN FND_API.G_FALSE;
3797: EXCEPTION
3798: WHEN OTHERS THEN

Line 3796: RETURN FND_API.G_FALSE;

3792: BEGIN
3793: IF (BSC_BIS_MEASURE_PUB.Is_Src_Col_In_Formulas(p_Source_Col)) THEN
3794: RETURN FND_API.G_TRUE;
3795: END IF;
3796: RETURN FND_API.G_FALSE;
3797: EXCEPTION
3798: WHEN OTHERS THEN
3799: RETURN FND_API.G_FALSE;
3800: END Is_Src_Col_In_Formulas;

Line 3799: RETURN FND_API.G_FALSE;

3795: END IF;
3796: RETURN FND_API.G_FALSE;
3797: EXCEPTION
3798: WHEN OTHERS THEN
3799: RETURN FND_API.G_FALSE;
3800: END Is_Src_Col_In_Formulas;
3801:
3802: -- Returns 'T' if the p_dataset_id is itself a Formula measure or a part of the formula for some other measure.
3803: FUNCTION is_formula_measure (

Line 3824: l_formula := FND_API.G_FALSE;

3820: AND (measure_id1 = d.measure_id1 OR measure_id2 = d.measure_id1)) > 0)
3821: );
3822:
3823: BEGIN
3824: l_formula := FND_API.G_FALSE;
3825:
3826: IF (c_formula_meas%ISOPEN) THEN
3827: CLOSE c_formula_meas;
3828: END IF;

Line 3832: l_formula := FND_API.G_TRUE;

3828: END IF;
3829: OPEN c_formula_meas;
3830: FETCH c_formula_meas INTO l_count;
3831: IF (l_count > 0) THEN
3832: l_formula := FND_API.G_TRUE;
3833: END IF;
3834: CLOSE c_formula_meas;
3835:
3836: RETURN l_formula;

Line 3842: RETURN FND_API.G_FALSE;

3838: WHEN OTHERS THEN
3839: IF (c_formula_meas%ISOPEN) THEN
3840: CLOSE c_formula_meas;
3841: END IF;
3842: RETURN FND_API.G_FALSE;
3843: END is_formula_measure;
3844:
3845:
3846: /***********************************************

Line 3955: l_flag :=FND_API.G_FALSE;

3951: IS
3952: l_flag VARCHAR2(10);
3953: l_measure_type VARCHAR2(10);
3954: BEGIN
3955: l_flag :=FND_API.G_FALSE;
3956:
3957: SELECT measure_type
3958: INTO l_measure_type
3959: FROM bis_indicators

Line 3963: l_flag:=FND_API.G_TRUE;

3959: FROM bis_indicators
3960: WHERE short_name = p_Measure_Short_Name;
3961:
3962: IF(l_measure_type=BSC_UTILITY.C_MEASURE_SOURCE_CDS_CALC)THEN
3963: l_flag:=FND_API.G_TRUE;
3964: END IF;
3965: RETURN l_flag;
3966:
3967: EXCEPTION

Line 3992: RETURN FND_API.G_TRUE;

3988: WHERE i.dataset_id = p_Dataset_Id
3989: AND tl.indicator_id = i.indicator_id;
3990:
3991: IF(l_count>0)THEN
3992: RETURN FND_API.G_TRUE;
3993: ELSE
3994: RETURN FND_API.G_FALSE;
3995: END IF;
3996: END Is_Meas_Used_In_Targets;

Line 3994: RETURN FND_API.G_FALSE;

3990:
3991: IF(l_count>0)THEN
3992: RETURN FND_API.G_TRUE;
3993: ELSE
3994: RETURN FND_API.G_FALSE;
3995: END IF;
3996: END Is_Meas_Used_In_Targets;
3997:
3998:

Line 4008: l_flag :=FND_API.G_FALSE;

4004: l_count NUMBER;
4005: l_flag VARCHAR2(10);
4006: l_measure_type VARCHAR2(10);
4007: BEGIN
4008: l_flag :=FND_API.G_FALSE;
4009:
4010: SELECT measure_type
4011: INTO l_measure_type
4012: FROM bis_indicators

Line 4016: l_flag:=FND_API.G_TRUE;

4012: FROM bis_indicators
4013: WHERE dataset_id = p_dataset_id;
4014:
4015: IF((l_measure_type=BSC_UTILITY.C_MEASURE_TYPE_CDS_SCORE) OR (l_measure_type=BSC_UTILITY.C_MEASURE_TYPE_CDS_PERF))THEN
4016: l_flag:=FND_API.G_TRUE;
4017: END IF;
4018: RETURN l_flag;
4019: EXCEPTION
4020: WHEN OTHERS THEN

Line 4037: l_flag := FND_API.G_FALSE;

4033: l_meas_short_name BIS_INDICATORS.short_name%TYPE;
4034: l_flag VARCHAR2(10);
4035: BEGIN
4036:
4037: l_flag := FND_API.G_FALSE;
4038:
4039: SELECT short_name
4040: INTO l_region_code
4041: FROM bsc_kpis_b

Line 4070: l_flag :=FND_API.G_FALSE;

4066: IS
4067: l_flag VARCHAR2(10);
4068: l_measure_type VARCHAR2(10);
4069: BEGIN
4070: l_flag :=FND_API.G_FALSE;
4071:
4072: SELECT measure_type
4073: INTO l_measure_type
4074: FROM bis_indicators

Line 4078: l_flag:=FND_API.G_TRUE;

4074: FROM bis_indicators
4075: WHERE dataset_id = p_dataset_id;
4076:
4077: IF(l_measure_type=BSC_UTILITY.C_MEASURE_SOURCE_CDS_CALC)THEN
4078: l_flag:=FND_API.G_TRUE;
4079: END IF;
4080: RETURN l_flag;
4081:
4082: EXCEPTION

Line 4098: l_flag := FND_API.G_FALSE;

4094: l_flag VARCHAR2(10);
4095: l_attribute2 ak_region_items.attribute2%TYPE;
4096: BEGIN
4097:
4098: l_flag := FND_API.G_FALSE;
4099: l_count := 0;
4100:
4101: SELECT short_name
4102: INTO l_attribute2

Line 4116: l_flag := FND_API.G_TRUE;

4112: AND a.attribute2 = l_attribute2
4113: AND b.attribute10 = BSC_UTILITY.C_MULTIPLE_DATA_SOURCE;
4114:
4115: IF(l_count>0)THEN
4116: l_flag := FND_API.G_TRUE;
4117: END IF;
4118:
4119: RETURN l_flag;
4120: