DBA Data[Home] [Help]

APPS.PAY_IPD_INS dependencies on HR_UTILITY

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

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

262: --13359423
263: );
264: --
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 15);
267: --
268: Exception
269: When hr_api.check_integrity_violated Then
270: -- A check constraint has been violated

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

294: --
295: l_proc varchar2(72) := g_package||'insert_dml';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: pay_ipd_ins.dt_insert_dml
301: (p_rec => p_rec
302: ,p_effective_date => p_effective_date

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

304: ,p_validation_start_date => p_validation_start_date
305: ,p_validation_end_date => p_validation_end_date
306: );
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 10);
309: End insert_dml;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |------------------------------< pre_insert >------------------------------|

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

359: --
360: Cursor C_Sel1 is select pay_ie_paye_details_s.nextval from sys.dual;
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: --
366: -- Select the next sequence number
367: --

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

369: Fetch C_Sel1 Into p_rec.paye_details_id;
370: Close C_Sel1;
371: --
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: End pre_insert;
375: --
376: -- ----------------------------------------------------------------------------
377: -- |----------------------------< post_insert >-------------------------------|

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

415: --
416: l_proc varchar2(72) := g_package||'post_insert';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: begin
421: --
422: pay_ipd_rki.after_insert
423: (p_effective_date

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

477: ,p_hook_type => 'AI');
478: --
479: end;
480: --
481: hr_utility.set_location(' Leaving:'||l_proc, 10);
482: End post_insert;
483: --
484: -- ----------------------------------------------------------------------------
485: -- |-------------------------------< ins_lck >--------------------------------|

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

529: l_validation_start_date date;
530: l_validation_end_date date;
531: --
532: Begin
533: hr_utility.set_location('Entering:'||l_proc, 5);
534: --
535: -- Validate the datetrack mode mode getting the validation start
536: -- and end dates for the specified datetrack operation.
537: --

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

553: --
554: p_validation_start_date := l_validation_start_date;
555: p_validation_end_date := l_validation_end_date;
556: --
557: hr_utility.set_location(' Leaving:'||l_proc, 10);
558: --
559: End ins_lck;
560: --
561: -- ----------------------------------------------------------------------------

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

571: l_validation_start_date date;
572: l_validation_end_date date;
573: --
574: Begin
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: -- Call the lock operation
578: --
579: pay_ipd_ins.ins_lck

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

623: ,p_validation_start_date => l_validation_start_date
624: ,p_validation_end_date => l_validation_end_date
625: );
626: --
627: hr_utility.set_location('Leaving:'||l_proc,10);
628: end ins;
629: --
630: -- ----------------------------------------------------------------------------
631: -- |---------------------------------< ins >----------------------------------|

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

695: l_rec pay_ipd_shd.g_rec_type;
696: l_proc varchar2(72) := g_package||'ins';
697: --
698: Begin
699: hr_utility.set_location('Entering:'||l_proc, 5);
700: --
701: -- Call conversion function to turn arguments into the
702: -- p_rec structure.
703: --

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

779: p_effective_end_date := l_rec.effective_end_date;
780: p_object_version_number := l_rec.object_version_number;
781: --
782: --
783: hr_utility.set_location(' Leaving:'||l_proc, 10);
784: End ins;
785: --
786: end pay_ipd_ins;