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_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_CARRIERS

Line 1003: wsh_carriers wc

999: SELECT wc.carrier_id
1000: FROM wsh_locations wl,
1001: hz_party_sites hps,
1002: hz_parties hp,
1003: wsh_carriers wc
1004: WHERE wl.wsh_location_id = c_location_id
1005: AND wl.location_source_code = 'HZ'
1006: AND wl.source_location_id = hps.location_id
1007: AND hps.party_id = hp.party_id

Line 7593: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

7589: l_location_id NUMBER := NULL;
7590: l_vehicle_type NUMBER := NULL;
7591: l_mode VARCHAR2(30) := NULL;
7592: l_service_level VARCHAR2(30) := NULL;
7593: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
7594: l_inp_items_cnt NUMBER := 0;
7595: l_const_count NUMBER := 0;
7596: l_return_status VARCHAR2(1);
7597: l_inp_dlvy_cus BOOLEAN := TRUE;

Line 7694: WSH_CARRIERS_GRP.get_carrier_service_mode(

7690: (p_target_trip.ship_method_code IS NOT NULL) THEN
7691:
7692: l_carrier_service_inout_rec.ship_method_code := p_target_trip.ship_method_code;
7693:
7694: WSH_CARRIERS_GRP.get_carrier_service_mode(
7695: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
7696: x_return_status => l_return_status);
7697:
7698: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 8507: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

8503:
8504: l_return_status VARCHAR2(1);
8505: l_mode VARCHAR2(30) := NULL;
8506: l_service_level VARCHAR2(30) := NULL;
8507: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
8508: l_validate_carrier_result VARCHAR2(1) := 'S';
8509: l_validate_mode_result VARCHAR2(1) := 'S';
8510:
8511: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'check_act_positive';

Line 8527: WSH_CARRIERS_GRP.get_carrier_service_mode(

8523: IF (p_delivery_rec.carrier_id IS NULL OR p_delivery_rec.mode_of_transport IS NULL) AND
8524: (p_delivery_rec.ship_method_code IS NOT NULL) THEN
8525: l_carrier_service_inout_rec.ship_method_code := p_delivery_rec.ship_method_code;
8526:
8527: WSH_CARRIERS_GRP.get_carrier_service_mode(
8528: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
8529: x_return_status => l_return_status);
8530:
8531: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 9920: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

9916: l_carrier NUMBER := NULL;
9917: l_vehicle_type NUMBER := NULL;
9918: l_mode VARCHAR2(30) := NULL;
9919: l_service_level VARCHAR2(30) := NULL;
9920: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
9921: l_out_object2_num NUMBER:=0;
9922: l_out_object2_char VARCHAR2(30):=NULL;
9923: l_linegroup_indx NUMBER := 0;
9924: l_return_status VARCHAR2(1);

Line 9987: WSH_CARRIERS_GRP.get_carrier_service_mode(

9983: IF (p_target_trip.carrier_id IS NULL OR p_target_trip.MODE_OF_TRANSPORT IS NULL) AND
9984: (p_target_trip.ship_method_code IS NOT NULL) THEN
9985: l_carrier_service_inout_rec.ship_method_code := p_target_trip.ship_method_code;
9986:
9987: WSH_CARRIERS_GRP.get_carrier_service_mode(
9988: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
9989: x_return_status => l_return_status);
9990:
9991: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 11221: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

11217: j NUMBER := 0;
11218: l_carrier NUMBER := 0;
11219: l_mode VARCHAR2(30);
11220: l_service_level VARCHAR2(30) := NULL;
11221: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
11222: l_return_status VARCHAR2(1);
11223: l_validate_result VARCHAR2(1);
11224: l_failed_constraint line_constraint_rec_type;
11225: l_validate_faccar_result VARCHAR2(1) := 'S';

Line 11245: WSH_CARRIERS_GRP.get_carrier_service_mode(

11241: IF (p_delivery_rec.carrier_id IS NULL OR p_delivery_rec.MODE_OF_TRANSPORT IS NULL) AND
11242: (p_delivery_rec.ship_method_code IS NOT NULL) THEN
11243:
11244: l_carrier_service_inout_rec.ship_method_code := p_delivery_rec.ship_method_code;
11245: WSH_CARRIERS_GRP.get_carrier_service_mode(
11246: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
11247: x_return_status => l_return_status);
11248:
11249: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 11662: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

11658: l_carrier NUMBER := NULL;
11659: l_vehicle_type NUMBER := NULL;
11660: l_mode VARCHAR2(30) := NULL;
11661: l_service_level VARCHAR2(30) := NULL;
11662: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
11663: l_location_id NUMBER := NULL;
11664: l_validate_carrier_result VARCHAR2(1) := 'S';
11665: l_validate_vehicle_result VARCHAR2(1) := 'S';
11666: l_validate_mode_result VARCHAR2(1) := 'S';

Line 12469: WSH_CARRIERS_GRP.get_carrier_service_mode(

12465: IF (l_target_trip.carrier_id IS NULL OR l_target_trip.MODE_OF_TRANSPORT IS NULL) AND
12466: (l_target_trip.ship_method_code IS NOT NULL) THEN
12467:
12468: l_carrier_service_inout_rec.ship_method_code := l_target_trip.ship_method_code;
12469: WSH_CARRIERS_GRP.get_carrier_service_mode(
12470: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
12471: x_return_status => l_return_status);
12472:
12473: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 13154: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

13150: l_carrier NUMBER := NULL;
13151: l_vehicle_type NUMBER := NULL;
13152: l_mode VARCHAR2(30) := NULL;
13153: l_service_level VARCHAR2(30) := NULL;
13154: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
13155: l_facility_id NUMBER := 0;
13156: l_failed_constraint line_constraint_rec_type;
13157: l_failed_constraints line_constraint_tab_type;
13158: l_validate_carrier_result VARCHAR2(1) := 'S';

Line 14434: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

14430: l_found BOOLEAN := FALSE;
14431: l_failed_line_added BOOLEAN := FALSE;
14432: l_mode VARCHAR2(30) := NULL;
14433: l_service_level VARCHAR2(30) := NULL;
14434: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
14435: l_intmed_location_id NUMBER:=0;
14436: l_hash_string VARCHAR2(200);
14437: l_hash_value NUMBER:=0;
14438: l_return_status VARCHAR2(1);

Line 15277: WSH_CARRIERS_GRP.get_carrier_service_mode(

15273:
15274: IF p_action_code = G_ASSIGN_DLVB_DLVY THEN
15275: IF l_target_delivery.ship_method_code IS NOT NULL THEN
15276: l_carrier_service_inout_rec.ship_method_code := l_target_delivery.ship_method_code;
15277: WSH_CARRIERS_GRP.get_carrier_service_mode(
15278: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
15279: x_return_status => l_return_status);
15280:
15281: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 15301: WSH_CARRIERS_GRP.get_carrier_service_mode(

15297: END IF;
15298: ELSIF p_action_code = G_AUTOCRT_DLVY THEN
15299: IF l_del_detail_info(j).ship_method_code IS NOT NULL THEN
15300: l_carrier_service_inout_rec.ship_method_code := l_del_detail_info(j).ship_method_code;
15301: WSH_CARRIERS_GRP.get_carrier_service_mode(
15302: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
15303: x_return_status => l_return_status);
15304:
15305: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 15716: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

15712: l_carrier NUMBER := 0;
15713: l_vehicle_type NUMBER := 0;
15714: l_mode VARCHAR2(30);
15715: l_service_level VARCHAR2(30) := NULL;
15716: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
15717: l_trip_del_cnt NUMBER := 0;
15718: l_trip_detail_cnt NUMBER := 0;
15719: l_trip_stops_cnt NUMBER := 0;
15720: l_out_object2_num NUMBER:=0;

Line 16045: WSH_CARRIERS_GRP.get_carrier_service_mode(

16041: IF (p_trip_info(j).carrier_id IS NULL OR p_trip_info(j).mode_of_transport IS NULL) AND
16042: (p_trip_info(j).ship_method_code IS NOT NULL) THEN
16043:
16044: l_carrier_service_inout_rec.ship_method_code := p_trip_info(j).ship_method_code;
16045: WSH_CARRIERS_GRP.get_carrier_service_mode(
16046: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
16047: x_return_status => l_return_status);
16048:
16049: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 16719: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

16715: l_carrier NUMBER := NULL;
16716: l_vehicle_type NUMBER := NULL;
16717: l_mode VARCHAR2(30) := NULL;
16718: l_service_level VARCHAR2(30) := NULL;
16719: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
16720: l_trips_cnt NUMBER := 0;
16721: l_trip_del_cnt NUMBER := 0;
16722: l_trip_detail_cnt NUMBER := 0;
16723: l_trip_stop_cnt NUMBER := 0;

Line 17009: WSH_CARRIERS_GRP.get_carrier_service_mode(

17005: (l_parent_trip_info(k).ship_method_code IS NOT NULL) THEN
17006:
17007: l_carrier_service_inout_rec.ship_method_code := l_parent_trip_info(k).ship_method_code;
17008:
17009: WSH_CARRIERS_GRP.get_carrier_service_mode(
17010: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
17011: x_return_status => l_return_status);
17012:
17013: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN