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_UI_ITEM_SUB_LOC_LOVS dependencies on INV_LOG_UTIL

Line 820: inv_log_util.TRACE('Im in GET_pick_LOV', 'WMS_LPN_LOVs', 9);

816: ) IS
817: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
818: BEGIN
819: IF (l_debug = 1) THEN
820: inv_log_util.TRACE('Im in GET_pick_LOV', 'WMS_LPN_LOVs', 9);
821: END IF;
822:
823: IF p_restrict_locators_code = 1 THEN --Locators restricted to predefined list
824: OPEN x_locators FOR

Line 2541: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);

2537: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2538: l_ispjm_org VARCHAR2(1);
2539: BEGIN
2540: IF (l_debug = 1) THEN
2541: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2542: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2543: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2544: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2545: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);

Line 2542: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);

2538: l_ispjm_org VARCHAR2(1);
2539: BEGIN
2540: IF (l_debug = 1) THEN
2541: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2542: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2543: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2544: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2545: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2546: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);

Line 2543: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);

2539: BEGIN
2540: IF (l_debug = 1) THEN
2541: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2542: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2543: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2544: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2545: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2546: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2547: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);

Line 2544: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);

2540: IF (l_debug = 1) THEN
2541: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2542: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2543: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2544: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2545: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2546: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2547: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2548: END IF;

Line 2545: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);

2541: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2542: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2543: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2544: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2545: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2546: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2547: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2548: END IF;
2549: BEGIN

Line 2546: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);

2542: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2543: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2544: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2545: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2546: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2547: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2548: END IF;
2549: BEGIN
2550: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')

Line 2547: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);

2543: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2544: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2545: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2546: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2547: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2548: END IF;
2549: BEGIN
2550: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
2551: INTO l_ispjm_org

Line 2564: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);

2560: FROM mtl_cycle_count_headers
2561: WHERE cycle_count_header_id = p_cycle_count_header_id;
2562:
2563: IF (l_debug = 1) THEN
2564: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);
2565: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);
2566: END IF;
2567:
2568: IF (p_unscheduled_entry = 2 AND

Line 2565: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);

2561: WHERE cycle_count_header_id = p_cycle_count_header_id;
2562:
2563: IF (l_debug = 1) THEN
2564: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);
2565: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);
2566: END IF;
2567:
2568: IF (p_unscheduled_entry = 2 AND
2569: l_serial_discrepancy_option = 2 AND

Line 2610: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);

2606: -- unscheduled count entries are allowed
2607: -- or serial or container discrepancy is allowed
2608:
2609: IF (l_ispjm_org = 'Y' and p_project_id is not null ) then
2610: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);
2611: IF ( p_task_id is not null ) then
2612: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2613: OPEN x_locators FOR
2614: SELECT inventory_location_id,

Line 2612: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);

2608:
2609: IF (l_ispjm_org = 'Y' and p_project_id is not null ) then
2610: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);
2611: IF ( p_task_id is not null ) then
2612: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2613: OPEN x_locators FOR
2614: SELECT inventory_location_id,
2615: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2616: locator_segments concatenated_segments,

Line 2639: Inv_log_util.trace('Task is null ' , 'INV_UI_ITEM_SUB_LOCS',9);

2635: NULL,
2636: 'L') = 'Y')
2637: ORDER BY 2;
2638: ELSE -- task_id is null then
2639: Inv_log_util.trace('Task is null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2640:
2641: OPEN x_locators FOR
2642: SELECT inventory_location_id,
2643: -- concatenated_segments ,--Bug4398337:Commented this line and added below line

Line 2668: Inv_log_util.trace('non pjm org or project is not passed' , 'INV_UI_ITEM_SUB_LOCS',9);

2664: ORDER BY 2;
2665:
2666: END IF;
2667: ELSE -- non pjm org or project is not passed
2668: Inv_log_util.trace('non pjm org or project is not passed' , 'INV_UI_ITEM_SUB_LOCS',9);
2669: OPEN x_locators FOR
2670: SELECT inventory_location_id,
2671: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2672: locator_segments concatenated_segments,

Line 2715: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);

2711: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2712: l_ispjm_org VARCHAR2(1);
2713: BEGIN
2714: IF (l_debug = 1) THEN
2715: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2716: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2717: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2718: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2719: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);

Line 2716: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);

2712: l_ispjm_org VARCHAR2(1);
2713: BEGIN
2714: IF (l_debug = 1) THEN
2715: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2716: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2717: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2718: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2719: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2720: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);

Line 2717: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);

2713: BEGIN
2714: IF (l_debug = 1) THEN
2715: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2716: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2717: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2718: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2719: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2720: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2721: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);

Line 2718: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);

2714: IF (l_debug = 1) THEN
2715: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2716: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2717: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2718: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2719: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2720: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2721: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2722: END IF;

Line 2719: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);

2715: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2716: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2717: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2718: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2719: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2720: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2721: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2722: END IF;
2723:

Line 2720: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);

2716: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2717: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2718: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2719: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2720: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2721: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2722: END IF;
2723:
2724: IF p_alias IS NULL THEN

Line 2721: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);

2717: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2718: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2719: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2720: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2721: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2722: END IF;
2723:
2724: IF p_alias IS NULL THEN
2725: get_cyc_locs(

Line 2752: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);

2748: FROM mtl_cycle_count_headers
2749: WHERE cycle_count_header_id = p_cycle_count_header_id;
2750:
2751: IF (l_debug = 1) THEN
2752: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);
2753: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);
2754: END IF;
2755:
2756: IF (p_unscheduled_entry = 2 AND

Line 2753: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);

2749: WHERE cycle_count_header_id = p_cycle_count_header_id;
2750:
2751: IF (l_debug = 1) THEN
2752: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);
2753: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);
2754: END IF;
2755:
2756: IF (p_unscheduled_entry = 2 AND
2757: l_serial_discrepancy_option = 2 AND

Line 2798: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);

2794: -- unscheduled count entries are allowed
2795: -- or serial or container discrepancy is allowed
2796:
2797: IF (l_ispjm_org = 'Y' and p_project_id is not null ) then
2798: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);
2799: IF ( p_task_id is not null ) then
2800: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2801: OPEN x_locators FOR
2802: SELECT inventory_location_id,

Line 2800: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);

2796:
2797: IF (l_ispjm_org = 'Y' and p_project_id is not null ) then
2798: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);
2799: IF ( p_task_id is not null ) then
2800: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2801: OPEN x_locators FOR
2802: SELECT inventory_location_id,
2803: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2804: locator_segments concatenated_segments,

Line 2827: Inv_log_util.trace('Task is null ' , 'INV_UI_ITEM_SUB_LOCS',9);

2823: NULL,
2824: 'L') = 'Y')
2825: ORDER BY 2;
2826: ELSE -- task_id is null then
2827: Inv_log_util.trace('Task is null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2828:
2829: OPEN x_locators FOR
2830: SELECT inventory_location_id,
2831: -- concatenated_segments ,--Bug4398337:Commented this line and added below line

Line 2857: Inv_log_util.trace('non pjm org or project is not passed' , 'INV_UI_ITEM_SUB_LOCS',9);

2853: ORDER BY 2;
2854:
2855: END IF;
2856: ELSE -- non pjm org or project is not passed
2857: Inv_log_util.trace('non pjm org or project is not passed' , 'INV_UI_ITEM_SUB_LOCS',9);
2858: OPEN x_locators FOR
2859: SELECT inventory_location_id,
2860: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2861: locator_segments concatenated_segments,