DBA Data[Home] [Help]

APPS.JAI_RCV_RND_PKG dependencies on FND_FILE

Line 424: FND_FILE.PUT_LINE( FND_FILE.log, 'File Version: 115.2 and LastUpdateDate:08/01/2004, Inputs parameters: p_organization_id->'

420: OPEN c_enable_trace('JAINRGRND'); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
421: FETCH c_enable_trace INTO v_enable_trace;
422: CLOSE c_enable_trace;
423:
424: FND_FILE.PUT_LINE( FND_FILE.log, 'File Version: 115.2 and LastUpdateDate:08/01/2004, Inputs parameters: p_organization_id->'
425: ||p_organization_id
426: ||', p_ex_invoice_from_date->'||p_ex_invoice_from_date
427: ||', p_ex_invoice_to_date->'||p_ex_invoice_to_date
428: ||', v_enable_trace->'||v_enable_trace

Line 441: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||v_spid||'.trc');

437: OPEN get_dbname;
438: FETCH get_dbname INTO v_name1;
439: CLOSE get_dbname;
440:
441: FND_FILE.PUT_LINE( FND_FILE.log, 'TraceFile Name = '||lower(v_name1)||'_ora_'||v_spid||'.trc');
442:
443: EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 trace name context forever, level 4''';
444:
445: END IF;

Line 483: FND_FILE.PUT_LINE( FND_FILE.log, 'ERROR: Rounding Account is not specified at Organization Level');

479:
480: v_statement_no := '0.2';
481:
482: IF v_rg_rounding_account_id IS NULL THEN
483: FND_FILE.PUT_LINE( FND_FILE.log, 'ERROR: Rounding Account is not specified at Organization Level');
484: RAISE_APPLICATION_ERROR( -20099, 'Rounding Account is not specified at Organization Level');
485: END IF;
486:
487: v_statement_no := '0.3';

Line 610: FND_FILE.PUT_LINE( FND_FILE.log, 'v_already_rounded_chk->'||v_already_rounded_chk

606: THEN
607: v_rnd_entries_to_be_passed := 2;
608: END IF;
609:
610: FND_FILE.PUT_LINE( FND_FILE.log, 'v_already_rounded_chk->'||v_already_rounded_chk
611: ||', v_1st_claim_rnd_amt->'||r_cgin_chk_for_2nd_claim.cent_percent_cnt
612: );
613:
614: -- If the following if is satisfied, then cgin chk for 2nd claim has to be done

Line 663: FND_FILE.PUT_LINE( FND_FILE.log, '+++++ Ex. Invoice Already rounded +++++');

659: */
660: where rt.transaction_id = jcrg23ac.receipt_ref
661: and rt.transaction_type = v_transaction_type);
662:
663: FND_FILE.PUT_LINE( FND_FILE.log, '+++++ Ex. Invoice Already rounded +++++');
664: GOTO next_exc_inv;
665: END IF;
666:
667: -- Rounding was not yet done for this excise invoice

Line 676: FND_FILE.PUT_LINE( FND_FILE.log, '2nd_claim.cent ->'||r_cgin_chk_for_2nd_claim.cent_percent_cnt

672: END IF;
673:
674: END IF;
675:
676: FND_FILE.PUT_LINE( FND_FILE.log, '2nd_claim.cent ->'||r_cgin_chk_for_2nd_claim.cent_percent_cnt
677: ||', fifty->'||r_cgin_chk_for_2nd_claim.fifty_percent_cnt
678: ||', zero->'||r_cgin_chk_for_2nd_claim.zero_percent_cnt
679: ||', v_proceed_for_2nd_claim->'||v_proceed_for_2nd_claim
680: );

Line 739: FND_FILE.PUT_LINE( FND_FILE.log, 'TrxId:'||line.transaction_id ||', RecvQty->'||ln_receive_qty);

735: ln_receive_amount.sh_cvd_edu_cess;
736:
737: CLOSE c_receipt_tax_amount;
738:
739: FND_FILE.PUT_LINE( FND_FILE.log, 'TrxId:'||line.transaction_id ||', RecvQty->'||ln_receive_qty);
740:
741: -- this is to loop through all the RECEIVE and related CORRECT transactions
742: lv_ttype_correct := 'CORRECT' ; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
743: FOR trx IN (select transaction_id, quantity

Line 834: FND_FILE.PUT_LINE( FND_FILE.log, 'Started Processing shipment_header_id->'||v_shipment_header_id

830: v_register_type := p_register_type;
831: v_rounding_type := 2;
832: END IF;
833:
834: FND_FILE.PUT_LINE( FND_FILE.log, 'Started Processing shipment_header_id->'||v_shipment_header_id
835: ||', excise_invoice_no->'||v_excise_invoice_no
836: ||', excise_invoice_date->'||v_excise_invoice_date
837: );
838:

Line 963: FND_FILE.PUT_LINE( FND_FILE.log, 'Some Problem in CGIN Claiming');

959:
960: -- end 5989740
961:
962: ELSE
963: FND_FILE.PUT_LINE( FND_FILE.log, 'Some Problem in CGIN Claiming');
964: END IF;
965:
966: -- Other than CGIN cases
967: ELSE

Line 1080: FND_FILE.PUT_LINE( FND_FILE.log, '**** Zero Rounded ****');

1076: );
1077:
1078: DELETE FROM JAI_CMN_RG_ROUND_LINES WHERE rounding_id = v_rounding_id;
1079:
1080: FND_FILE.PUT_LINE( FND_FILE.log, '**** Zero Rounded ****');
1081: GOTO next_exc_inv;
1082: ELSIF v_rounded_amount.total > 0 THEN
1083: v_rounding_entry_type := 'CR';
1084:

Line 1213: FND_FILE.PUT_LINE( FND_FILE.log, v_err_message);

1209: ELSE
1210: v_err_message := 'ERROR: Cenvat CGIN Account is not specified for Location:'||r.location_id;
1211: END IF;
1212:
1213: FND_FILE.PUT_LINE( FND_FILE.log, v_err_message);
1214: RAISE_APPLICATION_ERROR( -20099, v_err_message);
1215: END IF;
1216:
1217: v_statement_no := '5';

Line 1485: FND_FILE.put_line( FND_FILE.log, 'v_full_cgin_case->'||v_full_cgin_case

1481: END IF;
1482:
1483: v_statement_no := '16.1';
1484:
1485: FND_FILE.put_line( FND_FILE.log, 'v_full_cgin_case->'||v_full_cgin_case
1486: ||', cent_cnt->'||r_cgin_chk_for_2nd_claim.cent_percent_cnt
1487: ||', exc_rnd_cnt->'||v_excise_inv_rnd_cnt
1488: );
1489:

Line 1495: FND_FILE.put_line( FND_FILE.log, '1st Rounding of CGIN in Case of 100% CGIN claim');

1491: IF v_full_cgin_case = 'Y' AND r_cgin_chk_for_2nd_claim.cent_percent_cnt > 0
1492: AND v_excise_inv_rnd_cnt=0
1493: THEN
1494:
1495: FND_FILE.put_line( FND_FILE.log, '1st Rounding of CGIN in Case of 100% CGIN claim');
1496: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1497: lv_ttype_correct := 'CORRECT' ;
1498: /* Bug 4930048. Added by Lakshmi Gopalsami
1499: Added proper aliases and changed transaction_source_num

Line 1594: FND_FILE.PUT_LINE( FND_FILE.log, 'Error at statement_no->'|| v_statement_no

1590:
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: v_tot_errored_entries := v_tot_errored_entries + 1;
1594: FND_FILE.PUT_LINE( FND_FILE.log, 'Error at statement_no->'|| v_statement_no
1595: ||', shipment_header_id->'||v_shipment_header_id
1596: ||', excise_invoice_no->'||v_excise_invoice_no
1597: ||', excise_invoice_date->'||v_excise_invoice_date||' '
1598: );

Line 1599: FND_FILE.PUT_LINE( FND_FILE.log, 'ErrMess->'|| SQLERRM);

1595: ||', shipment_header_id->'||v_shipment_header_id
1596: ||', excise_invoice_no->'||v_excise_invoice_no
1597: ||', excise_invoice_date->'||v_excise_invoice_date||' '
1598: );
1599: FND_FILE.PUT_LINE( FND_FILE.log, 'ErrMess->'|| SQLERRM);
1600:
1601: IF v_save_point_set THEN
1602: -- This has to rollback only if SAVEPOINT is set for the exc invoice being processed
1603: ROLLBACK TO previous_savepoint;

Line 1648: FND_FILE.PUT_LINE( FND_FILE.log, 'Completed. Total Rounding entries made -> '|| v_rounding_entries_made

1644: END LOOP;
1645:
1646: END LOOP;
1647:
1648: FND_FILE.PUT_LINE( FND_FILE.log, 'Completed. Total Rounding entries made -> '|| v_rounding_entries_made
1649: ||', errored entries->'||v_tot_errored_entries
1650: ||', Zero Exc. Amt. Invoices found->'||v_zero_round_found
1651: ||', total Ex. Invoices processed->'||v_tot_processed_invoices
1652: );

Line 1775: FND_FILE.put_line(fnd_file.log, '2nd Claim Rounding Register_id is Selected');

1771: if r_get_all_rounding_ids.minimum_rounding_id <> r_get_all_rounding_ids.maximum_rounding_id then
1772:
1773: if r_get_all_rounding_ids.maximum_rounding_id = p_register_id then
1774:
1775: FND_FILE.put_line(fnd_file.log, '2nd Claim Rounding Register_id is Selected');
1776:
1777: OPEN c_2nd_claim_register_id
1778: (r_part_ii_rec.organization_id, r_part_ii_rec.location_id,
1779: r_part_ii_rec.excise_invoice_no, r_part_ii_rec.excise_invoice_date

Line 1788: FND_FILE.put_line(fnd_file.log, '1st Claim Rounding Register_id is Selected');

1784: goto exit_from_function;
1785:
1786: else
1787:
1788: FND_FILE.put_line(fnd_file.log, '1st Claim Rounding Register_id is Selected');
1789:
1790: end if; /* 2nd claim rounding id is selected */
1791:
1792: end if;

Line 1796: FND_FILE.put_line(fnd_file.log, 'Minimum Register_id is Selected');

1792: end if;
1793:
1794: end if; /* excise invoice is of full CGIN items and 2nd Claim is done for some/all lines */
1795:
1796: FND_FILE.put_line(fnd_file.log, 'Minimum Register_id is Selected');
1797: OPEN c_parent_part_ii_rec
1798: (r_part_ii_rec.register_type, r_part_ii_rec.organization_id,
1799: r_part_ii_rec.location_id, r_part_ii_rec.excise_invoice_no, r_part_ii_rec.excise_invoice_date,
1800: r_part_ii_rec.vendor_id,r_part_ii_rec.vendor_site_id,r_part_ii_rec.shipment_header_id);/*bgowrava for forward porting bug#5674376*/

Line 2144: fnd_file.put_line(fnd_file.log, '-1-Start of Procedure');

2140: v_tot_lines_cnt := 0;
2141: v_exc_inv_rnd_counter := 0;
2142:
2143: if gb_debug then
2144: fnd_file.put_line(fnd_file.log, '-1-Start of Procedure');
2145: end if;
2146:
2147: OPEN c_rg_rounding_account(p_organization_id);
2148: FETCH c_rg_rounding_account INTO v_rg_rounding_account_id;

Line 2154: fnd_file.put_line(fnd_file.log, 'ERROR: Rounding Account is not specified at Organization Level');

2150:
2151: v_statement_no := '0.2';
2152:
2153: IF v_rg_rounding_account_id IS NULL THEN
2154: fnd_file.put_line(fnd_file.log, 'ERROR: Rounding Account is not specified at Organization Level');
2155: RAISE_APPLICATION_ERROR( -20099, 'Rounding Account is not specified at Organization Level');
2156: END IF;
2157:
2158: v_statement_no := '0.3';

Line 2176: fnd_file.put_line(fnd_file.log, '0-Before MAIN LOOP');

2172:
2173: v_tot_amount := v_zero_record;
2174:
2175: if gb_debug then
2176: fnd_file.put_line(fnd_file.log, '0-Before MAIN LOOP');
2177: end if;
2178:
2179: -- PART II A, C rounding entries can be posted into one of the Registers A or C
2180: lv_ttype_correct := 'CORRECT' ;

Line 2309: fnd_file.put_line(fnd_file.log, '0-Amts: crBas:'||r.cr_basic_ed

2305:
2306: BEGIN
2307:
2308: if gb_debug then
2309: fnd_file.put_line(fnd_file.log, '0-Amts: crBas:'||r.cr_basic_ed
2310: ||', crAdd:'||r.cr_additional_ed||', crOth:'||r.cr_other_ed
2311: ||', crExcEdu:'||r.cr_exc_edu_cess||', crCvdEdu:'||r.cr_cvd_edu_cess
2312: ||', drBas:'||r.dr_basic_ed
2313: ||', drAdd:'||r.dr_additional_ed||', drOth:'||r.dr_other_ed

Line 2351: fnd_file.put_line(fnd_file.log, '1-Before Update of Register');

2347: SAVEPOINT previous_savepoint;
2348: v_save_point_set := TRUE;
2349:
2350: if gb_debug then
2351: fnd_file.put_line(fnd_file.log, '1-Before Update of Register');
2352: end if;
2353:
2354: if r.register = LV_RG23_REGISTER then
2355: v_statement_no := '1.2';

Line 2394: fnd_file.put_line(fnd_file.log, '+++++ Ex. Invoice Already rounded +++++');

2390: and (jrt.transaction_type = p_transaction_type or
2391: jrt.parent_transaction_type = p_transaction_type) );
2392: end if;
2393:
2394: fnd_file.put_line(fnd_file.log, '+++++ Ex. Invoice Already rounded +++++');
2395: GOTO next_exc_inv;
2396:
2397: END IF;
2398:

Line 2454: fnd_file.put_line(fnd_file.log, 'TrxId:'||line.transaction_id ||', RecvQty->'||ln_receive_qty);

2450: ln_receive_amount.sh_excise_edu_cess, -- Date 16/04/2007 by sacsethi for Bug#5989740
2451: ln_receive_amount.sh_cvd_edu_cess ;
2452: CLOSE c_receipt_tax_amount;
2453:
2454: fnd_file.put_line(fnd_file.log, 'TrxId:'||line.transaction_id ||', RecvQty->'||ln_receive_qty);
2455:
2456: ln_cenvat_amount.basic := ln_receive_amount.basic * line.quantity/ln_receive_qty;
2457: ln_cenvat_amount.additional := ln_receive_amount.additional * line.quantity/ln_receive_qty;
2458: ln_cenvat_amount.additional_cvd := nvl(ln_receive_amount.additional_cvd,0) * line.quantity/ln_receive_qty;/*5228046 Addtional cvd Enhancement*/

Line 2480: fnd_file.put_line(fnd_file.log, '2-Before Insert into Entry Lines');

2476:
2477: v_statement_no := '1.5';
2478:
2479: if gb_debug then
2480: fnd_file.put_line(fnd_file.log, '2-Before Insert into Entry Lines');
2481: end if;
2482:
2483: -- populate item class
2484: INSERT INTO JAI_CMN_RG_ROUND_LINES (ROUNDING_LINE_ID,

Line 2569: fnd_file.put_line(fnd_file.log, '2.1-Amts: tBas:'||v_tot_amount.basic

2565: NVL(v_tot_amount.cvd_edu_cess,0)+
2566: NVL(v_tot_amount.sh_excise_edu_cess,0) + -- Date 16/04/2007 by sacsethi for Bug#5989740
2567: NVL(v_tot_amount.sh_cvd_edu_cess,0);
2568: if gb_debug then
2569: fnd_file.put_line(fnd_file.log, '2.1-Amts: tBas:'||v_tot_amount.basic
2570: ||', tAdd:'||v_tot_amount.additional||', tOth:'||v_tot_amount.other
2571: ||', tAdditional_cvd:'||v_tot_amount.additional_cvd /*5228046 Addtional cvd Enhancement*/
2572: ||', tExcEdu:'||v_tot_amount.excise_edu_cess||', tCvdEdu:'||v_tot_amount.cvd_edu_cess
2573: ||', tAmt:'||v_tot_amount.total

Line 2577: fnd_file.put_line(fnd_file.log, 'Started Processing rtvExcBtchGrpId->'||ln_rtv_excise_batch_group_id

2573: ||', tAmt:'||v_tot_amount.total
2574: );
2575: end if;
2576:
2577: fnd_file.put_line(fnd_file.log, 'Started Processing rtvExcBtchGrpId->'||ln_rtv_excise_batch_group_id
2578: ||', excise_invoice_no->'||v_excise_invoice_no
2579: ||', excise_invoice_date->'||v_excise_invoice_date
2580: );
2581:

Line 2642: fnd_file.put_line(fnd_file.log, '2.2-Amts: rBas:'||v_rounded_amount.basic

2638: + NVL(v_rounded_amount.additional_cvd,0)/*5228046 Additional cvd Enhancement*/
2639: + NVL(v_rounded_amount.other,0);
2640:
2641: if gb_debug then
2642: fnd_file.put_line(fnd_file.log, '2.2-Amts: rBas:'||v_rounded_amount.basic
2643: ||', rAdd:'||v_rounded_amount.additional||', rOth:'||v_rounded_amount.other
2644: ||', rAdd_cvd:'||v_rounded_amount.additional_cvd /*5228046 Additional cvd Enhancement*/
2645: ||', rExcEdu:'||v_rounded_amount.excise_edu_cess||', rCvdEdu:'||v_rounded_amount.cvd_edu_cess
2646: );

Line 2666: fnd_file.put_line(fnd_file.log, '3-Before Update of Register with 0 Rounding');

2662: IF v_rounded_amount_abs = 0 THEN
2663: v_zero_round_found := v_zero_round_found + 1;
2664:
2665: if gb_debug then
2666: fnd_file.put_line(fnd_file.log, '3-Before Update of Register with 0 Rounding');
2667: end if;
2668:
2669: if r.register = LV_RG23_REGISTER then
2670: UPDATE JAI_CMN_RG_23AC_II_TRXS aa

Line 2712: fnd_file.put_line(fnd_file.log, '**** Zero Rounded ****');

2708: end if;
2709:
2710: DELETE FROM JAI_CMN_RG_ROUND_LINES WHERE rounding_id = v_rounding_id;
2711:
2712: fnd_file.put_line(fnd_file.log, '**** Zero Rounded ****');
2713: GOTO next_exc_inv;
2714:
2715: elsif v_rounded_amount.total < 0 then
2716: v_rounding_entry_type := 'CR';

Line 2837: fnd_file.put_line(fnd_file.log, v_err_message);

2833: else
2834: v_err_message := 'ERROR: Cenvat CGIN Account is not specified for Location:'||r.location_id;
2835: end if;
2836:
2837: fnd_file.put_line(fnd_file.log, v_err_message);
2838: RAISE_APPLICATION_ERROR( -20099, v_err_message);
2839: end if;
2840:
2841: v_statement_no := '5';

Line 2873: fnd_file.put_line(fnd_file.log, '4-Before Insert of Rounding Entry into Register:'||r.register );

2869:
2870: v_statement_no := '8.1';
2871:
2872: if gb_debug then
2873: fnd_file.put_line(fnd_file.log, '4-Before Insert of Rounding Entry into Register:'||r.register );
2874: end if;
2875:
2876: if r.register = LV_PLA_REGISTER then
2877:

Line 2979: fnd_file.put_line(fnd_file.log, '5-Before Insert of RG Others.Amts:dr-'||v_dr_amt||',cr-'||v_cr_amt );

2975: -- end 5989740
2976: end if;
2977:
2978: if gb_debug then
2979: fnd_file.put_line(fnd_file.log, '5-Before Insert of RG Others.Amts:dr-'||v_dr_amt||',cr-'||v_cr_amt );
2980: end if;
2981:
2982: IF NVL(v_dr_amt,0) <> 0 OR NVL(v_cr_amt,0) <> 0 THEN
2983: INSERT INTO JAI_CMN_RG_OTHERS (

Line 3026: fnd_file.put_line(fnd_file.log, '6-Before Insert into Rounding Entries. Id:'||v_rounding_id);

3022: jai_cmn_rg_period_bals_pkg.adjust_rounding(v_register_id_part_ii, v_period_balance_id, v_no_of_periods_updated);
3023: end if;
3024:
3025: if gb_debug then
3026: fnd_file.put_line(fnd_file.log, '6-Before Insert into Rounding Entries. Id:'||v_rounding_id);
3027: end if;
3028:
3029: v_statement_no := '11';
3030: INSERT INTO JAI_CMN_RG_ROUND_HDRS(

Line 3064: fnd_file.put_line(fnd_file.log, '7-Pass RG Accnting: Cr-'||v_rounded_cr_amount||', Dr-'||v_rounded_dr_amount);

3060:
3061: v_statement_no := '12';
3062:
3063: if gb_debug then
3064: fnd_file.put_line(fnd_file.log, '7-Pass RG Accnting: Cr-'||v_rounded_cr_amount||', Dr-'||v_rounded_dr_amount);
3065: end if;
3066:
3067: -- 2 (CR, DR) GL Interface related calls has to be coded
3068: -- Modvat Account entries

Line 3176: fnd_file.put_line(fnd_file.log,' 101 exc_rnd_cnt->'||v_excise_inv_rnd_cnt);

3172: end if;
3173:
3174: v_statement_no := '16.1';
3175:
3176: fnd_file.put_line(fnd_file.log,' 101 exc_rnd_cnt->'||v_excise_inv_rnd_cnt);
3177:
3178: if gb_debug then
3179: fnd_file.put_line(fnd_file.log, '8-Punching RoundingId in Register');
3180: end if;

Line 3179: fnd_file.put_line(fnd_file.log, '8-Punching RoundingId in Register');

3175:
3176: fnd_file.put_line(fnd_file.log,' 101 exc_rnd_cnt->'||v_excise_inv_rnd_cnt);
3177:
3178: if gb_debug then
3179: fnd_file.put_line(fnd_file.log, '8-Punching RoundingId in Register');
3180: end if;
3181:
3182: if r.register = LV_RG23_REGISTER then
3183: lv_ttype_correct := 'CORRECT'; /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 3237: fnd_file.put_line(fnd_file.log, '9-After Commit of '||v_commit_interval||' entries');

3233: IF v_no_of_invoices_posted >= v_commit_interval THEN
3234: v_no_of_invoices_posted := 0;
3235: COMMIT;
3236: if gb_debug then
3237: fnd_file.put_line(fnd_file.log, '9-After Commit of '||v_commit_interval||' entries');
3238: end if;
3239:
3240: ELSE
3241: v_no_of_invoices_posted := v_no_of_invoices_posted + 1;

Line 3250: fnd_file.put_line(fnd_file.log, 'Error at statement_no->'|| v_statement_no

3246:
3247: EXCEPTION
3248: WHEN OTHERS THEN
3249: v_tot_errored_entries := v_tot_errored_entries + 1;
3250: fnd_file.put_line(fnd_file.log, 'Error at statement_no->'|| v_statement_no
3251: ||', rtvExcBtchGrpId->'||ln_rtv_excise_batch_group_id
3252: ||', excise_invoice_no->'||v_excise_invoice_no
3253: ||', excise_invoice_date->'||v_excise_invoice_date||' '
3254: );

Line 3255: fnd_file.put_line(fnd_file.log, 'ErrMess->'|| SQLERRM);

3251: ||', rtvExcBtchGrpId->'||ln_rtv_excise_batch_group_id
3252: ||', excise_invoice_no->'||v_excise_invoice_no
3253: ||', excise_invoice_date->'||v_excise_invoice_date||' '
3254: );
3255: fnd_file.put_line(fnd_file.log, 'ErrMess->'|| SQLERRM);
3256:
3257: IF v_save_point_set THEN
3258: -- This has to rollback only if SAVEPOINT is set for the exc invoice being processed
3259: ROLLBACK TO previous_savepoint;

Line 3303: fnd_file.put_line(fnd_file.log, 'Completed. Total Rounding entries made -> '|| v_rounding_entries_made

3299: v_exc_inv_rnd_counter := v_exc_inv_rnd_counter + 1;
3300:
3301: END LOOP;
3302:
3303: fnd_file.put_line(fnd_file.log, 'Completed. Total Rounding entries made -> '|| v_rounding_entries_made
3304: ||', errored entries->'||v_tot_errored_entries
3305: ||', Zero Exc. Amt. Invoices found->'||v_zero_round_found
3306: ||', total Ex. Invoices processed->'||v_tot_processed_invoices
3307: );