DBA Data[Home] [Help]

APPS.PQP_ERG_INS dependencies on HR_UTILITY

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

104: --
105: l_proc varchar2(72) := g_package||'insert_dml';
106: --
107: Begin
108: hr_utility.set_location('Entering:'||l_proc, 5);
109: p_rec.object_version_number := 1; -- Initialise the object version
110: --
111: pqp_erg_shd.g_api_dml := true; -- Set the api dml status
112: --

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

136: );
137: --
138: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: pqp_erg_shd.g_api_dml := false; -- Unset the api dml status

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

204: --
205: Cursor C_Sel1 is select pqp_exception_report_groups_s.nextval from sys.dual;
206: --
207: Begin
208: hr_utility.set_location('Entering:'||l_proc, 5);
209: --
210: --
211: -- Select the next sequence number
212: --

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

213: Open C_Sel1;
214: Fetch C_Sel1 Into p_rec.exception_group_id;
215: Close C_Sel1;
216: --
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: End pre_insert;
219: --
220: -- ----------------------------------------------------------------------------
221: -- |-----------------------------< post_insert >------------------------------|

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

255: --
256: l_proc varchar2(72) := g_package||'post_insert';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: begin
261: --
262: pqp_erg_rki.after_insert (
263: p_exception_group_id

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

287: ,p_hook_type => 'AI');
288: --
289: end;
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 10);
292: End post_insert;
293: --
294: -- ----------------------------------------------------------------------------
295: -- |---------------------------------< ins >----------------------------------|

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

300: --
301: l_proc varchar2(72) := g_package||'ins';
302: --
303: Begin
304: hr_utility.set_location('Entering:'||l_proc, 5);
305: --
306: -- Call the supporting insert validate operations
307: --
308: pqp_erg_bus.insert_validate

Line 326: hr_utility.set_location('Leaving:'||l_proc, 20);

322: pqp_erg_ins.post_insert
323: (p_rec
324: );
325: --
326: hr_utility.set_location('Leaving:'||l_proc, 20);
327: end ins;
328: --
329: -- ----------------------------------------------------------------------------
330: -- |---------------------------------< ins >----------------------------------|

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

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

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

375: --
376: p_exception_group_id := l_rec.exception_group_id;
377: p_object_version_number := l_rec.object_version_number;
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380: End ins;
381: --
382: end pqp_erg_ins;