eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIP_STOPS_PVT dependencies on WSH_DEBUG_SV

Line 55: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

51: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
52: --
53: IF l_debug_on IS NULL
54: THEN
55: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
56: END IF;
57: --
58: IF l_debug_on THEN
59: WSH_DEBUG_SV.push(l_module_name);

Line 59: WSH_DEBUG_SV.push(l_module_name);

55: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
56: END IF;
57: --
58: IF l_debug_on THEN
59: WSH_DEBUG_SV.push(l_module_name);
60: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_trip_stop_info.STOP_ID);
61: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_stop_info.TRIP_ID);
62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);
63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);

Line 60: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_trip_stop_info.STOP_ID);

56: END IF;
57: --
58: IF l_debug_on THEN
59: WSH_DEBUG_SV.push(l_module_name);
60: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_trip_stop_info.STOP_ID);
61: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_stop_info.TRIP_ID);
62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);
63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);
64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);

Line 61: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_stop_info.TRIP_ID);

57: --
58: IF l_debug_on THEN
59: WSH_DEBUG_SV.push(l_module_name);
60: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_trip_stop_info.STOP_ID);
61: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_stop_info.TRIP_ID);
62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);
63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);
64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);
65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);

Line 62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);

58: IF l_debug_on THEN
59: WSH_DEBUG_SV.push(l_module_name);
60: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_trip_stop_info.STOP_ID);
61: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_stop_info.TRIP_ID);
62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);
63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);
64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);
65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);
66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);

Line 63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);

59: WSH_DEBUG_SV.push(l_module_name);
60: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_trip_stop_info.STOP_ID);
61: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_stop_info.TRIP_ID);
62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);
63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);
64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);
65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);
66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);
67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);

Line 64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);

60: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_trip_stop_info.STOP_ID);
61: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_stop_info.TRIP_ID);
62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);
63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);
64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);
65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);
66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);
67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);
68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);

Line 65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);

61: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_stop_info.TRIP_ID);
62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);
63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);
64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);
65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);
66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);
67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);
68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);

Line 66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);

62: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_trip_stop_info.STOP_LOCATION_ID);
63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);
64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);
65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);
66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);
67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);
68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);
70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);

Line 67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);

63: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_stop_info.STATUS_CODE);
64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);
65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);
66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);
67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);
68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);
70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);
71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);

Line 68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);

64: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_trip_stop_info.STOP_SEQUENCE_NUMBER);
65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);
66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);
67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);
68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);
70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);
71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);
72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);

Line 69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);

65: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_trip_stop_info.PLANNED_ARRIVAL_DATE);
66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);
67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);
68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);
70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);
71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);
72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);
73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);

Line 70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);

66: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_trip_stop_info.PLANNED_DEPARTURE_DATE);
67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);
68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);
70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);
71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);
72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);
73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);
74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);

Line 71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);

67: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_trip_stop_info.ACTUAL_ARRIVAL_DATE);
68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);
70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);
71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);
72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);
73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);
74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);

Line 72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);

68: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_trip_stop_info.ACTUAL_DEPARTURE_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);
70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);
71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);
72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);
73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);
74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);
76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);

Line 73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);

69: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_trip_stop_info.DEPARTURE_GROSS_WEIGHT);
70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);
71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);
72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);
73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);
74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);
76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);
77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);

Line 74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);

70: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_trip_stop_info.DEPARTURE_NET_WEIGHT);
71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);
72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);
73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);
74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);
76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);
77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);
78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);

Line 75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);

71: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_trip_stop_info.WEIGHT_UOM_CODE);
72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);
73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);
74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);
76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);
77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);
78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);
79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);

Line 76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);

72: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_trip_stop_info.DEPARTURE_VOLUME);
73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);
74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);
76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);
77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);
78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);
79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);
80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);

Line 77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);

73: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_trip_stop_info.VOLUME_UOM_CODE);
74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);
76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);
77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);
78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);
79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);
80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);
81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);

Line 78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);

74: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_trip_stop_info.DEPARTURE_SEAL_CODE);
75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);
76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);
77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);
78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);
79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);
80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);
81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);
82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);

Line 79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);

75: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_trip_stop_info.DEPARTURE_FILL_PERCENT);
76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);
77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);
78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);
79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);
80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);
81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);
82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);
83: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_trip_stop_info.UNLOADING_START_DATETIME);

Line 80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);

76: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_trip_stop_info.WSH_LOCATION_ID);
77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);
78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);
79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);
80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);
81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);
82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);
83: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_trip_stop_info.UNLOADING_START_DATETIME);
84: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_trip_stop_info.UNLOADING_END_DATETIME);

Line 81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);

77: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_trip_stop_info.TRACKING_DRILLDOWN_FLAG);
78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);
79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);
80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);
81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);
82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);
83: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_trip_stop_info.UNLOADING_START_DATETIME);
84: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_trip_stop_info.UNLOADING_END_DATETIME);
85: WSH_DEBUG_SV.log(l_module_name,'SHIPMENTS_TYPE_FLAG',p_trip_stop_info.SHIPMENTS_TYPE_FLAG);

Line 82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);

78: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_trip_stop_info.TRACKING_REMARKS);
79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);
80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);
81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);
82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);
83: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_trip_stop_info.UNLOADING_START_DATETIME);
84: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_trip_stop_info.UNLOADING_END_DATETIME);
85: WSH_DEBUG_SV.log(l_module_name,'SHIPMENTS_TYPE_FLAG',p_trip_stop_info.SHIPMENTS_TYPE_FLAG);
86: END IF;

Line 83: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_trip_stop_info.UNLOADING_START_DATETIME);

79: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_trip_stop_info.CARRIER_EST_DEPARTURE_DATE);
80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);
81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);
82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);
83: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_trip_stop_info.UNLOADING_START_DATETIME);
84: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_trip_stop_info.UNLOADING_END_DATETIME);
85: WSH_DEBUG_SV.log(l_module_name,'SHIPMENTS_TYPE_FLAG',p_trip_stop_info.SHIPMENTS_TYPE_FLAG);
86: END IF;
87: --

Line 84: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_trip_stop_info.UNLOADING_END_DATETIME);

80: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_trip_stop_info.CARRIER_EST_ARRIVAL_DATE);
81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);
82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);
83: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_trip_stop_info.UNLOADING_START_DATETIME);
84: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_trip_stop_info.UNLOADING_END_DATETIME);
85: WSH_DEBUG_SV.log(l_module_name,'SHIPMENTS_TYPE_FLAG',p_trip_stop_info.SHIPMENTS_TYPE_FLAG);
86: END IF;
87: --
88: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 85: WSH_DEBUG_SV.log(l_module_name,'SHIPMENTS_TYPE_FLAG',p_trip_stop_info.SHIPMENTS_TYPE_FLAG);

81: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_trip_stop_info.LOADING_START_DATETIME);
82: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_trip_stop_info.LOADING_END_DATETIME);
83: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_trip_stop_info.UNLOADING_START_DATETIME);
84: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_trip_stop_info.UNLOADING_END_DATETIME);
85: WSH_DEBUG_SV.log(l_module_name,'SHIPMENTS_TYPE_FLAG',p_trip_stop_info.SHIPMENTS_TYPE_FLAG);
86: END IF;
87: --
88: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
89: l_trips.DELETE;

Line 138: WSH_DEBUG_SV.log(l_module_name,'l_physical_loc_id',l_physical_loc_id);

134: raise get_physical_loc_err;
135: END IF;
136:
137: IF l_debug_on THEN
138: WSH_DEBUG_SV.log(l_module_name,'l_physical_loc_id',l_physical_loc_id);
139: END IF;
140:
141: INSERT INTO wsh_trip_stops(
142: stop_id,

Line 300: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);

296: --
297: -- Workflow Project
298: -- Raise Trip Stop Creation business event
299: IF l_debug_on THEN
300: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
301: END IF;
302:
303: WSH_WF_STD.RAISE_EVENT( p_entity_type => 'STOP',
304: p_entity_id => x_stop_id,

Line 310: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);

306: x_return_status => l_wf_rs
307: );
308:
309: IF l_debug_on THEN
310: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_WF_STD.RAISE_EVENT => ',l_wf_rs);
311: END IF;
312: -- End of code for Workflow project
313:
314: -- DBI Project

Line 319: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',x_stop_id);

315: -- Insert into WSH_TRIP_STOPS.
316: -- Call DBI API after the INSERT.
317: -- This API will also check for DBI Installed or not
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',x_stop_id);
320: END IF;
321: l_stop_tab(1) := x_stop_id;
322: WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
323: (p_stop_id_tab => l_stop_tab,

Line 328: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);

324: p_dml_type => 'INSERT',
325: x_return_status => l_dbi_rs);
326:
327: IF l_debug_on THEN
328: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
329: END IF;
330: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
331: x_return_status := l_dbi_rs;
332: -- just pass this return status to caller API

Line 334: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

330: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
331: x_return_status := l_dbi_rs;
332: -- just pass this return status to caller API
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
335: WSH_DEBUG_SV.pop(l_module_name);
336: END IF;
337: return;
338: END IF;

Line 335: WSH_DEBUG_SV.pop(l_module_name);

331: x_return_status := l_dbi_rs;
332: -- just pass this return status to caller API
333: IF l_debug_on THEN
334: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
335: WSH_DEBUG_SV.pop(l_module_name);
336: END IF;
337: return;
338: END IF;
339: -- End of Code for DBI Project

Line 358: WSH_DEBUG_SV.pop(l_module_name);

354: --
355: -- Debug Statements
356: --
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.pop(l_module_name);
359: END IF;
360: --
361: EXCEPTION
362:

Line 378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

374: --
375: -- Debug Statements
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
380: END IF;
381: --
382: END Create_Trip_Stop;

Line 379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

375: -- Debug Statements
376: --
377: IF l_debug_on THEN
378: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
379: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
380: END IF;
381: --
382: END Create_Trip_Stop;
383:

Line 452: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

448: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
449: --
450: IF l_debug_on IS NULL
451: THEN
452: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
453: END IF;
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.push(l_module_name);

Line 456: WSH_DEBUG_SV.push(l_module_name);

452: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
453: END IF;
454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.push(l_module_name);
457: --
458: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
459: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
460: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);

Line 458: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

454: --
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.push(l_module_name);
457: --
458: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
459: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
460: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
461: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
462: END IF;

Line 459: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

455: IF l_debug_on THEN
456: WSH_DEBUG_SV.push(l_module_name);
457: --
458: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
459: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
460: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
461: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
462: END IF;
463: --

Line 460: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);

456: WSH_DEBUG_SV.push(l_module_name);
457: --
458: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
459: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
460: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
461: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
462: END IF;
463: --
464: l_stop_id := p_stop_id;

Line 461: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);

457: --
458: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
459: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
460: WSH_DEBUG_SV.log(l_module_name,'P_VALIDATE_FLAG',P_VALIDATE_FLAG);
461: WSH_DEBUG_SV.log(l_module_name,'P_CALLER',P_CALLER);
462: END IF;
463: --
464: l_stop_id := p_stop_id;
465:

Line 506: WSH_DEBUG_SV.logmsg(l_module_name,'Ignore:'||l_ignore||' Tp Plan:'||l_tp_plan_name);

502: RAISE no_data_found;
503: END IF;
504: CLOSE c_get_trip_status;
505: IF l_debug_on THEN
506: WSH_DEBUG_SV.logmsg(l_module_name,'Ignore:'||l_ignore||' Tp Plan:'||l_tp_plan_name);
507: END IF;
508: IF (l_ignore = 'N' AND l_tp_plan_name IS NOT NULL) THEN
509: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
510: RAISE e_gc3_trip;

Line 521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.CHECK_STOP_DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);

517: --
518: -- Debug Statements
519: --
520: IF l_debug_on THEN
521: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.CHECK_STOP_DELETE',WSH_DEBUG_SV.C_PROC_LEVEL);
522: END IF;
523: --
524: WSH_TRIP_VALIDATIONS.check_stop_delete(
525: p_stop_id => l_stop_id,

Line 529: WSH_DEBUG_SV.log(l_module_name,'CHECK_STOP_DELETE x_return_status',x_return_status);

525: p_stop_id => l_stop_id,
526: x_return_status => l_return_status,
527: p_caller => p_caller);
528: IF l_debug_on THEN
529: WSH_DEBUG_SV.log(l_module_name,'CHECK_STOP_DELETE x_return_status',x_return_status);
530: END IF;
531:
532: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
533: x_return_status := l_return_status;

Line 539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

535: --
536: -- Debug Statements
537: --
538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
540: END IF;
541: --
542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));
543: wsh_util_core.add_message(x_return_status,l_module_name);

Line 548: WSH_DEBUG_SV.pop(l_module_name);

544: --
545: -- Debug Statements
546: --
547: IF l_debug_on THEN
548: WSH_DEBUG_SV.pop(l_module_name);
549: END IF;
550: --
551: RETURN;
552: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 567: WSH_DEBUG_SV.log(l_module_name,'Calling Delete_Delivery_Leg delivery_leg_id',rec.delivery_leg_id);

563:
564: FOR rec IN get_del_leg_id(l_stop_id) LOOP
565:
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.log(l_module_name,'Calling Delete_Delivery_Leg delivery_leg_id',rec.delivery_leg_id);
568: END IF;
569:
570: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg (
571: p_delivery_leg_id => rec.delivery_leg_id,

Line 575: WSH_DEBUG_SV.log(l_module_name,'After Calling Delete_Delivery_Leg x_return_status',x_return_status);

571: p_delivery_leg_id => rec.delivery_leg_id,
572: x_return_status => l_return_status);
573:
574: IF l_debug_on THEN
575: WSH_DEBUG_SV.log(l_module_name,'After Calling Delete_Delivery_Leg x_return_status',x_return_status);
576: END IF;
577:
578: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
579: IF l_debug_on THEN

Line 580: WSH_DEBUG_SV.pop(l_module_name);

576: END IF;
577:
578: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.pop(l_module_name);
581: END IF;
582: x_return_status := l_return_status;
583: RETURN;
584: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 600: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',l_stop_id);

596: -- DELETE from WSH_TRIP_STOPS.
597: -- Call DBI API after the DELETE.
598: -- This API will also check for DBI Installed or not
599: IF l_debug_on THEN
600: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',l_stop_id);
601: END IF;
602: l_stop_tab(1) := l_stop_id;
603: WSH_INTEGRATION.DBI_Update_Trip_Stop_Log
604: (p_stop_id_tab => l_stop_tab,

Line 609: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);

605: p_dml_type => 'DELETE',
606: x_return_status => l_dbi_rs);
607:
608: IF l_debug_on THEN
609: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
610: END IF;
611: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
612: x_return_status := l_dbi_rs;
613: -- just pass this return status to caller API

Line 615: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

611: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
612: x_return_status := l_dbi_rs;
613: -- just pass this return status to caller API
614: IF l_debug_on THEN
615: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
616: WSH_DEBUG_SV.pop(l_module_name);
617: END IF;
618: return;
619: END IF;

Line 616: WSH_DEBUG_SV.pop(l_module_name);

612: x_return_status := l_dbi_rs;
613: -- just pass this return status to caller API
614: IF l_debug_on THEN
615: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
616: WSH_DEBUG_SV.pop(l_module_name);
617: END IF;
618: return;
619: END IF;
620: -- End of Code for DBI Project

Line 628: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.trip_weight_volume',WSH_DEBUG_SV.C_PROC_LEVEL);

624: IF l_trip_id IS NOT NULL THEN
625:
626: -- Need to compute all stops weight/volumes
627: IF l_debug_on THEN
628: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.trip_weight_volume',WSH_DEBUG_SV.C_PROC_LEVEL);
629: END IF;
630:
631: l_trip_id_tab(1) := l_trip_id;
632: WSH_TRIPS_ACTIONS.trip_weight_volume(

Line 643: WSH_DEBUG_SV.logmsg(l_module_name,'Error calculating trip wt/vol');

639: p_suppress_errors => 'Y');
640:
641: IF x_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'Error calculating trip wt/vol');
644: END IF;
645: END IF;
646:
647: END IF;

Line 661: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

657: --
658: -- Debug Statements
659: --
660: IF l_debug_on THEN
661: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
662: WSH_DEBUG_SV.pop(l_module_name);
663: END IF;
664: --
665: EXCEPTION

Line 662: WSH_DEBUG_SV.pop(l_module_name);

658: -- Debug Statements
659: --
660: IF l_debug_on THEN
661: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
662: WSH_DEBUG_SV.pop(l_module_name);
663: END IF;
664: --
665: EXCEPTION
666: --OTM R12, glog proj

Line 678: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

674: --
675: -- Debug Statements
676: --
677: IF l_debug_on THEN
678: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
680: END IF;
681: --
682:

Line 679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

675: -- Debug Statements
676: --
677: IF l_debug_on THEN
678: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
680: END IF;
681: --
682:
683: --OTM R12, glog proj

Line 695: WSH_DEBUG_SV.logmsg(l_module_name,'E_GC3_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

691: --
692: -- Debug Statements
693: --
694: IF l_debug_on THEN
695: WSH_DEBUG_SV.logmsg(l_module_name,'E_GC3_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_GC3_TRIP');
697: END IF;
698: --
699:

Line 696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_GC3_TRIP');

692: -- Debug Statements
693: --
694: IF l_debug_on THEN
695: WSH_DEBUG_SV.logmsg(l_module_name,'E_GC3_TRIP exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
696: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_GC3_TRIP');
697: END IF;
698: --
699:
700: WHEN others THEN

Line 711: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

707: --
708: -- Debug Statements
709: --
710: IF l_debug_on THEN
711: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
713: END IF;
714: --
715: END Delete_Trip_Stop;

Line 712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

708: -- Debug Statements
709: --
710: IF l_debug_on THEN
711: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
712: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
713: END IF;
714: --
715: END Delete_Trip_Stop;
716:

Line 759: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

755: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
756: --
757: IF l_debug_on IS NULL
758: THEN
759: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
760: END IF;
761: --
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.push(l_module_name);

Line 763: WSH_DEBUG_SV.push(l_module_name);

759: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
760: END IF;
761: --
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.push(l_module_name);
764: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
765: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);

Line 764: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

760: END IF;
761: --
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.push(l_module_name);
764: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
765: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);

Line 765: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);

761: --
762: IF l_debug_on THEN
763: WSH_DEBUG_SV.push(l_module_name);
764: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
765: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);

Line 766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);

762: IF l_debug_on THEN
763: WSH_DEBUG_SV.push(l_module_name);
764: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
765: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);

Line 767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);

763: WSH_DEBUG_SV.push(l_module_name);
764: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
765: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);

Line 768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);

764: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
765: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);

Line 769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);

765: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);

Line 770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);

766: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);

Line 771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);

767: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);

Line 772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);

768: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);

Line 773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);

769: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);

Line 774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);

770: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);

Line 775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);

771: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);

Line 776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);

772: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);

Line 777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);

773: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);

Line 778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);

774: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);

Line 779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);

775: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);

Line 780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);

776: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);

Line 781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);

777: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);

Line 782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);

778: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);

Line 783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);

779: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);

Line 784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);

780: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);

Line 785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);

781: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);

Line 786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);

782: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
790: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_STOP_ID',p_stop_info.PHYSICAL_STOP_ID);

Line 787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);

783: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
790: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_STOP_ID',p_stop_info.PHYSICAL_STOP_ID);
791: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_LOCATION_ID',p_stop_info.PHYSICAL_LOCATION_ID);

Line 788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);

784: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
790: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_STOP_ID',p_stop_info.PHYSICAL_STOP_ID);
791: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_LOCATION_ID',p_stop_info.PHYSICAL_LOCATION_ID);
792: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj

Line 789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);

785: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
790: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_STOP_ID',p_stop_info.PHYSICAL_STOP_ID);
791: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_LOCATION_ID',p_stop_info.PHYSICAL_LOCATION_ID);
792: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj
793: END IF;

Line 790: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_STOP_ID',p_stop_info.PHYSICAL_STOP_ID);

786: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
790: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_STOP_ID',p_stop_info.PHYSICAL_STOP_ID);
791: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_LOCATION_ID',p_stop_info.PHYSICAL_LOCATION_ID);
792: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj
793: END IF;
794: --

Line 791: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_LOCATION_ID',p_stop_info.PHYSICAL_LOCATION_ID);

787: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
790: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_STOP_ID',p_stop_info.PHYSICAL_STOP_ID);
791: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_LOCATION_ID',p_stop_info.PHYSICAL_LOCATION_ID);
792: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj
793: END IF;
794: --
795:

Line 792: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj

788: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
789: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
790: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_STOP_ID',p_stop_info.PHYSICAL_STOP_ID);
791: WSH_DEBUG_SV.log(l_module_name,'PHYSICAL_LOCATION_ID',p_stop_info.PHYSICAL_LOCATION_ID);
792: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj
793: END IF;
794: --
795:
796: -- J: W/V Changes

Line 809: WSH_DEBUG_SV.log(l_module_name,'l_rowid'||l_rowid||' Org Gross '||l_gross_wt||' Org Net '||l_net_wt||' Org Vol '||l_volume||' W Uom '||l_weight_uom_code||' V Uom '||l_volume_uom_code||' frozen '||l_frozen_flag);

805: l_rowid := p_rowid;
806: END IF;
807:
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.log(l_module_name,'l_rowid'||l_rowid||' Org Gross '||l_gross_wt||' Org Net '||l_net_wt||' Org Vol '||l_volume||' W Uom '||l_weight_uom_code||' V Uom '||l_volume_uom_code||' frozen '||l_frozen_flag);
810: END IF;
811:
812: IF l_weight_uom_code <> p_stop_info.weight_uom_code THEN
813:

Line 930: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',p_stop_info.stop_id);

926: -- Update WSH_TRIP_STOPS.
927: -- Call DBI API after the UPDATE.
928: -- This API will also check for DBI Installed or not
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Stop id-',p_stop_info.stop_id);
931: END IF;
932: l_stop_tab(1) := p_stop_info.stop_id;
933: WSH_INTEGRATION.dbi_update_trip_stop_log
934: (p_stop_id_tab => l_stop_tab,

Line 939: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);

935: p_dml_type => 'UPDATE',
936: x_return_status => l_dbi_rs);
937:
938: IF l_debug_on THEN
939: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
940: END IF;
941: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
942: x_return_status := l_dbi_rs;
943: -- just pass this return status to caller API

Line 945: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);

941: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
942: x_return_status := l_dbi_rs;
943: -- just pass this return status to caller API
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
946: WSH_DEBUG_SV.pop(l_module_name);
947: END IF;
948: return;
949: END IF;

Line 946: WSH_DEBUG_SV.pop(l_module_name);

942: x_return_status := l_dbi_rs;
943: -- just pass this return status to caller API
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.log(l_module_name,'DBI API Returned Unexpected error '||x_return_status);
946: WSH_DEBUG_SV.pop(l_module_name);
947: END IF;
948: return;
949: END IF;
950: -- End of Code for DBI Project

Line 959: WSH_DEBUG_SV.pop(l_module_name);

955: --
956: -- Debug Statements
957: --
958: IF l_debug_on THEN
959: WSH_DEBUG_SV.pop(l_module_name);
960: END IF;
961: --
962: EXCEPTION
963: WHEN no_data_found THEN

Line 971: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

967: --
968: -- Debug Statements
969: --
970: IF l_debug_on THEN
971: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
973: END IF;
974: --
975: WHEN others THEN

Line 972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

968: -- Debug Statements
969: --
970: IF l_debug_on THEN
971: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
973: END IF;
974: --
975: WHEN others THEN
976: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP',l_module_name);

Line 983: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

979: --
980: -- Debug Statements
981: --
982: IF l_debug_on THEN
983: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
985: END IF;
986: --
987: END Update_Trip_Stop;

Line 984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

980: -- Debug Statements
981: --
982: IF l_debug_on THEN
983: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
984: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
985: END IF;
986: --
987: END Update_Trip_Stop;
988:

Line 1014: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1010: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1011: --
1012: IF l_debug_on IS NULL
1013: THEN
1014: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1015: END IF;
1016: --
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.push(l_module_name);

Line 1018: WSH_DEBUG_SV.push(l_module_name);

1014: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1015: END IF;
1016: --
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.push(l_module_name);
1019: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1020: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);

Line 1019: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);

1015: END IF;
1016: --
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.push(l_module_name);
1019: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1020: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);

Line 1020: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);

1016: --
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.push(l_module_name);
1019: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1020: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);

Line 1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);

1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.push(l_module_name);
1019: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1020: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);

Line 1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);

1018: WSH_DEBUG_SV.push(l_module_name);
1019: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1020: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);

Line 1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);

1019: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
1020: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);

Line 1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);

1020: WSH_DEBUG_SV.log(l_module_name,'STOP_ID',p_stop_info.STOP_ID);
1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);

Line 1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);

1021: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_stop_info.TRIP_ID);
1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);

Line 1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);

1022: WSH_DEBUG_SV.log(l_module_name,'STOP_LOCATION_ID',p_stop_info.STOP_LOCATION_ID);
1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);

Line 1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);

1023: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_stop_info.STATUS_CODE);
1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);

Line 1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);

1024: WSH_DEBUG_SV.log(l_module_name,'STOP_SEQUENCE_NUMBER',p_stop_info.STOP_SEQUENCE_NUMBER);
1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);

Line 1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);

1025: WSH_DEBUG_SV.log(l_module_name,'PLANNED_ARRIVAL_DATE',p_stop_info.PLANNED_ARRIVAL_DATE);
1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);

Line 1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);

1026: WSH_DEBUG_SV.log(l_module_name,'PLANNED_DEPARTURE_DATE',p_stop_info.PLANNED_DEPARTURE_DATE);
1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);

Line 1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);

1027: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_ARRIVAL_DATE',p_stop_info.ACTUAL_ARRIVAL_DATE);
1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);

Line 1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);

1028: WSH_DEBUG_SV.log(l_module_name,'ACTUAL_DEPARTURE_DATE',p_stop_info.ACTUAL_DEPARTURE_DATE);
1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);

Line 1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);

1029: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_GROSS_WEIGHT',p_stop_info.DEPARTURE_GROSS_WEIGHT);
1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);

Line 1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);

1030: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_NET_WEIGHT',p_stop_info.DEPARTURE_NET_WEIGHT);
1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);

Line 1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);

1031: WSH_DEBUG_SV.log(l_module_name,'WEIGHT_UOM_CODE',p_stop_info.WEIGHT_UOM_CODE);
1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);

Line 1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);

1032: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_VOLUME',p_stop_info.DEPARTURE_VOLUME);
1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);

Line 1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);

1033: WSH_DEBUG_SV.log(l_module_name,'VOLUME_UOM_CODE',p_stop_info.VOLUME_UOM_CODE);
1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);

Line 1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);

1034: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_SEAL_CODE',p_stop_info.DEPARTURE_SEAL_CODE);
1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);

Line 1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);

1035: WSH_DEBUG_SV.log(l_module_name,'DEPARTURE_FILL_PERCENT',p_stop_info.DEPARTURE_FILL_PERCENT);
1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
1043: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);

Line 1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);

1036: WSH_DEBUG_SV.log(l_module_name,'WSH_LOCATION_ID',p_stop_info.WSH_LOCATION_ID);
1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
1043: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
1044: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);

Line 1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);

1037: WSH_DEBUG_SV.log(l_module_name,'TRACKING_DRILLDOWN_FLAG',p_stop_info.TRACKING_DRILLDOWN_FLAG);
1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
1043: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
1044: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
1045: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj

Line 1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);

1038: WSH_DEBUG_SV.log(l_module_name,'TRACKING_REMARKS',p_stop_info.TRACKING_REMARKS);
1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
1043: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
1044: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
1045: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj
1046: END IF;

Line 1043: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);

1039: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_DEPARTURE_DATE',p_stop_info.CARRIER_EST_DEPARTURE_DATE);
1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
1043: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
1044: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
1045: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj
1046: END IF;
1047:

Line 1044: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);

1040: WSH_DEBUG_SV.log(l_module_name,'CARRIER_EST_ARRIVAL_DATE',p_stop_info.CARRIER_EST_ARRIVAL_DATE);
1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
1043: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
1044: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
1045: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj
1046: END IF;
1047:
1048: OPEN lock_row;

Line 1045: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj

1041: WSH_DEBUG_SV.log(l_module_name,'LOADING_START_DATETIME',p_stop_info.LOADING_START_DATETIME);
1042: WSH_DEBUG_SV.log(l_module_name,'LOADING_END_DATETIME',p_stop_info.LOADING_END_DATETIME);
1043: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_START_DATETIME',p_stop_info.UNLOADING_START_DATETIME);
1044: WSH_DEBUG_SV.log(l_module_name,'UNLOADING_END_DATETIME',p_stop_info.UNLOADING_END_DATETIME);
1045: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',p_stop_info.TMS_INTERFACE_FLAG); --OTM R12,glog proj
1046: END IF;
1047:
1048: OPEN lock_row;
1049: FETCH lock_row INTO Recinfo;

Line 1280: WSH_DEBUG_SV.pop(l_module_name,'RETURN');

1276: --
1277: -- Debug Statements
1278: --
1279: IF l_debug_on THEN
1280: WSH_DEBUG_SV.pop(l_module_name,'RETURN');
1281: END IF;
1282: --
1283: return;
1284: ELSE

Line 1293: WSH_DEBUG_SV.pop(l_module_name);

1289: --
1290: -- Debug Statements
1291: --
1292: IF l_debug_on THEN
1293: WSH_DEBUG_SV.pop(l_module_name);
1294: END IF;
1295: --
1296: EXCEPTION
1297: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN

Line 1303: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1299: close lock_row;
1300: end if;
1301: --
1302: IF l_debug_on THEN
1303: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
1305: END IF;
1306: --
1307: RAISE;

Line 1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');

1300: end if;
1301: --
1302: IF l_debug_on THEN
1303: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
1305: END IF;
1306: --
1307: RAISE;
1308: --

Line 1316: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1312: close lock_row;
1313: end if;
1314: --
1315: IF l_debug_on THEN
1316: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1317: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1318: END IF;
1319: --
1320: raise;

Line 1317: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1313: end if;
1314: --
1315: IF l_debug_on THEN
1316: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1317: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1318: END IF;
1319: --
1320: raise;
1321: --

Line 1433: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1429: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1430: --
1431: IF l_debug_on IS NULL
1432: THEN
1433: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1434: END IF;
1435: --
1436: IF l_debug_on THEN
1437: WSH_DEBUG_SV.push(l_module_name);

Line 1437: WSH_DEBUG_SV.push(l_module_name);

1433: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1434: END IF;
1435: --
1436: IF l_debug_on THEN
1437: WSH_DEBUG_SV.push(l_module_name);
1438: --
1439: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1440: END IF;
1441: --

Line 1439: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

1435: --
1436: IF l_debug_on THEN
1437: WSH_DEBUG_SV.push(l_module_name);
1438: --
1439: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1440: END IF;
1441: --
1442: IF (p_stop_id IS NULL) THEN
1443: raise others;

Line 1463: WSH_DEBUG_SV.pop(l_module_name);

1459: --
1460: -- Debug Statements
1461: --
1462: IF l_debug_on THEN
1463: WSH_DEBUG_SV.pop(l_module_name);
1464: END IF;
1465: --
1466: EXCEPTION
1467: WHEN others THEN

Line 1475: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1471: --
1472: -- Debug Statements
1473: --
1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1477: END IF;
1478: --
1479: END Populate_Record;

Line 1476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1472: -- Debug Statements
1473: --
1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1476: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1477: END IF;
1478: --
1479: END Populate_Record;
1480:

Line 1527: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1523: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1524: --
1525: IF l_debug_on IS NULL
1526: THEN
1527: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1528: END IF;
1529: --
1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.push(l_module_name);

Line 1531: WSH_DEBUG_SV.push(l_module_name);

1527: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1528: END IF;
1529: --
1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.push(l_module_name);
1532: --
1533: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1534: --tkt
1535: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);

Line 1533: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

1529: --
1530: IF l_debug_on THEN
1531: WSH_DEBUG_SV.push(l_module_name);
1532: --
1533: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1534: --tkt
1535: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1536: --tkt
1537: END IF;

Line 1535: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);

1531: WSH_DEBUG_SV.push(l_module_name);
1532: --
1533: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1534: --tkt
1535: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1536: --tkt
1537: END IF;
1538: --
1539: IF (p_stop_id IS NULL) THEN

Line 1551: WSH_DEBUG_SV.pop(l_module_name);

1547: CLOSE get_id;
1548: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
1549: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1550: IF l_debug_on THEN
1551: WSH_DEBUG_SV.pop(l_module_name);
1552: END IF;
1553: RETURN null;
1554: END IF;
1555: IF get_id%ISOPEN THEN

Line 1571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1567: --
1568: -- Debug Statements
1569: --
1570: IF l_debug_on THEN
1571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1572: WSH_DEBUG_SV.log(l_module_name,'x_id',x_id);
1573: END IF;
1574: --
1575: l_name := WSH_UTIL_CORE.get_location_description(x_id, 'NEW UI CODE');

Line 1572: WSH_DEBUG_SV.log(l_module_name,'x_id',x_id);

1568: -- Debug Statements
1569: --
1570: IF l_debug_on THEN
1571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.GET_LOCATION_DESCRIPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1572: WSH_DEBUG_SV.log(l_module_name,'x_id',x_id);
1573: END IF;
1574: --
1575: l_name := WSH_UTIL_CORE.get_location_description(x_id, 'NEW UI CODE');
1576: x_name := SUBSTR(l_name,1,60);

Line 1585: WSH_DEBUG_SV.pop(l_module_name);

1581: --
1582: -- Debug Statements
1583: --
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.pop(l_module_name);
1586: END IF;
1587: --
1588: RETURN null;
1589: END IF;

Line 1595: WSH_DEBUG_SV.pop(l_module_name);

1591: --
1592: -- Debug Statements
1593: --
1594: IF l_debug_on THEN
1595: WSH_DEBUG_SV.pop(l_module_name);
1596: END IF;
1597: --
1598: RETURN x_name;
1599:

Line 1606: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1602: WHEN others THEN
1603: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.GET_NAME',l_module_name);
1604: --
1605: IF l_debug_on THEN
1606: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1608: END IF;
1609: --
1610: RETURN null;

Line 1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1603: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.GET_NAME',l_module_name);
1604: --
1605: IF l_debug_on THEN
1606: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1608: END IF;
1609: --
1610: RETURN null;
1611:

Line 1723: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1719: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1720: --
1721: IF l_debug_on IS NULL
1722: THEN
1723: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1724: END IF;
1725: --
1726: IF l_debug_on THEN
1727: WSH_DEBUG_SV.push(l_module_name);

Line 1727: WSH_DEBUG_SV.push(l_module_name);

1723: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1724: END IF;
1725: --
1726: IF l_debug_on THEN
1727: WSH_DEBUG_SV.push(l_module_name);
1728: --
1729: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1730: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID',P_PARENT_ENTITY_ID);
1731: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);

Line 1729: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

1725: --
1726: IF l_debug_on THEN
1727: WSH_DEBUG_SV.push(l_module_name);
1728: --
1729: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1730: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID',P_PARENT_ENTITY_ID);
1731: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
1732: END IF;
1733: --

Line 1730: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID',P_PARENT_ENTITY_ID);

1726: IF l_debug_on THEN
1727: WSH_DEBUG_SV.push(l_module_name);
1728: --
1729: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1730: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID',P_PARENT_ENTITY_ID);
1731: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
1732: END IF;
1733: --
1734: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1731: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);

1727: WSH_DEBUG_SV.push(l_module_name);
1728: --
1729: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1730: WSH_DEBUG_SV.log(l_module_name,'P_PARENT_ENTITY_ID',P_PARENT_ENTITY_ID);
1731: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
1732: END IF;
1733: --
1734: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1735: --OTM R12, glog proj

Line 1817: WSH_DEBUG_SV.pop(l_module_name);

1813: --
1814: -- Debug Statements
1815: --
1816: IF l_debug_on THEN
1817: WSH_DEBUG_SV.pop(l_module_name);
1818: END IF;
1819: --
1820: RETURN;
1821: END IF;

Line 1837: WSH_DEBUG_SV.pop(l_module_name);

1833: --
1834: -- Debug Statements
1835: --
1836: IF l_debug_on THEN
1837: WSH_DEBUG_SV.pop(l_module_name);
1838: END IF;
1839: --
1840: RETURN;
1841: END IF;

Line 1886: WSH_DEBUG_SV.log(l_module_name,'Intransit Trip',p_parent_entity_id);

1882: -- inbetween closed/arrived stops, planned arrival date should
1883: -- not be updateable (Mixed Trips scenario, combination of Inbound
1884: -- and Outbound).
1885: IF l_debug_on THEN
1886: WSH_DEBUG_SV.log(l_module_name,'Intransit Trip',p_parent_entity_id);
1887: END IF;
1888: -- Check if the current stop being processed lies inbetween stops
1889: -- which are closed/arrived
1890: OPEN get_updateable_open_stop(l_stop_sequence_number);

Line 1909: WSH_DEBUG_SV.log(l_module_name,'Mixed Trip Open Stop-',p_stop_id);

1905: i:=i+1; x_disabled_list(i) := 'STOP_SEQUENCE_NUMBER';
1906: --
1907:
1908: IF l_debug_on THEN
1909: WSH_DEBUG_SV.log(l_module_name,'Mixed Trip Open Stop-',p_stop_id);
1910: END IF;
1911: END IF;
1912: ELSE
1913: -- SSN Change

Line 1934: WSH_DEBUG_SV.log(l_module_name,'Pickup Delivery found-',l_planned_flag);

1930: ELSE
1931: i:=i+1; x_disabled_list(i) := 'STOP_LOCATION_CODE';
1932: END IF;
1933: IF l_debug_on THEN
1934: WSH_DEBUG_SV.log(l_module_name,'Pickup Delivery found-',l_planned_flag);
1935: END IF;
1936: ELSE
1937: -- no pick_up deliveries, check if it has drop_off deliveries
1938: OPEN has_drop_off_deliveries(p_stop_id);

Line 1949: WSH_DEBUG_SV.log(l_module_name,'Pickup Delivery Not found-',l_planned_flag);

1945: END IF;
1946: END IF;
1947: CLOSE has_drop_off_deliveries;
1948: IF l_debug_on THEN
1949: WSH_DEBUG_SV.log(l_module_name,'Pickup Delivery Not found-',l_planned_flag);
1950: END IF;
1951: END IF;
1952: CLOSE has_pick_up_deliveries;
1953:

Line 1958: WSH_DEBUG_SV.log(l_module_name,'Caller--',p_caller);

1954: -- END OF FRONT PORTING BUG FIX 3134466
1955:
1956: -- OTM R12, glog project
1957: IF l_debug_on THEN
1958: WSH_DEBUG_SV.log(l_module_name,'Caller--',p_caller);
1959: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name--',l_tp_plan_name);
1960: WSH_DEBUG_SV.log(l_module_name,'GC3 Installed --',l_gc3_is_installed);
1961: END IF;
1962: -- Disable Stop Location and Stop Sequence Number

Line 1959: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name--',l_tp_plan_name);

1955:
1956: -- OTM R12, glog project
1957: IF l_debug_on THEN
1958: WSH_DEBUG_SV.log(l_module_name,'Caller--',p_caller);
1959: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name--',l_tp_plan_name);
1960: WSH_DEBUG_SV.log(l_module_name,'GC3 Installed --',l_gc3_is_installed);
1961: END IF;
1962: -- Disable Stop Location and Stop Sequence Number
1963: -- for GC3 trips (tp_plan_name is not null)

Line 1960: WSH_DEBUG_SV.log(l_module_name,'GC3 Installed --',l_gc3_is_installed);

1956: -- OTM R12, glog project
1957: IF l_debug_on THEN
1958: WSH_DEBUG_SV.log(l_module_name,'Caller--',p_caller);
1959: WSH_DEBUG_SV.log(l_module_name,'Tp Plan Name--',l_tp_plan_name);
1960: WSH_DEBUG_SV.log(l_module_name,'GC3 Installed --',l_gc3_is_installed);
1961: END IF;
1962: -- Disable Stop Location and Stop Sequence Number
1963: -- for GC3 trips (tp_plan_name is not null)
1964: -- For UI, disable Stop_Location_Code, for Inbound message

Line 2001: WSH_DEBUG_SV.log(l_module_name,'Stop has a closed linked dummy stop',dummy_id);

1997: CLOSE c_has_closed_dummy_stop;
1998:
1999: IF dummy_id IS NOT NULL THEN
2000: IF l_debug_on THEN
2001: WSH_DEBUG_SV.log(l_module_name,'Stop has a closed linked dummy stop',dummy_id);
2002: WSH_DEBUG_SV.log(l_module_name,'l_pad_disabled',l_pad_disabled);
2003: WSH_DEBUG_SV.log(l_module_name,'l_ssn_disabled',l_ssn_disabled);
2004: END IF;
2005: IF NOT l_ssn_disabled THEN

Line 2002: WSH_DEBUG_SV.log(l_module_name,'l_pad_disabled',l_pad_disabled);

1998:
1999: IF dummy_id IS NOT NULL THEN
2000: IF l_debug_on THEN
2001: WSH_DEBUG_SV.log(l_module_name,'Stop has a closed linked dummy stop',dummy_id);
2002: WSH_DEBUG_SV.log(l_module_name,'l_pad_disabled',l_pad_disabled);
2003: WSH_DEBUG_SV.log(l_module_name,'l_ssn_disabled',l_ssn_disabled);
2004: END IF;
2005: IF NOT l_ssn_disabled THEN
2006: i:=i+1; x_disabled_list(i) := 'STOP_SEQUENCE_NUMBER';

Line 2003: WSH_DEBUG_SV.log(l_module_name,'l_ssn_disabled',l_ssn_disabled);

1999: IF dummy_id IS NOT NULL THEN
2000: IF l_debug_on THEN
2001: WSH_DEBUG_SV.log(l_module_name,'Stop has a closed linked dummy stop',dummy_id);
2002: WSH_DEBUG_SV.log(l_module_name,'l_pad_disabled',l_pad_disabled);
2003: WSH_DEBUG_SV.log(l_module_name,'l_ssn_disabled',l_ssn_disabled);
2004: END IF;
2005: IF NOT l_ssn_disabled THEN
2006: i:=i+1; x_disabled_list(i) := 'STOP_SEQUENCE_NUMBER';
2007: END IF;

Line 2073: WSH_DEBUG_SV.pop(l_module_name);

2069: --
2070: -- Debug Statements
2071: --
2072: IF l_debug_on THEN
2073: WSH_DEBUG_SV.pop(l_module_name);
2074: END IF;
2075: --
2076: EXCEPTION
2077: WHEN e_all_disabled THEN --3509004:public api changes

Line 2084: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');

2080: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_id);
2081: wsh_util_core.add_message(x_return_status,l_module_name);
2082: IF l_debug_on THEN
2083: -- Nothing is updateable
2084: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
2085: END IF;
2086:
2087: WHEN WSH_DP_NO_ENTITY THEN
2088: FND_MESSAGE.SET_NAME('WSH', 'WSH_DP_NO_ENTITY');

Line 2103: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DP_NO_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2099: --
2100: -- Debug Statements
2101: --
2102: IF l_debug_on THEN
2103: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DP_NO_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2104: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
2105: END IF;
2106: --
2107: WHEN WSH_INV_LIST_TYPE THEN

Line 2104: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');

2100: -- Debug Statements
2101: --
2102: IF l_debug_on THEN
2103: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DP_NO_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2104: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
2105: END IF;
2106: --
2107: WHEN WSH_INV_LIST_TYPE THEN
2108: FND_MESSAGE.SET_NAME('WSH', 'WSH_INV_LIST_TYPE');

Line 2122: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INV_LIST_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2118: --
2119: -- Debug Statements
2120: --
2121: IF l_debug_on THEN
2122: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INV_LIST_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2123: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INV_LIST_TYPE');
2124: END IF;
2125: --
2126: WHEN OTHERS THEN

Line 2123: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INV_LIST_TYPE');

2119: -- Debug Statements
2120: --
2121: IF l_debug_on THEN
2122: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INV_LIST_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2123: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INV_LIST_TYPE');
2124: END IF;
2125: --
2126: WHEN OTHERS THEN
2127: IF get_stop_status%ISOPEN THEN

Line 2153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2149: FND_MESSAGE.Set_Name('WSH','WSH_UNEXPECTED_ERROR');
2150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2151:
2152: IF l_debug_on THEN
2153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2155: END IF;
2156: END Get_Disabled_List ;
2157:

Line 2154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

2150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2151:
2152: IF l_debug_on THEN
2153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2155: END IF;
2156: END Get_Disabled_List ;
2157:
2158: PROCEDURE lock_trip_stop_no_compare (p_stop_id IN NUMBER)

Line 2177: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2173: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2174: --
2175: IF l_debug_on IS NULL
2176: THEN
2177: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2178: END IF;
2179: --
2180: IF l_debug_on THEN
2181: WSH_DEBUG_SV.push(l_module_name);

Line 2181: WSH_DEBUG_SV.push(l_module_name);

2177: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2178: END IF;
2179: --
2180: IF l_debug_on THEN
2181: WSH_DEBUG_SV.push(l_module_name);
2182: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2183: END IF;
2184:
2185: OPEN c_lock_stop;

Line 2182: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);

2178: END IF;
2179: --
2180: IF l_debug_on THEN
2181: WSH_DEBUG_SV.push(l_module_name);
2182: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2183: END IF;
2184:
2185: OPEN c_lock_stop;
2186: FETCH c_lock_stop INTO l_stop_id;

Line 2190: WSH_DEBUG_SV.log(l_module_name,'stop id is locked',l_stop_id);

2186: FETCH c_lock_stop INTO l_stop_id;
2187: CLOSE c_lock_stop;
2188:
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.log(l_module_name,'stop id is locked',l_stop_id);
2191: END IF;
2192:
2193: IF l_debug_on THEN
2194: WSH_DEBUG_SV.pop(l_module_name);

Line 2194: WSH_DEBUG_SV.pop(l_module_name);

2190: WSH_DEBUG_SV.log(l_module_name,'stop id is locked',l_stop_id);
2191: END IF;
2192:
2193: IF l_debug_on THEN
2194: WSH_DEBUG_SV.pop(l_module_name);
2195: END IF;
2196:
2197: EXCEPTION
2198: WHEN app_exception.application_exception

Line 2201: wsh_debug_sv.log(l_module_name, 'Could not lock stop', p_stop_id);

2197: EXCEPTION
2198: WHEN app_exception.application_exception
2199: OR app_exception.record_lock_exception THEN
2200: IF l_debug_on THEN
2201: wsh_debug_sv.log(l_module_name, 'Could not lock stop', p_stop_id);
2202: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');
2203: END IF;
2204: --
2205: RAISE;

Line 2202: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');

2198: WHEN app_exception.application_exception
2199: OR app_exception.record_lock_exception THEN
2200: IF l_debug_on THEN
2201: wsh_debug_sv.log(l_module_name, 'Could not lock stop', p_stop_id);
2202: WSH_DEBUG_SV.pop(l_module_name, 'EXCEPTION:APPLICTION_EXCEPTION');
2203: END IF;
2204: --
2205: RAISE;
2206:

Line 2212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2208: --
2209: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare',l_module_name);
2210: --
2211: IF l_debug_on THEN
2212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2214: END IF;
2215: --
2216: RAISE;

Line 2213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

2209: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare',l_module_name);
2210: --
2211: IF l_debug_on THEN
2212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2214: END IF;
2215: --
2216: RAISE;
2217: END lock_trip_stop_no_compare;

Line 2243: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2239: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2240: --
2241: IF l_debug_on IS NULL
2242: THEN
2243: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2244: END IF;
2245: --
2246: IF l_debug_on THEN
2247: WSH_DEBUG_SV.push(l_module_name);

Line 2247: WSH_DEBUG_SV.push(l_module_name);

2243: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2244: END IF;
2245: --
2246: IF l_debug_on THEN
2247: WSH_DEBUG_SV.push(l_module_name);
2248: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2249: WSH_DEBUG_SV.log(l_module_name,'Total Number of Stop Records being locked',p_valid_index_tab.COUNT);
2250: END IF;
2251: --

Line 2248: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);

2244: END IF;
2245: --
2246: IF l_debug_on THEN
2247: WSH_DEBUG_SV.push(l_module_name);
2248: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2249: WSH_DEBUG_SV.log(l_module_name,'Total Number of Stop Records being locked',p_valid_index_tab.COUNT);
2250: END IF;
2251: --
2252: --

Line 2249: WSH_DEBUG_SV.log(l_module_name,'Total Number of Stop Records being locked',p_valid_index_tab.COUNT);

2245: --
2246: IF l_debug_on THEN
2247: WSH_DEBUG_SV.push(l_module_name);
2248: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2249: WSH_DEBUG_SV.log(l_module_name,'Total Number of Stop Records being locked',p_valid_index_tab.COUNT);
2250: END IF;
2251: --
2252: --
2253: l_index := p_valid_index_tab.FIRST;

Line 2286: WSH_DEBUG_SV.log(l_module_name,'Unable to obtain lock on the Stop Id',p_rec_attr_tab(l_index).stop_id);

2282: END IF;
2283: l_num_errors := l_num_errors + 1;
2284: --
2285: IF l_debug_on THEN
2286: WSH_DEBUG_SV.log(l_module_name,'Unable to obtain lock on the Stop Id',p_rec_attr_tab(l_index).stop_id);
2287: END IF;
2288: --
2289: WHEN others THEN
2290: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2304: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');

2300: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PERFORMED');
2301: x_return_status := wsh_util_core.g_ret_sts_error;
2302: wsh_util_core.add_message(x_return_status,l_module_name);
2303: IF l_debug_on THEN
2304: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PERFORMED');
2305: END IF;
2306: RAISE FND_API.G_EXC_ERROR;
2307: ELSIF l_num_errors > 0 THEN
2308: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');

Line 2312: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');

2308: FND_MESSAGE.SET_NAME('WSH', 'WSH_UI_NOT_PROCESSED');
2309: x_return_status := wsh_util_core.g_ret_sts_warning;
2310: wsh_util_core.add_message(x_return_status,l_module_name);
2311: IF l_debug_on THEN
2312: wsh_debug_sv.logmsg(l_module_name, 'WSH_UI_NOT_PROCESSED');
2313: END IF;
2314: raise wsh_util_core.g_exc_warning;
2315: ELSE
2316: x_return_status := wsh_util_core.g_ret_sts_success;

Line 2320: WSH_DEBUG_SV.pop(l_module_name);

2316: x_return_status := wsh_util_core.g_ret_sts_success;
2317: END IF;
2318: --
2319: IF l_debug_on THEN
2320: WSH_DEBUG_SV.pop(l_module_name);
2321: END IF;
2322: --
2323: EXCEPTION
2324: --

Line 2331: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2327: --
2328: x_return_status := wsh_util_core.g_ret_sts_error;
2329: --
2330: IF l_debug_on THEN
2331: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2333: END IF;
2334: --
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2328: x_return_status := wsh_util_core.g_ret_sts_error;
2329: --
2330: IF l_debug_on THEN
2331: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2333: END IF;
2334: --
2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

Line 2339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2337: --
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2341: END IF;
2342: --
2343: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 2340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2336: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2337: --
2338: IF l_debug_on THEN
2339: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2340: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2341: END IF;
2342: --
2343: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2344: x_return_status := wsh_util_core.g_ret_sts_warning;

Line 2347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2343: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2344: x_return_status := wsh_util_core.g_ret_sts_warning;
2345: --
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2349: END IF;
2350: --
2351: WHEN OTHERS THEN

Line 2348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2344: x_return_status := wsh_util_core.g_ret_sts_warning;
2345: --
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2349: END IF;
2350: --
2351: WHEN OTHERS THEN
2352: --

Line 2358: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2354: --
2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2359: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2360: END IF;
2361: --
2362: END Lock_Trip_Stop;

Line 2359: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2359: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2360: END IF;
2361: --
2362: END Lock_Trip_Stop;
2363:

Line 2397: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2393: --
2394: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2395: --
2396: IF l_debug_on IS NULL THEN
2397: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2398: END IF;
2399: --
2400: IF l_debug_on THEN
2401: WSH_DEBUG_SV.push(l_module_name);

Line 2401: WSH_DEBUG_SV.push(l_module_name);

2397: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2398: END IF;
2399: --
2400: IF l_debug_on THEN
2401: WSH_DEBUG_SV.push(l_module_name);
2402: WSH_DEBUG_SV.log(l_module_name,'STOP_Tab Count',p_stop_id_tab.COUNT);
2403: IF p_stop_id_tab.count > 0 THEN
2404: l_loop_counter := 0;
2405: l_loop_counter := p_stop_id_tab.FIRST;

Line 2402: WSH_DEBUG_SV.log(l_module_name,'STOP_Tab Count',p_stop_id_tab.COUNT);

2398: END IF;
2399: --
2400: IF l_debug_on THEN
2401: WSH_DEBUG_SV.push(l_module_name);
2402: WSH_DEBUG_SV.log(l_module_name,'STOP_Tab Count',p_stop_id_tab.COUNT);
2403: IF p_stop_id_tab.count > 0 THEN
2404: l_loop_counter := 0;
2405: l_loop_counter := p_stop_id_tab.FIRST;
2406: LOOP--{

Line 2407: WSH_DEBUG_SV.log(l_module_name,

2403: IF p_stop_id_tab.count > 0 THEN
2404: l_loop_counter := 0;
2405: l_loop_counter := p_stop_id_tab.FIRST;
2406: LOOP--{
2407: WSH_DEBUG_SV.log(l_module_name,
2408: 'STOP_ID',p_stop_id_tab(l_loop_counter));
2409: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',
2410: p_tms_interface_flag_tab(l_loop_counter));
2411: EXIT WHEN l_loop_counter >= p_stop_id_tab.LAST;

Line 2409: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',

2405: l_loop_counter := p_stop_id_tab.FIRST;
2406: LOOP--{
2407: WSH_DEBUG_SV.log(l_module_name,
2408: 'STOP_ID',p_stop_id_tab(l_loop_counter));
2409: WSH_DEBUG_SV.log(l_module_name,'TMS_INTERFACE_FLAG',
2410: p_tms_interface_flag_tab(l_loop_counter));
2411: EXIT WHEN l_loop_counter >= p_stop_id_tab.LAST;
2412: l_loop_counter := p_stop_id_tab.NEXT(l_loop_counter);
2413: END LOOP;--}

Line 2422: WSH_DEBUG_SV.logmsg(l_module_name,

2418:
2419: IF ((p_stop_id_tab.COUNT <> p_tms_interface_flag_tab.COUNT)
2420: OR (p_stop_id_tab.COUNT=0)) THEN
2421: IF l_debug_on THEN
2422: WSH_DEBUG_SV.logmsg(l_module_name,
2423: 'Stop ID and TMS_interface_flag_tab count does not match');
2424: END IF;
2425: RAISE FND_API.G_EXC_ERROR;
2426: END IF;

Line 2448: WSH_DEBUG_SV.log(l_module_name,

2444: l_loop_counter := 0;
2445: l_loop_counter := p_stop_id_tab.FIRST;
2446: LOOP--{
2447: IF l_debug_on THEN
2448: WSH_DEBUG_SV.log(l_module_name,
2449: 'Calling DBI API.Stop id-',
2450: p_stop_id_tab(l_loop_counter));
2451: END IF;
2452:

Line 2462: WSH_DEBUG_SV.log(l_module_name,

2458: p_dml_type => 'UPDATE',
2459: x_return_status => l_dbi_rs);
2460:
2461: IF l_debug_on THEN
2462: WSH_DEBUG_SV.log(l_module_name,
2463: 'Return Status after DBI Call-',
2464: l_dbi_rs);
2465: END IF;
2466:

Line 2469: WSH_DEBUG_SV.log(l_module_name,

2465: END IF;
2466:
2467: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2468: IF l_debug_on THEN
2469: WSH_DEBUG_SV.log(l_module_name,
2470: 'DBI API Returned Unexpected error '||x_return_status);
2471: END IF;
2472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2473: END IF;

Line 2486: WSH_DEBUG_SV.log(l_module_name,'Return Status'||x_return_status);

2482: --
2483: -- Debug Statements
2484: --
2485: IF l_debug_on THEN
2486: WSH_DEBUG_SV.log(l_module_name,'Return Status'||x_return_status);
2487: WSH_DEBUG_SV.pop(l_module_name);
2488: END IF;
2489: --
2490: EXCEPTION

Line 2487: WSH_DEBUG_SV.pop(l_module_name);

2483: -- Debug Statements
2484: --
2485: IF l_debug_on THEN
2486: WSH_DEBUG_SV.log(l_module_name,'Return Status'||x_return_status);
2487: WSH_DEBUG_SV.pop(l_module_name);
2488: END IF;
2489: --
2490: EXCEPTION
2491: --

Line 2497: WSH_DEBUG_SV.logmsg(l_module_name,

2493: ROLLBACK TO update_tms_interface;
2494: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2495: --
2496: IF l_debug_on THEN
2497: WSH_DEBUG_SV.logmsg(l_module_name,
2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2500: END IF;
2501: --

Line 2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2494: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2495: --
2496: IF l_debug_on THEN
2497: WSH_DEBUG_SV.logmsg(l_module_name,
2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2500: END IF;
2501: --
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2495: --
2496: IF l_debug_on THEN
2497: WSH_DEBUG_SV.logmsg(l_module_name,
2498: 'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2500: END IF;
2501: --
2502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2503: --

Line 2508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2504: ROLLBACK TO update_tms_interface;
2505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2506: --
2507: IF l_debug_on THEN
2508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2510: END IF;
2511: --
2512: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2505: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2506: --
2507: IF l_debug_on THEN
2508: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2510: END IF;
2511: --
2512: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2516: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2512: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2518: END IF;
2519: --
2520:

Line 2517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2514: --
2515: IF l_debug_on THEN
2516: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2518: END IF;
2519: --
2520:
2521: WHEN RECORD_LOCKED THEN

Line 2525: WSH_DEBUG_SV.logmsg(l_module_name,'Record_locked exception has occured. Cannot update stop tms_interface_flag', WSH_DEBUG_SV.C_EXCEP_LEVEL);

2521: WHEN RECORD_LOCKED THEN
2522: ROLLBACK TO update_tms_interface;
2523: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2524: IF l_debug_on THEN
2525: WSH_DEBUG_SV.logmsg(l_module_name,'Record_locked exception has occured. Cannot update stop tms_interface_flag', WSH_DEBUG_SV.C_EXCEP_LEVEL);
2526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
2527: END IF;
2528:
2529: WHEN others THEN

Line 2526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

2522: ROLLBACK TO update_tms_interface;
2523: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2524: IF l_debug_on THEN
2525: WSH_DEBUG_SV.logmsg(l_module_name,'Record_locked exception has occured. Cannot update stop tms_interface_flag', WSH_DEBUG_SV.C_EXCEP_LEVEL);
2526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
2527: END IF;
2528:
2529: WHEN others THEN
2530: ROLLBACK TO update_tms_interface;

Line 2538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2534: --
2535: -- Debug Statements
2536: --
2537: IF l_debug_on THEN
2538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2540: END IF;
2541: --
2542: END UPDATE_TMS_INTERFACE_FLAG;

Line 2539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

2535: -- Debug Statements
2536: --
2537: IF l_debug_on THEN
2538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2540: END IF;
2541: --
2542: END UPDATE_TMS_INTERFACE_FLAG;
2543: