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_EXT_PURGE dependencies on ICX_POR_EXT_PURGE

Line 1: PACKAGE BODY ICX_POR_EXT_PURGE AS

1: PACKAGE BODY ICX_POR_EXT_PURGE AS
2: /* $Header: ICXEXTPB.pls 120.1 2006/01/10 12:01:03 sbgeorge noship $*/
3:
4: --------------------------------------------------------------
5: -- Type and Cursor --

Line 198: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.deleteCategories-'||

194: xErrLoc := 700;
195: clearTables('CLASS');
196: EXCEPTION
197: when others then
198: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.deleteCategories-'||
199: xErrLoc||' '||SQLERRM);
200: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, 'CLASS'));
201:
202: ICX_POR_EXT_UTL.extRollback;

Line 241: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.deleteItems-'||

237: exception
238: when others then
239: ICX_POR_EXT_UTL.extRollback;
240:
241: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.deleteItems-'||
242: xErrLoc||' '||SQLERRM);
243:
244: raise ICX_POR_EXT_UTL.gException;
245: end deleteItems;

Line 289: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.processBatchData-'||

285: when OTHERS then
286: -- rollback;
287: ICX_POR_EXT_UTL.extRollback;
288:
289: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.processBatchData-'||
290: xErrLoc||' '||SQLERRM);
291: raise ICX_POR_EXT_UTL.gException;
292: END processBatchData;
293:

Line 440: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.openClassCursor-'||

436: EXCEPTION
437: when others then
438: ICX_POR_EXT_UTL.extRollback;
439:
440: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.openClassCursor-'||
441: xErrLoc||' '||SQLERRM);
442: raise ICX_POR_EXT_UTL.gException;
443: END openClassCursor;
444:

Line 538: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.purgeClassificationData-'||

534: when ICX_POR_EXT_UTL.gException then
535: -- rollback;
536: ICX_POR_EXT_UTL.extRollback;
537:
538: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.purgeClassificationData-'||
539: xErrLoc);
540: raise ICX_POR_EXT_UTL.gException;
541: when others then
542: -- rollback;

Line 545: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.purgeClassificationData-'||

541: when others then
542: -- rollback;
543: ICX_POR_EXT_UTL.extRollback;
544:
545: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.purgeClassificationData-'||
546: xErrLoc||' '||SQLERRM);
547:
548: -- Bug 2001770
549: -- handle exception ORA-01555: snapshot too old: rollback segment

Line 555: 'Restart ICX_POR_EXT_PURGE.purgeClassificationData ' ||

551: if (SQLCODE = -01555) then
552: if (gRestartTime < 3) then
553: gRestartTime := gRestartTime + 1;
554: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
555: 'Restart ICX_POR_EXT_PURGE.purgeClassificationData ' ||
556: gRestartTime || ' times');
557: gExceptionOccured := true;
558: -- Bug 2305219, zxzhang, 05/06/2002
559: -- purgeClassificationData;

Line 563: 'Restart ICX_POR_EXT_PURGE.purgeClassificationData too many times');

559: -- purgeClassificationData;
560: purgeClassificationData(pMode, pInvCatId);
561: else
562: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
563: 'Restart ICX_POR_EXT_PURGE.purgeClassificationData too many times');
564: raise ICX_POR_EXT_UTL.gException;
565: end if;
566: else
567: raise ICX_POR_EXT_UTL.gException;

Line 697: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.openItemCursor-'||

693: EXCEPTION
694: when others then
695: ICX_POR_EXT_UTL.extRollback;
696:
697: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.openItemCursor-'||
698: xErrLoc||' '||SQLERRM);
699: raise ICX_POR_EXT_UTL.gException;
700: END openItemCursor;
701:

Line 768: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.processItemRecords-'||

764: EXCEPTION
765: when others then
766: ICX_POR_EXT_UTL.extRollback;
767:
768: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.processItemRecords-'||
769: xErrLoc||' '||SQLERRM);
770: raise ICX_POR_EXT_UTL.gException;
771: END processItemRecords;
772:

Line 835: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.purgeItemData-'||

831: EXCEPTION
832: WHEN ICX_POR_EXT_UTL.gException THEN
833: ICX_POR_EXT_UTL.extRollback;
834:
835: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.purgeItemData-'||
836: xErrLoc);
837: raise ICX_POR_EXT_UTL.gException;
838: WHEN OTHERS THEN
839: ICX_POR_EXT_UTL.extRollback;

Line 841: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.purgeItemData-'||

837: raise ICX_POR_EXT_UTL.gException;
838: WHEN OTHERS THEN
839: ICX_POR_EXT_UTL.extRollback;
840:
841: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_PURGE.purgeItemData-'||
842: xErrLoc||' '||SQLERRM);
843:
844: -- Bug 2001770
845: -- handle exception ORA-01555: snapshot too old: rollback segment

Line 851: 'Restart ICX_POR_EXT_PURGE.purgeItemData ' ||

847: if (SQLCODE = -01555) then
848: if (gRestartTime < 3) then
849: gRestartTime := gRestartTime + 1;
850: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
851: 'Restart ICX_POR_EXT_PURGE.purgeItemData ' ||
852: gRestartTime || ' times');
853: gExceptionOccured := true;
854:
855: purgeItemData(pMode, pInvCatItemId);

Line 858: 'Restart ICX_POR_EXT_PURGE.purgeItemData too many times');

854:
855: purgeItemData(pMode, pInvCatItemId);
856: else
857: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL,
858: 'Restart ICX_POR_EXT_PURGE.purgeItemData too many times');
859: raise ICX_POR_EXT_UTL.gException;
860: end if;
861: else
862: raise ICX_POR_EXT_UTL.gException;

Line 867: END ICX_POR_EXT_PURGE;

863: end if;
864:
865: END purgeItemData;
866:
867: END ICX_POR_EXT_PURGE;