APPS.PER_CPN_INS dependencies on HR_UTILITY

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

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

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

197: ,p_rec.information19
198: ,p_rec.information20
199: );
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: Exception
203: When hr_api.check_integrity_violated Then
204: -- A check constraint has been violated
205: per_cpn_shd.constraint_error

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

259: --
260: cursor C_Sel1 is select per_competences_s.nextval from sys.dual;
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: Open C_Sel1;
266: Fetch C_Sel1 Into p_rec.competence_id;
267: Close C_Sel1;

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

265: Open C_Sel1;
266: Fetch C_Sel1 Into p_rec.competence_id;
267: Close C_Sel1;
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: End pre_insert;
271: --
272: -- ----------------------------------------------------------------------------
273: -- |-----------------------------< post_insert >------------------------------|

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

305: --
306: l_proc varchar2(72) := g_package||'post_insert';
307: --
308: Begin
309: hr_utility.set_location('Entering:'||l_proc, 5);
310: --
311: -- This is a hook point and the user hook for post_insert is called here.
312: --
313: begin

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

390: );
391: end;
392: -- End of API User Hook for post_insert.
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: End post_insert;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |---------------------------------< ins >----------------------------------|

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

406: --
407: l_proc varchar2(72) := g_package||'ins';
408: --
409: Begin
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: -- Determine if the business process is to be validated.
413: --
414: If p_validate then

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

439: If p_validate then
440: Raise HR_Api.Validate_Enabled;
441: End If;
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 10);
444: Exception
445: When HR_Api.Validate_Enabled Then
446: --
447: -- As the Validate_Enabled exception has been raised

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

530: l_rec per_cpn_shd.g_rec_type;
531: l_proc varchar2(72) := g_package||'ins';
532: --
533: Begin
534: hr_utility.set_location('Entering:'||l_proc, 5);
535: --
536: -- Call conversion function to turn arguments into the
537: -- p_rec structure.
538: -- ngundura added competence_alias as a parameter to convert args

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

620: --
621: p_competence_id := l_rec.competence_id;
622: p_object_version_number := l_rec.object_version_number;
623: --
624: hr_utility.set_location(' Leaving:'||l_proc, 10);
625: End ins;
626: --
627: end per_cpn_ins;