[Home] [Help]
889: BEGIN
890: /*Fixed Bug#6758460 regardless of validation level
891: txn temp id should be validated and serial number should be marked
892: If customer does not pass validation leverl as full then this API
893: does not derive txn temp id and pass null to API serial_check.inv_mark_serial
894: This cause serial number to me unmarked and it makes ITS fails with error
895: missing serial number error.
896: */
897:
1192: , p_dffupdatedflag
1193: );
1194:
1195: -- Populate group_mark_id in MSN for the range of serial passed
1196: serial_check.inv_mark_serial(
1197: from_serial_number => p_fm_ser_num
1198: , to_serial_number => p_to_ser_num
1199: , item_id => l_item_id
1200: , org_id => l_org_id
1831: BEGIN
1832: DELETE FROM mtl_serial_numbers_temp
1833: WHERE transaction_temp_id = NVL(p_serial_trx_tmp_id, p_trx_tmp_id);
1834:
1835: serial_check.inv_unmark_serial(
1836: from_serial_number => NULL
1837: , to_serial_number => NULL
1838: , serial_code => p_serial_control_code
1839: , hdr_id => p_trx_header_id
2022: IF ((p_serctrl <> 1) AND(p_lotctrl <> 2)) THEN
2023: --Item is only serial controlled
2024: FOR c_serial_rec IN c_serial(p_trx_tmp_id) LOOP
2025: --Now Call inv_unmark_serial
2026: serial_check.inv_unmark_serial(
2027: from_serial_number => c_serial_rec.fm_serial_number
2028: , to_serial_number => c_serial_rec.to_serial_number
2029: , serial_code => p_serctrl
2030: , hdr_id => NULL
2041: --Now get the serial txn temp ids
2042:
2043: FOR c_serial_rec IN c_serial(c_lot_rec.serial_transaction_temp_id) LOOP
2044: --Now call inv_unmark_serial
2045: serial_check.inv_unmark_serial(
2046: from_serial_number => c_serial_rec.fm_serial_number
2047: , to_serial_number => c_serial_rec.to_serial_number
2048: , serial_code => p_serctrl
2049: , hdr_id => NULL