eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TXN_MANAGER_GRP dependencies on INV_LOT_API_PUB

Line 1764: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE

1760:
1761: IF l_is_reversal <> 1 THEN
1762: /*Bug,9717803 END Avoiding the indivisible lot validation for the reversal transactions */
1763:
1764: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE
1765: ( p_api_version => 1.0
1766: , p_init_msg_list => fnd_api.g_false
1767: , p_transaction_type_id => p_transaction_type_id
1768: , p_organization_id => p_organization_id

Line 6085: l_attributes_tbl inv_lot_api_pub.char_tbl;

6081: FROM MTL_SERIAL_NUMBERS_INTERFACE
6082: WHERE TRANSACTION_INTERFACE_ID = interface_id;
6083:
6084: -- PL/SQL table to store lot attributes
6085: l_attributes_tbl inv_lot_api_pub.char_tbl;
6086: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
6087: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
6088: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
6089:

Line 6086: l_c_attributes_tbl inv_lot_api_pub.char_tbl;

6082: WHERE TRANSACTION_INTERFACE_ID = interface_id;
6083:
6084: -- PL/SQL table to store lot attributes
6085: l_attributes_tbl inv_lot_api_pub.char_tbl;
6086: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
6087: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
6088: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
6089:
6090: l_lot_exists NUMBER := 0;

Line 6087: l_n_attributes_tbl inv_lot_api_pub.number_tbl;

6083:
6084: -- PL/SQL table to store lot attributes
6085: l_attributes_tbl inv_lot_api_pub.char_tbl;
6086: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
6087: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
6088: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
6089:
6090: l_lot_exists NUMBER := 0;
6091: l_ret_number NUMBER := 0;

Line 6088: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

6084: -- PL/SQL table to store lot attributes
6085: l_attributes_tbl inv_lot_api_pub.char_tbl;
6086: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
6087: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
6088: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
6089:
6090: l_lot_exists NUMBER := 0;
6091: l_ret_number NUMBER := 0;
6092: l_qty NUMBER := NULL;

Line 6194: inv_log_util.trace('Before call to inv_lot_api_pub.create_inv_lot', 'INV_TXN_MANAGER_GRP', 9);

6190: l_d_attributes_tbl(9) := rec_MTLI.D_ATTRIBUTE9;
6191: l_d_attributes_tbl(10) := rec_MTLI.D_ATTRIBUTE10;
6192:
6193: IF (l_debug=1) THEN
6194: inv_log_util.trace('Before call to inv_lot_api_pub.create_inv_lot', 'INV_TXN_MANAGER_GRP', 9);
6195: END IF;
6196:
6197: inv_lot_api_pub.create_inv_lot(
6198: x_return_status => x_return_status

Line 6197: inv_lot_api_pub.create_inv_lot(

6193: IF (l_debug=1) THEN
6194: inv_log_util.trace('Before call to inv_lot_api_pub.create_inv_lot', 'INV_TXN_MANAGER_GRP', 9);
6195: END IF;
6196:
6197: inv_lot_api_pub.create_inv_lot(
6198: x_return_status => x_return_status
6199: , x_msg_count => l_msg_count
6200: , x_msg_data => x_proc_msg
6201: , p_inventory_item_id => p_item_id

Line 6240: inv_log_util.trace('After call to inv_lot_api_pub.create_inv_lot', 'INV_TXN_MANAGER_GRP', 9);

6236: , p_source => null
6237: );
6238:
6239: IF (l_debug=1) THEN
6240: inv_log_util.trace('After call to inv_lot_api_pub.create_inv_lot', 'INV_TXN_MANAGER_GRP', 9);
6241: inv_log_util.trace(' x_return_status : ' || x_return_status, 'INV_TXN_MANAGER_GRP', 9);
6242: END IF;
6243: END IF; -- End of Lot Exists check
6244:

Line 6247: inv_log_util.trace('Call to inv_lot_api_pub.create_inv_lot was successful','INV_TXN_MANAGER_GRP', 9);

6243: END IF; -- End of Lot Exists check
6244:
6245: IF (x_return_status = lg_ret_sts_success) THEN
6246: IF (l_debug=1) THEN
6247: inv_log_util.trace('Call to inv_lot_api_pub.create_inv_lot was successful','INV_TXN_MANAGER_GRP', 9);
6248: END IF;
6249: -- Looping through every serials in the lot
6250: FOR rec_MSNI IN cur_MSNI(rec_MTLI.SERIAL_TRANSACTION_TEMP_ID)
6251: LOOP

Line 6303: ELSE -- Failure from inv_lot_api_pub.create_inv_lot

6299: RETURN;
6300: END IF;
6301: END LOOP; -- End of cur_MSNI cursor
6302:
6303: ELSE -- Failure from inv_lot_api_pub.create_inv_lot
6304: x_return_status := lg_ret_sts_error;
6305: loaderrmsg('INV_INT_LOTCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
6306: IF (l_debug = 1) THEN
6307: inv_log_util.trace('Error from inv_lot_api_pub.create_inv_lot'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);

Line 6307: inv_log_util.trace('Error from inv_lot_api_pub.create_inv_lot'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);

6303: ELSE -- Failure from inv_lot_api_pub.create_inv_lot
6304: x_return_status := lg_ret_sts_error;
6305: loaderrmsg('INV_INT_LOTCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
6306: IF (l_debug = 1) THEN
6307: inv_log_util.trace('Error from inv_lot_api_pub.create_inv_lot'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);
6308: END IF;
6309: RETURN;
6310: END IF;
6311:

Line 15580: -- inv_lot_api_pub.Set_Msi_Default_Attr(p_lot_rec => l_lot_record);

15576: inv_log_util.trace('Calling Inv_Lot_API_PKG.Set_Msi_Default_Attr (1) ' , 'INV_TXN_MANAGER_GRP', 9);
15577: END IF;
15578: -- dbms_output.put_line('Calling Inv_Lot_API_PKG.Set_Msi_Default_Attr (1 )');
15579: /* Default attributes for lot from item master */
15580: -- inv_lot_api_pub.Set_Msi_Default_Attr(p_lot_rec => l_lot_record);
15581:
15582: Inv_Lot_API_PKG.Set_Msi_Default_Attr ( p_lot_rec => l_lot_record
15583: , x_return_status => l_return_status
15584: , x_msg_count => l_msg_count

Line 15933: INV_LOT_API_PUB.Update_Inv_lot(

15929: /*Bug#7425435 for the newlots created from the pending lots window of the
15930: batch details form, the attribured should be updated to the lots table */
15931: IF (l_new_child_lot) and l_existing_pending_lot = 1 THEN
15932: l_in_lot_rec := l_lot_record;
15933: INV_LOT_API_PUB.Update_Inv_lot(
15934: x_return_status => l_return_status
15935: , x_msg_count => l_msg_count
15936: , x_msg_data => l_msg_data
15937: , x_lot_rec => x_lot_rec