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 PV_LOCATOR

Line 1: PACKAGE BODY PV_LOCATOR AS

1: PACKAGE BODY PV_LOCATOR AS
2: /* $Header: pvxvlcrb.pls 120.5 2006/06/06 20:53:13 dhii ship $ */
3:
4:
5:

Line 118: select /+ cardinality( tmp 10 ) / pv_locator.geocode_distance (l_geo, hzl.geometry, l_dist_unit) dis,

114: ,p_distance NUMBER
115: ,p_customer_city VARCHAR2) is
116: select * from
117: (
118: select /*+ cardinality( tmp 10 ) */ pv_locator.geocode_distance (l_geo, hzl.geometry, l_dist_unit) dis,
119: tmp.party_id, org.party_name, hzl.address1, hzl.address2, hzl.address3,
120: hzl.city, hzl.state, hzl.country, hzl.postal_code,
121: org.url, cp.phone_country_code, cp.phone_area_code, cp.phone_number, rownum rn
122: from

Line 210: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',

206:
207: --raise_application_error(-20502, 'In ' || l_api_name || ' customer address geocode object is null');
208:
209: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
210: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',
211: p_token1 => null,
212: p_token1_value => null,
213: p_token2 => null,
214: p_token2_value => null);

Line 329: l_skip_server := fnd_profile.value('PV_LOCATOR_DO_SKIP_SERVER');

325: END IF;
326:
327: l_msg_data:=l_msg_data || 'Total No. Of Partners before sending to e_location: ' || l_partner_tbl.count;
328:
329: l_skip_server := fnd_profile.value('PV_LOCATOR_DO_SKIP_SERVER');
330:
331: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
332: Debug(p_msg_string => 'Do we SKIP E-Location???: ' || l_skip_server);
333: END IF;

Line 540: p_msg_string => 'START OF PV_LOCATOR.GET_PARTNERS() '

536: );
537: END IF;
538: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
539: Debug(
540: p_msg_string => 'START OF PV_LOCATOR.GET_PARTNERS() '
541: );
542: END IF;
543:
544:

Line 560: --l_distance_unit:= fnd_profile.value('PV_LOCATOR_DEFAULT_DISTANCE_UOM');

556:
557: --Check for distance unit
558: if(p_distance_unit is null) then
559:
560: --l_distance_unit:= fnd_profile.value('PV_LOCATOR_DEFAULT_DISTANCE_UOM');
561: l_distance_unit:= fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT');
562:
563: if(l_distance_unit = 'MILES') then
564: l_distance_unit:= g_distance_unit_mile;

Line 561: l_distance_unit:= fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT');

557: --Check for distance unit
558: if(p_distance_unit is null) then
559:
560: --l_distance_unit:= fnd_profile.value('PV_LOCATOR_DEFAULT_DISTANCE_UOM');
561: l_distance_unit:= fnd_profile.value('PV_LOCATOR_DISTANCE_UNIT');
562:
563: if(l_distance_unit = 'MILES') then
564: l_distance_unit:= g_distance_unit_mile;
565: elsif(l_distance_unit = 'KILOMETERS') then

Line 605: p_msg_name => 'PV_LOCATOR_NO_PARTNERS',

601:
602: if(p_partner_tbl IS NULL) then
603: --raise_application_error(-20506, ' partner id table received is null' || ' in ' || l_api_name );
604: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
605: p_msg_name => 'PV_LOCATOR_NO_PARTNERS',
606: p_token1 => null,
607: p_token1_value => null,
608: p_token2 => null,
609: p_token2_value => null);

Line 654: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',

650: if(l_customer_geocode_object IS NULL) then
651:
652: --raise_application_error(-20504, ' customer geocode object is null' || ' in ' || l_api_name );
653: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
654: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',
655: p_token1 => null,
656: p_token1_value => null,
657: p_token2 => null,
658: p_token2_value => null);

Line 667: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',

663: if(l_customer_geocode_object IS NOT NULL and l_customer_geocode_object.sdo_point.x IS NULL) then
664:
665: --raise_application_error(-20505, 'The customer does not have a valid address' );
666: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
667: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',
668: p_token1 => null,
669: p_token1_value => null,
670: p_token2 => null,
671: p_token2_value => null);

Line 704: ' select /+ leading(c) / pv_locator.geocode_distance(:1,hzl.geometry,:2) dis, ' ||

700: -- performance dramatically.
701: -- ---------------------------------------------------------------------
702: l_query:=
703: 'select * from ( ' ||
704: ' select /*+ leading(c) */ pv_locator.geocode_distance(:1,hzl.geometry,:2) dis, ' ||
705: ' pvpp.partner_id party_id, ' ||
706: ' org.party_name, '||
707: ' hzl.address1, '||
708: ' hzl.address2, '||

Line 769: FROM (SELECT pv_locator.geocode_distance(:1,hzl.geometry,:2) dis,

765: -- The second SELECT statement actually starts with /*+ leading(c) */
766: -- --------------------------------------------------------------------------------
767: /*
768: SELECT *
769: FROM (SELECT pv_locator.geocode_distance(:1,hzl.geometry,:2) dis,
770: pvpp.partner_id party_id, org.party_name, hzl.address1,
771: hzl.address2, hzl.address3, hzl.city, hzl.state, hzl.country,
772: hzl.postal_code, rownum rn
773: FROM hz_parties org,

Line 930: p_msg_string => 'END OF PV_LOCATOR.GET_PARTNERS() '

926:
927: --dbms_output.put_line('no of patners returned' || l_return_final_partner_tbl.count);
928: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
929: Debug(
930: p_msg_string => 'END OF PV_LOCATOR.GET_PARTNERS() '
931: );
932: END IF;
933: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
934: Debug(

Line 1109: p_msg_name => 'PV_LOCATOR_PARTNERS_NONE',

1105:
1106: if(p_partner_tbl IS NULL) then
1107: --raise_application_error(-20508, 'In ' || l_api_name || ' partner address table is null');
1108: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1109: p_msg_name => 'PV_LOCATOR_PARTNERS_NONE',
1110: p_token1 => null,
1111: p_token1_value => null,
1112: p_token2 => null,
1113: p_token2_value => null);

Line 1237: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',

1233: --what if xml_response is null
1234: if (xml_response is null) then
1235: --raise_application_error(-20516, 'In ' || l_api_name || ' Server is not available. Sever may be down right now. Try after some time.');
1236: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1237: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',
1238: p_token1 => null,
1239: p_token1_value => null,
1240: p_token2 => null,
1241: p_token2_value => null);

Line 1262: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',

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,
1264: p_token1_value => null,
1265: p_token2 => null,
1266: p_token2_value => null);

Line 1312: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',

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,
1314: p_token1_value => null,
1315: p_token2 => null,
1316: p_token2_value => null);

Line 1404: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',

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,
1406: p_token1_value => null,
1407: p_token2 => null,
1408: p_token2_value => null);

Line 1430: p_msg_name => 'PV_LOCATOR_SERVICE_UNAVAILABLE',

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,
1432: p_token1_value => null,
1433: p_token2 => null,
1434: p_token2_value => null);

Line 1575: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',

1571: latitude_loc := INSTR(xml_response, 'latitude', 1, 1);
1572: IF latitude_loc = 0 THEN
1573: --raise_application_error(-20512, 'latitude is missing');
1574: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1575: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',
1576: p_token1 => null,
1577: p_token1_value => null,
1578: p_token2 => null,
1579: p_token2_value => null);

Line 1599: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',

1595: longitude_loc := INSTR(xml_response, 'longitude', 1, 1);
1596: IF longitude_loc = 0 THEN
1597: --raise_application_error(-20513, 'longitude is missing');
1598: Set_Error_Message(p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1599: p_msg_name => 'PV_LOCATOR_CUST_ADDR_INVALID',
1600: p_token1 => null,
1601: p_token1_value => null,
1602: p_token2 => null,
1603: p_token2_value => null);

Line 1879: End PV_LOCATOR;

1875: END IF;
1876: END Set_Error_Message;
1877: -- ==============================End of Set_Error_Message==============================
1878:
1879: End PV_LOCATOR;
1880: