[Home] [Help]
48: l_api_version_number CONSTANT NUMBER := 1.0;
49: l_api_name CONSTANT VARCHAR2(30):= 'Trip_Action';
50:
51: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
52: l_entity_id_tab wsh_util_core.id_tab_type;
53: --
54: trip_action_error EXCEPTION;
55:
56: l_trip_id NUMBER := p_trip_info.trip_id;
113: wsh_util_validate.validate_trip_name( l_trip_id,
114: p_trip_info.name,
115: x_return_status);
116:
117: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
118: raise trip_action_error;
119: END IF;
120:
121: l_action_prms.caller := 'WSH_API';
157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
158: END IF;
159: --
160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
161: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_trip_IN_rec.action_code));
162: wsh_util_core.add_message(x_return_status);
163:
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_ACTION_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
158: END IF;
159: --
160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
161: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_trip_IN_rec.action_code));
162: wsh_util_core.add_message(x_return_status);
163:
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_ACTION_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRIP_ACTION_ERROR');
254:
255: --
256: trip_action_error EXCEPTION;
257:
258: l_trip_rows wsh_util_core.id_tab_type;
259: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
260: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
261:
262:
310: END IF;
311: --
312: wsh_util_validate.validate_trip_name( l_trip_id, p_trip_name, x_return_status);
313:
314: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
315: raise trip_action_error;
316: END IF;
317:
318: l_trip_rows(1) := l_trip_id;
352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
353: END IF;
354: --
355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
356: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));
357: wsh_util_core.add_message(x_return_status);
358:
359: --
360: -- Debug Statements
353: END IF;
354: --
355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
356: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));
357: wsh_util_core.add_message(x_return_status);
358:
359: --
360: -- Debug Statements
361: --
437: x_msg_count OUT NOCOPY NUMBER,
438: x_msg_data OUT NOCOPY VARCHAR2)
439:
440: IS
441: l_trip_id_tab wsh_util_core.id_tab_type;
442: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
443: l_valid_id_tab wsh_util_core.id_tab_type;
444: l_dummy_ids wsh_util_core.id_tab_type;
445: l_valid_index_tab wsh_util_core.id_tab_type;
439:
440: IS
441: l_trip_id_tab wsh_util_core.id_tab_type;
442: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
443: l_valid_id_tab wsh_util_core.id_tab_type;
444: l_dummy_ids wsh_util_core.id_tab_type;
445: l_valid_index_tab wsh_util_core.id_tab_type;
446: l_error_ids wsh_util_core.id_tab_type;
447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
440: IS
441: l_trip_id_tab wsh_util_core.id_tab_type;
442: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
443: l_valid_id_tab wsh_util_core.id_tab_type;
444: l_dummy_ids wsh_util_core.id_tab_type;
445: l_valid_index_tab wsh_util_core.id_tab_type;
446: l_error_ids wsh_util_core.id_tab_type;
447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
448: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
441: l_trip_id_tab wsh_util_core.id_tab_type;
442: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
443: l_valid_id_tab wsh_util_core.id_tab_type;
444: l_dummy_ids wsh_util_core.id_tab_type;
445: l_valid_index_tab wsh_util_core.id_tab_type;
446: l_error_ids wsh_util_core.id_tab_type;
447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
448: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
449: l_dummy_doc_param WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
442: l_trip_rec_tab WSH_TRIP_VALIDATIONS.trip_rec_tab_type;
443: l_valid_id_tab wsh_util_core.id_tab_type;
444: l_dummy_ids wsh_util_core.id_tab_type;
445: l_valid_index_tab wsh_util_core.id_tab_type;
446: l_error_ids wsh_util_core.id_tab_type;
447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
448: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
449: l_dummy_doc_param WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
450: l_api_version_number CONSTANT NUMBER := 1.0;
459: l_num NUMBER;
460: l_return_status VARCHAR2(500);
461: l_report_set_id NUMBER := p_action_prms.report_set_id;
462: l_trip_org NUMBER;
463: l_temp_trip_id_tab wsh_util_core.id_tab_type;
464: l_mbol_error_count number;
465: l_unassign_all VARCHAR2(1);
466:
467: --Compatibility Changes
472: l_msg_count NUMBER;
473: l_msg_data VARCHAR2(2000);
474:
475: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
476: l_trip_id_tab_temp wsh_util_core.id_tab_type;
477: l_cc_count_success NUMBER;
478: b_cc_linefailed BOOLEAN;
479:
480: --dummy tables for calling validate_constraint_wrapper
481: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
482: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
483: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
484: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
485: l_cc_in_ids wsh_util_core.id_tab_type;
486: l_cc_fail_ids wsh_util_core.id_tab_type;
487:
488: --Compatibility Changes
489:
482: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
483: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
484: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
485: l_cc_in_ids wsh_util_core.id_tab_type;
486: l_cc_fail_ids wsh_util_core.id_tab_type;
487:
488: --Compatibility Changes
489:
490: l_debug_on BOOLEAN;
518: AND Wrs.Name = 'Master Bill of Lading';
519:
520: -- Added for bug 4493263
521: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;
522: l_dummy_id_tab wsh_util_core.id_tab_type;
523: l_pmbol_trip_id_tab wsh_util_core.id_tab_type;
524: l_doc_set_id NUMBER;
525:
526:
519:
520: -- Added for bug 4493263
521: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;
522: l_dummy_id_tab wsh_util_core.id_tab_type;
523: l_pmbol_trip_id_tab wsh_util_core.id_tab_type;
524: l_doc_set_id NUMBER;
525:
526:
527: -- J - MBOL
528: l_document_number VARCHAR2(50);
529: --
530: l_action_prms wsh_deliveries_grp.action_parameters_rectype;
531: l_del_action_out_rec wsh_deliveries_grp.Delivery_Action_Out_Rec_Type;
532: l_delivery_id_tab wsh_util_core.id_tab_type;
533: l_trip_name VARCHAR2(30);
534: l_cnt NUMBER;
535: e_end_of_api EXCEPTION;
536: -- J-IB-NPARIKH-}
551: -- End of OTM R12 : packing ECO
552:
553: BEGIN
554: -- Bugfix 4070732
555: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
556: THEN
557: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
558: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
559: END IF;
553: BEGIN
554: -- Bugfix 4070732
555: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
556: THEN
557: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
558: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
559: END IF;
560: -- End of Code Bugfix 4070732
561: --
554: -- Bugfix 4070732
555: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
556: THEN
557: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
558: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
559: END IF;
560: -- End of Code Bugfix 4070732
561: --
562: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
606: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
607: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_rec_attr_tab.COUNT');
608: RAISE e_req_field;
609: END IF;
610: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
611:
612: -- J-IB-NPARIKH-{
613: --
614: --
630: IF l_debug_on THEN
631: wsh_debug_sv.log(l_module_name,'Return Status After Calling generate_routing_response',l_return_status);
632: END IF;
633: --
634: wsh_util_core.api_post_call(
635: p_return_status => l_return_status,
636: x_num_warnings => l_num_warning,
637: x_num_errors => l_num_errors);
638: --
675: x_return_status => l_return_status);
676:
677:
678:
679: wsh_util_core.api_post_call(p_return_status =>l_return_status,
680: x_num_warnings =>l_num_warning,
681: x_num_errors =>l_num_errors);
682:
683: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
692: x_valid_ids => l_valid_id_tab ,
693: x_error_ids => l_error_ids ,
694: x_valid_index_tab => l_valid_index_tab);
695:
696: wsh_util_core.api_post_call(p_return_status =>l_return_status,
697: x_num_warnings =>l_num_warning,
698: x_num_errors =>l_num_errors,
699: p_msg_data => NULL,
700: p_raise_error_flag => FALSE);
710: p_valid_index_tab => l_valid_index_tab,
711: x_valid_ids_tab => x_trip_out_rec.valid_ids_tab,
712: x_return_status => l_return_status);
713:
714: wsh_util_core.api_post_call(p_return_status =>l_return_status,
715: x_num_warnings =>l_num_warning,
716: x_num_errors =>l_num_errors,
717: p_msg_data => NULL,
718: p_raise_error_flag => FALSE);
726: p_trip_name => p_action_prms.trip_name,
727: x_def_rec => x_def_rec,
728: x_return_status => l_return_status);
729:
730: wsh_util_core.api_post_call(p_return_status =>l_return_status,
731: x_num_warnings =>l_num_warning,
732: x_num_errors =>l_num_errors,
733: p_msg_data => NULL,
734: p_raise_error_flag => FALSE);
738:
739:
740: IF(l_num_errors >0 ) THEN
741: --
742: x_return_status := wsh_util_core.g_ret_sts_error;
743: --
744: IF (p_action_prms.caller = 'WSH_FSTRX') THEN
745: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION');
746: wsh_util_core.add_message(x_return_status,l_module_name);
742: x_return_status := wsh_util_core.g_ret_sts_error;
743: --
744: IF (p_action_prms.caller = 'WSH_FSTRX') THEN
745: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION');
746: wsh_util_core.add_message(x_return_status,l_module_name);
747: END IF;
748: --
749: IF l_debug_on THEN
750: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION');
763: x_trip_out_rec.selection_issue_flag := 'Y';
764: END IF;
765:
766: IF l_num_warning > 0 THEN
767: x_return_status := wsh_util_core.g_ret_sts_warning;
768: --
769: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION_WARN');
770: wsh_util_core.add_message(x_return_status,l_module_name);
771: --
766: IF l_num_warning > 0 THEN
767: x_return_status := wsh_util_core.g_ret_sts_warning;
768: --
769: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION_WARN');
770: wsh_util_core.add_message(x_return_status,l_module_name);
771: --
772: IF l_debug_on THEN
773: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION_WARN');
774: END IF;
773: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION_WARN');
774: END IF;
775: --
776: IF p_action_prms.caller = 'WSH_FSTRX' THEN
777: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
778: ELSE
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781: --
791: AND nvl(p_action_prms.phase,1) = 1
792: AND p_action_prms.caller = 'WSH_FSTRX'
793: THEN
794:
795: x_return_status := wsh_util_core.g_ret_sts_success;
796: --
797: -- Start code for Bugfix 4070732
798: --
799: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
795: x_return_status := wsh_util_core.g_ret_sts_success;
796: --
797: -- Start code for Bugfix 4070732
798: --
799: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
800: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
803: END IF;
796: --
797: -- Start code for Bugfix 4070732
798: --
799: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
800: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
803: END IF;
804:
798: --
799: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
800: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
803: END IF;
804:
805:
806: WSH_UTIL_CORE.reset_stops_for_load_tender(
802: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
803: END IF;
804:
805:
806: WSH_UTIL_CORE.reset_stops_for_load_tender(
807: p_reset_flags => TRUE,
808: x_return_status => l_return_status);
809: IF l_debug_on THEN
810: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
826: END IF;
827:
828: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 )
829: AND ( p_action_prms.action_code IN ( 'FIRM', 'PLAN' , 'UNPLAN'))
830: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y')
831: THEN
832: FOR i IN l_trip_id_tab.FIRST..l_trip_id_tab.last LOOP
833: BEGIN
834:
838: p_trip_id => l_trip_id_tab(i),
839: x_trip_rec => l_trip_rec,
840: x_return_status => l_return_status
841: );
842: wsh_util_core.api_post_call(p_return_status =>l_return_status,
843: x_num_warnings =>l_num_warning,
844: x_num_errors =>l_num_errors);
845:
846:
849: p_trip_rec => l_trip_rec,
850: p_action => 'UPDATE',
851: x_return_status => l_return_status
852: );
853: wsh_util_core.api_post_call(p_return_status =>l_return_status,
854: x_num_warnings =>l_num_warning,
855: x_num_errors =>l_num_errors);
856: EXCEPTION
857: WHEN FND_API.G_EXC_ERROR THEN
895: p_action => p_action_prms.action_code,
896: x_return_status => l_return_status
897: );
898:
899: wsh_util_core.api_post_call(p_return_status =>l_return_status,
900: x_num_warnings =>l_num_warning,
901: x_num_errors =>l_num_errors);
902:
903: /* J TP Release */
911: IF l_debug_on THEN
912: wsh_debug_sv.log(l_module_name,'Return Status After Calling change_ignoreplan_status ',l_return_status);
913: END IF;
914: --
915: wsh_util_core.api_post_call(
916: p_return_status => l_return_status,
917: x_num_warnings => l_num_warning,
918: x_num_errors => l_num_errors);
919: --
927: p_detail_ids => l_dummy_ids,
928: x_request_ids => x_trip_out_rec.result_id_tab,
929: x_return_status => l_return_status
930: );
931: wsh_util_core.api_post_call(p_return_status =>l_return_status,
932: x_num_warnings =>l_num_warning,
933: x_num_errors =>l_num_errors);
934:
935:
955: p_defer_interface_flag => p_action_prms.defer_interface_flag,
956: p_mbol_flag => p_action_prms.mbol_flag, -- Added for MBOL
957: x_return_status => l_return_status);
958:
959: wsh_util_core.api_post_call(p_return_status =>l_return_status,
960: x_num_warnings =>l_num_warning,
961: x_num_errors =>l_num_errors);
962:
963: ELSIF p_action_prms.action_code = 'PRINT-DOC-SETS' THEN
964: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DOCUMENT_SETS_LVL)=1 THEN
965:
966: IF l_report_set_id IS NULL THEN
967: FND_MESSAGE.SET_NAME('WSH','WSH_DOC_MISSING');
968: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
969: IF l_debug_on THEN
970: wsh_debug_sv.log (l_module_name,'WSH_DOC_MISSING');
971: END IF;
972: RAISE FND_API.G_EXC_ERROR;
974: WSH_UTIL_VALIDATE.validate_report_set(
975: p_report_set_id => l_report_set_id,
976: p_report_set_name => NULL,
977: x_return_status => l_return_status);
978: wsh_util_core.api_post_call(p_return_status =>l_return_status,
979: x_num_warnings =>l_num_warning,
980: x_num_errors =>l_num_errors);
981: END IF;
982:
988: p_delivery_ids => l_dummy_ids,
989: p_document_param_info => l_dummy_doc_param,
990: x_return_status => l_return_status
991: );
992: wsh_util_core.api_post_call(p_return_status =>l_return_status,
993: x_num_warnings =>l_num_warning,
994: x_num_errors =>l_num_errors);
995:
996: ELSIF p_action_prms.action_code = 'WT-VOL' THEN
999: -- This change was introduced to mark the G_RESET_WV flag
1000: -- before calling trip_weight_volume so the procedure will know
1001: -- to invoke update tms_interface_flag process.
1002:
1003: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1004: IF l_gc3_is_installed IS NULL THEN
1005: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
1006: END IF;
1007:
1001: -- to invoke update tms_interface_flag process.
1002:
1003: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1004: IF l_gc3_is_installed IS NULL THEN
1005: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
1006: END IF;
1007:
1008: IF l_gc3_is_installed = 'Y' THEN
1009: WSH_WV_UTILS.G_RESET_WV := 'Y'; -- set to Y to enable the update
1017: x_return_status => l_return_status,
1018: --tkt
1019: p_caller => p_action_prms.caller
1020: );
1021: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1022: x_num_warnings =>l_num_warning,
1023: x_num_errors =>l_num_errors);
1024:
1025: -- OTM R12 : packing ECO
1028: END IF;
1029: -- End of OTM R12 : packing ECO
1030:
1031: ELSIF p_action_prms.action_code = 'DELETE' THEN
1032: WSH_UTIL_CORE.delete(
1033: p_type => 'TRIP',
1034: p_rows => l_trip_id_tab,
1035: x_return_status => l_return_status
1036: );
1033: p_type => 'TRIP',
1034: p_rows => l_trip_id_tab,
1035: x_return_status => l_return_status
1036: );
1037: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1038: x_num_warnings =>l_num_warning,
1039: x_num_errors =>l_num_errors);
1040:
1041: ELSIF p_action_prms.action_code IN ('PICK-RELEASE-UI' ,'RESOLVE-EXCEPTIONS-UI','FREIGHT-COSTS-UI') THEN
1050: ELSIF p_rec_attr_tab.COUNT = 1
1051: AND p_action_prms.caller <> 'WSH_FSTRX' THEN
1052: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
1053: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
1054: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1055: IF l_debug_on THEN
1056: wsh_debug_sv.log (l_module_name,'WSH_INVALID_ACTION_CODE COUNT');
1057: END IF;
1058: RAISE FND_API.G_EXC_ERROR;
1076: THEN
1077: --{
1078: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1079: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
1080: x_return_status := wsh_util_core.g_ret_sts_error;
1081: wsh_util_core.add_message(x_return_status,l_module_name);
1082: RAISE FND_API.G_EXC_ERROR;
1083: --}
1084: ELSE
1077: --{
1078: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1079: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
1080: x_return_status := wsh_util_core.g_ret_sts_error;
1081: wsh_util_core.add_message(x_return_status,l_module_name);
1082: RAISE FND_API.G_EXC_ERROR;
1083: --}
1084: ELSE
1085: l_action_prms.caller := 'WSH_GRP';
1101: IF l_debug_on THEN
1102: wsh_debug_sv.log(l_module_name,'Return Status After Calling delivery_action',l_return_status);
1103: END IF;
1104:
1105: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1106: x_num_warnings =>l_num_warning,
1107: x_num_errors =>l_num_errors);
1108: END IF;
1109: -- Modified by 4493263
1125: THEN
1126: --{
1127: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1128: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
1129: x_return_status := wsh_util_core.g_ret_sts_error;
1130: wsh_util_core.add_message(x_return_status,l_module_name);
1131: RAISE FND_API.G_EXC_ERROR;
1132: --}
1133: ELSE
1126: --{
1127: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NO_PICKUP_ERROR');
1128: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
1129: x_return_status := wsh_util_core.g_ret_sts_error;
1130: wsh_util_core.add_message(x_return_status,l_module_name);
1131: RAISE FND_API.G_EXC_ERROR;
1132: --}
1133: ELSE
1134: l_action_prms.caller := 'WSH_GRP';
1151: wsh_debug_sv.log(l_module_name,'Return Status After Calling delivery_action',l_return_status);
1152: END IF;
1153:
1154:
1155: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1156: x_num_warnings =>l_num_warning,
1157: x_num_errors =>l_num_errors);
1158: END IF;
1159:
1179: x_sequence_number => l_document_number,
1180: x_return_status => l_return_status );
1181:
1182: -- 4493263
1183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1184: l_mbol_error_count := l_mbol_error_count + 1;
1185: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1186: -- Need to add another trip id tab which will have the trip ids for which generate mbol
1187: -- was successful.And then use this for print Document sets.
1181:
1182: -- 4493263
1183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1184: l_mbol_error_count := l_mbol_error_count + 1;
1185: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1186: -- Need to add another trip id tab which will have the trip ids for which generate mbol
1187: -- was successful.And then use this for print Document sets.
1188: l_pmbol_trip_id_tab(l_pmbol_trip_id_tab.COUNT +1) := l_trip_id_tab(i);
1189: END IF;
1207: p_document_param_info => l_dummy_doc_set_params,
1208: x_return_status => l_return_status);
1209: END IF;
1210:
1211: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1212: l_mbol_error_count := l_mbol_error_count + 1;
1213: END IF;
1214:
1215: WSH_UTIL_CORE.api_post_call(
1211: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1212: l_mbol_error_count := l_mbol_error_count + 1;
1213: END IF;
1214:
1215: WSH_UTIL_CORE.api_post_call(
1216: p_return_status => l_return_status,
1217: x_num_warnings => l_num_warning,
1218: x_num_errors => l_num_errors,
1219: p_raise_error_flag => FALSE );
1219: p_raise_error_flag => FALSE );
1220:
1221: IF l_mbol_error_count > 0 THEN
1222: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_MBOL_ERROR');
1223: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1224: ELSIF l_mbol_error_count = 0 THEN
1225: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_MBOL_SUCCESS');
1226: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1227: END IF;
1222: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_MBOL_ERROR');
1223: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1224: ELSIF l_mbol_error_count = 0 THEN
1225: FND_MESSAGE.SET_NAME('WSH', 'WSH_PRINT_MBOL_SUCCESS');
1226: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1227: END IF;
1228:
1229: /*
1230: -- Hiding project
1230: -- Hiding project
1231: -- R12 Select Carrier
1232:
1233: ELSIF p_action_prms.action_code = 'SELECT-CARRIER' THEN
1234: IF wsh_util_core.fte_is_installed = 'Y' THEN
1235: IF p_rec_attr_tab.COUNT > 1 AND p_action_prms.caller = 'WSH_FSTRX' THEN
1236: FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');
1237: x_return_status := wsh_util_core.g_ret_sts_error;
1238: wsh_util_core.add_message(x_return_status,l_module_name);
1233: ELSIF p_action_prms.action_code = 'SELECT-CARRIER' THEN
1234: IF wsh_util_core.fte_is_installed = 'Y' THEN
1235: IF p_rec_attr_tab.COUNT > 1 AND p_action_prms.caller = 'WSH_FSTRX' THEN
1236: FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');
1237: x_return_status := wsh_util_core.g_ret_sts_error;
1238: wsh_util_core.add_message(x_return_status,l_module_name);
1239: --FND_MSG_PUB.ADD;
1240: IF l_debug_on THEN
1241: wsh_debug_sv.log (l_module_name,'WSH_UI_MULTI_SELECTION');
1234: IF wsh_util_core.fte_is_installed = 'Y' THEN
1235: IF p_rec_attr_tab.COUNT > 1 AND p_action_prms.caller = 'WSH_FSTRX' THEN
1236: FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');
1237: x_return_status := wsh_util_core.g_ret_sts_error;
1238: wsh_util_core.add_message(x_return_status,l_module_name);
1239: --FND_MSG_PUB.ADD;
1240: IF l_debug_on THEN
1241: wsh_debug_sv.log (l_module_name,'WSH_UI_MULTI_SELECTION');
1242: END IF;
1250: x_msg_count => l_msg_count,
1251: x_msg_data => l_msg_data,
1252: x_return_status => l_return_status );
1253:
1254: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1255: x_num_warnings =>l_num_warning,
1256: x_num_errors =>l_num_errors);
1257:
1258: ELSE
1256: x_num_errors =>l_num_errors);
1257:
1258: ELSE
1259: FND_MESSAGE.SET_NAME('WSH', 'FTE_NOT_INSTALLED');
1260: x_return_status := wsh_util_core.g_ret_sts_error;
1261: wsh_util_core.add_message(x_return_status,l_module_name);
1262: IF l_debug_on THEN
1263: wsh_debug_sv.logmsg(l_module_name,'FTE_NOT_INSTALLED');
1264: END IF;
1257:
1258: ELSE
1259: FND_MESSAGE.SET_NAME('WSH', 'FTE_NOT_INSTALLED');
1260: x_return_status := wsh_util_core.g_ret_sts_error;
1261: wsh_util_core.add_message(x_return_status,l_module_name);
1262: IF l_debug_on THEN
1263: wsh_debug_sv.logmsg(l_module_name,'FTE_NOT_INSTALLED');
1264: END IF;
1265: RAISE FND_API.G_EXC_ERROR;
1287:
1288: IF l_debug_on THEN
1289: wsh_debug_sv.log(l_module_name,'Return Status After Calling Remove_Consolidation',l_return_status);
1290: END IF;
1291: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1292: x_num_warnings =>l_num_warning,
1293: x_num_errors =>l_num_errors);
1294:
1295:
1296: ELSE
1297: -- give message for invalid action
1298: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
1299: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
1300: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1301: IF l_debug_on THEN
1302: wsh_debug_sv.log (l_module_name,'WSH_INVALID_ACTION_CODE');
1303: END IF;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306:
1307: -- TP call back to unfirm continuous move or delete continuous move or
1308: -- any other action that will be done in the future based on the action performed
1309: IF WSH_UTIL_CORE.TP_IS_INSTALLED='Y' THEN
1310: WSH_FTE_TP_INTEGRATION.trip_callback (
1311: p_api_version_number => 1.0,
1312: p_init_msg_list => FND_API.G_TRUE,
1313: x_return_status => l_return_status,
1319: IF l_debug_on THEN
1320: WSH_DEBUG_SV.log(l_module_name,'after calling trip_callback l_return_status',l_return_status);
1321: END IF;
1322:
1323: wsh_util_core.api_post_call(
1324: p_return_status => l_return_status,
1325: x_num_warnings => l_num_warning,
1326: x_num_errors => l_num_errors
1327: );
1334: EXCEPTION
1335: -- J-IB-NPARIKH-{
1336: WHEN e_end_of_api THEN
1337: IF l_num_warning > 0 THEN
1338: --RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1339: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1340: ELSE
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1342: END IF;
1335: -- J-IB-NPARIKH-{
1336: WHEN e_end_of_api THEN
1337: IF l_num_warning > 0 THEN
1338: --RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1339: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1340: ELSE
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1342: END IF;
1343:
1337: IF l_num_warning > 0 THEN
1338: --RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1339: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1340: ELSE
1341: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1342: END IF;
1343:
1344: --
1345: -- K LPN CONV. rv
1363: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1364: END IF;
1365: --
1366: --
1367: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1368: x_return_status := l_return_status;
1369: END IF;
1370:
1371: --}
1377: IF p_commit = FND_API.G_TRUE THEN
1378: --
1379: -- Start code for Bugfix 4070732 for commit
1380: --
1381: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1382: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1383:
1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1378: --
1379: -- Start code for Bugfix 4070732 for commit
1380: --
1381: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1382: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1383:
1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1386: END IF;
1381: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1382: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1383:
1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1386: END IF;
1387:
1388: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
1389: x_return_status => l_return_status);
1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1386: END IF;
1387:
1388: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
1389: x_return_status => l_return_status);
1390:
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1393: END IF;
1394: -- The x_return_status at this point is either success or warning
1395: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1396: x_return_status := l_return_status;
1397: END IF;
1398:
1399: END IF;
1397: END IF;
1398:
1399: END IF;
1400:
1401: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1402: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1403: COMMIT;
1404: ELSE
1405: ROLLBACK TO s_trip_action_grp;
1398:
1399: END IF;
1400:
1401: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1402: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1403: COMMIT;
1404: ELSE
1405: ROLLBACK TO s_trip_action_grp;
1406: END IF;
1410: END IF;
1411:
1412: --
1413: --Bugfix 4070732 { logical end of the API
1414: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1415: THEN --{
1416: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1417:
1418: IF p_commit = FND_API.G_TRUE THEN
1412: --
1413: --Bugfix 4070732 { logical end of the API
1414: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1415: THEN --{
1416: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1417:
1418: IF p_commit = FND_API.G_TRUE THEN
1419:
1420: IF l_debug_on THEN
1417:
1418: IF p_commit = FND_API.G_TRUE THEN
1419:
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1422: END IF;
1423: WSH_UTIL_CORE.reset_stops_for_load_tender(
1424: p_reset_flags => TRUE,
1425: x_return_status => l_return_status);
1419:
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1422: END IF;
1423: WSH_UTIL_CORE.reset_stops_for_load_tender(
1424: p_reset_flags => TRUE,
1425: x_return_status => l_return_status);
1426: ELSE
1427:
1425: x_return_status => l_return_status);
1426: ELSE
1427:
1428: IF l_debug_on THEN
1429: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1430: END IF;
1431: WSH_UTIL_CORE.Process_stops_for_load_tender(
1432: p_reset_flags => TRUE,
1433: x_return_status => l_return_status);
1427:
1428: IF l_debug_on THEN
1429: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1430: END IF;
1431: WSH_UTIL_CORE.Process_stops_for_load_tender(
1432: p_reset_flags => TRUE,
1433: x_return_status => l_return_status);
1434: END IF;
1435:
1437: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1438: END IF;
1439:
1440: --
1441: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1442: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1443: THEN --{
1444: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1445: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1438: END IF;
1439:
1440: --
1441: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1442: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1443: THEN --{
1444: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1445: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1446: THEN
1440: --
1441: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1442: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1443: THEN --{
1444: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1445: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1446: THEN
1447: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1441: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1442: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1443: THEN --{
1444: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1445: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1446: THEN
1447: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1449: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1443: THEN --{
1444: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1445: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1446: THEN
1447: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1449: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1450: THEN
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1444: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1445: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1446: THEN
1447: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1449: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1450: THEN
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1452: END IF;
1445: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1446: THEN
1447: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1449: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1450: THEN
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1452: END IF;
1453: END IF; --}
1447: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1448: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1449: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1450: THEN
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1452: END IF;
1453: END IF; --}
1454:
1455: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1452: END IF;
1453: END IF; --}
1454:
1455: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1456: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1457: THEN
1458: IF p_commit = FND_API.G_TRUE THEN
1459: null;
1452: END IF;
1453: END IF; --}
1454:
1455: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1456: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1457: THEN
1458: IF p_commit = FND_API.G_TRUE THEN
1459: null;
1460: ELSE
1481: -- J-IB-NPARIKH-}
1482:
1483: WHEN e_req_field THEN
1484: ROLLBACK TO s_trip_action_grp;
1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1486: wsh_util_core.add_message(x_return_status,l_module_name);
1487:
1488: --
1489: -- Start code for Bugfix 4070732
1482:
1483: WHEN e_req_field THEN
1484: ROLLBACK TO s_trip_action_grp;
1485: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1486: wsh_util_core.add_message(x_return_status,l_module_name);
1487:
1488: --
1489: -- Start code for Bugfix 4070732
1490: --
1487:
1488: --
1489: -- Start code for Bugfix 4070732
1490: --
1491: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1492: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1493: IF l_debug_on THEN
1494: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1495: END IF;
1488: --
1489: -- Start code for Bugfix 4070732
1490: --
1491: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1492: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1493: IF l_debug_on THEN
1494: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1495: END IF;
1496:
1490: --
1491: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1492: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1493: IF l_debug_on THEN
1494: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1495: END IF;
1496:
1497: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1498: x_return_status => l_return_status);
1493: IF l_debug_on THEN
1494: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1495: END IF;
1496:
1497: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1498: x_return_status => l_return_status);
1499:
1500:
1501: IF l_debug_on THEN
1501: IF l_debug_on THEN
1502: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1503: END IF;
1504: IF l_return_status =
1505: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1506: x_return_status := l_return_status;
1507: END IF;
1508: END IF;
1509: END IF;
1523:
1524:
1525: WHEN FND_API.G_EXC_ERROR THEN
1526: ROLLBACK TO s_trip_action_grp;
1527: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1528:
1529: --
1530: -- Start code for Bugfix 4070732
1531: --
1528:
1529: --
1530: -- Start code for Bugfix 4070732
1531: --
1532: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1533: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1534: IF l_debug_on THEN
1535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1536: END IF;
1529: --
1530: -- Start code for Bugfix 4070732
1531: --
1532: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1533: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1534: IF l_debug_on THEN
1535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1536: END IF;
1537:
1531: --
1532: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1533: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1534: IF l_debug_on THEN
1535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1536: END IF;
1537:
1538: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1539: x_return_status => l_return_status);
1534: IF l_debug_on THEN
1535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1536: END IF;
1537:
1538: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1539: x_return_status => l_return_status);
1540:
1541:
1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1544: END IF;
1545:
1546: IF l_return_status =
1547: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1548: x_return_status := l_return_status;
1549: END IF;
1550: END IF;
1551: END IF;
1564: WSH_DEBUG_SV.pop(l_module_name);
1565: END IF;
1566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1567: ROLLBACK TO s_trip_action_grp;
1568: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1569:
1570: --
1571: -- Start code for Bugfix 4070732
1572: --
1569:
1570: --
1571: -- Start code for Bugfix 4070732
1572: --
1573: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1574: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1575: IF l_debug_on THEN
1576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1577: END IF;
1570: --
1571: -- Start code for Bugfix 4070732
1572: --
1573: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1574: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1575: IF l_debug_on THEN
1576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1577: END IF;
1578:
1572: --
1573: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1574: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1575: IF l_debug_on THEN
1576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1577: END IF;
1578:
1579: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1580: x_return_status => l_return_status);
1575: IF l_debug_on THEN
1576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1577: END IF;
1578:
1579: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1580: x_return_status => l_return_status);
1581:
1582:
1583: IF l_debug_on THEN
1599: IF l_debug_on THEN
1600: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1601: WSH_DEBUG_SV.pop(l_module_name);
1602: END IF;
1603: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1604: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1605: --
1606: -- K LPN CONV. rv
1607: --
1600: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1601: WSH_DEBUG_SV.pop(l_module_name);
1602: END IF;
1603: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1604: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1605: --
1606: -- K LPN CONV. rv
1607: --
1608: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1624: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1625: END IF;
1626: --
1627: --
1628: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1629: x_return_status := l_return_status;
1630: END IF;
1631: --
1632: --}
1637:
1638: --
1639: -- Start code for Bugfix 4070732
1640: --
1641: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1642: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1645: END IF;
1638: --
1639: -- Start code for Bugfix 4070732
1640: --
1641: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1642: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1645: END IF;
1646:
1640: --
1641: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1642: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1645: END IF;
1646:
1647: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1648: x_return_status => l_return_status);
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1645: END IF;
1646:
1647: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1648: x_return_status => l_return_status);
1649:
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1649:
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1652: END IF;
1653: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1654: THEN
1655: x_return_status := l_return_status;
1656: END IF;
1657: END IF;
1656: END IF;
1657: END IF;
1658: END IF;
1659:
1660: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1661: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1662: THEN
1663: ROLLBACK TO s_trip_action_grp;
1664: END IF;
1657: END IF;
1658: END IF;
1659:
1660: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1661: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1662: THEN
1663: ROLLBACK TO s_trip_action_grp;
1664: END IF;
1665: --
1676: WSH_DEBUG_SV.pop(l_module_name);
1677: END IF;
1678: WHEN OTHERS THEN
1679: ROLLBACK TO s_trip_action_grp;
1680: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1681: l_module_name);
1682:
1683:
1684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1680: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1681: l_module_name);
1682:
1683:
1684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1685:
1686: --
1687: -- Start code for Bugfix 4070732
1688: --
1685:
1686: --
1687: -- Start code for Bugfix 4070732
1688: --
1689: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1690: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1691: IF l_debug_on THEN
1692: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1693: END IF;
1686: --
1687: -- Start code for Bugfix 4070732
1688: --
1689: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1690: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1691: IF l_debug_on THEN
1692: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1693: END IF;
1694:
1688: --
1689: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1690: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1691: IF l_debug_on THEN
1692: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1693: END IF;
1694:
1695: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1696: x_return_status => l_return_status);
1691: IF l_debug_on THEN
1692: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1693: END IF;
1694:
1695: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1696: x_return_status => l_return_status);
1697:
1698:
1699: IF l_debug_on THEN
1743: WSH_DEBUG_SV.log(l_module_name,'p_grp_trip_rec.TRIP_ID',p_grp_trip_rec.TRIP_ID);
1744: WSH_DEBUG_SV.log(l_module_name,'p_grp_trip_rec.NAME',p_grp_trip_rec.NAME);
1745: END IF;
1746: --
1747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1748:
1749: x_pvt_trip_rec.TRIP_ID := p_grp_trip_rec.TRIP_ID;
1750: x_pvt_trip_rec.NAME := p_grp_trip_rec.NAME;
1751: x_pvt_trip_rec.PLANNED_FLAG := p_grp_trip_rec.PLANNED_FLAG;
1805: END IF;
1806: --
1807: EXCEPTION
1808: WHEN OTHERS THEN
1809: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_tripgrp_to_pvt',l_module_name);
1810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1811: --
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1806: --
1807: EXCEPTION
1808: WHEN OTHERS THEN
1809: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_tripgrp_to_pvt',l_module_name);
1810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1811: --
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1818:
1819: PROCEDURE Validate_Trip
1820: (p_trip_info_tab IN OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
1821: p_action_code IN VARCHAR2,
1822: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,
1823: x_return_status OUT NOCOPY VARCHAR2,
1824: p_caller IN VARCHAR2 DEFAULT NULL) IS
1825:
1826: l_debug_on BOOLEAN;
1867: END IF;
1868: --
1869:
1870: --OTM R12, glog proj
1871: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1872: --OTM R12, glog proj, use Global Variable
1873: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1874:
1875: -- If null, call the function
1869:
1870: --OTM R12, glog proj
1871: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1872: --OTM R12, glog proj, use Global Variable
1873: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1874:
1875: -- If null, call the function
1876: IF l_gc3_is_installed IS NULL THEN
1877: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
1873: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
1874:
1875: -- If null, call the function
1876: IF l_gc3_is_installed IS NULL THEN
1877: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
1878: END IF;
1879: -- end of OTM R12, glog proj
1880:
1881: SAVEPOINT validate_trip_grp;
1960: x_return_status => l_return_status);
1961: IF l_debug_on THEN
1962: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_Name l_return_status',l_return_status);
1963: END IF;
1964: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1965: x_num_warnings =>l_num_warnings,
1966: x_num_errors =>l_num_errors);
1967: END IF;
1968:
1975: IF l_debug_on THEN
1976: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_VALIDATIONS.Validate_Arrive_after_trip l_return_status',
1977: l_return_status);
1978: END IF;
1979: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1980: x_num_warnings =>l_num_warnings,
1981: x_num_errors =>l_num_errors);
1982: END IF;
1983:
2006: -- Warning is converted to error when caller is FTE_TMS_INTEGRATION
2007: -- For Inbound messages, there is no way to warn user.
2008: IF (l_gc3_is_installed = 'Y' AND
2009: p_caller = 'FTE_TMS_INTEGRATION' AND
2010: l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2011: IF l_debug_on THEN
2012: WSH_DEBUG_SV.log(l_module_name,'Convert l_return_status',l_return_status);
2013: END IF;
2014: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2010: l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2011: IF l_debug_on THEN
2012: WSH_DEBUG_SV.log(l_module_name,'Convert l_return_status',l_return_status);
2013: END IF;
2014: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2015: END IF;
2016: -- OTM R12, end of glog project
2017:
2018: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2014: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2015: END IF;
2016: -- OTM R12, end of glog project
2017:
2018: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2019: x_num_warnings =>l_num_warnings,
2020: x_num_errors =>l_num_errors);
2021:
2022:
2030:
2031: IF l_debug_on THEN
2032: WSH_DEBUG_SV.log(l_module_name,'WSH_BOLS_PVT.cancel_bol l_return_status',l_return_status);
2033: END IF;
2034: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2035: x_num_warnings =>l_num_warnings,
2036: x_num_errors =>l_num_errors);
2037: WSH_MBOLS_PVT.cancel_mbol
2038: ( p_trip_id => p_trip_info_tab(l_index).trip_id
2040:
2041: IF l_debug_on THEN
2042: WSH_DEBUG_SV.log(l_module_name,'WSH_MBOLS_PVT.cancel_mbol l_return_status',l_return_status);
2043: END IF;
2044: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2045: x_num_warnings =>l_num_warnings,
2046: x_num_errors =>l_num_errors);
2047: END IF;
2048: END IF;
2057: IF l_debug_on THEN
2058: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_freight_terms',l_return_status);
2059: END IF;
2060: --
2061: WSH_UTIL_CORE.api_post_call(
2062: p_return_status => l_return_status,
2063: x_num_warnings => l_num_warnings,
2064: x_num_errors => l_num_errors);
2065: --
2077: --removed get_vehicle_item_id cursor as this was not being used
2078:
2079: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2080: FND_MESSAGE.SET_TOKEN('FIELD_NAME','vehicle_organization_id');
2081: wsh_util_core.add_message(l_return_status,l_module_name);
2082: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2083: ELSE
2084: WSH_UTIL_VALIDATE.validate_item(
2085: p_inventory_item_id => p_trip_info_tab(l_index).vehicle_item_id,
2078:
2079: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2080: FND_MESSAGE.SET_TOKEN('FIELD_NAME','vehicle_organization_id');
2081: wsh_util_core.add_message(l_return_status,l_module_name);
2082: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2083: ELSE
2084: WSH_UTIL_VALIDATE.validate_item(
2085: p_inventory_item_id => p_trip_info_tab(l_index).vehicle_item_id,
2086: p_inventory_item => p_trip_info_tab(l_index).vehicle_item_desc,
2088: p_seg_array => l_seg_array,
2089: p_item_type => 'VEH_ITEM' ,
2090: x_return_status => l_return_status);
2091: --Bug# 3565374 - Start
2092: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2093: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_VEHICLE');
2094: wsh_util_core.add_message(l_return_status,l_module_name);
2095: END IF;
2096: --Bug# 3565374 - End
2090: x_return_status => l_return_status);
2091: --Bug# 3565374 - Start
2092: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2093: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_VEHICLE');
2094: wsh_util_core.add_message(l_return_status,l_module_name);
2095: END IF;
2096: --Bug# 3565374 - End
2097:
2098: END IF;
2099:
2100: IF l_debug_on THEN
2101: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_item -vehicle l_return_status',l_return_status);
2102: END IF;
2103: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2104: x_num_warnings =>l_num_warnings,
2105: x_num_errors =>l_num_errors);
2106:
2107: END IF;
2123: x_return_status => l_return_status);
2124: IF l_debug_on THEN
2125: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_org l_return_status',l_return_status);
2126: END IF;
2127: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2128: x_num_warnings =>l_num_warnings,
2129: x_num_errors =>l_num_errors);
2130:
2131:
2129: x_num_errors =>l_num_errors);
2130:
2131:
2132: -- Pack J, if FTE is installed, make sure this is a master organization.
2133: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y') AND (p_trip_info_tab(l_index).vehicle_organization_id IS NOT NULL) THEN
2134: WSH_UTIL_CORE.get_master_from_org(
2135: p_org_id => p_trip_info_tab(l_index).vehicle_organization_id,
2136: x_master_org_id => l_dummy_master_org_id,
2137: x_return_status => l_return_status);
2130:
2131:
2132: -- Pack J, if FTE is installed, make sure this is a master organization.
2133: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y') AND (p_trip_info_tab(l_index).vehicle_organization_id IS NOT NULL) THEN
2134: WSH_UTIL_CORE.get_master_from_org(
2135: p_org_id => p_trip_info_tab(l_index).vehicle_organization_id,
2136: x_master_org_id => l_dummy_master_org_id,
2137: x_return_status => l_return_status);
2138:
2135: p_org_id => p_trip_info_tab(l_index).vehicle_organization_id,
2136: x_master_org_id => l_dummy_master_org_id,
2137: x_return_status => l_return_status);
2138:
2139: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2140: x_num_warnings =>l_num_warnings,
2141: x_num_errors =>l_num_errors);
2142:
2143:
2151: x_vehicle_org_id => l_vehicle_org_id,
2152: x_return_status => l_return_status);
2153:
2154: --Bug# 3565374 - Start
2155: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2156: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2157: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2158: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2159: END IF;
2152: x_return_status => l_return_status);
2153:
2154: --Bug# 3565374 - Start
2155: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2156: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2157: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2158: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2159: END IF;
2160: l_vehicle_name := WSH_UTIL_CORE.get_item_name (p_item_id => p_trip_info_tab(l_index).VEHICLE_ITEM_ID,
2153:
2154: --Bug# 3565374 - Start
2155: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2156: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2157: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2158: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2159: END IF;
2160: l_vehicle_name := WSH_UTIL_CORE.get_item_name (p_item_id => p_trip_info_tab(l_index).VEHICLE_ITEM_ID,
2161: p_organization_id => p_trip_info_tab(l_index).VEHICLE_ORGANIZATION_ID);
2156: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2157: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2158: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2159: END IF;
2160: l_vehicle_name := WSH_UTIL_CORE.get_item_name (p_item_id => p_trip_info_tab(l_index).VEHICLE_ITEM_ID,
2161: p_organization_id => p_trip_info_tab(l_index).VEHICLE_ORGANIZATION_ID);
2162: l_vehicle_org_name := WSH_UTIL_CORE.get_org_name (p_organization_id => p_trip_info_tab(l_index).VEHICLE_ORGANIZATION_ID);
2163: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
2164: FND_MESSAGE.SET_TOKEN('ITEM',l_vehicle_name);
2158: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2159: END IF;
2160: l_vehicle_name := WSH_UTIL_CORE.get_item_name (p_item_id => p_trip_info_tab(l_index).VEHICLE_ITEM_ID,
2161: p_organization_id => p_trip_info_tab(l_index).VEHICLE_ORGANIZATION_ID);
2162: l_vehicle_org_name := WSH_UTIL_CORE.get_org_name (p_organization_id => p_trip_info_tab(l_index).VEHICLE_ORGANIZATION_ID);
2163: FND_MESSAGE.SET_NAME('WSH','WSH_VEHICLE_TYPE_UNDEFINED');
2164: FND_MESSAGE.SET_TOKEN('ITEM',l_vehicle_name);
2165: FND_MESSAGE.SET_TOKEN('ORGANIZATION',l_vehicle_org_name);
2166: FND_MSG_PUB.ADD;
2166: FND_MSG_PUB.ADD;
2167: END IF;
2168: END IF;
2169: --Bug# 3565374 - End
2170: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2171: x_num_warnings =>l_num_warnings,
2172: x_num_errors =>l_num_errors);
2173:
2174: ELSE
2199: x_return_status => l_return_status);
2200: IF l_debug_on THEN
2201: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_ship_method l_return_status',l_return_status);
2202: END IF;
2203: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2204: x_num_warnings =>l_num_warnings,
2205: x_num_errors =>l_num_errors);
2206: END IF;
2207:
2212: x_return_status => l_return_status);
2213: IF l_debug_on THEN
2214: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_VALIDATIONS.Validate_Consol_Allowed l_return_status',l_return_status);
2215: END IF;
2216: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2217: x_num_warnings =>l_num_warnings,
2218: x_num_errors =>l_num_errors);
2219: END IF;
2220:
2217: x_num_warnings =>l_num_warnings,
2218: x_num_errors =>l_num_errors);
2219: END IF;
2220:
2221: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y') THEN
2222: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 ) THEN
2223:
2224: -- 4106444 -skattama
2225: -- After Trip is modified
2230: x_return_status => l_return_status);
2231: IF l_debug_on THEN
2232: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_MultiStops l_return_status',l_return_status);
2233: END IF;
2234: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2235: x_num_warnings =>l_num_warnings,
2236: x_num_errors =>l_num_errors);
2237:
2238: -- end 4106444
2244: x_return_status => l_return_status);
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.log(l_module_name,'WSH_FTE_INTEGRATION.trip_stop_validations l_return_status',l_return_status);
2247: END IF;
2248: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2249: x_num_warnings =>l_num_warnings,
2250: x_num_errors =>l_num_errors);
2251: END IF;
2252: END IF;
2258: WHEN e_mixed_trip_error THEN
2259: ROLLBACK TO validate_trip_loop_grp;
2260: l_num_errors := l_num_errors + 1;
2261: FND_MESSAGE.SET_NAME('WSH', 'WSH_MIXED_TRIP_ERROR');
2262: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
2263: IF l_debug_on THEN
2264: WSH_DEBUG_SV.logmsg(l_module_name,'e_mixed_trip_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2265: END IF;
2266: -- J-IB-NPARIKH-}
2271: WHEN fnd_api.g_exc_unexpected_error THEN
2272: Rollback to validate_trip_loop_grp;
2273:
2274: WHEN others THEN
2275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2276: ROLLBACK TO SAVEPOINT validate_trip_loop_grp;
2277: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2278:
2279: END;
2280: l_index := p_trip_info_tab.NEXT(l_index);
2281: END LOOP;
2282:
2283: IF (l_num_errors = p_trip_info_tab.count ) THEN
2284: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2285: ELSIF (l_num_errors > 0 ) THEN
2286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2287: ELSIF (l_num_warnings > 0 ) THEN
2288: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2282:
2283: IF (l_num_errors = p_trip_info_tab.count ) THEN
2284: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2285: ELSIF (l_num_errors > 0 ) THEN
2286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2287: ELSIF (l_num_warnings > 0 ) THEN
2288: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2289: ELSE
2290: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2284: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2285: ELSIF (l_num_errors > 0 ) THEN
2286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2287: ELSIF (l_num_warnings > 0 ) THEN
2288: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2289: ELSE
2290: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2291: END IF;
2292:
2286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2287: ELSIF (l_num_warnings > 0 ) THEN
2288: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2289: ELSE
2290: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2291: END IF;
2292:
2293: IF l_debug_on THEN
2294: WSH_DEBUG_SV.pop(l_module_name);
2294: WSH_DEBUG_SV.pop(l_module_name);
2295: END IF;
2296: EXCEPTION
2297: WHEN FND_API.G_EXC_ERROR THEN
2298: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2299: FND_MSG_PUB.Count_And_Get (
2300: p_count => x_msg_count,
2301: p_data => x_msg_data,
2302: p_encoded => FND_API.G_FALSE);
2307: END IF;
2308: ROLLBACK TO SAVEPOINT validate_trip_grp;
2309:
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2311: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2312: FND_MSG_PUB.Count_And_Get (
2313: p_count => x_msg_count,
2314: p_data => x_msg_data,
2315: p_encoded => FND_API.G_FALSE);
2319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2320: END IF;
2321: ROLLBACK TO SAVEPOINT validate_trip_grp;
2322:
2323: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2324: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2325: FND_MSG_PUB.Count_And_Get (
2326: p_count => x_msg_count,
2327: p_data => x_msg_data,
2320: END IF;
2321: ROLLBACK TO SAVEPOINT validate_trip_grp;
2322:
2323: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2324: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2325: FND_MSG_PUB.Count_And_Get (
2326: p_count => x_msg_count,
2327: p_data => x_msg_data,
2328: p_encoded => FND_API.G_FALSE);
2326: p_count => x_msg_count,
2327: p_data => x_msg_data,
2328: p_encoded => FND_API.G_FALSE);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
2331: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2333: END IF;
2334: -- Bug 2741482
2328: p_encoded => FND_API.G_FALSE);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
2331: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2333: END IF;
2334: -- Bug 2741482
2335: --ROLLBACK TO SAVEPOINT validate_trip_grp;
2336:
2334: -- Bug 2741482
2335: --ROLLBACK TO SAVEPOINT validate_trip_grp;
2336:
2337: WHEN OTHERS THEN
2338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2339: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.Validate_Trip');
2340: FND_MSG_PUB.Count_And_Get (
2341: p_count => x_msg_count,
2342: p_data => x_msg_data,
2335: --ROLLBACK TO SAVEPOINT validate_trip_grp;
2336:
2337: WHEN OTHERS THEN
2338: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2339: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.Validate_Trip');
2340: FND_MSG_PUB.Count_And_Get (
2341: p_count => x_msg_count,
2342: p_data => x_msg_data,
2343: p_encoded => FND_API.G_FALSE);
2390: l_index NUMBER;
2391: l_sp_disabled_list VARCHAR2(30) := 'get_disabled_list';
2392: l_return_status VARCHAR2(1);
2393:
2394: x_valid_index_tab wsh_util_core.id_tab_type;
2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2398:
2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2417: l_cc_fail_ids wsh_util_core.id_tab_type;
2418:
2419: --Compatibility Changes
2420: CURSOR c_getorgcarriersmc (p_tripid NUMBER) IS
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2417: l_cc_fail_ids wsh_util_core.id_tab_type;
2418:
2419: --Compatibility Changes
2420: CURSOR c_getorgcarriersmc (p_tripid NUMBER) IS
2421: SELECT wnd.organization_id, wnd.name, wt.ship_method_code, wt.carrier_id
2435: l_autofirm_loadtender_trip Varchar2(10) := null;
2436:
2437: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2438: l_action VARCHAR2(20);
2439: l_trip_ids wsh_util_core.id_tab_type;
2440:
2441: BEGIN
2442: --
2443: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2473:
2474: IF (p_in_rec.caller IS NULL) THEN
2475: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2476: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.caller');
2477: wsh_util_core.add_message(x_return_status,l_module_name);
2478: raise fnd_api.g_exc_error;
2479: END IF;
2480:
2481: -- for Load Tender
2481: -- for Load Tender
2482: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE','FTE_LOAD_TENDER') ) THEN
2483: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2484: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.action_code');
2485: wsh_util_core.add_message(x_return_status,l_module_name);
2486: raise fnd_api.g_exc_error;
2487: END IF;
2488:
2489: IF (nvl(p_in_rec.phase,1) < 1) THEN
2488:
2489: IF (nvl(p_in_rec.phase,1) < 1) THEN
2490: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2491: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.phase');
2492: wsh_util_core.add_message(x_return_status,l_module_name);
2493: raise fnd_api.g_exc_error;
2494: END IF;
2495:
2496: IF (p_trip_info_tab.count = 0 ) THEN
2510: IF l_debug_on THEN
2511: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
2512: END IF;
2513:
2514: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2515: x_num_warnings =>l_num_warnings,
2516: x_num_errors =>l_num_errors);
2517:
2518: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1 ) THEN
2527: x_msg_count => x_msg_count,
2528: x_msg_data => x_msg_data,
2529: x_trip_rec => l_trip_info_tab(l_index));
2530:
2531: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2532: x_num_warnings =>l_num_warnings,
2533: x_num_errors =>l_num_errors);
2534: EXCEPTION
2535: WHEN fnd_api.g_exc_error THEN
2539: Rollback to l_sp_disabled_list;
2540:
2541: WHEN others THEN
2542: Rollback to l_sp_disabled_list;
2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2544: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2545: END;
2546: l_index := l_p_trip_info_tab.NEXT(l_index);
2547: END LOOP;
2558: END IF;
2559:
2560: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{
2561: --Compatiblity Changes
2562: IF (wsh_util_core.fte_is_installed = 'Y') THEN
2563:
2564: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(
2565: p_api_version_number => p_api_version_number,
2566: p_init_msg_list => p_init_msg_list,
2592: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_wrap',l_cc_group_info.COUNT);
2593: END IF;
2594: --
2595:
2596: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
2597: --fix p_rec_attr_tab to have only successful records
2598: l_cc_count_success:=1;
2599:
2600: IF l_debug_on THEN
2626:
2627: END IF;
2628:
2629:
2630: IF l_return_status=wsh_util_core.g_ret_sts_error and l_cc_fail_ids.COUNT<>l_trip_info_tab.COUNT THEN
2631: l_return_status:=wsh_util_core.g_ret_sts_warning;
2632: END IF;
2633:
2634: wsh_util_core.api_post_call(
2627: END IF;
2628:
2629:
2630: IF l_return_status=wsh_util_core.g_ret_sts_error and l_cc_fail_ids.COUNT<>l_trip_info_tab.COUNT THEN
2631: l_return_status:=wsh_util_core.g_ret_sts_warning;
2632: END IF;
2633:
2634: wsh_util_core.api_post_call(
2635: p_return_status => l_return_status,
2630: IF l_return_status=wsh_util_core.g_ret_sts_error and l_cc_fail_ids.COUNT<>l_trip_info_tab.COUNT THEN
2631: l_return_status:=wsh_util_core.g_ret_sts_warning;
2632: END IF;
2633:
2634: wsh_util_core.api_post_call(
2635: p_return_status => l_return_status,
2636: x_num_warnings => l_num_warnings,
2637: x_num_errors => l_num_errors,
2638: p_msg_data => l_msg_data);
2658: IF l_debug_on THEN
2659: WSH_DEBUG_SV.log(l_module_name,'Validate_trip l_return_status',l_return_status);
2660: END IF;
2661:
2662: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2663: x_num_warnings =>l_num_warnings,
2664: x_num_errors =>l_num_errors);
2665:
2666:
2675: x_trip_id => x_out_Tab(l_index).trip_id,
2676: x_name => x_out_Tab(l_index).trip_name,
2677: x_return_status => l_return_status);
2678:
2679: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2680: x_num_warnings =>l_num_warnings,
2681: x_num_errors =>l_num_errors);
2682: ELSIF (p_in_rec.action_code = 'UPDATE' ) THEN
2683:
2699: p_rowid => l_trip_info_tab(x_valid_index_tab(l_index)).rowid,
2700: p_trip_info => l_trip_info_tab(x_valid_index_tab(l_index)),
2701: x_return_status => l_return_status);
2702:
2703: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2704: x_num_warnings =>l_num_warnings,
2705: x_num_errors =>l_num_errors);
2706:
2707: --J TP Release : firm/plan/unplan trip based on parameter for load tender update
2713: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(
2714: x_Param_Info => l_param_info,
2715: x_return_status => l_return_status);
2716:
2717: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2718: x_num_warnings =>l_num_warnings,
2719: x_num_errors =>l_num_errors);
2720:
2721: l_autofirm_loadtender_trip:=l_param_info.AUTOFIRM_LOAD_TENDERED_TRIPS;
2741: wsh_trips_actions.Plan(p_trip_rows => l_trip_ids,
2742: p_action => l_action,
2743: x_return_status => l_return_status);
2744:
2745: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2746: x_num_warnings =>l_num_warnings,
2747: x_num_errors =>l_num_errors);
2748: END IF;
2749: END IF;--call is for load tender update
2756: WSH_DEBUG_SV.log(l_module_name,'smc',l_smc);
2757: WSH_DEBUG_SV.log(l_module_name,'carrier_id',l_carrier_id);
2758: END IF;
2759: IF (l_carrier_id is not null OR l_smc is not null)
2760: AND WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
2761:
2762: FOR cur in c_getorgcarriersmc (l_trip_info_tab(x_valid_index_tab(l_index)).trip_id) LOOP
2763: l_organization_id:=cur.organization_id;
2764: IF l_smc is null THEN
2779: WSH_DEBUG_SV.log(l_module_name,'carrier_id',l_carrier_id);
2780: WSH_DEBUG_SV.log(l_module_name,'smc',l_smc);
2781: END IF;
2782:
2783: WSH_UTIL_CORE.api_post_call(
2784: p_return_status => l_return_status,
2785: x_num_warnings => l_num_warnings,
2786: x_num_errors => l_num_errors);
2787:
2797: x_return_status => l_return_status);
2798: IF l_debug_on THEN
2799: wsh_debug_sv.log(l_module_name,'Return Status After Calling change_ignoreplan_sttatus',l_return_status);
2800: END IF;
2801: WSH_UTIL_CORE.api_post_call(
2802: p_return_status => l_return_status,
2803: x_num_warnings => l_num_warnings,
2804: x_num_errors => l_num_errors);
2805: END IF;
2806: END LOOP;
2807:
2808: -- TP call back to unfirm continuous move or delete continuous move or
2809: -- any other action that will be done in the future based on the action performed
2810: IF WSH_UTIL_CORE.TP_IS_INSTALLED='Y' THEN
2811: l_action_prms.action_code:=p_in_rec.action_code;
2812: l_action_prms.caller:=p_in_rec.caller;
2813: WSH_FTE_TP_INTEGRATION.trip_callback (
2814: p_api_version_number => 1.0,
2822: IF l_debug_on THEN
2823: WSH_DEBUG_SV.log(l_module_name,'after calling trip_callback l_return_status',l_return_status);
2824: END IF;
2825:
2826: wsh_util_core.api_post_call(
2827: p_return_status => l_return_status,
2828: x_num_warnings => l_num_warnings,
2829: x_num_errors => l_num_errors
2830: );
2849: l_index := x_valid_index_tab.NEXT(l_index);
2850: END LOOP;
2851:
2852: IF (l_num_errors = l_trip_info_tab.count ) THEN
2853: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2854: ELSIF (l_num_errors > 0 ) THEN
2855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2856: ELSIF (l_num_warnings > 0 ) THEN
2857: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2851:
2852: IF (l_num_errors = l_trip_info_tab.count ) THEN
2853: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2854: ELSIF (l_num_errors > 0 ) THEN
2855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2856: ELSIF (l_num_warnings > 0 ) THEN
2857: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2858: ELSE
2859: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2853: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2854: ELSIF (l_num_errors > 0 ) THEN
2855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2856: ELSIF (l_num_warnings > 0 ) THEN
2857: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2858: ELSE
2859: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2860: END IF;
2861:
2855: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2856: ELSIF (l_num_warnings > 0 ) THEN
2857: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2858: ELSE
2859: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2860: END IF;
2861:
2862: IF FND_API.To_Boolean( p_commit ) THEN
2863: COMMIT WORK;
2872: WSH_DEBUG_SV.pop(l_module_name);
2873: END IF;
2874: EXCEPTION
2875: WHEN RECORD_LOCKED THEN
2876: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2877: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
2878: wsh_util_core.add_message(x_return_status,l_module_name);
2879: FND_MSG_PUB.Count_And_Get (
2880: p_count => x_msg_count,
2874: EXCEPTION
2875: WHEN RECORD_LOCKED THEN
2876: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2877: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
2878: wsh_util_core.add_message(x_return_status,l_module_name);
2879: FND_MSG_PUB.Count_And_Get (
2880: p_count => x_msg_count,
2881: p_data => x_msg_data,
2882: p_encoded => FND_API.G_FALSE);
2886: END IF;
2887: ROLLBACK TO create_update_trip_grp;
2888:
2889: WHEN FND_API.G_EXC_ERROR THEN
2890: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2891: FND_MSG_PUB.Count_And_Get (
2892: p_count => x_msg_count,
2893: p_data => x_msg_data,
2894: p_encoded => FND_API.G_FALSE);
2898: END IF;
2899: ROLLBACK TO create_update_trip_grp;
2900:
2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2902: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2903: FND_MSG_PUB.Count_And_Get (
2904: p_count => x_msg_count,
2905: p_data => x_msg_data,
2906: p_encoded => FND_API.G_FALSE);
2909: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2910: END IF;
2911: ROLLBACK TO create_update_trip_grp;
2912:
2913: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2914: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2915: FND_MSG_PUB.Count_And_Get (
2916: p_count => x_msg_count,
2917: p_data => x_msg_data,
2910: END IF;
2911: ROLLBACK TO create_update_trip_grp;
2912:
2913: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2914: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2915: FND_MSG_PUB.Count_And_Get (
2916: p_count => x_msg_count,
2917: p_data => x_msg_data,
2918: p_encoded => FND_API.G_FALSE);
2916: p_count => x_msg_count,
2917: p_data => x_msg_data,
2918: p_encoded => FND_API.G_FALSE);
2919: IF l_debug_on THEN
2920: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2922: END IF;
2923: -- Bug 2741482
2924: --ROLLBACK TO create_update_trip_grp;
2917: p_data => x_msg_data,
2918: p_encoded => FND_API.G_FALSE);
2919: IF l_debug_on THEN
2920: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2922: END IF;
2923: -- Bug 2741482
2924: --ROLLBACK TO create_update_trip_grp;
2925:
2923: -- Bug 2741482
2924: --ROLLBACK TO create_update_trip_grp;
2925:
2926: WHEN OTHERS THEN
2927: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2928: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
2929: FND_MSG_PUB.Count_And_Get (
2930: p_count => x_msg_count,
2931: p_data => x_msg_data,
2924: --ROLLBACK TO create_update_trip_grp;
2925:
2926: WHEN OTHERS THEN
2927: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2928: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
2929: FND_MSG_PUB.Count_And_Get (
2930: p_count => x_msg_count,
2931: p_data => x_msg_data,
2932: p_encoded => FND_API.G_FALSE);
3025: x_return_status => x_return_status);
3026: IF l_debug_on THEN
3027: wsh_debug_sv.log (l_module_name, 'map_tripgrp_to_pvt x_return_status',x_return_status);
3028: END IF;
3029: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3030: raise FND_API.G_EXC_ERROR;
3031: END IF;
3032:
3033: l_trip_info_tab(1):= l_pvt_trip_rec;
3046: IF l_debug_on THEN
3047: wsh_debug_sv.log (l_module_name,'In Wrapper Create_Update_Trip x_return_status',x_return_status);
3048: END IF;
3049:
3050: wsh_util_core.api_post_call(
3051: p_return_status => x_return_status,
3052: x_num_errors => l_num_errors,
3053: x_num_warnings => l_num_warnings,
3054: p_msg_data => x_msg_data);
3057: p_trip_out_rec := l_out_tab(l_out_tab.FIRST);
3058: END IF;
3059: --
3060: IF l_num_warnings > 0 THEN
3061: x_return_status := wsh_util_core.g_ret_sts_warning;
3062: ELSE
3063: x_return_status := wsh_util_core.g_ret_sts_success;
3064: END IF;
3065:
3059: --
3060: IF l_num_warnings > 0 THEN
3061: x_return_status := wsh_util_core.g_ret_sts_warning;
3062: ELSE
3063: x_return_status := wsh_util_core.g_ret_sts_success;
3064: END IF;
3065:
3066: FND_MSG_PUB.Count_And_Get (
3067: p_count => x_msg_count,
3077: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3078: END IF;
3079:
3080: WHEN OTHERS THEN
3081: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3082: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3083: IF l_debug_on THEN
3084: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3085: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3078: END IF;
3079:
3080: WHEN OTHERS THEN
3081: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3082: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3083: IF l_debug_on THEN
3084: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3085: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3175: x_return_status => x_return_status);
3176: IF l_debug_on THEN
3177: wsh_debug_sv.log (l_module_name, 'map_tripgrp_to_pvt x_return_status',x_return_status);
3178: END IF;
3179: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3180: raise FND_API.G_EXC_ERROR;
3181: END IF;
3182:
3183: IF (p_trip_name IS NOT NULL) AND (p_trip_name <> FND_API.G_MISS_CHAR) THEN
3203:
3204: IF l_debug_on THEN
3205: wsh_debug_sv.log (l_module_name,'In Wrapper Create_Update_Trip x_return_status',x_return_status);
3206: END IF;
3207: wsh_util_core.api_post_call(
3208: p_return_status => x_return_status,
3209: x_num_errors => l_num_errors,
3210: x_num_warnings => l_num_warnings,
3211: p_msg_data => x_msg_data);
3215: x_trip_name := l_out_tab(l_out_tab.FIRST).trip_name;
3216: END IF;
3217: --
3218: IF l_num_warnings > 0 THEN
3219: x_return_status := wsh_util_core.g_ret_sts_warning;
3220: ELSE
3221: x_return_status := wsh_util_core.g_ret_sts_success;
3222: END IF;
3223:
3217: --
3218: IF l_num_warnings > 0 THEN
3219: x_return_status := wsh_util_core.g_ret_sts_warning;
3220: ELSE
3221: x_return_status := wsh_util_core.g_ret_sts_success;
3222: END IF;
3223:
3224: FND_MSG_PUB.Count_And_Get (
3225: p_count => x_msg_count,
3235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3236: END IF;
3237:
3238: WHEN OTHERS THEN
3239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3240: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3243: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3236: END IF;
3237:
3238: WHEN OTHERS THEN
3239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3240: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3243: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3390: l_stops_trip_rec.OPERATOR;
3391: CLOSE c_old_trip_details;
3392:
3393: x_trip_rec := l_stops_trip_rec;
3394: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3395: --
3396: IF l_debug_on THEN
3397: WSH_DEBUG_SV.log(l_module_name,'l_stops_trip_rec.TRIP_ID',l_stops_trip_rec.TRIP_ID);
3398: WSH_DEBUG_SV.log(l_module_name,'l_stops_trip_rec.NAME',l_stops_trip_rec.NAME);
3400: END IF;
3401: --
3402: EXCEPTION
3403: WHEN OTHERS THEN
3404: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIPS_GRP.get_trip_details_pvt',l_module_name);
3405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3406: --
3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3401: --
3402: EXCEPTION
3403: WHEN OTHERS THEN
3404: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIPS_GRP.get_trip_details_pvt',l_module_name);
3405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3406: --
3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3409: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');