DBA Data[Home] [Help]

APPS.BEN_GOS_INS dependencies on HR_UTILITY

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

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

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

142: );
143: --
144: ben_gos_shd.g_api_dml := false; -- Unset the api dml status
145: --
146: hr_utility.set_location(' Leaving:'||l_proc, 10);
147: Exception
148: When hr_api.check_integrity_violated Then
149: -- A check constraint has been violated
150: ben_gos_shd.g_api_dml := false; -- Unset the api dml status

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

208: --
209: Cursor C_Sel1 is select ben_gd_or_svc_typ_s.nextval from sys.dual;
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: --
215: -- Select the next sequence number
216: --

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

217: Open C_Sel1;
218: Fetch C_Sel1 Into p_rec.gd_or_svc_typ_id;
219: Close C_Sel1;
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End pre_insert;
223: --
224: -- ----------------------------------------------------------------------------
225: -- |-----------------------------< post_insert >------------------------------|

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

258: --
259: l_proc varchar2(72) := g_package||'post_insert';
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: --
265: -- Start of API User Hook for post_insert.
266: --

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

320: --
321: -- End of API User Hook for post_insert.
322: --
323: --
324: hr_utility.set_location(' Leaving:'||l_proc, 10);
325: End post_insert;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |---------------------------------< ins >----------------------------------|

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

335: --
336: l_proc varchar2(72) := g_package||'ins';
337: --
338: Begin
339: hr_utility.set_location('Entering:'||l_proc, 5);
340: --
341: -- Call the supporting insert validate operations
342: --
343: ben_gos_bus.insert_validate(p_rec

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

405: l_rec ben_gos_shd.g_rec_type;
406: l_proc varchar2(72) := g_package||'ins';
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: -- Call conversion function to turn arguments into the
412: -- p_rec structure.
413: --

Line 459: hr_utility.set_location('In:'||l_proc, 7);

455: --
456: -- Having converted the arguments into the ben_gos_rec
457: -- plsql record structure we call the corresponding record business process.
458: --
459: hr_utility.set_location('In:'||l_proc, 7);
460: ins(
461: p_effective_date,l_rec);
462: --
463: -- As the primary key argument(s)

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

465: --
466: p_gd_or_svc_typ_id := l_rec.gd_or_svc_typ_id;
467: p_object_version_number := l_rec.object_version_number;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 10);
470: End ins;
471: --
472: end ben_gos_ins;