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

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

27: l_period_years number; -- Don't change the datatype
28: l_start_date per_previous_employers.start_date%type;
29: l_end_date per_previous_employers.end_date%type;
30: begin
31: hr_utility.set_location('Entering:'||l_proc, 5);
32: --
33: -- Truncate all date datatypes
34: l_start_date := trunc(p_start_date);
35: l_end_date := trunc(p_end_date+1);

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

34: l_start_date := trunc(p_start_date);
35: l_end_date := trunc(p_end_date+1);
36: --
37: if l_start_date is not null and l_end_date is not null then
38: hr_utility.set_location(l_proc, 10);
39: l_period_years := trunc(trunc(months_between(l_end_date,l_start_date))/12);
40: if l_period_years between 0 and 99 then
41: hr_utility.set_location(l_proc, 15);
42: p_period_years := trunc(trunc(months_between(l_end_date

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

37: if l_start_date is not null and l_end_date is not null then
38: hr_utility.set_location(l_proc, 10);
39: l_period_years := trunc(trunc(months_between(l_end_date,l_start_date))/12);
40: if l_period_years between 0 and 99 then
41: hr_utility.set_location(l_proc, 15);
42: p_period_years := trunc(trunc(months_between(l_end_date
43: ,l_start_date))/12);
44: hr_utility.set_location(l_proc, 20);
45: p_period_months:= mod(trunc(months_between(l_end_date

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

40: if l_period_years between 0 and 99 then
41: hr_utility.set_location(l_proc, 15);
42: p_period_years := trunc(trunc(months_between(l_end_date
43: ,l_start_date))/12);
44: hr_utility.set_location(l_proc, 20);
45: p_period_months:= mod(trunc(months_between(l_end_date
46: ,l_start_date)),12);
47: hr_utility.set_location(l_proc, 25);
48: --

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

43: ,l_start_date))/12);
44: hr_utility.set_location(l_proc, 20);
45: p_period_months:= mod(trunc(months_between(l_end_date
46: ,l_start_date)),12);
47: hr_utility.set_location(l_proc, 25);
48: --
49: -- 3635308: Added the if - else condition.
50: --
51: -- 3635308 start here

Line 58: hr_utility.set_location(l_proc, 26);

54: p_period_days := trunc(l_end_date
55: - add_months(l_start_date
56: ,trunc(months_between(l_end_date
57: ,l_start_date))));
58: hr_utility.set_location(l_proc, 26);
59: else
60: p_period_days := trunc(l_end_date
61: - add_months(l_start_date
62: ,trunc(months_between(l_end_date

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

62: ,trunc(months_between(l_end_date
63: ,l_start_date)-1)));
64: p_period_months := p_period_months - 1;
65:
66: hr_utility.set_location(l_proc, 28);
67: end if;
68: --
69: -- 3635308 end here
70: --

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

67: end if;
68: --
69: -- 3635308 end here
70: --
71: hr_utility.set_location(l_proc, 30);
72: else
73: /*Error message changed for the bug 5686794*/
74: hr_utility.set_location(l_proc, 35);
75: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');

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

70: --
71: hr_utility.set_location(l_proc, 30);
72: else
73: /*Error message changed for the bug 5686794*/
74: hr_utility.set_location(l_proc, 35);
75: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
76: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
77: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
78: fnd_message.raise_error;

Line 80: /*hr_utility.set_location(l_proc, 35);

76: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
77: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
78: fnd_message.raise_error;
79:
80: /*hr_utility.set_location(l_proc, 35);
81: fnd_message.set_name('PER','HR_289552_NOVALD_DATES_DIFF');
82: fnd_message.raise_error;*/-- Error msg changed & Commented for bug 5686794
83:
84: end if;

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

83:
84: end if;
85: end if;
86: --
87: hr_utility.set_location('Leaving:'||l_proc, 40);
88: end get_period_values;
89: --
90: -- ---------------------------------------------------------------------------
91: -- |----------------------< set_security_group_id >--------------------------|

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

111: l_proc varchar2(72) := g_package||'set_security_group_id';
112: --
113: begin
114: --
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116: --
117: -- Ensure that all the mandatory parameter are not null
118: --
119: hr_api.mandatory_arg_error

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

144: (p_security_group_id => l_security_group_id
145: );
146: end if;
147: --
148: hr_utility.set_location(' Leaving:'|| l_proc, 20);
149: --
150: end set_security_group_id;
151: --
152: -- ---------------------------------------------------------------------------

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

173: l_proc varchar2(72) := g_package||'return_legislation_code';
174: --
175: Begin
176: --
177: hr_utility.set_location('Entering:'|| l_proc, 10);
178: --
179: -- Ensure that all the mandatory parameter are not null
180: --
181: hr_api.mandatory_arg_error

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

191: -- call to this function. Just return the value in the global
192: -- variable.
193: --
194: l_legislation_code := per_pem_bus.g_legislation_code;
195: hr_utility.set_location(l_proc, 20);
196: else
197: --
198: -- The ID is different to the last call to this function
199: -- or this is the first call to this function.

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

208: close csr_leg_code;
209: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
210: fnd_message.raise_error;
211: end if;
212: hr_utility.set_location(l_proc,30);
213: --
214: -- Set the global variables so the values are
215: -- available for the next call to this function.
216: --

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

217: close csr_leg_code;
218: per_pem_bus.g_previous_employer_id := p_previous_employer_id;
219: per_pem_bus.g_legislation_code := l_legislation_code;
220: end if;
221: hr_utility.set_location(' Leaving:'|| l_proc, 40);
222: return l_legislation_code;
223: end return_legislation_code;
224: --
225: -- ----------------------------------------------------------------------------

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

256: --
257: l_proc varchar2(72) := g_package || 'chk_ddf';
258: --
259: begin
260: hr_utility.set_location('Entering:'||l_proc,10);
261: --
262: if ((p_rec.previous_employer_id is not null) and (
263: nvl(per_pem_shd.g_old_rec.pem_information_category, hr_api.g_varchar2) <>
264: nvl(p_rec.pem_information_category, hr_api.g_varchar2) or

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

395: ,p_attribute30_value => p_rec.pem_information30
396: );
397: end if;
398: --
399: hr_utility.set_location(' Leaving:'||l_proc,20);
400: end chk_ddf;
401: --
402: -- ----------------------------------------------------------------------------
403: -- |------------------------------< chk_df >----------------------------------|

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

433: --
434: l_proc varchar2(72) := g_package || 'chk_df';
435: --
436: begin
437: hr_utility.set_location('Entering:'||l_proc,10);
438: --
439: if ((p_rec.previous_employer_id is not null) and (
440: nvl(per_pem_shd.g_old_rec.pem_attribute_category, hr_api.g_varchar2) <>
441: nvl(p_rec.pem_attribute_category, hr_api.g_varchar2) or

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

572: ,p_attribute30_value => p_rec.pem_attribute30
573: );
574: end if;
575: --
576: hr_utility.set_location(' Leaving:'||l_proc,20);
577: end chk_df;
578: --
579: -- ----------------------------------------------------------------------------
580: -- |-----------------------< chk_non_updateable_args >------------------------|

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

610: --
611: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
612: --
613: Begin
614: hr_utility.set_location('Entering : '||l_proc,5);
615: --
616: -- Only proceed with the validation if a row exists for the current
617: -- record in the HR Schema.
618: --

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

627: END IF;
628: --
629: -- Add checks to ensure non-updateable args have
630: -- not been updated.
631: hr_utility.set_location(l_proc,10);
632: if per_pem_shd.g_old_rec.previous_employer_id <> p_rec.previous_employer_id
633: then
634: hr_api.argument_changed_error
635: (p_api_name => l_proc

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

637: ,p_base_table => per_pem_shd.g_tab_nam
638: );
639: end if;
640: --
641: hr_utility.set_location(l_proc,15);
642: if per_pem_shd.g_old_rec.person_id <> p_rec.person_id
643: then
644: hr_api.argument_changed_error
645: (p_api_name => l_proc

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

647: ,p_base_table => per_pem_shd.g_tab_nam
648: );
649: end if;
650: --
651: hr_utility.set_location(l_proc,20);
652: if nvl(per_pem_shd.g_old_rec.party_id,p_rec.party_id) <>
653: nvl(p_rec.party_id,per_pem_shd.g_old_rec.party_id)
654: then
655: hr_api.argument_changed_error

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

657: ,p_argument => 'party_id'
658: ,p_base_table => per_pem_shd.g_tab_nam
659: );
660: end if;
661: hr_utility.set_location(l_proc,25);
662: --
663: -- start commented code for business_group_id is
664: -- updateable if previously null.
665: --

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

676: */
677: --
678: -- end commented code
679: --
680: hr_utility.set_location('Leaving : '||l_proc,30);
681: End chk_non_updateable_args;
682: --
683: -- ----------------------------------------------------------------------------
684: -- |----------------------------< chk_person_id >-----------------------------|

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

736: l_proc varchar2(72) := g_package||'chk_person_id';
737: l_api_updating boolean;
738: --
739: begin
740: hr_utility.set_location('Entering:'||l_proc, 5);
741: if p_person_id is not null then
742: hr_utility.set_location(l_proc, 10);
743: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
744: => p_previous_employer_id

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

738: --
739: begin
740: hr_utility.set_location('Entering:'||l_proc, 5);
741: if p_person_id is not null then
742: hr_utility.set_location(l_proc, 10);
743: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
744: => p_previous_employer_id
745: ,p_object_version_number
746: => p_object_version_number

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

751: or
752: (not l_api_updating))
753: then
754: -- Check for invalid person_id
755: hr_utility.set_location(l_proc, 15);
756: open csr_person_id;
757: fetch csr_person_id into l_person_id;
758: if csr_person_id%notfound then
759: hr_utility.set_location(l_proc, 20);

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

755: hr_utility.set_location(l_proc, 15);
756: open csr_person_id;
757: fetch csr_person_id into l_person_id;
758: if csr_person_id%notfound then
759: hr_utility.set_location(l_proc, 20);
760: close csr_person_id;
761: fnd_message.set_name('PER','HR_289535_PEM_VALID_PERSON_ID');
762: fnd_message.raise_error;
763: end if;

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

764: if csr_person_id%isopen then
765: close csr_person_id;
766: end if;
767: -- Check for person_id with effective dates
768: hr_utility.set_location(l_proc, 25);
769: open csr_effective_person_id;
770: fetch csr_effective_person_id into l_person_id;
771: if csr_effective_person_id%notfound then
772: hr_utility.set_location(l_proc, 30);

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

768: hr_utility.set_location(l_proc, 25);
769: open csr_effective_person_id;
770: fetch csr_effective_person_id into l_person_id;
771: if csr_effective_person_id%notfound then
772: hr_utility.set_location(l_proc, 30);
773: close csr_effective_person_id;
774: fnd_message.set_name('PER','HR_289547_PEM_DATE_PERSON_ID');
775: fnd_message.raise_error;
776: end if;

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

779: end if;
780: --
781: end if;
782: end if;
783: hr_utility.set_location('Leaving:'||l_proc, 40);
784: exception
785: when app_exception.application_exception then
786: if hr_multi_message.exception_add
787: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERSON_ID'

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

785: when app_exception.application_exception then
786: if hr_multi_message.exception_add
787: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERSON_ID'
788: ) then
789: hr_utility.set_location('Leaving:'||l_proc, 50);
790: raise;
791: end if;
792: hr_utility.set_location('Leaving:'||l_proc,60);
793: end chk_person_id;

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

788: ) then
789: hr_utility.set_location('Leaving:'||l_proc, 50);
790: raise;
791: end if;
792: hr_utility.set_location('Leaving:'||l_proc,60);
793: end chk_person_id;
794: --
795: -- ----------------------------------------------------------------------------
796: -- |-----------------------------< chk_party_id >-----------------------------|

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

832: --
833: l_proc varchar2(72) := g_package||'chk_party_id';
834: l_api_updating boolean;
835: begin
836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: if p_party_id is not null then
839: hr_utility.set_location(l_proc, 10);
840: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

835: begin
836: hr_utility.set_location('Entering:'||l_proc, 5);
837: --
838: if p_party_id is not null then
839: hr_utility.set_location(l_proc, 10);
840: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
841: => p_previous_employer_id
842: ,p_object_version_number
843: => p_object_version_number

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

847: <> nvl(p_party_id,hr_api.g_number))
848: or
849: (not l_api_updating))
850: then
851: hr_utility.set_location(l_proc, 15);
852: open csr_party_id;
853: fetch csr_party_id into l_party_id;
854: if csr_party_id%notfound then
855: hr_utility.set_location(l_proc, 20);

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

851: hr_utility.set_location(l_proc, 15);
852: open csr_party_id;
853: fetch csr_party_id into l_party_id;
854: if csr_party_id%notfound then
855: hr_utility.set_location(l_proc, 20);
856: close csr_party_id;
857: fnd_message.set_name('PER','HR_289536_PEM_VALID_PARTY_ID');
858: fnd_message.raise_error;
859: end if;

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

862: end if;
863: end if;
864: end if;
865: --
866: hr_utility.set_location('Leaving:'||l_proc, 25);
867: exception
868: when app_exception.application_exception then
869: if hr_multi_message.exception_add
870: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PARTY_ID'

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

868: when app_exception.application_exception then
869: if hr_multi_message.exception_add
870: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PARTY_ID'
871: ) then
872: hr_utility.set_location('Leaving:'||l_proc,30);
873: raise;
874: end if;
875: hr_utility.set_location('Leaving:'||l_proc,40);
876: end chk_party_id;

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

871: ) then
872: hr_utility.set_location('Leaving:'||l_proc,30);
873: raise;
874: end if;
875: hr_utility.set_location('Leaving:'||l_proc,40);
876: end chk_party_id;
877: --
878: -- ----------------------------------------------------------------------------
879: -- |-------------------------< chk_employer_country >-------------------------|

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

916: --
917: l_proc varchar2(72) := g_package||'chk_employer_country';
918: l_api_updating boolean;
919: begin
920: hr_utility.set_location('Entering:'||l_proc, 5);
921: --
922: if p_employer_country is not null then
923: hr_utility.set_location(l_proc, 10);
924: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

919: begin
920: hr_utility.set_location('Entering:'||l_proc, 5);
921: --
922: if p_employer_country is not null then
923: hr_utility.set_location(l_proc, 10);
924: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
925: => p_previous_employer_id
926: ,p_object_version_number
927: => p_object_version_number

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

931: <> nvl(p_employer_country,hr_api.g_varchar2))
932: or
933: (not l_api_updating))
934: then
935: hr_utility.set_location(l_proc, 15);
936: open csr_employer_country;
937: fetch csr_employer_country into l_employer_country;
938: if csr_employer_country%notfound then
939: hr_utility.set_location(l_proc, 20);

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

935: hr_utility.set_location(l_proc, 15);
936: open csr_employer_country;
937: fetch csr_employer_country into l_employer_country;
938: if csr_employer_country%notfound then
939: hr_utility.set_location(l_proc, 20);
940: close csr_employer_country;
941: fnd_message.set_name('PER','HR_289531_PEM_VALD_EMPR_CNTRY');
942: fnd_message.raise_error;
943: end if;

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

946: end if;
947: end if;
948: end if;
949: --
950: hr_utility.set_location('Leaving:'||l_proc, 25);
951: exception
952: when app_exception.application_exception then
953: if hr_multi_message.exception_add
954: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_COUNTRY'

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

952: when app_exception.application_exception then
953: if hr_multi_message.exception_add
954: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_COUNTRY'
955: ) then
956: hr_utility.set_location('Leaving:'||l_proc, 30);
957: raise;
958: end if;
959: hr_utility.set_location('Leaving:'||l_proc,40);
960: end chk_employer_country;

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

955: ) then
956: hr_utility.set_location('Leaving:'||l_proc, 30);
957: raise;
958: end if;
959: hr_utility.set_location('Leaving:'||l_proc,40);
960: end chk_employer_country;
961: --
962: -- ----------------------------------------------------------------------------
963: -- |--------------------------< chk_employer_type >---------------------------|

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

1000: l_lookup_code per_previous_employers.employer_type%type
1001: := p_employer_type;
1002: l_api_updating boolean;
1003: begin
1004: hr_utility.set_location('Entering:'||l_proc, 5);
1005: --
1006: if p_employer_type is not null then
1007: hr_utility.set_location(l_proc, 10);
1008: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

1003: begin
1004: hr_utility.set_location('Entering:'||l_proc, 5);
1005: --
1006: if p_employer_type is not null then
1007: hr_utility.set_location(l_proc, 10);
1008: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1009: => p_previous_employer_id
1010: ,p_object_version_number
1011: => p_object_version_number

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

1014: nvl(p_employer_type,hr_api.g_varchar2)
1015: <> nvl(per_pem_shd.g_old_rec.employer_type, hr_api.g_varchar2))
1016: or
1017: (not l_api_updating)) then
1018: hr_utility.set_location(l_proc, 15);
1019: l_no_lookup := hr_api.not_exists_in_leg_lookups
1020: (p_effective_date => l_effective_date
1021: ,p_lookup_type => l_lookup_type
1022: ,p_lookup_code => l_lookup_code

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

1021: ,p_lookup_type => l_lookup_type
1022: ,p_lookup_code => l_lookup_code
1023: );
1024: if l_no_lookup = true then
1025: hr_utility.set_location(l_proc, 20);
1026: fnd_message.set_name('PER','HR_289532_PEM_VALID_EMPR_TYPE');
1027: fnd_message.raise_error;
1028: end if;
1029: end if;

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

1028: end if;
1029: end if;
1030: end if;
1031: --
1032: hr_utility.set_location('Leaving:'||l_proc, 25);
1033: exception
1034: when app_exception.application_exception then
1035: if hr_multi_message.exception_add
1036: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'

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

1034: when app_exception.application_exception then
1035: if hr_multi_message.exception_add
1036: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'
1037: ) then
1038: hr_utility.set_location('Leaving:'||l_proc, 30);
1039: raise;
1040: end if;
1041: hr_utility.set_location('Leaving:'||l_proc,40);
1042: end chk_employer_type;

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

1037: ) then
1038: hr_utility.set_location('Leaving:'||l_proc, 30);
1039: raise;
1040: end if;
1041: hr_utility.set_location('Leaving:'||l_proc,40);
1042: end chk_employer_type;
1043: --
1044: -- ----------------------------------------------------------------------------
1045: -- |-------------------------< chk_employer_subtype >-------------------------|

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

1094: l_employer_subtype hr_leg_lookups.lookup_code%type;
1095: --
1096: l_api_updating boolean;
1097: begin
1098: hr_utility.set_location('Entering:'||l_proc, 5);
1099: --
1100: --Only proceed with employer_subtype validation when multiple message list
1101: --does not already contain an error associated with employer type column.
1102: --

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

1103: if hr_multi_message.no_exclusive_error
1104: (p_check_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'
1105: ) then
1106: if p_employer_subtype is not null then
1107: hr_utility.set_location(l_proc, 10);
1108: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1109: => p_previous_employer_id
1110: ,p_object_version_number
1111: => p_object_version_number

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

1115: <> nvl(per_pem_shd.g_old_rec.employer_subtype
1116: , hr_api.g_varchar2))
1117: or
1118: (not l_api_updating)) then
1119: hr_utility.set_location(l_proc, 15);
1120: -- Check for standard lookup
1121: l_no_lookup := hr_api.not_exists_in_leg_lookups
1122: (p_effective_date => l_effective_date
1123: ,p_lookup_type => l_lookup_type

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

1123: ,p_lookup_type => l_lookup_type
1124: ,p_lookup_code => l_lookup_code
1125: );
1126: if l_no_lookup = true then
1127: hr_utility.set_location(l_proc, 20);
1128: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');
1129: fnd_message.raise_error;
1130: end if;
1131: -- Check for the dependency on employer type

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

1128: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');
1129: fnd_message.raise_error;
1130: end if;
1131: -- Check for the dependency on employer type
1132: hr_utility.set_location(l_proc, 25);
1133: open csr_employer_subtype;
1134: fetch csr_employer_subtype into l_employer_subtype;
1135: if csr_employer_subtype%notfound then
1136: hr_utility.set_location(l_proc, 30);

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

1132: hr_utility.set_location(l_proc, 25);
1133: open csr_employer_subtype;
1134: fetch csr_employer_subtype into l_employer_subtype;
1135: if csr_employer_subtype%notfound then
1136: hr_utility.set_location(l_proc, 30);
1137: close csr_employer_subtype;
1138: fnd_message.set_name('PER','HR_289533_PEM_VALID_EMPR_SBTP');
1139: fnd_message.raise_error;
1140: end if;

Line 1148: hr_utility.set_location('Leaving:'||l_proc, 35);

1144: end if;
1145: end if;
1146: end if;
1147: --
1148: hr_utility.set_location('Leaving:'||l_proc, 35);
1149: exception
1150: when app_exception.application_exception then
1151: if hr_multi_message.exception_add
1152: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'

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

1151: if hr_multi_message.exception_add
1152: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_TYPE'
1153: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.EMPLOYER_SUBTYPE'
1154: ) then
1155: hr_utility.set_location('Leaving:'||l_proc, 40);
1156: raise;
1157: end if;
1158: hr_utility.set_location('Leaving:'||l_proc,50);
1159: end chk_employer_subtype;

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

1154: ) then
1155: hr_utility.set_location('Leaving:'||l_proc, 40);
1156: raise;
1157: end if;
1158: hr_utility.set_location('Leaving:'||l_proc,50);
1159: end chk_employer_subtype;
1160: --
1161: -- -----------------------------------------------------------------------
1162: -- |---------------------------< chk_start_end_dates >-------------------|

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

1197: IN per_previous_employers.start_date%type) is
1198: l_proc varchar2(72) := g_package||'chk_start_end_dates';
1199: l_api_updating boolean;
1200: begin
1201: hr_utility.set_location('Entering:'||l_proc, 5);
1202: --
1203: -- This If condition added for bug 7112425
1204:
1205: IF p_start_date is not null AND p_start_date > p_effective_date THEN

Line 1209: hr_utility.set_location('Entering:'||l_proc, 6);

1205: IF p_start_date is not null AND p_start_date > p_effective_date THEN
1206: fnd_message.set_name('PER','HR_INVAL_ST_DT_PEM');
1207: fnd_message.raise_error;
1208: END IF ;
1209: hr_utility.set_location('Entering:'||l_proc, 6);
1210:
1211: if p_start_date is not null and p_end_date is not null then
1212: hr_utility.set_location(l_proc, 10);
1213: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

1208: END IF ;
1209: hr_utility.set_location('Entering:'||l_proc, 6);
1210:
1211: if p_start_date is not null and p_end_date is not null then
1212: hr_utility.set_location(l_proc, 10);
1213: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1214: => p_previous_employer_id
1215: ,p_object_version_number
1216: => p_object_version_number

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

1223: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1224: ))
1225: or
1226: (not l_api_updating)) then
1227: hr_utility.set_location(l_proc, 15);
1228: if p_start_date > p_end_date then
1229: hr_utility.set_location(l_proc, 20);
1230: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1231: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);

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

1225: or
1226: (not l_api_updating)) then
1227: hr_utility.set_location(l_proc, 15);
1228: if p_start_date > p_end_date then
1229: hr_utility.set_location(l_proc, 20);
1230: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1231: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1232: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1233: fnd_message.raise_error;

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

1234: end if;
1235: end if;
1236: end if;
1237: --
1238: hr_utility.set_location('Leaving:'||l_proc, 25);
1239: /*exception
1240: when app_exception.application_exception then
1241: if hr_multi_message.exception_add
1242: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'

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

1241: if hr_multi_message.exception_add
1242: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'
1243: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.END_DATE'
1244: ) then
1245: hr_utility.set_location('Leaving:'||l_proc, 30);
1246: raise;
1247: end if;
1248: hr_utility.set_location('Leaving:'||l_proc,40);*/--commented for the bug 5686794
1249: end chk_start_end_dates;

Line 1248: hr_utility.set_location('Leaving:'||l_proc,40);*/--commented for the bug 5686794

1244: ) then
1245: hr_utility.set_location('Leaving:'||l_proc, 30);
1246: raise;
1247: end if;
1248: hr_utility.set_location('Leaving:'||l_proc,40);*/--commented for the bug 5686794
1249: end chk_start_end_dates;
1250: --
1251: -- -----------------------------------------------------------------------
1252: -- |---------------------------< chk_period_years >----------------------|

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

1283: in per_previous_employers.object_version_number%type) is
1284: l_proc varchar2(72) := g_package||'chk_period_years';
1285: l_api_updating boolean;
1286: begin
1287: hr_utility.set_location('Entering:'||l_proc, 5);
1288: --
1289: if p_period_years is not null then
1290: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1291: => p_previous_employer_id

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

1290: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1291: => p_previous_employer_id
1292: ,p_object_version_number
1293: => p_object_version_number);
1294: hr_utility.set_location(l_proc, 10);
1295: if ((l_api_updating and
1296: ( nvl(p_period_years,hr_api.g_number)
1297: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_number)
1298: )

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

1297: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_number)
1298: )
1299: ) or
1300: (not l_api_updating)) then
1301: hr_utility.set_location(l_proc, 15);
1302: if p_period_years not between 0 and 99 then
1303: hr_utility.set_location(l_proc, 20);
1304: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1305: fnd_message.set_token('RANGE_START','0',true);

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

1299: ) or
1300: (not l_api_updating)) then
1301: hr_utility.set_location(l_proc, 15);
1302: if p_period_years not between 0 and 99 then
1303: hr_utility.set_location(l_proc, 20);
1304: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1305: fnd_message.set_token('RANGE_START','0',true);
1306: fnd_message.set_token('RANGE_END','99',true);
1307: fnd_message.raise_error;

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

1308: end if;
1309: end if;
1310: end if;
1311: --
1312: hr_utility.set_location('Leaving:'||l_proc, 25);
1313: exception
1314: when app_exception.application_exception then
1315: if hr_multi_message.exception_add
1316: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS'

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

1314: when app_exception.application_exception then
1315: if hr_multi_message.exception_add
1316: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS'
1317: ) then
1318: hr_utility.set_location('Leaving:'||l_proc, 30);
1319: raise;
1320: end if;
1321: hr_utility.set_location('Leaving:'||l_proc,40);
1322: end chk_period_years;

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

1317: ) then
1318: hr_utility.set_location('Leaving:'||l_proc, 30);
1319: raise;
1320: end if;
1321: hr_utility.set_location('Leaving:'||l_proc,40);
1322: end chk_period_years;
1323: --
1324: -- -----------------------------------------------------------------------
1325: -- |---------------------------< chk_period_months >---------------------|

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

1356: in per_previous_employers.object_version_number%type) is
1357: l_proc varchar2(72) := g_package||'chk_period_months';
1358: l_api_updating boolean;
1359: begin
1360: hr_utility.set_location('Entering:'||l_proc, 5);
1361: --
1362: if p_period_months is not null then
1363: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1364: => p_previous_employer_id

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

1363: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1364: => p_previous_employer_id
1365: ,p_object_version_number
1366: => p_object_version_number);
1367: hr_utility.set_location(l_proc, 10);
1368: if ((l_api_updating and
1369: ( nvl(p_period_months,hr_api.g_number)
1370: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_number)
1371: )

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

1370: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_number)
1371: )
1372: ) or
1373: (not l_api_updating)) then
1374: hr_utility.set_location(l_proc, 15);
1375: if p_period_months not between 0 and 11 then
1376: hr_utility.set_location(l_proc, 20);
1377: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1378: fnd_message.set_token('RANGE_START','0',true);

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

1372: ) or
1373: (not l_api_updating)) then
1374: hr_utility.set_location(l_proc, 15);
1375: if p_period_months not between 0 and 11 then
1376: hr_utility.set_location(l_proc, 20);
1377: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1378: fnd_message.set_token('RANGE_START','0',true);
1379: fnd_message.set_token('RANGE_END','11',true);
1380: fnd_message.raise_error;

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

1381: end if;
1382: end if;
1383: end if;
1384: --
1385: hr_utility.set_location('Leaving:'||l_proc, 25);
1386: exception
1387: when app_exception.application_exception then
1388: if hr_multi_message.exception_add
1389: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS'

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

1387: when app_exception.application_exception then
1388: if hr_multi_message.exception_add
1389: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS'
1390: ) then
1391: hr_utility.set_location('Leaving:'||l_proc, 30);
1392: raise;
1393: end if;
1394: hr_utility.set_location('Leaving:'||l_proc,40);
1395: end chk_period_months;

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

1390: ) then
1391: hr_utility.set_location('Leaving:'||l_proc, 30);
1392: raise;
1393: end if;
1394: hr_utility.set_location('Leaving:'||l_proc,40);
1395: end chk_period_months;
1396: --
1397: -- -----------------------------------------------------------------------
1398: -- |---------------------------< chk_period_days >-----------------------|

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

1429: in per_previous_employers.object_version_number%type) is
1430: l_proc varchar2(72) := g_package||'chk_period_days';
1431: l_api_updating boolean;
1432: begin
1433: hr_utility.set_location('Entering:'||l_proc, 5);
1434: --
1435: if p_period_days is not null then
1436: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1437: => p_previous_employer_id

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

1436: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1437: => p_previous_employer_id
1438: ,p_object_version_number
1439: => p_object_version_number);
1440: hr_utility.set_location(l_proc, 10);
1441: if ((l_api_updating and
1442: ( nvl(p_period_days,hr_api.g_number)
1443: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_number)
1444: )

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

1443: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_number)
1444: )
1445: ) or
1446: (not l_api_updating)) then
1447: hr_utility.set_location(l_proc, 15);
1448: if p_period_days not between 0 and 365 then
1449: hr_utility.set_location(l_proc, 20);
1450: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1451: fnd_message.set_token('RANGE_START','0',true);

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

1445: ) or
1446: (not l_api_updating)) then
1447: hr_utility.set_location(l_proc, 15);
1448: if p_period_days not between 0 and 365 then
1449: hr_utility.set_location(l_proc, 20);
1450: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1451: fnd_message.set_token('RANGE_START','0',true);
1452: fnd_message.set_token('RANGE_END','365',true);
1453: fnd_message.raise_error;

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

1454: end if;
1455: end if;
1456: end if;
1457: --
1458: hr_utility.set_location('Leaving:'||l_proc, 25);
1459: exception
1460: when app_exception.application_exception then
1461: if hr_multi_message.exception_add
1462: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS'

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

1460: when app_exception.application_exception then
1461: if hr_multi_message.exception_add
1462: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS'
1463: ) then
1464: hr_utility.set_location('Leaving:'||l_proc, 30);
1465: raise;
1466: end if;
1467: hr_utility.set_location('Leaving:'||l_proc,40);
1468: end chk_period_days;

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

1463: ) then
1464: hr_utility.set_location('Leaving:'||l_proc, 30);
1465: raise;
1466: end if;
1467: hr_utility.set_location('Leaving:'||l_proc,40);
1468: end chk_period_days;
1469: --
1470: -- ----------------------------------------------------------------------------
1471: -- |---------------------------< chk_all_assignments >------------------------|

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

1512: --
1513: l_proc varchar2(72) := g_package||'chk_all_assignments';
1514: l_api_updating boolean;
1515: begin
1516: hr_utility.set_location('Entering:'||l_proc, 5);
1517: --
1518: if p_all_assignments is not null then
1519: hr_utility.set_location(l_proc, 10);
1520: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

1515: begin
1516: hr_utility.set_location('Entering:'||l_proc, 5);
1517: --
1518: if p_all_assignments is not null then
1519: hr_utility.set_location(l_proc, 10);
1520: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1521: => p_previous_employer_id
1522: ,p_object_version_number
1523: => p_object_version_number

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

1527: nvl(p_all_assignments,hr_api.g_varchar2)
1528: <> nvl(per_pem_shd.g_old_rec.all_assignments, hr_api.g_varchar2))
1529: or
1530: (not l_api_updating)) then
1531: hr_utility.set_location(l_proc, 15);
1532: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1533: hr_utility.set_location(l_proc, 20);
1534: if p_all_assignments = 'Y' then
1535: hr_utility.set_location(l_proc, 25);

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

1529: or
1530: (not l_api_updating)) then
1531: hr_utility.set_location(l_proc, 15);
1532: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1533: hr_utility.set_location(l_proc, 20);
1534: if p_all_assignments = 'Y' then
1535: hr_utility.set_location(l_proc, 25);
1536: open csr_pem_assignments;
1537: fetch csr_pem_assignments into l_previous_job_usage_id;

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

1531: hr_utility.set_location(l_proc, 15);
1532: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1533: hr_utility.set_location(l_proc, 20);
1534: if p_all_assignments = 'Y' then
1535: hr_utility.set_location(l_proc, 25);
1536: open csr_pem_assignments;
1537: fetch csr_pem_assignments into l_previous_job_usage_id;
1538: if csr_pem_assignments%found then
1539: hr_utility.set_location(l_proc, 30);

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

1535: hr_utility.set_location(l_proc, 25);
1536: open csr_pem_assignments;
1537: fetch csr_pem_assignments into l_previous_job_usage_id;
1538: if csr_pem_assignments%found then
1539: hr_utility.set_location(l_proc, 30);
1540: close csr_pem_assignments;
1541: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1542: hr_multi_message.add
1543: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PREVIOUS_EMPLOYER_ID'

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

1547: close csr_pem_assignments;
1548: end if;
1549: end if;
1550: else
1551: hr_utility.set_location(l_proc, 35);
1552: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1553: hr_multi_message.add
1554: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.ALL_ASSIGNMENTS'
1555: );

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

1556: end if;
1557: end if;
1558: end if;
1559: --
1560: hr_utility.set_location('Leaving:'||l_proc, 40);
1561: end chk_all_assignments;
1562: --
1563: -- ----------------------------------------------------------------------------
1564: -- |-------------------------< chk_business_group_id >------------------------|

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

1601: l_proc varchar2(72) := g_package||'chk_business_group_id';
1602: l_api_updating boolean;
1603: --
1604: begin
1605: hr_utility.set_location('Entering:'||l_proc, 5);
1606: if p_business_group_id is not null then
1607: hr_utility.set_location(l_proc, 10);
1608: --
1609: --validate business_group_id

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

1603: --
1604: begin
1605: hr_utility.set_location('Entering:'||l_proc, 5);
1606: if p_business_group_id is not null then
1607: hr_utility.set_location(l_proc, 10);
1608: --
1609: --validate business_group_id
1610: --
1611: hr_api.validate_bus_grp_id(p_business_group_id);

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

1621: if (l_api_updating
1622: and per_pem_shd.g_old_rec.business_group_id is not null
1623: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1624: --
1625: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1626: hr_utility.raise_error;
1627: --
1628: end if;
1629: --

Line 1626: hr_utility.raise_error;

1622: and per_pem_shd.g_old_rec.business_group_id is not null
1623: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1624: --
1625: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1626: hr_utility.raise_error;
1627: --
1628: end if;
1629: --
1630: hr_utility.set_location('Leaving:'||l_proc, 40);

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

1626: hr_utility.raise_error;
1627: --
1628: end if;
1629: --
1630: hr_utility.set_location('Leaving:'||l_proc, 40);
1631: exception
1632: when app_exception.application_exception then
1633: if hr_multi_message.exception_add
1634: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.BUSINESS_GROUP_ID'

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

1632: when app_exception.application_exception then
1633: if hr_multi_message.exception_add
1634: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.BUSINESS_GROUP_ID'
1635: ) then
1636: hr_utility.set_location('Leaving:'||l_proc, 50);
1637: raise;
1638: end if;
1639: hr_utility.set_location('Leaving:'||l_proc,60);
1640: end chk_business_group_id;

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

1635: ) then
1636: hr_utility.set_location('Leaving:'||l_proc, 50);
1637: raise;
1638: end if;
1639: hr_utility.set_location('Leaving:'||l_proc,60);
1640: end chk_business_group_id;
1641: --
1642: -- ----------------------------------------------------------------------------
1643: -- |---------------------------< insert_validate >----------------------------|

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

1649: --
1650: l_proc varchar2(72) := g_package||'insert_validate';
1651: --
1652: Begin
1653: hr_utility.set_location('Entering:'||l_proc, 5);
1654: --
1655: --Validate Important Attributes
1656: --
1657: hr_utility.set_location(l_proc, 10);

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

1653: hr_utility.set_location('Entering:'||l_proc, 5);
1654: --
1655: --Validate Important Attributes
1656: --
1657: hr_utility.set_location(l_proc, 10);
1658: hr_api.mandatory_arg_error
1659: (p_api_name => l_proc
1660: ,p_argument => 'EFFECTIVE_DATE'
1661: ,p_argument_value => p_effective_date

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

1660: ,p_argument => 'EFFECTIVE_DATE'
1661: ,p_argument_value => p_effective_date
1662: );
1663: -- Call all supporting business operations
1664: hr_utility.set_location(l_proc, 15);
1665: --
1666: if p_rec.party_id is null and p_rec.business_group_id is not null then
1667: hr_api.validate_bus_grp_id
1668: (p_business_group_id => p_rec.business_group_id

Line 1680: hr_utility.set_location(l_proc, 18);

1676: hr_multi_message.end_validation_set;
1677: --
1678: --validate dependent attributes
1679: --
1680: hr_utility.set_location(l_proc, 18);
1681: chk_business_group_id(p_business_group_id => p_rec.business_group_id
1682: ,p_previous_employer_id => p_rec.previous_employer_id
1683: ,p_object_version_number => p_rec.object_version_number
1684: ,p_effective_date => p_effective_date);

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

1682: ,p_previous_employer_id => p_rec.previous_employer_id
1683: ,p_object_version_number => p_rec.object_version_number
1684: ,p_effective_date => p_effective_date);
1685: --
1686: hr_utility.set_location(l_proc, 20);
1687: chk_person_id(p_person_id => p_rec.person_id
1688: ,p_effective_date => p_effective_date
1689: ,p_previous_employer_id => p_rec.previous_employer_id
1690: ,p_object_version_number => p_rec.object_version_number);

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

1688: ,p_effective_date => p_effective_date
1689: ,p_previous_employer_id => p_rec.previous_employer_id
1690: ,p_object_version_number => p_rec.object_version_number);
1691: --
1692: hr_utility.set_location(l_proc, 25);
1693: chk_party_id(p_party_id => p_rec.party_id
1694: ,p_previous_employer_id => p_rec.previous_employer_id
1695: ,p_object_version_number => p_rec.object_version_number);
1696: --

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

1693: chk_party_id(p_party_id => p_rec.party_id
1694: ,p_previous_employer_id => p_rec.previous_employer_id
1695: ,p_object_version_number => p_rec.object_version_number);
1696: --
1697: hr_utility.set_location(l_proc, 30);
1698: chk_employer_country(p_previous_employer_id => p_rec.previous_employer_id
1699: ,p_object_version_number => p_rec.object_version_number
1700: ,p_employer_country => p_rec.employer_country);
1701: --

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

1698: chk_employer_country(p_previous_employer_id => p_rec.previous_employer_id
1699: ,p_object_version_number => p_rec.object_version_number
1700: ,p_employer_country => p_rec.employer_country);
1701: --
1702: hr_utility.set_location(l_proc, 35);
1703: chk_employer_type(p_previous_employer_id => p_rec.previous_employer_id
1704: ,p_object_version_number => p_rec.object_version_number
1705: ,p_employer_type => p_rec.employer_type
1706: ,p_effective_date => p_effective_date);

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

1704: ,p_object_version_number => p_rec.object_version_number
1705: ,p_employer_type => p_rec.employer_type
1706: ,p_effective_date => p_effective_date);
1707: --
1708: hr_utility.set_location(l_proc, 40);
1709: chk_employer_subtype(p_previous_employer_id => p_rec.previous_employer_id
1710: ,p_object_version_number => p_rec.object_version_number
1711: ,p_employer_type => p_rec.employer_type
1712: ,p_employer_subtype => p_rec.employer_subtype

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

1711: ,p_employer_type => p_rec.employer_type
1712: ,p_employer_subtype => p_rec.employer_subtype
1713: ,p_effective_date => p_effective_date);
1714: --
1715: hr_utility.set_location(l_proc, 50);
1716: chk_start_end_dates(p_previous_employer_id => p_rec.previous_employer_id
1717: ,p_object_version_number => p_rec.object_version_number
1718: ,p_start_date => p_rec.start_date
1719: ,p_end_date => p_rec.end_date

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

1718: ,p_start_date => p_rec.start_date
1719: ,p_end_date => p_rec.end_date
1720: ,p_effective_date => p_effective_date); -- bug 7112425
1721: --
1722: hr_utility.set_location(l_proc, 55);
1723: chk_period_years(p_period_years
1724: => p_rec.period_years
1725: ,p_previous_employer_id
1726: => p_rec.previous_employer_id

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

1726: => p_rec.previous_employer_id
1727: ,p_object_version_number
1728: => p_rec.object_version_number);
1729: --
1730: hr_utility.set_location(l_proc, 60);
1731: chk_period_months(p_period_months
1732: => p_rec.period_months
1733: ,p_previous_employer_id
1734: => p_rec.previous_employer_id

Line 1738: hr_utility.set_location(l_proc, 65);

1734: => p_rec.previous_employer_id
1735: ,p_object_version_number
1736: => p_rec.object_version_number);
1737: --
1738: hr_utility.set_location(l_proc, 65);
1739: chk_period_days(p_period_days
1740: => p_rec.period_days
1741: ,p_previous_employer_id
1742: => p_rec.previous_employer_id

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

1742: => p_rec.previous_employer_id
1743: ,p_object_version_number
1744: => p_rec.object_version_number);
1745: --
1746: hr_utility.set_location(l_proc, 70);
1747: chk_all_assignments(p_previous_employer_id => p_rec.previous_employer_id
1748: ,p_object_version_number => p_rec.object_version_number
1749: ,p_all_assignments => p_rec.all_assignments);
1750: --

Line 1751: hr_utility.set_location(l_proc, 75);

1747: chk_all_assignments(p_previous_employer_id => p_rec.previous_employer_id
1748: ,p_object_version_number => p_rec.object_version_number
1749: ,p_all_assignments => p_rec.all_assignments);
1750: --
1751: hr_utility.set_location(l_proc, 75);
1752: per_pem_bus.chk_ddf(p_rec);
1753: --
1754: hr_utility.set_location(l_proc, 80);
1755: per_pem_bus.chk_df(p_rec);

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

1750: --
1751: hr_utility.set_location(l_proc, 75);
1752: per_pem_bus.chk_ddf(p_rec);
1753: --
1754: hr_utility.set_location(l_proc, 80);
1755: per_pem_bus.chk_df(p_rec);
1756: --
1757: hr_utility.set_location(' Leaving:'||l_proc, 85);
1758: End insert_validate;

Line 1757: hr_utility.set_location(' Leaving:'||l_proc, 85);

1753: --
1754: hr_utility.set_location(l_proc, 80);
1755: per_pem_bus.chk_df(p_rec);
1756: --
1757: hr_utility.set_location(' Leaving:'||l_proc, 85);
1758: End insert_validate;
1759: --
1760: -- ----------------------------------------------------------------------------
1761: -- |---------------------------< update_validate >----------------------------|

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

1767: --
1768: l_proc varchar2(72) := g_package||'update_validate';
1769: --
1770: Begin
1771: hr_utility.set_location('Entering:'||l_proc, 5);
1772: --
1773: -- Call all supporting business operations
1774: --
1775: hr_utility.set_location(l_proc, 10);

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

1771: hr_utility.set_location('Entering:'||l_proc, 5);
1772: --
1773: -- Call all supporting business operations
1774: --
1775: hr_utility.set_location(l_proc, 10);
1776: hr_api.mandatory_arg_error
1777: (p_api_name => l_proc
1778: ,p_argument => 'EFFECTIVE_DATE'
1779: ,p_argument_value => p_effective_date

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

1783: (p_effective_date => p_effective_date
1784: ,p_rec => p_rec
1785: );
1786: --
1787: hr_utility.set_location(l_proc, 15);
1788: if p_rec.party_id is null and p_rec.business_group_id is not null then
1789: hr_api.validate_bus_grp_id
1790: (p_business_group_id => p_rec.business_group_id
1791: ,p_associated_column1 =>per_pem_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

Line 1803: hr_utility.set_location(l_proc, 18);

1799: hr_multi_message.end_validation_set;
1800: --
1801: --validate dependent attributes
1802: --
1803: hr_utility.set_location(l_proc, 18);
1804: chk_business_group_id(p_business_group_id => p_rec.business_group_id
1805: ,p_previous_employer_id => p_rec.previous_employer_id
1806: ,p_object_version_number => p_rec.object_version_number
1807: ,p_effective_date => p_effective_date);

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

1805: ,p_previous_employer_id => p_rec.previous_employer_id
1806: ,p_object_version_number => p_rec.object_version_number
1807: ,p_effective_date => p_effective_date);
1808: --
1809: hr_utility.set_location(l_proc, 20);
1810: chk_employer_country(p_previous_employer_id => p_rec.previous_employer_id
1811: ,p_object_version_number => p_rec.object_version_number
1812: ,p_employer_country => p_rec.employer_country);
1813: --

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

1810: chk_employer_country(p_previous_employer_id => p_rec.previous_employer_id
1811: ,p_object_version_number => p_rec.object_version_number
1812: ,p_employer_country => p_rec.employer_country);
1813: --
1814: hr_utility.set_location(l_proc, 25);
1815: chk_employer_type(p_previous_employer_id => p_rec.previous_employer_id
1816: ,p_object_version_number => p_rec.object_version_number
1817: ,p_employer_type => p_rec.employer_type
1818: ,p_effective_date => p_effective_date);

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

1816: ,p_object_version_number => p_rec.object_version_number
1817: ,p_employer_type => p_rec.employer_type
1818: ,p_effective_date => p_effective_date);
1819: --
1820: hr_utility.set_location(l_proc, 30);
1821: chk_employer_subtype(p_previous_employer_id => p_rec.previous_employer_id
1822: ,p_object_version_number => p_rec.object_version_number
1823: ,p_employer_type => p_rec.employer_type
1824: ,p_employer_subtype => p_rec.employer_subtype

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

1823: ,p_employer_type => p_rec.employer_type
1824: ,p_employer_subtype => p_rec.employer_subtype
1825: ,p_effective_date => p_effective_date);
1826: --
1827: hr_utility.set_location(l_proc, 40);
1828: chk_start_end_dates(p_previous_employer_id => p_rec.previous_employer_id
1829: ,p_object_version_number => p_rec.object_version_number
1830: ,p_start_date => p_rec.start_date
1831: ,p_end_date => p_rec.end_date

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

1830: ,p_start_date => p_rec.start_date
1831: ,p_end_date => p_rec.end_date
1832: ,p_effective_date => p_effective_date); -- bug 7112425
1833: --
1834: hr_utility.set_location(l_proc, 45);
1835: chk_period_years(p_period_years
1836: => p_rec.period_years
1837: ,p_previous_employer_id
1838: => p_rec.previous_employer_id

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

1838: => p_rec.previous_employer_id
1839: ,p_object_version_number
1840: => p_rec.object_version_number);
1841: --
1842: hr_utility.set_location(l_proc, 50);
1843: chk_period_months(p_period_months
1844: => p_rec.period_months
1845: ,p_previous_employer_id
1846: => p_rec.previous_employer_id

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

1846: => p_rec.previous_employer_id
1847: ,p_object_version_number
1848: => p_rec.object_version_number);
1849: --
1850: hr_utility.set_location(l_proc, 55);
1851: chk_period_days(p_period_days
1852: => p_rec.period_days
1853: ,p_previous_employer_id
1854: => p_rec.previous_employer_id

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

1854: => p_rec.previous_employer_id
1855: ,p_object_version_number
1856: => p_rec.object_version_number);
1857: --
1858: hr_utility.set_location(l_proc, 60);
1859: chk_all_assignments(p_previous_employer_id => p_rec.previous_employer_id
1860: ,p_object_version_number => p_rec.object_version_number
1861: ,p_all_assignments => p_rec.all_assignments);
1862: --

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

1859: chk_all_assignments(p_previous_employer_id => p_rec.previous_employer_id
1860: ,p_object_version_number => p_rec.object_version_number
1861: ,p_all_assignments => p_rec.all_assignments);
1862: --
1863: hr_utility.set_location(l_proc, 65);
1864: per_pem_bus.chk_ddf(p_rec);
1865: --
1866: hr_utility.set_location(l_proc, 70);
1867: per_pem_bus.chk_df(p_rec);

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

1862: --
1863: hr_utility.set_location(l_proc, 65);
1864: per_pem_bus.chk_ddf(p_rec);
1865: --
1866: hr_utility.set_location(l_proc, 70);
1867: per_pem_bus.chk_df(p_rec);
1868: --
1869: hr_utility.set_location(' Leaving:'||l_proc, 75);
1870: End update_validate;

Line 1869: hr_utility.set_location(' Leaving:'||l_proc, 75);

1865: --
1866: hr_utility.set_location(l_proc, 70);
1867: per_pem_bus.chk_df(p_rec);
1868: --
1869: hr_utility.set_location(' Leaving:'||l_proc, 75);
1870: End update_validate;
1871: --
1872: -- ----------------------------------------------------------------------------
1873: -- |---------------------------< delete_validate >----------------------------|

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

1878: --
1879: l_proc varchar2(72) := g_package||'delete_validate';
1880: --
1881: Begin
1882: hr_utility.set_location('Entering:'||l_proc, 5);
1883: --
1884: -- Call all supporting business operations
1885: --
1886: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1882: hr_utility.set_location('Entering:'||l_proc, 5);
1883: --
1884: -- Call all supporting business operations
1885: --
1886: hr_utility.set_location(' Leaving:'||l_proc, 10);
1887: End delete_validate;
1888: --
1889: end per_pem_bus;