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 3434: l_insert := inv_trx_util_pub.insert_line_trx(

3430:
3431: IF l_debug = 1 THEN
3432: trace('Creating MMTT for Content LPN ID '||p_content_lpn_id);
3433: END IF;
3434: l_insert := inv_trx_util_pub.insert_line_trx(
3435: p_trx_hdr_id => null
3436: ,p_item_id => null
3437: ,p_org_id => p_organization_id
3438: ,p_trx_action_id => l_txn_action_id

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

3674: nvl(p_revision, '#$%') = nvl(l_cur_rec.revision, '#$%') AND
3675: nvl(p_lot_number, '#$%') = nvl(l_cur_rec.lot_number, '#$%')) THEN
3676:
3677: IF l_debug = 1 THEN
3678: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');
3679: trace(' p_trx_hdr_id => '||l_txn_hdr_id);
3680: trace(' p_item_id => '||p_inventory_item_id);
3681: trace(' p_revision => '||p_revision);
3682: trace(' p_org_id => '||p_organization_id);

Line 3702: l_insert := inv_trx_util_pub.insert_line_trx(

3698: trace(' p_secondary_trx_qty => '||l_mol_list(i).secondary_transaction_quantity);
3699: trace(' p_secondary_uom => '||l_mol_list(i).secondary_uom_code);
3700: END IF;
3701: -- Create new MMTT
3702: l_insert := inv_trx_util_pub.insert_line_trx(
3703: p_trx_hdr_id => l_txn_hdr_id
3704: ,p_item_id => p_inventory_item_id
3705: ,p_revision => p_revision
3706: ,p_org_id => p_organization_id

Line 3791: l_insert := inv_trx_util_pub.insert_lot_trx(

3787: trace(' p_trx_qty => '|| l_mol_list(i).transaction_quantity);
3788: trace(' p_pri_qty => '||l_mol_list(i).primary_quantity);
3789: trace(' No lot attributes are passed in');
3790: END IF;
3791: l_insert := inv_trx_util_pub.insert_lot_trx(
3792: p_trx_tmp_id => l_txn_tmp_id
3793: , p_user_id => fnd_global.user_id
3794: , p_lot_number => p_lot_number
3795: , p_exp_date => p_lot_expiration_date

Line 3824: l_insert := inv_trx_util_pub.insert_lot_trx(

3820: trace(' p_trx_qty => '|| l_mol_list(i).transaction_quantity);
3821: trace(' p_pri_qty => '||l_mol_list(i).primary_quantity);
3822: trace(' Lot attributes are passed in');
3823: END IF;
3824: l_insert := inv_trx_util_pub.insert_lot_trx(
3825: p_trx_tmp_id => l_txn_tmp_id
3826: , p_user_id => fnd_global.user_id
3827: , p_lot_number => p_lot_number
3828: , p_exp_date => p_lot_expiration_date

Line 3951: l_insert := inv_trx_util_pub.insert_ser_trx(

3947: END IF;
3948: -- Insert MSNT record
3949: IF g_lot_ser_attr.count = 0 THEN
3950: -- No serial attributes
3951: l_insert := inv_trx_util_pub.insert_ser_trx(
3952: p_trx_tmp_id => nvl(l_ser_txn_id,l_txn_tmp_id)
3953: , p_user_id => fnd_global.user_id
3954: , p_fm_ser_num => p_fm_serial_number
3955: , p_to_ser_num => p_fm_serial_number

Line 3970: l_insert := inv_trx_util_pub.insert_ser_trx(

3966: trace('MSNT record inserted for serial(no attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
3967: END IF;
3968: ELSE
3969: -- Has serial attributes
3970: l_insert := inv_trx_util_pub.insert_ser_trx(
3971: p_trx_tmp_id => nvl(l_ser_txn_id,l_txn_tmp_id)
3972: , p_user_id => fnd_global.user_id
3973: , p_fm_ser_num => p_fm_serial_number
3974: , p_to_ser_num => p_fm_serial_number

Line 4160: l_insert := inv_trx_util_pub.insert_ser_trx(

4156: END IF;
4157: -- Insert MSNT record
4158: IF g_lot_ser_attr.count = 0 THEN
4159: -- No serial attributes
4160: l_insert := inv_trx_util_pub.insert_ser_trx(
4161: p_trx_tmp_id => nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id)
4162: , p_user_id => fnd_global.user_id
4163: , p_fm_ser_num => p_fm_serial_number
4164: , p_to_ser_num => p_fm_serial_number

Line 4179: l_insert := inv_trx_util_pub.insert_ser_trx(

4175: trace('MSNT record inserted for serial(no attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4176: END IF;
4177: ELSE
4178: -- Has serial attributes
4179: l_insert := inv_trx_util_pub.insert_ser_trx(
4180: p_trx_tmp_id => nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id)
4181: , p_user_id => fnd_global.user_id
4182: , p_fm_ser_num => p_fm_serial_number
4183: , p_to_ser_num => p_fm_serial_number

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

4245: raise fnd_api.g_exc_error;
4246: END IF;
4247: trace('MSNT record inserted for serial(with attr):'||p_fm_serial_number||',ser_txn_id='||nvl(l_ser_txn_id,l_txn_tmp_id));
4248: END IF;
4249: /* l_insert := inv_trx_util_pub.insert_ser_trx(
4250: p_trx_tmp_id => nvl(l_cur_rec.serial_transaction_temp_id, p_transaction_temp_id)
4251: , p_user_id => fnd_global.user_id
4252: , p_fm_ser_num => p_fm_serial_number
4253: , p_to_ser_num => p_fm_serial_number

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

4405: IF p_content_lpn_id IS NOT NULL THEN
4406: -- Content is LPN
4407: -- Create new MMTT
4408: IF l_debug = 1 THEN
4409: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');
4410: trace(' p_trx_hdr_id => '||l_txn_hdr_id);
4411: trace(' p_item_id => null');
4412: trace(' p_org_id => '||p_organization_id);
4413: trace(' p_trx_action_id => '||l_txn_action_id);

Line 4429: l_insert := inv_trx_util_pub.insert_line_trx(

4425: trace(' p_xfr_lpn_id => '||p_to_lpn_id);
4426: trace(' p_user_id => '||fnd_global.user_id);
4427: END IF;
4428:
4429: l_insert := inv_trx_util_pub.insert_line_trx(
4430: p_trx_hdr_id => l_txn_hdr_id
4431: ,p_item_id => null
4432: ,p_org_id => p_organization_id
4433: ,p_trx_action_id => l_txn_action_id

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

4494: IF l_mmtt_exists = 0 THEN
4495: -- Create new MMTT
4496:
4497: IF l_debug = 1 THEN
4498: trace('Calling inv_trx_util_pub.insert_line_trx() to insert MMTT with ');
4499: trace(' p_trx_hdr_id => '||l_txn_hdr_id);
4500: trace(' p_item_id => '||p_inventory_item_id);
4501: trace(' p_revision => '||p_revision);
4502: trace(' p_org_id => '||p_organization_id);

Line 4520: l_insert := inv_trx_util_pub.insert_line_trx(

4516: trace(' p_secondary_uom => '||p_secondary_uom);
4517: trace(' p_user_id => '||fnd_global.user_id);
4518: trace(' p_grade_code => '||p_grade_code);
4519: END IF;
4520: l_insert := inv_trx_util_pub.insert_line_trx(
4521: p_trx_hdr_id => l_txn_hdr_id
4522: ,p_item_id => p_inventory_item_id
4523: ,p_revision => p_revision
4524: ,p_org_id => p_organization_id

Line 4586: l_insert := inv_trx_util_pub.insert_lot_trx(

4582:
4583: IF p_lot_number IS NOT NULL THEN
4584: -- Create MTLT
4585: -- Insert MTLT record
4586: l_insert := inv_trx_util_pub.insert_lot_trx(
4587: p_trx_tmp_id => l_txn_tmp_id
4588: , p_user_id => fnd_global.user_id
4589: , p_lot_number => p_lot_number
4590: , p_trx_qty => p_transaction_qty

Line 4614: l_insert := inv_trx_util_pub.insert_ser_trx(

4610:
4611: IF p_fm_serial_number IS NOT NULL THEN
4612: -- Create MSNT
4613: -- Insert MSNT record
4614: l_insert := inv_trx_util_pub.insert_ser_trx(
4615: p_trx_tmp_id => l_ser_txn_id
4616: , p_user_id => fnd_global.user_id
4617: , p_fm_ser_num => p_fm_serial_number
4618: , p_to_ser_num => nvl(p_to_serial_number, p_fm_serial_number)