DBA Data[Home] [Help]

APPS.PER_SOS_INS dependencies on HR_UTILITY

Line 28: hr_utility.set_location('Entering:'||l_proc, 10);

24: --
25: l_proc varchar2(72) := g_package||'set_base_key_value';
26: --
27: Begin
28: hr_utility.set_location('Entering:'||l_proc, 10);
29: --
30: per_sos_ins.g_solution_id_i := p_solution_id;
31: per_sos_ins.g_solution_set_name_i := p_solution_set_name;
32: per_sos_ins.g_user_id_i := p_user_id;

Line 34: hr_utility.set_location(' Leaving:'||l_proc, 20);

30: per_sos_ins.g_solution_id_i := p_solution_id;
31: per_sos_ins.g_solution_set_name_i := p_solution_set_name;
32: per_sos_ins.g_user_id_i := p_user_id;
33: --
34: hr_utility.set_location(' Leaving:'||l_proc, 20);
35: End set_base_key_value;
36: --
37: --
38: -- ----------------------------------------------------------------------------

Line 88: hr_utility.set_location('Entering:'||l_proc, 5);

84: --
85: l_proc varchar2(72) := g_package||'insert_dml';
86: --
87: Begin
88: hr_utility.set_location('Entering:'||l_proc, 5);
89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: --
92: --

Line 110: hr_utility.set_location(' Leaving:'||l_proc, 10);

106: );
107: --
108: --
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --

Line 187: hr_utility.set_location('Entering:'||l_proc, 5);

183: l_proc varchar2(72) := g_package||'pre_insert';
184: l_exists varchar2(1);
185: --
186: Begin
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: If (per_sos_ins.g_solution_id_i is not null or
190: per_sos_ins.g_solution_set_name_i is not null or
191: per_sos_ins.g_user_id_i is not null) Then

Line 223: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');

219: Else
220: --
221: -- No registerd key values, so raise an error
222: --
223: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
224: hr_utility.set_message_token('API_NAME', 'per_sos_ins');
225: hr_utility.set_message_token('ARGUMENT', 'base_key_value');
226: hr_utility.raise_error;
227: End If;

Line 224: hr_utility.set_message_token('API_NAME', 'per_sos_ins');

220: --
221: -- No registerd key values, so raise an error
222: --
223: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
224: hr_utility.set_message_token('API_NAME', 'per_sos_ins');
225: hr_utility.set_message_token('ARGUMENT', 'base_key_value');
226: hr_utility.raise_error;
227: End If;
228: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 225: hr_utility.set_message_token('ARGUMENT', 'base_key_value');

221: -- No registerd key values, so raise an error
222: --
223: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
224: hr_utility.set_message_token('API_NAME', 'per_sos_ins');
225: hr_utility.set_message_token('ARGUMENT', 'base_key_value');
226: hr_utility.raise_error;
227: End If;
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End pre_insert;

Line 226: hr_utility.raise_error;

222: --
223: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
224: hr_utility.set_message_token('API_NAME', 'per_sos_ins');
225: hr_utility.set_message_token('ARGUMENT', 'base_key_value');
226: hr_utility.raise_error;
227: End If;
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End pre_insert;
230: --

Line 228: hr_utility.set_location(' Leaving:'||l_proc, 10);

224: hr_utility.set_message_token('API_NAME', 'per_sos_ins');
225: hr_utility.set_message_token('ARGUMENT', 'base_key_value');
226: hr_utility.raise_error;
227: End If;
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: End pre_insert;
230: --
231: -- ----------------------------------------------------------------------------
232: -- |-----------------------------< post_insert >------------------------------|

Line 270: hr_utility.set_location('Entering:'||l_proc, 5);

266: --
267: l_proc varchar2(72) := g_package||'post_insert';
268: --
269: Begin
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: begin
272: --
273: per_sos_rki.after_insert
274: (p_solution_id

Line 294: hr_utility.set_location(' Leaving:'||l_proc, 10);

290: ,p_hook_type => 'AI');
291: --
292: end;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 10);
295: End post_insert;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |---------------------------------< ins >----------------------------------|

Line 307: hr_utility.set_location('Entering:'||l_proc, 5);

303: --
304: l_proc varchar2(72) := g_package||'ins';
305: --
306: Begin
307: hr_utility.set_location('Entering:'||l_proc, 5);
308: --
309: -- Call the supporting insert validate operations
310: --
311: per_sos_bus.insert_validate

Line 335: hr_utility.set_location('Leaving:'||l_proc, 20);

331: --
332: -- Call to raise any errors on multi-message list
333: hr_multi_message.end_validation_set;
334: --
335: hr_utility.set_location('Leaving:'||l_proc, 20);
336: end ins;
337: --
338: -- ----------------------------------------------------------------------------
339: -- |---------------------------------< ins >----------------------------------|

Line 352: hr_utility.set_location('Entering:'||l_proc, 5);

348: l_rec per_sos_shd.g_rec_type;
349: l_proc varchar2(72) := g_package||'ins';
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: -- Call conversion function to turn arguments into the
355: -- p_rec structure.
356: --

Line 380: hr_utility.set_location(' Leaving:'||l_proc, 10);

376: p_solution_set_name := l_rec.solution_set_name;
377: p_user_id := l_rec.user_id;
378: p_object_version_number := l_rec.object_version_number;
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: End ins;
382: --
383: end per_sos_ins;