APPS.PQH_CEC_UPD dependencies on HR_API

Line 79: When hr_api.check_integrity_violated Then

75: --
76: hr_utility.set_location(' Leaving:'||l_proc, 10);
77: --
78: Exception
79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: pqh_cec_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then

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

78: Exception
79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: pqh_cec_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: pqh_cec_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 83: When hr_api.parent_integrity_violated Then

79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: pqh_cec_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: pqh_cec_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then

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

82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: pqh_cec_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: pqh_cec_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 87: When hr_api.unique_integrity_violated Then

83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: pqh_cec_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: pqh_cec_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then

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

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: pqh_cec_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: Raise;
93: End update_dml;
94: --

Line 198: when hr_api.cannot_find_prog_unit then

194: );
195: --
196: exception
197: --
198: when hr_api.cannot_find_prog_unit then
199: --
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'pqh_copy_entity_contexts'
202: ,p_hook_type => 'AU');

Line 200: hr_api.cannot_find_prog_unit_error

196: exception
197: --
198: when hr_api.cannot_find_prog_unit then
199: --
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'pqh_copy_entity_contexts'
202: ,p_hook_type => 'AU');
203: --
204: end;

Line 268: If (p_rec.application_short_name = hr_api.g_varchar2) then

264: -- p_rec plsql record structure
265: -- to see if a system default is being used. If a system default
266: -- is being used then we must set to the 'current' argument value.
267: --
268: If (p_rec.application_short_name = hr_api.g_varchar2) then
269: p_rec.application_short_name :=
270: pqh_cec_shd.g_old_rec.application_short_name;
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.application_short_name = hr_api.g_varchar2) then
269: p_rec.application_short_name :=
270: pqh_cec_shd.g_old_rec.application_short_name;
271: End If;
272: If (p_rec.legislation_code = hr_api.g_varchar2) then
273: p_rec.legislation_code :=
274: pqh_cec_shd.g_old_rec.legislation_code;
275: End If;
276: If (p_rec.responsibility_key = hr_api.g_varchar2) then

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

272: If (p_rec.legislation_code = hr_api.g_varchar2) then
273: p_rec.legislation_code :=
274: pqh_cec_shd.g_old_rec.legislation_code;
275: End If;
276: If (p_rec.responsibility_key = hr_api.g_varchar2) then
277: p_rec.responsibility_key :=
278: pqh_cec_shd.g_old_rec.responsibility_key;
279: End If;
280: If (p_rec.transaction_short_name = hr_api.g_varchar2) then

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

276: If (p_rec.responsibility_key = hr_api.g_varchar2) then
277: p_rec.responsibility_key :=
278: pqh_cec_shd.g_old_rec.responsibility_key;
279: End If;
280: If (p_rec.transaction_short_name = hr_api.g_varchar2) then
281: p_rec.transaction_short_name :=
282: pqh_cec_shd.g_old_rec.transaction_short_name;
283: End If;
284:

Line 339: p_application_short_name in varchar2 default hr_api.g_varchar2,

335: -- ----------------------------------------------------------------------------
336: Procedure upd
337: (
338: p_context in varchar2,
339: p_application_short_name in varchar2 default hr_api.g_varchar2,
340: p_legislation_code in varchar2 default hr_api.g_varchar2,
341: p_responsibility_key in varchar2 default hr_api.g_varchar2,
342: p_transaction_short_name in varchar2 default hr_api.g_varchar2,
343: p_object_version_number in out nocopy number

Line 340: p_legislation_code in varchar2 default hr_api.g_varchar2,

336: Procedure upd
337: (
338: p_context in varchar2,
339: p_application_short_name in varchar2 default hr_api.g_varchar2,
340: p_legislation_code in varchar2 default hr_api.g_varchar2,
341: p_responsibility_key in varchar2 default hr_api.g_varchar2,
342: p_transaction_short_name in varchar2 default hr_api.g_varchar2,
343: p_object_version_number in out nocopy number
344: ) is

Line 341: p_responsibility_key in varchar2 default hr_api.g_varchar2,

337: (
338: p_context in varchar2,
339: p_application_short_name in varchar2 default hr_api.g_varchar2,
340: p_legislation_code in varchar2 default hr_api.g_varchar2,
341: p_responsibility_key in varchar2 default hr_api.g_varchar2,
342: p_transaction_short_name in varchar2 default hr_api.g_varchar2,
343: p_object_version_number in out nocopy number
344: ) is
345: --

Line 342: p_transaction_short_name in varchar2 default hr_api.g_varchar2,

338: p_context in varchar2,
339: p_application_short_name in varchar2 default hr_api.g_varchar2,
340: p_legislation_code in varchar2 default hr_api.g_varchar2,
341: p_responsibility_key in varchar2 default hr_api.g_varchar2,
342: p_transaction_short_name in varchar2 default hr_api.g_varchar2,
343: p_object_version_number in out nocopy number
344: ) is
345: --
346: l_rec pqh_cec_shd.g_rec_type;