DBA Data[Home] [Help]

APPS.INV_WIP_PICKING_PVT dependencies on INV_GLOBALS

Line 88: IF l_mo_header_rec.move_order_type = INV_GLOBALS.G_MOVE_ORDER_BACKFLUSH THEN

84: --
85: -- Pre 11.5.9 WIP uses 2 move order types (G_MOVE_ORDER_WIP_ISSUE and G_MOVE_ORDER_BACKFLUSH),
86: -- but Inventory 11.5.9 has changed to a single type (G_MOVE_ORDER_MFG_PICK)
87: --
88: IF l_mo_header_rec.move_order_type = INV_GLOBALS.G_MOVE_ORDER_BACKFLUSH THEN
89: l_mo_header_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_MFG_PICK;
90: IF (l_debug = 1) THEN
91: print_debug('Changed MO type from ' || INV_GLOBALS.G_MOVE_ORDER_BACKFLUSH ||' to ' || l_mo_header_rec.move_order_type, 'RELEASE_PICK_BATCH');
92: END IF;

Line 89: l_mo_header_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_MFG_PICK;

85: -- Pre 11.5.9 WIP uses 2 move order types (G_MOVE_ORDER_WIP_ISSUE and G_MOVE_ORDER_BACKFLUSH),
86: -- but Inventory 11.5.9 has changed to a single type (G_MOVE_ORDER_MFG_PICK)
87: --
88: IF l_mo_header_rec.move_order_type = INV_GLOBALS.G_MOVE_ORDER_BACKFLUSH THEN
89: l_mo_header_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_MFG_PICK;
90: IF (l_debug = 1) THEN
91: print_debug('Changed MO type from ' || INV_GLOBALS.G_MOVE_ORDER_BACKFLUSH ||' to ' || l_mo_header_rec.move_order_type, 'RELEASE_PICK_BATCH');
92: END IF;
93: END IF;

Line 91: print_debug('Changed MO type from ' || INV_GLOBALS.G_MOVE_ORDER_BACKFLUSH ||' to ' || l_mo_header_rec.move_order_type, 'RELEASE_PICK_BATCH');

87: --
88: IF l_mo_header_rec.move_order_type = INV_GLOBALS.G_MOVE_ORDER_BACKFLUSH THEN
89: l_mo_header_rec.move_order_type := INV_GLOBALS.G_MOVE_ORDER_MFG_PICK;
90: IF (l_debug = 1) THEN
91: print_debug('Changed MO type from ' || INV_GLOBALS.G_MOVE_ORDER_BACKFLUSH ||' to ' || l_mo_header_rec.move_order_type, 'RELEASE_PICK_BATCH');
92: END IF;
93: END IF;
94:
95: release_pick_batch(

Line 827: IF l_mo_type <> inv_globals.g_move_order_mfg_pick THEN

823: fnd_msg_pub.ADD;
824: RAISE fnd_api.g_exc_unexpected_error;
825: END;
826:
827: IF l_mo_type <> inv_globals.g_move_order_mfg_pick THEN
828: IF (l_debug = 1) THEN
829: print_debug('Error: Trying to release non WIP move order', 'PICK_RELEASE');
830: END IF;
831: fnd_message.set_name('INV', 'INV_NOT_WIP_MOVE_ORDER');

Line 1721: IF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN

1717: ELSE
1718: l_pick_slip_number := c_mmtt_rec.pick_slip_number;
1719: END IF;
1720:
1721: IF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN
1722: UPDATE mtl_material_transactions_temp
1723: SET transaction_source_id = p_mo_line_rec.txn_source_id
1724: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1725: , demand_source_header_id = p_mo_line_rec.txn_source_id

Line 1727: , transaction_source_type_id = inv_globals.g_sourcetype_wip

1723: SET transaction_source_id = p_mo_line_rec.txn_source_id
1724: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1725: , demand_source_header_id = p_mo_line_rec.txn_source_id
1726: , demand_source_line = p_mo_line_rec.txn_source_line_id
1727: , transaction_source_type_id = inv_globals.g_sourcetype_wip
1728: , transaction_type_id = p_mo_line_rec.transaction_type_id
1729: , transaction_action_id = inv_globals.g_action_issue
1730: , wip_entity_type = l_wip_entity_type
1731: , repetitive_line_id = l_repetitive_line_id

Line 1729: , transaction_action_id = inv_globals.g_action_issue

1725: , demand_source_header_id = p_mo_line_rec.txn_source_id
1726: , demand_source_line = p_mo_line_rec.txn_source_line_id
1727: , transaction_source_type_id = inv_globals.g_sourcetype_wip
1728: , transaction_type_id = p_mo_line_rec.transaction_type_id
1729: , transaction_action_id = inv_globals.g_action_issue
1730: , wip_entity_type = l_wip_entity_type
1731: , repetitive_line_id = l_repetitive_line_id
1732: , operation_seq_num = p_mo_line_rec.txn_source_line_id
1733: , department_id = l_department_id

Line 1742: ELSIF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN

1738: , negative_req_flag = SIGN(transaction_quantity)
1739: , required_flag = '1'
1740: , pick_slip_number = l_pick_slip_number
1741: WHERE transaction_temp_id = c_mmtt_rec.transaction_temp_id;
1742: ELSIF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN
1743: UPDATE mtl_material_transactions_temp
1744: SET transaction_source_id = p_mo_line_rec.txn_source_id
1745: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1746: , demand_source_header_id = p_mo_line_rec.txn_source_id

Line 1748: , transaction_source_type_id = inv_globals.g_sourcetype_inventory

1744: SET transaction_source_id = p_mo_line_rec.txn_source_id
1745: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1746: , demand_source_header_id = p_mo_line_rec.txn_source_id
1747: , demand_source_line = p_mo_line_rec.txn_source_line_id
1748: , transaction_source_type_id = inv_globals.g_sourcetype_inventory
1749: , transaction_type_id = p_mo_line_rec.transaction_type_id
1750: , transaction_action_id = inv_globals.g_action_subxfr
1751: , wip_entity_type = l_wip_entity_type
1752: , wip_supply_type = NULL -- Bug#2057540

Line 1750: , transaction_action_id = inv_globals.g_action_subxfr

1746: , demand_source_header_id = p_mo_line_rec.txn_source_id
1747: , demand_source_line = p_mo_line_rec.txn_source_line_id
1748: , transaction_source_type_id = inv_globals.g_sourcetype_inventory
1749: , transaction_type_id = p_mo_line_rec.transaction_type_id
1750: , transaction_action_id = inv_globals.g_action_subxfr
1751: , wip_entity_type = l_wip_entity_type
1752: , wip_supply_type = NULL -- Bug#2057540
1753: , pick_slip_number = l_pick_slip_number
1754: WHERE transaction_temp_id = c_mmtt_rec.transaction_temp_id;

Line 1880: IF p_transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN

1876: CLOSE c_flow_dept;
1877: END IF;
1878:
1879: -- Repetitive Line ID
1880: IF p_transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN
1881: IF x_wip_entity_type = 2 THEN
1882: IF p_rep_schedule_id IS NULL THEN
1883: IF (l_debug = 1) THEN
1884: print_debug('Repetitive Schedule ID cannot be null for Entity Type 2', 'UPDATE_MMTT_FOR_WIP');