DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on WIP_PICKING_PUB

Line 3292: 'Calling wip_picking_pub.unallocate_material with '

3288: END IF; -- if UOM code not primary UOM
3289:
3290: IF (l_debug = 1) THEN
3291: DEBUG(
3292: 'Calling wip_picking_pub.unallocate_material with '
3293: || 'WIP entity ID='
3294: || TO_CHAR(l_trolin_rec.txn_source_id)
3295: || ', oper seq num='
3296: || TO_CHAR(l_trolin_rec.txn_source_line_id)

Line 3306: wip_picking_pub.unallocate_material(

3302: || TO_CHAR(l_unalloc_quantity)
3303: , 'Finalize_Pick_Confirm'
3304: );
3305: END IF;
3306: wip_picking_pub.unallocate_material(
3307: p_wip_entity_id => l_trolin_rec.txn_source_id
3308: , p_operation_seq_num => l_trolin_rec.txn_source_line_id
3309: , p_inventory_item_id => l_trolin_rec.inventory_item_id
3310: , p_repetitive_schedule_id => l_trolin_rec.reference_id

Line 3318: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');

3314: );
3315:
3316: IF l_return_status = 'L' THEN
3317: IF (l_debug = 1) THEN
3318: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');
3319: DEBUG('Unable to lock the work order line for update', 'Finalize_Pick_Confirm');
3320: END IF;
3321: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
3322: fnd_msg_pub.ADD;

Line 3326: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');

3322: fnd_msg_pub.ADD;
3323: RAISE fnd_api.g_exc_error;
3324: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
3325: IF (l_debug = 1) THEN
3326: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');
3327: END IF;
3328: RAISE fnd_api.g_exc_unexpected_error;
3329: END IF;
3330: END IF; -- if unalloc qty > 0