TRIGGER: APPS.FND_FLEX_VALIDATION_RULES_T1

Source

Description

"APPS"."FND_FLEX_VALIDATION_RULES_T1" 
  AFTER INSERT
 ON  "APPLSYS"."FND_FLEX_VALIDATION_RULES#"  FOR EACH ROW
  

Type

AFTER EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
    if(FND_FLEX_TRIGGER.update_cvr_stats(:new.application_id,
		:new.id_flex_code, :new.id_flex_num, 1, 0, 0) = FALSE) then
      FND_MESSAGE.RAISE_ERROR;
    end if;
  EXCEPTION
    when OTHERS then
      IF (SQLCODE = -20001) THEN
         FND_MESSAGE.RAISE_ERROR;
      ELSE
	 FND_MESSAGE.set_name('FND', 'FLEX-SSV EXCEPTION');
	 FND_MESSAGE.set_token('MSG', 'fnd_flex_validation_rules_t1() exception: '
			       || SQLERRM);
	 FND_MESSAGE.RAISE_ERROR;
      END IF;
  END;