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_RCTLA_TRIGGER_PKG dependencies on FND_FILE

Line 1424: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Function get_legal_entity_id');

1420:
1421: BEGIN
1422: pv_return_code := jai_constants.successful ;
1423:
1424: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Function get_legal_entity_id');
1425:
1426: OPEN cur_legal_entity_id ;
1427: FETCH cur_legal_entity_id INTO ln_legal_entity_id ;
1428: CLOSE cur_legal_entity_id ;

Line 1430: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Legal Entity Id: '|| ln_legal_entity_id);

1426: OPEN cur_legal_entity_id ;
1427: FETCH cur_legal_entity_id INTO ln_legal_entity_id ;
1428: CLOSE cur_legal_entity_id ;
1429:
1430: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Legal Entity Id: '|| ln_legal_entity_id);
1431:
1432: RETURN ln_legal_entity_id ;
1433:
1434: END get_legal_entity_id ;

Line 1486: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');

1482: ln_hdr_exist_chk number;
1483: BEGIN
1484: pv_return_code := jai_constants.successful ;
1485:
1486: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');
1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type); -- Added for bug#6498345 by JMEENA
1488: v_tax_amount :=0;
1489:
1490: open c_item_type;

Line 1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type); -- Added for bug#6498345 by JMEENA

1483: BEGIN
1484: pv_return_code := jai_constants.successful ;
1485:
1486: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');
1487: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type); -- Added for bug#6498345 by JMEENA
1488: v_tax_amount :=0;
1489:
1490: open c_item_type;
1491: fetch c_item_type into v_item_type;

Line 1494: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Item type'|| v_item_type);

1490: open c_item_type;
1491: fetch c_item_type into v_item_type;
1492: close c_item_type;
1493:
1494: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Item type'|| v_item_type);
1495:
1496: if NVL(v_item_type,'$$$') = 'MODEL' then
1497: IF (NVL(pr_new.Interface_line_attribute11,'0') ='0'
1498: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context)) -- added by sriram - bug# 3607101

Line 1510: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Config line id ' || v_config_line_id);

1506: Open c_get_config_line_id(v_interface_line_attribute6, 'CONFIG'); /* Modified by Ramananda for removal of SQL LITERALs */
1507: Fetch c_get_config_line_id into v_config_line_id;
1508: Close c_get_config_line_id;
1509:
1510: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Config line id ' || v_config_line_id);
1511:
1512: -- the variable v_config_line_id holds the line_id of the
1513: -- config item corresponding to the 'Model' item being imported.
1514:

Line 1521: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Type: '|| v_tax_type);

1517: Open c_get_tax_info(so_taxes_rec.tax_id);
1518: Fetch c_get_tax_info into v_tax_type;
1519: close c_get_tax_info;
1520:
1521: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Type: '|| v_tax_type);
1522:
1523: IF V_REGISTER_CODE ='BOND_REG' THEN
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');

Line 1525: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');

1521: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Type: '|| v_tax_type);
1522:
1523: IF V_REGISTER_CODE ='BOND_REG' THEN
1524:
1525: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');
1526: /* jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo Bug#5989740*/
1527: IF v_tax_type NOT IN ('Excise','Other Excise','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS',jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) THEN
1528: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
1529: -- Date 23/02/2006 by sacsethi for bug 5228046

Line 1587: FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');

1583: so_taxes_rec.last_updated_by,
1584: so_taxes_rec.last_update_login
1585: );
1586:
1587: FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');
1588:
1589: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1590:
1591: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);

Line 1591: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);

1587: FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');
1588:
1589: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1590:
1591: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
1592:
1593: end if; -- for 'tax type'
1594: else
1595:

Line 1654: FND_FILE.PUT_LINE(FND_FILE.LOG,

1650: sysdate,
1651: so_taxes_rec.last_updated_by,
1652: so_taxes_rec.last_update_login
1653: );
1654: FND_FILE.PUT_LINE(FND_FILE.LOG,
1655: ' Else - After insert into JAI_AR_TRX_TAX_LINES');
1656: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1657: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax amount: '|| v_tax_amount);
1658:

Line 1657: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax amount: '|| v_tax_amount);

1653: );
1654: FND_FILE.PUT_LINE(FND_FILE.LOG,
1655: ' Else - After insert into JAI_AR_TRX_TAX_LINES');
1656: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1657: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax amount: '|| v_tax_amount);
1658:
1659: end if; -- for 'BOND_REG'
1660: End Loop;
1661:

Line 1669: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);

1665: Open c_so_picking_data(v_config_line_id);
1666: fetch c_so_picking_data into v_ex_inv_no , v_pmt_reg , v_pre_prnt_ex_no , v_ar3_form_no , v_ar3_form_date;
1667: close c_so_picking_data;
1668:
1669: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1670: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1671: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1672: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1673: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);

Line 1670: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);

1666: fetch c_so_picking_data into v_ex_inv_no , v_pmt_reg , v_pre_prnt_ex_no , v_ar3_form_no , v_ar3_form_date;
1667: close c_so_picking_data;
1668:
1669: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1670: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1671: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1672: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1673: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);
1674:

Line 1671: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);

1667: close c_so_picking_data;
1668:
1669: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1670: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1671: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1672: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1673: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);
1674:
1675: /* JMEENA for bug#6391684( FP of 6061010), Starts */

Line 1672: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);

1668:
1669: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1670: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1671: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1672: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1673: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);
1674:
1675: /* JMEENA for bug#6391684( FP of 6061010), Starts */
1676: open duplicate_hdr_cur;

Line 1673: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);

1669: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1670: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1671: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1672: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1673: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);
1674:
1675: /* JMEENA for bug#6391684( FP of 6061010), Starts */
1676: open duplicate_hdr_cur;
1677: fetch duplicate_hdr_cur into ln_hdr_exist_chk;

Line 1685: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ATO: 1. v_organization_id , v_location_id: ' || v_organization_id || ' , ' || v_location_id );

1681: open so_ato_picking_hdr_info(v_config_line_id);
1682: fetch so_ato_picking_hdr_info into v_organization_id , v_location_id;
1683: close so_ato_picking_hdr_info;
1684:
1685: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ATO: 1. v_organization_id , v_location_id: ' || v_organization_id || ' , ' || v_location_id );
1686:
1687: IF v_organization_id IS NULL THEN
1688: open so_picking_hdr_info_1 ;
1689: fetch so_picking_hdr_info_1 into v_organization_id , v_location_id;

Line 1692: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: 2. v_organization_id , v_location_id: ' || v_organization_id || ' , ' || v_location_id );

1688: open so_picking_hdr_info_1 ;
1689: fetch so_picking_hdr_info_1 into v_organization_id , v_location_id;
1690: close so_picking_hdr_info_1;
1691:
1692: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: 2. v_organization_id , v_location_id: ' || v_organization_id || ' , ' || v_location_id );
1693:
1694: END IF ;
1695:
1696: update JAI_AR_TRXS

Line 1710: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);

1706: v_salesrep_id, c_from_currency_code, c_conversion_type,
1707: c_conversion_date, c_conversion_rate ;
1708: CLOSE CREATED_FROM_CUR;
1709:
1710: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1711: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);

Line 1711: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);

1707: c_conversion_date, c_conversion_rate ;
1708: CLOSE CREATED_FROM_CUR;
1709:
1710: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1711: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);

Line 1712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);

1708: CLOSE CREATED_FROM_CUR;
1709:
1710: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1711: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);

Line 1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);

1709:
1710: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1711: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);

Line 1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);

1710: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1711: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1718: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);

Line 1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);

1711: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1718: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1719:

Line 1716: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);

1712: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1718: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1719:
1720: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);

Line 1717: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);

1713: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1718: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1719:
1720: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1721: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;

Line 1718: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);

1714: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1715: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1716: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1717: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1718: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1719:
1720: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1721: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1722: close SO_ATO_PICKING_HDR_INFO;

Line 1724: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);

1720: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1721: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1722: close SO_ATO_PICKING_HDR_INFO;
1723:
1724: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);
1725: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);
1726:
1727: ln_legal_entity_id := get_legal_entity_id ;
1728: /* Added by JMEENA for bug#5684033*/

Line 1725: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);

1721: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1722: close SO_ATO_PICKING_HDR_INFO;
1723:
1724: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);
1725: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);
1726:
1727: ln_legal_entity_id := get_legal_entity_id ;
1728: /* Added by JMEENA for bug#5684033*/
1729: IF v_organization_id IS NULL THEN

Line 1733: FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Org id: '|| v_organization_id);

1729: IF v_organization_id IS NULL THEN
1730: open so_picking_hdr_info_1 ;
1731: fetch so_picking_hdr_info_1 into v_organization_id , v_location_id;
1732: close so_picking_hdr_info_1;
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Org id: '|| v_organization_id);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Loc id: '|| v_location_id);
1735: END IF ;
1736:
1737:

Line 1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Loc id: '|| v_location_id);

1730: open so_picking_hdr_info_1 ;
1731: fetch so_picking_hdr_info_1 into v_organization_id , v_location_id;
1732: close so_picking_hdr_info_1;
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Org id: '|| v_organization_id);
1734: FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Loc id: '|| v_location_id);
1735: END IF ;
1736:
1737:
1738: Insert into JAI_AR_TRXS

Line 1793: FND_FILE.PUT_LINE(FND_FILE.LOG,'After insert into JAI_AR_TRXS ');

1789: 'Y',
1790: ln_legal_entity_id /* rallamse bug#4448789 */
1791: );
1792:
1793: FND_FILE.PUT_LINE(FND_FILE.LOG,'After insert into JAI_AR_TRXS ');
1794: /* Added by JMEENA for bug# 6391684( FP of 6386592), Ends */
1795: end if;
1796: /* JMEENA for bug#6391684( FP of 6061010), Ends */
1797:

Line 1881: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');

1877: so_line_rec.vat_assessable_value,
1878: v_service_type --Added by csahoo for Bug#5879769
1879: );
1880:
1881: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1882: FND_FILE.PUT_LINE(FND_FILE.LOG,
1883: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1884: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);
1885:

Line 1882: FND_FILE.PUT_LINE(FND_FILE.LOG,

1878: v_service_type --Added by csahoo for Bug#5879769
1879: );
1880:
1881: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1882: FND_FILE.PUT_LINE(FND_FILE.LOG,
1883: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1884: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);
1885:
1886: v_ato_line_amount := so_line_rec.line_amount;

Line 1884: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);

1880:
1881: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1882: FND_FILE.PUT_LINE(FND_FILE.LOG,
1883: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1884: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);
1885:
1886: v_ato_line_amount := so_line_rec.line_amount;
1887: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
1888: v_ato_total_amount := NVL(v_ato_total_amount,0) + NVL(so_line_rec.line_amount,0) + NVL(v_ato_tax_amount,0);

Line 1889: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tax amount: '||v_ato_tax_amount);

1885:
1886: v_ato_line_amount := so_line_rec.line_amount;
1887: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
1888: v_ato_total_amount := NVL(v_ato_total_amount,0) + NVL(so_line_rec.line_amount,0) + NVL(v_ato_tax_amount,0);
1889: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tax amount: '||v_ato_tax_amount);
1890: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tot amount: '||v_ato_total_amount);
1891: end loop;
1892:
1893:

Line 1890: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tot amount: '||v_ato_total_amount);

1886: v_ato_line_amount := so_line_rec.line_amount;
1887: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
1888: v_ato_total_amount := NVL(v_ato_total_amount,0) + NVL(so_line_rec.line_amount,0) + NVL(v_ato_tax_amount,0);
1889: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tax amount: '||v_ato_tax_amount);
1890: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tot amount: '||v_ato_total_amount);
1891: end loop;
1892:
1893:
1894: -- creation of record in JAI_AR_TRXS

Line 1902: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);

1898: v_salesrep_id, c_from_currency_code, c_conversion_type,
1899: c_conversion_date, c_conversion_rate ;
1900: CLOSE CREATED_FROM_CUR;
1901:
1902: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1904: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);

Line 1903: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);

1899: c_conversion_date, c_conversion_rate ;
1900: CLOSE CREATED_FROM_CUR;
1901:
1902: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1904: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);

Line 1904: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);

1900: CLOSE CREATED_FROM_CUR;
1901:
1902: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1904: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);

Line 1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);

1901:
1902: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1904: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1909: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);

Line 1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);

1902: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1904: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1909: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);

Line 1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);

1903: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1904: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1909: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1911:

Line 1908: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);

1904: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1909: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1911:
1912: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);

Line 1909: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);

1905: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1909: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1911:
1912: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1913: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;

Line 1910: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);

1906: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1907: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1908: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1909: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1910: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1911:
1912: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1913: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1914: close SO_ATO_PICKING_HDR_INFO;

Line 1916: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);

1912: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1913: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1914: close SO_ATO_PICKING_HDR_INFO;
1915:
1916: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);
1917: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);
1918:
1919: ln_legal_entity_id := get_legal_entity_id ;
1920:

Line 1917: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);

1913: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1914: close SO_ATO_PICKING_HDR_INFO;
1915:
1916: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);
1917: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);
1918:
1919: ln_legal_entity_id := get_legal_entity_id ;
1920:
1921: Insert into JAI_AR_TRXS

Line 1976: FND_FILE.PUT_LINE(FND_FILE.LOG,'After insert into JAI_AR_TRXS ');

1972: 'Y',
1973: ln_legal_entity_id -- rallamse bug#4448789
1974: );
1975:
1976: FND_FILE.PUT_LINE(FND_FILE.LOG,'After insert into JAI_AR_TRXS ');
1977: */ --End bug#6391684( FP of 6386592)
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,
1979: 'End of Procedure Process_Taxes_for_ATO_Order');
1980:

Line 1978: FND_FILE.PUT_LINE(FND_FILE.LOG,

1974: );
1975:
1976: FND_FILE.PUT_LINE(FND_FILE.LOG,'After insert into JAI_AR_TRXS ');
1977: */ --End bug#6391684( FP of 6386592)
1978: FND_FILE.PUT_LINE(FND_FILE.LOG,
1979: 'End of Procedure Process_Taxes_for_ATO_Order');
1980:
1981: end if; -- end if for IF NVL(pr_new.Interface_line_attribute11,'0') ='0'
1982: end if;

Line 2099: FND_FILE.PUT_LINE(FND_FILE.LOG,

2095:
2096: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
2097:
2098: begin
2099: FND_FILE.PUT_LINE(FND_FILE.LOG,
2100: ' Inside Procedure process_bill_only_invoice');
2101:
2102: ln_hdr_exists := 0;
2103: ln_line_amount :=0;

Line 2119: FND_FILE.PUT_LINE(FND_FILE.LOG,' Header exists '|| ln_hdr_exists);

2115: open c_check_hdr_exists;
2116: fetch c_check_hdr_exists into ln_hdr_exists;
2117: close c_check_hdr_exists;
2118:
2119: FND_FILE.PUT_LINE(FND_FILE.LOG,' Header exists '|| ln_hdr_exists);
2120:
2121: if nvl(ln_hdr_exists,0) = 0 then
2122: /*
2123: no record exists in the JAI_AR_TRXS table for the customer trx id ,

Line 2139: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inv orgn id: '|| ln_inv_orgn_id);

2135: else
2136: ln_inv_orgn_id := pr_new.warehouse_id ;
2137: end if;
2138:
2139: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inv orgn id: '|| ln_inv_orgn_id);
2140:
2141: open c_default_location(ln_inv_orgn_id);
2142: fetch c_default_location into ln_default_locn_id;
2143: close c_default_location;

Line 2145: FND_FILE.PUT_LINE(FND_FILE.LOG,' Default location id '|| ln_default_locn_id);

2141: open c_default_location(ln_inv_orgn_id);
2142: fetch c_default_location into ln_default_locn_id;
2143: close c_default_location;
2144:
2145: FND_FILE.PUT_LINE(FND_FILE.LOG,' Default location id '|| ln_default_locn_id);
2146:
2147: if ln_default_locn_id is null then
2148:
2149: /*

Line 2241: FND_FILE.PUT_LINE(FND_FILE.LOG,

2237: NULL ,
2238: ln_legal_entity_id /* rallamse bug#4448789 */
2239: );
2240:
2241: FND_FILE.PUT_LINE(FND_FILE.LOG,
2242: ' After insert into JAI_AR_TRXS - Bill only invoice');
2243: end if;
2244:
2245: /*

Line 2254: FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);

2250:
2251: open c_ont_source_code;
2252: fetch c_ont_source_code into v_ont_source_code;
2253: close c_ont_source_code;
2254: FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);
2255:
2256: v_ont_source_code := ltrim(rtrim(v_ont_source_code));
2257:
2258: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 2258: FND_FILE.PUT_LINE(FND_FILE.LOG,

2254: FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);
2255:
2256: v_ont_source_code := ltrim(rtrim(v_ont_source_code));
2257:
2258: FND_FILE.PUT_LINE(FND_FILE.LOG,
2259: ' Ont source code- after trunc: '|| v_ont_source_code);
2260:
2261: /*
2262: return if it is discount line

Line 2265: FND_FILE.PUT_LINE(FND_FILE.LOG,

2261: /*
2262: return if it is discount line
2263: */
2264: if nvl(pr_new.interface_line_attribute11,'0') <> '0' then
2265: FND_FILE.PUT_LINE(FND_FILE.LOG,
2266: ' Int. line att1: '||pr_new.interface_line_attribute11);
2267: return;
2268: end if;
2269:

Line 2272: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');

2268: end if;
2269:
2270: for tax_rec in JA_SO_TAX_LINES_INFO
2271: Loop
2272: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');
2273: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
2274:
2275: if v_register_code = 'BOND_REG' then
2276: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);

Line 2273: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);

2269:
2270: for tax_rec in JA_SO_TAX_LINES_INFO
2271: Loop
2272: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');
2273: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
2274:
2275: if v_register_code = 'BOND_REG' then
2276: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
2277: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then

Line 2276: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);

2272: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');
2273: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
2274:
2275: if v_register_code = 'BOND_REG' then
2276: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
2277: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then
2278: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
2279: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
2280: /*

Line 2598: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');

2594: open c_get_amounts;
2595: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
2596: close c_get_amounts;
2597:
2598: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
2599: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
2600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
2601:
2602: update JAI_AR_TRXS

Line 2599: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);

2595: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
2596: close c_get_amounts;
2597:
2598: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
2599: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
2600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
2601:
2602: update JAI_AR_TRXS
2603: set tax_amount = ln_tax_amount ,

Line 2600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);

2596: close c_get_amounts;
2597:
2598: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
2599: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
2600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
2601:
2602: update JAI_AR_TRXS
2603: set tax_amount = ln_tax_amount ,
2604: line_amount = ln_line_amount,

Line 2966: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '||v_org_id);

2962:
2963: --2001/05/03 Gadde,Jagdish
2964:
2965: /****************************** Validation 1 ********************************/
2966: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '||v_org_id);
2967:
2968: /* Bug 5243532. Added by Lakshmi Gopalsami
2969: Removed the reference to cursor Fetch_Book_Id_Cur
2970: and used the values assigned in trigger to get

Line 2975: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id '|| v_gl_set_of_bks_id);

2971: the value of SOB.
2972: */
2973: v_gl_set_of_bks_id := pr_new.set_of_books_id;
2974:
2975: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id '|| v_gl_set_of_bks_id);
2976:
2977: --If jai_cmn_utils_pkg.check_jai_exists(P_CALLING_OBJECT => 'JA_IN_OE_AR_LINES_INSERT_TRG', P_ORG_ID => pr_new.org_id) = false then
2978: -- return;
2979: --end if;

Line 3016: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );

3012: j_location_id ,
3013: j_batch_source_id;
3014: CLOSE get_header_info_cur;
3015:
3016: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
3017: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
3018: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
3019: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);
3020:

Line 3017: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);

3013: j_batch_source_id;
3014: CLOSE get_header_info_cur;
3015:
3016: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
3017: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
3018: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
3019: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);
3020:
3021: /* The following code has been added by SRIRAM -- BUG # 3021588 CALL TO jai_cmn_bond_register_pkg INSTEAD */

Line 3018: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);

3014: CLOSE get_header_info_cur;
3015:
3016: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
3017: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
3018: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
3019: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);
3020:
3021: /* The following code has been added by SRIRAM -- BUG # 3021588 CALL TO jai_cmn_bond_register_pkg INSTEAD */
3022:

Line 3019: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);

3015:
3016: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
3017: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
3018: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
3019: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);
3020:
3021: /* The following code has been added by SRIRAM -- BUG # 3021588 CALL TO jai_cmn_bond_register_pkg INSTEAD */
3022:
3023: jai_cmn_bond_register_pkg.get_register_id(

Line 3037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);

3033: OPEN transaction_type_cur;
3034: FETCH transaction_type_cur INTO v_trans_type;
3035: CLOSE transaction_type_cur;
3036:
3037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
3038: FND_FILE.PUT_LINE(FND_FILE.LOG,
3039: ' Interface line attribute1 '||pr_new.interface_line_attribute1);
3040: FND_FILE.PUT_LINE(FND_FILE.LOG,
3041: ' Interface line context '|| pr_new.interface_line_context);

Line 3038: FND_FILE.PUT_LINE(FND_FILE.LOG,

3034: FETCH transaction_type_cur INTO v_trans_type;
3035: CLOSE transaction_type_cur;
3036:
3037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
3038: FND_FILE.PUT_LINE(FND_FILE.LOG,
3039: ' Interface line attribute1 '||pr_new.interface_line_attribute1);
3040: FND_FILE.PUT_LINE(FND_FILE.LOG,
3041: ' Interface line context '|| pr_new.interface_line_context);
3042:

Line 3040: FND_FILE.PUT_LINE(FND_FILE.LOG,

3036:
3037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
3038: FND_FILE.PUT_LINE(FND_FILE.LOG,
3039: ' Interface line attribute1 '||pr_new.interface_line_attribute1);
3040: FND_FILE.PUT_LINE(FND_FILE.LOG,
3041: ' Interface line context '|| pr_new.interface_line_context);
3042:
3043: IF ( v_trans_type = 'CM'
3044: AND pr_new.interface_line_attribute1 = 'SUPPLEMENT CM' -- pr_new.interface_line_context, Bug 4392001

Line 3085: FND_FILE.PUT_LINE(FND_FILE.LOG,

3081: OPEN once_complete_flag_cur;
3082: FETCH once_complete_flag_cur INTO v_once_completed_flag;
3083: CLOSE once_complete_flag_cur;
3084:
3085: FND_FILE.PUT_LINE(FND_FILE.LOG,
3086: ' Once completed flag '|| v_once_completed_flag);
3087:
3088:
3089: IF NVL(v_once_completed_flag,'N') = 'Y' THEN

Line 3109: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Exchange rate '|| v_exchange_rate);

3105: OPEN get_exchange_rate;
3106: FETCH get_exchange_rate INTO v_exchange_rate;
3107: CLOSE get_exchange_rate;
3108:
3109: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Exchange rate '|| v_exchange_rate);
3110:
3111: OPEN duplicate_hdr_cur;
3112: FETCH duplicate_hdr_cur INTO x;
3113: CLOSE duplicate_hdr_cur;

Line 3117: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line att4 is null');

3113: CLOSE duplicate_hdr_cur;
3114:
3115: -- IF pr_new.interface_line_attribute1 IS NULL THEN -- Commented By BRATHOD Bug 4392001
3116: IF pr_new.interface_line_attribute4 IS NULL THEN -- Added by BRATHOD, Big# 4392001
3117: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line att4 is null');
3118:
3119: OPEN supplement_lines_check_cnsldt;
3120: FETCH supplement_lines_check_cnsldt INTO v_exist_flag;
3121: CLOSE supplement_lines_check_cnsldt;

Line 3125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line att4 is not null');

3121: CLOSE supplement_lines_check_cnsldt;
3122:
3123: -- ELSIF pr_new.interface_line_attribute1 IS NOT NULL THEN -- Commented By BRATHOD Bug 4392001
3124: ELSIF pr_new.interface_line_attribute4 IS NOT NULL THEN -- Added By BRATHOD Bug 4392001
3125: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line att4 is not null');
3126: OPEN supplement_lines_check;
3127: FETCH supplement_lines_check INTO v_exist_flag;
3128: CLOSE supplement_lines_check;
3129: END IF;

Line 3131: FND_FILE.PUT_LINE(FND_FILE.LOG,

3127: FETCH supplement_lines_check INTO v_exist_flag;
3128: CLOSE supplement_lines_check;
3129: END IF;
3130:
3131: FND_FILE.PUT_LINE(FND_FILE.LOG,
3132: ' Supplement lines check exists flag'|| v_exist_flag);
3133: IF NVL(v_exist_flag,0) <> 1 THEN
3134: return;
3135: END IF;

Line 3192: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside x <> 1: After insert into JAI_AR_TRXS');

3188: v_last_updated_by ,
3189: v_last_update_login ,
3190: ln_legal_entity_id /* rallamse bug#4448789 */
3191: );
3192: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside x <> 1: After insert into JAI_AR_TRXS');
3193: END IF;
3194:
3195: IF pr_new.interface_line_attribute4 IS NULL THEN -- pr_new.interface_line_attribute1, Bug# 4392001
3196: OPEN supplement_tax_lines_check_cns;

Line 3281: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);

3277: v_bill_to_site_use_id , /*Bug 8371741*/
3278: v_trx_number ,
3279: v_batch_source_id;
3280:
3281: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3282: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id); /*Bug 8371741*/
3283: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3284: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);
3285:

Line 3282: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id); /Bug 8371741/

3278: v_trx_number ,
3279: v_batch_source_id;
3280:
3281: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3282: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id); /*Bug 8371741*/
3283: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3284: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);
3285:
3286: CLOSE get_header_details;

Line 3283: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);

3279: v_batch_source_id;
3280:
3281: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3282: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id); /*Bug 8371741*/
3283: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3284: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);
3285:
3286: CLOSE get_header_details;
3287: OPEN get_site(v_trx_number);

Line 3284: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);

3280:
3281: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3282: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id); /*Bug 8371741*/
3283: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3284: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);
3285:
3286: CLOSE get_header_details;
3287: OPEN get_site(v_trx_number);
3288: FETCH get_site INTO v_bill_to_site_use_id; /*Bug 8371741*/

Line 3367: FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is null');

3363:
3364: /**************** End of If Loop pr_new.interface_line_attribute1 IS NULL **********/
3365:
3366: IF pr_new.interface_line_attribute4 IS NULL THEN -- new.interface_line_attribute1, Bug# 4392001
3367: FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is null');
3368:
3369: OPEN supplement_lines_info_cnsldt;
3370: FETCH supplement_lines_info_cnsldt INTO v_tax_amount,
3371: v_excise_diff,

Line 3375: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);

3371: v_excise_diff,
3372: v_assessable_value;
3373: CLOSE supplement_lines_info_cnsldt;
3374:
3375: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3376: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3377: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3378:
3379: OPEN supplement_lines_info_tax_catg;

Line 3376: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);

3372: v_assessable_value;
3373: CLOSE supplement_lines_info_cnsldt;
3374:
3375: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3376: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3377: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3378:
3379: OPEN supplement_lines_info_tax_catg;
3380: FETCH supplement_lines_info_tax_catg INTO v_tax_category_id;

Line 3377: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);

3373: CLOSE supplement_lines_info_cnsldt;
3374:
3375: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3376: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3377: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3378:
3379: OPEN supplement_lines_info_tax_catg;
3380: FETCH supplement_lines_info_tax_catg INTO v_tax_category_id;
3381: CLOSE supplement_lines_info_tax_catg;

Line 3383: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);

3379: OPEN supplement_lines_info_tax_catg;
3380: FETCH supplement_lines_info_tax_catg INTO v_tax_category_id;
3381: CLOSE supplement_lines_info_tax_catg;
3382:
3383: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3384:
3385: ELSIF pr_new.INTERFACE_LINE_ATTRIBUTE4 IS NOT NULL THEN -- pr_new.interface_line_attribute1, Bug# 4392001
3386: FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is not null');
3387: OPEN supplement_lines_info;

Line 3386: FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is not null');

3382:
3383: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3384:
3385: ELSIF pr_new.INTERFACE_LINE_ATTRIBUTE4 IS NOT NULL THEN -- pr_new.interface_line_attribute1, Bug# 4392001
3386: FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is not null');
3387: OPEN supplement_lines_info;
3388: FETCH supplement_lines_info INTO v_tax_category_id,
3389: v_tax_amount ,
3390: v_excise_diff ,

Line 3393: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);

3389: v_tax_amount ,
3390: v_excise_diff ,
3391: v_assessable_value;
3392: CLOSE supplement_lines_info;
3393: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3394: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3395: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3396: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3397:

Line 3394: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);

3390: v_excise_diff ,
3391: v_assessable_value;
3392: CLOSE supplement_lines_info;
3393: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3394: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3395: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3396: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3397:
3398: END IF;

Line 3395: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);

3391: v_assessable_value;
3392: CLOSE supplement_lines_info;
3393: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3394: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3395: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3396: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3397:
3398: END IF;
3399:

Line 3396: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);

3392: CLOSE supplement_lines_info;
3393: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3394: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3395: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3396: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3397:
3398: END IF;
3399:
3400:

Line 3470: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code: '||v_reg_code);

3466: IF NVL(v_excise_diff ,0) > 0 THEN
3467:
3468: IF NVL(v_reg_code,'N') IN ('DOMESTIC_EXCISE','EXPORT_EXCISE') THEN
3469:
3470: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code: '||v_reg_code);
3471:
3472:
3473: OPEN pref_cur(v_organization_id, v_location_id);
3474: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla;

Line 3477: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);

3473: OPEN pref_cur(v_organization_id, v_location_id);
3474: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla;
3475: CLOSE pref_cur;
3476:
3477: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3478: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3479: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);
3480:
3481: OPEN rg_bal_cur(v_organization_id, v_location_id);

Line 3478: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);

3474: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla;
3475: CLOSE pref_cur;
3476:
3477: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3478: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3479: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);
3480:
3481: OPEN rg_bal_cur(v_organization_id, v_location_id);
3482: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;

Line 3479: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);

3475: CLOSE pref_cur;
3476:
3477: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3478: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3479: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);
3480:
3481: OPEN rg_bal_cur(v_organization_id, v_location_id);
3482: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;
3483: CLOSE rg_bal_cur;

Line 3485: FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);

3481: OPEN rg_bal_cur(v_organization_id, v_location_id);
3482: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;
3483: CLOSE rg_bal_cur;
3484:
3485: FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3486: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3487: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);
3488:
3489:

Line 3486: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);

3482: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;
3483: CLOSE rg_bal_cur;
3484:
3485: FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3486: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3487: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);
3488:
3489:
3490: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);

Line 3487: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);

3483: CLOSE rg_bal_cur;
3484:
3485: FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3486: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3487: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);
3488:
3489:
3490: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);
3491: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;

Line 3494: FND_FILE.PUT_LINE(FND_FILE.LOG,' SSI unit flag'||v_ssi_unit_flag);

3490: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);
3491: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;
3492: CLOSE ssi_unit_flag_cur;
3493:
3494: FND_FILE.PUT_LINE(FND_FILE.LOG,' SSI unit flag'||v_ssi_unit_flag);
3495:
3496: IF v_pref_rg23a = 1 THEN --5
3497: IF v_rg23a_balance >= NVL(v_excise_diff,0) THEN --6
3498: v_reg_type := 'RG23A';

Line 3582: FND_FILE.PUT_LINE(FND_FILE.LOG,' Meaning'|| v_meaning);

3578: OPEN register_code_meaning_cur(v_reg_code, 'REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs */
3579: FETCH register_code_meaning_cur INTO v_meaning;
3580: CLOSE register_code_meaning_cur;
3581:
3582: FND_FILE.PUT_LINE(FND_FILE.LOG,' Meaning'|| v_meaning);
3583:
3584: OPEN fin_year_cur(v_organization_id);
3585: FETCH fin_year_cur INTO v_fin_year;
3586: CLOSE fin_year_cur;

Line 3588: FND_FILE.PUT_LINE(FND_FILE.LOG,' Fin year '|| v_fin_year);

3584: OPEN fin_year_cur(v_organization_id);
3585: FETCH fin_year_cur INTO v_fin_year;
3586: CLOSE fin_year_cur;
3587:
3588: FND_FILE.PUT_LINE(FND_FILE.LOG,' Fin year '|| v_fin_year);
3589:
3590: OPEN Batch_Source_Name_Cur(v_batch_source_id);
3591: FETCH Batch_Source_Name_Cur INTO v_order_invoice_type;
3592: CLOSE Batch_Source_Name_Cur;

Line 3594: FND_FILE.PUT_LINE(FND_FILE.LOG,' Order invoice type: '|| v_order_invoice_type);

3590: OPEN Batch_Source_Name_Cur(v_batch_source_id);
3591: FETCH Batch_Source_Name_Cur INTO v_order_invoice_type;
3592: CLOSE Batch_Source_Name_Cur;
3593:
3594: FND_FILE.PUT_LINE(FND_FILE.LOG,' Order invoice type: '|| v_order_invoice_type);
3595:
3596: OPEN Def_Excise_Invoice_Cur(v_organization_id, v_location_id, v_fin_year, v_order_invoice_type, v_meaning);
3597: FETCH Def_Excise_Invoice_Cur INTO v_start_number, v_end_number, v_jump_by, v_prefix;
3598: CLOSE Def_Excise_Invoice_Cur;

Line 3600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);

3596: OPEN Def_Excise_Invoice_Cur(v_organization_id, v_location_id, v_fin_year, v_order_invoice_type, v_meaning);
3597: FETCH Def_Excise_Invoice_Cur INTO v_start_number, v_end_number, v_jump_by, v_prefix;
3598: CLOSE Def_Excise_Invoice_Cur;
3599:
3600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
3601: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
3602: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
3603: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);
3604:

Line 3601: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);

3597: FETCH Def_Excise_Invoice_Cur INTO v_start_number, v_end_number, v_jump_by, v_prefix;
3598: CLOSE Def_Excise_Invoice_Cur;
3599:
3600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
3601: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
3602: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
3603: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);
3604:
3605:

Line 3602: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);

3598: CLOSE Def_Excise_Invoice_Cur;
3599:
3600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
3601: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
3602: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
3603: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);
3604:
3605:
3606: IF v_start_number IS NOT NULL THEN --2

Line 3603: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);

3599:
3600: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
3601: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
3602: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
3603: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);
3604:
3605:
3606: IF v_start_number IS NOT NULL THEN --2
3607: IF NVL(v_start_number,0) >= NVL(v_end_number,0) AND v_end_number IS NOT NULL THEN

Line 3811: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );

3807:
3808: OPEN so_picking_hdr_info;
3809: FETCH so_picking_hdr_info INTO v_organization_id, v_location_id;
3810: CLOSE so_picking_hdr_info;
3811: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
3812:
3813: /* Added by JMEENA for bug#5684033 */
3814: IF v_organization_id IS NULL THEN
3815: OPEN so_picking_hdr_info_1;

Line 3819: FND_FILE.PUT_LINE(FND_FILE.LOG,'From Cursor so_picking_hdr_info_1: v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );

3815: OPEN so_picking_hdr_info_1;
3816: FETCH so_picking_hdr_info_1 INTO v_organization_id, v_location_id;
3817: CLOSE so_picking_hdr_info_1;
3818:
3819: FND_FILE.PUT_LINE(FND_FILE.LOG,'From Cursor so_picking_hdr_info_1: v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
3820: END IF ;
3821:
3822: /* Added by JMEENA for bug#6498345 ( FP 6492966), Starts */
3823: IF v_organization_id IS NULL THEN

Line 3835: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO Header Info: v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );

3831: fetch c_ato_hdr_info into v_organization_id, v_location_id;
3832: close c_ato_hdr_info;
3833: END IF ;
3834:
3835: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO Header Info: v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
3836: END IF ;
3837: /* Added for bug#6498345( FP 6492966), Ends */
3838:
3839: /*Added by qinglei for bug#13405359 on 27-Dec-2011 begin*/

Line 3846: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor so_non_ship_picking_info : v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );

3842: FETCH so_non_ship_picking_info INTO v_organization_id, v_location_id;
3843: CLOSE so_non_ship_picking_info;
3844: /*Added by qinglei for bug#13405359 on 27-Dec-2011 end*/
3845:
3846: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor so_non_ship_picking_info : v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
3847: END IF;
3848: /* This cursor moved here from above for bug#6391684 (FP of 6386592) */
3849: OPEN duplicate_hdr_cur;
3850: FETCH duplicate_hdr_cur INTO x;

Line 4241: fnd_file.put_line(FND_FILE.LOG,

4237: OPEN c_so_lines_exists ;
4238: FETCH c_so_lines_exists INTO lv_exists;
4239: IF c_so_lines_exists%NOTFOUND THEN
4240: CLOSE c_so_lines_exists;
4241: fnd_file.put_line(FND_FILE.LOG,
4242: 'no lines in jai_om_oe_so_lines -return');
4243: return;
4244: END IF;
4245: CLOSE c_so_lines_exists;

Line 4253: fnd_file.put_line(FND_FILE.LOG, ' Line cnt: '|| v_line_count);

4249: OPEN duplicate_lines_cur;
4250: FETCH duplicate_lines_cur INTO v_line_count;
4251: CLOSE duplicate_lines_cur;
4252:
4253: fnd_file.put_line(FND_FILE.LOG, ' Line cnt: '|| v_line_count);
4254:
4255: IF NVL(v_line_count,0) <> 1 THEN
4256: -- the following If Condition added by Sriram - 27/06/2002 - Bug # 2398198
4257: -- Here trying to conditionally update Ja_in_ra_customer_trx_table

Line 4268: fnd_file.put_line(FND_FILE.LOG, ' int. line att1 = 0 ');

4264: (nvl(v_ont_source_code,'ORDER ENTRY') <> nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$') -- added by sriram - bug# 3607101
4265: )
4266: then
4267:
4268: fnd_file.put_line(FND_FILE.LOG, ' int. line att1 = 0 ');
4269: v_calc_tax_amount := v_tax_amount * v_qty;
4270: OPEN c_cust_trx_tax_line_amt;
4271: FETCH c_cust_trx_tax_line_amt into v_calc_tax_amount;
4272: CLOSE c_cust_trx_tax_line_amt;

Line 4392: fnd_file.put_line(FND_FILE.LOG, ' Excise amount: '|| v_excise_amount);

4388: END IF; /* END IF OF IF NVL(v_line_count,0) <> 1 */
4389:
4390: v_excise_amount := round(nvl(v_basic_excise_duty_amount,0) + nvl(v_add_excise_duty_amount,0) + nvl(v_oth_excise_duty_amount,0));
4391:
4392: fnd_file.put_line(FND_FILE.LOG, ' Excise amount: '|| v_excise_amount);
4393:
4394: OPEN complete_flag_cur;
4395: FETCH complete_flag_cur INTO v_once_completed_flag;
4396: CLOSE complete_flag_cur;

Line 4398: fnd_file.put_line(FND_FILE.LOG, ' Once complete flag'|| v_once_completed_flag);

4394: OPEN complete_flag_cur;
4395: FETCH complete_flag_cur INTO v_once_completed_flag;
4396: CLOSE complete_flag_cur;
4397:
4398: fnd_file.put_line(FND_FILE.LOG, ' Once complete flag'|| v_once_completed_flag);
4399:
4400: v_so_tax_amount := v_tax_amount * v_qty ;
4401:
4402: /*Bug # 2316589*/

Line 4415: fnd_file.put_line(FND_FILE.LOG, ' so tax amount: '|| v_so_tax_amount);

4411: OPEN c_cust_trx_tax_line_amt;
4412: FETCH c_cust_trx_tax_line_amt into v_so_tax_amount;
4413: CLOSE c_cust_trx_tax_line_amt;
4414:
4415: fnd_file.put_line(FND_FILE.LOG, ' so tax amount: '|| v_so_tax_amount);
4416:
4417: -- bug # 3000550 sriram
4418: IF (NVL(pr_new.Interface_line_attribute11,'0') ='0'
4419: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context)) -- added by sriram - bug# 3607101

Line 4829: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Procedure process_bill_only_return');

4825:
4826: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
4827:
4828: begin
4829: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Procedure process_bill_only_return');
4830: ln_hdr_exists := 0;
4831: ln_line_amount :=0;
4832: ln_tax_amount :=0;
4833: /*

Line 4847: FND_FILE.PUT_LINE(FND_FILE.LOG,' Header exists '|| ln_hdr_exists);

4843: open c_check_hdr_exists;
4844: fetch c_check_hdr_exists into ln_hdr_exists;
4845: close c_check_hdr_exists;
4846:
4847: FND_FILE.PUT_LINE(FND_FILE.LOG,' Header exists '|| ln_hdr_exists);
4848:
4849: if nvl(ln_hdr_exists,0) = 0 then
4850: /*
4851: no record exists in the JAI_AR_TRXS table for the customer trx id ,

Line 4867: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inv orgn id: '|| ln_inv_orgn_id);

4863: else
4864: ln_inv_orgn_id := pr_new.warehouse_id ;
4865: end if;
4866:
4867: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inv orgn id: '|| ln_inv_orgn_id);
4868:
4869: open c_default_location(ln_inv_orgn_id);
4870: fetch c_default_location into ln_default_locn_id;
4871: close c_default_location;

Line 4873: FND_FILE.PUT_LINE(FND_FILE.LOG,' Default location id '|| ln_default_locn_id);

4869: open c_default_location(ln_inv_orgn_id);
4870: fetch c_default_location into ln_default_locn_id;
4871: close c_default_location;
4872:
4873: FND_FILE.PUT_LINE(FND_FILE.LOG,' Default location id '|| ln_default_locn_id);
4874:
4875: if ln_default_locn_id is null then
4876:
4877: /*

Line 4965: FND_FILE.PUT_LINE(FND_FILE.LOG,

4961: 'N' ,
4962: NULL ,
4963: ln_legal_entity_id /* rallamse bug#4448789 */
4964: );
4965: FND_FILE.PUT_LINE(FND_FILE.LOG,
4966: ' After insert into JAI_AR_TRXS - Bill only invoice');
4967: end if;
4968:
4969: /*

Line 4978: FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);

4974:
4975: open c_ont_source_code;
4976: fetch c_ont_source_code into v_ont_source_code;
4977: close c_ont_source_code;
4978: FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);
4979:
4980: v_ont_source_code := ltrim(rtrim(v_ont_source_code));
4981:
4982: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 4982: FND_FILE.PUT_LINE(FND_FILE.LOG,

4978: FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);
4979:
4980: v_ont_source_code := ltrim(rtrim(v_ont_source_code));
4981:
4982: FND_FILE.PUT_LINE(FND_FILE.LOG,
4983: ' Ont source code- after trunc: '|| v_ont_source_code);
4984:
4985: /*
4986: return if it is discount line

Line 4989: FND_FILE.PUT_LINE(FND_FILE.LOG,

4985: /*
4986: return if it is discount line
4987: */
4988: if nvl(pr_new.interface_line_attribute11,'0') <> '0' then
4989: FND_FILE.PUT_LINE(FND_FILE.LOG,
4990: ' Int. line att1: '||pr_new.interface_line_attribute11);
4991: return;
4992: end if;
4993:

Line 4996: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor SO_RMA_TAX_LINES_INFO');

4992: end if;
4993:
4994: for tax_rec in SO_RMA_TAX_LINES_INFO
4995: Loop
4996: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor SO_RMA_TAX_LINES_INFO');
4997: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
4998:
4999: if lv_register_code = 'BOND_REG' then
5000: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| lv_register_code);

Line 4997: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);

4993:
4994: for tax_rec in SO_RMA_TAX_LINES_INFO
4995: Loop
4996: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor SO_RMA_TAX_LINES_INFO');
4997: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
4998:
4999: if lv_register_code = 'BOND_REG' then
5000: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| lv_register_code);
5001: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then

Line 5000: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| lv_register_code);

4996: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor SO_RMA_TAX_LINES_INFO');
4997: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
4998:
4999: if lv_register_code = 'BOND_REG' then
5000: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| lv_register_code);
5001: if upper(tax_rec.tax_type) not in ('EXCISE','OTHER EXCISE','CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS', jai_constants.tax_type_sh_cvd_edu_cess, jai_constants.tax_type_sh_exc_edu_cess) then
5002: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
5003: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
5004: /*

Line 5297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');

5293: open c_get_amounts;
5294: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
5295: close c_get_amounts;
5296:
5297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
5298: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
5299: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
5300:
5301: update JAI_AR_TRXS

Line 5298: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);

5294: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
5295: close c_get_amounts;
5296:
5297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
5298: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
5299: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
5300:
5301: update JAI_AR_TRXS
5302: set tax_amount = nvl(ln_tax_amount,0) ,

Line 5299: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);

5295: close c_get_amounts;
5296:
5297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
5298: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
5299: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
5300:
5301: update JAI_AR_TRXS
5302: set tax_amount = nvl(ln_tax_amount,0) ,
5303: line_amount = nvl(ln_line_amount,0),

Line 5499: fnd_file.put_line(FND_FILE.LOG, ' RMA record chk:'|| v_exist_flag);

5495: OPEN SO_RMA_RECORD_CHECK;
5496: FETCH SO_RMA_RECORD_CHECK INTO v_exist_flag;
5497: CLOSE SO_RMA_RECORD_CHECK;
5498:
5499: fnd_file.put_line(FND_FILE.LOG, ' RMA record chk:'|| v_exist_flag);
5500:
5501: IF NVL(v_exist_flag,0) <> 1 THEN
5502: RETURN;
5503: END IF;

Line 5533: fnd_file.put_line(fnd_file.log,' before billonly return cursor '|| ln_bill_return);

5529: */
5530:
5531: /*start of changes by abezgam for bug # 10176878
5532: to handle the bill only return orders*/
5533: fnd_file.put_line(fnd_file.log,' before billonly return cursor '|| ln_bill_return);
5534: ln_bill_return := 0;
5535: open c_bill_only_invoice(pr_new.customer_trx_line_id, 'R_RMA_FOR_CREDIT_WO_SHIPMENT');
5536: fetch c_bill_only_invoice into ln_bill_return;
5537: close c_bill_only_invoice;

Line 5538: fnd_file.put_line(fnd_file.log,' after billonly return cursor '|| ln_bill_return);

5534: ln_bill_return := 0;
5535: open c_bill_only_invoice(pr_new.customer_trx_line_id, 'R_RMA_FOR_CREDIT_WO_SHIPMENT');
5536: fetch c_bill_only_invoice into ln_bill_return;
5537: close c_bill_only_invoice;
5538: fnd_file.put_line(fnd_file.log,' after billonly return cursor '|| ln_bill_return);
5539: if ln_bill_return = 1 then
5540: process_bill_only_return; --calling the procedure process_bill_only_return
5541: return;
5542: end if;