DBA Data[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_WMS_SYNC_TMP_PKG

Line 2536: WSH_WMS_SYNC_TMP_PKG.MERGE

2532: THEN
2533: --{
2534: l_sync_tmp_rec.delivery_detail_id := l_cont_tab(i);
2535: l_sync_tmp_rec.operation_type := 'UPDATE';
2536: WSH_WMS_SYNC_TMP_PKG.MERGE
2537: (
2538: p_sync_tmp_rec => l_sync_tmp_rec,
2539: x_return_status => l_return_status
2540: );

Line 2543: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

2539: x_return_status => l_return_status
2540: );
2541:
2542: IF l_debug_on THEN
2543: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
2544: END IF;
2545: --
2546: --
2547: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 2772: WSH_WMS_SYNC_TMP_PKG.MERGE

2768: THEN
2769: --{
2770: l_sync_tmp_rec.delivery_detail_id := l_del_detail_rec(i);
2771: l_sync_tmp_rec.operation_type := 'UPDATE';
2772: WSH_WMS_SYNC_TMP_PKG.MERGE
2773: (
2774: p_sync_tmp_rec => l_sync_tmp_rec,
2775: x_return_status => l_return_status
2776: );

Line 2779: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

2775: x_return_status => l_return_status
2776: );
2777:
2778: IF l_debug_on THEN
2779: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
2780: END IF;
2781: --
2782: --
2783: --

Line 2873: WSH_WMS_SYNC_TMP_PKG.MERGE

2869: THEN
2870: --{
2871: l_sync_tmp_rec.delivery_detail_id := l_del_detail_rec(i);
2872: l_sync_tmp_rec.operation_type := 'UPDATE';
2873: WSH_WMS_SYNC_TMP_PKG.MERGE
2874: (
2875: p_sync_tmp_rec => l_sync_tmp_rec,
2876: x_return_status => l_return_status
2877: );

Line 2880: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

2876: x_return_status => l_return_status
2877: );
2878:
2879: IF l_debug_on THEN
2880: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
2881: END IF;
2882: --
2883: --
2884: --

Line 7213: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

7209: --{
7210: IF (WSH_WMS_LPN_GRP.GK_WMS_PACK and l_sync_tmp_wms_ddlist.delivery_detail_id_tbl.count > 0)
7211: THEN
7212: --{
7213: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7214: (
7215: p_sync_tmp_recTbl => l_sync_tmp_wms_ddlist,
7216: x_return_status => l_return_status
7217: );

Line 7220: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

7216: x_return_status => l_return_status
7217: );
7218:
7219: IF l_debug_on THEN
7220: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
7221: END IF;
7222: --
7223: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7224: x_return_status := l_return_status;

Line 7227: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');

7223: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7224: x_return_status := l_return_status;
7225: --
7226: IF l_debug_on THEN
7227: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');
7228: WSH_DEBUG_SV.pop(l_module_name);
7229: END IF;
7230: --
7231: RETURN;

Line 7241: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

7237: --}
7238: ELSIF (WSH_WMS_LPN_GRP.GK_INV_PACK and l_sync_tmp_inv_ddlist.delivery_detail_id_tbl.count > 0)
7239: THEN
7240: --{
7241: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7242: (
7243: p_sync_tmp_recTbl => l_sync_tmp_inv_ddlist,
7244: x_return_status => l_return_status
7245: );

Line 7248: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

7244: x_return_status => l_return_status
7245: );
7246:
7247: IF l_debug_on THEN
7248: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
7249: END IF;
7250: --
7251: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7252: x_return_status := l_return_status;

Line 7255: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');

7251: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7252: x_return_status := l_return_status;
7253: --
7254: IF l_debug_on THEN
7255: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');
7256: WSH_DEBUG_SV.pop(l_module_name);
7257: END IF;
7258: --
7259: RETURN;

Line 7366: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

7362: --{
7363: IF (WSH_WMS_LPN_GRP.GK_WMS_UPD_GRP and l_sync_tmp_wms_contlist.delivery_detail_id_tbl.count > 0)
7364: THEN
7365: --{
7366: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7367: (
7368: p_sync_tmp_recTbl => l_sync_tmp_wms_contlist,
7369: x_return_status => l_return_status
7370: );

Line 7373: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

7369: x_return_status => l_return_status
7370: );
7371:
7372: IF l_debug_on THEN
7373: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
7374: END IF;
7375: --
7376: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7377: x_return_status := l_return_status;

Line 7380: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');

7376: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7377: x_return_status := l_return_status;
7378: --
7379: IF l_debug_on THEN
7380: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');
7381: WSH_DEBUG_SV.pop(l_module_name);
7382: END IF;
7383: --
7384: RETURN;

Line 7394: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

7390: --}
7391: ELSIF (WSH_WMS_LPN_GRP.GK_INV_UPD_GRP and l_sync_tmp_inv_contlist.delivery_detail_id_tbl.count > 0)
7392: THEN
7393: --{
7394: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7395: (
7396: p_sync_tmp_recTbl => l_sync_tmp_inv_contlist,
7397: x_return_status => l_return_status
7398: );

Line 7401: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

7397: x_return_status => l_return_status
7398: );
7399:
7400: IF l_debug_on THEN
7401: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
7402: END IF;
7403: --
7404: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7405: x_return_status := l_return_status;

Line 7408: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');

7404: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7405: x_return_status := l_return_status;
7406: --
7407: IF l_debug_on THEN
7408: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');
7409: WSH_DEBUG_SV.pop(l_module_name);
7410: END IF;
7411: --
7412: RETURN;

Line 7495: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

7491: --{
7492: IF (WSH_WMS_LPN_GRP.GK_WMS_ASSIGN_DLVY and l_sync_tmp_wms_contlist1.delivery_detail_id_tbl.count > 0)
7493: THEN
7494: --{
7495: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7496: (
7497: p_sync_tmp_recTbl => l_sync_tmp_wms_contlist1,
7498: x_return_status => l_return_status
7499: );

Line 7502: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

7498: x_return_status => l_return_status
7499: );
7500:
7501: IF l_debug_on THEN
7502: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
7503: END IF;
7504: --
7505: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7506: x_return_status := l_return_status;

Line 7509: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');

7505: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7506: x_return_status := l_return_status;
7507: --
7508: IF l_debug_on THEN
7509: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');
7510: WSH_DEBUG_SV.pop(l_module_name);
7511: END IF;
7512: --
7513: RETURN;

Line 7523: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

7519: --}
7520: ELSIF (WSH_WMS_LPN_GRP.GK_INV_ASSIGN_DLVY and l_sync_tmp_inv_contlist1.delivery_detail_id_tbl.count > 0)
7521: THEN
7522: --{
7523: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
7524: (
7525: p_sync_tmp_recTbl => l_sync_tmp_inv_contlist1,
7526: x_return_status => l_return_status
7527: );

Line 7530: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

7526: x_return_status => l_return_status
7527: );
7528:
7529: IF l_debug_on THEN
7530: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
7531: END IF;
7532: --
7533: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7534: x_return_status := l_return_status;

Line 7537: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');

7533: IF l_return_status IN (C_UNEXP_ERROR_STATUS, C_ERROR_STATUS) THEN
7534: x_return_status := l_return_status;
7535: --
7536: IF l_debug_on THEN
7537: WSH_DEBUG_SV.logmsg(l_module_name,'Error occured in WSH_WMS_SYNC_TMP_PKG.MERGE_BULK');
7538: WSH_DEBUG_SV.pop(l_module_name);
7539: END IF;
7540: --
7541: RETURN;

Line 11508: WSH_WMS_SYNC_TMP_PKG.MERGE

11504: THEN
11505: --{
11506: l_sync_tmp_rec.delivery_detail_id := l_cont_instance_id;
11507: l_sync_tmp_rec.operation_type := 'UPDATE';
11508: WSH_WMS_SYNC_TMP_PKG.MERGE
11509: (
11510: p_sync_tmp_rec => l_sync_tmp_rec,
11511: x_return_status => l_return_status
11512: );

Line 11515: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

11511: x_return_status => l_return_status
11512: );
11513:
11514: IF l_debug_on THEN
11515: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
11516: END IF;
11517: --
11518: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
11519: --

Line 11526: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE completed with an error');

11522: ELSE
11523: --
11524: error_cnt := error_cnt + 1;
11525: IF l_debug_on THEN
11526: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE completed with an error');
11527: END IF;
11528: --
11529: END IF;
11530: --

Line 11865: WSH_WMS_SYNC_TMP_PKG.MERGE

11861: THEN
11862: --{
11863: l_sync_tmp_rec.delivery_detail_id := p_container_instance_id;
11864: l_sync_tmp_rec.operation_type := 'UPDATE';
11865: WSH_WMS_SYNC_TMP_PKG.MERGE
11866: (
11867: p_sync_tmp_rec => l_sync_tmp_rec,
11868: x_return_status => l_return_status
11869: );

Line 11872: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);

11868: x_return_status => l_return_status
11869: );
11870:
11871: IF l_debug_on THEN
11872: WSH_DEBUG_SV.log(l_module_name,'Return Status after calling WSH_WMS_SYNC_TMP_PKG.MERGE',l_return_status);
11873: END IF;
11874: --
11875: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
11876: --