509: OPEN C;
510: FETCH C INTO Recinfo;
511: IF ( C%NOTFOUND ) THEN
512: CLOSE C;
513: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
514: APP_EXCEPTION.RAISE_EXCEPTION;
515: END IF;
516: CLOSE C;
517:
722: AND ( X_APPLICATION_ID IS NULL ) ) )
723: ) THEN
724: RETURN;
725: ELSE
726: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
727: APP_EXCEPTION.RAISE_EXCEPTION;
728: END IF;
729:
730: END Lock_Row;
920: WHERE CUST_ACCT_SITE_ID = X_CUST_ACCT_SITE_ID;
921:
922: EXCEPTION
923: WHEN NO_DATA_FOUND THEN
924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
925: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_site_rec');
926: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCT_SITE_ID ) );
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_ERROR;
921:
922: EXCEPTION
923: WHEN NO_DATA_FOUND THEN
924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
925: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_site_rec');
926: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCT_SITE_ID ) );
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_ERROR;
929:
922: EXCEPTION
923: WHEN NO_DATA_FOUND THEN
924: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
925: FND_MESSAGE.SET_TOKEN( 'RECORD', 'cust_acct_site_rec');
926: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCT_SITE_ID ) );
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_ERROR;
929:
930: END Select_Row;