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

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

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

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

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

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

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

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

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

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