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

Line 31: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

27:
28: PROCEDURE compare_trip_for_deliveries
29: (p_dleg_tab IN OUT NOCOPY TMS_DLEG_TAB_TYPE,
30: p_trip_id IN NUMBER,
31: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
32: --x_unassign_ver_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
33: x_return_status OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE process_internal_locations

Line 32: --x_unassign_ver_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

28: PROCEDURE compare_trip_for_deliveries
29: (p_dleg_tab IN OUT NOCOPY TMS_DLEG_TAB_TYPE,
30: p_trip_id IN NUMBER,
31: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
32: --x_unassign_ver_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
33: x_return_status OUT NOCOPY VARCHAR2);
34:
35: PROCEDURE process_internal_locations
36: (x_delivery_tab IN OUT NOCOPY TMS_DLEG_TAB_TYPE,

Line 1042: l_del_wti_tab WSH_UTIL_CORE.id_tab_type; -- OTM R12

1038: -- Variables to store information about various entities
1039: l_trip_info_tab tms_trip_tab_type;
1040: l_stop_info_tab tms_stop_tab_type;
1041: l_dleg_info_tab tms_dleg_tab_type;
1042: l_del_wti_tab WSH_UTIL_CORE.id_tab_type; -- OTM R12
1043:
1044: l_stop_local_tab tms_stop_tab_type;
1045: l_dleg_local_tab tms_dleg_tab_type;
1046:

Line 1048: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

1044: l_stop_local_tab tms_stop_tab_type;
1045: l_dleg_local_tab tms_dleg_tab_type;
1046:
1047: -- List of Delivery ids which are unassigned during the flow
1048: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1049: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1050: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1051: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1052: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 1049: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;

1045: l_dleg_local_tab tms_dleg_tab_type;
1046:
1047: -- List of Delivery ids which are unassigned during the flow
1048: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1049: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1050: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1051: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1052: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1053: l_unassigned_del_index NUMBER;

Line 1052: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1048: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1049: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1050: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1051: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1052: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1053: l_unassigned_del_index NUMBER;
1054:
1055: -- Populate Errors
1056: l_errors_tab interface_errors_tab_type;

Line 1063: l_stop_id_tab WSH_UTIL_CORE.id_tab_type;

1059: l_group_error_count NUMBER := 0;
1060:
1061: -- Variables to store(new) ids after creation
1062: l_trip_id NUMBER;
1063: l_stop_id_tab WSH_UTIL_CORE.id_tab_type;
1064:
1065: -- successful deliveries, used for freight costs and set in process_delivery section
1066: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1067: l_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;

Line 1066: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;

1062: l_trip_id NUMBER;
1063: l_stop_id_tab WSH_UTIL_CORE.id_tab_type;
1064:
1065: -- successful deliveries, used for freight costs and set in process_delivery section
1066: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1067: l_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1068:
1069: l_ret_code BOOLEAN;
1070: l_temp BOOLEAN;

Line 1067: l_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;

1063: l_stop_id_tab WSH_UTIL_CORE.id_tab_type;
1064:
1065: -- successful deliveries, used for freight costs and set in process_delivery section
1066: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1067: l_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1068:
1069: l_ret_code BOOLEAN;
1070: l_temp BOOLEAN;
1071: l_completion_status VARCHAR2(30);

Line 1077: l_upd_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;

1073: l_success_trips NUMBER;
1074: l_error_trips NUMBER;
1075:
1076: -- OTM R12 populate record structure to call update_tms_interface_flag
1077: l_upd_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1078: l_upd_dlvy_tms_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1079: -- OTM R12
1080: -- Bug#7491598(ER,defer planned shipment iface)
1081: l_del_pickup_date_low DATE;

Line 1078: l_upd_dlvy_tms_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1074: l_error_trips NUMBER;
1075:
1076: -- OTM R12 populate record structure to call update_tms_interface_flag
1077: l_upd_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1078: l_upd_dlvy_tms_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1079: -- OTM R12
1080: -- Bug#7491598(ER,defer planned shipment iface)
1081: l_del_pickup_date_low DATE;
1082: l_del_pickup_date_high DATE;

Line 1144: WSH_UTIL_CORE.PrintMsg(fnd_message.get);

1140: -- Check for p_group_id
1141: /*
1142: IF p_group_id IS NULL THEN
1143: FND_MESSAGE.SET_NAME('WSH','WSH_GROUP_ID_IS_REQUIRED');
1144: WSH_UTIL_CORE.PrintMsg(fnd_message.get);
1145: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1146: errbuf := 'Exception occurred in Release_Planned_Shipment';
1147: retcode := '2';
1148: IF l_debug_on THEN

Line 1145: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1141: /*
1142: IF p_group_id IS NULL THEN
1143: FND_MESSAGE.SET_NAME('WSH','WSH_GROUP_ID_IS_REQUIRED');
1144: WSH_UTIL_CORE.PrintMsg(fnd_message.get);
1145: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1146: errbuf := 'Exception occurred in Release_Planned_Shipment';
1147: retcode := '2';
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name, 'Group Id cannot be Null');

Line 1483: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_TRIP');
1482: FND_MESSAGE.SET_TOKEN('TRIP_NAME',WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id));
1483: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1484: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1485: IF l_debug_on THEN
1486: WSH_DEBUG_SV.log(l_module_name, 'trip not locked: l_return_status', l_return_status);
1487: END IF;

Line 1484: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1480: WHEN OTHERS THEN
1481: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_TRIP');
1482: FND_MESSAGE.SET_TOKEN('TRIP_NAME',WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id));
1483: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1484: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1485: IF l_debug_on THEN
1486: WSH_DEBUG_SV.log(l_module_name, 'trip not locked: l_return_status', l_return_status);
1487: END IF;
1488: GOTO trip_error;

Line 1512: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1508: EXCEPTION
1509: WHEN OTHERS THEN
1510: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_STOP');
1511: FND_MESSAGE.SET_TOKEN('STOP_NAME',WSH_TRIP_STOPS_PVT.get_name(l_stop_id,'FTE_TMS_INTEGRATION'));
1512: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1513: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.log(l_module_name, 'trip stop not locked: l_return_status', l_return_status);
1516: END IF;

Line 1513: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1509: WHEN OTHERS THEN
1510: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_STOP');
1511: FND_MESSAGE.SET_TOKEN('STOP_NAME',WSH_TRIP_STOPS_PVT.get_name(l_stop_id,'FTE_TMS_INTEGRATION'));
1512: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1513: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.log(l_module_name, 'trip stop not locked: l_return_status', l_return_status);
1516: END IF;
1517: GOTO trip_error;

Line 1544: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLEG');
1543: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1544: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1545: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1546: IF l_debug_on THEN
1547: WSH_DEBUG_SV.log(l_module_name, 'Delivery Leg not locked: l_return_status', l_return_status);
1548: END IF;

Line 1545: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1541: WHEN OTHERS THEN
1542: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLEG');
1543: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1544: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1545: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1546: IF l_debug_on THEN
1547: WSH_DEBUG_SV.log(l_module_name, 'Delivery Leg not locked: l_return_status', l_return_status);
1548: END IF;
1549: GOTO trip_error;

Line 1561: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLVY');
1560: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1561: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1562: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1563: IF l_debug_on THEN
1564: WSH_DEBUG_SV.log(l_module_name, 'Delivery not locked: l_return_status', l_return_status);
1565: END IF;

Line 1562: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1558: WHEN OTHERS THEN
1559: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLVY');
1560: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1561: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1562: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1563: IF l_debug_on THEN
1564: WSH_DEBUG_SV.log(l_module_name, 'Delivery not locked: l_return_status', l_return_status);
1565: END IF;
1566: GOTO trip_error;

Line 1589: l_organization_tab WSH_UTIL_CORE.id_tab_type;

1585: l_in_rec WSH_TRIPS_GRP.tripInRecType;
1586: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;
1587:
1588: l_stop_location_id NUMBER;
1589: l_organization_tab WSH_UTIL_CORE.id_tab_type;
1590:
1591: BEGIN--{
1592:
1593: -- try to lock the trip interface records

Line 1627: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1623: -- capture cases where stop_location_id is not a number
1624: -- special case, need to handle error a bit differently
1625: l_return_status := 'T';
1626: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1627: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1628: IF l_debug_on THEN
1629: WSH_DEBUG_SV.log(l_module_name, 'Invalid Stop Location, l_return_status:', l_return_status);
1630: END IF;
1631: GOTO trip_error;

Line 1639: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1635: END IF;
1636: END LOOP;--}
1637:
1638: IF l_stop_location_id IS NULL THEN
1639: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1640: l_return_status := 'T';
1641: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1642: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1643: IF l_debug_on THEN

Line 1642: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1638: IF l_stop_location_id IS NULL THEN
1639: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1640: l_return_status := 'T';
1641: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1642: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.log(l_module_name, 'Unable to Derive Stop Location', l_return_status);
1645: END IF;
1646: GOTO trip_error;

Line 1650: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_core.get_org_from_location:'||l_stop_location_id);

1646: GOTO trip_error;
1647: END IF;
1648:
1649: IF l_debug_on THEN
1650: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_core.get_org_from_location:'||l_stop_location_id);
1651: END IF;
1652: --get_org_from_location
1653: WSH_UTIL_CORE.get_org_from_location(
1654: p_location_id => l_stop_location_id,

Line 1653: WSH_UTIL_CORE.get_org_from_location(

1649: IF l_debug_on THEN
1650: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_core.get_org_from_location:'||l_stop_location_id);
1651: END IF;
1652: --get_org_from_location
1653: WSH_UTIL_CORE.get_org_from_location(
1654: p_location_id => l_stop_location_id,
1655: x_organization_tab => l_organization_tab,
1656: x_return_status => l_rs);
1657:

Line 1664: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR

1660: WSH_DEBUG_SV.logmsg(l_module_name,'Organizations Count:'||l_organization_tab.Count);
1661: END IF;
1662:
1663: --Bug 5931958. Added the OR condition l_organization_tab.COUNT = 0
1664: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR
1665: (l_organization_tab.COUNT = 0 ))THEN
1666: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1667: FND_MESSAGE.SET_NAME('WSH','WSH_LOC_ORG_UNDEFINED');
1668: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 1666: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1662:
1663: --Bug 5931958. Added the OR condition l_organization_tab.COUNT = 0
1664: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR
1665: (l_organization_tab.COUNT = 0 ))THEN
1666: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1667: FND_MESSAGE.SET_NAME('WSH','WSH_LOC_ORG_UNDEFINED');
1668: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1669: IF l_debug_on THEN
1670: WSH_DEBUG_SV.log(l_module_name, 'Error: Failed to get Organization from stop location id ',

Line 1668: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1664: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR
1665: (l_organization_tab.COUNT = 0 ))THEN
1666: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1667: FND_MESSAGE.SET_NAME('WSH','WSH_LOC_ORG_UNDEFINED');
1668: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1669: IF l_debug_on THEN
1670: WSH_DEBUG_SV.log(l_module_name, 'Error: Failed to get Organization from stop location id ',
1671: l_stop_location_id );
1672: END IF;

Line 1693: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1689: WSH_DEBUG_SV.logmsg(l_module_name,'return status:'||l_rs);
1690: WSH_DEBUG_SV.logmsg(l_module_name,'Vehicle Item id:'||l_trip_info_tab(i).vehicle_item_id);
1691: END IF;
1692:
1693: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1694: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1695: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
1696: FND_MESSAGE.SET_TOKEN('ITEM',l_trip_info_tab(i).vehicle_item_name);
1697: FND_MESSAGE.SET_TOKEN('ORGANIZATION',

Line 1694: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1690: WSH_DEBUG_SV.logmsg(l_module_name,'Vehicle Item id:'||l_trip_info_tab(i).vehicle_item_id);
1691: END IF;
1692:
1693: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1694: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1695: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
1696: FND_MESSAGE.SET_TOKEN('ITEM',l_trip_info_tab(i).vehicle_item_name);
1697: FND_MESSAGE.SET_TOKEN('ORGANIZATION',
1698: WSH_UTIL_CORE.get_org_name (p_organization_id =>l_organization_tab(l_organization_tab.FIRST)));

Line 1698: WSH_UTIL_CORE.get_org_name (p_organization_id =>l_organization_tab(l_organization_tab.FIRST)));

1694: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1695: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
1696: FND_MESSAGE.SET_TOKEN('ITEM',l_trip_info_tab(i).vehicle_item_name);
1697: FND_MESSAGE.SET_TOKEN('ORGANIZATION',
1698: WSH_UTIL_CORE.get_org_name (p_organization_id =>l_organization_tab(l_organization_tab.FIRST)));
1699: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.log(l_module_name, 'Validate Item Failed: l_return_status', l_return_status);
1702: END IF;

Line 1699: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1695: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
1696: FND_MESSAGE.SET_TOKEN('ITEM',l_trip_info_tab(i).vehicle_item_name);
1697: FND_MESSAGE.SET_TOKEN('ORGANIZATION',
1698: WSH_UTIL_CORE.get_org_name (p_organization_id =>l_organization_tab(l_organization_tab.FIRST)));
1699: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.log(l_module_name, 'Validate Item Failed: l_return_status', l_return_status);
1702: END IF;
1703: GOTO trip_error;

Line 1728: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

1724: IF l_trip_info_tab(i).interface_action_code = G_TMS_DELETE_CODE THEN--{
1725:
1726: DECLARE
1727: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
1728: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1729:
1730: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1731: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1732: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;

Line 1754: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1750: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after find_deliveries_for_trip'||l_rs);
1751: END IF;
1752:
1753: -- Handle return status here !!!
1754: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1755: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1756: IF l_debug_on THEN
1757: WSH_DEBUG_SV.log(l_module_name, 'Find Deliveries for Trip Failed,l_return_status:', l_return_status);
1758: END IF;

Line 1755: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1751: END IF;
1752:
1753: -- Handle return status here !!!
1754: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1755: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1756: IF l_debug_on THEN
1757: WSH_DEBUG_SV.log(l_module_name, 'Find Deliveries for Trip Failed,l_return_status:', l_return_status);
1758: END IF;
1759: GOTO trip_error;

Line 1809: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1805:
1806: IF l_debug_on THEN
1807: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
1808: END IF;
1809: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1810: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1811: IF l_debug_on THEN
1812: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery from Trip Failed: l_return_status', l_return_status);
1813: END IF;

Line 1810: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1806: IF l_debug_on THEN
1807: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
1808: END IF;
1809: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1810: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1811: IF l_debug_on THEN
1812: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery from Trip Failed: l_return_status', l_return_status);
1813: END IF;
1814: GOTO trip_error;

Line 1899: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1895: p_In_rec => l_in_rec,
1896: x_Out_tab => l_trip_output_tab);
1897:
1898:
1899: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1900: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1901: IF l_debug_on THEN
1902: WSH_DEBUG_SV.log(l_module_name, 'Create Update Trip Failed: l_return_status', l_return_status);
1903: END IF;

Line 1900: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1896: x_Out_tab => l_trip_output_tab);
1897:
1898:
1899: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1900: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1901: IF l_debug_on THEN
1902: WSH_DEBUG_SV.log(l_module_name, 'Create Update Trip Failed: l_return_status', l_return_status);
1903: END IF;
1904: GOTO trip_error;

Line 1934: l_stop_delete_tab WSH_UTIL_CORE.id_tab_type; -- stops to be deleted

1930:
1931: DECLARE
1932: -- Find Deliveries associated to a stop
1933: l_stop_matches VARCHAR2(1); -- stop sent by GC3 matches stop in EBS
1934: l_stop_delete_tab WSH_UTIL_CORE.id_tab_type; -- stops to be deleted
1935: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned
1936:
1937: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1938: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

Line 1935: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned

1931: DECLARE
1932: -- Find Deliveries associated to a stop
1933: l_stop_matches VARCHAR2(1); -- stop sent by GC3 matches stop in EBS
1934: l_stop_delete_tab WSH_UTIL_CORE.id_tab_type; -- stops to be deleted
1935: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned
1936:
1937: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1938: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1939: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;

Line 1982: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1978: -- capture cases where stop_location_id is not a number
1979: -- special case, need to handle error a bit differently
1980: l_return_status := 'T';
1981: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1982: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1983: IF l_debug_on THEN
1984: WSH_DEBUG_SV.log(l_module_name, 'Invalid Stop Location, l_return_status:', l_return_status);
1985: END IF;
1986: GOTO trip_error;

Line 1994: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

1990: WSH_UTIL_VALIDATE.VALIDATE_LOCATION
1991: (p_location_id =>l_location_id,
1992: x_return_status => l_rs);
1993:
1994: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1995: l_return_status := 'T';-- special case, need to handle error a bit differently
1996: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1997: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1998: IF l_debug_on THEN

Line 1997: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1993:
1994: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1995: l_return_status := 'T';-- special case, need to handle error a bit differently
1996: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1997: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1998: IF l_debug_on THEN
1999: WSH_DEBUG_SV.log(l_module_name, 'Invalid Stop Location, l_return_status:', l_return_status);
2000: END IF;
2001: GOTO trip_error;

Line 2107: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2103: x_internal_org_location_id => l_physical_loc_id,
2104: x_return_status => l_rs);
2105:
2106: -- Treat this also as Invalid Stop Location
2107: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2108: l_return_status := 'T';-- special case, need to handle error a bit differently
2109: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
2110: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2111: IF l_debug_on THEN

Line 2110: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

2106: -- Treat this also as Invalid Stop Location
2107: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2108: l_return_status := 'T';-- special case, need to handle error a bit differently
2109: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
2110: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2111: IF l_debug_on THEN
2112: WSH_DEBUG_SV.log(l_module_name, 'Invalid Stop Location, l_return_status:', l_return_status);
2113: END IF;
2114: GOTO trip_error;

Line 2270: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2266: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
2267: END IF;
2268:
2269: -- Handle error here !!!, should these deliveries be deleted from unassign table list??
2270: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2271: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2272: IF l_debug_on THEN
2273: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery Failed: l_return_status', l_return_status);
2274: END IF;

Line 2271: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2267: END IF;
2268:
2269: -- Handle error here !!!, should these deliveries be deleted from unassign table list??
2270: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2271: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2272: IF l_debug_on THEN
2273: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery Failed: l_return_status', l_return_status);
2274: END IF;
2275: GOTO trip_error;

Line 2301: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2297: -- Handle return status here, treat warning as success
2298: IF l_debug_on THEN
2299: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after deleting stop'||l_rs);
2300: END IF;
2301: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2302: -- go to trip_error
2303: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2304: IF l_debug_on THEN
2305: WSH_DEBUG_SV.log(l_module_name, 'Delete Trip Stop Failed: l_return_status', l_return_status);

Line 2303: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2299: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after deleting stop'||l_rs);
2300: END IF;
2301: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2302: -- go to trip_error
2303: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2304: IF l_debug_on THEN
2305: WSH_DEBUG_SV.log(l_module_name, 'Delete Trip Stop Failed: l_return_status', l_return_status);
2306: END IF;
2307: GOTO trip_error;

Line 2327: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2323: (x_delivery_tab => l_dleg_local_tab,
2324: x_stop_tab => l_stop_local_tab,
2325: x_return_status => l_rs);
2326:
2327: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2328: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.log(l_module_name, 'Process Internal Location, l_return_status:', l_return_status);
2331: END IF;

Line 2328: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2324: x_stop_tab => l_stop_local_tab,
2325: x_return_status => l_rs);
2326:
2327: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2328: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.log(l_module_name, 'Process Internal Location, l_return_status:', l_return_status);
2331: END IF;
2332: GOTO trip_error;

Line 2388: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2384: x_return_status => l_rs,
2385: x_msg_count => l_msg_count,
2386: x_msg_data => l_msg_data);
2387:
2388: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2389: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2390: IF l_debug_on THEN
2391: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Planned Arrival Date, l_return_status:', l_return_status);
2392: END IF;

Line 2389: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2385: x_msg_count => l_msg_count,
2386: x_msg_data => l_msg_data);
2387:
2388: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2389: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2390: IF l_debug_on THEN
2391: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Planned Arrival Date, l_return_status:', l_return_status);
2392: END IF;
2393: GOTO trip_error;

Line 2404: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2400: x_return_status => l_rs,
2401: x_msg_count => l_msg_count,
2402: x_msg_data => l_msg_data);
2403:
2404: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2405: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2406: IF l_debug_on THEN
2407: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Planned Arrival Date, l_return_status:', l_return_status);
2408: END IF;

Line 2405: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2401: x_msg_count => l_msg_count,
2402: x_msg_data => l_msg_data);
2403:
2404: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2405: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2406: IF l_debug_on THEN
2407: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Planned Arrival Date, l_return_status:', l_return_status);
2408: END IF;
2409: GOTO trip_error;

Line 2453: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2449: IF l_debug_on THEN
2450: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.GET_DEFAULT_UOMS'||l_rs);
2451: END IF;
2452: -- Handle return Status error!!!
2453: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2454: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.log(l_module_name, 'Get_Default_UOM failed: l_return_status', l_return_status);
2457: END IF;

Line 2454: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2450: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.GET_DEFAULT_UOMS'||l_rs);
2451: END IF;
2452: -- Handle return Status error!!!
2453: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2454: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2455: IF l_debug_on THEN
2456: WSH_DEBUG_SV.log(l_module_name, 'Get_Default_UOM failed: l_return_status', l_return_status);
2457: END IF;
2458: GOTO trip_error;

Line 2479: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2475: x_return_status => l_rs);
2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.GET_DEFAULT_UOMS'||l_rs);
2478: END IF;
2479: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2480: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2481: IF l_debug_on THEN
2482: WSH_DEBUG_SV.log(l_module_name, 'Get_Default_UOM Failed: l_return_status', l_return_status);
2483: END IF;

Line 2480: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.GET_DEFAULT_UOMS'||l_rs);
2478: END IF;
2479: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2480: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2481: IF l_debug_on THEN
2482: WSH_DEBUG_SV.log(l_module_name, 'Get_Default_UOM Failed: l_return_status', l_return_status);
2483: END IF;
2484: GOTO trip_error;

Line 2559: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2555: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab);
2556:
2557:
2558: -- Handle return status and error Here !!!
2559: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2560: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.log(l_module_name, 'Create Update Trip Stop Failed: l_return_status', l_return_status);
2563: END IF;

Line 2560: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2556:
2557:
2558: -- Handle return status and error Here !!!
2559: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2560: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.log(l_module_name, 'Create Update Trip Stop Failed: l_return_status', l_return_status);
2563: END IF;
2564: GOTO trip_error;

Line 2621: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2617: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_organization_id,
2618: x_param_info => l_shipping_parameters,
2619: x_return_status => l_rs);
2620:
2621: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2622: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2623: IF l_debug_on THEN
2624: WSH_DEBUG_SV.log(l_module_name, 'WSH_SHIPPING_PARAMS_PVT.GET Failed: l_return_status', l_return_status);
2625: END IF;

Line 2622: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2618: x_param_info => l_shipping_parameters,
2619: x_return_status => l_rs);
2620:
2621: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2622: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2623: IF l_debug_on THEN
2624: WSH_DEBUG_SV.log(l_module_name, 'WSH_SHIPPING_PARAMS_PVT.GET Failed: l_return_status', l_return_status);
2625: END IF;
2626: GOTO trip_error;

Line 2639: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2635: x_return_status => l_rs,
2636: x_msg_count => l_msg_count,
2637: x_msg_data => l_msg_data);
2638:
2639: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2640: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2641: IF l_debug_on THEN
2642: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Dock Door Appointment Start Time, l_return_status:', l_return_status);
2643: END IF;

Line 2640: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2636: x_msg_count => l_msg_count,
2637: x_msg_data => l_msg_data);
2638:
2639: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2640: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2641: IF l_debug_on THEN
2642: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Dock Door Appointment Start Time, l_return_status:', l_return_status);
2643: END IF;
2644: GOTO trip_error;

Line 2656: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2652: x_return_status => l_rs,
2653: x_msg_count => l_msg_count,
2654: x_msg_data => l_msg_data);
2655:
2656: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2657: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2658: IF l_debug_on THEN
2659: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Dock Door Appointment End Time, l_return_status:', l_return_status);
2660: END IF;

Line 2657: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2653: x_msg_count => l_msg_count,
2654: x_msg_data => l_msg_data);
2655:
2656: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2657: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2658: IF l_debug_on THEN
2659: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Dock Door Appointment End Time, l_return_status:', l_return_status);
2660: END IF;
2661: GOTO trip_error;

Line 2685: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2681: END IF; --} Checking WMS Org
2682: END IF; --} Checking l_organization_id as NULL
2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2686: IF l_debug_on THEN
2687: WSH_DEBUG_SV.log(l_module_name, 'Error while fetching Dock Door Appointment Scheduling Info.');
2688: END IF;
2689: IF (c_dock_appt_rec%ISOPEN) THEN

Line 2730: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

2726:
2727: DECLARE
2728:
2729: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
2730: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
2731:
2732: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2733: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2734: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;

Line 2745: l_del_index WSH_UTIL_CORE.id_tab_type;

2741: -- flag
2742: l_del_matches VARCHAR2(1);
2743:
2744: l_dleg_count NUMBER;
2745: l_del_index WSH_UTIL_CORE.id_tab_type;
2746:
2747: BEGIN--{
2748: l_delivery_id_tab.DELETE;
2749: l_del_attrs.DELETE;

Line 2770: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

2766: IF l_debug_on THEN
2767: WSH_DEBUG_SV.logmsg(l_module_name,'EBS and OTM version number donot match');
2768: END IF;
2769: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_NOT_UPD_VERSION_ERR');
2770: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2771: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;
2772: EXIT; -- out of this loop
2773: --}
2774: END IF;

Line 2771: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;

2767: WSH_DEBUG_SV.logmsg(l_module_name,'EBS and OTM version number donot match');
2768: END IF;
2769: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_NOT_UPD_VERSION_ERR');
2770: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2771: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;
2772: EXIT; -- out of this loop
2773: --}
2774: END IF;
2775: --

Line 2783: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

2779: IF l_debug_on THEN
2780: WSH_DEBUG_SV.logmsg(l_module_name,'EBS and OTM version number donot match');
2781: END IF;
2782: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_VERSION_ERROR');
2783: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2784: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;
2785: EXIT; -- out of this loop
2786: --}
2787: END IF;

Line 2784: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;

2780: WSH_DEBUG_SV.logmsg(l_module_name,'EBS and OTM version number donot match');
2781: END IF;
2782: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_VERSION_ERROR');
2783: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2784: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;
2785: EXIT; -- out of this loop
2786: --}
2787: END IF;
2788: --}

Line 2794: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2790: END LOOP;--}
2791: -- End of Bug 5134725
2792:
2793: -- Handle return status here !!!
2794: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2795: -- go to trip_error
2796: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2797: IF l_debug_on THEN
2798: WSH_DEBUG_SV.log(l_module_name, 'Version Comparison failed,l_return_status:', l_return_status);

Line 2796: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2792:
2793: -- Handle return status here !!!
2794: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2795: -- go to trip_error
2796: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2797: IF l_debug_on THEN
2798: WSH_DEBUG_SV.log(l_module_name, 'Version Comparison failed,l_return_status:', l_return_status);
2799: END IF;
2800: GOTO trip_error;

Line 2819: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2815: IF l_debug_on THEN
2816: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after find_deliveries_for_trip'||l_rs);
2817: END IF;
2818: -- Handle return status here !!!
2819: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2820: -- go to trip_error
2821: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2822: IF l_debug_on THEN
2823: WSH_DEBUG_SV.log(l_module_name, 'Find Deliveries for Trip Failed,l_return_status:', l_return_status);

Line 2821: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2817: END IF;
2818: -- Handle return status here !!!
2819: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2820: -- go to trip_error
2821: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2822: IF l_debug_on THEN
2823: WSH_DEBUG_SV.log(l_module_name, 'Find Deliveries for Trip Failed,l_return_status:', l_return_status);
2824: END IF;
2825: GOTO trip_error;

Line 2904: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2900:
2901: IF l_debug_on THEN
2902: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
2903: END IF;
2904: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2905: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery from Trip Failed: l_return_status', l_return_status);
2908: END IF;

Line 2905: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2901: IF l_debug_on THEN
2902: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
2903: END IF;
2904: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2905: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery from Trip Failed: l_return_status', l_return_status);
2908: END IF;
2909: GOTO trip_error;

Line 2932: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2928: IF l_debug_on THEN
2929: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Comparing Trips:'||l_rs);
2930: END IF;
2931: -- Handle return Status here !!!
2932: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2933: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2934: IF l_debug_on THEN
2935: WSH_DEBUG_SV.log(l_module_name, 'Compare Trip for Deliveries Failed: l_return_status', l_return_status);
2936: END IF;

Line 2933: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2929: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Comparing Trips:'||l_rs);
2930: END IF;
2931: -- Handle return Status here !!!
2932: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2933: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2934: IF l_debug_on THEN
2935: WSH_DEBUG_SV.log(l_module_name, 'Compare Trip for Deliveries Failed: l_return_status', l_return_status);
2936: END IF;
2937: GOTO trip_error;

Line 3070: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3066: IF l_debug_on THEN
3067: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Assign Delivery to Trip'||l_rs);
3068: END IF;
3069:
3070: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3071: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3072: IF l_debug_on THEN
3073: WSH_DEBUG_SV.log(l_module_name, 'Assign Delivery to Trip Failed: l_return_status', l_return_status);
3074: END IF;

Line 3071: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3067: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Assign Delivery to Trip'||l_rs);
3068: END IF;
3069:
3070: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3071: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3072: IF l_debug_on THEN
3073: WSH_DEBUG_SV.log(l_module_name, 'Assign Delivery to Trip Failed: l_return_status', l_return_status);
3074: END IF;
3075: GOTO trip_error;

Line 3076: ELSIF l_rs = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3072: IF l_debug_on THEN
3073: WSH_DEBUG_SV.log(l_module_name, 'Assign Delivery to Trip Failed: l_return_status', l_return_status);
3074: END IF;
3075: GOTO trip_error;
3076: ELSIF l_rs = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3077: l_dleg_local_tab(assign_count).processed_flag := 'Y';
3078: l_dlvy_id_tab(l_dlvy_id_tab.count + 1) := l_dleg_local_tab(assign_count).delivery_id;
3079: l_dlvy_version_tab(l_dlvy_id_tab.count) := l_dleg_local_tab(assign_count).tms_version_number;
3080: END IF;

Line 3156: l_dleg_id_tab WSH_UTIL_CORE.id_tab_type; -- for deleting Dleg freight cost

3152: l_carrier_cur_code VARCHAR2(15) := NULL;
3153: l_carrier_id NUMBER := NULL;
3154: l_count NUMBER := 0;
3155: l_frcost_type_id NUMBER := NULL;
3156: l_dleg_id_tab WSH_UTIL_CORE.id_tab_type; -- for deleting Dleg freight cost
3157: l_index NUMBER;
3158: --l_conversion_type_code VARCHAR2(30); -- OTM R12
3159: l_conversion_type_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE := NULL; -- OTM R12
3160:

Line 3240: WSH_UTIL_CORE.get_currency_conversion_type(

3236: END IF;
3237:
3238: -- OTM R12, start of Bug 5952842(5729276)
3239: IF l_conversion_type_code IS NULL THEN--{
3240: WSH_UTIL_CORE.get_currency_conversion_type(
3241: x_curr_conv_type => l_conversion_type_code,
3242: x_return_status => l_rs);
3243:
3244: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 3244: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3240: WSH_UTIL_CORE.get_currency_conversion_type(
3241: x_curr_conv_type => l_conversion_type_code,
3242: x_return_status => l_rs);
3243:
3244: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3245: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3246: IF l_debug_on THEN
3247: WSH_DEBUG_SV.log(l_module_name, 'get_currency_conversion_type Failed');
3248: END IF;

Line 3245: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3241: x_curr_conv_type => l_conversion_type_code,
3242: x_return_status => l_rs);
3243:
3244: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3245: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3246: IF l_debug_on THEN
3247: WSH_DEBUG_SV.log(l_module_name, 'get_currency_conversion_type Failed');
3248: END IF;
3249: GOTO trip_error;

Line 3280: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3276: END IF;
3277:
3278: -- OTM R12 check if carrier has a non-null currency
3279: IF c_get_currency_code%NOTFOUND THEN
3280: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3281: IF l_debug_on THEN
3282: WSH_DEBUG_SV.log(l_module_name, 'Carrier not found ');
3283: END IF;
3284: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_ID_NOT_FOUND');

Line 3285: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

3281: IF l_debug_on THEN
3282: WSH_DEBUG_SV.log(l_module_name, 'Carrier not found ');
3283: END IF;
3284: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_ID_NOT_FOUND');
3285: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3286: CLOSE c_get_currency_code;
3287: GOTO trip_error;
3288: ELSE
3289: WSH_UTIL_VALIDATE.Validate_Carrier(

Line 3298: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Carrier:',l_rs);
3296: END IF;
3297:
3298: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3299: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3300: IF l_debug_on THEN
3301: WSH_DEBUG_SV.log(l_module_name, 'Validate Carrier Failed: l_return_status', l_return_status);
3302: END IF;

Line 3299: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3295: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Carrier:',l_rs);
3296: END IF;
3297:
3298: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3299: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3300: IF l_debug_on THEN
3301: WSH_DEBUG_SV.log(l_module_name, 'Validate Carrier Failed: l_return_status', l_return_status);
3302: END IF;
3303: CLOSE c_get_currency_code;

Line 3310: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3306: END IF;
3307: CLOSE c_get_currency_code;
3308:
3309: IF l_carrier_cur_code IS NULL THEN
3310: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3311: IF l_debug_on THEN
3312: WSH_DEBUG_SV.log(l_module_name, 'Carrier Currency not defined ');
3313: END IF;
3314: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_NO_CURRENCY');

Line 3315: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

3311: IF l_debug_on THEN
3312: WSH_DEBUG_SV.log(l_module_name, 'Carrier Currency not defined ');
3313: END IF;
3314: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_NO_CURRENCY');
3315: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3316: GOTO trip_error;
3317: END IF;
3318:
3319: -- OTM R12 check if carrier has a non-null currency

Line 3338: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3334: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Currency:',l_rs);
3335: END IF;
3336: -- Handle error here !!!
3337: -- ECO 5008405 handle here !!!
3338: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3339: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3340: IF l_debug_on THEN
3341: WSH_DEBUG_SV.log(l_module_name, 'Validate Currency Failed: l_return_status', l_return_status);
3342: END IF;

Line 3339: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3335: END IF;
3336: -- Handle error here !!!
3337: -- ECO 5008405 handle here !!!
3338: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3339: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3340: IF l_debug_on THEN
3341: WSH_DEBUG_SV.log(l_module_name, 'Validate Currency Failed: l_return_status', l_return_status);
3342: END IF;
3343: GOTO trip_error;

Line 3443: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

3439: FND_MESSAGE.SET_NAME('WSH','WSH_CURR_CONV_ERROR');
3440: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_freight_info_tab(l_count).currency_code);
3441: FND_MESSAGE.SET_TOKEN('TO_CURR',l_carrier_cur_code);
3442: FND_MESSAGE.SET_TOKEN('CONV_TYPE',l_user_conv_type);-- Bug 5886042
3443: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3444: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3445: IF l_debug_on THEN
3446: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT'
3447: ||' failed no_rate', l_return_status);

Line 3444: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3440: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_freight_info_tab(l_count).currency_code);
3441: FND_MESSAGE.SET_TOKEN('TO_CURR',l_carrier_cur_code);
3442: FND_MESSAGE.SET_TOKEN('CONV_TYPE',l_user_conv_type);-- Bug 5886042
3443: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3444: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3445: IF l_debug_on THEN
3446: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT'
3447: ||' failed no_rate', l_return_status);
3448: END IF;

Line 3476: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

3472: FND_MESSAGE.SET_NAME('WSH','WSH_CURR_CONV_ERROR');
3473: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_freight_info_tab(l_count).currency_code);
3474: FND_MESSAGE.SET_TOKEN('TO_CURR',l_carrier_cur_code);
3475: FND_MESSAGE.SET_TOKEN('CONV_TYPE',l_user_conv_type);-- Bug 5886042
3476: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3477: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3478: IF l_debug_on THEN
3479: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT'
3480: ||' failed invalid_currency', l_return_status);

Line 3477: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3473: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_freight_info_tab(l_count).currency_code);
3474: FND_MESSAGE.SET_TOKEN('TO_CURR',l_carrier_cur_code);
3475: FND_MESSAGE.SET_TOKEN('CONV_TYPE',l_user_conv_type);-- Bug 5886042
3476: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3477: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3478: IF l_debug_on THEN
3479: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT'
3480: ||' failed invalid_currency', l_return_status);
3481: END IF;

Line 3486: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3482: GOTO trip_error;
3483:
3484: -- OTM R12 end
3485: WHEN gl_currency_excp THEN
3486: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3487: IF l_debug_on THEN
3488: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT returned NULL :', l_return_status);
3489: END IF;
3490: GOTO trip_error;

Line 3493: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3489: END IF;
3490: GOTO trip_error;
3491:
3492: WHEN OTHERS THEN
3493: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3494: IF l_debug_on THEN
3495: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT failed:', l_return_status);
3496: END IF;
3497: GOTO trip_error;

Line 3538: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3534: IF l_debug_on THEN
3535: WSH_DEBUG_SV.logmsg(l_module_name, 'Return Status after Create Freight Cost:'||l_rs);
3536: END IF;
3537:
3538: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3539: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3540: IF l_debug_on THEN
3541: WSH_DEBUG_SV.log(l_module_name, 'Create_Update_Freight_Costs Failed: l_return_status', l_return_status);
3542: END IF;

Line 3539: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3535: WSH_DEBUG_SV.logmsg(l_module_name, 'Return Status after Create Freight Cost:'||l_rs);
3536: END IF;
3537:
3538: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3539: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3540: IF l_debug_on THEN
3541: WSH_DEBUG_SV.log(l_module_name, 'Create_Update_Freight_Costs Failed: l_return_status', l_return_status);
3542: END IF;
3543: EXIT; -- need to exit out of the parent loop also!!!

Line 3552: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

3548:
3549: END IF;--}-- only if freight cost record has currency
3550:
3551: END LOOP;--}-- loop across freight_costs_interface table
3552: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3553: EXIT; -- need to exit out of the parent loop also!!!
3554: -- OTM R12 will never reach this GOTO and GOTO not required as the immediate next section is trip_error
3555: --GOTO trip_error;
3556: END IF;

Line 3589: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3585: AND wnd.delivery_id = wda.delivery_id
3586: AND wda.delivery_detail_id = wdd.delivery_detail_id
3587: FOR UPDATE OF wnd.loading_sequence, wdd.load_seq_number NOWAIT;
3588:
3589: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3590: l_del_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3591: l_loading_sequence NUMBER := 0;
3592: l_stop_id_rec NUMBER;
3593:

Line 3590: l_del_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3586: AND wda.delivery_detail_id = wdd.delivery_detail_id
3587: FOR UPDATE OF wnd.loading_sequence, wdd.load_seq_number NOWAIT;
3588:
3589: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3590: l_del_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3591: l_loading_sequence NUMBER := 0;
3592: l_stop_id_rec NUMBER;
3593:
3594: BEGIN

Line 3636: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3632: END LOOP;
3633:
3634: EXCEPTION
3635: WHEN OTHERS THEN
3636: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3637: IF c_lock_deliveries_and_details%ISOPEN then
3638: CLOSE c_lock_deliveries_and_details;
3639: END IF;
3640: IF l_debug_on THEN

Line 3666: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3662: x_msg_data => l_msg_data);
3663: IF l_debug_on THEN
3664: WSH_DEBUG_SV.log(l_module_name, 'wms_dock_appointments_pub.OTM_Dock_Appointment: Return Status', l_rs);
3665: END IF;
3666: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3667: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3668: FOR l_err_msg IN 1..l_msg_count LOOP
3669: l_message := fnd_msg_pub.get(l_err_msg,'F');
3670: l_message := replace(l_message,chr(0),' ');

Line 3667: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3663: IF l_debug_on THEN
3664: WSH_DEBUG_SV.log(l_module_name, 'wms_dock_appointments_pub.OTM_Dock_Appointment: Return Status', l_rs);
3665: END IF;
3666: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3667: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3668: FOR l_err_msg IN 1..l_msg_count LOOP
3669: l_message := fnd_msg_pub.get(l_err_msg,'F');
3670: l_message := replace(l_message,chr(0),' ');
3671: IF l_debug_on THEN

Line 3677: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

3673: END IF;
3674: END LOOP;
3675: fnd_msg_pub.delete_msg();
3676: FND_MESSAGE.SET_NAME('WSH','WSH_DOCK_SCHED_ERROR');
3677: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3678: GOTO trip_error;
3679: END IF;
3680: END IF; --} l_dock_appt_tab.COUNT > 0
3681: EXCEPTION

Line 3683: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3679: END IF;
3680: END IF; --} l_dock_appt_tab.COUNT > 0
3681: EXCEPTION
3682: WHEN OTHERS THEN
3683: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3684: IF l_debug_on THEN
3685: WSH_DEBUG_SV.log(l_module_name, 'Error while calling wms_dock_appointments_pub.OTM_Dock_Appointment' || SQLERRM);
3686: END IF;
3687: GOTO trip_error;

Line 3721: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,'T') THEN --{

3717: -- Status of T is for special case of Invalid Location for Trip Stop
3718: -- For Invalid Location error, donot insert records in error table,
3719: -- Only Log Delivery Level Error exceptions and purge the data from
3720: -- Interface tables
3721: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,'T') THEN --{
3722: --IF l_errors_tab.count > 0 THEN
3723: IF l_debug_on THEN
3724: WSH_DEBUG_SV.logmsg(l_module_name,'Rollback.....' );
3725: END IF;

Line 3758: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3754: WSH_DEBUG_SV.logmsg(l_module_name,'After Purging the Interface Data:'||l_rs );
3755: END IF;
3756:
3757: -- OTM R12
3758: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3759: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3760: IF l_debug_on THEN
3761: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3762: END IF;

Line 3759: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3755: END IF;
3756:
3757: -- OTM R12
3758: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3759: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3760: IF l_debug_on THEN
3761: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3762: END IF;
3763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3771: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN--{

3767: END IF;--}
3768:
3769: -- For Delete Shipment Cases, there will not be any delivery level information
3770: IF l_dleg_local_tab.count > 0 THEN--{
3771: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN--{
3772:
3773: -- Insert record in wsh_interface_errors table
3774: -- Generic error message is to be logged against all deliveries
3775: -- Handled in stamp_interface_errors

Line 3790: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3786: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Stamp_Interface_error'||l_rs);
3787: END IF;
3788:
3789: -- OTM R12
3790: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3791: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3792: IF l_debug_on THEN
3793: WSH_DEBUG_SV.log(l_module_name, 'stamp_interface_error Failed');
3794: END IF;

Line 3791: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3787: END IF;
3788:
3789: -- OTM R12
3790: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3791: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3792: IF l_debug_on THEN
3793: WSH_DEBUG_SV.log(l_module_name, 'stamp_interface_error Failed');
3794: END IF;
3795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3840: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3836: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Log_exception'||l_rs);
3837: END IF;
3838:
3839: -- OTM R12
3840: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3841: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3842: IF l_debug_on THEN
3843: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.log_exception Failed');
3844: END IF;

Line 3841: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3837: END IF;
3838:
3839: -- OTM R12
3840: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3841: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3842: IF l_debug_on THEN
3843: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.log_exception Failed');
3844: END IF;
3845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3903: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3899: IF l_debug_on THEN
3900: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after WSH_XC_UTIL.Purge' || l_rs);
3901: END IF;
3902: -- OTM R12
3903: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3904: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3905: IF l_debug_on THEN
3906: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.Purge Failed');
3907: END IF;

Line 3904: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3900: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after WSH_XC_UTIL.Purge' || l_rs);
3901: END IF;
3902: -- OTM R12
3903: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3904: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3905: IF l_debug_on THEN
3906: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.Purge Failed');
3907: END IF;
3908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3945: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3941: IF l_debug_on THEN
3942: WSH_DEBUG_SV.logmsg(l_module_name,'After Purging the Interface Data:'||l_rs );
3943: END IF;
3944:
3945: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3946: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3947: IF l_debug_on THEN
3948: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3949: END IF;

Line 3946: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3942: WSH_DEBUG_SV.logmsg(l_module_name,'After Purging the Interface Data:'||l_rs );
3943: END IF;
3944:
3945: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3946: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3947: IF l_debug_on THEN
3948: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3949: END IF;
3950: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3989: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

3985: x_delivery_rec => l_delivery_info,
3986: x_return_status => l_return_status);
3987:
3988: -- OTM R12
3989: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3990: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3991: IF l_debug_on THEN
3992: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');
3993: END IF;

Line 3990: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3986: x_return_status => l_return_status);
3987:
3988: -- OTM R12
3989: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3990: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3991: IF l_debug_on THEN
3992: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');
3993: END IF;
3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4035: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

4031:
4032: IF l_debug_on THEN
4033: WSH_DEBUG_SV.log(l_module_name, 'update_tms_interface_flag : l_return_status : ', l_return_status);
4034: END IF;
4035: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4036: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4037: ROLLBACK TO process_group;
4038: l_completion_status := 'WARNING';
4039: --l_completion_status := 'ERROR';

Line 4036: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4032: IF l_debug_on THEN
4033: WSH_DEBUG_SV.log(l_module_name, 'update_tms_interface_flag : l_return_status : ', l_return_status);
4034: END IF;
4035: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4036: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4037: ROLLBACK TO process_group;
4038: l_completion_status := 'WARNING';
4039: --l_completion_status := 'ERROR';
4040: ELSE

Line 4166: WSH_UTIL_CORE.DEFAULT_HANDLER(

4162: l_ret_code := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
4163: errbuf := 'Exception occurred in Release_Planned_Shipment';
4164: retcode := '2';
4165: --
4166: WSH_UTIL_CORE.DEFAULT_HANDLER(
4167: 'WSH_TMS_RELEASE.RELEASE_PLANNED_SHIPMENT',
4168: l_module_name);
4169: IF l_debug_on THEN
4170: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4215: l_trip_interface_id_tab WSH_UTIL_CORE.id_tab_type;

4211: WHERE wti.tp_plan_name = p_tp_plan_name
4212: AND wti.interface_action_code = G_TMS_RELEASE_CODE;
4213:
4214: l_trip_interface_id NUMBER;
4215: l_trip_interface_id_tab WSH_UTIL_CORE.id_tab_type;
4216:
4217: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PURGE_INTERFACE_DATA';
4218: --
4219: l_debug_on BOOLEAN;

Line 4237: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4233: WSH_DEBUG_SV.log(l_module_name,'p_commit_flag:', p_commit_flag);
4234: WSH_DEBUG_SV.log(l_module_name,'p_exception_action:', p_exception_action);
4235: END IF;
4236:
4237: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4238:
4239: SAVEPOINT BEFORE_PURGE;
4240:
4241: -- Derive the trip_interface_id

Line 4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4427: WHEN OTHERS THEN
4428: IF c_get_interface_id%ISOPEN THEN
4429: CLOSE c_get_interface_id;
4430: END IF;
4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4432: ROLLBACK to before_purge;
4433: WSH_UTIL_CORE.DEFAULT_HANDLER(
4434: 'WSH_TMS_RELEASE.PURGE_INTERFACE_DATA',
4435: l_module_name);

Line 4433: WSH_UTIL_CORE.DEFAULT_HANDLER(

4429: CLOSE c_get_interface_id;
4430: END IF;
4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4432: ROLLBACK to before_purge;
4433: WSH_UTIL_CORE.DEFAULT_HANDLER(
4434: 'WSH_TMS_RELEASE.PURGE_INTERFACE_DATA',
4435: l_module_name);
4436: IF l_debug_on THEN
4437: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4502: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;

4498: l_buffer VARCHAR2(4000);
4499: l_index_out NUMBER;
4500:
4501: --
4502: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;
4503: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4504: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;
4505: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4506: l_messages text_tab_type;

Line 4503: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;

4499: l_index_out NUMBER;
4500:
4501: --
4502: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;
4503: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4504: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;
4505: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4506: l_messages text_tab_type;
4507:

Line 4504: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;

4500:
4501: --
4502: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;
4503: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4504: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;
4505: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4506: l_messages text_tab_type;
4507:
4508: l_message VARCHAR2(4000);

Line 4505: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;

4501: --
4502: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;
4503: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4504: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;
4505: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4506: l_messages text_tab_type;
4507:
4508: l_message VARCHAR2(4000);
4509: l_message_name VARCHAR2(30);

Line 4511: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;

4507:
4508: l_message VARCHAR2(4000);
4509: l_message_name VARCHAR2(30);
4510: l_dleg_tab tms_dleg_tab_type;
4511: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
4512:
4513: l_msg_data VARCHAR2(240);
4514:
4515: BEGIN

Line 4542: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4538: WSH_DEBUG_SV.log(l_module_name,'p_token_4_value', p_token_4_value);
4539: WSH_DEBUG_SV.logmsg(l_module_name,'Count of Input Deliveries:'||p_dleg_tab.count);
4540: END IF;
4541:
4542: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4543:
4544: l_index := x_errors_tab.COUNT + 1;
4545:
4546: IF p_message_text IS NULL THEN --{

Line 4663: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4659: END IF;
4660:
4661: EXCEPTION
4662: WHEN OTHERS THEN
4663: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4664: WSH_UTIL_CORE.DEFAULT_HANDLER(
4665: 'WSH_TMS_RELEASE.STAMP_INTERFACE_ERROR',
4666: l_module_name);
4667: IF l_debug_on THEN

Line 4664: WSH_UTIL_CORE.DEFAULT_HANDLER(

4660:
4661: EXCEPTION
4662: WHEN OTHERS THEN
4663: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4664: WSH_UTIL_CORE.DEFAULT_HANDLER(
4665: 'WSH_TMS_RELEASE.STAMP_INTERFACE_ERROR',
4666: l_module_name);
4667: IF l_debug_on THEN
4668: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4685: x_delivery_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

4681: PROCEDURE find_deliveries_for_trip(
4682: p_trip_id IN NUMBER,
4683: p_tp_plan_name IN VARCHAR2,
4684: x_delivery_tab OUT NOCOPY WSH_TMS_RELEASE.delivery_tab,
4685: x_delivery_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4686: x_return_status OUT NOCOPY VARCHAR2) IS
4687:
4688: -- Query deliveries based on p_trip_id
4689: CURSOR c_get_deliveries1 IS

Line 4739: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4735: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name:', p_tp_plan_name);
4736: WSH_DEBUG_SV.log(l_module_name,'Trip Id:', p_trip_id);
4737: END IF;
4738:
4739: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4740:
4741: IF p_trip_id IS NOT NULL THEN--{
4742: FOR rec in c_get_deliveries1
4743: LOOP

Line 4780: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4776: END IF;
4777: IF c_get_deliveries2 %ISOPEN THEN
4778: CLOSE c_get_deliveries2;
4779: END IF;
4780: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4781: WSH_UTIL_CORE.DEFAULT_HANDLER(
4782: 'WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP',
4783: l_module_name);
4784: IF l_debug_on THEN

Line 4781: WSH_UTIL_CORE.DEFAULT_HANDLER(

4777: IF c_get_deliveries2 %ISOPEN THEN
4778: CLOSE c_get_deliveries2;
4779: END IF;
4780: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4781: WSH_UTIL_CORE.DEFAULT_HANDLER(
4782: 'WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP',
4783: l_module_name);
4784: IF l_debug_on THEN
4785: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4804: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

4800: --====================================================
4801: PROCEDURE compare_trip_for_deliveries
4802: (p_dleg_tab IN OUT NOCOPY TMS_DLEG_TAB_TYPE,
4803: p_trip_id IN NUMBER,
4804: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4805: --x_unassign_ver_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4806: x_return_status OUT NOCOPY VARCHAR2) IS
4807:
4808: CURSOR c_get_current_trip(p_delivery_id IN NUMBER) IS

Line 4805: --x_unassign_ver_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

4801: PROCEDURE compare_trip_for_deliveries
4802: (p_dleg_tab IN OUT NOCOPY TMS_DLEG_TAB_TYPE,
4803: p_trip_id IN NUMBER,
4804: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4805: --x_unassign_ver_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4806: x_return_status OUT NOCOPY VARCHAR2) IS
4807:
4808: CURSOR c_get_current_trip(p_delivery_id IN NUMBER) IS
4809: SELECT wdl.delivery_leg_id,

Line 4856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4852: WSH_DEBUG_SV.log(l_module_name,'Unassign Delivery Count:', x_unassign_id_tab.count);
4853: -- WSH_DEBUG_SV.log(l_module_name,'Unassign Delivery Version Count:', x_unassign_ver_tab.count);
4854: END IF;
4855:
4856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4857:
4858: IF p_dleg_tab.count > 0 THEN
4859:
4860: FOR dlvy_count IN p_dleg_tab.FIRST..p_dleg_tab.LAST

Line 4922: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

4918:
4919: IF l_debug_on THEN
4920: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
4921: END IF;
4922: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4923: x_return_status := l_rs;
4924: EXIT;
4925: END IF;
4926: -- THESE WILL BE ASSIGNED LATER, SO WHY POPULATE IN UNASSIGNED TAB AND THEN DELETE LATER!!!!!

Line 4947: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

4943: p_dleg_tab(dlvy_count).processed_flag := 'Y';
4944: END IF;--}
4945: END LOOP;--}
4946:
4947: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4948: x_return_status := l_rs;
4949: IF l_debug_on THEN
4950: WSH_DEBUG_SV.logmsg(l_module_name, 'Error Processing Delivery id:'||(p_dleg_tab(dlvy_count).delivery_id));
4951: END IF;

Line 4969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4965: WHEN OTHERS THEN
4966: IF c_get_current_trip %ISOPEN THEN
4967: CLOSE c_get_current_trip;
4968: END IF;
4969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4970: WSH_UTIL_CORE.DEFAULT_HANDLER(
4971: 'WSH_TMS_RELEASE.COMPARE_TRIP_FOR_DELIVERIES',
4972: l_module_name);
4973: IF l_debug_on THEN

Line 4970: WSH_UTIL_CORE.DEFAULT_HANDLER(

4966: IF c_get_current_trip %ISOPEN THEN
4967: CLOSE c_get_current_trip;
4968: END IF;
4969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4970: WSH_UTIL_CORE.DEFAULT_HANDLER(
4971: 'WSH_TMS_RELEASE.COMPARE_TRIP_FOR_DELIVERIES',
4972: l_module_name);
4973: IF l_debug_on THEN
4974: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5013: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5009: WSH_DEBUG_SV.push(l_module_name);
5010: WSH_DEBUG_SV.log(l_module_name,'Group Id:', p_group_id);
5011: END IF;
5012:
5013: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5014:
5015: x_request_id := FND_REQUEST.Submit_Request
5016: (application => 'WSH',
5017: program => 'WSHOTMRL',

Line 5030: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5026:
5027: EXCEPTION
5028: WHEN OTHERS THEN
5029: x_request_id := 0;
5030: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5031: WSH_UTIL_CORE.DEFAULT_HANDLER(
5032: 'WSH_TMS_RELEASE.LAUNCH_RELEASE_REQUEST',
5033: l_module_name);
5034: IF l_debug_on THEN

Line 5031: WSH_UTIL_CORE.DEFAULT_HANDLER(

5027: EXCEPTION
5028: WHEN OTHERS THEN
5029: x_request_id := 0;
5030: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5031: WSH_UTIL_CORE.DEFAULT_HANDLER(
5032: 'WSH_TMS_RELEASE.LAUNCH_RELEASE_REQUEST',
5033: l_module_name);
5034: IF l_debug_on THEN
5035: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5102: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5098: WSH_DEBUG_SV.log(l_module_name,'Delivery Tab Count:', x_delivery_tab.count);
5099: WSH_DEBUG_SV.log(l_module_name,'Stop Tab Count:', x_stop_tab.count);
5100: END IF;
5101:
5102: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5103:
5104: l_stop_tab := x_stop_tab;
5105: l_dlvy_tab := x_delivery_tab;
5106:

Line 5137: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

5133: p_internal_cust_location_id => l_dropoff_location_id,
5134: x_internal_org_location_id => l_physical_loc_id,
5135: x_return_status => l_return_status);
5136:
5137: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5138: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5139: THEN
5140: x_return_status := l_return_status;
5141: IF l_debug_on THEN

Line 5138: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

5134: x_internal_org_location_id => l_physical_loc_id,
5135: x_return_status => l_return_status);
5136:
5137: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5138: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5139: THEN
5140: x_return_status := l_return_status;
5141: IF l_debug_on THEN
5142: WSH_DEBUG_SV.log(l_module_name, 'Conversion Failed,l_return_status', l_return_status);

Line 5195: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

5191: p_internal_cust_location_id => l_dropoff_location_id,
5192: x_internal_org_location_id => l_physical_loc_id,
5193: x_return_status => l_return_status);
5194:
5195: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5196: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5197: THEN
5198: x_return_status := l_return_status;
5199: IF l_debug_on THEN

Line 5196: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

5192: x_internal_org_location_id => l_physical_loc_id,
5193: x_return_status => l_return_status);
5194:
5195: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5196: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5197: THEN
5198: x_return_status := l_return_status;
5199: IF l_debug_on THEN
5200: WSH_DEBUG_SV.log(l_module_name, 'Conversion Failed,l_return_status', l_return_status);

Line 5314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5310:
5311: EXCEPTION
5312: WHEN OTHERS THEN
5313: -- Close any open cursors
5314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5315: WSH_UTIL_CORE.DEFAULT_HANDLER(
5316: 'WSH_TMS_RELEASE.PROCESS_INTERNAL_LOCATIONS',l_module_name);
5317: IF l_debug_on THEN
5318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5315: WSH_UTIL_CORE.DEFAULT_HANDLER(

5311: EXCEPTION
5312: WHEN OTHERS THEN
5313: -- Close any open cursors
5314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5315: WSH_UTIL_CORE.DEFAULT_HANDLER(
5316: 'WSH_TMS_RELEASE.PROCESS_INTERNAL_LOCATIONS',l_module_name);
5317: IF l_debug_on THEN
5318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5350: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5346: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5347: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'get_server_time';
5348:
5349: BEGIN
5350: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5351:
5352: IF l_debug_on THEN
5353: WSH_DEBUG_SV.push (l_module_name);
5354: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_timezone_code : '||p_source_timezone_code);

Line 5395: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

5391:
5392: EXCEPTION
5393: WHEN invalid_timezone THEN
5394: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TIMEZONE');
5395: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
5396: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5397: x_msg_data := 'Input Timezone is not a valid FND timezone code';
5398: --
5399: IF l_debug_on THEN

Line 5396: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5392: EXCEPTION
5393: WHEN invalid_timezone THEN
5394: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TIMEZONE');
5395: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
5396: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5397: x_msg_data := 'Input Timezone is not a valid FND timezone code';
5398: --
5399: IF l_debug_on THEN
5400: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_timezone');

Line 5405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5401: END IF;
5402: --
5403:
5404: WHEN others THEN
5405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5406: x_msg_data := 'Oracle error message is '|| SQLERRM;
5407: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.get_server_time');
5408: --
5409: IF l_debug_on THEN

Line 5407: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.get_server_time');

5403:
5404: WHEN others THEN
5405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5406: x_msg_data := 'Oracle error message is '|| SQLERRM;
5407: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.get_server_time');
5408: --
5409: IF l_debug_on THEN
5410: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5411: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');