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

Line 990: raise FND_API.G_EXC_ERROR;

986: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
987: x_return_status := l_return_status;
988: wsh_util_core.add_message(x_return_status);
989: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
990: raise FND_API.G_EXC_ERROR;
991: END IF;
992: END IF;
993: FOR exp_cnt in 1..l_exceptions_tab.COUNT LOOP
994: IF l_exceptions_tab(exp_cnt).exception_behavior = 'ERROR' THEN

Line 1127: raise FND_API.G_EXC_ERROR;

1123: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1124: x_return_status := l_return_status;
1125: wsh_util_core.add_message(x_return_status);
1126: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1127: raise FND_API.G_EXC_ERROR;
1128: END IF;
1129: END IF;
1130:
1131: IF l_num_warn >0 THEN

Line 1267: RAISE FND_API.G_EXC_ERROR;

1263: --
1264: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_INVALID_STATUS');
1265: FND_MESSAGE.SET_TOKEN('TRIP_NAME','p_in_rec.name');
1266: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
1267: RAISE FND_API.G_EXC_ERROR;
1268: --}
1269: END IF;
1270: --
1271:

Line 1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1327: last_update_login = fnd_global.login_id
1328: WHERE trip_id = p_in_rec.trip_id;
1329:
1330: IF (SQL%NOTFOUND) THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333: --
1334: --
1335: -- Workflow Project

Line 1436: raise FND_API.G_EXC_ERROR;

1432: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1433: x_return_status := l_return_status;
1434: wsh_util_core.add_message(x_return_status);
1435: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1436: raise FND_API.G_EXC_ERROR;
1437: END IF;
1438: END IF;
1439: END IF;
1440: --

Line 1463: WHEN FND_API.G_EXC_ERROR THEN

1459: --
1460: --}
1461: EXCEPTION
1462: --{
1463: WHEN FND_API.G_EXC_ERROR THEN
1464:
1465: --ROLLBACK TO trip_chgStatus_begin_sp;
1466: --
1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1470: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1466: --
1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1472: END IF;
1473: --
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1468: --
1469: IF l_debug_on THEN
1470: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1472: END IF;
1473: --
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475:

Line 1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1470: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1471: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1472: END IF;
1473: --
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475:
1476: --ROLLBACK TO trip_chgStatus_begin_sp;
1477: --
1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1482: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1478: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1479: --
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1482: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1483: END IF;
1484: --
1485: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1486: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1691: RAISE FND_API.G_EXC_ERROR;

1687: --
1688: IF l_totalCnt = 0
1689: THEN
1690: --{
1691: RAISE FND_API.G_EXC_ERROR;
1692: --}
1693: ELSE
1694: --{
1695: l_cnt := 0;

Line 1737: p_init_msg_list => FND_API.G_FALSE,

1733: -- Call Delivery group API to generate routing response
1734: --
1735: wsh_interface_grp.Delivery_Action(
1736: p_api_version_number => 1.0,
1737: p_init_msg_list => FND_API.G_FALSE,
1738: p_commit => FND_API.G_FALSE,
1739: p_action_prms => l_action_prms,
1740: p_delivery_id_tab => l_delivery_id_tab,
1741: x_delivery_out_rec => l_del_action_out_rec,

Line 1738: p_commit => FND_API.G_FALSE,

1734: --
1735: wsh_interface_grp.Delivery_Action(
1736: p_api_version_number => 1.0,
1737: p_init_msg_list => FND_API.G_FALSE,
1738: p_commit => FND_API.G_FALSE,
1739: p_action_prms => l_action_prms,
1740: p_delivery_id_tab => l_delivery_id_tab,
1741: x_delivery_out_rec => l_del_action_out_rec,
1742: x_return_status => l_return_status,

Line 1784: WHEN FND_API.G_EXC_ERROR THEN

1780: --
1781: --}
1782: EXCEPTION
1783: --{
1784: WHEN FND_API.G_EXC_ERROR THEN
1785: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1786: --
1787: -- Debug Statements
1788: --

Line 1790: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1786: --
1787: -- Debug Statements
1788: --
1789: IF l_debug_on THEN
1790: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1792: END IF;
1793: --
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1787: -- Debug Statements
1788: --
1789: IF l_debug_on THEN
1790: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1792: END IF;
1793: --
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1790: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1792: END IF;
1793: --
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1796: --
1797: -- Debug Statements
1798: --

Line 1800: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1796: --
1797: -- Debug Statements
1798: --
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1802: END IF;
1803: --
1804: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 1801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1797: -- Debug Statements
1798: --
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1801: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1802: END IF;
1803: --
1804: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1805: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2230: p_sc_pickup_date => p_sc_pickup_date,
2231: p_sc_dropoff_date => p_sc_dropoff_date);
2232:
2233: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2235: END IF;
2236: wsh_util_core.api_post_call(
2237: p_return_status => l_return_status,
2238: x_num_warnings => l_num_warnings,

Line 3215: p_init_msg_list => FND_API.G_FALSE,

3211: IF wsh_util_core.fte_is_installed = 'Y' THEN--{
3212:
3213: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
3214: p_api_version_number => 1.0,
3215: p_init_msg_list => FND_API.G_FALSE,
3216: p_entity_type => 'L',
3217: p_target_id => null,
3218: p_action_code => 'AUTOCREATE-DEL',
3219: p_del_attr_tab => l_cc_del_attr_tab,

Line 3512: p_init_msg_list => FND_API.G_FALSE,

3508: IF wsh_util_core.fte_is_installed = 'Y' THEN--{
3509:
3510: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
3511: p_api_version_number => 1.0,
3512: p_init_msg_list => FND_API.G_FALSE,
3513: p_entity_type => 'D',
3514: p_target_id => null,
3515: p_action_code => 'AUTOCREATE-TRIP',
3516: p_del_attr_tab => l_cc_del_attr_tab,

Line 5411: nvl(planned_departure_date, nvl(p_start_departure_date, FND_API.G_MISS_DATE)) >= nvl(p_start_departure_date, FND_API.G_MISS_DATE)

5407: nvl(shipments_type_flag,'O'),
5408: nvl(wv_frozen_flag,'Y')
5409: FROM wsh_trip_stops
5410: WHERE trip_id = l_trip_id AND
5411: nvl(planned_departure_date, nvl(p_start_departure_date, FND_API.G_MISS_DATE)) >= nvl(p_start_departure_date, FND_API.G_MISS_DATE)
5412: ORDER BY stop_sequence_number;
5413:
5414:
5415: CURSOR lock_stop(c_stop_id NUMBER) IS

Line 5431: nvl(planned_departure_date, nvl(p_start_departure_date, FND_API.G_MISS_DATE)) <= nvl(p_start_departure_date, FND_API.G_MISS_DATE) AND

5427: weight_uom_code,
5428: volume_uom_code
5429: FROM wsh_trip_stops
5430: WHERE trip_id = l_trip_id AND
5431: nvl(planned_departure_date, nvl(p_start_departure_date, FND_API.G_MISS_DATE)) <= nvl(p_start_departure_date, FND_API.G_MISS_DATE) AND
5432: rownum = 1
5433: ORDER BY stop_sequence_number DESC;
5434:
5435: CURSOR last_stop (l_trip_id NUMBER) IS

Line 7700: IF l_return_status in (FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR) THEN

7696: p_internal_cust_location_id => l_getstops_stop_loc_id(j),
7697: x_internal_org_location_id => l_getstops_phys_loc_id(j),
7698: x_return_status => l_return_status);
7699:
7700: IF l_return_status in (FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR) THEN
7701: RAISE get_physical_loc_err;
7702: END IF;
7703: END IF;
7704:

Line 8095: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

8091:
8092:
8093:
8094: PROCEDURE PROCESS_CARRIER_SELECTION (
8095: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8096: p_trip_id_tab IN wsh_util_core.id_tab_type,
8097: p_caller IN VARCHAR2 DEFAULT NULL, -- WSH_FSTRX / WSH_PUB / WSH_GROUP/ FTE
8098: x_msg_count OUT NOCOPY NUMBER,
8099: x_msg_data OUT NOCOPY VARCHAR2,

Line 8229: l_commit VARCHAR2(100) := FND_API.G_FALSE;

8225: l_pickup_volume_convert NUMBER := 0;
8226: l_total_pickup_weight NUMBER := 0;
8227: l_total_pickup_volume NUMBER := 0;
8228:
8229: l_commit VARCHAR2(100) := FND_API.G_FALSE;
8230: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8231:
8232: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8233: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

Line 8230: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;

8226: l_total_pickup_weight NUMBER := 0;
8227: l_total_pickup_volume NUMBER := 0;
8228:
8229: l_commit VARCHAR2(100) := FND_API.G_FALSE;
8230: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8231:
8232: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8233: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
8234: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

Line 8263: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8259: --
8260: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PROCESS_CARRIER_SELECTION';
8261: BEGIN
8262:
8263: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8264: FND_MSG_PUB.initialize;
8265: END IF;
8266:
8267: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 8671: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8667: x_return_status => l_return_status);
8668:
8669: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
8670: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
8671: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8672: END IF;
8673:
8674: --l_trip_info_tab(1).trip_id := l_trip_id;
8675: -- rank_list_action takes care of updating rank_id for the trip

Line 8701: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8697: x_out_tab => l_trip_out_rec_tab);
8698:
8699: --IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
8700: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
8701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8702: END IF;
8703:
8704: --END IF;
8705:

Line 8749: p_init_msg_list => FND_API.G_FALSE,

8745: -- Call FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
8746:
8747: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(
8748: p_api_version => 1.0,
8749: p_init_msg_list => FND_API.G_FALSE,
8750: x_return_status => l_return_status,
8751: x_msg_count => l_msg_count,
8752: x_msg_data => l_msg_data,
8753: p_action_code => 'REPLACE',

Line 8760: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8756: p_rank_id => l_rank_id
8757: --x_ranklist => l_ranked_list
8758: );
8759: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
8760: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8761: END IF;
8762: l_ranked_list.DELETE;
8763: list_cnt := 0;
8764: END IF;

Line 8806: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8802: END IF;
8803: --
8804: END IF;
8805: ELSE
8806: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8807: END IF;
8808: -- TODO
8809: ELSE -- No eligible trips were found
8810: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_VALID_TRIPS');

Line 8828: p_encoded => FND_API.G_FALSE );

8824:
8825: FND_MSG_PUB.Count_And_Get (
8826: p_count => x_msg_count,
8827: p_data => x_msg_data ,
8828: p_encoded => FND_API.G_FALSE );
8829:
8830: IF l_debug_on THEN
8831: wsh_debug_sv.log (l_module_name,'No. of messages stacked : ',to_char(x_msg_count));
8832: wsh_debug_sv.pop(l_module_name);

Line 8838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8834:
8835: --
8836:
8837: EXCEPTION
8838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8839:
8840: ROLLBACK TO before_trip_update;
8841: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8842: --

Line 8845: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

8841: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8842: --
8843: IF l_debug_on THEN
8844: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
8845: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
8846: END IF;
8847: --
8848:
8849: WHEN others THEN

Line 9047: WHEN FND_API.G_EXC_ERROR THEN

9043: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9044: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ACTION');
9045: END IF;
9046:
9047: WHEN FND_API.G_EXC_ERROR THEN
9048: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9049: --
9050: -- Debug Statements
9051: --

Line 9053: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

9049: --
9050: -- Debug Statements
9051: --
9052: IF l_debug_on THEN
9053: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9054: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9055: END IF;
9056: WHEN OTHERS THEN
9057: wsh_util_core.default_handler('wsh_trips_actions',l_module_name);

Line 9054: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

9050: -- Debug Statements
9051: --
9052: IF l_debug_on THEN
9053: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9054: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9055: END IF;
9056: WHEN OTHERS THEN
9057: wsh_util_core.default_handler('wsh_trips_actions',l_module_name);
9058: --