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_BOMROUTINGUTIL_PVT dependencies on WIP_CONSTANTS

Line 40: if (l_logLevel <= wip_constants.trace_logging) then

36: where fad.pk1_value = to_char(wo.operation_sequence_id)
37: and fad.entity_name = 'BOM_OPERATION_SEQUENCES');
38: begin
39: x_returnStatus := fnd_api.g_ret_sts_success;
40: if (l_logLevel <= wip_constants.trace_logging) then
41: l_params(1).paramName := 'p_orgID';
42: l_params(1).paramValue := p_orgID;
43: l_params(2).paramName := 'p_wipEntityID';
44: l_params(2).paramValue := p_wipEntityID;

Line 79: if(l_logLevel <= wip_constants.trace_logging) then

75: and nvl(alternate_routing_designator, '@@@^@@@') = nvl(p_altRouting, '@@@^@@@')
76: and nvl(cfm_routing_flag, 2) = 2;
77: exception
78: when NO_DATA_FOUND then
79: if(l_logLevel <= wip_constants.trace_logging) then
80: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
81: p_procReturnStatus => 'true',
82: p_msg => 'this item does not have a routing',
83: x_returnStatus => l_retStatus);

Line 91: if ( l_logLevel <= wip_constants.full_logging ) then

87: end;
88:
89: l_excludeECO := fnd_profile.value('WIP_RELEASED_REVS');
90:
91: if ( l_logLevel <= wip_constants.full_logging ) then
92: wip_logger.log('exclude ECO is: ' || l_excludeECO, l_retStatus);
93: wip_logger.log('RoutingSeqID is: ' || l_routingSeqID, l_retStatus);
94: end if;
95:

Line 241: if ( l_logLevel <= wip_constants.full_logging ) then

237: and operation_seq_num > wo.operation_seq_num)
238: where wo.wip_entity_id = p_wipEntityID
239: and wo.organization_id = p_orgID;
240:
241: if ( l_logLevel <= wip_constants.full_logging ) then
242: wip_logger.log('begin to load resources', l_retStatus);
243: end if;
244:
245:

Line 370: if ( l_logLevel <= wip_constants.full_logging ) then

366: and eng.routing_sequence_id = l_routingSeqID
367: and ((eng.status_type in (4, 7) and l_excludeECO = 1) or
368: (eng.status_type in (1, 4, 7) and l_excludeECO = 2)))));
369:
370: if ( l_logLevel <= wip_constants.full_logging ) then
371: wip_logger.log('begin to load substitute resources', l_retStatus);
372: end if;
373:
374: select max(resource_seq_num)

Line 486: if ( l_logLevel <= wip_constants.full_logging ) then

482: and wo.operation_sequence_id = bsor.operation_sequence_id
483: and bsor.resource_id = br.resource_id
484: and nvl(bsor.acd_type, 0) <> 3;
485:
486: if ( l_logLevel <= wip_constants.full_logging ) then
487: wip_logger.log('begin to load attachment', l_retStatus);
488: end if;
489:
490:

Line 507: if ( l_logLevel <= wip_constants.full_logging ) then

503: x_request_id => fnd_global.conc_request_id);
504: END LOOP;
505:
506: /* Added for 12.1.1 Skills Validation project.*/
507: if ( l_logLevel <= wip_constants.full_logging ) then
508: wip_logger.log('begin to load competence', l_retStatus);
509: end if;
510:
511: DELETE FROM WIP_OPERATION_COMPETENCIES

Line 541: if (l_logLevel <= wip_constants.trace_logging) then

537: AND WO.ORGANIZATION_ID = BOS.ORGANIZATION_ID
538: AND BOS.OPERATION_SEQUENCE_ID = WO.OPERATION_SEQUENCE_ID
539: AND BOS.LEVEL_ID = 2;
540:
541: if (l_logLevel <= wip_constants.trace_logging) then
542: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
543: p_procReturnStatus => x_returnStatus,
544: p_msg => 'success',
545: x_returnStatus => l_retStatus);

Line 549: if(l_logLevel <= wip_constants.trace_logging) then

545: x_returnStatus => l_retStatus);
546: end if;
547: exception
548: when others then
549: if(l_logLevel <= wip_constants.trace_logging) then
550: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
551: p_procReturnStatus => x_returnStatus,
552: p_msg => 'unexp error:' || SQLERRM,
553: x_returnStatus => l_retStatus);

Line 609: and wip_supply_type = wip_constants.phantom;

605: where organization_id = p_orgID
606: and wip_entity_id = p_wipEntityID
607: and nvl(repetitive_schedule_id, -1) = nvl(p_repSchedID, -1)
608: and operation_seq_num < 0
609: and wip_supply_type = wip_constants.phantom;
610:
611: begin
612: x_returnStatus := fnd_api.g_ret_sts_success;
613: if (l_logLevel <= wip_constants.trace_logging) then

Line 613: if (l_logLevel <= wip_constants.trace_logging) then

609: and wip_supply_type = wip_constants.phantom;
610:
611: begin
612: x_returnStatus := fnd_api.g_ret_sts_success;
613: if (l_logLevel <= wip_constants.trace_logging) then
614: l_params(1).paramName := 'p_orgID';
615: l_params(1).paramValue := p_orgID;
616: l_params(2).paramName := 'p_wipEntityID';
617: l_params(2).paramValue := p_wipEntityID;

Line 648: l_entityType := wip_constants.discrete;

644: raise fnd_api.g_exc_unexpected_error;
645: end if;
646: end if;
647:
648: l_entityType := wip_constants.discrete;
649: if ( p_repSchedID is not null ) then
650: l_entityType := wip_constants.repetitive;
651: end if;
652:

Line 650: l_entityType := wip_constants.repetitive;

646: end if;
647:
648: l_entityType := wip_constants.discrete;
649: if ( p_repSchedID is not null ) then
650: l_entityType := wip_constants.repetitive;
651: end if;
652:
653: l_mrpFlag := wip_constants.yes;
654: if ( p_jobType = wip_constants.nonstandard ) then

Line 653: l_mrpFlag := wip_constants.yes;

649: if ( p_repSchedID is not null ) then
650: l_entityType := wip_constants.repetitive;
651: end if;
652:
653: l_mrpFlag := wip_constants.yes;
654: if ( p_jobType = wip_constants.nonstandard ) then
655: l_mrpFlag := wip_constants.no;
656: end if;
657:

Line 654: if ( p_jobType = wip_constants.nonstandard ) then

650: l_entityType := wip_constants.repetitive;
651: end if;
652:
653: l_mrpFlag := wip_constants.yes;
654: if ( p_jobType = wip_constants.nonstandard ) then
655: l_mrpFlag := wip_constants.no;
656: end if;
657:
658: /*

Line 655: l_mrpFlag := wip_constants.no;

651: end if;
652:
653: l_mrpFlag := wip_constants.yes;
654: if ( p_jobType = wip_constants.nonstandard ) then
655: l_mrpFlag := wip_constants.no;
656: end if;
657:
658: /*
659: wip_bflProc_priv.explodeRequirements(

Line 722: if( l_compTbl(l_count).basis_type = WIP_CONSTANTS.LOT_BASED_MTL) then

718: when others then
719: l_opSeq := l_minOp;
720: end;
721:
722: if( l_compTbl(l_count).basis_type = WIP_CONSTANTS.LOT_BASED_MTL) then
723: l_multipleFactor := 1 ;
724: else
725: l_multipleFactor := p_qty ;
726: end if;

Line 729: if (l_opSeq = 1 AND l_compTbl(l_count).wip_supply_type = WIP_CONSTANTS.OP_PULL) then

725: l_multipleFactor := p_qty ;
726: end if;
727:
728: /* Fix for bug 4703486. If no rtg exists, Op pull components should become Assy Pull */
729: if (l_opSeq = 1 AND l_compTbl(l_count).wip_supply_type = WIP_CONSTANTS.OP_PULL) then
730: l_compTbl(l_count).wip_supply_type := WIP_CONSTANTS.ASSY_PULL;
731: end if;
732:
733:

Line 730: l_compTbl(l_count).wip_supply_type := WIP_CONSTANTS.ASSY_PULL;

726: end if;
727:
728: /* Fix for bug 4703486. If no rtg exists, Op pull components should become Assy Pull */
729: if (l_opSeq = 1 AND l_compTbl(l_count).wip_supply_type = WIP_CONSTANTS.OP_PULL) then
730: l_compTbl(l_count).wip_supply_type := WIP_CONSTANTS.ASSY_PULL;
731: end if;
732:
733:
734: /* bug 4688276 - if the same component in op 1 and op 10, for example, we'll try

Line 736: if( l_compTbl(l_count).wip_supply_type = wip_constants.phantom) then

732:
733:
734: /* bug 4688276 - if the same component in op 1 and op 10, for example, we'll try
735: to merge the qties into op 10, as long as their baisis type is the same */
736: if( l_compTbl(l_count).wip_supply_type = wip_constants.phantom) then
737: l_wro_op := -1*l_opSeq;
738: else
739: l_wro_op := l_opSeq;
740: end if;

Line 757: wip_constants.max_displayed_precision),

753: if( (l_compTbl(l_count).basis_type is null and l_basis = 1 )
754: or l_compTbl(l_count).basis_type = l_basis ) then
755: update wip_requirement_operations wro
756: set wro.quantity_per_assembly = round( l_compTbl(l_count).primary_quantity + wro.quantity_per_assembly,
757: wip_constants.max_displayed_precision),
758: wro.required_quantity = round( round(l_compTbl(l_count).primary_quantity,
759: wip_constants.max_displayed_precision)
760: *l_multipleFactor/l_compTbl(l_count).component_yield_factor,
761: wip_constants.max_displayed_precision) + wro.required_quantity

Line 759: wip_constants.max_displayed_precision)

755: update wip_requirement_operations wro
756: set wro.quantity_per_assembly = round( l_compTbl(l_count).primary_quantity + wro.quantity_per_assembly,
757: wip_constants.max_displayed_precision),
758: wro.required_quantity = round( round(l_compTbl(l_count).primary_quantity,
759: wip_constants.max_displayed_precision)
760: *l_multipleFactor/l_compTbl(l_count).component_yield_factor,
761: wip_constants.max_displayed_precision) + wro.required_quantity
762: where wro.inventory_item_id = l_compTbl(l_count).inventory_item_id
763: and wro.organization_id = p_orgID

Line 761: wip_constants.max_displayed_precision) + wro.required_quantity

757: wip_constants.max_displayed_precision),
758: wro.required_quantity = round( round(l_compTbl(l_count).primary_quantity,
759: wip_constants.max_displayed_precision)
760: *l_multipleFactor/l_compTbl(l_count).component_yield_factor,
761: wip_constants.max_displayed_precision) + wro.required_quantity
762: where wro.inventory_item_id = l_compTbl(l_count).inventory_item_id
763: and wro.organization_id = p_orgID
764: and wro.wip_entity_id = p_wipEntityID
765: and wro.operation_seq_num = l_wro_op;

Line 770: wip_constants.max_displayed_precision))

766:
767: update wip_requirement_operations wro
768: /*Fix for bug 7486594*/
769: set wro.component_yield_factor = decode(wro.quantity_per_assembly,0,1,round( wro.quantity_per_assembly * l_multipleFactor / wro.required_quantity,
770: wip_constants.max_displayed_precision))
771: where wro.inventory_item_id = l_compTbl(l_count).inventory_item_id
772: and wro.organization_id = p_orgID
773: and wro.wip_entity_id = p_wipEntityID
774: and wro.operation_seq_num = l_wro_op;

Line 779: if (l_logLevel <= wip_constants.full_logging) then

775: else
776: x_returnStatus := fnd_api.g_ret_sts_error;
777: fnd_message.set_name('WIP', 'WIP_COMP_DUP_OP_ONE');
778: fnd_msg_pub.add;
779: if (l_logLevel <= wip_constants.full_logging) then
780: wip_logger.log(p_msg => 'Item ' || l_compTbl(l_count).inventory_item_id ||
781: ' has duplicates in op 1, failed explosion!',
782: x_returnStatus => x_returnStatus);
783:

Line 822: wip_constants.phantom, -1*l_opSeq, l_opSeq),

818: l_compTbl(l_count).inventory_item_id,
819: p_orgID,
820: p_wipEntityID,
821: decode(l_compTbl(l_count).wip_supply_type,
822: wip_constants.phantom, -1*l_opSeq, l_opSeq),
823: null,
824: sysdate,
825: fnd_global.user_id,
826: sysdate,

Line 836: round(round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision)*l_multipleFactor/

832: sysdate,
833: l_compTbl(l_count).component_sequence_id,
834: l_compTbl(l_count).wip_supply_type,
835: p_jobStartDate,
836: round(round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision)*l_multipleFactor/
837: l_compTbl(l_count).component_yield_factor, wip_constants.max_displayed_precision),
838: /*For Component Yield Enhancement(Bug 4369064)->Always need to consider yield factor*/
839: 0,
840: round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision),

Line 837: l_compTbl(l_count).component_yield_factor, wip_constants.max_displayed_precision),

833: l_compTbl(l_count).component_sequence_id,
834: l_compTbl(l_count).wip_supply_type,
835: p_jobStartDate,
836: round(round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision)*l_multipleFactor/
837: l_compTbl(l_count).component_yield_factor, wip_constants.max_displayed_precision),
838: /*For Component Yield Enhancement(Bug 4369064)->Always need to consider yield factor*/
839: 0,
840: round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision),
841: l_compTbl(l_count).component_yield_factor, /*For Component Yield Enhancement(Bug 4369064) */

Line 840: round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision),

836: round(round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision)*l_multipleFactor/
837: l_compTbl(l_count).component_yield_factor, wip_constants.max_displayed_precision),
838: /*For Component Yield Enhancement(Bug 4369064)->Always need to consider yield factor*/
839: 0,
840: round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision),
841: l_compTbl(l_count).component_yield_factor, /*For Component Yield Enhancement(Bug 4369064) */
842: decode(l_compTbl(l_count).basis_type,WIP_CONSTANTS.LOT_BASED_MTL,2,NULL),
843: l_compTbl(l_count).supply_subinventory,
844: l_compTbl(l_count).supply_locator_id,

Line 842: decode(l_compTbl(l_count).basis_type,WIP_CONSTANTS.LOT_BASED_MTL,2,NULL),

838: /*For Component Yield Enhancement(Bug 4369064)->Always need to consider yield factor*/
839: 0,
840: round(l_compTbl(l_count).primary_quantity, wip_constants.max_displayed_precision),
841: l_compTbl(l_count).component_yield_factor, /*For Component Yield Enhancement(Bug 4369064) */
842: decode(l_compTbl(l_count).basis_type,WIP_CONSTANTS.LOT_BASED_MTL,2,NULL),
843: l_compTbl(l_count).supply_subinventory,
844: l_compTbl(l_count).supply_locator_id,
845: decode(l_compTbl(l_count).wip_supply_type, 5, 2,
846: decode(sign(l_compTbl(l_count).primary_quantity), -1, 2, l_mrpFlag)));

Line 854: if ( l_usePhantomRouting = wip_constants.yes ) then

850: l_count := l_compTbl.next(l_count);
851: end loop;
852:
853: l_usePhantomRouting := wip_globals.use_phantom_routings(p_orgID);
854: if ( l_usePhantomRouting = wip_constants.yes ) then
855: for phan in c_phantoms loop
856: wip_explode_phantom_rtgs.explode_resources(
857: p_wip_entity_id => p_wipEntityID,
858: p_sched_id => p_repSchedID,

Line 877: if (l_logLevel <= wip_constants.full_logging) then

873: x_return_status => x_returnStatus,
874: x_msg_data => x_errorMsg );
875:
876: if (x_returnStatus <> fnd_api.g_ret_sts_success) then
877: if (l_logLevel <= wip_constants.full_logging) then
878: wip_logger.log(p_msg => 'Post_Explosion_Cleanup failed for wip_entity_id '||p_wipEntityID,
879: x_returnStatus => x_returnStatus);
880: end if;
881: return;

Line 892: decode(wro.wip_supply_type, wip_constants.assy_pull,

888: department_id,
889: wip_supply_type) =
890: (select nvl(max(wo.first_unit_start_date), wro.date_required),
891: max(department_id),
892: decode(wro.wip_supply_type, wip_constants.assy_pull,
893: decode(nvl(max(wo.count_point_type), 0),
894: wip_constants.no_manual, wip_constants.op_pull,
895: wro.wip_supply_type),
896: wro.wip_supply_type)

Line 894: wip_constants.no_manual, wip_constants.op_pull,

890: (select nvl(max(wo.first_unit_start_date), wro.date_required),
891: max(department_id),
892: decode(wro.wip_supply_type, wip_constants.assy_pull,
893: decode(nvl(max(wo.count_point_type), 0),
894: wip_constants.no_manual, wip_constants.op_pull,
895: wro.wip_supply_type),
896: wro.wip_supply_type)
897: from wip_operations wo
898: where wo.organization_id = wro.organization_id

Line 985: if (l_logLevel <= wip_constants.trace_logging) then

981: where wro.wip_entity_id = p_wipEntityID
982: and nvl(wro.repetitive_schedule_id, -1) = nvl(p_repSchedID, -1)
983: and wro.organization_id = p_orgID;
984:
985: if (l_logLevel <= wip_constants.trace_logging) then
986: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
987: p_procReturnStatus => x_returnStatus,
988: p_msg => 'success',
989: x_returnStatus => l_retStatus);

Line 993: if (l_logLevel <= wip_constants.trace_logging) then

989: x_returnStatus => l_retStatus);
990: end if;
991: exception
992: when fnd_api.g_exc_unexpected_error then
993: if (l_logLevel <= wip_constants.trace_logging) then
994: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
995: p_procReturnStatus => x_returnStatus,
996: p_msg => 'failed at exploding requirements',
997: x_returnStatus => l_retStatus); --discard logging return status

Line 1000: if(l_logLevel <= wip_constants.trace_logging) then

996: p_msg => 'failed at exploding requirements',
997: x_returnStatus => l_retStatus); --discard logging return status
998: end if;
999: when others then
1000: if(l_logLevel <= wip_constants.trace_logging) then
1001: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1002: p_procReturnStatus => x_returnStatus,
1003: p_msg => 'unexp error:' || SQLERRM,
1004: x_returnStatus => l_retStatus);

Line 1032: if (l_logLevel <= wip_constants.trace_logging) then

1028: l_minOp number;
1029: begin
1030:
1031: x_returnStatus := fnd_api.g_ret_sts_success;
1032: if (l_logLevel <= wip_constants.trace_logging) then
1033: l_params(1).paramName := 'p_orgID';
1034: l_params(1).paramValue := p_orgID;
1035: l_params(2).paramName := 'p_wipEntityID';
1036: l_params(2).paramValue := p_wipEntityID;

Line 1057: l_jobStatus not in (wip_constants.unreleased,

1053: where organization_id = p_orgID
1054: and wip_entity_id = p_wipEntityID;
1055:
1056: if ( p_qty is null or
1057: l_jobStatus not in (wip_constants.unreleased,
1058: wip_constants.released,
1059: wip_constants.comp_chrg,
1060: wip_constants.hold) ) then
1061: if(l_logLevel <= wip_constants.trace_logging) then

Line 1058: wip_constants.released,

1054: and wip_entity_id = p_wipEntityID;
1055:
1056: if ( p_qty is null or
1057: l_jobStatus not in (wip_constants.unreleased,
1058: wip_constants.released,
1059: wip_constants.comp_chrg,
1060: wip_constants.hold) ) then
1061: if(l_logLevel <= wip_constants.trace_logging) then
1062: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,

Line 1059: wip_constants.comp_chrg,

1055:
1056: if ( p_qty is null or
1057: l_jobStatus not in (wip_constants.unreleased,
1058: wip_constants.released,
1059: wip_constants.comp_chrg,
1060: wip_constants.hold) ) then
1061: if(l_logLevel <= wip_constants.trace_logging) then
1062: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1063: p_procReturnStatus => x_returnStatus,

Line 1060: wip_constants.hold) ) then

1056: if ( p_qty is null or
1057: l_jobStatus not in (wip_constants.unreleased,
1058: wip_constants.released,
1059: wip_constants.comp_chrg,
1060: wip_constants.hold) ) then
1061: if(l_logLevel <= wip_constants.trace_logging) then
1062: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1063: p_procReturnStatus => x_returnStatus,
1064: p_msg => 'no qty change or job status is not right',

Line 1061: if(l_logLevel <= wip_constants.trace_logging) then

1057: l_jobStatus not in (wip_constants.unreleased,
1058: wip_constants.released,
1059: wip_constants.comp_chrg,
1060: wip_constants.hold) ) then
1061: if(l_logLevel <= wip_constants.trace_logging) then
1062: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1063: p_procReturnStatus => x_returnStatus,
1064: p_msg => 'no qty change or job status is not right',
1065: x_returnStatus => l_retStatus);

Line 1071: if ( l_jobStatus <> wip_constants.unreleased ) then

1067: return;
1068: end if;
1069:
1070:
1071: if ( l_jobStatus <> wip_constants.unreleased ) then
1072: select nvl(min(operation_seq_num), fnd_api.g_miss_num)
1073: into l_minOp
1074: from wip_operations
1075: where organization_id = p_orgID

Line 1079: if(l_logLevel <= wip_constants.trace_logging) then

1075: where organization_id = p_orgID
1076: and wip_entity_id = p_wipEntityID;
1077:
1078: if ( l_minOp = fnd_api.g_miss_num ) then
1079: if(l_logLevel <= wip_constants.trace_logging) then
1080: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1081: p_procReturnStatus => x_returnStatus,
1082: p_msg => 'no operation exist',
1083: x_returnStatus => l_retStatus);

Line 1119: if (l_logLevel <= wip_constants.trace_logging) then

1115: round(quantity_per_assembly/nvl(component_yield_factor,1) * p_qty, 6))
1116: where organization_id = p_orgID
1117: and wip_entity_id = p_wipEntityID;
1118:
1119: if (l_logLevel <= wip_constants.trace_logging) then
1120: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1121: p_procReturnStatus => x_returnStatus,
1122: p_msg => 'success',
1123: x_returnStatus => l_retStatus);

Line 1128: if(l_logLevel <= wip_constants.trace_logging) then

1124: end if;
1125:
1126: exception
1127: when others then
1128: if(l_logLevel <= wip_constants.trace_logging) then
1129: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
1130: p_procReturnStatus => x_returnStatus,
1131: p_msg => 'unexp error:' || SQLERRM,
1132: x_returnStatus => l_retStatus);