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 489: inv_log_util.TRACE('Im in GET_pick_LOV', 'WMS_LPN_LOVs', 9);

485: ) IS
486: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
487: BEGIN
488: IF (l_debug = 1) THEN
489: inv_log_util.TRACE('Im in GET_pick_LOV', 'WMS_LPN_LOVs', 9);
490: END IF;
491:
492: IF p_restrict_locators_code = 1 THEN --Locators restricted to predefined list
493: OPEN x_locators FOR

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

2160: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2161: l_ispjm_org VARCHAR2(1);
2162: BEGIN
2163: IF (l_debug = 1) THEN
2164: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2165: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2166: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2167: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2168: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);

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

2161: l_ispjm_org VARCHAR2(1);
2162: BEGIN
2163: IF (l_debug = 1) THEN
2164: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2165: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2166: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2167: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2168: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2169: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);

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

2162: BEGIN
2163: IF (l_debug = 1) THEN
2164: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2165: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2166: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2167: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2168: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2169: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2170: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);

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

2163: IF (l_debug = 1) THEN
2164: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2165: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2166: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2167: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2168: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2169: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2170: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2171: END IF;

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

2164: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2165: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2166: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2167: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2168: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2169: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2170: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2171: END IF;
2172: BEGIN

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

2165: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2166: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2167: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2168: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2169: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2170: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2171: END IF;
2172: BEGIN
2173: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')

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

2166: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2167: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2168: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2169: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2170: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2171: END IF;
2172: BEGIN
2173: SELECT nvl(PROJECT_REFERENCE_ENABLED,'N')
2174: INTO l_ispjm_org

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

2183: FROM mtl_cycle_count_headers
2184: WHERE cycle_count_header_id = p_cycle_count_header_id;
2185:
2186: IF (l_debug = 1) THEN
2187: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);
2188: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);
2189: END IF;
2190:
2191: IF (p_unscheduled_entry = 2 AND

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

2184: WHERE cycle_count_header_id = p_cycle_count_header_id;
2185:
2186: IF (l_debug = 1) THEN
2187: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);
2188: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);
2189: END IF;
2190:
2191: IF (p_unscheduled_entry = 2 AND
2192: l_serial_discrepancy_option = 2 AND

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

2229: -- unscheduled count entries are allowed
2230: -- or serial or container discrepancy is allowed
2231:
2232: IF (l_ispjm_org = 'Y' and p_project_id is not null ) then
2233: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);
2234: IF ( p_task_id is not null ) then
2235: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2236: OPEN x_locators FOR
2237: SELECT inventory_location_id,

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

2231:
2232: IF (l_ispjm_org = 'Y' and p_project_id is not null ) then
2233: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);
2234: IF ( p_task_id is not null ) then
2235: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2236: OPEN x_locators FOR
2237: SELECT inventory_location_id,
2238: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2239: locator_segments concatenated_segments,

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

2258: NULL,
2259: 'L') = 'Y')
2260: ORDER BY 2;
2261: ELSE -- task_id is null then
2262: Inv_log_util.trace('Task is null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2263:
2264: OPEN x_locators FOR
2265: SELECT inventory_location_id,
2266: -- concatenated_segments ,--Bug4398337:Commented this line and added below line

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

2287: ORDER BY 2;
2288:
2289: END IF;
2290: ELSE -- non pjm org or project is not passed
2291: Inv_log_util.trace('non pjm org or project is not passed' , 'INV_UI_ITEM_SUB_LOCS',9);
2292: OPEN x_locators FOR
2293: SELECT inventory_location_id,
2294: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2295: locator_segments concatenated_segments,

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

2334: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2335: l_ispjm_org VARCHAR2(1);
2336: BEGIN
2337: IF (l_debug = 1) THEN
2338: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2339: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2340: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2341: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2342: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);

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

2335: l_ispjm_org VARCHAR2(1);
2336: BEGIN
2337: IF (l_debug = 1) THEN
2338: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2339: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2340: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2341: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2342: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2343: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);

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

2336: BEGIN
2337: IF (l_debug = 1) THEN
2338: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2339: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2340: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2341: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2342: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2343: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2344: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);

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

2337: IF (l_debug = 1) THEN
2338: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2339: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2340: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2341: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2342: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2343: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2344: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2345: END IF;

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

2338: Inv_log_util.trace('p_organization_id: =======> ' || p_organization_id ,l_proc_name ,9);
2339: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2340: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2341: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2342: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2343: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2344: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2345: END IF;
2346:

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

2339: Inv_log_util.trace('p_subinventory_code: =====> ' || p_subinventory_code , l_proc_name,9);
2340: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2341: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2342: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2343: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2344: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2345: END IF;
2346:
2347: IF p_alias IS NULL THEN

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

2340: Inv_log_util.trace('p_concatenated_segments: => ' || p_concatenated_segments , l_proc_name,9);
2341: Inv_log_util.trace('p_unscheduled_entry: =====> ' || p_unscheduled_entry , l_proc_name,9);
2342: Inv_log_util.trace('p_cycle_count_header_id: => ' || p_cycle_count_header_id , l_proc_name,9);
2343: Inv_log_util.trace('p_project_id: ============> ' || p_project_id , l_proc_name,9);
2344: Inv_log_util.trace('p_task_id: ===============> ' || p_task_id, l_proc_name,9);
2345: END IF;
2346:
2347: IF p_alias IS NULL THEN
2348: get_cyc_locs(

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

2371: FROM mtl_cycle_count_headers
2372: WHERE cycle_count_header_id = p_cycle_count_header_id;
2373:
2374: IF (l_debug = 1) THEN
2375: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);
2376: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);
2377: END IF;
2378:
2379: IF (p_unscheduled_entry = 2 AND

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

2372: WHERE cycle_count_header_id = p_cycle_count_header_id;
2373:
2374: IF (l_debug = 1) THEN
2375: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);
2376: Inv_log_util.trace('l_container_discrepancy_option: ' || l_container_discrepancy_option, l_proc_name,9);
2377: END IF;
2378:
2379: IF (p_unscheduled_entry = 2 AND
2380: l_serial_discrepancy_option = 2 AND

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

2417: -- unscheduled count entries are allowed
2418: -- or serial or container discrepancy is allowed
2419:
2420: IF (l_ispjm_org = 'Y' and p_project_id is not null ) then
2421: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);
2422: IF ( p_task_id is not null ) then
2423: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2424: OPEN x_locators FOR
2425: SELECT inventory_location_id,

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

2419:
2420: IF (l_ispjm_org = 'Y' and p_project_id is not null ) then
2421: Inv_log_util.trace('p_ispjm_org = yes and p_project_id is not null' , 'INV_UI_ITEM_SUB_LOCS',9);
2422: IF ( p_task_id is not null ) then
2423: Inv_log_util.trace('task id is not null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2424: OPEN x_locators FOR
2425: SELECT inventory_location_id,
2426: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2427: locator_segments concatenated_segments,

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

2446: NULL,
2447: 'L') = 'Y')
2448: ORDER BY 2;
2449: ELSE -- task_id is null then
2450: Inv_log_util.trace('Task is null ' , 'INV_UI_ITEM_SUB_LOCS',9);
2451:
2452: OPEN x_locators FOR
2453: SELECT inventory_location_id,
2454: -- concatenated_segments ,--Bug4398337:Commented this line and added below line

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

2476: ORDER BY 2;
2477:
2478: END IF;
2479: ELSE -- non pjm org or project is not passed
2480: Inv_log_util.trace('non pjm org or project is not passed' , 'INV_UI_ITEM_SUB_LOCS',9);
2481: OPEN x_locators FOR
2482: SELECT inventory_location_id,
2483: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2484: locator_segments concatenated_segments,