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

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

47: l_error exception;
48: l_argument varchar2(30);
49: --
50: Begin
51: hr_utility.set_location('Entering:'||l_proc, 5);
52: --
53: -- Only proceed with validation if a row exists for
54: -- the current record in the HR Schema
55: --

Line 61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

57: (p_assignment_id => p_rec.assignment_id
58: ,p_object_version_number => p_rec.object_version_number
59: ,p_effective_date => p_effective_date
60: ) then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP', '5');
64: end if;
65: --

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

58: ,p_object_version_number => p_rec.object_version_number
59: ,p_effective_date => p_effective_date
60: ) then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP', '5');
64: end if;
65: --
66: hr_utility.set_location(l_proc, 6);

Line 63: hr_utility.set_message_token('STEP', '5');

59: ,p_effective_date => p_effective_date
60: ) then
61: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP', '5');
64: end if;
65: --
66: hr_utility.set_location(l_proc, 6);
67: --

Line 66: hr_utility.set_location(l_proc, 6);

62: hr_utility.set_message_token('PROCEDURE', l_proc);
63: hr_utility.set_message_token('STEP', '5');
64: end if;
65: --
66: hr_utility.set_location(l_proc, 6);
67: --
68: if nvl(p_rec.business_group_id, hr_api.g_number) <>
69: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
70: l_argument := 'business_group_id';

Line 73: hr_utility.set_location(l_proc, 7);

69: nvl(per_asg_shd.g_old_rec.business_group_id, hr_api.g_number) then
70: l_argument := 'business_group_id';
71: raise l_error;
72: end if;
73: hr_utility.set_location(l_proc, 7);
74: --
75: if nvl(p_rec.person_id,hr_api.g_number) <>
76: nvl(per_asg_shd.g_old_rec.person_id, hr_api.g_number) then
77: l_argument := 'person_id';

Line 81: hr_utility.set_location(l_proc, 8);

77: l_argument := 'person_id';
78: raise l_error;
79: end if;
80: --
81: hr_utility.set_location(l_proc, 8);
82: exception
83: when l_error then
84: hr_api.argument_changed_error
85: (p_api_name => l_proc

Line 89: hr_utility.set_location(' Leaving:'||l_proc, 9);

85: (p_api_name => l_proc
86: ,p_argument => l_argument);
87: when others then
88: raise;
89: hr_utility.set_location(' Leaving:'||l_proc, 9);
90: end check_non_updateable_args;
91: --
92: -- ---------------------------------------------------------------------------
93: -- |--------------------------< chk_person_id >------------------------------|

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

133: and ppf.effective_end_date;
134: --
135: --
136: begin
137: hr_utility.set_location('Entering:'|| l_proc, 1);
138: --
139: -- Check mandatory parameters have been set
140: --
141: hr_api.mandatory_arg_error

Line 147: hr_utility.set_location(l_proc, 2);

143: ,p_argument => 'person_id'
144: ,p_argument_value => p_person_id
145: );
146: --
147: hr_utility.set_location(l_proc, 2);
148: --
149: -- Check that person business group is the same as
150: -- the contract business group
151: --

Line 156: hr_utility.set_message(800, 'PER_52832_CTR_INV_BG');

152: open csr_get_bus_grp;
153: fetch csr_get_bus_grp into l_business_group_id;
154: if l_business_group_id <> p_business_group_id then
155: close csr_get_bus_grp;
156: hr_utility.set_message(800, 'PER_52832_CTR_INV_BG');
157: hr_utility.raise_error;
158: end if;
159: close csr_get_bus_grp;
160: --

Line 157: hr_utility.raise_error;

153: fetch csr_get_bus_grp into l_business_group_id;
154: if l_business_group_id <> p_business_group_id then
155: close csr_get_bus_grp;
156: hr_utility.set_message(800, 'PER_52832_CTR_INV_BG');
157: hr_utility.raise_error;
158: end if;
159: close csr_get_bus_grp;
160: --
161: hr_utility.set_location(' Leaving:'|| l_proc, 3);

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

157: hr_utility.raise_error;
158: end if;
159: close csr_get_bus_grp;
160: --
161: hr_utility.set_location(' Leaving:'|| l_proc, 3);
162: end chk_person_id;
163: --
164: -- ---------------------------------------------------------------------------
165: -- |--------------------------< chk_reference >------------------------------|

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

216: where person_id = p_person_id
217: and reference = p_reference;
218: --
219: begin
220: hr_utility.set_location('Entering:'|| l_proc, 1);
221: --
222: -- Check mandatory parameters have been set
223: --
224: hr_api.mandatory_arg_error

Line 236: hr_utility.set_location(l_proc, 2);

232: ,p_argument => 'p_datetrack_mode'
233: ,p_argument_value => p_datetrack_mode
234: );
235: --
236: hr_utility.set_location(l_proc, 2);
237: --
238: -- If this is a DT update and reference is changing, Check that
239: -- the reference does not exist for any other contract for the same person.
240: --

Line 251: hr_utility.set_message(800, 'PER_52855_CTC_ORIGINAL');

247: open csr_update;
248: fetch csr_update into l_exists;
249: if csr_update%FOUND then
250: close csr_update;
251: hr_utility.set_message(800, 'PER_52855_CTC_ORIGINAL');
252: hr_utility.raise_error;
253: end if;
254: close csr_update;
255: end if;

Line 252: hr_utility.raise_error;

248: fetch csr_update into l_exists;
249: if csr_update%FOUND then
250: close csr_update;
251: hr_utility.set_message(800, 'PER_52855_CTC_ORIGINAL');
252: hr_utility.raise_error;
253: end if;
254: close csr_update;
255: end if;
256: if p_datetrack_mode = 'INSERT' then

Line 261: hr_utility.set_message(800, 'PER_52855_CTC_ORIGINAL');

257: open csr_insert;
258: fetch csr_insert into l_exists;
259: if csr_insert%FOUND then
260: close csr_insert;
261: hr_utility.set_message(800, 'PER_52855_CTC_ORIGINAL');
262: hr_utility.raise_error;
263: end if;
264: close csr_insert;
265: end if;

Line 262: hr_utility.raise_error;

258: fetch csr_insert into l_exists;
259: if csr_insert%FOUND then
260: close csr_insert;
261: hr_utility.set_message(800, 'PER_52855_CTC_ORIGINAL');
262: hr_utility.raise_error;
263: end if;
264: close csr_insert;
265: end if;
266: --

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

263: end if;
264: close csr_insert;
265: end if;
266: --
267: hr_utility.set_location(' Leaving:'|| l_proc, 3);
268: end chk_reference;
269: --
270: -- ---------------------------------------------------------------------------
271: -- |-----------------------< chk_type >--------------------------------------|

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

312: l_exists varchar2(1);
313: l_api_updating boolean;
314: --
315: begin
316: hr_utility.set_location('Entering:'|| l_proc, 10);
317: --
318: -- Check mandatory parameters have been set
319: --
320: hr_api.mandatory_arg_error

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

333: (p_api_name => l_proc
334: ,p_argument => 'validation_end_date'
335: ,p_argument_value => p_validation_end_date
336: );
337: hr_utility.set_location(l_proc, 20);
338: --
339: l_api_updating := per_ctc_shd.api_updating
340: (p_contract_id => p_contract_id
341: ,p_effective_date => p_effective_date

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

340: (p_contract_id => p_contract_id
341: ,p_effective_date => p_effective_date
342: ,p_object_version_number => p_object_version_number
343: );
344: hr_utility.set_location(l_proc, 30);
345: --
346: if ((l_api_updating and
347: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
348: nvl(p_type, hr_api.g_varchar2))

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

347: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
348: nvl(p_type, hr_api.g_varchar2))
349: or (NOT l_api_updating))
350: then
351: hr_utility.set_location(l_proc, 40);
352: --
353: if p_type is not null then
354: --
355: -- Check that the type exists in hr_lookups for the

Line 369: hr_utility.set_message(800, 'PER_52820_CTR_INV_TYPE');

365: ,p_lookup_code => p_type
366: )
367: then
368: --
369: hr_utility.set_message(800, 'PER_52820_CTR_INV_TYPE');
370: hr_utility.raise_error;
371: --
372: end if;
373: hr_utility.set_location(l_proc, 50);

Line 370: hr_utility.raise_error;

366: )
367: then
368: --
369: hr_utility.set_message(800, 'PER_52820_CTR_INV_TYPE');
370: hr_utility.raise_error;
371: --
372: end if;
373: hr_utility.set_location(l_proc, 50);
374: --

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

369: hr_utility.set_message(800, 'PER_52820_CTR_INV_TYPE');
370: hr_utility.raise_error;
371: --
372: end if;
373: hr_utility.set_location(l_proc, 50);
374: --
375: end if;
376: hr_utility.set_location(l_proc, 60);
377: --

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

372: end if;
373: hr_utility.set_location(l_proc, 50);
374: --
375: end if;
376: hr_utility.set_location(l_proc, 60);
377: --
378: end if;
379: --
380: hr_utility.set_location(' Leaving:'|| l_proc, 70);

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

376: hr_utility.set_location(l_proc, 60);
377: --
378: end if;
379: --
380: hr_utility.set_location(' Leaving:'|| l_proc, 70);
381: --
382: end chk_type;
383: --
384: -- ---------------------------------------------------------------------------

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

426: l_exists varchar2(1);
427: l_api_updating boolean;
428: --
429: begin
430: hr_utility.set_location('Entering:'|| l_proc, 10);
431: --
432: -- Check mandatory parameters have been set
433: --
434: hr_api.mandatory_arg_error

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

447: (p_api_name => l_proc
448: ,p_argument => 'validation_end_date'
449: ,p_argument_value => p_validation_end_date
450: );
451: hr_utility.set_location(l_proc, 20);
452: --
453: l_api_updating := per_ctc_shd.api_updating
454: (p_contract_id => p_contract_id
455: ,p_effective_date => p_effective_date

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

454: (p_contract_id => p_contract_id
455: ,p_effective_date => p_effective_date
456: ,p_object_version_number => p_object_version_number
457: );
458: hr_utility.set_location(l_proc, 30);
459: --
460: if ((l_api_updating and
461: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
462: nvl(p_status, hr_api.g_varchar2))

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

461: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
462: nvl(p_status, hr_api.g_varchar2))
463: or (NOT l_api_updating))
464: then
465: hr_utility.set_location(l_proc, 40);
466: --
467: if p_status is not null then
468: --
469: -- Check that the status exists in hr_lookups for the

Line 483: hr_utility.set_message(800, 'PER_52821_CTR_INV_STATUS');

479: ,p_lookup_code => p_status
480: )
481: then
482: --
483: hr_utility.set_message(800, 'PER_52821_CTR_INV_STATUS');
484: hr_utility.raise_error;
485: --
486: end if;
487: hr_utility.set_location(l_proc, 50);

Line 484: hr_utility.raise_error;

480: )
481: then
482: --
483: hr_utility.set_message(800, 'PER_52821_CTR_INV_STATUS');
484: hr_utility.raise_error;
485: --
486: end if;
487: hr_utility.set_location(l_proc, 50);
488: --

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

483: hr_utility.set_message(800, 'PER_52821_CTR_INV_STATUS');
484: hr_utility.raise_error;
485: --
486: end if;
487: hr_utility.set_location(l_proc, 50);
488: --
489: end if;
490: hr_utility.set_location(l_proc, 60);
491: --

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

486: end if;
487: hr_utility.set_location(l_proc, 50);
488: --
489: end if;
490: hr_utility.set_location(l_proc, 60);
491: --
492: end if;
493: --
494: hr_utility.set_location(' Leaving:'|| l_proc, 70);

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

490: hr_utility.set_location(l_proc, 60);
491: --
492: end if;
493: --
494: hr_utility.set_location(' Leaving:'|| l_proc, 70);
495: --
496: end chk_status;
497: --
498: -- ---------------------------------------------------------------------------

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

540: l_exists varchar2(1);
541: l_api_updating boolean;
542: --
543: begin
544: hr_utility.set_location('Entering:'|| l_proc, 10);
545: --
546: -- Check mandatory parameters have been set
547: --
548: hr_api.mandatory_arg_error

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

561: (p_api_name => l_proc
562: ,p_argument => 'validation_end_date'
563: ,p_argument_value => p_validation_end_date
564: );
565: hr_utility.set_location(l_proc, 20);
566: --
567: l_api_updating := per_ctc_shd.api_updating
568: (p_contract_id => p_contract_id
569: ,p_effective_date => p_effective_date

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

568: (p_contract_id => p_contract_id
569: ,p_effective_date => p_effective_date
570: ,p_object_version_number => p_object_version_number
571: );
572: hr_utility.set_location(l_proc, 30);
573: --
574: if ((l_api_updating and
575: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
576: nvl(p_status_reason, hr_api.g_varchar2))

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

575: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
576: nvl(p_status_reason, hr_api.g_varchar2))
577: or (NOT l_api_updating))
578: then
579: hr_utility.set_location(l_proc, 40);
580: --
581: if p_status_reason is not null then
582: --
583: -- Check that the status_reason exists in hr_lookups for the

Line 597: hr_utility.set_message(800, 'PER_52822_CTR_INV_STATUS_REASO');

593: ,p_lookup_code => p_status_reason
594: )
595: then
596: --
597: hr_utility.set_message(800, 'PER_52822_CTR_INV_STATUS_REASO');
598: hr_utility.raise_error;
599: --
600: end if;
601: hr_utility.set_location(l_proc, 50);

Line 598: hr_utility.raise_error;

594: )
595: then
596: --
597: hr_utility.set_message(800, 'PER_52822_CTR_INV_STATUS_REASO');
598: hr_utility.raise_error;
599: --
600: end if;
601: hr_utility.set_location(l_proc, 50);
602: --

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

597: hr_utility.set_message(800, 'PER_52822_CTR_INV_STATUS_REASO');
598: hr_utility.raise_error;
599: --
600: end if;
601: hr_utility.set_location(l_proc, 50);
602: --
603: end if;
604: hr_utility.set_location(l_proc, 60);
605: --

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

600: end if;
601: hr_utility.set_location(l_proc, 50);
602: --
603: end if;
604: hr_utility.set_location(l_proc, 60);
605: --
606: end if;
607: --
608: hr_utility.set_location(' Leaving:'|| l_proc, 70);

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

604: hr_utility.set_location(l_proc, 60);
605: --
606: end if;
607: --
608: hr_utility.set_location(' Leaving:'|| l_proc, 70);
609: --
610: end chk_status_reason;
611: --
612: -- ---------------------------------------------------------------------------

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

656: l_exists varchar2(1);
657: l_api_updating boolean;
658: --
659: begin
660: hr_utility.set_location('Entering:'|| l_proc, 10);
661: --
662: -- Check mandatory parameters have been set
663: --
664: hr_api.mandatory_arg_error

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

677: (p_api_name => l_proc
678: ,p_argument => 'validation_end_date'
679: ,p_argument_value => p_validation_end_date
680: );
681: hr_utility.set_location(l_proc, 20);
682: --
683: l_api_updating := per_ctc_shd.api_updating
684: (p_contract_id => p_contract_id
685: ,p_effective_date => p_effective_date

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

684: (p_contract_id => p_contract_id
685: ,p_effective_date => p_effective_date
686: ,p_object_version_number => p_object_version_number
687: );
688: hr_utility.set_location(l_proc, 30);
689: --
690: if ((l_api_updating and
691: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
692: nvl(p_duration_units, hr_api.g_varchar2))

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

691: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
692: nvl(p_duration_units, hr_api.g_varchar2))
693: or (NOT l_api_updating))
694: then
695: hr_utility.set_location(l_proc, 40);
696: --
697: if p_duration_units is not null then
698: --
699: -- Check that the duration units exists in hr_lookups for the

Line 713: hr_utility.set_message(800, 'PER_52823_CTR_INV_DURATION_UN');

709: ,p_lookup_code => p_duration_units
710: )
711: then
712: --
713: hr_utility.set_message(800, 'PER_52823_CTR_INV_DURATION_UN');
714: hr_utility.raise_error;
715: --
716: end if;
717: --

Line 714: hr_utility.raise_error;

710: )
711: then
712: --
713: hr_utility.set_message(800, 'PER_52823_CTR_INV_DURATION_UN');
714: hr_utility.raise_error;
715: --
716: end if;
717: --
718: hr_utility.set_location(l_proc, 50);

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

714: hr_utility.raise_error;
715: --
716: end if;
717: --
718: hr_utility.set_location(l_proc, 50);
719: --
720: -- Check that the duration exists when the duration units is not null
721: --
722: if p_duration is null then

Line 723: hr_utility.set_message(800, 'PER_52843_INV_DURATION');

719: --
720: -- Check that the duration exists when the duration units is not null
721: --
722: if p_duration is null then
723: hr_utility.set_message(800, 'PER_52843_INV_DURATION');
724: hr_utility.raise_error;
725: --
726: end if;
727: hr_utility.set_location(l_proc, 60);

Line 724: hr_utility.raise_error;

720: -- Check that the duration exists when the duration units is not null
721: --
722: if p_duration is null then
723: hr_utility.set_message(800, 'PER_52843_INV_DURATION');
724: hr_utility.raise_error;
725: --
726: end if;
727: hr_utility.set_location(l_proc, 60);
728: --

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

723: hr_utility.set_message(800, 'PER_52843_INV_DURATION');
724: hr_utility.raise_error;
725: --
726: end if;
727: hr_utility.set_location(l_proc, 60);
728: --
729: else
730: --
731: -- Check that the duration doesn't exist when the duration units is null

Line 734: hr_utility.set_message(800, 'PER_52843_CTR_INV_DURATION');

730: --
731: -- Check that the duration doesn't exist when the duration units is null
732: --
733: if p_duration is not null then
734: hr_utility.set_message(800, 'PER_52843_CTR_INV_DURATION');
735: hr_utility.raise_error;
736: --
737: end if;
738: end if;

Line 735: hr_utility.raise_error;

731: -- Check that the duration doesn't exist when the duration units is null
732: --
733: if p_duration is not null then
734: hr_utility.set_message(800, 'PER_52843_CTR_INV_DURATION');
735: hr_utility.raise_error;
736: --
737: end if;
738: end if;
739: hr_utility.set_location(l_proc, 70);

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

735: hr_utility.raise_error;
736: --
737: end if;
738: end if;
739: hr_utility.set_location(l_proc, 70);
740: --
741: end if;
742: --
743: hr_utility.set_location(' Leaving:'|| l_proc, 80);

Line 743: hr_utility.set_location(' Leaving:'|| l_proc, 80);

739: hr_utility.set_location(l_proc, 70);
740: --
741: end if;
742: --
743: hr_utility.set_location(' Leaving:'|| l_proc, 80);
744: --
745: end chk_duration_units;
746: --
747: -- ---------------------------------------------------------------------------

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

789: l_exists varchar2(1);
790: l_api_updating boolean;
791: --
792: begin
793: hr_utility.set_location('Entering:'|| l_proc, 10);
794: --
795: -- Check mandatory parameters have been set
796: --
797: hr_api.mandatory_arg_error

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

810: (p_api_name => l_proc
811: ,p_argument => 'validation_end_date'
812: ,p_argument_value => p_validation_end_date
813: );
814: hr_utility.set_location(l_proc, 20);
815: --
816: l_api_updating := per_ctc_shd.api_updating
817: (p_contract_id => p_contract_id
818: ,p_effective_date => p_effective_date

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

817: (p_contract_id => p_contract_id
818: ,p_effective_date => p_effective_date
819: ,p_object_version_number => p_object_version_number
820: );
821: hr_utility.set_location(l_proc, 30);
822: --
823: if ((l_api_updating and
824: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
825: nvl(p_start_reason, hr_api.g_varchar2))

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

824: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
825: nvl(p_start_reason, hr_api.g_varchar2))
826: or (NOT l_api_updating))
827: then
828: hr_utility.set_location(l_proc, 40);
829: --
830: if p_start_reason is not null then
831: --
832: -- Check that the start reason exists in hr_lookups for the

Line 846: hr_utility.set_message(800, 'PER_52824_CTR_INV_START_REASON');

842: ,p_lookup_code => p_start_reason
843: )
844: then
845: --
846: hr_utility.set_message(800, 'PER_52824_CTR_INV_START_REASON');
847: hr_utility.raise_error;
848: --
849: end if;
850: hr_utility.set_location(l_proc, 50);

Line 847: hr_utility.raise_error;

843: )
844: then
845: --
846: hr_utility.set_message(800, 'PER_52824_CTR_INV_START_REASON');
847: hr_utility.raise_error;
848: --
849: end if;
850: hr_utility.set_location(l_proc, 50);
851: --

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

846: hr_utility.set_message(800, 'PER_52824_CTR_INV_START_REASON');
847: hr_utility.raise_error;
848: --
849: end if;
850: hr_utility.set_location(l_proc, 50);
851: --
852: end if;
853: hr_utility.set_location(l_proc, 60);
854: --

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

849: end if;
850: hr_utility.set_location(l_proc, 50);
851: --
852: end if;
853: hr_utility.set_location(l_proc, 60);
854: --
855: end if;
856: --
857: hr_utility.set_location(' Leaving:'|| l_proc, 70);

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

853: hr_utility.set_location(l_proc, 60);
854: --
855: end if;
856: --
857: hr_utility.set_location(' Leaving:'|| l_proc, 70);
858: --
859: end chk_start_reason;
860: --
861: -- ---------------------------------------------------------------------------

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

903: l_exists varchar2(1);
904: l_api_updating boolean;
905: --
906: begin
907: hr_utility.set_location('Entering:'|| l_proc, 10);
908: --
909: -- Check mandatory parameters have been set
910: --
911: hr_api.mandatory_arg_error

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

924: (p_api_name => l_proc
925: ,p_argument => 'validation_end_date'
926: ,p_argument_value => p_validation_end_date
927: );
928: hr_utility.set_location(l_proc, 20);
929: --
930: l_api_updating := per_ctc_shd.api_updating
931: (p_contract_id => p_contract_id
932: ,p_effective_date => p_effective_date

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

931: (p_contract_id => p_contract_id
932: ,p_effective_date => p_effective_date
933: ,p_object_version_number => p_object_version_number
934: );
935: hr_utility.set_location(l_proc, 30);
936: --
937: if ((l_api_updating and
938: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
939: nvl(p_end_reason, hr_api.g_varchar2))

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

938: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
939: nvl(p_end_reason, hr_api.g_varchar2))
940: or (NOT l_api_updating))
941: then
942: hr_utility.set_location(l_proc, 40);
943: --
944: if p_end_reason is not null then
945: --
946: -- Check that the end reason exists in hr_lookups for the

Line 960: hr_utility.set_message(800, 'PER_52825_CTR_INV_END_REASON');

956: ,p_lookup_code => p_end_reason
957: )
958: then
959: --
960: hr_utility.set_message(800, 'PER_52825_CTR_INV_END_REASON');
961: hr_utility.raise_error;
962: --
963: end if;
964: hr_utility.set_location(l_proc, 50);

Line 961: hr_utility.raise_error;

957: )
958: then
959: --
960: hr_utility.set_message(800, 'PER_52825_CTR_INV_END_REASON');
961: hr_utility.raise_error;
962: --
963: end if;
964: hr_utility.set_location(l_proc, 50);
965: --

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

960: hr_utility.set_message(800, 'PER_52825_CTR_INV_END_REASON');
961: hr_utility.raise_error;
962: --
963: end if;
964: hr_utility.set_location(l_proc, 50);
965: --
966: end if;
967: hr_utility.set_location(l_proc, 60);
968: --

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

963: end if;
964: hr_utility.set_location(l_proc, 50);
965: --
966: end if;
967: hr_utility.set_location(l_proc, 60);
968: --
969: end if;
970: --
971: hr_utility.set_location(' Leaving:'|| l_proc, 70);

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

967: hr_utility.set_location(l_proc, 60);
968: --
969: end if;
970: --
971: hr_utility.set_location(' Leaving:'|| l_proc, 70);
972: --
973: end chk_end_reason;
974: --
975: -- ---------------------------------------------------------------------------

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

1019: l_exists varchar2(1);
1020: l_api_updating boolean;
1021: --
1022: begin
1023: hr_utility.set_location('Entering:'|| l_proc, 10);
1024: --
1025: -- Check mandatory parameters have been set
1026: --
1027: hr_api.mandatory_arg_error

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

1040: (p_api_name => l_proc
1041: ,p_argument => 'validation_end_date'
1042: ,p_argument_value => p_validation_end_date
1043: );
1044: hr_utility.set_location(l_proc, 20);
1045: --
1046: l_api_updating := per_ctc_shd.api_updating
1047: (p_contract_id => p_contract_id
1048: ,p_effective_date => p_effective_date

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

1047: (p_contract_id => p_contract_id
1048: ,p_effective_date => p_effective_date
1049: ,p_object_version_number => p_object_version_number
1050: );
1051: hr_utility.set_location(l_proc, 30);
1052: --
1053: if ((l_api_updating and
1054: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
1055: nvl(p_extension_period_units, hr_api.g_varchar2))

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

1054: nvl(per_ctc_shd.g_old_rec.type, hr_api.g_varchar2) <>
1055: nvl(p_extension_period_units, hr_api.g_varchar2))
1056: or (NOT l_api_updating))
1057: then
1058: hr_utility.set_location(l_proc, 40);
1059: --
1060: if p_extension_period_units is not null then
1061: --
1062: if hr_api.not_exists_in_dt_hr_lookups

Line 1071: hr_utility.set_message(800, 'PER_52826_CTR_INV_EXTENSION_UN');

1067: ,p_lookup_code => p_extension_period_units
1068: )
1069: then
1070: --
1071: hr_utility.set_message(800, 'PER_52826_CTR_INV_EXTENSION_UN');
1072: hr_utility.raise_error;
1073: --
1074: end if;
1075: hr_utility.set_location(l_proc, 50);

Line 1072: hr_utility.raise_error;

1068: )
1069: then
1070: --
1071: hr_utility.set_message(800, 'PER_52826_CTR_INV_EXTENSION_UN');
1072: hr_utility.raise_error;
1073: --
1074: end if;
1075: hr_utility.set_location(l_proc, 50);
1076: --

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

1071: hr_utility.set_message(800, 'PER_52826_CTR_INV_EXTENSION_UN');
1072: hr_utility.raise_error;
1073: --
1074: end if;
1075: hr_utility.set_location(l_proc, 50);
1076: --
1077: -- Check that the extension exists when the extension units is not null
1078: --
1079: if p_extension_period is null then

Line 1080: hr_utility.set_message(800, 'PER_52844_CTR_INV_EXTENSION');

1076: --
1077: -- Check that the extension exists when the extension units is not null
1078: --
1079: if p_extension_period is null then
1080: hr_utility.set_message(800, 'PER_52844_CTR_INV_EXTENSION');
1081: hr_utility.raise_error;
1082: --
1083: end if;
1084: hr_utility.set_location(l_proc, 60);

Line 1081: hr_utility.raise_error;

1077: -- Check that the extension exists when the extension units is not null
1078: --
1079: if p_extension_period is null then
1080: hr_utility.set_message(800, 'PER_52844_CTR_INV_EXTENSION');
1081: hr_utility.raise_error;
1082: --
1083: end if;
1084: hr_utility.set_location(l_proc, 60);
1085: --

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

1080: hr_utility.set_message(800, 'PER_52844_CTR_INV_EXTENSION');
1081: hr_utility.raise_error;
1082: --
1083: end if;
1084: hr_utility.set_location(l_proc, 60);
1085: --
1086: else
1087: --
1088: -- Check that the extension doesn't exist when the extension units is null

Line 1091: hr_utility.set_message(800, 'PER_52844_CTR_INV_EXTENSION');

1087: --
1088: -- Check that the extension doesn't exist when the extension units is null
1089: --
1090: if p_extension_period is not null then
1091: hr_utility.set_message(800, 'PER_52844_CTR_INV_EXTENSION');
1092: hr_utility.raise_error;
1093: --
1094: end if;
1095: end if;

Line 1092: hr_utility.raise_error;

1088: -- Check that the extension doesn't exist when the extension units is null
1089: --
1090: if p_extension_period is not null then
1091: hr_utility.set_message(800, 'PER_52844_CTR_INV_EXTENSION');
1092: hr_utility.raise_error;
1093: --
1094: end if;
1095: end if;
1096: hr_utility.set_location(l_proc, 70);

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

1092: hr_utility.raise_error;
1093: --
1094: end if;
1095: end if;
1096: hr_utility.set_location(l_proc, 70);
1097: --
1098: end if;
1099: --
1100: hr_utility.set_location(' Leaving:'|| l_proc, 80);

Line 1100: hr_utility.set_location(' Leaving:'|| l_proc, 80);

1096: hr_utility.set_location(l_proc, 70);
1097: --
1098: end if;
1099: --
1100: hr_utility.set_location(' Leaving:'|| l_proc, 80);
1101: --
1102: end chk_extension_period_units;
1103: --
1104: -- ---------------------------------------------------------------------------

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

1135: l_dummy varchar2(1);
1136: --
1137: begin
1138: --
1139: hr_utility.set_location('Entering:'|| l_proc, 10);
1140: --
1141: open csr_assignment;
1142: fetch csr_assignment into l_dummy;
1143: if csr_assignment%found then

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

1182: --
1183: l_proc varchar2(72) := g_package||'chk_df';
1184: --
1185: begin
1186: hr_utility.set_location('Entering:'||l_proc, 10);
1187: --
1188: if ((p_rec.contract_id is NULL) and (
1189: nvl(per_ctc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1281: ,p_attribute20_value => p_rec.attribute20
1282: );
1283: end if;
1284: --
1285: hr_utility.set_location(' Leaving:'||l_proc, 20);
1286:
1287: end chk_df;
1288: --
1289: -- -----------------------------------------------------------------------

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

1323: l_proc varchar2(72) := g_package||'chk_ddf';
1324: l_error exception;
1325: --
1326: Begin
1327: hr_utility.set_location('Entering:'||l_proc, 5);
1328: --
1329: -- Check if the row is being inserted or updated and a
1330: -- value has changed
1331: --

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

1423: );
1424: --
1425: end if;
1426: --
1427: hr_utility.set_location(' Leaving:'||l_proc, 10);
1428: end chk_ddf;
1429: --
1430: -- -------------------------------------------------------------
1431: -- |-------------------< chk_del_mode>-------------------------|

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

1437: --
1438: l_proc varchar2(72) := g_package||'chk_del_mode';
1439: --
1440: begin
1441: hr_utility.set_location('Entering:'|| l_proc, 10);
1442: --
1443: -- Check that the datetrack mode is correct
1444: --
1445: if upper(p_datetrack_mode) = 'DELETE' then

Line 1446: hr_utility.set_message(800, 'PER_52842_CTR_DEL_MODE');

1442: --
1443: -- Check that the datetrack mode is correct
1444: --
1445: if upper(p_datetrack_mode) = 'DELETE' then
1446: hr_utility.set_message(800, 'PER_52842_CTR_DEL_MODE');
1447: hr_utility.raise_error;
1448: --
1449: end if;
1450: hr_utility.set_location(l_proc, 20);

Line 1447: hr_utility.raise_error;

1443: -- Check that the datetrack mode is correct
1444: --
1445: if upper(p_datetrack_mode) = 'DELETE' then
1446: hr_utility.set_message(800, 'PER_52842_CTR_DEL_MODE');
1447: hr_utility.raise_error;
1448: --
1449: end if;
1450: hr_utility.set_location(l_proc, 20);
1451: --

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

1446: hr_utility.set_message(800, 'PER_52842_CTR_DEL_MODE');
1447: hr_utility.raise_error;
1448: --
1449: end if;
1450: hr_utility.set_location(l_proc, 20);
1451: --
1452: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1453: --
1454: end chk_del_mode;

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

1448: --
1449: end if;
1450: hr_utility.set_location(l_proc, 20);
1451: --
1452: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1453: --
1454: end chk_del_mode;
1455: --
1456: -- ---------------------------------------------------------------------------

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

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

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

1490: -- call to this function. Just return the value in the global
1491: -- variable.
1492: --
1493: l_legislation_code := g_legislation_code;
1494: hr_utility.set_location(l_proc, 20);
1495: else
1496: --
1497: -- The ID is different to the last call to this function
1498: -- or this is the first call to this function.

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

1503: close csr_leg_code;
1504: --
1505: -- The primary key is invalid therefore we must error
1506: --
1507: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1508: hr_utility.raise_error;
1509: end if;
1510: --
1511: close csr_leg_code;

Line 1508: hr_utility.raise_error;

1504: --
1505: -- The primary key is invalid therefore we must error
1506: --
1507: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1508: hr_utility.raise_error;
1509: end if;
1510: --
1511: close csr_leg_code;
1512: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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

1508: hr_utility.raise_error;
1509: end if;
1510: --
1511: close csr_leg_code;
1512: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1513: --
1514: g_contract_id := p_contract_id;
1515: g_legislation_code := l_legislation_code;
1516: end if;

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

1513: --
1514: g_contract_id := p_contract_id;
1515: g_legislation_code := l_legislation_code;
1516: end if;
1517: hr_utility.set_location(' Leaving:'|| l_proc, 25);
1518: --
1519: return l_legislation_code;
1520: end return_legislation_code;
1521: --

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

1559: l_integrity_error Exception;
1560: l_table_name all_tables.table_name%TYPE;
1561: --
1562: Begin
1563: hr_utility.set_location('Entering:'||l_proc, 5);
1564: --
1565: -- Ensure that the p_datetrack_mode argument is not null
1566: --
1567: hr_api.mandatory_arg_error

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

1598: End If;
1599: --
1600: End If;
1601: --
1602: hr_utility.set_location(' Leaving:'||l_proc, 10);
1603: Exception
1604: When l_integrity_error Then
1605: --
1606: -- A referential integrity check was violated therefore

Line 1609: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

1605: --
1606: -- A referential integrity check was violated therefore
1607: -- we must error
1608: --
1609: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1610: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1611: hr_utility.raise_error;
1612: When Others Then
1613: --

Line 1610: hr_utility.set_message_token('TABLE_NAME', l_table_name);

1606: -- A referential integrity check was violated therefore
1607: -- we must error
1608: --
1609: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1610: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1611: hr_utility.raise_error;
1612: When Others Then
1613: --
1614: -- An unhandled or unexpected error has occurred which

Line 1611: hr_utility.raise_error;

1607: -- we must error
1608: --
1609: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1610: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1611: hr_utility.raise_error;
1612: When Others Then
1613: --
1614: -- An unhandled or unexpected error has occurred which
1615: -- we must report

Line 1617: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1613: --
1614: -- An unhandled or unexpected error has occurred which
1615: -- we must report
1616: --
1617: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE', l_proc);
1619: hr_utility.set_message_token('STEP','15');
1620: hr_utility.raise_error;
1621:

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

1614: -- An unhandled or unexpected error has occurred which
1615: -- we must report
1616: --
1617: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE', l_proc);
1619: hr_utility.set_message_token('STEP','15');
1620: hr_utility.raise_error;
1621:
1622: End dt_update_validate;

Line 1619: hr_utility.set_message_token('STEP','15');

1615: -- we must report
1616: --
1617: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE', l_proc);
1619: hr_utility.set_message_token('STEP','15');
1620: hr_utility.raise_error;
1621:
1622: End dt_update_validate;
1623: --

Line 1620: hr_utility.raise_error;

1616: --
1617: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1618: hr_utility.set_message_token('PROCEDURE', l_proc);
1619: hr_utility.set_message_token('STEP','15');
1620: hr_utility.raise_error;
1621:
1622: End dt_update_validate;
1623: --
1624: -- ----------------------------------------------------------------------------

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

1666: l_rows_exist Exception;
1667: l_table_name all_tables.table_name%TYPE;
1668: --
1669: Begin
1670: hr_utility.set_location('Entering:'||l_proc, 5);
1671: --
1672: -- Ensure that the p_datetrack_mode argument is not null
1673: --
1674: hr_api.mandatory_arg_error

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

1703: --
1704: --
1705: End If;
1706: --
1707: hr_utility.set_location(' Leaving:'||l_proc, 10);
1708: Exception
1709: When l_rows_exist Then
1710: --
1711: -- A referential integrity check was violated therefore

Line 1714: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');

1710: --
1711: -- A referential integrity check was violated therefore
1712: -- we must error
1713: --
1714: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1715: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1716: hr_utility.raise_error;
1717: When Others Then
1718: --

Line 1715: hr_utility.set_message_token('TABLE_NAME', l_table_name);

1711: -- A referential integrity check was violated therefore
1712: -- we must error
1713: --
1714: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1715: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1716: hr_utility.raise_error;
1717: When Others Then
1718: --
1719: -- An unhandled or unexpected error has occurred which

Line 1716: hr_utility.raise_error;

1712: -- we must error
1713: --
1714: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1715: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1716: hr_utility.raise_error;
1717: When Others Then
1718: --
1719: -- An unhandled or unexpected error has occurred which
1720: -- we must report

Line 1722: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1718: --
1719: -- An unhandled or unexpected error has occurred which
1720: -- we must report
1721: --
1722: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1723: hr_utility.set_message_token('PROCEDURE', l_proc);
1724: hr_utility.set_message_token('STEP','15');
1725: hr_utility.raise_error;
1726:

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

1719: -- An unhandled or unexpected error has occurred which
1720: -- we must report
1721: --
1722: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1723: hr_utility.set_message_token('PROCEDURE', l_proc);
1724: hr_utility.set_message_token('STEP','15');
1725: hr_utility.raise_error;
1726:
1727: End dt_delete_validate;

Line 1724: hr_utility.set_message_token('STEP','15');

1720: -- we must report
1721: --
1722: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1723: hr_utility.set_message_token('PROCEDURE', l_proc);
1724: hr_utility.set_message_token('STEP','15');
1725: hr_utility.raise_error;
1726:
1727: End dt_delete_validate;
1728: --

Line 1725: hr_utility.raise_error;

1721: --
1722: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1723: hr_utility.set_message_token('PROCEDURE', l_proc);
1724: hr_utility.set_message_token('STEP','15');
1725: hr_utility.raise_error;
1726:
1727: End dt_delete_validate;
1728: --
1729: -- ----------------------------------------------------------------------------

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

1739: l_proc varchar2(72) := g_package||'insert_validate';
1740: l_session_id number;
1741: --
1742: Begin
1743: hr_utility.set_location('Entering:'||l_proc, 5);
1744: --
1745: -- Call all supporting business operations
1746: --
1747: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 1749: hr_utility.set_location(l_proc, 7);

1745: -- Call all supporting business operations
1746: --
1747: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1748: --
1749: hr_utility.set_location(l_proc, 7);
1750: --
1751: -- Set the business group profile as this is used by the flexfield validation.
1752: --
1753: hr_kflex_utility.set_profiles

Line 1756: hr_utility.set_location(l_proc, 8);

1752: --
1753: hr_kflex_utility.set_profiles
1754: (p_business_group_id => p_rec.business_group_id);
1755: --
1756: hr_utility.set_location(l_proc, 8);
1757: --
1758: -- Set the session date as this is used by the flexfield validation.
1759: --
1760: hr_kflex_utility.set_session_date

Line 1764: hr_utility.set_location(l_proc, 10);

1760: hr_kflex_utility.set_session_date
1761: (p_effective_date => p_effective_date
1762: ,p_session_id => l_session_id);
1763: --
1764: hr_utility.set_location(l_proc, 10);
1765: --
1766: chk_person_id
1767: (p_rec.person_id,
1768: p_rec.business_group_id,

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

1767: (p_rec.person_id,
1768: p_rec.business_group_id,
1769: p_effective_date);
1770: --
1771: hr_utility.set_location(l_proc, 15);
1772: --
1773: chk_type
1774: (p_rec.contract_id,
1775: p_rec.type,

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

1778: p_validation_end_date,
1779: p_rec.object_version_number
1780: );
1781: --
1782: hr_utility.set_location(l_proc, 20);
1783: --
1784: chk_status
1785: (p_rec.contract_id,
1786: p_rec.status,

Line 1793: hr_utility.set_location(l_proc, 25);

1789: p_validation_end_date,
1790: p_rec.object_version_number
1791: );
1792: --
1793: hr_utility.set_location(l_proc, 25);
1794: --
1795: chk_status_reason
1796: (p_rec.contract_id,
1797: p_rec.status_reason,

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

1800: p_validation_end_date,
1801: p_rec.object_version_number
1802: );
1803: --
1804: hr_utility.set_location(l_proc, 30);
1805: --
1806: chk_duration_units
1807: (p_rec.contract_id,
1808: p_rec.duration,

Line 1816: hr_utility.set_location(l_proc, 35);

1812: p_validation_end_date,
1813: p_rec.object_version_number
1814: );
1815: --
1816: hr_utility.set_location(l_proc, 35);
1817: --
1818: chk_start_reason
1819: (p_rec.contract_id,
1820: p_rec.start_reason,

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

1823: p_validation_end_date,
1824: p_rec.object_version_number
1825: );
1826: --
1827: hr_utility.set_location(l_proc, 40);
1828: --
1829: chk_end_reason
1830: (p_rec.contract_id,
1831: p_rec.end_reason,

Line 1838: hr_utility.set_location(l_proc, 45);

1834: p_validation_end_date,
1835: p_rec.object_version_number
1836: );
1837: --
1838: hr_utility.set_location(l_proc, 45);
1839: --
1840: chk_extension_period_units
1841: (p_rec.contract_id,
1842: p_rec.extension_period,

Line 1850: hr_utility.set_location(l_proc, 47);

1846: p_validation_end_date,
1847: p_rec.object_version_number
1848: );
1849: --
1850: hr_utility.set_location(l_proc, 47);
1851: --
1852: chk_reference
1853: (p_rec.person_id
1854: ,p_rec.reference

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

1855: ,p_datetrack_mode
1856: ,null
1857: );
1858: --
1859: hr_utility.set_location(l_proc, 50);
1860: --
1861: per_ctc_bus.chk_ddf(p_rec => p_rec);
1862: --
1863: hr_utility.set_location(l_proc, 55);

Line 1863: hr_utility.set_location(l_proc, 55);

1859: hr_utility.set_location(l_proc, 50);
1860: --
1861: per_ctc_bus.chk_ddf(p_rec => p_rec);
1862: --
1863: hr_utility.set_location(l_proc, 55);
1864: --
1865: per_ctc_bus.chk_df(p_rec => p_rec);
1866: --
1867: hr_utility.set_location(l_proc, 57);

Line 1867: hr_utility.set_location(l_proc, 57);

1863: hr_utility.set_location(l_proc, 55);
1864: --
1865: per_ctc_bus.chk_df(p_rec => p_rec);
1866: --
1867: hr_utility.set_location(l_proc, 57);
1868: --
1869: -- Unset the session date.
1870: --
1871: hr_kflex_utility.unset_session_date

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

1870: --
1871: hr_kflex_utility.unset_session_date
1872: (p_session_id => l_session_id);
1873: --
1874: hr_utility.set_location(l_proc, 60);
1875: --
1876: End insert_validate;
1877: --
1878: -- ----------------------------------------------------------------------------

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

1888: l_proc varchar2(72) := g_package||'update_validate';
1889: l_session_id number;
1890: --
1891: Begin
1892: hr_utility.set_location('Entering:'||l_proc, 5);
1893: --
1894: -- Call all supporting business operations
1895: --
1896: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 1898: hr_utility.set_location(l_proc, 7);

1894: -- Call all supporting business operations
1895: --
1896: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1897: --
1898: hr_utility.set_location(l_proc, 7);
1899: --
1900: -- Set the business group profile as this is used by the flexfield validation.
1901: --
1902: hr_kflex_utility.set_profiles

Line 1905: hr_utility.set_location(l_proc, 8);

1901: --
1902: hr_kflex_utility.set_profiles
1903: (p_business_group_id => p_rec.business_group_id);
1904: --
1905: hr_utility.set_location(l_proc, 8);
1906: --
1907: -- Set the session date as this is used by the flexfield validation.
1908: --
1909: hr_kflex_utility.set_session_date

Line 1913: hr_utility.set_location(l_proc, 10);

1909: hr_kflex_utility.set_session_date
1910: (p_effective_date => p_effective_date
1911: ,p_session_id => l_session_id);
1912: --
1913: hr_utility.set_location(l_proc, 10);
1914: --
1915: chk_type
1916: (p_rec.contract_id,
1917: p_rec.type,

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

1920: p_validation_end_date,
1921: p_rec.object_version_number
1922: );
1923: --
1924: hr_utility.set_location(l_proc, 15);
1925: --
1926: chk_status
1927: (p_rec.contract_id,
1928: p_rec.status,

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

1931: p_validation_end_date,
1932: p_rec.object_version_number
1933: );
1934: --
1935: hr_utility.set_location(l_proc, 20);
1936: --
1937: chk_status_reason
1938: (p_rec.contract_id,
1939: p_rec.status_reason,

Line 1946: hr_utility.set_location(l_proc, 25);

1942: p_validation_end_date,
1943: p_rec.object_version_number
1944: );
1945: --
1946: hr_utility.set_location(l_proc, 25);
1947: --
1948: chk_duration_units
1949: (p_rec.contract_id,
1950: p_rec.duration,

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

1954: p_validation_end_date,
1955: p_rec.object_version_number
1956: );
1957: --
1958: hr_utility.set_location(l_proc, 30);
1959: --
1960: chk_start_reason
1961: (p_rec.contract_id,
1962: p_rec.start_reason,

Line 1969: hr_utility.set_location(l_proc, 35);

1965: p_validation_end_date,
1966: p_rec.object_version_number
1967: );
1968: --
1969: hr_utility.set_location(l_proc, 35);
1970: --
1971: chk_end_reason
1972: (p_rec.contract_id,
1973: p_rec.end_reason,

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

1976: p_validation_end_date,
1977: p_rec.object_version_number
1978: );
1979: --
1980: hr_utility.set_location(l_proc, 40);
1981: --
1982: chk_extension_period_units
1983: (p_rec.contract_id,
1984: p_rec.extension_period,

Line 1992: hr_utility.set_location(l_proc, 42);

1988: p_validation_end_date,
1989: p_rec.object_version_number
1990: );
1991: --
1992: hr_utility.set_location(l_proc, 42);
1993: --
1994: chk_reference
1995: (p_rec.person_id
1996: ,p_rec.reference

Line 2001: hr_utility.set_location(l_proc, 45);

1997: ,p_datetrack_mode
1998: ,p_rec.contract_id
1999: );
2000: --
2001: hr_utility.set_location(l_proc, 45);
2002: --
2003: -- Call the datetrack update integrity operation
2004: --
2005: dt_update_validate

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

2007: p_datetrack_mode => p_datetrack_mode,
2008: p_validation_start_date => p_validation_start_date,
2009: p_validation_end_date => p_validation_end_date);
2010: --
2011: hr_utility.set_location(l_proc, 50);
2012: --
2013: per_ctc_bus.chk_ddf(p_rec => p_rec);
2014: --
2015: hr_utility.set_location(l_proc, 55);

Line 2015: hr_utility.set_location(l_proc, 55);

2011: hr_utility.set_location(l_proc, 50);
2012: --
2013: per_ctc_bus.chk_ddf(p_rec => p_rec);
2014: --
2015: hr_utility.set_location(l_proc, 55);
2016: --
2017: per_ctc_bus.chk_df(p_rec => p_rec);
2018: --
2019: hr_utility.set_location(l_proc, 57);

Line 2019: hr_utility.set_location(l_proc, 57);

2015: hr_utility.set_location(l_proc, 55);
2016: --
2017: per_ctc_bus.chk_df(p_rec => p_rec);
2018: --
2019: hr_utility.set_location(l_proc, 57);
2020: --
2021: -- Unset the session date.
2022: --
2023: hr_kflex_utility.unset_session_date

Line 2026: hr_utility.set_location(' Leaving:'||l_proc, 60);

2022: --
2023: hr_kflex_utility.unset_session_date
2024: (p_session_id => l_session_id);
2025: --
2026: hr_utility.set_location(' Leaving:'||l_proc, 60);
2027: --
2028: End update_validate;
2029: --
2030: -- ----------------------------------------------------------------------------

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

2039: --
2040: l_proc varchar2(72) := g_package||'delete_validate';
2041: --
2042: Begin
2043: hr_utility.set_location('Entering:'||l_proc, 5);
2044: --
2045: -- Call all supporting business operations
2046: --
2047: dt_delete_validate

Line 2053: hr_utility.set_location(l_proc, 10);

2049: p_validation_start_date => p_validation_start_date,
2050: p_validation_end_date => p_validation_end_date,
2051: p_contract_id => p_rec.contract_id);
2052: --
2053: hr_utility.set_location(l_proc, 10);
2054: --
2055: chk_del_mode
2056: (p_datetrack_mode => p_datetrack_mode) ;
2057: --

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

2054: --
2055: chk_del_mode
2056: (p_datetrack_mode => p_datetrack_mode) ;
2057: --
2058: hr_utility.set_location(l_proc, 15);
2059: --
2060: if chk_assignment_exists (p_contract_id => p_rec.contract_id) then
2061: hr_utility.set_message(800, 'PER_52841_CTR_DEL_ASG');
2062: hr_utility.raise_error;

Line 2061: hr_utility.set_message(800, 'PER_52841_CTR_DEL_ASG');

2057: --
2058: hr_utility.set_location(l_proc, 15);
2059: --
2060: if chk_assignment_exists (p_contract_id => p_rec.contract_id) then
2061: hr_utility.set_message(800, 'PER_52841_CTR_DEL_ASG');
2062: hr_utility.raise_error;
2063: end if;
2064: hr_utility.set_location(' Leaving:'||l_proc, 20);
2065:

Line 2062: hr_utility.raise_error;

2058: hr_utility.set_location(l_proc, 15);
2059: --
2060: if chk_assignment_exists (p_contract_id => p_rec.contract_id) then
2061: hr_utility.set_message(800, 'PER_52841_CTR_DEL_ASG');
2062: hr_utility.raise_error;
2063: end if;
2064: hr_utility.set_location(' Leaving:'||l_proc, 20);
2065:
2066: End delete_validate;

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

2060: if chk_assignment_exists (p_contract_id => p_rec.contract_id) then
2061: hr_utility.set_message(800, 'PER_52841_CTR_DEL_ASG');
2062: hr_utility.raise_error;
2063: end if;
2064: hr_utility.set_location(' Leaving:'||l_proc, 20);
2065:
2066: End delete_validate;
2067: --
2068: end per_ctc_bus;