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_DELIVERIES_PUB dependencies on FND_API

Line 186: IF (p_delivery_info.delivery_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN

182: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
183:
184: IF (p_action_code <> 'CREATE') THEN
185:
186: IF (p_delivery_info.delivery_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN
187:
188: IF (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN
189: p_delivery_info.delivery_id := NULL;
190: END IF;

Line 188: IF (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN

184: IF (p_action_code <> 'CREATE') THEN
185:
186: IF (p_delivery_info.delivery_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN
187:
188: IF (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN
189: p_delivery_info.delivery_id := NULL;
190: END IF;
191:
192: wsh_util_validate.validate_delivery_name(

Line 205: IF (p_delivery_info.organization_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN

201: END IF;
202:
203: END IF;
204:
205: IF (p_delivery_info.organization_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN
206:
207: IF (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN
208: p_delivery_info.organization_id := NULL;
209: END IF;

Line 207: IF (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN

203: END IF;
204:
205: IF (p_delivery_info.organization_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN
206:
207: IF (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN
208: p_delivery_info.organization_id := NULL;
209: END IF;
210:
211: wsh_util_validate.validate_org(

Line 226: IF (p_delivery_info.loading_order_flag <> FND_API.G_MISS_CHAR) OR (p_delivery_info.loading_order_desc <> FND_API.G_MISS_CHAR) THEN

222: p_delivery_info.delivery_type := 'STANDARD';
223:
224: END IF;
225:
226: IF (p_delivery_info.loading_order_flag <> FND_API.G_MISS_CHAR) OR (p_delivery_info.loading_order_desc <> FND_API.G_MISS_CHAR) THEN
227:
228: IF (p_delivery_info.loading_order_desc <> FND_API.G_MISS_CHAR) THEN
229: p_delivery_info.loading_order_flag := NULL;
230: END IF;

Line 228: IF (p_delivery_info.loading_order_desc <> FND_API.G_MISS_CHAR) THEN

224: END IF;
225:
226: IF (p_delivery_info.loading_order_flag <> FND_API.G_MISS_CHAR) OR (p_delivery_info.loading_order_desc <> FND_API.G_MISS_CHAR) THEN
227:
228: IF (p_delivery_info.loading_order_desc <> FND_API.G_MISS_CHAR) THEN
229: p_delivery_info.loading_order_flag := NULL;
230: END IF;
231:
232: wsh_util_validate.validate_loading_order(

Line 242: IF (p_delivery_info.initial_pickup_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.initial_pickup_location_code <> FND_API.G_MISS_CHAR) THEN

238: RETURN;
239: END IF;
240: END IF;
241:
242: IF (p_delivery_info.initial_pickup_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.initial_pickup_location_code <> FND_API.G_MISS_CHAR) THEN
243:
244: IF (p_delivery_info.initial_pickup_location_code <> FND_API.G_MISS_CHAR) THEN
245: p_delivery_info.initial_pickup_location_id := NULL;
246: END IF;

Line 244: IF (p_delivery_info.initial_pickup_location_code <> FND_API.G_MISS_CHAR) THEN

240: END IF;
241:
242: IF (p_delivery_info.initial_pickup_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.initial_pickup_location_code <> FND_API.G_MISS_CHAR) THEN
243:
244: IF (p_delivery_info.initial_pickup_location_code <> FND_API.G_MISS_CHAR) THEN
245: p_delivery_info.initial_pickup_location_id := NULL;
246: END IF;
247:
248: wsh_util_validate.validate_location(

Line 258: IF (p_delivery_info.ultimate_dropoff_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.ultimate_dropoff_location_code <> FND_API.G_MISS_CHAR) THEN

254: RETURN;
255: END IF;
256: END IF;
257:
258: IF (p_delivery_info.ultimate_dropoff_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.ultimate_dropoff_location_code <> FND_API.G_MISS_CHAR) THEN
259:
260: IF (p_delivery_info.ultimate_dropoff_location_code <> FND_API.G_MISS_CHAR) THEN
261: p_delivery_info.ultimate_dropoff_location_id := NULL;
262: END IF;

Line 260: IF (p_delivery_info.ultimate_dropoff_location_code <> FND_API.G_MISS_CHAR) THEN

256: END IF;
257:
258: IF (p_delivery_info.ultimate_dropoff_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.ultimate_dropoff_location_code <> FND_API.G_MISS_CHAR) THEN
259:
260: IF (p_delivery_info.ultimate_dropoff_location_code <> FND_API.G_MISS_CHAR) THEN
261: p_delivery_info.ultimate_dropoff_location_id := NULL;
262: END IF;
263:
264: wsh_util_validate.validate_location(

Line 274: IF (p_delivery_info.intmed_ship_to_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.intmed_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN

270: RETURN;
271: END IF;
272: END IF;
273:
274: IF (p_delivery_info.intmed_ship_to_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.intmed_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
275:
276: IF (p_delivery_info.intmed_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
277: p_delivery_info.intmed_ship_to_location_id := NULL;
278: END IF;

Line 276: IF (p_delivery_info.intmed_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN

272: END IF;
273:
274: IF (p_delivery_info.intmed_ship_to_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.intmed_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
275:
276: IF (p_delivery_info.intmed_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
277: p_delivery_info.intmed_ship_to_location_id := NULL;
278: END IF;
279:
280: wsh_util_validate.validate_location(

Line 290: IF (p_delivery_info.pooled_ship_to_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.pooled_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN

286: RETURN;
287: END IF;
288: END IF;
289:
290: IF (p_delivery_info.pooled_ship_to_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.pooled_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
291:
292: IF (p_delivery_info.pooled_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
293: p_delivery_info.pooled_ship_to_location_id := NULL;
294: END IF;

Line 292: IF (p_delivery_info.pooled_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN

288: END IF;
289:
290: IF (p_delivery_info.pooled_ship_to_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.pooled_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
291:
292: IF (p_delivery_info.pooled_ship_to_location_code <> FND_API.G_MISS_CHAR) THEN
293: p_delivery_info.pooled_ship_to_location_id := NULL;
294: END IF;
295:
296: wsh_util_validate.validate_location(

Line 306: IF (p_delivery_info.customer_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN

302: RETURN;
303: END IF;
304: END IF;
305:
306: IF (p_delivery_info.customer_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN
307:
308: IF (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN
309: p_delivery_info.customer_id := NULL;
310: END IF;

Line 308: IF (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN

304: END IF;
305:
306: IF (p_delivery_info.customer_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN
307:
308: IF (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN
309: p_delivery_info.customer_id := NULL;
310: END IF;
311:
312: wsh_util_validate.validate_customer(

Line 324: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_name <> FND_API.G_MISS_CHAR) THEN

320: END IF;
321:
322: -- Carrier ID is not validated as it is not used...Ship method is used instead.
323:
324: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_name <> FND_API.G_MISS_CHAR) THEN
325:
326: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) THEN
327: p_delivery_info.ship_method_name := NULL;
328: END IF;

Line 326: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) THEN

322: -- Carrier ID is not validated as it is not used...Ship method is used instead.
323:
324: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_name <> FND_API.G_MISS_CHAR) THEN
325:
326: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) THEN
327: p_delivery_info.ship_method_name := NULL;
328: END IF;
329:
330: wsh_util_validate.validate_ship_method(

Line 340: IF (p_delivery_info.freight_terms_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.freight_terms_name <> FND_API.G_MISS_CHAR) THEN

336: RETURN;
337: END IF;
338: END IF;
339:
340: IF (p_delivery_info.freight_terms_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.freight_terms_name <> FND_API.G_MISS_CHAR) THEN
341:
342: IF (p_delivery_info.freight_terms_name <> FND_API.G_MISS_CHAR) THEN
343: p_delivery_info.freight_terms_name := NULL;
344: END IF;

Line 342: IF (p_delivery_info.freight_terms_name <> FND_API.G_MISS_CHAR) THEN

338: END IF;
339:
340: IF (p_delivery_info.freight_terms_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.freight_terms_name <> FND_API.G_MISS_CHAR) THEN
341:
342: IF (p_delivery_info.freight_terms_name <> FND_API.G_MISS_CHAR) THEN
343: p_delivery_info.freight_terms_name := NULL;
344: END IF;
345:
346: wsh_util_validate.validate_freight_terms(

Line 356: IF (p_delivery_info.fob_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN

352: RETURN;
353: END IF;
354: END IF;
355:
356: IF (p_delivery_info.fob_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN
357:
358: IF (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN
359: p_delivery_info.fob_code := NULL;
360: END IF;

Line 358: IF (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN

354: END IF;
355:
356: IF (p_delivery_info.fob_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN
357:
358: IF (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN
359: p_delivery_info.fob_code := NULL;
360: END IF;
361:
362: wsh_util_validate.validate_fob(

Line 372: IF (p_delivery_info.fob_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.fob_location_code <> FND_API.G_MISS_CHAR) THEN

368: RETURN;
369: END IF;
370: END IF;
371:
372: IF (p_delivery_info.fob_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.fob_location_code <> FND_API.G_MISS_CHAR) THEN
373:
374: IF (p_delivery_info.fob_location_code <> FND_API.G_MISS_CHAR) THEN
375: p_delivery_info.fob_location_id := NULL;
376: END IF;

Line 374: IF (p_delivery_info.fob_location_code <> FND_API.G_MISS_CHAR) THEN

370: END IF;
371:
372: IF (p_delivery_info.fob_location_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.fob_location_code <> FND_API.G_MISS_CHAR) THEN
373:
374: IF (p_delivery_info.fob_location_code <> FND_API.G_MISS_CHAR) THEN
375: p_delivery_info.fob_location_id := NULL;
376: END IF;
377:
378: wsh_util_validate.validate_location(

Line 388: IF (p_delivery_info.weight_uom_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.weight_uom_desc <> FND_API.G_MISS_CHAR) THEN

384: RETURN;
385: END IF;
386: END IF;
387:
388: IF (p_delivery_info.weight_uom_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.weight_uom_desc <> FND_API.G_MISS_CHAR) THEN
389:
390: IF (p_delivery_info.weight_uom_desc <> FND_API.G_MISS_CHAR) THEN
391: p_delivery_info.weight_uom_code := NULL;
392: END IF;

Line 390: IF (p_delivery_info.weight_uom_desc <> FND_API.G_MISS_CHAR) THEN

386: END IF;
387:
388: IF (p_delivery_info.weight_uom_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.weight_uom_desc <> FND_API.G_MISS_CHAR) THEN
389:
390: IF (p_delivery_info.weight_uom_desc <> FND_API.G_MISS_CHAR) THEN
391: p_delivery_info.weight_uom_code := NULL;
392: END IF;
393:
394: wsh_util_validate.validate_uom(

Line 406: IF (p_delivery_info.volume_uom_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.volume_uom_desc <> FND_API.G_MISS_CHAR) THEN

402: RETURN;
403: END IF;
404: END IF;
405:
406: IF (p_delivery_info.volume_uom_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.volume_uom_desc <> FND_API.G_MISS_CHAR) THEN
407:
408: IF (p_delivery_info.volume_uom_desc <> FND_API.G_MISS_CHAR) THEN
409: p_delivery_info.volume_uom_code := NULL;
410: END IF;

Line 408: IF (p_delivery_info.volume_uom_desc <> FND_API.G_MISS_CHAR) THEN

404: END IF;
405:
406: IF (p_delivery_info.volume_uom_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.volume_uom_desc <> FND_API.G_MISS_CHAR) THEN
407:
408: IF (p_delivery_info.volume_uom_desc <> FND_API.G_MISS_CHAR) THEN
409: p_delivery_info.volume_uom_code := NULL;
410: END IF;
411:
412: wsh_util_validate.validate_uom(

Line 424: IF (p_delivery_info.currency_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN

420: RETURN;
421: END IF;
422: END IF;
423:
424: IF (p_delivery_info.currency_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN
425:
426: IF (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN
427: p_delivery_info.currency_code := NULL;
428: END IF;

Line 426: IF (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN

422: END IF;
423:
424: IF (p_delivery_info.currency_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN
425:
426: IF (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN
427: p_delivery_info.currency_code := NULL;
428: END IF;
429:
430: -- OTM R12, glog project changes, to use name value notation

Line 449: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR

445: -- manifesting code changes
446: -- disallow update of ship method or its components if the delivery is assigned to trip.
447: --
448:
449: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR
450: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
451: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
452: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
453:

Line 450: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR

446: -- disallow update of ship method or its components if the delivery is assigned to trip.
447: --
448:
449: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR
450: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
451: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
452: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
453:
454: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip

Line 451: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR

447: --
448:
449: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR
450: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
451: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
452: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
453:
454: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
455: (p_delivery_id => p_delivery_info.delivery_id,

Line 452: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN

448:
449: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR
450: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
451: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
452: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
453:
454: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
455: (p_delivery_id => p_delivery_info.delivery_id,
456: x_return_status => x_return_status);

Line 633: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;

629: x_pvt_rec.SHIPPING_MARKS := p_pub_rec.SHIPPING_MARKS;
630: x_pvt_rec.SERVICE_LEVEL := p_pub_rec.SERVICE_LEVEL;
631: x_pvt_rec.MODE_OF_TRANSPORT := p_pub_rec.MODE_OF_TRANSPORT;
632: x_pvt_rec.ASSIGNED_TO_FTE_TRIPS := p_pub_rec.ASSIGNED_TO_FTE_TRIPS;
633: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
634: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
635: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
636: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
637: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;

Line 634: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;

630: x_pvt_rec.SERVICE_LEVEL := p_pub_rec.SERVICE_LEVEL;
631: x_pvt_rec.MODE_OF_TRANSPORT := p_pub_rec.MODE_OF_TRANSPORT;
632: x_pvt_rec.ASSIGNED_TO_FTE_TRIPS := p_pub_rec.ASSIGNED_TO_FTE_TRIPS;
633: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
634: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
635: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
636: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
637: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
638: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;

Line 635: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;

631: x_pvt_rec.MODE_OF_TRANSPORT := p_pub_rec.MODE_OF_TRANSPORT;
632: x_pvt_rec.ASSIGNED_TO_FTE_TRIPS := p_pub_rec.ASSIGNED_TO_FTE_TRIPS;
633: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
634: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
635: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
636: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
637: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
638: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;
639: x_pvt_rec.AUTO_AP_EXCLUDE_FLAG := p_pub_rec.AUTO_AP_EXCLUDE_FLAG;

Line 636: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;

632: x_pvt_rec.ASSIGNED_TO_FTE_TRIPS := p_pub_rec.ASSIGNED_TO_FTE_TRIPS;
633: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
634: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
635: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
636: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
637: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
638: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;
639: x_pvt_rec.AUTO_AP_EXCLUDE_FLAG := p_pub_rec.AUTO_AP_EXCLUDE_FLAG;
640: x_pvt_rec.AP_BATCH_ID := FND_API.G_MISS_NUM;

Line 637: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;

633: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
634: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
635: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
636: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
637: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
638: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;
639: x_pvt_rec.AUTO_AP_EXCLUDE_FLAG := p_pub_rec.AUTO_AP_EXCLUDE_FLAG;
640: x_pvt_rec.AP_BATCH_ID := FND_API.G_MISS_NUM;
641: /*3667348*/

Line 640: x_pvt_rec.AP_BATCH_ID := FND_API.G_MISS_NUM;

636: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
637: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
638: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;
639: x_pvt_rec.AUTO_AP_EXCLUDE_FLAG := p_pub_rec.AUTO_AP_EXCLUDE_FLAG;
640: x_pvt_rec.AP_BATCH_ID := FND_API.G_MISS_NUM;
641: /*3667348*/
642: x_pvt_rec.REASON_OF_TRANSPORT := p_pub_rec.REASON_OF_TRANSPORT;
643: x_pvt_rec.DESCRIPTION := p_pub_rec.DESCRIPTION;
644: -- Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).

Line 645: IF p_pub_rec.prorate_wt_flag = FND_API.G_MISS_CHAR THEN

641: /*3667348*/
642: x_pvt_rec.REASON_OF_TRANSPORT := p_pub_rec.REASON_OF_TRANSPORT;
643: x_pvt_rec.DESCRIPTION := p_pub_rec.DESCRIPTION;
644: -- Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
645: IF p_pub_rec.prorate_wt_flag = FND_API.G_MISS_CHAR THEN
646: --{
647: x_pvt_rec.prorate_wt_flag := WSH_UTIL_CORE.FTE_Is_Installed ;
648: ELSIF p_pub_rec.prorate_wt_flag = 'Y' THEN
649: x_pvt_rec.prorate_wt_flag := 'Y';

Line 675: -- p_init_msg_list FND_API.G_TRUE to reset list

671: --========================================================================
672: -- PROCEDURE : Create_Update_Delivery PUBLIC
673: --
674: -- PARAMETERS: p_api_version_number known api versionerror buffer
675: -- p_init_msg_list FND_API.G_TRUE to reset list
676: -- x_return_status return status
677: -- x_msg_count number of messages in the list
678: -- x_msg_data text of messages
679: -- p_delivery_info Attributes for the delivery entity

Line 697: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

693: x_msg_count OUT NOCOPY NUMBER,
694: x_msg_data OUT NOCOPY VARCHAR2,
695: p_action_code IN VARCHAR2,
696: p_delivery_info IN OUT NOCOPY Delivery_Pub_Rec_Type,
697: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
698: x_delivery_id OUT NOCOPY NUMBER,
699: x_name OUT NOCOPY VARCHAR2)
700:
701: IS

Line 714: l_commit VARCHAR2(100) := FND_API.G_FALSE;

710: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;
711: l_delivery_in_rec wsh_deliveries_grp.Del_In_Rec_Type;
712: l_del_out_rec_tab wsh_deliveries_grp.Del_Out_Tbl_Type;
713: l_return_status VARCHAR2(1);
714: l_commit VARCHAR2(100) := FND_API.G_FALSE;
715: --
716: l_debug_on BOOLEAN;
717: --
718: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_DELIVERY_PUB';

Line 734: IF NOT FND_API.Compatible_API_Call

730: IF l_debug_on THEN
731: wsh_debug_sv.push(l_module_name);
732: END IF;
733: -- Standard call to check for call compatibility
734: IF NOT FND_API.Compatible_API_Call
735: ( l_api_version_number
736: , p_api_version_number
737: , l_api_name
738: , G_PKG_NAME

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

737: , l_api_name
738: , G_PKG_NAME
739: )
740: THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
744: -- Initialize message stack if required
745: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 745: IF FND_API.to_Boolean(p_init_msg_list) THEN

741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
744: -- Initialize message stack if required
745: IF FND_API.to_Boolean(p_init_msg_list) THEN
746: FND_MSG_PUB.initialize;
747: END IF;
748:
749:

Line 751: IF (p_delivery_name IS NOT NULL) OR (p_delivery_name <> FND_API.G_MISS_CHAR) THEN

747: END IF;
748:
749:
750: IF (p_action_code = 'UPDATE') THEN
751: IF (p_delivery_name IS NOT NULL) OR (p_delivery_name <> FND_API.G_MISS_CHAR) THEN
752: p_delivery_info.name := p_delivery_name;
753: END IF;
754: ELSIF ( p_action_code <> 'CREATE' ) THEN
755: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');

Line 792: -- treating non passed parameters as FND_API.G_MISS_NUM

788: x_num_errors => l_num_errors,
789: x_num_warnings => l_num_warnings);
790: --
791: -- bug 3666967 : else if p_action_code is 'CREATE'
792: -- treating non passed parameters as FND_API.G_MISS_NUM
793: ELSIF (p_action_code = 'CREATE') THEN
794: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND
795: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND
796: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN

Line 794: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND

790: --
791: -- bug 3666967 : else if p_action_code is 'CREATE'
792: -- treating non passed parameters as FND_API.G_MISS_NUM
793: ELSIF (p_action_code = 'CREATE') THEN
794: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND
795: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND
796: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN
797: l_rec_attr_tab(1).wv_frozen_flag := 'N';
798: ELSE

Line 795: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND

791: -- bug 3666967 : else if p_action_code is 'CREATE'
792: -- treating non passed parameters as FND_API.G_MISS_NUM
793: ELSIF (p_action_code = 'CREATE') THEN
794: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND
795: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND
796: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN
797: l_rec_attr_tab(1).wv_frozen_flag := 'N';
798: ELSE
799: l_rec_attr_tab(1).wv_frozen_flag := 'Y';

Line 796: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN

792: -- treating non passed parameters as FND_API.G_MISS_NUM
793: ELSIF (p_action_code = 'CREATE') THEN
794: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND
795: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND
796: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN
797: l_rec_attr_tab(1).wv_frozen_flag := 'N';
798: ELSE
799: l_rec_attr_tab(1).wv_frozen_flag := 'Y';
800: END IF;

Line 850: WHEN FND_API.G_EXC_ERROR THEN

846: WSH_DEBUG_SV.pop(l_module_name);
847: END IF;
848: --
849: EXCEPTION
850: WHEN FND_API.G_EXC_ERROR THEN
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: -- Get message count and data
853: FND_MSG_PUB.Count_And_Get
854: ( p_count => x_msg_count

Line 851: x_return_status := FND_API.G_RET_STS_ERROR;

847: END IF;
848: --
849: EXCEPTION
850: WHEN FND_API.G_EXC_ERROR THEN
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: -- Get message count and data
853: FND_MSG_PUB.Count_And_Get
854: ( p_count => x_msg_count
855: , p_data => x_msg_data

Line 860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

856: );
857: --
858: IF l_debug_on THEN
859: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
861: END IF;
862: --
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

859: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
861: END IF;
862: --
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
865: -- Get message count and data
866: FND_MSG_PUB.Count_And_Get
867: ( p_count => x_msg_count

Line 864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
861: END IF;
862: --
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
865: -- Get message count and data
866: FND_MSG_PUB.Count_And_Get
867: ( p_count => x_msg_count
868: , p_data => x_msg_data

Line 873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

869: );
870: --
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
874: END IF;
875: --
876: WHEN OTHERS THEN
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
874: END IF;
875: --
876: WHEN OTHERS THEN
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
878: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: FND_MSG_PUB.Add_Exc_Msg
881: ( G_PKG_NAME

Line 958: l_commit VARCHAR2(100) := FND_API.G_FALSE;

954: l_num_errors NUMBER := 0;
955: l_num_warnings NUMBER := 0;
956: l_return_status VARCHAR2(1);
957: l_first NUMBER := 0;
958: l_commit VARCHAR2(100) := FND_API.G_FALSE;
959: --
960: BEGIN
961: --
962: --

Line 975: IF NOT FND_API.Compatible_API_Call

971: wsh_debug_sv.push(l_module_name);
972: END IF;
973: --
974: -- Standard call to check for call compatibility
975: IF NOT FND_API.Compatible_API_Call
976: ( l_api_version_number
977: , p_api_version_number
978: , l_api_name
979: , G_PKG_NAME

Line 982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

978: , l_api_name
979: , G_PKG_NAME
980: )
981: THEN
982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983: END IF;
984:
985: -- Initialize message stack if required
986: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 986: IF FND_API.to_Boolean(p_init_msg_list) THEN

982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
983: END IF;
984:
985: -- Initialize message stack if required
986: IF FND_API.to_Boolean(p_init_msg_list) THEN
987: FND_MSG_PUB.initialize;
988: END IF;
989:
990: wsh_util_validate.validate_delivery_name(

Line 1088: WHEN FND_API.G_EXC_ERROR THEN

1084: WSH_DEBUG_SV.pop(l_module_name);
1085: END IF;
1086: --
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: -- Get message count and data
1091: FND_MSG_PUB.Count_And_Get
1092: ( p_count => x_msg_count

Line 1089: x_return_status := FND_API.G_RET_STS_ERROR;

1085: END IF;
1086: --
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: x_return_status := FND_API.G_RET_STS_ERROR;
1090: -- Get message count and data
1091: FND_MSG_PUB.Count_And_Get
1092: ( p_count => x_msg_count
1093: , p_data => x_msg_data

Line 1098: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1094: );
1095: --
1096: IF l_debug_on THEN
1097: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1098: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1099: END IF;
1100: --
1101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1097: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1098: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1099: END IF;
1100: --
1101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1103: -- Get message count and data
1104: FND_MSG_PUB.Count_And_Get
1105: ( p_count => x_msg_count

Line 1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1098: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1099: END IF;
1100: --
1101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1103: -- Get message count and data
1104: FND_MSG_PUB.Count_And_Get
1105: ( p_count => x_msg_count
1106: , p_data => x_msg_data

Line 1111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1107: );
1108: --
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1112: END IF;
1113: --
1114: WHEN OTHERS THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1112: END IF;
1113: --
1114: WHEN OTHERS THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1116: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1117: THEN
1118: FND_MSG_PUB.Add_Exc_Msg
1119: ( G_PKG_NAME

Line 1321: WHEN FND_API.G_EXC_ERROR THEN

1317: END IF;
1318:
1319: -- Exception Handling Block
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.Logmsg(l_module_name,
1325: 'Expected error occured. Oracle error message is ' || SQLERRM,

Line 1322: x_return_status := FND_API.G_RET_STS_ERROR;

1318:
1319: -- Exception Handling Block
1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.Logmsg(l_module_name,
1325: 'Expected error occured. Oracle error message is ' || SQLERRM,
1326: WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1327: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');

1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.Logmsg(l_module_name,
1325: 'Expected error occured. Oracle error message is ' || SQLERRM,
1326: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1327: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');
1328: END IF;
1329: FND_MSG_PUB.Count_And_Get(
1330: p_count => x_msg_count,
1331: p_data => x_msg_data );

Line 1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1329: FND_MSG_PUB.Count_And_Get(
1330: p_count => x_msg_count,
1331: p_data => x_msg_data );
1332:
1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.Logmsg(l_module_name,
1337: 'Unexpected error occured. Oracle error message is ' || SQLERRM,

Line 1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1330: p_count => x_msg_count,
1331: p_data => x_msg_data );
1332:
1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.Logmsg(l_module_name,
1337: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1338: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1339: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');

1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.Logmsg(l_module_name,
1337: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1338: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1339: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');
1340: END IF;
1341: FND_MSG_PUB.Count_And_Get(
1342: p_count => x_msg_count,
1343: p_data => x_msg_data );