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 380: raise FND_API.G_EXC_ERROR;

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

Line 400: raise FND_API.G_EXC_ERROR;

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

Line 451: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

Line 744: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 775: raise FND_API.G_EXC_ERROR;

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

Line 1206: raise FND_API.G_EXC_ERROR;

1202: IF l_debug_on
1203: THEN
1204: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1205: END IF;
1206: raise FND_API.G_EXC_ERROR;
1207: END IF;
1208:
1209: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1210: p_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,

Line 1219: raise FND_API.G_EXC_ERROR;

1215: IF l_debug_on
1216: THEN
1217: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1218: END IF;
1219: raise FND_API.G_EXC_ERROR;
1220: END IF;
1221:
1222:
1223:

Line 1264: raise FND_API.G_EXC_ERROR;

1260: IF l_debug_on
1261: THEN
1262: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1263: END IF;
1264: raise FND_API.G_EXC_ERROR;
1265: END IF;
1266:
1267: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1268: p_uom=>l_del_details(i).VOLUME_UOM_CODE,

Line 1277: raise FND_API.G_EXC_ERROR;

1273: IF l_debug_on
1274: THEN
1275: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1276: END IF;
1277: raise FND_API.G_EXC_ERROR;
1278: END IF;
1279:
1280:
1281:

Line 1334: raise FND_API.G_EXC_ERROR;

1330: IF l_debug_on
1331: THEN
1332: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed for Loose Item');
1333: END IF;
1334: raise FND_API.G_EXC_ERROR;
1335: END IF;
1336:
1337: 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,
1338: l_del_details(i).weight_uom_code,l_del_details(i).volume_uom_code,

Line 1393: raise FND_API.G_EXC_ERROR;

1389: IF l_debug_on
1390: THEN
1391: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1392: END IF;
1393: raise FND_API.G_EXC_ERROR;
1394: END IF;
1395:
1396:
1397: l_all_lpn_tab(l_del_details(i).delivery_detail_id) :=

Line 1461: WHEN FND_API.G_EXC_ERROR THEN

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

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

1461: WHEN FND_API.G_EXC_ERROR THEN
1462: -- 6830854
1463: IF l_debug_on
1464: THEN
1465: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
1466: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1467: END IF;
1468:
1469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1465: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
1466: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1467: END IF;
1468:
1469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1470: -- 6830854
1471: IF l_debug_on
1472: THEN
1473: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);

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

1469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1470: -- 6830854
1471: IF l_debug_on
1472: THEN
1473: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
1474: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1475: END IF;
1476:
1477: WHEN OTHERS THEN

Line 1563: -- 6830854 raise FND_API.G_EXC_ERROR;

1559: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1560: IF l_debug_on THEN
1561: WSH_DEBUG_SV.log(l_sub_module_name,'failed in WND_PVT.UPDATE_TMS_INTERFACE_FLAG');
1562: END IF;
1563: -- 6830854 raise FND_API.G_EXC_ERROR;
1564: -- removing the above as Error can occur in Validation again
1565: END IF;
1566: --}
1567: END IF;

Line 1608: x_return_status := FND_API.G_RET_STS_ERROR;

1604: END IF;
1605: x_error_dlv_id_tab := p_dlv_id_tab;
1606: p_dlv_id_tab := l_dlv_id_tab;
1607: x_dlv_tab := l_dlv_tab;
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: END IF;
1610: -- } Main IF - when l_dlv_tab count > 0
1611: --
1612: -- Debug Statements

Line 2052: x_return_status := FND_API.G_RET_STS_ERROR;

2048: END IF;
2049: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2050: -- returning all entitiy id to error id table
2051: p_error_id_tab := p_entity_id_tab;
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: WHEN UPD_STOP_INTF_FLAG_API_FALIED THEN
2054: IF l_debug_on THEN
2055: WSH_DEBUG_SV.log(l_sub_module_name,'UPD_STOP_INTF_FLAG_API_FALIED',sqlerrm);
2056: END IF;

Line 2060: x_return_status := FND_API.G_RET_STS_ERROR;

2056: END IF;
2057: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2058: -- returning all entitiy id to error id table
2059: p_error_id_tab := p_entity_id_tab;
2060: x_return_status := FND_API.G_RET_STS_ERROR;
2061: WHEN INVALID_ENTITY_TYPE THEN
2062: IF l_debug_on THEN
2063: WSH_DEBUG_SV.log(l_sub_module_name,'INVALID_ENTITY_TYPE',sqlerrm);
2064: END IF;

Line 2068: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2076: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2077: WHEN FND_API.G_EXC_ERROR THEN

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

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

2075: p_error_id_tab := p_entity_id_tab;
2076: x_return_status := FND_API.G_RET_STS_ERROR;
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: IF l_debug_on THEN
2079: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_ERROR',sqlerrm);
2080: END IF;
2081: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2082: -- returning all entitiy id to error id table
2083: p_error_id_tab := p_entity_id_tab;

Line 2084: x_return_status := FND_API.G_RET_STS_ERROR;

2080: END IF;
2081: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2082: -- returning all entitiy id to error id table
2083: p_error_id_tab := p_entity_id_tab;
2084: x_return_status := FND_API.G_RET_STS_ERROR;
2085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2086: IF l_debug_on THEN
2087: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
2088: END IF;

Line 2085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2081: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2082: -- returning all entitiy id to error id table
2083: p_error_id_tab := p_entity_id_tab;
2084: x_return_status := FND_API.G_RET_STS_ERROR;
2085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2086: IF l_debug_on THEN
2087: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
2088: END IF;
2089: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;

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

2083: p_error_id_tab := p_entity_id_tab;
2084: x_return_status := FND_API.G_RET_STS_ERROR;
2085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2086: IF l_debug_on THEN
2087: WSH_DEBUG_SV.log(l_sub_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
2088: END IF;
2089: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2090: -- returning all entitiy id to error id table
2091: p_error_id_tab := p_entity_id_tab;

Line 2099: x_return_status := FND_API.G_RET_STS_ERROR;

2095: WSH_DEBUG_SV.log(l_sub_module_name,'OTHERS - ERROR',sqlerrm);
2096: END IF;
2097: -- returning all entitiy id to error id table
2098: p_error_id_tab := p_entity_id_tab;
2099: x_return_status := FND_API.G_RET_STS_ERROR;
2100: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.UPDATE_ENTITY_INTF_STATUS');
2101: END;
2102:
2103: -- +======================================================================+