51: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
52: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
53:
54: begin
55: --hr_utility.trace_on(null,'EFT');
56: l_payment_method_id := p_payment_method_id;
57:
58: open c_get_name(p_payment_method_id);
59: fetch c_get_name into l_employer_code,l_bank_code,l_id_header,l_id_body,l_id_footer;
475: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
476: l_inputs ff_exec.inputs_t;
477: l_outputs ff_exec.outputs_t;
478: BEGIN
479: hr_utility.set_location('--In Formula ',20);
480: --
481: -- Initialize the formula
482: --
483: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
481: -- Initialize the formula
482: --
483: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
484: --
485: hr_utility.trace('after ff_exec');
486: -- Set up the input values
487: --
488: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
489: FOR i IN l_inputs.first..l_inputs.last LOOP
497: END IF;
498: --
499: -- Run the formula
500: --
501: hr_utility.trace('about to exec');
502: ff_exec.run_formula(l_inputs,l_outputs);
503: --
504: hr_utility.trace('After exec');
505: -- Populate the output table
500: --
501: hr_utility.trace('about to exec');
502: ff_exec.run_formula(l_inputs,l_outputs);
503: --
504: hr_utility.trace('After exec');
505: -- Populate the output table
506: --
507: IF l_outputs.count > 0 and p_inputs.count > 0 then
508: FOR i IN l_outputs.first..l_outputs.last LOOP
513: END IF;
514: END LOOP;
515: END LOOP;
516: END IF;
517: hr_utility.set_location('--Leaving Formula ',21);
518: EXCEPTION
519: WHEN hr_formula_error THEN
520: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
521: fnd_message.set_token('1', g_formula_name);