DBA Data[Home] [Help]

APPS.PAY_CITY_TAX_RULE_API dependencies on HR_UTILITY

Line 129: hr_utility.set_location('Entering:'|| l_proc, 10);

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;

Line 136: hr_utility.set_location(l_proc, 15);

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

Line 152: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');

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;

Line 153: hr_utility.set_message_token('PROCEDURE', l_proc);

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: /*

Line 154: hr_utility.set_message_token('step','20');

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

Line 155: hr_utility.raise_error;

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: --

Line 202: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');

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

Line 203: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');

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;

Line 204: hr_utility.set_message_token('step','25');

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

Line 205: hr_utility.raise_error;

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: (

Line 296: hr_utility.set_location(l_proc, 30);

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,

Line 361: hr_utility.set_location(l_proc, 35);

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

Line 376: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

Line 395: hr_utility.set_location(' Leaving:'||l_proc, 60);

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

Line 518: hr_utility.set_location('Entering:'|| l_proc, 10);

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;

Line 524: hr_utility.set_location(l_proc, 15);

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

Line 664: hr_utility.set_location(l_proc, 22);

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,

Line 718: hr_utility.set_location(l_proc, 25);

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

Line 732: hr_utility.set_location(' Leaving:'||l_proc, 30);

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

Line 750: hr_utility.set_location(' Leaving:'||l_proc, 50);

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

Line 789: hr_utility.set_location('Entering:'|| l_proc, 10);

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

Line 801: hr_utility.set_location(' Leaving:'||l_proc, 70);

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;