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.PER_ESA_BUS dependencies on HR_UTILITY

Line 50: hr_utility.set_location('Entering:'||l_proc, 5);

46: l_api_updating boolean;
47: --
48: Begin
49: --
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: --
52: l_api_updating := per_esa_shd.api_updating
53: (p_attendance_id => p_attendance_id,
54: p_object_version_number => p_object_version_number);

Line 78: hr_utility.set_location(' Leaving:'||l_proc, 10);

74: end if;
75: --
76: end if;
77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: End chk_attendance_id;
81: --
82: -- ----------------------------------------------------------------------------

Line 145: hr_utility.set_location('Entering:'||l_proc, 5);

141: and nvl(per.establishment,-1) = nvl(p_establishment,-1);
142: --
143: Begin
144: --
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: l_api_updating := per_esa_shd.api_updating
148: (p_attendance_id => p_attendance_id,
149: p_object_version_number => p_object_version_number);

Line 176: hr_utility.set_message(801,'HR_51494_ESA_CHK_PERSON_ID');

172: if p_party_id is null then
173: --
174: -- raise error as this a mandatory requirement
175: --
176: hr_utility.set_message(801,'HR_51494_ESA_CHK_PERSON_ID');
177: hr_utility.raise_error;
178: --
179: else
180: --

Line 177: hr_utility.raise_error;

173: --
174: -- raise error as this a mandatory requirement
175: --
176: hr_utility.set_message(801,'HR_51494_ESA_CHK_PERSON_ID');
177: hr_utility.raise_error;
178: --
179: else
180: --
181: -- check if the changes made to the above parameters result in a unique

Line 227: hr_utility.set_location(l_proc, 9);

223: --
224: end if;
225: end if;
226: --
227: hr_utility.set_location(l_proc, 9);
228: --
229: --UPDATE of person_id not allowed unless currently null(U)
230: --
231: if (l_api_updating

Line 236: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');

232: and nvl(per_esa_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number
233: and per_esa_shd.g_old_rec.person_id <> p_person_id
234: ) then
235: --
236: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');
237: hr_utility.raise_error;
238: --
239: end if;
240: --

Line 237: hr_utility.raise_error;

233: and per_esa_shd.g_old_rec.person_id <> p_person_id
234: ) then
235: --
236: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');
237: hr_utility.raise_error;
238: --
239: end if;
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 241: hr_utility.set_location(' Leaving:'||l_proc, 10);

237: hr_utility.raise_error;
238: --
239: end if;
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 10);
242: --
243: End chk_person_id;
244: --
245: -- ----------------------------------------------------------------------------

Line 300: hr_utility.set_location('Entering:'|| l_proc, 1);

296: from hz_parties hzp
297: where hzp.party_id = p_rec.party_id;
298: --
299: begin
300: hr_utility.set_location('Entering:'|| l_proc, 1);
301: --
302: --
303: if p_rec.person_id is not null then
304: open csr_get_party_id;

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

303: if p_rec.person_id is not null then
304: open csr_get_party_id;
305: fetch csr_get_party_id into l_party_id;
306: close csr_get_party_id;
307: hr_utility.set_location(l_proc,20);
308: if p_rec.party_id is not null then
309: if p_rec.party_id <> nvl(l_party_id,-1) then
310: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
311: hr_utility.set_location(l_proc,30);

Line 310: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');

306: close csr_get_party_id;
307: hr_utility.set_location(l_proc,20);
308: if p_rec.party_id is not null then
309: if p_rec.party_id <> nvl(l_party_id,-1) then
310: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
311: hr_utility.set_location(l_proc,30);
312: hr_utility.raise_error;
313: end if;
314: else

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

307: hr_utility.set_location(l_proc,20);
308: if p_rec.party_id is not null then
309: if p_rec.party_id <> nvl(l_party_id,-1) then
310: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
311: hr_utility.set_location(l_proc,30);
312: hr_utility.raise_error;
313: end if;
314: else
315: --

Line 312: hr_utility.raise_error;

308: if p_rec.party_id is not null then
309: if p_rec.party_id <> nvl(l_party_id,-1) then
310: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
311: hr_utility.set_location(l_proc,30);
312: hr_utility.raise_error;
313: end if;
314: else
315: --
316: -- derive party_id from per_all_people_f using person_id

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

314: else
315: --
316: -- derive party_id from per_all_people_f using person_id
317: --
318: hr_utility.set_location(l_proc,50);
319: p_rec.party_id := l_party_id;
320: end if;
321: else
322: if p_rec.party_id is null then

Line 323: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');

319: p_rec.party_id := l_party_id;
320: end if;
321: else
322: if p_rec.party_id is null then
323: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
324: hr_utility.set_location(l_proc,60);
325: hr_utility.raise_error;
326: else
327: open csr_valid_party_id;

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

320: end if;
321: else
322: if p_rec.party_id is null then
323: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
324: hr_utility.set_location(l_proc,60);
325: hr_utility.raise_error;
326: else
327: open csr_valid_party_id;
328: fetch csr_valid_party_id into l_party_id2;

Line 325: hr_utility.raise_error;

321: else
322: if p_rec.party_id is null then
323: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
324: hr_utility.set_location(l_proc,60);
325: hr_utility.raise_error;
326: else
327: open csr_valid_party_id;
328: fetch csr_valid_party_id into l_party_id2;
329: if csr_valid_party_id%notfound then

Line 331: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');

327: open csr_valid_party_id;
328: fetch csr_valid_party_id into l_party_id2;
329: if csr_valid_party_id%notfound then
330: close csr_valid_party_id;
331: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
332: hr_utility.set_location(l_proc,70);
333: hr_utility.raise_error;
334: end if;
335: close csr_valid_party_id;

Line 332: hr_utility.set_location(l_proc,70);

328: fetch csr_valid_party_id into l_party_id2;
329: if csr_valid_party_id%notfound then
330: close csr_valid_party_id;
331: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
332: hr_utility.set_location(l_proc,70);
333: hr_utility.raise_error;
334: end if;
335: close csr_valid_party_id;
336: end if;

Line 333: hr_utility.raise_error;

329: if csr_valid_party_id%notfound then
330: close csr_valid_party_id;
331: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
332: hr_utility.set_location(l_proc,70);
333: hr_utility.raise_error;
334: end if;
335: close csr_valid_party_id;
336: end if;
337: end if;

Line 339: hr_utility.set_location(' Leaving:'||l_proc,100);

335: close csr_valid_party_id;
336: end if;
337: end if;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc,100);
340: End chk_party_id;
341: -- ----------------------------------------------------------------------------
342: -- |------------------------< chk_address_constraints >-----------------------|
343: -- ----------------------------------------------------------------------------

Line 380: hr_utility.set_location('Entering:'||l_proc, 5);

376: l_temp varchar2(4000) := per_esa_shd.g_old_rec.address;
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: l_api_updating := per_esa_shd.api_updating
383: (p_attendance_id => p_attendance_id,
384: p_object_version_number => p_object_version_number);

Line 386: hr_utility.set_location(p_address,6);

382: l_api_updating := per_esa_shd.api_updating
383: (p_attendance_id => p_attendance_id,
384: p_object_version_number => p_object_version_number);
385:
386: hr_utility.set_location(p_address,6);
387: hr_utility.set_location(l_temp,6);
388: --hr_utility.set_location(l_api_updating,6);
389: --
390: if (l_api_updating

Line 387: hr_utility.set_location(l_temp,6);

383: (p_attendance_id => p_attendance_id,
384: p_object_version_number => p_object_version_number);
385:
386: hr_utility.set_location(p_address,6);
387: hr_utility.set_location(l_temp,6);
388: --hr_utility.set_location(l_api_updating,6);
389: --
390: if (l_api_updating
391: and nvl(p_address,hr_api.g_varchar2)

Line 388: --hr_utility.set_location(l_api_updating,6);

384: p_object_version_number => p_object_version_number);
385:
386: hr_utility.set_location(p_address,6);
387: hr_utility.set_location(l_temp,6);
388: --hr_utility.set_location(l_api_updating,6);
389: --
390: if (l_api_updating
391: and nvl(p_address,hr_api.g_varchar2)
392: <> nvl(per_esa_shd.g_old_rec.address,hr_api.g_varchar2)

Line 397: hr_utility.set_location(p_address,10);

393: or not l_api_updating) then
394: --
395: -- check if establishment_id is changeing at the same time as the address
396: --
397: hr_utility.set_location(p_address,10);
398: hr_utility.set_location(p_establishment_id,10);
399: --
400: if nvl(p_establishment_id,hr_api.g_number) <> nvl(per_esa_shd.g_old_rec.establishment_id,hr_api.g_number) and p_attendance_id is not null then
401: --

Line 398: hr_utility.set_location(p_establishment_id,10);

394: --
395: -- check if establishment_id is changeing at the same time as the address
396: --
397: hr_utility.set_location(p_address,10);
398: hr_utility.set_location(p_establishment_id,10);
399: --
400: if nvl(p_establishment_id,hr_api.g_number) <> nvl(per_esa_shd.g_old_rec.establishment_id,hr_api.g_number) and p_attendance_id is not null then
401: --
402: -- raise error as does not exist as lookup

Line 405: hr_utility.raise_error;

401: --
402: -- raise error as does not exist as lookup
403: --
404: fnd_message.set_name('PER', 'HR_289587_ESA_ADDRESS_UPDATE');
405: hr_utility.raise_error;
406: --
407: end if;
408:
409: elsif (l_api_updating

Line 414: hr_utility.set_location('Establishment Updating',15);

410: and nvl(p_establishment_id,hr_api.g_number)
411: <> per_esa_shd.g_old_rec.establishment_id
412: or not l_api_updating) then
413:
414: hr_utility.set_location('Establishment Updating',15);
415: hr_utility.set_location(p_address,15);
416: --
417: -- check if establishment_id is being changed when the address is not null
418: --

Line 415: hr_utility.set_location(p_address,15);

411: <> per_esa_shd.g_old_rec.establishment_id
412: or not l_api_updating) then
413:
414: hr_utility.set_location('Establishment Updating',15);
415: hr_utility.set_location(p_address,15);
416: --
417: -- check if establishment_id is being changed when the address is not null
418: --
419:

Line 427: hr_utility.raise_error;

423: -- Raise error to get user to delete the address of old establishment before
424: -- updating the establishment_id
425: --
426: fnd_message.set_name('PER', 'HR_289586_ESA_ADDRESS_NULL');
427: hr_utility.raise_error;
428:
429: end if;
430: --
431: end if;

Line 433: hr_utility.set_location('Leaving:'||l_proc,20);

429: end if;
430: --
431: end if;
432: --
433: hr_utility.set_location('Leaving:'||l_proc,20);
434: --
435: end chk_address_constraints;
436: --
437: -- ----------------------------------------------------------------------------

Line 475: hr_utility.set_location('Entering:'||l_proc, 5);

471: l_api_updating boolean;
472: --
473: Begin
474: --
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: l_api_updating := per_esa_shd.api_updating
478: (p_attendance_id => p_attendance_id,
479: p_object_version_number => p_object_version_number);

Line 488: hr_utility.set_location(p_full_time,100);

484: or not l_api_updating) then
485: --
486: -- check if value of full time falls within Full or Part time
487: --
488: hr_utility.set_location(p_full_time,100);
489: --
490: if hr_api.not_exists_in_hr_lookups(p_lookup_type => 'YES_NO',
491: p_lookup_code => p_full_time,
492: p_effective_date => p_effective_date) then

Line 496: hr_utility.set_message(801,'HR_51511_ESA_FULL_TIME_LKP');

492: p_effective_date => p_effective_date) then
493: --
494: -- raise error as does not exist as lookup
495: --
496: hr_utility.set_message(801,'HR_51511_ESA_FULL_TIME_LKP');
497: hr_utility.raise_error;
498: --
499: end if;
500: --

Line 497: hr_utility.raise_error;

493: --
494: -- raise error as does not exist as lookup
495: --
496: hr_utility.set_message(801,'HR_51511_ESA_FULL_TIME_LKP');
497: hr_utility.raise_error;
498: --
499: end if;
500: --
501: end if;

Line 503: hr_utility.set_location('Leaving:'||l_proc,10);

499: end if;
500: --
501: end if;
502: --
503: hr_utility.set_location('Leaving:'||l_proc,10);
504: --
505: end chk_full_time;
506: -- ----------------------------------------------------------------------------
507: -- |--------------------------< chk_estab_location >--------------------------|

Line 550: hr_utility.set_location('Entering:'||l_proc, 5);

546: where per.establishment_id = p_establishment_id;
547: --
548: Begin
549: --
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: l_api_updating := per_esa_shd.api_updating
553: (p_attendance_id => p_attendance_id,
554: p_object_version_number => p_object_version_number);

Line 570: hr_utility.set_message(801,'HR_51495_ESA_ESTAB_ID_NULL');

566: --
567: -- raise error as either establishmnet or establishment_id must be
568: -- populated but not both.
569: --
570: hr_utility.set_message(801,'HR_51495_ESA_ESTAB_ID_NULL');
571: hr_utility.raise_error;
572: --
573: end if;
574: --

Line 571: hr_utility.raise_error;

567: -- raise error as either establishmnet or establishment_id must be
568: -- populated but not both.
569: --
570: hr_utility.set_message(801,'HR_51495_ESA_ESTAB_ID_NULL');
571: hr_utility.raise_error;
572: --
573: end if;
574: --
575: -- check if establishment id has changed and if so does the establishment

Line 606: hr_utility.set_location('Leaving:'||l_proc, 5);

602: end if;
603: --
604: end if;
605: --
606: hr_utility.set_location('Leaving:'||l_proc, 5);
607: --
608: end chk_estab_location;
609: --
610: -- ----------------------------------------------------------------------------

Line 723: hr_utility.set_location('Entering:'||l_proc, 5);

719: -- Bug: 1664075 Ends here.
720: --
721: Begin
722: --
723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: l_api_updating := per_esa_shd.api_updating
726: (p_attendance_id => p_attendance_id,
727: p_object_version_number => p_object_version_number);

Line 730: hr_utility.set_location('Entering:chk_start'||p_attended_start_date,121);

726: (p_attendance_id => p_attendance_id,
727: p_object_version_number => p_object_version_number);
728: --
729: if l_api_updating then
730: hr_utility.set_location('Entering:chk_start'||p_attended_start_date,121);
731: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_start_date,121);
732: hr_utility.set_location('Entering:chk_end'||p_attended_end_date,212);
733: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_end_date,121);
734: end if;

Line 731: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_start_date,121);

727: p_object_version_number => p_object_version_number);
728: --
729: if l_api_updating then
730: hr_utility.set_location('Entering:chk_start'||p_attended_start_date,121);
731: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_start_date,121);
732: hr_utility.set_location('Entering:chk_end'||p_attended_end_date,212);
733: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_end_date,121);
734: end if;
735: if (l_api_updating

Line 732: hr_utility.set_location('Entering:chk_end'||p_attended_end_date,212);

728: --
729: if l_api_updating then
730: hr_utility.set_location('Entering:chk_start'||p_attended_start_date,121);
731: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_start_date,121);
732: hr_utility.set_location('Entering:chk_end'||p_attended_end_date,212);
733: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_end_date,121);
734: end if;
735: if (l_api_updating
736: and (nvl(p_attended_start_date,hr_api.g_date)

Line 733: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_end_date,121);

729: if l_api_updating then
730: hr_utility.set_location('Entering:chk_start'||p_attended_start_date,121);
731: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_start_date,121);
732: hr_utility.set_location('Entering:chk_end'||p_attended_end_date,212);
733: hr_utility.set_location('Entering:chk_start'||per_esa_shd.g_old_rec.attended_end_date,121);
734: end if;
735: if (l_api_updating
736: and (nvl(p_attended_start_date,hr_api.g_date)
737: <> nvl(per_esa_shd.g_old_rec.attended_start_date,hr_api.g_date)

Line 750: hr_utility.set_location('Entering:'||l_proc, 15);

746: --
747: -- Check if the date of birth of the person is null or start date is less
748: -- than the date of birth of the person.
749: --
750: hr_utility.set_location('Entering:'||l_proc, 15);
751: open c4;
752: fetch c4 into l_dob;
753: if (c4%found) then
754: /* if (l_dob is null) then

Line 756: hr_utility.set_message(800,'HR_289737_SCH_ATTND_NULL_DOB');

752: fetch c4 into l_dob;
753: if (c4%found) then
754: /* if (l_dob is null) then
755: close c4;
756: hr_utility.set_message(800,'HR_289737_SCH_ATTND_NULL_DOB');
757: hr_utility.raise_error;
758: elsif (p_attended_start_date is not null) and (l_dob > nvl(p_attended_start_date,hr_api.g_sot) ) then
759: close c4;
760: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');

Line 757: hr_utility.raise_error;

753: if (c4%found) then
754: /* if (l_dob is null) then
755: close c4;
756: hr_utility.set_message(800,'HR_289737_SCH_ATTND_NULL_DOB');
757: hr_utility.raise_error;
758: elsif (p_attended_start_date is not null) and (l_dob > nvl(p_attended_start_date,hr_api.g_sot) ) then
759: close c4;
760: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
761: hr_utility.raise_error;

Line 760: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');

756: hr_utility.set_message(800,'HR_289737_SCH_ATTND_NULL_DOB');
757: hr_utility.raise_error;
758: elsif (p_attended_start_date is not null) and (l_dob > nvl(p_attended_start_date,hr_api.g_sot) ) then
759: close c4;
760: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
761: hr_utility.raise_error;
762: end if;
763: */
764:

Line 761: hr_utility.raise_error;

757: hr_utility.raise_error;
758: elsif (p_attended_start_date is not null) and (l_dob > nvl(p_attended_start_date,hr_api.g_sot) ) then
759: close c4;
760: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
761: hr_utility.raise_error;
762: end if;
763: */
764:
765: --

Line 775: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');

771: --
772: --
773: if (p_attended_start_date is not null) and (p_attended_end_date is null) and l_dob > nvl(p_attended_start_date,hr_api.g_sot) then
774: close c4;
775: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
776: hr_utility.raise_error;
777: elsif (p_attended_start_date is null) and (p_attended_end_date is not null) and (l_dob > nvl(p_attended_end_date,hr_api.g_sot)) then
778: close c4;
779: hr_utility.set_message(800,'PER_289498_ATT_END_DATE');

Line 776: hr_utility.raise_error;

772: --
773: if (p_attended_start_date is not null) and (p_attended_end_date is null) and l_dob > nvl(p_attended_start_date,hr_api.g_sot) then
774: close c4;
775: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
776: hr_utility.raise_error;
777: elsif (p_attended_start_date is null) and (p_attended_end_date is not null) and (l_dob > nvl(p_attended_end_date,hr_api.g_sot)) then
778: close c4;
779: hr_utility.set_message(800,'PER_289498_ATT_END_DATE');
780: hr_utility.raise_error;

Line 779: hr_utility.set_message(800,'PER_289498_ATT_END_DATE');

775: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
776: hr_utility.raise_error;
777: elsif (p_attended_start_date is null) and (p_attended_end_date is not null) and (l_dob > nvl(p_attended_end_date,hr_api.g_sot)) then
778: close c4;
779: hr_utility.set_message(800,'PER_289498_ATT_END_DATE');
780: hr_utility.raise_error;
781: elsif (p_attended_start_date is not null) and (p_attended_end_date is not null) then
782: if (l_dob > p_attended_start_date) and (l_dob > p_attended_end_date) and (p_attended_start_date > p_attended_end_date) then
783: close c4;

Line 780: hr_utility.raise_error;

776: hr_utility.raise_error;
777: elsif (p_attended_start_date is null) and (p_attended_end_date is not null) and (l_dob > nvl(p_attended_end_date,hr_api.g_sot)) then
778: close c4;
779: hr_utility.set_message(800,'PER_289498_ATT_END_DATE');
780: hr_utility.raise_error;
781: elsif (p_attended_start_date is not null) and (p_attended_end_date is not null) then
782: if (l_dob > p_attended_start_date) and (l_dob > p_attended_end_date) and (p_attended_start_date > p_attended_end_date) then
783: close c4;
784: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');

Line 784: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');

780: hr_utility.raise_error;
781: elsif (p_attended_start_date is not null) and (p_attended_end_date is not null) then
782: if (l_dob > p_attended_start_date) and (l_dob > p_attended_end_date) and (p_attended_start_date > p_attended_end_date) then
783: close c4;
784: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');
785: hr_utility.raise_error;
786: elsif (l_dob > p_attended_start_date) and (l_dob > p_attended_end_date) then
787: close c4;
788: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');

Line 785: hr_utility.raise_error;

781: elsif (p_attended_start_date is not null) and (p_attended_end_date is not null) then
782: if (l_dob > p_attended_start_date) and (l_dob > p_attended_end_date) and (p_attended_start_date > p_attended_end_date) then
783: close c4;
784: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');
785: hr_utility.raise_error;
786: elsif (l_dob > p_attended_start_date) and (l_dob > p_attended_end_date) then
787: close c4;
788: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');
789: hr_utility.raise_error;

Line 788: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');

784: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');
785: hr_utility.raise_error;
786: elsif (l_dob > p_attended_start_date) and (l_dob > p_attended_end_date) then
787: close c4;
788: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');
789: hr_utility.raise_error;
790: elsif (l_dob > p_attended_start_date) and (p_attended_start_date > p_attended_end_date) then
791: close c4;
792: elsif (l_dob > p_attended_end_date) and (p_attended_start_date > p_attended_end_date) then

Line 789: hr_utility.raise_error;

785: hr_utility.raise_error;
786: elsif (l_dob > p_attended_start_date) and (l_dob > p_attended_end_date) then
787: close c4;
788: hr_utility.set_message(800,'PER_289497_ATT_ST_END_DATE');
789: hr_utility.raise_error;
790: elsif (l_dob > p_attended_start_date) and (p_attended_start_date > p_attended_end_date) then
791: close c4;
792: elsif (l_dob > p_attended_end_date) and (p_attended_start_date > p_attended_end_date) then
793: close c4;

Line 794: hr_utility.set_message(800,'PER_289499_ATT_END_DOB_DATE');

790: elsif (l_dob > p_attended_start_date) and (p_attended_start_date > p_attended_end_date) then
791: close c4;
792: elsif (l_dob > p_attended_end_date) and (p_attended_start_date > p_attended_end_date) then
793: close c4;
794: hr_utility.set_message(800,'PER_289499_ATT_END_DOB_DATE');
795: hr_utility.raise_error;
796: elsif (l_dob > p_attended_start_date) then
797: close c4;
798: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');

Line 795: hr_utility.raise_error;

791: close c4;
792: elsif (l_dob > p_attended_end_date) and (p_attended_start_date > p_attended_end_date) then
793: close c4;
794: hr_utility.set_message(800,'PER_289499_ATT_END_DOB_DATE');
795: hr_utility.raise_error;
796: elsif (l_dob > p_attended_start_date) then
797: close c4;
798: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
799: hr_utility.raise_error;

Line 798: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');

794: hr_utility.set_message(800,'PER_289499_ATT_END_DOB_DATE');
795: hr_utility.raise_error;
796: elsif (l_dob > p_attended_start_date) then
797: close c4;
798: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
799: hr_utility.raise_error;
800: elsif (l_dob > p_attended_end_date) then
801: close c4;
802: elsif (p_attended_start_date > p_attended_end_date) then

Line 799: hr_utility.raise_error;

795: hr_utility.raise_error;
796: elsif (l_dob > p_attended_start_date) then
797: close c4;
798: hr_utility.set_message(800,'HR_289384_SCH_ATND_START_DATE');
799: hr_utility.raise_error;
800: elsif (l_dob > p_attended_end_date) then
801: close c4;
802: elsif (p_attended_start_date > p_attended_end_date) then
803: close c4;

Line 804: hr_utility.set_message(800,'HR_51496_ESA_ATT_END_DATE');

800: elsif (l_dob > p_attended_end_date) then
801: close c4;
802: elsif (p_attended_start_date > p_attended_end_date) then
803: close c4;
804: hr_utility.set_message(800,'HR_51496_ESA_ATT_END_DATE');
805: hr_utility.raise_error;
806: end if;
807:
808: end if;

Line 805: hr_utility.raise_error;

801: close c4;
802: elsif (p_attended_start_date > p_attended_end_date) then
803: close c4;
804: hr_utility.set_message(800,'HR_51496_ESA_ATT_END_DATE');
805: hr_utility.raise_error;
806: end if;
807:
808: end if;
809: end if;

Line 818: hr_utility.set_location('Entering:'||l_proc, 20);

814: -- Bug: 1664075 Ends here.
815: --
816: -- check if the attended start date is later than the attended end date
817: --
818: hr_utility.set_location('Entering:'||l_proc, 20);
819: if nvl(p_attended_start_date,hr_api.g_sot) > nvl(p_attended_end_date,nvl(p_attended_start_date,hr_api.g_sot))
820: then
821: --
822: -- raise error

Line 824: hr_utility.set_message(800,'HR_51496_ESA_ATT_END_DATE'); -- Bug 3487909

820: then
821: --
822: -- raise error
823: --
824: hr_utility.set_message(800,'HR_51496_ESA_ATT_END_DATE'); -- Bug 3487909
825: hr_utility.raise_error;
826: --
827: end if;
828: --

Line 825: hr_utility.raise_error;

821: --
822: -- raise error
823: --
824: hr_utility.set_message(800,'HR_51496_ESA_ATT_END_DATE'); -- Bug 3487909
825: hr_utility.raise_error;
826: --
827: end if;
828: --
829: -- check if qualification dates are within the range of the attendance

Line 843: hr_utility.set_message(801,'HR_51596_ESA_QUAL_DATE_INV');

839: close c2;
840: --
841: -- raise error as qualification dates outside attendance dates
842: --
843: hr_utility.set_message(801,'HR_51596_ESA_QUAL_DATE_INV');
844: hr_utility.raise_error;
845: --
846: end if;
847: --

Line 844: hr_utility.raise_error;

840: --
841: -- raise error as qualification dates outside attendance dates
842: --
843: hr_utility.set_message(801,'HR_51596_ESA_QUAL_DATE_INV');
844: hr_utility.raise_error;
845: --
846: end if;
847: --
848: close c2;

Line 865: hr_utility.set_message(801,'HR_51497_ESA_CHK_ATT_OVERLAP');

861: close c1;
862: --
863: -- raise error as establishment attendance dates overlap
864: --
865: hr_utility.set_message(801,'HR_51497_ESA_CHK_ATT_OVERLAP');
866: hr_utility.raise_error;
867: --
868: end if;
869: --

Line 866: hr_utility.raise_error;

862: --
863: -- raise error as establishment attendance dates overlap
864: --
865: hr_utility.set_message(801,'HR_51497_ESA_CHK_ATT_OVERLAP');
866: hr_utility.raise_error;
867: --
868: end if;
869: --
870: close c1;

Line 884: hr_utility.set_message(801,'HR_51497_ESA_CHK_ATT_OVERLAP');

880: close c3;
881: --
882: -- raise error as establishment attendance dates overlap
883: --
884: hr_utility.set_message(801,'HR_51497_ESA_CHK_ATT_OVERLAP');
885: hr_utility.raise_error;
886: --
887: end if;
888: --

Line 885: hr_utility.raise_error;

881: --
882: -- raise error as establishment attendance dates overlap
883: --
884: hr_utility.set_message(801,'HR_51497_ESA_CHK_ATT_OVERLAP');
885: hr_utility.raise_error;
886: --
887: end if;
888: --
889: close c3;

Line 894: hr_utility.set_location('Leaving:'||l_proc, 5);

890: --
891: end if;*/
892: end if;
893: --
894: hr_utility.set_location('Leaving:'||l_proc, 5);
895: --
896: end chk_att_overlap;
897: --
898: -- ----------------------------------------------------------------------------

Line 952: hr_utility.set_location('Entering:'||l_proc, 5);

948: and nvl(trunc(per.effective_end_date),trunc(per.effective_end_date));
949: --
950: Begin
951: --
952: hr_utility.set_location('Entering:'||l_proc, 5);
953: --
954: l_api_updating := per_esa_shd.api_updating
955: (p_attendance_id => p_attendance_id,
956: p_object_version_number => p_object_version_number);

Line 975: hr_utility.set_message(801,'HR_51503_ESA_ESTAB_BG');

971: close c1;
972: --
973: -- raise error as person does not exist for this business group
974: --
975: hr_utility.set_message(801,'HR_51503_ESA_ESTAB_BG');
976: hr_utility.raise_error;
977: --
978: end if;
979: --

Line 976: hr_utility.raise_error;

972: --
973: -- raise error as person does not exist for this business group
974: --
975: hr_utility.set_message(801,'HR_51503_ESA_ESTAB_BG');
976: hr_utility.raise_error;
977: --
978: end if;
979: --
980: close c1;

Line 984: hr_utility.set_location(l_proc, 4);

980: close c1;
981: --
982: end if;
983: --
984: hr_utility.set_location(l_proc, 4);
985: --
986: --UPDATE of Business_group_id is not allowed unless currently null(U)
987: --
988: if (l_api_updating

Line 993: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');

989: and nvl(per_esa_shd.g_old_rec.business_group_id,hr_api.g_number)
990: <> hr_api.g_number
991: and per_esa_shd.g_old_rec.business_group_id <> p_business_group_id ) then
992: --
993: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
994: hr_utility.raise_error;
995: --
996: end if;
997: --

Line 994: hr_utility.raise_error;

990: <> hr_api.g_number
991: and per_esa_shd.g_old_rec.business_group_id <> p_business_group_id ) then
992: --
993: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
994: hr_utility.raise_error;
995: --
996: end if;
997: --
998: hr_utility.set_location('Leaving:'||l_proc, 5);

Line 998: hr_utility.set_location('Leaving:'||l_proc, 5);

994: hr_utility.raise_error;
995: --
996: end if;
997: --
998: hr_utility.set_location('Leaving:'||l_proc, 5);
999: --
1000: end chk_estab_bg;
1001: --
1002: -- ----------------------------------------------------------------------------

Line 1041: hr_utility.set_location('Entering:'||l_proc,10);

1037: where per.attendance_id = p_attendance_id;
1038: --
1039: Begin
1040: --
1041: hr_utility.set_location('Entering:'||l_proc,10);
1042: --
1043: open c1;
1044: --
1045: fetch c1 into l_dummy;

Line 1053: hr_utility.set_message(801,'HR_51580_ESA_ESTAB_ATT_DEL');

1049: close c1;
1050: --
1051: -- raise error as attendance_id is referenced.
1052: --
1053: hr_utility.set_message(801,'HR_51580_ESA_ESTAB_ATT_DEL');
1054: hr_utility.raise_error;
1055: --
1056: end if;
1057: --

Line 1054: hr_utility.raise_error;

1050: --
1051: -- raise error as attendance_id is referenced.
1052: --
1053: hr_utility.set_message(801,'HR_51580_ESA_ESTAB_ATT_DEL');
1054: hr_utility.raise_error;
1055: --
1056: end if;
1057: --
1058: close c1;

Line 1060: hr_utility.set_location('Leaving:'||l_proc,10);

1056: end if;
1057: --
1058: close c1;
1059: --
1060: hr_utility.set_location('Leaving:'||l_proc,10);
1061: --
1062: end chk_estab_att_delete;
1063: --
1064: -- -----------------------------------------------------------------------

Line 1097: hr_utility.set_location('Entering:'||l_proc, 10);

1093: --
1094: l_proc varchar2(72) := g_package||'chk_df';
1095: --
1096: begin
1097: hr_utility.set_location('Entering:'||l_proc, 10);
1098: --
1099: if ((p_rec.attendance_id is not null) and (
1100: nvl(per_esa_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1101: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 1197: hr_utility.set_location(' Leaving:'||l_proc, 20);

1193: ,p_attribute20_value => p_rec.attribute20
1194: );
1195: end if;
1196: --
1197: hr_utility.set_location(' Leaving:'||l_proc, 20);
1198:
1199: end chk_df;
1200: -- ----------------------------------------------------------------------------
1201: -- |---------------------------< insert_validate >----------------------------|

Line 1209: hr_utility.set_location('Entering:'||l_proc, 5);

1205: --
1206: l_proc varchar2(72) := g_package||'insert_validate';
1207: --
1208: Begin
1209: hr_utility.set_location('Entering:'||l_proc, 5);
1210: --
1211: -- only party_id is specified, validate business_group_id
1212: -- for HR/TCA merge
1213: --

Line 1315: hr_utility.set_location(' Leaving:'||l_proc, 10);

1311: -- ======================
1312: --
1313: per_esa_bus.chk_df(p_rec => p_rec);
1314: --
1315: hr_utility.set_location(' Leaving:'||l_proc, 10);
1316: End insert_validate;
1317: --
1318: -- ----------------------------------------------------------------------------
1319: -- |---------------------------< update_validate >----------------------------|

Line 1327: hr_utility.set_location('Entering:'||l_proc, 5);

1323: --
1324: l_proc varchar2(72) := g_package||'update_validate';
1325: --
1326: Begin
1327: hr_utility.set_location('Entering:'||l_proc, 5);
1328: --
1329: --
1330: -- if person_id is specified, validate business_group_id
1331: -- for HR/TCA merge

Line 1423: hr_utility.set_location(' Leaving:'||l_proc, 10);

1419: -- ======================
1420: --
1421: per_esa_bus.chk_df(p_rec => p_rec);
1422: --
1423: hr_utility.set_location(' Leaving:'||l_proc, 10);
1424: End update_validate;
1425: --
1426: -- ----------------------------------------------------------------------------
1427: -- |---------------------------< delete_validate >----------------------------|

Line 1434: hr_utility.set_location('Entering:'||l_proc, 5);

1430: --
1431: l_proc varchar2(72) := g_package||'delete_validate';
1432: --
1433: Begin
1434: hr_utility.set_location('Entering:'||l_proc, 5);
1435: --
1436: -- Call all supporting business operations
1437: --
1438: -- Business Rule Mapping

Line 1444: hr_utility.set_location(' Leaving:'||l_proc, 10);

1440: -- CHK_ESTAB_ATT_DELETE
1441: chk_estab_att_delete(p_rec.attendance_id,
1442: p_rec.object_version_number);
1443: --
1444: hr_utility.set_location(' Leaving:'||l_proc, 10);
1445: End delete_validate;
1446: --
1447: -- ---------------------------------------------------------------------------
1448: -- |---------------------< return_legislation_code >-------------------------|

Line 1478: hr_utility.set_location('Entering:'|| l_proc, 10);

1474: l_no_business_group varchar2(1);
1475: l_legislation_code varchar2(150);
1476: l_proc varchar2(72) := g_package||'return_legislation_code';
1477: begin
1478: hr_utility.set_location('Entering:'|| l_proc, 10);
1479: --
1480: -- Ensure that all the mandatory parameter are not null
1481: --
1482: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1500: -- call to this function. Just return the value in the global
1501: -- variable.
1502: --
1503: l_legislation_code := g_legislation_code;
1504: hr_utility.set_location(l_proc, 20);
1505: else
1506: --
1507: -- The ID is different to the last call to this function
1508: -- or this is the first call to this function.

Line 1521: hr_utility.set_location(' Leaving:'|| l_proc, 30);

1517: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1518: fnd_message.raise_error;
1519: end if;
1520: --
1521: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1522: --
1523: -- Set the global variables so the vlaues are
1524: -- available for the next call to this function
1525: --

Line 1530: hr_utility.set_location('Entering:'|| l_proc, 40);

1526: close csr_leg_code;
1527: g_attendance_id := p_attendance_id;
1528: g_legislation_code := l_legislation_code;
1529: end if;
1530: hr_utility.set_location('Entering:'|| l_proc, 40);
1531: --
1532: return l_legislation_code;
1533: end return_legislation_code;
1534: --