There were a bunch of patchwork rules but not until Trent was it made "official".
The Council of Trent considered the matter and at its twenty-fourth session decreed that marriage after ordination was invalid: "If any one saith, that clerics constituted in sacred orders, or Regulars, who have solemnly professed chastity, are able to contract marriage, and that being contracted it is valid, notwithstanding the ecclesiastical law, or vow; and that the contrary is no thing else than to condemn marriage; and, that all who do not feel that they have the gift of chastity, even though they have made a vow thereof, may contract marriage; let him be anathema: seeing that God refuses not that gift to those who ask for it rightly, neither does He suffer us to be tempted above that which we are able" (canon 9).
It also decreed, concerning the relative dignity of marriage and celibacy: "If any one saith, that the marriage state is to be placed above the state of virginity, or of celibacy, and that it is not better and more blessed to remain in virginity, or in celibacy, than to be united in matrimony; let him be anathema."[73]
https://en.wikipedia.org/wiki/Clerical_celibacy#First_century
The celibacy requirement is just more made up rules of Roman Catholicism.
It should be noted there is nothing in the New Testament prohibiting God's man to be married if he wants to be.
On the contrary, those in leadership positions in the church, are expected and commanded to be married.
1 Timothy 3:1-13 The saying is trustworthy: If anyone aspires to the office of overseer, he desires a noble task. Therefore an overseer must be above reproach, the husband of one wife, sober-minded, self-controlled, respectable, hospitable, able to teach, not a drunkard, not violent but gentle, not quarrelsome, not a lover of money. He must manage his own household well, with all dignity keeping his children submissive, for if someone does not know how to manage his own household, how will he care for God's church? He must not be a recent convert, or he may become puffed up with conceit and fall into the condemnation of the devil. Moreover, he must be well thought of by outsiders, so that he may not fall into disgrace, into a snare of the devil.
Deacons likewise must be dignified, not double-tongued, not addicted to much wine, not greedy for dishonest gain. They must hold the mystery of the faith with a clear conscience. And let them also be tested first; then let them serve as deacons if they prove themselves blameless. Their wives likewise must be dignified, not slanderers, but sober-minded, faithful in all things. Let deacons each be the husband of one wife, managing their children and their own households well. For those who serve well as deacons gain a good standing for themselves and also great confidence in the faith that is in Christ Jesus.
Titus 1:5-9 This is why I left you in Crete, so that you might put what remained into order, and appoint elders in every town as I directed you— if anyone is above reproach, the husband of one wife, and his children are believers and not open to the charge of debauchery or insubordination. For an overseer, as God's steward, must be above reproach. He must not be arrogant or quick-tempered or a drunkard or violent or greedy for gain, but hospitable, a lover of good, self-controlled, upright, holy, and disciplined. He must hold firm to the trustworthy word as taught, so that he may be able to give instruction in sound doctrine and also to rebuke those who contradict it.
Scripture also addresses what is to be done when there is a person in the church sinning in immorality.
And there, the Catholic church has completely dropped the ball. They don't even follow the Bible that they claim they wrote.
1 Corinthians 5:1-13 It is actually reported that there is sexual immorality among you, and of a kind that is not tolerated even among pagans, for a man has his father's wife. And you are arrogant! Ought you not rather to mourn? Let him who has done this be removed from among you.
For though absent in body, I am present in spirit; and as if present, I have already pronounced judgment on the one who did such a thing. When you are assembled in the name of the Lord Jesus and my spirit is present, with the power of our Lord Jesus, you are to deliver this man to Satan for the destruction of the flesh, so that his spirit may be saved in the day of the Lord.
Your boasting is not good. Do you not know that a little leaven leavens the whole lump? Cleanse out the old leaven that you may be a new lump, as you really are unleavened. For Christ, our Passover lamb, has been sacrificed. Let us therefore celebrate the festival, not with the old leaven, the leaven of malice and evil, but with the unleavened bread of sincerity and truth.
I wrote to you in my letter not to associate with sexually immoral people—not at all meaning the sexually immoral of this world, or the greedy and swindlers, or idolaters, since then you would need to go out of the world. But now I am writing to you not to associate with anyone who bears the name of brother if he is guilty of sexual immorality or greed, or is an idolater, reviler, drunkard, or swindler—not even to eat with such a one. For what have I to do with judging outsiders? Is it not those inside the church whom you are to judge? God judges those outside. “Purge the evil person from among you.”