[Home] [Help]
55: BEGIN
56: g_debug := hr_utility.debug_enabled;
57: l_proc := g_package||'get_parameters';
58:
59: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
60:
61: if g_debug then
62: pay_in_utils.trace('******************************','********************');
63: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
58:
59: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
60:
61: if g_debug then
62: pay_in_utils.trace('******************************','********************');
63: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
64: pay_in_utils.trace('p_token_name : ',p_token_name);
65: pay_in_utils.trace('******************************','********************');
66: end if;
59: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
60:
61: if g_debug then
62: pay_in_utils.trace('******************************','********************');
63: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
64: pay_in_utils.trace('p_token_name : ',p_token_name);
65: pay_in_utils.trace('******************************','********************');
66: end if;
67:
60:
61: if g_debug then
62: pay_in_utils.trace('******************************','********************');
63: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
64: pay_in_utils.trace('p_token_name : ',p_token_name);
65: pay_in_utils.trace('******************************','********************');
66: end if;
67:
68: OPEN csr_parameter_info(p_payroll_action_id,
61: if g_debug then
62: pay_in_utils.trace('******************************','********************');
63: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
64: pay_in_utils.trace('p_token_name : ',p_token_name);
65: pay_in_utils.trace('******************************','********************');
66: end if;
67:
68: OPEN csr_parameter_info(p_payroll_action_id,
69: p_token_name);
70: FETCH csr_parameter_info INTO l_token_value,l_bg_id;
71: CLOSE csr_parameter_info;
72:
73: if g_debug then
74: pay_in_utils.trace('l_token_value : ',l_token_value);
75: pay_in_utils.trace('l_bg_id : ',l_bg_id);
76: end if;
77:
78: p_token_value := TRIM(l_token_value);
71: CLOSE csr_parameter_info;
72:
73: if g_debug then
74: pay_in_utils.trace('l_token_value : ',l_token_value);
75: pay_in_utils.trace('l_bg_id : ',l_bg_id);
76: end if;
77:
78: p_token_value := TRIM(l_token_value);
79:
77:
78: p_token_value := TRIM(l_token_value);
79:
80: if g_debug then
81: pay_in_utils.trace('p_token_value before : ',p_token_value);
82: end if;
83:
84: IF (p_token_name = 'BG_ID') THEN
85: p_token_value := l_bg_id;
89: p_token_value := '%';
90: END IF;
91:
92: if g_debug then
93: pay_in_utils.trace('p_token_value after : ',p_token_value);
94: end if;
95:
96: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,20);
97:
92: if g_debug then
93: pay_in_utils.trace('p_token_value after : ',p_token_value);
94: end if;
95:
96: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,20);
97:
98: END get_parameters;
99:
100: --------------------------------------------------------------------------
166: AND ppa.payroll_action_id <> p_payroll_action_id
167: AND hou.organization_id = pai.action_information1
168: AND hou.business_group_id = p_bg_id;
169:
170: l_token_name pay_in_utils.char_tab_type;
171: l_token_value pay_in_utils.char_tab_type;
172:
173: BEGIN
174: --
167: AND hou.organization_id = pai.action_information1
168: AND hou.business_group_id = p_bg_id;
169:
170: l_token_name pay_in_utils.char_tab_type;
171: l_token_value pay_in_utils.char_tab_type;
172:
173: BEGIN
174: --
175:
175:
176: g_debug := hr_utility.debug_enabled;
177: l_proc := g_package || 'initialization_code';
178:
179: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
180:
181: if g_debug then
182: pay_in_utils.trace('******************************','********************');
183: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
178:
179: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
180:
181: if g_debug then
182: pay_in_utils.trace('******************************','********************');
183: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
184: pay_in_utils.trace('******************************','********************');
185: end if;
186:
179: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
180:
181: if g_debug then
182: pay_in_utils.trace('******************************','********************');
183: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
184: pay_in_utils.trace('******************************','********************');
185: end if;
186:
187: get_parameters(p_payroll_action_id,'YR',g_year);
180:
181: if g_debug then
182: pay_in_utils.trace('******************************','********************');
183: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
184: pay_in_utils.trace('******************************','********************');
185: end if;
186:
187: get_parameters(p_payroll_action_id,'YR',g_year);
188: get_parameters(p_payroll_action_id,'GRE',g_gre_id);
190: get_parameters(p_payroll_action_id,'RN',g_archive_ref_no);
191: get_parameters(p_payroll_action_id,'BG_ID',g_bg_id);
192:
193: if g_debug then
194: pay_in_utils.trace('g_year : ',g_year);
195: pay_in_utils.trace('g_gre_id : ',g_gre_id);
196: pay_in_utils.trace('g_quarter : ',g_quarter);
197: pay_in_utils.trace('g_bg_id : ',g_bg_id);
198: end if;
191: get_parameters(p_payroll_action_id,'BG_ID',g_bg_id);
192:
193: if g_debug then
194: pay_in_utils.trace('g_year : ',g_year);
195: pay_in_utils.trace('g_gre_id : ',g_gre_id);
196: pay_in_utils.trace('g_quarter : ',g_quarter);
197: pay_in_utils.trace('g_bg_id : ',g_bg_id);
198: end if;
199:
192:
193: if g_debug then
194: pay_in_utils.trace('g_year : ',g_year);
195: pay_in_utils.trace('g_gre_id : ',g_gre_id);
196: pay_in_utils.trace('g_quarter : ',g_quarter);
197: pay_in_utils.trace('g_bg_id : ',g_bg_id);
198: end if;
199:
200: l_arch_ref_no_check := 0;
193: if g_debug then
194: pay_in_utils.trace('g_year : ',g_year);
195: pay_in_utils.trace('g_gre_id : ',g_gre_id);
196: pay_in_utils.trace('g_quarter : ',g_quarter);
197: pay_in_utils.trace('g_bg_id : ',g_bg_id);
198: end if;
199:
200: l_arch_ref_no_check := 0;
201: OPEN csr_arch_ref_no(p_payroll_action_id
213: FROM fnd_sessions
214: WHERE session_id = USERENV('sessionid');
215:
216: if g_debug then
217: pay_in_utils.trace('g_session_date : ',g_session_date);
218: end if;
219:
220: i := TO_NUMBER(SUBSTR(g_quarter,2,1)) - 1;
221: l_assess_yr_start := fnd_date.string_to_date(('01/04/'|| SUBSTR(g_year,1,4)),'DD/MM/YYYY');
222: g_tax_year := TO_CHAR((TO_NUMBER(SUBSTR(g_year,1,4)) - 1)||'-'||SUBSTR(g_year,1,4));
223: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
224:
225: if g_debug then
226: pay_in_utils.trace('i : ',i);
227: pay_in_utils.trace('l_assess_yr_start : ',l_assess_yr_start);
228: pay_in_utils.trace('g_tax_year : ',g_tax_year);
229: pay_in_utils.trace('l_end_date : ',l_end_date);
230: end if;
223: l_end_date := fnd_date.string_to_date(('31/03/'|| SUBSTR(g_year,6)),'DD/MM/YYYY');
224:
225: if g_debug then
226: pay_in_utils.trace('i : ',i);
227: pay_in_utils.trace('l_assess_yr_start : ',l_assess_yr_start);
228: pay_in_utils.trace('g_tax_year : ',g_tax_year);
229: pay_in_utils.trace('l_end_date : ',l_end_date);
230: end if;
231:
224:
225: if g_debug then
226: pay_in_utils.trace('i : ',i);
227: pay_in_utils.trace('l_assess_yr_start : ',l_assess_yr_start);
228: pay_in_utils.trace('g_tax_year : ',g_tax_year);
229: pay_in_utils.trace('l_end_date : ',l_end_date);
230: end if;
231:
232: g_fin_start_date := ADD_MONTHS(l_assess_yr_start,-12);
225: if g_debug then
226: pay_in_utils.trace('i : ',i);
227: pay_in_utils.trace('l_assess_yr_start : ',l_assess_yr_start);
228: pay_in_utils.trace('g_tax_year : ',g_tax_year);
229: pay_in_utils.trace('l_end_date : ',l_end_date);
230: end if;
231:
232: g_fin_start_date := ADD_MONTHS(l_assess_yr_start,-12);
233: g_fin_end_date := ADD_MONTHS(l_end_date,-12);
235: g_end_date := ADD_MONTHS(g_qr_start_date,3) -1;
236: g_payroll_action_id := p_payroll_action_id;
237:
238: if g_debug then
239: pay_in_utils.trace('g_fin_start_date : ',g_fin_start_date);
240: pay_in_utils.trace('g_fin_end_date : ',g_fin_end_date);
241: pay_in_utils.trace('g_qr_start_date : ',g_qr_start_date);
242: pay_in_utils.trace('g_end_date : ',g_end_date);
243: pay_in_utils.trace('g_payroll_action_id : ',g_payroll_action_id);
236: g_payroll_action_id := p_payroll_action_id;
237:
238: if g_debug then
239: pay_in_utils.trace('g_fin_start_date : ',g_fin_start_date);
240: pay_in_utils.trace('g_fin_end_date : ',g_fin_end_date);
241: pay_in_utils.trace('g_qr_start_date : ',g_qr_start_date);
242: pay_in_utils.trace('g_end_date : ',g_end_date);
243: pay_in_utils.trace('g_payroll_action_id : ',g_payroll_action_id);
244: end if;
237:
238: if g_debug then
239: pay_in_utils.trace('g_fin_start_date : ',g_fin_start_date);
240: pay_in_utils.trace('g_fin_end_date : ',g_fin_end_date);
241: pay_in_utils.trace('g_qr_start_date : ',g_qr_start_date);
242: pay_in_utils.trace('g_end_date : ',g_end_date);
243: pay_in_utils.trace('g_payroll_action_id : ',g_payroll_action_id);
244: end if;
245:
238: if g_debug then
239: pay_in_utils.trace('g_fin_start_date : ',g_fin_start_date);
240: pay_in_utils.trace('g_fin_end_date : ',g_fin_end_date);
241: pay_in_utils.trace('g_qr_start_date : ',g_qr_start_date);
242: pay_in_utils.trace('g_end_date : ',g_end_date);
243: pay_in_utils.trace('g_payroll_action_id : ',g_payroll_action_id);
244: end if;
245:
246: pay_in_utils.set_location(g_debug,'Finding Globals : '||l_proc,20);
239: pay_in_utils.trace('g_fin_start_date : ',g_fin_start_date);
240: pay_in_utils.trace('g_fin_end_date : ',g_fin_end_date);
241: pay_in_utils.trace('g_qr_start_date : ',g_qr_start_date);
242: pay_in_utils.trace('g_end_date : ',g_end_date);
243: pay_in_utils.trace('g_payroll_action_id : ',g_payroll_action_id);
244: end if;
245:
246: pay_in_utils.set_location(g_debug,'Finding Globals : '||l_proc,20);
247:
242: pay_in_utils.trace('g_end_date : ',g_end_date);
243: pay_in_utils.trace('g_payroll_action_id : ',g_payroll_action_id);
244: end if;
245:
246: pay_in_utils.set_location(g_debug,'Finding Globals : '||l_proc,20);
247:
248: IF g_quarter ='Q4' THEN
249: g_start_date := ADD_MONTHS(l_assess_yr_start,-12);
250: ELSE
251: g_start_date := g_qr_start_date;
252: END IF;
253:
254: if g_debug then
255: pay_in_utils.trace('g_start_date : ',g_start_date);
256: end if;
257:
258: FOR crec in csr_challan_input_id LOOP
259: g_input_table_rec(crec.indx).input_value_id := crec.input_value_id;
259: g_input_table_rec(crec.indx).input_value_id := crec.input_value_id;
260: g_chln_element_id := crec.element_type_id;
261: END LOOP;
262:
263: pay_in_utils.set_location(g_debug,'Global1: '||g_year||' '||g_bg_id||' '||g_quarter||' '||g_gre_id,30);
264: pay_in_utils.set_location(g_debug,'Global2: '||g_start_date||g_end_date||g_qr_start_date,40);
265: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,50);
266:
267: --
260: g_chln_element_id := crec.element_type_id;
261: END LOOP;
262:
263: pay_in_utils.set_location(g_debug,'Global1: '||g_year||' '||g_bg_id||' '||g_quarter||' '||g_gre_id,30);
264: pay_in_utils.set_location(g_debug,'Global2: '||g_start_date||g_end_date||g_qr_start_date,40);
265: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,50);
266:
267: --
268: EXCEPTION
261: END LOOP;
262:
263: pay_in_utils.set_location(g_debug,'Global1: '||g_year||' '||g_bg_id||' '||g_quarter||' '||g_gre_id,30);
264: pay_in_utils.set_location(g_debug,'Global2: '||g_start_date||g_end_date||g_qr_start_date,40);
265: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,50);
266:
267: --
268: EXCEPTION
269: WHEN E_NON_UNIQUE_ARCH_REF_NO THEN
266:
267: --
268: EXCEPTION
269: WHEN E_NON_UNIQUE_ARCH_REF_NO THEN
270: pay_in_utils.raise_message(800, 'PER_IN_NON_UNIQUE_VALUE', l_token_name, l_token_value);
271: fnd_file.put_line(fnd_file.log,'Archive Reference Number '|| g_archive_ref_no || 'is non-unique.');
272: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,60);
273: RAISE;
274: WHEN OTHERS THEN
268: EXCEPTION
269: WHEN E_NON_UNIQUE_ARCH_REF_NO THEN
270: pay_in_utils.raise_message(800, 'PER_IN_NON_UNIQUE_VALUE', l_token_name, l_token_value);
271: fnd_file.put_line(fnd_file.log,'Archive Reference Number '|| g_archive_ref_no || 'is non-unique.');
272: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,60);
273: RAISE;
274: WHEN OTHERS THEN
275: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
276: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,70);
271: fnd_file.put_line(fnd_file.log,'Archive Reference Number '|| g_archive_ref_no || 'is non-unique.');
272: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,60);
273: RAISE;
274: WHEN OTHERS THEN
275: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
276: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,70);
277: pay_in_utils.trace(l_message,l_proc);
278: RAISE;
279: END initialization_code;
272: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,60);
273: RAISE;
274: WHEN OTHERS THEN
275: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
276: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,70);
277: pay_in_utils.trace(l_message,l_proc);
278: RAISE;
279: END initialization_code;
280:
273: RAISE;
274: WHEN OTHERS THEN
275: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
276: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,70);
277: pay_in_utils.trace(l_message,l_proc);
278: RAISE;
279: END initialization_code;
280:
281: --------------------------------------------------------------------------
318: --
319: pay_core_payslip_utils.range_cursor(p_payroll_action_id
320: ,p_sql);
321:
322: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,20);
323: --
324: EXCEPTION
325: WHEN OTHERS THEN
326: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
322: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,20);
323: --
324: EXCEPTION
325: WHEN OTHERS THEN
326: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
327: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,30);
328: pay_in_utils.trace(l_message,l_proc);
329: RAISE;
330: --
323: --
324: EXCEPTION
325: WHEN OTHERS THEN
326: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
327: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,30);
328: pay_in_utils.trace(l_message,l_proc);
329: RAISE;
330: --
331: END range_code;
324: EXCEPTION
325: WHEN OTHERS THEN
326: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
327: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,30);
328: pay_in_utils.trace(l_message,l_proc);
329: RAISE;
330: --
331: END range_code;
332:
416:
417: g_debug := hr_utility.debug_enabled;
418: l_proc := g_package || 'assignment_action_code';
419:
420: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
421:
422: if g_debug then
423: pay_in_utils.trace('******************************','********************');
424: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
419:
420: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
421:
422: if g_debug then
423: pay_in_utils.trace('******************************','********************');
424: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
425: pay_in_utils.trace('p_start_person : ',p_start_person);
426: pay_in_utils.trace('p_end_person : ',p_end_person);
427: pay_in_utils.trace('p_chunk : ',p_chunk);
420: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
421:
422: if g_debug then
423: pay_in_utils.trace('******************************','********************');
424: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
425: pay_in_utils.trace('p_start_person : ',p_start_person);
426: pay_in_utils.trace('p_end_person : ',p_end_person);
427: pay_in_utils.trace('p_chunk : ',p_chunk);
428: pay_in_utils.trace('******************************','********************');
421:
422: if g_debug then
423: pay_in_utils.trace('******************************','********************');
424: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
425: pay_in_utils.trace('p_start_person : ',p_start_person);
426: pay_in_utils.trace('p_end_person : ',p_end_person);
427: pay_in_utils.trace('p_chunk : ',p_chunk);
428: pay_in_utils.trace('******************************','********************');
429: end if;
422: if g_debug then
423: pay_in_utils.trace('******************************','********************');
424: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
425: pay_in_utils.trace('p_start_person : ',p_start_person);
426: pay_in_utils.trace('p_end_person : ',p_end_person);
427: pay_in_utils.trace('p_chunk : ',p_chunk);
428: pay_in_utils.trace('******************************','********************');
429: end if;
430:
423: pay_in_utils.trace('******************************','********************');
424: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
425: pay_in_utils.trace('p_start_person : ',p_start_person);
426: pay_in_utils.trace('p_end_person : ',p_end_person);
427: pay_in_utils.trace('p_chunk : ',p_chunk);
428: pay_in_utils.trace('******************************','********************');
429: end if;
430:
431: if g_debug then
424: pay_in_utils.trace('p_payroll_action_id : ',p_payroll_action_id);
425: pay_in_utils.trace('p_start_person : ',p_start_person);
426: pay_in_utils.trace('p_end_person : ',p_end_person);
427: pay_in_utils.trace('p_chunk : ',p_chunk);
428: pay_in_utils.trace('******************************','********************');
429: end if;
430:
431: if g_debug then
432: pay_in_utils.trace('g_fin_start_date : ',g_fin_start_date);
428: pay_in_utils.trace('******************************','********************');
429: end if;
430:
431: if g_debug then
432: pay_in_utils.trace('g_fin_start_date : ',g_fin_start_date);
433: end if;
434:
435: -- need to initialise the global contexts again
436: IF g_fin_start_date IS NULL THEN
443: INTO l_action_id
444: FROM dual;
445:
446: if g_debug then
447: pay_in_utils.trace('l_action_id : ',l_action_id);
448: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
449: end if;
450:
451: hr_nonrun_asact.insact(lockingactid => l_action_id
444: FROM dual;
445:
446: if g_debug then
447: pay_in_utils.trace('l_action_id : ',l_action_id);
448: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);
449: end if;
450:
451: hr_nonrun_asact.insact(lockingactid => l_action_id
452: ,assignid => csr_rec.assignment_id
454: ,chunk => p_chunk
455: );
456:
457: END LOOP;
458: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,30);
459: --
460: EXCEPTION
461: WHEN OTHERS THEN
462: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
458: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,30);
459: --
460: EXCEPTION
461: WHEN OTHERS THEN
462: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
463: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,40);
464: pay_in_utils.trace(l_message,l_proc);
465: RAISE;
466: END assignment_action_code;
459: --
460: EXCEPTION
461: WHEN OTHERS THEN
462: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
463: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,40);
464: pay_in_utils.trace(l_message,l_proc);
465: RAISE;
466: END assignment_action_code;
467:
460: EXCEPTION
461: WHEN OTHERS THEN
462: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
463: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,40);
464: pay_in_utils.trace(l_message,l_proc);
465: RAISE;
466: END assignment_action_code;
467:
468: --------------------------------------------------------------------------
549:
550: g_debug := hr_utility.debug_enabled;
551: l_proc := g_package || 'archive_challan_data';
552:
553: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
554:
555: if g_debug then
556: pay_in_utils.trace('******************************','********************');
557: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
552:
553: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
554:
555: if g_debug then
556: pay_in_utils.trace('******************************','********************');
557: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
558: pay_in_utils.trace('p_gre_id : ',p_gre_id);
559: pay_in_utils.trace('******************************','********************');
560: end if;
553: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
554:
555: if g_debug then
556: pay_in_utils.trace('******************************','********************');
557: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
558: pay_in_utils.trace('p_gre_id : ',p_gre_id);
559: pay_in_utils.trace('******************************','********************');
560: end if;
561:
554:
555: if g_debug then
556: pay_in_utils.trace('******************************','********************');
557: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
558: pay_in_utils.trace('p_gre_id : ',p_gre_id);
559: pay_in_utils.trace('******************************','********************');
560: end if;
561:
562: t_challan_entry_asg_tab.DELETE;
555: if g_debug then
556: pay_in_utils.trace('******************************','********************');
557: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
558: pay_in_utils.trace('p_gre_id : ',p_gre_id);
559: pay_in_utils.trace('******************************','********************');
560: end if;
561:
562: t_challan_entry_asg_tab.DELETE;
563:
567:
568: p_cnt := t_challan_entry_asg_tab.COUNT;
569:
570: if g_debug then
571: pay_in_utils.trace('p_cnt : ',p_cnt);
572: end if;
573:
574: IF p_cnt >0 then
575: FOR i IN t_challan_entry_asg_tab.FIRST .. t_challan_entry_asg_tab.LAST LOOP
581: CLOSE csr_challan_bank;
582: END IF;
583:
584: if g_debug then
585: pay_in_utils.trace('challan_number : ',t_challan_entry_asg_tab(i).challan_number);
586: pay_in_utils.trace('g_year : ',g_year);
587: pay_in_utils.trace('g_quarter : ',g_quarter);
588: pay_in_utils.trace('l_bank_code : ',l_bank_code);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
582: END IF;
583:
584: if g_debug then
585: pay_in_utils.trace('challan_number : ',t_challan_entry_asg_tab(i).challan_number);
586: pay_in_utils.trace('g_year : ',g_year);
587: pay_in_utils.trace('g_quarter : ',g_quarter);
588: pay_in_utils.trace('l_bank_code : ',l_bank_code);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
583:
584: if g_debug then
585: pay_in_utils.trace('challan_number : ',t_challan_entry_asg_tab(i).challan_number);
586: pay_in_utils.trace('g_year : ',g_year);
587: pay_in_utils.trace('g_quarter : ',g_quarter);
588: pay_in_utils.trace('l_bank_code : ',l_bank_code);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
584: if g_debug then
585: pay_in_utils.trace('challan_number : ',t_challan_entry_asg_tab(i).challan_number);
586: pay_in_utils.trace('g_year : ',g_year);
587: pay_in_utils.trace('g_quarter : ',g_quarter);
588: pay_in_utils.trace('l_bank_code : ',l_bank_code);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
585: pay_in_utils.trace('challan_number : ',t_challan_entry_asg_tab(i).challan_number);
586: pay_in_utils.trace('g_year : ',g_year);
587: pay_in_utils.trace('g_quarter : ',g_quarter);
588: pay_in_utils.trace('l_bank_code : ',l_bank_code);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
593: pay_in_utils.trace('others : ',t_challan_entry_asg_tab(i).others);
586: pay_in_utils.trace('g_year : ',g_year);
587: pay_in_utils.trace('g_quarter : ',g_quarter);
588: pay_in_utils.trace('l_bank_code : ',l_bank_code);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
593: pay_in_utils.trace('others : ',t_challan_entry_asg_tab(i).others);
594: pay_in_utils.trace('dd_cheq_num : ',t_challan_entry_asg_tab(i).dd_cheq_num);
587: pay_in_utils.trace('g_quarter : ',g_quarter);
588: pay_in_utils.trace('l_bank_code : ',l_bank_code);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
593: pay_in_utils.trace('others : ',t_challan_entry_asg_tab(i).others);
594: pay_in_utils.trace('dd_cheq_num : ',t_challan_entry_asg_tab(i).dd_cheq_num);
595: pay_in_utils.trace('book_entry : ',t_challan_entry_asg_tab(i).book_entry);
588: pay_in_utils.trace('l_bank_code : ',l_bank_code);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
593: pay_in_utils.trace('others : ',t_challan_entry_asg_tab(i).others);
594: pay_in_utils.trace('dd_cheq_num : ',t_challan_entry_asg_tab(i).dd_cheq_num);
595: pay_in_utils.trace('book_entry : ',t_challan_entry_asg_tab(i).book_entry);
596: pay_in_utils.trace('remarks : ',t_challan_entry_asg_tab(i).remarks);
589: pay_in_utils.trace('Payment_date : ',t_challan_entry_asg_tab(i).Payment_date);
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
593: pay_in_utils.trace('others : ',t_challan_entry_asg_tab(i).others);
594: pay_in_utils.trace('dd_cheq_num : ',t_challan_entry_asg_tab(i).dd_cheq_num);
595: pay_in_utils.trace('book_entry : ',t_challan_entry_asg_tab(i).book_entry);
596: pay_in_utils.trace('remarks : ',t_challan_entry_asg_tab(i).remarks);
597: end if;
590: pay_in_utils.trace('tax : ',t_challan_entry_asg_tab(i).tax);
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
593: pay_in_utils.trace('others : ',t_challan_entry_asg_tab(i).others);
594: pay_in_utils.trace('dd_cheq_num : ',t_challan_entry_asg_tab(i).dd_cheq_num);
595: pay_in_utils.trace('book_entry : ',t_challan_entry_asg_tab(i).book_entry);
596: pay_in_utils.trace('remarks : ',t_challan_entry_asg_tab(i).remarks);
597: end if;
598:
591: pay_in_utils.trace('surcharge : ',t_challan_entry_asg_tab(i).surcharge);
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
593: pay_in_utils.trace('others : ',t_challan_entry_asg_tab(i).others);
594: pay_in_utils.trace('dd_cheq_num : ',t_challan_entry_asg_tab(i).dd_cheq_num);
595: pay_in_utils.trace('book_entry : ',t_challan_entry_asg_tab(i).book_entry);
596: pay_in_utils.trace('remarks : ',t_challan_entry_asg_tab(i).remarks);
597: end if;
598:
599: IF (NVL(t_challan_entry_asg_tab(i).tax,0)<>0 OR
592: pay_in_utils.trace('interest : ',t_challan_entry_asg_tab(i).interest);
593: pay_in_utils.trace('others : ',t_challan_entry_asg_tab(i).others);
594: pay_in_utils.trace('dd_cheq_num : ',t_challan_entry_asg_tab(i).dd_cheq_num);
595: pay_in_utils.trace('book_entry : ',t_challan_entry_asg_tab(i).book_entry);
596: pay_in_utils.trace('remarks : ',t_challan_entry_asg_tab(i).remarks);
597: end if;
598:
599: IF (NVL(t_challan_entry_asg_tab(i).tax,0)<>0 OR
600: NVL(t_challan_entry_asg_tab(i).surcharge,0)<>0 OR
628: END IF;
629:
630: END LOOP;
631: END IF;
632: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,20);
633: --
634: END archive_challan_data;
635:
636: --------------------------------------------------------------------------
775: BEGIN
776: g_debug := hr_utility.debug_enabled;
777: l_proc := g_package || 'archive_org_data';
778:
779: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
780:
781: if g_debug then
782: pay_in_utils.trace('******************************','********************');
783: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
778:
779: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
780:
781: if g_debug then
782: pay_in_utils.trace('******************************','********************');
783: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
784: pay_in_utils.trace('p_gre_id : ',p_gre_id);
785: pay_in_utils.trace('p_effective_date : ',p_effective_date);
786: pay_in_utils.trace('******************************','********************');
779: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
780:
781: if g_debug then
782: pay_in_utils.trace('******************************','********************');
783: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
784: pay_in_utils.trace('p_gre_id : ',p_gre_id);
785: pay_in_utils.trace('p_effective_date : ',p_effective_date);
786: pay_in_utils.trace('******************************','********************');
787: end if;
780:
781: if g_debug then
782: pay_in_utils.trace('******************************','********************');
783: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
784: pay_in_utils.trace('p_gre_id : ',p_gre_id);
785: pay_in_utils.trace('p_effective_date : ',p_effective_date);
786: pay_in_utils.trace('******************************','********************');
787: end if;
788:
781: if g_debug then
782: pay_in_utils.trace('******************************','********************');
783: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
784: pay_in_utils.trace('p_gre_id : ',p_gre_id);
785: pay_in_utils.trace('p_effective_date : ',p_effective_date);
786: pay_in_utils.trace('******************************','********************');
787: end if;
788:
789: OPEN c_org_inc_tax_df_details;
782: pay_in_utils.trace('******************************','********************');
783: pay_in_utils.trace('p_arc_pay_action_id : ',p_arc_pay_action_id);
784: pay_in_utils.trace('p_gre_id : ',p_gre_id);
785: pay_in_utils.trace('p_effective_date : ',p_effective_date);
786: pay_in_utils.trace('******************************','********************');
787: end if;
788:
789: OPEN c_org_inc_tax_df_details;
790: FETCH c_org_inc_tax_df_details INTO l_tan,l_er_class,l_reg_org_id,l_division,l_location_id;
819: END IF;
820: CLOSE csr_challan_recs;
821:
822: if g_debug then
823: pay_in_utils.trace('l_tan : ',l_tan);
824: pay_in_utils.trace('g_year : ',g_year);
825: pay_in_utils.trace('g_quarter : ',g_quarter);
826: pay_in_utils.trace('l_reg_org_id : ',l_reg_org_id);
827: pay_in_utils.trace('l_division : ',l_division);
820: CLOSE csr_challan_recs;
821:
822: if g_debug then
823: pay_in_utils.trace('l_tan : ',l_tan);
824: pay_in_utils.trace('g_year : ',g_year);
825: pay_in_utils.trace('g_quarter : ',g_quarter);
826: pay_in_utils.trace('l_reg_org_id : ',l_reg_org_id);
827: pay_in_utils.trace('l_division : ',l_division);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
821:
822: if g_debug then
823: pay_in_utils.trace('l_tan : ',l_tan);
824: pay_in_utils.trace('g_year : ',g_year);
825: pay_in_utils.trace('g_quarter : ',g_quarter);
826: pay_in_utils.trace('l_reg_org_id : ',l_reg_org_id);
827: pay_in_utils.trace('l_division : ',l_division);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
829: pay_in_utils.trace('l_pan : ',l_pan);
822: if g_debug then
823: pay_in_utils.trace('l_tan : ',l_tan);
824: pay_in_utils.trace('g_year : ',g_year);
825: pay_in_utils.trace('g_quarter : ',g_quarter);
826: pay_in_utils.trace('l_reg_org_id : ',l_reg_org_id);
827: pay_in_utils.trace('l_division : ',l_division);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
829: pay_in_utils.trace('l_pan : ',l_pan);
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
823: pay_in_utils.trace('l_tan : ',l_tan);
824: pay_in_utils.trace('g_year : ',g_year);
825: pay_in_utils.trace('g_quarter : ',g_quarter);
826: pay_in_utils.trace('l_reg_org_id : ',l_reg_org_id);
827: pay_in_utils.trace('l_division : ',l_division);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
829: pay_in_utils.trace('l_pan : ',l_pan);
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
824: pay_in_utils.trace('g_year : ',g_year);
825: pay_in_utils.trace('g_quarter : ',g_quarter);
826: pay_in_utils.trace('l_reg_org_id : ',l_reg_org_id);
827: pay_in_utils.trace('l_division : ',l_division);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
829: pay_in_utils.trace('l_pan : ',l_pan);
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
825: pay_in_utils.trace('g_quarter : ',g_quarter);
826: pay_in_utils.trace('l_reg_org_id : ',l_reg_org_id);
827: pay_in_utils.trace('l_division : ',l_division);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
829: pay_in_utils.trace('l_pan : ',l_pan);
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
833: pay_in_utils.trace('l_rep_email_id : ',l_rep_email_id);
826: pay_in_utils.trace('l_reg_org_id : ',l_reg_org_id);
827: pay_in_utils.trace('l_division : ',l_division);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
829: pay_in_utils.trace('l_pan : ',l_pan);
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
833: pay_in_utils.trace('l_rep_email_id : ',l_rep_email_id);
834: pay_in_utils.trace('l_position : ',l_position);
827: pay_in_utils.trace('l_division : ',l_division);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
829: pay_in_utils.trace('l_pan : ',l_pan);
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
833: pay_in_utils.trace('l_rep_email_id : ',l_rep_email_id);
834: pay_in_utils.trace('l_position : ',l_position);
835: pay_in_utils.trace('l_rep_location : ',l_rep_location);
828: pay_in_utils.trace('l_location_id : ',l_location_id);
829: pay_in_utils.trace('l_pan : ',l_pan);
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
833: pay_in_utils.trace('l_rep_email_id : ',l_rep_email_id);
834: pay_in_utils.trace('l_position : ',l_position);
835: pay_in_utils.trace('l_rep_location : ',l_rep_location);
836: pay_in_utils.trace('l_rep_phone_no : ',l_rep_phone_no);
829: pay_in_utils.trace('l_pan : ',l_pan);
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
833: pay_in_utils.trace('l_rep_email_id : ',l_rep_email_id);
834: pay_in_utils.trace('l_position : ',l_position);
835: pay_in_utils.trace('l_rep_location : ',l_rep_location);
836: pay_in_utils.trace('l_rep_phone_no : ',l_rep_phone_no);
837: end if;
830: pay_in_utils.trace('l_legal_name : ',l_legal_name);
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
833: pay_in_utils.trace('l_rep_email_id : ',l_rep_email_id);
834: pay_in_utils.trace('l_position : ',l_position);
835: pay_in_utils.trace('l_rep_location : ',l_rep_location);
836: pay_in_utils.trace('l_rep_phone_no : ',l_rep_phone_no);
837: end if;
838:
831: pay_in_utils.trace('l_rep_person_id : ',l_rep_person_id);
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
833: pay_in_utils.trace('l_rep_email_id : ',l_rep_email_id);
834: pay_in_utils.trace('l_position : ',l_position);
835: pay_in_utils.trace('l_rep_location : ',l_rep_location);
836: pay_in_utils.trace('l_rep_phone_no : ',l_rep_phone_no);
837: end if;
838:
839: pay_action_information_api.create_action_information
832: pay_in_utils.trace('l_rep_name : ',l_rep_name);
833: pay_in_utils.trace('l_rep_email_id : ',l_rep_email_id);
834: pay_in_utils.trace('l_position : ',l_position);
835: pay_in_utils.trace('l_rep_location : ',l_rep_location);
836: pay_in_utils.trace('l_rep_phone_no : ',l_rep_phone_no);
837: end if;
838:
839: pay_action_information_api.create_action_information
840: (p_action_context_id => p_arc_pay_action_id
858: ,p_action_information_id => l_action_info_id
859: ,p_object_version_number => l_ovn
860: );
861:
862: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 20);
863:
864: END archive_org_data;
865:
866: --------------------------------------------------------------------------
975:
976: g_debug := hr_utility.debug_enabled;
977: l_proc := g_package || 'archive_person_data';
978:
979: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
980:
981: if g_debug then
982: pay_in_utils.trace('******************************','********************');
983: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
978:
979: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
980:
981: if g_debug then
982: pay_in_utils.trace('******************************','********************');
983: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
984: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
985: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
979: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
980:
981: if g_debug then
982: pay_in_utils.trace('******************************','********************');
983: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
984: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
985: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
980:
981: if g_debug then
982: pay_in_utils.trace('******************************','********************');
983: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
984: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
985: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
988: pay_in_utils.trace('p_effective_end_date : ',p_effective_end_date);
981: if g_debug then
982: pay_in_utils.trace('******************************','********************');
983: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
984: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
985: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
988: pay_in_utils.trace('p_effective_end_date : ',p_effective_end_date);
989: pay_in_utils.trace('p_effective_date : ',p_effective_date);
982: pay_in_utils.trace('******************************','********************');
983: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
984: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
985: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
988: pay_in_utils.trace('p_effective_end_date : ',p_effective_end_date);
989: pay_in_utils.trace('p_effective_date : ',p_effective_date);
990: pay_in_utils.trace('p_termination_date : ',p_termination_date);
983: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
984: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
985: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
988: pay_in_utils.trace('p_effective_end_date : ',p_effective_end_date);
989: pay_in_utils.trace('p_effective_date : ',p_effective_date);
990: pay_in_utils.trace('p_termination_date : ',p_termination_date);
991: pay_in_utils.trace('******************************','********************');
984: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
985: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
988: pay_in_utils.trace('p_effective_end_date : ',p_effective_end_date);
989: pay_in_utils.trace('p_effective_date : ',p_effective_date);
990: pay_in_utils.trace('p_termination_date : ',p_termination_date);
991: pay_in_utils.trace('******************************','********************');
992: end if;
985: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
988: pay_in_utils.trace('p_effective_end_date : ',p_effective_end_date);
989: pay_in_utils.trace('p_effective_date : ',p_effective_date);
990: pay_in_utils.trace('p_termination_date : ',p_termination_date);
991: pay_in_utils.trace('******************************','********************');
992: end if;
993:
986: pay_in_utils.trace('p_gre_id : ',p_gre_id);
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
988: pay_in_utils.trace('p_effective_end_date : ',p_effective_end_date);
989: pay_in_utils.trace('p_effective_date : ',p_effective_date);
990: pay_in_utils.trace('p_termination_date : ',p_termination_date);
991: pay_in_utils.trace('******************************','********************');
992: end if;
993:
994: IF p_person_table.EXISTS(1) THEN
987: pay_in_utils.trace('p_effective_start_date : ',p_effective_start_date);
988: pay_in_utils.trace('p_effective_end_date : ',p_effective_end_date);
989: pay_in_utils.trace('p_effective_date : ',p_effective_date);
990: pay_in_utils.trace('p_termination_date : ',p_termination_date);
991: pay_in_utils.trace('******************************','********************');
992: end if;
993:
994: IF p_person_table.EXISTS(1) THEN
995: NULL;
1029: l_effective_start_date := GREATEST(g_qr_start_date,p_effective_start_date);
1030: END IF;
1031:
1032: if g_debug then
1033: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
1034: pay_in_utils.trace('g_year : ',g_year);
1035: pay_in_utils.trace('g_quarter : ',g_quarter);
1036: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1030: END IF;
1031:
1032: if g_debug then
1033: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
1034: pay_in_utils.trace('g_year : ',g_year);
1035: pay_in_utils.trace('g_quarter : ',g_quarter);
1036: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1031:
1032: if g_debug then
1033: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
1034: pay_in_utils.trace('g_year : ',g_year);
1035: pay_in_utils.trace('g_quarter : ',g_quarter);
1036: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1039: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
1032: if g_debug then
1033: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
1034: pay_in_utils.trace('g_year : ',g_year);
1035: pay_in_utils.trace('g_quarter : ',g_quarter);
1036: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1039: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
1040: pay_in_utils.trace('position : ',p_person_table(1).position);
1033: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
1034: pay_in_utils.trace('g_year : ',g_year);
1035: pay_in_utils.trace('g_quarter : ',g_quarter);
1036: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1039: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
1040: pay_in_utils.trace('position : ',p_person_table(1).position);
1041: pay_in_utils.trace('l_effective_start_date : ',l_effective_start_date);
1034: pay_in_utils.trace('g_year : ',g_year);
1035: pay_in_utils.trace('g_quarter : ',g_quarter);
1036: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1039: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
1040: pay_in_utils.trace('position : ',p_person_table(1).position);
1041: pay_in_utils.trace('l_effective_start_date : ',l_effective_start_date);
1042: pay_in_utils.trace('l_effective_end_date : ',l_effective_end_date);
1035: pay_in_utils.trace('g_quarter : ',g_quarter);
1036: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1039: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
1040: pay_in_utils.trace('position : ',p_person_table(1).position);
1041: pay_in_utils.trace('l_effective_start_date : ',l_effective_start_date);
1042: pay_in_utils.trace('l_effective_end_date : ',l_effective_end_date);
1043: end if;
1036: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1039: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
1040: pay_in_utils.trace('position : ',p_person_table(1).position);
1041: pay_in_utils.trace('l_effective_start_date : ',l_effective_start_date);
1042: pay_in_utils.trace('l_effective_end_date : ',l_effective_end_date);
1043: end if;
1044:
1037: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1039: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
1040: pay_in_utils.trace('position : ',p_person_table(1).position);
1041: pay_in_utils.trace('l_effective_start_date : ',l_effective_start_date);
1042: pay_in_utils.trace('l_effective_end_date : ',l_effective_end_date);
1043: end if;
1044:
1045: pay_action_information_api.create_action_information
1038: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
1039: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
1040: pay_in_utils.trace('position : ',p_person_table(1).position);
1041: pay_in_utils.trace('l_effective_start_date : ',l_effective_start_date);
1042: pay_in_utils.trace('l_effective_end_date : ',l_effective_end_date);
1043: end if;
1044:
1045: pay_action_information_api.create_action_information
1046: (p_action_context_id => p_arc_asg_action_id
1061: ,p_action_information_id => l_action_info_id
1062: ,p_object_version_number => l_ovn
1063: );
1064:
1065: pay_in_utils.set_location(g_debug,'Leaving: '||l_proc,20);
1066:
1067: END archive_person_data;
1068:
1069: --------------------------------------------------------------------------
1160: l_q4_80cce_total := 0;
1161: l_q4_others_total := 0;
1162: g_debug := hr_utility.debug_enabled;
1163: l_proc := g_package||'archive_via_details';
1164: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1165:
1166: if g_debug then
1167: pay_in_utils.trace('******************************','********************');
1168: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1163: l_proc := g_package||'archive_via_details';
1164: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1165:
1166: if g_debug then
1167: pay_in_utils.trace('******************************','********************');
1168: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1169: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1170: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1171: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
1164: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1165:
1166: if g_debug then
1167: pay_in_utils.trace('******************************','********************');
1168: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1169: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1170: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1171: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
1172: pay_in_utils.trace('******************************','********************');
1165:
1166: if g_debug then
1167: pay_in_utils.trace('******************************','********************');
1168: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1169: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1170: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1171: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
1172: pay_in_utils.trace('******************************','********************');
1173: end if;
1166: if g_debug then
1167: pay_in_utils.trace('******************************','********************');
1168: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1169: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1170: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1171: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
1172: pay_in_utils.trace('******************************','********************');
1173: end if;
1174:
1167: pay_in_utils.trace('******************************','********************');
1168: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1169: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1170: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1171: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
1172: pay_in_utils.trace('******************************','********************');
1173: end if;
1174:
1175:
1168: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1169: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1170: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1171: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
1172: pay_in_utils.trace('******************************','********************');
1173: end if;
1174:
1175:
1176: -- STEP 1 : Gross Amount determination for 80G
1189: ,p_context_lst => g_context_table
1190: ,p_output_table => g_result_table1
1191: );
1192: l_80g_gross := g_result_table1(1).balance_value;
1193: pay_in_utils.set_location(g_debug,'80G Gross : '||l_80g_gross,20);
1194:
1195: -- STEP 2 : Get Qualifying Amt of Deferred Annuity,Senior Citizens Savings Scheme, Pension Fund and LIC
1196: g_balance_value_tab1.DELETE;
1197: g_context_table.DELETE;
1216: );
1217: FOR i IN 1..4 LOOP
1218: l_80cce_others := l_80cce_others + g_result_table1(i).balance_value;
1219: END LOOP;
1220: pay_in_utils.set_location(g_debug,'Qualifying Amount of three 80CCE components: '||l_80cce_others,20);
1221:
1222: -- STEP 3: Qualifying amt of 80GG ,80G, Total Qualifying Chapter VIA,Gross Amt of ALL chapter VIA Components
1223: g_context_table.DELETE;
1224: g_result_table.DELETE;
1237: ,p_defined_balance_lst => g_balance_value_tab
1238: ,p_context_lst => g_context_table
1239: ,p_output_table => g_result_table
1240: );
1241: pay_in_utils.set_location(g_debug,'ASSACT: '||p_run_asg_action_id,30);
1242:
1243: FOR i IN 1..g_balance_value_tab.COUNT
1244: LOOP
1245: pay_in_utils.set_location(g_debug,'Balance Name: '|| g_bal_name_tab(i).balance_name,32);
1241: pay_in_utils.set_location(g_debug,'ASSACT: '||p_run_asg_action_id,30);
1242:
1243: FOR i IN 1..g_balance_value_tab.COUNT
1244: LOOP
1245: pay_in_utils.set_location(g_debug,'Balance Name: '|| g_bal_name_tab(i).balance_name,32);
1246: pay_in_utils.set_location(g_debug,'Balance Value: '|| g_result_table(i).balance_value,34);
1247: IF (g_result_table(i).balance_value <> 0)
1248: THEN
1249: IF (g_bal_name_tab(i).balance_name IN('F16 Deductions Sec 80E'
1242:
1243: FOR i IN 1..g_balance_value_tab.COUNT
1244: LOOP
1245: pay_in_utils.set_location(g_debug,'Balance Name: '|| g_bal_name_tab(i).balance_name,32);
1246: pay_in_utils.set_location(g_debug,'Balance Value: '|| g_result_table(i).balance_value,34);
1247: IF (g_result_table(i).balance_value <> 0)
1248: THEN
1249: IF (g_bal_name_tab(i).balance_name IN('F16 Deductions Sec 80E'
1250: ,'F16 Deductions Sec 80U'
1279: l_via_others_qa := l_tot_via_qa - (l_80g_qa + l_80gg_qa_gross);
1280:
1281: l_q4_others_total := l_tot_via_qa - l_q4_80cce_total;
1282:
1283: pay_in_utils.set_location(g_debug,'Gross Amt 80G: '||l_80g_gross,30);
1284: pay_in_utils.set_location(g_debug,'Qual Amt 80G: '||l_80g_qa,40);
1285: pay_in_utils.set_location(g_debug,'Both Amts 80GG: '||l_80gg_qa_gross,50);
1286: pay_in_utils.set_location(g_debug,'Gross Amt Others: '||l_via_others_gross,60);
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1280:
1281: l_q4_others_total := l_tot_via_qa - l_q4_80cce_total;
1282:
1283: pay_in_utils.set_location(g_debug,'Gross Amt 80G: '||l_80g_gross,30);
1284: pay_in_utils.set_location(g_debug,'Qual Amt 80G: '||l_80g_qa,40);
1285: pay_in_utils.set_location(g_debug,'Both Amts 80GG: '||l_80gg_qa_gross,50);
1286: pay_in_utils.set_location(g_debug,'Gross Amt Others: '||l_via_others_gross,60);
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1288: pay_in_utils.set_location(g_debug,'Amount 80CCE: '|| l_q4_80cce_total,80);
1281: l_q4_others_total := l_tot_via_qa - l_q4_80cce_total;
1282:
1283: pay_in_utils.set_location(g_debug,'Gross Amt 80G: '||l_80g_gross,30);
1284: pay_in_utils.set_location(g_debug,'Qual Amt 80G: '||l_80g_qa,40);
1285: pay_in_utils.set_location(g_debug,'Both Amts 80GG: '||l_80gg_qa_gross,50);
1286: pay_in_utils.set_location(g_debug,'Gross Amt Others: '||l_via_others_gross,60);
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1288: pay_in_utils.set_location(g_debug,'Amount 80CCE: '|| l_q4_80cce_total,80);
1289: pay_in_utils.set_location(g_debug,'Amount Others: '|| l_q4_others_total,90);
1282:
1283: pay_in_utils.set_location(g_debug,'Gross Amt 80G: '||l_80g_gross,30);
1284: pay_in_utils.set_location(g_debug,'Qual Amt 80G: '||l_80g_qa,40);
1285: pay_in_utils.set_location(g_debug,'Both Amts 80GG: '||l_80gg_qa_gross,50);
1286: pay_in_utils.set_location(g_debug,'Gross Amt Others: '||l_via_others_gross,60);
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1288: pay_in_utils.set_location(g_debug,'Amount 80CCE: '|| l_q4_80cce_total,80);
1289: pay_in_utils.set_location(g_debug,'Amount Others: '|| l_q4_others_total,90);
1290: pay_in_utils.set_location(g_debug,'l_80cce_others: '|| l_80cce_others,100);
1283: pay_in_utils.set_location(g_debug,'Gross Amt 80G: '||l_80g_gross,30);
1284: pay_in_utils.set_location(g_debug,'Qual Amt 80G: '||l_80g_qa,40);
1285: pay_in_utils.set_location(g_debug,'Both Amts 80GG: '||l_80gg_qa_gross,50);
1286: pay_in_utils.set_location(g_debug,'Gross Amt Others: '||l_via_others_gross,60);
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1288: pay_in_utils.set_location(g_debug,'Amount 80CCE: '|| l_q4_80cce_total,80);
1289: pay_in_utils.set_location(g_debug,'Amount Others: '|| l_q4_others_total,90);
1290: pay_in_utils.set_location(g_debug,'l_80cce_others: '|| l_80cce_others,100);
1291: pay_in_utils.set_location(g_debug,'l_q4_others_total '|| l_q4_others_total,100);
1284: pay_in_utils.set_location(g_debug,'Qual Amt 80G: '||l_80g_qa,40);
1285: pay_in_utils.set_location(g_debug,'Both Amts 80GG: '||l_80gg_qa_gross,50);
1286: pay_in_utils.set_location(g_debug,'Gross Amt Others: '||l_via_others_gross,60);
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1288: pay_in_utils.set_location(g_debug,'Amount 80CCE: '|| l_q4_80cce_total,80);
1289: pay_in_utils.set_location(g_debug,'Amount Others: '|| l_q4_others_total,90);
1290: pay_in_utils.set_location(g_debug,'l_80cce_others: '|| l_80cce_others,100);
1291: pay_in_utils.set_location(g_debug,'l_q4_others_total '|| l_q4_others_total,100);
1292: -- STEP 4: Archive values
1285: pay_in_utils.set_location(g_debug,'Both Amts 80GG: '||l_80gg_qa_gross,50);
1286: pay_in_utils.set_location(g_debug,'Gross Amt Others: '||l_via_others_gross,60);
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1288: pay_in_utils.set_location(g_debug,'Amount 80CCE: '|| l_q4_80cce_total,80);
1289: pay_in_utils.set_location(g_debug,'Amount Others: '|| l_q4_others_total,90);
1290: pay_in_utils.set_location(g_debug,'l_80cce_others: '|| l_80cce_others,100);
1291: pay_in_utils.set_location(g_debug,'l_q4_others_total '|| l_q4_others_total,100);
1292: -- STEP 4: Archive values
1293:
1286: pay_in_utils.set_location(g_debug,'Gross Amt Others: '||l_via_others_gross,60);
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1288: pay_in_utils.set_location(g_debug,'Amount 80CCE: '|| l_q4_80cce_total,80);
1289: pay_in_utils.set_location(g_debug,'Amount Others: '|| l_q4_others_total,90);
1290: pay_in_utils.set_location(g_debug,'l_80cce_others: '|| l_80cce_others,100);
1291: pay_in_utils.set_location(g_debug,'l_q4_others_total '|| l_q4_others_total,100);
1292: -- STEP 4: Archive values
1293:
1294: IF (g_quarter = 'Q4') THEN
1287: pay_in_utils.set_location(g_debug,'Qual Amt Others: '|| l_via_others_qa,70);
1288: pay_in_utils.set_location(g_debug,'Amount 80CCE: '|| l_q4_80cce_total,80);
1289: pay_in_utils.set_location(g_debug,'Amount Others: '|| l_q4_others_total,90);
1290: pay_in_utils.set_location(g_debug,'l_80cce_others: '|| l_80cce_others,100);
1291: pay_in_utils.set_location(g_debug,'l_q4_others_total '|| l_q4_others_total,100);
1292: -- STEP 4: Archive values
1293:
1294: IF (g_quarter = 'Q4') THEN
1295: IF (l_q4_80cce_total <> 0) THEN
1369: g_result_table.DELETE;
1370: g_context_table.DELETE;
1371: g_result_table1.DELETE;
1372:
1373: pay_in_utils.set_location(g_debug,'Leaving: '||l_proc,80);
1374: END archive_via_details;
1375:
1376:
1377: --------------------------------------------------------------------------
1478: BEGIN
1479: g_debug := hr_utility.debug_enabled;
1480: l_proc := g_package||'archive_asg_salary';
1481:
1482: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1483:
1484: if g_debug then
1485: pay_in_utils.trace('******************************','********************');
1486: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1481:
1482: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1483:
1484: if g_debug then
1485: pay_in_utils.trace('******************************','********************');
1486: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1487: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1488: pay_in_utils.trace('p_balance_periods : ',p_balance_periods);
1489: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1482: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1483:
1484: if g_debug then
1485: pay_in_utils.trace('******************************','********************');
1486: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1487: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1488: pay_in_utils.trace('p_balance_periods : ',p_balance_periods);
1489: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1490: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1483:
1484: if g_debug then
1485: pay_in_utils.trace('******************************','********************');
1486: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1487: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1488: pay_in_utils.trace('p_balance_periods : ',p_balance_periods);
1489: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1490: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1491: pay_in_utils.trace('******************************','********************');
1484: if g_debug then
1485: pay_in_utils.trace('******************************','********************');
1486: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1487: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1488: pay_in_utils.trace('p_balance_periods : ',p_balance_periods);
1489: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1490: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1491: pay_in_utils.trace('******************************','********************');
1492: end if;
1485: pay_in_utils.trace('******************************','********************');
1486: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1487: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1488: pay_in_utils.trace('p_balance_periods : ',p_balance_periods);
1489: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1490: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1491: pay_in_utils.trace('******************************','********************');
1492: end if;
1493:
1486: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1487: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1488: pay_in_utils.trace('p_balance_periods : ',p_balance_periods);
1489: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1490: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1491: pay_in_utils.trace('******************************','********************');
1492: end if;
1493:
1494: i := 1;
1487: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1488: pay_in_utils.trace('p_balance_periods : ',p_balance_periods);
1489: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1490: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1491: pay_in_utils.trace('******************************','********************');
1492: end if;
1493:
1494: i := 1;
1495: g_bal_name_tab.DELETE;
1499: g_context_table(1).tax_unit_id := p_gre_id;
1500: l_total_cess:=0;
1501:
1502: --Step 1: Archive F16 balances,also get Projected Allowance Amount
1503: pay_in_utils.set_location(g_debug,'PERIODS '||p_balance_periods,10);
1504:
1505: FOR c_rec IN c_f16_sal_balances
1506: LOOP
1507: g_balance_value_tab(i).defined_balance_id := c_rec.balance_id;
1526: THEN
1527: IF g_bal_name_tab(i).balance_name = 'Allowances Standard Value' THEN
1528: l_allow_proj_value := g_result_table(i).balance_value * p_balance_periods;
1529: if g_debug then
1530: pay_in_utils.trace('l_allow_proj_value : ',l_allow_proj_value);
1531: end if;
1532: ELSIF g_bal_name_tab(i).balance_name <> 'F16 Education Cess' THEN
1533: if g_debug then
1534: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1530: pay_in_utils.trace('l_allow_proj_value : ',l_allow_proj_value);
1531: end if;
1532: ELSIF g_bal_name_tab(i).balance_name <> 'F16 Education Cess' THEN
1533: if g_debug then
1534: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1535: pay_in_utils.trace('balance_value : ',g_result_table(i).balance_value);
1536: end if;
1537: pay_action_information_api.create_action_information
1538: (p_action_context_id => p_arc_asg_action_id
1531: end if;
1532: ELSIF g_bal_name_tab(i).balance_name <> 'F16 Education Cess' THEN
1533: if g_debug then
1534: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1535: pay_in_utils.trace('balance_value : ',g_result_table(i).balance_value);
1536: end if;
1537: pay_action_information_api.create_action_information
1538: (p_action_context_id => p_arc_asg_action_id
1539: ,p_action_context_type => 'AAP'
1595: l_balance_value := g_balance_value_tab1(i).balance_value;
1596: END IF;
1597:
1598: if g_debug then
1599: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1600: pay_in_utils.trace('l_balance_value : ',l_balance_value);
1601: end if;
1602:
1603:
1596: END IF;
1597:
1598: if g_debug then
1599: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1600: pay_in_utils.trace('l_balance_value : ',l_balance_value);
1601: end if;
1602:
1603:
1604:
1626: g_balance_value_tab1.DELETE;
1627: g_balance_value_tab2.DELETE;
1628:
1629:
1630: pay_in_utils.set_location(g_debug,'Leaving: '||l_proc,30);
1631:
1632: END archive_asg_salary;
1633:
1634: --------------------------------------------------------------------------
1660: BEGIN
1661: g_debug := hr_utility.debug_enabled;
1662: l_proc := g_package||'balance_difference';
1663:
1664: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1665:
1666: FOR i IN 1..GREATEST(g_result_table1.COUNT,g_result_table2.COUNT)
1667: LOOP
1668: g_result_table(i).balance_value := g_result_table1(i).balance_value
1668: g_result_table(i).balance_value := g_result_table1(i).balance_value
1669: - g_result_table2(i).balance_value;
1670: END LOOP;
1671:
1672: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,20);
1673:
1674: END;
1675:
1676: --------------------------------------------------------------------------
1714: BEGIN
1715: g_debug := hr_utility.debug_enabled;
1716: l_proc := g_package||'get_balances';
1717:
1718: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1719:
1720: if g_debug then
1721: pay_in_utils.trace('******************************','********************');
1722: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1717:
1718: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1719:
1720: if g_debug then
1721: pay_in_utils.trace('******************************','********************');
1722: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1723: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1724: pay_in_utils.trace('p_balance_name : ',p_balance_name);
1725: pay_in_utils.trace('p_balance_dimension : ',p_balance_dimension);
1718: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1719:
1720: if g_debug then
1721: pay_in_utils.trace('******************************','********************');
1722: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1723: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1724: pay_in_utils.trace('p_balance_name : ',p_balance_name);
1725: pay_in_utils.trace('p_balance_dimension : ',p_balance_dimension);
1726: pay_in_utils.trace('******************************','********************');
1719:
1720: if g_debug then
1721: pay_in_utils.trace('******************************','********************');
1722: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1723: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1724: pay_in_utils.trace('p_balance_name : ',p_balance_name);
1725: pay_in_utils.trace('p_balance_dimension : ',p_balance_dimension);
1726: pay_in_utils.trace('******************************','********************');
1727: end if;
1720: if g_debug then
1721: pay_in_utils.trace('******************************','********************');
1722: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1723: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1724: pay_in_utils.trace('p_balance_name : ',p_balance_name);
1725: pay_in_utils.trace('p_balance_dimension : ',p_balance_dimension);
1726: pay_in_utils.trace('******************************','********************');
1727: end if;
1728:
1721: pay_in_utils.trace('******************************','********************');
1722: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1723: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1724: pay_in_utils.trace('p_balance_name : ',p_balance_name);
1725: pay_in_utils.trace('p_balance_dimension : ',p_balance_dimension);
1726: pay_in_utils.trace('******************************','********************');
1727: end if;
1728:
1729: IF p_balance_name IS NOT NULL THEN
1722: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1723: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1724: pay_in_utils.trace('p_balance_name : ',p_balance_name);
1725: pay_in_utils.trace('p_balance_dimension : ',p_balance_dimension);
1726: pay_in_utils.trace('******************************','********************');
1727: end if;
1728:
1729: IF p_balance_name IS NOT NULL THEN
1730: g_balance_value_tab(1).defined_balance_id :=
1745: ,p_output_table => l_result_table2
1746: );
1747: ELSE
1748: g_result_table := l_result_table1;
1749: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,20);
1750: RETURN;
1751: END IF;
1752:
1753: balance_difference(l_result_table1,l_result_table2,g_result_table);
1751: END IF;
1752:
1753: balance_difference(l_result_table1,l_result_table2,g_result_table);
1754:
1755: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,30);
1756:
1757: END get_balances;
1758:
1759: --------------------------------------------------------------------------
1854: g_debug := hr_utility.debug_enabled;
1855: l_proc := 'pay_in_24q_archive.archive_perquisites';
1856:
1857: --- Step 1: Company Accommodation :Cost and Rent of Furniture
1858: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1859:
1860: if g_debug then
1861: pay_in_utils.trace('******************************','********************');
1862: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1857: --- Step 1: Company Accommodation :Cost and Rent of Furniture
1858: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1859:
1860: if g_debug then
1861: pay_in_utils.trace('******************************','********************');
1862: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1863: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1864: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1865: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1858: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
1859:
1860: if g_debug then
1861: pay_in_utils.trace('******************************','********************');
1862: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1863: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1864: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1865: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1866: pay_in_utils.trace('******************************','********************');
1859:
1860: if g_debug then
1861: pay_in_utils.trace('******************************','********************');
1862: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1863: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1864: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1865: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1866: pay_in_utils.trace('******************************','********************');
1867: end if;
1860: if g_debug then
1861: pay_in_utils.trace('******************************','********************');
1862: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1863: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1864: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1865: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1866: pay_in_utils.trace('******************************','********************');
1867: end if;
1868:
1861: pay_in_utils.trace('******************************','********************');
1862: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1863: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1864: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1865: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1866: pay_in_utils.trace('******************************','********************');
1867: end if;
1868:
1869: l_defined_balance_id :=pay_in_tax_utils.get_defined_balance('Cost and Rent of Furniture','_ASG_YTD');
1862: pay_in_utils.trace('p_run_asg_action_id : ',p_run_asg_action_id);
1863: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
1864: pay_in_utils.trace('p_gre_id : ',p_gre_id);
1865: pay_in_utils.trace('pre_gre_asg_act_id : ',pre_gre_asg_act_id);
1866: pay_in_utils.trace('******************************','********************');
1867: end if;
1868:
1869: l_defined_balance_id :=pay_in_tax_utils.get_defined_balance('Cost and Rent of Furniture','_ASG_YTD');
1870:
1871: l_total_value := pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id,
1872: p_defined_balance_id => l_defined_balance_id);
1873:
1874: if g_debug then
1875: pay_in_utils.trace('l_total_value : ',l_total_value);
1876: end if;
1877:
1878: IF pre_gre_asg_act_id IS NOT NULL THEN
1879: l_prev_gre_value := pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id,
1878: IF pre_gre_asg_act_id IS NOT NULL THEN
1879: l_prev_gre_value := pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id,
1880: p_defined_balance_id => l_defined_balance_id);
1881: if g_debug then
1882: pay_in_utils.trace('l_prev_gre_value : ',l_prev_gre_value);
1883: end if;
1884:
1885: l_balance_value := l_total_value - l_prev_gre_value;
1886: ELSE
1887: l_balance_value := l_total_value;
1888: END IF;
1889:
1890: if g_debug then
1891: pay_in_utils.trace('l_balance_value : ',l_balance_value);
1892: end if;
1893:
1894: IF (l_balance_value <> 0)
1895: THEN
1906: END IF;
1907:
1908:
1909: -- Step 2: Company Accommodation :Employee Contribution
1910: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,20);
1911: g_context_table.DELETE;
1912: g_balance_value_tab1.DELETE;
1913: g_result_table1.DELETE;
1914: g_context_table(1).source_text2 := 'Company Accommodation';
1927: p_defined_balance_id => l_defined_balance_id);
1928:
1929:
1930: if g_debug then
1931: pay_in_utils.trace('balance_value : ',g_result_table1(1).balance_value);
1932: pay_in_utils.trace('l_balance_value : ',l_balance_value);
1933: end if;
1934:
1935: IF (g_result_table1(1).balance_value <>0 OR l_balance_value <>0 ) THEN
1928:
1929:
1930: if g_debug then
1931: pay_in_utils.trace('balance_value : ',g_result_table1(1).balance_value);
1932: pay_in_utils.trace('l_balance_value : ',l_balance_value);
1933: end if;
1934:
1935: IF (g_result_table1(1).balance_value <>0 OR l_balance_value <>0 ) THEN
1936: pay_action_information_api.create_action_information
1986: p_defined_balance_lst => g_balance_value_tab);
1987:
1988:
1989: if g_debug then
1990: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1991: pay_in_utils.trace('tabl_balance_value : ',g_balance_value_tab1(i).balance_value);
1992: pay_in_utils.trace('tab_balance_value : ',g_balance_value_tab(i).balance_value);
1993: end if;
1994:
1987:
1988:
1989: if g_debug then
1990: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1991: pay_in_utils.trace('tabl_balance_value : ',g_balance_value_tab1(i).balance_value);
1992: pay_in_utils.trace('tab_balance_value : ',g_balance_value_tab(i).balance_value);
1993: end if;
1994:
1995: FOR i IN 1..2
1988:
1989: if g_debug then
1990: pay_in_utils.trace('balance_name : ',g_bal_name_tab(i).balance_name);
1991: pay_in_utils.trace('tabl_balance_value : ',g_balance_value_tab1(i).balance_value);
1992: pay_in_utils.trace('tab_balance_value : ',g_balance_value_tab(i).balance_value);
1993: end if;
1994:
1995: FOR i IN 1..2
1996: LOOP
2014:
2015: l_others := g_balance_value_tab1(3).balance_value ;
2016: l_others_proj := g_balance_value_tab(3).balance_value ;
2017:
2018: pay_in_utils.set_location(g_debug,'Furniture and Total Perquisites '||l_proc,40);
2019:
2020: -- Step 5 - Get individual perquisite values
2021: g_balance_value_tab.DELETE;
2022: g_context_table.DELETE;
2032: g_context_table(7).source_text2 := 'Gas / Water / Electricity'; --
2033: g_context_table(8).source_text2 := 'Free Education';--
2034: g_context_table(9).source_text2 := 'Medical';--
2035:
2036: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,50);
2037:
2038: get_balances(p_run_asg_action_id => p_run_asg_action_id
2039: ,pre_gre_asg_act_id => pre_gre_asg_act_id
2040: ,p_balance_name => 'Taxable Perquisites'
2062: l_travel_perq := l_travel_perq + g_result_table1(i).balance_value ;
2063: l_travel_proj_perq := l_travel_proj_perq + g_result_table2(i).balance_value ;
2064: END LOOP ;
2065:
2066: pay_in_utils.set_location(g_debug,l_proc,55);
2067: g_context_table(3).source_text2 := 'Leave Travel Concession';
2068: g_result_table1(3).balance_value := l_travel_perq;
2069: g_result_table2(3).balance_value := l_travel_proj_perq;
2070:
2073: l_ser_gas_edu_med_perq := l_ser_gas_edu_med_perq + g_result_table1(i).balance_value ;
2074: l_ser_gas_edu_med_proj_perq := l_ser_gas_edu_med_proj_perq + g_result_table2(i).balance_value ;
2075: END LOOP;
2076:
2077: pay_in_utils.set_location(g_debug,l_proc,60);
2078: g_context_table(4).source_text2 := 'Domestic and Personal Services Perquisite';
2079: g_result_table1(4).balance_value := l_ser_gas_edu_med_perq;
2080: g_result_table2(4).balance_value := l_ser_gas_edu_med_proj_perq;
2081:
2083: l_others := l_others - g_result_table1(i).balance_value ;
2084: l_others_proj := l_others_proj - g_result_table2(i).balance_value ;
2085: END LOOP;
2086:
2087: pay_in_utils.set_location(g_debug,l_proc,70);
2088:
2089: g_context_table(5).source_text2 := 'Other Perquisites';
2090: g_result_table1(5).balance_value := l_others;
2091: g_result_table2(5).balance_value := l_others_proj;
2089: g_context_table(5).source_text2 := 'Other Perquisites';
2090: g_result_table1(5).balance_value := l_others;
2091: g_result_table2(5).balance_value := l_others_proj;
2092:
2093: pay_in_utils.set_location(g_debug,l_proc,80);
2094:
2095: if g_debug then
2096: pay_in_utils.trace('source_text2 : ',g_context_table(i).source_text2);
2097: pay_in_utils.trace('tablel_balance_value : ',g_result_table1(i).balance_value);
2092:
2093: pay_in_utils.set_location(g_debug,l_proc,80);
2094:
2095: if g_debug then
2096: pay_in_utils.trace('source_text2 : ',g_context_table(i).source_text2);
2097: pay_in_utils.trace('tablel_balance_value : ',g_result_table1(i).balance_value);
2098: pay_in_utils.trace('table2_balance_value : ',g_result_table2(i).balance_value);
2099: end if;
2100:
2093: pay_in_utils.set_location(g_debug,l_proc,80);
2094:
2095: if g_debug then
2096: pay_in_utils.trace('source_text2 : ',g_context_table(i).source_text2);
2097: pay_in_utils.trace('tablel_balance_value : ',g_result_table1(i).balance_value);
2098: pay_in_utils.trace('table2_balance_value : ',g_result_table2(i).balance_value);
2099: end if;
2100:
2101: FOR i IN 1..5
2094:
2095: if g_debug then
2096: pay_in_utils.trace('source_text2 : ',g_context_table(i).source_text2);
2097: pay_in_utils.trace('tablel_balance_value : ',g_result_table1(i).balance_value);
2098: pay_in_utils.trace('table2_balance_value : ',g_result_table2(i).balance_value);
2099: end if;
2100:
2101: FOR i IN 1..5
2102: LOOP
2118: END IF;
2119: END LOOP;
2120:
2121: -- Step 7 - Delete PL/SQL Tables
2122: pay_in_utils.set_location(g_debug,'Deleting PL/SQL tables in : '||l_proc,90);
2123: g_balance_value_tab.DELETE;
2124: g_balance_value_tab1.DELETE;
2125: g_balance_value_tab2.DELETE;
2126: g_bal_name_tab.DELETE;
2279: BEGIN
2280: g_debug := hr_utility.debug_enabled;
2281: l_proc := g_package||'archive_challan_asg';
2282:
2283: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
2284:
2285: if g_debug then
2286: pay_in_utils.trace('******************************','********************');
2287: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
2282:
2283: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
2284:
2285: if g_debug then
2286: pay_in_utils.trace('******************************','********************');
2287: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
2288: pay_in_utils.trace('p_person_id : ',p_person_id);
2289: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
2290: pay_in_utils.trace('p_gre_id : ',p_gre_id);
2283: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
2284:
2285: if g_debug then
2286: pay_in_utils.trace('******************************','********************');
2287: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
2288: pay_in_utils.trace('p_person_id : ',p_person_id);
2289: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
2290: pay_in_utils.trace('p_gre_id : ',p_gre_id);
2291: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2284:
2285: if g_debug then
2286: pay_in_utils.trace('******************************','********************');
2287: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
2288: pay_in_utils.trace('p_person_id : ',p_person_id);
2289: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
2290: pay_in_utils.trace('p_gre_id : ',p_gre_id);
2291: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2292: pay_in_utils.trace('******************************','********************');
2285: if g_debug then
2286: pay_in_utils.trace('******************************','********************');
2287: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
2288: pay_in_utils.trace('p_person_id : ',p_person_id);
2289: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
2290: pay_in_utils.trace('p_gre_id : ',p_gre_id);
2291: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2292: pay_in_utils.trace('******************************','********************');
2293: end if;
2286: pay_in_utils.trace('******************************','********************');
2287: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
2288: pay_in_utils.trace('p_person_id : ',p_person_id);
2289: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
2290: pay_in_utils.trace('p_gre_id : ',p_gre_id);
2291: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2292: pay_in_utils.trace('******************************','********************');
2293: end if;
2294:
2287: pay_in_utils.trace('p_arc_asg_action_id : ',p_arc_asg_action_id);
2288: pay_in_utils.trace('p_person_id : ',p_person_id);
2289: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
2290: pay_in_utils.trace('p_gre_id : ',p_gre_id);
2291: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2292: pay_in_utils.trace('******************************','********************');
2293: end if;
2294:
2295: t_challan_entry_asg_tab.DELETE;
2288: pay_in_utils.trace('p_person_id : ',p_person_id);
2289: pay_in_utils.trace('p_assignment_id : ',p_assignment_id);
2290: pay_in_utils.trace('p_gre_id : ',p_gre_id);
2291: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2292: pay_in_utils.trace('******************************','********************');
2293: end if;
2294:
2295: t_challan_entry_asg_tab.DELETE;
2296:
2336: t_entry_values_tab(j.indx).screen_entry_value := j.entry_value;
2337: END LOOP;
2338:
2339: if g_debug then
2340: pay_in_utils.trace('element_entry_id : ',t_challan_entry_asg_tab(i).element_entry_id);
2341: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2342: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
2343: pay_in_utils.trace('screen_entry_value2 : ',t_entry_values_tab(2).screen_entry_value);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2337: END LOOP;
2338:
2339: if g_debug then
2340: pay_in_utils.trace('element_entry_id : ',t_challan_entry_asg_tab(i).element_entry_id);
2341: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2342: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
2343: pay_in_utils.trace('screen_entry_value2 : ',t_entry_values_tab(2).screen_entry_value);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2338:
2339: if g_debug then
2340: pay_in_utils.trace('element_entry_id : ',t_challan_entry_asg_tab(i).element_entry_id);
2341: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2342: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
2343: pay_in_utils.trace('screen_entry_value2 : ',t_entry_values_tab(2).screen_entry_value);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2339: if g_debug then
2340: pay_in_utils.trace('element_entry_id : ',t_challan_entry_asg_tab(i).element_entry_id);
2341: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2342: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
2343: pay_in_utils.trace('screen_entry_value2 : ',t_entry_values_tab(2).screen_entry_value);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2340: pay_in_utils.trace('element_entry_id : ',t_challan_entry_asg_tab(i).element_entry_id);
2341: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2342: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
2343: pay_in_utils.trace('screen_entry_value2 : ',t_entry_values_tab(2).screen_entry_value);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2341: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2342: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
2343: pay_in_utils.trace('screen_entry_value2 : ',t_entry_values_tab(2).screen_entry_value);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2342: pay_in_utils.trace('person_id : ',p_person_table(1).person_id);
2343: pay_in_utils.trace('screen_entry_value2 : ',t_entry_values_tab(2).screen_entry_value);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2350: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
2343: pay_in_utils.trace('screen_entry_value2 : ',t_entry_values_tab(2).screen_entry_value);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2350: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
2351: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
2344: pay_in_utils.trace('screen_entry_value3 : ',t_entry_values_tab(3).screen_entry_value);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2350: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
2351: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
2352: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
2345: pay_in_utils.trace('screen_entry_value4 : ',t_entry_values_tab(4).screen_entry_value);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2350: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
2351: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
2352: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
2353: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
2346: pay_in_utils.trace('screen_entry_value5 : ',t_entry_values_tab(5).screen_entry_value);
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2350: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
2351: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
2352: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
2353: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
2354: end if;
2347: pay_in_utils.trace('screen_entry_value6 : ',t_entry_values_tab(6).screen_entry_value);
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2350: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
2351: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
2352: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
2353: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
2354: end if;
2355:
2348: pay_in_utils.trace('screen_entry_value7 : ',t_entry_values_tab(7).screen_entry_value);
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2350: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
2351: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
2352: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
2353: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
2354: end if;
2355:
2356: pay_action_information_api.create_action_information
2349: pay_in_utils.trace('screen_entry_value1 : ',t_entry_values_tab(1).screen_entry_value);
2350: pay_in_utils.trace('pan_number : ',p_person_table(1).pan_number);
2351: pay_in_utils.trace('pan_ref_number : ',p_person_table(1).pan_ref_number);
2352: pay_in_utils.trace('full_name : ',p_person_table(1).full_name);
2353: pay_in_utils.trace('tax_rate : ',p_person_table(1).tax_rate);
2354: end if;
2355:
2356: pay_action_information_api.create_action_information
2357: (p_action_context_id => p_arc_asg_action_id
2379:
2380: END LOOP;
2381: END IF;
2382:
2383: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,20);
2384:
2385: END archive_challan_asg;
2386: --------------------------------------------------------------------------
2387: -- --
2553:
2554:
2555: g_debug := hr_utility.debug_enabled;
2556: l_proc := g_package||'archive_code';
2557: pay_in_utils.set_location(g_debug,'Entering : '||l_proc||p_assignment_action_id,10);
2558:
2559: if g_debug then
2560: pay_in_utils.trace('******************************','********************');
2561: pay_in_utils.trace('p_assignment_action_id : ',p_assignment_action_id);
2556: l_proc := g_package||'archive_code';
2557: pay_in_utils.set_location(g_debug,'Entering : '||l_proc||p_assignment_action_id,10);
2558:
2559: if g_debug then
2560: pay_in_utils.trace('******************************','********************');
2561: pay_in_utils.trace('p_assignment_action_id : ',p_assignment_action_id);
2562: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2563: pay_in_utils.trace('******************************','********************');
2564: end if;
2557: pay_in_utils.set_location(g_debug,'Entering : '||l_proc||p_assignment_action_id,10);
2558:
2559: if g_debug then
2560: pay_in_utils.trace('******************************','********************');
2561: pay_in_utils.trace('p_assignment_action_id : ',p_assignment_action_id);
2562: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2563: pay_in_utils.trace('******************************','********************');
2564: end if;
2565:
2558:
2559: if g_debug then
2560: pay_in_utils.trace('******************************','********************');
2561: pay_in_utils.trace('p_assignment_action_id : ',p_assignment_action_id);
2562: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2563: pay_in_utils.trace('******************************','********************');
2564: end if;
2565:
2566: --
2559: if g_debug then
2560: pay_in_utils.trace('******************************','********************');
2561: pay_in_utils.trace('p_assignment_action_id : ',p_assignment_action_id);
2562: pay_in_utils.trace('p_effective_date : ',p_effective_date);
2563: pay_in_utils.trace('******************************','********************');
2564: end if;
2565:
2566: --
2567: l_count := 1;
2576: FETCH c_termination_check INTO l_actual_term_date;
2577: CLOSE c_termination_check;
2578:
2579: if g_debug then
2580: pay_in_utils.trace('l_assignment_id : ',l_assignment_id);
2581: pay_in_utils.trace('l_arc_pay_action_id : ',l_arc_pay_action_id);
2582: pay_in_utils.trace('l_person_id : ',l_person_id);
2583: pay_in_utils.trace('l_actual_term_date : ',l_actual_term_date);
2584: end if;
2577: CLOSE c_termination_check;
2578:
2579: if g_debug then
2580: pay_in_utils.trace('l_assignment_id : ',l_assignment_id);
2581: pay_in_utils.trace('l_arc_pay_action_id : ',l_arc_pay_action_id);
2582: pay_in_utils.trace('l_person_id : ',l_person_id);
2583: pay_in_utils.trace('l_actual_term_date : ',l_actual_term_date);
2584: end if;
2585:
2578:
2579: if g_debug then
2580: pay_in_utils.trace('l_assignment_id : ',l_assignment_id);
2581: pay_in_utils.trace('l_arc_pay_action_id : ',l_arc_pay_action_id);
2582: pay_in_utils.trace('l_person_id : ',l_person_id);
2583: pay_in_utils.trace('l_actual_term_date : ',l_actual_term_date);
2584: end if;
2585:
2586: pay_in_utils.set_location(g_debug,'Entering : '||l_assignment_id,11);
2579: if g_debug then
2580: pay_in_utils.trace('l_assignment_id : ',l_assignment_id);
2581: pay_in_utils.trace('l_arc_pay_action_id : ',l_arc_pay_action_id);
2582: pay_in_utils.trace('l_person_id : ',l_person_id);
2583: pay_in_utils.trace('l_actual_term_date : ',l_actual_term_date);
2584: end if;
2585:
2586: pay_in_utils.set_location(g_debug,'Entering : '||l_assignment_id,11);
2587: FOR c_gre_rec IN c_get_distinct_gre(l_assignment_id)
2582: pay_in_utils.trace('l_person_id : ',l_person_id);
2583: pay_in_utils.trace('l_actual_term_date : ',l_actual_term_date);
2584: end if;
2585:
2586: pay_in_utils.set_location(g_debug,'Entering : '||l_assignment_id,11);
2587: FOR c_gre_rec IN c_get_distinct_gre(l_assignment_id)
2588: LOOP
2589: if g_debug then
2590: pay_in_utils.trace('c_gre_rec.gre : ',c_gre_rec.gre);
2586: pay_in_utils.set_location(g_debug,'Entering : '||l_assignment_id,11);
2587: FOR c_gre_rec IN c_get_distinct_gre(l_assignment_id)
2588: LOOP
2589: if g_debug then
2590: pay_in_utils.trace('c_gre_rec.gre : ',c_gre_rec.gre);
2591: pay_in_utils.trace('g_session_date : ',g_session_date);
2592: end if;
2593:
2594: archive_challan_asg( p_arc_asg_action_id => p_assignment_action_id
2587: FOR c_gre_rec IN c_get_distinct_gre(l_assignment_id)
2588: LOOP
2589: if g_debug then
2590: pay_in_utils.trace('c_gre_rec.gre : ',c_gre_rec.gre);
2591: pay_in_utils.trace('g_session_date : ',g_session_date);
2592: end if;
2593:
2594: archive_challan_asg( p_arc_asg_action_id => p_assignment_action_id
2595: ,p_person_id => l_person_id
2601: END LOOP;
2602:
2603: -- Get all records from financial year start till current quarter end to find out
2604: -- previous GRE assignment_action_id and remaining pay periods
2605: pay_in_utils.set_location(g_debug,'Entering : '||l_assignment_id,12);
2606: FOR c_rec IN c_gre_records
2607: LOOP
2608: IF ((l_count <>1)
2609: AND
2621: END IF;
2622: l_count := l_count + 1;
2623: END LOOP;
2624:
2625: pay_in_utils.set_location(g_debug,'l_count : '||l_count,20);
2626:
2627: /* g_asg_tab.start/end date will contain the actual start/end of asg in a GRE or the the financial year .
2628: We need to change it to quarter date*/
2629:
2631: LOOP
2632: --Archive only if it is a candidate for reporting in the specified quarter
2633: IF (g_start_date <= g_asg_tab(i).end_date AND
2634: g_end_date >= g_asg_tab(i).start_date) THEN
2635: pay_in_utils.set_location(g_debug,'l_assignment_id : '||l_assignment_id||' ' ||g_asg_tab(i).start_date||' ' ||g_asg_tab(i).end_date||' ' ||g_asg_tab(i).gre_id,30);
2636:
2637: -- Get assignment action id corresponding to the maximum action sequence record
2638: OPEN get_eoy_archival_details(GREATEST(g_asg_tab(i).start_date,g_start_date)
2639: ,LEAST(g_asg_tab(i).end_date,g_end_date)
2719: END IF; -- RUN Assact is not null
2720: END IF; -- End of Archive
2721: END LOOP;
2722:
2723: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,40);
2724:
2725: EXCEPTION
2726: WHEN OTHERS THEN
2727: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
2723: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,40);
2724:
2725: EXCEPTION
2726: WHEN OTHERS THEN
2727: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
2728: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
2729: pay_in_utils.trace(l_message,l_proc);
2730: RAISE;
2731: END archive_code;
2724:
2725: EXCEPTION
2726: WHEN OTHERS THEN
2727: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
2728: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
2729: pay_in_utils.trace(l_message,l_proc);
2730: RAISE;
2731: END archive_code;
2732:
2725: EXCEPTION
2726: WHEN OTHERS THEN
2727: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
2728: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc, 50);
2729: pay_in_utils.trace(l_message,l_proc);
2730: RAISE;
2731: END archive_code;
2732:
2733: --------------------------------------------------------------------------
2820:
2821: g_debug := hr_utility.debug_enabled;
2822: l_proc := g_package || 'deinitialization_code';
2823:
2824: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,10);
2825:
2826: FOR c_challan_rec IN cur_challan_recs
2827: LOOP
2828: l_index := 0;
2837: );
2838: END LOOP;
2839: END LOOP;
2840:
2841: pay_in_utils.set_location(g_debug,'Entering : '||l_proc,20);
2842:
2843: FOR c_salary_rec IN cur_salary_recs
2844: LOOP
2845: l_index := 0;
2854: );
2855: END LOOP;
2856: END LOOP;
2857:
2858: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,50);
2859: EXCEPTION
2860: WHEN OTHERS THEN
2861: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
2862: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,70);
2857:
2858: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,50);
2859: EXCEPTION
2860: WHEN OTHERS THEN
2861: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
2862: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,70);
2863: pay_in_utils.trace(l_message,l_proc);
2864: RAISE;
2865: END deinitialization_code;
2858: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,50);
2859: EXCEPTION
2860: WHEN OTHERS THEN
2861: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
2862: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,70);
2863: pay_in_utils.trace(l_message,l_proc);
2864: RAISE;
2865: END deinitialization_code;
2866:
2859: EXCEPTION
2860: WHEN OTHERS THEN
2861: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_proc, 'SQLERRMC:'||sqlerrm);
2862: pay_in_utils.set_location(g_debug,'Leaving : '||l_proc,70);
2863: pay_in_utils.trace(l_message,l_proc);
2864: RAISE;
2865: END deinitialization_code;
2866:
2867: END pay_in_24q_archive;