APPS.HR_LEAVING_REASON_MIG dependencies on HR_UTILITY

Line 45: hr_utility.set_location('Entering:'||l_proc, 10);

41: --
42:
43: begin
44:
45: hr_utility.set_location('Entering:'||l_proc, 10);
46: hr_utility.set_location('Existing Leaving Reason = '||p_existing_leaving_reason, 20);
47: hr_utility.set_location('Seeded Leaving Reason = '||p_seeded_leaving_reason, 25);
48: --
49: ERRBUF := NULL;

Line 46: hr_utility.set_location('Existing Leaving Reason = '||p_existing_leaving_reason, 20);

42:
43: begin
44:
45: hr_utility.set_location('Entering:'||l_proc, 10);
46: hr_utility.set_location('Existing Leaving Reason = '||p_existing_leaving_reason, 20);
47: hr_utility.set_location('Seeded Leaving Reason = '||p_seeded_leaving_reason, 25);
48: --
49: ERRBUF := NULL;
50: RETCODE := 0;

Line 47: hr_utility.set_location('Seeded Leaving Reason = '||p_seeded_leaving_reason, 25);

43: begin
44:
45: hr_utility.set_location('Entering:'||l_proc, 10);
46: hr_utility.set_location('Existing Leaving Reason = '||p_existing_leaving_reason, 20);
47: hr_utility.set_location('Seeded Leaving Reason = '||p_seeded_leaving_reason, 25);
48: --
49: ERRBUF := NULL;
50: RETCODE := 0;
51:

Line 57: hr_utility.set_location('Period_of_service_id = '|| pds_rec.period_of_service_id, 30);

53: --
54: l_total_records := csr_pds%rowcount;
55:
56: l_object_version_number := pds_rec.object_version_number;
57: hr_utility.set_location('Period_of_service_id = '|| pds_rec.period_of_service_id, 30);
58: --
59: l_count := l_count + 1;
60: --
61: hr_periods_of_service_api.update_pds_details(

Line 71: hr_utility.set_location('Committed : '||l_count||' records.', 40);

67:
68: --
69: if l_count = 100 then
70: commit;
71: hr_utility.set_location('Committed : '||l_count||' records.', 40);
72: l_count := 0;
73: end if;
74: --
75: --

Line 79: hr_utility.set_location('Total records: '||l_total_records||' records.', 50);

75: --
76:
77: End loop;
78: --
79: hr_utility.set_location('Total records: '||l_total_records||' records.', 50);
80: --
81: hr_utility.set_location('Updating lookup table : FND_LOOKUP_VALUES', 60);
82:
83: Update fnd_lookup_values

Line 81: hr_utility.set_location('Updating lookup table : FND_LOOKUP_VALUES', 60);

77: End loop;
78: --
79: hr_utility.set_location('Total records: '||l_total_records||' records.', 50);
80: --
81: hr_utility.set_location('Updating lookup table : FND_LOOKUP_VALUES', 60);
82:
83: Update fnd_lookup_values
84: set end_date_active = l_effective_date, enabled_flag = 'N'
85: where lookup_type = 'LEAV_REAS'

Line 88: hr_utility.set_location('Updated lookup table : FND_LOOKUP_VALUES', 60);

84: set end_date_active = l_effective_date, enabled_flag = 'N'
85: where lookup_type = 'LEAV_REAS'
86: and lookup_code = p_existing_leaving_reason;
87: --
88: hr_utility.set_location('Updated lookup table : FND_LOOKUP_VALUES', 60);
89: --
90: -- the following is a migration of the ZA_TERMINATION_CATEGORIES
91: --
92: if hr_general2.is_legislation_install('PER','ZA') then

Line 94: hr_utility.set_location(' Entering ZA Migration ', 70);

90: -- the following is a migration of the ZA_TERMINATION_CATEGORIES
91: --
92: if hr_general2.is_legislation_install('PER','ZA') then
93: --
94: hr_utility.set_location(' Entering ZA Migration ', 70);
95: --
96: per_za_utility_pkg.za_term_cat_update(
97: p_existing_leaving_reason => p_existing_leaving_reason
98: ,p_seeded_leaving_reason => p_seeded_leaving_reason

Line 101: hr_utility.set_location(' Leaving ZA Migration ', 70);

97: p_existing_leaving_reason => p_existing_leaving_reason
98: ,p_seeded_leaving_reason => p_seeded_leaving_reason
99: );
100: --
101: hr_utility.set_location(' Leaving ZA Migration ', 70);
102: --
103: end if;
104:
105: --

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

102: --
103: end if;
104:
105: --
106: hr_utility.set_location('Leaving:'||l_proc, 10);
107: --
108: End leave_reas_mig;
109: end HR_LEAVING_REASON_MIG;