DBA Data[Home] [Help]

APPS.PAY_CITY_TAX_RULE_API dependencies on HR_UTILITY

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

138: -- End of changes for bug 13891625
139:
140: begin
141: --
142: hr_utility.set_location('Entering:'|| l_proc, 10);
143: --
144: -- Issue a savepoint
145: --
146: savepoint create_city_tax_rule;

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

145: --
146: savepoint create_city_tax_rule;
147:
148: --
149: hr_utility.set_location(l_proc, 15);
150: --
151: -- Process Logic
152: --
153: -- Derive the jurisdiction code

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

161: if csr_derive_business_grp%found then
162: close csr_derive_business_grp;
163: else
164: close csr_derive_business_grp;
165: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
166: hr_utility.set_message_token('PROCEDURE', l_proc);
167: hr_utility.set_message_token('step','20');
168: hr_utility.raise_error;
169: end if;

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

162: close csr_derive_business_grp;
163: else
164: close csr_derive_business_grp;
165: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
166: hr_utility.set_message_token('PROCEDURE', l_proc);
167: hr_utility.set_message_token('step','20');
168: hr_utility.raise_error;
169: end if;
170: /*

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

163: else
164: close csr_derive_business_grp;
165: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
166: hr_utility.set_message_token('PROCEDURE', l_proc);
167: hr_utility.set_message_token('step','20');
168: hr_utility.raise_error;
169: end if;
170: /*
171: begin

Line 168: hr_utility.raise_error;

164: close csr_derive_business_grp;
165: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
166: hr_utility.set_message_token('PROCEDURE', l_proc);
167: hr_utility.set_message_token('step','20');
168: hr_utility.raise_error;
169: end if;
170: /*
171: begin
172: --

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

211: open csr_defaulting_date(p_assignment_id);
212: fetch csr_defaulting_date into l_defaulting_date;
213: if l_defaulting_date is null then
214: close csr_defaulting_date;
215: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
216: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');
217: hr_utility.set_message_token('step','25');
218: hr_utility.raise_error;
219: else

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

212: fetch csr_defaulting_date into l_defaulting_date;
213: if l_defaulting_date is null then
214: close csr_defaulting_date;
215: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
216: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');
217: hr_utility.set_message_token('step','25');
218: hr_utility.raise_error;
219: else
220: close csr_defaulting_date;

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

213: if l_defaulting_date is null then
214: close csr_defaulting_date;
215: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
216: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');
217: hr_utility.set_message_token('step','25');
218: hr_utility.raise_error;
219: else
220: close csr_defaulting_date;
221:

Line 218: hr_utility.raise_error;

214: close csr_defaulting_date;
215: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
216: hr_utility.set_message_token('table_name', 'pay_us_emp_fed_tax_rules_f');
217: hr_utility.set_message_token('step','25');
218: hr_utility.raise_error;
219: else
220: close csr_defaulting_date;
221:
222: --Bug 13891625:Check if the same state, county and city combination tax rule already exists

Line 230: hr_utility.set_message(801, 'PAY_75276_CITY_TAX_ONE_RULE');

226: close csr_city_tax_rule;
227: --
228: -- This city tax rule already exists
229: --
230: hr_utility.set_message(801, 'PAY_75276_CITY_TAX_ONE_RULE');
231: hr_utility.raise_error;
232: end if;
233: close csr_city_tax_rule;
234: -- End of changes for bug 13891625

Line 231: hr_utility.raise_error;

227: --
228: -- This city tax rule already exists
229: --
230: hr_utility.set_message(801, 'PAY_75276_CITY_TAX_ONE_RULE');
231: hr_utility.raise_error;
232: end if;
233: close csr_city_tax_rule;
234: -- End of changes for bug 13891625
235:

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

320: ,p_cty_information29 => p_cty_information29
321: ,p_cty_information30 => p_cty_information30
322: );
323: --
324: hr_utility.set_location(l_proc, 30);
325: --
326: pay_us_tax_internal.maintain_tax_percentage
327: (
328: p_assignment_id => p_assignment_id,

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

385: --
386: end;
387: */
388: --
389: hr_utility.set_location(l_proc, 35);
390: --
391: -- When in validation only mode raise the Validate_Enabled exception
392: --
393: if p_validate then

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

400: p_effective_start_date := l_effective_start_date;
401: p_effective_end_date := l_effective_end_date;
402: p_object_version_number := l_object_version_number;
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 40);
405: --
406: exception
407: --
408: when hr_api.validate_enabled then

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

419: p_emp_city_tax_rule_id := null;
420: p_effective_start_date := null;
421: p_effective_end_date := null;
422: p_object_version_number := null;
423: hr_utility.set_location(' Leaving:'||l_proc, 60);
424: --
425: when others then
426: --
427: -- A validation or unexpected error has occurred

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

542: AND ctr.effective_end_date;
543: --
544: begin
545: --
546: hr_utility.set_location('Entering:'|| l_proc, 10);
547: --
548: -- Issue a savepoint
549: --
550: savepoint update_city_tax_rule;

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

548: -- Issue a savepoint
549: --
550: savepoint update_city_tax_rule;
551: --
552: hr_utility.set_location(l_proc, 15);
553: --
554: -- Process Logic
555: --
556: -- Changed call to check hr_general.chk_maintain_tax_records to

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

688: -- table if this city school district has changed.
689: --
690: if p_school_district_code IS NOT NULL AND
691: p_school_district_code <> hr_api.g_varchar2 THEN
692: hr_utility.set_location(l_proc, 22);
693: OPEN csr_assignment_id(p_emp_city_tax_rule_id,
694: p_effective_date);
695: FETCH csr_assignment_id
696: INTO l_assignment_id,

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

742: --
743: end;
744: */
745: --
746: hr_utility.set_location(l_proc, 25);
747: --
748: -- When in validation only mode raise the Validate_Enabled exception
749: --
750: if p_validate then

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

756: p_object_version_number := l_object_version_number;
757: p_effective_start_date := l_effective_start_date;
758: p_effective_end_date := l_effective_end_date;
759: --
760: hr_utility.set_location(' Leaving:'||l_proc, 30);
761: --
762: exception
763: --
764: when hr_api.validate_enabled then

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

774: --
775: p_object_version_number := l_object_version_number;
776: p_effective_start_date := null;
777: p_effective_end_date := null;
778: hr_utility.set_location(' Leaving:'||l_proc, 50);
779: --
780: when others then
781: --
782: -- A validation or unexpected error has occurred

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

813: l_validation_end_date date;
814: --
815: begin
816: --
817: hr_utility.set_location('Entering:'|| l_proc, 10);
818: --
819: pay_cty_shd.lck
820: (
821: p_emp_city_tax_rule_id => p_emp_city_tax_rule_id

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

825: ,p_effective_date => p_effective_date
826: ,p_datetrack_mode => p_datetrack_mode
827: );
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 70);
830: --
831: end lck;
832: --
833: end pay_city_tax_rule_api;