APPS.GHR_CAA_INS dependencies on HR_UTILITY

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

20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ghr_caa_ins.g_compl_agency_appeal_id_i := p_compl_agency_appeal_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ghr_caa_ins.g_compl_agency_appeal_id_i := p_compl_agency_appeal_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------

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

78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --

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

150: );
151: --
152: --
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: --

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

225: l_proc varchar2(72) := g_package||'pre_insert';
226: l_exists varchar2(1);
227: --
228: Begin
229: hr_utility.set_location('Entering:'||l_proc, 5);
230: --
231: If (ghr_caa_ins.g_compl_agency_appeal_id_i is not null) Then
232: --
233: -- Verify registered primary key values not already in use

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

261: Fetch C_Sel1 Into p_rec.compl_agency_appeal_id;
262: Close C_Sel1;
263: End If;
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End pre_insert;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |-----------------------------< post_insert >------------------------------|

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

305: l_proc varchar2(72) := g_package||'post_insert';
306: --
307:
308: Begin
309: hr_utility.set_location('Entering:'||l_proc, 5);
310: begin
311: --
312: ghr_caa_rki.after_insert
313: (p_effective_date => p_effective_date

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

351: ,p_hook_type => 'AI');
352: --
353: end;
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 10);
356: End post_insert;
357: --
358: -- ----------------------------------------------------------------------------
359: -- |---------------------------------< ins >----------------------------------|

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

365: --
366: l_proc varchar2(72) := g_package||'ins';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- Call the supporting insert validate operations
372: --
373: ghr_caa_bus.insert_validate

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

389: (p_effective_date
390: ,p_rec
391: );
392: --
393: hr_utility.set_location('Leaving:'||l_proc, 20);
394: end ins;
395: --
396: -- ----------------------------------------------------------------------------
397: -- |---------------------------------< ins >----------------------------------|

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

432: l_rec ghr_caa_shd.g_rec_type;
433: l_proc varchar2(72) := g_package||'ins';
434: --
435: Begin
436: hr_utility.set_location('Entering:'||l_proc, 5);
437: --
438: -- Call conversion function to turn arguments into the
439: -- p_rec structure.
440: --

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

484: --
485: p_compl_agency_appeal_id := l_rec.compl_agency_appeal_id;
486: p_object_version_number := l_rec.object_version_number;
487: --
488: hr_utility.set_location(' Leaving:'||l_proc, 10);
489: End ins;
490: --
491: end ghr_caa_ins;