DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_FTE_INTEGRATION

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

6100: --
6101: -- Debug Statements
6102: --
6103: IF l_debug_on THEN
6104: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
6105: END IF;
6106: --
6107: wsh_fte_integration.trip_stop_validations
6108: (p_stop_rec => l_stop_rec,

Line 6107: wsh_fte_integration.trip_stop_validations

6103: IF l_debug_on THEN
6104: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
6105: END IF;
6106: --
6107: wsh_fte_integration.trip_stop_validations
6108: (p_stop_rec => l_stop_rec,
6109: p_trip_rec => l_trip_rec,
6110: p_action => 'UPDATE',
6111: x_return_status => l_return_status);

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

10180: -- the new stop location
10181: l_stop_rec.stop_location_id := p_location_id;
10182: -- End of Code changes made in J+
10183: IF l_debug_on THEN
10184: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
10185: END IF;
10186: --
10187: wsh_fte_integration.trip_stop_validations
10188: (p_stop_rec => l_stop_rec,

Line 10187: wsh_fte_integration.trip_stop_validations

10183: IF l_debug_on THEN
10184: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_FTE_INTEGRATION.TRIP_STOP_VALIDATIONS',WSH_DEBUG_SV.C_PROC_LEVEL);
10185: END IF;
10186: --
10187: wsh_fte_integration.trip_stop_validations
10188: (p_stop_rec => l_stop_rec,
10189: p_trip_rec => l_trip_rec,
10190: p_action => 'UPDATE',
10191: x_return_status => l_return_status);

Line 10981: p_cs_mleg_result_tab IN OUT NOCOPY WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,

10977: --
10978: -- ----------------------------------------------------------------------
10979:
10980: PROCEDURE SET_PICK_UP_DROP_OFF_DATES(
10981: p_cs_mleg_result_tab IN OUT NOCOPY WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
10982: x_return_status OUT NOCOPY VARCHAR2,
10983: x_msg_count OUT NOCOPY NUMBER,
10984: x_msg_data OUT NOCOPY VARCHAR2
10985: ) IS

Line 11285: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,

11281:
11282: -- Result table will be of type Shipping
11283:
11284: PROCEDURE FORMAT_DEL_UPDATE_TABLE(--p_cs_result_tab IN FTE_ACS_PKG.FTE_CS_RESULT_TAB_TYPE,
11285: p_cs_result_tab IN WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE,
11286: p_caller IN VARCHAR2 DEFAULT NULL,
11287: x_rec_attr_tab OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11288: x_trip_info_tab OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
11289: x_return_message OUT NOCOPY VARCHAR2,

Line 11870: l_cs_mleg_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;

11866: l_prev_trip_id NUMBER;
11867: l_trip_name VARCHAR2(30);
11868: l_delivery_id NUMBER;
11869: list_cnt NUMBER;
11870: l_cs_mleg_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11871: l_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;
11872:
11873: l_rank_id NUMBER;
11874: l_trip_rank_seq NUMBER;

Line 11871: l_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;

11867: l_trip_name VARCHAR2(30);
11868: l_delivery_id NUMBER;
11869: list_cnt NUMBER;
11870: l_cs_mleg_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11871: l_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;
11872:
11873: l_rank_id NUMBER;
11874: l_trip_rank_seq NUMBER;
11875: --l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'N'; -- Commented for the bug 14768761

Line 11878: x_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;

11874: l_trip_rank_seq NUMBER;
11875: --l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'N'; -- Commented for the bug 14768761
11876: l_skip_rtng_rule_ac_trip VARCHAR2(1) := 'Y'; -- Added for the bug 14768761
11877: -- sachin
11878: x_ranked_list WSH_FTE_INTEGRATION.CARRIER_RANK_LIST_TBL_TYPE;
11879: -- Rename
11880: l_initial_pickup_date DATE;
11881: l_ultimate_dropoff_date DATE;
11882: i NUMBER;

Line 11897: l_carrier_sel_entity_tab WSH_FTE_INTEGRATION.WSH_CS_ENTITY_TAB_TYPE;

11893:
11894: --
11895: -- sbakshi
11896: --
11897: l_carrier_sel_entity_tab WSH_FTE_INTEGRATION.WSH_CS_ENTITY_TAB_TYPE;
11898:
11899: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;
11900:
11901: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;

Line 11899: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;

11895: -- sbakshi
11896: --
11897: l_carrier_sel_entity_tab WSH_FTE_INTEGRATION.WSH_CS_ENTITY_TAB_TYPE;
11898:
11899: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;
11900:
11901: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11902: l_cs_output_message_tab WSH_FTE_INTEGRATION.wsh_cs_output_message_tab;
11903:

Line 11901: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;

11897: l_carrier_sel_entity_tab WSH_FTE_INTEGRATION.WSH_CS_ENTITY_TAB_TYPE;
11898:
11899: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;
11900:
11901: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11902: l_cs_output_message_tab WSH_FTE_INTEGRATION.wsh_cs_output_message_tab;
11903:
11904:
11905: l_dlvy_info_tab wsh_cs_delivery_info_tab;

Line 11902: l_cs_output_message_tab WSH_FTE_INTEGRATION.wsh_cs_output_message_tab;

11898:
11899: l_carrier_sel_result_rec WSH_FTE_INTEGRATION.WSH_CS_RESULT_REC_TYPE;
11900:
11901: l_cs_result_tab WSH_FTE_INTEGRATION.WSH_CS_RESULT_TAB_TYPE;
11902: l_cs_output_message_tab WSH_FTE_INTEGRATION.wsh_cs_output_message_tab;
11903:
11904:
11905: l_dlvy_info_tab wsh_cs_delivery_info_tab;
11906: l_dlvy_info_rec wsh_cs_delivery_info_rec;

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

12325: --
12326: -- Call Carrier Selection Engine
12327: --
12328:
12329: WSH_FTE_INTEGRATION.CARRIER_SELECTION( p_format_cs_tab => l_carrier_sel_entity_tab,
12330: p_messaging_yn => l_messaging_yn,
12331: p_caller => p_caller,
12332: p_entity => 'DLVY',
12333: x_cs_output_tab => l_cs_result_tab,

Line 12492: WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP(

12488: END IF;
12489: --
12490: -- Since delivery not assigned to any trip( trip_id is null), and rank = 1, Create trip for the delivery
12491: --
12492: WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP(
12493: p_delivery_id => l_delivery_id,
12494: p_carrier_sel_result_rec => l_carrier_sel_result_rec,
12495: x_trip_id => l_trip_id,
12496: x_trip_name => l_trip_name,

Line 12631: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(

12627: IF l_debug_on THEN
12628: WSH_DEBUG_SV.logmsg(l_module_name, 'calling RANK_LIST_ACTION');
12629: END IF;
12630:
12631: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(
12632: --p_api_version_number => 1.0,
12633: --p_init_msg_list => FND_API.G_FALSE,
12634: x_return_status => l_return_status,
12635: x_msg_count => l_msg_count,

Line 12750: WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP(

12746: 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);
12747: END IF;
12748:
12749: l_carrier_sel_result_rec := l_cs_result_tab(j);
12750: WSH_FTE_INTEGRATION.CARRIER_SEL_CREATE_TRIP(
12751: p_delivery_id => l_delivery_id,
12752: p_carrier_sel_result_rec => l_carrier_sel_result_rec,
12753: x_trip_id => l_trip_id,
12754: x_trip_name => l_trip_name,

Line 12786: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(

12782: --
12783: -- Create and attach ranked list to each trip
12784: --
12785:
12786: WSH_FTE_INTEGRATION.RANK_LIST_ACTION(
12787: -- p_api_version_number => 1.0,
12788: -- p_init_msg_list => FND_API.G_FALSE,
12789: x_return_status => l_return_status,
12790: x_msg_count => l_msg_count,