1 PACKAGE CZ_RULE_IMPORT AS
2 /* $Header: czruleis.pls 120.0 2005/05/25 06:20:10 appldev noship $ */
3 ---------------------------------------------------------------------------------------
4 CZRI_MODULE_NAME CONSTANT VARCHAR2(16) := 'CZRULEIMPORT';
5 CZRI_COMMIT_SIZE CONSTANT NUMBER := 10000;
6 CZRI_MAXIMUM_ERRORS CONSTANT NUMBER := 1000000;
7 CZRI_API_VERSION CONSTANT NUMBER := 1.0;
8
9 CZRI_LOCALIZED_TEXTS_INC CONSTANT NUMBER := 20;
10 CZRI_RULES_INC CONSTANT NUMBER := 20;
11
12 CZRI_RECSTATUS_CND CONSTANT VARCHAR2(4) := 'CND';
13 CZRI_RECSTATUS_KRS CONSTANT VARCHAR2(4) := 'KRS';
14 CZRI_RECSTATUS_XFR CONSTANT VARCHAR2(4) := 'XFR';
15 CZRI_RECSTATUS_OK CONSTANT VARCHAR2(4) := 'OK';
16
17 CZRI_DISPOSITION_INSERT CONSTANT VARCHAR2(1) := 'I';
18 CZRI_DISPOSITION_MODIFY CONSTANT VARCHAR2(1) := 'M';
19 CZRI_DISPOSITION_REJECT CONSTANT VARCHAR2(1) := 'R';
20 CZRI_DISPOSITION_PASSED CONSTANT VARCHAR2(1) := 'P';
21
22 CZRI_FLAG_NOT_DELETED CONSTANT VARCHAR2(1) := '0';
23 CZRI_FLAG_NOT_SEEDED CONSTANT VARCHAR2(1) := '0';
24 CZRI_FLAG_STATEMENT_RULE CONSTANT VARCHAR2(1) := '0';
25 CZRI_FLAG_NOT_MUTABLE CONSTANT VARCHAR2(1) := '0';
26 CZRI_FLAG_NOT_DISABLED CONSTANT VARCHAR2(1) := '0';
27 CZRI_FLAG_NOT_INVALID CONSTANT VARCHAR2(1) := '0';
28 CZRI_REPOSITORY_PROJECT CONSTANT VARCHAR2(4) := 'PRJ';
29 CZRI_TYPE_RULE_FOLDER CONSTANT VARCHAR2(4) := 'RFL';
30 CZRI_FOLDER_TYPE_RULE CONSTANT VARCHAR2(4) := 'RUL';
31 CZRI_FOLDER_TYPE_CX CONSTANT VARCHAR2(4) := 'CXT';
32 CZRI_EFFECTIVE_USAGE CONSTANT VARCHAR2(16) := '0000000000000000';
33 CZRI_RULE_SEQ_NBR CONSTANT NUMBER := 1;
34 CZRI_RULE_SCOPE_INSTANCE CONSTANT NUMBER := 1;
35 CZRI_TYPE_EXPRESSION_RULE CONSTANT NUMBER := 200;
36 CZRI_TYPE_COMPANION_RULE CONSTANT NUMBER := 300;
37
38 CZRI_ERR_FATAL_ERROR EXCEPTION;
39 CZRI_ERR_REPORT_ERROR EXCEPTION;
40 CZRI_ERR_MAXIMUM_ERRORS EXCEPTION;
41 CZRI_ERR_ACTIVE_SESSIONS EXCEPTION;
42 CZRI_ERR_RUNID_EXISTS EXCEPTION;
43 CZRI_ERR_RUNID_INCORRECT EXCEPTION;
44 CZRI_ERR_DATA_INCORRECT EXCEPTION;
45 ---------------------------------------------------------------------------------------
46 PROCEDURE report(p_message IN VARCHAR2,
47 p_run_id IN NUMBER,
48 p_caller IN VARCHAR2,
49 p_statuscode IN NUMBER);
50 ---------------------------------------------------------------------------------------
51 PROCEDURE cnd_rules(p_api_version IN NUMBER,
52 p_run_id IN NUMBER,
53 p_maximum_errors IN PLS_INTEGER,
54 p_commit_size IN PLS_INTEGER,
55 p_errors IN OUT NOCOPY PLS_INTEGER,
56 x_return_status IN OUT NOCOPY VARCHAR2,
57 x_msg_count IN OUT NOCOPY NUMBER,
58 x_msg_data IN OUT NOCOPY VARCHAR2);
59 ---------------------------------------------------------------------------------------
60 PROCEDURE krs_rules(p_api_version IN NUMBER,
61 p_run_id IN NUMBER,
62 p_maximum_errors IN PLS_INTEGER,
63 p_commit_size IN PLS_INTEGER,
64 p_errors IN OUT NOCOPY PLS_INTEGER,
65 x_return_status IN OUT NOCOPY VARCHAR2,
66 x_msg_count IN OUT NOCOPY NUMBER,
67 x_msg_data IN OUT NOCOPY VARCHAR2);
68 ---------------------------------------------------------------------------------------
69 PROCEDURE xfr_rules(p_api_version IN NUMBER,
70 p_run_id IN NUMBER,
71 p_maximum_errors IN PLS_INTEGER,
72 p_commit_size IN PLS_INTEGER,
73 p_errors IN OUT NOCOPY PLS_INTEGER,
74 x_return_status IN OUT NOCOPY VARCHAR2,
75 x_msg_count IN OUT NOCOPY NUMBER,
76 x_msg_data IN OUT NOCOPY VARCHAR2);
77 ---------------------------------------------------------------------------------------
78 PROCEDURE rpt_rules(p_api_version IN NUMBER,
79 p_run_id IN NUMBER,
80 x_return_status IN OUT NOCOPY VARCHAR2,
81 x_msg_count IN OUT NOCOPY NUMBER,
82 x_msg_data IN OUT NOCOPY VARCHAR2);
83 ---------------------------------------------------------------------------------------
84 PROCEDURE restat_rules(p_api_version IN NUMBER,
85 p_run_id IN NUMBER,
86 x_return_status IN OUT NOCOPY VARCHAR2,
87 x_msg_count IN OUT NOCOPY NUMBER,
88 x_msg_data IN OUT NOCOPY VARCHAR2);
89 ---------------------------------------------------------------------------------------
90 PROCEDURE import_rules(p_api_version IN NUMBER,
91 p_run_id IN NUMBER,
92 p_maximum_errors IN PLS_INTEGER,
93 p_commit_size IN PLS_INTEGER,
94 p_errors IN OUT NOCOPY PLS_INTEGER,
95 x_return_status IN OUT NOCOPY VARCHAR2,
96 x_msg_count IN OUT NOCOPY NUMBER,
97 x_msg_data IN OUT NOCOPY VARCHAR2);
98 ---------------------------------------------------------------------------------------
99 PROCEDURE cnd_localized_texts(p_api_version IN NUMBER,
100 p_run_id IN NUMBER,
101 p_maximum_errors IN PLS_INTEGER,
102 p_commit_size IN PLS_INTEGER,
103 p_errors IN OUT NOCOPY PLS_INTEGER,
104 x_return_status IN OUT NOCOPY VARCHAR2,
105 x_msg_count IN OUT NOCOPY NUMBER,
106 x_msg_data IN OUT NOCOPY VARCHAR2);
107 ---------------------------------------------------------------------------------------
108 PROCEDURE krs_localized_texts(p_api_version IN NUMBER,
109 p_run_id IN NUMBER,
110 p_maximum_errors IN PLS_INTEGER,
111 p_commit_size IN PLS_INTEGER,
112 p_errors IN OUT NOCOPY PLS_INTEGER,
113 x_return_status IN OUT NOCOPY VARCHAR2,
114 x_msg_count IN OUT NOCOPY NUMBER,
115 x_msg_data IN OUT NOCOPY VARCHAR2);
116 ---------------------------------------------------------------------------------------
117 PROCEDURE xfr_localized_texts(p_api_version IN NUMBER,
118 p_run_id IN NUMBER,
119 p_maximum_errors IN PLS_INTEGER,
120 p_commit_size IN PLS_INTEGER,
121 p_errors IN OUT NOCOPY PLS_INTEGER,
122 x_return_status IN OUT NOCOPY VARCHAR2,
123 x_msg_count IN OUT NOCOPY NUMBER,
124 x_msg_data IN OUT NOCOPY VARCHAR2);
125 ---------------------------------------------------------------------------------------
126 PROCEDURE rpt_localized_texts(p_api_version IN NUMBER,
127 p_run_id IN NUMBER,
128 x_return_status IN OUT NOCOPY VARCHAR2,
129 x_msg_count IN OUT NOCOPY NUMBER,
130 x_msg_data IN OUT NOCOPY VARCHAR2);
131 ---------------------------------------------------------------------------------------
132 PROCEDURE restat_localized_texts(p_api_version IN NUMBER,
133 p_run_id IN NUMBER,
134 x_return_status IN OUT NOCOPY VARCHAR2,
135 x_msg_count IN OUT NOCOPY NUMBER,
136 x_msg_data IN OUT NOCOPY VARCHAR2);
137 ---------------------------------------------------------------------------------------
138 PROCEDURE import_localized_texts(p_api_version IN NUMBER,
139 p_run_id IN NUMBER,
140 p_maximum_errors IN PLS_INTEGER,
141 p_commit_size IN PLS_INTEGER,
142 p_errors IN OUT NOCOPY PLS_INTEGER,
143 x_return_status IN OUT NOCOPY VARCHAR2,
144 x_msg_count IN OUT NOCOPY NUMBER,
145 x_msg_data IN OUT NOCOPY VARCHAR2);
146 ---------------------------------------------------------------------------------------
147 PROCEDURE refresh_statistics(p_api_version IN NUMBER,
148 p_run_id IN NUMBER,
149 x_return_status IN OUT NOCOPY VARCHAR2,
150 x_msg_count IN OUT NOCOPY NUMBER,
151 x_msg_data IN OUT NOCOPY VARCHAR2);
152 ---------------------------------------------------------------------------------------
153 PROCEDURE rule_import(p_api_version IN NUMBER,
154 p_run_id IN OUT NOCOPY NUMBER,
155 p_maximum_errors IN PLS_INTEGER,
156 p_commit_size IN PLS_INTEGER,
157 x_return_status IN OUT NOCOPY VARCHAR2,
158 x_msg_count IN OUT NOCOPY NUMBER,
159 x_msg_data IN OUT NOCOPY VARCHAR2);
160
161 --------------------------
162 PROCEDURE lock_models (p_api_version IN NUMBER,
163 p_run_id IN NUMBER,
164 p_commit_flag IN VARCHAR2,
165 x_locked_entities OUT NOCOPY SYSTEM.CZ_NUMBER_TBL_TYPE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2);
169
170
171 ---------------------------------------------------------------------------------------
172 /* Rule Import messages.
173
174 CZRI_TXT_NULLORIGSYSREF
175 Record rejected: Null value in ORIG_SYS_REF column. Please populate the column and then run the import
176 program again.
177
178 CZRI_TXT_NULLLANGUAGE
179 Record rejected: Null value in LANGUAGE column. Please populate the column and then run the import
180 program again.
181
182 CZRI_TXT_NULLMODELID
183 Record rejected: Null value in MODEL_ID column. Please populate the column and then run the import
184 program again.
185
186 CZRI_TXT_INVALIDMODEL
187 Record rejected: The value in MODEL_ID refers to an invalid Model. Please correct the value and then run
188 the import program again.
189
190 CZRI_TXT_NULLSOURCELANG
191 Record rejected: Null value in SOURCE_LANG column. Please populate the column and then run the import
192 program again.
193
194 CZRI_RLE_NULLORIGSYSREF
195 Record rejected: Null value in ORIG_SYS_REF column. Please populate the column and then run the import
196 program again.
197
198 CZRI_RLE_NULLMODELID
199 Record rejected: Null value in MODEL_ID column. Please populate the column and then run the import
200 program again.
201
202 CZRI_RLE_INVALIDMODEL
203 Record rejected: The value in MODEL_ID column refers to an invalid Model. Please correct the value and
204 then run the import program again.
205
206 CZRI_RLE_NOSUCHFOLDER
207 Record rejected: The value in RULE_FOLDER_ID column is invalid because it refers to a folder that does
208 not exist. Please correct the value and then run the import program again.
209
210 CZRI_RLE_NOROOTFOLDER
211 Record rejected: Unable to find the root rule folder for the Model, specified by the value in DEVL_PROJECT_ID
212 column. Please correct the value and then run the import program again.
213
214 CZRI_RLE_NULLTEXTPOINTER
215 Record rejected: Null value in FSK_LOCALIZED_TEXT_1 column. Please populate the column and then run the
216 import program again.
217
218 CZRI_RLE_NULLTYPE
219 Record rejected: The value in RULE_TYPE column is null. The correct value is 300 for Configurator Extension
220 and 200 for other types of rules. Please populate the column and then run the import program again.
221
222 CZRI_RLE_INVALIDTYPE
223 Record rejected: The value in RULE_TYPE column is incorrect. The correct value is 300 for Configurator
224 Extension and 200 for other types of rules. Please correct the value and then run the import program again.
225
226 CZRI_RLE_NULLCOMPONENTID
227 Record rejected: Null value in COMPONENT_ID column for a Configurator Extension. Please populate the column
228 and then run the import program again.
229
230 CZRI_RLE_NULLEXPLID
231 Record rejected: Null value in MODEL_REF_EXPL_ID column for a Configurator Extension. Please populate the
232 column and then run the import program again.
233
234 CZRI_RLE_NOREASONID
235 Record rejected: Unable to resolve FSK_LOCALIZED_TEXT_1. No record with matching ORIG_SYS_REF exists in
236 CZ_LOCALIZED_TEXTS for the specified Model.
237
238 CZRI_RLE_NOUNSATISFIED
239 Record rejected: Unable to resolve FSK_LOCALIZED_TEXT_2. No record with matching ORIG_SYS_REF exists
240 in CZ_LOCALIZED_TEXTS for the specified Model.
241
242 CZRI_RLE_NOCOMPONENTID
243 Record rejected: Unable to resolve FSK_COMPONENT_ID for a Configurator Extension. No record with matching
244 ORIG_SYS_REF exists in CZ_PS_NODES.
245
246 CZRI_RLE_NOEXPLID
247 Record rejected: Unable to resolve FSK_MODEL_REF_EXPL_ID for a Configurator Extension. No record with
248 matching ORIG_SYS_REF exists in CZ_MODEL_REF_EXPLS.
249
250 CZRI_RLE_PRESENTFLAG
251 Record rejected: The value in PRESENTATION_FLAG column is incorrect. The correct value is '0'. Please
252 correct the value and then run the import program again.
253
254 CZRI_RLE_NULLNAME
255 Record rejected: Null value in NAME column. Rule name is required. Please populate the column and then
256 run the import program again.
257
258 CZRI_TXT_DUPLICATE
259 Record rejected as duplicate: A record with the same ORIG_SYS_REF and LANGUAGE values exists in Model
260 with MODEL_ID = %MODELID.
261
262 CZRI_RLE_DUPLICATE
263 Record rejected as duplicate: A record with the same ORIG_SYS_REF exists in Model with DEVL_PROJECT_ID = %MODELID.
264
265 CZRI_RLE_TRANSLATIONS
266 Record rejected: Incorrect number of translations in CZ_LOCALIZED_TEXTS: %ACTUAL. Expected number of
267 translations: %EXPECTED.
268
269 CZRI_IMP_MAXIMUMERRORS
270 Import session with RUN_ID = %RUNID has been terminated because the maximum number of errors has been reached.
271
272 CZRI_IMP_ACTIVESESSION
273 Import session with RUN_ID = %RUNID has been terminated because there are other import sessions running.
274
275 CZRI_IMP_RUNID_EXISTS
276 Control record with RUN_ID = %RUNID exists. Please delete the records from CZ_XFR_RUN_INFOS and
277 CZ_XFR_RUN_RESULTS or run the import program again with a different RUN_ID value.
278
279 CZRI_ERR_RUNID_INCORRECT
280 No data found in the CZ_IMP_RULES table with RUN_ID = %RUNID.
281
282 CZRI_ERR_DATA_INCORRECT
283 No rules imported with RUN_ID = %RUNID. Please modify the source data and run the import program again.
284
285 CZRI_IMP_SQLERROR
286 The following error occurred: %ERRORTEXT. */
287 ---------------------------------------------------------------------------------------
288 END;