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