8230: THEN
8231: --{
8232:
8233: IF l_debug_on THEN
8234: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
8235: END IF;
8236: --
8237: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
8238: (
8233: IF l_debug_on THEN
8234: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
8235: END IF;
8236: --
8237: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
8238: (
8239: p_in_rec => l_lpn_in_sync_comm_rec,
8240: x_return_status => l_return_status,
8241: x_out_rec => l_lpn_out_sync_comm_rec
8241: x_out_rec => l_lpn_out_sync_comm_rec
8242: );
8243: --
8244: IF l_debug_on THEN
8245: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
8246: END IF;
8247: --
8248: WSH_UTIL_CORE.API_POST_CALL
8249: (
8296: THEN
8297: --{
8298: --
8299: IF l_debug_on THEN
8300: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
8301: END IF;
8302: --
8303: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
8304: (
8299: IF l_debug_on THEN
8300: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
8301: END IF;
8302: --
8303: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
8304: (
8305: p_in_rec => l_lpn_in_sync_comm_rec,
8306: x_return_status => l_return_status,
8307: x_out_rec => l_lpn_out_sync_comm_rec
8307: x_out_rec => l_lpn_out_sync_comm_rec
8308: );
8309: --
8310: IF l_debug_on THEN
8311: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
8312: END IF;
8313: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
8314: x_return_status := l_return_status;
8315: END IF;
8327: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery',l_module_name);
8328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8329:
8330: IF l_debug_on THEN
8331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM WHEN OTHERS',WSH_DEBUG_SV.C_PROC_LEVEL);
8332: END IF;
8333: --
8334: IF l_debug_on THEN
8335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM WHEN OTHERS',WSH_DEBUG_SV.C_PROC_LEVEL);
8331: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM WHEN OTHERS',WSH_DEBUG_SV.C_PROC_LEVEL);
8332: END IF;
8333: --
8334: IF l_debug_on THEN
8335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM WHEN OTHERS',WSH_DEBUG_SV.C_PROC_LEVEL);
8336: END IF;
8337: --
8338: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
8339: THEN
8339: THEN
8340: --{
8341: --
8342: IF l_debug_on THEN
8343: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
8344: END IF;
8345: --
8346: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
8347: (
8342: IF l_debug_on THEN
8343: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
8344: END IF;
8345: --
8346: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
8347: (
8348: p_in_rec => l_lpn_in_sync_comm_rec,
8349: x_return_status => l_return_status,
8350: x_out_rec => l_lpn_out_sync_comm_rec
8350: x_out_rec => l_lpn_out_sync_comm_rec
8351: );
8352: --
8353: IF l_debug_on THEN
8354: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
8355: END IF;
8356: --}
8357: END IF;
8358: --
9905: THEN
9906: --{
9907:
9908: IF l_debug_on THEN
9909: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
9910: END IF;
9911: --
9912: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
9913: (
9908: IF l_debug_on THEN
9909: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
9910: END IF;
9911: --
9912: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
9913: (
9914: p_in_rec => l_lpn_in_sync_comm_rec,
9915: x_return_status => l_return_status,
9916: x_out_rec => l_lpn_out_sync_comm_rec
9916: x_out_rec => l_lpn_out_sync_comm_rec
9917: );
9918: --
9919: IF l_debug_on THEN
9920: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
9921: END IF;
9922: --
9923: WSH_UTIL_CORE.API_POST_CALL
9924: (
10015: WHEN e_return_excp THEN
10016: --
10017: --
10018: IF l_debug_on THEN
10019: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
10020: END IF;
10021: --
10022: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
10023: THEN
10023: THEN
10024: --{
10025: --
10026: IF l_debug_on THEN
10027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
10028: END IF;
10029: --
10030: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
10031: (
10026: IF l_debug_on THEN
10027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
10028: END IF;
10029: --
10030: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
10031: (
10032: p_in_rec => l_lpn_in_sync_comm_rec,
10033: x_return_status => l_return_status,
10034: x_out_rec => l_lpn_out_sync_comm_rec
10034: x_out_rec => l_lpn_out_sync_comm_rec
10035: );
10036: --
10037: IF l_debug_on THEN
10038: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
10039: END IF;
10040: --
10041: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,WSH_UTIL_CORE.G_RET_STS_ERROR) AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
10042: x_return_status := l_return_status;
10060: END IF;
10061: --
10062: -- LPN CONV. rv
10063: IF l_debug_on THEN
10064: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
10065: END IF;
10066: --
10067: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
10068: THEN
10068: THEN
10069: --{
10070: --
10071: IF l_debug_on THEN
10072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
10073: END IF;
10074: --
10075: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
10076: (
10071: IF l_debug_on THEN
10072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
10073: END IF;
10074: --
10075: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
10076: (
10077: p_in_rec => l_lpn_in_sync_comm_rec,
10078: x_return_status => l_return_status,
10079: x_out_rec => l_lpn_out_sync_comm_rec
10079: x_out_rec => l_lpn_out_sync_comm_rec
10080: );
10081: --
10082: IF l_debug_on THEN
10083: WSH_DEBUG_SV.log(l_module_name, 'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS', l_return_status);
10084: END IF;
10085: --}
10086: END IF;
10087: --