202: IF (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN
203: p_delivery_info.delivery_id := NULL;
204: END IF;
205:
206: wsh_util_validate.validate_delivery_name(
207: p_delivery_info.delivery_id,
208: p_delivery_info.name,
209: x_return_status);
210:
221: IF (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN
222: p_delivery_info.organization_id := NULL;
223: END IF;
224:
225: wsh_util_validate.validate_org(
226: p_delivery_info.organization_id,
227: p_delivery_info.organization_code,
228: x_return_status);
229:
242: IF (p_delivery_info.loading_order_desc <> FND_API.G_MISS_CHAR) THEN
243: p_delivery_info.loading_order_flag := NULL;
244: END IF;
245:
246: wsh_util_validate.validate_loading_order(
247: p_delivery_info.loading_order_flag,
248: p_delivery_info.loading_order_desc,
249: x_return_status);
250:
258: IF (p_delivery_info.initial_pickup_location_code <> FND_API.G_MISS_CHAR) THEN
259: p_delivery_info.initial_pickup_location_id := NULL;
260: END IF;
261:
262: wsh_util_validate.validate_location(
263: p_delivery_info.initial_pickup_location_id,
264: p_delivery_info.initial_pickup_location_code,
265: x_return_status);
266:
274: IF (p_delivery_info.ultimate_dropoff_location_code <> FND_API.G_MISS_CHAR) THEN
275: p_delivery_info.ultimate_dropoff_location_id := NULL;
276: END IF;
277:
278: wsh_util_validate.validate_location(
279: p_delivery_info.ultimate_dropoff_location_id,
280: p_delivery_info.ultimate_dropoff_location_code,
281: x_return_status);
282:
290: IF (p_delivery_info.intmed_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
291: p_delivery_info.intmed_ship_to_location_id := NULL;
292: END IF;
293:
294: wsh_util_validate.validate_location(
295: p_delivery_info.intmed_ship_to_location_id,
296: p_delivery_info.intmed_ship_to_location_code,
297: x_return_status);
298:
306: IF (p_delivery_info.pooled_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
307: p_delivery_info.pooled_ship_to_location_id := NULL;
308: END IF;
309:
310: wsh_util_validate.validate_location(
311: p_delivery_info.pooled_ship_to_location_id,
312: p_delivery_info.pooled_ship_to_location_code,
313: x_return_status);
314:
322: IF (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN
323: p_delivery_info.customer_id := NULL;
324: END IF;
325:
326: wsh_util_validate.validate_customer(
327: p_delivery_info.customer_id,
328: p_delivery_info.customer_number,
329: x_return_status);
330:
340: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) THEN
341: p_delivery_info.ship_method_name := NULL;
342: END IF;
343:
344: wsh_util_validate.validate_ship_method(
345: p_delivery_info.ship_method_code,
346: p_delivery_info.ship_method_name,
347: x_return_status);
348:
356: IF (p_delivery_info.freight_terms_name <> FND_API.G_MISS_CHAR) THEN
357: p_delivery_info.freight_terms_name := NULL;
358: END IF;
359:
360: wsh_util_validate.validate_freight_terms(
361: p_delivery_info.freight_terms_code,
362: p_delivery_info.freight_terms_name,
363: x_return_status);
364:
372: IF (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN
373: p_delivery_info.fob_code := NULL;
374: END IF;
375:
376: wsh_util_validate.validate_fob(
377: p_delivery_info.fob_code,
378: p_delivery_info.fob_name,
379: x_return_status);
380:
388: IF (p_delivery_info.fob_location_code <> FND_API.G_MISS_CHAR) THEN
389: p_delivery_info.fob_location_id := NULL;
390: END IF;
391:
392: wsh_util_validate.validate_location(
393: p_delivery_info.fob_location_id,
394: p_delivery_info.fob_location_code,
395: x_return_status);
396:
404: IF (p_delivery_info.weight_uom_desc <> FND_API.G_MISS_CHAR) THEN
405: p_delivery_info.weight_uom_code := NULL;
406: END IF;
407:
408: wsh_util_validate.validate_uom(
409: 'WEIGHT',
410: p_delivery_info.organization_id,
411: p_delivery_info.weight_uom_code,
412: p_delivery_info.weight_uom_desc,
422: IF (p_delivery_info.volume_uom_desc <> FND_API.G_MISS_CHAR) THEN
423: p_delivery_info.volume_uom_code := NULL;
424: END IF;
425:
426: wsh_util_validate.validate_uom(
427: 'VOLUME',
428: p_delivery_info.organization_id,
429: p_delivery_info.volume_uom_code,
430: p_delivery_info.volume_uom_desc,
441: p_delivery_info.currency_code := NULL;
442: END IF;
443:
444: -- OTM R12, glog project changes, to use name value notation
445: WSH_UTIL_VALIDATE.validate_currency(
446: p_currency_code => p_delivery_info.currency_code,
447: p_currency_name => p_delivery_info.currency_name,
448: p_amount => NULL,
449: x_return_status => x_return_status,
797: x_num_warnings => l_num_warnings);
798: --
799: IF (p_action_code = 'UPDATE') THEN
800: --
801: wsh_util_validate.validate_delivery_name(
802: p_delivery_id => l_rec_attr_tab(1).delivery_id,
803: p_delivery_name => l_rec_attr_tab(1).name,
804: x_return_status => l_return_status);
805: --
849: (l_rec_attr_tab(1).WEIGHT_UOM_CODE = FND_API.G_MISS_CHAR OR
850: l_rec_attr_tab(1).VOLUME_UOM_CODE = FND_API.G_MISS_CHAR
851: ) THEN
852: --
853: wsh_util_validate.validate_org( p_org_id => l_rec_attr_tab(1).ORGANIZATION_ID ,
854: p_org_code => l_rec_attr_tab(1).ORGANIZATION_CODE ,
855: x_return_status => l_return_status );
856: --
857: IF l_debug_on THEN
1073: IF FND_API.to_Boolean(p_init_msg_list) THEN
1074: FND_MSG_PUB.initialize;
1075: END IF;
1076:
1077: wsh_util_validate.validate_delivery_name(
1078: p_delivery_id => l_delivery_id,
1079: p_delivery_name => p_delivery_name,
1080: x_return_status => l_return_status);
1081: --
1305: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1306: l_count := 0;
1307:
1308: -- Validation of Organization_Code
1309: WSH_UTIL_VALIDATE.Validate_Org(
1310: l_organization_id ,
1311: p_organization_code,
1312: x_return_status );
1313: IF l_debug_on THEN
1326: FOR i in 1..l_delivery_count LOOP
1327:
1328: l_delivery_name := p_delivery_name(i);
1329: l_delivery_id := NULL;
1330: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
1331: l_delivery_id ,
1332: l_delivery_name,
1333: x_return_status);
1334: IF l_debug_on THEN