DBA Data[Home] [Help]

APPS.CZ_IMP_AC_MAIN dependencies on CZ_UTILS

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 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 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 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 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 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 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 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;