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

APPS.WSH_OTM_INBOUND_GRP dependencies on WSH_DEBUG_SV

Line 149: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

145: -- Bug#7491598(ER,defer planned shipment iface):
146: l_global_params WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
147: -- Bug#7491598(ER,defer planned shipment iface):
148:
149: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
150: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'initiate_planned_shipment';
151: BEGIN
152:
153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 155: WSH_DEBUG_SV.push (l_module_name);

151: BEGIN
152:
153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
154: IF l_debug_on THEN
155: WSH_DEBUG_SV.push (l_module_name);
156: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- START ----------------');
157: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info COUNT : '||l_cnt);
158: END IF;
159:

Line 156: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- START ----------------');

152:
153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
154: IF l_debug_on THEN
155: WSH_DEBUG_SV.push (l_module_name);
156: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- START ----------------');
157: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info COUNT : '||l_cnt);
158: END IF;
159:
160: SAVEPOINT before_insert;

Line 157: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info COUNT : '||l_cnt);

153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
154: IF l_debug_on THEN
155: WSH_DEBUG_SV.push (l_module_name);
156: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- START ----------------');
157: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info COUNT : '||l_cnt);
158: END IF;
159:
160: SAVEPOINT before_insert;
161:

Line 166: WSH_DEBUG_SV.logmsg(l_module_name,'Profile User Id : '||l_user_id);

162: l_user_id := FND_PROFILE.value('WSH_OTM_DEFAULT_APPS_USER');
163: l_resp_id := FND_PROFILE.value('WSH_OTM_DEFAULT_APPS_RESP');
164:
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.logmsg(l_module_name,'Profile User Id : '||l_user_id);
167: WSH_DEBUG_SV.logmsg(l_module_name,'Profile Responsibility Id : '||l_resp_id);
168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_OTM_OUTBOUND.wsh_otm_apps_initialize ');
169: END IF;
170:

Line 167: WSH_DEBUG_SV.logmsg(l_module_name,'Profile Responsibility Id : '||l_resp_id);

163: l_resp_id := FND_PROFILE.value('WSH_OTM_DEFAULT_APPS_RESP');
164:
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.logmsg(l_module_name,'Profile User Id : '||l_user_id);
167: WSH_DEBUG_SV.logmsg(l_module_name,'Profile Responsibility Id : '||l_resp_id);
168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_OTM_OUTBOUND.wsh_otm_apps_initialize ');
169: END IF;
170:
171: -- security_group_id is optional

Line 168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_OTM_OUTBOUND.wsh_otm_apps_initialize ');

164:
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.logmsg(l_module_name,'Profile User Id : '||l_user_id);
167: WSH_DEBUG_SV.logmsg(l_module_name,'Profile Responsibility Id : '||l_resp_id);
168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_OTM_OUTBOUND.wsh_otm_apps_initialize ');
169: END IF;
170:
171: -- security_group_id is optional
172: --fnd_global.apps_initialize(l_user_id,l_resp_id,l_resp_appl_id,l_security_group_id);

Line 197: WSH_DEBUG_SV.logmsg(l_module_name,'current trip record is i = '||i);

193: IF i IS NOT NULL THEN
194: LOOP
195: l_skip_trip := FALSE;
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.logmsg(l_module_name,'current trip record is i = '||i);
198: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_stops COUNT : '||p_int_trip_info(i).shipment_stops.COUNT);
199: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases COUNT : '||p_int_trip_info(i).shipment_releases.COUNT);
200: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_ship_units COUNT : '||p_int_trip_info(i).shipment_ship_units.COUNT);
201: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.stop_locations. COUNT : '||p_int_trip_info(i).stop_locations.COUNT);

Line 198: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_stops COUNT : '||p_int_trip_info(i).shipment_stops.COUNT);

194: LOOP
195: l_skip_trip := FALSE;
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.logmsg(l_module_name,'current trip record is i = '||i);
198: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_stops COUNT : '||p_int_trip_info(i).shipment_stops.COUNT);
199: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases COUNT : '||p_int_trip_info(i).shipment_releases.COUNT);
200: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_ship_units COUNT : '||p_int_trip_info(i).shipment_ship_units.COUNT);
201: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.stop_locations. COUNT : '||p_int_trip_info(i).stop_locations.COUNT);
202: END IF;

Line 199: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases COUNT : '||p_int_trip_info(i).shipment_releases.COUNT);

195: l_skip_trip := FALSE;
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.logmsg(l_module_name,'current trip record is i = '||i);
198: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_stops COUNT : '||p_int_trip_info(i).shipment_stops.COUNT);
199: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases COUNT : '||p_int_trip_info(i).shipment_releases.COUNT);
200: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_ship_units COUNT : '||p_int_trip_info(i).shipment_ship_units.COUNT);
201: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.stop_locations. COUNT : '||p_int_trip_info(i).stop_locations.COUNT);
202: END IF;
203:

Line 200: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_ship_units COUNT : '||p_int_trip_info(i).shipment_ship_units.COUNT);

196: IF l_debug_on THEN
197: WSH_DEBUG_SV.logmsg(l_module_name,'current trip record is i = '||i);
198: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_stops COUNT : '||p_int_trip_info(i).shipment_stops.COUNT);
199: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases COUNT : '||p_int_trip_info(i).shipment_releases.COUNT);
200: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_ship_units COUNT : '||p_int_trip_info(i).shipment_ship_units.COUNT);
201: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.stop_locations. COUNT : '||p_int_trip_info(i).stop_locations.COUNT);
202: END IF;
203:
204: -- Call anshuman's API to derive list of EBS delivery ids and versions for the input tp_plan_name for a trip

Line 201: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.stop_locations. COUNT : '||p_int_trip_info(i).stop_locations.COUNT);

197: WSH_DEBUG_SV.logmsg(l_module_name,'current trip record is i = '||i);
198: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_stops COUNT : '||p_int_trip_info(i).shipment_stops.COUNT);
199: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases COUNT : '||p_int_trip_info(i).shipment_releases.COUNT);
200: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_ship_units COUNT : '||p_int_trip_info(i).shipment_ship_units.COUNT);
201: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.stop_locations. COUNT : '||p_int_trip_info(i).stop_locations.COUNT);
202: END IF;
203:
204: -- Call anshuman's API to derive list of EBS delivery ids and versions for the input tp_plan_name for a trip
205: -- Check versions for each of the deliveries in a trip

Line 227: WSH_DEBUG_SV.logmsg(l_module_name,'Returned from WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP x_return_status : '||l_return_status);

223: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: ELSE
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.logmsg(l_module_name,'Returned from WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP x_return_status : '||l_return_status);
228: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_tab.COUNT : '||l_delivery_tab.COUNT);
229: END IF;
230:
231: END IF;

Line 228: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_tab.COUNT : '||l_delivery_tab.COUNT);

224: raise FND_API.G_EXC_UNEXPECTED_ERROR;
225: ELSE
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.logmsg(l_module_name,'Returned from WSH_TMS_RELEASE.FIND_DELIVERIES_FOR_TRIP x_return_status : '||l_return_status);
228: WSH_DEBUG_SV.logmsg(l_module_name,'l_delivery_tab.COUNT : '||l_delivery_tab.COUNT);
229: END IF;
230:
231: END IF;
232:

Line 259: WSH_DEBUG_SV.logmsg(l_module_name,'current release record is l = '||l);

255: IF l IS NOT NULL THEN
256: LOOP
257:
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.logmsg(l_module_name,'current release record is l = '||l);
260: WSH_DEBUG_SV.logmsg(l_module_name,'Release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
261: WSH_DEBUG_SV.logmsg(l_module_name,'Release_refnum : '||p_int_trip_info(i).shipment_releases(l).release_refnum);
262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);
263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);

Line 260: WSH_DEBUG_SV.logmsg(l_module_name,'Release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);

256: LOOP
257:
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.logmsg(l_module_name,'current release record is l = '||l);
260: WSH_DEBUG_SV.logmsg(l_module_name,'Release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
261: WSH_DEBUG_SV.logmsg(l_module_name,'Release_refnum : '||p_int_trip_info(i).shipment_releases(l).release_refnum);
262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);
263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);
264: WSH_DEBUG_SV.logmsg(l_module_name,'Early Delivery Date : '||p_int_trip_info(i).shipment_releases(l).early_delivery_date);

Line 261: WSH_DEBUG_SV.logmsg(l_module_name,'Release_refnum : '||p_int_trip_info(i).shipment_releases(l).release_refnum);

257:
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.logmsg(l_module_name,'current release record is l = '||l);
260: WSH_DEBUG_SV.logmsg(l_module_name,'Release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
261: WSH_DEBUG_SV.logmsg(l_module_name,'Release_refnum : '||p_int_trip_info(i).shipment_releases(l).release_refnum);
262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);
263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);
264: WSH_DEBUG_SV.logmsg(l_module_name,'Early Delivery Date : '||p_int_trip_info(i).shipment_releases(l).early_delivery_date);
265: WSH_DEBUG_SV.logmsg(l_module_name,'Late Delivery Date : '||p_int_trip_info(i).shipment_releases(l).late_delivery_date);

Line 262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);

258: IF l_debug_on THEN
259: WSH_DEBUG_SV.logmsg(l_module_name,'current release record is l = '||l);
260: WSH_DEBUG_SV.logmsg(l_module_name,'Release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
261: WSH_DEBUG_SV.logmsg(l_module_name,'Release_refnum : '||p_int_trip_info(i).shipment_releases(l).release_refnum);
262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);
263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);
264: WSH_DEBUG_SV.logmsg(l_module_name,'Early Delivery Date : '||p_int_trip_info(i).shipment_releases(l).early_delivery_date);
265: WSH_DEBUG_SV.logmsg(l_module_name,'Late Delivery Date : '||p_int_trip_info(i).shipment_releases(l).late_delivery_date);
266: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases.release_freight_costs COUNT : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs.COUNT);

Line 263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);

259: WSH_DEBUG_SV.logmsg(l_module_name,'current release record is l = '||l);
260: WSH_DEBUG_SV.logmsg(l_module_name,'Release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
261: WSH_DEBUG_SV.logmsg(l_module_name,'Release_refnum : '||p_int_trip_info(i).shipment_releases(l).release_refnum);
262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);
263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);
264: WSH_DEBUG_SV.logmsg(l_module_name,'Early Delivery Date : '||p_int_trip_info(i).shipment_releases(l).early_delivery_date);
265: WSH_DEBUG_SV.logmsg(l_module_name,'Late Delivery Date : '||p_int_trip_info(i).shipment_releases(l).late_delivery_date);
266: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases.release_freight_costs COUNT : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs.COUNT);
267: END IF;

Line 264: WSH_DEBUG_SV.logmsg(l_module_name,'Early Delivery Date : '||p_int_trip_info(i).shipment_releases(l).early_delivery_date);

260: WSH_DEBUG_SV.logmsg(l_module_name,'Release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
261: WSH_DEBUG_SV.logmsg(l_module_name,'Release_refnum : '||p_int_trip_info(i).shipment_releases(l).release_refnum);
262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);
263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);
264: WSH_DEBUG_SV.logmsg(l_module_name,'Early Delivery Date : '||p_int_trip_info(i).shipment_releases(l).early_delivery_date);
265: WSH_DEBUG_SV.logmsg(l_module_name,'Late Delivery Date : '||p_int_trip_info(i).shipment_releases(l).late_delivery_date);
266: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases.release_freight_costs COUNT : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs.COUNT);
267: END IF;
268:

Line 265: WSH_DEBUG_SV.logmsg(l_module_name,'Late Delivery Date : '||p_int_trip_info(i).shipment_releases(l).late_delivery_date);

261: WSH_DEBUG_SV.logmsg(l_module_name,'Release_refnum : '||p_int_trip_info(i).shipment_releases(l).release_refnum);
262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);
263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);
264: WSH_DEBUG_SV.logmsg(l_module_name,'Early Delivery Date : '||p_int_trip_info(i).shipment_releases(l).early_delivery_date);
265: WSH_DEBUG_SV.logmsg(l_module_name,'Late Delivery Date : '||p_int_trip_info(i).shipment_releases(l).late_delivery_date);
266: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases.release_freight_costs COUNT : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs.COUNT);
267: END IF;
268:
269: l_del_status_code := NULL;

Line 266: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases.release_freight_costs COUNT : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs.COUNT);

262: WSH_DEBUG_SV.logmsg(l_module_name,'Early Pickup Date : '||p_int_trip_info(i).shipment_releases(l).early_pickup_date);
263: WSH_DEBUG_SV.logmsg(l_module_name,'Late Pickup Date : '||p_int_trip_info(i).shipment_releases(l).late_pickup_date);
264: WSH_DEBUG_SV.logmsg(l_module_name,'Early Delivery Date : '||p_int_trip_info(i).shipment_releases(l).early_delivery_date);
265: WSH_DEBUG_SV.logmsg(l_module_name,'Late Delivery Date : '||p_int_trip_info(i).shipment_releases(l).late_delivery_date);
266: WSH_DEBUG_SV.logmsg(l_module_name,'p_int_trip_info.shipment_releases.release_freight_costs COUNT : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs.COUNT);
267: END IF;
268:
269: l_del_status_code := NULL;
270: -- Derive delivery's revision_number if could not be defined for the trip earlier

Line 274: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_id_number : '||l_del_id_number);

270: -- Derive delivery's revision_number if could not be defined for the trip earlier
271: l_del_id_number := to_number(p_int_trip_info(i).shipment_releases(l).release_xid);
272: IF l_delivery_tab.COUNT = 0 OR (NOT l_delivery_tab.EXISTS(p_int_trip_info(i).shipment_releases(l).release_xid)) THEN
273: IF l_debug_on THEN
274: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_id_number : '||l_del_id_number);
275: WSH_DEBUG_SV.logmsg(l_module_name,'Opening c_get_del_revision for release_xid '||p_int_trip_info(i).shipment_releases(l).release_xid);
276: END IF;
277:
278: OPEN c_get_del_revision(l_del_id_number);

Line 275: WSH_DEBUG_SV.logmsg(l_module_name,'Opening c_get_del_revision for release_xid '||p_int_trip_info(i).shipment_releases(l).release_xid);

271: l_del_id_number := to_number(p_int_trip_info(i).shipment_releases(l).release_xid);
272: IF l_delivery_tab.COUNT = 0 OR (NOT l_delivery_tab.EXISTS(p_int_trip_info(i).shipment_releases(l).release_xid)) THEN
273: IF l_debug_on THEN
274: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_id_number : '||l_del_id_number);
275: WSH_DEBUG_SV.logmsg(l_module_name,'Opening c_get_del_revision for release_xid '||p_int_trip_info(i).shipment_releases(l).release_xid);
276: END IF;
277:
278: OPEN c_get_del_revision(l_del_id_number);
279: FETCH c_get_del_revision INTO l_del_revision_number,l_delivery_name(l), l_del_status_code;

Line 282: WSH_DEBUG_SV.logmsg(l_module_name,'WSH revision not found for release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);

278: OPEN c_get_del_revision(l_del_id_number);
279: FETCH c_get_del_revision INTO l_del_revision_number,l_delivery_name(l), l_del_status_code;
280: IF c_get_del_revision%NOTFOUND THEN
281: IF l_debug_on THEN
282: WSH_DEBUG_SV.logmsg(l_module_name,'WSH revision not found for release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
283: WSH_DEBUG_SV.logmsg(l_module_name,'Skipping this trip ');
284: END IF;
285: l_skip_trip := TRUE;
286: CLOSE c_get_del_revision;

Line 283: WSH_DEBUG_SV.logmsg(l_module_name,'Skipping this trip ');

279: FETCH c_get_del_revision INTO l_del_revision_number,l_delivery_name(l), l_del_status_code;
280: IF c_get_del_revision%NOTFOUND THEN
281: IF l_debug_on THEN
282: WSH_DEBUG_SV.logmsg(l_module_name,'WSH revision not found for release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
283: WSH_DEBUG_SV.logmsg(l_module_name,'Skipping this trip ');
284: END IF;
285: l_skip_trip := TRUE;
286: CLOSE c_get_del_revision;
287: EXIT;

Line 290: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_revision_number : '||l_del_revision_number);

286: CLOSE c_get_del_revision;
287: EXIT;
288: END IF;
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_revision_number : '||l_del_revision_number);
291: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_name : '||l_delivery_name(l));
292: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_status : '||l_del_status_code);
293: END IF;
294: CLOSE c_get_del_revision;

Line 291: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_name : '||l_delivery_name(l));

287: EXIT;
288: END IF;
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_revision_number : '||l_del_revision_number);
291: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_name : '||l_delivery_name(l));
292: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_status : '||l_del_status_code);
293: END IF;
294: CLOSE c_get_del_revision;
295:

Line 292: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_status : '||l_del_status_code);

288: END IF;
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_revision_number : '||l_del_revision_number);
291: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_name : '||l_delivery_name(l));
292: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_status : '||l_del_status_code);
293: END IF;
294: CLOSE c_get_del_revision;
295:
296: ELSE

Line 301: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_revision_number : '||l_del_revision_number);

297: l_del_revision_number := l_delivery_tab(p_int_trip_info(i).shipment_releases(l).release_xid).tms_version_number;
298: l_delivery_name(l) := l_delivery_tab(p_int_trip_info(i).shipment_releases(l).release_xid).name;
299: l_del_status_code := l_delivery_tab(p_int_trip_info(i).shipment_releases(l).release_xid).status_code;
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_revision_number : '||l_del_revision_number);
302: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_name : '||l_delivery_name(l));
303: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_status : '||l_del_status_code);
304: END IF;
305: END IF;

Line 302: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_name : '||l_delivery_name(l));

298: l_delivery_name(l) := l_delivery_tab(p_int_trip_info(i).shipment_releases(l).release_xid).name;
299: l_del_status_code := l_delivery_tab(p_int_trip_info(i).shipment_releases(l).release_xid).status_code;
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_revision_number : '||l_del_revision_number);
302: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_name : '||l_delivery_name(l));
303: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_status : '||l_del_status_code);
304: END IF;
305: END IF;
306: l_del_refnum := to_number(p_int_trip_info(i).shipment_releases(l).release_refnum);

Line 303: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_status : '||l_del_status_code);

299: l_del_status_code := l_delivery_tab(p_int_trip_info(i).shipment_releases(l).release_xid).status_code;
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_revision_number : '||l_del_revision_number);
302: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_name : '||l_delivery_name(l));
303: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_status : '||l_del_status_code);
304: END IF;
305: END IF;
306: l_del_refnum := to_number(p_int_trip_info(i).shipment_releases(l).release_refnum);
307: IF l_debug_on THEN

Line 308: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_refnum : '||l_del_refnum);

304: END IF;
305: END IF;
306: l_del_refnum := to_number(p_int_trip_info(i).shipment_releases(l).release_refnum);
307: IF l_debug_on THEN
308: WSH_DEBUG_SV.logmsg(l_module_name,'l_del_refnum : '||l_del_refnum);
309: END IF;
310: IF (nvl(l_del_refnum,0) < nvl(l_del_revision_number,0) OR l_del_status_code <> 'OP') THEN
311: l_skip_trip := TRUE;
312: EXIT;

Line 333: WSH_DEBUG_SV.logmsg(l_module_name,'Populated release record structure ');

329: l_latest_dropoff_date(l) := to_date(p_int_trip_info(i).shipment_releases(l).late_delivery_date,'YYYYMMDDHH24MISS');
330: l_release_refnum(l) := p_int_trip_info(i).shipment_releases(l).release_refnum;
331:
332: IF l_debug_on THEN
333: WSH_DEBUG_SV.logmsg(l_module_name,'Populated release record structure ');
334: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_xid : '||l_release_xid(l));
335: END IF;
336: -- LOOP over freight cost records for a release
337: -- create wsh_fc_interface record structures

Line 334: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_xid : '||l_release_xid(l));

330: l_release_refnum(l) := p_int_trip_info(i).shipment_releases(l).release_refnum;
331:
332: IF l_debug_on THEN
333: WSH_DEBUG_SV.logmsg(l_module_name,'Populated release record structure ');
334: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_xid : '||l_release_xid(l));
335: END IF;
336: -- LOOP over freight cost records for a release
337: -- create wsh_fc_interface record structures
338: --l_release_freight_cost(l) := 0;

Line 344: WSH_DEBUG_SV.logmsg(l_module_name,'current freight cost record is p = '||p);

340: IF p IS NOT NULL THEN
341: LOOP
342: l_fc_count := l_fc_count + 1;
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.logmsg(l_module_name,'current freight cost record is p = '||p);
345: WSH_DEBUG_SV.logmsg(l_module_name,'for shipment_xid : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs(p).shipment_xid);
346: END IF;
347: -- Insert each record
348:

Line 345: WSH_DEBUG_SV.logmsg(l_module_name,'for shipment_xid : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs(p).shipment_xid);

341: LOOP
342: l_fc_count := l_fc_count + 1;
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.logmsg(l_module_name,'current freight cost record is p = '||p);
345: WSH_DEBUG_SV.logmsg(l_module_name,'for shipment_xid : '||p_int_trip_info(i).shipment_releases(l).release_freight_costs(p).shipment_xid);
346: END IF;
347: -- Insert each record
348:
349: l_release_freight_del_id(l_fc_count) := p_int_trip_info(i).shipment_releases(l).release_xid;

Line 365: WSH_DEBUG_SV.logmsg(l_module_name,'Skipping this trip ');

361: END IF;
362:
363: IF l_skip_trip THEN
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.logmsg(l_module_name,'Skipping this trip ');
366: WSH_DEBUG_SV.logmsg(l_module_name,'Could not find one or more'||
367: ' deliveries associated with this trip OR trip has one or '||
368: 'more deliveries that are not in open status.');
369: END IF;

Line 366: WSH_DEBUG_SV.logmsg(l_module_name,'Could not find one or more'||

362:
363: IF l_skip_trip THEN
364: IF l_debug_on THEN
365: WSH_DEBUG_SV.logmsg(l_module_name,'Skipping this trip ');
366: WSH_DEBUG_SV.logmsg(l_module_name,'Could not find one or more'||
367: ' deliveries associated with this trip OR trip has one or '||
368: 'more deliveries that are not in open status.');
369: END IF;
370: GOTO next_trip;

Line 398: WSH_DEBUG_SV.logmsg(l_module_name,'Bulk Inserting into wsh_new_del_interface ');

394:
395: -- Bulk insert delivery interface records here
396: -- returning delivery_interface_id s BULK COLLECT INTO l_del_int_id_tab
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.logmsg(l_module_name,'Bulk Inserting into wsh_new_del_interface ');
399: END IF;
400:
401: forall j in p_int_trip_info(i).shipment_releases.FIRST .. p_int_trip_info(i).shipment_releases.LAST
402: Insert into WSH_NEW_DEL_INTERFACE

Line 442: WSH_DEBUG_SV.logmsg(l_module_name,'interface id count l_del_int_id_tab : '||l_del_int_id_tab.COUNT);

438: 1)
439: RETURNING DELIVERY_INTERFACE_ID BULK COLLECT INTO l_del_int_id_tab;
440:
441: IF l_debug_on THEN
442: WSH_DEBUG_SV.logmsg(l_module_name,'interface id count l_del_int_id_tab : '||l_del_int_id_tab.COUNT);
443: END IF;
444:
445: -- Create an associative array of delivery_interface_id s indexed by delivery_id
446: -- Populate l_local_release_tab

Line 456: WSH_DEBUG_SV.logmsg(l_module_name,'Creating local release for release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);

452: l_int_del_cnt := l_int_del_cnt + 1;
453: l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).delivery_interface_id := l_del_int_id_tab(l_int_del_cnt);
454: l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).leg_created_flag := 'N';
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Creating local release for release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
457: WSH_DEBUG_SV.logmsg(l_module_name,'delivery_interface_id : '||l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).delivery_interface_id);
458: WSH_DEBUG_SV.logmsg(l_module_name,'leg_created_flag : '||l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).leg_created_flag);
459: END IF;
460:

Line 457: WSH_DEBUG_SV.logmsg(l_module_name,'delivery_interface_id : '||l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).delivery_interface_id);

453: l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).delivery_interface_id := l_del_int_id_tab(l_int_del_cnt);
454: l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).leg_created_flag := 'N';
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Creating local release for release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
457: WSH_DEBUG_SV.logmsg(l_module_name,'delivery_interface_id : '||l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).delivery_interface_id);
458: WSH_DEBUG_SV.logmsg(l_module_name,'leg_created_flag : '||l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).leg_created_flag);
459: END IF;
460:
461: EXIT WHEN l = p_int_trip_info(i).shipment_releases.LAST;

Line 458: WSH_DEBUG_SV.logmsg(l_module_name,'leg_created_flag : '||l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).leg_created_flag);

454: l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).leg_created_flag := 'N';
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.logmsg(l_module_name,'Creating local release for release_xid : '||p_int_trip_info(i).shipment_releases(l).release_xid);
457: WSH_DEBUG_SV.logmsg(l_module_name,'delivery_interface_id : '||l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).delivery_interface_id);
458: WSH_DEBUG_SV.logmsg(l_module_name,'leg_created_flag : '||l_local_release_tab(p_int_trip_info(i).shipment_releases(l).release_xid).leg_created_flag);
459: END IF;
460:
461: EXIT WHEN l = p_int_trip_info(i).shipment_releases.LAST;
462: l := p_int_trip_info(i).shipment_releases.NEXT(l);

Line 477: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_freight_costs_inetrface ');

473: -- Bulk insert fc interface record by deriving delivery_interface_id s for each of the record
474: -- from the above associative array
475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_freight_costs_inetrface ');
478: END IF;
479:
480: forall j in 1 .. l_fc_count
481: Insert into WSH_FREIGHT_COSTS_INTERFACE

Line 524: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trips interface ');

520:
521: -- Insert the trip_interface here returning the trip_interface_id into l_trip_int_id(i)
522:
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trips interface ');
525: END IF;
526:
527: Insert into WSH_TRIPS_INTERFACE
528: (TRIP_INTERFACE_ID,

Line 567: WSH_DEBUG_SV.logmsg(l_module_name,'interface id l_trip_int_id(i) : '||l_trip_int_id(i));

563: 1)
564: RETURNING TRIP_INTERFACE_ID,GROUP_ID INTO l_trip_int_id(i),l_group_id;
565:
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'interface id l_trip_int_id(i) : '||l_trip_int_id(i));
568: WSH_DEBUG_SV.logmsg(l_module_name,'group id : '||l_group_id);
569: END IF;
570:
571: --IF nvl(p_int_trip_info(i).transaction_code,'CREATE') <> 'DELETE' THEN

Line 568: WSH_DEBUG_SV.logmsg(l_module_name,'group id : '||l_group_id);

564: RETURNING TRIP_INTERFACE_ID,GROUP_ID INTO l_trip_int_id(i),l_group_id;
565:
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.logmsg(l_module_name,'interface id l_trip_int_id(i) : '||l_trip_int_id(i));
568: WSH_DEBUG_SV.logmsg(l_module_name,'group id : '||l_group_id);
569: END IF;
570:
571: --IF nvl(p_int_trip_info(i).transaction_code,'CREATE') <> 'DELETE' THEN
572: IF nvl(p_int_trip_info(i).transaction_code,'CREATE') <> 'D' THEN

Line 595: WSH_DEBUG_SV.logmsg(l_module_name,'current stop record is k = '||k);

591: IF k IS NOT NULL THEN
592: LOOP
593: -- Need to insert trip_interface_id
594: IF l_debug_on THEN
595: WSH_DEBUG_SV.logmsg(l_module_name,'current stop record is k = '||k);
596: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);
597: WSH_DEBUG_SV.logmsg(l_module_name,'stop_sequence_number : '||p_int_trip_info(i).shipment_stops(k).stop_sequence_number);
598: WSH_DEBUG_SV.logmsg(l_module_name,'pa_date : '||p_int_trip_info(i).shipment_stops(k).planned_arrival_time);
599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);

Line 596: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);

592: LOOP
593: -- Need to insert trip_interface_id
594: IF l_debug_on THEN
595: WSH_DEBUG_SV.logmsg(l_module_name,'current stop record is k = '||k);
596: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);
597: WSH_DEBUG_SV.logmsg(l_module_name,'stop_sequence_number : '||p_int_trip_info(i).shipment_stops(k).stop_sequence_number);
598: WSH_DEBUG_SV.logmsg(l_module_name,'pa_date : '||p_int_trip_info(i).shipment_stops(k).planned_arrival_time);
599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);
600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);

Line 597: WSH_DEBUG_SV.logmsg(l_module_name,'stop_sequence_number : '||p_int_trip_info(i).shipment_stops(k).stop_sequence_number);

593: -- Need to insert trip_interface_id
594: IF l_debug_on THEN
595: WSH_DEBUG_SV.logmsg(l_module_name,'current stop record is k = '||k);
596: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);
597: WSH_DEBUG_SV.logmsg(l_module_name,'stop_sequence_number : '||p_int_trip_info(i).shipment_stops(k).stop_sequence_number);
598: WSH_DEBUG_SV.logmsg(l_module_name,'pa_date : '||p_int_trip_info(i).shipment_stops(k).planned_arrival_time);
599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);
600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);
601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);

Line 598: WSH_DEBUG_SV.logmsg(l_module_name,'pa_date : '||p_int_trip_info(i).shipment_stops(k).planned_arrival_time);

594: IF l_debug_on THEN
595: WSH_DEBUG_SV.logmsg(l_module_name,'current stop record is k = '||k);
596: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);
597: WSH_DEBUG_SV.logmsg(l_module_name,'stop_sequence_number : '||p_int_trip_info(i).shipment_stops(k).stop_sequence_number);
598: WSH_DEBUG_SV.logmsg(l_module_name,'pa_date : '||p_int_trip_info(i).shipment_stops(k).planned_arrival_time);
599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);
600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);
601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);
602: --bug 6700792: OTM Dock Door App Sched Proj

Line 599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);

595: WSH_DEBUG_SV.logmsg(l_module_name,'current stop record is k = '||k);
596: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);
597: WSH_DEBUG_SV.logmsg(l_module_name,'stop_sequence_number : '||p_int_trip_info(i).shipment_stops(k).stop_sequence_number);
598: WSH_DEBUG_SV.logmsg(l_module_name,'pa_date : '||p_int_trip_info(i).shipment_stops(k).planned_arrival_time);
599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);
600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);
601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);
602: --bug 6700792: OTM Dock Door App Sched Proj
603: WSH_DEBUG_SV.logmsg(l_module_name,'dock_name : '||p_int_trip_info(i).shipment_stops(k).dock_door_xid);

Line 600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);

596: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);
597: WSH_DEBUG_SV.logmsg(l_module_name,'stop_sequence_number : '||p_int_trip_info(i).shipment_stops(k).stop_sequence_number);
598: WSH_DEBUG_SV.logmsg(l_module_name,'pa_date : '||p_int_trip_info(i).shipment_stops(k).planned_arrival_time);
599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);
600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);
601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);
602: --bug 6700792: OTM Dock Door App Sched Proj
603: WSH_DEBUG_SV.logmsg(l_module_name,'dock_name : '||p_int_trip_info(i).shipment_stops(k).dock_door_xid);
604: WSH_DEBUG_SV.logmsg(l_module_name,'start_time : '||p_int_trip_info(i).shipment_stops(k).start_time);

Line 601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);

597: WSH_DEBUG_SV.logmsg(l_module_name,'stop_sequence_number : '||p_int_trip_info(i).shipment_stops(k).stop_sequence_number);
598: WSH_DEBUG_SV.logmsg(l_module_name,'pa_date : '||p_int_trip_info(i).shipment_stops(k).planned_arrival_time);
599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);
600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);
601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);
602: --bug 6700792: OTM Dock Door App Sched Proj
603: WSH_DEBUG_SV.logmsg(l_module_name,'dock_name : '||p_int_trip_info(i).shipment_stops(k).dock_door_xid);
604: WSH_DEBUG_SV.logmsg(l_module_name,'start_time : '||p_int_trip_info(i).shipment_stops(k).start_time);
605: WSH_DEBUG_SV.logmsg(l_module_name,'end_time : '||p_int_trip_info(i).shipment_stops(k).end_time);

Line 603: WSH_DEBUG_SV.logmsg(l_module_name,'dock_name : '||p_int_trip_info(i).shipment_stops(k).dock_door_xid);

599: WSH_DEBUG_SV.logmsg(l_module_name,'pd_date : '||p_int_trip_info(i).shipment_stops(k).planned_departure_time);
600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);
601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);
602: --bug 6700792: OTM Dock Door App Sched Proj
603: WSH_DEBUG_SV.logmsg(l_module_name,'dock_name : '||p_int_trip_info(i).shipment_stops(k).dock_door_xid);
604: WSH_DEBUG_SV.logmsg(l_module_name,'start_time : '||p_int_trip_info(i).shipment_stops(k).start_time);
605: WSH_DEBUG_SV.logmsg(l_module_name,'end_time : '||p_int_trip_info(i).shipment_stops(k).end_time);
606: END IF;
607:

Line 604: WSH_DEBUG_SV.logmsg(l_module_name,'start_time : '||p_int_trip_info(i).shipment_stops(k).start_time);

600: WSH_DEBUG_SV.logmsg(l_module_name,'aa_date : '||p_int_trip_info(i).shipment_stops(k).actual_arrival_time);
601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);
602: --bug 6700792: OTM Dock Door App Sched Proj
603: WSH_DEBUG_SV.logmsg(l_module_name,'dock_name : '||p_int_trip_info(i).shipment_stops(k).dock_door_xid);
604: WSH_DEBUG_SV.logmsg(l_module_name,'start_time : '||p_int_trip_info(i).shipment_stops(k).start_time);
605: WSH_DEBUG_SV.logmsg(l_module_name,'end_time : '||p_int_trip_info(i).shipment_stops(k).end_time);
606: END IF;
607:
608: l_stop_location_id(k) := substrb(p_int_trip_info(i).shipment_stops(k).stop_location_xid,instrb(p_int_trip_info(i).shipment_stops(k).stop_location_xid,'-',1,2) + 1);

Line 605: WSH_DEBUG_SV.logmsg(l_module_name,'end_time : '||p_int_trip_info(i).shipment_stops(k).end_time);

601: WSH_DEBUG_SV.logmsg(l_module_name,'ad_date : '||p_int_trip_info(i).shipment_stops(k).actual_departure_time);
602: --bug 6700792: OTM Dock Door App Sched Proj
603: WSH_DEBUG_SV.logmsg(l_module_name,'dock_name : '||p_int_trip_info(i).shipment_stops(k).dock_door_xid);
604: WSH_DEBUG_SV.logmsg(l_module_name,'start_time : '||p_int_trip_info(i).shipment_stops(k).start_time);
605: WSH_DEBUG_SV.logmsg(l_module_name,'end_time : '||p_int_trip_info(i).shipment_stops(k).end_time);
606: END IF;
607:
608: l_stop_location_id(k) := substrb(p_int_trip_info(i).shipment_stops(k).stop_location_xid,instrb(p_int_trip_info(i).shipment_stops(k).stop_location_xid,'-',1,2) + 1);
609: l_stop_sequence_number(k) := p_int_trip_info(i).shipment_stops(k).stop_sequence_number;

Line 623: WSH_DEBUG_SV.logmsg(l_module_name,'tz location xid : '||p_int_trip_info(i).stop_locations(t).location_xid);

619: t := p_int_trip_info(i).stop_locations.FIRST;
620: IF t IS NOT NULL THEN
621: LOOP
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.logmsg(l_module_name,'tz location xid : '||p_int_trip_info(i).stop_locations(t).location_xid);
624: END IF;
625: IF p_int_trip_info(i).stop_locations(t).location_xid = p_int_trip_info(i).shipment_stops(k).stop_location_xid THEN
626: l_stop_timezone_code(k) := p_int_trip_info(i).stop_locations(t).timezone_xid;
627: IF l_debug_on THEN

Line 628: WSH_DEBUG_SV.logmsg(l_module_name,'Stop timezone_xid : '||l_stop_timezone_code(k));

624: END IF;
625: IF p_int_trip_info(i).stop_locations(t).location_xid = p_int_trip_info(i).shipment_stops(k).stop_location_xid THEN
626: l_stop_timezone_code(k) := p_int_trip_info(i).stop_locations(t).timezone_xid;
627: IF l_debug_on THEN
628: WSH_DEBUG_SV.logmsg(l_module_name,'Stop timezone_xid : '||l_stop_timezone_code(k));
629: END IF;
630: EXIT;
631: END IF;
632:

Line 657: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trip_stops_interface ');

653:
654: -- Bulk insert stop interface records here
655: -- returning stop_interface_id s BULK COLLECT INTO l_stop_int_id_tab
656: IF l_debug_on THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_trip_stops_interface ');
658: END IF;
659:
660: forall j in p_int_trip_info(i).shipment_stops.FIRST .. p_int_trip_info(i).shipment_stops.LAST
661: -- bug 6700792: OTM Dock Door App Sched Info

Line 697: WSH_DEBUG_SV.logmsg(l_module_name,'interface id count l_stop_int_id_tab : '||l_stop_int_id_tab.COUNT);

693: 1)
694: Returning STOP_INTERFACE_ID BULK COLLECT into l_stop_int_id_tab;
695:
696: IF l_debug_on THEN
697: WSH_DEBUG_SV.logmsg(l_module_name,'interface id count l_stop_int_id_tab : '||l_stop_int_id_tab.COUNT);
698: END IF;
699:
700: -- Create an associative array of stop_interface_id s indexed by stop_location_id
701: -- l_stop_loc_tab

Line 715: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);

711: l_stop_loc_tab(p_int_trip_info(i).shipment_stops(k).stop_location_xid) := l_stop_int_id_tab(l_int_stop_cnt);
712: END IF;
713:
714: IF l_debug_on THEN
715: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);
716: WSH_DEBUG_SV.logmsg(l_module_name,'l_stop_loc_tab data : '||l_stop_loc_tab(p_int_trip_info(i).shipment_stops(k).stop_location_xid));
717: END IF;
718:
719: EXIT WHEN k = p_int_trip_info(i).shipment_stops.LAST;

Line 716: WSH_DEBUG_SV.logmsg(l_module_name,'l_stop_loc_tab data : '||l_stop_loc_tab(p_int_trip_info(i).shipment_stops(k).stop_location_xid));

712: END IF;
713:
714: IF l_debug_on THEN
715: WSH_DEBUG_SV.logmsg(l_module_name,'stop_location_xid : '||p_int_trip_info(i).shipment_stops(k).stop_location_xid);
716: WSH_DEBUG_SV.logmsg(l_module_name,'l_stop_loc_tab data : '||l_stop_loc_tab(p_int_trip_info(i).shipment_stops(k).stop_location_xid));
717: END IF;
718:
719: EXIT WHEN k = p_int_trip_info(i).shipment_stops.LAST;
720: k := p_int_trip_info(i).shipment_stops.NEXT(k);

Line 725: WSH_DEBUG_SV.logmsg(l_module_name,'Created l_stop_loc_tab : '||l_stop_loc_tab.COUNT);

721: END LOOP;
722: END IF;
723:
724: IF l_debug_on THEN
725: WSH_DEBUG_SV.logmsg(l_module_name,'Created l_stop_loc_tab : '||l_stop_loc_tab.COUNT);
726: END IF;
727:
728: m := p_int_trip_info(i).shipment_ship_units.FIRST;
729: IF m IS NOT NULL THEN

Line 739: WSH_DEBUG_SV.logmsg(l_module_name,'shipunit count : '||m);

735: l_dleg_pu_loc_id := p_int_trip_info(i).shipment_ship_units(m).ship_from_location_xid;
736: l_dleg_do_loc_id := p_int_trip_info(i).shipment_ship_units(m).ship_to_location_xid;
737:
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'shipunit count : '||m);
740: WSH_DEBUG_SV.logmsg(l_module_name,'ship_unit_xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);
741: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_id : '||l_release_id);
742: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_pu_loc_id : '||l_dleg_pu_loc_id);
743: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_do_loc_id : '||l_dleg_do_loc_id);

Line 740: WSH_DEBUG_SV.logmsg(l_module_name,'ship_unit_xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);

736: l_dleg_do_loc_id := p_int_trip_info(i).shipment_ship_units(m).ship_to_location_xid;
737:
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'shipunit count : '||m);
740: WSH_DEBUG_SV.logmsg(l_module_name,'ship_unit_xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);
741: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_id : '||l_release_id);
742: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_pu_loc_id : '||l_dleg_pu_loc_id);
743: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_do_loc_id : '||l_dleg_do_loc_id);
744: END IF;

Line 741: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_id : '||l_release_id);

737:
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'shipunit count : '||m);
740: WSH_DEBUG_SV.logmsg(l_module_name,'ship_unit_xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);
741: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_id : '||l_release_id);
742: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_pu_loc_id : '||l_dleg_pu_loc_id);
743: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_do_loc_id : '||l_dleg_do_loc_id);
744: END IF;
745:

Line 742: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_pu_loc_id : '||l_dleg_pu_loc_id);

738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'shipunit count : '||m);
740: WSH_DEBUG_SV.logmsg(l_module_name,'ship_unit_xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);
741: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_id : '||l_release_id);
742: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_pu_loc_id : '||l_dleg_pu_loc_id);
743: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_do_loc_id : '||l_dleg_do_loc_id);
744: END IF;
745:
746: -- 0. Skip the current ship_unit if the leg created flag for this ship_unit's delivery_id is Yes

Line 743: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_do_loc_id : '||l_dleg_do_loc_id);

739: WSH_DEBUG_SV.logmsg(l_module_name,'shipunit count : '||m);
740: WSH_DEBUG_SV.logmsg(l_module_name,'ship_unit_xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);
741: WSH_DEBUG_SV.logmsg(l_module_name,'l_release_id : '||l_release_id);
742: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_pu_loc_id : '||l_dleg_pu_loc_id);
743: WSH_DEBUG_SV.logmsg(l_module_name,'l_dleg_do_loc_id : '||l_dleg_do_loc_id);
744: END IF;
745:
746: -- 0. Skip the current ship_unit if the leg created flag for this ship_unit's delivery_id is Yes
747:

Line 750: WSH_DEBUG_SV.logmsg(l_module_name,'Skipping as alreasy created shunit xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);

746: -- 0. Skip the current ship_unit if the leg created flag for this ship_unit's delivery_id is Yes
747:
748: IF l_local_release_tab(l_release_id).leg_created_flag = 'Y' THEN
749: IF l_debug_on THEN
750: WSH_DEBUG_SV.logmsg(l_module_name,'Skipping as alreasy created shunit xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);
751: END IF;
752: GOTO next_shipunit;
753: END IF;
754: IF l_debug_on THEN

Line 755: WSH_DEBUG_SV.logmsg(l_module_name,'Using shunit xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);

751: END IF;
752: GOTO next_shipunit;
753: END IF;
754: IF l_debug_on THEN
755: WSH_DEBUG_SV.logmsg(l_module_name,'Using shunit xid : '||p_int_trip_info(i).shipment_ship_units(m).ship_unit_xid);
756: END IF;
757: l_ship_unit_count := l_ship_unit_count + 1;
758:
759: -- 1. derive delivery_interface_id from delivery_id associative array

Line 765: WSH_DEBUG_SV.logmsg(l_module_name,'After Using l_local_release_tab ');

761: l_dleg_int_act_code(l_ship_unit_count) := l_interface_act_code;
762: l_dleg_del_int_id(l_ship_unit_count) := l_local_release_tab(l_release_id).delivery_interface_id;
763: l_dleg_del_id(l_ship_unit_count) := l_release_id;
764: IF l_debug_on THEN
765: WSH_DEBUG_SV.logmsg(l_module_name,'After Using l_local_release_tab ');
766: END IF;
767:
768: -- 2. derive stop_interface_id from location_id associative array
769:

Line 773: WSH_DEBUG_SV.logmsg(l_module_name,'After Using l_stop_loc_tab ');

769:
770: l_dleg_pustop_id(l_ship_unit_count) := l_stop_loc_tab(l_dleg_pu_loc_id);
771: l_dleg_dostop_id(l_ship_unit_count) := l_stop_loc_tab(l_dleg_do_loc_id);
772: IF l_debug_on THEN
773: WSH_DEBUG_SV.logmsg(l_module_name,'After Using l_stop_loc_tab ');
774: END IF;
775:
776: -- 3. Mark the leg created flag for the current delivery_id as Yes
777:

Line 788: WSH_DEBUG_SV.logmsg(l_module_name,'Out of ship_units loop l_ship_unit_count : '||l_ship_unit_count);

784: END LOOP;
785: END IF;
786:
787: IF l_debug_on THEN
788: WSH_DEBUG_SV.logmsg(l_module_name,'Out of ship_units loop l_ship_unit_count : '||l_ship_unit_count);
789: END IF;
790:
791: END IF; -- Transaction_code <> 'DELETE'
792: <>

Line 803: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_del_legs_interface ');

799: IF l_ship_unit_count > 0 THEN
800:
801: -- Bulk insert into wsh_del_legs_interface
802: IF l_debug_on THEN
803: WSH_DEBUG_SV.logmsg(l_module_name,'Inserting into wsh_del_legs_interface ');
804: END IF;
805:
806: forall j in 1 .. l_ship_unit_count
807: Insert into WSH_DEL_LEGS_INTERFACE

Line 839: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',WSH_DEBUG_SV.C_PROC_LEVEL);

835: --{
836: -- Bug#7491598(ER,defer planned shipment iface): Check whether planned shipment is deferred or not.
837: --
838: IF l_debug_on THEN
839: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET_GLOBAL_PARAMETERS',WSH_DEBUG_SV.C_PROC_LEVEL);
840: END IF;
841: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_params,
842: x_return_status => l_return_status);
843: IF l_debug_on THEN

Line 844: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);

840: END IF;
841: WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters(x_Param_Info => l_global_params,
842: x_return_status => l_return_status);
843: IF l_debug_on THEN
844: WSH_DEBUG_SV.log(l_module_name,'L_RETURN_STATUS',l_return_status);
845: END IF;
846: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
847: x_return_status := l_return_status;
848: IF l_debug_on THEN

Line 849: WSH_DEBUG_SV.pop(l_module_name);

845: END IF;
846: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
847: x_return_status := l_return_status;
848: IF l_debug_on THEN
849: WSH_DEBUG_SV.pop(l_module_name);
850: END IF;
851: RETURN;
852: END IF;
853: --

Line 855: WSH_DEBUG_SV.log(l_module_name,'defer_planned_shipment_flag',l_global_params.defer_plan_shipment_interface);

851: RETURN;
852: END IF;
853: --
854: IF l_debug_on THEN
855: WSH_DEBUG_SV.log(l_module_name,'defer_planned_shipment_flag',l_global_params.defer_plan_shipment_interface);
856: END IF;
857: IF nvl(l_global_params.defer_plan_shipment_interface,'N') = 'N' THEN
858: --{
859:

Line 861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FND_REQUEST.Submit_Request',WSH_DEBUG_SV.C_PROC_LEVEL);

857: IF nvl(l_global_params.defer_plan_shipment_interface,'N') = 'N' THEN
858: --{
859:
860: IF l_debug_on THEN
861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FND_REQUEST.Submit_Request',WSH_DEBUG_SV.C_PROC_LEVEL);
862: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
863: END IF;
864: l_request_id := FND_REQUEST.Submit_Request(
865: application => 'WSH',

Line 862: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);

858: --{
859:
860: IF l_debug_on THEN
861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FND_REQUEST.Submit_Request',WSH_DEBUG_SV.C_PROC_LEVEL);
862: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
863: END IF;
864: l_request_id := FND_REQUEST.Submit_Request(
865: application => 'WSH',
866: program => 'WSHOTMRL',

Line 871: WSH_DEBUG_SV.logmsg(l_module_name,'Request submission failed ');

867: argument1 => l_group_id);
868: IF l_request_id = 0 THEN
869: -- If request submission failed, exit with error.
870: IF l_debug_on THEN
871: WSH_DEBUG_SV.logmsg(l_module_name,'Request submission failed ');
872: END IF;
873: x_msg_data := FND_MESSAGE.GET_STRING('WSH','WSH_OTM_IB_CONC_ERROR');
874: --x_msg_data := 'Concurrent Request submission failed';
875: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 879: WSH_DEBUG_SV.logmsg(l_module_name,'Request '||l_request_id||' submitted successfully');

875: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
876: ELSE
877: x_output_request_id := l_request_id;
878: IF l_debug_on THEN
879: WSH_DEBUG_SV.logmsg(l_module_name,'Request '||l_request_id||' submitted successfully');
880: END IF;
881: END IF;
882: --}
883: END IF;

Line 893: WSH_DEBUG_SV.logmsg(l_module_name,'Returning x_return_status : '|| x_return_status);

889:
890: END IF; -- l_group_id IS NOT NULL
891:
892: IF l_debug_on THEN
893: WSH_DEBUG_SV.logmsg(l_module_name,'Returning x_return_status : '|| x_return_status);
894: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
895: WSH_DEBUG_SV.pop(l_module_name);
896: END IF;
897:

Line 894: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');

890: END IF; -- l_group_id IS NOT NULL
891:
892: IF l_debug_on THEN
893: WSH_DEBUG_SV.logmsg(l_module_name,'Returning x_return_status : '|| x_return_status);
894: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
895: WSH_DEBUG_SV.pop(l_module_name);
896: END IF;
897:
898: EXCEPTION

Line 895: WSH_DEBUG_SV.pop(l_module_name);

891:
892: IF l_debug_on THEN
893: WSH_DEBUG_SV.logmsg(l_module_name,'Returning x_return_status : '|| x_return_status);
894: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
895: WSH_DEBUG_SV.pop(l_module_name);
896: END IF;
897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

900: ROLLBACK TO SAVEPOINT before_insert;
901: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
902: --
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
905: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
906: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
907: END IF;
908: --

Line 905: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');

901: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
902: --
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
905: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
906: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
907: END IF;
908: --
909: x_msg_data := 'Oracle error message is '|| SQLERRM;

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

902: --
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
905: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
906: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
907: END IF;
908: --
909: x_msg_data := 'Oracle error message is '|| SQLERRM;
910: WHEN others THEN

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

913: x_msg_data := 'Oracle error message is '|| SQLERRM;
914: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.initiate_planned_shipment');
915: --
916: IF l_debug_on THEN
917: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
918: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
919: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
920: END IF;
921: --

Line 918: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');

914: WSH_UTIL_CORE.default_handler('WSH_OTM_INBOUND_GRP.initiate_planned_shipment');
915: --
916: IF l_debug_on THEN
917: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
918: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
919: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
920: END IF;
921: --
922: END initiate_planned_shipment;

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

915: --
916: IF l_debug_on THEN
917: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
918: WSH_DEBUG_SV.logmsg(l_module_name,'-------------- END ----------------');
919: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
920: END IF;
921: --
922: END initiate_planned_shipment;
923: