[Home] [Help]
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;
162: return ;
163: end if ;
164:
235: end if;
236: ROLLBACK TO WIP_CANCEL_ALLOCS_START;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
239: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_allocations: ' || SQLERRM);
240: x_msg_data := fnd_message.get;
241: end cancel_allocations;
242:
243:
376: end if;
377: ROLLBACK TO WIP_CANCEL_COMP_ALLOCS_START;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
380: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_comp_allocations: ' || SQLERRM);
381: x_msg_data := fnd_message.get;
382: END cancel_comp_allocations;
383:
384: Procedure cancel_MO_line(p_lineId IN NUMBER,
405: p_line_id => p_lineId,
406: p_delete_reservations => 'N');
407: END cancel_MO_line;
408:
409: procedure reduce_comp_allocations(p_comp_tbl IN wip_picking_pub.allocate_comp_tbl_t,
410: p_wip_entity_type NUMBER,
411: p_organization_id NUMBER,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_data OUT NOCOPY VARCHAR2)IS
553: end if;
554: ROLLBACK TO WIP_REDUCE_COMP_ALLOCS_START;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
556: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
557: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.cancel_allocations: ' || SQLERRM);
558: x_msg_data := fnd_message.get;
559: END reduce_comp_allocations;
560:
561:
652: end if;
653: ROLLBACK TO WIP_UPDATE_ALLOCS_START;
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
656: fnd_message.set_token('ERROR_TEXT', 'wip_picking_pub.update_allocation_op_seqs: ' || SQLERRM);
657: end update_allocation_op_seqs;
658:
659: /* Starting for p_index element of p_alloc_tbl, find number of consective flow schedules
660: that contain the same assembly, assembly qty, and required date. This number allows
666: assembly, assembly qty, and required date of the schedule that
667: all subsequent schedules compare to to see if there is a match.
668: x_opt_total: the total of number schedules that can be grouped together.
669: */
670: procedure getOptimalFlowSchGrp(p_alloc_tbl IN wip_picking_pub.allocate_tbl_t,
671: p_index IN NUMBER,
672: p_item_id IN NUMBER,
673: p_ably_qty IN NUMBER,
674: p_req_date IN DATE,
745: p_rev_date DATE,
746: p_project_id NUMBER,
747: p_task_id NUMBER,
748: p_alt_rout_desig VARCHAR2,
749: x_comp_sql_tbl OUT NOCOPY wip_picking_pub.allocate_comp_tbl_t,
750: x_explode_status OUT NOCOPY VARCHAR2,
751: x_optimize_status OUT NOCOPY VARCHAR2,
752: x_msg_data OUT NOCOPY VARCHAR2) IS
753: l_comp_sql_tbl wip_picking_pub.allocate_comp_tbl_t;
749: x_comp_sql_tbl OUT NOCOPY wip_picking_pub.allocate_comp_tbl_t,
750: x_explode_status OUT NOCOPY VARCHAR2,
751: x_optimize_status OUT NOCOPY VARCHAR2,
752: x_msg_data OUT NOCOPY VARCHAR2) IS
753: l_comp_sql_tbl wip_picking_pub.allocate_comp_tbl_t;
754: l_dummy VARCHAR2(1);
755:
756: begin
757:
832:
833:
834: --this version is used by the form and
835: --called by the conc. request wrapper version
836: procedure allocate(p_alloc_tbl IN OUT NOCOPY wip_picking_pub.allocate_tbl_t,
837: p_days_to_alloc NUMBER := NULL, --only used for rep scheds
838: p_auto_detail_flag VARCHAR2 DEFAULT NULL,
839: p_start_date DATE DEFAULT NULL, /* Enh#2824753 */
840: p_cutoff_date DATE,
881: l_revControlCode varchar2(3);
882: l_carton_grouping_id NUMBER :=0;
883: l_string1 VARCHAR2(200);
884: l_string2 VARCHAR2(200);
885: l_flowCompTbl wip_picking_pub.allocate_comp_tbl_t;
886: l_routing_seq_id NUMBER;
887: j NUMBER := 1;
888: h NUMBER;
889: k NUMBER;
901: /*Component Yield Enhancement(Bug 4369064)-> Derive quantity to allocate based on yield parameter*/
902: (wro.required_quantity * decode(l_include_yield,2,nvl(wro.component_yield_factor,1),1)
903: - wro.quantity_issued
904: -- - nvl(wro.quantity_allocated, 0)
905: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
906: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
907: - nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY /
908: decode(l_include_yield,2,1,nvl(wro.component_yield_factor,1)), 0)) open_quantity,
909: wro.supply_subinventory,
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
931: + nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
932: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)) >= 0.00001)
933: and wro.inventory_item_id = msi.inventory_item_id
934: and wro.wip_entity_id = wo.wip_entity_id (+)
935: and ( p_operation_seq_num_low IS NULL OR wro.operation_seq_num >= p_operation_seq_num_low)
947: /*Component Yield Enhancement(Bug 4369064)-> Derive quantity to allocate based on yield parameter*/
948: (wro.required_quantity * decode(l_include_yield,2,nvl(wro.component_yield_factor,1),1)
949: - wro.quantity_issued
950: -- - nvl(wro.quantity_allocated, 0)
951: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
952: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
953: - nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY /
954: decode(l_include_yield,2,1,nvl(wro.component_yield_factor,1)), 0)) open_quantity,
955: wro.supply_subinventory,
965: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
966: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then
967: 0.00001 (least amount inventory can transfer)*/
968: and (wro.required_quantity - (wro.quantity_issued +
969: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
970: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)) >= 0.00001)
971: and wro.inventory_item_id = msi.inventory_item_id
972: and wro.wip_entity_id = wo.wip_entity_id (+)
973: and ( p_operation_seq_num_low IS NULL OR wro.operation_seq_num >= p_operation_seq_num_low) /* Enh#2824753: op seq converted to range for EAM work orders */
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
993: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
994: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)) open_quantity,
995: wro.supply_subinventory,
996: wro.supply_locator_id,
997: msi.primary_uom_code,
1018: /*Bug 5255566 (FP Bug 5504661) : Changed below condition to show only components having open quantity greater then
1019: 0.00001 (least amount inventory can transfer)*/
1020: and (((wo.quantity_in_queue + wo.quantity_running + wo.quantity_completed) * wro.quantity_per_assembly) -
1021: (wro.quantity_issued +
1022: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1023: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)) >= 0.00001)
1024: and wro.inventory_item_id = msi.inventory_item_id
1025: and wro.organization_id = msi.organization_id
1026: and wro.organization_id = p_organization_id
1033: /*Component Yield Enhancement(Bug 4369064)-> Derive quantity to allocate based on yield parameter*/
1034: least( --open qty is the smaller of the remaining quantity and the quantity determined by the #days to allocate for
1035: (wro.required_quantity * decode(l_include_yield,2,nvl(wro.component_yield_factor,1),1)
1036: - wro.quantity_issued
1037: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1038: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID,WRO. REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
1039: - nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY /
1040: decode(l_include_yield,2,1,nvl(wro.component_yield_factor,1)),0)),
1041: (wrs.daily_production_rate * wro.quantity_per_assembly * p_days_to_alloc) + nvl(wro.quantity_backordered, 0)) open_quantity,
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 +
1068: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1069: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID,WRO.QUANTITY_ISSUED),0)) >= 0.00001)
1070: and wro.inventory_item_id = msi.inventory_item_id
1071: and wro.organization_id = msi.organization_id
1072: and wro.organization_id = p_organization_id
1777:
1778:
1779: --this procedure is used for allocation of specific material
1780:
1781: procedure allocate_comp(p_alloc_comp_tbl IN OUT NOCOPY wip_picking_pub.allocate_comp_tbl_t,
1782: p_days_to_alloc NUMBER DEFAULT NULL, --only used for rep scheds
1783: p_auto_detail_flag VARCHAR2 DEFAULT NULL,
1784: p_cutoff_date DATE,
1785: p_wip_entity_type NUMBER,
1832:
1833: for i in 1..p_alloc_comp_tbl.COUNT LOOP
1834: if(p_wip_entity_type = l_disc) then
1835: select (wro.required_quantity - wro.quantity_issued
1836: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1837: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
1838: - wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY) open_quantity,
1839: wro.supply_subinventory,
1840: wro.supply_locator_id,
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))
1868: and wro.inventory_item_id = p_alloc_comp_tbl(i).inventory_item_id
1869: and wro.inventory_item_id = msi.inventory_item_id
1870: and wro.wip_entity_id = wo.wip_entity_id (+)
1876: for update of wro.quantity_allocated, wro.quantity_backordered, wro.quantity_issued nowait;
1877:
1878: elsif(p_wip_entity_type = l_eam) then
1879: select (wro.required_quantity - wro.quantity_issued
1880: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1881: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
1882: - wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY) open_quantity,
1883: wro.supply_subinventory,
1884: wro.supply_locator_id,
1898: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo
1899: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1900: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1901: and wro.required_quantity > (wro.quantity_issued +
1902: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1903: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))
1904: and wro.inventory_item_id = p_alloc_comp_tbl(i).inventory_item_id
1905: and wro.inventory_item_id = msi.inventory_item_id
1906: and wro.wip_entity_id = wo.wip_entity_id (+)
1913:
1914: elsif(p_wip_entity_type = l_lotbased) then
1915: select (((wo.quantity_in_queue + wo.quantity_running + wo.quantity_completed) * wro.quantity_per_assembly)
1916: - wro.quantity_issued
1917: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1918: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)) open_quantity,
1919: wro.supply_subinventory,
1920: wro.supply_locator_id,
1921: msi.primary_uom_code,
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))
1951: and wro.inventory_item_id = p_alloc_comp_tbl(i).inventory_item_id
1952: and wro.inventory_item_id = msi.inventory_item_id
1953: and wro.organization_id = msi.organization_id
1957: elsif(p_wip_entity_type = l_repetitive) then
1958:
1959: select least( --open qty is the smaller of the remaining quantity and the quantity determined by the #days to allocate for
1960: (wro.required_quantity - wro.quantity_issued
1961: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
1962: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
1963: - wo.CUMULATIVE_SCRAP_QUANTITY*wro. QUANTITY_PER_ASSEMBLY),
1964: (wrs.daily_production_rate * wro.quantity_per_assembly * p_days_to_alloc) + nvl(wro.quantity_backordered, 0)) open_quantity,
1965: wro.supply_subinventory,
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))
1998: and wro.inventory_item_id = p_alloc_comp_tbl(i).inventory_item_id
1999: and wro.inventory_item_id = msi.inventory_item_id
2000: and wro.organization_id = msi.organization_id
2181: and wro.wip_entity_id = wo.wip_entity_id (+)
2182: and wro.operation_seq_num = wo.operation_seq_num(+)
2183: and (wo.count_point_type in (1,2) or wo.count_point_type is null)
2184: and wro.required_quantity > (wro.quantity_issued +
2185: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
2186: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))
2187: and ( ( wp.allocate_backflush_components = 'Y' and wro.wip_supply_type in (1,2,3) ) or ( ( wp.allocate_backflush_components = 'N' or wp.allocate_backflush_components is null )
2188: and wro.wip_supply_type = 1 ) )
2189: and wro.date_required < sysdate + p_days_forward
2211: and (wo.quantity_in_queue + quantity_running +
2212: wo.quantity_waiting_to_move + wo.quantity_rejected +
2213: wo.quantity_scrapped + wo.quantity_completed) *
2214: wro.quantity_per_assembly > wro.quantity_issued
2215: + nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
2216: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED), 0)
2217: and (
2218: ( wp.allocate_backflush_components = 'Y'
2219: and wro.wip_supply_type in (1,2,3)
2253: and wro.repetitive_schedule_id = wo.repetitive_schedule_id (+)
2254: and wro.operation_seq_num = wo.operation_seq_num(+)
2255: and (wo.count_point_type in (1,2) or wo.count_point_type is null)
2256: and wro.required_quantity > (wro.quantity_issued +
2257: nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
2258: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0))
2259: and ( ( wp.allocate_backflush_components = 'Y' and wro.wip_supply_type in (1,2,3) ) or ( ( wp.allocate_backflush_components = 'N' or wp.allocate_backflush_components is null ) and wro.wip_supply_type = 1 ) )
2260: and wro.date_required < sysdate + p_days_forward
2261: and we.organization_id = p_organization_id
2276: l_repSchedID NUMBER;
2277: l_projectID NUMBER;
2278: l_taskID NUMBER;
2279: i NUMBER := 0;
2280: l_allocTbl wip_picking_pub.allocate_tbl_t;
2281: l_returnStatus VARCHAR2(1);
2282: l_msgData VARCHAR2(2000);
2283: l_picksetFlag VARCHAR2(1);
2284: l_outBuffer VARCHAR2(240);
2532: p_project_id NUMBER,
2533: p_task_id NUMBER,
2534: p_to_op_seq_num NUMBER,
2535: p_alt_rout_desig VARCHAR2,
2536: x_comp_sql_tbl OUT NOCOPY wip_picking_pub.allocate_comp_tbl_t,
2537: x_return_status OUT NOCOPY VARCHAR2,
2538: x_msg_data OUT NOCOPY VARCHAR2) IS
2539: l_comp_sys_rec SYSTEM.WIP_COMPONENT_OBJ_T;
2540: l_comp_sys_table SYSTEM.WIP_COMPONENT_TBL_T;
2537: x_return_status OUT NOCOPY VARCHAR2,
2538: x_msg_data OUT NOCOPY VARCHAR2) IS
2539: l_comp_sys_rec SYSTEM.WIP_COMPONENT_OBJ_T;
2540: l_comp_sys_table SYSTEM.WIP_COMPONENT_TBL_T;
2541: l_comp_sql_rec wip_picking_pub.allocate_comp_rec_t;
2542: i NUMBER;
2543: j NUMBER;
2544: begin
2545:
2664: null;
2665: end;
2666:
2667: if (l_supply_subinventory is not null) then
2668: wip_picking_pub.Update_Requirement_SubinvLoc(p_wip_entity_id => p_wip_entity_id,
2669: p_repetitive_schedule_id => p_repetitive_schedule_id,
2670: p_operation_seq_num => l_operation_seq_num,
2671: p_supply_subinventory => l_supply_subinventory,
2672: p_supply_locator_id => l_supply_locator_id,
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;
2682: End if;
2683: end if;
2711: null;
2712: end;
2713:
2714: if l_supply_subinventory is not null then
2715: wip_picking_pub.Update_Requirement_SubinvLoc(p_wip_entity_id => p_wip_entity_id,
2716: p_repetitive_schedule_id => p_repetitive_schedule_id,
2717: p_operation_seq_num => l_operation_seq_num,
2718: p_supply_subinventory => l_supply_subinventory,
2719: p_supply_locator_id => l_supply_locator_id,
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;
2729: End if;
2730: end if;