TRIGGER: APPS.FND_FLEX_VALIDATION_RULES_T3

Source

Description

fnd_flex_validation_rules_t3
  AFTER DELETE ON fnd_flex_validation_rules FOR EACH ROW
  

Type

AFTER EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
    if(FND_FLEX_TRIGGER.update_cvr_stats(:old.application_id,
		:old.id_flex_code, :old.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_t3() exception: '
			       || SQLERRM);
	 FND_MESSAGE.RAISE_ERROR;
      END IF;
  END;