DBA Data[Home] [Help]

APPS.PAY_ELE_INS dependencies on HR_UTILITY

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

79: l_last_updated_by pay_element_entries_f.last_updated_by%TYPE;
80: l_last_update_login pay_element_entries_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 238: hr_utility.set_location(' Leaving:'||l_proc, 15);

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

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

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

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

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

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

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

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

350: ,p_source_table_name => 'PAY_ELEMENT_ENTRIES_F'
351: ,p_comment_text => p_rec.comments
352: );
353: End If;
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: End pre_insert;
356: --
357: -- ----------------------------------------------------------------------------
358: -- |----------------------------< post_insert >-------------------------------|

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

397: l_proc varchar2(72) := g_package||'post_insert';
398: --
399:
400: Begin
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: begin
403: --
404: pay_ele_rki.after_insert
405: (p_effective_date

Line 546: hr_utility.set_location('Leaving:'||l_proc, 900);

542: --
543: -- 11-NOV-03
544: -- Hard calls to DYT_PKG removed, perfomed in pyentapi.pkb
545:
546: hr_utility.set_location('Leaving:'||l_proc, 900);
547: --
548: End post_insert;
549: --
550: -- ----------------------------------------------------------------------------

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

595: l_validation_start_date date;
596: l_validation_end_date date;
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Validate the datetrack mode mode getting the validation start
602: -- and end dates for the specified datetrack operation.
603: --

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

622: --
623: p_validation_start_date := l_validation_start_date;
624: p_validation_end_date := l_validation_end_date;
625: --
626: hr_utility.set_location(' Leaving:'||l_proc, 10);
627: --
628: End ins_lck;
629: --
630: -- ----------------------------------------------------------------------------

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

640: l_validation_start_date date;
641: l_validation_end_date date;
642: --
643: Begin
644: hr_utility.set_location('Entering:'||l_proc, 5);
645: --
646: -- Call the lock operation
647: --
648: pay_ele_ins.ins_lck

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

692: ,p_validation_start_date => l_validation_start_date
693: ,p_validation_end_date => l_validation_end_date
694: );
695: --
696: hr_utility.set_location('Leaving:'||l_proc,10);
697: end ins;
698: --
699: -- ----------------------------------------------------------------------------
700: -- |---------------------------------< ins >----------------------------------|

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

750: l_proc varchar2(72) := g_package||'ins';
751: l_ele_type_id pay_element_types_f.element_type_id%type;
752: --
753: Begin
754: hr_utility.set_location('Entering:'||l_proc, 5);
755: --
756: -- First derive the element_type_id
757: --
758: l_ele_type_id := pay_ele_bus.derive_element_type_id

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

827: p_effective_end_date := l_rec.effective_end_date;
828: p_object_version_number := l_rec.object_version_number;
829: p_comment_id := l_rec.comment_id;
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: End ins;
833: --
834: end pay_ele_ins;