DBA Data[Home] [Help]

APPS.WSH_U_TRACK dependencies on FND_API

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

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

Line 152: IF NOT FND_API.compatible_api_call

148: WSH_DEBUG_SV.log(l_module_name,'P_RESPONSETYPE',P_RESPONSETYPE);
149: END IF;
150:
151: --
152: IF NOT FND_API.compatible_api_call
153: ( l_api_version
154: , p_api_version
155: , l_api_name
156: , G_PKG_NAME)

Line 158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

154: , p_api_version
155: , l_api_name
156: , G_PKG_NAME)
157: THEN
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: END IF;
160:
161: -- Check p_init_msg_list
162: IF FND_API.to_boolean(p_init_msg_list)

Line 162: IF FND_API.to_boolean(p_init_msg_list)

158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: END IF;
160:
161: -- Check p_init_msg_list
162: IF FND_API.to_boolean(p_init_msg_list)
163: THEN
164: FND_MSG_PUB.initialize;
165: END IF;
166:

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: FND_MSG_PUB.initialize;
165: END IF;
166:
167: -- initialize API return status to success
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169: x_msg_count := 0;
170: x_msg_data := NULL;
171:
172: -- program specific logic begins here

Line 196: IF l_return_status = FND_API.G_RET_STS_SUCCESS

192: , x_msg_data => l_msg_data
193: , x_return_status => l_return_status);
194:
195:
196: IF l_return_status = FND_API.G_RET_STS_SUCCESS
197: THEN
198: x_return_status := l_return_status;
199: IF l_debug_on THEN
200: WSH_DEBUG_SV.logmsg(l_module_name,'Service Level is '||x_pkg_detail_segment(1).ServiceLevelDescription);

Line 230: p_init_msg_list => FND_API.G_TRUE,

226: END IF;
227: --
228: L_UPS_URL := WSH_U_UTIL.Get_Carrier_API_URL(
229: p_api_version => 1.0,
230: p_init_msg_list => FND_API.G_TRUE,
231: x_return_status => l_return_status,
232: x_msg_count => l_msg_count,
233: x_msg_data => l_msg_data,
234: p_Carrier_Name => 'UPS',

Line 236: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

232: x_msg_count => l_msg_count,
233: x_msg_data => l_msg_data,
234: p_Carrier_Name => 'UPS',
235: p_API_Name => 'ENHANCED_TRACKING');
236: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
237: raise WSH_U_CAR_URL;
238: end if;
239:
240: L_INPUT_STR := L_UPS_URL || '?';

Line 346: l_return_status := FND_API.G_RET_STS_SUCCESS;

342: -- DBMS_OUTPUT.PUT_LINE(SUBSTR(L_INPUT_STR,251,50));
343: -- DBMS_OUTPUT.PUT_LINE('========== request end =========');
344:
345: -- clear variables before calling subroutine
346: l_return_status := FND_API.G_RET_STS_SUCCESS;
347: l_msg_count := 0;
348: l_msg_data := NULL;
349:
350:

Line 361: p_init_msg_list => FND_API.G_TRUE,

357: END IF;
358: --
359: L_INTERNET_PROXY := WSH_U_UTIL.Get_PROXY(
360: p_api_version => 1.0,
361: p_init_msg_list => FND_API.G_TRUE,
362: x_return_status => l_return_status,
363: x_msg_count => l_msg_count,
364: x_msg_data => l_msg_data);
365:

Line 366: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

362: x_return_status => l_return_status,
363: x_msg_count => l_msg_count,
364: x_msg_data => l_msg_data);
365:
366: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
367: raise WSH_U_PROXY;
368: end if;
369:
370: -- send request to UPS site

Line 632: x_return_status := FND_API.G_RET_STS_ERROR;

628:
629: x_msg_count := 1;
630: x_msg_data := 'Message ' || x_track_error.MessageNumber
631: || ': ' || x_track_error.MessageText;
632: x_return_status := FND_API.G_RET_STS_ERROR;
633:
634: -- DBMS_OUTPUT.PUT_LINE('=== === x-ups-error ===');
635: elsif(SUBSTR(L_Content_Type,1,LENGTH('x-ups-address')) = 'x-ups-address') then
636: -- DBMS_OUTPUT.PUT_LINE('=== === x-ups-address ===');

Line 1251: x_return_status := FND_API.G_RET_STS_ERROR;

1247: /* --Commented for Carrier Services Integration with Shipping project Bug 16095594
1248: WHEN WSH_U_CAR_URL THEN
1249: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_CAR_URL');
1250: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1251: x_return_status := FND_API.G_RET_STS_ERROR;
1252: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1253: if x_msg_count > 1 then
1254: x_msg_data := l_msg_summary || l_msg_details;
1255: else

Line 1270: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1293: x_return_status := FND_API.G_RET_STS_ERROR;

1289: --
1290: WHEN REQUEST_FAILED THEN
1291: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_REQ_FAILED');
1292: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1293: x_return_status := FND_API.G_RET_STS_ERROR;
1294: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1295: if x_msg_count > 1 then
1296: x_msg_data := l_msg_summary || l_msg_details;
1297: else

Line 1315: x_return_status := FND_API.G_RET_STS_ERROR;

1311: --
1312: WHEN INIT_FAILED THEN
1313: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INIT_FAILED');
1314: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1315: x_return_status := FND_API.G_RET_STS_ERROR;
1316: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1317: if x_msg_count > 1 then
1318: x_msg_data := l_msg_summary || l_msg_details;
1319: else

Line 1334: x_return_status := FND_API.G_RET_STS_ERROR;

1330: --
1331: WHEN WSH_U_NO_HOST THEN
1332: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_NO_HOST');
1333: WSH_UTIL_CORE.ADD_MESSAGE('E');
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1336: if x_msg_count > 1 then
1337: x_msg_data := l_msg_summary || l_msg_details;
1338: else

Line 1353: x_return_status := FND_API.G_RET_STS_ERROR;

1349: --
1350: WHEN WSH_U_APPVER THEN
1351: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_APPVER');
1352: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1355: if x_msg_count > 1 then
1356: x_msg_data := l_msg_summary || l_msg_details;
1357: else

Line 1374: x_return_status := FND_API.G_RET_STS_ERROR;

1370: --
1371: WHEN WSH_U_LICAGRE THEN
1372: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_LICAGRE');
1373: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1376: if x_msg_count > 1 then
1377: x_msg_data := l_msg_summary || l_msg_details;
1378: else

Line 1395: x_return_status := FND_API.G_RET_STS_ERROR;

1391: --
1392: WHEN WSH_U_RESTYP THEN
1393: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_RESTYP');
1394: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1397: if x_msg_count > 1 then
1398: x_msg_data := l_msg_summary || l_msg_details;
1399: else

Line 1416: x_return_status := FND_API.G_RET_STS_ERROR;

1412: --
1413: WHEN WSH_U_INPUT_PARAMETER THEN
1414: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INPUT_PARAMETER');
1415: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1416: x_return_status := FND_API.G_RET_STS_ERROR;
1417: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1418: if x_msg_count > 1 then
1419: x_msg_data := l_msg_summary || l_msg_details;
1420: else

Line 1437: x_return_status := FND_API.G_RET_STS_ERROR;

1433: --
1434: WHEN WSH_U_INQNO THEN
1435: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_INQNO');
1436: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1437: x_return_status := FND_API.G_RET_STS_ERROR;
1438: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1439: if x_msg_count > 1 then
1440: x_msg_data := l_msg_summary || l_msg_details;
1441: else

Line 1458: x_return_status := FND_API.G_RET_STS_ERROR;

1454: --
1455: WHEN WSH_U_TYP_INQNO THEN
1456: FND_MESSAGE.SET_NAME('WSH', 'WSH_U_TYP_INQNO');
1457: WSH_UTIL_CORE.ADD_MESSAGE(p_message_type);
1458: x_return_status := FND_API.G_RET_STS_ERROR;
1459: WSH_UTIL_CORE.get_messages( 'Y', l_msg_summary, l_msg_details, x_msg_count);
1460: if x_msg_count > 1 then
1461: x_msg_data := l_msg_summary || l_msg_details;
1462: else

Line 1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

1472: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_U_TYP_INQNO');
1473: END IF;
1474: --
1475: --End of Comment for Carrier Services Integration with Shipping project Bug 16095594 */
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1477: THEN
1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1480: THEN

Line 1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1474: --
1475: --End of Comment for Carrier Services Integration with Shipping project Bug 16095594 */
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
1477: THEN
1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1479: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1480: THEN
1481: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1482: END IF;

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

1485: -- Debug Statements
1486: --
1487: IF l_debug_on
1488: THEN
1489: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1490: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1491: END IF;
1492: --
1493: WHEN OTHERS

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

1486: --
1487: IF l_debug_on
1488: THEN
1489: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1490: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1491: END IF;
1492: --
1493: WHEN OTHERS
1494: THEN

Line 1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1491: END IF;
1492: --
1493: WHEN OTHERS
1494: THEN
1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1497: THEN
1498: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1499: END IF;