APPS.INV_TRX_UTIL_PUB dependencies on FND_PROFILE

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

79: v_acct_period_id NUMBER;
80: v_open_past_period BOOLEAN := FALSE;
81: v_trx_hdr_id NUMBER := p_trx_hdr_id;
82: v_item_id NUMBER := p_item_id;
83: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
84: BEGIN
85: -- get the account period ID
86: invttmtx.tdatechk(p_org_id, p_date, v_acct_period_id, v_open_past_period);
87:

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

415: l_n_attribute10 NUMBER := NULL;
416: l_vendor_id VARCHAR(250) := NULL;
417: l_territory_code VARCHAR(250) := NULL;
418: -- Bug# 2032659 End
419: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
420:
421: --Bug No 3952081
422: --Add variables to hold existent OPM attributes of the lot
423: l_parent_lot_number MTL_LOT_NUMBERS.PARENT_LOT_NUMBER%TYPE := NULL;

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

884: l_err_code NUMBER;
885: l_trx_type_id NUMBER;
886: l_subinventory_code VARCHAR2(10);
887: l_locator_id NUMBER;
888: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
889: BEGIN
890: /*Fixed Bug#6758460 regardless of validation level
891: txn temp id should be validated and serial number should be marked
892: If customer does not pass validation leverl as full then this API

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

1258: , p_serial_allocated_flag IN VARCHAR2
1259: , p_operation_plan_id IN NUMBER --lezhang
1260: , p_transaction_status IN NUMBER
1261: ) IS
1262: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1263: l_api_name VARCHAR2(30) := 'COPY_INSERT_LINE_TRX';
1264: l_acct_period_id NUMBER;
1265: l_open_past_period BOOLEAN;
1266: l_transaction_date DATE;

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

1826: , p_user_id IN NUMBER
1827: , x_proc_msg OUT NOCOPY VARCHAR2
1828: )
1829: RETURN NUMBER IS
1830: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1831: BEGIN
1832: DELETE FROM mtl_serial_numbers_temp
1833: WHERE transaction_temp_id = NVL(p_serial_trx_tmp_id, p_trx_tmp_id);
1834:

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

1880: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
1881: AND msi.inventory_item_id = mmtt.inventory_item_id
1882: AND msi.organization_id = mmtt.organization_id;
1883:
1884: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1885: BEGIN
1886: x_return_status := fnd_api.g_ret_sts_success;
1887:
1888: IF l_debug = 1 THEN

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

2104: , p_child_line_id IN NUMBER
2105: , p_lot_control_code IN NUMBER
2106: , p_serial_control_code IN NUMBER
2107: ) IS
2108: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2109:
2110: l_api_return_status VARCHAR2(1);
2111: l_item_id NUMBER;
2112: l_child_pri_qty NUMBER;