DBA Data[Home] [Help]

APPS.GHR_PDH_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:
56: -- Insert the row into: ghr_pd_routing_history

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

103: p_rec.item_key
104: );
105:
106: --
107: hr_utility.set_location(' Leaving:'||l_proc, 10);
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: ghr_pdh_shd.constraint_error

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

166: --
167: Cursor C_Sel1 is select ghr_pd_routing_history_s.nextval from sys.dual;
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: --
172: --
173: -- Select the next sequence number
174: --

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

174: --
175: open C_Sel1;
176: Fetch C_Sel1 Into p_rec.pd_routing_history_id;
177: Close C_Sel1;
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: End pre_insert;
180:
181:
182:

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

217: --
218: l_proc varchar2(72) := g_package||'post_insert';
219: --
220: Begin
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: -- This is a hook point and the user hook for post_insert is called here.
224: --
225: begin

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

254: );
255: end;
256: -- End of API User Hook for post_insert.
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: End post_insert;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |---------------------------------< ins >----------------------------------|

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

269: --
270: l_proc varchar2(72) := g_package||'ins';
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: -- Determine if the business process is to be validated.
276: --
277: If p_validate then

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

303: If p_validate then
304: Raise HR_Api.Validate_Enabled;
305: End If;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: Exception
309: When HR_Api.Validate_Enabled Then
310: --
311: -- As the Validate_Enabled exception has been raised

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

346: l_rec ghr_pdh_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'ins';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- Call conversion function to turn arguments into the
353: -- p_rec structure.
354: --

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

389: --
390: p_pd_routing_history_id := l_rec.pd_routing_history_id;
391: p_object_version_number := l_rec.object_version_number;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: End ins;
395: --
396: end ghr_pdh_ins;