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_RCV_DIR_RCPT_APIS dependencies on FND_PROFILE

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

4: --Variable to store interface_transaction_id for lot and serial splits
5: g_interface_transaction_id NUMBER;
6:
7: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER DEFAULT 4) IS
8: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9: BEGIN
10: IF (l_debug = 1) THEN
11: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'INV_RCV_DIR_RCPT_APIS', p_level => p_level);
12: END IF;

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

43: l_valid_ship_to_location BOOLEAN;
44: l_valid_deliver_to_location BOOLEAN;
45: l_valid_deliver_to_person BOOLEAN;
46: l_valid_subinventory BOOLEAN;
47: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
48: BEGIN
49:
50: --Bug 5550783 start
51: IF (l_debug = 1) THEN

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

411: AND mum.unit_of_measure(+) = pol.unit_meas_lookup_code
412: AND NVL(msi.organization_id, poll.ship_to_organization_id) = poll.ship_to_organization_id
413: AND msi.inventory_item_id(+) = pol.item_id;
414:
415: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
416: --table to store all RTId, quantity and original_rti_id for lot/serial splits
417: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
418: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
419: BEGIN

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

1035: OR pod.project_id = p_project_id)
1036: AND (p_task_id IS NULL
1037: OR pod.task_id = p_task_id);
1038:
1039: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1040: --table to store all RTId, quantity and original_rti_id for lot/serial splits
1041: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
1042: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
1043: l_msni_count NUMBER := 0;

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

1798: -- 3441084 Requisition_line_id also needs to be joined in the above Query otherwise will do
1799: -- a full scan on po_req_distributions_all which is not good.
1800:
1801:
1802: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1803: --table to store all RTId, quantity and original_rti_id for lot/serial splits
1804: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
1805: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
1806: l_msni_count NUMBER := 0;

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

2538: oel.project_id = p_project_id)
2539: AND (p_task_id IS NULL
2540: OR oel.task_id = p_task_id);
2541:
2542: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2543: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2544: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2545: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2546: BEGIN

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

3348:
3349: -- 3441084 Requisition_line_id also needs to be joined in the above Query otherwise will do
3350: -- a full scan on po_req_distributions_all which is not good.
3351:
3352: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3353: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3354: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3355: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3356: l_msni_count NUMBER := 0;

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

4100: l_serial_number VARCHAR2(30);
4101: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
4102: l_serial_number_count NUMBER;
4103: l_label_status VARCHAR2(500);
4104: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4105:
4106: l_transaction_interface_id NUMBER;
4107: l_product_transaction_id NUMBER;
4108: l_serial_transaction_temp_id NUMBER;

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

4840: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4841: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
4842: -- GROUP BY rti.lpn_id;
4843:
4844: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4845: BEGIN
4846: x_status := fnd_api.g_ret_sts_success;
4847: l_progress := '10';
4848:

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

5120: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5121: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5122:
5123: -- GROUP BY rti.lpn_id;
5124: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5125: BEGIN
5126: x_status := fnd_api.g_ret_sts_success;
5127: l_progress := '10';
5128:

Line 5793: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

5789: PROCEDURE pack_lpn_txn
5790: IS
5791: l_proc_msg VARCHAR2(400);
5792: l_return_status NUMBER;
5793: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5794: BEGIN
5795: IF (l_debug = 1) THEN
5796: print_debug('Enter pack_lpn_txn: 1'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS') , 1);
5797: END IF;