267: OPEN C;
268: FETCH C INTO Recinfo;
269: IF ( C%NOTFOUND ) THEN
270: CLOSE C;
271: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
272: APP_EXCEPTION.RAISE_EXCEPTION;
273: END IF;
274: CLOSE C;
275:
375: AND ( X_APPLICATION_ID IS NULL ) ) )
376: ) THEN
377: RETURN;
378: ELSE
379: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
380: APP_EXCEPTION.RAISE_EXCEPTION;
381: END IF;
382:
383: END Lock_Row;
462: WHERE RESPONSIBILITY_ID = X_RESPONSIBILITY_ID;
463:
464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN
466: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
467: FND_MESSAGE.SET_TOKEN( 'RECORD', 'role_responsibility_rec');
468: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_RESPONSIBILITY_ID ) );
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
463:
464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN
466: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
467: FND_MESSAGE.SET_TOKEN( 'RECORD', 'role_responsibility_rec');
468: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_RESPONSIBILITY_ID ) );
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471:
464: EXCEPTION
465: WHEN NO_DATA_FOUND THEN
466: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
467: FND_MESSAGE.SET_TOKEN( 'RECORD', 'role_responsibility_rec');
468: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_RESPONSIBILITY_ID ) );
469: FND_MSG_PUB.ADD;
470: RAISE FND_API.G_EXC_ERROR;
471:
472: END Select_Row;