APPS.INV_TRX_UTIL_PUB dependencies on FND_PROFILE

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

80: v_acct_period_id NUMBER;
81: v_open_past_period BOOLEAN := FALSE;
82: v_trx_hdr_id NUMBER := p_trx_hdr_id;
83: v_item_id NUMBER := p_item_id;
84: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
85:
86: --8939057
87: l_api_name VARCHAR2(30) := 'INSERT_LINE_TRX';
88: x_transfer_price NUMBER;

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

543: l_n_attribute10 NUMBER := NULL;
544: l_vendor_id VARCHAR(250) := NULL;
545: l_territory_code VARCHAR(250) := NULL;
546: -- Bug# 2032659 End
547: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
548:
549: --Bug No 3952081
550: --Add variables to hold existent OPM attributes of the lot
551: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;

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

1012: l_err_code NUMBER;
1013: l_trx_type_id NUMBER;
1014: l_subinventory_code VARCHAR2(10);
1015: l_locator_id NUMBER;
1016: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1017: BEGIN
1018: /*Fixed Bug#6758460 regardless of validation level
1019: txn temp id should be validated and serial number should be marked
1020: If customer does not pass validation leverl as full then this API

Line 1390: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

1386: , p_serial_allocated_flag IN VARCHAR2
1387: , p_operation_plan_id IN NUMBER --lezhang
1388: , p_transaction_status IN NUMBER
1389: ) IS
1390: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1391: l_api_name VARCHAR2(30) := 'COPY_INSERT_LINE_TRX';
1392: l_acct_period_id NUMBER;
1393: l_open_past_period BOOLEAN;
1394: l_transaction_date DATE;

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

1965: , p_user_id IN NUMBER
1966: , x_proc_msg OUT NOCOPY VARCHAR2
1967: )
1968: RETURN NUMBER IS
1969: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1970: BEGIN
1971: DELETE FROM mtl_serial_numbers_temp
1972: WHERE transaction_temp_id = NVL(p_serial_trx_tmp_id, p_trx_tmp_id);
1973:

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

2021: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2022: AND msi.inventory_item_id = mmtt.inventory_item_id
2023: AND msi.organization_id = mmtt.organization_id;
2024:
2025: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2026: BEGIN
2027: x_return_status := fnd_api.g_ret_sts_success;
2028:
2029: IF l_debug = 1 THEN

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

2259: , p_child_line_id IN NUMBER
2260: , p_lot_control_code IN NUMBER
2261: , p_serial_control_code IN NUMBER
2262: ) IS
2263: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2264:
2265: l_api_return_status VARCHAR2(1);
2266: l_item_id NUMBER;
2267: l_child_pri_qty NUMBER;

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

2461: p_trx_header_id IN NUMBER
2462: ) IS
2463:
2464: PRAGMA AUTONOMOUS_TRANSACTION;
2465: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2466: l_group_id NUMBER;
2467: l_rpc_timeout NUMBER := 172800;
2468: l_count NUMBER;
2469: