DBA Data[Home] [Help]

APPS.OE_HEADER_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 264: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

260: EXCEPTION
261:
262: WHEN OTHERS THEN
263:
264: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: OE_MSG_PUB.Add_Exc_Msg
267: ( G_PKG_NAME
268: , 'Update_Row'

Line 266: OE_MSG_PUB.Add_Exc_Msg

262: WHEN OTHERS THEN
263:
264: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: OE_MSG_PUB.Add_Exc_Msg
267: ( G_PKG_NAME
268: , 'Update_Row'
269: );
270: END IF;

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

584:
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: p_x_Header_Adj_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
587:
588: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
589: THEN
590:
591: -- Release the lock
592: ROLLBACK TO Lock_Row;

Line 595: OE_MSG_PUB.Add;

591: -- Release the lock
592: ROLLBACK TO Lock_Row;
593:
594: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
595: OE_MSG_PUB.Add;
596:
597: END IF;
598:
599: END IF;

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

667: p_price_adj_attrib_id <> FND_API.G_MISS_NUM) AND
668: (p_price_adjustment_id IS NOT NULL AND
669: p_price_adjustment_id <> FND_API.G_MISS_NUM)
670: THEN
671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
672: OE_MSG_PUB.Add_Exc_Msg
673: ( G_PKG_NAME
674: , 'Lock_Rows'
675: , 'Keys are mutually exclusive: price_adj_attrib_id = ' ||

Line 672: OE_MSG_PUB.Add_Exc_Msg

668: (p_price_adjustment_id IS NOT NULL AND
669: p_price_adjustment_id <> FND_API.G_MISS_NUM)
670: THEN
671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
672: OE_MSG_PUB.Add_Exc_Msg
673: ( G_PKG_NAME
674: , 'Lock_Rows'
675: , 'Keys are mutually exclusive: price_adj_attrib_id = ' ||
676: p_price_adj_attrib_id || ', price_adjustment_id = ' || p_price_adjustment_id );

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

723:
724: EXCEPTION
725: WHEN NO_DATA_FOUND THEN
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
728: THEN
729: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
730: OE_MSG_PUB.Add;
731: END IF;

Line 730: OE_MSG_PUB.Add;

726: x_return_status := FND_API.G_RET_STS_ERROR;
727: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
728: THEN
729: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
730: OE_MSG_PUB.Add;
731: END IF;
732:
733: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;

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

731: END IF;
732:
733: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
736: THEN
737: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
738: OE_MSG_PUB.Add;
739: END IF;

Line 738: OE_MSG_PUB.Add;

734: x_return_status := FND_API.G_RET_STS_ERROR;
735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
736: THEN
737: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
738: OE_MSG_PUB.Add;
739: END IF;
740:
741: WHEN OTHERS THEN
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

739: END IF;
740:
741: WHEN OTHERS THEN
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
744: THEN
745: OE_MSG_PUB.Add_Exc_Msg
746: ( G_PKG_NAME
747: , 'Lock_Rows'

Line 745: OE_MSG_PUB.Add_Exc_Msg

741: WHEN OTHERS THEN
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
744: THEN
745: OE_MSG_PUB.Add_Exc_Msg
746: ( G_PKG_NAME
747: , 'Lock_Rows'
748: );
749: END IF;