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

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

26: l_error exception;
27: l_argument varchar2(30);
28: --
29: Begin
30: hr_utility.set_location('Entering:'||l_proc, 10);
31: --
32: -- Only proceed with validation if a row exists for
33: -- the current record in the HR Schema
34: --

Line 39: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

35: if not per_sha_shd.api_updating
36: (p_std_holiday_absences_id => p_rec.std_holiday_absences_id,
37: p_object_version_number => p_rec.object_version_number)
38: then
39: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP', '20');
42: hr_utility.raise_error;
43: end if;

Line 40: hr_utility.set_message_token('PROCEDURE', l_proc);

36: (p_std_holiday_absences_id => p_rec.std_holiday_absences_id,
37: p_object_version_number => p_rec.object_version_number)
38: then
39: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP', '20');
42: hr_utility.raise_error;
43: end if;
44: hr_utility.set_location(l_proc, 30);

Line 41: hr_utility.set_message_token('STEP', '20');

37: p_object_version_number => p_rec.object_version_number)
38: then
39: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP', '20');
42: hr_utility.raise_error;
43: end if;
44: hr_utility.set_location(l_proc, 30);
45: --

Line 42: hr_utility.raise_error;

38: then
39: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP', '20');
42: hr_utility.raise_error;
43: end if;
44: hr_utility.set_location(l_proc, 30);
45: --
46: if nvl(p_rec.person_id, hr_api.g_number) <>

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

40: hr_utility.set_message_token('PROCEDURE', l_proc);
41: hr_utility.set_message_token('STEP', '20');
42: hr_utility.raise_error;
43: end if;
44: hr_utility.set_location(l_proc, 30);
45: --
46: if nvl(p_rec.person_id, hr_api.g_number) <>
47: nvl(per_sha_shd.g_old_rec.person_id
48: ,hr_api.g_number

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

50: l_argument := 'person_id';
51: raise l_error;
52: end if;
53: --
54: hr_utility.set_location(l_proc, 40);
55: exception
56: when l_error then
57: hr_api.argument_changed_error
58: (p_api_name => l_proc

Line 63: hr_utility.set_location(' Leaving:'||l_proc, 50);

59: ,p_argument => l_argument
60: );
61: when others then
62: raise;
63: hr_utility.set_location(' Leaving:'||l_proc, 50);
64: end chk_non_updateable_args;
65: --
66: -- ----------------------------------------------------------------------------
67: -- |-------------------------< chk_date_not_taken >---------------------------|

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

106: l_proc varchar2(72) := g_package||'chk_date_not_taken';
107: l_api_updating boolean;
108: --
109: begin
110: hr_utility.set_location('Entering:'||l_proc, 10);
111: --
112: -- Check mandatory parameters have been set
113: --
114: BEGIN

Line 122: hr_utility.set_message(800,'PER_50042_DATE_NOT_TAKEN_NULL');

118: ,p_argument_value => p_date_not_taken
119: );
120: EXCEPTION
121: WHEN OTHERS THEN
122: hr_utility.set_message(800,'PER_50042_DATE_NOT_TAKEN_NULL');
123: hr_utility.raise_error;
124: END;
125: --
126: -- Check whether field is being updated

Line 123: hr_utility.raise_error;

119: );
120: EXCEPTION
121: WHEN OTHERS THEN
122: hr_utility.set_message(800,'PER_50042_DATE_NOT_TAKEN_NULL');
123: hr_utility.raise_error;
124: END;
125: --
126: -- Check whether field is being updated
127: --

Line 138: hr_utility.set_message(800,'PER_50029_SHA_HOL_UPDATE');

134: --
135: -- Check whether the ACTUAL_DATE_TAKEN is NULL
136: --
137: if (p_actual_date_taken IS NOT NULL) then
138: hr_utility.set_message(800,'PER_50029_SHA_HOL_UPDATE');
139: hr_utility.raise_error;
140: elsif (p_expired = 'Y') then
141: hr_utility.set_message(800,'PER_50040_SHA_HOL_UPDATE_EXPD');
142: hr_utility.raise_error;

Line 139: hr_utility.raise_error;

135: -- Check whether the ACTUAL_DATE_TAKEN is NULL
136: --
137: if (p_actual_date_taken IS NOT NULL) then
138: hr_utility.set_message(800,'PER_50029_SHA_HOL_UPDATE');
139: hr_utility.raise_error;
140: elsif (p_expired = 'Y') then
141: hr_utility.set_message(800,'PER_50040_SHA_HOL_UPDATE_EXPD');
142: hr_utility.raise_error;
143: end if;

Line 141: hr_utility.set_message(800,'PER_50040_SHA_HOL_UPDATE_EXPD');

137: if (p_actual_date_taken IS NOT NULL) then
138: hr_utility.set_message(800,'PER_50029_SHA_HOL_UPDATE');
139: hr_utility.raise_error;
140: elsif (p_expired = 'Y') then
141: hr_utility.set_message(800,'PER_50040_SHA_HOL_UPDATE_EXPD');
142: hr_utility.raise_error;
143: end if;
144: end if;
145: --

Line 142: hr_utility.raise_error;

138: hr_utility.set_message(800,'PER_50029_SHA_HOL_UPDATE');
139: hr_utility.raise_error;
140: elsif (p_expired = 'Y') then
141: hr_utility.set_message(800,'PER_50040_SHA_HOL_UPDATE_EXPD');
142: hr_utility.raise_error;
143: end if;
144: end if;
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 146: hr_utility.set_location(' Leaving:'||l_proc, 3);

142: hr_utility.raise_error;
143: end if;
144: end if;
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 3);
147: --
148: end chk_date_not_taken;
149: --
150: -- ----------------------------------------------------------------------------

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

191: WHERE per.person_id = p_person_id
192: AND p_date_not_taken BETWEEN per.effective_start_date
193: AND per.effective_end_date;
194: begin
195: hr_utility.set_location('Entering:'||l_proc, 10);
196: --
197: -- Check mandatory parameters have been set
198: --
199: hr_api.mandatory_arg_error

Line 211: hr_utility.set_message(800,'HR_52361_PTU_INVALID_PERSON_ID');

207: open csr_valid_person_id;
208: fetch csr_valid_person_id into l_dummy;
209: if (csr_valid_person_id%NOTFOUND) then
210: close csr_valid_person_id;
211: hr_utility.set_message(800,'HR_52361_PTU_INVALID_PERSON_ID');
212: hr_utility.raise_error;
213: end if;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 212: hr_utility.raise_error;

208: fetch csr_valid_person_id into l_dummy;
209: if (csr_valid_person_id%NOTFOUND) then
210: close csr_valid_person_id;
211: hr_utility.set_message(800,'HR_52361_PTU_INVALID_PERSON_ID');
212: hr_utility.raise_error;
213: end if;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 3);
216: --

Line 215: hr_utility.set_location(' Leaving:'||l_proc, 3);

211: hr_utility.set_message(800,'HR_52361_PTU_INVALID_PERSON_ID');
212: hr_utility.raise_error;
213: end if;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 3);
216: --
217: end chk_person_id;
218: --
219: -- ----------------------------------------------------------------------------

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

263: SELECT sth.standard_holiday_id
264: FROM per_standard_holidays sth
265: WHERE sth.standard_holiday_id = p_standard_holiday_id;
266: begin
267: hr_utility.set_location('Entering:'||l_proc, 10);
268: --
269: -- Check mandatory parameters have been set
270: --
271: hr_api.mandatory_arg_error

Line 283: hr_utility.set_message(800,'PER_50038_SHA_INVALID_HOL_ID');

279: open csr_valid_std_hol_id;
280: fetch csr_valid_std_hol_id into l_dummy;
281: if (csr_valid_std_hol_id%NOTFOUND) then
282: close csr_valid_std_hol_id;
283: hr_utility.set_message(800,'PER_50038_SHA_INVALID_HOL_ID');
284: hr_utility.raise_error;
285: end if;
286: --
287: -- Update is not allowed if the ACTUAL_DATE_TAKEN is not NULL or the

Line 284: hr_utility.raise_error;

280: fetch csr_valid_std_hol_id into l_dummy;
281: if (csr_valid_std_hol_id%NOTFOUND) then
282: close csr_valid_std_hol_id;
283: hr_utility.set_message(800,'PER_50038_SHA_INVALID_HOL_ID');
284: hr_utility.raise_error;
285: end if;
286: --
287: -- Update is not allowed if the ACTUAL_DATE_TAKEN is not NULL or the
288: -- EXPIRED flag is 'checked'

Line 297: hr_utility.set_message(800,'PER_50028_SHA_HOL_UPDATE_ID');

293: --
294: if (l_api_updating AND
295: per_sha_shd.g_old_rec.standard_holiday_id <> p_standard_holiday_id) then
296: if (p_actual_date_taken is not NULL) then
297: hr_utility.set_message(800,'PER_50028_SHA_HOL_UPDATE_ID');
298: hr_utility.raise_error;
299: elsif (p_expired = 'Y') then
300: hr_utility.set_message(800,'PER_50039_SHA_EXPIRED_POP');
301: hr_utility.raise_error;

Line 298: hr_utility.raise_error;

294: if (l_api_updating AND
295: per_sha_shd.g_old_rec.standard_holiday_id <> p_standard_holiday_id) then
296: if (p_actual_date_taken is not NULL) then
297: hr_utility.set_message(800,'PER_50028_SHA_HOL_UPDATE_ID');
298: hr_utility.raise_error;
299: elsif (p_expired = 'Y') then
300: hr_utility.set_message(800,'PER_50039_SHA_EXPIRED_POP');
301: hr_utility.raise_error;
302: end if;

Line 300: hr_utility.set_message(800,'PER_50039_SHA_EXPIRED_POP');

296: if (p_actual_date_taken is not NULL) then
297: hr_utility.set_message(800,'PER_50028_SHA_HOL_UPDATE_ID');
298: hr_utility.raise_error;
299: elsif (p_expired = 'Y') then
300: hr_utility.set_message(800,'PER_50039_SHA_EXPIRED_POP');
301: hr_utility.raise_error;
302: end if;
303: end if;
304: --

Line 301: hr_utility.raise_error;

297: hr_utility.set_message(800,'PER_50028_SHA_HOL_UPDATE_ID');
298: hr_utility.raise_error;
299: elsif (p_expired = 'Y') then
300: hr_utility.set_message(800,'PER_50039_SHA_EXPIRED_POP');
301: hr_utility.raise_error;
302: end if;
303: end if;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 305: hr_utility.set_location(' Leaving:'||l_proc, 3);

301: hr_utility.raise_error;
302: end if;
303: end if;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 3);
306: --
307: end chk_standard_holiday_id;
308: --
309: -- ----------------------------------------------------------------------------

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

364: AND p_actual_date_taken BETWEEN sth.holiday_date
365: AND NVL(sth.holiday_date_end, sth.holiday_date);
366: --
367: begin
368: hr_utility.set_location('Entering:'||l_proc, 10);
369: --
370: -- Check whether field is being updated
371: --
372: l_api_updating := per_sha_shd.api_updating

Line 385: hr_utility.set_message(801,'PER_50026_SHA_EXPIRED_CHKD');

381: --
382: -- Check that the EXPIRED flag is not checked
383: --
384: if (p_expired = 'Y') then
385: hr_utility.set_message(801,'PER_50026_SHA_EXPIRED_CHKD');
386: hr_utility.raise_error;
387: end if;
388: --
389: -- Check that the ACTUAL_DATE_TAKEN does not overlap with any of the

Line 386: hr_utility.raise_error;

382: -- Check that the EXPIRED flag is not checked
383: --
384: if (p_expired = 'Y') then
385: hr_utility.set_message(801,'PER_50026_SHA_EXPIRED_CHKD');
386: hr_utility.raise_error;
387: end if;
388: --
389: -- Check that the ACTUAL_DATE_TAKEN does not overlap with any of the
390: -- Standard Holidays

Line 396: hr_utility.set_message(800,'PER_50025_SHA_DATE_NO_OVERLAP');

392: open csr_valid_actual_date_taken;
393: fetch csr_valid_actual_date_taken into l_dummy;
394: if (csr_valid_actual_date_taken%FOUND) then
395: close csr_valid_actual_date_taken;
396: hr_utility.set_message(800,'PER_50025_SHA_DATE_NO_OVERLAP');
397: hr_utility.raise_error;
398: end if;
399: end if;
400: --

Line 397: hr_utility.raise_error;

393: fetch csr_valid_actual_date_taken into l_dummy;
394: if (csr_valid_actual_date_taken%FOUND) then
395: close csr_valid_actual_date_taken;
396: hr_utility.set_message(800,'PER_50025_SHA_DATE_NO_OVERLAP');
397: hr_utility.raise_error;
398: end if;
399: end if;
400: --
401: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 401: hr_utility.set_location(' Leaving:'||l_proc, 3);

397: hr_utility.raise_error;
398: end if;
399: end if;
400: --
401: hr_utility.set_location(' Leaving:'||l_proc, 3);
402: --
403: end chk_actual_date_taken;
404: --
405: -- ----------------------------------------------------------------------------

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

442: l_proc varchar2(72) := g_package||'chk_expired';
443: l_api_updating boolean;
444: --
445: begin
446: hr_utility.set_location('Entering:'||l_proc, 10);
447: --
448: -- Check whether field is being updated
449: --
450: l_api_updating := per_sha_shd.api_updating

Line 464: hr_utility.set_message(800,'PER_50027_SHA_EXPIRED_UPD');

460: -- The EXPIRED flag can only be set if the ACTUAL_DATE_TAKEN is NULL
461: --
462: if (p_actual_date_taken is not NULL AND
463: p_expired = 'Y') then
464: hr_utility.set_message(800,'PER_50027_SHA_EXPIRED_UPD');
465: hr_utility.raise_error;
466: end if;
467: end if;
468: --

Line 465: hr_utility.raise_error;

461: --
462: if (p_actual_date_taken is not NULL AND
463: p_expired = 'Y') then
464: hr_utility.set_message(800,'PER_50027_SHA_EXPIRED_UPD');
465: hr_utility.raise_error;
466: end if;
467: end if;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 469: hr_utility.set_location(' Leaving:'||l_proc, 3);

465: hr_utility.raise_error;
466: end if;
467: end if;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 3);
470: --
471: end chk_expired;
472: --
473: -- -----------------------------------------------------------------------

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

502: --
503: l_proc varchar2(72) := g_package||'chk_df';
504: --
505: begin
506: hr_utility.set_location('Entering:'||l_proc, 10);
507: --
508: if ((p_rec.std_holiday_absences_id is not null) and (
509: nvl(per_sha_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
510: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

602: ,p_attribute20_value => p_rec.attribute20
603: );
604: end if;
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 20);
607: --
608: end chk_df;
609: --
610: -- ----------------------------------------------------------------------------

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

614: --
615: l_proc varchar2(72) := g_package||'insert_validate';
616: --
617: Begin
618: hr_utility.set_location('Entering:'||l_proc, 5);
619: --
620: -- As this data is not within the context of a business group
621: -- the set_security_group_id procedure has zero passed
622: -- to it as the default security_group_id.

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

622: -- to it as the default security_group_id.
623: --
624: hr_api.set_security_group_id(p_security_group_id => 0);
625: --
626: hr_utility.set_location('Entering:'||l_proc, 7);
627: --
628: -- Validate Standard Holiday Dates not taken
629: --
630: chk_date_not_taken

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

648: p_rec.standard_holiday_id,
649: p_rec.actual_date_taken,
650: p_rec.expired,
651: p_rec.object_version_number);
652: hr_utility.set_location(' Leaving:'||l_proc, 10);
653: --
654: -- Validate Actual Date Taken
655: --
656: chk_actual_date_taken

Line 671: hr_utility.set_location(' Leaving:'||l_proc, 15);

667: p_rec.expired,
668: p_rec.actual_date_taken,
669: p_rec.object_version_number);
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 15);
672: -- call descriptive flexfield validation routines
673: --
674: per_sha_bus.chk_df(p_rec => p_rec);
675: --

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

672: -- call descriptive flexfield validation routines
673: --
674: per_sha_bus.chk_df(p_rec => p_rec);
675: --
676: hr_utility.set_location (l_proc, 20);
677: End insert_validate;
678: --
679: -- ----------------------------------------------------------------------------
680: -- |---------------------------< update_validate >----------------------------|

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

683: --
684: l_proc varchar2(72) := g_package||'update_validate';
685: --
686: Begin
687: hr_utility.set_location('Entering:'||l_proc, 5);
688: --
689: -- As this data is not within the context of a business group
690: -- the set_security_group_id procedure has zero passed
691: -- to it as the default security_group_id.

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

691: -- to it as the default security_group_id.
692: --
693: hr_api.set_security_group_id(p_security_group_id => 0);
694: --
695: hr_utility.set_location('Entering:'||l_proc, 7);
696: --
697: -- Check no non-updateable arguments have been updated
698: --
699: chk_non_updateable_args (p_rec => p_rec);

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

714: p_rec.standard_holiday_id,
715: p_rec.actual_date_taken,
716: p_rec.expired,
717: p_rec.object_version_number);
718: hr_utility.set_location(' Leaving:'||l_proc, 10);
719: --
720: -- Validate Actual Date Taken
721: --
722: chk_actual_date_taken

Line 738: hr_utility.set_location (l_proc, 15);

734: p_rec.actual_date_taken,
735: p_rec.object_version_number);
736: --
737: --
738: hr_utility.set_location (l_proc, 15);
739: --
740: -- call descriptive flexfield validation routines
741: --
742: per_sha_bus.chk_df(p_rec => p_rec);

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

740: -- call descriptive flexfield validation routines
741: --
742: per_sha_bus.chk_df(p_rec => p_rec);
743: --
744: hr_utility.set_location(' Leaving:'||l_proc, 20);
745: --
746: End update_validate;
747: --
748: -- ----------------------------------------------------------------------------

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

752: --
753: l_proc varchar2(72) := g_package||'delete_validate';
754: --
755: Begin
756: hr_utility.set_location('Entering:'||l_proc, 5);
757: --
758: -- Call all supporting business operations
759: --
760: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

756: hr_utility.set_location('Entering:'||l_proc, 5);
757: --
758: -- Call all supporting business operations
759: --
760: hr_utility.set_location(' Leaving:'||l_proc, 10);
761: End delete_validate;
762: --
763: --
764: -- ---------------------------------------------------------------------------

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

785: --
786: l_legislation_code varchar2(150);
787: l_proc varchar2(72) := g_package||'return_legislation_code';
788: begin
789: hr_utility.set_location('Entering:'|| l_proc, 10);
790: --
791: -- Ensure that all the mandatory parameter are not null
792: --
793: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

800: -- call to this function. Just return the value in the global
801: -- variable.
802: --
803: l_legislation_code := g_legislation_code;
804: hr_utility.set_location(l_proc, 20);
805: else
806: --
807: -- The ID is different to the last call to this function
808: -- or this is the first call to this function.

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

813: close csr_leg_code;
814: --
815: -- The primary key is invalid therefore we must error
816: --
817: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
818: hr_utility.raise_error;
819: end if;
820: --
821: close csr_leg_code;

Line 818: hr_utility.raise_error;

814: --
815: -- The primary key is invalid therefore we must error
816: --
817: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
818: hr_utility.raise_error;
819: end if;
820: --
821: close csr_leg_code;
822: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

818: hr_utility.raise_error;
819: end if;
820: --
821: close csr_leg_code;
822: hr_utility.set_location(' Leaving:'|| l_proc, 20);
823: --
824: g_std_holiday_absences_id := p_std_holiday_absences_id;
825: g_legislation_code := l_legislation_code;
826: end if;

Line 827: hr_utility.set_location(' Leaving:'|| l_proc, 25);

823: --
824: g_std_holiday_absences_id := p_std_holiday_absences_id;
825: g_legislation_code := l_legislation_code;
826: end if;
827: hr_utility.set_location(' Leaving:'|| l_proc, 25);
828: --
829: return l_legislation_code;
830: end return_legislation_code;
831: --