62: l_procedure VARCHAR2(100);
63:
64: BEGIN
65:
66: g_debug := hr_utility.debug_enabled ;
67: l_procedure := g_package ||'check_asg';
68: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
69:
70: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
66: g_debug := hr_utility.debug_enabled ;
67: l_procedure := g_package ||'check_asg';
68: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
69:
70: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
71: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
72: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
73: RETURN;
74: END IF;
67: l_procedure := g_package ||'check_asg';
68: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
69:
70: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
71: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
72: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
73: RETURN;
74: END IF;
75:
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: IF c_org_name%ISOPEN THEN close c_org_name; END IF;
129: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
130: hr_utility.set_message_token('FUNCTION',l_procedure);
131: hr_utility.set_message_token('SQLERRMC',sqlerrm);
132: hr_utility.raise_error;
133: END check_asg;
126: EXCEPTION
127: WHEN OTHERS THEN
128: IF c_org_name%ISOPEN THEN close c_org_name; END IF;
129: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
130: hr_utility.set_message_token('FUNCTION',l_procedure);
131: hr_utility.set_message_token('SQLERRMC',sqlerrm);
132: hr_utility.raise_error;
133: END check_asg;
134:
127: WHEN OTHERS THEN
128: IF c_org_name%ISOPEN THEN close c_org_name; END IF;
129: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
130: hr_utility.set_message_token('FUNCTION',l_procedure);
131: hr_utility.set_message_token('SQLERRMC',sqlerrm);
132: hr_utility.raise_error;
133: END check_asg;
134:
135:
128: IF c_org_name%ISOPEN THEN close c_org_name; END IF;
129: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
130: hr_utility.set_message_token('FUNCTION',l_procedure);
131: hr_utility.set_message_token('SQLERRMC',sqlerrm);
132: hr_utility.raise_error;
133: END check_asg;
134:
135:
136: --------------------------------------------------------------------------
182: )
183: IS
184: l_procedure VARCHAR2(100);
185: BEGIN
186: g_debug := hr_utility.debug_enabled;
187: l_procedure := g_package ||'check_asg_update';
188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
189: --
190:
207: pay_in_utils.set_location(g_debug,'Leaving: '||g_procedure_name,20);
208:
209: EXCEPTION
210: WHEN OTHERS THEN
211: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
212: hr_utility.set_message_token('FUNCTION',g_procedure_name);
213: hr_utility.set_message_token('SQLERRMC',sqlerrm);
214: hr_utility.raise_error; */
215:
208:
209: EXCEPTION
210: WHEN OTHERS THEN
211: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
212: hr_utility.set_message_token('FUNCTION',g_procedure_name);
213: hr_utility.set_message_token('SQLERRMC',sqlerrm);
214: hr_utility.raise_error; */
215:
216: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
209: EXCEPTION
210: WHEN OTHERS THEN
211: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
212: hr_utility.set_message_token('FUNCTION',g_procedure_name);
213: hr_utility.set_message_token('SQLERRMC',sqlerrm);
214: hr_utility.raise_error; */
215:
216: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
217: END check_asg_update;
210: WHEN OTHERS THEN
211: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
212: hr_utility.set_message_token('FUNCTION',g_procedure_name);
213: hr_utility.set_message_token('SQLERRMC',sqlerrm);
214: hr_utility.raise_error; */
215:
216: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
217: END check_asg_update;
218: