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 1339: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Function get_legal_entity_id');

1335:
1336: BEGIN
1337: pv_return_code := jai_constants.successful ;
1338:
1339: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Function get_legal_entity_id');
1340:
1341: OPEN cur_legal_entity_id ;
1342: FETCH cur_legal_entity_id INTO ln_legal_entity_id ;
1343: CLOSE cur_legal_entity_id ;

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

1341: OPEN cur_legal_entity_id ;
1342: FETCH cur_legal_entity_id INTO ln_legal_entity_id ;
1343: CLOSE cur_legal_entity_id ;
1344:
1345: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Legal Entity Id: '|| ln_legal_entity_id);
1346:
1347: RETURN ln_legal_entity_id ;
1348:
1349: END get_legal_entity_id ;

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

1396:
1397: BEGIN
1398: pv_return_code := jai_constants.successful ;
1399:
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');
1401: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type); -- Added for bug#6498345 by JMEENA
1402: v_tax_amount :=0;
1403:
1404: open c_item_type;

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

1397: BEGIN
1398: pv_return_code := jai_constants.successful ;
1399:
1400: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');
1401: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type); -- Added for bug#6498345 by JMEENA
1402: v_tax_amount :=0;
1403:
1404: open c_item_type;
1405: fetch c_item_type into v_item_type;

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

1404: open c_item_type;
1405: fetch c_item_type into v_item_type;
1406: close c_item_type;
1407:
1408: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Item type'|| v_item_type);
1409:
1410: if NVL(v_item_type,'$$$') = 'MODEL' then
1411: IF (NVL(pr_new.Interface_line_attribute11,'0') ='0'
1412: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context)) -- added by sriram - bug# 3607101

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

1420: Open c_get_config_line_id(v_interface_line_attribute6, 'CONFIG'); /* Modified by Ramananda for removal of SQL LITERALs */
1421: Fetch c_get_config_line_id into v_config_line_id;
1422: Close c_get_config_line_id;
1423:
1424: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Config line id ' || v_config_line_id);
1425:
1426: -- the variable v_config_line_id holds the line_id of the
1427: -- config item corresponding to the 'Model' item being imported.
1428:

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

1431: Open c_get_tax_info(so_taxes_rec.tax_id);
1432: Fetch c_get_tax_info into v_tax_type;
1433: close c_get_tax_info;
1434:
1435: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Type: '|| v_tax_type);
1436:
1437: IF V_REGISTER_CODE ='BOND_REG' THEN
1438:
1439: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');

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

1435: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Type: '|| v_tax_type);
1436:
1437: IF V_REGISTER_CODE ='BOND_REG' THEN
1438:
1439: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');
1440: /* jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo Bug#5989740*/
1441: 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
1442: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
1443: -- Date 23/02/2006 by sacsethi for bug 5228046

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

1497: so_taxes_rec.last_updated_by,
1498: so_taxes_rec.last_update_login
1499: );
1500:
1501: FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');
1502:
1503: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1504:
1505: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);

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

1501: FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');
1502:
1503: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1504:
1505: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
1506:
1507: end if; -- for 'tax type'
1508: else
1509:

Line 1568: FND_FILE.PUT_LINE(FND_FILE.LOG,

1564: sysdate,
1565: so_taxes_rec.last_updated_by,
1566: so_taxes_rec.last_update_login
1567: );
1568: FND_FILE.PUT_LINE(FND_FILE.LOG,
1569: ' Else - After insert into JAI_AR_TRX_TAX_LINES');
1570: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1571: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax amount: '|| v_tax_amount);
1572:

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

1567: );
1568: FND_FILE.PUT_LINE(FND_FILE.LOG,
1569: ' Else - After insert into JAI_AR_TRX_TAX_LINES');
1570: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1571: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax amount: '|| v_tax_amount);
1572:
1573: end if; -- for 'BOND_REG'
1574: End Loop;
1575:

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

1579: Open c_so_picking_data(v_config_line_id);
1580: 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;
1581: close c_so_picking_data;
1582:
1583: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1584: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1585: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1586: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1587: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);

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

1580: 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;
1581: close c_so_picking_data;
1582:
1583: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1584: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1585: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1586: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1587: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);
1588:

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

1581: close c_so_picking_data;
1582:
1583: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1584: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1585: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1586: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1587: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);
1588:
1589: /*added by csahoo for bug#5879769*/

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

1582:
1583: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1584: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1585: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1586: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1587: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);
1588:
1589: /*added by csahoo for bug#5879769*/
1590: OPEN c_get_address_details(v_header_id);

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

1583: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1584: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1585: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1586: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1587: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);
1588:
1589: /*added by csahoo for bug#5879769*/
1590: OPEN c_get_address_details(v_header_id);
1591: FETCH c_get_address_details into r_add;

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

1668: so_line_rec.vat_assessable_value,
1669: v_service_type --Added by csahoo for Bug#5879769
1670: );
1671:
1672: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1673: FND_FILE.PUT_LINE(FND_FILE.LOG,
1674: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1675: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);
1676:

Line 1673: FND_FILE.PUT_LINE(FND_FILE.LOG,

1669: v_service_type --Added by csahoo for Bug#5879769
1670: );
1671:
1672: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1673: FND_FILE.PUT_LINE(FND_FILE.LOG,
1674: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1675: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);
1676:
1677: v_ato_line_amount := so_line_rec.line_amount;

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

1671:
1672: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1673: FND_FILE.PUT_LINE(FND_FILE.LOG,
1674: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1675: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);
1676:
1677: v_ato_line_amount := so_line_rec.line_amount;
1678: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
1679: v_ato_total_amount := NVL(v_ato_total_amount,0) + NVL(so_line_rec.line_amount,0) + NVL(v_ato_tax_amount,0);

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

1676:
1677: v_ato_line_amount := so_line_rec.line_amount;
1678: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
1679: v_ato_total_amount := NVL(v_ato_total_amount,0) + NVL(so_line_rec.line_amount,0) + NVL(v_ato_tax_amount,0);
1680: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tax amount: '||v_ato_tax_amount);
1681: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tot amount: '||v_ato_total_amount);
1682: end loop;
1683:
1684:

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

1677: v_ato_line_amount := so_line_rec.line_amount;
1678: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
1679: v_ato_total_amount := NVL(v_ato_total_amount,0) + NVL(so_line_rec.line_amount,0) + NVL(v_ato_tax_amount,0);
1680: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tax amount: '||v_ato_tax_amount);
1681: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tot amount: '||v_ato_total_amount);
1682: end loop;
1683:
1684:
1685: -- creation of record in JAI_AR_TRXS

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

1689: v_salesrep_id, c_from_currency_code, c_conversion_type,
1690: c_conversion_date, c_conversion_rate ;
1691: CLOSE CREATED_FROM_CUR;
1692:
1693: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);

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

1690: c_conversion_date, c_conversion_rate ;
1691: CLOSE CREATED_FROM_CUR;
1692:
1693: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);

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

1691: CLOSE CREATED_FROM_CUR;
1692:
1693: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1699: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);

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

1692:
1693: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1699: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);

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

1693: FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1699: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1701: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);

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

1694: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1695: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1699: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1701: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1702:

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

1695: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1699: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1701: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1702:
1703: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);

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

1696: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1699: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1701: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1702:
1703: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1704: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;

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

1697: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1699: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1701: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);
1702:
1703: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1704: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1705: close SO_ATO_PICKING_HDR_INFO;

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

1703: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1704: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1705: close SO_ATO_PICKING_HDR_INFO;
1706:
1707: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);
1708: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);
1709:
1710: ln_legal_entity_id := get_legal_entity_id ;
1711:

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

1704: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1705: close SO_ATO_PICKING_HDR_INFO;
1706:
1707: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);
1708: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);
1709:
1710: ln_legal_entity_id := get_legal_entity_id ;
1711:
1712: Insert into JAI_AR_TRXS

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

1763: 'Y',
1764: ln_legal_entity_id /* rallamse bug#4448789 */
1765: );
1766:
1767: FND_FILE.PUT_LINE(FND_FILE.LOG,'After insert into JAI_AR_TRXS ');
1768: FND_FILE.PUT_LINE(FND_FILE.LOG,
1769: 'End of Procedure Process_Taxes_for_ATO_Order');
1770:
1771: end if; -- end if for IF NVL(pr_new.Interface_line_attribute11,'0') ='0'

Line 1768: FND_FILE.PUT_LINE(FND_FILE.LOG,

1764: ln_legal_entity_id /* rallamse bug#4448789 */
1765: );
1766:
1767: FND_FILE.PUT_LINE(FND_FILE.LOG,'After insert into JAI_AR_TRXS ');
1768: FND_FILE.PUT_LINE(FND_FILE.LOG,
1769: 'End of Procedure Process_Taxes_for_ATO_Order');
1770:
1771: end if; -- end if for IF NVL(pr_new.Interface_line_attribute11,'0') ='0'
1772: end if;

Line 1889: FND_FILE.PUT_LINE(FND_FILE.LOG,

1885:
1886: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
1887:
1888: begin
1889: FND_FILE.PUT_LINE(FND_FILE.LOG,
1890: ' Inside Procedure process_bill_only_invoice');
1891:
1892: ln_hdr_exists := 0;
1893: ln_line_amount :=0;

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

1905: open c_check_hdr_exists;
1906: fetch c_check_hdr_exists into ln_hdr_exists;
1907: close c_check_hdr_exists;
1908:
1909: FND_FILE.PUT_LINE(FND_FILE.LOG,' Header exists '|| ln_hdr_exists);
1910:
1911: if nvl(ln_hdr_exists,0) = 0 then
1912: /*
1913: no record exists in the JAI_AR_TRXS table for the customer trx id ,

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

1925: else
1926: ln_inv_orgn_id := pr_new.warehouse_id ;
1927: end if;
1928:
1929: FND_FILE.PUT_LINE(FND_FILE.LOG,' Inv orgn id: '|| ln_inv_orgn_id);
1930:
1931: open c_default_location(ln_inv_orgn_id);
1932: fetch c_default_location into ln_default_locn_id;
1933: close c_default_location;

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

1931: open c_default_location(ln_inv_orgn_id);
1932: fetch c_default_location into ln_default_locn_id;
1933: close c_default_location;
1934:
1935: FND_FILE.PUT_LINE(FND_FILE.LOG,' Default location id '|| ln_default_locn_id);
1936:
1937: if ln_default_locn_id is null then
1938:
1939: /*

Line 2031: FND_FILE.PUT_LINE(FND_FILE.LOG,

2027: NULL ,
2028: ln_legal_entity_id /* rallamse bug#4448789 */
2029: );
2030:
2031: FND_FILE.PUT_LINE(FND_FILE.LOG,
2032: ' After insert into JAI_AR_TRXS - Bill only invoice');
2033: end if;
2034:
2035: /*

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

2040:
2041: open c_ont_source_code;
2042: fetch c_ont_source_code into v_ont_source_code;
2043: close c_ont_source_code;
2044: FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);
2045:
2046: v_ont_source_code := ltrim(rtrim(v_ont_source_code));
2047:
2048: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 2048: FND_FILE.PUT_LINE(FND_FILE.LOG,

2044: FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);
2045:
2046: v_ont_source_code := ltrim(rtrim(v_ont_source_code));
2047:
2048: FND_FILE.PUT_LINE(FND_FILE.LOG,
2049: ' Ont source code- after trunc: '|| v_ont_source_code);
2050:
2051: /*
2052: return if it is discount line

Line 2055: FND_FILE.PUT_LINE(FND_FILE.LOG,

2051: /*
2052: return if it is discount line
2053: */
2054: if nvl(pr_new.interface_line_attribute11,'0') <> '0' then
2055: FND_FILE.PUT_LINE(FND_FILE.LOG,
2056: ' Int. line att1: '||pr_new.interface_line_attribute11);
2057: return;
2058: end if;
2059:

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

2058: end if;
2059:
2060: for tax_rec in JA_SO_TAX_LINES_INFO
2061: Loop
2062: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');
2063: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
2064:
2065: if v_register_code = 'BOND_REG' then
2066: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);

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

2059:
2060: for tax_rec in JA_SO_TAX_LINES_INFO
2061: Loop
2062: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');
2063: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
2064:
2065: if v_register_code = 'BOND_REG' then
2066: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
2067: 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 2066: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);

2062: FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');
2063: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
2064:
2065: if v_register_code = 'BOND_REG' then
2066: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
2067: 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
2068: /* 'CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS' added by ssumaith - bug# 4136981*/
2069: /*jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess added by CSahoo BUG#5989740*/
2070: /*

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

2384: open c_get_amounts;
2385: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
2386: close c_get_amounts;
2387:
2388: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
2389: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
2390: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
2391:
2392: update JAI_AR_TRXS

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

2385: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
2386: close c_get_amounts;
2387:
2388: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
2389: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
2390: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
2391:
2392: update JAI_AR_TRXS
2393: set tax_amount = ln_tax_amount ,

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

2386: close c_get_amounts;
2387:
2388: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
2389: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
2390: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);
2391:
2392: update JAI_AR_TRXS
2393: set tax_amount = ln_tax_amount ,
2394: line_amount = ln_line_amount,

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

2703:
2704: --2001/05/03 Gadde,Jagdish
2705:
2706: /****************************** Validation 1 ********************************/
2707: FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '||v_org_id);
2708:
2709: /* Bug 5243532. Added by Lakshmi Gopalsami
2710: Removed the reference to cursor Fetch_Book_Id_Cur
2711: and used the values assigned in trigger to get

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

2712: the value of SOB.
2713: */
2714: v_gl_set_of_bks_id := pr_new.set_of_books_id;
2715:
2716: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id '|| v_gl_set_of_bks_id);
2717:
2718: --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
2719: -- return;
2720: --end if;

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

2753: j_location_id ,
2754: j_batch_source_id;
2755: CLOSE get_header_info_cur;
2756:
2757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
2758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
2759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
2760: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);
2761:

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

2754: j_batch_source_id;
2755: CLOSE get_header_info_cur;
2756:
2757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
2758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
2759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
2760: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);
2761:
2762: /* The following code has been added by SRIRAM -- BUG # 3021588 CALL TO jai_cmn_bond_register_pkg INSTEAD */

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

2755: CLOSE get_header_info_cur;
2756:
2757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
2758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
2759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
2760: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);
2761:
2762: /* The following code has been added by SRIRAM -- BUG # 3021588 CALL TO jai_cmn_bond_register_pkg INSTEAD */
2763:

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

2756:
2757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
2758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
2759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
2760: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);
2761:
2762: /* The following code has been added by SRIRAM -- BUG # 3021588 CALL TO jai_cmn_bond_register_pkg INSTEAD */
2763:
2764: jai_cmn_bond_register_pkg.get_register_id(

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

2774: OPEN transaction_type_cur;
2775: FETCH transaction_type_cur INTO v_trans_type;
2776: CLOSE transaction_type_cur;
2777:
2778: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
2779: FND_FILE.PUT_LINE(FND_FILE.LOG,
2780: ' Interface line attribute1 '||pr_new.interface_line_attribute1);
2781: FND_FILE.PUT_LINE(FND_FILE.LOG,
2782: ' Interface line context '|| pr_new.interface_line_context);

Line 2779: FND_FILE.PUT_LINE(FND_FILE.LOG,

2775: FETCH transaction_type_cur INTO v_trans_type;
2776: CLOSE transaction_type_cur;
2777:
2778: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
2779: FND_FILE.PUT_LINE(FND_FILE.LOG,
2780: ' Interface line attribute1 '||pr_new.interface_line_attribute1);
2781: FND_FILE.PUT_LINE(FND_FILE.LOG,
2782: ' Interface line context '|| pr_new.interface_line_context);
2783:

Line 2781: FND_FILE.PUT_LINE(FND_FILE.LOG,

2777:
2778: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
2779: FND_FILE.PUT_LINE(FND_FILE.LOG,
2780: ' Interface line attribute1 '||pr_new.interface_line_attribute1);
2781: FND_FILE.PUT_LINE(FND_FILE.LOG,
2782: ' Interface line context '|| pr_new.interface_line_context);
2783:
2784: IF ( v_trans_type = 'CM'
2785: AND pr_new.interface_line_attribute1 = 'SUPPLEMENT CM' -- pr_new.interface_line_context, Bug 4392001

Line 2826: FND_FILE.PUT_LINE(FND_FILE.LOG,

2822: OPEN once_complete_flag_cur;
2823: FETCH once_complete_flag_cur INTO v_once_completed_flag;
2824: CLOSE once_complete_flag_cur;
2825:
2826: FND_FILE.PUT_LINE(FND_FILE.LOG,
2827: ' Once completed flag '|| v_once_completed_flag);
2828:
2829:
2830: IF NVL(v_once_completed_flag,'N') = 'Y' THEN

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

2846: OPEN get_exchange_rate;
2847: FETCH get_exchange_rate INTO v_exchange_rate;
2848: CLOSE get_exchange_rate;
2849:
2850: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Exchange rate '|| v_exchange_rate);
2851:
2852: OPEN duplicate_hdr_cur;
2853: FETCH duplicate_hdr_cur INTO x;
2854: CLOSE duplicate_hdr_cur;

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

2854: CLOSE duplicate_hdr_cur;
2855:
2856: -- IF pr_new.interface_line_attribute1 IS NULL THEN -- Commented By BRATHOD Bug 4392001
2857: IF pr_new.interface_line_attribute4 IS NULL THEN -- Added by BRATHOD, Big# 4392001
2858: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line att4 is null');
2859:
2860: OPEN supplement_lines_check_cnsldt;
2861: FETCH supplement_lines_check_cnsldt INTO v_exist_flag;
2862: CLOSE supplement_lines_check_cnsldt;

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

2862: CLOSE supplement_lines_check_cnsldt;
2863:
2864: -- ELSIF pr_new.interface_line_attribute1 IS NOT NULL THEN -- Commented By BRATHOD Bug 4392001
2865: ELSIF pr_new.interface_line_attribute4 IS NOT NULL THEN -- Added By BRATHOD Bug 4392001
2866: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line att4 is not null');
2867: OPEN supplement_lines_check;
2868: FETCH supplement_lines_check INTO v_exist_flag;
2869: CLOSE supplement_lines_check;
2870: END IF;

Line 2872: FND_FILE.PUT_LINE(FND_FILE.LOG,

2868: FETCH supplement_lines_check INTO v_exist_flag;
2869: CLOSE supplement_lines_check;
2870: END IF;
2871:
2872: FND_FILE.PUT_LINE(FND_FILE.LOG,
2873: ' Supplement lines check exists flag'|| v_exist_flag);
2874: IF NVL(v_exist_flag,0) <> 1 THEN
2875: return;
2876: END IF;

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

2929: v_last_updated_by ,
2930: v_last_update_login ,
2931: ln_legal_entity_id /* rallamse bug#4448789 */
2932: );
2933: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside x <> 1: After insert into JAI_AR_TRXS');
2934: END IF;
2935:
2936: IF pr_new.interface_line_attribute4 IS NULL THEN -- pr_new.interface_line_attribute1, Bug# 4392001
2937: OPEN supplement_tax_lines_check_cns;

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

3018: v_ship_to_site_use_id ,
3019: v_trx_number ,
3020: v_batch_source_id;
3021:
3022: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3023: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ship to site use: '|| v_ship_to_site_use_id);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3025: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);
3026:

Line 3023: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ship to site use: '|| v_ship_to_site_use_id);

3019: v_trx_number ,
3020: v_batch_source_id;
3021:
3022: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3023: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ship to site use: '|| v_ship_to_site_use_id);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3025: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);
3026:
3027: CLOSE get_header_details;

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

3020: v_batch_source_id;
3021:
3022: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3023: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ship to site use: '|| v_ship_to_site_use_id);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3025: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);
3026:
3027: CLOSE get_header_details;
3028: OPEN get_site(v_trx_number);

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

3021:
3022: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3023: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ship to site use: '|| v_ship_to_site_use_id);
3024: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3025: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);
3026:
3027: CLOSE get_header_details;
3028: OPEN get_site(v_trx_number);
3029: FETCH get_site INTO v_ship_to_site_use_id;

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

3104:
3105: /**************** End of If Loop pr_new.interface_line_attribute1 IS NULL **********/
3106:
3107: IF pr_new.interface_line_attribute4 IS NULL THEN -- new.interface_line_attribute1, Bug# 4392001
3108: FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is null');
3109:
3110: OPEN supplement_lines_info_cnsldt;
3111: FETCH supplement_lines_info_cnsldt INTO v_tax_amount,
3112: v_excise_diff,

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

3112: v_excise_diff,
3113: v_assessable_value;
3114: CLOSE supplement_lines_info_cnsldt;
3115:
3116: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3117: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3118: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3119:
3120: OPEN supplement_lines_info_tax_catg;

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

3113: v_assessable_value;
3114: CLOSE supplement_lines_info_cnsldt;
3115:
3116: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3117: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3118: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3119:
3120: OPEN supplement_lines_info_tax_catg;
3121: FETCH supplement_lines_info_tax_catg INTO v_tax_category_id;

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

3114: CLOSE supplement_lines_info_cnsldt;
3115:
3116: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3117: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3118: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3119:
3120: OPEN supplement_lines_info_tax_catg;
3121: FETCH supplement_lines_info_tax_catg INTO v_tax_category_id;
3122: CLOSE supplement_lines_info_tax_catg;

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

3120: OPEN supplement_lines_info_tax_catg;
3121: FETCH supplement_lines_info_tax_catg INTO v_tax_category_id;
3122: CLOSE supplement_lines_info_tax_catg;
3123:
3124: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3125:
3126: ELSIF pr_new.INTERFACE_LINE_ATTRIBUTE4 IS NOT NULL THEN -- pr_new.interface_line_attribute1, Bug# 4392001
3127: FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is not null');
3128: OPEN supplement_lines_info;

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

3123:
3124: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3125:
3126: ELSIF pr_new.INTERFACE_LINE_ATTRIBUTE4 IS NOT NULL THEN -- pr_new.interface_line_attribute1, Bug# 4392001
3127: FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is not null');
3128: OPEN supplement_lines_info;
3129: FETCH supplement_lines_info INTO v_tax_category_id,
3130: v_tax_amount ,
3131: v_excise_diff ,

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

3130: v_tax_amount ,
3131: v_excise_diff ,
3132: v_assessable_value;
3133: CLOSE supplement_lines_info;
3134: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3135: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3136: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3137: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3138:

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

3131: v_excise_diff ,
3132: v_assessable_value;
3133: CLOSE supplement_lines_info;
3134: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3135: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3136: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3137: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3138:
3139: END IF;

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

3132: v_assessable_value;
3133: CLOSE supplement_lines_info;
3134: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3135: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3136: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3137: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3138:
3139: END IF;
3140:

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

3133: CLOSE supplement_lines_info;
3134: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3135: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3136: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3137: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3138:
3139: END IF;
3140:
3141:

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

3205: IF NVL(v_excise_diff ,0) > 0 THEN
3206:
3207: IF NVL(v_reg_code,'N') IN ('DOMESTIC_EXCISE','EXPORT_EXCISE') THEN
3208:
3209: FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code: '||v_reg_code);
3210:
3211:
3212: OPEN pref_cur(v_organization_id, v_location_id);
3213: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla;

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

3212: OPEN pref_cur(v_organization_id, v_location_id);
3213: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla;
3214: CLOSE pref_cur;
3215:
3216: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3217: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3218: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);
3219:
3220: OPEN rg_bal_cur(v_organization_id, v_location_id);

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

3213: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla;
3214: CLOSE pref_cur;
3215:
3216: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3217: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3218: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);
3219:
3220: OPEN rg_bal_cur(v_organization_id, v_location_id);
3221: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;

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

3214: CLOSE pref_cur;
3215:
3216: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3217: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3218: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);
3219:
3220: OPEN rg_bal_cur(v_organization_id, v_location_id);
3221: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;
3222: CLOSE rg_bal_cur;

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

3220: OPEN rg_bal_cur(v_organization_id, v_location_id);
3221: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;
3222: CLOSE rg_bal_cur;
3223:
3224: FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3225: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3226: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);
3227:
3228:

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

3221: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;
3222: CLOSE rg_bal_cur;
3223:
3224: FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3225: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3226: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);
3227:
3228:
3229: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);

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

3222: CLOSE rg_bal_cur;
3223:
3224: FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3225: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3226: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);
3227:
3228:
3229: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);
3230: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;

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

3229: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);
3230: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;
3231: CLOSE ssi_unit_flag_cur;
3232:
3233: FND_FILE.PUT_LINE(FND_FILE.LOG,' SSI unit flag'||v_ssi_unit_flag);
3234:
3235: IF v_pref_rg23a = 1 THEN --5
3236: IF v_rg23a_balance >= NVL(v_excise_diff,0) THEN --6
3237: v_reg_type := 'RG23A';

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

3317: OPEN register_code_meaning_cur(v_reg_code, 'REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs */
3318: FETCH register_code_meaning_cur INTO v_meaning;
3319: CLOSE register_code_meaning_cur;
3320:
3321: FND_FILE.PUT_LINE(FND_FILE.LOG,' Meaning'|| v_meaning);
3322:
3323: OPEN fin_year_cur(v_organization_id);
3324: FETCH fin_year_cur INTO v_fin_year;
3325: CLOSE fin_year_cur;

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

3323: OPEN fin_year_cur(v_organization_id);
3324: FETCH fin_year_cur INTO v_fin_year;
3325: CLOSE fin_year_cur;
3326:
3327: FND_FILE.PUT_LINE(FND_FILE.LOG,' Fin year '|| v_fin_year);
3328:
3329: OPEN Batch_Source_Name_Cur(v_batch_source_id);
3330: FETCH Batch_Source_Name_Cur INTO v_order_invoice_type;
3331: CLOSE Batch_Source_Name_Cur;

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

3329: OPEN Batch_Source_Name_Cur(v_batch_source_id);
3330: FETCH Batch_Source_Name_Cur INTO v_order_invoice_type;
3331: CLOSE Batch_Source_Name_Cur;
3332:
3333: FND_FILE.PUT_LINE(FND_FILE.LOG,' Order invoice type: '|| v_order_invoice_type);
3334:
3335: OPEN Def_Excise_Invoice_Cur(v_organization_id, v_location_id, v_fin_year, v_order_invoice_type, v_meaning);
3336: FETCH Def_Excise_Invoice_Cur INTO v_start_number, v_end_number, v_jump_by, v_prefix;
3337: CLOSE Def_Excise_Invoice_Cur;

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

3335: OPEN Def_Excise_Invoice_Cur(v_organization_id, v_location_id, v_fin_year, v_order_invoice_type, v_meaning);
3336: FETCH Def_Excise_Invoice_Cur INTO v_start_number, v_end_number, v_jump_by, v_prefix;
3337: CLOSE Def_Excise_Invoice_Cur;
3338:
3339: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
3340: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
3341: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
3342: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);
3343:

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

3336: FETCH Def_Excise_Invoice_Cur INTO v_start_number, v_end_number, v_jump_by, v_prefix;
3337: CLOSE Def_Excise_Invoice_Cur;
3338:
3339: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
3340: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
3341: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
3342: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);
3343:
3344:

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

3337: CLOSE Def_Excise_Invoice_Cur;
3338:
3339: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
3340: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
3341: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
3342: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);
3343:
3344:
3345: IF v_start_number IS NOT NULL THEN --2

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

3338:
3339: FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
3340: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
3341: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
3342: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);
3343:
3344:
3345: IF v_start_number IS NOT NULL THEN --2
3346: IF NVL(v_start_number,0) >= NVL(v_end_number,0) AND v_end_number IS NOT NULL THEN

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

3545:
3546: OPEN so_picking_hdr_info;
3547: FETCH so_picking_hdr_info INTO v_organization_id, v_location_id;
3548: CLOSE so_picking_hdr_info;
3549: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
3550: /* Added by JMEENA for bug#6498345 ( FP 6492966), Starts */
3551: IF v_organization_id IS NULL THEN
3552: ln_order_ato := NULL ;
3553: OPEN c_ato_order ;

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

3559: fetch c_ato_hdr_info into v_organization_id, v_location_id;
3560: close c_ato_hdr_info;
3561: END IF ;
3562:
3563: FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO Header Info: v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
3564: END IF ;
3565: /* Added for bug#6498345( FP 6492966), Ends */
3566:
3567:

Line 3935: fnd_file.put_line(FND_FILE.LOG,

3931: OPEN c_so_lines_exists ;
3932: FETCH c_so_lines_exists INTO lv_exists;
3933: IF c_so_lines_exists%NOTFOUND THEN
3934: CLOSE c_so_lines_exists;
3935: fnd_file.put_line(FND_FILE.LOG,
3936: 'no lines in jai_om_oe_so_lines -return');
3937: return;
3938: END IF;
3939: CLOSE c_so_lines_exists;

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

3943: OPEN duplicate_lines_cur;
3944: FETCH duplicate_lines_cur INTO v_line_count;
3945: CLOSE duplicate_lines_cur;
3946:
3947: fnd_file.put_line(FND_FILE.LOG, ' Line cnt: '|| v_line_count);
3948:
3949: IF NVL(v_line_count,0) <> 1 THEN
3950: -- the following If Condition added by Sriram - 27/06/2002 - Bug # 2398198
3951: -- Here trying to conditionally update Ja_in_ra_customer_trx_table

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

3958: (nvl(v_ont_source_code,'ORDER ENTRY') <> nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$') -- added by sriram - bug# 3607101
3959: )
3960: then
3961:
3962: fnd_file.put_line(FND_FILE.LOG, ' int. line att1 = 0 ');
3963: v_calc_tax_amount := v_tax_amount * v_qty;
3964: OPEN c_cust_trx_tax_line_amt;
3965: FETCH c_cust_trx_tax_line_amt into v_calc_tax_amount;
3966: CLOSE c_cust_trx_tax_line_amt;

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

4059: END IF; /* END IF OF IF NVL(v_line_count,0) <> 1 */
4060:
4061: 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));
4062:
4063: fnd_file.put_line(FND_FILE.LOG, ' Excise amount: '|| v_excise_amount);
4064:
4065: OPEN complete_flag_cur;
4066: FETCH complete_flag_cur INTO v_once_completed_flag;
4067: CLOSE complete_flag_cur;

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

4065: OPEN complete_flag_cur;
4066: FETCH complete_flag_cur INTO v_once_completed_flag;
4067: CLOSE complete_flag_cur;
4068:
4069: fnd_file.put_line(FND_FILE.LOG, ' Once complete flag'|| v_once_completed_flag);
4070:
4071: v_so_tax_amount := v_tax_amount * v_qty ;
4072:
4073: /*Bug # 2316589*/

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

4082: OPEN c_cust_trx_tax_line_amt;
4083: FETCH c_cust_trx_tax_line_amt into v_so_tax_amount;
4084: CLOSE c_cust_trx_tax_line_amt;
4085:
4086: fnd_file.put_line(FND_FILE.LOG, ' so tax amount: '|| v_so_tax_amount);
4087:
4088: -- bug # 3000550 sriram
4089: IF (NVL(pr_new.Interface_line_attribute11,'0') ='0'
4090: and nvl(v_ont_source_code,'ORDER ENTRY') = ltrim(rtrim(pr_new.interface_line_context)) -- added by sriram - bug# 3607101

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

4532: OPEN SO_RMA_RECORD_CHECK;
4533: FETCH SO_RMA_RECORD_CHECK INTO v_exist_flag;
4534: CLOSE SO_RMA_RECORD_CHECK;
4535:
4536: fnd_file.put_line(FND_FILE.LOG, ' RMA record chk:'|| v_exist_flag);
4537:
4538: IF NVL(v_exist_flag,0) <> 1 THEN
4539: RETURN;
4540: END IF;