DBA Data[Home] [Help]

APPS.ICX_POR_EXT_DIAG dependencies on ICX_POR_EXT_DIAG

Line 1: PACKAGE BODY ICX_POR_EXT_DIAG AS

1: PACKAGE BODY ICX_POR_EXT_DIAG AS
2: /* $Header: ICXEXTDB.pls 120.1 2006/01/10 11:36:01 sbgeorge noship $*/
3:
4: --------------------------------------------------------------
5: -- Global Variables --

Line 38: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.getOperatingUnit-'||

34: EXCEPTION
35: WHEN NO_DATA_FOUND THEN
36: RETURN 'OU: '||pOperatingUnitId;
37: WHEN OTHERS THEN
38: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.getOperatingUnit-'||
39: xErrLoc||' '||SQLERRM);
40: raise ICX_POR_EXT_UTL.gException;
41: END getOperatingUnit;
42:

Line 62: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.getInventoryOrg-'||

58: EXCEPTION
59: WHEN NO_DATA_FOUND THEN
60: RETURN 'InvOrg: '||pInventoryOrgId;
61: WHEN OTHERS THEN
62: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.getInventoryOrg-'||
63: xErrLoc||' '||SQLERRM);
64: raise ICX_POR_EXT_UTL.gException;
65: END getInventoryOrg;
66:

Line 322: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.constructMessage-'||

318: xErrLoc := 1000;
319: RETURN xMessage;
320: EXCEPTION
321: when others then
322: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.constructMessage-'||
323: xErrLoc||' '||SQLERRM);
324: raise ICX_POR_EXT_UTL.gException;
325: END constructMessage;
326:

Line 484: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkCategoryStatus-'||

480: xErrLoc := 400;
481: RETURN xStatus;
482: EXCEPTION
483: when others then
484: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkCategoryStatus-'||
485: xErrLoc||' '||SQLERRM);
486: raise ICX_POR_EXT_UTL.gException;
487: END checkCategoryStatus;
488:

Line 536: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkTemplateHeaderStatus-'||

532: xErrLoc := 400;
533: RETURN xStatus;
534: EXCEPTION
535: when others then
536: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkTemplateHeaderStatus-'||
537: xErrLoc||' '||SQLERRM);
538: raise ICX_POR_EXT_UTL.gException;
539: END checkTemplateHeaderStatus;
540:

Line 596: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkExtCategoryStatus-'||

592: xErrLoc := 400;
593: RETURN xStatus;
594: EXCEPTION
595: when others then
596: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkExtCategoryStatus-'||
597: xErrLoc||' '||SQLERRM);
598: raise ICX_POR_EXT_UTL.gException;
599: END checkExtCategoryStatus;
600:

Line 646: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkExtTemplateHeaderStatus-'||

642: xErrLoc := 400;
643: RETURN xStatus;
644: EXCEPTION
645: when others then
646: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkExtTemplateHeaderStatus-'||
647: xErrLoc||' '||SQLERRM);
648: raise ICX_POR_EXT_UTL.gException;
649: END checkExtTemplateHeaderStatus;
650:

Line 735: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkContractLineStatus-'||

731: xStatus := checkExtCategoryStatus(xCategoryId, xItemNum, pMessage);
732: RETURN xStatus;
733: EXCEPTION
734: when others then
735: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkContractLineStatus-'||
736: xErrLoc||' '||SQLERRM);
737: raise ICX_POR_EXT_UTL.gException;
738: END checkContractLineStatus;
739:

Line 824: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkTemplateLineStatus-'||

820:
821: RETURN xStatus;
822: EXCEPTION
823: when others then
824: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkTemplateLineStatus-'||
825: xErrLoc||' '||SQLERRM);
826: raise ICX_POR_EXT_UTL.gException;
827: END checkTemplateLineStatus;
828:

Line 913: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkASLStatus-'||

909: xStatus := checkExtCategoryStatus(xCategoryId, xItemNum, pMessage);
910: RETURN xStatus;
911: EXCEPTION
912: when others then
913: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkASLStatus-'||
914: xErrLoc||' '||SQLERRM);
915: raise ICX_POR_EXT_UTL.gException;
916: END checkASLStatus;
917:

Line 1022: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkMasterStatus-'||

1018: xStatus := checkExtCategoryStatus(xCategoryId, pItemNum, pMessage);
1019: RETURN xStatus;
1020: EXCEPTION
1021: when others then
1022: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkMasterStatus-'||
1023: xErrLoc||' '||SQLERRM);
1024: raise ICX_POR_EXT_UTL.gException;
1025: END checkMasterStatus;
1026:

Line 1176: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkClassStatus-'||

1172:
1173: RETURN xStatus;
1174: EXCEPTION
1175: when others then
1176: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkClassStatus-'||
1177: xErrLoc||' '||SQLERRM);
1178: ICX_POR_EXT_UTL.printStackTrace;
1179: raise ICX_POR_EXT_UTL.gException;
1180: END checkClassStatus;

Line 1260: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkItemStatus-'||

1256:
1257: RETURN xStatus;
1258: EXCEPTION
1259: when others then
1260: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkItemStatus-'||
1261: xErrLoc||' '||SQLERRM);
1262: ICX_POR_EXT_UTL.printStackTrace;
1263: raise ICX_POR_EXT_UTL.gException;
1264: END checkItemStatus;

Line 1329: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkItemStatus-'||

1325: xErrLoc := 300;
1326: RETURN xStatus;
1327: EXCEPTION
1328: when others then
1329: ICX_POR_EXT_UTL.pushError('ICX_POR_EXT_DIAG.checkItemStatus-'||
1330: xErrLoc||' '||SQLERRM);
1331: ICX_POR_EXT_UTL.printStackTrace;
1332: raise ICX_POR_EXT_UTL.gException;
1333: END checkItemStatus;

Line 2151: END ICX_POR_EXT_DIAG;

2147:
2148: RETURN 0;
2149: END isValidExtPrice;
2150:
2151: END ICX_POR_EXT_DIAG;