APPS.WSH_WMS_SYNC_TMP_PKG dependencies on WSH_WMS_SYNC_TMP_PKG

Line 1: PACKAGE BODY WSH_WMS_SYNC_TMP_PKG AS

1: PACKAGE BODY WSH_WMS_SYNC_TMP_PKG AS
2: /* $Header: WSHWSYTB.pls 120.1 2005/11/15 13:42:31 bsadri noship $ */
3:
4:
5: --

Line 10: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_WMS_SYNC_TMP_PKG';

6: --
7: --
8: --
9: --
10: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_WMS_SYNC_TMP_PKG';
11: --
12: PROCEDURE MERGE
13: (
14: p_sync_tmp_rec IN wsh_glbl_var_strct_grp.sync_tmp_rec_type,

Line 58: SAVEPOINT WSH_WMS_SYNC_TMP_PKG_MERGE;

54: WSH_DEBUG_SV.log(l_module_name, 'WSH_WMS_LPN_GRP.G_HW_TIME_STAMP', WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
55:
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

Line 143: ROLLBACK TO WSH_WMS_SYNC_TMP_PKG_MERGE;

139: EXCEPTION
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

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 211: SAVEPOINT WSH_WMS_SYNC_TMP_PKG_MRG_BULK;

207: WSH_DEBUG_SV.log(l_module_name, 'Count of Input Table ', p_sync_tmp_recTbl.delivery_detail_id_tbl.count);
208: WSH_DEBUG_SV.log(l_module_name, 'WSH_WMS_LPN_GRP.G_HW_TIME_STAMP', WSH_WMS_LPN_GRP.G_HW_TIME_STAMP);
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;

Line 413: ROLLBACK TO WSH_WMS_SYNC_TMP_PKG_MRG_BULK;

409: --{
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

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

Line 429: END WSH_WMS_SYNC_TMP_PKG;

425: END MERGE_BULK;
426:
427: --
428:
429: END WSH_WMS_SYNC_TMP_PKG;