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.WMS_PACKING_WORKBENCH_PVT dependencies on INV_TRX_UTIL_PUB

Line 3268: l_insert := inv_trx_util_pub.insert_line_trx(

3264:
3265: IF l_debug = 1 THEN
3266: trace('Creating MMTT for Content LPN ID '||p_content_lpn_id);
3267: END IF;
3268: l_insert := inv_trx_util_pub.insert_line_trx(
3269: p_trx_hdr_id => null
3270: ,p_item_id => null
3271: ,p_org_id => p_organization_id
3272: ,p_trx_action_id => l_txn_action_id

Line 3512: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');

3508: nvl(p_revision, '#$%') = nvl(l_cur_rec.revision, '#$%') AND
3509: nvl(p_lot_number, '#$%') = nvl(l_cur_rec.lot_number, '#$%')) THEN
3510:
3511: IF l_debug = 1 THEN
3512: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');
3513: trace(' p_trx_hdr_id => '||l_txn_hdr_id);
3514: trace(' p_item_id => '||p_inventory_item_id);
3515: trace(' p_revision => '||p_revision);
3516: trace(' p_org_id => '||p_organization_id);

Line 3536: l_insert := inv_trx_util_pub.insert_line_trx(

3532: trace(' p_secondary_trx_qty => '||l_mol_list(i).secondary_transaction_quantity);
3533: trace(' p_secondary_uom => '||l_mol_list(i).secondary_uom_code);
3534: END IF;
3535: -- Create new MMTT
3536: l_insert := inv_trx_util_pub.insert_line_trx(
3537: p_trx_hdr_id => l_txn_hdr_id
3538: ,p_item_id => p_inventory_item_id
3539: ,p_revision => p_revision
3540: ,p_org_id => p_organization_id

Line 3625: l_insert := inv_trx_util_pub.insert_lot_trx(

3621: trace(' p_trx_qty => '|| l_mol_list(i).transaction_quantity);
3622: trace(' p_pri_qty => '||l_mol_list(i).primary_quantity);
3623: trace(' No lot attributes are passed in');
3624: END IF;
3625: l_insert := inv_trx_util_pub.insert_lot_trx(
3626: p_trx_tmp_id => l_txn_tmp_id
3627: , p_user_id => fnd_global.user_id
3628: , p_lot_number => p_lot_number
3629: , p_exp_date => p_lot_expiration_date

Line 3658: l_insert := inv_trx_util_pub.insert_lot_trx(

3654: trace(' p_trx_qty => '|| l_mol_list(i).transaction_quantity);
3655: trace(' p_pri_qty => '||l_mol_list(i).primary_quantity);
3656: trace(' Lot attributes are passed in');
3657: END IF;
3658: l_insert := inv_trx_util_pub.insert_lot_trx(
3659: p_trx_tmp_id => l_txn_tmp_id
3660: , p_user_id => fnd_global.user_id
3661: , p_lot_number => p_lot_number
3662: , p_exp_date => p_lot_expiration_date

Line 3785: l_insert := inv_trx_util_pub.insert_ser_trx(

3781: END IF;
3782: -- Insert MSNT record
3783: IF g_lot_ser_attr.count = 0 THEN
3784: -- No serial attributes
3785: l_insert := inv_trx_util_pub.insert_ser_trx(
3786: p_trx_tmp_id => nvl(l_ser_txn_id,l_txn_tmp_id)
3787: , p_user_id => fnd_global.user_id
3788: , p_fm_ser_num => p_fm_serial_number
3789: , p_to_ser_num => p_fm_serial_number

Line 3804: l_insert := inv_trx_util_pub.insert_ser_trx(

3800: trace('MSNT record inserted for serial(no attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
3801: END IF;
3802: ELSE
3803: -- Has serial attributes
3804: l_insert := inv_trx_util_pub.insert_ser_trx(
3805: p_trx_tmp_id => nvl(l_ser_txn_id,l_txn_tmp_id)
3806: , p_user_id => fnd_global.user_id
3807: , p_fm_ser_num => p_fm_serial_number
3808: , p_to_ser_num => p_fm_serial_number

Line 3994: l_insert := inv_trx_util_pub.insert_ser_trx(

3990: END IF;
3991: -- Insert MSNT record
3992: IF g_lot_ser_attr.count = 0 THEN
3993: -- No serial attributes
3994: l_insert := inv_trx_util_pub.insert_ser_trx(
3995: p_trx_tmp_id => nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id)
3996: , p_user_id => fnd_global.user_id
3997: , p_fm_ser_num => p_fm_serial_number
3998: , p_to_ser_num => p_fm_serial_number

Line 4013: l_insert := inv_trx_util_pub.insert_ser_trx(

4009: trace('MSNT record inserted for serial(no attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4010: END IF;
4011: ELSE
4012: -- Has serial attributes
4013: l_insert := inv_trx_util_pub.insert_ser_trx(
4014: p_trx_tmp_id => nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id)
4015: , p_user_id => fnd_global.user_id
4016: , p_fm_ser_num => p_fm_serial_number
4017: , p_to_ser_num => p_fm_serial_number

Line 4083: /* l_insert := inv_trx_util_pub.insert_ser_trx(

4079: raise fnd_api.g_exc_error;
4080: END IF;
4081: trace('MSNT record inserted for serial(with attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4082: END IF;
4083: /* l_insert := inv_trx_util_pub.insert_ser_trx(
4084: p_trx_tmp_id => nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id)
4085: , p_user_id => fnd_global.user_id
4086: , p_fm_ser_num => p_fm_serial_number
4087: , p_to_ser_num => p_fm_serial_number

Line 4243: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');

4239: IF p_content_lpn_id IS NOT NULL THEN
4240: -- Content is LPN
4241: -- Create new MMTT
4242: IF l_debug = 1 THEN
4243: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');
4244: trace(' p_trx_hdr_id => '||l_txn_hdr_id);
4245: trace(' p_item_id => null');
4246: trace(' p_org_id => '||p_organization_id);
4247: trace(' p_trx_action_id => '||l_txn_action_id);

Line 4263: l_insert := inv_trx_util_pub.insert_line_trx(

4259: trace(' p_xfr_lpn_id => '||p_to_lpn_id);
4260: trace(' p_user_id => '||fnd_global.user_id);
4261: END IF;
4262:
4263: l_insert := inv_trx_util_pub.insert_line_trx(
4264: p_trx_hdr_id => l_txn_hdr_id
4265: ,p_item_id => null
4266: ,p_org_id => p_organization_id
4267: ,p_trx_action_id => l_txn_action_id

Line 4332: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');

4328: IF l_mmtt_exists = 0 THEN
4329: -- Create new MMTT
4330:
4331: IF l_debug = 1 THEN
4332: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');
4333: trace(' p_trx_hdr_id => '||l_txn_hdr_id);
4334: trace(' p_item_id => '||p_inventory_item_id);
4335: trace(' p_revision => '||p_revision);
4336: trace(' p_org_id => '||p_organization_id);

Line 4354: l_insert := inv_trx_util_pub.insert_line_trx(

4350: trace(' p_secondary_uom => '||p_secondary_uom);
4351: trace(' p_user_id => '||fnd_global.user_id);
4352: trace(' p_grade_code => '||p_grade_code);
4353: END IF;
4354: l_insert := inv_trx_util_pub.insert_line_trx(
4355: p_trx_hdr_id => l_txn_hdr_id
4356: ,p_item_id => p_inventory_item_id
4357: ,p_revision => p_revision
4358: ,p_org_id => p_organization_id

Line 4420: l_insert := inv_trx_util_pub.insert_lot_trx(

4416:
4417: IF p_lot_number IS NOT NULL THEN
4418: -- Create MTLT
4419: -- Insert MTLT record
4420: l_insert := inv_trx_util_pub.insert_lot_trx(
4421: p_trx_tmp_id => l_txn_tmp_id
4422: , p_user_id => fnd_global.user_id
4423: , p_lot_number => p_lot_number
4424: , p_trx_qty => p_transaction_qty

Line 4448: l_insert := inv_trx_util_pub.insert_ser_trx(

4444:
4445: IF p_fm_serial_number IS NOT NULL THEN
4446: -- Create MSNT
4447: -- Insert MSNT record
4448: l_insert := inv_trx_util_pub.insert_ser_trx(
4449: p_trx_tmp_id => l_ser_txn_id
4450: , p_user_id => fnd_global.user_id
4451: , p_fm_ser_num => p_fm_serial_number
4452: , p_to_ser_num => nvl(p_to_serial_number, p_fm_serial_number)