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: per_ric_pkg.Chk_integrity (
56: p_entity_name=> 'PQH_TEMPLATES',

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

92: p_rec.legislation_code
93: );
94: --
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: pqh_tem_shd.constraint_error

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

154: --
155: Cursor C_Sel1 is select pqh_templates_s.nextval from sys.dual;
156: --
157: Begin
158: hr_utility.set_location('Entering:'||l_proc, 5);
159: --
160: --
161: -- Select the next sequence number
162: --

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

163: Open C_Sel1;
164: Fetch C_Sel1 Into p_rec.template_id;
165: Close C_Sel1;
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End pre_insert;
169: --
170: -- ----------------------------------------------------------------------------
171: -- |-----------------------------< post_insert >------------------------------|

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

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

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

241: --
242: -- End of API User Hook for post_insert.
243: --
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: End post_insert;
247: --
248: -- ----------------------------------------------------------------------------
249: -- |---------------------------------< ins >----------------------------------|

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

256: --
257: l_proc varchar2(72) := g_package||'ins';
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: -- Call the supporting insert validate operations
263: --
264: pqh_tem_bus.insert_validate(p_rec

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

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

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

335: --
336: p_template_id := l_rec.template_id;
337: p_object_version_number := l_rec.object_version_number;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End ins;
341: --
342: end pqh_tem_ins;