DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_ASSOCS_UTIL dependencies on OE_MSG_PUB

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

107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108:
109: WHEN OTHERS THEN
110:
111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
112: THEN
113: OE_MSG_PUB.Add_Exc_Msg
114: ( G_PKG_NAME
115: , 'Query_Rows'

Line 113: OE_MSG_PUB.Add_Exc_Msg

109: WHEN OTHERS THEN
110:
111: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
112: THEN
113: OE_MSG_PUB.Add_Exc_Msg
114: ( G_PKG_NAME
115: , 'Query_Rows'
116: );
117: END IF;

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

221: EXCEPTION
222:
223: WHEN OTHERS THEN
224:
225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
226: THEN
227: OE_MSG_PUB.Add_Exc_Msg
228: ( G_PKG_NAME
229: , 'Update_Row'

Line 227: OE_MSG_PUB.Add_Exc_Msg

223: WHEN OTHERS THEN
224:
225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
226: THEN
227: OE_MSG_PUB.Add_Exc_Msg
228: ( G_PKG_NAME
229: , 'Update_Row'
230: );
231: END IF;

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

513:
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: p_x_Header_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_ERROR;
516:
517: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
518: THEN
519:
520: -- Release the lock
521: ROLLBACK TO Lock_Row;

Line 524: OE_MSG_PUB.Add;

520: -- Release the lock
521: ROLLBACK TO Lock_Row;
522:
523: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
524: OE_MSG_PUB.Add;
525:
526: END IF;
527:
528: END IF;

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

596: p_price_adj_assoc_id <> FND_API.G_MISS_NUM) AND
597: (p_price_adjustment_id IS NOT NULL AND
598: p_price_adjustment_id <> FND_API.G_MISS_NUM)
599: THEN
600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: OE_MSG_PUB.Add_Exc_Msg
602: ( G_PKG_NAME
603: , 'Lock_Rows'
604: , 'Keys are mutually exclusive: price_adj_assoc_id = ' ||

Line 601: OE_MSG_PUB.Add_Exc_Msg

597: (p_price_adjustment_id IS NOT NULL AND
598: p_price_adjustment_id <> FND_API.G_MISS_NUM)
599: THEN
600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: OE_MSG_PUB.Add_Exc_Msg
602: ( G_PKG_NAME
603: , 'Lock_Rows'
604: , 'Keys are mutually exclusive: price_adj_assoc_id = ' ||
605: p_price_adj_assoc_id || ', price_adjustment_id = ' || p_price_adjustment_id );

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

652:
653: EXCEPTION
654: WHEN NO_DATA_FOUND THEN
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
657: THEN
658: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
659: OE_MSG_PUB.Add;
660: END IF;

Line 659: OE_MSG_PUB.Add;

655: x_return_status := FND_API.G_RET_STS_ERROR;
656: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
657: THEN
658: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
659: OE_MSG_PUB.Add;
660: END IF;
661:
662: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
663: x_return_status := FND_API.G_RET_STS_ERROR;

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

660: END IF;
661:
662: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
665: THEN
666: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
667: OE_MSG_PUB.Add;
668: END IF;

Line 667: OE_MSG_PUB.Add;

663: x_return_status := FND_API.G_RET_STS_ERROR;
664: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
665: THEN
666: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
667: OE_MSG_PUB.Add;
668: END IF;
669:
670: WHEN OTHERS THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

668: END IF;
669:
670: WHEN OTHERS THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: OE_MSG_PUB.Add_Exc_Msg
675: ( G_PKG_NAME
676: , 'Lock_Rows'

Line 674: OE_MSG_PUB.Add_Exc_Msg

670: WHEN OTHERS THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
673: THEN
674: OE_MSG_PUB.Add_Exc_Msg
675: ( G_PKG_NAME
676: , 'Lock_Rows'
677: );
678: END IF;