4: g_package varchar2(33) := ' per_formula_functions.'; -- Global package name
5: hr_formula_application_id number;
6: hr_formula_message varchar2(80);
7: hr_formula_error exception;
8: /* Use a random user-defined errnum, using -20001 affects fnd_message calls */
9: pragma exception_init (hr_formula_error, -201);
10:
11: --
12: /* =====================================================================
347:
348: if l_formula_id = 0 then
349: --
350: hr_utility.set_location(l_proc, 10);
351: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
352: fnd_message.set_token('1', p_formula_name);
353: fnd_message.raise_error;
354: --
355: else
348: if l_formula_id = 0 then
349: --
350: hr_utility.set_location(l_proc, 10);
351: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
352: fnd_message.set_token('1', p_formula_name);
353: fnd_message.raise_error;
354: --
355: else
356: --
349: --
350: hr_utility.set_location(l_proc, 10);
351: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
352: fnd_message.set_token('1', p_formula_name);
353: fnd_message.raise_error;
354: --
355: else
356: --
357:
492: );
493:
494: if l_formula_id = 0 then
495: hr_utility.set_location(l_proc, 10);
496: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
497: fnd_message.set_token('1', p_formula_name);
498: fnd_message.raise_error;
499: else
500: run_formula(p_formula_id => l_formula_id,
493:
494: if l_formula_id = 0 then
495: hr_utility.set_location(l_proc, 10);
496: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
497: fnd_message.set_token('1', p_formula_name);
498: fnd_message.raise_error;
499: else
500: run_formula(p_formula_id => l_formula_id,
501: p_calculation_date => p_calculation_date,
494: if l_formula_id = 0 then
495: hr_utility.set_location(l_proc, 10);
496: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
497: fnd_message.set_token('1', p_formula_name);
498: fnd_message.raise_error;
499: else
500: run_formula(p_formula_id => l_formula_id,
501: p_calculation_date => p_calculation_date,
502: p_inputs => p_inputs,
549: open csr_get_ff_name;
550: fetch csr_get_ff_name into l_formula_name;
551: close csr_get_ff_name;
552:
553: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
554: fnd_message.set_token('1', l_formula_name);
555: fnd_message.raise_error;
556: else
557: --
550: fetch csr_get_ff_name into l_formula_name;
551: close csr_get_ff_name;
552:
553: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
554: fnd_message.set_token('1', l_formula_name);
555: fnd_message.raise_error;
556: else
557: --
558: ----------------------------
551: close csr_get_ff_name;
552:
553: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
554: fnd_message.set_token('1', l_formula_name);
555: fnd_message.raise_error;
556: else
557: --
558: ----------------------------
559: -- Initialize the formula --