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 1035: l_del_wti_tab WSH_UTIL_CORE.id_tab_type; -- OTM R12

1031: -- Variables to store information about various entities
1032: l_trip_info_tab tms_trip_tab_type;
1033: l_stop_info_tab tms_stop_tab_type;
1034: l_dleg_info_tab tms_dleg_tab_type;
1035: l_del_wti_tab WSH_UTIL_CORE.id_tab_type; -- OTM R12
1036:
1037: l_stop_local_tab tms_stop_tab_type;
1038: l_dleg_local_tab tms_dleg_tab_type;
1039:

Line 1041: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

1037: l_stop_local_tab tms_stop_tab_type;
1038: l_dleg_local_tab tms_dleg_tab_type;
1039:
1040: -- List of Delivery ids which are unassigned during the flow
1041: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1042: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1043: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1044: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1045: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 1042: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;

1038: l_dleg_local_tab tms_dleg_tab_type;
1039:
1040: -- List of Delivery ids which are unassigned during the flow
1041: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1042: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1043: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1044: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1045: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1046: l_unassigned_del_index NUMBER;

Line 1045: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1041: l_unassigned_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1042: l_unassigned_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1043: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
1044: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1045: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1046: l_unassigned_del_index NUMBER;
1047:
1048: -- Populate Errors
1049: l_errors_tab interface_errors_tab_type;

Line 1056: l_stop_id_tab WSH_UTIL_CORE.id_tab_type;

1052: l_group_error_count NUMBER := 0;
1053:
1054: -- Variables to store(new) ids after creation
1055: l_trip_id NUMBER;
1056: l_stop_id_tab WSH_UTIL_CORE.id_tab_type;
1057:
1058: -- successful deliveries, used for freight costs and set in process_delivery section
1059: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1060: l_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;

Line 1059: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;

1055: l_trip_id NUMBER;
1056: l_stop_id_tab WSH_UTIL_CORE.id_tab_type;
1057:
1058: -- successful deliveries, used for freight costs and set in process_delivery section
1059: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1060: l_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1061:
1062: l_ret_code BOOLEAN;
1063: l_temp BOOLEAN;

Line 1060: l_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;

1056: l_stop_id_tab WSH_UTIL_CORE.id_tab_type;
1057:
1058: -- successful deliveries, used for freight costs and set in process_delivery section
1059: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1060: l_dlvy_version_tab WSH_UTIL_CORE.id_tab_type;
1061:
1062: l_ret_code BOOLEAN;
1063: l_temp BOOLEAN;
1064: l_completion_status VARCHAR2(30);

Line 1070: l_upd_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;

1066: l_success_trips NUMBER;
1067: l_error_trips NUMBER;
1068:
1069: -- OTM R12 populate record structure to call update_tms_interface_flag
1070: l_upd_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1071: l_upd_dlvy_tms_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1072: -- OTM R12
1073: -- Bug#7491598(ER,defer planned shipment iface)
1074: l_del_pickup_date_low DATE;

Line 1071: l_upd_dlvy_tms_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1067: l_error_trips NUMBER;
1068:
1069: -- OTM R12 populate record structure to call update_tms_interface_flag
1070: l_upd_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
1071: l_upd_dlvy_tms_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1072: -- OTM R12
1073: -- Bug#7491598(ER,defer planned shipment iface)
1074: l_del_pickup_date_low DATE;
1075: l_del_pickup_date_high DATE;

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

1132: -- Check for p_group_id
1133: /*
1134: IF p_group_id IS NULL THEN
1135: FND_MESSAGE.SET_NAME('WSH','WSH_GROUP_ID_IS_REQUIRED');
1136: WSH_UTIL_CORE.PrintMsg(fnd_message.get);
1137: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1138: errbuf := 'Exception occurred in Release_Planned_Shipment';
1139: retcode := '2';
1140: IF l_debug_on THEN

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

1133: /*
1134: IF p_group_id IS NULL THEN
1135: FND_MESSAGE.SET_NAME('WSH','WSH_GROUP_ID_IS_REQUIRED');
1136: WSH_UTIL_CORE.PrintMsg(fnd_message.get);
1137: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1138: errbuf := 'Exception occurred in Release_Planned_Shipment';
1139: retcode := '2';
1140: IF l_debug_on THEN
1141: WSH_DEBUG_SV.logmsg(l_module_name, 'Group Id cannot be Null');

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

1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_TRIP');
1474: FND_MESSAGE.SET_TOKEN('TRIP_NAME',WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id));
1475: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1476: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.log(l_module_name, 'trip not locked: l_return_status', l_return_status);
1479: END IF;

Line 1476: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1472: WHEN OTHERS THEN
1473: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_TRIP');
1474: FND_MESSAGE.SET_TOKEN('TRIP_NAME',WSH_TRIPS_PVT.get_name(l_trip_info_tab(i).trip_id));
1475: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1476: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1477: IF l_debug_on THEN
1478: WSH_DEBUG_SV.log(l_module_name, 'trip not locked: l_return_status', l_return_status);
1479: END IF;
1480: GOTO trip_error;

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

1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_STOP');
1503: FND_MESSAGE.SET_TOKEN('STOP_NAME',WSH_TRIP_STOPS_PVT.get_name(l_stop_id,'FTE_TMS_INTEGRATION'));
1504: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1505: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1506: IF l_debug_on THEN
1507: WSH_DEBUG_SV.log(l_module_name, 'trip stop not locked: l_return_status', l_return_status);
1508: END IF;

Line 1505: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1501: WHEN OTHERS THEN
1502: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_STOP');
1503: FND_MESSAGE.SET_TOKEN('STOP_NAME',WSH_TRIP_STOPS_PVT.get_name(l_stop_id,'FTE_TMS_INTEGRATION'));
1504: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1505: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1506: IF l_debug_on THEN
1507: WSH_DEBUG_SV.log(l_module_name, 'trip stop not locked: l_return_status', l_return_status);
1508: END IF;
1509: GOTO trip_error;

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

1532: EXCEPTION
1533: WHEN OTHERS THEN
1534: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLEG');
1535: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1536: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1537: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1538: IF l_debug_on THEN
1539: WSH_DEBUG_SV.log(l_module_name, 'Delivery Leg not locked: l_return_status', l_return_status);
1540: END IF;

Line 1537: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1533: WHEN OTHERS THEN
1534: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLEG');
1535: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1536: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1537: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1538: IF l_debug_on THEN
1539: WSH_DEBUG_SV.log(l_module_name, 'Delivery Leg not locked: l_return_status', l_return_status);
1540: END IF;
1541: GOTO trip_error;

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

1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLVY');
1552: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1553: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1554: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1555: IF l_debug_on THEN
1556: WSH_DEBUG_SV.log(l_module_name, 'Delivery not locked: l_return_status', l_return_status);
1557: END IF;

Line 1554: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1550: WHEN OTHERS THEN
1551: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_LOCK_DLVY');
1552: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',wsh_new_deliveries_pvt.get_name(l_dleg_local_tab(m).delivery_id));
1553: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1554: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1555: IF l_debug_on THEN
1556: WSH_DEBUG_SV.log(l_module_name, 'Delivery not locked: l_return_status', l_return_status);
1557: END IF;
1558: GOTO trip_error;

Line 1581: l_organization_tab WSH_UTIL_CORE.id_tab_type;

1577: l_in_rec WSH_TRIPS_GRP.tripInRecType;
1578: l_trip_output_tab WSH_TRIPS_GRP.trip_Out_Tab_Type;
1579:
1580: l_stop_location_id NUMBER;
1581: l_organization_tab WSH_UTIL_CORE.id_tab_type;
1582:
1583: BEGIN--{
1584:
1585: -- try to lock the trip interface records

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

1615: -- capture cases where stop_location_id is not a number
1616: -- special case, need to handle error a bit differently
1617: l_return_status := 'T';
1618: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1619: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.log(l_module_name, 'Invalid Stop Location, l_return_status:', l_return_status);
1622: END IF;
1623: GOTO trip_error;

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

1627: END IF;
1628: END LOOP;--}
1629:
1630: IF l_stop_location_id IS NULL THEN
1631: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1632: l_return_status := 'T';
1633: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1634: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1635: IF l_debug_on THEN

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

1630: IF l_stop_location_id IS NULL THEN
1631: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1632: l_return_status := 'T';
1633: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1634: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1635: IF l_debug_on THEN
1636: WSH_DEBUG_SV.log(l_module_name, 'Unable to Derive Stop Location', l_return_status);
1637: END IF;
1638: GOTO trip_error;

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

1638: GOTO trip_error;
1639: END IF;
1640:
1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_core.get_org_from_location:'||l_stop_location_id);
1643: END IF;
1644: --get_org_from_location
1645: WSH_UTIL_CORE.get_org_from_location(
1646: p_location_id => l_stop_location_id,

Line 1645: WSH_UTIL_CORE.get_org_from_location(

1641: IF l_debug_on THEN
1642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling wsh_util_core.get_org_from_location:'||l_stop_location_id);
1643: END IF;
1644: --get_org_from_location
1645: WSH_UTIL_CORE.get_org_from_location(
1646: p_location_id => l_stop_location_id,
1647: x_organization_tab => l_organization_tab,
1648: x_return_status => l_rs);
1649:

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

1652: WSH_DEBUG_SV.logmsg(l_module_name,'Organizations Count:'||l_organization_tab.Count);
1653: END IF;
1654:
1655: --Bug 5931958. Added the OR condition l_organization_tab.COUNT = 0
1656: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR
1657: (l_organization_tab.COUNT = 0 ))THEN
1658: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1659: FND_MESSAGE.SET_NAME('WSH','WSH_LOC_ORG_UNDEFINED');
1660: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 1658: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1654:
1655: --Bug 5931958. Added the OR condition l_organization_tab.COUNT = 0
1656: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR
1657: (l_organization_tab.COUNT = 0 ))THEN
1658: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1659: FND_MESSAGE.SET_NAME('WSH','WSH_LOC_ORG_UNDEFINED');
1660: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1661: IF l_debug_on THEN
1662: WSH_DEBUG_SV.log(l_module_name, 'Error: Failed to get Organization from stop location id ',

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

1656: IF (l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) OR
1657: (l_organization_tab.COUNT = 0 ))THEN
1658: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1659: FND_MESSAGE.SET_NAME('WSH','WSH_LOC_ORG_UNDEFINED');
1660: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1661: IF l_debug_on THEN
1662: WSH_DEBUG_SV.log(l_module_name, 'Error: Failed to get Organization from stop location id ',
1663: l_stop_location_id );
1664: END IF;

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

1681: WSH_DEBUG_SV.logmsg(l_module_name,'return status:'||l_rs);
1682: WSH_DEBUG_SV.logmsg(l_module_name,'Vehicle Item id:'||l_trip_info_tab(i).vehicle_item_id);
1683: END IF;
1684:
1685: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1686: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1687: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
1688: FND_MESSAGE.SET_TOKEN('ITEM',l_trip_info_tab(i).vehicle_item_name);
1689: FND_MESSAGE.SET_TOKEN('ORGANIZATION',

Line 1686: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1682: WSH_DEBUG_SV.logmsg(l_module_name,'Vehicle Item id:'||l_trip_info_tab(i).vehicle_item_id);
1683: END IF;
1684:
1685: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1686: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1687: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
1688: FND_MESSAGE.SET_TOKEN('ITEM',l_trip_info_tab(i).vehicle_item_name);
1689: FND_MESSAGE.SET_TOKEN('ORGANIZATION',
1690: WSH_UTIL_CORE.get_org_name (p_organization_id =>l_organization_tab(l_organization_tab.FIRST)));

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

1686: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1687: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
1688: FND_MESSAGE.SET_TOKEN('ITEM',l_trip_info_tab(i).vehicle_item_name);
1689: FND_MESSAGE.SET_TOKEN('ORGANIZATION',
1690: WSH_UTIL_CORE.get_org_name (p_organization_id =>l_organization_tab(l_organization_tab.FIRST)));
1691: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.log(l_module_name, 'Validate Item Failed: l_return_status', l_return_status);
1694: END IF;

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

1687: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
1688: FND_MESSAGE.SET_TOKEN('ITEM',l_trip_info_tab(i).vehicle_item_name);
1689: FND_MESSAGE.SET_TOKEN('ORGANIZATION',
1690: WSH_UTIL_CORE.get_org_name (p_organization_id =>l_organization_tab(l_organization_tab.FIRST)));
1691: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.log(l_module_name, 'Validate Item Failed: l_return_status', l_return_status);
1694: END IF;
1695: GOTO trip_error;

Line 1720: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

1716: IF l_trip_info_tab(i).interface_action_code = G_TMS_DELETE_CODE THEN--{
1717:
1718: DECLARE
1719: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
1720: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
1721:
1722: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1723: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1724: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;

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

1742: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after find_deliveries_for_trip'||l_rs);
1743: END IF;
1744:
1745: -- Handle return status here !!!
1746: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1747: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1748: IF l_debug_on THEN
1749: WSH_DEBUG_SV.log(l_module_name, 'Find Deliveries for Trip Failed,l_return_status:', l_return_status);
1750: END IF;

Line 1747: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1743: END IF;
1744:
1745: -- Handle return status here !!!
1746: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1747: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1748: IF l_debug_on THEN
1749: WSH_DEBUG_SV.log(l_module_name, 'Find Deliveries for Trip Failed,l_return_status:', l_return_status);
1750: END IF;
1751: GOTO trip_error;

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

1797:
1798: IF l_debug_on THEN
1799: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
1800: END IF;
1801: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1802: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery from Trip Failed: l_return_status', l_return_status);
1805: END IF;

Line 1802: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1798: IF l_debug_on THEN
1799: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
1800: END IF;
1801: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1802: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery from Trip Failed: l_return_status', l_return_status);
1805: END IF;
1806: GOTO trip_error;

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

1887: p_In_rec => l_in_rec,
1888: x_Out_tab => l_trip_output_tab);
1889:
1890:
1891: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1892: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1893: IF l_debug_on THEN
1894: WSH_DEBUG_SV.log(l_module_name, 'Create Update Trip Failed: l_return_status', l_return_status);
1895: END IF;

Line 1892: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1888: x_Out_tab => l_trip_output_tab);
1889:
1890:
1891: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1892: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1893: IF l_debug_on THEN
1894: WSH_DEBUG_SV.log(l_module_name, 'Create Update Trip Failed: l_return_status', l_return_status);
1895: END IF;
1896: GOTO trip_error;

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

1922:
1923: DECLARE
1924: -- Find Deliveries associated to a stop
1925: l_stop_matches VARCHAR2(1); -- stop sent by GC3 matches stop in EBS
1926: l_stop_delete_tab WSH_UTIL_CORE.id_tab_type; -- stops to be deleted
1927: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned
1928:
1929: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1930: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

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

1923: DECLARE
1924: -- Find Deliveries associated to a stop
1925: l_stop_matches VARCHAR2(1); -- stop sent by GC3 matches stop in EBS
1926: l_stop_delete_tab WSH_UTIL_CORE.id_tab_type; -- stops to be deleted
1927: --l_dlvy_unassign_tab WSH_UTIL_CORE.id_tab_type; -- deliveries to be unassigned
1928:
1929: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
1930: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
1931: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;

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

1970: -- capture cases where stop_location_id is not a number
1971: -- special case, need to handle error a bit differently
1972: l_return_status := 'T';
1973: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1974: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1975: IF l_debug_on THEN
1976: WSH_DEBUG_SV.log(l_module_name, 'Invalid Stop Location, l_return_status:', l_return_status);
1977: END IF;
1978: GOTO trip_error;

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

1982: WSH_UTIL_VALIDATE.VALIDATE_LOCATION
1983: (p_location_id =>l_location_id,
1984: x_return_status => l_rs);
1985:
1986: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1987: l_return_status := 'T';-- special case, need to handle error a bit differently
1988: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1989: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1990: IF l_debug_on THEN

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

1985:
1986: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1987: l_return_status := 'T';-- special case, need to handle error a bit differently
1988: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
1989: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1990: IF l_debug_on THEN
1991: WSH_DEBUG_SV.log(l_module_name, 'Invalid Stop Location, l_return_status:', l_return_status);
1992: END IF;
1993: GOTO trip_error;

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

2095: x_internal_org_location_id => l_physical_loc_id,
2096: x_return_status => l_rs);
2097:
2098: -- Treat this also as Invalid Stop Location
2099: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2100: l_return_status := 'T';-- special case, need to handle error a bit differently
2101: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
2102: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2103: IF l_debug_on THEN

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

2098: -- Treat this also as Invalid Stop Location
2099: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2100: l_return_status := 'T';-- special case, need to handle error a bit differently
2101: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_LOCATION');
2102: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2103: IF l_debug_on THEN
2104: WSH_DEBUG_SV.log(l_module_name, 'Invalid Stop Location, l_return_status:', l_return_status);
2105: END IF;
2106: GOTO trip_error;

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

2258: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
2259: END IF;
2260:
2261: -- Handle error here !!!, should these deliveries be deleted from unassign table list??
2262: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2263: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2264: IF l_debug_on THEN
2265: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery Failed: l_return_status', l_return_status);
2266: END IF;

Line 2263: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2259: END IF;
2260:
2261: -- Handle error here !!!, should these deliveries be deleted from unassign table list??
2262: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2263: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2264: IF l_debug_on THEN
2265: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery Failed: l_return_status', l_return_status);
2266: END IF;
2267: GOTO trip_error;

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

2289: -- Handle return status here, treat warning as success
2290: IF l_debug_on THEN
2291: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after deleting stop'||l_rs);
2292: END IF;
2293: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2294: -- go to trip_error
2295: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2296: IF l_debug_on THEN
2297: WSH_DEBUG_SV.log(l_module_name, 'Delete Trip Stop Failed: l_return_status', l_return_status);

Line 2295: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2291: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after deleting stop'||l_rs);
2292: END IF;
2293: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2294: -- go to trip_error
2295: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2296: IF l_debug_on THEN
2297: WSH_DEBUG_SV.log(l_module_name, 'Delete Trip Stop Failed: l_return_status', l_return_status);
2298: END IF;
2299: GOTO trip_error;

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

2315: (x_delivery_tab => l_dleg_local_tab,
2316: x_stop_tab => l_stop_local_tab,
2317: x_return_status => l_rs);
2318:
2319: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2320: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2321: IF l_debug_on THEN
2322: WSH_DEBUG_SV.log(l_module_name, 'Process Internal Location, l_return_status:', l_return_status);
2323: END IF;

Line 2320: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2316: x_stop_tab => l_stop_local_tab,
2317: x_return_status => l_rs);
2318:
2319: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2320: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2321: IF l_debug_on THEN
2322: WSH_DEBUG_SV.log(l_module_name, 'Process Internal Location, l_return_status:', l_return_status);
2323: END IF;
2324: GOTO trip_error;

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

2376: x_return_status => l_rs,
2377: x_msg_count => l_msg_count,
2378: x_msg_data => l_msg_data);
2379:
2380: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2381: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2382: IF l_debug_on THEN
2383: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Planned Arrival Date, l_return_status:', l_return_status);
2384: END IF;

Line 2381: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2377: x_msg_count => l_msg_count,
2378: x_msg_data => l_msg_data);
2379:
2380: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2381: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2382: IF l_debug_on THEN
2383: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Planned Arrival Date, l_return_status:', l_return_status);
2384: END IF;
2385: GOTO trip_error;

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

2392: x_return_status => l_rs,
2393: x_msg_count => l_msg_count,
2394: x_msg_data => l_msg_data);
2395:
2396: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2397: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2398: IF l_debug_on THEN
2399: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Planned Arrival Date, l_return_status:', l_return_status);
2400: END IF;

Line 2397: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2393: x_msg_count => l_msg_count,
2394: x_msg_data => l_msg_data);
2395:
2396: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2397: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2398: IF l_debug_on THEN
2399: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Planned Arrival Date, l_return_status:', l_return_status);
2400: END IF;
2401: GOTO trip_error;

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

2441: IF l_debug_on THEN
2442: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.GET_DEFAULT_UOMS'||l_rs);
2443: END IF;
2444: -- Handle return Status error!!!
2445: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2446: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2447: IF l_debug_on THEN
2448: WSH_DEBUG_SV.log(l_module_name, 'Get_Default_UOM failed: l_return_status', l_return_status);
2449: END IF;

Line 2446: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2442: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.GET_DEFAULT_UOMS'||l_rs);
2443: END IF;
2444: -- Handle return Status error!!!
2445: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2446: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2447: IF l_debug_on THEN
2448: WSH_DEBUG_SV.log(l_module_name, 'Get_Default_UOM failed: l_return_status', l_return_status);
2449: END IF;
2450: GOTO trip_error;

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

2467: x_return_status => l_rs);
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.GET_DEFAULT_UOMS'||l_rs);
2470: END IF;
2471: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2472: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2473: IF l_debug_on THEN
2474: WSH_DEBUG_SV.log(l_module_name, 'Get_Default_UOM Failed: l_return_status', l_return_status);
2475: END IF;

Line 2472: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_WV_UTILS.GET_DEFAULT_UOMS'||l_rs);
2470: END IF;
2471: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2472: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2473: IF l_debug_on THEN
2474: WSH_DEBUG_SV.log(l_module_name, 'Get_Default_UOM Failed: l_return_status', l_return_status);
2475: END IF;
2476: GOTO trip_error;

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

2547: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab);
2548:
2549:
2550: -- Handle return status and error Here !!!
2551: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2552: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2553: IF l_debug_on THEN
2554: WSH_DEBUG_SV.log(l_module_name, 'Create Update Trip Stop Failed: l_return_status', l_return_status);
2555: END IF;

Line 2552: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2548:
2549:
2550: -- Handle return status and error Here !!!
2551: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2552: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2553: IF l_debug_on THEN
2554: WSH_DEBUG_SV.log(l_module_name, 'Create Update Trip Stop Failed: l_return_status', l_return_status);
2555: END IF;
2556: GOTO trip_error;

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

2609: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_organization_id,
2610: x_param_info => l_shipping_parameters,
2611: x_return_status => l_rs);
2612:
2613: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2614: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2615: IF l_debug_on THEN
2616: WSH_DEBUG_SV.log(l_module_name, 'WSH_SHIPPING_PARAMS_PVT.GET Failed: l_return_status', l_return_status);
2617: END IF;

Line 2614: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2610: x_param_info => l_shipping_parameters,
2611: x_return_status => l_rs);
2612:
2613: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2614: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2615: IF l_debug_on THEN
2616: WSH_DEBUG_SV.log(l_module_name, 'WSH_SHIPPING_PARAMS_PVT.GET Failed: l_return_status', l_return_status);
2617: END IF;
2618: GOTO trip_error;

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

2627: x_return_status => l_rs,
2628: x_msg_count => l_msg_count,
2629: x_msg_data => l_msg_data);
2630:
2631: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2632: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2633: IF l_debug_on THEN
2634: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Dock Door Appointment Start Time, l_return_status:', l_return_status);
2635: END IF;

Line 2632: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2628: x_msg_count => l_msg_count,
2629: x_msg_data => l_msg_data);
2630:
2631: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2632: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2633: IF l_debug_on THEN
2634: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Dock Door Appointment Start Time, l_return_status:', l_return_status);
2635: END IF;
2636: GOTO trip_error;

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

2644: x_return_status => l_rs,
2645: x_msg_count => l_msg_count,
2646: x_msg_data => l_msg_data);
2647:
2648: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2649: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2650: IF l_debug_on THEN
2651: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Dock Door Appointment End Time, l_return_status:', l_return_status);
2652: END IF;

Line 2649: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2645: x_msg_count => l_msg_count,
2646: x_msg_data => l_msg_data);
2647:
2648: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2649: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2650: IF l_debug_on THEN
2651: WSH_DEBUG_SV.log(l_module_name, 'Get Server Time for Dock Door Appointment End Time, l_return_status:', l_return_status);
2652: END IF;
2653: GOTO trip_error;

Line 2677: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2673: END IF; --} Checking WMS Org
2674: END IF; --} Checking l_organization_id as NULL
2675: EXCEPTION
2676: WHEN OTHERS THEN
2677: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2678: IF l_debug_on THEN
2679: WSH_DEBUG_SV.log(l_module_name, 'Error while fetching Dock Door Appointment Scheduling Info.');
2680: END IF;
2681: IF (c_dock_appt_rec%ISOPEN) THEN

Line 2722: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

2718:
2719: DECLARE
2720:
2721: l_delivery_tab WSH_TMS_RELEASE.delivery_tab;
2722: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
2723:
2724: l_del_attrs WSH_NEW_DELIVERIES_PVT.delivery_attr_tbl_type;
2725: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2726: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;

Line 2737: l_del_index WSH_UTIL_CORE.id_tab_type;

2733: -- flag
2734: l_del_matches VARCHAR2(1);
2735:
2736: l_dleg_count NUMBER;
2737: l_del_index WSH_UTIL_CORE.id_tab_type;
2738:
2739: BEGIN--{
2740: l_delivery_id_tab.DELETE;
2741: l_del_attrs.DELETE;

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

2758: IF l_debug_on THEN
2759: WSH_DEBUG_SV.logmsg(l_module_name,'EBS and OTM version number donot match');
2760: END IF;
2761: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_NOT_UPD_VERSION_ERR');
2762: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2763: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;
2764: EXIT; -- out of this loop
2765: --}
2766: END IF;

Line 2763: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;

2759: WSH_DEBUG_SV.logmsg(l_module_name,'EBS and OTM version number donot match');
2760: END IF;
2761: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_NOT_UPD_VERSION_ERR');
2762: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2763: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;
2764: EXIT; -- out of this loop
2765: --}
2766: END IF;
2767: --

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

2771: IF l_debug_on THEN
2772: WSH_DEBUG_SV.logmsg(l_module_name,'EBS and OTM version number donot match');
2773: END IF;
2774: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_VERSION_ERROR');
2775: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2776: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;
2777: EXIT; -- out of this loop
2778: --}
2779: END IF;

Line 2776: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;

2772: WSH_DEBUG_SV.logmsg(l_module_name,'EBS and OTM version number donot match');
2773: END IF;
2774: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_IB_VERSION_ERROR');
2775: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
2776: l_rs := WSH_UTIL_CORE.G_RET_STS_ERROR;
2777: EXIT; -- out of this loop
2778: --}
2779: END IF;
2780: --}

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

2782: END LOOP;--}
2783: -- End of Bug 5134725
2784:
2785: -- Handle return status here !!!
2786: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2787: -- go to trip_error
2788: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2789: IF l_debug_on THEN
2790: WSH_DEBUG_SV.log(l_module_name, 'Version Comparison failed,l_return_status:', l_return_status);

Line 2788: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2784:
2785: -- Handle return status here !!!
2786: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2787: -- go to trip_error
2788: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2789: IF l_debug_on THEN
2790: WSH_DEBUG_SV.log(l_module_name, 'Version Comparison failed,l_return_status:', l_return_status);
2791: END IF;
2792: GOTO trip_error;

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

2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after find_deliveries_for_trip'||l_rs);
2809: END IF;
2810: -- Handle return status here !!!
2811: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2812: -- go to trip_error
2813: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2814: IF l_debug_on THEN
2815: WSH_DEBUG_SV.log(l_module_name, 'Find Deliveries for Trip Failed,l_return_status:', l_return_status);

Line 2813: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2809: END IF;
2810: -- Handle return status here !!!
2811: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2812: -- go to trip_error
2813: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2814: IF l_debug_on THEN
2815: WSH_DEBUG_SV.log(l_module_name, 'Find Deliveries for Trip Failed,l_return_status:', l_return_status);
2816: END IF;
2817: GOTO trip_error;

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

2892:
2893: IF l_debug_on THEN
2894: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
2895: END IF;
2896: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2897: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2898: IF l_debug_on THEN
2899: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery from Trip Failed: l_return_status', l_return_status);
2900: END IF;

Line 2897: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2893: IF l_debug_on THEN
2894: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
2895: END IF;
2896: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2897: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2898: IF l_debug_on THEN
2899: WSH_DEBUG_SV.log(l_module_name, 'Unassign Delivery from Trip Failed: l_return_status', l_return_status);
2900: END IF;
2901: GOTO trip_error;

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

2920: IF l_debug_on THEN
2921: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Comparing Trips:'||l_rs);
2922: END IF;
2923: -- Handle return Status here !!!
2924: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2925: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2926: IF l_debug_on THEN
2927: WSH_DEBUG_SV.log(l_module_name, 'Compare Trip for Deliveries Failed: l_return_status', l_return_status);
2928: END IF;

Line 2925: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2921: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Comparing Trips:'||l_rs);
2922: END IF;
2923: -- Handle return Status here !!!
2924: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2925: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2926: IF l_debug_on THEN
2927: WSH_DEBUG_SV.log(l_module_name, 'Compare Trip for Deliveries Failed: l_return_status', l_return_status);
2928: END IF;
2929: GOTO trip_error;

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

3058: IF l_debug_on THEN
3059: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Assign Delivery to Trip'||l_rs);
3060: END IF;
3061:
3062: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3063: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3064: IF l_debug_on THEN
3065: WSH_DEBUG_SV.log(l_module_name, 'Assign Delivery to Trip Failed: l_return_status', l_return_status);
3066: END IF;

Line 3063: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3059: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Assign Delivery to Trip'||l_rs);
3060: END IF;
3061:
3062: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3063: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3064: IF l_debug_on THEN
3065: WSH_DEBUG_SV.log(l_module_name, 'Assign Delivery to Trip Failed: l_return_status', l_return_status);
3066: END IF;
3067: GOTO trip_error;

Line 3068: ELSIF l_rs = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3064: IF l_debug_on THEN
3065: WSH_DEBUG_SV.log(l_module_name, 'Assign Delivery to Trip Failed: l_return_status', l_return_status);
3066: END IF;
3067: GOTO trip_error;
3068: ELSIF l_rs = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3069: l_dleg_local_tab(assign_count).processed_flag := 'Y';
3070: l_dlvy_id_tab(l_dlvy_id_tab.count + 1) := l_dleg_local_tab(assign_count).delivery_id;
3071: l_dlvy_version_tab(l_dlvy_id_tab.count) := l_dleg_local_tab(assign_count).tms_version_number;
3072: END IF;

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

3144: l_carrier_cur_code VARCHAR2(15) := NULL;
3145: l_carrier_id NUMBER := NULL;
3146: l_count NUMBER := 0;
3147: l_frcost_type_id NUMBER := NULL;
3148: l_dleg_id_tab WSH_UTIL_CORE.id_tab_type; -- for deleting Dleg freight cost
3149: l_index NUMBER;
3150: --l_conversion_type_code VARCHAR2(30); -- OTM R12
3151: l_conversion_type_code FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE := NULL; -- OTM R12
3152:

Line 3232: WSH_UTIL_CORE.get_currency_conversion_type(

3228: END IF;
3229:
3230: -- OTM R12, start of Bug 5952842(5729276)
3231: IF l_conversion_type_code IS NULL THEN--{
3232: WSH_UTIL_CORE.get_currency_conversion_type(
3233: x_curr_conv_type => l_conversion_type_code,
3234: x_return_status => l_rs);
3235:
3236: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

3232: WSH_UTIL_CORE.get_currency_conversion_type(
3233: x_curr_conv_type => l_conversion_type_code,
3234: x_return_status => l_rs);
3235:
3236: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3237: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3238: IF l_debug_on THEN
3239: WSH_DEBUG_SV.log(l_module_name, 'get_currency_conversion_type Failed');
3240: END IF;

Line 3237: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3233: x_curr_conv_type => l_conversion_type_code,
3234: x_return_status => l_rs);
3235:
3236: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3237: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3238: IF l_debug_on THEN
3239: WSH_DEBUG_SV.log(l_module_name, 'get_currency_conversion_type Failed');
3240: END IF;
3241: GOTO trip_error;

Line 3272: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3268: END IF;
3269:
3270: -- OTM R12 check if carrier has a non-null currency
3271: IF c_get_currency_code%NOTFOUND THEN
3272: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3273: IF l_debug_on THEN
3274: WSH_DEBUG_SV.log(l_module_name, 'Carrier not found ');
3275: END IF;
3276: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_ID_NOT_FOUND');

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

3273: IF l_debug_on THEN
3274: WSH_DEBUG_SV.log(l_module_name, 'Carrier not found ');
3275: END IF;
3276: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_ID_NOT_FOUND');
3277: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3278: CLOSE c_get_currency_code;
3279: GOTO trip_error;
3280: ELSE
3281: WSH_UTIL_VALIDATE.Validate_Carrier(

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

3286: IF l_debug_on THEN
3287: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Carrier:',l_rs);
3288: END IF;
3289:
3290: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3291: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3292: IF l_debug_on THEN
3293: WSH_DEBUG_SV.log(l_module_name, 'Validate Carrier Failed: l_return_status', l_return_status);
3294: END IF;

Line 3291: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3287: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Carrier:',l_rs);
3288: END IF;
3289:
3290: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3291: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3292: IF l_debug_on THEN
3293: WSH_DEBUG_SV.log(l_module_name, 'Validate Carrier Failed: l_return_status', l_return_status);
3294: END IF;
3295: CLOSE c_get_currency_code;

Line 3302: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3298: END IF;
3299: CLOSE c_get_currency_code;
3300:
3301: IF l_carrier_cur_code IS NULL THEN
3302: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3303: IF l_debug_on THEN
3304: WSH_DEBUG_SV.log(l_module_name, 'Carrier Currency not defined ');
3305: END IF;
3306: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_NO_CURRENCY');

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

3303: IF l_debug_on THEN
3304: WSH_DEBUG_SV.log(l_module_name, 'Carrier Currency not defined ');
3305: END IF;
3306: FND_MESSAGE.SET_NAME('WSH','WSH_CARRIER_NO_CURRENCY');
3307: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3308: GOTO trip_error;
3309: END IF;
3310:
3311: -- OTM R12 check if carrier has a non-null currency

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

3326: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Currency:',l_rs);
3327: END IF;
3328: -- Handle error here !!!
3329: -- ECO 5008405 handle here !!!
3330: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3331: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3332: IF l_debug_on THEN
3333: WSH_DEBUG_SV.log(l_module_name, 'Validate Currency Failed: l_return_status', l_return_status);
3334: END IF;

Line 3331: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3327: END IF;
3328: -- Handle error here !!!
3329: -- ECO 5008405 handle here !!!
3330: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3331: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3332: IF l_debug_on THEN
3333: WSH_DEBUG_SV.log(l_module_name, 'Validate Currency Failed: l_return_status', l_return_status);
3334: END IF;
3335: GOTO trip_error;

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

3431: FND_MESSAGE.SET_NAME('WSH','WSH_CURR_CONV_ERROR');
3432: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_freight_info_tab(l_count).currency_code);
3433: FND_MESSAGE.SET_TOKEN('TO_CURR',l_carrier_cur_code);
3434: FND_MESSAGE.SET_TOKEN('CONV_TYPE',l_user_conv_type);-- Bug 5886042
3435: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3436: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3437: IF l_debug_on THEN
3438: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT'
3439: ||' failed no_rate', l_return_status);

Line 3436: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3432: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_freight_info_tab(l_count).currency_code);
3433: FND_MESSAGE.SET_TOKEN('TO_CURR',l_carrier_cur_code);
3434: FND_MESSAGE.SET_TOKEN('CONV_TYPE',l_user_conv_type);-- Bug 5886042
3435: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3436: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3437: IF l_debug_on THEN
3438: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT'
3439: ||' failed no_rate', l_return_status);
3440: END IF;

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

3464: FND_MESSAGE.SET_NAME('WSH','WSH_CURR_CONV_ERROR');
3465: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_freight_info_tab(l_count).currency_code);
3466: FND_MESSAGE.SET_TOKEN('TO_CURR',l_carrier_cur_code);
3467: FND_MESSAGE.SET_TOKEN('CONV_TYPE',l_user_conv_type);-- Bug 5886042
3468: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3469: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3470: IF l_debug_on THEN
3471: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT'
3472: ||' failed invalid_currency', l_return_status);

Line 3469: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3465: FND_MESSAGE.SET_TOKEN('FROM_CURR',l_freight_info_tab(l_count).currency_code);
3466: FND_MESSAGE.SET_TOKEN('TO_CURR',l_carrier_cur_code);
3467: FND_MESSAGE.SET_TOKEN('CONV_TYPE',l_user_conv_type);-- Bug 5886042
3468: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3469: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3470: IF l_debug_on THEN
3471: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT'
3472: ||' failed invalid_currency', l_return_status);
3473: END IF;

Line 3478: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3474: GOTO trip_error;
3475:
3476: -- OTM R12 end
3477: WHEN gl_currency_excp THEN
3478: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3479: IF l_debug_on THEN
3480: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT returned NULL :', l_return_status);
3481: END IF;
3482: GOTO trip_error;

Line 3485: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3481: END IF;
3482: GOTO trip_error;
3483:
3484: WHEN OTHERS THEN
3485: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3486: IF l_debug_on THEN
3487: WSH_DEBUG_SV.log(l_module_name, 'GL_CURRENCY_API.CONVERT_AMOUNT failed:', l_return_status);
3488: END IF;
3489: GOTO trip_error;

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

3526: IF l_debug_on THEN
3527: WSH_DEBUG_SV.logmsg(l_module_name, 'Return Status after Create Freight Cost:'||l_rs);
3528: END IF;
3529:
3530: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3531: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3532: IF l_debug_on THEN
3533: WSH_DEBUG_SV.log(l_module_name, 'Create_Update_Freight_Costs Failed: l_return_status', l_return_status);
3534: END IF;

Line 3531: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3527: WSH_DEBUG_SV.logmsg(l_module_name, 'Return Status after Create Freight Cost:'||l_rs);
3528: END IF;
3529:
3530: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3531: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3532: IF l_debug_on THEN
3533: WSH_DEBUG_SV.log(l_module_name, 'Create_Update_Freight_Costs Failed: l_return_status', l_return_status);
3534: END IF;
3535: EXIT; -- need to exit out of the parent loop also!!!

Line 3544: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

3540:
3541: END IF;--}-- only if freight cost record has currency
3542:
3543: END LOOP;--}-- loop across freight_costs_interface table
3544: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3545: EXIT; -- need to exit out of the parent loop also!!!
3546: -- OTM R12 will never reach this GOTO and GOTO not required as the immediate next section is trip_error
3547: --GOTO trip_error;
3548: END IF;

Line 3581: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3577: AND wnd.delivery_id = wda.delivery_id
3578: AND wda.delivery_detail_id = wdd.delivery_detail_id
3579: FOR UPDATE OF wnd.loading_sequence, wdd.load_seq_number NOWAIT;
3580:
3581: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3582: l_del_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3583: l_loading_sequence NUMBER := 0;
3584: l_stop_id_rec NUMBER;
3585:

Line 3582: l_del_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;

3578: AND wda.delivery_detail_id = wdd.delivery_detail_id
3579: FOR UPDATE OF wnd.loading_sequence, wdd.load_seq_number NOWAIT;
3580:
3581: l_del_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3582: l_del_det_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3583: l_loading_sequence NUMBER := 0;
3584: l_stop_id_rec NUMBER;
3585:
3586: BEGIN

Line 3628: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3624: END LOOP;
3625:
3626: EXCEPTION
3627: WHEN OTHERS THEN
3628: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3629: IF c_lock_deliveries_and_details%ISOPEN then
3630: CLOSE c_lock_deliveries_and_details;
3631: END IF;
3632: IF l_debug_on THEN

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

3654: x_msg_data => l_msg_data);
3655: IF l_debug_on THEN
3656: WSH_DEBUG_SV.log(l_module_name, 'wms_dock_appointments_pub.OTM_Dock_Appointment: Return Status', l_rs);
3657: END IF;
3658: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3659: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3660: FOR l_err_msg IN 1..l_msg_count LOOP
3661: l_message := fnd_msg_pub.get(l_err_msg,'F');
3662: l_message := replace(l_message,chr(0),' ');

Line 3659: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3655: IF l_debug_on THEN
3656: WSH_DEBUG_SV.log(l_module_name, 'wms_dock_appointments_pub.OTM_Dock_Appointment: Return Status', l_rs);
3657: END IF;
3658: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3659: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3660: FOR l_err_msg IN 1..l_msg_count LOOP
3661: l_message := fnd_msg_pub.get(l_err_msg,'F');
3662: l_message := replace(l_message,chr(0),' ');
3663: IF l_debug_on THEN

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

3665: END IF;
3666: END LOOP;
3667: fnd_msg_pub.delete_msg();
3668: FND_MESSAGE.SET_NAME('WSH','WSH_DOCK_SCHED_ERROR');
3669: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3670: GOTO trip_error;
3671: END IF;
3672: END IF; --} l_dock_appt_tab.COUNT > 0
3673: EXCEPTION

Line 3675: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3671: END IF;
3672: END IF; --} l_dock_appt_tab.COUNT > 0
3673: EXCEPTION
3674: WHEN OTHERS THEN
3675: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3676: IF l_debug_on THEN
3677: WSH_DEBUG_SV.log(l_module_name, 'Error while calling wms_dock_appointments_pub.OTM_Dock_Appointment' || SQLERRM);
3678: END IF;
3679: GOTO trip_error;

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

3709: -- Status of T is for special case of Invalid Location for Trip Stop
3710: -- For Invalid Location error, donot insert records in error table,
3711: -- Only Log Delivery Level Error exceptions and purge the data from
3712: -- Interface tables
3713: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,'T') THEN --{
3714: --IF l_errors_tab.count > 0 THEN
3715: IF l_debug_on THEN
3716: WSH_DEBUG_SV.logmsg(l_module_name,'Rollback.....' );
3717: END IF;

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

3746: WSH_DEBUG_SV.logmsg(l_module_name,'After Purging the Interface Data:'||l_rs );
3747: END IF;
3748:
3749: -- OTM R12
3750: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3751: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3752: IF l_debug_on THEN
3753: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3754: END IF;

Line 3751: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3747: END IF;
3748:
3749: -- OTM R12
3750: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3751: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3752: IF l_debug_on THEN
3753: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3754: END IF;
3755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3759: END IF;--}
3760:
3761: -- For Delete Shipment Cases, there will not be any delivery level information
3762: IF l_dleg_local_tab.count > 0 THEN--{
3763: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN--{
3764:
3765: -- Insert record in wsh_interface_errors table
3766: -- Generic error message is to be logged against all deliveries
3767: -- Handled in stamp_interface_errors

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

3778: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Stamp_Interface_error'||l_rs);
3779: END IF;
3780:
3781: -- OTM R12
3782: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3783: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3784: IF l_debug_on THEN
3785: WSH_DEBUG_SV.log(l_module_name, 'stamp_interface_error Failed');
3786: END IF;

Line 3783: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3779: END IF;
3780:
3781: -- OTM R12
3782: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3783: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3784: IF l_debug_on THEN
3785: WSH_DEBUG_SV.log(l_module_name, 'stamp_interface_error Failed');
3786: END IF;
3787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3828: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Log_exception'||l_rs);
3829: END IF;
3830:
3831: -- OTM R12
3832: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3833: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3834: IF l_debug_on THEN
3835: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.log_exception Failed');
3836: END IF;

Line 3833: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3829: END IF;
3830:
3831: -- OTM R12
3832: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3833: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3834: IF l_debug_on THEN
3835: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.log_exception Failed');
3836: END IF;
3837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3891: IF l_debug_on THEN
3892: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after WSH_XC_UTIL.Purge' || l_rs);
3893: END IF;
3894: -- OTM R12
3895: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3896: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3897: IF l_debug_on THEN
3898: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.Purge Failed');
3899: END IF;

Line 3896: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3892: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after WSH_XC_UTIL.Purge' || l_rs);
3893: END IF;
3894: -- OTM R12
3895: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3896: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3897: IF l_debug_on THEN
3898: WSH_DEBUG_SV.log(l_module_name, 'WSH_XC_UTIL.Purge Failed');
3899: END IF;
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3933: IF l_debug_on THEN
3934: WSH_DEBUG_SV.logmsg(l_module_name,'After Purging the Interface Data:'||l_rs );
3935: END IF;
3936:
3937: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3938: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3939: IF l_debug_on THEN
3940: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3941: END IF;

Line 3938: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3934: WSH_DEBUG_SV.logmsg(l_module_name,'After Purging the Interface Data:'||l_rs );
3935: END IF;
3936:
3937: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3938: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3939: IF l_debug_on THEN
3940: WSH_DEBUG_SV.log(l_module_name, 'purge_interface_data Failed');
3941: END IF;
3942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3977: x_delivery_rec => l_delivery_info,
3978: x_return_status => l_return_status);
3979:
3980: -- OTM R12
3981: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3982: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3983: IF l_debug_on THEN
3984: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');
3985: END IF;

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

3978: x_return_status => l_return_status);
3979:
3980: -- OTM R12
3981: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3982: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3983: IF l_debug_on THEN
3984: WSH_DEBUG_SV.log(l_module_name, 'WSH_NEW_DELIVERIES_PVT.TABLE_TO_RECORD Failed');
3985: END IF;
3986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4023:
4024: IF l_debug_on THEN
4025: WSH_DEBUG_SV.log(l_module_name, 'update_tms_interface_flag : l_return_status : ', l_return_status);
4026: END IF;
4027: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4028: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4029: ROLLBACK TO process_group;
4030: l_completion_status := 'WARNING';
4031: --l_completion_status := 'ERROR';

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

4024: IF l_debug_on THEN
4025: WSH_DEBUG_SV.log(l_module_name, 'update_tms_interface_flag : l_return_status : ', l_return_status);
4026: END IF;
4027: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4028: --l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4029: ROLLBACK TO process_group;
4030: l_completion_status := 'WARNING';
4031: --l_completion_status := 'ERROR';
4032: ELSE

Line 4158: WSH_UTIL_CORE.DEFAULT_HANDLER(

4154: l_ret_code := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');
4155: errbuf := 'Exception occurred in Release_Planned_Shipment';
4156: retcode := '2';
4157: --
4158: WSH_UTIL_CORE.DEFAULT_HANDLER(
4159: 'WSH_TMS_RELEASE.RELEASE_PLANNED_SHIPMENT',
4160: l_module_name);
4161: IF l_debug_on THEN
4162: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4207: l_trip_interface_id_tab WSH_UTIL_CORE.id_tab_type;

4203: WHERE wti.tp_plan_name = p_tp_plan_name
4204: AND wti.interface_action_code = G_TMS_RELEASE_CODE;
4205:
4206: l_trip_interface_id NUMBER;
4207: l_trip_interface_id_tab WSH_UTIL_CORE.id_tab_type;
4208:
4209: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PURGE_INTERFACE_DATA';
4210: --
4211: l_debug_on BOOLEAN;

Line 4229: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4225: WSH_DEBUG_SV.log(l_module_name,'p_commit_flag:', p_commit_flag);
4226: WSH_DEBUG_SV.log(l_module_name,'p_exception_action:', p_exception_action);
4227: END IF;
4228:
4229: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4230:
4231: SAVEPOINT BEFORE_PURGE;
4232:
4233: -- Derive the trip_interface_id

Line 4423: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4419: WHEN OTHERS THEN
4420: IF c_get_interface_id%ISOPEN THEN
4421: CLOSE c_get_interface_id;
4422: END IF;
4423: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4424: ROLLBACK to before_purge;
4425: WSH_UTIL_CORE.DEFAULT_HANDLER(
4426: 'WSH_TMS_RELEASE.PURGE_INTERFACE_DATA',
4427: l_module_name);

Line 4425: WSH_UTIL_CORE.DEFAULT_HANDLER(

4421: CLOSE c_get_interface_id;
4422: END IF;
4423: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4424: ROLLBACK to before_purge;
4425: WSH_UTIL_CORE.DEFAULT_HANDLER(
4426: 'WSH_TMS_RELEASE.PURGE_INTERFACE_DATA',
4427: l_module_name);
4428: IF l_debug_on THEN
4429: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4494: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;

4490: l_buffer VARCHAR2(4000);
4491: l_index_out NUMBER;
4492:
4493: --
4494: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;
4495: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4496: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;
4497: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4498: l_messages text_tab_type;

Line 4495: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;

4491: l_index_out NUMBER;
4492:
4493: --
4494: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;
4495: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4496: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;
4497: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4498: l_messages text_tab_type;
4499:

Line 4496: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;

4492:
4493: --
4494: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;
4495: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4496: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;
4497: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4498: l_messages text_tab_type;
4499:
4500: l_message VARCHAR2(4000);

Line 4497: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;

4493: --
4494: l_groups WSH_UTIL_CORE.ID_TAB_TYPE;
4495: l_table_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4496: l_interface_ids WSH_UTIL_CORE.ID_TAB_TYPE;
4497: l_message_names WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4498: l_messages text_tab_type;
4499:
4500: l_message VARCHAR2(4000);
4501: l_message_name VARCHAR2(30);

Line 4503: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;

4499:
4500: l_message VARCHAR2(4000);
4501: l_message_name VARCHAR2(30);
4502: l_dleg_tab tms_dleg_tab_type;
4503: l_dlvy_id_tab WSH_UTIL_CORE.id_tab_type;
4504:
4505: l_msg_data VARCHAR2(240);
4506:
4507: BEGIN

Line 4534: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4530: WSH_DEBUG_SV.log(l_module_name,'p_token_4_value', p_token_4_value);
4531: WSH_DEBUG_SV.logmsg(l_module_name,'Count of Input Deliveries:'||p_dleg_tab.count);
4532: END IF;
4533:
4534: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4535:
4536: l_index := x_errors_tab.COUNT + 1;
4537:
4538: IF p_message_text IS NULL THEN --{

Line 4655: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4651: END IF;
4652:
4653: EXCEPTION
4654: WHEN OTHERS THEN
4655: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4656: WSH_UTIL_CORE.DEFAULT_HANDLER(
4657: 'WSH_TMS_RELEASE.STAMP_INTERFACE_ERROR',
4658: l_module_name);
4659: IF l_debug_on THEN

Line 4656: WSH_UTIL_CORE.DEFAULT_HANDLER(

4652:
4653: EXCEPTION
4654: WHEN OTHERS THEN
4655: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4656: WSH_UTIL_CORE.DEFAULT_HANDLER(
4657: 'WSH_TMS_RELEASE.STAMP_INTERFACE_ERROR',
4658: l_module_name);
4659: IF l_debug_on THEN
4660: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4677: x_delivery_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

4673: PROCEDURE find_deliveries_for_trip(
4674: p_trip_id IN NUMBER,
4675: p_tp_plan_name IN VARCHAR2,
4676: x_delivery_tab OUT NOCOPY WSH_TMS_RELEASE.delivery_tab,
4677: x_delivery_id_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4678: x_return_status OUT NOCOPY VARCHAR2) IS
4679:
4680: -- Query deliveries based on p_trip_id
4681: CURSOR c_get_deliveries1 IS

Line 4731: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4727: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name:', p_tp_plan_name);
4728: WSH_DEBUG_SV.log(l_module_name,'Trip Id:', p_trip_id);
4729: END IF;
4730:
4731: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4732:
4733: IF p_trip_id IS NOT NULL THEN--{
4734: FOR rec in c_get_deliveries1
4735: LOOP

Line 4772: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4768: END IF;
4769: IF c_get_deliveries2 %ISOPEN THEN
4770: CLOSE c_get_deliveries2;
4771: END IF;
4772: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4773: WSH_UTIL_CORE.DEFAULT_HANDLER(
4774: 'WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP',
4775: l_module_name);
4776: IF l_debug_on THEN

Line 4773: WSH_UTIL_CORE.DEFAULT_HANDLER(

4769: IF c_get_deliveries2 %ISOPEN THEN
4770: CLOSE c_get_deliveries2;
4771: END IF;
4772: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4773: WSH_UTIL_CORE.DEFAULT_HANDLER(
4774: 'WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP',
4775: l_module_name);
4776: IF l_debug_on THEN
4777: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4796: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

4792: --====================================================
4793: PROCEDURE compare_trip_for_deliveries
4794: (p_dleg_tab IN OUT NOCOPY TMS_DLEG_TAB_TYPE,
4795: p_trip_id IN NUMBER,
4796: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4797: --x_unassign_ver_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4798: x_return_status OUT NOCOPY VARCHAR2) IS
4799:
4800: CURSOR c_get_current_trip(p_delivery_id IN NUMBER) IS

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

4793: PROCEDURE compare_trip_for_deliveries
4794: (p_dleg_tab IN OUT NOCOPY TMS_DLEG_TAB_TYPE,
4795: p_trip_id IN NUMBER,
4796: x_unassign_id_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4797: --x_unassign_ver_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
4798: x_return_status OUT NOCOPY VARCHAR2) IS
4799:
4800: CURSOR c_get_current_trip(p_delivery_id IN NUMBER) IS
4801: SELECT wdl.delivery_leg_id,

Line 4848: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4844: WSH_DEBUG_SV.log(l_module_name,'Unassign Delivery Count:', x_unassign_id_tab.count);
4845: -- WSH_DEBUG_SV.log(l_module_name,'Unassign Delivery Version Count:', x_unassign_ver_tab.count);
4846: END IF;
4847:
4848: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4849:
4850: IF p_dleg_tab.count > 0 THEN
4851:
4852: FOR dlvy_count IN p_dleg_tab.FIRST..p_dleg_tab.LAST

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

4910:
4911: IF l_debug_on THEN
4912: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status after Unassign Delivery'||l_rs);
4913: END IF;
4914: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4915: x_return_status := l_rs;
4916: EXIT;
4917: END IF;
4918: -- THESE WILL BE ASSIGNED LATER, SO WHY POPULATE IN UNASSIGNED TAB AND THEN DELETE LATER!!!!!

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

4935: p_dleg_tab(dlvy_count).processed_flag := 'Y';
4936: END IF;--}
4937: END LOOP;--}
4938:
4939: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
4940: x_return_status := l_rs;
4941: IF l_debug_on THEN
4942: WSH_DEBUG_SV.logmsg(l_module_name, 'Error Processing Delivery id:'||(p_dleg_tab(dlvy_count).delivery_id));
4943: END IF;

Line 4961: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4957: WHEN OTHERS THEN
4958: IF c_get_current_trip %ISOPEN THEN
4959: CLOSE c_get_current_trip;
4960: END IF;
4961: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4962: WSH_UTIL_CORE.DEFAULT_HANDLER(
4963: 'WSH_TMS_RELEASE.COMPARE_TRIP_FOR_DELIVERIES',
4964: l_module_name);
4965: IF l_debug_on THEN

Line 4962: WSH_UTIL_CORE.DEFAULT_HANDLER(

4958: IF c_get_current_trip %ISOPEN THEN
4959: CLOSE c_get_current_trip;
4960: END IF;
4961: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4962: WSH_UTIL_CORE.DEFAULT_HANDLER(
4963: 'WSH_TMS_RELEASE.COMPARE_TRIP_FOR_DELIVERIES',
4964: l_module_name);
4965: IF l_debug_on THEN
4966: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5005: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5001: WSH_DEBUG_SV.push(l_module_name);
5002: WSH_DEBUG_SV.log(l_module_name,'Group Id:', p_group_id);
5003: END IF;
5004:
5005: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5006:
5007: x_request_id := FND_REQUEST.Submit_Request
5008: (application => 'WSH',
5009: program => 'WSHOTMRL',

Line 5022: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5018:
5019: EXCEPTION
5020: WHEN OTHERS THEN
5021: x_request_id := 0;
5022: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5023: WSH_UTIL_CORE.DEFAULT_HANDLER(
5024: 'WSH_TMS_RELEASE.LAUNCH_RELEASE_REQUEST',
5025: l_module_name);
5026: IF l_debug_on THEN

Line 5023: WSH_UTIL_CORE.DEFAULT_HANDLER(

5019: EXCEPTION
5020: WHEN OTHERS THEN
5021: x_request_id := 0;
5022: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5023: WSH_UTIL_CORE.DEFAULT_HANDLER(
5024: 'WSH_TMS_RELEASE.LAUNCH_RELEASE_REQUEST',
5025: l_module_name);
5026: IF l_debug_on THEN
5027: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5094: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5090: WSH_DEBUG_SV.log(l_module_name,'Delivery Tab Count:', x_delivery_tab.count);
5091: WSH_DEBUG_SV.log(l_module_name,'Stop Tab Count:', x_stop_tab.count);
5092: END IF;
5093:
5094: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5095:
5096: l_stop_tab := x_stop_tab;
5097: l_dlvy_tab := x_delivery_tab;
5098:

Line 5129: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

5125: p_internal_cust_location_id => l_dropoff_location_id,
5126: x_internal_org_location_id => l_physical_loc_id,
5127: x_return_status => l_return_status);
5128:
5129: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5130: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5131: THEN
5132: x_return_status := l_return_status;
5133: IF l_debug_on THEN

Line 5130: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

5126: x_internal_org_location_id => l_physical_loc_id,
5127: x_return_status => l_return_status);
5128:
5129: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5130: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5131: THEN
5132: x_return_status := l_return_status;
5133: IF l_debug_on THEN
5134: WSH_DEBUG_SV.log(l_module_name, 'Conversion Failed,l_return_status', l_return_status);

Line 5187: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

5183: p_internal_cust_location_id => l_dropoff_location_id,
5184: x_internal_org_location_id => l_physical_loc_id,
5185: x_return_status => l_return_status);
5186:
5187: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5188: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5189: THEN
5190: x_return_status := l_return_status;
5191: IF l_debug_on THEN

Line 5188: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

5184: x_internal_org_location_id => l_physical_loc_id,
5185: x_return_status => l_return_status);
5186:
5187: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
5188: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5189: THEN
5190: x_return_status := l_return_status;
5191: IF l_debug_on THEN
5192: WSH_DEBUG_SV.log(l_module_name, 'Conversion Failed,l_return_status', l_return_status);

Line 5306: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5302:
5303: EXCEPTION
5304: WHEN OTHERS THEN
5305: -- Close any open cursors
5306: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5307: WSH_UTIL_CORE.DEFAULT_HANDLER(
5308: 'WSH_TMS_RELEASE.PROCESS_INTERNAL_LOCATIONS',l_module_name);
5309: IF l_debug_on THEN
5310: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 5307: WSH_UTIL_CORE.DEFAULT_HANDLER(

5303: EXCEPTION
5304: WHEN OTHERS THEN
5305: -- Close any open cursors
5306: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5307: WSH_UTIL_CORE.DEFAULT_HANDLER(
5308: 'WSH_TMS_RELEASE.PROCESS_INTERNAL_LOCATIONS',l_module_name);
5309: IF l_debug_on THEN
5310: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5311: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5342: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5338: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
5339: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'get_server_time';
5340:
5341: BEGIN
5342: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5343:
5344: IF l_debug_on THEN
5345: WSH_DEBUG_SV.push (l_module_name);
5346: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_timezone_code : '||p_source_timezone_code);

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

5383:
5384: EXCEPTION
5385: WHEN invalid_timezone THEN
5386: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TIMEZONE');
5387: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
5388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5389: x_msg_data := 'Input Timezone is not a valid FND timezone code';
5390: --
5391: IF l_debug_on THEN

Line 5388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5384: EXCEPTION
5385: WHEN invalid_timezone THEN
5386: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_INVALID_TIMEZONE');
5387: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
5388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5389: x_msg_data := 'Input Timezone is not a valid FND timezone code';
5390: --
5391: IF l_debug_on THEN
5392: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_timezone');

Line 5397: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5393: END IF;
5394: --
5395:
5396: WHEN others THEN
5397: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5398: x_msg_data := 'Oracle error message is '|| SQLERRM;
5399: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.get_server_time');
5400: --
5401: IF l_debug_on THEN

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

5395:
5396: WHEN others THEN
5397: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5398: x_msg_data := 'Oracle error message is '|| SQLERRM;
5399: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.get_server_time');
5400: --
5401: IF l_debug_on THEN
5402: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5403: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');