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.PV_LOCATOR dependencies on FND_API

Line 44: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

40: -- 1. object_version_number will be set to 1.
41: ---------------------------------------------------------------------
42: PROCEDURE Get_Locator_Partners(
43: p_api_version IN NUMBER
44: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
45: ,p_commit IN VARCHAR2 := FND_API.g_false
46: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE

Line 45: ,p_commit IN VARCHAR2 := FND_API.g_false

41: ---------------------------------------------------------------------
42: PROCEDURE Get_Locator_Partners(
43: p_api_version IN NUMBER
44: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
45: ,p_commit IN VARCHAR2 := FND_API.g_false
46: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE

Line 46: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

42: PROCEDURE Get_Locator_Partners(
43: p_api_version IN NUMBER
44: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
45: ,p_commit IN VARCHAR2 := FND_API.g_false
46: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
47: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
48: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
49: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
50: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE

Line 156: IF NOT FND_API.Compatible_API_Call ( l_api_version,

152: -- Retrieve profile value for stack trace profile option.
153: -- ------------------------------------------------------------------------
154:
155: -- Standard call to check for call compatibility.
156: IF NOT FND_API.Compatible_API_Call ( l_api_version,
157: p_api_version,
158: l_api_name,
159: G_PKG_NAME)
160: THEN

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: p_api_version,
158: l_api_name,
159: G_PKG_NAME)
160: THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163:
164: -- Initialize message list if p_init_msg_list is set to TRUE.
165: IF FND_API.to_Boolean( p_init_msg_list )

Line 165: IF FND_API.to_Boolean( p_init_msg_list )

161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163:
164: -- Initialize message list if p_init_msg_list is set to TRUE.
165: IF FND_API.to_Boolean( p_init_msg_list )
166: THEN
167: FND_MSG_PUB.initialize;
168: END IF;
169:

Line 216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

212: p_token1_value => null,
213: p_token2 => null,
214: p_token2_value => null);
215:
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: end if;
218: -- Initialize API return status to SUCCESS
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220: --x_partner_tbl := p_partner_tbl;

Line 219: x_return_status := FND_API.G_RET_STS_SUCCESS;

215:
216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: end if;
218: -- Initialize API return status to SUCCESS
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220: --x_partner_tbl := p_partner_tbl;
221:
222:
223: -- Call to form_where_clause to get partners by attributes

Line 389: WHEN FND_API.G_EXC_ERROR THEN

385:
386:
387: EXCEPTION
388:
389: WHEN FND_API.G_EXC_ERROR THEN
390:
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392: fnd_msg_pub.Count_And_Get
393: (

Line 391: x_return_status := FND_API.G_RET_STS_ERROR ;

387: EXCEPTION
388:
389: WHEN FND_API.G_EXC_ERROR THEN
390:
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392: fnd_msg_pub.Count_And_Get
393: (
394: p_encoded => FND_API.G_TRUE,
395: p_count => x_msg_count,

Line 394: p_encoded => FND_API.G_TRUE,

390:
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392: fnd_msg_pub.Count_And_Get
393: (
394: p_encoded => FND_API.G_TRUE,
395: p_count => x_msg_count,
396: p_data => x_msg_data
397: );
398:

Line 399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

395: p_count => x_msg_count,
396: p_data => x_msg_data
397: );
398:
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400:
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: fnd_msg_pub.Count_And_Get
403: (

Line 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

397: );
398:
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
400:
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: fnd_msg_pub.Count_And_Get
403: (
404: p_encoded => FND_API.G_TRUE,
405: p_count => x_msg_count,

Line 404: p_encoded => FND_API.G_TRUE,

400:
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: fnd_msg_pub.Count_And_Get
403: (
404: p_encoded => FND_API.G_TRUE,
405: p_count => x_msg_count,
406: p_data => x_msg_data
407: );
408:

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

407: );
408:
409: WHEN OTHERS THEN
410:
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
413: fnd_msg_pub.Count_And_Get
414: (
415: p_encoded => FND_API.G_TRUE,

Line 415: p_encoded => FND_API.G_TRUE,

411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
413: fnd_msg_pub.Count_And_Get
414: (
415: p_encoded => FND_API.G_TRUE,
416: p_count => x_msg_count,
417: p_data => x_msg_data
418: );
419: END Get_Locator_Partners;

Line 439: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

435: -- 1. object_version_number will be set to 1.
436: ---------------------------------------------------------------------
437: PROCEDURE Get_Partners(
438: p_api_version IN NUMBER
439: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
440: ,p_commit IN VARCHAR2 := FND_API.g_false
441: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
442:
443: ,p_customer_address IN party_address_rec_type

Line 440: ,p_commit IN VARCHAR2 := FND_API.g_false

436: ---------------------------------------------------------------------
437: PROCEDURE Get_Partners(
438: p_api_version IN NUMBER
439: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
440: ,p_commit IN VARCHAR2 := FND_API.g_false
441: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
442:
443: ,p_customer_address IN party_address_rec_type
444: ,p_partner_tbl IN JTF_NUMBER_TABLE

Line 441: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

437: PROCEDURE Get_Partners(
438: p_api_version IN NUMBER
439: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
440: ,p_commit IN VARCHAR2 := FND_API.g_false
441: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
442:
443: ,p_customer_address IN party_address_rec_type
444: ,p_partner_tbl IN JTF_NUMBER_TABLE
445: ,p_max_no_partners IN NUMBER

Line 519: IF NOT FND_API.Compatible_API_Call ( l_api_version,

515:
516:
517:
518: -- Standard call to check for call compatibility.
519: IF NOT FND_API.Compatible_API_Call ( l_api_version,
520: p_api_version,
521: l_api_name,
522: G_PKG_NAME)
523: THEN

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: p_api_version,
521: l_api_name,
522: G_PKG_NAME)
523: THEN
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.to_Boolean( p_init_msg_list )

Line 528: IF FND_API.to_Boolean( p_init_msg_list )

524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.to_Boolean( p_init_msg_list )
529: THEN
530: FND_MSG_PUB.initialize;
531: END IF;
532:

Line 554: x_return_status := FND_API.G_RET_STS_SUCCESS;

550: END IF;
551:
552:
553: -- Initialize API return status to SUCCESS
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555: --x_partner_tbl := p_partner_tbl;
556:
557: --Check for distance unit
558: if(p_distance_unit is null) then

Line 611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

607: p_token1_value => null,
608: p_token2 => null,
609: p_token2_value => null);
610:
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: end if;
613:
614:
615: if ( p_distance is null and p_max_no_partners is null and

Line 660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

656: p_token1_value => null,
657: p_token2 => null,
658: p_token2_value => null);
659:
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: end if;
662:
663: if(l_customer_geocode_object IS NOT NULL and l_customer_geocode_object.sdo_point.x IS NULL) then
664:

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

669: p_token1_value => null,
670: p_token2 => null,
671: p_token2_value => null);
672:
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: end if;
675:
676:
677: --Forming a string of all partner ids to use it in query

Line 949: WHEN FND_API.G_EXC_ERROR THEN

945: );
946:
947: EXCEPTION
948:
949: WHEN FND_API.G_EXC_ERROR THEN
950:
951: x_return_status := FND_API.G_RET_STS_ERROR ;
952: fnd_msg_pub.Count_And_Get
953: (

Line 951: x_return_status := FND_API.G_RET_STS_ERROR ;

947: EXCEPTION
948:
949: WHEN FND_API.G_EXC_ERROR THEN
950:
951: x_return_status := FND_API.G_RET_STS_ERROR ;
952: fnd_msg_pub.Count_And_Get
953: (
954: p_encoded => FND_API.G_TRUE,
955: p_count => x_msg_count,

Line 954: p_encoded => FND_API.G_TRUE,

950:
951: x_return_status := FND_API.G_RET_STS_ERROR ;
952: fnd_msg_pub.Count_And_Get
953: (
954: p_encoded => FND_API.G_TRUE,
955: p_count => x_msg_count,
956: p_data => x_msg_data
957: );
958:

Line 959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

955: p_count => x_msg_count,
956: p_data => x_msg_data
957: );
958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
962:
963: fnd_msg_pub.Count_And_Get

Line 961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

957: );
958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
962:
963: fnd_msg_pub.Count_And_Get
964: (
965: p_encoded => FND_API.G_TRUE,

Line 965: p_encoded => FND_API.G_TRUE,

961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
962:
963: fnd_msg_pub.Count_And_Get
964: (
965: p_encoded => FND_API.G_TRUE,
966: p_count => x_msg_count,
967: p_data => x_msg_data
968: );
969:

Line 972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

968: );
969:
970: WHEN OTHERS THEN
971:
972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
974: --Debug(SQLCODE || ':::' || SQLERRM);
975: fnd_msg_pub.Count_And_Get
976: (

Line 977: p_encoded => FND_API.G_TRUE,

973: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
974: --Debug(SQLCODE || ':::' || SQLERRM);
975: fnd_msg_pub.Count_And_Get
976: (
977: p_encoded => FND_API.G_TRUE,
978: p_count => x_msg_count,
979: p_data => x_msg_data
980: );
981: END Get_Partners;

Line 1001: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

997: -- 1. object_version_number will be set to 1.
998: ---------------------------------------------------------------------
999: PROCEDURE Get_Partners_From_ELocation(
1000: p_api_version IN NUMBER
1001: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1002: ,p_commit IN VARCHAR2 := FND_API.g_false
1003: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1004: ,p_customer_address IN party_address_rec_type
1005: ,p_partner_tbl IN party_address_rec_tbl

Line 1002: ,p_commit IN VARCHAR2 := FND_API.g_false

998: ---------------------------------------------------------------------
999: PROCEDURE Get_Partners_From_ELocation(
1000: p_api_version IN NUMBER
1001: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1002: ,p_commit IN VARCHAR2 := FND_API.g_false
1003: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1004: ,p_customer_address IN party_address_rec_type
1005: ,p_partner_tbl IN party_address_rec_tbl
1006: ,p_max_no_partners IN NUMBER

Line 1003: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

999: PROCEDURE Get_Partners_From_ELocation(
1000: p_api_version IN NUMBER
1001: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1002: ,p_commit IN VARCHAR2 := FND_API.g_false
1003: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1004: ,p_customer_address IN party_address_rec_type
1005: ,p_partner_tbl IN party_address_rec_tbl
1006: ,p_max_no_partners IN NUMBER
1007: ,p_distance IN NUMBER

Line 1056: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1052: BEGIN
1053:
1054:
1055: -- Standard call to check for call compatibility.
1056: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1057: p_api_version,
1058: l_api_name,
1059: G_PKG_NAME)
1060: THEN

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057: p_api_version,
1058: l_api_name,
1059: G_PKG_NAME)
1060: THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END IF;
1063:
1064: -- Initialize message list if p_init_msg_list is set to TRUE.
1065: IF FND_API.to_Boolean( p_init_msg_list )

Line 1065: IF FND_API.to_Boolean( p_init_msg_list )

1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: END IF;
1063:
1064: -- Initialize message list if p_init_msg_list is set to TRUE.
1065: IF FND_API.to_Boolean( p_init_msg_list )
1066: THEN
1067: FND_MSG_PUB.initialize;
1068: END IF;
1069: -- Debug Message

Line 1078: x_return_status := FND_API.G_RET_STS_SUCCESS;

1074: END IF;
1075:
1076:
1077: -- Initialize API return status to SUCCESS
1078: x_return_status := FND_API.G_RET_STS_SUCCESS;
1079:
1080: --checking sort_by_distance
1081: if(UPPER(p_sort_by_distance)='T') then
1082: l_sort_by_distance := 'true';

Line 1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1111: p_token1_value => null,
1112: p_token2 => null,
1113: p_token2_value => null);
1114:
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: end if;
1117: -- max_no-of_partners can not be more than no of entries in the table.
1118: --even if it is, it wont retrieve those many . so, making max as table count.
1119: if (p_max_no_partners is null) then

Line 1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1239: p_token1_value => null,
1240: p_token2 => null,
1241: p_token2_value => null);
1242:
1243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1244: end if;
1245:
1246:
1247: loop --parsing loop

Line 1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1255: INSTR(xml_response,'component_error',1, 1) <> 0 or
1256: INSTR(xml_response,'generic_error',1, 1) <> 0 or
1257: INSTR(xml_response,' Error parsing',1, 1) <> 0 ) THEN
1258:
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1260: --raise_application_error(-20509, ' eLocation Server is not available' || 'in ' || l_api_name );
1261: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1262: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',
1263: p_token1 => null,

Line 1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1264: p_token1_value => null,
1265: p_token2 => null,
1266: p_token2_value => null);
1267:
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269: -- dbms_output.put_line('Error occured in parsing..');
1270: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END IF;
1272:

Line 1270: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1266: p_token2_value => null);
1267:
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269: -- dbms_output.put_line('Error occured in parsing..');
1270: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END IF;
1272:
1273: --exit when xml_response is null or no id string in xml_response;
1274: --EXIT when INSTR(xml_response, 'route id', 1, 1) =0 ;

Line 1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1305: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1306: Debug( p_msg_string => 'partner with invalid geocode (Geometry)' || l_partyid_loc );
1307: END IF;
1308: IF l_partyid_loc = 0 THEN
1309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1310: --raise_application_error(-20510,' eLocation Server is not available' || 'in ' || l_api_name);
1311: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1312: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',
1313: p_token1 => null,

Line 1318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1314: p_token1_value => null,
1315: p_token2 => null,
1316: p_token2_value => null);
1317:
1318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;
1321: l_first_quote_loc := INSTR(xml_response, '"', l_partyid_loc, 1);
1322: l_second_quote_loc := INSTR(xml_response, '"', l_partyid_loc, 2);

Line 1319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1315: p_token2 => null,
1316: p_token2_value => null);
1317:
1318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1319: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: END IF;
1321: l_first_quote_loc := INSTR(xml_response, '"', l_partyid_loc, 1);
1322: l_second_quote_loc := INSTR(xml_response, '"', l_partyid_loc, 2);
1323: --this line will fetch id value that is between " and "

Line 1401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1397: --First find location for id and then find location for " if id exists.
1398: l_partyid_loc := INSTR(xml_response, 'route id', 1, 1);
1399:
1400: IF l_partyid_loc = 0 THEN
1401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1402: --raise_application_error(-20510,' eLocation Server is not available' || 'in ' || l_api_name);
1403: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1404: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',
1405: p_token1 => null,

Line 1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1406: p_token1_value => null,
1407: p_token2 => null,
1408: p_token2_value => null);
1409:
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;
1413:
1414: l_first_quote_loc := INSTR(xml_response, '"', l_partyid_loc, 1);

Line 1411: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1407: p_token2 => null,
1408: p_token2_value => null);
1409:
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1412: END IF;
1413:
1414: l_first_quote_loc := INSTR(xml_response, '"', l_partyid_loc, 1);
1415: l_second_quote_loc := INSTR(xml_response, '"', l_partyid_loc, 2);

Line 1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1423: --similarly do for distance
1424: l_distance_loc := INSTR(xml_response, 'distance', 1, 1);
1425:
1426: IF l_distance_loc = 0 THEN
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1428: --raise_application_error(-20511, ' eLocation Server is not available' || 'in ' || l_api_name );
1429: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1430: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',
1431: p_token1 => null,

Line 1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1432: p_token1_value => null,
1433: p_token2 => null,
1434: p_token2_value => null);
1435:
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: END IF;
1439: l_first_quote_loc := INSTR(xml_response, '"', l_distance_loc, 1);
1440: l_second_quote_loc := INSTR(xml_response, '"', l_distance_loc, 2);

Line 1437: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1433: p_token2 => null,
1434: p_token2_value => null);
1435:
1436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1437: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1438: END IF;
1439: l_first_quote_loc := INSTR(xml_response, '"', l_distance_loc, 1);
1440: l_second_quote_loc := INSTR(xml_response, '"', l_distance_loc, 2);
1441:

Line 1496: WHEN FND_API.G_EXC_ERROR THEN

1492: --x_msg_data:= l_msg_data;
1493:
1494: EXCEPTION
1495:
1496: WHEN FND_API.G_EXC_ERROR THEN
1497:
1498: x_return_status := FND_API.G_RET_STS_ERROR ;
1499: fnd_msg_pub.Count_And_Get
1500: (

Line 1498: x_return_status := FND_API.G_RET_STS_ERROR ;

1494: EXCEPTION
1495:
1496: WHEN FND_API.G_EXC_ERROR THEN
1497:
1498: x_return_status := FND_API.G_RET_STS_ERROR ;
1499: fnd_msg_pub.Count_And_Get
1500: (
1501: p_encoded => FND_API.G_TRUE,
1502: p_count => x_msg_count,

Line 1501: p_encoded => FND_API.G_TRUE,

1497:
1498: x_return_status := FND_API.G_RET_STS_ERROR ;
1499: fnd_msg_pub.Count_And_Get
1500: (
1501: p_encoded => FND_API.G_TRUE,
1502: p_count => x_msg_count,
1503: p_data => x_msg_data
1504: );
1505:

Line 1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1502: p_count => x_msg_count,
1503: p_data => x_msg_data
1504: );
1505:
1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507:
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1509: fnd_msg_pub.Count_And_Get
1510: (

Line 1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1504: );
1505:
1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507:
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1509: fnd_msg_pub.Count_And_Get
1510: (
1511: p_encoded => FND_API.G_TRUE,
1512: p_count => x_msg_count,

Line 1511: p_encoded => FND_API.G_TRUE,

1507:
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1509: fnd_msg_pub.Count_And_Get
1510: (
1511: p_encoded => FND_API.G_TRUE,
1512: p_count => x_msg_count,
1513: p_data => x_msg_data
1514: );
1515:

Line 1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1514: );
1515:
1516: WHEN OTHERS THEN
1517:
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1520: fnd_msg_pub.Count_And_Get
1521: (
1522: p_encoded => FND_API.G_TRUE,

Line 1522: p_encoded => FND_API.G_TRUE,

1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1520: fnd_msg_pub.Count_And_Get
1521: (
1522: p_encoded => FND_API.G_TRUE,
1523: p_count => x_msg_count,
1524: p_data => x_msg_data
1525: );
1526: END Get_Partners_From_ELocation;

Line 1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1577: p_token1_value => null,
1578: p_token2 => null,
1579: p_token2_value => null);
1580:
1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1582: END IF;
1583: first_quote_loc := INSTR(xml_response, '"', latitude_loc, 1);
1584: second_quote_loc := INSTR(xml_response, '"', latitude_loc, 2);
1585: latitude_str := SUBSTR(

Line 1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1601: p_token1_value => null,
1602: p_token2 => null,
1603: p_token2_value => null);
1604:
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607: first_quote_loc := INSTR(xml_response, '"', longitude_loc, 1);
1608: second_quote_loc := INSTR(xml_response, '"', longitude_loc, 2);
1609: longitude_str := SUBSTR(