eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_IN_ADD_LEG_HOOK dependencies on PAY_IN_UTILS

Line 55: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_state',p_state);

Line 58: pay_in_utils.trace('******************************','');

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
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_state',p_state);
60: pay_in_utils.trace('p_postal_code',p_postal_code);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;

Line 59: pay_in_utils.trace('p_state',p_state);

55: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
56:
57: IF g_debug THEN
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_state',p_state);
60: pay_in_utils.trace('p_postal_code',p_postal_code);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63:

Line 60: pay_in_utils.trace('p_postal_code',p_postal_code);

56:
57: IF g_debug THEN
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_state',p_state);
60: pay_in_utils.trace('p_postal_code',p_postal_code);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63:
64: l_postal_code :=substr(p_postal_code,1,2);

Line 61: pay_in_utils.trace('******************************','');

57: IF g_debug THEN
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_state',p_state);
60: pay_in_utils.trace('p_postal_code',p_postal_code);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63:
64: l_postal_code :=substr(p_postal_code,1,2);
65: select decode(p_state,'JH','BR','CG','MP',p_state) into l_state from dual;

Line 70: pay_in_utils.set_location(g_debug,l_procedure,20);

66:
67: FOR i IN 1..tab_pin_code.COUNT LOOP
68: --
69: IF g_debug THEN
70: pay_in_utils.set_location(g_debug,l_procedure,20);
71: END IF;
72:
73: IF instr(tab_pin_code(i).state_code,l_state)>0 THEN
74:

Line 76: pay_in_utils.set_location(g_debug,l_procedure,30);

72:
73: IF instr(tab_pin_code(i).state_code,l_state)>0 THEN
74:
75: IF g_debug THEN
76: pay_in_utils.set_location(g_debug,l_procedure,30);
77: END IF;
78:
79: IF instr(tab_pin_code(i).pin_code,l_postal_code) =0 THEN
80: --

Line 86: pay_in_utils.set_location(g_debug,l_procedure,40);

82: IF substr(tab_pin_code(i).pin_code,1,2)=substr(tab_pin_code(i).pin_code,-2,2) THEN
83: l_token :=tab_pin_code(i).pin_code;
84:
85: IF g_debug THEN
86: pay_in_utils.set_location(g_debug,l_procedure,40);
87: END IF;
88: ELSE
89: l_token :=rtrim(tab_pin_code(i).pin_code,substr(tab_pin_code(i).pin_code,-3,3))||' or '||substr(tab_pin_code(i).pin_code,-2,2);
90:

Line 92: pay_in_utils.set_location(g_debug,l_procedure,50);

88: ELSE
89: l_token :=rtrim(tab_pin_code(i).pin_code,substr(tab_pin_code(i).pin_code,-3,3))||' or '||substr(tab_pin_code(i).pin_code,-2,2);
90:
91: IF g_debug THEN
92: pay_in_utils.set_location(g_debug,l_procedure,50);
93: END IF;
94:
95: END IF;
96:

Line 98: pay_in_utils.set_location(g_debug,l_procedure,60);

94:
95: END IF;
96:
97: IF g_debug THEN
98: pay_in_utils.set_location(g_debug,l_procedure,60);
99: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);
100: END IF;
101: --
102: RETURN FALSE;

Line 99: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);

95: END IF;
96:
97: IF g_debug THEN
98: pay_in_utils.set_location(g_debug,l_procedure,60);
99: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);
100: END IF;
101: --
102: RETURN FALSE;
103: ELSE

Line 105: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);

101: --
102: RETURN FALSE;
103: ELSE
104: IF g_debug THEN
105: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
106: END IF;
107: RETURN TRUE;
108: END IF;
109: END IF;

Line 113: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);

109: END IF;
110: --
111: --
112: END LOOP;
113: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);
114: RETURN FALSE;
115: EXCEPTION
116: WHEN OTHERS THEN
117: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

Line 117: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

113: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,90);
114: RETURN FALSE;
115: EXCEPTION
116: WHEN OTHERS THEN
117: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
118: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
119: pay_in_utils.trace(l_message,l_procedure);
120: RAISE;
121: RETURN FALSE;

Line 118: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);

114: RETURN FALSE;
115: EXCEPTION
116: WHEN OTHERS THEN
117: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
118: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
119: pay_in_utils.trace(l_message,l_procedure);
120: RAISE;
121: RETURN FALSE;
122: END;

Line 119: pay_in_utils.trace(l_message,l_procedure);

115: EXCEPTION
116: WHEN OTHERS THEN
117: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
118: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
119: pay_in_utils.trace(l_message,l_procedure);
120: RAISE;
121: RETURN FALSE;
122: END;
123:

Line 129: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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);
130: pay_in_utils.trace('**************************************************','********************');
131: pay_in_utils.trace('p_style',p_style);
132: pay_in_utils.trace('p_add_information15',p_add_information15);
133: pay_in_utils.trace('p_postal_code',p_postal_code);

Line 130: pay_in_utils.trace('******************************','');

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);
130: pay_in_utils.trace('**************************************************','********************');
131: pay_in_utils.trace('p_style',p_style);
132: pay_in_utils.trace('p_add_information15',p_add_information15);
133: pay_in_utils.trace('p_postal_code',p_postal_code);
134: pay_in_utils.trace('**************************************************','********************');

Line 131: pay_in_utils.trace('p_style',p_style);

127: IF g_debug THEN
128: l_procedure := g_package ||'check_address';
129: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
130: pay_in_utils.trace('**************************************************','********************');
131: pay_in_utils.trace('p_style',p_style);
132: pay_in_utils.trace('p_add_information15',p_add_information15);
133: pay_in_utils.trace('p_postal_code',p_postal_code);
134: pay_in_utils.trace('**************************************************','********************');
135: END IF;

Line 132: pay_in_utils.trace('p_add_information15',p_add_information15);

128: l_procedure := g_package ||'check_address';
129: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
130: pay_in_utils.trace('**************************************************','********************');
131: pay_in_utils.trace('p_style',p_style);
132: pay_in_utils.trace('p_add_information15',p_add_information15);
133: pay_in_utils.trace('p_postal_code',p_postal_code);
134: pay_in_utils.trace('**************************************************','********************');
135: END IF;
136:

Line 133: pay_in_utils.trace('p_postal_code',p_postal_code);

129: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
130: pay_in_utils.trace('**************************************************','********************');
131: pay_in_utils.trace('p_style',p_style);
132: pay_in_utils.trace('p_add_information15',p_add_information15);
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

Line 134: pay_in_utils.trace('******************************','');

130: pay_in_utils.trace('**************************************************','********************');
131: pay_in_utils.trace('p_style',p_style);
132: pay_in_utils.trace('p_add_information15',p_add_information15);
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

Line 139: pay_in_utils.trace('IN Legislation not installed. Not performing the validations','20');

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:
142: RETURN;
143: END IF;

Line 146: pay_in_utils.set_location(g_debug,l_procedure,30);

142: RETURN;
143: END IF;
144:
145: IF g_debug THEN
146: pay_in_utils.set_location(g_debug,l_procedure,30);
147: END IF;
148: --
149: IF p_style='IN' THEN
150:

Line 161: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

157: END IF;
158:
159: END IF;
160: IF g_debug THEN
161: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
162: END IF;
163: /*
164: EXCEPTION
165: WHEN OTHERS THEN

Line 166: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);

162: END IF;
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;*/

Line 207: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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);
208: pay_in_utils.trace('**************************************************','********************');
209: pay_in_utils.trace('p_style',p_style);
210: pay_in_utils.trace('p_address_id',p_address_id);
211: pay_in_utils.trace('p_add_information14',p_add_information14);

Line 208: pay_in_utils.trace('******************************','');

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);
208: pay_in_utils.trace('**************************************************','********************');
209: pay_in_utils.trace('p_style',p_style);
210: pay_in_utils.trace('p_address_id',p_address_id);
211: pay_in_utils.trace('p_add_information14',p_add_information14);
212: pay_in_utils.trace('p_add_information15',p_add_information15);

Line 209: pay_in_utils.trace('p_style',p_style);

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);
208: pay_in_utils.trace('**************************************************','********************');
209: pay_in_utils.trace('p_style',p_style);
210: pay_in_utils.trace('p_address_id',p_address_id);
211: pay_in_utils.trace('p_add_information14',p_add_information14);
212: pay_in_utils.trace('p_add_information15',p_add_information15);
213: pay_in_utils.trace('p_postal_code',p_postal_code);

Line 210: pay_in_utils.trace('p_address_id',p_address_id);

206: l_procedure := g_package ||'check_per_address_ins';
207: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
208: pay_in_utils.trace('**************************************************','********************');
209: pay_in_utils.trace('p_style',p_style);
210: pay_in_utils.trace('p_address_id',p_address_id);
211: pay_in_utils.trace('p_add_information14',p_add_information14);
212: pay_in_utils.trace('p_add_information15',p_add_information15);
213: pay_in_utils.trace('p_postal_code',p_postal_code);
214: pay_in_utils.trace('**************************************************','********************');

Line 211: pay_in_utils.trace('p_add_information14',p_add_information14);

207: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
208: pay_in_utils.trace('**************************************************','********************');
209: pay_in_utils.trace('p_style',p_style);
210: pay_in_utils.trace('p_address_id',p_address_id);
211: pay_in_utils.trace('p_add_information14',p_add_information14);
212: pay_in_utils.trace('p_add_information15',p_add_information15);
213: pay_in_utils.trace('p_postal_code',p_postal_code);
214: pay_in_utils.trace('**************************************************','********************');
215: END IF;

Line 212: pay_in_utils.trace('p_add_information15',p_add_information15);

208: pay_in_utils.trace('**************************************************','********************');
209: pay_in_utils.trace('p_style',p_style);
210: pay_in_utils.trace('p_address_id',p_address_id);
211: pay_in_utils.trace('p_add_information14',p_add_information14);
212: pay_in_utils.trace('p_add_information15',p_add_information15);
213: pay_in_utils.trace('p_postal_code',p_postal_code);
214: pay_in_utils.trace('**************************************************','********************');
215: END IF;
216: check_address (p_style => p_style

Line 213: pay_in_utils.trace('p_postal_code',p_postal_code);

209: pay_in_utils.trace('p_style',p_style);
210: pay_in_utils.trace('p_address_id',p_address_id);
211: pay_in_utils.trace('p_add_information14',p_add_information14);
212: pay_in_utils.trace('p_add_information15',p_add_information15);
213: pay_in_utils.trace('p_postal_code',p_postal_code);
214: pay_in_utils.trace('**************************************************','********************');
215: END IF;
216: check_address (p_style => p_style
217: ,p_add_information15 => p_add_information15

Line 214: pay_in_utils.trace('******************************','');

210: pay_in_utils.trace('p_address_id',p_address_id);
211: pay_in_utils.trace('p_add_information14',p_add_information14);
212: pay_in_utils.trace('p_add_information15',p_add_information15);
213: pay_in_utils.trace('p_postal_code',p_postal_code);
214: pay_in_utils.trace('**************************************************','********************');
215: END IF;
216: check_address (p_style => p_style
217: ,p_add_information15 => p_add_information15
218: ,p_postal_code => p_postal_code);

Line 220: pay_in_utils.set_location(g_debug,l_procedure,20);

216: check_address (p_style => p_style
217: ,p_add_information15 => p_add_information15
218: ,p_postal_code => p_postal_code);
219: IF g_debug THEN
220: pay_in_utils.set_location(g_debug,l_procedure,20);
221: END IF;
222:
223: IF p_style ='IN' THEN
224: l_get_migrator_status:=hr_general.g_data_migrator_mode;

Line 240: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

236: hr_general.g_data_migrator_mode:=l_get_migrator_status;
237: END IF;
238:
239: IF g_debug THEN
240: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
241: END IF;
242: /*
243: EXCEPTION
244: WHEN OTHERS THEN

Line 245: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

241: END IF;
242: /*
243: EXCEPTION
244: WHEN OTHERS THEN
245: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
246: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
247: pay_in_utils.trace(l_message,l_procedure);
248: RAISE;*/
249: END check_per_address_ins;

Line 246: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

242: /*
243: EXCEPTION
244: WHEN OTHERS THEN
245: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
246: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
247: pay_in_utils.trace(l_message,l_procedure);
248: RAISE;*/
249: END check_per_address_ins;
250:

Line 247: pay_in_utils.trace(l_message,l_procedure);

243: EXCEPTION
244: WHEN OTHERS THEN
245: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
246: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
247: pay_in_utils.trace(l_message,l_procedure);
248: RAISE;*/
249: END check_per_address_ins;
250:
251: --------------------------------------------------------------------------

Line 278: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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);
279: pay_in_utils.trace('**************************************************','********************');
280: pay_in_utils.trace('p_style',p_style);
281: pay_in_utils.trace('p_loc_information16',p_loc_information16);
282: pay_in_utils.trace('p_postal_code',p_postal_code);

Line 279: pay_in_utils.trace('******************************','');

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);
279: pay_in_utils.trace('**************************************************','********************');
280: pay_in_utils.trace('p_style',p_style);
281: pay_in_utils.trace('p_loc_information16',p_loc_information16);
282: pay_in_utils.trace('p_postal_code',p_postal_code);
283: pay_in_utils.trace('**************************************************','********************');

Line 280: pay_in_utils.trace('p_style',p_style);

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);
279: pay_in_utils.trace('**************************************************','********************');
280: pay_in_utils.trace('p_style',p_style);
281: pay_in_utils.trace('p_loc_information16',p_loc_information16);
282: pay_in_utils.trace('p_postal_code',p_postal_code);
283: pay_in_utils.trace('**************************************************','********************');
284: END IF;

Line 281: pay_in_utils.trace('p_loc_information16',p_loc_information16);

277: l_procedure := g_package ||'check_loc_address_ins';
278: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
279: pay_in_utils.trace('**************************************************','********************');
280: pay_in_utils.trace('p_style',p_style);
281: pay_in_utils.trace('p_loc_information16',p_loc_information16);
282: pay_in_utils.trace('p_postal_code',p_postal_code);
283: pay_in_utils.trace('**************************************************','********************');
284: END IF;
285:

Line 282: pay_in_utils.trace('p_postal_code',p_postal_code);

278: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
279: pay_in_utils.trace('**************************************************','********************');
280: pay_in_utils.trace('p_style',p_style);
281: pay_in_utils.trace('p_loc_information16',p_loc_information16);
282: pay_in_utils.trace('p_postal_code',p_postal_code);
283: pay_in_utils.trace('**************************************************','********************');
284: END IF;
285:
286: check_address (p_style => p_style

Line 283: pay_in_utils.trace('******************************','');

279: pay_in_utils.trace('**************************************************','********************');
280: pay_in_utils.trace('p_style',p_style);
281: pay_in_utils.trace('p_loc_information16',p_loc_information16);
282: pay_in_utils.trace('p_postal_code',p_postal_code);
283: pay_in_utils.trace('**************************************************','********************');
284: END IF;
285:
286: check_address (p_style => p_style
287: ,p_add_information15 => p_loc_information16

Line 290: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

286: check_address (p_style => p_style
287: ,p_add_information15 => p_loc_information16
288: ,p_postal_code => p_postal_code);
289: IF g_debug THEN
290: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
291: END IF;
292: /*
293: EXCEPTION
294: WHEN OTHERS THEN

Line 295: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

291: END IF;
292: /*
293: EXCEPTION
294: WHEN OTHERS THEN
295: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
296: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
297: pay_in_utils.trace(l_message,l_procedure);
298: RAISE;*/
299: END check_loc_address_ins;

Line 296: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

292: /*
293: EXCEPTION
294: WHEN OTHERS THEN
295: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
296: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
297: pay_in_utils.trace(l_message,l_procedure);
298: RAISE;*/
299: END check_loc_address_ins;
300:

Line 297: pay_in_utils.trace(l_message,l_procedure);

293: EXCEPTION
294: WHEN OTHERS THEN
295: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
296: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
297: pay_in_utils.trace(l_message,l_procedure);
298: RAISE;*/
299: END check_loc_address_ins;
300:
301:

Line 341: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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);
342: pay_in_utils.trace('**************************************************','********************');
343: pay_in_utils.trace('p_address_id',p_address_id);
344: pay_in_utils.trace('p_add_information14',p_add_information14);
345: pay_in_utils.trace('p_add_information15',p_add_information15);

Line 342: pay_in_utils.trace('******************************','');

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);
342: pay_in_utils.trace('**************************************************','********************');
343: pay_in_utils.trace('p_address_id',p_address_id);
344: pay_in_utils.trace('p_add_information14',p_add_information14);
345: pay_in_utils.trace('p_add_information15',p_add_information15);
346: pay_in_utils.trace('p_postal_code',p_postal_code);

Line 343: pay_in_utils.trace('p_address_id',p_address_id);

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);
342: pay_in_utils.trace('**************************************************','********************');
343: pay_in_utils.trace('p_address_id',p_address_id);
344: pay_in_utils.trace('p_add_information14',p_add_information14);
345: pay_in_utils.trace('p_add_information15',p_add_information15);
346: pay_in_utils.trace('p_postal_code',p_postal_code);
347: pay_in_utils.trace('**************************************************','********************');

Line 344: pay_in_utils.trace('p_add_information14',p_add_information14);

340: l_procedure := g_package ||'check_per_address_upd';
341: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
342: pay_in_utils.trace('**************************************************','********************');
343: pay_in_utils.trace('p_address_id',p_address_id);
344: pay_in_utils.trace('p_add_information14',p_add_information14);
345: pay_in_utils.trace('p_add_information15',p_add_information15);
346: pay_in_utils.trace('p_postal_code',p_postal_code);
347: pay_in_utils.trace('**************************************************','********************');
348: END IF;

Line 345: pay_in_utils.trace('p_add_information15',p_add_information15);

341: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
342: pay_in_utils.trace('**************************************************','********************');
343: pay_in_utils.trace('p_address_id',p_address_id);
344: pay_in_utils.trace('p_add_information14',p_add_information14);
345: pay_in_utils.trace('p_add_information15',p_add_information15);
346: pay_in_utils.trace('p_postal_code',p_postal_code);
347: pay_in_utils.trace('**************************************************','********************');
348: END IF;
349:

Line 346: pay_in_utils.trace('p_postal_code',p_postal_code);

342: pay_in_utils.trace('**************************************************','********************');
343: pay_in_utils.trace('p_address_id',p_address_id);
344: pay_in_utils.trace('p_add_information14',p_add_information14);
345: pay_in_utils.trace('p_add_information15',p_add_information15);
346: pay_in_utils.trace('p_postal_code',p_postal_code);
347: pay_in_utils.trace('**************************************************','********************');
348: END IF;
349:
350: OPEN csr_addr_style(p_address_id);

Line 347: pay_in_utils.trace('******************************','');

343: pay_in_utils.trace('p_address_id',p_address_id);
344: pay_in_utils.trace('p_add_information14',p_add_information14);
345: pay_in_utils.trace('p_add_information15',p_add_information15);
346: pay_in_utils.trace('p_postal_code',p_postal_code);
347: pay_in_utils.trace('**************************************************','********************');
348: END IF;
349:
350: OPEN csr_addr_style(p_address_id);
351: FETCH csr_addr_style INTO l_style;

Line 355: pay_in_utils.set_location(g_debug,l_procedure,20);

351: FETCH csr_addr_style INTO l_style;
352: CLOSE csr_addr_style;
353:
354: IF g_debug THEN
355: pay_in_utils.set_location(g_debug,l_procedure,20);
356: END IF;
357:
358: check_address (p_style => l_style
359: ,p_add_information15 => p_add_information15

Line 363: pay_in_utils.set_location(g_debug,l_procedure,30);

359: ,p_add_information15 => p_add_information15
360: ,p_postal_code => p_postal_code);
361:
362: IF g_debug THEN
363: pay_in_utils.set_location(g_debug,l_procedure,30);
364: END IF;
365:
366: IF l_style='IN' THEN
367: l_get_migrator_status:=hr_general.g_data_migrator_mode;

Line 382: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);/*

378: END IF;
379: hr_general.g_data_migrator_mode:=l_get_migrator_status;
380: END IF;
381:
382: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);/*
383: EXCEPTION
384: WHEN OTHERS THEN
385: IF csr_addr_style%ISOPEN THEN
386: CLOSE csr_addr_style;

Line 388: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

384: WHEN OTHERS THEN
385: IF csr_addr_style%ISOPEN THEN
386: CLOSE csr_addr_style;
387: END IF;
388: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
389: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
390: pay_in_utils.trace(l_message,l_procedure);
391: RAISE;*/
392: END check_per_address_upd;

Line 389: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);

385: IF csr_addr_style%ISOPEN THEN
386: CLOSE csr_addr_style;
387: END IF;
388: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
389: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
390: pay_in_utils.trace(l_message,l_procedure);
391: RAISE;*/
392: END check_per_address_upd;
393: --------------------------------------------------------------------------

Line 390: pay_in_utils.trace(l_message,l_procedure);

386: CLOSE csr_addr_style;
387: END IF;
388: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
389: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
390: pay_in_utils.trace(l_message,l_procedure);
391: RAISE;*/
392: END check_per_address_upd;
393: --------------------------------------------------------------------------
394: -- --

Line 429: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

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);
430: pay_in_utils.trace('**************************************************','********************');
431: pay_in_utils.trace('p_location_id',p_location_id);
432: pay_in_utils.trace('p_loc_information16',p_loc_information16);
433: pay_in_utils.trace('p_postal_code',p_postal_code);

Line 430: pay_in_utils.trace('******************************','');

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);
430: pay_in_utils.trace('**************************************************','********************');
431: pay_in_utils.trace('p_location_id',p_location_id);
432: pay_in_utils.trace('p_loc_information16',p_loc_information16);
433: pay_in_utils.trace('p_postal_code',p_postal_code);
434: pay_in_utils.trace('**************************************************','********************');

Line 431: pay_in_utils.trace('p_location_id',p_location_id);

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);
430: pay_in_utils.trace('**************************************************','********************');
431: pay_in_utils.trace('p_location_id',p_location_id);
432: pay_in_utils.trace('p_loc_information16',p_loc_information16);
433: pay_in_utils.trace('p_postal_code',p_postal_code);
434: pay_in_utils.trace('**************************************************','********************');
435: END IF;

Line 432: pay_in_utils.trace('p_loc_information16',p_loc_information16);

428: l_procedure := g_package ||'check_loc_address_upd';
429: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
430: pay_in_utils.trace('**************************************************','********************');
431: pay_in_utils.trace('p_location_id',p_location_id);
432: pay_in_utils.trace('p_loc_information16',p_loc_information16);
433: pay_in_utils.trace('p_postal_code',p_postal_code);
434: pay_in_utils.trace('**************************************************','********************');
435: END IF;
436:

Line 433: pay_in_utils.trace('p_postal_code',p_postal_code);

429: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
430: pay_in_utils.trace('**************************************************','********************');
431: pay_in_utils.trace('p_location_id',p_location_id);
432: pay_in_utils.trace('p_loc_information16',p_loc_information16);
433: pay_in_utils.trace('p_postal_code',p_postal_code);
434: pay_in_utils.trace('**************************************************','********************');
435: END IF;
436:
437: OPEN csr_addr_style(p_location_id);

Line 434: pay_in_utils.trace('******************************','');

430: pay_in_utils.trace('**************************************************','********************');
431: pay_in_utils.trace('p_location_id',p_location_id);
432: pay_in_utils.trace('p_loc_information16',p_loc_information16);
433: pay_in_utils.trace('p_postal_code',p_postal_code);
434: pay_in_utils.trace('**************************************************','********************');
435: END IF;
436:
437: OPEN csr_addr_style(p_location_id);
438: FETCH csr_addr_style INTO l_style;

Line 442: pay_in_utils.set_location(g_debug,l_procedure,20);

438: FETCH csr_addr_style INTO l_style;
439: CLOSE csr_addr_style;
440:
441: IF g_debug THEN
442: pay_in_utils.set_location(g_debug,l_procedure,20);
443: END IF;
444:
445: check_address (p_style => l_style
446: ,p_add_information15 => p_loc_information16

Line 449: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

445: check_address (p_style => l_style
446: ,p_add_information15 => p_loc_information16
447: ,p_postal_code => p_postal_code);
448: IF g_debug THEN
449: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
450: END IF;/*
451: EXCEPTION
452: WHEN OTHERS THEN
453: IF csr_addr_style%ISOPEN THEN

Line 456: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

452: WHEN OTHERS THEN
453: IF csr_addr_style%ISOPEN THEN
454: CLOSE csr_addr_style;
455: END IF;
456: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
457: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
458: pay_in_utils.trace(l_message,l_procedure);
459: RAISE;*/
460: END check_loc_address_upd;

Line 457: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

453: IF csr_addr_style%ISOPEN THEN
454: CLOSE csr_addr_style;
455: END IF;
456: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
457: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
458: pay_in_utils.trace(l_message,l_procedure);
459: RAISE;*/
460: END check_loc_address_upd;
461:

Line 458: pay_in_utils.trace(l_message,l_procedure);

454: CLOSE csr_addr_style;
455: END IF;
456: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
457: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
458: pay_in_utils.trace(l_message,l_procedure);
459: RAISE;*/
460: END check_loc_address_upd;
461:
462: BEGIN

Line 467: pay_in_utils.set_location(g_debug,'Entering: '||g_package,10);

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;
469: p_cnt:=1;
470:
471: --

Line 484: pay_in_utils.set_location(g_debug,g_package,20);

480: END LOOP;
481: CLOSE csr_pin_codes;
482:
483: IF g_debug THEN
484: pay_in_utils.set_location(g_debug,g_package,20);
485: END IF;
486:
487: pay_in_utils.set_location(g_debug,'Leaving: '||g_package,30);
488: EXCEPTION

Line 487: pay_in_utils.set_location(g_debug,'Leaving: '||g_package,30);

483: IF g_debug THEN
484: pay_in_utils.set_location(g_debug,g_package,20);
485: END IF;
486:
487: pay_in_utils.set_location(g_debug,'Leaving: '||g_package,30);
488: EXCEPTION
489: WHEN OTHERS THEN
490: --
491: IF csr_pin_codes%ISOPEN THEN

Line 493: pay_in_utils.set_location(g_debug,g_package,40);

489: WHEN OTHERS THEN
490: --
491: IF csr_pin_codes%ISOPEN THEN
492: IF g_debug THEN
493: pay_in_utils.set_location(g_debug,g_package,40);
494: END IF;
495: CLOSE csr_pin_codes;
496: END IF;
497: --

Line 498: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'PACKAGE:'||g_package, 'SQLERRMC:'||sqlerrm);

494: END IF;
495: CLOSE csr_pin_codes;
496: END IF;
497: --
498: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'PACKAGE:'||g_package, 'SQLERRMC:'||sqlerrm);
499: pay_in_utils.set_location(g_debug,'Leaving : '||g_package, 50);
500: pay_in_utils.trace(l_message,g_package);
501: RAISE;
502: END per_in_add_leg_hook;

Line 499: pay_in_utils.set_location(g_debug,'Leaving : '||g_package, 50);

495: CLOSE csr_pin_codes;
496: END IF;
497: --
498: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'PACKAGE:'||g_package, 'SQLERRMC:'||sqlerrm);
499: pay_in_utils.set_location(g_debug,'Leaving : '||g_package, 50);
500: pay_in_utils.trace(l_message,g_package);
501: RAISE;
502: END per_in_add_leg_hook;

Line 500: pay_in_utils.trace(l_message,g_package);

496: END IF;
497: --
498: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'PACKAGE:'||g_package, 'SQLERRMC:'||sqlerrm);
499: pay_in_utils.set_location(g_debug,'Leaving : '||g_package, 50);
500: pay_in_utils.trace(l_message,g_package);
501: RAISE;
502: END per_in_add_leg_hook;