457:
458: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
459: THEN
460:
461: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
462: FND_MSG_PUB.Add;
463:
464: END IF;
465:
474:
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
476: THEN
477:
478: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
479: FND_MSG_PUB.Add;
480:
481: END IF;
482: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
486:
487: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
488: THEN
489:
490: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
491: FND_MSG_PUB.Add;
492:
493: END IF;
494: WHEN OTHERS THEN
568:
569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
570: THEN
571:
572: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
574: FND_MSG_PUB.Add;
575:
576: END IF;
569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
570: THEN
571:
572: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
574: FND_MSG_PUB.Add;
575:
576: END IF;
577:
598:
599: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
600: THEN
601:
602: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
603: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');
604: FND_MSG_PUB.Add;
605:
606: END IF;
599: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
600: THEN
601:
602: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
603: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');
604: FND_MSG_PUB.Add;
605:
606: END IF;
607: