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_LF_PUB dependencies on FND_LOG

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 76: fnd_log.string(p_level, 'csf.plsql.CSF_LF_PUB.' || p_module, p_message);

72: ELSE
73: fnd_file.put_line(fnd_file.log, rpad(p_module, 20) || ': ' || p_message);
74: END IF;
75: ELSE
76: fnd_log.string(p_level, 'csf.plsql.CSF_LF_PUB.' || p_module, p_message);
77: END IF;
78: END IF;
79: --dbms_output.put_line(rpad(p_module, 20) || ': ' || p_message);
80: END debug;

Line 158: debug(' --> Inside CSF_LF_ResolveAddress ' , l_api_name, fnd_log.level_statement);

154: WHERE HR_COUNTRY_NAME = p_country;
155: BEGIN
156:
157: IF l_debug THEN
158: debug(' --> Inside CSF_LF_ResolveAddress ' , l_api_name, fnd_log.level_statement);
159: END IF;
160:
161: if ( l_api_version <> p_api_version ) then
162: raise csf_lf_version_error;

Line 206: debug(' --> p_buildingnum = ' || p_buildingnum, l_api_name, fnd_log.level_statement);

202: l_country := p_country;
203: END IF;
204:
205: IF l_debug THEN
206: debug(' --> p_buildingnum = ' || p_buildingnum, l_api_name, fnd_log.level_statement);
207: END IF;
208:
209: IF ((p_buildingnum = NULL) OR (p_buildingnum = ''))
210: THEN

Line 243: debug(' --> l_retCode = ' || l_retCode, l_api_name, fnd_log.level_statement);

239:
240: l_retCode := l_result_int(1).record_type;
241:
242: IF l_debug THEN
243: debug(' --> l_retCode = ' || l_retCode, l_api_name, fnd_log.level_statement);
244: END IF;
245:
246: --
247: -- TODO: Perform Geometry to Locus conversion then load the result array back

Line 306: debug(' --> l_numResults = ' || l_numResults, l_api_name, fnd_log.level_statement);

302: l_numResults := l_result_int.count();
303: x_resultsArray := CSF_LF_RESULTARRAY();
304:
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

Line 327: debug(' --> l_data_set_name = ' || l_data_set_name, l_api_name, fnd_log.level_statement);

323: END;
324: END IF;
325:
326: IF l_debug THEN
327: debug(' --> l_data_set_name = ' || l_data_set_name, l_api_name, fnd_log.level_statement);
328: END IF;
329:
330: sql_stmt_str := 'SELECT nvl(cscp.default_display_center.sdo_srid, 8307) srid
331: FROM csf_sdm_ctry_profiles' || l_data_set_name || ' cscp

Line 344: debug(' --> l_srid = ' || l_srid, l_api_name, fnd_log.level_statement);

340: l_srid := 8307;
341: end if;
342:
343: IF l_debug THEN
344: debug(' --> l_srid = ' || l_srid, l_api_name, fnd_log.level_statement);
345: END IF;
346:
347: for J in 1..l_numresults loop
348:

Line 352: debug(' --> l_result_int(J).lon = ' || l_result_int(J).lon, l_api_name, fnd_log.level_statement);

348:
349: x_resultsArray.extend(1);
350:
351: IF l_debug THEN
352: debug(' --> l_result_int(J).lon = ' || l_result_int(J).lon, l_api_name, fnd_log.level_statement);
353: debug(' --> l_result_int(J).lat = ' || l_result_int(J).lat, l_api_name, fnd_log.level_statement);
354: debug(' --> l_result_int(J).accuracy_fact = ' || l_result_int(J).accuracy_fact, l_api_name, fnd_log.level_statement);
355: debug(' --> l_result_int(J).segment_id = ' || l_result_int(J).segment_id, l_api_name, fnd_log.level_statement);
356: END IF;

Line 353: debug(' --> l_result_int(J).lat = ' || l_result_int(J).lat, l_api_name, fnd_log.level_statement);

349: x_resultsArray.extend(1);
350:
351: IF l_debug THEN
352: debug(' --> l_result_int(J).lon = ' || l_result_int(J).lon, l_api_name, fnd_log.level_statement);
353: debug(' --> l_result_int(J).lat = ' || l_result_int(J).lat, l_api_name, fnd_log.level_statement);
354: debug(' --> l_result_int(J).accuracy_fact = ' || l_result_int(J).accuracy_fact, l_api_name, fnd_log.level_statement);
355: debug(' --> l_result_int(J).segment_id = ' || l_result_int(J).segment_id, l_api_name, fnd_log.level_statement);
356: END IF;
357:

Line 354: debug(' --> l_result_int(J).accuracy_fact = ' || l_result_int(J).accuracy_fact, l_api_name, fnd_log.level_statement);

350:
351: IF l_debug THEN
352: debug(' --> l_result_int(J).lon = ' || l_result_int(J).lon, l_api_name, fnd_log.level_statement);
353: debug(' --> l_result_int(J).lat = ' || l_result_int(J).lat, l_api_name, fnd_log.level_statement);
354: debug(' --> l_result_int(J).accuracy_fact = ' || l_result_int(J).accuracy_fact, l_api_name, fnd_log.level_statement);
355: debug(' --> l_result_int(J).segment_id = ' || l_result_int(J).segment_id, l_api_name, fnd_log.level_statement);
356: END IF;
357:
358: x_resultsArray(J).locus := mdsys.sdo_geometry(2001,l_srid,

Line 355: debug(' --> l_result_int(J).segment_id = ' || l_result_int(J).segment_id, l_api_name, fnd_log.level_statement);

351: IF l_debug THEN
352: debug(' --> l_result_int(J).lon = ' || l_result_int(J).lon, l_api_name, fnd_log.level_statement);
353: debug(' --> l_result_int(J).lat = ' || l_result_int(J).lat, l_api_name, fnd_log.level_statement);
354: debug(' --> l_result_int(J).accuracy_fact = ' || l_result_int(J).accuracy_fact, l_api_name, fnd_log.level_statement);
355: debug(' --> l_result_int(J).segment_id = ' || l_result_int(J).segment_id, l_api_name, fnd_log.level_statement);
356: END IF;
357:
358: x_resultsArray(J).locus := mdsys.sdo_geometry(2001,l_srid,
359: mdsys.sdo_point_type( l_result_int(J).lon

Line 392: debug(' --> End of CSF_LF_ResolveAddress ' , l_api_name, fnd_log.level_statement);

388: x_msg_count := l_numResults;
389: x_msg_data := 'Success';
390:
391: IF l_debug THEN
392: debug(' --> End of CSF_LF_ResolveAddress ' , l_api_name, fnd_log.level_statement);
393: END IF;
394:
395: end if;
396: