6: --
7: g_package constant VARCHAR2(100) := 'per_in_person_term_leg_hook.' ;
8: g_debug BOOLEAN ;
9: g_message_name VARCHAR2(30);
10: g_token_name pay_in_utils.char_tab_type;
11: g_token_value pay_in_utils.char_tab_type;
12:
13: --------------------------------------------------------------------------
14: -- --
7: g_package constant VARCHAR2(100) := 'per_in_person_term_leg_hook.' ;
8: g_debug BOOLEAN ;
9: g_message_name VARCHAR2(30);
10: g_token_name pay_in_utils.char_tab_type;
11: g_token_value pay_in_utils.char_tab_type;
12:
13: --------------------------------------------------------------------------
14: -- --
15: -- Name : ACTUAL_TERMINATION_EMP_INT --
35: ,p_actual_termination_date IN DATE
36: ,p_business_group_id IN NUMBER
37: ,p_calling_procedure IN VARCHAR2
38: ,p_message_name OUT NOCOPY VARCHAR2
39: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
40: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
41: IS
42:
43: --
36: ,p_business_group_id IN NUMBER
37: ,p_calling_procedure IN VARCHAR2
38: ,p_message_name OUT NOCOPY VARCHAR2
39: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
40: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
41: IS
42:
43: --
44: l_procedure VARCHAR2(100);
48: BEGIN
49: --
50: g_debug := hr_utility.debug_enabled ;
51: l_procedure := g_package || 'actual_termination_emp_int' ;
52: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
53:
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
51: l_procedure := g_package || 'actual_termination_emp_int' ;
52: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
53:
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
52: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
53:
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
53:
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
54: if g_debug then
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
55: pay_in_utils.trace('******************************','********************');
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
63:
56: pay_in_utils.trace('p_effective_date : ',p_effective_date);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
63:
64: pay_in_utils.null_message(g_token_name, g_token_value);
57: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
58: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
59: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
63:
64: pay_in_utils.null_message(g_token_name, g_token_value);
65: g_message_name := 'SUCCESS';
60: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
61: pay_in_utils.trace('******************************','********************');
62: end if;
63:
64: pay_in_utils.null_message(g_token_name, g_token_value);
65: g_message_name := 'SUCCESS';
66:
67: pay_in_termination_pkg.create_termination_elements
68: (p_period_of_service_id => p_period_of_service_id
73: ,p_token_name => p_token_name
74: ,p_token_value => p_token_value);
75:
76: if g_debug then
77: pay_in_utils.trace('******************************','********************');
78: pay_in_utils.trace('p_message_name : ',p_message_name);
79: pay_in_utils.trace('******************************','********************');
80: end if;
81:
74: ,p_token_value => p_token_value);
75:
76: if g_debug then
77: pay_in_utils.trace('******************************','********************');
78: pay_in_utils.trace('p_message_name : ',p_message_name);
79: pay_in_utils.trace('******************************','********************');
80: end if;
81:
82: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
75:
76: if g_debug then
77: pay_in_utils.trace('******************************','********************');
78: pay_in_utils.trace('p_message_name : ',p_message_name);
79: pay_in_utils.trace('******************************','********************');
80: end if;
81:
82: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
83:
78: pay_in_utils.trace('p_message_name : ',p_message_name);
79: pay_in_utils.trace('******************************','********************');
80: end if;
81:
82: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
83:
84: --
85: END actual_termination_emp_int ;
86:
109: ,p_actual_termination_date IN DATE
110: ,p_business_group_id IN NUMBER
111: ,p_calling_procedure IN VARCHAR2
112: ,p_message_name OUT NOCOPY VARCHAR2
113: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
114: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
115: )
116: IS
117: l_procedure VARCHAR2(100);
110: ,p_business_group_id IN NUMBER
111: ,p_calling_procedure IN VARCHAR2
112: ,p_message_name OUT NOCOPY VARCHAR2
113: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
114: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
115: )
116: IS
117: l_procedure VARCHAR2(100);
118: l_message VARCHAR2(255);
120: BEGIN
121: --
122: g_debug := hr_utility.debug_enabled ;
123: l_procedure := g_package || 'reverse_termination_emp_int' ;
124: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
125:
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
123: l_procedure := g_package || 'reverse_termination_emp_int' ;
124: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
125:
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
124: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
125:
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
125:
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
126: if g_debug then
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
127: pay_in_utils.trace('******************************','********************');
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
135:
128: pay_in_utils.trace('p_effective_date : ',p_effective_date);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
135:
136: pay_in_utils.null_message(g_token_name, g_token_value);
129: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
130: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
131: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
135:
136: pay_in_utils.null_message(g_token_name, g_token_value);
137: g_message_name := 'SUCCESS';
132: pay_in_utils.trace('p_calling_procedure : ',p_calling_procedure);
133: pay_in_utils.trace('******************************','********************');
134: end if;
135:
136: pay_in_utils.null_message(g_token_name, g_token_value);
137: g_message_name := 'SUCCESS';
138:
139: pay_in_termination_pkg.delete_termination_elements
140: (p_period_of_service_id => p_period_of_service_id
145: ,p_token_name => p_token_name
146: ,p_token_value => p_token_value);
147:
148: if g_debug then
149: pay_in_utils.trace('******************************','********************');
150: pay_in_utils.trace('p_message_name : ',p_message_name);
151: pay_in_utils.trace('******************************','********************');
152: end if;
153:
146: ,p_token_value => p_token_value);
147:
148: if g_debug then
149: pay_in_utils.trace('******************************','********************');
150: pay_in_utils.trace('p_message_name : ',p_message_name);
151: pay_in_utils.trace('******************************','********************');
152: end if;
153:
154: --
147:
148: if g_debug then
149: pay_in_utils.trace('******************************','********************');
150: pay_in_utils.trace('p_message_name : ',p_message_name);
151: pay_in_utils.trace('******************************','********************');
152: end if;
153:
154: --
155: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
151: pay_in_utils.trace('******************************','********************');
152: end if;
153:
154: --
155: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
156:
157: --
158: END reverse_termination_emp_int ;
159:
205: --
206:
207: g_debug := hr_utility.debug_enabled ;
208: l_procedure := g_package || 'actual_termination_emp';
209: pay_in_utils.set_location(g_debug,'Entering: '|| l_procedure,10);
210:
211: IF g_debug
212: THEN
213: pay_in_utils.trace('******************************','********************');
209: pay_in_utils.set_location(g_debug,'Entering: '|| l_procedure,10);
210:
211: IF g_debug
212: THEN
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
210:
211: IF g_debug
212: THEN
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
211: IF g_debug
212: THEN
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
219: END IF;
212: THEN
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
219: END IF;
220:
213: pay_in_utils.trace('******************************','********************');
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
219: END IF;
220:
221: OPEN c_pds_details;
214: pay_in_utils.trace('p_effective_date : ',p_effective_date);
215: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
216: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
217: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
218: pay_in_utils.trace('******************************','********************');
219: END IF;
220:
221: OPEN c_pds_details;
222: FETCH c_pds_details INTO l_final_process_date,l_actual_termination_date;
221: OPEN c_pds_details;
222: FETCH c_pds_details INTO l_final_process_date,l_actual_termination_date;
223: CLOSE c_pds_details;
224:
225: pay_in_utils.trace('l_final_process_date : ',l_final_process_date);
226: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
227:
228: g_message_name := 'SUCCESS';
229: pay_in_utils.null_message (g_token_name, g_token_value);
222: FETCH c_pds_details INTO l_final_process_date,l_actual_termination_date;
223: CLOSE c_pds_details;
224:
225: pay_in_utils.trace('l_final_process_date : ',l_final_process_date);
226: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
227:
228: g_message_name := 'SUCCESS';
229: pay_in_utils.null_message (g_token_name, g_token_value);
230: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
225: pay_in_utils.trace('l_final_process_date : ',l_final_process_date);
226: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
227:
228: g_message_name := 'SUCCESS';
229: pay_in_utils.null_message (g_token_name, g_token_value);
230: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
231: IF (l_final_process_date IS NULL)
232: THEN
233: actual_termination_emp_int
241: ,p_token_value => g_token_value
242: ) ;
243: END IF;
244: END IF;
245: pay_in_utils.set_location(g_debug,'Leaving: '|| l_procedure,30);
246: RETURN;
247: END actual_termination_emp ;
248:
249: --------------------------------------------------------------------------
289: --
290: g_debug := hr_utility.debug_enabled ;
291:
292: l_procedure := g_package || 'final_process_emp' ;
293: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
294:
295: if g_debug then
296: pay_in_utils.trace('******************************','********************');
297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
292: l_procedure := g_package || 'final_process_emp' ;
293: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
294:
295: if g_debug then
296: pay_in_utils.trace('******************************','********************');
297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
298: pay_in_utils.trace('******************************','********************');
299: end if;
300:
293: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
294:
295: if g_debug then
296: pay_in_utils.trace('******************************','********************');
297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
298: pay_in_utils.trace('******************************','********************');
299: end if;
300:
301: g_message_name := 'SUCCESS';
294:
295: if g_debug then
296: pay_in_utils.trace('******************************','********************');
297: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
298: pay_in_utils.trace('******************************','********************');
299: end if;
300:
301: g_message_name := 'SUCCESS';
302: pay_in_utils.null_message (g_token_name, g_token_value);
298: pay_in_utils.trace('******************************','********************');
299: end if;
300:
301: g_message_name := 'SUCCESS';
302: pay_in_utils.null_message (g_token_name, g_token_value);
303: --
304: -- Check if PAY is installed for India Localization
305: --
306: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
304: -- Check if PAY is installed for India Localization
305: --
306: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
307:
308: pay_in_utils.set_location(g_debug,l_procedure,20);
309:
310: OPEN c_pos_dtls;
311: FETCH c_pos_dtls
312: INTO l_business_group_id, l_actual_termination_date;
313: CLOSE c_pos_dtls;
314:
315:
316: if g_debug then
317: pay_in_utils.trace('l_effective_date : ',l_effective_date);
318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
320: end if;
321:
314:
315:
316: if g_debug then
317: pay_in_utils.trace('l_effective_date : ',l_effective_date);
318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
320: end if;
321:
322: pay_in_utils.set_location(g_debug,l_procedure,25);
315:
316: if g_debug then
317: pay_in_utils.trace('l_effective_date : ',l_effective_date);
318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
320: end if;
321:
322: pay_in_utils.set_location(g_debug,l_procedure,25);
323:
318: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
319: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
320: end if;
321:
322: pay_in_utils.set_location(g_debug,l_procedure,25);
323:
324: actual_termination_emp_int
325: (p_effective_date => l_effective_date
326: ,p_period_of_service_id => p_period_of_service_id
334: --
335: END IF ;
336:
337: if g_debug then
338: pay_in_utils.trace('******************************','********************');
339: pay_in_utils.trace('g_message_name : ',g_message_name);
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
335: END IF ;
336:
337: if g_debug then
338: pay_in_utils.trace('******************************','********************');
339: pay_in_utils.trace('g_message_name : ',g_message_name);
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
336:
337: if g_debug then
338: pay_in_utils.trace('******************************','********************');
339: pay_in_utils.trace('g_message_name : ',g_message_name);
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
344: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
339: pay_in_utils.trace('g_message_name : ',g_message_name);
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
344: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
345: --
346: END final_process_emp ;
347:
340: pay_in_utils.trace('******************************','********************');
341: end if;
342:
343: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
344: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
345: --
346: END final_process_emp ;
347:
348: --------------------------------------------------------------------------
378: --
379: g_debug := hr_utility.debug_enabled ;
380:
381: l_procedure := g_package || 'reverse_termination_emp' ;
382: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
383:
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
381: l_procedure := g_package || 'reverse_termination_emp' ;
382: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
383:
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
382: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
383:
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
383:
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
391: end if;
384: if g_debug then
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
391: end if;
392:
385: pay_in_utils.trace('******************************','********************');
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
391: end if;
392:
393: g_message_name := 'SUCCESS';
386: pay_in_utils.trace('p_effective_date : ',p_effective_date);
387: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
388: pay_in_utils.trace('p_actual_termination_date : ',p_actual_termination_date);
389: pay_in_utils.trace('p_business_group_id : ',p_business_group_id);
390: pay_in_utils.trace('******************************','********************');
391: end if;
392:
393: g_message_name := 'SUCCESS';
394: pay_in_utils.null_message (g_token_name, g_token_value);
390: pay_in_utils.trace('******************************','********************');
391: end if;
392:
393: g_message_name := 'SUCCESS';
394: pay_in_utils.null_message (g_token_name, g_token_value);
395: --
396: -- Check if PAY is installed for India Localization
397: --
398: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
396: -- Check if PAY is installed for India Localization
397: --
398: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
399:
400: pay_in_utils.set_location(g_debug,l_procedure,20);
401:
402: reverse_termination_emp_int
403: (p_effective_date => p_effective_date
404: ,p_period_of_service_id => p_period_of_service_id
412: --
413: END IF ;
414:
415: if g_debug then
416: pay_in_utils.trace('******************************','********************');
417: pay_in_utils.trace('g_message_name : ',g_message_name);
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
413: END IF ;
414:
415: if g_debug then
416: pay_in_utils.trace('******************************','********************');
417: pay_in_utils.trace('g_message_name : ',g_message_name);
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
414:
415: if g_debug then
416: pay_in_utils.trace('******************************','********************');
417: pay_in_utils.trace('g_message_name : ',g_message_name);
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
422: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
417: pay_in_utils.trace('g_message_name : ',g_message_name);
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
422: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
423:
424: --
425: END reverse_termination_emp ;
418: pay_in_utils.trace('******************************','********************');
419: end if;
420:
421: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
422: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
423:
424: --
425: END reverse_termination_emp ;
426:
473: BEGIN
474: --
475: g_debug := hr_utility.debug_enabled ;
476: l_procedure := g_package || 'update_pds_details' ;
477: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
478:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
476: l_procedure := g_package || 'update_pds_details' ;
477: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
478:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
477: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
478:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
485: end if;
478:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
485: end if;
486:
479: if g_debug then
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
485: end if;
486:
487: g_message_name := 'SUCCESS';
480: pay_in_utils.trace('******************************','********************');
481: pay_in_utils.trace('p_period_of_service_id : ',p_period_of_service_id);
482: pay_in_utils.trace('p_effective_date : ',p_effective_date);
483: pay_in_utils.trace('p_leaving_reason : ',p_leaving_reason);
484: pay_in_utils.trace('******************************','********************');
485: end if;
486:
487: g_message_name := 'SUCCESS';
488:
487: g_message_name := 'SUCCESS';
488:
489: pay_in_termination_pkg.g_leaving_reason := p_leaving_reason;
490:
491: pay_in_utils.null_message (g_token_name, g_token_value);
492: --
493: -- Check if PAY is installed for India Localization
494: --
495:
494: --
495:
496: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
497:
498: pay_in_utils.set_location(g_debug,l_procedure,20);
499: OPEN c_pos_dtls;
500: FETCH c_pos_dtls
501: INTO l_actual_termination_date, l_business_group_id;
502: CLOSE c_pos_dtls;
501: INTO l_actual_termination_date, l_business_group_id;
502: CLOSE c_pos_dtls;
503:
504: if g_debug then
505: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
506: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
507: end if;
508:
509: pay_in_utils.set_location(g_debug,l_procedure,30);
502: CLOSE c_pos_dtls;
503:
504: if g_debug then
505: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
506: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
507: end if;
508:
509: pay_in_utils.set_location(g_debug,l_procedure,30);
510: pay_in_termination_pkg.delete_gratuity_entry
505: pay_in_utils.trace('l_business_group_id : ',l_business_group_id);
506: pay_in_utils.trace('l_actual_termination_date : ',l_actual_termination_date);
507: end if;
508:
509: pay_in_utils.set_location(g_debug,l_procedure,30);
510: pay_in_termination_pkg.delete_gratuity_entry
511: (p_period_of_service_id => p_period_of_service_id
512: ,p_business_group_id => l_business_group_id
513: ,p_actual_termination_date => l_actual_termination_date
517: ,p_token_value => g_token_value
518: );
519:
520: if g_debug then
521: pay_in_utils.trace('******************************','********************');
522: pay_in_utils.trace('g_message_name : ',g_message_name);
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
518: );
519:
520: if g_debug then
521: pay_in_utils.trace('******************************','********************');
522: pay_in_utils.trace('g_message_name : ',g_message_name);
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
519:
520: if g_debug then
521: pay_in_utils.trace('******************************','********************');
522: pay_in_utils.trace('g_message_name : ',g_message_name);
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
522: pay_in_utils.trace('g_message_name : ',g_message_name);
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
528: g_message_name := 'SUCCESS';
529: pay_in_utils.null_message (g_token_name, g_token_value);
530:
523: pay_in_utils.trace('******************************','********************');
524: end if;
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
528: g_message_name := 'SUCCESS';
529: pay_in_utils.null_message (g_token_name, g_token_value);
530:
531:
525:
526: pay_in_utils.set_location(g_debug,l_procedure,40);
527: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
528: g_message_name := 'SUCCESS';
529: pay_in_utils.null_message (g_token_name, g_token_value);
530:
531:
532:
533: pay_in_termination_pkg.create_gratuity_entry
540: ,p_token_value => g_token_value
541: );
542:
543: if g_debug then
544: pay_in_utils.trace('******************************','********************');
545: pay_in_utils.trace('g_message_name : ',g_message_name);
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
541: );
542:
543: if g_debug then
544: pay_in_utils.trace('******************************','********************');
545: pay_in_utils.trace('g_message_name : ',g_message_name);
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
549: pay_in_utils.set_location(g_debug,l_procedure,50);
542:
543: if g_debug then
544: pay_in_utils.trace('******************************','********************');
545: pay_in_utils.trace('g_message_name : ',g_message_name);
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
549: pay_in_utils.set_location(g_debug,l_procedure,50);
550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
545: pay_in_utils.trace('g_message_name : ',g_message_name);
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
549: pay_in_utils.set_location(g_debug,l_procedure,50);
550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
551:
552: END IF ;
553:
546: pay_in_utils.trace('******************************','********************');
547: end if;
548:
549: pay_in_utils.set_location(g_debug,l_procedure,50);
550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
551:
552: END IF ;
553:
554: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
550: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
551:
552: END IF ;
553:
554: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
555:
556: END update_pds_details;
557:
558: END per_in_person_term_leg_hook;