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

Line 977: l_customer_address pv_locator.party_address_rec_type;

973: l_previous_sc_id NUMBER;
974: l_previous_operator VARCHAR2(100);
975: l_previous_return_type VARCHAR2(100);
976:
977: l_customer_address pv_locator.party_address_rec_type;
978: l_distance_uom VARCHAR2(30);
979: --l_distance_uom_returned VARCHAR2(30);
980:
981: l_attr_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1411: l_distance_uom := pv_locator.g_distance_unit_km;

1407: -- Geographic proximity restrictions.
1408: -- -------------------------------------------------------------
1409: IF (l_entity_routing.entity_routing_id IS NOT NULL) THEN
1410: IF (l_entity_routing.distance_uom_code = 'KILOMETERS') THEN
1411: l_distance_uom := pv_locator.g_distance_unit_km;
1412:
1413: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1414: Debug('Distance Unit: ' || l_distance_uom);
1415: END IF;

Line 1418: l_distance_uom := pv_locator.g_distance_unit_mile;

1414: Debug('Distance Unit: ' || l_distance_uom);
1415: END IF;
1416:
1417: ELSIF (l_entity_routing.distance_uom_code = 'MILES') THEN
1418: l_distance_uom := pv_locator.g_distance_unit_mile;
1419:
1420: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1421: Debug('Distance Unit: ' || l_distance_uom);
1422: END IF;

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

1421: Debug('Distance Unit: ' || l_distance_uom);
1422: END IF;
1423:
1424: ELSE
1425: --l_distance_uom := pv_locator.g_distance_unit_mile;
1426:
1427: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1428: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');
1429: END IF;

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

1424: ELSE
1425: --l_distance_uom := pv_locator.g_distance_unit_mile;
1426:
1427: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1428: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');
1429: END IF;
1430: END IF;
1431:
1432: ELSE

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

1429: END IF;
1430: END IF;
1431:
1432: ELSE
1433: --l_distance_uom := pv_locator.g_distance_unit_mile;
1434:
1435: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1436: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');
1437: END IF;

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

1432: ELSE
1433: --l_distance_uom := pv_locator.g_distance_unit_mile;
1434:
1435: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1436: Debug('No Distance Unit Specified. Use the default from the pv_locator profile.');
1437: END IF;
1438: END IF;
1439:
1440:

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

1466: -- Execute geo proximity API.
1467: -- -------------------------------------------------------------
1468: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1469: Debug('..........................................................');
1470: Debug('Calling pv_locator.Get_Partners..........................');
1471: Debug('# of Partners Sent: ' || l_partner_id_tbl.COUNT);
1472: END IF;
1473:
1474: l_start := DBMS_UTILITY.get_time;

Line 1476: pv_locator.Get_Partners (

1472: END IF;
1473:
1474: l_start := DBMS_UTILITY.get_time;
1475:
1476: pv_locator.Get_Partners (
1477: p_api_version => p_api_version,
1478: p_customer_address => l_customer_address,
1479: p_partner_tbl => l_partner_id_tbl,
1480: p_max_no_partners => l_entity_routing.max_nearest_partner,

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

1500: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1501: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');
1502: END IF;
1503:
1504: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1505: x_distance_uom_returned := 'KILOMETERS';
1506:
1507: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
1508: x_distance_uom_returned := 'MILES';

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

1503:
1504: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1505: x_distance_uom_returned := 'KILOMETERS';
1506:
1507: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
1508: x_distance_uom_returned := 'MILES';
1509: END IF;
1510:
1511: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1671: pv_locator.Get_Partners (

1667: l_partner_tbl.EXTEND;
1668: l_partner_tbl(1) := l_preferred_partner_party_id;
1669: l_partner_id_tbl := l_partner_tbl;
1670:
1671: pv_locator.Get_Partners (
1672: p_api_version => p_api_version,
1673: p_customer_address => l_customer_address,
1674: p_partner_tbl => l_partner_id_tbl,
1675: p_max_no_partners => null,

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

1693: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1694: RAISE FND_API.g_exc_unexpected_error;
1695: END IF;
1696:
1697: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1698: x_distance_uom_returned := 'KILOMETERS';
1699:
1700: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
1701: x_distance_uom_returned := 'MILES';

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

1696:
1697: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1698: x_distance_uom_returned := 'KILOMETERS';
1699:
1700: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
1701: x_distance_uom_returned := 'MILES';
1702: END IF;
1703:
1704: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN