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_FLOWUTIL_PRIV dependencies on FND_MESSAGE

Line 167: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_DEFAULTING');

163: locator_id = flow_rec.locator_id,
164: accounting_class = flow_rec.accounting_class
165: where rowid = flow_rec.rowid;
166: else
167: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_DEFAULTING');
168: fnd_message.set_token('ENTITY1',to_char(flow_rec.transaction_interface_id));
169: wip_mti_pub.setMtiError(p_txnInterfaceID => flow_rec.transaction_interface_id,
170: p_errCode => null,
171: p_msgData => fnd_message.get);

Line 168: fnd_message.set_token('ENTITY1',to_char(flow_rec.transaction_interface_id));

164: accounting_class = flow_rec.accounting_class
165: where rowid = flow_rec.rowid;
166: else
167: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_DEFAULTING');
168: fnd_message.set_token('ENTITY1',to_char(flow_rec.transaction_interface_id));
169: wip_mti_pub.setMtiError(p_txnInterfaceID => flow_rec.transaction_interface_id,
170: p_errCode => null,
171: p_msgData => fnd_message.get);
172: l_errMsg := 'error defaulting';

Line 171: p_msgData => fnd_message.get);

167: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_DEFAULTING');
168: fnd_message.set_token('ENTITY1',to_char(flow_rec.transaction_interface_id));
169: wip_mti_pub.setMtiError(p_txnInterfaceID => flow_rec.transaction_interface_id,
170: p_errCode => null,
171: p_msgData => fnd_message.get);
172: l_errMsg := 'error defaulting';
173: raise l_validationException;
174: end if;
175:

Line 476: fnd_message.set_name('WIP', 'WIP_CANNOT_BUILD_ITEM');

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

Line 479: fnd_message.set_name('WIP', 'WIP_INTERFACE_INVALID_CLASS');

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

Line 482: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION_DATE');

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

Line 485: fnd_message.set_name('WIP', 'WIP_INVALID_BOM_REVISION');

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

Line 488: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION_DATE');

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

Line 491: fnd_message.set_name('WIP', 'WIP_INVALID_ROUT_REVISION');

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

Line 494: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_BOM');

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

Line 497: fnd_message.set_name('WIP', 'WIP_ML_ALTERNATE_ROUTING');

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

Line 500: fnd_message.set_name('WIP', 'WIP_INVALID_COMPLETION_SUB');

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

Line 503: fnd_message.set_name('WIP', 'WIP_INVALID_LOCATOR');

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

Line 506: fnd_message.set_name('WIP', 'WIP_ML_DEMAND_CLASS');

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

Line 509: fnd_message.set_name('WIP', 'WIP_ML_SCHEDULE_GROUP');

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

Line 512: fnd_message.set_name('WIP', 'WIP_BUILD_SEQUENCE');

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

Line 515: fnd_message.set_name('WIP', 'WIP_ML_LINE_ID');

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

Line 518: fnd_message.set_name('WIP', 'WIP_INVALID_PROJECT');

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

Line 521: fnd_message.set_name('WIP', 'WIP_INVALID_TASK');

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

Line 524: fnd_message.set_name('WIP', 'WIP_INVALID_SCHEDULE_NUMBER');

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');
528: else

Line 527: fnd_message.set_name('WIP', 'UEFF-UNIT NUMBER INVALID');

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;
531:

Line 534: p_msgData => fnd_message.get);

530: end if;
531:
532: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
533: p_errCode => null,
534: p_msgData => fnd_message.get);
535: return fnd_api.g_ret_sts_error;
536: exception
537: when others then
538: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');

Line 538: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');

534: p_msgData => fnd_message.get);
535: return fnd_api.g_ret_sts_error;
536: exception
537: when others then
538: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
539: fnd_message.set_token('ENTITY1', l_scheduleNumber);
540: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
541: p_errCode => null,
542: p_msgData => fnd_message.get);

Line 539: fnd_message.set_token('ENTITY1', l_scheduleNumber);

535: return fnd_api.g_ret_sts_error;
536: exception
537: when others then
538: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
539: fnd_message.set_token('ENTITY1', l_scheduleNumber);
540: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
541: p_errCode => null,
542: p_msgData => fnd_message.get);
543: return fnd_api.g_ret_sts_error;

Line 542: p_msgData => fnd_message.get);

538: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
539: fnd_message.set_token('ENTITY1', l_scheduleNumber);
540: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
541: p_errCode => null,
542: p_msgData => fnd_message.get);
543: return fnd_api.g_ret_sts_error;
544: end validateInterfaceCompletion;
545:
546:

Line 582: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_TYPE');

578: and process_flag = 1
579: and nvl(substitution_type_id, -1) not in (1, 2, 3, 4);
580:
581: if ( l_result > 0 ) then
582: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_TYPE');
583: wip_mti_pub.setMtiError(p_parentID,
584: 'substitution_type_id',
585: substrb(fnd_message.get, 1, 240));
586: return fnd_api.g_ret_sts_error;

Line 585: substrb(fnd_message.get, 1, 240));

581: if ( l_result > 0 ) then
582: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_TYPE');
583: wip_mti_pub.setMtiError(p_parentID,
584: 'substitution_type_id',
585: substrb(fnd_message.get, 1, 240));
586: return fnd_api.g_ret_sts_error;
587: end if;
588:
589: select count(*)

Line 597: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');

593: and process_flag = 1
594: and nvl(flow_schedule, 'Y') <> 'Y';
595:
596: if ( l_result > 0 ) then
597: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
598: wip_mti_pub.setMtiError(p_parentID,
599: 'flow_schedule',
600: substrb(fnd_message.get, 1, 240));
601: return fnd_api.g_ret_sts_error;

Line 600: substrb(fnd_message.get, 1, 240));

596: if ( l_result > 0 ) then
597: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
598: wip_mti_pub.setMtiError(p_parentID,
599: 'flow_schedule',
600: substrb(fnd_message.get, 1, 240));
601: return fnd_api.g_ret_sts_error;
602: end if;
603: exception
604: when others then

Line 632: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');

628: msi.eng_item_flag,
629: 'N')
630: and msi.bom_item_type = 4; -- standard type
631: if ( l_result = 0 ) then
632: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
633: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
634: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
635: fnd_message.set_token('ENTITY1', l_errMsg);
636: fnd_message.set_token('ENTITY2', 'Original Component');

Line 635: fnd_message.set_token('ENTITY1', l_errMsg);

631: if ( l_result = 0 ) then
632: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
633: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
634: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
635: fnd_message.set_token('ENTITY1', l_errMsg);
636: fnd_message.set_token('ENTITY2', 'Original Component');
637: wip_mti_pub.setMtiError(p_parentID,
638: 'inventory_item_id',
639: substrb(fnd_message.get, 1, 240));

Line 636: fnd_message.set_token('ENTITY2', 'Original Component');

632: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
633: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
634: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
635: fnd_message.set_token('ENTITY1', l_errMsg);
636: fnd_message.set_token('ENTITY2', 'Original Component');
637: wip_mti_pub.setMtiError(p_parentID,
638: 'inventory_item_id',
639: substrb(fnd_message.get, 1, 240));
640: return fnd_api.g_ret_sts_error;

Line 639: substrb(fnd_message.get, 1, 240));

635: fnd_message.set_token('ENTITY1', l_errMsg);
636: fnd_message.set_token('ENTITY2', 'Original Component');
637: wip_mti_pub.setMtiError(p_parentID,
638: 'inventory_item_id',
639: substrb(fnd_message.get, 1, 240));
640: return fnd_api.g_ret_sts_error;
641: end if;
642: end if;
643:

Line 660: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');

656: msi.eng_item_flag,
657: 'N')
658: and msi.bom_item_type = 4; -- standard type
659: if ( l_result = 0 ) then
660: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
661: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
662: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
663: fnd_message.set_token('ENTITY1', l_errMsg);
664: fnd_message.set_token('ENTITY2', 'Substitution Component');

Line 663: fnd_message.set_token('ENTITY1', l_errMsg);

659: if ( l_result = 0 ) then
660: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
661: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
662: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
663: fnd_message.set_token('ENTITY1', l_errMsg);
664: fnd_message.set_token('ENTITY2', 'Substitution Component');
665: wip_mti_pub.setMtiError(p_parentID,
666: 'substitution_item_id',
667: substrb(fnd_message.get, 1, 240));

Line 664: fnd_message.set_token('ENTITY2', 'Substitution Component');

660: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
661: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
662: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
663: fnd_message.set_token('ENTITY1', l_errMsg);
664: fnd_message.set_token('ENTITY2', 'Substitution Component');
665: wip_mti_pub.setMtiError(p_parentID,
666: 'substitution_item_id',
667: substrb(fnd_message.get, 1, 240));
668: return fnd_api.g_ret_sts_error;

Line 667: substrb(fnd_message.get, 1, 240));

663: fnd_message.set_token('ENTITY1', l_errMsg);
664: fnd_message.set_token('ENTITY2', 'Substitution Component');
665: wip_mti_pub.setMtiError(p_parentID,
666: 'substitution_item_id',
667: substrb(fnd_message.get, 1, 240));
668: return fnd_api.g_ret_sts_error;
669: end if;
670: end if;
671: end loop;

Line 1005: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

1001: || to_char(p_parentID),
1002: x_returnStatus => l_returnStatus); --discard logging return status
1003: end if;
1004:
1005: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1006: fnd_message.set_token('MESSAGE', l_errMsg);
1007: wip_mti_pub.setMtiError(p_parentID,
1008: null,
1009: substrb(fnd_message.get, 1, 240));

Line 1006: fnd_message.set_token('MESSAGE', l_errMsg);

1002: x_returnStatus => l_returnStatus); --discard logging return status
1003: end if;
1004:
1005: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1006: fnd_message.set_token('MESSAGE', l_errMsg);
1007: wip_mti_pub.setMtiError(p_parentID,
1008: null,
1009: substrb(fnd_message.get, 1, 240));
1010:

Line 1009: substrb(fnd_message.get, 1, 240));

1005: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1006: fnd_message.set_token('MESSAGE', l_errMsg);
1007: wip_mti_pub.setMtiError(p_parentID,
1008: null,
1009: substrb(fnd_message.get, 1, 240));
1010:
1011: when others then
1012: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1013: if (l_logLevel <= wip_constants.trace_logging) then

Line 1025: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_BKFLUSH');

1021: p_msg => 'unexpected error: ' || l_errMsg || ' for exploding interface '
1022: || to_char(p_parentID),
1023: x_returnStatus => l_returnStatus); --discard logging return status
1024: end if;
1025: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_BKFLUSH');
1026: fnd_message.set_token('ENTITY1', p_parentID);
1027: wip_mti_pub.setMtiError(p_parentID,
1028: null,
1029: substrb(fnd_message.get, 1, 240));

Line 1026: fnd_message.set_token('ENTITY1', p_parentID);

1022: || to_char(p_parentID),
1023: x_returnStatus => l_returnStatus); --discard logging return status
1024: end if;
1025: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_BKFLUSH');
1026: fnd_message.set_token('ENTITY1', p_parentID);
1027: wip_mti_pub.setMtiError(p_parentID,
1028: null,
1029: substrb(fnd_message.get, 1, 240));
1030: end explodeRequirementsToMTI;

Line 1029: substrb(fnd_message.get, 1, 240));

1025: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_BKFLUSH');
1026: fnd_message.set_token('ENTITY1', p_parentID);
1027: wip_mti_pub.setMtiError(p_parentID,
1028: null,
1029: substrb(fnd_message.get, 1, 240));
1030: end explodeRequirementsToMTI;
1031:
1032:
1033: /**

Line 1109: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_REPLACE');

1105:
1106: close bf_c;
1107: else
1108: close bf_c;
1109: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_REPLACE');
1110: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1111: raise merge_exception;
1112: end if;
1113:

Line 1110: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));

1106: close bf_c;
1107: else
1108: close bf_c;
1109: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_REPLACE');
1110: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1111: raise merge_exception;
1112: end if;
1113:
1114: elsif ( subs_rec.substitution_type_id = 2 ) then

Line 1136: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_DELETE');

1132:
1133: close bf_c;
1134: else
1135: close bf_c;
1136: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_DELETE');
1137: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1138: raise merge_exception;
1139: end if;
1140:

Line 1137: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));

1133: close bf_c;
1134: else
1135: close bf_c;
1136: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_DELETE');
1137: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1138: raise merge_exception;
1139: end if;
1140:
1141: elsif ( subs_rec.substitution_type_id = 3 ) then

Line 1187: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_SERIAL');

1183:
1184: close bf_c;
1185: else
1186: close bf_c;
1187: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_SERIAL');
1188: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1189: raise merge_exception;
1190: end if; -- end of bf_c%FOUND
1191:

Line 1188: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));

1184: close bf_c;
1185: else
1186: close bf_c;
1187: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_SERIAL');
1188: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1189: raise merge_exception;
1190: end if; -- end of bf_c%FOUND
1191:
1192: else

Line 1193: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');

1189: raise merge_exception;
1190: end if; -- end of bf_c%FOUND
1191:
1192: else
1193: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');
1194: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1195: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);
1196: fnd_message.set_token('ENTITYY3', l_primaryUOM);
1197: raise merge_exception;

Line 1194: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));

1190: end if; -- end of bf_c%FOUND
1191:
1192: else
1193: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');
1194: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1195: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);
1196: fnd_message.set_token('ENTITYY3', l_primaryUOM);
1197: raise merge_exception;
1198: end if;

Line 1195: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);

1191:
1192: else
1193: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');
1194: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1195: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);
1196: fnd_message.set_token('ENTITYY3', l_primaryUOM);
1197: raise merge_exception;
1198: end if;
1199:

Line 1196: fnd_message.set_token('ENTITYY3', l_primaryUOM);

1192: else
1193: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');
1194: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1195: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);
1196: fnd_message.set_token('ENTITYY3', l_primaryUOM);
1197: raise merge_exception;
1198: end if;
1199:
1200: end if;

Line 1236: substrb(fnd_message.get, 1, 240));

1232: when merge_exception then
1233: x_returnStatus := fnd_api.g_ret_sts_error;
1234: wip_mti_pub.setMtiError(p_parentID,
1235: null,
1236: substrb(fnd_message.get, 1, 240));
1237: when others then
1238: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1239: wip_mti_pub.setMtiError(p_parentID,
1240: null,

Line 1788: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_CREATION');

1784: p_msg => 'unexpected error: ' || SQLERRM,
1785: x_returnStatus => l_returnStatus); --discard logging return status
1786: end if;
1787:
1788: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_CREATION');
1789: fnd_message.set_token('ENTITY1',to_char(p_txnInterfaceID));
1790: fnd_msg_pub.add;
1791: end createFlowSchedule;
1792:

Line 1789: fnd_message.set_token('ENTITY1',to_char(p_txnInterfaceID));

1785: x_returnStatus => l_returnStatus); --discard logging return status
1786: end if;
1787:
1788: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_CREATION');
1789: fnd_message.set_token('ENTITY1',to_char(p_txnInterfaceID));
1790: fnd_msg_pub.add;
1791: end createFlowSchedule;
1792:
1793:

Line 1911: fnd_message.set_name('WIP', 'WIP_UPDATE_WFS_ERROR');

1907: p_msg => 'unexpected error: ' || SQLERRM,
1908: x_returnStatus => l_returnStatus); --discard logging return status
1909: end if;
1910:
1911: fnd_message.set_name('WIP', 'WIP_UPDATE_WFS_ERROR');
1912: fnd_msg_pub.add;
1913: end updateFlowSchedule;
1914:
1915: /**

Line 2162: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');

2158: if ( nvl(x_compTbl(l_count).wip_supply_type, -1) <> 6 and
2159: x_compTbl(l_count).mtl_transactions_enabled_flag <> 'Y' and
2160: p_txnFlag) then --Bug4538135.Don't check this while creating job
2161: x_returnStatus := fnd_api.g_ret_sts_error;
2162: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');
2163: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);
2164: fnd_msg_pub.add;
2165: if (l_logLevel <= wip_constants.full_logging) then
2166: wip_logger.log(p_msg => 'Item ' || x_compTbl(l_count).inventory_item_id ||

Line 2163: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);

2159: x_compTbl(l_count).mtl_transactions_enabled_flag <> 'Y' and
2160: p_txnFlag) then --Bug4538135.Don't check this while creating job
2161: x_returnStatus := fnd_api.g_ret_sts_error;
2162: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');
2163: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);
2164: fnd_msg_pub.add;
2165: if (l_logLevel <= wip_constants.full_logging) then
2166: wip_logger.log(p_msg => 'Item ' || x_compTbl(l_count).inventory_item_id ||
2167: ' not transactable, failed explosion!',

Line 2318: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');

2314: transaction_date => p_txnDate,
2315: period_id => l_acctPeriodID,
2316: open_past_period => l_openPastPeriod);
2317: if ( l_acctPeriodID is null ) then
2318: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
2319: fnd_msg_pub.add;
2320: raise fnd_api.g_exc_unexpected_error;
2321: end if;
2322: