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

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

Line 1125: raise FND_API.G_EXC_ERROR;

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

Line 1265: RAISE FND_API.G_EXC_ERROR;

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

Line 1329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1434: raise FND_API.G_EXC_ERROR;

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

Line 1461: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

Line 1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 1689: RAISE FND_API.G_EXC_ERROR;

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

Line 1735: p_init_msg_list => FND_API.G_FALSE,

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

Line 1736: p_commit => FND_API.G_FALSE,

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

Line 1782: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

Line 1792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

Line 2232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 3213: p_init_msg_list => FND_API.G_FALSE,

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

Line 3510: p_init_msg_list => FND_API.G_FALSE,

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

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

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

Line 5429: 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

5425: weight_uom_code,
5426: volume_uom_code
5427: FROM wsh_trip_stops
5428: WHERE trip_id = l_trip_id AND
5429: 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
5430: rownum = 1
5431: ORDER BY stop_sequence_number DESC;
5432:
5433: CURSOR last_stop (l_trip_id NUMBER) IS

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

7685: p_internal_cust_location_id => l_getstops_stop_loc_id(j),
7686: x_internal_org_location_id => l_getstops_phys_loc_id(j),
7687: x_return_status => l_return_status);
7688:
7689: IF l_return_status in (FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR) THEN
7690: RAISE get_physical_loc_err;
7691: END IF;
7692: END IF;
7693:

Line 8084: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

8080:
8081:
8082:
8083: PROCEDURE PROCESS_CARRIER_SELECTION (
8084: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8085: p_trip_id_tab IN wsh_util_core.id_tab_type,
8086: p_caller IN VARCHAR2 DEFAULT NULL, -- WSH_FSTRX / WSH_PUB / WSH_GROUP/ FTE
8087: x_msg_count OUT NOCOPY NUMBER,
8088: x_msg_data OUT NOCOPY VARCHAR2,

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

8214: l_pickup_volume_convert NUMBER := 0;
8215: l_total_pickup_weight NUMBER := 0;
8216: l_total_pickup_volume NUMBER := 0;
8217:
8218: l_commit VARCHAR2(100) := FND_API.G_FALSE;
8219: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8220:
8221: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8222: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

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

8215: l_total_pickup_weight NUMBER := 0;
8216: l_total_pickup_volume NUMBER := 0;
8217:
8218: l_commit VARCHAR2(100) := FND_API.G_FALSE;
8219: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8220:
8221: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8222: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
8223: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

Line 8252: IF FND_API.to_Boolean( p_init_msg_list ) THEN

8248: --
8249: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PROCESS_CARRIER_SELECTION';
8250: BEGIN
8251:
8252: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8253: FND_MSG_PUB.initialize;
8254: END IF;
8255:
8256: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 8660: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8656: x_return_status => l_return_status);
8657:
8658: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
8659: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
8660: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8661: END IF;
8662:
8663: --l_trip_info_tab(1).trip_id := l_trip_id;
8664: -- rank_list_action takes care of updating rank_id for the trip

Line 8690: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8686: x_out_tab => l_trip_out_rec_tab);
8687:
8688: --IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
8689: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
8690: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8691: END IF;
8692:
8693: --END IF;
8694:

Line 8738: p_init_msg_list => FND_API.G_FALSE,

8734: -- Call FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION(
8735:
8736: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(
8737: p_api_version => 1.0,
8738: p_init_msg_list => FND_API.G_FALSE,
8739: x_return_status => l_return_status,
8740: x_msg_count => l_msg_count,
8741: x_msg_data => l_msg_data,
8742: p_action_code => 'REPLACE',

Line 8749: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8745: p_rank_id => l_rank_id
8746: --x_ranklist => l_ranked_list
8747: );
8748: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
8749: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8750: END IF;
8751: l_ranked_list.DELETE;
8752: list_cnt := 0;
8753: END IF;

Line 8795: raise FND_API.G_EXC_UNEXPECTED_ERROR;

8791: END IF;
8792: --
8793: END IF;
8794: ELSE
8795: raise FND_API.G_EXC_UNEXPECTED_ERROR;
8796: END IF;
8797: -- TODO
8798: ELSE -- No eligible trips were found
8799: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_VALID_TRIPS');

Line 8817: p_encoded => FND_API.G_FALSE );

8813:
8814: FND_MSG_PUB.Count_And_Get (
8815: p_count => x_msg_count,
8816: p_data => x_msg_data ,
8817: p_encoded => FND_API.G_FALSE );
8818:
8819: IF l_debug_on THEN
8820: wsh_debug_sv.log (l_module_name,'No. of messages stacked : ',to_char(x_msg_count));
8821: wsh_debug_sv.pop(l_module_name);

Line 8827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8823:
8824: --
8825:
8826: EXCEPTION
8827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8828:
8829: ROLLBACK TO before_trip_update;
8830: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8831: --

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

8830: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
8831: --
8832: IF l_debug_on THEN
8833: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
8834: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
8835: END IF;
8836: --
8837:
8838: WHEN others THEN

Line 9036: WHEN FND_API.G_EXC_ERROR THEN

9032: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_ACTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9033: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_ACTION');
9034: END IF;
9035:
9036: WHEN FND_API.G_EXC_ERROR THEN
9037: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9038: --
9039: -- Debug Statements
9040: --

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

9038: --
9039: -- Debug Statements
9040: --
9041: IF l_debug_on THEN
9042: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9043: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9044: END IF;
9045: WHEN OTHERS THEN
9046: wsh_util_core.default_handler('wsh_trips_actions',l_module_name);

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

9039: -- Debug Statements
9040: --
9041: IF l_debug_on THEN
9042: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
9043: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
9044: END IF;
9045: WHEN OTHERS THEN
9046: wsh_util_core.default_handler('wsh_trips_actions',l_module_name);
9047: --