124: begin
125: g_package := 'pay_ae_general';
126: l_proc := g_package||'.get_message';
127: --
128: hr_utility.set_location('Entered '||l_proc,5);
129: hr_utility.set_location('. Message Name: '||p_message_name,40);
130: fnd_message.set_name(p_product, p_message_name);
131: if p_token1 is not null then
132: -- Obtain token 1 name and value
125: g_package := 'pay_ae_general';
126: l_proc := g_package||'.get_message';
127: --
128: hr_utility.set_location('Entered '||l_proc,5);
129: hr_utility.set_location('. Message Name: '||p_message_name,40);
130: fnd_message.set_name(p_product, p_message_name);
131: if p_token1 is not null then
132: -- Obtain token 1 name and value
133: l_colon_position := instr(p_token1,':');
133: l_colon_position := instr(p_token1,':');
134: l_token_name := substr(p_token1,1,l_colon_position-1);
135: l_token_value := substr(p_token1,l_colon_position+1,length(p_token1));
136: fnd_message.set_token(l_token_name, l_token_value);
137: hr_utility.set_location('. Token1: '||l_token_name||'. Value: '||l_token_value,50);
138: end if;
139: if p_token2 is not null then
140: -- Obtain token 2 name and value
141: l_colon_position := instr(p_token2,':');
141: l_colon_position := instr(p_token2,':');
142: l_token_name := substr(p_token2,1,l_colon_position-1);
143: l_token_value := substr(p_token2,l_colon_position+1,length(p_token2));
144: fnd_message.set_token(l_token_name, l_token_value);
145: hr_utility.set_location('. Token2: '||l_token_name||'. Value: '||l_token_value,60);
146: end if;
147: if p_token3 is not null then
148: -- Obtain token 3 name and value
149: l_colon_position := instr(p_token3,':');
149: l_colon_position := instr(p_token3,':');
150: l_token_name := substr(p_token3,1,l_colon_position-1);
151: l_token_value := substr(p_token3,l_colon_position+1,length(p_token3));
152: fnd_message.set_token(l_token_name, l_token_value);
153: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
154: end if;
155: l_message := substr(fnd_message.get,1,254);
156: hr_utility.set_location('leaving '||l_proc,100);
157: return l_message;
152: fnd_message.set_token(l_token_name, l_token_value);
153: hr_utility.set_location('. Token3: '||l_token_name||'. Value: '||l_token_value,70);
154: end if;
155: l_message := substr(fnd_message.get,1,254);
156: hr_utility.set_location('leaving '||l_proc,100);
157: return l_message;
158: end get_message;
159: ------------------------------------------------------------------------
160: -- Function GET_TABLE_BANDS
195: begin
196: g_package := 'pay_ae_general';
197: l_proc := g_package||'.get_table_bands';
198: --
199: hr_utility.set_location('Entered '||l_proc,5);
200: -- Get the User Table ID
201: OPEN csr_get_user_table_id(p_table_name);
202: FETCH csr_get_user_table_id INTO l_table_id;
203: CLOSE csr_get_user_table_id;
563: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
564: l_inputs ff_exec.inputs_t;
565: l_outputs ff_exec.outputs_t;
566: BEGIN
567: hr_utility.set_location('--In Formula ',20);
568: --
569: -- Initialize the formula
570: --
571: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
569: -- Initialize the formula
570: --
571: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
572: --
573: hr_utility.trace('after ff_exec');
574: -- Set up the input values
575: --
576: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
577: FOR i IN l_inputs.first..l_inputs.last LOOP
585: END IF;
586: --
587: -- Run the formula
588: --
589: hr_utility.trace('about to exec');
590: ff_exec.run_formula(l_inputs,l_outputs);
591: --
592: -- Populate the output table
593: --