eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOT_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: -- Delete the hr_locations_all_tl row.
53: --
54: delete from hr_locations_all_tl

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

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

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

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

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

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

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

144: --
145: l_proc varchar2(72) := g_package||'post_delete';
146: --
147: Begin
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: --
150: --
151: -- Start of API User Hook for post_delete.
152: --

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

173: --
174: -- End of API User Hook for post_delete.
175: --
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: End post_delete;
179: --
180: -- ----------------------------------------------------------------------------
181: -- |---------------------------------< del >----------------------------------|

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

187: --
188: l_proc varchar2(72) := g_package||'del';
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: -- We must lock the row which we need to delete.
194: --
195: hr_lot_shd.lck

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

227: l_rec hr_lot_shd.g_rec_type;
228: l_proc varchar2(72) := g_package||'del';
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: --
233: -- As the delete procedure accepts a plsql record structure we do need to
234: -- convert the arguments into the record structure.
235: -- We don't need to call the supplied conversion argument routine as we

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

244: -- business process
245: --
246: del(l_rec);
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End del;
250: --
251: -- ------------------------------------------------------------------------
252: -- |-----------------------------< del_tl >-------------------------------|

Line 271: hr_utility.set_location('Entering:'||l_proc, 10);

267: l_proc varchar2(72) := g_package||'del_tl';
268: l_deleted_anything boolean := false;
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 10);
272: --
273: -- Delete all the translated rows
274: --
275: for l_lang in csr_del_langs loop

Line 284: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');

280: l_deleted_anything := true;
281: end loop;
282: --
283: if not l_deleted_anything then
284: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;
286: end if;
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 285: hr_utility.raise_error;

281: end loop;
282: --
283: if not l_deleted_anything then
284: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;
286: end if;
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 20);
289: End del_tl;

Line 288: hr_utility.set_location(' Leaving:'||l_proc, 20);

284: hr_utility.set_message(800, 'HR_7220_INVALID_PRIMARY_KEY');
285: hr_utility.raise_error;
286: end if;
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 20);
289: End del_tl;
290: --
291: end hr_lot_del;