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.HR_CAGR_FF_PKG dependencies on HR_UTILITY

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

55:
56: --
57: Begin
58: --
59: hr_utility.set_location('Entering:'|| l_proc, 10);
60: --
61: -- validate arguments prior to calling FF
62: --
63: -- check national identifier is not null

Line 66: hr_utility.set_message(800,'HR_XXXXX_ASSIGNMENT_ID_NULL');

62: --
63: -- check national identifier is not null
64: --
65: if p_assignment_id is null then
66: hr_utility.set_message(800,'HR_XXXXX_ASSIGNMENT_ID_NULL');
67: hr_utility.raise_error;
68: end if;
69: --
70: open csr_formula;

Line 67: hr_utility.raise_error;

63: -- check national identifier is not null
64: --
65: if p_assignment_id is null then
66: hr_utility.set_message(800,'HR_XXXXX_ASSIGNMENT_ID_NULL');
67: hr_utility.raise_error;
68: end if;
69: --
70: open csr_formula;
71:

Line 76: hr_utility.set_location(l_proc, 20);

72: fetch csr_formula into l_formula_name;
73:
74: close csr_formula;
75: --
76: hr_utility.set_location(l_proc, 20);
77: --
78: open csr_assignment;
79:
80: fetch csr_assignment into

Line 90: hr_utility.set_location('l_business_group_id = '||to_char(l_business_group_id),11);

86: --
87: close csr_assignment;
88:
89: --
90: hr_utility.set_location('l_business_group_id = '||to_char(l_business_group_id),11);
91: hr_utility.set_location('l_organization_id = '||to_char(l_organization_id),11);
92: hr_utility.set_location('l_payroll_id = '||to_char(l_payroll_id),11);
93: hr_utility.set_location('l_person_id = '||to_char(l_person_id),11);
94: --

Line 91: hr_utility.set_location('l_organization_id = '||to_char(l_organization_id),11);

87: close csr_assignment;
88:
89: --
90: hr_utility.set_location('l_business_group_id = '||to_char(l_business_group_id),11);
91: hr_utility.set_location('l_organization_id = '||to_char(l_organization_id),11);
92: hr_utility.set_location('l_payroll_id = '||to_char(l_payroll_id),11);
93: hr_utility.set_location('l_person_id = '||to_char(l_person_id),11);
94: --
95: per_cagr_utility_pkg.put_log(' Information : Formula '||l_formula_name);

Line 92: hr_utility.set_location('l_payroll_id = '||to_char(l_payroll_id),11);

88:
89: --
90: hr_utility.set_location('l_business_group_id = '||to_char(l_business_group_id),11);
91: hr_utility.set_location('l_organization_id = '||to_char(l_organization_id),11);
92: hr_utility.set_location('l_payroll_id = '||to_char(l_payroll_id),11);
93: hr_utility.set_location('l_person_id = '||to_char(l_person_id),11);
94: --
95: per_cagr_utility_pkg.put_log(' Information : Formula '||l_formula_name);
96: per_cagr_utility_pkg.put_log(' Information : Business Group ID = '||l_business_group_id);

Line 93: hr_utility.set_location('l_person_id = '||to_char(l_person_id),11);

89: --
90: hr_utility.set_location('l_business_group_id = '||to_char(l_business_group_id),11);
91: hr_utility.set_location('l_organization_id = '||to_char(l_organization_id),11);
92: hr_utility.set_location('l_payroll_id = '||to_char(l_payroll_id),11);
93: hr_utility.set_location('l_person_id = '||to_char(l_person_id),11);
94: --
95: per_cagr_utility_pkg.put_log(' Information : Formula '||l_formula_name);
96: per_cagr_utility_pkg.put_log(' Information : Business Group ID = '||l_business_group_id);
97: per_cagr_utility_pkg.put_log(' Information : Organization ID = '||l_organization_id);

Line 104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);

100: per_cagr_utility_pkg.put_log(' Information : Tax Unit ID = '||l_tax_unit_id);
101:
102: ff_exec.init_formula(p_formula_id,p_effective_date,l_inputs,l_outputs);
103: --
104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);
105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);
106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);
107:
108: if ff_exec.input_count > 0 then

Line 105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);

101:
102: ff_exec.init_formula(p_formula_id,p_effective_date,l_inputs,l_outputs);
103: --
104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);
105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);
106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);
107:
108: if ff_exec.input_count > 0 then
109: per_cagr_utility_pkg.put_log('ERROR : CAGR formula has unexpected Input values defined.');

Line 106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);

102: ff_exec.init_formula(p_formula_id,p_effective_date,l_inputs,l_outputs);
103: --
104: hr_utility.set_location('Inputs='||ff_exec.input_count,6);
105: hr_utility.set_location('Contexts='||ff_exec.context_count,6);
106: hr_utility.set_location('Outputs='||ff_exec.output_count,6);
107:
108: if ff_exec.input_count > 0 then
109: per_cagr_utility_pkg.put_log('ERROR : CAGR formula has unexpected Input values defined.');
110: end if;

Line 117: -- hr_utility.set_location('FF',12);

113: -- end if;
114: -- if ff_exec.output_count > 8 then
115: -- per_cagr_utility_pkg.put_log('ERROR : CAGR formula has more than 8 Output values defined.');
116: -- end if;
117: -- hr_utility.set_location('FF',12);
118: --
119:
120: for l_in_cnt in l_inputs.first..l_inputs.last
121: loop

Line 125: hr_utility.set_location('ASSIGNMENT_ID',13);

121: loop
122: if l_inputs(l_in_cnt).name='ASSIGNMENT_ID' then
123: l_inputs(l_in_cnt).value := p_assignment_id;
124: -- per_cagr_utility_pkg.put_log('Information : Context - Assignment ID');
125: hr_utility.set_location('ASSIGNMENT_ID',13);
126: elsif l_inputs(l_in_cnt).name='DATE_EARNED' then
127: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(p_effective_date);
128: -- per_cagr_utility_pkg.put_log('Information : Context - DATE_EARNED');
129: hr_utility.set_location('DATE_EARNED',14);

Line 129: hr_utility.set_location('DATE_EARNED',14);

125: hr_utility.set_location('ASSIGNMENT_ID',13);
126: elsif l_inputs(l_in_cnt).name='DATE_EARNED' then
127: l_inputs(l_in_cnt).value := fnd_date.date_to_canonical(p_effective_date);
128: -- per_cagr_utility_pkg.put_log('Information : Context - DATE_EARNED');
129: hr_utility.set_location('DATE_EARNED',14);
130: elsif l_inputs(l_in_cnt).name='PERSON_ID' then
131: l_inputs(l_in_cnt).value := l_person_id;
132: -- per_cagr_utility_pkg.put_log('Information : Context - PERSON_ID');
133: hr_utility.set_location('PERSON_ID',15);

Line 133: hr_utility.set_location('PERSON_ID',15);

129: hr_utility.set_location('DATE_EARNED',14);
130: elsif l_inputs(l_in_cnt).name='PERSON_ID' then
131: l_inputs(l_in_cnt).value := l_person_id;
132: -- per_cagr_utility_pkg.put_log('Information : Context - PERSON_ID');
133: hr_utility.set_location('PERSON_ID',15);
134: elsif l_inputs(l_in_cnt).name='ORGANIZATION_ID' then
135: l_inputs(l_in_cnt).value := l_organization_id;
136: -- per_cagr_utility_pkg.put_log('Information : Context - ORGANIZATION_ID');
137: hr_utility.set_location('ORGANIZATION_ID',16);

Line 137: hr_utility.set_location('ORGANIZATION_ID',16);

133: hr_utility.set_location('PERSON_ID',15);
134: elsif l_inputs(l_in_cnt).name='ORGANIZATION_ID' then
135: l_inputs(l_in_cnt).value := l_organization_id;
136: -- per_cagr_utility_pkg.put_log('Information : Context - ORGANIZATION_ID');
137: hr_utility.set_location('ORGANIZATION_ID',16);
138: elsif l_inputs(l_in_cnt).name='BUSINESS_GROUP_ID' then
139: l_inputs(l_in_cnt).value := l_business_group_id;
140: -- per_cagr_utility_pkg.put_log('Information : Context - BUSINESS_GROUP_ID');
141: hr_utility.set_location('BUSINESS_GROUP_ID',17);

Line 141: hr_utility.set_location('BUSINESS_GROUP_ID',17);

137: hr_utility.set_location('ORGANIZATION_ID',16);
138: elsif l_inputs(l_in_cnt).name='BUSINESS_GROUP_ID' then
139: l_inputs(l_in_cnt).value := l_business_group_id;
140: -- per_cagr_utility_pkg.put_log('Information : Context - BUSINESS_GROUP_ID');
141: hr_utility.set_location('BUSINESS_GROUP_ID',17);
142: elsif l_inputs(l_in_cnt).name='PAYROLL_ID' then
143: l_inputs(l_in_cnt).value := l_payroll_id;
144: -- per_cagr_utility_pkg.put_log('Information : Context - PAYROLL_ID');
145: hr_utility.set_location('PAYROLL_ID',18);

Line 145: hr_utility.set_location('PAYROLL_ID',18);

141: hr_utility.set_location('BUSINESS_GROUP_ID',17);
142: elsif l_inputs(l_in_cnt).name='PAYROLL_ID' then
143: l_inputs(l_in_cnt).value := l_payroll_id;
144: -- per_cagr_utility_pkg.put_log('Information : Context - PAYROLL_ID');
145: hr_utility.set_location('PAYROLL_ID',18);
146: elsif l_inputs(l_in_cnt).name='TAX_UNIT_ID' then
147: l_inputs(l_in_cnt).value := l_tax_unit_id;
148: -- per_cagr_utility_pkg.put_log('Information : Context - TAX_UNIT_ID');
149: hr_utility.set_location('TAX_UNIT_ID',19);

Line 149: hr_utility.set_location('TAX_UNIT_ID',19);

145: hr_utility.set_location('PAYROLL_ID',18);
146: elsif l_inputs(l_in_cnt).name='TAX_UNIT_ID' then
147: l_inputs(l_in_cnt).value := l_tax_unit_id;
148: -- per_cagr_utility_pkg.put_log('Information : Context - TAX_UNIT_ID');
149: hr_utility.set_location('TAX_UNIT_ID',19);
150: end if;
151: -- per_cagr_utility_pkg.put_log('Information : End of Context Section ');
152: end loop;
153: --

Line 154: hr_utility.set_location(l_proc, 15);

150: end if;
151: -- per_cagr_utility_pkg.put_log('Information : End of Context Section ');
152: end loop;
153: --
154: hr_utility.set_location(l_proc, 15);
155: --
156: --
157: -- per_cagr_utility_pkg.put_log('Before Start of Run Formula ');
158: ff_exec.run_formula

Line 210: -- hr_utility.set_location('Mandatory Outputs missing for Category '||p_category_name,100);

206: -- if
207: -- (p_out_rec.parent_spine_id is null OR
208: -- p_out_rec.step_id is null OR
209: -- p_out_rec.grade_spine_id is null) THEN
210: -- hr_utility.set_location('Mandatory Outputs missing for Category '||p_category_name,100);
211: -- per_cagr_utility_pkg.put_log('Warning : Mandatory Outputs missing for Category '||p_category_name);
212: -- end if;
213: if
214: (p_out_rec.value is not null OR

Line 217: hr_utility.set_location('Invalid Outputs Returned for Category '||p_category_name,200);

213: if
214: (p_out_rec.value is not null OR
215: p_out_rec.range_from is not null OR
216: p_out_rec.range_to is not null) THEN
217: hr_utility.set_location('Invalid Outputs Returned for Category '||p_category_name,200);
218: per_cagr_utility_pkg.put_log('Warning : Invalid Outputs Returned for Category '||p_category_name);
219: end if;
220: elsif p_category_name in ('ASG','PAY','ABS') then
221: -- if

Line 223: -- hr_utility.set_location('Mandatory Output missing for Category '||p_category_name,300);

219: end if;
220: elsif p_category_name in ('ASG','PAY','ABS') then
221: -- if
222: -- p_out_rec.value is null then
223: -- hr_utility.set_location('Mandatory Output missing for Category '||p_category_name,300);
224: -- per_cagr_utility_pkg.put_log('Warning : Mandatory Output missing for Category '||p_category_name);
225: -- end if;
226: if
227: (p_out_rec.parent_spine_id is not null OR

Line 232: hr_utility.set_location('Invalid Outputs Returned for Category '||p_category_name,400);

228: p_out_rec.step_id is not null OR
229: p_out_rec.from_step_id is not null OR
230: p_out_rec.to_step_id is not null or
231: p_out_rec.grade_spine_id is not null) THEN
232: hr_utility.set_location('Invalid Outputs Returned for Category '||p_category_name,400);
233: per_cagr_utility_pkg.put_log('Warning : Invalid Outputs Returned for Category '||p_category_name);
234: end if;
235: else
236: hr_utility.set_location('Incorrect Category Name = '||p_category_name,500);

Line 236: hr_utility.set_location('Incorrect Category Name = '||p_category_name,500);

232: hr_utility.set_location('Invalid Outputs Returned for Category '||p_category_name,400);
233: per_cagr_utility_pkg.put_log('Warning : Invalid Outputs Returned for Category '||p_category_name);
234: end if;
235: else
236: hr_utility.set_location('Incorrect Category Name = '||p_category_name,500);
237: per_cagr_utility_pkg.put_log('Warning : Category is incorrect');
238: end if;
239:
240: hr_utility.set_location('Leaving:'|| l_proc, 22);

Line 240: hr_utility.set_location('Leaving:'|| l_proc, 22);

236: hr_utility.set_location('Incorrect Category Name = '||p_category_name,500);
237: per_cagr_utility_pkg.put_log('Warning : Category is incorrect');
238: end if;
239:
240: hr_utility.set_location('Leaving:'|| l_proc, 22);
241: --
242: per_cagr_utility_pkg.put_log(' Information : End of Fast Formula Evaluation.');
243: EXCEPTION
244: when OTHERS then

Line 246: hr_utility.set_location('Formula Not Compiled',600);

242: per_cagr_utility_pkg.put_log(' Information : End of Fast Formula Evaluation.');
243: EXCEPTION
244: when OTHERS then
245: p_out_rec := null;
246: hr_utility.set_location('Formula Not Compiled',600);
247: -- per_cagr_utility_pkg.put_log('Error : Formula '||l_formula_name||' has not been compiled or is invalid : '||sqlerrm,1);
248: per_cagr_utility_pkg.put_log('Error : Formula '||l_formula_name);
249: per_cagr_utility_pkg.put_log('Error : '||sqlerrm);
250: --