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_INBOUND_SHIP_ADVICE_PKG dependencies on WSH_DEBUG_SV

Line 151: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

147: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
148: --
149: IF l_debug_on IS NULL
150: THEN
151: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
152: END IF;
153: --
154: IF l_debug_on THEN
155: wsh_debug_sv.push(l_module_name);

Line 155: wsh_debug_sv.push(l_module_name);

151: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
152: END IF;
153: --
154: IF l_debug_on THEN
155: wsh_debug_sv.push(l_module_name);
156: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);
157: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
158: END IF;
159:

Line 156: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);

152: END IF;
153: --
154: IF l_debug_on THEN
155: wsh_debug_sv.push(l_module_name);
156: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);
157: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
158: END IF;
159:
160: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 157: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);

153: --
154: IF l_debug_on THEN
155: wsh_debug_sv.push(l_module_name);
156: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);
157: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
158: END IF;
159:
160: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
161:

Line 171: wsh_debug_sv.log (l_module_name, 'Delivery ID', l_delivery_id);

167: FETCH del_id INTO l_delivery_id, l_delivery_name,l_del_orgaization_id;
168: CLOSE del_id;
169:
170: IF l_debug_on THEN
171: wsh_debug_sv.log (l_module_name, 'Delivery ID', l_delivery_id);
172: END IF;
173:
174: --SA Trip Consolidation heali
175: OPEN get_inbd_trip_info(l_del_orgaization_id);

Line 181: wsh_debug_sv.log (l_module_name, 'l_ignore_inbd_trip',l_ignore_inbd_trip);

177: CLOSE get_inbd_trip_info;
178: --SA Trip Consolidation heali
179:
180: IF l_debug_on THEN
181: wsh_debug_sv.log (l_module_name, 'l_ignore_inbd_trip',l_ignore_inbd_trip);
182: END IF;
183:
184: ----Bug 3346237:ENFORCE SHIP METHOD NOT ENFORCED WHILE SHIP CONFIRMING
185: OPEN get_defer_interface_info;

Line 190: wsh_debug_sv.log (l_module_name, 'l_defer_interface_flag',l_defer_interface_flag);

186: FETCH get_defer_interface_info INTO l_defer_interface_flag;
187: CLOSE get_defer_interface_info;
188:
189: IF l_debug_on THEN
190: wsh_debug_sv.log (l_module_name, 'l_defer_interface_flag',l_defer_interface_flag);
191: END IF;
192:
193: -- check for warehouse type
194: l_warehouse_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type(

Line 201: wsh_debug_sv.log (l_module_name, 'Return status from get warehouse type', l_return_status);

197: P_Event_Key => p_event_key,
198: X_Return_Status => l_return_status);
199:
200: IF l_debug_on THEN
201: wsh_debug_sv.log (l_module_name, 'Return status from get warehouse type', l_return_status);
202: wsh_debug_sv.log (l_module_name, 'Warehouse type ', l_warehouse_type);
203: END IF;
204:
205: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 202: wsh_debug_sv.log (l_module_name, 'Warehouse type ', l_warehouse_type);

198: X_Return_Status => l_return_status);
199:
200: IF l_debug_on THEN
201: wsh_debug_sv.log (l_module_name, 'Return status from get warehouse type', l_return_status);
202: wsh_debug_sv.log (l_module_name, 'Warehouse type ', l_warehouse_type);
203: END IF;
204:
205: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
206: raise get_warehouse_type_failed;

Line 224: wsh_debug_sv.log (l_module_name, 'Return status from Validate Delivery Details', l_return_status);

220: WSH_INTERFACE_VALIDATIONS_PKG.Validate_Delivery_Details
221: (p_delivery_interface_id => p_delivery_interface_id,
222: x_return_Status => l_return_status);
223: IF l_debug_on THEN
224: wsh_debug_sv.log (l_module_name, 'Return status from Validate Delivery Details', l_return_status);
225: END IF;
226:
227: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
228: raise validate_delivery_failed;

Line 235: wsh_debug_sv.log (l_module_name, 'Return status from Validate Deliveries', l_return_status);

231: WSH_INTERFACE_VALIDATIONS_PKG.Validate_Deliveries
232: (p_delivery_id => l_delivery_id,
233: x_return_Status => l_return_status);
234: IF l_debug_on THEN
235: wsh_debug_sv.log (l_module_name, 'Return status from Validate Deliveries', l_return_status);
236: END IF;
237:
238: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
239: raise validate_delivery_failed;

Line 254: wsh_debug_sv.log (l_module_name, 'Return status from compare procedure', l_return_status);

250: (P_Delivery_ID => l_delivery_id,
251: X_Return_Status => l_return_status);
252:
253: IF l_debug_on THEN
254: wsh_debug_sv.log (l_module_name, 'Return status from compare procedure', l_return_status);
255: END IF;
256:
257: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
258: raise validate_delivery_failed;

Line 288: wsh_debug_sv.log (l_module_name, 'Return status from Dlvy Wrapper', l_return_status);

284: x_return_status => l_return_status);
285: END IF;
286:
287: IF l_debug_on THEN
288: wsh_debug_sv.log (l_module_name, 'Return status from Dlvy Wrapper', l_return_status);
289: END IF;
290:
291: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
292: raise process_delivery_failed;

Line 304: wsh_debug_sv.log (l_module_name, 'Container not received', l_cont_not_recv.delivery_detail_id);

300: l_not_recv_count := 0;
301: FOR l_cont_not_recv IN cont_not_recv_cur(l_delivery_id, p_delivery_interface_id) LOOP
302: l_not_recv_count := l_not_recv_count + 1;
303: IF l_debug_on THEN
304: wsh_debug_sv.log (l_module_name, 'Container not received', l_cont_not_recv.delivery_detail_id);
305: END IF;
306: -- For each of these containers, need to drill down and
307: -- backorder the delivery details that are not containers
308: FOR non_cont IN cont_contents_cur(l_cont_not_recv.delivery_detail_id) LOOP

Line 310: wsh_debug_sv.log (l_module_name, 'Contents', non_cont.delivery_detail_id);

306: -- For each of these containers, need to drill down and
307: -- backorder the delivery details that are not containers
308: FOR non_cont IN cont_contents_cur(l_cont_not_recv.delivery_detail_id) LOOP
309: IF l_debug_on THEN
310: wsh_debug_sv.log (l_module_name, 'Contents', non_cont.delivery_detail_id);
311: END IF;
312: OPEN det_qtys_cur(non_cont.delivery_detail_id);
313: FETCH det_qtys_cur INTO l_det_rq, l_det_pq, l_cont_flag;
314: CLOSE det_qtys_cur;

Line 322: wsh_debug_sv.log (l_module_name, 'Over picked qty', l_overpick_qty);

318: l_req_qtys(l_req_qtys.count + 1) := l_det_rq;
319: l_overpick_qty := LEAST(l_det_rq,
320: NVL(l_det_pq, l_det_rq) - l_det_rq);
321: IF l_debug_on THEN
322: wsh_debug_sv.log (l_module_name, 'Over picked qty', l_overpick_qty);
323: wsh_debug_sv.log (l_module_name, 'Req qty', l_det_rq);
324: wsh_debug_sv.log (l_module_name, 'Picked qty', l_det_pq);
325: END IF;
326: l_overpick_qtys(l_overpick_qtys.count + 1) := l_overpick_qty;

Line 323: wsh_debug_sv.log (l_module_name, 'Req qty', l_det_rq);

319: l_overpick_qty := LEAST(l_det_rq,
320: NVL(l_det_pq, l_det_rq) - l_det_rq);
321: IF l_debug_on THEN
322: wsh_debug_sv.log (l_module_name, 'Over picked qty', l_overpick_qty);
323: wsh_debug_sv.log (l_module_name, 'Req qty', l_det_rq);
324: wsh_debug_sv.log (l_module_name, 'Picked qty', l_det_pq);
325: END IF;
326: l_overpick_qtys(l_overpick_qtys.count + 1) := l_overpick_qty;
327: l_bo_qtys(l_bo_qtys.count + 1) := l_det_rq - l_overpick_qty;

Line 324: wsh_debug_sv.log (l_module_name, 'Picked qty', l_det_pq);

320: NVL(l_det_pq, l_det_rq) - l_det_rq);
321: IF l_debug_on THEN
322: wsh_debug_sv.log (l_module_name, 'Over picked qty', l_overpick_qty);
323: wsh_debug_sv.log (l_module_name, 'Req qty', l_det_rq);
324: wsh_debug_sv.log (l_module_name, 'Picked qty', l_det_pq);
325: END IF;
326: l_overpick_qtys(l_overpick_qtys.count + 1) := l_overpick_qty;
327: l_bo_qtys(l_bo_qtys.count + 1) := l_det_rq - l_overpick_qty;
328: END IF;

Line 334: wsh_debug_sv.log (l_module_name, 'Rows count ', l_bo_rows.count);

330: END LOOP;
331: END LOOP;
332:
333: IF l_debug_on THEN
334: wsh_debug_sv.log (l_module_name, 'Rows count ', l_bo_rows.count);
335: wsh_debug_sv.log (l_module_name, 'Not received count', l_not_recv_count);
336: END IF;
337: IF(l_not_recv_count > 0 AND l_bo_rows.count > 0) THEN
338: wsh_ship_confirm_actions2.Backorder(

Line 335: wsh_debug_sv.log (l_module_name, 'Not received count', l_not_recv_count);

331: END LOOP;
332:
333: IF l_debug_on THEN
334: wsh_debug_sv.log (l_module_name, 'Rows count ', l_bo_rows.count);
335: wsh_debug_sv.log (l_module_name, 'Not received count', l_not_recv_count);
336: END IF;
337: IF(l_not_recv_count > 0 AND l_bo_rows.count > 0) THEN
338: wsh_ship_confirm_actions2.Backorder(
339: p_detail_ids => l_bo_rows ,

Line 349: wsh_debug_sv.log (l_module_name, 'Return status after backorder', l_return_status);

345: p_bo_mode => 'UNRESERVE',
346: x_out_rows => l_cc_ids ,
347: x_return_status => l_return_status);
348: IF l_debug_on THEN
349: wsh_debug_sv.log (l_module_name, 'Return status after backorder', l_return_status);
350: END IF;
351: END IF; -- if l_not_recv_count
352: END IF; -- if l_warehouse_type = cms
353:

Line 377: wsh_debug_sv.log (l_module_name, 'Return status from create-update-trip', l_return_status);

373: x_trip_id => l_trip_id,
374: x_return_status => l_return_status);
375:
376: IF l_debug_on THEN
377: wsh_debug_sv.log (l_module_name, 'Return status from create-update-trip', l_return_status);
378: END IF;
379:
380: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
381: raise create_update_trip_failed;

Line 391: wsh_debug_sv.log (l_module_name, 'Delivery Name', l_delivery_name);

387: fetch c_get_del_name into l_delivery_name;
388: close c_get_del_name;
389:
390: IF l_debug_on THEN
391: wsh_debug_sv.log (l_module_name, 'Delivery Name', l_delivery_name);
392: END IF;
393:
394: -- 1. Need to update the txn. history record to success
395: -- Because all data(dlvy, details, trip, stop) have been successfully moved to base tables

Line 413: wsh_debug_sv.log (l_module_name, 'Contnr not received count', l_not_recv_count);

409: -- But since the delivery is planned , the unassign api will fail.
410: -- Hence we need to UNPLAN the delivery in such cases.
411:
412: IF l_debug_on THEN
413: wsh_debug_sv.log (l_module_name, 'Contnr not received count', l_not_recv_count);
414: END IF;
415:
416: IF(l_not_recv_count > 0) THEN
417: l_unplan_del_rows(1) := l_delivery_id;

Line 422: wsh_debug_sv.log (l_module_name, 'Return status after Unplan', l_return_status);

418: WSH_NEW_DELIVERY_ACTIONS.Unplan(
419: p_del_rows => l_unplan_del_rows,
420: x_return_status => l_return_status);
421: IF l_debug_on THEN
422: wsh_debug_sv.log (l_module_name, 'Return status after Unplan', l_return_status);
423: END IF;
424: END IF;
425: END IF; -- if l_warehouse_type
426:

Line 432: wsh_debug_sv.log(l_module_name,'Return status after delete interface records', l_return_status);

428: WSH_PROCESS_INTERFACED_PKG.Delete_Interface_Records(
429: p_delivery_interface_id => p_delivery_interface_id,
430: x_return_status => l_return_status);
431: IF l_debug_on THEN
432: wsh_debug_sv.log(l_module_name,'Return status after delete interface records', l_return_status);
433: END IF;
434: END IF;
435: END IF; --}
436: EXCEPTION

Line 488: wsh_debug_sv.log (l_module_name, 'Return status from ship confirm', l_return_status);

484: p_caller => 'WSH_IB');
485:
486: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);
487: IF l_debug_on THEN
488: wsh_debug_sv.log (l_module_name, 'Return status from ship confirm', l_return_status);
489: wsh_debug_sv.log (l_module_name, 'Ship confirm message count',l_msg_count);
490: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);
491: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);
492: END IF;

Line 489: wsh_debug_sv.log (l_module_name, 'Ship confirm message count',l_msg_count);

485:
486: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);
487: IF l_debug_on THEN
488: wsh_debug_sv.log (l_module_name, 'Return status from ship confirm', l_return_status);
489: wsh_debug_sv.log (l_module_name, 'Ship confirm message count',l_msg_count);
490: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);
491: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);
492: END IF;
493:

Line 490: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);

486: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);
487: IF l_debug_on THEN
488: wsh_debug_sv.log (l_module_name, 'Return status from ship confirm', l_return_status);
489: wsh_debug_sv.log (l_module_name, 'Ship confirm message count',l_msg_count);
490: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);
491: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);
492: END IF;
493:
494: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 491: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);

487: IF l_debug_on THEN
488: wsh_debug_sv.log (l_module_name, 'Return status from ship confirm', l_return_status);
489: wsh_debug_sv.log (l_module_name, 'Ship confirm message count',l_msg_count);
490: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);
491: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);
492: END IF;
493:
494: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
495: IF(l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 501: wsh_debug_sv.log (l_module_name, 'Ship confirm global variable', WSH_NEW_DELIVERY_ACTIONS.g_error_level);

497: -- Then need to raise the exception
498: -- Otherwise, i.e if the global variable is not 'E' then it means the warning
499: -- can be ignored and hence no need to raise the exception
500: IF l_debug_on THEN
501: wsh_debug_sv.log (l_module_name, 'Ship confirm global variable', WSH_NEW_DELIVERY_ACTIONS.g_error_level);
502: END IF;
503: IF(nvl(WSH_NEW_DELIVERY_ACTIONS.g_error_level, '!') = 'E') THEN
504: -- Reset the global variable to null
505: -- And then raise the exception

Line 524: wsh_debug_sv.pop(l_module_name);

520: END;
521:
522:
523: IF l_debug_on THEN
524: wsh_debug_sv.pop(l_module_name);
525: END IF;
526:
527: EXCEPTION
528: WHEN invalid_input THEN

Line 531: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

527: EXCEPTION
528: WHEN invalid_input THEN
529: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
530: IF l_debug_on THEN
531: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
532: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
533: END IF;
534: WHEN validate_delivery_failed THEN
535: FND_MESSAGE.SET_NAME('WSH','WSH_VALIDATE_DLVY_ERROR');

Line 532: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');

528: WHEN invalid_input THEN
529: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
530: IF l_debug_on THEN
531: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
532: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
533: END IF;
534: WHEN validate_delivery_failed THEN
535: FND_MESSAGE.SET_NAME('WSH','WSH_VALIDATE_DLVY_ERROR');
536: FND_MESSAGE.SET_TOKEN('DLVY', l_delivery_id);

Line 539: WSH_DEBUG_SV.logmsg(l_module_name,'validate_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

535: FND_MESSAGE.SET_NAME('WSH','WSH_VALIDATE_DLVY_ERROR');
536: FND_MESSAGE.SET_TOKEN('DLVY', l_delivery_id);
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'validate_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
540: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:validate_delivery_failed');
541: END IF;
542: WHEN process_delivery_failed THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 540: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:validate_delivery_failed');

536: FND_MESSAGE.SET_TOKEN('DLVY', l_delivery_id);
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'validate_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
540: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:validate_delivery_failed');
541: END IF;
542: WHEN process_delivery_failed THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
544: ROLLBACK TO before_update_dlvy_det;

Line 546: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

542: WHEN process_delivery_failed THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
544: ROLLBACK TO before_update_dlvy_det;
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
547: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_failed');
548: END IF;
549: WHEN create_update_trip_failed THEN
550: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_PROCESS_ERROR');

Line 547: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_failed');

543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
544: ROLLBACK TO before_update_dlvy_det;
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
547: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_failed');
548: END IF;
549: WHEN create_update_trip_failed THEN
550: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_PROCESS_ERROR');
551: FND_MESSAGE.SET_TOKEN('DLVY',l_delivery_id);

Line 555: WSH_DEBUG_SV.logmsg(l_module_name,'create_update_trip_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

551: FND_MESSAGE.SET_TOKEN('DLVY',l_delivery_id);
552: ROLLBACK TO before_update_dlvy_det;
553: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'create_update_trip_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_update_trip_failed');
557: END IF;
558: WHEN ship_confirm_failed THEN
559: FND_MESSAGE.SET_NAME('WSH','WSH_TXN_SHIP_CONFIRM_ERROR');

Line 556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_update_trip_failed');

552: ROLLBACK TO before_update_dlvy_det;
553: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'create_update_trip_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_update_trip_failed');
557: END IF;
558: WHEN ship_confirm_failed THEN
559: FND_MESSAGE.SET_NAME('WSH','WSH_TXN_SHIP_CONFIRM_ERROR');
560: FND_MESSAGE.SET_TOKEN('DLVY',l_delivery_id);

Line 571: WSH_DEBUG_SV.logmsg(l_module_name,'ship_confirm_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

567: IF l_warehouse_type ='TW2' THEN
568: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
569: END IF;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.logmsg(l_module_name,'ship_confirm_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ship_confirm_failed');
573: END IF;
574: WHEN update_dlvy_status_failed THEN
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ship_confirm_failed');

568: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
569: END IF;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.logmsg(l_module_name,'ship_confirm_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ship_confirm_failed');
573: END IF;
574: WHEN update_dlvy_status_failed THEN
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
576: ROLLBACK TO before_update_dlvy_det;

Line 578: WSH_DEBUG_SV.logmsg(l_module_name,'update_dlvy_status_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

574: WHEN update_dlvy_status_failed THEN
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
576: ROLLBACK TO before_update_dlvy_det;
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'update_dlvy_status_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_dlvy_status_failed');
580: END IF;
581: WHEN get_warehouse_type_failed THEN
582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_dlvy_status_failed');

575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
576: ROLLBACK TO before_update_dlvy_det;
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'update_dlvy_status_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_dlvy_status_failed');
580: END IF;
581: WHEN get_warehouse_type_failed THEN
582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
583: IF l_debug_on THEN

Line 584: WSH_DEBUG_SV.logmsg(l_module_name,'get_warehouse_type_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

580: END IF;
581: WHEN get_warehouse_type_failed THEN
582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
583: IF l_debug_on THEN
584: WSH_DEBUG_SV.logmsg(l_module_name,'get_warehouse_type_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
585: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:get_warehouse_type_failed');
586: END IF;
587: WHEN others_update_dlvy_det THEN
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 585: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:get_warehouse_type_failed');

581: WHEN get_warehouse_type_failed THEN
582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
583: IF l_debug_on THEN
584: WSH_DEBUG_SV.logmsg(l_module_name,'get_warehouse_type_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
585: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:get_warehouse_type_failed');
586: END IF;
587: WHEN others_update_dlvy_det THEN
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
589: ROLLBACK TO before_update_dlvy_det;

Line 591: WSH_DEBUG_SV.logmsg(l_module_name,'others_update_dlvy_det exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

587: WHEN others_update_dlvy_det THEN
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
589: ROLLBACK TO before_update_dlvy_det;
590: IF l_debug_on THEN
591: WSH_DEBUG_SV.logmsg(l_module_name,'others_update_dlvy_det exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
592: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_update_dlvy_det');
593: END IF;
594: WHEN others_create_update_trip THEN
595: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 592: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_update_dlvy_det');

588: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
589: ROLLBACK TO before_update_dlvy_det;
590: IF l_debug_on THEN
591: WSH_DEBUG_SV.logmsg(l_module_name,'others_update_dlvy_det exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
592: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_update_dlvy_det');
593: END IF;
594: WHEN others_create_update_trip THEN
595: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
596: ROLLBACK TO before_update_dlvy_det;

Line 598: WSH_DEBUG_SV.logmsg(l_module_name,'others_create_update_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

594: WHEN others_create_update_trip THEN
595: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
596: ROLLBACK TO before_update_dlvy_det;
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'others_create_update_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_create_update_trip');
600: END IF;
601: WHEN others_ship_confirm THEN
602: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_create_update_trip');

595: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
596: ROLLBACK TO before_update_dlvy_det;
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'others_create_update_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_create_update_trip');
600: END IF;
601: WHEN others_ship_confirm THEN
602: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
603: --Fulfillment Batch XML Project

Line 612: WSH_DEBUG_SV.logmsg(l_module_name,'others_ship_confirm exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

608: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
609: END IF;
610: ROLLBACK TO before_ship_confirm;
611: IF l_debug_on THEN
612: WSH_DEBUG_SV.logmsg(l_module_name,'others_ship_confirm exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_ship_confirm');
614: END IF;
615: WHEN OTHERS THEN
616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_ship_confirm');

609: END IF;
610: ROLLBACK TO before_ship_confirm;
611: IF l_debug_on THEN
612: WSH_DEBUG_SV.logmsg(l_module_name,'others_ship_confirm exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_ship_confirm');
614: END IF;
615: WHEN OTHERS THEN
616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
617: IF l_debug_on THEN

Line 618: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

614: END IF;
615: WHEN OTHERS THEN
616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
619: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
621: END IF;
622:

Line 619: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

615: WHEN OTHERS THEN
616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
619: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
621: END IF;
622:
623: END Process_Ship_Advice;

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

616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
619: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
621: END IF;
622:
623: END Process_Ship_Advice;
624: