DBA Data[Home] [Help]

APPS.OE_LINE_ADJ_UTIL dependencies on FND_MSG_PUB

Line 3015: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3011: EXCEPTION
3012:
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'

Line 3341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3337: Reset_Sequence;
3338: IF l_debug_level > 0 THEN
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'

Line 3349: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);

3345: , 'Insert_Row'
3346: );
3347: END IF;
3348:
3349: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);
3350:
3351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3352:
3353: WHEN OTHERS THEN

Line 3357: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3353: WHEN OTHERS THEN
3354: IF l_debug_level > 0 THEN
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'

Line 3365: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);

3361: , 'Insert_Row'
3362: );
3363: END IF;
3364:
3365: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);
3366:
3367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3368:
3369: END Insert_Row;

Line 3537: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3533: WHEN OTHERS THEN
3534: IF l_debug_level > 0 THEN
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'

Line 4050: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4046: (p_line_id IS NOT NULL
4047: AND
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'

Line 4261: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4257: WHEN OTHERS THEN
4258: IF l_debug_level > 0 THEN
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'

Line 4394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4390:
4391: x_return_status := FND_API.G_RET_STS_ERROR;
4392: p_x_Line_Adj_rec.return_status := FND_API.G_RET_STS_ERROR;
4393:
4394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4395: THEN
4396:
4397: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
4398: FND_MSG_PUB.Add;

Line 4398: FND_MSG_PUB.Add;

4394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4395: THEN
4396:
4397: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
4398: FND_MSG_PUB.Add;
4399:
4400: END IF;
4401: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4402:

Line 4406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

4402:
4403: x_return_status := FND_API.G_RET_STS_ERROR;
4404: p_x_Line_Adj_rec.return_status := FND_API.G_RET_STS_ERROR;
4405:
4406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4407: THEN
4408:
4409: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4410: FND_MSG_PUB.Add;

Line 4410: FND_MSG_PUB.Add;

4406: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4407: THEN
4408:
4409: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4410: FND_MSG_PUB.Add;
4411:
4412: END IF;
4413: WHEN OTHERS THEN
4414:

Line 4418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4414:
4415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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'

Line 4647: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

4643: IF p_x_Line_Adj_rec.discount_id <> FND_API.G_MISS_NUM THEN
4644:
4645: l_Line_Adj_rec.discount_id := p_x_Line_Adj_rec.discount_id;
4646:
4647: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4648: THEN
4649:
4650: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');

Line 4652: FND_MSG_PUB.Add;

4648: THEN
4649:
4650: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
4652: FND_MSG_PUB.Add;
4653:
4654: END IF;
4655:
4656: ELSE

Line 4920: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4916: EXCEPTION
4917:
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'