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_QUA_BUS dependencies on HR_UTILITY

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

39: l_security_group_id number;
40: l_proc varchar2(72) := g_package||'set_security_group_id';
41: --
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 58: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

54: close csr_sec_grp;
55: --
56: -- The primary key is invalid therefore we must error
57: --
58: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
59: hr_multi_message.add
60: (p_associated_column1 => nvl(p_associated_column1, 'QUALIFICATION_ID')
61: );
62: else

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

68: (p_security_group_id => l_security_group_id
69: );
70: end if;
71: --
72: hr_utility.set_location(' Leaving:'|| l_proc, 20);
73: --
74: end set_security_group_id;
75: --
76: --

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

97: l_legislation_code varchar2(150);
98: l_proc varchar2(72) := g_package||'return_legislation_code';
99: Begin
100: --
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102: --
103: -- Ensure that all the mandatory parameter are not null
104: --
105: hr_api.mandatory_arg_error

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

115: -- call to this function. Just return the value in the global
116: -- variable.
117: --
118: l_legislation_code := per_qua_bus.g_legislation_code;
119: hr_utility.set_location(l_proc, 20);
120: else
121: --
122: -- The ID is different to the last call to this function
123: -- or this is the first call to this function.

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

132: close csr_leg_code;
133: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
134: fnd_message.raise_error;
135: end if;
136: hr_utility.set_location(l_proc,30);
137: --
138: -- Set the global variables so the values are
139: -- available for the next call to this function.
140: --

Line 145: hr_utility.set_location(' Leaving:'|| l_proc, 40);

141: close csr_leg_code;
142: per_qua_bus.g_qualification_id := p_qualification_id;
143: per_qua_bus.g_legislation_code := l_legislation_code;
144: end if;
145: hr_utility.set_location(' Leaving:'|| l_proc, 40);
146: return l_legislation_code;
147: end return_legislation_code;
148: --
149: -- ----------------------------------------------------------------------------

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

178: l_api_updating boolean;
179: --
180: Begin
181: --
182: hr_utility.set_location('Entering:'||l_proc,5);
183: --
184: l_api_updating := per_qua_shd.api_updating
185: (p_qualification_id => p_qualification_id,
186: p_object_version_number => p_object_version_number);

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

206: end if;
207: --
208: end if;
209: --
210: hr_utility.set_location('Leaving:'||l_proc,10);
211: --
212: End chk_qualification_id;
213: --
214: -- ----------------------------------------------------------------------------

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

251: where per.qualification_type_id = p_qualification_type_id;
252: --
253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc,5);
256: --
257: l_api_updating := per_qua_shd.api_updating
258: (p_qualification_id => p_qualification_id,
259: p_object_version_number => p_object_version_number);

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

282: close c1;
283: --
284: end if;
285: --
286: hr_utility.set_location('Leaving:'||l_proc,10);
287: --
288: End chk_qualification_type_id;
289: --
290: -- ----------------------------------------------------------------------------

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

343: where per.attendance_id = p_attendance_id;
344: --
345: Begin
346: --
347: hr_utility.set_location('Entering:'||l_proc,5);
348: --
349: l_api_updating := per_qua_shd.api_updating
350: (p_qualification_id => p_qualification_id,
351: p_object_version_number => p_object_version_number);

Line 369: hr_utility.set_message(801,'HR_51833_QUA_PER_ATT_ID');

365: -- WWBUG 2658623 comment out the following 2 lines
366: --or ((p_person_id is not null or p_party_id is not null)
367: --and p_attendance_id is not null)) then
368: --
369: hr_utility.set_message(801,'HR_51833_QUA_PER_ATT_ID');
370: hr_multi_message.add
371: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
372: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
373: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

Line 390: hr_utility.set_message(801,'HR_51834_QUA_PER_ID_INV');

386: fetch c1 into l_dummy;
387: if c1%notfound then
388: --
389: close c1;
390: hr_utility.set_message(801,'HR_51834_QUA_PER_ID_INV');
391: hr_multi_message.add
392: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
393: );
394: --

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

424: and nvl(per_qua_shd.g_old_rec.person_id,hr_api.g_number) <> hr_api.g_number
425: and per_qua_shd.g_old_rec.person_id <> p_person_id
426: ) then
427: --
428: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');
429: hr_utility.raise_error;
430: --
431: end if;
432: --

Line 429: hr_utility.raise_error;

425: and per_qua_shd.g_old_rec.person_id <> p_person_id
426: ) then
427: --
428: hr_utility.set_message(800, 'HR_289948_INV_UPD_PERSON_ID');
429: hr_utility.raise_error;
430: --
431: end if;
432: --
433: hr_utility.set_location('Leaving:'||l_proc,10);

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

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

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

496: from per_establishment_attendances pea
497: where pea.attendance_id = p_rec.attendance_id;
498: --
499: begin
500: hr_utility.set_location('Entering:'|| l_proc, 1);
501: --
502: --
503: if p_rec.person_id is not null then
504: if hr_multi_message.no_all_inclusive_error

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

507: ) then
508: open csr_get_party_id;
509: fetch csr_get_party_id into l_party_id;
510: close csr_get_party_id;
511: hr_utility.set_location(l_proc,20);
512: if p_rec.party_id is not null then
513: if p_rec.party_id <> nvl(l_party_id,-1) then
514: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
515: hr_utility.set_location(l_proc,30);

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

510: close csr_get_party_id;
511: hr_utility.set_location(l_proc,20);
512: if p_rec.party_id is not null then
513: if p_rec.party_id <> nvl(l_party_id,-1) then
514: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
515: hr_utility.set_location(l_proc,30);
516: hr_multi_message.add
517: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
518: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

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

511: hr_utility.set_location(l_proc,20);
512: if p_rec.party_id is not null then
513: if p_rec.party_id <> nvl(l_party_id,-1) then
514: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
515: hr_utility.set_location(l_proc,30);
516: hr_multi_message.add
517: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
518: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
519: );

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

521: else
522: --
523: -- derive party_id from per_all_people_f using person_id
524: --
525: hr_utility.set_location(l_proc,50);
526: p_rec.party_id := l_party_id;
527: end if;
528: end if; --end if for no_all_inclusive_error
529: else

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

534: ) then
535: open csr_attendances;
536: fetch csr_attendances into l_party_id,l_person_id;
537: close csr_attendances;
538: hr_utility.set_location(l_proc,60);
539: if p_rec.party_id is not null then
540: if p_rec.party_id <> l_party_id then
541: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
542: hr_utility.set_location(l_proc,70);

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

537: close csr_attendances;
538: hr_utility.set_location(l_proc,60);
539: if p_rec.party_id is not null then
540: if p_rec.party_id <> l_party_id then
541: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
542: hr_utility.set_location(l_proc,70);
543: hr_multi_message.add
544: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
545: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

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

538: hr_utility.set_location(l_proc,60);
539: if p_rec.party_id is not null then
540: if p_rec.party_id <> l_party_id then
541: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
542: hr_utility.set_location(l_proc,70);
543: hr_multi_message.add
544: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
545: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
546: );

Line 552: hr_utility.set_location(l_proc,80);

548: else
549: --
550: -- derive party_id from per_establishment_attendances
551: --
552: hr_utility.set_location(l_proc,80);
553: -- p_rec.person_id := l_person_id; WWBUG#2289195
554: p_rec.party_id := l_party_id;
555: end if;
556: end if;--end if for no_all_inclusive_error

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

556: end if;--end if for no_all_inclusive_error
557: else
558: if p_rec.party_id is null then
559: /* chk_person_id ensures that this does not occur*/
560: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
561: hr_utility.set_location(l_proc,90);
562: hr_multi_message.add
563: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
564: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'

Line 561: hr_utility.set_location(l_proc,90);

557: else
558: if p_rec.party_id is null then
559: /* chk_person_id ensures that this does not occur*/
560: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
561: hr_utility.set_location(l_proc,90);
562: hr_multi_message.add
563: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
564: ,p_associated_column2 => 'PER_QUALIFICATIONS.PARTY_ID'
565: ,p_associated_column3 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'

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

568: open csr_valid_party_id;
569: fetch csr_valid_party_id into l_party_id2;
570: if csr_valid_party_id%notfound then
571: close csr_valid_party_id;
572: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
573: hr_utility.set_location(l_proc,100);
574: hr_multi_message.add
575: (p_associated_column1 => 'PER_QUALIFICATIONS.PARTY_ID'
576: );

Line 573: hr_utility.set_location(l_proc,100);

569: fetch csr_valid_party_id into l_party_id2;
570: if csr_valid_party_id%notfound then
571: close csr_valid_party_id;
572: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
573: hr_utility.set_location(l_proc,100);
574: hr_multi_message.add
575: (p_associated_column1 => 'PER_QUALIFICATIONS.PARTY_ID'
576: );
577: else

Line 584: hr_utility.set_location(' Leaving:'||l_proc,200);

580: end if; -- party_id is null
581: end if; -- att_id is not null
582: end if; -- person_id is not null
583: --
584: hr_utility.set_location(' Leaving:'||l_proc,200);
585: End chk_party_id;
586:
587: --
588: -- ----------------------------------------------------------------------------

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

620: l_api_updating boolean;
621: --
622: Begin
623: --
624: hr_utility.set_location('Entering:'||l_proc,5);
625: --
626: l_api_updating := per_qua_shd.api_updating
627: (p_qualification_id => p_qualification_id,
628: p_object_version_number => p_object_version_number);

Line 644: hr_utility.set_message(801,'HR_51835_QUA_STATUS_LKP');

640: (p_effective_date => p_effective_date,
641: p_lookup_type => 'PER_SUBJECT_STATUSES',
642: p_lookup_code => p_status) then
643: --
644: hr_utility.set_message(801,'HR_51835_QUA_STATUS_LKP');
645: hr_utility.raise_error;
646: --
647: end if;
648: --

Line 645: hr_utility.raise_error;

641: p_lookup_type => 'PER_SUBJECT_STATUSES',
642: p_lookup_code => p_status) then
643: --
644: hr_utility.set_message(801,'HR_51835_QUA_STATUS_LKP');
645: hr_utility.raise_error;
646: --
647: end if;
648: --
649: end if;

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

649: end if;
650: --
651: end if;
652: --
653: hr_utility.set_location('Leaving:'||l_proc,10);
654: --
655: exception
656: when app_exception.application_exception then
657: if hr_multi_message.exception_add

Line 661: hr_utility.set_location(' Leaving:'||l_proc, 11);

657: if hr_multi_message.exception_add
658: (p_associated_column1 => 'PER_QUALIFICATIONS.STATUS'
659: ) then
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 11);
662: --
663: raise;
664: end if;
665: --

Line 666: hr_utility.set_location(' Leaving:'||l_proc, 12);

662: --
663: raise;
664: end if;
665: --
666: hr_utility.set_location(' Leaving:'||l_proc, 12);
667: --
668: End chk_status;
669: --
670: -- ----------------------------------------------------------------------------

Line 757: hr_utility.set_location('BUG1956358',99);

753: l_api_updating boolean;
754: --
755: Begin
756: --
757: hr_utility.set_location('********BUG1956358********',99);
758: hr_utility.set_location('Entering:'||l_proc,5);
759: --
760: l_api_updating := per_qua_shd.api_updating
761: (p_qualification_id => p_qualification_id,

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

754: --
755: Begin
756: --
757: hr_utility.set_location('********BUG1956358********',99);
758: hr_utility.set_location('Entering:'||l_proc,5);
759: --
760: l_api_updating := per_qua_shd.api_updating
761: (p_qualification_id => p_qualification_id,
762: p_object_version_number => p_object_version_number);

Line 767: hr_utility.set_location('Start Date= '||p_start_date,20);

763: --
764: if p_awarded_date is not null then
765:
766:
767: hr_utility.set_location('Start Date= '||p_start_date,20);
768: hr_utility.set_location('Prev Start Date= '||l_old_start_date,30);
769: hr_utility.set_location('End Date= '||p_end_date,40);
770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);
771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);

Line 768: hr_utility.set_location('Prev Start Date= '||l_old_start_date,30);

764: if p_awarded_date is not null then
765:
766:
767: hr_utility.set_location('Start Date= '||p_start_date,20);
768: hr_utility.set_location('Prev Start Date= '||l_old_start_date,30);
769: hr_utility.set_location('End Date= '||p_end_date,40);
770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);
771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);
772: hr_utility.set_location('Prev Awarded Date= '||l_old_awarded_date,70);

Line 769: hr_utility.set_location('End Date= '||p_end_date,40);

765:
766:
767: hr_utility.set_location('Start Date= '||p_start_date,20);
768: hr_utility.set_location('Prev Start Date= '||l_old_start_date,30);
769: hr_utility.set_location('End Date= '||p_end_date,40);
770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);
771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);
772: hr_utility.set_location('Prev Awarded Date= '||l_old_awarded_date,70);
773: hr_utility.set_location('Proj Comp Date= '||p_projected_completion_date,80);

Line 770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);

766:
767: hr_utility.set_location('Start Date= '||p_start_date,20);
768: hr_utility.set_location('Prev Start Date= '||l_old_start_date,30);
769: hr_utility.set_location('End Date= '||p_end_date,40);
770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);
771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);
772: hr_utility.set_location('Prev Awarded Date= '||l_old_awarded_date,70);
773: hr_utility.set_location('Proj Comp Date= '||p_projected_completion_date,80);
774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);

Line 771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);

767: hr_utility.set_location('Start Date= '||p_start_date,20);
768: hr_utility.set_location('Prev Start Date= '||l_old_start_date,30);
769: hr_utility.set_location('End Date= '||p_end_date,40);
770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);
771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);
772: hr_utility.set_location('Prev Awarded Date= '||l_old_awarded_date,70);
773: hr_utility.set_location('Proj Comp Date= '||p_projected_completion_date,80);
774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);
775: --

Line 772: hr_utility.set_location('Prev Awarded Date= '||l_old_awarded_date,70);

768: hr_utility.set_location('Prev Start Date= '||l_old_start_date,30);
769: hr_utility.set_location('End Date= '||p_end_date,40);
770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);
771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);
772: hr_utility.set_location('Prev Awarded Date= '||l_old_awarded_date,70);
773: hr_utility.set_location('Proj Comp Date= '||p_projected_completion_date,80);
774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);
775: --
776: if (l_api_updating

Line 773: hr_utility.set_location('Proj Comp Date= '||p_projected_completion_date,80);

769: hr_utility.set_location('End Date= '||p_end_date,40);
770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);
771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);
772: hr_utility.set_location('Prev Awarded Date= '||l_old_awarded_date,70);
773: hr_utility.set_location('Proj Comp Date= '||p_projected_completion_date,80);
774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);
775: --
776: if (l_api_updating
777: and (nvl(p_awarded_date,hr_api.g_date)

Line 774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);

770: hr_utility.set_location('Prev End Date= '||l_old_end_date,50);
771: hr_utility.set_location('Awarded Date= '||p_awarded_date,60);
772: hr_utility.set_location('Prev Awarded Date= '||l_old_awarded_date,70);
773: hr_utility.set_location('Proj Comp Date= '||p_projected_completion_date,80);
774: hr_utility.set_location('Prev Proj Comp Date= '||l_old_proj_comp_date,90);
775: --
776: if (l_api_updating
777: and (nvl(p_awarded_date,hr_api.g_date)
778: <> nvl(per_qua_shd.g_old_rec.awarded_date,hr_api.g_date)

Line 791: hr_utility.set_location('enter check for invalid dates',100);

787: -- check if awarded_date is after the start_date and greater than or
788: -- equal to the projected/actual completion date.
789: --
790:
791: hr_utility.set_location('enter check for invalid dates',100);
792: hr_utility.set_location('start of time= '||hr_api.g_sot,110);
793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);
794:
795:

Line 792: hr_utility.set_location('start of time= '||hr_api.g_sot,110);

788: -- equal to the projected/actual completion date.
789: --
790:
791: hr_utility.set_location('enter check for invalid dates',100);
792: hr_utility.set_location('start of time= '||hr_api.g_sot,110);
793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);
794:
795:
796: hr_utility.set_location('Start Date= '||p_start_date,20);

Line 793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);

789: --
790:
791: hr_utility.set_location('enter check for invalid dates',100);
792: hr_utility.set_location('start of time= '||hr_api.g_sot,110);
793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);
794:
795:
796: hr_utility.set_location('Start Date= '||p_start_date,20);
797: hr_utility.set_location('Awarded Date= '||p_awarded_date,20);

Line 796: hr_utility.set_location('Start Date= '||p_start_date,20);

792: hr_utility.set_location('start of time= '||hr_api.g_sot,110);
793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);
794:
795:
796: hr_utility.set_location('Start Date= '||p_start_date,20);
797: hr_utility.set_location('Awarded Date= '||p_awarded_date,20);
798:
799:
800: IF p_start_date is not null then

Line 797: hr_utility.set_location('Awarded Date= '||p_awarded_date,20);

793: hr_utility.set_location('end of time= '||hr_api.g_eot,115);
794:
795:
796: hr_utility.set_location('Start Date= '||p_start_date,20);
797: hr_utility.set_location('Awarded Date= '||p_awarded_date,20);
798:
799:
800: IF p_start_date is not null then
801: hr_utility.set_location('p_start_date1',40);

Line 801: hr_utility.set_location('p_start_date1',40);

797: hr_utility.set_location('Awarded Date= '||p_awarded_date,20);
798:
799:
800: IF p_start_date is not null then
801: hr_utility.set_location('p_start_date1',40);
802: --hr_utility.set_message(801,'1Start Date Error');
803: if p_awarded_date < p_start_date then
804: hr_utility.set_location('Start Date Error',30);
805: hr_utility.set_message(801,'HR_51836_QUA_AWARD_DATE_INV');

Line 802: --hr_utility.set_message(801,'1Start Date Error');

798:
799:
800: IF p_start_date is not null then
801: hr_utility.set_location('p_start_date1',40);
802: --hr_utility.set_message(801,'1Start Date Error');
803: if p_awarded_date < p_start_date then
804: hr_utility.set_location('Start Date Error',30);
805: hr_utility.set_message(801,'HR_51836_QUA_AWARD_DATE_INV');
806: hr_utility.set_message(801,'Start Date Error');

Line 804: hr_utility.set_location('Start Date Error',30);

800: IF p_start_date is not null then
801: hr_utility.set_location('p_start_date1',40);
802: --hr_utility.set_message(801,'1Start Date Error');
803: if p_awarded_date < p_start_date then
804: hr_utility.set_location('Start Date Error',30);
805: hr_utility.set_message(801,'HR_51836_QUA_AWARD_DATE_INV');
806: hr_utility.set_message(801,'Start Date Error');
807: hr_utility.raise_error;
808: END IF;

Line 805: hr_utility.set_message(801,'HR_51836_QUA_AWARD_DATE_INV');

801: hr_utility.set_location('p_start_date1',40);
802: --hr_utility.set_message(801,'1Start Date Error');
803: if p_awarded_date < p_start_date then
804: hr_utility.set_location('Start Date Error',30);
805: hr_utility.set_message(801,'HR_51836_QUA_AWARD_DATE_INV');
806: hr_utility.set_message(801,'Start Date Error');
807: hr_utility.raise_error;
808: END IF;
809: end if;

Line 806: hr_utility.set_message(801,'Start Date Error');

802: --hr_utility.set_message(801,'1Start Date Error');
803: if p_awarded_date < p_start_date then
804: hr_utility.set_location('Start Date Error',30);
805: hr_utility.set_message(801,'HR_51836_QUA_AWARD_DATE_INV');
806: hr_utility.set_message(801,'Start Date Error');
807: hr_utility.raise_error;
808: END IF;
809: end if;
810:

Line 807: hr_utility.raise_error;

803: if p_awarded_date < p_start_date then
804: hr_utility.set_location('Start Date Error',30);
805: hr_utility.set_message(801,'HR_51836_QUA_AWARD_DATE_INV');
806: hr_utility.set_message(801,'Start Date Error');
807: hr_utility.raise_error;
808: END IF;
809: end if;
810:
811: hr_utility.set_location('Project_comp_date= '||p_projected_completion_date,40);

Line 811: hr_utility.set_location('Project_comp_date= '||p_projected_completion_date,40);

807: hr_utility.raise_error;
808: END IF;
809: end if;
810:
811: hr_utility.set_location('Project_comp_date= '||p_projected_completion_date,40);
812: hr_utility.set_location('End Date= '||p_end_date,40);
813: hr_utility.set_location('Awarded Date= '||p_awarded_date,40);
814:
815: IF p_end_date is not null then

Line 812: hr_utility.set_location('End Date= '||p_end_date,40);

808: END IF;
809: end if;
810:
811: hr_utility.set_location('Project_comp_date= '||p_projected_completion_date,40);
812: hr_utility.set_location('End Date= '||p_end_date,40);
813: hr_utility.set_location('Awarded Date= '||p_awarded_date,40);
814:
815: IF p_end_date is not null then
816: hr_utility.set_location('p_end_date1',40);

Line 813: hr_utility.set_location('Awarded Date= '||p_awarded_date,40);

809: end if;
810:
811: hr_utility.set_location('Project_comp_date= '||p_projected_completion_date,40);
812: hr_utility.set_location('End Date= '||p_end_date,40);
813: hr_utility.set_location('Awarded Date= '||p_awarded_date,40);
814:
815: IF p_end_date is not null then
816: hr_utility.set_location('p_end_date1',40);
817: --hr_utility.set_message(801,'1End Date Error');

Line 816: hr_utility.set_location('p_end_date1',40);

812: hr_utility.set_location('End Date= '||p_end_date,40);
813: hr_utility.set_location('Awarded Date= '||p_awarded_date,40);
814:
815: IF p_end_date is not null then
816: hr_utility.set_location('p_end_date1',40);
817: --hr_utility.set_message(801,'1End Date Error');
818: if p_awarded_date < p_end_date then
819: hr_utility.set_location('End/Projected date error',50);
820: hr_utility.set_message(800,'PER_289710_INVALID_AWARD_DATE');

Line 817: --hr_utility.set_message(801,'1End Date Error');

813: hr_utility.set_location('Awarded Date= '||p_awarded_date,40);
814:
815: IF p_end_date is not null then
816: hr_utility.set_location('p_end_date1',40);
817: --hr_utility.set_message(801,'1End Date Error');
818: if p_awarded_date < p_end_date then
819: hr_utility.set_location('End/Projected date error',50);
820: hr_utility.set_message(800,'PER_289710_INVALID_AWARD_DATE');
821: hr_utility.raise_error;

Line 819: hr_utility.set_location('End/Projected date error',50);

815: IF p_end_date is not null then
816: hr_utility.set_location('p_end_date1',40);
817: --hr_utility.set_message(801,'1End Date Error');
818: if p_awarded_date < p_end_date then
819: hr_utility.set_location('End/Projected date error',50);
820: hr_utility.set_message(800,'PER_289710_INVALID_AWARD_DATE');
821: hr_utility.raise_error;
822: END IF;
823:

Line 820: hr_utility.set_message(800,'PER_289710_INVALID_AWARD_DATE');

816: hr_utility.set_location('p_end_date1',40);
817: --hr_utility.set_message(801,'1End Date Error');
818: if p_awarded_date < p_end_date then
819: hr_utility.set_location('End/Projected date error',50);
820: hr_utility.set_message(800,'PER_289710_INVALID_AWARD_DATE');
821: hr_utility.raise_error;
822: END IF;
823:
824: else

Line 821: hr_utility.raise_error;

817: --hr_utility.set_message(801,'1End Date Error');
818: if p_awarded_date < p_end_date then
819: hr_utility.set_location('End/Projected date error',50);
820: hr_utility.set_message(800,'PER_289710_INVALID_AWARD_DATE');
821: hr_utility.raise_error;
822: END IF;
823:
824: else
825: if p_projected_completion_date is not null then

Line 826: hr_utility.set_location('p_end_date2',40);

822: END IF;
823:
824: else
825: if p_projected_completion_date is not null then
826: hr_utility.set_location('p_end_date2',40);
827: --hr_utility.set_message(801,'1Projected Date Error');
828: if p_awarded_date < p_projected_completion_date then
829: hr_utility.set_location('End/Projected date error',50);
830: hr_utility.set_message(800,'PER_289711_INVALID_AWARD_DATE');

Line 827: --hr_utility.set_message(801,'1Projected Date Error');

823:
824: else
825: if p_projected_completion_date is not null then
826: hr_utility.set_location('p_end_date2',40);
827: --hr_utility.set_message(801,'1Projected Date Error');
828: if p_awarded_date < p_projected_completion_date then
829: hr_utility.set_location('End/Projected date error',50);
830: hr_utility.set_message(800,'PER_289711_INVALID_AWARD_DATE');
831: hr_utility.raise_error;

Line 829: hr_utility.set_location('End/Projected date error',50);

825: if p_projected_completion_date is not null then
826: hr_utility.set_location('p_end_date2',40);
827: --hr_utility.set_message(801,'1Projected Date Error');
828: if p_awarded_date < p_projected_completion_date then
829: hr_utility.set_location('End/Projected date error',50);
830: hr_utility.set_message(800,'PER_289711_INVALID_AWARD_DATE');
831: hr_utility.raise_error;
832: END IF;
833: end if;

Line 830: hr_utility.set_message(800,'PER_289711_INVALID_AWARD_DATE');

826: hr_utility.set_location('p_end_date2',40);
827: --hr_utility.set_message(801,'1Projected Date Error');
828: if p_awarded_date < p_projected_completion_date then
829: hr_utility.set_location('End/Projected date error',50);
830: hr_utility.set_message(800,'PER_289711_INVALID_AWARD_DATE');
831: hr_utility.raise_error;
832: END IF;
833: end if;
834: end if;

Line 831: hr_utility.raise_error;

827: --hr_utility.set_message(801,'1Projected Date Error');
828: if p_awarded_date < p_projected_completion_date then
829: hr_utility.set_location('End/Projected date error',50);
830: hr_utility.set_message(800,'PER_289711_INVALID_AWARD_DATE');
831: hr_utility.raise_error;
832: END IF;
833: end if;
834: end if;
835: --

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

836: end if;
837: --
838: end if;
839: --
840: hr_utility.set_location('Leaving:'||l_proc,10);
841: --
842: exception
843: when app_exception.application_exception then
844: if hr_multi_message.exception_add

Line 849: hr_utility.set_location(' Leaving:'||l_proc, 11);

845: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'
846: ,p_associated_column2 => 'PER_QUALIFICATIONS.AWARDED_DATE'
847: ) then
848: --
849: hr_utility.set_location(' Leaving:'||l_proc, 11);
850: --
851: raise;
852: end if;
853: --

Line 854: hr_utility.set_location(' Leaving:'||l_proc, 12);

850: --
851: raise;
852: end if;
853: --
854: hr_utility.set_location(' Leaving:'||l_proc, 12);
855: --
856: End chk_awarded_date;
857: --
858: -- ----------------------------------------------------------------------------

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

897: where fnd.currency_code = p_fee_currency;
898: --
899: Begin
900: --
901: hr_utility.set_location('Entering:'||l_proc,5);
902: --
903: l_api_updating := per_qua_shd.api_updating
904: (p_qualification_id => p_qualification_id,
905: p_object_version_number => p_object_version_number);

Line 926: hr_utility.set_message(801,'HR_51840_QUA_FEE_CURRENCY');

922: --
923: -- raise error as fee or fee currency has been set without the other
924: -- having been set.
925: --
926: hr_utility.set_message(801,'HR_51840_QUA_FEE_CURRENCY');
927: hr_multi_message.add
928: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE'
929: ,p_associated_column2 => 'PER_QUALIFICATIONS.FEE_CURRENCY'
930: );

Line 947: hr_utility.set_message(801,'HR_51855_QUA_CCY_INV');

943: --
944: -- raise error as currency does not exist in table
945: --
946: close c1;
947: hr_utility.set_message(801,'HR_51855_QUA_CCY_INV');
948: --
949: hr_multi_message.add
950: (p_associated_column1 => 'PER_QUALIFICATIONS.FEE_CURRENCY'
951: );

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

958: end if; --fee_curr is not null
959: --
960: end if;
961: --
962: hr_utility.set_location('Leaving:'||l_proc,10);
963: --
964: End chk_fee;
965: --
966: -- ----------------------------------------------------------------------------

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

1057: -- Bug: 1664055 Ends here.
1058: --
1059: Begin
1060: --
1061: hr_utility.set_location('Entering:'||l_proc,5);
1062: --
1063: l_api_updating := per_qua_shd.api_updating
1064: (p_qualification_id => p_qualification_id,
1065: p_object_version_number => p_object_version_number);

Line 1078: hr_utility.set_message(800,'HR_289739_QUA_NULL_DOB');

1074: fetch c3 into l_dob;
1075: if (c3%found) then
1076: if (l_dob is null) then
1077: close c3;
1078: hr_utility.set_message(800,'HR_289739_QUA_NULL_DOB');
1079: hr_utility.raise_error;
1080: elsif (l_dob > p_start_date) then
1081: close c3;
1082: hr_utility.set_message(800,'HR_289383_QUA_START_DATE');

Line 1079: hr_utility.raise_error;

1075: if (c3%found) then
1076: if (l_dob is null) then
1077: close c3;
1078: hr_utility.set_message(800,'HR_289739_QUA_NULL_DOB');
1079: hr_utility.raise_error;
1080: elsif (l_dob > p_start_date) then
1081: close c3;
1082: hr_utility.set_message(800,'HR_289383_QUA_START_DATE');
1083: hr_utility.raise_error;

Line 1082: hr_utility.set_message(800,'HR_289383_QUA_START_DATE');

1078: hr_utility.set_message(800,'HR_289739_QUA_NULL_DOB');
1079: hr_utility.raise_error;
1080: elsif (l_dob > p_start_date) then
1081: close c3;
1082: hr_utility.set_message(800,'HR_289383_QUA_START_DATE');
1083: hr_utility.raise_error;
1084: end if;
1085: end if;
1086: close c3;

Line 1083: hr_utility.raise_error;

1079: hr_utility.raise_error;
1080: elsif (l_dob > p_start_date) then
1081: close c3;
1082: hr_utility.set_message(800,'HR_289383_QUA_START_DATE');
1083: hr_utility.raise_error;
1084: end if;
1085: end if;
1086: close c3;
1087: end if;

Line 1126: hr_utility.set_message(801,'HR_51841_QUA_DATES_OUT_ESA');

1122: -- raise error as qualification start and end dates are outside of
1123: -- the dates of the establishment attendance.
1124: --
1125: close c1;
1126: hr_utility.set_message(801,'HR_51841_QUA_DATES_OUT_ESA');
1127: hr_multi_message.add
1128: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1129: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1130: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'

Line 1163: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');

1159: -- raise error as we have found a linked subjects taken record that is
1160: -- not bounded by the qualification record.
1161: --
1162: close c2;
1163: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1164: hr_multi_message.add
1165: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1166: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1167: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'

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

1175: --
1176: end if;*/
1177: end if; -- l_api_updating
1178: --
1179: hr_utility.set_location('Leaving:'||l_proc,10);
1180: --
1181: End chk_start_date;
1182: --
1183: -- ----------------------------------------------------------------------------

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

1231: and nvl(per.end_date,per.start_date) > nvl(p_end_date,hr_api.g_eot);
1232:
1233: Begin
1234: --
1235: hr_utility.set_location('Entering:'||l_proc,5);
1236: --
1237: --
1238: open c1;
1239: --

Line 1248: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');

1244: -- not bounded by the qualification record.
1245: --
1246: close c1;
1247:
1248: hr_utility.set_message(801,'HR_51842_QUA_SUB_DATES');
1249: hr_multi_message.add
1250: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1251: ,p_associated_column2 => 'PER_QUALIFICATIONS.START_DATE'
1252: ,p_associated_column3 => 'PER_QUALIFICATIONS.END_DATE'

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

1257: close c1;
1258: --
1259: end if;
1260: --
1261: hr_utility.set_location('Leaving:'||l_proc,10);
1262: --
1263: End chk_end_date;
1264: --
1265: -- ----------------------------------------------------------------------------

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

1298: l_api_updating boolean;
1299: --
1300: Begin
1301: --
1302: hr_utility.set_location('Entering:'||l_proc,5);
1303: --
1304: if hr_multi_message.no_all_inclusive_error
1305: (p_check_column1 => 'PER_QUALIFICATIONS.START_DATE'
1306: ) then

Line 1328: hr_utility.set_message(801,'HR_51844_QUA_PROJ_DATE');

1324: --
1325: -- raise error as projected completion date is not after the
1326: -- start date.
1327: --
1328: hr_utility.set_message(801,'HR_51844_QUA_PROJ_DATE');
1329: hr_utility.raise_error;
1330: --
1331: end if;
1332: --

Line 1329: hr_utility.raise_error;

1325: -- raise error as projected completion date is not after the
1326: -- start date.
1327: --
1328: hr_utility.set_message(801,'HR_51844_QUA_PROJ_DATE');
1329: hr_utility.raise_error;
1330: --
1331: end if;
1332: --
1333: end if;

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

1333: end if;
1334: --
1335: end if; -- for no_all_inclusive_error
1336: --
1337: hr_utility.set_location('Leaving:'||l_proc,10);
1338: --
1339: exception
1340: when app_exception.application_exception then
1341: if hr_multi_message.exception_add

Line 1346: hr_utility.set_location(' Leaving:'||l_proc, 11);

1342: (p_associated_column1 => 'PER_QUALIFICATIONS.START_DATE'
1343: ,p_associated_column2 => 'PER_QUALIFICATIONS.PROJECTED_COMPLETION_DATE'
1344: ) then
1345: --
1346: hr_utility.set_location(' Leaving:'||l_proc, 11);
1347: --
1348: raise;
1349: end if;
1350: --

Line 1351: hr_utility.set_location(' Leaving:'||l_proc, 12);

1347: --
1348: raise;
1349: end if;
1350: --
1351: hr_utility.set_location(' Leaving:'||l_proc, 12);
1352: --
1353: End chk_projected_completion_date;
1354: --
1355: -- ----------------------------------------------------------------------------

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

1387: l_api_updating boolean;
1388: --
1389: Begin
1390: --
1391: hr_utility.set_location('Entering:'||l_proc,5);
1392: --
1393: l_api_updating := per_qua_shd.api_updating
1394: (p_qualification_id => p_qualification_id,
1395: p_object_version_number => p_object_version_number);

Line 1411: hr_utility.set_message(801,'HR_51845_QUA_TUITION_MTHD');

1407: (p_effective_date => p_effective_date,
1408: p_lookup_type => 'PER_TUITION_METHODS',
1409: p_lookup_code => p_tuition_method) then
1410: --
1411: hr_utility.set_message(801,'HR_51845_QUA_TUITION_MTHD');
1412: hr_utility.raise_error;
1413: --
1414: end if;
1415: --

Line 1412: hr_utility.raise_error;

1408: p_lookup_type => 'PER_TUITION_METHODS',
1409: p_lookup_code => p_tuition_method) then
1410: --
1411: hr_utility.set_message(801,'HR_51845_QUA_TUITION_MTHD');
1412: hr_utility.raise_error;
1413: --
1414: end if;
1415: --
1416: end if;

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

1416: end if;
1417: --
1418: end if;
1419: --
1420: hr_utility.set_location('Leaving:'||l_proc,10);
1421: --
1422: exception
1423: when app_exception.application_exception then
1424: if hr_multi_message.exception_add

Line 1428: hr_utility.set_location(' Leaving:'||l_proc, 11);

1424: if hr_multi_message.exception_add
1425: (p_associated_column1 => 'PER_QUALIFICATIONS.TUITION_METHOD'
1426: ) then
1427: --
1428: hr_utility.set_location(' Leaving:'||l_proc, 11);
1429: --
1430: raise;
1431: end if;
1432: --

Line 1433: hr_utility.set_location(' Leaving:'||l_proc, 12);

1429: --
1430: raise;
1431: end if;
1432: --
1433: hr_utility.set_location(' Leaving:'||l_proc, 12);
1434: --
1435: End chk_tuition_method;
1436: --
1437: -- ----------------------------------------------------------------------------

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

1477: nvl(per.business_group_id,-1));
1478: --
1479: Begin
1480: --
1481: hr_utility.set_location('Entering:'||l_proc,5);
1482: --
1483: if hr_multi_message.no_all_inclusive_error
1484: (p_check_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1485: ) then

Line 1512: hr_utility.set_message(801,'HR_51848_QUA_ESTAB_ATT_BG');

1508: -- raise error as BG is different for establishment attendance and
1509: -- qualification record.
1510: --
1511: close c1;
1512: hr_utility.set_message(801,'HR_51848_QUA_ESTAB_ATT_BG');
1513: hr_utility.raise_error;
1514: --
1515: end if;
1516: --

Line 1513: hr_utility.raise_error;

1509: -- qualification record.
1510: --
1511: close c1;
1512: hr_utility.set_message(801,'HR_51848_QUA_ESTAB_ATT_BG');
1513: hr_utility.raise_error;
1514: --
1515: end if;
1516: --
1517: close c1;

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

1521: end if; -- l_api_updating
1522: --
1523: end if; -- no_all_inclusive_error
1524: --
1525: hr_utility.set_location('Leaving:'||l_proc,10);
1526: --
1527: exception
1528: when app_exception.application_exception then
1529: if hr_multi_message.exception_add

Line 1533: hr_utility.set_location(' Leaving:'||l_proc, 11);

1529: if hr_multi_message.exception_add
1530: (p_associated_column1 => 'PER_QUALIFICATIONS.ATTENDANCE_ID'
1531: ) then
1532: --
1533: hr_utility.set_location(' Leaving:'||l_proc, 11);
1534: --
1535: raise;
1536: end if;
1537: --

Line 1538: hr_utility.set_location(' Leaving:'||l_proc, 12);

1534: --
1535: raise;
1536: end if;
1537: --
1538: hr_utility.set_location(' Leaving:'||l_proc, 12);
1539: --
1540: End chk_estab_att_bg;
1541: --
1542: -- ----------------------------------------------------------------------------

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

1588: and nvl(per.effective_end_date,hr_api.g_eot);
1589: --
1590: Begin
1591: --
1592: hr_utility.set_location('Entering:'||l_proc,5);
1593: --
1594: if hr_multi_message.no_all_inclusive_error
1595: (p_check_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
1596: ) then

Line 1621: hr_utility.set_message(801,'HR_51849_QUA_PERSON_BG');

1617: --
1618: -- raise error as BG is different for person and qualification record.
1619: --
1620: close c1;
1621: hr_utility.set_message(801,'HR_51849_QUA_PERSON_BG');
1622: hr_utility.raise_error;
1623: --
1624: end if;
1625: --

Line 1622: hr_utility.raise_error;

1618: -- raise error as BG is different for person and qualification record.
1619: --
1620: close c1;
1621: hr_utility.set_message(801,'HR_51849_QUA_PERSON_BG');
1622: hr_utility.raise_error;
1623: --
1624: end if;
1625: --
1626: close c1;

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

1630: end if; -- l_api_updating
1631: --
1632: end if; -- no_all_inclusive_error
1633: --
1634: hr_utility.set_location(l_proc,9);
1635: --
1636: --UPDATE of BG_ID not allowed unless currently null(U)
1637: --
1638: if (l_api_updating

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

1638: if (l_api_updating
1639: and nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number
1640: and per_qua_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1641: --
1642: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1643: hr_utility.raise_error;
1644: --
1645: end if;
1646: --

Line 1643: hr_utility.raise_error;

1639: and nvl(per_qua_shd.g_old_rec.business_group_id,hr_api.g_number) <> hr_api.g_number
1640: and per_qua_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1641: --
1642: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1643: hr_utility.raise_error;
1644: --
1645: end if;
1646: --
1647: hr_utility.set_location('Leaving:'||l_proc,10);

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

1643: hr_utility.raise_error;
1644: --
1645: end if;
1646: --
1647: hr_utility.set_location('Leaving:'||l_proc,10);
1648: --
1649: exception
1650: when app_exception.application_exception then
1651: if hr_multi_message.exception_add

Line 1655: hr_utility.set_location(' Leaving:'||l_proc, 11);

1651: if hr_multi_message.exception_add
1652: (p_associated_column1 => 'PER_QUALIFICATIONS.PERSON_ID'
1653: ) then
1654: --
1655: hr_utility.set_location(' Leaving:'||l_proc, 11);
1656: --
1657: raise;
1658: end if;
1659: --

Line 1660: hr_utility.set_location(' Leaving:'||l_proc, 12);

1656: --
1657: raise;
1658: end if;
1659: --
1660: hr_utility.set_location(' Leaving:'||l_proc, 12);
1661: --
1662: End chk_person_bg;
1663: --
1664: -- ----------------------------------------------------------------------------

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

1697: where per.qualification_id = p_qualification_id;
1698: --
1699: Begin
1700: --
1701: hr_utility.set_location('Entering:'||l_proc,5);
1702: --
1703: if hr_multi_message.no_all_inclusive_error
1704: (p_check_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1705: ) then

Line 1717: hr_utility.set_message(801,'HR_51857_QUA_REC_DEL');

1713: --
1714: -- raise error as child records exist.
1715: --
1716: close c1;
1717: hr_utility.set_message(801,'HR_51857_QUA_REC_DEL');
1718: hr_utility.raise_error;
1719: --
1720: end if;
1721: --

Line 1718: hr_utility.raise_error;

1714: -- raise error as child records exist.
1715: --
1716: close c1;
1717: hr_utility.set_message(801,'HR_51857_QUA_REC_DEL');
1718: hr_utility.raise_error;
1719: --
1720: end if;
1721: --
1722: close c1;

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

1722: close c1;
1723: --
1724: end if;
1725: --
1726: hr_utility.set_location('Leaving:'||l_proc,10);
1727: --
1728: exception
1729: when app_exception.application_exception then
1730: if hr_multi_message.exception_add

Line 1734: hr_utility.set_location(' Leaving:'||l_proc, 11);

1730: if hr_multi_message.exception_add
1731: (p_associated_column1 => 'PER_QUALIFICATIONS.QUALIFICATION_ID'
1732: ) then
1733: --
1734: hr_utility.set_location(' Leaving:'||l_proc, 11);
1735: --
1736: raise;
1737: end if;
1738: --

Line 1739: hr_utility.set_location(' Leaving:'||l_proc, 12);

1735: --
1736: raise;
1737: end if;
1738: --
1739: hr_utility.set_location(' Leaving:'||l_proc, 12);
1740: --
1741: End chk_qualification_delete;
1742: --
1743: -- ----------------------------------------------------------------------------

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

1788: --
1789: l_proc varchar2(72) := g_package||'chk_qual_overlap';
1790: --
1791: begin
1792: hr_utility.set_location('Entering:'||l_proc, 10);
1793: --
1794: per_qat_bus.chk_qual_overlap
1795: (p_qualification_id => p_qualification_id
1796: ,p_qualification_type_id => p_qualification_type_id

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

1803: ,p_object_version_number => p_object_version_number
1804: ,p_party_id => p_party_id
1805: ,p_language => userenv('LANG'));
1806: --
1807: hr_utility.set_location(' Leaving:'||l_proc, 20);
1808: end chk_qual_overlap;
1809: --
1810: -- -----------------------------------------------------------------------
1811: -- |------------------------------< chk_df >-----------------------------|

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

1842: --
1843: l_proc varchar2(72) := g_package||'chk_df';
1844: --
1845: begin
1846: hr_utility.set_location('Entering:'||l_proc, 10);
1847: --
1848: if ((p_rec.qualification_id is not null) and (
1849: nvl(per_qua_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1850: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1941: ,p_attribute20_name => 'ATTRIBUTE20'
1942: ,p_attribute20_value => p_rec.attribute20);
1943: end if;
1944: --
1945: hr_utility.set_location(' Leaving:'||l_proc, 20);
1946: end chk_df;
1947: -- ----------------------------------------------------------------------------
1948: -- |-----------------------------< chk_ddf >----------------------------------|
1949: -- ----------------------------------------------------------------------------

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

1978: --
1979: l_proc varchar2(72) := g_package || 'chk_ddf';
1980: --
1981: begin
1982: hr_utility.set_location('Entering:'||l_proc,10);
1983: --
1984: if ((p_rec.qualification_id is not null) and (
1985: nvl(per_qua_shd.g_old_rec.qua_information_category, hr_api.g_varchar2) <>
1986: nvl(p_rec.qua_information_category, hr_api.g_varchar2) or

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

2077: ,p_attribute20_value => p_rec.qua_information20
2078: );
2079: end if;
2080: --
2081: hr_utility.set_location(' Leaving:'||l_proc,20);
2082: end chk_ddf;
2083: --
2084: -- ----------------------------------------------------------------------------
2085: -- |---------------------------< insert_validate >----------------------------|

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

2089: --
2090: l_proc varchar2(72) := g_package||'insert_validate';
2091: --
2092: Begin
2093: hr_utility.set_location('Entering:'||l_proc, 5);
2094: --
2095: -- Call all supporting business operations
2096: --
2097: -- Business Rule Mapping

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

2257: per_qua_bus.chk_df(p_rec => p_rec);
2258: --
2259: per_qua_bus.chk_ddf(p_rec);
2260: --
2261: hr_utility.set_location(' Leaving:'||l_proc, 10);
2262: End insert_validate;
2263: --
2264: -- ----------------------------------------------------------------------------
2265: -- |---------------------------< update_validate >----------------------------|

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

2269: --
2270: l_proc varchar2(72) := g_package||'update_validate';
2271: --
2272: Begin
2273: hr_utility.set_location('Entering:'||l_proc, 5);
2274: hr_utility.set_location('End Date Hello = '||p_rec.end_date,998);
2275: --
2276: -- Business Rule Mapping
2277: -- =====================

Line 2274: hr_utility.set_location('End Date Hello = '||p_rec.end_date,998);

2270: l_proc varchar2(72) := g_package||'update_validate';
2271: --
2272: Begin
2273: hr_utility.set_location('Entering:'||l_proc, 5);
2274: hr_utility.set_location('End Date Hello = '||p_rec.end_date,998);
2275: --
2276: -- Business Rule Mapping
2277: -- =====================
2278: -- CHK_BUSINESS_GROUP_ID

Line 2341: hr_utility.set_location('End Date Hello = '||p_rec.end_date,999);

2337: p_object_version_number => p_rec.object_version_number);
2338: --
2339: -- Business Rule Mapping
2340: -- =====================
2341: hr_utility.set_location('End Date Hello = '||p_rec.end_date,999);
2342: -- CHK_AWARDED_DATE
2343: chk_awarded_date
2344: (p_qualification_id => p_rec.qualification_id,
2345: p_awarded_date => p_rec.awarded_date,

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

2436: per_qua_bus.chk_df(p_rec => p_rec);
2437: --
2438: per_qua_bus.chk_ddf(p_rec);
2439: --
2440: hr_utility.set_location(' Leaving:'||l_proc, 10);
2441: End update_validate;
2442: --
2443: -- ----------------------------------------------------------------------------
2444: -- |---------------------------< delete_validate >----------------------------|

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

2447: --
2448: l_proc varchar2(72) := g_package||'delete_validate';
2449: --
2450: Begin
2451: hr_utility.set_location('Entering:'||l_proc, 5);
2452: --
2453: -- Call all supporting business operations
2454: --
2455: -- Business Rule Mapping

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

2456: -- =====================
2457: -- CHK_QUALIFICATION_DELETE
2458: chk_qualification_delete(p_qualification_id => p_rec.qualification_id);
2459: --
2460: hr_utility.set_location(' Leaving:'||l_proc, 10);
2461: End delete_validate;
2462: --
2463: end per_qua_bus;