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_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: BEGIN
199: SELECT mtl_material_transactions_s.NEXTVAL
200: INTO x_trxtempid

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

461: retval NUMBER;
462: l_exp_date DATE;
463: l_primary_uom VARCHAR2(3);
464: l_primary_qty NUMBER;
465: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
466: BEGIN
467: -- retrieve the expiration-date for the lot number
468: -- being inserted
469: BEGIN

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

531: *******************************************************************/
532: FUNCTION insert_ser_trx(p_ser_number VARCHAR2, p_sertrxid NUMBER)
533: RETURN NUMBER IS
534: retval NUMBER;
535: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
536: BEGIN
537: retval :=
538: inv_trx_util_pub.insert_ser_trx(p_trx_tmp_id => p_sertrxid, p_user_id => 1, p_fm_ser_num => p_ser_number
539: , p_to_ser_num => p_ser_number, x_proc_msg => ret_msgdata);

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

614: l_lpn_subinv VARCHAR2(32) := p_mmtt.subinventory_code;
615: l_lpn_locator_id NUMBER := p_mmtt.locator_id;
616: l_cst_grp_id NUMBER;
617: l_xfr_cst_grp_id NUMBER;
618: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
619: /* Bug 2712046, add cost group comingle check if the transfer location is non-LPN controlled
620: new variable to check LPN controlled flag of the transfer subinventory */
621: l_skip_comingle_check NUMBER := 0;
622: --l_lpn_controlled_flag number := 0;

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

1304: l_intransit_inv_account NUMBER;
1305: l_transfer_transaction_id NUMBER;
1306: l_shipment_line_id NUMBER;
1307: l_mmt_transaction_id NUMBER;
1308: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1309: BEGIN
1310: x_return_status := fnd_api.g_ret_sts_success;
1311:
1312: IF (l_debug = 1) THEN

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

1489: , serial_transaction_temp_id
1490: FROM mtl_transaction_lots_temp
1491: WHERE transaction_temp_id = p_tempid;
1492:
1493: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1494: BEGIN
1495: IF ( p_operation = g_unpack AND p_content_lpn IS NULL
1496: AND ( (p_source_type_id = inv_globals.g_sourcetype_purchaseorder AND p_trx_action = inv_globals.g_action_receipt)
1497: OR (p_source_type_id = inv_globals.g_sourcetype_rma AND p_trx_action = inv_globals.g_action_receipt)

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

1970: /********************************************************************
1971: * Update the status of the LPN
1972: *******************************************************************/
1973: PROCEDURE update_lpn_status(v_lpn wms_container_pub.lpn) IS
1974: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1975: BEGIN
1976: WMS_Container_PVT.Modify_LPN (
1977: p_api_version => 1.0
1978: , p_init_msg_list => fnd_api.g_true

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

2002: *******************************************************************/
2003: PROCEDURE copy_msnt(p_source_row_id ROWID, p_new_sertrxid NUMBER, p_new_fm_serial VARCHAR2, p_new_to_serial VARCHAR2) IS
2004: l_api_name CONSTANT VARCHAR2(30) := 'COPY_MSNT';
2005: l_api_version CONSTANT NUMBER := 1.0;
2006: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2007: l_sertmp_rec mtl_serial_numbers_temp%ROWTYPE;
2008: BEGIN
2009: IF (l_debug = 1) THEN
2010: inv_log_util.TRACE('Call to Copy_MSNT rowid=' || p_source_row_id, 'INV_LPN_TRX_PUB', 9);

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

2207: , p_transaction_source_id NUMBER := NULL
2208: , p_trx_source_line_id NUMBER := NULL
2209: ) IS
2210: l_api_name CONSTANT VARCHAR2(30) := 'Split_Delivery_Details';
2211: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2212: l_progress VARCHAR2(500) := '0';
2213:
2214: -- Vaiables for call to Update_Shipping_Attributes
2215: l_shipping_attr wsh_interface.changedattributetabtype;

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

2995: , p_trx_source_line_id NUMBER := NULL
2996: ) IS
2997: l_api_name CONSTANT VARCHAR2(30) := 'Split_Delivery';
2998: l_api_version CONSTANT NUMBER := 1.0;
2999: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3000: l_progress VARCHAR2(10) := '0';
3001: l_lotfound BOOLEAN := FALSE;
3002: l_prev_lot VARCHAR2(30) := -999;
3003: l_secondary_trx_quantity NUMBER := p_secondary_trx_quantity;

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

3462: --fob enhencement for J
3463: l_fob_ret_sts VARCHAR2(1);
3464: l_fob_ret_msg VARCHAR2(2000);
3465: l_fob_msg_count NUMBER;
3466: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3467: -- Nested lpn changes
3468: l_putway_explode_req VARCHAR2(1) := 'N';
3469: -- HVERDDIN ERES START
3470: l_erecord_id NUMBER;

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

3468: l_putway_explode_req VARCHAR2(1) := 'N';
3469: -- HVERDDIN ERES START
3470: l_erecord_id NUMBER;
3471: l_trans_status VARCHAR2(30) := 'SUCCESS';
3472: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');
3473: tbl_index BINARY_INTEGER := 1;
3474: l_eres_tbl eres_tbl;
3475: -- HVERDDIN ERES END
3476: l_process NUMBER := 0;

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

3540: SAVEPOINT process_lpn_trx;
3541:
3542: -- If l_proc_mode is not filled, then check mode from profile
3543: IF (l_proc_mode IS NULL) THEN
3544: l_proc_mode := fnd_profile.VALUE('TRANSACTION_PROCESS_MODE');
3545:
3546: IF (l_debug = 1) THEN
3547: inv_log_util.TRACE('TRANSACTION_PROCESS_MODE for ProcMode= ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3548: END IF;

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

3874: IF (
3875: (v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_inventory)
3876: AND(v_mmtt.transaction_action_id = inv_globals.g_action_subxfr)
3877: ) THEN
3878: l_proc_mode := fnd_profile.VALUE('SUBINV_TRANS_TXN');
3879:
3880: IF (l_debug = 1) THEN
3881: inv_log_util.TRACE('Using SUBINV_TRANS_TXN to set process_mode. ProcMode=' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3882: END IF;

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

3889: (v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3890: OR(v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
3891: )
3892: ) THEN
3893: l_proc_mode := fnd_profile.VALUE('ACCOUNT_ISSUE_TXN');
3894:
3895: IF (l_debug = 1) THEN
3896: inv_log_util.TRACE('Using ACCOUNT_ISSUE_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3897: END IF;

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

3901: (v_mmtt.transaction_action_id = inv_globals.g_action_receipt)
3902: OR(v_mmtt.transaction_action_id = inv_globals.g_action_issue)
3903: )
3904: ) THEN
3905: l_proc_mode := fnd_profile.VALUE('TRANSFER_ORDER_TXN');
3906:
3907: IF (l_debug = 1) THEN
3908: inv_log_util.TRACE('Using TRANSFER_ORDER_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3909: END IF;

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

3913: (v_mmtt.transaction_action_id = inv_globals.g_action_orgxfr)
3914: OR(v_mmtt.transaction_action_id = inv_globals.g_action_intransitshipment)
3915: )
3916: ) THEN
3917: l_proc_mode := fnd_profile.VALUE('INTER_ORG_SHIP_TXN');
3918:
3919: IF (l_debug = 1) THEN
3920: inv_log_util.TRACE('Using INTER_ORG_SHIP_TXN to set process_mode. ProcMode = ' || l_proc_mode, 'INV_LPN_TRX_PUB', 9);
3921: END IF;

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

4769: , p_source_transaction_id IN NUMBER := NULL
4770: ) IS
4771: l_api_name CONSTANT VARCHAR2(30) := 'Process_LPN_Trx_Line';
4772: l_api_version CONSTANT NUMBER := 1.0;
4773: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4774: l_progress VARCHAR2(500) := '0';
4775: l_msgdata VARCHAR2(1000);
4776: l_item_rec inv_validate.item;
4777: v_lpn wms_container_pub.lpn;

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

4793: l_ret_bool BOOLEAN;
4794: --Start of fix for Bug 4891916
4795: --Added the following variables to check for the profile value and
4796: --to pass the transaction_identifer to the label label printing api
4797: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);
4798: l_transaction_identifier NUMBER := NULL ;
4799: --End of fix for Bug 4891916
4800:
4801: l_cyclpn_id NUMBER := NULL; --Bug#6043776