[Home] [Help]
49: --
50: BEGIN
51: --
52: l_procedure := g_package || 'get_template';
53: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
54:
55: IF g_debug THEN
56: pay_in_utils.trace('**************************************************','********************');
57: pay_in_utils.trace('p_business_group_id',p_business_group_id);
52: l_procedure := g_package || 'get_template';
53: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
54:
55: IF g_debug THEN
56: pay_in_utils.trace('**************************************************','********************');
57: pay_in_utils.trace('p_business_group_id',p_business_group_id);
58: pay_in_utils.trace('**************************************************','********************');
59: END IF;
60:
53: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
54:
55: IF g_debug THEN
56: pay_in_utils.trace('**************************************************','********************');
57: pay_in_utils.trace('p_business_group_id',p_business_group_id);
58: pay_in_utils.trace('**************************************************','********************');
59: END IF;
60:
61:
54:
55: IF g_debug THEN
56: pay_in_utils.trace('**************************************************','********************');
57: pay_in_utils.trace('p_business_group_id',p_business_group_id);
58: pay_in_utils.trace('**************************************************','********************');
59: END IF;
60:
61:
62:
73: g_chunk_size := 500;
74: --
75: ELSE
76: --
77: pay_in_utils.trace('l_template ',l_template);
78: pay_in_utils.set_location(g_debug,l_procedure,20);
79: pay_in_utils.trace('g_chunk_size ',g_chunk_size);
80: pay_in_utils.set_location(g_debug,l_procedure,30);
81:
74: --
75: ELSE
76: --
77: pay_in_utils.trace('l_template ',l_template);
78: pay_in_utils.set_location(g_debug,l_procedure,20);
79: pay_in_utils.trace('g_chunk_size ',g_chunk_size);
80: pay_in_utils.set_location(g_debug,l_procedure,30);
81:
82: p_template := l_template;
75: ELSE
76: --
77: pay_in_utils.trace('l_template ',l_template);
78: pay_in_utils.set_location(g_debug,l_procedure,20);
79: pay_in_utils.trace('g_chunk_size ',g_chunk_size);
80: pay_in_utils.set_location(g_debug,l_procedure,30);
81:
82: p_template := l_template;
83: g_chunk_size := l_chunk_size;
76: --
77: pay_in_utils.trace('l_template ',l_template);
78: pay_in_utils.set_location(g_debug,l_procedure,20);
79: pay_in_utils.trace('g_chunk_size ',g_chunk_size);
80: pay_in_utils.set_location(g_debug,l_procedure,30);
81:
82: p_template := l_template;
83: g_chunk_size := l_chunk_size;
84: --
84: --
85: END IF;
86: --
87: IF g_debug THEN
88: pay_in_utils.trace('**************************************************','********************');
89: pay_in_utils.trace('p_template',p_template);
90: pay_in_utils.trace('**************************************************','********************');
91: END IF;
92:
85: END IF;
86: --
87: IF g_debug THEN
88: pay_in_utils.trace('**************************************************','********************');
89: pay_in_utils.trace('p_template',p_template);
90: pay_in_utils.trace('**************************************************','********************');
91: END IF;
92:
93: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
86: --
87: IF g_debug THEN
88: pay_in_utils.trace('**************************************************','********************');
89: pay_in_utils.trace('p_template',p_template);
90: pay_in_utils.trace('**************************************************','********************');
91: END IF;
92:
93: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
94:
89: pay_in_utils.trace('p_template',p_template);
90: pay_in_utils.trace('**************************************************','********************');
91: END IF;
92:
93: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
93: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
98: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
99: pay_in_utils.trace(l_message,l_procedure);
100:
101: IF csr_payslip_info%ISOPEN THEN
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
98: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
99: pay_in_utils.trace(l_message,l_procedure);
100:
101: IF csr_payslip_info%ISOPEN THEN
102: CLOSE csr_payslip_info;
95: EXCEPTION
96: WHEN OTHERS THEN
97: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
98: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
99: pay_in_utils.trace(l_message,l_procedure);
100:
101: IF csr_payslip_info%ISOPEN THEN
102: CLOSE csr_payslip_info;
103: END IF;
131: --
132: BEGIN
133: --
134: l_procedure := g_package || 'append_tag';
135: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
136:
137: IF g_debug THEN
138: pay_in_utils.trace('**************************************************','********************');
139: pay_in_utils.trace('p_tag_name',p_tag_name);
134: l_procedure := g_package || 'append_tag';
135: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
136:
137: IF g_debug THEN
138: pay_in_utils.trace('**************************************************','********************');
139: pay_in_utils.trace('p_tag_name',p_tag_name);
140: pay_in_utils.trace('p_value',p_value);
141: pay_in_utils.trace('**************************************************','********************');
142: END IF;
135: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
136:
137: IF g_debug THEN
138: pay_in_utils.trace('**************************************************','********************');
139: pay_in_utils.trace('p_tag_name',p_tag_name);
140: pay_in_utils.trace('p_value',p_value);
141: pay_in_utils.trace('**************************************************','********************');
142: END IF;
143:
136:
137: IF g_debug THEN
138: pay_in_utils.trace('**************************************************','********************');
139: pay_in_utils.trace('p_tag_name',p_tag_name);
140: pay_in_utils.trace('p_value',p_value);
141: pay_in_utils.trace('**************************************************','********************');
142: END IF;
143:
144: /*Bug 14699505 - Replace invalid characters. Only characters between ascii 32 and 126 allowed*/
137: IF g_debug THEN
138: pay_in_utils.trace('**************************************************','********************');
139: pay_in_utils.trace('p_tag_name',p_tag_name);
140: pay_in_utils.trace('p_value',p_value);
141: pay_in_utils.trace('**************************************************','********************');
142: END IF;
143:
144: /*Bug 14699505 - Replace invalid characters. Only characters between ascii 32 and 126 allowed*/
145: l_str1:=regexp_replace(p_value, '[^ -~]', '?');
142: END IF;
143:
144: /*Bug 14699505 - Replace invalid characters. Only characters between ascii 32 and 126 allowed*/
145: l_str1:=regexp_replace(p_value, '[^ -~]', '?');
146: pay_in_utils.trace('l_str1 ',l_str1);
147: IF(l_str1 <> p_value) THEN
148: fnd_file.put_line(fnd_file.log,'Invalid Character found in:'
149: ||p_tag_name||' -->'|| p_value);
150: fnd_file.put_line(fnd_file.log,'Invalid Character replaced with ?');
150: fnd_file.put_line(fnd_file.log,'Invalid Character replaced with ?');
151: END IF;
152:
153: /*Bug 4070869 - Encoded the data*/
154: l_str:= '<'||p_tag_name||'>'||pay_in_utils.ENCODE_HTML_STRING(l_str1)||'';
155:
156: pay_in_utils.trace('l_str ',l_str);
157: pay_in_utils.set_location(g_debug,l_procedure,20);
158:
152:
153: /*Bug 4070869 - Encoded the data*/
154: l_str:= '<'||p_tag_name||'>'||pay_in_utils.ENCODE_HTML_STRING(l_str1)||'';
155:
156: pay_in_utils.trace('l_str ',l_str);
157: pay_in_utils.set_location(g_debug,l_procedure,20);
158:
159: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
160:
153: /*Bug 4070869 - Encoded the data*/
154: l_str:= '<'||p_tag_name||'>'||pay_in_utils.ENCODE_HTML_STRING(l_str1)||'';
155:
156: pay_in_utils.trace('l_str ',l_str);
157: pay_in_utils.set_location(g_debug,l_procedure,20);
158:
159: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
160:
161: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
157: pay_in_utils.set_location(g_debug,l_procedure,20);
158:
159: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
160:
161: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
162:
163: END append_tag;
164:
165: --------------------------------------------------------------------------
183: --
184: BEGIN
185: --
186: l_procedure := g_package || 'open_tag';
187: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
188:
189: IF g_debug THEN
190: pay_in_utils.trace ('**************************************************','********************');
191: pay_in_utils.trace ('p_tag_name',p_tag_name);
186: l_procedure := g_package || 'open_tag';
187: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
188:
189: IF g_debug THEN
190: pay_in_utils.trace ('**************************************************','********************');
191: pay_in_utils.trace ('p_tag_name',p_tag_name);
192: pay_in_utils.trace ('**************************************************','********************');
193: END IF;
194:
187: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
188:
189: IF g_debug THEN
190: pay_in_utils.trace ('**************************************************','********************');
191: pay_in_utils.trace ('p_tag_name',p_tag_name);
192: pay_in_utils.trace ('**************************************************','********************');
193: END IF;
194:
195: l_str:= '<'||p_tag_name||'>';
188:
189: IF g_debug THEN
190: pay_in_utils.trace ('**************************************************','********************');
191: pay_in_utils.trace ('p_tag_name',p_tag_name);
192: pay_in_utils.trace ('**************************************************','********************');
193: END IF;
194:
195: l_str:= '<'||p_tag_name||'>';
196: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
194:
195: l_str:= '<'||p_tag_name||'>';
196: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
197:
198: pay_in_utils.trace('l_str ',l_str);
199: pay_in_utils.set_location(g_debug,l_procedure,20);
200:
201: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
202:
195: l_str:= '<'||p_tag_name||'>';
196: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
197:
198: pay_in_utils.trace('l_str ',l_str);
199: pay_in_utils.set_location(g_debug,l_procedure,20);
200:
201: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
202:
203: END open_tag;
197:
198: pay_in_utils.trace('l_str ',l_str);
199: pay_in_utils.set_location(g_debug,l_procedure,20);
200:
201: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
202:
203: END open_tag;
204:
205: --------------------------------------------------------------------------
223: --
224: BEGIN
225: --
226: l_procedure := g_package || 'close_tag';
227: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
228:
229: IF g_debug THEN
230: pay_in_utils.trace ('**************************************************','********************');
231: pay_in_utils.trace ('p_tag_name',p_tag_name);
226: l_procedure := g_package || 'close_tag';
227: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
228:
229: IF g_debug THEN
230: pay_in_utils.trace ('**************************************************','********************');
231: pay_in_utils.trace ('p_tag_name',p_tag_name);
232: pay_in_utils.trace ('**************************************************','********************');
233: END IF;
234:
227: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
228:
229: IF g_debug THEN
230: pay_in_utils.trace ('**************************************************','********************');
231: pay_in_utils.trace ('p_tag_name',p_tag_name);
232: pay_in_utils.trace ('**************************************************','********************');
233: END IF;
234:
235: l_str:= '';
228:
229: IF g_debug THEN
230: pay_in_utils.trace ('**************************************************','********************');
231: pay_in_utils.trace ('p_tag_name',p_tag_name);
232: pay_in_utils.trace ('**************************************************','********************');
233: END IF;
234:
235: l_str:= '';
236: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
234:
235: l_str:= '';
236: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
237:
238: pay_in_utils.trace('l_str ',l_str);
239: pay_in_utils.set_location(g_debug,l_procedure,20);
240:
241: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
242:
235: l_str:= '';
236: dbms_lob.writeAppend(g_tmp_clob,length(l_str),l_str);
237:
238: pay_in_utils.trace('l_str ',l_str);
239: pay_in_utils.set_location(g_debug,l_procedure,20);
240:
241: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
242:
243: END close_tag;
237:
238: pay_in_utils.trace('l_str ',l_str);
239: pay_in_utils.set_location(g_debug,l_procedure,20);
240:
241: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
242:
243: END close_tag;
244:
245: --------------------------------------------------------------------------
265: --
266: BEGIN
267: --
268: l_procedure := g_package || 'submit_req_xml_burst';
269: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
270:
271: IF g_debug THEN
272: pay_in_utils.trace('**************************************************','********************');
273: pay_in_utils.trace('p_request_id',TO_CHAR(p_request_id));
268: l_procedure := g_package || 'submit_req_xml_burst';
269: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
270:
271: IF g_debug THEN
272: pay_in_utils.trace('**************************************************','********************');
273: pay_in_utils.trace('p_request_id',TO_CHAR(p_request_id));
274: pay_in_utils.trace('**************************************************','********************');
275: END IF;
276:
269: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
270:
271: IF g_debug THEN
272: pay_in_utils.trace('**************************************************','********************');
273: pay_in_utils.trace('p_request_id',TO_CHAR(p_request_id));
274: pay_in_utils.trace('**************************************************','********************');
275: END IF;
276:
277: UPDATE fnd_concurrent_requests
270:
271: IF g_debug THEN
272: pay_in_utils.trace('**************************************************','********************');
273: pay_in_utils.trace('p_request_id',TO_CHAR(p_request_id));
274: pay_in_utils.trace('**************************************************','********************');
275: END IF;
276:
277: UPDATE fnd_concurrent_requests
278: SET output_file_type = 'XML'
345:
346: BEGIN
347: g_debug := hr_utility.debug_enabled;
348: l_procedure := g_package ||'get_location_details';
349: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
350:
351: IF g_debug THEN
352: pay_in_utils.trace('**************************************************','********************');
353: pay_in_utils.trace('p_address_id ',p_address_id );
348: l_procedure := g_package ||'get_location_details';
349: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
350:
351: IF g_debug THEN
352: pay_in_utils.trace('**************************************************','********************');
353: pay_in_utils.trace('p_address_id ',p_address_id );
354: pay_in_utils.trace('p_concatenate',p_concatenate);
355: pay_in_utils.trace('p_field' ,p_field );
356: pay_in_utils.trace('**************************************************','********************');
349: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
350:
351: IF g_debug THEN
352: pay_in_utils.trace('**************************************************','********************');
353: pay_in_utils.trace('p_address_id ',p_address_id );
354: pay_in_utils.trace('p_concatenate',p_concatenate);
355: pay_in_utils.trace('p_field' ,p_field );
356: pay_in_utils.trace('**************************************************','********************');
357: END IF;
350:
351: IF g_debug THEN
352: pay_in_utils.trace('**************************************************','********************');
353: pay_in_utils.trace('p_address_id ',p_address_id );
354: pay_in_utils.trace('p_concatenate',p_concatenate);
355: pay_in_utils.trace('p_field' ,p_field );
356: pay_in_utils.trace('**************************************************','********************');
357: END IF;
358:
351: IF g_debug THEN
352: pay_in_utils.trace('**************************************************','********************');
353: pay_in_utils.trace('p_address_id ',p_address_id );
354: pay_in_utils.trace('p_concatenate',p_concatenate);
355: pay_in_utils.trace('p_field' ,p_field );
356: pay_in_utils.trace('**************************************************','********************');
357: END IF;
358:
359: OPEN csr_get_address_details;
352: pay_in_utils.trace('**************************************************','********************');
353: pay_in_utils.trace('p_address_id ',p_address_id );
354: pay_in_utils.trace('p_concatenate',p_concatenate);
355: pay_in_utils.trace('p_field' ,p_field );
356: pay_in_utils.trace('**************************************************','********************');
357: END IF;
358:
359: OPEN csr_get_address_details;
360: FETCH csr_get_address_details
402:
403:
404:
405: IF g_debug THEN
406: pay_in_utils.trace('l_details',l_details);
407: END IF;
408:
409: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
410: RETURN l_details;
405: IF g_debug THEN
406: pay_in_utils.trace('l_details',l_details);
407: END IF;
408:
409: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
410: RETURN l_details;
411:
412: END get_address_details;
413:
444: --
445: BEGIN
446: --
447: l_procedure := g_package || 'get_emp_address';
448: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
449:
450: IF g_debug THEN
451: pay_in_utils.trace('**************************************************','********************');
452: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
447: l_procedure := g_package || 'get_emp_address';
448: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
449:
450: IF g_debug THEN
451: pay_in_utils.trace('**************************************************','********************');
452: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
453: pay_in_utils.trace('p_date ',TO_CHAR(p_date));
454: pay_in_utils.trace('**************************************************','********************');
455: END IF;
448: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
449:
450: IF g_debug THEN
451: pay_in_utils.trace('**************************************************','********************');
452: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
453: pay_in_utils.trace('p_date ',TO_CHAR(p_date));
454: pay_in_utils.trace('**************************************************','********************');
455: END IF;
456:
449:
450: IF g_debug THEN
451: pay_in_utils.trace('**************************************************','********************');
452: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
453: pay_in_utils.trace('p_date ',TO_CHAR(p_date));
454: pay_in_utils.trace('**************************************************','********************');
455: END IF;
456:
457: OPEN c_employee_address;
450: IF g_debug THEN
451: pay_in_utils.trace('**************************************************','********************');
452: pay_in_utils.trace('p_person_id',TO_CHAR(p_person_id));
453: pay_in_utils.trace('p_date ',TO_CHAR(p_date));
454: pay_in_utils.trace('**************************************************','********************');
455: END IF;
456:
457: OPEN c_employee_address;
458: FETCH c_employee_address INTO l_emp_addr_id ;
460:
461:
462: l_emp_addr := get_address_details(l_emp_addr_id,'Y','NULL');
463:
464: pay_in_utils.set_location(g_debug,'l_emp_addr: '||l_emp_addr,10);
465: RETURN l_emp_addr;
466:
467: END get_emp_address;
468:
493: --
494: BEGIN
495: --
496: l_procedure := g_package || 'get_emp_email';
497: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
498:
499: IF g_debug THEN
500: pay_in_utils.trace('**************************************************','********************');
501: pay_in_utils.trace('p_assign_action_id',TO_CHAR(p_assign_action_id));
496: l_procedure := g_package || 'get_emp_email';
497: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
498:
499: IF g_debug THEN
500: pay_in_utils.trace('**************************************************','********************');
501: pay_in_utils.trace('p_assign_action_id',TO_CHAR(p_assign_action_id));
502: pay_in_utils.trace('**************************************************','********************');
503: END IF;
504:
497: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
498:
499: IF g_debug THEN
500: pay_in_utils.trace('**************************************************','********************');
501: pay_in_utils.trace('p_assign_action_id',TO_CHAR(p_assign_action_id));
502: pay_in_utils.trace('**************************************************','********************');
503: END IF;
504:
505: OPEN c_emp_email_id;
498:
499: IF g_debug THEN
500: pay_in_utils.trace('**************************************************','********************');
501: pay_in_utils.trace('p_assign_action_id',TO_CHAR(p_assign_action_id));
502: pay_in_utils.trace('**************************************************','********************');
503: END IF;
504:
505: OPEN c_emp_email_id;
506: FETCH c_emp_email_id INTO l_emp_email_id ;
506: FETCH c_emp_email_id INTO l_emp_email_id ;
507:
508: IF c_emp_email_id%NOTFOUND THEN
509: l_emp_email_id := '';
510: pay_in_utils.set_location(g_debug,l_procedure,20);
511: END IF;
512: CLOSE c_emp_email_id;
513:
514: RETURN l_emp_email_id;
566: --
567: BEGIN
568: --
569: l_procedure := g_package || 'append_elements';
570: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
571:
572: IF g_debug THEN
573: pay_in_utils.trace ('**************************************************','********************');
574: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
569: l_procedure := g_package || 'append_elements';
570: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
571:
572: IF g_debug THEN
573: pay_in_utils.trace ('**************************************************','********************');
574: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
575: pay_in_utils.trace ('p_classification_name',p_classification_name);
576: pay_in_utils.trace ('**************************************************','********************');
577: END IF;
570: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
571:
572: IF g_debug THEN
573: pay_in_utils.trace ('**************************************************','********************');
574: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
575: pay_in_utils.trace ('p_classification_name',p_classification_name);
576: pay_in_utils.trace ('**************************************************','********************');
577: END IF;
578:
571:
572: IF g_debug THEN
573: pay_in_utils.trace ('**************************************************','********************');
574: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
575: pay_in_utils.trace ('p_classification_name',p_classification_name);
576: pay_in_utils.trace ('**************************************************','********************');
577: END IF;
578:
579:
572: IF g_debug THEN
573: pay_in_utils.trace ('**************************************************','********************');
574: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
575: pay_in_utils.trace ('p_classification_name',p_classification_name);
576: pay_in_utils.trace ('**************************************************','********************');
577: END IF;
578:
579:
580: l_total := 0;
593: --
594: END IF;
595: open_tag(l_classification_tag);
596:
597: pay_in_utils.trace('l_classification_tag ',l_classification_tag);
598: pay_in_utils.set_location(g_debug,l_procedure,20);
599:
600: IF (l_classification_tag = 'Earnings') THEN
601: FOR rec in csr_elements_earnings
594: END IF;
595: open_tag(l_classification_tag);
596:
597: pay_in_utils.trace('l_classification_tag ',l_classification_tag);
598: pay_in_utils.set_location(g_debug,l_procedure,20);
599:
600: IF (l_classification_tag = 'Earnings') THEN
601: FOR rec in csr_elements_earnings
602: LOOP
603: --
604: l_rec_exists := TRUE;
605: open_tag(l_classification_tag || 'Element');
606:
607: pay_in_utils.trace('Element Name : ',rec.ename);
608: pay_in_utils.set_location(g_debug,l_procedure,30);
609: pay_in_utils.trace('This Pay : ',rec.amt);
610: pay_in_utils.set_location(g_debug,l_procedure,40);
611:
604: l_rec_exists := TRUE;
605: open_tag(l_classification_tag || 'Element');
606:
607: pay_in_utils.trace('Element Name : ',rec.ename);
608: pay_in_utils.set_location(g_debug,l_procedure,30);
609: pay_in_utils.trace('This Pay : ',rec.amt);
610: pay_in_utils.set_location(g_debug,l_procedure,40);
611:
612: append_tag('Description',rec.ename);
605: open_tag(l_classification_tag || 'Element');
606:
607: pay_in_utils.trace('Element Name : ',rec.ename);
608: pay_in_utils.set_location(g_debug,l_procedure,30);
609: pay_in_utils.trace('This Pay : ',rec.amt);
610: pay_in_utils.set_location(g_debug,l_procedure,40);
611:
612: append_tag('Description',rec.ename);
613: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
606:
607: pay_in_utils.trace('Element Name : ',rec.ename);
608: pay_in_utils.set_location(g_debug,l_procedure,30);
609: pay_in_utils.trace('This Pay : ',rec.amt);
610: pay_in_utils.set_location(g_debug,l_procedure,40);
611:
612: append_tag('Description',rec.ename);
613: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
614: g_business_group_id
625: --
626: l_rec_exists := TRUE;
627: open_tag(l_classification_tag || 'Element');
628:
629: pay_in_utils.trace('Element Name : ',rec.ename);
630: pay_in_utils.set_location(g_debug,l_procedure,30);
631: pay_in_utils.trace('This Pay : ',rec.amt);
632: pay_in_utils.set_location(g_debug,l_procedure,40);
633:
626: l_rec_exists := TRUE;
627: open_tag(l_classification_tag || 'Element');
628:
629: pay_in_utils.trace('Element Name : ',rec.ename);
630: pay_in_utils.set_location(g_debug,l_procedure,30);
631: pay_in_utils.trace('This Pay : ',rec.amt);
632: pay_in_utils.set_location(g_debug,l_procedure,40);
633:
634: append_tag('Description',rec.ename);
627: open_tag(l_classification_tag || 'Element');
628:
629: pay_in_utils.trace('Element Name : ',rec.ename);
630: pay_in_utils.set_location(g_debug,l_procedure,30);
631: pay_in_utils.trace('This Pay : ',rec.amt);
632: pay_in_utils.set_location(g_debug,l_procedure,40);
633:
634: append_tag('Description',rec.ename);
635: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
628:
629: pay_in_utils.trace('Element Name : ',rec.ename);
630: pay_in_utils.set_location(g_debug,l_procedure,30);
631: pay_in_utils.trace('This Pay : ',rec.amt);
632: pay_in_utils.set_location(g_debug,l_procedure,40);
633:
634: append_tag('Description',rec.ename);
635: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
636: g_business_group_id
641: --
642: END LOOP;
643: END IF;
644:
645: pay_in_utils.trace('l_total : ',l_total);
646: pay_in_utils.set_location(g_debug,l_procedure,50);
647:
648: IF l_rec_exists = FALSE THEN
649: --
642: END LOOP;
643: END IF;
644:
645: pay_in_utils.trace('l_total : ',l_total);
646: pay_in_utils.set_location(g_debug,l_procedure,50);
647:
648: IF l_rec_exists = FALSE THEN
649: --
650: open_tag(l_classification_tag|| 'Element');
662:
663: close_tag(l_classification_tag);
664:
665:
666: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
667:
668: EXCEPTION
669: WHEN others THEN
670: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
666: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
667:
668: EXCEPTION
669: WHEN others THEN
670: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
671: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
672: pay_in_utils.trace(l_message,l_procedure);
673:
674: IF csr_elements%ISOPEN THEN
667:
668: EXCEPTION
669: WHEN others THEN
670: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
671: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
672: pay_in_utils.trace(l_message,l_procedure);
673:
674: IF csr_elements%ISOPEN THEN
675: CLOSE csr_elements;
668: EXCEPTION
669: WHEN others THEN
670: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
671: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
672: pay_in_utils.trace(l_message,l_procedure);
673:
674: IF csr_elements%ISOPEN THEN
675: CLOSE csr_elements;
676: END IF;
714: --
715: BEGIN
716: --
717: l_procedure := g_package || 'append_net_pay';
718: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
719:
720: IF g_debug THEN
721: pay_in_utils.trace ('**************************************************','********************');
722: pay_in_utils.trace (' p_action_context_id', p_action_context_id);
717: l_procedure := g_package || 'append_net_pay';
718: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
719:
720: IF g_debug THEN
721: pay_in_utils.trace ('**************************************************','********************');
722: pay_in_utils.trace (' p_action_context_id', p_action_context_id);
723: pay_in_utils.trace ('**************************************************','********************');
724: END IF;
725:
718: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
719:
720: IF g_debug THEN
721: pay_in_utils.trace ('**************************************************','********************');
722: pay_in_utils.trace (' p_action_context_id', p_action_context_id);
723: pay_in_utils.trace ('**************************************************','********************');
724: END IF;
725:
726:
719:
720: IF g_debug THEN
721: pay_in_utils.trace ('**************************************************','********************');
722: pay_in_utils.trace (' p_action_context_id', p_action_context_id);
723: pay_in_utils.trace ('**************************************************','********************');
724: END IF;
725:
726:
727: open_tag('NetPay');
747: CLOSE csr_sum_amt;
748:
749: l_gross_earnings := l_gross_earnings + NVL(l_advances,0)+ NVL(l_fbenefits,0) + NVL(l_mon_perks,0);
750:
751: pay_in_utils.trace('l_gross_earnings : ',l_gross_earnings);
752: pay_in_utils.set_location(g_debug,l_procedure,20);
753:
754: append_tag('GrossEarnings',pay_us_employee_payslip_web.get_format_value(
755: g_business_group_id
748:
749: l_gross_earnings := l_gross_earnings + NVL(l_advances,0)+ NVL(l_fbenefits,0) + NVL(l_mon_perks,0);
750:
751: pay_in_utils.trace('l_gross_earnings : ',l_gross_earnings);
752: pay_in_utils.set_location(g_debug,l_procedure,20);
753:
754: append_tag('GrossEarnings',pay_us_employee_payslip_web.get_format_value(
755: g_business_group_id
756: ,l_gross_earnings));
761: INTO l_gross_deductions;
762: CLOSE csr_sum_amt;
763:
764: l_gross_deductions := NVL(l_gross_deductions,0);
765: pay_in_utils.trace('l_gross_deductions ',l_gross_deductions);
766: pay_in_utils.set_location(g_debug,l_procedure,30);
767:
768: append_tag('GrossDeductions',pay_us_employee_payslip_web.get_format_value(
769: g_business_group_id
762: CLOSE csr_sum_amt;
763:
764: l_gross_deductions := NVL(l_gross_deductions,0);
765: pay_in_utils.trace('l_gross_deductions ',l_gross_deductions);
766: pay_in_utils.set_location(g_debug,l_procedure,30);
767:
768: append_tag('GrossDeductions',pay_us_employee_payslip_web.get_format_value(
769: g_business_group_id
770: ,l_gross_deductions));
770: ,l_gross_deductions));
771:
772: l_net_pay:=l_gross_earnings - l_gross_deductions;
773:
774: pay_in_utils.trace('l_net_pay ',l_net_pay);
775: pay_in_utils.set_location(g_debug,l_procedure,30);
776:
777: append_tag('Pay',pay_us_employee_payslip_web.get_format_value(
778: g_business_group_id
771:
772: l_net_pay:=l_gross_earnings - l_gross_deductions;
773:
774: pay_in_utils.trace('l_net_pay ',l_net_pay);
775: pay_in_utils.set_location(g_debug,l_procedure,30);
776:
777: append_tag('Pay',pay_us_employee_payslip_web.get_format_value(
778: g_business_group_id
779: ,l_net_pay));
781:
782: close_tag('NetPay');
783:
784: --
785: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
786:
787: EXCEPTION
788: WHEN others THEN
789: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
785: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
786:
787: EXCEPTION
788: WHEN others THEN
789: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
790: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
791: pay_in_utils.trace(l_message,l_procedure);
792:
793: IF csr_sum_amt%ISOPEN THEN
786:
787: EXCEPTION
788: WHEN others THEN
789: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
790: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
791: pay_in_utils.trace(l_message,l_procedure);
792:
793: IF csr_sum_amt%ISOPEN THEN
794: CLOSE csr_sum_amt;
787: EXCEPTION
788: WHEN others THEN
789: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
790: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
791: pay_in_utils.trace(l_message,l_procedure);
792:
793: IF csr_sum_amt%ISOPEN THEN
794: CLOSE csr_sum_amt;
795: END IF;
827: --
828: BEGIN
829: --
830: l_procedure := g_package ||'append_balances';
831: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
832:
833: IF g_debug THEN
834: pay_in_utils.trace ('**************************************************','********************');
835: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
830: l_procedure := g_package ||'append_balances';
831: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
832:
833: IF g_debug THEN
834: pay_in_utils.trace ('**************************************************','********************');
835: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
836: pay_in_utils.trace ('**************************************************','********************');
837: END IF;
838:
831: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
832:
833: IF g_debug THEN
834: pay_in_utils.trace ('**************************************************','********************');
835: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
836: pay_in_utils.trace ('**************************************************','********************');
837: END IF;
838:
839:
832:
833: IF g_debug THEN
834: pay_in_utils.trace ('**************************************************','********************');
835: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
836: pay_in_utils.trace ('**************************************************','********************');
837: END IF;
838:
839:
840: open_tag('Balances');
843: LOOP
844: --
845: open_tag('Balance');
846:
847: pay_in_utils.trace('Balance Name : ',rec.bname);
848: pay_in_utils.set_location(g_debug,l_procedure,20);
849: pay_in_utils.trace('YTD : ',rec.ytd);
850: pay_in_utils.set_location(g_debug,l_procedure,30);
851:
844: --
845: open_tag('Balance');
846:
847: pay_in_utils.trace('Balance Name : ',rec.bname);
848: pay_in_utils.set_location(g_debug,l_procedure,20);
849: pay_in_utils.trace('YTD : ',rec.ytd);
850: pay_in_utils.set_location(g_debug,l_procedure,30);
851:
852: append_tag('Description',rec.bname);
845: open_tag('Balance');
846:
847: pay_in_utils.trace('Balance Name : ',rec.bname);
848: pay_in_utils.set_location(g_debug,l_procedure,20);
849: pay_in_utils.trace('YTD : ',rec.ytd);
850: pay_in_utils.set_location(g_debug,l_procedure,30);
851:
852: append_tag('Description',rec.bname);
853: append_tag('YTD',pay_us_employee_payslip_web.get_format_value(
846:
847: pay_in_utils.trace('Balance Name : ',rec.bname);
848: pay_in_utils.set_location(g_debug,l_procedure,20);
849: pay_in_utils.trace('YTD : ',rec.ytd);
850: pay_in_utils.set_location(g_debug,l_procedure,30);
851:
852: append_tag('Description',rec.bname);
853: append_tag('YTD',pay_us_employee_payslip_web.get_format_value(
854: g_business_group_id
858: --
859: END LOOP;
860:
861: close_tag('Balances');
862: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
863:
864: EXCEPTION
865: WHEN others THEN
866: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
862: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
863:
864: EXCEPTION
865: WHEN others THEN
866: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
867: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
868: pay_in_utils.trace(l_message,l_procedure);
869:
870: IF csr_balances%ISOPEN THEN
863:
864: EXCEPTION
865: WHEN others THEN
866: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
867: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
868: pay_in_utils.trace(l_message,l_procedure);
869:
870: IF csr_balances%ISOPEN THEN
871: CLOSE csr_balances;
864: EXCEPTION
865: WHEN others THEN
866: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
867: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
868: pay_in_utils.trace(l_message,l_procedure);
869:
870: IF csr_balances%ISOPEN THEN
871: CLOSE csr_balances;
872: END IF;
908: BEGIN
909: --
910: l_rec_exists := FALSE;
911: l_procedure := g_package ||'append_other_elements';
912: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
913:
914: IF g_debug THEN
915: pay_in_utils.trace ('**************************************************','********************');
916: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
911: l_procedure := g_package ||'append_other_elements';
912: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
913:
914: IF g_debug THEN
915: pay_in_utils.trace ('**************************************************','********************');
916: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
917: pay_in_utils.trace ('**************************************************','********************');
918: END IF;
919:
912: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
913:
914: IF g_debug THEN
915: pay_in_utils.trace ('**************************************************','********************');
916: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
917: pay_in_utils.trace ('**************************************************','********************');
918: END IF;
919:
920: open_tag('EMEAElements');
913:
914: IF g_debug THEN
915: pay_in_utils.trace ('**************************************************','********************');
916: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
917: pay_in_utils.trace ('**************************************************','********************');
918: END IF;
919:
920: open_tag('EMEAElements');
921:
925: l_rec_exists := TRUE;
926: open_tag('EMEAElement');
927:
928:
929: pay_in_utils.trace('Element Name : ',rec.narrative);
930: pay_in_utils.set_location(g_debug,l_procedure,20);
931: pay_in_utils.trace('Value : ',rec.amount);
932: pay_in_utils.set_location(g_debug,l_procedure,30);
933:
926: open_tag('EMEAElement');
927:
928:
929: pay_in_utils.trace('Element Name : ',rec.narrative);
930: pay_in_utils.set_location(g_debug,l_procedure,20);
931: pay_in_utils.trace('Value : ',rec.amount);
932: pay_in_utils.set_location(g_debug,l_procedure,30);
933:
934: append_tag('Description',rec.narrative);
927:
928:
929: pay_in_utils.trace('Element Name : ',rec.narrative);
930: pay_in_utils.set_location(g_debug,l_procedure,20);
931: pay_in_utils.trace('Value : ',rec.amount);
932: pay_in_utils.set_location(g_debug,l_procedure,30);
933:
934: append_tag('Description',rec.narrative);
935:
928:
929: pay_in_utils.trace('Element Name : ',rec.narrative);
930: pay_in_utils.set_location(g_debug,l_procedure,20);
931: pay_in_utils.trace('Value : ',rec.amount);
932: pay_in_utils.set_location(g_debug,l_procedure,30);
933:
934: append_tag('Description',rec.narrative);
935:
936: BEGIN
957: --
958: END IF;
959: close_tag('EMEAElements');
960:
961: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
961: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
966: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
967: pay_in_utils.trace(l_message,l_procedure);
968:
969: IF csr_other_elements%ISOPEN THEN
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
966: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
967: pay_in_utils.trace(l_message,l_procedure);
968:
969: IF csr_other_elements%ISOPEN THEN
970: CLOSE csr_other_elements;
963: EXCEPTION
964: WHEN OTHERS THEN
965: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
966: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
967: pay_in_utils.trace(l_message,l_procedure);
968:
969: IF csr_other_elements%ISOPEN THEN
970: CLOSE csr_other_elements;
971: END IF;
1005: --
1006: BEGIN
1007: --
1008: l_procedure := g_package ||'append_accruals';
1009: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1010:
1011: IF g_debug THEN
1012: pay_in_utils.trace ('**************************************************','********************');
1013: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1008: l_procedure := g_package ||'append_accruals';
1009: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1010:
1011: IF g_debug THEN
1012: pay_in_utils.trace ('**************************************************','********************');
1013: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1014: pay_in_utils.trace ('**************************************************','********************');
1015: END IF;
1016:
1009: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1010:
1011: IF g_debug THEN
1012: pay_in_utils.trace ('**************************************************','********************');
1013: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1014: pay_in_utils.trace ('**************************************************','********************');
1015: END IF;
1016:
1017: l_rec_exists := FALSE;
1010:
1011: IF g_debug THEN
1012: pay_in_utils.trace ('**************************************************','********************');
1013: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1014: pay_in_utils.trace ('**************************************************','********************');
1015: END IF;
1016:
1017: l_rec_exists := FALSE;
1018: open_tag('Accruals');
1022: --
1023: l_rec_exists := TRUE;
1024: open_tag('AccrualPlan');
1025:
1026: pay_in_utils.trace('Plan Name : ',rec.plan_name);
1027: pay_in_utils.set_location(g_debug,l_procedure,20);
1028: pay_in_utils.trace('UOM : ',rec.uom);
1029: pay_in_utils.set_location(g_debug,l_procedure,30);
1030: pay_in_utils.trace('Accrual Balance : ',rec.balance);
1023: l_rec_exists := TRUE;
1024: open_tag('AccrualPlan');
1025:
1026: pay_in_utils.trace('Plan Name : ',rec.plan_name);
1027: pay_in_utils.set_location(g_debug,l_procedure,20);
1028: pay_in_utils.trace('UOM : ',rec.uom);
1029: pay_in_utils.set_location(g_debug,l_procedure,30);
1030: pay_in_utils.trace('Accrual Balance : ',rec.balance);
1031: pay_in_utils.set_location(g_debug,l_procedure,40);
1024: open_tag('AccrualPlan');
1025:
1026: pay_in_utils.trace('Plan Name : ',rec.plan_name);
1027: pay_in_utils.set_location(g_debug,l_procedure,20);
1028: pay_in_utils.trace('UOM : ',rec.uom);
1029: pay_in_utils.set_location(g_debug,l_procedure,30);
1030: pay_in_utils.trace('Accrual Balance : ',rec.balance);
1031: pay_in_utils.set_location(g_debug,l_procedure,40);
1032:
1025:
1026: pay_in_utils.trace('Plan Name : ',rec.plan_name);
1027: pay_in_utils.set_location(g_debug,l_procedure,20);
1028: pay_in_utils.trace('UOM : ',rec.uom);
1029: pay_in_utils.set_location(g_debug,l_procedure,30);
1030: pay_in_utils.trace('Accrual Balance : ',rec.balance);
1031: pay_in_utils.set_location(g_debug,l_procedure,40);
1032:
1033: /* Bug 4218967 Changed the tag AccrBalance to Balance */
1026: pay_in_utils.trace('Plan Name : ',rec.plan_name);
1027: pay_in_utils.set_location(g_debug,l_procedure,20);
1028: pay_in_utils.trace('UOM : ',rec.uom);
1029: pay_in_utils.set_location(g_debug,l_procedure,30);
1030: pay_in_utils.trace('Accrual Balance : ',rec.balance);
1031: pay_in_utils.set_location(g_debug,l_procedure,40);
1032:
1033: /* Bug 4218967 Changed the tag AccrBalance to Balance */
1034: append_tag('PlanName',rec.plan_name);
1027: pay_in_utils.set_location(g_debug,l_procedure,20);
1028: pay_in_utils.trace('UOM : ',rec.uom);
1029: pay_in_utils.set_location(g_debug,l_procedure,30);
1030: pay_in_utils.trace('Accrual Balance : ',rec.balance);
1031: pay_in_utils.set_location(g_debug,l_procedure,40);
1032:
1033: /* Bug 4218967 Changed the tag AccrBalance to Balance */
1034: append_tag('PlanName',rec.plan_name);
1035: append_tag('UOM',rec.uom);
1053: --
1054: END IF;
1055: close_tag('Accruals');
1056:
1057: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
1058:
1059: EXCEPTION
1060: WHEN others THEN
1061: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1057: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
1058:
1059: EXCEPTION
1060: WHEN others THEN
1061: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1062: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1063: pay_in_utils.trace(l_message,l_procedure);
1064:
1065: IF csr_accruals%ISOPEN THEN
1058:
1059: EXCEPTION
1060: WHEN others THEN
1061: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1062: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1063: pay_in_utils.trace(l_message,l_procedure);
1064:
1065: IF csr_accruals%ISOPEN THEN
1066: CLOSE csr_accruals;
1059: EXCEPTION
1060: WHEN others THEN
1061: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1062: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1063: pay_in_utils.trace(l_message,l_procedure);
1064:
1065: IF csr_accruals%ISOPEN THEN
1066: CLOSE csr_accruals;
1067: END IF;
1102: --
1103: BEGIN
1104: --
1105: l_procedure := g_package || 'append_absences';
1106: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1107:
1108: IF g_debug THEN
1109: pay_in_utils.trace ('**************************************************','********************');
1110: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1105: l_procedure := g_package || 'append_absences';
1106: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1107:
1108: IF g_debug THEN
1109: pay_in_utils.trace ('**************************************************','********************');
1110: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1111: pay_in_utils.trace ('**************************************************','********************');
1112: END IF;
1113:
1106: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1107:
1108: IF g_debug THEN
1109: pay_in_utils.trace ('**************************************************','********************');
1110: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1111: pay_in_utils.trace ('**************************************************','********************');
1112: END IF;
1113:
1114: l_rec_exists := FALSE;
1107:
1108: IF g_debug THEN
1109: pay_in_utils.trace ('**************************************************','********************');
1110: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1111: pay_in_utils.trace ('**************************************************','********************');
1112: END IF;
1113:
1114: l_rec_exists := FALSE;
1115: open_tag('Absences');
1119: --
1120: l_rec_exists := TRUE;
1121: open_tag('Absence');
1122:
1123: pay_in_utils.trace('Absence Name : ',rec.absence_name);
1124: pay_in_utils.set_location(g_debug,l_procedure,20);
1125: pay_in_utils.trace('Start Date : ',to_char(rec.start_date,'DD-MON-YYYY'));
1126: pay_in_utils.set_location(g_debug,l_procedure,30);
1127: pay_in_utils.trace('End Date : ',to_char(rec.end_date,'DD-MON-YYYY'));
1120: l_rec_exists := TRUE;
1121: open_tag('Absence');
1122:
1123: pay_in_utils.trace('Absence Name : ',rec.absence_name);
1124: pay_in_utils.set_location(g_debug,l_procedure,20);
1125: pay_in_utils.trace('Start Date : ',to_char(rec.start_date,'DD-MON-YYYY'));
1126: pay_in_utils.set_location(g_debug,l_procedure,30);
1127: pay_in_utils.trace('End Date : ',to_char(rec.end_date,'DD-MON-YYYY'));
1128: pay_in_utils.set_location(g_debug,l_procedure,40);
1121: open_tag('Absence');
1122:
1123: pay_in_utils.trace('Absence Name : ',rec.absence_name);
1124: pay_in_utils.set_location(g_debug,l_procedure,20);
1125: pay_in_utils.trace('Start Date : ',to_char(rec.start_date,'DD-MON-YYYY'));
1126: pay_in_utils.set_location(g_debug,l_procedure,30);
1127: pay_in_utils.trace('End Date : ',to_char(rec.end_date,'DD-MON-YYYY'));
1128: pay_in_utils.set_location(g_debug,l_procedure,40);
1129: pay_in_utils.trace('This Pay : ',rec.absence_value);
1122:
1123: pay_in_utils.trace('Absence Name : ',rec.absence_name);
1124: pay_in_utils.set_location(g_debug,l_procedure,20);
1125: pay_in_utils.trace('Start Date : ',to_char(rec.start_date,'DD-MON-YYYY'));
1126: pay_in_utils.set_location(g_debug,l_procedure,30);
1127: pay_in_utils.trace('End Date : ',to_char(rec.end_date,'DD-MON-YYYY'));
1128: pay_in_utils.set_location(g_debug,l_procedure,40);
1129: pay_in_utils.trace('This Pay : ',rec.absence_value);
1130: pay_in_utils.set_location(g_debug,l_procedure,50);
1123: pay_in_utils.trace('Absence Name : ',rec.absence_name);
1124: pay_in_utils.set_location(g_debug,l_procedure,20);
1125: pay_in_utils.trace('Start Date : ',to_char(rec.start_date,'DD-MON-YYYY'));
1126: pay_in_utils.set_location(g_debug,l_procedure,30);
1127: pay_in_utils.trace('End Date : ',to_char(rec.end_date,'DD-MON-YYYY'));
1128: pay_in_utils.set_location(g_debug,l_procedure,40);
1129: pay_in_utils.trace('This Pay : ',rec.absence_value);
1130: pay_in_utils.set_location(g_debug,l_procedure,50);
1131:
1124: pay_in_utils.set_location(g_debug,l_procedure,20);
1125: pay_in_utils.trace('Start Date : ',to_char(rec.start_date,'DD-MON-YYYY'));
1126: pay_in_utils.set_location(g_debug,l_procedure,30);
1127: pay_in_utils.trace('End Date : ',to_char(rec.end_date,'DD-MON-YYYY'));
1128: pay_in_utils.set_location(g_debug,l_procedure,40);
1129: pay_in_utils.trace('This Pay : ',rec.absence_value);
1130: pay_in_utils.set_location(g_debug,l_procedure,50);
1131:
1132: append_tag('AbsenceName',rec.absence_name);
1125: pay_in_utils.trace('Start Date : ',to_char(rec.start_date,'DD-MON-YYYY'));
1126: pay_in_utils.set_location(g_debug,l_procedure,30);
1127: pay_in_utils.trace('End Date : ',to_char(rec.end_date,'DD-MON-YYYY'));
1128: pay_in_utils.set_location(g_debug,l_procedure,40);
1129: pay_in_utils.trace('This Pay : ',rec.absence_value);
1130: pay_in_utils.set_location(g_debug,l_procedure,50);
1131:
1132: append_tag('AbsenceName',rec.absence_name);
1133: append_tag('StartDate',to_char(rec.start_date,'DD-MON-YYYY'));
1126: pay_in_utils.set_location(g_debug,l_procedure,30);
1127: pay_in_utils.trace('End Date : ',to_char(rec.end_date,'DD-MON-YYYY'));
1128: pay_in_utils.set_location(g_debug,l_procedure,40);
1129: pay_in_utils.trace('This Pay : ',rec.absence_value);
1130: pay_in_utils.set_location(g_debug,l_procedure,50);
1131:
1132: append_tag('AbsenceName',rec.absence_name);
1133: append_tag('StartDate',to_char(rec.start_date,'DD-MON-YYYY'));
1134: append_tag('EndDate',to_char(rec.end_date,'DD-MON-YYYY'));
1154: END IF;
1155: close_tag('Absences');
1156:
1157: --
1158: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
1159:
1160: EXCEPTION
1161: WHEN others THEN
1162: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1158: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
1159:
1160: EXCEPTION
1161: WHEN others THEN
1162: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1163: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1164: pay_in_utils.trace(l_message,l_procedure);
1165:
1166: IF csr_absences%ISOPEN THEN
1159:
1160: EXCEPTION
1161: WHEN others THEN
1162: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1163: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1164: pay_in_utils.trace(l_message,l_procedure);
1165:
1166: IF csr_absences%ISOPEN THEN
1167: CLOSE csr_absences;
1160: EXCEPTION
1161: WHEN others THEN
1162: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1163: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1164: pay_in_utils.trace(l_message,l_procedure);
1165:
1166: IF csr_absences%ISOPEN THEN
1167: CLOSE csr_absences;
1168: END IF;
1220: --
1221: BEGIN
1222:
1223: l_procedure := g_package || 'append_messages';
1224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1225:
1226: IF g_debug THEN
1227: pay_in_utils.trace('**************************************************','********************');
1228: pay_in_utils.trace('p_action_context_id',p_action_context_id);
1223: l_procedure := g_package || 'append_messages';
1224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1225:
1226: IF g_debug THEN
1227: pay_in_utils.trace('**************************************************','********************');
1228: pay_in_utils.trace('p_action_context_id',p_action_context_id);
1229: pay_in_utils.trace('**************************************************','********************');
1230: END IF;
1231:
1224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1225:
1226: IF g_debug THEN
1227: pay_in_utils.trace('**************************************************','********************');
1228: pay_in_utils.trace('p_action_context_id',p_action_context_id);
1229: pay_in_utils.trace('**************************************************','********************');
1230: END IF;
1231:
1232:
1225:
1226: IF g_debug THEN
1227: pay_in_utils.trace('**************************************************','********************');
1228: pay_in_utils.trace('p_action_context_id',p_action_context_id);
1229: pay_in_utils.trace('**************************************************','********************');
1230: END IF;
1231:
1232:
1233: open_tag('Messages');
1235: LOOP
1236: --
1237: open_tag('Mesg');
1238:
1239: pay_in_utils.trace('Mesg : ',rec.value);
1240: pay_in_utils.set_location(g_debug,l_procedure,20);
1241:
1242: append_tag('Value',rec.value);
1243:
1236: --
1237: open_tag('Mesg');
1238:
1239: pay_in_utils.trace('Mesg : ',rec.value);
1240: pay_in_utils.set_location(g_debug,l_procedure,20);
1241:
1242: append_tag('Value',rec.value);
1243:
1244: close_tag('Mesg');
1245: --
1246: END LOOP;
1247: close_tag('Messages');
1248:
1249: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN
1253: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1249: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN
1253: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1254: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1255: pay_in_utils.trace(l_message,l_procedure);
1256:
1257: IF csr_messages%ISOPEN THEN
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN
1253: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1254: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1255: pay_in_utils.trace(l_message,l_procedure);
1256:
1257: IF csr_messages%ISOPEN THEN
1258: CLOSE csr_messages;
1251: EXCEPTION
1252: WHEN OTHERS THEN
1253: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1254: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1255: pay_in_utils.trace(l_message,l_procedure);
1256:
1257: IF csr_messages%ISOPEN THEN
1258: CLOSE csr_messages;
1259: END IF;
1292: --
1293: BEGIN
1294: --
1295: l_procedure := g_package || 'append_other_balances';
1296: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1297:
1298: IF g_debug THEN
1299: pay_in_utils.trace('**************************************************','********************');
1300: pay_in_utils.trace('p_action_context_id',p_action_context_id);
1295: l_procedure := g_package || 'append_other_balances';
1296: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1297:
1298: IF g_debug THEN
1299: pay_in_utils.trace('**************************************************','********************');
1300: pay_in_utils.trace('p_action_context_id',p_action_context_id);
1301: pay_in_utils.trace('**************************************************','********************');
1302: END IF;
1303:
1296: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1297:
1298: IF g_debug THEN
1299: pay_in_utils.trace('**************************************************','********************');
1300: pay_in_utils.trace('p_action_context_id',p_action_context_id);
1301: pay_in_utils.trace('**************************************************','********************');
1302: END IF;
1303:
1304: l_rec_exists := FALSE;
1297:
1298: IF g_debug THEN
1299: pay_in_utils.trace('**************************************************','********************');
1300: pay_in_utils.trace('p_action_context_id',p_action_context_id);
1301: pay_in_utils.trace('**************************************************','********************');
1302: END IF;
1303:
1304: l_rec_exists := FALSE;
1305: open_tag('EMEABalances');
1309: --
1310: l_rec_exists := TRUE;
1311: open_tag('EMEABalance');
1312:
1313: pay_in_utils.trace('Description : ',rec.narrative);
1314: pay_in_utils.set_location(g_debug,l_procedure,20);
1315: pay_in_utils.trace('Amount : ',rec.value);
1316: pay_in_utils.set_location(g_debug,l_procedure,30);
1317:
1310: l_rec_exists := TRUE;
1311: open_tag('EMEABalance');
1312:
1313: pay_in_utils.trace('Description : ',rec.narrative);
1314: pay_in_utils.set_location(g_debug,l_procedure,20);
1315: pay_in_utils.trace('Amount : ',rec.value);
1316: pay_in_utils.set_location(g_debug,l_procedure,30);
1317:
1318:
1311: open_tag('EMEABalance');
1312:
1313: pay_in_utils.trace('Description : ',rec.narrative);
1314: pay_in_utils.set_location(g_debug,l_procedure,20);
1315: pay_in_utils.trace('Amount : ',rec.value);
1316: pay_in_utils.set_location(g_debug,l_procedure,30);
1317:
1318:
1319: append_tag('Description',rec.narrative);
1312:
1313: pay_in_utils.trace('Description : ',rec.narrative);
1314: pay_in_utils.set_location(g_debug,l_procedure,20);
1315: pay_in_utils.trace('Amount : ',rec.value);
1316: pay_in_utils.set_location(g_debug,l_procedure,30);
1317:
1318:
1319: append_tag('Description',rec.narrative);
1320: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
1336: --
1337: END IF;
1338: close_tag('EMEABalances');
1339:
1340: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1341:
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1340: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1341:
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1345: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1346: pay_in_utils.trace(l_message,l_procedure);
1347:
1348: IF csr_other_balances%ISOPEN THEN
1341:
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1345: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1346: pay_in_utils.trace(l_message,l_procedure);
1347:
1348: IF csr_other_balances%ISOPEN THEN
1349: CLOSE csr_other_balances;
1342: EXCEPTION
1343: WHEN OTHERS THEN
1344: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1345: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
1346: pay_in_utils.trace(l_message,l_procedure);
1347:
1348: IF csr_other_balances%ISOPEN THEN
1349: CLOSE csr_other_balances;
1350: END IF;
1385: --
1386: BEGIN
1387: --
1388: l_procedure := g_package ||'append_payment_details';
1389: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1390:
1391: IF g_debug THEN
1392: pay_in_utils.trace ('**************************************************','********************');
1393: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1388: l_procedure := g_package ||'append_payment_details';
1389: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1390:
1391: IF g_debug THEN
1392: pay_in_utils.trace ('**************************************************','********************');
1393: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1394: pay_in_utils.trace ('**************************************************','********************');
1395: END IF;
1396:
1389: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1390:
1391: IF g_debug THEN
1392: pay_in_utils.trace ('**************************************************','********************');
1393: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1394: pay_in_utils.trace ('**************************************************','********************');
1395: END IF;
1396:
1397: l_rec_exists := FALSE;
1390:
1391: IF g_debug THEN
1392: pay_in_utils.trace ('**************************************************','********************');
1393: pay_in_utils.trace ('p_action_context_id',p_action_context_id);
1394: pay_in_utils.trace ('**************************************************','********************');
1395: END IF;
1396:
1397: l_rec_exists := FALSE;
1398: open_tag('PaymentDetails');
1402: --
1403: l_rec_exists := TRUE;
1404: open_tag('Payment');
1405:
1406: pay_in_utils.trace('Payment Method : ',rec.payment_method);
1407: pay_in_utils.set_location(g_debug,l_procedure,20);
1408: pay_in_utils.trace('Bank Name : ',rec.bank_name);
1409: pay_in_utils.set_location(g_debug,l_procedure,30);
1410: pay_in_utils.trace('Account Number : ',rec.account_number);
1403: l_rec_exists := TRUE;
1404: open_tag('Payment');
1405:
1406: pay_in_utils.trace('Payment Method : ',rec.payment_method);
1407: pay_in_utils.set_location(g_debug,l_procedure,20);
1408: pay_in_utils.trace('Bank Name : ',rec.bank_name);
1409: pay_in_utils.set_location(g_debug,l_procedure,30);
1410: pay_in_utils.trace('Account Number : ',rec.account_number);
1411: pay_in_utils.set_location(g_debug,l_procedure,40);
1404: open_tag('Payment');
1405:
1406: pay_in_utils.trace('Payment Method : ',rec.payment_method);
1407: pay_in_utils.set_location(g_debug,l_procedure,20);
1408: pay_in_utils.trace('Bank Name : ',rec.bank_name);
1409: pay_in_utils.set_location(g_debug,l_procedure,30);
1410: pay_in_utils.trace('Account Number : ',rec.account_number);
1411: pay_in_utils.set_location(g_debug,l_procedure,40);
1412: pay_in_utils.trace('This Pay : ',rec.value);
1405:
1406: pay_in_utils.trace('Payment Method : ',rec.payment_method);
1407: pay_in_utils.set_location(g_debug,l_procedure,20);
1408: pay_in_utils.trace('Bank Name : ',rec.bank_name);
1409: pay_in_utils.set_location(g_debug,l_procedure,30);
1410: pay_in_utils.trace('Account Number : ',rec.account_number);
1411: pay_in_utils.set_location(g_debug,l_procedure,40);
1412: pay_in_utils.trace('This Pay : ',rec.value);
1413: pay_in_utils.set_location(g_debug,l_procedure,50);
1406: pay_in_utils.trace('Payment Method : ',rec.payment_method);
1407: pay_in_utils.set_location(g_debug,l_procedure,20);
1408: pay_in_utils.trace('Bank Name : ',rec.bank_name);
1409: pay_in_utils.set_location(g_debug,l_procedure,30);
1410: pay_in_utils.trace('Account Number : ',rec.account_number);
1411: pay_in_utils.set_location(g_debug,l_procedure,40);
1412: pay_in_utils.trace('This Pay : ',rec.value);
1413: pay_in_utils.set_location(g_debug,l_procedure,50);
1414:
1407: pay_in_utils.set_location(g_debug,l_procedure,20);
1408: pay_in_utils.trace('Bank Name : ',rec.bank_name);
1409: pay_in_utils.set_location(g_debug,l_procedure,30);
1410: pay_in_utils.trace('Account Number : ',rec.account_number);
1411: pay_in_utils.set_location(g_debug,l_procedure,40);
1412: pay_in_utils.trace('This Pay : ',rec.value);
1413: pay_in_utils.set_location(g_debug,l_procedure,50);
1414:
1415: append_tag('PaymentType',rec.payment_method);
1408: pay_in_utils.trace('Bank Name : ',rec.bank_name);
1409: pay_in_utils.set_location(g_debug,l_procedure,30);
1410: pay_in_utils.trace('Account Number : ',rec.account_number);
1411: pay_in_utils.set_location(g_debug,l_procedure,40);
1412: pay_in_utils.trace('This Pay : ',rec.value);
1413: pay_in_utils.set_location(g_debug,l_procedure,50);
1414:
1415: append_tag('PaymentType',rec.payment_method);
1416: append_tag('Bank',rec.bank_name);
1409: pay_in_utils.set_location(g_debug,l_procedure,30);
1410: pay_in_utils.trace('Account Number : ',rec.account_number);
1411: pay_in_utils.set_location(g_debug,l_procedure,40);
1412: pay_in_utils.trace('This Pay : ',rec.value);
1413: pay_in_utils.set_location(g_debug,l_procedure,50);
1414:
1415: append_tag('PaymentType',rec.payment_method);
1416: append_tag('Bank',rec.bank_name);
1417: append_tag('AccountNumber',rec.account_number);
1436: --
1437: END IF;
1438: close_tag('PaymentDetails');
1439:
1440: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
1441:
1442: EXCEPTION
1443: WHEN others THEN
1444: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1440: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
1441:
1442: EXCEPTION
1443: WHEN others THEN
1444: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1445: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1446: pay_in_utils.trace(l_message,l_procedure);
1447:
1448: IF csr_payment_details%ISOPEN THEN
1441:
1442: EXCEPTION
1443: WHEN others THEN
1444: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1445: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1446: pay_in_utils.trace(l_message,l_procedure);
1447:
1448: IF csr_payment_details%ISOPEN THEN
1449: CLOSE csr_payment_details;
1442: EXCEPTION
1443: WHEN others THEN
1444: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1445: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,70);
1446: pay_in_utils.trace(l_message,l_procedure);
1447:
1448: IF csr_payment_details%ISOPEN THEN
1449: CLOSE csr_payment_details;
1450: END IF;
1476: BEGIN
1477: --
1478:
1479: l_procedure := g_package||'fetch_xml';
1480: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1481:
1482:
1483:
1484: -- If Clobs exists return next clob else exit NULL
1491: --
1492: p_clob := null;
1493: --
1494: END IF;
1495: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1496:
1497: END fetch_xml;
1498:
1499: --------------------------------------------------------------------------
1573: BEGIN
1574: --
1575:
1576: l_procedure := g_package ||'get_template';
1577: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1578:
1579: IF g_debug THEN
1580: pay_in_utils.trace('**************************************************','********************');
1581: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1576: l_procedure := g_package ||'get_template';
1577: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1578:
1579: IF g_debug THEN
1580: pay_in_utils.trace('**************************************************','********************');
1581: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1582: pay_in_utils.trace('p_start_date : ', p_start_date);
1583: pay_in_utils.trace('p_end_date : ', p_end_date);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1577: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1578:
1579: IF g_debug THEN
1580: pay_in_utils.trace('**************************************************','********************');
1581: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1582: pay_in_utils.trace('p_start_date : ', p_start_date);
1583: pay_in_utils.trace('p_end_date : ', p_end_date);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1578:
1579: IF g_debug THEN
1580: pay_in_utils.trace('**************************************************','********************');
1581: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1582: pay_in_utils.trace('p_start_date : ', p_start_date);
1583: pay_in_utils.trace('p_end_date : ', p_end_date);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1579: IF g_debug THEN
1580: pay_in_utils.trace('**************************************************','********************');
1581: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1582: pay_in_utils.trace('p_start_date : ', p_start_date);
1583: pay_in_utils.trace('p_end_date : ', p_end_date);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1580: pay_in_utils.trace('**************************************************','********************');
1581: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1582: pay_in_utils.trace('p_start_date : ', p_start_date);
1583: pay_in_utils.trace('p_end_date : ', p_end_date);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1581: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1582: pay_in_utils.trace('p_start_date : ', p_start_date);
1583: pay_in_utils.trace('p_end_date : ', p_end_date);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1589: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1582: pay_in_utils.trace('p_start_date : ', p_start_date);
1583: pay_in_utils.trace('p_end_date : ', p_end_date);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1589: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1590: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1583: pay_in_utils.trace('p_end_date : ', p_end_date);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1589: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1590: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1591: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1584: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1589: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1590: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1591: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1592: pay_in_utils.trace('**************************************************','********************');
1585: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1589: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1590: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1591: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1592: pay_in_utils.trace('**************************************************','********************');
1593: END IF;
1586: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1589: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1590: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1591: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1592: pay_in_utils.trace('**************************************************','********************');
1593: END IF;
1594:
1587: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1589: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1590: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1591: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1592: pay_in_utils.trace('**************************************************','********************');
1593: END IF;
1594:
1595:
1588: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1589: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1590: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1591: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1592: pay_in_utils.trace('**************************************************','********************');
1593: END IF;
1594:
1595:
1596: l_start_date := fnd_date.canonical_to_date(p_start_date);
1677: -- Append sort order to SQL statement
1678: --
1679: l_stmt := l_stmt || l_sort_by;
1680:
1681: pay_in_utils.trace('Before Open Cursor',20);
1682: l_sql_csr := dbms_sql.open_cursor;
1683:
1684: pay_in_utils.set_location(g_debug,'Before parse',30);
1685: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1680:
1681: pay_in_utils.trace('Before Open Cursor',20);
1682: l_sql_csr := dbms_sql.open_cursor;
1683:
1684: pay_in_utils.set_location(g_debug,'Before parse',30);
1685: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
1686: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
1687: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
1688: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
1702: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
1703: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
1704: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
1705:
1706: pay_in_utils.set_location(g_debug,'Before Bind',40);
1707: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
1708: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
1709: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
1710: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
1712: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
1713: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
1714:
1715:
1716: pay_in_utils.set_location(g_debug,'Before execute',50);
1717: l_dummy := dbms_sql.execute(l_sql_csr);
1718:
1719: LOOP
1720: --
1745: dbms_sql.column_value(l_sql_csr,17,l_grade);
1746: dbms_sql.column_value(l_sql_csr,18,l_pan);
1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
1748:
1749: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1750: pay_in_utils.set_location(g_debug,l_procedure,20);
1751: pay_in_utils.trace('l_employee_number : ', l_employee_number);
1752: pay_in_utils.set_location(g_debug,l_procedure,20);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1746: dbms_sql.column_value(l_sql_csr,18,l_pan);
1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
1748:
1749: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1750: pay_in_utils.set_location(g_debug,l_procedure,20);
1751: pay_in_utils.trace('l_employee_number : ', l_employee_number);
1752: pay_in_utils.set_location(g_debug,l_procedure,20);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1747: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
1748:
1749: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1750: pay_in_utils.set_location(g_debug,l_procedure,20);
1751: pay_in_utils.trace('l_employee_number : ', l_employee_number);
1752: pay_in_utils.set_location(g_debug,l_procedure,20);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1748:
1749: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1750: pay_in_utils.set_location(g_debug,l_procedure,20);
1751: pay_in_utils.trace('l_employee_number : ', l_employee_number);
1752: pay_in_utils.set_location(g_debug,l_procedure,20);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1749: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
1750: pay_in_utils.set_location(g_debug,l_procedure,20);
1751: pay_in_utils.trace('l_employee_number : ', l_employee_number);
1752: pay_in_utils.set_location(g_debug,l_procedure,20);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1750: pay_in_utils.set_location(g_debug,l_procedure,20);
1751: pay_in_utils.trace('l_employee_number : ', l_employee_number);
1752: pay_in_utils.set_location(g_debug,l_procedure,20);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1751: pay_in_utils.trace('l_employee_number : ', l_employee_number);
1752: pay_in_utils.set_location(g_debug,l_procedure,20);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1752: pay_in_utils.set_location(g_debug,l_procedure,20);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1753: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1754: pay_in_utils.set_location(g_debug,l_procedure,30);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1755: pay_in_utils.trace('l_dob : ', l_dob);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1756: pay_in_utils.set_location(g_debug,l_procedure,40);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1757: pay_in_utils.trace('l_joining_date : ', l_joining_date);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1758: pay_in_utils.set_location(g_debug,l_procedure,50);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1759: pay_in_utils.trace('l_ptn : ', l_ptn);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1767: pay_in_utils.trace('l_job : ', l_job);
1760: pay_in_utils.set_location(g_debug,l_procedure,60);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1767: pay_in_utils.trace('l_job : ', l_job);
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1761: pay_in_utils.trace('l_pf_number : ', l_pf_number);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1767: pay_in_utils.trace('l_job : ', l_job);
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1769: pay_in_utils.trace('l_position : ', l_position);
1762: pay_in_utils.set_location(g_debug,l_procedure,70);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1767: pay_in_utils.trace('l_job : ', l_job);
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1769: pay_in_utils.trace('l_position : ', l_position);
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1763: pay_in_utils.trace('l_esi_number : ', l_esi_number);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1767: pay_in_utils.trace('l_job : ', l_job);
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1769: pay_in_utils.trace('l_position : ', l_position);
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1771: pay_in_utils.trace('l_grade : ', l_grade);
1764: pay_in_utils.set_location(g_debug,l_procedure,80);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1767: pay_in_utils.trace('l_job : ', l_job);
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1769: pay_in_utils.trace('l_position : ', l_position);
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1771: pay_in_utils.trace('l_grade : ', l_grade);
1772: pay_in_utils.set_location(g_debug,l_procedure,120);
1765: pay_in_utils.trace('l_pay_month : ', l_pay_month);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1767: pay_in_utils.trace('l_job : ', l_job);
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1769: pay_in_utils.trace('l_position : ', l_position);
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1771: pay_in_utils.trace('l_grade : ', l_grade);
1772: pay_in_utils.set_location(g_debug,l_procedure,120);
1773: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
1766: pay_in_utils.set_location(g_debug,l_procedure,90);
1767: pay_in_utils.trace('l_job : ', l_job);
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1769: pay_in_utils.trace('l_position : ', l_position);
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1771: pay_in_utils.trace('l_grade : ', l_grade);
1772: pay_in_utils.set_location(g_debug,l_procedure,120);
1773: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
1774: pay_in_utils.set_location(g_debug,l_procedure,130);
1767: pay_in_utils.trace('l_job : ', l_job);
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1769: pay_in_utils.trace('l_position : ', l_position);
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1771: pay_in_utils.trace('l_grade : ', l_grade);
1772: pay_in_utils.set_location(g_debug,l_procedure,120);
1773: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
1774: pay_in_utils.set_location(g_debug,l_procedure,130);
1775:
1768: pay_in_utils.set_location(g_debug,l_procedure,100);
1769: pay_in_utils.trace('l_position : ', l_position);
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1771: pay_in_utils.trace('l_grade : ', l_grade);
1772: pay_in_utils.set_location(g_debug,l_procedure,120);
1773: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
1774: pay_in_utils.set_location(g_debug,l_procedure,130);
1775:
1776: IF ( l_emp_cnt = 0) OR ( l_emp_cnt >=g_chunk_size ) THEN
1769: pay_in_utils.trace('l_position : ', l_position);
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1771: pay_in_utils.trace('l_grade : ', l_grade);
1772: pay_in_utils.set_location(g_debug,l_procedure,120);
1773: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
1774: pay_in_utils.set_location(g_debug,l_procedure,130);
1775:
1776: IF ( l_emp_cnt = 0) OR ( l_emp_cnt >=g_chunk_size ) THEN
1777: --
1770: pay_in_utils.set_location(g_debug,l_procedure,110);
1771: pay_in_utils.trace('l_grade : ', l_grade);
1772: pay_in_utils.set_location(g_debug,l_procedure,120);
1773: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
1774: pay_in_utils.set_location(g_debug,l_procedure,130);
1775:
1776: IF ( l_emp_cnt = 0) OR ( l_emp_cnt >=g_chunk_size ) THEN
1777: --
1778: pay_in_utils.set_location(g_debug,'Inside If emp_cnt = 0 or emp_cnt > chunk_size',70);
1774: pay_in_utils.set_location(g_debug,l_procedure,130);
1775:
1776: IF ( l_emp_cnt = 0) OR ( l_emp_cnt >=g_chunk_size ) THEN
1777: --
1778: pay_in_utils.set_location(g_debug,'Inside If emp_cnt = 0 or emp_cnt > chunk_size',70);
1779:
1780: -- If not the first employee close the previous clob
1781: -- Put the clob in the global CLOB array
1782: --
1792: -- Increment global clob count
1793: --
1794: g_clob_cnt := g_clob_cnt + 1;
1795:
1796: pay_in_utils.trace('g_clob_cnt : ', g_clob_cnt);
1797: pay_in_utils.set_location(g_debug,l_procedure,140);
1798:
1799: -- Open a new CLOB
1800: --
1793: --
1794: g_clob_cnt := g_clob_cnt + 1;
1795:
1796: pay_in_utils.trace('g_clob_cnt : ', g_clob_cnt);
1797: pay_in_utils.set_location(g_debug,l_procedure,140);
1798:
1799: -- Open a new CLOB
1800: --
1801: pay_in_utils.set_location(g_debug,'Before Create Temporary',150);
1797: pay_in_utils.set_location(g_debug,l_procedure,140);
1798:
1799: -- Open a new CLOB
1800: --
1801: pay_in_utils.set_location(g_debug,'Before Create Temporary',150);
1802: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
1803:
1804: pay_in_utils.set_location(g_debug,'Before Open',160);
1805: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
1800: --
1801: pay_in_utils.set_location(g_debug,'Before Create Temporary',150);
1802: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
1803:
1804: pay_in_utils.set_location(g_debug,'Before Open',160);
1805: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
1806:
1807: -- Append Open tags to new CLOB
1808: --
1809: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1810: --
1811: END IF;
1812:
1813: pay_in_utils.set_location(g_debug,'Before employee tag',170);
1814:
1815: -- Open Employee tag
1816: -- Append Details
1817: --
1856: -- Close employee tag
1857: --
1858: close_tag('Employee');
1859: l_emp_cnt := l_emp_cnt + 1;
1860: pay_in_utils.set_location(g_debug,'After employee tag',180);
1861: --
1862: END LOOP;
1863:
1864: pay_in_utils.set_location(g_debug,'Close cursor',190);
1860: pay_in_utils.set_location(g_debug,'After employee tag',180);
1861: --
1862: END LOOP;
1863:
1864: pay_in_utils.set_location(g_debug,'Close cursor',190);
1865: dbms_sql.close_cursor(l_sql_csr);
1866:
1867: -- Last CLOB is not yet closed
1868: -- So close it.
1867: -- Last CLOB is not yet closed
1868: -- So close it.
1869: IF ( g_clob_cnt <> 0) THEN
1870: --
1871: pay_in_utils.set_location(g_debug,'Closing last clob',200);
1872: close_tag('clob');
1873: dbms_lob.close(g_tmp_clob);
1874: g_clob(g_clob_cnt):=g_tmp_clob;
1875: --
1877: END IF;
1878: p_clob_cnt := g_clob_cnt;
1879:
1880: IF g_debug THEN
1881: pay_in_utils.trace('**************************************************','********************');
1882: pay_in_utils.trace('p_clob_cnt : ',p_clob_cnt);
1883: pay_in_utils.trace('**************************************************','********************');
1884: END IF;
1885:
1878: p_clob_cnt := g_clob_cnt;
1879:
1880: IF g_debug THEN
1881: pay_in_utils.trace('**************************************************','********************');
1882: pay_in_utils.trace('p_clob_cnt : ',p_clob_cnt);
1883: pay_in_utils.trace('**************************************************','********************');
1884: END IF;
1885:
1886:
1879:
1880: IF g_debug THEN
1881: pay_in_utils.trace('**************************************************','********************');
1882: pay_in_utils.trace('p_clob_cnt : ',p_clob_cnt);
1883: pay_in_utils.trace('**************************************************','********************');
1884: END IF;
1885:
1886:
1887: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,220);
1883: pay_in_utils.trace('**************************************************','********************');
1884: END IF;
1885:
1886:
1887: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,220);
1888:
1889: EXCEPTION
1890: WHEN others THEN
1891: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1887: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,220);
1888:
1889: EXCEPTION
1890: WHEN others THEN
1891: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1892: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
1893: pay_in_utils.trace(l_message,l_procedure);
1894:
1895: IF dbms_sql.is_open(l_sql_csr) THEN
1888:
1889: EXCEPTION
1890: WHEN others THEN
1891: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1892: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
1893: pay_in_utils.trace(l_message,l_procedure);
1894:
1895: IF dbms_sql.is_open(l_sql_csr) THEN
1896: dbms_sql.close_cursor(l_sql_csr);
1889: EXCEPTION
1890: WHEN others THEN
1891: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1892: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
1893: pay_in_utils.trace(l_message,l_procedure);
1894:
1895: IF dbms_sql.is_open(l_sql_csr) THEN
1896: dbms_sql.close_cursor(l_sql_csr);
1897: END IF;
1975: BEGIN
1976: --
1977:
1978: l_procedure := g_package ||'load_xml_burst';
1979: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1980:
1981: IF g_debug THEN
1982: pay_in_utils.trace('**************************************************','********************');
1983: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1978: l_procedure := g_package ||'load_xml_burst';
1979: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1980:
1981: IF g_debug THEN
1982: pay_in_utils.trace('**************************************************','********************');
1983: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1984: pay_in_utils.trace('p_start_date : ', p_start_date);
1985: pay_in_utils.trace('p_end_date : ', p_end_date);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1979: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1980:
1981: IF g_debug THEN
1982: pay_in_utils.trace('**************************************************','********************');
1983: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1984: pay_in_utils.trace('p_start_date : ', p_start_date);
1985: pay_in_utils.trace('p_end_date : ', p_end_date);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1980:
1981: IF g_debug THEN
1982: pay_in_utils.trace('**************************************************','********************');
1983: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1984: pay_in_utils.trace('p_start_date : ', p_start_date);
1985: pay_in_utils.trace('p_end_date : ', p_end_date);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1981: IF g_debug THEN
1982: pay_in_utils.trace('**************************************************','********************');
1983: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1984: pay_in_utils.trace('p_start_date : ', p_start_date);
1985: pay_in_utils.trace('p_end_date : ', p_end_date);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1982: pay_in_utils.trace('**************************************************','********************');
1983: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1984: pay_in_utils.trace('p_start_date : ', p_start_date);
1985: pay_in_utils.trace('p_end_date : ', p_end_date);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1983: pay_in_utils.trace('p_business_group_id : ', p_business_group_id);
1984: pay_in_utils.trace('p_start_date : ', p_start_date);
1985: pay_in_utils.trace('p_end_date : ', p_end_date);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1991: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1984: pay_in_utils.trace('p_start_date : ', p_start_date);
1985: pay_in_utils.trace('p_end_date : ', p_end_date);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1991: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1992: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1985: pay_in_utils.trace('p_end_date : ', p_end_date);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1991: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1992: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1993: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1986: pay_in_utils.trace('p_payroll_id : ', p_payroll_id);
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1991: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1992: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1993: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1994: pay_in_utils.trace('**************************************************','********************');
1987: pay_in_utils.trace('p_consolidation_set_id : ', p_consolidation_set_id);
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1991: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1992: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1993: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1994: pay_in_utils.trace('**************************************************','********************');
1995: END IF;
1988: pay_in_utils.trace('p_assignment_set_id : ', p_assignment_set_id);
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1991: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1992: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1993: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1994: pay_in_utils.trace('**************************************************','********************');
1995: END IF;
1996:
1989: pay_in_utils.trace('p_employee_number : ', p_employee_number);
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1991: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1992: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1993: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1994: pay_in_utils.trace('**************************************************','********************');
1995: END IF;
1996:
1997:
1990: pay_in_utils.trace('p_sort_order1 : ', p_sort_order1);
1991: pay_in_utils.trace('p_sort_order2 : ', p_sort_order2);
1992: pay_in_utils.trace('p_sort_order3 : ', p_sort_order3);
1993: pay_in_utils.trace('p_sort_order4 : ', p_sort_order4);
1994: pay_in_utils.trace('**************************************************','********************');
1995: END IF;
1996:
1997:
1998: l_start_date := fnd_date.canonical_to_date(p_start_date);
2082: -- Append sort order to SQL statement
2083: --
2084: l_stmt := l_stmt || l_sort_by;
2085:
2086: pay_in_utils.trace('Before Open Cursor',20);
2087: l_sql_csr := dbms_sql.open_cursor;
2088:
2089: pay_in_utils.set_location(g_debug,'Before parse',30);
2090: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
2085:
2086: pay_in_utils.trace('Before Open Cursor',20);
2087: l_sql_csr := dbms_sql.open_cursor;
2088:
2089: pay_in_utils.set_location(g_debug,'Before parse',30);
2090: dbms_sql.parse(l_sql_csr,l_stmt,dbms_sql.native);
2091: dbms_sql.define_column(l_sql_csr,1,l_action_context_id);
2092: dbms_sql.define_column(l_sql_csr,2,l_employee_number,240);
2093: dbms_sql.define_column(l_sql_csr,3,l_assignment_number,240);
2107: dbms_sql.define_column(l_sql_csr,17,l_grade,240);
2108: dbms_sql.define_column(l_sql_csr,18,l_pan,240);
2109: dbms_sql.define_column(l_sql_csr,19,l_superannuation,240);
2110:
2111: pay_in_utils.set_location(g_debug,'Before Bind',40);
2112: dbms_sql.bind_variable(l_sql_csr,':bg_id',p_business_group_id);
2113: dbms_sql.bind_variable(l_sql_csr,':start_date',l_start_date);
2114: dbms_sql.bind_variable(l_sql_csr,':end_date',l_end_date);
2115: dbms_sql.bind_variable(l_sql_csr,':payroll_id',p_payroll_id);
2117: dbms_sql.bind_variable(l_sql_csr,':assg_set_id',p_assignment_set_id);
2118: dbms_sql.bind_variable(l_sql_csr,':person_id',p_employee_number);
2119:
2120:
2121: pay_in_utils.set_location(g_debug,'Before execute',50);
2122: l_dummy := dbms_sql.execute(l_sql_csr);
2123:
2124: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2125: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2155: dbms_sql.column_value(l_sql_csr,17,l_grade);
2156: dbms_sql.column_value(l_sql_csr,18,l_pan);
2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
2158:
2159: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
2160: pay_in_utils.set_location(g_debug,l_procedure,20);
2161: pay_in_utils.trace('l_employee_number : ', l_employee_number);
2162: pay_in_utils.set_location(g_debug,l_procedure,20);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2156: dbms_sql.column_value(l_sql_csr,18,l_pan);
2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
2158:
2159: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
2160: pay_in_utils.set_location(g_debug,l_procedure,20);
2161: pay_in_utils.trace('l_employee_number : ', l_employee_number);
2162: pay_in_utils.set_location(g_debug,l_procedure,20);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2157: dbms_sql.column_value(l_sql_csr,19,l_superannuation);
2158:
2159: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
2160: pay_in_utils.set_location(g_debug,l_procedure,20);
2161: pay_in_utils.trace('l_employee_number : ', l_employee_number);
2162: pay_in_utils.set_location(g_debug,l_procedure,20);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2158:
2159: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
2160: pay_in_utils.set_location(g_debug,l_procedure,20);
2161: pay_in_utils.trace('l_employee_number : ', l_employee_number);
2162: pay_in_utils.set_location(g_debug,l_procedure,20);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2159: pay_in_utils.trace('l_action_context_id : ', l_action_context_id);
2160: pay_in_utils.set_location(g_debug,l_procedure,20);
2161: pay_in_utils.trace('l_employee_number : ', l_employee_number);
2162: pay_in_utils.set_location(g_debug,l_procedure,20);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2160: pay_in_utils.set_location(g_debug,l_procedure,20);
2161: pay_in_utils.trace('l_employee_number : ', l_employee_number);
2162: pay_in_utils.set_location(g_debug,l_procedure,20);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2161: pay_in_utils.trace('l_employee_number : ', l_employee_number);
2162: pay_in_utils.set_location(g_debug,l_procedure,20);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2162: pay_in_utils.set_location(g_debug,l_procedure,20);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2163: pay_in_utils.trace('l_assignment_number : ', l_assignment_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2164: pay_in_utils.set_location(g_debug,l_procedure,30);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2165: pay_in_utils.trace('l_dob : ', l_dob);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2166: pay_in_utils.set_location(g_debug,l_procedure,40);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2167: pay_in_utils.trace('l_joining_date : ', l_joining_date);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2168: pay_in_utils.set_location(g_debug,l_procedure,50);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2169: pay_in_utils.trace('l_ptn : ', l_ptn);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2177: pay_in_utils.trace('l_job : ', l_job);
2170: pay_in_utils.set_location(g_debug,l_procedure,60);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2177: pay_in_utils.trace('l_job : ', l_job);
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2171: pay_in_utils.trace('l_pf_number : ', l_pf_number);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2177: pay_in_utils.trace('l_job : ', l_job);
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2179: pay_in_utils.trace('l_position : ', l_position);
2172: pay_in_utils.set_location(g_debug,l_procedure,70);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2177: pay_in_utils.trace('l_job : ', l_job);
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2179: pay_in_utils.trace('l_position : ', l_position);
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2173: pay_in_utils.trace('l_esi_number : ', l_esi_number);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2177: pay_in_utils.trace('l_job : ', l_job);
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2179: pay_in_utils.trace('l_position : ', l_position);
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2181: pay_in_utils.trace('l_grade : ', l_grade);
2174: pay_in_utils.set_location(g_debug,l_procedure,80);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2177: pay_in_utils.trace('l_job : ', l_job);
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2179: pay_in_utils.trace('l_position : ', l_position);
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2181: pay_in_utils.trace('l_grade : ', l_grade);
2182: pay_in_utils.set_location(g_debug,l_procedure,120);
2175: pay_in_utils.trace('l_pay_month : ', l_pay_month);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2177: pay_in_utils.trace('l_job : ', l_job);
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2179: pay_in_utils.trace('l_position : ', l_position);
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2181: pay_in_utils.trace('l_grade : ', l_grade);
2182: pay_in_utils.set_location(g_debug,l_procedure,120);
2183: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
2176: pay_in_utils.set_location(g_debug,l_procedure,90);
2177: pay_in_utils.trace('l_job : ', l_job);
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2179: pay_in_utils.trace('l_position : ', l_position);
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2181: pay_in_utils.trace('l_grade : ', l_grade);
2182: pay_in_utils.set_location(g_debug,l_procedure,120);
2183: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
2184: pay_in_utils.set_location(g_debug,l_procedure,130);
2177: pay_in_utils.trace('l_job : ', l_job);
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2179: pay_in_utils.trace('l_position : ', l_position);
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2181: pay_in_utils.trace('l_grade : ', l_grade);
2182: pay_in_utils.set_location(g_debug,l_procedure,120);
2183: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
2184: pay_in_utils.set_location(g_debug,l_procedure,130);
2185:
2178: pay_in_utils.set_location(g_debug,l_procedure,100);
2179: pay_in_utils.trace('l_position : ', l_position);
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2181: pay_in_utils.trace('l_grade : ', l_grade);
2182: pay_in_utils.set_location(g_debug,l_procedure,120);
2183: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
2184: pay_in_utils.set_location(g_debug,l_procedure,130);
2185:
2186: pay_in_utils.set_location(g_debug,'Before employee tag',170);
2179: pay_in_utils.trace('l_position : ', l_position);
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2181: pay_in_utils.trace('l_grade : ', l_grade);
2182: pay_in_utils.set_location(g_debug,l_procedure,120);
2183: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
2184: pay_in_utils.set_location(g_debug,l_procedure,130);
2185:
2186: pay_in_utils.set_location(g_debug,'Before employee tag',170);
2187:
2180: pay_in_utils.set_location(g_debug,l_procedure,110);
2181: pay_in_utils.trace('l_grade : ', l_grade);
2182: pay_in_utils.set_location(g_debug,l_procedure,120);
2183: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
2184: pay_in_utils.set_location(g_debug,l_procedure,130);
2185:
2186: pay_in_utils.set_location(g_debug,'Before employee tag',170);
2187:
2188:
2182: pay_in_utils.set_location(g_debug,l_procedure,120);
2183: pay_in_utils.trace('l_emp_cnt : ', l_emp_cnt);
2184: pay_in_utils.set_location(g_debug,l_procedure,130);
2185:
2186: pay_in_utils.set_location(g_debug,'Before employee tag',170);
2187:
2188:
2189: -- Open Employee tag
2190: -- Append Details
2232: --
2233: close_tag('Employee');
2234:
2235: /* l_emp_cnt := l_emp_cnt + 1;*/
2236: pay_in_utils.set_location(g_debug,'After employee tag',180);
2237: --
2238: END LOOP;
2239: close_tag('IN_SOE');
2240: pay_in_utils.set_location(g_debug,'Close cursor',190);
2236: pay_in_utils.set_location(g_debug,'After employee tag',180);
2237: --
2238: END LOOP;
2239: close_tag('IN_SOE');
2240: pay_in_utils.set_location(g_debug,'Close cursor',190);
2241: dbms_sql.close_cursor(l_sql_csr);
2242:
2243:
2244:
2243:
2244:
2245: dbms_lob.close(g_tmp_clob);
2246: p_xml := g_tmp_clob;
2247: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,220);
2248:
2249: EXCEPTION
2250: WHEN others THEN
2251: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2247: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,220);
2248:
2249: EXCEPTION
2250: WHEN others THEN
2251: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
2253: pay_in_utils.trace(l_message,l_procedure);
2254:
2255: IF dbms_sql.is_open(l_sql_csr) THEN
2248:
2249: EXCEPTION
2250: WHEN others THEN
2251: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
2253: pay_in_utils.trace(l_message,l_procedure);
2254:
2255: IF dbms_sql.is_open(l_sql_csr) THEN
2256: dbms_sql.close_cursor(l_sql_csr);
2249: EXCEPTION
2250: WHEN others THEN
2251: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2252: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,230);
2253: pay_in_utils.trace(l_message,l_procedure);
2254:
2255: IF dbms_sql.is_open(l_sql_csr) THEN
2256: dbms_sql.close_cursor(l_sql_csr);
2257: END IF;