1905: RAISE g_qty_not_avail;
1906: END IF;
1907:
1908: lot_row.transaction_temp_id := new_txn_temp_id;
1909: inv_rcv_common_apis.insert_mtlt(lot_row);
1910: lot_row := NULL;
1911: END IF;
1912: END LOOP;
1913: /********* serial Controlled only **************/
1972: RAISE g_qty_not_avail;
1973: END IF;
1974: /**2706001 checking group mark ids here **/
1975: ser_row.transaction_temp_id := new_txn_temp_id;
1976: inv_rcv_common_apis.insert_msnt(ser_row);
1977: ser_row := NULL;
1978: END IF;
1979: END LOOP;
1980: END IF;
2012: END IF;
2013:
2014: lot_row.serial_transaction_temp_id := NULL;
2015: lot_row.transaction_temp_id := new_txn_temp_id;
2016: inv_rcv_common_apis.insert_mtlt(lot_row);
2017: lot_row := NULL;
2018: END IF;
2019: END LOOP;
2020: --END IF;
2086: END IF;
2087: /**2706001 checking group mark ids here **/
2088:
2089: ser_row.transaction_temp_id:= ser_transaction_temp_id;
2090: inv_rcv_common_apis.insert_msnt(ser_row);
2091: ser_row := NULL;
2092: --lot_row.serial_transaction_temp_id := ser_row.transaction_temp_id;
2093: END IF;
2094: END LOOP;
2097: /**2706001 moved this assignment out of the loop **/
2098: lot_row.serial_transaction_temp_id := ser_transaction_temp_id;
2099:
2100: lot_row.transaction_temp_id := new_txn_temp_id;
2101: inv_rcv_common_apis.insert_mtlt(lot_row);
2102: lot_row := NULL;
2103: END IF;
2104: END LOOP;
2105: END IF;