DBA Data[Home] [Help]

APPS.PE_POI_INS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: -- Insert the row into: per_position_extra_info
56: --

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

178: p_rec.poei_information30,
179: p_rec.object_version_number
180: );
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: Exception
184: When hr_api.check_integrity_violated Then
185: -- A check constraint has been violated
186: pe_poi_shd.constraint_error

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

240: --
241: Cursor C_Sel1 is select per_position_extra_info_s.nextval from sys.dual;
242: --
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: --
247: -- Select the next sequence number
248: --

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

249: Open C_Sel1;
250: Fetch C_Sel1 Into p_rec.position_extra_info_id;
251: Close C_Sel1;
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: End pre_insert;
255: --
256: -- ----------------------------------------------------------------------------
257: -- |-----------------------------< post_insert >------------------------------|

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

289: --
290: l_proc varchar2(72) := g_package||'post_insert';
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- This is a hook point and the user hook for post_insert is called here.
296: --
297: begin

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

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

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

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

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

412: If p_validate then
413: Raise HR_Api.Validate_Enabled;
414: End If;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: Exception
418: When HR_Api.Validate_Enabled Then
419: --
420: -- As the Validate_Enabled exception has been raised

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

494: l_rec pe_poi_shd.g_rec_type;
495: l_proc varchar2(72) := g_package||'ins';
496: --
497: Begin
498: hr_utility.set_location('Entering:'||l_proc, 5);
499: --
500: -- Call conversion function to turn arguments into the
501: -- p_rec structure.
502: --

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

575: --
576: p_position_extra_info_id := l_rec.position_extra_info_id;
577: p_object_version_number := l_rec.object_version_number;
578: --
579: hr_utility.set_location(' Leaving:'||l_proc, 10);
580: End ins;
581: --
582: end pe_poi_ins;