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.FTE_TRIPS_PVT dependencies on WSH_UTIL_CORE

Line 186: wsh_util_core.default_handler('FTE_TRIPS_PVT.Create_Update_Delete_Fte_Trip');

182: wsh_debug_sv.dpop (c_sdebug);
183: wsh_debug_sv.stop_debug;
184:
185: WHEN others THEN
186: wsh_util_core.default_handler('FTE_TRIPS_PVT.Create_Update_Delete_Fte_Trip');
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Count_And_Get
189: ( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count

Line 187: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

183: wsh_debug_sv.stop_debug;
184:
185: WHEN others THEN
186: wsh_util_core.default_handler('FTE_TRIPS_PVT.Create_Update_Delete_Fte_Trip');
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Count_And_Get
189: ( p_encoded => FND_API.G_FALSE,
190: p_count => x_msg_count
191: , p_data => x_msg_data

Line 245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

241:
242: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_info.fte_trip_id);
243: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_info.name);
244:
245: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
246:
247: x_trip_id := p_trip_info.fte_trip_id;
248: x_name := p_trip_info.name;
249:

Line 311: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

307: --validation
308: Validate_CreateTrip (p_trip_name =>x_name,
309: x_return_status=>x_return_status);
310:
311: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
312: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
313: THEN
314: RETURN;
315: END IF;

Line 312: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)

308: Validate_CreateTrip (p_trip_name =>x_name,
309: x_return_status=>x_return_status);
310:
311: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
312: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
313: THEN
314: RETURN;
315: END IF;
316:

Line 400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

396:
397: EXCEPTION
398: WHEN wsh_duplicate_name THEN
399: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
401: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
402:
403: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
404: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');

Line 401: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

397: EXCEPTION
398: WHEN wsh_duplicate_name THEN
399: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
400: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
401: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
402:
403: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
404: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
405: wsh_debug_sv.dpop (c_sdebug);

Line 408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');

404: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
405: wsh_debug_sv.dpop (c_sdebug);
406:
407: WHEN others THEN
408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
410:
411: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
412: wsh_debug_sv.dlog (c_debug,'others exception');

Line 409: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

405: wsh_debug_sv.dpop (c_sdebug);
406:
407: WHEN others THEN
408: wsh_util_core.default_handler('FTE_TRIPS_PVT.CREATE_TRIP');
409: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
410:
411: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
412: wsh_debug_sv.dlog (c_debug,'others exception');
413: wsh_debug_sv.dpop (c_sdebug);

Line 439: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

435:
436: wsh_debug_sv.dlog (c_debug,'trip_id ',p_trip_id);
437: wsh_debug_sv.dlog (c_debug,'Name ',p_trip_name);
438:
439: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
440:
441: wsh_debug_sv.dlog (c_debug,'about to check trip name... ');
442:
443: OPEN check_trip_names(p_trip_name);

Line 458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

454:
455: EXCEPTION
456: WHEN wsh_duplicate_name THEN
457: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
459: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
460:
461: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
462: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');

Line 459: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

455: EXCEPTION
456: WHEN wsh_duplicate_name THEN
457: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
459: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
460:
461: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
462: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
463: wsh_debug_sv.dpop (c_sdebug);

Line 466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');

462: wsh_debug_sv.dlog (c_debug,'wsh_duplicate_name exception');
463: wsh_debug_sv.dpop (c_sdebug);
464:
465: WHEN others THEN
466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
468:
469: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
470: wsh_debug_sv.dlog (c_debug,'others exception');

Line 467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

463: wsh_debug_sv.dpop (c_sdebug);
464:
465: WHEN others THEN
466: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_CREATETRIP');
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
468:
469: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);
470: wsh_debug_sv.dlog (c_debug,'others exception');
471: wsh_debug_sv.dpop (c_sdebug);

Line 500: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

496:
497: wsh_duplicate_name EXCEPTION;
498: BEGIN
499:
500: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
501:
502: --validation
503: Validate_UpdateTrip(p_trip_id =>p_trip_info.fte_trip_id,
504: p_trip_name =>p_trip_info.name,

Line 508: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

504: p_trip_name =>p_trip_info.name,
505: p_trip_status =>p_trip_info.status_code,
506: x_return_status => x_return_status);
507:
508: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
509: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
510: THEN
511: RETURN;
512: END IF;

Line 509: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)

505: p_trip_status =>p_trip_info.status_code,
506: x_return_status => x_return_status);
507:
508: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
509: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
510: THEN
511: RETURN;
512: END IF;
513:

Line 558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

554:
555: EXCEPTION
556: WHEN wsh_duplicate_name THEN
557: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
559: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
560: WHEN no_data_found THEN
561: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 559: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

555: EXCEPTION
556: WHEN wsh_duplicate_name THEN
557: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
559: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
560: WHEN no_data_found THEN
561: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
563: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
559: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
560: WHEN no_data_found THEN
561: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
563: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
564: WHEN others THEN
565: wsh_util_core.default_handler('FTE_TRIPS_PVT.UPDATE_TRIP');
566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 563: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

559: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
560: WHEN no_data_found THEN
561: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
563: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
564: WHEN others THEN
565: wsh_util_core.default_handler('FTE_TRIPS_PVT.UPDATE_TRIP');
566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
567:

Line 565: wsh_util_core.default_handler('FTE_TRIPS_PVT.UPDATE_TRIP');

561: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
563: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
564: WHEN others THEN
565: wsh_util_core.default_handler('FTE_TRIPS_PVT.UPDATE_TRIP');
566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
567:
568: END Update_Trip;
569:

Line 566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
563: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
564: WHEN others THEN
565: wsh_util_core.default_handler('FTE_TRIPS_PVT.UPDATE_TRIP');
566: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
567:
568: END Update_Trip;
569:
570:

Line 588: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

584: wsh_duplicate_name EXCEPTION;
585: invalid_fte_trip_status EXCEPTION;
586: BEGIN
587:
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
589:
590: IF (p_trip_id = FND_API.G_MISS_NUM) THEN
591: RAISE no_fte_trip_id;
592: END IF;

Line 615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

611:
612: EXCEPTION
613: WHEN wsh_duplicate_name THEN
614: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
616: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
617: WHEN no_fte_trip_id THEN
618: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
619: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);

Line 616: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

612: EXCEPTION
613: WHEN wsh_duplicate_name THEN
614: FND_MESSAGE.Set_Name('FND', 'FORM_DUPLICATE_KEY_IN_INDEX');
615: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
616: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
617: WHEN no_fte_trip_id THEN
618: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
619: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);
620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

616: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
617: WHEN no_fte_trip_id THEN
618: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
619: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);
620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
621: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
622: WHEN invalid_fte_trip_status THEN
623: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP_STATUS');
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 621: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

617: WHEN no_fte_trip_id THEN
618: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
619: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);
620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
621: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
622: WHEN invalid_fte_trip_status THEN
623: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP_STATUS');
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
625: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 624: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
621: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
622: WHEN invalid_fte_trip_status THEN
623: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP_STATUS');
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
625: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
626: WHEN others THEN
627: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_UPDATETRIP');
628: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 625: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

621: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
622: WHEN invalid_fte_trip_status THEN
623: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP_STATUS');
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
625: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
626: WHEN others THEN
627: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_UPDATETRIP');
628: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
629:

Line 627: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_UPDATETRIP');

623: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP_STATUS');
624: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
625: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
626: WHEN others THEN
627: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_UPDATETRIP');
628: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
629:
630: END Validate_UpdateTrip;
631:

Line 628: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

624: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
625: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
626: WHEN others THEN
627: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_UPDATETRIP');
628: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
629:
630: END Validate_UpdateTrip;
631:
632:

Line 649: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

645: others EXCEPTION;
646:
647: BEGIN
648:
649: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
650:
651: l_trip_id := p_trip_id;
652:
653: --validate

Line 658: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

654: Validate_DeleteTrip(p_trip_id=>l_trip_id,
655: x_return_status=>x_return_status
656: );
657:
658: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
659: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
660: THEN
661: RETURN;
662: END IF;

Line 659: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)

655: x_return_status=>x_return_status
656: );
657:
658: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
659: AND (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
660: THEN
661: RETURN;
662: END IF;
663:

Line 670: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

666:
667: IF (SQL%NOTFOUND) THEN
668: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
669: FND_MESSAGE.SET_TOKEN('TRIP_ID', l_trip_id);
670: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
671: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
672: END IF;
673:
674: EXCEPTION

Line 671: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

667: IF (SQL%NOTFOUND) THEN
668: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
669: FND_MESSAGE.SET_TOKEN('TRIP_ID', l_trip_id);
670: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
671: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
672: END IF;
673:
674: EXCEPTION
675: WHEN others THEN

Line 676: wsh_util_core.default_handler('FTE_TRIPS_PVT.DELETE_TRIP');

672: END IF;
673:
674: EXCEPTION
675: WHEN others THEN
676: wsh_util_core.default_handler('FTE_TRIPS_PVT.DELETE_TRIP');
677: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
678:
679: END Delete_Trip;
680:

Line 677: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

673:
674: EXCEPTION
675: WHEN others THEN
676: wsh_util_core.default_handler('FTE_TRIPS_PVT.DELETE_TRIP');
677: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
678:
679: END Delete_Trip;
680:
681:

Line 701: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

697: others EXCEPTION;
698:
699: BEGIN
700:
701: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
702:
703: l_trip_id := p_trip_id;
704:
705: OPEN trip_segments(l_trip_id);

Line 718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

714: x_return_status =>x_return_status
715: );
716: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_DELETE_ERROR');
717: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
719: wsh_util_core.add_message(x_return_status);
720: end if;
721:
722: EXCEPTION

Line 719: wsh_util_core.add_message(x_return_status);

715: );
716: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_DELETE_ERROR');
717: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
719: wsh_util_core.add_message(x_return_status);
720: end if;
721:
722: EXCEPTION
723: WHEN others THEN

Line 724: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');

720: end if;
721:
722: EXCEPTION
723: WHEN others THEN
724: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');
725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
726:
727: END Validate_DeleteTrip;
728:

Line 725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

721:
722: EXCEPTION
723: WHEN others THEN
724: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');
725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
726:
727: END Validate_DeleteTrip;
728:
729:

Line 772: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

768:
769: wsh_debug_sv.start_debug ('FteTrip-' || p_trip_id);
770: wsh_debug_sv.dpush (c_sdebug, 'Validate_Trip');
771:
772: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
773:
774: IF p_trip_id IS NOT NULL THEN
775: l_count:=0;
776: FOR l_trip_segments IN trip_segments(p_trip_id) LOOP

Line 800: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

796: x_return_status =>x_return_status
797: );
798: FND_MESSAGE.SET_NAME('FTE','FTE_DUPLICATE_SEQ_NUM');
799: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
800: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
801: wsh_util_core.add_message(x_return_status);
802:
803: wsh_debug_sv.dpop (c_sdebug);
804: wsh_debug_sv.stop_debug;

Line 801: wsh_util_core.add_message(x_return_status);

797: );
798: FND_MESSAGE.SET_NAME('FTE','FTE_DUPLICATE_SEQ_NUM');
799: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
800: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
801: wsh_util_core.add_message(x_return_status);
802:
803: wsh_debug_sv.dpop (c_sdebug);
804: wsh_debug_sv.stop_debug;
805:

Line 824: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

820: x_first_stop_location_id =>l_segment_origin,
821: x_return_status =>x_return_status
822: );
823:
824: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
825: wsh_debug_sv.dlog (c_debug,'could not get 1st stop location');
826: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
827: UPDATE FTE_TRIPS SET validation_required='Y'
828: where fte_trip_id=p_trip_id;

Line 826: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

822: );
823:
824: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
825: wsh_debug_sv.dlog (c_debug,'could not get 1st stop location');
826: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
827: UPDATE FTE_TRIPS SET validation_required='Y'
828: where fte_trip_id=p_trip_id;
829: IF (SQL%NOTFOUND) THEN
830: RAISE no_data_found;

Line 863: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

859: RAISE no_data_found;
860: END IF;
861: FND_MESSAGE.SET_NAME('FTE','FTE_SEGMENT_NO_TWO_STOPS');
862: FND_MESSAGE.SET_TOKEN('WSH_TRIP_NAME',l_trip_segment_name);
863: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
864: wsh_util_core.add_message(x_return_status);
865:
866: wsh_debug_sv.dpop (c_sdebug);
867: wsh_debug_sv.stop_debug;

Line 864: wsh_util_core.add_message(x_return_status);

860: END IF;
861: FND_MESSAGE.SET_NAME('FTE','FTE_SEGMENT_NO_TWO_STOPS');
862: FND_MESSAGE.SET_TOKEN('WSH_TRIP_NAME',l_trip_segment_name);
863: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
864: wsh_util_core.add_message(x_return_status);
865:
866: wsh_debug_sv.dpop (c_sdebug);
867: wsh_debug_sv.stop_debug;
868: FND_MSG_PUB.Count_And_Get

Line 896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

892: x_return_status =>x_return_status
893: );
894: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_CONNECT_SEGMENT');
895: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
897: wsh_util_core.add_message(x_return_status);
898: wsh_debug_sv.dpop (c_sdebug);
899: wsh_debug_sv.stop_debug;
900:

Line 897: wsh_util_core.add_message(x_return_status);

893: );
894: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_CONNECT_SEGMENT');
895: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
897: wsh_util_core.add_message(x_return_status);
898: wsh_debug_sv.dpop (c_sdebug);
899: wsh_debug_sv.stop_debug;
900:
901: FND_MSG_PUB.Count_And_Get

Line 916: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

912: x_last_stop_location_id =>l_segment_dest,
913: x_return_status =>x_return_status
914: );
915:
916: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
917: wsh_debug_sv.dlog (c_debug,'could not get last stop location');
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
919:
920: UPDATE FTE_TRIPS SET validation_required='Y'

Line 918: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

914: );
915:
916: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
917: wsh_debug_sv.dlog (c_debug,'could not get last stop location');
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
919:
920: UPDATE FTE_TRIPS SET validation_required='Y'
921: where fte_trip_id=p_trip_id;
922: IF (SQL%NOTFOUND) THEN

Line 934: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

930:
931:
932: END LOOP;
933:
934: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
935: wsh_debug_sv.dlog (c_debug,'validation success');
936: UPDATE FTE_TRIPS SET validation_required='N'
937: where fte_trip_id=p_trip_id;
938: IF (SQL%NOTFOUND) THEN

Line 953: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

949:
950: EXCEPTION
951: WHEN no_data_found THEN
952: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
953: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
954: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
955: wsh_debug_sv.dpop (c_sdebug);
956: wsh_debug_sv.stop_debug;
957: -- Get message count and data

Line 954: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

950: EXCEPTION
951: WHEN no_data_found THEN
952: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_NOT_FOUND');
953: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
954: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
955: wsh_debug_sv.dpop (c_sdebug);
956: wsh_debug_sv.stop_debug;
957: -- Get message count and data
958: FND_MSG_PUB.Count_And_Get

Line 964: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');

960: p_count => x_msg_count
961: ,p_data => x_msg_data
962: );
963: WHEN others THEN
964: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
966: wsh_debug_sv.dpop (c_sdebug);
967: wsh_debug_sv.stop_debug;
968: -- Get message count and data

Line 965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

961: ,p_data => x_msg_data
962: );
963: WHEN others THEN
964: wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');
965: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
966: wsh_debug_sv.dpop (c_sdebug);
967: wsh_debug_sv.stop_debug;
968: -- Get message count and data
969: FND_MSG_PUB.Count_And_Get

Line 996: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

992: BEGIN
993:
994: l_trip_name := NULL;
995:
996: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
997:
998: FOR get_trip_rec IN get_trip_cur
999: LOOP
1000: l_trip_name := get_trip_rec.name;

Line 1012: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_NAME');

1008: x_trip_name := l_trip_name;
1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_NAME');
1013: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_NAME_ERROR');
1014: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
1015: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1016: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1015: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1011: WHEN OTHERS THEN
1012: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_NAME');
1013: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_NAME_ERROR');
1014: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
1015: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1016: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1017: END get_trip_name;
1018:
1019:

Line 1016: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1012: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_NAME');
1013: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_NAME_ERROR');
1014: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
1015: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1016: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1017: END get_trip_name;
1018:
1019:
1020: -- pass in del ids as a comma seperated list which will

Line 1051: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1047:
1048:
1049: BEGIN
1050:
1051: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1052:
1053: dbms_utility.comma_to_table(
1054: list =>p_del_ids,
1055: tablen =>l_noofrows,

Line 1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1076:
1077: EXCEPTION
1078: WHEN no_data_found THEN
1079: FND_MESSAGE.SET_NAME('FTE','FTE_DELIVERY_NOT_FOUND');
1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1081: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1082: FND_MSG_PUB.Count_And_Get
1083: ( p_encoded => FND_API.G_FALSE,
1084: p_count => x_msg_count

Line 1081: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1077: EXCEPTION
1078: WHEN no_data_found THEN
1079: FND_MESSAGE.SET_NAME('FTE','FTE_DELIVERY_NOT_FOUND');
1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1081: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1082: FND_MSG_PUB.Count_And_Get
1083: ( p_encoded => FND_API.G_FALSE,
1084: p_count => x_msg_count
1085: ,p_data => x_msg_data

Line 1088: wsh_util_core.default_handler('FTE_TRIPS_PVT.assign_deliveries_to_ftetrip');

1084: p_count => x_msg_count
1085: ,p_data => x_msg_data
1086: );
1087: WHEN others THEN
1088: wsh_util_core.default_handler('FTE_TRIPS_PVT.assign_deliveries_to_ftetrip');
1089: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1090: FND_MSG_PUB.Count_And_Get
1091: ( p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count

Line 1089: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1085: ,p_data => x_msg_data
1086: );
1087: WHEN others THEN
1088: wsh_util_core.default_handler('FTE_TRIPS_PVT.assign_deliveries_to_ftetrip');
1089: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1090: FND_MSG_PUB.Count_And_Get
1091: ( p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count
1093: ,p_data => x_msg_data

Line 1163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1159: where trip_id = p_trip_id);
1160: --}
1161: BEGIN
1162: --{
1163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1164: --
1165: --
1166: IF x_trip_segment_name IS NULL
1167: THEN

Line 1177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

1173: x_return_status => l_return_status
1174: );
1175: --
1176: --
1177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1178: THEN
1179: --{
1180: x_return_status := l_return_status;
1181: --

Line 1183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING

1179: --{
1180: x_return_status := l_return_status;
1181: --
1182: --
1183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1184: THEN
1185: --{
1186: RETURN;
1187: --}

Line 1211: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_LAST_STOP_LOCATION_INFO');

1207:
1208: EXCEPTION
1209: --{
1210: WHEN OTHERS THEN
1211: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_LAST_STOP_LOCATION_INFO');
1212: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LAST_STOP_ERROR');
1213: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
1214: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1214: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1210: WHEN OTHERS THEN
1211: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_LAST_STOP_LOCATION_INFO');
1212: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LAST_STOP_ERROR');
1213: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
1214: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1216: --}
1217: END GET_LAST_STOP_LOCATION_INFO;
1218: --

Line 1215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1211: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_LAST_STOP_LOCATION_INFO');
1212: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LAST_STOP_ERROR');
1213: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
1214: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1216: --}
1217: END GET_LAST_STOP_LOCATION_INFO;
1218: --
1219: --

Line 1249: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1245: where trip_id = p_trip_id);
1246: --}
1247: BEGIN
1248: --{
1249: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1250: --
1251: --
1252: IF x_trip_segment_name IS NULL
1253: THEN

Line 1263: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

1259: x_return_status => l_return_status
1260: );
1261: --
1262: --
1263: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1264: THEN
1265: --{
1266: x_return_status := l_return_status;
1267: --

Line 1269: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING

1265: --{
1266: x_return_status := l_return_status;
1267: --
1268: --
1269: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1270: THEN
1271: --{
1272: RETURN;
1273: --}

Line 1297: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_FIRST_STOP_LOCATION_INFO');

1293:
1294: EXCEPTION
1295: --{
1296: WHEN OTHERS THEN
1297: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_FIRST_STOP_LOCATION_INFO');
1298: FND_MESSAGE.SET_NAME('FTE','FTE_GET_FIRST_STOP_ERROR');
1299: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
1300: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1300: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1296: WHEN OTHERS THEN
1297: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_FIRST_STOP_LOCATION_INFO');
1298: FND_MESSAGE.SET_NAME('FTE','FTE_GET_FIRST_STOP_ERROR');
1299: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
1300: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1302: --}
1303: END GET_FIRST_STOP_LOCATION_INFO;
1304: --

Line 1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1297: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_FIRST_STOP_LOCATION_INFO');
1298: FND_MESSAGE.SET_NAME('FTE','FTE_GET_FIRST_STOP_ERROR');
1299: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
1300: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1301: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1302: --}
1303: END GET_FIRST_STOP_LOCATION_INFO;
1304: --
1305: --

Line 1343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1339: --
1340: --
1341: x_trip_segment_name := l_trip_segment_name;
1342: --
1343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1344: --}
1345: EXCEPTION
1346: --{
1347: WHEN OTHERS THEN

Line 1348: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_SEGMENT_NAME');

1344: --}
1345: EXCEPTION
1346: --{
1347: WHEN OTHERS THEN
1348: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_SEGMENT_NAME');
1349: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_SEG_NAME_ERROR');
1350: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_segment_id);
1351: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1352: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1351: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1347: WHEN OTHERS THEN
1348: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_SEGMENT_NAME');
1349: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_SEG_NAME_ERROR');
1350: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_segment_id);
1351: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1352: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1353: --}
1354: END GET_TRIP_SEGMENT_NAME;
1355:

Line 1352: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1348: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_SEGMENT_NAME');
1349: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_SEG_NAME_ERROR');
1350: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_segment_id);
1351: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1352: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1353: --}
1354: END GET_TRIP_SEGMENT_NAME;
1355:
1356: --

Line 1435: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1431: FND_MSG_PUB.initialize;
1432: END IF;
1433:
1434: -- Initialize API return status to success
1435: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1436: x_msg_count := 0;
1437: x_msg_data := 0;
1438:
1439: l_trip_id := GET_TRIP_BY_TENDER_NUMBER(p_tender_number);

Line 1445: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1441: IF (l_trip_id = -9999)
1442: THEN
1443: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_TEND_NUM_NOTRIP');
1444: FND_MESSAGE.SET_TOKEN('TENDER_NUMBER',p_tender_number);
1445: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1446: RAISE FND_API.G_EXC_ERROR;
1447: END IF;
1448:
1449: --get the stop information

Line 1578: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_SHIPMENT_INFORMATION');

1574: p_encoded => FND_API.G_FALSE
1575: );
1576: WHEN OTHERS THEN
1577: ROLLBACK TO GET_SHIPMENT_INFORMATION_PUB;
1578: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_SHIPMENT_INFORMATION');
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1580: FND_MSG_PUB.Count_And_Get
1581: (
1582: p_count => x_msg_count,

Line 1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1575: );
1576: WHEN OTHERS THEN
1577: ROLLBACK TO GET_SHIPMENT_INFORMATION_PUB;
1578: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_SHIPMENT_INFORMATION');
1579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1580: FND_MSG_PUB.Count_And_Get
1581: (
1582: p_count => x_msg_count,
1583: p_data => x_msg_data,

Line 1644: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1640: FND_MSG_PUB.initialize;
1641: END IF;
1642:
1643: -- Initialize API return status to success
1644: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1645: x_msg_count := 0;
1646: x_msg_data := 0;
1647:
1648:

Line 1656: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1652:
1653: THEN
1654: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_TEND_NUM_NOTRIP');
1655: FND_MESSAGE.SET_TOKEN('TENDER_NUMBER',p_tender_number);
1656: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1657: RAISE FND_API.G_EXC_ERROR;
1658: END IF;
1659:
1660: l_trip_weight_measure := NULL;

Line 1748: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_INFO_FROM_DLVY');

1744: p_encoded => FND_API.G_FALSE
1745: );
1746: WHEN OTHERS THEN
1747: ROLLBACK TO GET_TRIP_INFO_FROM_DLVY_PUB;
1748: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_INFO_FROM_DLVY');
1749: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1750: FND_MSG_PUB.Count_And_Get
1751: (
1752: p_count => x_msg_count,

Line 1749: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1745: );
1746: WHEN OTHERS THEN
1747: ROLLBACK TO GET_TRIP_INFO_FROM_DLVY_PUB;
1748: wsh_util_core.default_handler('FTE_TRIPS_PVT.GET_TRIP_INFO_FROM_DLVY');
1749: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1750: FND_MSG_PUB.Count_And_Get
1751: (
1752: p_count => x_msg_count,
1753: p_data => x_msg_data,