DBA Data[Home] [Help]

APPS.PAY_AMO_UPD dependencies on HR_API

Line 92: When hr_api.check_integrity_violated Then

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

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

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

Line 97: When hr_api.parent_integrity_violated Then

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

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

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

Line 102: When hr_api.unique_integrity_violated Then

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

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

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

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

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

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

258: If (p_rec.name = hr_api.g_varchar2) then
259: p_rec.name :=
260: pay_amo_shd.g_old_rec.name;
261: End If;
262: If (p_rec.enabled_flag = hr_api.g_varchar2) then
263: p_rec.enabled_flag :=
264: pay_amo_shd.g_old_rec.enabled_flag;
265: End If;
266: If (p_rec.module_type_id = hr_api.g_number) then

Line 266: If (p_rec.module_type_id = hr_api.g_number) then

262: If (p_rec.enabled_flag = hr_api.g_varchar2) then
263: p_rec.enabled_flag :=
264: pay_amo_shd.g_old_rec.enabled_flag;
265: End If;
266: If (p_rec.module_type_id = hr_api.g_number) then
267: p_rec.module_type_id :=
268: pay_amo_shd.g_old_rec.module_type_id;
269: End If;
270: If (p_rec.business_group_id = hr_api.g_number) then

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

266: If (p_rec.module_type_id = hr_api.g_number) then
267: p_rec.module_type_id :=
268: pay_amo_shd.g_old_rec.module_type_id;
269: End If;
270: If (p_rec.business_group_id = hr_api.g_number) then
271: p_rec.business_group_id :=
272: pay_amo_shd.g_old_rec.business_group_id;
273: End If;
274: If (p_rec.legislation_code = hr_api.g_varchar2) then

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

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

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

274: If (p_rec.legislation_code = hr_api.g_varchar2) then
275: p_rec.legislation_code :=
276: pay_amo_shd.g_old_rec.legislation_code;
277: End If;
278: If (p_rec.description = hr_api.g_varchar2) then
279: p_rec.description :=
280: pay_amo_shd.g_old_rec.description;
281: End If;
282: If (p_rec.package_name = hr_api.g_varchar2) then

Line 282: If (p_rec.package_name = hr_api.g_varchar2) then

278: If (p_rec.description = hr_api.g_varchar2) then
279: p_rec.description :=
280: pay_amo_shd.g_old_rec.description;
281: End If;
282: If (p_rec.package_name = hr_api.g_varchar2) then
283: p_rec.package_name :=
284: pay_amo_shd.g_old_rec.package_name;
285: End If;
286: If (p_rec.procedure_function_name = hr_api.g_varchar2) then

Line 286: If (p_rec.procedure_function_name = hr_api.g_varchar2) then

282: If (p_rec.package_name = hr_api.g_varchar2) then
283: p_rec.package_name :=
284: pay_amo_shd.g_old_rec.package_name;
285: End If;
286: If (p_rec.procedure_function_name = hr_api.g_varchar2) then
287: p_rec.procedure_function_name :=
288: pay_amo_shd.g_old_rec.procedure_function_name;
289: End If;
290: If (p_rec.formula_name = hr_api.g_varchar2) then

Line 290: If (p_rec.formula_name = hr_api.g_varchar2) then

286: If (p_rec.procedure_function_name = hr_api.g_varchar2) then
287: p_rec.procedure_function_name :=
288: pay_amo_shd.g_old_rec.procedure_function_name;
289: End If;
290: If (p_rec.formula_name = hr_api.g_varchar2) then
291: p_rec.formula_name :=
292: pay_amo_shd.g_old_rec.formula_name;
293: End If;
294: --