DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_UTIL dependencies on OE_MSG_PUB

Line 2873: OE_MSG_PUB.Add_Exc_Msg

2869: WHEN OTHERS THEN
2870:
2871: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2872: THEN
2873: OE_MSG_PUB.Add_Exc_Msg
2874: ( G_PKG_NAME
2875: , 'Update_Row'
2876: );
2877: END IF;

Line 3163: OE_MSG_PUB.Add_Exc_Msg

3159: WHEN OTHERS THEN
3160:
3161: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3162: THEN
3163: OE_MSG_PUB.Add_Exc_Msg
3164: ( G_PKG_NAME
3165: , 'Insert_Row'
3166: );
3167: END IF;

Line 3381: OE_MSG_PUB.Add_Exc_Msg

3377: WHEN OTHERS THEN
3378:
3379: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3380: THEN
3381: OE_MSG_PUB.Add_Exc_Msg
3382: ( G_PKG_NAME
3383: , 'Delete_Row'
3384: );
3385: END IF;

Line 3665: OE_MSG_PUB.Add_Exc_Msg

3661: p_header_id <> FND_API.G_MISS_NUM)
3662: THEN
3663: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3664: THEN
3665: OE_MSG_PUB.Add_Exc_Msg
3666: ( G_PKG_NAME
3667: , 'Query Rows'
3668: , 'Keys are mutually exclusive: price_adjustment_id = '|| p_price_adjustment_id || ', header_id = '|| p_header_id
3669: );

Line 3841: OE_MSG_PUB.Add_Exc_Msg

3837: WHEN OTHERS THEN
3838:
3839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3840: THEN
3841: OE_MSG_PUB.Add_Exc_Msg
3842: ( G_PKG_NAME
3843: , 'Query_Rows'
3844: );
3845: END IF;

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

3958:
3959: x_return_status := FND_API.G_RET_STS_ERROR;
3960: p_x_header_adj_rec.return_status := FND_API.G_RET_STS_ERROR;
3961:
3962: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3963: THEN
3964:
3965: -- Release the lock
3966: ROLLBACK TO Lock_Row;

Line 3969: OE_MSG_PUB.Add;

3965: -- Release the lock
3966: ROLLBACK TO Lock_Row;
3967:
3968: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
3969: OE_MSG_PUB.Add;
3970:
3971: END IF;
3972:
3973: END IF;

Line 4012: OE_MSG_PUB.Add_Exc_Msg

4008: p_x_Header_Adj_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4009:
4010: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4011: THEN
4012: OE_MSG_PUB.Add_Exc_Msg
4013: ( G_PKG_NAME
4014: , 'Lock_Row'
4015: );
4016: END IF;

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

4051: p_price_adjustment_id <> FND_API.G_MISS_NUM) AND
4052: (p_header_id IS NOT NULL AND
4053: p_header_id <> FND_API.G_MISS_NUM)
4054: THEN
4055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4056: OE_MSG_PUB.Add_Exc_Msg
4057: ( G_PKG_NAME
4058: , 'Lock_Rows'
4059: , 'Keys are mutually exclusive: price_adjustment_id = ' ||

Line 4056: OE_MSG_PUB.Add_Exc_Msg

4052: (p_header_id IS NOT NULL AND
4053: p_header_id <> FND_API.G_MISS_NUM)
4054: THEN
4055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4056: OE_MSG_PUB.Add_Exc_Msg
4057: ( G_PKG_NAME
4058: , 'Lock_Rows'
4059: , 'Keys are mutually exclusive: price_adjustment_id = ' ||
4060: p_price_adjustment_id || ', header_id = ' || p_header_id );

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

4106:
4107: EXCEPTION
4108: WHEN NO_DATA_FOUND THEN
4109: x_return_status := FND_API.G_RET_STS_ERROR;
4110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4111: THEN
4112: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4113: OE_MSG_PUB.Add;
4114: END IF;

Line 4113: OE_MSG_PUB.Add;

4109: x_return_status := FND_API.G_RET_STS_ERROR;
4110: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4111: THEN
4112: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4113: OE_MSG_PUB.Add;
4114: END IF;
4115:
4116: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4117: x_return_status := FND_API.G_RET_STS_ERROR;

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

4114: END IF;
4115:
4116: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4117: x_return_status := FND_API.G_RET_STS_ERROR;
4118: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4119: THEN
4120: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4121: OE_MSG_PUB.Add;
4122: END IF;

Line 4121: OE_MSG_PUB.Add;

4117: x_return_status := FND_API.G_RET_STS_ERROR;
4118: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4119: THEN
4120: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4121: OE_MSG_PUB.Add;
4122: END IF;
4123:
4124: WHEN OTHERS THEN
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4122: END IF;
4123:
4124: WHEN OTHERS THEN
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4127: THEN
4128: OE_MSG_PUB.Add_Exc_Msg
4129: ( G_PKG_NAME
4130: , 'Lock_Row'

Line 4128: OE_MSG_PUB.Add_Exc_Msg

4124: WHEN OTHERS THEN
4125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4126: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4127: THEN
4128: OE_MSG_PUB.Add_Exc_Msg
4129: ( G_PKG_NAME
4130: , 'Lock_Row'
4131: );
4132: END IF;

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

4348:
4349: WHEN OTHERS THEN
4350:
4351: -- Unexpected error
4352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4353:
4354: OE_MSG_PUB.Add_Exc_Msg
4355: ( G_PKG_NAME ,
4356: 'Price_Utilities - Get_Adj_Total'

Line 4354: OE_MSG_PUB.Add_Exc_Msg

4350:
4351: -- Unexpected error
4352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4353:
4354: OE_MSG_PUB.Add_Exc_Msg
4355: ( G_PKG_NAME ,
4356: 'Price_Utilities - Get_Adj_Total'
4357: );
4358: END IF;

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

4451:
4452: WHEN OTHERS THEN
4453:
4454: -- Unexpected error
4455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4456:
4457: OE_MSG_PUB.Add_Exc_Msg
4458: ( G_PKG_NAME ,
4459: 'Header_utilities - get_line_adjustments'

Line 4457: OE_MSG_PUB.Add_Exc_Msg

4453:
4454: -- Unexpected error
4455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4456:
4457: OE_MSG_PUB.Add_Exc_Msg
4458: ( G_PKG_NAME ,
4459: 'Header_utilities - get_line_adjustments'
4460: );
4461: END IF;

Line 4727: OE_MSG_PUB.Add_Exc_Msg

4723: oe_debug_pub.add(G_PKG_NAME||':copy_header_adjuetments :'||SQLERRM);
4724:
4725: WHEN OTHERS THEN
4726: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
4727: OE_MSG_PUB.Add_Exc_Msg
4728: ( G_PKG_NAME
4729: , 'Copy_header_adjustments '
4730: );
4731: End If;

Line 4976: OE_MSG_PUB.Add_Exc_Msg

4972: END IF;
4973:
4974: WHEN OTHERS THEN
4975: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
4976: OE_MSG_PUB.Add_Exc_Msg
4977: ( G_PKG_NAME
4978: , 'Copy_Freight_Charges'
4979: );
4980: End If;

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

5051:
5052: WHEN OTHERS THEN
5053:
5054: -- Unexpected error
5055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5056:
5057: OE_MSG_PUB.Add_Exc_Msg
5058: ( G_PKG_NAME ,
5059: 'Price_Utilities - Get_Adj_Total'

Line 5057: OE_MSG_PUB.Add_Exc_Msg

5053:
5054: -- Unexpected error
5055: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5056:
5057: OE_MSG_PUB.Add_Exc_Msg
5058: ( G_PKG_NAME ,
5059: 'Price_Utilities - Get_Adj_Total'
5060: );
5061: END IF;