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 1691: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE

1687: ELSE
1688: l_primary_quantity := p_transaction_quantity;
1689: END IF;
1690:
1691: l_lot_indiv_trx_valid := INV_LOT_API_PUB.VALIDATE_LOT_INDIVISIBLE
1692: ( p_api_version => 1.0
1693: , p_init_msg_list => fnd_api.g_false
1694: , p_transaction_type_id => p_transaction_type_id
1695: , p_organization_id => p_organization_id

Line 5706: l_attributes_tbl inv_lot_api_pub.char_tbl;

5702: FROM MTL_SERIAL_NUMBERS_INTERFACE
5703: WHERE TRANSACTION_INTERFACE_ID = interface_id;
5704:
5705: -- PL/SQL table to store lot attributes
5706: l_attributes_tbl inv_lot_api_pub.char_tbl;
5707: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
5708: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
5709: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
5710:

Line 5707: l_c_attributes_tbl inv_lot_api_pub.char_tbl;

5703: WHERE TRANSACTION_INTERFACE_ID = interface_id;
5704:
5705: -- PL/SQL table to store lot attributes
5706: l_attributes_tbl inv_lot_api_pub.char_tbl;
5707: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
5708: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
5709: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
5710:
5711: l_lot_exists NUMBER := 0;

Line 5708: l_n_attributes_tbl inv_lot_api_pub.number_tbl;

5704:
5705: -- PL/SQL table to store lot attributes
5706: l_attributes_tbl inv_lot_api_pub.char_tbl;
5707: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
5708: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
5709: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
5710:
5711: l_lot_exists NUMBER := 0;
5712: l_ret_number NUMBER := 0;

Line 5709: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

5705: -- PL/SQL table to store lot attributes
5706: l_attributes_tbl inv_lot_api_pub.char_tbl;
5707: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
5708: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
5709: l_d_attributes_tbl inv_lot_api_pub.date_tbl;
5710:
5711: l_lot_exists NUMBER := 0;
5712: l_ret_number NUMBER := 0;
5713: l_qty NUMBER := NULL;

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

5811: l_d_attributes_tbl(9) := rec_MTLI.D_ATTRIBUTE9;
5812: l_d_attributes_tbl(10) := rec_MTLI.D_ATTRIBUTE10;
5813:
5814: IF (l_debug=1) THEN
5815: inv_log_util.trace('Before call to inv_lot_api_pub.create_inv_lot', 'INV_TXN_MANAGER_GRP', 9);
5816: END IF;
5817:
5818: inv_lot_api_pub.create_inv_lot(
5819: x_return_status => x_return_status

Line 5818: inv_lot_api_pub.create_inv_lot(

5814: IF (l_debug=1) THEN
5815: inv_log_util.trace('Before call to inv_lot_api_pub.create_inv_lot', 'INV_TXN_MANAGER_GRP', 9);
5816: END IF;
5817:
5818: inv_lot_api_pub.create_inv_lot(
5819: x_return_status => x_return_status
5820: , x_msg_count => l_msg_count
5821: , x_msg_data => x_proc_msg
5822: , p_inventory_item_id => p_item_id

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

5857: , p_source => null
5858: );
5859:
5860: IF (l_debug=1) THEN
5861: inv_log_util.trace('After call to inv_lot_api_pub.create_inv_lot', 'INV_TXN_MANAGER_GRP', 9);
5862: inv_log_util.trace(' x_return_status : ' || x_return_status, 'INV_TXN_MANAGER_GRP', 9);
5863: END IF;
5864: END IF; -- End of Lot Exists check
5865:

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

5864: END IF; -- End of Lot Exists check
5865:
5866: IF (x_return_status = lg_ret_sts_success) THEN
5867: IF (l_debug=1) THEN
5868: inv_log_util.trace('Call to inv_lot_api_pub.create_inv_lot was successful','INV_TXN_MANAGER_GRP', 9);
5869: END IF;
5870: -- Looping through every serials in the lot
5871: FOR rec_MSNI IN cur_MSNI(rec_MTLI.SERIAL_TRANSACTION_TEMP_ID)
5872: LOOP

Line 5924: ELSE -- Failure from inv_lot_api_pub.create_inv_lot

5920: RETURN;
5921: END IF;
5922: END LOOP; -- End of cur_MSNI cursor
5923:
5924: ELSE -- Failure from inv_lot_api_pub.create_inv_lot
5925: x_return_status := lg_ret_sts_error;
5926: loaderrmsg('INV_INT_LOTCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
5927: IF (l_debug = 1) THEN
5928: inv_log_util.trace('Error from inv_lot_api_pub.create_inv_lot'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);

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

5924: ELSE -- Failure from inv_lot_api_pub.create_inv_lot
5925: x_return_status := lg_ret_sts_error;
5926: loaderrmsg('INV_INT_LOTCODE','INV_LOT_SERIAL_VALIDATION_FAIL');
5927: IF (l_debug = 1) THEN
5928: inv_log_util.trace('Error from inv_lot_api_pub.create_inv_lot'|| x_proc_msg || ':' || sqlerrm,'INV_TXN_MANAGER_GRP', 9);
5929: END IF;
5930: RETURN;
5931: END IF;
5932:

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

14970: inv_log_util.trace('Calling Inv_Lot_API_PKG.Set_Msi_Default_Attr (1) ' , 'INV_TXN_MANAGER_GRP', 9);
14971: END IF;
14972: -- dbms_output.put_line('Calling Inv_Lot_API_PKG.Set_Msi_Default_Attr (1 )');
14973: /* Default attributes for lot from item master */
14974: -- inv_lot_api_pub.Set_Msi_Default_Attr(p_lot_rec => l_lot_record);
14975:
14976: Inv_Lot_API_PKG.Set_Msi_Default_Attr ( p_lot_rec => l_lot_record
14977: , x_return_status => l_return_status
14978: , x_msg_count => l_msg_count