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 70: hr_utility.set_location(l_proc, 28);

66: p_period_months:=11;
67: p_period_years:=p_period_years - 1;
68: end if;
69:
70: hr_utility.set_location(l_proc, 28);
71: end if;
72: --
73: -- 3635308 end here
74: --

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

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

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

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

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

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

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

87:
88: end if;
89: end if;
90: --
91: hr_utility.set_location('Leaving:'||l_proc, 40);
92: end get_period_values;
93: --
94: -- ---------------------------------------------------------------------------
95: -- |----------------------< set_security_group_id >--------------------------|

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

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

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

148: (p_security_group_id => l_security_group_id
149: );
150: end if;
151: --
152: hr_utility.set_location(' Leaving:'|| l_proc, 20);
153: --
154: end set_security_group_id;
155: --
156: -- ---------------------------------------------------------------------------

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

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

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

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

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

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

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

221: close csr_leg_code;
222: per_pem_bus.g_previous_employer_id := p_previous_employer_id;
223: per_pem_bus.g_legislation_code := l_legislation_code;
224: end if;
225: hr_utility.set_location(' Leaving:'|| l_proc, 40);
226: return l_legislation_code;
227: end return_legislation_code;
228: --
229: -- ----------------------------------------------------------------------------

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

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

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

399: ,p_attribute30_value => p_rec.pem_information30
400: );
401: end if;
402: --
403: hr_utility.set_location(' Leaving:'||l_proc,20);
404: end chk_ddf;
405: --
406: -- ----------------------------------------------------------------------------
407: -- |------------------------------< chk_df >----------------------------------|

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

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

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

576: ,p_attribute30_value => p_rec.pem_attribute30
577: );
578: end if;
579: --
580: hr_utility.set_location(' Leaving:'||l_proc,20);
581: end chk_df;
582: --
583: -- ----------------------------------------------------------------------------
584: -- |-----------------------< chk_non_updateable_args >------------------------|

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

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

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

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

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

641: ,p_base_table => per_pem_shd.g_tab_nam
642: );
643: end if;
644: --
645: hr_utility.set_location(l_proc,15);
646: if per_pem_shd.g_old_rec.person_id <> p_rec.person_id
647: then
648: hr_api.argument_changed_error
649: (p_api_name => l_proc

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

651: ,p_base_table => per_pem_shd.g_tab_nam
652: );
653: end if;
654: --
655: hr_utility.set_location(l_proc,20);
656: if nvl(per_pem_shd.g_old_rec.party_id,p_rec.party_id) <>
657: nvl(p_rec.party_id,per_pem_shd.g_old_rec.party_id)
658: then
659: hr_api.argument_changed_error

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

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

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

680: */
681: --
682: -- end commented code
683: --
684: hr_utility.set_location('Leaving : '||l_proc,30);
685: End chk_non_updateable_args;
686: --
687: -- ----------------------------------------------------------------------------
688: -- |----------------------------< chk_person_id >-----------------------------|

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

792: ) then
793: hr_utility.set_location('Leaving:'||l_proc, 50);
794: raise;
795: end if;
796: hr_utility.set_location('Leaving:'||l_proc,60);
797: end chk_person_id;
798: --
799: -- ----------------------------------------------------------------------------
800: -- |-----------------------------< chk_party_id >-----------------------------|

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

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

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

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

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

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

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

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

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

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

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

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

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

875: ) then
876: hr_utility.set_location('Leaving:'||l_proc,30);
877: raise;
878: end if;
879: hr_utility.set_location('Leaving:'||l_proc,40);
880: end chk_party_id;
881: --
882: -- ----------------------------------------------------------------------------
883: -- |-------------------------< chk_employer_country >-------------------------|

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

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

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

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

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

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

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

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

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

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

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

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

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

959: ) then
960: hr_utility.set_location('Leaving:'||l_proc, 30);
961: raise;
962: end if;
963: hr_utility.set_location('Leaving:'||l_proc,40);
964: end chk_employer_country;
965: --
966: -- ----------------------------------------------------------------------------
967: -- |--------------------------< chk_employer_type >---------------------------|

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

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

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

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

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

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

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

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

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

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

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

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

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

1041: ) then
1042: hr_utility.set_location('Leaving:'||l_proc, 30);
1043: raise;
1044: end if;
1045: hr_utility.set_location('Leaving:'||l_proc,40);
1046: end chk_employer_type;
1047: --
1048: -- ----------------------------------------------------------------------------
1049: -- |-------------------------< chk_employer_subtype >-------------------------|

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1158: ) then
1159: hr_utility.set_location('Leaving:'||l_proc, 40);
1160: raise;
1161: end if;
1162: hr_utility.set_location('Leaving:'||l_proc,50);
1163: end chk_employer_subtype;
1164: --
1165: -- -----------------------------------------------------------------------
1166: -- |---------------------------< chk_start_end_dates >-------------------|

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

1214: FROM per_business_groups
1215: WHERE business_group_id = p_business_group_id;
1216:
1217: begin
1218: hr_utility.set_location('Entering:'||l_proc, 5);
1219: --
1220: -- This If condition added for bug 7112425
1221:
1222: OPEN leg_code;

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

1229: fnd_message.raise_error;
1230: END IF ;
1231: END IF;
1232: -- Bug 14316052
1233: hr_utility.set_location('Entering:'||l_proc, 6);
1234:
1235: if p_start_date is not null and p_end_date is not null then
1236: hr_utility.set_location(l_proc, 10);
1237: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

1232: -- Bug 14316052
1233: hr_utility.set_location('Entering:'||l_proc, 6);
1234:
1235: if p_start_date is not null and p_end_date is not null then
1236: hr_utility.set_location(l_proc, 10);
1237: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1238: => p_previous_employer_id
1239: ,p_object_version_number
1240: => p_object_version_number

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

1247: <> nvl(per_pem_shd.g_old_rec.end_date, hr_api.g_eot)
1248: ))
1249: or
1250: (not l_api_updating)) then
1251: hr_utility.set_location(l_proc, 15);
1252: if p_start_date > p_end_date then
1253: hr_utility.set_location(l_proc, 20);
1254: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1255: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);

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

1249: or
1250: (not l_api_updating)) then
1251: hr_utility.set_location(l_proc, 15);
1252: if p_start_date > p_end_date then
1253: hr_utility.set_location(l_proc, 20);
1254: fnd_message.set_name('PER','HR_289530_PEM_STRT_END_DATES');
1255: fnd_message.set_token('START_DATE',TO_CHAR(p_start_date,'DD-MON-YYYY'),true);
1256: fnd_message.set_token('END_DATE',TO_CHAR(p_end_date,'DD-MON-YYYY'),true);
1257: fnd_message.raise_error;

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

1258: end if;
1259: end if;
1260: end if;
1261: --
1262: hr_utility.set_location('Leaving:'||l_proc, 25);
1263: /*exception
1264: when app_exception.application_exception then
1265: if hr_multi_message.exception_add
1266: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'

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

1265: if hr_multi_message.exception_add
1266: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.START_DATE'
1267: ,p_associated_column2 => 'PER_PREVIOUS_EMPLOYERS.END_DATE'
1268: ) then
1269: hr_utility.set_location('Leaving:'||l_proc, 30);
1270: raise;
1271: end if;
1272: hr_utility.set_location('Leaving:'||l_proc,40);*/--commented for the bug 5686794
1273: end chk_start_end_dates;

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

1268: ) then
1269: hr_utility.set_location('Leaving:'||l_proc, 30);
1270: raise;
1271: end if;
1272: hr_utility.set_location('Leaving:'||l_proc,40);*/--commented for the bug 5686794
1273: end chk_start_end_dates;
1274: --
1275: -- -----------------------------------------------------------------------
1276: -- |---------------------------< chk_period_years >----------------------|

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

1307: in per_previous_employers.object_version_number%type) is
1308: l_proc varchar2(72) := g_package||'chk_period_years';
1309: l_api_updating boolean;
1310: begin
1311: hr_utility.set_location('Entering:'||l_proc, 5);
1312: --
1313: if p_period_years is not null then
1314: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1315: => p_previous_employer_id

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

1314: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1315: => p_previous_employer_id
1316: ,p_object_version_number
1317: => p_object_version_number);
1318: hr_utility.set_location(l_proc, 10);
1319: if ((l_api_updating and
1320: ( nvl(p_period_years,hr_api.g_number)
1321: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_number)
1322: )

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

1321: <> nvl(per_pem_shd.g_old_rec.period_years, hr_api.g_number)
1322: )
1323: ) or
1324: (not l_api_updating)) then
1325: hr_utility.set_location(l_proc, 15);
1326: if p_period_years not between 0 and 99 then
1327: hr_utility.set_location(l_proc, 20);
1328: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1329: fnd_message.set_token('RANGE_START','0',true);

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

1323: ) or
1324: (not l_api_updating)) then
1325: hr_utility.set_location(l_proc, 15);
1326: if p_period_years not between 0 and 99 then
1327: hr_utility.set_location(l_proc, 20);
1328: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1329: fnd_message.set_token('RANGE_START','0',true);
1330: fnd_message.set_token('RANGE_END','99',true);
1331: fnd_message.raise_error;

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

1332: end if;
1333: end if;
1334: end if;
1335: --
1336: hr_utility.set_location('Leaving:'||l_proc, 25);
1337: exception
1338: when app_exception.application_exception then
1339: if hr_multi_message.exception_add
1340: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS'

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

1338: when app_exception.application_exception then
1339: if hr_multi_message.exception_add
1340: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_YEARS'
1341: ) then
1342: hr_utility.set_location('Leaving:'||l_proc, 30);
1343: raise;
1344: end if;
1345: hr_utility.set_location('Leaving:'||l_proc,40);
1346: end chk_period_years;

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

1341: ) then
1342: hr_utility.set_location('Leaving:'||l_proc, 30);
1343: raise;
1344: end if;
1345: hr_utility.set_location('Leaving:'||l_proc,40);
1346: end chk_period_years;
1347: --
1348: -- -----------------------------------------------------------------------
1349: -- |---------------------------< chk_period_months >---------------------|

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

1380: in per_previous_employers.object_version_number%type) is
1381: l_proc varchar2(72) := g_package||'chk_period_months';
1382: l_api_updating boolean;
1383: begin
1384: hr_utility.set_location('Entering:'||l_proc, 5);
1385: --
1386: if p_period_months is not null then
1387: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1388: => p_previous_employer_id

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

1387: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1388: => p_previous_employer_id
1389: ,p_object_version_number
1390: => p_object_version_number);
1391: hr_utility.set_location(l_proc, 10);
1392: if ((l_api_updating and
1393: ( nvl(p_period_months,hr_api.g_number)
1394: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_number)
1395: )

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

1394: <> nvl(per_pem_shd.g_old_rec.period_months,hr_api.g_number)
1395: )
1396: ) or
1397: (not l_api_updating)) then
1398: hr_utility.set_location(l_proc, 15);
1399: if p_period_months not between 0 and 11 then
1400: hr_utility.set_location(l_proc, 20);
1401: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1402: fnd_message.set_token('RANGE_START','0',true);

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

1396: ) or
1397: (not l_api_updating)) then
1398: hr_utility.set_location(l_proc, 15);
1399: if p_period_months not between 0 and 11 then
1400: hr_utility.set_location(l_proc, 20);
1401: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1402: fnd_message.set_token('RANGE_START','0',true);
1403: fnd_message.set_token('RANGE_END','11',true);
1404: fnd_message.raise_error;

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

1405: end if;
1406: end if;
1407: end if;
1408: --
1409: hr_utility.set_location('Leaving:'||l_proc, 25);
1410: exception
1411: when app_exception.application_exception then
1412: if hr_multi_message.exception_add
1413: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS'

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

1411: when app_exception.application_exception then
1412: if hr_multi_message.exception_add
1413: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_MONTHS'
1414: ) then
1415: hr_utility.set_location('Leaving:'||l_proc, 30);
1416: raise;
1417: end if;
1418: hr_utility.set_location('Leaving:'||l_proc,40);
1419: end chk_period_months;

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

1414: ) then
1415: hr_utility.set_location('Leaving:'||l_proc, 30);
1416: raise;
1417: end if;
1418: hr_utility.set_location('Leaving:'||l_proc,40);
1419: end chk_period_months;
1420: --
1421: -- -----------------------------------------------------------------------
1422: -- |---------------------------< chk_period_days >-----------------------|

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

1453: in per_previous_employers.object_version_number%type) is
1454: l_proc varchar2(72) := g_package||'chk_period_days';
1455: l_api_updating boolean;
1456: begin
1457: hr_utility.set_location('Entering:'||l_proc, 5);
1458: --
1459: if p_period_days is not null then
1460: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1461: => p_previous_employer_id

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

1460: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1461: => p_previous_employer_id
1462: ,p_object_version_number
1463: => p_object_version_number);
1464: hr_utility.set_location(l_proc, 10);
1465: if ((l_api_updating and
1466: ( nvl(p_period_days,hr_api.g_number)
1467: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_number)
1468: )

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

1467: <> nvl(per_pem_shd.g_old_rec.period_days,hr_api.g_number)
1468: )
1469: ) or
1470: (not l_api_updating)) then
1471: hr_utility.set_location(l_proc, 15);
1472: if p_period_days not between 0 and 365 then
1473: hr_utility.set_location(l_proc, 20);
1474: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1475: fnd_message.set_token('RANGE_START','0',true);

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

1469: ) or
1470: (not l_api_updating)) then
1471: hr_utility.set_location(l_proc, 15);
1472: if p_period_days not between 0 and 365 then
1473: hr_utility.set_location(l_proc, 20);
1474: fnd_message.set_name('PER','HR_289534_PEM_VALID_PRD_RANGE');
1475: fnd_message.set_token('RANGE_START','0',true);
1476: fnd_message.set_token('RANGE_END','365',true);
1477: fnd_message.raise_error;

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

1478: end if;
1479: end if;
1480: end if;
1481: --
1482: hr_utility.set_location('Leaving:'||l_proc, 25);
1483: exception
1484: when app_exception.application_exception then
1485: if hr_multi_message.exception_add
1486: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS'

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

1484: when app_exception.application_exception then
1485: if hr_multi_message.exception_add
1486: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PERIOD_DAYS'
1487: ) then
1488: hr_utility.set_location('Leaving:'||l_proc, 30);
1489: raise;
1490: end if;
1491: hr_utility.set_location('Leaving:'||l_proc,40);
1492: end chk_period_days;

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

1487: ) then
1488: hr_utility.set_location('Leaving:'||l_proc, 30);
1489: raise;
1490: end if;
1491: hr_utility.set_location('Leaving:'||l_proc,40);
1492: end chk_period_days;
1493: --
1494: -- ----------------------------------------------------------------------------
1495: -- |---------------------------< chk_all_assignments >------------------------|

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

1536: --
1537: l_proc varchar2(72) := g_package||'chk_all_assignments';
1538: l_api_updating boolean;
1539: begin
1540: hr_utility.set_location('Entering:'||l_proc, 5);
1541: --
1542: if p_all_assignments is not null then
1543: hr_utility.set_location(l_proc, 10);
1544: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id

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

1539: begin
1540: hr_utility.set_location('Entering:'||l_proc, 5);
1541: --
1542: if p_all_assignments is not null then
1543: hr_utility.set_location(l_proc, 10);
1544: l_api_updating := per_pem_shd.api_updating(p_previous_employer_id
1545: => p_previous_employer_id
1546: ,p_object_version_number
1547: => p_object_version_number

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

1551: nvl(p_all_assignments,hr_api.g_varchar2)
1552: <> nvl(per_pem_shd.g_old_rec.all_assignments, hr_api.g_varchar2))
1553: or
1554: (not l_api_updating)) then
1555: hr_utility.set_location(l_proc, 15);
1556: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1557: hr_utility.set_location(l_proc, 20);
1558: if p_all_assignments = 'Y' then
1559: hr_utility.set_location(l_proc, 25);

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

1553: or
1554: (not l_api_updating)) then
1555: hr_utility.set_location(l_proc, 15);
1556: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1557: hr_utility.set_location(l_proc, 20);
1558: if p_all_assignments = 'Y' then
1559: hr_utility.set_location(l_proc, 25);
1560: open csr_pem_assignments;
1561: fetch csr_pem_assignments into l_previous_job_usage_id;

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

1555: hr_utility.set_location(l_proc, 15);
1556: if p_all_assignments = 'Y' or p_all_assignments = 'N' then
1557: hr_utility.set_location(l_proc, 20);
1558: if p_all_assignments = 'Y' then
1559: hr_utility.set_location(l_proc, 25);
1560: open csr_pem_assignments;
1561: fetch csr_pem_assignments into l_previous_job_usage_id;
1562: if csr_pem_assignments%found then
1563: hr_utility.set_location(l_proc, 30);

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

1559: hr_utility.set_location(l_proc, 25);
1560: open csr_pem_assignments;
1561: fetch csr_pem_assignments into l_previous_job_usage_id;
1562: if csr_pem_assignments%found then
1563: hr_utility.set_location(l_proc, 30);
1564: close csr_pem_assignments;
1565: fnd_message.set_name('PER','HR_289546_PEM_ALL_ASG_MOD_NA');
1566: hr_multi_message.add
1567: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.PREVIOUS_EMPLOYER_ID'

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

1571: close csr_pem_assignments;
1572: end if;
1573: end if;
1574: else
1575: hr_utility.set_location(l_proc, 35);
1576: fnd_message.set_name('PER','HR_289545_PEM_VALID_ASGMT_FLAG');
1577: hr_multi_message.add
1578: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.ALL_ASSIGNMENTS'
1579: );

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

1580: end if;
1581: end if;
1582: end if;
1583: --
1584: hr_utility.set_location('Leaving:'||l_proc, 40);
1585: end chk_all_assignments;
1586: --
1587: -- ----------------------------------------------------------------------------
1588: -- |-------------------------< chk_business_group_id >------------------------|

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

1625: l_proc varchar2(72) := g_package||'chk_business_group_id';
1626: l_api_updating boolean;
1627: --
1628: begin
1629: hr_utility.set_location('Entering:'||l_proc, 5);
1630: if p_business_group_id is not null then
1631: hr_utility.set_location(l_proc, 10);
1632: --
1633: --validate business_group_id

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

1627: --
1628: begin
1629: hr_utility.set_location('Entering:'||l_proc, 5);
1630: if p_business_group_id is not null then
1631: hr_utility.set_location(l_proc, 10);
1632: --
1633: --validate business_group_id
1634: --
1635: hr_api.validate_bus_grp_id(p_business_group_id);

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

1645: if (l_api_updating
1646: and per_pem_shd.g_old_rec.business_group_id is not null
1647: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1648: --
1649: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1650: hr_utility.raise_error;
1651: --
1652: end if;
1653: --

Line 1650: hr_utility.raise_error;

1646: and per_pem_shd.g_old_rec.business_group_id is not null
1647: and per_pem_shd.g_old_rec.business_group_id <> p_business_group_id ) then
1648: --
1649: hr_utility.set_message(800, 'HR_289947_INV_UPD_BG_ID');
1650: hr_utility.raise_error;
1651: --
1652: end if;
1653: --
1654: hr_utility.set_location('Leaving:'||l_proc, 40);

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

1650: hr_utility.raise_error;
1651: --
1652: end if;
1653: --
1654: hr_utility.set_location('Leaving:'||l_proc, 40);
1655: exception
1656: when app_exception.application_exception then
1657: if hr_multi_message.exception_add
1658: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.BUSINESS_GROUP_ID'

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

1656: when app_exception.application_exception then
1657: if hr_multi_message.exception_add
1658: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.BUSINESS_GROUP_ID'
1659: ) then
1660: hr_utility.set_location('Leaving:'||l_proc, 50);
1661: raise;
1662: end if;
1663: hr_utility.set_location('Leaving:'||l_proc,60);
1664: end chk_business_group_id;

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

1659: ) then
1660: hr_utility.set_location('Leaving:'||l_proc, 50);
1661: raise;
1662: end if;
1663: hr_utility.set_location('Leaving:'||l_proc,60);
1664: end chk_business_group_id;
1665: --
1666: -- ----------------------------------------------------------------------------
1667: -- |---------------------------< insert_validate >----------------------------|

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

1673: --
1674: l_proc varchar2(72) := g_package||'insert_validate';
1675: --
1676: Begin
1677: hr_utility.set_location('Entering:'||l_proc, 5);
1678: --
1679: --Validate Important Attributes
1680: --
1681: hr_utility.set_location(l_proc, 10);

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

1677: hr_utility.set_location('Entering:'||l_proc, 5);
1678: --
1679: --Validate Important Attributes
1680: --
1681: hr_utility.set_location(l_proc, 10);
1682: hr_api.mandatory_arg_error
1683: (p_api_name => l_proc
1684: ,p_argument => 'EFFECTIVE_DATE'
1685: ,p_argument_value => p_effective_date

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

1684: ,p_argument => 'EFFECTIVE_DATE'
1685: ,p_argument_value => p_effective_date
1686: );
1687: -- Call all supporting business operations
1688: hr_utility.set_location(l_proc, 15);
1689: --
1690: if p_rec.party_id is null and p_rec.business_group_id is not null then
1691: hr_api.validate_bus_grp_id
1692: (p_business_group_id => p_rec.business_group_id

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

1700: hr_multi_message.end_validation_set;
1701: --
1702: --validate dependent attributes
1703: --
1704: hr_utility.set_location(l_proc, 18);
1705: chk_business_group_id(p_business_group_id => p_rec.business_group_id
1706: ,p_previous_employer_id => p_rec.previous_employer_id
1707: ,p_object_version_number => p_rec.object_version_number
1708: ,p_effective_date => p_effective_date);

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

1706: ,p_previous_employer_id => p_rec.previous_employer_id
1707: ,p_object_version_number => p_rec.object_version_number
1708: ,p_effective_date => p_effective_date);
1709: --
1710: hr_utility.set_location(l_proc, 20);
1711: chk_person_id(p_person_id => p_rec.person_id
1712: ,p_effective_date => p_effective_date
1713: ,p_previous_employer_id => p_rec.previous_employer_id
1714: ,p_object_version_number => p_rec.object_version_number);

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

1712: ,p_effective_date => p_effective_date
1713: ,p_previous_employer_id => p_rec.previous_employer_id
1714: ,p_object_version_number => p_rec.object_version_number);
1715: --
1716: hr_utility.set_location(l_proc, 25);
1717: chk_party_id(p_party_id => p_rec.party_id
1718: ,p_previous_employer_id => p_rec.previous_employer_id
1719: ,p_object_version_number => p_rec.object_version_number);
1720: --

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

1717: chk_party_id(p_party_id => p_rec.party_id
1718: ,p_previous_employer_id => p_rec.previous_employer_id
1719: ,p_object_version_number => p_rec.object_version_number);
1720: --
1721: hr_utility.set_location(l_proc, 30);
1722: chk_employer_country(p_previous_employer_id => p_rec.previous_employer_id
1723: ,p_object_version_number => p_rec.object_version_number
1724: ,p_employer_country => p_rec.employer_country);
1725: --

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

1722: chk_employer_country(p_previous_employer_id => p_rec.previous_employer_id
1723: ,p_object_version_number => p_rec.object_version_number
1724: ,p_employer_country => p_rec.employer_country);
1725: --
1726: hr_utility.set_location(l_proc, 35);
1727: chk_employer_type(p_previous_employer_id => p_rec.previous_employer_id
1728: ,p_object_version_number => p_rec.object_version_number
1729: ,p_employer_type => p_rec.employer_type
1730: ,p_effective_date => p_effective_date);

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

1728: ,p_object_version_number => p_rec.object_version_number
1729: ,p_employer_type => p_rec.employer_type
1730: ,p_effective_date => p_effective_date);
1731: --
1732: hr_utility.set_location(l_proc, 40);
1733: chk_employer_subtype(p_previous_employer_id => p_rec.previous_employer_id
1734: ,p_object_version_number => p_rec.object_version_number
1735: ,p_employer_type => p_rec.employer_type
1736: ,p_employer_subtype => p_rec.employer_subtype

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

1735: ,p_employer_type => p_rec.employer_type
1736: ,p_employer_subtype => p_rec.employer_subtype
1737: ,p_effective_date => p_effective_date);
1738: --
1739: hr_utility.set_location(l_proc, 50);
1740: chk_start_end_dates(p_previous_employer_id => p_rec.previous_employer_id
1741: ,p_object_version_number => p_rec.object_version_number
1742: ,p_start_date => p_rec.start_date
1743: ,p_end_date => p_rec.end_date

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

1744: ,p_effective_date => p_effective_date -- bug 7112425
1745: ,p_business_group_id => p_rec.business_group_id -- bug 14316052
1746: ,p_employer_type => p_rec.employer_type);
1747: --
1748: hr_utility.set_location(l_proc, 55);
1749: chk_period_years(p_period_years
1750: => p_rec.period_years
1751: ,p_previous_employer_id
1752: => p_rec.previous_employer_id

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

1752: => p_rec.previous_employer_id
1753: ,p_object_version_number
1754: => p_rec.object_version_number);
1755: --
1756: hr_utility.set_location(l_proc, 60);
1757: chk_period_months(p_period_months
1758: => p_rec.period_months
1759: ,p_previous_employer_id
1760: => p_rec.previous_employer_id

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

1760: => p_rec.previous_employer_id
1761: ,p_object_version_number
1762: => p_rec.object_version_number);
1763: --
1764: hr_utility.set_location(l_proc, 65);
1765: chk_period_days(p_period_days
1766: => p_rec.period_days
1767: ,p_previous_employer_id
1768: => p_rec.previous_employer_id

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

1768: => p_rec.previous_employer_id
1769: ,p_object_version_number
1770: => p_rec.object_version_number);
1771: --
1772: hr_utility.set_location(l_proc, 70);
1773: chk_all_assignments(p_previous_employer_id => p_rec.previous_employer_id
1774: ,p_object_version_number => p_rec.object_version_number
1775: ,p_all_assignments => p_rec.all_assignments);
1776: --

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

1773: chk_all_assignments(p_previous_employer_id => p_rec.previous_employer_id
1774: ,p_object_version_number => p_rec.object_version_number
1775: ,p_all_assignments => p_rec.all_assignments);
1776: --
1777: hr_utility.set_location(l_proc, 75);
1778: per_pem_bus.chk_ddf(p_rec);
1779: --
1780: hr_utility.set_location(l_proc, 80);
1781: per_pem_bus.chk_df(p_rec);

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

1776: --
1777: hr_utility.set_location(l_proc, 75);
1778: per_pem_bus.chk_ddf(p_rec);
1779: --
1780: hr_utility.set_location(l_proc, 80);
1781: per_pem_bus.chk_df(p_rec);
1782: --
1783: hr_utility.set_location(' Leaving:'||l_proc, 85);
1784: End insert_validate;

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

1779: --
1780: hr_utility.set_location(l_proc, 80);
1781: per_pem_bus.chk_df(p_rec);
1782: --
1783: hr_utility.set_location(' Leaving:'||l_proc, 85);
1784: End insert_validate;
1785: --
1786: -- ----------------------------------------------------------------------------
1787: -- |---------------------------< update_validate >----------------------------|

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

1793: --
1794: l_proc varchar2(72) := g_package||'update_validate';
1795: --
1796: Begin
1797: hr_utility.set_location('Entering:'||l_proc, 5);
1798: --
1799: -- Call all supporting business operations
1800: --
1801: hr_utility.set_location(l_proc, 10);

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

1797: hr_utility.set_location('Entering:'||l_proc, 5);
1798: --
1799: -- Call all supporting business operations
1800: --
1801: hr_utility.set_location(l_proc, 10);
1802: hr_api.mandatory_arg_error
1803: (p_api_name => l_proc
1804: ,p_argument => 'EFFECTIVE_DATE'
1805: ,p_argument_value => p_effective_date

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

1809: (p_effective_date => p_effective_date
1810: ,p_rec => p_rec
1811: );
1812: --
1813: hr_utility.set_location(l_proc, 15);
1814: if p_rec.party_id is null and p_rec.business_group_id is not null then
1815: hr_api.validate_bus_grp_id
1816: (p_business_group_id => p_rec.business_group_id
1817: ,p_associated_column1 =>per_pem_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

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

1825: hr_multi_message.end_validation_set;
1826: --
1827: --validate dependent attributes
1828: --
1829: hr_utility.set_location(l_proc, 18);
1830: chk_business_group_id(p_business_group_id => p_rec.business_group_id
1831: ,p_previous_employer_id => p_rec.previous_employer_id
1832: ,p_object_version_number => p_rec.object_version_number
1833: ,p_effective_date => p_effective_date);

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

1831: ,p_previous_employer_id => p_rec.previous_employer_id
1832: ,p_object_version_number => p_rec.object_version_number
1833: ,p_effective_date => p_effective_date);
1834: --
1835: hr_utility.set_location(l_proc, 20);
1836: chk_employer_country(p_previous_employer_id => p_rec.previous_employer_id
1837: ,p_object_version_number => p_rec.object_version_number
1838: ,p_employer_country => p_rec.employer_country);
1839: --

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

1836: chk_employer_country(p_previous_employer_id => p_rec.previous_employer_id
1837: ,p_object_version_number => p_rec.object_version_number
1838: ,p_employer_country => p_rec.employer_country);
1839: --
1840: hr_utility.set_location(l_proc, 25);
1841: chk_employer_type(p_previous_employer_id => p_rec.previous_employer_id
1842: ,p_object_version_number => p_rec.object_version_number
1843: ,p_employer_type => p_rec.employer_type
1844: ,p_effective_date => p_effective_date);

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

1842: ,p_object_version_number => p_rec.object_version_number
1843: ,p_employer_type => p_rec.employer_type
1844: ,p_effective_date => p_effective_date);
1845: --
1846: hr_utility.set_location(l_proc, 30);
1847: chk_employer_subtype(p_previous_employer_id => p_rec.previous_employer_id
1848: ,p_object_version_number => p_rec.object_version_number
1849: ,p_employer_type => p_rec.employer_type
1850: ,p_employer_subtype => p_rec.employer_subtype

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

1849: ,p_employer_type => p_rec.employer_type
1850: ,p_employer_subtype => p_rec.employer_subtype
1851: ,p_effective_date => p_effective_date);
1852: --
1853: hr_utility.set_location(l_proc, 40);
1854: chk_start_end_dates(p_previous_employer_id => p_rec.previous_employer_id
1855: ,p_object_version_number => p_rec.object_version_number
1856: ,p_start_date => p_rec.start_date
1857: ,p_end_date => p_rec.end_date

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

1858: ,p_effective_date => p_effective_date -- bug 7112425
1859: ,p_business_group_id => p_rec.business_group_id -- Bug 14316052
1860: ,p_employer_type => p_rec.employer_type);
1861: --
1862: hr_utility.set_location(l_proc, 45);
1863: chk_period_years(p_period_years
1864: => p_rec.period_years
1865: ,p_previous_employer_id
1866: => p_rec.previous_employer_id

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

1866: => p_rec.previous_employer_id
1867: ,p_object_version_number
1868: => p_rec.object_version_number);
1869: --
1870: hr_utility.set_location(l_proc, 50);
1871: chk_period_months(p_period_months
1872: => p_rec.period_months
1873: ,p_previous_employer_id
1874: => p_rec.previous_employer_id

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

1874: => p_rec.previous_employer_id
1875: ,p_object_version_number
1876: => p_rec.object_version_number);
1877: --
1878: hr_utility.set_location(l_proc, 55);
1879: chk_period_days(p_period_days
1880: => p_rec.period_days
1881: ,p_previous_employer_id
1882: => p_rec.previous_employer_id

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

1882: => p_rec.previous_employer_id
1883: ,p_object_version_number
1884: => p_rec.object_version_number);
1885: --
1886: hr_utility.set_location(l_proc, 60);
1887: chk_all_assignments(p_previous_employer_id => p_rec.previous_employer_id
1888: ,p_object_version_number => p_rec.object_version_number
1889: ,p_all_assignments => p_rec.all_assignments);
1890: --

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

1887: chk_all_assignments(p_previous_employer_id => p_rec.previous_employer_id
1888: ,p_object_version_number => p_rec.object_version_number
1889: ,p_all_assignments => p_rec.all_assignments);
1890: --
1891: hr_utility.set_location(l_proc, 65);
1892: per_pem_bus.chk_ddf(p_rec);
1893: --
1894: hr_utility.set_location(l_proc, 70);
1895: per_pem_bus.chk_df(p_rec);

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

1890: --
1891: hr_utility.set_location(l_proc, 65);
1892: per_pem_bus.chk_ddf(p_rec);
1893: --
1894: hr_utility.set_location(l_proc, 70);
1895: per_pem_bus.chk_df(p_rec);
1896: --
1897: hr_utility.set_location(' Leaving:'||l_proc, 75);
1898: End update_validate;

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

1893: --
1894: hr_utility.set_location(l_proc, 70);
1895: per_pem_bus.chk_df(p_rec);
1896: --
1897: hr_utility.set_location(' Leaving:'||l_proc, 75);
1898: End update_validate;
1899: --
1900: -- ----------------------------------------------------------------------------
1901: -- |---------------------------< delete_validate >----------------------------|

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

1906: --
1907: l_proc varchar2(72) := g_package||'delete_validate';
1908: --
1909: Begin
1910: hr_utility.set_location('Entering:'||l_proc, 5);
1911: --
1912: -- Call all supporting business operations
1913: --
1914: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1910: hr_utility.set_location('Entering:'||l_proc, 5);
1911: --
1912: -- Call all supporting business operations
1913: --
1914: hr_utility.set_location(' Leaving:'||l_proc, 10);
1915: End delete_validate;
1916: --
1917: end per_pem_bus;