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_KRS dependencies on CZ_UTILS

Line 62: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);

58: nInsertCount PLS_INTEGER:=0; /*Inserts */
59: nUpdateCount PLS_INTEGER:=0; /*Updates */
60: nDups PLS_INTEGER:=0; /*Dupl records */
61:
62: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
63: nAllocateBlock PLS_INTEGER:=1;
64: nAllocateCounter PLS_INTEGER;
65: nNextValue NUMBER;
66:

Line 90: ELSIF CZ_UTILS.ISNUM(sDfltItemTypeId)=TRUE THEN

86: OPEN C_ITEM_TYPE_ID;
87: FETCH C_ITEM_TYPE_ID INTO sDfltItemTypeId;
88: IF(C_ITEM_TYPE_ID%NOTFOUND)THEN
89: nOnlItemTypeId:=0;
90: ELSIF CZ_UTILS.ISNUM(sDfltItemTypeId)=TRUE THEN
91: nOnlItemTypeId:=TO_NUMBER(sDfltItemTypeId);
92: ELSE
93: nOnlItemTypeId:=0;
94: END IF;

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

205: sLastFSK:=sImpOrigSysRef;
206:
207: /* Return if MAX_ERR is reached */
208: IF (FAILED >= MAX_ERR) THEN
209: 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);
210: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
211: END IF;
212:
213: sDisposition:=NULL; sRecStatus:=NULL;

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

222: EXCEPTION
223: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
224: RAISE;
225: WHEN OTHERS THEN
226: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_MASTER',11276,inRun_ID);
227: END;
228: END KRS_ITEM_MASTER;
229: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
230: PROCEDURE KRS_ITEM_PROPERTY_VALUE ( inRUN_ID IN PLS_INTEGER,

Line 256: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);

252: iOrigSysRef tOrigSysRef;
253: iItemId tItemId;
254: iPropertyId tPropertyId;
255:
256: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);
257: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
258: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
259:
260: -- passing records

Line 257: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);

253: iItemId tItemId;
254: iPropertyId tPropertyId;
255:
256: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);
257: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
258: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
259:
260: -- passing records
261: CURSOR C1 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS

Line 258: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);

254: iPropertyId tPropertyId;
255:
256: x_usesurr_itempropertyvalue PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_PROPERTY_VALUES',inXFR_GROUP);
257: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
258: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
259:
260: -- passing records
261: CURSOR C1 (x_usersurr_itemmaster PLS_INTEGER, x_usesurr_property PLS_INTEGER) IS
262: SELECT a.fsk_itemmaster_2_1,a.fsk_itemmaster_2_ext, a.fsk_property_1_1, a.fsk_property_1_ext,

Line 511: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);

507: EXCEPTION
508: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
509: RAISE;
510: WHEN OTHERS THEN
511: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
512: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_IM_KRS.KRS_ITEM_PROPERTY_VALUE',11276,inRun_ID);
513: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
514: END KRS_ITEM_PROPERTY_VALUE ;
515: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

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

508: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
509: RAISE;
510: WHEN OTHERS THEN
511: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
512: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_IM_KRS.KRS_ITEM_PROPERTY_VALUE',11276,inRun_ID);
513: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
514: END KRS_ITEM_PROPERTY_VALUE ;
515: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
516: PROCEDURE KRS_ITEM_TYPE ( inRUN_ID IN PLS_INTEGER,

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

639: WHERE ROWID = thisRowId;
640: sLastFSK:=sImpName;
641:
642: IF (FAILED >= MAX_ERR) THEN
643: 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);
644: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
645: END IF;
646: sDisposition:=NULL; sRecStatus:=NULL;
647: END LOOP;

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

653: EXCEPTION
654: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
655: RAISE;
656: WHEN OTHERS THEN
657: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE',11276,inRun_ID);
658: END;
659: END KRS_ITEM_TYPE;
660: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
661: PROCEDURE KRS_ITEM_TYPE_PROPERTY ( inRUN_ID IN PLS_INTEGER,

Line 703: x_usesurr_itemtypeprop PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPE_PROPERTIES',inXFR_GROUP);

699: nErrorCount PLS_INTEGER:=0; /*Error index */
700: nInsertCount PLS_INTEGER:=0; /*Inserts */
701: nUpdateCount PLS_INTEGER:=0; /*Updates */
702: nDups PLS_INTEGER:=0; /*Duplicate records */
703: x_usesurr_itemtypeprop PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPE_PROPERTIES',inXFR_GROUP);
704: /*Use surrogates */
705: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
706: /*Use surrogates */
707: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);

Line 705: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);

701: nUpdateCount PLS_INTEGER:=0; /*Updates */
702: nDups PLS_INTEGER:=0; /*Duplicate records */
703: x_usesurr_itemtypeprop PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPE_PROPERTIES',inXFR_GROUP);
704: /*Use surrogates */
705: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
706: /*Use surrogates */
707: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
708: /*Use surrogates */
709: thisRowId ROWID;

Line 707: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);

703: x_usesurr_itemtypeprop PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPE_PROPERTIES',inXFR_GROUP);
704: /*Use surrogates */
705: x_usesurr_itemtype PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_TYPES',inXFR_GROUP);
706: /*Use surrogates */
707: x_usesurr_property PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PROPERTIES',inXFR_GROUP);
708: /*Use surrogates */
709: thisRowId ROWID;
710: BEGIN
711:

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

817: sLastFSK2:=sFSKPROPERTY;
818:
819: /* Return if MAX_ERR is reached */
820: IF (FAILED >= MAX_ERR) THEN
821: 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);
822: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
823: END IF;
824: sDisposition:=NULL; sRecStatus:=NULL;
825: END LOOP;

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

859: EXCEPTION
860: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
861: RAISE;
862: WHEN OTHERS THEN
863: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_ITEM_TYPE_PROPERTY',11276,inRun_ID);
864: END;
865: END KRS_ITEM_TYPE_PROPERTY ;
866: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
867: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

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

989: IF( x_onl_property_propertyname_f)THEN
990: sRecStatus:='DUPL';
991: sDisposition:='R';
992: nDups:=nDups+1;
993: 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);
994: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));
995: ELSE
996: /*Insert */
997: sDisposition:='I';

Line 994: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));

990: sRecStatus:='DUPL';
991: sDisposition:='R';
992: nDups:=nDups+1;
993: 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);
994: CZ_IMP_ALL.setReturnCode(cz_imp_all.CONCURRENT_WARNING,CZ_UTILS.GET_TEXT('CZ_IMP_PROPERTY_EXISTS','NAME',nPropertyName));
995: ELSE
996: /*Insert */
997: sDisposition:='I';
998: nInsertCount:=nInsertCount+1;

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

1017: WHERE ROWID = thisRowId;
1018: sLastFSK:=sImpName;
1019: sDisposition:=NULL; sRecStatus:=NULL;
1020: IF (FAILED >= MAX_ERR) THEN
1021: 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);
1022: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1023: COMMIT;
1024: END IF;
1025: END LOOP;

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

1029: UPDATES:=nUpdateCount;
1030: DUPS:=nDups;
1031: EXCEPTION
1032: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1033: x_error:=CZ_UTILS.LOG_REPORT('raised max_err',1,'CZ_IMP_IM_KRS.KRS_PROPERTY:MAX',11276,inRun_Id);
1034: RAISE;
1035: WHEN OTHERS THEN
1036: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_ID);
1037: END;

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

1032: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1033: x_error:=CZ_UTILS.LOG_REPORT('raised max_err',1,'CZ_IMP_IM_KRS.KRS_PROPERTY:MAX',11276,inRun_Id);
1034: RAISE;
1035: WHEN OTHERS THEN
1036: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_IM_KRS.KRS_PROPERTY',11276,inRun_ID);
1037: END;
1038: END KRS_PROPERTY ;
1039: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1040: END CZ_IMP_IM_KRS;