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 77: wsh_util_core.api_post_call

73: p_doctype => p_doctype,
74: p_src_header_num_from => p_src_header_num_from,
75: p_src_header_num_to => p_src_header_num_to );
76:
77: wsh_util_core.api_post_call
78: (
79: p_return_status => l_return_status,
80: x_num_warnings => l_warning_count,
81: x_num_errors => l_error_count,

Line 89: l_otm_installed := WSH_UTIL_CORE.GC3_Is_Installed;

85: END IF; --}
86: IF ((p_doctype = 'SR')
87: AND ((p_shipment_type IS NULL) OR (p_shipment_type = 'CMS') OR
88: (p_shipment_type = 'BOTH'))) THEN --{
89: l_otm_installed := WSH_UTIL_CORE.GC3_Is_Installed;
90: IF l_otm_installed = 'N' THEN --{
91: Process_Auto_Manifest (
92: p_organization_id => p_organization_id,
93: p_carrier_id => p_carrier_id,

Line 108: wsh_util_core.api_post_call

104: p_doctype => p_doctype,
105: p_src_header_num_from => p_src_header_num_from,
106: p_src_header_num_to => p_src_header_num_to );
107:
108: wsh_util_core.api_post_call
109: (
110: p_return_status => l_return_status,
111: x_num_warnings => l_warning_count,
112: x_num_errors => l_error_count,

Line 120: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

116: END IF; --}
117:
118: IF l_error_count > 0
119: THEN
120: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
121: ELSIF l_warning_count > 0
122: THEN
123: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
124: ELSE

Line 123: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

119: THEN
120: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
121: ELSIF l_warning_count > 0
122: THEN
123: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
124: ELSE
125: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
126: END IF;
127:

Line 125: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

121: ELSIF l_warning_count > 0
122: THEN
123: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
124: ELSE
125: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
126: END IF;
127:
128:
129: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 129: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

125: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
126: END IF;
127:
128:
129: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
130: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', '');
131: --errbuf := 'Automated Carrier Manifesting is completed Successfully';
132: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_NORMAL');
133: errbuf := FND_MESSAGE.GET;

Line 135: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

131: --errbuf := 'Automated Carrier Manifesting is completed Successfully';
132: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_NORMAL');
133: errbuf := FND_MESSAGE.GET;
134: retcode := '0';
135: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
136: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS( 'WARNING', '');
137: --errbuf := 'Automated Carrier Manifesting is completed with Warning';
138: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_WARNING');
139: errbuf := FND_MESSAGE.GET;

Line 334: l_entity_ids WSH_UTIL_CORE.id_tab_type;

330: l_customer_name VARCHAR2(80);
331: l_location VARCHAR2(200);
332: l_autopack VARCHAR2(5);
333:
334: l_entity_ids WSH_UTIL_CORE.id_tab_type;
335: l_con_ids WSH_UTIL_CORE.id_tab_type;
336: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
337: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
338: l_group_id_tab WSH_UTIL_CORE.id_tab_type;

Line 335: l_con_ids WSH_UTIL_CORE.id_tab_type;

331: l_location VARCHAR2(200);
332: l_autopack VARCHAR2(5);
333:
334: l_entity_ids WSH_UTIL_CORE.id_tab_type;
335: l_con_ids WSH_UTIL_CORE.id_tab_type;
336: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
337: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
338: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
339: l_success_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;

Line 336: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;

332: l_autopack VARCHAR2(5);
333:
334: l_entity_ids WSH_UTIL_CORE.id_tab_type;
335: l_con_ids WSH_UTIL_CORE.id_tab_type;
336: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
337: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
338: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
339: l_success_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;
340: l_success_count NUMBER := 0;

Line 337: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;

333:
334: l_entity_ids WSH_UTIL_CORE.id_tab_type;
335: l_con_ids WSH_UTIL_CORE.id_tab_type;
336: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
337: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
338: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
339: l_success_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;
340: l_success_count NUMBER := 0;
341: l_error_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;

Line 338: l_group_id_tab WSH_UTIL_CORE.id_tab_type;

334: l_entity_ids WSH_UTIL_CORE.id_tab_type;
335: l_con_ids WSH_UTIL_CORE.id_tab_type;
336: l_err_entity_ids WSH_UTIL_CORE.id_tab_type;
337: l_cont_inst_tab WSH_UTIL_CORE.id_tab_type;
338: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
339: l_success_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;
340: l_success_count NUMBER := 0;
341: l_error_delivery WSH_AUTO_MANIFEST.tab_delivery_msg;
342: l_error_count NUMBER := 0;

Line 372: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN

368:
369: BEGIN
370: --
371: -- Bug 4070732
372: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
373: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
374: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
375: END IF;
376:

Line 373: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;

369: BEGIN
370: --
371: -- Bug 4070732
372: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
373: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
374: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
375: END IF;
376:
377: --

Line 374: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;

370: --
371: -- Bug 4070732
372: IF WSH_UTIL_CORE.G_START_OF_SESSION_API is null THEN
373: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
374: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
375: END IF;
376:
377: --
378: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 409: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

405: END IF;
406:
407:
408:
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
410:
411: IF l_debug_on THEN
412: wsh_debug_sv.log (l_module_name, 'Begining of FOR LOOP');
413: END IF;

Line 467: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

463:
464: -- set the return status to success if no exception raised, as the
465: -- API Lock_Dlvy_No_Compare does not have a x_return_status
466:
467: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
468:
469: EXCEPTION
470: WHEN app_exception.application_exception
471: OR app_exception.record_lock_exception THEN

Line 472: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

468:
469: EXCEPTION
470: WHEN app_exception.application_exception
471: OR app_exception.record_lock_exception THEN
472: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
473: END ;
474:
475: IF l_debug_on THEN
476: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);

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

475: IF l_debug_on THEN
476: wsh_debug_sv.log (l_module_name,'wsh_new_deliveries_pvt.Lock_Dlvy_No_Compare return status: ',l_return_status);
477: END IF;
478:
479: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN --1.IF {
480:
481: IF p_shipment_type = 'CMS' AND p_doctype = 'SR' THEN --{
482:
483: l_calling_api := 'Calling WSH_DELIVERY_VALIDATIONS.Check_Pack';

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

489: IF l_debug_on THEN
490: wsh_debug_sv.log (l_module_name,'WSH_DELIVERY_VALIDATIONS.Check_Pack Return Status',l_return_status);
491: END IF;
492:
493: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN --3.IF {
494:
495: IF ( nvl(p_autopack,'N') = 'Y' ) THEN -- {
496: l_calling_api := 'Calling WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery';
497:

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

505: wsh_debug_sv.log (l_module_name,'WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery Return Status',
506: l_return_status);
507: END IF;
508:
509: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )THEN --5.IF
510: l_delivery_status := 'ERROR';
511: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --5.IF
512: l_warning_index := l_warning_index +1;
513: END IF; --5.IF

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

507: END IF;
508:
509: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) )THEN --5.IF
510: l_delivery_status := 'ERROR';
511: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --5.IF
512: l_warning_index := l_warning_index +1;
513: END IF; --5.IF
514:
515: ELSE -- }{

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

515: ELSE -- }{
516: l_delivery_status := 'ERROR';
517: END IF; --}
518:
519: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --}{
520: l_warning_index := l_warning_index +1;
521: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --}{
522: l_delivery_status := 'ERROR';
523: END IF; --}

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

517: END IF; --}
518:
519: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --}{
520: l_warning_index := l_warning_index +1;
521: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN --}{
522: l_delivery_status := 'ERROR';
523: END IF; --}
524: END IF; --}
525:

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

538: IF l_debug_on THEN
539: wsh_debug_sv.log (l_module_name,'WSH_TRANSACTIONS_UTIL.Send_Document Return Status',l_return_status);
540: END IF;
541:
542: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING )) THEN --{
543: l_delivery_status := 'ERROR';
544: ELSE --}{
545: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
546: l_warning_index := l_warning_index +1;

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

541:
542: IF ( l_return_status not in (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING )) THEN --{
543: l_delivery_status := 'ERROR';
544: ELSE --}{
545: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
546: l_warning_index := l_warning_index +1;
547: END IF;
548: END IF; --}
549: END IF; --}

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

552: l_delivery_status := 'ERROR';
553: END IF; --}
554:
555:
556: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
557: IF (l_msg_count < 2 ) THEN
558: l_msg_details := NULL;
559: END IF;
560:

Line 575: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

571: wsh_debug_sv.log (l_module_name,'Success l_warning_index: ',l_warning_index);
572: END IF;
573:
574: --Start of bug 4070732
575: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
576:
577: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
578:
579: IF l_debug_on THEN

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

573:
574: --Start of bug 4070732
575: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
576:
577: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
578:
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
581: END IF;

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

576:
577: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN --{
578:
579: IF l_debug_on THEN
580: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
581: END IF;
582:
583: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
584: x_return_status => l_return_status);

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

579: IF l_debug_on THEN
580: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
581: END IF;
582:
583: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
584: x_return_status => l_return_status);
585:
586: IF l_debug_on THEN
587: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

Line 589: wsh_util_core.api_post_call

585:
586: IF l_debug_on THEN
587: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
588: END IF;
589: wsh_util_core.api_post_call
590: (
591: p_return_status => l_return_status,
592: x_num_warnings => l_warning_count,
593: x_num_errors => l_error_count,

Line 598: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

594: p_raise_error_flag => FALSE
595: );
596: END IF; --}
597: -- End of bug 4070732
598: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
599: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
600: IF ( l_warning_index > 0 ) THEN --{
601: IF l_debug_on THEN
602: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS with WARNING');

Line 599: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{

595: );
596: END IF; --}
597: -- End of bug 4070732
598: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
599: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
600: IF ( l_warning_index > 0 ) THEN --{
601: IF l_debug_on THEN
602: wsh_debug_sv.log(l_module_name,'Delivery Status: SUCCESS with WARNING');
603: END IF;

Line 619: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,

615: l_success_delivery(l_success_count).msg_details := l_msg_details;
616: END IF; --}
617: END IF; --}
618:
619: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
620: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
621: COMMIT;
622: ELSE --}{
623: IF l_debug_on THEN

Line 620: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{

616: END IF; --}
617: END IF; --}
618:
619: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,
620: WSH_UTIL_CORE.G_RET_STS_WARNING) THEN --{
621: COMMIT;
622: ELSE --}{
623: IF l_debug_on THEN
624: wsh_debug_sv.log(l_module_name,'Delivery Status: ERROR');

Line 647: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

643: END LOOP; --}
644:
645:
646: IF l_error_count > 0 THEN
647: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
648: IF l_delivery_count = l_error_count THEN
649: IF l_debug_on THEN
650: wsh_debug_sv.log(l_module_name,'All Deliveries selected are having error');
651: END IF;

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

675: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
676: FND_FILE.put_line(FND_FILE.output,'==========');
677:
678: FND_MESSAGE.SET_NAME('WSH', 'WSH_DOC_TYPE');
679: FND_MESSAGE.SET_TOKEN('DOC_TYPE', wsh_util_core.get_lookup_meaning('WSH_TXN_DOCUMENT_TYPE',p_doctype));
680: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
681:
682: FND_MESSAGE.SET_NAME('WSH', 'WSH_SHIP_TYPE');
683: FND_MESSAGE.SET_TOKEN('SHIP_TYPE', wsh_util_core.get_lookup_meaning('WSH_SHIPMENT_TYPE',p_shipment_type));

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

679: FND_MESSAGE.SET_TOKEN('DOC_TYPE', wsh_util_core.get_lookup_meaning('WSH_TXN_DOCUMENT_TYPE',p_doctype));
680: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
681:
682: FND_MESSAGE.SET_NAME('WSH', 'WSH_SHIP_TYPE');
683: FND_MESSAGE.SET_TOKEN('SHIP_TYPE', wsh_util_core.get_lookup_meaning('WSH_SHIPMENT_TYPE',p_shipment_type));
684: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
685:
686: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ORG');
687: FND_MESSAGE.SET_TOKEN('ORG_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));

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

683: FND_MESSAGE.SET_TOKEN('SHIP_TYPE', wsh_util_core.get_lookup_meaning('WSH_SHIPMENT_TYPE',p_shipment_type));
684: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
685:
686: FND_MESSAGE.SET_NAME('WSH', 'WSH_MANIFEST_ORG');
687: FND_MESSAGE.SET_TOKEN('ORG_NAME', WSH_UTIL_CORE.Get_Org_Name(p_organization_id));
688: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
689:
690: FND_MESSAGE.SET_NAME('WSH', 'WSH_ORDER_FROM');
691: FND_MESSAGE.SET_TOKEN('ORDER',p_src_header_num_from );

Line 727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

723: FND_MESSAGE.SET_TOKEN('LOG_LEVEL', to_char(p_log_level));
724: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
725:
726: IF (l_delivery_count < 1 ) THEN
727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
728: FND_FILE.put_line(FND_FILE.output,' ');
729: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_DEL_FOR_PARAMETERS');
730: FND_FILE.put_line(FND_FILE.output,FND_MESSAGE.GET);
731: IF l_debug_on THEN

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

837: END IF;
838: ----** Output to Concurrent Output File **---
839:
840: --Bugfix 4070732 {
841: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
842: THEN --{
843: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
844: IF l_debug_on THEN
845: 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 843: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

839:
840: --Bugfix 4070732 {
841: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
842: THEN --{
843: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
846: END IF;
847: WSH_UTIL_CORE.Process_stops_for_load_tender(

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

841: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name)
842: THEN --{
843: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
846: END IF;
847: WSH_UTIL_CORE.Process_stops_for_load_tender(
848: p_reset_flags => TRUE,
849: x_return_status => l_return_status);

Line 847: WSH_UTIL_CORE.Process_stops_for_load_tender(

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

Line 855: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

851: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
852: END IF;
853:
854:
855: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
856: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
857: THEN --{
858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
859: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR

Line 856: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

852: END IF;
853:
854:
855: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
856: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
857: THEN --{
858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
859: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
860: THEN

Line 858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

854:
855: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
856: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
857: THEN --{
858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
859: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
860: THEN
861: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 859: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR

855: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
856: OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
857: THEN --{
858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
859: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
860: THEN
861: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
863: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

Line 861: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

857: THEN --{
858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
859: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
860: THEN
861: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
863: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
864: THEN
865: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

858: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
859: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
860: THEN
861: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
863: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
864: THEN
865: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
866: END IF;

Line 863: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

859: ELSIF x_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR
860: THEN
861: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
863: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
864: THEN
865: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
866: END IF;
867: END IF; --}

Line 865: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

861: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
862: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
863: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
864: THEN
865: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
866: END IF;
867: END IF; --}
868: END IF;
869: END IF; --}

Line 881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

877:
878: EXCEPTION
879:
880: WHEN others THEN
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
882: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Process_Auto_Manifest',l_module_name);
883: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
884:
885: --Start of bug 4070732

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

878: EXCEPTION
879:
880: WHEN others THEN
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
882: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Process_Auto_Manifest',l_module_name);
883: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
884:
885: --Start of bug 4070732
886:

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

879:
880: WHEN others THEN
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
882: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Process_Auto_Manifest',l_module_name);
883: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
884:
885: --Start of bug 4070732
886:
887: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

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

883: WSH_UTIL_CORE.get_messages('Y', l_msg_summary, l_msg_details, l_msg_count);
884:
885: --Start of bug 4070732
886:
887: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
888: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
891: END IF;

Line 888: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN

884:
885: --Start of bug 4070732
886:
887: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
888: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
891: END IF;
892:

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

886:
887: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
888: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
891: END IF;
892:
893: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
894: x_return_status => l_return_status);

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

889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
891: END IF;
892:
893: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
894: x_return_status => l_return_status);
895: IF l_debug_on THEN
896: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
897: END IF;

Line 963: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

959: OPEN c_lock_delivery;
960: FETCH c_lock_delivery INTO l_delivery_id,l_status_code;
961: CLOSE c_lock_delivery;
962:
963: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
964: IF l_debug_on THEN
965: wsh_debug_sv.pop(l_module_name);
966: END IF;
967: EXCEPTION

Line 969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

965: wsh_debug_sv.pop(l_module_name);
966: END IF;
967: EXCEPTION
968: WHEN RECORD_LOCKED THEN
969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
970: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
971: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
972: IF l_debug_on THEN
973: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

967: EXCEPTION
968: WHEN RECORD_LOCKED THEN
969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
970: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
971: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
972: IF l_debug_on THEN
973: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
975: END IF;

Line 978: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

974: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
975: END IF;
976:
977: WHEN others THEN
978: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
979: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Lock_Manifest_Delivery',l_module_name);
980:
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

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

975: END IF;
976:
977: WHEN others THEN
978: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
979: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Lock_Manifest_Delivery',l_module_name);
980:
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
983: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1054: wsh_debug_sv.log (l_module_name,'P_SCHEDULED_TO_DATE',p_scheduled_to_date);
1055: END IF;
1056:
1057: x_validate := 'Y';
1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1059:
1060: IF (p_scheduled_from_date IS NULL AND p_scheduled_to_date IS NULL ) THEN
1061: IF l_debug_on THEN
1062: wsh_debug_sv.pop(l_module_name,'RETURN');

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

1081: IF (l_count < 1 ) THEN
1082: x_validate := 'N';
1083: FND_MESSAGE.SET_NAME('WSH','WSH_SCH_DATE_NOT_IN_RANGED');
1084: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
1085: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1086: END IF;
1087:
1088: IF l_debug_on THEN
1089: wsh_debug_sv.pop(l_module_name);

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

1090: END IF;
1091: EXCEPTION
1092: WHEN others THEN
1093: x_validate := 'N';
1094: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Validate_Scheduled_Ship_Date',l_module_name);
1095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1096:
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,

Line 1095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1091: EXCEPTION
1092: WHEN others THEN
1093: x_validate := 'N';
1094: wsh_util_core.default_handler('WSH_AUTO_MANIFEST.Validate_Scheduled_Ship_Date',l_module_name);
1095: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1096:
1097: IF l_debug_on THEN
1098: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
1099: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);