DBA Data[Home] [Help]

APPS.HR_ABM_SHD dependencies on HR_API

Line 42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then

38: hr_utility.set_message(801, 'HR_7297_API_ARG_ONLY');
39: hr_utility.set_message_token('ARG_NAME', 'status');
40: hr_utility.set_message_token('ARG_ONLY','(F,S)');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_BATCH_MESSAGE_LINES_PK') Then
43: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
44: hr_utility.raise_error;
45: Else
46: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 71: from hr_api_batch_message_lines

67: error_number,
68: error_message,
69: extended_error_message,
70: source_row_information
71: from hr_api_batch_message_lines
72: where line_id = p_line_id
73: for update nowait;
74: --
75: l_proc varchar2(72) := g_package||'lck';

Line 80: hr_api.mandatory_arg_error

76: --
77: Begin
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: --
80: hr_api.mandatory_arg_error
81: (p_api_name => l_proc,
82: p_argument => 'line_id',
83: p_argument_value => p_line_id);
84: --

Line 103: When HR_Api.Object_Locked then

99: --
100: -- We need to trap the ORA LOCK exception
101: --
102: Exception
103: When HR_Api.Object_Locked then
104: --
105: -- The object is locked therefore we need to supply a meaningful
106: -- error message.
107: --

Line 109: hr_utility.set_message_token('TABLE_NAME', 'hr_api_batch_message_lines');

105: -- The object is locked therefore we need to supply a meaningful
106: -- error message.
107: --
108: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
109: hr_utility.set_message_token('TABLE_NAME', 'hr_api_batch_message_lines');
110: hr_utility.raise_error;
111: End lck;
112: --
113: -- ----------------------------------------------------------------------------