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 275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

271: --{
272: fnd_msg_pub.initialize;
273: --}
274: END IF;
275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
276: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
277:
278: l_batch_in_rec := p_batch_rec;
279: l_rule_id := p_rule_id;

Line 276: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

272: fnd_msg_pub.initialize;
273: --}
274: END IF;
275: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
276: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
277:
278: l_batch_in_rec := p_batch_rec;
279: l_rule_id := p_rule_id;
280: l_rule_name := p_rule_name;

Line 372: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

368: END IF;
369: --
370: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICKING_RULE');
372: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
373: wsh_util_core.add_message(x_return_status);
374: CLOSE Get_Picking_Rule_Info;
375: IF l_debug_on THEN
376: --{

Line 373: wsh_util_core.add_message(x_return_status);

369: --
370: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','PICKING_RULE');
372: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
373: wsh_util_core.add_message(x_return_status);
374: CLOSE Get_Picking_Rule_Info;
375: IF l_debug_on THEN
376: --{
377: WSH_DEBUG_SV.pop(l_module_name);

Line 409: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

405: IF ( l_batch_in_rec.Backorders_Only_Flag NOT IN ('I','E','O','M') ) THEN
406: --{
407: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BACKORDERS_ONLY_FLAG ');
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
410: wsh_util_core.add_message(x_return_status);
411: return;
412: --}
413: END IF;

Line 410: wsh_util_core.add_message(x_return_status);

406: --{
407: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','BACKORDERS_ONLY_FLAG ');
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
410: wsh_util_core.add_message(x_return_status);
411: return;
412: --}
413: END IF;
414: l_batch_grp_rec.Backorders_Only_Flag := l_batch_in_rec.Backorders_Only_Flag ;

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

450: x_return_status => l_return_status);
451:
452: IF l_debug_on THEN
453: --{
454: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
455: --}
456: END IF;
457: --
458: wsh_util_core.api_post_call(

Line 458: wsh_util_core.api_post_call(

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

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

474: p_organization_id => l_batch_grp_rec.Organization_Id);
475:
476: IF l_debug_on THEN
477: --{
478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
479: --}
480: END IF;
481: --
482: wsh_util_core.api_post_call(

Line 482: wsh_util_core.api_post_call(

478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
479: --}
480: END IF;
481: --
482: wsh_util_core.api_post_call(
483: p_return_status => l_return_status,
484: x_num_warnings => l_number_of_warnings,
485: x_num_errors => l_number_of_errors,
486: p_msg_data => l_msg_data

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

524: x_return_status => l_return_status);
525:
526: IF l_debug_on THEN
527: --{
528: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
529: --}
530: END IF;
531: --
532: wsh_util_core.api_post_call(

Line 532: wsh_util_core.api_post_call(

528: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
529: --}
530: END IF;
531: --
532: wsh_util_core.api_post_call(
533: p_return_status => l_return_status,
534: x_num_warnings => l_number_of_warnings,
535: x_num_errors => l_number_of_errors,
536: p_msg_data => l_msg_data

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

572: x_return_status => l_return_status);
573:
574: IF l_debug_on THEN
575: --{
576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
577: --}
578: END IF;
579: --
580: wsh_util_core.api_post_call(

Line 580: wsh_util_core.api_post_call(

576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
577: --}
578: END IF;
579: --
580: wsh_util_core.api_post_call(
581: p_return_status => l_return_status,
582: x_num_warnings => l_number_of_warnings,
583: x_num_errors => l_number_of_errors,
584: p_msg_data => l_msg_data

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

620: x_return_status => l_return_status);
621:
622: IF l_debug_on THEN
623: --{
624: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
625: --}
626: END IF;
627: --
628: wsh_util_core.api_post_call(

Line 628: wsh_util_core.api_post_call(

624: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
625: --}
626: END IF;
627: --
628: wsh_util_core.api_post_call(
629: p_return_status => l_return_status,
630: x_num_warnings => l_number_of_warnings,
631: x_num_errors => l_number_of_errors,
632: p_msg_data => l_msg_data

Line 666: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

662: IF ( Get_Order_Type_id%NOTFOUND ) THEN
663: --{
664: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_TYPE');
666: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
667: wsh_util_core.add_message(x_return_status);
668: CLOSE Get_Order_Type_id;
669: return;
670: --}

Line 667: wsh_util_core.add_message(x_return_status);

663: --{
664: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_TYPE');
666: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
667: wsh_util_core.add_message(x_return_status);
668: CLOSE Get_Order_Type_id;
669: return;
670: --}
671: END IF;

Line 702: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

698: IF ( l_batch_in_rec.order_number IS NOT NULL AND l_batch_grp_rec.order_type_id IS NULL ) THEN
699: --{
700: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER AND ORDER_TYPE_ID combination');
702: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
703: wsh_util_core.add_message(x_return_status);
704: return;
705: --}
706: END IF;

Line 703: wsh_util_core.add_message(x_return_status);

699: --{
700: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER AND ORDER_TYPE_ID combination');
702: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
703: wsh_util_core.add_message(x_return_status);
704: return;
705: --}
706: END IF;
707: 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 715: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

711: IF ( Get_Order_Header_id%NOTFOUND ) THEN
712: --{
713: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
714: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER OR ORDER_HEADER_ID');
715: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
716: wsh_util_core.add_message(x_return_status);
717: CLOSE Get_Order_Header_id;
718: return;
719: --}

Line 716: wsh_util_core.add_message(x_return_status);

712: --{
713: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
714: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ORDER_NUMBER OR ORDER_HEADER_ID');
715: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
716: wsh_util_core.add_message(x_return_status);
717: CLOSE Get_Order_Header_id;
718: return;
719: --}
720: END IF;

Line 750: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

746: IF ( l_batch_in_rec.ship_set_number IS NOT NULL AND l_batch_grp_rec.order_header_id IS NULL ) THEN
747: --{
748: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
749: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER AND ORDER_HEADER_ID combination');
750: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
751: wsh_util_core.add_message(x_return_status);
752: return;
753: --}
754: END IF;

Line 751: wsh_util_core.add_message(x_return_status);

747: --{
748: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
749: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER AND ORDER_HEADER_ID combination');
750: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
751: wsh_util_core.add_message(x_return_status);
752: return;
753: --}
754: END IF;
755: 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 763: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

759: IF ( Get_Ship_Set_Id%NOTFOUND ) THEN
760: --{
761: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER OR SHIP_SET_ID');
763: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
764: wsh_util_core.add_message(x_return_status);
765: CLOSE Get_Ship_Set_Id;
766: return;
767: --}

Line 764: wsh_util_core.add_message(x_return_status);

760: --{
761: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_NUMBER OR SHIP_SET_ID');
763: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
764: wsh_util_core.add_message(x_return_status);
765: CLOSE Get_Ship_Set_Id;
766: return;
767: --}
768: END IF;

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

805: p_isWshLocation => TRUE);
806:
807: IF l_debug_on THEN
808: --{
809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
810: --}
811: END IF;
812: --
813: wsh_util_core.api_post_call(

Line 813: wsh_util_core.api_post_call(

809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
810: --}
811: END IF;
812: --
813: wsh_util_core.api_post_call(
814: p_return_status => l_return_status,
815: x_num_warnings => l_number_of_warnings,
816: x_num_errors => l_number_of_errors,
817: p_msg_data => l_msg_data

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

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

Line 865: wsh_util_core.api_post_call(

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

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

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

Line 918: wsh_util_core.api_post_call(

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

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

959: x_return_status => l_return_status);
960:
961: IF l_debug_on THEN
962: --{
963: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
964: --}
965: END IF;
966: --
967: wsh_util_core.api_post_call(

Line 967: wsh_util_core.api_post_call(

963: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
964: --}
965: END IF;
966: --
967: wsh_util_core.api_post_call(
968: p_return_status => l_return_status,
969: x_num_warnings => l_number_of_warnings,
970: x_num_errors => l_number_of_errors,
971: p_msg_data => l_msg_data

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

1023: x_return_status => l_return_status);
1024:
1025: IF l_debug_on THEN
1026: --{
1027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1028: --}
1029: END IF;
1030: --
1031: wsh_util_core.api_post_call(

Line 1031: wsh_util_core.api_post_call(

1027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1028: --}
1029: END IF;
1030: --
1031: wsh_util_core.api_post_call(
1032: p_return_status => l_return_status,
1033: x_num_warnings => l_number_of_warnings,
1034: x_num_errors => l_number_of_errors,
1035: p_msg_data => l_msg_data

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

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

Line 1083: wsh_util_core.api_post_call(

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

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

1124: x_return_status => l_return_status);
1125:
1126: IF l_debug_on THEN
1127: --{
1128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1129: --}
1130: END IF;
1131: --
1132: wsh_util_core.api_post_call(

Line 1132: wsh_util_core.api_post_call(

1128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1129: --}
1130: END IF;
1131: --
1132: wsh_util_core.api_post_call(
1133: p_return_status => l_return_status,
1134: x_num_warnings => l_number_of_warnings,
1135: x_num_errors => l_number_of_errors,
1136: p_msg_data => l_msg_data

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

1210: x_return_status => l_return_status);
1211:
1212: IF l_debug_on THEN
1213: --{
1214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1215: --}
1216: END IF;
1217: --
1218: wsh_util_core.api_post_call(

Line 1218: wsh_util_core.api_post_call(

1214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1215: --}
1216: END IF;
1217: --
1218: wsh_util_core.api_post_call(
1219: p_return_status => l_return_status,
1220: x_num_warnings => l_number_of_warnings,
1221: x_num_errors => l_number_of_errors,
1222: p_msg_data => l_msg_data

Line 1246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1242: --{
1243: IF l_batch_in_rec.actual_departure_date IS NOT NULL THEN
1244: --
1245: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACTUAL_DEP_DATE');
1246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1247: wsh_util_core.add_message(x_return_status);
1248: --
1249: IF l_debug_on THEN
1250: wsh_debug_sv.logmsg(l_module_name, 'Error - WSH_NO_ACTUAL_DEP_DATE');

Line 1247: wsh_util_core.add_message(x_return_status);

1243: IF l_batch_in_rec.actual_departure_date IS NOT NULL THEN
1244: --
1245: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACTUAL_DEP_DATE');
1246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1247: wsh_util_core.add_message(x_return_status);
1248: --
1249: IF l_debug_on THEN
1250: wsh_debug_sv.logmsg(l_module_name, 'Error - WSH_NO_ACTUAL_DEP_DATE');
1251: wsh_debug_sv.pop(l_module_name);

Line 1267: wsh_util_core.api_post_call(

1263: p_ship_confirm_rule_id => l_batch_grp_rec.ship_confirm_rule_id,
1264: p_actual_departure_date => l_batch_in_rec.actual_departure_date,
1265: x_return_status => l_return_status);
1266: --
1267: wsh_util_core.api_post_call(
1268: p_return_status => l_return_status,
1269: x_num_warnings => l_number_of_warnings,
1270: x_num_errors => l_number_of_errors,
1271: p_msg_data => l_msg_data

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

1309: x_return_status => l_return_status);
1310:
1311: IF l_debug_on THEN
1312: --{
1313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1314: --}
1315: END IF;
1316: --
1317: wsh_util_core.api_post_call(

Line 1317: wsh_util_core.api_post_call(

1313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1314: --}
1315: END IF;
1316: --
1317: wsh_util_core.api_post_call(
1318: p_return_status => l_return_status,
1319: x_num_warnings => l_number_of_warnings,
1320: x_num_errors => l_number_of_errors,
1321: p_msg_data => l_msg_data

Line 1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1342: IF ( Check_Item_id%NOTFOUND ) THEN
1343: --{
1344: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INVENTORY_ITEM_ID');
1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1347: wsh_util_core.add_message(x_return_status);
1348: CLOSE Check_Item_id;
1349: return;
1350: --}

Line 1347: wsh_util_core.add_message(x_return_status);

1343: --{
1344: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INVENTORY_ITEM_ID');
1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1347: wsh_util_core.add_message(x_return_status);
1348: CLOSE Check_Item_id;
1349: return;
1350: --}
1351: END IF;

Line 1379: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1375: IF ( Check_Subinventory%NOTFOUND ) THEN
1376: --{
1377: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1378: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_SUBINVENTORY');
1379: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1380: wsh_util_core.add_message(x_return_status);
1381: CLOSE Check_Subinventory;
1382: return;
1383: --}

Line 1380: wsh_util_core.add_message(x_return_status);

1376: --{
1377: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1378: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_SUBINVENTORY');
1379: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1380: wsh_util_core.add_message(x_return_status);
1381: CLOSE Check_Subinventory;
1382: return;
1383: --}
1384: END IF;

Line 1406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1402: IF ( Check_Locator_Id%NOTFOUND ) THEN
1403: --{
1404: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1405: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_LOCATOR_ID');
1406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1407: wsh_util_core.add_message(x_return_status);
1408: CLOSE Check_Locator_Id;
1409: return;
1410: --}

Line 1407: wsh_util_core.add_message(x_return_status);

1403: --{
1404: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1405: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DEFAULT_STAGE_LOCATOR_ID');
1406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1407: wsh_util_core.add_message(x_return_status);
1408: CLOSE Check_Locator_Id;
1409: return;
1410: --}
1411: 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','PICK_FROM_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','PICK_FROM_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 1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 1462: wsh_util_core.add_message(x_return_status);

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

Line 1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1489: IF ( Check_Delivery_Detail_Id%NOTFOUND ) THEN
1490: --{
1491: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DELIVERY_DETAIL_ID');
1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1494: wsh_util_core.add_message(x_return_status);
1495: CLOSE Check_Delivery_Detail_Id;
1496: return;
1497: --}

Line 1494: wsh_util_core.add_message(x_return_status);

1490: --{
1491: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','DELIVERY_DETAIL_ID');
1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1494: wsh_util_core.add_message(x_return_status);
1495: CLOSE Check_Delivery_Detail_Id;
1496: return;
1497: --}
1498: END IF;

Line 1521: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1517: IF ( Check_Category_Set_Id%NOTFOUND ) THEN
1518: --{
1519: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1520: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_SET_ID');
1521: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1522: wsh_util_core.add_message(x_return_status);
1523: CLOSE Check_Category_Set_Id;
1524: return;
1525: --}

Line 1522: wsh_util_core.add_message(x_return_status);

1518: --{
1519: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1520: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_SET_ID');
1521: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1522: wsh_util_core.add_message(x_return_status);
1523: CLOSE Check_Category_Set_Id;
1524: return;
1525: --}
1526: END IF;

Line 1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1547: IF ( Check_Category_Id%NOTFOUND ) THEN
1548: --{
1549: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_ID');
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1552: wsh_util_core.add_message(x_return_status);
1553: CLOSE Check_Category_Id;
1554: return;
1555: --}

Line 1552: wsh_util_core.add_message(x_return_status);

1548: --{
1549: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1550: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','CATEGORY_ID');
1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1552: wsh_util_core.add_message(x_return_status);
1553: CLOSE Check_Category_Id;
1554: return;
1555: --}
1556: END IF;

Line 1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1576: IF ( l_batch_in_rec.Ship_Set_Smc_Flag NOT IN ('I','E','A') ) THEN
1577: --{
1578: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1579: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_SMC_FLAG');
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: wsh_util_core.add_message(x_return_status);
1582: return;
1583: --}
1584: END IF;

Line 1581: wsh_util_core.add_message(x_return_status);

1577: --{
1578: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1579: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SHIP_SET_SMC_FLAG');
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1581: wsh_util_core.add_message(x_return_status);
1582: return;
1583: --}
1584: END IF;
1585: l_batch_grp_rec.Ship_Set_Smc_Flag :=l_batch_in_rec.Ship_Set_Smc_Flag;

Line 1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1601: IF ( l_batch_in_rec.Auto_Pick_Confirm_Flag NOT IN ('Y','N') ) THEN
1602: --{
1603: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1604: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTO_PICK_CONFIRM_FLAG');
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1606: wsh_util_core.add_message(x_return_status);
1607: return;
1608: --}
1609: END IF;

Line 1606: wsh_util_core.add_message(x_return_status);

1602: --{
1603: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1604: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTO_PICK_CONFIRM_FLAG');
1605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1606: wsh_util_core.add_message(x_return_status);
1607: return;
1608: --}
1609: END IF;
1610: l_batch_grp_rec.Auto_Pick_Confirm_Flag := l_batch_in_rec.Auto_Pick_Confirm_Flag;

Line 1629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1625: IF ( l_batch_in_rec.Existing_Rsvs_Only_Flag NOT IN ('N','Y')) THEN
1626: --{
1627: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','EXISTING_RSVS_ONLY_FLAG');
1629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1630: wsh_util_core.add_message(x_return_status);
1631: return;
1632: --}
1633: END IF;

Line 1630: wsh_util_core.add_message(x_return_status);

1626: --{
1627: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','EXISTING_RSVS_ONLY_FLAG');
1629: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1630: wsh_util_core.add_message(x_return_status);
1631: return;
1632: --}
1633: END IF;
1634: l_batch_grp_rec.Existing_Rsvs_Only_Flag := l_batch_in_rec.Existing_Rsvs_Only_Flag;

Line 1654: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1650: IF ( l_batch_in_rec.Include_Planned_Lines NOT IN ('Y','N') ) THEN
1651: --{
1652: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1653: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INCLUDE_PLANNED_LINES');
1654: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1655: wsh_util_core.add_message(x_return_status);
1656: return;
1657: --}
1658: END IF;

Line 1655: wsh_util_core.add_message(x_return_status);

1651: --{
1652: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1653: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','INCLUDE_PLANNED_LINES');
1654: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1655: wsh_util_core.add_message(x_return_status);
1656: return;
1657: --}
1658: END IF;
1659: l_batch_grp_rec.Include_Planned_Lines := l_batch_in_rec.Include_Planned_Lines;

Line 1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1675: IF ( l_batch_in_rec.Autodetail_Pr_Flag NOT IN ('Y','N') ) THEN
1676: --{
1677: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1678: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTODETAIL_PR_FLAG');
1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1680: wsh_util_core.add_message(x_return_status);
1681: return;
1682: --}
1683: END IF;

Line 1680: wsh_util_core.add_message(x_return_status);

1676: --{
1677: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1678: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTODETAIL_PR_FLAG');
1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1680: wsh_util_core.add_message(x_return_status);
1681: return;
1682: --}
1683: END IF;
1684: l_batch_grp_rec.Autodetail_Pr_Flag :=l_batch_in_rec.Autodetail_Pr_Flag;

Line 1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1701: IF ( l_batch_in_rec.Autopack_Flag NOT IN ('Y','N') ) THEN
1702: --{
1703: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_FLAG');
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1706: wsh_util_core.add_message(x_return_status);
1707: return;
1708: --}
1709: END IF;

Line 1706: wsh_util_core.add_message(x_return_status);

1702: --{
1703: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1704: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_FLAG');
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1706: wsh_util_core.add_message(x_return_status);
1707: return;
1708: --}
1709: END IF;
1710: l_batch_grp_rec.Autopack_Flag :=l_batch_in_rec.Autopack_Flag;

Line 1732: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1728: IF ( l_batch_in_rec.Autopack_Level NOT IN (0,1,2) ) THEN
1729: --{
1730: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_LEVEL');
1732: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1733: wsh_util_core.add_message(x_return_status);
1734: return;
1735: --}
1736: END IF;

Line 1733: wsh_util_core.add_message(x_return_status);

1729: --{
1730: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','AUTOPACK_LEVEL');
1732: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1733: wsh_util_core.add_message(x_return_status);
1734: return;
1735: --}
1736: END IF;
1737: l_batch_grp_rec.Autopack_Level := l_batch_in_rec.Autopack_Level;

Line 1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1755: IF ( l_batch_in_rec.Task_Planning_Flag NOT IN ('Y','N') ) THEN
1756: --{
1757: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','TASK_PLANNING_FLAG');
1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1760: wsh_util_core.add_message(x_return_status);
1761: return;
1762: --}
1763: END IF;

Line 1760: wsh_util_core.add_message(x_return_status);

1756: --{
1757: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1758: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','TASK_PLANNING_FLAG');
1759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1760: wsh_util_core.add_message(x_return_status);
1761: return;
1762: --}
1763: END IF;
1764: l_batch_grp_rec.Task_Planning_Flag :=l_batch_in_rec.Task_Planning_Flag;

Line 1791: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 1792: wsh_util_core.add_message(x_return_status);

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

Line 1823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1819: IF ( l_batch_in_rec.Non_Picking_flag NOT IN ('Y','N') ) THEN
1820: --{
1821: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1822: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','NON_PICKING_FLAG');
1823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1824: wsh_util_core.add_message(x_return_status);
1825: return;
1826: --}
1827: END IF;

Line 1824: wsh_util_core.add_message(x_return_status);

1820: --{
1821: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
1822: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','NON_PICKING_FLAG');
1823: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1824: wsh_util_core.add_message(x_return_status);
1825: return;
1826: --}
1827: END IF;
1828: l_batch_grp_rec.Non_Picking_flag :=l_batch_in_rec.Non_Picking_flag;

Line 2178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2174: l_batch_grp_rec.autocreate_Delivery_flag NOT IN ('Y', 'N')) THEN
2175: --{
2176: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'AUTOCREATE_DELIVERY_FLAG');
2178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2179: wsh_util_core.add_message(x_return_status);
2180: --
2181: IF l_debug_on THEN
2182: WSH_DEBUG_SV.pop(l_module_name);

Line 2179: wsh_util_core.add_message(x_return_status);

2175: --{
2176: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'AUTOCREATE_DELIVERY_FLAG');
2178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2179: wsh_util_core.add_message(x_return_status);
2180: --
2181: IF l_debug_on THEN
2182: WSH_DEBUG_SV.pop(l_module_name);
2183: END IF;

Line 2197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2193: IF (l_batch_grp_rec.ac_delivery_criteria IS NOT NULL AND
2194: l_batch_grp_rec.autocreate_delivery_flag <> 'Y') THEN
2195: --{
2196: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACDEL_CRITERIA');
2197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2198: wsh_util_core.add_message(x_return_status, l_module_name);
2199: --
2200: IF l_debug_on THEN
2201: wsh_debug_sv.pop(l_module_name);

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

2194: l_batch_grp_rec.autocreate_delivery_flag <> 'Y') THEN
2195: --{
2196: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_ACDEL_CRITERIA');
2197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2198: wsh_util_core.add_message(x_return_status, l_module_name);
2199: --
2200: IF l_debug_on THEN
2201: wsh_debug_sv.pop(l_module_name);
2202: END IF;

Line 2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2208: IF l_batch_grp_rec.Append_Flag = 'Y' or l_batch_grp_rec.Append_Flag is NULL THEN
2209:
2210: IF l_batch_grp_rec.organization_id is NULL THEN
2211: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_ORGANIZATION');
2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2213: wsh_util_core.add_message(x_return_status);
2214: IF l_debug_on THEN
2215: WSH_DEBUG_SV.pop(l_module_name);
2216: END IF;

Line 2213: wsh_util_core.add_message(x_return_status);

2209:
2210: IF l_batch_grp_rec.organization_id is NULL THEN
2211: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_ORGANIZATION');
2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2213: wsh_util_core.add_message(x_return_status);
2214: IF l_debug_on THEN
2215: WSH_DEBUG_SV.pop(l_module_name);
2216: END IF;
2217: return;

Line 2229: wsh_util_core.api_post_call(

2225: IF l_debug_on THEN
2226: wsh_debug_sv.logmsg(l_module_name, 'Return status from WSH_SHIPPING_PARAMS_PVT.Get is :'||l_return_status );
2227: END IF;
2228:
2229: wsh_util_core.api_post_call(
2230: p_return_status => l_return_status,
2231: x_num_warnings => l_number_of_warnings,
2232: x_num_errors => l_number_of_errors,
2233: p_msg_data => l_msg_data

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

2234: );
2235:
2236: IF NVL(l_param_info.appending_limit, 'N') = 'N' THEN
2237: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');
2238: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2240: wsh_util_core.add_message(x_return_status);
2241: IF l_debug_on THEN
2242: WSH_DEBUG_SV.pop(l_module_name);

Line 2239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2235:
2236: IF NVL(l_param_info.appending_limit, 'N') = 'N' THEN
2237: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');
2238: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2240: wsh_util_core.add_message(x_return_status);
2241: IF l_debug_on THEN
2242: WSH_DEBUG_SV.pop(l_module_name);
2243: END IF;

Line 2240: wsh_util_core.add_message(x_return_status);

2236: IF NVL(l_param_info.appending_limit, 'N') = 'N' THEN
2237: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_APPENDING_LIMIT');
2238: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2240: wsh_util_core.add_message(x_return_status);
2241: IF l_debug_on THEN
2242: WSH_DEBUG_SV.pop(l_module_name);
2243: END IF;
2244: return;

Line 2249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2245: END IF;
2246:
2247: IF NVL(l_batch_grp_rec.autocreate_delivery_flag, 'N') <> 'Y' THEN
2248: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTOCREATE_DEL');
2249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2250: wsh_util_core.add_message(x_return_status);
2251: IF l_debug_on THEN
2252: WSH_DEBUG_SV.pop(l_module_name);
2253: END IF;

Line 2250: wsh_util_core.add_message(x_return_status);

2246:
2247: IF NVL(l_batch_grp_rec.autocreate_delivery_flag, 'N') <> 'Y' THEN
2248: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTOCREATE_DEL');
2249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2250: wsh_util_core.add_message(x_return_status);
2251: IF l_debug_on THEN
2252: WSH_DEBUG_SV.pop(l_module_name);
2253: END IF;
2254: return;

Line 2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2255: END IF;
2256:
2257: IF NVL(l_batch_grp_rec.ac_delivery_criteria, 'Y') <> 'N' THEN
2258: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AC_DEL_CRITERIA');
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2260: wsh_util_core.add_message(x_return_status);
2261: IF l_debug_on THEN
2262: WSH_DEBUG_SV.pop(l_module_name);
2263: END IF;

Line 2260: wsh_util_core.add_message(x_return_status);

2256:
2257: IF NVL(l_batch_grp_rec.ac_delivery_criteria, 'Y') <> 'N' THEN
2258: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AC_DEL_CRITERIA');
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2260: wsh_util_core.add_message(x_return_status);
2261: IF l_debug_on THEN
2262: WSH_DEBUG_SV.pop(l_module_name);
2263: END IF;
2264: return;

Line 2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2265: END IF;
2266:
2267: IF NVL(l_batch_grp_rec.auto_pick_confirm_flag, 'Y') <> 'N' THEN
2268: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PICK');
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2270: wsh_util_core.add_message(x_return_status);
2271: IF l_debug_on THEN
2272: WSH_DEBUG_SV.pop(l_module_name);
2273: END IF;

Line 2270: wsh_util_core.add_message(x_return_status);

2266:
2267: IF NVL(l_batch_grp_rec.auto_pick_confirm_flag, 'Y') <> 'N' THEN
2268: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PICK');
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2270: wsh_util_core.add_message(x_return_status);
2271: IF l_debug_on THEN
2272: WSH_DEBUG_SV.pop(l_module_name);
2273: END IF;
2274: return;

Line 2279: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2275: END IF;
2276:
2277: IF l_batch_grp_rec.ship_confirm_rule_id is not NULL THEN
2278: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_SHIP');
2279: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2280: wsh_util_core.add_message(x_return_status);
2281: IF l_debug_on THEN
2282: WSH_DEBUG_SV.pop(l_module_name);
2283: END IF;

Line 2280: wsh_util_core.add_message(x_return_status);

2276:
2277: IF l_batch_grp_rec.ship_confirm_rule_id is not NULL THEN
2278: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_SHIP');
2279: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2280: wsh_util_core.add_message(x_return_status);
2281: IF l_debug_on THEN
2282: WSH_DEBUG_SV.pop(l_module_name);
2283: END IF;
2284: return;

Line 2289: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2285: END IF;
2286:
2287: IF NVL(l_batch_grp_rec.autopack_flag, 'Y') <> 'N' THEN
2288: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PACK');
2289: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2290: wsh_util_core.add_message(x_return_status);
2291: IF l_debug_on THEN
2292: WSH_DEBUG_SV.pop(l_module_name);
2293: END IF;

Line 2290: wsh_util_core.add_message(x_return_status);

2286:
2287: IF NVL(l_batch_grp_rec.autopack_flag, 'Y') <> 'N' THEN
2288: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PACK');
2289: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2290: wsh_util_core.add_message(x_return_status);
2291: IF l_debug_on THEN
2292: WSH_DEBUG_SV.pop(l_module_name);
2293: END IF;
2294: return;

Line 2300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2296:
2297: ELSIF l_batch_grp_rec.Append_Flag <> 'N' THEN
2298: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2299: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'APPEND_FLAG');
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: ELSIF l_batch_grp_rec.Append_Flag <> 'N' THEN
2298: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2299: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'APPEND_FLAG');
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 2318: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2314: close c_location_id;
2315:
2316: IF l_ship_from_loc_id <> l_batch_grp_rec.Ship_From_Location_Id THEN
2317: FND_MESSAGE.SET_NAME('WSH','WSH_ORG_SHIPFROM_NOT_COMP');
2318: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2319: wsh_util_core.add_message(x_return_status);
2320: IF l_debug_on THEN
2321: WSH_DEBUG_SV.pop(l_module_name);
2322: END IF;

Line 2319: wsh_util_core.add_message(x_return_status);

2315:
2316: IF l_ship_from_loc_id <> l_batch_grp_rec.Ship_From_Location_Id THEN
2317: FND_MESSAGE.SET_NAME('WSH','WSH_ORG_SHIPFROM_NOT_COMP');
2318: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2319: wsh_util_core.add_message(x_return_status);
2320: IF l_debug_on THEN
2321: WSH_DEBUG_SV.pop(l_module_name);
2322: END IF;
2323: return;

Line 2348: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2344: --
2345: IF l_batch_grp_rec.Organization_Id IS NULL THEN --{
2346: -- Fatal error if no warehouse specified
2347: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NO_WAREHOUSE');
2348: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2349: wsh_util_core.add_message(x_return_status);
2350: IF l_debug_on THEN
2351: WSH_DEBUG_SV.pop(l_module_name);
2352: END IF;

Line 2349: wsh_util_core.add_message(x_return_status);

2345: IF l_batch_grp_rec.Organization_Id IS NULL THEN --{
2346: -- Fatal error if no warehouse specified
2347: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NO_WAREHOUSE');
2348: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2349: wsh_util_core.add_message(x_return_status);
2350: IF l_debug_on THEN
2351: WSH_DEBUG_SV.pop(l_module_name);
2352: END IF;
2353: RETURN;

Line 2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2353: RETURN;
2354: ELSE --}{
2355: -- Warning if warehouse specified and others null
2356: FND_MESSAGE.SET_NAME('WSH', 'WSH_PR_CRITICAL_NULL');
2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2358: wsh_util_core.add_message(x_return_status);
2359: END IF; --}
2360: --
2361: END IF; --}

Line 2358: wsh_util_core.add_message(x_return_status);

2354: ELSE --}{
2355: -- Warning if warehouse specified and others null
2356: FND_MESSAGE.SET_NAME('WSH', 'WSH_PR_CRITICAL_NULL');
2357: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2358: wsh_util_core.add_message(x_return_status);
2359: END IF; --}
2360: --
2361: END IF; --}
2362:

Line 2398: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2394: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY
2395: )
2396: ) THEN
2397: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2398: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2399: wsh_util_core.add_message(x_return_status);
2400: IF l_debug_on THEN
2401: WSH_DEBUG_SV.pop(l_module_name);
2402: END IF;

Line 2399: wsh_util_core.add_message(x_return_status);

2395: )
2396: ) THEN
2397: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2398: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2399: wsh_util_core.add_message(x_return_status);
2400: IF l_debug_on THEN
2401: WSH_DEBUG_SV.pop(l_module_name);
2402: END IF;
2403: RETURN;

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

2407: -- call WMS API to validate cross dock criteria
2408: WMS_CROSSDOCK_GRP.validate_planxdock_crt_id
2409: (p_criterion_id => l_batch_grp_rec.crossdock_criteria_id,
2410: x_return_status => l_return_status);
2411: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2412: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');
2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2414: wsh_util_core.add_message(x_return_status);
2415: IF l_debug_on THEN

Line 2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2409: (p_criterion_id => l_batch_grp_rec.crossdock_criteria_id,
2410: x_return_status => l_return_status);
2411: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2412: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');
2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2414: wsh_util_core.add_message(x_return_status);
2415: IF l_debug_on THEN
2416: WSH_DEBUG_SV.pop(l_module_name);
2417: END IF;

Line 2414: wsh_util_core.add_message(x_return_status);

2410: x_return_status => l_return_status);
2411: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
2412: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');
2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2414: wsh_util_core.add_message(x_return_status);
2415: IF l_debug_on THEN
2416: WSH_DEBUG_SV.pop(l_module_name);
2417: END IF;
2418: RETURN;

Line 2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2419: END IF;
2420: ELSIF (l_batch_grp_rec.crossdock_criteria_id IS NOT NULL AND
2421: l_batch_grp_rec.allocation_method = (WSH_PICK_LIST.C_INVENTORY_ONLY)) THEN
2422: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2424: wsh_util_core.add_message(x_return_status);
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.pop(l_module_name);
2427: END IF;

Line 2424: wsh_util_core.add_message(x_return_status);

2420: ELSIF (l_batch_grp_rec.crossdock_criteria_id IS NOT NULL AND
2421: l_batch_grp_rec.allocation_method = (WSH_PICK_LIST.C_INVENTORY_ONLY)) THEN
2422: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2424: wsh_util_core.add_message(x_return_status);
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.pop(l_module_name);
2427: END IF;
2428: RETURN;

Line 2435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2431: ELSIF (l_batch_grp_rec.dynamic_replenishment_flag = 'Y' AND
2432: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY)) THEN
2433: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DYNAMIC_REPLENISHMENT_FLAG');
2435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2436: wsh_util_core.add_message(x_return_status);
2437: IF l_debug_on THEN
2438: WSH_DEBUG_SV.pop(l_module_name);
2439: END IF;

Line 2436: wsh_util_core.add_message(x_return_status);

2432: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY)) THEN
2433: FND_MESSAGE.SET_NAME('WSH', 'WSH_OI_INVALID_ATTRIBUTE');
2434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DYNAMIC_REPLENISHMENT_FLAG');
2435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2436: wsh_util_core.add_message(x_return_status);
2437: IF l_debug_on THEN
2438: WSH_DEBUG_SV.pop(l_module_name);
2439: END IF;
2440: RETURN;

Line 2446: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2442: ELSE -- non WMS org
2443: IF l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2444: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
2445: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2446: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2447: wsh_util_core.add_message(x_return_status);
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.pop(l_module_name);
2450: END IF;

Line 2447: wsh_util_core.add_message(x_return_status);

2443: IF l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,
2444: WSH_PICK_LIST.C_PRIORITIZE_CROSSDOCK,WSH_PICK_LIST.C_PRIORITIZE_INVENTORY) THEN
2445: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2446: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2447: wsh_util_core.add_message(x_return_status);
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.pop(l_module_name);
2450: END IF;
2451: RETURN;

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

2551: );
2552:
2553: IF l_debug_on THEN
2554: --{
2555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2556: --}
2557: END IF;
2558: --
2559: wsh_util_core.api_post_call(

Line 2559: wsh_util_core.api_post_call(

2555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2556: --}
2557: END IF;
2558: --
2559: wsh_util_core.api_post_call(
2560: p_return_status => l_return_status,
2561: x_num_warnings => l_number_of_warnings,
2562: x_num_errors => l_number_of_errors,
2563: p_msg_data => l_msg_data

Line 2591: wsh_util_core.add_message(x_return_status);

2587: EXCEPTION
2588: WHEN FND_API.G_EXC_ERROR THEN
2589: ROLLBACK TO PICKING_BATCH_GRP;
2590: x_return_status := FND_API.G_RET_STS_ERROR ;
2591: wsh_util_core.add_message(x_return_status);
2592: FND_MSG_PUB.Count_And_Get
2593: (
2594: p_count => x_msg_count,
2595: p_data => x_msg_data,

Line 2612: wsh_util_core.add_message(x_return_status);

2608: ROLLBACK TO PICKING_BATCH_GRP;
2609: FND_MESSAGE.SET_NAME('WSH', 'WSH_PUB_CONSOL_DEL_PR');
2610: FND_MESSAGE.SET_TOKEN('PARAMETER',l_batch_in_rec.Delivery_id);
2611: x_return_status := FND_API.G_RET_STS_ERROR ;
2612: wsh_util_core.add_message(x_return_status);
2613: FND_MSG_PUB.Count_And_Get
2614: (
2615: p_count => x_msg_count,
2616: p_data => x_msg_data,

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

2627:
2628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2629: ROLLBACK TO PICKING_BATCH_GRP;
2630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2631: wsh_util_core.add_message(x_return_status, l_module_name);
2632: FND_MSG_PUB.Count_And_Get
2633: (
2634: p_count => x_msg_count,
2635: p_data => x_msg_data,

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

2644: --}
2645: END IF;
2646: WHEN OTHERS THEN
2647: ROLLBACK TO PICKING_BATCH_GRP;
2648: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');
2649: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2650: FND_MSG_PUB.Count_And_Get
2651: (
2652: p_count => x_msg_count,

Line 2649: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2645: END IF;
2646: WHEN OTHERS THEN
2647: ROLLBACK TO PICKING_BATCH_GRP;
2648: wsh_util_core.default_handler('WSH_PICKING_BATCHES_PUB.CREATE_BATCH');
2649: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2650: FND_MSG_PUB.Count_And_Get
2651: (
2652: p_count => x_msg_count,
2653: p_data => x_msg_data,

Line 2786: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2782: --{
2783: fnd_msg_pub.initialize;
2784: --}
2785: END IF;
2786: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2787: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2788: l_batch_id := p_batch_id;
2789: l_batch_name := p_batch_name;
2790: l_log_level := p_log_level;

Line 2787: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2783: fnd_msg_pub.initialize;
2784: --}
2785: END IF;
2786: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2787: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2788: l_batch_id := p_batch_id;
2789: l_batch_name := p_batch_name;
2790: l_log_level := p_log_level;
2791:

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

2815: x_return_status => l_return_status);
2816:
2817: IF l_debug_on THEN
2818: --{
2819: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2820: --}
2821: END IF;
2822: --
2823: wsh_util_core.api_post_call(

Line 2823: wsh_util_core.api_post_call(

2819: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2820: --}
2821: END IF;
2822: --
2823: wsh_util_core.api_post_call(
2824: p_return_status => l_return_status,
2825: x_num_warnings => l_number_of_warnings,
2826: x_num_errors => l_number_of_errors,
2827: p_msg_data => l_msg_data

Line 2836: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2832: --
2833: --
2834: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2835: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');
2836: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2837: wsh_util_core.add_message(x_return_status);
2838: return;
2839: --}
2840: END IF;

Line 2837: wsh_util_core.add_message(x_return_status);

2833: --
2834: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2835: FND_MESSAGE.SET_TOKEN('FIELD_NAME ',' BATCH_ID OR BATCH_NAME ');
2836: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2837: wsh_util_core.add_message(x_return_status);
2838: return;
2839: --}
2840: END IF;
2841:

Line 2849: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2845: IF ( ( p_release_mode IS NULL ) OR ( p_release_mode NOT IN ('CONCURRENT','ONLINE'))) THEN
2846: --{
2847: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
2848: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_RELEASE_MODE');
2849: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2850: wsh_util_core.add_message(x_return_status);
2851: return;
2852: --}
2853: END IF;

Line 2850: wsh_util_core.add_message(x_return_status);

2846: --{
2847: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');
2848: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','P_RELEASE_MODE');
2849: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2850: wsh_util_core.add_message(x_return_status);
2851: return;
2852: --}
2853: END IF;
2854: -- End of Validating the Release Mode

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

2861: x_return_status => l_return_status);
2862:
2863: IF l_debug_on THEN
2864: --{
2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2866: --}
2867: END IF;
2868: --
2869: wsh_util_core.api_post_call(

Line 2869: wsh_util_core.api_post_call(

2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2866: --}
2867: END IF;
2868: --
2869: wsh_util_core.api_post_call(
2870: p_return_status => l_return_status,
2871: x_num_warnings => l_number_of_warnings,
2872: x_num_errors => l_number_of_errors,
2873: p_msg_data => l_msg_data

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

2890: p_log_level => l_log_level,
2891: p_num_workers => p_num_workers);
2892: IF l_debug_on THEN
2893: --{
2894: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2895: --}
2896: END IF;
2897: --
2898: wsh_util_core.api_post_call(

Line 2898: wsh_util_core.api_post_call(

2894: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2895: --}
2896: END IF;
2897: --
2898: wsh_util_core.api_post_call(
2899: p_return_status => l_return_status,
2900: x_num_warnings => l_number_of_warnings,
2901: x_num_errors => l_number_of_errors,
2902: p_msg_data => l_msg_data

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

2926: p_pick_skip => l_pick_skip);
2927:
2928: IF l_debug_on THEN
2929: --{
2930: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2931: --}
2932: END IF;
2933: --
2934: wsh_util_core.api_post_call(

Line 2934: wsh_util_core.api_post_call(

2930: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2931: --}
2932: END IF;
2933: --
2934: wsh_util_core.api_post_call(
2935: p_return_status => l_return_status,
2936: x_num_warnings => l_number_of_warnings,
2937: x_num_errors => l_number_of_errors,
2938: p_msg_data => l_msg_data

Line 2948: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2944: IF (nvl(l_pick_phase,'START') ='MOVE_ORDER_LINES') then
2945: --{
2946: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PARTIAL');
2947: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
2948: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2949: wsh_util_core.add_message(x_return_status,l_module_name);
2950: ELSE
2951: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
2952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

2945: --{
2946: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PARTIAL');
2947: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
2948: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2949: wsh_util_core.add_message(x_return_status,l_module_name);
2950: ELSE
2951: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
2952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2953: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2948: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2949: wsh_util_core.add_message(x_return_status,l_module_name);
2950: ELSE
2951: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
2952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2953: wsh_util_core.add_message(x_return_status,l_module_name);
2954: --}
2955: END IF;
2956: ELSIF (nvl(l_pick_result, 'F') = 'W') then

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

2949: wsh_util_core.add_message(x_return_status,l_module_name);
2950: ELSE
2951: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_FAILED');
2952: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2953: wsh_util_core.add_message(x_return_status,l_module_name);
2954: --}
2955: END IF;
2956: ELSIF (nvl(l_pick_result, 'F') = 'W') then
2957: IF (nvl(l_pick_phase,'START') ='MOVE_ORDER_LINES') then

Line 2961: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2957: IF (nvl(l_pick_phase,'START') ='MOVE_ORDER_LINES') then
2958: --{
2959: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PART_WARN');
2960: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
2961: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2962: wsh_util_core.add_message(x_return_status,l_module_name);
2963: ELSE
2964: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
2965: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2958: --{
2959: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_PART_WARN');
2960: FND_MESSAGE.SET_TOKEN('MOVE_ORDER', l_batch_name);
2961: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2962: wsh_util_core.add_message(x_return_status,l_module_name);
2963: ELSE
2964: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
2965: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2966: wsh_util_core.add_message(x_return_status,l_module_name);

Line 2965: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2961: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2962: wsh_util_core.add_message(x_return_status,l_module_name);
2963: ELSE
2964: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
2965: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2966: wsh_util_core.add_message(x_return_status,l_module_name);
2967: --}
2968: END IF;
2969: ELSE

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

2962: wsh_util_core.add_message(x_return_status,l_module_name);
2963: ELSE
2964: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_WARN');
2965: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2966: wsh_util_core.add_message(x_return_status,l_module_name);
2967: --}
2968: END IF;
2969: ELSE
2970: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_SUCCESS');

Line 2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2967: --}
2968: END IF;
2969: ELSE
2970: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_SUCCESS');
2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2972: wsh_util_core.add_message(x_return_status,l_module_name);
2973: --}
2974: END IF;
2975: --}

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

2968: END IF;
2969: ELSE
2970: FND_MESSAGE.SET_NAME('WSH','WSH_PR_ONLINE_SUCCESS');
2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2972: wsh_util_core.add_message(x_return_status,l_module_name);
2973: --}
2974: END IF;
2975: --}
2976: END IF;

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

2977:
2978:
2979: IF l_debug_on THEN
2980: --{
2981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2982: --}
2983: END IF;
2984: --
2985: wsh_util_core.api_post_call(

Line 2985: wsh_util_core.api_post_call(

2981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2982: --}
2983: END IF;
2984: --
2985: wsh_util_core.api_post_call(
2986: p_return_status => l_return_status,
2987: x_num_warnings => l_number_of_warnings,
2988: x_num_errors => l_number_of_errors,
2989: p_msg_data => l_msg_data

Line 3015: wsh_util_core.add_message(x_return_status);

3011: EXCEPTION
3012: WHEN FND_API.G_EXC_ERROR THEN
3013: ROLLBACK TO PICKING_BATCH_GRP;
3014: x_return_status := FND_API.G_RET_STS_ERROR ;
3015: wsh_util_core.add_message(x_return_status);
3016: FND_MSG_PUB.Count_And_Get
3017: (
3018: p_count => x_msg_count,
3019: p_data => x_msg_data,

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

3030:
3031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3032: ROLLBACK TO PICKING_BATCH_GRP;
3033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3034: wsh_util_core.add_message(x_return_status, l_module_name);
3035: FND_MSG_PUB.Count_And_Get
3036: (
3037: p_count => x_msg_count,
3038: p_data => x_msg_data,

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

3047: --}
3048: END IF;
3049: WHEN OTHERS THEN
3050: ROLLBACK TO PICKING_BATCH_GRP;
3051: wsh_util_core.default_handler('WSH_PICKING_BATCHES_GRP.RELEASE_BATCH');
3052: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3053: FND_MSG_PUB.Count_And_Get
3054: (
3055: p_count => x_msg_count,

Line 3052: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3048: END IF;
3049: WHEN OTHERS THEN
3050: ROLLBACK TO PICKING_BATCH_GRP;
3051: wsh_util_core.default_handler('WSH_PICKING_BATCHES_GRP.RELEASE_BATCH');
3052: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3053: FND_MSG_PUB.Count_And_Get
3054: (
3055: p_count => x_msg_count,
3056: p_data => x_msg_data,