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 507: fnd_message.set_name('WIP', 'WIP_CANNOT_BUILD_ITEM');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 565: p_msgData => fnd_message.get);

561: end if;
562:
563: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
564: p_errCode => null,
565: p_msgData => fnd_message.get);
566: return fnd_api.g_ret_sts_error;
567: exception
568: when others then
569: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');

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

565: p_msgData => fnd_message.get);
566: return fnd_api.g_ret_sts_error;
567: exception
568: when others then
569: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
570: fnd_message.set_token('ENTITY1', l_scheduleNumber);
571: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
572: p_errCode => null,
573: p_msgData => fnd_message.get);

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

566: return fnd_api.g_ret_sts_error;
567: exception
568: when others then
569: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
570: fnd_message.set_token('ENTITY1', l_scheduleNumber);
571: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
572: p_errCode => null,
573: p_msgData => fnd_message.get);
574: return fnd_api.g_ret_sts_error;

Line 573: p_msgData => fnd_message.get);

569: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_VALIDATION');
570: fnd_message.set_token('ENTITY1', l_scheduleNumber);
571: wip_mti_pub.setMtiError(p_txnInterfaceID => l_interfaceID,
572: p_errCode => null,
573: p_msgData => fnd_message.get);
574: return fnd_api.g_ret_sts_error;
575: end validateInterfaceCompletion;
576:
577:

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

609: and process_flag = 1
610: and nvl(substitution_type_id, -1) not in (1, 2, 3, 4);
611:
612: if ( l_result > 0 ) then
613: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_TYPE');
614: wip_mti_pub.setMtiError(p_parentID,
615: 'substitution_type_id',
616: substrb(fnd_message.get, 1, 240));
617: return fnd_api.g_ret_sts_error;

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

612: if ( l_result > 0 ) then
613: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_TYPE');
614: wip_mti_pub.setMtiError(p_parentID,
615: 'substitution_type_id',
616: substrb(fnd_message.get, 1, 240));
617: return fnd_api.g_ret_sts_error;
618: end if;
619:
620: select count(*)

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

624: and process_flag = 1
625: and nvl(flow_schedule, 'Y') <> 'Y';
626:
627: if ( l_result > 0 ) then
628: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
629: wip_mti_pub.setMtiError(p_parentID,
630: 'flow_schedule',
631: substrb(fnd_message.get, 1, 240));
632: return fnd_api.g_ret_sts_error;

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

627: if ( l_result > 0 ) then
628: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
629: wip_mti_pub.setMtiError(p_parentID,
630: 'flow_schedule',
631: substrb(fnd_message.get, 1, 240));
632: return fnd_api.g_ret_sts_error;
633: end if;
634: exception
635: when others then

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

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

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

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

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

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

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

666: fnd_message.set_token('ENTITY1', l_errMsg);
667: fnd_message.set_token('ENTITY2', 'Original Component');
668: wip_mti_pub.setMtiError(p_parentID,
669: 'inventory_item_id',
670: substrb(fnd_message.get, 1, 240));
671: return fnd_api.g_ret_sts_error;
672: end if;
673: end if;
674:

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

687: msi.eng_item_flag,
688: 'N')
689: and msi.bom_item_type = 4; -- standard type
690: if ( l_result = 0 ) then
691: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
692: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
693: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
694: fnd_message.set_token('ENTITY1', l_errMsg);
695: fnd_message.set_token('ENTITY2', 'Substitution Component');

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

690: if ( l_result = 0 ) then
691: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
692: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
693: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
694: fnd_message.set_token('ENTITY1', l_errMsg);
695: fnd_message.set_token('ENTITY2', 'Substitution Component');
696: wip_mti_pub.setMtiError(p_parentID,
697: 'substitution_item_id',
698: substrb(fnd_message.get, 1, 240));

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

691: fnd_message.set_name('WIP', 'WIP_ERROR_SUBST_ASSEMBLY');
692: l_errMsg := 'Original item id ' || to_char(sub_rec.inventory_item_id) ||
693: ' at op seq ' || to_char(sub_rec.operation_seq_num) || '.';
694: fnd_message.set_token('ENTITY1', l_errMsg);
695: fnd_message.set_token('ENTITY2', 'Substitution Component');
696: wip_mti_pub.setMtiError(p_parentID,
697: 'substitution_item_id',
698: substrb(fnd_message.get, 1, 240));
699: return fnd_api.g_ret_sts_error;

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

694: fnd_message.set_token('ENTITY1', l_errMsg);
695: fnd_message.set_token('ENTITY2', 'Substitution Component');
696: wip_mti_pub.setMtiError(p_parentID,
697: 'substitution_item_id',
698: substrb(fnd_message.get, 1, 240));
699: return fnd_api.g_ret_sts_error;
700: end if;
701: end if;
702: end loop;

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

1032: || to_char(p_parentID),
1033: x_returnStatus => l_returnStatus); --discard logging return status
1034: end if;
1035:
1036: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1037: fnd_message.set_token('MESSAGE', l_errMsg);
1038: wip_mti_pub.setMtiError(p_parentID,
1039: null,
1040: substrb(fnd_message.get, 1, 240));

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

1033: x_returnStatus => l_returnStatus); --discard logging return status
1034: end if;
1035:
1036: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1037: fnd_message.set_token('MESSAGE', l_errMsg);
1038: wip_mti_pub.setMtiError(p_parentID,
1039: null,
1040: substrb(fnd_message.get, 1, 240));
1041:

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

1036: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1037: fnd_message.set_token('MESSAGE', l_errMsg);
1038: wip_mti_pub.setMtiError(p_parentID,
1039: null,
1040: substrb(fnd_message.get, 1, 240));
1041:
1042: when others then
1043: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1044: if (l_logLevel <= wip_constants.trace_logging) then

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

1052: p_msg => 'unexpected error: ' || l_errMsg || ' for exploding interface '
1053: || to_char(p_parentID),
1054: x_returnStatus => l_returnStatus); --discard logging return status
1055: end if;
1056: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_BKFLUSH');
1057: fnd_message.set_token('ENTITY1', p_parentID);
1058: wip_mti_pub.setMtiError(p_parentID,
1059: null,
1060: substrb(fnd_message.get, 1, 240));

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

1053: || to_char(p_parentID),
1054: x_returnStatus => l_returnStatus); --discard logging return status
1055: end if;
1056: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_BKFLUSH');
1057: fnd_message.set_token('ENTITY1', p_parentID);
1058: wip_mti_pub.setMtiError(p_parentID,
1059: null,
1060: substrb(fnd_message.get, 1, 240));
1061: end explodeRequirementsToMTI;

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

1056: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_BKFLUSH');
1057: fnd_message.set_token('ENTITY1', p_parentID);
1058: wip_mti_pub.setMtiError(p_parentID,
1059: null,
1060: substrb(fnd_message.get, 1, 240));
1061: end explodeRequirementsToMTI;
1062:
1063:
1064: /**

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

1136:
1137: close bf_c;
1138: else
1139: close bf_c;
1140: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_REPLACE');
1141: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1142: raise merge_exception;
1143: end if;
1144:

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

1137: close bf_c;
1138: else
1139: close bf_c;
1140: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_REPLACE');
1141: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1142: raise merge_exception;
1143: end if;
1144:
1145: elsif ( subs_rec.substitution_type_id = 2 ) then

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

1163:
1164: close bf_c;
1165: else
1166: close bf_c;
1167: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_DELETE');
1168: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1169: raise merge_exception;
1170: end if;
1171:

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

1164: close bf_c;
1165: else
1166: close bf_c;
1167: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_DELETE');
1168: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1169: raise merge_exception;
1170: end if;
1171:
1172: elsif ( subs_rec.substitution_type_id = 3 ) then

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

1214:
1215: close bf_c;
1216: else
1217: close bf_c;
1218: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_SERIAL');
1219: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1220: raise merge_exception;
1221: end if; -- end of bf_c%FOUND
1222:

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

1215: close bf_c;
1216: else
1217: close bf_c;
1218: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_SERIAL');
1219: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1220: raise merge_exception;
1221: end if; -- end of bf_c%FOUND
1222:
1223: else

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

1220: raise merge_exception;
1221: end if; -- end of bf_c%FOUND
1222:
1223: else
1224: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');
1225: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1226: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);
1227: fnd_message.set_token('ENTITYY3', l_primaryUOM);
1228: raise merge_exception;

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

1221: end if; -- end of bf_c%FOUND
1222:
1223: else
1224: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');
1225: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1226: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);
1227: fnd_message.set_token('ENTITYY3', l_primaryUOM);
1228: raise merge_exception;
1229: end if;

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

1222:
1223: else
1224: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');
1225: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1226: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);
1227: fnd_message.set_token('ENTITYY3', l_primaryUOM);
1228: raise merge_exception;
1229: end if;
1230:

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

1223: else
1224: fnd_message.set_name('WIP', 'WIP_ERROR_MERGE_LOT_UOM');
1225: fnd_message.set_token('ENTITY1', to_char(subs_rec.operation_seq_num));
1226: fnd_message.set_token('ENTITY2', subs_rec.transaction_uom);
1227: fnd_message.set_token('ENTITYY3', l_primaryUOM);
1228: raise merge_exception;
1229: end if;
1230:
1231: end if;

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

1263: when merge_exception then
1264: x_returnStatus := fnd_api.g_ret_sts_error;
1265: wip_mti_pub.setMtiError(p_parentID,
1266: null,
1267: substrb(fnd_message.get, 1, 240));
1268: when others then
1269: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1270: wip_mti_pub.setMtiError(p_parentID,
1271: null,

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

1815: p_msg => 'unexpected error: ' || SQLERRM,
1816: x_returnStatus => l_returnStatus); --discard logging return status
1817: end if;
1818:
1819: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_CREATION');
1820: fnd_message.set_token('ENTITY1',to_char(p_txnInterfaceID));
1821: fnd_msg_pub.add;
1822: end createFlowSchedule;
1823:

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

1816: x_returnStatus => l_returnStatus); --discard logging return status
1817: end if;
1818:
1819: fnd_message.set_name('WIP', 'WIP_ERROR_FLOW_CREATION');
1820: fnd_message.set_token('ENTITY1',to_char(p_txnInterfaceID));
1821: fnd_msg_pub.add;
1822: end createFlowSchedule;
1823:
1824:

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

1940: p_msg => 'unexpected error: ' || SQLERRM,
1941: x_returnStatus => l_returnStatus); --discard logging return status
1942: end if;
1943:
1944: fnd_message.set_name('WIP', 'WIP_UPDATE_WFS_ERROR');
1945: fnd_msg_pub.add;
1946: end updateFlowSchedule;
1947:
1948: /**

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

2197: if ( nvl(x_compTbl(l_count).wip_supply_type, -1) <> 6 and
2198: x_compTbl(l_count).mtl_transactions_enabled_flag <> 'Y' and
2199: p_txnFlag) then --Bug4538135.Don't check this while creating job
2200: x_returnStatus := fnd_api.g_ret_sts_error;
2201: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');
2202: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);
2203: fnd_msg_pub.add;
2204: if (l_logLevel <= wip_constants.full_logging) then
2205: wip_logger.log(p_msg => 'Item ' || x_compTbl(l_count).inventory_item_id ||

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

2198: x_compTbl(l_count).mtl_transactions_enabled_flag <> 'Y' and
2199: p_txnFlag) then --Bug4538135.Don't check this while creating job
2200: x_returnStatus := fnd_api.g_ret_sts_error;
2201: fnd_message.set_name('WIP', 'WIP_COMP_NOT_TRANSACTABLE');
2202: fnd_message.set_token('ENTITY1', x_compTbl(l_count).item_name);
2203: fnd_msg_pub.add;
2204: if (l_logLevel <= wip_constants.full_logging) then
2205: wip_logger.log(p_msg => 'Item ' || x_compTbl(l_count).inventory_item_id ||
2206: ' not transactable, failed explosion!',

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

2353: transaction_date => p_txnDate,
2354: period_id => l_acctPeriodID,
2355: open_past_period => l_openPastPeriod);
2356: if ( l_acctPeriodID is null ) then
2357: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
2358: fnd_msg_pub.add;
2359: raise fnd_api.g_exc_unexpected_error;
2360: end if;
2361: