DBA Data[Home] [Help]

APPS.PER_PER_UPD dependencies on HR_UTILITY

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

73: l_person per_all_people_f%rowtype;
74: --
75: --
76: Begin
77: hr_utility.set_location('Entering:'||l_proc, 5);
78: --
79: If (p_datetrack_mode = 'CORRECTION') then
80: hr_utility.set_location(l_proc, 10);
81: --

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

76: Begin
77: hr_utility.set_location('Entering:'||l_proc, 5);
78: --
79: If (p_datetrack_mode = 'CORRECTION') then
80: hr_utility.set_location(l_proc, 10);
81: --
82: -- Because we are updating a row we must get the next object
83: -- version number.
84: --

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

271: p_rec.effective_start_date := p_validation_start_date;
272: p_rec.effective_end_date := p_validation_end_date;
273: End If;
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 15);
276: Exception
277: When hr_api.check_integrity_violated Then
278: -- A check constraint has been violated
279: per_per_shd.g_api_dml := false; -- Unset the api dml status

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

329: --
330: l_proc varchar2(72) := g_package||'update_dml';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: dt_update_dml(p_rec => p_rec,
336: p_effective_date => p_effective_date,
337: p_datetrack_mode => p_datetrack_mode,

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

337: p_datetrack_mode => p_datetrack_mode,
338: p_validation_start_date => p_validation_start_date,
339: p_validation_end_date => p_validation_end_date);
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 10);
342: End update_dml;
343: --
344: -- ----------------------------------------------------------------------------
345: -- |----------------------------< dt_pre_update >-----------------------------|

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

394: l_proc varchar2(72) := g_package||'dt_pre_update';
395: l_dummy_version_number number;
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: If (p_datetrack_mode <> 'CORRECTION') then
400: hr_utility.set_location(l_proc, 10);
401: --
402: -- Update the current effective end date

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

396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: If (p_datetrack_mode <> 'CORRECTION') then
400: hr_utility.set_location(l_proc, 10);
401: --
402: -- Update the current effective end date
403: --
404: per_per_shd.upd_effective_end_date

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

409: p_validation_end_date => p_validation_end_date,
410: p_object_version_number => l_dummy_version_number);
411: --
412: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
413: hr_utility.set_location(l_proc, 15);
414: --
415: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
416: -- delete any future rows
417: --

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

421: p_datetrack_mode => p_datetrack_mode,
422: p_validation_start_date => p_validation_start_date,
423: p_validation_end_date => p_validation_end_date);
424: End If;
425: hr_utility.set_location(l_proc, 20);
426: --
427: -- We must now insert the updated row
428: --
429: per_per_ins.insert_dml

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

432: p_datetrack_mode => p_datetrack_mode,
433: p_validation_start_date => p_validation_start_date,
434: p_validation_end_date => p_validation_end_date);
435: End If;
436: hr_utility.set_location(' Leaving:'||l_proc, 20);
437: End dt_pre_update;
438: --
439: -- ----------------------------------------------------------------------------
440: -- |------------------------------< pre_update >------------------------------|

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

495: and p_effective_date -1 between
496: effective_start_date and effective_end_date;
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: --
502: -- Insert the comment text if comments exist
503: --

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

597: ,p_attribute29 => p_rec.attribute29
598: ,p_attribute30 => p_rec.attribute30
599: );
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: --
603: End pre_update;
604: --
605: -- ----------------------------------------------------------------------------

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

654: and effective_end_date = p_rec.effective_end_date;
655: l_per_rec per_all_people_f%rowtype;
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: --
660: -- Start of API User Hook for post_update.
661: begin
662: per_per_rku.after_update

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

1115: );
1116: end;
1117: -- End of API User Hook for post_update.
1118: --
1119: hr_utility.set_location(' Leaving:'||l_proc, 10);
1120: --
1121: -- Start of HR/WF Synchronization
1122: --
1123: open l_per_cur;

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

1179: l_proc varchar2(72) := g_package||'convert_defs';
1180: --
1181: Begin
1182: --
1183: hr_utility.set_location('Entering:'||l_proc, 5);
1184: --
1185: -- We must now examine each argument value in the
1186: -- p_rec plsql record structure
1187: -- to see if a system default is being used. If a system default

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

1698: End If;
1699: --
1700: -- Return the plsql record structure.
1701: --
1702: hr_utility.set_location(' Leaving:'||l_proc, 10);
1703: --
1704: End convert_defs;
1705: --
1706: -- ----------------------------------------------------------------------------

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

1724: l_dob_null_warning boolean;
1725: l_orig_hire_warning boolean;
1726: --
1727: Begin
1728: hr_utility.set_location('Entering:'||l_proc, 5);
1729: --
1730: -- Ensure that the DateTrack update mode is valid
1731: --
1732: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);

Line 1818: hr_utility.set_location(l_proc,990);

1814: p_dob_null_warning := l_dob_null_warning;
1815: p_orig_hire_warning := l_orig_hire_warning;
1816: --
1817: if l_name_combination_warning = FALSE then
1818: hr_utility.set_location(l_proc,990);
1819: elsif l_name_combination_warning = TRUE then
1820: hr_utility.set_location(l_proc,991);
1821: else
1822: hr_utility.set_location(l_proc,992);

Line 1820: hr_utility.set_location(l_proc,991);

1816: --
1817: if l_name_combination_warning = FALSE then
1818: hr_utility.set_location(l_proc,990);
1819: elsif l_name_combination_warning = TRUE then
1820: hr_utility.set_location(l_proc,991);
1821: else
1822: hr_utility.set_location(l_proc,992);
1823: end if;
1824: --

Line 1822: hr_utility.set_location(l_proc,992);

1818: hr_utility.set_location(l_proc,990);
1819: elsif l_name_combination_warning = TRUE then
1820: hr_utility.set_location(l_proc,991);
1821: else
1822: hr_utility.set_location(l_proc,992);
1823: end if;
1824: --
1825: if l_orig_hire_warning = FALSE then
1826: hr_utility.set_location(l_proc,993);

Line 1826: hr_utility.set_location(l_proc,993);

1822: hr_utility.set_location(l_proc,992);
1823: end if;
1824: --
1825: if l_orig_hire_warning = FALSE then
1826: hr_utility.set_location(l_proc,993);
1827: elsif l_orig_hire_warning = TRUE then
1828: hr_utility.set_location(l_proc,994);
1829: else hr_utility.set_location(l_proc,995);
1830: end if;

Line 1828: hr_utility.set_location(l_proc,994);

1824: --
1825: if l_orig_hire_warning = FALSE then
1826: hr_utility.set_location(l_proc,993);
1827: elsif l_orig_hire_warning = TRUE then
1828: hr_utility.set_location(l_proc,994);
1829: else hr_utility.set_location(l_proc,995);
1830: end if;
1831: --
1832: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1829: else hr_utility.set_location(l_proc,995);

1825: if l_orig_hire_warning = FALSE then
1826: hr_utility.set_location(l_proc,993);
1827: elsif l_orig_hire_warning = TRUE then
1828: hr_utility.set_location(l_proc,994);
1829: else hr_utility.set_location(l_proc,995);
1830: end if;
1831: --
1832: hr_utility.set_location(' Leaving:'||l_proc, 10);
1833: Exception

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

1828: hr_utility.set_location(l_proc,994);
1829: else hr_utility.set_location(l_proc,995);
1830: end if;
1831: --
1832: hr_utility.set_location(' Leaving:'||l_proc, 10);
1833: Exception
1834: When HR_Api.Validate_Enabled Then
1835: --
1836: -- As the Validate_Enabled exception has been raised

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

2000: l_rec per_per_shd.g_rec_type;
2001: l_proc varchar2(72) := g_package||'upd';
2002: --
2003: Begin
2004: hr_utility.set_location('Entering:'||l_proc, 5);
2005: --
2006: -- Call conversion function to turn arguments into the
2007: -- l_rec structure.
2008: --

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

2176: p_current_employee_flag := l_rec.current_employee_flag;
2177: p_full_name := l_rec.full_name;
2178: p_npw_number := l_rec.npw_number;
2179: --
2180: hr_utility.set_location(' Leaving:'||l_proc, 10);
2181: End upd;
2182: --
2183: end per_per_upd;