APPS.WSH_DD_TXNS_PVT dependencies on WSH_DD_TXNS

Line 1: PACKAGE BODY WSH_DD_TXNS_PVT as

1: PACKAGE BODY WSH_DD_TXNS_PVT as
2: /* $Header: WSHDXTHB.pls 120.2 2006/06/07 08:19:06 alksharm noship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DD_TXN_PVT';
5: --

Line 45: INSERT INTO wsh_dd_txns

41: --
42:
43: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
44:
45: INSERT INTO wsh_dd_txns
46: (DD_TXN_ID,
47: DD_TXN_DATE,
48: DELIVERY_DETAIL_ID,
49: RELEASED_STATUS,

Line 78: (wsh_dd_txns_s.nextval, -- bug 5257141

74: LAST_UPDATE_DATE,
75: LAST_UPDATED_BY,
76: LAST_UPDATE_LOGIN)
77: VALUES
78: (wsh_dd_txns_s.nextval, -- bug 5257141
79: SYSDATE,
80: p_dd_txn_info.DELIVERY_DETAIL_ID,
81: p_dd_txn_info.RELEASED_STATUS,
82: p_dd_txn_info.REQUESTED_QUANTITY,

Line 120: wsh_util_core.default_handler('WSH_DD_TXNS_PVT.INSERT_DD_TXN',l_module_name);

116:
117: EXCEPTION
118:
119: WHEN others THEN
120: wsh_util_core.default_handler('WSH_DD_TXNS_PVT.INSERT_DD_TXN',l_module_name);
121: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
122: --
123: IF l_debug_on THEN
124: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 203: wsh_util_core.default_handler('WSH_DD_TXNS_PVT.Get_DD_Snapshot',l_module_name);

199:
200:
201: EXCEPTION
202: WHEN others THEN
203: wsh_util_core.default_handler('WSH_DD_TXNS_PVT.Get_DD_Snapshot',l_module_name);
204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
205: --
206: IF l_debug_on THEN
207: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 308: wsh_util_core.default_handler('WSH_DD_TXNS_PVT.create_dd_txn_from_dd',l_module_name);

304:
305: EXCEPTION
306:
307: WHEN others THEN
308: wsh_util_core.default_handler('WSH_DD_TXNS_PVT.create_dd_txn_from_dd',l_module_name);
309: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
310: --
311: IF l_debug_on THEN
312: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 319: END WSH_DD_TXNS_PVT;

315: --
316:
317: END create_dd_txn_from_dd;
318:
319: END WSH_DD_TXNS_PVT;