48: EXCEPTION
49:
50: WHEN OTHERS THEN
51:
52: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
53: THEN
54: FND_MSG_PUB.Add_Exc_Msg
55: ( G_PKG_NAME
56: , 'Update_Row'
50: WHEN OTHERS THEN
51:
52: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
53: THEN
54: FND_MSG_PUB.Add_Exc_Msg
55: ( G_PKG_NAME
56: , 'Update_Row'
57: );
58: END IF;
133: EXCEPTION
134:
135: WHEN OTHERS THEN
136:
137: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
138: THEN
139: FND_MSG_PUB.Add_Exc_Msg
140: ( G_PKG_NAME
141: , 'Insert_Row'
135: WHEN OTHERS THEN
136:
137: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
138: THEN
139: FND_MSG_PUB.Add_Exc_Msg
140: ( G_PKG_NAME
141: , 'Insert_Row'
142: );
143: END IF;
186: EXCEPTION
187:
188: WHEN OTHERS THEN
189:
190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
191: THEN
192: FND_MSG_PUB.Add_Exc_Msg
193: ( G_PKG_NAME
194: , 'Delete_Row'
188: WHEN OTHERS THEN
189:
190: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
191: THEN
192: FND_MSG_PUB.Add_Exc_Msg
193: ( G_PKG_NAME
194: , 'Delete_Row'
195: );
196: END IF;
430:
431: x_return_status := FND_API.G_RET_STS_ERROR;
432: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
433:
434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
435: THEN
436:
437: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_CHANGED');
438: FND_MSG_PUB.Add;
434: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
435: THEN
436:
437: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_CHANGED');
438: FND_MSG_PUB.Add;
439:
440: END IF;
441:
442: END IF;
447:
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
450:
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
452: THEN
453:
454: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
455: FND_MSG_PUB.Add;
451: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
452: THEN
453:
454: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
455: FND_MSG_PUB.Add;
456:
457: END IF;
458: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
459:
459:
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_ERROR;
462:
463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
464: THEN
465:
466: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_ALREADY_LOCKED');
467: FND_MSG_PUB.Add;
463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
464: THEN
465:
466: FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_ALREADY_LOCKED');
467: FND_MSG_PUB.Add;
468:
469: END IF;
470: WHEN OTHERS THEN
471:
471:
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474:
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
476: THEN
477: FND_MSG_PUB.Add_Exc_Msg
478: ( G_PKG_NAME
479: , 'Lock_Row'
473: x_Assignment_Set_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474:
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
476: THEN
477: FND_MSG_PUB.Add_Exc_Msg
478: ( G_PKG_NAME
479: , 'Lock_Row'
480: );
481: END IF;
556: EXCEPTION
557:
558: WHEN OTHERS THEN
559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: FND_MSG_PUB.Add_Exc_Msg
563: ( G_PKG_NAME
564: , 'Query_Row'
558: WHEN OTHERS THEN
559:
560: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
561: THEN
562: FND_MSG_PUB.Add_Exc_Msg
563: ( G_PKG_NAME
564: , 'Query_Row'
565: );
566: END IF;
643: EXCEPTION
644:
645: WHEN OTHERS THEN
646:
647: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
648: THEN
649: FND_MSG_PUB.Add_Exc_Msg
650: ( G_PKG_NAME
651: , 'Query_Entity'
645: WHEN OTHERS THEN
646:
647: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
648: THEN
649: FND_MSG_PUB.Add_Exc_Msg
650: ( G_PKG_NAME
651: , 'Query_Entity'
652: );
653: END IF;