DBA Data[Home] [Help]

APPS.WSH_U_TRACK dependencies on FND_API

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

46: l_api_version CONSTANT NUMBER := 1.0;
47: l_api_name CONSTANT VARCHAR2(30) := 'EnhancedTracking';
48:
49: -- standard variables
50: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
51: l_msg_count NUMBER := 0;
52: l_msg_data VARCHAR2(2000) := NULL;
53: l_msg_summary VARCHAR2(2000) := NULL;
54: l_msg_details VARCHAR2(4000) := NULL;

Line 149: IF NOT FND_API.compatible_api_call( l_api_version,

145: WSH_DEBUG_SV.log(l_module_name,'P_ACCEPTLICENSEAGREEMENT',P_ACCEPTLICENSEAGREEMENT);
146: WSH_DEBUG_SV.log(l_module_name,'P_RESPONSETYPE',P_RESPONSETYPE);
147: END IF;
148: --
149: IF NOT FND_API.compatible_api_call( l_api_version,
150: p_api_version,
151: l_api_name,
152: G_PKG_NAME) THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: IF NOT FND_API.compatible_api_call( l_api_version,
150: p_api_version,
151: l_api_name,
152: G_PKG_NAME) THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: -- Check p_init_msg_list
157: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 157: IF FND_API.to_boolean(p_init_msg_list) THEN

153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: -- Check p_init_msg_list
157: IF FND_API.to_boolean(p_init_msg_list) THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160:
161: -- initialize API return status to success

Line 162: x_return_status := FND_API.G_RET_STS_SUCCESS;

158: FND_MSG_PUB.initialize;
159: END IF;
160:
161: -- initialize API return status to success
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163:
164: x_msg_count := 0;
165: x_msg_data := NULL;
166:

Line 183: p_init_msg_list => FND_API.G_TRUE,

179: END IF;
180: --
181: L_UPS_URL := WSH_U_UTIL.Get_Carrier_API_URL(
182: p_api_version => 1.0,
183: p_init_msg_list => FND_API.G_TRUE,
184: x_return_status => l_return_status,
185: x_msg_count => l_msg_count,
186: x_msg_data => l_msg_data,
187: p_Carrier_Name => 'UPS',

Line 189: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

185: x_msg_count => l_msg_count,
186: x_msg_data => l_msg_data,
187: p_Carrier_Name => 'UPS',
188: p_API_Name => 'ENHANCED_TRACKING');
189: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
190: raise WSH_U_CAR_URL;
191: end if;
192:
193: L_INPUT_STR := L_UPS_URL || '?';

Line 299: l_return_status := FND_API.G_RET_STS_SUCCESS;

295: -- DBMS_OUTPUT.PUT_LINE(SUBSTR(L_INPUT_STR,251,50));
296: -- DBMS_OUTPUT.PUT_LINE('========== request end =========');
297:
298: -- clear variables before calling subroutine
299: l_return_status := FND_API.G_RET_STS_SUCCESS;
300: l_msg_count := 0;
301: l_msg_data := NULL;
302:
303:

Line 314: p_init_msg_list => FND_API.G_TRUE,

310: END IF;
311: --
312: L_INTERNET_PROXY := WSH_U_UTIL.Get_PROXY(
313: p_api_version => 1.0,
314: p_init_msg_list => FND_API.G_TRUE,
315: x_return_status => l_return_status,
316: x_msg_count => l_msg_count,
317: x_msg_data => l_msg_data);
318:

Line 319: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

315: x_return_status => l_return_status,
316: x_msg_count => l_msg_count,
317: x_msg_data => l_msg_data);
318:
319: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
320: raise WSH_U_PROXY;
321: end if;
322:
323: -- send request to UPS site

Line 585: x_return_status := FND_API.G_RET_STS_ERROR;

581:
582: x_msg_count := 1;
583: x_msg_data := 'Message ' || x_track_error.MessageNumber
584: || ': ' || x_track_error.MessageText;
585: x_return_status := FND_API.G_RET_STS_ERROR;
586:
587: -- DBMS_OUTPUT.PUT_LINE('=== === x-ups-error ===');
588: elsif(SUBSTR(L_Content_Type,1,LENGTH('x-ups-address')) = 'x-ups-address') then
589: -- DBMS_OUTPUT.PUT_LINE('=== === x-ups-address ===');

Line 1204: x_return_status := FND_API.G_RET_STS_ERROR;

1200:
1201: WHEN WSH_U_CAR_URL THEN
1202: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CAR_URL');
1203: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1204: x_return_status := FND_API.G_RET_STS_ERROR;
1205: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1206: if x_msg_count > 1 then
1207: x_msg_data := l_msg_summary || l_msg_details;
1208: else

Line 1223: x_return_status := FND_API.G_RET_STS_ERROR;

1219: --
1220: WHEN WSH_U_PROXY THEN
1221: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_PROXY');
1222: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1223: x_return_status := FND_API.G_RET_STS_ERROR;
1224: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1225: if x_msg_count > 1 then
1226: x_msg_data := l_msg_summary || l_msg_details;
1227: else

Line 1246: x_return_status := FND_API.G_RET_STS_ERROR;

1242: --
1243: WHEN REQUEST_FAILED THEN
1244: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_REQ_FAILED');
1245: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1246: x_return_status := FND_API.G_RET_STS_ERROR;
1247: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1248: if x_msg_count > 1 then
1249: x_msg_data := l_msg_summary || l_msg_details;
1250: else

Line 1268: x_return_status := FND_API.G_RET_STS_ERROR;

1264: --
1265: WHEN INIT_FAILED THEN
1266: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INIT_FAILED');
1267: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1270: if x_msg_count > 1 then
1271: x_msg_data := l_msg_summary || l_msg_details;
1272: else

Line 1287: x_return_status := FND_API.G_RET_STS_ERROR;

1283: --
1284: WHEN WSH_U_NO_HOST THEN
1285: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_NO_HOST');
1286: WSH_UTIL_CORE.ADD_MESSAGE('E');
1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1289: if x_msg_count > 1 then
1290: x_msg_data := l_msg_summary || l_msg_details;
1291: else

Line 1306: x_return_status := FND_API.G_RET_STS_ERROR;

1302: --
1303: WHEN WSH_U_APPVER THEN
1304: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_APPVER');
1305: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1306: x_return_status := FND_API.G_RET_STS_ERROR;
1307: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1308: if x_msg_count > 1 then
1309: x_msg_data := l_msg_summary || l_msg_details;
1310: else

Line 1327: x_return_status := FND_API.G_RET_STS_ERROR;

1323: --
1324: WHEN WSH_U_LICAGRE THEN
1325: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_LICAGRE');
1326: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1329: if x_msg_count > 1 then
1330: x_msg_data := l_msg_summary || l_msg_details;
1331: else

Line 1348: x_return_status := FND_API.G_RET_STS_ERROR;

1344: --
1345: WHEN WSH_U_RESTYP THEN
1346: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RESTYP');
1347: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1350: if x_msg_count > 1 then
1351: x_msg_data := l_msg_summary || l_msg_details;
1352: else

Line 1369: x_return_status := FND_API.G_RET_STS_ERROR;

1365: --
1366: WHEN WSH_U_INPUT_PARAMETER THEN
1367: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INPUT_PARAMETER');
1368: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1369: x_return_status := FND_API.G_RET_STS_ERROR;
1370: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1371: if x_msg_count > 1 then
1372: x_msg_data := l_msg_summary || l_msg_details;
1373: else

Line 1390: x_return_status := FND_API.G_RET_STS_ERROR;

1386: --
1387: WHEN WSH_U_INQNO THEN
1388: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INQNO');
1389: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1392: if x_msg_count > 1 then
1393: x_msg_data := l_msg_summary || l_msg_details;
1394: else

Line 1411: x_return_status := FND_API.G_RET_STS_ERROR;

1407: --
1408: WHEN WSH_U_TYP_INQNO THEN
1409: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TYP_INQNO');
1410: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1413: if x_msg_count > 1 then
1414: x_msg_data := l_msg_summary || l_msg_details;
1415: else

Line 1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1424: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_U_TYP_INQNO exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1425: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_TYP_INQNO');
1426: END IF;
1427: --
1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF FND_MSG_PUB.check_msg_level
1431: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: THEN

Line 1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1425: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_TYP_INQNO');
1426: END IF;
1427: --
1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF FND_MSG_PUB.check_msg_level
1431: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1432: THEN
1433: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1438: --
1439: -- Debug Statements
1440: --
1441: IF l_debug_on THEN
1442: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1443: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1444: END IF;
1445: --
1446: WHEN OTHERS THEN

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

1439: -- Debug Statements
1440: --
1441: IF l_debug_on THEN
1442: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1443: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1444: END IF;
1445: --
1446: WHEN OTHERS THEN
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1443: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1444: END IF;
1445: --
1446: WHEN OTHERS THEN
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: IF FND_MSG_PUB.check_msg_level
1449: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1450: THEN
1451: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);