DBA Data[Home] [Help]

APPS.GHR_NRE_INS dependencies on HR_UTILITY

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

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

79: p_rec.object_version_number
80: );
81: --
82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: Exception
85: When hr_api.check_integrity_violated Then
86: -- A check constraint has been violated
87: p_rec := l_rec;

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

147: Cursor C_Sel1 is select ghr_noac_remarks_s.nextval from sys.dual;
148: --
149: Begin
150: l_proc := g_package||'pre_insert';
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: l_rec := p_rec;
153: --
154: --
155: -- Select the next sequence number

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

157: Open C_Sel1;
158: Fetch C_Sel1 Into p_rec.noac_remark_id;
159: Close C_Sel1;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: EXCEPTION
163: when others then
164: p_rec := l_rec;
165: raise;

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

203: l_proc varchar2(72);
204: --
205: Begin
206: l_proc := g_package||'post_insert';
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: --
210: -- Start of API User Hook for post_insert.
211: --

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

236: --
237: -- End of API User Hook for post_insert.
238: --
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: End post_insert;
242: --
243: -- ----------------------------------------------------------------------------
244: -- |---------------------------------< ins >----------------------------------|

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

253: l_rec ghr_nre_shd.g_rec_type ;
254: --
255: Begin
256: l_proc := g_package||'ins';
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: l_rec := p_rec;
259: --
260: -- Call the supporting insert validate operations
261: --

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

300: l_proc varchar2(72) ;
301: --
302: Begin
303: l_proc := g_package||'ins';
304: hr_utility.set_location('Entering:'||l_proc, 5);
305: --
306: -- Call conversion function to turn arguments into the
307: -- p_rec structure.
308: --

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

330: --
331: p_noac_remark_id := l_rec.noac_remark_id;
332: p_object_version_number := l_rec.object_version_number;
333: --
334: hr_utility.set_location(' Leaving:'||l_proc, 10);
335: exception
336: when others then
337: p_noac_remark_id := null;
338: p_object_version_number := null;