DBA Data[Home] [Help]

APPS.PQH_TEM_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_templates

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

84: p_rec.legislation_code
85: );
86: --
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: pqh_tem_shd.constraint_error

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

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

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

155: Open C_Sel1;
156: Fetch C_Sel1 Into p_rec.template_id;
157: Close C_Sel1;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: End pre_insert;
161: --
162: -- ----------------------------------------------------------------------------
163: -- |-----------------------------< post_insert >------------------------------|

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

196: --
197: l_proc varchar2(72) := g_package||'post_insert';
198: --
199: Begin
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: --
203: -- Start of API User Hook for post_insert.
204: --

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

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

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

248: --
249: l_proc varchar2(72) := g_package||'ins';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- Call the supporting insert validate operations
255: --
256: pqh_tem_bus.insert_validate(p_rec

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

293: l_rec pqh_tem_shd.g_rec_type;
294: l_proc varchar2(72) := g_package||'ins';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- Call conversion function to turn arguments into the
300: -- p_rec structure.
301: --

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

327: --
328: p_template_id := l_rec.template_id;
329: p_object_version_number := l_rec.object_version_number;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: End ins;
333: --
334: end pqh_tem_ins;