[Home] [Help]
10: /* Debugging utility*/
11: PROCEDURE print_debug (
12: p_err_msg VARCHAR2
13: , p_level NUMBER) IS
14: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
15: BEGIN
16: IF (l_debug = 1) THEN
17: inv_mobile_helper_functions.tracelog (
18: p_err_msg => p_err_msg
51: l_currency_conv_date DATE;
52: l_validation_flag VARCHAR2(1);
53: l_lpn_group_id NUMBER;
54: l_progress NUMBER; --Index to track progress and log error
55: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
56: l_project_id NUMBER := NULL;
57: l_task_id NUMBER := NULL;
58:
59: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
466: l_interface_txn_id NUMBER;
467: l_location_id NUMBER;
468: l_msni_count NUMBER := 0;
469: l_progress NUMBER; --Index to track progress and log error
470: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
471: BEGIN
472:
473: --Initialize the return status to success
474: x_return_status := FND_API.G_RET_STS_SUCCESS;
831: l_lpn_count NUMBER; --Count of RT records for the LPN ID
832: l_lot_count NUMBER; --Count of RLS records for the given lot
833:
834: l_progress NUMBER; --Index to track progress and log error
835: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
836:
837: BEGIN
838: --Initizlize the return status to success
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
1220: l_parent_txn_id NUMBER;
1221: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
1222:
1223: l_progress NUMBER; --Index to track progress and log error
1224: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1225:
1226: --OPM Convergence
1227: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1228: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1652: l_receipt_source_code RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE;
1653: l_parent_txn_id NUMBER;
1654: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
1655: l_progress NUMBER; --Index to track progress and log error
1656: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1657: --OPM Convergence
1658: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
1659: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
1660: l_sec_transfer_uom mtl_units_of_measure.unit_of_measure%TYPE;
2069: l_parent_txn_id NUMBER;
2070: l_um_transfer_qty NUMBER; --Transfer quantity converted to MOL UOM
2071:
2072: l_progress NUMBER; --Index to track progress and log error
2073: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
2074:
2075: --OPM Convergence
2076: l_sec_transfer_uom_code mtl_units_of_measure.uom_code%TYPE; --OPM Convergence
2077: l_secondary_uom mtl_units_of_measure.unit_of_measure%TYPE;
2380: l_shipment_header_id NUMBER;
2381: l_oe_order_header_id NUMBER;
2382: l_group_id NUMBER; --Interface Group ID
2383: l_progress NUMBER; --Index to track progress and log error
2384: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
2385: l_message VARCHAR2(1000);
2386:
2387: l_sec_uom_code VARCHAR2(3) := p_sec_transfer_uom_code;
2388:
2776: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
2777: l_return_status VARCHAR2(1);
2778: l_msg_count NUMBER;
2779: l_msg_data VARCHAR2(10000);
2780: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2781: BEGIN
2782: --Get the required columns from MLN first
2783: SELECT expiration_date
2784: , status_id
2861: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
2862: l_return_status VARCHAR2(1);
2863: l_msg_count NUMBER;
2864: l_msg_data VARCHAR2(10000);
2865: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2866: BEGIN
2867:
2868: --Get the serial status
2869: SELECT status_id
3037: ;
3038:
3039:
3040: --Local Variables
3041: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
3042:
3043:
3044: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3045: l_from_sub VARCHAR2(30);