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 832: IF l_mo_type <> inv_globals.g_move_order_mfg_pick THEN

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

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

1765: ELSE
1766: l_pick_slip_number := c_mmtt_rec.pick_slip_number;
1767: END IF;
1768:
1769: IF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN
1770: UPDATE mtl_material_transactions_temp
1771: SET transaction_source_id = p_mo_line_rec.txn_source_id
1772: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1773: , demand_source_header_id = p_mo_line_rec.txn_source_id

Line 1775: , transaction_source_type_id = inv_globals.g_sourcetype_wip

1771: SET transaction_source_id = p_mo_line_rec.txn_source_id
1772: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1773: , demand_source_header_id = p_mo_line_rec.txn_source_id
1774: , demand_source_line = p_mo_line_rec.txn_source_line_id
1775: , transaction_source_type_id = inv_globals.g_sourcetype_wip
1776: , transaction_type_id = p_mo_line_rec.transaction_type_id
1777: , transaction_action_id = inv_globals.g_action_issue
1778: , wip_entity_type = l_wip_entity_type
1779: , repetitive_line_id = l_repetitive_line_id

Line 1777: , transaction_action_id = inv_globals.g_action_issue

1773: , demand_source_header_id = p_mo_line_rec.txn_source_id
1774: , demand_source_line = p_mo_line_rec.txn_source_line_id
1775: , transaction_source_type_id = inv_globals.g_sourcetype_wip
1776: , transaction_type_id = p_mo_line_rec.transaction_type_id
1777: , transaction_action_id = inv_globals.g_action_issue
1778: , wip_entity_type = l_wip_entity_type
1779: , repetitive_line_id = l_repetitive_line_id
1780: , operation_seq_num = p_mo_line_rec.txn_source_line_id
1781: , department_id = l_department_id

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

1786: , negative_req_flag = SIGN(transaction_quantity)
1787: , required_flag = '1'
1788: , pick_slip_number = l_pick_slip_number
1789: WHERE transaction_temp_id = c_mmtt_rec.transaction_temp_id;
1790: ELSIF p_mo_line_rec.transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_REPL_SUBXFR THEN
1791: UPDATE mtl_material_transactions_temp
1792: SET transaction_source_id = p_mo_line_rec.txn_source_id
1793: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1794: , demand_source_header_id = p_mo_line_rec.txn_source_id

Line 1796: , transaction_source_type_id = inv_globals.g_sourcetype_inventory

1792: SET transaction_source_id = p_mo_line_rec.txn_source_id
1793: , trx_source_line_id = p_mo_line_rec.txn_source_line_id
1794: , demand_source_header_id = p_mo_line_rec.txn_source_id
1795: , demand_source_line = p_mo_line_rec.txn_source_line_id
1796: , transaction_source_type_id = inv_globals.g_sourcetype_inventory
1797: , transaction_type_id = p_mo_line_rec.transaction_type_id
1798: , transaction_action_id = inv_globals.g_action_subxfr
1799: , wip_entity_type = l_wip_entity_type
1800: , wip_supply_type = NULL -- Bug#2057540

Line 1798: , transaction_action_id = inv_globals.g_action_subxfr

1794: , demand_source_header_id = p_mo_line_rec.txn_source_id
1795: , demand_source_line = p_mo_line_rec.txn_source_line_id
1796: , transaction_source_type_id = inv_globals.g_sourcetype_inventory
1797: , transaction_type_id = p_mo_line_rec.transaction_type_id
1798: , transaction_action_id = inv_globals.g_action_subxfr
1799: , wip_entity_type = l_wip_entity_type
1800: , wip_supply_type = NULL -- Bug#2057540
1801: , pick_slip_number = l_pick_slip_number
1802: WHERE transaction_temp_id = c_mmtt_rec.transaction_temp_id;

Line 1928: IF p_transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN

1924: CLOSE c_flow_dept;
1925: END IF;
1926:
1927: -- Repetitive Line ID
1928: IF p_transaction_type_id = INV_GLOBALS.G_TYPE_XFER_ORDER_WIP_ISSUE THEN
1929: IF x_wip_entity_type = 2 THEN
1930: IF p_rep_schedule_id IS NULL THEN
1931: IF (l_debug = 1) THEN
1932: print_debug('Repetitive Schedule ID cannot be null for Entity Type 2', 'UPDATE_MMTT_FOR_WIP');