DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_FTE_INTEGRATION

Line 6003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);

5999: --
6000: -- Debug Statements
6001: --
6002: IF l_debug_on THEN
6003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
6004: END IF;
6005: --
6006: wsh_fte_integration.trip_stop_validations
6007: (p_stop_rec => l_stop_rec,

Line 6006: wsh_fte_integration.trip_stop_validations

6002: IF l_debug_on THEN
6003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
6004: END IF;
6005: --
6006: wsh_fte_integration.trip_stop_validations
6007: (p_stop_rec => l_stop_rec,
6008: p_trip_rec => l_trip_rec,
6009: p_action => 'UPDATE',
6010: x_return_status => l_return_status);

Line 9988: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);

9984: -- the new stop location
9985: l_stop_rec.stop_location_id := p_location_id;
9986: -- End of Code changes made in J+
9987: IF l_debug_on THEN
9988: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
9989: END IF;
9990: --
9991: wsh_fte_integration.trip_stop_validations
9992: (p_stop_rec => l_stop_rec,

Line 9991: wsh_fte_integration.trip_stop_validations

9987: IF l_debug_on THEN
9988: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
9989: END IF;
9990: --
9991: wsh_fte_integration.trip_stop_validations
9992: (p_stop_rec => l_stop_rec,
9993: p_trip_rec => l_trip_rec,
9994: p_action => 'UPDATE',
9995: x_return_status => l_return_status);

Line 10785: p_cs_mleg_result_tab IN OUT NOCOPY WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,

10781: --
10782: -- ----------------------------------------------------------------------
10783:
10784: PROCEDURE SET_PICK_UP_DROP_OFF_DATES(
10785: p_cs_mleg_result_tab IN OUT NOCOPY WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
10786: x_return_status OUT NOCOPY VARCHAR2,
10787: x_msg_count OUT NOCOPY NUMBER,
10788: x_msg_data OUT NOCOPY VARCHAR2
10789: ) IS

Line 11089: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,

11085:
11086: -- Result table will be of type Shipping
11087:
11088: PROCEDURE FORMAT_DEL_UPDATE_TABLE(--p_cs_result_tab IN FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
11089: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
11090: p_caller IN VARCHAR2 DEFAULT NULL,
11091: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11092: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
11093: x_return_message OUT NOCOPY VARCHAR2,

Line 11674: l_cs_mleg_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;

11670: l_prev_trip_id NUMBER;
11671: l_trip_name VARCHAR2(30);
11672: l_delivery_id NUMBER;
11673: list_cnt NUMBER;
11674: l_cs_mleg_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11675: l_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;
11676:
11677: l_rank_id NUMBER;
11678: l_trip_rank_seq NUMBER;

Line 11675: l_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;

11671: l_trip_name VARCHAR2(30);
11672: l_delivery_id NUMBER;
11673: list_cnt NUMBER;
11674: l_cs_mleg_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11675: l_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;
11676:
11677: l_rank_id NUMBER;
11678: l_trip_rank_seq NUMBER;
11679: l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'N';

Line 11681: x_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;

11677: l_rank_id NUMBER;
11678: l_trip_rank_seq NUMBER;
11679: l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'N';
11680: -- sachin
11681: x_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;
11682: -- Rename
11683:
11684:
11685: l_initial_pickup_date DATE;

Line 11702: l_carrier_sel_entity_tab WSH_FTE_INTEGRATION.WSH_CS_ENTITY_TAB_TYPE;

11698:
11699: --
11700: -- sbakshi
11701: --
11702: l_carrier_sel_entity_tab WSH_FTE_INTEGRATION.WSH_CS_ENTITY_TAB_TYPE;
11703:
11704: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;
11705:
11706: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;

Line 11704: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;

11700: -- sbakshi
11701: --
11702: l_carrier_sel_entity_tab WSH_FTE_INTEGRATION.WSH_CS_ENTITY_TAB_TYPE;
11703:
11704: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;
11705:
11706: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11707: l_cs_output_message_tab WSH_FTE_INTEGRATION.wsh_cs_output_message_tab;
11708:

Line 11706: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;

11702: l_carrier_sel_entity_tab WSH_FTE_INTEGRATION.WSH_CS_ENTITY_TAB_TYPE;
11703:
11704: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;
11705:
11706: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11707: l_cs_output_message_tab WSH_FTE_INTEGRATION.wsh_cs_output_message_tab;
11708:
11709:
11710: l_dlvy_info_tab wsh_cs_delivery_info_tab;

Line 11707: l_cs_output_message_tab WSH_FTE_INTEGRATION.wsh_cs_output_message_tab;

11703:
11704: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;
11705:
11706: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11707: l_cs_output_message_tab WSH_FTE_INTEGRATION.wsh_cs_output_message_tab;
11708:
11709:
11710: l_dlvy_info_tab wsh_cs_delivery_info_tab;
11711: l_dlvy_info_rec wsh_cs_delivery_info_rec;

Line 12134: WSH_FTE_INTEGRATION.CARRIER_SELECTION( p_format_cs_tab => l_carrier_sel_entity_tab,

12130: --
12131: -- Call Carrier Selection Engine
12132: --
12133:
12134: WSH_FTE_INTEGRATION.CARRIER_SELECTION( p_format_cs_tab => l_carrier_sel_entity_tab,
12135: p_messaging_yn => l_messaging_yn,
12136: p_caller => p_caller,
12137: p_entity => 'DLVY',
12138: x_cs_output_tab => l_cs_result_tab,

Line 12296: WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP(

12292: END IF;
12293: --
12294: -- Since delivery not assigned to any trip( trip_id is null), and rank = 1, Create trip for the delivery
12295: --
12296: WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP(
12297: p_delivery_id => l_delivery_id,
12298: p_carrier_sel_result_rec => l_carrier_sel_result_rec,
12299: x_trip_id => l_trip_id,
12300: x_trip_name => l_trip_name,

Line 12435: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(

12431: IF l_debug_on THEN
12432: WSH_DEBUG_SV.logmsg(l_module_name, 'calling RANK_LIST_ACTION');
12433: END IF;
12434:
12435: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(
12436: --p_api_version_number => 1.0,
12437: --p_init_msg_list => FND_API.G_FALSE,
12438: x_return_status => l_return_status,
12439: x_msg_count => l_msg_count,

Line 12553: WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP(

12549: WSH_DEBUG_SV.logmsg(l_module_name,'l_cs_result_tab(j).ultimate_dropoff_location_id: '||l_cs_result_tab(j).ultimate_dropoff_location_id);
12550: END IF;
12551:
12552: l_carrier_sel_result_rec := l_cs_result_tab(j);
12553: WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP(
12554: p_delivery_id => l_delivery_id,
12555: p_carrier_sel_result_rec => l_carrier_sel_result_rec,
12556: x_trip_id => l_trip_id,
12557: x_trip_name => l_trip_name,

Line 12589: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(

12585: --
12586: -- Create and attach ranked list to each trip
12587: --
12588:
12589: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(
12590: -- p_api_version_number => 1.0,
12591: -- p_init_msg_list => FND_API.G_FALSE,
12592: x_return_status => l_return_status,
12593: x_msg_count => l_msg_count,