APPS.GHR_PRH_INS dependencies on HR_UTILITY

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

50: l_rec ghr_prh_shd.g_rec_type;
51: --
52: Begin
53: l_proc := g_package||'insert_dml';
54: hr_utility.set_location('Entering:'||l_proc, 5);
55: l_rec := p_rec;
56: p_rec.object_version_number := 1; -- Initialise the object version
57: --
58:

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

115: p_rec.object_version_number
116: );
117:
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: p_rec := l_rec;

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

184: Cursor C_Sel1 is select ghr_pa_routing_history_s.nextval from sys.dual;
185: --
186: Begin
187: l_proc := g_package||'pre_insert';
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: l_rec := p_rec;
190: --
191: --
192: -- Select the next sequence number

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

193: --
194: open C_Sel1;
195: Fetch C_Sel1 Into p_rec.pa_routing_history_id;
196: Close C_Sel1;
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: exception
199: when others then
200: p_rec := l_rec;
201: raise;

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

241: l_proc varchar2(72) ;
242: --
243: Begin
244: l_proc := g_package||'post_insert';
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: -- This is a hook point and the user hook for post_insert is called here.
248: --
249: begin

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

284: );
285: end;
286: -- End of API User Hook for post_insert.
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 10);
289: End post_insert;
290: --
291: -- ----------------------------------------------------------------------------
292: -- |---------------------------------< ins >----------------------------------|

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

301: l_rec ghr_prh_shd.g_rec_type;
302: --
303: Begin
304: l_proc := g_package||'ins';
305: hr_utility.set_location('Entering:'||l_proc, 5);
306: l_rec := p_rec;
307: --
308: -- Determine if the business process is to be validated.
309: --

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

336: If p_validate then
337: Raise HR_Api.Validate_Enabled;
338: End If;
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 10);
341: Exception
342: When HR_Api.Validate_Enabled Then
343: --
344: -- As the Validate_Enabled exception has been raised

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

389: l_proc varchar2(72) ;
390: --
391: Begin
392: l_proc := g_package||'ins';
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: --
395: -- Call conversion function to turn arguments into the
396: -- p_rec structure.
397: --

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

436: --
437: p_pa_routing_history_id := l_rec.pa_routing_history_id;
438: p_object_version_number := l_rec.object_version_number;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: exception
442: when others then
443: p_pa_routing_history_id := null;
444: p_object_version_number := null;