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_FTE_INTEGRATION dependencies on WSH_FTE_INTEGRATION

Line 1: PACKAGE BODY WSH_FTE_INTEGRATION as

1: PACKAGE BODY WSH_FTE_INTEGRATION as
2: /* $Header: WSHFTEIB.pls 120.8.12000000.2 2007/02/15 00:54:23 parkhj ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FTE_INTEGRATION';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FTE_INTEGRATION';

1: PACKAGE BODY WSH_FTE_INTEGRATION as
2: /* $Header: WSHFTEIB.pls 120.8.12000000.2 2007/02/15 00:54:23 parkhj ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FTE_INTEGRATION';
6: --
7:
8: PROCEDURE Rate_Delivery (
9: p_api_version IN NUMBER DEFAULT 1.0,

Line 92: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Rate_Delivery',l_module_name);

88: EXCEPTION
89: WHEN others THEN
90: ROLLBACK TO WSH_Rate_Delivery;
91: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
92: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Rate_Delivery',l_module_name);
93: --
94: IF l_debug_on THEN
95: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
96: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 181: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);

177: EXCEPTION
178: WHEN others THEN
179: ROLLBACK TO WSH_Cancel_Service;
180: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
181: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
182: --
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 269: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);

265: EXCEPTION
266: WHEN others THEN
267: ROLLBACK TO WSH_Cancel_Service_2;
268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
269: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Cancel_Service',l_module_name);
270: --
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
273: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 345: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Shipment_Price_Consolidate',l_module_name);

341: EXCEPTION
342: WHEN others THEN
343: ROLLBACK TO before_changes;
344: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
345: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.Shipment_Price_Consolidate',l_module_name);
346: --
347: IF l_debug_on THEN
348: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
349: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 672: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.trip_stop_validations',l_module_name);

668: END IF;
669: --
670: EXCEPTION
671: WHEN OTHERS THEN
672: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.trip_stop_validations',l_module_name);
673: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
674: --
675: IF l_debug_on THEN
676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 752: --WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.get_cc_object_name');

748: EXCEPTION
749: WHEN OTHERS THEN
750: l_error_code := SQLCODE;
751: l_error_text := SQLERRM;
752: --WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.get_cc_object_name');
753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.get_cc_object_name IS ' ||L_ERROR_TEXT );
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 755: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.get_cc_object_name IS ' ||L_ERROR_TEXT );

751: l_error_text := SQLERRM;
752: --WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.get_cc_object_name');
753: --
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.get_cc_object_name IS ' ||L_ERROR_TEXT );
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
758: END IF;
759: --

Line 953: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.RATE_TRIP',l_module_name);

949: EXCEPTION
950: WHEN others THEN
951: ROLLBACK TO WSH_Rate_Trip;
952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
953: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.RATE_TRIP',l_module_name);
954: --
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
957: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1127: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.TRIP_ACTION',l_module_name);

1123: EXCEPTION
1124: WHEN others THEN
1125: ROLLBACK TO WSH_Trip_Action;
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1127: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.TRIP_ACTION',l_module_name);
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1140: PROCEDURE CARRIER_SELECTION( p_format_cs_tab IN OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_entity_tab_type,

1136: --
1137: -- SBAKSHI
1138: --
1139:
1140: PROCEDURE CARRIER_SELECTION( p_format_cs_tab IN OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_entity_tab_type,
1141: p_messaging_yn IN VARCHAR2,
1142: p_caller IN VARCHAR2,
1143: p_entity IN VARCHAR2,
1144: x_cs_output_tab OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_result_tab_type,

Line 1144: x_cs_output_tab OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_result_tab_type,

1140: PROCEDURE CARRIER_SELECTION( p_format_cs_tab IN OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_entity_tab_type,
1141: p_messaging_yn IN VARCHAR2,
1142: p_caller IN VARCHAR2,
1143: p_entity IN VARCHAR2,
1144: x_cs_output_tab OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_result_tab_type,
1145: x_cs_output_message_tab OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_output_message_tab,
1146: x_return_message OUT NOCOPY VARCHAR2,
1147: x_return_status OUT NOCOPY VARCHAR2) IS
1148:

Line 1145: x_cs_output_message_tab OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_output_message_tab,

1141: p_messaging_yn IN VARCHAR2,
1142: p_caller IN VARCHAR2,
1143: p_entity IN VARCHAR2,
1144: x_cs_output_tab OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_result_tab_type,
1145: x_cs_output_message_tab OUT NOCOPY WSH_FTE_INTEGRATION.wsh_cs_output_message_tab,
1146: x_return_message OUT NOCOPY VARCHAR2,
1147: x_return_status OUT NOCOPY VARCHAR2) IS
1148:
1149: --

Line 1324: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.CARRIER_SELECTION IS ' ||L_ERROR_TEXT );

1320: l_error_code := SQLCODE;
1321: l_error_text := SQLERRM;
1322: --
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.CARRIER_SELECTION IS ' ||L_ERROR_TEXT );
1325: END IF;
1326: --
1327: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.CARRIER_SELECTION');
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1327: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.CARRIER_SELECTION');

1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.CARRIER_SELECTION IS ' ||L_ERROR_TEXT );
1325: END IF;
1326: --
1327: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.CARRIER_SELECTION');
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1329: x_return_message := l_error_text;
1330: --
1331: IF l_debug_on THEN

Line 1424: -- Copy l_ranked_list to WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE

1420: p_ranklist => l_ranked_list,
1421: p_trip_id => p_trip_id,
1422: p_rank_id => l_rank_id);
1423:
1424: -- Copy l_ranked_list to WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE
1425:
1426: list_cnt := l_ranked_list.FIRST;
1427: IF list_cnt IS NOT NULL THEN
1428: LOOP

Line 1470: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.RANK_LIST_ACTION IS ' ||L_ERROR_TEXT );

1466: l_error_code := SQLCODE;
1467: l_error_text := SQLERRM;
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.RANK_LIST_ACTION IS ' ||L_ERROR_TEXT );
1471: END IF;
1472: --
1473: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.RANK_LIST_ACTION');
1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1473: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.RANK_LIST_ACTION');

1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.RANK_LIST_ACTION IS ' ||L_ERROR_TEXT );
1471: END IF;
1472: --
1473: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.RANK_LIST_ACTION');
1474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1475: x_msg_data := l_error_text;
1476: --
1477: IF l_debug_on THEN

Line 1555: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.GET_TRIP_MOVE IS ' ||L_ERROR_TEXT );

1551: l_error_code := SQLCODE;
1552: l_error_text := SQLERRM;
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.GET_TRIP_MOVE IS ' ||L_ERROR_TEXT );
1556: END IF;
1557: --
1558: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.GET_TRIP_MOVE');
1559: --

Line 1558: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.GET_TRIP_MOVE');

1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name, 'THE UNEXPECTED ERROR FROM WSH_FTE_INTEGRATION.GET_TRIP_MOVE IS ' ||L_ERROR_TEXT );
1556: END IF;
1557: --
1558: WSH_UTIL_CORE.default_handler('WSH_FTE_INTEGRATION.GET_TRIP_MOVE');
1559: --
1560: IF l_debug_on THEN
1561: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1562: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1573: -- p_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE

1569: -- ----------------------------------------------------------------------
1570: -- Procedure: CARRIER_SEL_CREATE_TRIP
1571: --
1572: -- Parameters: p_delivery_id Delivery ID
1573: -- p_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE
1574: -- x_trip_id Trip Id
1575: -- x_trip_name Trip Name
1576: -- x_return_message Return Message
1577: -- x_return_status Return Status

Line 1590: p_carrier_sel_result_rec IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE,

1586: --p_initial_pickup_loc_id IN NUMBER,
1587: --p_ultimate_dropoff_loc_id IN NUMBER,
1588: --p_initial_pickup_date IN DATE,
1589: --p_ultimate_dropoff_date IN DATE,
1590: p_carrier_sel_result_rec IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE,
1591: x_trip_id OUT NOCOPY NUMBER,
1592: x_trip_name OUT NOCOPY VARCHAR2,
1593: x_return_message OUT NOCOPY VARCHAR2,
1594: x_return_status OUT NOCOPY VARCHAR2

Line 1637: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP',l_module_name);

1633:
1634: EXCEPTION
1635:
1636: WHEN OTHERS THEN
1637: wsh_util_core.default_handler('WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP',l_module_name);
1638:
1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1640:
1641: IF l_debug_on THEN

Line 1740: 'WSH_FTE_INTEGRATION.GET_ORG_ORGANIZATION_INFO',

1736: WHEN OTHERS THEN
1737:
1738: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1739: wsh_util_core.default_handler(
1740: 'WSH_FTE_INTEGRATION.GET_ORG_ORGANIZATION_INFO',
1741: l_module_name);
1742:
1743: IF l_debug_on THEN
1744: WSH_DEBUG_SV.logmsg(l_module_name,

Line 1939: 'WSH_FTE_INTEGRATION.CREATE_RANK_LIST_BULK',

1935: WHEN OTHERS THEN
1936:
1937: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1938: wsh_util_core.default_handler(
1939: 'WSH_FTE_INTEGRATION.CREATE_RANK_LIST_BULK',
1940: l_module_name);
1941:
1942: IF l_debug_on THEN
1943: WSH_DEBUG_SV.logmsg(l_module_name,

Line 1954: END WSH_FTE_INTEGRATION;

1950:
1951: END CREATE_RANK_LIST_BULK;
1952:
1953:
1954: END WSH_FTE_INTEGRATION;