By exchanging the insert parameters and the condition parameter for Bind variables like this:
INSERT INTO GROUPS (GROUP_ID, GROUP_NAME,DEPT_ID)
VALUES(:GROUP_ID,:GROUP_NAME,SELECT DEPARTMENT_ID FROM PERSONNEL_TEMP.DEPARTMENT WHERE DEPARTMENT_NAME = :DEPARTMENT_NAME)