APPS.OE_DS_PVT dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 814: MTL_SERIAL_NUMBERS_INTERFACE : For every serial number

810: This API will insert records into
811:
812: MTL_TRANSACTION_LOTS_INTERFACE: For every receipt in lot
813: (lot controlled items).
814: MTL_SERIAL_NUMBERS_INTERFACE : For every serial number
815: receipt (serial controlled
816: items.)
817: MTL_TRANSACTIONS_INTERFACE : For every transaction
818: (corresponds to qty recd

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

1131:
1132: BEGIN
1133:
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'Inserting into mtl_serial_numbers_interface table ' , 1 ) ;
1136: END IF;
1137:
1138: insert into mtl_serial_numbers_interface
1139: (transaction_interface_id,

Line 1138: insert into mtl_serial_numbers_interface

1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'Inserting into mtl_serial_numbers_interface table ' , 1 ) ;
1136: END IF;
1137:
1138: insert into mtl_serial_numbers_interface
1139: (transaction_interface_id,
1140: source_code,
1141: source_line_id,
1142: last_update_date,

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

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: IF l_debug_level > 0 THEN
1183: oe_debug_pub.add( 'Failed inserting into mtl_serial_numbers_interface' , 1 ) ;
1184: END IF;
1185: -- bug 5357879
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: ROLLBACK TO DECREMENT_INV;