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

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

38: l_api_updating boolean;
39: --
40: Begin
41: --
42: hr_utility.set_location('Entering:'||l_proc,5);
43: --
44: l_api_updating := per_sub_shd.api_updating
45: (p_subjects_taken_id => p_subjects_taken_id,
46: p_object_version_number => p_object_version_number);

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

66: end if;
67: --
68: end if;
69: --
70: hr_utility.set_location('Leaving:'||l_proc,10);
71: --
72: End chk_subjects_taken_id;
73: --
74: -- ----------------------------------------------------------------------------

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

110: where per.qualification_id = p_qualification_id;
111: --
112: Begin
113: --
114: hr_utility.set_location('Entering:'||l_proc,5);
115: --
116: l_api_updating := per_sub_shd.api_updating
117: (p_subjects_taken_id => p_subjects_taken_id,
118: p_object_version_number => p_object_version_number);

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

138: close c1;
139: --
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc,10);
143: --
144: End chk_qualification_id;
145: --
146: -- ----------------------------------------------------------------------------

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

207: into l_start_date,l_end_date
208: from per_qualifications per
209: where per.qualification_id = p_qualification_id;
210: --
211: hr_utility.set_location('Entering:'||l_proc,5);
212: --
213: l_api_updating := per_sub_shd.api_updating
214: (p_subjects_taken_id => p_subjects_taken_id,
215: p_object_version_number => p_object_version_number);

Line 237: hr_utility.set_message(801,'HR_51817_SUB_START_DATE_QUAL');

233: if l_start_date is not null then
234: if c1%notfound then
235: --
236: close c1;
237: hr_utility.set_message(801,'HR_51817_SUB_START_DATE_QUAL');
238: hr_utility.raise_error;
239: --
240: end if;
241: end if;

Line 238: hr_utility.raise_error;

234: if c1%notfound then
235: --
236: close c1;
237: hr_utility.set_message(801,'HR_51817_SUB_START_DATE_QUAL');
238: hr_utility.raise_error;
239: --
240: end if;
241: end if;
242: --

Line 255: hr_utility.set_message(801,'HR_51817_SUB_START_DATE_QUAL');

251: end if;
252: --
253: if p_start_date > nvl(l_end_date,p_start_date) then
254: --
255: hr_utility.set_message(801,'HR_51817_SUB_START_DATE_QUAL');
256: hr_utility.raise_error;
257: --
258: end if;
259: --

Line 256: hr_utility.raise_error;

252: --
253: if p_start_date > nvl(l_end_date,p_start_date) then
254: --
255: hr_utility.set_message(801,'HR_51817_SUB_START_DATE_QUAL');
256: hr_utility.raise_error;
257: --
258: end if;
259: --
260: end if;

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

258: end if;
259: --
260: end if;
261: --
262: hr_utility.set_location('Leaving:'||l_proc,5);
263: --
264: End chk_start_date;
265: --
266: --

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

332: into l_end_date
333: from per_qualifications per
334: where per.qualification_id = p_qualification_id;
335: --
336: hr_utility.set_location('Entering:'||l_proc,5);
337: --
338: l_api_updating := per_sub_shd.api_updating
339: (p_subjects_taken_id => p_subjects_taken_id,
340: p_object_version_number => p_object_version_number);

Line 355: hr_utility.set_message(801,'HR_289802_SUB_END_QUAL');

351: if l_end_date is not null and p_end_date is not null then
352: if c1%notfound then
353: --
354: close c1;
355: hr_utility.set_message(801,'HR_289802_SUB_END_QUAL');
356: hr_utility.raise_error;
357: --
358: end if;
359: end if;

Line 356: hr_utility.raise_error;

352: if c1%notfound then
353: --
354: close c1;
355: hr_utility.set_message(801,'HR_289802_SUB_END_QUAL');
356: hr_utility.raise_error;
357: --
358: end if;
359: end if;
360: --

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

398: l_api_updating boolean;
399: --
400: Begin
401: --
402: hr_utility.set_location('Entering:'||l_proc,5);
403: --
404: l_api_updating := per_sub_shd.api_updating
405: (p_subjects_taken_id => p_subjects_taken_id,
406: p_object_version_number => p_object_version_number);

Line 421: hr_utility.set_message(801,'HR_51818_SUB_MAJOR_LKP_INV');

417: (p_effective_date => p_effective_date,
418: p_lookup_type => 'YES_NO',
419: p_lookup_code => p_major) then
420: --
421: hr_utility.set_message(801,'HR_51818_SUB_MAJOR_LKP_INV');
422: hr_utility.raise_error;
423: --
424: end if;
425: --

Line 422: hr_utility.raise_error;

418: p_lookup_type => 'YES_NO',
419: p_lookup_code => p_major) then
420: --
421: hr_utility.set_message(801,'HR_51818_SUB_MAJOR_LKP_INV');
422: hr_utility.raise_error;
423: --
424: end if;
425: --
426: end if;

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

425: --
426: end if;
427: end if;
428: --
429: hr_utility.set_location('Leaving:'||l_proc,5);
430: --
431: End chk_major;
432: --
433: -- ----------------------------------------------------------------------------

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

464: l_api_updating boolean;
465: --
466: Begin
467: --
468: hr_utility.set_location('Entering:'||l_proc,5);
469: --
470: l_api_updating := per_sub_shd.api_updating
471: (p_subjects_taken_id => p_subjects_taken_id,
472: p_object_version_number => p_object_version_number);

Line 486: hr_utility.set_message(801,'HR_51819_SUB_STATUS_LKP_INV');

482: (p_effective_date => p_effective_date,
483: p_lookup_type => 'PER_SUBJECT_STATUSES',
484: p_lookup_code => p_subject_status) then
485: --
486: hr_utility.set_message(801,'HR_51819_SUB_STATUS_LKP_INV');
487: hr_utility.raise_error;
488: --
489: end if;
490: --

Line 487: hr_utility.raise_error;

483: p_lookup_type => 'PER_SUBJECT_STATUSES',
484: p_lookup_code => p_subject_status) then
485: --
486: hr_utility.set_message(801,'HR_51819_SUB_STATUS_LKP_INV');
487: hr_utility.raise_error;
488: --
489: end if;
490: --
491: end if;

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

489: end if;
490: --
491: end if;
492: --
493: hr_utility.set_location('Leaving:'||l_proc,5);
494: --
495: End chk_subject_status;
496: --
497: -- ----------------------------------------------------------------------------

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

551: and per.subjects_taken_id <> nvl(p_subjects_taken_id,-1);
552: --
553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc,5);
556: --
557: l_api_updating := per_sub_shd.api_updating
558: (p_subjects_taken_id => p_subjects_taken_id,
559: p_object_version_number => p_object_version_number);

Line 579: hr_utility.set_message(801,'HR_51820_SUB_SUBJECT_LKP_INV');

575: (p_effective_date => p_effective_date,
576: p_lookup_type => 'PER_SUBJECTS',
577: p_lookup_code => p_subject) then
578: --
579: hr_utility.set_message(801,'HR_51820_SUB_SUBJECT_LKP_INV');
580: hr_utility.raise_error;
581: --
582: end if;
583: --

Line 580: hr_utility.raise_error;

576: p_lookup_type => 'PER_SUBJECTS',
577: p_lookup_code => p_subject) then
578: --
579: hr_utility.set_message(801,'HR_51820_SUB_SUBJECT_LKP_INV');
580: hr_utility.raise_error;
581: --
582: end if;
583: --
584: -- Check if subject conflicts with a previous subject for the same

Line 597: hr_utility.set_message(801,'HR_51821_SUB_SUB_DATE_OVLAP');

593: --
594: -- raise error as subject trying to be added twice
595: --
596: close c1;
597: hr_utility.set_message(801,'HR_51821_SUB_SUB_DATE_OVLAP');
598: hr_utility.raise_error;
599: --
600: end if;
601: --

Line 598: hr_utility.raise_error;

594: -- raise error as subject trying to be added twice
595: --
596: close c1;
597: hr_utility.set_message(801,'HR_51821_SUB_SUB_DATE_OVLAP');
598: hr_utility.raise_error;
599: --
600: end if;
601: --
602: close c1;

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

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

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

642: --
643: l_proc varchar2(72) := g_package||'chk_df';
644: --
645: begin
646: hr_utility.set_location('Entering:'||l_proc, 10);
647: --
648: if ((p_rec.subjects_taken_id is not null) and (
649: nvl(per_sub_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
650: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

741: ,p_attribute20_name => 'ATTRIBUTE20'
742: ,p_attribute20_value => p_rec.attribute20);
743: end if;
744: --
745: hr_utility.set_location(' Leaving:'||l_proc, 20);
746: end chk_df;
747: -- ----------------------------------------------------------------------------
748: -- |-----------------------------< chk_ddf >----------------------------------|
749: -- ----------------------------------------------------------------------------

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

778: --
779: l_proc varchar2(72) := g_package || 'chk_ddf';
780: --
781: begin
782: hr_utility.set_location('Entering:'||l_proc,10);
783: --
784: if ((p_rec.subjects_taken_id is not null) and (
785: nvl(per_sub_shd.g_old_rec.sub_information_category, hr_api.g_varchar2) <>
786: nvl(p_rec.sub_information_category, hr_api.g_varchar2) or

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

877: ,p_attribute20_value => p_rec.sub_information20
878: );
879: end if;
880: --
881: hr_utility.set_location(' Leaving:'||l_proc,20);
882: end chk_ddf;
883:
884: --
885: -- ----------------------------------------------------------------------------

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

890: --
891: l_proc varchar2(72) := g_package||'insert_validate';
892: --
893: Begin
894: hr_utility.set_location('Entering:'||l_proc, 5);
895: --
896: per_qua_bus.set_security_group_id
897: (
898: p_qualification_id => p_rec.qualification_id);

Line 900: hr_utility.set_location('Entering:'||l_proc, 7);

896: per_qua_bus.set_security_group_id
897: (
898: p_qualification_id => p_rec.qualification_id);
899: --
900: hr_utility.set_location('Entering:'||l_proc, 7);
901: --
902: -- Call all supporting business operations
903: --
904: -- Business Rule Mapping

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

990: per_sub_bus.chk_df(p_rec => p_rec);
991: --
992: per_sub_bus.chk_ddf(p_rec => p_rec);
993: --
994: hr_utility.set_location(' Leaving:'||l_proc, 10);
995: End insert_validate;
996: --
997: -- ----------------------------------------------------------------------------
998: -- |---------------------------< update_validate >----------------------------|

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

1002: --
1003: l_proc varchar2(72) := g_package||'update_validate';
1004: --
1005: Begin
1006: hr_utility.set_location('Entering:'||l_proc, 5);
1007: --
1008: per_qua_bus.set_security_group_id
1009: (
1010: p_qualification_id => p_rec.qualification_id);

Line 1012: hr_utility.set_location('Entering:'||l_proc, 7);

1008: per_qua_bus.set_security_group_id
1009: (
1010: p_qualification_id => p_rec.qualification_id);
1011: --
1012: hr_utility.set_location('Entering:'||l_proc, 7);
1013: --
1014: -- Call all supporting business operations
1015: --
1016: -- Business Rule Mapping

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

1099: per_sub_bus.chk_df(p_rec => p_rec);
1100: --
1101: per_sub_bus.chk_ddf(p_rec => p_rec);
1102: --
1103: hr_utility.set_location(' Leaving:'||l_proc, 10);
1104: End update_validate;
1105: --
1106: -- ----------------------------------------------------------------------------
1107: -- |---------------------------< delete_validate >----------------------------|

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

1110: --
1111: l_proc varchar2(72) := g_package||'delete_validate';
1112: --
1113: Begin
1114: hr_utility.set_location('Entering:'||l_proc, 5);
1115: --
1116: -- Call all supporting business operations
1117: --
1118: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1114: hr_utility.set_location('Entering:'||l_proc, 5);
1115: --
1116: -- Call all supporting business operations
1117: --
1118: hr_utility.set_location(' Leaving:'||l_proc, 10);
1119: End delete_validate;
1120: --
1121: end per_sub_bus;