DBA Data[Home] [Help]

APPS.PAY_COUNTY_TAX_RULE_API dependencies on HR_UTILITY

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

127: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE := null;
128: --
129: begin
130: --
131: hr_utility.set_location('Entering:'|| l_proc, 10);
132: --
133: -- Issue a savepoint if operating in validation only mode
134: --
135: savepoint create_county_tax_rule;

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

134: --
135: savepoint create_county_tax_rule;
136:
137: --
138: hr_utility.set_location(l_proc, 15);
139: --
140: -- Process Logic
141: --
142: /*

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

186: open csr_defaulting_date(p_assignment_id);
187: Fetch csr_defaulting_date into l_defaulting_date;
188: If l_defaulting_date is null then
189: close csr_defaulting_date;
190: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
191: hr_utility.set_message_token('table_name', 'PAY_US_EMP_FED_TAX_RULES_F');
192: hr_utility.raise_error;
193: Else
194: l_jurisdiction_code := p_state_code||'-'||p_county_code||'-0000';

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

187: Fetch csr_defaulting_date into l_defaulting_date;
188: If l_defaulting_date is null then
189: close csr_defaulting_date;
190: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
191: hr_utility.set_message_token('table_name', 'PAY_US_EMP_FED_TAX_RULES_F');
192: hr_utility.raise_error;
193: Else
194: l_jurisdiction_code := p_state_code||'-'||p_county_code||'-0000';
195: close csr_defaulting_date;

Line 192: hr_utility.raise_error;

188: If l_defaulting_date is null then
189: close csr_defaulting_date;
190: hr_utility.set_message(801, 'HR_7182_DT_NO_MIN_MAX_ROWS');
191: hr_utility.set_message_token('table_name', 'PAY_US_EMP_FED_TAX_RULES_F');
192: hr_utility.raise_error;
193: Else
194: l_jurisdiction_code := p_state_code||'-'||p_county_code||'-0000';
195: close csr_defaulting_date;
196: hr_utility.set_location(l_proc, 20);

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

192: hr_utility.raise_error;
193: Else
194: l_jurisdiction_code := p_state_code||'-'||p_county_code||'-0000';
195: close csr_defaulting_date;
196: hr_utility.set_location(l_proc, 20);
197: pay_cnt_ins.ins
198: (
199: p_emp_county_tax_rule_id => l_emp_county_tax_rule_id
200: ,p_effective_start_date => l_effective_start_date

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

280: ,p_cnt_information29 => p_cnt_information29
281: ,p_cnt_information30 => p_cnt_information30
282: );
283: --
284: hr_utility.set_location(l_proc, 25);
285: --
286: pay_us_tax_internal.maintain_tax_percentage
287: (
288: p_assignment_id => p_assignment_id,

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

306: );
307: End if;
308: Else
309: close csr_derive_business_grp;
310: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','30');
313: hr_utility.raise_error;
314: End if;

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

307: End if;
308: Else
309: close csr_derive_business_grp;
310: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','30');
313: hr_utility.raise_error;
314: End if;
315: --

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

308: Else
309: close csr_derive_business_grp;
310: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','30');
313: hr_utility.raise_error;
314: End if;
315: --
316: --

Line 313: hr_utility.raise_error;

309: close csr_derive_business_grp;
310: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
311: hr_utility.set_message_token('PROCEDURE', l_proc);
312: hr_utility.set_message_token('STEP','30');
313: hr_utility.raise_error;
314: End if;
315: --
316: --
317: /*

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

353: --
354: end;
355: */
356: --
357: hr_utility.set_location(l_proc, 40);
358: --
359: -- When in validation only mode raise the Validate_Enabled exception
360: --
361: if p_validate then

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

368: p_effective_start_date := l_effective_start_date;
369: p_effective_end_date := l_effective_end_date;
370: p_object_version_number := l_object_version_number;
371: --
372: hr_utility.set_location(' Leaving:'||l_proc, 50);
373: --
374: exception
375: --
376: when hr_api.validate_enabled then

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

387: p_emp_county_tax_rule_id := null;
388: p_effective_start_date := null;
389: p_effective_end_date := null;
390: p_object_version_number := null;
391: hr_utility.set_location(' Leaving:'||l_proc, 70);
392: --
393: when others then
394: --
395: -- A validation or unexpected error has occurred

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

513: AND ctr.effective_end_date;
514: --
515: begin
516: --
517: hr_utility.set_location('Entering:'|| l_proc, 10);
518: --
519: -- Issue a savepoint if operating in validation only mode
520: --
521: savepoint update_county_tax_rule;

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

520: --
521: savepoint update_county_tax_rule;
522:
523: --
524: hr_utility.set_location(l_proc, 15);
525: --
526: -- Check to see if we need to maintain the tax records.
527: --
528: IF hr_general.chk_maintain_tax_records = 'N' Then

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

571: --
572: end;
573: */
574: --
575: hr_utility.set_location(l_proc, 20);
576: --
577: pay_cnt_upd.upd
578: (
579: p_emp_county_tax_rule_id => p_emp_county_tax_rule_id

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

662: -- table if the county school district has changed
663: --
664: if p_school_district_code IS NOT NULL AND
665: p_school_district_code <> hr_api.g_varchar2 THEN
666: hr_utility.set_location(l_proc, 22);
667: OPEN csr_assignment_id(p_emp_county_tax_rule_id,
668: p_effective_date);
669: FETCH csr_assignment_id
670: 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 791: hr_utility.set_location('Entering:'|| l_proc, 10);

787: l_validation_end_date date;
788: --
789: begin
790: --
791: hr_utility.set_location('Entering:'|| l_proc, 10);
792: --
793: pay_cnt_shd.lck
794: (
795: p_emp_county_tax_rule_id => p_emp_county_tax_rule_id

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

799: ,p_effective_date => p_effective_date
800: ,p_datetrack_mode => p_datetrack_mode
801: );
802: --
803: hr_utility.set_location(' Leaving:'||l_proc, 70);
804: --
805: end lck;
806: --
807: end pay_county_tax_rule_api;