[Home] [Help]
3328: OR l_lpn_discrepancy_flag = 1 )
3329: ) THEN
3330:
3331: IF ( l_txn_header_id = -2 ) THEN
3332: SELECT mtl_material_transactions_s.NEXTVAL
3333: INTO l_txn_header_id
3334: FROM DUAL;
3335:
3336: g_txn_header_id := l_txn_header_id;
3338: END IF;
3339:
3340: IF ( l_serial_number IS NOT NULL ) THEN
3341: print_debug ( 'l_serial_number '||l_serial_number);
3342: SELECT mtl_material_transactions_s.NEXTVAL
3343: INTO l_txn_temp_id
3344: FROM DUAL;
3345:
3346: SELECT auto_serial_alpha_prefix
3516: RAISE FND_API.G_EXC_ERROR;
3517: END IF;
3518:
3519: -- Get a new txn temp ID for receiving the serial back into inventory
3520: SELECT mtl_material_transactions_s.NEXTVAL
3521: INTO l_txn_temp_id
3522: FROM DUAL;
3523: END IF;
3524: END IF;
3649: RAISE FND_API.G_EXC_ERROR;
3650: END IF;
3651:
3652: -- Get a new txn temp ID for the next record into MMTT
3653: SELECT mtl_material_transactions_s.NEXTVAL
3654: INTO l_txn_temp_id
3655: FROM DUAL;
3656: END IF;
3657: END IF;
6456: END IF;
6457:
6458: IF ( l_entry_status_code = 5 AND l_adjustment_quantity <> 0 ) THEN
6459: IF ( l_txn_header_id = -2 ) THEN
6460: SELECT mtl_material_transactions_s.NEXTVAL
6461: INTO l_txn_header_id
6462: FROM DUAL;
6463:
6464: g_txn_header_id := l_txn_header_id;
6463:
6464: g_txn_header_id := l_txn_header_id;
6465: END IF;
6466:
6467: SELECT mtl_material_transactions_s.NEXTVAL
6468: INTO l_txn_temp_id
6469: FROM DUAL;
6470:
6471: SELECT auto_serial_alpha_prefix
6781: RAISE FND_API.G_EXC_ERROR;
6782: END IF;
6783:
6784: -- Get a new txn temp ID for receiving the serial back into inventory
6785: SELECT mtl_material_transactions_s.NEXTVAL
6786: INTO l_txn_temp_id
6787: FROM DUAL;
6788: END IF;
6789: