DBA Data[Home] [Help]

APPS.WSH_USA_INV_PVT dependencies on INV_STAGED_RESERVATION_UTIL

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

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,

Line 1956: INV_STAGED_RESERVATION_UTIL.query_staged_flag

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,

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

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

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:

Line 2263: INV_STAGED_RESERVATION_UTIL.query_staged_flag(

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,

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

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

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,

Line 2371: INV_STAGED_RESERVATION_UTIL.query_staged_flag

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,

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

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

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,

Line 2563: INV_STAGED_RESERVATION_UTIL.query_staged_flag (

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,

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

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

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,

Line 3089: INV_STAGED_RESERVATION_UTIL.update_staged_flag

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,

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

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,

Line 3548: INV_STAGED_RESERVATION_UTIL.query_staged_flag(

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,