APPS.WSH_WMS_SYNC_TMP_PKG dependencies on WSH_UTIL_CORE

Line 60: x_return_status := wsh_util_core.g_ret_sts_success;

56: END IF;
57: --
58: SAVEPOINT WSH_WMS_SYNC_TMP_PKG_MERGE;
59: --
60: x_return_status := wsh_util_core.g_ret_sts_success;
61:
62: IF (WSH_WMS_LPN_GRP.G_HW_TIME_STAMP IS NULL) THEN
63: WSH_WMS_LPN_GRP.G_HW_TIME_STAMP := sysdate;
64: END IF;

Line 127: x_return_status := wsh_util_core.g_ret_sts_error;

123: --
124: IF l_debug_on THEN
125: WSH_DEBUG_SV.log(l_module_name, 'Invalid Operation Type', p_sync_tmp_rec.operation_type);
126: END IF;
127: x_return_status := wsh_util_core.g_ret_sts_error;
128: --
129: --}
130: END IF;
131: --

Line 144: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

140: --{
141: --
142: WHEN OTHERS THEN
143: ROLLBACK TO WSH_WMS_SYNC_TMP_PKG_MERGE;
144: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
145: wsh_util_core.default_handler('WSH_WMS_SYNC_TMP_PKG.MERGE',l_module_name);
146: --
147: -- Debug Statements
148: --

Line 145: wsh_util_core.default_handler('WSH_WMS_SYNC_TMP_PKG.MERGE',l_module_name);

141: --
142: WHEN OTHERS THEN
143: ROLLBACK TO WSH_WMS_SYNC_TMP_PKG_MERGE;
144: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
145: wsh_util_core.default_handler('WSH_WMS_SYNC_TMP_PKG.MERGE',l_module_name);
146: --
147: -- Debug Statements
148: --
149: IF l_debug_on THEN

Line 213: x_return_status := wsh_util_core.g_ret_sts_success;

209: END IF;
210: --
211: SAVEPOINT WSH_WMS_SYNC_TMP_PKG_MRG_BULK;
212: --
213: x_return_status := wsh_util_core.g_ret_sts_success;
214: l_first := p_sync_tmp_recTbl.delivery_detail_id_tbl.first;
215: l_last := p_sync_tmp_recTbl.delivery_detail_id_tbl.last;
216: l_operation_type := nvl(p_operation_type,p_sync_tmp_recTbl.operation_type_tbl(l_first));
217: IF l_debug_on THEN

Line 291: x_return_status := wsh_util_core.g_ret_sts_error;

287: --
288: IF l_debug_on THEN
289: WSH_DEBUG_SV.log(l_module_name, 'Invalid Operation Type', l_operation_type);
290: END IF;
291: x_return_status := wsh_util_core.g_ret_sts_error;
292: --
293: --}
294: END IF;
295: */

Line 395: x_return_status := wsh_util_core.g_ret_sts_error;

391: --
392: IF l_debug_on THEN
393: WSH_DEBUG_SV.log(l_module_name, 'Invalid Operation Type', l_operation_type);
394: END IF;
395: x_return_status := wsh_util_core.g_ret_sts_error;
396: --
397: END IF;
398: --}
399: END IF;

Line 414: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

410: --
411: WHEN OTHERS THEN
412: --
413: ROLLBACK TO WSH_WMS_SYNC_TMP_PKG_MRG_BULK;
414: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
415: wsh_util_core.default_handler('WSH_WMS_SYNC_TMP_PKG.MERGE',l_module_name);
416: --
417: -- Debug Statements
418: --

Line 415: wsh_util_core.default_handler('WSH_WMS_SYNC_TMP_PKG.MERGE',l_module_name);

411: WHEN OTHERS THEN
412: --
413: ROLLBACK TO WSH_WMS_SYNC_TMP_PKG_MRG_BULK;
414: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
415: wsh_util_core.default_handler('WSH_WMS_SYNC_TMP_PKG.MERGE',l_module_name);
416: --
417: -- Debug Statements
418: --
419: IF l_debug_on THEN