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_PR_MAIN dependencies on CZ_IMP_PR_MAIN

Line 1: PACKAGE BODY CZ_IMP_PR_MAIN AS

1: PACKAGE BODY CZ_IMP_PR_MAIN AS
2: /* $Header: cziprmnb.pls 115.18 2002/12/03 14:47:45 askhacha ship $ */
3:
4:
5: PROCEDURE CND_PRICE ( inRUN_ID IN PLS_INTEGER,

Line 45: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.CND_PRICE',11276);

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

Line 55: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.CND_PRICE',11276);

51: FAILED:=nFailed;
52:
53: EXCEPTION
54: WHEN OTHERS THEN
55: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.CND_PRICE',11276);
56: END;
57:
58: END CND_PRICE;
59:

Line 102: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.CND_PRICE_GROUP',11276);

98: nCommitCount:=0;
99: END IF;
100: EXCEPTION
101: WHEN OTHERS THEN
102: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.CND_PRICE_GROUP',11276);
103: nFailed:=nFailed+1;
104: END;
105: END IF;
106: END LOOP;

Line 112: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.CND_PRICE_GROUP',11276);

108: FAILED:=nFailed;
109:
110: EXCEPTION
111: WHEN OTHERS THEN
112: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.CND_PRICE_GROUP',11276);
113: END;
114:
115: END CND_PRICE_GROUP;
116:

Line 157: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.MAIN_PRICE',11276);

153: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
154: VALUES(inRUN_ID,SYSDATE,SYSDATE);
155:
156: WHEN OTHERS THEN
157: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.MAIN_PRICE',11276);
158: END;
159:
160: CZ_IMP_PR_MAIN.CND_PRICE (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
161: IF (nFailed=MAX_ERR) THEN

Line 160: CZ_IMP_PR_MAIN.CND_PRICE (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

156: WHEN OTHERS THEN
157: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.MAIN_PRICE',11276);
158: END;
159:
160: CZ_IMP_PR_MAIN.CND_PRICE (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
161: IF (nFailed=MAX_ERR) THEN
162: INSERTS:=0;
163: UPDATES:=0;
164: FAILED:=MAX_ERR;

Line 176: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_PR_MAIN.MAIN_PRICE ',11276);

172: IF(nFailed < MAX_ERR) THEN
173: CZ_IMP_PR_XFR.XFR_PRICE (inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
174: /* Report Insert Errors */
175: IF (nXfrInsertCount<> INSERTS) THEN
176: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_PR_MAIN.MAIN_PRICE ',11276);
177: END IF;
178:
179: /* Report Update Errors */
180: IF (nXfrUpdateCount<> UPDATES) THEN

Line 181: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PR_MAIN.MAIN_PRICE',11276);

177: END IF;
178:
179: /* Report Update Errors */
180: IF (nXfrUpdateCount<> UPDATES) THEN
181: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PR_MAIN.MAIN_PRICE',11276);
182: END IF;
183:
184: /* Return the transferred number of rows and not the number of rows with keys resolved*/
185: INSERTS:=nXfrInsertCount;

Line 193: CZ_IMP_PR_MAIN.RPT_PRICE(inRUN_ID);

189: ELSE
190: FAILED:=nFailed;
191: END IF;
192:
193: CZ_IMP_PR_MAIN.RPT_PRICE(inRUN_ID);
194: END ;
195: END MAIN_PRICE ;
196: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
197:

Line 234: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.MAIN_PRICE_GROUP',11276);

230: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
231: VALUES(inRUN_ID,SYSDATE,SYSDATE);
232:
233: WHEN OTHERS THEN
234: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.MAIN_PRICE_GROUP',11276);
235: END;
236:
237: CZ_IMP_PR_MAIN.CND_PRICE_GROUP (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
238: IF (nFailed=MAX_ERR) THEN

Line 237: CZ_IMP_PR_MAIN.CND_PRICE_GROUP (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);

233: WHEN OTHERS THEN
234: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.MAIN_PRICE_GROUP',11276);
235: END;
236:
237: CZ_IMP_PR_MAIN.CND_PRICE_GROUP (inRun_ID,COMMIT_SIZE,MAX_ERR,nFailed);
238: IF (nFailed=MAX_ERR) THEN
239: INSERTS:=0;
240: UPDATES:=0;
241: FAILED:=MAX_ERR;

Line 253: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_PR_MAIN.MAIN_PRICE_GROUP ',11276);

249: IF(nFailed < MAX_ERR) THEN
250: CZ_IMP_PR_XFR.XFR_PRICE_GROUP(inRUN_ID,COMMIT_SIZE,MAX_ERR-nFailed,nXfrInsertCount,nXfrUpdateCount,FAILED,inXFR_GROUP);
251: /* Report Insert Errors */
252: IF (nXfrInsertCount<> INSERTS) THEN
253: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_PR_MAIN.MAIN_PRICE_GROUP ',11276);
254: END IF;
255:
256: /* Report Update Errors */
257: IF (nXfrUpdateCount<> UPDATES) THEN

Line 258: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PR_MAIN.MAIN_PRICE_GROUP ',11276);

254: END IF;
255:
256: /* Report Update Errors */
257: IF (nXfrUpdateCount<> UPDATES) THEN
258: x_error:=CZ_IMP_ALL.REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PR_MAIN.MAIN_PRICE_GROUP ',11276);
259: END IF;
260:
261: /* Return the transferred number of rows and not the number of rows with keys resolved*/
262: INSERTS:=nXfrInsertCount;

Line 270: CZ_IMP_PR_MAIN.RPT_PRICE_GROUP(inRUN_ID);

266: ELSE
267: FAILED:=nFailed;
268: END IF;
269:
270: CZ_IMP_PR_MAIN.RPT_PRICE_GROUP(inRUN_ID);
271: END ;
272: END MAIN_PRICE_GROUP;
273: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
274: PROCEDURE RPT_PRICE ( inRUN_ID IN PLS_INTEGER ) AS

Line 311: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE',11276);

307: COMMIT;
308:
309: EXCEPTION
310: WHEN OTHERS THEN
311: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE',11276);
312: END;
313:
314: DECLARE
315: nErrors PLS_INTEGER;

Line 331: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE',11276);

327: WHERE RUN_ID=inRUN_ID;
328: COMMIT;
329: EXCEPTION
330: WHEN OTHERS THEN
331: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE',11276);
332: END;
333: EXCEPTION
334: WHEN OTHERS THEN
335: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE',11276);

Line 335: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE',11276);

331: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE',11276);
332: END;
333: EXCEPTION
334: WHEN OTHERS THEN
335: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE',11276);
336: END;
337:
338: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
339: PROCEDURE RPT_PRICE_GROUP ( inRUN_ID IN PLS_INTEGER ) AS

Line 376: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE_GROUP',11276);

372: COMMIT;
373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE_GROUP',11276);
377: END;
378:
379: DECLARE
380: nErrors PLS_INTEGER;

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

392: WHERE RUN_ID=inRUN_ID;
393: COMMIT;
394: EXCEPTION
395: WHEN OTHERS THEN
396: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE_GROUP',11276);
397: END;
398: EXCEPTION
399: WHEN OTHERS THEN
400: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE_GROUP',11276);

Line 400: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE_GROUP',11276);

396: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE_GROUP',11276);
397: END;
398: EXCEPTION
399: WHEN OTHERS THEN
400: x_error:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_MAIN.RPT_PRICE_GROUP',11276);
401: END;
402:
403: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
404:

Line 405: END CZ_IMP_PR_MAIN;

401: END;
402:
403: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
404:
405: END CZ_IMP_PR_MAIN;