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.WIP_SCHEDULING dependencies on WIP_MASS_LOAD_UTILITIES

Line 459: WIP_MASS_LOAD_UTILITIES.Error

455: BEGIN
456:
457: -- Jobs must exist and be status 1,3,4,6
458:
459: WIP_MASS_LOAD_UTILITIES.Error
460: (P_Group_Id,
461: 'WIP_SCHEDULING_INTERFACE WSI',
462: WIP_CONSTANTS.ERROR,
463: ' NOT EXISTS

Line 469: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

465: FROM WIP_DISCRETE_JOBS WDJ
466: WHERE WDJ.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
467: AND WDJ.ORGANIZATION_ID = WSI.ORGANIZATION_ID
468: AND WDJ.STATUS_TYPE IN (1,3,4,6)) ',
469: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
470: 'WIP_SI_INVALID_JOB');
471:
472: END VALIDATE_JOBS;
473:

Line 479: WIP_MASS_LOAD_UTILITIES.Error

475: BEGIN
476:
477: -- Scheduling level must be 1 (operation) or 2 (resource)
478:
479: WIP_MASS_LOAD_UTILITIES.Error
480: (P_Group_Id,
481: 'WIP_SCHEDULING_INTERFACE WSI',
482: WIP_CONSTANTS.ERROR,
483: ' SCHEDULING_LEVEL NOT IN (1,2) ',

Line 484: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

480: (P_Group_Id,
481: 'WIP_SCHEDULING_INTERFACE WSI',
482: WIP_CONSTANTS.ERROR,
483: ' SCHEDULING_LEVEL NOT IN (1,2) ',
484: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
485: 'WIP_SI_INVALID_SCHED_LEVEL');
486:
487: END VALIDATE_SCHEDULING_LEVEL;
488:

Line 494: WIP_MASS_LOAD_UTILITIES.Error

490: BEGIN
491:
492: -- Give Error if dates are null or if start date > comp date
493:
494: WIP_MASS_LOAD_UTILITIES.Error
495: (P_Group_Id,
496: 'WIP_SCHEDULING_INTERFACE WSI',
497: WIP_CONSTANTS.ERROR,
498: ' ((WSI.SCHEDULING_LEVEL = 2

Line 500: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

496: 'WIP_SCHEDULING_INTERFACE WSI',
497: WIP_CONSTANTS.ERROR,
498: ' ((WSI.SCHEDULING_LEVEL = 2
499: AND WSI.USAGE_RATE_OR_AMOUNT < 0)) ',
500: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
501: 'WIP_SI_INVALID_RATE');
502:
503: END VALIDATE_USAGE_RATE;
504:

Line 510: WIP_MASS_LOAD_UTILITIES.Error

506: BEGIN
507:
508: -- Give Error if dates are null or if start date > comp date
509:
510: WIP_MASS_LOAD_UTILITIES.Error
511: (P_Group_Id,
512: 'WIP_SCHEDULING_INTERFACE WSI',
513: WIP_CONSTANTS.ERROR,
514: ' ((WSI.SCHEDULING_LEVEL = 1

Line 524: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

520: AND( (WSI.RESOURCE_COMPLETION_DATE IS NULL
521: OR WSI.RESOURCE_START_DATE IS NULL)
522: OR (WSI.RESOURCE_START_DATE >
523: WSI.RESOURCE_COMPLETION_DATE)))) ',
524: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
525: 'WIP_SI_INVALID_DATES');
526:
527: END VALIDATE_DATES;
528:

Line 533: WIP_MASS_LOAD_UTILITIES.Error

529: PROCEDURE VALIDATE_OPS_RES_MATCH
530: (P_GROUP_ID NUMBER) IS
531: BEGIN
532: -- Need to worry about erroring out 1 ==> erroring out all
533: WIP_MASS_LOAD_UTILITIES.Error
534: (P_Group_Id,
535: 'WIP_SCHEDULING_INTERFACE WSI',
536: WIP_CONSTANTS.ERROR,
537: ' WSI.SCHEDULING_LEVEL = 1

Line 551: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

547: SELECT OPERATION_SEQ_NUM
548: FROM WIP_OPERATIONS WO
549: WHERE WO.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
550: AND WO.ORGANIZATION_ID = WSI.ORGANIZATION_ID) ',
551: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
552: 'WIP_SI_INVALID_OPS');
553:
554: WIP_MASS_LOAD_UTILITIES.Error
555: (P_Group_Id,

Line 554: WIP_MASS_LOAD_UTILITIES.Error

550: AND WO.ORGANIZATION_ID = WSI.ORGANIZATION_ID) ',
551: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
552: 'WIP_SI_INVALID_OPS');
553:
554: WIP_MASS_LOAD_UTILITIES.Error
555: (P_Group_Id,
556: 'WIP_SCHEDULING_INTERFACE WSI',
557: WIP_CONSTANTS.ERROR,
558: ' WSI.SCHEDULING_LEVEL = 1

Line 572: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

568: AND SI2.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
569: AND SI2.ORGANIZATION_ID = WSI.ORGANIZATION_ID
570: AND SI2.PROCESS_PHASE = 2
571: AND SI2.PROCESS_STATUS = 2) ',
572: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
573: 'WIP_SI_INVALID_OPS');
574:
575: WIP_MASS_LOAD_UTILITIES.Error
576: (P_Group_Id,

Line 575: WIP_MASS_LOAD_UTILITIES.Error

571: AND SI2.PROCESS_STATUS = 2) ',
572: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
573: 'WIP_SI_INVALID_OPS');
574:
575: WIP_MASS_LOAD_UTILITIES.Error
576: (P_Group_Id,
577: 'WIP_SCHEDULING_INTERFACE WSI',
578: WIP_CONSTANTS.ERROR,
579: ' WSI.SCHEDULING_LEVEL = 2

Line 594: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

590: FROM WIP_OPERATION_RESOURCES WOR
591: WHERE WOR.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
592: AND WOR.ORGANIZATION_ID = WSI.ORGANIZATION_ID
593: ) ',
594: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
595: 'WIP_SI_INVALID_RES');
596:
597: WIP_MASS_LOAD_UTILITIES.Error
598: (P_Group_Id,

Line 597: WIP_MASS_LOAD_UTILITIES.Error

593: ) ',
594: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
595: 'WIP_SI_INVALID_RES');
596:
597: WIP_MASS_LOAD_UTILITIES.Error
598: (P_Group_Id,
599: 'WIP_SCHEDULING_INTERFACE WSI',
600: WIP_CONSTANTS.ERROR,
601: ' WSI.SCHEDULING_LEVEL = 2

Line 616: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

612: AND SI2.ORGANIZATION_ID = WSI.ORGANIZATION_ID
613: AND SI2.PROCESS_PHASE = 2
614: AND SI2.PROCESS_STATUS = 2
615: )',
616: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
617: 'WIP_SI_INVALID_RES');
618:
619: END VALIDATE_OPS_RES_MATCH;
620:

Line 625: WIP_MASS_LOAD_UTILITIES.Error

621: /* If any record for a job is invalid, we must error out ALL records for that job */
622: PROCEDURE ERROR_ALL_IF_ANY
623: (P_GROUP_ID NUMBER) IS
624: BEGIN
625: WIP_MASS_LOAD_UTILITIES.Error
626: (P_Group_Id,
627: 'WIP_SCHEDULING_INTERFACE WSI',
628: WIP_CONSTANTS.ERROR,
629: ' EXISTS (SELECT 1

Line 634: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,

630: FROM WIP_SCHEDULING_INTERFACE WSI2
631: WHERE WSI2.GROUP_ID = WSI.GROUP_ID
632: AND WSI2.WIP_ENTITY_ID = WSI.WIP_ENTITY_ID
633: AND WSI2.PROCESS_STATUS = 3) ',
634: WIP_MASS_LOAD_UTILITIES.MSG_ERROR,
635: 'WIP_SI_OTHERS_FAILED');
636: END ERROR_ALL_IF_ANY;
637:
638: PROCEDURE UPDATE_REQ_DATES(P_WIP_ENTITY_ID NUMBER,