TRIGGER: APPS.IGI_EXP_AR_COMP_T1

Source

Description

igi_exp_ar_comp_t1
BEFORE INSERT OR UPDATE
 OF complete_flag
ON igi_ra_customer_trx_all
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
    IF igi_gen.is_req_installed('EXP') THEN
      IF nvl(:new.dial_unit_id,0) = -999
      THEN
	 :new.DIAL_UNIT_ID := :old.DIAL_UNIT_ID;
      ELSE
         IF (igi_gen.is_req_installed('EXP')
	 AND
	   :new.complete_flag = 'Y'
	 AND
	   :new.created_from <> 'RAXTRX')
         THEN
            fnd_message.set_name('IGI', 'IGI_EXP_AR_COMP');
            RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
         END IF;
      END IF;
    END IF ;
END;