DBA Data[Home] [Help]

APPS.PAY_APR_UPD dependencies on HR_API

Line 90: When hr_api.check_integrity_violated Then

86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
93: pay_apr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
93: pay_apr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
98: pay_apr_shd.constraint_error

Line 95: When hr_api.parent_integrity_violated Then

91: -- A check constraint has been violated
92: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
93: pay_apr_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
98: pay_apr_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
98: pay_apr_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
103: pay_apr_shd.constraint_error

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
98: pay_apr_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
103: pay_apr_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
103: pay_apr_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: pay_apr_shd.g_api_dml := false; -- Unset the api dml status
107: Raise;
108: End update_dml;

Line 256: If (p_rec.short_name = hr_api.g_varchar2) then

252: -- p_rec plsql record structure
253: -- to see if a system default is being used. If a system default
254: -- is being used then we must set to the 'current' argument value.
255: --
256: If (p_rec.short_name = hr_api.g_varchar2) then
257: p_rec.short_name :=
258: pay_apr_shd.g_old_rec.short_name;
259: End If;
260: If (p_rec.name = hr_api.g_varchar2) then

Line 260: If (p_rec.name = hr_api.g_varchar2) then

256: If (p_rec.short_name = hr_api.g_varchar2) then
257: p_rec.short_name :=
258: pay_apr_shd.g_old_rec.short_name;
259: End If;
260: If (p_rec.name = hr_api.g_varchar2) then
261: p_rec.name :=
262: pay_apr_shd.g_old_rec.name;
263: End If;
264: If (p_rec.enabled_flag = hr_api.g_varchar2) then

Line 264: If (p_rec.enabled_flag = hr_api.g_varchar2) then

260: If (p_rec.name = hr_api.g_varchar2) then
261: p_rec.name :=
262: pay_apr_shd.g_old_rec.name;
263: End If;
264: If (p_rec.enabled_flag = hr_api.g_varchar2) then
265: p_rec.enabled_flag :=
266: pay_apr_shd.g_old_rec.enabled_flag;
267: End If;
268: If (p_rec.business_group_id = hr_api.g_number) then

Line 268: If (p_rec.business_group_id = hr_api.g_number) then

264: If (p_rec.enabled_flag = hr_api.g_varchar2) then
265: p_rec.enabled_flag :=
266: pay_apr_shd.g_old_rec.enabled_flag;
267: End If;
268: If (p_rec.business_group_id = hr_api.g_number) then
269: p_rec.business_group_id :=
270: pay_apr_shd.g_old_rec.business_group_id;
271: End If;
272: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

268: If (p_rec.business_group_id = hr_api.g_number) then
269: p_rec.business_group_id :=
270: pay_apr_shd.g_old_rec.business_group_id;
271: End If;
272: If (p_rec.legislation_code = hr_api.g_varchar2) then
273: p_rec.legislation_code :=
274: pay_apr_shd.g_old_rec.legislation_code;
275: End If;
276: If (p_rec.description = hr_api.g_varchar2) then

Line 276: If (p_rec.description = hr_api.g_varchar2) then

272: If (p_rec.legislation_code = hr_api.g_varchar2) then
273: p_rec.legislation_code :=
274: pay_apr_shd.g_old_rec.legislation_code;
275: End If;
276: If (p_rec.description = hr_api.g_varchar2) then
277: p_rec.description :=
278: pay_apr_shd.g_old_rec.description;
279: End If;
280: If (p_rec.accrual_category = hr_api.g_varchar2) then

Line 280: If (p_rec.accrual_category = hr_api.g_varchar2) then

276: If (p_rec.description = hr_api.g_varchar2) then
277: p_rec.description :=
278: pay_apr_shd.g_old_rec.description;
279: End If;
280: If (p_rec.accrual_category = hr_api.g_varchar2) then
281: p_rec.accrual_category :=
282: pay_apr_shd.g_old_rec.accrual_category;
283: End If;
284: --