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

Line 25: g_debug_enabled := nvl(fnd_profile.value('AFLOG_ENABLED'), 'N');

21: );
22:
23: procedure init_package is
24: begin
25: g_debug_enabled := nvl(fnd_profile.value('AFLOG_ENABLED'), 'N');
26: g_debug_level := nvl(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
27: END init_package;
28:
29: procedure debug(p_message varchar2, p_module varchar2, p_level number) is

Line 26: g_debug_level := nvl(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);

22:
23: procedure init_package is
24: begin
25: g_debug_enabled := nvl(fnd_profile.value('AFLOG_ENABLED'), 'N');
26: g_debug_level := nvl(fnd_profile.value('AFLOG_LEVEL'), fnd_log.level_event);
27: END init_package;
28:
29: procedure debug(p_message varchar2, p_module varchar2, p_level number) is
30: begin

Line 156: l_fmt := fnd_profile.VALUE ('ICX_DATE_FORMAT_MASK');

152: END IF;
153:
154: --
155: -- get date format
156: l_fmt := fnd_profile.VALUE ('ICX_DATE_FORMAT_MASK');
157:
158: IF l_fmt IS NULL
159: THEN
160: l_fmt := 'dd-MON-yyyy';

Line 522: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');

518: l_error_detail := l_error;
519: put_stream (g_output, l_error_detail);
520: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then
521: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
522: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
523: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
524: if (l_exp_accuracy_level = '0') then
525: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
526: end if;

Line 709: l_geo_coder_url:= fnd_profile.value('CSF_GEOSPATIAL_SERVICE_URL');

705: );
706:
707: i_retrieve_task_data task_address_rec_type;
708: BEGIN
709: l_geo_coder_url:= fnd_profile.value('CSF_GEOSPATIAL_SERVICE_URL');
710: IF(l_geo_coder_url is null)
711: THEN
712: l_query := 'SELECT t.task_id,
713: t.task_number,

Line 969: l_mds_enabled:= fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');

965: -- API body
966: i := 1;
967:
968:
969: l_mds_enabled:= fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
970: l_geo_coder_url:= fnd_profile.value('CSF_GEOSPATIAL_SERVICE_URL');
971: --If Single dataset, select tasks which belongs to that dataset
972: --If Multi dataset, select tasks which belongs to datasets listed in csf_spatial_ctry_mappings
973: if( l_mds_enabled = 'N' or l_mds_enabled is null or l_geo_coder_url is not null)

Line 970: l_geo_coder_url:= fnd_profile.value('CSF_GEOSPATIAL_SERVICE_URL');

966: i := 1;
967:
968:
969: l_mds_enabled:= fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
970: l_geo_coder_url:= fnd_profile.value('CSF_GEOSPATIAL_SERVICE_URL');
971: --If Single dataset, select tasks which belongs to that dataset
972: --If Multi dataset, select tasks which belongs to datasets listed in csf_spatial_ctry_mappings
973: if( l_mds_enabled = 'N' or l_mds_enabled is null or l_geo_coder_url is not null)
974: then

Line 1311: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');

1307: IF (l_country is null) THEN
1308: l_country := p_task_rec.country;
1309: END IF;
1310:
1311: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
1312: IF (l_dataset_profile_value = 'N' OR l_dataset_profile_value IS NULL ) THEN
1313: l_dataset_profile_value := '';
1314: ELSE
1315: l_dataset_profile_value := l_spatail_dataset;

Line 1600: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');

1596: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
1597: BEGIN
1598:
1599: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1600: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1601: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1602: IF (l_exp_accuracy_level = '0')
1603: THEN
1604: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');

Line 1913: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');

1909: fnd_message.set_token ('COUNTRY', p_country);
1910: x_error_detail := fnd_message.get;
1911: elsif(x_dup_msg_data = 'CSF_LF 223629:ADDRESS_ACCURACY_EXCEPTION') then
1912: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
1913: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
1914: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
1915: IF (l_exp_accuracy_level = '0') THEN
1916: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');
1917: END IF;

Line 2002: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');

1998: THEN
1999: fnd_msg_pub.initialize;
2000: END IF;
2001:
2002: l_dataset_profile_value := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
2003:
2004: open ctry_hr_to_spatial;
2005: fetch ctry_hr_to_spatial into l_country, l_spatial_dataset;
2006: close ctry_hr_to_spatial;

Line 2305: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');

2301: l_exp_accuracy_level VARCHAR2(5) DEFAULT '0';
2302: BEGIN
2303:
2304: fnd_message.set_name ('CSF', 'CSF_ADDRESS_ACC_FACTOR_ERROR');
2305: l_exp_accuracy_level := fnd_profile.VALUE('CSF_LOC_ACC_LEVELS');
2306: l_exp_accuracy_level := NVL(l_exp_accuracy_level,'0');
2307: IF (l_exp_accuracy_level = '0')
2308: THEN
2309: fnd_message.set_token ('ACCURACY','zip code or city level accuracy');

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

2996: sql_stmt_str VARCHAR2(1000);
2997: l_data_set_name VARCHAR2(40);
2998: BEGIN
2999:
3000: l_data_set_name := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
3001: IF (l_data_set_name = 'N' OR l_data_set_name IS NULL ) THEN
3002: l_data_set_name := '';
3003: ELSE
3004: BEGIN

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

3149: sql_stmt_str VARCHAR2(1000);
3150: l_data_set_name VARCHAR2(40);
3151: BEGIN
3152:
3153: l_data_set_name := fnd_profile.value('CSF_SPATIAL_MULTIDATASET_ENABLED');
3154: IF (l_data_set_name = 'N' OR l_data_set_name IS NULL ) THEN
3155: l_data_set_name := '';
3156: ELSE
3157: BEGIN