According to Catholics at what moment did the ransom sacrifice go into effect? At his crucifixion our Lord cried out "My God Why have thou forsaken me?"

A bit later he cries out again and in about that moment he died and there was darkness and earthquake and the temple curtain split in half.

Did the ransom go into effect at that moment or was it upon the shedding of blood when the soldier pierced his side? (Hebrews 9:22) "no forgiveness takes place without the shedding of blood"

Or was when Jesus returned to heaven "to appear for us in Gods presence"?   (Hebrews 9:24)

Or do Catholics have a time frame different than these for when the ransom went into effect?
Catholicism does not necessarily believe that there was a single moment at which Christ redeemed us:

Christ’s whole life is a mystery of redemption. Redemption comes to us above all through the blood of his cross [cf. Eph 1:7; Col 1:13–14; 1 Pet 1:18–19], but this mystery is at work throughout Christ’s entire life:

already in his Incarnation through which by becoming poor he enriches us with his poverty [cf. 2 Cor 8:9];

in his hidden life which by his submission atones for our disobedience [cf. Luke 2:51];

in his word which purifies its hearers [cf. John 15:3];

in his healings and exorcisms by which &quot;he took our infirmities and bore our diseases&quot; [cf. Mt 8:17; Isa 53:4];

and in his Resurrection by which he justifies us [cf. Rom. 4:25].



(Catechism of the Catholic Church, paragraph 517; all Scripture references taken from footnotes to the passage)
However, the particular aspect of Christ's redemption of us which has to do with our ransom appears to have been fulfilled, that is completed, at the moment of his death:

The redemption won by Christ consists in this, that he came &quot;to give his life as a ransom for many&quot; (Mt 20:28), that is, he &quot;loved [his own] to the end&quot; (Jn 13:1), so that they might be &quot;ransomed from the futile ways inherited from [their] fathers&quot; (1 Pet 1:18).
By his loving obedience to the Father, &quot;unto death, even death on a cross&quot; (Phil 2:8), Jesus fulfills the atoning mission (cf. Isa 53:10) of the suffering Servant, who will &quot;make many righteous; and he shall bear their iniquities&quot; (Isa 53:11; cf. Rom 5:19).

(Catechism, paragraphs 622–623)
Along similar lines, Aquinas' Catena Aurea quotes Origen on the passage:

His ministry extended so far, that He fulfilled even in what follows, And to give his life a ransom for many, they, that is, who believed on Him; and gave it, i.e. to death. But since He was alone free among the dead, and mightier than the power of death, He has set free from death all who were willing to follow Him.

(emphasis added)
Thus it appears that our redemption, considered as a whole, is caught up with the whole of Christ's life and death; but his death is primary in ransoming us; so that it is at the moment of his death that the ransom was fulfilled.