470: --{
471:
472: --
473: IF l_debug_on THEN
474: 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);
475: END IF;
476: --
477: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
478: (
473: IF l_debug_on THEN
474: 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);
475: END IF;
476: --
477: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
478: (
479: p_in_rec => l_lpn_in_sync_comm_rec,
480: x_return_status => l_return_status,
481: x_out_rec => l_lpn_out_sync_comm_rec
482: );
483: --
484: --
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
487: END IF;
488: --}
489: END IF;
490: --
542: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
543: THEN
544: --{
545: IF l_debug_on THEN
546: 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);
547: END IF;
548:
549: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
550: (
545: IF l_debug_on THEN
546: 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);
547: END IF;
548:
549: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
550: (
551: p_in_rec => l_lpn_in_sync_comm_rec,
552: x_return_status => l_return_status,
553: x_out_rec => l_lpn_out_sync_comm_rec
554: );
555: --
556: --
557: IF l_debug_on THEN
558: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
559: END IF;
560: --
561: --
562: 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
584: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
585: THEN
586: --{
587: IF l_debug_on THEN
588: 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);
589: END IF;
590:
591: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
592: (
587: IF l_debug_on THEN
588: 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);
589: END IF;
590:
591: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
592: (
593: p_in_rec => l_lpn_in_sync_comm_rec,
594: x_return_status => l_return_status,
595: x_out_rec => l_lpn_out_sync_comm_rec
596: );
597: --
598: --
599: IF l_debug_on THEN
600: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
601: END IF;
602: --
603: --
604: --}
829: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
830: THEN
831: --{
832: IF l_debug_on THEN
833: 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);
834: END IF;
835:
836: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
837: (
832: IF l_debug_on THEN
833: 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);
834: END IF;
835:
836: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
837: (
838: p_in_rec => l_lpn_in_sync_comm_rec,
839: x_return_status => x_return_status,
840: x_out_rec => l_lpn_out_sync_comm_rec
841: );
842: --
843: --
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',x_return_status);
846: END IF;
847: --
848: --
849: IF ((x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
896: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
897: THEN
898: --{
899: IF l_debug_on THEN
900: 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);
901: END IF;
902:
903: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
904: (
899: IF l_debug_on THEN
900: 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);
901: END IF;
902:
903: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
904: (
905: p_in_rec => l_lpn_in_sync_comm_rec,
906: x_return_status => l_return_status,
907: x_out_rec => l_lpn_out_sync_comm_rec
908: );
909: --
910: --
911: IF l_debug_on THEN
912: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
913: END IF;
914: --
915: --
916: 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
938: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
939: THEN
940: --{
941: IF l_debug_on THEN
942: 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);
943: END IF;
944:
945: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
946: (
941: IF l_debug_on THEN
942: 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);
943: END IF;
944:
945: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
946: (
947: p_in_rec => l_lpn_in_sync_comm_rec,
948: x_return_status => l_return_status,
949: x_out_rec => l_lpn_out_sync_comm_rec
950: );
951: --
952: --
953: IF l_debug_on THEN
954: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
955: END IF;
956: --
957: --
958: --}
1299: THEN
1300: --{
1301:
1302: IF l_debug_on THEN
1303: 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);
1304: END IF;
1305: --
1306: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1307: (
1302: IF l_debug_on THEN
1303: 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);
1304: END IF;
1305: --
1306: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1307: (
1308: p_in_rec => l_lpn_in_sync_comm_rec,
1309: x_return_status => l_return_status,
1310: x_out_rec => l_lpn_out_sync_comm_rec
1311: );
1312: --
1313: --
1314: IF l_debug_on THEN
1315: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1316: END IF;
1317: --
1318: --
1319: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1357: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1358: THEN
1359: --{
1360: IF l_debug_on THEN
1361: 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);
1362: END IF;
1363:
1364: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1365: (
1360: IF l_debug_on THEN
1361: 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);
1362: END IF;
1363:
1364: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1365: (
1366: p_in_rec => l_lpn_in_sync_comm_rec,
1367: x_return_status => l_return_status,
1368: x_out_rec => l_lpn_out_sync_comm_rec
1369: );
1370: --
1371: --
1372: IF l_debug_on THEN
1373: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1374: END IF;
1375: --
1376: --
1377: 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
1403: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1404: THEN
1405: --{
1406: IF l_debug_on THEN
1407: 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);
1408: END IF;
1409:
1410: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1411: (
1406: IF l_debug_on THEN
1407: 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);
1408: END IF;
1409:
1410: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1411: (
1412: p_in_rec => l_lpn_in_sync_comm_rec,
1413: x_return_status => l_return_status,
1414: x_out_rec => l_lpn_out_sync_comm_rec
1415: );
1416: --
1417: --
1418: IF l_debug_on THEN
1419: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1420: END IF;
1421: --
1422: --
1423: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1449: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1450: THEN
1451: --{
1452: IF l_debug_on THEN
1453: 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);
1454: END IF;
1455:
1456: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1457: (
1452: IF l_debug_on THEN
1453: 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);
1454: END IF;
1455:
1456: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1457: (
1458: p_in_rec => l_lpn_in_sync_comm_rec,
1459: x_return_status => l_return_status,
1460: x_out_rec => l_lpn_out_sync_comm_rec
1461: );
1462: --
1463: --
1464: IF l_debug_on THEN
1465: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1466: END IF;
1467: --
1468: --
1469: --}
2471: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2472: THEN
2473: --{
2474: IF l_debug_on THEN
2475: 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);
2476: END IF;
2477:
2478: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2479: (
2474: IF l_debug_on THEN
2475: 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);
2476: END IF;
2477:
2478: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2479: (
2480: p_in_rec => l_lpn_in_sync_comm_rec,
2481: x_return_status => l_return_status,
2482: x_out_rec => l_lpn_out_sync_comm_rec
2483: );
2484: --
2485: --
2486: IF l_debug_on THEN
2487: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2488: END IF;
2489: --
2490: --
2491: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING)
2529: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2530: THEN
2531: --{
2532: IF l_debug_on THEN
2533: 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);
2534: END IF;
2535:
2536: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2537: (
2532: IF l_debug_on THEN
2533: 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);
2534: END IF;
2535:
2536: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2537: (
2538: p_in_rec => l_lpn_in_sync_comm_rec,
2539: x_return_status => l_return_status,
2540: x_out_rec => l_lpn_out_sync_comm_rec
2541: );
2542: --
2543: --
2544: IF l_debug_on THEN
2545: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2546: END IF;
2547: --
2548: --
2549: 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
2571: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
2572: THEN
2573: --{
2574: IF l_debug_on THEN
2575: 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);
2576: END IF;
2577:
2578: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2579: (
2574: IF l_debug_on THEN
2575: 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);
2576: END IF;
2577:
2578: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
2579: (
2580: p_in_rec => l_lpn_in_sync_comm_rec,
2581: x_return_status => l_return_status,
2582: x_out_rec => l_lpn_out_sync_comm_rec
2583: );
2584: --
2585: --
2586: IF l_debug_on THEN
2587: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
2588: END IF;
2589: --
2590: --
2591: --}