[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;