DBA Data[Home] [Help]

APPS.PAY_ETU_INS dependencies on HR_UTILITY

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

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

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

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

251: --
252: l_proc varchar2(72) := g_package||'insert_dml';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: pay_etu_ins.dt_insert_dml
258: (p_rec => p_rec
259: ,p_effective_date => p_effective_date

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

261: ,p_validation_start_date => p_validation_start_date
262: ,p_validation_end_date => p_validation_end_date
263: );
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End insert_dml;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |------------------------------< pre_insert >------------------------------|

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

316: --
317: Cursor C_Sel1 is select pay_element_type_usages_s.nextval from sys.dual;
318: --
319: Begin
320: hr_utility.set_location('Entering:'||l_proc, 5);
321: --
322: --
323: -- Select the next sequence number
324: --

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

326: Fetch C_Sel1 Into p_rec.element_type_usage_id;
327: Close C_Sel1;
328: --
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: End pre_insert;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |----------------------------< post_insert >-------------------------------|

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

372: --
373: l_proc varchar2(72) := g_package||'post_insert';
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: begin
378: --
379: -- insert ownerships if applicable
380: --

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

418: ,p_hook_type => 'AI');
419: --
420: end;
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 10);
423: End post_insert;
424: --
425: -- ----------------------------------------------------------------------------
426: -- |-------------------------------< ins_lck >--------------------------------|

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

470: l_validation_start_date date;
471: l_validation_end_date date;
472: --
473: Begin
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: -- Validate the datetrack mode mode getting the validation start
477: -- and end dates for the specified datetrack operation.
478: --

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

497: --
498: p_validation_start_date := l_validation_start_date;
499: p_validation_end_date := l_validation_end_date;
500: --
501: hr_utility.set_location(' Leaving:'||l_proc, 10);
502: --
503: End ins_lck;
504: --
505: -- ----------------------------------------------------------------------------

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

515: l_validation_start_date date;
516: l_validation_end_date date;
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520: --
521: -- Call the lock operation
522: --
523: pay_etu_ins.ins_lck

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

567: ,p_validation_start_date => l_validation_start_date
568: ,p_validation_end_date => l_validation_end_date
569: );
570: --
571: hr_utility.set_location('Leaving:'||l_proc,10);
572: end ins;
573: --
574: -- ----------------------------------------------------------------------------
575: -- |---------------------------------< ins >----------------------------------|

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

591: l_rec pay_etu_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'ins';
593: --
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);
596: --
597: -- Call conversion function to turn arguments into the
598: -- p_rec structure.
599: --

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

627: p_effective_end_date := l_rec.effective_end_date;
628: p_object_version_number := l_rec.object_version_number;
629: --
630: --
631: hr_utility.set_location(' Leaving:'||l_proc, 10);
632: End ins;
633: --
634: end pay_etu_ins;