Remote Query failure Oracle to Non-Oracle

[dbasan]

Post the trigger

CREATE OR REPLACE TRIGGER ADM.LENINSERT
AFTER INSERT OR UPDATE
ON ADM.PS_LEN_TMP 
FOR EACH ROW
BEGIN
	   IF :new.badge_expirdt is not null 
	   and :new.badge_categry is not null 
	   and :new.badge_categry <> ' ' THEN

       	  INSERT INTO UDO_TEMP@tg4msql
	   		   (PERSONNEL_ID,
			   FIRST_NAME,
			   LAST_NAME,
			   MIDDLE_NAME,
			   RANK_TITLE_CODE,
			   PERSONNEL_CATG_CODE,
			   BADGE_EXPIRATION_DATE,
			   PERSONNEL_CLEARANCE,
			   CLEARANCE_SCI,
			   UNEMPLID)
		VALUES
			   (:new.badge_number,
			   :new.first_name,
			   :new.last_name,
			   :new.middle_name,
			   :new.rank_title,
			   :new.badge_categry,
			   :new.badge_expirdt,
			   :new.clearance,
			   :new.sci,
			   :new.emplid);   
		END IF;
END ;

when the condition is met the trigger will fire, other wise the local update should happen which is failing.