805: OPEN C;
806: FETCH C INTO Recinfo;
807: IF ( C%NOTFOUND ) THEN
808: CLOSE C;
809: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
810: APP_EXCEPTION.RAISE_EXCEPTION;
811: END IF;
812: CLOSE C;
813:
1165: AND ( X_CHARGE_BEGIN_DATE IS NULL ) ) )
1166: ) THEN
1167: RETURN;
1168: ELSE
1169: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1170: APP_EXCEPTION.RAISE_EXCEPTION;
1171: END IF;
1172:
1173: END Lock_Row;
1504: WHERE CUST_ACCOUNT_PROFILE_ID = X_CUST_ACCOUNT_PROFILE_ID;
1505:
1506: EXCEPTION
1507: WHEN NO_DATA_FOUND THEN
1508: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1509: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer_profile_rec');
1510: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCOUNT_PROFILE_ID ) );
1511: FND_MSG_PUB.ADD;
1512: RAISE FND_API.G_EXC_ERROR;
1505:
1506: EXCEPTION
1507: WHEN NO_DATA_FOUND THEN
1508: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1509: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer_profile_rec');
1510: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCOUNT_PROFILE_ID ) );
1511: FND_MSG_PUB.ADD;
1512: RAISE FND_API.G_EXC_ERROR;
1513:
1506: EXCEPTION
1507: WHEN NO_DATA_FOUND THEN
1508: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1509: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer_profile_rec');
1510: FND_MESSAGE.SET_TOKEN( 'VALUE', TO_CHAR( X_CUST_ACCOUNT_PROFILE_ID ) );
1511: FND_MSG_PUB.ADD;
1512: RAISE FND_API.G_EXC_ERROR;
1513:
1514: END Select_Row;