2523: where cu.issuing_territory_code = p_legislation_code
2524: and cu.enabled_flag = 'Y';
2525: exception
2526: when too_many_rows then
2527: fnd_message.set_name('PAY','HR_51885_MISSING_DC_RULE');
2528: fnd_message.raise_error;
2529: when no_data_found then
2530: fnd_message.set_name('PAY','HR_7989_HR_DEFAULT_CURRENCY');
2531: fnd_message.raise_error;
2524: and cu.enabled_flag = 'Y';
2525: exception
2526: when too_many_rows then
2527: fnd_message.set_name('PAY','HR_51885_MISSING_DC_RULE');
2528: fnd_message.raise_error;
2529: when no_data_found then
2530: fnd_message.set_name('PAY','HR_7989_HR_DEFAULT_CURRENCY');
2531: fnd_message.raise_error;
2532: end;
2526: when too_many_rows then
2527: fnd_message.set_name('PAY','HR_51885_MISSING_DC_RULE');
2528: fnd_message.raise_error;
2529: when no_data_found then
2530: fnd_message.set_name('PAY','HR_7989_HR_DEFAULT_CURRENCY');
2531: fnd_message.raise_error;
2532: end;
2533: --
2534: else
2527: fnd_message.set_name('PAY','HR_51885_MISSING_DC_RULE');
2528: fnd_message.raise_error;
2529: when no_data_found then
2530: fnd_message.set_name('PAY','HR_7989_HR_DEFAULT_CURRENCY');
2531: fnd_message.raise_error;
2532: end;
2533: --
2534: else
2535: close csr_leg_rule;