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 194: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLMODELID');

190: t_disposition(i) := CZRI_DISPOSITION_REJECT;
191:
192: IF(t_devl_project_id(i) IS NULL)THEN
193:
194: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLMODELID');
195:
196: ELSIF(h_InvalidModel.EXISTS(t_devl_project_id(i)))THEN
197:
198: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');

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

194: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLMODELID');
195:
196: ELSIF(h_InvalidModel.EXISTS(t_devl_project_id(i)))THEN
197:
198: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');
199:
200: ELSIF(h_NoRootFolder.EXISTS(t_devl_project_id(i)))THEN
201:
202: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');

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

198: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');
199:
200: ELSIF(h_NoRootFolder.EXISTS(t_devl_project_id(i)))THEN
201:
202: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');
203:
204: ELSIF(t_rule_folder_id(i) IS NOT NULL AND h_NoSuchFolder.EXISTS(t_rule_folder_id(i)))THEN
205:
206: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');

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

202: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');
203:
204: ELSIF(t_rule_folder_id(i) IS NOT NULL AND h_NoSuchFolder.EXISTS(t_rule_folder_id(i)))THEN
205:
206: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');
207:
208: ELSIF(t_orig_sys_ref(i) IS NULL)THEN
209:
210: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLORIGSYSREF');

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

206: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');
207:
208: ELSIF(t_orig_sys_ref(i) IS NULL)THEN
209:
210: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLORIGSYSREF');
211:
212: ELSIF(t_rule_type(i) IS NULL)THEN
213:
214: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLTYPE');

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

210: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLORIGSYSREF');
211:
212: ELSIF(t_rule_type(i) IS NULL)THEN
213:
214: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLTYPE');
215:
216: ELSIF(t_rule_type(i) NOT IN (CZRI_TYPE_EXPRESSION_RULE, CZRI_TYPE_COMPANION_RULE))THEN
217:
218: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDTYPE');

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

214: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLTYPE');
215:
216: ELSIF(t_rule_type(i) NOT IN (CZRI_TYPE_EXPRESSION_RULE, CZRI_TYPE_COMPANION_RULE))THEN
217:
218: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDTYPE');
219:
220: -- For the Phase I we do not implement resolution of component_id, model_ref_expl_id values for
221: -- CX rules using surrogate keys. Instead, we require direct population of the columns.
222: --

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

221: -- CX rules using surrogate keys. Instead, we require direct population of the columns.
222: --
223: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_fsk_component_id(i) IS NULL)THEN
224: --
225: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLCOMPONENTID');
226: --
227: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_fsk_model_ref_expl_id(i) IS NULL)THEN
228: --
229: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');

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

225: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLCOMPONENTID');
226: --
227: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_fsk_model_ref_expl_id(i) IS NULL)THEN
228: --
229: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');
230:
231: -- If component_id is NULL, it will be populated automatically with the ps_node_id of the root
232: -- model node.
233: --

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

232: -- model node.
233: --
234: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_component_id(i) IS NULL)THEN
235: --
236: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLCOMPONENTID');
237:
238: -- If model_ref_expl_id is NULL, it will be populated automatically with the model_ref_expl_id
239: -- of the root model node.
240: --

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

239: -- of the root model node.
240: --
241: -- ELSIF(t_rule_type(i) = CZRI_TYPE_COMPANION_RULE AND t_model_ref_expl_id(i) IS NULL)THEN
242: --
243: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');
244:
245: ELSIF(t_name(i) IS NULL)THEN
246:
247: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLNAME');

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

243: -- t_message(i) := cz_utils.get_text('CZRI_RLE_NULLEXPLID');
244:
245: ELSIF(t_name(i) IS NULL)THEN
246:
247: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLNAME');
248:
249: ELSIF(t_presentation_flag(i) IS NOT NULL AND t_presentation_flag(i) <> CZRI_FLAG_STATEMENT_RULE)THEN
250:
251: t_message(i) := cz_utils.get_text('CZRI_RLE_PRESENTFLAG');

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

247: t_message(i) := cz_utils.get_text('CZRI_RLE_NULLNAME');
248:
249: ELSIF(t_presentation_flag(i) IS NOT NULL AND t_presentation_flag(i) <> CZRI_FLAG_STATEMENT_RULE)THEN
250:
251: t_message(i) := cz_utils.get_text('CZRI_RLE_PRESENTFLAG');
252:
253: ELSE
254:
255: t_disposition(i) := CZRI_DISPOSITION_PASSED;

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

263: h_ValidModel(t_devl_project_id(i)) := v_root_expl_id;
264:
265: EXCEPTION
266: WHEN NO_DATA_FOUND THEN
267: t_message(i) := cz_utils.get_text('CZRI_RLE_INVALIDMODEL');
268: t_disposition(i) := CZRI_DISPOSITION_REJECT;
269: h_InvalidModel(t_devl_project_id(i)) := 1;
270: END;
271: END IF;

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

285: h_RootFolder(t_devl_project_id(i)) := v_root_folder_id;
286:
287: EXCEPTION
288: WHEN NO_DATA_FOUND THEN
289: t_message(i) := cz_utils.get_text('CZRI_RLE_NOROOTFOLDER');
290: t_disposition(i) := CZRI_DISPOSITION_REJECT;
291: h_NoRootFolder(t_devl_project_id(i)) := 1;
292: END;
293: END IF;

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

300: h_ValidFolder(t_rule_folder_id(i)) := v_root_folder_id;
301:
302: EXCEPTION
303: WHEN NO_DATA_FOUND THEN
304: t_message(i) := cz_utils.get_text('CZRI_RLE_NOSUCHFOLDER');
305: t_disposition(i) := CZRI_DISPOSITION_REJECT;
306: h_NoSuchFolder(t_rule_folder_id(i)) := 1;
307: END;
308: END IF;

Line 315: t_message(i) := cz_utils.get_text('CZRI_RLE_DUPNAME','DEVL_PROJ_ID',t_devl_project_id(i),'RULE_FOLDER_ID',t_rule_folder_id(i),'RULE_NAME',t_name(i)); --Bug8580853

311: --Check for Duplicate names of rules Bug8580853
312: IF(t_disposition(i) = CZRI_DISPOSITION_PASSED)THEN
313: v_check_dup_name := t_devl_project_id(i) || '-' || t_rule_folder_id(i) ||'-' || t_name(i); --Bug8580853
314: IF(h_NameRootFolder.EXISTS(v_check_dup_name))THEN --Bug8580853
315: t_message(i) := cz_utils.get_text('CZRI_RLE_DUPNAME','DEVL_PROJ_ID',t_devl_project_id(i),'RULE_FOLDER_ID',t_rule_folder_id(i),'RULE_NAME',t_name(i)); --Bug8580853
316: t_disposition(i) := CZRI_DISPOSITION_REJECT;
317: FND_FILE.PUT_LINE(FND_FILE.LOG, t_message(i));
318: ELSE
319: h_NameRootFolder(v_check_dup_name):=1;

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

366: CLOSE c_rec;
367: EXCEPTION
368: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
369: CLOSE c_rec;
370: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
371: x_msg_count := 1;
372: report(x_msg_data, p_run_id, 'cnd_rules', v_debug);
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: RAISE CZRI_ERR_FATAL_ERROR;

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

373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: RAISE CZRI_ERR_FATAL_ERROR;
375: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
376: CLOSE c_rec;
377: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
378: x_msg_count := 1;
379: report(x_msg_data, p_run_id, 'cnd_rules', v_debug);
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381: RAISE CZRI_ERR_FATAL_ERROR;

Line 558: t_message(i) := cz_utils.get_text('CZRI_CONFIG_ENGINE_INCORRECT');

554: CLOSE c_get_engine_type;
555: END IF;
556:
557: IF (t_config_engine_type(i) NOT IN ('F', 'L')) THEN
558: t_message(i) := cz_utils.get_text('CZRI_CONFIG_ENGINE_INCORRECT');
559: t_disposition(i) := CZRI_DISPOSITION_REJECT;
560:
561: ELSIF((t_config_engine_type(i)= 'L') AND ((t_rule_class(i) IS NOT NULL) OR (t_class_seq(i) IS NOT NULL))) THEN
562: t_message(i) := cz_utils.get_text('CZRI_ENGTYP_RULCLSSSEQ_INVALD');

Line 562: t_message(i) := cz_utils.get_text('CZRI_ENGTYP_RULCLSSSEQ_INVALD');

558: t_message(i) := cz_utils.get_text('CZRI_CONFIG_ENGINE_INCORRECT');
559: t_disposition(i) := CZRI_DISPOSITION_REJECT;
560:
561: ELSIF((t_config_engine_type(i)= 'L') AND ((t_rule_class(i) IS NOT NULL) OR (t_class_seq(i) IS NOT NULL))) THEN
562: t_message(i) := cz_utils.get_text('CZRI_ENGTYP_RULCLSSSEQ_INVALD');
563: t_disposition(i) := CZRI_DISPOSITION_REJECT;
564:
565: ELSIF (t_config_engine_type(i)='F' AND t_rule_class(i) IS NULL) THEN
566: t_message(i) := cz_utils.get_text('CZRI_RULE_CLASS_INCORRECT');

Line 566: t_message(i) := cz_utils.get_text('CZRI_RULE_CLASS_INCORRECT');

562: t_message(i) := cz_utils.get_text('CZRI_ENGTYP_RULCLSSSEQ_INVALD');
563: t_disposition(i) := CZRI_DISPOSITION_REJECT;
564:
565: ELSIF (t_config_engine_type(i)='F' AND t_rule_class(i) IS NULL) THEN
566: t_message(i) := cz_utils.get_text('CZRI_RULE_CLASS_INCORRECT');
567: t_disposition(i) := CZRI_DISPOSITION_REJECT;
568:
569: ELSIF (t_config_engine_type(i)='F' AND t_rule_class(i) IS NULL AND t_class_seq(i) IS NOT NULL) THEN
570: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT');

Line 570: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT');

566: t_message(i) := cz_utils.get_text('CZRI_RULE_CLASS_INCORRECT');
567: t_disposition(i) := CZRI_DISPOSITION_REJECT;
568:
569: ELSIF (t_config_engine_type(i)='F' AND t_rule_class(i) IS NULL AND t_class_seq(i) IS NOT NULL) THEN
570: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT');
571: t_disposition(i) := CZRI_DISPOSITION_REJECT;
572: END IF;
573:
574:

Line 586: t_message(i) := cz_utils.get_text('CZRI_RULE_CLASS_INCORRECT');

582: FROM cz_rule_class_lkv
583: WHERE cz_rule_class_lkv.data_value=t_rule_class(i);
584: EXCEPTION
585: WHEN NO_DATA_FOUND THEN
586: t_message(i) := cz_utils.get_text('CZRI_RULE_CLASS_INCORRECT');
587: t_disposition(i) := CZRI_DISPOSITION_REJECT;
588: END;
589:
590:

Line 593: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT');

589:
590:
591: IF((t_data_value='1')OR (t_data_value='2')) THEN
592: IF(t_class_seq(i) IS NULL) THEN
593: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT');
594: t_disposition(i) := CZRI_DISPOSITION_REJECT;
595: ELSE
596: BEGIN
597: SELECT class_seq

Line 606: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT');

602: AND class_seq = t_class_seq(i)
603: AND deleted_flag = CZRI_FLAG_NOT_DELETED;
604:
605: IF(v_rule_class_chk IS NOT NULL) then
606: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT');
607: t_disposition(i) := CZRI_DISPOSITION_REJECT;
608: END IF;
609:
610: EXCEPTION

Line 615: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));

611: WHEN NO_DATA_FOUND THEN
612: -- Valid Case, No record found with same model id, rule class and class sequence. do nothing.
613: null;
614: WHEN TOO_MANY_ROWS THEN
615: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));
616: t_disposition(i) := CZRI_DISPOSITION_REJECT;
617: END;
618: END IF;
619:

Line 621: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));

617: END;
618: END IF;
619:
620: ELSIF(t_data_value='0' AND t_class_seq(i) IS NOT NULL ) THEN
621: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));
622: t_disposition(i) := CZRI_DISPOSITION_REJECT;
623: END IF;
624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN

Line 626: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));

622: t_disposition(i) := CZRI_DISPOSITION_REJECT;
623: END IF;
624: EXCEPTION
625: WHEN NO_DATA_FOUND THEN
626: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));
627: t_disposition(i) := CZRI_DISPOSITION_REJECT;
628:
629: WHEN TOO_MANY_ROWS THEN
630: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));

Line 630: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));

626: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));
627: t_disposition(i) := CZRI_DISPOSITION_REJECT;
628:
629: WHEN TOO_MANY_ROWS THEN
630: t_message(i) := cz_utils.get_text('CZRI_CLASS_SEQ_INCORRECT', 'MODELID', t_devl_project_id(i));
631: t_disposition(i) := CZRI_DISPOSITION_REJECT;
632:
633: END;
634: END IF;

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

638: last_project_id = t_devl_project_id(i))THEN
639:
640: --This is a duplicate record in the source data.
641:
642: t_message(i) := cz_utils.get_text('CZRI_RLE_DUPLICATE', 'MODELID', last_project_id);
643: t_disposition(i) := CZRI_DISPOSITION_REJECT;
644: END IF;
645:
646: IF(t_disposition(i) = CZRI_DISPOSITION_PASSED)THEN

Line 678: t_message(i) := cz_utils.get_text('CZRI_DUPL_RULE_IN_FOLDER','DEVL_PROJ_ID',t_devl_project_id(i),'RULE_FOLDER_ID',t_rule_folder_id(i),'RULE_NAME',t_name(i)); --Bug8580853

674: END;
675: -- Raise an error if similar rule name already exists in the project under a rule folder
676: IF(v_error_flag = 1)THEN
677: t_disposition(i) := CZRI_DISPOSITION_REJECT;
678: t_message(i) := cz_utils.get_text('CZRI_DUPL_RULE_IN_FOLDER','DEVL_PROJ_ID',t_devl_project_id(i),'RULE_FOLDER_ID',t_rule_folder_id(i),'RULE_NAME',t_name(i)); --Bug8580853
679: FND_FILE.PUT_LINE(FND_FILE.LOG, t_message(i));
680: END IF;
681: --Resolve unsatisfied_msg_id. --Bug9068095
682:

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

700: v_translations := l_intl_text_id.COUNT;
701:
702: ELSIF(v_translations <> l_intl_text_id.COUNT)THEN
703:
704: t_message(i) := cz_utils.get_text('CZRI_RLE_TRANSLATIONS', 'ACTUAL', l_intl_text_id.COUNT, 'EXPECTED', v_translations);
705: t_disposition(i) := CZRI_DISPOSITION_REJECT;
706: END IF;
707: ELSE
708: t_message(i) := cz_utils.get_text('CZRI_RLE_NOUNSATISFIED');

Line 708: t_message(i) := cz_utils.get_text('CZRI_RLE_NOUNSATISFIED');

704: t_message(i) := cz_utils.get_text('CZRI_RLE_TRANSLATIONS', 'ACTUAL', l_intl_text_id.COUNT, 'EXPECTED', v_translations);
705: t_disposition(i) := CZRI_DISPOSITION_REJECT;
706: END IF;
707: ELSE
708: t_message(i) := cz_utils.get_text('CZRI_RLE_NOUNSATISFIED');
709: t_disposition(i) := CZRI_DISPOSITION_REJECT;
710: END IF;
711: END IF;
712:

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

734: v_translations := t_intl_text_id.COUNT;
735:
736: ELSIF(v_translations <> t_intl_text_id.COUNT)THEN
737:
738: t_message(i) := cz_utils.get_text('CZRI_RLE_TRANSLATIONS', 'ACTUAL', t_intl_text_id.COUNT, 'EXPECTED', v_translations);
739: t_disposition(i) := CZRI_DISPOSITION_REJECT;
740: END IF;
741: ELSE
742:

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

739: t_disposition(i) := CZRI_DISPOSITION_REJECT;
740: END IF;
741: ELSE
742:
743: t_message(i) := cz_utils.get_text('CZRI_RLE_NOREASONID');
744: t_disposition(i) := CZRI_DISPOSITION_REJECT;
745: END IF;
746: END IF;
747: END IF;

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

789: CLOSE c_rec;
790: EXCEPTION
791: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
792: CLOSE c_rec;
793: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
794: x_msg_count := 1;
795: report(x_msg_data, p_run_id, 'krs_rules', v_debug);
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: RAISE CZRI_ERR_FATAL_ERROR;

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

796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: RAISE CZRI_ERR_FATAL_ERROR;
798: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
799: CLOSE c_rec;
800: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
801: x_msg_count := 1;
802: report(x_msg_data, p_run_id, 'krs_rules', v_debug);
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: RAISE CZRI_ERR_FATAL_ERROR;

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

1362: t_effectivity_set_id(i));
1363:
1364: EXCEPTION
1365: WHEN OTHERS THEN
1366: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1367: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1368: ROLLBACK TO insert_rule_record;
1369: END;
1370: END IF;

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

1461: AND object_type = CZRI_FOLDER_TYPE_RULE;
1462:
1463: EXCEPTION
1464: WHEN OTHERS THEN
1465: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1466: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1467: ROLLBACK TO update_rule_record;
1468: END;
1469: END IF;

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

1512: EXCEPTION
1513: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
1514: CLOSE c_rec;
1515: CLOSE c_rec_nochange;
1516: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1517: x_msg_count := 1;
1518: report(x_msg_data, p_run_id, 'xfr_rules', v_debug);
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: RAISE CZRI_ERR_FATAL_ERROR;

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

1520: RAISE CZRI_ERR_FATAL_ERROR;
1521: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1522: CLOSE c_rec;
1523: CLOSE c_rec_nochange;
1524: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1525: x_msg_count := 1;
1526: report(x_msg_data, p_run_id, 'xfr_rules', v_debug);
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1528: RAISE CZRI_ERR_FATAL_ERROR;

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

1549:
1550: COMMIT;
1551: EXCEPTION
1552: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1553: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1554: x_msg_count := 1;
1555: report(x_msg_data, p_run_id, 'rpt_rules', v_debug);
1556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1557: RAISE CZRI_ERR_REPORT_ERROR;

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

1714: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1715:
1716: IF(t_model_id(i) IS NULL)THEN
1717:
1718: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLMODELID');
1719:
1720: ELSIF(h_InvalidModel.EXISTS(t_model_id(i)))THEN
1721:
1722: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');

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

1718: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLMODELID');
1719:
1720: ELSIF(h_InvalidModel.EXISTS(t_model_id(i)))THEN
1721:
1722: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');
1723:
1724: ELSIF(t_orig_sys_ref(i) IS NULL)THEN
1725:
1726: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLORIGSYSREF');

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

1722: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');
1723:
1724: ELSIF(t_orig_sys_ref(i) IS NULL)THEN
1725:
1726: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLORIGSYSREF');
1727:
1728: ELSIF(t_language(i) IS NULL)THEN
1729:
1730: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLLANGUAGE');

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

1726: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLORIGSYSREF');
1727:
1728: ELSIF(t_language(i) IS NULL)THEN
1729:
1730: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLLANGUAGE');
1731:
1732: ELSIF(t_source_lang(i) IS NULL)THEN
1733:
1734: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLSOURCELANG');

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

1730: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLLANGUAGE');
1731:
1732: ELSIF(t_source_lang(i) IS NULL)THEN
1733:
1734: t_message(i) := cz_utils.get_text('CZRI_TXT_NULLSOURCELANG');
1735:
1736: ELSE
1737:
1738: t_disposition(i) := CZRI_DISPOSITION_PASSED;

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

1745: h_ValidModel(t_model_id(i)) := 1;
1746:
1747: EXCEPTION
1748: WHEN NO_DATA_FOUND THEN
1749: t_message(i) := cz_utils.get_text('CZRI_TXT_INVALIDMODEL');
1750: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1751: h_InvalidModel(t_model_id(i)) := 1;
1752: END;
1753: END IF;

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

1785: CLOSE c_rec;
1786: EXCEPTION
1787: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
1788: CLOSE c_rec;
1789: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
1790: x_msg_count := 1;
1791: report(x_msg_data, p_run_id, 'cnd_localized_texts', v_debug);
1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1793: RAISE CZRI_ERR_FATAL_ERROR;

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

1792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1793: RAISE CZRI_ERR_FATAL_ERROR;
1794: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
1795: CLOSE c_rec;
1796: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
1797: x_msg_count := 1;
1798: report(x_msg_data, p_run_id, 'cnd_localized_texts', v_debug);
1799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1800: RAISE CZRI_ERR_FATAL_ERROR;

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

1927: last_language = t_language(i))THEN
1928:
1929: --This is a duplicate record in the source data.
1930:
1931: t_message(i) := cz_utils.get_text('CZRI_TXT_DUPLICATE', 'MODELID', last_model_id);
1932: t_disposition(i) := CZRI_DISPOSITION_REJECT;
1933: END IF;
1934:
1935: IF(t_disposition(i) = CZRI_DISPOSITION_PASSED)THEN

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

2006: CLOSE c_rec;
2007: EXCEPTION
2008: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
2009: CLOSE c_rec;
2010: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
2011: x_msg_count := 1;
2012: report(x_msg_data, p_run_id, 'krs_localized_texts', v_debug);
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: RAISE CZRI_ERR_FATAL_ERROR;

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

2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: RAISE CZRI_ERR_FATAL_ERROR;
2015: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
2016: CLOSE c_rec;
2017: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2018: x_msg_count := 1;
2019: report(x_msg_data, p_run_id, 'krs_localized_texts', v_debug);
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021: RAISE CZRI_ERR_FATAL_ERROR;

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

2254: t_language(i), t_source_lang(i), t_model_id(i), t_seeded_flag(i));
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2259: t_disposition(i) := CZRI_DISPOSITION_REJECT;
2260: END;
2261: END IF;
2262:

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

2298: AND language = t_language(i);
2299:
2300: EXCEPTION
2301: WHEN OTHERS THEN
2302: t_message(i) := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2303: t_disposition(i) := CZRI_DISPOSITION_REJECT;
2304: END;
2305: END IF;
2306:

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

2346: EXCEPTION
2347: WHEN CZRI_ERR_MAXIMUM_ERRORS THEN --maximum errors number exceeded.
2348: CLOSE c_rec;
2349: CLOSE c_rec_nochange;
2350: x_msg_data := cz_utils.get_text('CZRI_IMP_MAXIMUMERRORS', 'RUNID', p_run_id);
2351: x_msg_count := 1;
2352: report(x_msg_data, p_run_id, 'xfr_localized_texts', v_debug);
2353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2354: RAISE CZRI_ERR_FATAL_ERROR;

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

2354: RAISE CZRI_ERR_FATAL_ERROR;
2355: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
2356: CLOSE c_rec;
2357: CLOSE c_rec_nochange;
2358: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2359: x_msg_count := 1;
2360: report(x_msg_data, p_run_id, 'xfr_localized_texts', v_debug);
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2362: RAISE CZRI_ERR_FATAL_ERROR;

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

2384:
2385: COMMIT;
2386: EXCEPTION
2387: WHEN OTHERS THEN --unexpected errors occurred in the procedure.
2388: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2389: x_msg_count := 1;
2390: report(x_msg_data, p_run_id, 'rpt_localized_texts', v_debug);
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2392: RAISE CZRI_ERR_REPORT_ERROR;

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

2479: WHEN CZRI_ERR_REPORT_ERROR THEN
2480: --All the logging has already been done.
2481: NULL;
2482: WHEN OTHERS THEN
2483: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2484: x_msg_count := 1;
2485: report(x_msg_data, p_run_id, 'refresh_statistics', v_debug);
2486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2487: END;

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

2634: DBMS_APPLICATION_INFO.SET_MODULE('','');
2635:
2636: EXCEPTION
2637: WHEN CZRI_ERR_ACTIVE_SESSIONS THEN
2638: x_msg_data := cz_utils.get_text('CZRI_IMP_ACTIVESESSION', 'RUNID', p_run_id);
2639: x_msg_count := 1;
2640: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2642: DBMS_APPLICATION_INFO.SET_MODULE('','');

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

2640: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2642: DBMS_APPLICATION_INFO.SET_MODULE('','');
2643: WHEN CZRI_ERR_RUNID_EXISTS THEN
2644: x_msg_data := cz_utils.get_text('CZRI_IMP_RUNID_EXISTS', 'RUNID', p_run_id);
2645: x_msg_count := 1;
2646: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: DBMS_APPLICATION_INFO.SET_MODULE('','');

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

2646: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: DBMS_APPLICATION_INFO.SET_MODULE('','');
2649: WHEN CZRI_ERR_RUNID_INCORRECT THEN
2650: x_msg_data := cz_utils.get_text('CZRI_ERR_RUNID_INCORRECT', 'RUNID', p_run_id);
2651: x_msg_count := 1;
2652: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2654: DBMS_APPLICATION_INFO.SET_MODULE('','');

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

2652: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2654: DBMS_APPLICATION_INFO.SET_MODULE('','');
2655: WHEN CZRI_ERR_DATA_INCORRECT THEN
2656: x_msg_data := cz_utils.get_text('CZRI_ERR_DATA_INCORRECT', 'RUNID', p_run_id);
2657: x_msg_count := 1;
2658: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660: DBMS_APPLICATION_INFO.SET_MODULE('','');

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

2662: --hard errors occurred in underlying procedures, already logged.
2663: DBMS_APPLICATION_INFO.SET_MODULE('','');
2664: WHEN OTHERS THEN
2665: --unexpected errors occurred in the procedure.
2666: x_msg_data := cz_utils.get_text('CZRI_IMP_SQLERROR', 'ERRORTEXT', SQLERRM);
2667: x_msg_count := 1;
2668: report(x_msg_data, p_run_id, 'rule_import', v_debug);
2669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2670: DBMS_APPLICATION_INFO.SET_MODULE('','');