1936: --
1937: -- Debug Statements
1938: --
1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1941: END IF;
1942: --
1943: INV_STAGED_RESERVATION_UTIL.query_staged_flag
1944: ( x_return_status => x_return_status,
1939: IF l_debug_on THEN
1940: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1941: END IF;
1942: --
1943: INV_STAGED_RESERVATION_UTIL.query_staged_flag
1944: ( x_return_status => x_return_status,
1945: x_msg_count => l_msg_count,
1946: x_msg_data => l_msg_data,
1947: x_staged_flag => l_staged_flag,
1954: --
1955: -- Debug Statements
1956: --
1957: IF l_debug_on THEN
1958: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG : '||L_STAGED_FLAG );
1959: END IF;
1960: --
1961:
1962: -- HW OPMCONV - Update qty2 using new reservation flds
2235: LOOP
2236: -- HW OPMCONV. Removed forking the code
2237:
2238: IF l_debug_on THEN
2239: WSH_DEBUG_SV.log(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.query_staged_flag',WSH_DEBUG_SV.C_PROC_LEVEL);
2240: END IF;
2241:
2242: IF l_debug_on THEN
2243:
2244: WSH_DEBUG_SV.log(l_module_name,'BEG OF LOOP l_nonstaged_qty',l_nonstaged_qty);
2245:
2246: WSH_DEBUG_SV.log(l_module_name,'BEG OF LOOP l_nonstaged_qty2',l_nonstaged_qty2);
2247: END IF;
2248: INV_STAGED_RESERVATION_UTIL.query_staged_flag(
2249: x_return_status => x_return_status,
2250: x_msg_count => l_msg_count,
2251: x_msg_data => l_msg_data,
2252: x_staged_flag => l_staged_flag,
2251: x_msg_data => l_msg_data,
2252: x_staged_flag => l_staged_flag,
2253: p_reservation_id => l_rsv_array(l_counter).reservation_id);
2254: IF l_debug_on THEN
2255: WSH_DEBUG_SV.log(l_module_name,'INV_STAGED_RESERVATION_UTIL.query_staged_flag',l_staged_flag);
2256: END IF;
2257: -- HW OPMCONV. Removed code forking
2258:
2259: -- Bug3012297
2338: --
2339: -- Debug Statements
2340: --
2341: IF l_debug_on THEN
2342: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2343: END IF;
2344: --
2345: INV_STAGED_RESERVATION_UTIL.query_staged_flag
2346: ( x_return_status => x_return_status,
2341: IF l_debug_on THEN
2342: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2343: END IF;
2344: --
2345: INV_STAGED_RESERVATION_UTIL.query_staged_flag
2346: ( x_return_status => x_return_status,
2347: x_msg_count => l_msg_count,
2348: x_msg_data => l_msg_data,
2349: x_staged_flag => l_staged_flag,
2355: --
2356: -- Debug Statements
2357: --
2358: IF l_debug_on THEN
2359: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG : '||L_STAGED_FLAG );
2360: END IF;
2361: --
2362:
2363: -- HW OPMCONV -Update Qty2 using new reservation flds.
2809: END IF;
2810:
2811: IF p_staged = 'Y' THEN
2812: IF l_debug_on THEN
2813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2814: END IF;
2815: --
2816: INV_STAGED_RESERVATION_UTIL.update_staged_flag
2817: ( x_return_status => l_status,
2812: IF l_debug_on THEN
2813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2814: END IF;
2815: --
2816: INV_STAGED_RESERVATION_UTIL.update_staged_flag
2817: ( x_return_status => l_status,
2818: x_msg_count => l_msg_count,
2819: x_msg_data => l_msg_data,
2820: p_reservation_id => l_new_rsv_id,
3158:
3159: -- loop over all the reservation records in l_rsv_array
3160: FOR l_counter in 1..l_size LOOP
3161: IF l_debug_on THEN
3162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
3163: END IF;
3164: --
3165: INV_STAGED_RESERVATION_UTIL.query_staged_flag(
3166: x_return_status => x_return_status,
3161: IF l_debug_on THEN
3162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
3163: END IF;
3164: --
3165: INV_STAGED_RESERVATION_UTIL.query_staged_flag(
3166: x_return_status => x_return_status,
3167: x_msg_count => l_msg_count,
3168: x_msg_data => l_msg_data,
3169: x_staged_flag => l_staged_flag,