DBA Data[Home] [Help]

APPS.OE_LINE_ADJ_UTIL dependencies on OE_MSG_PUB

Line 3095: OE_MSG_PUB.Add_Exc_Msg

3091: WHEN OTHERS THEN
3092:
3093: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3094: THEN
3095: OE_MSG_PUB.Add_Exc_Msg
3096: ( G_PKG_NAME
3097: , 'Update_Row'
3098: );
3099: END IF;

Line 3421: OE_MSG_PUB.Add_Exc_Msg

3417: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
3418: END IF;
3419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3420: THEN
3421: OE_MSG_PUB.Add_Exc_Msg
3422: ( G_PKG_NAME
3423: , 'Insert_Row'
3424: );
3425: END IF;

Line 3437: OE_MSG_PUB.Add_Exc_Msg

3433: oe_debug_pub.add( G_PKG_NAME||':INSER_ROW:'||SQLERRM ) ;
3434: END IF;
3435: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3436: THEN
3437: OE_MSG_PUB.Add_Exc_Msg
3438: ( G_PKG_NAME
3439: , 'Insert_Row'
3440: );
3441: END IF;

Line 3617: OE_MSG_PUB.Add_Exc_Msg

3613: oe_debug_pub.add( G_PKG_NAME||':DELETE_ROW:'||SQLERRM ) ;
3614: END IF;
3615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3616: THEN
3617: OE_MSG_PUB.Add_Exc_Msg
3618: ( G_PKG_NAME
3619: , 'Delete_Row'
3620: );
3621: END IF;

Line 4130: OE_MSG_PUB.Add_Exc_Msg

4126: p_line_id <> FND_API.G_MISS_NUM)
4127: THEN
4128: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4129: THEN
4130: OE_MSG_PUB.Add_Exc_Msg
4131: ( G_PKG_NAME
4132: , 'Query Rows'
4133: , 'Keys are mutually exclusive: price_adjustment_id = '|| p_price_adjustment_id || ', line_id = '|| p_line_id
4134: );

Line 4341: OE_MSG_PUB.Add_Exc_Msg

4337: oe_debug_pub.add( G_PKG_NAME||':QUERY_ROW:'||SQLERRM ) ;
4338: END IF;
4339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4340: THEN
4341: OE_MSG_PUB.Add_Exc_Msg
4342: ( G_PKG_NAME
4343: , 'Query_Rows'
4344: );
4345: END IF;

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

4448:
4449: x_return_status := FND_API.G_RET_STS_ERROR;
4450: p_x_line_adj_rec.return_status := FND_API.G_RET_STS_ERROR;
4451:
4452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4453: THEN
4454:
4455: -- Release the lock
4456: ROLLBACK TO Lock_Row;

Line 4459: OE_MSG_PUB.Add;

4455: -- Release the lock
4456: ROLLBACK TO Lock_Row;
4457:
4458: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
4459: OE_MSG_PUB.Add;
4460:
4461: END IF;
4462:
4463: END IF;

Line 4498: OE_MSG_PUB.Add_Exc_Msg

4494: p_x_Line_Adj_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4495:
4496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4497: THEN
4498: OE_MSG_PUB.Add_Exc_Msg
4499: ( G_PKG_NAME
4500: , 'Lock_Row'
4501: );
4502: END IF;

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

4539: p_price_adjustment_id <> FND_API.G_MISS_NUM) AND
4540: (p_line_id IS NOT NULL AND
4541: p_line_id <> FND_API.G_MISS_NUM)
4542: THEN
4543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4544: OE_MSG_PUB.Add_Exc_Msg
4545: ( G_PKG_NAME
4546: , 'Lock_Rows'
4547: , 'Keys are mutually exclusive: price_adjustment_id = ' ||

Line 4544: OE_MSG_PUB.Add_Exc_Msg

4540: (p_line_id IS NOT NULL AND
4541: p_line_id <> FND_API.G_MISS_NUM)
4542: THEN
4543: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4544: OE_MSG_PUB.Add_Exc_Msg
4545: ( G_PKG_NAME
4546: , 'Lock_Rows'
4547: , 'Keys are mutually exclusive: price_adjustment_id = ' ||
4548: p_price_adjustment_id || ', line_id = ' || p_line_id );

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

4594:
4595: EXCEPTION
4596: WHEN NO_DATA_FOUND THEN
4597: x_return_status := FND_API.G_RET_STS_ERROR;
4598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4599: THEN
4600: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4601: OE_MSG_PUB.Add;
4602: END IF;

Line 4601: OE_MSG_PUB.Add;

4597: x_return_status := FND_API.G_RET_STS_ERROR;
4598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4599: THEN
4600: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4601: OE_MSG_PUB.Add;
4602: END IF;
4603:
4604: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4605: x_return_status := FND_API.G_RET_STS_ERROR;

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

4602: END IF;
4603:
4604: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4605: x_return_status := FND_API.G_RET_STS_ERROR;
4606: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4607: THEN
4608: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4609: OE_MSG_PUB.Add;
4610: END IF;

Line 4609: OE_MSG_PUB.Add;

4605: x_return_status := FND_API.G_RET_STS_ERROR;
4606: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4607: THEN
4608: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4609: OE_MSG_PUB.Add;
4610: END IF;
4611:
4612: WHEN OTHERS THEN
4613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4610: END IF;
4611:
4612: WHEN OTHERS THEN
4613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4614: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4615: THEN
4616: OE_MSG_PUB.Add_Exc_Msg
4617: ( G_PKG_NAME
4618: , 'Lock_Row'

Line 4616: OE_MSG_PUB.Add_Exc_Msg

4612: WHEN OTHERS THEN
4613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4614: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4615: THEN
4616: OE_MSG_PUB.Add_Exc_Msg
4617: ( G_PKG_NAME
4618: , 'Lock_Row'
4619: );
4620: END IF;

Line 5000: OE_MSG_PUB.Add_Exc_Msg

4996: WHEN OTHERS THEN
4997:
4998: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4999: THEN
5000: OE_MSG_PUB.Add_Exc_Msg
5001: ( G_PKG_NAME
5002: , 'Update_Row'
5003: );
5004: END IF;