------------------------------------------------
-- Package: JR_ERROR
-- Author : Will Stallard
-- Date   : 21st Sept 1999
-- 
-- This package contains methods used by the
-- repository packages for posting specific
-- errors to the RMMES error stack. The package
-- handes getting hold of parameters such as 
-- element paths and nls names for element types
------------------------------------------------


prompt Package Header: jr_error 

create or replace package jr_error is

 ----------------------------------------------
 -- jr_error.POST_REF_ERROR()
 --
 -- Posts errors raised by referential integrity
 -- violations - either a blocking FK reference,
 -- or attempt to update a PK which has FK 
 -- references.
 -- Errors: CDR-2001 and CDR-1051
 -----------------------------------------------
 procedure post_ref_error(parent_ivid in number
                         ,parent_type in number
                         ,child_irid  in number
                         ,child_type  in number
                         ,action      in varchar2);

 ----------------------------------------------
 -- jr_error.POST_REFERENCING_ERROR()
 --
 -- Posts errors raised by referential integrity
 -- violations - when a FK reference is invalid
 -- Errors: CDR-1052
 -----------------------------------------------
 procedure post_referencing_error ( object_ivid in number
                                  , object_type in number
                                  , fkref       in number
                                  , ref_type    in number
                                  , action      in varchar2
                                  );

 ----------------------------------------------
 -- jr_error.POST_UPD_CHECKIN_ERROR()
 --
 -- Posts error raised by attempt to update a
 -- checked in object.
 -- Error: CDR-2622 
 -----------------------------------------------
 procedure post_upd_checkin_error(ivid in number);
 
 ----------------------------------------------
 -- jr_error.POST_DEL_ERROR()
 --
 -- Posts error raised by failure to delete/purge
 -- an element
 -- Error: CDR-2000 
 -----------------------------------------------
 procedure post_del_error(ivid in number
                         ,el_type in number);

 ----------------------------------------------
 -- jr_error.POST_DEL_ERROR()
 --
 -- Posts error raised by attempt to delete 
 -- a secondary element where the primary 
 -- element is checked in
 -- Error: CDR-2020
 -----------------------------------------------
 procedure post_del_ci_sac_error(sac_ivid    in number
                                ,sac_type_id in number
								,pac_ivid    in number);
                         
end jr_error;
/