DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_UTIL dependencies on OE_MSG_PUB

Line 2930: OE_MSG_PUB.Add_Exc_Msg

2926: WHEN OTHERS THEN
2927:
2928: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2929: THEN
2930: OE_MSG_PUB.Add_Exc_Msg
2931: ( G_PKG_NAME
2932: , 'Update_Row'
2933: );
2934: END IF;

Line 3222: OE_MSG_PUB.Add_Exc_Msg

3218: WHEN OTHERS THEN
3219:
3220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3221: THEN
3222: OE_MSG_PUB.Add_Exc_Msg
3223: ( G_PKG_NAME
3224: , 'Insert_Row'
3225: );
3226: END IF;

Line 3440: OE_MSG_PUB.Add_Exc_Msg

3436: WHEN OTHERS THEN
3437:
3438: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3439: THEN
3440: OE_MSG_PUB.Add_Exc_Msg
3441: ( G_PKG_NAME
3442: , 'Delete_Row'
3443: );
3444: END IF;

Line 3724: OE_MSG_PUB.Add_Exc_Msg

3720: p_header_id <> FND_API.G_MISS_NUM)
3721: THEN
3722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3723: THEN
3724: OE_MSG_PUB.Add_Exc_Msg
3725: ( G_PKG_NAME
3726: , 'Query Rows'
3727: , 'Keys are mutually exclusive: price_adjustment_id = '|| p_price_adjustment_id || ', header_id = '|| p_header_id
3728: );

Line 3900: OE_MSG_PUB.Add_Exc_Msg

3896: WHEN OTHERS THEN
3897:
3898: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3899: THEN
3900: OE_MSG_PUB.Add_Exc_Msg
3901: ( G_PKG_NAME
3902: , 'Query_Rows'
3903: );
3904: END IF;

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

4017:
4018: x_return_status := FND_API.G_RET_STS_ERROR;
4019: p_x_header_adj_rec.return_status := FND_API.G_RET_STS_ERROR;
4020:
4021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4022: THEN
4023:
4024: -- Release the lock
4025: ROLLBACK TO Lock_Row;

Line 4028: OE_MSG_PUB.Add;

4024: -- Release the lock
4025: ROLLBACK TO Lock_Row;
4026:
4027: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
4028: OE_MSG_PUB.Add;
4029:
4030: END IF;
4031:
4032: END IF;

Line 4071: OE_MSG_PUB.Add_Exc_Msg

4067: p_x_Header_Adj_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4068:
4069: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4070: THEN
4071: OE_MSG_PUB.Add_Exc_Msg
4072: ( G_PKG_NAME
4073: , 'Lock_Row'
4074: );
4075: END IF;

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

4110: p_price_adjustment_id <> FND_API.G_MISS_NUM) AND
4111: (p_header_id IS NOT NULL AND
4112: p_header_id <> FND_API.G_MISS_NUM)
4113: THEN
4114: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4115: OE_MSG_PUB.Add_Exc_Msg
4116: ( G_PKG_NAME
4117: , 'Lock_Rows'
4118: , 'Keys are mutually exclusive: price_adjustment_id = ' ||

Line 4115: OE_MSG_PUB.Add_Exc_Msg

4111: (p_header_id IS NOT NULL AND
4112: p_header_id <> FND_API.G_MISS_NUM)
4113: THEN
4114: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4115: OE_MSG_PUB.Add_Exc_Msg
4116: ( G_PKG_NAME
4117: , 'Lock_Rows'
4118: , 'Keys are mutually exclusive: price_adjustment_id = ' ||
4119: p_price_adjustment_id || ', header_id = ' || p_header_id );

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

4165:
4166: EXCEPTION
4167: WHEN NO_DATA_FOUND THEN
4168: x_return_status := FND_API.G_RET_STS_ERROR;
4169: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4170: THEN
4171: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4172: OE_MSG_PUB.Add;
4173: END IF;

Line 4172: OE_MSG_PUB.Add;

4168: x_return_status := FND_API.G_RET_STS_ERROR;
4169: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4170: THEN
4171: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4172: OE_MSG_PUB.Add;
4173: END IF;
4174:
4175: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4176: x_return_status := FND_API.G_RET_STS_ERROR;

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

4173: END IF;
4174:
4175: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4176: x_return_status := FND_API.G_RET_STS_ERROR;
4177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4178: THEN
4179: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4180: OE_MSG_PUB.Add;
4181: END IF;

Line 4180: OE_MSG_PUB.Add;

4176: x_return_status := FND_API.G_RET_STS_ERROR;
4177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4178: THEN
4179: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4180: OE_MSG_PUB.Add;
4181: END IF;
4182:
4183: WHEN OTHERS THEN
4184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4181: END IF;
4182:
4183: WHEN OTHERS THEN
4184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4186: THEN
4187: OE_MSG_PUB.Add_Exc_Msg
4188: ( G_PKG_NAME
4189: , 'Lock_Row'

Line 4187: OE_MSG_PUB.Add_Exc_Msg

4183: WHEN OTHERS THEN
4184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4186: THEN
4187: OE_MSG_PUB.Add_Exc_Msg
4188: ( G_PKG_NAME
4189: , 'Lock_Row'
4190: );
4191: END IF;

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

4407:
4408: WHEN OTHERS THEN
4409:
4410: -- Unexpected error
4411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4412:
4413: OE_MSG_PUB.Add_Exc_Msg
4414: ( G_PKG_NAME ,
4415: 'Price_Utilities - Get_Adj_Total'

Line 4413: OE_MSG_PUB.Add_Exc_Msg

4409:
4410: -- Unexpected error
4411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4412:
4413: OE_MSG_PUB.Add_Exc_Msg
4414: ( G_PKG_NAME ,
4415: 'Price_Utilities - Get_Adj_Total'
4416: );
4417: END IF;

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

4510:
4511: WHEN OTHERS THEN
4512:
4513: -- Unexpected error
4514: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4515:
4516: OE_MSG_PUB.Add_Exc_Msg
4517: ( G_PKG_NAME ,
4518: 'Header_utilities - get_line_adjustments'

Line 4516: OE_MSG_PUB.Add_Exc_Msg

4512:
4513: -- Unexpected error
4514: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4515:
4516: OE_MSG_PUB.Add_Exc_Msg
4517: ( G_PKG_NAME ,
4518: 'Header_utilities - get_line_adjustments'
4519: );
4520: END IF;

Line 4883: OE_MSG_PUB.Add_Exc_Msg

4879: oe_debug_pub.add(G_PKG_NAME||':copy_header_adjuetments :'||SQLERRM);
4880:
4881: WHEN OTHERS THEN
4882: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
4883: OE_MSG_PUB.Add_Exc_Msg
4884: ( G_PKG_NAME
4885: , 'Copy_header_adjustments '
4886: );
4887: End If;

Line 5132: OE_MSG_PUB.Add_Exc_Msg

5128: END IF;
5129:
5130: WHEN OTHERS THEN
5131: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
5132: OE_MSG_PUB.Add_Exc_Msg
5133: ( G_PKG_NAME
5134: , 'Copy_Freight_Charges'
5135: );
5136: End If;

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

5207:
5208: WHEN OTHERS THEN
5209:
5210: -- Unexpected error
5211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5212:
5213: OE_MSG_PUB.Add_Exc_Msg
5214: ( G_PKG_NAME ,
5215: 'Price_Utilities - Get_Adj_Total'

Line 5213: OE_MSG_PUB.Add_Exc_Msg

5209:
5210: -- Unexpected error
5211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5212:
5213: OE_MSG_PUB.Add_Exc_Msg
5214: ( G_PKG_NAME ,
5215: 'Price_Utilities - Get_Adj_Total'
5216: );
5217: END IF;