APPS.PQH_TTL_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: --
56: --
57: -- Update the pqh_templates_tl Row

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

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

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

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

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

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

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

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

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

262: p_rec.source_lang :=
263: pqh_ttl_shd.g_old_rec.source_lang;
264: End If;
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: --
268: End convert_defs;
269: --
270: -- ----------------------------------------------------------------------------

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

277: --
278: l_proc varchar2(72) := g_package||'upd';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- We must lock the row which we need to update.
284: --
285: pqh_ttl_shd.lck

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

324: l_rec pqh_ttl_shd.g_rec_type;
325: l_proc varchar2(72) := g_package||'upd';
326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: --
330: -- Call conversion function to turn arguments into the
331: -- l_rec structure.
332: --

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

345: --
346: upd(l_rec);
347: --
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: End upd;
351: --
352: --
353: -- ----------------------------------------------------------------------------

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

371: l_proc varchar2(72) := g_package||'upd_tl';
372: --
373: begin
374: --
375: hr_utility.set_location(' Entering:'||l_proc, 10);
376: --
377: for l_lang in csr_upd_langs loop
378: --
379: --

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

385: --
386: --
387: end loop;
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 20);
390: --
391: end upd_tl;
392:
393: