APPS.CSF_LF_PUB dependencies on FND_PROFILE

Line 4: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

1: PACKAGE BODY CSF_LF_PUB AS
2: /*$Header: CSFPLFB.pls 120.20 2011/04/25 13:32:47 sseshaiy ship $*/
3:
4: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
5: g_debug_level NUMBER := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
6:
7: -- ----------------------------------------------------------------------------
8: -- register JSP

Line 5: g_debug_level NUMBER := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);

1: PACKAGE BODY CSF_LF_PUB AS
2: /*$Header: CSFPLFB.pls 120.20 2011/04/25 13:32:47 sseshaiy ship $*/
3:
4: g_debug VARCHAR2(1) := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
5: g_debug_level NUMBER := NVL(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
6:
7: -- ----------------------------------------------------------------------------
8: -- register JSP
9: -- ----------------------------------------------------------------------------

Line 194: l_requiredAccuracy := NVL(fnd_profile.value('CSF_LOC_ACC_LEVELS'),''+0);

190: --l_result_int := RESOLVEADDRESS(p_country, p_state, p_city, p_postalCode, p_roadName, p_buildingnum, p_alternate);
191: --l_result_int := RESOLVEADDRESS(p_country, p_state, p_city, p_postalCode, p_roadName, '_', p_alternate);
192:
193: -- added for LF enhancement of forced accuracy
194: l_requiredAccuracy := NVL(fnd_profile.value('CSF_LOC_ACC_LEVELS'),''+0);
195:
196: /** Bug 7570463 **/
197: open ctry_hr_to_spatial;
198: fetch ctry_hr_to_spatial into l_country;

Line 309: l_data_set_name := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');

305: IF l_debug THEN
306: debug(' --> l_numResults = ' || l_numResults, l_api_name, fnd_log.level_statement);
307: END IF;
308:
309: l_data_set_name := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
310: IF (l_data_set_name = 'N' OR l_data_set_name IS NULL ) THEN
311: l_data_set_name := '';
312: ELSE
313: BEGIN

Line 339: if((NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'N') OR l_srid IS NULL) then

335: FETCH C_SRID INTO l_srid;
336: CLOSE C_SRID;
337:
338: -- Fix for bug 9299548
339: if((NVL(fnd_profile.VALUE('CSF_LF_INSTALLED'),'N') = 'N') OR l_srid IS NULL) then
340: l_srid := 8307;
341: end if;
342:
343: IF l_debug THEN

Line 489: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

485: /* select roadsegment_geometry into segmentGeometry
486: from csf_lf_roadsegments
487: where roadSegment_id = x_segid; */
488:
489: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
490: IF (l_data_set_name = 'NONE' OR l_data_set_name IS NULL ) THEN
491: l_data_set_name := '';
492: END IF;
493:

Line 634: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');

630: /* select time_zone into x_timezone
631: from csf_lf_roadsegments
632: where roadsegment_id = p_locus.sdo_ordinates(6); */
633:
634: l_data_set_name := fnd_profile.value('CSF_SPATIAL_DATASET_NAME');
635: IF (l_data_set_name = 'NONE' OR l_data_set_name IS NULL ) THEN
636: l_data_set_name := '';
637: END IF;
638: sql_stmt_str := 'SELECT time_zone into x_timezone