DBA Data[Home] [Help]

APPS.WMS_ITEM_LOAD dependencies on INV_TRX_UTIL_PUB

Line 1827: l_return := inv_trx_util_pub.insert_line_trx

1823: END IF;
1824: l_progress := '430';
1825:
1826: -- Insert a record into MMTT
1827: l_return := inv_trx_util_pub.insert_line_trx
1828: (p_trx_hdr_id => p_txn_header_id,
1829: p_item_id => p_inventory_item_id,
1830: p_revision => p_revision,
1831: p_org_id => p_organization_id,

Line 1869: print_debug('Error occurred while calling inv_trx_util_pub.insert_line_trx');

1865:
1866: -- Check if the API call was successful or not
1867: IF (l_return <> 0) THEN
1868: IF (l_debug = 1) THEN
1869: print_debug('Error occurred while calling inv_trx_util_pub.insert_line_trx');
1870: END IF;
1871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1872: END IF;
1873: l_progress := '450';

Line 1894: l_return := inv_trx_util_pub.insert_lot_trx

1890: IF (p_lot_number IS NOT NULL) THEN
1891: IF (l_debug = 1) THEN
1892: print_debug('Insert a record into MTLT for lot: ' || p_lot_number);
1893: END IF;
1894: l_return := inv_trx_util_pub.insert_lot_trx
1895: (p_trx_tmp_id => l_txn_temp_id,
1896: p_user_id => p_user_id,
1897: p_lot_number => p_lot_number,
1898: p_trx_qty => l_trx_qty,

Line 1912: print_debug('Error occurred while calling inv_trx_util_pub.insert_lot_trx');

1908: l_progress := '460';
1909:
1910: IF (l_return <> 0) THEN
1911: IF (l_debug = 1) THEN
1912: print_debug('Error occurred while calling inv_trx_util_pub.insert_lot_trx');
1913: END IF;
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1915: END IF;
1916: l_progress := '470';

Line 1962: l_return := inv_trx_util_pub.insert_ser_trx

1958: print_debug('Insert a record into MSNT for serial: ' || l_current_serial);
1959: END IF;
1960: l_progress := '500';
1961:
1962: l_return := inv_trx_util_pub.insert_ser_trx
1963: (p_trx_tmp_id => l_ser_trx_id,
1964: p_user_id => p_user_id,
1965: p_fm_ser_num => l_current_serial,
1966: p_to_ser_num => l_current_serial,

Line 1976: print_debug('Error occurred while calling inv_trx_util_pub.insert_ser_trx');

1972: l_progress := '510';
1973:
1974: IF (l_return <> 0) THEN
1975: IF (l_debug = 1) THEN
1976: print_debug('Error occurred while calling inv_trx_util_pub.insert_ser_trx');
1977: END IF;
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1979: END IF;
1980: l_progress := '520';

Line 2004: l_return := inv_trx_util_pub.insert_ser_trx

2000: print_debug('Insert a record into MSNT for serial: ' || l_current_serial);
2001: END IF;
2002: l_progress := '540';
2003:
2004: l_return := inv_trx_util_pub.insert_ser_trx
2005: (p_trx_tmp_id => l_ser_trx_id,
2006: p_user_id => p_user_id,
2007: p_fm_ser_num => l_current_serial,
2008: p_to_ser_num => l_current_serial,

Line 2018: print_debug('Error occurred while calling inv_trx_util_pub.insert_ser_trx');

2014: l_progress := '550';
2015:
2016: IF (l_return <> 0) THEN
2017: IF (l_debug = 1) THEN
2018: print_debug('Error occurred while calling inv_trx_util_pub.insert_ser_trx');
2019: END IF;
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END IF;
2022: l_progress := '560';