APPS.OE_DS_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 839: MTL_SERIAL_NUMBERS_INTERFACE : For every serial number

835: This API will insert records into
836:
837: MTL_TRANSACTION_LOTS_INTERFACE: For every receipt in lot
838: (lot controlled items).
839: MTL_SERIAL_NUMBERS_INTERFACE : For every serial number
840: receipt (serial controlled
841: items.)
842: MTL_TRANSACTIONS_INTERFACE : For every transaction
843: (corresponds to qty recd

Line 1160: oe_debug_pub.add( 'Inserting into mtl_serial_numbers_interface table ' , 1 ) ;

1156:
1157: BEGIN
1158:
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'Inserting into mtl_serial_numbers_interface table ' , 1 ) ;
1161: END IF;
1162:
1163: insert into mtl_serial_numbers_interface
1164: (transaction_interface_id,

Line 1163: insert into mtl_serial_numbers_interface

1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'Inserting into mtl_serial_numbers_interface table ' , 1 ) ;
1161: END IF;
1162:
1163: insert into mtl_serial_numbers_interface
1164: (transaction_interface_id,
1165: source_code,
1166: source_line_id,
1167: last_update_date,

Line 1208: oe_debug_pub.add( 'Failed inserting into mtl_serial_numbers_interface' , 1 ) ;

1204:
1205: EXCEPTION
1206: WHEN OTHERS THEN
1207: IF l_debug_level > 0 THEN
1208: oe_debug_pub.add( 'Failed inserting into mtl_serial_numbers_interface' , 1 ) ;
1209: END IF;
1210: -- bug 5357879
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: ROLLBACK TO DECREMENT_INV;