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 515: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_MASTER',11276,inRun_ID);

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

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

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

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

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

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

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

Line 556: 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);

552: end if;
553:
554: /* Report Insert Errors */
555: IF (nXfrInsertCount<> INSERTS) THEN
556: 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);
557: END IF;
558:
559: /* Report Update Errors */
560: IF (nXfrUpdateCount<> UPDATES) THEN

Line 561: 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);

557: END IF;
558:
559: /* Report Update Errors */
560: IF (nXfrUpdateCount<> UPDATES) THEN
561: 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);
562: END IF;
563:
564: /* Return the transferred number of rows and not the number of rows with keys resolved*/
565: INSERTS:=nXfrInsertCount;

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

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

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

624:
625: if (CZ_IMP_ALL.get_time) then
626: end_time := dbms_utility.get_time();
627: d_str := inRun_id || ' CND item prop val :' || (end_time-st_time)/100.00;
628: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
629: end if;
630:
631:
632: if (CZ_IMP_ALL.get_time) then

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

637:
638: if (CZ_IMP_ALL.get_time) then
639: end_time := dbms_utility.get_time();
640: d_str := inRun_id || ' KRS item prop val :' || (end_time-st_time)/100.00;
641: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
642: end if;
643:
644: if (CZ_IMP_ALL.get_time) then
645: st_time := dbms_utility.get_time();

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

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

Line 658: 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);

654: end if;
655:
656: /* Report Insert Errors */
657: IF (nXfrInsertCount<> INSERTS) THEN
658: 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 Update Errors */
662: IF (nXfrUpdateCount<> UPDATES) THEN

Line 663: 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);

659: END IF;
660:
661: /* Report Update Errors */
662: IF (nXfrUpdateCount<> UPDATES) THEN
663: 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: /* Return the transferred number of rows and not the number of rows with keys resolved*/
667: INSERTS:=nXfrInsertCount;

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

714: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
715: VALUES(inRUN_ID,SYSDATE,SYSDATE);
716:
717: WHEN OTHERS THEN
718: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE',11276,inRun_ID);
719: END;
720:
721: if (CZ_IMP_ALL.get_time) then
722: st_time := dbms_utility.get_time();

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

724: CZ_IMP_IM_MAIN.CND_ITEM_TYPE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
725: if (CZ_IMP_ALL.get_time) then
726: end_time := dbms_utility.get_time();
727: d_str := inRun_id || ' CND item type :' || (end_time-st_time)/100.00;
728: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
729: end if;
730:
731: if (CZ_IMP_ALL.get_time) then
732: st_time := dbms_utility.get_time();

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

736:
737: if (CZ_IMP_ALL.get_time) then
738: end_time := dbms_utility.get_time();
739: d_str := inRun_id || ' KRS item type :' || (end_time-st_time)/100.00;
740: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
741: end if;
742:
743: if (CZ_IMP_ALL.get_time) then
744: st_time := dbms_utility.get_time();

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

748:
749: if (CZ_IMP_ALL.get_time) then
750: end_time := dbms_utility.get_time();
751: d_str := inRun_id || ' XFR item type :' || (end_time-st_time)/100.00;
752: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
753: end if;
754:
755: /* Report Insert Errors */
756: IF (nXfrInsertCount<> INSERTS) THEN

Line 757: 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);

753: end if;
754:
755: /* Report Insert Errors */
756: IF (nXfrInsertCount<> INSERTS) THEN
757: 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);
758: END IF;
759:
760: /* Report Update Errors */
761: IF (nXfrUpdateCount<> UPDATES) THEN

Line 762: 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);

758: END IF;
759:
760: /* Report Update Errors */
761: IF (nXfrUpdateCount<> UPDATES) THEN
762: 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);
763: END IF;
764:
765: /* Return the transferred number of rows and not the number of rows with keys resolved*/
766: INSERTS:=nXfrInsertCount;

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

813: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
814: VALUES(inRUN_ID,SYSDATE,SYSDATE);
815:
816: WHEN OTHERS THEN
817: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_ITEM_TYPE_PROPERTY',11276,inRun_ID);
818: END;
819:
820: if (CZ_IMP_ALL.get_time) then
821: st_time := dbms_utility.get_time();

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

825:
826: if (CZ_IMP_ALL.get_time) then
827: end_time := dbms_utility.get_time();
828: d_str := inRun_id || ' CND item type prop :' || (end_time-st_time)/100.00;
829: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
830: end if;
831:
832: if (CZ_IMP_ALL.get_time) then
833: st_time := dbms_utility.get_time();

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

837:
838: if (CZ_IMP_ALL.get_time) then
839: end_time := dbms_utility.get_time();
840: d_str := inRun_id || ' KRS item type prop :' || (end_time-st_time)/100.00;
841: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299);
842: end if;
843:
844: if (CZ_IMP_ALL.get_time) then
845: st_time := dbms_utility.get_time();

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

849:
850: if (CZ_IMP_ALL.get_time) then
851: end_time := dbms_utility.get_time();
852: d_str := inRun_id || ' XFR item type prop :' || (end_time-st_time)/100.00;
853: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
854: end if;
855:
856: /* Report Insert Errors */
857: IF (nXfrInsertCount<> INSERTS) THEN

Line 858: 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);

854: end if;
855:
856: /* Report Insert Errors */
857: IF (nXfrInsertCount<> INSERTS) THEN
858: 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);
859: END IF;
860:
861: /* Report Update Errors */
862: IF (nXfrUpdateCount<> UPDATES) THEN

Line 863: 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);

859: END IF;
860:
861: /* Report Update Errors */
862: IF (nXfrUpdateCount<> UPDATES) THEN
863: 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);
864: END IF;
865:
866: /* Return the transferred number of rows and not the number of rows with keys resolved*/
867: INSERTS:=nXfrInsertCount;

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

917: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
918: VALUES(inRUN_ID,SYSDATE,SYSDATE);
919:
920: WHEN OTHERS THEN
921: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.MAIN_PROPERTY',11276,inRun_ID);
922: END;
923:
924: if (CZ_IMP_ALL.get_time) then
925: st_time := dbms_utility.get_time();

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

929:
930: if (CZ_IMP_ALL.get_time) then
931: end_time := dbms_utility.get_time();
932: d_str := inRun_id || ' CND property :' || (end_time-st_time)/100.00;
933: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299);
934: end if;
935:
936: if (CZ_IMP_ALL.get_time) then
937: st_time := dbms_utility.get_time();

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

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

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

953:
954: if (CZ_IMP_ALL.get_time) then
955: end_time := dbms_utility.get_time();
956: d_str := inRun_id || ' XFR property :' || (end_time-st_time)/100.00;
957: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299);
958: end if;
959:
960: /* Report Insert Errors */
961: IF (nXfrInsertCount<> INSERTS) THEN

Line 962: 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);

958: end if;
959:
960: /* Report Insert Errors */
961: IF (nXfrInsertCount<> INSERTS) THEN
962: 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);
963: END IF;
964:
965: /* Report Update Errors */
966: IF (nXfrUpdateCount<> UPDATES) THEN

Line 967: 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);

963: END IF;
964:
965: /* Report Update Errors */
966: IF (nXfrUpdateCount<> UPDATES) THEN
967: 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);
968: END IF;
969:
970: /* Return the transferred number of rows and not the number of rows with keys resolved*/
971: INSERTS:=nXfrInsertCount;

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

1016: COMMIT;
1017:
1018: EXCEPTION
1019: WHEN OTHERS THEN
1020: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);
1021: END;
1022:
1023: DECLARE
1024: nErrors PLS_INTEGER;

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

1036: WHERE RUN_ID=inRUN_ID;
1037: COMMIT;
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);
1041: END;
1042: EXCEPTION
1043: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1044: RAISE;

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

1042: EXCEPTION
1043: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1044: RAISE;
1045: WHEN OTHERS THEN
1046: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_MASTER',11276,inRun_ID);
1047: END;
1048:
1049: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1050:

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

1087: COMMIT;
1088:
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);
1092: END;
1093:
1094: DECLARE
1095: nErrors PLS_INTEGER;

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

1107: WHERE RUN_ID=inRUN_ID;
1108: COMMIT;
1109: EXCEPTION
1110: WHEN OTHERS THEN
1111: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);
1112: END;
1113: EXCEPTION
1114: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1115: RAISE;

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

1113: EXCEPTION
1114: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1115: RAISE;
1116: WHEN OTHERS THEN
1117: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_PROPERTY_VALUE',11276,inRun_ID);
1118: END;
1119: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1120:
1121: PROCEDURE RPT_ITEM_TYPE ( inRUN_ID IN PLS_INTEGER ) AS

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

1157: COMMIT;
1158:
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);
1162: END;
1163:
1164: DECLARE
1165: nErrors PLS_INTEGER;

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

1177: WHERE RUN_ID=inRUN_ID;
1178: COMMIT;
1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);
1182: END;
1183: EXCEPTION
1184: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1185: RAISE;

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

1183: EXCEPTION
1184: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1185: RAISE;
1186: WHEN OTHERS THEN
1187: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE',11276,inRun_ID);
1188: END;
1189:
1190: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1191:

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

1228: COMMIT;
1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);
1233: END;
1234:
1235: DECLARE
1236: nErrors PLS_INTEGER;

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

1248: WHERE RUN_ID=inRUN_ID;
1249: COMMIT;
1250: EXCEPTION
1251: WHEN OTHERS THEN
1252: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);
1253: END;
1254: EXCEPTION
1255: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1256: RAISE;

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

1254: EXCEPTION
1255: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1256: RAISE;
1257: WHEN OTHERS THEN
1258: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_ITEM_TYPE_PROPERTY',11276,inRun_ID);
1259: END;
1260:
1261: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1262: PROCEDURE RPT_PROPERTY ( inRUN_ID IN PLS_INTEGER ) AS

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

1298: COMMIT;
1299:
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);
1303: END;
1304:
1305: DECLARE
1306: nErrors PLS_INTEGER;

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

1318: WHERE RUN_ID=inRUN_ID;
1319: COMMIT;
1320: EXCEPTION
1321: WHEN OTHERS THEN
1322: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);
1323: END;
1324: EXCEPTION
1325: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1326: RAISE;

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

1324: EXCEPTION
1325: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1326: RAISE;
1327: WHEN OTHERS THEN
1328: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IM_MAIN.RPT_PROPERTY',11276,inRun_ID);
1329: END;
1330:
1331: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1332: