[Home] [Help]
335: END IF;
336: END LOOP;
337: END IF;
338: IF (l_Count = -1) THEN
339: FND_MESSAGE.SET_NAME('BSC','BSC_V_NO_ANLSIS_DEF_FOR_COMB');
340: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT1', p_Option_ID);
341: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT2', p_Parent_Option_ID);
342: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT3', p_GrandParent_Option_ID);
343: FND_MSG_PUB.ADD;
336: END LOOP;
337: END IF;
338: IF (l_Count = -1) THEN
339: FND_MESSAGE.SET_NAME('BSC','BSC_V_NO_ANLSIS_DEF_FOR_COMB');
340: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT1', p_Option_ID);
341: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT2', p_Parent_Option_ID);
342: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT3', p_GrandParent_Option_ID);
343: FND_MSG_PUB.ADD;
344: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: IF (l_Count = -1) THEN
339: FND_MESSAGE.SET_NAME('BSC','BSC_V_NO_ANLSIS_DEF_FOR_COMB');
340: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT1', p_Option_ID);
341: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT2', p_Parent_Option_ID);
342: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT3', p_GrandParent_Option_ID);
343: FND_MSG_PUB.ADD;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
338: IF (l_Count = -1) THEN
339: FND_MESSAGE.SET_NAME('BSC','BSC_V_NO_ANLSIS_DEF_FOR_COMB');
340: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT1', p_Option_ID);
341: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT2', p_Parent_Option_ID);
342: FND_MESSAGE.SET_TOKEN('ANLSIS_OPT3', p_GrandParent_Option_ID);
343: FND_MSG_PUB.ADD;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346: --dbms_output.PUT_LINE('Exiting from BSC_BIS_KPI_MEAS_PUB.Get_Default_Viewby_For_Measure Procedure');
1395: --dbms_output.PUT_LINE('pick default x_view_by_name <'||x_view_by_name||'>');
1396: -- visuri commented this validation for bug 5080308
1397: /*ELSE
1398: --dbms_output.PUT_LINE('view by problem');
1399: FND_MESSAGE.SET_NAME('BSC','BSC_VIEW_BY_REQUIRED');
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;*/
1402: END IF;
1403: END IF;
1443: END LOOP;
1444: END IF;
1445: END IF;
1446: IF(NOT l_flag) THEN
1447: FND_MESSAGE.SET_NAME('BSC','BSC_TIME_DIM_REQUIRED');
1448: FND_MSG_PUB.ADD;
1449: RAISE FND_API.G_EXC_ERROR;
1450: END IF;
1451: END IF;
1541: x_return_status := FND_API.G_RET_STS_SUCCESS;
1542: SAVEPOINT CreateBSCDimSetPMD;
1543: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set procedure');
1544: IF (p_kpi_id IS NULL) THEN
1545: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1546: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1542: SAVEPOINT CreateBSCDimSetPMD;
1543: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set procedure');
1544: IF (p_kpi_id IS NULL) THEN
1545: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1546: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550: SELECT COUNT(*) INTO l_count
1550: SELECT COUNT(*) INTO l_count
1551: FROM BSC_KPIS_B
1552: WHERE indicator = p_kpi_id;
1553: IF (l_count = 0) THEN
1554: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1555: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1556: FND_MSG_PUB.ADD;
1557: RAISE FND_API.G_EXC_ERROR;
1558: END IF;
1551: FROM BSC_KPIS_B
1552: WHERE indicator = p_kpi_id;
1553: IF (l_count = 0) THEN
1554: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1555: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1556: FND_MSG_PUB.ADD;
1557: RAISE FND_API.G_EXC_ERROR;
1558: END IF;
1559: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id; --varchar2(10)
1564: INTO l_count
1565: FROM BSC_KPIS_B
1566: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
1567: IF (l_count = 2) THEN
1568: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1569: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);
1570: FND_MSG_PUB.ADD;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1565: FROM BSC_KPIS_B
1566: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
1567: IF (l_count = 2) THEN
1568: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1569: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);
1570: FND_MSG_PUB.ADD;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1751: WHERE INDICATOR = p_Kpi_Id;
1752:
1753: l_kpi_name := '['||l_kpi_name||']';
1754:
1755: FND_MESSAGE.SET_NAME('BSC','BSC_IND_DIMOBJ_LIMIT');
1756: FND_MESSAGE.SET_TOKEN('NAME_LIST',l_kpi_name);
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;
1752:
1753: l_kpi_name := '['||l_kpi_name||']';
1754:
1755: FND_MESSAGE.SET_NAME('BSC','BSC_IND_DIMOBJ_LIMIT');
1756: FND_MESSAGE.SET_TOKEN('NAME_LIST',l_kpi_name);
1757: FND_MSG_PUB.ADD;
1758: RAISE FND_API.G_EXC_ERROR;
1759: END IF;
1760:
1833: FND_MSG_PUB.Initialize;
1834: x_return_status := FND_API.G_RET_STS_SUCCESS;
1835: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set procedure');
1836: IF (p_kpi_id IS NULL) THEN
1837: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1838: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1834: x_return_status := FND_API.G_RET_STS_SUCCESS;
1835: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set procedure');
1836: IF (p_kpi_id IS NULL) THEN
1837: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1838: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842:
1907: WHERE INDICATOR = p_Kpi_Id;
1908:
1909: l_kpi_name := '['||l_kpi_name||']';
1910:
1911: FND_MESSAGE.SET_NAME('BSC','BSC_IND_DIMOBJ_LIMIT');
1912: FND_MESSAGE.SET_TOKEN('NAME_LIST',l_kpi_name);
1913: FND_MSG_PUB.ADD;
1914: RAISE FND_API.G_EXC_ERROR;
1915: END IF;
1908:
1909: l_kpi_name := '['||l_kpi_name||']';
1910:
1911: FND_MESSAGE.SET_NAME('BSC','BSC_IND_DIMOBJ_LIMIT');
1912: FND_MESSAGE.SET_TOKEN('NAME_LIST',l_kpi_name);
1913: FND_MSG_PUB.ADD;
1914: RAISE FND_API.G_EXC_ERROR;
1915: END IF;
1916:
1991: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set procedure');
1992: FND_MSG_PUB.Initialize;
1993: x_return_status := FND_API.G_RET_STS_SUCCESS;
1994: IF (p_kpi_id IS NULL) THEN
1995: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1996: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1997: FND_MSG_PUB.ADD;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
1992: FND_MSG_PUB.Initialize;
1993: x_return_status := FND_API.G_RET_STS_SUCCESS;
1994: IF (p_kpi_id IS NULL) THEN
1995: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1996: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1997: FND_MSG_PUB.ADD;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: IF (p_dim_set_id IS NULL) THEN
1997: FND_MSG_PUB.ADD;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: IF (p_dim_set_id IS NULL) THEN
2001: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2002: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2003: FND_MSG_PUB.ADD;
2004: RAISE FND_API.G_EXC_ERROR;
2005: END IF;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: IF (p_dim_set_id IS NULL) THEN
2001: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2002: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2003: FND_MSG_PUB.ADD;
2004: RAISE FND_API.G_EXC_ERROR;
2005: END IF;
2006: SELECT COUNT(DIM_SET_ID)
2008: FROM BSC_KPI_DIM_SETS_VL
2009: WHERE DIM_SET_ID = p_dim_set_id AND INDICATOR = p_kpi_id;
2010:
2011: IF (l_count = 0) THEN
2012: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2013:
2014: SELECT MEANING
2015: INTO l_meaning
2016: FROM BSC_LOOKUPS
2015: INTO l_meaning
2016: FROM BSC_LOOKUPS
2017: WHERE LOOKUP_TYPE = 'BSC_UI_COMMON' AND LOOKUP_CODE = 'DIM_SET' ;
2018:
2019: FND_MESSAGE.SET_TOKEN('TYPE', l_meaning, TRUE);
2020: FND_MSG_PUB.ADD;
2021: RAISE FND_API.G_EXC_ERROR;
2022: END IF;
2023: FOR cd IN p_unassign_dim_names LOOP
2131: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set procedure');
2132: FND_MSG_PUB.Initialize;
2133: x_return_status := FND_API.G_RET_STS_SUCCESS;
2134: IF (p_kpi_id IS NULL) THEN
2135: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2136: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2137: FND_MSG_PUB.ADD;
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2132: FND_MSG_PUB.Initialize;
2133: x_return_status := FND_API.G_RET_STS_SUCCESS;
2134: IF (p_kpi_id IS NULL) THEN
2135: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2136: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2137: FND_MSG_PUB.ADD;
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2140: IF (p_dim_set_id IS NULL) THEN
2137: FND_MSG_PUB.ADD;
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2140: IF (p_dim_set_id IS NULL) THEN
2141: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2142: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2143: FND_MSG_PUB.ADD;
2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2140: IF (p_dim_set_id IS NULL) THEN
2141: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2142: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2143: FND_MSG_PUB.ADD;
2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2146: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id; --number
2150: INTO l_count
2151: FROM BSC_KPIS_B
2152: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
2153: IF (l_count = 2) THEN
2154: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
2155: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);
2156: FND_MSG_PUB.ADD;
2157: RAISE FND_API.G_EXC_ERROR;
2158: END IF;
2151: FROM BSC_KPIS_B
2152: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
2153: IF (l_count = 2) THEN
2154: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
2155: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);
2156: FND_MSG_PUB.ADD;
2157: RAISE FND_API.G_EXC_ERROR;
2158: END IF;
2159: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id; --number
2165: FROM BSC_KPI_DIM_SETS_VL
2166: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2167: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2168: IF (l_count = 0) THEN
2169: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2170: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2171: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2172: FND_MSG_PUB.ADD;
2173: RAISE FND_API.G_EXC_ERROR;
2166: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2167: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2168: IF (l_count = 0) THEN
2169: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2170: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2171: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2172: FND_MSG_PUB.ADD;
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2167: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2168: IF (l_count = 0) THEN
2169: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2170: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2171: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2172: FND_MSG_PUB.ADD;
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2175:
2220: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
2221: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2222: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2223: IF (l_count = 0) THEN
2224: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2225: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2226: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2227: FND_MSG_PUB.ADD;
2228: RAISE FND_API.G_EXC_ERROR;
2221: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2222: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2223: IF (l_count = 0) THEN
2224: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2225: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2226: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2227: FND_MSG_PUB.ADD;
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2222: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2223: IF (l_count = 0) THEN
2224: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2225: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2226: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2227: FND_MSG_PUB.ADD;
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2230: -- START Granular Locking
2402: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Set procedure');
2403: FND_MSG_PUB.Initialize;
2404: x_return_status := FND_API.G_RET_STS_SUCCESS;
2405: IF (p_kpi_id IS NULL) THEN
2406: FND_MESSAGE.SET_NAME('BSC', 'BSC_REQ_FIELD_MISSING');
2407: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2403: FND_MSG_PUB.Initialize;
2404: x_return_status := FND_API.G_RET_STS_SUCCESS;
2405: IF (p_kpi_id IS NULL) THEN
2406: FND_MESSAGE.SET_NAME('BSC', 'BSC_REQ_FIELD_MISSING');
2407: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411: IF (p_dim_set_id IS NULL) THEN
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411: IF (p_dim_set_id IS NULL) THEN
2412: FND_MESSAGE.SET_NAME('BSC', 'BSC_REQ_FIELD_MISSING');
2413: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2414: FND_MSG_PUB.ADD;
2415: RAISE FND_API.G_EXC_ERROR;
2416: END IF;
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411: IF (p_dim_set_id IS NULL) THEN
2412: FND_MESSAGE.SET_NAME('BSC', 'BSC_REQ_FIELD_MISSING');
2413: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2414: FND_MSG_PUB.ADD;
2415: RAISE FND_API.G_EXC_ERROR;
2416: END IF;
2417: IF (p_dim_set_id = 0) THEN
2414: FND_MSG_PUB.ADD;
2415: RAISE FND_API.G_EXC_ERROR;
2416: END IF;
2417: IF (p_dim_set_id = 0) THEN
2418: FND_MESSAGE.SET_NAME('BSC', 'BSC_DIM_SET_0_NO_DELETE');
2419: FND_MSG_PUB.ADD;
2420: RAISE FND_API.G_EXC_ERROR;
2421: END IF;
2422: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id; --number
2426: INTO l_count
2427: FROM BSC_KPIS_B
2428: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
2429: IF (l_count = 2) THEN
2430: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
2431: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);
2432: FND_MSG_PUB.ADD;
2433: RAISE FND_API.G_EXC_ERROR;
2434: END IF;
2427: FROM BSC_KPIS_B
2428: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id ;
2429: IF (l_count = 2) THEN
2430: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
2431: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_bsc_dimset_rec.Bsc_Kpi_Id);
2432: FND_MSG_PUB.ADD;
2433: RAISE FND_API.G_EXC_ERROR;
2434: END IF;
2435: SELECT COUNT(*) INTO l_count
2435: SELECT COUNT(*) INTO l_count
2436: FROM BSC_KPI_DIM_SETS_VL
2437: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id;
2438: IF (l_count = 1) THEN
2439: FND_MESSAGE.SET_NAME('BSC','BSC_D_KPI_AT_LEAST_1_DS');
2440: FND_MSG_PUB.ADD;
2441: RAISE FND_API.G_EXC_ERROR;
2442: END IF;
2443: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id; --number
2608: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Assign_Dims_To_Dim_Set procedure');
2609: FND_MSG_PUB.Initialize;
2610: x_return_status := FND_API.G_RET_STS_SUCCESS;
2611: IF (p_kpi_id IS NULL) THEN
2612: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2613: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2614: FND_MSG_PUB.ADD;
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2609: FND_MSG_PUB.Initialize;
2610: x_return_status := FND_API.G_RET_STS_SUCCESS;
2611: IF (p_kpi_id IS NULL) THEN
2612: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2613: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2614: FND_MSG_PUB.ADD;
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2617: IF (p_dim_set_id IS NULL) THEN
2614: FND_MSG_PUB.ADD;
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2617: IF (p_dim_set_id IS NULL) THEN
2618: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2619: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: END IF;
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2617: IF (p_dim_set_id IS NULL) THEN
2618: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2619: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: END IF;
2623: SELECT
2652: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
2653: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2654: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2655: IF (l_count = 0) THEN
2656: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2657: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2658: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2659: FND_MSG_PUB.ADD;
2660: RAISE FND_API.G_EXC_ERROR;
2653: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2654: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2655: IF (l_count = 0) THEN
2656: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2657: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2658: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2659: FND_MSG_PUB.ADD;
2660: RAISE FND_API.G_EXC_ERROR;
2661: END IF;
2654: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2655: IF (l_count = 0) THEN
2656: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2657: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2658: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2659: FND_MSG_PUB.ADD;
2660: RAISE FND_API.G_EXC_ERROR;
2661: END IF;
2662:
2682: SELECT COUNT(*) INTO l_count
2683: FROM BSC_SYS_DIM_GROUPS_VL
2684: WHERE short_name = l_dim_short_name;
2685: IF (l_count = 0) THEN
2686: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
2687: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dim_short_name);
2688: FND_MSG_PUB.ADD;
2689: RAISE FND_API.G_EXC_ERROR;
2690: END IF;
2683: FROM BSC_SYS_DIM_GROUPS_VL
2684: WHERE short_name = l_dim_short_name;
2685: IF (l_count = 0) THEN
2686: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
2687: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME', l_dim_short_name);
2688: FND_MSG_PUB.ADD;
2689: RAISE FND_API.G_EXC_ERROR;
2690: END IF;
2691:
2751: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
2752: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2753: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2754: IF (l_count = 0) THEN
2755: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2756: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2757: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2758: FND_MSG_PUB.ADD;
2759: RAISE FND_API.G_EXC_ERROR;
2752: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
2753: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2754: IF (l_count = 0) THEN
2755: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2756: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2757: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2758: FND_MSG_PUB.ADD;
2759: RAISE FND_API.G_EXC_ERROR;
2760: END IF;
2753: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
2754: IF (l_count = 0) THEN
2755: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
2756: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
2757: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
2758: FND_MSG_PUB.ADD;
2759: RAISE FND_API.G_EXC_ERROR;
2760: END IF;
2761: -- START Granular Locking
2942: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Assign_Unassign_Dimensions procedure');
2943: FND_MSG_PUB.Initialize;
2944: x_return_status := FND_API.G_RET_STS_SUCCESS;
2945: IF (p_kpi_id IS NULL) THEN
2946: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2947: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2943: FND_MSG_PUB.Initialize;
2944: x_return_status := FND_API.G_RET_STS_SUCCESS;
2945: IF (p_kpi_id IS NULL) THEN
2946: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2947: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951: IF (p_dim_set_id IS NULL) THEN
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951: IF (p_dim_set_id IS NULL) THEN
2952: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2953: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2954: FND_MSG_PUB.ADD;
2955: RAISE FND_API.G_EXC_ERROR;
2956: END IF;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951: IF (p_dim_set_id IS NULL) THEN
2952: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2953: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2954: FND_MSG_PUB.ADD;
2955: RAISE FND_API.G_EXC_ERROR;
2956: END IF;
2957:
3150: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Unassign_Dims_From_Dim_Set procedure');
3151: FND_MSG_PUB.Initialize;
3152: x_return_status := FND_API.G_RET_STS_SUCCESS;
3153: IF (p_kpi_id IS NULL) THEN
3154: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3155: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_ERROR;
3158: END IF;
3151: FND_MSG_PUB.Initialize;
3152: x_return_status := FND_API.G_RET_STS_SUCCESS;
3153: IF (p_kpi_id IS NULL) THEN
3154: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3155: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_ERROR;
3158: END IF;
3159: IF (p_dim_set_id IS NULL) THEN
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_ERROR;
3158: END IF;
3159: IF (p_dim_set_id IS NULL) THEN
3160: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3161: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
3162: FND_MSG_PUB.ADD;
3163: RAISE FND_API.G_EXC_ERROR;
3164: END IF;
3157: RAISE FND_API.G_EXC_ERROR;
3158: END IF;
3159: IF (p_dim_set_id IS NULL) THEN
3160: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3161: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
3162: FND_MSG_PUB.ADD;
3163: RAISE FND_API.G_EXC_ERROR;
3164: END IF;
3165: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id; --number
3170: INTO l_count
3171: FROM BSC_KPIS_B
3172: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id;
3173: IF (l_count = 2) THEN
3174: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
3175: FND_MSG_PUB.ADD;
3176: RAISE FND_API.G_EXC_ERROR;
3177: END IF;
3178: l_bsc_dimset_rec.Bsc_Dim_Set_Id := p_dim_set_id; --number
3181: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
3182: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3183: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3184: IF (l_count = 0) THEN
3185: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3186: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3187: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3182: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3183: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3184: IF (l_count = 0) THEN
3185: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3186: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3187: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: END IF;
3183: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3184: IF (l_count = 0) THEN
3185: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3186: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3187: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3188: FND_MSG_PUB.ADD;
3189: RAISE FND_API.G_EXC_ERROR;
3190: END IF;
3191: -- START Granular Locking
3668: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Assign_DSet_Analysis_Options procedure');
3669: FND_MSG_PUB.Initialize;
3670: x_return_status := FND_API.G_RET_STS_SUCCESS;
3671: IF (p_kpi_id IS NULL) THEN
3672: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3673: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3669: FND_MSG_PUB.Initialize;
3670: x_return_status := FND_API.G_RET_STS_SUCCESS;
3671: IF (p_kpi_id IS NULL) THEN
3672: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3673: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: IF (p_dim_set_id IS NULL) THEN
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: IF (p_dim_set_id IS NULL) THEN
3678: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3679: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: IF (p_dim_set_id IS NULL) THEN
3678: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3679: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3683: IF (p_analysis_grp_id IS NULL) THEN
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3683: IF (p_analysis_grp_id IS NULL) THEN
3684: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3685: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'Analysis Group ID');
3686: FND_MSG_PUB.ADD;
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3683: IF (p_analysis_grp_id IS NULL) THEN
3684: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3685: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'Analysis Group ID');
3686: FND_MSG_PUB.ADD;
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;
3689: IF (p_option_id IS NULL) THEN
3686: FND_MSG_PUB.ADD;
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;
3689: IF (p_option_id IS NULL) THEN
3690: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3691: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'Option ID');
3692: FND_MSG_PUB.ADD;
3693: RAISE FND_API.G_EXC_ERROR;
3694: END IF;
3687: RAISE FND_API.G_EXC_ERROR;
3688: END IF;
3689: IF (p_option_id IS NULL) THEN
3690: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3691: FND_MESSAGE.SET_TOKEN('FIELD_NAME', 'Option ID');
3692: FND_MSG_PUB.ADD;
3693: RAISE FND_API.G_EXC_ERROR;
3694: END IF;
3695: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id; --number
3713: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
3714: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3715: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3716: IF (l_count = 0) THEN
3717: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3718: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3719: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3720: FND_MSG_PUB.ADD;
3721: RAISE FND_API.G_EXC_ERROR;
3714: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3715: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3716: IF (l_count = 0) THEN
3717: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3718: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3719: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3720: FND_MSG_PUB.ADD;
3721: RAISE FND_API.G_EXC_ERROR;
3722: END IF;
3715: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3716: IF (l_count = 0) THEN
3717: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3718: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3719: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3720: FND_MSG_PUB.ADD;
3721: RAISE FND_API.G_EXC_ERROR;
3722: END IF;
3723: BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B
3741: SELECT COUNT(*) INTO l_count FROM BSC_KPI_DIM_SETS_VL
3742: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3743: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3744: IF (l_count = 0) THEN
3745: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3746: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3747: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3748: FND_MSG_PUB.ADD;
3749: RAISE FND_API.G_EXC_ERROR;
3742: WHERE indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
3743: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3744: IF (l_count = 0) THEN
3745: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3746: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3747: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3748: FND_MSG_PUB.ADD;
3749: RAISE FND_API.G_EXC_ERROR;
3750: END IF;
3743: AND dim_set_id = l_bsc_dimset_rec.Bsc_Dim_Set_Id;
3744: IF (l_count = 0) THEN
3745: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
3746: FND_MESSAGE.SET_TOKEN('KPI_ID', l_bsc_dimset_rec.Bsc_Kpi_Id);
3747: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_bsc_dimset_rec.Bsc_Dim_Set_Id);
3748: FND_MSG_PUB.ADD;
3749: RAISE FND_API.G_EXC_ERROR;
3750: END IF;
3751: BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B
4200: FETCH c_stack_series_id INTO l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Stack_Series_Id;
4201: CLOSE c_stack_series_id;
4202: END IF;
4203: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
4204: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4205: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
4206: FND_MSG_PUB.ADD;
4207: RAISE FND_API.G_EXC_ERROR;
4208: END IF;
4201: CLOSE c_stack_series_id;
4202: END IF;
4203: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
4204: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4205: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
4206: FND_MSG_PUB.ADD;
4207: RAISE FND_API.G_EXC_ERROR;
4208: END IF;
4209: IF (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL) THEN
4214: FETCH c_data_set_id INTO l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id;
4215: CLOSE c_data_set_id;
4216: END IF;
4217: IF (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL) THEN
4218: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4219: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DATASET'), TRUE);
4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_ERROR;
4222: END IF;
4215: CLOSE c_data_set_id;
4216: END IF;
4217: IF (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL) THEN
4218: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4219: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DATASET'), TRUE);
4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_ERROR;
4222: END IF;
4223: SELECT COUNT(*) INTO l_count
4223: SELECT COUNT(*) INTO l_count
4224: FROM BSC_KPIS_B
4225: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4226: IF (l_count = 0) THEN
4227: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
4228: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
4229: FND_MSG_PUB.ADD;
4230: RAISE FND_API.G_EXC_ERROR;
4231: END IF;
4224: FROM BSC_KPIS_B
4225: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4226: IF (l_count = 0) THEN
4227: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
4228: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
4229: FND_MSG_PUB.ADD;
4230: RAISE FND_API.G_EXC_ERROR;
4231: END IF;
4232: -- Verify that this is not a Shared KPI.
4233: SELECT share_flag INTO l_count
4234: FROM BSC_KPIS_B
4235: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id ;
4236: IF (l_count = 2) THEN
4237: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
4238: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4239: FND_MSG_PUB.ADD;
4240: RAISE FND_API.G_EXC_ERROR;
4241: END IF;
4234: FROM BSC_KPIS_B
4235: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id ;
4236: IF (l_count = 2) THEN
4237: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
4238: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4239: FND_MSG_PUB.ADD;
4240: RAISE FND_API.G_EXC_ERROR;
4241: END IF;
4242:
4255: --dbms_output.PUT_LINE('l_data_set_id <'||l_data_set_id||'>');
4256: IF ((l_temp_data_source IS NOT NULL) AND
4257: (((l_data_source <> l_temp_data_source) AND (l_data_set_id <> -1)) OR
4258: ((l_data_set_id <> -1) AND (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id = -1)))) THEN
4259: FND_MESSAGE.SET_NAME('BSC','BSC_NO_UPDATE_MEASURE_SOURCE');
4260: FND_MSG_PUB.ADD;
4261: RAISE FND_API.G_EXC_ERROR;
4262: ELSIF (l_temp_data_source IS NULL) THEN
4263: FND_MESSAGE.SET_NAME('BSC','BSC_V_NO_MEASURE_BY_DIM_SET');
4259: FND_MESSAGE.SET_NAME('BSC','BSC_NO_UPDATE_MEASURE_SOURCE');
4260: FND_MSG_PUB.ADD;
4261: RAISE FND_API.G_EXC_ERROR;
4262: ELSIF (l_temp_data_source IS NULL) THEN
4263: FND_MESSAGE.SET_NAME('BSC','BSC_V_NO_MEASURE_BY_DIM_SET');
4264: FND_MESSAGE.SET_TOKEN('DIM_SET', l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id);
4265: FND_MSG_PUB.ADD;
4266: RAISE FND_API.G_EXC_ERROR;
4267: END IF;
4260: FND_MSG_PUB.ADD;
4261: RAISE FND_API.G_EXC_ERROR;
4262: ELSIF (l_temp_data_source IS NULL) THEN
4263: FND_MESSAGE.SET_NAME('BSC','BSC_V_NO_MEASURE_BY_DIM_SET');
4264: FND_MESSAGE.SET_TOKEN('DIM_SET', l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id);
4265: FND_MSG_PUB.ADD;
4266: RAISE FND_API.G_EXC_ERROR;
4267: END IF;
4268: END IF;
4483: FROM BSC_KPI_DIM_SETS_VL
4484: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4485: AND dim_set_id = l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id;
4486: IF (l_count = 0) THEN
4487: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
4488: FND_MESSAGE.SET_TOKEN('KPI_ID', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4489: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id);
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_ERROR;
4484: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id
4485: AND dim_set_id = l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id;
4486: IF (l_count = 0) THEN
4487: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
4488: FND_MESSAGE.SET_TOKEN('KPI_ID', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4489: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id);
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_ERROR;
4492: END IF;
4485: AND dim_set_id = l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id;
4486: IF (l_count = 0) THEN
4487: FND_MESSAGE.SET_NAME('BSC', 'BSC_INCORRECT_KPI_DIMSET');
4488: FND_MESSAGE.SET_TOKEN('KPI_ID', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4489: FND_MESSAGE.SET_TOKEN('DIM_SET_ID', l_Bsc_Anal_Opt_Rec.Bsc_Dim_Set_Id);
4490: FND_MSG_PUB.ADD;
4491: RAISE FND_API.G_EXC_ERROR;
4492: END IF;
4493: --dbms_output.PUT_LINE('ASSIGN TO DIMENSION SET');
4687: END IF;
4688: ELSE
4689: --dbms_output.PUT_LINE('ELSE');
4690: IF (l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name IS NULL) THEN
4691: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4692: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'ANALYSIS_MS'), TRUE);
4693: FND_MSG_PUB.ADD;
4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;
4688: ELSE
4689: --dbms_output.PUT_LINE('ELSE');
4690: IF (l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name IS NULL) THEN
4691: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4692: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'ANALYSIS_MS'), TRUE);
4693: FND_MSG_PUB.ADD;
4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;
4696: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN
5021: OPEN c_data_source;
5022: FETCH c_data_source INTO l_datasource;
5023: CLOSE c_data_source;
5024: IF (l_datasource IS NULL) THEN
5025: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5026: SELECT MEANING INTO l_meaning
5027: FROM BSC_LOOKUPS
5028: WHERE LOOKUP_TYPE = 'BSC_UI_COMMON' AND LOOKUP_CODE = 'EDW_MEASURE' ;
5029: FND_MESSAGE.SET_TOKEN('TYPE', l_meaning, TRUE);
5025: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5026: SELECT MEANING INTO l_meaning
5027: FROM BSC_LOOKUPS
5028: WHERE LOOKUP_TYPE = 'BSC_UI_COMMON' AND LOOKUP_CODE = 'EDW_MEASURE' ;
5029: FND_MESSAGE.SET_TOKEN('TYPE', l_meaning, TRUE);
5030: FND_MSG_PUB.ADD;
5031: RAISE FND_API.G_EXC_ERROR;
5032: END IF;
5033: IF ((l_datasource <> 'BSC') AND (l_datasource <> 'PMF')) THEN
5030: FND_MSG_PUB.ADD;
5031: RAISE FND_API.G_EXC_ERROR;
5032: END IF;
5033: IF ((l_datasource <> 'BSC') AND (l_datasource <> 'PMF')) THEN
5034: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DATA_SOURCE');
5035: FND_MSG_PUB.ADD;
5036: RAISE FND_API.G_EXC_ERROR;
5037: END IF;
5038: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL
5056:
5057: l_Bsc_Anal_Opt_Rec.Bsc_Option_Short_Name := p_Short_Name;
5058:
5059: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
5060: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5061: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5062: FND_MSG_PUB.ADD;
5063: RAISE FND_API.G_EXC_ERROR;
5064: END IF;
5057: l_Bsc_Anal_Opt_Rec.Bsc_Option_Short_Name := p_Short_Name;
5058:
5059: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
5060: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5061: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5062: FND_MSG_PUB.ADD;
5063: RAISE FND_API.G_EXC_ERROR;
5064: END IF;
5065: IF ((l_datasource = 'BSC') AND (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL)) THEN
5062: FND_MSG_PUB.ADD;
5063: RAISE FND_API.G_EXC_ERROR;
5064: END IF;
5065: IF ((l_datasource = 'BSC') AND (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL)) THEN
5066: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5067: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DATASET'), TRUE);
5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_ERROR;
5070: END IF;
5063: RAISE FND_API.G_EXC_ERROR;
5064: END IF;
5065: IF ((l_datasource = 'BSC') AND (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL)) THEN
5066: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5067: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DATASET'), TRUE);
5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_ERROR;
5070: END IF;
5071: SELECT COUNT(*) INTO l_count
5071: SELECT COUNT(*) INTO l_count
5072: FROM BSC_KPIS_B
5073: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5074: IF (l_count = 0) THEN
5075: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5076: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5077: FND_MSG_PUB.ADD;
5078: RAISE FND_API.G_EXC_ERROR;
5079: END IF;
5072: FROM BSC_KPIS_B
5073: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5074: IF (l_count = 0) THEN
5075: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5076: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5077: FND_MSG_PUB.ADD;
5078: RAISE FND_API.G_EXC_ERROR;
5079: END IF;
5080: -- Verify that this is not a Shared KPI.
5081: SELECT share_flag INTO l_count
5082: FROM BSC_KPIS_B
5083: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id ;
5084: IF (l_count = 2) THEN
5085: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
5086: FND_MSG_PUB.ADD;
5087: RAISE FND_API.G_EXC_ERROR;
5088: END IF;
5089: --dbms_output.PUT_LINE('l_datasource '||l_datasource);
5087: RAISE FND_API.G_EXC_ERROR;
5088: END IF;
5089: --dbms_output.PUT_LINE('l_datasource '||l_datasource);
5090: IF (l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name IS NULL) THEN
5091: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5092: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'ANALYSIS_MS'), TRUE);
5093: FND_MSG_PUB.ADD;
5094: RAISE FND_API.G_EXC_ERROR;
5095: END IF;
5088: END IF;
5089: --dbms_output.PUT_LINE('l_datasource '||l_datasource);
5090: IF (l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name IS NULL) THEN
5091: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5092: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'ANALYSIS_MS'), TRUE);
5093: FND_MSG_PUB.ADD;
5094: RAISE FND_API.G_EXC_ERROR;
5095: END IF;
5096: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN
5352: FND_MSG_PUB.Initialize;
5353: x_return_status := FND_API.G_RET_STS_SUCCESS;
5354: SAVEPOINT DeleteBSCKPIAnaOpts;
5355: IF (p_data_source IS NULL) THEN
5356: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5357: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);
5358: FND_MSG_PUB.ADD;
5359: RAISE FND_API.G_EXC_ERROR;
5360: END IF;
5353: x_return_status := FND_API.G_RET_STS_SUCCESS;
5354: SAVEPOINT DeleteBSCKPIAnaOpts;
5355: IF (p_data_source IS NULL) THEN
5356: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5357: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);
5358: FND_MSG_PUB.ADD;
5359: RAISE FND_API.G_EXC_ERROR;
5360: END IF;
5361: IF ((p_data_source <> 'BSC') AND (p_data_source <> 'PMF')) THEN
5358: FND_MSG_PUB.ADD;
5359: RAISE FND_API.G_EXC_ERROR;
5360: END IF;
5361: IF ((p_data_source <> 'BSC') AND (p_data_source <> 'PMF')) THEN
5362: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DATA_SOURCE');
5363: FND_MSG_PUB.ADD;
5364: RAISE FND_API.G_EXC_ERROR;
5365: END IF;
5366: --Initialize record for BSC_KPI_ANALYSIS_MEASURES_B/TL &BSC_KPI_ANALYSIS_OPTIONS_B/TL
5386: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5387: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id);
5388: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);
5389: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
5390: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5391: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_ERROR;
5394: END IF;
5387: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id);
5388: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);
5389: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
5390: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5391: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_ERROR;
5394: END IF;
5395:
5396: SELECT COUNT(*) INTO l_count
5397: FROM BSC_KPIS_B
5398: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5399: IF (l_count = 0) THEN
5400: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5401: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5402: FND_MSG_PUB.ADD;
5403: RAISE FND_API.G_EXC_ERROR;
5404: END IF;
5397: FROM BSC_KPIS_B
5398: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5399: IF (l_count = 0) THEN
5400: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5401: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5402: FND_MSG_PUB.ADD;
5403: RAISE FND_API.G_EXC_ERROR;
5404: END IF;
5405: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN
5402: FND_MSG_PUB.ADD;
5403: RAISE FND_API.G_EXC_ERROR;
5404: END IF;
5405: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN
5406: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5407: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_OPTIONS'), TRUE);
5408: FND_MSG_PUB.ADD;
5409: RAISE FND_API.G_EXC_ERROR;
5410: END IF;
5403: RAISE FND_API.G_EXC_ERROR;
5404: END IF;
5405: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN
5406: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5407: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_OPTIONS'), TRUE);
5408: FND_MSG_PUB.ADD;
5409: RAISE FND_API.G_EXC_ERROR;
5410: END IF;
5411: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN
5408: FND_MSG_PUB.ADD;
5409: RAISE FND_API.G_EXC_ERROR;
5410: END IF;
5411: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN
5412: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5413: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_GROUP'), TRUE);
5414: FND_MSG_PUB.ADD;
5415: RAISE FND_API.G_EXC_ERROR;
5416: END IF;
5409: RAISE FND_API.G_EXC_ERROR;
5410: END IF;
5411: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN
5412: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5413: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_GROUP'), TRUE);
5414: FND_MSG_PUB.ADD;
5415: RAISE FND_API.G_EXC_ERROR;
5416: END IF;
5417: -- Verify that this is not a Shared KPI.
5418: SELECT share_flag INTO l_count
5419: FROM BSC_KPIS_B
5420: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id ;
5421: IF (l_count = 2) THEN
5422: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
5423: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_ERROR;
5426: END IF;
5419: FROM BSC_KPIS_B
5420: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id ;
5421: IF (l_count = 2) THEN
5422: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
5423: --FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5424: FND_MSG_PUB.ADD;
5425: RAISE FND_API.G_EXC_ERROR;
5426: END IF;
5427: --Determine if Indicator assigned to a tab.
5799: SAVEPOINT UpdatePMDBSCKPIs;
5800: x_return_status := FND_API.G_RET_STS_SUCCESS;
5801: FND_MSG_PUB.Initialize;
5802: IF (p_kpi_id IS NULL) THEN
5803: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5804: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;
5807: END IF;
5800: x_return_status := FND_API.G_RET_STS_SUCCESS;
5801: FND_MSG_PUB.Initialize;
5802: IF (p_kpi_id IS NULL) THEN
5803: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5804: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;
5807: END IF;
5808: SELECT COUNT(*) INTO l_count
5808: SELECT COUNT(*) INTO l_count
5809: FROM BSC_KPIS_B
5810: WHERE indicator = p_kpi_id;
5811: IF (l_count = 0) THEN
5812: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5813: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5814: FND_MSG_PUB.ADD;
5815: RAISE FND_API.G_EXC_ERROR;
5816: END IF;
5809: FROM BSC_KPIS_B
5810: WHERE indicator = p_kpi_id;
5811: IF (l_count = 0) THEN
5812: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5813: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5814: FND_MSG_PUB.ADD;
5815: RAISE FND_API.G_EXC_ERROR;
5816: END IF;
5817: -- Verify that this is not a Shared KPI.
5819: INTO l_count
5820: FROM bsc_kpis_b
5821: WHERE indicator = p_kpi_id ;
5822: IF (l_count = 2) THEN
5823: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
5824: --FND_MESSAGE.SET_TOKEN('BSC_KPI', p_kpi_id);
5825: FND_MSG_PUB.ADD;
5826: RAISE FND_API.G_EXC_ERROR;
5827: END IF;
5820: FROM bsc_kpis_b
5821: WHERE indicator = p_kpi_id ;
5822: IF (l_count = 2) THEN
5823: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
5824: --FND_MESSAGE.SET_TOKEN('BSC_KPI', p_kpi_id);
5825: FND_MSG_PUB.ADD;
5826: RAISE FND_API.G_EXC_ERROR;
5827: END IF;
5828: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_kpi_id;
5890: ,bsc_tab_indicators w
5891: WHERE v.tab_id =w.tab_id
5892: AND w.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5893:
5894: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
5895: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_kpi_name);
5896: FND_MESSAGE.SET_TOKEN('Tab name: ', l_tab_name);
5897: FND_MSG_PUB.ADD;
5898: RAISE FND_API.G_EXC_ERROR;
5891: WHERE v.tab_id =w.tab_id
5892: AND w.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5893:
5894: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
5895: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_kpi_name);
5896: FND_MESSAGE.SET_TOKEN('Tab name: ', l_tab_name);
5897: FND_MSG_PUB.ADD;
5898: RAISE FND_API.G_EXC_ERROR;
5899: END IF;
5892: AND w.indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
5893:
5894: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
5895: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_kpi_name);
5896: FND_MESSAGE.SET_TOKEN('Tab name: ', l_tab_name);
5897: FND_MSG_PUB.ADD;
5898: RAISE FND_API.G_EXC_ERROR;
5899: END IF;
5900:
6051: x_return_status := FND_API.G_RET_STS_SUCCESS;
6052: FND_MSG_PUB.Initialize;
6053: SAVEPOINT CreatePMDBSCKPIs;
6054: IF (p_kpi_name IS NULL) THEN
6055: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
6056: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_NAME'), TRUE);
6057: FND_MSG_PUB.ADD;
6058: RAISE FND_API.G_EXC_ERROR;
6059: END IF;
6052: FND_MSG_PUB.Initialize;
6053: SAVEPOINT CreatePMDBSCKPIs;
6054: IF (p_kpi_name IS NULL) THEN
6055: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
6056: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_NAME'), TRUE);
6057: FND_MSG_PUB.ADD;
6058: RAISE FND_API.G_EXC_ERROR;
6059: END IF;
6060: IF (p_responsibility_id IS NULL) THEN
6057: FND_MSG_PUB.ADD;
6058: RAISE FND_API.G_EXC_ERROR;
6059: END IF;
6060: IF (p_responsibility_id IS NULL) THEN
6061: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
6062: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'SRC_RESPONSIBILITY'), TRUE);
6063: FND_MSG_PUB.ADD;
6064: RAISE FND_API.G_EXC_ERROR;
6065: END IF;
6058: RAISE FND_API.G_EXC_ERROR;
6059: END IF;
6060: IF (p_responsibility_id IS NULL) THEN
6061: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
6062: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'SRC_RESPONSIBILITY'), TRUE);
6063: FND_MSG_PUB.ADD;
6064: RAISE FND_API.G_EXC_ERROR;
6065: END IF;
6066: -- set the passed values to the record.
6269: AND Analysis_Option2 = p_Option_2
6270: and Series_Id = p_Sid;
6271:
6272: IF(l_tokens IS NOT NULL) THEN
6273: FND_MESSAGE.SET_NAME('BSC','BSC_MEAS_DELETE_DEPEND');
6274: FND_MESSAGE.SET_TOKEN('MEASURE', l_tokens);
6275: FND_MSG_PUB.ADD;
6276: RAISE FND_API.G_EXC_ERROR;
6277: END IF;
6270: and Series_Id = p_Sid;
6271:
6272: IF(l_tokens IS NOT NULL) THEN
6273: FND_MESSAGE.SET_NAME('BSC','BSC_MEAS_DELETE_DEPEND');
6274: FND_MESSAGE.SET_TOKEN('MEASURE', l_tokens);
6275: FND_MSG_PUB.ADD;
6276: RAISE FND_API.G_EXC_ERROR;
6277: END IF;
6278:
6395: AND KPI_GROUP.Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
6396: GROUP BY SYS_DIM_LEL.Dim_Level_Id);
6397: --dbms_output.PUT_LINE('l_count '||l_count);
6398: IF (l_count > 1) THEN
6399: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_COMMON_DIM_OBJS');
6400: FND_MSG_PUB.ADD;
6401: RAISE FND_API.G_EXC_ERROR;
6402: END IF;
6403:
6510: AND KPI_GROUP.Indicator = l_bsc_dimset_rec.Bsc_Kpi_Id
6511: AND KPI_GROUP.Dim_Set_Id = l_bsc_dimset_rec.Bsc_Dim_Set_Id
6512: GROUP BY SYS_DIM_LEL.Dim_Level_Id);
6513: IF (l_count > 1) THEN
6514: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_COMMON_DIM_OBJS');
6515: FND_MSG_PUB.ADD;
6516: RAISE FND_API.G_EXC_ERROR;
6517: END IF;
6518: FOR cn_bsc IN c_dim_group_id LOOP
6885: END IF;
6886: END LOOP;
6887: IF (l_kpi_names IS NOT NULL) THEN
6888: --raise exception for Structural Changes
6889: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
6890: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
6891: FND_MSG_PUB.ADD;
6892: RAISE FND_API.G_EXC_ERROR;
6893: END IF;
6886: END LOOP;
6887: IF (l_kpi_names IS NOT NULL) THEN
6888: --raise exception for Structural Changes
6889: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
6890: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
6891: FND_MSG_PUB.ADD;
6892: RAISE FND_API.G_EXC_ERROR;
6893: END IF;
6894: --dbms_output.PUT_LINE('Exiting from BSC_BIS_KPI_MEAS_PUB.get_KPIs Function');
7207: AND INSTR(l_final_dim_names,','||vl.short_name ||',')>0 ;
7208: --dbms_output.PUT_LINE('THE COUNT OF DIMOBJECTS :- '||l_count );
7209: IF(l_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIM) THEN
7210: --dbms_output.PUT_LINE('DIMESION OBJECTS MESSAEGE' );
7211: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
7212: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7213: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7214: FND_MSG_PUB.ADD;
7215: RAISE FND_API.G_EXC_ERROR;
7208: --dbms_output.PUT_LINE('THE COUNT OF DIMOBJECTS :- '||l_count );
7209: IF(l_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIM) THEN
7210: --dbms_output.PUT_LINE('DIMESION OBJECTS MESSAEGE' );
7211: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
7212: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7213: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7214: FND_MSG_PUB.ADD;
7215: RAISE FND_API.G_EXC_ERROR;
7216: END IF;
7209: IF(l_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIM) THEN
7210: --dbms_output.PUT_LINE('DIMESION OBJECTS MESSAEGE' );
7211: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
7212: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7213: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7214: FND_MSG_PUB.ADD;
7215: RAISE FND_API.G_EXC_ERROR;
7216: END IF;
7217:
7219: FROM BSC_KPI_DIM_SETS_VL
7220: WHERE INDICATOR = p_Kpi_ID;
7221: IF (l_dim_set_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET ) THEN
7222: --dbms_output.PUT_LINE('FIRST dimset IF LOOP' );
7223: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7224: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7225: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;
7220: WHERE INDICATOR = p_Kpi_ID;
7221: IF (l_dim_set_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET ) THEN
7222: --dbms_output.PUT_LINE('FIRST dimset IF LOOP' );
7223: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7224: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7225: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;
7228: END IF;
7221: IF (l_dim_set_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET ) THEN
7222: --dbms_output.PUT_LINE('FIRST dimset IF LOOP' );
7223: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7224: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7225: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;
7228: END IF;
7229: --dbms_output.PUT_LINE('DIM SET COUNT :- '||l_dim_set_count );
7228: END IF;
7229: --dbms_output.PUT_LINE('DIM SET COUNT :- '||l_dim_set_count );
7230: IF(l_dim_set_count = BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET AND p_Dim_Set_ID IS NULL ) THEN
7231: --dbms_output.PUT_LINE('dimset IF LOOP' );
7232: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7233: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7234: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7235: FND_MSG_PUB.ADD;
7236: RAISE FND_API.G_EXC_ERROR;
7229: --dbms_output.PUT_LINE('DIM SET COUNT :- '||l_dim_set_count );
7230: IF(l_dim_set_count = BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET AND p_Dim_Set_ID IS NULL ) THEN
7231: --dbms_output.PUT_LINE('dimset IF LOOP' );
7232: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7233: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7234: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7235: FND_MSG_PUB.ADD;
7236: RAISE FND_API.G_EXC_ERROR;
7237: END IF;
7230: IF(l_dim_set_count = BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET AND p_Dim_Set_ID IS NULL ) THEN
7231: --dbms_output.PUT_LINE('dimset IF LOOP' );
7232: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7233: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7234: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7235: FND_MSG_PUB.ADD;
7236: RAISE FND_API.G_EXC_ERROR;
7237: END IF;
7238:
7260: l_no_rels := get_no_rels(p_dim_obj_sht_names => l_dimobj_name_rel);
7261: --dbms_output.PUT_LINE('THE NO OF RELATIONS ARE :- '||l_no_rels );
7262: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
7263: --dbms_output.PUT_LINE('RELATIONS MESSAGE' );
7264: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7265: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7266: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7267: FND_MSG_PUB.ADD;
7268: RAISE FND_API.G_EXC_ERROR;
7261: --dbms_output.PUT_LINE('THE NO OF RELATIONS ARE :- '||l_no_rels );
7262: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
7263: --dbms_output.PUT_LINE('RELATIONS MESSAGE' );
7264: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7265: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7266: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7267: FND_MSG_PUB.ADD;
7268: RAISE FND_API.G_EXC_ERROR;
7269: END IF;
7262: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
7263: --dbms_output.PUT_LINE('RELATIONS MESSAGE' );
7264: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7265: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7266: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7267: FND_MSG_PUB.ADD;
7268: RAISE FND_API.G_EXC_ERROR;
7269: END IF;
7270: IF(cr_dim_objs_in_dimset %ISOPEN) THEN
7472: SAVEPOINT DeleteBSCKPIMulAnaOpts;
7473: FND_MSG_PUB.Initialize;
7474: x_return_status := FND_API.G_RET_STS_SUCCESS;
7475: IF (p_data_source IS NULL) THEN
7476: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7477: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);
7478: FND_MSG_PUB.ADD;
7479: RAISE FND_API.G_EXC_ERROR;
7480: END IF;
7473: FND_MSG_PUB.Initialize;
7474: x_return_status := FND_API.G_RET_STS_SUCCESS;
7475: IF (p_data_source IS NULL) THEN
7476: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7477: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);
7478: FND_MSG_PUB.ADD;
7479: RAISE FND_API.G_EXC_ERROR;
7480: END IF;
7481: IF ((p_data_source <> 'BSC') AND (p_data_source <> 'PMF')) THEN
7478: FND_MSG_PUB.ADD;
7479: RAISE FND_API.G_EXC_ERROR;
7480: END IF;
7481: IF ((p_data_source <> 'BSC') AND (p_data_source <> 'PMF')) THEN
7482: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DATA_SOURCE');
7483: FND_MSG_PUB.ADD;
7484: RAISE FND_API.G_EXC_ERROR;
7485: END IF;
7486:
7502: l_Bsc_Anal_Opt_Rec.Bsc_Option_Group1 := 0;
7503: END IF;
7504:
7505: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
7506: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7507: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
7508: FND_MSG_PUB.ADD;
7509: RAISE FND_API.G_EXC_ERROR;
7510: END IF;
7503: END IF;
7504:
7505: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
7506: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7507: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
7508: FND_MSG_PUB.ADD;
7509: RAISE FND_API.G_EXC_ERROR;
7510: END IF;
7511:
7512: SELECT COUNT(*) INTO l_count
7513: FROM BSC_KPIS_B
7514: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
7515: IF (l_count = 0) THEN
7516: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
7517: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
7518: FND_MSG_PUB.ADD;
7519: RAISE FND_API.G_EXC_ERROR;
7520: END IF;
7513: FROM BSC_KPIS_B
7514: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
7515: IF (l_count = 0) THEN
7516: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
7517: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
7518: FND_MSG_PUB.ADD;
7519: RAISE FND_API.G_EXC_ERROR;
7520: END IF;
7521: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN
7518: FND_MSG_PUB.ADD;
7519: RAISE FND_API.G_EXC_ERROR;
7520: END IF;
7521: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN
7522: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7523: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_OPTIONS'), TRUE);
7524: FND_MSG_PUB.ADD;
7525: RAISE FND_API.G_EXC_ERROR;
7526: END IF;
7519: RAISE FND_API.G_EXC_ERROR;
7520: END IF;
7521: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN
7522: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7523: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_OPTIONS'), TRUE);
7524: FND_MSG_PUB.ADD;
7525: RAISE FND_API.G_EXC_ERROR;
7526: END IF;
7527: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN
7524: FND_MSG_PUB.ADD;
7525: RAISE FND_API.G_EXC_ERROR;
7526: END IF;
7527: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN
7528: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7529: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_GROUP'), TRUE);
7530: FND_MSG_PUB.ADD;
7531: RAISE FND_API.G_EXC_ERROR;
7532: END IF;
7525: RAISE FND_API.G_EXC_ERROR;
7526: END IF;
7527: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN
7528: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7529: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_GROUP'), TRUE);
7530: FND_MSG_PUB.ADD;
7531: RAISE FND_API.G_EXC_ERROR;
7532: END IF;
7533:
7534: SELECT share_flag INTO l_count
7535: FROM BSC_KPIS_B
7536: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
7537: IF (l_count = 2) THEN
7538: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
7539: FND_MSG_PUB.ADD;
7540: RAISE FND_API.G_EXC_ERROR;
7541: END IF;
7542: -- obtain dimension set id this option is using.