DBA Data[Home] [Help]

APPS.PER_APR_DEL dependencies on HR_UTILITY

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

46:
47: l_proc varchar2(72) := g_package||'delete_dml';
48:
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51:
52:
53: -- Delete the per_appraisals row.
54:

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

55: delete from per_appraisals
56: where appraisal_id = p_rec.appraisal_id;
57:
58:
59: hr_utility.set_location(' Leaving:'||l_proc, 10);
60:
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated

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

103:
104: l_proc varchar2(72) := g_package||'pre_delete';
105:
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108:
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: End pre_delete;
111:

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

105:
106: Begin
107: hr_utility.set_location('Entering:'||l_proc, 5);
108:
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: End pre_delete;
111:
112: -- ---------------------------------------------------------------------------+
113: -- |-----------------------------< post_delete >------------------------------|

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

145:
146: l_proc varchar2(72) := g_package||'post_delete';
147:
148: Begin
149: hr_utility.set_location('Entering:'||l_proc, 5);
150:
151: -- This is a hook point and the user hook for post_delete is called here.
152:
153: begin

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

229: );
230: end;
231: -- End of API User Hook for post_delete.
232:
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: End post_delete;
235:
236: -- ---------------------------------------------------------------------------+
237: -- |---------------------------------< del >----------------------------------|

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

244:
245: l_proc varchar2(72) := g_package||'del';
246:
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249:
250: -- Determine if the business process is to be validated.
251:
252: If p_validate then

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

289: If p_validate then
290: Raise HR_Api.Validate_Enabled;
291: End If;
292:
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: Exception
295: When HR_Api.Validate_Enabled Then
296:
297: -- As the Validate_Enabled exception has been raised

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

313: l_rec per_apr_shd.g_rec_type;
314: l_proc varchar2(72) := g_package||'del';
315:
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318:
319: -- As the delete procedure accepts a plsql record structure we do need to
320: -- convert the arguments into the record structure.
321: -- We don't need to call the supplied conversion argument routine as we

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

329: -- business process
330:
331: del(l_rec, p_validate);
332:
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: End del;
335:
336: end per_apr_del;