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_IMP_IM_MAIN dependencies on CZ_UTILS

Line 37: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_MASTER:MAX',11276,inRun_Id);

33: x_imp_itemmaster_f:=c_imp_itemmaster%FOUND;
34:
35: EXIT WHEN NOT x_imp_itemmaster_f;
36: IF (FAILED >= MAX_ERR) THEN
37: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_MASTER:MAX',11276,inRun_Id);
38: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
39: END IF;
40:
41: IF (p_imp_itemmaster.DELETED_FLAG IS NULL) THEN

Line 54: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);

50: nCommitCount:=0;
51: END IF;
52: EXCEPTION
53: WHEN OTHERS THEN
54: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);
55: FAILED:=FAILED+1;
56: END;
57: END IF;
58:

Line 72: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);

68: nCommitCount:=0;
69: END IF;
70: EXCEPTION
71: WHEN OTHERS THEN
72: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);
73: FAILED:=FAILED+1;
74: END;
75: END IF;
76:

Line 92: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);

88: nCommitCount:=0;
89: END IF;
90: EXCEPTION
91: WHEN OTHERS THEN
92: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);
93: FAILED:=FAILED+1;
94: END;
95: ELSIF (p_imp_itemmaster.SRC_APPLICATION_ID IS NULL) THEN
96: BEGIN

Line 109: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);

105: nCommitCount:=0;
106: END IF;
107: EXCEPTION
108: WHEN OTHERS THEN
109: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);
110: FAILED:=FAILED+1;
111: END;
112: ELSIF (p_imp_itemmaster.SRC_TYPE_CODE IS NULL) THEN
113: BEGIN

Line 126: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);

122: nCommitCount:=0;
123: END IF;
124: EXCEPTION
125: WHEN OTHERS THEN
126: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);
127: FAILED:=FAILED+1;
128: END;
129: END IF;
130:

Line 138: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);

134: EXCEPTION
135: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
136: RAISE;
137: WHEN OTHERS THEN
138: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_MASTER',11276,inRun_ID);
139: END;
140:
141: END CND_ITEM_MASTER ;
142:

Line 212: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,

208:
209: IF iDeletedFlag.COUNT > 0 THEN
210:
211: IF (FAILED >= MAX_ERR) THEN
212: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,
213: 'CZ_IMP_IM_MAIN.CND_ITEM_PROPERTY_VALUE:MAX',11276,inRun_Id);
214: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
215: END IF;
216: FOR i IN iDeletedFlag.FIRST..iDeletedFlag.LAST LOOP

Line 225: xERROR:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_NULL_PROPVAL',

221: IF (iPropertyValue(i) IS NULL AND iPropertyNumValue(i) IS NULL) THEN
222: iDisposition(i) := 'R';
223: iRecStatus(i) := 'FAIL';
224: FAILED := FAILED + 1;
225: xERROR:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_NULL_PROPVAL',
226: 'PROPNAME',iFskProperty(i))||iFskPropertyExt(i),
227: 1,'EXTR_ITEM_PROPERTY_VALUES',11276,inRun_ID);
228: END IF;
229: BEGIN

Line 239: xERROR:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_PROPVAL',

235: WHEN VALUE_ERROR THEN
236: iDisposition(i) := 'R';
237: iRecStatus(i) := 'FAIL';
238: FAILED := FAILED + 1;
239: xERROR:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_PROPVAL',
240: 'PROPNAME',iFskProperty(i)||iFskPropertyExt(i),
241: 'PROPVAL',iPropertyValue(i)),
242: 1,'EXTR_ITEM_PROPERTY_VALUES',11276,inRun_ID);
243: END;

Line 262: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_PROPERTY_VALUE',11276,inRun_ID);

258: EXCEPTION
259: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
260: RAISE;
261: WHEN OTHERS THEN
262: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_PROPERTY_VALUE',11276,inRun_ID);
263: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
264: END CND_ITEM_PROPERTY_VALUE ;
265: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
266:

Line 295: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_TYPE:MAX',11276,inRun_Id);

291: x_imp_itemtype_f:=c_imp_itemtype%FOUND;
292:
293: EXIT WHEN NOT x_imp_itemtype_f;
294: IF (FAILED >= MAX_ERR) THEN
295: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_TYPE:MAX',11276,inRun_Id);
296: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
297: END IF;
298:
299: IF (p_imp_itemtype.DELETED_FLAG IS NULL) THEN

Line 310: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_TYPE',11276,inRun_ID);

306: nCommitCount:=0;
307: END IF;
308: EXCEPTION
309: WHEN OTHERS THEN
310: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_TYPE',11276,inRun_ID);
311: FAILED:=FAILED+1;
312: END;
313: END IF;
314: END LOOP;

Line 321: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_TYPE',11276,inRun_ID);

317: EXCEPTION
318: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
319: RAISE;
320: WHEN OTHERS THEN
321: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_TYPE',11276,inRun_ID);
322: END;
323:
324: END CND_ITEM_TYPE;
325:

Line 358: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY:MAX',11276,inRun_Id);

354: x_imp_itemtypeprop_f:=c_imp_itemtypeprop%FOUND;
355:
356: EXIT WHEN NOT x_imp_itemtypeprop_f;
357: IF (FAILED >= MAX_ERR) THEN
358: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_ITEM_TYPE_PROPERTY:MAX',11276,inRun_Id);
359: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
360: END IF;
361:
362: IF (p_imp_itemtypeprop.DELETED_FLAG IS NULL) THEN

Line 373: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_TYPE_PROPERTY',11276,inRun_ID);

369: nCommitCount:=0;
370: END IF;
371: EXCEPTION
372: WHEN OTHERS THEN
373: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_TYPE_PROPERTY',11276,inRun_ID);
374: FAILED:=FAILED+1;
375: END;
376: END IF;
377: END LOOP;

Line 384: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_TYPE_PROPERTY',11276,inRun_ID);

380: EXCEPTION
381: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
382: RAISE;
383: WHEN OTHERS THEN
384: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_ITEM_TYPE_PROPERTY',11276,inRun_ID);
385: END;
386:
387: END CND_ITEM_TYPE_PROPERTY;
388:

Line 423: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_PROPERTY:MAX',11276,inRun_Id);

419: x_imp_property_f:=c_imp_property%FOUND;
420:
421: EXIT WHEN NOT x_imp_property_f;
422: IF (FAILED >= MAX_ERR) THEN
423: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_MAIN.CND_PROPERTY:MAX',11276,inRun_Id);
424: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
425: END IF;
426:
427: IF (p_imp_property.DELETED_FLAG IS NULL) THEN

Line 438: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_PROPERTY',11276,inRun_ID);

434: nCommitCount:=0;
435: END IF;
436: EXCEPTION
437: WHEN OTHERS THEN
438: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_PROPERTY',11276,inRun_ID);
439: FAILED:=FAILED+1;
440: END;
441: END IF;
442:

Line 456: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_PROPERTY',11276,inRun_ID);

452: nCommitCount:=0;
453: END IF;
454: EXCEPTION
455: WHEN OTHERS THEN
456: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_PROPERTY',11276,inRun_ID);
457: FAILED:=FAILED+1;
458: END;
459: END IF;
460: END LOOP;

Line 467: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_PROPERTY',11276,inRun_ID);

463: EXCEPTION
464: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
465: RAISE;
466: WHEN OTHERS THEN
467: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.CND_PROPERTY',11276,inRun_ID);
468: END;
469:
470: END CND_PROPERTY;
471:

Line 517: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_MASTER',11276,inRun_ID);

513: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
514: VALUES(inRUN_ID,SYSDATE,SYSDATE);
515:
516: WHEN OTHERS THEN
517: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_MASTER',11276,inRun_ID);
518: END;
519:
520: if (CZ_IMP_ALL.get_time) then
521: st_time := dbms_utility.get_time();

Line 529: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);

525:
526: if (CZ_IMP_ALL.get_time) then
527: end_time := dbms_utility.get_time();
528: d_str := inRun_id || ' CND item master :' || (end_time-st_time)/100.00;
529: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
530: end if;
531:
532: if (CZ_IMP_ALL.get_time) then
533: st_time := dbms_utility.get_time();

Line 541: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);

537:
538: if (CZ_IMP_ALL.get_time) then
539: end_time := dbms_utility.get_time();
540: d_str := inRun_id || ' KRS item master :' || (end_time-st_time)/100.00;
541: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
542: end if;
543:
544: if (CZ_IMP_ALL.get_time) then
545: st_time := dbms_utility.get_time();

Line 553: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);

549:
550: if (CZ_IMP_ALL.get_time) then
551: end_time := dbms_utility.get_time();
552: d_str := inRun_id || ' XFR item master :' || (end_time-st_time)/100.00;
553: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
554: end if;
555:
556: /* Report Insert Errors */
557: IF (nXfrInsertCount<> INSERTS) THEN

Line 558: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'IMP_IM.MAIN_ITEM_MASTER ',11276,inRun_ID);

554: end if;
555:
556: /* Report Insert Errors */
557: IF (nXfrInsertCount<> INSERTS) THEN
558: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'IMP_IM.MAIN_ITEM_MASTER ',11276,inRun_ID);
559: END IF;
560:
561: /* Report Update Errors */
562: IF (nXfrUpdateCount<> UPDATES) THEN

Line 563: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'IMP_IM.MAIN_ITEM_MASTER ',11276,inRun_ID);

559: END IF;
560:
561: /* Report Update Errors */
562: IF (nXfrUpdateCount<> UPDATES) THEN
563: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'IMP_IM.MAIN_ITEM_MASTER ',11276,inRun_ID);
564: END IF;
565:
566: /* Return the transferred number of rows and not the number of rows with keys resolved*/
567: INSERTS:=nXfrInsertCount;

Line 621: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);

617: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
618: VALUES(inRUN_ID,SYSDATE,SYSDATE);
619:
620: WHEN OTHERS THEN
621: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);
622: END;
623:
624: if (CZ_IMP_ALL.get_time) then
625: st_time := dbms_utility.get_time();

Line 633: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);

629:
630: if (CZ_IMP_ALL.get_time) then
631: end_time := dbms_utility.get_time();
632: d_str := inRun_id || ' CND item prop val :' || (end_time-st_time)/100.00;
633: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
634: end if;
635:
636:
637: if (CZ_IMP_ALL.get_time) then

Line 646: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);

642:
643: if (CZ_IMP_ALL.get_time) then
644: end_time := dbms_utility.get_time();
645: d_str := inRun_id || ' KRS item prop val :' || (end_time-st_time)/100.00;
646: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
647: end if;
648:
649: if (CZ_IMP_ALL.get_time) then
650: st_time := dbms_utility.get_time();

Line 658: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);

654:
655: if (CZ_IMP_ALL.get_time) then
656: end_time := dbms_utility.get_time();
657: d_str := inRun_id || ' XFR item prop val :' || (end_time-st_time)/100.00;
658: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
659: end if;
660:
661: /* Report Insert Errors */
662: IF (nXfrInsertCount<> INSERTS) THEN

Line 663: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);

659: end if;
660:
661: /* Report Insert Errors */
662: IF (nXfrInsertCount<> INSERTS) THEN
663: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);
664: END IF;
665:
666: /* Report Update Errors */
667: IF (nXfrUpdateCount<> UPDATES) THEN

Line 668: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);

664: END IF;
665:
666: /* Report Update Errors */
667: IF (nXfrUpdateCount<> UPDATES) THEN
668: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_PROPERTY_VALUE',11276,inRun_ID);
669: END IF;
670:
671: /* Return the transferred number of rows and not the number of rows with keys resolved*/
672: INSERTS:=nXfrInsertCount;

Line 725: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);

721: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
722: VALUES(inRUN_ID,SYSDATE,SYSDATE);
723:
724: WHEN OTHERS THEN
725: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);
726: END;
727:
728: if (CZ_IMP_ALL.get_time) then
729: st_time := dbms_utility.get_time();

Line 735: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);

731: CZ_IMP_IM_MAIN.CND_ITEM_TYPE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
732: if (CZ_IMP_ALL.get_time) then
733: end_time := dbms_utility.get_time();
734: d_str := inRun_id || ' CND item type :' || (end_time-st_time)/100.00;
735: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
736: end if;
737:
738: if (CZ_IMP_ALL.get_time) then
739: st_time := dbms_utility.get_time();

Line 747: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);

743:
744: if (CZ_IMP_ALL.get_time) then
745: end_time := dbms_utility.get_time();
746: d_str := inRun_id || ' KRS item type :' || (end_time-st_time)/100.00;
747: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
748: end if;
749:
750: if (CZ_IMP_ALL.get_time) then
751: st_time := dbms_utility.get_time();

Line 759: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);

755:
756: if (CZ_IMP_ALL.get_time) then
757: end_time := dbms_utility.get_time();
758: d_str := inRun_id || ' XFR item type :' || (end_time-st_time)/100.00;
759: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
760: end if;
761:
762: /* Report Insert Errors */
763: IF (nXfrInsertCount<> INSERTS) THEN

Line 764: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);

760: end if;
761:
762: /* Report Insert Errors */
763: IF (nXfrInsertCount<> INSERTS) THEN
764: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);
765: END IF;
766:
767: /* Report Update Errors */
768: IF (nXfrUpdateCount<> UPDATES) THEN

Line 769: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);

765: END IF;
766:
767: /* Report Update Errors */
768: IF (nXfrUpdateCount<> UPDATES) THEN
769: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);
770: END IF;
771:
772: /* Return the transferred number of rows and not the number of rows with keys resolved*/
773: INSERTS:=nXfrInsertCount;

Line 825: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);

821: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
822: VALUES(inRUN_ID,SYSDATE,SYSDATE);
823:
824: WHEN OTHERS THEN
825: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);
826: END;
827:
828: if (CZ_IMP_ALL.get_time) then
829: st_time := dbms_utility.get_time();

Line 837: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);

833:
834: if (CZ_IMP_ALL.get_time) then
835: end_time := dbms_utility.get_time();
836: d_str := inRun_id || ' CND item type prop :' || (end_time-st_time)/100.00;
837: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
838: end if;
839:
840: if (CZ_IMP_ALL.get_time) then
841: st_time := dbms_utility.get_time();

Line 849: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);

845:
846: if (CZ_IMP_ALL.get_time) then
847: end_time := dbms_utility.get_time();
848: d_str := inRun_id || ' KRS item type prop :' || (end_time-st_time)/100.00;
849: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
850: end if;
851:
852: if (CZ_IMP_ALL.get_time) then
853: st_time := dbms_utility.get_time();

Line 861: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);

857:
858: if (CZ_IMP_ALL.get_time) then
859: end_time := dbms_utility.get_time();
860: d_str := inRun_id || ' XFR item type prop :' || (end_time-st_time)/100.00;
861: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
862: end if;
863:
864: /* Report Insert Errors */
865: IF (nXfrInsertCount<> INSERTS) THEN

Line 866: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);

862: end if;
863:
864: /* Report Insert Errors */
865: IF (nXfrInsertCount<> INSERTS) THEN
866: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);
867: END IF;
868:
869: /* Report Update Errors */
870: IF (nXfrUpdateCount<> UPDATES) THEN

Line 871: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);

867: END IF;
868:
869: /* Report Update Errors */
870: IF (nXfrUpdateCount<> UPDATES) THEN
871: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);
872: END IF;
873:
874: /* Return the transferred number of rows and not the number of rows with keys resolved*/
875: INSERTS:=nXfrInsertCount;

Line 931: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);

927: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
928: VALUES(inRUN_ID,SYSDATE,SYSDATE);
929:
930: WHEN OTHERS THEN
931: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);
932: END;
933:
934: if (CZ_IMP_ALL.get_time) then
935: st_time := dbms_utility.get_time();

Line 943: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);

939:
940: if (CZ_IMP_ALL.get_time) then
941: end_time := dbms_utility.get_time();
942: d_str := inRun_id || ' CND property :' || (end_time-st_time)/100.00;
943: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
944: end if;
945:
946: if (CZ_IMP_ALL.get_time) then
947: st_time := dbms_utility.get_time();

Line 955: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);

951:
952: if (CZ_IMP_ALL.get_time) then
953: end_time := dbms_utility.get_time();
954: d_str := inRun_id || ' KRS property :' || (end_time-st_time)/100.00;
955: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
956: end if;
957:
958: if (CZ_IMP_ALL.get_time) then
959: st_time := dbms_utility.get_time();

Line 967: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);

963:
964: if (CZ_IMP_ALL.get_time) then
965: end_time := dbms_utility.get_time();
966: d_str := inRun_id || ' XFR property :' || (end_time-st_time)/100.00;
967: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
968: end if;
969:
970: /* Report Insert Errors */
971: IF (nXfrInsertCount<> INSERTS) THEN

Line 972: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);

968: end if;
969:
970: /* Report Insert Errors */
971: IF (nXfrInsertCount<> INSERTS) THEN
972: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);
973: END IF;
974:
975: /* Report Update Errors */
976: IF (nXfrUpdateCount<> UPDATES) THEN

Line 977: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);

973: END IF;
974:
975: /* Report Update Errors */
976: IF (nXfrUpdateCount<> UPDATES) THEN
977: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);
978: END IF;
979:
980: /* Return the transferred number of rows and not the number of rows with keys resolved*/
981: INSERTS:=nXfrInsertCount;

Line 1031: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);

1027: COMMIT;
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);
1032: END;
1033:
1034: DECLARE
1035: nErrors PLS_INTEGER;

Line 1051: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);

1047: WHERE RUN_ID=inRUN_ID;
1048: COMMIT;
1049: EXCEPTION
1050: WHEN OTHERS THEN
1051: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);
1052: END;
1053: EXCEPTION
1054: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1055: RAISE;

Line 1057: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);

1053: EXCEPTION
1054: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1055: RAISE;
1056: WHEN OTHERS THEN
1057: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);
1058: END;
1059:
1060: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1061:

Line 1102: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);

1098: COMMIT;
1099:
1100: EXCEPTION
1101: WHEN OTHERS THEN
1102: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);
1103: END;
1104:
1105: DECLARE
1106: nErrors PLS_INTEGER;

Line 1122: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);

1118: WHERE RUN_ID=inRUN_ID;
1119: COMMIT;
1120: EXCEPTION
1121: WHEN OTHERS THEN
1122: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);
1123: END;
1124: EXCEPTION
1125: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1126: RAISE;

Line 1128: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);

1124: EXCEPTION
1125: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1126: RAISE;
1127: WHEN OTHERS THEN
1128: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);
1129: END;
1130: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1131:
1132: PROCEDURE RPT_ITEM_TYPE ( inRUN_ID IN PLS_INTEGER ) AS

Line 1172: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);

1168: COMMIT;
1169:
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);
1173: END;
1174:
1175: DECLARE
1176: nErrors PLS_INTEGER;

Line 1192: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);

1188: WHERE RUN_ID=inRUN_ID;
1189: COMMIT;
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);
1193: END;
1194: EXCEPTION
1195: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1196: RAISE;

Line 1198: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);

1194: EXCEPTION
1195: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1196: RAISE;
1197: WHEN OTHERS THEN
1198: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);
1199: END;
1200:
1201: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1202:

Line 1243: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);

1239: COMMIT;
1240:
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);
1244: END;
1245:
1246: DECLARE
1247: nErrors PLS_INTEGER;

Line 1263: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);

1259: WHERE RUN_ID=inRUN_ID;
1260: COMMIT;
1261: EXCEPTION
1262: WHEN OTHERS THEN
1263: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);
1264: END;
1265: EXCEPTION
1266: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1267: RAISE;

Line 1269: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);

1265: EXCEPTION
1266: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1267: RAISE;
1268: WHEN OTHERS THEN
1269: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);
1270: END;
1271:
1272: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1273: PROCEDURE RPT_PROPERTY ( inRUN_ID IN PLS_INTEGER ) AS

Line 1313: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);

1309: COMMIT;
1310:
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);
1314: END;
1315:
1316: DECLARE
1317: nErrors PLS_INTEGER;

Line 1333: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);

1329: WHERE RUN_ID=inRUN_ID;
1330: COMMIT;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);
1334: END;
1335: EXCEPTION
1336: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1337: RAISE;

Line 1339: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);

1335: EXCEPTION
1336: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1337: RAISE;
1338: WHEN OTHERS THEN
1339: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);
1340: END;
1341:
1342: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1343: