DBA Data[Home] [Help]

APPS.HR_FR_MMO dependencies on HR_UTILITY

Line 222: hr_utility.set_location(' Entering:'||l_proc, 5);

218: l_inputs ff_exec.inputs_t;
219: l_outputs ff_exec.outputs_t;
220: --
221: Begin
222: hr_utility.set_location(' Entering:'||l_proc, 5);
223: --
224: -- Initialize the formula
225: --
226: hr_utility.set_location(' Initialize formula '||l_proc, 5);

Line 226: hr_utility.set_location(' Initialize formula '||l_proc, 5);

222: hr_utility.set_location(' Entering:'||l_proc, 5);
223: --
224: -- Initialize the formula
225: --
226: hr_utility.set_location(' Initialize formula '||l_proc, 5);
227: select formula_id,effective_start_date
228: into l_formula_id,l_effective_start_date
229: from ff_formulas_f
230: where formula_id = p_formula_id;

Line 232: hr_utility.set_location('formula id found : ' || to_char(l_formula_id),500);

228: into l_formula_id,l_effective_start_date
229: from ff_formulas_f
230: where formula_id = p_formula_id;
231:
232: hr_utility.set_location('formula id found : ' || to_char(l_formula_id),500);
233:
234: ff_exec.init_formula (l_formula_id,
235: l_effective_start_date,
236: l_inputs,

Line 240: hr_utility.set_location(' set context variables '||l_proc, 6);

236: l_inputs,
237: l_outputs
238: );
239:
240: hr_utility.set_location(' set context variables '||l_proc, 6);
241:
242: if (l_inputs.first is not null) and (l_inputs.last is not null)
243: then
244: -- Set up context values for the formula

Line 248: hr_utility.set_location(' in the loop ... ' || to_char(l_in_cnt),7);

244: -- Set up context values for the formula
245: for l_in_cnt in
246: l_inputs.first..l_inputs.last
247: loop
248: hr_utility.set_location(' in the loop ... ' || to_char(l_in_cnt),7);
249: if l_inputs(l_in_cnt).name='ASSIGNMENT_ID' then
250: l_inputs(l_in_cnt).value := p_assignment_id;
251: hr_utility.set_location(' ASSIGNMENT_ID .. done' ,7);
252: end if;

Line 251: hr_utility.set_location(' ASSIGNMENT_ID .. done' ,7);

247: loop
248: hr_utility.set_location(' in the loop ... ' || to_char(l_in_cnt),7);
249: if l_inputs(l_in_cnt).name='ASSIGNMENT_ID' then
250: l_inputs(l_in_cnt).value := p_assignment_id;
251: hr_utility.set_location(' ASSIGNMENT_ID .. done' ,7);
252: end if;
253: if l_inputs(l_in_cnt).name='DATE_EARNED' then
254: l_inputs(l_in_cnt).value := p_starting_date;
255: hr_utility.set_location(' DATE_EARNED .. done' ,7);

Line 255: hr_utility.set_location(' DATE_EARNED .. done' ,7);

251: hr_utility.set_location(' ASSIGNMENT_ID .. done' ,7);
252: end if;
253: if l_inputs(l_in_cnt).name='DATE_EARNED' then
254: l_inputs(l_in_cnt).value := p_starting_date;
255: hr_utility.set_location(' DATE_EARNED .. done' ,7);
256: end if;
257: if l_inputs(l_in_cnt).name='TRANSFER_DATE' then
258: l_inputs(l_in_cnt).value := p_starting_date;
259: hr_utility.set_location(' TRANSFER_DATE .. done' ,7);

Line 259: hr_utility.set_location(' TRANSFER_DATE .. done' ,7);

255: hr_utility.set_location(' DATE_EARNED .. done' ,7);
256: end if;
257: if l_inputs(l_in_cnt).name='TRANSFER_DATE' then
258: l_inputs(l_in_cnt).value := p_starting_date;
259: hr_utility.set_location(' TRANSFER_DATE .. done' ,7);
260: end if;
261: if l_inputs(l_in_cnt).name='SWITCH_STARTING_LEAVING' then
262: l_inputs(l_in_cnt).value := p_switch_starting_leaving;
263: hr_utility.set_location('SWITCH_STARTING_LEAVING .. done' ,7);

Line 263: hr_utility.set_location('SWITCH_STARTING_LEAVING .. done' ,7);

259: hr_utility.set_location(' TRANSFER_DATE .. done' ,7);
260: end if;
261: if l_inputs(l_in_cnt).name='SWITCH_STARTING_LEAVING' then
262: l_inputs(l_in_cnt).value := p_switch_starting_leaving;
263: hr_utility.set_location('SWITCH_STARTING_LEAVING .. done' ,7);
264: end if;
265: end loop;
266: end if;
267:

Line 272: hr_utility.set_location(' Prior to execute the formula',8);

268: --
269: -- Run the formula
270: --
271:
272: hr_utility.set_location(' Prior to execute the formula',8);
273: ff_exec.run_formula (l_inputs ,
274: l_outputs
275: );
276:

Line 277: hr_utility.set_location(' End run formula',9);

273: ff_exec.run_formula (l_inputs ,
274: l_outputs
275: );
276:
277: hr_utility.set_location(' End run formula',9);
278:
279: for l_out_cnt in
280: l_outputs.first..l_outputs.last
281: loop

Line 287: hr_utility.set_location(' After run ..return value = ' || l_return_value,9);

283: l_return_value := l_outputs(l_out_cnt).value;
284: end if;
285: end loop;
286:
287: hr_utility.set_location(' After run ..return value = ' || l_return_value,9);
288:
289: Return l_return_value;
290: End Get_reason;
291: --