APPS.PQH_DST_UPD dependencies on HR_API

Line 74: When hr_api.check_integrity_violated Then

70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 10);
72: --
73: Exception
74: When hr_api.check_integrity_violated Then
75: -- A check constraint has been violated
76: pqh_dst_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then

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

73: Exception
74: When hr_api.check_integrity_violated Then
75: -- A check constraint has been violated
76: pqh_dst_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: pqh_dst_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 78: When hr_api.parent_integrity_violated Then

74: When hr_api.check_integrity_violated Then
75: -- A check constraint has been violated
76: pqh_dst_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: pqh_dst_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then

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

77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: pqh_dst_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: pqh_dst_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 82: When hr_api.unique_integrity_violated Then

78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: pqh_dst_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: pqh_dst_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then

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

81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: pqh_dst_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: Raise;
88: End update_dml;
89: --

Line 189: when hr_api.cannot_find_prog_unit then

185: );
186: --
187: exception
188: --
189: when hr_api.cannot_find_prog_unit then
190: --
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'pqh_dflt_budget_sets'
193: ,p_hook_type => 'AU');

Line 191: hr_api.cannot_find_prog_unit_error

187: exception
188: --
189: when hr_api.cannot_find_prog_unit then
190: --
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'pqh_dflt_budget_sets'
193: ,p_hook_type => 'AU');
194: --
195: end;

Line 259: If (p_rec.dflt_budget_set_name = hr_api.g_varchar2) then

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

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

259: If (p_rec.dflt_budget_set_name = hr_api.g_varchar2) then
260: p_rec.dflt_budget_set_name :=
261: pqh_dst_shd.g_old_rec.dflt_budget_set_name;
262: End If;
263: If (p_rec.business_group_id = hr_api.g_number) then
264: p_rec.business_group_id :=
265: pqh_dst_shd.g_old_rec.business_group_id;
266: End If;
267:

Line 322: p_dflt_budget_set_name in varchar2 default hr_api.g_varchar2,

318: -- ----------------------------------------------------------------------------
319: Procedure upd
320: (
321: p_dflt_budget_set_id in number,
322: p_dflt_budget_set_name in varchar2 default hr_api.g_varchar2,
323: p_business_group_id in number default hr_api.g_number,
324: p_object_version_number in out nocopy number
325: ) is
326: --

Line 323: p_business_group_id in number default hr_api.g_number,

319: Procedure upd
320: (
321: p_dflt_budget_set_id in number,
322: p_dflt_budget_set_name in varchar2 default hr_api.g_varchar2,
323: p_business_group_id in number default hr_api.g_number,
324: p_object_version_number in out nocopy number
325: ) is
326: --
327: l_rec pqh_dst_shd.g_rec_type;