2345: x_msg_data ,
2346: x_msg_count );
2347:
2348: IF mtlt.serial_transaction_temp_id IS NOT NULL THEN
2349: SELECT mtl_material_transactions_s.NEXTVAL
2350: INTO l_new_serial_txn_temp_id
2351: FROM dual;
2352: UPDATE mtl_transaction_lots_temp
2353: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
6849: print_msg(l_procedure_name, ' SAVEPOINT wms_split_task established');
6850: END IF;
6851: FOR i IN l_split_uom_quantities.FIRST .. l_split_uom_quantities.LAST
6852: LOOP
6853: SELECT mtl_material_transactions_s.NEXTVAL
6854: INTO l_new_transaction_header_id
6855: FROM dual;
6856: SELECT mtl_material_transactions_s.NEXTVAL
6857: INTO l_new_transaction_temp_id
6852: LOOP
6853: SELECT mtl_material_transactions_s.NEXTVAL
6854: INTO l_new_transaction_header_id
6855: FROM dual;
6856: SELECT mtl_material_transactions_s.NEXTVAL
6857: INTO l_new_transaction_temp_id
6858: FROM dual;
6859: SELECT wms_dispatched_tasks_s.NEXTVAL INTO l_new_task_id FROM dual;
6860: IF g_debug = 1 THEN