DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on FND_GLOBAL

Line 1804: if fnd_global.user_id = 1005653 THEN --SATKUMAR

1800:
1801: END IF;--p_is_pjm_enabled_org
1802:
1803: /*
1804: if fnd_global.user_id = 1005653 THEN --SATKUMAR
1805: insert into wms_packing_material_temp value (select * from wms_packing_material_gtemp);
1806: commit;
1807: end if;
1808: */

Line 3454: ,p_user_id => fnd_global.user_id

3450: ,p_xfr_lpn_id => p_to_lpn_id
3451: ,p_posting_flag => 'N' -- Set this so that locator capacity calculation will not consider this
3452: ,p_move_order_line_id => null
3453: ,p_process_flag => 'N' -- Set process_flag to 'N' so that INV TM will not process this MMTT
3454: ,p_user_id => fnd_global.user_id
3455: ,x_trx_tmp_id => l_txn_tmp_id
3456: ,x_proc_msg => l_proc_msg
3457: ,p_secondary_trx_qty => CASE WHEN p_secondary_uom IS NOT NULL THEN 0 ELSE NULL END --INVCONV kkillams
3458: ,p_secondary_uom => nvl(p_secondary_uom, ' ') --INVCONV kkillams

Line 3697: trace(' p_user_id => '||fnd_global.user_id);

3693: trace(' p_from_lpn_id => '||p_from_lpn_id);
3694: trace(' p_xfr_lpn_id => '||p_to_lpn_id);
3695: trace(' p_posting_flag => N');
3696: trace(' p_move_order_line_id => '||l_mol_list(i).move_order_line_id);
3697: trace(' p_user_id => '||fnd_global.user_id);
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

Line 3724: ,p_user_id => fnd_global.user_id

3720: ,p_xfr_lpn_id => p_to_lpn_id
3721: ,p_posting_flag => 'N' -- Set this so that locator capacity calculation will not consider this
3722: ,p_process_flag => 'N' -- Set process_flag to 'N' so that INV TM will not process this MMTT record
3723: ,p_move_order_line_id => l_mol_list(i).move_order_line_id
3724: ,p_user_id => fnd_global.user_id
3725: ,x_trx_tmp_id => l_txn_tmp_id
3726: ,x_proc_msg => l_proc_msg
3727: );
3728:

Line 3793: , p_user_id => fnd_global.user_id

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
3796: , p_trx_qty => l_mol_list(i).transaction_quantity
3797: , p_pri_qty => l_mol_list(i).primary_quantity

Line 3826: , p_user_id => fnd_global.user_id

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
3829: , p_trx_qty => l_mol_list(i).transaction_quantity
3830: , p_pri_qty => l_mol_list(i).primary_quantity

Line 3953: , p_user_id => fnd_global.user_id

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
3956: , x_proc_msg => l_proc_msg
3957: );

Line 3972: , p_user_id => fnd_global.user_id

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
3975: , x_proc_msg => l_proc_msg
3976: , p_time_since_new =>to_number(get_column_default_value('TIME_SINCE_NEW'))

Line 4162: , p_user_id => fnd_global.user_id

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
4165: , x_proc_msg => l_proc_msg
4166: );

Line 4181: , p_user_id => fnd_global.user_id

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
4184: , x_proc_msg => l_proc_msg
4185: , p_time_since_new =>to_number(get_column_default_value('TIME_SINCE_NEW'))

Line 4251: , p_user_id => fnd_global.user_id

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
4254: , x_proc_msg => l_proc_msg
4255: );

Line 4426: trace(' p_user_id => '||fnd_global.user_id);

4422: trace(' p_tolocator_id => '||l_to_loc_id);
4423: trace(' p_from_lpn_id => '||p_from_lpn_id);
4424: trace(' p_cnt_lpn_id => '||p_content_lpn_id);
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

Line 4449: ,p_user_id => fnd_global.user_id

4445: ,p_tolocator_id => l_to_loc_id
4446: ,p_from_lpn_id => p_from_lpn_id
4447: ,p_cnt_lpn_id => p_content_lpn_id
4448: ,p_xfr_lpn_id => p_to_lpn_id
4449: ,p_user_id => fnd_global.user_id
4450: ,x_trx_tmp_id => l_txn_tmp_id
4451: ,x_proc_msg => l_proc_msg);
4452:
4453: IF l_debug = 1 THEN

Line 4517: trace(' p_user_id => '||fnd_global.user_id);

4513: trace(' p_from_lpn_id => '||p_from_lpn_id);
4514: trace(' p_xfr_lpn_id => '||p_to_lpn_id);
4515: trace(' p_secondary_trx_qty => '||p_secondary_qty);
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

Line 4538: ,p_user_id => fnd_global.user_id

4534: ,p_locator_id => p_locator_id
4535: ,p_tolocator_id => l_to_loc_id
4536: ,p_from_lpn_id => p_from_lpn_id
4537: ,p_xfr_lpn_id => p_to_lpn_id
4538: ,p_user_id => fnd_global.user_id
4539: ,p_secondary_trx_qty => p_secondary_qty
4540: ,p_secondary_uom => p_secondary_uom
4541: ,x_trx_tmp_id => l_txn_tmp_id
4542: ,x_proc_msg => l_proc_msg);

Line 4588: , p_user_id => fnd_global.user_id

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
4591: , p_pri_qty => p_primary_qty
4592: , p_secondary_qty => p_secondary_qty

Line 4616: , p_user_id => fnd_global.user_id

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)
4619: , x_proc_msg => l_proc_msg
4620: );