94: END check_number;
95:
96: BEGIN
97:
98: g_debug := hr_utility.debug_enabled ;
99: l_procedure := g_package ||'check_asg';
100: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
101:
102: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
98: g_debug := hr_utility.debug_enabled ;
99: l_procedure := g_package ||'check_asg';
100: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
101:
102: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
103: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
104: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
105: RETURN;
106: END IF;
99: l_procedure := g_package ||'check_asg';
100: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
101:
102: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
103: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
104: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
105: RETURN;
106: END IF;
107:
177:
178: /*EXCEPTION
179: WHEN OTHERS THEN
180: IF c_org_name%ISOPEN THEN close c_org_name; END IF;
181: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
182: hr_utility.set_message_token('FUNCTION',l_procedure);
183: hr_utility.set_message_token('SQLERRMC',sqlerrm);
184: hr_utility.raise_error;*/
185: END check_asg;
178: /*EXCEPTION
179: WHEN OTHERS THEN
180: IF c_org_name%ISOPEN THEN close c_org_name; END IF;
181: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
182: hr_utility.set_message_token('FUNCTION',l_procedure);
183: hr_utility.set_message_token('SQLERRMC',sqlerrm);
184: hr_utility.raise_error;*/
185: END check_asg;
186:
179: WHEN OTHERS THEN
180: IF c_org_name%ISOPEN THEN close c_org_name; END IF;
181: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
182: hr_utility.set_message_token('FUNCTION',l_procedure);
183: hr_utility.set_message_token('SQLERRMC',sqlerrm);
184: hr_utility.raise_error;*/
185: END check_asg;
186:
187:
180: IF c_org_name%ISOPEN THEN close c_org_name; END IF;
181: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
182: hr_utility.set_message_token('FUNCTION',l_procedure);
183: hr_utility.set_message_token('SQLERRMC',sqlerrm);
184: hr_utility.raise_error;*/
185: END check_asg;
186:
187:
188: --------------------------------------------------------------------------
234: )
235: IS
236: l_procedure VARCHAR2(100);
237: BEGIN
238: g_debug := hr_utility.debug_enabled;
239: l_procedure := g_package ||'check_asg_update';
240: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
241: --
242:
259: pay_in_utils.set_location(g_debug,'Leaving: '||g_procedure_name,20);
260:
261: /*EXCEPTION
262: WHEN OTHERS THEN
263: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
264: hr_utility.set_message_token('FUNCTION',l_procedure);
265: hr_utility.set_message_token('SQLERRMC',sqlerrm);
266: hr_utility.raise_error; */
267:
260:
261: /*EXCEPTION
262: WHEN OTHERS THEN
263: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
264: hr_utility.set_message_token('FUNCTION',l_procedure);
265: hr_utility.set_message_token('SQLERRMC',sqlerrm);
266: hr_utility.raise_error; */
267:
268: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
261: /*EXCEPTION
262: WHEN OTHERS THEN
263: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
264: hr_utility.set_message_token('FUNCTION',l_procedure);
265: hr_utility.set_message_token('SQLERRMC',sqlerrm);
266: hr_utility.raise_error; */
267:
268: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
269: END check_asg_update;
262: WHEN OTHERS THEN
263: hr_utility.set_message(800, 'PER_IN_ORACLE_GENERIC_ERROR');
264: hr_utility.set_message_token('FUNCTION',l_procedure);
265: hr_utility.set_message_token('SQLERRMC',sqlerrm);
266: hr_utility.raise_error; */
267:
268: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
269: END check_asg_update;
270: