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 200: IF (p_delivery_info.delivery_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN

196: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
197:
198: IF (p_action_code <> 'CREATE') THEN
199:
200: IF (p_delivery_info.delivery_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN
201:
202: IF (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN
203: p_delivery_info.delivery_id := NULL;
204: END IF;

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

198: IF (p_action_code <> 'CREATE') THEN
199:
200: IF (p_delivery_info.delivery_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.name <> FND_API.G_MISS_CHAR) THEN
201:
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(

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

215: END IF;
216:
217: END IF;
218:
219: IF (p_delivery_info.organization_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN
220:
221: IF (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN
222: p_delivery_info.organization_id := NULL;
223: END IF;

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

217: END IF;
218:
219: IF (p_delivery_info.organization_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.organization_code <> FND_API.G_MISS_CHAR) THEN
220:
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(

Line 240: 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

236: p_delivery_info.delivery_type := 'STANDARD';
237:
238: END IF;
239:
240: 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
241:
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;

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

238: END IF;
239:
240: 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
241:
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(

Line 256: 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

252: RETURN;
253: END IF;
254: END IF;
255:
256: 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
257:
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;

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

254: END IF;
255:
256: 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
257:
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(

Line 272: 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

268: RETURN;
269: END IF;
270: END IF;
271:
272: 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
273:
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;

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

270: END IF;
271:
272: 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
273:
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(

Line 288: 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

284: RETURN;
285: END IF;
286: END IF;
287:
288: 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
289:
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;

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

286: END IF;
287:
288: 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
289:
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(

Line 304: 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

300: RETURN;
301: END IF;
302: END IF;
303:
304: 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
305:
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;

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

302: END IF;
303:
304: 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
305:
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(

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

316: RETURN;
317: END IF;
318: END IF;
319:
320: IF (p_delivery_info.customer_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN
321:
322: IF (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN
323: p_delivery_info.customer_id := NULL;
324: END IF;

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

318: END IF;
319:
320: IF (p_delivery_info.customer_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.customer_number <> FND_API.G_MISS_CHAR) THEN
321:
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(

Line 338: 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

334: END IF;
335:
336: -- Carrier ID is not validated as it is not used...Ship method is used instead.
337:
338: 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
339:
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;

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

336: -- Carrier ID is not validated as it is not used...Ship method is used instead.
337:
338: 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
339:
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(

Line 354: 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

350: RETURN;
351: END IF;
352: END IF;
353:
354: 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
355:
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;

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

352: END IF;
353:
354: 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
355:
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(

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

366: RETURN;
367: END IF;
368: END IF;
369:
370: IF (p_delivery_info.fob_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN
371:
372: IF (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN
373: p_delivery_info.fob_code := NULL;
374: END IF;

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

368: END IF;
369:
370: IF (p_delivery_info.fob_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.fob_name <> FND_API.G_MISS_CHAR) THEN
371:
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(

Line 386: 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

382: RETURN;
383: END IF;
384: END IF;
385:
386: 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
387:
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;

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

384: END IF;
385:
386: 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
387:
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(

Line 402: 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

398: RETURN;
399: END IF;
400: END IF;
401:
402: 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
403:
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;

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

400: END IF;
401:
402: 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
403:
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(

Line 420: 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

416: RETURN;
417: END IF;
418: END IF;
419:
420: 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
421:
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;

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

418: END IF;
419:
420: 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
421:
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(

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

434: RETURN;
435: END IF;
436: END IF;
437:
438: IF (p_delivery_info.currency_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN
439:
440: IF (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN
441: p_delivery_info.currency_code := NULL;
442: END IF;

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

436: END IF;
437:
438: IF (p_delivery_info.currency_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN
439:
440: IF (p_delivery_info.currency_name <> FND_API.G_MISS_CHAR) THEN
441: p_delivery_info.currency_code := NULL;
442: END IF;
443:
444: -- OTM R12, glog project changes, to use name value notation

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

459: -- manifesting code changes
460: -- disallow update of ship method or its components if the delivery is assigned to trip.
461: --
462:
463: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR
464: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
465: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
466: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
467:

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

460: -- disallow update of ship method or its components if the delivery is assigned to trip.
461: --
462:
463: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR
464: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
465: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
466: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
467:
468: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip

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

461: --
462:
463: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR
464: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
465: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
466: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
467:
468: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
469: (p_delivery_id => p_delivery_info.delivery_id,

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

462:
463: IF (p_delivery_info.ship_method_code <> FND_API.G_MISS_CHAR) OR (p_delivery_info.ship_method_code IS NULL) OR
464: (p_delivery_info.carrier_id <> FND_API.G_MISS_NUM) OR (p_delivery_info.carrier_id IS NULL) OR
465: (p_delivery_info.service_level <> FND_API.G_MISS_CHAR) OR (p_delivery_info.service_level IS NULL) OR
466: (p_delivery_info.mode_of_transport <> FND_API.G_MISS_CHAR) OR (p_delivery_info.mode_of_transport IS NULL) THEN
467:
468: l_assigned_to_trip := WSH_Delivery_Validations.Del_Assigned_To_Trip
469: (p_delivery_id => p_delivery_info.delivery_id,
470: x_return_status => x_return_status);

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

644: x_pvt_rec.SHIPPING_MARKS := p_pub_rec.SHIPPING_MARKS;
645: x_pvt_rec.SERVICE_LEVEL := p_pub_rec.SERVICE_LEVEL;
646: x_pvt_rec.MODE_OF_TRANSPORT := p_pub_rec.MODE_OF_TRANSPORT;
647: x_pvt_rec.ASSIGNED_TO_FTE_TRIPS := p_pub_rec.ASSIGNED_TO_FTE_TRIPS;
648: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
649: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
650: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
651: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
652: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;

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

645: x_pvt_rec.SERVICE_LEVEL := p_pub_rec.SERVICE_LEVEL;
646: x_pvt_rec.MODE_OF_TRANSPORT := p_pub_rec.MODE_OF_TRANSPORT;
647: x_pvt_rec.ASSIGNED_TO_FTE_TRIPS := p_pub_rec.ASSIGNED_TO_FTE_TRIPS;
648: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
649: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
650: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
651: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
652: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
653: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;

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

646: x_pvt_rec.MODE_OF_TRANSPORT := p_pub_rec.MODE_OF_TRANSPORT;
647: x_pvt_rec.ASSIGNED_TO_FTE_TRIPS := p_pub_rec.ASSIGNED_TO_FTE_TRIPS;
648: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
649: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
650: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
651: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
652: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
653: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;
654: x_pvt_rec.AUTO_AP_EXCLUDE_FLAG := p_pub_rec.AUTO_AP_EXCLUDE_FLAG;

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

647: x_pvt_rec.ASSIGNED_TO_FTE_TRIPS := p_pub_rec.ASSIGNED_TO_FTE_TRIPS;
648: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
649: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
650: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
651: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
652: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
653: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;
654: x_pvt_rec.AUTO_AP_EXCLUDE_FLAG := p_pub_rec.AUTO_AP_EXCLUDE_FLAG;
655: x_pvt_rec.AP_BATCH_ID := FND_API.G_MISS_NUM;

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

648: x_pvt_rec.PLANNED_FLAG := FND_API.G_MISS_CHAR;
649: x_pvt_rec.STATUS_CODE := FND_API.G_MISS_CHAR;
650: x_pvt_rec.BATCH_ID := FND_API.G_MISS_NUM;
651: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
652: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
653: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;
654: x_pvt_rec.AUTO_AP_EXCLUDE_FLAG := p_pub_rec.AUTO_AP_EXCLUDE_FLAG;
655: x_pvt_rec.AP_BATCH_ID := FND_API.G_MISS_NUM;
656: /*3667348*/

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

651: x_pvt_rec.HASH_VALUE := FND_API.G_MISS_NUM;
652: x_pvt_rec.SOURCE_HEADER_ID := FND_API.G_MISS_NUM;
653: x_pvt_rec.AUTO_SC_EXCLUDE_FLAG := p_pub_rec.AUTO_SC_EXCLUDE_FLAG;
654: x_pvt_rec.AUTO_AP_EXCLUDE_FLAG := p_pub_rec.AUTO_AP_EXCLUDE_FLAG;
655: x_pvt_rec.AP_BATCH_ID := FND_API.G_MISS_NUM;
656: /*3667348*/
657: x_pvt_rec.REASON_OF_TRANSPORT := p_pub_rec.REASON_OF_TRANSPORT;
658: x_pvt_rec.DESCRIPTION := p_pub_rec.DESCRIPTION;
659: -- Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).

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

656: /*3667348*/
657: x_pvt_rec.REASON_OF_TRANSPORT := p_pub_rec.REASON_OF_TRANSPORT;
658: x_pvt_rec.DESCRIPTION := p_pub_rec.DESCRIPTION;
659: -- Non Database field added for "Proration of weight from Delivery to delivery lines" Project(Bug#4254552).
660: IF p_pub_rec.prorate_wt_flag = FND_API.G_MISS_CHAR THEN
661: --{
662: x_pvt_rec.prorate_wt_flag := WSH_UTIL_CORE.FTE_Is_Installed ;
663: ELSIF p_pub_rec.prorate_wt_flag = 'Y' THEN
664: x_pvt_rec.prorate_wt_flag := 'Y';

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

693: --========================================================================
694: -- PROCEDURE : Create_Update_Delivery PUBLIC
695: --
696: -- PARAMETERS: p_api_version_number known api versionerror buffer
697: -- p_init_msg_list FND_API.G_TRUE to reset list
698: -- x_return_status return status
699: -- x_msg_count number of messages in the list
700: -- x_msg_data text of messages
701: -- p_delivery_info Attributes for the delivery entity

Line 719: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

715: x_msg_count OUT NOCOPY NUMBER,
716: x_msg_data OUT NOCOPY VARCHAR2,
717: p_action_code IN VARCHAR2,
718: p_delivery_info IN OUT NOCOPY Delivery_Pub_Rec_Type,
719: p_delivery_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
720: x_delivery_id OUT NOCOPY NUMBER,
721: x_name OUT NOCOPY VARCHAR2)
722:
723: IS

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

732: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;
733: l_delivery_in_rec wsh_deliveries_grp.Del_In_Rec_Type;
734: l_del_out_rec_tab wsh_deliveries_grp.Del_Out_Tbl_Type;
735: l_return_status VARCHAR2(1);
736: l_commit VARCHAR2(100) := FND_API.G_FALSE;
737: l_weight_uom_code VARCHAR2(10);
738: l_volume_uom_code VARCHAR2(10);
739: --
740: l_debug_on BOOLEAN;

Line 758: IF NOT FND_API.Compatible_API_Call

754: IF l_debug_on THEN
755: wsh_debug_sv.push(l_module_name);
756: END IF;
757: -- Standard call to check for call compatibility
758: IF NOT FND_API.Compatible_API_Call
759: ( l_api_version_number
760: , p_api_version_number
761: , l_api_name
762: , G_PKG_NAME

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761: , l_api_name
762: , G_PKG_NAME
763: )
764: THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: -- Initialize message stack if required
769: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 769: IF FND_API.to_Boolean(p_init_msg_list) THEN

765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: -- Initialize message stack if required
769: IF FND_API.to_Boolean(p_init_msg_list) THEN
770: FND_MSG_PUB.initialize;
771: END IF;
772:
773:

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

771: END IF;
772:
773:
774: IF (p_action_code = 'UPDATE') THEN
775: IF (p_delivery_name IS NOT NULL) OR (p_delivery_name <> FND_API.G_MISS_CHAR) THEN
776: p_delivery_info.name := p_delivery_name;
777: END IF;
778: ELSIF ( p_action_code <> 'CREATE' ) THEN
779: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');

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

831: END;
832: --Bug 9772252: End of changes
833:
834: -- bug 3666967 : else if p_action_code is 'CREATE'
835: -- treating non passed parameters as FND_API.G_MISS_NUM
836: ELSIF (p_action_code = 'CREATE') THEN
837: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND
838: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND
839: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN

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

833:
834: -- bug 3666967 : else if p_action_code is 'CREATE'
835: -- treating non passed parameters as FND_API.G_MISS_NUM
836: ELSIF (p_action_code = 'CREATE') THEN
837: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND
838: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND
839: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN
840: l_rec_attr_tab(1).wv_frozen_flag := 'N';
841: ELSE

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

834: -- bug 3666967 : else if p_action_code is 'CREATE'
835: -- treating non passed parameters as FND_API.G_MISS_NUM
836: ELSIF (p_action_code = 'CREATE') THEN
837: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND
838: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND
839: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN
840: l_rec_attr_tab(1).wv_frozen_flag := 'N';
841: ELSE
842: l_rec_attr_tab(1).wv_frozen_flag := 'Y';

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

835: -- treating non passed parameters as FND_API.G_MISS_NUM
836: ELSIF (p_action_code = 'CREATE') THEN
837: IF (l_rec_attr_tab(1).gross_weight = FND_API.G_MISS_NUM AND
838: l_rec_attr_tab(1).net_weight = FND_API.G_MISS_NUM AND
839: l_rec_attr_tab(1).volume = FND_API.G_MISS_NUM) THEN
840: l_rec_attr_tab(1).wv_frozen_flag := 'N';
841: ELSE
842: l_rec_attr_tab(1).wv_frozen_flag := 'Y';
843: END IF;

Line 846: IF (l_rec_attr_tab(1).ORGANIZATION_ID <> FND_API.G_MISS_NUM OR

842: l_rec_attr_tab(1).wv_frozen_flag := 'Y';
843: END IF;
844:
845: --Added for bug 8369407
846: IF (l_rec_attr_tab(1).ORGANIZATION_ID <> FND_API.G_MISS_NUM OR
847: l_rec_attr_tab(1).ORGANIZATION_CODE <> FND_API.G_MISS_CHAR
848: ) AND
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

Line 847: l_rec_attr_tab(1).ORGANIZATION_CODE <> FND_API.G_MISS_CHAR

843: END IF;
844:
845: --Added for bug 8369407
846: IF (l_rec_attr_tab(1).ORGANIZATION_ID <> FND_API.G_MISS_NUM OR
847: l_rec_attr_tab(1).ORGANIZATION_CODE <> FND_API.G_MISS_CHAR
848: ) AND
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

Line 849: (l_rec_attr_tab(1).WEIGHT_UOM_CODE = FND_API.G_MISS_CHAR OR

845: --Added for bug 8369407
846: IF (l_rec_attr_tab(1).ORGANIZATION_ID <> FND_API.G_MISS_NUM OR
847: l_rec_attr_tab(1).ORGANIZATION_CODE <> FND_API.G_MISS_CHAR
848: ) AND
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 ,

Line 850: l_rec_attr_tab(1).VOLUME_UOM_CODE = FND_API.G_MISS_CHAR

846: IF (l_rec_attr_tab(1).ORGANIZATION_ID <> FND_API.G_MISS_NUM OR
847: l_rec_attr_tab(1).ORGANIZATION_CODE <> FND_API.G_MISS_CHAR
848: ) AND
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 ,

Line 878: IF l_rec_attr_tab(1).WEIGHT_UOM_CODE = FND_API.G_MISS_CHAR THEN

874: wsh_util_core.api_post_call(p_return_status => l_return_status,
875: x_num_errors => l_num_errors,
876: x_num_warnings => l_num_warnings );
877: --
878: IF l_rec_attr_tab(1).WEIGHT_UOM_CODE = FND_API.G_MISS_CHAR THEN
879: l_rec_attr_tab(1).WEIGHT_UOM_CODE := l_weight_uom_code ;
880: END IF;
881: --
882: IF l_rec_attr_tab(1).VOLUME_UOM_CODE = FND_API.G_MISS_CHAR THEN

Line 882: IF l_rec_attr_tab(1).VOLUME_UOM_CODE = FND_API.G_MISS_CHAR THEN

878: IF l_rec_attr_tab(1).WEIGHT_UOM_CODE = FND_API.G_MISS_CHAR THEN
879: l_rec_attr_tab(1).WEIGHT_UOM_CODE := l_weight_uom_code ;
880: END IF;
881: --
882: IF l_rec_attr_tab(1).VOLUME_UOM_CODE = FND_API.G_MISS_CHAR THEN
883: l_rec_attr_tab(1).VOLUME_UOM_CODE := l_volume_uom_code ;
884: END IF;
885: --
886: END IF;

Line 937: WHEN FND_API.G_EXC_ERROR THEN

933: WSH_DEBUG_SV.pop(l_module_name);
934: END IF;
935: --
936: EXCEPTION
937: WHEN FND_API.G_EXC_ERROR THEN
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: -- Get message count and data
940: FND_MSG_PUB.Count_And_Get
941: ( p_count => x_msg_count

Line 938: x_return_status := FND_API.G_RET_STS_ERROR;

934: END IF;
935: --
936: EXCEPTION
937: WHEN FND_API.G_EXC_ERROR THEN
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: -- Get message count and data
940: FND_MSG_PUB.Count_And_Get
941: ( p_count => x_msg_count
942: , p_data => x_msg_data

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

943: );
944: --
945: IF l_debug_on THEN
946: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
948: END IF;
949: --
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

946: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
948: END IF;
949: --
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: -- Get message count and data
953: FND_MSG_PUB.Count_And_Get
954: ( p_count => x_msg_count

Line 951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
948: END IF;
949: --
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: -- Get message count and data
953: FND_MSG_PUB.Count_And_Get
954: ( p_count => x_msg_count
955: , p_data => x_msg_data

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

956: );
957: --
958: IF l_debug_on THEN
959: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
960: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
961: END IF;
962: --
963: WHEN OTHERS THEN
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

960: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
961: END IF;
962: --
963: WHEN OTHERS THEN
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
965: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
966: THEN
967: FND_MSG_PUB.Add_Exc_Msg
968: ( G_PKG_NAME

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

1041: l_num_errors NUMBER := 0;
1042: l_num_warnings NUMBER := 0;
1043: l_return_status VARCHAR2(1);
1044: l_first NUMBER := 0;
1045: l_commit VARCHAR2(100) := FND_API.G_FALSE;
1046: --
1047: BEGIN
1048: --
1049: --

Line 1062: IF NOT FND_API.Compatible_API_Call

1058: wsh_debug_sv.push(l_module_name);
1059: END IF;
1060: --
1061: -- Standard call to check for call compatibility
1062: IF NOT FND_API.Compatible_API_Call
1063: ( l_api_version_number
1064: , p_api_version_number
1065: , l_api_name
1066: , G_PKG_NAME

Line 1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1065: , l_api_name
1066: , G_PKG_NAME
1067: )
1068: THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;
1071:
1072: -- Initialize message stack if required
1073: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1073: IF FND_API.to_Boolean(p_init_msg_list) THEN

1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: END IF;
1071:
1072: -- Initialize message stack if required
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(

Line 1175: WHEN FND_API.G_EXC_ERROR THEN

1171: WSH_DEBUG_SV.pop(l_module_name);
1172: END IF;
1173: --
1174: EXCEPTION
1175: WHEN FND_API.G_EXC_ERROR THEN
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: -- Get message count and data
1178: FND_MSG_PUB.Count_And_Get
1179: ( p_count => x_msg_count

Line 1176: x_return_status := FND_API.G_RET_STS_ERROR;

1172: END IF;
1173: --
1174: EXCEPTION
1175: WHEN FND_API.G_EXC_ERROR THEN
1176: x_return_status := FND_API.G_RET_STS_ERROR;
1177: -- Get message count and data
1178: FND_MSG_PUB.Count_And_Get
1179: ( p_count => x_msg_count
1180: , p_data => x_msg_data

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

1181: );
1182: --
1183: IF l_debug_on THEN
1184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1186: END IF;
1187: --
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1186: END IF;
1187: --
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1190: -- Get message count and data
1191: FND_MSG_PUB.Count_And_Get
1192: ( p_count => x_msg_count

Line 1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1186: END IF;
1187: --
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1190: -- Get message count and data
1191: FND_MSG_PUB.Count_And_Get
1192: ( p_count => x_msg_count
1193: , p_data => x_msg_data

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

1194: );
1195: --
1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1199: END IF;
1200: --
1201: WHEN OTHERS THEN
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1199: END IF;
1200: --
1201: WHEN OTHERS THEN
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1203: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1204: THEN
1205: FND_MSG_PUB.Add_Exc_Msg
1206: ( G_PKG_NAME

Line 1408: WHEN FND_API.G_EXC_ERROR THEN

1404: END IF;
1405:
1406: -- Exception Handling Block
1407: EXCEPTION
1408: WHEN FND_API.G_EXC_ERROR THEN
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.Logmsg(l_module_name,
1412: 'Expected error occured. Oracle error message is ' || SQLERRM,

Line 1409: x_return_status := FND_API.G_RET_STS_ERROR;

1405:
1406: -- Exception Handling Block
1407: EXCEPTION
1408: WHEN FND_API.G_EXC_ERROR THEN
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.Logmsg(l_module_name,
1412: 'Expected error occured. Oracle error message is ' || SQLERRM,
1413: WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.Logmsg(l_module_name,
1412: 'Expected error occured. Oracle error message is ' || SQLERRM,
1413: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1414: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');
1415: END IF;
1416: FND_MSG_PUB.Count_And_Get(
1417: p_count => x_msg_count,
1418: p_data => x_msg_data );

Line 1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1416: FND_MSG_PUB.Count_And_Get(
1417: p_count => x_msg_count,
1418: p_data => x_msg_data );
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.Logmsg(l_module_name,
1424: 'Unexpected error occured. Oracle error message is ' || SQLERRM,

Line 1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1417: p_count => x_msg_count,
1418: p_data => x_msg_data );
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.Logmsg(l_module_name,
1424: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1425: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.Logmsg(l_module_name,
1424: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1425: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1426: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');
1427: END IF;
1428: FND_MSG_PUB.Count_And_Get(
1429: p_count => x_msg_count,
1430: p_data => x_msg_data );