DBA Data[Home] [Help]

APPS.WIP_FLOWUTIL_PRIV dependencies on WIP_FLOW_VALIDATION

Line 506: if ( wip_flow_validation.primary_item_id(p_rowid => p_rowid) = 0 ) then

502: l_interfaceID
503: from mtl_transactions_interface
504: where rowid = p_rowid;
505:
506: if ( wip_flow_validation.primary_item_id(p_rowid => p_rowid) = 0 ) then
507: fnd_message.set_name('WIP', 'WIP_CANNOT_BUILD_ITEM');
508:
509: elsif (wip_flow_validation.class_code(p_rowid => p_rowid) = 0 ) then
510: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');

Line 509: elsif (wip_flow_validation.class_code(p_rowid => p_rowid) = 0 ) then

505:
506: if ( wip_flow_validation.primary_item_id(p_rowid => p_rowid) = 0 ) then
507: fnd_message.set_name('WIP', 'WIP_CANNOT_BUILD_ITEM');
508:
509: elsif (wip_flow_validation.class_code(p_rowid => p_rowid) = 0 ) then
510: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');
511:
512: elsif (wip_flow_validation.bom_rev_date(p_rowid => p_rowid) = 0 ) then
513: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');

Line 512: elsif (wip_flow_validation.bom_rev_date(p_rowid => p_rowid) = 0 ) then

508:
509: elsif (wip_flow_validation.class_code(p_rowid => p_rowid) = 0 ) then
510: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');
511:
512: elsif (wip_flow_validation.bom_rev_date(p_rowid => p_rowid) = 0 ) then
513: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');
514:
515: elsif (wip_flow_validation.bom_revision(p_rowid => p_rowid) = 0 ) then
516: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');

Line 515: elsif (wip_flow_validation.bom_revision(p_rowid => p_rowid) = 0 ) then

511:
512: elsif (wip_flow_validation.bom_rev_date(p_rowid => p_rowid) = 0 ) then
513: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');
514:
515: elsif (wip_flow_validation.bom_revision(p_rowid => p_rowid) = 0 ) then
516: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');
517:
518: elsif (wip_flow_validation.rout_rev_date(p_rowid => p_rowid) = 0 ) then
519: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');

Line 518: elsif (wip_flow_validation.rout_rev_date(p_rowid => p_rowid) = 0 ) then

514:
515: elsif (wip_flow_validation.bom_revision(p_rowid => p_rowid) = 0 ) then
516: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');
517:
518: elsif (wip_flow_validation.rout_rev_date(p_rowid => p_rowid) = 0 ) then
519: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');
520:
521: elsif (wip_flow_validation.routing_revision(p_rowid => p_rowid) = 0 ) then
522: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');

Line 521: elsif (wip_flow_validation.routing_revision(p_rowid => p_rowid) = 0 ) then

517:
518: elsif (wip_flow_validation.rout_rev_date(p_rowid => p_rowid) = 0 ) then
519: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');
520:
521: elsif (wip_flow_validation.routing_revision(p_rowid => p_rowid) = 0 ) then
522: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');
523:
524: elsif (wip_flow_validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) then
525: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');

Line 524: elsif (wip_flow_validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) then

520:
521: elsif (wip_flow_validation.routing_revision(p_rowid => p_rowid) = 0 ) then
522: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');
523:
524: elsif (wip_flow_validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) then
525: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
526:
527: elsif (wip_flow_validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) then
528: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');

Line 527: elsif (wip_flow_validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) then

523:
524: elsif (wip_flow_validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) then
525: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
526:
527: elsif (wip_flow_validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) then
528: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
529:
530: elsif (wip_flow_validation.completion_sub(p_rowid => p_rowid) = 0 ) then
531: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');

Line 530: elsif (wip_flow_validation.completion_sub(p_rowid => p_rowid) = 0 ) then

526:
527: elsif (wip_flow_validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) then
528: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
529:
530: elsif (wip_flow_validation.completion_sub(p_rowid => p_rowid) = 0 ) then
531: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');
532:
533: elsif (wip_flow_validation.completion_locator_id(p_rowid => p_rowid) = 0 ) then
534: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');

Line 533: elsif (wip_flow_validation.completion_locator_id(p_rowid => p_rowid) = 0 ) then

529:
530: elsif (wip_flow_validation.completion_sub(p_rowid => p_rowid) = 0 ) then
531: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');
532:
533: elsif (wip_flow_validation.completion_locator_id(p_rowid => p_rowid) = 0 ) then
534: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');
535:
536: elsif (wip_flow_validation.demand_class(p_rowid => p_rowid) = 0 ) then
537: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');

Line 536: elsif (wip_flow_validation.demand_class(p_rowid => p_rowid) = 0 ) then

532:
533: elsif (wip_flow_validation.completion_locator_id(p_rowid => p_rowid) = 0 ) then
534: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');
535:
536: elsif (wip_flow_validation.demand_class(p_rowid => p_rowid) = 0 ) then
537: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
538:
539: elsif (wip_flow_validation.schedule_group_id(p_rowid => p_rowid) = 0 ) then
540: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');

Line 539: elsif (wip_flow_validation.schedule_group_id(p_rowid => p_rowid) = 0 ) then

535:
536: elsif (wip_flow_validation.demand_class(p_rowid => p_rowid) = 0 ) then
537: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
538:
539: elsif (wip_flow_validation.schedule_group_id(p_rowid => p_rowid) = 0 ) then
540: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
541:
542: elsif (wip_flow_validation.build_sequence(p_rowid => p_rowid) = 0 ) then
543: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');

Line 542: elsif (wip_flow_validation.build_sequence(p_rowid => p_rowid) = 0 ) then

538:
539: elsif (wip_flow_validation.schedule_group_id(p_rowid => p_rowid) = 0 ) then
540: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
541:
542: elsif (wip_flow_validation.build_sequence(p_rowid => p_rowid) = 0 ) then
543: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');
544:
545: elsif (wip_flow_validation.line_id(p_rowid => p_rowid) = 0 ) then
546: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');

Line 545: elsif (wip_flow_validation.line_id(p_rowid => p_rowid) = 0 ) then

541:
542: elsif (wip_flow_validation.build_sequence(p_rowid => p_rowid) = 0 ) then
543: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');
544:
545: elsif (wip_flow_validation.line_id(p_rowid => p_rowid) = 0 ) then
546: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
547:
548: elsif (wip_flow_validation.project_id(p_rowid => p_rowid) = 0 ) then
549: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');

Line 548: elsif (wip_flow_validation.project_id(p_rowid => p_rowid) = 0 ) then

544:
545: elsif (wip_flow_validation.line_id(p_rowid => p_rowid) = 0 ) then
546: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
547:
548: elsif (wip_flow_validation.project_id(p_rowid => p_rowid) = 0 ) then
549: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');
550:
551: elsif (wip_flow_validation.task_id(p_rowid => p_rowid) = 0 ) then
552: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');

Line 551: elsif (wip_flow_validation.task_id(p_rowid => p_rowid) = 0 ) then

547:
548: elsif (wip_flow_validation.project_id(p_rowid => p_rowid) = 0 ) then
549: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');
550:
551: elsif (wip_flow_validation.task_id(p_rowid => p_rowid) = 0 ) then
552: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');
553:
554: elsif (wip_flow_validation.schedule_number(p_rowid => p_rowid) = 0 ) then
555: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');

Line 554: elsif (wip_flow_validation.schedule_number(p_rowid => p_rowid) = 0 ) then

550:
551: elsif (wip_flow_validation.task_id(p_rowid => p_rowid) = 0 ) then
552: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');
553:
554: elsif (wip_flow_validation.schedule_number(p_rowid => p_rowid) = 0 ) then
555: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
556:
557: elsif (wip_flow_validation.unit_number(p_rowid => p_rowid) = 0 ) then
558: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');

Line 557: elsif (wip_flow_validation.unit_number(p_rowid => p_rowid) = 0 ) then

553:
554: elsif (wip_flow_validation.schedule_number(p_rowid => p_rowid) = 0 ) then
555: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
556:
557: elsif (wip_flow_validation.unit_number(p_rowid => p_rowid) = 0 ) then
558: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');
559: else
560: return fnd_api.g_ret_sts_success;
561: end if;