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

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

7: --g_rcpt_lot_qty_rec_tb rcpt_lot_qty_rec_tb_tp;
8: --g_prev_lot_number VARCHAR2(30) := NULL;
9:
10: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER DEFAULT 4) IS
11: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
12: BEGIN
13: IF (l_debug = 1) THEN
14: inv_mobile_helper_functions.tracelog(
15: p_err_msg => p_err_msg

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

26: , x_task_id OUT NOCOPY NUMBER
27: ) IS
28: l_project_id NUMBER := '';
29: l_task_id NUMBER := '';
30: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
31: BEGIN
32: IF (l_debug = 1) THEN
33: print_debug('get_project_task: 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
34: END IF;

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

179: l_task_id NUMBER := p_task_id;
180: l_validation_flag VARCHAR2(1);
181: l_lpn_group_id NUMBER;
182: l_header_interface_id NUMBER;
183: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
184: --OPM Convergence
185: l_secondary_unit_of_measure VARCHAR2(25);
186: l_secondary_uom_code VARCHAR2(3);
187: l_secondary_quantity NUMBER;

Line 445: IF (NVL(FND_PROFILE.VALUE('WMS_DEPLOYMENT_MODE'), 1) = 3) THEN

441: Begin
442:
443: /* Bug 9158529: LSP Changes */
444:
445: IF (NVL(FND_PROFILE.VALUE('WMS_DEPLOYMENT_MODE'), 1) = 3) THEN
446:
447: l_client_code := wms_deploy.get_client_code(l_rcv_transaction_rec.item_id);
448:
449:

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

1370: l_primary_uom VARCHAR2(3);
1371: l_txn_qty NUMBER;
1372: l_counter NUMBER;
1373: l_create_new NUMBER := 1;
1374: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1375: --OPM Convergence
1376: l_sec_txn_qty NUMBER;
1377: BEGIN
1378: IF (l_debug = 1) THEN

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

1445: ****************************************************/
1446: PROCEDURE split_qty_for_lot(p_txn_qty IN NUMBER, p_splitted_qty_rec_tb OUT NOCOPY rcpt_lot_qty_rec_tb_tp) IS
1447: l_new_txn_quantity NUMBER; -- the quanity user wants to split
1448: l_new_counter NUMBER := 0;
1449: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1450: BEGIN
1451: IF (l_debug = 1) THEN
1452: print_debug('Enter split_qty_for_lot: 1 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
1453: END IF;

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

1782: AND pod.po_line_id = poll.po_line_id
1783: AND pod.line_location_id = poll.line_location_id);
1784:
1785: l_rcv_rcpt_rec rcv_enter_receipts_rec_tp;
1786: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1787:
1788: --table to store all RTId, quantity and original_rti_id for lot/serial splits
1789: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
1790: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API

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

2734: )
2735: OR rsl.source_document_code <> 'REQ'
2736: );
2737:
2738: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2739: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2740: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2741: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2742: l_msni_count NUMBER := 0;

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

3508: OR oel.task_id = p_task_id)
3509: );
3510: -- don't need from and to org for the query since both have 1-to-1 relationship to shipment header
3511:
3512: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3513: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3514: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3515: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3516: l_line_id NUMBER;

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

4287: AND rsh.asn_type IS NULL
4288: AND rsl.shipment_line_id = v_shipment_line_id;
4289: -- dont need from and to org for the query since both have 1-to-1 relationship to shipment header
4290:
4291: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4292: --table to store all RTId, quantity and original_rti_id for lot/serial splits
4293: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
4294: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
4295: l_lpn_id NUMBER := p_lpn_id;

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

5175: l_msg_count NUMBER;
5176: l_msg_data VARCHAR2(4000);
5177: l_progress VARCHAR2(10);
5178: l_label_status VARCHAR2(500);
5179: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5180:
5181: l_serial_control_code NUMBER;
5182: l_transaction_interface_id NUMBER;
5183: l_product_transaction_id NUMBER;

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

5873: 'ASNEXP', rti.interface_transaction_id
5874: , 'SHIPMENTEXP', rti.interface_transaction_id, NULL);
5875:
5876: -- GROUP BY rti.lpn_id;
5877: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5878: BEGIN
5879: x_status := fnd_api.g_ret_sts_success;
5880: l_progress := '10';
5881:

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

6573: * is post-inv txn processing, because
6574: * mtlt records will not exist post-inv
6575: * txn processing.
6576: ******************************************************************************/
6577: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6578: l_line_id NUMBER;
6579: BEGIN
6580: IF p_lot_control_code = 2 THEN
6581: g_rcpt_lot_qty_rec_tb.DELETE;

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

6765: l_msg_count NUMBER;
6766: l_msg_data VARCHAR2(4000);
6767: l_progress VARCHAR2(10);
6768: l_wms_process_flag NUMBER := 2;
6769: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6770: --Added for bug #3989521
6771: l_po_line_location_id NUMBER := NULL;
6772: l_po_distribution_id NUMBER := NULL;
6773: l_is_asn VARCHAR2(1);

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

7252: l_msg_count NUMBER;
7253: l_msg_data VARCHAR2(4000);
7254: l_progress VARCHAR2(10);
7255: l_process_status VARCHAR2(10);
7256: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7257: BEGIN
7258: l_progress := '10';
7259: x_return_status := fnd_api.g_ret_sts_success;
7260:

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

7401: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7402: l_msg_count NUMBER;
7403: l_msg_data VARCHAR2(4000);
7404: l_progress VARCHAR2(10);
7405: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7406: BEGIN
7407: IF (l_debug = 1) THEN
7408: print_debug('rcv_insert_header_interface 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
7409: END IF;

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

7705: l_progress VARCHAR2(10);
7706: l_check_asn VARCHAR2(25);--Bug 4551595
7707: l_vendor_site_id NUMBER; --bug9409867
7708:
7709: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7710: BEGIN
7711: -- receving api is using row_id in where clause
7712: -- so query row_id based on shipment_header_id
7713: IF (l_debug = 1) THEN

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

7928: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
7929: l_msg_count NUMBER;
7930: l_msg_data VARCHAR2(4000);
7931: l_progress VARCHAR2(10);
7932: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7933: -- Changes for BUG 3630412
7934: l_label_status VARCHAR2(500);
7935: l_txn_id_tbl inv_label.transaction_id_rec_type;
7936: l_counter NUMBER := 0;

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

8194: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8195: l_msg_count NUMBER;
8196: l_msg_data VARCHAR2(4000);
8197: l_progress VARCHAR2(10);
8198: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8199: BEGIN
8200: IF (l_debug = 1) THEN
8201: print_debug('PackUnpack_Container 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
8202: print_debug('Parameters passed : 10.1: p_from_lpn_id - ' || p_from_lpn_id, 4);

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

8541: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8542: l_msg_count NUMBER;
8543: l_msg_data VARCHAR2(4000);
8544: l_progress VARCHAR2(10);
8545: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8546: BEGIN
8547: IF (l_debug = 1) THEN
8548: print_debug('Enter detect_ASN_discrepancy 10 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
8549: print_debug('p_lpn_id ' || p_lpn_id , 1);

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

8634: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8635: l_msg_count NUMBER;
8636: l_msg_data VARCHAR2(4000);
8637: l_progress VARCHAR2(10);
8638: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8639: BEGIN
8640: IF (l_debug = 1) THEN
8641: print_debug('remove_lpn_contents 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
8642: END IF;

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

8705: SELECT lpn_id
8706: FROM wms_license_plate_numbers
8707: WHERE source_header_id = p_shipment_header_id;
8708:
8709: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8710: BEGIN
8711: IF (l_debug = 1) THEN
8712: print_debug('clear_LPN_for_ship 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
8713: END IF;

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

8951: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
8952: l_msg_count NUMBER;
8953: l_msg_data VARCHAR2(4000);
8954: l_progress VARCHAR2(10);
8955: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
8956: BEGIN
8957: IF (l_debug = 1) THEN
8958: print_debug('check_lpn_on_shipment 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
8959: END IF;

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

9044: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
9045: l_msg_count NUMBER;
9046: l_msg_data VARCHAR2(4000);
9047: l_progress VARCHAR2(10);
9048: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9049: BEGIN
9050: IF (l_debug = 1) THEN
9051: print_debug('check_lpn_on_ASN 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
9052: END IF;

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

9148: SELECT line_id
9149: FROM oe_order_lines_all
9150: WHERE header_id = l_order_header_id;
9151:
9152: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9153:
9154: -- bug 3209246
9155: CURSOR c_delivery_details(v_order_header_id NUMBER, v_order_line_id NUMBER) IS
9156: SELECT wdd1.lpn_id

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

9351: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
9352: l_msg_count NUMBER;
9353: l_msg_data VARCHAR2(4000);
9354: l_progress VARCHAR2(10);
9355: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9356: --variables below are added for bug# 2814405
9357: l_serial_code NUMBER;
9358: l_lot_code NUMBER;
9359: l_item_id NUMBER;

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

9494: l_index NUMBER := 0;
9495: l_diff_txn_qty NUMBER := 0;
9496: l_partial_rcpt NUMBER := 0;
9497: l_rec_count NUMBER := 0;
9498: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9499:
9500: BEGIN
9501:
9502: IF (l_debug = 1) THEN

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

9622: ) IS
9623: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;
9624: l_mtli_primary_quantity NUMBER := 0;
9625: l_current_grp_prim_qty NUMBER := 0;
9626: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9627:
9628: BEGIN
9629: IF (l_debug = 1) THEN
9630: print_debug('validate_lot_qty J: 10 Entering into Lot Qty Validation Procedure' , 4);

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

9737: ) IS
9738: l_rlsu_primary_quantity RCV_LOTS_SUPPLY.PRIMARY_QUANTITY%TYPE := 0;
9739: l_mtli_primary_quantity NUMBER := 0;
9740: l_current_grp_prim_qty NUMBER := 0;
9741: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
9742: l_lot_code NUMBER := 0; --bug number 12814511
9743:
9744: BEGIN
9745: IF (l_debug = 1) THEN