DBA Data[Home] [Help]

APPS.PAY_GRR_UPD dependencies on HR_UTILITY

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

63: --
64: l_proc varchar2(72) := g_package||'dt_update_dml';
65: --
66: Begin
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: --
69: If (p_datetrack_mode = 'CORRECTION') then
70: hr_utility.set_location(l_proc, 10);
71: --

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

66: Begin
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: --
69: If (p_datetrack_mode = 'CORRECTION') then
70: hr_utility.set_location(l_proc, 10);
71: --
72: -- Because we are updating a row we must get the next object
73: -- version number.
74: --

Line 83: hr_utility.set_location(l_proc, 12);

79: p_base_key_value => p_rec.grade_rule_id);
80: --
81: pay_grr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: hr_utility.set_location(l_proc, 12);
84: --
85: -- Update the pay_grade_rules_f Row
86: --
87: update pay_grade_rules_f

Line 104: hr_utility.set_location(l_proc, 14);

100: where grade_rule_id = p_rec.grade_rule_id
101: and effective_start_date = p_validation_start_date
102: and effective_end_date = p_validation_end_date;
103: --
104: hr_utility.set_location(l_proc, 14);
105: --
106: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: -- Set the effective start and end dates

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

110: p_rec.effective_start_date := p_validation_start_date;
111: p_rec.effective_end_date := p_validation_end_date;
112: End If;
113: --
114: hr_utility.set_location(' Leaving:'||l_proc, 15);
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pay_grr_shd.g_api_dml := false; -- Unset the api dml status

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

168: --
169: l_proc varchar2(72) := g_package||'update_dml';
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: dt_update_dml(p_rec => p_rec,
175: p_effective_date => p_effective_date,
176: p_datetrack_mode => p_datetrack_mode,

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

176: p_datetrack_mode => p_datetrack_mode,
177: p_validation_start_date => p_validation_start_date,
178: p_validation_end_date => p_validation_end_date);
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: End update_dml;
182: --
183: -- ----------------------------------------------------------------------------
184: -- |----------------------------< dt_pre_update >-----------------------------|

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

233: l_proc varchar2(72) := g_package||'dt_pre_update';
234: l_dummy_version_number number;
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: If (p_datetrack_mode <> 'CORRECTION') then
239: hr_utility.set_location(l_proc, 10);
240: --
241: -- Update the current effective end date

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

235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: If (p_datetrack_mode <> 'CORRECTION') then
239: hr_utility.set_location(l_proc, 10);
240: --
241: -- Update the current effective end date
242: --
243: pay_grr_shd.upd_effective_end_date

Line 252: hr_utility.set_location(l_proc, 15);

248: p_validation_end_date => p_validation_end_date,
249: p_object_version_number => l_dummy_version_number);
250: --
251: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
252: hr_utility.set_location(l_proc, 15);
253: --
254: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
255: -- delete any future rows
256: --

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

260: p_datetrack_mode => p_datetrack_mode,
261: p_validation_start_date => p_validation_start_date,
262: p_validation_end_date => p_validation_end_date);
263: End If;
264: hr_utility.set_location(l_proc, 20);
265: --
266: -- We must now insert the updated row
267: --
268: pay_grr_ins.insert_dml

Line 275: hr_utility.set_location(' Leaving:'||l_proc, 20);

271: p_datetrack_mode => p_datetrack_mode,
272: p_validation_start_date => p_validation_start_date,
273: p_validation_end_date => p_validation_end_date);
274: End If;
275: hr_utility.set_location(' Leaving:'||l_proc, 20);
276: End dt_pre_update;
277: --
278: -- ----------------------------------------------------------------------------
279: -- |------------------------------< pre_update >------------------------------|

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

317: --
318: l_proc varchar2(72) := g_package||'pre_update';
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: dt_pre_update
324: (p_rec => p_rec,
325: p_effective_date => p_effective_date,

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

326: p_datetrack_mode => p_datetrack_mode,
327: p_validation_start_date => p_validation_start_date,
328: p_validation_end_date => p_validation_end_date);
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: End pre_update;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |-----------------------------< post_update >------------------------------|

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

371: --
372: l_proc varchar2(72) := g_package||'post_update';
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: --
377: hr_utility.set_location(' Leaving:'||l_proc, 10);
378: End post_update;
379: --

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

373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: --
377: hr_utility.set_location(' Leaving:'||l_proc, 10);
378: End post_update;
379: --
380: -- ----------------------------------------------------------------------------
381: -- |-----------------------------< convert_defs >-----------------------------|

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

425: l_proc varchar2(72) := g_package||'convert_defs';
426: --
427: Begin
428: --
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: --
431: -- We must now examine each argument value in the
432: -- p_rec plsql record structure
433: -- to see if a system default is being used. If a system default

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

489: p_rec.currency_code :=
490: pay_grr_shd.g_old_rec.currency_code;
491: End If;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: --
495: End convert_defs;
496: --
497: -- ----------------------------------------------------------------------------

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

509: l_validation_start_date date;
510: l_validation_end_date date;
511: --
512: Begin
513: hr_utility.set_location('Entering:'||l_proc, 5);
514: --
515: -- Ensure that the DateTrack update mode is valid
516: --
517: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);

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

582: If p_validate then
583: Raise HR_Api.Validate_Enabled;
584: End If;
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 10);
587: Exception
588: When HR_Api.Validate_Enabled Then
589: --
590: -- As the Validate_Enabled exception has been raised

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

619: l_rec pay_grr_shd.g_rec_type;
620: l_proc varchar2(72) := g_package||'upd';
621: --
622: Begin
623: hr_utility.set_location('Entering:'||l_proc, 5);
624: --
625: -- Call conversion function to turn arguments into the
626: -- l_rec structure.
627: --

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

657: p_effective_start_date := l_rec.effective_start_date;
658: p_effective_end_date := l_rec.effective_end_date;
659: --
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 10);
662: End upd;
663: --
664: end pay_grr_upd;