DBA Data[Home] [Help]

APPS.PQH_RHT_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: pqh_routing_history

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

106: p_rec.object_version_number
107: );
108: --
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pqh_rht_shd.constraint_error

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

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

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

177: Open C_Sel1;
178: Fetch C_Sel1 Into p_rec.routing_history_id;
179: Close C_Sel1;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: End pre_insert;
183: --
184: -- ----------------------------------------------------------------------------
185: -- |-----------------------------< post_insert >------------------------------|

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

221: --
222: --
223:
224: Begin
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: --
228: -- Start of API User Hook for post_insert.
229: --

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

270: --
271: -- End of API User Hook for post_insert.
272: --
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: End post_insert;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |---------------------------------< ins >----------------------------------|

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

285: --
286: l_proc varchar2(72) := g_package||'ins';
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Call the supporting insert validate operations
292: --
293: pqh_rht_bus.insert_validate(p_rec

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

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

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

390: --
391: p_routing_history_id := l_rec.routing_history_id;
392: p_object_version_number := l_rec.object_version_number;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: End ins;
396: --
397: end pqh_rht_ins;