DBA Data[Home] [Help]

APPS.PQP_SHP_INS dependencies on HR_UTILITY

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

56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: pqp_shp_shd.g_api_dml := true; -- Set the api dml status
64: --

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

184: );
185: --
186: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status

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

252: --
253: Cursor C_Sel1 is select pqp_service_history_periods_s.nextval from sys.dual;
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: --
259: -- Select the next sequence number
260: --

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

261: Open C_Sel1;
262: Fetch C_Sel1 Into p_rec.service_history_period_id;
263: Close C_Sel1;
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End pre_insert;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |-----------------------------< post_insert >------------------------------|

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

304: --
305: l_proc varchar2(72) := g_package||'post_insert';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: begin
310: --
311: pqp_shp_rki.after_insert
312: (

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

435: ,p_hook_type => 'AI');
436: --
437: end;
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: End post_insert;
441: --
442: -- ----------------------------------------------------------------------------
443: -- |---------------------------------< ins >----------------------------------|

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

449: --
450: l_proc varchar2(72) := g_package||'ins';
451: --
452: Begin
453: hr_utility.set_location('Entering:'||l_proc, 5);
454: --
455: -- Call the supporting insert validate operations
456: --
457: pqp_shp_bus.insert_validate

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

473: (
474: p_rec
475: );
476: --
477: hr_utility.set_location('Leaving:'||l_proc, 20);
478: end ins;
479: --
480: -- ----------------------------------------------------------------------------
481: -- |---------------------------------< ins >----------------------------------|

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

543: l_rec pqp_shp_shd.g_rec_type;
544: l_proc varchar2(72) := g_package||'ins';
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Call conversion function to turn arguments into the
550: -- p_rec structure.
551: --

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

623: --
624: p_service_history_period_id := l_rec.service_history_period_id;
625: p_object_version_number := l_rec.object_version_number;
626: --
627: hr_utility.set_location(' Leaving:'||l_proc, 10);
628: End ins;
629: --
630: end pqp_shp_ins;