INSERT INTO po_distributions_interface
	(
	interface_header_id,
	interface_line_id,
	interface_distribution_id,
	quantity_ordered,
	charge_account_id,
	last_update_date,
	last_updated_by,
	creation_date,
	created_by,
	org_id
	)
______________________________________________________________________________________________________________


CREATE OR REPLACE PACKAGE Iappz_common_pkg

        IS

 PROCEDURE insert_conv_error(
	      rec_id_p        IN   NUMBER
	      ,error_msg_p      IN   VARCHAR2
	      ,error_type_p      IN   VARCHAR2
	      ,error_source_p  IN   VARCHAR2
	      ,attribute1_p    IN   VARCHAR2
	      ,attribute2_p    IN   VARCHAR2
	      ,attribute3_p    IN   VARCHAR2
    		);

end Iappz_common_pkg;

__________________________________________________________________________________________________________



CREATE OR REPLACE PACKAGE BODY Iappz_common_pkg

                   IS

PROCEDURE insert_conv_error (
	      rec_id_p        IN   NUMBER
	      ,error_msg_p      IN   VARCHAR2
	      ,error_type_p      IN   VARCHAR2
	      ,error_source_p  IN   VARCHAR2
	      ,attribute1_p    IN   VARCHAR2
	      ,attribute2_p    IN   VARCHAR2
	      ,attribute3_p    IN   VARCHAR2
    		)

	IS
	   PRAGMA AUTONOMOUS_TRANSACTION;
	BEGIN

	        INSERT INTO Iappz_conv_error (
	              rec_id
	  	     ,error_msg
	             ,error_type
	             ,error_source
	             ,attribute1
	             ,attribute2
	             ,attribute3 )

	         VALUES (rec_id_p
	  		 ,error_msg_p
	                 ,error_type_p
	  	         ,error_source_p
	                 ,attribute1_p
	  		 ,attribute2_p
	                 ,attribute3_p
	                  );
	     COMMIT;
	 EXCEPTION
	 WHEN OTHERS
	 THEN
	 	           
            FND_FILE.PUT_LINE(FND_FILE.LOG,'Error While Updating common conversion error table' || '--' || SUBSTR(SQLERRM,1,150));


	 END insert_conv_error;
END Iappz_common_pkg;
/