DBA Data[Home] [Help]

APPS.PER_ADD_BUS dependencies on HR_MULTI_MESSAGE

Line 112: if hr_multi_message.exception_add

108: --
109: hr_utility.set_location('Leaving:'||l_proc, 40);
110: exception
111: when app_exception.application_exception then
112: if hr_multi_message.exception_add
113: (p_associated_column1 => 'PER_PREVIOUS_EMPLOYERS.BUSINESS_GROUP_ID'
114: ) then
115: hr_utility.set_location('Leaving:'||l_proc, 50);
116: raise;

Line 254: if hr_multi_message.exception_add

250: --
251: hr_utility.set_location(' Leaving:'|| l_proc, 50);
252: exception
253: when app_exception.application_exception then
254: if hr_multi_message.exception_add
255: (p_associated_column1 => 'PER_ADDRESSES.PERSON_ID'
256: ) then
257: hr_utility.set_location(' Leaving:'||l_proc,60);
258: raise;

Line 321: if hr_multi_message.no_all_inclusive_error

317: hr_utility.set_location('Entering:'|| l_proc, 1);
318: --
319: --
320: if p_rec.person_id is not null then
321: if hr_multi_message.no_all_inclusive_error
322: (p_check_column1 => 'PER_ADDRESSES.PERSON_ID'
323: ,p_check_column2 => 'PER_ADDRESSES.DATE_FROM'
324: ) then
325: --

Line 334: hr_multi_message.add

330: if p_rec.party_id is not null then
331: if p_rec.party_id <> nvl(l_party_id,-1) then
332: hr_utility.set_message(800, 'HR_289343_PERSONPARTY_MISMATCH');
333: hr_utility.set_location(l_proc,30);
334: hr_multi_message.add
335: (p_associated_column1 => 'PER_ADDRESSES.PERSON_ID'
336: ,p_associated_column2 => 'PER_ADDRESSES.DATE_FROM'
337: ,p_associated_column3 => 'PER_ADDRESSES.PARTY_ID'
338: );

Line 352: hr_multi_message.add

348: else
349: if p_rec.party_id is null then
350: hr_utility.set_message(800, 'HR_289341_CHK_PERSON_OR_PARTY');
351: hr_utility.set_location(l_proc,60);
352: hr_multi_message.add
353: ( p_associated_column1 => 'PER_ADDRESSES.PARTY_ID'
354: );
355: else
356: open csr_valid_party_id;

Line 362: hr_multi_message.add

358: if csr_valid_party_id%notfound then
359: close csr_valid_party_id;
360: hr_utility.set_message(800, 'PER_289342_PARTY_ID_INVALID');
361: hr_utility.set_location(l_proc,70);
362: hr_multi_message.add
363: (p_associated_column1 => 'PER_ADDRESSES.PARTY_ID'
364: );
365: else
366: --

Line 550: if hr_multi_message.exception_add

546: --
547: hr_utility.set_location(' Leaving:'|| l_proc, 4);
548: exception
549: when app_exception.application_exception then
550: if hr_multi_message.exception_add
551: (p_associated_column1 => 'PER_ADDRESSES.ADDRESS_TYPE'
552: ) then
553: hr_utility.set_location(' Leaving:'||l_proc,5);
554: raise;

Line 643: if hr_multi_message.exception_add

639: --
640: hr_utility.set_location(' Leaving:'|| l_proc, 3);
641: exception
642: when app_exception.application_exception then
643: if hr_multi_message.exception_add
644: (p_associated_column1 => 'PER_ADDRESSES.COUNTRY'
645: ) then
646: hr_utility.set_location(' Leaving:'||l_proc,4);
647: raise;

Line 705: if hr_multi_message.no_all_inclusive_error

701: (p_api_name => l_proc
702: ,p_argument => 'date_from'
703: ,p_argument_value => p_date_from
704: );
705: if hr_multi_message.no_all_inclusive_error
706: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
707: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
708: ,p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
709: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'

Line 742: if hr_multi_message.exception_add

738: end if;
739: hr_utility.set_location(' Leaving:'|| l_proc, 3);
740: exception
741: when app_exception.application_exception then
742: if hr_multi_message.exception_add
743: (p_same_associated_columns => 'Y'
744: ) then
745: hr_utility.set_location(' Leaving:'||l_proc,4);
746: raise;

Line 829: if hr_multi_message.exception_add

825: --
826: hr_utility.set_location(' Leaving:'|| l_proc, 3);
827: exception
828: when app_exception.application_exception then
829: if hr_multi_message.exception_add
830: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
831: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
832: ) then
833: hr_utility.set_location(' Leaving:'||l_proc,4);

Line 1071: if hr_multi_message.no_all_inclusive_error

1067: ,p_argument => 'primary_flag'
1068: ,p_argument_value => p_primary_flag
1069: );
1070: hr_utility.set_location(l_proc, 20);
1071: if hr_multi_message.no_all_inclusive_error
1072: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1073: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1074: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1075: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1118: hr_multi_message.add

1114: fetch csr_dup_add_type_exists into l_exists;
1115: if csr_dup_add_type_exists%found then
1116: close csr_dup_add_type_exists;
1117: hr_utility.set_message(801, 'HR_51139_ADD_TYPE_ALR_EXIST');
1118: hr_multi_message.add
1119: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1120: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1121: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1122: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1154: hr_multi_message.add

1150: fetch csr_dup_prim_flag into l_exists;
1151: if csr_dup_prim_flag%found then
1152: close csr_dup_prim_flag;
1153: hr_utility.set_message(801, 'HR_7327_ADD_PRIMARY_ADD_EXISTS');
1154: hr_multi_message.add
1155: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1156: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1157: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1158: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1220: hr_multi_message.add

1216: and l_recs_after)
1217: or
1218: (l_good_recs < 1)) then
1219: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1220: hr_multi_message.add
1221: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1222: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1223: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1224: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1247: hr_multi_message.add

1243: fetch csr_invalid_non_prim into l_exists;
1244: if csr_invalid_non_prim%found then
1245: close csr_invalid_non_prim;
1246: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1247: hr_multi_message.add
1248: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1249: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1250: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1251: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1276: hr_multi_message.add

1272: fetch csr_no_primary into l_exists;
1273: if csr_no_primary%notfound then
1274: close csr_no_primary;
1275: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1276: hr_multi_message.add
1277: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1278: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1279: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1280: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1322: hr_multi_message.add();

1318: and l_action_eff_date between date_from
1319: and nvl(date_to,l_action_eff_date);
1320: if l_address_count = 0 then
1321: hr_utility.set_message(800, 'PER_PAYROLL_EXISTS');
1322: hr_multi_message.add();
1323: end if;
1324: end if;
1325: end loop;
1326: end loop;

Line 1414: if hr_multi_message.exception_add

1410: --
1411: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1412: exception
1413: when app_exception.application_exception then
1414: if hr_multi_message.exception_add
1415: (p_associated_column1 => 'PER_ADDRESSES.STYLE'
1416: ) then
1417: hr_utility.set_location(' Leaving:'||l_proc,5);
1418: raise;

Line 1422: hr_multi_message.end_validation_set;

1418: raise;
1419: end if;
1420: -- Call to raise any errors on multi-message list
1421: -- Taking STYLE as an important parameter.
1422: hr_multi_message.end_validation_set;
1423: hr_utility.set_location(' Leaving:'||l_proc,6);
1424: --
1425: end chk_style;
1426: --

Line 1481: if hr_multi_message.no_exclusive_error

1477: -- Check 'GB' address style
1478: --
1479: if p_style = 'GB' then
1480: if p_region_2 is not null then
1481: if hr_multi_message.no_exclusive_error
1482: (p_check_column1 => 'PER_ADDRESSES.REGION_2') then
1483: --
1484: l_token := 'region_2';
1485: raise l_error;

Line 1554: hr_multi_message.add(

1550: exception
1551: when l_error then
1552: hr_utility.set_message(801, 'HR_7324_ADD_ADD_ATTRIBUTE_NULL');
1553: hr_utility.set_message_token('ARGUMENT', l_token);
1554: hr_multi_message.add(
1555: p_associated_column1 =>
1556: (per_add_shd.g_tab_nam || '.' || upper(l_token))
1557: );
1558: when others then

Line 1650: if hr_multi_message.exception_add

1646: --
1647: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1648: exception
1649: when app_exception.application_exception then
1650: if hr_multi_message.exception_add
1651: (p_associated_column1 => 'PER_ADDRESSES.ADDRESS_LINE1'
1652: ) then
1653: hr_utility.set_location(' Leaving:'||l_proc,6);
1654: raise;

Line 2363: if hr_multi_message.exception_add

2359: --
2360: hr_utility.set_location(' Leaving:'|| l_proc, 9);
2361: exception
2362: when app_exception.application_exception then
2363: if hr_multi_message.exception_add
2364: (p_associated_column1 => 'PER_ADDRESSES.POSTAL_CODE'
2365: ) then
2366: hr_utility.set_location(' Leaving:'||l_proc,10);
2367: raise;

Line 2536: if hr_multi_message.exception_add

2532: end if;
2533: hr_utility.set_location(' Leaving:'|| l_proc, 7);
2534: exception
2535: when app_exception.application_exception then
2536: if hr_multi_message.exception_add
2537: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
2538: ) then
2539: hr_utility.set_location(' Leaving:'||l_proc,6);
2540: raise;

Line 2693: if hr_multi_message.exception_add

2689: end if;
2690: hr_utility.set_location(' Leaving:'|| l_proc, 6);
2691: exception
2692: when app_exception.application_exception then
2693: if hr_multi_message.exception_add
2694: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
2695: ) then
2696: hr_utility.set_location(' Leaving:'||l_proc,7);
2697: raise;

Line 2815: if hr_multi_message.exception_add

2811: end if;
2812: hr_utility.set_location(' Leaving:'|| l_proc, 6);
2813: exception
2814: when app_exception.application_exception then
2815: if hr_multi_message.exception_add
2816: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION19'
2817: ) then
2818: hr_utility.set_location(' Leaving:'||l_proc,7);
2819: raise;

Line 2975: if hr_multi_message.exception_add

2971: --
2972: hr_utility.set_location(' Leaving:'|| l_proc, 10);
2973: exception
2974: when app_exception.application_exception then
2975: if hr_multi_message.exception_add
2976: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
2977: ) then
2978: hr_utility.set_location(' Leaving:'||l_proc,11);
2979: raise;

Line 3119: if hr_multi_message.exception_add

3115: --
3116: hr_utility.set_location(' Leaving:'|| l_proc, 10);
3117: exception
3118: when app_exception.application_exception then
3119: if hr_multi_message.exception_add
3120: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3121: ) then
3122: hr_utility.set_location(' Leaving:'||l_proc,11);
3123: raise;

Line 3234: if hr_multi_message.exception_add

3230: --
3231: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3232: exception
3233: when app_exception.application_exception then
3234: if hr_multi_message.exception_add
3235: (p_associated_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'
3236: ) then
3237: hr_utility.set_location(' Leaving:'||l_proc,6);
3238: raise;

Line 3342: if hr_multi_message.exception_add

3338: end if;
3339: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3340: exception
3341: when app_exception.application_exception then
3342: if hr_multi_message.exception_add
3343: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'
3344: ) then
3345: hr_utility.set_location(' Leaving:'||l_proc,6);
3346: raise;

Line 3508: if hr_multi_message.no_exclusive_error

3504: --
3505: --
3506: if (p_region_1 is null) then
3507: --
3508: if hr_multi_message.no_exclusive_error
3509: (p_check_column1 => 'PER_ADDRESSES.REGION_2'
3510: ,p_check_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3511: ) then
3512: --

Line 3524: hr_multi_message.add

3520: if(csr_val_st_city%notfound) then
3521: close csr_val_st_city;
3522: hr_utility.set_location(l_proc, 50);
3523: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3524: hr_multi_message.add
3525: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3526: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3527: );
3528: else

Line 3534: if hr_multi_message.no_exclusive_error

3530: hr_utility.set_location(l_proc, 60);
3531: --
3532: -- check for a valid state, city, zip combination
3533: --
3534: if hr_multi_message.no_exclusive_error
3535: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'
3536: ) then
3537: --
3538: open csr_valid_zip_code_no_ncty;

Line 3544: hr_multi_message.add

3540: if csr_valid_zip_code_no_ncty%notfound then
3541: close csr_valid_zip_code_no_ncty;
3542: hr_utility.set_location(l_proc, 70);
3543: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3544: hr_multi_message.add
3545: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3546: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3547: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'
3548: );

Line 3566: if hr_multi_message.no_exclusive_error

3562: -- The county is supplied, so validate with it.
3563: --
3564: -- Validate the state and county combination
3565: --
3566: if hr_multi_message.no_exclusive_error
3567: (p_check_column1 => 'PER_ADDRESSES.REGION_1'
3568: ,p_check_column2 => 'PER_ADDRESSES.REGION_2'
3569: ) then
3570: --

Line 3580: hr_multi_message.add

3576: close csr_valid_state_county;
3577: --
3578: hr_utility.set_location(l_proc, 100);
3579: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3580: hr_multi_message.add
3581: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
3582: ,p_associated_column2 => 'PER_ADDRESSES.REGION_2'
3583: );
3584: else

Line 3591: if hr_multi_message.no_exclusive_error

3587: end if;
3588: --
3589: -- Validate the state, county and city combination
3590: --
3591: if hr_multi_message.no_exclusive_error
3592: (p_check_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'
3593: ) then
3594: open csr_val_st_county_city;
3595: fetch csr_val_st_county_city into l_city_code;

Line 3602: hr_multi_message.add

3598: close csr_val_st_county_city;
3599: --
3600: hr_utility.set_location(l_proc, 120);
3601: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3602: hr_multi_message.add
3603: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3604: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3605: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3606: );

Line 3614: if hr_multi_message.no_exclusive_error

3610: end if;
3611: --
3612: -- Validate the state, county, city and zip code combination
3613: --
3614: if hr_multi_message.no_exclusive_error
3615: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'
3616: ) then
3617: --
3618: open csr_valid_zip_code;

Line 3625: hr_multi_message.add

3621: close csr_valid_zip_code;
3622: --
3623: hr_utility.set_location(l_proc, 140);
3624: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3625: hr_multi_message.add
3626: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3627: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3628: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3629: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'

Line 3812: if hr_multi_message.no_exclusive_error

3808: l_postal_code := substr(p_tax_zip,1,5);
3809: --
3810: --
3811: if (p_tax_county is null) then
3812: if hr_multi_message.no_exclusive_error
3813: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3814: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3815: ) then
3816: hr_utility.set_location(l_proc, 40);

Line 3827: hr_multi_message.add

3823: if(csr_val_st_city%notfound) then
3824: close csr_val_st_city;
3825: hr_utility.set_location(l_proc, 50);
3826: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3827: hr_multi_message.add
3828: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3829: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3830: );
3831: else

Line 3837: if hr_multi_message.no_exclusive_error

3833: hr_utility.set_location(l_proc, 60);
3834: --
3835: -- check for a valid state, city, zip combination
3836: --
3837: if hr_multi_message.no_exclusive_error
3838: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
3839: ) then
3840: open csr_valid_zip_code_no_ncty;
3841: fetch csr_valid_zip_code_no_ncty into l_exists;

Line 3846: hr_multi_message.add

3842: if csr_valid_zip_code_no_ncty%notfound then
3843: close csr_valid_zip_code_no_ncty;
3844: hr_utility.set_location(l_proc, 70);
3845: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3846: hr_multi_message.add
3847: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3848: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3849: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION20'
3850: );

Line 3870: if hr_multi_message.no_exclusive_error

3866: -- The county is supplied, so validate with it.
3867: --
3868: -- Validate the state and county combination
3869: --
3870: if hr_multi_message.no_exclusive_error
3871: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3872: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3873: ) then
3874: --

Line 3884: hr_multi_message.add

3880: close csr_valid_state_county;
3881: --
3882: hr_utility.set_location(l_proc, 100);
3883: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3884: hr_multi_message.add
3885: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3886: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3887: );
3888: --

Line 3898: if hr_multi_message.no_exclusive_error

3894: end if;
3895: --
3896: -- Validate the state, county and city combination
3897: --
3898: if hr_multi_message.no_exclusive_error
3899: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'
3900: ) then
3901: open csr_val_st_county_city;
3902: fetch csr_val_st_county_city into l_city_code;

Line 3909: hr_multi_message.add

3905: close csr_val_st_county_city;
3906: --
3907: hr_utility.set_location(l_proc, 120);
3908: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3909: hr_multi_message.add
3910: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3911: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3912: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3913: );

Line 3924: if hr_multi_message.no_exclusive_error

3920: end if;
3921: --
3922: -- Validate the state, county, city and zip code combination
3923: --
3924: if hr_multi_message.no_exclusive_error
3925: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
3926: ) then
3927: open csr_valid_zip_code;
3928: fetch csr_valid_zip_code into l_exists;

Line 3934: hr_multi_message.add

3930: close csr_valid_zip_code;
3931: --
3932: hr_utility.set_location(l_proc, 140);
3933: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3934: hr_multi_message.add
3935: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3936: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3937: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3938: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'

Line 4530: hr_multi_message.end_validation_set;

4526: -- After validating the set of important attributes,
4527: -- if Mulitple message detection is enabled and at least
4528: -- one error has been found then abort further validation.
4529: --
4530: hr_multi_message.end_validation_set;
4531: --
4532: end if;
4533: --
4534: -- Validate Dependent Attributes

Line 4915: hr_multi_message.end_validation_set;

4911: -- After validating the set of important attributes,
4912: -- if Mulitple message detection is enabled and at least
4913: -- one error has been found then abort further validation.
4914: --
4915: hr_multi_message.end_validation_set;
4916: --
4917: end if;
4918: --
4919: -- HR/TCA merge