DBA Data[Home] [Help]

APPS.PER_ABV_INS dependencies on HR_UTILITY

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

80: l_last_update_login per_assignment_budget_values_f.last_update_login%TYPE;
81: l_value per_assignment_budget_values_f.value%TYPE;
82: --
83: Begin
84: hr_utility.set_location('Entering:'||l_proc, 5);
85: --
86: -- Set the effective start and end dates to the corresponding
87: -- validation start and end dates
88: --

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

92: -- If the datetrack_mode is not INSERT then we must populate the WHO
93: -- columns with the 'old' creation values and 'new' updated values.
94: --
95: If (p_datetrack_mode <> hr_api.g_insert) then
96: hr_utility.set_location(l_proc, 10);
97: --
98: -- Select the 'old' created values
99: --
100: Open C_Sel1;

Line 127: hr_utility.set_location(l_proc, 20);

123: p_rec.object_version_number := 1;
124:
125: -- Added the following code as a part of Bug 2172818 fix
126:
127: hr_utility.set_location(l_proc, 20);
128:
129: l_value := p_rec.value;
130:
131: -- Check whether the unit is a FTE

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

180: ,p_rec.object_version_number
181: );
182: --
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 15);
185: --
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated

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

212: --
213: l_proc varchar2(72) := g_package||'insert_dml';
214: --
215: Begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: per_abv_ins.dt_insert_dml
219: (p_rec => p_rec
220: ,p_effective_date => p_effective_date

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

222: ,p_validation_start_date => p_validation_start_date
223: ,p_validation_end_date => p_validation_end_date
224: );
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: End insert_dml;
228: --
229: -- ----------------------------------------------------------------------------
230: -- |------------------------------< pre_insert >------------------------------|

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

277: --
278: Cursor C_Sel1 is select per_assignment_budget_values_s.nextval from sys.dual;
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: --
284: -- Select the next sequence number
285: --

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

287: Fetch C_Sel1 Into p_rec.assignment_budget_value_id;
288: Close C_Sel1;
289: --
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 10);
292: End pre_insert;
293: --
294: -- ----------------------------------------------------------------------------
295: -- |----------------------------< post_insert >-------------------------------|

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

333: --
334: l_proc varchar2(72) := g_package||'post_insert';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: begin
339: --
340: per_abv_rki.after_insert
341: (p_effective_date

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

379: ,p_hook_type => 'AI');
380: --
381: end;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: End post_insert;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |-------------------------------< ins_lck >--------------------------------|

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

431: l_validation_start_date date;
432: l_validation_end_date date;
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: -- Validate the datetrack mode mode getting the validation start
438: -- and end dates for the specified datetrack operation.
439: --

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

455: --
456: p_validation_start_date := l_validation_start_date;
457: p_validation_end_date := l_validation_end_date;
458: --
459: hr_utility.set_location(' Leaving:'||l_proc, 10);
460: --
461: End ins_lck;
462: --
463: -- ----------------------------------------------------------------------------

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

473: l_validation_start_date date;
474: l_validation_end_date date;
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: -- Call the lock operation
480: --
481: per_abv_ins.ins_lck

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

525: ,p_validation_start_date => l_validation_start_date
526: ,p_validation_end_date => l_validation_end_date
527: );
528: --
529: hr_utility.set_location('Leaving:'||l_proc,10);
530: end ins;
531: --
532: -- ----------------------------------------------------------------------------
533: -- |---------------------------------< ins >----------------------------------|

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

551: l_rec per_abv_shd.g_rec_type;
552: l_proc varchar2(72) := g_package||'ins';
553: --
554: Begin
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: --
557: -- Call conversion function to turn arguments into the
558: -- p_rec structure.
559: --

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

588: p_effective_start_date := l_rec.effective_start_date;
589: p_effective_end_date := l_rec.effective_end_date;
590: --
591: --
592: hr_utility.set_location(' Leaving:'||l_proc, 10);
593: End ins;
594: --
595: end per_abv_ins;