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 740: FND_FILE.PUT_LINE( FND_FILE.log, 'TrxId:'||line.transaction_id ||', RecvQty->'||ln_receive_qty);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1793: end if;
1794:
1795: end if; /* excise invoice is of full CGIN items and 2nd Claim is done for some/all lines */
1796:
1797: FND_FILE.put_line(fnd_file.log, 'Minimum Register_id is Selected');
1798: OPEN c_parent_part_ii_rec
1799: (r_part_ii_rec.register_type, r_part_ii_rec.organization_id,
1800: r_part_ii_rec.location_id, r_part_ii_rec.excise_invoice_no, r_part_ii_rec.excise_invoice_date,
1801: 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 2145: fnd_file.put_line(fnd_file.log, '-1-Start of Procedure');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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