APPS.PAY_LIV_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 112: When hr_api.check_integrity_violated Then

108: End If;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 15);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
115: pay_liv_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 117: When hr_api.unique_integrity_violated Then

113: -- A check constraint has been violated
114: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
115: pay_liv_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: pay_liv_shd.g_api_dml := false; -- Unset the api dml status
120: pay_liv_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 238: If (p_datetrack_mode <> hr_api.g_correction) then

234: l_dummy_version_number number;
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: If (p_datetrack_mode <> hr_api.g_correction) then
239: --
240: -- Update the current effective end date
241: --
242: pay_liv_shd.upd_effective_end_date

Line 251: If (p_datetrack_mode = hr_api.g_update_override) then

247: ,p_validation_end_date => p_validation_end_date
248: ,p_object_version_number => l_dummy_version_number
249: );
250: --
251: If (p_datetrack_mode = hr_api.g_update_override) then
252: --
253: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
254: -- delete any future rows
255: --

Line 437: when hr_api.cannot_find_prog_unit then

433: );
434: --
435: exception
436: --
437: when hr_api.cannot_find_prog_unit then
438: --
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'PAY_LINK_INPUT_VALUES_F'
441: ,p_hook_type => 'AU');

Line 439: hr_api.cannot_find_prog_unit_error

435: exception
436: --
437: when hr_api.cannot_find_prog_unit then
438: --
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'PAY_LINK_INPUT_VALUES_F'
441: ,p_hook_type => 'AU');
442: --
443: end;

Line 502: If (p_rec.element_link_id = hr_api.g_number) then

498: -- p_rec plsql record structure
499: -- to see if a system default is being used. If a system default
500: -- is being used then we must set to the 'current' argument value.
501: --
502: If (p_rec.element_link_id = hr_api.g_number) then
503: p_rec.element_link_id :=
504: pay_liv_shd.g_old_rec.element_link_id;
505: End If;
506: If (p_rec.input_value_id = hr_api.g_number) then

Line 506: If (p_rec.input_value_id = hr_api.g_number) then

502: If (p_rec.element_link_id = hr_api.g_number) then
503: p_rec.element_link_id :=
504: pay_liv_shd.g_old_rec.element_link_id;
505: End If;
506: If (p_rec.input_value_id = hr_api.g_number) then
507: p_rec.input_value_id :=
508: pay_liv_shd.g_old_rec.input_value_id;
509: End If;
510: If (p_rec.costed_flag = hr_api.g_varchar2) then

Line 510: If (p_rec.costed_flag = hr_api.g_varchar2) then

506: If (p_rec.input_value_id = hr_api.g_number) then
507: p_rec.input_value_id :=
508: pay_liv_shd.g_old_rec.input_value_id;
509: End If;
510: If (p_rec.costed_flag = hr_api.g_varchar2) then
511: p_rec.costed_flag :=
512: pay_liv_shd.g_old_rec.costed_flag;
513: End If;
514: If (p_rec.default_value = hr_api.g_varchar2) then

Line 514: If (p_rec.default_value = hr_api.g_varchar2) then

510: If (p_rec.costed_flag = hr_api.g_varchar2) then
511: p_rec.costed_flag :=
512: pay_liv_shd.g_old_rec.costed_flag;
513: End If;
514: If (p_rec.default_value = hr_api.g_varchar2) then
515: p_rec.default_value :=
516: pay_liv_shd.g_old_rec.default_value;
517: End If;
518: If (p_rec.max_value = hr_api.g_varchar2) then

Line 518: If (p_rec.max_value = hr_api.g_varchar2) then

514: If (p_rec.default_value = hr_api.g_varchar2) then
515: p_rec.default_value :=
516: pay_liv_shd.g_old_rec.default_value;
517: End If;
518: If (p_rec.max_value = hr_api.g_varchar2) then
519: p_rec.max_value :=
520: pay_liv_shd.g_old_rec.max_value;
521: End If;
522: If (p_rec.min_value = hr_api.g_varchar2) then

Line 522: If (p_rec.min_value = hr_api.g_varchar2) then

518: If (p_rec.max_value = hr_api.g_varchar2) then
519: p_rec.max_value :=
520: pay_liv_shd.g_old_rec.max_value;
521: End If;
522: If (p_rec.min_value = hr_api.g_varchar2) then
523: p_rec.min_value :=
524: pay_liv_shd.g_old_rec.min_value;
525: End If;
526: If (p_rec.warning_or_error = hr_api.g_varchar2) then

Line 526: If (p_rec.warning_or_error = hr_api.g_varchar2) then

522: If (p_rec.min_value = hr_api.g_varchar2) then
523: p_rec.min_value :=
524: pay_liv_shd.g_old_rec.min_value;
525: End If;
526: If (p_rec.warning_or_error = hr_api.g_varchar2) then
527: p_rec.warning_or_error :=
528: pay_liv_shd.g_old_rec.warning_or_error;
529: End If;
530: --