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 4283: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

4279:
4280: x_return_status := FND_API.G_RET_STS_ERROR;
4281: p_x_line_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4282:
4283: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4284: THEN
4285:
4286: -- Release the lock
4287: ROLLBACK TO Lock_Row;

Line 4290: OE_MSG_PUB.Add;

4286: -- Release the lock
4287: ROLLBACK TO Lock_Row;
4288:
4289: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
4290: OE_MSG_PUB.Add;
4291:
4292: END IF;
4293:
4294: END IF;

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

4363: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4364: (p_line_id IS NOT NULL AND
4365: p_line_id <> FND_API.G_MISS_NUM)
4366: THEN
4367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4368: OE_MSG_PUB.Add_Exc_Msg
4369: ( G_PKG_NAME
4370: , 'Lock_Rows'
4371: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||

Line 4368: OE_MSG_PUB.Add_Exc_Msg

4364: (p_line_id IS NOT NULL AND
4365: p_line_id <> FND_API.G_MISS_NUM)
4366: THEN
4367: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4368: OE_MSG_PUB.Add_Exc_Msg
4369: ( G_PKG_NAME
4370: , 'Lock_Rows'
4371: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||
4372: p_order_price_attrib_id || ', line_id = ' || p_line_id );

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

4419:
4420: EXCEPTION
4421: WHEN NO_DATA_FOUND THEN
4422: x_return_status := FND_API.G_RET_STS_ERROR;
4423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4424: THEN
4425: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4426: OE_MSG_PUB.Add;
4427: END IF;

Line 4426: OE_MSG_PUB.Add;

4422: x_return_status := FND_API.G_RET_STS_ERROR;
4423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4424: THEN
4425: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4426: OE_MSG_PUB.Add;
4427: END IF;
4428:
4429: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4430: x_return_status := FND_API.G_RET_STS_ERROR;

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

4427: END IF;
4428:
4429: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4430: x_return_status := FND_API.G_RET_STS_ERROR;
4431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4432: THEN
4433: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4434: OE_MSG_PUB.Add;
4435: END IF;

Line 4434: OE_MSG_PUB.Add;

4430: x_return_status := FND_API.G_RET_STS_ERROR;
4431: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4432: THEN
4433: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4434: OE_MSG_PUB.Add;
4435: END IF;
4436:
4437: WHEN OTHERS THEN
4438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4435: END IF;
4436:
4437: WHEN OTHERS THEN
4438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4439: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4440: THEN
4441: OE_MSG_PUB.Add_Exc_Msg
4442: ( G_PKG_NAME
4443: , 'Lock_Row'

Line 4441: OE_MSG_PUB.Add_Exc_Msg

4437: WHEN OTHERS THEN
4438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4439: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4440: THEN
4441: OE_MSG_PUB.Add_Exc_Msg
4442: ( G_PKG_NAME
4443: , 'Lock_Row'
4444: );
4445: END IF;