DBA Data[Home] [Help]

APPS.OE_LINE_ADJ_ASSOCS_UTIL dependencies on OE_MSG_PUB

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

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

Line 111: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 225: OE_MSG_PUB.Add_Exc_Msg

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

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

517:
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: p_x_Line_Adj_Assoc_rec.return_status := FND_API.G_RET_STS_ERROR;
520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
522: THEN
523:
524: -- Release the lock
525: ROLLBACK TO Lock_Row;

Line 528: OE_MSG_PUB.Add;

524: -- Release the lock
525: ROLLBACK TO Lock_Row;
526:
527: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
528: OE_MSG_PUB.Add;
529:
530: END IF;
531:
532: END IF;

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

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

Line 605: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 663: OE_MSG_PUB.Add;

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

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

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

Line 671: OE_MSG_PUB.Add;

667: x_return_status := FND_API.G_RET_STS_ERROR;
668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
669: THEN
670: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
671: OE_MSG_PUB.Add;
672: END IF;
673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

Line 678: OE_MSG_PUB.Add_Exc_Msg

674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
677: THEN
678: OE_MSG_PUB.Add_Exc_Msg
679: ( G_PKG_NAME
680: , 'Lock_Rows'
681: );
682: END IF;