DBA Data[Home] [Help]

APPS.CZ_IMP_IM_KRS dependencies on CZ_IMP_IM_KRS

Line 1: PACKAGE BODY CZ_IMP_IM_KRS AS

1: PACKAGE BODY CZ_IMP_IM_KRS AS
2: /* $Header: cziimkrb.pls 120.6.12020000.2 2012/08/17 14:54:13 smanna ship $ */
3:
4:
5: PROCEDURE KRS_ITEM_MASTER(inRUN_ID IN PLS_INTEGER,

Line 256: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_KRS.KRS_ITEM_MASTER:MAX',11276,inRun_Id);

252:
253:
254: /* Return if MAX_ERR is reached */
255: IF (FAILED >= MAX_ERR) THEN
256: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_KRS.KRS_ITEM_MASTER:MAX',11276,inRun_Id);
257: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
258: END IF;
259:
260: sDisposition:=NULL; sRecStatus:=NULL;dispositionflag:=0;

Line 275: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_MASTER',11276,inRun_ID);

271: EXCEPTION
272: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
273: RAISE;
274: WHEN OTHERS THEN
275: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_MASTER',11276,inRun_ID);
276: END;
277: END KRS_ITEM_MASTER;
278: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
279: PROCEDURE KRS_ITEM_PROPERTY_VALUE ( inRUN_ID IN PLS_INTEGER,

Line 581: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_IM_KRS.KRS_ITEM_PROPERTY_VALUE',11276,inRun_ID);

577: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
578: RAISE;
579: WHEN OTHERS THEN
580: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
581: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_IM_KRS.KRS_ITEM_PROPERTY_VALUE',11276,inRun_ID);
582: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
583: END KRS_ITEM_PROPERTY_VALUE ;
584: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
585: PROCEDURE KRS_ITEM_TYPE ( inRUN_ID IN PLS_INTEGER,

Line 746: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE:MAX',11276,inRun_Id);

742:
743:
744:
745: IF (FAILED >= MAX_ERR) THEN
746: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE:MAX',11276,inRun_Id);
747: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
748: END IF;
749: sDisposition:=NULL; sRecStatus:=NULL;dispositionflag:=0;
750: END LOOP;

Line 761: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE',11276,inRun_ID);

757: EXCEPTION
758: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
759: RAISE;
760: WHEN OTHERS THEN
761: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE',11276,inRun_ID);
762: END;
763: END KRS_ITEM_TYPE;
764: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
765: PROCEDURE KRS_ITEM_TYPE_PROPERTY ( inRUN_ID IN PLS_INTEGER,

Line 925: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE_PROPERTY:MAX',11276,inRun_Id);

921: sLastFSK2:=sFSKPROPERTY;
922:
923: /* Return if MAX_ERR is reached */
924: IF (FAILED >= MAX_ERR) THEN
925: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE_PROPERTY:MAX',11276,inRun_Id);
926: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
927: END IF;
928: sDisposition:=NULL; sRecStatus:=NULL;
929: END LOOP;

Line 969: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE_PROPERTY',11276,inRun_ID);

965: EXCEPTION
966: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
967: RAISE;
968: WHEN OTHERS THEN
969: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE_PROPERTY',11276,inRun_ID);
970: END;
971: END KRS_ITEM_TYPE_PROPERTY ;
972: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
973: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 1140: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName),1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_Id);

1136: IF( x_onl_property_propertyname_f)THEN
1137: sRecStatus:='DUPL';
1138: sDisposition:='R';
1139: nDups:=nDups+1;
1140: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName),1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_Id);
1141: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));
1142: ELSE
1143: /*Insert */
1144: sDisposition:='I';

Line 1172: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_KRS.KRS_PROPERTY:MAX',11276,inRun_Id);

1168:
1169:
1170:
1171: IF (FAILED >= MAX_ERR) THEN
1172: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_IM_KRS.KRS_PROPERTY:MAX',11276,inRun_Id);
1173: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1174: COMMIT;
1175: END IF;
1176: END LOOP;

Line 1185: x_error:=CZ_UTILS.LOG_REPORT('raised max_err',1,'CZ_IMP_IM_KRS.KRS_PROPERTY:MAX',11276,inRun_Id);

1181: DUPS:=nDups;
1182: NOCHANGE:=nNoChangeCount;
1183: EXCEPTION
1184: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1185: x_error:=CZ_UTILS.LOG_REPORT('raised max_err',1,'CZ_IMP_IM_KRS.KRS_PROPERTY:MAX',11276,inRun_Id);
1186: RAISE;
1187: WHEN OTHERS THEN
1188: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_ID);
1189: END;

Line 1188: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_ID);

1184: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1185: x_error:=CZ_UTILS.LOG_REPORT('raised max_err',1,'CZ_IMP_IM_KRS.KRS_PROPERTY:MAX',11276,inRun_Id);
1186: RAISE;
1187: WHEN OTHERS THEN
1188: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_ID);
1189: END;
1190: END KRS_PROPERTY ;
1191: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1192: END CZ_IMP_IM_KRS;

Line 1192: END CZ_IMP_IM_KRS;

1188: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_ID);
1189: END;
1190: END KRS_PROPERTY ;
1191: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1192: END CZ_IMP_IM_KRS;