eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_RULE_IMPORT dependencies on CZ_UTILS

Line 165: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLMODELID');

161: t_disposition(i) := CZRI_DISPOSITION_REJECT;
162:
163: IF(t_devl_project_id(i) IS NULL)THEN
164:
165: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLMODELID');
166:
167: ELSIF(h_InvalidModel.EXISTS(t_devl_project_id(i)))THEN
168:
169: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');

Line 169: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');

165: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLMODELID');
166:
167: ELSIF(h_InvalidModel.EXISTS(t_devl_project_id(i)))THEN
168:
169: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');
170:
171: ELSIF(h_NoRootFolder.EXISTS(t_devl_project_id(i)))THEN
172:
173: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');

Line 173: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');

169: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');
170:
171: ELSIF(h_NoRootFolder.EXISTS(t_devl_project_id(i)))THEN
172:
173: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');
174:
175: ELSIF(t_rule_folder_id(i) IS NOT NULL AND h_NoSuchFolder.EXISTS(t_rule_folder_id(i)))THEN
176:
177: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');

Line 177: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');

173: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');
174:
175: ELSIF(t_rule_folder_id(i) IS NOT NULL AND h_NoSuchFolder.EXISTS(t_rule_folder_id(i)))THEN
176:
177: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');
178:
179: ELSIF(t_orig_sys_ref(i) IS NULL)THEN
180:
181: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLORIGSYSREF');

Line 181: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLORIGSYSREF');

177: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');
178:
179: ELSIF(t_orig_sys_ref(i) IS NULL)THEN
180:
181: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLORIGSYSREF');
182:
183: ELSIF(t_rule_type(i) IS NULL)THEN
184:
185: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLTYPE');

Line 185: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLTYPE');

181: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLORIGSYSREF');
182:
183: ELSIF(t_rule_type(i) IS NULL)THEN
184:
185: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLTYPE');
186:
187: ELSIF(t_rule_type(i) NOT IN (CZRI_TYPE_EXPRESSION_RULE, CZRI_TYPE_COMPANION_RULE))THEN
188:
189: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDTYPE');

Line 189: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDTYPE');

185: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLTYPE');
186:
187: ELSIF(t_rule_type(i) NOT IN (CZRI_TYPE_EXPRESSION_RULE, CZRI_TYPE_COMPANION_RULE))THEN
188:
189: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDTYPE');
190:
191: -- For the Phase I we do not implement resolution of component_id, model_ref_expl_id values for
192: -- CX rules using surrogate keys. Instead, we require direct population of the columns.
193: --

Line 196: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLCOMPONENTID');

192: -- CX rules using surrogate keys. Instead, we require direct population of the columns.
193: --
194: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_fsk_component_id(i) IS NULL)THEN
195: --
196: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLCOMPONENTID');
197: --
198: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_fsk_model_ref_expl_id(i) IS NULL)THEN
199: --
200: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');

Line 200: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');

196: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLCOMPONENTID');
197: --
198: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_fsk_model_ref_expl_id(i) IS NULL)THEN
199: --
200: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');
201:
202: -- If component_id is NULL, it will be populated automatically with the ps_node_id of the root
203: -- model node.
204: --

Line 207: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLCOMPONENTID');

203: -- model node.
204: --
205: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_component_id(i) IS NULL)THEN
206: --
207: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLCOMPONENTID');
208:
209: -- If model_ref_expl_id is NULL, it will be populated automatically with the model_ref_expl_id
210: -- of the root model node.
211: --

Line 214: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');

210: -- of the root model node.
211: --
212: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_model_ref_expl_id(i) IS NULL)THEN
213: --
214: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');
215:
216: ELSIF(t_name(i) IS NULL)THEN
217:
218: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLNAME');

Line 218: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLNAME');

214: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');
215:
216: ELSIF(t_name(i) IS NULL)THEN
217:
218: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLNAME');
219:
220: ELSIF(t_presentation_flag(i) IS NOT NULL AND t_presentation_flag(i) <> CZRI_FLAG_STATEMENT_RULE)THEN
221:
222: t_message(i) := cz_utils.get_text('CZRI_RLE_PRESENTFLAG');

Line 222: t_message(i) := cz_utils.get_text('CZRI_RLE_PRESENTFLAG');

218: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLNAME');
219:
220: ELSIF(t_presentation_flag(i) IS NOT NULL AND t_presentation_flag(i) <> CZRI_FLAG_STATEMENT_RULE)THEN
221:
222: t_message(i) := cz_utils.get_text('CZRI_RLE_PRESENTFLAG');
223:
224: ELSE
225:
226: t_disposition(i) := CZRI_DISPOSITION_PASSED;

Line 238: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');

234: h_ValidModel(t_devl_project_id(i)) := v_root_expl_id;
235:
236: EXCEPTION
237: WHEN NO_DATA_FOUND THEN
238: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');
239: t_disposition(i) := CZRI_DISPOSITION_REJECT;
240: h_InvalidModel(t_devl_project_id(i)) := 1;
241: END;
242: END IF;

Line 260: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');

256: h_RootFolder(t_devl_project_id(i)) := v_root_folder_id;
257:
258: EXCEPTION
259: WHEN NO_DATA_FOUND THEN
260: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');
261: t_disposition(i) := CZRI_DISPOSITION_REJECT;
262: h_NoRootFolder(t_devl_project_id(i)) := 1;
263: END;
264: END IF;

Line 275: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');

271: h_ValidFolder(t_rule_folder_id(i)) := v_root_folder_id;
272:
273: EXCEPTION
274: WHEN NO_DATA_FOUND THEN
275: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');
276: t_disposition(i) := CZRI_DISPOSITION_REJECT;
277: h_NoSuchFolder(t_rule_folder_id(i)) := 1;
278: END;
279: END IF;

Line 330: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);

326: CLOSE c_rec;
327: EXCEPTION
328: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
329: CLOSE c_rec;
330: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
331: x_msg_count := 1;
332: report(x_msg_data, p_run_id, 'cnd_rules', v_debug);
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: RAISE CZRI_ERR_FATAL_ERROR;

Line 337: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: RAISE CZRI_ERR_FATAL_ERROR;
335: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
336: CLOSE c_rec;
337: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
338: x_msg_count := 1;
339: report(x_msg_data, p_run_id, 'cnd_rules', v_debug);
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341: RAISE CZRI_ERR_FATAL_ERROR;

Line 457: t_message(i) := cz_utils.get_text('CZRI_RLE_DUPLICATE', 'MODELID', last_project_id);

453: last_project_id = t_devl_project_id(i))THEN
454:
455: --This is a duplicate record in the source data.
456:
457: t_message(i) := cz_utils.get_text('CZRI_RLE_DUPLICATE', 'MODELID', last_project_id);
458: t_disposition(i) := CZRI_DISPOSITION_REJECT;
459: END IF;
460:
461: IF(t_disposition(i) = CZRI_DISPOSITION_PASSED)THEN

Line 499: t_message(i) := cz_utils.get_text('CZRI_RLE_TRANSLATIONS', 'ACTUAL', t_intl_text_id.COUNT, 'EXPECTED', v_translations);

495: v_translations := t_intl_text_id.COUNT;
496:
497: ELSIF(v_translations <> t_intl_text_id.COUNT)THEN
498:
499: t_message(i) := cz_utils.get_text('CZRI_RLE_TRANSLATIONS', 'ACTUAL', t_intl_text_id.COUNT, 'EXPECTED', v_translations);
500: t_disposition(i) := CZRI_DISPOSITION_REJECT;
501: END IF;
502: ELSE
503:

Line 504: t_message(i) := cz_utils.get_text('CZRI_RLE_NOREASONID');

500: t_disposition(i) := CZRI_DISPOSITION_REJECT;
501: END IF;
502: ELSE
503:
504: t_message(i) := cz_utils.get_text('CZRI_RLE_NOREASONID');
505: t_disposition(i) := CZRI_DISPOSITION_REJECT;
506: END IF;
507: END IF;
508: END IF;

Line 541: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);

537: CLOSE c_rec;
538: EXCEPTION
539: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
540: CLOSE c_rec;
541: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
542: x_msg_count := 1;
543: report(x_msg_data, p_run_id, 'krs_rules', v_debug);
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: RAISE CZRI_ERR_FATAL_ERROR;

Line 548: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: RAISE CZRI_ERR_FATAL_ERROR;
546: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
547: CLOSE c_rec;
548: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
549: x_msg_count := 1;
550: report(x_msg_data, p_run_id, 'krs_rules', v_debug);
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: RAISE CZRI_ERR_FATAL_ERROR;

Line 1047: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1043: t_effectivity_set_id(i));
1044:
1045: EXCEPTION
1046: WHEN OTHERS THEN
1047: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1048: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1049: ROLLBACK TO insert_rule_record;
1050: END;
1051: END IF;

Line 1140: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1136: AND object_type = CZRI_FOLDER_TYPE_RULE;
1137:
1138: EXCEPTION
1139: WHEN OTHERS THEN
1140: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1141: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1142: ROLLBACK TO update_rule_record;
1143: END;
1144: END IF;

Line 1170: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);

1166: CLOSE c_rec;
1167: EXCEPTION
1168: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
1169: CLOSE c_rec;
1170: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1171: x_msg_count := 1;
1172: report(x_msg_data, p_run_id, 'xfr_rules', v_debug);
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174: RAISE CZRI_ERR_FATAL_ERROR;

Line 1177: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174: RAISE CZRI_ERR_FATAL_ERROR;
1175: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1176: CLOSE c_rec;
1177: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1178: x_msg_count := 1;
1179: report(x_msg_data, p_run_id, 'xfr_rules', v_debug);
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1181: RAISE CZRI_ERR_FATAL_ERROR;

Line 1206: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1202:
1203: COMMIT;
1204: EXCEPTION
1205: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1206: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1207: x_msg_count := 1;
1208: report(x_msg_data, p_run_id, 'rpt_rules', v_debug);
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: RAISE CZRI_ERR_REPORT_ERROR;

Line 1362: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLMODELID');

1358: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1359:
1360: IF(t_model_id(i) IS NULL)THEN
1361:
1362: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLMODELID');
1363:
1364: ELSIF(h_InvalidModel.EXISTS(t_model_id(i)))THEN
1365:
1366: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');

Line 1366: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');

1362: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLMODELID');
1363:
1364: ELSIF(h_InvalidModel.EXISTS(t_model_id(i)))THEN
1365:
1366: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');
1367:
1368: ELSIF(t_orig_sys_ref(i) IS NULL)THEN
1369:
1370: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLORIGSYSREF');

Line 1370: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLORIGSYSREF');

1366: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');
1367:
1368: ELSIF(t_orig_sys_ref(i) IS NULL)THEN
1369:
1370: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLORIGSYSREF');
1371:
1372: ELSIF(t_language(i) IS NULL)THEN
1373:
1374: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLLANGUAGE');

Line 1374: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLLANGUAGE');

1370: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLORIGSYSREF');
1371:
1372: ELSIF(t_language(i) IS NULL)THEN
1373:
1374: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLLANGUAGE');
1375:
1376: ELSIF(t_source_lang(i) IS NULL)THEN
1377:
1378: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLSOURCELANG');

Line 1378: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLSOURCELANG');

1374: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLLANGUAGE');
1375:
1376: ELSIF(t_source_lang(i) IS NULL)THEN
1377:
1378: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLSOURCELANG');
1379:
1380: ELSE
1381:
1382: t_disposition(i) := CZRI_DISPOSITION_PASSED;

Line 1393: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');

1389: h_ValidModel(t_model_id(i)) := 1;
1390:
1391: EXCEPTION
1392: WHEN NO_DATA_FOUND THEN
1393: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');
1394: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1395: h_InvalidModel(t_model_id(i)) := 1;
1396: END;
1397: END IF;

Line 1433: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);

1429: CLOSE c_rec;
1430: EXCEPTION
1431: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
1432: CLOSE c_rec;
1433: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1434: x_msg_count := 1;
1435: report(x_msg_data, p_run_id, 'cnd_localized_texts', v_debug);
1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437: RAISE CZRI_ERR_FATAL_ERROR;

Line 1440: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1437: RAISE CZRI_ERR_FATAL_ERROR;
1438: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1439: CLOSE c_rec;
1440: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1441: x_msg_count := 1;
1442: report(x_msg_data, p_run_id, 'cnd_localized_texts', v_debug);
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: RAISE CZRI_ERR_FATAL_ERROR;

Line 1558: t_message(i) := cz_utils.get_text('CZRI_TXT_DUPLICATE', 'MODELID', last_model_id);

1554: last_language = t_language(i))THEN
1555:
1556: --This is a duplicate record in the source data.
1557:
1558: t_message(i) := cz_utils.get_text('CZRI_TXT_DUPLICATE', 'MODELID', last_model_id);
1559: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1560: END IF;
1561:
1562: IF(t_disposition(i) = CZRI_DISPOSITION_PASSED)THEN

Line 1627: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);

1623: CLOSE c_rec;
1624: EXCEPTION
1625: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
1626: CLOSE c_rec;
1627: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1628: x_msg_count := 1;
1629: report(x_msg_data, p_run_id, 'krs_localized_texts', v_debug);
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1631: RAISE CZRI_ERR_FATAL_ERROR;

Line 1634: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1631: RAISE CZRI_ERR_FATAL_ERROR;
1632: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1633: CLOSE c_rec;
1634: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1635: x_msg_count := 1;
1636: report(x_msg_data, p_run_id, 'krs_localized_texts', v_debug);
1637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1638: RAISE CZRI_ERR_FATAL_ERROR;

Line 1858: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1854: t_language(i), t_source_lang(i), t_model_id(i), t_seeded_flag(i));
1855:
1856: EXCEPTION
1857: WHEN OTHERS THEN
1858: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1859: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1860: END;
1861: END IF;
1862:

Line 1902: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1898: AND language = t_language(i);
1899:
1900: EXCEPTION
1901: WHEN OTHERS THEN
1902: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1903: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1904: END;
1905: END IF;
1906:

Line 1931: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);

1927: CLOSE c_rec;
1928: EXCEPTION
1929: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
1930: CLOSE c_rec;
1931: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1932: x_msg_count := 1;
1933: report(x_msg_data, p_run_id, 'xfr_localized_texts', v_debug);
1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: RAISE CZRI_ERR_FATAL_ERROR;

Line 1938: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1935: RAISE CZRI_ERR_FATAL_ERROR;
1936: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1937: CLOSE c_rec;
1938: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1939: x_msg_count := 1;
1940: report(x_msg_data, p_run_id, 'xfr_localized_texts', v_debug);
1941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1942: RAISE CZRI_ERR_FATAL_ERROR;

Line 1968: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

1964:
1965: COMMIT;
1966: EXCEPTION
1967: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1968: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1969: x_msg_count := 1;
1970: report(x_msg_data, p_run_id, 'rpt_localized_texts', v_debug);
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1972: RAISE CZRI_ERR_REPORT_ERROR;

Line 2063: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

2059: WHEN CZRI_ERR_REPORT_ERROR THEN
2060: --All the logging has already been done.
2061: NULL;
2062: WHEN OTHERS THEN
2063: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2064: x_msg_count := 1;
2065: report(x_msg_data, p_run_id, 'refresh_statistics', v_debug);
2066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2067: END;

Line 2218: x_msg_data := cz_utils.get_text('CZRI_IMP_ACTIVESESSION', 'RUNID', p_run_id);

2214: DBMS_APPLICATION_INFO.SET_MODULE('','');
2215:
2216: EXCEPTION
2217: WHEN CZRI_ERR_ACTIVE_SESSIONS THEN
2218: x_msg_data := cz_utils.get_text('CZRI_IMP_ACTIVESESSION', 'RUNID', p_run_id);
2219: x_msg_count := 1;
2220: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2222: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 2224: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);

2220: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2222: DBMS_APPLICATION_INFO.SET_MODULE('','');
2223: WHEN CZRI_ERR_RUNID_EXISTS THEN
2224: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);
2225: x_msg_count := 1;
2226: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2228: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 2230: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);

2226: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2228: DBMS_APPLICATION_INFO.SET_MODULE('','');
2229: WHEN CZRI_ERR_RUNID_INCORRECT THEN
2230: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);
2231: x_msg_count := 1;
2232: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 2236: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);

2232: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2234: DBMS_APPLICATION_INFO.SET_MODULE('','');
2235: WHEN CZRI_ERR_DATA_INCORRECT THEN
2236: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);
2237: x_msg_count := 1;
2238: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: DBMS_APPLICATION_INFO.SET_MODULE('','');

Line 2246: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);

2242: --hard errors occurred in underlying procedures, already logged.
2243: DBMS_APPLICATION_INFO.SET_MODULE('','');
2244: WHEN OTHERS THEN
2245: --unexpected errors occurred in the procedure.
2246: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2247: x_msg_count := 1;
2248: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: DBMS_APPLICATION_INFO.SET_MODULE('','');