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_EXT_UTL

Line 71: --ICX_POR_EXT_UTL.setDebugLevel(ICX_POR_EXT_UTL.NOLOG_LEVEL);

67: xErrLoc PLS_INTEGER := 0;
68: BEGIN
69:
70: -- Set Log level to NOLOG_LEVEL, so no log file will be generated for ECManager
71: --ICX_POR_EXT_UTL.setDebugLevel(ICX_POR_EXT_UTL.NOLOG_LEVEL);
72:
73: -- Set commit size
74: xErrLoc := 100;
75: fnd_profile.get('POR_LOAD_PURGE_COMMIT_SIZE', xCommitSize);

Line 99: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

95:
96: xErrLoc := 300;
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;

Line 153: --ICX_POR_EXT_UTL.setDebugLevel(ICX_POR_EXT_UTL.NOLOG_LEVEL);

149: xErrLoc PLS_INTEGER := 0;
150: BEGIN
151:
152: -- Set Log level to NOLOG_LEVEL, so no log file will be generated for ECManager
153: --ICX_POR_EXT_UTL.setDebugLevel(ICX_POR_EXT_UTL.NOLOG_LEVEL);
154:
155: -- Set commit size
156: xErrLoc := 100;
157: fnd_profile.get('POR_LOAD_PURGE_COMMIT_SIZE', xCommitSize);

Line 181: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

177:
178: xErrLoc := 400;
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-');

Line 235: --ICX_POR_EXT_UTL.setDebugLevel(ICX_POR_EXT_UTL.NOLOG_LEVEL);

231: xErrLoc PLS_INTEGER := 0;
232: BEGIN
233:
234: -- Set Log level to NOLOG_LEVEL, so no log file will be generated for ECManager
235: --ICX_POR_EXT_UTL.setDebugLevel(ICX_POR_EXT_UTL.NOLOG_LEVEL);
236:
237: -- Set commit size
238: xErrLoc := 100;
239: fnd_profile.get('POR_LOAD_PURGE_COMMIT_SIZE', xCommitSize);

Line 263: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

259:
260: xErrLoc := 400;
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;

Line 300: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_HISTORY');

296: xErrLoc PLS_INTEGER := 0;
297: xContinue BOOLEAN := TRUE;
298:
299: BEGIN
300: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_HISTORY');
301: xErrLoc := 100;
302: WHILE xContinue LOOP
303: FORALL i IN 1..pRtItemIds.COUNT
304: DELETE FROM icx_cat_price_history

Line 309: ICX_POR_EXT_UTL.extCommit;

305: WHERE rt_item_id = pRtItemIds(i)
306: AND rownum <= gCommitSize ;
307:
308: xErrLoc := 200;
309: ICX_POR_EXT_UTL.extCommit;
310: IF ( SQL%ROWCOUNT < gCommitSize ) THEN
311: xContinue := FALSE;
312: END IF;
313: END LOOP;

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 318: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||

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;
321: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delPriceHistory(' ||
322: xErrLoc|| '): '||sqlerrm;

Line 320: ICX_POR_EXT_UTL.extRollback;

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;
321: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delPriceHistory(' ||
322: xErrLoc|| '): '||sqlerrm;
323: raise_application_error(-20000,gReturnError);
324: END delPriceHistory;

Line 336: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_TLP');

332: xErrLoc PLS_INTEGER := 0;
333: xContinue BOOLEAN := TRUE;
334:
335: BEGIN
336: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_TLP');
337: xErrLoc := 100;
338: WHILE xContinue LOOP
339: FORALL i IN 1..pRtItemIds.COUNT
340: DELETE FROM icx_cat_items_tlp

Line 345: ICX_POR_EXT_UTL.extCommit;

341: WHERE rt_item_id = pRtItemIds(i)
342: AND rownum <= gCommitSize ;
343:
344: xErrLoc := 200;
345: ICX_POR_EXT_UTL.extCommit;
346: IF ( SQL%ROWCOUNT < gCommitSize ) THEN
347: xContinue := FALSE;
348: END IF;
349: END LOOP;

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 354: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||

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;
357: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsTLP(' ||
358: xErrLoc|| '): '||sqlerrm;

Line 356: ICX_POR_EXT_UTL.extRollback;

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;
357: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsTLP(' ||
358: xErrLoc|| '): '||sqlerrm;
359: raise_application_error(-20000,gReturnError);
360: END delItemsTLP;

Line 372: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_EXT_ITEMS_TLP');

368: xErrLoc PLS_INTEGER := 0;
369: xContinue BOOLEAN := TRUE;
370:
371: BEGIN
372: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_EXT_ITEMS_TLP');
373: xErrLoc := 100;
374: WHILE xContinue LOOP
375: FORALL i IN 1..pRtItemIds.COUNT
376: DELETE FROM icx_cat_ext_items_tlp

Line 381: ICX_POR_EXT_UTL.extCommit;

377: WHERE rt_item_id = pRtItemIds(i)
378: AND rownum <= gCommitSize ;
379:
380: xErrLoc := 200;
381: ICX_POR_EXT_UTL.extCommit;
382: IF ( SQL%ROWCOUNT < gCommitSize ) THEN
383: xContinue := FALSE;
384: END IF;
385: END LOOP;

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 390: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||

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;
393: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delExtItemsTLP(' ||
394: xErrLoc|| '): '||sqlerrm;

Line 392: ICX_POR_EXT_UTL.extRollback;

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;
393: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delExtItemsTLP(' ||
394: xErrLoc|| '): '||sqlerrm;
395: raise_application_error(-20000,gReturnError);
396: END delExtItemsTLP;

Line 408: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_CTX_TLP');

404: xErrLoc PLS_INTEGER := 0;
405: xContinue BOOLEAN := TRUE;
406:
407: BEGIN
408: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_CTX_TLP');
409: xErrLoc := 100;
410: WHILE xContinue LOOP
411: FORALL i IN 1..pRtItemIds.COUNT
412: DELETE FROM icx_cat_items_ctx_tlp

Line 417: ICX_POR_EXT_UTL.extCommit;

413: WHERE rt_item_id = pRtItemIds(i)
414: AND rownum <= gCommitSize ;
415:
416: xErrLoc := 200;
417: ICX_POR_EXT_UTL.extCommit;
418: IF ( SQL%ROWCOUNT < gCommitSize ) THEN
419: xContinue := FALSE;
420: END IF;
421: END LOOP;

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 426: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||

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;
429: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsCtxTLP(' ||
430: xErrLoc|| '): '||sqlerrm;

Line 428: ICX_POR_EXT_UTL.extRollback;

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;
429: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsCtxTLP(' ||
430: xErrLoc|| '): '||sqlerrm;
431: raise_application_error(-20000,gReturnError);
432: END delItemsCtxTLP;

Line 444: ICX_POR_EXT_UTL.debug('Delete from POR_FAVORITE_LIST_LINES');

440: xErrLoc PLS_INTEGER := 0;
441: xContinue BOOLEAN := TRUE;
442:
443: BEGIN
444: ICX_POR_EXT_UTL.debug('Delete from POR_FAVORITE_LIST_LINES');
445: xErrLoc := 100;
446: WHILE xContinue LOOP
447: FORALL i IN 1..pRtItemIds.COUNT
448: DELETE FROM por_favorite_list_lines

Line 453: ICX_POR_EXT_UTL.extCommit;

449: WHERE rt_item_id = pRtItemIds(i)
450: AND rownum <= gCommitSize ;
451:
452: xErrLoc := 200;
453: ICX_POR_EXT_UTL.extCommit;
454: IF ( SQL%ROWCOUNT < gCommitSize ) THEN
455: xContinue := FALSE;
456: END IF;
457: END LOOP;

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 462: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||

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;
465: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delFavoriteList(' ||
466: xErrLoc|| '): '||sqlerrm;

Line 464: ICX_POR_EXT_UTL.extRollback;

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;
465: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delFavoriteList(' ||
466: xErrLoc|| '): '||sqlerrm;
467: raise_application_error(-20000,gReturnError);
468: END delFavoriteList;

Line 480: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORY_ITEMS');

476: xErrLoc PLS_INTEGER := 0;
477: xContinue BOOLEAN := TRUE;
478:
479: BEGIN
480: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_CATEGORY_ITEMS');
481: xErrLoc := 100;
482: WHILE xContinue LOOP
483: FORALL i IN 1..pRtItemIds.COUNT
484: DELETE FROM icx_cat_category_items

Line 489: ICX_POR_EXT_UTL.extCommit;

485: WHERE rt_item_id = pRtItemIds(i)
486: AND rownum <= gCommitSize ;
487:
488: xErrLoc := 200;
489: ICX_POR_EXT_UTL.extCommit;
490: IF ( SQL%ROWCOUNT < gCommitSize ) THEN
491: xContinue := FALSE;
492: END IF;
493: END LOOP;

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 498: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||

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;
501: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delCategoryItems(' ||
502: xErrLoc|| '): '||sqlerrm;

Line 500: ICX_POR_EXT_UTL.extRollback;

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;
501: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delCategoryItems(' ||
502: xErrLoc|| '): '||sqlerrm;
503: raise_application_error(-20000,gReturnError);
504: END delCategoryItems;

Line 514: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_LISTS');

510: PROCEDURE delPriceLists(pPriceListIds IN DBMS_SQL.NUMBER_TABLE)
511: IS
512: xErrLoc PLS_INTEGER := 0;
513: BEGIN
514: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_PRICE_LISTS');
515: xErrLoc := 100;
516: FORALL i IN 1..pPriceListIds.COUNT
517: DELETE FROM icx_cat_price_lists pl
518: WHERE pl.price_list_id = pPriceListIds(i)

Line 523: ICX_POR_EXT_UTL.extCommit;

519: AND NOT EXISTS (SELECT 'price line'
520: FROM icx_cat_item_prices p
521: WHERE p.price_list_id = pl.price_list_id);
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);

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 528: ICX_POR_EXT_UTL.pushError('Index: '|| SQL%ROWCOUNT+1);

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(' ||
531: xErrLoc|| '): '||sqlerrm;
532: raise_application_error(-20000,gReturnError);

Line 529: ICX_POR_EXT_UTL.extRollback;

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(' ||
531: xErrLoc|| '): '||sqlerrm;
532: raise_application_error(-20000,gReturnError);
533: END delPriceLists;

Line 546: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEM_PRICES');

542: xContinue BOOLEAN := TRUE;
543: xPriceListIds DBMS_SQL.NUMBER_TABLE;
544:
545: BEGIN
546: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEM_PRICES');
547: xErrLoc := 100;
548: WHILE xContinue LOOP
549: xPriceListIds.DELETE;
550:

Line 559: ICX_POR_EXT_UTL.extCommit;

555: AND rownum <= gCommitSize
556: RETURNING price_list_id BULK COLLECT INTO xPriceListIds;
557:
558: xErrLoc := 200;
559: ICX_POR_EXT_UTL.extCommit;
560: IF ( SQL%ROWCOUNT < gCommitSize ) THEN
561: xContinue := FALSE;
562: END IF;
563:

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 571: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||

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;
574: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemPrices(' ||
575: xErrLoc|| '): '||sqlerrm;

Line 573: ICX_POR_EXT_UTL.extRollback;

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;
574: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemPrices(' ||
575: xErrLoc|| '): '||sqlerrm;
576: raise_application_error(-20000,gReturnError);
577: END delItemPrices;

Line 589: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_B');

585: xErrLoc PLS_INTEGER := 0;
586: xContinue BOOLEAN := TRUE;
587:
588: BEGIN
589: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_ITEMS_B');
590: xErrLoc := 100;
591: WHILE xContinue LOOP
592: FORALL i IN 1..pRtItemIds.COUNT
593: DELETE FROM icx_cat_items_b

Line 598: ICX_POR_EXT_UTL.extCommit;

594: WHERE rt_item_id = pRtItemIds(i)
595: AND rownum <= gCommitSize;
596:
597: xErrLoc := 200;
598: ICX_POR_EXT_UTL.extCommit;
599: IF ( SQL%ROWCOUNT < gCommitSize ) THEN
600: xContinue := FALSE;
601: END IF;
602: END LOOP;

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 607: ICX_POR_EXT_UTL.pushError('pRtItemIds('||SQL%ROWCOUNT+1||'): '||

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;
610: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsB(' ||
611: xErrLoc|| '): '||sqlerrm;

Line 609: ICX_POR_EXT_UTL.extRollback;

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;
610: gReturnError := gReturnError || 'ICX_POR_DELETE_CATALOG.delItemsB(' ||
611: xErrLoc|| '): '||sqlerrm;
612: raise_application_error(-20000,gReturnError);
613: END delItemsB;

Line 659: ICX_POR_EXT_UTL.extAFCommit;

655: delCategoryItems(pRtItemIds);
656: END IF;
657:
658: xErrLoc := 400;
659: ICX_POR_EXT_UTL.extAFCommit;
660:
661: EXCEPTION
662: WHEN OTHERS THEN
663: ICX_POR_EXT_UTL.extRollback;

Line 663: ICX_POR_EXT_UTL.extRollback;

659: ICX_POR_EXT_UTL.extAFCommit;
660:
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);

Line 682: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_BROWSE_TREES');

678: xErrLoc PLS_INTEGER := 0;
679: xContinue BOOLEAN := TRUE;
680:
681: BEGIN
682: ICX_POR_EXT_UTL.debug('Delete from ICX_CAT_BROWSE_TREES');
683: --Delete the item category from browse trees if it existed in any toc.
684: xErrLoc := 100;
685: DELETE FROM icx_cat_browse_trees
686: WHERE child_category_id = pRtCategoryId;

Line 688: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_ORDER_MAP');

684: xErrLoc := 100;
685: DELETE FROM icx_cat_browse_trees
686: WHERE child_category_id = pRtCategoryId;
687:
688: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_ORDER_MAP');
689: --Delete the mapping for the item category.
690: xErrLoc := 200;
691: DELETE FROM icx_por_category_order_map
692: WHERE rt_category_id = pRtCategoryId;

Line 694: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_DATA_SOURCES');

690: xErrLoc := 200;
691: DELETE FROM icx_por_category_order_map
692: WHERE rt_category_id = pRtCategoryId;
693:
694: ICX_POR_EXT_UTL.debug('Delete from ICX_POR_CATEGORY_DATA_SOURCES');
695: --Delete the mapping for the item category.
696: xErrLoc := 300;
697: DELETE FROM icx_por_category_data_sources
698: WHERE category_key = pCategoryKey;