DBA Data[Home] [Help]

APPS.PAY_ITR_INS dependencies on HR_UTILITY

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

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

168: ,l_last_update_login
169: );
170: --
171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 15);
173: --
174: Exception
175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated

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

200: --
201: l_proc varchar2(72) := g_package||'insert_dml';
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: pay_itr_ins.dt_insert_dml
207: (p_rec => p_rec
208: ,p_effective_date => p_effective_date

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

210: ,p_validation_start_date => p_validation_start_date
211: ,p_validation_end_date => p_validation_end_date
212: );
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End insert_dml;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |------------------------------< pre_insert >------------------------------|

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

265: --
266: Cursor C_Sel1 is select pay_iterative_rules_s.nextval from sys.dual;
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: --
272: -- Select the next sequence number
273: --

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

275: Fetch C_Sel1 Into p_rec.iterative_rule_id;
276: Close C_Sel1;
277: --
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: End pre_insert;
281: --
282: -- ----------------------------------------------------------------------------
283: -- |----------------------------< post_insert >-------------------------------|

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

321: --
322: l_proc varchar2(72) := g_package||'post_insert';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: begin
327: --
328: pay_itr_rki.after_insert
329: (p_effective_date

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

365: ,p_hook_type => 'AI');
366: --
367: end;
368: --
369: hr_utility.set_location(' Leaving:'||l_proc, 10);
370: End post_insert;
371: --
372: -- ----------------------------------------------------------------------------
373: -- |-------------------------------< ins_lck >--------------------------------|

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

417: l_validation_start_date date;
418: l_validation_end_date date;
419: --
420: Begin
421: hr_utility.set_location('Entering:'||l_proc, 5);
422: --
423: -- Validate the datetrack mode mode getting the validation start
424: -- and end dates for the specified datetrack operation.
425: --

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

438: --
439: p_validation_start_date := l_validation_start_date;
440: p_validation_end_date := l_validation_end_date;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 10);
443: --
444: End ins_lck;
445: --
446: -- ----------------------------------------------------------------------------

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

456: l_validation_start_date date;
457: l_validation_end_date date;
458: --
459: Begin
460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: -- Call the lock operation
463: --
464: pay_itr_ins.ins_lck

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

508: ,p_validation_start_date => l_validation_start_date
509: ,p_validation_end_date => l_validation_end_date
510: );
511: --
512: hr_utility.set_location('Leaving:'||l_proc,10);
513: end ins;
514: --
515: -- ----------------------------------------------------------------------------
516: -- |---------------------------------< ins >----------------------------------|

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

533: l_rec pay_itr_shd.g_rec_type;
534: l_proc varchar2(72) := g_package||'ins';
535: --
536: Begin
537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: -- Call conversion function to turn arguments into the
540: -- p_rec structure.
541: --

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

570: p_effective_end_date := l_rec.effective_end_date;
571: p_object_version_number := l_rec.object_version_number;
572: --
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: End ins;
576: --
577: end pay_itr_ins;