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 1288: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

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

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

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

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

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

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

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

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

Line 1450: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

Line 1511: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1614: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 1623: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 1719: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 1728: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

1781: p_validation_end_date,
1782: p_rec.object_version_number
1783: );
1784: --
1785: hr_utility.set_location(l_proc, 20);
1786: --
1787: chk_status
1788: (p_rec.contract_id,
1789: p_rec.status,

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

1792: p_validation_end_date,
1793: p_rec.object_version_number
1794: );
1795: --
1796: hr_utility.set_location(l_proc, 25);
1797: --
1798: chk_status_reason
1799: (p_rec.contract_id,
1800: p_rec.status_reason,

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

1803: p_validation_end_date,
1804: p_rec.object_version_number
1805: );
1806: --
1807: hr_utility.set_location(l_proc, 30);
1808: --
1809: chk_duration_units
1810: (p_rec.contract_id,
1811: p_rec.duration,

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

1815: p_validation_end_date,
1816: p_rec.object_version_number
1817: );
1818: --
1819: hr_utility.set_location(l_proc, 35);
1820: --
1821: chk_start_reason
1822: (p_rec.contract_id,
1823: p_rec.start_reason,

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

1826: p_validation_end_date,
1827: p_rec.object_version_number
1828: );
1829: --
1830: hr_utility.set_location(l_proc, 40);
1831: --
1832: chk_end_reason
1833: (p_rec.contract_id,
1834: p_rec.end_reason,

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

1837: p_validation_end_date,
1838: p_rec.object_version_number
1839: );
1840: --
1841: hr_utility.set_location(l_proc, 45);
1842: --
1843: chk_extension_period_units
1844: (p_rec.contract_id,
1845: p_rec.extension_period,

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

1849: p_validation_end_date,
1850: p_rec.object_version_number
1851: );
1852: --
1853: hr_utility.set_location(l_proc, 47);
1854: --
1855: chk_reference
1856: (p_rec.person_id
1857: ,p_rec.reference

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1923: p_validation_end_date,
1924: p_rec.object_version_number
1925: );
1926: --
1927: hr_utility.set_location(l_proc, 15);
1928: --
1929: chk_status
1930: (p_rec.contract_id,
1931: p_rec.status,

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

1934: p_validation_end_date,
1935: p_rec.object_version_number
1936: );
1937: --
1938: hr_utility.set_location(l_proc, 20);
1939: --
1940: chk_status_reason
1941: (p_rec.contract_id,
1942: p_rec.status_reason,

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

1945: p_validation_end_date,
1946: p_rec.object_version_number
1947: );
1948: --
1949: hr_utility.set_location(l_proc, 25);
1950: --
1951: chk_duration_units
1952: (p_rec.contract_id,
1953: p_rec.duration,

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

1957: p_validation_end_date,
1958: p_rec.object_version_number
1959: );
1960: --
1961: hr_utility.set_location(l_proc, 30);
1962: --
1963: chk_start_reason
1964: (p_rec.contract_id,
1965: p_rec.start_reason,

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

1968: p_validation_end_date,
1969: p_rec.object_version_number
1970: );
1971: --
1972: hr_utility.set_location(l_proc, 35);
1973: --
1974: chk_end_reason
1975: (p_rec.contract_id,
1976: p_rec.end_reason,

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

1979: p_validation_end_date,
1980: p_rec.object_version_number
1981: );
1982: --
1983: hr_utility.set_location(l_proc, 40);
1984: --
1985: chk_extension_period_units
1986: (p_rec.contract_id,
1987: p_rec.extension_period,

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

1991: p_validation_end_date,
1992: p_rec.object_version_number
1993: );
1994: --
1995: hr_utility.set_location(l_proc, 42);
1996: --
1997: chk_reference
1998: (p_rec.person_id
1999: ,p_rec.reference

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2065: hr_utility.raise_error;

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

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

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