APPS.PQH_RLT_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_rlt_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_rlt_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_rlt_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_rlt_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_rlt_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_rlt_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_rlt_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_rlt_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_rlt_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_rlt_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_routing_lists'
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_routing_lists'
193: ,p_hook_type => 'AU');
194: --
195: end;

Line 259: If (p_rec.routing_list_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.routing_list_name = hr_api.g_varchar2) then
260: p_rec.routing_list_name :=
261: pqh_rlt_shd.g_old_rec.routing_list_name;
262: End If;
263: --

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

260: p_rec.routing_list_name :=
261: pqh_rlt_shd.g_old_rec.routing_list_name;
262: End If;
263: --
264: If (p_rec.enable_flag = hr_api.g_varchar2) then
265: p_rec.enable_flag :=
266: pqh_rlt_shd.g_old_rec.enable_flag;
267: End If;
268: --

Line 322: p_routing_list_name in varchar2 default hr_api.g_varchar2,

318: -- ----------------------------------------------------------------------------
319: Procedure upd
320: (
321: p_routing_list_id in number,
322: p_routing_list_name in varchar2 default hr_api.g_varchar2,
323: p_enable_flag in varchar2 default hr_api.g_varchar2,
324: p_object_version_number in out nocopy number
325: ) is
326: --

Line 323: p_enable_flag in varchar2 default hr_api.g_varchar2,

319: Procedure upd
320: (
321: p_routing_list_id in number,
322: p_routing_list_name in varchar2 default hr_api.g_varchar2,
323: p_enable_flag in varchar2 default hr_api.g_varchar2,
324: p_object_version_number in out nocopy number
325: ) is
326: --
327: l_rec pqh_rlt_shd.g_rec_type;