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_RETRO_PRC_PKG dependencies on JAI_RCV_TRANSACTIONS

Line 738: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE

734: --
735: -- 14-JAN-2008 Eric Ma created
736: --==========================================================================
737: Function Get_Jai_Rcv_Trans_Record
738: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
739: )
740: RETURN jai_rcv_transactions%ROWTYPE
741: IS
742:

Line 740: RETURN jai_rcv_transactions%ROWTYPE

736: --==========================================================================
737: Function Get_Jai_Rcv_Trans_Record
738: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
739: )
740: RETURN jai_rcv_transactions%ROWTYPE
741: IS
742:
743: CURSOR get_jai_rcv_transactions_cur
744: IS

Line 743: CURSOR get_jai_rcv_transactions_cur

739: )
740: RETURN jai_rcv_transactions%ROWTYPE
741: IS
742:
743: CURSOR get_jai_rcv_transactions_cur
744: IS
745: SELECT
746: *
747: FROM

Line 748: jai_rcv_transactions

744: IS
745: SELECT
746: *
747: FROM
748: jai_rcv_transactions
749: WHERE transaction_id = pn_transaction_id;
750:
751:
752: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

Line 752: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

748: jai_rcv_transactions
749: WHERE transaction_id = pn_transaction_id;
750:
751:
752: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
753:
754: lv_procedure_name VARCHAR2(40):='Get_Jai_Rcv_Trans_Record';
755: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
756: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 768: OPEN get_jai_rcv_transactions_cur;

764: , 'Enter procedure'
765: );
766: END IF; --l_proc_level>=l_dbg_level
767:
768: OPEN get_jai_rcv_transactions_cur;
769: FETCH get_jai_rcv_transactions_cur
770: INTO jai_rcv_transactions_rec;
771: CLOSE get_jai_rcv_transactions_cur;
772:

Line 769: FETCH get_jai_rcv_transactions_cur

765: );
766: END IF; --l_proc_level>=l_dbg_level
767:
768: OPEN get_jai_rcv_transactions_cur;
769: FETCH get_jai_rcv_transactions_cur
770: INTO jai_rcv_transactions_rec;
771: CLOSE get_jai_rcv_transactions_cur;
772:
773: --logging for debug

Line 770: INTO jai_rcv_transactions_rec;

766: END IF; --l_proc_level>=l_dbg_level
767:
768: OPEN get_jai_rcv_transactions_cur;
769: FETCH get_jai_rcv_transactions_cur
770: INTO jai_rcv_transactions_rec;
771: CLOSE get_jai_rcv_transactions_cur;
772:
773: --logging for debug
774: IF (ln_proc_level >= ln_dbg_level)

Line 771: CLOSE get_jai_rcv_transactions_cur;

767:
768: OPEN get_jai_rcv_transactions_cur;
769: FETCH get_jai_rcv_transactions_cur
770: INTO jai_rcv_transactions_rec;
771: CLOSE get_jai_rcv_transactions_cur;
772:
773: --logging for debug
774: IF (ln_proc_level >= ln_dbg_level)
775: THEN

Line 781: RETURN jai_rcv_transactions_rec;

777: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
778: , 'Exit procedure'
779: );
780: END IF; -- (ln_proc_level>=ln_dbg_level)
781: RETURN jai_rcv_transactions_rec;
782: EXCEPTION
783: WHEN OTHERS THEN
784: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
785: THEN

Line 815: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE

811: --
812: -- 14-JAN-2008 Eric Ma created
813: --==========================================================================
814: Function Get_Jai_Rcv_Lines_Record
815: ( pn_transaction_id jai_rcv_transactions.transaction_id%TYPE
816: )
817: RETURN jai_rcv_lines%ROWTYPE
818: IS
819:

Line 925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;

921: WHERE
922: organization_id = pn_organization_id;
923:
924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
928: ln_expense_account mtl_parameters.expense_account%TYPE;
929: lv_process_message VARCHAR2(500);

Line 926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;

922: organization_id = pn_organization_id;
923:
924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
928: ln_expense_account mtl_parameters.expense_account%TYPE;
929: lv_process_message VARCHAR2(500);
930: lv_process_status VARCHAR2(500);

Line 927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;

923:
924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
928: ln_expense_account mtl_parameters.expense_account%TYPE;
929: lv_process_message VARCHAR2(500);
930: lv_process_status VARCHAR2(500);
931: lv_code_path VARCHAR2(500);

Line 2254: jai_rcv_transactions

2250: IS
2251: SELECT
2252: *
2253: FROM
2254: jai_rcv_transactions
2255: WHERE
2256: transaction_id = pn_transaction_id;
2257:
2258: CURSOR get_rcv_cenvat_claim_cur

Line 2324: --Get the record from jai_rcv_transactions for the current transaction_id

2320: RETURN;
2321: END IF;
2322:
2323:
2324: --Get the record from jai_rcv_transactions for the current transaction_id
2325: OPEN get_jai_transaction_cur;
2326: FETCH get_jai_transaction_cur
2327: INTO jai_transaction_rec;
2328: CLOSE get_jai_transaction_cur;

Line 2342: END IF;--(jai_rcv_transactions.organization_type = 'T')

2338: THEN --Trading
2339: lv_tax_breakup_type := 'RG23D';
2340: ELSE -- manufacturing and others
2341: lv_tax_breakup_type := 'MODVAT';
2342: END IF;--(jai_rcv_transactions.organization_type = 'T')
2343:
2344: --Call the following procedure to get the tax amounts by tax types
2345: Get_Tax_Amount_Breakup
2346: ( pn_shipment_line_id => pn_shipment_line_id

Line 2589: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;

2585: , pv_supp_vat_inv_date IN VARCHAR2 DEFAULT NULL
2586: , pv_process_downward IN VARCHAR2 DEFAULT NULL
2587: )
2588: IS
2589: jai_rcv_transactions_rec jai_rcv_transactions%ROWTYPE;
2590: jai_rcv_lines_rec jai_rcv_lines%ROWTYPE;
2591:
2592: ln_skip_rcpt_cnt NUMBER := NULL;
2593: lv_profile_setting VARCHAR2(255);

Line 2800: jai_rcv_transactions_rec := Get_Jai_Rcv_Trans_Record(rcv_transactions_rec.transaction_id);

2796: , pn_line_change_id => jai_retro_line_change_rec.line_change_id
2797: )
2798: LOOP
2799: ln_tot_receipt_no := ln_tot_receipt_no +1;
2800: jai_rcv_transactions_rec := Get_Jai_Rcv_Trans_Record(rcv_transactions_rec.transaction_id);
2801: jai_rcv_lines_rec := Get_Jai_Rcv_Lines_Record(rcv_transactions_rec.transaction_id);
2802:
2803: BEGIN
2804: FND_FILE.PUT_LINE(fnd_file.log, ' ');

Line 2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);

2806: FND_FILE.PUT_LINE(fnd_file.log, ' LOOP through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL

Line 2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);

2807: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Header id is : ' ||jai_rcv_lines_rec.shipment_header_id);
2808: FND_FILE.PUT_LINE(fnd_file.log, ' Shipment Line id is : ' ||jai_rcv_lines_rec.shipment_line_id);
2809: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Number is : ' ||jai_rcv_lines_rec.receipt_num );
2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'

Line 2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL

2810: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt Vat status is : ' ||jai_rcv_transactions_rec.process_vat_status);
2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL

Line 2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'

2811: FND_FILE.PUT_LINE(fnd_file.log, ' Receipt CenVat status is : ' ||jai_rcv_transactions_rec.cenvat_rg_status);
2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

Line 2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'

2812: FND_FILE.PUT_LINE(fnd_file.log, '');
2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

Line 2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'

2813: END;
2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

Line 2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL

2814: IF ( jai_rcv_transactions_rec.process_vat_status IS NULL
2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2822: )

Line 2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

2815: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2822: )
2823: THEN

Line 2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

2816: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2822: )
2823: THEN
2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before

Line 2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

2817: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2818: OR jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2819: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2820: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2821: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2822: )
2823: THEN
2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2825: -- JAI Retroactive price Update is Run

Line 2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL

2822: )
2823: THEN
2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2825: -- JAI Retroactive price Update is Run
2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2830: )

Line 2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'

2823: THEN
2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2825: -- JAI Retroactive price Update is Run
2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2830: )
2831: THEN

Line 2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'

2824: -- Print a message stating that the Receipt is not claimed and it should be claimed before
2825: -- JAI Retroactive price Update is Run
2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2830: )
2831: THEN
2832: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');

Line 2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'

2825: -- JAI Retroactive price Update is Run
2826: IF( jai_rcv_transactions_rec.process_vat_status IS NULL
2827: OR jai_rcv_transactions_rec.process_vat_status = 'P'
2828: OR jai_rcv_transactions_rec.process_vat_status = 'N'
2829: OR jai_rcv_transactions_rec.process_vat_status = 'EE'
2830: )
2831: THEN
2832: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2833: END IF;

Line 2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL

2831: THEN
2832: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2833: END IF;
2834:
2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2839: )

Line 2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'

2832: FND_FILE.PUT_LINE(fnd_file.log, ' Vat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2833: END IF;
2834:
2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2839: )
2840: THEN

Line 2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'

2833: END IF;
2834:
2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2839: )
2840: THEN
2841: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');

Line 2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'

2834:
2835: IF( jai_rcv_transactions_rec.cenvat_rg_status IS NULL
2836: OR jai_rcv_transactions_rec.cenvat_rg_status = 'P'
2837: OR jai_rcv_transactions_rec.cenvat_rg_status = 'N'
2838: OR jai_rcv_transactions_rec.cenvat_rg_status = 'EE'
2839: )
2840: THEN
2841: FND_FILE.PUT_LINE(fnd_file.log, ' Cenvat tax on the receipt :'||jai_rcv_lines_rec.receipt_num||' is not claimed.');
2842: END IF;

Line 3013: , p_line_uom => jai_rcv_transactions_rec.uom_code

3009: ln_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value
3010: ( p_vendor_id => rcv_transactions_rec.vendor_id
3011: , p_vendor_site_id => rcv_transactions_rec.vendor_site_id
3012: , p_inv_item_id => jai_rcv_lines_rec.inventory_item_id
3013: , p_line_uom => jai_rcv_transactions_rec.uom_code
3014: );
3015:
3016: IF (ln_proc_level >= ln_dbg_level)
3017: THEN

Line 3038: , p_uom_code => jai_rcv_transactions_rec.uom_code

3034: ln_vat_assess_value := jai_general_pkg.ja_in_vat_assessable_value
3035: ( p_party_id => rcv_transactions_rec.vendor_id
3036: , p_party_site_id => rcv_transactions_rec.vendor_site_id
3037: , p_inventory_item_id => jai_rcv_lines_rec.inventory_item_id
3038: , p_uom_code => jai_rcv_transactions_rec.uom_code
3039: , p_default_price => jai_retro_line_change_rec.modified_unit_price
3040: , p_ass_value_date => trunc(sysdate)
3041: , p_party_type => 'V'
3042: );

Line 3064: , p_line_uom_code => jai_rcv_transactions_rec.uom_code -- Receipt UOM code

3060: , P_line_id => jai_rcv_lines_rec.shipment_line_id -- Receipt Shipment line Id
3061: , p_line_loc_id => -999
3062: , p_line_quantity => rcv_transactions_rec.quantity -- receipt Quantity
3063: , p_price => ln_recv_line_amount -- Receipt line Amount
3064: , p_line_uom_code => jai_rcv_transactions_rec.uom_code -- Receipt UOM code
3065: , p_tax_amount => ln_recv_tax_amount -- Receipt line Amount ( IN Out parameter that gives the total tax amount and takes line amount as Input)
3066: , p_assessable_value => ln_assessable_value -- Excise Assesable value
3067: , p_vat_assess_value => ln_vat_assess_value -- VAT Assessable value
3068: , p_item_id => jai_rcv_lines_rec.inventory_item_id -- Inventory item id

Line 3209: END IF; -- IF ( jai_rcv_transactions_rec.process_vat_status IS NULL )

3205: END IF; --(lv_vat_action <> 'UNCLAIMED' AND ln_vat_amount <> 0)
3206:
3207: --Increaset the total processed receipt number;
3208: ln_receipt_processed_no :=ln_receipt_processed_no+1;
3209: END IF; -- IF ( jai_rcv_transactions_rec.process_vat_status IS NULL )
3210:
3211: FND_FILE.PUT_LINE(fnd_file.log, ' The Receipt :'||jai_rcv_lines_rec.receipt_num||' processing is done.');
3212: FND_FILE.PUT_LINE(fnd_file.log, ' End loop through the RECEIVE transactions,Transaction id is : ' ||rcv_transactions_rec.transaction_id);
3213: FND_FILE.PUT_LINE(fnd_file.log, ' ++');