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 475: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly

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

Line 487: serial_check.inv_unmark_rsv_serial

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

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

3280: DEBUG('serial number:'|| l_serial_number, 'Finalize_Pick_Confirm');
3281: END IF;
3282:
3283: /*** {{ R12 Enhanced reservations code changes,
3284: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
3285: UPDATE mtl_serial_numbers
3286: SET group_mark_id = NULL
3287: WHERE serial_number = l_serial_number
3288: AND inventory_item_id = l_mmtt_rec.inventory_item_id;

Line 3292: serial_check.inv_unmark_rsv_serial

3288: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
3289: *** End R12 }} ***/
3290:
3291: /*** {{ R12 Enhanced reservations code changes ***/
3292: serial_check.inv_unmark_rsv_serial
3293: (from_serial_number => l_serial_number
3294: ,to_serial_number => null
3295: ,serial_code => null
3296: ,hdr_id => null

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

3316: DEBUG('serial number:'|| l_serial_number, 'Finalize_Pick_Confirm');
3317: END IF;
3318:
3319: /*** {{ R12 Enhanced reservations code changes,
3320: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
3321: UPDATE mtl_serial_numbers
3322: SET group_mark_id = NULL
3323: WHERE serial_number = l_serial_number
3324: AND inventory_item_id = l_mmtt_rec.inventory_item_id;

Line 3328: serial_check.inv_unmark_rsv_serial

3324: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
3325: *** End R12 }} ***/
3326:
3327: /*** {{ R12 Enhanced reservations code changes ***/
3328: serial_check.inv_unmark_rsv_serial
3329: (from_serial_number => l_serial_number
3330: ,to_serial_number => null
3331: ,serial_code => null
3332: ,hdr_id => null

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

4734: END IF;
4735: ELSE
4736: -- Unmark the remaining serials
4737: /*** {{ R12 Enhanced reservations code changes,
4738: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
4739: UPDATE mtl_serial_numbers
4740: SET group_mark_id = NULL
4741: WHERE serial_number = l_serial_number
4742: AND inventory_item_id = l_mmtt_rec.inventory_item_id;

Line 4746: serial_check.inv_unmark_rsv_serial

4742: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
4743: *** End R12 }} ***/
4744:
4745: /*** {{ R12 Enhanced reservations code changes ***/
4746: serial_check.inv_unmark_rsv_serial
4747: (from_serial_number => l_serial_number
4748: ,to_serial_number => null
4749: ,serial_code => null
4750: ,hdr_id => null

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

4955: END IF;
4956: ELSE
4957: -- Unmark the remaining serials
4958: /*** {{ R12 Enhanced reservations code changes,
4959: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
4960: UPDATE mtl_serial_numbers
4961: SET group_mark_id = NULL
4962: WHERE serial_number = l_serial_number
4963: AND inventory_item_id = l_mmtt_rec.inventory_item_id;

Line 4967: serial_check.inv_unmark_rsv_serial

4963: AND inventory_item_id = l_mmtt_rec.inventory_item_id;
4964: *** End R12 }} ***/
4965:
4966: /*** {{ R12 Enhanced reservations code changes ***/
4967: serial_check.inv_unmark_rsv_serial
4968: (from_serial_number => l_serial_number
4969: ,to_serial_number => null
4970: ,serial_code => null
4971: ,hdr_id => null

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

6445: and fm_Serial_number = l_Serial_cursor.fm_serial_number
6446: and to_Serial_number = l_Serial_cursor.to_serial_number;
6447:
6448: /*** {{ R12 Enhanced reservations code changes,
6449: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6450: update mtl_Serial_numbers
6451: set group_mark_id = null
6452: where current_organization_id = l_serial_cursor.organization_id
6453: and inventory_item_id = l_Serial_cursor.inventory_item_id

Line 6458: serial_check.inv_unmark_rsv_serial

6454: and serial_number between l_Serial_cursor.fm_Serial_number and l_serial_cursor.to_Serial_number;
6455: *** End R12 }} ***/
6456:
6457: /*** {{ R12 Enhanced reservations code changes ***/
6458: serial_check.inv_unmark_rsv_serial
6459: (from_serial_number => l_Serial_cursor.fm_Serial_number
6460: ,to_serial_number => l_serial_cursor.to_Serial_number
6461: ,serial_code => null
6462: ,hdr_id => null

Line 6478: IF NOT mtl_serial_check.INV_SERIAL_INFO

6474: DEBUG('Inside ifelse p_qty= '||p_qty||' diff_qty= '||diff_qty||' qty_count= '||qty_count,'INV_TRANSFER_ORDER_PVT.adjust_serial_numbers_in_MMTT');
6475: 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');
6476: END IF;
6477:
6478: IF NOT mtl_serial_check.INV_SERIAL_INFO
6479: (p_from_serial_number => l_Serial_cursor.fm_serial_number ,
6480: p_to_serial_number => l_Serial_cursor.to_serial_number ,
6481: x_prefix => x_prefix,
6482: x_quantity => x_quantity,

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

6514: --set a flag to delete the subsequent records from MSNT
6515:
6516: --unmark these serial numbers in MSN
6517: /*** {{ R12 Enhanced reservations code changes,
6518: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6519: update mtl_serial_numbers
6520: set group_mark_id = null
6521: where current_organization_id = l_serial_cursor.organization_id
6522: and inventory_item_id = l_serial_cursor.inventory_item_id

Line 6527: serial_check.inv_unmark_rsv_serial

6523: and serial_number between x_prefix||l_new_num_str_update and l_Serial_cursor.to_serial_number;
6524: *** End R12 }} ***/
6525:
6526: /*** {{ R12 Enhanced reservations code changes ***/
6527: serial_check.inv_unmark_rsv_serial
6528: (from_serial_number => x_prefix||l_new_num_str_update
6529: ,to_serial_number => l_serial_cursor.to_serial_number
6530: ,serial_code => null
6531: ,hdr_id => null

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

6546: and to_serial_number = l_serial_cursor.to_serial_number
6547: and transaction_temp_id = p_transaction_Temp_id;
6548:
6549: /*** {{ R12 Enhanced reservations code changes,
6550: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6551: update mtl_serial_numbers
6552: set group_mark_id = null
6553: where current_organization_id = l_serial_cursor.organization_id
6554: and inventory_item_id = l_serial_cursor.inventory_item_id

Line 6559: serial_check.inv_unmark_rsv_serial

6555: and serial_number = l_Serial_cursor.fm_serial_number;
6556: *** End R12 }} ***/
6557:
6558: /*** {{ R12 Enhanced reservations code changes ***/
6559: serial_check.inv_unmark_rsv_serial
6560: (from_serial_number => l_Serial_cursor.fm_serial_number
6561: ,to_serial_number => null
6562: ,serial_code => null
6563: ,hdr_id => null

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

6582: and transaction_temp_id = p_transaction_Temp_id;
6583:
6584:
6585: /*** {{ R12 Enhanced reservations code changes,
6586: *** call serial_check.inv_unmark_rsv_serial instead of update msn directly
6587: update mtl_serial_numbers
6588: set group_mark_id = null
6589: where current_organization_id = l_serial_cursor.organization_id
6590: and inventory_item_id = l_serial_cursor.inventory_item_id

Line 6595: serial_check.inv_unmark_rsv_serial

6591: and serial_number = l_Serial_cursor.to_serial_number;
6592: *** End R12 }} ***/
6593:
6594: /*** {{ R12 Enhanced reservations code changes ***/
6595: serial_check.inv_unmark_rsv_serial
6596: (from_serial_number => l_Serial_cursor.to_serial_number
6597: ,to_serial_number => null
6598: ,serial_code => null
6599: ,hdr_id => null