APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on INV_STAGED_RESERVATION_UTIL

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

466:
467: FOR l_counter in 1..l_count
468: LOOP
469: IF l_debug_on THEN
470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
471: END IF;
472:
473: INV_STAGED_RESERVATION_UTIL.query_staged_flag(
474: x_return_status => x_return_status,

Line 473: INV_STAGED_RESERVATION_UTIL.query_staged_flag(

469: IF l_debug_on THEN
470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
471: END IF;
472:
473: INV_STAGED_RESERVATION_UTIL.query_staged_flag(
474: x_return_status => x_return_status,
475: x_msg_count => l_msg_count,
476: x_msg_data => l_msg_data,
477: x_staged_flag => l_staged_flag,

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

580: END IF;
581: --
582: -- 2747520 : Query Staged Reservation
583: IF l_debug_on THEN
584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
585: END IF;
586: --
587: inv_staged_reservation_util.query_staged_flag(
588: x_return_status => l_return_status

Line 587: inv_staged_reservation_util.query_staged_flag(

583: IF l_debug_on THEN
584: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
585: END IF;
586: --
587: inv_staged_reservation_util.query_staged_flag(
588: x_return_status => l_return_status
589: , x_msg_count => l_msg_count
590: , x_msg_data => l_msg_data
591: , x_staged_flag => l_staged_flag

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

832: IF ( nvl(l_staged_flag, 'N') = 'Y') THEN -- Staged Flag = Y
833:
834: --
835: IF l_debug_on THEN
836: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
837: END IF;
838: --
839: inv_staged_reservation_util.update_staged_flag(
840: x_return_status => l_return_status

Line 839: inv_staged_reservation_util.update_staged_flag(

835: IF l_debug_on THEN
836: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
837: END IF;
838: --
839: inv_staged_reservation_util.update_staged_flag(
840: x_return_status => l_return_status
841: , x_msg_count => l_msg_count
842: , x_msg_data => l_msg_data
843: , p_staged_flag => 'N'

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

1078: END IF;
1079:
1080: --
1081: IF l_debug_on THEN
1082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1083: END IF;
1084: --
1085:
1086: inv_staged_reservation_util.query_staged_flag(

Line 1086: inv_staged_reservation_util.query_staged_flag(

1082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.QUERY_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1083: END IF;
1084: --
1085:
1086: inv_staged_reservation_util.query_staged_flag(
1087: x_return_status => l_return_status
1088: , x_msg_count => l_msg_count
1089: , x_msg_data => l_msg_data
1090: , x_staged_flag => l_staged_flag

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

1104:
1105: If ( nvl(l_staged_flag, 'N') = 'Y') then -- Staged
1106: --
1107: IF l_debug_on THEN
1108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1109: END IF;
1110: --
1111: inv_staged_reservation_util.update_staged_flag(
1112: x_return_status => l_return_status

Line 1111: inv_staged_reservation_util.update_staged_flag(

1107: IF l_debug_on THEN
1108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_STAGED_RESERVATION_UTIL.UPDATE_STAGED_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1109: END IF;
1110: --
1111: inv_staged_reservation_util.update_staged_flag(
1112: x_return_status => l_return_status
1113: , x_msg_count => l_msg_count
1114: , x_msg_data => l_msg_data
1115: , p_staged_flag => 'N'