eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_OTP_INS dependencies on HR_UTILITY

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

79: l_last_updated_by ben_optip_f.last_updated_by%TYPE;
80: l_last_update_login ben_optip_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=

Line 104: hr_utility.set_location(l_proc, 10);

100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> hr_api.g_insert) then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --
108: Open C_Sel1;

Line 236: hr_utility.set_location(' Leaving:'||l_proc, 15);

232: ,l_last_update_login
233: );
234: --
235: ben_otp_shd.g_api_dml := false; -- Unset the api dml status
236: hr_utility.set_location(' Leaving:'||l_proc, 15);
237: --
238: Exception
239: When hr_api.check_integrity_violated Then
240: -- A check constraint has been violated

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

264: --
265: l_proc varchar2(72) := g_package||'insert_dml';
266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: --
270: ben_otp_ins.dt_insert_dml
271: (p_rec => p_rec
272: ,p_effective_date => p_effective_date

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

274: ,p_validation_start_date => p_validation_start_date
275: ,p_validation_end_date => p_validation_end_date
276: );
277: --
278: hr_utility.set_location(' Leaving:'||l_proc, 10);
279: End insert_dml;
280: --
281: -- ----------------------------------------------------------------------------
282: -- |------------------------------< pre_insert >------------------------------|

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

329: --
330: Cursor C_Sel1 is select ben_optip_s.nextval from sys.dual;
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: --
336: -- Select the next sequence number
337: --

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

339: Fetch C_Sel1 Into p_rec.optip_id;
340: Close C_Sel1;
341: --
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 10);
344: End pre_insert;
345: --
346: -- ----------------------------------------------------------------------------
347: -- |----------------------------< post_insert >-------------------------------|

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

385: --
386: l_proc varchar2(72) := g_package||'post_insert';
387: --
388: Begin
389: hr_utility.set_location('Entering:'||l_proc, 5);
390: begin
391: --
392: ben_otp_rki.after_insert
393: (p_effective_date

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

493: ,p_hook_type => 'AI');
494: --
495: end;
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 10);
498: End post_insert;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |-------------------------------< ins_lck >--------------------------------|

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

545: l_validation_start_date date;
546: l_validation_end_date date;
547: --
548: Begin
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Validate the datetrack mode mode getting the validation start
552: -- and end dates for the specified datetrack operation.
553: --

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

575: --
576: p_validation_start_date := l_validation_start_date;
577: p_validation_end_date := l_validation_end_date;
578: --
579: hr_utility.set_location(' Leaving:'||l_proc, 10);
580: --
581: End ins_lck;
582: --
583: -- ----------------------------------------------------------------------------

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

593: l_validation_start_date date;
594: l_validation_end_date date;
595: --
596: Begin
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: -- Call the lock operation
600: --
601: ben_otp_ins.ins_lck

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

645: ,p_validation_start_date => l_validation_start_date
646: ,p_validation_end_date => l_validation_end_date
647: );
648: --
649: hr_utility.set_location('Leaving:'||l_proc,10);
650: end ins;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------------< ins >----------------------------------|

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

702: l_rec ben_otp_shd.g_rec_type;
703: l_proc varchar2(72) := g_package||'ins';
704: --
705: Begin
706: hr_utility.set_location('Entering:'||l_proc, 5);
707: --
708: -- Call conversion function to turn arguments into the
709: -- p_rec structure.
710: --

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

771: p_effective_end_date := l_rec.effective_end_date;
772: p_object_version_number := l_rec.object_version_number;
773: --
774: --
775: hr_utility.set_location(' Leaving:'||l_proc, 10);
776: End ins;
777: --
778: end ben_otp_ins;