DBA Data[Home] [Help]

APPS.OE_HEADER_PATTR_UTIL dependencies on OE_MSG_PUB

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

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'

Line 194: OE_MSG_PUB.Add_Exc_Msg

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: );

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

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'

Line 374: OE_MSG_PUB.Add_Exc_Msg

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;

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

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'

Line 4037: OE_MSG_PUB.Add_Exc_Msg

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;

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

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;

Line 4151: OE_MSG_PUB.Add;

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;

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

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 = ' ||

Line 4235: OE_MSG_PUB.Add_Exc_Msg

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 );

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

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;

Line 4293: OE_MSG_PUB.Add;

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;

Line 4298: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_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;

Line 4301: OE_MSG_PUB.Add;

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;

Line 4306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_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'

Line 4308: OE_MSG_PUB.Add_Exc_Msg

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;