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

Line 279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

275: --{
276: fnd_msg_pub.initialize;
277: --}
278: END IF;
279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
280: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
281:
282: l_batch_in_rec := p_batch_rec;
283: l_rule_id := p_rule_id;

Line 280: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

276: fnd_msg_pub.initialize;
277: --}
278: END IF;
279: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
280: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
281:
282: l_batch_in_rec := p_batch_rec;
283: l_rule_id := p_rule_id;
284: l_rule_name := p_rule_name;

Line 377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

373: END IF;
374: --
375: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICKING_RULE');
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
378: wsh_util_core.add_message(x_return_status);
379: CLOSE Get_Picking_Rule_Info;
380: IF l_debug_on THEN
381: --{

Line 378: wsh_util_core.add_message(x_return_status);

374: --
375: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICKING_RULE');
377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
378: wsh_util_core.add_message(x_return_status);
379: CLOSE Get_Picking_Rule_Info;
380: IF l_debug_on THEN
381: --{
382: WSH_DEBUG_SV.pop(l_module_name);

Line 414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

410: IF ( l_batch_in_rec.Backorders_Only_Flag NOT IN ('I','E','O','M') ) THEN
411: --{
412: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BACKORDERS_ONLY_FLAG ');
414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
415: wsh_util_core.add_message(x_return_status);
416: return;
417: --}
418: END IF;

Line 415: wsh_util_core.add_message(x_return_status);

411: --{
412: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BACKORDERS_ONLY_FLAG ');
414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
415: wsh_util_core.add_message(x_return_status);
416: return;
417: --}
418: END IF;
419: l_batch_grp_rec.Backorders_Only_Flag := l_batch_in_rec.Backorders_Only_Flag ;

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

453: x_client_code => l_batch_in_rec.client_code,
454: x_client_name => l_client_name,
455: x_return_status => l_return_status);
456: IF l_debug_on THEN
457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
458: END IF;
459: --
460: wsh_util_core.api_post_call(
461: p_return_status => l_return_status,

Line 460: wsh_util_core.api_post_call(

456: IF l_debug_on THEN
457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
458: END IF;
459: --
460: wsh_util_core.api_post_call(
461: p_return_status => l_return_status,
462: x_num_warnings => l_number_of_warnings,
463: x_num_errors => l_number_of_errors,
464: p_msg_data => l_msg_data);

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

505: x_return_status => l_return_status);
506:
507: IF l_debug_on THEN
508: --{
509: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
510: --}
511: END IF;
512: --
513: wsh_util_core.api_post_call(

Line 513: wsh_util_core.api_post_call(

509: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
510: --}
511: END IF;
512: --
513: wsh_util_core.api_post_call(
514: p_return_status => l_return_status,
515: x_num_warnings => l_number_of_warnings,
516: x_num_errors => l_number_of_errors,
517: p_msg_data => l_msg_data

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

529: p_organization_id => l_batch_grp_rec.Organization_Id);
530:
531: IF l_debug_on THEN
532: --{
533: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
534: --}
535: END IF;
536: --
537: wsh_util_core.api_post_call(

Line 537: wsh_util_core.api_post_call(

533: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
534: --}
535: END IF;
536: --
537: wsh_util_core.api_post_call(
538: p_return_status => l_return_status,
539: x_num_warnings => l_number_of_warnings,
540: x_num_errors => l_number_of_errors,
541: p_msg_data => l_msg_data

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

579: x_return_status => l_return_status);
580:
581: IF l_debug_on THEN
582: --{
583: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
584: --}
585: END IF;
586: --
587: wsh_util_core.api_post_call(

Line 587: wsh_util_core.api_post_call(

583: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
584: --}
585: END IF;
586: --
587: wsh_util_core.api_post_call(
588: p_return_status => l_return_status,
589: x_num_warnings => l_number_of_warnings,
590: x_num_errors => l_number_of_errors,
591: p_msg_data => l_msg_data

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

627: x_return_status => l_return_status);
628:
629: IF l_debug_on THEN
630: --{
631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
632: --}
633: END IF;
634: --
635: wsh_util_core.api_post_call(

Line 635: wsh_util_core.api_post_call(

631: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
632: --}
633: END IF;
634: --
635: wsh_util_core.api_post_call(
636: p_return_status => l_return_status,
637: x_num_warnings => l_number_of_warnings,
638: x_num_errors => l_number_of_errors,
639: p_msg_data => l_msg_data

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

675: x_return_status => l_return_status);
676:
677: IF l_debug_on THEN
678: --{
679: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
680: --}
681: END IF;
682: --
683: wsh_util_core.api_post_call(

Line 683: wsh_util_core.api_post_call(

679: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
680: --}
681: END IF;
682: --
683: wsh_util_core.api_post_call(
684: p_return_status => l_return_status,
685: x_num_warnings => l_number_of_warnings,
686: x_num_errors => l_number_of_errors,
687: p_msg_data => l_msg_data

Line 721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

717: IF ( Get_Order_Type_id%NOTFOUND ) THEN
718: --{
719: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
720: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_TYPE');
721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
722: wsh_util_core.add_message(x_return_status);
723: CLOSE Get_Order_Type_id;
724: return;
725: --}

Line 722: wsh_util_core.add_message(x_return_status);

718: --{
719: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
720: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_TYPE');
721: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
722: wsh_util_core.add_message(x_return_status);
723: CLOSE Get_Order_Type_id;
724: return;
725: --}
726: END IF;

Line 757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

753: IF ( l_batch_in_rec.order_number IS NOT NULL AND l_batch_grp_rec.order_type_id IS NULL ) THEN
754: --{
755: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER AND ORDER_TYPE_ID combination');
757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
758: wsh_util_core.add_message(x_return_status);
759: return;
760: --}
761: END IF;

Line 758: wsh_util_core.add_message(x_return_status);

754: --{
755: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER AND ORDER_TYPE_ID combination');
757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
758: wsh_util_core.add_message(x_return_status);
759: return;
760: --}
761: END IF;
762: IF ( ( l_batch_in_rec.order_header_id IS NOT NULL ) OR ( l_batch_in_rec.order_number IS NOT NULL AND l_batch_grp_rec.order_type_id IS NOT NULL ) ) THEN

Line 770: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

766: IF ( Get_Order_Header_id%NOTFOUND ) THEN
767: --{
768: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER OR ORDER_HEADER_ID');
770: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
771: wsh_util_core.add_message(x_return_status);
772: CLOSE Get_Order_Header_id;
773: return;
774: --}

Line 771: wsh_util_core.add_message(x_return_status);

767: --{
768: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER OR ORDER_HEADER_ID');
770: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
771: wsh_util_core.add_message(x_return_status);
772: CLOSE Get_Order_Header_id;
773: return;
774: --}
775: END IF;

Line 805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

801: IF ( l_batch_in_rec.ship_set_number IS NOT NULL AND l_batch_grp_rec.order_header_id IS NULL ) THEN
802: --{
803: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER AND ORDER_HEADER_ID combination');
805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
806: wsh_util_core.add_message(x_return_status);
807: return;
808: --}
809: END IF;

Line 806: wsh_util_core.add_message(x_return_status);

802: --{
803: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER AND ORDER_HEADER_ID combination');
805: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
806: wsh_util_core.add_message(x_return_status);
807: return;
808: --}
809: END IF;
810: IF ( ( l_batch_in_rec.ship_set_id IS NOT NULL ) OR ( l_batch_in_rec.ship_set_number IS NOT NULL AND l_batch_grp_rec.order_header_id IS NOT NULL ) ) THEN

Line 818: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

814: IF ( Get_Ship_Set_Id%NOTFOUND ) THEN
815: --{
816: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER OR SHIP_SET_ID');
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
819: wsh_util_core.add_message(x_return_status);
820: CLOSE Get_Ship_Set_Id;
821: return;
822: --}

Line 819: wsh_util_core.add_message(x_return_status);

815: --{
816: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
817: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER OR SHIP_SET_ID');
818: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
819: wsh_util_core.add_message(x_return_status);
820: CLOSE Get_Ship_Set_Id;
821: return;
822: --}
823: END IF;

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

860: p_isWshLocation => TRUE);
861:
862: IF l_debug_on THEN
863: --{
864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
865: --}
866: END IF;
867: --
868: wsh_util_core.api_post_call(

Line 868: wsh_util_core.api_post_call(

864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
865: --}
866: END IF;
867: --
868: wsh_util_core.api_post_call(
869: p_return_status => l_return_status,
870: x_num_warnings => l_number_of_warnings,
871: x_num_errors => l_number_of_errors,
872: p_msg_data => l_msg_data

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

912: p_isWshLocation => TRUE);
913:
914: IF l_debug_on THEN
915: --{
916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
917: --}
918: END IF;
919: --
920: wsh_util_core.api_post_call(

Line 920: wsh_util_core.api_post_call(

916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
917: --}
918: END IF;
919: --
920: wsh_util_core.api_post_call(
921: p_return_status => l_return_status,
922: x_num_warnings => l_number_of_warnings,
923: x_num_errors => l_number_of_errors,
924: p_msg_data => l_msg_data

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

965: x_return_status => l_return_status);
966:
967: IF l_debug_on THEN
968: --{
969: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
970: --}
971: END IF;
972: --
973: wsh_util_core.api_post_call(

Line 973: wsh_util_core.api_post_call(

969: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
970: --}
971: END IF;
972: --
973: wsh_util_core.api_post_call(
974: p_return_status => l_return_status,
975: x_num_warnings => l_number_of_warnings,
976: x_num_errors => l_number_of_errors,
977: p_msg_data => l_msg_data

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

1014: x_return_status => l_return_status);
1015:
1016: IF l_debug_on THEN
1017: --{
1018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1019: --}
1020: END IF;
1021: --
1022: wsh_util_core.api_post_call(

Line 1022: wsh_util_core.api_post_call(

1018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1019: --}
1020: END IF;
1021: --
1022: wsh_util_core.api_post_call(
1023: p_return_status => l_return_status,
1024: x_num_warnings => l_number_of_warnings,
1025: x_num_errors => l_number_of_errors,
1026: p_msg_data => l_msg_data

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

1078: x_return_status => l_return_status);
1079:
1080: IF l_debug_on THEN
1081: --{
1082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1083: --}
1084: END IF;
1085: --
1086: wsh_util_core.api_post_call(

Line 1086: wsh_util_core.api_post_call(

1082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1083: --}
1084: END IF;
1085: --
1086: wsh_util_core.api_post_call(
1087: p_return_status => l_return_status,
1088: x_num_warnings => l_number_of_warnings,
1089: x_num_errors => l_number_of_errors,
1090: p_msg_data => l_msg_data

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

1130: x_return_status => l_return_status);
1131:
1132: IF l_debug_on THEN
1133: --{
1134: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1135: --}
1136: END IF;
1137: --
1138: wsh_util_core.api_post_call(

Line 1138: wsh_util_core.api_post_call(

1134: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1135: --}
1136: END IF;
1137: --
1138: wsh_util_core.api_post_call(
1139: p_return_status => l_return_status,
1140: x_num_warnings => l_number_of_warnings,
1141: x_num_errors => l_number_of_errors,
1142: p_msg_data => l_msg_data

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

1179: x_return_status => l_return_status);
1180:
1181: IF l_debug_on THEN
1182: --{
1183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1184: --}
1185: END IF;
1186: --
1187: wsh_util_core.api_post_call(

Line 1187: wsh_util_core.api_post_call(

1183: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1184: --}
1185: END IF;
1186: --
1187: wsh_util_core.api_post_call(
1188: p_return_status => l_return_status,
1189: x_num_warnings => l_number_of_warnings,
1190: x_num_errors => l_number_of_errors,
1191: p_msg_data => l_msg_data

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

1265: x_return_status => l_return_status);
1266:
1267: IF l_debug_on THEN
1268: --{
1269: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1270: --}
1271: END IF;
1272: --
1273: wsh_util_core.api_post_call(

Line 1273: wsh_util_core.api_post_call(

1269: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1270: --}
1271: END IF;
1272: --
1273: wsh_util_core.api_post_call(
1274: p_return_status => l_return_status,
1275: x_num_warnings => l_number_of_warnings,
1276: x_num_errors => l_number_of_errors,
1277: p_msg_data => l_msg_data

Line 1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1297: --{
1298: IF l_batch_in_rec.actual_departure_date IS NOT NULL THEN
1299: --
1300: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACTUAL_DEP_DATE');
1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1302: wsh_util_core.add_message(x_return_status);
1303: --
1304: IF l_debug_on THEN
1305: wsh_debug_sv.logmsg(l_module_name, 'Error - WSH_NO_ACTUAL_DEP_DATE');

Line 1302: wsh_util_core.add_message(x_return_status);

1298: IF l_batch_in_rec.actual_departure_date IS NOT NULL THEN
1299: --
1300: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACTUAL_DEP_DATE');
1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1302: wsh_util_core.add_message(x_return_status);
1303: --
1304: IF l_debug_on THEN
1305: wsh_debug_sv.logmsg(l_module_name, 'Error - WSH_NO_ACTUAL_DEP_DATE');
1306: wsh_debug_sv.pop(l_module_name);

Line 1322: wsh_util_core.api_post_call(

1318: p_ship_confirm_rule_id => l_batch_grp_rec.ship_confirm_rule_id,
1319: p_actual_departure_date => l_batch_in_rec.actual_departure_date,
1320: x_return_status => l_return_status);
1321: --
1322: wsh_util_core.api_post_call(
1323: p_return_status => l_return_status,
1324: x_num_warnings => l_number_of_warnings,
1325: x_num_errors => l_number_of_errors,
1326: p_msg_data => l_msg_data

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

1364: x_return_status => l_return_status);
1365:
1366: IF l_debug_on THEN
1367: --{
1368: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1369: --}
1370: END IF;
1371: --
1372: wsh_util_core.api_post_call(

Line 1372: wsh_util_core.api_post_call(

1368: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1369: --}
1370: END IF;
1371: --
1372: wsh_util_core.api_post_call(
1373: p_return_status => l_return_status,
1374: x_num_warnings => l_number_of_warnings,
1375: x_num_errors => l_number_of_errors,
1376: p_msg_data => l_msg_data

Line 1401: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1397: IF ( Check_Item_id%NOTFOUND ) THEN
1398: --{
1399: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INVENTORY_ITEM_ID');
1401: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1402: wsh_util_core.add_message(x_return_status);
1403: CLOSE Check_Item_id;
1404: return;
1405: --}

Line 1402: wsh_util_core.add_message(x_return_status);

1398: --{
1399: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INVENTORY_ITEM_ID');
1401: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1402: wsh_util_core.add_message(x_return_status);
1403: CLOSE Check_Item_id;
1404: return;
1405: --}
1406: END IF;

Line 1434: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1430: IF ( Check_Subinventory%NOTFOUND ) THEN
1431: --{
1432: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_SUBINVENTORY');
1434: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1435: wsh_util_core.add_message(x_return_status);
1436: CLOSE Check_Subinventory;
1437: return;
1438: --}

Line 1435: wsh_util_core.add_message(x_return_status);

1431: --{
1432: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_SUBINVENTORY');
1434: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1435: wsh_util_core.add_message(x_return_status);
1436: CLOSE Check_Subinventory;
1437: return;
1438: --}
1439: END IF;

Line 1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1456: IF ( Check_Subinventory%NOTFOUND ) THEN
1457: --{
1458: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REL_SUBINVENTORY');
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: CLOSE Check_Subinventory;
1463: return;
1464: --}

Line 1461: wsh_util_core.add_message(x_return_status);

1457: --{
1458: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','REL_SUBINVENTORY');
1460: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1461: wsh_util_core.add_message(x_return_status);
1462: CLOSE Check_Subinventory;
1463: return;
1464: --}
1465: END IF;

Line 1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1483: IF ( Check_Locator_Id%NOTFOUND ) THEN
1484: --{
1485: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_LOCATOR_ID');
1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1488: wsh_util_core.add_message(x_return_status);
1489: CLOSE Check_Locator_Id;
1490: return;
1491: --}

Line 1488: wsh_util_core.add_message(x_return_status);

1484: --{
1485: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_LOCATOR_ID');
1487: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1488: wsh_util_core.add_message(x_return_status);
1489: CLOSE Check_Locator_Id;
1490: return;
1491: --}
1492: END IF;

Line 1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1511: IF ( Check_Subinventory%NOTFOUND ) THEN
1512: --{
1513: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_SUBINVENTORY');
1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1516: wsh_util_core.add_message(x_return_status);
1517: CLOSE Check_Subinventory;
1518: return;
1519: --}

Line 1516: wsh_util_core.add_message(x_return_status);

1512: --{
1513: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1514: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_SUBINVENTORY');
1515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1516: wsh_util_core.add_message(x_return_status);
1517: CLOSE Check_Subinventory;
1518: return;
1519: --}
1520: END IF;

Line 1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1538: IF ( Check_Locator_Id%NOTFOUND ) THEN
1539: --{
1540: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1541: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_LOCATOR_ID');
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: wsh_util_core.add_message(x_return_status);
1544: CLOSE Check_Locator_Id;
1545: return;
1546: --}

Line 1543: wsh_util_core.add_message(x_return_status);

1539: --{
1540: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1541: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICK_FROM_LOCATOR_ID');
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: wsh_util_core.add_message(x_return_status);
1544: CLOSE Check_Locator_Id;
1545: return;
1546: --}
1547: END IF;

Line 1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1575: IF ( Check_Delivery_Detail_Id%NOTFOUND ) THEN
1576: --{
1577: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DELIVERY_DETAIL_ID');
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1580: wsh_util_core.add_message(x_return_status);
1581: CLOSE Check_Delivery_Detail_Id;
1582: return;
1583: --}

Line 1580: wsh_util_core.add_message(x_return_status);

1576: --{
1577: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DELIVERY_DETAIL_ID');
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1580: wsh_util_core.add_message(x_return_status);
1581: CLOSE Check_Delivery_Detail_Id;
1582: return;
1583: --}
1584: END IF;

Line 1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1605: IF ( Check_Category_Set_Id%NOTFOUND ) THEN
1606: --{
1607: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_SET_ID');
1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1610: wsh_util_core.add_message(x_return_status);
1611: CLOSE Check_Category_Set_Id;
1612: return;
1613: --}

Line 1610: wsh_util_core.add_message(x_return_status);

1606: --{
1607: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_SET_ID');
1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1610: wsh_util_core.add_message(x_return_status);
1611: CLOSE Check_Category_Set_Id;
1612: return;
1613: --}
1614: END IF;

Line 1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1635: IF ( Check_Category_Id%NOTFOUND ) THEN
1636: --{
1637: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_ID');
1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1640: wsh_util_core.add_message(x_return_status);
1641: CLOSE Check_Category_Id;
1642: return;
1643: --}

Line 1640: wsh_util_core.add_message(x_return_status);

1636: --{
1637: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_ID');
1639: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1640: wsh_util_core.add_message(x_return_status);
1641: CLOSE Check_Category_Id;
1642: return;
1643: --}
1644: END IF;

Line 1668: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1664: IF ( l_batch_in_rec.Ship_Set_Smc_Flag NOT IN ('I','E','A') ) THEN
1665: --{
1666: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_SMC_FLAG');
1668: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1669: wsh_util_core.add_message(x_return_status);
1670: return;
1671: --}
1672: END IF;

Line 1669: wsh_util_core.add_message(x_return_status);

1665: --{
1666: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1667: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_SMC_FLAG');
1668: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1669: wsh_util_core.add_message(x_return_status);
1670: return;
1671: --}
1672: END IF;
1673: l_batch_grp_rec.Ship_Set_Smc_Flag :=l_batch_in_rec.Ship_Set_Smc_Flag;

Line 1693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1689: IF ( l_batch_in_rec.Auto_Pick_Confirm_Flag NOT IN ('Y','N') ) THEN
1690: --{
1691: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTO_PICK_CONFIRM_FLAG');
1693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1694: wsh_util_core.add_message(x_return_status);
1695: return;
1696: --}
1697: END IF;

Line 1694: wsh_util_core.add_message(x_return_status);

1690: --{
1691: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTO_PICK_CONFIRM_FLAG');
1693: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1694: wsh_util_core.add_message(x_return_status);
1695: return;
1696: --}
1697: END IF;
1698: l_batch_grp_rec.Auto_Pick_Confirm_Flag := l_batch_in_rec.Auto_Pick_Confirm_Flag;

Line 1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1713: IF ( l_batch_in_rec.Existing_Rsvs_Only_Flag NOT IN ('N','Y')) THEN
1714: --{
1715: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1716: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','EXISTING_RSVS_ONLY_FLAG');
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1718: wsh_util_core.add_message(x_return_status);
1719: return;
1720: --}
1721: END IF;

Line 1718: wsh_util_core.add_message(x_return_status);

1714: --{
1715: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1716: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','EXISTING_RSVS_ONLY_FLAG');
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1718: wsh_util_core.add_message(x_return_status);
1719: return;
1720: --}
1721: END IF;
1722: l_batch_grp_rec.Existing_Rsvs_Only_Flag := l_batch_in_rec.Existing_Rsvs_Only_Flag;

Line 1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1738: IF ( l_batch_in_rec.Include_Planned_Lines NOT IN ('Y','N') ) THEN
1739: --{
1740: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INCLUDE_PLANNED_LINES');
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: wsh_util_core.add_message(x_return_status);
1744: return;
1745: --}
1746: END IF;

Line 1743: wsh_util_core.add_message(x_return_status);

1739: --{
1740: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1741: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INCLUDE_PLANNED_LINES');
1742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1743: wsh_util_core.add_message(x_return_status);
1744: return;
1745: --}
1746: END IF;
1747: l_batch_grp_rec.Include_Planned_Lines := l_batch_in_rec.Include_Planned_Lines;

Line 1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1763: IF ( l_batch_in_rec.Autodetail_Pr_Flag NOT IN ('Y','N') ) THEN
1764: --{
1765: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTODETAIL_PR_FLAG');
1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1768: wsh_util_core.add_message(x_return_status);
1769: return;
1770: --}
1771: END IF;

Line 1768: wsh_util_core.add_message(x_return_status);

1764: --{
1765: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1766: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTODETAIL_PR_FLAG');
1767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1768: wsh_util_core.add_message(x_return_status);
1769: return;
1770: --}
1771: END IF;
1772: l_batch_grp_rec.Autodetail_Pr_Flag :=l_batch_in_rec.Autodetail_Pr_Flag;

Line 1793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1789: IF ( l_batch_in_rec.Autopack_Flag NOT IN ('Y','N') ) THEN
1790: --{
1791: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1792: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_FLAG');
1793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1794: wsh_util_core.add_message(x_return_status);
1795: return;
1796: --}
1797: END IF;

Line 1794: wsh_util_core.add_message(x_return_status);

1790: --{
1791: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1792: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_FLAG');
1793: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1794: wsh_util_core.add_message(x_return_status);
1795: return;
1796: --}
1797: END IF;
1798: l_batch_grp_rec.Autopack_Flag :=l_batch_in_rec.Autopack_Flag;

Line 1820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1816: IF ( l_batch_in_rec.Autopack_Level NOT IN (0,1,2) ) THEN
1817: --{
1818: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1819: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_LEVEL');
1820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1821: wsh_util_core.add_message(x_return_status);
1822: return;
1823: --}
1824: END IF;

Line 1821: wsh_util_core.add_message(x_return_status);

1817: --{
1818: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1819: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_LEVEL');
1820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1821: wsh_util_core.add_message(x_return_status);
1822: return;
1823: --}
1824: END IF;
1825: l_batch_grp_rec.Autopack_Level := l_batch_in_rec.Autopack_Level;

Line 1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1843: IF ( l_batch_in_rec.Task_Planning_Flag NOT IN ('Y','N') ) THEN
1844: --{
1845: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','TASK_PLANNING_FLAG');
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: wsh_util_core.add_message(x_return_status);
1849: return;
1850: --}
1851: END IF;

Line 1848: wsh_util_core.add_message(x_return_status);

1844: --{
1845: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1846: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','TASK_PLANNING_FLAG');
1847: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1848: wsh_util_core.add_message(x_return_status);
1849: return;
1850: --}
1851: END IF;
1852: l_batch_grp_rec.Task_Planning_Flag :=l_batch_in_rec.Task_Planning_Flag;

Line 1879: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1875: IF ( l_batch_in_rec.dynamic_replenishment_flag NOT IN ('Y','N') ) THEN
1876: --{
1877: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1878: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','dynamic_replenishment_flag');
1879: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1880: wsh_util_core.add_message(x_return_status);
1881: return;
1882: --}
1883: END IF;

Line 1880: wsh_util_core.add_message(x_return_status);

1876: --{
1877: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1878: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','dynamic_replenishment_flag');
1879: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1880: wsh_util_core.add_message(x_return_status);
1881: return;
1882: --}
1883: END IF;
1884: l_batch_grp_rec.dynamic_replenishment_flag :=l_batch_in_rec.dynamic_replenishment_flag;

Line 1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1907: IF ( l_batch_in_rec.Non_Picking_flag NOT IN ('Y','N') ) THEN
1908: --{
1909: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','NON_PICKING_FLAG');
1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1912: wsh_util_core.add_message(x_return_status);
1913: return;
1914: --}
1915: END IF;

Line 1912: wsh_util_core.add_message(x_return_status);

1908: --{
1909: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','NON_PICKING_FLAG');
1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1912: wsh_util_core.add_message(x_return_status);
1913: return;
1914: --}
1915: END IF;
1916: l_batch_grp_rec.Non_Picking_flag :=l_batch_in_rec.Non_Picking_flag;

Line 2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2262: l_batch_grp_rec.autocreate_Delivery_flag NOT IN ('Y', 'N')) THEN
2263: --{
2264: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'AUTOCREATE_DELIVERY_FLAG');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2267: wsh_util_core.add_message(x_return_status);
2268: --
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.pop(l_module_name);

Line 2267: wsh_util_core.add_message(x_return_status);

2263: --{
2264: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'AUTOCREATE_DELIVERY_FLAG');
2266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2267: wsh_util_core.add_message(x_return_status);
2268: --
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.pop(l_module_name);
2271: END IF;

Line 2285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2281: IF (l_batch_grp_rec.ac_delivery_criteria IS NOT NULL AND
2282: l_batch_grp_rec.autocreate_delivery_flag <> 'Y') THEN
2283: --{
2284: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACDEL_CRITERIA');
2285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2286: wsh_util_core.add_message(x_return_status, l_module_name);
2287: --
2288: IF l_debug_on THEN
2289: wsh_debug_sv.pop(l_module_name);

Line 2286: wsh_util_core.add_message(x_return_status, l_module_name);

2282: l_batch_grp_rec.autocreate_delivery_flag <> 'Y') THEN
2283: --{
2284: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACDEL_CRITERIA');
2285: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2286: wsh_util_core.add_message(x_return_status, l_module_name);
2287: --
2288: IF l_debug_on THEN
2289: wsh_debug_sv.pop(l_module_name);
2290: END IF;

Line 2300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2296: IF l_batch_grp_rec.Append_Flag = 'Y' or l_batch_grp_rec.Append_Flag is NULL THEN
2297:
2298: IF l_batch_grp_rec.organization_id is NULL THEN
2299: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_ORGANIZATION');
2300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2301: wsh_util_core.add_message(x_return_status);
2302: IF l_debug_on THEN
2303: WSH_DEBUG_SV.pop(l_module_name);
2304: END IF;

Line 2301: wsh_util_core.add_message(x_return_status);

2297:
2298: IF l_batch_grp_rec.organization_id is NULL THEN
2299: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_ORGANIZATION');
2300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2301: wsh_util_core.add_message(x_return_status);
2302: IF l_debug_on THEN
2303: WSH_DEBUG_SV.pop(l_module_name);
2304: END IF;
2305: return;

Line 2317: wsh_util_core.api_post_call(

2313: IF l_debug_on THEN
2314: wsh_debug_sv.logmsg(l_module_name, 'Return status from WSH_SHIPPING_PARAMS_PVT.Get is :'||l_return_status );
2315: END IF;
2316:
2317: wsh_util_core.api_post_call(
2318: p_return_status => l_return_status,
2319: x_num_warnings => l_number_of_warnings,
2320: x_num_errors => l_number_of_errors,
2321: p_msg_data => l_msg_data

Line 2326: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));

2322: );
2323:
2324: IF NVL(l_param_info.appending_limit, 'N') = 'N' THEN
2325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');
2326: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2327: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2328: wsh_util_core.add_message(x_return_status);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.pop(l_module_name);

Line 2327: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2323:
2324: IF NVL(l_param_info.appending_limit, 'N') = 'N' THEN
2325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');
2326: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2327: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2328: wsh_util_core.add_message(x_return_status);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.pop(l_module_name);
2331: END IF;

Line 2328: wsh_util_core.add_message(x_return_status);

2324: IF NVL(l_param_info.appending_limit, 'N') = 'N' THEN
2325: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');
2326: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2327: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2328: wsh_util_core.add_message(x_return_status);
2329: IF l_debug_on THEN
2330: WSH_DEBUG_SV.pop(l_module_name);
2331: END IF;
2332: return;

Line 2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2333: END IF;
2334:
2335: IF NVL(l_batch_grp_rec.autocreate_delivery_flag, 'N') <> 'Y' THEN
2336: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTOCREATE_DEL');
2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2338: wsh_util_core.add_message(x_return_status);
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.pop(l_module_name);
2341: END IF;

Line 2338: wsh_util_core.add_message(x_return_status);

2334:
2335: IF NVL(l_batch_grp_rec.autocreate_delivery_flag, 'N') <> 'Y' THEN
2336: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTOCREATE_DEL');
2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2338: wsh_util_core.add_message(x_return_status);
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.pop(l_module_name);
2341: END IF;
2342: return;

Line 2347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2343: END IF;
2344:
2345: IF NVL(l_batch_grp_rec.ac_delivery_criteria, 'Y') <> 'N' THEN
2346: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AC_DEL_CRITERIA');
2347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2348: wsh_util_core.add_message(x_return_status);
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.pop(l_module_name);
2351: END IF;

Line 2348: wsh_util_core.add_message(x_return_status);

2344:
2345: IF NVL(l_batch_grp_rec.ac_delivery_criteria, 'Y') <> 'N' THEN
2346: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AC_DEL_CRITERIA');
2347: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2348: wsh_util_core.add_message(x_return_status);
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.pop(l_module_name);
2351: END IF;
2352: return;

Line 2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2353: END IF;
2354:
2355: IF NVL(l_batch_grp_rec.auto_pick_confirm_flag, 'Y') <> 'N' THEN
2356: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PICK');
2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2358: wsh_util_core.add_message(x_return_status);
2359: IF l_debug_on THEN
2360: WSH_DEBUG_SV.pop(l_module_name);
2361: END IF;

Line 2358: wsh_util_core.add_message(x_return_status);

2354:
2355: IF NVL(l_batch_grp_rec.auto_pick_confirm_flag, 'Y') <> 'N' THEN
2356: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PICK');
2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2358: wsh_util_core.add_message(x_return_status);
2359: IF l_debug_on THEN
2360: WSH_DEBUG_SV.pop(l_module_name);
2361: END IF;
2362: return;

Line 2367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2363: END IF;
2364:
2365: IF l_batch_grp_rec.ship_confirm_rule_id is not NULL THEN
2366: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_SHIP');
2367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2368: wsh_util_core.add_message(x_return_status);
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.pop(l_module_name);
2371: END IF;

Line 2368: wsh_util_core.add_message(x_return_status);

2364:
2365: IF l_batch_grp_rec.ship_confirm_rule_id is not NULL THEN
2366: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_SHIP');
2367: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2368: wsh_util_core.add_message(x_return_status);
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.pop(l_module_name);
2371: END IF;
2372: return;

Line 2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2373: END IF;
2374:
2375: IF NVL(l_batch_grp_rec.autopack_flag, 'Y') <> 'N' THEN
2376: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PACK');
2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2378: wsh_util_core.add_message(x_return_status);
2379: IF l_debug_on THEN
2380: WSH_DEBUG_SV.pop(l_module_name);
2381: END IF;

Line 2378: wsh_util_core.add_message(x_return_status);

2374:
2375: IF NVL(l_batch_grp_rec.autopack_flag, 'Y') <> 'N' THEN
2376: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PACK');
2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2378: wsh_util_core.add_message(x_return_status);
2379: IF l_debug_on THEN
2380: WSH_DEBUG_SV.pop(l_module_name);
2381: END IF;
2382: return;

Line 2388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2384:
2385: ELSIF l_batch_grp_rec.Append_Flag <> 'N' THEN
2386: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'APPEND_FLAG');
2388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2389: wsh_util_core.add_message(x_return_status);
2390: IF l_debug_on THEN
2391: WSH_DEBUG_SV.pop(l_module_name);
2392: END IF;

Line 2389: wsh_util_core.add_message(x_return_status);

2385: ELSIF l_batch_grp_rec.Append_Flag <> 'N' THEN
2386: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2387: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'APPEND_FLAG');
2388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2389: wsh_util_core.add_message(x_return_status);
2390: IF l_debug_on THEN
2391: WSH_DEBUG_SV.pop(l_module_name);
2392: END IF;
2393: return;

Line 2406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2402: close c_location_id;
2403:
2404: IF l_ship_from_loc_id <> l_batch_grp_rec.Ship_From_Location_Id THEN
2405: FND_MESSAGE.SET_NAME('WSH','WSH_ORG_SHIPFROM_NOT_COMP');
2406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2407: wsh_util_core.add_message(x_return_status);
2408: IF l_debug_on THEN
2409: WSH_DEBUG_SV.pop(l_module_name);
2410: END IF;

Line 2407: wsh_util_core.add_message(x_return_status);

2403:
2404: IF l_ship_from_loc_id <> l_batch_grp_rec.Ship_From_Location_Id THEN
2405: FND_MESSAGE.SET_NAME('WSH','WSH_ORG_SHIPFROM_NOT_COMP');
2406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2407: wsh_util_core.add_message(x_return_status);
2408: IF l_debug_on THEN
2409: WSH_DEBUG_SV.pop(l_module_name);
2410: END IF;
2411: return;

Line 2436: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2432: --
2433: IF l_batch_grp_rec.Organization_Id IS NULL THEN --{
2434: -- Fatal error if no warehouse specified
2435: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NO_WAREHOUSE');
2436: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2437: wsh_util_core.add_message(x_return_status);
2438: IF l_debug_on THEN
2439: WSH_DEBUG_SV.pop(l_module_name);
2440: END IF;

Line 2437: wsh_util_core.add_message(x_return_status);

2433: IF l_batch_grp_rec.Organization_Id IS NULL THEN --{
2434: -- Fatal error if no warehouse specified
2435: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NO_WAREHOUSE');
2436: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2437: wsh_util_core.add_message(x_return_status);
2438: IF l_debug_on THEN
2439: WSH_DEBUG_SV.pop(l_module_name);
2440: END IF;
2441: RETURN;

Line 2445: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2441: RETURN;
2442: ELSE --}{
2443: -- Warning if warehouse specified and others null
2444: FND_MESSAGE.SET_NAME('WSH', 'WSH_PR_CRITICAL_NULL');
2445: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2446: wsh_util_core.add_message(x_return_status);
2447: END IF; --}
2448: --
2449: END IF; --}

Line 2446: wsh_util_core.add_message(x_return_status);

2442: ELSE --}{
2443: -- Warning if warehouse specified and others null
2444: FND_MESSAGE.SET_NAME('WSH', 'WSH_PR_CRITICAL_NULL');
2445: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2446: wsh_util_core.add_message(x_return_status);
2447: END IF; --}
2448: --
2449: END IF; --}
2450:

Line 2482: wsh_util_core.api_post_call(

2478: (p_criterion_id => l_batch_in_rec.crossdock_criteria_id,
2479: p_criterion_name => l_batch_in_rec.crossdock_criteria_name,
2480: x_return_status => l_return_status);
2481:
2482: wsh_util_core.api_post_call(
2483: p_return_status => l_return_status,
2484: x_num_warnings => l_number_of_warnings,
2485: x_num_errors => l_number_of_errors,
2486: p_msg_data => l_msg_data

Line 2515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2511: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY
2512: )
2513: ) THEN
2514: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2516: wsh_util_core.add_message(x_return_status);
2517: IF l_debug_on THEN
2518: WSH_DEBUG_SV.pop(l_module_name);
2519: END IF;

Line 2516: wsh_util_core.add_message(x_return_status);

2512: )
2513: ) THEN
2514: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2515: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2516: wsh_util_core.add_message(x_return_status);
2517: IF l_debug_on THEN
2518: WSH_DEBUG_SV.pop(l_module_name);
2519: END IF;
2520: RETURN;

Line 2528: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

2524: -- call WMS API to validate cross dock criteria
2525: WMS_CROSSDOCK_GRP.validate_planxdock_crt_id
2526: (p_criterion_id => l_batch_grp_rec.crossdock_criteria_id,
2527: x_return_status => l_return_status);
2528: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');
2530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2531: wsh_util_core.add_message(x_return_status);
2532: IF l_debug_on THEN

Line 2530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2526: (p_criterion_id => l_batch_grp_rec.crossdock_criteria_id,
2527: x_return_status => l_return_status);
2528: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');
2530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2531: wsh_util_core.add_message(x_return_status);
2532: IF l_debug_on THEN
2533: WSH_DEBUG_SV.pop(l_module_name);
2534: END IF;

Line 2531: wsh_util_core.add_message(x_return_status);

2527: x_return_status => l_return_status);
2528: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2529: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');
2530: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2531: wsh_util_core.add_message(x_return_status);
2532: IF l_debug_on THEN
2533: WSH_DEBUG_SV.pop(l_module_name);
2534: END IF;
2535: RETURN;

Line 2540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2536: END IF;
2537: ELSIF (l_batch_grp_rec.crossdock_criteria_id IS NOT NULL AND
2538: l_batch_grp_rec.allocation_method = (WSH_PICK_LIST.C_INVENTORY_ONLY)) THEN
2539: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2541: wsh_util_core.add_message(x_return_status);
2542: IF l_debug_on THEN
2543: WSH_DEBUG_SV.pop(l_module_name);
2544: END IF;

Line 2541: wsh_util_core.add_message(x_return_status);

2537: ELSIF (l_batch_grp_rec.crossdock_criteria_id IS NOT NULL AND
2538: l_batch_grp_rec.allocation_method = (WSH_PICK_LIST.C_INVENTORY_ONLY)) THEN
2539: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2540: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2541: wsh_util_core.add_message(x_return_status);
2542: IF l_debug_on THEN
2543: WSH_DEBUG_SV.pop(l_module_name);
2544: END IF;
2545: RETURN;

Line 2552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2548: ELSIF (l_batch_grp_rec.dynamic_replenishment_flag = 'Y' AND
2549: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY)) THEN
2550: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DYNAMIC_REPLENISHMENT_FLAG');
2552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2553: wsh_util_core.add_message(x_return_status);
2554: IF l_debug_on THEN
2555: WSH_DEBUG_SV.pop(l_module_name);
2556: END IF;

Line 2553: wsh_util_core.add_message(x_return_status);

2549: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY)) THEN
2550: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2551: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DYNAMIC_REPLENISHMENT_FLAG');
2552: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2553: wsh_util_core.add_message(x_return_status);
2554: IF l_debug_on THEN
2555: WSH_DEBUG_SV.pop(l_module_name);
2556: END IF;
2557: RETURN;

Line 2566: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2562: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2563: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,
2564: WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
2565: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2566: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2567: wsh_util_core.add_message(x_return_status);
2568: IF l_debug_on THEN
2569: WSH_DEBUG_SV.pop(l_module_name);
2570: END IF;

Line 2567: wsh_util_core.add_message(x_return_status);

2563: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,
2564: WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
2565: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2566: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2567: wsh_util_core.add_message(x_return_status);
2568: IF l_debug_on THEN
2569: WSH_DEBUG_SV.pop(l_module_name);
2570: END IF;
2571: RETURN;

Line 2579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2575: ELSE -- non WMS org
2576: IF l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2577: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
2578: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2580: wsh_util_core.add_message(x_return_status);
2581: IF l_debug_on THEN
2582: WSH_DEBUG_SV.pop(l_module_name);
2583: END IF;

Line 2580: wsh_util_core.add_message(x_return_status);

2576: IF l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2577: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
2578: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2580: wsh_util_core.add_message(x_return_status);
2581: IF l_debug_on THEN
2582: WSH_DEBUG_SV.pop(l_module_name);
2583: END IF;
2584: RETURN;

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

2685: );
2686:
2687: IF l_debug_on THEN
2688: --{
2689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2690: --}
2691: END IF;
2692: --
2693: wsh_util_core.api_post_call(

Line 2693: wsh_util_core.api_post_call(

2689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2690: --}
2691: END IF;
2692: --
2693: wsh_util_core.api_post_call(
2694: p_return_status => l_return_status,
2695: x_num_warnings => l_number_of_warnings,
2696: x_num_errors => l_number_of_errors,
2697: p_msg_data => l_msg_data

Line 2725: wsh_util_core.add_message(x_return_status);

2721: EXCEPTION
2722: WHEN FND_API.G_EXC_ERROR THEN
2723: ROLLBACK TO PICKING_BATCH_GRP;
2724: x_return_status := FND_API.G_RET_STS_ERROR ;
2725: wsh_util_core.add_message(x_return_status);
2726: FND_MSG_PUB.Count_And_Get
2727: (
2728: p_count => x_msg_count,
2729: p_data => x_msg_data,

Line 2746: wsh_util_core.add_message(x_return_status);

2742: ROLLBACK TO PICKING_BATCH_GRP;
2743: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_CONSOL_DEL_PR');
2744: FND_MESSAGE.SET_TOKEN('PARAMETER',l_batch_in_rec.Delivery_id);
2745: x_return_status := FND_API.G_RET_STS_ERROR ;
2746: wsh_util_core.add_message(x_return_status);
2747: FND_MSG_PUB.Count_And_Get
2748: (
2749: p_count => x_msg_count,
2750: p_data => x_msg_data,

Line 2765: wsh_util_core.add_message(x_return_status, l_module_name);

2761:
2762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2763: ROLLBACK TO PICKING_BATCH_GRP;
2764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2765: wsh_util_core.add_message(x_return_status, l_module_name);
2766: FND_MSG_PUB.Count_And_Get
2767: (
2768: p_count => x_msg_count,
2769: p_data => x_msg_data,

Line 2782: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');

2778: --}
2779: END IF;
2780: WHEN OTHERS THEN
2781: ROLLBACK TO PICKING_BATCH_GRP;
2782: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');
2783: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2784: FND_MSG_PUB.Count_And_Get
2785: (
2786: p_count => x_msg_count,

Line 2783: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2779: END IF;
2780: WHEN OTHERS THEN
2781: ROLLBACK TO PICKING_BATCH_GRP;
2782: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');
2783: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2784: FND_MSG_PUB.Count_And_Get
2785: (
2786: p_count => x_msg_count,
2787: p_data => x_msg_data,

Line 2921: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2917: --{
2918: fnd_msg_pub.initialize;
2919: --}
2920: END IF;
2921: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2922: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2923: l_batch_id := p_batch_id;
2924: l_batch_name := p_batch_name;
2925: l_log_level := p_log_level;

Line 2922: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2918: fnd_msg_pub.initialize;
2919: --}
2920: END IF;
2921: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2922: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2923: l_batch_id := p_batch_id;
2924: l_batch_name := p_batch_name;
2925: l_log_level := p_log_level;
2926:

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

2950: x_return_status => l_return_status);
2951:
2952: IF l_debug_on THEN
2953: --{
2954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2955: --}
2956: END IF;
2957: --
2958: wsh_util_core.api_post_call(

Line 2958: wsh_util_core.api_post_call(

2954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2955: --}
2956: END IF;
2957: --
2958: wsh_util_core.api_post_call(
2959: p_return_status => l_return_status,
2960: x_num_warnings => l_number_of_warnings,
2961: x_num_errors => l_number_of_errors,
2962: p_msg_data => l_msg_data

Line 2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2967: --
2968: --
2969: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2970: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');
2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2972: wsh_util_core.add_message(x_return_status);
2973: return;
2974: --}
2975: END IF;

Line 2972: wsh_util_core.add_message(x_return_status);

2968: --
2969: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2970: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');
2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2972: wsh_util_core.add_message(x_return_status);
2973: return;
2974: --}
2975: END IF;
2976:

Line 2984: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2980: IF ( ( p_release_mode IS NULL ) OR ( p_release_mode NOT IN ('CONCURRENT','ONLINE'))) THEN
2981: --{
2982: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
2983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_RELEASE_MODE');
2984: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2985: wsh_util_core.add_message(x_return_status);
2986: return;
2987: --}
2988: END IF;

Line 2985: wsh_util_core.add_message(x_return_status);

2981: --{
2982: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
2983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_RELEASE_MODE');
2984: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2985: wsh_util_core.add_message(x_return_status);
2986: return;
2987: --}
2988: END IF;
2989: -- End of Validating the Release Mode

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

2996: x_return_status => l_return_status);
2997:
2998: IF l_debug_on THEN
2999: --{
3000: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3001: --}
3002: END IF;
3003: --
3004: wsh_util_core.api_post_call(

Line 3004: wsh_util_core.api_post_call(

3000: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3001: --}
3002: END IF;
3003: --
3004: wsh_util_core.api_post_call(
3005: p_return_status => l_return_status,
3006: x_num_warnings => l_number_of_warnings,
3007: x_num_errors => l_number_of_errors,
3008: p_msg_data => l_msg_data

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

3030: p_log_level => l_log_level,
3031: p_num_workers => l_num_workers); -- bug # 7505524
3032: IF l_debug_on THEN
3033: --{
3034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3035: --}
3036: END IF;
3037: --
3038: wsh_util_core.api_post_call(

Line 3038: wsh_util_core.api_post_call(

3034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3035: --}
3036: END IF;
3037: --
3038: wsh_util_core.api_post_call(
3039: p_return_status => l_return_status,
3040: x_num_warnings => l_number_of_warnings,
3041: x_num_errors => l_number_of_errors,
3042: p_msg_data => l_msg_data

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

3066: p_pick_skip => l_pick_skip);
3067:
3068: IF l_debug_on THEN
3069: --{
3070: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3071: --}
3072: END IF;
3073: --
3074: wsh_util_core.api_post_call(

Line 3074: wsh_util_core.api_post_call(

3070: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3071: --}
3072: END IF;
3073: --
3074: wsh_util_core.api_post_call(
3075: p_return_status => l_return_status,
3076: x_num_warnings => l_number_of_warnings,
3077: x_num_errors => l_number_of_errors,
3078: p_msg_data => l_msg_data

Line 3088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3084: IF (nvl(l_pick_phase,'START') ='MOVE_ORDER_LINES') then
3085: --{
3086: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PARTIAL');
3087: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
3088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3089: wsh_util_core.add_message(x_return_status,l_module_name);
3090: ELSE
3091: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
3092: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3089: wsh_util_core.add_message(x_return_status,l_module_name);

3085: --{
3086: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PARTIAL');
3087: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
3088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3089: wsh_util_core.add_message(x_return_status,l_module_name);
3090: ELSE
3091: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
3092: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3093: wsh_util_core.add_message(x_return_status,l_module_name);

Line 3092: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3089: wsh_util_core.add_message(x_return_status,l_module_name);
3090: ELSE
3091: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
3092: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3093: wsh_util_core.add_message(x_return_status,l_module_name);
3094: --}
3095: END IF;
3096: ELSIF (nvl(l_pick_result, 'F') = 'W') then

Line 3093: wsh_util_core.add_message(x_return_status,l_module_name);

3089: wsh_util_core.add_message(x_return_status,l_module_name);
3090: ELSE
3091: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
3092: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3093: wsh_util_core.add_message(x_return_status,l_module_name);
3094: --}
3095: END IF;
3096: ELSIF (nvl(l_pick_result, 'F') = 'W') then
3097: IF (nvl(l_pick_phase,'START') ='MOVE_ORDER_LINES') then

Line 3102: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3098: --{
3099: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PART_WARN');
3100: -- bug# 8340984 : Changed error to warning here (same behavior when performed
3101: -- pick release through release sales orders form)
3102: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3103: wsh_util_core.add_message(x_return_status,l_module_name);
3104: ELSE
3105: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
3106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3103: wsh_util_core.add_message(x_return_status,l_module_name);

3099: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PART_WARN');
3100: -- bug# 8340984 : Changed error to warning here (same behavior when performed
3101: -- pick release through release sales orders form)
3102: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3103: wsh_util_core.add_message(x_return_status,l_module_name);
3104: ELSE
3105: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
3106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3107: wsh_util_core.add_message(x_return_status,l_module_name);

Line 3106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3102: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3103: wsh_util_core.add_message(x_return_status,l_module_name);
3104: ELSE
3105: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
3106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3107: wsh_util_core.add_message(x_return_status,l_module_name);
3108: --}
3109: END IF;
3110: ELSE

Line 3107: wsh_util_core.add_message(x_return_status,l_module_name);

3103: wsh_util_core.add_message(x_return_status,l_module_name);
3104: ELSE
3105: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
3106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3107: wsh_util_core.add_message(x_return_status,l_module_name);
3108: --}
3109: END IF;
3110: ELSE
3111: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_SUCCESS');

Line 3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3108: --}
3109: END IF;
3110: ELSE
3111: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_SUCCESS');
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3113: wsh_util_core.add_message(x_return_status,l_module_name);
3114: --}
3115: END IF;
3116: --}

Line 3113: wsh_util_core.add_message(x_return_status,l_module_name);

3109: END IF;
3110: ELSE
3111: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_SUCCESS');
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3113: wsh_util_core.add_message(x_return_status,l_module_name);
3114: --}
3115: END IF;
3116: --}
3117: END IF;

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

3118:
3119:
3120: IF l_debug_on THEN
3121: --{
3122: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3123: --}
3124: END IF;
3125: --
3126: wsh_util_core.api_post_call(

Line 3126: wsh_util_core.api_post_call(

3122: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
3123: --}
3124: END IF;
3125: --
3126: wsh_util_core.api_post_call(
3127: p_return_status => l_return_status,
3128: x_num_warnings => l_number_of_warnings,
3129: x_num_errors => l_number_of_errors,
3130: p_msg_data => l_msg_data

Line 3156: wsh_util_core.add_message(x_return_status);

3152: EXCEPTION
3153: WHEN FND_API.G_EXC_ERROR THEN
3154: ROLLBACK TO PICKING_BATCH_GRP;
3155: x_return_status := FND_API.G_RET_STS_ERROR ;
3156: wsh_util_core.add_message(x_return_status);
3157: FND_MSG_PUB.Count_And_Get
3158: (
3159: p_count => x_msg_count,
3160: p_data => x_msg_data,

Line 3175: wsh_util_core.add_message(x_return_status, l_module_name);

3171:
3172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3173: ROLLBACK TO PICKING_BATCH_GRP;
3174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3175: wsh_util_core.add_message(x_return_status, l_module_name);
3176: FND_MSG_PUB.Count_And_Get
3177: (
3178: p_count => x_msg_count,
3179: p_data => x_msg_data,

Line 3192: wsh_util_core.default_handler('WSH_PICKING_BATCHES_GRP.RELEASE_BATCH');

3188: --}
3189: END IF;
3190: WHEN OTHERS THEN
3191: ROLLBACK TO PICKING_BATCH_GRP;
3192: wsh_util_core.default_handler('WSH_PICKING_BATCHES_GRP.RELEASE_BATCH');
3193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3194: FND_MSG_PUB.Count_And_Get
3195: (
3196: p_count => x_msg_count,

Line 3193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3189: END IF;
3190: WHEN OTHERS THEN
3191: ROLLBACK TO PICKING_BATCH_GRP;
3192: wsh_util_core.default_handler('WSH_PICKING_BATCHES_GRP.RELEASE_BATCH');
3193: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3194: FND_MSG_PUB.Count_And_Get
3195: (
3196: p_count => x_msg_count,
3197: p_data => x_msg_data,

Line 3268: l_dd_tbl WSH_UTIL_CORE.id_tab_type;

3264: record_locked EXCEPTION;
3265: PRAGMA EXCEPTION_INIT(record_locked, -54);
3266:
3267: l_batch_rec WSH_PICKING_BATCHES_PUB.Batch_Info_Rec;
3268: l_dd_tbl WSH_UTIL_CORE.id_tab_type;
3269: l_batch_id NUMBER;
3270: l_request_id NUMBER;
3271: l_log_level NUMBER := 0;
3272: l_tot_fetch NUMBER;

Line 3277: l_dd_upd_tbl WSH_UTIL_CORE.id_tab_type;

3273: l_pre_fetch NUMBER;
3274: l_cur_fetch NUMBER;
3275: l_batch_size NUMBER :=5;
3276: l_tot_upd_dds NUMBER := 0;
3277: l_dd_upd_tbl WSH_UTIL_CORE.id_tab_type;
3278: l_return_status VARCHAR2(1);
3279: l_temp_rec WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
3280: l_num_errors NUMBER;
3281: --

Line 3322: IF NVL(l_batch_id,0) = 0 OR l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

3318: wsh_debug_sv.LOG(l_module_name, 'WSH_PICKING_BATCHES_GRP.Create_Batch return status', l_return_status);
3319: wsh_debug_sv.LOG(l_module_name, 'l_batch_id', l_batch_id);
3320: END IF;
3321: --
3322: IF NVL(l_batch_id,0) = 0 OR l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3323: --{
3324: IF NVL(l_batch_id,0) = 0 AND l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3325: --{
3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3324: IF NVL(l_batch_id,0) = 0 AND l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

3320: END IF;
3321: --
3322: IF NVL(l_batch_id,0) = 0 OR l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3323: --{
3324: IF NVL(l_batch_id,0) = 0 AND l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3325: --{
3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3327: ELSE
3328: x_return_status := l_return_status;

Line 3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3322: IF NVL(l_batch_id,0) = 0 OR l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3323: --{
3324: IF NVL(l_batch_id,0) = 0 AND l_return_status IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3325: --{
3326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3327: ELSE
3328: x_return_status := l_return_status;
3329: --}
3330: END IF;

Line 3361: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);

3357: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN
3358: rollback to lock_delivery_detail_loop;
3359: FND_MESSAGE.SET_NAME('WSH', 'WSH_DLVB_LOCK_FAILED');
3360: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_dd_tbl(i));
3361: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
3362: l_num_errors := l_num_errors + 1;
3363: --
3364: IF l_debug_on THEN
3365: WSH_DEBUG_SV.log(l_module_name,'Unable to obtain lock on the Delivery Detail Id',l_dd_tbl(i));

Line 3400: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3396: --{
3397: IF l_debug_on THEN
3398: wsh_debug_sv.LOG(l_module_name, 'There are no eligible delivery lines for the pick release',l_tot_fetch);
3399: END IF;
3400: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3401: RETURN;
3402: --}
3403: END IF;
3404: IF l_tot_upd_dds < l_tot_fetch THEN

Line 3409: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3405: --{
3406: IF l_debug_on THEN
3407: wsh_debug_sv.LOG(l_module_name, 'Number of delivery detail lines failed while locking',l_tot_fetch-l_tot_upd_dds);
3408: END IF;
3409: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3410: --}
3411: END IF;
3412:
3413:

Line 3434: IF ((l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING))

3430: IF l_debug_on THEN
3431: wsh_debug_sv.LOG(l_module_name, 'WSH_PICKING_BATCHES_GRP.release_batch return status:', l_return_status);
3432: wsh_debug_sv.LOG(l_module_name, 'pick release concurrent req.id:',l_request_id);
3433: END IF;
3434: IF ((l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING))
3435: AND ( p_release_mode='ONLINE' OR nvl(l_request_id,0) = 0 )) THEN
3436: --{
3437: ROLLBACK TO update_batch_id_on_dd;
3438: --}

Line 3460: WSH_UTIL_CORE.Default_Handler ('WSH_PICKING_BATCHES_GRP.release_wms_wave');

3456:
3457: EXCEPTION
3458: WHEN Others THEN
3459: ROLLBACK TO create_batch;
3460: WSH_UTIL_CORE.Default_Handler ('WSH_PICKING_BATCHES_GRP.release_wms_wave');
3461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3462: IF c_get_dds_for_wave%ISOPEN THEN
3463: CLOSE c_get_dds_for_wave;
3464: END IF;

Line 3461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3457: EXCEPTION
3458: WHEN Others THEN
3459: ROLLBACK TO create_batch;
3460: WSH_UTIL_CORE.Default_Handler ('WSH_PICKING_BATCHES_GRP.release_wms_wave');
3461: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3462: IF c_get_dds_for_wave%ISOPEN THEN
3463: CLOSE c_get_dds_for_wave;
3464: END IF;
3465: --