DBA Data[Home] [Help]

APPS.OE_LINE_PATTR_UTIL dependencies on OE_MSG_PUB

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

182: AND
183: p_line_id <> FND_API.G_MISS_NUM)
184: THEN
185:
186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
188: OE_MSG_PUB.Add_Exc_Msg
189: ( G_PKG_NAME
190: , 'Query Rows'

Line 188: OE_MSG_PUB.Add_Exc_Msg

184: THEN
185:
186: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
188: OE_MSG_PUB.Add_Exc_Msg
189: ( G_PKG_NAME
190: , 'Query Rows'
191: , 'Keys are mutually exclusive'
192: );

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

364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365:
366: WHEN OTHERS THEN
367:
368: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369: THEN
370: OE_MSG_PUB.Add_Exc_Msg
371: ( G_PKG_NAME
372: , 'Query_Rows'

Line 370: OE_MSG_PUB.Add_Exc_Msg

366: WHEN OTHERS THEN
367:
368: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369: THEN
370: OE_MSG_PUB.Add_Exc_Msg
371: ( G_PKG_NAME
372: , 'Query_Rows'
373: );
374: END IF;

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

878: EXCEPTION
879:
880: WHEN OTHERS THEN
881:
882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884: OE_MSG_PUB.Add_Exc_Msg
885: ( G_PKG_NAME
886: , 'Update_Row'

Line 884: OE_MSG_PUB.Add_Exc_Msg

880: WHEN OTHERS THEN
881:
882: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884: OE_MSG_PUB.Add_Exc_Msg
885: ( G_PKG_NAME
886: , 'Update_Row'
887: );
888: END IF;

Line 3451: OE_MSG_PUB.ADD;

3447:
3448: IF l_return_status = 'E' THEN
3449: oe_debug_pub.add('OTA API - Error.', 1);
3450: FND_MESSAGE.SET_NAME('OTA',l_msg_name);
3451: OE_MSG_PUB.ADD;
3452: RAISE FND_API.G_EXC_ERROR;
3453: END IF;
3454:
3455: ELSE

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

4238:
4239: x_return_status := FND_API.G_RET_STS_ERROR;
4240: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4241:
4242: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4243: THEN
4244:
4245: -- Release the lock
4246: ROLLBACK TO Lock_Row;

Line 4249: OE_MSG_PUB.Add;

4245: -- Release the lock
4246: ROLLBACK TO Lock_Row;
4247:
4248: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
4249: OE_MSG_PUB.Add;
4250:
4251: END IF;
4252:
4253: END IF;

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

4322: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4323: (p_line_id IS NOT NULL AND
4324: p_line_id <> FND_API.G_MISS_NUM)
4325: THEN
4326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4327: OE_MSG_PUB.Add_Exc_Msg
4328: ( G_PKG_NAME
4329: , 'Lock_Rows'
4330: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||

Line 4327: OE_MSG_PUB.Add_Exc_Msg

4323: (p_line_id IS NOT NULL AND
4324: p_line_id <> FND_API.G_MISS_NUM)
4325: THEN
4326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4327: OE_MSG_PUB.Add_Exc_Msg
4328: ( G_PKG_NAME
4329: , 'Lock_Rows'
4330: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||
4331: p_order_price_attrib_id || ', line_id = ' || p_line_id );

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

4378:
4379: EXCEPTION
4380: WHEN NO_DATA_FOUND THEN
4381: x_return_status := FND_API.G_RET_STS_ERROR;
4382: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4383: THEN
4384: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4385: OE_MSG_PUB.Add;
4386: END IF;

Line 4385: OE_MSG_PUB.Add;

4381: x_return_status := FND_API.G_RET_STS_ERROR;
4382: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4383: THEN
4384: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4385: OE_MSG_PUB.Add;
4386: END IF;
4387:
4388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4389: x_return_status := FND_API.G_RET_STS_ERROR;

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

4386: END IF;
4387:
4388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4389: x_return_status := FND_API.G_RET_STS_ERROR;
4390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4391: THEN
4392: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4393: OE_MSG_PUB.Add;
4394: END IF;

Line 4393: OE_MSG_PUB.Add;

4389: x_return_status := FND_API.G_RET_STS_ERROR;
4390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4391: THEN
4392: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4393: OE_MSG_PUB.Add;
4394: END IF;
4395:
4396: WHEN OTHERS THEN
4397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4394: END IF;
4395:
4396: WHEN OTHERS THEN
4397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4398: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4399: THEN
4400: OE_MSG_PUB.Add_Exc_Msg
4401: ( G_PKG_NAME
4402: , 'Lock_Row'

Line 4400: OE_MSG_PUB.Add_Exc_Msg

4396: WHEN OTHERS THEN
4397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4398: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4399: THEN
4400: OE_MSG_PUB.Add_Exc_Msg
4401: ( G_PKG_NAME
4402: , 'Lock_Row'
4403: );
4404: END IF;