[Home] [Help]
117: between adr.date_from
118: and nvl(adr.date_to,hr_api.g_eot);
119: --
120: begin
121: hr_utility.set_location('Entering:'|| l_proc, 5);
122: --
123: -- Issue a savepoint.
124: --
125: savepoint create_person_address;
143: (p_api_name => l_proc,
144: p_argument => 'effective_date',
145: p_argument_value => p_effective_date);
146: --
147: hr_utility.set_location(l_proc, 6);
148: --
149: l_date_from := trunc(p_date_from);
150: l_date_to := trunc(p_date_to);
151: l_effective_date := trunc(p_effective_date);
230: fetch csr_bus_grp into l_business_group_id;
231: --
232: if csr_bus_grp%notfound then
233: close csr_bus_grp;
234: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');
235: hr_utility.raise_error;
236: end if;
237: close csr_bus_grp;
238: end if;
231: --
232: if csr_bus_grp%notfound then
233: close csr_bus_grp;
234: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');
235: hr_utility.raise_error;
236: end if;
237: close csr_bus_grp;
238: end if;
239: hr_utility.set_location(l_proc, 70);
235: hr_utility.raise_error;
236: end if;
237: close csr_bus_grp;
238: end if;
239: hr_utility.set_location(l_proc, 70);
240: --
241: -- Check if primary address overlap validation override mode is on
242: --
243: if p_pradd_ovlapval_override
272: --
273: end if;
274: --
275: end if;
276: hr_utility.set_location(l_proc, 80);
277: --
278: -- Insert Person Address details.
279: --
280: per_add_ins.ins
334: ,p_validate_county => p_validate_county
335: ,p_party_id => p_party_id -- HR/TCA merge
336: );
337: --
338: hr_utility.set_location(l_proc, 8);
339: begin
340: --
341: -- Start of API User Hook for the after hook of create_person_address
342: --
417: --
418: p_address_id := l_address_id;
419: p_object_version_number := l_object_version_number;
420: --
421: hr_utility.set_location(' Leaving:'||l_proc, 11);
422: exception
423: when hr_api.validate_enabled then
424: --
425: -- As the Validate_Enabled exception has been raised
511: --
512: l_proc varchar2(72) := g_package||'create_gb_person_address';
513: --
514: begin
515: hr_utility.set_location('Entering:'|| l_proc, 5);
516: --
517: -- Create Person Address details.
518: --
519: hr_person_address_api.create_person_address
569: ,p_object_version_number => p_object_version_number
570: ,p_party_id => p_party_id -- HR/TCA merge
571: );
572: --
573: hr_utility.set_location(' Leaving:'||l_proc, 10);
574: end create_gb_person_address;
575: --
576: -- ----------------------------------------------------------------------------
577: -- |-----------------------< create_us_person_address >-----------------------|
636: --
637: l_proc varchar2(72) := g_package||'create_us_person_address';
638: --
639: begin
640: hr_utility.set_location('Entering:'|| l_proc, 5);
641: --
642: -- Create Person Address details.
643: --
644: hr_person_address_api.create_person_address
696: ,p_address_id => p_address_id
697: ,p_object_version_number => p_object_version_number
698: );
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 10);
701: end create_us_person_address;
702: --
703: -- ----------------------------------------------------------------------------
704: -- |-----------------------< create_AT_person_address >-----------------------|
761: --
762: l_proc varchar2(72) := g_package||'create_AT_person_address';
763: --
764: begin
765: hr_utility.set_location('Entering:'|| l_proc, 5);
766: --
767: -- Create Person Address details.
768: --
769: hr_person_address_api.create_person_address
819: ,p_address_id => p_address_id
820: ,p_object_version_number => p_object_version_number
821: );
822: --
823: hr_utility.set_location(' Leaving:'||l_proc, 10);
824: end create_AT_person_address;
825: --
826: -- ----------------------------------------------------------------------------
827: -- |-----------------------< create_AU_person_address >-----------------------|
884: --
885: l_proc varchar2(72) := g_package||'create_AU_person_address';
886: --
887: begin
888: hr_utility.set_location('Entering:'|| l_proc, 5);
889: --
890: -- Create Person Address details.
891: --
892: hr_person_address_api.create_person_address
942: ,p_address_id => p_address_id
943: ,p_object_version_number => p_object_version_number
944: );
945: --
946: hr_utility.set_location(' Leaving:'||l_proc, 10);
947: end create_AU_person_address;
948: --
949: -- ----------------------------------------------------------------------------
950: -- |-----------------------< create_AU_LOC_person_address >-----------------------|
1006: --
1007: l_proc varchar2(72) := g_package||'create_AU_LOC_person_address';
1008: --
1009: begin
1010: hr_utility.set_location('Entering:'|| l_proc, 5);
1011: --
1012: -- Create Person Address details.
1013: --
1014: hr_person_address_api.create_person_address
1063: ,p_address_id => p_address_id
1064: ,p_object_version_number => p_object_version_number
1065: );
1066: --
1067: hr_utility.set_location(' Leaving:'||l_proc, 10);
1068: end create_AU_LOC_person_address;
1069: --
1070: -- ----------------------------------------------------------------------------
1071: -- |-----------------------< create_DK_person_address >-----------------------|
1127: --
1128: l_proc varchar2(72) := g_package||'create_DK_person_address';
1129: --
1130: begin
1131: hr_utility.set_location('Entering:'|| l_proc, 5);
1132: --
1133: -- Create Person Address details.
1134: --
1135: hr_person_address_api.create_person_address
1184: ,p_address_id => p_address_id
1185: ,p_object_version_number => p_object_version_number
1186: );
1187: --
1188: hr_utility.set_location(' Leaving:'||l_proc, 10);
1189: end create_DK_person_address;
1190: --
1191: -- ----------------------------------------------------------------------------
1192: -- |-----------------------< create_DE_person_address >-----------------------|
1249: --
1250: l_proc varchar2(72) := g_package||'create_DE_person_address';
1251: --
1252: begin
1253: hr_utility.set_location('Entering:'|| l_proc, 5);
1254: --
1255: -- Create Person Address details.
1256: --
1257: hr_person_address_api.create_person_address
1307: ,p_address_id => p_address_id
1308: ,p_object_version_number => p_object_version_number
1309: );
1310: --
1311: hr_utility.set_location(' Leaving:'||l_proc, 10);
1312: end create_DE_person_address;
1313: --
1314: -- ----------------------------------------------------------------------------
1315: -- |-----------------------< create_IT_person_address >-----------------------|
1372: --
1373: l_proc varchar2(72) := g_package||'create_IT_person_address';
1374: --
1375: begin
1376: hr_utility.set_location('Entering:'|| l_proc, 5);
1377: --
1378: -- Create Person Address details.
1379: --
1380: hr_person_address_api.create_person_address
1430: ,p_address_id => p_address_id
1431: ,p_object_version_number => p_object_version_number
1432: );
1433: --
1434: hr_utility.set_location(' Leaving:'||l_proc, 10);
1435: end create_IT_person_address;
1436: --
1437: -- ----------------------------------------------------------------------------
1438: -- |-----------------------< create_MX_person_address >-----------------------|
1495: --
1496: l_proc varchar2(72) := g_package||'create_MX_person_address';
1497: --
1498: begin
1499: hr_utility.set_location('Entering:'|| l_proc, 5);
1500: --
1501: -- Create Person Address details.
1502: --
1503: hr_person_address_api.create_person_address
1553: ,p_address_id => p_address_id
1554: ,p_object_version_number => p_object_version_number
1555: );
1556: --
1557: hr_utility.set_location(' Leaving:'||l_proc, 10);
1558: end create_MX_person_address;
1559:
1560: --
1561: -- --------------------------------------------------------------------------
1619: --
1620: l_proc varchar2(72) := g_package||'create_MX_LOC_person_address';
1621: --
1622: begin
1623: hr_utility.set_location('Entering:'|| l_proc, 5);
1624: --
1625: -- Create Person Address details.
1626: --
1627: hr_person_address_api.create_person_address
1677: ,p_address_id => p_address_id
1678: ,p_object_version_number => p_object_version_number
1679: );
1680: --
1681: hr_utility.set_location(' Leaving:'||l_proc, 10);
1682: end create_MX_LOC_person_address;
1683:
1684: --
1685: -- ----------------------------------------------------------------------------
1743: --
1744: l_proc varchar2(72) := g_package||'create_MY_person_address';
1745: --
1746: begin
1747: hr_utility.set_location('Entering:'|| l_proc, 5);
1748: --
1749: -- Create Person Address details.
1750: --
1751: hr_person_address_api.create_person_address
1801: ,p_address_id => p_address_id
1802: ,p_object_version_number => p_object_version_number
1803: );
1804: --
1805: hr_utility.set_location(' Leaving:'||l_proc, 10);
1806: end create_MY_person_address;
1807: --
1808: -- ----------------------------------------------------------------------------
1809: -- |-----------------------< create_PT_person_address >-----------------------|
1865: --
1866: l_proc varchar2(72) := g_package||'create_PT_person_address';
1867: --
1868: begin
1869: hr_utility.set_location('Entering:'|| l_proc, 5);
1870: --
1871: -- Create Person Address details.
1872: --
1873: hr_person_address_api.create_person_address
1922: ,p_address_id => p_address_id
1923: ,p_object_version_number => p_object_version_number
1924: );
1925: --
1926: hr_utility.set_location(' Leaving:'||l_proc, 10);
1927: end create_PT_person_address;
1928: --
1929: -- ----------------------------------------------------------------------------
1930: -- |-----------------------< create_BE_person_address >-----------------------|
1986: --
1987: l_proc varchar2(72) := g_package||'create_BE_person_address';
1988: --
1989: begin
1990: hr_utility.set_location('Entering:'|| l_proc, 5);
1991: --
1992: -- Create Person Address details.
1993: --
1994: hr_person_address_api.create_person_address
2043: ,p_address_id => p_address_id
2044: ,p_object_version_number => p_object_version_number
2045: );
2046: --
2047: hr_utility.set_location(' Leaving:'||l_proc, 10);
2048: end create_BE_person_address;
2049: --
2050: -- ----------------------------------------------------------------------------
2051: -- |-----------------------< create_FI_person_address >-----------------------|
2107: --
2108: l_proc varchar2(72) := g_package||'create_FI_person_address';
2109: --
2110: begin
2111: hr_utility.set_location('Entering:'|| l_proc, 5);
2112: --
2113: -- Create Person Address details.
2114: --
2115: hr_person_address_api.create_person_address
2164: ,p_address_id => p_address_id
2165: ,p_object_version_number => p_object_version_number
2166: );
2167: --
2168: hr_utility.set_location(' Leaving:'||l_proc, 10);
2169: end create_FI_person_address;
2170: --
2171: -- ----------------------------------------------------------------------------
2172: -- |-----------------------< create_GR_person_address >-----------------------|
2228: --
2229: l_proc varchar2(72) := g_package||'create_GR_person_address';
2230: --
2231: begin
2232: hr_utility.set_location('Entering:'|| l_proc, 5);
2233: --
2234: -- Create Person Address details.
2235: --
2236: hr_person_address_api.create_person_address
2285: ,p_address_id => p_address_id
2286: ,p_object_version_number => p_object_version_number
2287: );
2288: --
2289: hr_utility.set_location(' Leaving:'||l_proc, 10);
2290: end create_GR_person_address;
2291: --
2292: -- ----------------------------------------------------------------------------
2293: -- |-----------------------< create_HK_person_address >-----------------------|
2348: --
2349: l_proc varchar2(72) := g_package||'create_HK_person_address';
2350: --
2351: begin
2352: hr_utility.set_location('Entering:'|| l_proc, 5);
2353: --
2354: -- Create Person Address details.
2355: --
2356: hr_person_address_api.create_person_address
2404: ,p_address_id => p_address_id
2405: ,p_object_version_number => p_object_version_number
2406: );
2407: --
2408: hr_utility.set_location(' Leaving:'||l_proc, 10);
2409: end create_HK_person_address;
2410: --
2411: -- ----------------------------------------------------------------------------
2412: -- |-----------------------< create_IE_person_address >-----------------------|
2469: --
2470: l_proc varchar2(72) := g_package||'create_IE_person_address';
2471: --
2472: begin
2473: hr_utility.set_location('Entering:'|| l_proc, 5);
2474: --
2475: -- Create Person Address details.
2476: --
2477: hr_person_address_api.create_person_address
2527: ,p_address_id => p_address_id
2528: ,p_object_version_number => p_object_version_number
2529: );
2530: --
2531: hr_utility.set_location(' Leaving:'||l_proc, 10);
2532: end create_IE_person_address;
2533: --
2534: -- ----------------------------------------------------------------------------
2535: -- |-----------------------< create_LU_person_address >-----------------------|
2591: --
2592: l_proc varchar2(72) := g_package||'create_LU_person_address';
2593: --
2594: begin
2595: hr_utility.set_location('Entering:'|| l_proc, 5);
2596: --
2597: -- Create Person Address details.
2598: --
2599: hr_person_address_api.create_person_address
2648: ,p_address_id => p_address_id
2649: ,p_object_version_number => p_object_version_number
2650: );
2651: --
2652: hr_utility.set_location(' Leaving:'||l_proc, 10);
2653: end create_LU_person_address;
2654: --
2655: -- ----------------------------------------------------------------------------
2656: -- |-----------------------< create_NL_person_address >-----------------------|
2713: --
2714: l_proc varchar2(72) := g_package||'create_NL_person_address';
2715: --
2716: begin
2717: hr_utility.set_location('Entering:'|| l_proc, 5);
2718: --
2719: -- Create Person Address details.
2720: --
2721: hr_person_address_api.create_person_address
2771: ,p_address_id => p_address_id
2772: ,p_object_version_number => p_object_version_number
2773: );
2774: --
2775: hr_utility.set_location(' Leaving:'||l_proc, 10);
2776: end create_NL_person_address;
2777: --
2778: -- ----------------------------------------------------------------------------
2779: -- |-----------------------< create_SG_person_address >-----------------------|
2835: --
2836: l_proc varchar2(72) := g_package||'create_SG_person_address';
2837: --
2838: begin
2839: hr_utility.set_location('Entering:'|| l_proc, 5);
2840: --
2841: -- Create Person Address details.
2842: --
2843: hr_person_address_api.create_person_address
2892: ,p_address_id => p_address_id
2893: ,p_object_version_number => p_object_version_number
2894: );
2895: --
2896: hr_utility.set_location(' Leaving:'||l_proc, 10);
2897: end create_SG_person_address;
2898: --
2899: -- ----------------------------------------------------------------------------
2900: -- |-----------------------< create_SE_person_address >-----------------------|
2956: --
2957: l_proc varchar2(72) := g_package||'create_SE_person_address';
2958: --
2959: begin
2960: hr_utility.set_location('Entering:'|| l_proc, 5);
2961: --
2962: -- Create Person Address details.
2963: --
2964: hr_person_address_api.create_person_address
3013: ,p_address_id => p_address_id
3014: ,p_object_version_number => p_object_version_number
3015: );
3016: --
3017: hr_utility.set_location(' Leaving:'||l_proc, 10);
3018: end create_SE_person_address;
3019: --
3020: -- ----------------------------------------------------------------------------
3021: -- |-----------------------< create_ES_GLB_person_address >-----------------------|
3080: begin
3081: --
3082: l_proc := g_package||'create_ES_GLB_person_address';
3083: --
3084: hr_utility.set_location('Entering:'|| l_proc, 5);
3085: --
3086: -- Create Person Address details.
3087: --
3088: hr_person_address_api.create_person_address
3137: ,p_address_id => p_address_id
3138: ,p_object_version_number => p_object_version_number
3139: );
3140: --
3141: hr_utility.set_location(' Leaving:'||l_proc, 10);
3142: end create_ES_GLB_person_address;
3143: --
3144: -- --------------------------------------------------------------------------
3145: -- |-----------------------< create_ES_person_address >-------------------|
3204: begin
3205: --
3206: l_proc := g_package||'create_ES_person_address';
3207: --
3208: hr_utility.set_location('Entering:'|| l_proc, 5);
3209: --
3210: -- Create Person Address details.
3211: --
3212: hr_person_address_api.create_person_address
3261: ,p_address_id => p_address_id
3262: ,p_object_version_number => p_object_version_number
3263: );
3264: --
3265: hr_utility.set_location(' Leaving:'||l_proc, 10);
3266: end create_ES_person_address;
3267: --
3268: -- ----------------------------------------------------------------------------
3269: -- |-----------------------< create_SA_person_address >-----------------------|
3315: --
3316: l_proc varchar2(72) := g_package||'create_SA_person_address';
3317: --
3318: begin
3319: hr_utility.set_location('Entering:'|| l_proc, 5);
3320: --
3321: -- Create Person Address details.
3322: --
3323: hr_person_address_api.create_person_address
3362: ,p_address_id => p_address_id
3363: ,p_object_version_number => p_object_version_number
3364: );
3365: --
3366: hr_utility.set_location(' Leaving:'||l_proc, 10);
3367: end create_SA_person_address;
3368: --
3369: -- ----------------------------------------------------------------------------
3370: -- |------------------------< update_person_address >-------------------------|
3437: --
3438: lv_object_version_number number := p_object_version_number ;
3439: --
3440: begin
3441: hr_utility.set_location('Entering:'|| l_proc, 5);
3442: --
3443: -- Issue a savepoint.
3444: --
3445: savepoint update_person_address;
3455: (p_api_name => l_proc,
3456: p_argument => 'effective_date',
3457: p_argument_value => p_effective_date);
3458: --
3459: hr_utility.set_location(l_proc, 6);
3460: --
3461: l_date_from := trunc(p_date_from);
3462: l_date_to := trunc(p_date_to);
3463: l_effective_date := trunc(p_effective_date);
3535: -- End of API User Hook for the before hook of update_person_address
3536: --
3537: end;
3538: --
3539: hr_utility.set_location(l_proc, 6);
3540: --
3541: l_object_version_number := p_object_version_number;
3542: --
3543: -- Update Person Address details.
3598: ,p_validate_county => p_validate_county
3599: ,p_party_id => p_party_id
3600: );
3601: --
3602: hr_utility.set_location(l_proc, 8);
3603: begin
3604: --
3605: -- Start of API User Hook for the after hook of update_person_address
3606: --
3671: if p_validate then
3672: raise hr_api.validate_enabled;
3673: end if;
3674: --
3675: hr_utility.set_location(' Leaving:'||l_proc, 11);
3676: exception
3677: when hr_api.validate_enabled then
3678: --
3679: -- As the Validate_Enabled exception has been raised
3773: --
3774: lv_object_version_number number := p_object_version_number ;
3775: --
3776: begin
3777: hr_utility.set_location('Entering:'|| l_proc, 5);
3778: --
3779: -- Issue a savepoint.
3780: --
3781: savepoint update_pers_addr_with_style;
3791: (p_api_name => l_proc,
3792: p_argument => 'effective_date',
3793: p_argument_value => p_effective_date);
3794: --
3795: hr_utility.set_location(l_proc, 6);
3796: --
3797: l_date_from := trunc(p_date_from);
3798: l_date_to := trunc(p_date_to);
3799: l_effective_date := trunc(p_effective_date);
3865: -- End of API User Hook for the before hook of update_pers_addr_with_style
3866: --
3867: end;
3868: --
3869: hr_utility.set_location(l_proc, 6);
3870: --
3871: l_object_version_number := p_object_version_number;
3872: --
3873: -- Update Person Address details.
3929: ,p_primary_flag => p_primary_flag
3930: -- End of fix part2 for Bug #2431588
3931: );
3932: --
3933: hr_utility.set_location(l_proc, 8);
3934: begin
3935: --
3936: -- Start of API User Hook for the after hook of update_pers_addr_with_style
3937: --
4003: if p_validate then
4004: raise hr_api.validate_enabled;
4005: end if;
4006: --
4007: hr_utility.set_location(' Leaving:'||l_proc, 11);
4008: exception
4009: when hr_api.validate_enabled then
4010: --
4011: -- As the Validate_Enabled exception has been raised
4097: from per_addresses addr
4098: where addr.address_id = p_address_id;
4099: --
4100: begin
4101: hr_utility.set_location('Entering:'|| l_proc, 5);
4102: --
4103: -- Check that the Address identified is GB style.
4104: --
4105: open csr_add_style;
4108: if csr_add_style%notfound then
4109: --
4110: close csr_add_style;
4111: --
4112: hr_utility.set_location(l_proc, 7);
4113: --
4114: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4115: hr_utility.raise_error;
4116: --
4110: close csr_add_style;
4111: --
4112: hr_utility.set_location(l_proc, 7);
4113: --
4114: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4115: hr_utility.raise_error;
4116: --
4117: else
4118: --
4111: --
4112: hr_utility.set_location(l_proc, 7);
4113: --
4114: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4115: hr_utility.raise_error;
4116: --
4117: else
4118: --
4119: close csr_add_style;
4119: close csr_add_style;
4120: --
4121: if l_style <> 'GB' then
4122: --
4123: hr_utility.set_location(l_proc, 8);
4124: --
4125: hr_utility.set_message(801, 'HR_7788_ADD_INV_NOT_GB_STYLE');
4126: hr_utility.raise_error;
4127: --
4121: if l_style <> 'GB' then
4122: --
4123: hr_utility.set_location(l_proc, 8);
4124: --
4125: hr_utility.set_message(801, 'HR_7788_ADD_INV_NOT_GB_STYLE');
4126: hr_utility.raise_error;
4127: --
4128: end if;
4129: end if;
4122: --
4123: hr_utility.set_location(l_proc, 8);
4124: --
4125: hr_utility.set_message(801, 'HR_7788_ADD_INV_NOT_GB_STYLE');
4126: hr_utility.raise_error;
4127: --
4128: end if;
4129: end if;
4130: --
4127: --
4128: end if;
4129: end if;
4130: --
4131: hr_utility.set_location(l_proc, 9);
4132: --
4133: -- Update Person Address details.
4134: --
4135: hr_person_address_api.update_person_address
4180: ,p_add_information19 => p_add_information19
4181: ,p_add_information20 => p_add_information20
4182: );
4183: --
4184: hr_utility.set_location(' Leaving:'||l_proc, 11);
4185: end update_gb_person_address;
4186: --
4187: -- ----------------------------------------------------------------------------
4188: -- |-----------------------< update_us_person_address >-----------------------|
4249: from per_addresses
4250: where address_id = p_address_id;
4251: --
4252: begin
4253: hr_utility.set_location('Entering:'|| l_proc, 5);
4254: --
4255: -- Check that the address is US style.
4256: --
4257: open csr_add_style;
4259: into l_style;
4260: if csr_add_style%notfound then
4261: close csr_add_style;
4262: --
4263: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4264: hr_utility.raise_error;
4265: else
4266: hr_utility.set_location(l_proc, 10);
4267: --
4260: if csr_add_style%notfound then
4261: close csr_add_style;
4262: --
4263: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4264: hr_utility.raise_error;
4265: else
4266: hr_utility.set_location(l_proc, 10);
4267: --
4268: close csr_add_style;
4262: --
4263: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4264: hr_utility.raise_error;
4265: else
4266: hr_utility.set_location(l_proc, 10);
4267: --
4268: close csr_add_style;
4269: --
4270: if l_style <> 'US' then
4267: --
4268: close csr_add_style;
4269: --
4270: if l_style <> 'US' then
4271: hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');
4272: hr_utility.raise_error;
4273: end if;
4274: end if;
4275: --
4268: close csr_add_style;
4269: --
4270: if l_style <> 'US' then
4271: hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');
4272: hr_utility.raise_error;
4273: end if;
4274: end if;
4275: --
4276: hr_utility.set_location(l_proc, 15);
4272: hr_utility.raise_error;
4273: end if;
4274: end if;
4275: --
4276: hr_utility.set_location(l_proc, 15);
4277: --
4278: -- Update Person Address details.
4279: --
4280: hr_person_address_api.update_person_address
4327: ,p_add_information19 => p_add_information19
4328: ,p_add_information20 => p_add_information20
4329: );
4330: --
4331: hr_utility.set_location(' Leaving:'||l_proc, 20);
4332: end update_us_person_address;
4333: --
4334: -- ----------------------------------------------------------------------------
4335: -- |-----------------------< update_AT_person_address >-----------------------|
4395: from per_addresses addr
4396: where addr.address_id = p_address_id;
4397: --
4398: begin
4399: hr_utility.set_location('Entering:'|| l_proc, 5);
4400: --
4401: -- Check that the Address identified is of specified style.
4402: --
4403: open csr_add_style;
4406: if csr_add_style%notfound then
4407: --
4408: close csr_add_style;
4409: --
4410: hr_utility.set_location(l_proc, 7);
4411: --
4412: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4413: hr_utility.raise_error;
4414: --
4408: close csr_add_style;
4409: --
4410: hr_utility.set_location(l_proc, 7);
4411: --
4412: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4413: hr_utility.raise_error;
4414: --
4415: else
4416: --
4409: --
4410: hr_utility.set_location(l_proc, 7);
4411: --
4412: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4413: hr_utility.raise_error;
4414: --
4415: else
4416: --
4417: close csr_add_style;
4417: close csr_add_style;
4418: --
4419: if l_style <> 'AT_GLB' then
4420: --
4421: hr_utility.set_location(l_proc, 8);
4422: --
4423: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4424: hr_utility.raise_error;
4425: --
4419: if l_style <> 'AT_GLB' then
4420: --
4421: hr_utility.set_location(l_proc, 8);
4422: --
4423: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4424: hr_utility.raise_error;
4425: --
4426: end if;
4427: end if;
4420: --
4421: hr_utility.set_location(l_proc, 8);
4422: --
4423: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4424: hr_utility.raise_error;
4425: --
4426: end if;
4427: end if;
4428: --
4425: --
4426: end if;
4427: end if;
4428: --
4429: hr_utility.set_location(l_proc, 9);
4430: --
4431: -- Update Person Address details.
4432: --
4433: hr_person_address_api.update_person_address
4479: ,p_add_information19 => p_add_information19
4480: ,p_add_information20 => p_add_information20
4481: );
4482: --
4483: hr_utility.set_location(' Leaving:'||l_proc, 11);
4484: end update_AT_person_address;
4485: --
4486: -- ----------------------------------------------------------------------------
4487: -- |-----------------------< update_AU_person_address >-----------------------|
4547: from per_addresses addr
4548: where addr.address_id = p_address_id;
4549: --
4550: begin
4551: hr_utility.set_location('Entering:'|| l_proc, 5);
4552: --
4553: -- Check that the Address identified is of specified style.
4554: --
4555: open csr_add_style;
4558: if csr_add_style%notfound then
4559: --
4560: close csr_add_style;
4561: --
4562: hr_utility.set_location(l_proc, 7);
4563: --
4564: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4565: hr_utility.raise_error;
4566: --
4560: close csr_add_style;
4561: --
4562: hr_utility.set_location(l_proc, 7);
4563: --
4564: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4565: hr_utility.raise_error;
4566: --
4567: else
4568: --
4561: --
4562: hr_utility.set_location(l_proc, 7);
4563: --
4564: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4565: hr_utility.raise_error;
4566: --
4567: else
4568: --
4569: close csr_add_style;
4569: close csr_add_style;
4570: --
4571: if l_style <> 'AU_GLB' then
4572: --
4573: hr_utility.set_location(l_proc, 8);
4574: --
4575: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4576: hr_utility.raise_error;
4577: --
4571: if l_style <> 'AU_GLB' then
4572: --
4573: hr_utility.set_location(l_proc, 8);
4574: --
4575: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4576: hr_utility.raise_error;
4577: --
4578: end if;
4579: end if;
4572: --
4573: hr_utility.set_location(l_proc, 8);
4574: --
4575: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4576: hr_utility.raise_error;
4577: --
4578: end if;
4579: end if;
4580: --
4577: --
4578: end if;
4579: end if;
4580: --
4581: hr_utility.set_location(l_proc, 9);
4582: --
4583: -- Update Person Address details.
4584: --
4585: hr_person_address_api.update_person_address
4631: ,p_add_information19 => p_add_information19
4632: ,p_add_information20 => p_add_information20
4633: );
4634: --
4635: hr_utility.set_location(' Leaving:'||l_proc, 11);
4636: end update_AU_person_address;
4637: --
4638: -- ----------------------------------------------------------------------------
4639: -- |-----------------------< update_AU_LOC_person_address >-----------------------|
4698: from per_addresses addr
4699: where addr.address_id = p_address_id;
4700: --
4701: begin
4702: hr_utility.set_location('Entering:'|| l_proc, 5);
4703: --
4704: -- Check that the Address identified is of specified style.
4705: --
4706: open csr_add_style;
4709: if csr_add_style%notfound then
4710: --
4711: close csr_add_style;
4712: --
4713: hr_utility.set_location(l_proc, 7);
4714: --
4715: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4716: hr_utility.raise_error;
4717: --
4711: close csr_add_style;
4712: --
4713: hr_utility.set_location(l_proc, 7);
4714: --
4715: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4716: hr_utility.raise_error;
4717: --
4718: else
4719: --
4712: --
4713: hr_utility.set_location(l_proc, 7);
4714: --
4715: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4716: hr_utility.raise_error;
4717: --
4718: else
4719: --
4720: close csr_add_style;
4720: close csr_add_style;
4721: --
4722: if l_style <> 'AU' then
4723: --
4724: hr_utility.set_location(l_proc, 8);
4725: --
4726: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4727: hr_utility.raise_error;
4728: --
4722: if l_style <> 'AU' then
4723: --
4724: hr_utility.set_location(l_proc, 8);
4725: --
4726: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4727: hr_utility.raise_error;
4728: --
4729: end if;
4730: end if;
4723: --
4724: hr_utility.set_location(l_proc, 8);
4725: --
4726: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4727: hr_utility.raise_error;
4728: --
4729: end if;
4730: end if;
4731: --
4728: --
4729: end if;
4730: end if;
4731: --
4732: hr_utility.set_location(l_proc, 9);
4733: --
4734: -- Update Person Address details.
4735: --
4736: hr_person_address_api.update_person_address
4781: ,p_add_information19 => p_add_information19
4782: ,p_add_information20 => p_add_information20
4783: );
4784: --
4785: hr_utility.set_location(' Leaving:'||l_proc, 11);
4786: end update_AU_LOC_person_address;
4787: --
4788: -- ----------------------------------------------------------------------------
4789: -- |-----------------------< update_DK_person_address >-----------------------|
4848: from per_addresses addr
4849: where addr.address_id = p_address_id;
4850: --
4851: begin
4852: hr_utility.set_location('Entering:'|| l_proc, 5);
4853: --
4854: -- Check that the Address identified is of specified style.
4855: --
4856: open csr_add_style;
4859: if csr_add_style%notfound then
4860: --
4861: close csr_add_style;
4862: --
4863: hr_utility.set_location(l_proc, 7);
4864: --
4865: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4866: hr_utility.raise_error;
4867: --
4861: close csr_add_style;
4862: --
4863: hr_utility.set_location(l_proc, 7);
4864: --
4865: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4866: hr_utility.raise_error;
4867: --
4868: else
4869: --
4862: --
4863: hr_utility.set_location(l_proc, 7);
4864: --
4865: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
4866: hr_utility.raise_error;
4867: --
4868: else
4869: --
4870: close csr_add_style;
4870: close csr_add_style;
4871: --
4872: if l_style <> 'DK_GLB' then
4873: --
4874: hr_utility.set_location(l_proc, 8);
4875: --
4876: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4877: hr_utility.raise_error;
4878: --
4872: if l_style <> 'DK_GLB' then
4873: --
4874: hr_utility.set_location(l_proc, 8);
4875: --
4876: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4877: hr_utility.raise_error;
4878: --
4879: end if;
4880: end if;
4873: --
4874: hr_utility.set_location(l_proc, 8);
4875: --
4876: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
4877: hr_utility.raise_error;
4878: --
4879: end if;
4880: end if;
4881: --
4878: --
4879: end if;
4880: end if;
4881: --
4882: hr_utility.set_location(l_proc, 9);
4883: --
4884: -- Update Person Address details.
4885: --
4886: hr_person_address_api.update_person_address
4931: ,p_add_information19 => p_add_information19
4932: ,p_add_information20 => p_add_information20
4933: );
4934: --
4935: hr_utility.set_location(' Leaving:'||l_proc, 11);
4936: end update_DK_person_address;
4937: --
4938: -- ----------------------------------------------------------------------------
4939: -- |-----------------------< update_DE_person_address >-----------------------|
4999: from per_addresses addr
5000: where addr.address_id = p_address_id;
5001: --
5002: begin
5003: hr_utility.set_location('Entering:'|| l_proc, 5);
5004: --
5005: -- Check that the Address identified is of specified style.
5006: --
5007: open csr_add_style;
5010: if csr_add_style%notfound then
5011: --
5012: close csr_add_style;
5013: --
5014: hr_utility.set_location(l_proc, 7);
5015: --
5016: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5017: hr_utility.raise_error;
5018: --
5012: close csr_add_style;
5013: --
5014: hr_utility.set_location(l_proc, 7);
5015: --
5016: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5017: hr_utility.raise_error;
5018: --
5019: else
5020: --
5013: --
5014: hr_utility.set_location(l_proc, 7);
5015: --
5016: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5017: hr_utility.raise_error;
5018: --
5019: else
5020: --
5021: close csr_add_style;
5021: close csr_add_style;
5022: --
5023: if l_style <> 'DE_GLB' then
5024: --
5025: hr_utility.set_location(l_proc, 8);
5026: --
5027: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5028: hr_utility.raise_error;
5029: --
5023: if l_style <> 'DE_GLB' then
5024: --
5025: hr_utility.set_location(l_proc, 8);
5026: --
5027: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5028: hr_utility.raise_error;
5029: --
5030: end if;
5031: end if;
5024: --
5025: hr_utility.set_location(l_proc, 8);
5026: --
5027: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5028: hr_utility.raise_error;
5029: --
5030: end if;
5031: end if;
5032: --
5029: --
5030: end if;
5031: end if;
5032: --
5033: hr_utility.set_location(l_proc, 9);
5034: --
5035: -- Update Person Address details.
5036: --
5037: hr_person_address_api.update_person_address
5083: ,p_add_information19 => p_add_information19
5084: ,p_add_information20 => p_add_information20
5085: );
5086: --
5087: hr_utility.set_location(' Leaving:'||l_proc, 11);
5088: end update_DE_person_address;
5089: --
5090: -- ----------------------------------------------------------------------------
5091: -- |-----------------------< update_IT_person_address >-----------------------|
5151: from per_addresses addr
5152: where addr.address_id = p_address_id;
5153: --
5154: begin
5155: hr_utility.set_location('Entering:'|| l_proc, 5);
5156: --
5157: -- Check that the Address identified is of specified style.
5158: --
5159: open csr_add_style;
5162: if csr_add_style%notfound then
5163: --
5164: close csr_add_style;
5165: --
5166: hr_utility.set_location(l_proc, 7);
5167: --
5168: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5169: hr_utility.raise_error;
5170: --
5164: close csr_add_style;
5165: --
5166: hr_utility.set_location(l_proc, 7);
5167: --
5168: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5169: hr_utility.raise_error;
5170: --
5171: else
5172: --
5165: --
5166: hr_utility.set_location(l_proc, 7);
5167: --
5168: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5169: hr_utility.raise_error;
5170: --
5171: else
5172: --
5173: close csr_add_style;
5173: close csr_add_style;
5174: --
5175: if l_style <> 'IT_GLB' then
5176: --
5177: hr_utility.set_location(l_proc, 8);
5178: --
5179: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5180: hr_utility.raise_error;
5181: --
5175: if l_style <> 'IT_GLB' then
5176: --
5177: hr_utility.set_location(l_proc, 8);
5178: --
5179: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5180: hr_utility.raise_error;
5181: --
5182: end if;
5183: end if;
5176: --
5177: hr_utility.set_location(l_proc, 8);
5178: --
5179: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5180: hr_utility.raise_error;
5181: --
5182: end if;
5183: end if;
5184: --
5181: --
5182: end if;
5183: end if;
5184: --
5185: hr_utility.set_location(l_proc, 9);
5186: --
5187: -- Update Person Address details.
5188: --
5189: hr_person_address_api.update_person_address
5235: ,p_add_information19 => p_add_information19
5236: ,p_add_information20 => p_add_information20
5237: );
5238: --
5239: hr_utility.set_location(' Leaving:'||l_proc, 11);
5240: end update_IT_person_address;
5241: --
5242: -- ----------------------------------------------------------------------------
5243: -- |-----------------------< update_MX_person_address >-----------------------|
5303: from per_addresses addr
5304: where addr.address_id = p_address_id;
5305: --
5306: begin
5307: hr_utility.set_location('Entering:'|| l_proc, 5);
5308: --
5309: -- Check that the Address identified is of specified style.
5310: --
5311: open csr_add_style;
5314: if csr_add_style%notfound then
5315: --
5316: close csr_add_style;
5317: --
5318: hr_utility.set_location(l_proc, 7);
5319: --
5320: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5321: hr_utility.raise_error;
5322: --
5316: close csr_add_style;
5317: --
5318: hr_utility.set_location(l_proc, 7);
5319: --
5320: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5321: hr_utility.raise_error;
5322: --
5323: else
5324: --
5317: --
5318: hr_utility.set_location(l_proc, 7);
5319: --
5320: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5321: hr_utility.raise_error;
5322: --
5323: else
5324: --
5325: close csr_add_style;
5325: close csr_add_style;
5326: --
5327: if l_style <> 'MX_GLB' then
5328: --
5329: hr_utility.set_location(l_proc, 8);
5330: --
5331: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5332: hr_utility.raise_error;
5333: --
5327: if l_style <> 'MX_GLB' then
5328: --
5329: hr_utility.set_location(l_proc, 8);
5330: --
5331: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5332: hr_utility.raise_error;
5333: --
5334: end if;
5335: end if;
5328: --
5329: hr_utility.set_location(l_proc, 8);
5330: --
5331: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5332: hr_utility.raise_error;
5333: --
5334: end if;
5335: end if;
5336: --
5333: --
5334: end if;
5335: end if;
5336: --
5337: hr_utility.set_location(l_proc, 9);
5338: --
5339: -- Update Person Address details.
5340: --
5341: hr_person_address_api.update_person_address
5387: ,p_add_information19 => p_add_information19
5388: ,p_add_information20 => p_add_information20
5389: );
5390: --
5391: hr_utility.set_location(' Leaving:'||l_proc, 11);
5392: end update_MX_person_address;
5393: --
5394: -- ----------------------------------------------------------------------------
5395: -- |---------------------< update_MX_LOC_person_address >---------------------|
5456: from per_addresses addr
5457: where addr.address_id = p_address_id;
5458: --
5459: begin
5460: hr_utility.set_location('Entering:'|| l_proc, 5);
5461: --
5462: -- Check that the Address identified is of specified style.
5463: --
5464: open csr_add_style;
5467: if csr_add_style%notfound then
5468: --
5469: close csr_add_style;
5470: --
5471: hr_utility.set_location(l_proc, 7);
5472: --
5473: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5474: hr_utility.raise_error;
5475: --
5469: close csr_add_style;
5470: --
5471: hr_utility.set_location(l_proc, 7);
5472: --
5473: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5474: hr_utility.raise_error;
5475: --
5476: else
5477: --
5470: --
5471: hr_utility.set_location(l_proc, 7);
5472: --
5473: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5474: hr_utility.raise_error;
5475: --
5476: else
5477: --
5478: close csr_add_style;
5478: close csr_add_style;
5479: --
5480: if l_style <> 'MX' then
5481: --
5482: hr_utility.set_location(l_proc, 8);
5483: --
5484: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5485: hr_utility.raise_error;
5486: --
5480: if l_style <> 'MX' then
5481: --
5482: hr_utility.set_location(l_proc, 8);
5483: --
5484: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5485: hr_utility.raise_error;
5486: --
5487: end if;
5488: end if;
5481: --
5482: hr_utility.set_location(l_proc, 8);
5483: --
5484: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5485: hr_utility.raise_error;
5486: --
5487: end if;
5488: end if;
5489: --
5486: --
5487: end if;
5488: end if;
5489: --
5490: hr_utility.set_location(l_proc, 9);
5491: --
5492: -- Update Person Address details.
5493: --
5494: hr_person_address_api.update_person_address
5541: ,p_add_information20 => p_add_information20
5542: ,p_party_id => p_party_id
5543: );
5544: --
5545: hr_utility.set_location(' Leaving:'||l_proc, 11);
5546: end update_MX_LOC_person_address;
5547: --
5548: -- ----------------------------------------------------------------------------
5549: -- |-----------------------< update_MY_person_address >-----------------------|
5609: from per_addresses addr
5610: where addr.address_id = p_address_id;
5611: --
5612: begin
5613: hr_utility.set_location('Entering:'|| l_proc, 5);
5614: --
5615: -- Check that the Address identified is of specified style.
5616: --
5617: open csr_add_style;
5620: if csr_add_style%notfound then
5621: --
5622: close csr_add_style;
5623: --
5624: hr_utility.set_location(l_proc, 7);
5625: --
5626: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5627: hr_utility.raise_error;
5628: --
5622: close csr_add_style;
5623: --
5624: hr_utility.set_location(l_proc, 7);
5625: --
5626: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5627: hr_utility.raise_error;
5628: --
5629: else
5630: --
5623: --
5624: hr_utility.set_location(l_proc, 7);
5625: --
5626: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5627: hr_utility.raise_error;
5628: --
5629: else
5630: --
5631: close csr_add_style;
5631: close csr_add_style;
5632: --
5633: if l_style <> 'MY_GLB' then
5634: --
5635: hr_utility.set_location(l_proc, 8);
5636: --
5637: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5638: hr_utility.raise_error;
5639: --
5633: if l_style <> 'MY_GLB' then
5634: --
5635: hr_utility.set_location(l_proc, 8);
5636: --
5637: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5638: hr_utility.raise_error;
5639: --
5640: end if;
5641: end if;
5634: --
5635: hr_utility.set_location(l_proc, 8);
5636: --
5637: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5638: hr_utility.raise_error;
5639: --
5640: end if;
5641: end if;
5642: --
5639: --
5640: end if;
5641: end if;
5642: --
5643: hr_utility.set_location(l_proc, 9);
5644: --
5645: -- Update Person Address details.
5646: --
5647: hr_person_address_api.update_person_address
5693: ,p_add_information19 => p_add_information19
5694: ,p_add_information20 => p_add_information20
5695: );
5696: --
5697: hr_utility.set_location(' Leaving:'||l_proc, 11);
5698: end update_MY_person_address;
5699: --
5700: -- ----------------------------------------------------------------------------
5701: -- |-----------------------< update_PT_person_address >-----------------------|
5760: from per_addresses addr
5761: where addr.address_id = p_address_id;
5762: --
5763: begin
5764: hr_utility.set_location('Entering:'|| l_proc, 5);
5765: --
5766: -- Check that the Address identified is of specified style.
5767: --
5768: open csr_add_style;
5771: if csr_add_style%notfound then
5772: --
5773: close csr_add_style;
5774: --
5775: hr_utility.set_location(l_proc, 7);
5776: --
5777: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5778: hr_utility.raise_error;
5779: --
5773: close csr_add_style;
5774: --
5775: hr_utility.set_location(l_proc, 7);
5776: --
5777: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5778: hr_utility.raise_error;
5779: --
5780: else
5781: --
5774: --
5775: hr_utility.set_location(l_proc, 7);
5776: --
5777: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5778: hr_utility.raise_error;
5779: --
5780: else
5781: --
5782: close csr_add_style;
5782: close csr_add_style;
5783: --
5784: if l_style <> 'PT_GLB' then
5785: --
5786: hr_utility.set_location(l_proc, 8);
5787: --
5788: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5789: hr_utility.raise_error;
5790: --
5784: if l_style <> 'PT_GLB' then
5785: --
5786: hr_utility.set_location(l_proc, 8);
5787: --
5788: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5789: hr_utility.raise_error;
5790: --
5791: end if;
5792: end if;
5785: --
5786: hr_utility.set_location(l_proc, 8);
5787: --
5788: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5789: hr_utility.raise_error;
5790: --
5791: end if;
5792: end if;
5793: --
5790: --
5791: end if;
5792: end if;
5793: --
5794: hr_utility.set_location(l_proc, 9);
5795: --
5796: -- Update Person Address details.
5797: --
5798: hr_person_address_api.update_person_address
5843: ,p_add_information19 => p_add_information19
5844: ,p_add_information20 => p_add_information20
5845: );
5846: --
5847: hr_utility.set_location(' Leaving:'||l_proc, 11);
5848: end update_PT_person_address;
5849: --
5850: -- ----------------------------------------------------------------------------
5851: -- |-----------------------< update_BE_person_address >-----------------------|
5910: from per_addresses addr
5911: where addr.address_id = p_address_id;
5912: --
5913: begin
5914: hr_utility.set_location('Entering:'|| l_proc, 5);
5915: --
5916: -- Check that the Address identified is of specified style.
5917: --
5918: open csr_add_style;
5921: if csr_add_style%notfound then
5922: --
5923: close csr_add_style;
5924: --
5925: hr_utility.set_location(l_proc, 7);
5926: --
5927: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5928: hr_utility.raise_error;
5929: --
5923: close csr_add_style;
5924: --
5925: hr_utility.set_location(l_proc, 7);
5926: --
5927: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5928: hr_utility.raise_error;
5929: --
5930: else
5931: --
5924: --
5925: hr_utility.set_location(l_proc, 7);
5926: --
5927: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
5928: hr_utility.raise_error;
5929: --
5930: else
5931: --
5932: close csr_add_style;
5932: close csr_add_style;
5933: --
5934: if l_style <> 'BE' then
5935: --
5936: hr_utility.set_location(l_proc, 8);
5937: --
5938: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5939: hr_utility.raise_error;
5940: --
5934: if l_style <> 'BE' then
5935: --
5936: hr_utility.set_location(l_proc, 8);
5937: --
5938: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5939: hr_utility.raise_error;
5940: --
5941: end if;
5942: end if;
5935: --
5936: hr_utility.set_location(l_proc, 8);
5937: --
5938: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
5939: hr_utility.raise_error;
5940: --
5941: end if;
5942: end if;
5943: --
5940: --
5941: end if;
5942: end if;
5943: --
5944: hr_utility.set_location(l_proc, 9);
5945: --
5946: -- Update Person Address details.
5947: --
5948: hr_person_address_api.update_person_address
5993: ,p_add_information19 => p_add_information19
5994: ,p_add_information20 => p_add_information20
5995: );
5996: --
5997: hr_utility.set_location(' Leaving:'||l_proc, 11);
5998: end update_BE_person_address;
5999: --
6000: -- ----------------------------------------------------------------------------
6001: -- |-----------------------< update_FI_person_address >-----------------------|
6060: from per_addresses addr
6061: where addr.address_id = p_address_id;
6062: --
6063: begin
6064: hr_utility.set_location('Entering:'|| l_proc, 5);
6065: --
6066: -- Check that the Address identified is of specified style.
6067: --
6068: open csr_add_style;
6071: if csr_add_style%notfound then
6072: --
6073: close csr_add_style;
6074: --
6075: hr_utility.set_location(l_proc, 7);
6076: --
6077: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6078: hr_utility.raise_error;
6079: --
6073: close csr_add_style;
6074: --
6075: hr_utility.set_location(l_proc, 7);
6076: --
6077: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6078: hr_utility.raise_error;
6079: --
6080: else
6081: --
6074: --
6075: hr_utility.set_location(l_proc, 7);
6076: --
6077: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6078: hr_utility.raise_error;
6079: --
6080: else
6081: --
6082: close csr_add_style;
6082: close csr_add_style;
6083: --
6084: if l_style <> 'FI_GLB' then
6085: --
6086: hr_utility.set_location(l_proc, 8);
6087: --
6088: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6089: hr_utility.raise_error;
6090: --
6084: if l_style <> 'FI_GLB' then
6085: --
6086: hr_utility.set_location(l_proc, 8);
6087: --
6088: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6089: hr_utility.raise_error;
6090: --
6091: end if;
6092: end if;
6085: --
6086: hr_utility.set_location(l_proc, 8);
6087: --
6088: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6089: hr_utility.raise_error;
6090: --
6091: end if;
6092: end if;
6093: --
6090: --
6091: end if;
6092: end if;
6093: --
6094: hr_utility.set_location(l_proc, 9);
6095: --
6096: -- Update Person Address details.
6097: --
6098: hr_person_address_api.update_person_address
6143: ,p_add_information19 => p_add_information19
6144: ,p_add_information20 => p_add_information20
6145: );
6146: --
6147: hr_utility.set_location(' Leaving:'||l_proc, 11);
6148: end update_FI_person_address;
6149: --
6150: -- ----------------------------------------------------------------------------
6151: -- |-----------------------< update_GR_person_address >-----------------------|
6210: from per_addresses addr
6211: where addr.address_id = p_address_id;
6212: --
6213: begin
6214: hr_utility.set_location('Entering:'|| l_proc, 5);
6215: --
6216: -- Check that the Address identified is of specified style.
6217: --
6218: open csr_add_style;
6221: if csr_add_style%notfound then
6222: --
6223: close csr_add_style;
6224: --
6225: hr_utility.set_location(l_proc, 7);
6226: --
6227: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6228: hr_utility.raise_error;
6229: --
6223: close csr_add_style;
6224: --
6225: hr_utility.set_location(l_proc, 7);
6226: --
6227: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6228: hr_utility.raise_error;
6229: --
6230: else
6231: --
6224: --
6225: hr_utility.set_location(l_proc, 7);
6226: --
6227: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6228: hr_utility.raise_error;
6229: --
6230: else
6231: --
6232: close csr_add_style;
6232: close csr_add_style;
6233: --
6234: if l_style <> 'GR_GLB' then
6235: --
6236: hr_utility.set_location(l_proc, 8);
6237: --
6238: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6239: hr_utility.raise_error;
6240: --
6234: if l_style <> 'GR_GLB' then
6235: --
6236: hr_utility.set_location(l_proc, 8);
6237: --
6238: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6239: hr_utility.raise_error;
6240: --
6241: end if;
6242: end if;
6235: --
6236: hr_utility.set_location(l_proc, 8);
6237: --
6238: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6239: hr_utility.raise_error;
6240: --
6241: end if;
6242: end if;
6243: --
6240: --
6241: end if;
6242: end if;
6243: --
6244: hr_utility.set_location(l_proc, 9);
6245: --
6246: -- Update Person Address details.
6247: --
6248: hr_person_address_api.update_person_address
6293: ,p_add_information19 => p_add_information19
6294: ,p_add_information20 => p_add_information20
6295: );
6296: --
6297: hr_utility.set_location(' Leaving:'||l_proc, 11);
6298: end update_GR_person_address;
6299: --
6300: -- ----------------------------------------------------------------------------
6301: -- |-----------------------< update_HK_person_address >-----------------------|
6359: from per_addresses addr
6360: where addr.address_id = p_address_id;
6361: --
6362: begin
6363: hr_utility.set_location('Entering:'|| l_proc, 5);
6364: --
6365: -- Check that the Address identified is of specified style.
6366: --
6367: open csr_add_style;
6370: if csr_add_style%notfound then
6371: --
6372: close csr_add_style;
6373: --
6374: hr_utility.set_location(l_proc, 7);
6375: --
6376: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6377: hr_utility.raise_error;
6378: --
6372: close csr_add_style;
6373: --
6374: hr_utility.set_location(l_proc, 7);
6375: --
6376: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6377: hr_utility.raise_error;
6378: --
6379: else
6380: --
6373: --
6374: hr_utility.set_location(l_proc, 7);
6375: --
6376: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6377: hr_utility.raise_error;
6378: --
6379: else
6380: --
6381: close csr_add_style;
6381: close csr_add_style;
6382: --
6383: if l_style <> 'HK' then
6384: --
6385: hr_utility.set_location(l_proc, 8);
6386: --
6387: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6388: hr_utility.raise_error;
6389: --
6383: if l_style <> 'HK' then
6384: --
6385: hr_utility.set_location(l_proc, 8);
6386: --
6387: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6388: hr_utility.raise_error;
6389: --
6390: end if;
6391: end if;
6384: --
6385: hr_utility.set_location(l_proc, 8);
6386: --
6387: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6388: hr_utility.raise_error;
6389: --
6390: end if;
6391: end if;
6392: --
6389: --
6390: end if;
6391: end if;
6392: --
6393: hr_utility.set_location(l_proc, 9);
6394: --
6395: -- Update Person Address details.
6396: --
6397: hr_person_address_api.update_person_address
6441: ,p_add_information19 => p_add_information19
6442: ,p_add_information20 => p_add_information20
6443: );
6444: --
6445: hr_utility.set_location(' Leaving:'||l_proc, 11);
6446: end update_HK_person_address;
6447: --
6448: -- ----------------------------------------------------------------------------
6449: -- |-----------------------< update_IE_person_address >-----------------------|
6509: from per_addresses addr
6510: where addr.address_id = p_address_id;
6511: --
6512: begin
6513: hr_utility.set_location('Entering:'|| l_proc, 5);
6514: --
6515: -- Check that the Address identified is of specified style.
6516: --
6517: open csr_add_style;
6520: if csr_add_style%notfound then
6521: --
6522: close csr_add_style;
6523: --
6524: hr_utility.set_location(l_proc, 7);
6525: --
6526: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6527: hr_utility.raise_error;
6528: --
6522: close csr_add_style;
6523: --
6524: hr_utility.set_location(l_proc, 7);
6525: --
6526: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6527: hr_utility.raise_error;
6528: --
6529: else
6530: --
6523: --
6524: hr_utility.set_location(l_proc, 7);
6525: --
6526: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6527: hr_utility.raise_error;
6528: --
6529: else
6530: --
6531: close csr_add_style;
6532: --
6533: --if l_style <> 'IE_GLB' then -- Commented for Bug#16191697
6534: if l_style <> 'IE' then --Added for Bug#16191697
6535: --
6536: hr_utility.set_location(l_proc, 8);
6537: --
6538: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6539: hr_utility.raise_error;
6540: --
6534: if l_style <> 'IE' then --Added for Bug#16191697
6535: --
6536: hr_utility.set_location(l_proc, 8);
6537: --
6538: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6539: hr_utility.raise_error;
6540: --
6541: end if;
6542: end if;
6535: --
6536: hr_utility.set_location(l_proc, 8);
6537: --
6538: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6539: hr_utility.raise_error;
6540: --
6541: end if;
6542: end if;
6543: --
6540: --
6541: end if;
6542: end if;
6543: --
6544: hr_utility.set_location(l_proc, 9);
6545: --
6546: -- Update Person Address details.
6547: --
6548: hr_person_address_api.update_person_address
6594: ,p_add_information19 => p_add_information19
6595: ,p_add_information20 => p_add_information20
6596: );
6597: --
6598: hr_utility.set_location(' Leaving:'||l_proc, 11);
6599: end update_IE_person_address;
6600: --
6601: -- ----------------------------------------------------------------------------
6602: -- |-----------------------< update_LU_person_address >-----------------------|
6661: from per_addresses addr
6662: where addr.address_id = p_address_id;
6663: --
6664: begin
6665: hr_utility.set_location('Entering:'|| l_proc, 5);
6666: --
6667: -- Check that the Address identified is of specified style.
6668: --
6669: open csr_add_style;
6672: if csr_add_style%notfound then
6673: --
6674: close csr_add_style;
6675: --
6676: hr_utility.set_location(l_proc, 7);
6677: --
6678: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6679: hr_utility.raise_error;
6680: --
6674: close csr_add_style;
6675: --
6676: hr_utility.set_location(l_proc, 7);
6677: --
6678: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6679: hr_utility.raise_error;
6680: --
6681: else
6682: --
6675: --
6676: hr_utility.set_location(l_proc, 7);
6677: --
6678: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6679: hr_utility.raise_error;
6680: --
6681: else
6682: --
6683: close csr_add_style;
6683: close csr_add_style;
6684: --
6685: if l_style <> 'LU_GLB' then
6686: --
6687: hr_utility.set_location(l_proc, 8);
6688: --
6689: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6690: hr_utility.raise_error;
6691: --
6685: if l_style <> 'LU_GLB' then
6686: --
6687: hr_utility.set_location(l_proc, 8);
6688: --
6689: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6690: hr_utility.raise_error;
6691: --
6692: end if;
6693: end if;
6686: --
6687: hr_utility.set_location(l_proc, 8);
6688: --
6689: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6690: hr_utility.raise_error;
6691: --
6692: end if;
6693: end if;
6694: --
6691: --
6692: end if;
6693: end if;
6694: --
6695: hr_utility.set_location(l_proc, 9);
6696: --
6697: -- Update Person Address details.
6698: --
6699: hr_person_address_api.update_person_address
6744: ,p_add_information19 => p_add_information19
6745: ,p_add_information20 => p_add_information20
6746: );
6747: --
6748: hr_utility.set_location(' Leaving:'||l_proc, 11);
6749: end update_LU_person_address;
6750: --
6751: -- ----------------------------------------------------------------------------
6752: -- |-----------------------< update_NL_person_address >-----------------------|
6812: from per_addresses addr
6813: where addr.address_id = p_address_id;
6814: --
6815: begin
6816: hr_utility.set_location('Entering:'|| l_proc, 5);
6817: --
6818: -- Check that the Address identified is of specified style.
6819: --
6820: open csr_add_style;
6823: if csr_add_style%notfound then
6824: --
6825: close csr_add_style;
6826: --
6827: hr_utility.set_location(l_proc, 7);
6828: --
6829: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6830: hr_utility.raise_error;
6831: --
6825: close csr_add_style;
6826: --
6827: hr_utility.set_location(l_proc, 7);
6828: --
6829: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6830: hr_utility.raise_error;
6831: --
6832: else
6833: --
6826: --
6827: hr_utility.set_location(l_proc, 7);
6828: --
6829: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6830: hr_utility.raise_error;
6831: --
6832: else
6833: --
6834: close csr_add_style;
6834: close csr_add_style;
6835: --
6836: if l_style <> 'NL_GLB' then
6837: --
6838: hr_utility.set_location(l_proc, 8);
6839: --
6840: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6841: hr_utility.raise_error;
6842: --
6836: if l_style <> 'NL_GLB' then
6837: --
6838: hr_utility.set_location(l_proc, 8);
6839: --
6840: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6841: hr_utility.raise_error;
6842: --
6843: end if;
6844: end if;
6837: --
6838: hr_utility.set_location(l_proc, 8);
6839: --
6840: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6841: hr_utility.raise_error;
6842: --
6843: end if;
6844: end if;
6845: --
6842: --
6843: end if;
6844: end if;
6845: --
6846: hr_utility.set_location(l_proc, 9);
6847: --
6848: -- Update Person Address details.
6849: --
6850: hr_person_address_api.update_person_address
6896: ,p_add_information19 => p_add_information19
6897: ,p_add_information20 => p_add_information20
6898: );
6899: --
6900: hr_utility.set_location(' Leaving:'||l_proc, 11);
6901: end update_NL_person_address;
6902: --
6903: -- ----------------------------------------------------------------------------
6904: -- |-----------------------< update_SG_person_address >-----------------------|
6963: from per_addresses addr
6964: where addr.address_id = p_address_id;
6965: --
6966: begin
6967: hr_utility.set_location('Entering:'|| l_proc, 5);
6968: --
6969: -- Check that the Address identified is of specified style.
6970: --
6971: open csr_add_style;
6974: if csr_add_style%notfound then
6975: --
6976: close csr_add_style;
6977: --
6978: hr_utility.set_location(l_proc, 7);
6979: --
6980: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6981: hr_utility.raise_error;
6982: --
6976: close csr_add_style;
6977: --
6978: hr_utility.set_location(l_proc, 7);
6979: --
6980: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6981: hr_utility.raise_error;
6982: --
6983: else
6984: --
6977: --
6978: hr_utility.set_location(l_proc, 7);
6979: --
6980: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
6981: hr_utility.raise_error;
6982: --
6983: else
6984: --
6985: close csr_add_style;
6985: close csr_add_style;
6986: --
6987: if l_style <> 'SG_GLB' then
6988: --
6989: hr_utility.set_location(l_proc, 8);
6990: --
6991: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6992: hr_utility.raise_error;
6993: --
6987: if l_style <> 'SG_GLB' then
6988: --
6989: hr_utility.set_location(l_proc, 8);
6990: --
6991: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6992: hr_utility.raise_error;
6993: --
6994: end if;
6995: end if;
6988: --
6989: hr_utility.set_location(l_proc, 8);
6990: --
6991: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
6992: hr_utility.raise_error;
6993: --
6994: end if;
6995: end if;
6996: --
6993: --
6994: end if;
6995: end if;
6996: --
6997: hr_utility.set_location(l_proc, 9);
6998: --
6999: -- Update Person Address details.
7000: --
7001: hr_person_address_api.update_person_address
7046: ,p_add_information19 => p_add_information19
7047: ,p_add_information20 => p_add_information20
7048: );
7049: --
7050: hr_utility.set_location(' Leaving:'||l_proc, 11);
7051: end update_SG_person_address;
7052: --
7053: -- ----------------------------------------------------------------------------
7054: -- |-----------------------< update_SE_person_address >-----------------------|
7113: from per_addresses addr
7114: where addr.address_id = p_address_id;
7115: --
7116: begin
7117: hr_utility.set_location('Entering:'|| l_proc, 5);
7118: --
7119: -- Check that the Address identified is of specified style.
7120: --
7121: open csr_add_style;
7124: if csr_add_style%notfound then
7125: --
7126: close csr_add_style;
7127: --
7128: hr_utility.set_location(l_proc, 7);
7129: --
7130: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7131: hr_utility.raise_error;
7132: --
7126: close csr_add_style;
7127: --
7128: hr_utility.set_location(l_proc, 7);
7129: --
7130: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7131: hr_utility.raise_error;
7132: --
7133: else
7134: --
7127: --
7128: hr_utility.set_location(l_proc, 7);
7129: --
7130: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7131: hr_utility.raise_error;
7132: --
7133: else
7134: --
7135: close csr_add_style;
7135: close csr_add_style;
7136: --
7137: if l_style <> 'SE_GLB' then
7138: --
7139: hr_utility.set_location(l_proc, 8);
7140: --
7141: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7142: hr_utility.raise_error;
7143: --
7137: if l_style <> 'SE_GLB' then
7138: --
7139: hr_utility.set_location(l_proc, 8);
7140: --
7141: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7142: hr_utility.raise_error;
7143: --
7144: end if;
7145: end if;
7138: --
7139: hr_utility.set_location(l_proc, 8);
7140: --
7141: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7142: hr_utility.raise_error;
7143: --
7144: end if;
7145: end if;
7146: --
7143: --
7144: end if;
7145: end if;
7146: --
7147: hr_utility.set_location(l_proc, 9);
7148: --
7149: -- Update Person Address details.
7150: --
7151: hr_person_address_api.update_person_address
7196: ,p_add_information19 => p_add_information19
7197: ,p_add_information20 => p_add_information20
7198: );
7199: --
7200: hr_utility.set_location(' Leaving:'||l_proc, 11);
7201: end update_SE_person_address;
7202: --
7203: -- ----------------------------------------------------------------------------
7204: -- |-----------------------< update_ES_GLB_person_address >-----------------------|
7266: begin
7267: --
7268: l_proc := g_package||'update_ES_GLB_person_address';
7269: --
7270: hr_utility.set_location('Entering:'|| l_proc, 5);
7271: --
7272: -- Check that the Address identified is of specified style.
7273: --
7274: open csr_add_style;
7277: if csr_add_style%notfound then
7278: --
7279: close csr_add_style;
7280: --
7281: hr_utility.set_location(l_proc, 7);
7282: --
7283: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7284: hr_utility.raise_error;
7285: --
7279: close csr_add_style;
7280: --
7281: hr_utility.set_location(l_proc, 7);
7282: --
7283: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7284: hr_utility.raise_error;
7285: --
7286: else
7287: --
7280: --
7281: hr_utility.set_location(l_proc, 7);
7282: --
7283: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7284: hr_utility.raise_error;
7285: --
7286: else
7287: --
7288: close csr_add_style;
7288: close csr_add_style;
7289: --
7290: if l_style <> 'ES_GLB' then
7291: --
7292: hr_utility.set_location(l_proc, 8);
7293: --
7294: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7295: hr_utility.raise_error;
7296: --
7290: if l_style <> 'ES_GLB' then
7291: --
7292: hr_utility.set_location(l_proc, 8);
7293: --
7294: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7295: hr_utility.raise_error;
7296: --
7297: end if;
7298: end if;
7291: --
7292: hr_utility.set_location(l_proc, 8);
7293: --
7294: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7295: hr_utility.raise_error;
7296: --
7297: end if;
7298: end if;
7299: --
7296: --
7297: end if;
7298: end if;
7299: --
7300: hr_utility.set_location(l_proc, 9);
7301: --
7302: -- Update Person Address details.
7303: --
7304: hr_person_address_api.update_person_address
7349: ,p_add_information19 => p_add_information19
7350: ,p_add_information20 => p_add_information20
7351: );
7352: --
7353: hr_utility.set_location(' Leaving:'||l_proc, 11);
7354: end update_ES_GLB_person_address;
7355: --
7356: -- ----------------------------------------------------------------------------
7357: -- |-----------------------< update_ES_person_address >-----------------------|
7419: begin
7420: --
7421: l_proc := g_package||'update_ES_person_address';
7422: --
7423: hr_utility.set_location('Entering:'|| l_proc, 5);
7424: --
7425: -- Check that the Address identified is of specified style.
7426: --
7427: open csr_add_style;
7430: if csr_add_style%notfound then
7431: --
7432: close csr_add_style;
7433: --
7434: hr_utility.set_location(l_proc, 7);
7435: --
7436: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7437: hr_utility.raise_error;
7438: --
7432: close csr_add_style;
7433: --
7434: hr_utility.set_location(l_proc, 7);
7435: --
7436: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7437: hr_utility.raise_error;
7438: --
7439: else
7440: --
7433: --
7434: hr_utility.set_location(l_proc, 7);
7435: --
7436: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7437: hr_utility.raise_error;
7438: --
7439: else
7440: --
7441: close csr_add_style;
7441: close csr_add_style;
7442: --
7443: if l_style <> 'ES' then
7444: --
7445: hr_utility.set_location(l_proc, 8);
7446: --
7447: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7448: hr_utility.raise_error;
7449: --
7443: if l_style <> 'ES' then
7444: --
7445: hr_utility.set_location(l_proc, 8);
7446: --
7447: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7448: hr_utility.raise_error;
7449: --
7450: end if;
7451: end if;
7444: --
7445: hr_utility.set_location(l_proc, 8);
7446: --
7447: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7448: hr_utility.raise_error;
7449: --
7450: end if;
7451: end if;
7452: --
7449: --
7450: end if;
7451: end if;
7452: --
7453: hr_utility.set_location(l_proc, 9);
7454: --
7455: -- Update Person Address details.
7456: --
7457: hr_person_address_api.update_person_address
7502: ,p_add_information19 => p_add_information19
7503: ,p_add_information20 => p_add_information20
7504: );
7505: --
7506: hr_utility.set_location(' Leaving:'||l_proc, 11);
7507: end update_ES_person_address;
7508: --
7509: -- ----------------------------------------------------------------------------
7510: -- |-----------------------< update_SA_person_address >-----------------------|
7559: from per_addresses addr
7560: where addr.address_id = p_address_id;
7561: --
7562: begin
7563: hr_utility.set_location('Entering:'|| l_proc, 5);
7564: --
7565: -- Check that the Address identified is of specified style.
7566: --
7567: open csr_add_style;
7570: if csr_add_style%notfound then
7571: --
7572: close csr_add_style;
7573: --
7574: hr_utility.set_location(l_proc, 7);
7575: --
7576: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7577: hr_utility.raise_error;
7578: --
7572: close csr_add_style;
7573: --
7574: hr_utility.set_location(l_proc, 7);
7575: --
7576: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7577: hr_utility.raise_error;
7578: --
7579: else
7580: --
7573: --
7574: hr_utility.set_location(l_proc, 7);
7575: --
7576: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
7577: hr_utility.raise_error;
7578: --
7579: else
7580: --
7581: close csr_add_style;
7581: close csr_add_style;
7582: --
7583: if l_style <> 'SA' then
7584: --
7585: hr_utility.set_location(l_proc, 8);
7586: --
7587: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7588: hr_utility.raise_error;
7589: --
7583: if l_style <> 'SA' then
7584: --
7585: hr_utility.set_location(l_proc, 8);
7586: --
7587: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7588: hr_utility.raise_error;
7589: --
7590: end if;
7591: end if;
7584: --
7585: hr_utility.set_location(l_proc, 8);
7586: --
7587: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
7588: hr_utility.raise_error;
7589: --
7590: end if;
7591: end if;
7592: --
7589: --
7590: end if;
7591: end if;
7592: --
7593: hr_utility.set_location(l_proc, 9);
7594: --
7595: -- Update Person Address details.
7596: --
7597: hr_person_address_api.update_person_address
7632: ,p_addr_attribute19 => p_addr_attribute19
7633: ,p_addr_attribute20 => p_addr_attribute20
7634: );
7635: --
7636: hr_utility.set_location(' Leaving:'||l_proc, 11);
7637: end update_SA_person_address;
7638: --
7639: --
7640: -- ----------------------------------------------------------------------------
7714: lv_object_version_number number := p_object_version_number ;
7715: --
7716: begin
7717: --
7718: hr_utility.set_location('Entering:'|| l_proc, 10);
7719: --
7720: savepoint cre_or_upd_person_address;
7721: --
7722: l_update_mode:=p_update_mode;
7723: l_effective_date:=trunc(p_effective_date);
7724: l_api_updating := per_add_shd.api_updating
7725: (p_address_id => p_address_id
7726: ,p_object_version_number => p_object_version_number);
7727: hr_utility.set_location(l_proc, 20);
7728: --
7729: -- set the record
7730: --
7731: l_add_rec:=
7791: --
7792: -- set g_old_rec to null
7793: --
7794: per_add_shd.g_old_rec:=l_null_add_rec;
7795: hr_utility.set_location(l_proc, 30);
7796: --
7797: -- convert the null values
7798: --
7799: hr_utility.set_location(l_proc, 40);
7795: hr_utility.set_location(l_proc, 30);
7796: --
7797: -- convert the null values
7798: --
7799: hr_utility.set_location(l_proc, 40);
7800: l_add_rec:=per_add_upd.convert_defs(l_add_rec);
7801: --
7802: -- insert the data
7803: --
7800: l_add_rec:=per_add_upd.convert_defs(l_add_rec);
7801: --
7802: -- insert the data
7803: --
7804: hr_utility.set_location(l_proc, 50);
7805: hr_person_address_api.create_person_address
7806: (p_validate => FALSE
7807: ,p_effective_date => l_effective_date
7808: ,p_validate_county => p_validate_county
7858: ,p_address_id => l_add_rec.address_id
7859: ,p_object_version_number => l_add_rec.object_version_number
7860: ,p_party_id => l_add_rec.party_id -- HR/TCA merge
7861: );
7862: hr_utility.set_location(l_proc, 60);
7863: else
7864: hr_utility.set_location(l_proc, 70);
7865: --
7866: -- updating not inserting
7860: ,p_party_id => l_add_rec.party_id -- HR/TCA merge
7861: );
7862: hr_utility.set_location(l_proc, 60);
7863: else
7864: hr_utility.set_location(l_proc, 70);
7865: --
7866: -- updating not inserting
7867: --
7868: -- Validating update_mode values
7866: -- updating not inserting
7867: --
7868: -- Validating update_mode values
7869: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
7870: hr_utility.set_location(l_proc, 80);
7871: hr_utility.set_message(800, 'HR_52862_ADD_CHK_MODE');
7872: hr_utility.raise_error;
7873: end if;
7874: hr_utility.set_location(l_proc, 90);
7867: --
7868: -- Validating update_mode values
7869: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
7870: hr_utility.set_location(l_proc, 80);
7871: hr_utility.set_message(800, 'HR_52862_ADD_CHK_MODE');
7872: hr_utility.raise_error;
7873: end if;
7874: hr_utility.set_location(l_proc, 90);
7875: --
7868: -- Validating update_mode values
7869: if (l_update_mode not in (hr_api.g_update,hr_api.g_correction)) then
7870: hr_utility.set_location(l_proc, 80);
7871: hr_utility.set_message(800, 'HR_52862_ADD_CHK_MODE');
7872: hr_utility.raise_error;
7873: end if;
7874: hr_utility.set_location(l_proc, 90);
7875: --
7876: -- Validating effective_date
7870: hr_utility.set_location(l_proc, 80);
7871: hr_utility.set_message(800, 'HR_52862_ADD_CHK_MODE');
7872: hr_utility.raise_error;
7873: end if;
7874: hr_utility.set_location(l_proc, 90);
7875: --
7876: -- Validating effective_date
7877: --
7878: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
7877: --
7878: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
7879: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
7880: then
7881: hr_utility.set_location(l_proc, 100);
7882: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
7883: hr_utility.raise_error;
7884: end if;
7885: hr_utility.set_location(l_proc, 110);
7878: if ((p_date_to <> hr_api.g_date) AND ( l_effective_date > p_date_to ))
7879: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
7880: then
7881: hr_utility.set_location(l_proc, 100);
7882: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
7883: hr_utility.raise_error;
7884: end if;
7885: hr_utility.set_location(l_proc, 110);
7886: --
7879: or ((p_date_from <> hr_api.g_date) AND ( l_effective_date < p_date_from ))
7880: then
7881: hr_utility.set_location(l_proc, 100);
7882: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
7883: hr_utility.raise_error;
7884: end if;
7885: hr_utility.set_location(l_proc, 110);
7886: --
7887: per_add_shd.lck
7881: hr_utility.set_location(l_proc, 100);
7882: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
7883: hr_utility.raise_error;
7884: end if;
7885: hr_utility.set_location(l_proc, 110);
7886: --
7887: per_add_shd.lck
7888: (p_address_id => p_address_id
7889: ,p_object_version_number => p_object_version_number);
7889: ,p_object_version_number => p_object_version_number);
7890: --
7891: -- convert the null values
7892: --
7893: hr_utility.set_location(l_proc, 130);
7894: l_add_rec:=per_add_upd.convert_defs(l_add_rec);
7895: --
7896: -- check to see if the start date hasn't changed and is equal to the
7897: -- effective date. This will always be a correction.
7906: if l_update_mode = hr_api.g_correction then
7907: --
7908: -- correct the data
7909: --
7910: hr_utility.set_location(l_proc, 140);
7911: --
7912: -- Bug 2863410 starts here.
7913: -- If the style is changed then used update_pers_addr_with_style.
7914: --
7913: -- If the style is changed then used update_pers_addr_with_style.
7914: --
7915: IF per_add_shd.g_old_rec.style <> l_add_rec.style THEN
7916: --
7917: hr_utility.set_location(l_proc, 142);
7918: --
7919: hr_person_address_api.update_pers_addr_with_style
7920: (p_validate => FALSE
7921: ,p_effective_date => l_effective_date
7969: ,p_add_information20 => l_add_rec.add_information20
7970: ,p_style => l_add_rec.style
7971: );
7972: --
7973: hr_utility.set_location(l_proc, 144);
7974: --
7975: ELSE
7976: --
7977: -- Address style is not changed.
7975: ELSE
7976: --
7977: -- Address style is not changed.
7978: --
7979: hr_utility.set_location(l_proc, 146);
7980: --
7981: hr_person_address_api.update_person_address
7982: (p_validate => FALSE
7983: ,p_effective_date => l_effective_date
8030: ,p_add_information19 => l_add_rec.add_information19
8031: ,p_add_information20 => l_add_rec.add_information20
8032: );
8033: --
8034: hr_utility.set_location(l_proc, 148);
8035: --
8036: END IF;
8037: --
8038: -- Bug 2863410 ends here.
8036: END IF;
8037: --
8038: -- Bug 2863410 ends here.
8039: --
8040: hr_utility.set_location(l_proc, 150);
8041: --
8042: else
8043: --
8044: -- update mode
8042: else
8043: --
8044: -- update mode
8045: --
8046: hr_utility.set_location(l_proc, 160);
8047: --
8048: -- if the start date has changed and it is not the effective date then
8049: -- we have an error. A change of start date is the new start date for
8050: -- the new record, so must be the effective date so that the address
8051: -- is continuous.
8052: --
8053: if per_add_shd.g_old_rec.date_from <> l_add_rec.date_from
8054: and l_add_rec.date_from <> l_effective_date then
8055: hr_utility.set_location(l_proc, 170);
8056: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
8057: hr_utility.raise_error;
8058: end if;
8059: --
8052: --
8053: if per_add_shd.g_old_rec.date_from <> l_add_rec.date_from
8054: and l_add_rec.date_from <> l_effective_date then
8055: hr_utility.set_location(l_proc, 170);
8056: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
8057: hr_utility.raise_error;
8058: end if;
8059: --
8060: hr_utility.set_location(l_proc, 180);
8053: if per_add_shd.g_old_rec.date_from <> l_add_rec.date_from
8054: and l_add_rec.date_from <> l_effective_date then
8055: hr_utility.set_location(l_proc, 170);
8056: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
8057: hr_utility.raise_error;
8058: end if;
8059: --
8060: hr_utility.set_location(l_proc, 180);
8061: --
8056: hr_utility.set_message(800, 'HR_52863_ADD_INVALID_EFF_DATE');
8057: hr_utility.raise_error;
8058: end if;
8059: --
8060: hr_utility.set_location(l_proc, 180);
8061: --
8062: -- end the old address
8063: --2660711, remove this call, change the create call to pass TRUE for
8064: --p_pradd_ovlapval_override which will achieve the same thing
8087: end if;
8088: -- changes ended for bug5372061
8089:
8090: --
8091: hr_utility.set_location(l_proc, 190);
8092: --
8093: -- insert the new address
8094: --
8095: hr_person_address_api.create_person_address
8149: ,p_object_version_number => l_add_rec.object_version_number
8150: ,p_party_id => l_add_rec.party_id -- HR/TCA merge
8151: );
8152: --
8153: hr_utility.set_location(l_proc, 190);
8154: --
8155: end if;
8156: end if;
8157: --
8160: end if;
8161: --
8162: p_address_id:=l_add_rec.address_id;
8163: p_object_version_number:=l_add_rec.object_version_number;
8164: hr_utility.set_location('Leaving:'||l_proc, 200);
8165: --
8166: exception
8167: when hr_api.validate_enabled then
8168: rollback to cre_or_upd_person_address;
8167: when hr_api.validate_enabled then
8168: rollback to cre_or_upd_person_address;
8169: p_address_id:=null;
8170: p_object_version_number:=null;
8171: hr_utility.set_location('Leaving:'||l_proc, 220);
8172: when others then
8173: p_address_id := lv_address_id ;
8174: p_object_version_number := lv_object_version_number ;
8175: rollback to cre_or_upd_person_address;
8172: when others then
8173: p_address_id := lv_address_id ;
8174: p_object_version_number := lv_object_version_number ;
8175: rollback to cre_or_upd_person_address;
8176: hr_utility.set_location('Leaving:'||l_proc, 230);
8177: raise;
8178: --
8179: end cre_or_upd_person_address;
8180: --
8243: from per_addresses addr
8244: where addr.address_id = p_address_id;
8245: --
8246: begin
8247: hr_utility.set_location('Entering:'|| l_proc, 5);
8248: --
8249: -- Check that the Address identified is of specified style.
8250: --
8251: open csr_add_style;
8254: if csr_add_style%notfound then
8255: --
8256: close csr_add_style;
8257: --
8258: hr_utility.set_location(l_proc, 7);
8259: --
8260: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
8261: hr_utility.raise_error;
8262: --
8256: close csr_add_style;
8257: --
8258: hr_utility.set_location(l_proc, 7);
8259: --
8260: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
8261: hr_utility.raise_error;
8262: --
8263: else
8264: --
8257: --
8258: hr_utility.set_location(l_proc, 7);
8259: --
8260: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
8261: hr_utility.raise_error;
8262: --
8263: else
8264: --
8265: close csr_add_style;
8265: close csr_add_style;
8266: --
8267: if l_style <> 'IE_GLB' then
8268: --
8269: hr_utility.set_location(l_proc, 8);
8270: --
8271: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
8272: hr_utility.raise_error;
8273: --
8267: if l_style <> 'IE_GLB' then
8268: --
8269: hr_utility.set_location(l_proc, 8);
8270: --
8271: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
8272: hr_utility.raise_error;
8273: --
8274: end if;
8275: end if;
8268: --
8269: hr_utility.set_location(l_proc, 8);
8270: --
8271: hr_utility.set_message(801, 'HR_52368_ADD_INV_NOT_CORR_STYLE');
8272: hr_utility.raise_error;
8273: --
8274: end if;
8275: end if;
8276: --
8273: --
8274: end if;
8275: end if;
8276: --
8277: hr_utility.set_location(l_proc, 9);
8278: --
8279: -- Update Person Address details.
8280: --
8281: hr_person_address_api.update_person_address
8327: ,p_add_information19 => p_add_information19
8328: ,p_add_information20 => p_add_information20
8329: );
8330: --
8331: hr_utility.set_location(' Leaving:'||l_proc, 11);
8332: end update_IE_GLB_person_address;
8333: --
8334: -- Changes end for Bug#16191697
8335: --