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 113: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null

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

Line 115: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;

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

Line 116: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;

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

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

207: IF l_debug_on THEN
208: wsh_debug_sv.log (l_module_name,'After Calling Derive IDS l_return_status',l_return_status);
209: END IF;
210:
211: IF (l_return_status = wsh_util_core.g_ret_sts_success) THEN
212:
213: IF (l_trns_history_rec.document_type = 'SR') THEN
214:
215: wsh_inbound_ship_request_pkg.process_ship_request (

Line 245: IF (t_return_status = wsh_util_core.g_ret_sts_success)

241: END IF;
242:
243: x_return_status := t_return_status;
244:
245: IF (t_return_status = wsh_util_core.g_ret_sts_success)
246: THEN --{
247:
248: IF (l_trns_history_rec.document_type = 'SA') THEN --{
249: --k proj

Line 337: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

333: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
334: END IF;
335: --
336: --
337: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: ELSE

Line 339: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

335: --
336: --
337: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: ELSE
342: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
343: wsh_util_core.g_ret_sts_success

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

338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: ELSE
342: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
343: wsh_util_core.g_ret_sts_success
344: THEN
345: x_return_status := l_return_status;
346: END IF;

Line 343: wsh_util_core.g_ret_sts_success

339: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: ELSE
342: IF NVL(x_return_status,wsh_util_core.g_ret_sts_success) =
343: wsh_util_core.g_ret_sts_success
344: THEN
345: x_return_status := l_return_status;
346: END IF;
347: END IF;

Line 360: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

356: -- Added on Mar 29th
357: --
358: -- Start code for Bugfix 4070732
359: --
360: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
361: --{
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
364: END IF;

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

359: --
360: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
361: --{
362: IF l_debug_on THEN
363: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
364: END IF;
365:
366: l_reset_flags := FALSE;
367:

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

364: END IF;
365:
366: l_reset_flags := FALSE;
367:
368: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
369: x_return_status => l_return_status);
370:
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 375: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
373: END IF;
374:
375: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
376: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 376: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

372: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
373: END IF;
374:
375: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
376: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;

Line 378: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

374:
375: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
376: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
377: RAISE FND_API.G_EXC_ERROR;
378: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: --}
382: END IF;

Line 390: x_return_status := wsh_util_core.g_ret_sts_error;

386:
387: COMMIT;
388:
389: ELSE
390: x_return_status := wsh_util_core.g_ret_sts_error;
391: -- Derive_ids returned error. Some validation has failed.
392: --Need to update the status to Error. Otherwise, status will continue to 'IP'
393: UPDATE wsh_transactions_history
394: SET transaction_status = 'ER'

Line 415: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

411: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
412: END IF;
413: --
414: --
415: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: --ELSE

Line 417: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

413: --
414: --
415: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
416: RAISE FND_API.G_EXC_ERROR;
417: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
419: --ELSE
420: --x_return_status := l_return_status;
421: END IF;

Line 428: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

424: --
425: --
426: -- Start code for Bugfix 4070732
427: --
428: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
429: --{
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;

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

427: --
428: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
429: --{
430: IF l_debug_on THEN
431: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
432: END IF;
433:
434: l_reset_flags := FALSE;
435:

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

432: END IF;
433:
434: l_reset_flags := FALSE;
435:
436: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
437: x_return_status => l_return_status);
438:
439: IF l_debug_on THEN
440: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 443: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

439: IF l_debug_on THEN
440: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
441: END IF;
442:
443: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
444: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 444: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

440: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
441: END IF;
442:
443: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
444: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;

Line 446: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

442:
443: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
444: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449: --}
450: END IF;

Line 459: x_return_status := wsh_util_core.g_ret_sts_error;

455:
456: END IF; -- End of IF (L_Return_Status ....
457:
458: ELSE -- if Not Null Check failed.
459: x_return_status := wsh_util_core.g_ret_sts_error;
460: END IF; -- Check for Null Values.
461:
462: END IF; -- End of (IF Entity_Type = 'DLVY_INT') ...
463:

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

463:
464:
465: --bug 4070732
466: --End of the API handling of calls to process_stops_for_load_tender
467: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
468: THEN
469: --{
470: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
471: --{

Line 470: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

466: --End of the API handling of calls to process_stops_for_load_tender
467: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
468: THEN
469: --{
470: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
471: --{
472: l_reset_flags := TRUE;
473:
474: IF l_debug_on THEN

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

471: --{
472: l_reset_flags := TRUE;
473:
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
476: END IF;
477:
478: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
479: x_return_status => l_return_status);

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

474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
476: END IF;
477:
478: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => l_reset_flags,
479: x_return_status => l_return_status);
480:
481: IF l_debug_on THEN
482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 486: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

482: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
483: END IF;
484:
485: IF (
486: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
487: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
488: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
490: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,

Line 487: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

483: END IF;
484:
485: IF (
486: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
487: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
488: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
490: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
491: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )

Line 488: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

484:
485: IF (
486: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
487: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
488: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
490: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
491: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )
492: )

Line 489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

485: IF (
486: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
487: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
488: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
490: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
491: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )
492: )
493: THEN

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

486: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
487: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
488: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
490: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
491: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )
492: )
493: THEN
494: --{

Line 491: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )

487: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
488: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
489: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
490: AND x_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
491: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )
492: )
493: THEN
494: --{
495: x_return_status := l_return_status;

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

534: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
535: END IF;
536: --
537: --
538: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
539: x_return_status := l_return_status;
540: END IF;
541: --
542: --}

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

546: --
547: --
548: -- Start code for Bugfix 4070732
549: --
550: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
551: THEN
552: --{
553: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
554: --{

Line 553: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

549: --
550: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
551: THEN
552: --{
553: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
554: --{
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
557: END IF;

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

552: --{
553: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
554: --{
555: IF l_debug_on THEN
556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
557: END IF;
558:
559: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
560: x_return_status => l_return_status);

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

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

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

562: IF l_debug_on THEN
563: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
564: END IF;
565:
566: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
567: x_return_status := l_return_status;
568: END IF;
569: --}
570: END IF;

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

611: --
612: --
613: -- Start code for Bugfix 4070732
614: --
615: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
616: THEN
617: --{
618: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
619: --{

Line 618: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

614: --
615: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
616: THEN
617: --{
618: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
619: --{
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
622: END IF;

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

617: --{
618: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
619: --{
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
622: END IF;
623:
624: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
625: x_return_status => l_return_status);

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

620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
622: END IF;
623:
624: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
625: x_return_status => l_return_status);
626:
627: IF l_debug_on THEN
628: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 644: x_return_status := wsh_util_core.g_ret_sts_error;

640: END IF;
641: --
642: WHEN invalid_doc_direction
643: THEN
644: x_return_status := wsh_util_core.g_ret_sts_error;
645: --
646: -- K LPN CONV. rv
647: --
648: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

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

664: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
665: END IF;
666: --
667: --
668: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
669: x_return_status := l_return_status;
670: END IF;
671: --
672: --}

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

676: --
677:
678: -- Start code for Bugfix 4070732
679: --
680: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
681: THEN
682: --{
683: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
684: --{

Line 683: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

679: --
680: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
681: THEN
682: --{
683: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
684: --{
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
687: END IF;

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

682: --{
683: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
684: --{
685: IF l_debug_on THEN
686: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
687: END IF;
688:
689: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
690: x_return_status => l_return_status);

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

685: IF l_debug_on THEN
686: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
687: END IF;
688:
689: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
690: x_return_status => l_return_status);
691:
692: IF l_debug_on THEN
693: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

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

692: IF l_debug_on THEN
693: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
694: END IF;
695:
696: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
697: x_return_status := l_return_status;
698: END IF;
699: --}
700: END IF;

Line 714: x_return_status := wsh_util_core.g_ret_sts_error;

710: END IF;
711: wsh_debug_sv.stop_debug;
712: WHEN invalid_doc_type
713: THEN
714: x_return_status := wsh_util_core.g_ret_sts_error;
715:
716: --
717: -- K LPN CONV. rv
718: --

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

735: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
736: END IF;
737: --
738: --
739: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
740: x_return_status := l_return_status;
741: END IF;
742: --
743: --}

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

747: --
748: --
749: -- Start code for Bugfix 4070732
750: --
751: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
752: THEN
753: --{
754: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
755: --{

Line 754: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

750: --
751: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
752: THEN
753: --{
754: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
755: --{
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
758: END IF;

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

753: --{
754: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
755: --{
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
758: END IF;
759:
760: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
761: x_return_status => l_return_status);

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

756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
758: END IF;
759:
760: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
761: x_return_status => l_return_status);
762:
763: IF l_debug_on THEN
764: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

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

763: IF l_debug_on THEN
764: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
765: END IF;
766:
767: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
768: x_return_status := l_return_status;
769: END IF;
770: --}
771: END IF;

Line 785: x_return_status := wsh_util_core.g_ret_sts_error;

781: END IF;
782: wsh_debug_sv.stop_debug;
783: WHEN invalid_action_type
784: THEN
785: x_return_status := wsh_util_core.g_ret_sts_error;
786: --
787: -- K LPN CONV. rv
788: --
789: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'

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

805: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
806: END IF;
807: --
808: --
809: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
810: x_return_status := l_return_status;
811: END IF;
812: --
813: --}

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

818:
819: --
820: -- Start code for Bugfix 4070732
821: --
822: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
823: THEN
824: --{
825: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
826: --{

Line 825: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

821: --
822: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
823: THEN
824: --{
825: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
826: --{
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
829: END IF;

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

824: --{
825: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
826: --{
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
829: END IF;
830:
831: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
832: x_return_status => l_return_status);

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

827: IF l_debug_on THEN
828: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
829: END IF;
830:
831: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
832: x_return_status => l_return_status);
833:
834: IF l_debug_on THEN
835: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

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

834: IF l_debug_on THEN
835: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
836: END IF;
837:
838: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
839: x_return_status := l_return_status;
840: END IF;
841: --}
842: END IF;

Line 856: x_return_status := wsh_util_core.g_ret_sts_error;

852: END IF;
853: wsh_debug_sv.stop_debug;
854: WHEN invalid_entity_type
855: THEN
856: x_return_status := wsh_util_core.g_ret_sts_error;
857:
858: --
859: -- K LPN CONV. rv
860: --

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

877: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
878: END IF;
879: --
880: --
881: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
882: x_return_status := l_return_status;
883: END IF;
884: --
885: --}

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

889: --
890: --
891: -- Start code for Bugfix 4070732
892: --
893: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
894: THEN
895: --{
896: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
897: --{

Line 896: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

892: --
893: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
894: THEN
895: --{
896: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
897: --{
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
900: END IF;

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

895: --{
896: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
897: --{
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
900: END IF;
901:
902: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
903: x_return_status => l_return_status);

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

898: IF l_debug_on THEN
899: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
900: END IF;
901:
902: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
903: x_return_status => l_return_status);
904:
905: IF l_debug_on THEN
906: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

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

905: IF l_debug_on THEN
906: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
907: END IF;
908:
909: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
910: x_return_status := l_return_status;
911: END IF;
912: --}
913: END IF;

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

959: --
960: --
961: -- Start code for Bugfix 4070732
962: --
963: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
964: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
967: END IF;

Line 964: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

960: --
961: -- Start code for Bugfix 4070732
962: --
963: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
964: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
967: END IF;
968:

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

962: --
963: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
964: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
967: END IF;
968:
969: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
970: x_return_status => l_return_status);

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

965: IF l_debug_on THEN
966: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
967: END IF;
968:
969: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
970: x_return_status => l_return_status);
971:
972:
973: IF l_debug_on THEN

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

1165: IF l_debug_on THEN
1166: wsh_debug_sv.log (l_module_name,'Status after validate_org',x_return_status);
1167: END IF;
1168:
1169: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1170: THEN
1171: interface_errors_rec.p_token1 := 'Organization_Code';
1172: interface_errors_rec.p_value1 := delivery_rec.organization_code;
1173: l_d_temp_status := 'INVALID';

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

1266: IF l_debug_on THEN
1267: wsh_debug_sv.log (l_module_name,'Status after Intmed_ship_to_location_code',x_return_status);
1268: END IF;
1269:
1270: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1271: interface_errors_rec.p_token2 := 'Intmed_Ship_To_Location_Code';
1272: interface_errors_rec.p_value2 := delivery_rec.intmed_ship_to_location_code;
1273: l_d_temp_status := 'INVALID';
1274: END IF;

Line 1284: IF (x_return_status = wsh_util_core.g_ret_sts_error)

1280: IF l_debug_on THEN
1281: wsh_debug_sv.log (l_module_name,'Status after Validate Customer ',x_return_status);
1282: END IF;
1283:
1284: IF (x_return_status = wsh_util_core.g_ret_sts_error)
1285: THEN
1286: interface_errors_rec.p_token3 := 'Customer_Number';
1287: interface_errors_rec.p_value3 := delivery_rec.customer_number;
1288: l_d_temp_status := 'INVALID';

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

1297: IF l_debug_on THEN
1298: wsh_debug_sv.log (l_module_name,'Status after Initial_pickup_location ',x_return_status);
1299: END IF;
1300:
1301: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1302: THEN
1303: interface_errors_rec.p_token4 := 'Initial Pickup Location Code';
1304: interface_errors_rec.p_value4 := delivery_rec.initial_pickup_location_code;
1305: l_d_temp_status := 'INVALID';

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

1323: IF l_debug_on THEN
1324: wsh_debug_sv.log (l_module_name,'Status after ultimate_dropoff_location ',x_return_status);
1325: END IF;
1326:
1327: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1328: THEN
1329: interface_errors_rec.p_token5 := 'Ultimate Dropoff Location Code';
1330: interface_errors_rec.p_value5 := delivery_rec.ultimate_dropoff_location_code;
1331: l_d_temp_status := 'INVALID';

Line 1387: IF (x_return_status = wsh_util_core.g_ret_sts_error)

1383: wsh_debug_sv.log (l_module_name, 'Derived Org id', l_det_org_id);
1384: wsh_debug_sv.log (l_module_name, 'Status after validate org for detail',x_return_status);
1385: END IF;
1386:
1387: IF (x_return_status = wsh_util_core.g_ret_sts_error)
1388: THEN
1389: interface_errors_rec.p_token1 := 'Organization Code';
1390: interface_errors_rec.p_value1 :=delivery_detail_rec.organization_code;
1391: l_dd_temp_status := 'INVALID';

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

1425: wsh_debug_sv.log (l_module_name, 'Return status after validate item',X_Return_Status);
1426: wsh_debug_sv.log (l_module_name, 'Item Number', Delivery_Detail_Rec.Item_Number);
1427: wsh_debug_sv.log (l_module_name, 'Derived Item Id', L_Inventory_Item_ID);
1428: END IF;
1429: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then
1430: Interface_Errors_rec.P_token2 := 'Item Number';
1431: Interface_Errors_rec.P_value2 := Delivery_Detail_Rec.Item_Number;
1432: L_DD_Temp_Status := 'INVALID';
1433: End If;

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

1438: L_Det_org_ID,
1439: L_Seg_Array,
1440: X_Return_Status);
1441:
1442: IF (x_return_status <> WSH_UTIL_CORE.g_ret_sts_success) Then
1443: Interface_Errors_rec.P_token3 := 'Customer Item Number';
1444: Interface_Errors_rec.P_value3 := Delivery_Detail_Rec.Customer_Item_Number;
1445: L_DD_Temp_Status := 'INVALID';
1446: End If; */

Line 1454: IF (x_return_status = wsh_util_core.g_ret_sts_error)

1450: l_ship_from_location_id,
1451: delivery_detail_rec.ship_from_location_code,
1452: x_return_status);
1453:
1454: IF (x_return_status = wsh_util_core.g_ret_sts_error)
1455: THEN
1456: interface_errors_rec.p_token4 := 'Ship From Location Code';
1457: interface_errors_rec.p_value4 := delivery_detail_rec.ship_from_location_code;
1458: l_dd_temp_status := 'INVALID';

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

1489: IF l_debug_on THEN
1490: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1491: END IF;
1492:
1493: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1494: interface_errors_rec.p_token5 := 'Ship To Location Code';
1495: interface_errors_rec.p_value5 := delivery_detail_rec.ship_to_location_code;
1496: l_dd_temp_status := 'INVALID';
1497: END IF;

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

1513:
1514: IF l_debug_on THEN
1515: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1516: END IF;
1517: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1518: interface_errors_rec.p_token6 := 'IntMed ShipTo Location Code';
1519: interface_errors_rec.p_value6 := delivery_detail_rec.intmed_ship_to_location_code;
1520: l_dd_temp_status := 'INVALID';
1521: END IF;

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

1541: IF l_debug_on THEN
1542: wsh_debug_sv.log (l_module_name, 'Validate_Ship_To x_return_status',x_return_status );
1543: END IF;
1544:
1545: IF (x_return_status <> wsh_util_core.g_ret_sts_success) THEN
1546: interface_errors_rec.p_token7 := 'Deliver To Location Code';
1547: interface_errors_rec.p_value7 := delivery_detail_rec.deliver_to_location_code;
1548: l_dd_temp_status := 'INVALID';
1549: END IF;

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

1554: wsh_util_validate.validate_customer(l_det_customer_id,
1555: delivery_detail_rec.customer_number,
1556: x_return_status);
1557:
1558: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1559: THEN
1560: interface_errors_rec.p_token8 := 'Customer Number';
1561: interface_errors_rec.p_value8 := delivery_detail_rec.customer_number;
1562: l_dd_temp_status := 'INVALID';

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

1576: p_inventory_item_id => l_inventory_item_id,
1577: x_return_status => x_return_status,
1578: x_result => x_result);
1579:
1580: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1581: THEN
1582: interface_errors_rec.p_token9 := 'Subinventory';
1583: interface_errors_rec.p_value9 := delivery_detail_rec.subinventory;
1584: l_dd_temp_status := 'INVALID';

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

1593: x_return_status,
1594: x_result
1595: );
1596:
1597: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1598: THEN
1599: interface_errors_rec.p_token10 := 'Revision';
1600: interface_errors_rec.p_value10 := delivery_detail_rec.revision;
1601: l_dd_temp_status := 'INVALID';

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

1612: p_locator_id => delivery_detail_rec.locator_id,
1613: x_return_status => x_return_status,
1614: x_result => x_result);
1615:
1616: IF (x_return_status <> wsh_util_core.g_ret_sts_success)
1617: THEN
1618: interface_errors_rec.p_token11 := 'Lot Number';
1619: interface_errors_rec.p_value11 := delivery_detail_rec.lot_number;
1620: l_dd_temp_status := 'INVALID';

Line 1667: x_return_status := wsh_util_core.g_ret_sts_success;

1663: END LOOP;
1664:
1665: IF (l_dd_temp_status <> 'INVALID') AND (l_d_temp_status <> 'INVALID')
1666: THEN
1667: x_return_status := wsh_util_core.g_ret_sts_success;
1668: ELSE
1669: x_return_status := wsh_util_core.g_ret_sts_error;
1670: END IF;
1671:

Line 1669: x_return_status := wsh_util_core.g_ret_sts_error;

1665: IF (l_dd_temp_status <> 'INVALID') AND (l_d_temp_status <> 'INVALID')
1666: THEN
1667: x_return_status := wsh_util_core.g_ret_sts_success;
1668: ELSE
1669: x_return_status := wsh_util_core.g_ret_sts_error;
1670: END IF;
1671:
1672: wsh_debug_sv.pop (l_module_name);
1673: EXCEPTION

Line 1678: x_return_status := wsh_util_core.g_ret_sts_error;

1674: WHEN invalid_delivery_name THEN
1675: IF(dlvy_id_cur%ISOPEN) THEN
1676: CLOSE dlvy_id_cur;
1677: END IF;
1678: x_return_status := wsh_util_core.g_ret_sts_error;
1679: IF l_debug_on THEN
1680: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1681: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_name');
1682: END IF;

Line 1685: x_return_status := wsh_util_core.g_ret_sts_error;

1681: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_name');
1682: END IF;
1683:
1684: WHEN invalid_delivery_int_id THEN
1685: x_return_status := wsh_util_core.g_ret_sts_error;
1686: IF l_debug_on THEN
1687: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_int_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_int_id');
1689: END IF;

Line 1691: x_return_status := wsh_util_core.g_ret_sts_error;

1687: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery_int_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery_int_id');
1689: END IF;
1690: WHEN invalid_customer_name THEN
1691: x_return_status := wsh_util_core.g_ret_sts_error;
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_customer_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_customer_name');
1695: END IF;

Line 1697: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1693: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_customer_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1694: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_customer_name');
1695: END IF;
1696: WHEN OTHERS THEN
1697: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1700: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1701: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1804: x_return_status := wsh_util_core.g_ret_sts_success;

1800: DELETE wsh_new_del_interface
1801: WHERE delivery_interface_id = p_delivery_interface_id
1802: AND INTERFACE_ACTION_CODE = '94X_INBOUND';
1803:
1804: x_return_status := wsh_util_core.g_ret_sts_success;
1805: ELSE -- IF Delivery Doesnot exists
1806: RAISE invalid_delivery;
1807: END IF;
1808:

Line 1813: x_return_status := wsh_util_core.g_ret_sts_error;

1809: wsh_debug_sv.pop (l_module_name);
1810: EXCEPTION
1811: WHEN invalid_delivery
1812: THEN
1813: x_return_status := wsh_util_core.g_ret_sts_error;
1814: IF l_debug_on THEN
1815: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delivery exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1816: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
1817: END IF;

Line 1820: x_return_status := wsh_util_core.g_ret_sts_error;

1816: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delivery');
1817: END IF;
1818: WHEN invalid_delete
1819: THEN
1820: x_return_status := wsh_util_core.g_ret_sts_error;
1821: IF l_debug_on THEN
1822: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_delete exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1823: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delete');
1824: END IF;

Line 1827: x_return_status := wsh_util_core.g_ret_sts_unexp_error;

1823: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_delete');
1824: END IF;
1825: WHEN OTHERS
1826: THEN
1827: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
1828: IF l_debug_on THEN
1829: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1830: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1831: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');