APPS.PQH_BGM_UPD dependencies on HR_API

Line 78: When hr_api.check_integrity_violated Then

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

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

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

Line 82: When hr_api.parent_integrity_violated Then

78: When hr_api.check_integrity_violated Then
79: -- A check constraint has been violated
80: pqh_bgm_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.parent_integrity_violated Then
83: -- Parent integrity has been violated
84: pqh_bgm_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.unique_integrity_violated 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.parent_integrity_violated Then
83: -- Parent integrity has been violated
84: pqh_bgm_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.unique_integrity_violated Then
87: -- Unique integrity has been violated
88: pqh_bgm_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 86: When hr_api.unique_integrity_violated Then

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

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

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

Line 195: when hr_api.cannot_find_prog_unit then

191: );
192: --
193: exception
194: --
195: when hr_api.cannot_find_prog_unit then
196: --
197: hr_api.cannot_find_prog_unit_error
198: (p_module_name => 'pqh_budget_gl_flex_maps'
199: ,p_hook_type => 'AU');

Line 197: hr_api.cannot_find_prog_unit_error

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

Line 265: If (p_rec.budget_id = hr_api.g_number) then

261: -- p_rec plsql record structure
262: -- to see if a system default is being used. If a system default
263: -- is being used then we must set to the 'current' argument value.
264: --
265: If (p_rec.budget_id = hr_api.g_number) then
266: p_rec.budget_id :=
267: pqh_bgm_shd.g_old_rec.budget_id;
268: End If;
269: If (p_rec.gl_account_segment = hr_api.g_varchar2) then

Line 269: If (p_rec.gl_account_segment = hr_api.g_varchar2) then

265: If (p_rec.budget_id = hr_api.g_number) then
266: p_rec.budget_id :=
267: pqh_bgm_shd.g_old_rec.budget_id;
268: End If;
269: If (p_rec.gl_account_segment = hr_api.g_varchar2) then
270: p_rec.gl_account_segment :=
271: pqh_bgm_shd.g_old_rec.gl_account_segment;
272: End If;
273: If (p_rec.payroll_cost_segment = hr_api.g_varchar2) then

Line 273: If (p_rec.payroll_cost_segment = hr_api.g_varchar2) then

269: If (p_rec.gl_account_segment = hr_api.g_varchar2) then
270: p_rec.gl_account_segment :=
271: pqh_bgm_shd.g_old_rec.gl_account_segment;
272: End If;
273: If (p_rec.payroll_cost_segment = hr_api.g_varchar2) then
274: p_rec.payroll_cost_segment :=
275: pqh_bgm_shd.g_old_rec.payroll_cost_segment;
276: End If;
277:

Line 332: p_budget_id in number default hr_api.g_number,

328: -- ----------------------------------------------------------------------------
329: Procedure upd
330: (
331: p_budget_gl_flex_map_id in number,
332: p_budget_id in number default hr_api.g_number,
333: p_gl_account_segment in varchar2 default hr_api.g_varchar2,
334: p_payroll_cost_segment in varchar2 default hr_api.g_varchar2,
335: p_object_version_number in out nocopy number
336: ) is

Line 333: p_gl_account_segment in varchar2 default hr_api.g_varchar2,

329: Procedure upd
330: (
331: p_budget_gl_flex_map_id in number,
332: p_budget_id in number default hr_api.g_number,
333: p_gl_account_segment in varchar2 default hr_api.g_varchar2,
334: p_payroll_cost_segment in varchar2 default hr_api.g_varchar2,
335: p_object_version_number in out nocopy number
336: ) is
337: --

Line 334: p_payroll_cost_segment in varchar2 default hr_api.g_varchar2,

330: (
331: p_budget_gl_flex_map_id in number,
332: p_budget_id in number default hr_api.g_number,
333: p_gl_account_segment in varchar2 default hr_api.g_varchar2,
334: p_payroll_cost_segment in varchar2 default hr_api.g_varchar2,
335: p_object_version_number in out nocopy number
336: ) is
337: --
338: l_rec pqh_bgm_shd.g_rec_type;