DBA Data[Home] [Help]

APPS.HR_BATCH_MESSAGE_LINE_API dependencies on HR_API

Line 25: l_line_id hr_api_batch_message_lines.line_id%type;

21: ,p_source_row_information in varchar2 default null
22: ,p_line_id out nocopy number) is
23: --
24: l_proc varchar2(72) := g_package||'create_message_line';
25: l_line_id hr_api_batch_message_lines.line_id%type;
26: --
27: begin
28: g_debug := hr_utility.debug_enabled; -- get debug status
29: IF g_debug THEN

Line 61: raise hr_api.validate_enabled;

57: --
58: -- When in validation only mode raise the Validate_Enabled exception
59: --
60: if p_validate then
61: raise hr_api.validate_enabled;
62: end if;
63: --
64: -- Set all output arguments
65: --

Line 72: when hr_api.validate_enabled then

68: IF g_debug THEN
69: hr_utility.set_location(' Leaving:'||l_proc, 11);
70: END IF;
71: exception
72: when hr_api.validate_enabled then
73: --
74: -- As the Validate_Enabled exception has been raised
75: -- we must rollback to the savepoint
76: --

Line 135: raise hr_api.validate_enabled;

131: --
132: -- When in validation only mode raise the Validate_Enabled exception
133: --
134: if p_validate then
135: raise hr_api.validate_enabled;
136: end if;
137: --
138: IF g_debug THEN
139: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 142: when hr_api.validate_enabled then

138: IF g_debug THEN
139: hr_utility.set_location(' Leaving:'||l_proc, 11);
140: END IF;
141: exception
142: when hr_api.validate_enabled then
143: --
144: -- As the Validate_Enabled exception has been raised
145: -- we must rollback to the savepoint
146: --

Line 175: from hr_api_batch_message_lines abm

171: -- select all the lines to be deleted for the specified batch run number
172: --
173: cursor csr_get_line_id is
174: select abm.line_id
175: from hr_api_batch_message_lines abm
176: where abm.batch_run_number = p_batch_run_number
177: order by 1;
178: --
179: begin

Line 193: hr_api.mandatory_arg_error

189: IF g_debug THEN
190: hr_utility.set_location(l_proc, 6);
191: END IF;
192: --
193: hr_api.mandatory_arg_error
194: (p_api_name => l_proc,
195: p_argument => 'batch_run_number',
196: p_argument_value => p_batch_run_number);
197: --

Line 215: raise hr_api.validate_enabled;

211: --
212: -- When in validation only mode raise the Validate_Enabled exception
213: --
214: if p_validate then
215: raise hr_api.validate_enabled;
216: end if;
217: --
218: IF g_debug THEN
219: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 222: when hr_api.validate_enabled then

218: IF g_debug THEN
219: hr_utility.set_location(' Leaving:'||l_proc, 11);
220: END IF;
221: exception
222: when hr_api.validate_enabled then
223: --
224: -- As the Validate_Enabled exception has been raised
225: -- we must rollback to the savepoint
226: --