463: EXCEPTION
464:
465: WHEN OTHERS THEN
466:
467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
468: THEN
469: FND_MSG_PUB.Add_Exc_Msg
470: ( G_PKG_NAME
471: , 'Update_Row'
465: WHEN OTHERS THEN
466:
467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
468: THEN
469: FND_MSG_PUB.Add_Exc_Msg
470: ( G_PKG_NAME
471: , 'Update_Row'
472: );
473: END IF;
670: EXCEPTION
671:
672: WHEN OTHERS THEN
673:
674: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
675: THEN
676: FND_MSG_PUB.Add_Exc_Msg
677: ( G_PKG_NAME
678: , 'Insert_Row'
672: WHEN OTHERS THEN
673:
674: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
675: THEN
676: FND_MSG_PUB.Add_Exc_Msg
677: ( G_PKG_NAME
678: , 'Insert_Row'
679: );
680: END IF;
698: EXCEPTION
699:
700: WHEN OTHERS THEN
701:
702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
703: THEN
704: FND_MSG_PUB.Add_Exc_Msg
705: ( G_PKG_NAME
706: , 'Delete_Row'
700: WHEN OTHERS THEN
701:
702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
703: THEN
704: FND_MSG_PUB.Add_Exc_Msg
705: ( G_PKG_NAME
706: , 'Delete_Row'
707: );
708: END IF;
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945:
946: WHEN OTHERS THEN
947:
948: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
949: THEN
950: FND_MSG_PUB.Add_Exc_Msg
951: ( G_PKG_NAME
952: , 'Query_Rows'
946: WHEN OTHERS THEN
947:
948: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
949: THEN
950: FND_MSG_PUB.Add_Exc_Msg
951: ( G_PKG_NAME
952: , 'Query_Rows'
953: );
954: END IF;
1320:
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1323:
1324: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN
1326:
1327: FND_MESSAGE.SET_NAME('WIP','WIP_LOCK_ROW_CHANGED');
1328: FND_MSG_PUB.Add;
1324: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1325: THEN
1326:
1327: FND_MESSAGE.SET_NAME('WIP','WIP_LOCK_ROW_CHANGED');
1328: FND_MSG_PUB.Add;
1329:
1330: END IF;
1331:
1332: END IF;
1336:
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1339:
1340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1341: THEN
1342:
1343: FND_MESSAGE.SET_NAME('WIP','WIP_LOCK_ROW_DELETED');
1344: FND_MSG_PUB.Add;
1340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1341: THEN
1342:
1343: FND_MESSAGE.SET_NAME('WIP','WIP_LOCK_ROW_DELETED');
1344: FND_MSG_PUB.Add;
1345:
1346: END IF;
1347: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1348:
1348:
1349: x_return_status := FND_API.G_RET_STS_ERROR;
1350: x_Res_rec.return_status := FND_API.G_RET_STS_ERROR;
1351:
1352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1353: THEN
1354:
1355: FND_MESSAGE.SET_NAME('WIP','WIP_LOCK_ROW_ALREADY_LOCKED');
1356: FND_MSG_PUB.Add;
1352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1353: THEN
1354:
1355: FND_MESSAGE.SET_NAME('WIP','WIP_LOCK_ROW_ALREADY_LOCKED');
1356: FND_MSG_PUB.Add;
1357:
1358: END IF;
1359: WHEN OTHERS THEN
1360:
1360:
1361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1362: x_Res_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1363:
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1365: THEN
1366: FND_MSG_PUB.Add_Exc_Msg
1367: ( G_PKG_NAME
1368: , 'Lock_Row'
1362: x_Res_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1363:
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1365: THEN
1366: FND_MSG_PUB.Add_Exc_Msg
1367: ( G_PKG_NAME
1368: , 'Lock_Row'
1369: );
1370: END IF;