DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_WMS_SYNC_TMP_PKG

Line 3043: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

3039: l_sync_tmp_rec.delivery_id := l_del_id_for_detail.delivery_id;
3040: l_sync_tmp_rec.operation_type := 'PRIOR';
3041: --
3042: IF l_debug_on THEN
3043: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3044: END IF;
3045: --
3046: WSH_WMS_SYNC_TMP_PKG.MERGE
3047: (

Line 3046: WSH_WMS_SYNC_TMP_PKG.MERGE

3042: IF l_debug_on THEN
3043: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3044: END IF;
3045: --
3046: WSH_WMS_SYNC_TMP_PKG.MERGE
3047: (
3048: p_sync_tmp_rec => l_sync_tmp_rec,
3049: x_return_status => l_return_status
3050: );

Line 3154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

3150: l_sync_tmp_rec.delivery_id := l_del_id_for_detail.delivery_id;
3151: l_sync_tmp_rec.operation_type := 'PRIOR';
3152: --
3153: IF l_debug_on THEN
3154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3155: END IF;
3156: --
3157: WSH_WMS_SYNC_TMP_PKG.MERGE
3158: (

Line 3157: WSH_WMS_SYNC_TMP_PKG.MERGE

3153: IF l_debug_on THEN
3154: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3155: END IF;
3156: --
3157: WSH_WMS_SYNC_TMP_PKG.MERGE
3158: (
3159: p_sync_tmp_rec => l_sync_tmp_rec,
3160: x_return_status => l_return_status
3161: );

Line 3300: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

3296: THEN
3297: --{
3298: --
3299: IF l_debug_on THEN
3300: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
3301: END IF;
3302: --
3303: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
3304: (

Line 3303: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

3299: IF l_debug_on THEN
3300: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
3301: END IF;
3302: --
3303: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
3304: (
3305: p_sync_tmp_recTbl => l_sync_tmp_recTbl,
3306: x_return_status => l_return_status,
3307: p_operation_type => l_operation_type

Line 3704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

3700: l_sync_tmp_rec.delivery_id := l_del_rec.delivery_id;
3701: l_sync_tmp_rec.operation_type := 'PRIOR';
3702: --
3703: IF l_debug_on THEN
3704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3705: END IF;
3706: --
3707: WSH_WMS_SYNC_TMP_PKG.MERGE
3708: (

Line 3707: WSH_WMS_SYNC_TMP_PKG.MERGE

3703: IF l_debug_on THEN
3704: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
3705: END IF;
3706: --
3707: WSH_WMS_SYNC_TMP_PKG.MERGE
3708: (
3709: p_sync_tmp_rec => l_sync_tmp_rec,
3710: x_return_status => l_return_status
3711: );

Line 3716: WSH_DEBUG_SV.log(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE returned ',l_return_status);

3712:
3713: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
3714: THEN
3715: IF l_debug_on THEN
3716: WSH_DEBUG_SV.log(l_module_name,'WSH_WMS_SYNC_TMP_PKG.MERGE returned ',l_return_status);
3717: END IF;
3718: RAISE e_abort;
3719: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3720: l_num_warnings := l_num_warnings + 1;

Line 4387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

4383: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);
4384: l_sync_tmp_rec.operation_type := 'UPDATE';
4385: --
4386: IF l_debug_on THEN
4387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4388: END IF;
4389: --
4390: WSH_WMS_SYNC_TMP_PKG.MERGE
4391: (

Line 4390: WSH_WMS_SYNC_TMP_PKG.MERGE

4386: IF l_debug_on THEN
4387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4388: END IF;
4389: --
4390: WSH_WMS_SYNC_TMP_PKG.MERGE
4391: (
4392: p_sync_tmp_rec => l_sync_tmp_rec,
4393: x_return_status => l_return_status
4394: );

Line 4689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

4685: l_sync_tmp_rec.delivery_id := l_detail.delivery_id;
4686: l_sync_tmp_rec.operation_type := 'PRIOR';
4687: --
4688: IF l_debug_on THEN
4689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4690: END IF;
4691: --
4692: WSH_WMS_SYNC_TMP_PKG.MERGE
4693: (

Line 4692: WSH_WMS_SYNC_TMP_PKG.MERGE

4688: IF l_debug_on THEN
4689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
4690: END IF;
4691: --
4692: WSH_WMS_SYNC_TMP_PKG.MERGE
4693: (
4694: p_sync_tmp_rec => l_sync_tmp_rec,
4695: x_return_status => l_return_status
4696: );

Line 6016: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

6012: THEN
6013: --{
6014: --
6015: IF l_debug_on THEN
6016: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
6017: END IF;
6018: --
6019: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
6020: (

Line 6019: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

6015: IF l_debug_on THEN
6016: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
6017: END IF;
6018: --
6019: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
6020: (
6021: p_sync_tmp_recTbl => l_sync_tmp_recTbl,
6022: x_return_status => l_return_status,
6023: p_operation_type => l_operation_type

Line 6180: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);

6176: THEN
6177: --{
6178: --
6179: IF l_debug_on THEN
6180: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
6181: END IF;
6182: --
6183: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
6184: (

Line 6183: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK

6179: IF l_debug_on THEN
6180: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE_BULK',WSH_DEBUG_SV.C_PROC_LEVEL);
6181: END IF;
6182: --
6183: WSH_WMS_SYNC_TMP_PKG.MERGE_BULK
6184: (
6185: p_sync_tmp_recTbl => l_sync_tmp_recTbl,
6186: x_return_status => l_return_status,
6187: p_operation_type => l_operation_type

Line 6291: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

6287: l_sync_tmp_rec.delivery_id := l_del_id_FOR_container1.delivery_id;
6288: l_sync_tmp_rec.operation_type := 'PRIOR';
6289: --
6290: IF l_debug_on THEN
6291: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
6292: END IF;
6293: --
6294: WSH_WMS_SYNC_TMP_PKG.MERGE
6295: (

Line 6294: WSH_WMS_SYNC_TMP_PKG.MERGE

6290: IF l_debug_on THEN
6291: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
6292: END IF;
6293: --
6294: WSH_WMS_SYNC_TMP_PKG.MERGE
6295: (
6296: p_sync_tmp_rec => l_sync_tmp_rec,
6297: x_return_status => l_return_status
6298: );

Line 6955: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

6951: l_sync_tmp_rec.delivery_id := l_del_id_tbl(j);
6952: l_sync_tmp_rec.operation_type := 'PRIOR';
6953: --
6954: IF l_debug_on THEN
6955: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
6956: END IF;
6957: --
6958: WSH_WMS_SYNC_TMP_PKG.MERGE
6959: (

Line 6958: WSH_WMS_SYNC_TMP_PKG.MERGE

6954: IF l_debug_on THEN
6955: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
6956: END IF;
6957: --
6958: WSH_WMS_SYNC_TMP_PKG.MERGE
6959: (
6960: p_sync_tmp_rec => l_sync_tmp_rec,
6961: x_return_status => l_return_status
6962: );

Line 7058: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

7054: l_sync_tmp_rec.delivery_detail_id := l_dd_id(j);
7055: l_sync_tmp_rec.operation_type := 'UPDATE';
7056: --
7057: IF l_debug_on THEN
7058: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7059: END IF;
7060: --
7061: WSH_WMS_SYNC_TMP_PKG.MERGE
7062: (

Line 7061: WSH_WMS_SYNC_TMP_PKG.MERGE

7057: IF l_debug_on THEN
7058: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7059: END IF;
7060: --
7061: WSH_WMS_SYNC_TMP_PKG.MERGE
7062: (
7063: p_sync_tmp_rec => l_sync_tmp_rec,
7064: x_return_status => l_return_status
7065: );

Line 7310: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);

7306: l_sync_tmp_rec.delivery_id := l_assign.delivery_id;
7307: l_sync_tmp_rec.operation_type := 'PRIOR';
7308: --
7309: IF l_debug_on THEN
7310: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7311: END IF;
7312: --
7313: WSH_WMS_SYNC_TMP_PKG.MERGE
7314: (

Line 7313: WSH_WMS_SYNC_TMP_PKG.MERGE

7309: IF l_debug_on THEN
7310: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WMS_SYNC_TMP_PKG.MERGE',WSH_DEBUG_SV.C_PROC_LEVEL);
7311: END IF;
7312: --
7313: WSH_WMS_SYNC_TMP_PKG.MERGE
7314: (
7315: p_sync_tmp_rec => l_sync_tmp_rec,
7316: x_return_status => l_return_status
7317: );