5257: EXCEPTION
5258: WHEN OTHERS THEN
5259: ROLLBACK to identify_candidates;
5260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5261: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
5262: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
5263: FND_MSG_PUB.ADD;
5264: FND_MSG_PUB.Count_And_Get(
5265: p_encoded => FND_API.G_FALSE,
5258: WHEN OTHERS THEN
5259: ROLLBACK to identify_candidates;
5260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5261: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
5262: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
5263: FND_MSG_PUB.ADD;
5264: FND_MSG_PUB.Count_And_Get(
5265: p_encoded => FND_API.G_FALSE,
5266: p_count => x_msg_count,