DBA Data[Home] [Help]

APPS.FTE_DELIVERY_LEGS_PVT dependencies on FTE_MLS_UTIL

Line 501: := FTE_MLS_UTIL.segment_has_other_deliveries

497: l_segment_has_other_deliveries := FALSE;
498: --
499: --
500: l_segment_has_other_deliveries
501: := FTE_MLS_UTIL.segment_has_other_deliveries
502: (
503: p_trip_segment_id => p_wsh_trip_id,
504: p_delivery_id => p_delivery_id
505: );

Line 617: fte_mls_util.derive_ship_method

613: --
614: IF l_wsh_trip_action IN ( K_CREATE, K_UPDATE )
615: THEN
616: --{
617: fte_mls_util.derive_ship_method
618: (
619: p_carrier_id => p_carrier_id,
620: p_mode_of_transport => p_mode_of_transport,
621: p_service_level => p_service_level,

Line 630: FTE_MLS_UTIL.api_post_call

626: x_return_status => l_return_status
627: );
628: --
629: --
630: FTE_MLS_UTIL.api_post_call
631: (
632: p_api_name => 'FTE_MLS_UTIL.DERIVE_SHIP_METHOD',
633: p_api_return_status => l_return_status,
634: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',

Line 632: p_api_name => 'FTE_MLS_UTIL.DERIVE_SHIP_METHOD',

628: --
629: --
630: FTE_MLS_UTIL.api_post_call
631: (
632: p_api_name => 'FTE_MLS_UTIL.DERIVE_SHIP_METHOD',
633: p_api_return_status => l_return_status,
634: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',
635: p_delivery_id => p_delivery_id,
636: p_delivery_name => p_delivery_name,

Line 706: FTE_MLS_UTIL.api_post_call

702: x_stop_id => l_stop_id
703: );
704: --
705: --
706: FTE_MLS_UTIL.api_post_call
707: (
708: p_api_name => 'FTE_MLS_WRAPPER.UPDATE_STOP',
709: p_api_return_status => l_return_status,
710: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',

Line 791: FTE_MLS_UTIL.api_post_call

787: p_rec_IGNORE_FOR_PLANNING => p_ignore_for_planning
788: );
789: --
790: --
791: FTE_MLS_UTIL.api_post_call
792: (
793: p_api_name => 'FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP',
794: p_api_return_status => l_return_status,
795: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',

Line 850: FTE_MLS_UTIL.api_post_call

846: p_veh_item_id => p_veh_item_id
847: );
848: --
849: --
850: FTE_MLS_UTIL.api_post_call
851: (
852: p_api_name => 'FTE_DELIVERY_LEGS_PVT.ASSIGN_SERVICE_TO_SEGMENT',
853: p_api_return_status => l_return_status,
854: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',

Line 945: FTE_MLS_UTIL.api_post_call

941: END IF;
942:
943: --
944: --
945: FTE_MLS_UTIL.api_post_call
946: (
947: p_api_name => 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP',
948: p_api_return_status => l_return_status,
949: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',

Line 1038: FTE_MLS_UTIL.api_post_call

1034:
1035:
1036: --
1037: --
1038: FTE_MLS_UTIL.api_post_call
1039: (
1040: p_api_name => 'FTE_MLS_WRAPPER.CREATE_UPDATE_STOP',
1041: p_api_return_status => l_return_status,
1042: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',

Line 1099: FTE_MLS_UTIL.api_post_call

1095: WSH_DEBUG_SV.logmsg(l_api_name, ' DELIVERY Action RETURN VALUE ' || l_return_status,
1096: WSH_DEBUG_SV.C_PROC_LEVEL);
1097: END IF;
1098:
1099: FTE_MLS_UTIL.api_post_call
1100: (
1101: p_api_name => 'FTE_MLS_WRAPPER.DELIVERY_ACTION',
1102: p_api_return_status => l_return_status,
1103: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',

Line 1146: FTE_MLS_UTIL.api_post_call

1142: x_name => l_fte_trip_name
1143: );
1144: --
1145: --
1146: FTE_MLS_UTIL.api_post_call
1147: (
1148: p_api_name => 'FTE_TRIPS_PVT.CREATE_UPDATE_DELETE_FTE_TRIP',
1149: p_api_return_status => l_return_status,
1150: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',

Line 1183: FTE_MLS_UTIL.api_post_call

1179: p_validate_flag => 'N'
1180: );
1181: --
1182: --
1183: FTE_MLS_UTIL.api_post_call
1184: (
1185: p_api_name => 'FTE_WSH_TRIPS_PVT.CREATE_UPDATE_TRIP_WRAPPER',
1186: p_api_return_status => l_return_status,
1187: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',

Line 1230: FTE_MLS_UTIL.api_post_call

1226: --{
1227: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1228: --
1229: --
1230: FTE_MLS_UTIL.api_post_call
1231: (
1232: p_api_name => 'FTE_DELIVERY_LEGS_PVT.UPDATE_DLEG_FTE_TRIP',
1233: p_api_return_status => l_return_status,
1234: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',

Line 1280: FTE_MLS_UTIL.api_post_call

1276: --{
1277: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1278: --
1279: --
1280: FTE_MLS_UTIL.api_post_call
1281: (
1282: p_api_name => 'FTE_DELIVERY_LEGS_PVT.UPDATE_DLEG_REPRICE',
1283: p_api_return_status => l_return_status,
1284: p_message_name => 'FTE_DELIVERY_LEG_UNEXP_ERROR',

Line 1328: FTE_MLS_UTIL.api_post_call

1324: p_service_type_code => p_service_level
1325: );
1326: --
1327: --
1328: FTE_MLS_UTIL.api_post_call
1329: (
1330: p_api_name => 'FTE_FREIGHT_PRICING.MOVE_FC_TEMP_TO_MAIN',
1331: p_api_return_status => l_return_status,
1332: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',

Line 1563: FTE_MLS_UTIL.api_post_call

1559: OR p_last_stop_arrival_date IS NULL
1560: )
1561: THEN
1562: --{
1563: FTE_MLS_UTIL.api_post_call
1564: (
1565: p_api_name => 'FIRST_LAST_ID_DATES_NULL',
1566: p_api_return_status => WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR,
1567: p_message_name => 'FTE_SEGMENT_UNEXP_ERROR',

Line 1682: FTE_MLS_UTIL.api_post_call

1678: x_stop_id => l_stop_id
1679: );
1680: --
1681: --
1682: FTE_MLS_UTIL.api_post_call
1683: (
1684: p_api_name => 'FTE_MLS_WRAPPER.UPDATE_STOP',
1685: p_api_return_status => l_return_status,
1686: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',

Line 1738: FTE_MLS_UTIL.api_post_call

1734: x_stop_id => l_stop_id
1735: );
1736: --
1737: --
1738: FTE_MLS_UTIL.api_post_call
1739: (
1740: p_api_name => 'FTE_MLS_WRAPPER.UPDATE_STOP',
1741: p_api_return_status => l_return_status,
1742: p_message_name => 'FTE_SEGMENT_STOP_UNEXP_ERROR',

Line 1815: FTE_MLS_UTIL.api_post_call

1811: x_MSG_COUNT => l_msg_count,
1812: x_MSG_DATA => l_msg_data);
1813: --
1814: */
1815: FTE_MLS_UTIL.api_post_call
1816: (
1817: p_api_name => 'FTE_MLS_WRAPPER.CREATE_UPDATE_TRIP',
1818: p_api_return_status => l_return_status,
1819: p_message_name => 'FTE_SEGMENT_UNEXP_ERROR',

Line 2186: fte_mls_util.get_location_info(

2182: l_location :=null;
2183: l_csz :=null;
2184: l_country :=null;
2185: l_return_status :=null;
2186: fte_mls_util.get_location_info(
2187: p_location_id => get_pickup_info_rec.stop_location_id,
2188: x_location => l_location,
2189: x_csz => l_csz,
2190: x_country => l_country,

Line 2277: fte_mls_util.get_location_info(

2273: ELSE
2274: l_location_id := get_dropoff_info_rec.physical_location_id;
2275: END IF;
2276:
2277: fte_mls_util.get_location_info(
2278: p_location_id => l_location_id,
2279: x_location => l_location,
2280: x_csz => l_csz,
2281: x_country => l_country,

Line 2359: fte_mls_util.get_location_info(

2355: l_csz :=null;
2356: l_country :=null;
2357: l_return_status :=null;
2358:
2359: fte_mls_util.get_location_info(
2360: p_location_id => get_trip_seg_origin_rec.stop_location_id,
2361: x_location => l_location,
2362: x_csz => l_csz,
2363: x_country => l_country,

Line 2418: fte_mls_util.get_location_info(

2414: l_location_id := get_trip_seg_dest_rec.physical_location_id;
2415: END IF;
2416:
2417:
2418: fte_mls_util.get_location_info(
2419: p_location_id => l_location_id,
2420: x_location => l_location,
2421: x_csz => l_csz,
2422: x_country => l_country,

Line 2456: x_CarrierName := fte_mls_util.get_carrier_name(x_CarrierId);

2452: --GET CARRIER INFO
2453: --
2454: IF (x_CarrierId IS NOT NULL)
2455: THEN
2456: x_CarrierName := fte_mls_util.get_carrier_name(x_CarrierId);
2457: END IF;
2458: --
2459: -- END OF GET CARRIER NAME
2460: --