APPS.WIP_PICKING_PVT dependencies on WIP_CONSTANTS

Line 20: and wip_supply_type = wip_constants.phantom

16: component_code, operation_seq_num
17: from wip_explosions_v
18: where top_bill_sequence_id = p_bill_sequence_id
19: and organization_id = p_organization_id
20: and wip_supply_type = wip_constants.phantom
21: order by component_code;
22:
23: CURSOR c_lock
24: IS select '1'

Line 155: if(p_wip_entity_type not in (wip_constants.discrete,

151: where mtrl.header_id = mtrh.header_id
152: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK);
153:
154: BEGIN
155: if(p_wip_entity_type not in (wip_constants.discrete,
156: wip_constants.lotbased,
157: wip_constants.repetitive,
158: wip_constants.flow,
159: wip_constants.eam)) then

Line 156: wip_constants.lotbased,

152: and mtrh.move_order_type = INV_Globals.G_MOVE_ORDER_MFG_PICK);
153:
154: BEGIN
155: if(p_wip_entity_type not in (wip_constants.discrete,
156: wip_constants.lotbased,
157: wip_constants.repetitive,
158: wip_constants.flow,
159: wip_constants.eam)) then
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 157: wip_constants.repetitive,

153:
154: BEGIN
155: if(p_wip_entity_type not in (wip_constants.discrete,
156: wip_constants.lotbased,
157: wip_constants.repetitive,
158: wip_constants.flow,
159: wip_constants.eam)) then
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');

Line 158: wip_constants.flow,

154: BEGIN
155: if(p_wip_entity_type not in (wip_constants.discrete,
156: wip_constants.lotbased,
157: wip_constants.repetitive,
158: wip_constants.flow,
159: wip_constants.eam)) then
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
162: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.Incorrect Entity type passed');

Line 159: wip_constants.eam)) then

155: if(p_wip_entity_type not in (wip_constants.discrete,
156: wip_constants.lotbased,
157: wip_constants.repetitive,
158: wip_constants.flow,
159: wip_constants.eam)) then
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
162: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.Incorrect Entity type passed');
163: x_msg_data := fnd_message.get;

Line 170: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

166:
167: SAVEPOINT WIP_CANCEL_ALLOCS_START;
168:
169: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
170: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
171: open c_discLines;
172: elsif(p_wip_entity_type = wip_constants.repetitive) then
173: open c_repLines;
174: elsif(p_wip_entity_type = wip_constants.flow) then

Line 172: elsif(p_wip_entity_type = wip_constants.repetitive) then

168:
169: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
170: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
171: open c_discLines;
172: elsif(p_wip_entity_type = wip_constants.repetitive) then
173: open c_repLines;
174: elsif(p_wip_entity_type = wip_constants.flow) then
175: open c_flowLines;
176: end if;

Line 174: elsif(p_wip_entity_type = wip_constants.flow) then

170: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
171: open c_discLines;
172: elsif(p_wip_entity_type = wip_constants.repetitive) then
173: open c_repLines;
174: elsif(p_wip_entity_type = wip_constants.flow) then
175: open c_flowLines;
176: end if;
177: loop --need to handle failure conditions!!!
178: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

Line 178: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

174: elsif(p_wip_entity_type = wip_constants.flow) then
175: open c_flowLines;
176: end if;
177: loop --need to handle failure conditions!!!
178: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
179: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
180: exit when c_discLines%NOTFOUND;
181: elsif(p_wip_entity_type = wip_constants.repetitive) then
182: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;

Line 181: elsif(p_wip_entity_type = wip_constants.repetitive) then

177: loop --need to handle failure conditions!!!
178: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
179: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
180: exit when c_discLines%NOTFOUND;
181: elsif(p_wip_entity_type = wip_constants.repetitive) then
182: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;
183: exit when c_repLines%NOTFOUND;
184: elsif(p_wip_entity_type = wip_constants.flow) then
185: fetch c_flowLines into l_lineID;

Line 184: elsif(p_wip_entity_type = wip_constants.flow) then

180: exit when c_discLines%NOTFOUND;
181: elsif(p_wip_entity_type = wip_constants.repetitive) then
182: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;
183: exit when c_repLines%NOTFOUND;
184: elsif(p_wip_entity_type = wip_constants.flow) then
185: fetch c_flowLines into l_lineID;
186: exit when c_flowLines%NOTFOUND;
187: end if;
188:

Line 216: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

212: close c_flowLines;
213: end if;
214:
215: --finally update all backordered quantity to 0
216: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
217: --Fix bug 15874569
218: SAVEPOINT updateBackorder;
219: LOOP
220: BEGIN

Line 232: elsif(p_wip_entity_type = wip_constants.repetitive) then

228: dbms_lock.sleep(5);
229: END;
230: END LOOP;
231: --End of Fix bug 15874569
232: elsif(p_wip_entity_type = wip_constants.repetitive) then
233: update wip_requirement_operations
234: set quantity_backordered = 0
235: where wip_entity_id = p_wip_entity_id
236: and repetitive_schedule_id = p_repetitive_schedule_id;

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

311: BEGIN
312: SAVEPOINT WIP_CANCEL_COMP_ALLOCS_START;
313: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
314:
315: if (l_logLevel <= wip_constants.trace_logging) then
316: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
317: end if;
318: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
319: open c_discLines;

Line 318: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

314:
315: if (l_logLevel <= wip_constants.trace_logging) then
316: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
317: end if;
318: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
319: open c_discLines;
320: elsif(p_wip_entity_type = wip_constants.repetitive) then
321: open c_repLines;
322: else

Line 320: elsif(p_wip_entity_type = wip_constants.repetitive) then

316: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
317: end if;
318: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
319: open c_discLines;
320: elsif(p_wip_entity_type = wip_constants.repetitive) then
321: open c_repLines;
322: else
323: if (l_logLevel <= wip_constants.trace_logging) then
324: wip_logger.log('Invalid entity type passed to wip_picking_pvt.cancel_comp_allocations:'

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

319: open c_discLines;
320: elsif(p_wip_entity_type = wip_constants.repetitive) then
321: open c_repLines;
322: else
323: if (l_logLevel <= wip_constants.trace_logging) then
324: wip_logger.log('Invalid entity type passed to wip_picking_pvt.cancel_comp_allocations:'
325: || p_wip_entity_type, l_dummy);
326: end if;
327: end if;

Line 330: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

326: end if;
327: end if;
328:
329: loop
330: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
331: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
332: exit when c_discLines%NOTFOUND;
333: elsif(p_wip_entity_type = wip_constants.repetitive) then
334: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;

Line 333: elsif(p_wip_entity_type = wip_constants.repetitive) then

329: loop
330: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
331: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
332: exit when c_discLines%NOTFOUND;
333: elsif(p_wip_entity_type = wip_constants.repetitive) then
334: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;
335: exit when c_repLines%NOTFOUND;
336: end if;
337:

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

334: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;
335: exit when c_repLines%NOTFOUND;
336: end if;
337:
338: if (l_logLevel <= wip_constants.trace_logging) then
339: wip_logger.log('line ID:' || l_lineID || ',Open Qty:' || l_openQty || ',WRO RowID:'
340: || l_wroRowID || ',p_wip_entity_type:' || p_wip_entity_type, l_dummy);
341: end if;
342:

Line 367: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

363: raise FND_API.G_EXC_UNEXPECTED_ERROR;
364: end if;
365:
366: --finally update backordered quantity to 0
367: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
368: update wip_requirement_operations
369: set quantity_backordered = 0
370: where wip_entity_id = p_wip_entity_id
371: and operation_seq_num = p_operation_seq_num

Line 373: elsif(p_wip_entity_type = wip_constants.repetitive) then

369: set quantity_backordered = 0
370: where wip_entity_id = p_wip_entity_id
371: and operation_seq_num = p_operation_seq_num
372: and inventory_item_id = p_inventory_item_id;
373: elsif(p_wip_entity_type = wip_constants.repetitive) then
374: update wip_requirement_operations
375: set quantity_backordered = 0
376: where wip_entity_id = p_wip_entity_id
377: and repetitive_schedule_id = p_repetitive_schedule_id

Line 481: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

477: BEGIN
478: SAVEPOINT WIP_REDUCE_COMP_ALLOCS_START;
479: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
480: for i in 1..p_comp_tbl.COUNT LOOP /* Component Loop*/
481: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
482: open c_discLines(p_comp_tbl(i).wip_entity_id, p_comp_tbl(i).operation_seq_num, p_comp_tbl(i).inventory_item_id);
483: elsif(p_wip_entity_type = wip_constants.repetitive) then
484: open c_repLines(p_comp_tbl(i).wip_entity_id, p_comp_tbl(i).repetitive_schedule_id, p_comp_tbl(i).operation_seq_num, p_comp_tbl(i).inventory_item_id);
485: end if;

Line 483: elsif(p_wip_entity_type = wip_constants.repetitive) then

479: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
480: for i in 1..p_comp_tbl.COUNT LOOP /* Component Loop*/
481: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
482: open c_discLines(p_comp_tbl(i).wip_entity_id, p_comp_tbl(i).operation_seq_num, p_comp_tbl(i).inventory_item_id);
483: elsif(p_wip_entity_type = wip_constants.repetitive) then
484: open c_repLines(p_comp_tbl(i).wip_entity_id, p_comp_tbl(i).repetitive_schedule_id, p_comp_tbl(i).operation_seq_num, p_comp_tbl(i).inventory_item_id);
485: end if;
486: l_reductionQty := p_comp_tbl(i).requested_quantity;
487:

Line 490: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

486: l_reductionQty := p_comp_tbl(i).requested_quantity;
487:
488: Loop /* Loop through all the MO lines for this component */
489:
490: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
491: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
492: exit when c_discLines%NOTFOUND;
493: elsif(p_wip_entity_type = wip_constants.repetitive) then
494: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;

Line 493: elsif(p_wip_entity_type = wip_constants.repetitive) then

489:
490: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
491: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
492: exit when c_discLines%NOTFOUND;
493: elsif(p_wip_entity_type = wip_constants.repetitive) then
494: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;
495: exit when c_repLines%NOTFOUND;
496: end if;
497:

Line 541: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then

537: close c_repLines;
538: end if;
539:
540: /*finally update backordered quantity and allocated quantity for this component*/
541: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
542: update wip_requirement_operations
543: set quantity_backordered = greatest((quantity_backordered - p_comp_tbl(i).requested_quantity), 0),
544: quantity_allocated = quantity_allocated - p_comp_tbl(i).requested_quantity
545: where wip_entity_id = p_comp_tbl(i).wip_entity_id

Line 548: elsif(p_wip_entity_type = wip_constants.repetitive) then

544: quantity_allocated = quantity_allocated - p_comp_tbl(i).requested_quantity
545: where wip_entity_id = p_comp_tbl(i).wip_entity_id
546: and operation_seq_num = p_comp_tbl(i).operation_seq_num
547: and inventory_item_id = p_comp_tbl(i).inventory_item_id;
548: elsif(p_wip_entity_type = wip_constants.repetitive) then
549: update wip_requirement_operations
550: set quantity_backordered = greatest(quantity_backordered - p_comp_tbl(i).requested_quantity, 0),
551: quantity_allocated = quantity_allocated - p_comp_tbl(i).requested_quantity
552: where wip_entity_id = p_comp_tbl(i).wip_entity_id

Line 896: l_disc NUMBER := wip_constants.discrete;

892: l_linesRec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
893: l_hdrRec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
894: l_defaultSub VARCHAR2(10);
895: l_defaultLocator NUMBER;
896: l_disc NUMBER := wip_constants.discrete;
897: l_eam NUMBER := wip_constants.eam;
898: l_lotbased NUMBER := wip_constants.lotbased;
899: l_repetitive NUMBER := wip_constants.repetitive;
900: l_msgCount NUMBER;

Line 897: l_eam NUMBER := wip_constants.eam;

893: l_hdrRec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
894: l_defaultSub VARCHAR2(10);
895: l_defaultLocator NUMBER;
896: l_disc NUMBER := wip_constants.discrete;
897: l_eam NUMBER := wip_constants.eam;
898: l_lotbased NUMBER := wip_constants.lotbased;
899: l_repetitive NUMBER := wip_constants.repetitive;
900: l_msgCount NUMBER;
901: l_dummy VARCHAR2(1);

Line 898: l_lotbased NUMBER := wip_constants.lotbased;

894: l_defaultSub VARCHAR2(10);
895: l_defaultLocator NUMBER;
896: l_disc NUMBER := wip_constants.discrete;
897: l_eam NUMBER := wip_constants.eam;
898: l_lotbased NUMBER := wip_constants.lotbased;
899: l_repetitive NUMBER := wip_constants.repetitive;
900: l_msgCount NUMBER;
901: l_dummy VARCHAR2(1);
902: l_abm VARCHAR2(10);

Line 899: l_repetitive NUMBER := wip_constants.repetitive;

895: l_defaultLocator NUMBER;
896: l_disc NUMBER := wip_constants.discrete;
897: l_eam NUMBER := wip_constants.eam;
898: l_lotbased NUMBER := wip_constants.lotbased;
899: l_repetitive NUMBER := wip_constants.repetitive;
900: l_msgCount NUMBER;
901: l_dummy VARCHAR2(1);
902: l_abm VARCHAR2(10);
903: l_revControlCode varchar2(3);

Line 946: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)

942: and (
943: ( 'Y' = (select allocate_backflush_components
944: from wip_parameters wp
945: where organization_id = wro.organization_id)
946: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
947: )
948: or wro.wip_supply_type = wip_constants.push
949: )
950: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

Line 948: or wro.wip_supply_type = wip_constants.push

944: from wip_parameters wp
945: where organization_id = wro.organization_id)
946: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
947: )
948: or wro.wip_supply_type = wip_constants.push
949: )
950: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then
951: 0.00001 (least amount inventory can transfer)*/
952: and (wro.required_quantity - (wro.quantity_issued

Line 1005: and wro.wip_supply_type <> wip_constants.bulk

1001: and (wo.count_point_type is null or wo.count_point_type in (1,2))
1002: and wro.auto_request_material = 'Y'
1003: and wro.organization_id = msi.organization_id
1004: and wro.organization_id = p_organization_id
1005: and wro.wip_supply_type <> wip_constants.bulk
1006: and msi.mtl_transactions_enabled_flag = 'Y' /* fix for bug# 2468515 */
1007: for update of wro.quantity_allocated, wro.quantity_backordered, wro.quantity_issued nowait;
1008: /*Bug 5119650 and 5119601 */
1009: /* Modified the calculation of open quantity considering lot basis of component and yield factor*/

Line 1013: ((decode (nvl(wro.basis_type,wip_constants.item_based_mtl),wip_constants.item_based_mtl,

1009: /* Modified the calculation of open quantity considering lot basis of component and yield factor*/
1010: CURSOR c_lotJobs(v_wip_entity_id NUMBER) IS
1011: select wro.operation_seq_num,
1012: wro.inventory_item_id,
1013: ((decode (nvl(wro.basis_type,wip_constants.item_based_mtl),wip_constants.item_based_mtl,
1014: (wo.quantity_in_queue + wo.quantity_running + wo.quantity_completed),1) *
1015: wro.quantity_per_assembly /
1016: decode(l_include_yield,l_include_comp_yield_factor,nvl(wro.component_yield_factor,1),1))
1017: - wro.quantity_issued

Line 1037: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)

1033: and (
1034: ( 'Y' = (select allocate_backflush_components
1035: from wip_parameters wp
1036: where organization_id = wro.organization_id)
1037: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1038: )
1039: or wro.wip_supply_type = wip_constants.push
1040: )
1041: -- and (nvl(wro.quantity_allocated,0) + wro.quantity_issued) < ((wo.quantity_in_queue + wo.quantity_running +

Line 1039: or wro.wip_supply_type = wip_constants.push

1035: from wip_parameters wp
1036: where organization_id = wro.organization_id)
1037: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1038: )
1039: or wro.wip_supply_type = wip_constants.push
1040: )
1041: -- and (nvl(wro.quantity_allocated,0) + wro.quantity_issued) < ((wo.quantity_in_queue + wo.quantity_running +
1042: -- wo.quantity_completed) * wro.quantity_per_assembly)
1043: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

Line 1086: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)

1082: and (
1083: ( 'Y' = (select allocate_backflush_components
1084: from wip_parameters wp
1085: where organization_id = wro.organization_id)
1086: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1087: )
1088: or wro.wip_supply_type = wip_constants.push
1089: )
1090: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

Line 1088: or wro.wip_supply_type = wip_constants.push

1084: from wip_parameters wp
1085: where organization_id = wro.organization_id)
1086: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1087: )
1088: or wro.wip_supply_type = wip_constants.push
1089: )
1090: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then
1091: 0.00001 (least amount inventory can transfer)*/
1092: and (wro.required_quantity - (wro.quantity_issued +

Line 1109: l_push NUMBER := wip_constants.push;

1105: --to avoid multiple unnecessary cross package calls when creating lines.
1106: l_sysDate DATE := sysdate;
1107: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1108: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1109: l_push NUMBER := wip_constants.push;
1110: /* Bug 4917429 */
1111: l_jobname VARCHAR2(240);
1112: l_item VARCHAR2(2000);
1113:

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

1123: select nvl(include_component_yield,1)
1124: into l_include_yield
1125: from wip_parameters
1126: where organization_id = p_organization_id;
1127: if (l_logLevel <= wip_constants.trace_logging) then
1128: wip_logger.log('wip_picking_pvt.allocate => job count in table passed into allocate(): '
1129: || p_alloc_tbl.COUNT, l_dummy2);
1130: wip_logger.log('p_days_to_alloc=' || p_days_to_alloc || ',p_auto_detail_flag=' || p_auto_detail_flag ||
1131: ',p_start_date=' || p_start_date || ',p_cutoff_date=' || p_cutoff_date ||

Line 1150: elsif(p_wip_entity_type = wip_constants.flow) then --flow

1146: elsif(p_wip_entity_type = l_lotbased) then
1147: open c_lotJobs(p_alloc_tbl(i).wip_entity_id);
1148: elsif(p_wip_entity_type = l_repetitive) then
1149: open c_rep(p_alloc_tbl(i).repetitive_schedule_id);
1150: elsif(p_wip_entity_type = wip_constants.flow) then --flow
1151:
1152: if (l_logLevel <= wip_constants.trace_logging) then
1153: wip_logger.log('wip_picking_pvt.allocate => processing job: (wei)'
1154: || p_alloc_tbl(i).wip_entity_id

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

1148: elsif(p_wip_entity_type = l_repetitive) then
1149: open c_rep(p_alloc_tbl(i).repetitive_schedule_id);
1150: elsif(p_wip_entity_type = wip_constants.flow) then --flow
1151:
1152: if (l_logLevel <= wip_constants.trace_logging) then
1153: wip_logger.log('wip_picking_pvt.allocate => processing job: (wei)'
1154: || p_alloc_tbl(i).wip_entity_id
1155: || ';job counter=' || i || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1156: end if;

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

1229: p_ably_qty => l_assemblyQty,
1230: p_req_date => p_alloc_tbl(i).required_date,
1231: x_opt_total => l_opt_cnt);
1232:
1233: if (l_logLevel <= wip_constants.trace_logging) then
1234: wip_logger.log('wip_picking_pvt.allocate => ' ||
1235: 'flow optimal group total: ' || l_opt_cnt, l_dummy2);
1236: end if;
1237: -- no flow sched can be grouped together

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

1281: -- can not optimize, b/c bom is not the same for the group,
1282: -- reset counter, and proceed as normal(one record at a time)
1283: l_opt_cnt := 0;
1284:
1285: if (l_logLevel <= wip_constants.trace_logging) then
1286: wip_logger.log('wip_picking_pvt.allocate => ' ||
1287: 'flow optimal group NOT optimzable', l_dummy2);
1288: end if;
1289: else

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

1288: end if;
1289: else
1290: -- can be optimized, do nothing here, it will be processed
1291: -- as a whole right before passing to INV
1292: if (l_logLevel <= wip_constants.trace_logging) then
1293: wip_logger.log('wip_picking_pvt.allocate => ' ||
1294: 'flow optimal group IS optimzable', l_dummy2);
1295: end if;
1296: end if;

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

1298: else -- if (l_opt_cnt > 0)
1299: -- in the middle of an optimized flow sched group, jump to the end
1300: -- of the jobs loop, since this whole group has been added to
1301: -- l_linesTable to pass to INV
1302: if (l_logLevel <= wip_constants.trace_logging) then
1303: wip_logger.log('wip_picking_pvt.allocate => ' ||
1304: 'processing flow optimal group..', l_dummy2);
1305: end if;
1306: l_opt_cnt := l_opt_cnt-1;

Line 1352: elsif(p_wip_entity_type = wip_constants.flow) then --flow

1348: elsif(p_wip_entity_type = l_lotbased) then
1349: fetch c_lotJobs into l_operationSeqNum, l_itemID, l_openQty, l_subinv, l_locator, l_uom, l_supplyType, l_reqDate,l_revControlCode;
1350: exit when c_lotJobs%NOTFOUND;
1351:
1352: elsif(p_wip_entity_type = wip_constants.flow) then --flow
1353: j := j+1;
1354: if (j > l_flowCompTbl.COUNT) then
1355: exit;
1356: end if;

Line 1382: l_supplyType := wip_constants.ASSY_PULL; --although defined as push, flow allocations always behave as pull components

1378: l_subinv := l_flowCompTbl(j).source_subinventory_code;
1379: l_locator := l_flowCompTbl(j).source_locator_id;
1380: l_uom := l_flowCompTbl(j).primary_uom_code;
1381: l_revControlCode := l_flowCompTbl(j).revision;
1382: l_supplyType := wip_constants.ASSY_PULL; --although defined as push, flow allocations always behave as pull components
1383: end if;
1384:
1385: if (l_logLevel <= wip_constants.trace_logging) then
1386: wip_logger.log(' op_seq_num=' || l_operationSeqNum || ',item_id=' || l_itemID || ',open qty=' || l_openQty

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

1381: l_revControlCode := l_flowCompTbl(j).revision;
1382: l_supplyType := wip_constants.ASSY_PULL; --although defined as push, flow allocations always behave as pull components
1383: end if;
1384:
1385: if (l_logLevel <= wip_constants.trace_logging) then
1386: wip_logger.log(' op_seq_num=' || l_operationSeqNum || ',item_id=' || l_itemID || ',open qty=' || l_openQty
1387: || ',subinv=' || l_subinv || ',loc=' || l_locator || ',supplyType=' || l_supplyType
1388: || ',reqDate=' || l_reqDate, l_dummy2);
1389: end if;

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

1482: <>
1483: null;
1484: end loop; --end per entity loop
1485:
1486: if (l_logLevel <= wip_constants.trace_logging) then
1487: wip_logger.log('wip_picking_pvt.allocate => line count passed to inv_wip_picking_pvt.release_pick_batch: '
1488: || l_lineCount || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1489: end if;
1490: if(l_lineCount > 0) then

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

1501: p_init_msg_lst => fnd_api.g_true,
1502: x_mo_line_errrec_tbl => x_MOLineErrTbl);
1503: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);
1504:
1505: if (l_logLevel <= wip_constants.trace_logging) then
1506: wip_logger.log('returned status from call to inv_wip_picking_pvt.release_pick_batch() = ' || l_pickStatus || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1507: end if;
1508:
1509: --bugfix 4435437

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

1572: raise FND_API.G_EXC_ERROR;
1573: end if;
1574: end if; /* end of l_lineCount > 0 */
1575:
1576: if (l_logLevel <= wip_constants.trace_logging) then
1577: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_status='
1578: || l_pickStatus, l_dummy2);
1579: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_msg='
1580: || x_msg_data, l_dummy2);

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

1613: x_msg_data := fnd_message.get;
1614: end if;
1615: x_mo_req_number := l_hdrRec.request_number; /* Added as part of enhancement 2478446 */
1616:
1617: if (l_logLevel <= wip_constants.trace_logging) then
1618: wip_logger.cleanup(l_dummy2);
1619: end if;
1620:
1621: exception

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

1620:
1621: exception
1622: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls
1623: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1624: if (l_logLevel <= wip_constants.trace_logging) then
1625: wip_logger.log(x_msg_data, l_dummy2);
1626: wip_logger.cleanup(l_dummy2);
1627: end if;
1628: when RECORDS_LOCKED then

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

1629: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1630: x_return_status := 'L';
1631: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
1632: x_msg_data := fnd_message.get;
1633: if (l_logLevel <= wip_constants.trace_logging) then
1634: wip_logger.log(x_msg_data, l_dummy2);
1635: wip_logger.cleanup(l_dummy2);
1636: end if;
1637: when others then

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

1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1640: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1641: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
1642: x_msg_data := fnd_message.get;
1643: if (l_logLevel <= wip_constants.trace_logging) then
1644: wip_logger.log(x_msg_data, l_dummy2);
1645: wip_logger.cleanup(l_dummy2);
1646: end if;
1647: end allocate;

Line 1683: l_push NUMBER := wip_constants.push;

1679: l_sysDate DATE := sysdate;
1680: l_userId NUMBER := fnd_global.user_id;
1681: l_loginId NUMBER := fnd_global.login_id;
1682: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;
1683: l_push NUMBER := wip_constants.push;
1684: l_pick_grouping_rule_id NUMBER;
1685: l_unit_number VARCHAR2(30);
1686: BEGIN
1687:

Line 1709: if(p_wip_entity_type = wip_constants.eam) then

1705: p_linesRec.line_status := l_lineStatus;
1706: p_linesRec.operation := INV_Globals.G_OPR_CREATE;
1707:
1708: /* for EAM entity type, select picksilp grouping rule from wip_parameters. If no rule is defined, raise an exception with suitable message */
1709: if(p_wip_entity_type = wip_constants.eam) then
1710:
1711: select pickslip_grouping_rule_id
1712: into l_pick_grouping_rule_id
1713: from wip_parameters

Line 1729: if(p_wip_entity_type in(wip_constants.repetitive,wip_constants.discrete,wip_constants.eam,wip_constants.lotbased)) then

1725: p_hdrRec.grouping_rule_id := p_pick_grouping_rule_id;
1726: end if;
1727:
1728: /* moved to pre_allocate_material in wippckpb.pls per bug#2642679
1729: if(p_wip_entity_type in(wip_constants.repetitive,wip_constants.discrete,wip_constants.eam,wip_constants.lotbased)) then
1730: if(p_use_pickset_flag = 'N') then
1731: update wip_requirement_operations
1732: set quantity_backordered = p_open_qty,
1733: last_update_date = l_sysDate,

Line 1748: if(p_wip_entity_type = wip_constants.eam) then

1744: p_linesRec.txn_source_id := p_wip_entity_id;
1745: p_linesRec.txn_source_line_id := p_operation_seq_num;
1746: p_linesRec.reference_id := p_repetitive_schedule_id;
1747: p_linesRec.date_required := p_req_date;
1748: if(p_wip_entity_type = wip_constants.eam) then
1749: p_linesRec.to_subinventory_code := NULL;
1750: p_linesRec.to_locator_id := NULL;
1751: elsif(p_supply_type = l_push) then --push
1752: p_linesRec.to_subinventory_code := p_to_subinv;

Line 1790: if (p_wip_entity_type = wip_constants.discrete) then

1786: end if;
1787: */
1788: p_linesRec.revision := null;
1789: /* Fix bug 8274922 set unit_number for Unit Effective Assembly */
1790: if (p_wip_entity_type = wip_constants.discrete) then
1791: select end_item_unit_number
1792: into l_unit_number
1793: from wip_discrete_jobs
1794: where wip_entity_id = p_wip_entity_id

Line 1847: l_disc NUMBER := wip_constants.discrete;

1843: l_linesRec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
1844: l_hdrRec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1845: l_defaultSub VARCHAR2(10);
1846: l_defaultLocator NUMBER;
1847: l_disc NUMBER := wip_constants.discrete;
1848: l_eam NUMBER := wip_constants.eam;
1849: l_lotbased NUMBER := wip_constants.lotbased;
1850: l_repetitive NUMBER := wip_constants.repetitive;
1851: l_msgCount NUMBER;

Line 1848: l_eam NUMBER := wip_constants.eam;

1844: l_hdrRec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1845: l_defaultSub VARCHAR2(10);
1846: l_defaultLocator NUMBER;
1847: l_disc NUMBER := wip_constants.discrete;
1848: l_eam NUMBER := wip_constants.eam;
1849: l_lotbased NUMBER := wip_constants.lotbased;
1850: l_repetitive NUMBER := wip_constants.repetitive;
1851: l_msgCount NUMBER;
1852: l_revControlCode VARCHAR2(3);

Line 1849: l_lotbased NUMBER := wip_constants.lotbased;

1845: l_defaultSub VARCHAR2(10);
1846: l_defaultLocator NUMBER;
1847: l_disc NUMBER := wip_constants.discrete;
1848: l_eam NUMBER := wip_constants.eam;
1849: l_lotbased NUMBER := wip_constants.lotbased;
1850: l_repetitive NUMBER := wip_constants.repetitive;
1851: l_msgCount NUMBER;
1852: l_revControlCode VARCHAR2(3);
1853: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;

Line 1850: l_repetitive NUMBER := wip_constants.repetitive;

1846: l_defaultLocator NUMBER;
1847: l_disc NUMBER := wip_constants.discrete;
1848: l_eam NUMBER := wip_constants.eam;
1849: l_lotbased NUMBER := wip_constants.lotbased;
1850: l_repetitive NUMBER := wip_constants.repetitive;
1851: l_msgCount NUMBER;
1852: l_revControlCode VARCHAR2(3);
1853: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1854: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;

Line 1855: l_push NUMBER := wip_constants.push;

1851: l_msgCount NUMBER;
1852: l_revControlCode VARCHAR2(3);
1853: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1854: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1855: l_push NUMBER := wip_constants.push;
1856: l_carton_grouping_id NUMBER;
1857: TYPE carton_tbl_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1858: carton_tbl carton_tbl_t;
1859: l_string1 VARCHAR2(200);

Line 1899: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)

1895: and (
1896: ( 'Y' = (select allocate_backflush_components
1897: from wip_parameters wp
1898: where organization_id = wro.organization_id)
1899: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1900: )
1901: or wro.wip_supply_type = wip_constants.push
1902: )
1903: and wro.required_quantity > (wro.quantity_issued +

Line 1901: or wro.wip_supply_type = wip_constants.push

1897: from wip_parameters wp
1898: where organization_id = wro.organization_id)
1899: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1900: )
1901: or wro.wip_supply_type = wip_constants.push
1902: )
1903: and wro.required_quantity > (wro.quantity_issued +
1904: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1905: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))

Line 1982: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)

1978: and (
1979: ( 'Y' = (select allocate_backflush_components
1980: from wip_parameters wp
1981: where organization_id = wro.organization_id)
1982: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1983: )
1984: or wro.wip_supply_type = wip_constants.push
1985: )
1986: and ((wo.quantity_in_queue + wo.quantity_running + wo.quantity_completed) * wro.quantity_per_assembly) > (wro.quantity_issued +

Line 1984: or wro.wip_supply_type = wip_constants.push

1980: from wip_parameters wp
1981: where organization_id = wro.organization_id)
1982: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1983: )
1984: or wro.wip_supply_type = wip_constants.push
1985: )
1986: and ((wo.quantity_in_queue + wo.quantity_running + wo.quantity_completed) * wro.quantity_per_assembly) > (wro.quantity_issued +
1987: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1988: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))

Line 2029: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)

2025: and (
2026: ( 'Y' = (select allocate_backflush_components
2027: from wip_parameters wp
2028: where organization_id = wro.organization_id)
2029: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
2030: )
2031: or wro.wip_supply_type = wip_constants.push
2032: )
2033: and wro.required_quantity > (wro.quantity_issued +

Line 2031: or wro.wip_supply_type = wip_constants.push

2027: from wip_parameters wp
2028: where organization_id = wro.organization_id)
2029: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
2030: )
2031: or wro.wip_supply_type = wip_constants.push
2032: )
2033: and wro.required_quantity > (wro.quantity_issued +
2034: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
2035: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))

Line 2389: if(p_wip_entity_type = wip_constants.discrete) then

2385:
2386: retcode := 0;
2387: savepoint wip_allocate_concurrent;
2388:
2389: if(p_wip_entity_type = wip_constants.discrete) then
2390: open c_jobs;
2391: elsif(p_wip_entity_type = wip_constants.lotbased) then
2392: open c_lotjobs;
2393: elsif(p_wip_entity_type = wip_constants.repetitive) then

Line 2391: elsif(p_wip_entity_type = wip_constants.lotbased) then

2387: savepoint wip_allocate_concurrent;
2388:
2389: if(p_wip_entity_type = wip_constants.discrete) then
2390: open c_jobs;
2391: elsif(p_wip_entity_type = wip_constants.lotbased) then
2392: open c_lotjobs;
2393: elsif(p_wip_entity_type = wip_constants.repetitive) then
2394: open c_rep;
2395: --Added for opening the eAM Cursor (Added for eAM Enhancement 13608137 )

Line 2393: elsif(p_wip_entity_type = wip_constants.repetitive) then

2389: if(p_wip_entity_type = wip_constants.discrete) then
2390: open c_jobs;
2391: elsif(p_wip_entity_type = wip_constants.lotbased) then
2392: open c_lotjobs;
2393: elsif(p_wip_entity_type = wip_constants.repetitive) then
2394: open c_rep;
2395: --Added for opening the eAM Cursor (Added for eAM Enhancement 13608137 )
2396: elsif(p_wip_entity_type = wip_constants.eam) then
2397: open c_eam_jobs;

Line 2396: elsif(p_wip_entity_type = wip_constants.eam) then

2392: open c_lotjobs;
2393: elsif(p_wip_entity_type = wip_constants.repetitive) then
2394: open c_rep;
2395: --Added for opening the eAM Cursor (Added for eAM Enhancement 13608137 )
2396: elsif(p_wip_entity_type = wip_constants.eam) then
2397: open c_eam_jobs;
2398: else
2399: open c_flow;
2400: end if;

Line 2483: if(p_wip_entity_type = wip_constants.discrete) then

2479: fnd_message.set_name('WIP', 'WIP_PICKING_MFG_MODE');
2480: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2481:
2482: /* Bug 6046963: Added below if to print job type parameter in case of Discrete Job Comp Pick Release request only*/
2483: if(p_wip_entity_type = wip_constants.discrete) then
2484: /*Start - Bug 5932126 (FP of 5880558): Added following code to print new parameter for job type*/
2485: select meaning
2486: into l_outBuffer
2487: from mfg_lookups

Line 2500: if(p_wip_entity_type = wip_constants.discrete) then

2496: fnd_file.put_line(which => fnd_file.output, buff => '');
2497: fnd_file.put_line(which => fnd_file.output, buff => '');
2498:
2499: LOOP
2500: if(p_wip_entity_type = wip_constants.discrete) then
2501: fetch c_jobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2502: exit when c_jobs%NOTFOUND;
2503: elsif(p_wip_entity_type = wip_constants.lotbased) then
2504: fetch c_lotjobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;

Line 2503: elsif(p_wip_entity_type = wip_constants.lotbased) then

2499: LOOP
2500: if(p_wip_entity_type = wip_constants.discrete) then
2501: fetch c_jobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2502: exit when c_jobs%NOTFOUND;
2503: elsif(p_wip_entity_type = wip_constants.lotbased) then
2504: fetch c_lotjobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2505: exit when c_lotjobs%NOTFOUND;
2506: elsif(p_wip_entity_type = wip_constants.repetitive) then
2507: fetch c_rep into l_wipEntityID, l_outBuffer, l_repSchedID;

Line 2506: elsif(p_wip_entity_type = wip_constants.repetitive) then

2502: exit when c_jobs%NOTFOUND;
2503: elsif(p_wip_entity_type = wip_constants.lotbased) then
2504: fetch c_lotjobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2505: exit when c_lotjobs%NOTFOUND;
2506: elsif(p_wip_entity_type = wip_constants.repetitive) then
2507: fetch c_rep into l_wipEntityID, l_outBuffer, l_repSchedID;
2508: exit when c_rep%NOTFOUND;
2509: --Added for eAM Enhancement 13608137
2510: elsif(p_wip_entity_type = wip_constants.eam) then

Line 2510: elsif(p_wip_entity_type = wip_constants.eam) then

2506: elsif(p_wip_entity_type = wip_constants.repetitive) then
2507: fetch c_rep into l_wipEntityID, l_outBuffer, l_repSchedID;
2508: exit when c_rep%NOTFOUND;
2509: --Added for eAM Enhancement 13608137
2510: elsif(p_wip_entity_type = wip_constants.eam) then
2511: fetch c_eam_jobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID, l_eam_wro_date_req;
2512: exit when c_eam_jobs%NOTFOUND;
2513: else
2514: fetch c_flow into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;

Line 2678: if (l_comp_sys_rec.wip_supply_type = wip_constants.push) then

2674: j := 1;
2675: WHILE i IS NOT NULL LOOP
2676: l_comp_sys_rec := l_comp_sys_table(i);
2677: --all to pl/sql table
2678: if (l_comp_sys_rec.wip_supply_type = wip_constants.push) then
2679: l_comp_sql_rec.operation_seq_num := l_comp_sys_rec.operation_seq_num ;
2680: l_comp_sql_rec.inventory_item_id := l_comp_sys_rec.inventory_item_id ;
2681: l_comp_sql_rec.requested_quantity := l_comp_sys_rec.primary_quantity ;
2682: l_comp_sql_rec.source_subinventory_code := l_comp_sys_rec.supply_subinventory ;

Line 2687: if(round(abs(l_comp_sys_rec.primary_quantity), WIP_CONSTANTS.INV_MAX_PRECISION) <> 0) then

2683: l_comp_sql_rec.source_locator_id := l_comp_sys_rec.supply_locator_id ;
2684: l_comp_sql_rec.revision := l_comp_sys_rec.revision;
2685: l_comp_sql_rec.primary_uom_code := l_comp_sys_rec.primary_uom_code;
2686: l_comp_sql_rec.item_name:= l_comp_sys_rec.item_name;
2687: if(round(abs(l_comp_sys_rec.primary_quantity), WIP_CONSTANTS.INV_MAX_PRECISION) <> 0) then
2688: x_comp_sql_tbl(j) := l_comp_sql_rec;
2689: j := j+1;
2690: end if;
2691: end if;

Line 2714: and wip_supply_type in (wip_constants.op_pull, wip_constants.assy_pull);

2710: select unique operation_seq_num
2711: from wip_requirement_operations
2712: where wip_entity_id = v_wip_entity_id
2713: and organization_id = v_organization_id
2714: and wip_supply_type in (wip_constants.op_pull, wip_constants.assy_pull);
2715:
2716: CURSOR c_rep_operations(v_wip_entity_id NUMBER, v_repetitive_schedule_id NUMBER,
2717: v_organization_id NUMBER) IS
2718: select unique operation_seq_num

Line 2723: and wip_supply_type in (wip_constants.op_pull, wip_constants.assy_pull);

2719: from wip_requirement_operations
2720: where wip_entity_id = v_wip_entity_id
2721: and organization_id = v_organization_id
2722: and repetitive_schedule_id = v_repetitive_schedule_id
2723: and wip_supply_type in (wip_constants.op_pull, wip_constants.assy_pull);
2724: Begin
2725: x_return_status := FND_API.G_RET_STS_SUCCESS;
2726:
2727: l_logLevel := fnd_log.g_current_runtime_level;

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

2724: Begin
2725: x_return_status := FND_API.G_RET_STS_SUCCESS;
2726:
2727: l_logLevel := fnd_log.g_current_runtime_level;
2728: if (l_logLevel <= wip_constants.trace_logging) then
2729: wip_logger.log('In wip_picking_pvt.Post_Explosion_CleanUp():'
2730: || p_wip_entity_id || ':' || p_org_id
2731: || ':' || p_repetitive_schedule_id, l_dummy2);
2732: end if;

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

2778: x_return_status => x_return_status,
2779: x_msg_data => x_msg_data);
2780:
2781: if (x_return_status <> fnd_api.g_ret_sts_success) then
2782: if (l_logLevel <= wip_constants.trace_logging) then
2783: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2784: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2785: end if;
2786: Return;

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

2825: x_return_status => x_return_status,
2826: x_msg_data => x_msg_data);
2827:
2828: if (x_return_status <> fnd_api.g_ret_sts_success) then
2829: if (l_logLevel <= wip_constants.trace_logging) then
2830: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2831: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2832: end if;
2833: Return;

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

2847: when RECORDS_LOCKED then
2848: x_return_status := 'L';
2849: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
2850: x_msg_data := fnd_message.get;
2851: if (l_logLevel <= wip_constants.trace_logging) then
2852: wip_logger.log( x_msg_data, l_dummy2);
2853: wip_logger.cleanup(l_dummy2);
2854: end if;
2855: when others then

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

2857: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2858: fnd_message.set_token('ERROR_TEXT', 'WIP_EXPLODER_UTITLITIES.Post_Explosion_CleanUp:'
2859: || SQLERRM);
2860: x_msg_data := fnd_message.get;
2861: if (l_logLevel <= wip_constants.trace_logging) then
2862: wip_logger.log( x_msg_data, l_dummy2);
2863: wip_logger.cleanup(l_dummy2);
2864: end if;
2865: End Post_Explosion_CleanUp;