TRIGGER: APPS.JTF_TERR_USGS_BIUD

Source

Description

"APPS"."JTF_TERR_USGS_BIUD" 
		BEFORE INSERT  OR DELETE  OR UPDATE
	
 ON  "JTF"."JTF_TERR_USGS_ALL#"  		REFERENCING NEW AS NEW OLD AS OLD
		FOR EACH ROW
		

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE OR DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
		  terr_id      NUMBER;
		  Trigger_Mode varchar2(20);
		  source_id    NUMBER;

		  --Following variables are used to replace inputs to FND_MSG_PUB.Add_Exc_Msg
		  lo_tr_name varchar2(25):='JTF_TERR_USGS_BIUD';
		  lo_message varchar2(50):='Others exception inside TERR trigger:  ';

		BEGIN
		IF INSERTING THEN
			Trigger_Mode := 'ON-INSERT';
			terr_id      := :new.terr_id;
			source_id    := :new.source_id;
		ELSIF UPDATING THEN
			Trigger_Mode := 'ON-UPDATE';
			terr_id      := :new.terr_id;
			source_id    := :new.source_id;
		ELSIF DELETING THEN
			Trigger_Mode := 'ON-DELETE';
			terr_id      := :old.terr_id;
			source_id    := :old.source_id;
		END IF;

		JTY_TERR_TRIGGER_HANDLERS.Terr_Usgs_Trigger_Handler(
		  terr_id
		 ,source_id
		 ,Trigger_Mode);

		EXCEPTION
		when others then
		FND_MSG_PUB.Add_Exc_Msg(lo_tr_name, lo_message || sqlerrm);
		END JTF_TERR_USGS_BIUD;