APPS.PAY_BCT_UPD dependencies on HR_API

Line 105: When hr_api.check_integrity_violated Then

101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
108: pay_bct_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
108: pay_bct_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
113: pay_bct_shd.constraint_error

Line 110: When hr_api.parent_integrity_violated Then

106: -- A check constraint has been violated
107: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
108: pay_bct_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
113: pay_bct_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
113: pay_bct_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
118: pay_bct_shd.constraint_error

Line 115: When hr_api.unique_integrity_violated Then

111: -- Parent integrity has been violated
112: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
113: pay_bct_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
118: pay_bct_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
118: pay_bct_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: pay_bct_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
123: End update_dml;

Line 239: when hr_api.cannot_find_prog_unit then

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

Line 241: hr_api.cannot_find_prog_unit_error

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

Line 304: If (p_rec.batch_id = hr_api.g_number) then

300: -- p_rec plsql record structure
301: -- to see if a system default is being used. If a system default
302: -- is being used then we must set to the 'current' argument value.
303: --
304: If (p_rec.batch_id = hr_api.g_number) then
305: p_rec.batch_id :=
306: pay_bct_shd.g_old_rec.batch_id;
307: End If;
308: If (p_rec.control_status = hr_api.g_varchar2) then

Line 308: If (p_rec.control_status = hr_api.g_varchar2) then

304: If (p_rec.batch_id = hr_api.g_number) then
305: p_rec.batch_id :=
306: pay_bct_shd.g_old_rec.batch_id;
307: End If;
308: If (p_rec.control_status = hr_api.g_varchar2) then
309: p_rec.control_status :=
310: pay_bct_shd.g_old_rec.control_status;
311: End If;
312: If (p_rec.control_total = hr_api.g_varchar2) then

Line 312: If (p_rec.control_total = hr_api.g_varchar2) then

308: If (p_rec.control_status = hr_api.g_varchar2) then
309: p_rec.control_status :=
310: pay_bct_shd.g_old_rec.control_status;
311: End If;
312: If (p_rec.control_total = hr_api.g_varchar2) then
313: p_rec.control_total :=
314: pay_bct_shd.g_old_rec.control_total;
315: End If;
316: If (p_rec.control_type = hr_api.g_varchar2) then

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

312: If (p_rec.control_total = hr_api.g_varchar2) then
313: p_rec.control_total :=
314: pay_bct_shd.g_old_rec.control_total;
315: End If;
316: If (p_rec.control_type = hr_api.g_varchar2) then
317: p_rec.control_type :=
318: pay_bct_shd.g_old_rec.control_type;
319: End If;
320: --

Line 378: ,p_control_status in varchar2 default hr_api.g_varchar2

374: Procedure upd
375: (p_session_date in date
376: ,p_batch_control_id in number
377: ,p_object_version_number in out nocopy number
378: ,p_control_status in varchar2 default hr_api.g_varchar2
379: ,p_control_total in varchar2 default hr_api.g_varchar2
380: ,p_control_type in varchar2 default hr_api.g_varchar2
381: ) is
382: --

Line 379: ,p_control_total in varchar2 default hr_api.g_varchar2

375: (p_session_date in date
376: ,p_batch_control_id in number
377: ,p_object_version_number in out nocopy number
378: ,p_control_status in varchar2 default hr_api.g_varchar2
379: ,p_control_total in varchar2 default hr_api.g_varchar2
380: ,p_control_type in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: l_rec pay_bct_shd.g_rec_type;

Line 380: ,p_control_type in varchar2 default hr_api.g_varchar2

376: ,p_batch_control_id in number
377: ,p_object_version_number in out nocopy number
378: ,p_control_status in varchar2 default hr_api.g_varchar2
379: ,p_control_total in varchar2 default hr_api.g_varchar2
380: ,p_control_type in varchar2 default hr_api.g_varchar2
381: ) is
382: --
383: l_rec pay_bct_shd.g_rec_type;
384: l_proc varchar2(72) := g_package||'upd';

Line 395: ,hr_api.g_number

391: --
392: l_rec :=
393: pay_bct_shd.convert_args
394: (p_batch_control_id
395: ,hr_api.g_number
396: ,p_control_status
397: ,p_control_total
398: ,p_control_type
399: ,p_object_version_number