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

Line 53: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

49: END IF;
50:
51: IF ( P_funcmode = 'RUN' ) THEN
52:
53: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
54:
55: WSH_TRANSACTIONS_TPW_UTIL.Check_Cancel_Allowed (P_item_type, P_item_key, l_Return_Status);
56: IF l_debug_on THEN
57: wsh_debug_sv.log (l_module_name, 'Return status after check_Cancel_Allowed ', l_Return_Status);

Line 60: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN

56: IF l_debug_on THEN
57: wsh_debug_sv.log (l_module_name, 'Return status after check_Cancel_Allowed ', l_Return_Status);
58: END IF;
59:
60: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN
61: X_resultout := 'COMPLETE:SUCCESS';
62: ELSE
63: X_resultout := 'COMPLETE:ERROR';
64: END IF;

Line 129: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

125: END IF;
126:
127: IF ( P_funcmode = 'RUN' ) THEN
128:
129: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
130:
131: Send_Cbod_Success (P_item_type, P_item_key, l_Return_Status);
132: IF l_debug_on THEN
133: wsh_debug_sv.log (l_module_name, 'Return status after Send_Cbod_Success ', l_Return_Status);

Line 136: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN

132: IF l_debug_on THEN
133: wsh_debug_sv.log (l_module_name, 'Return status after Send_Cbod_Success ', l_Return_Status);
134: END IF;
135:
136: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN
137: X_resultout := 'COMPLETE:SUCCESS';
138: ELSE
139: X_resultout := 'COMPLETE:ERROR';
140: END IF;

Line 206: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

202: END IF;
203:
204: IF ( P_funcmode = 'RUN' ) THEN
205:
206: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
207:
208: Send_Cbod_Failure (P_item_type, P_item_key, l_Return_Status);
209: IF l_debug_on THEN
210: wsh_debug_sv.log (l_module_name, 'Return status after Send_Cbod_Failure ', l_Return_Status);

Line 213: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN

209: IF l_debug_on THEN
210: wsh_debug_sv.log (l_module_name, 'Return status after Send_Cbod_Failure ', l_Return_Status);
211: END IF;
212:
213: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN
214: X_resultout := 'COMPLETE:SUCCESS';
215: ELSE
216: X_resultout := 'COMPLETE:ERROR';
217: END IF;

Line 282: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

278: END IF;
279:
280: IF ( P_funcmode = 'RUN' ) THEN
281:
282: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
283: Raise_Cancel_Event (P_item_type, P_item_key, l_Return_Status);
284: IF l_debug_on THEN
285: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Cancel_Event ', l_Return_Status);
286: END IF;

Line 288: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN

284: IF l_debug_on THEN
285: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Cancel_Event ', l_Return_Status);
286: END IF;
287:
288: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN
289: X_resultout := 'COMPLETE:SUCCESS';
290: ELSE
291: X_resultout := 'COMPLETE:ERROR';
292: END IF;

Line 357: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

353: END IF;
354:
355: IF ( P_funcmode = 'RUN' ) THEN
356:
357: l_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
358: Raise_Close_Event (P_item_type, P_item_key, l_Return_Status);
359: IF l_debug_on THEN
360: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Close_Event ', l_Return_Status);
361: END IF;

Line 363: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN

359: IF l_debug_on THEN
360: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Close_Event ', l_Return_Status);
361: END IF;
362:
363: IF ( l_Return_Status = WSH_UTIL_CORE.g_ret_sts_success ) THEN
364: X_resultout := 'COMPLETE:SUCCESS';
365: ELSE
366: X_resultout := 'COMPLETE:ERROR';
367: END IF;

Line 430: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

426: wsh_debug_sv.log(l_module_name, 'P_item_type',P_item_type);
427: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
428: END IF;
429:
430: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
431:
432: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
433: P_item_key,
434: 'I',

Line 442: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

438: IF l_debug_on THEN
439: wsh_debug_sv.log (l_module_name, 'Return status after Get_Txns_History ', l_Return_Status);
440: END IF;
441:
442: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
443: RAISE wsh_get_txns_hist_error;
444: END IF;
445:
446: IF l_debug_on THEN

Line 466: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

462: IF l_debug_on THEN
463: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Event ', l_Return_Status);
464: END IF;
465:
466: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
467: RAISE wsh_raise_event_error;
468: END IF;
469:
470: IF l_debug_on THEN

Line 475: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

471: wsh_debug_sv.pop(l_module_name);
472: END IF;
473: EXCEPTION
474: WHEN wsh_get_txns_hist_error THEN
475: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_txns_hist_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
479: END IF;

Line 482: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
479: END IF;
480:
481: WHEN wsh_raise_event_error THEN
482: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
483: IF l_debug_on THEN
484: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
485: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
486: END IF;

Line 489: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

485: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
486: END IF;
487:
488: WHEN OTHERS THEN
489: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
490: IF l_debug_on THEN
491: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
492: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
493: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 561: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

557: wsh_debug_sv.log(l_module_name, 'P_item_type',P_item_type);
558: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
559: END IF;
560:
561: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
562:
563: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
564: P_item_key,
565: 'I',

Line 574: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

570: IF l_debug_on THEN
571: wsh_debug_sv.log (l_module_name, 'Return status after Get_Txns_History ', l_Return_Status);
572: END IF;
573:
574: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
575: RAISE wsh_get_txns_hist_error;
576: END IF;
577:
578: -- Check if the error message is for the current WF or the Original WF

Line 630: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

626: IF l_debug_on THEN
627: wsh_debug_sv.log (l_module_name, 'After calling the Raise_Event, Status ', l_Return_Status);
628: END IF;
629:
630: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
631: RAISE wsh_raise_event_error;
632: END IF;
633:
634: IF l_debug_on THEN

Line 639: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

635: wsh_debug_sv.pop(l_module_name);
636: END IF;
637: EXCEPTION
638: WHEN wsh_get_txns_hist_error THEN
639: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
640: IF l_debug_on THEN
641: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
643: END IF;

Line 646: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
643: END IF;
644:
645: WHEN wsh_orig_txns_hist_error THEN
646: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
647: IF l_debug_on THEN
648: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
649: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
650: END IF;

Line 653: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

649: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
650: END IF;
651:
652: WHEN wsh_raise_event_error THEN
653: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
657: END IF;

Line 660: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
657: END IF;
658:
659: WHEN OTHERS THEN
660: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
661: IF l_debug_on THEN
662: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
663: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
664: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 751: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN

747: --Bugfix 4070732
748: l_api_session_name CONSTANT VARCHAR2(150) := G_PKG_NAME ||'.' || l_module_name;
749: BEGIN
750: --Bugfix 4070732
751: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
752: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
753: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
754: END IF;
755: --

Line 752: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;

748: l_api_session_name CONSTANT VARCHAR2(150) := G_PKG_NAME ||'.' || l_module_name;
749: BEGIN
750: --Bugfix 4070732
751: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
752: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
753: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
754: END IF;
755: --
756: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 753: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;

749: BEGIN
750: --Bugfix 4070732
751: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
752: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
753: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
754: END IF;
755: --
756: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
757: --

Line 770: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

766: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
767: END IF;
768:
769:
770: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
771:
772: IF ( P_item_type IS NULL OR
773: P_item_key IS NULL ) THEN
774: RAISE wsh_invalid_item_key;

Line 789: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

785: IF l_debug_on THEN
786: wsh_debug_sv.log (l_module_name, 'Return status after Get_Txns_History ', l_Return_Status);
787: END IF;
788:
789: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
790: RAISE wsh_get_txns_hist_error;
791: END IF;
792:
793: -- Get the Delivery Interface ID from wsh_new_del_interface table for the given record

Line 837: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

833: l_Return_Status );
834: IF l_debug_on THEN
835: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);
836: END IF;
837: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
838: RAISE wsh_update_history;
839: END IF;
840:
841: WSH_PROCESS_INTERFACED_PKG.delete_interface_records ( l_New_Del_Interface_ID,

Line 847: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

843: IF l_debug_on THEN
844: wsh_debug_sv.log (l_module_name, 'Return status after delete_interface_records ', l_Return_Status);
845: END IF;
846:
847: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
848: RAISE wsh_del_interface_rec;
849: END IF;
850:
851: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

Line 851: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

847: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
848: RAISE wsh_del_interface_rec;
849: END IF;
850:
851: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
852:
853: --Bugfix 4070732 {
854: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
855: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

850:
851: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
852:
853: --Bugfix 4070732 {
854: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
855: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;

Line 855: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

851: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
852:
853: --Bugfix 4070732 {
854: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
855: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859:

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

853: --Bugfix 4070732 {
854: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
855: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859:
860: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
861: x_return_status => l_return_status);

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

856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859:
860: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
861: x_return_status => l_return_status);
862:
863: IF l_debug_on THEN
864: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

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

863: IF l_debug_on THEN
864: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
865: END IF;
866:
867: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
868: x_return_status := l_return_status;
869: END IF;
870:
871: END IF;

Line 888: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

884: IF l_debug_on THEN
885: wsh_debug_sv.log (l_module_name, 'Return status after delete_interface_records ', l_Return_Status);
886: END IF;
887:
888: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
889: RAISE wsh_del_interface_rec;
890: END IF;
891:
892: l_txn_hist_record.transaction_status := 'SC';

Line 899: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

895: l_Return_Status );
896: IF l_debug_on THEN
897: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);
898: END IF;
899: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
900: RAISE wsh_update_history;
901: END IF;
902:
903: --Bugfix 4070732 {

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

900: RAISE wsh_update_history;
901: END IF;
902:
903: --Bugfix 4070732 {
904: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
905: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
906: IF l_debug_on THEN
907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
908: END IF;

Line 905: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

901: END IF;
902:
903: --Bugfix 4070732 {
904: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
905: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
906: IF l_debug_on THEN
907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
908: END IF;
909:

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

903: --Bugfix 4070732 {
904: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
905: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
906: IF l_debug_on THEN
907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
908: END IF;
909:
910: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
911: x_return_status => l_return_status);

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

906: IF l_debug_on THEN
907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
908: END IF;
909:
910: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
911: x_return_status => l_return_status);
912:
913: IF l_debug_on THEN
914: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 918: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

914: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
915: END IF;
916:
917: IF (
918: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
919: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
920: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
921: )
922: THEN

Line 919: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

915: END IF;
916:
917: IF (
918: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
919: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
920: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
921: )
922: THEN
923: --{

Line 920: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

916:
917: IF (
918: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
919: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
920: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
921: )
922: THEN
923: --{
924: x_return_status := l_return_status;

Line 926: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

922: THEN
923: --{
924: x_return_status := l_return_status;
925: --}
926: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
927: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
928: THEN
929: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
930: END IF;

Line 927: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

923: --{
924: x_return_status := l_return_status;
925: --}
926: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
927: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
928: THEN
929: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
930: END IF;
931:

Line 929: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

925: --}
926: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
927: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
928: THEN
929: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
930: END IF;
931:
932: END IF;
933: END IF;

Line 968: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

964: l_Return_Status );
965: IF l_debug_on THEN
966: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);
967: END IF;
968: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
969: RAISE wsh_update_history;
970: END IF;
971:
972:

Line 973: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

969: RAISE wsh_update_history;
970: END IF;
971:
972:
973: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
974:
975: --Bugfix 4070732 {
976: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
977: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

972:
973: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
974:
975: --Bugfix 4070732 {
976: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
977: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
978: IF l_debug_on THEN
979: 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: END IF;

Line 977: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

973: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
974:
975: --Bugfix 4070732 {
976: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
977: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
978: IF l_debug_on THEN
979: 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: END IF;
981:

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

975: --Bugfix 4070732 {
976: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
977: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
978: IF l_debug_on THEN
979: 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: END IF;
981:
982: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
983: x_return_status => l_return_status);

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

978: IF l_debug_on THEN
979: 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: END IF;
981:
982: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
983: x_return_status => l_return_status);
984:
985:
986: IF l_debug_on THEN

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

986: IF l_debug_on THEN
987: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
988: END IF;
989:
990: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
991: x_return_status := l_return_status;
992: END IF;
993:
994: END IF;

Line 1019: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

1015: IF l_debug_on THEN
1016: wsh_debug_sv.log (l_module_name, 'Return status after Delivery_Interface_Wrapper ', l_Return_Status);
1017: END IF;
1018:
1019: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1020: RAISE wsh_del_interface_wrapper;
1021: ELSE
1022: l_txn_hist_record.transaction_status := 'SC';
1023:

Line 1032: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

1028: IF l_debug_on THEN
1029: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);
1030: END IF;
1031:
1032: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1033: RAISE wsh_update_history;
1034: END IF;
1035:
1036: WSH_PROCESS_INTERFACED_PKG.delete_interface_records ( l_New_Del_Interface_ID,

Line 1043: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

1039: IF l_debug_on THEN
1040: wsh_debug_sv.log (l_module_name, 'Return status after delete_interface_records ', l_Return_Status);
1041: END IF;
1042:
1043: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1044: RAISE wsh_del_interface_rec;
1045: END IF;
1046: END IF;
1047:

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

1046: END IF;
1047:
1048: --bug 4070732
1049: --End of the API handling of calls to process_stops_for_load_tender
1050: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1051: THEN
1052: --{
1053: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1054: --{

Line 1053: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1049: --End of the API handling of calls to process_stops_for_load_tender
1050: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1051: THEN
1052: --{
1053: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1054: --{
1055:
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

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

1053: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1054: --{
1055:
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1058: END IF;
1059:
1060: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1061: x_return_status => l_return_status);

Line 1060: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,

1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1058: END IF;
1059:
1060: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1061: x_return_status => l_return_status);
1062:
1063: IF l_debug_on THEN
1064: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 1068: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

1064: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1065: END IF;
1066:
1067: IF (
1068: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
1069: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1070: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
1071: )
1072: THEN

Line 1069: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

1065: END IF;
1066:
1067: IF (
1068: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
1069: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1070: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
1071: )
1072: THEN
1073: --{

Line 1070: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

1066:
1067: IF (
1068: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
1069: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1070: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
1071: )
1072: THEN
1073: --{
1074: x_return_status := l_return_status;

Line 1076: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

1072: THEN
1073: --{
1074: x_return_status := l_return_status;
1075: --}
1076: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1077: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1078: THEN
1079: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1080: END IF;

Line 1077: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

1073: --{
1074: x_return_status := l_return_status;
1075: --}
1076: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1077: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1078: THEN
1079: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1080: END IF;
1081:

Line 1079: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1075: --}
1076: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1077: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
1078: THEN
1079: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1080: END IF;
1081:
1082:
1083: --}

Line 1095: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1091: END IF;
1092:
1093: EXCEPTION
1094: WHEN wsh_invalid_item_key THEN
1095: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1096:
1097: --Bugfix 4070732 {
1098: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1099: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1094: WHEN wsh_invalid_item_key THEN
1095: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1096:
1097: --Bugfix 4070732 {
1098: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1099: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1100: IF l_debug_on THEN
1101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1102: END IF;

Line 1099: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1095: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1096:
1097: --Bugfix 4070732 {
1098: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1099: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1100: IF l_debug_on THEN
1101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1102: END IF;
1103:

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

1097: --Bugfix 4070732 {
1098: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1099: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1100: IF l_debug_on THEN
1101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1102: END IF;
1103:
1104: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1105: x_return_status => l_return_status);

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

1100: IF l_debug_on THEN
1101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1102: END IF;
1103:
1104: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1105: x_return_status => l_return_status);
1106:
1107: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1108: x_return_status := l_return_status;

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

1103:
1104: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1105: x_return_status => l_return_status);
1106:
1107: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1108: x_return_status := l_return_status;
1109: END IF;
1110:
1111:

Line 1127: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1123: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_item_key');
1124: END IF;
1125:
1126: WHEN wsh_get_txns_hist_error THEN
1127: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1128: --Bugfix 4070732 {
1129: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1130: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1131: IF l_debug_on THEN

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

1125:
1126: WHEN wsh_get_txns_hist_error THEN
1127: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1128: --Bugfix 4070732 {
1129: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1130: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1131: IF l_debug_on THEN
1132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1133: END IF;

Line 1130: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1126: WHEN wsh_get_txns_hist_error THEN
1127: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1128: --Bugfix 4070732 {
1129: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1130: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1131: IF l_debug_on THEN
1132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1133: END IF;
1134:

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

1128: --Bugfix 4070732 {
1129: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1130: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1131: IF l_debug_on THEN
1132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1133: END IF;
1134:
1135: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1136: x_return_status => l_return_status);

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

1131: IF l_debug_on THEN
1132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1133: END IF;
1134:
1135: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1136: x_return_status => l_return_status);
1137:
1138:
1139: IF l_debug_on THEN

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

1139: IF l_debug_on THEN
1140: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1141: END IF;
1142:
1143: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1144: x_return_status := l_return_status;
1145: END IF;
1146:
1147: END IF;

Line 1158: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
1155: END IF;
1156:
1157: WHEN wsh_orig_txns_hist_error THEN
1158: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1159: --Bugfix 4070732 {
1160: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1161: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1162: IF l_debug_on THEN

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

1156:
1157: WHEN wsh_orig_txns_hist_error THEN
1158: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1159: --Bugfix 4070732 {
1160: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1161: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1162: IF l_debug_on THEN
1163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1164: END IF;

Line 1161: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1157: WHEN wsh_orig_txns_hist_error THEN
1158: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1159: --Bugfix 4070732 {
1160: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1161: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1162: IF l_debug_on THEN
1163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1164: END IF;
1165:

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

1159: --Bugfix 4070732 {
1160: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1161: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1162: IF l_debug_on THEN
1163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1164: END IF;
1165:
1166: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1167: x_return_status => l_return_status);

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

1162: IF l_debug_on THEN
1163: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1164: END IF;
1165:
1166: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1167: x_return_status => l_return_status);
1168:
1169:
1170: IF l_debug_on THEN

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

1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1172: END IF;
1173:
1174: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1175: x_return_status := l_return_status;
1176: END IF;
1177: END IF;
1178: END IF;

Line 1188: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;

1184: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1185: END IF;
1186:
1187: WHEN wsh_update_history THEN
1188: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1189:
1190: --Bugfix 4070732 {
1191: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1192: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1187: WHEN wsh_update_history THEN
1188: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1189:
1190: --Bugfix 4070732 {
1191: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1192: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1193: IF l_debug_on THEN
1194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1195: END IF;

Line 1192: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1188: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1189:
1190: --Bugfix 4070732 {
1191: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1192: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1193: IF l_debug_on THEN
1194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1195: END IF;
1196:

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

1190: --Bugfix 4070732 {
1191: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1192: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1193: IF l_debug_on THEN
1194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1195: END IF;
1196:
1197: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1198: x_return_status => l_return_status);

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

1193: IF l_debug_on THEN
1194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1195: END IF;
1196:
1197: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1198: x_return_status => l_return_status);
1199:
1200:
1201: IF l_debug_on THEN

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

1201: IF l_debug_on THEN
1202: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1203: END IF;
1204:
1205: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1206: x_return_status := l_return_status;
1207: END IF;
1208:
1209: END IF;

Line 1220: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1216: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
1217: END IF;
1218:
1219: WHEN wsh_del_interface_rec THEN
1220: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1221:
1222: --Bugfix 4070732 {
1223: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1224: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1219: WHEN wsh_del_interface_rec THEN
1220: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1221:
1222: --Bugfix 4070732 {
1223: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1224: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1227: END IF;

Line 1224: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1220: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1221:
1222: --Bugfix 4070732 {
1223: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1224: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1227: END IF;
1228:

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

1222: --Bugfix 4070732 {
1223: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1224: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1227: END IF;
1228:
1229: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1230: x_return_status => l_return_status);

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

1225: IF l_debug_on THEN
1226: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1227: END IF;
1228:
1229: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1230: x_return_status => l_return_status);
1231:
1232: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1233: x_return_status := l_return_status;

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

1228:
1229: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1230: x_return_status => l_return_status);
1231:
1232: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1233: x_return_status := l_return_status;
1234: END IF;
1235:
1236:

Line 1252: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;

1248: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_interface_rec');
1249: END IF;
1250:
1251: WHEN wsh_invalid_delivery_no THEN
1252: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1253:
1254: --Bugfix 4070732 {
1255: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1256: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1251: WHEN wsh_invalid_delivery_no THEN
1252: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1253:
1254: --Bugfix 4070732 {
1255: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1256: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;

Line 1256: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1252: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1253:
1254: --Bugfix 4070732 {
1255: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1256: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;
1260:

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

1254: --Bugfix 4070732 {
1255: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1256: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;
1260:
1261: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1262: x_return_status => l_return_status);

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

1257: IF l_debug_on THEN
1258: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1259: END IF;
1260:
1261: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1262: x_return_status => l_return_status);
1263:
1264:
1265: IF l_debug_on THEN

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

1265: IF l_debug_on THEN
1266: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1267: END IF;
1268:
1269: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1270: x_return_status := l_return_status;
1271: END IF;
1272:
1273: END IF;

Line 1288: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

1284: l_txn_hist_record.transaction_status := 'ER';
1285: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
1286: l_txn_hist_record.transaction_id,
1287: l_Return_Status );
1288: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1289: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1290: END IF;
1291:
1292: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

Line 1289: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1285: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
1286: l_txn_hist_record.transaction_id,
1287: l_Return_Status );
1288: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1289: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1290: END IF;
1291:
1292: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1293:

Line 1292: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1288: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1289: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1290: END IF;
1291:
1292: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1293:
1294: --Bugfix 4070732 {
1295: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1296: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1291:
1292: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1293:
1294: --Bugfix 4070732 {
1295: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1296: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1297: IF l_debug_on THEN
1298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1299: END IF;

Line 1296: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1292: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1293:
1294: --Bugfix 4070732 {
1295: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1296: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1297: IF l_debug_on THEN
1298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1299: END IF;
1300:

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

1294: --Bugfix 4070732 {
1295: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1296: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1297: IF l_debug_on THEN
1298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1299: END IF;
1300:
1301: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1302: x_return_status => l_return_status);

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

1297: IF l_debug_on THEN
1298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1299: END IF;
1300:
1301: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1302: x_return_status => l_return_status);
1303:
1304:
1305: IF l_debug_on THEN

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

1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1307: END IF;
1308:
1309: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1310: x_return_status := l_return_status;
1311: END IF;
1312:
1313: END IF;

Line 1324: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1320: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_interface_wrapper');
1321: END IF;
1322:
1323: WHEN OTHERS THEN
1324: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1325:
1326: --Bugfix 4070732 {
1327: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1323: WHEN OTHERS THEN
1324: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1325:
1326: --Bugfix 4070732 {
1327: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1329: IF l_debug_on THEN
1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1331: END IF;

Line 1328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1324: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1325:
1326: --Bugfix 4070732 {
1327: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1329: IF l_debug_on THEN
1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1331: END IF;
1332:

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

1326: --Bugfix 4070732 {
1327: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1328: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1329: IF l_debug_on THEN
1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1331: END IF;
1332:
1333: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1334: x_return_status => l_return_status);

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

1329: IF l_debug_on THEN
1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1331: END IF;
1332:
1333: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1334: x_return_status => l_return_status);
1335:
1336:
1337: IF l_debug_on THEN

Line 1444: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

1440: wsh_debug_sv.log(l_module_name, 'P_item_type',P_item_type);
1441: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
1442: END IF;
1443:
1444: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
1445:
1446: OPEN l_txn_hist_cur (P_Item_Type, P_Item_Key);
1447: FETCH l_txn_hist_cur
1448: INTO l_orig_txn_hist_record;

Line 1472: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

1468: IF l_debug_on THEN
1469: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Event ', l_Return_Status);
1470: END IF;
1471:
1472: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1473: RAISE wsh_raise_event_error;
1474: END IF;
1475:
1476: IF l_debug_on THEN

Line 1481: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1477: wsh_debug_sv.pop(l_module_name);
1478: END IF;
1479: EXCEPTION
1480: WHEN wsh_orig_txns_hist_error THEN
1481: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1482: IF l_debug_on THEN
1483: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1484: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1485: END IF;

Line 1488: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1484: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1485: END IF;
1486:
1487: WHEN wsh_raise_event_error THEN
1488: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1489: IF l_debug_on THEN
1490: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1491: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
1492: END IF;

Line 1495: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1491: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
1492: END IF;
1493:
1494: WHEN OTHERS THEN
1495: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1496: IF l_debug_on THEN
1497: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1498: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1499: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1600: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

1596: wsh_debug_sv.log(l_module_name, 'P_item_type',P_item_type);
1597: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
1598: END IF;
1599:
1600: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
1601:
1602: FOR l_orig_txn_hist_record IN l_stnd_txn_hist_cur(P_Item_Type, P_Item_Key) LOOP
1603:
1604: l_orig_txn_hist_record.Event_Name := 'oracle.apps.wsh.standalone.spwf';

Line 1619: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

1615: IF l_debug_on THEN
1616: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Event ', l_Return_Status);
1617: END IF;
1618:
1619: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1620: RAISE wsh_raise_event_error;
1621: END IF;
1622:
1623: END LOOP;

Line 1632: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1628: wsh_debug_sv.pop(l_module_name);
1629: END IF;
1630: EXCEPTION
1631: WHEN wsh_orig_txns_hist_error THEN
1632: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1633: IF l_debug_on THEN
1634: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1636: END IF;

Line 1639: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1636: END IF;
1637:
1638: WHEN wsh_raise_event_error THEN
1639: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1640: IF l_debug_on THEN
1641: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
1643: END IF;

Line 1646: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1642: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
1643: END IF;
1644:
1645: WHEN OTHERS THEN
1646: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1647: IF l_debug_on THEN
1648: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1649: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1650: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1785: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

1781: wsh_debug_sv.log (l_module_name, 'P_Document_Type ', P_Document_Type);
1782: wsh_debug_sv.log (l_module_name, 'P_Org_ID ', P_Org_ID);
1783: END IF;
1784:
1785: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
1786:
1787: IF ( P_Entity_TYPE <> 'DLVY' ) THEN
1788: RAISE wsh_invalid_entity_type;
1789: ELSIF ( P_Action_TYPE <> 'A' ) THEN

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

1868: WSH_SHIP_CONFIRM_ACTIONS.Process_Delivery_To_OM (
1869: p_delivery_id => p_entity_id,
1870: x_return_status => l_return_status);
1871:
1872: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1873: RAISE wsh_interface_to_om_failed;
1874: END IF;
1875: ELSE
1876: -- Get the Original record from the Transaction History Table for the Delivery.

Line 1960: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

1956: IF l_debug_on THEN
1957: wsh_debug_sv.log (l_module_name, 'After Raise_Event , return status ' , l_Return_Status);
1958: END IF;
1959:
1960: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1961: RAISE wsh_raise_event_error;
1962: END IF;
1963:
1964: IF l_debug_on THEN

Line 1970: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1966: END IF;
1967:
1968: EXCEPTION
1969: WHEN wsh_invalid_delivery_id THEN
1970: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1971: IF l_debug_on THEN
1972: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1973: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
1974: END IF;

Line 1977: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1973: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
1974: END IF;
1975:
1976: WHEN wsh_invalid_entity_type THEN
1977: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1978: IF l_debug_on THEN
1979: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_entity_type');
1981: END IF;

Line 1984: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_entity_type');
1981: END IF;
1982:
1983: WHEN wsh_invalid_action_type THEN
1984: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1985: IF l_debug_on THEN
1986: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_action_type');
1988: END IF;

Line 1991: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_action_type');
1988: END IF;
1989:
1990: WHEN wsh_invalid_doc_type THEN
1991: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1992: IF l_debug_on THEN
1993: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_doc_type');
1995: END IF;

Line 1998: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1994: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_doc_type');
1995: END IF;
1996:
1997: WHEN wsh_orig_txns_hist_error THEN
1998: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1999: IF l_debug_on THEN
2000: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2001: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
2002: END IF;

Line 2005: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

2001: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
2002: END IF;
2003:
2004: WHEN wsh_orig_txn_hist_error_status THEN
2005: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2006: IF l_debug_on THEN
2007: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2008: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
2009: END IF;

Line 2012: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

2008: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
2009: END IF;
2010: -- R12.1.1 STANDALONE PROJECT
2011: WHEN wsh_interface_to_om_failed THEN
2012: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2013: IF l_debug_on THEN
2014: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_interface_to_om_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2015: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_interface_to_om_failed');
2016: END IF;

Line 2019: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

2015: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_interface_to_om_failed');
2016: END IF;
2017:
2018: WHEN wsh_invalid_del_status THEN
2019: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2020: FND_MESSAGE.Set_Name ('WSH', 'WSH_INVALID_DELIVERY_STATUS');
2021: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_del_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2021: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);

2017:
2018: WHEN wsh_invalid_del_status THEN
2019: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2020: FND_MESSAGE.Set_Name ('WSH', 'WSH_INVALID_DELIVERY_STATUS');
2021: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
2022: IF l_debug_on THEN
2023: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_del_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_del_status');
2025: END IF;

Line 2028: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

2024: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_del_status');
2025: END IF;
2026:
2027: WHEN wsh_del_details_error THEN
2028: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2029: FND_MESSAGE.Set_Name ('WSH', 'WSH_DEL_DETAIL_ERROR');
2030: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
2031: IF l_debug_on THEN
2032: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_details_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2030: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);

2026:
2027: WHEN wsh_del_details_error THEN
2028: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2029: FND_MESSAGE.Set_Name ('WSH', 'WSH_DEL_DETAIL_ERROR');
2030: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
2031: IF l_debug_on THEN
2032: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_details_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2033: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_details_error');
2034: END IF;

Line 2037: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

2033: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_details_error');
2034: END IF;
2035:
2036: WHEN wsh_raise_event_error THEN
2037: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2038: IF l_debug_on THEN
2039: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2040: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
2041: END IF;

Line 2043: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

2039: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2040: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
2041: END IF;
2042: WHEN wsh_sa_resend_error THEN
2043: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2044: FND_MESSAGE.Set_Name ('WSH', 'WSH_SA_RESEND_ERROR');
2045: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
2046: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
2047: IF l_debug_on THEN

Line 2046: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);

2042: WHEN wsh_sa_resend_error THEN
2043: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2044: FND_MESSAGE.Set_Name ('WSH', 'WSH_SA_RESEND_ERROR');
2045: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
2046: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
2047: IF l_debug_on THEN
2048: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_sa_resend_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2049: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_sa_resend_error');
2050: END IF;

Line 2053: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

2049: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_sa_resend_error');
2050: END IF;
2051:
2052: WHEN wsh_serial_no_inv_interface THEN
2053: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2054: FND_MESSAGE.Set_Name ('WSH', 'WSH_SERIAL_NO_INV_INTERFACE');
2055: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
2056: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
2057: IF l_debug_on THEN

Line 2056: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);

2052: WHEN wsh_serial_no_inv_interface THEN
2053: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
2054: FND_MESSAGE.Set_Name ('WSH', 'WSH_SERIAL_NO_INV_INTERFACE');
2055: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
2056: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
2057: IF l_debug_on THEN
2058: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_serial_no_inv_interface exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2059: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_serial_no_inv_interface');
2060: END IF;

Line 2063: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

2059: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_serial_no_inv_interface');
2060: END IF;
2061:
2062: WHEN OTHERS THEN
2063: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
2064: IF l_debug_on THEN
2065: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
2066: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2067: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');