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

Line 116: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null

112: l_cancel_hist_record c_get_cancel_record%ROWTYPE;
113: BEGIN
114:
115: -- Bugfix 4070732
116: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
117: THEN
118: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
119: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
120: END IF;

Line 118: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;

114:
115: -- Bugfix 4070732
116: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
117: THEN
118: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
119: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
120: END IF;
121:
122: -- End of Code Bugfix 4070732

Line 119: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;

115: -- Bugfix 4070732
116: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null
117: THEN
118: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
119: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
120: END IF;
121:
122: -- End of Code Bugfix 4070732
123: --

Line 204: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

200: p_transaction_rec => l_trns_history_rec,
201: p_commit_flag => FND_API.G_TRUE,
202: x_return_status => l_return_status);
203:
204: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
205: RAISE FND_API.G_EXC_ERROR;
206: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSE

Line 206: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

202: x_return_status => l_return_status);
203:
204: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
205: RAISE FND_API.G_EXC_ERROR;
206: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSE
209: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
210: wsh_util_core.g_ret_sts_success

Line 209: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =

205: RAISE FND_API.G_EXC_ERROR;
206: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSE
209: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
210: wsh_util_core.g_ret_sts_success
211: THEN
212: x_return_status := l_return_status;
213: END IF;

Line 210: wsh_util_core.g_ret_sts_success

206: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSE
209: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
210: wsh_util_core.g_ret_sts_success
211: THEN
212: x_return_status := l_return_status;
213: END IF;
214: END IF;

Line 277: IF (l_return_status = wsh_util_core.g_ret_sts_success) THEN

273: IF l_debug_on THEN
274: wsh_debug_sv.log (l_module_name,'After Calling Derive IDS l_return_status',l_return_status);
275: END IF;
276:
277: IF (l_return_status = wsh_util_core.g_ret_sts_success) THEN
278:
279: -- TPW - Distributed changes
280: -- savepoint before_process NOT required since api
281: -- wsh_inbound_ship_advice_pkg.process_ship_advice takes care of

Line 316: IF (t_return_status = wsh_util_core.g_ret_sts_success)

312: END IF;
313:
314: x_return_status := t_return_status;
315:
316: IF (t_return_status = wsh_util_core.g_ret_sts_success)
317: THEN --{
318:
319: IF (l_trns_history_rec.document_type = 'SA') THEN --{
320: --k proj

Line 421: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

417: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
418: END IF;
419: --
420: --
421: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
422: RAISE FND_API.G_EXC_ERROR;
423: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: ELSE

Line 423: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

419: --
420: --
421: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
422: RAISE FND_API.G_EXC_ERROR;
423: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: ELSE
426: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
427: wsh_util_core.g_ret_sts_success

Line 426: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =

422: RAISE FND_API.G_EXC_ERROR;
423: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: ELSE
426: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
427: wsh_util_core.g_ret_sts_success
428: THEN
429: x_return_status := l_return_status;
430: END IF;

Line 427: wsh_util_core.g_ret_sts_success

423: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: ELSE
426: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
427: wsh_util_core.g_ret_sts_success
428: THEN
429: x_return_status := l_return_status;
430: END IF;
431: END IF;

Line 444: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

440: -- Added on Mar 29th
441: --
442: -- Start code for Bugfix 4070732
443: --
444: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
445: --{
446: IF l_debug_on THEN
447: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
448: END IF;

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

443: --
444: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
445: --{
446: IF l_debug_on THEN
447: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
448: END IF;
449:
450: l_reset_flags := FALSE;
451:

Line 452: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,

448: END IF;
449:
450: l_reset_flags := FALSE;
451:
452: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
453: x_return_status => l_return_status);
454:
455: IF l_debug_on THEN
456: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 459: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

455: IF l_debug_on THEN
456: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
457: END IF;
458:
459: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
460: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
461: RAISE FND_API.G_EXC_ERROR;
462: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 460: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

456: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
457: END IF;
458:
459: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
460: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
461: RAISE FND_API.G_EXC_ERROR;
462: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;

Line 462: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

458:
459: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
460: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
461: RAISE FND_API.G_EXC_ERROR;
462: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: --}
466: END IF;

Line 474: x_return_status := wsh_util_core.g_ret_sts_error;

470:
471: COMMIT;
472:
473: ELSE
474: x_return_status := wsh_util_core.g_ret_sts_error;
475: -- Derive_ids returned error. Some validation has failed.
476: --Need to update the status to Error. Otherwise, status will continue to 'IP'
477: UPDATE wsh_transactions_history
478: SET transaction_status = 'ER'

Line 499: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

495: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
496: END IF;
497: --
498: --
499: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: --ELSE

Line 501: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

497: --
498: --
499: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: --ELSE
504: --x_return_status := l_return_status;
505: END IF;

Line 512: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

508: --
509: --
510: -- Start code for Bugfix 4070732
511: --
512: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
513: --{
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
516: END IF;

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

511: --
512: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
513: --{
514: IF l_debug_on THEN
515: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
516: END IF;
517:
518: l_reset_flags := FALSE;
519:

Line 520: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,

516: END IF;
517:
518: l_reset_flags := FALSE;
519:
520: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
521: x_return_status => l_return_status);
522:
523: IF l_debug_on THEN
524: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 527: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

523: IF l_debug_on THEN
524: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
525: END IF;
526:
527: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
528: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 528: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

524: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
525: END IF;
526:
527: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
528: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;

Line 530: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

526:
527: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
528: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
529: RAISE FND_API.G_EXC_ERROR;
530: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: --}
534: END IF;

Line 543: x_return_status := wsh_util_core.g_ret_sts_error;

539:
540: END IF; -- End of IF (L_Return_Status ....
541:
542: ELSE -- if Not Null Check failed.
543: x_return_status := wsh_util_core.g_ret_sts_error;
544: END IF; -- Check for Null Values.
545:
546: END IF; -- End of (IF Entity_Type = 'DLVY_INT') ...
547:

Line 552: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

548: END IF; --} --End of WMS_DEPLOYMENT_MODE
549:
550: --bug 4070732
551: --End of the API handling of calls to process_stops_for_load_tender
552: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
553: THEN
554: --{
555: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
556: --{

Line 555: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

551: --End of the API handling of calls to process_stops_for_load_tender
552: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
553: THEN
554: --{
555: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
556: --{
557: l_reset_flags := TRUE;
558:
559: IF l_debug_on THEN

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

556: --{
557: l_reset_flags := TRUE;
558:
559: IF l_debug_on THEN
560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
561: END IF;
562:
563: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
564: x_return_status => l_return_status);

Line 563: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,

559: IF l_debug_on THEN
560: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
561: END IF;
562:
563: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
564: x_return_status => l_return_status);
565:
566: IF l_debug_on THEN
567: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 571: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

567: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
568: END IF;
569:
570: IF (
571: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
572: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
573: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
574: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
575: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 572: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

568: END IF;
569:
570: IF (
571: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
572: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
573: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
574: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
575: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
576: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )

Line 573: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

569:
570: IF (
571: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
572: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
573: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
574: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
575: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
576: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )
577: )

Line 574: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

570: IF (
571: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
572: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
573: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
574: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
575: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
576: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )
577: )
578: THEN

Line 575: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

571: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
572: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
573: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
574: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
575: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
576: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )
577: )
578: THEN
579: --{

Line 576: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )

572: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
573: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
574: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
575: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
576: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )
577: )
578: THEN
579: --{
580: x_return_status := l_return_status;

Line 623: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

619: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
620: END IF;
621: --
622: --
623: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
624: x_return_status := l_return_status;
625: END IF;
626: --
627: --}

Line 635: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

631: --
632: --
633: -- Start code for Bugfix 4070732
634: --
635: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
636: THEN
637: --{
638: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
639: --{

Line 638: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

634: --
635: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
636: THEN
637: --{
638: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
639: --{
640: IF l_debug_on THEN
641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
642: END IF;

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

637: --{
638: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
639: --{
640: IF l_debug_on THEN
641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
642: END IF;
643:
644: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
645: x_return_status => l_return_status);

Line 644: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

640: IF l_debug_on THEN
641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
642: END IF;
643:
644: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
645: x_return_status => l_return_status);
646:
647: IF l_debug_on THEN
648: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 651: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

647: IF l_debug_on THEN
648: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
649: END IF;
650:
651: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
652: x_return_status := l_return_status;
653: END IF;
654: --}
655: END IF;

Line 700: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

696: --
697: --
698: -- Start code for Bugfix 4070732
699: --
700: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
701: THEN
702: --{
703: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
704: --{

Line 703: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

699: --
700: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
701: THEN
702: --{
703: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
704: --{
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
707: END IF;

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

702: --{
703: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
704: --{
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
707: END IF;
708:
709: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
710: x_return_status => l_return_status);

Line 709: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

705: IF l_debug_on THEN
706: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
707: END IF;
708:
709: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
710: x_return_status => l_return_status);
711:
712: IF l_debug_on THEN
713: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 729: x_return_status := wsh_util_core.g_ret_sts_error;

725: END IF;
726: --
727: WHEN invalid_doc_direction
728: THEN
729: x_return_status := wsh_util_core.g_ret_sts_error;
730: --
731: -- K LPN CONV. rv
732: --
733: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 753: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

749: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
750: END IF;
751: --
752: --
753: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
754: x_return_status := l_return_status;
755: END IF;
756: --
757: --}

Line 765: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

761: --
762:
763: -- Start code for Bugfix 4070732
764: --
765: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
766: THEN
767: --{
768: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
769: --{

Line 768: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

764: --
765: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
766: THEN
767: --{
768: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
769: --{
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
772: END IF;

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

767: --{
768: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
769: --{
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
772: END IF;
773:
774: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
775: x_return_status => l_return_status);

Line 774: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
772: END IF;
773:
774: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
775: x_return_status => l_return_status);
776:
777: IF l_debug_on THEN
778: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 781: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

777: IF l_debug_on THEN
778: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
779: END IF;
780:
781: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
782: x_return_status := l_return_status;
783: END IF;
784: --}
785: END IF;

Line 799: x_return_status := wsh_util_core.g_ret_sts_error;

795: END IF;
796: wsh_debug_sv.stop_debug;
797: WHEN invalid_doc_type
798: THEN
799: x_return_status := wsh_util_core.g_ret_sts_error;
800:
801: --
802: -- K LPN CONV. rv
803: --

Line 824: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

820: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
821: END IF;
822: --
823: --
824: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
825: x_return_status := l_return_status;
826: END IF;
827: --
828: --}

Line 836: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

832: --
833: --
834: -- Start code for Bugfix 4070732
835: --
836: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
837: THEN
838: --{
839: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
840: --{

Line 839: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

835: --
836: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
837: THEN
838: --{
839: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
840: --{
841: IF l_debug_on THEN
842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
843: END IF;

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

838: --{
839: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
840: --{
841: IF l_debug_on THEN
842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
843: END IF;
844:
845: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
846: x_return_status => l_return_status);

Line 845: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

841: IF l_debug_on THEN
842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
843: END IF;
844:
845: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
846: x_return_status => l_return_status);
847:
848: IF l_debug_on THEN
849: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 852: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

848: IF l_debug_on THEN
849: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
850: END IF;
851:
852: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
853: x_return_status := l_return_status;
854: END IF;
855: --}
856: END IF;

Line 870: x_return_status := wsh_util_core.g_ret_sts_error;

866: END IF;
867: wsh_debug_sv.stop_debug;
868: WHEN invalid_action_type
869: THEN
870: x_return_status := wsh_util_core.g_ret_sts_error;
871: --
872: -- K LPN CONV. rv
873: --
874: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

Line 894: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

890: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
891: END IF;
892: --
893: --
894: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
895: x_return_status := l_return_status;
896: END IF;
897: --
898: --}

Line 907: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

903:
904: --
905: -- Start code for Bugfix 4070732
906: --
907: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
908: THEN
909: --{
910: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
911: --{

Line 910: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

906: --
907: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
908: THEN
909: --{
910: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
911: --{
912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
914: END IF;

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

909: --{
910: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
911: --{
912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
914: END IF;
915:
916: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
917: x_return_status => l_return_status);

Line 916: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
914: END IF;
915:
916: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
917: x_return_status => l_return_status);
918:
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 923: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

919: IF l_debug_on THEN
920: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
921: END IF;
922:
923: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
924: x_return_status := l_return_status;
925: END IF;
926: --}
927: END IF;

Line 941: x_return_status := wsh_util_core.g_ret_sts_error;

937: END IF;
938: wsh_debug_sv.stop_debug;
939: WHEN invalid_entity_type
940: THEN
941: x_return_status := wsh_util_core.g_ret_sts_error;
942:
943: --
944: -- K LPN CONV. rv
945: --

Line 966: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

962: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
963: END IF;
964: --
965: --
966: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
967: x_return_status := l_return_status;
968: END IF;
969: --
970: --}

Line 978: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)

974: --
975: --
976: -- Start code for Bugfix 4070732
977: --
978: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
979: THEN
980: --{
981: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
982: --{

Line 981: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

977: --
978: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
979: THEN
980: --{
981: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
982: --{
983: IF l_debug_on THEN
984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
985: END IF;

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

980: --{
981: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
982: --{
983: IF l_debug_on THEN
984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
985: END IF;
986:
987: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
988: x_return_status => l_return_status);

Line 987: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

983: IF l_debug_on THEN
984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
985: END IF;
986:
987: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
988: x_return_status => l_return_status);
989:
990: IF l_debug_on THEN
991: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 994: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

990: IF l_debug_on THEN
991: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
992: END IF;
993:
994: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
995: x_return_status := l_return_status;
996: END IF;
997: --}
998: END IF;

Line 1048: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

1044: --
1045: --
1046: -- Start code for Bugfix 4070732
1047: --
1048: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1049: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1052: END IF;

Line 1049: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1045: --
1046: -- Start code for Bugfix 4070732
1047: --
1048: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1049: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1052: END IF;
1053:

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

1047: --
1048: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1049: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1052: END IF;
1053:
1054: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1055: x_return_status => l_return_status);

Line 1054: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,

1050: IF l_debug_on THEN
1051: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1052: END IF;
1053:
1054: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1055: x_return_status => l_return_status);
1056:
1057:
1058: IF l_debug_on THEN

Line 1304: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1300: IF l_debug_on THEN
1301: wsh_debug_sv.log (l_module_name,'Status after validate_org',x_return_status);
1302: END IF;
1303:
1304: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1305: THEN
1306: interface_errors_rec.p_token1 := 'Organization_Code';
1307: interface_errors_rec.p_value1 := delivery_rec.organization_code;
1308: l_d_temp_status := 'INVALID';

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

1319: wsh_debug_sv.log (l_module_name, 'Return status from get warehouse type', l_return_status);
1320: wsh_debug_sv.log (l_module_name, 'Warehouse type ', l_warehouse_type);
1321: END IF;
1322:
1323: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1324: raise get_warehouse_type_failed;
1325: END IF;
1326:
1327:

Line 1357: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1353: IF l_debug_on THEN
1354: wsh_debug_sv.log (l_module_name,'Status after Initial_pickup_location ',x_return_status);
1355: END IF;
1356:
1357: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1358: THEN
1359: interface_errors_rec.p_token2 := 'Initial Pickup Location Code';
1360: interface_errors_rec.p_value2 := delivery_rec.initial_pickup_location_code;
1361: l_d_temp_status := 'INVALID';

Line 1371: l_ou_org_id := WSH_UTIL_CORE.Get_Operating_Unit (p_organization_id => l_org_id);

1367: wsh_debug_sv.log (l_module_name, 'Validating Customer Name');
1368: END IF;
1369:
1370: --Calling Get_Operating_Unit to get the org_id of the organization_id
1371: l_ou_org_id := WSH_UTIL_CORE.Get_Operating_Unit (p_organization_id => l_org_id);
1372: --Set the Policy Context before calling OM API
1373: MO_GLOBAL.set_policy_context('S', l_ou_org_id);
1374:
1375: IF ( delivery_rec.customer_name is not null )

Line 1394: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1390: --
1391:
1392: IF nvl(l_customer_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
1393: l_customer_id := null;
1394: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1395: THEN
1396: interface_errors_rec.p_token3 := 'Customer Name';
1397: interface_errors_rec.p_value3 := delivery_rec.customer_name;
1398: l_d_temp_status := 'INVALID';

Line 1429: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1425: WSH_DEBUG_SV.logmsg(l_module_name, 'l_ship_to_cust_id = '||l_ship_to_cust_id, WSH_DEBUG_SV.C_PROC_LEVEL);
1426:
1427: IF nvl(l_ship_to_cust_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
1428: l_ship_to_cust_id := null;
1429: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1430: THEN
1431: interface_errors_rec.p_token3 := 'Ship To Customer Name';
1432: interface_errors_rec.p_value3 := delivery_rec.ship_to_customer_name;
1433: l_d_temp_status := 'INVALID';

Line 1469: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1465: END IF;
1466: IF ( nvl(l_ship_to_site_use_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM )
1467: THEN
1468: l_ship_to_site_use_id := null;
1469: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1470: THEN
1471: interface_errors_rec.p_token3 := 'Ship To Address';
1472: interface_errors_rec.p_value3 := delivery_rec.ship_to_address1;
1473: l_d_temp_status := 'INVALID';

Line 1479: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE',

1475: END IF;
1476: END IF;
1477:
1478: IF l_ship_to_site_use_id is not null THEN
1479: WSH_UTIL_CORE.GET_LOCATION_ID('CUSTOMER SITE',
1480: l_ship_to_site_use_id,
1481: l_ultimate_dropoff_location_id,
1482: l_return_status);
1483: IF l_debug_on THEN

Line 1567: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN

1563: IF l_debug_on THEN
1564: wsh_debug_sv.log (l_module_name,'Status after Intmed_ship_to_location_code',x_return_status);
1565: END IF;
1566:
1567: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1568: interface_errors_rec.p_token2 := 'Intmed_Ship_To_Location_Code';
1569: interface_errors_rec.p_value2 := delivery_rec.intmed_ship_to_location_code;
1570: l_d_temp_status := 'INVALID';
1571: END IF;

Line 1593: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1589: IF l_debug_on THEN
1590: wsh_debug_sv.log (l_module_name,'Status after ultimate_dropoff_location ',x_return_status);
1591: END IF;
1592:
1593: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1594: THEN
1595: interface_errors_rec.p_token5 := 'Ultimate Dropoff Location Code';
1596: interface_errors_rec.p_value5 := delivery_rec.ultimate_dropoff_location_code;
1597: l_d_temp_status := 'INVALID';

Line 1664: IF (x_return_status = wsh_util_core.g_ret_sts_error)

1660: wsh_debug_sv.log (l_module_name, 'Derived Org id', l_det_org_id);
1661: wsh_debug_sv.log (l_module_name, 'Status after validate org for detail',x_return_status);
1662: END IF;
1663:
1664: IF (x_return_status = wsh_util_core.g_ret_sts_error)
1665: THEN
1666: interface_errors_rec.p_token1 := 'Organization Code';
1667: interface_errors_rec.p_value1 :=delivery_detail_rec.organization_code;
1668: l_dd_temp_status := 'INVALID';

Line 1706: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then

1702: wsh_debug_sv.log (l_module_name, 'Return status after validate item',X_Return_Status);
1703: wsh_debug_sv.log (l_module_name, 'Item Number', Delivery_Detail_Rec.Item_Number);
1704: wsh_debug_sv.log (l_module_name, 'Derived Item Id', L_Inventory_Item_ID);
1705: END IF;
1706: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then
1707: Interface_Errors_rec.P_token2 := 'Item Number';
1708: Interface_Errors_rec.P_value2 := Delivery_Detail_Rec.Item_Number;
1709: L_DD_Temp_Status := 'INVALID';
1710: End If;

Line 1719: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then

1715: L_Det_org_ID,
1716: L_Seg_Array,
1717: X_Return_Status);
1718:
1719: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then
1720: Interface_Errors_rec.P_token3 := 'Customer Item Number';
1721: Interface_Errors_rec.P_value3 := Delivery_Detail_Rec.Customer_Item_Number;
1722: L_DD_Temp_Status := 'INVALID';
1723: End If; */

Line 1739: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then

1735: wsh_debug_sv.log (l_module_name, 'Return status after Validate Locator Code',X_Return_Status);
1736: wsh_debug_sv.log (l_module_name, 'Locator Code', Delivery_Detail_Rec.Locator_code);
1737: wsh_debug_sv.log (l_module_name, 'Derived Locator Id', l_locator_id);
1738: END IF;
1739: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then
1740: Interface_Errors_rec.P_token3 := 'Locator Code';
1741: Interface_Errors_rec.P_value3 := Delivery_Detail_Rec.Locator_code;
1742: l_loc_temp_status := 'INVALID';
1743: End If;

Line 1756: IF (x_return_status = wsh_util_core.g_ret_sts_error)

1752: l_ship_from_location_id,
1753: delivery_detail_rec.ship_from_location_code,
1754: x_return_status);
1755:
1756: IF (x_return_status = wsh_util_core.g_ret_sts_error)
1757: THEN
1758: interface_errors_rec.p_token4 := 'Ship From Location Code';
1759: interface_errors_rec.p_value4 := delivery_detail_rec.ship_from_location_code;
1760: l_dd_temp_status := 'INVALID';

Line 1795: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN

1791: IF l_debug_on THEN
1792: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1793: END IF;
1794:
1795: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1796: interface_errors_rec.p_token5 := 'Ship To Location Code';
1797: interface_errors_rec.p_value5 := delivery_detail_rec.ship_to_location_code;
1798: l_dd_temp_status := 'INVALID';
1799: END IF;

Line 1819: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN

1815:
1816: IF l_debug_on THEN
1817: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1818: END IF;
1819: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1820: interface_errors_rec.p_token6 := 'IntMed ShipTo Location Code';
1821: interface_errors_rec.p_value6 := delivery_detail_rec.intmed_ship_to_location_code;
1822: l_dd_temp_status := 'INVALID';
1823: END IF;

Line 1847: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN

1843: IF l_debug_on THEN
1844: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1845: END IF;
1846:
1847: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1848: interface_errors_rec.p_token7 := 'Deliver To Location Code';
1849: interface_errors_rec.p_value7 := delivery_detail_rec.deliver_to_location_code;
1850: l_dd_temp_status := 'INVALID';
1851: END IF;

Line 1860: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1856: wsh_util_validate.validate_customer(l_det_customer_id,
1857: delivery_detail_rec.customer_number,
1858: x_return_status);
1859:
1860: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1861: THEN
1862: interface_errors_rec.p_token8 := 'Customer Number';
1863: interface_errors_rec.p_value8 := delivery_detail_rec.customer_number;
1864: l_dd_temp_status := 'INVALID';

Line 1882: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1878: p_inventory_item_id => l_inventory_item_id,
1879: x_return_status => x_return_status,
1880: x_result => x_result);
1881:
1882: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1883: THEN
1884: interface_errors_rec.p_token9 := 'Subinventory';
1885: interface_errors_rec.p_value9 := delivery_detail_rec.subinventory;
1886: l_dd_temp_status := 'INVALID';

Line 1899: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1895: x_return_status,
1896: x_result
1897: );
1898:
1899: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1900: THEN
1901: interface_errors_rec.p_token10 := 'Revision';
1902: interface_errors_rec.p_value10 := delivery_detail_rec.revision;
1903: l_dd_temp_status := 'INVALID';

Line 1918: IF (x_return_status <> wsh_util_core.g_ret_sts_success)

1914: p_locator_id => delivery_detail_rec.locator_id,
1915: x_return_status => x_return_status,
1916: x_result => x_result);
1917:
1918: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1919: THEN
1920: interface_errors_rec.p_token11 := 'Lot Number';
1921: interface_errors_rec.p_value11 := delivery_detail_rec.lot_number;
1922: l_dd_temp_status := 'INVALID';

Line 1996: x_return_status := wsh_util_core.g_ret_sts_success;

1992: END LOOP;
1993:
1994: IF (l_dd_temp_status <> 'INVALID') AND (l_d_temp_status <> 'INVALID')
1995: THEN
1996: x_return_status := wsh_util_core.g_ret_sts_success;
1997: ELSE
1998: x_return_status := wsh_util_core.g_ret_sts_error;
1999: END IF;
2000:

Line 1998: x_return_status := wsh_util_core.g_ret_sts_error;

1994: IF (l_dd_temp_status <> 'INVALID') AND (l_d_temp_status <> 'INVALID')
1995: THEN
1996: x_return_status := wsh_util_core.g_ret_sts_success;
1997: ELSE
1998: x_return_status := wsh_util_core.g_ret_sts_error;
1999: END IF;
2000:
2001: wsh_debug_sv.pop (l_module_name);
2002: EXCEPTION

Line 2007: x_return_status := wsh_util_core.g_ret_sts_error;

2003: WHEN invalid_delivery_name THEN
2004: IF(dlvy_id_cur%ISOPEN) THEN
2005: CLOSE dlvy_id_cur;
2006: END IF;
2007: x_return_status := wsh_util_core.g_ret_sts_error;
2008: IF l_debug_on THEN
2009: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2010: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_name');
2011: END IF;

Line 2014: x_return_status := wsh_util_core.g_ret_sts_error;

2010: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_name');
2011: END IF;
2012:
2013: WHEN invalid_delivery_int_id THEN
2014: x_return_status := wsh_util_core.g_ret_sts_error;
2015: IF l_debug_on THEN
2016: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_int_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2017: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_int_id');
2018: END IF;

Line 2023: x_return_status := wsh_util_core.g_ret_sts_error;

2019: WHEN invalid_locator THEN
2020: IF Get_Inv_Controls%ISOPEN THEN
2021: CLOSE Get_Inv_Controls;
2022: END IF;
2023: x_return_status := wsh_util_core.g_ret_sts_error;
2024: IF l_debug_on THEN
2025: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_locator exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_locator');
2027: END IF;

Line 2029: x_return_status := wsh_util_core.g_ret_sts_error;

2025: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_locator exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_locator');
2027: END IF;
2028: WHEN invalid_customer_name THEN
2029: x_return_status := wsh_util_core.g_ret_sts_error;
2030: IF l_debug_on THEN
2031: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_customer_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2032: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_customer_name');
2033: END IF;

Line 2035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2031: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_customer_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2032: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_customer_name');
2033: END IF;
2034: WHEN get_warehouse_type_failed THEN
2035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2036: IF l_debug_on THEN
2037: WSH_DEBUG_SV.logmsg(l_module_name,'get_warehouse_type_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2038: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:get_warehouse_type_failed');
2039: END IF;

Line 2044: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2040: WHEN OTHERS THEN
2041: IF Get_Inv_Controls%ISOPEN THEN
2042: CLOSE Get_Inv_Controls;
2043: END IF;
2044: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2045: IF l_debug_on THEN
2046: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2047: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2048: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2180: x_return_status := wsh_util_core.g_ret_sts_success;

2176: DELETE wsh_freight_costs_interface
2177: WHERE delivery_interface_id = p_delivery_interface_id
2178: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
2179:
2180: x_return_status := wsh_util_core.g_ret_sts_success;
2181: ELSE -- IF Delivery Doesnot exists
2182: RAISE invalid_delivery;
2183: END IF;
2184:

Line 2189: x_return_status := wsh_util_core.g_ret_sts_error;

2185: wsh_debug_sv.pop (l_module_name);
2186: EXCEPTION
2187: WHEN invalid_delivery
2188: THEN
2189: x_return_status := wsh_util_core.g_ret_sts_error;
2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
2193: END IF;

Line 2196: x_return_status := wsh_util_core.g_ret_sts_error;

2192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
2193: END IF;
2194: WHEN invalid_delete
2195: THEN
2196: x_return_status := wsh_util_core.g_ret_sts_error;
2197: IF l_debug_on THEN
2198: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delete exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2199: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delete');
2200: END IF;

Line 2203: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2199: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delete');
2200: END IF;
2201: WHEN OTHERS
2202: THEN
2203: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2206: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2222: p_del_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,

2218:
2219: =======================================================================================*/
2220:
2221: PROCEDURE delete_interface_records (
2222: p_del_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2223: p_del_det_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2224: p_del_assgn_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2225: p_del_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2226: p_det_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,

Line 2223: p_del_det_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,

2219: =======================================================================================*/
2220:
2221: PROCEDURE delete_interface_records (
2222: p_del_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2223: p_del_det_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2224: p_del_assgn_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2225: p_del_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2226: p_det_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2227: x_return_status OUT NOCOPY VARCHAR2

Line 2224: p_del_assgn_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,

2220:
2221: PROCEDURE delete_interface_records (
2222: p_del_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2223: p_del_det_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2224: p_del_assgn_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2225: p_del_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2226: p_det_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2227: x_return_status OUT NOCOPY VARCHAR2
2228: )

Line 2225: p_del_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,

2221: PROCEDURE delete_interface_records (
2222: p_del_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2223: p_del_det_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2224: p_del_assgn_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2225: p_del_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2226: p_det_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2227: x_return_status OUT NOCOPY VARCHAR2
2228: )
2229: IS

Line 2226: p_det_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,

2222: p_del_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2223: p_del_det_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2224: p_del_assgn_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2225: p_del_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2226: p_det_error_interface_id_tbl IN WSH_UTIL_CORE.Id_Tab_Type,
2227: x_return_status OUT NOCOPY VARCHAR2
2228: )
2229: IS
2230: l_debug_on BOOLEAN;

Line 2251: x_return_status := wsh_util_core.g_ret_sts_success;

2247: wsh_debug_sv.log ( l_module_name, 'p_del_error_interface_id_tbl.COUNT', p_del_error_interface_id_tbl.COUNT);
2248: wsh_debug_sv.log ( l_module_name, 'p_det_error_interface_id_tbl.COUNT', p_det_error_interface_id_tbl.COUNT);
2249: END IF;
2250:
2251: x_return_status := wsh_util_core.g_ret_sts_success;
2252: --
2253: IF (p_det_error_interface_id_tbl.COUNT > 0) THEN
2254: FORALL i in p_det_error_interface_id_tbl.FIRST..p_det_error_interface_id_tbl.LAST
2255: DELETE FROM wsh_interface_errors

Line 2315: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

2311: END IF;
2312: --
2313: EXCEPTION
2314: WHEN OTHERS THEN
2315: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2316: --
2317: IF l_debug_on THEN
2318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2319: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);