DBA Data[Home] [Help]

APPS.PQH_PRE_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: pqh_pre_ins.g_ins_end_reason_id_i := p_ins_end_reason_id;
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: pqh_pre_ins.g_ins_end_reason_id_i := p_ins_end_reason_id;
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 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 185: hr_utility.set_location('Entering:'||l_proc, 5);

181: l_proc varchar2(72) := g_package||'pre_insert';
182: l_exists varchar2(1);
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: If (pqh_pre_ins.g_ins_end_reason_id_i is not null) Then
188: --
189: -- Verify registered primary key values not already in use

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

217: Fetch C_Sel1 Into p_rec.ins_end_reason_id;
218: Close C_Sel1;
219: End If;
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End pre_insert;
223: --
224: -- ----------------------------------------------------------------------------
225: -- |-----------------------------< post_insert >------------------------------|

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

259: --
260: l_proc varchar2(72) := g_package||'post_insert';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: begin
265: --
266: pqh_pre_rki.after_insert
267: (p_ins_end_reason_id

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 306: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

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

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

379: --
380: p_ins_end_reason_id := l_rec.ins_end_reason_id;
381: p_object_version_number := l_rec.object_version_number;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End ins;
385: --
386: end pqh_pre_ins;