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_AC_MAIN dependencies on CZ_IMP_ALL

Line 47: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CONTACT',11276);

43: nCommitCount:=0;
44: END IF;
45: EXCEPTION
46: WHEN OTHERS THEN
47: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CONTACT',11276);
48: nFailed:=nFailed+1;
49: END;
50: END IF;
51: END LOOP;

Line 57: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CONTACT',11276);

53: FAILED:=nFailed;
54:
55: EXCEPTION
56: WHEN OTHERS THEN
57: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CONTACT',11276);
58: END;
59:
60: END CND_CONTACT;
61:

Line 108: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CUSTOMER',11276);

104: nCommitCount:=0;
105: END IF;
106: EXCEPTION
107: WHEN OTHERS THEN
108: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CUSTOMER',11276);
109: nFailed:=nFailed+1;
110: END;
111: END IF;
112: END LOOP;

Line 118: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CUSTOMER',11276);

114: FAILED:=nFailed;
115:
116: EXCEPTION
117: WHEN OTHERS THEN
118: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CUSTOMER',11276);
119: END;
120:
121: END CND_CUSTOMER;
122:

Line 165: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_ADDRESS',11276);

161: nCommitCount:=0;
162: END IF;
163: EXCEPTION
164: WHEN OTHERS THEN
165: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_ADDRESS',11276);
166: nFailed:=nFailed+1;
167: END;
168: END IF;
169: END LOOP;

Line 175: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_ADDRESS',11276);

171: FAILED:=nFailed;
172:
173: EXCEPTION
174: WHEN OTHERS THEN
175: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_ADDRESS',11276);
176: END;
177:
178: END CND_ADDRESS;
179:

Line 225: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_ADDRESS_USES',11276);

221: END IF;
222:
223: EXCEPTION
224: WHEN OTHERS THEN
225: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_ADDRESS_USES',11276);
226: nFailed:=nFailed+1;
227: END;
228: END IF;
229: END LOOP;

Line 235: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_ADDRESS_USES',11276);

231: FAILED:=nFailed;
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_ADDRESS_USES',11276);
236: END;
237: END CND_ADDRESS_USES;
238:
239: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 281: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CUSTOMER_END_USER',11276);

277: nCommitCount:=0;
278: END IF;
279: EXCEPTION
280: WHEN OTHERS THEN
281: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CUSTOMER_END_USER',11276);
282: nFailed:=nFailed+1;
283: END;
284: END IF;
285: END LOOP;

Line 291: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CUSTOMER',11276);

287: FAILED:=nFailed;
288:
289: EXCEPTION
290: WHEN OTHERS THEN
291: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_CUSTOMER',11276);
292: END;
293:
294: END CND_CUSTOMER_END_USER;
295:

Line 338: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_END_USER',11276);

334: nCommitCount:=0;
335: END IF;
336: EXCEPTION
337: WHEN OTHERS THEN
338: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_END_USER',11276);
339: nFailed:=nFailed+1;
340: END;
341: END IF;
342: END LOOP;

Line 348: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_END_USER',11276);

344: FAILED:=nFailed;
345:
346: EXCEPTION
347: WHEN OTHERS THEN
348: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_END_USER',11276);
349:
350: END;
351:
352: END CND_END_USER;

Line 396: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_END_USER_GROUP',11276);

392: nCommitCount:=0;
393: END IF;
394: EXCEPTION
395: WHEN OTHERS THEN
396: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_END_USER_GROUP',11276);
397: nFailed:=nFailed+1;
398: END;
399: END IF;
400: END LOOP;

Line 406: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_END_USER_GROUP',11276);

402: FAILED:=nFailed;
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_END_USER_GROUP',11276);
407: END;
408:
409: END CND_END_USER_GROUP;
410:

Line 455: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_USER_GROUP',11276);

451: nCommitCount:=0;
452: END IF;
453: EXCEPTION
454: WHEN OTHERS THEN
455: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_USER_GROUP',11276);
456: nFailed:=nFailed+1;
457: END;
458: END IF;
459: END LOOP;

Line 465: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_USER_GROUP',11276);

461: FAILED:=nFailed;
462:
463: EXCEPTION
464: WHEN OTHERS THEN
465: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.CND_USER_GROUP',11276);
466: END;
467:
468: END CND_USER_GROUP;
469:

Line 512: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CONTACT',11276);

508: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
509: VALUES(inRUN_ID,SYSDATE,SYSDATE);
510:
511: WHEN OTHERS THEN
512: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CONTACT',11276);
513: END;
514:
515: CZ_IMP_AC_MAIN.CND_CONTACT (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
516: IF (nFailed=MAX_ERR) THEN

Line 531: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_CONTACT',11276);

527: IF(nFailed < MAX_ERR) THEN
528: CZ_IMP_AC_XFR.XFR_CONTACT (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
529: /* Report Insert Errors */
530: IF (nXfrInsertCount<> INSERTS) THEN
531: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_CONTACT',11276);
532: END IF;
533:
534: /* Report Update Errors */
535: IF (nXfrUpdateCount<> UPDATES) THEN

Line 536: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_CONTACT',11276);

532: END IF;
533:
534: /* Report Update Errors */
535: IF (nXfrUpdateCount<> UPDATES) THEN
536: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_CONTACT',11276);
537: END IF;
538:
539: /* Return the transferred number of rows and not the number of rows with keys resolved*/
540: INSERTS:=nXfrInsertCount;

Line 590: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CUSTOMER',11276);

586: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
587: VALUES(inRUN_ID,SYSDATE,SYSDATE);
588:
589: WHEN OTHERS THEN
590: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CUSTOMER',11276);
591: END;
592:
593: CZ_IMP_AC_MAIN.CND_CUSTOMER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
594: IF (nFailed=MAX_ERR) THEN

Line 607: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);

603: IF(nFailed < MAX_ERR) THEN
604: CZ_IMP_AC_XFR.XFR_CUSTOMER (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
605: /* Report Insert Errors */
606: IF (nXfrInsertCount<> INSERTS) THEN
607: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);
608: END IF;
609: /* Report Update Errors */
610: IF (nXfrUpdateCount<> UPDATES) THEN
611: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);

Line 611: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);

607: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);
608: END IF;
609: /* Report Update Errors */
610: IF (nXfrUpdateCount<> UPDATES) THEN
611: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER ',11276);
612: END IF;
613: /* Return the transferred number of rows and not the number of rows with keys resolved*/
614: INSERTS:=nXfrInsertCount;
615: UPDATES:=nXfrUpdateCount;

Line 663: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_ADDRESS',11276);

659: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
660: VALUES(inRUN_ID,SYSDATE,SYSDATE);
661:
662: WHEN OTHERS THEN
663: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_ADDRESS',11276);
664: END;
665:
666: CZ_IMP_AC_MAIN.CND_ADDRESS (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
667: IF (nFailed=MAX_ERR) THEN

Line 680: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);

676: IF(nFailed < MAX_ERR) THEN
677: CZ_IMP_AC_XFR.XFR_ADDRESS (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
678: /* Report Insert Errors */
679: IF (nXfrInsertCount<> INSERTS) THEN
680: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);
681: END IF;
682: /* Report Update Errors */
683: IF (nXfrUpdateCount<> UPDATES) THEN
684: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);

Line 684: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);

680: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);
681: END IF;
682: /* Report Update Errors */
683: IF (nXfrUpdateCount<> UPDATES) THEN
684: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS ',11276);
685: END IF;
686: /* Return the transferred number of rows and not the number of rows with keys resolved*/
687: INSERTS:=nXfrInsertCount;
688: UPDATES:=nXfrUpdateCount;

Line 736: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_ADDRESS_USES',11276);

732: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
733: VALUES(inRUN_ID,SYSDATE,SYSDATE);
734:
735: WHEN OTHERS THEN
736: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_ADDRESS_USES',11276);
737: END;
738:
739: CZ_IMP_AC_MAIN.CND_ADDRESS_USES(inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
740: IF(nFailed=MAX_ERR) THEN

Line 753: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);

749: IF(nFailed < MAX_ERR) THEN
750: CZ_IMP_AC_XFR.XFR_ADDRESS_USES(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
751: /* Report Insert Errors */
752: IF(nXfrInsertCount<> INSERTS) THEN
753: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);
754: END IF;
755: /* Report Update Errors */
756: IF(nXfrUpdateCount<> UPDATES) THEN
757: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);

Line 757: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);

753: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);
754: END IF;
755: /* Report Update Errors */
756: IF(nXfrUpdateCount<> UPDATES) THEN
757: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_ADDRESS_USES ',11276);
758: END IF;
759: /* Return the transferred number of rows and not the number of rows with keys resolved */
760: INSERTS:=nXfrInsertCount;
761: UPDATES:=nXfrUpdateCount;

Line 809: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CUSTOMER_END_USER',11276);

805: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
806: VALUES(inRUN_ID,SYSDATE,SYSDATE);
807:
808: WHEN OTHERS THEN
809: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_CUSTOMER_END_USER',11276);
810: END;
811:
812: CZ_IMP_AC_MAIN.CND_CUSTOMER_END_USER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
813: IF (nFailed=MAX_ERR) THEN

Line 826: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);

822: IF(nFailed < MAX_ERR) THEN
823: CZ_IMP_AC_XFR.XFR_CUSTOMER_END_USER (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
824: /* Report Insert Errors */
825: IF (nXfrInsertCount<> INSERTS) THEN
826: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);
827: END IF;
828: /* Report Update Errors */
829: IF (nXfrUpdateCount<> UPDATES) THEN
830: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);

Line 830: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);

826: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);
827: END IF;
828: /* Report Update Errors */
829: IF (nXfrUpdateCount<> UPDATES) THEN
830: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_AC.MAIN_CUSTOMER_END_USER ',11276);
831: END IF;
832: /* Return the transferred number of rows and not the number of rows with keys resolved*/
833: INSERTS:=nXfrInsertCount;
834: UPDATES:=nXfrUpdateCount;

Line 884: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_END_USER',11276);

880: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
881: VALUES(inRUN_ID,SYSDATE,SYSDATE);
882:
883: WHEN OTHERS THEN
884: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_END_USER',11276);
885: END;
886:
887: CZ_IMP_AC_MAIN.CND_END_USER (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
888: IF (nFailed=MAX_ERR) THEN

Line 903: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_END_USER ',11276);

899: IF(nFailed < MAX_ERR) THEN
900: CZ_IMP_AC_XFR.XFR_END_USER(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
901: /* Report Insert Errors */
902: IF (nXfrInsertCount<> INSERTS) THEN
903: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_END_USER ',11276);
904: END IF;
905:
906: /* Report Update Errors */
907: IF (nXfrUpdateCount<> UPDATES) THEN

Line 908: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_END_USER ',11276);

904: END IF;
905:
906: /* Report Update Errors */
907: IF (nXfrUpdateCount<> UPDATES) THEN
908: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_END_USER ',11276);
909: END IF;
910:
911: /* Return the transferred number of rows and not the number of rows with keys resolved*/
912: INSERTS:=nXfrInsertCount;

Line 962: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_END_USER_GROUP',11276);

958: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
959: VALUES(inRUN_ID,SYSDATE,SYSDATE);
960:
961: WHEN OTHERS THEN
962: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_END_USER_GROUP',11276);
963: END;
964:
965: CZ_IMP_AC_MAIN.CND_END_USER_GROUP (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
966: IF (nFailed=MAX_ERR) THEN

Line 981: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_END_USER_GROUP ',11276);

977: IF(nFailed < MAX_ERR) THEN
978: CZ_IMP_AC_XFR.XFR_END_USER_GROUP(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
979: /* Report Insert Errors */
980: IF (nXfrInsertCount<> INSERTS) THEN
981: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_END_USER_GROUP ',11276);
982: END IF;
983:
984: /* Report Update Errors */
985: IF (nXfrUpdateCount<> UPDATES) THEN

Line 986: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_END_USER_GROUP ',11276);

982: END IF;
983:
984: /* Report Update Errors */
985: IF (nXfrUpdateCount<> UPDATES) THEN
986: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_END_USER_GROUP ',11276);
987: END IF;
988:
989: /* Return the transferred number of rows and not the number of rows with keys resolved*/
990: INSERTS:=nXfrInsertCount;

Line 1042: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_USER_GROUP',11276);

1038: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
1039: VALUES(inRUN_ID,SYSDATE,SYSDATE);
1040:
1041: WHEN OTHERS THEN
1042: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.MAIN_USER_GROUP',11276);
1043: END;
1044:
1045: CZ_IMP_AC_MAIN.CND_USER_GROUP(inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
1046: IF (nFailed=MAX_ERR) THEN

Line 1061: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_USER_GROUP',11276);

1057: IF(nFailed < MAX_ERR) THEN
1058: CZ_IMP_AC_XFR.XFR_USER_GROUP (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
1059: /* Report Insert Errors */
1060: IF (nXfrInsertCount<> INSERTS) THEN
1061: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_AC.MAIN_USER_GROUP',11276);
1062: END IF;
1063:
1064: /* Report Update Errors */
1065: IF (nXfrUpdateCount<> UPDATES) THEN

Line 1066: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_USER_GROUP ',11276);

1062: END IF;
1063:
1064: /* Report Update Errors */
1065: IF (nXfrUpdateCount<> UPDATES) THEN
1066: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_AC.MAIN_USER_GROUP ',11276);
1067: END IF;
1068:
1069: /* Return the transferred number of rows and not the number of rows with keys resolved*/
1070: INSERTS:=nXfrInsertCount;

Line 1119: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CONTACT',11276);

1115: COMMIT;
1116:
1117: EXCEPTION
1118: WHEN OTHERS THEN
1119: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CONTACT',11276);
1120: END;
1121:
1122: DECLARE
1123: nErrors PLS_INTEGER;

Line 1139: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CONTACT',11276);

1135: WHERE RUN_ID=inRUN_ID;
1136: COMMIT;
1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CONTACT',11276);
1140: END;
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CONTACT',11276);

Line 1143: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CONTACT',11276);

1139: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CONTACT',11276);
1140: END;
1141: EXCEPTION
1142: WHEN OTHERS THEN
1143: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CONTACT',11276);
1144: END;
1145:
1146: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1147: PROCEDURE RPT_CUSTOMER ( inRUN_ID IN PLS_INTEGER ) AS

Line 1184: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER',11276);

1180: COMMIT;
1181:
1182: EXCEPTION
1183: WHEN OTHERS THEN
1184: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER',11276);
1185: END;
1186:
1187: DECLARE
1188: nErrors PLS_INTEGER;

Line 1204: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER',11276);

1200: WHERE RUN_ID=inRUN_ID;
1201: COMMIT;
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER',11276);
1205: END;
1206: EXCEPTION
1207: WHEN OTHERS THEN
1208: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER',11276);

Line 1208: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER',11276);

1204: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER',11276);
1205: END;
1206: EXCEPTION
1207: WHEN OTHERS THEN
1208: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER',11276);
1209: END;
1210:
1211: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1212: PROCEDURE RPT_ADDRESS ( inRUN_ID IN PLS_INTEGER ) AS

Line 1249: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS',11276);

1245: COMMIT;
1246:
1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS',11276);
1250: END;
1251:
1252: DECLARE
1253: nErrors PLS_INTEGER;

Line 1269: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS',11276);

1265: WHERE RUN_ID=inRUN_ID;
1266: COMMIT;
1267: EXCEPTION
1268: WHEN OTHERS THEN
1269: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS',11276);
1270: END;
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS',11276);

Line 1273: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS',11276);

1269: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS',11276);
1270: END;
1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS',11276);
1274: END;
1275: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1276: PROCEDURE RPT_ADDRESS_USES ( inRUN_ID IN PLS_INTEGER ) AS
1277: x_error BOOLEAN:=FALSE;

Line 1313: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS_USES',11276);

1309: COMMIT;
1310:
1311: EXCEPTION
1312: WHEN OTHERS THEN
1313: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS_USES',11276);
1314: END;
1315:
1316: DECLARE
1317: nErrors PLS_INTEGER;

Line 1333: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS_USES',11276);

1329: WHERE RUN_ID=inRUN_ID;
1330: COMMIT;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS_USES',11276);
1334: END;
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS_USES',11276);

Line 1337: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS_USES',11276);

1333: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS_USES',11276);
1334: END;
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_ADDRESS_USES',11276);
1338: END;
1339:
1340: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1341: PROCEDURE RPT_CUSTOMER_END_USER ( inRUN_ID IN PLS_INTEGER ) AS

Line 1378: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER_END_USER',11276);

1374: COMMIT;
1375:
1376: EXCEPTION
1377: WHEN OTHERS THEN
1378: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER_END_USER',11276);
1379: END;
1380:
1381: DECLARE
1382: nErrors PLS_INTEGER;

Line 1398: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER_END_USER',11276);

1394: WHERE RUN_ID=inRUN_ID;
1395: COMMIT;
1396: EXCEPTION
1397: WHEN OTHERS THEN
1398: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER_END_USER',11276);
1399: END;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER_END_USER',11276);

Line 1402: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER_END_USER',11276);

1398: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER_END_USER',11276);
1399: END;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_CUSTOMER_END_USER',11276);
1403: END;
1404:
1405: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1406: PROCEDURE RPT_END_USER ( inRUN_ID IN PLS_INTEGER ) AS

Line 1443: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER',11276);

1439: COMMIT;
1440:
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER',11276);
1444: END;
1445:
1446: DECLARE
1447: nErrors PLS_INTEGER;

Line 1463: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER',11276);

1459: WHERE RUN_ID=inRUN_ID;
1460: COMMIT;
1461: EXCEPTION
1462: WHEN OTHERS THEN
1463: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER',11276);
1464: END;
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER',11276);

Line 1467: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER',11276);

1463: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER',11276);
1464: END;
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER',11276);
1468: END;
1469:
1470: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1471: PROCEDURE RPT_END_USER_GROUP ( inRUN_ID IN PLS_INTEGER ) AS

Line 1508: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER_GROUP',11276);

1504: COMMIT;
1505:
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER_GROUP',11276);
1509: END;
1510:
1511: DECLARE
1512: nErrors PLS_INTEGER;

Line 1528: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER_GROUP',11276);

1524: WHERE RUN_ID=inRUN_ID;
1525: COMMIT;
1526: EXCEPTION
1527: WHEN OTHERS THEN
1528: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER_GROUP',11276);
1529: END;
1530: EXCEPTION
1531: WHEN OTHERS THEN
1532: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER_GROUP',11276);

Line 1532: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER_GROUP',11276);

1528: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER_GROUP',11276);
1529: END;
1530: EXCEPTION
1531: WHEN OTHERS THEN
1532: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_END_USER_GROUP',11276);
1533: END;
1534:
1535: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1536: PROCEDURE RPT_USER_GROUP ( inRUN_ID IN PLS_INTEGER ) AS

Line 1573: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);

1569: COMMIT;
1570:
1571: EXCEPTION
1572: WHEN OTHERS THEN
1573: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);
1574: END;
1575:
1576: DECLARE
1577: nErrors PLS_INTEGER;

Line 1593: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);

1589: WHERE RUN_ID=inRUN_ID;
1590: COMMIT;
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);
1594: END;
1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);

Line 1597: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);

1593: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);
1594: END;
1595: EXCEPTION
1596: WHEN OTHERS THEN
1597: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_AC.RPT_USER_GROUP',11276);
1598: END;
1599: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1600:
1601: END CZ_IMP_AC_MAIN;