DBA Data[Home] [Help]

APPS.OE_DS_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 817: MTL_TRANSACTIONS_INTERFACE : For every transaction

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
819: in RCV_TRANSACTIONS)
820:
821: IMPORTANT: ALL THE RECORDS INSERTED IN THE ABOVE TABLE FOR A

Line 1460: INSERT INTO MTL_TRANSACTIONS_INTERFACE

1456: l_segment29,
1457: l_segment30;
1458: CLOSE c_transacc_info;
1459:
1460: INSERT INTO MTL_TRANSACTIONS_INTERFACE
1461: (
1462: SOURCE_CODE,
1463: SOURCE_LINE_ID,
1464: SOURCE_HEADER_ID,

Line 1639: oe_debug_pub.add( 'Failed while inserting records in mtl_transactions_interface '||sqlerrm , 1 ) ;

1635: x_return_status := FND_API.G_RET_STS_SUCCESS; -- bug 5357879
1636: END IF;
1637: EXCEPTION WHEN OTHERS THEN
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'Failed while inserting records in mtl_transactions_interface '||sqlerrm , 1 ) ;
1640: oe_debug_pub.add( 'Sales order issue transaction will not occur ' , 1 ) ;
1641: END IF;
1642:
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR; -- bug 5357879