APPS.PER_KAD_BUS dependencies on HR_API

Line 59: hr_api.mandatory_arg_error

55: hr_utility.set_location('Entering:'|| l_proc, 1);
56: --
57: -- Check mandatory parameters have been set
58: --
59: hr_api.mandatory_arg_error
60: (p_api_name => l_proc
61: ,p_argument => 'person_id'
62: ,p_argument_value => p_person_id
63: );

Line 129: hr_api.mandatory_arg_error

125: hr_utility.set_location('Entering:'|| l_proc, 1);
126: --
127: -- Check mandatory parameters have been set
128: --
129: hr_api.mandatory_arg_error
130: (p_api_name => l_proc
131: ,p_argument => 'date_from'
132: ,p_argument_value => p_date_from
133: );

Line 134: hr_api.mandatory_arg_error

130: (p_api_name => l_proc
131: ,p_argument => 'date_from'
132: ,p_argument_value => p_date_from
133: );
134: hr_api.mandatory_arg_error
135: (p_api_name => l_proc
136: ,p_argument => 'effective_date'
137: ,p_argument_value => p_effective_date
138: );

Line 149: nvl(per_kad_shd.g_old_rec.address_type, hr_api.g_varchar2) <>

145: (p_address_id => p_address_id
146: ,p_object_version_number => p_object_version_number);
147: --
148: if ((l_api_updating and
149: nvl(per_kad_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
150: nvl(p_address_type, hr_api.g_varchar2)) or
151: (NOT l_api_updating)) then
152: hr_utility.set_location(l_proc, 2);
153: --

Line 150: nvl(p_address_type, hr_api.g_varchar2)) or

146: ,p_object_version_number => p_object_version_number);
147: --
148: if ((l_api_updating and
149: nvl(per_kad_shd.g_old_rec.address_type, hr_api.g_varchar2) <>
150: nvl(p_address_type, hr_api.g_varchar2)) or
151: (NOT l_api_updating)) then
152: hr_utility.set_location(l_proc, 2);
153: --
154: -- Checks that the value for address_type is

Line 160: if hr_api.not_exists_in_hr_lookups

156: -- specified date range
157: --
158: if p_address_type is not null then
159: --
160: if hr_api.not_exists_in_hr_lookups
161: (p_effective_date => p_effective_date
162: ,p_lookup_type => 'ADDRESS_TYPE'
163: ,p_lookup_code => p_address_type
164: ) then

Line 233: nvl(per_kad_shd.g_old_rec.country, hr_api.g_varchar2) <>

229: (p_address_id => p_address_id
230: ,p_object_version_number => p_object_version_number);
231: --
232: if ((l_api_updating and
233: nvl(per_kad_shd.g_old_rec.country, hr_api.g_varchar2) <>
234: nvl(p_country, hr_api.g_varchar2)) or
235: (NOT l_api_updating)) then
236: hr_utility.set_location(l_proc, 2);
237: --

Line 234: nvl(p_country, hr_api.g_varchar2)) or

230: ,p_object_version_number => p_object_version_number);
231: --
232: if ((l_api_updating and
233: nvl(per_kad_shd.g_old_rec.country, hr_api.g_varchar2) <>
234: nvl(p_country, hr_api.g_varchar2)) or
235: (NOT l_api_updating)) then
236: hr_utility.set_location(l_proc, 2);
237: --
238: -- Checks that value for country is a valid

Line 305: hr_api.mandatory_arg_error

301: hr_utility.set_location('Entering:'|| l_proc, 1);
302: --
303: -- Check mandatory parameters have been set
304: --
305: hr_api.mandatory_arg_error
306: (p_api_name => l_proc
307: ,p_argument => 'date_from'
308: ,p_argument_value => p_date_from
309: );

Line 320: nvl(per_kad_shd.g_old_rec.date_to, hr_api.g_eot) <>

316: (p_address_id => p_address_id
317: ,p_object_version_number => p_object_version_number);
318: --
319: if ((l_api_updating and
320: nvl(per_kad_shd.g_old_rec.date_to, hr_api.g_eot) <>
321: nvl(p_date_to, hr_api.g_eot)) or
322: (NOT l_api_updating)) then
323: --
324: hr_utility.set_location(l_proc, 2);

Line 321: nvl(p_date_to, hr_api.g_eot)) or

317: ,p_object_version_number => p_object_version_number);
318: --
319: if ((l_api_updating and
320: nvl(per_kad_shd.g_old_rec.date_to, hr_api.g_eot) <>
321: nvl(p_date_to, hr_api.g_eot)) or
322: (NOT l_api_updating)) then
323: --
324: hr_utility.set_location(l_proc, 2);
325: --

Line 330: if nvl(p_date_to, hr_api.g_eot) < p_date_from then

326: -- Checks that the value for date_to is greater than or
327: -- equal to the corresponding value for date_from for the
328: -- same record
329: --
330: if nvl(p_date_to, hr_api.g_eot) < p_date_from then
331: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
332: hr_utility.raise_error;
333: end if;
334: --

Line 385: hr_api.mandatory_arg_error

381: hr_utility.set_location('Entering:'|| l_proc, 1);
382: --
383: -- Check mandatory parameters have been set
384: --
385: hr_api.mandatory_arg_error
386: (p_api_name => l_proc
387: ,p_argument => 'date_from'
388: ,p_argument_value => p_date_from
389: );

Line 407: if p_date_from > nvl(p_date_to, hr_api.g_eot) then

403: -- Check that the date_from values is less than
404: -- or equal to the date_to value for the current
405: -- record
406: --
407: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
408: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');
409: hr_utility.raise_error;
410: end if;
411: --

Line 479: hr_api.mandatory_arg_error

475: hr_utility.set_location('Entering:'|| l_proc, 1);
476: --
477: -- Check mandatory parameters have been set
478: --
479: hr_api.mandatory_arg_error
480: (p_api_name => l_proc
481: ,p_argument => 'style'
482: ,p_argument_value => p_style
483: );

Line 594: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)

590: ,p_object_version_number => p_object_version_number
591: );
592: --
593: if p_region_3 is not null
594: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
595: = nvl(p_region_3, hr_api.g_varchar2)
596: then
597: --
598: null;

Line 595: = nvl(p_region_3, hr_api.g_varchar2)

591: );
592: --
593: if p_region_3 is not null
594: and nvl(per_add_shd.g_old_rec.region_3, hr_api.g_varchar2)
595: = nvl(p_region_3, hr_api.g_varchar2)
596: then
597: --
598: null;
599: --

Line 610: nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)

606: --
607: -- Check if telephone number 3 is set but is unchanged on update
608: --
609: if p_telephone_number_3 is not null and
610: nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
611: = nvl(p_telephone_number_3, hr_api.g_varchar2)
612: then
613: --
614: null;

Line 611: = nvl(p_telephone_number_3, hr_api.g_varchar2)

607: -- Check if telephone number 3 is set but is unchanged on update
608: --
609: if p_telephone_number_3 is not null and
610: nvl(per_add_shd.g_old_rec.telephone_number_3, hr_api.g_varchar2)
611: = nvl(p_telephone_number_3, hr_api.g_varchar2)
612: then
613: --
614: null;
615: --

Line 692: hr_api.mandatory_arg_error

688: hr_utility.set_location('Entering:'|| l_proc, 1);
689: --
690: -- Check mandatory parameters have been set
691: --
692: hr_api.mandatory_arg_error
693: (p_api_name => l_proc
694: ,p_argument => 'style'
695: ,p_argument_value => p_style
696: );

Line 707: nvl(per_kad_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>

703: (p_address_id => p_address_id
704: ,p_object_version_number => p_object_version_number);
705: --
706: if ((l_api_updating and
707: nvl(per_kad_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>
708: nvl(p_address_line1, hr_api.g_varchar2)) or
709: (NOT l_api_updating)) then
710: hr_utility.set_location(l_proc, 2);
711: --

Line 708: nvl(p_address_line1, hr_api.g_varchar2)) or

704: ,p_object_version_number => p_object_version_number);
705: --
706: if ((l_api_updating and
707: nvl(per_kad_shd.g_old_rec.address_line1, hr_api.g_varchar2) <>
708: nvl(p_address_line1, hr_api.g_varchar2)) or
709: (NOT l_api_updating)) then
710: hr_utility.set_location(l_proc, 2);
711: --
712: -- Check that value for address_line1 is not null for 'US' and 'GB'

Line 803: (nvl(per_kad_shd_t.g_old_rec.town_or_city, hr_api.g_varchar2) <>

799: (p_address_id => p_address_id
800: ,p_object_version_number => p_object_version_number);
801:
802: if ((l_api_updating and
803: (nvl(per_kad_shd_t.g_old_rec.town_or_city, hr_api.g_varchar2) <>
804: nvl(p_town_or_city, hr_api.g_varchar2) or
805: nvl(per_kad_shd_t.g_old_rec.address_line1, hr_api.g_varchar2) <>
806: nvl(p_address_line1, hr_api.g_varchar2) or
807: nvl(per_kad_shd_t.g_old_rec.region_1, hr_api.g_varchar2) <>

Line 804: nvl(p_town_or_city, hr_api.g_varchar2) or

800: ,p_object_version_number => p_object_version_number);
801:
802: if ((l_api_updating and
803: (nvl(per_kad_shd_t.g_old_rec.town_or_city, hr_api.g_varchar2) <>
804: nvl(p_town_or_city, hr_api.g_varchar2) or
805: nvl(per_kad_shd_t.g_old_rec.address_line1, hr_api.g_varchar2) <>
806: nvl(p_address_line1, hr_api.g_varchar2) or
807: nvl(per_kad_shd_t.g_old_rec.region_1, hr_api.g_varchar2) <>
808: nvl(p_region_1, hr_api.g_varchar2)

Line 805: nvl(per_kad_shd_t.g_old_rec.address_line1, hr_api.g_varchar2) <>

801:
802: if ((l_api_updating and
803: (nvl(per_kad_shd_t.g_old_rec.town_or_city, hr_api.g_varchar2) <>
804: nvl(p_town_or_city, hr_api.g_varchar2) or
805: nvl(per_kad_shd_t.g_old_rec.address_line1, hr_api.g_varchar2) <>
806: nvl(p_address_line1, hr_api.g_varchar2) or
807: nvl(per_kad_shd_t.g_old_rec.region_1, hr_api.g_varchar2) <>
808: nvl(p_region_1, hr_api.g_varchar2)
809: )) or (NOT l_api_updating)) then

Line 806: nvl(p_address_line1, hr_api.g_varchar2) or

802: if ((l_api_updating and
803: (nvl(per_kad_shd_t.g_old_rec.town_or_city, hr_api.g_varchar2) <>
804: nvl(p_town_or_city, hr_api.g_varchar2) or
805: nvl(per_kad_shd_t.g_old_rec.address_line1, hr_api.g_varchar2) <>
806: nvl(p_address_line1, hr_api.g_varchar2) or
807: nvl(per_kad_shd_t.g_old_rec.region_1, hr_api.g_varchar2) <>
808: nvl(p_region_1, hr_api.g_varchar2)
809: )) or (NOT l_api_updating)) then
810:

Line 807: nvl(per_kad_shd_t.g_old_rec.region_1, hr_api.g_varchar2) <>

803: (nvl(per_kad_shd_t.g_old_rec.town_or_city, hr_api.g_varchar2) <>
804: nvl(p_town_or_city, hr_api.g_varchar2) or
805: nvl(per_kad_shd_t.g_old_rec.address_line1, hr_api.g_varchar2) <>
806: nvl(p_address_line1, hr_api.g_varchar2) or
807: nvl(per_kad_shd_t.g_old_rec.region_1, hr_api.g_varchar2) <>
808: nvl(p_region_1, hr_api.g_varchar2)
809: )) or (NOT l_api_updating)) then
810:
811: hr_utility.set_location(l_proc, 2);

Line 808: nvl(p_region_1, hr_api.g_varchar2)

804: nvl(p_town_or_city, hr_api.g_varchar2) or
805: nvl(per_kad_shd_t.g_old_rec.address_line1, hr_api.g_varchar2) <>
806: nvl(p_address_line1, hr_api.g_varchar2) or
807: nvl(per_kad_shd_t.g_old_rec.region_1, hr_api.g_varchar2) <>
808: nvl(p_region_1, hr_api.g_varchar2)
809: )) or (NOT l_api_updating)) then
810:
811: hr_utility.set_location(l_proc, 2);
812:

Line 885: (nvl(per_kad_shd_t.g_old_rec.address_line2, hr_api.g_varchar2) <>

881: (p_address_id => p_address_id
882: ,p_object_version_number => p_object_version_number);
883:
884: if ((l_api_updating and
885: (nvl(per_kad_shd_t.g_old_rec.address_line2, hr_api.g_varchar2) <>
886: nvl(p_address_line2, hr_api.g_varchar2) or
887: nvl(per_kad_shd_t.g_old_rec.region_2, hr_api.g_varchar2) <>
888: nvl(p_region_2, hr_api.g_varchar2)
889: )) or (NOT l_api_updating)) then

Line 886: nvl(p_address_line2, hr_api.g_varchar2) or

882: ,p_object_version_number => p_object_version_number);
883:
884: if ((l_api_updating and
885: (nvl(per_kad_shd_t.g_old_rec.address_line2, hr_api.g_varchar2) <>
886: nvl(p_address_line2, hr_api.g_varchar2) or
887: nvl(per_kad_shd_t.g_old_rec.region_2, hr_api.g_varchar2) <>
888: nvl(p_region_2, hr_api.g_varchar2)
889: )) or (NOT l_api_updating)) then
890:

Line 887: nvl(per_kad_shd_t.g_old_rec.region_2, hr_api.g_varchar2) <>

883:
884: if ((l_api_updating and
885: (nvl(per_kad_shd_t.g_old_rec.address_line2, hr_api.g_varchar2) <>
886: nvl(p_address_line2, hr_api.g_varchar2) or
887: nvl(per_kad_shd_t.g_old_rec.region_2, hr_api.g_varchar2) <>
888: nvl(p_region_2, hr_api.g_varchar2)
889: )) or (NOT l_api_updating)) then
890:
891: hr_utility.set_location(l_proc, 2);

Line 888: nvl(p_region_2, hr_api.g_varchar2)

884: if ((l_api_updating and
885: (nvl(per_kad_shd_t.g_old_rec.address_line2, hr_api.g_varchar2) <>
886: nvl(p_address_line2, hr_api.g_varchar2) or
887: nvl(per_kad_shd_t.g_old_rec.region_2, hr_api.g_varchar2) <>
888: nvl(p_region_2, hr_api.g_varchar2)
889: )) or (NOT l_api_updating)) then
890:
891: hr_utility.set_location(l_proc, 2);
892:

Line 931: (nvl(per_kad_shd_t.g_old_rec.address_line3, hr_api.g_varchar2) <>

927: (p_address_id => p_address_id
928: ,p_object_version_number => p_object_version_number);
929:
930: if ((l_api_updating and
931: (nvl(per_kad_shd_t.g_old_rec.address_line3, hr_api.g_varchar2) <>
932: nvl(p_address_line3, hr_api.g_varchar2) or
933: nvl(per_kad_shd_t.g_old_rec.region_3, hr_api.g_varchar2) <>
934: nvl(p_region_3, hr_api.g_varchar2)
935: )) or (NOT l_api_updating)) then

Line 932: nvl(p_address_line3, hr_api.g_varchar2) or

928: ,p_object_version_number => p_object_version_number);
929:
930: if ((l_api_updating and
931: (nvl(per_kad_shd_t.g_old_rec.address_line3, hr_api.g_varchar2) <>
932: nvl(p_address_line3, hr_api.g_varchar2) or
933: nvl(per_kad_shd_t.g_old_rec.region_3, hr_api.g_varchar2) <>
934: nvl(p_region_3, hr_api.g_varchar2)
935: )) or (NOT l_api_updating)) then
936:

Line 933: nvl(per_kad_shd_t.g_old_rec.region_3, hr_api.g_varchar2) <>

929:
930: if ((l_api_updating and
931: (nvl(per_kad_shd_t.g_old_rec.address_line3, hr_api.g_varchar2) <>
932: nvl(p_address_line3, hr_api.g_varchar2) or
933: nvl(per_kad_shd_t.g_old_rec.region_3, hr_api.g_varchar2) <>
934: nvl(p_region_3, hr_api.g_varchar2)
935: )) or (NOT l_api_updating)) then
936:
937: hr_utility.set_location(l_proc, 2);

Line 934: nvl(p_region_3, hr_api.g_varchar2)

930: if ((l_api_updating and
931: (nvl(per_kad_shd_t.g_old_rec.address_line3, hr_api.g_varchar2) <>
932: nvl(p_address_line3, hr_api.g_varchar2) or
933: nvl(per_kad_shd_t.g_old_rec.region_3, hr_api.g_varchar2) <>
934: nvl(p_region_3, hr_api.g_varchar2)
935: )) or (NOT l_api_updating)) then
936:
937: hr_utility.set_location(l_proc, 2);
938:

Line 1068: hr_api.mandatory_arg_error

1064: hr_utility.set_location('Entering:'|| l_proc, 1);
1065: --
1066: -- Check mandatory parameters have been set
1067: --
1068: hr_api.mandatory_arg_error
1069: (p_api_name => l_proc
1070: ,p_argument => 'style'
1071: ,p_argument_value => p_style
1072: );

Line 1083: and nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>

1079: (p_address_id => p_address_id
1080: ,p_object_version_number => p_object_version_number);
1081: --
1082: if ((l_api_updating
1083: and nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1084: nvl(p_postal_code, hr_api.g_varchar2)) or
1085: (NOT l_api_updating)) then
1086: hr_utility.set_location(l_proc, 2);
1087: --

Line 1084: nvl(p_postal_code, hr_api.g_varchar2)) or

1080: ,p_object_version_number => p_object_version_number);
1081: --
1082: if ((l_api_updating
1083: and nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1084: nvl(p_postal_code, hr_api.g_varchar2)) or
1085: (NOT l_api_updating)) then
1086: hr_utility.set_location(l_proc, 2);
1087: --
1088: -- Check if US payroll is installed.

Line 1256: hr_api.mandatory_arg_error

1252: hr_utility.set_location('Entering:'|| l_proc, 1);
1253: --
1254: -- Check mandatory parameters have been set
1255: --
1256: hr_api.mandatory_arg_error
1257: (p_api_name => l_proc
1258: ,p_argument => 'style'
1259: ,p_argument_value => p_style
1260: );

Line 1262: hr_api.mandatory_arg_error

1258: ,p_argument => 'style'
1259: ,p_argument_value => p_style
1260: );
1261: --
1262: hr_api.mandatory_arg_error
1263: (p_api_name => l_proc
1264: ,p_argument => 'effective_date'
1265: ,p_argument_value => p_effective_date
1266: );

Line 1277: nvl(per_kad_shd.g_old_rec.region_1, hr_api.g_varchar2) <>

1273: (p_address_id => p_address_id
1274: ,p_object_version_number => p_object_version_number);
1275: --
1276: if ((l_api_updating and
1277: nvl(per_kad_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1278: nvl(p_region_1, hr_api.g_varchar2)) or
1279: (NOT l_api_updating)) then
1280: hr_utility.set_location(l_proc, 2);
1281: --

Line 1278: nvl(p_region_1, hr_api.g_varchar2)) or

1274: ,p_object_version_number => p_object_version_number);
1275: --
1276: if ((l_api_updating and
1277: nvl(per_kad_shd.g_old_rec.region_1, hr_api.g_varchar2) <>
1278: nvl(p_region_1, hr_api.g_varchar2)) or
1279: (NOT l_api_updating)) then
1280: hr_utility.set_location(l_proc, 2);
1281: --
1282: -- Check that value for region_1 is valid

Line 1290: if hr_api.not_exists_in_hr_lookups

1286: --
1287: if p_style = 'GB' then
1288: hr_utility.set_location(l_proc, 4);
1289: --
1290: if hr_api.not_exists_in_hr_lookups
1291: (p_effective_date => p_effective_date
1292: ,p_lookup_type => 'GB_COUNTY'
1293: ,p_lookup_code => p_region_1
1294: ) then

Line 1388: hr_api.mandatory_arg_error

1384: hr_utility.set_location('Entering:'|| l_proc, 1);
1385: --
1386: -- Check mandatory parameters have been set.
1387: --
1388: hr_api.mandatory_arg_error
1389: (p_api_name => l_proc
1390: ,p_argument => 'style'
1391: ,p_argument_value => p_style
1392: );

Line 1394: hr_api.mandatory_arg_error

1390: ,p_argument => 'style'
1391: ,p_argument_value => p_style
1392: );
1393: --
1394: hr_api.mandatory_arg_error
1395: (p_api_name => l_proc
1396: ,p_argument => 'effective_date'
1397: ,p_argument_value => p_effective_date
1398: );

Line 1409: nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>

1405: (p_address_id => p_address_id
1406: ,p_object_version_number => p_object_version_number);
1407: --
1408: if ((l_api_updating and
1409: nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1410: nvl(p_region_2, hr_api.g_varchar2)) or
1411: (NOT l_api_updating)) then
1412: hr_utility.set_location(l_proc, 2);
1413: --

Line 1410: nvl(p_region_2, hr_api.g_varchar2)) or

1406: ,p_object_version_number => p_object_version_number);
1407: --
1408: if ((l_api_updating and
1409: nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1410: nvl(p_region_2, hr_api.g_varchar2)) or
1411: (NOT l_api_updating)) then
1412: hr_utility.set_location(l_proc, 2);
1413: --
1414: -- Check if US payroll is installed.

Line 1431: if hr_api.not_exists_in_hr_lookups

1427: if p_style = 'US'
1428: and l_geocodes_installed = 'N' then -- 09/12/97 Changed
1429: hr_utility.set_location(l_proc, 4);
1430: --
1431: if hr_api.not_exists_in_hr_lookups
1432: (p_effective_date => p_effective_date
1433: ,p_lookup_type => 'US_STATE'
1434: ,p_lookup_code => p_region_2
1435: ) then

Line 1521: hr_api.mandatory_arg_error

1517: hr_utility.set_location('Entering:'|| l_proc, 1);
1518: --
1519: -- Check mandatory parameters have been set
1520: --
1521: hr_api.mandatory_arg_error
1522: (p_api_name => l_proc
1523: ,p_argument => 'style'
1524: ,p_argument_value => p_style
1525: );

Line 1536: nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

1532: (p_address_id => p_address_id
1533: ,p_object_version_number => p_object_version_number);
1534: --
1535: if ((l_api_updating and
1536: nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1537: nvl(p_town_or_city, hr_api.g_varchar2)) or
1538: (NOT l_api_updating)) then
1539: hr_utility.set_location(l_proc, 2);
1540: --

Line 1537: nvl(p_town_or_city, hr_api.g_varchar2)) or

1533: ,p_object_version_number => p_object_version_number);
1534: --
1535: if ((l_api_updating and
1536: nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1537: nvl(p_town_or_city, hr_api.g_varchar2)) or
1538: (NOT l_api_updating)) then
1539: hr_utility.set_location(l_proc, 2);
1540: --
1541: --

Line 1648: (nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>

1644: (p_address_id => p_address_id
1645: ,p_object_version_number => p_object_version_number);
1646: --
1647: if ((l_api_updating and
1648: (nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1649: nvl(p_region_2, hr_api.g_varchar2)) or
1650: (nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1651: nvl(p_postal_code, hr_api.g_varchar2)) or
1652: (nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

Line 1649: nvl(p_region_2, hr_api.g_varchar2)) or

1645: ,p_object_version_number => p_object_version_number);
1646: --
1647: if ((l_api_updating and
1648: (nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1649: nvl(p_region_2, hr_api.g_varchar2)) or
1650: (nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1651: nvl(p_postal_code, hr_api.g_varchar2)) or
1652: (nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1653: nvl(p_town_or_city, hr_api.g_varchar2))) or

Line 1650: (nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>

1646: --
1647: if ((l_api_updating and
1648: (nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1649: nvl(p_region_2, hr_api.g_varchar2)) or
1650: (nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1651: nvl(p_postal_code, hr_api.g_varchar2)) or
1652: (nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1653: nvl(p_town_or_city, hr_api.g_varchar2))) or
1654: (NOT l_api_updating)) then

Line 1651: nvl(p_postal_code, hr_api.g_varchar2)) or

1647: if ((l_api_updating and
1648: (nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1649: nvl(p_region_2, hr_api.g_varchar2)) or
1650: (nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1651: nvl(p_postal_code, hr_api.g_varchar2)) or
1652: (nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1653: nvl(p_town_or_city, hr_api.g_varchar2))) or
1654: (NOT l_api_updating)) then
1655: --

Line 1652: (nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>

1648: (nvl(per_kad_shd.g_old_rec.region_2, hr_api.g_varchar2) <>
1649: nvl(p_region_2, hr_api.g_varchar2)) or
1650: (nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1651: nvl(p_postal_code, hr_api.g_varchar2)) or
1652: (nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1653: nvl(p_town_or_city, hr_api.g_varchar2))) or
1654: (NOT l_api_updating)) then
1655: --
1656: hr_utility.set_location(l_proc, 2);

Line 1653: nvl(p_town_or_city, hr_api.g_varchar2))) or

1649: nvl(p_region_2, hr_api.g_varchar2)) or
1650: (nvl(per_kad_shd.g_old_rec.postal_code, hr_api.g_varchar2) <>
1651: nvl(p_postal_code, hr_api.g_varchar2)) or
1652: (nvl(per_kad_shd.g_old_rec.town_or_city, hr_api.g_varchar2) <>
1653: nvl(p_town_or_city, hr_api.g_varchar2))) or
1654: (NOT l_api_updating)) then
1655: --
1656: hr_utility.set_location(l_proc, 2);
1657: --

Line 1761: l_date := nvl(per_kad_shd.g_old_rec.date_to, hr_api.g_eot);

1757: and pa2.person_id = per_kad_shd.g_old_rec.person_id
1758: and pa2.primary_flag = 'Y');
1759: --
1760: begin
1761: l_date := nvl(per_kad_shd.g_old_rec.date_to, hr_api.g_eot);
1762: hr_utility.set_location('Entering:'|| l_proc, 1);
1763: --
1764: -- For primary addresses only
1765: -- ==========================

Line 1851: if nvl(p_rec.business_group_id, hr_api.g_number) <>

1847: end if;
1848: --
1849: hr_utility.set_location(l_proc, 6);
1850: --
1851: if nvl(p_rec.business_group_id, hr_api.g_number) <>
1852: per_kad_shd.g_old_rec.business_group_id then
1853: l_argument := 'business_group_id';
1854: raise l_error;
1855: end if;

Line 1858: if nvl(p_rec.person_id, hr_api.g_number) <>

1854: raise l_error;
1855: end if;
1856: hr_utility.set_location(l_proc, 7);
1857: --
1858: if nvl(p_rec.person_id, hr_api.g_number) <>
1859: per_kad_shd.g_old_rec.person_id then
1860: l_argument := 'person_id';
1861: raise l_error;
1862: end if;

Line 1865: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>

1861: raise l_error;
1862: end if;
1863: hr_utility.set_location(l_proc, 8);
1864: --
1865: if nvl(p_rec.primary_flag, hr_api.g_varchar2) <>
1866: per_kad_shd.g_old_rec.primary_flag then
1867: l_argument := 'primary_flag';
1868: raise l_error;
1869: end if;

Line 1872: if nvl(p_rec.style, hr_api.g_varchar2) <>

1868: raise l_error;
1869: end if;
1870: hr_utility.set_location(l_proc, 10);
1871: --
1872: if nvl(p_rec.style, hr_api.g_varchar2) <>
1873: per_kad_shd.g_old_rec.style then
1874: l_argument := 'style';
1875: raise l_error;
1876: end if;

Line 1881: hr_api.argument_changed_error

1877: hr_utility.set_location(l_proc, 11);
1878: --
1879: exception
1880: when l_error then
1881: hr_api.argument_changed_error
1882: (p_api_name => l_proc
1883: ,p_argument => l_argument);
1884: when others then
1885: raise;

Line 1911: hr_api.validate_bus_grp_id(p_rec.business_group_id);

1907: -- Call all supporting business operations.
1908: --
1909: -- Validate business group id
1910: --
1911: hr_api.validate_bus_grp_id(p_rec.business_group_id);
1912: --
1913: hr_utility.set_location(l_proc, 6);
1914: --
1915: -- Validate date from

Line 2141: hr_api.validate_bus_grp_id(p_rec.business_group_id);

2137: -- appropriate Business Rules in peradd.bru is provided.
2138: --
2139: -- Validate business group id
2140: --
2141: hr_api.validate_bus_grp_id(p_rec.business_group_id);
2142: --
2143: -- Check that the columns which cannot
2144: -- be updated have not changed
2145: --

Line 2349: hr_api.validate_bus_grp_id(p_rec.business_group_id);

2345: -- appropriate business rules on peradd.bru is provided
2346: --
2347: -- Validate business group id
2348: --
2349: hr_api.validate_bus_grp_id(p_rec.business_group_id);
2350: --
2351: -- Check that deletion of a primary address is not allowed
2352: -- if non primary addresses exist within the same date range
2353: -- as the primary address