188: AND
189: p_header_id <> FND_API.G_MISS_NUM)
190: THEN
191:
192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
193: THEN
194: OE_MSG_PUB.Add_Exc_Msg
195: ( G_PKG_NAME
196: , 'Query Rows'
190: THEN
191:
192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
193: THEN
194: OE_MSG_PUB.Add_Exc_Msg
195: ( G_PKG_NAME
196: , 'Query Rows'
197: , 'Keys are mutually exclusive'
198: );
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369:
370: WHEN OTHERS THEN
371:
372: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
373: THEN
374: OE_MSG_PUB.Add_Exc_Msg
375: ( G_PKG_NAME
376: , 'Query_Rows'
370: WHEN OTHERS THEN
371:
372: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
373: THEN
374: OE_MSG_PUB.Add_Exc_Msg
375: ( G_PKG_NAME
376: , 'Query_Rows'
377: );
378: END IF;
4031: EXCEPTION
4032:
4033: WHEN OTHERS THEN
4034:
4035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4036: THEN
4037: OE_MSG_PUB.Add_Exc_Msg
4038: ( G_PKG_NAME
4039: , 'Update_Row'
4033: WHEN OTHERS THEN
4034:
4035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4036: THEN
4037: OE_MSG_PUB.Add_Exc_Msg
4038: ( G_PKG_NAME
4039: , 'Update_Row'
4040: );
4041: END IF;
4140:
4141: x_return_status := FND_API.G_RET_STS_ERROR;
4142: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4143:
4144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4145: THEN
4146:
4147: -- Release the lock
4148: ROLLBACK TO Lock_Row;
4147: -- Release the lock
4148: ROLLBACK TO Lock_Row;
4149:
4150: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
4151: OE_MSG_PUB.Add;
4152:
4153: END IF;
4154:
4155: END IF;
4230: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4231: (p_header_id IS NOT NULL AND
4232: p_header_id <> FND_API.G_MISS_NUM)
4233: THEN
4234: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4235: OE_MSG_PUB.Add_Exc_Msg
4236: ( G_PKG_NAME
4237: , 'Lock_Rows'
4238: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||
4231: (p_header_id IS NOT NULL AND
4232: p_header_id <> FND_API.G_MISS_NUM)
4233: THEN
4234: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4235: OE_MSG_PUB.Add_Exc_Msg
4236: ( G_PKG_NAME
4237: , 'Lock_Rows'
4238: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||
4239: p_order_price_attrib_id || ', header_id = ' || p_header_id );
4286:
4287: EXCEPTION
4288: WHEN NO_DATA_FOUND THEN
4289: x_return_status := FND_API.G_RET_STS_ERROR;
4290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4291: THEN
4292: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4293: OE_MSG_PUB.Add;
4294: END IF;
4289: x_return_status := FND_API.G_RET_STS_ERROR;
4290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4291: THEN
4292: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4293: OE_MSG_PUB.Add;
4294: END IF;
4295:
4296: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4297: x_return_status := FND_API.G_RET_STS_ERROR;
4294: END IF;
4295:
4296: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4297: x_return_status := FND_API.G_RET_STS_ERROR;
4298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4299: THEN
4300: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4301: OE_MSG_PUB.Add;
4302: END IF;
4297: x_return_status := FND_API.G_RET_STS_ERROR;
4298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4299: THEN
4300: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4301: OE_MSG_PUB.Add;
4302: END IF;
4303:
4304: WHEN OTHERS THEN
4305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4302: END IF;
4303:
4304: WHEN OTHERS THEN
4305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4307: THEN
4308: OE_MSG_PUB.Add_Exc_Msg
4309: ( G_PKG_NAME
4310: , 'Lock_Rows'
4304: WHEN OTHERS THEN
4305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4307: THEN
4308: OE_MSG_PUB.Add_Exc_Msg
4309: ( G_PKG_NAME
4310: , 'Lock_Rows'
4311: );
4312: END IF;