DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on WIP_PICKING_PUB

Line 3081: 'Calling wip_picking_pub.unallocate_material with '

3077: END IF; -- if UOM code not primary UOM
3078:
3079: IF (l_debug = 1) THEN
3080: DEBUG(
3081: 'Calling wip_picking_pub.unallocate_material with '
3082: || 'WIP entity ID='
3083: || TO_CHAR(l_trolin_rec.txn_source_id)
3084: || ', oper seq num='
3085: || TO_CHAR(l_trolin_rec.txn_source_line_id)

Line 3095: wip_picking_pub.unallocate_material(

3091: || TO_CHAR(l_unalloc_quantity)
3092: , 'Finalize_Pick_Confirm'
3093: );
3094: END IF;
3095: wip_picking_pub.unallocate_material(
3096: p_wip_entity_id => l_trolin_rec.txn_source_id
3097: , p_operation_seq_num => l_trolin_rec.txn_source_line_id
3098: , p_inventory_item_id => l_trolin_rec.inventory_item_id
3099: , p_repetitive_schedule_id => l_trolin_rec.reference_id

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

3103: );
3104:
3105: IF l_return_status = 'L' THEN
3106: IF (l_debug = 1) THEN
3107: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');
3108: DEBUG('Unable to lock the work order line for update', 'Finalize_Pick_Confirm');
3109: END IF;
3110: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
3111: fnd_msg_pub.ADD;

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

3111: fnd_msg_pub.ADD;
3112: RAISE fnd_api.g_exc_error;
3113: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
3114: IF (l_debug = 1) THEN
3115: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');
3116: END IF;
3117: RAISE fnd_api.g_exc_unexpected_error;
3118: END IF;
3119: END IF; -- if unalloc qty > 0