DBA Data[Home] [Help]

APPS.INV_TRX_UTIL_PUB dependencies on SERIAL_CHECK

Line 1021: does not derive txn temp id and pass null to API serial_check.inv_mark_serial

1017: BEGIN
1018: /*Fixed Bug#6758460 regardless of validation level
1019: txn temp id should be validated and serial number should be marked
1020: If customer does not pass validation leverl as full then this API
1021: does not derive txn temp id and pass null to API serial_check.inv_mark_serial
1022: This cause serial number to me unmarked and it makes ITS fails with error
1023: missing serial number error.
1024: */
1025:

Line 1324: serial_check.inv_mark_serial(

1320: , p_dffupdatedflag
1321: );
1322:
1323: -- Populate group_mark_id in MSN for the range of serial passed
1324: serial_check.inv_mark_serial(
1325: from_serial_number => p_fm_ser_num
1326: , to_serial_number => p_to_ser_num
1327: , item_id => l_item_id
1328: , org_id => l_org_id

Line 1974: serial_check.inv_unmark_serial(

1970: BEGIN
1971: DELETE FROM mtl_serial_numbers_temp
1972: WHERE transaction_temp_id = NVL(p_serial_trx_tmp_id, p_trx_tmp_id);
1973:
1974: serial_check.inv_unmark_serial(
1975: from_serial_number => NULL
1976: , to_serial_number => NULL
1977: , serial_code => p_serial_control_code
1978: , hdr_id => p_trx_header_id

Line 2181: serial_check.inv_unmark_serial(

2177: IF ((p_serctrl <> 1) AND(p_lotctrl <> 2)) THEN
2178: --Item is only serial controlled
2179: FOR c_serial_rec IN c_serial(p_trx_tmp_id) LOOP
2180: --Now Call inv_unmark_serial
2181: serial_check.inv_unmark_serial(
2182: from_serial_number => c_serial_rec.fm_serial_number
2183: , to_serial_number => c_serial_rec.to_serial_number
2184: , serial_code => p_serctrl
2185: , hdr_id => NULL

Line 2200: serial_check.inv_unmark_serial(

2196: --Now get the serial txn temp ids
2197:
2198: FOR c_serial_rec IN c_serial(c_lot_rec.serial_transaction_temp_id) LOOP
2199: --Now call inv_unmark_serial
2200: serial_check.inv_unmark_serial(
2201: from_serial_number => c_serial_rec.fm_serial_number
2202: , to_serial_number => c_serial_rec.to_serial_number
2203: , serial_code => p_serctrl
2204: , hdr_id => NULL