71: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
72: --
73: IF l_debug_on IS NULL
74: THEN
75: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
76: END IF;
77: --
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);
75: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
76: END IF;
77: --
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);
80: --
81: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
82: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
83: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
77: --
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);
80: --
81: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
82: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
83: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
84: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
78: IF l_debug_on THEN
79: WSH_DEBUG_SV.push(l_module_name);
80: --
81: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
82: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
83: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
84: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
79: WSH_DEBUG_SV.push(l_module_name);
80: --
81: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
82: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
83: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
84: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
80: --
81: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
82: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
83: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
84: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
81: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
82: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
83: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
84: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
82: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
83: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
84: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
83: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
84: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
84: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
92: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
85: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
92: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
93: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
86: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
92: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
93: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
94: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
87: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
92: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
93: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
94: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
95: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
88: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
92: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
93: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
94: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
95: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
96: END IF;
89: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
92: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
93: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
94: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
95: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
96: END IF;
97: --
90: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
92: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
93: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
94: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
95: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
96: END IF;
97: --
98: IF NOT FND_API.Compatible_API_Call
91: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
92: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
93: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
94: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
95: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
96: END IF;
97: --
98: IF NOT FND_API.Compatible_API_Call
99: ( l_api_version_number
144: ,p_encoded => FND_API.G_FALSE
145: );
146: --
147: IF l_debug_on THEN
148: WSH_DEBUG_SV.pop(l_module_name);
149: END IF;
150: --
151: EXCEPTION
152:
153: WHEN trip_action_error THEN
154: FND_MESSAGE.SET_NAME('WSH','WSH_OI_TRIP_ACTION_ERROR');
155: --
156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
158: END IF;
159: --
160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
161: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_trip_IN_rec.action_code));
161: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_trip_IN_rec.action_code));
162: wsh_util_core.add_message(x_return_status);
163:
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_ACTION_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRIP_ACTION_ERROR');
167: END IF;
168: --
169: WHEN FND_API.G_EXC_ERROR THEN
162: wsh_util_core.add_message(x_return_status);
163:
164: IF l_debug_on THEN
165: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_ACTION_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
166: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRIP_ACTION_ERROR');
167: END IF;
168: --
169: WHEN FND_API.G_EXC_ERROR THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
174: , p_data => x_msg_data
175: );
176:
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
180: END IF;
181: --
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
175: );
176:
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
180: END IF;
181: --
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: ( p_count => x_msg_count
187: , p_data => x_msg_data
188: );
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
192: END IF;
193: --
194: WHEN OTHERS THEN
187: , p_data => x_msg_data
188: );
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
191: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
192: END IF;
193: --
194: WHEN OTHERS THEN
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
206: , p_data => x_msg_data
207: );
208:
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
211: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
212: END IF;
213: --
214: END Trip_Action_New;
207: );
208:
209: IF l_debug_on THEN
210: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
211: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
212: END IF;
213: --
214: END Trip_Action_New;
215: /*** OLD VERSIONS **/
275: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
276: --
277: IF l_debug_on IS NULL
278: THEN
279: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
280: END IF;
281: --
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.push(l_module_name);
279: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
280: END IF;
281: --
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.push(l_module_name);
284: --
285: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
286: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
287: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
281: --
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.push(l_module_name);
284: --
285: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
286: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
287: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
288: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
282: IF l_debug_on THEN
283: WSH_DEBUG_SV.push(l_module_name);
284: --
285: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
286: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
287: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
288: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
290: WSH_DEBUG_SV.log(l_module_name,'P_WV_OVERRIDE_FLAG',P_WV_OVERRIDE_FLAG);
283: WSH_DEBUG_SV.push(l_module_name);
284: --
285: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
286: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
287: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
288: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
290: WSH_DEBUG_SV.log(l_module_name,'P_WV_OVERRIDE_FLAG',P_WV_OVERRIDE_FLAG);
291: END IF;
284: --
285: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
286: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
287: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
288: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
290: WSH_DEBUG_SV.log(l_module_name,'P_WV_OVERRIDE_FLAG',P_WV_OVERRIDE_FLAG);
291: END IF;
292: --
285: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
286: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
287: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
288: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
290: WSH_DEBUG_SV.log(l_module_name,'P_WV_OVERRIDE_FLAG',P_WV_OVERRIDE_FLAG);
291: END IF;
292: --
293: IF NOT FND_API.Compatible_API_Call
286: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
287: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
288: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
289: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
290: WSH_DEBUG_SV.log(l_module_name,'P_WV_OVERRIDE_FLAG',P_WV_OVERRIDE_FLAG);
291: END IF;
292: --
293: IF NOT FND_API.Compatible_API_Call
294: ( l_api_version_number
305: FND_MSG_PUB.initialize;
306: END IF;
307:
308: IF l_debug_on THEN
309: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
310: END IF;
311: --
312: wsh_util_validate.validate_trip_name( l_trip_id, p_trip_name, x_return_status);
313:
337: ,p_encoded => FND_API.G_FALSE
338: );
339: --
340: IF l_debug_on THEN
341: WSH_DEBUG_SV.pop(l_module_name);
342: END IF;
343: --
344: EXCEPTION
345:
348: --
349: -- Debug Statements
350: --
351: IF l_debug_on THEN
352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
353: END IF;
354: --
355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
356: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));
359: --
360: -- Debug Statements
361: --
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_ACTION_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
364: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRIP_ACTION_ERROR');
365: END IF;
366: --
367: WHEN FND_API.G_EXC_ERROR THEN
360: -- Debug Statements
361: --
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_ACTION_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
364: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:TRIP_ACTION_ERROR');
365: END IF;
366: --
367: WHEN FND_API.G_EXC_ERROR THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
376: --
377: -- Debug Statements
378: --
379: IF l_debug_on THEN
380: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
381: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
382: END IF;
383: --
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: -- Debug Statements
378: --
379: IF l_debug_on THEN
380: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
381: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
382: END IF;
383: --
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: --
394: -- Debug Statements
395: --
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
399: END IF;
400: --
401: WHEN OTHERS THEN
394: -- Debug Statements
395: --
396: IF l_debug_on THEN
397: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
399: END IF;
400: --
401: WHEN OTHERS THEN
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417: --
418: -- Debug Statements
419: --
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
423: END IF;
424: --
425: END Trip_Action;
418: -- Debug Statements
419: --
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
423: END IF;
424: --
425: END Trip_Action;
426:
562: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
563: --
564: IF l_debug_on IS NULL
565: THEN
566: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
567: END IF;
568: --
569: SAVEPOINT s_trip_action_grp;
570:
568: --
569: SAVEPOINT s_trip_action_grp;
570:
571: IF l_debug_on THEN
572: wsh_debug_sv.push (l_module_name);
573: wsh_debug_sv.log (l_module_name,'p_api_version_number',
574: p_api_version_number);
575: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
576: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
569: SAVEPOINT s_trip_action_grp;
570:
571: IF l_debug_on THEN
572: wsh_debug_sv.push (l_module_name);
573: wsh_debug_sv.log (l_module_name,'p_api_version_number',
574: p_api_version_number);
575: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
576: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
577: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
571: IF l_debug_on THEN
572: wsh_debug_sv.push (l_module_name);
573: wsh_debug_sv.log (l_module_name,'p_api_version_number',
574: p_api_version_number);
575: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
576: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
577: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
578: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
579: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
572: wsh_debug_sv.push (l_module_name);
573: wsh_debug_sv.log (l_module_name,'p_api_version_number',
574: p_api_version_number);
575: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
576: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
577: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
578: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
579: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
580: END IF;
573: wsh_debug_sv.log (l_module_name,'p_api_version_number',
574: p_api_version_number);
575: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
576: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
577: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
578: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
579: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
580: END IF;
581:
574: p_api_version_number);
575: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
576: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
577: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
578: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
579: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
580: END IF;
581:
582: IF FND_API.to_Boolean(p_init_msg_list) THEN
575: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
576: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
577: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
578: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
579: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
580: END IF;
581:
582: IF FND_API.to_Boolean(p_init_msg_list) THEN
583: FND_MSG_PUB.initialize;
615: IF p_action_prms.action_code = 'GENERATE-ROUTING-RESPONSE'
616: THEN
617: --{
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.generateRoutingResponse',WSH_DEBUG_SV.C_PROC_LEVEL);
620: END IF;
621: --
622: WSH_TRIPS_ACTIONS.generateRoutingResponse
623: (
627: );
628: --
629: --
630: IF l_debug_on THEN
631: wsh_debug_sv.log(l_module_name,'Return Status After Calling generate_routing_response',l_return_status);
632: END IF;
633: --
634: wsh_util_core.api_post_call(
635: p_return_status => l_return_status,
658:
659: --OTM R12, glog proj
660: l_trip_rec_tab(l_index).ignore_for_planning := p_rec_attr_tab(l_index).ignore_for_planning;
661: IF l_debug_on THEN
662: wsh_debug_sv.log (l_module_name,'trip_id',
663: p_rec_attr_tab(l_index).trip_id);
664: wsh_debug_sv.log (l_module_name,'status_code',
665: p_rec_attr_tab(l_index).status_code);
666: END IF;
660: l_trip_rec_tab(l_index).ignore_for_planning := p_rec_attr_tab(l_index).ignore_for_planning;
661: IF l_debug_on THEN
662: wsh_debug_sv.log (l_module_name,'trip_id',
663: p_rec_attr_tab(l_index).trip_id);
664: wsh_debug_sv.log (l_module_name,'status_code',
665: p_rec_attr_tab(l_index).status_code);
666: END IF;
667: l_index := p_rec_attr_tab.NEXT(l_index);
668: END LOOP;
746: wsh_util_core.add_message(x_return_status,l_module_name);
747: END IF;
748: --
749: IF l_debug_on THEN
750: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION');
751: END IF;
752: --
753: RAISE FND_API.G_EXC_ERROR;
754: --
754: --
755: END IF;
756:
757: IF l_debug_on THEN
758: wsh_debug_sv.log (l_module_name,'l_num_warning',l_num_warning);
759: END IF;
760:
761:
762: IF l_num_warning > 0 AND p_action_prms.caller = 'WSH_FSTRX' THEN
769: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION_WARN');
770: wsh_util_core.add_message(x_return_status,l_module_name);
771: --
772: IF l_debug_on THEN
773: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION_WARN');
774: END IF;
775: --
776: IF p_action_prms.caller = 'WSH_FSTRX' THEN
777: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
783:
784: l_trip_id := p_rec_attr_tab(p_rec_attr_tab.FIRST).trip_id;
785:
786: IF l_debug_on THEN
787: wsh_debug_sv.log (l_module_name,'l_trip_id', l_trip_id);
788: END IF;
789:
790: IF p_action_prms.action_code in ('PRINT-DOC-SETS', 'TRIP-CONFIRM')
791: AND nvl(p_action_prms.phase,1) = 1
798: --
799: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
800: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
801: IF l_debug_on THEN
802: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
803: END IF;
804:
805:
806: WSH_UTIL_CORE.reset_stops_for_load_tender(
806: WSH_UTIL_CORE.reset_stops_for_load_tender(
807: p_reset_flags => TRUE,
808: x_return_status => l_return_status);
809: IF l_debug_on THEN
810: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
811: END IF;
812: -- x_return_status is set to Success already, so
813: -- it will get the value for l_return_status
814: x_return_status := l_return_status;
821:
822:
823:
824: IF l_debug_on THEN
825: wsh_debug_sv.log (l_module_name,'C_TRIP_STOP_VALIDATION_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL));
826: END IF;
827:
828: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 )
829: AND ( p_action_prms.action_code IN ( 'FIRM', 'PLAN' , 'UNPLAN'))
856: EXCEPTION
857: WHEN FND_API.G_EXC_ERROR THEN
858: ROLLBACK TO s_clean_loop_grp;
859: IF l_debug_on THEN
860: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR in the loop');
861: END IF;
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: ROLLBACK TO s_clean_loop_grp;
864: IF l_debug_on THEN
861: END IF;
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: ROLLBACK TO s_clean_loop_grp;
864: IF l_debug_on THEN
865: wsh_debug_sv.log (l_module_name,
866: 'G_EXC_UNEXPECTED_ERROR in the loop');
867: END IF;
868: END;
869: END LOOP;
869: END LOOP;
870:
871: IF l_num_errors >= l_trip_id_tab.COUNT THEN
872: IF l_debug_on THEN
873: wsh_debug_sv.log (l_module_name,'All failed in the loop');
874: END IF;
875: RAISE FND_API.G_EXC_ERROR;
876: END IF;
877:
876: END IF;
877:
878: IF l_num_errors >0 THEN
879: IF l_debug_on THEN
880: wsh_debug_sv.log (l_module_name,'l_num_errors',l_num_errors);
881:
882: END IF;
883: l_num_warning := l_num_warning + l_num_errors;
884: l_num_errors := 0;
908: p_action_code => p_action_prms.action_code,
909: x_return_status => l_return_status);
910: --
911: IF l_debug_on THEN
912: wsh_debug_sv.log(l_module_name,'Return Status After Calling change_ignoreplan_status ',l_return_status);
913: END IF;
914: --
915: wsh_util_core.api_post_call(
916: p_return_status => l_return_status,
966: IF l_report_set_id IS NULL THEN
967: FND_MESSAGE.SET_NAME('WSH','WSH_DOC_MISSING');
968: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
969: IF l_debug_on THEN
970: wsh_debug_sv.log (l_module_name,'WSH_DOC_MISSING');
971: END IF;
972: RAISE FND_API.G_EXC_ERROR;
973: END IF;
974: WSH_UTIL_VALIDATE.validate_report_set(
1043: --bms set the message given in DLD
1044: FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');
1045: FND_MSG_PUB.ADD;
1046: IF l_debug_on THEN
1047: wsh_debug_sv.log (l_module_name,'WSH_UI_MULTI_SELECTION');
1048: END IF;
1049: RAISE FND_API.G_EXC_ERROR;
1050: ELSIF p_rec_attr_tab.COUNT = 1
1051: AND p_action_prms.caller <> 'WSH_FSTRX' THEN
1052: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
1053: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
1054: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1055: IF l_debug_on THEN
1056: wsh_debug_sv.log (l_module_name,'WSH_INVALID_ACTION_CODE COUNT');
1057: END IF;
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060: -- Modified by 4493263
1098: x_msg_data => l_msg_data);
1099: --
1100: --
1101: IF l_debug_on THEN
1102: wsh_debug_sv.log(l_module_name,'Return Status After Calling delivery_action',l_return_status);
1103: END IF;
1104:
1105: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1106: x_num_warnings =>l_num_warning,
1147: x_msg_data => l_msg_data);
1148: --
1149: --
1150: IF l_debug_on THEN
1151: wsh_debug_sv.log(l_module_name,'Return Status After Calling delivery_action',l_return_status);
1152: END IF;
1153:
1154:
1155: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1168: FETCH c_mbol_doc_set into l_doc_set_id;
1169: CLOSE c_mbol_doc_set;
1170:
1171: IF l_debug_on THEN
1172: wsh_debug_sv.log (l_module_name,'l_doc_set_id is', l_doc_set_id);
1173: END IF;
1174:
1175: FOR i IN l_trip_id_tab.FIRST..l_trip_id_tab.last LOOP
1176:
1190:
1191: END LOOP;
1192:
1193: IF l_debug_on THEN
1194: wsh_debug_sv.log (l_module_name,'l_pmbol_trip_id_tab.COUNT is', l_pmbol_trip_id_tab.COUNT );
1195: END IF;
1196: --Bug 4494236 : call Print doc set only if l_pmbol_trip_id_tab.count is > 0
1197:
1198: IF ( l_doc_set_id IS NOT NULL AND l_pmbol_trip_id_tab.COUNT > 0 ) THEN
1237: x_return_status := wsh_util_core.g_ret_sts_error;
1238: wsh_util_core.add_message(x_return_status,l_module_name);
1239: --FND_MSG_PUB.ADD;
1240: IF l_debug_on THEN
1241: wsh_debug_sv.log (l_module_name,'WSH_UI_MULTI_SELECTION');
1242: END IF;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245:
1259: FND_MESSAGE.SET_NAME('WSH', 'FTE_NOT_INSTALLED');
1260: x_return_status := wsh_util_core.g_ret_sts_error;
1261: wsh_util_core.add_message(x_return_status,l_module_name);
1262: IF l_debug_on THEN
1263: wsh_debug_sv.logmsg(l_module_name,'FTE_NOT_INSTALLED');
1264: END IF;
1265: RAISE FND_API.G_EXC_ERROR;
1266: END IF;
1267:
1285: p_caller => p_action_prms.caller,
1286: x_return_status => l_return_status);
1287:
1288: IF l_debug_on THEN
1289: wsh_debug_sv.log(l_module_name,'Return Status After Calling Remove_Consolidation',l_return_status);
1290: END IF;
1291: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1292: x_num_warnings =>l_num_warning,
1293: x_num_errors =>l_num_errors);
1298: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
1299: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
1300: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1301: IF l_debug_on THEN
1302: wsh_debug_sv.log (l_module_name,'WSH_INVALID_ACTION_CODE');
1303: END IF;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306:
1316: p_action_prms => p_action_prms,
1317: p_rec_attr_tab => p_rec_attr_tab);
1318:
1319: IF l_debug_on THEN
1320: WSH_DEBUG_SV.log(l_module_name,'after calling trip_callback l_return_status',l_return_status);
1321: END IF;
1322:
1323: wsh_util_core.api_post_call(
1324: p_return_status => l_return_status,
1347: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1348: THEN
1349: --{
1350: IF l_debug_on THEN
1351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1352: END IF;
1353:
1354: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1355: (
1359: );
1360: --
1361: --
1362: IF l_debug_on THEN
1363: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1364: END IF;
1365: --
1366: --
1367: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1381: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1382: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1383:
1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1386: END IF;
1387:
1388: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
1389: x_return_status => l_return_status);
1388: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
1389: x_return_status => l_return_status);
1390:
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1393: END IF;
1394: -- The x_return_status at this point is either success or warning
1395: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1396: x_return_status := l_return_status;
1417:
1418: IF p_commit = FND_API.G_TRUE THEN
1419:
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1422: END IF;
1423: WSH_UTIL_CORE.reset_stops_for_load_tender(
1424: p_reset_flags => TRUE,
1425: x_return_status => l_return_status);
1425: x_return_status => l_return_status);
1426: ELSE
1427:
1428: IF l_debug_on THEN
1429: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1430: END IF;
1431: WSH_UTIL_CORE.Process_stops_for_load_tender(
1432: p_reset_flags => TRUE,
1433: x_return_status => l_return_status);
1433: x_return_status => l_return_status);
1434: END IF;
1435:
1436: IF l_debug_on THEN
1437: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1438: END IF;
1439:
1440: --
1441: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1475: ,p_encoded => FND_API.G_FALSE
1476: );
1477:
1478: IF l_debug_on THEN
1479: WSH_DEBUG_SV.pop(l_module_name);
1480: END IF;
1481: -- J-IB-NPARIKH-}
1482:
1483: WHEN e_req_field THEN
1490: --
1491: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1492: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1493: IF l_debug_on THEN
1494: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1495: END IF;
1496:
1497: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1498: x_return_status => l_return_status);
1498: x_return_status => l_return_status);
1499:
1500:
1501: IF l_debug_on THEN
1502: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1503: END IF;
1504: IF l_return_status =
1505: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1506: x_return_status := l_return_status;
1516: , p_data => x_msg_data
1517: ,p_encoded => FND_API.G_FALSE
1518: );
1519: IF l_debug_on THEN
1520: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1521: WSH_DEBUG_SV.pop(l_module_name);
1522: END IF;
1523:
1524:
1517: ,p_encoded => FND_API.G_FALSE
1518: );
1519: IF l_debug_on THEN
1520: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1521: WSH_DEBUG_SV.pop(l_module_name);
1522: END IF;
1523:
1524:
1525: WHEN FND_API.G_EXC_ERROR THEN
1531: --
1532: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1533: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1534: IF l_debug_on THEN
1535: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1536: END IF;
1537:
1538: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1539: x_return_status => l_return_status);
1539: x_return_status => l_return_status);
1540:
1541:
1542: IF l_debug_on THEN
1543: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1544: END IF;
1545:
1546: IF l_return_status =
1547: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1558: ,p_encoded => FND_API.G_FALSE
1559: );
1560:
1561: IF l_debug_on THEN
1562: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1563: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1564: WSH_DEBUG_SV.pop(l_module_name);
1565: END IF;
1566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1559: );
1560:
1561: IF l_debug_on THEN
1562: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1563: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1564: WSH_DEBUG_SV.pop(l_module_name);
1565: END IF;
1566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1567: ROLLBACK TO s_trip_action_grp;
1560:
1561: IF l_debug_on THEN
1562: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
1563: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1564: WSH_DEBUG_SV.pop(l_module_name);
1565: END IF;
1566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1567: ROLLBACK TO s_trip_action_grp;
1568: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1572: --
1573: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1574: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1575: IF l_debug_on THEN
1576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1577: END IF;
1578:
1579: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1580: x_return_status => l_return_status);
1580: x_return_status => l_return_status);
1581:
1582:
1583: IF l_debug_on THEN
1584: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1585: END IF;
1586:
1587: END IF;
1588: END IF;
1596: ,p_encoded => FND_API.G_FALSE
1597: );
1598:
1599: IF l_debug_on THEN
1600: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1601: WSH_DEBUG_SV.pop(l_module_name);
1602: END IF;
1603: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1604: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1597: );
1598:
1599: IF l_debug_on THEN
1600: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1601: WSH_DEBUG_SV.pop(l_module_name);
1602: END IF;
1603: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1604: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1605: --
1608: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1609: THEN
1610: --{
1611: IF l_debug_on THEN
1612: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1613: END IF;
1614:
1615: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1616: (
1620: );
1621: --
1622: --
1623: IF l_debug_on THEN
1624: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1625: END IF;
1626: --
1627: --
1628: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1640: --
1641: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1642: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1643: IF l_debug_on THEN
1644: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1645: END IF;
1646:
1647: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1648: x_return_status => l_return_status);
1647: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1648: x_return_status => l_return_status);
1649:
1650: IF l_debug_on THEN
1651: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1652: END IF;
1653: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1654: THEN
1655: x_return_status := l_return_status;
1671: ,p_encoded => FND_API.G_FALSE
1672: );
1673:
1674: IF l_debug_on THEN
1675: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1676: WSH_DEBUG_SV.pop(l_module_name);
1677: END IF;
1678: WHEN OTHERS THEN
1679: ROLLBACK TO s_trip_action_grp;
1672: );
1673:
1674: IF l_debug_on THEN
1675: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1676: WSH_DEBUG_SV.pop(l_module_name);
1677: END IF;
1678: WHEN OTHERS THEN
1679: ROLLBACK TO s_trip_action_grp;
1680: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1688: --
1689: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1690: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1691: IF l_debug_on THEN
1692: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1693: END IF;
1694:
1695: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1696: x_return_status => l_return_status);
1696: x_return_status => l_return_status);
1697:
1698:
1699: IF l_debug_on THEN
1700: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1701: END IF;
1702:
1703: END IF;
1704: END IF;
1712: , p_data => x_msg_data
1713: ,p_encoded => FND_API.G_FALSE
1714: );
1715: IF l_debug_on THEN
1716: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
1717: WSH_DEBUG_SV.pop(l_module_name);
1718: END IF;
1719:
1720: END Trip_Action;
1713: ,p_encoded => FND_API.G_FALSE
1714: );
1715: IF l_debug_on THEN
1716: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
1717: WSH_DEBUG_SV.pop(l_module_name);
1718: END IF;
1719:
1720: END Trip_Action;
1721:
1734: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1735: --
1736: IF l_debug_on IS NULL
1737: THEN
1738: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1739: END IF;
1740: --
1741: IF l_debug_on THEN
1742: WSH_DEBUG_SV.push(l_module_name);
1738: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1739: END IF;
1740: --
1741: IF l_debug_on THEN
1742: WSH_DEBUG_SV.push(l_module_name);
1743: WSH_DEBUG_SV.log(l_module_name,'p_grp_trip_rec.TRIP_ID',p_grp_trip_rec.TRIP_ID);
1744: WSH_DEBUG_SV.log(l_module_name,'p_grp_trip_rec.NAME',p_grp_trip_rec.NAME);
1745: END IF;
1746: --
1739: END IF;
1740: --
1741: IF l_debug_on THEN
1742: WSH_DEBUG_SV.push(l_module_name);
1743: WSH_DEBUG_SV.log(l_module_name,'p_grp_trip_rec.TRIP_ID',p_grp_trip_rec.TRIP_ID);
1744: WSH_DEBUG_SV.log(l_module_name,'p_grp_trip_rec.NAME',p_grp_trip_rec.NAME);
1745: END IF;
1746: --
1747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1740: --
1741: IF l_debug_on THEN
1742: WSH_DEBUG_SV.push(l_module_name);
1743: WSH_DEBUG_SV.log(l_module_name,'p_grp_trip_rec.TRIP_ID',p_grp_trip_rec.TRIP_ID);
1744: WSH_DEBUG_SV.log(l_module_name,'p_grp_trip_rec.NAME',p_grp_trip_rec.NAME);
1745: END IF;
1746: --
1747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1748:
1800: x_pvt_trip_rec.CARRIER_REFERENCE_NUMBER := p_grp_trip_rec.CARRIER_REFERENCE_NUMBER;
1801: x_pvt_trip_rec.CONSIGNEE_CARRIER_AC_NO := p_grp_trip_rec.CONSIGNEE_CARRIER_AC_NO;
1802:
1803: IF l_debug_on THEN
1804: WSH_DEBUG_SV.pop(l_module_name);
1805: END IF;
1806: --
1807: EXCEPTION
1808: WHEN OTHERS THEN
1809: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_tripgrp_to_pvt',l_module_name);
1810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1811: --
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1815: END IF;
1816: --
1817: END map_tripgrp_to_pvt;
1810: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1811: --
1812: IF l_debug_on THEN
1813: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1814: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1815: END IF;
1816: --
1817: END map_tripgrp_to_pvt;
1818:
1862: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1863: --
1864: IF l_debug_on IS NULL
1865: THEN
1866: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1867: END IF;
1868: --
1869:
1870: --OTM R12, glog proj
1879: -- end of OTM R12, glog proj
1880:
1881: SAVEPOINT validate_trip_grp;
1882: IF l_debug_on THEN
1883: wsh_debug_sv.push(l_module_name);
1884: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code );
1885: END IF;
1886:
1887:
1880:
1881: SAVEPOINT validate_trip_grp;
1882: IF l_debug_on THEN
1883: wsh_debug_sv.push(l_module_name);
1884: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code );
1885: END IF;
1886:
1887:
1888: l_index := p_trip_info_tab.FIRST;
1888: l_index := p_trip_info_tab.FIRST;
1889: WHILE l_index IS NOT NULL LOOP
1890: BEGIN
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1893: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_info_tab(l_index).trip_id);
1894: WSH_DEBUG_SV.log(l_module_name,'name',p_trip_info_tab(l_index).name);
1895: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id',p_trip_info_tab(l_index).arrive_after_trip_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1889: WHILE l_index IS NOT NULL LOOP
1890: BEGIN
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1893: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_info_tab(l_index).trip_id);
1894: WSH_DEBUG_SV.log(l_module_name,'name',p_trip_info_tab(l_index).name);
1895: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id',p_trip_info_tab(l_index).arrive_after_trip_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1890: BEGIN
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1893: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_info_tab(l_index).trip_id);
1894: WSH_DEBUG_SV.log(l_module_name,'name',p_trip_info_tab(l_index).name);
1895: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id',p_trip_info_tab(l_index).arrive_after_trip_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1891: IF l_debug_on THEN
1892: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1893: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_info_tab(l_index).trip_id);
1894: WSH_DEBUG_SV.log(l_module_name,'name',p_trip_info_tab(l_index).name);
1895: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id',p_trip_info_tab(l_index).arrive_after_trip_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1892: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
1893: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_info_tab(l_index).trip_id);
1894: WSH_DEBUG_SV.log(l_module_name,'name',p_trip_info_tab(l_index).name);
1895: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id',p_trip_info_tab(l_index).arrive_after_trip_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1893: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_info_tab(l_index).trip_id);
1894: WSH_DEBUG_SV.log(l_module_name,'name',p_trip_info_tab(l_index).name);
1895: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id',p_trip_info_tab(l_index).arrive_after_trip_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1894: WSH_DEBUG_SV.log(l_module_name,'name',p_trip_info_tab(l_index).name);
1895: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id',p_trip_info_tab(l_index).arrive_after_trip_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1902: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_code',p_trip_info_tab(l_index).vehicle_organization_code);
1895: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_id',p_trip_info_tab(l_index).arrive_after_trip_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1902: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_code',p_trip_info_tab(l_index).vehicle_organization_code);
1903: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id',p_trip_info_tab(l_index).vehicle_item_id);
1896: WSH_DEBUG_SV.log(l_module_name,'arrive_after_trip_name',p_trip_info_tab(l_index).arrive_after_trip_name);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1902: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_code',p_trip_info_tab(l_index).vehicle_organization_code);
1903: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id',p_trip_info_tab(l_index).vehicle_item_id);
1904: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed',p_trip_info_tab(l_index).consolidation_allowed);
1897: WSH_DEBUG_SV.log(l_module_name,'ship_method_name',p_trip_info_tab(l_index).ship_method_name);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1902: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_code',p_trip_info_tab(l_index).vehicle_organization_code);
1903: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id',p_trip_info_tab(l_index).vehicle_item_id);
1904: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed',p_trip_info_tab(l_index).consolidation_allowed);
1905: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code',p_trip_info_tab(l_index).freight_Terms_code);
1898: WSH_DEBUG_SV.log(l_module_name,'ship_method_code',p_trip_info_tab(l_index).ship_method_code);
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1902: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_code',p_trip_info_tab(l_index).vehicle_organization_code);
1903: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id',p_trip_info_tab(l_index).vehicle_item_id);
1904: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed',p_trip_info_tab(l_index).consolidation_allowed);
1905: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code',p_trip_info_tab(l_index).freight_Terms_code);
1906: END IF;
1899: WSH_DEBUG_SV.log(l_module_name,'carrier_id',p_trip_info_tab(l_index).carrier_id);
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1902: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_code',p_trip_info_tab(l_index).vehicle_organization_code);
1903: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id',p_trip_info_tab(l_index).vehicle_item_id);
1904: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed',p_trip_info_tab(l_index).consolidation_allowed);
1905: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code',p_trip_info_tab(l_index).freight_Terms_code);
1906: END IF;
1907:
1900: WSH_DEBUG_SV.log(l_module_name,'mode_of_transport',p_trip_info_tab(l_index).mode_of_transport);
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1902: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_code',p_trip_info_tab(l_index).vehicle_organization_code);
1903: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id',p_trip_info_tab(l_index).vehicle_item_id);
1904: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed',p_trip_info_tab(l_index).consolidation_allowed);
1905: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code',p_trip_info_tab(l_index).freight_Terms_code);
1906: END IF;
1907:
1908: SAVEPOINT validate_trip_loop_grp;
1901: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_id',p_trip_info_tab(l_index).vehicle_organization_id);
1902: WSH_DEBUG_SV.log(l_module_name,'vehicle_organization_code',p_trip_info_tab(l_index).vehicle_organization_code);
1903: WSH_DEBUG_SV.log(l_module_name,'vehicle_item_id',p_trip_info_tab(l_index).vehicle_item_id);
1904: WSH_DEBUG_SV.log(l_module_name,'consolidation_allowed',p_trip_info_tab(l_index).consolidation_allowed);
1905: WSH_DEBUG_SV.log(l_module_name,'freight_terms_code',p_trip_info_tab(l_index).freight_Terms_code);
1906: END IF;
1907:
1908: SAVEPOINT validate_trip_loop_grp;
1909:
1958: p_trip_id => p_trip_info_tab(l_index).trip_id,
1959: p_trip_name => l_dummy,
1960: x_return_status => l_return_status);
1961: IF l_debug_on THEN
1962: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_Name l_return_status',l_return_status);
1963: END IF;
1964: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1965: x_num_warnings =>l_num_warnings,
1966: x_num_errors =>l_num_errors);
1972: p_arr_after_trip_id => p_trip_info_tab(l_index).arrive_after_trip_id,
1973: p_arr_after_trip_name => p_trip_info_tab(l_index).arrive_after_trip_name,
1974: x_return_status => l_return_status);
1975: IF l_debug_on THEN
1976: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_VALIDATIONS.Validate_Arrive_after_trip l_return_status',
1977: l_return_status);
1978: END IF;
1979: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1980: x_num_warnings =>l_num_warnings,
1995: x_return_status => l_return_status,
1996: p_caller => p_caller);
1997:
1998: IF l_debug_on THEN
1999: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Freight_Carrier l_return_status',l_return_status);
2000: END IF;
2001:
2002: -- OTM R12, glog project
2003: -- To handle the warning about Invalid Ship Method when the
2008: IF (l_gc3_is_installed = 'Y' AND
2009: p_caller = 'FTE_TMS_INTEGRATION' AND
2010: l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2011: IF l_debug_on THEN
2012: WSH_DEBUG_SV.log(l_module_name,'Convert l_return_status',l_return_status);
2013: END IF;
2014: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2015: END IF;
2016: -- OTM R12, end of glog project
2028: ,p_new_ship_method_code => p_trip_info_tab(l_index).ship_method_code
2029: ,x_return_status => l_return_status );
2030:
2031: IF l_debug_on THEN
2032: WSH_DEBUG_SV.log(l_module_name,'WSH_BOLS_PVT.cancel_bol l_return_status',l_return_status);
2033: END IF;
2034: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2035: x_num_warnings =>l_num_warnings,
2036: x_num_errors =>l_num_errors);
2038: ( p_trip_id => p_trip_info_tab(l_index).trip_id
2039: ,x_return_status => l_return_status );
2040:
2041: IF l_debug_on THEN
2042: WSH_DEBUG_SV.log(l_module_name,'WSH_MBOLS_PVT.cancel_mbol l_return_status',l_return_status);
2043: END IF;
2044: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2045: x_num_warnings =>l_num_warnings,
2046: x_num_errors =>l_num_errors);
2054: p_freight_terms_name => NULL,
2055: x_return_status => l_return_status);
2056: --
2057: IF l_debug_on THEN
2058: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_freight_terms',l_return_status);
2059: END IF;
2060: --
2061: WSH_UTIL_CORE.api_post_call(
2062: p_return_status => l_return_status,
2097:
2098: END IF;
2099:
2100: IF l_debug_on THEN
2101: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_item -vehicle l_return_status',l_return_status);
2102: END IF;
2103: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2104: x_num_warnings =>l_num_warnings,
2105: x_num_errors =>l_num_errors);
2121: p_org_id => p_trip_info_tab(l_index).vehicle_organization_id,
2122: p_org_code => p_trip_info_tab(l_index).vehicle_organization_code,
2123: x_return_status => l_return_status);
2124: IF l_debug_on THEN
2125: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_org l_return_status',l_return_status);
2126: END IF;
2127: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2128: x_num_warnings =>l_num_warnings,
2129: x_num_errors =>l_num_errors);
2142:
2143:
2144: IF (p_trip_info_tab(l_index).vehicle_item_id IS NOT NULL) THEN
2145: IF l_debug_on THEN
2146: wsh_debug_sv.logmsg(l_module_name, 'calling get_vehicle_org_id');
2147: END IF;
2148:
2149: WSH_FTE_INTEGRATION.GET_VEHICLE_ORG_ID
2150: (p_inventory_item_id => p_trip_info_tab(l_index).vehicle_item_id,
2176: l_vehicle_org_id:=l_dummy_master_org_id;
2177: END IF;
2178:
2179: IF l_debug_on THEN
2180: WSH_DEBUG_SV.log(l_module_name,'vehicle org passed in: '|| p_trip_info_tab(l_index).vehicle_organization_id||' master org: '|| l_dummy_master_org_id||' vehicle org found: '||l_vehicle_org_id);
2181: END IF;
2182:
2183: --bug 3437995 - if master org is not passed, do not error out, get
2184: --the master org and populate vehicle org with that
2197: p_ship_method_code => p_trip_info_tab(l_index).ship_method_code,
2198: p_ship_method_name => l_dummy,
2199: x_return_status => l_return_status);
2200: IF l_debug_on THEN
2201: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_ship_method l_return_status',l_return_status);
2202: END IF;
2203: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2204: x_num_warnings =>l_num_warnings,
2205: x_num_errors =>l_num_errors);
2210: p_trip_info => p_trip_info_tab(l_index),
2211: p_db_trip_info => l_db_trip_info,
2212: x_return_status => l_return_status);
2213: IF l_debug_on THEN
2214: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_VALIDATIONS.Validate_Consol_Allowed l_return_status',l_return_status);
2215: END IF;
2216: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2217: x_num_warnings =>l_num_warnings,
2218: x_num_errors =>l_num_errors);
2228: p_trip_id => p_trip_info_tab(l_index).trip_id,
2229: p_mode_of_transport => p_trip_info_tab(l_index).mode_of_transport,
2230: x_return_status => l_return_status);
2231: IF l_debug_on THEN
2232: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_MultiStops l_return_status',l_return_status);
2233: END IF;
2234: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2235: x_num_warnings =>l_num_warnings,
2236: x_num_errors =>l_num_errors);
2242: p_trip_rec => p_trip_info_tab(l_index),
2243: p_action => l_action,
2244: x_return_status => l_return_status);
2245: IF l_debug_on THEN
2246: WSH_DEBUG_SV.log(l_module_name,'WSH_FTE_INTEGRATION.trip_stop_validations l_return_status',l_return_status);
2247: END IF;
2248: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2249: x_num_warnings =>l_num_warnings,
2250: x_num_errors =>l_num_errors);
2260: l_num_errors := l_num_errors + 1;
2261: FND_MESSAGE.SET_NAME('WSH', 'WSH_MIXED_TRIP_ERROR');
2262: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
2263: IF l_debug_on THEN
2264: WSH_DEBUG_SV.logmsg(l_module_name,'e_mixed_trip_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2265: END IF;
2266: -- J-IB-NPARIKH-}
2267:
2268: WHEN fnd_api.g_exc_error THEN
2290: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2291: END IF;
2292:
2293: IF l_debug_on THEN
2294: WSH_DEBUG_SV.pop(l_module_name);
2295: END IF;
2296: EXCEPTION
2297: WHEN FND_API.G_EXC_ERROR THEN
2298: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2300: p_count => x_msg_count,
2301: p_data => x_msg_data,
2302: p_encoded => FND_API.G_FALSE);
2303: IF l_debug_on THEN
2304: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
2305: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2306: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2307: END IF;
2308: ROLLBACK TO SAVEPOINT validate_trip_grp;
2301: p_data => x_msg_data,
2302: p_encoded => FND_API.G_FALSE);
2303: IF l_debug_on THEN
2304: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
2305: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2306: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2307: END IF;
2308: ROLLBACK TO SAVEPOINT validate_trip_grp;
2309:
2302: p_encoded => FND_API.G_FALSE);
2303: IF l_debug_on THEN
2304: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',
2305: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2306: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2307: END IF;
2308: ROLLBACK TO SAVEPOINT validate_trip_grp;
2309:
2310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2313: p_count => x_msg_count,
2314: p_data => x_msg_data,
2315: p_encoded => FND_API.G_FALSE);
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
2318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2320: END IF;
2321: ROLLBACK TO SAVEPOINT validate_trip_grp;
2314: p_data => x_msg_data,
2315: p_encoded => FND_API.G_FALSE);
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
2318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2320: END IF;
2321: ROLLBACK TO SAVEPOINT validate_trip_grp;
2322:
2315: p_encoded => FND_API.G_FALSE);
2316: IF l_debug_on THEN
2317: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',
2318: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2319: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2320: END IF;
2321: ROLLBACK TO SAVEPOINT validate_trip_grp;
2322:
2323: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2326: p_count => x_msg_count,
2327: p_data => x_msg_data,
2328: p_encoded => FND_API.G_FALSE);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
2331: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2333: END IF;
2334: -- Bug 2741482
2327: p_data => x_msg_data,
2328: p_encoded => FND_API.G_FALSE);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
2331: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2333: END IF;
2334: -- Bug 2741482
2335: --ROLLBACK TO SAVEPOINT validate_trip_grp;
2328: p_encoded => FND_API.G_FALSE);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',
2331: WSH_DEBUG_SV.C_EXCEP_LEVEL);
2332: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2333: END IF;
2334: -- Bug 2741482
2335: --ROLLBACK TO SAVEPOINT validate_trip_grp;
2336:
2341: p_count => x_msg_count,
2342: p_data => x_msg_data,
2343: p_encoded => FND_API.G_FALSE);
2344: IF l_debug_on THEN
2345: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2346: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2347: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2348: END IF;
2349: ROLLBACK TO SAVEPOINT validate_trip_grp;
2342: p_data => x_msg_data,
2343: p_encoded => FND_API.G_FALSE);
2344: IF l_debug_on THEN
2345: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2346: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2347: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2348: END IF;
2349: ROLLBACK TO SAVEPOINT validate_trip_grp;
2350:
2343: p_encoded => FND_API.G_FALSE);
2344: IF l_debug_on THEN
2345: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2346: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2347: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2348: END IF;
2349: ROLLBACK TO SAVEPOINT validate_trip_grp;
2350:
2351: END Validate_Trip;
2443: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2444: --
2445: IF l_debug_on IS NULL
2446: THEN
2447: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2448: END IF;
2449: --
2450: SAVEPOINT create_update_trip_grp;
2451: IF l_debug_on THEN
2448: END IF;
2449: --
2450: SAVEPOINT create_update_trip_grp;
2451: IF l_debug_on THEN
2452: wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');
2453: wsh_debug_sv.log (l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
2454: END IF;
2455:
2456: IF l_debug_on THEN
2449: --
2450: SAVEPOINT create_update_trip_grp;
2451: IF l_debug_on THEN
2452: wsh_debug_sv.push (l_module_name, 'Create_Update_Trip');
2453: wsh_debug_sv.log (l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
2454: END IF;
2455:
2456: IF l_debug_on THEN
2457: FOR i in 1..p_trip_info_tab.count
2455:
2456: IF l_debug_on THEN
2457: FOR i in 1..p_trip_info_tab.count
2458: LOOP
2459: wsh_debug_sv.log (l_module_name,'p_shipmethod_code',p_trip_info_tab(i).ship_method_code);
2460: END LOOP;
2461: END IF;
2462:
2463: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
2461: END IF;
2462:
2463: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
2464: IF l_debug_on THEN
2465: WSH_DEBUG_SV.logmsg(l_module_name,'Not compatible');
2466: END IF;
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468: END IF;
2469:
2507: p_action => p_in_rec.action_code,
2508: x_return_status => l_return_status);
2509:
2510: IF l_debug_on THEN
2511: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
2512: END IF;
2513:
2514: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2515: x_num_warnings =>l_num_warnings,
2553: l_trip_info_tab := l_p_trip_info_tab;
2554: END IF;
2555:
2556: IF l_debug_on THEN
2557: WSH_DEBUG_SV.log(l_module_name,'count, l_num_errors',l_trip_info_tab.COUNT ||','||l_num_errors);
2558: END IF;
2559:
2560: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{
2561: --Compatiblity Changes
2582: x_return_status => l_return_status);
2583:
2584:
2585: IF l_debug_on THEN
2586: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_wrap',l_return_status);
2587: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_wrap',l_cc_validate_result);
2588: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_wrap',l_msg_count);
2589: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_wrap',l_msg_data);
2590: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_wrap',l_cc_failed_records.COUNT);
2583:
2584:
2585: IF l_debug_on THEN
2586: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_wrap',l_return_status);
2587: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_wrap',l_cc_validate_result);
2588: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_wrap',l_msg_count);
2589: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_wrap',l_msg_data);
2590: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_wrap',l_cc_failed_records.COUNT);
2591: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_wrap',l_cc_line_groups.COUNT);
2584:
2585: IF l_debug_on THEN
2586: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_wrap',l_return_status);
2587: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_wrap',l_cc_validate_result);
2588: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_wrap',l_msg_count);
2589: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_wrap',l_msg_data);
2590: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_wrap',l_cc_failed_records.COUNT);
2591: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_wrap',l_cc_line_groups.COUNT);
2592: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_wrap',l_cc_group_info.COUNT);
2585: IF l_debug_on THEN
2586: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_wrap',l_return_status);
2587: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_wrap',l_cc_validate_result);
2588: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_wrap',l_msg_count);
2589: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_wrap',l_msg_data);
2590: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_wrap',l_cc_failed_records.COUNT);
2591: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_wrap',l_cc_line_groups.COUNT);
2592: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_wrap',l_cc_group_info.COUNT);
2593: END IF;
2586: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_wrap',l_return_status);
2587: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_wrap',l_cc_validate_result);
2588: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_wrap',l_msg_count);
2589: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_wrap',l_msg_data);
2590: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_wrap',l_cc_failed_records.COUNT);
2591: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_wrap',l_cc_line_groups.COUNT);
2592: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_wrap',l_cc_group_info.COUNT);
2593: END IF;
2594: --
2587: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_wrap',l_cc_validate_result);
2588: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_wrap',l_msg_count);
2589: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_wrap',l_msg_data);
2590: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_wrap',l_cc_failed_records.COUNT);
2591: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_wrap',l_cc_line_groups.COUNT);
2592: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_wrap',l_cc_group_info.COUNT);
2593: END IF;
2594: --
2595:
2588: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_wrap',l_msg_count);
2589: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_wrap',l_msg_data);
2590: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_wrap',l_cc_failed_records.COUNT);
2591: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_wrap',l_cc_line_groups.COUNT);
2592: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_wrap',l_cc_group_info.COUNT);
2593: END IF;
2594: --
2595:
2596: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
2597: --fix p_rec_attr_tab to have only successful records
2598: l_cc_count_success:=1;
2599:
2600: IF l_debug_on THEN
2601: wsh_debug_sv.log(l_module_name,'trip_info_tab count before removing failed lines',l_trip_info_tab.COUNT);
2602: END IF;
2603:
2604: IF l_cc_fail_ids.COUNT>0 AND l_trip_info_tab.COUNT>0 THEN
2605: FOR i in l_trip_info_tab.FIRST..l_trip_info_tab.LAST LOOP
2620: l_trip_info_tab:=l_trip_info_tab_temp;
2621: END IF;
2622:
2623: IF l_debug_on THEN
2624: wsh_debug_sv.log(l_module_name,'trip_info_tab count after removing failed lines',l_trip_info_tab.COUNT);
2625: END IF;
2626:
2627: END IF;
2628:
2644:
2645: l_num_errors:= 0;
2646:
2647: IF l_debug_on THEN
2648: wsh_debug_sv.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
2649: END IF;
2650:
2651: Validate_Trip(
2652: p_trip_info_tab => l_trip_info_tab,
2655: x_return_status => l_return_status,
2656: p_caller => p_in_rec.caller);
2657:
2658: IF l_debug_on THEN
2659: WSH_DEBUG_SV.log(l_module_name,'Validate_trip l_return_status',l_return_status);
2660: END IF;
2661:
2662: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2663: x_num_warnings =>l_num_warnings,
2706:
2707: --J TP Release : firm/plan/unplan trip based on parameter for load tender update
2708: -- moved update statement from previous release to table handler
2709: IF l_debug_on THEN
2710: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2711: END IF;
2712:
2713: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(
2714: x_Param_Info => l_param_info,
2721: l_autofirm_loadtender_trip:=l_param_info.AUTOFIRM_LOAD_TENDERED_TRIPS;
2722:
2723:
2724: IF l_debug_on THEN
2725: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2726: WSH_DEBUG_SV.log(l_module_name,'load_tender_status',l_trip_info_tab(x_valid_index_tab(l_index)).load_tender_status);
2727: WSH_DEBUG_SV.log(l_module_name,'l_autofirm_loadtender_trip',l_autofirm_loadtender_trip);
2728: END IF;
2729: IF l_trip_info_tab(x_valid_index_tab(l_index)).load_tender_status is not null AND l_autofirm_loadtender_trip IN ('Y','F') THEN
2722:
2723:
2724: IF l_debug_on THEN
2725: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2726: WSH_DEBUG_SV.log(l_module_name,'load_tender_status',l_trip_info_tab(x_valid_index_tab(l_index)).load_tender_status);
2727: WSH_DEBUG_SV.log(l_module_name,'l_autofirm_loadtender_trip',l_autofirm_loadtender_trip);
2728: END IF;
2729: IF l_trip_info_tab(x_valid_index_tab(l_index)).load_tender_status is not null AND l_autofirm_loadtender_trip IN ('Y','F') THEN
2730: IF l_trip_info_tab(x_valid_index_tab(l_index)).load_tender_status IN ('TENDERED','ACCEPTED','RETENDERED', 'AUTO_ACCEPTED') THEN
2723:
2724: IF l_debug_on THEN
2725: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2726: WSH_DEBUG_SV.log(l_module_name,'load_tender_status',l_trip_info_tab(x_valid_index_tab(l_index)).load_tender_status);
2727: WSH_DEBUG_SV.log(l_module_name,'l_autofirm_loadtender_trip',l_autofirm_loadtender_trip);
2728: END IF;
2729: IF l_trip_info_tab(x_valid_index_tab(l_index)).load_tender_status is not null AND l_autofirm_loadtender_trip IN ('Y','F') THEN
2730: IF l_trip_info_tab(x_valid_index_tab(l_index)).load_tender_status IN ('TENDERED','ACCEPTED','RETENDERED', 'AUTO_ACCEPTED') THEN
2731: IF l_autofirm_loadtender_trip='Y' THEN
2752: --TP Release : if carrier or smc is changed, if they are CMS/TPW, call change_ignoreplan_status
2753: l_smc:=l_trip_info_tab(x_valid_index_tab(l_index)).ship_method_code;
2754: l_carrier_id:=l_trip_info_tab(x_valid_index_tab(l_index)).carrier_id;
2755: IF l_debug_on THEN
2756: WSH_DEBUG_SV.log(l_module_name,'smc',l_smc);
2757: WSH_DEBUG_SV.log(l_module_name,'carrier_id',l_carrier_id);
2758: END IF;
2759: IF (l_carrier_id is not null OR l_smc is not null)
2760: AND WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
2753: l_smc:=l_trip_info_tab(x_valid_index_tab(l_index)).ship_method_code;
2754: l_carrier_id:=l_trip_info_tab(x_valid_index_tab(l_index)).carrier_id;
2755: IF l_debug_on THEN
2756: WSH_DEBUG_SV.log(l_module_name,'smc',l_smc);
2757: WSH_DEBUG_SV.log(l_module_name,'carrier_id',l_carrier_id);
2758: END IF;
2759: IF (l_carrier_id is not null OR l_smc is not null)
2760: AND WSH_UTIL_CORE.TP_Is_Installed = 'Y' THEN
2761:
2774: p_ship_method_code=> l_smc,
2775: p_msg_display => 'N');
2776:
2777: IF l_debug_on THEN
2778: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type organization_id,l_wh_type,l_return_status',l_organization_id||l_wh_type||l_return_status);
2779: WSH_DEBUG_SV.log(l_module_name,'carrier_id',l_carrier_id);
2780: WSH_DEBUG_SV.log(l_module_name,'smc',l_smc);
2781: END IF;
2782:
2775: p_msg_display => 'N');
2776:
2777: IF l_debug_on THEN
2778: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type organization_id,l_wh_type,l_return_status',l_organization_id||l_wh_type||l_return_status);
2779: WSH_DEBUG_SV.log(l_module_name,'carrier_id',l_carrier_id);
2780: WSH_DEBUG_SV.log(l_module_name,'smc',l_smc);
2781: END IF;
2782:
2783: WSH_UTIL_CORE.api_post_call(
2776:
2777: IF l_debug_on THEN
2778: WSH_DEBUG_SV.log(l_module_name,'Get_Warehouse_Type organization_id,l_wh_type,l_return_status',l_organization_id||l_wh_type||l_return_status);
2779: WSH_DEBUG_SV.log(l_module_name,'carrier_id',l_carrier_id);
2780: WSH_DEBUG_SV.log(l_module_name,'smc',l_smc);
2781: END IF;
2782:
2783: WSH_UTIL_CORE.api_post_call(
2784: p_return_status => l_return_status,
2795: p_in_ids => l_trip_ids,
2796: p_action_code => 'IGNORE_PLAN',
2797: x_return_status => l_return_status);
2798: IF l_debug_on THEN
2799: wsh_debug_sv.log(l_module_name,'Return Status After Calling change_ignoreplan_sttatus',l_return_status);
2800: END IF;
2801: WSH_UTIL_CORE.api_post_call(
2802: p_return_status => l_return_status,
2803: x_num_warnings => l_num_warnings,
2819: p_action_prms => l_action_prms,
2820: p_rec_attr_tab => l_trip_info_tab);
2821:
2822: IF l_debug_on THEN
2823: WSH_DEBUG_SV.log(l_module_name,'after calling trip_callback l_return_status',l_return_status);
2824: END IF;
2825:
2826: wsh_util_core.api_post_call(
2827: p_return_status => l_return_status,
2868: p_data => x_msg_data,
2869: p_encoded => FND_API.G_FALSE );
2870:
2871: IF l_debug_on THEN
2872: WSH_DEBUG_SV.pop(l_module_name);
2873: END IF;
2874: EXCEPTION
2875: WHEN RECORD_LOCKED THEN
2876: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2880: p_count => x_msg_count,
2881: p_data => x_msg_data,
2882: p_encoded => FND_API.G_FALSE);
2883: IF l_debug_on THEN
2884: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2885: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
2886: END IF;
2887: ROLLBACK TO create_update_trip_grp;
2888:
2881: p_data => x_msg_data,
2882: p_encoded => FND_API.G_FALSE);
2883: IF l_debug_on THEN
2884: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2885: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
2886: END IF;
2887: ROLLBACK TO create_update_trip_grp;
2888:
2889: WHEN FND_API.G_EXC_ERROR THEN
2892: p_count => x_msg_count,
2893: p_data => x_msg_data,
2894: p_encoded => FND_API.G_FALSE);
2895: IF l_debug_on THEN
2896: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2897: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2898: END IF;
2899: ROLLBACK TO create_update_trip_grp;
2900:
2893: p_data => x_msg_data,
2894: p_encoded => FND_API.G_FALSE);
2895: IF l_debug_on THEN
2896: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2897: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2898: END IF;
2899: ROLLBACK TO create_update_trip_grp;
2900:
2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2904: p_count => x_msg_count,
2905: p_data => x_msg_data,
2906: p_encoded => FND_API.G_FALSE);
2907: IF l_debug_on THEN
2908: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2909: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2910: END IF;
2911: ROLLBACK TO create_update_trip_grp;
2912:
2905: p_data => x_msg_data,
2906: p_encoded => FND_API.G_FALSE);
2907: IF l_debug_on THEN
2908: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2909: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2910: END IF;
2911: ROLLBACK TO create_update_trip_grp;
2912:
2913: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2916: p_count => x_msg_count,
2917: p_data => x_msg_data,
2918: p_encoded => FND_API.G_FALSE);
2919: IF l_debug_on THEN
2920: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2922: END IF;
2923: -- Bug 2741482
2924: --ROLLBACK TO create_update_trip_grp;
2917: p_data => x_msg_data,
2918: p_encoded => FND_API.G_FALSE);
2919: IF l_debug_on THEN
2920: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2922: END IF;
2923: -- Bug 2741482
2924: --ROLLBACK TO create_update_trip_grp;
2925:
2930: p_count => x_msg_count,
2931: p_data => x_msg_data,
2932: p_encoded => FND_API.G_FALSE);
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2935: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2936: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2937: END IF;
2938: ROLLBACK TO create_update_trip_grp;
2931: p_data => x_msg_data,
2932: p_encoded => FND_API.G_FALSE);
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2935: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2936: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2937: END IF;
2938: ROLLBACK TO create_update_trip_grp;
2939:
2932: p_encoded => FND_API.G_FALSE);
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2935: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2936: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2937: END IF;
2938: ROLLBACK TO create_update_trip_grp;
2939:
2940: END CREATE_UPDATE_TRIP;
2986: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2987: --
2988: IF l_debug_on IS NULL
2989: THEN
2990: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2991: END IF;
2992: --
2993: IF l_debug_on THEN
2994: WSH_DEBUG_SV.push(l_module_name);
2990: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2991: END IF;
2992: --
2993: IF l_debug_on THEN
2994: WSH_DEBUG_SV.push(l_module_name);
2995: --
2996: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
2997: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2998: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
2992: --
2993: IF l_debug_on THEN
2994: WSH_DEBUG_SV.push(l_module_name);
2995: --
2996: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
2997: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2998: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
2999: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
2993: IF l_debug_on THEN
2994: WSH_DEBUG_SV.push(l_module_name);
2995: --
2996: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
2997: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2998: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
2999: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
2994: WSH_DEBUG_SV.push(l_module_name);
2995: --
2996: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
2997: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2998: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
2999: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
2995: --
2996: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
2997: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2998: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
2999: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
2996: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
2997: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2998: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
2999: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
2997: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
2998: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
2999: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
2998: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
2999: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
2999: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3007: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3000: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3007: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3008: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3001: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3007: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3008: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3009: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3002: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3007: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3008: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3009: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3010: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3003: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3007: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3008: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3009: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3010: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3011: END IF;
3004: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3007: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3008: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3009: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3010: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3011: END IF;
3012: --
3005: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3007: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3008: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3009: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3010: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3011: END IF;
3012: --
3013:
3006: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3007: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3008: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3009: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3010: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3011: END IF;
3012: --
3013:
3014: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
3023: p_grp_trip_rec => p_trip_info,
3024: x_pvt_trip_rec => l_pvt_trip_rec,
3025: x_return_status => x_return_status);
3026: IF l_debug_on THEN
3027: wsh_debug_sv.log (l_module_name, 'map_tripgrp_to_pvt x_return_status',x_return_status);
3028: END IF;
3029: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3030: raise FND_API.G_EXC_ERROR;
3031: END IF;
3043: p_In_rec => p_trip_In_rec,
3044: x_Out_tab => l_Out_Tab);
3045:
3046: IF l_debug_on THEN
3047: wsh_debug_sv.log (l_module_name,'In Wrapper Create_Update_Trip x_return_status',x_return_status);
3048: END IF;
3049:
3050: wsh_util_core.api_post_call(
3051: p_return_status => x_return_status,
3067: p_count => x_msg_count,
3068: p_data => x_msg_data);
3069:
3070: IF l_debug_on THEN
3071: WSH_DEBUG_SV.pop(l_module_name);
3072: END IF;
3073: EXCEPTION
3074: WHEN FND_API.G_EXC_ERROR THEN
3075: IF l_debug_on THEN
3072: END IF;
3073: EXCEPTION
3074: WHEN FND_API.G_EXC_ERROR THEN
3075: IF l_debug_on THEN
3076: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3077: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3078: END IF;
3079:
3080: WHEN OTHERS THEN
3073: EXCEPTION
3074: WHEN FND_API.G_EXC_ERROR THEN
3075: IF l_debug_on THEN
3076: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3077: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3078: END IF;
3079:
3080: WHEN OTHERS THEN
3081: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3080: WHEN OTHERS THEN
3081: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3082: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3083: IF l_debug_on THEN
3084: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3085: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3087: END IF;
3088: END Create_Update_Trip_New;
3081: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3082: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3083: IF l_debug_on THEN
3084: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3085: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3087: END IF;
3088: END Create_Update_Trip_New;
3089:
3082: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3083: IF l_debug_on THEN
3084: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3085: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3087: END IF;
3088: END Create_Update_Trip_New;
3089:
3090:
3135: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3136: --
3137: IF l_debug_on IS NULL
3138: THEN
3139: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3140: END IF;
3141: --
3142: IF l_debug_on THEN
3143: WSH_DEBUG_SV.push(l_module_name);
3139: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3140: END IF;
3141: --
3142: IF l_debug_on THEN
3143: WSH_DEBUG_SV.push(l_module_name);
3144: --
3145: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
3146: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3147: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
3141: --
3142: IF l_debug_on THEN
3143: WSH_DEBUG_SV.push(l_module_name);
3144: --
3145: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
3146: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3147: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3142: IF l_debug_on THEN
3143: WSH_DEBUG_SV.push(l_module_name);
3144: --
3145: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
3146: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3147: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3143: WSH_DEBUG_SV.push(l_module_name);
3144: --
3145: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
3146: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3147: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3144: --
3145: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
3146: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3147: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3145: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
3146: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3147: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3146: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
3147: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3147: WSH_DEBUG_SV.log(l_module_name,'P_ACTION_CODE',P_ACTION_CODE);
3148: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3148: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_NAME',P_TRIP_NAME);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3149: WSH_DEBUG_SV.log(l_module_name,'TRIP_ID',p_trip_info.trip_id);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3150: WSH_DEBUG_SV.log(l_module_name,'NAME',p_trip_info.name);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3158: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3151: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ITEM_ID',p_trip_info.vehicle_item_id);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3158: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3159: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3152: WSH_DEBUG_SV.log(l_module_name,'VEHICLE_ORGANIZATION_ID',p_trip_info.vehicle_organization_id);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3158: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3159: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3160: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3153: WSH_DEBUG_SV.log(l_module_name,'CARRIER_ID',p_trip_info.carrier_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3158: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3159: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3160: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3161: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3154: WSH_DEBUG_SV.log(l_module_name,'SHIP_METHOD_CODE',p_trip_info.ship_method_code);
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3158: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3159: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3160: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3161: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3162: END IF;
3155: WSH_DEBUG_SV.log(l_module_name,'SERVICE_LEVEL',p_trip_info.service_level);
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3158: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3159: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3160: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3161: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3162: END IF;
3163:
3156: WSH_DEBUG_SV.log(l_module_name,'MODE_OF_TRANSPORT',p_trip_info.mode_of_transport);
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3158: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3159: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3160: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3161: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3162: END IF;
3163:
3164: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
3157: WSH_DEBUG_SV.log(l_module_name,'CONSOLIDATION_ALLOWED',p_trip_info.consolidation_allowed);
3158: WSH_DEBUG_SV.log(l_module_name,'PLANNED_FLAG',p_trip_info.planned_flag);
3159: WSH_DEBUG_SV.log(l_module_name,'STATUS_CODE',p_trip_info.status_code);
3160: WSH_DEBUG_SV.log(l_module_name,'FREIGHT_TERMS_CODE',p_trip_info.freight_terms_code);
3161: WSH_DEBUG_SV.log(l_module_name,'LANE_ID',p_trip_info.lane_id);
3162: END IF;
3163:
3164: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
3165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3173: p_grp_trip_rec => p_trip_info,
3174: x_pvt_trip_rec => l_pvt_trip_rec,
3175: x_return_status => x_return_status);
3176: IF l_debug_on THEN
3177: wsh_debug_sv.log (l_module_name, 'map_tripgrp_to_pvt x_return_status',x_return_status);
3178: END IF;
3179: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3180: raise FND_API.G_EXC_ERROR;
3181: END IF;
3201: p_In_rec => l_In_rec,
3202: x_Out_tab => l_Out_Tab);
3203:
3204: IF l_debug_on THEN
3205: wsh_debug_sv.log (l_module_name,'In Wrapper Create_Update_Trip x_return_status',x_return_status);
3206: END IF;
3207: wsh_util_core.api_post_call(
3208: p_return_status => x_return_status,
3209: x_num_errors => l_num_errors,
3225: p_count => x_msg_count,
3226: p_data => x_msg_data);
3227:
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.pop(l_module_name);
3230: END IF;
3231: EXCEPTION
3232: WHEN FND_API.G_EXC_ERROR THEN
3233: IF l_debug_on THEN
3230: END IF;
3231: EXCEPTION
3232: WHEN FND_API.G_EXC_ERROR THEN
3233: IF l_debug_on THEN
3234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3236: END IF;
3237:
3238: WHEN OTHERS THEN
3231: EXCEPTION
3232: WHEN FND_API.G_EXC_ERROR THEN
3233: IF l_debug_on THEN
3234: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3236: END IF;
3237:
3238: WHEN OTHERS THEN
3239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3238: WHEN OTHERS THEN
3239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3240: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3243: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3245: END IF;
3246: END Create_Update_Trip;
3239: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3240: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3243: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3245: END IF;
3246: END Create_Update_Trip;
3247: --Harmonization Project **heali
3240: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_TRIP_NEW');
3241: IF l_debug_on THEN
3242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3243: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3245: END IF;
3246: END Create_Update_Trip;
3247: --Harmonization Project **heali
3248:
3322: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3323: --
3324: IF l_debug_on IS NULL
3325: THEN
3326: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3327: END IF;
3328: --
3329: IF l_debug_on THEN
3330: WSH_DEBUG_SV.push(l_module_name);
3326: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3327: END IF;
3328: --
3329: IF l_debug_on THEN
3330: WSH_DEBUG_SV.push(l_module_name);
3331: --
3332: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3333: END IF;
3334: --
3328: --
3329: IF l_debug_on THEN
3330: WSH_DEBUG_SV.push(l_module_name);
3331: --
3332: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
3333: END IF;
3334: --
3335: OPEN c_old_trip_details(p_trip_id);
3336: FETCH c_old_trip_details
3393: x_trip_rec := l_stops_trip_rec;
3394: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3395: --
3396: IF l_debug_on THEN
3397: WSH_DEBUG_SV.log(l_module_name,'l_stops_trip_rec.TRIP_ID',l_stops_trip_rec.TRIP_ID);
3398: WSH_DEBUG_SV.log(l_module_name,'l_stops_trip_rec.NAME',l_stops_trip_rec.NAME);
3399: WSH_DEBUG_SV.pop(l_module_name);
3400: END IF;
3401: --
3394: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3395: --
3396: IF l_debug_on THEN
3397: WSH_DEBUG_SV.log(l_module_name,'l_stops_trip_rec.TRIP_ID',l_stops_trip_rec.TRIP_ID);
3398: WSH_DEBUG_SV.log(l_module_name,'l_stops_trip_rec.NAME',l_stops_trip_rec.NAME);
3399: WSH_DEBUG_SV.pop(l_module_name);
3400: END IF;
3401: --
3402: EXCEPTION
3395: --
3396: IF l_debug_on THEN
3397: WSH_DEBUG_SV.log(l_module_name,'l_stops_trip_rec.TRIP_ID',l_stops_trip_rec.TRIP_ID);
3398: WSH_DEBUG_SV.log(l_module_name,'l_stops_trip_rec.NAME',l_stops_trip_rec.NAME);
3399: WSH_DEBUG_SV.pop(l_module_name);
3400: END IF;
3401: --
3402: EXCEPTION
3403: WHEN OTHERS THEN
3404: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIPS_GRP.get_trip_details_pvt',l_module_name);
3405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3406: --
3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3409: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3410: END IF;
3411: --
3412: END;
3405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3406: --
3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3409: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3410: END IF;
3411: --
3412: END;
3413: