eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PL_UTILITY dependencies on FND_MESSAGE

Line 205: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');

201:
202: if p_nationality = 'PQH_PL' and p_citizenship = 'PL' then
203: begin
204: if length (p_nip_number) > 10 then
205: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
206: fnd_message.raise_error;
207: end if;
208:
209: if to_number (p_nip_number) = 0 then

Line 206: fnd_message.raise_error;

202: if p_nationality = 'PQH_PL' and p_citizenship = 'PL' then
203: begin
204: if length (p_nip_number) > 10 then
205: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
206: fnd_message.raise_error;
207: end if;
208:
209: if to_number (p_nip_number) = 0 then
210: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');

Line 210: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');

206: fnd_message.raise_error;
207: end if;
208:
209: if to_number (p_nip_number) = 0 then
210: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
211: fnd_message.raise_error;
212: end if;
213:
214: nip_number (1) := 6 * (to_number (substr (p_nip_number, 1, 1)));

Line 211: fnd_message.raise_error;

207: end if;
208:
209: if to_number (p_nip_number) = 0 then
210: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
211: fnd_message.raise_error;
212: end if;
213:
214: nip_number (1) := 6 * (to_number (substr (p_nip_number, 1, 1)));
215: nip_number (2) := 5 * (to_number (substr (p_nip_number, 2, 1)));

Line 234: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');

230: );
231:
232: if nip_sum = 10 then
233: if nip_number (10) <> 0 then
234: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
235: fnd_message.raise_error;
236: end if;
237: elsif nip_sum <> nip_number (10) then
238: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');

Line 235: fnd_message.raise_error;

231:
232: if nip_sum = 10 then
233: if nip_number (10) <> 0 then
234: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
235: fnd_message.raise_error;
236: end if;
237: elsif nip_sum <> nip_number (10) then
238: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
239: fnd_message.raise_error;

Line 238: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');

234: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
235: fnd_message.raise_error;
236: end if;
237: elsif nip_sum <> nip_number (10) then
238: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
239: fnd_message.raise_error;
240: end if;
241:
242: -- Uniqueness Check at legal employer level for Polish Persons

Line 239: fnd_message.raise_error;

235: fnd_message.raise_error;
236: end if;
237: elsif nip_sum <> nip_number (10) then
238: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
239: fnd_message.raise_error;
240: end if;
241:
242: -- Uniqueness Check at legal employer level for Polish Persons
243: if p_nip_number is not null and p_business_group_id is not null then

Line 248: fnd_message.set_name ('PER', 'HR_NIP_UNIQUE_NUMBER_PL');

244: open nip;
245: fetch nip into nip_number_dup;
246:
247: if nip_number_dup = p_nip_number then
248: fnd_message.set_name ('PER', 'HR_NIP_UNIQUE_NUMBER_PL');
249: fnd_message.raise_error;
250: end if;
251:
252: close nip;

Line 249: fnd_message.raise_error;

245: fetch nip into nip_number_dup;
246:
247: if nip_number_dup = p_nip_number then
248: fnd_message.set_name ('PER', 'HR_NIP_UNIQUE_NUMBER_PL');
249: fnd_message.raise_error;
250: end if;
251:
252: close nip;
253: end if;

Line 256: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');

252: close nip;
253: end if;
254: exception
255: when value_error then
256: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
257: fnd_message.raise_error;
258: end;
259: elsif nvl (p_nationality, '-1') <> 'PQH_PL' or nvl (p_citizenship, '-1') <>
260: 'PL' then

Line 257: fnd_message.raise_error;

253: end if;
254: exception
255: when value_error then
256: fnd_message.set_name ('PER', 'HR_NIP_INVALID_NUMBER_PL');
257: fnd_message.raise_error;
258: end;
259: elsif nvl (p_nationality, '-1') <> 'PQH_PL' or nvl (p_citizenship, '-1') <>
260: 'PL' then
261: begin

Line 301: fnd_message.set_name ('PER', 'HR_375887_NIP_LENGTH_PL');

297: hr_utility.set_warning;
298: end if;
299:
300: if length (p_nip_number) > 30 then
301: fnd_message.set_name ('PER', 'HR_375887_NIP_LENGTH_PL');
302: fnd_message.raise_error;
303: end if; -- End if of NIP Length Check
304: exception
305: when value_error then

Line 302: fnd_message.raise_error;

298: end if;
299:
300: if length (p_nip_number) > 30 then
301: fnd_message.set_name ('PER', 'HR_375887_NIP_LENGTH_PL');
302: fnd_message.raise_error;
303: end if; -- End if of NIP Length Check
304: exception
305: when value_error then
306: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');

Line 354: fnd_message.set_name('PER','HR_PL_INVALID_NATIONAL_ID');

350: V3 number;
351: BEGIN
352:
353: if (hr_ni_chk_pkg.chk_nat_id_format(pesel,'DDDDDDDDDDD') = 0) then
354: fnd_message.set_name('PER','HR_PL_INVALID_NATIONAL_ID');
355: fnd_message.raise_error;
356: else
357: Y1:=to_number(substr(pesel,1,1));
358: Y2:=to_number(substr(pesel,2,1));

Line 355: fnd_message.raise_error;

351: BEGIN
352:
353: if (hr_ni_chk_pkg.chk_nat_id_format(pesel,'DDDDDDDDDDD') = 0) then
354: fnd_message.set_name('PER','HR_PL_INVALID_NATIONAL_ID');
355: fnd_message.raise_error;
356: else
357: Y1:=to_number(substr(pesel,1,1));
358: Y2:=to_number(substr(pesel,2,1));
359: M3:=to_number(substr(pesel,3,1));

Line 380: fnd_message.set_name('PER','HR_PL_INVALID_NATIONAL_ID');

376: V3:=10-V2;
377: end if;
378:
379: if C11 <> V3 then
380: fnd_message.set_name('PER','HR_PL_INVALID_NATIONAL_ID');
381: fnd_message.raise_error;
382: end if;
383: end if;
384:

Line 381: fnd_message.raise_error;

377: end if;
378:
379: if C11 <> V3 then
380: fnd_message.set_name('PER','HR_PL_INVALID_NATIONAL_ID');
381: fnd_message.raise_error;
382: end if;
383: end if;
384:
385: end per_pl_validate;

Line 685: select fnd_message.get_string(message_cat,message_name)

681: message_cat VARCHAR2(3);
682: message_name fnd_new_messages.message_name%TYPE;
683:
684: cursor csr_error_message is
685: select fnd_message.get_string(message_cat,message_name)
686: from dual;
687:
688: BEGIN
689: lookup_type_val := 'PL_TYPE_OF_SERVICE';

Line 1221: fnd_message.set_name('PER','HR_NATIONAL_ID_NUMBER_PL');

1217: AND p_national_identifier = pp.national_identifier
1218: AND pp.business_group_id +0 = p_business_group_id
1219: AND pp.per_information7 = p_legal_employer);
1220: l_prof_val := fnd_profile.value('PL_PER_NI_UNIQUE_ERROR_WARN');
1221: fnd_message.set_name('PER','HR_NATIONAL_ID_NUMBER_PL');
1222: l_nat_lbl := fnd_message.get;
1223: l_nat_lbl := rtrim(l_nat_lbl);
1224: if l_nat_lbl = 'HR_NATIONAL_ID_NUMBER_PL' then
1225: fnd_message.set_name('PER','HR_NATIONAL_IDENTIFIER_NUMBER');

Line 1222: l_nat_lbl := fnd_message.get;

1218: AND pp.business_group_id +0 = p_business_group_id
1219: AND pp.per_information7 = p_legal_employer);
1220: l_prof_val := fnd_profile.value('PL_PER_NI_UNIQUE_ERROR_WARN');
1221: fnd_message.set_name('PER','HR_NATIONAL_ID_NUMBER_PL');
1222: l_nat_lbl := fnd_message.get;
1223: l_nat_lbl := rtrim(l_nat_lbl);
1224: if l_nat_lbl = 'HR_NATIONAL_ID_NUMBER_PL' then
1225: fnd_message.set_name('PER','HR_NATIONAL_IDENTIFIER_NUMBER');
1226: l_nat_lbl := fnd_message.get;

Line 1225: fnd_message.set_name('PER','HR_NATIONAL_IDENTIFIER_NUMBER');

1221: fnd_message.set_name('PER','HR_NATIONAL_ID_NUMBER_PL');
1222: l_nat_lbl := fnd_message.get;
1223: l_nat_lbl := rtrim(l_nat_lbl);
1224: if l_nat_lbl = 'HR_NATIONAL_ID_NUMBER_PL' then
1225: fnd_message.set_name('PER','HR_NATIONAL_IDENTIFIER_NUMBER');
1226: l_nat_lbl := fnd_message.get;
1227: l_nat_lbl := rtrim(l_nat_lbl);
1228: end if;
1229: if l_prof_val = 'ERROR' then

Line 1226: l_nat_lbl := fnd_message.get;

1222: l_nat_lbl := fnd_message.get;
1223: l_nat_lbl := rtrim(l_nat_lbl);
1224: if l_nat_lbl = 'HR_NATIONAL_ID_NUMBER_PL' then
1225: fnd_message.set_name('PER','HR_NATIONAL_IDENTIFIER_NUMBER');
1226: l_nat_lbl := fnd_message.get;
1227: l_nat_lbl := rtrim(l_nat_lbl);
1228: end if;
1229: if l_prof_val = 'ERROR' then
1230: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');