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

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

42: l_api_version CONSTANT NUMBER := 1.0;
43: l_api_name CONSTANT VARCHAR2(30) := 'Time_In_Tansit';
44:
45: -- standard variables
46: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
47: l_msg_count NUMBER := 0;
48: l_msg_data VARCHAR2(2000) := NULL;
49: l_msg_summary VARCHAR2(2000) := NULL;
50: l_msg_details VARCHAR2(4000) := NULL;

Line 128: IF NOT FND_API.compatible_api_call( l_api_version,

124: WSH_DEBUG_SV.log(l_module_name,'P_ORIGINNUMBER',P_ORIGINNUMBER);
125: WSH_DEBUG_SV.log(l_module_name,'P_DESTINATIONNUMBER',P_DESTINATIONNUMBER);
126: END IF;
127: --
128: IF NOT FND_API.compatible_api_call( l_api_version,
129: p_api_version,
130: l_api_name,
131: G_PKG_NAME) THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

128: IF NOT FND_API.compatible_api_call( l_api_version,
129: p_api_version,
130: l_api_name,
131: G_PKG_NAME) THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:
135: -- Check p_init_msg_list
136: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 136: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 141: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 159: p_init_msg_list => FND_API.G_TRUE,

155: END IF;
156: --
157: L_UPS_URL := WSH_U_UTIL.Get_Carrier_API_URL(
158: p_api_version => 1.0,
159: p_init_msg_list => FND_API.G_TRUE,
160: x_return_status => l_return_status,
161: x_msg_count => l_msg_count,
162: x_msg_data => l_msg_data,
163: p_Carrier_Name => 'UPS',

Line 165: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

161: x_msg_count => l_msg_count,
162: x_msg_data => l_msg_data,
163: p_Carrier_Name => 'UPS',
164: p_API_Name => 'TIME_IN_TRANSIT');
165: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
166: raise WSH_U_CAR_URL;
167: end if;
168:
169:

Line 230: l_return_status := FND_API.G_RET_STS_SUCCESS;

226: -- DBMS_OUTPUT.PUT_LINE(SUBSTR(L_INPUT_STR,251,50));
227: -- DBMS_OUTPUT.PUT_LINE('========== request end =========');
228:
229: -- clear variables before calling subroutine
230: l_return_status := FND_API.G_RET_STS_SUCCESS;
231: l_msg_count := 0;
232: l_msg_data := NULL;
233:
234:

Line 245: p_init_msg_list => FND_API.G_TRUE,

241: END IF;
242: --
243: L_INTERNET_PROXY := WSH_U_UTIL.Get_PROXY(
244: p_api_version => 1.0,
245: p_init_msg_list => FND_API.G_TRUE,
246: x_return_status => l_return_status,
247: x_msg_count => l_msg_count,
248: x_msg_data => l_msg_data);
249:

Line 250: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

246: x_return_status => l_return_status,
247: x_msg_count => l_msg_count,
248: x_msg_data => l_msg_data);
249:
250: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
251: raise WSH_U_PROXY;
252: end if;
253: -- send request to UPS site
254: if L_INTERNET_PROXY is not NULL then

Line 470: x_return_status := FND_API.G_RET_STS_ERROR;

466:
467: WHEN WSH_U_CAR_URL THEN
468: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CAR_URL');
469: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
472: if x_msg_count > 1 then
473: x_msg_data := l_msg_summary || l_msg_details;
474: else

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485: --
486: WHEN WSH_U_PROXY THEN
487: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
488: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
491: if x_msg_count > 1 then
492: x_msg_data := l_msg_summary || l_msg_details;
493: else

Line 512: x_return_status := FND_API.G_RET_STS_ERROR;

508: --
509: WHEN REQUEST_FAILED THEN
510: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_REQ_FAILED');
511: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
514: if x_msg_count > 1 then
515: x_msg_data := l_msg_summary || l_msg_details;
516: else

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: --
531: WHEN INIT_FAILED THEN
532: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INIT_FAILED');
533: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
536: if x_msg_count > 1 then
537: x_msg_data := l_msg_summary || l_msg_details;
538: else

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549: --
550: WHEN WSH_U_NO_HOST THEN
551: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_NO_HOST');
552: WSH_UTIL_CORE.ADD_MESSAGE('E');
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
555: if x_msg_count > 1 then
556: x_msg_data := l_msg_summary || l_msg_details;
557: else

Line 573: x_return_status := FND_API.G_RET_STS_ERROR;

569: --
570: WHEN WSH_U_APPVER THEN
571: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_APPVER');
572: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
575: if x_msg_count > 1 then
576: x_msg_data := l_msg_summary || l_msg_details;
577: else

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588: --
589: WHEN WSH_U_LICAGRE THEN
590: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_LICAGRE');
591: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
592: x_return_status := FND_API.G_RET_STS_ERROR;
593:
594:
595: --
596: -- Debug Statements

Line 606: x_return_status := FND_API.G_RET_STS_ERROR;

602: --
603: WHEN WSH_U_RESTYP THEN
604: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RESTYP');
605: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
608: if x_msg_count > 1 then
609: x_msg_data := l_msg_summary || l_msg_details;
610: else

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

621: --
622: WHEN WSH_U_ORIGINNUM THEN
623: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_ORIGINNUM');
624: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
627: if x_msg_count > 1 then
628: x_msg_data := l_msg_summary || l_msg_details;
629: else

Line 644: x_return_status := FND_API.G_RET_STS_ERROR;

640: --
641: WHEN WSH_U_DESTINATIONNUM THEN
642: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_DESTINATIONNUM');
643: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
646: if x_msg_count > 1 then
647: x_msg_data := l_msg_summary || l_msg_details;
648: else

Line 661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

657: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_DESTINATIONNUM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_DESTINATIONNUM');
659: END IF;
660: --
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF FND_MSG_PUB.check_msg_level
664: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
665: THEN

Line 662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_DESTINATIONNUM');
659: END IF;
660: --
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF FND_MSG_PUB.check_msg_level
664: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
665: THEN
666: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

670: --
671: -- Debug Statements
672: --
673: IF l_debug_on THEN
674: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
675: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
676: END IF;
677: --
678: WHEN OTHERS THEN

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

671: -- Debug Statements
672: --
673: IF l_debug_on THEN
674: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
675: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
676: END IF;
677: --
678: WHEN OTHERS THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

675: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
676: END IF;
677: --
678: WHEN OTHERS THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: IF FND_MSG_PUB.check_msg_level
681: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
682: THEN
683: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);