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.ICX_POR_DELETE_CATALOG dependencies on ICX_POR_DELETE_CATALOG

Line 1: PACKAGE BODY ICX_POR_DELETE_CATALOG AS

1: PACKAGE BODY ICX_POR_DELETE_CATALOG AS
2: /* $Header: ICXDELCB.pls 115.7 2004/06/10 10:43:56 sosingha ship $*/
3:
4:
5: /**

Line 101: 'ICX_POR_DELETE_CATALOG.delete_items_in_category(' || xErrLoc|| ')'|| ', sqlerrm:' ||sqlerrm ||

97: EXCEPTION
98: WHEN snap_shot_too_old THEN
99: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
100: 'ORA-01555: snapshot too old: caught at '||
101: 'ICX_POR_DELETE_CATALOG.delete_items_in_category(' || xErrLoc|| ')'|| ', sqlerrm:' ||sqlerrm ||
102: '; so close the cursor and reopen the cursor-');
103: xErrLoc := 400;
104: COMMIT;
105: IF (item_cursor%ISOPEN) THEN

Line 126: 'ICX_POR_DELETE_CATALOG.delete_items_in_category(' ||

122:
123: EXCEPTION
124: WHEN OTHERS THEN
125: gReturnError := gReturnError ||
126: 'ICX_POR_DELETE_CATALOG.delete_items_in_category(' ||
127: xErrLoc|| '): '||sqlerrm;
128: raise_application_error(-20000,gReturnError);
129: END delete_items_in_category;
130:

Line 183: 'ICX_POR_DELETE_CATALOG.delete_items_in_catalog(' || xErrLoc|| ')'||

179: EXCEPTION
180: WHEN snap_shot_too_old THEN
181: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
182: 'ORA-01555: snapshot too old: caught at '||
183: 'ICX_POR_DELETE_CATALOG.delete_items_in_catalog(' || xErrLoc|| ')'||
184: ', sqlerrm:' ||sqlerrm ||
185: '; so close the cursor and reopen the cursor-');
186: xErrLoc := 500;
187: COMMIT;

Line 205: 'ICX_POR_DELETE_CATALOG.delete_items_in_catalog(' ||

201:
202: EXCEPTION
203: WHEN OTHERS THEN
204: gReturnError := gReturnError ||
205: 'ICX_POR_DELETE_CATALOG.delete_items_in_catalog(' ||
206: xErrLoc|| '): '||sqlerrm;
207: raise_application_error(-20000,gReturnError);
208: END delete_items_in_catalog;
209:

Line 265: 'ICX_POR_DELETE_CATALOG.delete_supplier_catalog_opUnit(' || xErrLoc|| ')'|| ', sqlerrm:' ||sqlerrm ||

261: EXCEPTION
262: WHEN snap_shot_too_old THEN
263: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
264: 'ORA-01555: snapshot too old: caught at '||
265: 'ICX_POR_DELETE_CATALOG.delete_supplier_catalog_opUnit(' || xErrLoc|| ')'|| ', sqlerrm:' ||sqlerrm ||
266: '; so close the cursor and reopen the cursor-');
267: xErrLoc := 500;
268: COMMIT;
269: IF (item_cursor%ISOPEN) THEN

Line 285: 'ICX_POR_DELETE_CATALOG.delete_supplier_catalog_opUnit(' ||

281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: gReturnError := gReturnError ||
285: 'ICX_POR_DELETE_CATALOG.delete_supplier_catalog_opUnit(' ||
286: xErrLoc|| '): '||sqlerrm;
287: raise_application_error(-20000,gReturnError);
288: END delete_supplier_catalog_opUnit;
289:

Line 316: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delPriceHistory-'||

312: END IF;
313: END LOOP;
314: EXCEPTION
315: WHEN OTHERS THEN
316: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delPriceHistory-'||
317: xErrLoc||' '||SQLERRM);
318: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
319: pRtItemIds(SQL%ROWCOUNT+1));
320: ICX_POR_EXT_UTL.extRollback;

Line 321: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delPriceHistory(' ||

317: xErrLoc||' '||SQLERRM);
318: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
319: pRtItemIds(SQL%ROWCOUNT+1));
320: ICX_POR_EXT_UTL.extRollback;
321: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delPriceHistory(' ||
322: xErrLoc|| '): '||sqlerrm;
323: raise_application_error(-20000,gReturnError);
324: END delPriceHistory;
325:

Line 352: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delItemsTLP-'||

348: END IF;
349: END LOOP;
350: EXCEPTION
351: WHEN OTHERS THEN
352: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delItemsTLP-'||
353: xErrLoc||' '||SQLERRM);
354: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
355: pRtItemIds(SQL%ROWCOUNT+1));
356: ICX_POR_EXT_UTL.extRollback;

Line 357: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsTLP(' ||

353: xErrLoc||' '||SQLERRM);
354: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
355: pRtItemIds(SQL%ROWCOUNT+1));
356: ICX_POR_EXT_UTL.extRollback;
357: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsTLP(' ||
358: xErrLoc|| '): '||sqlerrm;
359: raise_application_error(-20000,gReturnError);
360: END delItemsTLP;
361:

Line 388: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delExtItemsTLP-'||

384: END IF;
385: END LOOP;
386: EXCEPTION
387: WHEN OTHERS THEN
388: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delExtItemsTLP-'||
389: xErrLoc||' '||SQLERRM);
390: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
391: pRtItemIds(SQL%ROWCOUNT+1));
392: ICX_POR_EXT_UTL.extRollback;

Line 393: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delExtItemsTLP(' ||

389: xErrLoc||' '||SQLERRM);
390: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
391: pRtItemIds(SQL%ROWCOUNT+1));
392: ICX_POR_EXT_UTL.extRollback;
393: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delExtItemsTLP(' ||
394: xErrLoc|| '): '||sqlerrm;
395: raise_application_error(-20000,gReturnError);
396: END delExtItemsTLP;
397:

Line 424: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delItemsCtxTLP-'||

420: END IF;
421: END LOOP;
422: EXCEPTION
423: WHEN OTHERS THEN
424: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delItemsCtxTLP-'||
425: xErrLoc||' '||SQLERRM);
426: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
427: pRtItemIds(SQL%ROWCOUNT+1));
428: ICX_POR_EXT_UTL.extRollback;

Line 429: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsCtxTLP(' ||

425: xErrLoc||' '||SQLERRM);
426: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
427: pRtItemIds(SQL%ROWCOUNT+1));
428: ICX_POR_EXT_UTL.extRollback;
429: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsCtxTLP(' ||
430: xErrLoc|| '): '||sqlerrm;
431: raise_application_error(-20000,gReturnError);
432: END delItemsCtxTLP;
433:

Line 460: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delFavoriteList-'||

456: END IF;
457: END LOOP;
458: EXCEPTION
459: WHEN OTHERS THEN
460: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delFavoriteList-'||
461: xErrLoc||' '||SQLERRM);
462: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
463: pRtItemIds(SQL%ROWCOUNT+1));
464: ICX_POR_EXT_UTL.extRollback;

Line 465: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delFavoriteList(' ||

461: xErrLoc||' '||SQLERRM);
462: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
463: pRtItemIds(SQL%ROWCOUNT+1));
464: ICX_POR_EXT_UTL.extRollback;
465: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delFavoriteList(' ||
466: xErrLoc|| '): '||sqlerrm;
467: raise_application_error(-20000,gReturnError);
468: END delFavoriteList;
469:

Line 496: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delCategoryItems-'||

492: END IF;
493: END LOOP;
494: EXCEPTION
495: WHEN OTHERS THEN
496: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delCategoryItems-'||
497: xErrLoc||' '||SQLERRM);
498: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
499: pRtItemIds(SQL%ROWCOUNT+1));
500: ICX_POR_EXT_UTL.extRollback;

Line 501: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delCategoryItems(' ||

497: xErrLoc||' '||SQLERRM);
498: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
499: pRtItemIds(SQL%ROWCOUNT+1));
500: ICX_POR_EXT_UTL.extRollback;
501: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delCategoryItems(' ||
502: xErrLoc|| '): '||sqlerrm;
503: raise_application_error(-20000,gReturnError);
504: END delCategoryItems;
505:

Line 526: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delPriceLists-'||

522: xErrLoc := 200;
523: ICX_POR_EXT_UTL.extCommit;
524: EXCEPTION
525: WHEN OTHERS THEN
526: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delPriceLists-'||
527: xErrLoc||' '||SQLERRM);
528: ICX_POR_EXT_UTL.pushError('Index: '|| SQL%ROWCOUNT+1);
529: ICX_POR_EXT_UTL.extRollback;
530: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delPriceLists(' ||

Line 530: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delPriceLists(' ||

526: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delPriceLists-'||
527: xErrLoc||' '||SQLERRM);
528: ICX_POR_EXT_UTL.pushError('Index: '|| SQL%ROWCOUNT+1);
529: ICX_POR_EXT_UTL.extRollback;
530: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delPriceLists(' ||
531: xErrLoc|| '): '||sqlerrm;
532: raise_application_error(-20000,gReturnError);
533: END delPriceLists;
534:

Line 569: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delItemPrices-'||

565: delPriceLists(xPriceListIds);
566: END LOOP;
567: EXCEPTION
568: WHEN OTHERS THEN
569: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delItemPrices-'||
570: xErrLoc||' '||SQLERRM);
571: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
572: pRtItemIds(SQL%ROWCOUNT+1));
573: ICX_POR_EXT_UTL.extRollback;

Line 574: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemPrices(' ||

570: xErrLoc||' '||SQLERRM);
571: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
572: pRtItemIds(SQL%ROWCOUNT+1));
573: ICX_POR_EXT_UTL.extRollback;
574: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemPrices(' ||
575: xErrLoc|| '): '||sqlerrm;
576: raise_application_error(-20000,gReturnError);
577: END delItemPrices;
578:

Line 605: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delItemsB-'||

601: END IF;
602: END LOOP;
603: EXCEPTION
604: WHEN OTHERS THEN
605: ICX_POR_EXT_UTL.pushError('ICX_POR_DELETE_CATALOG.delItemsB-'||
606: xErrLoc||' '||SQLERRM);
607: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
608: pRtItemIds(SQL%ROWCOUNT+1));
609: ICX_POR_EXT_UTL.extRollback;

Line 610: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsB(' ||

606: xErrLoc||' '||SQLERRM);
607: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||
608: pRtItemIds(SQL%ROWCOUNT+1));
609: ICX_POR_EXT_UTL.extRollback;
610: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsB(' ||
611: xErrLoc|| '): '||sqlerrm;
612: raise_application_error(-20000,gReturnError);
613: END delItemsB;
614:

Line 665: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.deleteCommonTables(' ||

661: EXCEPTION
662: WHEN OTHERS THEN
663: ICX_POR_EXT_UTL.extRollback;
664:
665: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.deleteCommonTables(' ||
666: xErrLoc||'): '||sqlerrm;
667: raise_application_error(-20000,gReturnError);
668: END deleteCommonTables;
669:

Line 702: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.deleteCategoryRelatedInfo(' ||

698: WHERE category_key = pCategoryKey;
699:
700: EXCEPTION
701: WHEN OTHERS THEN
702: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.deleteCategoryRelatedInfo(' ||
703: xErrLoc|| '): '||sqlerrm;
704: raise_application_error(-20000,gReturnError);
705: END deleteCategoryRelatedInfo;
706:

Line 707: END ICX_POR_DELETE_CATALOG;

703: xErrLoc|| '): '||sqlerrm;
704: raise_application_error(-20000,gReturnError);
705: END deleteCategoryRelatedInfo;
706:
707: END ICX_POR_DELETE_CATALOG;