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 1804: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

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

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

2623: oel.project_id = p_project_id)
2624: AND (p_task_id IS NULL
2625: OR oel.task_id = p_task_id);
2626:
2627: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2628: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2629: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2630: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2631: BEGIN

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

3452:
3453: -- 3441084 Requisition_line_id also needs to be joined in the above Query otherwise will do
3454: -- a full scan on po_req_distributions_all which is not good.
3455:
3456: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3457: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3458: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3459: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3460: l_msni_count NUMBER := 0;

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

4242: l_serial_number VARCHAR2(30);
4243: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
4244: l_serial_number_count NUMBER;
4245: l_label_status VARCHAR2(500);
4246: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4247:
4248: l_transaction_interface_id NUMBER;
4249: l_product_transaction_id NUMBER;
4250: l_serial_transaction_temp_id NUMBER;

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

4985: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4986: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
4987: -- GROUP BY rti.lpn_id;
4988:
4989: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4990: BEGIN
4991: x_status := fnd_api.g_ret_sts_success;
4992: l_progress := '10';
4993:

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

5265: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5266: GROUP BY DECODE(p_source_type, 'ASNEXP', rti.interface_transaction_id, 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5267:
5268: -- GROUP BY rti.lpn_id;
5269: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5270: BEGIN
5271: x_status := fnd_api.g_ret_sts_success;
5272: l_progress := '10';
5273:

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

5935: PROCEDURE pack_lpn_txn
5936: IS
5937: l_proc_msg VARCHAR2(400);
5938: l_return_status NUMBER;
5939: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5940: BEGIN
5941: IF (l_debug = 1) THEN
5942: print_debug('Enter pack_lpn_txn: 1'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS') , 1);
5943: END IF;