[Home] [Help]
23: ,crossdock_type NUMBER DEFAULT NULL
24: );
25:
26: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
27: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
28: BEGIN
29: IF (l_debug = 1) THEN
30: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => g_pkg_name||'($Revision: 120.12.12010000.2 $)', p_level => p_level);
31: END IF;
87: , p_SOURCE_LINE_ID IN NUMBER
88: , p_SOURCE_LINE_DETAIL_ID IN NUMBER
89: , p_SOURCE_NAME IN VARCHAR2
90: ) IS
91: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
92: BEGIN
93: x_return_status := g_ret_sts_success;
94:
95: IF (p_lpn_id IS NOT NULL OR p_license_plate_number IS NOT NULL) THEN
463: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
464: l_api_version CONSTANT NUMBER := 1.0;
465: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
466: l_progress NUMBER; --Progress Indicator
467: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
468:
469: l_att_org_id NUMBER;
470:
471: --nsinghi bug#5209065 START. Default the variables to input parameters.
1394: l_api_version CONSTANT NUMBER := 1.0;
1395: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
1396: l_success NUMBER;
1397: l_progress NUMBER; --Progress Indicator
1398: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1399: BEGIN
1400:
1401: -- Standard call to check for call compatibility.
1402: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version,
1940: user_defined_exp_date CONSTANT NUMBER := 4;
1941: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
1942: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
1943: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
1944: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1945: BEGIN
1946: x_return_status := g_ret_sts_success;
1947:
1948: fnd_msg_pub.initialize;
2215: , p_to_serial_number IN OUT NOCOPY VARCHAR2
2216: , p_txn_type IN NUMBER
2217: )
2218: RETURN BOOLEAN IS
2219: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2220: l_serial_diff NUMBER := 0;
2221: l_serial_qty NUMBER := 0;
2222: l_serial_prefix VARCHAR2(30);
2223: l_cur_serial_number mtl_serial_numbers.serial_number%TYPE;
2436: ) return BOOLEAN
2437: IS
2438: l_exist NUMBER;
2439: l_org_id NUMBER;
2440: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2441: BEGIN
2442: x_return_status := g_ret_sts_success;
2443:
2444: -- If not patchsetJ then return from this place.
2546: , p_lpn IN VARCHAR2
2547: , p_parent_lpn_id IN NUMBER DEFAULT NULL
2548: ) return BOOLEAN
2549: IS
2550: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2551: l_exists NUMBER;
2552: l_lpn_id NUMBER;
2553: BEGIN
2554: x_return_status := g_ret_sts_success;
2656: l_api_name VARCHAR2(30) := 'VALIDATE_LPN_INFO';
2657: l_api_version CONSTANT NUMBER := 1.0;
2658:
2659: l_progress VARCHAR2(10) := '00';
2660: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2661: BEGIN
2662: x_return_status := g_ret_sts_success;
2663:
2664: l_progress := '10';
2803: , p_group_id IN NUMBER
2804: , p_request_id IN NUMBER
2805: ) IS
2806: l_exist NUMBER;
2807: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2808: BEGIN
2809: x_return_status := g_ret_sts_success;
2810:
2811: /*
2933: , location_id
2934: FROM rcv_transactions_interface rti
2935: WHERE interface_transaction_id = p_rti_id;
2936:
2937: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2938: BEGIN
2939: x_return_status := g_ret_sts_success;
2940:
2941: IF (l_debug = 1) THEN
3156: l_rti_id NUMBER;
3157:
3158: l_api_name VARCHAR2(30) := 'SPLIT_LOT_SERIAL';
3159: l_api_version CONSTANT NUMBER := 1.0;
3160: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3161: BEGIN
3162: x_return_status := g_ret_sts_success;
3163:
3164: -- Standard call to check for call compatibility.
3202: , p_rti_id IN NUMBER
3203: ) return BOOLEAN
3204: IS
3205: l_org_id NUMBER;
3206: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3207: BEGIN
3208: x_return_status := g_ret_sts_success;
3209:
3210: IF (l_debug = 1) THEN
3336: ORDER BY rt.transfer_lpn_id;
3337:
3338: l_label_status VARCHAR2(500);
3339: l_bus_flow_code NUMBER;
3340: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3341: l_progress VARCHAR2(10) := '00';
3342: BEGIN
3343: x_return_status := g_ret_sts_success;
3344:
3728: l_serial_control_code NUMBER;
3729: l_new_txn_tb inv_rcv_common_apis.trans_rec_tb_tp;
3730: l_temp NUMBER;
3731: l_sysdate DATE := Sysdate;
3732: l_debug NUMBER := Nvl(fnd_profile.value('INV_DEBUG_TRACE'), 0);
3733: l_progress VARCHAR2(10) := '0';
3734: l_error_code NUMBER;
3735: l_inspection_flag NUMBER;
3736: l_load_flag NUMBER;
4793: l_remaining_prim_qty NUMBER;
4794: l_remaining_qty NUMBER;
4795: -- OPMCovergence
4796: l_remaining_sec_qty NUMBER;
4797: l_debug NUMBER := Nvl(fnd_profile.value('INV_DEBUG_TRACE'), 0);
4798: l_progress VARCHAR2(10) := '00';
4799:
4800: l_SECONDARY_QUANTITY NUMBER; --OPM Convergence
4801: l_SECONDARY_QUANTITY_DELIVERED NUMBER; --OPM Convergence
5893: l_mmtts_to_split wms_atf_runtime_pub_apis.task_id_table_type;
5894: l_sysdate DATE := Sysdate;
5895:
5896: l_error_code NUMBER;
5897: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5898: l_progress VARCHAR2(10) := '10';
5899:
5900: BEGIN
5901: