DBA Data[Home] [Help]

APPS.OE_LINE_PRICE_AATTR_UTIL dependencies on OE_MSG_PUB

Line 137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 139: OE_MSG_PUB.Add_Exc_Msg

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;

Line 276: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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'

Line 278: OE_MSG_PUB.Add_Exc_Msg

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;

Line 615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 622: OE_MSG_PUB.Add;

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;

Line 697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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 = ' ||

Line 698: OE_MSG_PUB.Add_Exc_Msg

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 );

Line 753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 756: OE_MSG_PUB.Add;

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;

Line 761: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_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;

Line 764: OE_MSG_PUB.Add;

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;

Line 769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_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'

Line 771: OE_MSG_PUB.Add_Exc_Msg

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;