DBA Data[Home] [Help]

APPS.WIP_FLOWUTIL_PRIV dependencies on WIP_FLOW_VALIDATION

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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');

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

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;