eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TRANSFER_ORDER_PVT dependencies on SERIAL_CHECK

Line 478: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

474: DELETE FROM mtl_serial_numbers_temp
475: WHERE CURRENT OF serial_temp_csr;
476:
477: /*** {{ R12 Enhanced reservations code changes,
478: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
479: UPDATE mtl_serial_numbers
480: SET line_mark_id = unmarked_value
481: , group_mark_id = unmarked_value
482: , lot_line_mark_id = unmarked_value

Line 490: serial_check.inv_unmark_rsv_serial

486: AND LENGTH(serial_number) = LENGTH(NVL(l_fm_serial_number, serial_number));
487: *** End R12 }} ***/
488:
489: /*** {{ R12 Enhanced reservations code changes ***/
490: serial_check.inv_unmark_rsv_serial
491: (from_serial_number => l_fm_serial_number
492: ,to_serial_number => l_to_serial_number
493: ,serial_code => null
494: ,hdr_id => l_transaction_header_id

Line 3511: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

3507: DEBUG('serial number:'|| l_serial_number, 'Finalize_Pick_Confirm');
3508: END IF;
3509:
3510: /*** {{ R12 Enhanced reservations code changes,
3511: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
3512: UPDATE mtl_serial_numbers
3513: SET group_mark_id = NULL
3514: WHERE serial_number = l_serial_number
3515: AND inventory_item_id = l_mmtt_rec.inventory_item_id;

Line 3519: serial_check.inv_unmark_rsv_serial

3515: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
3516: *** End R12 }} ***/
3517:
3518: /*** {{ R12 Enhanced reservations code changes ***/
3519: serial_check.inv_unmark_rsv_serial
3520: (from_serial_number => l_serial_number
3521: ,to_serial_number => null
3522: ,serial_code => null
3523: ,hdr_id => null

Line 3547: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

3543: DEBUG('serial number:'|| l_serial_number, 'Finalize_Pick_Confirm');
3544: END IF;
3545:
3546: /*** {{ R12 Enhanced reservations code changes,
3547: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
3548: UPDATE mtl_serial_numbers
3549: SET group_mark_id = NULL
3550: WHERE serial_number = l_serial_number
3551: AND inventory_item_id = l_mmtt_rec.inventory_item_id;

Line 3555: serial_check.inv_unmark_rsv_serial

3551: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
3552: *** End R12 }} ***/
3553:
3554: /*** {{ R12 Enhanced reservations code changes ***/
3555: serial_check.inv_unmark_rsv_serial
3556: (from_serial_number => l_serial_number
3557: ,to_serial_number => null
3558: ,serial_code => null
3559: ,hdr_id => null

Line 5074: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

5070: END IF;
5071: ELSE
5072: -- Unmark the remaining serials
5073: /*** {{ R12 Enhanced reservations code changes,
5074: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
5075: UPDATE mtl_serial_numbers
5076: SET group_mark_id = NULL
5077: WHERE serial_number = l_serial_number
5078: AND inventory_item_id = l_mmtt_rec.inventory_item_id;

Line 5082: serial_check.inv_unmark_rsv_serial

5078: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
5079: *** End R12 }} ***/
5080:
5081: /*** {{ R12 Enhanced reservations code changes ***/
5082: serial_check.inv_unmark_rsv_serial
5083: (from_serial_number => l_serial_number
5084: ,to_serial_number => null
5085: ,serial_code => null
5086: ,hdr_id => null

Line 5303: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

5299: END IF;
5300: ELSE
5301: -- Unmark the remaining serials
5302: /*** {{ R12 Enhanced reservations code changes,
5303: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
5304: UPDATE mtl_serial_numbers
5305: SET group_mark_id = NULL
5306: WHERE serial_number = l_serial_number
5307: AND inventory_item_id = l_mmtt_rec.inventory_item_id;

Line 5311: serial_check.inv_unmark_rsv_serial

5307: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
5308: *** End R12 }} ***/
5309:
5310: /*** {{ R12 Enhanced reservations code changes ***/
5311: serial_check.inv_unmark_rsv_serial
5312: (from_serial_number => l_serial_number
5313: ,to_serial_number => null
5314: ,serial_code => null
5315: ,hdr_id => null

Line 6883: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

6879: and fm_Serial_number = l_Serial_cursor.fm_serial_number
6880: and to_Serial_number = l_Serial_cursor.to_serial_number;
6881:
6882: /*** {{ R12 Enhanced reservations code changes,
6883: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6884: update mtl_Serial_numbers
6885: set group_mark_id = null
6886: where current_organization_id = l_serial_cursor.organization_id
6887: and inventory_item_id = l_Serial_cursor.inventory_item_id

Line 6892: serial_check.inv_unmark_rsv_serial

6888: and serial_number between l_Serial_cursor.fm_Serial_number and l_serial_cursor.to_Serial_number;
6889: *** End R12 }} ***/
6890:
6891: /*** {{ R12 Enhanced reservations code changes ***/
6892: serial_check.inv_unmark_rsv_serial
6893: (from_serial_number => l_Serial_cursor.fm_Serial_number
6894: ,to_serial_number => l_serial_cursor.to_Serial_number
6895: ,serial_code => null
6896: ,hdr_id => null

Line 6912: IF NOT mtl_serial_check.INV_SERIAL_INFO

6908: DEBUG('Inside ifelse p_qty= '||p_qty||' diff_qty= '||diff_qty||' qty_count= '||qty_count,'INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6909: DEBUG(' fm_Ser_num= '||l_Serial_cursor.fm_serial_number ||' to_Ser_num= '||l_Serial_cursor.to_serial_number ,'INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6910: END IF;
6911:
6912: IF NOT mtl_serial_check.INV_SERIAL_INFO
6913: (p_from_serial_number => l_Serial_cursor.fm_serial_number ,
6914: p_to_serial_number => l_Serial_cursor.to_serial_number ,
6915: x_prefix => x_prefix,
6916: x_quantity => x_quantity,

Line 6952: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

6948: --set a flag to delete the subsequent records from MSNT
6949:
6950: --unmark these serial numbers in MSN
6951: /*** {{ R12 Enhanced reservations code changes,
6952: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6953: update mtl_serial_numbers
6954: set group_mark_id = null
6955: where current_organization_id = l_serial_cursor.organization_id
6956: and inventory_item_id = l_serial_cursor.inventory_item_id

Line 6961: serial_check.inv_unmark_rsv_serial

6957: and serial_number between x_prefix||l_new_num_str_update and l_Serial_cursor.to_serial_number;
6958: *** End R12 }} ***/
6959:
6960: /*** {{ R12 Enhanced reservations code changes ***/
6961: serial_check.inv_unmark_rsv_serial
6962: (from_serial_number => x_prefix||l_new_num_str_update
6963: ,to_serial_number => l_serial_cursor.to_serial_number
6964: ,serial_code => null
6965: ,hdr_id => null

Line 6984: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

6980: and to_serial_number = l_serial_cursor.to_serial_number
6981: and transaction_temp_id = p_transaction_Temp_id;
6982:
6983: /*** {{ R12 Enhanced reservations code changes,
6984: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6985: update mtl_serial_numbers
6986: set group_mark_id = null
6987: where current_organization_id = l_serial_cursor.organization_id
6988: and inventory_item_id = l_serial_cursor.inventory_item_id

Line 6993: serial_check.inv_unmark_rsv_serial

6989: and serial_number = l_Serial_cursor.fm_serial_number;
6990: *** End R12 }} ***/
6991:
6992: /*** {{ R12 Enhanced reservations code changes ***/
6993: serial_check.inv_unmark_rsv_serial
6994: (from_serial_number => l_Serial_cursor.fm_serial_number
6995: ,to_serial_number => null
6996: ,serial_code => null
6997: ,hdr_id => null

Line 7020: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

7016: and transaction_temp_id = p_transaction_Temp_id;
7017:
7018:
7019: /*** {{ R12 Enhanced reservations code changes,
7020: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
7021: update mtl_serial_numbers
7022: set group_mark_id = null
7023: where current_organization_id = l_serial_cursor.organization_id
7024: and inventory_item_id = l_serial_cursor.inventory_item_id

Line 7029: serial_check.inv_unmark_rsv_serial

7025: and serial_number = l_Serial_cursor.to_serial_number;
7026: *** End R12 }} ***/
7027:
7028: /*** {{ R12 Enhanced reservations code changes ***/
7029: serial_check.inv_unmark_rsv_serial
7030: (from_serial_number => l_Serial_cursor.to_serial_number
7031: ,to_serial_number => null
7032: ,serial_code => null
7033: ,hdr_id => null