183: EXCEPTION
184:
185: WHEN OTHERS THEN
186:
187: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
188: THEN
189: FND_MSG_PUB.Add_Exc_Msg
190: ( G_PKG_NAME
191: , 'Update_Row'
185: WHEN OTHERS THEN
186:
187: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
188: THEN
189: FND_MSG_PUB.Add_Exc_Msg
190: ( G_PKG_NAME
191: , 'Update_Row'
192: );
193: END IF;
242: EXCEPTION
243:
244: WHEN OTHERS THEN
245:
246: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
247: THEN
248: FND_MSG_PUB.Add_Exc_Msg
249: ( G_PKG_NAME
250: , 'Insert_Row'
244: WHEN OTHERS THEN
245:
246: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
247: THEN
248: FND_MSG_PUB.Add_Exc_Msg
249: ( G_PKG_NAME
250: , 'Insert_Row'
251: );
252: END IF;
270: EXCEPTION
271:
272: WHEN OTHERS THEN
273:
274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
275: THEN
276: FND_MSG_PUB.Add_Exc_Msg
277: ( G_PKG_NAME
278: , 'Delete_Row'
272: WHEN OTHERS THEN
273:
274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
275: THEN
276: FND_MSG_PUB.Add_Exc_Msg
277: ( G_PKG_NAME
278: , 'Delete_Row'
279: );
280: END IF;
331: EXCEPTION
332:
333: WHEN OTHERS THEN
334:
335: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg
338: ( G_PKG_NAME
339: , 'Query_Row'
333: WHEN OTHERS THEN
334:
335: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg
338: ( G_PKG_NAME
339: , 'Query_Row'
340: );
341: END IF;
439:
440: x_return_status := FND_API.G_RET_STS_ERROR;
441: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
442:
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
444: THEN
445:
446: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_CHANGED');
447: FND_MSG_PUB.Add;
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
444: THEN
445:
446: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_CHANGED');
447: FND_MSG_PUB.Add;
448:
449: END IF;
450:
451: END IF;
455:
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
458:
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461:
462: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
463: FND_MSG_PUB.Add;
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
460: THEN
461:
462: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_DELETED');
463: FND_MSG_PUB.Add;
464:
465: END IF;
466: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
467:
467:
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_ERROR;
470:
471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
472: THEN
473:
474: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_ALREADY_LOCKED');
475: FND_MSG_PUB.Add;
471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
472: THEN
473:
474: FND_MESSAGE.SET_NAME('WIP','OE_LOCK_ROW_ALREADY_LOCKED');
475: FND_MSG_PUB.Add;
476:
477: END IF;
478: WHEN OTHERS THEN
479:
479:
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482:
483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME
487: , 'Lock_Row'
481: x_Wip_Entities_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482:
483: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg
486: ( G_PKG_NAME
487: , 'Lock_Row'
488: );
489: END IF;