DBA Data[Home] [Help]

APPS.PER_SUB_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_sub_shd.g_api_dml := true; -- Set the api dml status
62: --

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

171: );
172: --
173: per_sub_shd.g_api_dml := false; -- Unset the api dml status
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: Exception
177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_sub_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

246: Open C_Sel1;
247: Fetch C_Sel1 Into p_rec.subjects_taken_id;
248: Close C_Sel1;
249: --
250: hr_utility.set_location(' Leaving:'||l_proc, 10);
251: End pre_insert;
252: --
253: -- ----------------------------------------------------------------------------
254: -- |-----------------------------< post_insert >------------------------------|

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

287: --
288: l_proc varchar2(72) := g_package||'post_insert';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- Start of Row Handler User Hook for post_insert.
294: --
295: Begin

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

357: end;
358: --
359: -- End of Row Handler User Hook for post_insert.
360: --
361: hr_utility.set_location(' Leaving:'||l_proc, 10);
362: End post_insert;
363: --
364: -- ----------------------------------------------------------------------------
365: -- |---------------------------------< ins >----------------------------------|

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

373: --
374: l_proc varchar2(72) := g_package||'ins';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Determine if the business process is to be validated.
380: --
381: If p_validate then

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

406: If p_validate then
407: Raise HR_Api.Validate_Enabled;
408: End If;
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 10);
411: Exception
412: When HR_Api.Validate_Enabled Then
413: --
414: -- As the Validate_Enabled exception has been raised

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

480: l_rec per_sub_shd.g_rec_type;
481: l_proc varchar2(72) := g_package||'ins';
482: --
483: Begin
484: hr_utility.set_location('Entering:'||l_proc, 5);
485: --
486: -- Call conversion function to turn arguments into the
487: -- p_rec structure.
488: --

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

552: --
553: p_subjects_taken_id := l_rec.subjects_taken_id;
554: p_object_version_number := l_rec.object_version_number;
555: --
556: hr_utility.set_location(' Leaving:'||l_proc, 10);
557: End ins;
558: --
559: end per_sub_ins;