DBA Data[Home] [Help]

APPS.PQP_EXR_INS dependencies on HR_UTILITY

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

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

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

195:
196: --
197: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: Exception
201: When hr_api.check_integrity_violated Then
202: -- A check constraint has been violated
203: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status

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

263: --
264: Cursor C_Sel1 is select pqp_exception_reports_s.nextval from sys.dual;
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269: --
270: -- Select the next sequence number
271: --

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

272: Open C_Sel1;
273: Fetch C_Sel1 Into p_rec.exception_report_id;
274: Close C_Sel1;
275: --
276: hr_utility.set_location(' Leaving:'||l_proc, 10);
277: End pre_insert;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |-----------------------------< post_insert >------------------------------|

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

314: --
315: l_proc varchar2(72) := g_package||'post_insert';
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: begin
320: --
321: -- insert ownerships if applicable
322: create_app_ownerships('EXCEPTION_REPORT_ID', p_rec.exception_report_id);

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

362: ,p_hook_type => 'AI');
363: --
364: end;
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End post_insert;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |---------------------------------< ins >----------------------------------|

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

376: l_proc varchar2(72) := g_package||'ins';
377: --
378: Begin
379:
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: -- Call the supporting insert validate operations
383: --
384:

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

402: (p_rec
403: );
404: --
405: hr_multi_message.end_validation_set;
406: hr_utility.set_location('Leaving:'||l_proc, 20);
407: end ins;
408: --
409: -- ----------------------------------------------------------------------------
410: -- |---------------------------------< ins >----------------------------------|

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

429: l_rec pqp_exr_shd.g_rec_type;
430: l_proc varchar2(72) := g_package||'ins';
431: --
432: Begin
433: hr_utility.set_location('Entering:'||l_proc, 5);
434: --
435: -- Call conversion function to turn arguments into the
436: -- p_rec structure.
437: --

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

467: --
468: p_exception_report_id := l_rec.exception_report_id;
469: p_object_version_number := l_rec.object_version_number;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: End ins;
473: --
474: end pqp_exr_ins;