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_ESTIMATE_FREIGHT_RATE dependencies on WSH_UTIL_CORE

Line 200: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

196: WSH_DEBUG_SV.log(l_module_name,'Begin of the process ',l_debugfile);
197:
198: END IF;
199: --
200: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
201:
202: -- delete to refresh the data from Global Temp Table
203: delete from FTE_FREIGHT_ESTIMATE_TEMP;
204: -- initialize old message from stack

Line 681: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

677: --commit;
678: EXCEPTION
679: WHEN e_org_is_too_long then
680: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_TOO_LONG');
681: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
682: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
683:
684: WHEN e_dest_is_too_long then
685: FND_MESSAGE.SET_NAME('FTE','FTE_DEST_TOO_LONG');

Line 682: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

678: EXCEPTION
679: WHEN e_org_is_too_long then
680: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_TOO_LONG');
681: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
682: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
683:
684: WHEN e_dest_is_too_long then
685: FND_MESSAGE.SET_NAME('FTE','FTE_DEST_TOO_LONG');
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 686: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

682: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
683:
684: WHEN e_dest_is_too_long then
685: FND_MESSAGE.SET_NAME('FTE','FTE_DEST_TOO_LONG');
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
687: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
688:
689: WHEN e_org_dest_is_too_long then
690: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_DEST_TOO_LONG');

Line 687: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

683:
684: WHEN e_dest_is_too_long then
685: FND_MESSAGE.SET_NAME('FTE','FTE_DEST_TOO_LONG');
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
687: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
688:
689: WHEN e_org_dest_is_too_long then
690: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_DEST_TOO_LONG');
691: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 691: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

687: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
688:
689: WHEN e_org_dest_is_too_long then
690: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_DEST_TOO_LONG');
691: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
692: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
693:
694: WHEN e_process_lines_api_failed then
695: FND_MESSAGE.SET_NAME('FTE','FTE_PROCESS_LINE_API_FAILED');

Line 692: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

688:
689: WHEN e_org_dest_is_too_long then
690: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_DEST_TOO_LONG');
691: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
692: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
693:
694: WHEN e_process_lines_api_failed then
695: FND_MESSAGE.SET_NAME('FTE','FTE_PROCESS_LINE_API_FAILED');
696: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 696: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

692: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
693:
694: WHEN e_process_lines_api_failed then
695: FND_MESSAGE.SET_NAME('FTE','FTE_PROCESS_LINE_API_FAILED');
696: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
697: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
698: --dbms_output.put_line('API FTE_PROCESS_LINE_API_FAILED call failed '||sqlerrm );
699:
700: WHEN e_invalid_service_level THEN

Line 697: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

693:
694: WHEN e_process_lines_api_failed then
695: FND_MESSAGE.SET_NAME('FTE','FTE_PROCESS_LINE_API_FAILED');
696: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
697: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
698: --dbms_output.put_line('API FTE_PROCESS_LINE_API_FAILED call failed '||sqlerrm );
699:
700: WHEN e_invalid_service_level THEN
701: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_SERVICE_LEVEL');

Line 702: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

698: --dbms_output.put_line('API FTE_PROCESS_LINE_API_FAILED call failed '||sqlerrm );
699:
700: WHEN e_invalid_service_level THEN
701: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_SERVICE_LEVEL');
702: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
703: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
704:
705: WHEN e_invalid_mode_of_transport THEN
706: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_MODE');

Line 703: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

699:
700: WHEN e_invalid_service_level THEN
701: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_SERVICE_LEVEL');
702: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
703: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
704:
705: WHEN e_invalid_mode_of_transport THEN
706: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_MODE');
707: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 707: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

703: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
704:
705: WHEN e_invalid_mode_of_transport THEN
706: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_MODE');
707: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
708: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
709:
710: WHEN e_invalid_carrier THEN
711: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_CARRIER');

Line 708: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

704:
705: WHEN e_invalid_mode_of_transport THEN
706: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_MODE');
707: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
708: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
709:
710: WHEN e_invalid_carrier THEN
711: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_CARRIER');
712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

708: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
709:
710: WHEN e_invalid_carrier THEN
711: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_CARRIER');
712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
713: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
714:
715: WHEN e_invalid_vehicle THEN
716: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_VEHICLE');

Line 713: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

709:
710: WHEN e_invalid_carrier THEN
711: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_CARRIER');
712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
713: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
714:
715: WHEN e_invalid_vehicle THEN
716: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_VEHICLE');
717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

713: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
714:
715: WHEN e_invalid_vehicle THEN
716: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_VEHICLE');
717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
718: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
719:
720: WHEN e_failed_split_csz_api THEN
721: FND_MESSAGE.SET_NAME('FTE','FTE_FAILED_SPLIT_CSZ_API');

Line 718: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

714:
715: WHEN e_invalid_vehicle THEN
716: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_VEHICLE');
717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
718: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
719:
720: WHEN e_failed_split_csz_api THEN
721: FND_MESSAGE.SET_NAME('FTE','FTE_FAILED_SPLIT_CSZ_API');
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

718: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
719:
720: WHEN e_failed_split_csz_api THEN
721: FND_MESSAGE.SET_NAME('FTE','FTE_FAILED_SPLIT_CSZ_API');
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
723: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
724:
725: WHEN e_no_data_found THEN
726: FND_MESSAGE.SET_NAME('FTE','FTE_NO_RATE_EXISTS');

Line 723: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

719:
720: WHEN e_failed_split_csz_api THEN
721: FND_MESSAGE.SET_NAME('FTE','FTE_FAILED_SPLIT_CSZ_API');
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
723: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
724:
725: WHEN e_no_data_found THEN
726: FND_MESSAGE.SET_NAME('FTE','FTE_NO_RATE_EXISTS');
727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

723: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
724:
725: WHEN e_no_data_found THEN
726: FND_MESSAGE.SET_NAME('FTE','FTE_NO_RATE_EXISTS');
727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
728: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
729:
730: WHEN others then
731: wsh_util_core.default_handler('FTE_ESTIMATE_FREIGHT_RATE.RATE_SEARCH');

Line 728: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

724:
725: WHEN e_no_data_found THEN
726: FND_MESSAGE.SET_NAME('FTE','FTE_NO_RATE_EXISTS');
727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
728: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
729:
730: WHEN others then
731: wsh_util_core.default_handler('FTE_ESTIMATE_FREIGHT_RATE.RATE_SEARCH');
732: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 731: wsh_util_core.default_handler('FTE_ESTIMATE_FREIGHT_RATE.RATE_SEARCH');

727: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
728: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
729:
730: WHEN others then
731: wsh_util_core.default_handler('FTE_ESTIMATE_FREIGHT_RATE.RATE_SEARCH');
732: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
733: --dbms_output.put_line('Unhandled Exception '||sqlerrm );
734: END;
735:

Line 732: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

728: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
729:
730: WHEN others then
731: wsh_util_core.default_handler('FTE_ESTIMATE_FREIGHT_RATE.RATE_SEARCH');
732: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
733: --dbms_output.put_line('Unhandled Exception '||sqlerrm );
734: END;
735:
736: /* This API will be used to split city_state_zip into city state zip