DBA Data[Home] [Help]

APPS.WSH_MDC_SRS dependencies on WSH_TRIPS_GRP

Line 188: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

184: l_init_msg_list VARCHAR2(1000);
185: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
186: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
187: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
188: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
189: l_trip_out WSH_TRIPS_GRP.tripActionOutRecType;
190: l_commit VARCHAR2(10);
191: l_api_version_number NUMBER := 1.0;
192: l_debug_on BOOLEAN;

Line 189: l_trip_out WSH_TRIPS_GRP.tripActionOutRecType;

185: l_failed_lines WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;
186: l_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
187: l_group_info WSH_FTE_COMP_CONSTRAINT_PKG.cc_group_tab_type;
188: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
189: l_trip_out WSH_TRIPS_GRP.tripActionOutRecType;
190: l_commit VARCHAR2(10);
191: l_api_version_number NUMBER := 1.0;
192: l_debug_on BOOLEAN;
193: l_exc_complete EXCEPTION;

Line 2565: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;

2561: p_trip_name_prefix IN VARCHAR2,
2562: x_trips_all IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
2563: x_return_status OUT NOCOPY VARCHAR2)
2564: IS
2565: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
2566: l_init_msg_list VARCHAR2(100);
2567: l_api_version_number NUMBER := 1.0;
2568: l_commit VARCHAR2(10);
2569: l_return_status VARCHAR2(1);

Line 2574: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

2570: l_msg_count NUMBER;
2571: l_msg_data VARCHAR2(2000);
2572: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2573: l_trip_info_rec WSH_TRIPS_PVT.trip_rec_type;
2574: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
2575: l_trip_id NUMBER;
2576: l_del_id NUMBER;
2577: l_trip_name VARCHAR2(30);
2578: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

Line 2590: l_unplan_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
2590: l_unplan_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2591: l_unplan_rec_attr WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2592: l_unplan_dummy_out WSH_TRIPS_GRP.tripActionOutRecType;
2593: l_unplan_dummy_def WSH_TRIPS_GRP.default_parameters_rectype;
2594: l_trips_all_count NUMBER;

Line 2592: l_unplan_dummy_out WSH_TRIPS_GRP.tripActionOutRecType;

2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
2590: l_unplan_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2591: l_unplan_rec_attr WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2592: l_unplan_dummy_out WSH_TRIPS_GRP.tripActionOutRecType;
2593: l_unplan_dummy_def WSH_TRIPS_GRP.default_parameters_rectype;
2594: l_trips_all_count NUMBER;
2595: l_trip_cr_flag BOOLEAN;
2596: i NUMBER;

Line 2593: l_unplan_dummy_def WSH_TRIPS_GRP.default_parameters_rectype;

2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;
2590: l_unplan_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2591: l_unplan_rec_attr WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2592: l_unplan_dummy_out WSH_TRIPS_GRP.tripActionOutRecType;
2593: l_unplan_dummy_def WSH_TRIPS_GRP.default_parameters_rectype;
2594: l_trips_all_count NUMBER;
2595: l_trip_cr_flag BOOLEAN;
2596: i NUMBER;
2597: m NUMBER;

Line 2665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

2661:
2662: l_commit := FND_API.g_false;
2663: IF l_debug_on THEN
2664: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
2665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2666: END IF;
2667:
2668: WSH_TRIPS_GRP.Create_Update_Trip(
2669: p_api_version_number => l_api_version_number,

Line 2668: WSH_TRIPS_GRP.Create_Update_Trip(

2664: WSH_DEBUG_SV.logmsg(l_module_name,'Creating deconsol trip');
2665: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2666: END IF;
2667:
2668: WSH_TRIPS_GRP.Create_Update_Trip(
2669: p_api_version_number => l_api_version_number,
2670: p_init_msg_list => l_init_msg_list,
2671: p_commit => l_commit,
2672: x_return_status => l_return_status,

Line 2688: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_GRP.Create_Update_Trip');

2684: END IF;
2685: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2686: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2687: THEN
2688: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_GRP.Create_Update_Trip');
2689: IF l_debug_on THEN
2690: FOR m in 1..l_msg_count
2691: LOOP
2692: l_message := fnd_msg_pub.get(m,'F');

Line 2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

2728: l_trip_info_tab(0) := l_trip_info_rec;
2729:
2730: IF l_debug_on THEN
2731: WSH_DEBUG_SV.logmsg(l_module_name,'Renaming deconsol trip, attaching prefix '||p_trip_name_prefix);
2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2733: END IF;
2734:
2735:
2736: WSH_TRIPS_GRP.Create_Update_Trip(

Line 2736: WSH_TRIPS_GRP.Create_Update_Trip(

2732: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
2733: END IF;
2734:
2735:
2736: WSH_TRIPS_GRP.Create_Update_Trip(
2737: p_api_version_number => l_api_version_number,
2738: p_init_msg_list => l_init_msg_list,
2739: p_commit => l_commit,
2740: x_return_status => l_return_status,

Line 2756: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_GRP.Create_Update_Trip');

2752: END IF;
2753: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2754: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2755: THEN
2756: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_GRP.Create_Update_Trip');
2757: IF l_debug_on THEN
2758: FOR m in 1..l_msg_count
2759: LOOP
2760: l_message := fnd_msg_pub.get(m,'F');

Line 2804: WSH_TRIPS_GRP.Trip_Action

2800:
2801:
2802:
2803:
2804: WSH_TRIPS_GRP.Trip_Action
2805: ( p_api_version_number => l_api_version_number,
2806: p_init_msg_list => l_init_msg_list,
2807: p_commit => l_commit,
2808: p_action_prms => l_unplan_action_prms,

Line 2824: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_GRP.Trip_Action');

2820: END IF;
2821: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2822: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2823: THEN
2824: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_GRP.Trip_Action');
2825: IF l_debug_on THEN
2826: FOR m in 1..l_msg_count
2827: LOOP
2828: l_message := fnd_msg_pub.get(m,'F');