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.0.12000000.3 2007/04/11 23:10:12 rvarghes 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: -- p_source_code should only be 'INV' or 'OE', else raise error. -- jckwok
112: -- 5870774: Added OKE since there will be cancellations initiated from OKE

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

127: --
128: -- Debug Statements
129: --
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_INTERFACE.PROCESS_RECORDS ' || L_RS );
132: END IF;
133: --
134:
135: ELSIF (p_source_code = 'INV') THEN

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

205: --
206: -- Debug Statements
207: --
208: IF l_debug_on THEN
209: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_INTERFACE.PROCESS_RECORDS / UPDATE_INVENTORY_INFO' );
210: END IF;
211: --
212: ROLLBACK TO before_changes;
213:

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

357: --
358: WHEN others THEN
359: ROLLBACK TO before_changes;
360: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
361: wsh_util_core.default_handler('WSH_INTERFACE.Update_Shipping_Attributes');
362: --
363: -- Start code for Bugfix 4070732
364: --
365: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

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

598: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_CUST_SITE');
599: END IF;
600: --
601: when others then
602: wsh_util_core.default_handler('WSH_INTERFACE.Get_In_Transit_Qty');
603: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
604: --
605: -- Debug Statements
606: --

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

682: END IF;
683: --
684: exception
685: when others then
686: wsh_util_core.default_handler('WSH_INTERFACE.Get_In_Transit_Qty');
687: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
688: --
689: -- Debug Statements
690: --

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

782: --
783: -- Debug Statements
784: --
785: IF l_debug_on THEN
786: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);
787: END IF;
788: --
789: WSH_INTERFACE.PrintMsg('Import Delivery Details failed with unexpected error ' || SQLCODE);
790: --

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

785: IF l_debug_on THEN
786: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);
787: END IF;
788: --
789: WSH_INTERFACE.PrintMsg('Import Delivery Details failed with unexpected error ' || SQLCODE);
790: --
791: -- Debug Statements
792: --
793: IF l_debug_on THEN

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

790: --
791: -- Debug Statements
792: --
793: IF l_debug_on THEN
794: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);
795: END IF;
796: --
797: WSH_INTERFACE.PrintMsg('The unexpected error is ' || SQLERRM);
798: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');

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

793: IF l_debug_on THEN
794: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INTERFACE.PRINTMSG',WSH_DEBUG_SV.C_PROC_LEVEL);
795: END IF;
796: --
797: WSH_INTERFACE.PrintMsg('The unexpected error is ' || SQLERRM);
798: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
799: errbuf := 'Import Delivery Details is completed with error';
800: retcode := '2';
801:

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

887: RETURN;
888: --
889: WHEN others THEN
890: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
891: wsh_util_core.default_handler('WSH_INTERFACE.Default_Container');
892:
893: --
894: -- Debug Statements
895: --

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

1664: END IF;
1665: --
1666: WHEN OTHERS THEN
1667: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1668: wsh_util_core.default_handler('WSH_INTERFACE.PROCESS_DETAILS');
1669: IF l_debug_on THEN
1670: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1671: END IF;
1672: --

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

1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN
1753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1754: wsh_util_core.default_handler('WSH_INTERFACE.DELETE_DETAILS');
1755:
1756: IF l_debug_on THEN
1757: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1758: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1865:
1866: EXCEPTION
1867: WHEN OTHERS THEN
1868: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1869: wsh_util_core.default_handler('WSH_INTERFACE.CANCEL_DETAILS');
1870: --
1871: -- Start code for Bugfix 4070732
1872: --
1873: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

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

2036:
2037:
2038: WHEN others THEN
2039: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2040: wsh_util_core.default_handler('WSH_INTERFACE.Get_Max_Load_Qty');
2041:
2042: --
2043: -- Debug Statements
2044: --

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

2103: --
2104: -- Debug Statements
2105: --
2106: IF l_debug_on THEN
2107: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_INTERFACE.LOCK_RECORDS ' );
2108: END IF;
2109: --
2110: <>
2111: FOR l_counter IN p_changed_attributes.FIRST .. p_changed_attributes.LAST LOOP

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

2193: --
2194: EXCEPTION
2195: WHEN others THEN
2196: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2197: wsh_util_core.default_handler('WSH_INTERFACE.Lock_Records');
2198:
2199: --
2200: -- Debug Statements
2201: --

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

2383: RETURN;
2384:
2385: WHEN others THEN
2386: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2387: wsh_util_core.default_handler('WSH_INTERFACE.Lock_Delivery_Detail');
2388:
2389: --
2390: -- Debug Statements
2391: --

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

2437: --
2438: -- Debug Statements
2439: --
2440: IF l_debug_on THEN
2441: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_INTERFACE.PROCESS_RECORDS' );
2442: END IF;
2443: --
2444:
2445: --

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

2604: --
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2608: wsh_util_core.default_handler('WSH_INTERFACE.Process_Records');
2609:
2610: --
2611: -- Debug Statements
2612: --

Line 2692: x_out_table OUT NOCOPY wsh_interface.deliverydetailtab,

2688: p_source_code IN VARCHAR2,
2689: p_changed_attributes IN ChangedAttributeTabType,
2690: p_phase IN NUMBER,
2691: x_dd_ids IN OUT NOCOPY wsh_util_core.id_tab_type,
2692: x_out_table OUT NOCOPY wsh_interface.deliverydetailtab,
2693: x_return_status OUT NOCOPY VARCHAR2) IS
2694:
2695: -- use delivery detail id
2696: CURSOR get_dd_for_id (v_delivery_detail_id NUMBER)IS

Line 2736: l_dd_rec wsh_interface.delivery_detail_rec;

2732: WHERE wdd.source_line_id = v_source_line_id
2733: AND wdd.delivery_detail_id = wda.delivery_detail_id
2734: AND nvl(wdd.line_direction, 'O') IN ('O', 'IO');
2735: i NUMBER;
2736: l_dd_rec wsh_interface.delivery_detail_rec;
2737: l_dd_tab wsh_interface.deliverydetailtab;
2738: l_dd_ids wsh_util_core.id_tab_type;
2739: l_source_line_id wsh_delivery_details.source_line_id%TYPE;
2740: --

Line 2737: l_dd_tab wsh_interface.deliverydetailtab;

2733: AND wdd.delivery_detail_id = wda.delivery_detail_id
2734: AND nvl(wdd.line_direction, 'O') IN ('O', 'IO');
2735: i NUMBER;
2736: l_dd_rec wsh_interface.delivery_detail_rec;
2737: l_dd_tab wsh_interface.deliverydetailtab;
2738: l_dd_ids wsh_util_core.id_tab_type;
2739: l_source_line_id wsh_delivery_details.source_line_id%TYPE;
2740: --
2741: l_debug_on BOOLEAN;

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

2806: END IF;
2807:
2808: EXCEPTION
2809: WHEN others THEN
2810: wsh_util_core.default_handler('WSH_INTERFACE.get_details_snapshot');
2811: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2812: IF l_debug_on THEN
2813: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2822: END WSH_INTERFACE;

2818: END Get_Details_Snapshot;
2819:
2820: -- anxsharm for Load Tender
2821:
2822: END WSH_INTERFACE;