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_INTERFACE dependencies on WSH_INTERFACE

Line 1: PACKAGE BODY WSH_INTERFACE as

1: PACKAGE BODY WSH_INTERFACE as
2: /* $Header: WSHDDINB.pls 120.6 2010/08/06 16:07:54 anvarshn ship $ */
3:
4: G_CALL_MODE VARCHAR2(6) := 'ONLINE'; -- global variable for PRINTMSG
5:

Line 8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INTERFACE';

4: G_CALL_MODE VARCHAR2(6) := 'ONLINE'; -- global variable for PRINTMSG
5:
6:
7: --
8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_INTERFACE';
9: --
10: -- anxsharm For Load Tender
11: -- Forward Declaration
12: PROCEDURE Get_Details_Snapshot(

Line 17: x_out_table OUT NOCOPY wsh_interface.deliverydetailtab,

13: p_source_code IN VARCHAR2,
14: p_changed_attributes IN ChangedAttributeTabType,
15: p_phase IN NUMBER,
16: x_dd_ids IN OUT NOCOPY wsh_util_core.id_tab_type,
17: x_out_table OUT NOCOPY wsh_interface.deliverydetailtab,
18: x_return_status OUT NOCOPY VARCHAR2);
19:
20: --
21:

Line 91: WSH_DEBUG_SV.logmsg(l_module_name, 'INSIDE WSH_INTERFACE.UPDATE_SHIPPING_ATTRIBUTES' );

87: --
88: -- Debug Statements
89: --
90: IF l_debug_on THEN
91: WSH_DEBUG_SV.logmsg(l_module_name, 'INSIDE WSH_INTERFACE.UPDATE_SHIPPING_ATTRIBUTES' );
92: END IF;
93: --
94:
95: Lock_Records(

Line 108: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_INTERFACE.LOCK_RECORDS BEFORE PROCESS_RECORDS ' || L_RS );

104: --
105: -- Debug Statements
106: --
107: IF l_debug_on THEN
108: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_INTERFACE.LOCK_RECORDS BEFORE PROCESS_RECORDS ' || L_RS );
109: END IF;
110: --
111: Process_Records(
112: p_source_code => p_source_code,

Line 120: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_INTERFACE.PROCESS_RECORDS ' || L_RS );

116: --
117: -- Debug Statements
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_INTERFACE.PROCESS_RECORDS ' || L_RS );
121: END IF;
122: --
123:
124: ELSIF (p_source_code = 'INV') THEN

Line 198: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_INTERFACE.PROCESS_RECORDS / UPDATE_INVENTORY_INFO' );

194: --
195: -- Debug Statements
196: --
197: IF l_debug_on THEN
198: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_INTERFACE.PROCESS_RECORDS / UPDATE_INVENTORY_INFO' );
199: END IF;
200: --
201: ROLLBACK TO before_changes;
202:

Line 350: wsh_util_core.default_handler('WSH_INTERFACE.Update_Shipping_Attributes');

346: --
347: WHEN others THEN
348: ROLLBACK TO before_changes;
349: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
350: wsh_util_core.default_handler('WSH_INTERFACE.Update_Shipping_Attributes');
351: --
352: --
353: -- Start code for Bugfix 4070732
354: --

Line 592: wsh_util_core.default_handler('WSH_INTERFACE.Get_In_Transit_Qty');

588: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_CUST_SITE');
589: END IF;
590: --
591: when others then
592: wsh_util_core.default_handler('WSH_INTERFACE.Get_In_Transit_Qty');
593: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
594: --
595: -- Debug Statements
596: --

Line 676: wsh_util_core.default_handler('WSH_INTERFACE.Get_In_Transit_Qty');

672: END IF;
673: --
674: exception
675: when others then
676: wsh_util_core.default_handler('WSH_INTERFACE.Get_In_Transit_Qty');
677: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
678: --
679: -- Debug Statements
680: --

Line 776: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);

772: --
773: -- Debug Statements
774: --
775: IF l_debug_on THEN
776: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);
777: END IF;
778: --
779: WSH_INTERFACE.PrintMsg('Import Delivery Details failed with unexpected error ' || SQLCODE);
780: --

Line 779: WSH_INTERFACE.PrintMsg('Import Delivery Details failed with unexpected error ' || SQLCODE);

775: IF l_debug_on THEN
776: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);
777: END IF;
778: --
779: WSH_INTERFACE.PrintMsg('Import Delivery Details failed with unexpected error ' || SQLCODE);
780: --
781: -- Debug Statements
782: --
783: IF l_debug_on THEN

Line 784: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);

780: --
781: -- Debug Statements
782: --
783: IF l_debug_on THEN
784: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);
785: END IF;
786: --
787: WSH_INTERFACE.PrintMsg('The unexpected error is ' || SQLERRM);
788: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

Line 787: WSH_INTERFACE.PrintMsg('The unexpected error is ' || SQLERRM);

783: IF l_debug_on THEN
784: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);
785: END IF;
786: --
787: WSH_INTERFACE.PrintMsg('The unexpected error is ' || SQLERRM);
788: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
789: errbuf := 'Import Delivery Details is completed with error';
790: retcode := '2';
791:

Line 881: wsh_util_core.default_handler('WSH_INTERFACE.Default_Container');

877: RETURN;
878: --
879: WHEN others THEN
880: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
881: wsh_util_core.default_handler('WSH_INTERFACE.Default_Container');
882:
883: --
884: -- Debug Statements
885: --

Line 1658: wsh_util_core.default_handler('WSH_INTERFACE.PROCESS_DETAILS');

1654: END IF;
1655: --
1656: WHEN OTHERS THEN
1657: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1658: wsh_util_core.default_handler('WSH_INTERFACE.PROCESS_DETAILS');
1659: IF l_debug_on THEN
1660: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1661: END IF;
1662: --

Line 1744: wsh_util_core.default_handler('WSH_INTERFACE.DELETE_DETAILS');

1740:
1741: EXCEPTION
1742: WHEN OTHERS THEN
1743: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1744: wsh_util_core.default_handler('WSH_INTERFACE.DELETE_DETAILS');
1745:
1746: IF l_debug_on THEN
1747: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1748: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1859: wsh_util_core.default_handler('WSH_INTERFACE.CANCEL_DETAILS');

1855:
1856: EXCEPTION
1857: WHEN OTHERS THEN
1858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1859: wsh_util_core.default_handler('WSH_INTERFACE.CANCEL_DETAILS');
1860: --
1861: -- Start code for Bugfix 4070732
1862: --
1863: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 2030: wsh_util_core.default_handler('WSH_INTERFACE.Get_Max_Load_Qty');

2026:
2027:
2028: WHEN others THEN
2029: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2030: wsh_util_core.default_handler('WSH_INTERFACE.Get_Max_Load_Qty');
2031:
2032: --
2033: -- Debug Statements
2034: --

Line 2110: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_INTERFACE.LOCK_RECORDS ' );

2106: --
2107: -- Debug Statements
2108: --
2109: IF l_debug_on THEN
2110: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_INTERFACE.LOCK_RECORDS ' );
2111: END IF;
2112: --
2113: --Standalone project
2114: l_standalone_mode := WMS_DEPLOY.Wms_Deployment_Mode;

Line 2265: wsh_util_core.default_handler('WSH_INTERFACE.Lock_Records');

2261: --
2262: EXCEPTION
2263: WHEN others THEN
2264: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2265: wsh_util_core.default_handler('WSH_INTERFACE.Lock_Records');
2266:
2267: --
2268: -- Debug Statements
2269: --

Line 2455: wsh_util_core.default_handler('WSH_INTERFACE.Lock_Delivery_Detail');

2451: RETURN;
2452:
2453: WHEN others THEN
2454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2455: wsh_util_core.default_handler('WSH_INTERFACE.Lock_Delivery_Detail');
2456:
2457: --
2458: -- Debug Statements
2459: --

Line 2509: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_INTERFACE.PROCESS_RECORDS' );

2505: --
2506: -- Debug Statements
2507: --
2508: IF l_debug_on THEN
2509: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_INTERFACE.PROCESS_RECORDS' );
2510: END IF;
2511: --
2512:
2513: --

Line 2695: wsh_util_core.default_handler('WSH_INTERFACE.Process_Records');

2691: --
2692: EXCEPTION
2693: WHEN OTHERS THEN
2694: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2695: wsh_util_core.default_handler('WSH_INTERFACE.Process_Records');
2696:
2697: --
2698: -- Debug Statements
2699: --

Line 2779: x_out_table OUT NOCOPY wsh_interface.deliverydetailtab,

2775: p_source_code IN VARCHAR2,
2776: p_changed_attributes IN ChangedAttributeTabType,
2777: p_phase IN NUMBER,
2778: x_dd_ids IN OUT NOCOPY wsh_util_core.id_tab_type,
2779: x_out_table OUT NOCOPY wsh_interface.deliverydetailtab,
2780: x_return_status OUT NOCOPY VARCHAR2) IS
2781:
2782: -- use delivery detail id
2783: CURSOR get_dd_for_id (v_delivery_detail_id NUMBER)IS

Line 2823: l_dd_rec wsh_interface.delivery_detail_rec;

2819: WHERE wdd.source_line_id = v_source_line_id
2820: AND wdd.delivery_detail_id = wda.delivery_detail_id
2821: AND nvl(wdd.line_direction, 'O') IN ('O', 'IO');
2822: i NUMBER;
2823: l_dd_rec wsh_interface.delivery_detail_rec;
2824: l_dd_tab wsh_interface.deliverydetailtab;
2825: l_dd_ids wsh_util_core.id_tab_type;
2826: l_source_line_id wsh_delivery_details.source_line_id%TYPE;
2827: --

Line 2824: l_dd_tab wsh_interface.deliverydetailtab;

2820: AND wdd.delivery_detail_id = wda.delivery_detail_id
2821: AND nvl(wdd.line_direction, 'O') IN ('O', 'IO');
2822: i NUMBER;
2823: l_dd_rec wsh_interface.delivery_detail_rec;
2824: l_dd_tab wsh_interface.deliverydetailtab;
2825: l_dd_ids wsh_util_core.id_tab_type;
2826: l_source_line_id wsh_delivery_details.source_line_id%TYPE;
2827: --
2828: l_debug_on BOOLEAN;

Line 2897: wsh_util_core.default_handler('WSH_INTERFACE.get_details_snapshot');

2893: END IF;
2894:
2895: EXCEPTION
2896: WHEN others THEN
2897: wsh_util_core.default_handler('WSH_INTERFACE.get_details_snapshot');
2898: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2899: IF l_debug_on THEN
2900: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2901: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2909: END WSH_INTERFACE;

2905: END Get_Details_Snapshot;
2906:
2907: -- anxsharm for Load Tender
2908:
2909: END WSH_INTERFACE;