APPS.CSF_GPS_PUB dependencies on FND_PROFILE

Line 15: IF NVL(fnd_profile.value('AFLOG_ENABLED'), 'N') = 'Y'

11: IF p_level = g_level_cp_output AND fnd_file.output > 0 THEN
12: fnd_file.put_line(fnd_file.output, p_message);
13: END IF;
14:
15: IF NVL(fnd_profile.value('AFLOG_ENABLED'), 'N') = 'Y'
16: AND p_level >= NVL(fnd_profile.value('AFLOG_LEVEL'), 1)
17: THEN
18: IF fnd_file.log > 0 THEN
19: IF p_message = ' ' THEN

Line 16: AND p_level >= NVL(fnd_profile.value('AFLOG_LEVEL'), 1)

12: fnd_file.put_line(fnd_file.output, p_message);
13: END IF;
14:
15: IF NVL(fnd_profile.value('AFLOG_ENABLED'), 'N') = 'Y'
16: AND p_level >= NVL(fnd_profile.value('AFLOG_LEVEL'), 1)
17: THEN
18: IF fnd_file.log > 0 THEN
19: IF p_message = ' ' THEN
20: fnd_file.put_line(fnd_file.log, '');

Line 414: l_datetime_format fnd_profile_option_values.profile_option_value%TYPE;

410: SELECT resource_id, resource_type
411: FROM jtf_terr_rsc_all
412: WHERE terr_id = p_territory_id;
413:
414: l_datetime_format fnd_profile_option_values.profile_option_value%TYPE;
415:
416: BEGIN
417: fnd_message.set_name('CSF', 'CSF_GPS_PURGE_CP_STARTED');
418: debug(fnd_message.get, l_api_name, g_level_cp_output, 0);

Line 437: l_datetime_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');

433: l_start_date := SYSDATE - trunc(p_num_days);
434: l_end_date := SYSDATE;
435: END IF;
436:
437: l_datetime_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
438: IF l_datetime_format IS NULL THEN
439: l_datetime_format := 'DD-MM-YYYY HH24:MI';
440: ELSE
441: l_datetime_format := l_datetime_format || ' HH24:MI';