138: from BSC_KPIS_B
139: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
140:
141: if l_share_flag = 2 then
142: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
143: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;
146: end if;
139: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
140:
141: if l_share_flag = 2 then
142: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
143: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;
146: end if;
147:
1240:
1241: -- Changed message for Bug#4590994
1242: IF (l_Kpi_Short_Name IS NOT NULL) THEN
1243: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_Objective_Report_Type(l_Kpi_Short_Name) = FND_API.G_TRUE) THEN
1244: FND_MESSAGE.SET_NAME('BSC','BSC_D_DELETE_RPT_KPI_OBJ');
1245: FND_MESSAGE.SET_TOKEN('OBJECTIVE', l_Kpi_Name);
1246: FND_MSG_PUB.ADD;
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1241: -- Changed message for Bug#4590994
1242: IF (l_Kpi_Short_Name IS NOT NULL) THEN
1243: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_Objective_Report_Type(l_Kpi_Short_Name) = FND_API.G_TRUE) THEN
1244: FND_MESSAGE.SET_NAME('BSC','BSC_D_DELETE_RPT_KPI_OBJ');
1245: FND_MESSAGE.SET_TOKEN('OBJECTIVE', l_Kpi_Name);
1246: FND_MSG_PUB.ADD;
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249: END IF;
1416: INTO l_count
1417: FROM BSC_KPIS_B
1418: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1419: if l_count = 0 then
1420: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1421: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1422: FND_MSG_PUB.ADD;
1423: RAISE FND_API.G_EXC_ERROR;
1424: end if;
1417: FROM BSC_KPIS_B
1418: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1419: if l_count = 0 then
1420: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1421: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1422: FND_MSG_PUB.ADD;
1423: RAISE FND_API.G_EXC_ERROR;
1424: end if;
1425: else
1422: FND_MSG_PUB.ADD;
1423: RAISE FND_API.G_EXC_ERROR;
1424: end if;
1425: else
1426: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1427: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1428: FND_MSG_PUB.ADD;
1429: RAISE FND_API.G_EXC_ERROR;
1430: end if;
1423: RAISE FND_API.G_EXC_ERROR;
1424: end if;
1425: else
1426: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1427: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1428: FND_MSG_PUB.ADD;
1429: RAISE FND_API.G_EXC_ERROR;
1430: end if;
1431:
1435: from BSC_KPIS_B
1436: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1437:
1438: if l_share_flag = 2 then
1439: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1440: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1441: FND_MSG_PUB.ADD;
1442: RAISE FND_API.G_EXC_ERROR;
1443: end if;
1436: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1437:
1438: if l_share_flag = 2 then
1439: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1440: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1441: FND_MSG_PUB.ADD;
1442: RAISE FND_API.G_EXC_ERROR;
1443: end if;
1444:
1676: INTO l_count
1677: FROM BSC_KPIS_B
1678: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1679: if l_count = 0 then
1680: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1681: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1682: FND_MSG_PUB.ADD;
1683: RAISE FND_API.G_EXC_ERROR;
1684: end if;
1677: FROM BSC_KPIS_B
1678: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1679: if l_count = 0 then
1680: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1681: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1682: FND_MSG_PUB.ADD;
1683: RAISE FND_API.G_EXC_ERROR;
1684: end if;
1685: else
1682: FND_MSG_PUB.ADD;
1683: RAISE FND_API.G_EXC_ERROR;
1684: end if;
1685: else
1686: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1687: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1688: FND_MSG_PUB.ADD;
1689: RAISE FND_API.G_EXC_ERROR;
1690: end if;
1683: RAISE FND_API.G_EXC_ERROR;
1684: end if;
1685: else
1686: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1687: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1688: FND_MSG_PUB.ADD;
1689: RAISE FND_API.G_EXC_ERROR;
1690: end if;
1691:
1695: from BSC_KPIS_B
1696: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1697:
1698: if l_share_flag = 2 then
1699: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1700: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1701: FND_MSG_PUB.ADD;
1702: RAISE FND_API.G_EXC_ERROR;
1703: end if;
1696: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1697:
1698: if l_share_flag = 2 then
1699: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1700: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1701: FND_MSG_PUB.ADD;
1702: RAISE FND_API.G_EXC_ERROR;
1703: end if;
1704:
1817: INTO l_count
1818: FROM BSC_KPIS_B
1819: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1820: if l_count = 0 then
1821: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1822: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1823: FND_MSG_PUB.ADD;
1824: RAISE FND_API.G_EXC_ERROR;
1825: end if;
1818: FROM BSC_KPIS_B
1819: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1820: if l_count = 0 then
1821: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1822: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1823: FND_MSG_PUB.ADD;
1824: RAISE FND_API.G_EXC_ERROR;
1825: end if;
1826: else
1823: FND_MSG_PUB.ADD;
1824: RAISE FND_API.G_EXC_ERROR;
1825: end if;
1826: else
1827: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1828: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1829: FND_MSG_PUB.ADD;
1830: RAISE FND_API.G_EXC_ERROR;
1831: end if;
1824: RAISE FND_API.G_EXC_ERROR;
1825: end if;
1826: else
1827: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1828: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1829: FND_MSG_PUB.ADD;
1830: RAISE FND_API.G_EXC_ERROR;
1831: end if;
1832:
1836: from BSC_KPIS_B
1837: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1838:
1839: if l_share_flag = 2 then
1840: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1841: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1842: FND_MSG_PUB.ADD;
1843: RAISE FND_API.G_EXC_ERROR;
1844: end if;
1837: where indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id;
1838:
1839: if l_share_flag = 2 then
1840: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1841: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1842: FND_MSG_PUB.ADD;
1843: RAISE FND_API.G_EXC_ERROR;
1844: end if;
1845:
2244: ,x_msg_data => x_msg_data
2245: );
2246: END IF;
2247: ELSE
2248: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
2249: FND_MESSAGE.SET_TOKEN('BSC_MEAS', l_short_name);
2250: FND_MSG_PUB.ADD;
2251: RAISE FND_API.G_EXC_ERROR;
2252: END IF;
2245: );
2246: END IF;
2247: ELSE
2248: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
2249: FND_MESSAGE.SET_TOKEN('BSC_MEAS', l_short_name);
2250: FND_MSG_PUB.ADD;
2251: RAISE FND_API.G_EXC_ERROR;
2252: END IF;
2253: