DBA Data[Home] [Help]

APPS.INV_LOT_TRX_VALIDATION_PUB dependencies on INV_SERIAL_NUMBER_PUB

Line 4684: Call INV_SERIAL_NUMBER_PUB.validate_serials.

4680: -> Source Serials should match Resulting Serials in Count and Serial Number
4681: -> Source Serials should be available for transactions. (GM ID validation)
4682: -> Serial Material status validation for the source Serials.
4683: -> If Lot Translate and Item Id changed Then
4684: Call INV_SERIAL_NUMBER_PUB.validate_serials.
4685: This will perform uniqueness
4686: check and if possible create the new serial for the Resulting Item.
4687: End IF
4688: ****************************************************************************/

Line 4955: print_debug ('Calling INV_SERIAL_NUMBER_PUB.VALIDATE_SERIALS', 'Validate_serials');

4951: */
4952: IF (l_debug = 1)
4953: THEN
4954: print_debug ('breadcrumb 130', 'Validate_serials');
4955: print_debug ('Calling INV_SERIAL_NUMBER_PUB.VALIDATE_SERIALS', 'Validate_serials');
4956: END IF;
4957: l_qty := 0;
4958: l_end_ser := p_rs_ser_number_tbl(l_rs_var_index);
4959: IF (inv_serial_number_pub.validate_serials

Line 4959: IF (inv_serial_number_pub.validate_serials

4955: print_debug ('Calling INV_SERIAL_NUMBER_PUB.VALIDATE_SERIALS', 'Validate_serials');
4956: END IF;
4957: l_qty := 0;
4958: l_end_ser := p_rs_ser_number_tbl(l_rs_var_index);
4959: IF (inv_serial_number_pub.validate_serials
4960: (p_org_id => p_rs_org_id_tbl (1)
4961: , p_item_id => p_rs_item_id_tbl (1)
4962: , p_qty => l_qty
4963: , p_lot => p_rs_lot_num_tbl (1)

Line 5691: inv_serial_number_pub.is_serial_unique (p_org_id

5687: );
5688: END IF;
5689:
5690: l_ret :=
5691: inv_serial_number_pub.is_serial_unique (p_org_id
5692: , p_to_item_id
5693: , l_ser_number_tbl (i)
5694: , x_msg_data
5695: );