DBA Data[Home] [Help]

APPS.WIP_FLOW_UTILITIES dependencies on WIP_FLOW_VALIDATION

Line 431: IF (Wip_Flow_Validation.primary_item_id(p_rowid => p_rowid) = 0 ) THEN

427: 1. The messages are being set in this routine because the actual validation routines may be called by planning.
428: 2. I am reusing the "ML" messages instead of creating new ones because the message text fits this validation also.
429: */
430:
431: IF (Wip_Flow_Validation.primary_item_id(p_rowid => p_rowid) = 0 ) THEN
432: fnd_message.set_name('WIP', 'WIP_CANNOT_BUILD_ITEM');
433:
434: ELSIF (Wip_Flow_Validation.class_code(p_rowid => p_rowid) = 0 ) THEN
435: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');

Line 434: ELSIF (Wip_Flow_Validation.class_code(p_rowid => p_rowid) = 0 ) THEN

430:
431: IF (Wip_Flow_Validation.primary_item_id(p_rowid => p_rowid) = 0 ) THEN
432: fnd_message.set_name('WIP', 'WIP_CANNOT_BUILD_ITEM');
433:
434: ELSIF (Wip_Flow_Validation.class_code(p_rowid => p_rowid) = 0 ) THEN
435: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');
436:
437: ELSIF (Wip_Flow_Validation.bom_rev_date(p_rowid => p_rowid) = 0 ) THEN
438: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');

Line 437: ELSIF (Wip_Flow_Validation.bom_rev_date(p_rowid => p_rowid) = 0 ) THEN

433:
434: ELSIF (Wip_Flow_Validation.class_code(p_rowid => p_rowid) = 0 ) THEN
435: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');
436:
437: ELSIF (Wip_Flow_Validation.bom_rev_date(p_rowid => p_rowid) = 0 ) THEN
438: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');
439:
440: ELSIF (Wip_Flow_Validation.bom_revision(p_rowid => p_rowid) = 0 ) THEN
441: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');

Line 440: ELSIF (Wip_Flow_Validation.bom_revision(p_rowid => p_rowid) = 0 ) THEN

436:
437: ELSIF (Wip_Flow_Validation.bom_rev_date(p_rowid => p_rowid) = 0 ) THEN
438: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');
439:
440: ELSIF (Wip_Flow_Validation.bom_revision(p_rowid => p_rowid) = 0 ) THEN
441: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');
442:
443: ELSIF (Wip_Flow_Validation.rout_rev_date(p_rowid => p_rowid) = 0 ) THEN
444: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');

Line 443: ELSIF (Wip_Flow_Validation.rout_rev_date(p_rowid => p_rowid) = 0 ) THEN

439:
440: ELSIF (Wip_Flow_Validation.bom_revision(p_rowid => p_rowid) = 0 ) THEN
441: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');
442:
443: ELSIF (Wip_Flow_Validation.rout_rev_date(p_rowid => p_rowid) = 0 ) THEN
444: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');
445:
446: ELSIF (Wip_Flow_Validation.routing_revision(p_rowid => p_rowid) = 0 ) THEN
447: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');

Line 446: ELSIF (Wip_Flow_Validation.routing_revision(p_rowid => p_rowid) = 0 ) THEN

442:
443: ELSIF (Wip_Flow_Validation.rout_rev_date(p_rowid => p_rowid) = 0 ) THEN
444: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');
445:
446: ELSIF (Wip_Flow_Validation.routing_revision(p_rowid => p_rowid) = 0 ) THEN
447: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');
448:
449: ELSIF (Wip_Flow_Validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) THEN
450: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');

Line 449: ELSIF (Wip_Flow_Validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) THEN

445:
446: ELSIF (Wip_Flow_Validation.routing_revision(p_rowid => p_rowid) = 0 ) THEN
447: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');
448:
449: ELSIF (Wip_Flow_Validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) THEN
450: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
451:
452: ELSIF (Wip_Flow_Validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) THEN
453: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');

Line 452: ELSIF (Wip_Flow_Validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) THEN

448:
449: ELSIF (Wip_Flow_Validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) THEN
450: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
451:
452: ELSIF (Wip_Flow_Validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) THEN
453: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
454:
455: ELSIF (Wip_Flow_Validation.completion_sub(p_rowid => p_rowid) = 0 ) THEN
456: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');

Line 455: ELSIF (Wip_Flow_Validation.completion_sub(p_rowid => p_rowid) = 0 ) THEN

451:
452: ELSIF (Wip_Flow_Validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) THEN
453: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
454:
455: ELSIF (Wip_Flow_Validation.completion_sub(p_rowid => p_rowid) = 0 ) THEN
456: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');
457:
458: ELSIF (Wip_Flow_Validation.completion_locator_id(p_rowid => p_rowid) = 0 ) THEN
459: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');

Line 458: ELSIF (Wip_Flow_Validation.completion_locator_id(p_rowid => p_rowid) = 0 ) THEN

454:
455: ELSIF (Wip_Flow_Validation.completion_sub(p_rowid => p_rowid) = 0 ) THEN
456: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');
457:
458: ELSIF (Wip_Flow_Validation.completion_locator_id(p_rowid => p_rowid) = 0 ) THEN
459: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');
460:
461: ELSIF (Wip_Flow_Validation.demand_class(p_rowid => p_rowid) = 0 ) THEN
462: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');

Line 461: ELSIF (Wip_Flow_Validation.demand_class(p_rowid => p_rowid) = 0 ) THEN

457:
458: ELSIF (Wip_Flow_Validation.completion_locator_id(p_rowid => p_rowid) = 0 ) THEN
459: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');
460:
461: ELSIF (Wip_Flow_Validation.demand_class(p_rowid => p_rowid) = 0 ) THEN
462: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
463:
464: ELSIF (Wip_Flow_Validation.schedule_group_id(p_rowid => p_rowid) = 0 ) THEN
465: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');

Line 464: ELSIF (Wip_Flow_Validation.schedule_group_id(p_rowid => p_rowid) = 0 ) THEN

460:
461: ELSIF (Wip_Flow_Validation.demand_class(p_rowid => p_rowid) = 0 ) THEN
462: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
463:
464: ELSIF (Wip_Flow_Validation.schedule_group_id(p_rowid => p_rowid) = 0 ) THEN
465: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
466:
467: ELSIF (Wip_Flow_Validation.build_sequence(p_rowid => p_rowid) = 0 ) THEN
468: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');

Line 467: ELSIF (Wip_Flow_Validation.build_sequence(p_rowid => p_rowid) = 0 ) THEN

463:
464: ELSIF (Wip_Flow_Validation.schedule_group_id(p_rowid => p_rowid) = 0 ) THEN
465: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
466:
467: ELSIF (Wip_Flow_Validation.build_sequence(p_rowid => p_rowid) = 0 ) THEN
468: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');
469:
470: ELSIF (Wip_Flow_Validation.line_id(p_rowid => p_rowid) = 0 ) THEN
471: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');

Line 470: ELSIF (Wip_Flow_Validation.line_id(p_rowid => p_rowid) = 0 ) THEN

466:
467: ELSIF (Wip_Flow_Validation.build_sequence(p_rowid => p_rowid) = 0 ) THEN
468: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');
469:
470: ELSIF (Wip_Flow_Validation.line_id(p_rowid => p_rowid) = 0 ) THEN
471: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
472:
473: ELSIF (Wip_Flow_Validation.project_id(p_rowid => p_rowid) = 0 ) THEN
474: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');

Line 473: ELSIF (Wip_Flow_Validation.project_id(p_rowid => p_rowid) = 0 ) THEN

469:
470: ELSIF (Wip_Flow_Validation.line_id(p_rowid => p_rowid) = 0 ) THEN
471: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
472:
473: ELSIF (Wip_Flow_Validation.project_id(p_rowid => p_rowid) = 0 ) THEN
474: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');
475:
476: ELSIF (Wip_Flow_Validation.task_id(p_rowid => p_rowid) = 0 ) THEN
477: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');

Line 476: ELSIF (Wip_Flow_Validation.task_id(p_rowid => p_rowid) = 0 ) THEN

472:
473: ELSIF (Wip_Flow_Validation.project_id(p_rowid => p_rowid) = 0 ) THEN
474: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');
475:
476: ELSIF (Wip_Flow_Validation.task_id(p_rowid => p_rowid) = 0 ) THEN
477: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');
478:
479: ELSIF (Wip_Flow_Validation.schedule_number(p_rowid => p_rowid) = 0 ) THEN
480: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');

Line 479: ELSIF (Wip_Flow_Validation.schedule_number(p_rowid => p_rowid) = 0 ) THEN

475:
476: ELSIF (Wip_Flow_Validation.task_id(p_rowid => p_rowid) = 0 ) THEN
477: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');
478:
479: ELSIF (Wip_Flow_Validation.schedule_number(p_rowid => p_rowid) = 0 ) THEN
480: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
481:
482: ELSIF (Wip_Flow_Validation.scheduled_flag(p_rowid => p_rowid) = 0 ) THEN
483: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULED_FLAG');

Line 482: ELSIF (Wip_Flow_Validation.scheduled_flag(p_rowid => p_rowid) = 0 ) THEN

478:
479: ELSIF (Wip_Flow_Validation.schedule_number(p_rowid => p_rowid) = 0 ) THEN
480: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
481:
482: ELSIF (Wip_Flow_Validation.scheduled_flag(p_rowid => p_rowid) = 0 ) THEN
483: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULED_FLAG');
484:
485: ELSIF (Wip_Flow_Validation.unit_number(p_rowid => p_rowid) = 0 ) THEN
486: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');

Line 485: ELSIF (Wip_Flow_Validation.unit_number(p_rowid => p_rowid) = 0 ) THEN

481:
482: ELSIF (Wip_Flow_Validation.scheduled_flag(p_rowid => p_rowid) = 0 ) THEN
483: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULED_FLAG');
484:
485: ELSIF (Wip_Flow_Validation.unit_number(p_rowid => p_rowid) = 0 ) THEN
486: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');
487:
488: ELSE
489: RETURN 1;

Line 857: if (wip_flow_validation.schedule_number(

853:
854:
855: elsif (flow_rec.scheduled_flag = 3) then
856:
857: if (wip_flow_validation.schedule_number(
858: p_rowid => flow_rec.rowid ) = 0 ) then
859:
860: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
861: