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 4047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4043: EXCEPTION
4044:
4045: WHEN OTHERS THEN
4046:
4047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4048: THEN
4049: OE_MSG_PUB.Add_Exc_Msg
4050: ( G_PKG_NAME
4051: , 'Update_Row'

Line 4049: OE_MSG_PUB.Add_Exc_Msg

4045: WHEN OTHERS THEN
4046:
4047: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4048: THEN
4049: OE_MSG_PUB.Add_Exc_Msg
4050: ( G_PKG_NAME
4051: , 'Update_Row'
4052: );
4053: END IF;

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

4152:
4153: x_return_status := FND_API.G_RET_STS_ERROR;
4154: p_x_Header_Price_Att_rec.return_status := FND_API.G_RET_STS_ERROR;
4155:
4156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4157: THEN
4158:
4159: -- Release the lock
4160: ROLLBACK TO Lock_Row;

Line 4163: OE_MSG_PUB.Add;

4159: -- Release the lock
4160: ROLLBACK TO Lock_Row;
4161:
4162: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
4163: OE_MSG_PUB.Add;
4164:
4165: END IF;
4166:
4167: END IF;

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

4242: p_order_price_attrib_id <> FND_API.G_MISS_NUM) AND
4243: (p_header_id IS NOT NULL AND
4244: p_header_id <> FND_API.G_MISS_NUM)
4245: THEN
4246: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4247: OE_MSG_PUB.Add_Exc_Msg
4248: ( G_PKG_NAME
4249: , 'Lock_Rows'
4250: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||

Line 4247: OE_MSG_PUB.Add_Exc_Msg

4243: (p_header_id IS NOT NULL AND
4244: p_header_id <> FND_API.G_MISS_NUM)
4245: THEN
4246: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4247: OE_MSG_PUB.Add_Exc_Msg
4248: ( G_PKG_NAME
4249: , 'Lock_Rows'
4250: , 'Keys are mutually exclusive: order_price_attrib_id = ' ||
4251: p_order_price_attrib_id || ', header_id = ' || p_header_id );

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

4298:
4299: EXCEPTION
4300: WHEN NO_DATA_FOUND THEN
4301: x_return_status := FND_API.G_RET_STS_ERROR;
4302: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4303: THEN
4304: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4305: OE_MSG_PUB.Add;
4306: END IF;

Line 4305: OE_MSG_PUB.Add;

4301: x_return_status := FND_API.G_RET_STS_ERROR;
4302: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4303: THEN
4304: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
4305: OE_MSG_PUB.Add;
4306: END IF;
4307:
4308: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4309: x_return_status := FND_API.G_RET_STS_ERROR;

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

4306: END IF;
4307:
4308: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4309: x_return_status := FND_API.G_RET_STS_ERROR;
4310: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4311: THEN
4312: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4313: OE_MSG_PUB.Add;
4314: END IF;

Line 4313: OE_MSG_PUB.Add;

4309: x_return_status := FND_API.G_RET_STS_ERROR;
4310: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4311: THEN
4312: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
4313: OE_MSG_PUB.Add;
4314: END IF;
4315:
4316: WHEN OTHERS THEN
4317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4314: END IF;
4315:
4316: WHEN OTHERS THEN
4317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4319: THEN
4320: OE_MSG_PUB.Add_Exc_Msg
4321: ( G_PKG_NAME
4322: , 'Lock_Rows'

Line 4320: OE_MSG_PUB.Add_Exc_Msg

4316: WHEN OTHERS THEN
4317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4319: THEN
4320: OE_MSG_PUB.Add_Exc_Msg
4321: ( G_PKG_NAME
4322: , 'Lock_Rows'
4323: );
4324: END IF;