DBA Data[Home] [Help]

APPS.CZ_IMP_PR_XFR dependencies on CZ_IMP_ALL

Line 114: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE_GROUP',11276);

110: UPDATE CZ_IMP_price_group
111: SET REC_STATUS='ERR'
112: WHERE PRICE_GROUP_ID=p_xfr_pricegroup.PRICE_GROUP_ID AND RUN_ID=inRUN_ID;
113: END;
114: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE_GROUP',11276);
115: END ;
116: ELSIF (P_XFR_PRICEGROUP.DISPOSITION = 'M') THEN
117: BEGIN
118: UPDATE CZ_PRICE_GROUPS

Line 159: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE_GROUP',11276);

155: UPDATE CZ_IMP_price_group
156: SET REC_STATUS='ERR'
157: WHERE PRICE_GROUP_ID=p_xfr_pricegroup.PRICE_GROUP_ID AND RUN_ID=inRUN_ID;
158: END;
159: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE_GROUP',11276);
160: END ;
161: END IF;
162: END LOOP;
163: CLOSE C_XFR_PRICE_GROUP;

Line 170: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE_GROUP',11276);

166: UPDATES:=NUPDATECOUNT;
167: FAILED:=NFAILED;
168: EXCEPTION
169: WHEN OTHERS THEN
170: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE_GROUP',11276);
171: END;
172: END XFR_PRICE_GROUP;
173:
174: PROCEDURE XFR_PRICE ( inRUN_ID IN PLS_INTEGER,

Line 256: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE',11276);

252: SET REC_STATUS='ERR'
253: WHERE PRICE_GROUP_ID=p_xfr_price.PRICE_GROUP_ID
254: AND ITEM_ID=P_XFR_PRICE.ITEM_ID AND RUN_ID=inRUN_ID;
255: END;
256: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE',11276);
257: END ;
258: ELSIF (P_XFR_PRICE.DISPOSITION = 'M') THEN
259: BEGIN
260: UPDATE CZ_PRICES

Line 294: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE',11276);

290: SET REC_STATUS='ERR'
291: WHERE PRICE_GROUP_ID=p_xfr_price.PRICE_GROUP_ID
292: AND ITEM_ID=P_XFR_PRICE.ITEM_ID AND RUN_ID=inRUN_ID;
293: END;
294: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE',11276);
295: END ;
296: END IF;
297: END LOOP;
298: CLOSE C_XFR_PRICE;

Line 305: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE',11276);

301: UPDATES:=NUPDATECOUNT;
302: FAILED:=NFAILED;
303: EXCEPTION
304: WHEN OTHERS THEN
305: X_ERROR:=CZ_IMP_ALL.REPORT(SQLERRM,1,'CZ_IMP_PR_XFR.XFR_PRICE',11276);
306: END;
307: END XFR_PRICE;
308: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
309: END CZ_IMP_PR_XFR;