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

Line 89: wsh_util_core.api_post_call

85: p_del_name_to => p_del_name_to,
86: p_client_id => p_client_id -- Modified R12.1.1 LSP PROJECT(rminocha)
87: );
88:
89: wsh_util_core.api_post_call
90: (
91: p_return_status => l_return_status,
92: x_num_warnings => l_warning_count,
93: x_num_errors => l_error_count,

Line 101: l_otm_installed := WSH_UTIL_CORE.GC3_Is_Installed;

97: END IF; --}
98: IF ((p_doctype = 'SR')
99: AND ((p_shipment_type IS NULL) OR (p_shipment_type = 'CMS') OR
100: (p_shipment_type = 'BOTH'))) THEN --{
101: l_otm_installed := WSH_UTIL_CORE.GC3_Is_Installed;
102: IF l_otm_installed = 'N' THEN --{
103: Process_Auto_Manifest (
104: p_organization_id => p_organization_id,
105: p_carrier_id => p_carrier_id,

Line 126: wsh_util_core.api_post_call

122: p_del_name_to => p_del_name_to,
123: p_client_id => p_client_id -- Modified R12.1.1 LSP PROJECT(rminocha)
124: );
125:
126: wsh_util_core.api_post_call
127: (
128: p_return_status => l_return_status,
129: x_num_warnings => l_warning_count,
130: x_num_errors => l_error_count,

Line 138: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

134: END IF; --}
135:
136: IF l_error_count > 0
137: THEN
138: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
139: ELSIF l_warning_count > 0
140: THEN
141: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
142: ELSE

Line 141: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

137: THEN
138: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
139: ELSIF l_warning_count > 0
140: THEN
141: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
142: ELSE
143: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
144: END IF;
145:

Line 143: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

139: ELSIF l_warning_count > 0
140: THEN
141: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
142: ELSE
143: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
144: END IF;
145:
146:
147: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 147: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

143: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
144: END IF;
145:
146:
147: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
148: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', '');
149: --errbuf := 'Automated Carrier Manifesting is completed Successfully';
150: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_NORMAL');
151: errbuf := FND_MESSAGE.GET;

Line 153: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

149: --errbuf := 'Automated Carrier Manifesting is completed Successfully';
150: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_NORMAL');
151: errbuf := FND_MESSAGE.GET;
152: retcode := '0';
153: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
154: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS( 'WARNING', '');
155: --errbuf := 'Automated Carrier Manifesting is completed with Warning';
156: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_WARNING');
157: errbuf := FND_MESSAGE.GET;

Line 437: l_entity_ids WSH_UTIL_CORE.id_tab_type;

433: l_customer_name VARCHAR2(80);
434: l_location VARCHAR2(200);
435: l_autopack VARCHAR2(5);
436:
437: l_entity_ids WSH_UTIL_CORE.id_tab_type;
438: l_con_ids WSH_UTIL_CORE.id_tab_type;
439: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
440: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
441: l_group_id_tab WSH_UTIL_CORE.id_tab_type;

Line 438: l_con_ids WSH_UTIL_CORE.id_tab_type;

434: l_location VARCHAR2(200);
435: l_autopack VARCHAR2(5);
436:
437: l_entity_ids WSH_UTIL_CORE.id_tab_type;
438: l_con_ids WSH_UTIL_CORE.id_tab_type;
439: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
440: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
441: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
442: l_success_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;

Line 439: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;

435: l_autopack VARCHAR2(5);
436:
437: l_entity_ids WSH_UTIL_CORE.id_tab_type;
438: l_con_ids WSH_UTIL_CORE.id_tab_type;
439: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
440: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
441: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
442: l_success_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;
443: l_success_count NUMBER := 0;

Line 440: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;

436:
437: l_entity_ids WSH_UTIL_CORE.id_tab_type;
438: l_con_ids WSH_UTIL_CORE.id_tab_type;
439: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
440: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
441: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
442: l_success_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;
443: l_success_count NUMBER := 0;
444: l_error_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;

Line 441: l_group_id_tab WSH_UTIL_CORE.id_tab_type;

437: l_entity_ids WSH_UTIL_CORE.id_tab_type;
438: l_con_ids WSH_UTIL_CORE.id_tab_type;
439: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
440: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
441: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
442: l_success_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;
443: l_success_count NUMBER := 0;
444: l_error_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;
445: l_error_count NUMBER := 0;

Line 479: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN

475:
476: BEGIN
477: --
478: -- Bug 4070732
479: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
480: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
481: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
482: END IF;
483:

Line 480: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;

476: BEGIN
477: --
478: -- Bug 4070732
479: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
480: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
481: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
482: END IF;
483:
484: --

Line 481: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;

477: --
478: -- Bug 4070732
479: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
480: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
481: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
482: END IF;
483:
484: --
485: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 522: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

518: END IF;
519:
520:
521:
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
523:
524: IF l_debug_on THEN
525: wsh_debug_sv.log (l_module_name, 'Begining of FOR LOOP');
526: END IF;

Line 602: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

598:
599: -- set the return status to success if no exception raised, as the
600: -- API Lock_Dlvy_No_Compare does not have a x_return_status
601:
602: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
603:
604: EXCEPTION
605: WHEN app_exception.application_exception
606: OR app_exception.record_lock_exception THEN

Line 607: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

603:
604: EXCEPTION
605: WHEN app_exception.application_exception
606: OR app_exception.record_lock_exception THEN
607: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
608: END ;
609:
610: IF l_debug_on THEN
611: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);

Line 614: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN --1.IF {

610: IF l_debug_on THEN
611: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);
612: END IF;
613:
614: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN --1.IF {
615:
616: IF p_shipment_type = 'CMS' AND p_doctype = 'SR' THEN --{
617:
618: l_calling_api := 'Calling WSH_DELIVERY_VALIDATIONS.Check_Pack';

Line 628: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --3.IF {

624: IF l_debug_on THEN
625: wsh_debug_sv.log (l_module_name,'WSH_DELIVERY_VALIDATIONS.Check_Pack Return Status',l_return_status);
626: END IF;
627:
628: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --3.IF {
629:
630: IF ( nvl(p_autopack,'N') = 'Y' ) THEN -- {
631: l_calling_api := 'Calling WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery';
632:

Line 644: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )THEN --5.IF

640: wsh_debug_sv.log (l_module_name,'WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery Return Status',
641: l_return_status);
642: END IF;
643:
644: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )THEN --5.IF
645: l_delivery_status := 'ERROR';
646: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --5.IF
647: l_warning_index := l_warning_index +1;
648: END IF; --5.IF

Line 646: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --5.IF

642: END IF;
643:
644: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )THEN --5.IF
645: l_delivery_status := 'ERROR';
646: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --5.IF
647: l_warning_index := l_warning_index +1;
648: END IF; --5.IF
649:
650: ELSE -- }{

Line 654: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --}{

650: ELSE -- }{
651: l_delivery_status := 'ERROR';
652: END IF; --}
653:
654: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --}{
655: l_warning_index := l_warning_index +1;
656: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --}{
657: l_delivery_status := 'ERROR';
658: END IF; --}

Line 656: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --}{

652: END IF; --}
653:
654: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --}{
655: l_warning_index := l_warning_index +1;
656: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --}{
657: l_delivery_status := 'ERROR';
658: END IF; --}
659:
660: END IF; --}

Line 678: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING )) THEN --{

674: IF l_debug_on THEN
675: wsh_debug_sv.log (l_module_name,'WSH_TRANSACTIONS_UTIL.Send_Document Return Status',l_return_status);
676: END IF;
677:
678: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING )) THEN --{
679: l_delivery_status := 'ERROR';
680: ELSE --}{
681: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
682: l_warning_index := l_warning_index +1;

Line 681: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

677:
678: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING )) THEN --{
679: l_delivery_status := 'ERROR';
680: ELSE --}{
681: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
682: l_warning_index := l_warning_index +1;
683: END IF;
684: END IF; --}
685: END IF; --}

Line 692: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);

688: l_delivery_status := 'ERROR';
689: END IF; --}
690:
691:
692: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
693: IF (l_msg_count < 2 ) THEN
694: l_msg_details := NULL;
695: END IF;
696:

Line 711: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

707: wsh_debug_sv.log (l_module_name,'Success l_warning_index: ',l_warning_index);
708: END IF;
709:
710: --Start of bug 4070732
711: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
712:
713: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
714:
715: IF l_debug_on THEN

Line 713: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{

709:
710: --Start of bug 4070732
711: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
712:
713: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
714:
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
717: END IF;

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

712:
713: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
714:
715: IF l_debug_on THEN
716: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
717: END IF;
718:
719: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
720: x_return_status => l_return_status);

Line 719: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,

715: IF l_debug_on THEN
716: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
717: END IF;
718:
719: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
720: x_return_status => l_return_status);
721:
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 725: wsh_util_core.api_post_call

721:
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
724: END IF;
725: wsh_util_core.api_post_call
726: (
727: p_return_status => l_return_status,
728: x_num_warnings => l_warning_count,
729: x_num_errors => l_error_count,

Line 734: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

730: p_raise_error_flag => FALSE
731: );
732: END IF; --}
733: -- End of bug 4070732
734: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
735: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
736: IF ( l_warning_index > 0 ) THEN --{
737: IF l_debug_on THEN
738: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS with WARNING');

Line 735: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{

731: );
732: END IF; --}
733: -- End of bug 4070732
734: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
735: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
736: IF ( l_warning_index > 0 ) THEN --{
737: IF l_debug_on THEN
738: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS with WARNING');
739: END IF;

Line 755: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

751: l_success_delivery(l_success_count).msg_details := l_msg_details;
752: END IF; --}
753: END IF; --}
754:
755: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
756: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
757: COMMIT;
758: ELSE --}{
759: IF l_debug_on THEN

Line 756: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{

752: END IF; --}
753: END IF; --}
754:
755: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
756: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
757: COMMIT;
758: ELSE --}{
759: IF l_debug_on THEN
760: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');

Line 783: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

779: END LOOP; --}
780:
781:
782: IF l_error_count > 0 THEN
783: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
784: IF l_delivery_count = l_error_count THEN
785: IF l_debug_on THEN
786: wsh_debug_sv.log(l_module_name,'All Deliveries selected are having error');
787: END IF;

Line 815: FND_MESSAGE.SET_TOKEN('DOC_TYPE', wsh_util_core.get_lookup_meaning('WSH_TXN_DOCUMENT_TYPE',p_doctype));

811: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
812: FND_FILE.put_line(FND_FILE.output,'==========');
813:
814: FND_MESSAGE.SET_NAME('WSH', 'WSH_DOC_TYPE');
815: FND_MESSAGE.SET_TOKEN('DOC_TYPE', wsh_util_core.get_lookup_meaning('WSH_TXN_DOCUMENT_TYPE',p_doctype));
816: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
817:
818: FND_MESSAGE.SET_NAME('WSH', 'WSH_SHIP_TYPE');
819: FND_MESSAGE.SET_TOKEN('SHIP_TYPE', wsh_util_core.get_lookup_meaning('WSH_SHIPMENT_TYPE',p_shipment_type));

Line 819: FND_MESSAGE.SET_TOKEN('SHIP_TYPE', wsh_util_core.get_lookup_meaning('WSH_SHIPMENT_TYPE',p_shipment_type));

815: FND_MESSAGE.SET_TOKEN('DOC_TYPE', wsh_util_core.get_lookup_meaning('WSH_TXN_DOCUMENT_TYPE',p_doctype));
816: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
817:
818: FND_MESSAGE.SET_NAME('WSH', 'WSH_SHIP_TYPE');
819: FND_MESSAGE.SET_TOKEN('SHIP_TYPE', wsh_util_core.get_lookup_meaning('WSH_SHIPMENT_TYPE',p_shipment_type));
820: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
821:
822: /*Modified R12.1.1 LSP PROJECT*/
823: IF p_client_id IS NOT NULL THEN

Line 832: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

828: x_client_name => l_client_name,
829: x_client_code => l_client_code,
830: x_return_status => l_return_status);
831:
832: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
833: --{
834: IF l_debug_on THEN
835: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occured in WMS_DEPLOY.GET_CLIENT_DETAILS');
836: END IF;

Line 852: FND_MESSAGE.SET_TOKEN('ORG_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));

848: /*Modified R12.1.1 LSP PROJECT*/
849:
850:
851: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ORG');
852: FND_MESSAGE.SET_TOKEN('ORG_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
853: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
854:
855: FND_MESSAGE.SET_NAME('WSH', 'WSH_ORDER_FROM');
856: FND_MESSAGE.SET_TOKEN('ORDER',p_src_header_num_from );

Line 900: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

896: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_log_level));
897: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
898:
899: IF (l_delivery_count < 1 ) THEN
900: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
901: FND_FILE.put_line(FND_FILE.output,' ');
902: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_DEL_FOR_PARAMETERS');
903: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
904: IF l_debug_on THEN

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

1010: END IF;
1011: ----** Output to Concurrent Output File **---
1012:
1013: --Bugfix 4070732 {
1014: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1015: THEN --{
1016: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1017: IF l_debug_on THEN
1018: 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 1016: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1012:
1013: --Bugfix 4070732 {
1014: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1015: THEN --{
1016: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1019: END IF;
1020: WSH_UTIL_CORE.Process_stops_for_load_tender(

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

1014: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
1015: THEN --{
1016: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1019: END IF;
1020: WSH_UTIL_CORE.Process_stops_for_load_tender(
1021: p_reset_flags => TRUE,
1022: x_return_status => l_return_status);

Line 1020: WSH_UTIL_CORE.Process_stops_for_load_tender(

1016: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1017: IF l_debug_on THEN
1018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1019: END IF;
1020: WSH_UTIL_CORE.Process_stops_for_load_tender(
1021: p_reset_flags => TRUE,
1022: x_return_status => l_return_status);
1023: IF l_debug_on THEN
1024: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 1028: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

1024: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1025: END IF;
1026:
1027:
1028: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1029: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1030: THEN --{
1031: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1032: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR

Line 1029: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

1025: END IF;
1026:
1027:
1028: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1029: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1030: THEN --{
1031: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1032: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1033: THEN

Line 1031: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1027:
1028: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1029: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1030: THEN --{
1031: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1032: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1033: THEN
1034: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1032: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR

1028: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1029: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1030: THEN --{
1031: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1032: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1033: THEN
1034: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1036: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 1034: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

1030: THEN --{
1031: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1032: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1033: THEN
1034: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1036: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1037: THEN
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1031: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1032: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1033: THEN
1034: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1036: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1037: THEN
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1039: END IF;

Line 1036: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

1032: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
1033: THEN
1034: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1036: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1037: THEN
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1039: END IF;
1040: END IF; --}

Line 1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1034: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1036: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
1037: THEN
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1039: END IF;
1040: END IF; --}
1041: END IF;
1042: END IF; --}

Line 1054: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1050:
1051: EXCEPTION
1052:
1053: WHEN others THEN
1054: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1055: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Process_Auto_Manifest',l_module_name);
1056: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
1057:
1058: --Start of bug 4070732

Line 1055: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Process_Auto_Manifest',l_module_name);

1051: EXCEPTION
1052:
1053: WHEN others THEN
1054: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1055: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Process_Auto_Manifest',l_module_name);
1056: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
1057:
1058: --Start of bug 4070732
1059:

Line 1056: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);

1052:
1053: WHEN others THEN
1054: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1055: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Process_Auto_Manifest',l_module_name);
1056: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
1057:
1058: --Start of bug 4070732
1059:
1060: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

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

1056: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
1057:
1058: --Start of bug 4070732
1059:
1060: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1061: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1062: IF l_debug_on THEN
1063: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1064: END IF;

Line 1061: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

1057:
1058: --Start of bug 4070732
1059:
1060: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1061: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1062: IF l_debug_on THEN
1063: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1064: END IF;
1065:

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

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

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

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

Line 1136: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1132: OPEN c_lock_delivery;
1133: FETCH c_lock_delivery INTO l_delivery_id,l_status_code;
1134: CLOSE c_lock_delivery;
1135:
1136: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1137: IF l_debug_on THEN
1138: wsh_debug_sv.pop(l_module_name);
1139: END IF;
1140: EXCEPTION

Line 1142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1138: wsh_debug_sv.pop(l_module_name);
1139: END IF;
1140: EXCEPTION
1141: WHEN RECORD_LOCKED THEN
1142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1143: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
1144: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1140: EXCEPTION
1141: WHEN RECORD_LOCKED THEN
1142: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1143: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
1144: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1147: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1148: END IF;

Line 1151: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1147: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1148: END IF;
1149:
1150: WHEN others THEN
1151: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1152: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Lock_Manifest_Delivery',l_module_name);
1153:
1154: IF l_debug_on THEN
1155: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

Line 1152: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Lock_Manifest_Delivery',l_module_name);

1148: END IF;
1149:
1150: WHEN others THEN
1151: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1152: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Lock_Manifest_Delivery',l_module_name);
1153:
1154: IF l_debug_on THEN
1155: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1156: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1231: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1227: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_TO_DATE',p_scheduled_to_date);
1228: END IF;
1229:
1230: x_validate := 'Y';
1231: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1232:
1233: IF (p_scheduled_from_date IS NULL AND p_scheduled_to_date IS NULL ) THEN
1234: IF l_debug_on THEN
1235: wsh_debug_sv.pop(l_module_name,'RETURN');

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

1254: IF (l_count < 1 ) THEN
1255: x_validate := 'N';
1256: FND_MESSAGE.SET_NAME('WSH','WSH_SCH_DATE_NOT_IN_RANGED');
1257: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1258: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1259: END IF;
1260:
1261: IF l_debug_on THEN
1262: wsh_debug_sv.pop(l_module_name);

Line 1267: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Validate_Scheduled_Ship_Date',l_module_name);

1263: END IF;
1264: EXCEPTION
1265: WHEN others THEN
1266: x_validate := 'N';
1267: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Validate_Scheduled_Ship_Date',l_module_name);
1268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1269:
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

Line 1268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1264: EXCEPTION
1265: WHEN others THEN
1266: x_validate := 'N';
1267: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Validate_Scheduled_Ship_Date',l_module_name);
1268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1269:
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1272: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);