DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on INV_STAGED_RESERVATION_UTIL

Line 1940: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);

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,

Line 1943: INV_STAGED_RESERVATION_UTIL.query_staged_flag

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,

Line 1958: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER INV_STAGED_RESERVATION_UTIL.QUERY_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

Line 2239: WSH_DEBUG_SV.log(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.query_staged_flag',WSH_DEBUG_SV.C_PROC_LEVEL);

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:

Line 2248: INV_STAGED_RESERVATION_UTIL.query_staged_flag(

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,

Line 2255: WSH_DEBUG_SV.log(l_module_name,'INV_STAGED_RESERVATION_UTIL.query_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

Line 2342: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);

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,

Line 2345: INV_STAGED_RESERVATION_UTIL.query_staged_flag

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,

Line 2359: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER INV_STAGED_RESERVATION_UTIL.QUERY_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.

Line 2813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);

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,

Line 2816: INV_STAGED_RESERVATION_UTIL.update_staged_flag

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,

Line 3162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);

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,

Line 3165: INV_STAGED_RESERVATION_UTIL.query_staged_flag(

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,