1 PACKAGE xla_accounting_err_pkg AUTHID CURRENT_USER AS
2 -- $Header: xlaaperr.pkh 120.8.12020000.2 2012/07/23 13:22:26 vgopiset ship $
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_accounting_err_pkg |
10 | |
11 | DESCRIPTION |
12 | This is the specification of the package that handles errors for |
13 | accounting entries generated by Accounting Program and Mnaual Enteries.|
14 | |
15 | HISTORY |
16 | 09/09/2002 S. Singhania Created |
17 | 05/21/2003 S. Singhania Modified the specifications of |
18 | initialize() |
19 | 07/29/2003 S. Singhania Modified the specifications of |
20 | initialize() |
21 | Modification for bug # 3072738 |
22 | - Added API GET_TOTAL_ERROR_COUNT |
23 | - Added variable G_ERROR_LIMIT |
24 | Added G_ERROR_COUNT (bug # 2709397) |
25 | 09/09/2003 S. Singhania Added the procedure specifications |
26 | for SET_ERROR_SOURCE |
27 | 10/14/2003 S. Singhania Renamed SET_ERROR_SOURCE to |
28 | SET_OPTIONS. |
29 | Added new parameters to INITIALIZE. |
30 +===========================================================================*/
31
32 -------------------------------------------------------------------------------
33 -- declaring constants for error_source_code
34 -------------------------------------------------------------------------------
35 C_ACCT_PROGRAM VARCHAR2(30) := 'ACCT_PROGRAM';
36 C_ACCT_ENGINE VARCHAR2(30) := 'ACCT_ENGINE';
37 C_TRANSFER_TO_GL VARCHAR2(30) := 'TRANSFER_TO_GL';
38 C_MANUAL_JE VARCHAR2(30) := 'MANUAL_ENTRIES';
39
40 -------------------------------------------------------------------------------
41 -- declaring types
42 -------------------------------------------------------------------------------
43 TYPE t_array_error IS TABLE OF xla_accounting_errors%rowtype
44 INDEX BY BINARY_INTEGER;
45
46 g_error_limit PLS_INTEGER;
47 g_error_count PLS_INTEGER;
48 g_warning_count PLS_INTEGER;
49
50 --accounting_error_limit EXCEPTION;
51
52 -------------------------------------------------------------------------------
53 -- public routines
54 -------------------------------------------------------------------------------
55 --added bug 10226301
56 PROCEDURE copy_global_array ;
57
58
59
60 PROCEDURE build_message
61 (p_appli_s_name IN VARCHAR2
62 ,p_msg_name IN VARCHAR2
63 ,p_entity_id IN NUMBER
64 ,p_event_id IN NUMBER
65 ,p_ledger_id IN NUMBER DEFAULT NULL
66 ,p_ae_header_id IN NUMBER DEFAULT NULL
67 ,p_ae_line_num IN NUMBER DEFAULT NULL
68 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
69
70 PROCEDURE build_message
71 (p_appli_s_name IN VARCHAR2
72 ,p_msg_name IN VARCHAR2
73 ,p_token_1 IN VARCHAR2
74 ,p_value_1 IN VARCHAR2
75 ,p_entity_id IN NUMBER
76 ,p_event_id IN NUMBER
77 ,p_ledger_id IN NUMBER DEFAULT NULL
78 ,p_ae_header_id IN NUMBER DEFAULT NULL
79 ,p_ae_line_num IN NUMBER DEFAULT NULL
80 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
81
82 PROCEDURE build_message
83 (p_appli_s_name IN VARCHAR2
84 ,p_msg_name IN VARCHAR2
85 ,p_token_1 IN VARCHAR2
86 ,p_value_1 IN VARCHAR2
87 ,p_token_2 IN VARCHAR2
88 ,p_value_2 IN VARCHAR2
89 ,p_entity_id IN NUMBER
90 ,p_event_id IN NUMBER
91 ,p_ledger_id IN NUMBER DEFAULT NULL
92 ,p_ae_header_id IN NUMBER DEFAULT NULL
93 ,p_ae_line_num IN NUMBER DEFAULT NULL
94 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
95
96 PROCEDURE build_message
97 (p_appli_s_name IN VARCHAR2
98 ,p_msg_name IN VARCHAR2
99 ,p_token_1 IN VARCHAR2
100 ,p_value_1 IN VARCHAR2
101 ,p_token_2 IN VARCHAR2
102 ,p_value_2 IN VARCHAR2
103 ,p_token_3 IN VARCHAR2
104 ,p_value_3 IN VARCHAR2
105 ,p_entity_id IN NUMBER
106 ,p_event_id IN NUMBER
107 ,p_ledger_id IN NUMBER DEFAULT NULL
108 ,p_ae_header_id IN NUMBER DEFAULT NULL
109 ,p_ae_line_num IN NUMBER DEFAULT NULL
110 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
111
112 PROCEDURE build_message
113 (p_appli_s_name IN VARCHAR2
114 ,p_msg_name IN VARCHAR2
115 ,p_token_1 IN VARCHAR2
116 ,p_value_1 IN VARCHAR2
117 ,p_token_2 IN VARCHAR2
118 ,p_value_2 IN VARCHAR2
119 ,p_token_3 IN VARCHAR2
120 ,p_value_3 IN VARCHAR2
121 ,p_token_4 IN VARCHAR2
122 ,p_value_4 IN VARCHAR2
123 ,p_entity_id IN NUMBER
124 ,p_event_id IN NUMBER
125 ,p_ledger_id IN NUMBER DEFAULT NULL
126 ,p_ae_header_id IN NUMBER DEFAULT NULL
127 ,p_ae_line_num IN NUMBER DEFAULT NULL
128 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
129
130 PROCEDURE build_message
131 (p_appli_s_name IN VARCHAR2
132 ,p_msg_name IN VARCHAR2
133 ,p_token_1 IN VARCHAR2
134 ,p_value_1 IN VARCHAR2
135 ,p_token_2 IN VARCHAR2
136 ,p_value_2 IN VARCHAR2
137 ,p_token_3 IN VARCHAR2
138 ,p_value_3 IN VARCHAR2
139 ,p_token_4 IN VARCHAR2
140 ,p_value_4 IN VARCHAR2
141 ,p_token_5 IN VARCHAR2
142 ,p_value_5 IN VARCHAR2
143 ,p_entity_id IN NUMBER
144 ,p_event_id IN NUMBER
145 ,p_ledger_id IN NUMBER DEFAULT NULL
146 ,p_ae_header_id IN NUMBER DEFAULT NULL
147 ,p_ae_line_num IN NUMBER DEFAULT NULL
148 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
149
150 PROCEDURE build_message
151 (p_appli_s_name IN VARCHAR2
152 ,p_msg_name IN VARCHAR2
153 ,p_token_1 IN VARCHAR2
154 ,p_value_1 IN VARCHAR2
155 ,p_token_2 IN VARCHAR2
156 ,p_value_2 IN VARCHAR2
157 ,p_token_3 IN VARCHAR2
158 ,p_value_3 IN VARCHAR2
159 ,p_token_4 IN VARCHAR2
160 ,p_value_4 IN VARCHAR2
161 ,p_token_5 IN VARCHAR2
162 ,p_value_5 IN VARCHAR2
163 ,p_token_6 IN VARCHAR2
164 ,p_value_6 IN VARCHAR2
165 ,p_entity_id IN NUMBER
166 ,p_event_id IN NUMBER
167 ,p_ledger_id IN NUMBER DEFAULT NULL
168 ,p_ae_header_id IN NUMBER DEFAULT NULL
169 ,p_ae_line_num IN NUMBER DEFAULT NULL
170 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
171
172 FUNCTION get_total_error_count
173 RETURN NUMBER;
174
175 PROCEDURE set_options
176 (p_error_source IN VARCHAR2 DEFAULT NULL
177 ,p_request_id IN NUMBER DEFAULT NULL
178 ,p_application_id IN NUMBER DEFAULT NULL);
179
180 PROCEDURE initialize
181 (p_client_id IN VARCHAR2 DEFAULT NULL
182 ,p_error_limit IN NUMBER DEFAULT NULL
183 ,p_error_source IN VARCHAR2 DEFAULT NULL
184 ,p_request_id IN NUMBER DEFAULT NULL
185 ,p_application_id IN NUMBER DEFAULT NULL);
186
187 PROCEDURE insert_errors;
188 END;