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_DIAG dependencies on ICX_POR_EXT_UTL

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 40: raise ICX_POR_EXT_UTL.gException;

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:
43: -- Get inventory organization name
44: FUNCTION getInventoryOrg(pInventoryOrgId IN NUMBER)

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 64: raise ICX_POR_EXT_UTL.gException;

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:
67: -- Construct message, usually pOrgName carries Operating Unit or
68: -- Inventory Organization, pDocName carries document number, and

Line 84: xIcxSchema := ICX_POR_EXT_UTL.getIcxSchema;

80: xIcxSchema VARCHAR2(20);
81:
82: BEGIN
83: xErrLoc := 100;
84: xIcxSchema := ICX_POR_EXT_UTL.getIcxSchema;
85: xErrLoc := 200;
86: IF pStatus = INVALID_TEMPLATE_LINE THEN
87: xMessage := 'Invalid template line ' || pDocName || ', ' ||
88: pExtraValue || ' in Operating Unit: ' || pOrgName;

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 324: raise ICX_POR_EXT_UTL.gException;

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:
327: FUNCTION getPriceReport(p_document_type IN VARCHAR2,
328: p_org_id IN NUMBER,

Line 407: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

403: xEndDate DATE;
404: xDisableDate DATE;
405:
406: BEGIN
407: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
408: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
409: 'checkCategoryStatus(pValue: ' || pValue || ')');
410: END IF;
411:

Line 408: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

404: xDisableDate DATE;
405:
406: BEGIN
407: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
408: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
409: 'checkCategoryStatus(pValue: ' || pValue || ')');
410: END IF;
411:
412: xErrLoc := 100;

Line 431: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

427: EXCEPTION
428: WHEN OTHERS THEN
429: xStatus := INVALID_CATEGORY;
430: pMessage := 'Invalid category: ' || pValue;
431: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
432: RETURN xStatus;
433: END;
434: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
435: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 434: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

430: pMessage := 'Invalid category: ' || pValue;
431: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
432: RETURN xStatus;
433: END;
434: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
435: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
436: 'Category found with category_id: ' || xCategoryId ||
437: ', xWebEnabledFlag: ' || NVL(xWebEnabledFlag, 'NULL') ||
438: ', xStartDate: ' || NVL(TO_CHAR(xStartDate, 'MM/DD/YY HH24:MI:SS'),

Line 435: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

431: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
432: RETURN xStatus;
433: END;
434: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
435: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
436: 'Category found with category_id: ' || xCategoryId ||
437: ', xWebEnabledFlag: ' || NVL(xWebEnabledFlag, 'NULL') ||
438: ', xStartDate: ' || NVL(TO_CHAR(xStartDate, 'MM/DD/YY HH24:MI:SS'),
439: 'NULL') || ', xEndDate: ' ||

Line 449: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

445: xErrLoc := 220;
446: IF xWebEnabledFlag <> 'Y' THEN
447: xStatus := NOT_WEBENABLED_CATEGORY;
448: pMessage := 'Not webenabled category: ' || xCategoryId;
449: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
450: RETURN xStatus;
451: END IF;
452:
453: xErrLoc := 240;

Line 460: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

456: NVL(xDisableDate, SYSDATE+1) <= SYSDATE)
457: THEN
458: xStatus := INACTIVE_CATEGORY;
459: pMessage := 'Inactive category: ' || xCategoryId;
460: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
461: RETURN xStatus;
462: END IF;
463:
464: xErrLoc := 300;

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 486: raise ICX_POR_EXT_UTL.gException;

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:
489: -- Check template header status
490: FUNCTION checkTemplateHeaderStatus(pValue IN VARCHAR2,

Line 499: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

495: xStatus PLS_INTEGER := VALID_FOR_EXTRACT;
496: xInactiveDate DATE;
497:
498: BEGIN
499: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
500: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
501: 'checkTemplateHeaderStatus(pValue: ' || pValue || ')');
502: END IF;
503:

Line 500: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

496: xInactiveDate DATE;
497:
498: BEGIN
499: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
500: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
501: 'checkTemplateHeaderStatus(pValue: ' || pValue || ')');
502: END IF;
503:
504: xErrLoc := 100;

Line 515: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

511: EXCEPTION
512: WHEN OTHERS THEN
513: xStatus := INVALID_TEMPLATE_HEADER;
514: pMessage := 'Invalid template header: ' || pValue;
515: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
516: RETURN xStatus;
517: END;
518: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
519: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 518: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

514: pMessage := 'Invalid template header: ' || pValue;
515: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
516: RETURN xStatus;
517: END;
518: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
519: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
520: 'Template header found with xInactiveDate: ' ||
521: NVL(TO_CHAR(xInactiveDate, 'MM/DD/YY HH24:MI:SS'), 'NULL'));
522: END IF;

Line 519: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

515: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
516: RETURN xStatus;
517: END;
518: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
519: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
520: 'Template header found with xInactiveDate: ' ||
521: NVL(TO_CHAR(xInactiveDate, 'MM/DD/YY HH24:MI:SS'), 'NULL'));
522: END IF;
523:

Line 528: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

524: xErrLoc := 200;
525: IF NVL(xInactiveDate, SYSDATE+1) <= SYSDATE THEN
526: xStatus := INACTIVE_TEMPLATE_HEADER;
527: pMessage := 'Inactive template header: ' || pValue;
528: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
529: RETURN xStatus;
530: END IF;
531:
532: xErrLoc := 400;

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 538: raise ICX_POR_EXT_UTL.gException;

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:
541:
542: --------------------------------------------------------------

Line 557: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

553: xCategoryName mtl_categories_kfv.concatenated_segments%TYPE;
554: xRtCategoryId NUMBER;
555:
556: BEGIN
557: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
558: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
559: 'checkExtCategoryStatus(pCategoryId: ' || pCategoryId || ')');
560: END IF;
561:

Line 558: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

554: xRtCategoryId NUMBER;
555:
556: BEGIN
557: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
558: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
559: 'checkExtCategoryStatus(pCategoryId: ' || pCategoryId || ')');
560: END IF;
561:
562: xErrLoc := 100;

Line 584: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

580:
581: xErrLoc := 150;
582: pMessage := constructMessage(xStatus, gOperatingUnitName,
583: xCategoryName, pItemNum);
584: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
585: RETURN xStatus;
586: END;
587: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
588: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 587: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

583: xCategoryName, pItemNum);
584: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
585: RETURN xStatus;
586: END;
587: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
588: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
589: 'Category extracted as rt_category_id: '||xRtCategoryId);
590: END IF;
591:

Line 588: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

584: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
585: RETURN xStatus;
586: END;
587: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
588: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
589: 'Category extracted as rt_category_id: '||xRtCategoryId);
590: END IF;
591:
592: xErrLoc := 400;

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 598: raise ICX_POR_EXT_UTL.gException;

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:
601: -- Check extracted template header status
602: FUNCTION checkExtTemplateHeaderStatus(pTemplateName IN VARCHAR2,

Line 612: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

608: xStatus PLS_INTEGER := VALID_FOR_EXTRACT;
609: xRtCategoryId NUMBER;
610:
611: BEGIN
612: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
613: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
614: 'checkExtTemplateHeaderStatus(pTemplateName: ' || pTemplateName || ')');
615: END IF;
616:

Line 613: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

609: xRtCategoryId NUMBER;
610:
611: BEGIN
612: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
613: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
614: 'checkExtTemplateHeaderStatus(pTemplateName: ' || pTemplateName || ')');
615: END IF;
616:
617: xErrLoc := 100;

Line 634: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

630:
631: xErrLoc := 150;
632: pMessage := constructMessage(xStatus, gOperatingUnitName,
633: pTemplateName, pItemNum);
634: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
635: RETURN xStatus;
636: END;
637: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
638: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 637: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

633: pTemplateName, pItemNum);
634: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
635: RETURN xStatus;
636: END;
637: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
638: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
639: 'Template header extracted as rt_category_id: '||xRtCategoryId);
640: END IF;
641:

Line 638: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

634: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
635: RETURN xStatus;
636: END;
637: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
638: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
639: 'Template header extracted as rt_category_id: '||xRtCategoryId);
640: END IF;
641:
642: xErrLoc := 400;

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 648: raise ICX_POR_EXT_UTL.gException;

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:
651: -- Check blanket/quotation status
652: FUNCTION checkContractLineStatus(pType IN VARCHAR2,

Line 667: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

663: xCategoryId NUMBER;
664: xOperatingUnit hr_operating_units.name%TYPE;
665:
666: BEGIN
667: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
668: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
669: 'checkContractLineStatus(pType: ' || pType ||
670: ', pOperatingUnitId: ' || pOperatingUnitId ||
671: ', pPONum: ' || pPONum ||

Line 668: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

664: xOperatingUnit hr_operating_units.name%TYPE;
665:
666: BEGIN
667: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
668: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
669: 'checkContractLineStatus(pType: ' || pType ||
670: ', pOperatingUnitId: ' || pOperatingUnitId ||
671: ', pPONum: ' || pPONum ||
672: ', pLineNum: ' || pLineNum || ')');

Line 713: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

709: END IF;
710: xErrLoc := 150;
711: pMessage := constructMessage(xStatus, xOperatingUnit,
712: pPONum, pLineNum);
713: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
714: RETURN xStatus;
715: END;
716: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
717: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 716: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

712: pPONum, pLineNum);
713: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
714: RETURN xStatus;
715: END;
716: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
717: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
718: 'Contract line found ' || xContractLineId ||
719: ' with status: ' || xStatus);
720: END IF;

Line 717: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

713: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
714: RETURN xStatus;
715: END;
716: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
717: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
718: 'Contract line found ' || xContractLineId ||
719: ' with status: ' || xStatus);
720: END IF;
721:

Line 726: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

722: xErrLoc := 200;
723: IF (xStatus <> VALID_FOR_EXTRACT) THEN
724: pMessage := constructMessage(xStatus, xOperatingUnit,
725: pPONum, xItemNum);
726: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
727: RETURN xStatus;
728: END IF;
729:
730: xErrLoc := 400;

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 737: raise ICX_POR_EXT_UTL.gException;

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:
740: -- Check template status
741: FUNCTION checkTemplateLineStatus(pOperatingUnitId IN NUMBER,

Line 754: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

750: xCategoryId NUMBER;
751: xOperatingUnit hr_operating_units.name%TYPE;
752:
753: BEGIN
754: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
755: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
756: 'checkTemplateLineStatus(pOperatingUnitId: ' || pOperatingUnitId ||
757: ', pTemplateName: ' || pTemplateName ||
758: ', pLineNum: ' || pLineNum || ')');

Line 755: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

751: xOperatingUnit hr_operating_units.name%TYPE;
752:
753: BEGIN
754: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
755: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
756: 'checkTemplateLineStatus(pOperatingUnitId: ' || pOperatingUnitId ||
757: ', pTemplateName: ' || pTemplateName ||
758: ', pLineNum: ' || pLineNum || ')');
759: END IF;

Line 797: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

793: xStatus := INVALID_TEMPLATE_LINE;
794: xErrLoc := 150;
795: pMessage := constructMessage(xStatus, xOperatingUnit,
796: pTemplateName, pLineNum);
797: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
798: RETURN xStatus;
799: END;
800: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
801: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 800: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

796: pTemplateName, pLineNum);
797: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
798: RETURN xStatus;
799: END;
800: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
801: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
802: 'Tempalte line found with status: ' || xStatus);
803: END IF;
804:

Line 801: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

797: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
798: RETURN xStatus;
799: END;
800: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
801: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
802: 'Tempalte line found with status: ' || xStatus);
803: END IF;
804:
805: xErrLoc := 200;

Line 809: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

805: xErrLoc := 200;
806: IF (xStatus <> VALID_FOR_EXTRACT) THEN
807: pMessage := constructMessage(xStatus, xOperatingUnit,
808: pTemplateName, xItemNum);
809: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
810: RETURN xStatus;
811: END IF;
812:
813: xErrLoc := 400;

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 826: raise ICX_POR_EXT_UTL.gException;

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:
829: -- Check ASL status
830: FUNCTION checkASLStatus(pOperatingUnitId IN NUMBER,

Line 844: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

840: xCategoryId NUMBER;
841: xOperatingUnit hr_operating_units.name%TYPE;
842:
843: BEGIN
844: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
845: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
846: 'checkASLStatus(pOperatingUnitId: ' || pOperatingUnitId ||
847: ', pASLId: ' || pASLId || ')');
848: END IF;

Line 845: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

841: xOperatingUnit hr_operating_units.name%TYPE;
842:
843: BEGIN
844: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
845: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
846: 'checkASLStatus(pOperatingUnitId: ' || pOperatingUnitId ||
847: ', pASLId: ' || pASLId || ')');
848: END IF;
849:

Line 892: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

888: xStatus := INVALID_ASL;
889: xErrLoc := 150;
890: pMessage := constructMessage(xStatus, xOperatingUnit,
891: pASLId, NULL);
892: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
893: RETURN xStatus;
894: END;
895: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
896: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 895: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

891: pASLId, NULL);
892: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
893: RETURN xStatus;
894: END;
895: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
896: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
897: 'ASL found with status: ' || xStatus);
898: END IF;
899:

Line 896: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

892: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
893: RETURN xStatus;
894: END;
895: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
896: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
897: 'ASL found with status: ' || xStatus);
898: END IF;
899:
900: xErrLoc := 200;

Line 904: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

900: xErrLoc := 200;
901: IF (xStatus <> VALID_FOR_EXTRACT) THEN
902: pMessage := constructMessage(xStatus, xOrgName,
903: xSupplier, xItemNum);
904: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
905: RETURN xStatus;
906: END IF;
907:
908: xErrLoc := 400;

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 915: raise ICX_POR_EXT_UTL.gException;

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:
918: -- Check master item status
919: FUNCTION checkMasterStatus(pOperatingUnitId IN NUMBER,

Line 936: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

932: xLoadInternal VARCHAR2(1);
933: xOperatingUnit hr_operating_units.name%TYPE;
934:
935: BEGIN
936: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
937: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
938: 'checkMasterStatus(pOperatingUnitId: ' || pOperatingUnitId ||
939: ', pItemNum: ' || pItemNum || ')');
940: END IF;

Line 937: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

933: xOperatingUnit hr_operating_units.name%TYPE;
934:
935: BEGIN
936: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
937: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
938: 'checkMasterStatus(pOperatingUnitId: ' || pOperatingUnitId ||
939: ', pItemNum: ' || pItemNum || ')');
940: END IF;
941:

Line 979: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

975: xStatus := INVALID_ITEM;
976: xErrLoc := 150;
977: pMessage := constructMessage(xStatus, xOperatingUnit,
978: NULL, pItemNum);
979: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
980: RETURN xStatus;
981: END;
982: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
983: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 982: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

978: NULL, pItemNum);
979: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
980: RETURN xStatus;
981: END;
982: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
983: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
984: 'Item found ' || xItemId || ' with purchasing status: ' ||
985: xStatus1 || ', internal status: ' || xStatus2);
986: END IF;

Line 983: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

979: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
980: RETURN xStatus;
981: END;
982: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
983: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
984: 'Item found ' || xItemId || ' with purchasing status: ' ||
985: xStatus1 || ', internal status: ' || xStatus2);
986: END IF;
987:

Line 1013: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

1009:
1010: IF (xStatus <> VALID_FOR_EXTRACT) THEN
1011: pMessage := constructMessage(xStatus, xOrgName,
1012: NULL, pItemNum);
1013: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
1014: RETURN xStatus;
1015: END IF;
1016:
1017: xErrLoc := 400;

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 1024: raise ICX_POR_EXT_UTL.gException;

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:
1027: FUNCTION getStatusString(pStatus IN NUMBER)
1028: RETURN VARCHAR2

Line 1135: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

1131: xOperatingUnitId PLS_INTEGER;
1132: xType VARCHAR2(20);
1133:
1134: BEGIN
1135: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1136: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1137: 'checkClassStatus(pType: ' || pType ||
1138: ', pValue: ' || pValue || ')');
1139: END IF;

Line 1136: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

1132: xType VARCHAR2(20);
1133:
1134: BEGIN
1135: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1136: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1137: 'checkClassStatus(pType: ' || pType ||
1138: ', pValue: ' || pValue || ')');
1139: END IF;
1140:

Line 1151: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

1147: gStructureId
1148: FROM mtl_default_sets_view
1149: WHERE functional_area_id = 2;
1150:
1151: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1152: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1153: 'Category Set Information[category_set_id: ' || gCategorySetId ||
1154: ', validate_flag: ' || gValidateFlag ||
1155: ', structure_id: ' || gStructureId || ']');

Line 1152: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

1148: FROM mtl_default_sets_view
1149: WHERE functional_area_id = 2;
1150:
1151: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1152: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1153: 'Category Set Information[category_set_id: ' || gCategorySetId ||
1154: ', validate_flag: ' || gValidateFlag ||
1155: ', structure_id: ' || gStructureId || ']');
1156: END IF;

Line 1168: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

1164: RETURN checkTemplateHeaderStatus(pValue, pMessage);
1165: ELSE
1166: xStatus := INVALID_TYPE;
1167: pMessage := 'Invalid type: ' || pType;
1168: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
1169:
1170: RETURN xStatus;
1171: END IF;
1172:

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 1178: ICX_POR_EXT_UTL.printStackTrace;

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;
1181:
1182: -- Check classification status

Line 1179: raise ICX_POR_EXT_UTL.gException;

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;
1181:
1182: -- Check classification status
1183: FUNCTION checkClassStatus(pType IN VARCHAR2,

Line 1209: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

1205: xBusinessGroupId PLS_INTEGER;
1206: xOperatingUnitId PLS_INTEGER;
1207:
1208: BEGIN
1209: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1210: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1211: 'checkItemStatus(pBusinessGroup: ' || pBusinessGroup ||
1212: ', pOperatingUnit: ' || pOperatingUnit ||
1213: ', pType: ' || pType ||

Line 1210: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

1206: xOperatingUnitId PLS_INTEGER;
1207:
1208: BEGIN
1209: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1210: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1211: 'checkItemStatus(pBusinessGroup: ' || pBusinessGroup ||
1212: ', pOperatingUnit: ' || pOperatingUnit ||
1213: ', pType: ' || pType ||
1214: ', pValue1: ' || NVL(pValue1, 'NULL') ||

Line 1229: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: xStatus := INVALID_BUSINESS_GROUP;
1228: pMessage := 'Invalid business group: ' || pBusinessGroup;
1229: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
1230: RETURN xStatus;
1231: END;
1232: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1233: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 1232: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

1228: pMessage := 'Invalid business group: ' || pBusinessGroup;
1229: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
1230: RETURN xStatus;
1231: END;
1232: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1233: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1234: 'Business group found with business_group_id: ' || xBusinessGroupId);
1235: END IF;
1236:

Line 1233: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

1229: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
1230: RETURN xStatus;
1231: END;
1232: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1233: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1234: 'Business group found with business_group_id: ' || xBusinessGroupId);
1235: END IF;
1236:
1237: xErrLoc := 200;

Line 1249: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: xStatus := INVALID_OPERATING_UNIT;
1248: pMessage := 'Invalid operating unit: ' || pOperatingUnit;
1249: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
1250: RETURN xStatus;
1251: END;
1252:
1253: xErrLoc := 300;

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 1262: ICX_POR_EXT_UTL.printStackTrace;

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;
1265:
1266: -- Check item status

Line 1263: raise ICX_POR_EXT_UTL.gException;

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;
1265:
1266: -- Check item status
1267: FUNCTION checkItemStatus(pOperatingUnitId IN NUMBER,

Line 1279: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

1275: xStatus PLS_INTEGER := VALID_FOR_EXTRACT;
1276: xType VARCHAR2(20);
1277:
1278: BEGIN
1279: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1280: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1281: 'checkItemStatus(pOperatingUnitID: ' || pOperatingUnitId ||
1282: ', pType: ' || pType ||
1283: ', pValue1: ' || NVL(pValue1, 'NULL') ||

Line 1280: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

1276: xType VARCHAR2(20);
1277:
1278: BEGIN
1279: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1280: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1281: 'checkItemStatus(pOperatingUnitID: ' || pOperatingUnitId ||
1282: ', pType: ' || pType ||
1283: ', pValue1: ' || NVL(pValue1, 'NULL') ||
1284: ', pValue2: ' || NVL(pValue2, 'NULL') || ')');

Line 1297: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

1293: gStructureId
1294: FROM mtl_default_sets_view
1295: WHERE functional_area_id = 2;
1296:
1297: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1298: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1299: 'Category Set Information[category_set_id: ' || gCategorySetId ||
1300: ', validate_flag: ' || gValidateFlag ||
1301: ', structure_id: ' || gStructureId || ']');

Line 1298: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

1294: FROM mtl_default_sets_view
1295: WHERE functional_area_id = 2;
1296:
1297: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
1298: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,
1299: 'Category Set Information[category_set_id: ' || gCategorySetId ||
1300: ', validate_flag: ' || gValidateFlag ||
1301: ', structure_id: ' || gStructureId || ']');
1302: END IF;

Line 1321: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);

1317: RETURN checkMasterStatus(pOperatingUnitId, pValue1, pMessage);
1318: ELSE
1319: xStatus := INVALID_TYPE;
1320: pMessage := 'Invalid type: ' || pType;
1321: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.ERROR_LEVEL, pMessage);
1322: RETURN xStatus;
1323: END IF;
1324:
1325: xErrLoc := 300;

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 1331: ICX_POR_EXT_UTL.printStackTrace;

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;
1334:
1335: -- Check item status

Line 1332: raise ICX_POR_EXT_UTL.gException;

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;
1334:
1335: -- Check item status
1336: FUNCTION checkItemStatus(pBusinessGroup IN VARCHAR2,