165: AND EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE
166: AND EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE ;
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
170: FND_MESSAGE.SET_TOKEN( 'RECORD', 'hierarchy node');
171: FND_MESSAGE.SET_TOKEN( 'VALUE', X_HIERARCHY_TYPE );
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
166: AND EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE ;
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
170: FND_MESSAGE.SET_TOKEN( 'RECORD', 'hierarchy node');
171: FND_MESSAGE.SET_TOKEN( 'VALUE', X_HIERARCHY_TYPE );
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
174:
167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
170: FND_MESSAGE.SET_TOKEN( 'RECORD', 'hierarchy node');
171: FND_MESSAGE.SET_TOKEN( 'VALUE', X_HIERARCHY_TYPE );
172: FND_MSG_PUB.ADD;
173: RAISE FND_API.G_EXC_ERROR;
174:
175: END Select_Row;