APPS.PER_PHN_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_phn_ins.g_phone_id_i := p_phone_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: per_phn_ins.g_phone_id_i := p_phone_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: -- ----------------------------------------------------------------------------
31: -- |------------------------------< insert_dml >------------------------------|
32: -- ----------------------------------------------------------------------------

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

68: --
69: l_proc varchar2(72) := g_package||'insert_dml';
70: --
71: Begin
72: hr_utility.set_location('Entering:'||l_proc, 5);
73: p_rec.object_version_number := 1; -- Initialise the object version
74: --
75: -- Insert the row into: per_phones
76: --

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

160: p_rec.validity,
161: p_rec.object_version_number
162: );
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: per_phn_shd.constraint_error

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

228: from per_phones
229: where phone_id = per_phn_ins.g_phone_id_i;
230: --
231: Begin
232: hr_utility.set_location('Entering:'||l_proc, 5);
233: --
234: if per_phn_ins.g_phone_id_i is not null then
235: --
236: -- Verify registered primary key values not already in use

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

261: Fetch C_Sel1 Into p_rec.phone_id;
262: Close C_Sel1;
263: --
264: end if;
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End pre_insert;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |-----------------------------< post_insert >------------------------------|

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

302: --
303: l_proc varchar2(72) := g_package||'post_insert';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: --
309: -- Start of API User Hook for post_insert.
310: begin

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

362: end;
363: --
364: -- End of API User Hook for post_insert.
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End post_insert;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |---------------------------------< ins >----------------------------------|

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

378: --
379: l_proc varchar2(72) := g_package||'ins';
380: --
381: Begin
382: hr_utility.set_location('Entering:'||l_proc, 5);
383: --
384: -- Determine if the business process is to be validated.
385: --
386: If p_validate then

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

421: If p_validate then
422: Raise HR_Api.Validate_Enabled;
423: End If;
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 10);
426: Exception
427: When HR_Api.Validate_Enabled Then
428: --
429: -- As the Validate_Enabled exception has been raised

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

485: l_rec per_phn_shd.g_rec_type;
486: l_proc varchar2(72) := g_package||'ins';
487: --
488: Begin
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: -- Call conversion function to turn arguments into the
492: -- p_rec structure.
493: --

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

547: --
548: p_phone_id := l_rec.phone_id;
549: p_object_version_number := l_rec.object_version_number;
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 10);
552: End ins;
553: --
554: end per_phn_ins;