120:
121: --Get value from sequence for next transaction_header_id
122: SELECT mtl_material_transactions_s.NEXTVAL
123: INTO l_next_transaction_header_id
124: FROM dual ;
125:
126: IF (l_debug = 1) THEN
127: mydebug('Backflush: header_id: ' || l_next_transaction_header_id);
128: END IF;
138:
139: --Get value from sequence for next transaction_temp_id
140: SELECT mtl_material_transactions_s.NEXTVAL
141: INTO l_next_transaction_temp_id
142: FROM dual ;
143:
144: IF (l_debug = 1) THEN
145: mydebug('Backflush: temp_id '||l_next_transaction_temp_id);
146: END IF;
656:
657: --Get value from sequence for next serial_transaction_temp_id
658: SELECT mtl_material_transactions_s.NEXTVAL
659: INTO l_next_ser_tran_temp_id
660: FROM dual;
661:
662: --Update MTLT line
663: UPDATE mtl_transaction_lots_temp
664: SET serial_transaction_temp_id = l_next_ser_tran_temp_id
1512: where serial_number = p_serial_number
1513: and inventory_item_id = l_item_id;
1514:
1515: if( l_object_id is null ) then
1516: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1517: end if;
1518:
1519: UPDATE mtl_serial_numbers
1520: SET
1641:
1642: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1643:
1644: -- Lot number does not exist
1645: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1646:
1647: INSERT INTO mtl_lot_numbers
1648: (INVENTORY_ITEM_ID
1649: ,ORGANIZATION_ID
2729: l_msg VARCHAR2(5100);
2730: l_ts VARCHAR2(30);
2731: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2732: BEGIN
2733: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
2734: -- l_msg:=l_ts||' '||msg;
2735:
2736: l_msg := msg;
2737: