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.

[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on FND_PROFILE

Line 54: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

50: -- Created H.Verdding - Added to support ERES FDA requirements.
51: ******************************************************************************************************************/
52: FUNCTION trans_eres_enabled(p_trans_action_id IN NUMBER, p_trans_source_type_id IN NUMBER)
53: RETURN BOOLEAN IS
54: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
55: BEGIN
56: IF (l_debug = 1) THEN
57: inv_log_util.TRACE('** Trans Eres Enabled trx_action_id = ' || p_trans_action_id, 'INV_LPN_TRX_PUB', 9);
58: inv_log_util.TRACE('** Trans Eres Enabled trx_soource_id =' || p_trans_source_type_id, 'INV_LPN_TRX_PUB', 9);

Line 140: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

136: l_errCode VARCHAR2(1);
137: l_errMsg VARCHAR2(241);
138: l_cst_ret NUMBER(1):=0;
139: l_primary_cost_method NUMBER;
140: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
141: BEGIN
142: select primary_cost_method
143: into l_primary_cost_method
144: from mtl_parameters

Line 196: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

192: ) IS
193: l_cst_grp_id NUMBER;
194: l_xfr_cst_grp_id NUMBER := v_cost_group_id;
195: l_temp_uom_code VARCHAR(3);
196: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
197: l_sign NUMBER := 1; --Added bug3984746
198:
199: --Bug 10158934
200: l_api_name VARCHAR2(30) := 'INSERT_LINE_TRX';

Line 631: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

627: retval NUMBER;
628: l_exp_date DATE;
629: l_primary_uom VARCHAR2(3);
630: l_primary_qty NUMBER;
631: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
632: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL; --12949776
633: BEGIN
634: -- retrieve the expiration-date for the lot number
635: -- being inserted

Line 724: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

720: *******************************************************************/
721: FUNCTION insert_ser_trx(p_ser_number VARCHAR2, p_sertrxid NUMBER)
722: RETURN NUMBER IS
723: retval NUMBER;
724: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
725: BEGIN
726: retval :=
727: inv_trx_util_pub.insert_ser_trx(p_trx_tmp_id => p_sertrxid, p_user_id => 1, p_fm_ser_num => p_ser_number
728: , p_to_ser_num => p_ser_number, x_proc_msg => ret_msgdata);

Line 811: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

807: l_lpn_subinv VARCHAR2(32) := p_mmtt.subinventory_code;
808: l_lpn_locator_id NUMBER := p_mmtt.locator_id;
809: l_cst_grp_id NUMBER;
810: l_xfr_cst_grp_id NUMBER;
811: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
812: /* Bug 2712046, add cost group comingle check if the transfer location is non-LPN controlled
813: new variable to check LPN controlled flag of the transfer subinventory */
814: l_skip_comingle_check NUMBER := 0;
815: --l_lpn_controlled_flag number := 0;

Line 1525: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1521: l_intransit_inv_account NUMBER;
1522: l_transfer_transaction_id NUMBER;
1523: l_shipment_line_id NUMBER;
1524: l_mmt_transaction_id NUMBER;
1525: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1526: BEGIN
1527: x_return_status := fnd_api.g_ret_sts_success;
1528:
1529: IF (l_debug = 1) THEN

Line 1710: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1706: , serial_transaction_temp_id
1707: FROM mtl_transaction_lots_temp
1708: WHERE transaction_temp_id = p_tempid;
1709:
1710: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1711: BEGIN
1712: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1713: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1714: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)

Line 2191: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2187: /********************************************************************
2188: * Update the status of the LPN
2189: *******************************************************************/
2190: PROCEDURE update_lpn_status(v_lpn wms_container_pub.lpn) IS
2191: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2192: BEGIN
2193: WMS_Container_PVT.Modify_LPN (
2194: p_api_version => 1.0
2195: , p_init_msg_list => fnd_api.g_true

Line 2223: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2219: *******************************************************************/
2220: PROCEDURE copy_msnt(p_source_row_id ROWID, p_new_sertrxid NUMBER, p_new_fm_serial VARCHAR2, p_new_to_serial VARCHAR2) IS
2221: l_api_name CONSTANT VARCHAR2(30) := 'COPY_MSNT';
2222: l_api_version CONSTANT NUMBER := 1.0;
2223: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2224: l_sertmp_rec mtl_serial_numbers_temp%ROWTYPE;
2225: BEGIN
2226: IF (l_debug = 1) THEN
2227: inv_log_util.TRACE('Call to Copy_MSNT rowid=' || p_source_row_id, 'INV_LPN_TRX_PUB', 9);

Line 2428: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

2424: , p_transaction_source_id NUMBER := NULL
2425: , p_trx_source_line_id NUMBER := NULL
2426: ) IS
2427: l_api_name CONSTANT VARCHAR2(30) := 'Split_Delivery_Details';
2428: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2429: l_progress VARCHAR2(500) := '0';
2430:
2431: -- Vaiables for call to Update_Shipping_Attributes
2432: l_shipping_attr wsh_interface.changedattributetabtype;

Line 3261: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3257: , p_trx_source_line_id NUMBER := NULL
3258: ) IS
3259: l_api_name CONSTANT VARCHAR2(30) := 'Split_Delivery';
3260: l_api_version CONSTANT NUMBER := 1.0;
3261: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3262: l_progress VARCHAR2(10) := '0';
3263: l_lotfound BOOLEAN := FALSE;
3264: l_prev_lot VARCHAR2(30) := -999;
3265: l_secondary_trx_quantity NUMBER := p_secondary_trx_quantity;

Line 3744: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

3740: --fob enhencement for J
3741: l_fob_ret_sts VARCHAR2(1);
3742: l_fob_ret_msg VARCHAR2(2000);
3743: l_fob_msg_count NUMBER;
3744: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3745: -- Nested lpn changes
3746: l_putway_explode_req VARCHAR2(1) := 'N';
3747: -- HVERDDIN ERES START
3748: l_erecord_id NUMBER;

Line 3750: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');

3746: l_putway_explode_req VARCHAR2(1) := 'N';
3747: -- HVERDDIN ERES START
3748: l_erecord_id NUMBER;
3749: l_trans_status VARCHAR2(30) := 'SUCCESS';
3750: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');
3751: tbl_index BINARY_INTEGER := 1;
3752: l_eres_tbl eres_tbl;
3753: -- HVERDDIN ERES END
3754: l_process NUMBER := 0;

Line 3831: l_proc_mode := fnd_profile.VALUE('TRANSACTION_PROCESS_MODE');

3827: SAVEPOINT process_lpn_trx;
3828:
3829: -- If l_proc_mode is not filled, then check mode from profile
3830: IF (l_proc_mode IS NULL) THEN
3831: l_proc_mode := fnd_profile.VALUE('TRANSACTION_PROCESS_MODE');
3832:
3833: IF (l_debug = 1) THEN
3834: inv_log_util.TRACE('TRANSACTION_PROCESS_MODE for ProcMode= ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3835: END IF;

Line 4165: l_proc_mode := fnd_profile.VALUE('SUBINV_TRANS_TXN');

4161: IF (
4162: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
4163: AND(v_mmtt.transaction_action_id = inv_globals.g_action_subxfr)
4164: ) THEN
4165: l_proc_mode := fnd_profile.VALUE('SUBINV_TRANS_TXN');
4166:
4167: IF (l_debug = 1) THEN
4168: inv_log_util.TRACE('Using SUBINV_TRANS_TXN to set process_mode. ProcMode=' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
4169: END IF;

Line 4180: l_proc_mode := fnd_profile.VALUE('ACCOUNT_ISSUE_TXN');

4176: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4177: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
4178: )
4179: ) THEN
4180: l_proc_mode := fnd_profile.VALUE('ACCOUNT_ISSUE_TXN');
4181:
4182: IF (l_debug = 1) THEN
4183: inv_log_util.TRACE('Using ACCOUNT_ISSUE_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
4184: END IF;

Line 4192: l_proc_mode := fnd_profile.VALUE('TRANSFER_ORDER_TXN');

4188: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
4189: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)
4190: )
4191: ) THEN
4192: l_proc_mode := fnd_profile.VALUE('TRANSFER_ORDER_TXN');
4193:
4194: IF (l_debug = 1) THEN
4195: inv_log_util.TRACE('Using TRANSFER_ORDER_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
4196: END IF;

Line 4204: l_proc_mode := fnd_profile.VALUE('INTER_ORG_SHIP_TXN');

4200: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
4201: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
4202: )
4203: ) THEN
4204: l_proc_mode := fnd_profile.VALUE('INTER_ORG_SHIP_TXN');
4205:
4206: IF (l_debug = 1) THEN
4207: inv_log_util.TRACE('Using INTER_ORG_SHIP_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
4208: END IF;

Line 4732: last_updated_by = FND_PROFILE.VALUE('USER_ID'),

4728: inv_log_util.TRACE('Update WHO Columns for allocation type.','INV_LPN_TRX_PUB', 1);
4729: END IF;
4730: update mtl_material_transactions_temp
4731: set last_update_date = SYSDATE,
4732: last_updated_by = FND_PROFILE.VALUE('USER_ID'),
4733: last_update_login = FND_PROFILE.VALUE('LOGIN_ID'),
4734: CREATED_BY = FND_PROFILE.VALUE('USER_ID')
4735: where transaction_temp_id = v_mmtt.transaction_temp_id;
4736: END IF; --Bug15837987 End

Line 4733: last_update_login = FND_PROFILE.VALUE('LOGIN_ID'),

4729: END IF;
4730: update mtl_material_transactions_temp
4731: set last_update_date = SYSDATE,
4732: last_updated_by = FND_PROFILE.VALUE('USER_ID'),
4733: last_update_login = FND_PROFILE.VALUE('LOGIN_ID'),
4734: CREATED_BY = FND_PROFILE.VALUE('USER_ID')
4735: where transaction_temp_id = v_mmtt.transaction_temp_id;
4736: END IF; --Bug15837987 End
4737:

Line 4734: CREATED_BY = FND_PROFILE.VALUE('USER_ID')

4730: update mtl_material_transactions_temp
4731: set last_update_date = SYSDATE,
4732: last_updated_by = FND_PROFILE.VALUE('USER_ID'),
4733: last_update_login = FND_PROFILE.VALUE('LOGIN_ID'),
4734: CREATED_BY = FND_PROFILE.VALUE('USER_ID')
4735: where transaction_temp_id = v_mmtt.transaction_temp_id;
4736: END IF; --Bug15837987 End
4737:
4738: IF (l_debug = 1) THEN

Line 5273: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

5269: , p_source_transaction_id IN NUMBER := NULL
5270: ) IS
5271: l_api_name CONSTANT VARCHAR2(30) := 'Process_LPN_Trx_Line';
5272: l_api_version CONSTANT NUMBER := 1.0;
5273: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5274: l_progress VARCHAR2(500) := '0';
5275: l_msgdata VARCHAR2(1000);
5276: l_item_rec inv_validate.item;
5277: v_lpn wms_container_pub.lpn;

Line 5297: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);

5293: l_ret_bool BOOLEAN;
5294: --Start of fix for Bug 4891916
5295: --Added the following variables to check for the profile value and
5296: --to pass the transaction_identifer to the label label printing api
5297: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);
5298: l_transaction_identifier NUMBER := NULL ;
5299: --End of fix for Bug 4891916
5300:
5301: l_cyclpn_id NUMBER := NULL; --Bug#6043776