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.PQP_EXCP_RPT dependencies on FND_FILE

Line 278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);

274:
275: begin
276: -- hr_utility.trace_on(NULL,'YYY');
277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');
278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);
279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);
280: hr_utility.trace('ppa_finder :'||p_ppa_finder);
281: hr_utility.trace('report_date :'||p_report_date);
282:

Line 279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);

275: begin
276: -- hr_utility.trace_on(NULL,'YYY');
277: hr_utility.trace('Entering Procedure PQP_EXR_CSV_FORMAT....');
278: hr_utility.trace('Fnd_log.output :'||fnd_file.output);
279: hr_utility.trace('Fnd_log.Log :'||fnd_file.log);
280: hr_utility.trace('ppa_finder :'||p_ppa_finder);
281: hr_utility.trace('report_date :'||p_report_date);
282:
283: --

Line 476: fnd_file.put(fnd_file.output,'"Effective Date","');

472: --
473: -- Print the header if not printed already
474: --
475: IF NOT l_header_printed THEN
476: fnd_file.put(fnd_file.output,'"Effective Date","');
477: -- BUG #3008584, changed from Payroll date to report parameter date.
478: fnd_file.put_line(fnd_file.output,fnd_date.canonical_to_date(p_report_date) || '"');
479:
480: fnd_file.put(fnd_file.output,'"Business Group Name","');

Line 478: fnd_file.put_line(fnd_file.output,fnd_date.canonical_to_date(p_report_date) || '"');

474: --
475: IF NOT l_header_printed THEN
476: fnd_file.put(fnd_file.output,'"Effective Date","');
477: -- BUG #3008584, changed from Payroll date to report parameter date.
478: fnd_file.put_line(fnd_file.output,fnd_date.canonical_to_date(p_report_date) || '"');
479:
480: fnd_file.put(fnd_file.output,'"Business Group Name","');
481: fnd_file.put_line(fnd_file.output,l_business_group_name||'"');
482:

Line 480: fnd_file.put(fnd_file.output,'"Business Group Name","');

476: fnd_file.put(fnd_file.output,'"Effective Date","');
477: -- BUG #3008584, changed from Payroll date to report parameter date.
478: fnd_file.put_line(fnd_file.output,fnd_date.canonical_to_date(p_report_date) || '"');
479:
480: fnd_file.put(fnd_file.output,'"Business Group Name","');
481: fnd_file.put_line(fnd_file.output,l_business_group_name||'"');
482:
483: fnd_file.put(fnd_file.output,'"Consolidation Set Name","');
484: fnd_file.put_line(fnd_file.output,l_consolidation_set_name||'"');

Line 481: fnd_file.put_line(fnd_file.output,l_business_group_name||'"');

477: -- BUG #3008584, changed from Payroll date to report parameter date.
478: fnd_file.put_line(fnd_file.output,fnd_date.canonical_to_date(p_report_date) || '"');
479:
480: fnd_file.put(fnd_file.output,'"Business Group Name","');
481: fnd_file.put_line(fnd_file.output,l_business_group_name||'"');
482:
483: fnd_file.put(fnd_file.output,'"Consolidation Set Name","');
484: fnd_file.put_line(fnd_file.output,l_consolidation_set_name||'"');
485:

Line 483: fnd_file.put(fnd_file.output,'"Consolidation Set Name","');

479:
480: fnd_file.put(fnd_file.output,'"Business Group Name","');
481: fnd_file.put_line(fnd_file.output,l_business_group_name||'"');
482:
483: fnd_file.put(fnd_file.output,'"Consolidation Set Name","');
484: fnd_file.put_line(fnd_file.output,l_consolidation_set_name||'"');
485:
486: --
487: -- If its a exception report group,

Line 484: fnd_file.put_line(fnd_file.output,l_consolidation_set_name||'"');

480: fnd_file.put(fnd_file.output,'"Business Group Name","');
481: fnd_file.put_line(fnd_file.output,l_business_group_name||'"');
482:
483: fnd_file.put(fnd_file.output,'"Consolidation Set Name","');
484: fnd_file.put_line(fnd_file.output,l_consolidation_set_name||'"');
485:
486: --
487: -- If its a exception report group,
488: -- then print the group name in the header

Line 500: fnd_file.put(fnd_file.output,'"Exception Group Name","');

496: CLOSE c_get_exception_group_name;
497: -- Close the cursor
498:
499: -- Print the group name
500: fnd_file.put(fnd_file.output,'"Exception Group Name","');
501: fnd_file.put_line(fnd_file.output, l_exception_group_name ||'"');
502: END IF;
503:
504: --

Line 501: fnd_file.put_line(fnd_file.output, l_exception_group_name ||'"');

497: -- Close the cursor
498:
499: -- Print the group name
500: fnd_file.put(fnd_file.output,'"Exception Group Name","');
501: fnd_file.put_line(fnd_file.output, l_exception_group_name ||'"');
502: END IF;
503:
504: --
505: -- Print a Blank row between the heading and the main report body.

Line 507: fnd_file.put_line(fnd_file.output,' ');

503:
504: --
505: -- Print a Blank row between the heading and the main report body.
506: --
507: fnd_file.put_line(fnd_file.output,' ');
508:
509: --
510: -- Printing the SpreadSheet Table Labels
511: --

Line 512: fnd_file.put(fnd_file.output,'"Exception Report Name",');

508:
509: --
510: -- Printing the SpreadSheet Table Labels
511: --
512: fnd_file.put(fnd_file.output,'"Exception Report Name",');
513: fnd_file.put(fnd_file.output,'"Payroll Name",');
514: fnd_file.put(fnd_file.output,'"Employee Full Name",');
515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');
516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');

Line 513: fnd_file.put(fnd_file.output,'"Payroll Name",');

509: --
510: -- Printing the SpreadSheet Table Labels
511: --
512: fnd_file.put(fnd_file.output,'"Exception Report Name",');
513: fnd_file.put(fnd_file.output,'"Payroll Name",');
514: fnd_file.put(fnd_file.output,'"Employee Full Name",');
515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');
516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');
517: fnd_file.put(fnd_file.output,'"Comparison Type",');

Line 514: fnd_file.put(fnd_file.output,'"Employee Full Name",');

510: -- Printing the SpreadSheet Table Labels
511: --
512: fnd_file.put(fnd_file.output,'"Exception Report Name",');
513: fnd_file.put(fnd_file.output,'"Payroll Name",');
514: fnd_file.put(fnd_file.output,'"Employee Full Name",');
515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');
516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');
517: fnd_file.put(fnd_file.output,'"Comparison Type",');
518: fnd_file.put(fnd_file.output,'"Comparison Value",');

Line 515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');

511: --
512: fnd_file.put(fnd_file.output,'"Exception Report Name",');
513: fnd_file.put(fnd_file.output,'"Payroll Name",');
514: fnd_file.put(fnd_file.output,'"Employee Full Name",');
515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');
516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');
517: fnd_file.put(fnd_file.output,'"Comparison Type",');
518: fnd_file.put(fnd_file.output,'"Comparison Value",');
519: fnd_file.put(fnd_file.output,'"Variance Type",');

Line 516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');

512: fnd_file.put(fnd_file.output,'"Exception Report Name",');
513: fnd_file.put(fnd_file.output,'"Payroll Name",');
514: fnd_file.put(fnd_file.output,'"Employee Full Name",');
515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');
516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');
517: fnd_file.put(fnd_file.output,'"Comparison Type",');
518: fnd_file.put(fnd_file.output,'"Comparison Value",');
519: fnd_file.put(fnd_file.output,'"Variance Type",');
520: fnd_file.put(fnd_file.output,'"Variance Operator",');

Line 517: fnd_file.put(fnd_file.output,'"Comparison Type",');

513: fnd_file.put(fnd_file.output,'"Payroll Name",');
514: fnd_file.put(fnd_file.output,'"Employee Full Name",');
515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');
516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');
517: fnd_file.put(fnd_file.output,'"Comparison Type",');
518: fnd_file.put(fnd_file.output,'"Comparison Value",');
519: fnd_file.put(fnd_file.output,'"Variance Type",');
520: fnd_file.put(fnd_file.output,'"Variance Operator",');
521: fnd_file.put(fnd_file.output,'"Variance Value",');

Line 518: fnd_file.put(fnd_file.output,'"Comparison Value",');

514: fnd_file.put(fnd_file.output,'"Employee Full Name",');
515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');
516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');
517: fnd_file.put(fnd_file.output,'"Comparison Type",');
518: fnd_file.put(fnd_file.output,'"Comparison Value",');
519: fnd_file.put(fnd_file.output,'"Variance Type",');
520: fnd_file.put(fnd_file.output,'"Variance Operator",');
521: fnd_file.put(fnd_file.output,'"Variance Value",');
522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');

Line 519: fnd_file.put(fnd_file.output,'"Variance Type",');

515: fnd_file.put(fnd_file.output,'"Assignment Number","Balance Name",');
516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');
517: fnd_file.put(fnd_file.output,'"Comparison Type",');
518: fnd_file.put(fnd_file.output,'"Comparison Value",');
519: fnd_file.put(fnd_file.output,'"Variance Type",');
520: fnd_file.put(fnd_file.output,'"Variance Operator",');
521: fnd_file.put(fnd_file.output,'"Variance Value",');
522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');
523: fnd_file.put(fnd_file.output,'"Difference",');

Line 520: fnd_file.put(fnd_file.output,'"Variance Operator",');

516: fnd_file.put(fnd_file.output,'"Balance Dimension Name",');
517: fnd_file.put(fnd_file.output,'"Comparison Type",');
518: fnd_file.put(fnd_file.output,'"Comparison Value",');
519: fnd_file.put(fnd_file.output,'"Variance Type",');
520: fnd_file.put(fnd_file.output,'"Variance Operator",');
521: fnd_file.put(fnd_file.output,'"Variance Value",');
522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');
523: fnd_file.put(fnd_file.output,'"Difference",');
524: fnd_file.put(fnd_file.output,'"Employee Last Name",');

Line 521: fnd_file.put(fnd_file.output,'"Variance Value",');

517: fnd_file.put(fnd_file.output,'"Comparison Type",');
518: fnd_file.put(fnd_file.output,'"Comparison Value",');
519: fnd_file.put(fnd_file.output,'"Variance Type",');
520: fnd_file.put(fnd_file.output,'"Variance Operator",');
521: fnd_file.put(fnd_file.output,'"Variance Value",');
522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');
523: fnd_file.put(fnd_file.output,'"Difference",');
524: fnd_file.put(fnd_file.output,'"Employee Last Name",');
525: fnd_file.put(fnd_file.output,'"Employee First Name",');

Line 522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');

518: fnd_file.put(fnd_file.output,'"Comparison Value",');
519: fnd_file.put(fnd_file.output,'"Variance Type",');
520: fnd_file.put(fnd_file.output,'"Variance Operator",');
521: fnd_file.put(fnd_file.output,'"Variance Value",');
522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');
523: fnd_file.put(fnd_file.output,'"Difference",');
524: fnd_file.put(fnd_file.output,'"Employee Last Name",');
525: fnd_file.put(fnd_file.output,'"Employee First Name",');
526: fnd_file.put_line(fnd_file.output,'"Employee Middle Name"');

Line 523: fnd_file.put(fnd_file.output,'"Difference",');

519: fnd_file.put(fnd_file.output,'"Variance Type",');
520: fnd_file.put(fnd_file.output,'"Variance Operator",');
521: fnd_file.put(fnd_file.output,'"Variance Value",');
522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');
523: fnd_file.put(fnd_file.output,'"Difference",');
524: fnd_file.put(fnd_file.output,'"Employee Last Name",');
525: fnd_file.put(fnd_file.output,'"Employee First Name",');
526: fnd_file.put_line(fnd_file.output,'"Employee Middle Name"');
527: l_header_printed := TRUE;

Line 524: fnd_file.put(fnd_file.output,'"Employee Last Name",');

520: fnd_file.put(fnd_file.output,'"Variance Operator",');
521: fnd_file.put(fnd_file.output,'"Variance Value",');
522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');
523: fnd_file.put(fnd_file.output,'"Difference",');
524: fnd_file.put(fnd_file.output,'"Employee Last Name",');
525: fnd_file.put(fnd_file.output,'"Employee First Name",');
526: fnd_file.put_line(fnd_file.output,'"Employee Middle Name"');
527: l_header_printed := TRUE;
528: END IF;

Line 525: fnd_file.put(fnd_file.output,'"Employee First Name",');

521: fnd_file.put(fnd_file.output,'"Variance Value",');
522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');
523: fnd_file.put(fnd_file.output,'"Difference",');
524: fnd_file.put(fnd_file.output,'"Employee Last Name",');
525: fnd_file.put(fnd_file.output,'"Employee First Name",');
526: fnd_file.put_line(fnd_file.output,'"Employee Middle Name"');
527: l_header_printed := TRUE;
528: END IF;
529:

Line 526: fnd_file.put_line(fnd_file.output,'"Employee Middle Name"');

522: fnd_file.put(fnd_file.output,'"Previous Balance","Current Balance",');
523: fnd_file.put(fnd_file.output,'"Difference",');
524: fnd_file.put(fnd_file.output,'"Employee Last Name",');
525: fnd_file.put(fnd_file.output,'"Employee First Name",');
526: fnd_file.put_line(fnd_file.output,'"Employee Middle Name"');
527: l_header_printed := TRUE;
528: END IF;
529:
530: --

Line 545: fnd_file.put(fnd_file.output,'"' || l_exception_report_name|| '","');

541:
542: -- Get the Currency format code
543: l_currency_format := fnd_currency.get_format_mask(l_currency_code, 30);
544:
545: fnd_file.put(fnd_file.output,'"' || l_exception_report_name|| '","');
546: fnd_file.put(fnd_file.output,l_payroll_name || '","');
547: fnd_file.put(fnd_file.output,l_full_name || '","');
548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');
549: fnd_file.put(fnd_file.output,l_balance_name || '","');

Line 546: fnd_file.put(fnd_file.output,l_payroll_name || '","');

542: -- Get the Currency format code
543: l_currency_format := fnd_currency.get_format_mask(l_currency_code, 30);
544:
545: fnd_file.put(fnd_file.output,'"' || l_exception_report_name|| '","');
546: fnd_file.put(fnd_file.output,l_payroll_name || '","');
547: fnd_file.put(fnd_file.output,l_full_name || '","');
548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');
549: fnd_file.put(fnd_file.output,l_balance_name || '","');
550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');

Line 547: fnd_file.put(fnd_file.output,l_full_name || '","');

543: l_currency_format := fnd_currency.get_format_mask(l_currency_code, 30);
544:
545: fnd_file.put(fnd_file.output,'"' || l_exception_report_name|| '","');
546: fnd_file.put(fnd_file.output,l_payroll_name || '","');
547: fnd_file.put(fnd_file.output,l_full_name || '","');
548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');
549: fnd_file.put(fnd_file.output,l_balance_name || '","');
550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');
551: fnd_file.put(fnd_file.output,l_comparison_type || '","');

Line 548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');

544:
545: fnd_file.put(fnd_file.output,'"' || l_exception_report_name|| '","');
546: fnd_file.put(fnd_file.output,l_payroll_name || '","');
547: fnd_file.put(fnd_file.output,l_full_name || '","');
548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');
549: fnd_file.put(fnd_file.output,l_balance_name || '","');
550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');
551: fnd_file.put(fnd_file.output,l_comparison_type || '","');
552: fnd_file.put(fnd_file.output,l_comparison_value || '","');

Line 549: fnd_file.put(fnd_file.output,l_balance_name || '","');

545: fnd_file.put(fnd_file.output,'"' || l_exception_report_name|| '","');
546: fnd_file.put(fnd_file.output,l_payroll_name || '","');
547: fnd_file.put(fnd_file.output,l_full_name || '","');
548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');
549: fnd_file.put(fnd_file.output,l_balance_name || '","');
550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');
551: fnd_file.put(fnd_file.output,l_comparison_type || '","');
552: fnd_file.put(fnd_file.output,l_comparison_value || '","');
553: fnd_file.put(fnd_file.output,l_variance_type || '","');

Line 550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');

546: fnd_file.put(fnd_file.output,l_payroll_name || '","');
547: fnd_file.put(fnd_file.output,l_full_name || '","');
548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');
549: fnd_file.put(fnd_file.output,l_balance_name || '","');
550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');
551: fnd_file.put(fnd_file.output,l_comparison_type || '","');
552: fnd_file.put(fnd_file.output,l_comparison_value || '","');
553: fnd_file.put(fnd_file.output,l_variance_type || '","');
554: fnd_file.put(fnd_file.output,l_variance_operator || '","');

Line 551: fnd_file.put(fnd_file.output,l_comparison_type || '","');

547: fnd_file.put(fnd_file.output,l_full_name || '","');
548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');
549: fnd_file.put(fnd_file.output,l_balance_name || '","');
550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');
551: fnd_file.put(fnd_file.output,l_comparison_type || '","');
552: fnd_file.put(fnd_file.output,l_comparison_value || '","');
553: fnd_file.put(fnd_file.output,l_variance_type || '","');
554: fnd_file.put(fnd_file.output,l_variance_operator || '","');
555: fnd_file.put(fnd_file.output,l_variance_value || '","');

Line 552: fnd_file.put(fnd_file.output,l_comparison_value || '","');

548: fnd_file.put(fnd_file.output,r_excp_rpt_data.assignment_number || '","');
549: fnd_file.put(fnd_file.output,l_balance_name || '","');
550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');
551: fnd_file.put(fnd_file.output,l_comparison_type || '","');
552: fnd_file.put(fnd_file.output,l_comparison_value || '","');
553: fnd_file.put(fnd_file.output,l_variance_type || '","');
554: fnd_file.put(fnd_file.output,l_variance_operator || '","');
555: fnd_file.put(fnd_file.output,l_variance_value || '","');
556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );

Line 553: fnd_file.put(fnd_file.output,l_variance_type || '","');

549: fnd_file.put(fnd_file.output,l_balance_name || '","');
550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');
551: fnd_file.put(fnd_file.output,l_comparison_type || '","');
552: fnd_file.put(fnd_file.output,l_comparison_value || '","');
553: fnd_file.put(fnd_file.output,l_variance_type || '","');
554: fnd_file.put(fnd_file.output,l_variance_operator || '","');
555: fnd_file.put(fnd_file.output,l_variance_value || '","');
556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );
557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );

Line 554: fnd_file.put(fnd_file.output,l_variance_operator || '","');

550: fnd_file.put(fnd_file.output,l_dimension_name ||'","');
551: fnd_file.put(fnd_file.output,l_comparison_type || '","');
552: fnd_file.put(fnd_file.output,l_comparison_value || '","');
553: fnd_file.put(fnd_file.output,l_variance_type || '","');
554: fnd_file.put(fnd_file.output,l_variance_operator || '","');
555: fnd_file.put(fnd_file.output,l_variance_value || '","');
556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );
557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );
558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');

Line 555: fnd_file.put(fnd_file.output,l_variance_value || '","');

551: fnd_file.put(fnd_file.output,l_comparison_type || '","');
552: fnd_file.put(fnd_file.output,l_comparison_value || '","');
553: fnd_file.put(fnd_file.output,l_variance_type || '","');
554: fnd_file.put(fnd_file.output,l_variance_operator || '","');
555: fnd_file.put(fnd_file.output,l_variance_value || '","');
556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );
557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );
558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');
559: fnd_file.put(fnd_file.output,r_excp_rpt_data.last_name||'","');

Line 556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );

552: fnd_file.put(fnd_file.output,l_comparison_value || '","');
553: fnd_file.put(fnd_file.output,l_variance_type || '","');
554: fnd_file.put(fnd_file.output,l_variance_operator || '","');
555: fnd_file.put(fnd_file.output,l_variance_value || '","');
556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );
557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );
558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');
559: fnd_file.put(fnd_file.output,r_excp_rpt_data.last_name||'","');
560: fnd_file.put(fnd_file.output,r_excp_rpt_data.first_name||'","');

Line 557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );

553: fnd_file.put(fnd_file.output,l_variance_type || '","');
554: fnd_file.put(fnd_file.output,l_variance_operator || '","');
555: fnd_file.put(fnd_file.output,l_variance_value || '","');
556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );
557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );
558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');
559: fnd_file.put(fnd_file.output,r_excp_rpt_data.last_name||'","');
560: fnd_file.put(fnd_file.output,r_excp_rpt_data.first_name||'","');
561: fnd_file.put_line(fnd_file.output,r_excp_rpt_data.middle_name||'"');

Line 558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');

554: fnd_file.put(fnd_file.output,l_variance_operator || '","');
555: fnd_file.put(fnd_file.output,l_variance_value || '","');
556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );
557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );
558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');
559: fnd_file.put(fnd_file.output,r_excp_rpt_data.last_name||'","');
560: fnd_file.put(fnd_file.output,r_excp_rpt_data.first_name||'","');
561: fnd_file.put_line(fnd_file.output,r_excp_rpt_data.middle_name||'"');
562:

Line 559: fnd_file.put(fnd_file.output,r_excp_rpt_data.last_name||'","');

555: fnd_file.put(fnd_file.output,l_variance_value || '","');
556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );
557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );
558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');
559: fnd_file.put(fnd_file.output,r_excp_rpt_data.last_name||'","');
560: fnd_file.put(fnd_file.output,r_excp_rpt_data.first_name||'","');
561: fnd_file.put_line(fnd_file.output,r_excp_rpt_data.middle_name||'"');
562:
563: END LOOP;

Line 560: fnd_file.put(fnd_file.output,r_excp_rpt_data.first_name||'","');

556: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.previous_balance, l_currency_format) || '","' );
557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );
558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');
559: fnd_file.put(fnd_file.output,r_excp_rpt_data.last_name||'","');
560: fnd_file.put(fnd_file.output,r_excp_rpt_data.first_name||'","');
561: fnd_file.put_line(fnd_file.output,r_excp_rpt_data.middle_name||'"');
562:
563: END LOOP;
564: -- Loop Ends here

Line 561: fnd_file.put_line(fnd_file.output,r_excp_rpt_data.middle_name||'"');

557: fnd_file.put(fnd_file.output,TO_CHAR(r_excp_rpt_data.current_balance, l_currency_format) || '","' );
558: fnd_file.put(fnd_file.output,TO_CHAR(l_difference, l_currency_format)||'","');
559: fnd_file.put(fnd_file.output,r_excp_rpt_data.last_name||'","');
560: fnd_file.put(fnd_file.output,r_excp_rpt_data.first_name||'","');
561: fnd_file.put_line(fnd_file.output,r_excp_rpt_data.middle_name||'"');
562:
563: END LOOP;
564: -- Loop Ends here
565: IF l_output_format = 'CSV' THEN