DBA Data[Home] [Help]

APPS.PER_IE_VEHICLE_ALLOC_RULES dependencies on HR_UTILITY

Line 89: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN

85:
86: BEGIN
87:
88: /* Added for GSI Bug 5472781 */
89: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
90:
91: hr_utility.set_location('Entering ' || l_proc,10);
92: hr_utility.set_location('p_vehicle_allocation_id = ' ||
93: p_vehicle_allocation_id,10);

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

87:
88: /* Added for GSI Bug 5472781 */
89: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
90:
91: hr_utility.set_location('Entering ' || l_proc,10);
92: hr_utility.set_location('p_vehicle_allocation_id = ' ||
93: p_vehicle_allocation_id,10);
94: hr_utility.set_location('p_effective_date = ' || p_effective_date,10);
95:

Line 92: hr_utility.set_location('p_vehicle_allocation_id = ' ||

88: /* Added for GSI Bug 5472781 */
89: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
90:
91: hr_utility.set_location('Entering ' || l_proc,10);
92: hr_utility.set_location('p_vehicle_allocation_id = ' ||
93: p_vehicle_allocation_id,10);
94: hr_utility.set_location('p_effective_date = ' || p_effective_date,10);
95:
96: OPEN csr_vehicle_element_entry;

Line 94: hr_utility.set_location('p_effective_date = ' || p_effective_date,10);

90:
91: hr_utility.set_location('Entering ' || l_proc,10);
92: hr_utility.set_location('p_vehicle_allocation_id = ' ||
93: p_vehicle_allocation_id,10);
94: hr_utility.set_location('p_effective_date = ' || p_effective_date,10);
95:
96: OPEN csr_vehicle_element_entry;
97: FETCH csr_vehicle_element_entry
98: INTO l_element_entry_id,

Line 103: hr_utility.set_location('l_effective_start_date = ' ||

99: l_object_version_number,
100: l_max_effective_date,
101: l_max_date_earned; -- 5872123
102:
103: hr_utility.set_location('l_effective_start_date = ' ||
104: to_char(l_element_entry_id),30);
105: hr_utility.set_location('l_effective_end_date = ' ||
106: to_char(l_object_version_number),30);
107: hr_utility.set_location('l_effective_end_date = ' ||

Line 105: hr_utility.set_location('l_effective_end_date = ' ||

101: l_max_date_earned; -- 5872123
102:
103: hr_utility.set_location('l_effective_start_date = ' ||
104: to_char(l_element_entry_id),30);
105: hr_utility.set_location('l_effective_end_date = ' ||
106: to_char(l_object_version_number),30);
107: hr_utility.set_location('l_effective_end_date = ' ||
108: to_char(l_max_effective_date),30);
109:

Line 107: hr_utility.set_location('l_effective_end_date = ' ||

103: hr_utility.set_location('l_effective_start_date = ' ||
104: to_char(l_element_entry_id),30);
105: hr_utility.set_location('l_effective_end_date = ' ||
106: to_char(l_object_version_number),30);
107: hr_utility.set_location('l_effective_end_date = ' ||
108: to_char(l_max_effective_date),30);
109:
110: IF csr_vehicle_element_entry%FOUND THEN
111: OPEN csr_pay_period(l_max_effective_date,l_max_date_earned); -- 5872123

Line 115: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id,20);

111: OPEN csr_pay_period(l_max_effective_date,l_max_date_earned); -- 5872123
112: FETCH csr_pay_period INTO l_period_end_date;
113: CLOSE csr_pay_period;
114:
115: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id,20);
116: hr_utility.set_location('l_period_end_date = ' || l_period_end_date,20);
117: hr_utility.set_location('Calling delete_element_entry',25);
118:
119: pay_element_entry_api.delete_element_entry (

Line 116: hr_utility.set_location('l_period_end_date = ' || l_period_end_date,20);

112: FETCH csr_pay_period INTO l_period_end_date;
113: CLOSE csr_pay_period;
114:
115: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id,20);
116: hr_utility.set_location('l_period_end_date = ' || l_period_end_date,20);
117: hr_utility.set_location('Calling delete_element_entry',25);
118:
119: pay_element_entry_api.delete_element_entry (
120: p_validate => FALSE,

Line 117: hr_utility.set_location('Calling delete_element_entry',25);

113: CLOSE csr_pay_period;
114:
115: hr_utility.set_location('l_element_entry_id = ' || l_element_entry_id,20);
116: hr_utility.set_location('l_period_end_date = ' || l_period_end_date,20);
117: hr_utility.set_location('Calling delete_element_entry',25);
118:
119: pay_element_entry_api.delete_element_entry (
120: p_validate => FALSE,
121: p_datetrack_delete_mode => 'DELETE',

Line 130: hr_utility.set_location('l_effective_start_date = ' ||

126: p_effective_end_date => l_effective_end_date,
127: p_delete_warning => l_delete_warning
128: );
129:
130: hr_utility.set_location('l_effective_start_date = ' ||
131: l_effective_start_date,30);
132: hr_utility.set_location('l_effective_end_date = ' ||
133: l_effective_end_date,30);
134: END IF;

Line 132: hr_utility.set_location('l_effective_end_date = ' ||

128: );
129:
130: hr_utility.set_location('l_effective_start_date = ' ||
131: l_effective_start_date,30);
132: hr_utility.set_location('l_effective_end_date = ' ||
133: l_effective_end_date,30);
134: END IF;
135:
136: CLOSE csr_vehicle_element_entry;

Line 137: hr_utility.set_location('Leaving ' || l_proc,40);

133: l_effective_end_date,30);
134: END IF;
135:
136: CLOSE csr_vehicle_element_entry;
137: hr_utility.set_location('Leaving ' || l_proc,40);
138:
139: END IF; /* Added for GSI Bug 5472781 */
140:
141: END element_end_date_update;