APPS.PAY_CN_RULES dependencies on HR_UTILITY

Line 120: g_debug := hr_utility.debug_enabled;

116: l_creator_type pay_element_entries_f.creator_type%TYPE;
117:
118: BEGIN
119: l_procedure_name := g_package_name ||'get_retro_component_id';
120: g_debug := hr_utility.debug_enabled;
121: hr_cn_api.set_location (g_debug,'Entering : '||l_procedure_name,10);
122:
123: l_retro_component_id := p_retro_component_id;
124: l_effective_date := hr_general.effective_date;

Line 127: hr_utility.trace ('====================================================');

123: l_retro_component_id := p_retro_component_id;
124: l_effective_date := hr_general.effective_date;
125:
126: IF g_debug THEN
127: hr_utility.trace ('====================================================');
128: hr_utility.trace (' Element Entry ID : '||p_ee_id);
129: hr_utility.trace ('Old Retro Component ID : '||p_retro_component_id);
130: hr_utility.trace (' Effective Date : '||TO_CHAR(l_effective_date, 'DD/MM/YYYY'));
131: END IF;

Line 128: hr_utility.trace (' Element Entry ID : '||p_ee_id);

124: l_effective_date := hr_general.effective_date;
125:
126: IF g_debug THEN
127: hr_utility.trace ('====================================================');
128: hr_utility.trace (' Element Entry ID : '||p_ee_id);
129: hr_utility.trace ('Old Retro Component ID : '||p_retro_component_id);
130: hr_utility.trace (' Effective Date : '||TO_CHAR(l_effective_date, 'DD/MM/YYYY'));
131: END IF;
132:

Line 129: hr_utility.trace ('Old Retro Component ID : '||p_retro_component_id);

125:
126: IF g_debug THEN
127: hr_utility.trace ('====================================================');
128: hr_utility.trace (' Element Entry ID : '||p_ee_id);
129: hr_utility.trace ('Old Retro Component ID : '||p_retro_component_id);
130: hr_utility.trace (' Effective Date : '||TO_CHAR(l_effective_date, 'DD/MM/YYYY'));
131: END IF;
132:
133: OPEN csr_et(l_effective_date);

Line 130: hr_utility.trace (' Effective Date : '||TO_CHAR(l_effective_date, 'DD/MM/YYYY'));

126: IF g_debug THEN
127: hr_utility.trace ('====================================================');
128: hr_utility.trace (' Element Entry ID : '||p_ee_id);
129: hr_utility.trace ('Old Retro Component ID : '||p_retro_component_id);
130: hr_utility.trace (' Effective Date : '||TO_CHAR(l_effective_date, 'DD/MM/YYYY'));
131: END IF;
132:
133: OPEN csr_et(l_effective_date);
134: FETCH csr_et INTO l_element_name, l_creator_type;

Line 151: hr_utility.trace (' Element Name : '||l_element_name);

147: CLOSE csr_et;
148: END IF;
149:
150: IF g_debug THEN
151: hr_utility.trace (' Element Name : '||l_element_name);
152: hr_utility.trace (' Creator Type : '||l_creator_type);
153: hr_utility.trace ('====================================================');
154: END IF;
155:

Line 152: hr_utility.trace (' Creator Type : '||l_creator_type);

148: END IF;
149:
150: IF g_debug THEN
151: hr_utility.trace (' Element Name : '||l_element_name);
152: hr_utility.trace (' Creator Type : '||l_creator_type);
153: hr_utility.trace ('====================================================');
154: END IF;
155:
156: IF l_element_name NOT IN

Line 153: hr_utility.trace ('====================================================');

149:
150: IF g_debug THEN
151: hr_utility.trace (' Element Name : '||l_element_name);
152: hr_utility.trace (' Creator Type : '||l_creator_type);
153: hr_utility.trace ('====================================================');
154: END IF;
155:
156: IF l_element_name NOT IN
157: ('Taxation Information') -- Bug 5484589

Line 164: hr_utility.trace (' Tax Area : '||l_tax_area);

160: OPEN csr_tax_area(l_effective_date);
161: FETCH csr_tax_area INTO l_tax_area, l_bg_id;
162: CLOSE csr_tax_area;
163: IF g_debug THEN
164: hr_utility.trace (' Tax Area : '||l_tax_area);
165: hr_utility.trace (' Business Group ID : '||l_bg_id);
166: END IF;
167:
168: BEGIN

Line 165: hr_utility.trace (' Business Group ID : '||l_bg_id);

161: FETCH csr_tax_area INTO l_tax_area, l_bg_id;
162: CLOSE csr_tax_area;
163: IF g_debug THEN
164: hr_utility.trace (' Tax Area : '||l_tax_area);
165: hr_utility.trace (' Business Group ID : '||l_bg_id);
166: END IF;
167:
168: BEGIN
169: OPEN csr_rc_id (l_bg_id, l_tax_area, l_effective_date);

Line 174: hr_utility.trace ('New Retro Component ID : '||p_retro_component_id);

170: FETCH csr_rc_id INTO l_retro_component_id;
171: CLOSE csr_rc_id;
172:
173: IF g_debug THEN
174: hr_utility.trace ('New Retro Component ID : '||p_retro_component_id);
175: END IF;
176:
177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN

Line 205: hr_utility.trace(hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm));

201: IF csr_ename%ISOPEN THEN
202: close csr_ename;
203: END IF;
204: p_retro_component_id := -1;
205: hr_utility.trace(hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure_name, 'SQLERRMC:'||sqlerrm));
206: hr_cn_api.set_location (g_debug,'Leaving : '||l_procedure_name,40);
207: RAISE;
208:
209: END get_retro_component_id;