PACKAGE: APPS.EAM_INT_UTILS

Source

1 PACKAGE eam_int_utils AUTHID CURRENT_USER AS
2 /* $Header: EAMINTUS.pls 115.3 2002/02/20 19:53:08 pkm ship   $ */
3 
4   --
5   -- Constants
6   --
7 
8   EAM_INT_EXCEPTION constant number := -20240 ;
9 
10   REQUEST_ABORTED exception ;
11   pragma exception_init(REQUEST_ABORTED, -20240) ;
12 
13 
14   -- declare a PL/SQL table to record errors
15   -- with three columns: Interface_id, error_type and error
16 
17   type request_error is record (
18     interface_id        number,
19     error_type          wip_interface_errors.error_type %type,
20     error               wip_interface_errors.error      %type
21   ) ;
22 
23   type error_list is table of request_error index by binary_integer ;
24 
25   current_errors error_list ;
26 
27   any_current_request boolean ;
28 
29   --  Common procedure for error handling
30 
31   -- Add an error message into PL/SQL table current_errors.
32   procedure add_error(p_interface_id    number,
33                       p_text            varchar2,
34                       p_error_type      number);
35 
36   -- Copy all errors from current_errors into WIP_INTERFACE_ERRORS
37   procedure load_errors(p_source_interface_table in varchar2);
38 
39   function has_errors return boolean;
40 
41   procedure abort_request;
42 
43   procedure warn_irrelevant_column(p_current_rowid in rowid,
44                                    p_current_interface_id in number,
45                                    p_table_name in varchar2,
46                                    p_column in varchar2,
47                                    p_condition in varchar2);
48 
49   procedure warn_redundant_column(p_current_rowid  in rowid,
50                                   p_current_interface_id in number,
51                                   p_table_name in varchar2,
52                                   p_column_being_used in varchar2,
53                                   p_column_being_ignored in varchar2,
54                                   p_condition in varchar2 default null);
55 
56   procedure derive_id_from_code(p_current_rowid in rowid,
57                                 p_current_interface_id in number,
58                                 p_table_name in varchar2,
59                                 p_id_column in varchar2,
60                                 p_code_column in varchar2,
61                                 p_derived_value_expression in varchar2,
62                                 p_id_required in boolean default true);
63 
64   procedure derive_code_from_id(p_current_rowid in rowid,
65                                   p_current_interface_id in number,
66                                   p_table_name in varchar2,
67                                   p_id_column in varchar2,
68                                   p_code_column in varchar2,
69                                   p_derived_value_expression in varchar2,
70                                 p_id_required in boolean default true);
71 
72   procedure default_if_null(p_current_rowid in rowid,
73                             p_interface_id in number,
74                             p_table_name in varchar2,
75                             p_column     in varchar2,
76                             p_condition  in varchar2,
77                             p_default_value_expression in varchar2);
78 
79 
80   function request_matches_condition(p_current_rowid  in rowid,
81                                      p_interface_id in number,
82                                      p_table_name   in varchar2,
83                                      p_where_clause in varchar2)
84                                                     return boolean;
85 
86 
87   procedure record_ignored_column_warning(p_interface_id in number,
88                                           p_column_name in varchar2);
89 
90   procedure record_invalid_column_error(p_interface_id in number,
91                                         p_column_name in varchar2);
92 
93   procedure record_error(p_interface_id in number,
94                          p_text in varchar2,
95                          p_warning_only in boolean);
96 
97 
98 END eam_int_utils;