[Home] [Help]
PACKAGE: APPS.GL_CHART_OF_ACCOUNTS_API_PKG
Source
1 PACKAGE GL_CHART_OF_ACCOUNTS_API_PKG AUTHID CURRENT_USER AS
2 /* $Header: gluvcoas.pls 120.0 2003/01/31 23:40:47 djogg ship $ */
3 --
4 -- Package
5 -- GL_CHART_OF_ACCOUNTS_API_PKG
6 -- Purpose
7 -- This package specification is used to validate the chart of accounts information
8 -- imported with iSpeed.
9 -- History
10 -- 10.09.2000 O Monnier Created.
11
12 --
13 -- EXCEPTIONS
14 --
15 invalid_dml_mode EXCEPTION;
16 flexfield_not_supported EXCEPTION;
17 flexfield_must_exist EXCEPTION;
18 dynamic_inserts_not_allowed EXCEPTION;
19 multiflex_not_allowed EXCEPTION;
20 structure_name_not_unique EXCEPTION;
21 invalid_app_column_name EXCEPTION;
22 segment_num_not_unique EXCEPTION;
23 gl_segment_must_be_required EXCEPTION;
24 gl_segment_must_be_displayed EXCEPTION;
25 value_set_must_exist EXCEPTION;
26 gl_value_set_must_exist EXCEPTION;
27 invalid_value_set EXCEPTION;
28 gl_format_must_be_char EXCEPTION;
29 maximum_size_too_large EXCEPTION;
30 invalid_default_value EXCEPTION;
31 vset_security_not_enabled EXCEPTION;
32 display_size_too_large EXCEPTION;
33 invalid_date_default_type EXCEPTION;
34 invalid_time_default_type EXCEPTION;
35 invalid_seg_attribute_type EXCEPTION;
36 invalid_assignment_date_order EXCEPTION;
37 global_qualifier_error EXCEPTION;
38 qualifier_not_unique EXCEPTION;
39 invalid_value_set_name EXCEPTION;
40 invalid_minimum_maximum EXCEPTION;
41 invalid_dependant_value EXCEPTION;
42 invalid_minimum_value EXCEPTION;
43 invalid_maximum_value EXCEPTION;
44 invalid_minormax_value EXCEPTION;
45 invalid_value EXCEPTION;
46 invalid_compiled_value_attr1 EXCEPTION;
47 invalid_compiled_value_attr2 EXCEPTION;
48 invalid_compiled_value_attr3 EXCEPTION;
49 invalid_val_attribute_type EXCEPTION;
50 value_meaning_not_unique EXCEPTION;
51 invalid_value_meaning EXCEPTION;
52 attribute_must_exist EXCEPTION;
53 required_attr_must_exist EXCEPTION;
54 invalid_low_high_range_code EXCEPTION;
55 sum_maximum_size_too_large EXCEPTION;
56 gl_segment_not_consecutive EXCEPTION;
57 gl_same_bal_acct_segment EXCEPTION;
58 invalid_application_id EXCEPTION;
59 invalid_structure_code EXCEPTION;
60 hierarchy_loop EXCEPTION;
61 invalid_parent EXCEPTION;
62 request_failed EXCEPTION;
63
64 --
65 -- PUBLIC FUNCTIONS
66 --
67
68 --
69 -- Procedure
70 -- validate_structure
71 -- Purpose
72 -- Do the validation for the structure
73 -- (FND_ID_FLEX_STRUCTURES table).
74 -- History
75 -- 10.09.2000 O Monnier Created.
76 --
77 PROCEDURE validate_structure(v_application_id IN NUMBER,
78 v_id_flex_code IN VARCHAR2,
79 v_id_flex_num IN NUMBER,
80 v_dynamic_inserts_allowed_f IN VARCHAR2,
81 v_operation IN VARCHAR2 DEFAULT 'DML_INSERT');
82
83 --
84 -- Procedure
85 -- validate_structure_tl
86 -- Purpose
87 -- Do the validation for the translated structure
88 -- (FND_ID_FLEX_STRUCTURES_TL table).
89 -- History
90 -- 10.09.2000 O Monnier Created.
91 --
92 PROCEDURE validate_structure_tl(v_application_id IN NUMBER,
93 v_id_flex_code IN VARCHAR2,
94 v_id_flex_num IN NUMBER,
95 v_language IN VARCHAR2,
96 v_id_flex_structure_name IN VARCHAR2,
97 v_userenvlang IN VARCHAR2);
98
99 --
100 -- Procedure
101 -- validate_segment
102 -- Purpose
103 -- Do the validation for one particular segment of a structure
104 -- (FND_ID_FLEX_SEGMENTS table).
105 -- History
106 -- 10.09.2000 O Monnier Created.
107 --
108 PROCEDURE validate_segment(v_application_id IN NUMBER,
109 v_id_flex_code IN VARCHAR2,
110 v_id_flex_num IN NUMBER,
111 v_application_column_name IN VARCHAR2,
112 v_segment_name IN VARCHAR2,
113 v_segment_num IN NUMBER,
114 v_enabled_flag IN VARCHAR2,
115 v_required_flag IN VARCHAR2,
116 v_display_flag IN VARCHAR2,
117 v_display_size IN NUMBER,
118 v_security_enabled_flag IN VARCHAR2,
119 v_flex_value_set_id IN NUMBER,
120 v_default_type IN VARCHAR2,
121 v_default_value IN VARCHAR2);
122
123
124 --
125 -- Procedure
126 -- validate_segment_tl
127 -- Purpose
128 -- Do the validation for one particular translated segment of a structure
129 -- (FND_ID_FLEX_SEGMENTS_TL table).
130 -- History
131 -- 10.09.2000 O Monnier Created.
132 --
133 PROCEDURE validate_segment_tl(v_application_id IN NUMBER,
134 v_id_flex_code IN VARCHAR2,
135 v_id_flex_num IN NUMBER,
136 v_application_column_name IN VARCHAR2,
137 v_language IN VARCHAR2);
138
139
140 --
141 -- Procedure
142 -- validate_seg_attribute_value
143 -- Purpose
144 -- Do the validation for one particular segment attribute
145 -- (FND_SEGMENT_ATTRIBUTE_VALUES table)
146 -- History
147 -- 10.09.2000 O Monnier Created.
148 --
149 PROCEDURE validate_seg_attribute_value(v_application_id IN NUMBER,
150 v_id_flex_code IN VARCHAR2,
151 v_id_flex_num IN NUMBER,
152 v_application_column_name IN VARCHAR2,
153 v_segment_attribute_type IN VARCHAR2,
154 v_attribute_value IN VARCHAR2);
155
156
157 --
158 -- Procedure
159 -- validate_value_set
160 -- Purpose
161 -- Do the validation for one particular value set
162 -- (FND_FLEX_VALUE_SETS table)
163 -- History
164 -- 10.09.2000 O Monnier Created.
165 --
166 PROCEDURE validate_value_set(v_flex_value_set_id IN NUMBER,
167 v_flex_value_set_name IN VARCHAR2,
168 v_format_type IN VARCHAR2,
169 v_maximum_size IN NUMBER,
170 v_alphanumeric_allowed_flag IN VARCHAR2,
171 v_uppercase_only_flag IN VARCHAR2,
172 v_numeric_mode_enabled_flag IN VARCHAR2,
173 v_dependant_default_value IN VARCHAR2,
174 v_minimum_value IN VARCHAR2,
175 v_maximum_value IN VARCHAR2,
176 v_number_precision IN NUMBER);
177
178
179 --
180 -- Procedure
181 -- validate_validation_qualifier
182 -- (FND_FLEX_VALIDATION_QUALIFIERS table)
183 -- Purpose
184 -- Do the validation for one particular validation qualifier
185 -- History
186 -- 10.09.2000 O Monnier Created.
187 --
188 PROCEDURE validate_validation_qualifier(v_id_flex_application_id IN NUMBER,
189 v_id_flex_code IN VARCHAR2,
190 v_flex_value_set_id IN NUMBER,
191 v_segment_attribute_type IN VARCHAR2,
192 v_value_attribute_type IN VARCHAR2);
193
194 --
195 -- Procedure
196 -- validate_value
197 -- (FND_FLEX_VALUES table)
198 -- Purpose
199 -- Do the validation for one particular value of a value set.
200 -- History
201 -- 10.09.2000 O Monnier Created.
202 --
203 PROCEDURE validate_value(v_flex_value_id IN NUMBER,
204 v_flex_value_set_id IN NUMBER,
205 v_flex_value IN VARCHAR2,
206 v_compiled_value_attributes IN VARCHAR2);
207
208
209 --
210 -- Procedure
211 -- validate_value_tl
212 -- (FND_FLEX_VALUES_TL table)
213 -- Purpose
214 -- Do the validation for one particular translated value of a value set.
215 -- History
216 -- 10.09.2000 O Monnier Created.
217 --
218 PROCEDURE validate_value_tl(v_flex_value_id IN NUMBER,
219 v_language IN VARCHAR2,
220 v_flex_value_meaning IN VARCHAR2,
221 v_userenvlang IN VARCHAR2);
222
223
224 --
225 -- Procedure
226 -- validate_final_structure
227 -- Purpose
228 -- Do the final validation when all the rows has been inserted in the
229 -- database for one particular structure:
230 -- Check that the structure has all the global and required qualifiers.
231 -- History
232 -- 10.09.2000 O Monnier Created.
233 --
234 PROCEDURE validate_final_structure(v_application_id IN NUMBER,
235 v_id_flex_code IN VARCHAR2,
236 v_id_flex_num IN NUMBER);
237
238
239 --
240 -- Procedure
241 -- compile_key_flexfield
242 -- Purpose
243 -- Compile the key flexfield if needed.
244 -- History
245 -- 10.09.2000 O Monnier Created.
246 --
247 FUNCTION compile_key_flexfield(v_application_id IN NUMBER,
248 v_id_flex_code IN VARCHAR2,
249 v_id_flex_structure_code IN VARCHAR2) RETURN VARCHAR2;
250
251 --
252 -- Procedure
253 -- validate_hierarchy
254 -- Purpose
255 -- Detect hierarchy loop in rows to be added to
256 -- fnd_flex_value_norm_hierarchy
257 -- History
258 -- 02.03.2001 M Marra Created.
259 -- 03.08.2001 M Marra Modified to work row by row
260 -- rather than validating the entire hierarchy
261 -- at once. This reflects the repositioning of
262 -- FndFlexValueNormHierarchyEO to a composite
263 -- child of FndFlexValueEO.
264 --
265 procedure validate_hierarchy (
266 p_parent IN varchar2,
267 p_child_low IN varchar2,
268 p_child_high IN varchar2,
269 p_value_set_id IN number);
270
271 --
272 -- Function
273 -- compile_hierarchy
274 -- Purpose
275 -- Compile hierarchy data from fnd_flex_value_norm_hierarchy.
276 -- History
277 -- 02.03.2001 MMarra Created.
278 --
279 FUNCTION compile_hierarchy (
280 p_flex_value_set_id IN NUMBER
281 ) RETURN VARCHAR2;
282
283 END GL_CHART_OF_ACCOUNTS_API_PKG;