DBA Data[Home] [Help]

APPS.BEN_PQC_INS dependencies on HR_UTILITY

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

79: l_last_updated_by ben_prtt_rmt_rqst_ctfn_prvdd_f.last_updated_by%TYPE;
80: l_last_update_login ben_prtt_rmt_rqst_ctfn_prvdd_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_pqc_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_pqc_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_prtt_rmt_rqst_ctfn_prvdd_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.prtt_rmt_rqst_ctfn_prvdd_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_pqc_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 576: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

590: l_validation_start_date date;
591: l_validation_end_date date;
592: --
593: Begin
594: hr_utility.set_location('Entering:'||l_proc, 5);
595: --
596: -- Call the lock operation
597: --
598: ben_pqc_ins.ins_lck

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

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

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

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

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

768: p_effective_end_date := l_rec.effective_end_date;
769: p_object_version_number := l_rec.object_version_number;
770: --
771: --
772: hr_utility.set_location(' Leaving:'||l_proc, 10);
773: End ins;
774: --
775: end ben_pqc_ins;