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_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 153: if(p_wip_entity_type not in (wip_constants.discrete,

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

Line 154: wip_constants.lotbased,

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

Line 155: wip_constants.repetitive,

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

Line 156: wip_constants.flow,

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

Line 157: wip_constants.eam)) then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

210: close c_flowLines;
211: end if;
212:
213: --finally update all backordered quantity to 0
214: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
215: update wip_requirement_operations
216: set quantity_backordered = 0
217: where wip_entity_id = p_wip_entity_id;
218: elsif(p_wip_entity_type = wip_constants.repetitive) then

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

214: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
215: update wip_requirement_operations
216: set quantity_backordered = 0
217: where wip_entity_id = p_wip_entity_id;
218: elsif(p_wip_entity_type = wip_constants.repetitive) then
219: update wip_requirement_operations
220: set quantity_backordered = 0
221: where wip_entity_id = p_wip_entity_id
222: and repetitive_schedule_id = p_repetitive_schedule_id;

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

297: BEGIN
298: SAVEPOINT WIP_CANCEL_COMP_ALLOCS_START;
299: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
300:
301: if (l_logLevel <= wip_constants.trace_logging) then
302: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
303: end if;
304: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
305: open c_discLines;

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

300:
301: if (l_logLevel <= wip_constants.trace_logging) then
302: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
303: end if;
304: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
305: open c_discLines;
306: elsif(p_wip_entity_type = wip_constants.repetitive) then
307: open c_repLines;
308: else

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

302: wip_logger.log('In wip_picking_pvt.cancel_comp_allocations', l_dummy);
303: end if;
304: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
305: open c_discLines;
306: elsif(p_wip_entity_type = wip_constants.repetitive) then
307: open c_repLines;
308: else
309: if (l_logLevel <= wip_constants.trace_logging) then
310: wip_logger.log('Invalid entity type passed to wip_picking_pvt.cancel_comp_allocations:'

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

305: open c_discLines;
306: elsif(p_wip_entity_type = wip_constants.repetitive) then
307: open c_repLines;
308: else
309: if (l_logLevel <= wip_constants.trace_logging) then
310: wip_logger.log('Invalid entity type passed to wip_picking_pvt.cancel_comp_allocations:'
311: || p_wip_entity_type, l_dummy);
312: end if;
313: end if;

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

312: end if;
313: end if;
314:
315: loop
316: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
317: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
318: exit when c_discLines%NOTFOUND;
319: elsif(p_wip_entity_type = wip_constants.repetitive) then
320: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;

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

315: loop
316: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
317: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
318: exit when c_discLines%NOTFOUND;
319: elsif(p_wip_entity_type = wip_constants.repetitive) then
320: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;
321: exit when c_repLines%NOTFOUND;
322: end if;
323:

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

320: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;
321: exit when c_repLines%NOTFOUND;
322: end if;
323:
324: if (l_logLevel <= wip_constants.trace_logging) then
325: wip_logger.log('line ID:' || l_lineID || ',Open Qty:' || l_openQty || ',WRO RowID:'
326: || l_wroRowID || ',p_wip_entity_type:' || p_wip_entity_type, l_dummy);
327: end if;
328:

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

349: raise FND_API.G_EXC_UNEXPECTED_ERROR;
350: end if;
351:
352: --finally update backordered quantity to 0
353: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
354: update wip_requirement_operations
355: set quantity_backordered = 0
356: where wip_entity_id = p_wip_entity_id
357: and operation_seq_num = p_operation_seq_num

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

355: set quantity_backordered = 0
356: where wip_entity_id = p_wip_entity_id
357: and operation_seq_num = p_operation_seq_num
358: and inventory_item_id = p_inventory_item_id;
359: elsif(p_wip_entity_type = wip_constants.repetitive) then
360: update wip_requirement_operations
361: set quantity_backordered = 0
362: where wip_entity_id = p_wip_entity_id
363: and repetitive_schedule_id = p_repetitive_schedule_id

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

463: BEGIN
464: SAVEPOINT WIP_REDUCE_COMP_ALLOCS_START;
465: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
466: for i in 1..p_comp_tbl.COUNT LOOP /* Component Loop*/
467: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
468: open c_discLines(p_comp_tbl(i).wip_entity_id, p_comp_tbl(i).operation_seq_num, p_comp_tbl(i).inventory_item_id);
469: elsif(p_wip_entity_type = wip_constants.repetitive) then
470: 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);
471: end if;

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

465: x_return_status := FND_API.G_RET_STS_SUCCESS; -- in case no open lines are found
466: for i in 1..p_comp_tbl.COUNT LOOP /* Component Loop*/
467: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
468: open c_discLines(p_comp_tbl(i).wip_entity_id, p_comp_tbl(i).operation_seq_num, p_comp_tbl(i).inventory_item_id);
469: elsif(p_wip_entity_type = wip_constants.repetitive) then
470: 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);
471: end if;
472: l_reductionQty := p_comp_tbl(i).requested_quantity;
473:

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

472: l_reductionQty := p_comp_tbl(i).requested_quantity;
473:
474: Loop /* Loop through all the MO lines for this component */
475:
476: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
477: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
478: exit when c_discLines%NOTFOUND;
479: elsif(p_wip_entity_type = wip_constants.repetitive) then
480: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;

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

475:
476: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
477: fetch c_discLines into l_lineID, l_openQty, l_wroRowID;
478: exit when c_discLines%NOTFOUND;
479: elsif(p_wip_entity_type = wip_constants.repetitive) then
480: fetch c_repLines into l_lineID, l_openQty, l_wroRowID;
481: exit when c_repLines%NOTFOUND;
482: end if;
483:

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

523: close c_repLines;
524: end if;
525:
526: /*finally update backordered quantity and allocated quantity for this component*/
527: if(p_wip_entity_type in (wip_constants.discrete, wip_constants.lotbased, wip_constants.eam)) then
528: update wip_requirement_operations
529: set quantity_backordered = greatest((quantity_backordered - p_comp_tbl(i).requested_quantity), 0),
530: quantity_allocated = quantity_allocated - p_comp_tbl(i).requested_quantity
531: where wip_entity_id = p_comp_tbl(i).wip_entity_id

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

530: quantity_allocated = quantity_allocated - p_comp_tbl(i).requested_quantity
531: where wip_entity_id = p_comp_tbl(i).wip_entity_id
532: and operation_seq_num = p_comp_tbl(i).operation_seq_num
533: and inventory_item_id = p_comp_tbl(i).inventory_item_id;
534: elsif(p_wip_entity_type = wip_constants.repetitive) then
535: update wip_requirement_operations
536: set quantity_backordered = greatest(quantity_backordered - p_comp_tbl(i).requested_quantity, 0),
537: quantity_allocated = quantity_allocated - p_comp_tbl(i).requested_quantity
538: where wip_entity_id = p_comp_tbl(i).wip_entity_id

Line 874: l_disc NUMBER := wip_constants.discrete;

870: l_linesRec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
871: l_hdrRec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
872: l_defaultSub VARCHAR2(10);
873: l_defaultLocator NUMBER;
874: l_disc NUMBER := wip_constants.discrete;
875: l_eam NUMBER := wip_constants.eam;
876: l_lotbased NUMBER := wip_constants.lotbased;
877: l_repetitive NUMBER := wip_constants.repetitive;
878: l_msgCount NUMBER;

Line 875: l_eam NUMBER := wip_constants.eam;

871: l_hdrRec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
872: l_defaultSub VARCHAR2(10);
873: l_defaultLocator NUMBER;
874: l_disc NUMBER := wip_constants.discrete;
875: l_eam NUMBER := wip_constants.eam;
876: l_lotbased NUMBER := wip_constants.lotbased;
877: l_repetitive NUMBER := wip_constants.repetitive;
878: l_msgCount NUMBER;
879: l_dummy VARCHAR2(1);

Line 876: l_lotbased NUMBER := wip_constants.lotbased;

872: l_defaultSub VARCHAR2(10);
873: l_defaultLocator NUMBER;
874: l_disc NUMBER := wip_constants.discrete;
875: l_eam NUMBER := wip_constants.eam;
876: l_lotbased NUMBER := wip_constants.lotbased;
877: l_repetitive NUMBER := wip_constants.repetitive;
878: l_msgCount NUMBER;
879: l_dummy VARCHAR2(1);
880: l_abm VARCHAR2(10);

Line 877: l_repetitive NUMBER := wip_constants.repetitive;

873: l_defaultLocator NUMBER;
874: l_disc NUMBER := wip_constants.discrete;
875: l_eam NUMBER := wip_constants.eam;
876: l_lotbased NUMBER := wip_constants.lotbased;
877: l_repetitive NUMBER := wip_constants.repetitive;
878: l_msgCount NUMBER;
879: l_dummy VARCHAR2(1);
880: l_abm VARCHAR2(10);
881: l_revControlCode varchar2(3);

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

920: and (
921: ( 'Y' = (select allocate_backflush_components
922: from wip_parameters wp
923: where organization_id = wro.organization_id)
924: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
925: )
926: or wro.wip_supply_type = wip_constants.push
927: )
928: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

Line 926: or wro.wip_supply_type = wip_constants.push

922: from wip_parameters wp
923: where organization_id = wro.organization_id)
924: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
925: )
926: or wro.wip_supply_type = wip_constants.push
927: )
928: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then
929: 0.00001 (least amount inventory can transfer)*/
930: and (wro.required_quantity - (wro.quantity_issued

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

976: and (wo.count_point_type is null or wo.count_point_type in (1,2))
977: and wro.auto_request_material = 'Y'
978: and wro.organization_id = msi.organization_id
979: and wro.organization_id = p_organization_id
980: and wro.wip_supply_type <> wip_constants.bulk
981: and msi.mtl_transactions_enabled_flag = 'Y' /* fix for bug# 2468515 */
982: for update of wro.quantity_allocated, wro.quantity_backordered, wro.quantity_issued nowait;
983: /*Bug 5119650 and 5119601 */
984: /* Modified the calculation of open quantity considering lot basis of component and yield factor*/

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

984: /* Modified the calculation of open quantity considering lot basis of component and yield factor*/
985: CURSOR c_lotJobs(v_wip_entity_id NUMBER) IS
986: select wro.operation_seq_num,
987: wro.inventory_item_id,
988: ((decode (nvl(wro.basis_type,wip_constants.item_based_mtl),wip_constants.item_based_mtl,
989: (wo.quantity_in_queue + wo.quantity_running + wo.quantity_completed),1) *
990: wro.quantity_per_assembly /
991: decode(l_include_yield,l_include_comp_yield_factor,nvl(wro.component_yield_factor,1),1))
992: - wro.quantity_issued

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

1008: and (
1009: ( 'Y' = (select allocate_backflush_components
1010: from wip_parameters wp
1011: where organization_id = wro.organization_id)
1012: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1013: )
1014: or wro.wip_supply_type = wip_constants.push
1015: )
1016: -- and (nvl(wro.quantity_allocated,0) + wro.quantity_issued) < ((wo.quantity_in_queue + wo.quantity_running +

Line 1014: or wro.wip_supply_type = wip_constants.push

1010: from wip_parameters wp
1011: where organization_id = wro.organization_id)
1012: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1013: )
1014: or wro.wip_supply_type = wip_constants.push
1015: )
1016: -- and (nvl(wro.quantity_allocated,0) + wro.quantity_issued) < ((wo.quantity_in_queue + wo.quantity_running +
1017: -- wo.quantity_completed) * wro.quantity_per_assembly)
1018: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

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

1057: and (
1058: ( 'Y' = (select allocate_backflush_components
1059: from wip_parameters wp
1060: where organization_id = wro.organization_id)
1061: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1062: )
1063: or wro.wip_supply_type = wip_constants.push
1064: )
1065: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then

Line 1063: or wro.wip_supply_type = wip_constants.push

1059: from wip_parameters wp
1060: where organization_id = wro.organization_id)
1061: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1062: )
1063: or wro.wip_supply_type = wip_constants.push
1064: )
1065: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then
1066: 0.00001 (least amount inventory can transfer)*/
1067: and (wro.required_quantity - (wro.quantity_issued +

Line 1084: l_push NUMBER := wip_constants.push;

1080: --to avoid multiple unnecessary cross package calls when creating lines.
1081: l_sysDate DATE := sysdate;
1082: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1083: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1084: l_push NUMBER := wip_constants.push;
1085: /* Bug 4917429 */
1086: l_jobname VARCHAR2(240);
1087: l_item VARCHAR2(2000);
1088:

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

1098: select nvl(include_component_yield,1)
1099: into l_include_yield
1100: from wip_parameters
1101: where organization_id = p_organization_id;
1102: if (l_logLevel <= wip_constants.trace_logging) then
1103: wip_logger.log('wip_picking_pvt.allocate => job count in table passed into allocate(): '
1104: || p_alloc_tbl.COUNT, l_dummy2);
1105: wip_logger.log('p_days_to_alloc=' || p_days_to_alloc || ',p_auto_detail_flag=' || p_auto_detail_flag ||
1106: ',p_start_date=' || p_start_date || ',p_cutoff_date=' || p_cutoff_date ||

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

1121: elsif(p_wip_entity_type = l_lotbased) then
1122: open c_lotJobs(p_alloc_tbl(i).wip_entity_id);
1123: elsif(p_wip_entity_type = l_repetitive) then
1124: open c_rep(p_alloc_tbl(i).repetitive_schedule_id);
1125: elsif(p_wip_entity_type = wip_constants.flow) then --flow
1126:
1127: if (l_logLevel <= wip_constants.trace_logging) then
1128: wip_logger.log('wip_picking_pvt.allocate => processing job: (wei)'
1129: || p_alloc_tbl(i).wip_entity_id

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

1123: elsif(p_wip_entity_type = l_repetitive) then
1124: open c_rep(p_alloc_tbl(i).repetitive_schedule_id);
1125: elsif(p_wip_entity_type = wip_constants.flow) then --flow
1126:
1127: if (l_logLevel <= wip_constants.trace_logging) then
1128: wip_logger.log('wip_picking_pvt.allocate => processing job: (wei)'
1129: || p_alloc_tbl(i).wip_entity_id
1130: || ';job counter=' || i || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1131: end if;

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

1204: p_ably_qty => l_assemblyQty,
1205: p_req_date => p_alloc_tbl(i).required_date,
1206: x_opt_total => l_opt_cnt);
1207:
1208: if (l_logLevel <= wip_constants.trace_logging) then
1209: wip_logger.log('wip_picking_pvt.allocate => ' ||
1210: 'flow optimal group total: ' || l_opt_cnt, l_dummy2);
1211: end if;
1212: -- no flow sched can be grouped together

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

1256: -- can not optimize, b/c bom is not the same for the group,
1257: -- reset counter, and proceed as normal(one record at a time)
1258: l_opt_cnt := 0;
1259:
1260: if (l_logLevel <= wip_constants.trace_logging) then
1261: wip_logger.log('wip_picking_pvt.allocate => ' ||
1262: 'flow optimal group NOT optimzable', l_dummy2);
1263: end if;
1264: else

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

1263: end if;
1264: else
1265: -- can be optimized, do nothing here, it will be processed
1266: -- as a whole right before passing to INV
1267: if (l_logLevel <= wip_constants.trace_logging) then
1268: wip_logger.log('wip_picking_pvt.allocate => ' ||
1269: 'flow optimal group IS optimzable', l_dummy2);
1270: end if;
1271: end if;

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

1273: else -- if (l_opt_cnt > 0)
1274: -- in the middle of an optimized flow sched group, jump to the end
1275: -- of the jobs loop, since this whole group has been added to
1276: -- l_linesTable to pass to INV
1277: if (l_logLevel <= wip_constants.trace_logging) then
1278: wip_logger.log('wip_picking_pvt.allocate => ' ||
1279: 'processing flow optimal group..', l_dummy2);
1280: end if;
1281: l_opt_cnt := l_opt_cnt-1;

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

1323: elsif(p_wip_entity_type = l_lotbased) then
1324: fetch c_lotJobs into l_operationSeqNum, l_itemID, l_openQty, l_subinv, l_locator, l_uom, l_supplyType, l_reqDate,l_revControlCode;
1325: exit when c_lotJobs%NOTFOUND;
1326:
1327: elsif(p_wip_entity_type = wip_constants.flow) then --flow
1328: j := j+1;
1329: if (j > l_flowCompTbl.COUNT) then
1330: exit;
1331: end if;

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

1353: l_subinv := l_flowCompTbl(j).source_subinventory_code;
1354: l_locator := l_flowCompTbl(j).source_locator_id;
1355: l_uom := l_flowCompTbl(j).primary_uom_code;
1356: l_revControlCode := l_flowCompTbl(j).revision;
1357: l_supplyType := wip_constants.ASSY_PULL; --although defined as push, flow allocations always behave as pull components
1358: end if;
1359:
1360: if (l_logLevel <= wip_constants.trace_logging) then
1361: wip_logger.log(' op_seq_num=' || l_operationSeqNum || ',item_id=' || l_itemID || ',open qty=' || l_openQty

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

1356: l_revControlCode := l_flowCompTbl(j).revision;
1357: l_supplyType := wip_constants.ASSY_PULL; --although defined as push, flow allocations always behave as pull components
1358: end if;
1359:
1360: if (l_logLevel <= wip_constants.trace_logging) then
1361: wip_logger.log(' op_seq_num=' || l_operationSeqNum || ',item_id=' || l_itemID || ',open qty=' || l_openQty
1362: || ',subinv=' || l_subinv || ',loc=' || l_locator || ',supplyType=' || l_supplyType
1363: || ',reqDate=' || l_reqDate, l_dummy2);
1364: end if;

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

1457: <>
1458: null;
1459: end loop; --end per entity loop
1460:
1461: if (l_logLevel <= wip_constants.trace_logging) then
1462: wip_logger.log('wip_picking_pvt.allocate => line count passed to inv_wip_picking_pvt.release_pick_batch: '
1463: || l_lineCount || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1464: end if;
1465: if(l_lineCount > 0) then

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

1476: p_init_msg_lst => fnd_api.g_true,
1477: x_mo_line_errrec_tbl => x_MOLineErrTbl);
1478: fnd_file.put_line(which => fnd_file.log, buff => 'return status = ' ||l_pickStatus);
1479:
1480: if (l_logLevel <= wip_constants.trace_logging) then
1481: wip_logger.log('returned status from call to inv_wip_picking_pvt.release_pick_batch() = ' || l_pickStatus || ';total=' || p_alloc_tbl.COUNT, l_dummy2);
1482: end if;
1483:
1484: if(l_pickStatus not in ('P','N', FND_API.G_RET_STS_SUCCESS)) then

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

1547: end if;
1548: end if; /* end of conc_req_id <> -1 condition */
1549: end if; /* end of l_lineCount > 0 */
1550:
1551: if (l_logLevel <= wip_constants.trace_logging) then
1552: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_status='
1553: || l_pickStatus, l_dummy2);
1554: wip_logger.log('wip_picking_pvt.allocate => inv_wip_picking_pvt.release_pick_batch return_msg='
1555: || x_msg_data, l_dummy2);

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

1588: x_msg_data := fnd_message.get;
1589: end if;
1590: x_mo_req_number := l_hdrRec.request_number; /* Added as part of enhancement 2478446 */
1591:
1592: if (l_logLevel <= wip_constants.trace_logging) then
1593: wip_logger.cleanup(l_dummy2);
1594: end if;
1595:
1596: exception

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

1595:
1596: exception
1597: when FND_API.G_EXC_ERROR then --msg_data, return_status set by inventory calls
1598: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1599: if (l_logLevel <= wip_constants.trace_logging) then
1600: wip_logger.log(x_msg_data, l_dummy2);
1601: wip_logger.cleanup(l_dummy2);
1602: end if;
1603: when RECORDS_LOCKED then

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

1604: -- ROLLBACK TO WIP_ALLOCATE_PVT_START; -- Fix bug 4341138
1605: x_return_status := 'L';
1606: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
1607: x_msg_data := fnd_message.get;
1608: if (l_logLevel <= wip_constants.trace_logging) then
1609: wip_logger.log(x_msg_data, l_dummy2);
1610: wip_logger.cleanup(l_dummy2);
1611: end if;
1612: when others then

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

1614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1615: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
1616: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pvt.allocate: ' || SQLERRM);
1617: x_msg_data := fnd_message.get;
1618: if (l_logLevel <= wip_constants.trace_logging) then
1619: wip_logger.log(x_msg_data, l_dummy2);
1620: wip_logger.cleanup(l_dummy2);
1621: end if;
1622: end allocate;

Line 1658: l_push NUMBER := wip_constants.push;

1654: l_sysDate DATE := sysdate;
1655: l_userId NUMBER := fnd_global.user_id;
1656: l_loginId NUMBER := fnd_global.login_id;
1657: l_lineStatus NUMBER := INV_Globals.G_TO_STATUS_PREAPPROVED;
1658: l_push NUMBER := wip_constants.push;
1659: l_pick_grouping_rule_id NUMBER;
1660:
1661: BEGIN
1662:

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

1680: p_linesRec.line_status := l_lineStatus;
1681: p_linesRec.operation := INV_Globals.G_OPR_CREATE;
1682:
1683: /* for EAM entity type, select picksilp grouping rule from wip_parameters. If no rule is defined, raise an exception with suitable message */
1684: if(p_wip_entity_type = wip_constants.eam) then
1685:
1686: select pickslip_grouping_rule_id
1687: into l_pick_grouping_rule_id
1688: from wip_parameters

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

1700: p_hdrRec.grouping_rule_id := p_pick_grouping_rule_id;
1701: end if;
1702:
1703: /* moved to pre_allocate_material in wippckpb.pls per bug#2642679
1704: if(p_wip_entity_type in(wip_constants.repetitive,wip_constants.discrete,wip_constants.eam,wip_constants.lotbased)) then
1705: if(p_use_pickset_flag = 'N') then
1706: update wip_requirement_operations
1707: set quantity_backordered = p_open_qty,
1708: last_update_date = l_sysDate,

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

1719: p_linesRec.txn_source_id := p_wip_entity_id;
1720: p_linesRec.txn_source_line_id := p_operation_seq_num;
1721: p_linesRec.reference_id := p_repetitive_schedule_id;
1722: p_linesRec.date_required := p_req_date;
1723: if(p_wip_entity_type = wip_constants.eam) then
1724: p_linesRec.to_subinventory_code := NULL;
1725: p_linesRec.to_locator_id := NULL;
1726: elsif(p_supply_type = l_push) then --push
1727: p_linesRec.to_subinventory_code := p_to_subinv;

Line 1809: l_disc NUMBER := wip_constants.discrete;

1805: l_linesRec INV_MOVE_ORDER_PUB.Trolin_Rec_Type;
1806: l_hdrRec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1807: l_defaultSub VARCHAR2(10);
1808: l_defaultLocator NUMBER;
1809: l_disc NUMBER := wip_constants.discrete;
1810: l_eam NUMBER := wip_constants.eam;
1811: l_lotbased NUMBER := wip_constants.lotbased;
1812: l_repetitive NUMBER := wip_constants.repetitive;
1813: l_msgCount NUMBER;

Line 1810: l_eam NUMBER := wip_constants.eam;

1806: l_hdrRec INV_MOVE_ORDER_PUB.Trohdr_Rec_Type;
1807: l_defaultSub VARCHAR2(10);
1808: l_defaultLocator NUMBER;
1809: l_disc NUMBER := wip_constants.discrete;
1810: l_eam NUMBER := wip_constants.eam;
1811: l_lotbased NUMBER := wip_constants.lotbased;
1812: l_repetitive NUMBER := wip_constants.repetitive;
1813: l_msgCount NUMBER;
1814: l_revControlCode VARCHAR2(3);

Line 1811: l_lotbased NUMBER := wip_constants.lotbased;

1807: l_defaultSub VARCHAR2(10);
1808: l_defaultLocator NUMBER;
1809: l_disc NUMBER := wip_constants.discrete;
1810: l_eam NUMBER := wip_constants.eam;
1811: l_lotbased NUMBER := wip_constants.lotbased;
1812: l_repetitive NUMBER := wip_constants.repetitive;
1813: l_msgCount NUMBER;
1814: l_revControlCode VARCHAR2(3);
1815: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;

Line 1812: l_repetitive NUMBER := wip_constants.repetitive;

1808: l_defaultLocator NUMBER;
1809: l_disc NUMBER := wip_constants.discrete;
1810: l_eam NUMBER := wip_constants.eam;
1811: l_lotbased NUMBER := wip_constants.lotbased;
1812: l_repetitive NUMBER := wip_constants.repetitive;
1813: l_msgCount NUMBER;
1814: l_revControlCode VARCHAR2(3);
1815: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1816: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;

Line 1817: l_push NUMBER := wip_constants.push;

1813: l_msgCount NUMBER;
1814: l_revControlCode VARCHAR2(3);
1815: l_backflushTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_REPL_SUBXFR;
1816: l_issueTxnType NUMBER := INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE;
1817: l_push NUMBER := wip_constants.push;
1818: l_carton_grouping_id NUMBER;
1819: TYPE carton_tbl_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1820: carton_tbl carton_tbl_t;
1821: l_string1 VARCHAR2(200);

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

1857: and (
1858: ( 'Y' = (select allocate_backflush_components
1859: from wip_parameters wp
1860: where organization_id = wro.organization_id)
1861: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1862: )
1863: or wro.wip_supply_type = wip_constants.push
1864: )
1865: and wro.required_quantity > (wro.quantity_issued +

Line 1863: or wro.wip_supply_type = wip_constants.push

1859: from wip_parameters wp
1860: where organization_id = wro.organization_id)
1861: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1862: )
1863: or wro.wip_supply_type = wip_constants.push
1864: )
1865: and wro.required_quantity > (wro.quantity_issued +
1866: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1867: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))

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

1940: and (
1941: ( 'Y' = (select allocate_backflush_components
1942: from wip_parameters wp
1943: where organization_id = wro.organization_id)
1944: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1945: )
1946: or wro.wip_supply_type = wip_constants.push
1947: )
1948: and ((wo.quantity_in_queue + wo.quantity_running + wo.quantity_completed) * wro.quantity_per_assembly) > (wro.quantity_issued +

Line 1946: or wro.wip_supply_type = wip_constants.push

1942: from wip_parameters wp
1943: where organization_id = wro.organization_id)
1944: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1945: )
1946: or wro.wip_supply_type = wip_constants.push
1947: )
1948: and ((wo.quantity_in_queue + wo.quantity_running + wo.quantity_completed) * wro.quantity_per_assembly) > (wro.quantity_issued +
1949: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1950: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))

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

1987: and (
1988: ( 'Y' = (select allocate_backflush_components
1989: from wip_parameters wp
1990: where organization_id = wro.organization_id)
1991: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1992: )
1993: or wro.wip_supply_type = wip_constants.push
1994: )
1995: and wro.required_quantity > (wro.quantity_issued +

Line 1993: or wro.wip_supply_type = wip_constants.push

1989: from wip_parameters wp
1990: where organization_id = wro.organization_id)
1991: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1992: )
1993: or wro.wip_supply_type = wip_constants.push
1994: )
1995: and wro.required_quantity > (wro.quantity_issued +
1996: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1997: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))

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

2292:
2293: retcode := 0;
2294: savepoint wip_allocate_concurrent;
2295:
2296: if(p_wip_entity_type = wip_constants.discrete) then
2297: open c_jobs;
2298: elsif(p_wip_entity_type = wip_constants.lotbased) then
2299: open c_lotjobs;
2300: elsif(p_wip_entity_type = wip_constants.repetitive) then

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

2294: savepoint wip_allocate_concurrent;
2295:
2296: if(p_wip_entity_type = wip_constants.discrete) then
2297: open c_jobs;
2298: elsif(p_wip_entity_type = wip_constants.lotbased) then
2299: open c_lotjobs;
2300: elsif(p_wip_entity_type = wip_constants.repetitive) then
2301: open c_rep;
2302: else

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

2296: if(p_wip_entity_type = wip_constants.discrete) then
2297: open c_jobs;
2298: elsif(p_wip_entity_type = wip_constants.lotbased) then
2299: open c_lotjobs;
2300: elsif(p_wip_entity_type = wip_constants.repetitive) then
2301: open c_rep;
2302: else
2303: open c_flow;
2304: end if;

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

2383: fnd_message.set_name('WIP', 'WIP_PICKING_MFG_MODE');
2384: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);
2385:
2386: /* Bug 6046963: Added below if to print job type parameter in case of Discrete Job Comp Pick Release request only*/
2387: if(p_wip_entity_type = wip_constants.discrete) then
2388: /*Start - Bug 5932126 (FP of 5880558): Added following code to print new parameter for job type*/
2389: select meaning
2390: into l_outBuffer
2391: from mfg_lookups

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

2400: fnd_file.put_line(which => fnd_file.output, buff => '');
2401: fnd_file.put_line(which => fnd_file.output, buff => '');
2402:
2403: LOOP
2404: if(p_wip_entity_type = wip_constants.discrete) then
2405: fetch c_jobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2406: exit when c_jobs%NOTFOUND;
2407: elsif(p_wip_entity_type = wip_constants.lotbased) then
2408: fetch c_lotjobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;

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

2403: LOOP
2404: if(p_wip_entity_type = wip_constants.discrete) then
2405: fetch c_jobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2406: exit when c_jobs%NOTFOUND;
2407: elsif(p_wip_entity_type = wip_constants.lotbased) then
2408: fetch c_lotjobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2409: exit when c_lotjobs%NOTFOUND;
2410: elsif(p_wip_entity_type = wip_constants.repetitive) then
2411: fetch c_rep into l_wipEntityID, l_outBuffer, l_repSchedID;

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

2406: exit when c_jobs%NOTFOUND;
2407: elsif(p_wip_entity_type = wip_constants.lotbased) then
2408: fetch c_lotjobs into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;
2409: exit when c_lotjobs%NOTFOUND;
2410: elsif(p_wip_entity_type = wip_constants.repetitive) then
2411: fetch c_rep into l_wipEntityID, l_outBuffer, l_repSchedID;
2412: exit when c_rep%NOTFOUND;
2413: else
2414: fetch c_flow into l_wipEntityID, l_outBuffer, l_projectID, l_taskID;

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

2569: j := 1;
2570: WHILE i IS NOT NULL LOOP
2571: l_comp_sys_rec := l_comp_sys_table(i);
2572: --all to pl/sql table
2573: if (l_comp_sys_rec.wip_supply_type = wip_constants.push) then
2574: l_comp_sql_rec.operation_seq_num := l_comp_sys_rec.operation_seq_num ;
2575: l_comp_sql_rec.inventory_item_id := l_comp_sys_rec.inventory_item_id ;
2576: l_comp_sql_rec.requested_quantity := l_comp_sys_rec.primary_quantity ;
2577: l_comp_sql_rec.source_subinventory_code := l_comp_sys_rec.supply_subinventory ;

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

2578: l_comp_sql_rec.source_locator_id := l_comp_sys_rec.supply_locator_id ;
2579: l_comp_sql_rec.revision := l_comp_sys_rec.revision;
2580: l_comp_sql_rec.primary_uom_code := l_comp_sys_rec.primary_uom_code;
2581: l_comp_sql_rec.item_name:= l_comp_sys_rec.item_name;
2582: if(round(abs(l_comp_sys_rec.primary_quantity), WIP_CONSTANTS.INV_MAX_PRECISION) <> 0) then
2583: x_comp_sql_tbl(j) := l_comp_sql_rec;
2584: j := j+1;
2585: end if;
2586: end if;

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

2605: select unique operation_seq_num
2606: from wip_requirement_operations
2607: where wip_entity_id = v_wip_entity_id
2608: and organization_id = v_organization_id
2609: and wip_supply_type in (wip_constants.op_pull, wip_constants.assy_pull);
2610:
2611: CURSOR c_rep_operations(v_wip_entity_id NUMBER, v_repetitive_schedule_id NUMBER,
2612: v_organization_id NUMBER) IS
2613: select unique operation_seq_num

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

2614: from wip_requirement_operations
2615: where wip_entity_id = v_wip_entity_id
2616: and organization_id = v_organization_id
2617: and repetitive_schedule_id = v_repetitive_schedule_id
2618: and wip_supply_type in (wip_constants.op_pull, wip_constants.assy_pull);
2619: Begin
2620: x_return_status := FND_API.G_RET_STS_SUCCESS;
2621:
2622: l_logLevel := fnd_log.g_current_runtime_level;

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

2619: Begin
2620: x_return_status := FND_API.G_RET_STS_SUCCESS;
2621:
2622: l_logLevel := fnd_log.g_current_runtime_level;
2623: if (l_logLevel <= wip_constants.trace_logging) then
2624: wip_logger.log('In wip_picking_pvt.Post_Explosion_CleanUp():'
2625: || p_wip_entity_id || ':' || p_org_id
2626: || ':' || p_repetitive_schedule_id, l_dummy2);
2627: end if;

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

2673: x_return_status => x_return_status,
2674: x_msg_data => x_msg_data);
2675:
2676: if (x_return_status <> fnd_api.g_ret_sts_success) then
2677: if (l_logLevel <= wip_constants.trace_logging) then
2678: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2679: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2680: end if;
2681: Return;

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

2720: x_return_status => x_return_status,
2721: x_msg_data => x_msg_data);
2722:
2723: if (x_return_status <> fnd_api.g_ret_sts_success) then
2724: if (l_logLevel <= wip_constants.trace_logging) then
2725: wip_logger.log('wip_picking_pvt.Post_Explosion_CleanUp: ' ||
2726: 'wip_picking_pub.Update_Requirement_SubinvLoc failed..', l_dummy2);
2727: end if;
2728: Return;

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

2742: when RECORDS_LOCKED then
2743: x_return_status := 'L';
2744: fnd_message.set_name('FND', 'FORM_UNABLE_TO_RESERVE_RECORD');
2745: x_msg_data := fnd_message.get;
2746: if (l_logLevel <= wip_constants.trace_logging) then
2747: wip_logger.log( x_msg_data, l_dummy2);
2748: wip_logger.cleanup(l_dummy2);
2749: end if;
2750: when others then

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

2752: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
2753: fnd_message.set_token('ERROR_TEXT', 'WIP_EXPLODER_UTITLITIES.Post_Explosion_CleanUp:'
2754: || SQLERRM);
2755: x_msg_data := fnd_message.get;
2756: if (l_logLevel <= wip_constants.trace_logging) then
2757: wip_logger.log( x_msg_data, l_dummy2);
2758: wip_logger.cleanup(l_dummy2);
2759: end if;
2760: End Post_Explosion_CleanUp;