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 HR_UTILITY

Line 263: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');

259: elsif nvl (p_nationality, '-1') <> 'PQH_PL' or nvl (p_citizenship, '-1') <>
260: 'PL' then
261: begin
262: if length (p_nip_number) <> 10 then
263: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
264: hr_utility.set_warning;
265: end if;
266:
267: if to_number (p_nip_number) = 0 then

Line 264: hr_utility.set_warning;

260: 'PL' then
261: begin
262: if length (p_nip_number) <> 10 then
263: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
264: hr_utility.set_warning;
265: end if;
266:
267: if to_number (p_nip_number) = 0 then
268: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');

Line 268: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');

264: hr_utility.set_warning;
265: end if;
266:
267: if to_number (p_nip_number) = 0 then
268: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
269: hr_utility.set_warning;
270: end if;
271:
272: nip_number (1) := 6 * (to_number (substr (p_nip_number, 1, 1)));

Line 269: hr_utility.set_warning;

265: end if;
266:
267: if to_number (p_nip_number) = 0 then
268: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
269: hr_utility.set_warning;
270: end if;
271:
272: nip_number (1) := 6 * (to_number (substr (p_nip_number, 1, 1)));
273: nip_number (2) := 5 * (to_number (substr (p_nip_number, 2, 1)));

Line 292: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');

288: );
289:
290: if nip_sum = 10 then
291: if nip_number (10) <> 0 then
292: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
293: hr_utility.set_warning;
294: end if;
295: elsif nip_sum <> nip_number (10) then
296: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');

Line 293: hr_utility.set_warning;

289:
290: if nip_sum = 10 then
291: if nip_number (10) <> 0 then
292: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
293: hr_utility.set_warning;
294: end if;
295: elsif nip_sum <> nip_number (10) then
296: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
297: hr_utility.set_warning;

Line 296: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');

292: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
293: hr_utility.set_warning;
294: end if;
295: elsif nip_sum <> nip_number (10) then
296: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_PL');
297: hr_utility.set_warning;
298: end if;
299:
300: if length (p_nip_number) > 30 then

Line 297: hr_utility.set_warning;

293: hr_utility.set_warning;
294: end if;
295: elsif nip_sum <> nip_number (10) then
296: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_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');

Line 306: hr_utility.set_message (800, 'HR_375890_NIP_NON_POLISH_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');
307: hr_utility.set_warning;
308: end;
309: end if; -- End if of Nationality and Citizenship Check
310: End IF; -- End If for not null check

Line 307: hr_utility.set_warning;

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');
307: hr_utility.set_warning;
308: end;
309: end if; -- End if of Nationality and Citizenship Check
310: End IF; -- End If for not null check
311: end per_pl_nip_validate;

Line 541: -- hr_utility.trace_on(null,'ACCVAL');

537: p_bank_id IN Varchar2 DEFAULT NULL) RETURN NUMBER IS
538: --
539: l_ret NUMBER ;
540: begin
541: -- hr_utility.trace_on(null,'ACCVAL');
542: l_ret :=0;
543: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
544: hr_utility.set_location('p_account_number ' || p_acc_no,1);
545:

Line 543: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);

539: l_ret NUMBER ;
540: begin
541: -- hr_utility.trace_on(null,'ACCVAL');
542: l_ret :=0;
543: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
544: hr_utility.set_location('p_account_number ' || p_acc_no,1);
545:
546: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
547: l_ret := validate_account_no(p_bank_chk_dig, p_bank_id, p_acc_no);

Line 544: hr_utility.set_location('p_account_number ' || p_acc_no,1);

540: begin
541: -- hr_utility.trace_on(null,'ACCVAL');
542: l_ret :=0;
543: hr_utility.set_location('p_is_iban_acc ' || p_is_iban_acc,1);
544: hr_utility.set_location('p_account_number ' || p_acc_no,1);
545:
546: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
547: l_ret := validate_account_no(p_bank_chk_dig, p_bank_id, p_acc_no);
548: hr_utility.set_location('l_ret ' || l_ret,1);

Line 548: hr_utility.set_location('l_ret ' || l_ret,1);

544: hr_utility.set_location('p_account_number ' || p_acc_no,1);
545:
546: IF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'N') then
547: l_ret := validate_account_no(p_bank_chk_dig, p_bank_id, p_acc_no);
548: hr_utility.set_location('l_ret ' || l_ret,1);
549: RETURN l_ret;
550: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
551: l_ret := validate_iban_acc(p_acc_no);
552: hr_utility.set_location('l_ret ' || l_ret,3);

Line 552: hr_utility.set_location('l_ret ' || l_ret,3);

548: hr_utility.set_location('l_ret ' || l_ret,1);
549: RETURN l_ret;
550: ELSIF (p_acc_no IS NOT NULL AND p_is_iban_acc = 'Y') then
551: l_ret := validate_iban_acc(p_acc_no);
552: hr_utility.set_location('l_ret ' || l_ret,3);
553: RETURN l_ret;
554: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
555: hr_utility.set_location('Both Account Nos Null',4);
556: RETURN 1;

Line 555: hr_utility.set_location('Both Account Nos Null',4);

551: l_ret := validate_iban_acc(p_acc_no);
552: hr_utility.set_location('l_ret ' || l_ret,3);
553: RETURN l_ret;
554: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
555: hr_utility.set_location('Both Account Nos Null',4);
556: RETURN 1;
557: ELSE
558: hr_utility.set_location('l_ret: 3 ' ,5);
559: RETURN 3;

Line 558: hr_utility.set_location('l_ret: 3 ' ,5);

554: ELSIF (p_acc_no IS NULL AND p_is_iban_acc IS NULL) then
555: hr_utility.set_location('Both Account Nos Null',4);
556: RETURN 1;
557: ELSE
558: hr_utility.set_location('l_ret: 3 ' ,5);
559: RETURN 3;
560: END if;
561: End validate_account_entered;
562:

Line 1057: hr_utility.set_location(l_proc,10);

1053:
1054: begin
1055:
1056: l_proc:='HR_PL_UTILITY.GET_TOTAL_PERIOD_OF_SERVICE';
1057: hr_utility.set_location(l_proc,10);
1058: open csr_person_id;
1059: fetch csr_person_id into l_person_id;
1060: close csr_person_id;
1061:

Line 1127: hr_utility.set_location(l_proc,20);

1123: l_prev_emp_table(idx).days :=l_temp_period_days;
1124: end if;
1125: end if;
1126: end loop;
1127: hr_utility.set_location(l_proc,20);
1128: /*End of calculation for records in per_periods_of_service*/
1129:
1130:
1131: /*Calculation start for per_previous_employers*/

Line 1139: hr_utility.set_location(l_proc,30);

1135: and start_date is not null
1136: and start_date> p_date
1137: 2)Employer_type='PREVIOUS' and start_date is null
1138: */
1139: hr_utility.set_location(l_proc,30);
1140: for i in csr_prev_emp_with_start_date(l_person_id) loop
1141:
1142: if i.employer_type='PARALLEL' then
1143: l_end_date:=p_date;

Line 1205: hr_utility.set_location(l_proc,40);

1201: l_prev_emp_table(idx).months :=l_temp_period_months;
1202: l_prev_emp_table(idx).days :=l_temp_period_days;
1203: end if;
1204: end loop;
1205: hr_utility.set_location(l_proc,40);
1206: for kk in l_prev_emp_table.FIRST..l_prev_emp_table.LAST loop
1207: if l_prev_emp_table(kk).active then
1208: l_total_period_years :=l_total_period_years + l_prev_emp_table(kk).years;
1209: l_total_period_months :=l_total_period_months + l_prev_emp_table(kk).months;

Line 1214: hr_utility.set_location(l_proc,50);

1210: l_total_period_days :=l_total_period_days + l_prev_emp_table(kk).days;
1211: end if;
1212: end loop;
1213:
1214: hr_utility.set_location(l_proc,50);
1215: for i in csr_pemp_without_start_date(l_person_id) loop
1216: l_total_period_years :=l_total_period_years + i.years;
1217: l_total_period_months :=l_total_period_months + i.months;
1218: l_total_period_days :=l_total_period_days + i.days;

Line 1235: hr_utility.set_location(l_proc,60);

1231:
1232: p_years := l_total_period_years;
1233: p_months := l_total_period_months;
1234: p_days := l_total_period_days;
1235: hr_utility.set_location(l_proc,60);
1236: return 1;
1237: exception
1238: when others then
1239: hr_utility.set_location(l_proc,99);

Line 1239: hr_utility.set_location(l_proc,99);

1235: hr_utility.set_location(l_proc,60);
1236: return 1;
1237: exception
1238: when others then
1239: hr_utility.set_location(l_proc,99);
1240: hr_utility.raise_error;
1241: end GET_TOTAL_PERIOD_OF_SERVICE;
1242:
1243: PROCEDURE PER_PL_CHECK_NI_UNIQUE

Line 1240: hr_utility.raise_error;

1236: return 1;
1237: exception
1238: when others then
1239: hr_utility.set_location(l_proc,99);
1240: hr_utility.raise_error;
1241: end GET_TOTAL_PERIOD_OF_SERVICE;
1242:
1243: PROCEDURE PER_PL_CHECK_NI_UNIQUE
1244: ( p_national_identifier VARCHAR2,

Line 1273: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');

1269: l_nat_lbl := fnd_message.get;
1270: l_nat_lbl := rtrim(l_nat_lbl);
1271: end if;
1272: if l_prof_val = 'ERROR' then
1273: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
1274: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1275: hr_utility.raise_error;
1276: elsif l_prof_val = 'WARNING' then
1277: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');

Line 1274: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);

1270: l_nat_lbl := rtrim(l_nat_lbl);
1271: end if;
1272: if l_prof_val = 'ERROR' then
1273: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
1274: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1275: hr_utility.raise_error;
1276: elsif l_prof_val = 'WARNING' then
1277: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
1278: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);

Line 1275: hr_utility.raise_error;

1271: end if;
1272: if l_prof_val = 'ERROR' then
1273: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
1274: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1275: hr_utility.raise_error;
1276: elsif l_prof_val = 'WARNING' then
1277: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
1278: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1279: raise local_warning;

Line 1277: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');

1273: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
1274: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1275: hr_utility.raise_error;
1276: elsif l_prof_val = 'WARNING' then
1277: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
1278: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1279: raise local_warning;
1280: end if;
1281: exception

Line 1278: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);

1274: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1275: hr_utility.raise_error;
1276: elsif l_prof_val = 'WARNING' then
1277: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
1278: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1279: raise local_warning;
1280: end if;
1281: exception
1282: when no_data_found then null;

Line 1284: hr_utility.set_warning;

1280: end if;
1281: exception
1282: when no_data_found then null;
1283: when local_warning then
1284: hr_utility.set_warning;
1285: end per_pl_check_ni_unique;
1286:
1287: END hr_pl_utility;