57: FROM BSC_SYS_COLORS_B
58: WHERE COLOR_ID = p_Bsc_Color_Rec.Color_id;
59:
60: IF (l_Count > 0) THEN
61: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_ID_EXISTS');
62: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);
63: FND_MSG_PUB.ADD;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
58: WHERE COLOR_ID = p_Bsc_Color_Rec.Color_id;
59:
60: IF (l_Count > 0) THEN
61: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_ID_EXISTS');
62: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);
63: FND_MSG_PUB.ADD;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: ELSE
63: FND_MSG_PUB.ADD;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: ELSE
67: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID');
68: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);
69: FND_MSG_PUB.ADD;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: ELSE
67: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID');
68: FND_MESSAGE.SET_TOKEN('BSC_COLOR_ID', p_Bsc_Color_Rec.Color_Id);
69: FND_MSG_PUB.ADD;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF (p_Bsc_Color_Rec.Short_Name IS NULL) THEN
69: FND_MSG_PUB.ADD;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF (p_Bsc_Color_Rec.Short_Name IS NULL) THEN
73: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_SN');
74: FND_MESSAGE.SET_TOKEN('BSC_COLOR_SN', p_Bsc_Color_Rec.short_name);
75: FND_MSG_PUB.ADD;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
70: RAISE FND_API.G_EXC_ERROR;
71: END IF;
72: IF (p_Bsc_Color_Rec.Short_Name IS NULL) THEN
73: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_SN');
74: FND_MESSAGE.SET_TOKEN('BSC_COLOR_SN', p_Bsc_Color_Rec.short_name);
75: FND_MSG_PUB.ADD;
76: RAISE FND_API.G_EXC_ERROR;
77: END IF;
78: BSC_COLOR_PKG.INSERT_ROW(p_Bsc_Color_Rec.color_id
233:
234: SAVEPOINT BscColorPvt_DelColor;
235:
236: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN
237: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID_SN');
238: FND_MSG_PUB.ADD;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: BSC_COLOR_PKG.DELETE_ROW(p_Bsc_Color_Id
433:
434: SAVEPOINT BscColorPvt_RetColor;
435:
436: IF(p_Bsc_Color_Id IS NULL AND p_Bsc_Color_SN IS NULL) THEN
437: FND_MESSAGE.SET_NAME('BSC','BSC_NO_COLOR_ID_SN');
438: FND_MSG_PUB.ADD;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;
441: