DBA Data[Home] [Help]

APPS.PAY_COUNTY_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 if operating in validation only mode
145: --
146: savepoint create_county_tax_rule;

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

145: --
146: savepoint create_county_tax_rule;
147:
148: --
149: hr_utility.set_location(l_proc, 15);
150: --
151: -- Process Logic
152: --
153: /*

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

197: open csr_defaulting_date(p_assignment_id);
198: Fetch csr_defaulting_date into l_defaulting_date;
199: If l_defaulting_date is null then
200: close csr_defaulting_date;
201: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
202: hr_utility.set_message_token('table_name', 'PAY_US_EMP_FED_TAX_RULES_F');
203: hr_utility.raise_error;
204: Else
205: l_jurisdiction_code := p_state_code||'-'||p_county_code||'-0000';

Line 202: hr_utility.set_message_token('table_name', 'PAY_US_EMP_FED_TAX_RULES_F');

198: Fetch csr_defaulting_date into l_defaulting_date;
199: If l_defaulting_date is null then
200: close csr_defaulting_date;
201: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
202: hr_utility.set_message_token('table_name', 'PAY_US_EMP_FED_TAX_RULES_F');
203: hr_utility.raise_error;
204: Else
205: l_jurisdiction_code := p_state_code||'-'||p_county_code||'-0000';
206: close csr_defaulting_date;

Line 203: hr_utility.raise_error;

199: If l_defaulting_date is null then
200: close csr_defaulting_date;
201: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
202: hr_utility.set_message_token('table_name', 'PAY_US_EMP_FED_TAX_RULES_F');
203: hr_utility.raise_error;
204: Else
205: l_jurisdiction_code := p_state_code||'-'||p_county_code||'-0000';
206: close csr_defaulting_date;
207: hr_utility.set_location(l_proc, 20);

Line 207: hr_utility.set_location(l_proc, 20);

203: hr_utility.raise_error;
204: Else
205: l_jurisdiction_code := p_state_code||'-'||p_county_code||'-0000';
206: close csr_defaulting_date;
207: hr_utility.set_location(l_proc, 20);
208:
209: /** added for bug 13891625**/
210: open csr_county_tax_rule;
211: fetch csr_county_tax_rule into l_dummy;

Line 217: hr_utility.set_message(801, 'PAY_75275_COUNTY_TAX_ONE_RULE');

213: close csr_county_tax_rule;
214: --
215: -- This county tax rule already exists
216: --
217: hr_utility.set_message(801, 'PAY_75275_COUNTY_TAX_ONE_RULE');
218: hr_utility.raise_error;
219: end if;
220: close csr_county_tax_rule;
221: -- End of changes for bug 13891625

Line 218: hr_utility.raise_error;

214: --
215: -- This county tax rule already exists
216: --
217: hr_utility.set_message(801, 'PAY_75275_COUNTY_TAX_ONE_RULE');
218: hr_utility.raise_error;
219: end if;
220: close csr_county_tax_rule;
221: -- End of changes for bug 13891625
222:

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

306: ,p_cnt_information29 => p_cnt_information29
307: ,p_cnt_information30 => p_cnt_information30
308: );
309: --
310: hr_utility.set_location(l_proc, 25);
311: --
312: pay_us_tax_internal.maintain_tax_percentage
313: (
314: p_assignment_id => p_assignment_id,

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

332: );
333: End if;
334: Else
335: close csr_derive_business_grp;
336: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
337: hr_utility.set_message_token('PROCEDURE', l_proc);
338: hr_utility.set_message_token('STEP','30');
339: hr_utility.raise_error;
340: End if;

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

333: End if;
334: Else
335: close csr_derive_business_grp;
336: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
337: hr_utility.set_message_token('PROCEDURE', l_proc);
338: hr_utility.set_message_token('STEP','30');
339: hr_utility.raise_error;
340: End if;
341: --

Line 338: hr_utility.set_message_token('STEP','30');

334: Else
335: close csr_derive_business_grp;
336: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
337: hr_utility.set_message_token('PROCEDURE', l_proc);
338: hr_utility.set_message_token('STEP','30');
339: hr_utility.raise_error;
340: End if;
341: --
342: --

Line 339: hr_utility.raise_error;

335: close csr_derive_business_grp;
336: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
337: hr_utility.set_message_token('PROCEDURE', l_proc);
338: hr_utility.set_message_token('STEP','30');
339: hr_utility.raise_error;
340: End if;
341: --
342: --
343: /*

Line 383: hr_utility.set_location(l_proc, 40);

379: --
380: end;
381: */
382: --
383: hr_utility.set_location(l_proc, 40);
384: --
385: -- When in validation only mode raise the Validate_Enabled exception
386: --
387: if p_validate then

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

394: p_effective_start_date := l_effective_start_date;
395: p_effective_end_date := l_effective_end_date;
396: p_object_version_number := l_object_version_number;
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 50);
399: --
400: exception
401: --
402: when hr_api.validate_enabled then

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

413: p_emp_county_tax_rule_id := null;
414: p_effective_start_date := null;
415: p_effective_end_date := null;
416: p_object_version_number := null;
417: hr_utility.set_location(' Leaving:'||l_proc, 70);
418: --
419: when others then
420: --
421: -- A validation or unexpected error has occurred

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

539: AND ctr.effective_end_date;
540: --
541: begin
542: --
543: hr_utility.set_location('Entering:'|| l_proc, 10);
544: --
545: -- Issue a savepoint if operating in validation only mode
546: --
547: savepoint update_county_tax_rule;

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

546: --
547: savepoint update_county_tax_rule;
548:
549: --
550: hr_utility.set_location(l_proc, 15);
551: --
552: -- Check to see if we need to maintain the tax records.
553: --
554: IF hr_general.chk_maintain_tax_records = 'N' Then

Line 601: hr_utility.set_location(l_proc, 20);

597: --
598: end;
599: */
600: --
601: hr_utility.set_location(l_proc, 20);
602: --
603: pay_cnt_upd.upd
604: (
605: p_emp_county_tax_rule_id => p_emp_county_tax_rule_id

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

688: -- table if the county 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_county_tax_rule_id,
694: p_effective_date);
695: FETCH csr_assignment_id
696: INTO l_assignment_id,

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

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

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

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

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

772: --
773: p_object_version_number := l_object_version_number;
774: p_effective_start_date := null;
775: p_effective_end_date := null;
776: hr_utility.set_location(' Leaving:'||l_proc, 50);
777: --
778: when others then
779: --
780: -- 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_cnt_shd.lck
820: (
821: p_emp_county_tax_rule_id => p_emp_county_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_county_tax_rule_api;