02055, 00000, "distributed update operation failed; rollback required"
// *Cause: a failure during distributed update operation may not have
//      rolled back all effects of the operation.  Since
//  	some sites may be inconsistent, the transaction must roll back to
//	a savepoint or entirely
// *Action: rollback to a savepoint or rollback transaction and resubmit
bcm@bcm-laptop:~$ oerr ora 2067
02067, 00000, "transaction or savepoint rollback required"
// *Cause: A failure (typically a trigger or stored procedure with multiple
//	   remote updates) occurred such that the all-or-nothing execution
//	   of a previous Oracle call cannot be guaranteed.
// *Action: rollback to a previous savepoint or rollback the transaction
//	    and resubmit.

CREATE OR REPLACE Procedure NML.prl_pro_upd(empcod in number,bascod in number) IS
Begin
    dbms_output.put_line('starting');
        INSERT INTO pay.COMPANY@att_bhk.com (EMP_COD,
                                     FIRST_NAME,
                                     MIDDLE_NAME,
                                     LAST_NAME,
                                     FULL_NAME,
                                     CALL_ME_AS,
                                     BRANCH_ID,
                                     DIVISION_ID,
                                     DEPARTMENT_ID,
                                     SECTION_ID,
                                     CONFIRMATION_DATE,
                                     HIRE_DATE,
                                     SHIFT_GROUP_ID,
                                     OVERTIME_ALLOWED,
                                     C_P_I_ALLOWED,
                                     OVT_HRS_PER_DAY,
                                     POSITION_ID,
                                     CATEGORY_ID,
                                     EMPLOYEE_TYPE_ID,
                                     EMPLOYEE_GROUP,
                                     RANK_ID,
                                     STATUS,
                                     DATE_OF_ARRIVAL,
                                     WEEKLY_OF_DAY,
                                     SALARY,
                                     upd_flg)
   SELECT   h34.emp_cod,
            NVL (h0.FST_NOM, h34.NOM_FST) FST_NOM,
            NULL MIDDLE_NAME,
            NVL (h0.LST_NOM, h34.NOM_LST) LAST_NAME,
               NVL (h0.FST_NOM, h34.NOM_FST)
            || ' '
            || NVL (h0.LST_NOM, h34.NOM_LST)
               FULL_NAM,
            NVL (h0.FST_NOM, h34.NOM_FST) call_me_as,
            NVL (c8iii.bas_cod, 500) - 500 branch_id,
            '1' division_id,
            p10.dpt_cod sec_cod,
            c8i.bas_cod dpt_cod,
            P10.CON_DTE,
            p10.jon_dte,
            1,
            DECODE (p10.ovt_flg, 'Y', 0, -1) ovt,
            -1 cpl,
            NULL ovt_hrs,
            0 pod_id,
            0 cat_id,
            32 emp_typ,
            NULL grp,
            0 rank_id,
            DECODE (h34.dut_flg, 0, 'Active', 1, 'Active', 'InActive') sta,
            NVL (h0.LTR_DTE, p10.jon_dte) arv_dte,
            h34.res_day,
            NVL (H0.DMD_SAL, grs.gross2) grs,
            1 flg
     FROM   pay.hrm_00_00 h0,
            pay.hrm_01_34 h34,
            pay.prl_10_01 p10,
            nml.emp_grs grs,
            nml.crp_00_08 c8,
            nml.crp_00_08 c8i,
            nml.crp_00_08 c8ii,
            nml.crp_00_08 c8iii
    WHERE       h0.emp_cod(+) = H34.emp_cod
            AND grs.emp_cod(+) = H34.emp_cod
            AND P10.DPT_COD = c8.bas_cod
            AND c8.bas_typ = 14
            AND c8i.bas_cod = c8.pnt_cod
            AND c8i.bas_typ = 13
            AND c8ii.bas_cod = c8i.pnt_cod
            AND c8ii.bas_typ = 12
            AND c8iii.bas_cod = c8ii.pnt_cod
            AND c8iii.bas_typ = 11
            AND p10.emp_cod = H34.emp_cod
            AND h34.prs_bas = bascod
            AND h34.emp_cod = empcod
            AND h34.dut_flg IN (0, 1);        dbms_output.put_line('step 4');
    End;

SQL> 
SQL>  EXECUTE NML.PRL_PRO_UPD(2800101906,302);
step 1
step 2
step 3
starting
step 4
step 2
PL/SQL procedure successfully completed.
SQL> /

SQL>  EXECUTE NML.PRL_PRO_UPD(2800101906,302);
BEGIN NML.PRL_PRO_UPD(2800101906,302); END;

*
ERROR at line 1:
ORA-02068: following severe error from ATT_BHK
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-02063: preceding line from NML.COM
ORA-06512: at "NML.PRL_PRO_UPD", line 61
ORA-06512: at line 1