(Код ошибки)
( Класс ошибки : EDatabaseError )
ORA-02291: integrity constraint (DBO.YFKMONEYDRIVE_IPARENTID) violated - parent key not found
ORA-06512: at line 2


4.1.0.441
begin
insert into MoneyDrive ( IMONEYSTATEID
, DTPLAT
, VCNUMPP
, IPARENTID
, IDRIVENUM
, DTREALENTER
, DTENTER
, IMONEYDRIVETYPEID
, IDOCUMENTID_TRG
, IDOCUMENTID_SRC
, ISTAFFID_ENTER
, IMONEYDRIVEID
, DECNDS
, DECSUM_TRG
, ICURRENCYID_TRG
, ICURRENCYID_SRC
, DECSUM_SRC
, DTGRUZ
, VCNUMGP
, VCNaznachenie ,DTPLANDAY,iDaysToPay
)values
(:IMONEYSTATEID
,:DTPLAT
,:VCNUMPP
,:IPARENTID
,:IDRIVENUM
,SYSDATE
,nvl(:dtEnter,sysdate)
,:IMONEYDRIVETYPEID
,:IDOCUMENTID_TRG
,:IDOCUMENTID_SRC,
GetUserID
,:IMONEYDRIVEID
,:DECNDS
,:DECSUM_TRG
,:ICURRENCYID_TRG
,:ICURRENCYID_SRC
,:DECSUM_SRC
,:DTGRUZ
,:VCNUMGP
,:VCNaznachenie,:dtplanday,:idaystopay);

CheckMoneysum(:iDocumentID_Src,'insmd_document_src' );
CheckMoneysum(:iDocumentID_Trg,'insmd_document_trg' );

begin
IF :IMONEYSTATEID = 2 THEN
select COUNT(*) INTO :CNT from moneydrive e
where e.imoneydrivetypeid = :imoneydrivetypeid
AND(e.idocumentid_src = :iDocumentID_Owner or e.idocumentid_trg = :iDocumentID_Owner)
and e.imoneystateid = 2;
IF (:CNT = 1) THEN
SELECT :DTENTER - MIN(E.DTENTER) INTO :DELTA FROM moneydrive e
where (e.idocumentid_src = :iDocumentID_Owner or e.idocumentid_trg = :iDocumentID_Owner)
and imoneydrivetypeid = :imoneydrivetypeid
and imoneystateid <> 2 ;

update moneydrive e set dtenter = dtenter+:DELTA
where (e.idocumentid_src = :iDocumentID_Owner or e.idocumentid_trg = :iDocumentID_Owner)
and imoneydrivetypeid = :imoneydrivetypeid
and imoneystateid <> 2;
END IF;
END IF;
END;


end;

----- Ïàðàìåòðû -----
:IMONEYSTATEID = 2
:DTPLAT =
:VCNUMPP =
:IPARENTID = 1
:IDRIVENUM =
:DTENTER = 07.08.2013 16:38:54
:IMONEYDRIVETYPEID = 22
:IDOCUMENTID_TRG = 9885
:IDOCUMENTID_SRC = 9871
:IMONEYDRIVEID = 131
:DECNDS =
:DECSUM_TRG = 406,96
:ICURRENCYID_TRG = 1
:ICURRENCYID_SRC = 1
:DECSUM_SRC = 406,96
:DTGRUZ =
:VCNUMGP =
:VCNAZNACHENIE =
:DTPLANDAY =
:IDAYSTOPAY =
:IDOCUMENTID_OWNER = 9871
:CNT =
:DELTA =
---------------------