DBA Data[Home] [Help]

APPS.PQH_VLD_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_vld_ins.g_validation_id_i := p_validation_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_vld_ins.g_validation_id_i := p_validation_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 132: hr_utility.set_location(' Leaving:'||l_proc, 10);

128: );
129: --
130: --
131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: --

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

203: l_proc varchar2(72) := g_package||'pre_insert';
204: l_exists varchar2(1);
205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: If (pqh_vld_ins.g_validation_id_i is not null) Then
210: --
211: -- Verify registered primary key values not already in use

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

239: Fetch C_Sel1 Into p_rec.validation_id;
240: Close C_Sel1;
241: End If;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: End pre_insert;
245: --
246: -- ----------------------------------------------------------------------------
247: -- |-----------------------------< post_insert >------------------------------|

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

282: --
283: l_proc varchar2(72) := g_package||'post_insert';
284: --
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 5);
287: begin
288: --
289: pqh_vld_rki.after_insert
290: (p_effective_date => p_effective_date

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

335: ,p_hook_type => 'AI');
336: --
337: end;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End post_insert;
341: --
342: -- ----------------------------------------------------------------------------
343: -- |---------------------------------< ins >----------------------------------|

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

349: --
350: l_proc varchar2(72) := g_package||'ins';
351: --
352: Begin
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: --
355: -- Call the supporting insert validate operations
356: --
357: pqh_vld_bus.insert_validate

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

379: --
380: -- Call to raise any errors on multi-message list
381: hr_multi_message.end_validation_set;
382: --
383: hr_utility.set_location('Leaving:'||l_proc, 20);
384: end ins;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |---------------------------------< ins >----------------------------------|

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

411: l_rec pqh_vld_shd.g_rec_type;
412: l_proc varchar2(72) := g_package||'ins';
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- Call conversion function to turn arguments into the
418: -- p_rec structure.
419: --

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

452: --
453: p_validation_id := l_rec.validation_id;
454: p_object_version_number := l_rec.object_version_number;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: End ins;
458: --
459: end pqh_vld_ins;