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_OTM_OUTBOUND dependencies on FND_API

Line 53: WHEN FND_API.G_EXC_ERROR THEN

49: END IF;
50:
51: EXCEPTION
52:
53: WHEN FND_API.G_EXC_ERROR THEN
54: IF l_debug_on THEN
55: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
56: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
57: END IF;

Line 55: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);

51: EXCEPTION
52:
53: WHEN FND_API.G_EXC_ERROR THEN
54: IF l_debug_on THEN
55: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
56: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
57: END IF;
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
59: IF l_debug_on THEN

Line 56: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

52:
53: WHEN FND_API.G_EXC_ERROR THEN
54: IF l_debug_on THEN
55: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
56: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
57: END IF;
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
59: IF l_debug_on THEN
60: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);

Line 58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

54: IF l_debug_on THEN
55: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
56: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
57: END IF;
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
59: IF l_debug_on THEN
60: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
61: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
62: END IF;

Line 60: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);

56: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
57: END IF;
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
59: IF l_debug_on THEN
60: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
61: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
62: END IF;
63: WHEN OTHERS THEN
64: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DEL_DETAILS',l_sub_module_name);

Line 61: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

57: END IF;
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
59: IF l_debug_on THEN
60: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
61: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
62: END IF;
63: WHEN OTHERS THEN
64: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DEL_DETAILS',l_sub_module_name);
65: IF l_debug_on THEN

Line 379: raise FND_API.G_EXC_ERROR;

375: l_del_trip_rec := l_trip_tab(l_trip_tab.COUNT).trip_id;
376: x_error_trip_id_tab.extend;
377: x_error_trip_id_tab(x_error_trip_id_tab.COUNT) := l_trip_tab(l_trip_tab.COUNT).trip_id;
378: l_trip_tab.TRIM;
379: raise FND_API.G_EXC_ERROR;
380: --}
381: END IF;
382:
383: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(

Line 399: raise FND_API.G_EXC_ERROR;

395: l_del_trip_rec := l_trip_tab(l_trip_tab.COUNT).trip_id;
396: x_error_trip_id_tab.extend;
397: x_error_trip_id_tab(x_error_trip_id_tab.COUNT) := l_trip_tab(l_trip_tab.COUNT).trip_id;
398: l_trip_tab.TRIM;
399: raise FND_API.G_EXC_ERROR;
400: END IF;
401:
402: l_total_gross_wt := 0;
403: l_total_net_wt := 0;

Line 450: WHEN FND_API.G_EXC_ERROR THEN

446: WSH_DEBUG_SV.log(l_sub_module_name,' GET_DEAFULT_UOMS_FALIED',sqlerrm);
447: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:GET_DEAFULT_UOMS_FALIED');
448: END IF;
449:
450: WHEN FND_API.G_EXC_ERROR THEN
451: l_num_error := l_num_error + 1;
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
454: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 453: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);

449:
450: WHEN FND_API.G_EXC_ERROR THEN
451: l_num_error := l_num_error + 1;
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
454: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
455: END IF;
456:
457: END;

Line 454: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

450: WHEN FND_API.G_EXC_ERROR THEN
451: l_num_error := l_num_error + 1;
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
454: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
455: END IF;
456:
457: END;
458: --}

Line 743: x_return_status := FND_API.G_RET_STS_ERROR;

739: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
740: --}
741: ELSE
742: --{
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: --}
745: END IF;
746: --
747: -- Bug 6497991(begin): for error trips, update tms_interface_flag back to 'ASR'

Line 774: raise FND_API.G_EXC_ERROR;

770: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
771: IF l_debug_on THEN
772: WSH_DEBUG_SV.log(l_sub_module_name,'failed in UPDATE_TMS_INTERFACE_FLAG');
773: END IF;
774: raise FND_API.G_EXC_ERROR;
775: END IF;
776: --}
777: END IF;
778: i := x_error_trip_id_tab.NEXT(i);

Line 1195: raise FND_API.G_EXC_ERROR;

1191: IF l_debug_on
1192: THEN
1193: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1194: END IF;
1195: raise FND_API.G_EXC_ERROR;
1196: END IF;
1197:
1198: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1199: p_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,

Line 1208: raise FND_API.G_EXC_ERROR;

1204: IF l_debug_on
1205: THEN
1206: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1207: END IF;
1208: raise FND_API.G_EXC_ERROR;
1209: END IF;
1210:
1211:
1212:

Line 1253: raise FND_API.G_EXC_ERROR;

1249: IF l_debug_on
1250: THEN
1251: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1252: END IF;
1253: raise FND_API.G_EXC_ERROR;
1254: END IF;
1255:
1256: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1257: p_uom=>l_del_details(i).VOLUME_UOM_CODE,

Line 1266: raise FND_API.G_EXC_ERROR;

1262: IF l_debug_on
1263: THEN
1264: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1265: END IF;
1266: raise FND_API.G_EXC_ERROR;
1267: END IF;
1268:
1269:
1270:

Line 1323: raise FND_API.G_EXC_ERROR;

1319: IF l_debug_on
1320: THEN
1321: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed for Loose Item');
1322: END IF;
1323: raise FND_API.G_EXC_ERROR;
1324: END IF;
1325:
1326: l_lpn_tab(l_lpn_tab.COUNT) := wsh_otm_lpn_obj(l_del_details(i).delivery_detail_id,null,l_del_details(i).gross_weight,l_del_details(i).net_weight,
1327: l_del_details(i).weight_uom_code,l_del_details(i).volume_uom_code,

Line 1382: raise FND_API.G_EXC_ERROR;

1378: IF l_debug_on
1379: THEN
1380: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1381: END IF;
1382: raise FND_API.G_EXC_ERROR;
1383: END IF;
1384:
1385:
1386: l_all_lpn_tab(l_del_details(i).delivery_detail_id) :=

Line 1450: WHEN FND_API.G_EXC_ERROR THEN

1446: WSH_DEBUG_SV.log(l_sub_module_name,'CONVERT_INT_LOC_FALIED',sqlerrm);
1447: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1448: END IF;
1449:
1450: WHEN FND_API.G_EXC_ERROR THEN
1451: -- 6830854
1452: IF l_debug_on
1453: THEN
1454: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);

Line 1454: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);

1450: WHEN FND_API.G_EXC_ERROR THEN
1451: -- 6830854
1452: IF l_debug_on
1453: THEN
1454: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
1455: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1456: END IF;
1457:
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1454: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
1455: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1456: END IF;
1457:
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1459: -- 6830854
1460: IF l_debug_on
1461: THEN
1462: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);

Line 1462: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);

1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1459: -- 6830854
1460: IF l_debug_on
1461: THEN
1462: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
1463: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1464: END IF;
1465:
1466: WHEN OTHERS THEN

Line 1552: -- 6830854 raise FND_API.G_EXC_ERROR;

1548: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.log(l_sub_module_name,'failed in WND_PVT.UPDATE_TMS_INTERFACE_FLAG');
1551: END IF;
1552: -- 6830854 raise FND_API.G_EXC_ERROR;
1553: -- removing the above as Error can occur in Validation again
1554: END IF;
1555: --}
1556: END IF;

Line 1597: x_return_status := FND_API.G_RET_STS_ERROR;

1593: END IF;
1594: x_error_dlv_id_tab := p_dlv_id_tab;
1595: p_dlv_id_tab := l_dlv_id_tab;
1596: x_dlv_tab := l_dlv_tab;
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: END IF;
1599: -- } Main IF - when l_dlv_tab count > 0
1600: --
1601: -- Debug Statements

Line 2040: x_return_status := FND_API.G_RET_STS_ERROR;

2036: END IF;
2037: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2038: -- returning all entitiy id to error id table
2039: p_error_id_tab := p_entity_id_tab;
2040: x_return_status := FND_API.G_RET_STS_ERROR;
2041: WHEN UPD_STOP_INTF_FLAG_API_FALIED THEN
2042: IF l_debug_on THEN
2043: WSH_DEBUG_SV.log(l_sub_module_name,'UPD_STOP_INTF_FLAG_API_FALIED',sqlerrm);
2044: END IF;

Line 2048: x_return_status := FND_API.G_RET_STS_ERROR;

2044: END IF;
2045: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2046: -- returning all entitiy id to error id table
2047: p_error_id_tab := p_entity_id_tab;
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: WHEN INVALID_ENTITY_TYPE THEN
2050: IF l_debug_on THEN
2051: WSH_DEBUG_SV.log(l_sub_module_name,'INVALID_ENTITY_TYPE',sqlerrm);
2052: END IF;

Line 2056: x_return_status := FND_API.G_RET_STS_ERROR;

2052: END IF;
2053: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2054: -- returning all entitiy id to error id table
2055: p_error_id_tab := p_entity_id_tab;
2056: x_return_status := FND_API.G_RET_STS_ERROR;
2057: WHEN INVALID_NEW_INTF_STATUS THEN
2058: IF l_debug_on THEN
2059: WSH_DEBUG_SV.log(l_sub_module_name,'INVALID_NEW_INTF_STATUS',sqlerrm);
2060: END IF;

Line 2064: x_return_status := FND_API.G_RET_STS_ERROR;

2060: END IF;
2061: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2062: -- returning all entitiy id to error id table
2063: p_error_id_tab := p_entity_id_tab;
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: WHEN FND_API.G_EXC_ERROR THEN
2066: IF l_debug_on THEN
2067: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
2068: END IF;

Line 2065: WHEN FND_API.G_EXC_ERROR THEN

2061: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2062: -- returning all entitiy id to error id table
2063: p_error_id_tab := p_entity_id_tab;
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: WHEN FND_API.G_EXC_ERROR THEN
2066: IF l_debug_on THEN
2067: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
2068: END IF;
2069: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;

Line 2067: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);

2063: p_error_id_tab := p_entity_id_tab;
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: WHEN FND_API.G_EXC_ERROR THEN
2066: IF l_debug_on THEN
2067: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
2068: END IF;
2069: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2070: -- returning all entitiy id to error id table
2071: p_error_id_tab := p_entity_id_tab;

Line 2072: x_return_status := FND_API.G_RET_STS_ERROR;

2068: END IF;
2069: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2070: -- returning all entitiy id to error id table
2071: p_error_id_tab := p_entity_id_tab;
2072: x_return_status := FND_API.G_RET_STS_ERROR;
2073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
2076: END IF;

Line 2073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2069: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2070: -- returning all entitiy id to error id table
2071: p_error_id_tab := p_entity_id_tab;
2072: x_return_status := FND_API.G_RET_STS_ERROR;
2073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
2076: END IF;
2077: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;

Line 2075: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);

2071: p_error_id_tab := p_entity_id_tab;
2072: x_return_status := FND_API.G_RET_STS_ERROR;
2073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
2076: END IF;
2077: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2078: -- returning all entitiy id to error id table
2079: p_error_id_tab := p_entity_id_tab;

Line 2087: x_return_status := FND_API.G_RET_STS_ERROR;

2083: WSH_DEBUG_SV.log(l_sub_module_name,'OTHERS - ERROR',sqlerrm);
2084: END IF;
2085: -- returning all entitiy id to error id table
2086: p_error_id_tab := p_entity_id_tab;
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.UPDATE_ENTITY_INTF_STATUS');
2089: END;
2090:
2091: