560: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
561: ,'indicator'
562: , p_Indicator);
563: IF l_Count = 0 THEN
564: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
565: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
561: ,'indicator'
562: , p_Indicator);
563: IF l_Count = 0 THEN
564: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
565: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569: ELSE
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569: ELSE
570: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
571: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569: ELSE
570: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
571: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575: BSC_BIS_LOCKS_PUB.LOCK_KPI
808: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
809: ,'indicator'
810: , p_Indicator);
811: IF l_Count = 0 THEN
812: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
813: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
809: ,'indicator'
810: , p_Indicator);
811: IF l_Count = 0 THEN
812: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
813: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
817: ELSE
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
817: ELSE
818: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
819: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
817: ELSE
818: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
819: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823: BSC_BIS_LOCKS_PUB.LOCK_KPI
1099: l_Count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1100: ,'indicator'
1101: , p_Indicator);
1102: IF l_Count = 0 THEN
1103: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1104: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
1105: FND_MSG_PUB.ADD;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1100: ,'indicator'
1101: , p_Indicator);
1102: IF l_Count = 0 THEN
1103: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1104: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
1105: FND_MSG_PUB.ADD;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: ELSE
1105: FND_MSG_PUB.ADD;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: ELSE
1109: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1110: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
1111: FND_MSG_PUB.ADD;
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: ELSE
1109: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1110: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
1111: FND_MSG_PUB.ADD;
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114: BSC_BIS_LOCKS_PUB.LOCK_KPI
1697: END LOOP;
1698: END IF;
1699:
1700: IF l_Structure_Change THEN
1701: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
1702: FND_MESSAGE.SET_TOKEN('INDICATORS', BSC_BIS_LOCKS_PVT.Get_Kpi_Name(p_Indicator));
1703: FND_MSG_PUB.ADD;
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1698: END IF;
1699:
1700: IF l_Structure_Change THEN
1701: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
1702: FND_MESSAGE.SET_TOKEN('INDICATORS', BSC_BIS_LOCKS_PVT.Get_Kpi_Name(p_Indicator));
1703: FND_MSG_PUB.ADD;
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706: