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 1011: hr_utility.set_location(l_proc,10);

1007:
1008: begin
1009:
1010: l_proc:='HR_PL_UTILITY.GET_TOTAL_PERIOD_OF_SERVICE';
1011: hr_utility.set_location(l_proc,10);
1012: open csr_person_id;
1013: fetch csr_person_id into l_person_id;
1014: close csr_person_id;
1015:

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

1077: l_prev_emp_table(idx).days :=l_temp_period_days;
1078: end if;
1079: end if;
1080: end loop;
1081: hr_utility.set_location(l_proc,20);
1082: /*End of calculation for records in per_periods_of_service*/
1083:
1084:
1085: /*Calculation start for per_previous_employers*/

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

1089: and start_date is not null
1090: and start_date> p_date
1091: 2)Employer_type='PREVIOUS' and start_date is null
1092: */
1093: hr_utility.set_location(l_proc,30);
1094: for i in csr_prev_emp_with_start_date(l_person_id) loop
1095:
1096: if i.employer_type='PARALLEL' then
1097: l_end_date:=p_date;

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

1158: l_prev_emp_table(idx).months :=l_temp_period_months;
1159: l_prev_emp_table(idx).days :=l_temp_period_days;
1160: end if;
1161: end loop;
1162: hr_utility.set_location(l_proc,40);
1163: for kk in l_prev_emp_table.FIRST..l_prev_emp_table.LAST loop
1164: if l_prev_emp_table(kk).active then
1165: l_total_period_years :=l_total_period_years + l_prev_emp_table(kk).years;
1166: l_total_period_months :=l_total_period_months + l_prev_emp_table(kk).months;

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

1167: l_total_period_days :=l_total_period_days + l_prev_emp_table(kk).days;
1168: end if;
1169: end loop;
1170:
1171: hr_utility.set_location(l_proc,50);
1172: for i in csr_pemp_without_start_date(l_person_id) loop
1173: l_total_period_years :=l_total_period_years + i.years;
1174: l_total_period_months :=l_total_period_months + i.months;
1175: l_total_period_days :=l_total_period_days + i.days;

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

1188:
1189: p_years := l_total_period_years;
1190: p_months := l_total_period_months;
1191: p_days := l_total_period_days;
1192: hr_utility.set_location(l_proc,60);
1193: return 1;
1194: exception
1195: when others then
1196: hr_utility.set_location(l_proc,99);

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

1192: hr_utility.set_location(l_proc,60);
1193: return 1;
1194: exception
1195: when others then
1196: hr_utility.set_location(l_proc,99);
1197: hr_utility.raise_error;
1198: end GET_TOTAL_PERIOD_OF_SERVICE;
1199:
1200: PROCEDURE PER_PL_CHECK_NI_UNIQUE

Line 1197: hr_utility.raise_error;

1193: return 1;
1194: exception
1195: when others then
1196: hr_utility.set_location(l_proc,99);
1197: hr_utility.raise_error;
1198: end GET_TOTAL_PERIOD_OF_SERVICE;
1199:
1200: PROCEDURE PER_PL_CHECK_NI_UNIQUE
1201: ( p_national_identifier VARCHAR2,

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

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');
1231: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1232: hr_utility.raise_error;
1233: elsif l_prof_val = 'WARNING' then
1234: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');

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

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');
1231: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1232: hr_utility.raise_error;
1233: elsif l_prof_val = 'WARNING' then
1234: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
1235: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);

Line 1232: hr_utility.raise_error;

1228: end if;
1229: if l_prof_val = 'ERROR' then
1230: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
1231: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1232: hr_utility.raise_error;
1233: elsif l_prof_val = 'WARNING' then
1234: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
1235: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1236: raise local_warning;

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

1230: hr_utility.set_message(801,'HR_NI_UNIQUE_ERROR');
1231: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1232: hr_utility.raise_error;
1233: elsif l_prof_val = 'WARNING' then
1234: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
1235: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1236: raise local_warning;
1237: end if;
1238: exception

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

1231: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1232: hr_utility.raise_error;
1233: elsif l_prof_val = 'WARNING' then
1234: hr_utility.set_message(801,'HR_NI_UNIQUE_WARNING');
1235: hr_utility.set_message_token('NI_NUMBER',l_nat_lbl);
1236: raise local_warning;
1237: end if;
1238: exception
1239: when no_data_found then null;

Line 1241: hr_utility.set_warning;

1237: end if;
1238: exception
1239: when no_data_found then null;
1240: when local_warning then
1241: hr_utility.set_warning;
1242: end per_pl_check_ni_unique;
1243:
1244: END hr_pl_utility;