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

Line 42: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

38: l_api_name CONSTANT VARCHAR2(30) := 'FindServiceRate';
39:
40:
41: -- standard variable for calling subroutines
42: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: l_msg_count NUMBER := 0;
44: l_msg_data VARCHAR2(2000) := NULL;
45: l_msg_summary VARCHAR2(2000) := NULL;
46: l_msg_details VARCHAR2(4000) := NULL;

Line 126: IF NOT FND_API.compatible_api_call( l_api_version,

122: END IF;
123: --
124: L_OUTPUT.delete;
125: -- Standard call to check for call compatibility.
126: IF NOT FND_API.compatible_api_call( l_api_version,
127: p_api_version,
128: l_api_name,
129: G_PKG_NAME) THEN
130: IF l_debug_on THEN

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

129: G_PKG_NAME) THEN
130: IF l_debug_on THEN
131: WSH_DEBUG_SV.log(l_module_name,'Not Compatible');
132: END IF;
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135:
136: -- Check p_init_msg_list
137: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 137: IF FND_API.to_boolean(p_init_msg_list) THEN

133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: END IF;
135:
136: -- Check p_init_msg_list
137: IF FND_API.to_boolean(p_init_msg_list) THEN
138: FND_MSG_PUB.initialize;
139: END IF;
140:
141: -- initialize API return status to success

Line 142: x_return_status := FND_API.G_RET_STS_SUCCESS;

138: FND_MSG_PUB.initialize;
139: END IF;
140:
141: -- initialize API return status to success
142: x_return_status := FND_API.G_RET_STS_SUCCESS;
143:
144: x_msg_count := 0;
145: x_msg_data := NULL;
146:

Line 155: p_init_msg_list => FND_API.G_TRUE,

151: l_request_in := p_request_in;
152:
153: L_UPS_URL := WSH_U_UTIL.Get_Carrier_API_URL(
154: p_api_version => 1.0,
155: p_init_msg_list => FND_API.G_TRUE,
156: x_return_status => l_return_status,
157: x_msg_count => l_msg_count,
158: x_msg_data => l_msg_data,
159: p_Carrier_Name => 'UPS',

Line 161: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

157: x_msg_count => l_msg_count,
158: x_msg_data => l_msg_data,
159: p_Carrier_Name => 'UPS',
160: p_API_Name => 'RATING_AND_SERVICE_SELECTION');
161: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
162: raise WSH_U_CAR_URL;
163: end if;
164:
165: -- constructing the request sent to UPS API

Line 412: l_return_status := FND_API.G_RET_STS_SUCCESS;

408: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,651,50));
409: WSH_DEBUG_SV.log(l_module_name,'Input',SUBSTR(L_INPUT_STR,701,50));
410: END IF;
411: -- clear variables before calling subroutine
412: l_return_status := FND_API.G_RET_STS_SUCCESS;
413: l_msg_count := 0;
414: l_msg_data := NULL;
415:
416: -- get proxy server URL

Line 420: p_init_msg_list => FND_API.G_TRUE,

416: -- get proxy server URL
417: --
418: L_INTERNET_PROXY := WSH_U_UTIL.Get_PROXY(
419: p_api_version => 1.0,
420: p_init_msg_list => FND_API.G_TRUE,
421: x_return_status => l_return_status,
422: x_msg_count => l_msg_count,
423: x_msg_data => l_msg_data);
424:

Line 425: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

421: x_return_status => l_return_status,
422: x_msg_count => l_msg_count,
423: x_msg_data => l_msg_data);
424:
425: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
426: raise WSH_U_PROXY;
427: end if;
428:
429: -- send request to UPS site

Line 540: x_return_status := FND_API.G_RET_STS_ERROR;

536: /* FND_MESSAGE.SET_NAME('WSH',L_OUTPUT(l_outrec_index).MessageText);
537: WSH_UTIL_CORE.Add_Message('E',l_module_name);
538: */
539: -- Bug #2993856 : Adding the error message to the message stack
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_E');
542: FND_MESSAGE.SET_TOKEN('MSG_TEXT',L_OUTPUT(l_outrec_index).MessageText);
543: WSH_UTIL_CORE.Add_Message(p_message_type);
544: L_OUTPUT(l_outrec_index).ActionCode := NULL;

Line 564: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

560: EXIT WHEN L_Locate_Begin = 0;
561:
562: END LOOP;
563: -- Bug 2993856: Handling the error message returned by the HOST. This exception sends the error text returned from the HOST
564: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
565: raise WSH_U_HOST_FAILED;
566: END IF;
567:
568: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);

Line 583: x_return_status := FND_API.G_RET_STS_ERROR;

579:
580: WHEN WSH_U_CAR_URL THEN
581: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CAR_URL');
582: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
585: if x_msg_count > 1 then
586: x_msg_data := l_msg_summary || l_msg_details;
587: else

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

597: return L_OUTPUT;
598: WHEN WSH_U_PROXY THEN
599: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
600: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
603: if x_msg_count > 1 then
604: x_msg_data := l_msg_summary || l_msg_details;
605: else

Line 624: x_return_status := FND_API.G_RET_STS_ERROR;

620: -- as a URL because it is NULL or has non-HTTP syntax)
621: WHEN REQUEST_FAILED THEN
622: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_REQ_FAILED');
623: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
624: x_return_status := FND_API.G_RET_STS_ERROR;
625: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
626: if x_msg_count > 1 then
627: x_msg_data := l_msg_summary || l_msg_details;
628: else

Line 646: x_return_status := FND_API.G_RET_STS_ERROR;

642: -- for invironmental reasons such as lack of available memory
643: WHEN INIT_FAILED THEN
644: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INIT_FAILED');
645: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
646: x_return_status := FND_API.G_RET_STS_ERROR;
647: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
648: if x_msg_count > 1 then
649: x_msg_data := l_msg_summary || l_msg_details;
650: else

Line 664: x_return_status := FND_API.G_RET_STS_ERROR;

660: return L_OUTPUT;
661: WHEN WSH_U_NO_HOST THEN
662: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_NO_HOST');
663: WSH_UTIL_CORE.ADD_MESSAGE('E',l_module_name);
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
666: if x_msg_count > 1 then
667: x_msg_data := l_msg_summary || l_msg_details;
668: else

Line 682: x_return_status := FND_API.G_RET_STS_ERROR;

678: return L_OUTPUT;
679: WHEN WSH_U_APPVER THEN
680: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_APPVER');
681: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
682: x_return_status := FND_API.G_RET_STS_ERROR;
683: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
684: if x_msg_count > 1 then
685: x_msg_data := l_msg_summary || l_msg_details;
686: else

Line 700: x_return_status := FND_API.G_RET_STS_ERROR;

696: return L_OUTPUT;
697: WHEN WSH_U_LICAGRE THEN
698: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_LICAGRE');
699: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
702: if x_msg_count > 1 then
703: x_msg_data := l_msg_summary || l_msg_details;
704: else

Line 718: x_return_status := FND_API.G_RET_STS_ERROR;

714: return L_OUTPUT;
715: WHEN WSH_U_RESTYP THEN
716: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RESTYP');
717: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
720: if x_msg_count > 1 then
721: x_msg_data := l_msg_summary || l_msg_details;
722: else

Line 736: x_return_status := FND_API.G_RET_STS_ERROR;

732: return L_OUTPUT;
733: WHEN WSH_U_ACTIONCODE THEN
734: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_ACTIONCODE');
735: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
736: x_return_status := FND_API.G_RET_STS_ERROR;
737: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
738: if x_msg_count > 1 then
739: x_msg_data := l_msg_summary || l_msg_details;
740: else

Line 754: x_return_status := FND_API.G_RET_STS_ERROR;

750: return L_OUTPUT;
751: WHEN WSH_U_SRVLEVCODE THEN
752: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_SRVLEVCODE');
753: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
756: if x_msg_count > 1 then
757: x_msg_data := l_msg_summary || l_msg_details;
758: else

Line 772: x_return_status := FND_API.G_RET_STS_ERROR;

768: return L_OUTPUT;
769: WHEN WSH_U_RATECHART THEN
770: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RATECHART');
771: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
774: if x_msg_count > 1 then
775: x_msg_data := l_msg_summary || l_msg_details;
776: else

Line 790: x_return_status := FND_API.G_RET_STS_ERROR;

786: return L_OUTPUT;
787: WHEN WSH_U_SPOSTALCODE THEN
788: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_SPOSTALCODE');
789: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
792: if x_msg_count > 1 then
793: x_msg_data := l_msg_summary || l_msg_details;
794: else

Line 808: x_return_status := FND_API.G_RET_STS_ERROR;

804: return L_OUTPUT;
805: WHEN WSH_U_CPOSTALCODE THEN
806: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CPOSTALCODE');
807: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
808: x_return_status := FND_API.G_RET_STS_ERROR;
809: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
810: if x_msg_count > 1 then
811: x_msg_data := l_msg_summary || l_msg_details;
812: else

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822: return L_OUTPUT;
823: WHEN WSH_U_CCOUNTRY THEN
824: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CCOUNTRY');
825: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
828: if x_msg_count > 1 then
829: x_msg_data := l_msg_summary || l_msg_details;
830: else

Line 844: x_return_status := FND_API.G_RET_STS_ERROR;

840: return L_OUTPUT;
841: WHEN WSH_U_PKGACTWT THEN
842: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PKGACTWT');
843: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
844: x_return_status := FND_API.G_RET_STS_ERROR;
845: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
846: if x_msg_count > 1 then
847: x_msg_data := l_msg_summary || l_msg_details;
848: else

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: return L_OUTPUT;
859: WHEN WSH_U_RESDIND THEN
860: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RESDIND');
861: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
864: if x_msg_count > 1 then
865: x_msg_data := l_msg_summary || l_msg_details;
866: else

Line 880: x_return_status := FND_API.G_RET_STS_ERROR;

876: return L_OUTPUT;
877: WHEN WSH_U_PKGTYPE THEN
878: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PKGTYPE');
879: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type,l_module_name);
880: x_return_status := FND_API.G_RET_STS_ERROR;
881: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
882: if x_msg_count > 1 then
883: x_msg_data := l_msg_summary || l_msg_details;
884: else

Line 915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

911: END IF;
912: --
913: return L_OUTPUT;
914:
915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: IF FND_MSG_PUB.check_msg_level
918: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN

Line 916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

912: --
913: return L_OUTPUT;
914:
915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: IF FND_MSG_PUB.check_msg_level
918: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

921: END IF;
922: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
923: --
924: IF l_debug_on THEN
925: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
926: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
927: END IF;
928: --
929: return L_OUTPUT;

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

922: FND_MSG_PUB.count_and_get ( p_count => x_msg_count, p_data => x_msg_data);
923: --
924: IF l_debug_on THEN
925: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
926: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
927: END IF;
928: --
929: return L_OUTPUT;
930: WHEN OTHERS THEN

Line 931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

927: END IF;
928: --
929: return L_OUTPUT;
930: WHEN OTHERS THEN
931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
932: IF FND_MSG_PUB.check_msg_level
933: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);