DBA Data[Home] [Help]

APPS.BEN_PRY_INS dependencies on HR_API

Line 103: If (p_datetrack_mode <> hr_api.g_insert) then

99: --
100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> hr_api.g_insert) then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --

Line 243: When hr_api.check_integrity_violated Then

239: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
240: hr_utility.set_location(' Leaving:'||l_proc, 15);
241: --
242: Exception
243: When hr_api.check_integrity_violated Then
244: -- A check constraint has been violated
245: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
246: ben_pry_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

243: When hr_api.check_integrity_violated Then
244: -- A check constraint has been violated
245: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
246: ben_pry_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
251: ben_pry_shd.constraint_error

Line 248: When hr_api.unique_integrity_violated Then

244: -- A check constraint has been violated
245: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
246: ben_pry_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
251: ben_pry_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
251: ben_pry_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When Others Then
254: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
255: Raise;
256: End dt_insert_dml;

Line 504: when hr_api.cannot_find_prog_unit then

500: );
501: --
502: exception
503: --
504: when hr_api.cannot_find_prog_unit then
505: --
506: hr_api.cannot_find_prog_unit_error
507: (p_module_name => 'BEN_PRTT_RMT_APRVD_FR_PYMT_F'
508: ,p_hook_type => 'AI');

Line 506: hr_api.cannot_find_prog_unit_error

502: exception
503: --
504: when hr_api.cannot_find_prog_unit then
505: --
506: hr_api.cannot_find_prog_unit_error
507: (p_module_name => 'BEN_PRTT_RMT_APRVD_FR_PYMT_F'
508: ,p_hook_type => 'AI');
509: --
510: end;

Line 539: -- another user. This will raise the HR_Api.Object_Locked exception.

535: --
536: -- Post Failure:
537: -- The Lck process can fail for:
538: -- 1) When attempting to lock the row the row could already be locked by
539: -- another user. This will raise the HR_Api.Object_Locked exception.
540: -- 2) When attempting to the lock the parent which doesn't exist.
541: -- For the entity to be locked the parent must exist!
542: --
543: -- Developer Implementation Notes:

Line 601: l_datetrack_mode varchar2(30) := hr_api.g_insert;

597: ,p_rec in out nocopy ben_pry_shd.g_rec_type
598: ) is
599: --
600: l_proc varchar2(72) := g_package||'ins';
601: l_datetrack_mode varchar2(30) := hr_api.g_insert;
602: l_validation_start_date date;
603: l_validation_end_date date;
604: --
605: Begin