APPS.BEN_CTK_UPD dependencies on HR_API

Line 92: When hr_api.check_integrity_violated Then

88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: end if;
90: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
95: ben_ctk_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
95: ben_ctk_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
100: ben_ctk_shd.constraint_error

Line 97: When hr_api.parent_integrity_violated Then

93: -- A check constraint has been violated
94: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
95: ben_ctk_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
100: ben_ctk_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
100: ben_ctk_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
105: ben_ctk_shd.constraint_error

Line 102: When hr_api.unique_integrity_violated Then

98: -- Parent integrity has been violated
99: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
100: ben_ctk_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
105: ben_ctk_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
105: ben_ctk_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: ben_ctk_shd.g_api_dml := false; -- Unset the api dml status
109: Raise;
110: End update_dml;

Line 241: when hr_api.cannot_find_prog_unit then

237: );
238: --
239: exception
240: --
241: when hr_api.cannot_find_prog_unit then
242: --
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'BEN_CWB_PERSON_TASKS'
245: ,p_hook_type => 'AU');

Line 243: hr_api.cannot_find_prog_unit_error

239: exception
240: --
241: when hr_api.cannot_find_prog_unit then
242: --
243: hr_api.cannot_find_prog_unit_error
244: (p_module_name => 'BEN_CWB_PERSON_TASKS'
245: ,p_hook_type => 'AU');
246: --
247: end;

Line 308: If (p_rec.group_pl_id = hr_api.g_number) then

304: -- p_rec plsql record structure
305: -- to see if a system default is being used. If a system default
306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.group_pl_id = hr_api.g_number) then
309: p_rec.group_pl_id :=
310: ben_ctk_shd.g_old_rec.group_pl_id;
311: End If;
312: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then

Line 312: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then

308: If (p_rec.group_pl_id = hr_api.g_number) then
309: p_rec.group_pl_id :=
310: ben_ctk_shd.g_old_rec.group_pl_id;
311: End If;
312: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
313: p_rec.lf_evt_ocrd_dt :=
314: ben_ctk_shd.g_old_rec.lf_evt_ocrd_dt;
315: End If;
316: If (p_rec.status_cd = hr_api.g_varchar2) then

Line 316: If (p_rec.status_cd = hr_api.g_varchar2) then

312: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
313: p_rec.lf_evt_ocrd_dt :=
314: ben_ctk_shd.g_old_rec.lf_evt_ocrd_dt;
315: End If;
316: If (p_rec.status_cd = hr_api.g_varchar2) then
317: p_rec.status_cd :=
318: ben_ctk_shd.g_old_rec.status_cd;
319: End If;
320: If (p_rec.access_cd = hr_api.g_varchar2) then

Line 320: If (p_rec.access_cd = hr_api.g_varchar2) then

316: If (p_rec.status_cd = hr_api.g_varchar2) then
317: p_rec.status_cd :=
318: ben_ctk_shd.g_old_rec.status_cd;
319: End If;
320: If (p_rec.access_cd = hr_api.g_varchar2) then
321: p_rec.access_cd :=
322: ben_ctk_shd.g_old_rec.access_cd;
323: End If;
324: If (p_rec.task_last_update_date = hr_api.g_date) then

Line 324: If (p_rec.task_last_update_date = hr_api.g_date) then

320: If (p_rec.access_cd = hr_api.g_varchar2) then
321: p_rec.access_cd :=
322: ben_ctk_shd.g_old_rec.access_cd;
323: End If;
324: If (p_rec.task_last_update_date = hr_api.g_date) then
325: p_rec.task_last_update_date :=
326: ben_ctk_shd.g_old_rec.task_last_update_date;
327: End If;
328: If (p_rec.task_last_update_by = hr_api.g_number) then

Line 328: If (p_rec.task_last_update_by = hr_api.g_number) then

324: If (p_rec.task_last_update_date = hr_api.g_date) then
325: p_rec.task_last_update_date :=
326: ben_ctk_shd.g_old_rec.task_last_update_date;
327: End If;
328: If (p_rec.task_last_update_by = hr_api.g_number) then
329: p_rec.task_last_update_by :=
330: ben_ctk_shd.g_old_rec.task_last_update_by;
331: End If;
332: --

Line 396: ,p_group_pl_id in number default hr_api.g_number

392: Procedure upd
393: (p_group_per_in_ler_id in number
394: ,p_task_id in number
395: ,p_object_version_number in out nocopy number
396: ,p_group_pl_id in number default hr_api.g_number
397: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
398: ,p_status_cd in varchar2 default hr_api.g_varchar2
399: ,p_access_cd in varchar2 default hr_api.g_varchar2
400: ,p_task_last_update_date in date default hr_api.g_date

Line 397: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

393: (p_group_per_in_ler_id in number
394: ,p_task_id in number
395: ,p_object_version_number in out nocopy number
396: ,p_group_pl_id in number default hr_api.g_number
397: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
398: ,p_status_cd in varchar2 default hr_api.g_varchar2
399: ,p_access_cd in varchar2 default hr_api.g_varchar2
400: ,p_task_last_update_date in date default hr_api.g_date
401: ,p_task_last_update_by in number default hr_api.g_number

Line 398: ,p_status_cd in varchar2 default hr_api.g_varchar2

394: ,p_task_id in number
395: ,p_object_version_number in out nocopy number
396: ,p_group_pl_id in number default hr_api.g_number
397: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
398: ,p_status_cd in varchar2 default hr_api.g_varchar2
399: ,p_access_cd in varchar2 default hr_api.g_varchar2
400: ,p_task_last_update_date in date default hr_api.g_date
401: ,p_task_last_update_by in number default hr_api.g_number
402: ) is

Line 399: ,p_access_cd in varchar2 default hr_api.g_varchar2

395: ,p_object_version_number in out nocopy number
396: ,p_group_pl_id in number default hr_api.g_number
397: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
398: ,p_status_cd in varchar2 default hr_api.g_varchar2
399: ,p_access_cd in varchar2 default hr_api.g_varchar2
400: ,p_task_last_update_date in date default hr_api.g_date
401: ,p_task_last_update_by in number default hr_api.g_number
402: ) is
403: --

Line 400: ,p_task_last_update_date in date default hr_api.g_date

396: ,p_group_pl_id in number default hr_api.g_number
397: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
398: ,p_status_cd in varchar2 default hr_api.g_varchar2
399: ,p_access_cd in varchar2 default hr_api.g_varchar2
400: ,p_task_last_update_date in date default hr_api.g_date
401: ,p_task_last_update_by in number default hr_api.g_number
402: ) is
403: --
404: l_rec ben_ctk_shd.g_rec_type;

Line 401: ,p_task_last_update_by in number default hr_api.g_number

397: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
398: ,p_status_cd in varchar2 default hr_api.g_varchar2
399: ,p_access_cd in varchar2 default hr_api.g_varchar2
400: ,p_task_last_update_date in date default hr_api.g_date
401: ,p_task_last_update_by in number default hr_api.g_number
402: ) is
403: --
404: l_rec ben_ctk_shd.g_rec_type;
405: l_proc varchar2(72) := g_package||'upd';