5: --
6: g_package CONSTANT VARCHAR2(100) := 'per_in_entry_value_leg_hook.' ;
7: g_debug BOOLEAN ;
8: g_message_name VARCHAR2(30);
9: g_token_name pay_in_utils.char_tab_type;
10: g_token_value pay_in_utils.char_tab_type;
11:
12: --------------------------------------------------------------------------
13: -- --
6: g_package CONSTANT VARCHAR2(100) := 'per_in_entry_value_leg_hook.' ;
7: g_debug BOOLEAN ;
8: g_message_name VARCHAR2(30);
9: g_token_name pay_in_utils.char_tab_type;
10: g_token_value pay_in_utils.char_tab_type;
11:
12: --------------------------------------------------------------------------
13: -- --
14: -- Name : CHECK_ENTRY_VALUE_INT --
38: ,p_effective_start_date IN DATE
39: ,p_effective_end_date IN DATE
40: ,p_calling_procedure IN VARCHAR2
41: ,p_message_name OUT NOCOPY VARCHAR2
42: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
43: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
44: )
45: IS
46: l_procedure VARCHAR2(100);
39: ,p_effective_end_date IN DATE
40: ,p_calling_procedure IN VARCHAR2
41: ,p_message_name OUT NOCOPY VARCHAR2
42: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
43: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
44: )
45: IS
46: l_procedure VARCHAR2(100);
47: l_message VARCHAR2(250);
47: l_message VARCHAR2(250);
48: BEGIN
49: l_procedure := g_package||'check_entry_value_int';
50: g_debug := hr_utility.debug_enabled;
51: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
52:
53: IF g_debug THEN
54: pay_in_utils.trace('**************************************************','********************');
55: pay_in_utils.trace('p_effective_date ',p_effective_date );
50: g_debug := hr_utility.debug_enabled;
51: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
52:
53: IF g_debug THEN
54: pay_in_utils.trace('**************************************************','********************');
55: pay_in_utils.trace('p_effective_date ',p_effective_date );
56: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
57: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
58: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
51: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
52:
53: IF g_debug THEN
54: pay_in_utils.trace('**************************************************','********************');
55: pay_in_utils.trace('p_effective_date ',p_effective_date );
56: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
57: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
58: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
59: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
52:
53: IF g_debug THEN
54: pay_in_utils.trace('**************************************************','********************');
55: pay_in_utils.trace('p_effective_date ',p_effective_date );
56: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
57: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
58: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
59: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
60: pay_in_utils.trace('**************************************************','********************');
53: IF g_debug THEN
54: pay_in_utils.trace('**************************************************','********************');
55: pay_in_utils.trace('p_effective_date ',p_effective_date );
56: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
57: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
58: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
59: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
60: pay_in_utils.trace('**************************************************','********************');
61: END IF;
54: pay_in_utils.trace('**************************************************','********************');
55: pay_in_utils.trace('p_effective_date ',p_effective_date );
56: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
57: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
58: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
59: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
60: pay_in_utils.trace('**************************************************','********************');
61: END IF;
62:
55: pay_in_utils.trace('p_effective_date ',p_effective_date );
56: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
57: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
58: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
59: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
60: pay_in_utils.trace('**************************************************','********************');
61: END IF;
62:
63: pay_in_utils.null_message(g_token_name, g_token_value);
56: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
57: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
58: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
59: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
60: pay_in_utils.trace('**************************************************','********************');
61: END IF;
62:
63: pay_in_utils.null_message(g_token_name, g_token_value);
64: g_message_name := 'SUCCESS';
59: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
60: pay_in_utils.trace('**************************************************','********************');
61: END IF;
62:
63: pay_in_utils.null_message(g_token_name, g_token_value);
64: g_message_name := 'SUCCESS';
65:
66: --
67: -- Code for Checking element entries
75: ,p_message_name => g_message_name
76: ,p_token_name => g_token_name
77: ,p_token_value => g_token_value);
78:
79: pay_in_utils.set_location(g_debug,l_procedure,20);
80: IF g_message_name <> 'SUCCESS' then
81: IF g_debug THEN
82: pay_in_utils.trace('**************************************************','********************');
83: pay_in_utils.trace('g_message_name ',g_message_name);
78:
79: pay_in_utils.set_location(g_debug,l_procedure,20);
80: IF g_message_name <> 'SUCCESS' then
81: IF g_debug THEN
82: pay_in_utils.trace('**************************************************','********************');
83: pay_in_utils.trace('g_message_name ',g_message_name);
84: pay_in_utils.trace('**************************************************','********************');
85: END IF;
86:
79: pay_in_utils.set_location(g_debug,l_procedure,20);
80: IF g_message_name <> 'SUCCESS' then
81: IF g_debug THEN
82: pay_in_utils.trace('**************************************************','********************');
83: pay_in_utils.trace('g_message_name ',g_message_name);
84: pay_in_utils.trace('**************************************************','********************');
85: END IF;
86:
87: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
80: IF g_message_name <> 'SUCCESS' then
81: IF g_debug THEN
82: pay_in_utils.trace('**************************************************','********************');
83: pay_in_utils.trace('g_message_name ',g_message_name);
84: pay_in_utils.trace('**************************************************','********************');
85: END IF;
86:
87: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
88: RETURN;
83: pay_in_utils.trace('g_message_name ',g_message_name);
84: pay_in_utils.trace('**************************************************','********************');
85: END IF;
86:
87: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
88: RETURN;
89: END IF;
90:
91: pay_in_termination_pkg.check_gratuity
96: ,p_token_name => g_token_name
97: ,p_token_value => g_token_value);
98: --
99: IF g_debug THEN
100: pay_in_utils.trace('**************************************************','********************');
101: pay_in_utils.trace('g_message_name ',g_message_name);
102: pay_in_utils.trace('**************************************************','********************');
103: END IF;
104:
97: ,p_token_value => g_token_value);
98: --
99: IF g_debug THEN
100: pay_in_utils.trace('**************************************************','********************');
101: pay_in_utils.trace('g_message_name ',g_message_name);
102: pay_in_utils.trace('**************************************************','********************');
103: END IF;
104:
105: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
98: --
99: IF g_debug THEN
100: pay_in_utils.trace('**************************************************','********************');
101: pay_in_utils.trace('g_message_name ',g_message_name);
102: pay_in_utils.trace('**************************************************','********************');
103: END IF;
104:
105: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
106:
101: pay_in_utils.trace('g_message_name ',g_message_name);
102: pay_in_utils.trace('**************************************************','********************');
103: END IF;
104:
105: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
106:
107: END check_entry_value_int;
108: --------------------------------------------------------------------------
109: -- --
139: BEGIN
140: --
141: l_procedure := g_package||'check_entry_value';
142: g_debug := hr_utility.debug_enabled;
143: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
144:
145: IF g_debug THEN
146: pay_in_utils.trace('**************************************************','********************');
147: pay_in_utils.trace('p_effective_date ',p_effective_date );
142: g_debug := hr_utility.debug_enabled;
143: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
144:
145: IF g_debug THEN
146: pay_in_utils.trace('**************************************************','********************');
147: pay_in_utils.trace('p_effective_date ',p_effective_date );
148: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
149: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
150: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
143: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
144:
145: IF g_debug THEN
146: pay_in_utils.trace('**************************************************','********************');
147: pay_in_utils.trace('p_effective_date ',p_effective_date );
148: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
149: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
150: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
151: pay_in_utils.trace('**************************************************','********************');
144:
145: IF g_debug THEN
146: pay_in_utils.trace('**************************************************','********************');
147: pay_in_utils.trace('p_effective_date ',p_effective_date );
148: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
149: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
150: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
151: pay_in_utils.trace('**************************************************','********************');
152: END IF;
145: IF g_debug THEN
146: pay_in_utils.trace('**************************************************','********************');
147: pay_in_utils.trace('p_effective_date ',p_effective_date );
148: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
149: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
150: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
151: pay_in_utils.trace('**************************************************','********************');
152: END IF;
153:
146: pay_in_utils.trace('**************************************************','********************');
147: pay_in_utils.trace('p_effective_date ',p_effective_date );
148: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
149: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
150: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
151: pay_in_utils.trace('**************************************************','********************');
152: END IF;
153:
154: g_message_name := 'SUCCESS';
147: pay_in_utils.trace('p_effective_date ',p_effective_date );
148: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
149: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
150: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
151: pay_in_utils.trace('**************************************************','********************');
152: END IF;
153:
154: g_message_name := 'SUCCESS';
155: pay_in_utils.null_message (g_token_name, g_token_value);
151: pay_in_utils.trace('**************************************************','********************');
152: END IF;
153:
154: g_message_name := 'SUCCESS';
155: pay_in_utils.null_message (g_token_name, g_token_value);
156: --
157: -- Check whether PAY is installed for India Localization
158: --
159: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
157: -- Check whether PAY is installed for India Localization
158: --
159: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
160:
161: pay_in_utils.set_location(g_debug,l_procedure,20);
162:
163: check_entry_value_int(p_effective_date => p_effective_date
164: ,p_element_entry_id => p_element_entry_id
165: ,p_effective_start_date=> p_effective_start_date
170: ,p_token_value => g_token_value
171: );
172: --
173: IF g_debug THEN
174: pay_in_utils.trace('**************************************************','********************');
175: pay_in_utils.trace('g_message_name ',g_message_name );
176: pay_in_utils.trace('**************************************************','********************');
177: END IF;
178:
171: );
172: --
173: IF g_debug THEN
174: pay_in_utils.trace('**************************************************','********************');
175: pay_in_utils.trace('g_message_name ',g_message_name );
176: pay_in_utils.trace('**************************************************','********************');
177: END IF;
178:
179: IF g_message_name <> 'SUCCESS' THEN
172: --
173: IF g_debug THEN
174: pay_in_utils.trace('**************************************************','********************');
175: pay_in_utils.trace('g_message_name ',g_message_name );
176: pay_in_utils.trace('**************************************************','********************');
177: END IF;
178:
179: IF g_message_name <> 'SUCCESS' THEN
180: pay_in_utils.set_location(g_debug,l_procedure,30);
176: pay_in_utils.trace('**************************************************','********************');
177: END IF;
178:
179: IF g_message_name <> 'SUCCESS' THEN
180: pay_in_utils.set_location(g_debug,l_procedure,30);
181: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
182: END IF;
183:
184: END IF ;
177: END IF;
178:
179: IF g_message_name <> 'SUCCESS' THEN
180: pay_in_utils.set_location(g_debug,l_procedure,30);
181: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
182: END IF;
183:
184: END IF ;
185: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
181: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
182: END IF;
183:
184: END IF ;
185: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
186:
187: END check_entry_value;
188:
189: --------------------------------------------------------------------------
260: BEGIN
261: --
262: l_procedure := g_package||'check_entry_value_del';
263: g_debug := hr_utility.debug_enabled;
264: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
265:
266:
267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
264: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
265:
266:
267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_effective_date ',p_effective_date );
270: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
271: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
272: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
265:
266:
267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_effective_date ',p_effective_date );
270: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
271: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
272: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
273: pay_in_utils.trace('p_assignment_id_o ',p_assignment_id_o );
266:
267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_effective_date ',p_effective_date );
270: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
271: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
272: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
273: pay_in_utils.trace('p_assignment_id_o ',p_assignment_id_o );
274: pay_in_utils.trace('**************************************************','********************');
267: IF g_debug THEN
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_effective_date ',p_effective_date );
270: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
271: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
272: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
273: pay_in_utils.trace('p_assignment_id_o ',p_assignment_id_o );
274: pay_in_utils.trace('**************************************************','********************');
275: END IF;
268: pay_in_utils.trace('**************************************************','********************');
269: pay_in_utils.trace('p_effective_date ',p_effective_date );
270: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
271: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
272: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
273: pay_in_utils.trace('p_assignment_id_o ',p_assignment_id_o );
274: pay_in_utils.trace('**************************************************','********************');
275: END IF;
276:
269: pay_in_utils.trace('p_effective_date ',p_effective_date );
270: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
271: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
272: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
273: pay_in_utils.trace('p_assignment_id_o ',p_assignment_id_o );
274: pay_in_utils.trace('**************************************************','********************');
275: END IF;
276:
277: g_message_name := 'SUCCESS';
270: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
271: pay_in_utils.trace('p_effective_start_date',p_effective_start_date);
272: pay_in_utils.trace('p_effective_end_date ',p_effective_end_date );
273: pay_in_utils.trace('p_assignment_id_o ',p_assignment_id_o );
274: pay_in_utils.trace('**************************************************','********************');
275: END IF;
276:
277: g_message_name := 'SUCCESS';
278: pay_in_utils.null_message (g_token_name, g_token_value);
274: pay_in_utils.trace('**************************************************','********************');
275: END IF;
276:
277: g_message_name := 'SUCCESS';
278: pay_in_utils.null_message (g_token_name, g_token_value);
279: --
280: -- Check whether PAY is installed for India Localization
281: --
282: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
280: -- Check whether PAY is installed for India Localization
281: --
282: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
283:
284: pay_in_utils.set_location(g_debug,l_procedure,20);
285:
286:
287: OPEN c_ele_name;
288: FETCH c_ele_name INTO l_ele_name;
324: ,p_token_value => g_token_value);
325:
326: --
327: IF g_debug THEN
328: pay_in_utils.trace('**************************************************','********************');
329: pay_in_utils.trace('g_message_name ',g_message_name );
330: pay_in_utils.trace('**************************************************','********************');
331: END IF;
332:
325:
326: --
327: IF g_debug THEN
328: pay_in_utils.trace('**************************************************','********************');
329: pay_in_utils.trace('g_message_name ',g_message_name );
330: pay_in_utils.trace('**************************************************','********************');
331: END IF;
332:
333: IF g_message_name <> 'SUCCESS' THEN
326: --
327: IF g_debug THEN
328: pay_in_utils.trace('**************************************************','********************');
329: pay_in_utils.trace('g_message_name ',g_message_name );
330: pay_in_utils.trace('**************************************************','********************');
331: END IF;
332:
333: IF g_message_name <> 'SUCCESS' THEN
334: pay_in_utils.set_location(g_debug,l_procedure,30);
330: pay_in_utils.trace('**************************************************','********************');
331: END IF;
332:
333: IF g_message_name <> 'SUCCESS' THEN
334: pay_in_utils.set_location(g_debug,l_procedure,30);
335: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
336: END IF;
337: END IF ;
338: END IF ;
331: END IF;
332:
333: IF g_message_name <> 'SUCCESS' THEN
334: pay_in_utils.set_location(g_debug,l_procedure,30);
335: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
336: END IF;
337: END IF ;
338: END IF ;
339: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
335: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
336: END IF;
337: END IF ;
338: END IF ;
339: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
340:
341: END check_entry_value_del;
342:
343: --------------------------------------------------------------------------
418: BEGIN
419:
420: l_procedure := g_package||'check_80cce_entry';
421: g_debug := hr_utility.debug_enabled;
422: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
423:
424: OPEN c_element_name;
425: FETCH c_element_name INTO l_element_name;
426: CLOSE c_element_name;
425: FETCH c_element_name INTO l_element_name;
426: CLOSE c_element_name;
427:
428: IF g_debug THEN
429: pay_in_utils.trace('**************************************************','********************');
430: pay_in_utils.trace('l_element_name ',l_element_name );
431: pay_in_utils.trace('**************************************************','********************');
432: END IF;
433:
426: CLOSE c_element_name;
427:
428: IF g_debug THEN
429: pay_in_utils.trace('**************************************************','********************');
430: pay_in_utils.trace('l_element_name ',l_element_name );
431: pay_in_utils.trace('**************************************************','********************');
432: END IF;
433:
434: IF l_element_name = 'Deduction under Section 80CCE' THEN
427:
428: IF g_debug THEN
429: pay_in_utils.trace('**************************************************','********************');
430: pay_in_utils.trace('l_element_name ',l_element_name );
431: pay_in_utils.trace('**************************************************','********************');
432: END IF;
433:
434: IF l_element_name = 'Deduction under Section 80CCE' THEN
435:
437: FETCH c_ppf_element_entry INTO l_ppf_element_entry_id;
438: CLOSE c_ppf_element_entry;
439:
440: IF g_debug THEN
441: pay_in_utils.trace('**************************************************','********************');
442: pay_in_utils.trace('l_ppf_element_entry_id ',l_ppf_element_entry_id );
443: pay_in_utils.trace('**************************************************','********************');
444: END IF;
445:
438: CLOSE c_ppf_element_entry;
439:
440: IF g_debug THEN
441: pay_in_utils.trace('**************************************************','********************');
442: pay_in_utils.trace('l_ppf_element_entry_id ',l_ppf_element_entry_id );
443: pay_in_utils.trace('**************************************************','********************');
444: END IF;
445:
446: IF l_ppf_element_entry_id IS NULL THEN
439:
440: IF g_debug THEN
441: pay_in_utils.trace('**************************************************','********************');
442: pay_in_utils.trace('l_ppf_element_entry_id ',l_ppf_element_entry_id );
443: pay_in_utils.trace('**************************************************','********************');
444: END IF;
445:
446: IF l_ppf_element_entry_id IS NULL THEN
447: RETURN;
455: FETCH get_ppf_max_exemption_limit INTO g_ppf_max_exemption_limit_80c;
456: CLOSE get_ppf_max_exemption_limit;
457:
458: IF g_debug THEN
459: pay_in_utils.trace('**************************************************','********************');
460: pay_in_utils.trace('l_ppf_amount ',l_ppf_amount );
461: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
462: pay_in_utils.trace('**************************************************','********************');
463: END IF;
456: CLOSE get_ppf_max_exemption_limit;
457:
458: IF g_debug THEN
459: pay_in_utils.trace('**************************************************','********************');
460: pay_in_utils.trace('l_ppf_amount ',l_ppf_amount );
461: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
462: pay_in_utils.trace('**************************************************','********************');
463: END IF;
464:
457:
458: IF g_debug THEN
459: pay_in_utils.trace('**************************************************','********************');
460: pay_in_utils.trace('l_ppf_amount ',l_ppf_amount );
461: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
462: pay_in_utils.trace('**************************************************','********************');
463: END IF;
464:
465: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN
458: IF g_debug THEN
459: pay_in_utils.trace('**************************************************','********************');
460: pay_in_utils.trace('l_ppf_amount ',l_ppf_amount );
461: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
462: pay_in_utils.trace('**************************************************','********************');
463: END IF;
464:
465: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN
466: pay_in_utils.trace('inside the error loop','********************');
462: pay_in_utils.trace('**************************************************','********************');
463: END IF;
464:
465: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN
466: pay_in_utils.trace('inside the error loop','********************');
467: fnd_message.set_name('PER', 'PER_IN_PPF_MAX_EXEMPTION_ERROR');
468: fnd_message.set_token('PPF_LIMIT',g_ppf_max_exemption_limit_80c);
469: fnd_message.raise_error;
470: END IF;
471: END IF;
472: END IF;
473:
474: IF g_debug THEN
475: pay_in_utils.trace('**************************************************','********************');
476: pay_in_utils.trace('p_effective_date ',p_effective_date );
477: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
478: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
479: pay_in_utils.trace('p_element_type_id ',p_element_type_id );
472: END IF;
473:
474: IF g_debug THEN
475: pay_in_utils.trace('**************************************************','********************');
476: pay_in_utils.trace('p_effective_date ',p_effective_date );
477: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
478: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
479: pay_in_utils.trace('p_element_type_id ',p_element_type_id );
480: pay_in_utils.trace('**************************************************','********************');
473:
474: IF g_debug THEN
475: pay_in_utils.trace('**************************************************','********************');
476: pay_in_utils.trace('p_effective_date ',p_effective_date );
477: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
478: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
479: pay_in_utils.trace('p_element_type_id ',p_element_type_id );
480: pay_in_utils.trace('**************************************************','********************');
481: END IF;
474: IF g_debug THEN
475: pay_in_utils.trace('**************************************************','********************');
476: pay_in_utils.trace('p_effective_date ',p_effective_date );
477: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
478: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
479: pay_in_utils.trace('p_element_type_id ',p_element_type_id );
480: pay_in_utils.trace('**************************************************','********************');
481: END IF;
482:
475: pay_in_utils.trace('**************************************************','********************');
476: pay_in_utils.trace('p_effective_date ',p_effective_date );
477: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
478: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
479: pay_in_utils.trace('p_element_type_id ',p_element_type_id );
480: pay_in_utils.trace('**************************************************','********************');
481: END IF;
482:
483: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
476: pay_in_utils.trace('p_effective_date ',p_effective_date );
477: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
478: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
479: pay_in_utils.trace('p_element_type_id ',p_element_type_id );
480: pay_in_utils.trace('**************************************************','********************');
481: END IF;
482:
483: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
484: END check_80cce_entry;
479: pay_in_utils.trace('p_element_type_id ',p_element_type_id );
480: pay_in_utils.trace('**************************************************','********************');
481: END IF;
482:
483: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
484: END check_80cce_entry;
485:
486: --------------------------------------------------------------------------
487: -- --
560: BEGIN
561:
562: l_procedure := g_package||'check_80cce_upd';
563: g_debug := hr_utility.debug_enabled;
564: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
565:
566: OPEN c_element_name;
567: FETCH c_element_name INTO l_element_name;
568: CLOSE c_element_name;
567: FETCH c_element_name INTO l_element_name;
568: CLOSE c_element_name;
569:
570: IF g_debug THEN
571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('l_element_name ',l_element_name);
573: pay_in_utils.trace('**************************************************','********************');
574: END IF;
575:
568: CLOSE c_element_name;
569:
570: IF g_debug THEN
571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('l_element_name ',l_element_name);
573: pay_in_utils.trace('**************************************************','********************');
574: END IF;
575:
576: IF l_element_name = 'Deduction under Section 80CCE' THEN
569:
570: IF g_debug THEN
571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('l_element_name ',l_element_name);
573: pay_in_utils.trace('**************************************************','********************');
574: END IF;
575:
576: IF l_element_name = 'Deduction under Section 80CCE' THEN
577:
579: FETCH c_ppf_element_entry INTO l_ppf_element_entry_id;
580: CLOSE c_ppf_element_entry;
581:
582: IF g_debug THEN
583: pay_in_utils.trace('**************************************************','********************');
584: pay_in_utils.trace('l_ppf_element_entry_id ',l_ppf_element_entry_id );
585: pay_in_utils.trace('**************************************************','********************');
586: END IF;
587:
580: CLOSE c_ppf_element_entry;
581:
582: IF g_debug THEN
583: pay_in_utils.trace('**************************************************','********************');
584: pay_in_utils.trace('l_ppf_element_entry_id ',l_ppf_element_entry_id );
585: pay_in_utils.trace('**************************************************','********************');
586: END IF;
587:
588: IF l_ppf_element_entry_id IS NULL THEN
581:
582: IF g_debug THEN
583: pay_in_utils.trace('**************************************************','********************');
584: pay_in_utils.trace('l_ppf_element_entry_id ',l_ppf_element_entry_id );
585: pay_in_utils.trace('**************************************************','********************');
586: END IF;
587:
588: IF l_ppf_element_entry_id IS NULL THEN
589: RETURN;
597: FETCH get_ppf_max_exemption_limit INTO g_ppf_max_exemption_limit_80c;
598: CLOSE get_ppf_max_exemption_limit;
599:
600: IF g_debug THEN
601: pay_in_utils.trace('**************************************************','********************');
602: pay_in_utils.trace('l_ppf_amount ',l_ppf_amount );
603: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
604: pay_in_utils.trace('**************************************************','********************');
605: END IF;
598: CLOSE get_ppf_max_exemption_limit;
599:
600: IF g_debug THEN
601: pay_in_utils.trace('**************************************************','********************');
602: pay_in_utils.trace('l_ppf_amount ',l_ppf_amount );
603: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
604: pay_in_utils.trace('**************************************************','********************');
605: END IF;
606:
599:
600: IF g_debug THEN
601: pay_in_utils.trace('**************************************************','********************');
602: pay_in_utils.trace('l_ppf_amount ',l_ppf_amount );
603: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
604: pay_in_utils.trace('**************************************************','********************');
605: END IF;
606:
607:
600: IF g_debug THEN
601: pay_in_utils.trace('**************************************************','********************');
602: pay_in_utils.trace('l_ppf_amount ',l_ppf_amount );
603: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
604: pay_in_utils.trace('**************************************************','********************');
605: END IF;
606:
607:
608: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN
605: END IF;
606:
607:
608: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN
609: pay_in_utils.trace('inside the error loop','********************');
610: fnd_message.set_name('PER', 'PER_IN_PPF_MAX_EXEMPTION_ERROR');
611: fnd_message.set_token('PPF_LIMIT',g_ppf_max_exemption_limit_80c);
612: fnd_message.raise_error;
613: END IF;
614: END IF;
615: END IF;
616:
617: IF g_debug THEN
618: pay_in_utils.trace('**************************************************','********************');
619: pay_in_utils.trace('p_effective_date ',p_effective_date );
620: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
621: pay_in_utils.trace('p_assignment_id_O ',p_assignment_id_O );
622: pay_in_utils.trace('p_element_type_id_O ',p_element_type_id_O );
615: END IF;
616:
617: IF g_debug THEN
618: pay_in_utils.trace('**************************************************','********************');
619: pay_in_utils.trace('p_effective_date ',p_effective_date );
620: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
621: pay_in_utils.trace('p_assignment_id_O ',p_assignment_id_O );
622: pay_in_utils.trace('p_element_type_id_O ',p_element_type_id_O );
623: pay_in_utils.trace('**************************************************','********************');
616:
617: IF g_debug THEN
618: pay_in_utils.trace('**************************************************','********************');
619: pay_in_utils.trace('p_effective_date ',p_effective_date );
620: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
621: pay_in_utils.trace('p_assignment_id_O ',p_assignment_id_O );
622: pay_in_utils.trace('p_element_type_id_O ',p_element_type_id_O );
623: pay_in_utils.trace('**************************************************','********************');
624: END IF;
617: IF g_debug THEN
618: pay_in_utils.trace('**************************************************','********************');
619: pay_in_utils.trace('p_effective_date ',p_effective_date );
620: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
621: pay_in_utils.trace('p_assignment_id_O ',p_assignment_id_O );
622: pay_in_utils.trace('p_element_type_id_O ',p_element_type_id_O );
623: pay_in_utils.trace('**************************************************','********************');
624: END IF;
625:
618: pay_in_utils.trace('**************************************************','********************');
619: pay_in_utils.trace('p_effective_date ',p_effective_date );
620: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
621: pay_in_utils.trace('p_assignment_id_O ',p_assignment_id_O );
622: pay_in_utils.trace('p_element_type_id_O ',p_element_type_id_O );
623: pay_in_utils.trace('**************************************************','********************');
624: END IF;
625:
626: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
619: pay_in_utils.trace('p_effective_date ',p_effective_date );
620: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
621: pay_in_utils.trace('p_assignment_id_O ',p_assignment_id_O );
622: pay_in_utils.trace('p_element_type_id_O ',p_element_type_id_O );
623: pay_in_utils.trace('**************************************************','********************');
624: END IF;
625:
626: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
627: END check_80cce_upd;
622: pay_in_utils.trace('p_element_type_id_O ',p_element_type_id_O );
623: pay_in_utils.trace('**************************************************','********************');
624: END IF;
625:
626: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
627: END check_80cce_upd;
628:
629:
630: END per_in_entry_value_leg_hook;