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_BOLS_PVT dependencies on WSH_UTIL_CORE

Line 71: l_del_rows wsh_util_core.id_tab_type;

67: l_leg_info_old wsh_delivery_legs_pvt.delivery_leg_rec_type;
68: l_old_leg_id NUMBER;
69: l_new_leg_id NUMBER;
70: l_ledger_id NUMBER; -- LE Uptake
71: l_del_rows wsh_util_core.id_tab_type;
72: l_leg_rows wsh_util_core.id_tab_type;
73: l_drop_off_stop_id NUMBER;
74: l_pick_up_stop_id NUMBER;
75: wsh_create_trip_error EXCEPTION;

Line 72: l_leg_rows wsh_util_core.id_tab_type;

68: l_old_leg_id NUMBER;
69: l_new_leg_id NUMBER;
70: l_ledger_id NUMBER; -- LE Uptake
71: l_del_rows wsh_util_core.id_tab_type;
72: l_leg_rows wsh_util_core.id_tab_type;
73: l_drop_off_stop_id NUMBER;
74: l_pick_up_stop_id NUMBER;
75: wsh_create_trip_error EXCEPTION;
76: wsh_populate_trip_error EXCEPTION;

Line 217: x_return_status := wsh_util_core.g_ret_sts_error;

213: --
214: EXCEPTION
215: WHEN wsh_create_trip_error THEN
216: ROLLBACK TO sp1;
217: x_return_status := wsh_util_core.g_ret_sts_error;
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_TRIP_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
220: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_TRIP_ERROR');
221: END IF;

Line 225: x_return_status := wsh_util_core.g_ret_sts_error;

221: END IF;
222: --
223: WHEN wsh_populate_trip_error THEN
224: ROLLBACK TO sp1;
225: x_return_status := wsh_util_core.g_ret_sts_error;
226: --
227: IF l_debug_on THEN
228: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_POPULATE_TRIP_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
229: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_POPULATE_TRIP_ERROR');

Line 234: x_return_status := wsh_util_core.g_ret_sts_error;

230: END IF;
231: --
232: WHEN wsh_update_trip_error THEN
233: ROLLBACK TO sp1;
234: x_return_status := wsh_util_core.g_ret_sts_error;
235: --
236: IF l_debug_on THEN
237: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UPDATE_TRIP_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
238: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UPDATE_TRIP_ERROR');

Line 243: x_return_status := wsh_util_core.g_ret_sts_error;

239: END IF;
240: --
241: WHEN wsh_assign_delivery_error THEN
242: ROLLBACK TO sp1;
243: x_return_status := wsh_util_core.g_ret_sts_error;
244: --
245: IF l_debug_on THEN
246: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_ASSIGN_DELIVERY_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
247: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_ASSIGN_DELIVERY_ERROR');

Line 252: x_return_status := wsh_util_core.g_ret_sts_error;

248: END IF;
249: --
250: WHEN wsh_populate_leg_error THEN
251: ROLLBACK TO sp1;
252: x_return_status := wsh_util_core.g_ret_sts_error;
253: --
254: IF l_debug_on THEN
255: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_POPULATE_LEG_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
256: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_POPULATE_LEG_ERROR');

Line 261: x_return_status := wsh_util_core.g_ret_sts_error;

257: END IF;
258: --
259: WHEN wsh_delete_leg_error THEN
260: ROLLBACK TO sp1;
261: x_return_status := wsh_util_core.g_ret_sts_error;
262: --
263: IF l_debug_on THEN
264: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DELETE_LEG_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
265: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DELETE_LEG_ERROR');

Line 270: x_return_status := wsh_util_core.g_ret_sts_error;

266: END IF;
267: --
268: WHEN wsh_update_leg_error THEN
269: ROLLBACK TO sp1;
270: x_return_status := wsh_util_core.g_ret_sts_error;
271: --
272: IF l_debug_on THEN
273: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UPDATE_LEG_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
274: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UPDATE_LEG_ERROR');

Line 279: x_return_status := wsh_util_core.g_ret_sts_error;

275: END IF;
276: --
277: WHEN wsh_create_document_error THEN
278: ROLLBACK TO sp1;
279: x_return_status := wsh_util_core.g_ret_sts_error;
280: --
281: IF l_debug_on THEN
282: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');

Line 288: x_return_status := wsh_util_core.g_ret_sts_error;

284: END IF;
285: --
286: WHEN wsh_update_document_error THEN
287: ROLLBACK TO sp1;
288: x_return_status := wsh_util_core.g_ret_sts_error;
289: --
290: IF l_debug_on THEN
291: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UPDATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
292: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UPDATE_DOCUMENT_ERROR');

Line 297: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

293: END IF;
294: --
295: WHEN OTHERS THEN
296: ROLLBACK TO sp1;
297: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
298: --
299: IF l_debug_on THEN
300: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
301: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 329: l_del_rows wsh_util_core.id_tab_type;

325: )
326: IS
327: x_rowid varchar2(30);
328: l_trip_info wsh_trips_pvt.trip_rec_type;
329: l_del_rows wsh_util_core.id_tab_type;
330: l_leg_rows wsh_util_core.id_tab_type;
331: l_ledger_id NUMBER; -- LE Uptake
332:
333: wsh_create_trip_error EXCEPTION;

Line 330: l_leg_rows wsh_util_core.id_tab_type;

326: IS
327: x_rowid varchar2(30);
328: l_trip_info wsh_trips_pvt.trip_rec_type;
329: l_del_rows wsh_util_core.id_tab_type;
330: l_leg_rows wsh_util_core.id_tab_type;
331: l_ledger_id NUMBER; -- LE Uptake
332:
333: wsh_create_trip_error EXCEPTION;
334: wsh_populate_trip_error EXCEPTION;

Line 429: x_return_status := wsh_util_core.g_ret_sts_error;

425: --
426: EXCEPTION
427: WHEN wsh_create_trip_error THEN
428: ROLLBACK TO sp1;
429: x_return_status := wsh_util_core.g_ret_sts_error;
430: --
431: IF l_debug_on THEN
432: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_TRIP_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
433: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_TRIP_ERROR');

Line 438: x_return_status := wsh_util_core.g_ret_sts_error;

434: END IF;
435: --
436: WHEN wsh_populate_trip_error THEN
437: ROLLBACK TO sp1;
438: x_return_status := wsh_util_core.g_ret_sts_error;
439: --
440: IF l_debug_on THEN
441: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_POPULATE_TRIP_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
442: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_POPULATE_TRIP_ERROR');

Line 447: x_return_status := wsh_util_core.g_ret_sts_error;

443: END IF;
444: --
445: WHEN wsh_update_trip_error THEN
446: ROLLBACK TO sp1;
447: x_return_status := wsh_util_core.g_ret_sts_error;
448: --
449: IF l_debug_on THEN
450: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UPDATE_TRIP_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
451: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UPDATE_TRIP_ERROR');

Line 456: x_return_status := wsh_util_core.g_ret_sts_error;

452: END IF;
453: --
454: WHEN wsh_assign_delivery_error THEN
455: ROLLBACK TO sp1;
456: x_return_status := wsh_util_core.g_ret_sts_error;
457: --
458: IF l_debug_on THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_ASSIGN_DELIVERY_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
460: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_ASSIGN_DELIVERY_ERROR');

Line 465: x_return_status := wsh_util_core.g_ret_sts_error;

461: END IF;
462: --
463: WHEN wsh_create_document_error THEN
464: ROLLBACK TO sp1;
465: x_return_status := wsh_util_core.g_ret_sts_error;
466: --
467: IF l_debug_on THEN
468: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
469: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_DOCUMENT_ERROR');

Line 474: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

470: END IF;
471: --
472: WHEN OTHERS THEN
473: ROLLBACK TO sp1;
474: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
475: --
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 580: x_return_status := wsh_util_core.g_ret_sts_error;

576: --
577: EXCEPTION
578: WHEN wsh_delete_leg_error THEN
579: ROLLBACK TO sp1;
580: x_return_status := wsh_util_core.g_ret_sts_error;
581: --
582: IF l_debug_on THEN
583: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DELETE_LEG_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
584: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DELETE_LEG_ERROR');

Line 589: x_return_status := wsh_util_core.g_ret_sts_error;

585: END IF;
586: --
587: WHEN wsh_cancel_document_error THEN
588: ROLLBACK TO sp1;
589: x_return_status := wsh_util_core.g_ret_sts_error;
590: --
591: IF l_debug_on THEN
592: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_DOCUMENT_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
593: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_DOCUMENT_ERROR');

Line 598: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

594: END IF;
595: --
596: WHEN OTHERS THEN
597: ROLLBACK TO sp1;
598: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
599: --
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
602: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 785: IF (l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

781: p_entity_name => NULL,
782: p_entity_id => l_bol_num_tab(i).delivery_leg_id,
783: p_document_type => 'BOL',
784: p_consolidate_option => 'BOTH');
785: IF (l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
786: raise wsh_cancel_bol_error;
787: END IF;
788:
789: --

Line 812: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

808: p_trip_name => l_bol_num_tab(i).name, --bugfix 3990683
809: p_error_message => l_exception_error_message
810: );
811:
812: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
813: --
814: IF l_debug_on THEN
815: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_XC_UTIL.LOG_EXCEPTION DID NOT RETURN SUCCESS' );
816: END IF;

Line 830: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

826: IF l_debug_on THEN
827: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
828: END IF;
829: ELSE
830: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
831: END IF;
832:
833: IF l_debug_on THEN
834: WSH_DEBUG_SV.pop(l_module_name);

Line 840: x_return_status := wsh_util_core.g_ret_sts_error;

836: --
837: EXCEPTION
838: WHEN wsh_cancel_bol_error THEN
839: ROLLBACK TO cancel_bol1;
840: x_return_status := wsh_util_core.g_ret_sts_error;
841: --
842: IF l_debug_on THEN
843: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CANCEL_BOL_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
844: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_BOL_ERROR');

Line 848: x_return_status := wsh_util_core.g_ret_sts_error;

844: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CANCEL_BOL_ERROR');
845: END IF;
846: --
847: WHEN record_locked THEN
848: x_return_status := wsh_util_core.g_ret_sts_error;
849: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
850: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
851: --
852: IF l_debug_on THEN

Line 850: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);

846: --
847: WHEN record_locked THEN
848: x_return_status := wsh_util_core.g_ret_sts_error;
849: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
850: WSH_UTIL_CORE.add_message (x_return_status, l_module_name);
851: --
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

Line 859: wsh_util_core.default_handler('WSH_BOLS_PVT.cancel_bol',l_module_name);

855: END IF;
856: --
857: WHEN OTHERS THEN
858: ROLLBACK TO cancel_bol1;
859: wsh_util_core.default_handler('WSH_BOLS_PVT.cancel_bol',l_module_name);
860: IF bol_num_cur_1%ISOPEN THEN
861: close bol_num_cur_1;
862: END IF;
863: IF bol_num_cur_2%ISOPEN THEN

Line 866: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

862: END IF;
863: IF bol_num_cur_2%ISOPEN THEN
864: close bol_num_cur_2;
865: END IF;
866: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
867: --
868: IF l_debug_on THEN
869: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
870: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');