DBA Data[Home] [Help]

APPS.PER_VGR_INS dependencies on HR_UTILITY

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

54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: per_vgr_shd.g_api_dml := true; -- Set the api dml status
62: --

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

136: );
137: --
138: per_vgr_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: per_vgr_shd.g_api_dml := false; -- Unset the api dml status

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

202: --
203: Cursor C_Sel1 is select per_valid_grades_s.nextval from sys.dual;
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: --
209: -- Select the next sequence number
210: --

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

211: Open C_Sel1;
212: Fetch C_Sel1 Into p_rec.valid_grade_id;
213: Close C_Sel1;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: End pre_insert;
217: --
218: -- ----------------------------------------------------------------------------
219: -- |-----------------------------< post_insert >------------------------------|

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

252: --
253: l_proc varchar2(72) := g_package||'post_insert';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: -- Start of API User Hook for post_insert.
259: Begin
260: per_vgr_rki.after_insert

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

302: );
303: end;
304: -- End of API User Hook for post_insert.
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: End post_insert;
308: --
309: -- ----------------------------------------------------------------------------
310: -- |---------------------------------< ins >----------------------------------|

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

318: --
319: l_proc varchar2(72) := g_package||'ins';
320: --
321: Begin
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: -- Determine if the business process is to be validated.
325: --
326: If p_validate then

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

351: If p_validate then
352: Raise HR_Api.Validate_Enabled;
353: End If;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 10);
356: Exception
357: When HR_Api.Validate_Enabled Then
358: --
359: -- As the Validate_Enabled exception has been raised

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

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

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

463: --
464: p_valid_grade_id := l_rec.valid_grade_id;
465: p_object_version_number := l_rec.object_version_number;
466: --
467: hr_utility.set_location(' Leaving:'||l_proc, 10);
468: End ins;
469: --
470: end per_vgr_ins;