DBA Data[Home] [Help]

APPS.HR_LOT_UPD dependencies on HR_UTILITY

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

49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Update the hr_locations_all_tl Row
56: --
57: update hr_locations_all_tl

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

64: where location_id = p_rec.location_id
65: and language = p_rec.language;
66:
67: --
68: hr_utility.set_location(' Leaving:'||l_proc, 10);
69: --
70: Exception
71: When hr_api.check_integrity_violated Then
72: -- A check constraint has been violated

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

120: --
121: l_proc varchar2(72) := g_package||'pre_update';
122: --
123: Begin
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: End pre_update;
128: --

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

122: --
123: Begin
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: End pre_update;
128: --
129: -- ----------------------------------------------------------------------------
130: -- |-----------------------------< post_update >------------------------------|

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

162: --
163: l_proc varchar2(72) := g_package||'post_update';
164: --
165: Begin
166: hr_utility.set_location('Entering:'||l_proc, 5);
167: --
168: --
169: -- Start of API User Hook for post_update.
170: --

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

194: --
195: -- End of API User Hook for post_update.
196: --
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: End post_update;
200: --
201: -- ----------------------------------------------------------------------------
202: -- |-----------------------------< convert_defs >-----------------------------|

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

246: l_proc varchar2(72) := g_package||'convert_defs';
247: --
248: Begin
249: --
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: --
252: -- We must now examine each argument value in the
253: -- p_rec plsql record structure
254: -- to see if a system default is being used. If a system default

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

266: p_rec.description :=
267: hr_lot_shd.g_old_rec.description;
268: End If;
269: --
270: hr_utility.set_location(' Leaving:'||l_proc, 10);
271: --
272: End convert_defs;
273: --
274: -- ----------------------------------------------------------------------------

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

282: --
283: l_proc varchar2(72) := g_package||'upd';
284: --
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 5);
287: --
288: -- We must lock the row which we need to update.
289: --
290: hr_lot_shd.lck

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

331: l_rec hr_lot_shd.g_rec_type;
332: l_proc varchar2(72) := g_package||'upd';
333: --
334: Begin
335: hr_utility.set_location('Entering:'||l_proc, 5);
336: --
337: -- Call conversion function to turn arguments into the
338: -- l_rec structure.
339: --

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

354: upd( l_rec,
355: p_business_group_id);
356: --
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 10);
359: End upd;
360: --
361: -- ------------------------------------------------------------------------
362: -- |-----------------------------< upd_tl >-------------------------------|

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

384: l_updated_anything boolean := false;
385: --
386: begin
387: --
388: hr_utility.set_location('Entering:'||l_proc, 10);
389: --
390: l_business_group_id := hr_lot_shd.return_value_business_group_id
391: ( p_location_id => p_location_id );
392: --

Line 396: hr_utility.set_location(l_proc, 15);

392: --
393: -- Update the translated values for every matching row
394: -- setting SOURCE_LANG to the specified language.
395: --
396: hr_utility.set_location(l_proc, 15);
397: for l_lang in csr_upd_langs loop
398: upd
399: (p_location_id => p_location_id
400: ,p_language => l_lang.language

Line 410: hr_utility.set_message(800, 'PER_52518_NO_MLS_UPDATES');

406: l_updated_anything := true;
407: end loop;
408: --
409: if not l_updated_anything then
410: hr_utility.set_message(800, 'PER_52518_NO_MLS_UPDATES');
411: hr_utility.raise_error;
412: end if;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 411: hr_utility.raise_error;

407: end loop;
408: --
409: if not l_updated_anything then
410: hr_utility.set_message(800, 'PER_52518_NO_MLS_UPDATES');
411: hr_utility.raise_error;
412: end if;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 20);
415: End upd_tl;

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

410: hr_utility.set_message(800, 'PER_52518_NO_MLS_UPDATES');
411: hr_utility.raise_error;
412: end if;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 20);
415: End upd_tl;
416: --
417: end hr_lot_upd;