DBA Data[Home] [Help]

APPS.PQH_DEL_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: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;

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

68: object_version_number = p_rec.object_version_number
69: where dflt_budget_element_id = p_rec.dflt_budget_element_id;
70: --
71: --
72: hr_utility.set_location(' Leaving:'||l_proc, 10);
73: --
74: Exception
75: When hr_api.check_integrity_violated Then
76: -- A check constraint has been violated

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

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

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

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

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

177:
178:
179: --
180: Begin
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: --
184: open csr_element(p_dflt_budget_set_id => p_rec.dflt_budget_set_id );
185: fetch csr_element into l_sum;

Line 191: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');

187:
188: if l_sum > 100 then
189: -- sum cannot be more then 100
190: --
191: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');
192: hr_utility.raise_error;
193: --
194: end if;
195: --

Line 192: hr_utility.raise_error;

188: if l_sum > 100 then
189: -- sum cannot be more then 100
190: --
191: hr_utility.set_message(8302,'PQH_WKS_INVALID_ELMNT_SUM');
192: hr_utility.raise_error;
193: --
194: end if;
195: --
196: --

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

223: --
224: -- End of API User Hook for post_update.
225: --
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: End post_update;
229: --
230: -- ----------------------------------------------------------------------------
231: -- |-----------------------------< convert_defs >-----------------------------|

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

275: l_proc varchar2(72) := g_package||'convert_defs';
276: --
277: Begin
278: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- We must now examine each argument value in the
282: -- p_rec plsql record structure
283: -- to see if a system default is being used. If a system default

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

296: pqh_del_shd.g_old_rec.dflt_dist_percentage;
297: End If;
298:
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 10);
301: --
302: End convert_defs;
303: --
304: -- ----------------------------------------------------------------------------

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

311: --
312: l_proc varchar2(72) := g_package||'upd';
313: --
314: Begin
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: -- We must lock the row which we need to update.
318: --
319: pqh_del_shd.lck

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

359: l_rec pqh_del_shd.g_rec_type;
360: l_proc varchar2(72) := g_package||'upd';
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: -- Call conversion function to turn arguments into the
366: -- l_rec structure.
367: --

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

381: --
382: upd(l_rec);
383: p_object_version_number := l_rec.object_version_number;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: End upd;
387: --
388: end pqh_del_upd;