DBA Data[Home] [Help]

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

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

216: );
217: --
218: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: Exception
222: When hr_api.check_integrity_violated Then
223: -- A check constraint has been violated
224: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status

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

282: --
283: Cursor C_Sel1 is select ssp_maternities_s.nextval from sys.dual;
284: --
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 5);
287: --
288: --
289: -- Select the next sequence number
290: --

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

291: Open C_Sel1;
292: Fetch C_Sel1 Into p_rec.maternity_id;
293: Close C_Sel1;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End pre_insert;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |-----------------------------< post_insert >------------------------------|

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

331: --
332: l_proc varchar2(72) := g_package||'post_insert';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 10);
338: End post_insert;
339: --

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

333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 10);
338: End post_insert;
339: --
340: -- ----------------------------------------------------------------------------
341: -- |---------------------------------< ins >----------------------------------|

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

348: --
349: l_proc varchar2(72) := g_package||'ins';
350: --
351: Begin
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: -- Determine if the business process is to be validated.
355: --
356: If p_validate then

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

381: If p_validate then
382: Raise HR_Api.Validate_Enabled;
383: End If;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: Exception
387: When HR_Api.Validate_Enabled Then
388: --
389: -- As the Validate_Enabled exception has been raised

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

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

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

572: --
573: p_maternity_id := l_rec.maternity_id;
574: p_object_version_number := l_rec.object_version_number;
575: --
576: hr_utility.set_location(' Leaving:'||l_proc, 10);
577: End ins;
578: --
579: end ssp_mat_ins;