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

Line 1: PACKAGE BODY CZ_IMP_ALL AS

1: PACKAGE BODY CZ_IMP_ALL AS
2: /* $Header: cziallb.pls 120.6.12020000.2 2012/08/17 14:51:40 smanna ship $ */
3: ------------------------------------------------------------------------------------------
4: FUNCTION isTracingEnabled RETURN BOOLEAN IS
5: nEnableTrace VARCHAR2(1) := '0';

Line 52: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);

48: EXCEPTION
49: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
50: retcode:=2;
51: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
52: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
53: RAISE;
54: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
55: retcode:=2;
56: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 57: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);

53: RAISE;
54: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
55: retcode:=2;
56: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
57: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
58: RAISE;
59: WHEN OTHERS THEN
60: retcode:=2;
61: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);

Line 62: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);

58: RAISE;
59: WHEN OTHERS THEN
60: retcode:=2;
61: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
62: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go_cp',11276,NULL);
63: RAISE;
64: END go_cp;
65:
66: ------------------------------------------------------------------------------------------

Line 103: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);

99: EXCEPTION
100: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
101: retcode:=2;
102: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
103: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
104: RAISE;
105: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
106: retcode:=2;
107: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 108: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);

104: RAISE;
105: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
106: retcode:=2;
107: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
108: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
109: RAISE;
110: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
111: RAISE;
112: WHEN OTHERS THEN

Line 115: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);

111: RAISE;
112: WHEN OTHERS THEN
113: retcode:=2;
114: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
115: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.goSingleBill_cp',11276,NULL);
116: RAISE;
117: END goSingleBill_cp;
118: ------------------------------------------------------------------------------------------
119: PROCEDURE go(errbuf IN OUT NOCOPY VARCHAR2,retcode IN OUT NOCOPY NUMBER) IS

Line 153: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);

149: EXCEPTION
150: WHEN TOO_MANY_ROWS THEN
151: retcode:=2;
152: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
153: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);
154: RAISE;
155: WHEN NO_DATA_FOUND THEN
156: retcode:=2;
157: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 158: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);

154: RAISE;
155: WHEN NO_DATA_FOUND THEN
156: retcode:=2;
157: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
158: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.go',11276,NULL);
159: RAISE;
160: END;
161:
162: SELECT organization_id, top_item_id, explosion_type, NVL(copy_addl_child_models, '0'), model_ps_node_id

Line 172: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);

168:
169: IF(orgId.COUNT = 0)THEN
170: retcode:=2;
171: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_IMPORTED_MODELS');
172: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);
173: RETURN;
174: END IF;
175:
176: FOR i IN orgId.FIRST .. orgId.LAST

Line 189: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);

185: RAISE;
186: WHEN OTHERS THEN
187: retcode:=2;
188: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
189: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.GO',11276,NULL);
190: RAISE;
191: END go;
192: ------------------------------------------------------------------------------------------
193: PROCEDURE go_generic(outRun_ID IN OUT NOCOPY PLS_INTEGER,

Line 376: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.GO_GENERIC',11276,NULL);

372: DBMS_APPLICATION_INFO.SET_MODULE('','');
373: RAISE;
374: WHEN OTHERS THEN
375: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
376: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.GO_GENERIC',11276,NULL);
377: DBMS_APPLICATION_INFO.SET_MODULE('','');
378: RAISE;
379: END go_generic;
380: ------------------------------------------------------------------------------------------

Line 459: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);

455: CZ_IMP_AC_MAIN.MAIN_USER_GROUP(inRun_ID, commit_size, max_err,
456: Inserts, Updates, x_failed, Dups, inXFR_GROUP);
457: ELSE
458: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name));
459: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_INVALID_TABLE_IMPORT','TABLENAME',table_name),1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);
460: END IF;
461: --DBMS_OUTPUT.PUT_LINE('INSERTS: '||to_char(Inserts));
462: --DBMS_OUTPUT.PUT_LINE('UPDATES: '||to_char(Updates));
463: --DBMS_OUTPUT.PUT_LINE('FAILED: '||to_char(x_failed));

Line 470: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);

466: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
467: RAISE;
468: WHEN OTHERS THEN
469: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
470: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.POPULATE_TABLE',11276,inRun_ID);
471: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
472: END populate_table;
473: ------------------------------------------------------------------------------------------
474: PROCEDURE import_before_start IS

Line 505: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_BEFORE_START',11276);

501: BEGIN
502: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=sOrigSysRef WHERE CURRENT OF C_SET_ID;
503: EXCEPTION
504: WHEN OTHERS THEN
505: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_BEFORE_START',11276);
506: END;
507: END IF;
508:
509: END LOOP;

Line 587: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);

583: price_list_id=nPriceListId;
584: end if;
585: exception
586: when others then
587: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);
588: end;
589: close c_pricegroup;
590: end loop;
591: close c_listcontrol;

Line 645: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);

641: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL
642: WHERE CURRENT OF C_GET_HOST;
643: EXCEPTION
644: WHEN OTHERS THEN
645: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);
646: END;
647: ELSE
648: BEGIN
649: nAllocateCounter:=nAllocateCounter+1;

Line 674: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);

670: UPDATE CZ_PRICE_GROUPS SET ORIG_SYS_REF=NULL
671: WHERE CURRENT OF C_GET_HOST;
672: EXCEPTION
673: WHEN OTHERS THEN
674: xERROR:=cz_utils.log_report(SQLERRM,1,'CZ_IMP_ALL.IMPORT_AFTER_COMPLETE',11276,inRUN_ID);
675: END;
676: END IF;
677:
678: END LOOP;

Line 719: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.goSingleBill',11276,NULL);

715: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
716: RAISE;
717: WHEN OTHERS THEN
718: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
719: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.goSingleBill',11276,NULL);
720: RAISE;
721: END goSingleBill;
722: ------------------------------------------------------------------------------------------
723: PROCEDURE AddBillToImport(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,nOrg_ID IN NUMBER,nTop_ID IN NUMBER,

Line 741: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);

737: EXCEPTION
738: WHEN TOO_MANY_ROWS THEN
739: retcode:=2;
740: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
741: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
742: RAISE;
743: WHEN NO_DATA_FOUND THEN
744: retcode:=2;
745: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 746: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);

742: RAISE;
743: WHEN NO_DATA_FOUND THEN
744: retcode:=2;
745: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
746: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
747: RAISE;
748: END;
749:
750: insert into cz_xfr_project_bills (top_item_id,organization_id,deleted_flag,explosion_type,model_ps_node_id,

Line 764: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);

760: EXCEPTION
761: WHEN OTHERS THEN
762: retcode:=2;
763: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
764: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.ADDBILLTOIMPORT',11276,NULL);
765: RAISE;
766: END;
767: ------------------------------------------------------------------------------------------
768: PROCEDURE SetSingleBillState(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,nOrg_ID IN NUMBER,nTop_ID IN NUMBER,sState IN VARCHAR2) IS

Line 785: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);

781: EXCEPTION
782: WHEN TOO_MANY_ROWS THEN
783: retcode:=2;
784: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
785: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
786: RAISE;
787: WHEN NO_DATA_FOUND THEN
788: retcode:=2;
789: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 790: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);

786: RAISE;
787: WHEN NO_DATA_FOUND THEN
788: retcode:=2;
789: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
790: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
791: RAISE;
792: END;
793:
794: update cz_xfr_project_bills set

Line 804: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);

800: EXCEPTION
801: WHEN OTHERS THEN
802: retcode:=2;
803: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
804: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.SETSINGLEBILLSTATE',11276,NULL);
805: END;
806: ------------------------------------------------------------------------------------------
807: PROCEDURE RemoveModel(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,sOrg_ID IN VARCHAR2,
808: dsOrg_ID IN VARCHAR2,sTop_ID IN VARCHAR2) IS

Line 828: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);

824: EXCEPTION
825: WHEN TOO_MANY_ROWS THEN
826: retcode:=2;
827: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_TOO_MANY_SERVERS');
828: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
829: RAISE;
830: WHEN NO_DATA_FOUND THEN
831: retcode:=2;
832: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');

Line 833: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);

829: RAISE;
830: WHEN NO_DATA_FOUND THEN
831: retcode:=2;
832: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_NO_SERVERS');
833: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
834: RAISE;
835: END;
836:
837: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS

Line 857: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);

853: EXCEPTION
854: WHEN OTHERS THEN
855: retcode:=2;
856: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
857: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.RemoveModel',11276,NULL);
858: END;
859: ------------------------------------------------------------------------------------------
860: PROCEDURE PopulateModels_cp(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,
861: sOrg_ID IN VARCHAR2,dsOrg_ID IN VARCHAR2,

Line 915: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);

911: RAISE;
912: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
913: retcode:=2;
914: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
915: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
916: RAISE;
917: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
918: retcode:=2;
919: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 920: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);

916: RAISE;
917: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
918: retcode:=2;
919: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
920: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
921: RAISE;
922: WHEN OTHERS THEN
923: retcode:=2;
924: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 925: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);

921: RAISE;
922: WHEN OTHERS THEN
923: retcode:=2;
924: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
925: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateModels_cp',11276,NULL);
926: RAISE;
927: END;
928: ------------------------------------------------------------------------------------------
929:

Line 986: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);

982: RAISE;
983: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
984: retcode:=2;
985: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS');
986: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
987: RAISE;
988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
989: retcode:=2;
990: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');

Line 991: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);

987: RAISE;
988: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
989: retcode:=2;
990: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED');
991: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
992: RAISE;
993: WHEN OTHERS THEN
994: retcode:=2;
995: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

Line 996: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);

992: RAISE;
993: WHEN OTHERS THEN
994: retcode:=2;
995: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
996: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.PopulateSingleModel_cp',11276,NULL);
997: RAISE;
998: END;
999: ------------------------------------------------------------------------------------------
1000:

Line 1059: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);

1055: AND ASSEMBLY_ITEM_ID = nTop_ID);
1056: IF ((commonOrgId <> nOrg_ID) or (commonInvId <> nTop_ID)) THEN
1057: retcode := 1;
1058: errbuf := CZ_UTILS.get_text('CZ_HAS_COMMON_BILL','ORGID',nOrg_ID,'INVID',nTop_ID,'C_ORGID',commonOrgId,'C_INVID',commonInvId);
1059: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1060: END IF;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: retcode := 2;

Line 1065: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);

1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: retcode := 2;
1064: errbuf := CZ_UTILS.get_text('CZ_IMP_BOM_NO_DATA');
1065: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1066: WHEN OTHERS THEN
1067: retcode := 2;
1068: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;
1069: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);

Line 1068: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;

1064: errbuf := CZ_UTILS.get_text('CZ_IMP_BOM_NO_DATA');
1065: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1066: WHEN OTHERS THEN
1067: retcode := 2;
1068: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;
1069: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);
1070: RAISE;
1071: END check_for_common_bill;
1072:

Line 1069: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);

1065: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:CZ_COMMON_BILL_CHECK',11276,NULL);
1066: WHEN OTHERS THEN
1067: retcode := 2;
1068: errbuf := 'CZ_IMP_ALL:COMMON_BILL_CHECK' || SQLERRM;
1069: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL:COMMON_BILL_CHECK',11276,NULL);
1070: RAISE;
1071: END check_for_common_bill;
1072:
1073: ------------------------------------------------------------------------------------------

Line 1110: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.generic_import',11276,NULL);

1106: EXCEPTION
1107: WHEN OTHERS THEN
1108: retcode:=2;
1109: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1110: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.generic_import',11276,NULL);
1111: END go_generic_cp;
1112: ------------------------------------------------------------------------------------------
1113: END CZ_IMP_ALL;

Line 1113: END CZ_IMP_ALL;

1109: errbuf:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
1110: xERROR:=cz_utils.log_report(errbuf,1,'CZ_IMP_ALL.generic_import',11276,NULL);
1111: END go_generic_cp;
1112: ------------------------------------------------------------------------------------------
1113: END CZ_IMP_ALL;