471: l_interfaceID
472: from mtl_transactions_interface
473: where rowid = p_rowid;
474:
475: if ( wip_flow_validation.primary_item_id(p_rowid => p_rowid) = 0 ) then
476: fnd_message.set_name('WIP', 'WIP_CANNOT_BUILD_ITEM');
477:
478: elsif (wip_flow_validation.class_code(p_rowid => p_rowid) = 0 ) then
479: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');
474:
475: if ( wip_flow_validation.primary_item_id(p_rowid => p_rowid) = 0 ) then
476: fnd_message.set_name('WIP', 'WIP_CANNOT_BUILD_ITEM');
477:
478: elsif (wip_flow_validation.class_code(p_rowid => p_rowid) = 0 ) then
479: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');
480:
481: elsif (wip_flow_validation.bom_rev_date(p_rowid => p_rowid) = 0 ) then
482: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');
477:
478: elsif (wip_flow_validation.class_code(p_rowid => p_rowid) = 0 ) then
479: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');
480:
481: elsif (wip_flow_validation.bom_rev_date(p_rowid => p_rowid) = 0 ) then
482: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');
483:
484: elsif (wip_flow_validation.bom_revision(p_rowid => p_rowid) = 0 ) then
485: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');
480:
481: elsif (wip_flow_validation.bom_rev_date(p_rowid => p_rowid) = 0 ) then
482: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');
483:
484: elsif (wip_flow_validation.bom_revision(p_rowid => p_rowid) = 0 ) then
485: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');
486:
487: elsif (wip_flow_validation.rout_rev_date(p_rowid => p_rowid) = 0 ) then
488: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');
483:
484: elsif (wip_flow_validation.bom_revision(p_rowid => p_rowid) = 0 ) then
485: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');
486:
487: elsif (wip_flow_validation.rout_rev_date(p_rowid => p_rowid) = 0 ) then
488: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');
489:
490: elsif (wip_flow_validation.routing_revision(p_rowid => p_rowid) = 0 ) then
491: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');
486:
487: elsif (wip_flow_validation.rout_rev_date(p_rowid => p_rowid) = 0 ) then
488: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');
489:
490: elsif (wip_flow_validation.routing_revision(p_rowid => p_rowid) = 0 ) then
491: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');
492:
493: elsif (wip_flow_validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) then
494: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
489:
490: elsif (wip_flow_validation.routing_revision(p_rowid => p_rowid) = 0 ) then
491: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');
492:
493: elsif (wip_flow_validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) then
494: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
495:
496: elsif (wip_flow_validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) then
497: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
492:
493: elsif (wip_flow_validation.alt_bom_desg(p_rowid => p_rowid) = 0 ) then
494: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');
495:
496: elsif (wip_flow_validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) then
497: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
498:
499: elsif (wip_flow_validation.completion_sub(p_rowid => p_rowid) = 0 ) then
500: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');
495:
496: elsif (wip_flow_validation.alt_rout_desg(p_rowid => p_rowid) = 0 ) then
497: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');
498:
499: elsif (wip_flow_validation.completion_sub(p_rowid => p_rowid) = 0 ) then
500: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');
501:
502: elsif (wip_flow_validation.completion_locator_id(p_rowid => p_rowid) = 0 ) then
503: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');
498:
499: elsif (wip_flow_validation.completion_sub(p_rowid => p_rowid) = 0 ) then
500: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');
501:
502: elsif (wip_flow_validation.completion_locator_id(p_rowid => p_rowid) = 0 ) then
503: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');
504:
505: elsif (wip_flow_validation.demand_class(p_rowid => p_rowid) = 0 ) then
506: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
501:
502: elsif (wip_flow_validation.completion_locator_id(p_rowid => p_rowid) = 0 ) then
503: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');
504:
505: elsif (wip_flow_validation.demand_class(p_rowid => p_rowid) = 0 ) then
506: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
507:
508: elsif (wip_flow_validation.schedule_group_id(p_rowid => p_rowid) = 0 ) then
509: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
504:
505: elsif (wip_flow_validation.demand_class(p_rowid => p_rowid) = 0 ) then
506: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');
507:
508: elsif (wip_flow_validation.schedule_group_id(p_rowid => p_rowid) = 0 ) then
509: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
510:
511: elsif (wip_flow_validation.build_sequence(p_rowid => p_rowid) = 0 ) then
512: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');
507:
508: elsif (wip_flow_validation.schedule_group_id(p_rowid => p_rowid) = 0 ) then
509: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');
510:
511: elsif (wip_flow_validation.build_sequence(p_rowid => p_rowid) = 0 ) then
512: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');
513:
514: elsif (wip_flow_validation.line_id(p_rowid => p_rowid) = 0 ) then
515: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
510:
511: elsif (wip_flow_validation.build_sequence(p_rowid => p_rowid) = 0 ) then
512: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');
513:
514: elsif (wip_flow_validation.line_id(p_rowid => p_rowid) = 0 ) then
515: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
516:
517: elsif (wip_flow_validation.project_id(p_rowid => p_rowid) = 0 ) then
518: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');
513:
514: elsif (wip_flow_validation.line_id(p_rowid => p_rowid) = 0 ) then
515: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');
516:
517: elsif (wip_flow_validation.project_id(p_rowid => p_rowid) = 0 ) then
518: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');
519:
520: elsif (wip_flow_validation.task_id(p_rowid => p_rowid) = 0 ) then
521: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');
516:
517: elsif (wip_flow_validation.project_id(p_rowid => p_rowid) = 0 ) then
518: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');
519:
520: elsif (wip_flow_validation.task_id(p_rowid => p_rowid) = 0 ) then
521: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');
522:
523: elsif (wip_flow_validation.schedule_number(p_rowid => p_rowid) = 0 ) then
524: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
519:
520: elsif (wip_flow_validation.task_id(p_rowid => p_rowid) = 0 ) then
521: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');
522:
523: elsif (wip_flow_validation.schedule_number(p_rowid => p_rowid) = 0 ) then
524: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
525:
526: elsif (wip_flow_validation.unit_number(p_rowid => p_rowid) = 0 ) then
527: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');
522:
523: elsif (wip_flow_validation.schedule_number(p_rowid => p_rowid) = 0 ) then
524: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');
525:
526: elsif (wip_flow_validation.unit_number(p_rowid => p_rowid) = 0 ) then
527: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');
528: else
529: return fnd_api.g_ret_sts_success;
530: end if;