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 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359: WSH_DEBUG_SV.push(l_module_name);
360: WSH_DEBUG_SV.log(l_module_name,'freight_cost_id',p_freight_rec.freight_cost_id);
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: IF p_action = 'UPDATE' THEN
366: OPEN c_tbl_rec;
367: FETCH c_tbl_rec INTO x_freight_rec;

Line 382: p_freight_rec.conversion_type_code = FND_API.G_MISS_CHAR) THEN

378: x_freight_rec.CONVERSION_DATE:= SYSDATE;
379:
380: --Bug 3560936
381: IF (p_freight_rec.conversion_type_code IS NULL OR
382: p_freight_rec.conversion_type_code = FND_API.G_MISS_CHAR) THEN
383: x_freight_rec.CONVERSION_TYPE_CODE:= 'Corporate';
384: ELSE
385: x_freight_rec.CONVERSION_TYPE_CODE:= p_freight_rec.conversion_type_code;
386: END IF;

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

391: x_freight_rec.LAST_UPDATED_BY:= FND_GLOBAL.USER_ID;
392: x_freight_rec.LAST_UPDATE_LOGIN:= FND_GLOBAL.USER_ID;
393:
394:
395: IF ( p_freight_rec.FREIGHT_COST_TYPE_ID <> FND_API.G_MISS_NUM ) THEN
396: x_freight_rec.FREIGHT_COST_TYPE_ID := p_freight_rec.FREIGHT_COST_TYPE_ID;
397: END IF;
398: IF ( p_freight_rec.UNIT_AMOUNT <> FND_API.G_MISS_NUM
399: OR p_freight_rec.UNIT_AMOUNT IS NULL ) THEN

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

394:
395: IF ( p_freight_rec.FREIGHT_COST_TYPE_ID <> FND_API.G_MISS_NUM ) THEN
396: x_freight_rec.FREIGHT_COST_TYPE_ID := p_freight_rec.FREIGHT_COST_TYPE_ID;
397: END IF;
398: IF ( p_freight_rec.UNIT_AMOUNT <> FND_API.G_MISS_NUM
399: OR p_freight_rec.UNIT_AMOUNT IS NULL ) THEN
400: x_freight_rec.UNIT_AMOUNT:= p_freight_rec.UNIT_AMOUNT;
401: END IF;
402: IF ( p_freight_rec.CALCULATION_METHOD <> FND_API.G_MISS_CHAR

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

398: IF ( p_freight_rec.UNIT_AMOUNT <> FND_API.G_MISS_NUM
399: OR p_freight_rec.UNIT_AMOUNT IS NULL ) THEN
400: x_freight_rec.UNIT_AMOUNT:= p_freight_rec.UNIT_AMOUNT;
401: END IF;
402: IF ( p_freight_rec.CALCULATION_METHOD <> FND_API.G_MISS_CHAR
403: OR p_freight_rec.CALCULATION_METHOD IS NULL ) THEN
404: x_freight_rec.CALCULATION_METHOD:= p_freight_rec.CALCULATION_METHOD;
405: END IF;
406: IF ( p_freight_rec.UOM <> FND_API.G_MISS_CHAR

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

402: IF ( p_freight_rec.CALCULATION_METHOD <> FND_API.G_MISS_CHAR
403: OR p_freight_rec.CALCULATION_METHOD IS NULL ) THEN
404: x_freight_rec.CALCULATION_METHOD:= p_freight_rec.CALCULATION_METHOD;
405: END IF;
406: IF ( p_freight_rec.UOM <> FND_API.G_MISS_CHAR
407: OR p_freight_rec.UOM IS NULL ) THEN
408: x_freight_rec.UOM:= p_freight_rec.UOM;
409: END IF;
410: IF ( p_freight_rec.QUANTITY <> FND_API.G_MISS_NUM

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

406: IF ( p_freight_rec.UOM <> FND_API.G_MISS_CHAR
407: OR p_freight_rec.UOM IS NULL ) THEN
408: x_freight_rec.UOM:= p_freight_rec.UOM;
409: END IF;
410: IF ( p_freight_rec.QUANTITY <> FND_API.G_MISS_NUM
411: OR p_freight_rec.QUANTITY IS NULL) THEN
412: x_freight_rec.QUANTITY:= p_freight_rec.QUANTITY;
413: END IF;
414: IF ( p_freight_rec.TOTAL_AMOUNT <> FND_API.G_MISS_NUM

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

410: IF ( p_freight_rec.QUANTITY <> FND_API.G_MISS_NUM
411: OR p_freight_rec.QUANTITY IS NULL) THEN
412: x_freight_rec.QUANTITY:= p_freight_rec.QUANTITY;
413: END IF;
414: IF ( p_freight_rec.TOTAL_AMOUNT <> FND_API.G_MISS_NUM
415: OR p_freight_rec.TOTAL_AMOUNT IS NULL) THEN
416: x_freight_rec.TOTAL_AMOUNT:= p_freight_rec.TOTAL_AMOUNT;
417: END IF;
418: IF ( p_freight_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR

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

414: IF ( p_freight_rec.TOTAL_AMOUNT <> FND_API.G_MISS_NUM
415: OR p_freight_rec.TOTAL_AMOUNT IS NULL) THEN
416: x_freight_rec.TOTAL_AMOUNT:= p_freight_rec.TOTAL_AMOUNT;
417: END IF;
418: IF ( p_freight_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR
419: OR p_freight_rec.CURRENCY_CODE IS NULL) THEN
420: x_freight_rec.CURRENCY_CODE:= p_freight_rec.CURRENCY_CODE;
421: END IF;
422: IF ( p_freight_rec.CONVERSION_RATE <> FND_API.G_MISS_NUM

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

418: IF ( p_freight_rec.CURRENCY_CODE <> FND_API.G_MISS_CHAR
419: OR p_freight_rec.CURRENCY_CODE IS NULL) THEN
420: x_freight_rec.CURRENCY_CODE:= p_freight_rec.CURRENCY_CODE;
421: END IF;
422: IF ( p_freight_rec.CONVERSION_RATE <> FND_API.G_MISS_NUM
423: OR p_freight_rec.CONVERSION_RATE IS NULL) THEN
424: x_freight_rec.CONVERSION_RATE:= p_freight_rec.CONVERSION_RATE;
425: END IF;
426: IF ( p_freight_rec.TRIP_ID <> FND_API.G_MISS_NUM

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

422: IF ( p_freight_rec.CONVERSION_RATE <> FND_API.G_MISS_NUM
423: OR p_freight_rec.CONVERSION_RATE IS NULL) THEN
424: x_freight_rec.CONVERSION_RATE:= p_freight_rec.CONVERSION_RATE;
425: END IF;
426: IF ( p_freight_rec.TRIP_ID <> FND_API.G_MISS_NUM
427: OR p_freight_rec.TRIP_ID IS NULL) THEN
428: x_freight_rec.TRIP_ID:= p_freight_rec.TRIP_ID;
429: END IF;
430:

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

427: OR p_freight_rec.TRIP_ID IS NULL) THEN
428: x_freight_rec.TRIP_ID:= p_freight_rec.TRIP_ID;
429: END IF;
430:
431: IF ( p_freight_rec.STOP_ID <> FND_API.G_MISS_NUM
432: OR p_freight_rec.STOP_ID IS NULL) THEN
433: x_freight_rec.STOP_ID:= p_freight_rec.STOP_ID;
434: END IF;
435:

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

432: OR p_freight_rec.STOP_ID IS NULL) THEN
433: x_freight_rec.STOP_ID:= p_freight_rec.STOP_ID;
434: END IF;
435:
436: IF ( p_freight_rec.DELIVERY_ID <> FND_API.G_MISS_NUM
437: OR p_freight_rec.DELIVERY_ID IS NULL) THEN
438: x_freight_rec.DELIVERY_ID:= p_freight_rec.DELIVERY_ID;
439: END IF;
440:

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

437: OR p_freight_rec.DELIVERY_ID IS NULL) THEN
438: x_freight_rec.DELIVERY_ID:= p_freight_rec.DELIVERY_ID;
439: END IF;
440:
441: IF ( p_freight_rec.DELIVERY_LEG_ID <> FND_API.G_MISS_NUM
442: OR p_freight_rec.DELIVERY_LEG_ID IS NULL) THEN
443: x_freight_rec.DELIVERY_LEG_ID:= p_freight_rec.DELIVERY_LEG_ID;
444: END IF;
445: IF ( p_freight_rec.DELIVERY_DETAIL_ID <> FND_API.G_MISS_NUM

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

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

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

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

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

449: IF ( p_freight_rec.ATTRIBUTE_CATEGORY <> FND_API.G_MISS_CHAR
450: OR p_freight_rec.ATTRIBUTE_CATEGORY IS NULL) THEN
451: x_freight_rec.ATTRIBUTE_CATEGORY:= p_freight_rec.ATTRIBUTE_CATEGORY;
452: END IF;
453: IF ( p_freight_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
454: OR p_freight_rec.ATTRIBUTE1 IS NULL) THEN
455: x_freight_rec.ATTRIBUTE1:= p_freight_rec.ATTRIBUTE1;
456: END IF;
457: IF ( p_freight_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR

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

453: IF ( p_freight_rec.ATTRIBUTE1 <> FND_API.G_MISS_CHAR
454: OR p_freight_rec.ATTRIBUTE1 IS NULL) THEN
455: x_freight_rec.ATTRIBUTE1:= p_freight_rec.ATTRIBUTE1;
456: END IF;
457: IF ( p_freight_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
458: OR p_freight_rec.ATTRIBUTE2 IS NULL) THEN
459: x_freight_rec.ATTRIBUTE2:= p_freight_rec.ATTRIBUTE2;
460: END IF;
461: IF ( p_freight_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR

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

457: IF ( p_freight_rec.ATTRIBUTE2 <> FND_API.G_MISS_CHAR
458: OR p_freight_rec.ATTRIBUTE2 IS NULL) THEN
459: x_freight_rec.ATTRIBUTE2:= p_freight_rec.ATTRIBUTE2;
460: END IF;
461: IF ( p_freight_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
462: OR p_freight_rec.ATTRIBUTE3 IS NULL) THEN
463: x_freight_rec.ATTRIBUTE3:= p_freight_rec.ATTRIBUTE3;
464: END IF;
465: IF ( p_freight_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR

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

461: IF ( p_freight_rec.ATTRIBUTE3 <> FND_API.G_MISS_CHAR
462: OR p_freight_rec.ATTRIBUTE3 IS NULL) THEN
463: x_freight_rec.ATTRIBUTE3:= p_freight_rec.ATTRIBUTE3;
464: END IF;
465: IF ( p_freight_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
466: OR p_freight_rec.ATTRIBUTE4 IS NULL) THEN
467: x_freight_rec.ATTRIBUTE4:= p_freight_rec.ATTRIBUTE4;
468: END IF;
469: IF ( p_freight_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR

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

465: IF ( p_freight_rec.ATTRIBUTE4 <> FND_API.G_MISS_CHAR
466: OR p_freight_rec.ATTRIBUTE4 IS NULL) THEN
467: x_freight_rec.ATTRIBUTE4:= p_freight_rec.ATTRIBUTE4;
468: END IF;
469: IF ( p_freight_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
470: OR p_freight_rec.ATTRIBUTE5 IS NULL) THEN
471: x_freight_rec.ATTRIBUTE5:= p_freight_rec.ATTRIBUTE5;
472: END IF;
473: IF ( p_freight_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR

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

469: IF ( p_freight_rec.ATTRIBUTE5 <> FND_API.G_MISS_CHAR
470: OR p_freight_rec.ATTRIBUTE5 IS NULL) THEN
471: x_freight_rec.ATTRIBUTE5:= p_freight_rec.ATTRIBUTE5;
472: END IF;
473: IF ( p_freight_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
474: OR p_freight_rec.ATTRIBUTE6 IS NULL) THEN
475: x_freight_rec.ATTRIBUTE6:= p_freight_rec.ATTRIBUTE6;
476: END IF;
477: IF ( p_freight_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR

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

473: IF ( p_freight_rec.ATTRIBUTE6 <> FND_API.G_MISS_CHAR
474: OR p_freight_rec.ATTRIBUTE6 IS NULL) THEN
475: x_freight_rec.ATTRIBUTE6:= p_freight_rec.ATTRIBUTE6;
476: END IF;
477: IF ( p_freight_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
478: OR p_freight_rec.ATTRIBUTE7 IS NULL) THEN
479: x_freight_rec.ATTRIBUTE7:= p_freight_rec.ATTRIBUTE7;
480: END IF;
481: IF ( p_freight_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR

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

477: IF ( p_freight_rec.ATTRIBUTE7 <> FND_API.G_MISS_CHAR
478: OR p_freight_rec.ATTRIBUTE7 IS NULL) THEN
479: x_freight_rec.ATTRIBUTE7:= p_freight_rec.ATTRIBUTE7;
480: END IF;
481: IF ( p_freight_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
482: OR p_freight_rec.ATTRIBUTE8 IS NULL) THEN
483: x_freight_rec.ATTRIBUTE8:= p_freight_rec.ATTRIBUTE8;
484: END IF;
485: IF ( p_freight_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR

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

481: IF ( p_freight_rec.ATTRIBUTE8 <> FND_API.G_MISS_CHAR
482: OR p_freight_rec.ATTRIBUTE8 IS NULL) THEN
483: x_freight_rec.ATTRIBUTE8:= p_freight_rec.ATTRIBUTE8;
484: END IF;
485: IF ( p_freight_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
486: OR p_freight_rec.ATTRIBUTE9 IS NULL) THEN
487: x_freight_rec.ATTRIBUTE9:= p_freight_rec.ATTRIBUTE9;
488: END IF;
489: IF ( p_freight_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR

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

485: IF ( p_freight_rec.ATTRIBUTE9 <> FND_API.G_MISS_CHAR
486: OR p_freight_rec.ATTRIBUTE9 IS NULL) THEN
487: x_freight_rec.ATTRIBUTE9:= p_freight_rec.ATTRIBUTE9;
488: END IF;
489: IF ( p_freight_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
490: OR p_freight_rec.ATTRIBUTE10 IS NULL) THEN
491: x_freight_rec.ATTRIBUTE10:= p_freight_rec.ATTRIBUTE10;
492: END IF;
493: IF ( p_freight_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR

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

489: IF ( p_freight_rec.ATTRIBUTE10 <> FND_API.G_MISS_CHAR
490: OR p_freight_rec.ATTRIBUTE10 IS NULL) THEN
491: x_freight_rec.ATTRIBUTE10:= p_freight_rec.ATTRIBUTE10;
492: END IF;
493: IF ( p_freight_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
494: OR p_freight_rec.ATTRIBUTE11 IS NULL) THEN
495: x_freight_rec.ATTRIBUTE11:= p_freight_rec.ATTRIBUTE11;
496: END IF;
497: IF ( p_freight_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR

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

493: IF ( p_freight_rec.ATTRIBUTE11 <> FND_API.G_MISS_CHAR
494: OR p_freight_rec.ATTRIBUTE11 IS NULL) THEN
495: x_freight_rec.ATTRIBUTE11:= p_freight_rec.ATTRIBUTE11;
496: END IF;
497: IF ( p_freight_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
498: OR p_freight_rec.ATTRIBUTE12 IS NULL) THEN
499: x_freight_rec.ATTRIBUTE12:= p_freight_rec.ATTRIBUTE12;
500: END IF;
501: IF ( p_freight_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR

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

497: IF ( p_freight_rec.ATTRIBUTE12 <> FND_API.G_MISS_CHAR
498: OR p_freight_rec.ATTRIBUTE12 IS NULL) THEN
499: x_freight_rec.ATTRIBUTE12:= p_freight_rec.ATTRIBUTE12;
500: END IF;
501: IF ( p_freight_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
502: OR p_freight_rec.ATTRIBUTE13 IS NULL) THEN
503: x_freight_rec.ATTRIBUTE13:= p_freight_rec.ATTRIBUTE13;
504: END IF;
505: IF ( p_freight_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR

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

501: IF ( p_freight_rec.ATTRIBUTE13 <> FND_API.G_MISS_CHAR
502: OR p_freight_rec.ATTRIBUTE13 IS NULL) THEN
503: x_freight_rec.ATTRIBUTE13:= p_freight_rec.ATTRIBUTE13;
504: END IF;
505: IF ( p_freight_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
506: OR p_freight_rec.ATTRIBUTE14 IS NULL) THEN
507: x_freight_rec.ATTRIBUTE14:= p_freight_rec.ATTRIBUTE14;
508: END IF;
509: IF ( p_freight_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR

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

505: IF ( p_freight_rec.ATTRIBUTE14 <> FND_API.G_MISS_CHAR
506: OR p_freight_rec.ATTRIBUTE14 IS NULL) THEN
507: x_freight_rec.ATTRIBUTE14:= p_freight_rec.ATTRIBUTE14;
508: END IF;
509: IF ( p_freight_rec.ATTRIBUTE15 <> FND_API.G_MISS_CHAR
510: OR p_freight_rec.ATTRIBUTE15 IS NULL) THEN
511: x_freight_rec.ATTRIBUTE15:= p_freight_rec.ATTRIBUTE15;
512: END IF;
513:

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

510: OR p_freight_rec.ATTRIBUTE15 IS NULL) THEN
511: x_freight_rec.ATTRIBUTE15:= p_freight_rec.ATTRIBUTE15;
512: END IF;
513:
514: IF ( p_freight_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
515: OR p_freight_rec.PROGRAM_APPLICATION_ID IS NULL) THEN
516: x_freight_rec.PROGRAM_APPLICATION_ID:= p_freight_rec.PROGRAM_APPLICATION_ID;
517: END IF;
518: IF ( p_freight_rec.PROGRAM_ID <> FND_API.G_MISS_NUM

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

514: IF ( p_freight_rec.PROGRAM_APPLICATION_ID <> FND_API.G_MISS_NUM
515: OR p_freight_rec.PROGRAM_APPLICATION_ID IS NULL) THEN
516: x_freight_rec.PROGRAM_APPLICATION_ID:= p_freight_rec.PROGRAM_APPLICATION_ID;
517: END IF;
518: IF ( p_freight_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
519: OR p_freight_rec.PROGRAM_ID IS NULL) THEN
520: x_freight_rec.PROGRAM_ID:= p_freight_rec.PROGRAM_ID;
521: END IF;
522: IF ( p_freight_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE

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

518: IF ( p_freight_rec.PROGRAM_ID <> FND_API.G_MISS_NUM
519: OR p_freight_rec.PROGRAM_ID IS NULL) THEN
520: x_freight_rec.PROGRAM_ID:= p_freight_rec.PROGRAM_ID;
521: END IF;
522: IF ( p_freight_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
523: OR p_freight_rec.PROGRAM_UPDATE_DATE IS NULL) THEN
524: x_freight_rec.PROGRAM_UPDATE_DATE:= p_freight_rec.PROGRAM_UPDATE_DATE;
525: END IF;
526: IF ( p_freight_rec.REQUEST_ID <> FND_API.G_MISS_NUM

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

522: IF ( p_freight_rec.PROGRAM_UPDATE_DATE <> FND_API.G_MISS_DATE
523: OR p_freight_rec.PROGRAM_UPDATE_DATE IS NULL) THEN
524: x_freight_rec.PROGRAM_UPDATE_DATE:= p_freight_rec.PROGRAM_UPDATE_DATE;
525: END IF;
526: IF ( p_freight_rec.REQUEST_ID <> FND_API.G_MISS_NUM
527: OR p_freight_rec.REQUEST_ID IS NULL) THEN
528: x_freight_rec.REQUEST_ID:= p_freight_rec.REQUEST_ID;
529: END IF;
530: IF ( p_freight_rec.FREIGHT_CODE <> FND_API.G_MISS_CHAR

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

526: IF ( p_freight_rec.REQUEST_ID <> FND_API.G_MISS_NUM
527: OR p_freight_rec.REQUEST_ID IS NULL) THEN
528: x_freight_rec.REQUEST_ID:= p_freight_rec.REQUEST_ID;
529: END IF;
530: IF ( p_freight_rec.FREIGHT_CODE <> FND_API.G_MISS_CHAR
531: OR p_freight_rec.FREIGHT_CODE IS NULL) THEN
532: x_freight_rec.FREIGHT_CODE:= p_freight_rec.FREIGHT_CODE;
533: END IF;
534: IF ( p_freight_rec.LINE_TYPE_CODE <> FND_API.G_MISS_CHAR

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

530: IF ( p_freight_rec.FREIGHT_CODE <> FND_API.G_MISS_CHAR
531: OR p_freight_rec.FREIGHT_CODE IS NULL) THEN
532: x_freight_rec.FREIGHT_CODE:= p_freight_rec.FREIGHT_CODE;
533: END IF;
534: IF ( p_freight_rec.LINE_TYPE_CODE <> FND_API.G_MISS_CHAR
535: OR p_freight_rec.LINE_TYPE_CODE IS NULL) THEN
536: x_freight_rec.LINE_TYPE_CODE:= p_freight_rec.FREIGHT_CODE;
537: END IF;
538: IF ( p_freight_rec.PRICING_LIST_HEADER_ID <> FND_API.G_MISS_NUM

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

534: IF ( p_freight_rec.LINE_TYPE_CODE <> FND_API.G_MISS_CHAR
535: OR p_freight_rec.LINE_TYPE_CODE IS NULL) THEN
536: x_freight_rec.LINE_TYPE_CODE:= p_freight_rec.FREIGHT_CODE;
537: END IF;
538: IF ( p_freight_rec.PRICING_LIST_HEADER_ID <> FND_API.G_MISS_NUM
539: OR p_freight_rec.PRICING_LIST_HEADER_ID IS NULL) THEN
540: x_freight_rec.PRICING_LIST_HEADER_ID:= p_freight_rec.PRICING_LIST_HEADER_ID;
541: END IF;
542: IF ( p_freight_rec.PRICING_LIST_LINE_ID <> FND_API.G_MISS_NUM

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

538: IF ( p_freight_rec.PRICING_LIST_HEADER_ID <> FND_API.G_MISS_NUM
539: OR p_freight_rec.PRICING_LIST_HEADER_ID IS NULL) THEN
540: x_freight_rec.PRICING_LIST_HEADER_ID:= p_freight_rec.PRICING_LIST_HEADER_ID;
541: END IF;
542: IF ( p_freight_rec.PRICING_LIST_LINE_ID <> FND_API.G_MISS_NUM
543: OR p_freight_rec.PRICING_LIST_LINE_ID IS NULL) THEN
544: x_freight_rec.PRICING_LIST_LINE_ID:= p_freight_rec.PRICING_LIST_LINE_ID;
545: END IF;
546: IF ( p_freight_rec.APPLIED_TO_CHARGE_ID <> FND_API.G_MISS_NUM

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

542: IF ( p_freight_rec.PRICING_LIST_LINE_ID <> FND_API.G_MISS_NUM
543: OR p_freight_rec.PRICING_LIST_LINE_ID IS NULL) THEN
544: x_freight_rec.PRICING_LIST_LINE_ID:= p_freight_rec.PRICING_LIST_LINE_ID;
545: END IF;
546: IF ( p_freight_rec.APPLIED_TO_CHARGE_ID <> FND_API.G_MISS_NUM
547: OR p_freight_rec.APPLIED_TO_CHARGE_ID IS NULL) THEN
548: x_freight_rec.APPLIED_TO_CHARGE_ID:= p_freight_rec.APPLIED_TO_CHARGE_ID;
549: END IF;
550: IF ( p_freight_rec.CHARGE_UNIT_VALUE <> FND_API.G_MISS_NUM

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

546: IF ( p_freight_rec.APPLIED_TO_CHARGE_ID <> FND_API.G_MISS_NUM
547: OR p_freight_rec.APPLIED_TO_CHARGE_ID IS NULL) THEN
548: x_freight_rec.APPLIED_TO_CHARGE_ID:= p_freight_rec.APPLIED_TO_CHARGE_ID;
549: END IF;
550: IF ( p_freight_rec.CHARGE_UNIT_VALUE <> FND_API.G_MISS_NUM
551: OR p_freight_rec.CHARGE_UNIT_VALUE IS NULL) THEN
552: x_freight_rec.CHARGE_UNIT_VALUE:= p_freight_rec.CHARGE_UNIT_VALUE;
553: END IF;
554: IF ( p_freight_rec.CHARGE_SOURCE_CODE <> FND_API.G_MISS_CHAR

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

550: IF ( p_freight_rec.CHARGE_UNIT_VALUE <> FND_API.G_MISS_NUM
551: OR p_freight_rec.CHARGE_UNIT_VALUE IS NULL) THEN
552: x_freight_rec.CHARGE_UNIT_VALUE:= p_freight_rec.CHARGE_UNIT_VALUE;
553: END IF;
554: IF ( p_freight_rec.CHARGE_SOURCE_CODE <> FND_API.G_MISS_CHAR
555: OR p_freight_rec.CHARGE_SOURCE_CODE IS NULL) THEN
556: x_freight_rec.CHARGE_SOURCE_CODE:= p_freight_rec.CHARGE_SOURCE_CODE;
557: END IF;
558: IF ( p_freight_rec.ESTIMATED_FLAG <> FND_API.G_MISS_CHAR

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

554: IF ( p_freight_rec.CHARGE_SOURCE_CODE <> FND_API.G_MISS_CHAR
555: OR p_freight_rec.CHARGE_SOURCE_CODE IS NULL) THEN
556: x_freight_rec.CHARGE_SOURCE_CODE:= p_freight_rec.CHARGE_SOURCE_CODE;
557: END IF;
558: IF ( p_freight_rec.ESTIMATED_FLAG <> FND_API.G_MISS_CHAR
559: OR p_freight_rec.ESTIMATED_FLAG IS NULL) THEN
560: x_freight_rec.ESTIMATED_FLAG:= p_freight_rec.ESTIMATED_FLAG;
561: END IF;
562: IF ( p_freight_rec.FREIGHT_COST_TYPE <> FND_API.G_MISS_CHAR

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

558: IF ( p_freight_rec.ESTIMATED_FLAG <> FND_API.G_MISS_CHAR
559: OR p_freight_rec.ESTIMATED_FLAG IS NULL) THEN
560: x_freight_rec.ESTIMATED_FLAG:= p_freight_rec.ESTIMATED_FLAG;
561: END IF;
562: IF ( p_freight_rec.FREIGHT_COST_TYPE <> FND_API.G_MISS_CHAR
563: OR p_freight_rec.FREIGHT_COST_TYPE IS NULL) THEN
564: x_freight_rec.FREIGHT_COST_TYPE := p_freight_rec.FREIGHT_COST_TYPE;
565: END IF;
566: IF ( p_freight_rec.COMMODITY_CATEGORY_ID <> FND_API.G_MISS_NUM

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

562: IF ( p_freight_rec.FREIGHT_COST_TYPE <> FND_API.G_MISS_CHAR
563: OR p_freight_rec.FREIGHT_COST_TYPE IS NULL) THEN
564: x_freight_rec.FREIGHT_COST_TYPE := p_freight_rec.FREIGHT_COST_TYPE;
565: END IF;
566: IF ( p_freight_rec.COMMODITY_CATEGORY_ID <> FND_API.G_MISS_NUM
567: OR p_freight_rec.COMMODITY_CATEGORY_ID IS NULL) THEN
568: x_freight_rec.COMMODITY_CATEGORY_ID := p_freight_rec.COMMODITY_CATEGORY_ID;
569: END IF;
570:

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

570:
571: --bug 3614196
572: --trip_name, stop_location_id, planned_dep_date, delivery_name
573: --need to copied to output record
574: IF ( p_freight_rec.TRIP_NAME <> FND_API.G_MISS_CHAR
575: OR p_freight_rec.TRIP_NAME IS NULL) THEN
576: x_freight_rec.TRIP_NAME:= p_freight_rec.TRIP_NAME;
577: END IF;
578:

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

575: OR p_freight_rec.TRIP_NAME IS NULL) THEN
576: x_freight_rec.TRIP_NAME:= p_freight_rec.TRIP_NAME;
577: END IF;
578:
579: IF ( p_freight_rec.STOP_LOCATION_ID <> FND_API.G_MISS_NUM
580: OR p_freight_rec.STOP_LOCATION_ID IS NULL) THEN
581: x_freight_rec.STOP_LOCATION_ID:= p_freight_rec.STOP_LOCATION_ID;
582: END IF;
583:

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

580: OR p_freight_rec.STOP_LOCATION_ID IS NULL) THEN
581: x_freight_rec.STOP_LOCATION_ID:= p_freight_rec.STOP_LOCATION_ID;
582: END IF;
583:
584: IF ( p_freight_rec.PLANNED_DEP_DATE <> FND_API.G_MISS_DATE
585: OR p_freight_rec.PLANNED_DEP_DATE IS NULL) THEN
586: x_freight_rec.PLANNED_DEP_DATE:= p_freight_rec.PLANNED_DEP_DATE;
587: END IF;
588:

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

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

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

593:
594:
595: IF (p_caller IN ('FTE_RATING')) THEN
596:
597: IF (p_freight_rec.BILLABLE_QUANTITY <> FND_API.G_MISS_NUM
598: OR p_freight_rec.BILLABLE_QUANTITY IS NULL) THEN
599: x_freight_rec.BILLABLE_QUANTITY := p_freight_rec.BILLABLE_QUANTITY;
600: END IF;
601:

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

598: OR p_freight_rec.BILLABLE_QUANTITY IS NULL) THEN
599: x_freight_rec.BILLABLE_QUANTITY := p_freight_rec.BILLABLE_QUANTITY;
600: END IF;
601:
602: IF (p_freight_rec.BILLABLE_UOM <> FND_API.G_MISS_CHAR
603: OR p_freight_rec.BILLABLE_UOM IS NULL) THEN
604: x_freight_rec.BILLABLE_UOM := p_freight_rec.BILLABLE_UOM;
605: END IF;
606:

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

603: OR p_freight_rec.BILLABLE_UOM IS NULL) THEN
604: x_freight_rec.BILLABLE_UOM := p_freight_rec.BILLABLE_UOM;
605: END IF;
606:
607: IF (p_freight_rec.BILLABLE_BASIS <> FND_API.G_MISS_CHAR
608: OR p_freight_rec.BILLABLE_BASIS IS NULL) THEN
609: x_freight_rec.BILLABLE_BASIS := p_freight_rec.BILLABLE_BASIS;
610: END IF;
611:

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

760: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
761: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.phase',p_in_rec.phase);
762: END IF;
763: --
764: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
765: IF l_debug_on THEN
766: WSH_DEBUG_SV.log(l_module_name,'Not compatible');
767: END IF;
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

764: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
765: IF l_debug_on THEN
766: WSH_DEBUG_SV.log(l_module_name,'Not compatible');
767: END IF;
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771: IF FND_API.to_Boolean(p_init_msg_list) THEN
772: FND_MSG_PUB.initialize;

Line 771: IF FND_API.to_Boolean(p_init_msg_list) THEN

767: END IF;
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771: IF FND_API.to_Boolean(p_init_msg_list) THEN
772: FND_MSG_PUB.initialize;
773: END IF;
774:
775: IF (p_in_rec.caller IS NULL) THEN

Line 779: raise fnd_api.g_exc_error;

775: IF (p_in_rec.caller IS NULL) THEN
776: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
777: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.caller');
778: wsh_util_core.add_message(x_return_status,l_module_name);
779: raise fnd_api.g_exc_error;
780: END IF;
781: IF (nvl(p_in_rec.phase,1) <> 1) THEN
782: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
783: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.phase');

Line 785: raise fnd_api.g_exc_error;

781: IF (nvl(p_in_rec.phase,1) <> 1) THEN
782: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
783: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.phase');
784: wsh_util_core.add_message(x_return_status,l_module_name);
785: raise fnd_api.g_exc_error;
786: END IF;
787: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE') ) THEN
788: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
789: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.action_code');

Line 791: raise fnd_api.g_exc_error;

787: IF (p_in_rec.action_code IS NULL OR p_in_rec.action_code NOT IN ('CREATE','UPDATE') ) THEN
788: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
789: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_in_rec.action_code');
790: wsh_util_core.add_message(x_return_status,l_module_name);
791: raise fnd_api.g_exc_error;
792: END IF;
793:
794: WSH_ACTIONS_LEVELS.set_validation_level (
795: p_entity => 'FRST',

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

921: p_value1 => 'conversion_rate');
922: END IF;
923:
924: IF ((WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CURR_CODE_LVL)=1)
925: AND (l_freight_info_tab(l_index).currency_code <>FND_API.G_MISS_CHAR)) THEN
926: WSH_UTIL_VALIDATE.validate_currency(
927: p_currency_code => l_freight_info_tab(l_index).currency_code,
928: p_currency_name => NULL,
929: p_amount => l_freight_info_tab(l_index).unit_amount,

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

1289: -- Add nvl with g_miss_num
1290:
1291: --J-IB-JCKWOK
1292: --
1293: IF nvl(l_freight_info_tab(l_index).DELIVERY_DETAIL_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1294: --
1295: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
1296: --
1297: OPEN c_detail_rec(l_freight_info_tab(l_index).DELIVERY_DETAIL_ID);

Line 1309: RAISE FND_API.G_EXC_ERROR;

1305: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1306: IF l_debug_on THEN
1307: wsh_debug_sv.log (l_module_name,'WSH_DETAIL_NOT_EXIST');
1308: END IF;
1309: RAISE FND_API.G_EXC_ERROR;
1310: --
1311: END IF;
1312: --
1313: CLOSE c_detail_rec;

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

1327: x_num_errors =>l_num_errors);
1328: --
1329: END IF;
1330: --
1331: ELSIF nvl(l_freight_info_tab(l_index).DELIVERY_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1332: --
1333: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
1334: OPEN c_del_rec(l_freight_info_tab(l_index).DELIVERY_ID);
1335: FETCH c_del_rec INTO l_del_rec_tab(1);

Line 1347: RAISE FND_API.G_EXC_ERROR;

1343: IF l_debug_on THEN
1344: wsh_debug_sv.log (l_module_name,'WSH_DELIVERY_NOT_EXIST');
1345: END IF;
1346: --
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;
1349: --
1350: CLOSE c_del_rec;
1351: --

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

1362: x_num_warnings =>l_num_warnings,
1363: x_num_errors =>l_num_errors);
1364: END IF;
1365: --
1366: ELSIF nvl(l_freight_info_tab(l_index).TRIP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1367: --
1368: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
1369: OPEN c_trip_rec(l_freight_info_tab(l_index).TRIP_ID);
1370: FETCH c_trip_rec INTO l_trip_rec_tab(1);

Line 1382: RAISE FND_API.G_EXC_ERROR;

1378: IF l_debug_on THEN
1379: wsh_debug_sv.log (l_module_name,'WSH_TRIP_NOT_EXIST');
1380: END IF;
1381: --
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;
1384: --
1385: CLOSE c_trip_rec;
1386: --

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

1397: x_num_warnings =>l_num_warnings,
1398: x_num_errors =>l_num_errors);
1399: END IF;
1400: --
1401: ELSIF nvl(l_freight_info_tab(l_index).STOP_ID, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
1402: --
1403: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
1404: OPEN c_stop_rec(l_freight_info_tab(l_index).STOP_ID);
1405: FETCH c_stop_rec INTO l_stop_rec_tab(1);

Line 1417: RAISE FND_API.G_EXC_ERROR;

1413: IF l_debug_on THEN
1414: wsh_debug_sv.log (l_module_name,'WSH_STOP_NOT_EXIST');
1415: END IF;
1416: --
1417: RAISE FND_API.G_EXC_ERROR;
1418: END IF;
1419: --
1420: CLOSE c_stop_rec;
1421: --

Line 1479: WHEN fnd_api.g_exc_error THEN

1475: p_value1 => 'Freight_Cost');
1476: END IF;
1477:
1478: EXCEPTION
1479: WHEN fnd_api.g_exc_error THEN
1480: -- OTM R12, glog proj
1481: IF get_freight_cost_type_del%ISOPEN THEN
1482: CLOSE get_freight_cost_type_del;
1483: END IF;

Line 1498: WHEN fnd_api.g_exc_unexpected_error THEN

1494: CLOSE c_del_rec;
1495: END IF;
1496: ROLLBACK to create_update_freight_loop;
1497:
1498: WHEN fnd_api.g_exc_unexpected_error THEN
1499: -- OTM R12, glog proj
1500: IF get_freight_cost_type_del%ISOPEN THEN
1501: CLOSE get_freight_cost_type_del;
1502: END IF;

Line 1535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1531: IF c_del_rec%ISOPEN THEN
1532: CLOSE c_del_rec;
1533: END IF;
1534: ROLLBACK to create_update_freight_loop;
1535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1536: END;
1537:
1538: l_index := p_freight_info_tab.NEXT(l_index);
1539: END LOOP;

Line 1543: RAISE FND_API.G_EXC_ERROR;

1539: END LOOP;
1540:
1541: IF (l_num_errors = p_freight_info_tab.count ) THEN
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: RAISE FND_API.G_EXC_ERROR;
1544: ELSIF (l_num_errors > 0 ) THEN
1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1546: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1547: ELSIF (l_num_warnings > 0 ) THEN

Line 1555: IF FND_API.TO_BOOLEAN(p_commit) THEN

1551: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1552: END IF;
1553:
1554:
1555: IF FND_API.TO_BOOLEAN(p_commit) THEN
1556: COMMIT WORK;
1557: END IF;
1558:
1559: FND_MSG_PUB.Count_And_Get (

Line 1578: WHEN FND_API.G_EXC_ERROR THEN

1574: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
1575: END IF;
1576: Rollback to Create_Update_Freight_Costs_Gp;
1577:
1578: WHEN FND_API.G_EXC_ERROR THEN
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1580: FND_MSG_PUB.Count_And_Get (
1581: p_count => x_msg_count,
1582: p_data => x_msg_data,

Line 1583: p_encoded => FND_API.G_FALSE);

1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1580: FND_MSG_PUB.Count_And_Get (
1581: p_count => x_msg_count,
1582: p_data => x_msg_data,
1583: p_encoded => FND_API.G_FALSE);
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1587: END IF;

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

1581: p_count => x_msg_count,
1582: p_data => x_msg_data,
1583: p_encoded => FND_API.G_FALSE);
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1587: END IF;
1588: Rollback to Create_Update_Freight_Costs_Gp;
1589:

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

1582: p_data => x_msg_data,
1583: p_encoded => FND_API.G_FALSE);
1584: IF l_debug_on THEN
1585: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1587: END IF;
1588: Rollback to Create_Update_Freight_Costs_Gp;
1589:
1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1586: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1587: END IF;
1588: Rollback to Create_Update_Freight_Costs_Gp;
1589:
1590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1592: FND_MSG_PUB.Count_And_Get (
1593: p_count => x_msg_count,
1594: p_data => x_msg_data,

Line 1595: p_encoded => FND_API.G_FALSE);

1591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1592: FND_MSG_PUB.Count_And_Get (
1593: p_count => x_msg_count,
1594: p_data => x_msg_data,
1595: p_encoded => FND_API.G_FALSE);
1596: IF l_debug_on THEN
1597: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1598: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1599: END IF;

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

1593: p_count => x_msg_count,
1594: p_data => x_msg_data,
1595: p_encoded => FND_API.G_FALSE);
1596: IF l_debug_on THEN
1597: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1598: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1599: END IF;
1600: Rollback to Create_Update_Freight_Costs_Gp;
1601:

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

1594: p_data => x_msg_data,
1595: p_encoded => FND_API.G_FALSE);
1596: IF l_debug_on THEN
1597: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1598: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1599: END IF;
1600: Rollback to Create_Update_Freight_Costs_Gp;
1601:
1602: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 1607: p_encoded => FND_API.G_FALSE);

1603: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1604: FND_MSG_PUB.Count_And_Get (
1605: p_count => x_msg_count,
1606: p_data => x_msg_data,
1607: p_encoded => FND_API.G_FALSE);
1608: IF l_debug_on THEN
1609: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1610: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1611: END IF;

Line 1619: p_encoded => FND_API.G_FALSE);

1615: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
1616: FND_MSG_PUB.Count_And_Get (
1617: p_count => x_msg_count,
1618: p_data => x_msg_data,
1619: p_encoded => FND_API.G_FALSE);
1620: IF l_debug_on THEN
1621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1622: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1673: THEN
1674: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1675: END IF;
1676: --
1677: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;
1680:
1681: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1674: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1675: END IF;
1676: --
1677: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;
1680:
1681: IF FND_API.to_Boolean(p_init_msg_list) THEN
1682: FND_MSG_PUB.initialize;

Line 1681: IF FND_API.to_Boolean(p_init_msg_list) THEN

1677: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679: END IF;
1680:
1681: IF FND_API.to_Boolean(p_init_msg_list) THEN
1682: FND_MSG_PUB.initialize;
1683: END IF;
1684:
1685: map_freightgrp_to_pvt (

Line 1693: raise FND_API.G_EXC_ERROR;

1689: IF l_debug_on THEN
1690: wsh_debug_sv.log (l_module_name, 'map_freightgrp_to_pvt x_return_status',x_return_status);
1691: END IF;
1692: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1693: raise FND_API.G_EXC_ERROR;
1694: END IF;
1695:
1696: l_in_rec.caller := 'WSH_GRP';
1697: l_in_rec.phase := 1;

Line 1721: WHEN FND_API.G_EXC_ERROR THEN

1717: WSH_DEBUG_SV.pop(l_module_name);
1718: END IF;
1719:
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1725: END IF;

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

1719:
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1725: END IF;
1726:
1727:

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

1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1725: END IF;
1726:
1727:
1728: WHEN OTHERS THEN