169: EXCEPTION
170:
171: WHEN OTHERS THEN
172:
173: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
174: THEN
175: FND_MSG_PUB.Add_Exc_Msg
176: ( G_PKG_NAME
177: , 'Insert_Row'
171: WHEN OTHERS THEN
172:
173: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
174: THEN
175: FND_MSG_PUB.Add_Exc_Msg
176: ( G_PKG_NAME
177: , 'Insert_Row'
178: );
179: END IF;
256: end if;
257:
258: exception
259: WHEN OTHERS THEN
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: FND_MSG_PUB.Add_Exc_Msg
263: ( G_PKG_NAME
264: , 'Delete_Row'
258: exception
259: WHEN OTHERS THEN
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: FND_MSG_PUB.Add_Exc_Msg
263: ( G_PKG_NAME
264: , 'Delete_Row'
265: );
266: END IF;
534:
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: p_x_Header_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_ERROR;
537:
538: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
539: THEN
540:
541: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
542: FND_MSG_PUB.Add;
538: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
539: THEN
540:
541: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
542: FND_MSG_PUB.Add;
543:
544: END IF;
545: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
546:
546:
547: x_return_status := FND_API.G_RET_STS_ERROR;
548: p_x_Header_Adj_Assoc_Rec.return_status := FND_API.G_RET_STS_ERROR;
549:
550: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
551: THEN
552:
553: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
554: FND_MSG_PUB.Add;
550: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
551: THEN
552:
553: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
554: FND_MSG_PUB.Add;
555:
556: END IF;
557: WHEN OTHERS THEN
558: