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 214: hr_utility.set_location(' Leaving:'||l_proc, 10);

210: );
211: --
212: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: Exception
216: When hr_api.check_integrity_violated Then
217: -- A check constraint has been violated
218: ssp_mat_shd.g_api_dml := false; -- Unset the api dml status

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

276: --
277: Cursor C_Sel1 is select ssp_maternities_s.nextval from sys.dual;
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: --
283: -- Select the next sequence number
284: --

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

285: Open C_Sel1;
286: Fetch C_Sel1 Into p_rec.maternity_id;
287: Close C_Sel1;
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290: End pre_insert;
291: --
292: -- ----------------------------------------------------------------------------
293: -- |-----------------------------< post_insert >------------------------------|

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

325: --
326: l_proc varchar2(72) := g_package||'post_insert';
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: End post_insert;
333: --

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

327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: End post_insert;
333: --
334: -- ----------------------------------------------------------------------------
335: -- |---------------------------------< ins >----------------------------------|

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

342: --
343: l_proc varchar2(72) := g_package||'ins';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Determine if the business process is to be validated.
349: --
350: If p_validate then

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

375: If p_validate then
376: Raise HR_Api.Validate_Enabled;
377: End If;
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: Exception
381: When HR_Api.Validate_Enabled Then
382: --
383: -- As the Validate_Enabled exception has been raised

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

468: l_rec ssp_mat_shd.g_rec_type;
469: l_proc varchar2(72) := g_package||'ins';
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Call conversion function to turn arguments into the
475: -- p_rec structure.
476: --

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

560: --
561: p_maternity_id := l_rec.maternity_id;
562: p_object_version_number := l_rec.object_version_number;
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 10);
565: End ins;
566: --
567: end ssp_mat_ins;