536: OPEN C;
537: FETCH C INTO Recinfo;
538: IF ( C%NOTFOUND ) THEN
539: CLOSE C;
540: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
541: APP_EXCEPTION.RAISE_EXCEPTION;
542: END IF;
543: CLOSE C;
544:
773: AND ( X_ACTUAL_CONTENT_SOURCE IS NULL ) ) )
774: ) THEN
775: RETURN;
776: ELSE
777: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
778: APP_EXCEPTION.RAISE_EXCEPTION;
779: END IF;
780:
781: END Lock_Row;
989: WHERE PERSON_PROFILE_ID = X_PERSON_PROFILE_ID;
990:
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
994: FND_MESSAGE.SET_TOKEN( 'RECORD', 'person_profile_rec');
995: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PERSON_PROFILE_ID ) );
996: FND_MSG_PUB.ADD;
997: RAISE FND_API.G_EXC_ERROR;
990:
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
994: FND_MESSAGE.SET_TOKEN( 'RECORD', 'person_profile_rec');
995: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PERSON_PROFILE_ID ) );
996: FND_MSG_PUB.ADD;
997: RAISE FND_API.G_EXC_ERROR;
998:
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
994: FND_MESSAGE.SET_TOKEN( 'RECORD', 'person_profile_rec');
995: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_PERSON_PROFILE_ID ) );
996: FND_MSG_PUB.ADD;
997: RAISE FND_API.G_EXC_ERROR;
998:
999: END Select_Row;