[Home] [Help]
3621: OR l_lpn_discrepancy_flag = 1 )
3622: ) THEN
3623:
3624: IF ( l_txn_header_id = -2 ) THEN
3625: SELECT mtl_material_transactions_s.NEXTVAL
3626: INTO l_txn_header_id
3627: FROM DUAL;
3628:
3629: g_txn_header_id := l_txn_header_id;
3635: END IF;
3636:
3637: IF ( l_serial_number IS NOT NULL ) THEN
3638: print_debug ( 'l_serial_number '||l_serial_number);
3639: SELECT mtl_material_transactions_s.NEXTVAL
3640: INTO l_txn_temp_id
3641: FROM DUAL;
3642:
3643: SELECT auto_serial_alpha_prefix
3813: RAISE FND_API.G_EXC_ERROR;
3814: END IF;
3815:
3816: -- Get a new txn temp ID for receiving the serial back into inventory
3817: SELECT mtl_material_transactions_s.NEXTVAL
3818: INTO l_txn_temp_id
3819: FROM DUAL;
3820: END IF;
3821: END IF;
3960: RAISE FND_API.G_EXC_ERROR;
3961: END IF;
3962:
3963: -- Get a new txn temp ID for the next record into MMTT
3964: SELECT mtl_material_transactions_s.NEXTVAL
3965: INTO l_txn_temp_id
3966: FROM DUAL;
3967: END IF;
3968: END IF;
6562: END IF;
6563:
6564: IF ( l_entry_status_code = 5 AND l_adjustment_quantity <> 0 ) THEN
6565: IF ( l_txn_header_id = -2 ) THEN
6566: SELECT mtl_material_transactions_s.NEXTVAL
6567: INTO l_txn_header_id
6568: FROM DUAL;
6569:
6570: g_txn_header_id := l_txn_header_id;
6569:
6570: g_txn_header_id := l_txn_header_id;
6571: END IF;
6572:
6573: SELECT mtl_material_transactions_s.NEXTVAL
6574: INTO l_txn_temp_id
6575: FROM DUAL;
6576:
6577: SELECT auto_serial_alpha_prefix
6887: RAISE FND_API.G_EXC_ERROR;
6888: END IF;
6889:
6890: -- Get a new txn temp ID for receiving the serial back into inventory
6891: SELECT mtl_material_transactions_s.NEXTVAL
6892: INTO l_txn_temp_id
6893: FROM DUAL;
6894: END IF;
6895: