1 PACKAGE xla_accounting_err_pkg AS
2 -- $Header: xlaaperr.pkh 120.8 2006/04/11 23:17:48 wychan 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 PROCEDURE build_message
56 (p_appli_s_name IN VARCHAR2
57 ,p_msg_name IN VARCHAR2
58 ,p_entity_id IN NUMBER
59 ,p_event_id IN NUMBER
60 ,p_ledger_id IN NUMBER DEFAULT NULL
61 ,p_ae_header_id IN NUMBER DEFAULT NULL
62 ,p_ae_line_num IN NUMBER DEFAULT NULL
63 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
64
65 PROCEDURE build_message
66 (p_appli_s_name IN VARCHAR2
67 ,p_msg_name IN VARCHAR2
68 ,p_token_1 IN VARCHAR2
69 ,p_value_1 IN VARCHAR2
70 ,p_entity_id IN NUMBER
71 ,p_event_id IN NUMBER
72 ,p_ledger_id IN NUMBER DEFAULT NULL
73 ,p_ae_header_id IN NUMBER DEFAULT NULL
74 ,p_ae_line_num IN NUMBER DEFAULT NULL
75 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
76
77 PROCEDURE build_message
78 (p_appli_s_name IN VARCHAR2
79 ,p_msg_name IN VARCHAR2
80 ,p_token_1 IN VARCHAR2
81 ,p_value_1 IN VARCHAR2
82 ,p_token_2 IN VARCHAR2
83 ,p_value_2 IN VARCHAR2
84 ,p_entity_id IN NUMBER
85 ,p_event_id IN NUMBER
86 ,p_ledger_id IN NUMBER DEFAULT NULL
87 ,p_ae_header_id IN NUMBER DEFAULT NULL
88 ,p_ae_line_num IN NUMBER DEFAULT NULL
89 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
90
91 PROCEDURE build_message
92 (p_appli_s_name IN VARCHAR2
93 ,p_msg_name IN VARCHAR2
94 ,p_token_1 IN VARCHAR2
95 ,p_value_1 IN VARCHAR2
96 ,p_token_2 IN VARCHAR2
97 ,p_value_2 IN VARCHAR2
98 ,p_token_3 IN VARCHAR2
99 ,p_value_3 IN VARCHAR2
100 ,p_entity_id IN NUMBER
101 ,p_event_id IN NUMBER
102 ,p_ledger_id IN NUMBER DEFAULT NULL
103 ,p_ae_header_id IN NUMBER DEFAULT NULL
104 ,p_ae_line_num IN NUMBER DEFAULT NULL
105 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
106
107 PROCEDURE build_message
108 (p_appli_s_name IN VARCHAR2
109 ,p_msg_name IN VARCHAR2
110 ,p_token_1 IN VARCHAR2
111 ,p_value_1 IN VARCHAR2
112 ,p_token_2 IN VARCHAR2
113 ,p_value_2 IN VARCHAR2
114 ,p_token_3 IN VARCHAR2
115 ,p_value_3 IN VARCHAR2
116 ,p_token_4 IN VARCHAR2
117 ,p_value_4 IN VARCHAR2
118 ,p_entity_id IN NUMBER
119 ,p_event_id IN NUMBER
120 ,p_ledger_id IN NUMBER DEFAULT NULL
121 ,p_ae_header_id IN NUMBER DEFAULT NULL
122 ,p_ae_line_num IN NUMBER DEFAULT NULL
123 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
124
125 PROCEDURE build_message
126 (p_appli_s_name IN VARCHAR2
127 ,p_msg_name IN VARCHAR2
128 ,p_token_1 IN VARCHAR2
129 ,p_value_1 IN VARCHAR2
130 ,p_token_2 IN VARCHAR2
131 ,p_value_2 IN VARCHAR2
132 ,p_token_3 IN VARCHAR2
133 ,p_value_3 IN VARCHAR2
134 ,p_token_4 IN VARCHAR2
135 ,p_value_4 IN VARCHAR2
136 ,p_token_5 IN VARCHAR2
137 ,p_value_5 IN VARCHAR2
138 ,p_entity_id IN NUMBER
139 ,p_event_id IN NUMBER
140 ,p_ledger_id IN NUMBER DEFAULT NULL
141 ,p_ae_header_id IN NUMBER DEFAULT NULL
142 ,p_ae_line_num IN NUMBER DEFAULT NULL
143 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
144
145 PROCEDURE build_message
146 (p_appli_s_name IN VARCHAR2
147 ,p_msg_name IN VARCHAR2
148 ,p_token_1 IN VARCHAR2
149 ,p_value_1 IN VARCHAR2
150 ,p_token_2 IN VARCHAR2
151 ,p_value_2 IN VARCHAR2
152 ,p_token_3 IN VARCHAR2
153 ,p_value_3 IN VARCHAR2
154 ,p_token_4 IN VARCHAR2
155 ,p_value_4 IN VARCHAR2
156 ,p_token_5 IN VARCHAR2
157 ,p_value_5 IN VARCHAR2
158 ,p_token_6 IN VARCHAR2
159 ,p_value_6 IN VARCHAR2
160 ,p_entity_id IN NUMBER
161 ,p_event_id IN NUMBER
162 ,p_ledger_id IN NUMBER DEFAULT NULL
163 ,p_ae_header_id IN NUMBER DEFAULT NULL
164 ,p_ae_line_num IN NUMBER DEFAULT NULL
165 ,p_accounting_batch_id IN NUMBER DEFAULT NULL);
166
167 FUNCTION get_total_error_count
168 RETURN NUMBER;
169
170 PROCEDURE set_options
171 (p_error_source IN VARCHAR2 DEFAULT NULL
172 ,p_request_id IN NUMBER DEFAULT NULL
173 ,p_application_id IN NUMBER DEFAULT NULL);
174
175 PROCEDURE initialize
176 (p_client_id IN VARCHAR2 DEFAULT NULL
177 ,p_error_limit IN NUMBER DEFAULT NULL
178 ,p_error_source IN VARCHAR2 DEFAULT NULL
179 ,p_request_id IN NUMBER DEFAULT NULL
180 ,p_application_id IN NUMBER DEFAULT NULL);
181
182 PROCEDURE insert_errors;
183 END;
[Home] [Help]