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: END per_in_entry_value_leg_hook;