DBA Data[Home] [Help]

APPS.GHR_PRE_INS dependencies on HR_UTILITY

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

48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: -- Insert the row into: ghr_pa_remarks
56: --

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: ghr_pre_shd.constraint_error

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

141: --
142: Cursor C_Sel1 is select ghr_pa_remarks_s.nextval from sys.dual;
143: --
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: --
148: -- Select the next sequence number
149: --

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

150: Open C_Sel1;
151: Fetch C_Sel1 Into p_rec.pa_remark_id;
152: Close C_Sel1;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: End pre_insert;
156: --
157: -- ----------------------------------------------------------------------------
158: -- |-----------------------------< post_insert >------------------------------|

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

190: --
191: l_proc varchar2(72) := g_package||'post_insert';
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: --
196: -- This is a hook point and the user hook for post_insert is called here.
197: --
198: begin

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

216: );
217: end;
218: -- End of API User Hook for post_insert.
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: End post_insert;
222: --
223: -- ----------------------------------------------------------------------------
224: -- |---------------------------------< ins >----------------------------------|

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

231: --
232: l_proc varchar2(72) := g_package||'ins';
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: -- Determine if the business process is to be validated.
238: --
239: If p_validate then

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

264: If p_validate then
265: Raise HR_Api.Validate_Enabled;
266: End If;
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: Exception
270: When HR_Api.Validate_Enabled Then
271: --
272: -- As the Validate_Enabled exception has been raised

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

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

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

328: --
329: p_pa_remark_id := l_rec.pa_remark_id;
330: p_object_version_number := l_rec.object_version_number;
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 10);
333: End ins;
334: --
335: end ghr_pre_ins;