DBA Data[Home] [Help]

APPS.PE_PEI_INS dependencies on HR_UTILITY

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

58: --
59: l_proc varchar2(72) := g_package||'insert_dml';
60: --
61: Begin
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: p_rec.object_version_number := 1; -- Initialise the object version
64: --
65: -- Insert the row into: per_people_extra_info
66: --

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

188: p_rec.pei_information30,
189: p_rec.object_version_number
190: );
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: Exception
194: When hr_api.check_integrity_violated Then
195: -- A check constraint has been violated
196: pe_pei_shd.constraint_error

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

250: --
251: Cursor C_Sel1 is select per_people_extra_info_s.nextval from sys.dual;
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: --
257: -- Select the next sequence number
258: --

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

259: Open C_Sel1;
260: Fetch C_Sel1 Into p_rec.person_extra_info_id;
261: Close C_Sel1;
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: End pre_insert;
265: --
266: -- ----------------------------------------------------------------------------
267: -- |-----------------------------< post_insert >------------------------------|

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

299: --
300: l_proc varchar2(72) := g_package||'post_insert';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- This is a hook point and the user hook for post_insert is called here.
306: --
307: begin

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

404: end;
405: end if;
406: end if;
407: --
408: hr_utility.set_location(' Leaving:'||l_proc, 10);
409: End post_insert;
410: --
411: -- ----------------------------------------------------------------------------
412: -- |---------------------------------< ins >----------------------------------|

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

419: --
420: l_proc varchar2(72) := g_package||'ins';
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: -- Determine if the business process is to be validated.
426: --
427: If p_validate then

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

452: If p_validate then
453: Raise HR_Api.Validate_Enabled;
454: End If;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: Exception
458: When HR_Api.Validate_Enabled Then
459: --
460: -- As the Validate_Enabled exception has been raised

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

534: l_rec pe_pei_shd.g_rec_type;
535: l_proc varchar2(72) := g_package||'ins';
536: --
537: Begin
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: -- Call conversion function to turn arguments into the
541: -- p_rec structure.
542: --

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

615: --
616: p_person_extra_info_id := l_rec.person_extra_info_id;
617: p_object_version_number := l_rec.object_version_number;
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);
620: End ins;
621: --
622: end pe_pei_ins;