DBA Data[Home] [Help]

PACKAGE: APPS.WIP_INTERFACE_ERR_UTILS

Source


1 package WIP_INTERFACE_ERR_Utils AUTHID CURRENT_USER as
2 /* $Header: wipieuts.pls 115.6 2002/12/12 14:47:01 rmahidha ship $ */
3 
4    -- declare a PL/SQL table to record errors
5    -- with three columns: Interface_id, error_type and error
6 
7   type request_error is record (
8     interface_id 	number,
9     error_type 		wip_interface_errors.error_type %type,
10     error      		wip_interface_errors.error      %type
11   ) ;
12 
13   type error_list is table of request_error index by binary_integer ;
14 
15   current_errors error_list ;
16 
17   any_current_request boolean ;
18 
19 
20   --  Common procedure for error handling
21 
22   Procedure add_error(p_interface_id 	number,
23 		      p_text		varchar2,
24 		      p_error_type	number);
25 
26   -- Add an error message into PL/SQL table current_errors.
27 
28   Procedure load_errors;
29 
30   -- Copy all errors from current_errors into WIP_INTERFACE_ERRORS.
31 
32 end WIP_INTERFACE_ERR_Utils;