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

Line 409: 2 09-MAY-2002 Sriram. Adding fnd_file.put_line -

405: 1 04-MAY-2002 Sriram. Procedure Created . This Procedure will be
406: invoked by the concurrent
407: 'India Local Concurrent Procedure for processing Order Lines to AR' - JAINMREQ .
408: This will be only applicable for Invoiced Created from Order Entry.
409: 2 09-MAY-2002 Sriram. Adding fnd_file.put_line -
410: to write logs from concurrent program.
411: 3 24-May-2002 Sriram. Set the Code so that it works in the batch mode .
412: 4. 09-JAN-2003 Sriram - Bug # 2740546 - File Version is 615.1
413: Added the substr function to the update statement that updates the

Line 643: fnd_file.put_line(FND_FILE.LOG,' Entering Procedure - jai_ar_match_tax_pkg.process_batch');

639: v_org_id := FND_PROFILE.VALUE('ORG_ID');
640: */
641: lv_debug := nvl(p_debug,'N');
642: lv_debug := 'Y';
643: fnd_file.put_line(FND_FILE.LOG,' Entering Procedure - jai_ar_match_tax_pkg.process_batch');
644:
645: ln_org_id := mo_global.get_current_org_id() ; -- Harshita for Bug 5490479
646: /*commented by kunkumar for bug# 6066813 Start
647: 6012570 (5876390) -- Revoked the comments for 6012570*/

Line 660: fnd_file.put_line(FND_FILE.LOG,' Org id retreived is - ' || v_org_id || ' Generate for All orgs is : ' || p_all_orgs);

656: else
657: v_org_id := ln_org_id; -- p_org_id -- Harshita for Bug 5490479
658: end if;
659:
660: fnd_file.put_line(FND_FILE.LOG,' Org id retreived is - ' || v_org_id || ' Generate for All orgs is : ' || p_all_orgs);
661:
662: lv_source := 'RAXTRX';
663: FOR temp_rec IN
664: (

Line 800: fnd_file.put_line(FND_FILE.LOG , 'Error - ' || ' When Processing '||

796:
797:
798: COMMIT;
799:
800: fnd_file.put_line(FND_FILE.LOG , 'Error - ' || ' When Processing '||
801: temp_rec.customer_trx_id );
802: fnd_file.put_line(FND_FILE.LOG , 'Error is ' || var_error_mesg );
803:
804: var_error_invoice := 'Y';

Line 802: fnd_file.put_line(FND_FILE.LOG , 'Error is ' || var_error_mesg );

798: COMMIT;
799:
800: fnd_file.put_line(FND_FILE.LOG , 'Error - ' || ' When Processing '||
801: temp_rec.customer_trx_id );
802: fnd_file.put_line(FND_FILE.LOG , 'Error is ' || var_error_mesg );
803:
804: var_error_invoice := 'Y';
805:
806: END;

Line 814: fnd_file.put_line(FND_FILE.LOG , 'lv_called_from ' || lv_called_from);

810: BEGIN
811:
812: /*Bug 11735678 - Populate VAT Invoice Number into Base AR Reference column only if it is imported from ORDER ENTRY
813: Projects Imported AR Invoices is not within the scope of VAT Invoice Number on AR Invoice ER*/
814: fnd_file.put_line(FND_FILE.LOG , 'lv_called_from ' || lv_called_from);
815: fnd_file.put_line(FND_FILE.LOG , 'lv_projects_flag ' || lv_projects_flag);
816: /*IF (lv_called_from <> gv_projects_invoices and lv_projects_flag = jai_constants.no)
817: THEN*/
818: --Commented by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952

Line 815: fnd_file.put_line(FND_FILE.LOG , 'lv_projects_flag ' || lv_projects_flag);

811:
812: /*Bug 11735678 - Populate VAT Invoice Number into Base AR Reference column only if it is imported from ORDER ENTRY
813: Projects Imported AR Invoices is not within the scope of VAT Invoice Number on AR Invoice ER*/
814: fnd_file.put_line(FND_FILE.LOG , 'lv_called_from ' || lv_called_from);
815: fnd_file.put_line(FND_FILE.LOG , 'lv_projects_flag ' || lv_projects_flag);
816: /*IF (lv_called_from <> gv_projects_invoices and lv_projects_flag = jai_constants.no)
817: THEN*/
818: --Commented by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952
819: --For Porjects Invoices also need to generate service invoice and display on AR Workbench

Line 842: fnd_file.put_line(FND_FILE.LOG,

838: ln_bill_to_site_use_id,ld_trx_date;
839: CLOSE cur_ar_trx_header;
840:
841: lv_doc_type_class := 'I';
842: fnd_file.put_line(FND_FILE.LOG,
843: 'Start Generate Service Tax Invoice Number');
844: jai_cmn_rgm_setup_pkg.gen_invoice_number(
845: p_regime_id => ln_regime_id ,
846: p_organization_id => ln_organization_id ,

Line 857: fnd_file.put_line(FND_FILE.LOG,

853: p_process_msg => lv_process_message
854: );
855: IF lv_process_status = jai_constants.successful THEN
856: IF lv_st_inv_number IS NOT NULL THEN
857: fnd_file.put_line(FND_FILE.LOG,
858: 'Service Tax Invoice Number has been successfully generated.lv_st_inv_number '||lv_st_inv_number);
859: update jai_ar_trxs set st_inv_number = lv_st_inv_number
860: WHERE customer_trx_id = temp_rec.customer_trx_id;
861: ELSE

Line 875: fnd_file.put_line(FND_FILE.LOG,

871:
872: END IF;
873: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 End*/
874:
875: fnd_file.put_line(FND_FILE.LOG,
876: 'Display the VAT/Excise number in AR Transaction workbench');
877:
878: --when there is no error happening in the above process
879: IF nvl(var_error_invoice, 'N') <> 'Y'

Line 932: FND_FILE.put_line(FND_FILE.LOG,

928: END IF;
929:
930: lv_display_flag := FND_PROFILE.VALUE('JAI_DISP_VAT_EXC_INV_AR_TRX_REF');
931:
932: FND_FILE.put_line(FND_FILE.LOG,
933: 'JAI:Include Excise and VAT Invoice Number in AR transactions - Referencde is set to ' ||
934: lv_display_flag);
935:
936: -- when then profile "JAI:Include Excise and VAT Invoice Number

Line 939: FND_FILE.put_line( FND_FILE.LOG

935:
936: -- when then profile "JAI:Include Excise and VAT Invoice Number
937: -- in AR transactions - Referencde" set to "Yes"
938:
939: FND_FILE.put_line( FND_FILE.LOG
940: ,'temp_rec.customer_trx_id :' || temp_rec.customer_trx_id);
941: FND_FILE.put_line( FND_FILE.LOG
942: , 'lv_excise_invoice_no :' ||lv_excise_invoice_no);
943: FND_FILE.put_line( FND_FILE.LOG

Line 941: FND_FILE.put_line( FND_FILE.LOG

937: -- in AR transactions - Referencde" set to "Yes"
938:
939: FND_FILE.put_line( FND_FILE.LOG
940: ,'temp_rec.customer_trx_id :' || temp_rec.customer_trx_id);
941: FND_FILE.put_line( FND_FILE.LOG
942: , 'lv_excise_invoice_no :' ||lv_excise_invoice_no);
943: FND_FILE.put_line( FND_FILE.LOG
944: , 'lv_vat_invoice_no :' || lv_vat_invoice_no);
945:

Line 943: FND_FILE.put_line( FND_FILE.LOG

939: FND_FILE.put_line( FND_FILE.LOG
940: ,'temp_rec.customer_trx_id :' || temp_rec.customer_trx_id);
941: FND_FILE.put_line( FND_FILE.LOG
942: , 'lv_excise_invoice_no :' ||lv_excise_invoice_no);
943: FND_FILE.put_line( FND_FILE.LOG
944: , 'lv_vat_invoice_no :' || lv_vat_invoice_no);
945:
946: -- when the two inovice number has not been generated
947: -- and the profile has been set as "Yes", the default profile value is "No"

Line 958: fnd_file.put_line(FND_FILE.LOG,'The invoice number has been displayed successfully!');

954: display_vat_invoice_no( pn_customer_trx_id => temp_rec.customer_trx_id
955: , pv_excise_invoice_no => lv_excise_invoice_no
956: , pv_vat_invoice_no => lv_vat_invoice_no);
957:
958: fnd_file.put_line(FND_FILE.LOG,'The invoice number has been displayed successfully!');
959: END IF; --lv_excise_invoice_no IS NOT NULL
960:
961: END IF;--nvl(var_error_invoice, 'N') <> 'Y'
962:

Line 979: fnd_file.put_line(FND_FILE.LOG, 'Processed Customer_trx_id - ' ||var_cust_trx_id);

975:
976: -- write here to log the successful processing for last invoice
977:
978: IF var_error_invoice <> 'Y' THEN
979: fnd_file.put_line(FND_FILE.LOG, 'Processed Customer_trx_id - ' ||var_cust_trx_id);
980: END IF;
981:
982: COMMIT;
983: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');

Line 983: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');

979: fnd_file.put_line(FND_FILE.LOG, 'Processed Customer_trx_id - ' ||var_cust_trx_id);
980: END IF;
981:
982: COMMIT;
983: fnd_file.put_line(FND_FILE.LOG,'Successfully Exiting PROCEDURE - jai_ar_match_tax_pkg.process_batch');
984: EXCEPTION
985: WHEN OTHERS THEN
986: ROLLBACK;
987:

Line 1000: Fnd_file.put_line(FND_FILE.LOG,'EXCEPTION Occured - ' || ERRBUF || ' WHILE Processing Customer_trx_id - ' || var_cust_trx_id );

996: var_freight_amount :=0;
997:
998: ERRBUF := SQLERRM;
999: RETCODE := 2;
1000: Fnd_file.put_line(FND_FILE.LOG,'EXCEPTION Occured - ' || ERRBUF || ' WHILE Processing Customer_trx_id - ' || var_cust_trx_id );
1001: END process_batch;
1002:
1003: ------------------------------------------------ ---------------------------------------
1004: --=========================================================================================--

Line 1615: fnd_file.put_line(FND_FILE.LOG, 'Before deleting ar_distributions : p_receivable_appl_id '|| p_receivable_appl_id);

1611: p_process_message OUT NOCOPY VARCHAR2)
1612: IS
1613: BEGIN
1614: IF p_debug = 'Y' THEN
1615: fnd_file.put_line(FND_FILE.LOG, 'Before deleting ar_distributions : p_receivable_appl_id '|| p_receivable_appl_id);
1616: END IF;
1617:
1618: DELETE ar_distributions
1619: where source_id = p_receivable_appl_id

Line 1623: fnd_file.put_line(FND_FILE.LOG, 'Before call to create_Acct_entry: p_customer_trx_id '|| p_customer_trx_id||

1619: where source_id = p_receivable_appl_id
1620: and source_table = 'RA' ;
1621:
1622: IF p_debug = 'Y' THEN
1623: fnd_file.put_line(FND_FILE.LOG, 'Before call to create_Acct_entry: p_customer_trx_id '|| p_customer_trx_id||
1624: ' p_receivable_appl_id '|| p_receivable_appl_id);
1625: END IF;
1626:
1627: arp_acct_main.create_Acct_entry('CREDIT_MEMO',

Line 2183: fnd_file.put_line(FND_FILE.LOG, 'START process_imported_invoice');

2179: v_upd_created_from VARCHAR2(15);
2180: ln_event_id NUMBER; --added for bug#7645588
2181: BEGIN
2182:
2183: fnd_file.put_line(FND_FILE.LOG, 'START process_imported_invoice');
2184:
2185: --Lock all the rows from JAI_AR_TRX_INS_LINES_T for a customer_trx_id, which are to be processed
2186: FOR i IN cur_lock_temp(p_customer_trx_id)
2187: LOOP

Line 2204: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');

2200: --If ln_previous_customer_trx_id is not null, then current transaction is a CM
2201: ln_previous_customer_trx_id := rec_customer_trx.previous_customer_trx_id;
2202:
2203: IF p_debug = 'Y' THEN
2204: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');
2205: END IF;
2206:
2207: --do the basic validations before processing the transaction
2208: jai_ar_validate_data_pkg.pre_validation

Line 2214: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');

2210: p_process_status => lv_process_status,
2211: p_process_message => lv_process_message);
2212:
2213: IF p_debug = 'Y' THEN
2214: fnd_file.put_line(FND_FILE.LOG, 'Before pre_validation');
2215: END IF;
2216:
2217: IF lv_process_status <> jai_constants.successful THEN
2218: p_process_status := lv_process_status;

Line 2254: fnd_file.put_line(FND_FILE.LOG, 'Before delete_trx_data');

2250: FETCH cur_curr_precision INTO ln_precision;
2251: CLOSE cur_curr_precision;
2252:
2253: IF p_debug = 'Y' THEN
2254: fnd_file.put_line(FND_FILE.LOG, 'Before delete_trx_data');
2255: END IF;
2256:
2257: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
2258: --Also deletes the MRC data from ra_cust_trx_line_gl_dist

Line 2264: fnd_file.put_line(FND_FILE.LOG, 'After delete_trx_data');

2260: p_process_status => lv_process_status,
2261: p_process_message => lv_process_message);
2262:
2263: IF p_debug = 'Y' THEN
2264: fnd_file.put_line(FND_FILE.LOG, 'After delete_trx_data');
2265: END IF;
2266:
2267: IF lv_process_status <> jai_constants.successful THEN
2268: p_process_status := lv_process_status;

Line 2304: fnd_file.put_line(FND_FILE.LOG, 'Before cur_temp_lines_insert LOOP');

2300: /* Added by Ramananda for bug#4468353 due to ebtax uptake by AR, end */
2301:
2302:
2303: IF p_debug = 'Y' THEN
2304: fnd_file.put_line(FND_FILE.LOG, 'Before cur_temp_lines_insert LOOP');
2305: END IF;
2306:
2307: FOR rec_temp IN cur_temp_lines_insert(p_customer_trx_id)
2308: LOOP

Line 2366: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - before insert_trx_lines');

2362: ln_taxable_amount := rec_customer_trx_lines.extended_amount;
2363: END IF;
2364:
2365: IF p_debug = 'Y' THEN
2366: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - before insert_trx_lines');
2367: END IF;
2368:
2369:
2370: -- #### IMPORTANT FOR R12

Line 2405: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_lines');

2401: p_process_status => lv_process_status,
2402: p_process_message => lv_process_message);
2403:
2404: IF p_debug = 'Y' THEN
2405: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_lines');
2406: END IF;
2407:
2408: IF lv_process_status <> jai_constants.successful THEN
2409: p_process_status := lv_process_status;

Line 2415: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - before insert_trx_line_gl_dist');

2411: goto EXIT_POINT;
2412: END IF;
2413:
2414: IF p_debug = 'Y' THEN
2415: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - before insert_trx_line_gl_dist');
2416: END IF;
2417:
2418:
2419: --This procedure inserts the data into ra_cust_trx_line_gl_dist_all

Line 2445: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_line_gl_dist');

2441: p_seq_id => ln_gl_seq,
2442: p_event_id => ln_event_id); --added for bug#7645588
2443:
2444: IF p_debug = 'Y' THEN
2445: fnd_file.put_line(FND_FILE.LOG, 'In loop cur_temp_lines_insert - after insert_trx_line_gl_dist');
2446: END IF;
2447:
2448: --added the following IF condition for bug#7645588
2449: --added the OR condition for bug#8276902

Line 2546: fnd_file.put_line(FND_FILE.LOG, 'Before ln_previous_customer_trx_id is not null'||ln_previous_customer_trx_id);

2542: ln_taxable_amount; --this variable is not being used
2543: CLOSE cur_total_amt_trx_lines;
2544:
2545: IF p_debug = 'Y' THEN
2546: fnd_file.put_line(FND_FILE.LOG, 'Before ln_previous_customer_trx_id is not null'||ln_previous_customer_trx_id);
2547: END IF;
2548:
2549: IF ln_previous_customer_trx_id IS NOT NULL THEN --CM
2550:

Line 2586: fnd_file.PUT_LINE(fnd_file.LOG, 'r_period_dtl.closing_status = ' || r_period_dtl.closing_status);

2582: FETCH c_period_dtl
2583: INTO r_period_dtl;
2584: CLOSE c_period_dtl;
2585:
2586: fnd_file.PUT_LINE(fnd_file.LOG, 'r_period_dtl.closing_status = ' || r_period_dtl.closing_status);
2587:
2588: IF r_period_dtl.closing_status IN('O', 'F') THEN
2589: ld_accounting_date(ln_row_count) := lt_gl_date(ln_row_count);
2590:

Line 2611: fnd_file.PUT_LINE(fnd_file.LOG, 'GL Period is closed for Accounting Date:' || to_char(lt_gl_date(ln_row_count)) || '. Hence passing with Entries for ' || to_char(ld_accounting_date(ln_row_count)));

2607: EXIT;
2608: END IF;
2609: END LOOP;
2610:
2611: fnd_file.PUT_LINE(fnd_file.LOG, 'GL Period is closed for Accounting Date:' || to_char(lt_gl_date(ln_row_count)) || '. Hence passing with Entries for ' || to_char(ld_accounting_date(ln_row_count)));
2612:
2613: END IF;
2614:
2615: fnd_file.PUT_LINE(fnd_file.LOG, 'ld_accounting_date(ln_row_count) = ' || ld_accounting_date(ln_row_count));

Line 2615: fnd_file.PUT_LINE(fnd_file.LOG, 'ld_accounting_date(ln_row_count) = ' || ld_accounting_date(ln_row_count));

2611: fnd_file.PUT_LINE(fnd_file.LOG, 'GL Period is closed for Accounting Date:' || to_char(lt_gl_date(ln_row_count)) || '. Hence passing with Entries for ' || to_char(ld_accounting_date(ln_row_count)));
2612:
2613: END IF;
2614:
2615: fnd_file.PUT_LINE(fnd_file.LOG, 'ld_accounting_date(ln_row_count) = ' || ld_accounting_date(ln_row_count));
2616:
2617: /*End additions by mmurtuza for bug 13557242*/
2618:
2619:

Line 2620: fnd_file.put_line(FND_FILE.LOG, 'lt_receipt_id_tab(i) '|| lt_receipt_id_tab(ln_row_count) ||

2616:
2617: /*End additions by mmurtuza for bug 13557242*/
2618:
2619:
2620: fnd_file.put_line(FND_FILE.LOG, 'lt_receipt_id_tab(i) '|| lt_receipt_id_tab(ln_row_count) ||
2621: ' ln_previous_customer_trx_id '|| ln_previous_customer_trx_id ||
2622: ' lt_apply_date(i) '|| lt_apply_date(ln_row_count) ||
2623: ' lt_gl_date(i) '|| lt_gl_date(ln_row_count) );
2624:

Line 2641: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Unapplication');

2637:
2638:
2639: IF (lv_return_status <> 'S')
2640: THEN
2641: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Unapplication');
2642: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);
2643: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);
2644: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);
2645: p_process_status := lv_return_status;

Line 2642: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);

2638:
2639: IF (lv_return_status <> 'S')
2640: THEN
2641: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Unapplication');
2642: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);
2643: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);
2644: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);
2645: p_process_status := lv_return_status;
2646: p_process_message := lv_msg_data;

Line 2643: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);

2639: IF (lv_return_status <> 'S')
2640: THEN
2641: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Unapplication');
2642: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);
2643: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);
2644: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);
2645: p_process_status := lv_return_status;
2646: p_process_message := lv_msg_data;
2647: goto EXIT_POINT;

Line 2644: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);

2640: THEN
2641: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Unapplication');
2642: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);
2643: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);
2644: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);
2645: p_process_status := lv_return_status;
2646: p_process_message := lv_msg_data;
2647: goto EXIT_POINT;
2648: END IF;

Line 2675: fnd_file.put_line(FND_FILE.LOG, 'After INSERT call to maintain_schedules');

2671: goto EXIT_POINT;
2672: END IF;
2673:
2674: IF p_debug = 'Y' THEN
2675: fnd_file.put_line(FND_FILE.LOG, 'After INSERT call to maintain_schedules');
2676: END IF;
2677:
2678: UPDATE ar_payment_schedules_all
2679: SET amount_due_original = ROUND(NVL(amount_line_items_original,0) + ln_total_tax_amt_for_inv + ln_total_frt_amt_for_inv, ln_precision),

Line 2705: fnd_file.put_line(FND_FILE.LOG, 'After UPDATE call to maintain_schedules');

2701: goto EXIT_POINT;
2702: END IF;
2703:
2704: IF p_debug = 'Y' THEN
2705: fnd_file.put_line(FND_FILE.LOG, 'After UPDATE call to maintain_schedules');
2706: END IF;
2707:
2708:
2709: --get the min(payment_schedule_id) and term_id from ar_payment_schedules_all for customer_trx_id

Line 2738: fnd_file.put_line(FND_FILE.LOG, 'Before entering rec_payment LOOP');

2734: ln_frt_amt_cashrcpt;
2735: CLOSE cur_tot_cash_rcpt;
2736:
2737: IF p_debug = 'Y' THEN
2738: fnd_file.put_line(FND_FILE.LOG, 'Before entering rec_payment LOOP');
2739: END IF;
2740:
2741: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
2742: FOR rec_payment in cur_payment_schedule(ln_previous_customer_trx_id)

Line 2745: fnd_file.put_line(FND_FILE.LOG, 'In rec_payment LOOP');

2741: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
2742: FOR rec_payment in cur_payment_schedule(ln_previous_customer_trx_id)
2743: LOOP
2744: IF p_debug = 'Y' THEN
2745: fnd_file.put_line(FND_FILE.LOG, 'In rec_payment LOOP');
2746: END IF;
2747:
2748:
2749: --Get the relative_amount from ra_terms_lines

Line 2756: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_term_lines');

2752: FETCH cur_term_lines INTO ln_relative_amt;
2753: CLOSE cur_term_lines;
2754:
2755: IF p_debug = 'Y' THEN
2756: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_term_lines');
2757: END IF;
2758:
2759: IF rec_term_details.first_installment_code = 'ALLOCATE' THEN
2760: ln_apportion_factor := ln_relative_amt/rec_term_details.base_amount;

Line 2773: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_tot_recv_appl');

2769: FETCH cur_tot_recv_appl INTO ln_line_applied;
2770: CLOSE cur_tot_recv_appl;
2771:
2772: IF p_debug = 'Y' THEN
2773: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_tot_recv_appl');
2774: END IF;
2775:
2776: ln_inst_tax_amt_for_inv := ln_tax_amt_cms * ln_apportion_factor;
2777: ln_inst_frt_amt_for_inv := ln_frt_amt_cms * ln_apportion_factor;

Line 2786: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_trx_types');

2782: FETCH cur_trx_types INTO lv_allow_overappln_flag ;
2783: CLOSE cur_trx_types ;
2784:
2785: IF p_debug = 'Y' THEN
2786: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_trx_types');
2787: END IF;
2788:
2789:
2790: --Get the data from ar_payment_schedules_all for customer_trx_id

Line 2797: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_payment_schedule');

2793: FETCH cur_prev_payment_schedule INTO rec_prev_payment_schedule;
2794: CLOSE cur_prev_payment_schedule;
2795:
2796: IF p_debug = 'Y' THEN
2797: fnd_file.put_line(FND_FILE.LOG, 'after cursor cur_payment_schedule');
2798: END IF;
2799:
2800: ln_amt_due_rem := NVL(rec_prev_payment_schedule.amount_line_items_remaining,0)
2801: + NVL(rec_prev_payment_schedule.tax_original,0)

Line 2809: fnd_file.put_line(FND_FILE.LOG, 'ln_amt_due_--| '||ln_amt_due_rem);

2805: - ln_tax_amt_cashrcpt
2806: - ln_frt_amt_cashrcpt;
2807:
2808: IF p_debug = 'Y' THEN
2809: fnd_file.put_line(FND_FILE.LOG, 'ln_amt_due_--| '||ln_amt_due_rem);
2810: END IF;
2811:
2812: IF ( NVL(lv_allow_overappln_flag,'N') = 'Y' ) OR
2813: ( NVL(lv_allow_overappln_flag,'N') = 'N' AND ln_amt_due_rem >= 0 )

Line 2835: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');

2831: goto EXIT_POINT;
2832: END IF;
2833:
2834: IF p_debug = 'Y' THEN
2835: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');
2836: END IF;
2837:
2838: UPDATE ar_payment_schedules_all
2839: SET amount_due_remaining = ROUND (ln_amt_due_rem ,ln_precision) ,

Line 2850: fnd_file.put_line(FND_FILE.LOG, 'After first update fo ar_payment_schedules_all');

2846: AND payment_schedule_id = rec_payment.payment_schedule_id;
2847:
2848:
2849: IF p_debug = 'Y' THEN
2850: fnd_file.put_line(FND_FILE.LOG, 'After first update fo ar_payment_schedules_all');
2851: END IF;
2852:
2853: UPDATE ar_payment_schedules_all
2854: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),

Line 2862: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');

2858: WHERE customer_trx_id = ln_previous_customer_trx_id
2859: AND payment_schedule_id = rec_payment.payment_schedule_id;
2860:
2861: IF p_debug = 'Y' THEN
2862: fnd_file.put_line(FND_FILE.LOG, 'After second update fo ar_payment_schedules_all');
2863: END IF;
2864:
2865: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits
2866: maintain_schedules( p_customer_trx_id => p_customer_trx_id,

Line 2884: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');

2880: goto EXIT_POINT;
2881: END IF;
2882:
2883: IF p_debug = 'Y' THEN
2884: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_schedules');
2885: END IF;
2886:
2887:
2888: --Get the receivable_application_id from ar_receivable_applications_all for the Invoice's payment_schedule_id

Line 2913: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_applications');

2909: goto EXIT_POINT;
2910: END IF;
2911:
2912: IF p_debug = 'Y' THEN
2913: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_applications');
2914: END IF;
2915:
2916:
2917: UPDATE ar_receivable_applications_all

Line 2942: fnd_file.put_line(FND_FILE.LOG, 'after update of ar_receivable_applications_all');

2938: || Modified by Ramananda for bug#5495711, Ends
2939: */
2940:
2941: IF p_debug = 'Y' THEN
2942: fnd_file.put_line(FND_FILE.LOG, 'after update of ar_receivable_applications_all');
2943: END IF;
2944:
2945: maintain_applications(p_customer_trx_id => p_customer_trx_id,
2946: p_receivable_application_id => ln_recv_appln_id,

Line 2961: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_applications');

2957: goto EXIT_POINT;
2958: END IF;
2959:
2960: IF p_debug = 'Y' THEN
2961: fnd_file.put_line(FND_FILE.LOG, 'after Call to maintain_applications');
2962: END IF;
2963:
2964: --added for bug#8325824, start
2965: IF p_debug = 'Y' THEN

Line 2966: fnd_file.put_line(FND_FILE.LOG, 'before insert into ar_distributions_all');

2962: END IF;
2963:
2964: --added for bug#8325824, start
2965: IF p_debug = 'Y' THEN
2966: fnd_file.put_line(FND_FILE.LOG, 'before insert into ar_distributions_all');
2967: END IF;
2968: insert_ar_dist_entries( p_customer_trx_id => p_customer_trx_id,
2969: p_receivable_appl_id => ln_recv_appln_id,
2970: p_debug => p_debug,

Line 2976: fnd_file.put_line(FND_FILE.LOG, 'after insert into ar_distributions_all');

2972: p_process_message => lv_process_message
2973: );
2974:
2975: IF p_debug = 'Y' THEN
2976: fnd_file.put_line(FND_FILE.LOG, 'after insert into ar_distributions_all');
2977: END IF;
2978:
2979: --bug#8325824, end
2980:

Line 3005: fnd_file.put_line(FND_FILE.LOG, 'lt_receipt_id_tab(i) '|| lt_receipt_id_tab(i) ||

3001: --------------------------------------------------------------------------
3002: -- added by Allen Yang 04-Jun-2010 for bug #9709906, end
3003: FOR i in lt_receipt_id_tab.FIRST..lt_receipt_id_tab.LAST
3004: LOOP
3005: fnd_file.put_line(FND_FILE.LOG, 'lt_receipt_id_tab(i) '|| lt_receipt_id_tab(i) ||
3006: ' ln_previous_customer_trx_id '|| ln_previous_customer_trx_id ||
3007: ' lt_apply_date(i) '|| lt_apply_date(i) ||
3008: ' lt_gl_date(i) '|| lt_gl_date(i) );
3009: AR_RECEIPT_API_PUB.Apply (

Line 3023: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Application');

3019: p_apply_gl_date => ld_accounting_date(i)
3020: );
3021: IF (lv_return_status <> 'S')
3022: THEN
3023: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Application');
3024: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);
3025: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);
3026: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);
3027: p_process_status := lv_return_status;

Line 3024: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);

3020: );
3021: IF (lv_return_status <> 'S')
3022: THEN
3023: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Application');
3024: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);
3025: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);
3026: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);
3027: p_process_status := lv_return_status;
3028: p_process_message := lv_msg_data;

Line 3025: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);

3021: IF (lv_return_status <> 'S')
3022: THEN
3023: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Application');
3024: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);
3025: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);
3026: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);
3027: p_process_status := lv_return_status;
3028: p_process_message := lv_msg_data;
3029: goto EXIT_POINT;

Line 3026: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);

3022: THEN
3023: fnd_file.put_line(FND_FILE.LOG, '>>>>>>>>>> Problems during Receipt Application');
3024: fnd_file.put_line(FND_FILE.LOG, 'lv_return_status : ' || lv_return_status);
3025: fnd_file.put_line(FND_FILE.LOG, 'ln_msg_count : ' || ln_msg_count);
3026: fnd_file.put_line(FND_FILE.LOG, 'lv_msg_data : ' || lv_msg_data);
3027: p_process_status := lv_return_status;
3028: p_process_message := lv_msg_data;
3029: goto EXIT_POINT;
3030: END IF;

Line 3042: fnd_file.put_line(FND_FILE.LOG, 'In else of previous_customer_trx_id');

3038:
3039: ln_payment_audit_id := NULL;
3040:
3041: IF p_debug = 'Y' THEN
3042: fnd_file.put_line(FND_FILE.LOG, 'In else of previous_customer_trx_id');
3043: END IF;
3044:
3045: --Get the first_installment_code and base_amount from ra_terms
3046: OPEN cur_term_details(rec_min_payment_schedule.term_id);

Line 3055: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);

3051: FOR rec_payment in cur_payment_schedule(p_customer_trx_id)
3052: LOOP
3053:
3054: IF p_debug = 'Y' THEN
3055: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);
3056: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);
3057: END IF;
3058:
3059: --Get the relative_amount from ra_terms_lines

Line 3056: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);

3052: LOOP
3053:
3054: IF p_debug = 'Y' THEN
3055: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_payment.payment_schedule_id'||rec_payment.payment_schedule_id);
3056: fnd_file.put_line(FND_FILE.LOG, 'In LOOP cur_payment_schedule - rec_term_details.first_installment_code'||rec_term_details.first_installment_code);
3057: END IF;
3058:
3059: --Get the relative_amount from ra_terms_lines
3060: OPEN cur_term_lines(rec_payment.term_id,

Line 3095: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');

3091: goto EXIT_POINT;
3092: END IF;
3093:
3094: IF p_debug = 'Y' THEN
3095: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');
3096: END IF;
3097:
3098: UPDATE ar_payment_schedules_all
3099: SET amount_due_original = ROUND(NVL(amount_line_items_original,0) + NVL(ln_inst_tax_amt_for_inv,0) + NVL(ln_inst_frt_amt_for_inv,0) , ln_precision),

Line 3111: fnd_file.put_line(FND_FILE.LOG, 'After First update of ar_payment_schedules_all');

3107: WHERE customer_trx_id = p_customer_trx_id
3108: AND payment_schedule_id = rec_payment.payment_schedule_id;
3109:
3110: IF p_debug = 'Y' THEN
3111: fnd_file.put_line(FND_FILE.LOG, 'After First update of ar_payment_schedules_all');
3112: END IF;
3113:
3114: UPDATE ar_payment_schedules_all
3115: SET status = DECODE (amount_due_remaining, 0, 'CL', 'OP'),

Line 3123: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);

3119: WHERE customer_trx_id = p_customer_trx_id
3120: AND payment_schedule_id = rec_payment.payment_schedule_id;
3121:
3122: IF p_debug = 'Y' THEN
3123: fnd_file.put_line(FND_FILE.LOG, 'After Second update of ar_payment_schedules_all '||SQL%ROWCOUNT);
3124: END IF;
3125:
3126:
3127: --This procedure maintains the history of ar_payment_schedules_all in jai_ar_payment_audits

Line 3139: fnd_file.put_line(FND_FILE.LOG, 'Out ln_payment_audit_id '||ln_payment_audit_id);

3135: p_payment_audit_id => ln_payment_audit_id,
3136: p_process_status => lv_process_status,
3137: p_process_message => lv_process_message);
3138:
3139: fnd_file.put_line(FND_FILE.LOG, 'Out ln_payment_audit_id '||ln_payment_audit_id);
3140:
3141: IF lv_process_status <> jai_constants.successful THEN
3142: p_process_status := lv_process_status;
3143: p_process_message := lv_process_message;

Line 3148: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');

3144: goto EXIT_POINT;
3145: END IF;
3146:
3147: IF p_debug = 'Y' THEN
3148: fnd_file.put_line(FND_FILE.LOG, 'After call to maintain_schedules');
3149: END IF;
3150:
3151: IF rec_term_details.first_installment_code <> 'ALLOCATE' THEN
3152: EXIT;

Line 3177: fnd_file.put_line(FND_FILE.LOG,'Resource Busy,record '||p_customer_trx_id||' has been locked by another resource');

3173: NULL;
3174:
3175: EXCEPTION
3176: WHEN resource_busy THEN
3177: fnd_file.put_line(FND_FILE.LOG,'Resource Busy,record '||p_customer_trx_id||' has been locked by another resource');
3178: p_process_message:= ' Resource Busy,record '||p_customer_trx_id||' has been locked by another resource ';
3179: p_process_status := jai_constants.unexpected_error;
3180:
3181: WHEN LOCALIZATION_TAX_NOT_DEFINED THEN

Line 3182: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');

3178: p_process_message:= ' Resource Busy,record '||p_customer_trx_id||' has been locked by another resource ';
3179: p_process_status := jai_constants.unexpected_error;
3180:
3181: WHEN LOCALIZATION_TAX_NOT_DEFINED THEN
3182: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');
3183: p_process_message:= ' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ';
3184: p_process_status := jai_constants.expected_error;
3185:
3186: WHEN ROUNDING_ACCOUNT_NOT_DEFINED THEN

Line 3187: fnd_file.put_line(FND_FILE.LOG, lv_process_message );

3183: p_process_message:= ' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ';
3184: p_process_status := jai_constants.expected_error;
3185:
3186: WHEN ROUNDING_ACCOUNT_NOT_DEFINED THEN
3187: fnd_file.put_line(FND_FILE.LOG, lv_process_message );
3188: p_process_message := lv_process_message;
3189: p_process_status := lv_process_status;
3190:
3191: WHEN OTHERS THEN

Line 3192: fnd_file.put_line(FND_FILE.LOG,sqlerrm);

3188: p_process_message := lv_process_message;
3189: p_process_status := lv_process_status;
3190:
3191: WHEN OTHERS THEN
3192: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
3193: p_process_status := jai_constants.unexpected_error;
3194: p_process_message :=SUBSTR(SQLERRM,1,120);
3195:
3196: UPDATE JAI_AR_TRX_INS_LINES_T

Line 3723: fnd_file.put_line(FND_FILE.LOG, 'Deletion in the RMA Blk...No. of rows deleted '|| v_sql_count);

3719: v_sql_count := SQL%ROWCOUNT;
3720: END IF;
3721: END LOOP;
3722: END IF;
3723: fnd_file.put_line(FND_FILE.LOG, 'Deletion in the RMA Blk...No. of rows deleted '|| v_sql_count);
3724: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice..RMA Blk.. '|| v_trx_num);
3725:
3726: EXCEPTION
3727: WHEN OTHERS THEN

Line 3724: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice..RMA Blk.. '|| v_trx_num);

3720: END IF;
3721: END LOOP;
3722: END IF;
3723: fnd_file.put_line(FND_FILE.LOG, 'Deletion in the RMA Blk...No. of rows deleted '|| v_sql_count);
3724: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice..RMA Blk.. '|| v_trx_num);
3725:
3726: EXCEPTION
3727: WHEN OTHERS THEN
3728: --retcode :=3;

Line 3729: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN FOR RMA. Retcode = '|| retcode);

3725:
3726: EXCEPTION
3727: WHEN OTHERS THEN
3728: --retcode :=3;
3729: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN FOR RMA. Retcode = '|| retcode);
3730: fnd_file.put_line(FND_FILE.LOG, 'ERROR IN PROCESSING ..... ' || SQLERRM);
3731: END; --End block of RMA processing
3732: v_sql_num :=9;
3733:

Line 3730: fnd_file.put_line(FND_FILE.LOG, 'ERROR IN PROCESSING ..... ' || SQLERRM);

3726: EXCEPTION
3727: WHEN OTHERS THEN
3728: --retcode :=3;
3729: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN FOR RMA. Retcode = '|| retcode);
3730: fnd_file.put_line(FND_FILE.LOG, 'ERROR IN PROCESSING ..... ' || SQLERRM);
3731: END; --End block of RMA processing
3732: v_sql_num :=9;
3733:
3734: --start additions for bug#9177024

Line 4182: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));

4178: Acctd_amount_due_remaining = NVL(Acctd_amount_due_remaining,0) + NVL(v_receivable_acctd_amount,0)
4179: Where Customer_Trx_ID = p_customer_trx_id
4180: And Payment_Schedule_ID = v_payment_schedule_id;
4181:
4182: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4183: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4184: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
4185: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
4186: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));

Line 4183: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));

4179: Where Customer_Trx_ID = p_customer_trx_id
4180: And Payment_Schedule_ID = v_payment_schedule_id;
4181:
4182: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4183: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4184: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
4185: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
4186: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
4187: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));

Line 4184: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));

4180: And Payment_Schedule_ID = v_payment_schedule_id;
4181:
4182: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4183: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4184: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
4185: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
4186: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
4187: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
4188: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));

Line 4185: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));

4181:
4182: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4183: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4184: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
4185: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
4186: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
4187: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
4188: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4189:

Line 4186: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));

4182: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 1.......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4183: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4184: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
4185: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
4186: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
4187: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
4188: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4189:
4190: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);

Line 4187: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));

4183: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 1......' || v_trx_num || 'is ' || NVL(v_tax_amount,-111));
4184: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
4185: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
4186: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
4187: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
4188: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4189:
4190: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
4191:

Line 4188: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));

4184: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_freight_amount,-77));
4185: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 1..' || v_trx_num || 'is ' || NVL(v_freight_amount,-66));
4186: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,-222));
4187: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 1...' || v_trx_num || 'is ' || NVL(v_receivable_amount,333));
4188: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4189:
4190: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
4191:
4192: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));

Line 4192: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));

4188: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 1...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4189:
4190: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
4191:
4192: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4193: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4194: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
4195: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
4196: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 2...' || v_trx_num || 'is ' || V_TEMP);

Line 4193: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));

4189:
4190: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
4191:
4192: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4193: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4194: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
4195: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
4196: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 2...' || v_trx_num || 'is ' || V_TEMP);
4197: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);

Line 4194: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));

4190: V_TEMP := NVL(v_old_amount,0) + NVL(v_tax_amt,0);
4191:
4192: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4193: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4194: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
4195: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
4196: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 2...' || v_trx_num || 'is ' || V_TEMP);
4197: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
4198: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));

Line 4195: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));

4191:
4192: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4193: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4194: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
4195: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
4196: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 2...' || v_trx_num || 'is ' || V_TEMP);
4197: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
4198: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4199:

Line 4196: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 2...' || v_trx_num || 'is ' || V_TEMP);

4192: fnd_file.put_line(FND_FILE.LOG, 'TAX ORIGINAL 2.......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4193: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4194: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
4195: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
4196: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 2...' || v_trx_num || 'is ' || V_TEMP);
4197: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
4198: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4199:
4200: end if; --END 22-MAR-02 FOR PROPER UPDATION

Line 4197: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);

4193: fnd_file.put_line(FND_FILE.LOG, 'TAX --|AINING 2......' || v_trx_num || 'is ' || NVL(v_PAYMENT_amt,-111));
4194: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
4195: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
4196: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 2...' || v_trx_num || 'is ' || V_TEMP);
4197: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
4198: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4199:
4200: end if; --END 22-MAR-02 FOR PROPER UPDATION
4201:

Line 4198: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));

4194: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT ORIGINAL 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-77));
4195: fnd_file.put_line(FND_FILE.LOG, 'FREIGHT --|AINING 2...' || v_trx_num || 'is ' || NVL(v_FREIGHT_amt,-66));
4196: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE --|AINING 2...' || v_trx_num || 'is ' || V_TEMP);
4197: fnd_file.put_line(FND_FILE.LOG, 'AMOUNT DUE ORIGINAL 2...' || v_trx_num || 'is ' || V_TEMP);
4198: fnd_file.put_line(FND_FILE.LOG, 'ACCTD AMOUNT DUE 2...' || v_trx_num || 'is ' || NVL(v_receivable_acctd_amount,444));
4199:
4200: end if; --END 22-MAR-02 FOR PROPER UPDATION
4201:
4202: v_sql_num :=33;

Line 4213: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);

4209:
4210:
4211: ERRBUF :=SQLERRM;
4212: -- retcode := 0;
4213: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);
4214: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);
4215: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);
4216: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);
4217:

Line 4214: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);

4210:
4211: ERRBUF :=SQLERRM;
4212: -- retcode := 0;
4213: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);
4214: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);
4215: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);
4216: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);
4217:
4218: EXCEPTION

Line 4215: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);

4211: ERRBUF :=SQLERRM;
4212: -- retcode := 0;
4213: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);
4214: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);
4215: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);
4216: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);
4217:
4218: EXCEPTION
4219: -- retcode := 5;

Line 4216: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);

4212: -- retcode := 0;
4213: fnd_file.put_line(FND_FILE.LOG, 'The total tax amount for the line is....' || v_tax_amt);
4214: fnd_file.put_line(FND_FILE.LOG, 'The receivable amount for the line is....' || v_receivable_amount);
4215: fnd_file.put_line(FND_FILE.LOG, 'Successfully Processed the Invoice... '|| v_trx_num);
4216: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the Invoice Retcode = '|| retcode);
4217:
4218: EXCEPTION
4219: -- retcode := 5;
4220: when others then

Line 4230: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);

4226: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID;
4227:
4228: COMMIT;
4229:
4230: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4231: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
4232: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
4233: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4234: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);

Line 4231: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');

4227:
4228: COMMIT;
4229:
4230: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4231: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
4232: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
4233: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4234: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);
4235:

Line 4232: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);

4228: COMMIT;
4229:
4230: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4231: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
4232: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
4233: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4234: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);
4235:
4236:

Line 4233: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);

4229:
4230: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4231: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
4232: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
4233: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4234: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);
4235:
4236:
4237: END; --End Temp_Cur Block

Line 4234: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);

4230: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4231: fnd_file.put_line(FND_FILE.LOG, 'Updated the customer_trx_id error_flag to ...' || 'R');
4232: fnd_file.put_line(FND_FILE.LOG, 'Unable to Process the invoice... '|| v_trx_num);
4233: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4234: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM || v_sql_num);
4235:
4236:
4237: END; --End Temp_Cur Block
4238:

Line 4261: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );

4257: Freight_Original = NVL(Freight_Original,0) + NVL(v_freight_amount,0),
4258: Amount_Due_Original = NVL(Amount_Due_Original,0) + NVL(v_receivable_amount,0)
4259: Where Customer_Trx_ID = p_customer_trx_id
4260: And Payment_Schedule_ID = v_payment_schedule_id;
4261: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
4262: ELSIF v_return_reference_type_code in ('Invoice India','Sales Order India')
4263: and v_credit_invoice_line_id IS NOT NULL THEN
4264:
4265: Select sum(amount) INTO v_tax_amount1

Line 4317: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);

4313: Acctd_Amount_Due_remaining = NVL(Acctd_Amount_Due_remaining,0) + NVL(v_freight_amount1,0)
4314: Where Customer_Trx_Id = v_prev_customer_trx_id
4315: And Payment_Schedule_Id = v_payment_Schedule_id; --18-apr-2002
4316:
4317: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);
4318: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);
4319: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);
4320: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
4321: END IF;

Line 4318: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);

4314: Where Customer_Trx_Id = v_prev_customer_trx_id
4315: And Payment_Schedule_Id = v_payment_Schedule_id; --18-apr-2002
4316:
4317: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);
4318: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);
4319: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);
4320: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
4321: END IF;
4322:

Line 4319: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);

4315: And Payment_Schedule_Id = v_payment_Schedule_id; --18-apr-2002
4316:
4317: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);
4318: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);
4319: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);
4320: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
4321: END IF;
4322:
4323: END IF;

Line 4320: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );

4316:
4317: fnd_file.put_line(FND_FILE.LOG, 'v_tot_amount = '|| v_tot_amount);
4318: fnd_file.put_line(FND_FILE.LOG, 'v_tax_amount1 = '|| v_tax_amount1);
4319: fnd_file.put_line(FND_FILE.LOG, 'v_freight_amount1 = '|| v_freight_amount1);
4320: fnd_file.put_line(FND_FILE.LOG, ' DEBUG:SPATIAL) checking Tax Details updating updating v_return_reference_type_code ' || v_return_reference_type_code );
4321: END IF;
4322:
4323: END IF;
4324:

Line 4387: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the invoice = '|| v_trx_num);

4383: --------------------------------------------------------------------------
4384: --Added by Bo Li for Bug9803555 on 01-JUL-2010 ,End
4385:
4386: -- retcode := 0;
4387: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the invoice = '|| v_trx_num);
4388: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the customer_trx_id Retcode = '|| retcode);
4389:
4390: EXCEPTION
4391:

Line 4388: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the customer_trx_id Retcode = '|| retcode);

4384: --Added by Bo Li for Bug9803555 on 01-JUL-2010 ,End
4385:
4386: -- retcode := 0;
4387: fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the invoice = '|| v_trx_num);
4388: -- fnd_file.put_line(FND_FILE.LOG, 'COMPLETED RUN.Processed the customer_trx_id Retcode = '|| retcode);
4389:
4390: EXCEPTION
4391:
4392: when Localization_tax_not_defined then

Line 4393: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');

4389:
4390: EXCEPTION
4391:
4392: when Localization_tax_not_defined then
4393: fnd_file.put_line(FND_FILE.LOG,' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ');
4394: errbuf:= ' ''Localization'' Tax not defined or is end-dated. Please ensure that a valid ''Localization'' Tax exists and is not enddated ';
4395: retcode := 2;
4396:
4397: WHEN OTHERS THEN

Line 4404: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);

4400: UPDATE JAI_AR_TRX_INS_LINES_T SET ERROR_FLAG = 'R',ERR_MESG=ERRBUF WHERE CUSTOMER_TRX_ID=P_CUSTOMER_TRX_ID
4401: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID;
4402: COMMIT;
4403: -- retcode := 7;
4404: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4405: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
4406: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4407: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
4408: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');

Line 4405: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);

4401: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID;
4402: COMMIT;
4403: -- retcode := 7;
4404: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4405: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
4406: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4407: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
4408: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');
4409:

Line 4406: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);

4402: COMMIT;
4403: -- retcode := 7;
4404: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4405: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
4406: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4407: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
4408: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');
4409:
4410: END process_manual_invoice;

Line 4407: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);

4403: -- retcode := 7;
4404: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4405: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
4406: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4407: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
4408: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');
4409:
4410: END process_manual_invoice;
4411: -- Start commented by kunkumar for bug#6066813

Line 4408: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');

4404: -- fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN. Retcode = '|| retcode);
4405: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the invoice = '|| v_trx_num);
4406: fnd_file.put_line(FND_FILE.LOG, 'ABORTED RUN... the err = '|| SQLERRM);
4407: fnd_file.put_line(FND_FILE.LOG, 'Main Block.... the err = '|| SQLERRM);
4408: fnd_file.put_line(FND_FILE.LOG, 'Please Contact the System Administrator Or Oracle Software Support Services...');
4409:
4410: END process_manual_invoice;
4411: -- Start commented by kunkumar for bug#6066813
4412: -- following function added for bug#6012570 (5876390) --> revoked the comments, 6012570

Line 5119: FND_FILE.PUT_LINE ( FND_FILE.LOG

5115: , ln_inv_org_id -- organization id of the inventory organization id
5116: );
5117:
5118: ln_total_inclu_tax_amt := ln_total_inclu_tax_amt + inclu_tax_csr.tax_amount;
5119: FND_FILE.PUT_LINE ( FND_FILE.LOG
5120: , 'Insert tax info: '
5121: || 'tax_account_id = ' || ln_tax_account_id
5122: || ' tax_amount = '|| inclu_tax_csr.tax_amount
5123: );

Line 5353: FND_FILE.PUT_LINE ( FND_FILE.LOG

5349: );
5350:
5351: -- ln_total_inclu_tax_amt := ln_total_inclu_tax_amt + inclu_tax_csr.tax_amount;
5352: ln_total_inclu_tax_amt := ln_total_inclu_tax_amt + ln_amount; --Add by Xiao for bug#11936390
5353: FND_FILE.PUT_LINE ( FND_FILE.LOG
5354: , 'Insert tax info: '
5355: || 'tax_account_id = ' || ln_tax_account_id
5356: || ' tax_amount = '|| inclu_tax_csr.tax_amount
5357: );

Line 5431: FND_FILE.PUT_LINE ( FND_FILE.LOG

5427: , pn_customer_trx_id -- value of customer_trx_id
5428: , ln_inv_org_id -- organization id of the inventory organization id
5429: );
5430:
5431: FND_FILE.PUT_LINE ( FND_FILE.LOG
5432: , 'Insert debit info: '
5433: || 'account_id = ' || ln_rec_account_id
5434: || ' amount = '|| ln_total_inclu_tax_amt
5435: );

Line 5542: fnd_file.put_line(FND_FILE.LOG,

5538: FETCH check_reference
5539: INTO lv_reference_check;
5540: CLOSE check_reference;
5541:
5542: fnd_file.put_line(FND_FILE.LOG,
5543: 'The exist reference is: '||lv_reference_check);
5544:
5545: lv_reference := NULL;
5546: