DBA Data[Home] [Help]

APPS.OE_LINE_ADJ_UTIL dependencies on FND_MSG_PUB

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

3089: EXCEPTION
3090:
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'

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

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

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

3423: , 'Insert_Row'
3424: );
3425: END IF;
3426:
3427: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);
3428:
3429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3430:
3431: WHEN OTHERS THEN

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

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

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

3439: , 'Insert_Row'
3440: );
3441: END IF;
3442:
3443: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Insert_Row:'||SQLERRM);
3444:
3445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3446:
3447: END Insert_Row;

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

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

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

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

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

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

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

4468:
4469: x_return_status := FND_API.G_RET_STS_ERROR;
4470: p_x_Line_Adj_rec.return_status := FND_API.G_RET_STS_ERROR;
4471:
4472: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4473: THEN
4474:
4475: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
4476: FND_MSG_PUB.Add;

Line 4476: FND_MSG_PUB.Add;

4472: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4473: THEN
4474:
4475: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
4476: FND_MSG_PUB.Add;
4477:
4478: END IF;
4479: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4480:

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

4480:
4481: x_return_status := FND_API.G_RET_STS_ERROR;
4482: p_x_Line_Adj_rec.return_status := FND_API.G_RET_STS_ERROR;
4483:
4484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4485: THEN
4486:
4487: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4488: FND_MSG_PUB.Add;

Line 4488: FND_MSG_PUB.Add;

4484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4485: THEN
4486:
4487: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4488: FND_MSG_PUB.Add;
4489:
4490: END IF;
4491: WHEN OTHERS THEN
4492:

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

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

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

4721: IF p_x_Line_Adj_rec.discount_id <> FND_API.G_MISS_NUM THEN
4722:
4723: l_Line_Adj_rec.discount_id := p_x_Line_Adj_rec.discount_id;
4724:
4725: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
4726: THEN
4727:
4728: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4729: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');

Line 4730: FND_MSG_PUB.Add;

4726: THEN
4727:
4728: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4729: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount');
4730: FND_MSG_PUB.Add;
4731:
4732: END IF;
4733:
4734: ELSE

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

4994: EXCEPTION
4995:
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'