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

Line 43: IF (p_freight_cost_type <> FND_API.G_MISS_CHAR) THEN

39: --
40: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
41:
42: IF (x_freight_cost_type_id IS NULL) THEN
43: IF (p_freight_cost_type <> FND_API.G_MISS_CHAR) THEN
44: SELECT freight_cost_type_id INTO x_freight_cost_type_id
45: FROM wsh_freight_cost_types
46: WHERE name = p_freight_cost_type;
47: IF (SQL%NOTFOUND) THEN

Line 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

141: END IF;
142: --
143: EXCEPTION
144: WHEN OTHERS THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
147: FND_MSG_PUB.Add_Exc_Msg (
148: G_PKG_NAME,
149: '_x_'

Line 365: x_return_status := FND_API.G_RET_STS_SUCCESS;

361: WSH_DEBUG_SV.push(l_module_name);
362: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id',p_freight_rec.freight_cost_id);
363: END IF;
364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: IF p_action = 'UPDATE' THEN
368: IF p_freight_rec.freight_cost_id <> FND_API.G_MISS_NUM THEN -- Added for Bug 13590798
369: OPEN c_tbl_rec;

Line 368: IF p_freight_rec.freight_cost_id <> FND_API.G_MISS_NUM THEN -- Added for Bug 13590798

364:
365: x_return_status := FND_API.G_RET_STS_SUCCESS;
366:
367: IF p_action = 'UPDATE' THEN
368: IF p_freight_rec.freight_cost_id <> FND_API.G_MISS_NUM THEN -- Added for Bug 13590798
369: OPEN c_tbl_rec;
370: FETCH c_tbl_rec INTO x_freight_rec;
371: IF c_tbl_rec%NOTFOUND THEN
372: CLOSE c_tbl_rec;

Line 390: IF NOT(nvl(p_freight_rec.conversion_type_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR ) THEN

386: -- Found a regression of the bug 8736256 while working in TPW FP bug
387: -- Moving the fix done has a part of bug 8736256 inside if loop,
388: -- validating only if conversion_type_code is not null
389: --Bug 8640930
390: IF NOT(nvl(p_freight_rec.conversion_type_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR ) THEN
391:
392: --Bugfix 8736256 Start -- Validate Conversion Type Code
393: BEGIN
394: SELECT conversion_type INTO l_conversion_type

Line 422: IF ( p_freight_rec.FREIGHT_COST_TYPE_ID <> FND_API.G_MISS_NUM ) THEN

418: x_freight_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
419: x_freight_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.USER_ID;
420:
421:
422: IF ( p_freight_rec.FREIGHT_COST_TYPE_ID <> FND_API.G_MISS_NUM ) THEN
423: x_freight_rec.FREIGHT_COST_TYPE_ID := p_freight_rec.FREIGHT_COST_TYPE_ID;
424: END IF;
425: IF ( p_freight_rec.UNIT_AMOUNT <> FND_API.G_MISS_NUM
426: OR p_freight_rec.UNIT_AMOUNT IS NULL ) THEN

Line 425: IF ( p_freight_rec.UNIT_AMOUNT <> FND_API.G_MISS_NUM

421:
422: IF ( p_freight_rec.FREIGHT_COST_TYPE_ID <> FND_API.G_MISS_NUM ) THEN
423: x_freight_rec.FREIGHT_COST_TYPE_ID := p_freight_rec.FREIGHT_COST_TYPE_ID;
424: END IF;
425: IF ( p_freight_rec.UNIT_AMOUNT <> FND_API.G_MISS_NUM
426: OR p_freight_rec.UNIT_AMOUNT IS NULL ) THEN
427: x_freight_rec.UNIT_AMOUNT:= p_freight_rec.UNIT_AMOUNT;
428: END IF;
429: IF ( p_freight_rec.CALCULATION_METHOD <> FND_API.G_MISS_CHAR

Line 429: IF ( p_freight_rec.CALCULATION_METHOD <> FND_API.G_MISS_CHAR

425: IF ( p_freight_rec.UNIT_AMOUNT <> FND_API.G_MISS_NUM
426: OR p_freight_rec.UNIT_AMOUNT IS NULL ) THEN
427: x_freight_rec.UNIT_AMOUNT:= p_freight_rec.UNIT_AMOUNT;
428: END IF;
429: IF ( p_freight_rec.CALCULATION_METHOD <> FND_API.G_MISS_CHAR
430: OR p_freight_rec.CALCULATION_METHOD IS NULL ) THEN
431: x_freight_rec.CALCULATION_METHOD:= p_freight_rec.CALCULATION_METHOD;
432: END IF;
433: IF ( p_freight_rec.UOM <> FND_API.G_MISS_CHAR

Line 433: IF ( p_freight_rec.UOM <> FND_API.G_MISS_CHAR

429: IF ( p_freight_rec.CALCULATION_METHOD <> FND_API.G_MISS_CHAR
430: OR p_freight_rec.CALCULATION_METHOD IS NULL ) THEN
431: x_freight_rec.CALCULATION_METHOD:= p_freight_rec.CALCULATION_METHOD;
432: END IF;
433: IF ( p_freight_rec.UOM <> FND_API.G_MISS_CHAR
434: OR p_freight_rec.UOM IS NULL ) THEN
435: x_freight_rec.UOM:= p_freight_rec.UOM;
436: END IF;
437: IF ( p_freight_rec.QUANTITY <> FND_API.G_MISS_NUM

Line 437: IF ( p_freight_rec.QUANTITY <> FND_API.G_MISS_NUM

433: IF ( p_freight_rec.UOM <> FND_API.G_MISS_CHAR
434: OR p_freight_rec.UOM IS NULL ) THEN
435: x_freight_rec.UOM:= p_freight_rec.UOM;
436: END IF;
437: IF ( p_freight_rec.QUANTITY <> FND_API.G_MISS_NUM
438: OR p_freight_rec.QUANTITY IS NULL) THEN
439: x_freight_rec.QUANTITY:= p_freight_rec.QUANTITY;
440: END IF;
441: IF ( p_freight_rec.TOTAL_AMOUNT <> FND_API.G_MISS_NUM

Line 441: IF ( p_freight_rec.TOTAL_AMOUNT <> FND_API.G_MISS_NUM

437: IF ( p_freight_rec.QUANTITY <> FND_API.G_MISS_NUM
438: OR p_freight_rec.QUANTITY IS NULL) THEN
439: x_freight_rec.QUANTITY:= p_freight_rec.QUANTITY;
440: END IF;
441: IF ( p_freight_rec.TOTAL_AMOUNT <> FND_API.G_MISS_NUM
442: OR p_freight_rec.TOTAL_AMOUNT IS NULL) THEN
443: x_freight_rec.TOTAL_AMOUNT:= p_freight_rec.TOTAL_AMOUNT;
444: END IF;
445: IF ( p_freight_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR

Line 445: IF ( p_freight_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR

441: IF ( p_freight_rec.TOTAL_AMOUNT <> FND_API.G_MISS_NUM
442: OR p_freight_rec.TOTAL_AMOUNT IS NULL) THEN
443: x_freight_rec.TOTAL_AMOUNT:= p_freight_rec.TOTAL_AMOUNT;
444: END IF;
445: IF ( p_freight_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR
446: OR p_freight_rec.CURRENCY_CODE IS NULL) THEN
447: x_freight_rec.CURRENCY_CODE:= p_freight_rec.CURRENCY_CODE;
448: END IF;
449: IF ( p_freight_rec.CONVERSION_RATE <> FND_API.G_MISS_NUM

Line 449: IF ( p_freight_rec.CONVERSION_RATE <> FND_API.G_MISS_NUM

445: IF ( p_freight_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR
446: OR p_freight_rec.CURRENCY_CODE IS NULL) THEN
447: x_freight_rec.CURRENCY_CODE:= p_freight_rec.CURRENCY_CODE;
448: END IF;
449: IF ( p_freight_rec.CONVERSION_RATE <> FND_API.G_MISS_NUM
450: OR p_freight_rec.CONVERSION_RATE IS NULL) THEN
451: x_freight_rec.CONVERSION_RATE:= p_freight_rec.CONVERSION_RATE;
452: END IF;
453: IF ( p_freight_rec.TRIP_ID <> FND_API.G_MISS_NUM

Line 453: IF ( p_freight_rec.TRIP_ID <> FND_API.G_MISS_NUM

449: IF ( p_freight_rec.CONVERSION_RATE <> FND_API.G_MISS_NUM
450: OR p_freight_rec.CONVERSION_RATE IS NULL) THEN
451: x_freight_rec.CONVERSION_RATE:= p_freight_rec.CONVERSION_RATE;
452: END IF;
453: IF ( p_freight_rec.TRIP_ID <> FND_API.G_MISS_NUM
454: OR p_freight_rec.TRIP_ID IS NULL) THEN
455: x_freight_rec.TRIP_ID:= p_freight_rec.TRIP_ID;
456: END IF;
457:

Line 458: IF ( p_freight_rec.STOP_ID <> FND_API.G_MISS_NUM

454: OR p_freight_rec.TRIP_ID IS NULL) THEN
455: x_freight_rec.TRIP_ID:= p_freight_rec.TRIP_ID;
456: END IF;
457:
458: IF ( p_freight_rec.STOP_ID <> FND_API.G_MISS_NUM
459: OR p_freight_rec.STOP_ID IS NULL) THEN
460: x_freight_rec.STOP_ID:= p_freight_rec.STOP_ID;
461: END IF;
462:

Line 463: IF ( p_freight_rec.DELIVERY_ID <> FND_API.G_MISS_NUM

459: OR p_freight_rec.STOP_ID IS NULL) THEN
460: x_freight_rec.STOP_ID:= p_freight_rec.STOP_ID;
461: END IF;
462:
463: IF ( p_freight_rec.DELIVERY_ID <> FND_API.G_MISS_NUM
464: OR p_freight_rec.DELIVERY_ID IS NULL) THEN
465: x_freight_rec.DELIVERY_ID:= p_freight_rec.DELIVERY_ID;
466: END IF;
467:

Line 468: IF ( p_freight_rec.DELIVERY_LEG_ID <> FND_API.G_MISS_NUM

464: OR p_freight_rec.DELIVERY_ID IS NULL) THEN
465: x_freight_rec.DELIVERY_ID:= p_freight_rec.DELIVERY_ID;
466: END IF;
467:
468: IF ( p_freight_rec.DELIVERY_LEG_ID <> FND_API.G_MISS_NUM
469: OR p_freight_rec.DELIVERY_LEG_ID IS NULL) THEN
470: x_freight_rec.DELIVERY_LEG_ID:= p_freight_rec.DELIVERY_LEG_ID;
471: END IF;
472: IF ( p_freight_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM

Line 472: IF ( p_freight_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM

468: IF ( p_freight_rec.DELIVERY_LEG_ID <> FND_API.G_MISS_NUM
469: OR p_freight_rec.DELIVERY_LEG_ID IS NULL) THEN
470: x_freight_rec.DELIVERY_LEG_ID:= p_freight_rec.DELIVERY_LEG_ID;
471: END IF;
472: IF ( p_freight_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM
473: OR p_freight_rec.DELIVERY_DETAIL_ID IS NULL) THEN
474: x_freight_rec.DELIVERY_DETAIL_ID:= p_freight_rec.DELIVERY_DETAIL_ID;
475: END IF;
476: IF ( p_freight_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR

Line 476: IF ( p_freight_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR

472: IF ( p_freight_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM
473: OR p_freight_rec.DELIVERY_DETAIL_ID IS NULL) THEN
474: x_freight_rec.DELIVERY_DETAIL_ID:= p_freight_rec.DELIVERY_DETAIL_ID;
475: END IF;
476: IF ( p_freight_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
477: OR p_freight_rec.ATTRIBUTE_CATEGORY IS NULL) THEN
478: x_freight_rec.ATTRIBUTE_CATEGORY:= p_freight_rec.ATTRIBUTE_CATEGORY;
479: END IF;
480: IF ( p_freight_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR

Line 480: IF ( p_freight_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR

476: IF ( p_freight_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
477: OR p_freight_rec.ATTRIBUTE_CATEGORY IS NULL) THEN
478: x_freight_rec.ATTRIBUTE_CATEGORY:= p_freight_rec.ATTRIBUTE_CATEGORY;
479: END IF;
480: IF ( p_freight_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
481: OR p_freight_rec.ATTRIBUTE1 IS NULL) THEN
482: x_freight_rec.ATTRIBUTE1:= p_freight_rec.ATTRIBUTE1;
483: END IF;
484: IF ( p_freight_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR

Line 484: IF ( p_freight_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR

480: IF ( p_freight_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
481: OR p_freight_rec.ATTRIBUTE1 IS NULL) THEN
482: x_freight_rec.ATTRIBUTE1:= p_freight_rec.ATTRIBUTE1;
483: END IF;
484: IF ( p_freight_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
485: OR p_freight_rec.ATTRIBUTE2 IS NULL) THEN
486: x_freight_rec.ATTRIBUTE2:= p_freight_rec.ATTRIBUTE2;
487: END IF;
488: IF ( p_freight_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR

Line 488: IF ( p_freight_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR

484: IF ( p_freight_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
485: OR p_freight_rec.ATTRIBUTE2 IS NULL) THEN
486: x_freight_rec.ATTRIBUTE2:= p_freight_rec.ATTRIBUTE2;
487: END IF;
488: IF ( p_freight_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
489: OR p_freight_rec.ATTRIBUTE3 IS NULL) THEN
490: x_freight_rec.ATTRIBUTE3:= p_freight_rec.ATTRIBUTE3;
491: END IF;
492: IF ( p_freight_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR

Line 492: IF ( p_freight_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR

488: IF ( p_freight_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
489: OR p_freight_rec.ATTRIBUTE3 IS NULL) THEN
490: x_freight_rec.ATTRIBUTE3:= p_freight_rec.ATTRIBUTE3;
491: END IF;
492: IF ( p_freight_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
493: OR p_freight_rec.ATTRIBUTE4 IS NULL) THEN
494: x_freight_rec.ATTRIBUTE4:= p_freight_rec.ATTRIBUTE4;
495: END IF;
496: IF ( p_freight_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR

Line 496: IF ( p_freight_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR

492: IF ( p_freight_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
493: OR p_freight_rec.ATTRIBUTE4 IS NULL) THEN
494: x_freight_rec.ATTRIBUTE4:= p_freight_rec.ATTRIBUTE4;
495: END IF;
496: IF ( p_freight_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
497: OR p_freight_rec.ATTRIBUTE5 IS NULL) THEN
498: x_freight_rec.ATTRIBUTE5:= p_freight_rec.ATTRIBUTE5;
499: END IF;
500: IF ( p_freight_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR

Line 500: IF ( p_freight_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR

496: IF ( p_freight_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
497: OR p_freight_rec.ATTRIBUTE5 IS NULL) THEN
498: x_freight_rec.ATTRIBUTE5:= p_freight_rec.ATTRIBUTE5;
499: END IF;
500: IF ( p_freight_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
501: OR p_freight_rec.ATTRIBUTE6 IS NULL) THEN
502: x_freight_rec.ATTRIBUTE6:= p_freight_rec.ATTRIBUTE6;
503: END IF;
504: IF ( p_freight_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR

Line 504: IF ( p_freight_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR

500: IF ( p_freight_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
501: OR p_freight_rec.ATTRIBUTE6 IS NULL) THEN
502: x_freight_rec.ATTRIBUTE6:= p_freight_rec.ATTRIBUTE6;
503: END IF;
504: IF ( p_freight_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
505: OR p_freight_rec.ATTRIBUTE7 IS NULL) THEN
506: x_freight_rec.ATTRIBUTE7:= p_freight_rec.ATTRIBUTE7;
507: END IF;
508: IF ( p_freight_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR

Line 508: IF ( p_freight_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR

504: IF ( p_freight_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
505: OR p_freight_rec.ATTRIBUTE7 IS NULL) THEN
506: x_freight_rec.ATTRIBUTE7:= p_freight_rec.ATTRIBUTE7;
507: END IF;
508: IF ( p_freight_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
509: OR p_freight_rec.ATTRIBUTE8 IS NULL) THEN
510: x_freight_rec.ATTRIBUTE8:= p_freight_rec.ATTRIBUTE8;
511: END IF;
512: IF ( p_freight_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR

Line 512: IF ( p_freight_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR

508: IF ( p_freight_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
509: OR p_freight_rec.ATTRIBUTE8 IS NULL) THEN
510: x_freight_rec.ATTRIBUTE8:= p_freight_rec.ATTRIBUTE8;
511: END IF;
512: IF ( p_freight_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
513: OR p_freight_rec.ATTRIBUTE9 IS NULL) THEN
514: x_freight_rec.ATTRIBUTE9:= p_freight_rec.ATTRIBUTE9;
515: END IF;
516: IF ( p_freight_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR

Line 516: IF ( p_freight_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR

512: IF ( p_freight_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
513: OR p_freight_rec.ATTRIBUTE9 IS NULL) THEN
514: x_freight_rec.ATTRIBUTE9:= p_freight_rec.ATTRIBUTE9;
515: END IF;
516: IF ( p_freight_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
517: OR p_freight_rec.ATTRIBUTE10 IS NULL) THEN
518: x_freight_rec.ATTRIBUTE10:= p_freight_rec.ATTRIBUTE10;
519: END IF;
520: IF ( p_freight_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR

Line 520: IF ( p_freight_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR

516: IF ( p_freight_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
517: OR p_freight_rec.ATTRIBUTE10 IS NULL) THEN
518: x_freight_rec.ATTRIBUTE10:= p_freight_rec.ATTRIBUTE10;
519: END IF;
520: IF ( p_freight_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
521: OR p_freight_rec.ATTRIBUTE11 IS NULL) THEN
522: x_freight_rec.ATTRIBUTE11:= p_freight_rec.ATTRIBUTE11;
523: END IF;
524: IF ( p_freight_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR

Line 524: IF ( p_freight_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR

520: IF ( p_freight_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
521: OR p_freight_rec.ATTRIBUTE11 IS NULL) THEN
522: x_freight_rec.ATTRIBUTE11:= p_freight_rec.ATTRIBUTE11;
523: END IF;
524: IF ( p_freight_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
525: OR p_freight_rec.ATTRIBUTE12 IS NULL) THEN
526: x_freight_rec.ATTRIBUTE12:= p_freight_rec.ATTRIBUTE12;
527: END IF;
528: IF ( p_freight_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR

Line 528: IF ( p_freight_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR

524: IF ( p_freight_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
525: OR p_freight_rec.ATTRIBUTE12 IS NULL) THEN
526: x_freight_rec.ATTRIBUTE12:= p_freight_rec.ATTRIBUTE12;
527: END IF;
528: IF ( p_freight_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
529: OR p_freight_rec.ATTRIBUTE13 IS NULL) THEN
530: x_freight_rec.ATTRIBUTE13:= p_freight_rec.ATTRIBUTE13;
531: END IF;
532: IF ( p_freight_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR

Line 532: IF ( p_freight_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR

528: IF ( p_freight_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
529: OR p_freight_rec.ATTRIBUTE13 IS NULL) THEN
530: x_freight_rec.ATTRIBUTE13:= p_freight_rec.ATTRIBUTE13;
531: END IF;
532: IF ( p_freight_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
533: OR p_freight_rec.ATTRIBUTE14 IS NULL) THEN
534: x_freight_rec.ATTRIBUTE14:= p_freight_rec.ATTRIBUTE14;
535: END IF;
536: IF ( p_freight_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR

Line 536: IF ( p_freight_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR

532: IF ( p_freight_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
533: OR p_freight_rec.ATTRIBUTE14 IS NULL) THEN
534: x_freight_rec.ATTRIBUTE14:= p_freight_rec.ATTRIBUTE14;
535: END IF;
536: IF ( p_freight_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
537: OR p_freight_rec.ATTRIBUTE15 IS NULL) THEN
538: x_freight_rec.ATTRIBUTE15:= p_freight_rec.ATTRIBUTE15;
539: END IF;
540:

Line 541: IF ( p_freight_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM

537: OR p_freight_rec.ATTRIBUTE15 IS NULL) THEN
538: x_freight_rec.ATTRIBUTE15:= p_freight_rec.ATTRIBUTE15;
539: END IF;
540:
541: IF ( p_freight_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
542: OR p_freight_rec.PROGRAM_APPLICATION_ID IS NULL) THEN
543: x_freight_rec.PROGRAM_APPLICATION_ID:= p_freight_rec.PROGRAM_APPLICATION_ID;
544: END IF;
545: IF ( p_freight_rec.PROGRAM_ID <> FND_API.G_MISS_NUM

Line 545: IF ( p_freight_rec.PROGRAM_ID <> FND_API.G_MISS_NUM

541: IF ( p_freight_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
542: OR p_freight_rec.PROGRAM_APPLICATION_ID IS NULL) THEN
543: x_freight_rec.PROGRAM_APPLICATION_ID:= p_freight_rec.PROGRAM_APPLICATION_ID;
544: END IF;
545: IF ( p_freight_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
546: OR p_freight_rec.PROGRAM_ID IS NULL) THEN
547: x_freight_rec.PROGRAM_ID:= p_freight_rec.PROGRAM_ID;
548: END IF;
549: IF ( p_freight_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE

Line 549: IF ( p_freight_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE

545: IF ( p_freight_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
546: OR p_freight_rec.PROGRAM_ID IS NULL) THEN
547: x_freight_rec.PROGRAM_ID:= p_freight_rec.PROGRAM_ID;
548: END IF;
549: IF ( p_freight_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
550: OR p_freight_rec.PROGRAM_UPDATE_DATE IS NULL) THEN
551: x_freight_rec.PROGRAM_UPDATE_DATE:= p_freight_rec.PROGRAM_UPDATE_DATE;
552: END IF;
553: IF ( p_freight_rec.REQUEST_ID <> FND_API.G_MISS_NUM

Line 553: IF ( p_freight_rec.REQUEST_ID <> FND_API.G_MISS_NUM

549: IF ( p_freight_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
550: OR p_freight_rec.PROGRAM_UPDATE_DATE IS NULL) THEN
551: x_freight_rec.PROGRAM_UPDATE_DATE:= p_freight_rec.PROGRAM_UPDATE_DATE;
552: END IF;
553: IF ( p_freight_rec.REQUEST_ID <> FND_API.G_MISS_NUM
554: OR p_freight_rec.REQUEST_ID IS NULL) THEN
555: x_freight_rec.REQUEST_ID:= p_freight_rec.REQUEST_ID;
556: END IF;
557: IF ( p_freight_rec.FREIGHT_CODE <> FND_API.G_MISS_CHAR

Line 557: IF ( p_freight_rec.FREIGHT_CODE <> FND_API.G_MISS_CHAR

553: IF ( p_freight_rec.REQUEST_ID <> FND_API.G_MISS_NUM
554: OR p_freight_rec.REQUEST_ID IS NULL) THEN
555: x_freight_rec.REQUEST_ID:= p_freight_rec.REQUEST_ID;
556: END IF;
557: IF ( p_freight_rec.FREIGHT_CODE <> FND_API.G_MISS_CHAR
558: OR p_freight_rec.FREIGHT_CODE IS NULL) THEN
559: x_freight_rec.FREIGHT_CODE:= p_freight_rec.FREIGHT_CODE;
560: END IF;
561: IF ( p_freight_rec.LINE_TYPE_CODE <> FND_API.G_MISS_CHAR

Line 561: IF ( p_freight_rec.LINE_TYPE_CODE <> FND_API.G_MISS_CHAR

557: IF ( p_freight_rec.FREIGHT_CODE <> FND_API.G_MISS_CHAR
558: OR p_freight_rec.FREIGHT_CODE IS NULL) THEN
559: x_freight_rec.FREIGHT_CODE:= p_freight_rec.FREIGHT_CODE;
560: END IF;
561: IF ( p_freight_rec.LINE_TYPE_CODE <> FND_API.G_MISS_CHAR
562: OR p_freight_rec.LINE_TYPE_CODE IS NULL) THEN
563: x_freight_rec.LINE_TYPE_CODE:= p_freight_rec.FREIGHT_CODE;
564: END IF;
565: IF ( p_freight_rec.PRICING_LIST_HEADER_ID <> FND_API.G_MISS_NUM

Line 565: IF ( p_freight_rec.PRICING_LIST_HEADER_ID <> FND_API.G_MISS_NUM

561: IF ( p_freight_rec.LINE_TYPE_CODE <> FND_API.G_MISS_CHAR
562: OR p_freight_rec.LINE_TYPE_CODE IS NULL) THEN
563: x_freight_rec.LINE_TYPE_CODE:= p_freight_rec.FREIGHT_CODE;
564: END IF;
565: IF ( p_freight_rec.PRICING_LIST_HEADER_ID <> FND_API.G_MISS_NUM
566: OR p_freight_rec.PRICING_LIST_HEADER_ID IS NULL) THEN
567: x_freight_rec.PRICING_LIST_HEADER_ID:= p_freight_rec.PRICING_LIST_HEADER_ID;
568: END IF;
569: IF ( p_freight_rec.PRICING_LIST_LINE_ID <> FND_API.G_MISS_NUM

Line 569: IF ( p_freight_rec.PRICING_LIST_LINE_ID <> FND_API.G_MISS_NUM

565: IF ( p_freight_rec.PRICING_LIST_HEADER_ID <> FND_API.G_MISS_NUM
566: OR p_freight_rec.PRICING_LIST_HEADER_ID IS NULL) THEN
567: x_freight_rec.PRICING_LIST_HEADER_ID:= p_freight_rec.PRICING_LIST_HEADER_ID;
568: END IF;
569: IF ( p_freight_rec.PRICING_LIST_LINE_ID <> FND_API.G_MISS_NUM
570: OR p_freight_rec.PRICING_LIST_LINE_ID IS NULL) THEN
571: x_freight_rec.PRICING_LIST_LINE_ID:= p_freight_rec.PRICING_LIST_LINE_ID;
572: END IF;
573: IF ( p_freight_rec.APPLIED_TO_CHARGE_ID <> FND_API.G_MISS_NUM

Line 573: IF ( p_freight_rec.APPLIED_TO_CHARGE_ID <> FND_API.G_MISS_NUM

569: IF ( p_freight_rec.PRICING_LIST_LINE_ID <> FND_API.G_MISS_NUM
570: OR p_freight_rec.PRICING_LIST_LINE_ID IS NULL) THEN
571: x_freight_rec.PRICING_LIST_LINE_ID:= p_freight_rec.PRICING_LIST_LINE_ID;
572: END IF;
573: IF ( p_freight_rec.APPLIED_TO_CHARGE_ID <> FND_API.G_MISS_NUM
574: OR p_freight_rec.APPLIED_TO_CHARGE_ID IS NULL) THEN
575: x_freight_rec.APPLIED_TO_CHARGE_ID:= p_freight_rec.APPLIED_TO_CHARGE_ID;
576: END IF;
577: IF ( p_freight_rec.CHARGE_UNIT_VALUE <> FND_API.G_MISS_NUM

Line 577: IF ( p_freight_rec.CHARGE_UNIT_VALUE <> FND_API.G_MISS_NUM

573: IF ( p_freight_rec.APPLIED_TO_CHARGE_ID <> FND_API.G_MISS_NUM
574: OR p_freight_rec.APPLIED_TO_CHARGE_ID IS NULL) THEN
575: x_freight_rec.APPLIED_TO_CHARGE_ID:= p_freight_rec.APPLIED_TO_CHARGE_ID;
576: END IF;
577: IF ( p_freight_rec.CHARGE_UNIT_VALUE <> FND_API.G_MISS_NUM
578: OR p_freight_rec.CHARGE_UNIT_VALUE IS NULL) THEN
579: x_freight_rec.CHARGE_UNIT_VALUE:= p_freight_rec.CHARGE_UNIT_VALUE;
580: END IF;
581: IF ( p_freight_rec.CHARGE_SOURCE_CODE <> FND_API.G_MISS_CHAR

Line 581: IF ( p_freight_rec.CHARGE_SOURCE_CODE <> FND_API.G_MISS_CHAR

577: IF ( p_freight_rec.CHARGE_UNIT_VALUE <> FND_API.G_MISS_NUM
578: OR p_freight_rec.CHARGE_UNIT_VALUE IS NULL) THEN
579: x_freight_rec.CHARGE_UNIT_VALUE:= p_freight_rec.CHARGE_UNIT_VALUE;
580: END IF;
581: IF ( p_freight_rec.CHARGE_SOURCE_CODE <> FND_API.G_MISS_CHAR
582: OR p_freight_rec.CHARGE_SOURCE_CODE IS NULL) THEN
583: x_freight_rec.CHARGE_SOURCE_CODE:= p_freight_rec.CHARGE_SOURCE_CODE;
584: END IF;
585: IF ( p_freight_rec.ESTIMATED_FLAG <> FND_API.G_MISS_CHAR

Line 585: IF ( p_freight_rec.ESTIMATED_FLAG <> FND_API.G_MISS_CHAR

581: IF ( p_freight_rec.CHARGE_SOURCE_CODE <> FND_API.G_MISS_CHAR
582: OR p_freight_rec.CHARGE_SOURCE_CODE IS NULL) THEN
583: x_freight_rec.CHARGE_SOURCE_CODE:= p_freight_rec.CHARGE_SOURCE_CODE;
584: END IF;
585: IF ( p_freight_rec.ESTIMATED_FLAG <> FND_API.G_MISS_CHAR
586: OR p_freight_rec.ESTIMATED_FLAG IS NULL) THEN
587: x_freight_rec.ESTIMATED_FLAG:= p_freight_rec.ESTIMATED_FLAG;
588: END IF;
589: IF ( p_freight_rec.FREIGHT_COST_TYPE <> FND_API.G_MISS_CHAR

Line 589: IF ( p_freight_rec.FREIGHT_COST_TYPE <> FND_API.G_MISS_CHAR

585: IF ( p_freight_rec.ESTIMATED_FLAG <> FND_API.G_MISS_CHAR
586: OR p_freight_rec.ESTIMATED_FLAG IS NULL) THEN
587: x_freight_rec.ESTIMATED_FLAG:= p_freight_rec.ESTIMATED_FLAG;
588: END IF;
589: IF ( p_freight_rec.FREIGHT_COST_TYPE <> FND_API.G_MISS_CHAR
590: OR p_freight_rec.FREIGHT_COST_TYPE IS NULL) THEN
591: x_freight_rec.FREIGHT_COST_TYPE := p_freight_rec.FREIGHT_COST_TYPE;
592: END IF;
593: IF ( p_freight_rec.COMMODITY_CATEGORY_ID <> FND_API.G_MISS_NUM

Line 593: IF ( p_freight_rec.COMMODITY_CATEGORY_ID <> FND_API.G_MISS_NUM

589: IF ( p_freight_rec.FREIGHT_COST_TYPE <> FND_API.G_MISS_CHAR
590: OR p_freight_rec.FREIGHT_COST_TYPE IS NULL) THEN
591: x_freight_rec.FREIGHT_COST_TYPE := p_freight_rec.FREIGHT_COST_TYPE;
592: END IF;
593: IF ( p_freight_rec.COMMODITY_CATEGORY_ID <> FND_API.G_MISS_NUM
594: OR p_freight_rec.COMMODITY_CATEGORY_ID IS NULL) THEN
595: x_freight_rec.COMMODITY_CATEGORY_ID := p_freight_rec.COMMODITY_CATEGORY_ID;
596: END IF;
597:

Line 601: IF ( p_freight_rec.TRIP_NAME <> FND_API.G_MISS_CHAR

597:
598: --bug 3614196
599: --trip_name, stop_location_id, planned_dep_date, delivery_name
600: --need to copied to output record
601: IF ( p_freight_rec.TRIP_NAME <> FND_API.G_MISS_CHAR
602: OR p_freight_rec.TRIP_NAME IS NULL) THEN
603: x_freight_rec.TRIP_NAME:= p_freight_rec.TRIP_NAME;
604: END IF;
605:

Line 606: IF ( p_freight_rec.STOP_LOCATION_ID <> FND_API.G_MISS_NUM

602: OR p_freight_rec.TRIP_NAME IS NULL) THEN
603: x_freight_rec.TRIP_NAME:= p_freight_rec.TRIP_NAME;
604: END IF;
605:
606: IF ( p_freight_rec.STOP_LOCATION_ID <> FND_API.G_MISS_NUM
607: OR p_freight_rec.STOP_LOCATION_ID IS NULL) THEN
608: x_freight_rec.STOP_LOCATION_ID:= p_freight_rec.STOP_LOCATION_ID;
609: END IF;
610:

Line 611: IF ( p_freight_rec.PLANNED_DEP_DATE <> FND_API.G_MISS_DATE

607: OR p_freight_rec.STOP_LOCATION_ID IS NULL) THEN
608: x_freight_rec.STOP_LOCATION_ID:= p_freight_rec.STOP_LOCATION_ID;
609: END IF;
610:
611: IF ( p_freight_rec.PLANNED_DEP_DATE <> FND_API.G_MISS_DATE
612: OR p_freight_rec.PLANNED_DEP_DATE IS NULL) THEN
613: x_freight_rec.PLANNED_DEP_DATE:= p_freight_rec.PLANNED_DEP_DATE;
614: END IF;
615:

Line 616: IF ( p_freight_rec.DELIVERY_NAME <> FND_API.G_MISS_CHAR

612: OR p_freight_rec.PLANNED_DEP_DATE IS NULL) THEN
613: x_freight_rec.PLANNED_DEP_DATE:= p_freight_rec.PLANNED_DEP_DATE;
614: END IF;
615:
616: IF ( p_freight_rec.DELIVERY_NAME <> FND_API.G_MISS_CHAR
617: OR p_freight_rec.DELIVERY_NAME IS NULL) THEN
618: x_freight_rec.DELIVERY_NAME:= p_freight_rec.DELIVERY_NAME;
619: END IF;
620:

Line 624: IF (p_freight_rec.BILLABLE_QUANTITY <> FND_API.G_MISS_NUM

620:
621:
622: IF (p_caller IN ('FTE_RATING')) THEN
623:
624: IF (p_freight_rec.BILLABLE_QUANTITY <> FND_API.G_MISS_NUM
625: OR p_freight_rec.BILLABLE_QUANTITY IS NULL) THEN
626: x_freight_rec.BILLABLE_QUANTITY := p_freight_rec.BILLABLE_QUANTITY;
627: END IF;
628:

Line 629: IF (p_freight_rec.BILLABLE_UOM <> FND_API.G_MISS_CHAR

625: OR p_freight_rec.BILLABLE_QUANTITY IS NULL) THEN
626: x_freight_rec.BILLABLE_QUANTITY := p_freight_rec.BILLABLE_QUANTITY;
627: END IF;
628:
629: IF (p_freight_rec.BILLABLE_UOM <> FND_API.G_MISS_CHAR
630: OR p_freight_rec.BILLABLE_UOM IS NULL) THEN
631: x_freight_rec.BILLABLE_UOM := p_freight_rec.BILLABLE_UOM;
632: END IF;
633:

Line 634: IF (p_freight_rec.BILLABLE_BASIS <> FND_API.G_MISS_CHAR

630: OR p_freight_rec.BILLABLE_UOM IS NULL) THEN
631: x_freight_rec.BILLABLE_UOM := p_freight_rec.BILLABLE_UOM;
632: END IF;
633:
634: IF (p_freight_rec.BILLABLE_BASIS <> FND_API.G_MISS_CHAR
635: OR p_freight_rec.BILLABLE_BASIS IS NULL) THEN
636: x_freight_rec.BILLABLE_BASIS := p_freight_rec.BILLABLE_BASIS;
637: END IF;
638:

Line 810: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN

806: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
807: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
808: END IF;
809: --
810: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.log(l_module_name,'Not compatible');
813: END IF;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

810: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
811: IF l_debug_on THEN
812: WSH_DEBUG_SV.log(l_module_name,'Not compatible');
813: END IF;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816:
817: IF FND_API.to_Boolean(p_init_msg_list) THEN
818: FND_MSG_PUB.initialize;

Line 817: IF FND_API.to_Boolean(p_init_msg_list) THEN

813: END IF;
814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
815: END IF;
816:
817: IF FND_API.to_Boolean(p_init_msg_list) THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820:
821: IF (p_in_rec.caller IS NULL) THEN

Line 825: raise fnd_api.g_exc_error;

821: IF (p_in_rec.caller IS NULL) THEN
822: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
823: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.caller');
824: wsh_util_core.add_message(x_return_status,l_module_name);
825: raise fnd_api.g_exc_error;
826: END IF;
827: IF (nvl(p_in_rec.phase,1) <> 1) THEN
828: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
829: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.phase');

Line 831: raise fnd_api.g_exc_error;

827: IF (nvl(p_in_rec.phase,1) <> 1) THEN
828: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
829: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.phase');
830: wsh_util_core.add_message(x_return_status,l_module_name);
831: raise fnd_api.g_exc_error;
832: END IF;
833: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE') ) THEN
834: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
835: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.action_code');

Line 837: raise fnd_api.g_exc_error;

833: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE') ) THEN
834: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
835: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.action_code');
836: wsh_util_core.add_message(x_return_status,l_module_name);
837: raise fnd_api.g_exc_error;
838: END IF;
839:
840: WSH_ACTIONS_LEVELS.set_validation_level (
841: p_entity => 'FRST',

Line 971: AND (l_freight_info_tab(l_index).currency_code <>FND_API.G_MISS_CHAR)) THEN

967: p_value1 => 'conversion_rate');
968: END IF;
969:
970: IF ((WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL)=1)
971: AND (l_freight_info_tab(l_index).currency_code <>FND_API.G_MISS_CHAR)) THEN
972: WSH_UTIL_VALIDATE.validate_currency(
973: p_currency_code => l_freight_info_tab(l_index).currency_code,
974: p_currency_name => NULL,
975: p_amount => l_freight_info_tab(l_index).unit_amount,

Line 1339: IF nvl(l_freight_info_tab(l_index).DELIVERY_DETAIL_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1335: -- Add nvl with g_miss_num
1336:
1337: --J-IB-JCKWOK
1338: --
1339: IF nvl(l_freight_info_tab(l_index).DELIVERY_DETAIL_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1340: --
1341: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
1342: --
1343: OPEN c_detail_rec(l_freight_info_tab(l_index).DELIVERY_DETAIL_ID);

Line 1355: RAISE FND_API.G_EXC_ERROR;

1351: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1352: IF l_debug_on THEN
1353: wsh_debug_sv.log (l_module_name,'WSH_DETAIL_NOT_EXIST');
1354: END IF;
1355: RAISE FND_API.G_EXC_ERROR;
1356: --
1357: END IF;
1358: --
1359: CLOSE c_detail_rec;

Line 1377: ELSIF nvl(l_freight_info_tab(l_index).DELIVERY_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1373: x_num_errors =>l_num_errors);
1374: --
1375: END IF;
1376: --
1377: ELSIF nvl(l_freight_info_tab(l_index).DELIVERY_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1378: --
1379: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
1380: OPEN c_del_rec(l_freight_info_tab(l_index).DELIVERY_ID);
1381: FETCH c_del_rec INTO l_del_rec_tab(1);

Line 1393: RAISE FND_API.G_EXC_ERROR;

1389: IF l_debug_on THEN
1390: wsh_debug_sv.log (l_module_name,'WSH_DELIVERY_NOT_EXIST');
1391: END IF;
1392: --
1393: RAISE FND_API.G_EXC_ERROR;
1394: END IF;
1395: --
1396: CLOSE c_del_rec;
1397: --

Line 1412: ELSIF nvl(l_freight_info_tab(l_index).TRIP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1408: x_num_warnings =>l_num_warnings,
1409: x_num_errors =>l_num_errors);
1410: END IF;
1411: --
1412: ELSIF nvl(l_freight_info_tab(l_index).TRIP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1413: --
1414: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
1415: OPEN c_trip_rec(l_freight_info_tab(l_index).TRIP_ID);
1416: FETCH c_trip_rec INTO l_trip_rec_tab(1);

Line 1428: RAISE FND_API.G_EXC_ERROR;

1424: IF l_debug_on THEN
1425: wsh_debug_sv.log (l_module_name,'WSH_TRIP_NOT_EXIST');
1426: END IF;
1427: --
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: --
1431: CLOSE c_trip_rec;
1432: --

Line 1447: ELSIF nvl(l_freight_info_tab(l_index).STOP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

1443: x_num_warnings =>l_num_warnings,
1444: x_num_errors =>l_num_errors);
1445: END IF;
1446: --
1447: ELSIF nvl(l_freight_info_tab(l_index).STOP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1448: --
1449: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
1450: OPEN c_stop_rec(l_freight_info_tab(l_index).STOP_ID);
1451: FETCH c_stop_rec INTO l_stop_rec_tab(1);

Line 1463: RAISE FND_API.G_EXC_ERROR;

1459: IF l_debug_on THEN
1460: wsh_debug_sv.log (l_module_name,'WSH_STOP_NOT_EXIST');
1461: END IF;
1462: --
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465: --
1466: CLOSE c_stop_rec;
1467: --

Line 1525: WHEN fnd_api.g_exc_error THEN

1521: p_value1 => 'Freight_Cost');
1522: END IF;
1523:
1524: EXCEPTION
1525: WHEN fnd_api.g_exc_error THEN
1526: -- OTM R12, glog proj
1527: IF get_freight_cost_type_del%ISOPEN THEN
1528: CLOSE get_freight_cost_type_del;
1529: END IF;

Line 1544: WHEN fnd_api.g_exc_unexpected_error THEN

1540: CLOSE c_del_rec;
1541: END IF;
1542: ROLLBACK to create_update_freight_loop;
1543:
1544: WHEN fnd_api.g_exc_unexpected_error THEN
1545: -- OTM R12, glog proj
1546: IF get_freight_cost_type_del%ISOPEN THEN
1547: CLOSE get_freight_cost_type_del;
1548: END IF;

Line 1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1577: IF c_del_rec%ISOPEN THEN
1578: CLOSE c_del_rec;
1579: END IF;
1580: ROLLBACK to create_update_freight_loop;
1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1582: END;
1583:
1584: l_index := p_freight_info_tab.NEXT(l_index);
1585: END LOOP;

Line 1589: RAISE FND_API.G_EXC_ERROR;

1585: END LOOP;
1586:
1587: IF (l_num_errors = p_freight_info_tab.count ) THEN
1588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1589: RAISE FND_API.G_EXC_ERROR;
1590: ELSIF (l_num_errors > 0 ) THEN
1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1592: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1593: ELSIF (l_num_warnings > 0 ) THEN

Line 1601: IF FND_API.TO_BOOLEAN(p_commit) THEN

1597: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1598: END IF;
1599:
1600:
1601: IF FND_API.TO_BOOLEAN(p_commit) THEN
1602: COMMIT WORK;
1603: END IF;
1604:
1605: FND_MSG_PUB.Count_And_Get (

Line 1624: WHEN FND_API.G_EXC_ERROR THEN

1620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1621: END IF;
1622: Rollback to Create_Update_Freight_Costs_Gp;
1623:
1624: WHEN FND_API.G_EXC_ERROR THEN
1625: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1626: FND_MSG_PUB.Count_And_Get (
1627: p_count => x_msg_count,
1628: p_data => x_msg_data,

Line 1629: p_encoded => FND_API.G_FALSE);

1625: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1626: FND_MSG_PUB.Count_And_Get (
1627: p_count => x_msg_count,
1628: p_data => x_msg_data,
1629: p_encoded => FND_API.G_FALSE);
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1633: END IF;

Line 1631: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1627: p_count => x_msg_count,
1628: p_data => x_msg_data,
1629: p_encoded => FND_API.G_FALSE);
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1633: END IF;
1634: Rollback to Create_Update_Freight_Costs_Gp;
1635:

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

1628: p_data => x_msg_data,
1629: p_encoded => FND_API.G_FALSE);
1630: IF l_debug_on THEN
1631: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1633: END IF;
1634: Rollback to Create_Update_Freight_Costs_Gp;
1635:
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1632: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1633: END IF;
1634: Rollback to Create_Update_Freight_Costs_Gp;
1635:
1636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1637: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1638: FND_MSG_PUB.Count_And_Get (
1639: p_count => x_msg_count,
1640: p_data => x_msg_data,

Line 1641: p_encoded => FND_API.G_FALSE);

1637: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1638: FND_MSG_PUB.Count_And_Get (
1639: p_count => x_msg_count,
1640: p_data => x_msg_data,
1641: p_encoded => FND_API.G_FALSE);
1642: IF l_debug_on THEN
1643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1645: END IF;

Line 1643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1639: p_count => x_msg_count,
1640: p_data => x_msg_data,
1641: p_encoded => FND_API.G_FALSE);
1642: IF l_debug_on THEN
1643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1645: END IF;
1646: Rollback to Create_Update_Freight_Costs_Gp;
1647:

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

1640: p_data => x_msg_data,
1641: p_encoded => FND_API.G_FALSE);
1642: IF l_debug_on THEN
1643: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1645: END IF;
1646: Rollback to Create_Update_Freight_Costs_Gp;
1647:
1648: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 1653: p_encoded => FND_API.G_FALSE);

1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1650: FND_MSG_PUB.Count_And_Get (
1651: p_count => x_msg_count,
1652: p_data => x_msg_data,
1653: p_encoded => FND_API.G_FALSE);
1654: IF l_debug_on THEN
1655: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1657: END IF;

Line 1665: p_encoded => FND_API.G_FALSE);

1661: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1662: FND_MSG_PUB.Count_And_Get (
1663: p_count => x_msg_count,
1664: p_data => x_msg_data,
1665: p_encoded => FND_API.G_FALSE);
1666: IF l_debug_on THEN
1667: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1668: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1669: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1723: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN

1719: THEN
1720: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1721: END IF;
1722: --
1723: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: END IF;
1726:
1727: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1720: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1721: END IF;
1722: --
1723: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: END IF;
1726:
1727: IF FND_API.to_Boolean(p_init_msg_list) THEN
1728: FND_MSG_PUB.initialize;

Line 1727: IF FND_API.to_Boolean(p_init_msg_list) THEN

1723: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: END IF;
1726:
1727: IF FND_API.to_Boolean(p_init_msg_list) THEN
1728: FND_MSG_PUB.initialize;
1729: END IF;
1730:
1731: map_freightgrp_to_pvt (

Line 1739: raise FND_API.G_EXC_ERROR;

1735: IF l_debug_on THEN
1736: wsh_debug_sv.log (l_module_name, 'map_freightgrp_to_pvt x_return_status',x_return_status);
1737: END IF;
1738: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1739: raise FND_API.G_EXC_ERROR;
1740: END IF;
1741:
1742: l_in_rec.caller := 'WSH_GRP';
1743: l_in_rec.phase := 1;

Line 1767: WHEN FND_API.G_EXC_ERROR THEN

1763: WSH_DEBUG_SV.pop(l_module_name);
1764: END IF;
1765:
1766: EXCEPTION
1767: WHEN FND_API.G_EXC_ERROR THEN
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1771: END IF;

Line 1769: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1765:
1766: EXCEPTION
1767: WHEN FND_API.G_EXC_ERROR THEN
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1771: END IF;
1772:
1773:

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

1766: EXCEPTION
1767: WHEN FND_API.G_EXC_ERROR THEN
1768: IF l_debug_on THEN
1769: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1771: END IF;
1772:
1773:
1774: WHEN OTHERS THEN