DBA Data[Home] [Help]

APPS.HR_ADI_LOB_UPD dependencies on HR_API

Line 84: When hr_api.check_integrity_violated Then

80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: --
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: hr_adi_lob_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: hr_adi_lob_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: hr_adi_lob_shd.constraint_error

Line 89: When hr_api.parent_integrity_violated Then

85: -- A check constraint has been violated
86: --
87: hr_adi_lob_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: hr_adi_lob_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: hr_adi_lob_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: hr_adi_lob_shd.constraint_error

Line 94: When hr_api.unique_integrity_violated Then

90: -- Parent integrity has been violated
91: --
92: hr_adi_lob_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: hr_adi_lob_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: hr_adi_lob_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;
102: End update_dml;

Line 234: when hr_api.cannot_find_prog_unit then

230: );
231: --
232: exception
233: --
234: when hr_api.cannot_find_prog_unit then
235: --
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'FND_LOBS'
238: ,p_hook_type => 'AU');

Line 236: hr_api.cannot_find_prog_unit_error

232: exception
233: --
234: when hr_api.cannot_find_prog_unit then
235: --
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'FND_LOBS'
238: ,p_hook_type => 'AU');
239: --
240: end;

Line 299: If (p_rec.file_name = hr_api.g_varchar2) then

295: -- p_rec plsql record structure
296: -- to see if a system default is being used. If a system default
297: -- is being used then we must set to the 'current' argument value.
298: --
299: If (p_rec.file_name = hr_api.g_varchar2) then
300: p_rec.file_name :=
301: hr_adi_lob_shd.g_old_rec.file_name;
302: End If;
303: If (p_rec.file_content_type = hr_api.g_varchar2) then

Line 303: If (p_rec.file_content_type = hr_api.g_varchar2) then

299: If (p_rec.file_name = hr_api.g_varchar2) then
300: p_rec.file_name :=
301: hr_adi_lob_shd.g_old_rec.file_name;
302: End If;
303: If (p_rec.file_content_type = hr_api.g_varchar2) then
304: p_rec.file_content_type :=
305: hr_adi_lob_shd.g_old_rec.file_content_type;
306: End If;
307: If (p_rec.upload_date = hr_api.g_date) then

Line 307: If (p_rec.upload_date = hr_api.g_date) then

303: If (p_rec.file_content_type = hr_api.g_varchar2) then
304: p_rec.file_content_type :=
305: hr_adi_lob_shd.g_old_rec.file_content_type;
306: End If;
307: If (p_rec.upload_date = hr_api.g_date) then
308: p_rec.upload_date :=
309: hr_adi_lob_shd.g_old_rec.upload_date;
310: End If;
311: If (p_rec.program_name = hr_api.g_varchar2) then

Line 311: If (p_rec.program_name = hr_api.g_varchar2) then

307: If (p_rec.upload_date = hr_api.g_date) then
308: p_rec.upload_date :=
309: hr_adi_lob_shd.g_old_rec.upload_date;
310: End If;
311: If (p_rec.program_name = hr_api.g_varchar2) then
312: p_rec.program_name :=
313: hr_adi_lob_shd.g_old_rec.program_name;
314: End If;
315: If (p_rec.program_tag = hr_api.g_varchar2) then

Line 315: If (p_rec.program_tag = hr_api.g_varchar2) then

311: If (p_rec.program_name = hr_api.g_varchar2) then
312: p_rec.program_name :=
313: hr_adi_lob_shd.g_old_rec.program_name;
314: End If;
315: If (p_rec.program_tag = hr_api.g_varchar2) then
316: p_rec.program_tag :=
317: hr_adi_lob_shd.g_old_rec.program_tag;
318: End If;
319: If (p_rec.file_format = hr_api.g_varchar2) then

Line 319: If (p_rec.file_format = hr_api.g_varchar2) then

315: If (p_rec.program_tag = hr_api.g_varchar2) then
316: p_rec.program_tag :=
317: hr_adi_lob_shd.g_old_rec.program_tag;
318: End If;
319: If (p_rec.file_format = hr_api.g_varchar2) then
320: p_rec.file_format :=
321: hr_adi_lob_shd.g_old_rec.file_format;
322: End If;
323: --

Line 405: ,hr_api.g_varchar2

401: ,p_file_name
402: ,p_file_content_type
403: ,SYSDATE
404: ,'HRMS_ADI'
405: ,hr_api.g_varchar2
406: ,null
407: );
408: --
409: -- Having converted the arguments into the