SQL> ho cat data/sql/test_trigger_lines.trg
CREATE OR REPLACE TRIGGER CAN_CHIAVE
AFTER UPDATE OF D_FINE_VALIDITA ON CHIAVI FOR EACH ROW

BEGIN
THIS_IS_LINE_2;  -- Check the error listing when this code fails

IF DBMS_REPUTIL.FROM_REMOTE = FALSE THEN

UPDATE SET_CHIAVI
SET Q_CHIAVI_DISPONIBILI = Q_CHIAVI_DISPONIBILI - 1
WHERE K_ID_SET = :new.E_ID_SET
AND Q_CHIAVI_DISPONIBILI > 0;

END IF;

END;
/

SQL> @data/sql/test_trigger_lines.trg

Warning: Trigger created with compilation errors.

SQL> show errors
Errors for TRIGGER CAN_CHIAVE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1      PLS-00201: identifier 'THIS_IS_LINE_2' must be declared
2/1      PL/SQL: Statement ignored
SQL> 

scott@ORA92> create table chiavi
  2    (d_fine_validita number,
  3  	e_id_set	number)
  4  /

Table created.

scott@ORA92> create table set_chiavi
  2    (Q_CHIAVI_DISPONIBILI number,
  3  	k_id_set	     number)
  4  /

Table created.

scott@ORA92> CREATE OR REPLACE TRIGGER CAN_CHIAVE
  2    AFTER UPDATE OF D_FINE_VALIDITA ON CHIAVI
  3    FOR EACH ROW
  4  
  5  BEGIN
  6  
  7    IF DBMS_REPUTIL.FROM_REMOTE = FALSE THEN
  8  
  9  	 UPDATE SET_CHIAVI
 10  	 SET	Q_CHIAVI_DISPONIBILI = Q_CHIAVI_DISPONIBILI - 1
 11  	 WHERE	K_ID_SET = :new.E_ID_SET
 12  	 AND	Q_CHIAVI_DISPONIBILI > 0;
 13  
 14    END IF;
 15  
 16  END;
 17  /

Trigger created.

scott@ORA92> SHOW ERRORS
No errors.
scott@ORA92> alter trigger CAN_CHIAVE compile
  2  /

Trigger altered.

scott@ORA92> show errors
No errors.
scott@ORA92> column text format a45 word_wrapped
scott@ORA92> select line, text
  2  from   user_source
  3  where  name = 'CAN_CHIAVE'
  4  order  by line
  5  /

      LINE TEXT
---------- ---------------------------------------------
         1 TRIGGER CAN_CHIAVE
         2 AFTER UPDATE OF D_FINE_VALIDITA ON CHIAVI
         3 FOR EACH ROW
         4
         5 BEGIN
         6
         7 IF DBMS_REPUTIL.FROM_REMOTE = FALSE THEN
         8
         9 UPDATE SET_CHIAVI
        10 SET    Q_CHIAVI_DISPONIBILI =
           Q_CHIAVI_DISPONIBILI - 1

        11 WHERE  K_ID_SET = :new.E_ID_SET
        12 AND    Q_CHIAVI_DISPONIBILI > 0;
        13
        14 END IF;
        15
        16 END;

16 rows selected.

scott@ORA92> CREATE OR REPLACE TRIGGER CAN_CHIAVE
  2    AFTER UPDATE OF D_FINE_VALIDITA ON CHIAVI
  3    FOR EACH ROW
  4  
  5  BEGIN
  6  
  7    IF DBMS_REPUTIL.FROM_REMOTE = FALSE THEN
  8  
  9  	 UPDATE SET_CHIAVI
 10  	 SET	Q_CHIAVI_DISPONIBILI = Q_CHIAVI_DISPONIBILI - 1
 11  	 WHERE	K_ID_SET = :new.E_ID_SET
 12  	 AND	Q_CHIAVI_DISPONIBILI > 0;
 13  
 14    line14; END IF;
 15  
 16  END;
 17  /

Warning: Trigger created with compilation errors.

scott@ORA92> SHOW ERRORS
Errors for TRIGGER CAN_CHIAVE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
10/3     PLS-00201: identifier 'LINE14' must be declared
10/3     PL/SQL: Statement ignored
scott@ORA92> CREATE OR REPLACE TRIGGER CAN_CHIAVE
  2    AFTER UPDATE OF D_FINE_VALIDITA ON CHIAVI
  3    FOR EACH ROW
  4  BEGIN
  5    IF DBMS_REPUTIL.FROM_REMOTE = FALSE THEN
  6  	 UPDATE SET_CHIAVI
  7  	 SET	Q_CHIAVI_DISPONIBILI = Q_CHIAVI_DISPONIBILI - 1
  8  	 WHERE	K_ID_SET = :new.E_ID_SET
  9  	 AND	Q_CHIAVI_DISPONIBILI > 0;
 10    line10; END IF;
 11  END;
 12  /

Warning: Trigger created with compilation errors.

scott@ORA92> SHOW ERRORS
Errors for TRIGGER CAN_CHIAVE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7/3      PLS-00201: identifier 'LINE10' must be declared
7/3      PL/SQL: Statement ignored

CREATE OR REPLACE TRIGGER CAN_CHIAVE
AFTER UPDATE OF D_FINE_VALIDITA ON CHIAVI FOR EACH ROW
BEGIN
    IF DBMS_REPUTIL.FROM_REMOTE = FALSE THEN

        UPDATE SET_CHIAVI
        SET Q_CHIAVI_DISPONIBILI = Q_CHIAVI_DISPONIBILI - 1
        WHERE K_ID_SET = :new.E_ID_SET
        AND Q_CHIAVI_DISPONIBILI > 0;

    END IF;

END;

CREATE OR REPLACE TRIGGER some_other_trigger
AFTER UPDATE OF D_FINE_VALIDITA ON CHIAVI FOR EACH ROW
etc blah blah
/

SQL> @test_trigger.trg

Warning: Trigger created with compilation errors.

SQL> show errors
Errors for TRIGGER CAN_CHIAVE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
13/1     PLS-00103: Encountered the symbol "CREATE"
SQL> 
SQL> ALTER TRIGGER CAN_CHIAVE COMPILE;

Warning: Trigger altered with compilation errors.

SQL> show errors
Errors for TRIGGER CAN_CHIAVE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
13/1     PLS-00103: Encountered the symbol "CREATE"
SQL>

CREATE OR REPLACE PROCEDURE recreate_seqs
IS
rows NUMBER;
start_num NUMBER;
BEGIN
start_num := 1661168;

SELECT COUNT(rowid) INTO rows FROM ADDL_CHG_GROUPS;
rows := rows + start_num + 1;
execute immediate 'CREATE SEQUENCE ADDL_CHG_GROUP_SQ START WITH '||rows||';';
END;
/

show errors