DBA Data[Home] [Help]

APPS.PAY_CN_RULES dependencies on HR_CN_API

Line 121: hr_cn_api.set_location (g_debug,'Entering : '||l_procedure_name,10);

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;
125:

Line 140: hr_cn_api.set_location (g_debug,'Leaving : '||l_procedure_name, 20);

136: CLOSE csr_et;
137: OPEN csr_ename(l_effective_date);
138: FETCH csr_ename INTO l_element_name, l_creator_type;
139: IF csr_ename%NOTFOUND THEN
140: hr_cn_api.set_location (g_debug,'Leaving : '||l_procedure_name, 20);
141: CLOSE csr_ename;
142: RETURN;
143: ELSE
144: CLOSE csr_ename;

Line 188: hr_cn_api.set_location (g_debug,'Leaving : '||l_procedure_name,30);

184: END;
185:
186: END IF;
187: p_retro_component_id := l_retro_component_id;
188: hr_cn_api.set_location (g_debug,'Leaving : '||l_procedure_name,30);
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: IF csr_et%ISOPEN 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;

Line 206: hr_cn_api.set_location (g_debug,'Leaving : '||l_procedure_name,40);

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;
210: