6: --
7: g_package constant VARCHAR2(100) := 'per_in_disability_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_disability_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 : EMP_DISABILITY_INT --
49: ,p_degree IN NUMBER
50: ,p_dis_information1 IN VARCHAR2
51: ,p_calling_procedure IN VARCHAR2
52: ,p_message_name OUT NOCOPY VARCHAR2
53: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
54: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
55: IS
56:
57: --
50: ,p_dis_information1 IN VARCHAR2
51: ,p_calling_procedure IN VARCHAR2
52: ,p_message_name OUT NOCOPY VARCHAR2
53: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
54: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
55: IS
56:
57: --
58: l_procedure VARCHAR2(100);
86: BEGIN
87: --
88: g_debug := hr_utility.debug_enabled;
89: l_procedure := g_package || 'emp_disability_int';
90: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
91:
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
89: l_procedure := g_package || 'emp_disability_int';
90: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
91:
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
90: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
91:
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
91:
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
92: IF g_debug THEN
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
93: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
94: pay_in_utils.trace('p_effective_date',p_effective_date);
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
95: pay_in_utils.trace('p_person_id',p_person_id);
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
103:
96: pay_in_utils.trace('p_category',p_category);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
103:
104: pay_in_utils.null_message(p_token_name, p_token_value);
97: pay_in_utils.trace('p_status',p_status);
98: pay_in_utils.trace('p_degree',p_degree);
99: pay_in_utils.trace('p_dis_information1',p_dis_information1);
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
103:
104: pay_in_utils.null_message(p_token_name, p_token_value);
105: p_message_name := 'SUCCESS';
100: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
101: pay_in_utils.trace('**************************************************','********************');
102: END IF;
103:
104: pay_in_utils.null_message(p_token_name, p_token_value);
105: p_message_name := 'SUCCESS';
106: --
107: pay_in_utils.set_location(g_debug, l_procedure, 20);
108: --
103:
104: pay_in_utils.null_message(p_token_name, p_token_value);
105: p_message_name := 'SUCCESS';
106: --
107: pay_in_utils.set_location(g_debug, l_procedure, 20);
108: --
109: OPEN c_asg_details;
110: FETCH c_asg_details INTO l_assignment_id;
111: CLOSE c_asg_details;
109: OPEN c_asg_details;
110: FETCH c_asg_details INTO l_assignment_id;
111: CLOSE c_asg_details;
112: --
113: pay_in_utils.set_location(g_debug, l_procedure, 30);
114: --
115:
116: IF p_dis_information1 = 'Y' AND
117: p_degree >= 40 AND
117: p_degree >= 40 AND
118: p_category IN ('BLIND','SA_VIS_IMP','LC','SA_HEA_IMP','LD','07','MI','AU','CP','MD')
119: THEN
120: --
121: pay_in_utils.set_location(g_debug, l_procedure, 50);
122: --
123:
124: pay_in_tax_declaration.declare_section80u
125: (p_assignment_id => l_assignment_id
126: ,p_effective_date => p_effective_date
127: ,p_warnings => l_warning
128: );
129: --
130: pay_in_utils.set_location(g_debug, l_procedure, 60);
131: --
132: END IF;
133: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure, 100);
134:
129: --
130: pay_in_utils.set_location(g_debug, l_procedure, 60);
131: --
132: END IF;
133: pay_in_utils.set_location(g_debug, 'Leaving: '||l_procedure, 100);
134:
135: END emp_disability_int;
136:
137: --------------------------------------------------------------------------
175: --
176: g_debug := hr_utility.debug_enabled ;
177:
178: l_procedure := g_package || 'emp_disability_create' ;
179: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
180: g_message_name := 'SUCCESS';
181: pay_in_utils.null_message (g_token_name, g_token_value);
182:
183: IF g_debug THEN
177:
178: l_procedure := g_package || 'emp_disability_create' ;
179: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
180: g_message_name := 'SUCCESS';
181: pay_in_utils.null_message (g_token_name, g_token_value);
182:
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
180: g_message_name := 'SUCCESS';
181: pay_in_utils.null_message (g_token_name, g_token_value);
182:
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
181: pay_in_utils.null_message (g_token_name, g_token_value);
182:
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
182:
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
183: IF g_debug THEN
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
184: pay_in_utils.trace('**************************************************','********************');
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
192: END IF;
185: pay_in_utils.trace('p_effective_date',p_effective_date);
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
192: END IF;
193: --
186: pay_in_utils.trace('p_person_id',p_person_id);
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
192: END IF;
193: --
194: -- Check if PAY is installed for India Localization
187: pay_in_utils.trace('p_category',p_category);
188: pay_in_utils.trace('p_status',p_status);
189: pay_in_utils.trace('p_degree',p_degree);
190: pay_in_utils.trace('p_dis_information1',p_dis_information1);
191: pay_in_utils.trace('**************************************************','********************');
192: END IF;
193: --
194: -- Check if PAY is installed for India Localization
195: --
194: -- Check if PAY is installed for India Localization
195: --
196: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
197:
198: pay_in_utils.set_location(g_debug,l_procedure,20);
199:
200: emp_disability_int
201: (p_effective_date => p_effective_date
202: ,p_person_id => p_person_id
211: );
212:
213: --
214: END IF ;
215: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
216: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
217: --
218: END emp_disability_create;
219:
212:
213: --
214: END IF ;
215: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
216: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
217: --
218: END emp_disability_create;
219:
220: --------------------------------------------------------------------------
269: --
270: g_debug := hr_utility.debug_enabled ;
271:
272: l_procedure := g_package || 'emp_disability_update' ;
273: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
274: g_message_name := 'SUCCESS';
275: pay_in_utils.null_message (g_token_name, g_token_value);
276:
277: IF g_debug THEN
271:
272: l_procedure := g_package || 'emp_disability_update' ;
273: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
274: g_message_name := 'SUCCESS';
275: pay_in_utils.null_message (g_token_name, g_token_value);
276:
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
274: g_message_name := 'SUCCESS';
275: pay_in_utils.null_message (g_token_name, g_token_value);
276:
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
275: pay_in_utils.null_message (g_token_name, g_token_value);
276:
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
276:
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
277: IF g_debug THEN
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
278: pay_in_utils.trace('**************************************************','********************');
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
286: END IF;
279: pay_in_utils.trace('p_effective_date',p_effective_date);
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
286: END IF;
287: --
280: pay_in_utils.trace('p_disability_id',p_disability_id);
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
286: END IF;
287: --
288: -- Check if PAY is installed for India Localization
281: pay_in_utils.trace('p_category',p_category);
282: pay_in_utils.trace('p_status',p_status);
283: pay_in_utils.trace('p_degree',p_degree);
284: pay_in_utils.trace('p_dis_information1',p_dis_information1);
285: pay_in_utils.trace('**************************************************','********************');
286: END IF;
287: --
288: -- Check if PAY is installed for India Localization
289: --
288: -- Check if PAY is installed for India Localization
289: --
290: IF hr_utility.chk_product_install('Oracle Payroll','IN') THEN
291:
292: pay_in_utils.set_location(g_debug,l_procedure,20);
293:
294: OPEN c_person_id;
295: FETCH c_person_id INTO l_person_id,l_category,l_status,l_degree,l_dis_information1;
296: CLOSE c_person_id;
294: OPEN c_person_id;
295: FETCH c_person_id INTO l_person_id,l_category,l_status,l_degree,l_dis_information1;
296: CLOSE c_person_id;
297:
298: pay_in_utils.set_location(g_debug,l_procedure,30);
299:
300: IF p_category <> hr_api.g_varchar2 THEN
301: l_category := p_category;
302: END IF;
329:
330: --
331: END IF ;
332:
333: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
334: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
335: --
336: END emp_disability_update;
337:
330: --
331: END IF ;
332:
333: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
334: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
335: --
336: END emp_disability_update;
337:
338: END per_in_disability_leg_hook;