APPS.PA_TIMELINE_UTIL dependencies on FND_PROFILE

Line 16: g_debug_mode CONSTANT varchar2(1) := fnd_profile.value('PA_DEBUG_MODE');

12: --
13:
14: -- Global variables Added for bug No 5079785.
15:
16: g_debug_mode CONSTANT varchar2(1) := fnd_profile.value('PA_DEBUG_MODE');
17: --fnd_profile.get('PA_DEBUG_MODE', g_debug_mode);
18: PROCEDURE Create_Time_Scale (p_start_date IN DATE,
19: p_end_date IN DATE := null,
20: p_scale_type IN VARCHAR2,

Line 17: --fnd_profile.get('PA_DEBUG_MODE', g_debug_mode);

13:
14: -- Global variables Added for bug No 5079785.
15:
16: g_debug_mode CONSTANT varchar2(1) := fnd_profile.value('PA_DEBUG_MODE');
17: --fnd_profile.get('PA_DEBUG_MODE', g_debug_mode);
18: PROCEDURE Create_Time_Scale (p_start_date IN DATE,
19: p_end_date IN DATE := null,
20: p_scale_type IN VARCHAR2,
21: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 254: -- Retrieve week_ending_index from the FND profile value.

250: p_given_date IN DATE) RETURN DATE IS
251:
252: x_week_ending DATE;
253: x_week_ending_day VARCHAR2(80);
254: -- Retrieve week_ending_index from the FND profile value.
255: x_week_ending_day_index NUMBER := TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')) + 6;
256:
257:
258: BEGIN

Line 255: x_week_ending_day_index NUMBER := TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')) + 6;

251:
252: x_week_ending DATE;
253: x_week_ending_day VARCHAR2(80);
254: -- Retrieve week_ending_index from the FND profile value.
255: x_week_ending_day_index NUMBER := TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY')) + 6;
256:
257:
258: BEGIN
259:

Line 495: FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_RES_CAPACITY_PERCENTAGE'));

491: BEGIN
492: BEGIN
493:
494: TmpTimelineProfileSetup.res_capacity_percentage :=
495: FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_RES_CAPACITY_PERCENTAGE'));
496:
497:
498: TmpTimelineProfileSetup.availability_cal_period :=
499: FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');

Line 499: FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');

495: FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_RES_CAPACITY_PERCENTAGE'));
496:
497:
498: TmpTimelineProfileSetup.availability_cal_period :=
499: FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
500:
501:
502: TmpTimelineProfileSetup.availability_duration :=
503: FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_AVAILABILITY_DURATION'));

Line 503: FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_AVAILABILITY_DURATION'));

499: FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
500:
501:
502: TmpTimelineProfileSetup.availability_duration :=
503: FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_AVAILABILITY_DURATION'));
504:
505: EXCEPTION
506: WHEN OTHERS THEN
507: raise;

Line 546: -- fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);

542: BEGIN
543: -- dbms_output.put_line('log : ' || 'pa.plsql.pa_timeline_pvt' ||
544: -- ' : ' || p_text);
545: -- commented for Bug 5079785 chenged from l_debug_mode to g_debug_mode
546: -- fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
547: -- IF l_debug_mode = 'Y' THEN
548: IF g_debug_mode = 'Y' THEN
549: PA_DEBUG.WRITE_LOG(
550: x_module => 'pa.plsql.pa_timeline_pvt',

Line 565: -- fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);

561: -- l_debug_mode VARCHAR2(20) := 'N'; -- Added for Bug 4344821
562: BEGIN
563: -- dbms_output.put_line('log : ' || p_module || ' : ' || p_msg);
564: -- commented for Bug 5079785 chenged from l_debug_mode to g_debug_mode
565: -- fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);
566: -- IF l_debug_mode = 'Y' THEN
567: IF g_debug_mode ='Y' THEN
568: PA_DEBUG.WRITE_LOG(
569: x_module => p_module,