57: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
58: --
59: IF l_debug_on IS NULL
60: THEN
61: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
62: END IF;
63: --
64: IF l_debug_on THEN
65: WSH_DEBUG_SV.push(l_module_name);
61: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
62: END IF;
63: --
64: IF l_debug_on THEN
65: WSH_DEBUG_SV.push(l_module_name);
66: END IF;
67: --
68:
69: x_trip_id := p_trip_info.trip_id;
119: --
120: -- Debug Statements
121: --
122: IF l_debug_on THEN
123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CUSTOM_PUB.TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
124: END IF;
125: --
126: l_name := wsh_custom_pub.trip_name(x_trip_id, p_trip_info);
127:
331: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
332:
333: --/== Workflow Changes
334: IF l_debug_on THEN
335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.START_WF_PROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
336: END IF;
337: WSH_WF_STD.start_wf_process(p_entity_type => 'TRIP',
338: p_entity_id => x_trip_id,
339: p_organization_id => NULL,
339: p_organization_id => NULL,
340: x_process_started => l_process_started,
341: x_return_status => l_return_status);
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.log(l_module_name,'L_PROCESS_STARTED',l_process_started);
344: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
345: END IF;
346: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
347: NULL;
340: x_process_started => l_process_started,
341: x_return_status => l_return_status);
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.log(l_module_name,'L_PROCESS_STARTED',l_process_started);
344: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
345: END IF;
346: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
347: NULL;
348: -- x_return_status := l_return_status;
350: END IF;
351:
352:
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
355: END IF;
356:
357: WSH_WF_STD.RAISE_EVENT(p_entity_type => 'TRIP',
358: p_entity_id => x_trip_id,
360: x_return_status => l_wf_rs
361: );
362:
363: IF l_debug_on THEN
364: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
365: END IF;
366: -- Workflow Changes ==/
367:
368:
369: --
370: -- Debug Statements
371: --
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.pop(l_module_name);
374: END IF;
375: --
376: EXCEPTION
377: WHEN wsh_duplicate_name THEN
391: --
392: -- Debug Statements
393: --
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DUPLICATE_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
396: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DUPLICATE_NAME');
397: END IF;
398: --
399: WHEN others THEN
392: -- Debug Statements
393: --
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DUPLICATE_NAME exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
396: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DUPLICATE_NAME');
397: END IF;
398: --
399: WHEN others THEN
400: -- OTM R12,glog proj, close any open cursor
412: --
413: -- Debug Statements
414: --
415: IF l_debug_on THEN
416: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
417: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
418: END IF;
419: --
420: END Create_Trip;
413: -- Debug Statements
414: --
415: IF l_debug_on THEN
416: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
417: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
418: END IF;
419: --
420: END Create_Trip;
421:
480: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
481: --
482: IF l_debug_on IS NULL
483: THEN
484: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
485: END IF;
486: --
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.push(l_module_name);
484: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
485: END IF;
486: --
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.push(l_module_name);
489: --
490: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
491: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
492: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
486: --
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.push(l_module_name);
489: --
490: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
491: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
492: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
493: END IF;
494: --
487: IF l_debug_on THEN
488: WSH_DEBUG_SV.push(l_module_name);
489: --
490: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
491: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
492: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
493: END IF;
494: --
495: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
488: WSH_DEBUG_SV.push(l_module_name);
489: --
490: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
491: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
492: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
493: END IF;
494: --
495: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
496:
519: END IF;
520: CLOSE c_get_trip_status;
521:
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.log(l_module_name,'Ignore for Planning',l_ignore);
524: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name',l_tp_plan_name);
525: WSH_DEBUG_SV.log(l_module_name,'GC3 is installed',l_gc3_is_installed);
526: END IF;
527:
520: CLOSE c_get_trip_status;
521:
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.log(l_module_name,'Ignore for Planning',l_ignore);
524: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name',l_tp_plan_name);
525: WSH_DEBUG_SV.log(l_module_name,'GC3 is installed',l_gc3_is_installed);
526: END IF;
527:
528: -- Do not allow user to delete a trip if it is include for Planning and created by OTM
521:
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.log(l_module_name,'Ignore for Planning',l_ignore);
524: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name',l_tp_plan_name);
525: WSH_DEBUG_SV.log(l_module_name,'GC3 is installed',l_gc3_is_installed);
526: END IF;
527:
528: -- Do not allow user to delete a trip if it is include for Planning and created by OTM
529: IF (l_ignore = 'N' AND l_tp_plan_name IS NOT NULL) THEN
537: --
538: -- Debug Statements
539: --
540: IF l_debug_on THEN
541: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.CHECK_TRIP_DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
542: END IF;
543: --
544: wsh_trip_validations.check_trip_delete(l_trip_id, l_return_status, p_caller);
545:
563: --
564: -- Debug Statements
565: --
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
568: END IF;
569: --
570: wsh_delivery_legs_actions.unassign_deliveries(l_del_ids, l_trip_id, NULL, NULL, l_return_status);
571:
598: -- DELETE from WSH_TRIP_STOPS.
599: -- Call DBI API after the DELETE.
600: -- This API will also check for DBI Installed or not
601: IF l_debug_on THEN
602: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count -',l_stop_tab.count);
603: END IF;
604: WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
605: (p_stop_id_tab => l_stop_tab,
606: p_dml_type => 'DELETE',
606: p_dml_type => 'DELETE',
607: x_return_status => l_dbi_rs);
608:
609: IF l_debug_on THEN
610: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
611: END IF;
612: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
613: x_return_status := l_dbi_rs;
614: rollback;
613: x_return_status := l_dbi_rs;
614: rollback;
615: -- just pass this return status to caller API
616: IF l_debug_on THEN
617: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
618: WSH_DEBUG_SV.pop(l_module_name);
619: END IF;
620: return;
621: END IF;
614: rollback;
615: -- just pass this return status to caller API
616: IF l_debug_on THEN
617: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
618: WSH_DEBUG_SV.pop(l_module_name);
619: END IF;
620: return;
621: END IF;
622: -- End of Code for DBI Project
637: --
638: -- Debug Statements
639: --
640: IF l_debug_on THEN
641: WSH_DEBUG_SV.pop(l_module_name);
642: END IF;
643: --
644: EXCEPTION
645: --OTM R12, glog proj
653: --
654: -- Debug Statements
655: --
656: IF l_debug_on THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'E_GC3_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_GC3_TRIP');
659: END IF;
660: --
661:
654: -- Debug Statements
655: --
656: IF l_debug_on THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'E_GC3_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_GC3_TRIP');
659: END IF;
660: --
661:
662: --OTM R12, glog proj
670: --
671: -- Debug Statements
672: --
673: IF l_debug_on THEN
674: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
675: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
676: END IF;
677: --
678:
671: -- Debug Statements
672: --
673: IF l_debug_on THEN
674: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
675: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
676: END IF;
677: --
678:
679:
688: --
689: -- Debug Statements
690: --
691: IF l_debug_on THEN
692: WSH_DEBUG_SV.logmsg(l_module_name,'CANNOT_DELETE_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CANNOT_DELETE_TRIP');
694: END IF;
695: --
696: WHEN others THEN
689: -- Debug Statements
690: --
691: IF l_debug_on THEN
692: WSH_DEBUG_SV.logmsg(l_module_name,'CANNOT_DELETE_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CANNOT_DELETE_TRIP');
694: END IF;
695: --
696: WHEN others THEN
697: -- OTM R12, glog proj
703: --
704: -- Debug Statements
705: --
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
708: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
709: END IF;
710: --
711: END Delete_Trip;
704: -- Debug Statements
705: --
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
708: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
709: END IF;
710: --
711: END Delete_Trip;
712:
753: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
754: --
755: IF l_debug_on IS NULL
756: THEN
757: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
758: END IF;
759: --
760: IF l_debug_on THEN
761: WSH_DEBUG_SV.push(l_module_name);
757: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
758: END IF;
759: --
760: IF l_debug_on THEN
761: WSH_DEBUG_SV.push(l_module_name);
762: --
763: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
764: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
765: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
759: --
760: IF l_debug_on THEN
761: WSH_DEBUG_SV.push(l_module_name);
762: --
763: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
764: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
765: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
766: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
760: IF l_debug_on THEN
761: WSH_DEBUG_SV.push(l_module_name);
762: --
763: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
764: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
765: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
766: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
761: WSH_DEBUG_SV.push(l_module_name);
762: --
763: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
764: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
765: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
766: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
762: --
763: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
764: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
765: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
766: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
763: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
764: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
765: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
766: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
764: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
765: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
766: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
765: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
766: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
766: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
767: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
768: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
769: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
770: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
771: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
772: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
773: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
774: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
775: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
776: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
777: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
778: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
779: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
780: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
781: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
782: WSH_DEBUG_SV.log(l_module_name,'load_tender_number', p_trip_info.load_tender_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
783: WSH_DEBUG_SV.log(l_module_name,'wf_name', p_trip_info.wf_name);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
784: WSH_DEBUG_SV.log(l_module_name,'wf_process_name', p_trip_info.wf_process_name);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
785: WSH_DEBUG_SV.log(l_module_name,'wf_item_key', p_trip_info.wf_item_key);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
786: WSH_DEBUG_SV.log(l_module_name,'carrier_contact_id', p_trip_info.carrier_contact_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
794: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
787: WSH_DEBUG_SV.log(l_module_name,'shipper_wait_time', p_trip_info.shipper_wait_time);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
794: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
795: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
788: WSH_DEBUG_SV.log(l_module_name,'wait_time_uom', p_trip_info.wait_time_uom);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
794: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
795: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
796: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
789: WSH_DEBUG_SV.log(l_module_name,'vessel', p_trip_info.vessel);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
794: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
795: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
796: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
797: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
790: WSH_DEBUG_SV.log(l_module_name,'voyage_number', p_trip_info.voyage_number);
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
794: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
795: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
796: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
797: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
798:
791: WSH_DEBUG_SV.log(l_module_name,'port_of_loading', p_trip_info.port_of_loading);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
794: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
795: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
796: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
797: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
798:
799: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
792: WSH_DEBUG_SV.log(l_module_name,'port_of_discharge', p_trip_info.port_of_discharge);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
794: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
795: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
796: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
797: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
798:
799: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
800: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
793: WSH_DEBUG_SV.log(l_module_name,'carrier_response', p_trip_info.carrier_response);
794: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
795: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
796: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
797: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
798:
799: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
800: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
801: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
795: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
796: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
797: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
798:
799: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
800: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
801: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
802: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
803: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
796: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
797: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
798:
799: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
800: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
801: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
802: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
803: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
804: END IF;
797: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
798:
799: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
800: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
801: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
802: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
803: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
804: END IF;
805: --
798:
799: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
800: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
801: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
802: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
803: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
804: END IF;
805: --
806: IF (p_rowid IS NULL) THEN
799: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
800: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
801: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
802: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
803: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
804: END IF;
805: --
806: IF (p_rowid IS NULL) THEN
807: OPEN get_row_id;
922: --
923: -- Debug Statements
924: --
925: IF l_debug_on THEN
926: WSH_DEBUG_SV.pop(l_module_name);
927: END IF;
928: --
929: EXCEPTION
930: WHEN no_data_found THEN
934: --
935: -- Debug Statements
936: --
937: IF l_debug_on THEN
938: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
940: END IF;
941: --
942: --Bug # 3268641
935: -- Debug Statements
936: --
937: IF l_debug_on THEN
938: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
940: END IF;
941: --
942: --Bug # 3268641
943: WHEN DUP_VAL_ON_INDEX THEN
945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
946: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
947:
948: IF l_debug_on THEN
949: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
950: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
951: END IF;
952: --
953:
946: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
947:
948: IF l_debug_on THEN
949: WSH_DEBUG_SV.logmsg(l_module_name,'DUP_VAL_ON_INDEX exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
950: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DUP_VAL_ON_INDEX');
951: END IF;
952: --
953:
954:
959: --
960: -- Debug Statements
961: --
962: IF l_debug_on THEN
963: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
964: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
965: END IF;
966: --
967: END Update_Trip;
960: -- Debug Statements
961: --
962: IF l_debug_on THEN
963: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
964: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
965: END IF;
966: --
967: END Update_Trip;
968:
1073: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1074: --
1075: IF l_debug_on IS NULL
1076: THEN
1077: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1078: END IF;
1079: --
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.push(l_module_name);
1077: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1078: END IF;
1079: --
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.push(l_module_name);
1082: --
1083: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1084: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
1085: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
1079: --
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.push(l_module_name);
1082: --
1083: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1084: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
1085: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
1086: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1080: IF l_debug_on THEN
1081: WSH_DEBUG_SV.push(l_module_name);
1082: --
1083: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1084: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
1085: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
1086: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1081: WSH_DEBUG_SV.push(l_module_name);
1082: --
1083: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1084: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
1085: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
1086: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1082: --
1083: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1084: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
1085: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
1086: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1083: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1084: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
1085: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
1086: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1084: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_trip_info.trip_id);
1085: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
1086: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1085: WSH_DEBUG_SV.log(l_module_name,'name', p_trip_info.name);
1086: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1086: WSH_DEBUG_SV.log(l_module_name,'planned_flag', p_trip_info.planned_flag);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1087: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id', p_trip_info.arrive_after_trip_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1088: WSH_DEBUG_SV.log(l_module_name,'status_code', p_trip_info.status_code);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1089: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id', p_trip_info.vehicle_item_id);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1090: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id', p_trip_info.vehicle_organization_id);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1091: WSH_DEBUG_SV.log(l_module_name,'vehicle_number', p_trip_info.vehicle_number);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1092: WSH_DEBUG_SV.log(l_module_name,'vehicle_num_prefix', p_trip_info.vehicle_num_prefix);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1093: WSH_DEBUG_SV.log(l_module_name,'carrier_id', p_trip_info.carrier_id);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1094: WSH_DEBUG_SV.log(l_module_name,'ship_method_code', p_trip_info.ship_method_code);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1102: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
1095: WSH_DEBUG_SV.log(l_module_name,'route_id', p_trip_info.route_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1102: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
1103: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
1096: WSH_DEBUG_SV.log(l_module_name,'routing_instructions', p_trip_info.routing_instructions);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1102: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
1103: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
1104: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
1097: WSH_DEBUG_SV.log(l_module_name,'service_level', p_trip_info.service_level);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1102: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
1103: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
1104: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
1105: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
1098: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport', p_trip_info.mode_of_transport);
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1102: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
1103: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
1104: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
1105: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
1106:
1099: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code', p_trip_info.freight_terms_code);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1102: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
1103: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
1104: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
1105: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
1106:
1107: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
1100: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed', p_trip_info.consolidation_allowed);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1102: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
1103: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
1104: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
1105: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
1106:
1107: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
1108: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
1101: WSH_DEBUG_SV.log(l_module_name,'load_tender_status', p_trip_info.load_tender_status);
1102: WSH_DEBUG_SV.log(l_module_name,'route_lane_id', p_trip_info.route_lane_id);
1103: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
1104: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
1105: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
1106:
1107: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
1108: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
1109: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
1103: WSH_DEBUG_SV.log(l_module_name,'lane_id', p_trip_info.lane_id);
1104: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
1105: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
1106:
1107: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
1108: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
1109: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
1110: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
1111: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
1104: WSH_DEBUG_SV.log(l_module_name,'schedule_id', p_trip_info.schedule_id);
1105: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
1106:
1107: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
1108: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
1109: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
1110: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
1111: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
1112: END IF;
1105: WSH_DEBUG_SV.log(l_module_name,'booking_number', p_trip_info.booking_number);
1106:
1107: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
1108: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
1109: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
1110: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
1111: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
1112: END IF;
1113: --
1106:
1107: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
1108: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
1109: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
1110: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
1111: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
1112: END IF;
1113: --
1114:
1107: WSH_DEBUG_SV.log(l_module_name,'carrier_reference_number', p_trip_info.carrier_reference_number);
1108: WSH_DEBUG_SV.log(l_module_name,'consignee_carrier_ac_no', p_trip_info.consignee_carrier_ac_no);
1109: WSH_DEBUG_SV.log(l_module_name,'rank_id', p_trip_info.rank_id);
1110: WSH_DEBUG_SV.log(l_module_name,'routing_rule_id', p_trip_info.routing_rule_id);
1111: WSH_DEBUG_SV.log(l_module_name,'append_flag', p_trip_info.append_flag);
1112: END IF;
1113: --
1114:
1115: --OTM R12, glog proj, use Global Variable
1134: IF (lock_row%NOTFOUND) THEN
1135: CLOSE lock_row;
1136: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
1137: IF l_debug_on THEN
1138: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1139: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');
1140: END IF;
1141: app_exception.raise_exception;
1142: END IF;
1135: CLOSE lock_row;
1136: FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
1137: IF l_debug_on THEN
1138: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1139: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');
1140: END IF;
1141: app_exception.raise_exception;
1142: END IF;
1143:
1310: --
1311: -- Debug Statements
1312: --
1313: IF l_debug_on THEN
1314: WSH_DEBUG_SV.pop(l_module_name);
1315: END IF;
1316: --
1317: return;
1318: ELSE
1317: return;
1318: ELSE
1319: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1320: IF l_debug_on THEN
1321: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1322: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');
1323: END IF;
1324: app_exception.raise_exception;
1325: END IF;
1318: ELSE
1319: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1320: IF l_debug_on THEN
1321: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1322: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:app_exception');
1323: END IF;
1324: app_exception.raise_exception;
1325: END IF;
1326:
1327: --
1328: -- Debug Statements
1329: --
1330: IF l_debug_on THEN
1331: WSH_DEBUG_SV.pop(l_module_name);
1332: END IF;
1333: --
1334: EXCEPTION
1335: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
1337: close lock_row;
1338: end if;
1339: --
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
1343: END IF;
1344: --
1345: RAISE;
1338: end if;
1339: --
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
1343: END IF;
1344: --
1345: RAISE;
1346: --
1350: close lock_row;
1351: end if;
1352: --
1353: IF l_debug_on THEN
1354: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1355: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1356: END IF;
1357: --
1358: raise;
1351: end if;
1352: --
1353: IF l_debug_on THEN
1354: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1355: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1356: END IF;
1357: --
1358: raise;
1359: --
1471: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1472: --
1473: IF l_debug_on IS NULL
1474: THEN
1475: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1476: END IF;
1477: --
1478: IF l_debug_on THEN
1479: WSH_DEBUG_SV.push(l_module_name);
1475: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1476: END IF;
1477: --
1478: IF l_debug_on THEN
1479: WSH_DEBUG_SV.push(l_module_name);
1480: --
1481: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1482: END IF;
1483: --
1477: --
1478: IF l_debug_on THEN
1479: WSH_DEBUG_SV.push(l_module_name);
1480: --
1481: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1482: END IF;
1483: --
1484: IF (p_trip_id IS NULL) THEN
1485: raise others;
1515: --
1516: -- Debug Statements
1517: --
1518: IF l_debug_on THEN
1519: WSH_DEBUG_SV.pop(l_module_name);
1520: END IF;
1521: --
1522: EXCEPTION
1523: WHEN others THEN
1527: --
1528: -- Debug Statements
1529: --
1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1532: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1533: END IF;
1534: --
1535: END Populate_Record;
1528: -- Debug Statements
1529: --
1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1532: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1533: END IF;
1534: --
1535: END Populate_Record;
1536:
1563: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1564: --
1565: IF l_debug_on IS NULL
1566: THEN
1567: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1568: END IF;
1569: --
1570: IF l_debug_on THEN
1571: WSH_DEBUG_SV.push(l_module_name);
1567: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1568: END IF;
1569: --
1570: IF l_debug_on THEN
1571: WSH_DEBUG_SV.push(l_module_name);
1572: --
1573: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1574: END IF;
1575: --
1569: --
1570: IF l_debug_on THEN
1571: WSH_DEBUG_SV.push(l_module_name);
1572: --
1573: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1574: END IF;
1575: --
1576: IF (p_trip_id IS NULL) THEN
1577: raise others;
1587: --
1588: -- Debug Statements
1589: --
1590: IF l_debug_on THEN
1591: WSH_DEBUG_SV.pop(l_module_name);
1592: END IF;
1593: --
1594: RETURN null;
1595: END IF;
1597: --
1598: -- Debug Statements
1599: --
1600: IF l_debug_on THEN
1601: WSH_DEBUG_SV.pop(l_module_name);
1602: END IF;
1603: --
1604: RETURN x_name;
1605:
1610: --
1611: -- Debug Statements
1612: --
1613: IF l_debug_on THEN
1614: WSH_DEBUG_SV.pop(l_module_name);
1615: END IF;
1616: --
1617: RETURN null;
1618:
1619: --
1620: -- Debug Statements
1621: --
1622: IF l_debug_on THEN
1623: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1624: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1625: END IF;
1626: --
1627: END Get_Name;
1620: -- Debug Statements
1621: --
1622: IF l_debug_on THEN
1623: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1624: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1625: END IF;
1626: --
1627: END Get_Name;
1628:
1648: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1649: --
1650: IF l_debug_on IS NULL
1651: THEN
1652: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1653: END IF;
1654: --
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.push(l_module_name);
1652: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1653: END IF;
1654: --
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.push(l_module_name);
1657: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1658: WSH_DEBUG_SV.log(l_module_name,'Total Number of Trip Records being locked',p_valid_index_tab.COUNT);
1659: END IF;
1660: --
1653: END IF;
1654: --
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.push(l_module_name);
1657: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1658: WSH_DEBUG_SV.log(l_module_name,'Total Number of Trip Records being locked',p_valid_index_tab.COUNT);
1659: END IF;
1660: --
1661: --
1654: --
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.push(l_module_name);
1657: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1658: WSH_DEBUG_SV.log(l_module_name,'Total Number of Trip Records being locked',p_valid_index_tab.COUNT);
1659: END IF;
1660: --
1661: --
1662: l_index := p_valid_index_tab.FIRST;
1693:
1694: l_num_errors := l_num_errors + 1;
1695: --
1696: IF l_debug_on THEN
1697: WSH_DEBUG_SV.log(l_module_name,'Unable to obtain lock on the Trip Id',p_rec_attr_tab(l_index).trip_id);
1698: END IF;
1699: --
1700: WHEN others THEN
1701: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1711: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
1712: x_return_status := wsh_util_core.g_ret_sts_error;
1713: wsh_util_core.add_message(x_return_status,l_module_name);
1714: IF l_debug_on THEN
1715: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
1716: END IF;
1717: RAISE FND_API.G_EXC_ERROR;
1718: ELSIF l_num_errors > 0 THEN
1719: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
1719: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
1720: x_return_status := wsh_util_core.g_ret_sts_warning;
1721: wsh_util_core.add_message(x_return_status,l_module_name);
1722: IF l_debug_on THEN
1723: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
1724: END IF;
1725: raise wsh_util_core.g_exc_warning;
1726: ELSE
1727: x_return_status := wsh_util_core.g_ret_sts_success;
1728: END IF;
1729:
1730: --
1731: IF l_debug_on THEN
1732: WSH_DEBUG_SV.pop(l_module_name);
1733: END IF;
1734: --
1735: EXCEPTION
1736: --
1739: --
1740: x_return_status := wsh_util_core.g_ret_sts_error;
1741: --
1742: IF l_debug_on THEN
1743: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1745: END IF;
1746: --
1747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1740: x_return_status := wsh_util_core.g_ret_sts_error;
1741: --
1742: IF l_debug_on THEN
1743: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1745: END IF;
1746: --
1747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1748: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1748: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1749: --
1750: IF l_debug_on THEN
1751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1753: END IF;
1754: --
1755: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1748: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1749: --
1750: IF l_debug_on THEN
1751: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1752: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1753: END IF;
1754: --
1755: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1756: x_return_status := wsh_util_core.g_ret_sts_warning;
1755: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1756: x_return_status := wsh_util_core.g_ret_sts_warning;
1757: --
1758: IF l_debug_on THEN
1759: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1761: END IF;
1762: --
1763: WHEN OTHERS THEN
1756: x_return_status := wsh_util_core.g_ret_sts_warning;
1757: --
1758: IF l_debug_on THEN
1759: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1760: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1761: END IF;
1762: --
1763: WHEN OTHERS THEN
1764: --
1766: --
1767: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_TRIP_WRAPPER',l_module_name);
1768: --
1769: IF l_debug_on THEN
1770: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1771: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1772: END IF;
1773: --
1774: END Lock_Trip;
1767: wsh_util_core.default_handler('WSH_DELIVERY_DETAILS_PKG.LOCK_TRIP_WRAPPER',l_module_name);
1768: --
1769: IF l_debug_on THEN
1770: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1771: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1772: END IF;
1773: --
1774: END Lock_Trip;
1775:
1792: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1793: --
1794: IF l_debug_on IS NULL
1795: THEN
1796: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1797: END IF;
1798: --
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.push(l_module_name);
1796: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1797: END IF;
1798: --
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.push(l_module_name);
1801: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
1802: END IF;
1803:
1804: OPEN c_lock_trip;
1797: END IF;
1798: --
1799: IF l_debug_on THEN
1800: WSH_DEBUG_SV.push(l_module_name);
1801: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
1802: END IF;
1803:
1804: OPEN c_lock_trip;
1805: FETCH c_lock_trip INTO l_trip_id;
1805: FETCH c_lock_trip INTO l_trip_id;
1806: CLOSE c_lock_trip;
1807:
1808: IF l_debug_on THEN
1809: WSH_DEBUG_SV.log(l_module_name,'trip id is locked',l_trip_id);
1810: END IF;
1811:
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.pop(l_module_name);
1809: WSH_DEBUG_SV.log(l_module_name,'trip id is locked',l_trip_id);
1810: END IF;
1811:
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.pop(l_module_name);
1814: END IF;
1815:
1816: EXCEPTION
1817: WHEN app_exception.application_exception
1816: EXCEPTION
1817: WHEN app_exception.application_exception
1818: OR app_exception.record_lock_exception THEN
1819: IF l_debug_on THEN
1820: wsh_debug_sv.log(l_module_name, 'Could not lock trip', p_trip_id);
1821: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');
1822: END IF;
1823: --
1824: RAISE;
1817: WHEN app_exception.application_exception
1818: OR app_exception.record_lock_exception THEN
1819: IF l_debug_on THEN
1820: wsh_debug_sv.log(l_module_name, 'Could not lock trip', p_trip_id);
1821: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');
1822: END IF;
1823: --
1824: RAISE;
1825:
1827: --
1828: wsh_util_core.default_handler('WSH_TRIPS_PVT.lock_trip_no_compare',l_module_name);
1829: --
1830: IF l_debug_on THEN
1831: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1832: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1833: END IF;
1834: --
1835: RAISE;
1828: wsh_util_core.default_handler('WSH_TRIPS_PVT.lock_trip_no_compare',l_module_name);
1829: --
1830: IF l_debug_on THEN
1831: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1832: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1833: END IF;
1834: --
1835: RAISE;
1836: END lock_trip_no_compare;