APPS.PAY_TXR_UPD dependencies on HR_API

Line 91: When hr_api.check_integrity_violated Then

87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: --
94: pay_txr_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: --
94: pay_txr_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: pay_txr_shd.constraint_error

Line 96: When hr_api.parent_integrity_violated Then

92: -- A check constraint has been violated
93: --
94: pay_txr_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: pay_txr_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: pay_txr_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: pay_txr_shd.constraint_error

Line 101: When hr_api.unique_integrity_violated Then

97: -- Parent integrity has been violated
98: --
99: pay_txr_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: pay_txr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: pay_txr_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: --
108: Raise;
109: End update_dml;

Line 224: when hr_api.cannot_find_prog_unit then

220: );
221: --
222: exception
223: --
224: when hr_api.cannot_find_prog_unit then
225: --
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'PAY_TAXABILITY_RULES'
228: ,p_hook_type => 'AU');

Line 226: hr_api.cannot_find_prog_unit_error

222: exception
223: --
224: when hr_api.cannot_find_prog_unit then
225: --
226: hr_api.cannot_find_prog_unit_error
227: (p_module_name => 'PAY_TAXABILITY_RULES'
228: ,p_hook_type => 'AU');
229: --
230: end;

Line 289: If (p_rec.legislation_code = hr_api.g_varchar2) then

285: -- p_rec plsql record structure
286: -- to see if a system default is being used. If a system default
287: -- is being used then we must set to the 'current' argument value.
288: --
289: If (p_rec.legislation_code = hr_api.g_varchar2) then
290: p_rec.legislation_code :=
291: pay_txr_shd.g_old_rec.legislation_code;
292: End If;
293: If (p_rec.status = hr_api.g_varchar2) then

Line 293: If (p_rec.status = hr_api.g_varchar2) then

289: If (p_rec.legislation_code = hr_api.g_varchar2) then
290: p_rec.legislation_code :=
291: pay_txr_shd.g_old_rec.legislation_code;
292: End If;
293: If (p_rec.status = hr_api.g_varchar2) then
294: p_rec.status :=
295: pay_txr_shd.g_old_rec.status;
296: End If;
297: --

Line 364: ,p_tax_type in varchar2 default hr_api.g_varchar2

360: -- ----------------------------------------------------------------------------
361: Procedure upd
362: (p_effective_date in date
363: ,p_jurisdiction_code in varchar2
364: ,p_tax_type in varchar2 default hr_api.g_varchar2
365: ,p_tax_category in varchar2 default hr_api.g_varchar2
366: ,p_classification_id in number default hr_api.g_number
367: ,p_taxability_rules_date_id in number
368: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 365: ,p_tax_category in varchar2 default hr_api.g_varchar2

361: Procedure upd
362: (p_effective_date in date
363: ,p_jurisdiction_code in varchar2
364: ,p_tax_type in varchar2 default hr_api.g_varchar2
365: ,p_tax_category in varchar2 default hr_api.g_varchar2
366: ,p_classification_id in number default hr_api.g_number
367: ,p_taxability_rules_date_id in number
368: ,p_legislation_code in varchar2 default hr_api.g_varchar2
369: ,p_status in varchar2 default hr_api.g_varchar2

Line 366: ,p_classification_id in number default hr_api.g_number

362: (p_effective_date in date
363: ,p_jurisdiction_code in varchar2
364: ,p_tax_type in varchar2 default hr_api.g_varchar2
365: ,p_tax_category in varchar2 default hr_api.g_varchar2
366: ,p_classification_id in number default hr_api.g_number
367: ,p_taxability_rules_date_id in number
368: ,p_legislation_code in varchar2 default hr_api.g_varchar2
369: ,p_status in varchar2 default hr_api.g_varchar2
370: ,p_secondary_classification_id in number default hr_api.g_number

Line 368: ,p_legislation_code in varchar2 default hr_api.g_varchar2

364: ,p_tax_type in varchar2 default hr_api.g_varchar2
365: ,p_tax_category in varchar2 default hr_api.g_varchar2
366: ,p_classification_id in number default hr_api.g_number
367: ,p_taxability_rules_date_id in number
368: ,p_legislation_code in varchar2 default hr_api.g_varchar2
369: ,p_status in varchar2 default hr_api.g_varchar2
370: ,p_secondary_classification_id in number default hr_api.g_number
371: ) is
372: --

Line 369: ,p_status in varchar2 default hr_api.g_varchar2

365: ,p_tax_category in varchar2 default hr_api.g_varchar2
366: ,p_classification_id in number default hr_api.g_number
367: ,p_taxability_rules_date_id in number
368: ,p_legislation_code in varchar2 default hr_api.g_varchar2
369: ,p_status in varchar2 default hr_api.g_varchar2
370: ,p_secondary_classification_id in number default hr_api.g_number
371: ) is
372: --
373: l_rec pay_txr_shd.g_rec_type;

Line 370: ,p_secondary_classification_id in number default hr_api.g_number

366: ,p_classification_id in number default hr_api.g_number
367: ,p_taxability_rules_date_id in number
368: ,p_legislation_code in varchar2 default hr_api.g_varchar2
369: ,p_status in varchar2 default hr_api.g_varchar2
370: ,p_secondary_classification_id in number default hr_api.g_number
371: ) is
372: --
373: l_rec pay_txr_shd.g_rec_type;
374: l_proc varchar2(72) := g_package||'upd';