DBA Data[Home] [Help]

APPS.PER_STB_INS dependencies on HR_UTILITY

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

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_stb_ins.g_setup_task_code_i := p_setup_task_code;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_stb_ins.g_setup_task_code_i := p_setup_task_code;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------

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

78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --

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

110: );
111: --
112: --
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 10);
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --

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_stb_ins.g_setup_task_code_i is not null) Then
190: --
191: -- Verify registered primary key values not already in use

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

213: -- No registerd key values, so select the next sequence number
214: --
215: -- No registerd key values, so raise error
216: --
217: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
218: hr_utility.set_message_token('API_NAME', g_package);
219: hr_utility.set_message_token('ARGUMENT', 'workbench_item_code');
220: hr_utility.raise_error; --
221:

Line 218: hr_utility.set_message_token('API_NAME', g_package);

214: --
215: -- No registerd key values, so raise error
216: --
217: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
218: hr_utility.set_message_token('API_NAME', g_package);
219: hr_utility.set_message_token('ARGUMENT', 'workbench_item_code');
220: hr_utility.raise_error; --
221:
222: End If;

Line 219: hr_utility.set_message_token('ARGUMENT', 'workbench_item_code');

215: -- No registerd key values, so raise error
216: --
217: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
218: hr_utility.set_message_token('API_NAME', g_package);
219: hr_utility.set_message_token('ARGUMENT', 'workbench_item_code');
220: hr_utility.raise_error; --
221:
222: End If;
223: --

Line 220: hr_utility.raise_error; --

216: --
217: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
218: hr_utility.set_message_token('API_NAME', g_package);
219: hr_utility.set_message_token('ARGUMENT', 'workbench_item_code');
220: hr_utility.raise_error; --
221:
222: End If;
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

220: hr_utility.raise_error; --
221:
222: End If;
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: End pre_insert;
226: --
227: -- ----------------------------------------------------------------------------
228: -- |-----------------------------< post_insert >------------------------------|

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

263: --
264: l_proc varchar2(72) := g_package||'post_insert';
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: begin
269: --
270: per_stb_rki.after_insert
271: (p_effective_date => p_effective_date

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

289: ,p_hook_type => 'AI');
290: --
291: end;
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: End post_insert;
295: --
296: -- ----------------------------------------------------------------------------
297: -- |---------------------------------< 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_stb_bus.insert_validate

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

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

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

356: l_rec per_stb_shd.g_rec_type;
357: l_proc varchar2(72) := g_package||'ins';
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: -- Call conversion function to turn arguments into the
363: -- p_rec structure.
364: --

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

388: --
389: p_setup_task_code := l_rec.setup_task_code;
390: p_object_version_number := l_rec.object_version_number;
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: End ins;
394: --
395: end per_stb_ins;