eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_DD_TXNS_PVT dependencies on WSH_UTIL_CORE

Line 43: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

39: WSH_DEBUG_SV.push(l_module_name); -- bug 4992250
40: END IF;
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,

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 121: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
125: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

176: WSH_DEBUG_SV.push(l_module_name);
177: WSH_DEBUG_SV.log(l_module_name,'p_delivery_detail_id',p_delivery_detail_id);
178: END IF;
179: --
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
181:
182:
183: OPEN c_dd_rec(p_delivery_detail_id);
184: FETCH c_dd_rec INTO ln_rec_info;

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 204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
208: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 247: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

243: WSH_DEBUG_SV.push(l_module_name);
244: WSH_DEBUG_SV.log(l_module_name,'p_delivery_detail_id',p_delivery_detail_id);
245: END IF;
246: --
247: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
248: --
249: -- Check if DBI is installed, possible values are Y or N only
250: -- If not installed, then do not proceed , return Success
251: IF (WSH_INTEGRATION.DBI_Installed = 'N')

Line 272: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

268: Get_DD_Snapshot (p_delivery_detail_id => l_delivery_detail_id,
269: x_dd_txn_info => l_dd_txn_info,
270: x_return_status => l_return_status);
271:
272: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
273: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.logmsg(l_module_name,' Error in Get_DD_Snapshot');
276: WSH_DEBUG_SV.pop(l_module_name); -- bug 4992250

Line 273: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

269: x_dd_txn_info => l_dd_txn_info,
270: x_return_status => l_return_status);
271:
272: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
273: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.logmsg(l_module_name,' Error in Get_DD_Snapshot');
276: WSH_DEBUG_SV.pop(l_module_name); -- bug 4992250
277: END IF;

Line 292: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

288: x_rowid => l_rowid,
289: x_dd_txn_id =>l_dd_txn_id,
290: x_return_status => l_return_status);
291:
292: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
293: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
294: IF l_debug_on THEN
295: WSH_DEBUG_SV.logmsg(l_module_name,' Error in Insert_DD_Txn');
296: WSH_DEBUG_SV.pop(l_module_name); -- bug 4992250

Line 293: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

289: x_dd_txn_id =>l_dd_txn_id,
290: x_return_status => l_return_status);
291:
292: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
293: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
294: IF l_debug_on THEN
295: WSH_DEBUG_SV.logmsg(l_module_name,' Error in Insert_DD_Txn');
296: WSH_DEBUG_SV.pop(l_module_name); -- bug 4992250
297: END IF;

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 309: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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);
313: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');