APPS.PER_FR_REPORT_UTILITIES dependencies on HR_UTILITY

Line 40: hr_utility.set_location('Entering '||l_proc, 10);

36: l_delimeter fnd_id_flex_structures.concatenated_segment_delimiter%type;
37: l_proc varchar2(400);
38: BEGIN
39: l_proc := 'pay_fr_report_utilities.get_job_names';
40: hr_utility.set_location('Entering '||l_proc, 10);
41: l_column_name := NULL;
42: l_select := NULL;
43: hr_utility.set_location('Obtaining segment names '||l_proc, 20);
44: open get_segments;

Line 43: hr_utility.set_location('Obtaining segment names '||l_proc, 20);

39: l_proc := 'pay_fr_report_utilities.get_job_names';
40: hr_utility.set_location('Entering '||l_proc, 10);
41: l_column_name := NULL;
42: l_select := NULL;
43: hr_utility.set_location('Obtaining segment names '||l_proc, 20);
44: open get_segments;
45: loop
46: fetch get_segments into l_select, l_delimeter;
47: exit when get_segments%notfound;

Line 55: hr_utility.set_location('Obtaining segment values '||l_proc, 30);

51: l_column_name := l_column_name ||
52: 'nvl(' || l_select ||', ''_NULL_'')'||
53: ' || '''|| l_delimeter||''' ||';
54: end loop;
55: hr_utility.set_location('Obtaining segment values '||l_proc, 30);
56: if l_column_name is not null then
57: l_column_name := substr(l_column_name, 1, length(l_column_name) - 10);
58: open csr_segment_values for 'select '||l_column_name||
59: ' from per_job_definitions

Line 71: hr_utility.set_location('No segment names '||l_proc, 40);

67: present in rdf file */
68: -- return substr(l_resultant, 1, 20);
69: return l_resultant;
70: else
71: hr_utility.set_location('No segment names '||l_proc, 40);
72: return null;
73: end if;
74: hr_utility.set_location('Leaving '||l_proc, 50);
75: exception

Line 74: hr_utility.set_location('Leaving '||l_proc, 50);

70: else
71: hr_utility.set_location('No segment names '||l_proc, 40);
72: return null;
73: end if;
74: hr_utility.set_location('Leaving '||l_proc, 50);
75: exception
76: when others then
77: hr_utility.set_location('Errored out in '||l_proc, 50);
78: hr_utility.set_location('Error is '||sqlerrm, 60);

Line 77: hr_utility.set_location('Errored out in '||l_proc, 50);

73: end if;
74: hr_utility.set_location('Leaving '||l_proc, 50);
75: exception
76: when others then
77: hr_utility.set_location('Errored out in '||l_proc, 50);
78: hr_utility.set_location('Error is '||sqlerrm, 60);
79: end get_job_names;
80: end per_fr_report_utilities;

Line 78: hr_utility.set_location('Error is '||sqlerrm, 60);

74: hr_utility.set_location('Leaving '||l_proc, 50);
75: exception
76: when others then
77: hr_utility.set_location('Errored out in '||l_proc, 50);
78: hr_utility.set_location('Error is '||sqlerrm, 60);
79: end get_job_names;
80: end per_fr_report_utilities;