if....then
begin
update......
commit;
insert into table(......)

insert into table_2(....)

exception when others then
......
end;

IF vReturnValue = 'SUCCESS' THEN
                           BEGIN
                                UPDATE p_contract_mf_auto_debit
                                SET last_pymt_date = sysdate,
                                    payments_processed = NVL(payments_processed,0) + 1
                                WHERE contr_num IN (SELECT cad.contr_num
                                                    FROM p_contract_mf_auto_debit cad, p_contract_lead cl, p_contract_purchase cp, ar_club_group gc, p_member_contract mc
                                                    WHERE cad.contr_num = cp.contr_num
                                                    AND cp.contr_num = cl.contr_num
                                                    AND cl.lead_id = x.lead_id
                                                    AND cp.club_mbr_type = gc.mbr_type
                                                    AND opt_in = 'Y'
                                                    AND mc.parent_mbr_contr_id = x.parent_mbr_contr_id
                                                    AND mc.mbr_contr_id = cp.mbr_contr_id
                                                   -- AND
                                                    AND gc.club_group_code = x.club_group_code);
                                COMMIT;
                                
                      
                                
                                --26432 + insert into s_remark comments
                                 INSERT INTO S_REMARK (rem_id,
                                                      remtype_id,
                                                      remarea_id,
                                                      lead_id,
                                                      mbr_contr_id,
                                                      personnel_id,
                                                      date_time_created,
                                                      rem_desc)
                                              VALUES (pnRemarkID,
                                                      1,
                                                      1,
                                                      x.lead_id,
                                                      x.parent_mbr_contr_id,
                                                      vPersonnelID,
                                                      SYSDATE,
                                                      'MF Surepay auto-debit:'||x.payment_amt||', '||x.club_group_code);
                                                      
                            EXCEPTION WHEN OTHERS THEN
                                vComment     := 'ATLAS Check Settle Table Error: '||SQLERRM||' '||vComment;
                                vMessage     := 'ATLAS Check Settle Table Error: '||SQLERRM||' '||vMessage ;
                                vReturnValue := 'ATLAS CheckSettle Error';
                            END;