133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134:
135: WHEN OTHERS THEN
136:
137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
138: THEN
139: OE_MSG_PUB.Add_Exc_Msg
140: ( G_PKG_NAME
141: , 'Query_Rows'
135: WHEN OTHERS THEN
136:
137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
138: THEN
139: OE_MSG_PUB.Add_Exc_Msg
140: ( G_PKG_NAME
141: , 'Query_Rows'
142: );
143: END IF;
272: EXCEPTION
273:
274: WHEN OTHERS THEN
275:
276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: OE_MSG_PUB.Add_Exc_Msg
279: ( G_PKG_NAME
280: , 'Update_Row'
274: WHEN OTHERS THEN
275:
276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
277: THEN
278: OE_MSG_PUB.Add_Exc_Msg
279: ( G_PKG_NAME
280: , 'Update_Row'
281: );
282: END IF;
611:
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: p_x_Line_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
614:
615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
616: THEN
617:
618: -- Release the lock
619: ROLLBACK TO Lock_Row;
618: -- Release the lock
619: ROLLBACK TO Lock_Row;
620:
621: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
622: OE_MSG_PUB.Add;
623:
624: END IF;
625:
626: END IF;
693: p_price_adj_attrib_id <> FND_API.G_MISS_NUM) AND
694: (p_price_adjustment_id IS NOT NULL AND
695: p_price_adjustment_id <> FND_API.G_MISS_NUM)
696: THEN
697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
698: OE_MSG_PUB.Add_Exc_Msg
699: ( G_PKG_NAME
700: , 'Lock_Rows'
701: , 'Keys are mutually exclusive: price_adj_attrib_id = ' ||
694: (p_price_adjustment_id IS NOT NULL AND
695: p_price_adjustment_id <> FND_API.G_MISS_NUM)
696: THEN
697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
698: OE_MSG_PUB.Add_Exc_Msg
699: ( G_PKG_NAME
700: , 'Lock_Rows'
701: , 'Keys are mutually exclusive: price_adj_attrib_id = ' ||
702: p_price_adj_attrib_id || ', price_adjustment_id = ' || p_price_adjustment_id );
749:
750: EXCEPTION
751: WHEN NO_DATA_FOUND THEN
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
754: THEN
755: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
756: OE_MSG_PUB.Add;
757: END IF;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
754: THEN
755: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
756: OE_MSG_PUB.Add;
757: END IF;
758:
759: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
757: END IF;
758:
759: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
764: OE_MSG_PUB.Add;
765: END IF;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
762: THEN
763: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
764: OE_MSG_PUB.Add;
765: END IF;
766:
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: END IF;
766:
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: OE_MSG_PUB.Add_Exc_Msg
772: ( G_PKG_NAME
773: , 'Lock_Rows'
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: OE_MSG_PUB.Add_Exc_Msg
772: ( G_PKG_NAME
773: , 'Lock_Rows'
774: );
775: END IF;