DBA Data[Home] [Help]

APPS.OE_LINE_ADJ_UTIL dependencies on OE_MSG_PUB

Line 3017: OE_MSG_PUB.Add_Exc_Msg

3013: WHEN OTHERS THEN
3014:
3015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3016: THEN
3017: OE_MSG_PUB.Add_Exc_Msg
3018: ( G_PKG_NAME
3019: , 'Update_Row'
3020: );
3021: END IF;

Line 3343: OE_MSG_PUB.Add_Exc_Msg

3339: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
3340: END IF;
3341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3342: THEN
3343: OE_MSG_PUB.Add_Exc_Msg
3344: ( G_PKG_NAME
3345: , 'Insert_Row'
3346: );
3347: END IF;

Line 3359: OE_MSG_PUB.Add_Exc_Msg

3355: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
3356: END IF;
3357: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3358: THEN
3359: OE_MSG_PUB.Add_Exc_Msg
3360: ( G_PKG_NAME
3361: , 'Insert_Row'
3362: );
3363: END IF;

Line 3539: OE_MSG_PUB.Add_Exc_Msg

3535: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;
3536: END IF;
3537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3538: THEN
3539: OE_MSG_PUB.Add_Exc_Msg
3540: ( G_PKG_NAME
3541: , 'Delete_Row'
3542: );
3543: END IF;

Line 4052: OE_MSG_PUB.Add_Exc_Msg

4048: p_line_id <> FND_API.G_MISS_NUM)
4049: THEN
4050: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4051: THEN
4052: OE_MSG_PUB.Add_Exc_Msg
4053: ( G_PKG_NAME
4054: , 'Query Rows'
4055: , 'Keys are mutually exclusive: price_adjustment_id = '|| p_price_adjustment_id || ', line_id = '|| p_line_id
4056: );

Line 4263: OE_MSG_PUB.Add_Exc_Msg

4259: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
4260: END IF;
4261: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4262: THEN
4263: OE_MSG_PUB.Add_Exc_Msg
4264: ( G_PKG_NAME
4265: , 'Query_Rows'
4266: );
4267: END IF;

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

4370:
4371: x_return_status := FND_API.G_RET_STS_ERROR;
4372: p_x_line_adj_rec.return_status := FND_API.G_RET_STS_ERROR;
4373:
4374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4375: THEN
4376:
4377: -- Release the lock
4378: ROLLBACK TO Lock_Row;

Line 4381: OE_MSG_PUB.Add;

4377: -- Release the lock
4378: ROLLBACK TO Lock_Row;
4379:
4380: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
4381: OE_MSG_PUB.Add;
4382:
4383: END IF;
4384:
4385: END IF;

Line 4420: OE_MSG_PUB.Add_Exc_Msg

4416: p_x_Line_Adj_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4417:
4418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4419: THEN
4420: OE_MSG_PUB.Add_Exc_Msg
4421: ( G_PKG_NAME
4422: , 'Lock_Row'
4423: );
4424: END IF;

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

4461: p_price_adjustment_id <> FND_API.G_MISS_NUM) AND
4462: (p_line_id IS NOT NULL AND
4463: p_line_id <> FND_API.G_MISS_NUM)
4464: THEN
4465: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4466: OE_MSG_PUB.Add_Exc_Msg
4467: ( G_PKG_NAME
4468: , 'Lock_Rows'
4469: , 'Keys are mutually exclusive: price_adjustment_id = ' ||

Line 4466: OE_MSG_PUB.Add_Exc_Msg

4462: (p_line_id IS NOT NULL AND
4463: p_line_id <> FND_API.G_MISS_NUM)
4464: THEN
4465: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4466: OE_MSG_PUB.Add_Exc_Msg
4467: ( G_PKG_NAME
4468: , 'Lock_Rows'
4469: , 'Keys are mutually exclusive: price_adjustment_id = ' ||
4470: p_price_adjustment_id || ', line_id = ' || p_line_id );

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

4516:
4517: EXCEPTION
4518: WHEN NO_DATA_FOUND THEN
4519: x_return_status := FND_API.G_RET_STS_ERROR;
4520: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4521: THEN
4522: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4523: OE_MSG_PUB.Add;
4524: END IF;

Line 4523: OE_MSG_PUB.Add;

4519: x_return_status := FND_API.G_RET_STS_ERROR;
4520: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4521: THEN
4522: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4523: OE_MSG_PUB.Add;
4524: END IF;
4525:
4526: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4527: x_return_status := FND_API.G_RET_STS_ERROR;

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

4524: END IF;
4525:
4526: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4527: x_return_status := FND_API.G_RET_STS_ERROR;
4528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4529: THEN
4530: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4531: OE_MSG_PUB.Add;
4532: END IF;

Line 4531: OE_MSG_PUB.Add;

4527: x_return_status := FND_API.G_RET_STS_ERROR;
4528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4529: THEN
4530: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4531: OE_MSG_PUB.Add;
4532: END IF;
4533:
4534: WHEN OTHERS THEN
4535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4532: END IF;
4533:
4534: WHEN OTHERS THEN
4535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4536: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4537: THEN
4538: OE_MSG_PUB.Add_Exc_Msg
4539: ( G_PKG_NAME
4540: , 'Lock_Row'

Line 4538: OE_MSG_PUB.Add_Exc_Msg

4534: WHEN OTHERS THEN
4535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4536: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4537: THEN
4538: OE_MSG_PUB.Add_Exc_Msg
4539: ( G_PKG_NAME
4540: , 'Lock_Row'
4541: );
4542: END IF;

Line 4922: OE_MSG_PUB.Add_Exc_Msg

4918: WHEN OTHERS THEN
4919:
4920: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4921: THEN
4922: OE_MSG_PUB.Add_Exc_Msg
4923: ( G_PKG_NAME
4924: , 'Update_Row'
4925: );
4926: END IF;