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_PO_INTEGRATION_GRP dependencies on WSH_UTIL_CORE

Line 67: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;

63: --
64: BEGIN
65:
66:
67: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
68: --
69: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
70: --
71: IF l_debug_on IS NULL

Line 144: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

140: END IF;
141: --
142: EXCEPTION
143: WHEN OTHERS THEN
144: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
145: WSH_UTIL_CORE.Default_Handler('WSH_PO_INTEGRATION_GRP.check_purge',l_module_name);
146: --
147: -- Debug Statements
148: --

Line 145: WSH_UTIL_CORE.Default_Handler('WSH_PO_INTEGRATION_GRP.check_purge',l_module_name);

141: --
142: EXCEPTION
143: WHEN OTHERS THEN
144: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
145: WSH_UTIL_CORE.Default_Handler('WSH_PO_INTEGRATION_GRP.check_purge',l_module_name);
146: --
147: -- Debug Statements
148: --
149: IF l_debug_on THEN

Line 201: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

197: l_api_version_number NUMBER := 1.0;
198: l_api_name CONSTANT VARCHAR2(30) := 'purge';
199: l_return_status VARCHAR2(1);
200:
201: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
202: l_dbi_rs VARCHAR2(1); -- DBI Project
203:
204: --
205: l_debug_on BOOLEAN;

Line 211: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;

207: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PURGE';
208: --
209: BEGIN
210:
211: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
212: --
213: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
214: --
215: IF l_debug_on IS NULL

Line 271: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

267:
268: IF l_debug_on THEN
269: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
270: END IF;
271: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
272: x_return_status := l_dbi_rs;
273: Rollback to PURGE_PVT;
274: -- just pass this return status to caller API
275: IF l_debug_on THEN

Line 305: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

301: EXCEPTION
302:
303: WHEN OTHERS THEN
304: ROLLBACK TO PURGE_PVT;
305: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
306: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
307: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.Purge',l_module_name);
308:
309: --

Line 306: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);

302:
303: WHEN OTHERS THEN
304: ROLLBACK TO PURGE_PVT;
305: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
306: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
307: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.Purge',l_module_name);
308:
309: --
310: -- Debug Statements

Line 307: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.Purge',l_module_name);

303: WHEN OTHERS THEN
304: ROLLBACK TO PURGE_PVT;
305: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
306: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
307: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.Purge',l_module_name);
308:
309: --
310: -- Debug Statements
311: --

Line 347: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;

343: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VENDOR_MERGE';
344: --
345: BEGIN
346: --
347: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
348: --
349: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
350: --
351: IF l_debug_on IS NULL

Line 391: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

387: --
388: EXCEPTION
389: --
390: WHEN OTHERS THEN
391: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
392: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
393: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.VENDOR_MERGE',l_module_name);
394: --
395: IF l_debug_on THEN

Line 392: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);

388: EXCEPTION
389: --
390: WHEN OTHERS THEN
391: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
392: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
393: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.VENDOR_MERGE',l_module_name);
394: --
395: IF l_debug_on THEN
396: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 393: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.VENDOR_MERGE',l_module_name);

389: --
390: WHEN OTHERS THEN
391: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
392: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
393: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.VENDOR_MERGE',l_module_name);
394: --
395: IF l_debug_on THEN
396: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 515: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

511: --
512: BEGIN
513: --
514: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
515: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
516: --
517: IF l_debug_on IS NULL THEN
518: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
519: END IF;

Line 617: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

613: EXCEPTION
614: --
615: WHEN FND_API.G_EXC_ERROR THEN
616: --
617: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
618: --
619: FND_MSG_PUB.Count_And_Get
620: (
621: p_count => x_msg_count,

Line 633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

629: END IF;
630: --
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: --
633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
634: --
635: FND_MSG_PUB.Count_And_Get
636: (
637: p_count => x_msg_count,

Line 650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

646: END IF;
647: --
648: WHEN OTHERS THEN
649: --
650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
651: --
652: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
653: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged',l_module_name);
654: --

Line 652: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);

648: WHEN OTHERS THEN
649: --
650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
651: --
652: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
653: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged',l_module_name);
654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '

Line 653: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged',l_module_name);

649: --
650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
651: --
652: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
653: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged',l_module_name);
654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
657: || ' Oracle error message is '

Line 763: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;

759: --
760:
761: BEGIN
762:
763: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS ;
764: --
765: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
766: --
767: IF l_debug_on IS NULL

Line 830: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);

826: WSH_DEBUG_SV.logmsg(l_module_name,' Invalid ShipFromLocation ID from PO');
827: END IF;
828: --
829: FND_MESSAGE.SET_NAME('WSH', 'WSH_IB_INVALID_WSH_LOC');
830: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
831: --
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: --

Line 858: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);

854: CLOSE open_line_without_sf_csr;
855: CLOSE open_line_with_sf_csr;
856: --
857: FND_MESSAGE.SET_NAME('WSH', 'WSH_IB_NO_OPEN_LINES');
858: WSH_UTIL_CORE.add_message (wsh_util_core.g_ret_sts_error,l_module_name);
859: --
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: CLOSE open_line_without_sf_csr;

Line 889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
887: --
888: x_out_rec.is_valid := FALSE;
889: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
890: --
891: FND_MSG_PUB.Count_And_Get
892: (
893: p_count => x_msg_count,

Line 906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

902: --
903: WHEN OTHERS THEN
904: --
905: x_out_rec.is_valid := FALSE;
906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
907: --
908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.validateASNReceiptShipFrom',l_module_name);
909: --
910: IF l_debug_on THEN

Line 908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.validateASNReceiptShipFrom',l_module_name);

904: --
905: x_out_rec.is_valid := FALSE;
906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
907: --
908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.validateASNReceiptShipFrom',l_module_name);
909: --
910: IF l_debug_on THEN
911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
912: || ' Oracle error message is '