DBA Data[Home] [Help]

APPS.PV_LOCATOR dependencies on FND_PROFILE

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 510: l_skip_server CONSTANT VARCHAR(1) :=nvl(fnd_profile.value('PV_SKIP_ELOCATION_FOR_MATCHING'), 'N');

506: from hz_locations hzl
507: where hzl.location_id =pc_location_id;
508:
509: l_count NUMBER;
510: l_skip_server CONSTANT VARCHAR(1) :=nvl(fnd_profile.value('PV_SKIP_ELOCATION_FOR_MATCHING'), 'N');
511:
512: my_message VARCHAR2(2000);
513:
514: BEGIN

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