150: ,g_rate_type);
151: /* hr_currency_pkg.convert_amount returns negative value in case of invalid currency/date combination.
152: Return the original value in such a case*/
153: if(l_converted_amount>=0) then
154: fnd_message.set_name('PER','HR_MULTI_CURR_FMT');
155: fnd_message.set_token('FROM_AMT',to_char(p_amount,
156: fnd_currency.get_format_mask(p_from_currency,25)),false);
157: fnd_message.set_token('FROM_CURR',p_from_currency,false);
158: fnd_message.set_token('TO_AMT',to_char(l_converted_amount,
151: /* hr_currency_pkg.convert_amount returns negative value in case of invalid currency/date combination.
152: Return the original value in such a case*/
153: if(l_converted_amount>=0) then
154: fnd_message.set_name('PER','HR_MULTI_CURR_FMT');
155: fnd_message.set_token('FROM_AMT',to_char(p_amount,
156: fnd_currency.get_format_mask(p_from_currency,25)),false);
157: fnd_message.set_token('FROM_CURR',p_from_currency,false);
158: fnd_message.set_token('TO_AMT',to_char(l_converted_amount,
159: fnd_currency.get_format_mask(l_to_currency,25)),false);
153: if(l_converted_amount>=0) then
154: fnd_message.set_name('PER','HR_MULTI_CURR_FMT');
155: fnd_message.set_token('FROM_AMT',to_char(p_amount,
156: fnd_currency.get_format_mask(p_from_currency,25)),false);
157: fnd_message.set_token('FROM_CURR',p_from_currency,false);
158: fnd_message.set_token('TO_AMT',to_char(l_converted_amount,
159: fnd_currency.get_format_mask(l_to_currency,25)),false);
160: fnd_message.set_token('TO_CURR',l_to_currency,false);
161: return (fnd_message.get);
154: fnd_message.set_name('PER','HR_MULTI_CURR_FMT');
155: fnd_message.set_token('FROM_AMT',to_char(p_amount,
156: fnd_currency.get_format_mask(p_from_currency,25)),false);
157: fnd_message.set_token('FROM_CURR',p_from_currency,false);
158: fnd_message.set_token('TO_AMT',to_char(l_converted_amount,
159: fnd_currency.get_format_mask(l_to_currency,25)),false);
160: fnd_message.set_token('TO_CURR',l_to_currency,false);
161: return (fnd_message.get);
162: else
156: fnd_currency.get_format_mask(p_from_currency,25)),false);
157: fnd_message.set_token('FROM_CURR',p_from_currency,false);
158: fnd_message.set_token('TO_AMT',to_char(l_converted_amount,
159: fnd_currency.get_format_mask(l_to_currency,25)),false);
160: fnd_message.set_token('TO_CURR',l_to_currency,false);
161: return (fnd_message.get);
162: else
163: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
164: fnd_message.set_token('FROM_AMT',to_char(p_amount,
157: fnd_message.set_token('FROM_CURR',p_from_currency,false);
158: fnd_message.set_token('TO_AMT',to_char(l_converted_amount,
159: fnd_currency.get_format_mask(l_to_currency,25)),false);
160: fnd_message.set_token('TO_CURR',l_to_currency,false);
161: return (fnd_message.get);
162: else
163: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
164: fnd_message.set_token('FROM_AMT',to_char(p_amount,
165: fnd_currency.get_format_mask(p_from_currency,25)),false);
159: fnd_currency.get_format_mask(l_to_currency,25)),false);
160: fnd_message.set_token('TO_CURR',l_to_currency,false);
161: return (fnd_message.get);
162: else
163: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
164: fnd_message.set_token('FROM_AMT',to_char(p_amount,
165: fnd_currency.get_format_mask(p_from_currency,25)),false);
166: fnd_message.set_token('FROM_CURR',p_from_currency,false);
167: return (fnd_message.get);
160: fnd_message.set_token('TO_CURR',l_to_currency,false);
161: return (fnd_message.get);
162: else
163: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
164: fnd_message.set_token('FROM_AMT',to_char(p_amount,
165: fnd_currency.get_format_mask(p_from_currency,25)),false);
166: fnd_message.set_token('FROM_CURR',p_from_currency,false);
167: return (fnd_message.get);
168: end if;
162: else
163: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
164: fnd_message.set_token('FROM_AMT',to_char(p_amount,
165: fnd_currency.get_format_mask(p_from_currency,25)),false);
166: fnd_message.set_token('FROM_CURR',p_from_currency,false);
167: return (fnd_message.get);
168: end if;
169: Exception When Others then
170: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
163: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
164: fnd_message.set_token('FROM_AMT',to_char(p_amount,
165: fnd_currency.get_format_mask(p_from_currency,25)),false);
166: fnd_message.set_token('FROM_CURR',p_from_currency,false);
167: return (fnd_message.get);
168: end if;
169: Exception When Others then
170: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
171: fnd_message.set_token('FROM_AMT',to_char(p_amount,
166: fnd_message.set_token('FROM_CURR',p_from_currency,false);
167: return (fnd_message.get);
168: end if;
169: Exception When Others then
170: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
171: fnd_message.set_token('FROM_AMT',to_char(p_amount,
172: fnd_currency.get_format_mask(p_from_currency,25)),false);
173: fnd_message.set_token('FROM_CURR',p_from_currency,false);
174: return (fnd_message.get);
167: return (fnd_message.get);
168: end if;
169: Exception When Others then
170: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
171: fnd_message.set_token('FROM_AMT',to_char(p_amount,
172: fnd_currency.get_format_mask(p_from_currency,25)),false);
173: fnd_message.set_token('FROM_CURR',p_from_currency,false);
174: return (fnd_message.get);
175: END get_in_preferred_currency_str;
169: Exception When Others then
170: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
171: fnd_message.set_token('FROM_AMT',to_char(p_amount,
172: fnd_currency.get_format_mask(p_from_currency,25)),false);
173: fnd_message.set_token('FROM_CURR',p_from_currency,false);
174: return (fnd_message.get);
175: END get_in_preferred_currency_str;
176:
177: FUNCTION getCompSourceInfo (
170: fnd_message.set_name('PER','HR_MULTI_CURR_FROM_FMT');
171: fnd_message.set_token('FROM_AMT',to_char(p_amount,
172: fnd_currency.get_format_mask(p_from_currency,25)),false);
173: fnd_message.set_token('FROM_CURR',p_from_currency,false);
174: return (fnd_message.get);
175: END get_in_preferred_currency_str;
176:
177: FUNCTION getCompSourceInfo (
178: p_competence_id IN NUMBER
284: ,p_object_name => p_object_name
285: ,p_instance_pk1_value => p_person_id
286: ,p_instance_pk2_value => p_instance_pk2_value);
287: IF l_status = 'E' OR l_status = 'U' THEN
288: hr_utility.trace('Error in fnd_data_security.check_function l_status is: '||l_status||'. Error is: '|| replace(fnd_message.get_encoded(), chr(0), ' '));
289: l_status := 'F';
290: END IF;
291:
292: IF g_debug then