DBA Data[Home] [Help]

APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_CARRIERS_GRP

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 12470: WSH_CARRIERS_GRP.get_carrier_service_mode(

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

Line 13159: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

13155: l_carrier NUMBER := NULL;
13156: l_vehicle_type NUMBER := NULL;
13157: l_mode VARCHAR2(30) := NULL;
13158: l_service_level VARCHAR2(30) := NULL;
13159: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
13160: l_facility_id NUMBER := 0;
13161: l_failed_constraint line_constraint_rec_type;
13162: l_failed_constraints line_constraint_tab_type;
13163: l_validate_carrier_result VARCHAR2(1) := 'S';

Line 14439: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

14435: l_found BOOLEAN := FALSE;
14436: l_failed_line_added BOOLEAN := FALSE;
14437: l_mode VARCHAR2(30) := NULL;
14438: l_service_level VARCHAR2(30) := NULL;
14439: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
14440: l_intmed_location_id NUMBER:=0;
14441: l_hash_string VARCHAR2(200);
14442: l_hash_value NUMBER:=0;
14443: l_return_status VARCHAR2(1);

Line 15282: WSH_CARRIERS_GRP.get_carrier_service_mode(

15278:
15279: IF p_action_code = G_ASSIGN_DLVB_DLVY THEN
15280: IF l_target_delivery.ship_method_code IS NOT NULL THEN
15281: l_carrier_service_inout_rec.ship_method_code := l_target_delivery.ship_method_code;
15282: WSH_CARRIERS_GRP.get_carrier_service_mode(
15283: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
15284: x_return_status => l_return_status);
15285:
15286: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 15306: WSH_CARRIERS_GRP.get_carrier_service_mode(

15302: END IF;
15303: ELSIF p_action_code = G_AUTOCRT_DLVY THEN
15304: IF l_del_detail_info(j).ship_method_code IS NOT NULL THEN
15305: l_carrier_service_inout_rec.ship_method_code := l_del_detail_info(j).ship_method_code;
15306: WSH_CARRIERS_GRP.get_carrier_service_mode(
15307: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
15308: x_return_status => l_return_status);
15309:
15310: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 15721: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

15717: l_carrier NUMBER := 0;
15718: l_vehicle_type NUMBER := 0;
15719: l_mode VARCHAR2(30);
15720: l_service_level VARCHAR2(30) := NULL;
15721: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
15722: l_trip_del_cnt NUMBER := 0;
15723: l_trip_detail_cnt NUMBER := 0;
15724: l_trip_stops_cnt NUMBER := 0;
15725: l_out_object2_num NUMBER:=0;

Line 16050: WSH_CARRIERS_GRP.get_carrier_service_mode(

16046: IF (p_trip_info(j).carrier_id IS NULL OR p_trip_info(j).mode_of_transport IS NULL) AND
16047: (p_trip_info(j).ship_method_code IS NOT NULL) THEN
16048:
16049: l_carrier_service_inout_rec.ship_method_code := p_trip_info(j).ship_method_code;
16050: WSH_CARRIERS_GRP.get_carrier_service_mode(
16051: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
16052: x_return_status => l_return_status);
16053:
16054: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 16724: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

16720: l_carrier NUMBER := NULL;
16721: l_vehicle_type NUMBER := NULL;
16722: l_mode VARCHAR2(30) := NULL;
16723: l_service_level VARCHAR2(30) := NULL;
16724: l_carrier_service_inout_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
16725: l_trips_cnt NUMBER := 0;
16726: l_trip_del_cnt NUMBER := 0;
16727: l_trip_detail_cnt NUMBER := 0;
16728: l_trip_stop_cnt NUMBER := 0;

Line 17014: WSH_CARRIERS_GRP.get_carrier_service_mode(

17010: (l_parent_trip_info(k).ship_method_code IS NOT NULL) THEN
17011:
17012: l_carrier_service_inout_rec.ship_method_code := l_parent_trip_info(k).ship_method_code;
17013:
17014: WSH_CARRIERS_GRP.get_carrier_service_mode(
17015: p_carrier_service_inout_rec => l_carrier_service_inout_rec,
17016: x_return_status => l_return_status);
17017:
17018: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN