Oracle Forms

Dear Friends
I am getting this message
FRM-40735 POST-INSERT TRIGGER RAISED UNHANDLED EXCEPTION ORA-02291

And my script in POST-INSERT TRIGGER as the following :

BEGIN
-- CHECKING THE TABLE CHEMICAL_CONS_DETAILS FOR KRAFT PAPER 135 CM

SELECT 1 INTO :GLOBAL.DUMMY FROM CHEMICAL_CONS_DETAILS
WHERE DC_JOB_NO = :FD_JOB_NO
AND DC_DATE = :FD_DOC_DATE
AND DC_YEAR = :FD_YEAR
AND DC_BLOCK_TYPE = :FD_BLOCK_TYPE
AND DC_COLOR_TYPE = :FD__COLOR_TYPE
AND DC_RAW_CODE = :FD_RAW_CODE_KR135;
EXCEPTION
WHEN NO_DATA_FOUND THEN
-- INSEERT INTO CHEMICAL_CONS_DETAILS TABLE
INSERT INTO CHEMICAL_CONS_DETAILS
(DC_DATE,
DC_JOB_NO,
DC_BLOCK_TYPE,
DC_COLOR_TYPE,
DC_OUT,
DC_RAW_CODE,
DC_YEAR)
SELECT FD_DOC_DATE,FD_JOB_NO,FD_BLOCK_TYPE,FD__COLOR_TYPE,FD_KR135
,FD_RAW_CODE_KR135,FD_YEAR
FROM FINISHED_FOAM_DETAILS
WHERE FD_JOB_NO = :FD_JOB_NO
AND FD_DOC_DATE = :FD_DOC_DATE
AND FD_YEAR = :FD_YEAR
AND FD_BLOCK_TYPE = :FD_BLOCK_TYPE
AND FD__COLOR_TYPE = :FD__COLOR_TYPE
AND FD_ITEM_CODE = :FD_ITEM_CODE
AND FD_RAW_CODE_KR135 = :FD_RAW_CODE_KR135;

WHEN OTHERS THEN
SHOW_MESSAGE(SQLERRM);
raise form_trigger_failure;
END;

BEGIN
-- CHECKING THE TABLE CHEMICAL_CONS_DETAILS FOR KRAFT PAPER 210 CM

SELECT 1 INTO :GLOBAL.DUMMY FROM CHEMICAL_CONS_DETAILS
WHERE DC_JOB_NO = :FD_JOB_NO
AND DC_DATE = :FD_DOC_DATE
AND DC_YEAR = :FD_YEAR
AND DC_BLOCK_TYPE = :FD_BLOCK_TYPE
AND DC_COLOR_TYPE = :FD__COLOR_TYPE
AND DC_RAW_CODE = :FD_RAW_CODE_KR210;


EXCEPTION
WHEN NO_DATA_FOUND THEN
-- INSEERT INTO CHEMICAL_CONS_DETAILS TABLE
INSERT INTO CHEMICAL_CONS_DETAILS
(DC_DATE,DC_JOB_NO,DC_BLOCK_TYPE,DC_COLOR_TYPE,
DC_OUT,DC_RAW_CODE,DC_YEAR)
SELECT FD_DOC_DATE,FD_JOB_NO,FD_BLOCK_TYPE,FD__COLOR_TYPE,FD_KR210
,FD_RAW_CODE_KR210,FD_YEAR
FROM FINISHED_FOAM_DETAILS
WHERE FD_JOB_NO = :FD_JOB_NO
AND FD_DOC_DATE = :FD_DOC_DATE
AND FD_YEAR = :FD_YEAR
AND FD_BLOCK_TYPE = :FD_BLOCK_TYPE
AND FD__COLOR_TYPE = :FD__COLOR_TYPE
AND FD_ITEM_CODE = :FD_ITEM_CODE
AND FD_RAW_CODE_KR210 = :FD_RAW_CODE_KR210;

WHEN OTHERS THEN
SHOW_MESSAGE(SQLERRM);
raise form_trigger_failure;
END;

waiting for your valuable answer

Best regards
Jamil