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_MATCH_V3_PUB dependencies on PV_LOCATOR

Line 850: l_customer_address pv_locator.party_address_rec_type;

846: l_previous_sc_id NUMBER;
847: l_previous_operator VARCHAR2(100);
848: l_previous_return_type VARCHAR2(100);
849:
850: l_customer_address pv_locator.party_address_rec_type;
851: l_distance_uom VARCHAR2(30);
852: --l_distance_uom_returned VARCHAR2(30);
853:
854: l_attr_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1279: l_distance_uom := pv_locator.g_distance_unit_km;

1275: -- Geographic proximity restrictions.
1276: -- -------------------------------------------------------------
1277: IF (l_entity_routing.entity_routing_id IS NOT NULL) THEN
1278: IF (l_entity_routing.distance_uom_code = 'KILOMETERS') THEN
1279: l_distance_uom := pv_locator.g_distance_unit_km;
1280:
1281: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1282: Debug('Distance Unit: ' || l_distance_uom);
1283: END IF;

Line 1286: l_distance_uom := pv_locator.g_distance_unit_mile;

1282: Debug('Distance Unit: ' || l_distance_uom);
1283: END IF;
1284:
1285: ELSIF (l_entity_routing.distance_uom_code = 'MILES') THEN
1286: l_distance_uom := pv_locator.g_distance_unit_mile;
1287:
1288: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1289: Debug('Distance Unit: ' || l_distance_uom);
1290: END IF;

Line 1293: --l_distance_uom := pv_locator.g_distance_unit_mile;

1289: Debug('Distance Unit: ' || l_distance_uom);
1290: END IF;
1291:
1292: ELSE
1293: --l_distance_uom := pv_locator.g_distance_unit_mile;
1294:
1295: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1296: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');
1297: END IF;

Line 1296: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');

1292: ELSE
1293: --l_distance_uom := pv_locator.g_distance_unit_mile;
1294:
1295: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1296: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');
1297: END IF;
1298: END IF;
1299:
1300: ELSE

Line 1301: --l_distance_uom := pv_locator.g_distance_unit_mile;

1297: END IF;
1298: END IF;
1299:
1300: ELSE
1301: --l_distance_uom := pv_locator.g_distance_unit_mile;
1302:
1303: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1304: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');
1305: END IF;

Line 1304: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');

1300: ELSE
1301: --l_distance_uom := pv_locator.g_distance_unit_mile;
1302:
1303: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1304: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');
1305: END IF;
1306: END IF;
1307:
1308:

Line 1338: Debug('Calling pv_locator.Get_Partners..........................');

1334: -- Execute geo proximity API.
1335: -- -------------------------------------------------------------
1336: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1337: Debug('..........................................................');
1338: Debug('Calling pv_locator.Get_Partners..........................');
1339: Debug('# of Partners Sent: ' || l_partner_id_tbl.COUNT);
1340: END IF;
1341:
1342: l_start := DBMS_UTILITY.get_time;

Line 1344: pv_locator.Get_Partners (

1340: END IF;
1341:
1342: l_start := DBMS_UTILITY.get_time;
1343:
1344: pv_locator.Get_Partners (
1345: p_api_version => p_api_version,
1346: p_customer_address => l_customer_address,
1347: p_partner_tbl => l_partner_id_tbl,
1348: p_max_no_partners => l_entity_routing.max_nearest_partner,

Line 1372: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN

1368: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1369: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1370: END IF;
1371:
1372: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1373: x_distance_uom_returned := 'KILOMETERS';
1374:
1375: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
1376: x_distance_uom_returned := 'MILES';

Line 1375: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN

1371:
1372: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1373: x_distance_uom_returned := 'KILOMETERS';
1374:
1375: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
1376: x_distance_uom_returned := 'MILES';
1377: END IF;
1378:
1379: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1621: l_customer_address pv_locator.party_address_rec_type;

1617: l_matched_tbl_last_idx NUMBER := 0;
1618: l_incumbent_idx NUMBER := 0;
1619:
1620: l_distance_uom VARCHAR2(100);
1621: l_customer_address pv_locator.party_address_rec_type;
1622:
1623: x_matched_id JTF_NUMBER_TABLE;
1624: x_partner_details JTF_VARCHAR2_TABLE_4000;
1625: x_distance_tbl JTF_NUMBER_TABLE;

Line 1786: Debug('Calling pv_locator.Get_Partners..........................');

1782: IF l_locator_flag = 'Y' THEN
1783: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1784: Debug('Location ID: ' || l_customer_address.location_id);
1785: Debug('..........................................................');
1786: Debug('Calling pv_locator.Get_Partners..........................');
1787: Debug('# of Partners Sent: ' || l_matched_id.COUNT);
1788:
1789: FOR i IN 1 .. x_matched_id.COUNT
1790: LOOP

Line 1799: l_distance_uom := pv_locator.g_distance_unit_mile;

1795: -- -------------------------------------------------------------
1796: -- Execute geo proximity API.
1797: -- -------------------------------------------------------------
1798: -- Default to mile
1799: l_distance_uom := pv_locator.g_distance_unit_mile;
1800: pv_locator.Get_Partners (
1801: p_api_version => 1.0,
1802: p_init_msg_list => FND_API.g_false,
1803: p_commit => FND_API.g_false,

Line 1800: pv_locator.Get_Partners (

1796: -- Execute geo proximity API.
1797: -- -------------------------------------------------------------
1798: -- Default to mile
1799: l_distance_uom := pv_locator.g_distance_unit_mile;
1800: pv_locator.Get_Partners (
1801: p_api_version => 1.0,
1802: p_init_msg_list => FND_API.g_false,
1803: p_commit => FND_API.g_false,
1804: p_validation_level => FND_API.g_valid_level_full,

Line 1825: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN

1821: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1822: RAISE FND_API.g_exc_unexpected_error;
1823: END IF;
1824:
1825: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1826: x_distance_uom_returned := 'KILOMETERS';
1827:
1828: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
1829: x_distance_uom_returned := 'MILES';

Line 1828: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN

1824:
1825: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1826: x_distance_uom_returned := 'KILOMETERS';
1827:
1828: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
1829: x_distance_uom_returned := 'MILES';
1830: END IF;
1831:
1832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN