23: THEN
24:
25: l_return_status := FND_API.G_RET_STS_ERROR;
26:
27: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:
30: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
31: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1');
28: THEN
29:
30: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
31: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','attribute1');
32: OE_MSG_PUB.Add;
33:
34: END IF;
35:
36: END IF;
75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
80: THEN
81: OE_MSG_PUB.Add_Exc_Msg
82: ( G_PKG_NAME
83: , 'Entity'
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
80: THEN
81: OE_MSG_PUB.Add_Exc_Msg
82: ( G_PKG_NAME
83: , 'Entity'
84: );
85: END IF;
530: WHEN OTHERS THEN
531:
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533:
534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
535: THEN
536: OE_MSG_PUB.Add_Exc_Msg
537: ( G_PKG_NAME
538: , 'Attributes'
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533:
534: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
535: THEN
536: OE_MSG_PUB.Add_Exc_Msg
537: ( G_PKG_NAME
538: , 'Attributes'
539: );
540: END IF;
635: --
636: if is_attribute_used = 'Y' then
637: l_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MESSAGE.SET_NAME('QP','QP_CANNOT_DELETE_SEGMENT');
639: OE_MSG_PUB.Add;
640: raise fnd_api.g_exc_error;
641: end if;
642: --
643: x_return_status := l_return_status;
655: WHEN OTHERS THEN
656:
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658:
659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
660: THEN
661: OE_MSG_PUB.Add_Exc_Msg
662: ( G_PKG_NAME
663: , 'Entity_Delete'
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658:
659: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
660: THEN
661: OE_MSG_PUB.Add_Exc_Msg
662: ( G_PKG_NAME
663: , 'Entity_Delete'
664: );
665: END IF;