eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_EOY_REPORTS dependencies on PAY_IN_UTILS

Line 104: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

100:
101: BEGIN
102: g_debug := hr_utility.debug_enabled;
103: l_procedure := g_package||'init_form12ba_code';
104: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
105:
106: g_perq_record(1).perq_value1 := 0;
107: g_perq_record(1).perq_value2 := 0;
108:

Line 163: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

159:
160: g_perq_record(19).perq_value1 := 0;
161: g_perq_record(19).perq_value2 := 0;
162:
163: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
164:
165: END init_form12ba_code;
166:
167: --------------------------------------------------------------------------

Line 200: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

196: --
197: BEGIN
198: g_debug := hr_utility.debug_enabled;
199: l_procedure := g_package ||'get_max_context_id';
200: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
201:
202:
203: IF g_debug THEN
204: pay_in_utils.trace('**************************************************','********************');

Line 204: pay_in_utils.trace('******************************','');

200: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
201:
202:
203: IF g_debug THEN
204: pay_in_utils.trace('**************************************************','********************');
205: pay_in_utils.trace('p_gre_id',to_char(p_gre_id));
206: pay_in_utils.trace('p_assessment_year',to_char(p_assessment_year));
207: pay_in_utils.trace('**************************************************','********************');
208: END IF;

Line 205: pay_in_utils.trace('p_gre_id',to_char(p_gre_id));

201:
202:
203: IF g_debug THEN
204: pay_in_utils.trace('**************************************************','********************');
205: pay_in_utils.trace('p_gre_id',to_char(p_gre_id));
206: pay_in_utils.trace('p_assessment_year',to_char(p_assessment_year));
207: pay_in_utils.trace('**************************************************','********************');
208: END IF;
209:

Line 206: pay_in_utils.trace('p_assessment_year',to_char(p_assessment_year));

202:
203: IF g_debug THEN
204: pay_in_utils.trace('**************************************************','********************');
205: pay_in_utils.trace('p_gre_id',to_char(p_gre_id));
206: pay_in_utils.trace('p_assessment_year',to_char(p_assessment_year));
207: pay_in_utils.trace('**************************************************','********************');
208: END IF;
209:
210: OPEN csr_max_action_context_id;

Line 207: pay_in_utils.trace('******************************','');

203: IF g_debug THEN
204: pay_in_utils.trace('**************************************************','********************');
205: pay_in_utils.trace('p_gre_id',to_char(p_gre_id));
206: pay_in_utils.trace('p_assessment_year',to_char(p_assessment_year));
207: pay_in_utils.trace('**************************************************','********************');
208: END IF;
209:
210: OPEN csr_max_action_context_id;
211: FETCH csr_max_action_context_id INTO l_action_context_id;

Line 215: pay_in_utils.trace('l_action_context_id',l_action_context_id);

211: FETCH csr_max_action_context_id INTO l_action_context_id;
212: CLOSE csr_max_action_context_id;
213:
214: IF g_debug THEN
215: pay_in_utils.trace('l_action_context_id',l_action_context_id);
216: END IF;
217: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
218: RETURN l_action_context_id;
219:

Line 217: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

213:
214: IF g_debug THEN
215: pay_in_utils.trace('l_action_context_id',l_action_context_id);
216: END IF;
217: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
218: RETURN l_action_context_id;
219:
220: END get_max_context_id;
221:

Line 270: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

266:
267: BEGIN
268: g_debug := hr_utility.debug_enabled;
269: l_procedure := g_package ||'get_location_details';
270: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
271:
272:
273: IF g_debug THEN
274: pay_in_utils.trace('**************************************************','********************');

Line 274: pay_in_utils.trace('******************************','');

270: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
271:
272:
273: IF g_debug THEN
274: pay_in_utils.trace('**************************************************','********************');
275: pay_in_utils.trace('p_location_id',to_char(p_location_id));
276: pay_in_utils.trace('p_concatenate',p_concatenate);
277: pay_in_utils.trace('p_field', p_field);
278: pay_in_utils.trace('**************************************************','********************');

Line 275: pay_in_utils.trace('p_location_id',to_char(p_location_id));

271:
272:
273: IF g_debug THEN
274: pay_in_utils.trace('**************************************************','********************');
275: pay_in_utils.trace('p_location_id',to_char(p_location_id));
276: pay_in_utils.trace('p_concatenate',p_concatenate);
277: pay_in_utils.trace('p_field', p_field);
278: pay_in_utils.trace('**************************************************','********************');
279: END IF;

Line 276: pay_in_utils.trace('p_concatenate',p_concatenate);

272:
273: IF g_debug THEN
274: pay_in_utils.trace('**************************************************','********************');
275: pay_in_utils.trace('p_location_id',to_char(p_location_id));
276: pay_in_utils.trace('p_concatenate',p_concatenate);
277: pay_in_utils.trace('p_field', p_field);
278: pay_in_utils.trace('**************************************************','********************');
279: END IF;
280:

Line 277: pay_in_utils.trace('p_field', p_field);

273: IF g_debug THEN
274: pay_in_utils.trace('**************************************************','********************');
275: pay_in_utils.trace('p_location_id',to_char(p_location_id));
276: pay_in_utils.trace('p_concatenate',p_concatenate);
277: pay_in_utils.trace('p_field', p_field);
278: pay_in_utils.trace('**************************************************','********************');
279: END IF;
280:
281: OPEN csr_get_location_details;

Line 278: pay_in_utils.trace('******************************','');

274: pay_in_utils.trace('**************************************************','********************');
275: pay_in_utils.trace('p_location_id',to_char(p_location_id));
276: pay_in_utils.trace('p_concatenate',p_concatenate);
277: pay_in_utils.trace('p_field', p_field);
278: pay_in_utils.trace('**************************************************','********************');
279: END IF;
280:
281: OPEN csr_get_location_details;
282: FETCH csr_get_location_details

Line 330: pay_in_utils.trace('l_details', l_details );

326: l_details :=RTRIM(l_details,fnd_global.local_chr(10));
327: l_details :=RTRIM(l_details,',');
328:
329: IF g_debug THEN
330: pay_in_utils.trace('l_details', l_details );
331: END IF;
332:
333: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
334:

Line 333: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

329: IF g_debug THEN
330: pay_in_utils.trace('l_details', l_details );
331: END IF;
332:
333: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
334:
335: RETURN l_details;
336:
337: END get_location_details;

Line 385: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

381:
382: BEGIN
383: g_debug := hr_utility.debug_enabled;
384: l_procedure := g_package ||'get_location_details';
385: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
386:
387: IF g_debug THEN
388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('p_address_id ',p_address_id );

Line 388: pay_in_utils.trace('******************************','');

384: l_procedure := g_package ||'get_location_details';
385: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
386:
387: IF g_debug THEN
388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('p_address_id ',p_address_id );
390: pay_in_utils.trace('p_concatenate',p_concatenate);
391: pay_in_utils.trace('p_field' ,p_field );
392: pay_in_utils.trace('**************************************************','********************');

Line 389: pay_in_utils.trace('p_address_id ',p_address_id );

385: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
386:
387: IF g_debug THEN
388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('p_address_id ',p_address_id );
390: pay_in_utils.trace('p_concatenate',p_concatenate);
391: pay_in_utils.trace('p_field' ,p_field );
392: pay_in_utils.trace('**************************************************','********************');
393: END IF;

Line 390: pay_in_utils.trace('p_concatenate',p_concatenate);

386:
387: IF g_debug THEN
388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('p_address_id ',p_address_id );
390: pay_in_utils.trace('p_concatenate',p_concatenate);
391: pay_in_utils.trace('p_field' ,p_field );
392: pay_in_utils.trace('**************************************************','********************');
393: END IF;
394:

Line 391: pay_in_utils.trace('p_field' ,p_field );

387: IF g_debug THEN
388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('p_address_id ',p_address_id );
390: pay_in_utils.trace('p_concatenate',p_concatenate);
391: pay_in_utils.trace('p_field' ,p_field );
392: pay_in_utils.trace('**************************************************','********************');
393: END IF;
394:
395: OPEN csr_get_address_details;

Line 392: pay_in_utils.trace('******************************','');

388: pay_in_utils.trace('**************************************************','********************');
389: pay_in_utils.trace('p_address_id ',p_address_id );
390: pay_in_utils.trace('p_concatenate',p_concatenate);
391: pay_in_utils.trace('p_field' ,p_field );
392: pay_in_utils.trace('**************************************************','********************');
393: END IF;
394:
395: OPEN csr_get_address_details;
396: FETCH csr_get_address_details

Line 442: pay_in_utils.trace('l_details',l_details);

438:
439:
440:
441: IF g_debug THEN
442: pay_in_utils.trace('l_details',l_details);
443: END IF;
444:
445: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
446: RETURN l_details;

Line 445: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

441: IF g_debug THEN
442: pay_in_utils.trace('l_details',l_details);
443: END IF;
444:
445: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
446: RETURN l_details;
447:
448: END get_address_details;
449:

Line 470: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

466:
467: BEGIN
468: g_debug := hr_utility.debug_enabled;
469: l_procedure := g_package ||'write_tag';
470: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
471:
472: IF g_debug THEN
473: pay_in_utils.trace('**************************************************','********************');
474: pay_in_utils.trace('p_tag_name ',p_tag_name );

Line 473: pay_in_utils.trace('******************************','');

469: l_procedure := g_package ||'write_tag';
470: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
471:
472: IF g_debug THEN
473: pay_in_utils.trace('**************************************************','********************');
474: pay_in_utils.trace('p_tag_name ',p_tag_name );
475: pay_in_utils.trace('p_tag_value',p_tag_value);
476: pay_in_utils.trace('**************************************************','********************');
477: END IF;

Line 474: pay_in_utils.trace('p_tag_name ',p_tag_name );

470: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
471:
472: IF g_debug THEN
473: pay_in_utils.trace('**************************************************','********************');
474: pay_in_utils.trace('p_tag_name ',p_tag_name );
475: pay_in_utils.trace('p_tag_value',p_tag_value);
476: pay_in_utils.trace('**************************************************','********************');
477: END IF;
478:

Line 475: pay_in_utils.trace('p_tag_value',p_tag_value);

471:
472: IF g_debug THEN
473: pay_in_utils.trace('**************************************************','********************');
474: pay_in_utils.trace('p_tag_name ',p_tag_name );
475: pay_in_utils.trace('p_tag_value',p_tag_value);
476: pay_in_utils.trace('**************************************************','********************');
477: END IF;
478:
479: l_tag := pay_in_xml_utils.getTag( p_tag_name => p_tag_name

Line 476: pay_in_utils.trace('******************************','');

472: IF g_debug THEN
473: pay_in_utils.trace('**************************************************','********************');
474: pay_in_utils.trace('p_tag_name ',p_tag_name );
475: pay_in_utils.trace('p_tag_value',p_tag_value);
476: pay_in_utils.trace('**************************************************','********************');
477: END IF;
478:
479: l_tag := pay_in_xml_utils.getTag( p_tag_name => p_tag_name
480: , p_tag_value => p_tag_value

Line 484: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

480: , p_tag_value => p_tag_value
481: );
482:
483: dbms_lob.writeAppend(g_tmp_clob,length(l_tag),l_tag);
484: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
485: END write_tag;
486:
487: --------------------------------------------------------------------------
488: -- --

Line 614: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

610:
611: BEGIN
612: g_debug := hr_utility.debug_enabled;
613: l_procedure := g_package ||'build_gre_xml';
614: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
615:
616:
617: g_Bank_Details_tbl.DELETE;
618: g_Bank_Details_tbl_16aa.DELETE;

Line 621: pay_in_utils.trace('p_gre_id ',to_char(p_gre_id ));

617: g_Bank_Details_tbl.DELETE;
618: g_Bank_Details_tbl_16aa.DELETE;
619:
620: IF g_debug THEN
621: pay_in_utils.trace('p_gre_id ',to_char(p_gre_id ));
622: END IF;
623:
624: l_action_context_id := get_max_context_id(p_gre_id,g_assessment_year);
625:

Line 692: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

688:
689:
690: END IF;
691:
692: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
693:
694: EXCEPTION
695:
696: WHEN OTHERS THEN

Line 697: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);

693:
694: EXCEPTION
695:
696: WHEN OTHERS THEN
697: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,30);
698: RAISE;
699:
700: END build_gre_xml;
701:

Line 790: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

786:
787: BEGIN
788: g_debug := hr_utility.debug_enabled;
789: l_procedure := g_package ||'build_employee_xml';
790: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
791:
792:
793: IF g_debug THEN
794: pay_in_utils.trace('**************************************************','********************');

Line 794: pay_in_utils.trace('******************************','');

790: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
791:
792:
793: IF g_debug THEN
794: pay_in_utils.trace('**************************************************','********************');
795: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
796: pay_in_utils.trace('p_source_id ',p_source_id );
797: pay_in_utils.trace('**************************************************','********************');
798: END IF;

Line 795: pay_in_utils.trace('p_action_context_id ',p_action_context_id );

791:
792:
793: IF g_debug THEN
794: pay_in_utils.trace('**************************************************','********************');
795: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
796: pay_in_utils.trace('p_source_id ',p_source_id );
797: pay_in_utils.trace('**************************************************','********************');
798: END IF;
799:

Line 796: pay_in_utils.trace('p_source_id ',p_source_id );

792:
793: IF g_debug THEN
794: pay_in_utils.trace('**************************************************','********************');
795: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
796: pay_in_utils.trace('p_source_id ',p_source_id );
797: pay_in_utils.trace('**************************************************','********************');
798: END IF;
799:
800:

Line 797: pay_in_utils.trace('******************************','');

793: IF g_debug THEN
794: pay_in_utils.trace('**************************************************','********************');
795: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
796: pay_in_utils.trace('p_source_id ',p_source_id );
797: pay_in_utils.trace('**************************************************','********************');
798: END IF;
799:
800:
801: FOR i IN csr_get_person_data

Line 843: pay_in_utils.trace('******************************','');

839: p_flag := 0;
840: END IF;
841:
842: IF g_debug THEN
843: pay_in_utils.trace('**************************************************','********************');
844: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period ));
845: pay_in_utils.trace('p_flag ',to_char(p_flag ));
846: pay_in_utils.trace('**************************************************','********************');
847: END IF;

Line 844: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period ));

840: END IF;
841:
842: IF g_debug THEN
843: pay_in_utils.trace('**************************************************','********************');
844: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period ));
845: pay_in_utils.trace('p_flag ',to_char(p_flag ));
846: pay_in_utils.trace('**************************************************','********************');
847: END IF;
848:

Line 845: pay_in_utils.trace('p_flag ',to_char(p_flag ));

841:
842: IF g_debug THEN
843: pay_in_utils.trace('**************************************************','********************');
844: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period ));
845: pay_in_utils.trace('p_flag ',to_char(p_flag ));
846: pay_in_utils.trace('**************************************************','********************');
847: END IF;
848:
849: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 846: pay_in_utils.trace('******************************','');

842: IF g_debug THEN
843: pay_in_utils.trace('**************************************************','********************');
844: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period ));
845: pay_in_utils.trace('p_flag ',to_char(p_flag ));
846: pay_in_utils.trace('**************************************************','********************');
847: END IF;
848:
849: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
850:

Line 849: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

845: pay_in_utils.trace('p_flag ',to_char(p_flag ));
846: pay_in_utils.trace('**************************************************','********************');
847: END IF;
848:
849: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
850:
851:
852: EXCEPTION
853: --

Line 855: pay_in_utils.set_location(g_debug,'Error in: '||l_procedure,30);

851:
852: EXCEPTION
853: --
854: WHEN OTHERS THEN
855: pay_in_utils.set_location(g_debug,'Error in: '||l_procedure,30);
856: RAISE;
857: END build_employee_xml;
858:
859: --------------------------------------------------------------------------

Line 1188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

1184:
1185: BEGIN
1186: g_debug := hr_utility.debug_enabled;
1187: l_procedure := g_package ||'build_form16_xml';
1188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1189:
1190:
1191: IF g_debug THEN
1192: pay_in_utils.trace('**************************************************','********************');

Line 1192: pay_in_utils.trace('******************************','');

1188: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1189:
1190:
1191: IF g_debug THEN
1192: pay_in_utils.trace('**************************************************','********************');
1193: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
1194: pay_in_utils.trace('p_source_id ',p_source_id );
1195: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period));
1196: pay_in_utils.trace('p_flag ',to_char(p_flag));

Line 1193: pay_in_utils.trace('p_action_context_id ',p_action_context_id );

1189:
1190:
1191: IF g_debug THEN
1192: pay_in_utils.trace('**************************************************','********************');
1193: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
1194: pay_in_utils.trace('p_source_id ',p_source_id );
1195: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period));
1196: pay_in_utils.trace('p_flag ',to_char(p_flag));
1197: pay_in_utils.trace('**************************************************','********************');

Line 1194: pay_in_utils.trace('p_source_id ',p_source_id );

1190:
1191: IF g_debug THEN
1192: pay_in_utils.trace('**************************************************','********************');
1193: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
1194: pay_in_utils.trace('p_source_id ',p_source_id );
1195: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period));
1196: pay_in_utils.trace('p_flag ',to_char(p_flag));
1197: pay_in_utils.trace('**************************************************','********************');
1198: END IF;

Line 1195: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period));

1191: IF g_debug THEN
1192: pay_in_utils.trace('**************************************************','********************');
1193: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
1194: pay_in_utils.trace('p_source_id ',p_source_id );
1195: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period));
1196: pay_in_utils.trace('p_flag ',to_char(p_flag));
1197: pay_in_utils.trace('**************************************************','********************');
1198: END IF;
1199:

Line 1196: pay_in_utils.trace('p_flag ',to_char(p_flag));

1192: pay_in_utils.trace('**************************************************','********************');
1193: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
1194: pay_in_utils.trace('p_source_id ',p_source_id );
1195: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period));
1196: pay_in_utils.trace('p_flag ',to_char(p_flag));
1197: pay_in_utils.trace('**************************************************','********************');
1198: END IF;
1199:
1200: l_flag_for_12ba :=0;

Line 1197: pay_in_utils.trace('******************************','');

1193: pay_in_utils.trace('p_action_context_id ',p_action_context_id );
1194: pay_in_utils.trace('p_source_id ',p_source_id );
1195: pay_in_utils.trace('p_rem_pay_period ',to_char(p_rem_pay_period));
1196: pay_in_utils.trace('p_flag ',to_char(p_flag));
1197: pay_in_utils.trace('**************************************************','********************');
1198: END IF;
1199:
1200: l_flag_for_12ba :=0;
1201: l_flag_rep_gen := -1;

Line 1577: l_tax_in_words := pay_in_utils.number_to_words(g_salary_record(20).Value);

1573: write_tag('EE_INCOME',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(10).Value - g_salary_record(2).Value));
1574: write_tag('C_16AA_FLAG',p_flag_for_16aa );
1575: write_tag('C_12BA_FLAG',l_flag_for_12ba );
1576:
1577: l_tax_in_words := pay_in_utils.number_to_words(g_salary_record(20).Value);
1578: write_tag('TOTAL',l_tax_in_words );
1579:
1580: /* Allowances Start*/
1581: FOR i in csr_allowances LOOP

Line 1726: pay_in_utils.trace('p_flag_for_16aa ', p_flag_for_16aa );

1722:
1723: END IF;
1724: /* Challan End */
1725: IF g_debug THEN
1726: pay_in_utils.trace('p_flag_for_16aa ', p_flag_for_16aa );
1727: END IF;
1728: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1729: END build_form16_xml;
1730:

Line 1728: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

1724: /* Challan End */
1725: IF g_debug THEN
1726: pay_in_utils.trace('p_flag_for_16aa ', p_flag_for_16aa );
1727: END IF;
1728: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1729: END build_form16_xml;
1730:
1731: --------------------------------------------------------------------------
1732: -- --

Line 1805: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

1801:
1802: BEGIN
1803: g_debug := hr_utility.debug_enabled;
1804: l_procedure := g_package ||'build_form12ba_xml';
1805: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1806:
1807:
1808: IF g_debug THEN
1809: pay_in_utils.trace('**************************************************','********************');

Line 1809: pay_in_utils.trace('******************************','');

1805: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1806:
1807:
1808: IF g_debug THEN
1809: pay_in_utils.trace('**************************************************','********************');
1810: pay_in_utils.trace('p_action_context_id ', p_action_context_id );
1811: pay_in_utils.trace('p_source_id ', p_source_id );
1812: pay_in_utils.trace('**************************************************','********************');
1813: END IF;

Line 1810: pay_in_utils.trace('p_action_context_id ', p_action_context_id );

1806:
1807:
1808: IF g_debug THEN
1809: pay_in_utils.trace('**************************************************','********************');
1810: pay_in_utils.trace('p_action_context_id ', p_action_context_id );
1811: pay_in_utils.trace('p_source_id ', p_source_id );
1812: pay_in_utils.trace('**************************************************','********************');
1813: END IF;
1814:

Line 1811: pay_in_utils.trace('p_source_id ', p_source_id );

1807:
1808: IF g_debug THEN
1809: pay_in_utils.trace('**************************************************','********************');
1810: pay_in_utils.trace('p_action_context_id ', p_action_context_id );
1811: pay_in_utils.trace('p_source_id ', p_source_id );
1812: pay_in_utils.trace('**************************************************','********************');
1813: END IF;
1814:
1815: FOR j in csr_get_perq_values

Line 1812: pay_in_utils.trace('******************************','');

1808: IF g_debug THEN
1809: pay_in_utils.trace('**************************************************','********************');
1810: pay_in_utils.trace('p_action_context_id ', p_action_context_id );
1811: pay_in_utils.trace('p_source_id ', p_source_id );
1812: pay_in_utils.trace('**************************************************','********************');
1813: END IF;
1814:
1815: FOR j in csr_get_perq_values
1816: LOOP

Line 1872: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

1868: )
1869: );
1870:
1871: END LOOP;
1872: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1873:
1874: END build_form12ba_xml;
1875:
1876: --------------------------------------------------------------------------

Line 1897: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

1893:
1894: BEGIN
1895: g_debug := hr_utility.debug_enabled;
1896: l_procedure := g_package ||'build_form12ba_xml';
1897: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1898:
1899:
1900: IF g_debug THEN
1901: pay_in_utils.trace('p_business_group_id ', to_char(p_business_group_id) );

Line 1901: pay_in_utils.trace('p_business_group_id ', to_char(p_business_group_id) );

1897: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1898:
1899:
1900: IF g_debug THEN
1901: pay_in_utils.trace('p_business_group_id ', to_char(p_business_group_id) );
1902: END IF;
1903:
1904: p_template := 'PAY_IN_ITR_EE_05';
1905: g_chunk_size := 10;

Line 1909: pay_in_utils.trace('p_template ', p_template);

1905: g_chunk_size := 10;
1906: g_business_group_id := p_business_group_id;
1907:
1908: IF g_debug THEN
1909: pay_in_utils.trace('p_template ', p_template);
1910: END IF;
1911: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1912: EXCEPTION
1913:

Line 1911: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

1907:
1908: IF g_debug THEN
1909: pay_in_utils.trace('p_template ', p_template);
1910: END IF;
1911: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1912: EXCEPTION
1913:
1914: WHEN OTHERS THEN
1915: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,20);

Line 1915: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,20);

1911: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1912: EXCEPTION
1913:
1914: WHEN OTHERS THEN
1915: pay_in_utils.set_location(g_debug,'Error in : '||l_procedure,20);
1916: RAISE;
1917:
1918: END get_template;
1919:

Line 1939: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

1935:
1936: BEGIN
1937: g_debug := hr_utility.debug_enabled;
1938: l_procedure := g_package ||'fetch_xml';
1939: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1940:
1941: -- If Clobs exists return next clob else exit NULL
1942: hr_utility.trace('Clob Count : ' || g_clob_cnt);
1943: hr_utility.trace('Clob Fetch Count : ' || g_fetch_clob_cnt);

Line 1951: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

1947: ELSE
1948: p_clob := null;
1949: END IF;
1950:
1951: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1952:
1953: END fetch_xml;
1954:
1955: --------------------------------------------------------------------------

Line 2079: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

2075:
2076: begin
2077: g_debug := hr_utility.debug_enabled;
2078: l_procedure := g_package ||'load_xml';
2079: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2080:
2081:
2082: IF g_debug THEN
2083: pay_in_utils.trace('**************************************************','********************');

Line 2083: pay_in_utils.trace('******************************','');

2079: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2080:
2081:
2082: IF g_debug THEN
2083: pay_in_utils.trace('**************************************************','********************');
2084: pay_in_utils.trace('Business Group ID',to_char(p_business_group_id ));
2085: pay_in_utils.trace('Assessment Year ',p_assessment_year );
2086: pay_in_utils.trace('GRE Organization ',p_gre_organization );
2087: pay_in_utils.trace('Employee Type ',p_employee_type );

Line 2084: pay_in_utils.trace('Business Group ID',to_char(p_business_group_id ));

2080:
2081:
2082: IF g_debug THEN
2083: pay_in_utils.trace('**************************************************','********************');
2084: pay_in_utils.trace('Business Group ID',to_char(p_business_group_id ));
2085: pay_in_utils.trace('Assessment Year ',p_assessment_year );
2086: pay_in_utils.trace('GRE Organization ',p_gre_organization );
2087: pay_in_utils.trace('Employee Type ',p_employee_type );
2088: pay_in_utils.trace('Employee Number ',p_employee_number );

Line 2085: pay_in_utils.trace('Assessment Year ',p_assessment_year );

2081:
2082: IF g_debug THEN
2083: pay_in_utils.trace('**************************************************','********************');
2084: pay_in_utils.trace('Business Group ID',to_char(p_business_group_id ));
2085: pay_in_utils.trace('Assessment Year ',p_assessment_year );
2086: pay_in_utils.trace('GRE Organization ',p_gre_organization );
2087: pay_in_utils.trace('Employee Type ',p_employee_type );
2088: pay_in_utils.trace('Employee Number ',p_employee_number );
2089: pay_in_utils.trace('**************************************************','********************');

Line 2086: pay_in_utils.trace('GRE Organization ',p_gre_organization );

2082: IF g_debug THEN
2083: pay_in_utils.trace('**************************************************','********************');
2084: pay_in_utils.trace('Business Group ID',to_char(p_business_group_id ));
2085: pay_in_utils.trace('Assessment Year ',p_assessment_year );
2086: pay_in_utils.trace('GRE Organization ',p_gre_organization );
2087: pay_in_utils.trace('Employee Type ',p_employee_type );
2088: pay_in_utils.trace('Employee Number ',p_employee_number );
2089: pay_in_utils.trace('**************************************************','********************');
2090: END IF;

Line 2087: pay_in_utils.trace('Employee Type ',p_employee_type );

2083: pay_in_utils.trace('**************************************************','********************');
2084: pay_in_utils.trace('Business Group ID',to_char(p_business_group_id ));
2085: pay_in_utils.trace('Assessment Year ',p_assessment_year );
2086: pay_in_utils.trace('GRE Organization ',p_gre_organization );
2087: pay_in_utils.trace('Employee Type ',p_employee_type );
2088: pay_in_utils.trace('Employee Number ',p_employee_number );
2089: pay_in_utils.trace('**************************************************','********************');
2090: END IF;
2091:

Line 2088: pay_in_utils.trace('Employee Number ',p_employee_number );

2084: pay_in_utils.trace('Business Group ID',to_char(p_business_group_id ));
2085: pay_in_utils.trace('Assessment Year ',p_assessment_year );
2086: pay_in_utils.trace('GRE Organization ',p_gre_organization );
2087: pay_in_utils.trace('Employee Type ',p_employee_type );
2088: pay_in_utils.trace('Employee Number ',p_employee_number );
2089: pay_in_utils.trace('**************************************************','********************');
2090: END IF;
2091:
2092: l_emp_count := 0;

Line 2089: pay_in_utils.trace('******************************','');

2085: pay_in_utils.trace('Assessment Year ',p_assessment_year );
2086: pay_in_utils.trace('GRE Organization ',p_gre_organization );
2087: pay_in_utils.trace('Employee Type ',p_employee_type );
2088: pay_in_utils.trace('Employee Number ',p_employee_number );
2089: pay_in_utils.trace('**************************************************','********************');
2090: END IF;
2091:
2092: l_emp_count := 0;
2093: g_assessment_year := p_assessment_year;

Line 2173: pay_in_utils.set_location(g_debug,'INDIA F16: Building XML for Employee',70);

2169: /* The following calls builds the XML related to form16, form 16aa and 12ba
2170: required to generate the report
2171: */
2172:
2173: pay_in_utils.set_location(g_debug,'INDIA F16: Building XML for Employee',70);
2174: build_employee_xml(l_action_context_id,l_source_id,p_rem_pay_period,p_flag);
2175: pay_in_utils.set_location(g_debug,'Building XML for Form 16/16AA',80);
2176: build_form16_xml(l_action_context_id,l_source_id,p_rem_pay_period,p_flag,l_flag_for_16aa);
2177: IF (l_flag_for_16aa = -1) THEN

Line 2175: pay_in_utils.set_location(g_debug,'Building XML for Form 16/16AA',80);

2171: */
2172:
2173: pay_in_utils.set_location(g_debug,'INDIA F16: Building XML for Employee',70);
2174: build_employee_xml(l_action_context_id,l_source_id,p_rem_pay_period,p_flag);
2175: pay_in_utils.set_location(g_debug,'Building XML for Form 16/16AA',80);
2176: build_form16_xml(l_action_context_id,l_source_id,p_rem_pay_period,p_flag,l_flag_for_16aa);
2177: IF (l_flag_for_16aa = -1) THEN
2178: l_emp_count := l_emp_count - 1;
2179: ELSE

Line 2180: pay_in_utils.set_location(g_debug,'Building XML for Form 12BA',90);

2176: build_form16_xml(l_action_context_id,l_source_id,p_rem_pay_period,p_flag,l_flag_for_16aa);
2177: IF (l_flag_for_16aa = -1) THEN
2178: l_emp_count := l_emp_count - 1;
2179: ELSE
2180: pay_in_utils.set_location(g_debug,'Building XML for Form 12BA',90);
2181: init_form12ba_code;
2182: build_form12ba_xml(l_action_context_id,l_source_id);
2183: l_open_tag := '';
2184: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

Line 2206: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,100);

2202: ELSE
2203: p_clob_cnt := g_clob_cnt;
2204: END IF;
2205:
2206: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,100);
2207: END load_xml;
2208:
2209: BEGIN
2210: