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 355: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

351: wsh_debug_sv.log(l_module_name, 'P_item_type',P_item_type);
352: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
353: END IF;
354:
355: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
356:
357: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
358: P_item_key,
359: 'I',

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

363: IF l_debug_on THEN
364: wsh_debug_sv.log (l_module_name, 'Return status after Get_Txns_History ', l_Return_Status);
365: END IF;
366:
367: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
368: RAISE wsh_get_txns_hist_error;
369: END IF;
370:
371: IF l_debug_on THEN

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

380: IF l_debug_on THEN
381: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Event ', l_Return_Status);
382: END IF;
383:
384: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
385: RAISE wsh_raise_event_error;
386: END IF;
387:
388: IF l_debug_on THEN

Line 393: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

389: wsh_debug_sv.pop(l_module_name);
390: END IF;
391: EXCEPTION
392: WHEN wsh_get_txns_hist_error THEN
393: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
394: IF l_debug_on THEN
395: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_txns_hist_error has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
396: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
397: END IF;

Line 400: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

396: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
397: END IF;
398:
399: WHEN wsh_raise_event_error THEN
400: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
401: IF l_debug_on THEN
402: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
403: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
404: END IF;

Line 407: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

403: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
404: END IF;
405:
406: WHEN OTHERS THEN
407: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
408: IF l_debug_on THEN
409: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
410: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
411: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 478: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

474: wsh_debug_sv.log(l_module_name, 'P_item_type',P_item_type);
475: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
476: END IF;
477:
478: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
479:
480: WSH_TRANSACTIONS_HISTORY_PKG.Get_Txns_History ( P_item_type,
481: P_item_key,
482: 'I',

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

487: IF l_debug_on THEN
488: wsh_debug_sv.log (l_module_name, 'Return status after Get_Txns_History ', l_Return_Status);
489: END IF;
490:
491: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
492: RAISE wsh_get_txns_hist_error;
493: END IF;
494:
495: -- Check if the error message is for the current WF or the Original WF

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

535: IF l_debug_on THEN
536: wsh_debug_sv.log (l_module_name, 'After calling the Raise_Event, Status ', l_Return_Status);
537: END IF;
538:
539: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
540: RAISE wsh_raise_event_error;
541: END IF;
542:
543: IF l_debug_on THEN

Line 548: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

544: wsh_debug_sv.pop(l_module_name);
545: END IF;
546: EXCEPTION
547: WHEN wsh_get_txns_hist_error THEN
548: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
549: IF l_debug_on THEN
550: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
552: END IF;

Line 555: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
552: END IF;
553:
554: WHEN wsh_orig_txns_hist_error THEN
555: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
556: IF l_debug_on THEN
557: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
558: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
559: END IF;

Line 562: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

558: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
559: END IF;
560:
561: WHEN wsh_raise_event_error THEN
562: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
566: END IF;

Line 569: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

565: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
566: END IF;
567:
568: WHEN OTHERS THEN
569: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
572: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
573: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 655: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN

651: --Bugfix 4070732
652: l_api_session_name CONSTANT VARCHAR2(150) := G_PKG_NAME ||'.' || l_module_name;
653: BEGIN
654: --Bugfix 4070732
655: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
656: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
657: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
658: END IF;
659: --

Line 656: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;

652: l_api_session_name CONSTANT VARCHAR2(150) := G_PKG_NAME ||'.' || l_module_name;
653: BEGIN
654: --Bugfix 4070732
655: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
656: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
657: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
658: END IF;
659: --
660: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 657: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;

653: BEGIN
654: --Bugfix 4070732
655: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
656: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
657: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
658: END IF;
659: --
660: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
661: --

Line 674: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

670: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
671: END IF;
672:
673:
674: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
675:
676: IF ( P_item_type IS NULL OR
677: P_item_key IS NULL ) THEN
678: RAISE wsh_invalid_item_key;

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

689: IF l_debug_on THEN
690: wsh_debug_sv.log (l_module_name, 'Return status after Get_Txns_History ', l_Return_Status);
691: END IF;
692:
693: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
694: RAISE wsh_get_txns_hist_error;
695: END IF;
696:
697: -- Get the Delivery Interface ID from wsh_new_del_interface table for the given record

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

735: l_Return_Status );
736: IF l_debug_on THEN
737: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);
738: END IF;
739: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
740: RAISE wsh_update_history;
741: END IF;
742:
743: WSH_PROCESS_INTERFACED_PKG.delete_interface_records ( l_New_Del_Interface_ID,

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

745: IF l_debug_on THEN
746: wsh_debug_sv.log (l_module_name, 'Return status after delete_interface_records ', l_Return_Status);
747: END IF;
748:
749: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
750: RAISE wsh_del_interface_rec;
751: END IF;
752:
753: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

Line 753: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

749: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
750: RAISE wsh_del_interface_rec;
751: END IF;
752:
753: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
754:
755: --Bugfix 4070732 {
756: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
757: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

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

Line 757: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

753: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
754:
755: --Bugfix 4070732 {
756: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
757: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
758: IF l_debug_on THEN
759: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
760: END IF;
761:

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

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

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

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

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

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

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

786: IF l_debug_on THEN
787: wsh_debug_sv.log (l_module_name, 'Return status after delete_interface_records ', l_Return_Status);
788: END IF;
789:
790: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
791: RAISE wsh_del_interface_rec;
792: END IF;
793:
794: l_txn_hist_record.transaction_status := 'SC';

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

797: l_Return_Status );
798: IF l_debug_on THEN
799: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);
800: END IF;
801: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
802: RAISE wsh_update_history;
803: END IF;
804:
805: --Bugfix 4070732 {

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

802: RAISE wsh_update_history;
803: END IF;
804:
805: --Bugfix 4070732 {
806: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
807: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
810: END IF;

Line 807: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

803: END IF;
804:
805: --Bugfix 4070732 {
806: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
807: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
810: END IF;
811:

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

805: --Bugfix 4070732 {
806: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
807: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
808: IF l_debug_on THEN
809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
810: END IF;
811:
812: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
813: x_return_status => l_return_status);

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

808: IF l_debug_on THEN
809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
810: END IF;
811:
812: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
813: x_return_status => l_return_status);
814:
815: IF l_debug_on THEN
816: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 820: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

816: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
817: END IF;
818:
819: IF (
820: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
821: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
822: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
823: )
824: THEN

Line 821: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

817: END IF;
818:
819: IF (
820: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
821: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
822: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
823: )
824: THEN
825: --{

Line 822: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

818:
819: IF (
820: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
821: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
822: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
823: )
824: THEN
825: --{
826: x_return_status := l_return_status;

Line 828: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

824: THEN
825: --{
826: x_return_status := l_return_status;
827: --}
828: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
829: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
830: THEN
831: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
832: END IF;

Line 829: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

825: --{
826: x_return_status := l_return_status;
827: --}
828: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
829: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
830: THEN
831: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
832: END IF;
833:

Line 831: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

827: --}
828: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
829: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
830: THEN
831: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
832: END IF;
833:
834: END IF;
835: END IF;

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

866: l_Return_Status );
867: IF l_debug_on THEN
868: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);
869: END IF;
870: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
871: RAISE wsh_update_history;
872: END IF;
873:
874:

Line 875: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

871: RAISE wsh_update_history;
872: END IF;
873:
874:
875: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
876:
877: --Bugfix 4070732 {
878: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
879: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

874:
875: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
876:
877: --Bugfix 4070732 {
878: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
879: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;

Line 879: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

875: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
876:
877: --Bugfix 4070732 {
878: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
879: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;
883:

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

877: --Bugfix 4070732 {
878: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
879: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;
883:
884: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
885: x_return_status => l_return_status);

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

880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;
883:
884: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
885: x_return_status => l_return_status);
886:
887:
888: IF l_debug_on THEN

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

888: IF l_debug_on THEN
889: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
890: END IF;
891:
892: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
893: x_return_status := l_return_status;
894: END IF;
895:
896: END IF;

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

917: IF l_debug_on THEN
918: wsh_debug_sv.log (l_module_name, 'Return status after Delivery_Interface_Wrapper ', l_Return_Status);
919: END IF;
920:
921: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
922: RAISE wsh_del_interface_wrapper;
923: ELSE
924: l_txn_hist_record.transaction_status := 'SC';
925:

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

930: IF l_debug_on THEN
931: wsh_debug_sv.log (l_module_name, 'Return status after Create_Update_Txns_History ', l_Return_Status);
932: END IF;
933:
934: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
935: RAISE wsh_update_history;
936: END IF;
937:
938: WSH_PROCESS_INTERFACED_PKG.delete_interface_records ( l_New_Del_Interface_ID,

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

941: IF l_debug_on THEN
942: wsh_debug_sv.log (l_module_name, 'Return status after delete_interface_records ', l_Return_Status);
943: END IF;
944:
945: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
946: RAISE wsh_del_interface_rec;
947: END IF;
948: END IF;
949:

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

948: END IF;
949:
950: --bug 4070732
951: --End of the API handling of calls to process_stops_for_load_tender
952: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
953: THEN
954: --{
955: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
956: --{

Line 955: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

951: --End of the API handling of calls to process_stops_for_load_tender
952: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
953: THEN
954: --{
955: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
956: --{
957:
958: IF l_debug_on THEN
959: 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 959: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);

955: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
956: --{
957:
958: IF l_debug_on THEN
959: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
960: END IF;
961:
962: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
963: x_return_status => l_return_status);

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

958: IF l_debug_on THEN
959: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
960: END IF;
961:
962: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
963: x_return_status => l_return_status);
964:
965: IF l_debug_on THEN
966: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 970: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

966: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
967: END IF;
968:
969: IF (
970: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
971: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
972: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
973: )
974: THEN

Line 971: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

967: END IF;
968:
969: IF (
970: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
971: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
972: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
973: )
974: THEN
975: --{

Line 972: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )

968:
969: IF (
970: ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
971: OR ( l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
972: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR )
973: )
974: THEN
975: --{
976: x_return_status := l_return_status;

Line 978: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

974: THEN
975: --{
976: x_return_status := l_return_status;
977: --}
978: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
979: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
980: THEN
981: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
982: END IF;

Line 979: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

975: --{
976: x_return_status := l_return_status;
977: --}
978: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
979: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
980: THEN
981: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
982: END IF;
983:

Line 981: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

977: --}
978: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
979: AND x_return_status <> WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
980: THEN
981: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
982: END IF;
983:
984:
985: --}

Line 997: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

993: END IF;
994:
995: EXCEPTION
996: WHEN wsh_invalid_item_key THEN
997: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
998:
999: --Bugfix 4070732 {
1000: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1001: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

996: WHEN wsh_invalid_item_key THEN
997: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
998:
999: --Bugfix 4070732 {
1000: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1001: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;

Line 1001: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

997: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
998:
999: --Bugfix 4070732 {
1000: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1001: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005:

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

999: --Bugfix 4070732 {
1000: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1001: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005:
1006: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1007: x_return_status => l_return_status);

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

1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005:
1006: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1007: x_return_status => l_return_status);
1008:
1009: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1010: x_return_status := l_return_status;

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

1005:
1006: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1007: x_return_status => l_return_status);
1008:
1009: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1010: x_return_status := l_return_status;
1011: END IF;
1012:
1013:

Line 1029: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1025: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_item_key');
1026: END IF;
1027:
1028: WHEN wsh_get_txns_hist_error THEN
1029: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1030: --Bugfix 4070732 {
1031: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1032: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1033: IF l_debug_on THEN

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

1027:
1028: WHEN wsh_get_txns_hist_error THEN
1029: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1030: --Bugfix 4070732 {
1031: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1032: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1035: END IF;

Line 1032: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1028: WHEN wsh_get_txns_hist_error THEN
1029: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1030: --Bugfix 4070732 {
1031: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1032: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1035: END IF;
1036:

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

1030: --Bugfix 4070732 {
1031: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1032: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1035: END IF;
1036:
1037: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1038: x_return_status => l_return_status);

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

1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1035: END IF;
1036:
1037: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1038: x_return_status => l_return_status);
1039:
1040:
1041: IF l_debug_on THEN

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

1041: IF l_debug_on THEN
1042: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1043: END IF;
1044:
1045: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1046: x_return_status := l_return_status;
1047: END IF;
1048:
1049: END IF;

Line 1060: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1056: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_txns_hist_error');
1057: END IF;
1058:
1059: WHEN wsh_orig_txns_hist_error THEN
1060: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1061: --Bugfix 4070732 {
1062: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1063: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1064: IF l_debug_on THEN

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

1058:
1059: WHEN wsh_orig_txns_hist_error THEN
1060: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1061: --Bugfix 4070732 {
1062: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1063: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1066: END IF;

Line 1063: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1059: WHEN wsh_orig_txns_hist_error THEN
1060: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1061: --Bugfix 4070732 {
1062: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1063: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1066: END IF;
1067:

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

1061: --Bugfix 4070732 {
1062: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1063: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1066: END IF;
1067:
1068: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1069: x_return_status => l_return_status);

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

1064: IF l_debug_on THEN
1065: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1066: END IF;
1067:
1068: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1069: x_return_status => l_return_status);
1070:
1071:
1072: IF l_debug_on THEN

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

1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1074: END IF;
1075:
1076: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1077: x_return_status := l_return_status;
1078: END IF;
1079: END IF;
1080: END IF;

Line 1090: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;

1086: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1087: END IF;
1088:
1089: WHEN wsh_update_history THEN
1090: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1091:
1092: --Bugfix 4070732 {
1093: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1094: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1089: WHEN wsh_update_history THEN
1090: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1091:
1092: --Bugfix 4070732 {
1093: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1094: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1095: IF l_debug_on THEN
1096: 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: END IF;

Line 1094: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1090: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1091:
1092: --Bugfix 4070732 {
1093: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1094: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1095: IF l_debug_on THEN
1096: 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: END IF;
1098:

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

1092: --Bugfix 4070732 {
1093: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1094: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1095: IF l_debug_on THEN
1096: 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: END IF;
1098:
1099: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1100: x_return_status => l_return_status);

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

1095: IF l_debug_on THEN
1096: 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: END IF;
1098:
1099: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1100: x_return_status => l_return_status);
1101:
1102:
1103: IF l_debug_on THEN

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

1103: IF l_debug_on THEN
1104: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1105: END IF;
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: END IF;

Line 1122: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1118: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
1119: END IF;
1120:
1121: WHEN wsh_del_interface_rec THEN
1122: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1123:
1124: --Bugfix 4070732 {
1125: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1126: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1121: WHEN wsh_del_interface_rec THEN
1122: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1123:
1124: --Bugfix 4070732 {
1125: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1126: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1129: END IF;

Line 1126: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

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

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

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

1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1129: END IF;
1130:
1131: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1132: x_return_status => l_return_status);
1133:
1134: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1135: x_return_status := l_return_status;

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

1130:
1131: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1132: x_return_status => l_return_status);
1133:
1134: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1135: x_return_status := l_return_status;
1136: END IF;
1137:
1138:

Line 1154: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;

1150: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_interface_rec');
1151: END IF;
1152:
1153: WHEN wsh_invalid_delivery_no THEN
1154: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1155:
1156: --Bugfix 4070732 {
1157: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1158: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1153: WHEN wsh_invalid_delivery_no THEN
1154: X_return_status := WSH_UTIL_CORE.g_ret_sts_error;
1155:
1156: --Bugfix 4070732 {
1157: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1158: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1159: IF l_debug_on THEN
1160: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1161: END IF;

Line 1158: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

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

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

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

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

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

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

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

1186: l_txn_hist_record.transaction_status := 'ER';
1187: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
1188: l_txn_hist_record.transaction_id,
1189: l_Return_Status );
1190: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1191: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1192: END IF;
1193:
1194: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

Line 1191: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1187: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
1188: l_txn_hist_record.transaction_id,
1189: l_Return_Status );
1190: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1191: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1192: END IF;
1193:
1194: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1195:

Line 1194: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1190: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1191: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1192: END IF;
1193:
1194: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1195:
1196: --Bugfix 4070732 {
1197: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1198: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1193:
1194: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1195:
1196: --Bugfix 4070732 {
1197: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1198: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1201: END IF;

Line 1198: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1194: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1195:
1196: --Bugfix 4070732 {
1197: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1198: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1201: END IF;
1202:

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

1196: --Bugfix 4070732 {
1197: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1198: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1201: END IF;
1202:
1203: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1204: x_return_status => l_return_status);

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

1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1201: END IF;
1202:
1203: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1204: x_return_status => l_return_status);
1205:
1206:
1207: IF l_debug_on THEN

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

1207: IF l_debug_on THEN
1208: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1209: END IF;
1210:
1211: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1212: x_return_status := l_return_status;
1213: END IF;
1214:
1215: END IF;

Line 1226: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_interface_wrapper');
1223: END IF;
1224:
1225: WHEN OTHERS THEN
1226: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1227:
1228: --Bugfix 4070732 {
1229: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1230: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

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

1225: WHEN OTHERS THEN
1226: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1227:
1228: --Bugfix 4070732 {
1229: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1230: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1233: END IF;

Line 1230: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1226: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1227:
1228: --Bugfix 4070732 {
1229: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1230: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1233: END IF;
1234:

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

1228: --Bugfix 4070732 {
1229: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1230: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1233: END IF;
1234:
1235: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1236: x_return_status => l_return_status);

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

1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1233: END IF;
1234:
1235: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1236: x_return_status => l_return_status);
1237:
1238:
1239: IF l_debug_on THEN

Line 1343: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

1339: wsh_debug_sv.log(l_module_name, 'P_item_type',P_item_type);
1340: wsh_debug_sv.log(l_module_name, 'P_item_key',P_item_key);
1341: END IF;
1342:
1343: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
1344:
1345: OPEN l_txn_hist_cur (P_Item_Type, P_Item_Key);
1346: FETCH l_txn_hist_cur
1347: INTO l_orig_txn_hist_record;

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

1367: IF l_debug_on THEN
1368: wsh_debug_sv.log (l_module_name, 'Return status after Raise_Event ', l_Return_Status);
1369: END IF;
1370:
1371: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1372: RAISE wsh_raise_event_error;
1373: END IF;
1374:
1375: IF l_debug_on THEN

Line 1380: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1376: wsh_debug_sv.pop(l_module_name);
1377: END IF;
1378: EXCEPTION
1379: WHEN wsh_orig_txns_hist_error THEN
1380: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1381: IF l_debug_on THEN
1382: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1383: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1384: END IF;

Line 1387: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1383: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1384: END IF;
1385:
1386: WHEN wsh_raise_event_error THEN
1387: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1388: IF l_debug_on THEN
1389: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
1391: END IF;

Line 1394: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1390: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
1391: END IF;
1392:
1393: WHEN OTHERS THEN
1394: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1395: IF l_debug_on THEN
1396: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1397: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1398: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1528: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;

1524: wsh_debug_sv.log (l_module_name, 'P_Document_Type ', P_Document_Type);
1525: wsh_debug_sv.log (l_module_name, 'P_Org_ID ', P_Org_ID);
1526: END IF;
1527:
1528: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_success;
1529:
1530: IF ( P_Entity_TYPE <> 'DLVY' ) THEN
1531: RAISE wsh_invalid_entity_type;
1532: ELSIF ( P_Action_TYPE <> 'A' ) THEN

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

1641: IF l_debug_on THEN
1642: wsh_debug_sv.log (l_module_name, 'After Raise_Event , return status ' , l_Return_Status);
1643: END IF;
1644:
1645: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
1646: RAISE wsh_raise_event_error;
1647: END IF;
1648:
1649: IF l_debug_on THEN

Line 1655: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1651: END IF;
1652:
1653: EXCEPTION
1654: WHEN wsh_invalid_delivery_id THEN
1655: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1656: IF l_debug_on THEN
1657: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_id exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
1659: END IF;

Line 1662: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_id');
1659: END IF;
1660:
1661: WHEN wsh_invalid_entity_type THEN
1662: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1663: IF l_debug_on THEN
1664: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_entity_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_entity_type');
1666: END IF;

Line 1669: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_entity_type');
1666: END IF;
1667:
1668: WHEN wsh_invalid_action_type THEN
1669: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1670: IF l_debug_on THEN
1671: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_action_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_action_type');
1673: END IF;

Line 1676: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1672: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_action_type');
1673: END IF;
1674:
1675: WHEN wsh_invalid_doc_type THEN
1676: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1677: IF l_debug_on THEN
1678: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_doc_type exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_doc_type');
1680: END IF;

Line 1683: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1679: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_doc_type');
1680: END IF;
1681:
1682: WHEN wsh_orig_txns_hist_error THEN
1683: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1684: IF l_debug_on THEN
1685: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1687: END IF;

Line 1690: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1687: END IF;
1688:
1689: WHEN wsh_orig_txn_hist_error_status THEN
1690: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1691: IF l_debug_on THEN
1692: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_orig_txns_hist_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1694: END IF;

Line 1697: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1693: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_orig_txns_hist_error');
1694: END IF;
1695:
1696: WHEN wsh_invalid_del_status THEN
1697: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1698: FND_MESSAGE.Set_Name ('WSH', 'WSH_INVALID_DELIVERY_STATUS');
1699: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_del_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1695:
1696: WHEN wsh_invalid_del_status THEN
1697: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1698: FND_MESSAGE.Set_Name ('WSH', 'WSH_INVALID_DELIVERY_STATUS');
1699: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
1700: IF l_debug_on THEN
1701: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_del_status exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_del_status');
1703: END IF;

Line 1706: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_del_status');
1703: END IF;
1704:
1705: WHEN wsh_del_details_error THEN
1706: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1707: FND_MESSAGE.Set_Name ('WSH', 'WSH_DEL_DETAIL_ERROR');
1708: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_details_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1704:
1705: WHEN wsh_del_details_error THEN
1706: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1707: FND_MESSAGE.Set_Name ('WSH', 'WSH_DEL_DETAIL_ERROR');
1708: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_del_details_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_details_error');
1712: END IF;

Line 1715: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1711: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_del_details_error');
1712: END IF;
1713:
1714: WHEN wsh_raise_event_error THEN
1715: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1716: IF l_debug_on THEN
1717: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1718: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
1719: END IF;

Line 1721: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1717: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_raise_event_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1718: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_raise_event_error');
1719: END IF;
1720: WHEN wsh_sa_resend_error THEN
1721: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1722: FND_MESSAGE.Set_Name ('WSH', 'WSH_SA_RESEND_ERROR');
1723: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
1724: IF l_debug_on THEN
1725: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_sa_resend_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1719: END IF;
1720: WHEN wsh_sa_resend_error THEN
1721: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1722: FND_MESSAGE.Set_Name ('WSH', 'WSH_SA_RESEND_ERROR');
1723: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
1724: IF l_debug_on THEN
1725: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_sa_resend_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_sa_resend_error');
1727: END IF;

Line 1730: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;

1726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_sa_resend_error');
1727: END IF;
1728:
1729: WHEN wsh_serial_no_inv_interface THEN
1730: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1731: FND_MESSAGE.Set_Name ('WSH', 'WSH_SERIAL_NO_INV_INTERFACE');
1732: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
1733: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
1734: IF l_debug_on THEN

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

1729: WHEN wsh_serial_no_inv_interface THEN
1730: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_error;
1731: FND_MESSAGE.Set_Name ('WSH', 'WSH_SERIAL_NO_INV_INTERFACE');
1732: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_del_name);
1733: WSH_UTIL_CORE.Add_Message (x_return_status,l_module_name);
1734: IF l_debug_on THEN
1735: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_serial_no_inv_interface exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_serial_no_inv_interface');
1737: END IF;

Line 1740: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

1736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_serial_no_inv_interface');
1737: END IF;
1738:
1739: WHEN OTHERS THEN
1740: X_Return_Status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
1741: IF l_debug_on THEN
1742: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1743: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');