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.CSP_PART_SEARCH_PVT dependencies on FND_PROFILE

Line 30: l_server_timezone_id number := fnd_profile.value('SERVER_TIMEZONE_ID');

26: l_enough number := -1;
27: l_open_or_closed varchar2(30) := 'OPEN';
28: l_my_location sdo_geometry;
29: l_distance_uom varchar2(30) := 'unit=km';
30: l_server_timezone_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
31: l_search_method varchar2(30):= nvl(p_search_params.search_method,
32: fnd_profile.value('CSP_PART_SEARCH_METHOD'));
33: l_called_from_charges varchar2(1) := 'N';
34:

Line 32: fnd_profile.value('CSP_PART_SEARCH_METHOD'));

28: l_my_location sdo_geometry;
29: l_distance_uom varchar2(30) := 'unit=km';
30: l_server_timezone_id number := fnd_profile.value('SERVER_TIMEZONE_ID');
31: l_search_method varchar2(30):= nvl(p_search_params.search_method,
32: fnd_profile.value('CSP_PART_SEARCH_METHOD'));
33: l_called_from_charges varchar2(1) := 'N';
34:
35: procedure ship_set as
36:

Line 1169: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);

1165: x_msg_data => l_msg_data,
1166: x_geometry => l_my_location );
1167: /*
1168: if l_my_location is null then
1169: fnd_profile.get('HZ_GEOCODE_WEBSITE', l_http_ad);
1170: log('get_my_location','l_http_ad:'||l_http_ad);
1171: l_array(cpt).location_id := l_to_hz_location_id;
1172: log('get_my_location','calling hz_geocode_pkg.get_spatial_coords');
1173: hz_geocode_pkg.get_spatial_coords(

Line 1189: fnd_profile.value('CSFW_DEFAULT_DISTANCE_UNIT'));

1185: */
1186: end if;
1187: end if;
1188: l_distance_uom_code := nvl(p_search_params.distance_uom,
1189: fnd_profile.value('CSFW_DEFAULT_DISTANCE_UNIT'));
1190: log('get_my_location','l_distance_uom_code:'||l_distance_uom_code);
1191: if l_distance_uom_code = 'KM' then
1192: l_distance_uom := 'unit=km';
1193: elsif l_distance_uom_code = 'METER' then

Line 1233: l_organization_id := fnd_profile.value('CS_INV_VALIDATION_ORG');

1229: log('get_organization_id','l_organization_id:'||l_organization_id);
1230: log('get_organization_id','l_subinventory_code:'||l_subinventory_code);
1231: else
1232: log('get_organization_id','p_search_params.resource_id is null');
1233: l_organization_id := fnd_profile.value('CS_INV_VALIDATION_ORG');
1234: l_subinventory_code := fnd_api.g_miss_char;
1235: l_called_from_charges := 'Y';
1236: end if;
1237: log('get_organization_id','l_organization_id:'||l_organization_id);

Line 1922: p_hr_uom varchar2(60) := FND_PROFILE.VALUE('CSF_UOM_HOURS');

1918: i number := 0;
1919: l_arrival_date date := sysdate;
1920: l_cutoff date;
1921: l_delivery_time date;
1922: p_hr_uom varchar2(60) := FND_PROFILE.VALUE('CSF_UOM_HOURS');
1923: p_client_timezone_id number := FND_PROFILE.VALUE('CLIENT_TIMEZONE_ID');
1924: p_server_timezone_id number := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');
1925: begin
1926: log('get_arrival_time',

Line 1923: p_client_timezone_id number := FND_PROFILE.VALUE('CLIENT_TIMEZONE_ID');

1919: l_arrival_date date := sysdate;
1920: l_cutoff date;
1921: l_delivery_time date;
1922: p_hr_uom varchar2(60) := FND_PROFILE.VALUE('CSF_UOM_HOURS');
1923: p_client_timezone_id number := FND_PROFILE.VALUE('CLIENT_TIMEZONE_ID');
1924: p_server_timezone_id number := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');
1925: begin
1926: log('get_arrival_time',
1927: 'p_cutoff:'||to_char(p_cutoff,'dd-mon-yyyy hh24:mi'));

Line 1924: p_server_timezone_id number := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');

1920: l_cutoff date;
1921: l_delivery_time date;
1922: p_hr_uom varchar2(60) := FND_PROFILE.VALUE('CSF_UOM_HOURS');
1923: p_client_timezone_id number := FND_PROFILE.VALUE('CLIENT_TIMEZONE_ID');
1924: p_server_timezone_id number := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');
1925: begin
1926: log('get_arrival_time',
1927: 'p_cutoff:'||to_char(p_cutoff,'dd-mon-yyyy hh24:mi'));
1928: log('get_arrival_time','p_cutoff_tz:'||p_cutoff_tz);

Line 2131: l_distance_uom_code := fnd_profile.value('CSFW_DEFAULT_DISTANCE_UNIT');

2127: AND ploc.address_id = hcsa.cust_acct_site_id
2128: AND ploc.org_id = hcsa.org_id
2129: );
2130:
2131: l_distance_uom_code := fnd_profile.value('CSFW_DEFAULT_DISTANCE_UNIT');
2132: log('get_src_distance','l_distance_uom_code:'||l_distance_uom_code);
2133:
2134: if l_distance_uom_code = 'KM' then
2135: l_distance_uom := 'unit=km';

Line 2169: p_server_timezone_id number := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');

2165: p_cutoff_tz number
2166: ) return date is
2167: l_cutoff date;
2168: l_cutoff_date date := sysdate;
2169: p_server_timezone_id number := FND_PROFILE.VALUE('SERVER_TIMEZONE_ID');
2170: begin
2171: if p_cutoff is null or p_cutoff_tz is null then
2172: return null;
2173: end if;