125: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
126: --
127: begin
128: --
129: hr_utility.set_location('Entering:'|| l_proc, 10);
130: --
131: -- Issue a savepoint
132: --
133: savepoint create_city_tax_rule;
132: --
133: savepoint create_city_tax_rule;
134:
135: --
136: hr_utility.set_location(l_proc, 15);
137: --
138: -- Process Logic
139: --
140: -- Derive the jurisdiction code
148: if csr_derive_business_grp%found then
149: close csr_derive_business_grp;
150: else
151: close csr_derive_business_grp;
152: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
153: hr_utility.set_message_token('PROCEDURE', l_proc);
154: hr_utility.set_message_token('step','20');
155: hr_utility.raise_error;
156: end if;
149: close csr_derive_business_grp;
150: else
151: close csr_derive_business_grp;
152: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
153: hr_utility.set_message_token('PROCEDURE', l_proc);
154: hr_utility.set_message_token('step','20');
155: hr_utility.raise_error;
156: end if;
157: /*
150: else
151: close csr_derive_business_grp;
152: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
153: hr_utility.set_message_token('PROCEDURE', l_proc);
154: hr_utility.set_message_token('step','20');
155: hr_utility.raise_error;
156: end if;
157: /*
158: begin
151: close csr_derive_business_grp;
152: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
153: hr_utility.set_message_token('PROCEDURE', l_proc);
154: hr_utility.set_message_token('step','20');
155: hr_utility.raise_error;
156: end if;
157: /*
158: begin
159: --
198: open csr_defaulting_date(p_assignment_id);
199: fetch csr_defaulting_date into l_defaulting_date;
200: if l_defaulting_date is null then
201: close csr_defaulting_date;
202: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
203: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');
204: hr_utility.set_message_token('step','25');
205: hr_utility.raise_error;
206: else
199: fetch csr_defaulting_date into l_defaulting_date;
200: if l_defaulting_date is null then
201: close csr_defaulting_date;
202: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
203: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');
204: hr_utility.set_message_token('step','25');
205: hr_utility.raise_error;
206: else
207: close csr_defaulting_date;
200: if l_defaulting_date is null then
201: close csr_defaulting_date;
202: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
203: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');
204: hr_utility.set_message_token('step','25');
205: hr_utility.raise_error;
206: else
207: close csr_defaulting_date;
208: pay_cty_ins.ins
201: close csr_defaulting_date;
202: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
203: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');
204: hr_utility.set_message_token('step','25');
205: hr_utility.raise_error;
206: else
207: close csr_defaulting_date;
208: pay_cty_ins.ins
209: (
292: ,p_cty_information29 => p_cty_information29
293: ,p_cty_information30 => p_cty_information30
294: );
295: --
296: hr_utility.set_location(l_proc, 30);
297: --
298: pay_us_tax_internal.maintain_tax_percentage
299: (
300: p_assignment_id => p_assignment_id,
357: --
358: end;
359: */
360: --
361: hr_utility.set_location(l_proc, 35);
362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then
372: p_effective_start_date := l_effective_start_date;
373: p_effective_end_date := l_effective_end_date;
374: p_object_version_number := l_object_version_number;
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 40);
377: --
378: exception
379: --
380: when hr_api.validate_enabled then
391: p_emp_city_tax_rule_id := null;
392: p_effective_start_date := null;
393: p_effective_end_date := null;
394: p_object_version_number := null;
395: hr_utility.set_location(' Leaving:'||l_proc, 60);
396: --
397: when others then
398: --
399: -- A validation or unexpected error has occurred
514: AND ctr.effective_end_date;
515: --
516: begin
517: --
518: hr_utility.set_location('Entering:'|| l_proc, 10);
519: --
520: -- Issue a savepoint
521: --
522: savepoint update_city_tax_rule;
520: -- Issue a savepoint
521: --
522: savepoint update_city_tax_rule;
523: --
524: hr_utility.set_location(l_proc, 15);
525: --
526: -- Process Logic
527: --
528: -- Changed call to check hr_general.chk_maintain_tax_records to
660: -- table if this city school district has changed.
661: --
662: if p_school_district_code IS NOT NULL AND
663: p_school_district_code <> hr_api.g_varchar2 THEN
664: hr_utility.set_location(l_proc, 22);
665: OPEN csr_assignment_id(p_emp_city_tax_rule_id,
666: p_effective_date);
667: FETCH csr_assignment_id
668: INTO l_assignment_id,
714: --
715: end;
716: */
717: --
718: hr_utility.set_location(l_proc, 25);
719: --
720: -- When in validation only mode raise the Validate_Enabled exception
721: --
722: if p_validate then
728: p_object_version_number := l_object_version_number;
729: p_effective_start_date := l_effective_start_date;
730: p_effective_end_date := l_effective_end_date;
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 30);
733: --
734: exception
735: --
736: when hr_api.validate_enabled then
746: --
747: p_object_version_number := l_object_version_number;
748: p_effective_start_date := null;
749: p_effective_end_date := null;
750: hr_utility.set_location(' Leaving:'||l_proc, 50);
751: --
752: when others then
753: --
754: -- A validation or unexpected error has occurred
785: l_validation_end_date date;
786: --
787: begin
788: --
789: hr_utility.set_location('Entering:'|| l_proc, 10);
790: --
791: pay_cty_shd.lck
792: (
793: p_emp_city_tax_rule_id => p_emp_city_tax_rule_id
797: ,p_effective_date => p_effective_date
798: ,p_datetrack_mode => p_datetrack_mode
799: );
800: --
801: hr_utility.set_location(' Leaving:'||l_proc, 70);
802: --
803: end lck;
804: --
805: end pay_city_tax_rule_api;