DBA Data[Home] [Help]

APPS.PER_IN_ADD_LEG_HOOK dependencies on HR_UTILITY

Line 53: g_debug := hr_utility.debug_enabled ;

49: g_debug BOOLEAN;
50: l_state hr_lookups.lookup_code%TYPE;
51:
52: BEGIN
53: g_debug := hr_utility.debug_enabled ;
54: l_procedure := g_package ||'validate_pin_code';
55: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
56:
57: IF g_debug THEN

Line 125: g_debug := hr_utility.debug_enabled ;

121: RETURN FALSE;
122: END;
123:
124: BEGIN
125: g_debug := hr_utility.debug_enabled ;
126:
127: IF g_debug THEN
128: l_procedure := g_package ||'check_address';
129: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

Line 137: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN

133: pay_in_utils.trace('p_postal_code',p_postal_code);
134: pay_in_utils.trace('**************************************************','********************');
135: END IF;
136:
137: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
138: IF g_debug THEN
139: pay_in_utils.trace('IN Legislation not installed. Not performing the validations','20');
140: END IF;
141:

Line 153: hr_utility.set_message(800,'PER_IN_INVALID_PIN_CODE');

149: IF p_style='IN' THEN
150:
151: IF p_postal_code IS NOT NULL AND p_add_information15 IS NOT NULL THEN
152: IF NOT validate_pin_code(p_add_information15,p_postal_code) THEN
153: hr_utility.set_message(800,'PER_IN_INVALID_PIN_CODE');
154: hr_utility.set_message_token('VALUE',l_token);
155: hr_utility.raise_error;
156: END IF;
157: END IF;

Line 154: hr_utility.set_message_token('VALUE',l_token);

150:
151: IF p_postal_code IS NOT NULL AND p_add_information15 IS NOT NULL THEN
152: IF NOT validate_pin_code(p_add_information15,p_postal_code) THEN
153: hr_utility.set_message(800,'PER_IN_INVALID_PIN_CODE');
154: hr_utility.set_message_token('VALUE',l_token);
155: hr_utility.raise_error;
156: END IF;
157: END IF;
158:

Line 155: hr_utility.raise_error;

151: IF p_postal_code IS NOT NULL AND p_add_information15 IS NOT NULL THEN
152: IF NOT validate_pin_code(p_add_information15,p_postal_code) THEN
153: hr_utility.set_message(800,'PER_IN_INVALID_PIN_CODE');
154: hr_utility.set_message_token('VALUE',l_token);
155: hr_utility.raise_error;
156: END IF;
157: END IF;
158:
159: END IF;

Line 167: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');

163: /*
164: EXCEPTION
165: WHEN OTHERS THEN
166: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
167: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');
168: hr_utility.set_message_token('FUNCTION',l_procedure);
169: hr_utility.set_message_token('SQLERRMC',sqlerrm);
170: hr_utility.raise_error;*/
171: END check_address;

Line 168: hr_utility.set_message_token('FUNCTION',l_procedure);

164: EXCEPTION
165: WHEN OTHERS THEN
166: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
167: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');
168: hr_utility.set_message_token('FUNCTION',l_procedure);
169: hr_utility.set_message_token('SQLERRMC',sqlerrm);
170: hr_utility.raise_error;*/
171: END check_address;
172:

Line 169: hr_utility.set_message_token('SQLERRMC',sqlerrm);

165: WHEN OTHERS THEN
166: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
167: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');
168: hr_utility.set_message_token('FUNCTION',l_procedure);
169: hr_utility.set_message_token('SQLERRMC',sqlerrm);
170: hr_utility.raise_error;*/
171: END check_address;
172:
173: --------------------------------------------------------------------------

Line 170: hr_utility.raise_error;*/

166: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
167: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');
168: hr_utility.set_message_token('FUNCTION',l_procedure);
169: hr_utility.set_message_token('SQLERRMC',sqlerrm);
170: hr_utility.raise_error;*/
171: END check_address;
172:
173: --------------------------------------------------------------------------
174: -- --

Line 203: g_debug := hr_utility.debug_enabled ;

199: g_debug BOOLEAN;
200: l_procedure VARCHAR2(100);
201: l_message VARCHAR2(255);
202: BEGIN
203: g_debug := hr_utility.debug_enabled ;
204:
205: IF g_debug THEN
206: l_procedure := g_package ||'check_per_address_ins';
207: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

Line 274: g_debug := hr_utility.debug_enabled ;

270: g_debug BOOLEAN;
271: l_procedure VARCHAR2(100);
272: l_message VARCHAR2(255);
273: BEGIN
274: g_debug := hr_utility.debug_enabled ;
275:
276: IF g_debug THEN
277: l_procedure := g_package ||'check_loc_address_ins';
278: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

Line 337: g_debug := hr_utility.debug_enabled ;

333: FROM per_addresses addr
334: WHERE addr.address_id = p_address_id ;
335:
336: BEGIN
337: g_debug := hr_utility.debug_enabled ;
338:
339: IF g_debug THEN
340: l_procedure := g_package ||'check_per_address_upd';
341: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

Line 425: g_debug := hr_utility.debug_enabled ;

421: WHERE hl.location_id = p_location_id ;
422:
423:
424: BEGIN
425: g_debug := hr_utility.debug_enabled ;
426:
427: IF g_debug THEN
428: l_procedure := g_package ||'check_loc_address_upd';
429: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

Line 464: g_debug := hr_utility.debug_enabled ;

460: END check_loc_address_upd;
461:
462: BEGIN
463:
464: g_debug := hr_utility.debug_enabled ;
465:
466: IF g_debug THEN
467: pay_in_utils.set_location(g_debug,'Entering: '||g_package,10);
468: END IF;