1949: --
1950: -- Debug Statements
1951: --
1952: IF l_debug_on THEN
1953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1954: END IF;
1955: --
1956: INV_STAGED_RESERVATION_UTIL.query_staged_flag
1957: ( x_return_status => x_return_status,
1952: IF l_debug_on THEN
1953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1954: END IF;
1955: --
1956: INV_STAGED_RESERVATION_UTIL.query_staged_flag
1957: ( x_return_status => x_return_status,
1958: x_msg_count => l_msg_count,
1959: x_msg_data => l_msg_data,
1960: x_staged_flag => l_staged_flag,
1967: --
1968: -- Debug Statements
1969: --
1970: IF l_debug_on THEN
1971: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG : '||L_STAGED_FLAG );
1972: END IF;
1973: --
1974:
1975: -- HW OPMCONV - Update qty2 using new reservation flds
2250: LOOP
2251: -- HW OPMCONV. Removed forking the code
2252:
2253: IF l_debug_on THEN
2254: WSH_DEBUG_SV.log(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.query_staged_flag',WSH_DEBUG_SV.C_PROC_LEVEL);
2255: END IF;
2256:
2257: IF l_debug_on THEN
2258:
2259: WSH_DEBUG_SV.log(l_module_name,'BEG OF LOOP l_nonstaged_qty',l_nonstaged_qty);
2260:
2261: WSH_DEBUG_SV.log(l_module_name,'BEG OF LOOP l_nonstaged_qty2',l_nonstaged_qty2);
2262: END IF;
2263: INV_STAGED_RESERVATION_UTIL.query_staged_flag(
2264: x_return_status => x_return_status,
2265: x_msg_count => l_msg_count,
2266: x_msg_data => l_msg_data,
2267: x_staged_flag => l_staged_flag,
2266: x_msg_data => l_msg_data,
2267: x_staged_flag => l_staged_flag,
2268: p_reservation_id => l_rsv_array(l_counter).reservation_id);
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.log(l_module_name,'INV_STAGED_RESERVATION_UTIL.query_staged_flag',l_staged_flag);
2271: END IF;
2272: -- HW OPMCONV. Removed code forking
2273:
2274: -- Bug3012297
2364: --
2365: -- Debug Statements
2366: --
2367: IF l_debug_on THEN
2368: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2369: END IF;
2370: --
2371: INV_STAGED_RESERVATION_UTIL.query_staged_flag
2372: ( x_return_status => x_return_status,
2367: IF l_debug_on THEN
2368: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2369: END IF;
2370: --
2371: INV_STAGED_RESERVATION_UTIL.query_staged_flag
2372: ( x_return_status => x_return_status,
2373: x_msg_count => l_msg_count,
2374: x_msg_data => l_msg_data,
2375: x_staged_flag => l_staged_flag,
2381: --
2382: -- Debug Statements
2383: --
2384: IF l_debug_on THEN
2385: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG : '||L_STAGED_FLAG );
2386: END IF;
2387: --
2388:
2389: -- HW OPMCONV -Update Qty2 using new reservation flds.
2556: exit;
2557: END IF;
2558: --
2559: IF l_debug_on THEN
2560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2561: END IF;
2562: --
2563: INV_STAGED_RESERVATION_UTIL.query_staged_flag (
2564: x_return_status => x_return_status,
2559: IF l_debug_on THEN
2560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2561: END IF;
2562: --
2563: INV_STAGED_RESERVATION_UTIL.query_staged_flag (
2564: x_return_status => x_return_status,
2565: x_msg_count => l_msg_count,
2566: x_msg_data => l_msg_data,
2567: x_staged_flag => l_staged_flag,
2568: p_reservation_id => l_rsv_array(l_counter).reservation_id );
2569: --
2570: IF l_debug_on THEN
2571: WSH_DEBUG_SV.log(l_module_name,'query_staged_flag x_return_status',x_return_status);
2572: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG : '||L_STAGED_FLAG );
2573: END IF;
2574: --
2575: l_rsv_match := 'N';
2576: IF l_staged_flag <> 'Y' THEN
3082: END IF;
3083:
3084: IF p_staged = 'Y' THEN
3085: IF l_debug_on THEN
3086: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
3087: END IF;
3088: --
3089: INV_STAGED_RESERVATION_UTIL.update_staged_flag
3090: ( x_return_status => l_status,
3085: IF l_debug_on THEN
3086: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
3087: END IF;
3088: --
3089: INV_STAGED_RESERVATION_UTIL.update_staged_flag
3090: ( x_return_status => l_status,
3091: x_msg_count => l_msg_count,
3092: x_msg_data => l_msg_data,
3093: p_reservation_id => l_new_rsv_id,
3541: ELSE -- non PTOTRANSFER case..
3542: -- loop over all the reservation records in l_rsv_array
3543: FOR l_counter in 1..l_size LOOP
3544: IF l_debug_on THEN
3545: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
3546: END IF;
3547: --
3548: INV_STAGED_RESERVATION_UTIL.query_staged_flag(
3549: x_return_status => x_return_status,
3544: IF l_debug_on THEN
3545: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
3546: END IF;
3547: --
3548: INV_STAGED_RESERVATION_UTIL.query_staged_flag(
3549: x_return_status => x_return_status,
3550: x_msg_count => l_msg_count,
3551: x_msg_data => l_msg_data,
3552: x_staged_flag => l_staged_flag,