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 1063: if hr_multi_message.no_all_inclusive_error

1059: ,p_argument => 'primary_flag'
1060: ,p_argument_value => p_primary_flag
1061: );
1062: hr_utility.set_location(l_proc, 20);
1063: if hr_multi_message.no_all_inclusive_error
1064: (p_check_column1 => 'PER_ADDRESSES.DATE_FROM'
1065: ,p_check_column2 => 'PER_ADDRESSES.DATE_TO'
1066: ,p_check_column3 => 'PER_ADDRESSES.PERSON_ID'
1067: ,p_check_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1110: hr_multi_message.add

1106: fetch csr_dup_add_type_exists into l_exists;
1107: if csr_dup_add_type_exists%found then
1108: close csr_dup_add_type_exists;
1109: hr_utility.set_message(801, 'HR_51139_ADD_TYPE_ALR_EXIST');
1110: hr_multi_message.add
1111: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1112: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1113: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1114: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1146: hr_multi_message.add

1142: fetch csr_dup_prim_flag into l_exists;
1143: if csr_dup_prim_flag%found then
1144: close csr_dup_prim_flag;
1145: hr_utility.set_message(801, 'HR_7327_ADD_PRIMARY_ADD_EXISTS');
1146: hr_multi_message.add
1147: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1148: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1149: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1150: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1212: hr_multi_message.add

1208: and l_recs_after)
1209: or
1210: (l_good_recs < 1)) then
1211: hr_utility.set_message(801, 'HR_51030_ADDR_PRIM_GAP');
1212: hr_multi_message.add
1213: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1214: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1215: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1216: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1239: hr_multi_message.add

1235: fetch csr_invalid_non_prim into l_exists;
1236: if csr_invalid_non_prim%found then
1237: close csr_invalid_non_prim;
1238: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1239: hr_multi_message.add
1240: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1241: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1242: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1243: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1268: hr_multi_message.add

1264: fetch csr_no_primary into l_exists;
1265: if csr_no_primary%notfound then
1266: close csr_no_primary;
1267: hr_utility.set_message(801, 'HR_7302_ADD_PRIMARY_DATES');
1268: hr_multi_message.add
1269: (p_associated_column1 => 'PER_ADDRESSES.DATE_FROM'
1270: ,p_associated_column2 => 'PER_ADDRESSES.DATE_TO'
1271: ,p_associated_column3 => 'PER_ADDRESSES.PERSON_ID'
1272: ,p_associated_column4 => 'PER_ADDRESSES.PARTY_ID'

Line 1303: hr_multi_message.add();

1299: and l_action_eff_date between date_from
1300: and nvl(date_to,l_action_eff_date);
1301: if l_address_count = 0 then
1302: hr_utility.set_message(800, 'PER_PAYROLL_EXISTS');
1303: hr_multi_message.add();
1304: end if;
1305: end if;
1306: end loop;
1307: end loop;

Line 1394: if hr_multi_message.exception_add

1390: --
1391: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1392: exception
1393: when app_exception.application_exception then
1394: if hr_multi_message.exception_add
1395: (p_associated_column1 => 'PER_ADDRESSES.STYLE'
1396: ) then
1397: hr_utility.set_location(' Leaving:'||l_proc,5);
1398: raise;

Line 1402: hr_multi_message.end_validation_set;

1398: raise;
1399: end if;
1400: -- Call to raise any errors on multi-message list
1401: -- Taking STYLE as an important parameter.
1402: hr_multi_message.end_validation_set;
1403: hr_utility.set_location(' Leaving:'||l_proc,6);
1404: --
1405: end chk_style;
1406: --

Line 1461: if hr_multi_message.no_exclusive_error

1457: -- Check 'GB' address style
1458: --
1459: if p_style = 'GB' then
1460: if p_region_2 is not null then
1461: if hr_multi_message.no_exclusive_error
1462: (p_check_column1 => 'PER_ADDRESSES.REGION_2') then
1463: --
1464: l_token := 'region_2';
1465: raise l_error;

Line 1534: hr_multi_message.add(

1530: exception
1531: when l_error then
1532: hr_utility.set_message(801, 'HR_7324_ADD_ADD_ATTRIBUTE_NULL');
1533: hr_utility.set_message_token('ARGUMENT', l_token);
1534: hr_multi_message.add(
1535: p_associated_column1 =>
1536: (per_add_shd.g_tab_nam || '.' || upper(l_token))
1537: );
1538: when others then

Line 1630: if hr_multi_message.exception_add

1626: --
1627: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1628: exception
1629: when app_exception.application_exception then
1630: if hr_multi_message.exception_add
1631: (p_associated_column1 => 'PER_ADDRESSES.ADDRESS_LINE1'
1632: ) then
1633: hr_utility.set_location(' Leaving:'||l_proc,6);
1634: raise;

Line 2344: if hr_multi_message.exception_add

2340: --
2341: hr_utility.set_location(' Leaving:'|| l_proc, 9);
2342: exception
2343: when app_exception.application_exception then
2344: if hr_multi_message.exception_add
2345: (p_associated_column1 => 'PER_ADDRESSES.POSTAL_CODE'
2346: ) then
2347: hr_utility.set_location(' Leaving:'||l_proc,10);
2348: raise;

Line 2517: if hr_multi_message.exception_add

2513: end if;
2514: hr_utility.set_location(' Leaving:'|| l_proc, 7);
2515: exception
2516: when app_exception.application_exception then
2517: if hr_multi_message.exception_add
2518: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
2519: ) then
2520: hr_utility.set_location(' Leaving:'||l_proc,6);
2521: raise;

Line 2674: if hr_multi_message.exception_add

2670: end if;
2671: hr_utility.set_location(' Leaving:'|| l_proc, 6);
2672: exception
2673: when app_exception.application_exception then
2674: if hr_multi_message.exception_add
2675: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
2676: ) then
2677: hr_utility.set_location(' Leaving:'||l_proc,7);
2678: raise;

Line 2796: if hr_multi_message.exception_add

2792: end if;
2793: hr_utility.set_location(' Leaving:'|| l_proc, 6);
2794: exception
2795: when app_exception.application_exception then
2796: if hr_multi_message.exception_add
2797: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION19'
2798: ) then
2799: hr_utility.set_location(' Leaving:'||l_proc,7);
2800: raise;

Line 2956: if hr_multi_message.exception_add

2952: --
2953: hr_utility.set_location(' Leaving:'|| l_proc, 10);
2954: exception
2955: when app_exception.application_exception then
2956: if hr_multi_message.exception_add
2957: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
2958: ) then
2959: hr_utility.set_location(' Leaving:'||l_proc,11);
2960: raise;

Line 3100: if hr_multi_message.exception_add

3096: --
3097: hr_utility.set_location(' Leaving:'|| l_proc, 10);
3098: exception
3099: when app_exception.application_exception then
3100: if hr_multi_message.exception_add
3101: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3102: ) then
3103: hr_utility.set_location(' Leaving:'||l_proc,11);
3104: raise;

Line 3215: if hr_multi_message.exception_add

3211: --
3212: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3213: exception
3214: when app_exception.application_exception then
3215: if hr_multi_message.exception_add
3216: (p_associated_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'
3217: ) then
3218: hr_utility.set_location(' Leaving:'||l_proc,6);
3219: raise;

Line 3323: if hr_multi_message.exception_add

3319: end if;
3320: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3321: exception
3322: when app_exception.application_exception then
3323: if hr_multi_message.exception_add
3324: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'
3325: ) then
3326: hr_utility.set_location(' Leaving:'||l_proc,6);
3327: raise;

Line 3489: if hr_multi_message.no_exclusive_error

3485: --
3486: --
3487: if (p_region_1 is null) then
3488: --
3489: if hr_multi_message.no_exclusive_error
3490: (p_check_column1 => 'PER_ADDRESSES.REGION_2'
3491: ,p_check_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3492: ) then
3493: --

Line 3505: hr_multi_message.add

3501: if(csr_val_st_city%notfound) then
3502: close csr_val_st_city;
3503: hr_utility.set_location(l_proc, 50);
3504: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3505: hr_multi_message.add
3506: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3507: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3508: );
3509: else

Line 3515: if hr_multi_message.no_exclusive_error

3511: hr_utility.set_location(l_proc, 60);
3512: --
3513: -- check for a valid state, city, zip combination
3514: --
3515: if hr_multi_message.no_exclusive_error
3516: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'
3517: ) then
3518: --
3519: open csr_valid_zip_code_no_ncty;

Line 3525: hr_multi_message.add

3521: if csr_valid_zip_code_no_ncty%notfound then
3522: close csr_valid_zip_code_no_ncty;
3523: hr_utility.set_location(l_proc, 70);
3524: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3525: hr_multi_message.add
3526: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3527: ,p_associated_column2 => 'PER_ADDRESSES.TOWN_OR_CITY'
3528: ,p_associated_column3 => 'PER_ADDRESSES.POSTAL_CODE'
3529: );

Line 3547: if hr_multi_message.no_exclusive_error

3543: -- The county is supplied, so validate with it.
3544: --
3545: -- Validate the state and county combination
3546: --
3547: if hr_multi_message.no_exclusive_error
3548: (p_check_column1 => 'PER_ADDRESSES.REGION_1'
3549: ,p_check_column2 => 'PER_ADDRESSES.REGION_2'
3550: ) then
3551: --

Line 3561: hr_multi_message.add

3557: close csr_valid_state_county;
3558: --
3559: hr_utility.set_location(l_proc, 100);
3560: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3561: hr_multi_message.add
3562: (p_associated_column1 => 'PER_ADDRESSES.REGION_1'
3563: ,p_associated_column2 => 'PER_ADDRESSES.REGION_2'
3564: );
3565: else

Line 3572: if hr_multi_message.no_exclusive_error

3568: end if;
3569: --
3570: -- Validate the state, county and city combination
3571: --
3572: if hr_multi_message.no_exclusive_error
3573: (p_check_column1 => 'PER_ADDRESSES.TOWN_OR_CITY'
3574: ) then
3575: open csr_val_st_county_city;
3576: fetch csr_val_st_county_city into l_city_code;

Line 3583: hr_multi_message.add

3579: close csr_val_st_county_city;
3580: --
3581: hr_utility.set_location(l_proc, 120);
3582: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3583: hr_multi_message.add
3584: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3585: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3586: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3587: );

Line 3595: if hr_multi_message.no_exclusive_error

3591: end if;
3592: --
3593: -- Validate the state, county, city and zip code combination
3594: --
3595: if hr_multi_message.no_exclusive_error
3596: (p_check_column1 => 'PER_ADDRESSES.POSTAL_CODE'
3597: ) then
3598: --
3599: open csr_valid_zip_code;

Line 3606: hr_multi_message.add

3602: close csr_valid_zip_code;
3603: --
3604: hr_utility.set_location(l_proc, 140);
3605: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3606: hr_multi_message.add
3607: (p_associated_column1 => 'PER_ADDRESSES.REGION_2'
3608: ,p_associated_column2 => 'PER_ADDRESSES.REGION_1'
3609: ,p_associated_column3 => 'PER_ADDRESSES.TOWN_OR_CITY'
3610: ,p_associated_column4 => 'PER_ADDRESSES.POSTAL_CODE'

Line 3793: if hr_multi_message.no_exclusive_error

3789: l_postal_code := substr(p_tax_zip,1,5);
3790: --
3791: --
3792: if (p_tax_county is null) then
3793: if hr_multi_message.no_exclusive_error
3794: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3795: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3796: ) then
3797: hr_utility.set_location(l_proc, 40);

Line 3808: hr_multi_message.add

3804: if(csr_val_st_city%notfound) then
3805: close csr_val_st_city;
3806: hr_utility.set_location(l_proc, 50);
3807: hr_utility.set_message(800, 'PER_52531_ADD_INV_STCI_COMB');
3808: hr_multi_message.add
3809: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3810: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3811: );
3812: else

Line 3818: if hr_multi_message.no_exclusive_error

3814: hr_utility.set_location(l_proc, 60);
3815: --
3816: -- check for a valid state, city, zip combination
3817: --
3818: if hr_multi_message.no_exclusive_error
3819: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
3820: ) then
3821: open csr_valid_zip_code_no_ncty;
3822: fetch csr_valid_zip_code_no_ncty into l_exists;

Line 3827: hr_multi_message.add

3823: if csr_valid_zip_code_no_ncty%notfound then
3824: close csr_valid_zip_code_no_ncty;
3825: hr_utility.set_location(l_proc, 70);
3826: hr_utility.set_message(800, 'PER_52532_ADD_INV_STCIZ_COMB');
3827: hr_multi_message.add
3828: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3829: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3830: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION20'
3831: );

Line 3851: if hr_multi_message.no_exclusive_error

3847: -- The county is supplied, so validate with it.
3848: --
3849: -- Validate the state and county combination
3850: --
3851: if hr_multi_message.no_exclusive_error
3852: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3853: ,p_check_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3854: ) then
3855: --

Line 3865: hr_multi_message.add

3861: close csr_valid_state_county;
3862: --
3863: hr_utility.set_location(l_proc, 100);
3864: hr_utility.set_message(800, 'PER_52988_ADD_INV_STCOU_COMB');
3865: hr_multi_message.add
3866: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3867: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION19'
3868: );
3869: --

Line 3879: if hr_multi_message.no_exclusive_error

3875: end if;
3876: --
3877: -- Validate the state, county and city combination
3878: --
3879: if hr_multi_message.no_exclusive_error
3880: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION18'
3881: ) then
3882: open csr_val_st_county_city;
3883: fetch csr_val_st_county_city into l_city_code;

Line 3890: hr_multi_message.add

3886: close csr_val_st_county_city;
3887: --
3888: hr_utility.set_location(l_proc, 120);
3889: hr_utility.set_message(800, 'PER_52987_ADD_INV_STCOCY_COMB');
3890: hr_multi_message.add
3891: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3892: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3893: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3894: );

Line 3905: if hr_multi_message.no_exclusive_error

3901: end if;
3902: --
3903: -- Validate the state, county, city and zip code combination
3904: --
3905: if hr_multi_message.no_exclusive_error
3906: (p_check_column1 => 'PER_ADDRESSES.ADD_INFORMATION20'
3907: ) then
3908: open csr_valid_zip_code;
3909: fetch csr_valid_zip_code into l_exists;

Line 3915: hr_multi_message.add

3911: close csr_valid_zip_code;
3912: --
3913: hr_utility.set_location(l_proc, 140);
3914: hr_utility.set_message(801, 'HR_51282_ADD_INV_ZIP_FOR_CITY');
3915: hr_multi_message.add
3916: (p_associated_column1 => 'PER_ADDRESSES.ADD_INFORMATION17'
3917: ,p_associated_column2 => 'PER_ADDRESSES.ADD_INFORMATION18'
3918: ,p_associated_column3 => 'PER_ADDRESSES.ADD_INFORMATION19'
3919: ,p_associated_column4 => 'PER_ADDRESSES.ADD_INFORMATION20'

Line 4511: hr_multi_message.end_validation_set;

4507: -- After validating the set of important attributes,
4508: -- if Mulitple message detection is enabled and at least
4509: -- one error has been found then abort further validation.
4510: --
4511: hr_multi_message.end_validation_set;
4512: --
4513: end if;
4514: --
4515: -- Validate Dependent Attributes

Line 4896: hr_multi_message.end_validation_set;

4892: -- After validating the set of important attributes,
4893: -- if Mulitple message detection is enabled and at least
4894: -- one error has been found then abort further validation.
4895: --
4896: hr_multi_message.end_validation_set;
4897: --
4898: end if;
4899: --
4900: -- HR/TCA merge