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.

[Home] [Help]

APPS.WSH_U_GTT dependencies on FND_API

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

32: l_api_version CONSTANT NUMBER := 1.0;
33: l_api_name CONSTANT VARCHAR2(30) := 'Time_In_Tansit';
34:
35: -- standard variables
36: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
37: l_msg_count NUMBER := 0;
38: l_msg_data VARCHAR2(2000) := NULL;
39: l_msg_summary VARCHAR2(2000) := NULL;
40: l_msg_details VARCHAR2(4000) := NULL;

Line 122: IF NOT FND_API.compatible_api_call

118: WSH_DEBUG_SV.log(l_module_name,'P_ORIGINNUMBER',p_tnt_request_in.ORIGINNUMBER);
119: WSH_DEBUG_SV.log(l_module_name,'P_DESTINATIONNUMBER',p_tnt_request_in.DESTINATIONNUMBER);
120: END IF;
121: --
122: IF NOT FND_API.compatible_api_call
123: ( l_api_version
124: , p_api_version
125: , l_api_name
126: , G_PKG_NAME)

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124: , p_api_version
125: , l_api_name
126: , G_PKG_NAME)
127: THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130:
131: -- Check p_init_msg_list
132: IF FND_API.to_boolean(p_init_msg_list)

Line 132: IF FND_API.to_boolean(p_init_msg_list)

128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130:
131: -- Check p_init_msg_list
132: IF FND_API.to_boolean(p_init_msg_list)
133: THEN
134: FND_MSG_PUB.initialize;
135: END IF;
136:

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: FND_MSG_PUB.initialize;
135: END IF;
136:
137: -- initialize API return status to success
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: x_msg_count := 0;
140: x_msg_data := NULL;
141: -- program specific logic begins here
142: --

Line 173: IF l_return_status = FND_API.G_RET_STS_SUCCESS

169: , x_msg_data => l_msg_data
170: , x_return_status =>l_return_status);
171:
172: -- dbms_output.put_line('l_return_status :'||l_return_status);
173: IF l_return_status = FND_API.G_RET_STS_SUCCESS
174: THEN
175: x_timeintransit_out := l_timeintransit_out;
176: ELSE
177: x_return_status := l_return_status;

Line 197: p_init_msg_list => FND_API.G_TRUE,

193: END IF;
194: --
195: L_UPS_URL := WSH_U_UTIL.Get_Carrier_API_URL(
196: p_api_version => 1.0,
197: p_init_msg_list => FND_API.G_TRUE,
198: x_return_status => l_return_status,
199: x_msg_count => l_msg_count,
200: x_msg_data => l_msg_data,
201: p_Carrier_Name => 'UPS',

Line 203: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

199: x_msg_count => l_msg_count,
200: x_msg_data => l_msg_data,
201: p_Carrier_Name => 'UPS',
202: p_API_Name => 'TIME_IN_TRANSIT');
203: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
204: raise WSH_U_CAR_URL;
205: end if;
206:
207:

Line 268: l_return_status := FND_API.G_RET_STS_SUCCESS;

264: -- DBMS_OUTPUT.PUT_LINE(SUBSTR(L_INPUT_STR,251,50));
265: -- DBMS_OUTPUT.PUT_LINE('========== request end =========');
266:
267: -- clear variables before calling subroutine
268: l_return_status := FND_API.G_RET_STS_SUCCESS;
269: l_msg_count := 0;
270: l_msg_data := NULL;
271:
272:

Line 283: p_init_msg_list => FND_API.G_TRUE,

279: END IF;
280: --
281: L_INTERNET_PROXY := WSH_U_UTIL.Get_PROXY(
282: p_api_version => 1.0,
283: p_init_msg_list => FND_API.G_TRUE,
284: x_return_status => l_return_status,
285: x_msg_count => l_msg_count,
286: x_msg_data => l_msg_data);
287:

Line 288: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

284: x_return_status => l_return_status,
285: x_msg_count => l_msg_count,
286: x_msg_data => l_msg_data);
287:
288: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
289: raise WSH_U_PROXY;
290: end if;
291: -- send request to UPS site
292: if L_INTERNET_PROXY is not NULL then

Line 510: x_return_status := FND_API.G_RET_STS_ERROR;

506: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_SHIPFROMTO');
507: FND_MESSAGE.SET_TOKEN('MSG_TEXT','Ship to/from Location Id IS null');
508: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
509:
510: x_return_status := FND_API.G_RET_STS_ERROR;
511: WSH_UTIL_CORE.get_messages
512: ( 'Y'
513: , l_msg_summary
514: , l_msg_details

Line 535: x_return_status := FND_API.G_RET_STS_ERROR;

531: /* Commented for Carrier Services Integration with Shipping project Bug 16095594
532: WHEN WSH_U_CAR_URL THEN
533: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CAR_URL');
534: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
537: if x_msg_count > 1 then
538: x_msg_data := l_msg_summary || l_msg_details;
539: else

Line 554: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 577: x_return_status := FND_API.G_RET_STS_ERROR;

573: --
574: WHEN REQUEST_FAILED THEN
575: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_REQ_FAILED');
576: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
577: x_return_status := FND_API.G_RET_STS_ERROR;
578: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
579: if x_msg_count > 1 then
580: x_msg_data := l_msg_summary || l_msg_details;
581: else

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595: --
596: WHEN INIT_FAILED THEN
597: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INIT_FAILED');
598: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
601: if x_msg_count > 1 then
602: x_msg_data := l_msg_summary || l_msg_details;
603: else

Line 618: x_return_status := FND_API.G_RET_STS_ERROR;

614: --
615: WHEN WSH_U_NO_HOST THEN
616: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_NO_HOST');
617: WSH_UTIL_CORE.ADD_MESSAGE('E');
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
620: if x_msg_count > 1 then
621: x_msg_data := l_msg_summary || l_msg_details;
622: else

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634: --
635: WHEN WSH_U_APPVER THEN
636: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_APPVER');
637: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
640: if x_msg_count > 1 then
641: x_msg_data := l_msg_summary || l_msg_details;
642: else

Line 657: x_return_status := FND_API.G_RET_STS_ERROR;

653: --
654: WHEN WSH_U_LICAGRE THEN
655: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_LICAGRE');
656: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
657: x_return_status := FND_API.G_RET_STS_ERROR;
658:
659:
660: --
661: -- Debug Statements

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

667: --
668: WHEN WSH_U_RESTYP THEN
669: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RESTYP');
670: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
673: if x_msg_count > 1 then
674: x_msg_data := l_msg_summary || l_msg_details;
675: else

Line 690: x_return_status := FND_API.G_RET_STS_ERROR;

686: --
687: WHEN WSH_U_ORIGINNUM THEN
688: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_ORIGINNUM');
689: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
692: if x_msg_count > 1 then
693: x_msg_data := l_msg_summary || l_msg_details;
694: else

Line 709: x_return_status := FND_API.G_RET_STS_ERROR;

705: --
706: WHEN WSH_U_DESTINATIONNUM THEN
707: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_DESTINATIONNUM');
708: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
711: if x_msg_count > 1 then
712: x_msg_data := l_msg_summary || l_msg_details;
713: else

Line 727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

723: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_DESTINATIONNUM');
724: END IF;
725: --
726: Commented for Carrier Services Integration with Shipping project Bug 16095594 */
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
728: THEN
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN

Line 729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

725: --
726: Commented for Carrier Services Integration with Shipping project Bug 16095594 */
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
728: THEN
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: FND_MSG_PUB.Add_Exc_Msg
733: ( G_PKG_NAME

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

740: -- Debug Statements
741: --
742: IF l_debug_on
743: THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
745: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
746: END IF;
747: --
748: WHEN OTHERS

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

741: --
742: IF l_debug_on
743: THEN
744: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
745: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
746: END IF;
747: --
748: WHEN OTHERS
749: THEN

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

746: END IF;
747: --
748: WHEN OTHERS
749: THEN
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
752: THEN
753: FND_MSG_PUB.Add_Exc_Msg
754: ( G_PKG_NAME