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

Line 549: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Inside Procedure process_bill_only_invoice');

545:
546: ln_ar_tax_amount JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%type;
547: l_api_name CONSTANT VARCHAR2(30) := 'process_bill_only_invoice()';
548: begin
549: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Inside Procedure process_bill_only_invoice');
550: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
551: FND_LOG.STRING(G_LEVEL_PROCEDURE,
552: G_MODULE_NAME || l_api_name || '.BEGIN',
553: G_PKG_NAME || ': ' || l_api_name || '()+');

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

569: open c_check_hdr_exists;
570: fetch c_check_hdr_exists into ln_hdr_exists;
571: close c_check_hdr_exists;
572:
573: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Header exists '|| ln_hdr_exists);
574: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
575: FND_LOG.STRING(G_LEVEL_PROCEDURE,
576: G_MODULE_NAME || l_api_name || '.IN',
577: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

595: else
596: ln_inv_orgn_id := pr_new.warehouse_id ;
597: end if;
598:
599: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Inv orgn id: '|| ln_inv_orgn_id);
600: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
601: FND_LOG.STRING(G_LEVEL_PROCEDURE,
602: G_MODULE_NAME || l_api_name || '.IN',
603: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

607: open c_default_location(ln_inv_orgn_id);
608: fetch c_default_location into ln_default_locn_id;
609: close c_default_location;
610:
611: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Default location id '|| ln_default_locn_id);
612: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
613: FND_LOG.STRING(G_LEVEL_PROCEDURE,
614: G_MODULE_NAME || l_api_name || '.IN',
615: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 715: --FND_FILE.PUT_LINE(FND_FILE.LOG,' After insert into JAI_AR_TRXS - Bill only invoice');

711: NULL ,
712: ln_legal_entity_id
713: );
714:
715: --FND_FILE.PUT_LINE(FND_FILE.LOG,' After insert into JAI_AR_TRXS - Bill only invoice');
716: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
717: FND_LOG.STRING(G_LEVEL_PROCEDURE,
718: G_MODULE_NAME || l_api_name || '.IN',
719: G_PKG_NAME || ': ' || l_api_name || '().'||' After insert into JAI_AR_TRXS - Bill only invoice'

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

729:
730: open c_ont_source_code;
731: fetch c_ont_source_code into v_ont_source_code;
732: close c_ont_source_code;
733: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);
734: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
735: FND_LOG.STRING(G_LEVEL_PROCEDURE,
736: G_MODULE_NAME || l_api_name || '.IN',
737: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 743: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code- after trunc: '|| v_ont_source_code);

739: );
740: end if;
741: v_ont_source_code := ltrim(rtrim(v_ont_source_code));
742:
743: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code- after trunc: '|| v_ont_source_code);
744: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
745: FND_LOG.STRING(G_LEVEL_PROCEDURE,
746: G_MODULE_NAME || l_api_name || '.IN',
747: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 755: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att1: '||pr_new.interface_line_attribute11);

751: /*
752: return if it is discount line
753: */
754: if nvl(pr_new.interface_line_attribute11,'0') <> '0' then
755: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att1: '||pr_new.interface_line_attribute11);
756: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
757: FND_LOG.STRING(G_LEVEL_PROCEDURE,
758: G_MODULE_NAME || l_api_name || '.IN',
759: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

764: end if;
765:
766: for tax_rec in JA_SO_TAX_LINES_INFO
767: Loop
768: --FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');
769: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
770: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
771: FND_LOG.STRING(G_LEVEL_PROCEDURE,
772: G_MODULE_NAME || l_api_name || '.IN',

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

765:
766: for tax_rec in JA_SO_TAX_LINES_INFO
767: Loop
768: --FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor ja_so_tax_lines_info');
769: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
770: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
771: FND_LOG.STRING(G_LEVEL_PROCEDURE,
772: G_MODULE_NAME || l_api_name || '.IN',
773: G_PKG_NAME || ': ' || l_api_name || '().'||' cursor ja_so_tax_lines_info :'

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

775: );
776: end if;
777: if v_register_code = 'BOND_REG' then
778:
779: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| v_register_code);
780: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
781: FND_LOG.STRING(G_LEVEL_PROCEDURE,
782: G_MODULE_NAME || l_api_name || '.IN',
783: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO :'

Line 1123: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');

1119: open c_get_amounts;
1120: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
1121: close c_get_amounts;
1122:
1123: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
1125: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);*/
1126: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1127: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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

1120: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
1121: close c_get_amounts;
1122:
1123: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
1125: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);*/
1126: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1127: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1128: G_MODULE_NAME || l_api_name || '.IN',

Line 1125: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);*/

1121: close c_get_amounts;
1122:
1123: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
1125: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);*/
1126: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1127: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1128: G_MODULE_NAME || l_api_name || '.IN',
1129: G_PKG_NAME || ': ' || l_api_name || '().'||' Cursor c_get_amounts :'

Line 1137: --FND_FILE.PUT_LINE(FND_FILE.LOG,' VAT Invoice Number '|| lv_vat_invoice_no);

1133: end if;
1134: OPEN c_get_vat_inv_no;
1135: FETCH c_get_vat_inv_no INTO lv_vat_invoice_no;
1136: CLOSE c_get_vat_inv_no;
1137: --FND_FILE.PUT_LINE(FND_FILE.LOG,' VAT Invoice Number '|| lv_vat_invoice_no);
1138: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1139: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1140: G_MODULE_NAME || l_api_name || '.IN',
1141: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO :'

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

1266: G_MODULE_NAME || l_api_name || '.BEGIN',
1267: G_PKG_NAME || ': ' || l_api_name || '()+');
1268: end if;
1269:
1270: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');
1271: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type);
1272: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1273: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1274: G_MODULE_NAME || l_api_name || '.IN',

Line 1271: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type);

1267: G_PKG_NAME || ': ' || l_api_name || '()+');
1268: end if;
1269:
1270: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside Procedure Process_Taxes_for_ATO_Order');
1271: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: v_item_type: ' || v_item_type);
1272: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1273: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1274: G_MODULE_NAME || l_api_name || '.IN',
1275: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1281: open c_item_type;
1282: fetch c_item_type into v_item_type;
1283: close c_item_type;
1284:
1285: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Item type'|| v_item_type);
1286: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1287: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1288: G_MODULE_NAME || l_api_name || '.IN',
1289: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1303: Open c_get_config_line_id(v_interface_line_attribute6, 'CONFIG');
1304: Fetch c_get_config_line_id into v_config_line_id;
1305: Close c_get_config_line_id;
1306:
1307: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Config line id ' || v_config_line_id);
1308: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1309: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1310: G_MODULE_NAME || l_api_name || '.IN',
1311: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1320: Open c_get_tax_info(so_taxes_rec.tax_id);
1321: Fetch c_get_tax_info into v_tax_type;
1322: close c_get_tax_info;
1323:
1324: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Type: '|| v_tax_type);
1325: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1326: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1327: G_MODULE_NAME || l_api_name || '.IN',
1328: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1331: end if;
1332:
1333: IF V_REGISTER_CODE ='BOND_REG' THEN
1334:
1335: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside BOND Register');
1336: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1337: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1338: G_MODULE_NAME || l_api_name || '.IN',
1339: G_PKG_NAME || ': ' || l_api_name || '().'||' Inside BOND Register '

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

1397: so_taxes_rec.last_updated_by,
1398: so_taxes_rec.last_update_login
1399: );
1400:
1401: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRX_TAX_LINES');
1402: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1403: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1404: G_MODULE_NAME || l_api_name || '.IN',
1405: G_PKG_NAME || ': ' || l_api_name || '().'||' After insert into JAI_AR_TRX_TAX_LINES '

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

1406: );
1407: end if;
1408: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1409:
1410: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
1411: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1412: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1413: G_MODULE_NAME || l_api_name || '.IN',
1414: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 1481: /*FND_FILE.PUT_LINE(FND_FILE.LOG,

1477: so_taxes_rec.last_updated_by,
1478: so_taxes_rec.last_update_login
1479: );
1480:
1481: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
1482: ' Else - After insert into JAI_AR_TRX_TAX_LINES');*/
1483: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1484: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1485: G_MODULE_NAME || l_api_name || '.IN',

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

1486: G_PKG_NAME || ': ' || l_api_name || '().'||' Else - After insert into JAI_AR_TRX_TAX_LINES '
1487: );
1488: end if;
1489: v_tax_amount := NVL(v_tax_amount,0) + NVL(so_taxes_rec.tax_amount,0);
1490: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax amount: '|| v_tax_amount);
1491: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1492: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1493: G_MODULE_NAME || l_api_name || '.IN',
1494: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1505: Open c_so_picking_data(v_config_line_id);
1506: 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;
1507: close c_so_picking_data;
1508:
1509: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1510: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1513: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);*/

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

1506: 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;
1507: close c_so_picking_data;
1508:
1509: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1510: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1513: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);*/
1514: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

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

1507: close c_so_picking_data;
1508:
1509: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1510: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1513: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);*/
1514: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1515: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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

1508:
1509: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1510: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1513: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);*/
1514: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1515: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1516: G_MODULE_NAME || l_api_name || '.IN',

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

1509: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Excise invoice number: '|| v_ex_inv_no);
1510: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pmt reg: ' ||v_pmt_reg);
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Pre print ex. no : '|| v_pre_prnt_ex_no);
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form no.: '|| v_ar3_form_no);
1513: FND_FILE.PUT_LINE(FND_FILE.LOG, ' AR3 form date '||v_ar3_form_date);*/
1514: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1515: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1516: G_MODULE_NAME || l_api_name || '.IN',
1517: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1531: open so_ato_picking_hdr_info(v_config_line_id);
1532: fetch so_ato_picking_hdr_info into v_organization_id , v_location_id;
1533: close so_ato_picking_hdr_info;
1534:
1535: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'ATO: 1. v_organization_id , v_location_id: ' || v_organization_id || ' , ' || v_location_id );
1536: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1538: G_MODULE_NAME || l_api_name || '.IN',
1539: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1545: open so_picking_hdr_info_1 ;
1546: fetch so_picking_hdr_info_1 into v_organization_id , v_location_id;
1547: close so_picking_hdr_info_1;
1548:
1549: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO: 2. v_organization_id , v_location_id: ' || v_organization_id || ' , ' || v_location_id );
1550: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1551: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1552: G_MODULE_NAME || l_api_name || '.IN',
1553: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 1611: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);

1607: v_salesrep_id, c_from_currency_code, c_conversion_type,
1608: c_conversion_date, c_conversion_rate ;
1609: CLOSE CREATED_FROM_CUR;
1610:
1611: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1613: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1614: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);

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

1608: c_conversion_date, c_conversion_rate ;
1609: CLOSE CREATED_FROM_CUR;
1610:
1611: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1613: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1614: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1616: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);

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

1609: CLOSE CREATED_FROM_CUR;
1610:
1611: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1613: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1614: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1616: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1617: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);

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

1610:
1611: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1613: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1614: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1616: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1617: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1618: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);

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

1611: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Created from: '|| v_created_from);
1612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1613: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1614: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1616: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1617: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1618: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1619: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);*/

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

1612: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx number : ' ||v_trx_number);
1613: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1614: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1616: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1617: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1618: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1619: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);*/
1620:

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

1613: FND_FILE.PUT_LINE(FND_FILE.LOG,' Batch source id '|| v_batch_source_id);
1614: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1616: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1617: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1618: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1619: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);*/
1620:
1621: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

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

1614: FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id : '|| v_books_id);
1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1616: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1617: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1618: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1619: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);*/
1620:
1621: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1622: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1619: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);*/

1615: FND_FILE.PUT_LINE(FND_FILE.LOG,' Salesrep. id '||v_salesrep_id);
1616: FND_FILE.PUT_LINE(FND_FILE.LOG,' From currency code '||c_from_currency_code);
1617: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion type: '||c_conversion_type);
1618: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion date: '||c_conversion_date);
1619: FND_FILE.PUT_LINE(FND_FILE.LOG,' conversion rate: '||c_conversion_rate);*/
1620:
1621: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1622: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1623: G_MODULE_NAME || l_api_name || '.IN',

Line 1642: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);

1638: OPEN SO_ATO_PICKING_HDR_INFO(v_config_line_id);
1639: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1640: close SO_ATO_PICKING_HDR_INFO;
1641:
1642: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);
1643: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);*/
1644: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1645: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1646: G_MODULE_NAME || l_api_name || '.IN',

Line 1643: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);*/

1639: Fetch SO_ATO_PICKING_HDR_INFO into v_organization_id , v_location_id;
1640: close SO_ATO_PICKING_HDR_INFO;
1641:
1642: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Org id: '|| v_organization_id);
1643: FND_FILE.PUT_LINE(FND_FILE.LOG,' Loc id: '||v_location_id);*/
1644: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1645: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1646: G_MODULE_NAME || l_api_name || '.IN',
1647: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1654: IF v_organization_id IS NULL THEN
1655: open so_picking_hdr_info_1 ;
1656: fetch so_picking_hdr_info_1 into v_organization_id , v_location_id;
1657: close so_picking_hdr_info_1;
1658: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Org id: '|| v_organization_id);
1659: FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Loc id: '|| v_location_id);*/
1660: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1661: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1662: G_MODULE_NAME || l_api_name || '.IN',

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

1655: open so_picking_hdr_info_1 ;
1656: fetch so_picking_hdr_info_1 into v_organization_id , v_location_id;
1657: close so_picking_hdr_info_1;
1658: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Org id: '|| v_organization_id);
1659: FND_FILE.PUT_LINE(FND_FILE.LOG,' ATO: Loc id: '|| v_location_id);*/
1660: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1661: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1662: G_MODULE_NAME || l_api_name || '.IN',
1663: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1727: G_MODULE_NAME || l_api_name || '.IN',
1728: G_PKG_NAME || ': ' || l_api_name || '().'||' After insert into JAI_AR_TRXS '
1729: );
1730: end if;
1731: --FND_FILE.PUT_LINE(FND_FILE.LOG,'After insert into JAI_AR_TRXS ');
1732:
1733: end if;
1734:
1735:

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

1834: RAISE le_error;
1835: END IF;
1836: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
1837:
1838: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1839: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
1840: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1841: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);*/
1842: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

Line 1839: /*FND_FILE.PUT_LINE(FND_FILE.LOG,

1835: END IF;
1836: --Added by Qinglei for JAI Trigger Elimination 11-May-2012 end
1837:
1838: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1839: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
1840: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1841: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);*/
1842: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1843: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 1841: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);*/

1837:
1838: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1839: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
1840: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1841: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);*/
1842: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1843: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1844: G_MODULE_NAME || l_api_name || '.IN',
1845: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

1851:
1852: v_ato_line_amount := so_line_rec.line_amount;
1853: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
1854: v_ato_total_amount := NVL(v_ato_total_amount,0) + NVL(so_line_rec.line_amount,0) + NVL(v_ato_tax_amount,0);
1855: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tax amount: '||v_ato_tax_amount);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tot amount: '||v_ato_total_amount);*/
1857: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1858: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1859: G_MODULE_NAME || l_api_name || '.IN',

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

1852: v_ato_line_amount := so_line_rec.line_amount;
1853: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
1854: v_ato_total_amount := NVL(v_ato_total_amount,0) + NVL(so_line_rec.line_amount,0) + NVL(v_ato_tax_amount,0);
1855: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tax amount: '||v_ato_tax_amount);
1856: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Ato tot amount: '||v_ato_total_amount);*/
1857: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1858: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1859: G_MODULE_NAME || l_api_name || '.IN',
1860: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 1868: /*FND_FILE.PUT_LINE(FND_FILE.LOG,

1864: end if;
1865: end loop;
1866:
1867:
1868: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
1869: 'End of Procedure Process_Taxes_for_ATO_Order');*/
1870:
1871: end if; -- end if for IF NVL(pr_new.Interface_line_attribute11,'0') ='0'
1872: end if;

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

1958:
1959: OPEN so_picking_hdr_info;
1960: FETCH so_picking_hdr_info INTO v_organization_id, v_location_id;
1961: CLOSE so_picking_hdr_info;
1962: --FND_FILE.PUT_LINE(FND_FILE.LOG,'v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
1963: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1964:
1965: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1966: G_MODULE_NAME || l_api_name || '.IN',

Line 1978: --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 );

1974: OPEN so_picking_hdr_info_1;
1975: FETCH so_picking_hdr_info_1 INTO v_organization_id, v_location_id;
1976: CLOSE so_picking_hdr_info_1;
1977:
1978: --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 );
1979: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1980:
1981: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1982: G_MODULE_NAME || l_api_name || '.IN',

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

1999: fetch c_ato_hdr_info into v_organization_id, v_location_id;
2000: close c_ato_hdr_info;
2001: END IF ;
2002:
2003: --FND_FILE.PUT_LINE(FND_FILE.LOG,'ATO Header Info: v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
2004: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2005:
2006: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2007: G_MODULE_NAME || l_api_name || '.IN',

Line 2025: --FND_FILE.PUT_LINE(FND_FILE.LOG,'From Cursor c_so_picking_hdr_info_ns: v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );

2021: THEN
2022: OPEN c_so_picking_hdr_info_ns;
2023: FETCH c_so_picking_hdr_info_ns INTO v_organization_id, v_location_id;
2024: CLOSE c_so_picking_hdr_info_ns;
2025: --FND_FILE.PUT_LINE(FND_FILE.LOG,'From Cursor c_so_picking_hdr_info_ns: v_organization_id= '||v_organization_id||' v_location_id= ' || v_location_id );
2026: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2027:
2028: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2029: G_MODULE_NAME || l_api_name || '.IN',

Line 2628: --fnd_file.put_line(FND_FILE.LOG,'no lines in jai_om_oe_so_lines -return');

2624: OPEN c_so_lines_exists ;
2625: FETCH c_so_lines_exists INTO lv_exists;
2626: IF c_so_lines_exists%NOTFOUND THEN
2627: CLOSE c_so_lines_exists;
2628: --fnd_file.put_line(FND_FILE.LOG,'no lines in jai_om_oe_so_lines -return');
2629: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2630: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2631: G_MODULE_NAME || l_api_name || '.IN',
2632: G_PKG_NAME || ': ' || l_api_name || '().'||' no lines in jai_om_oe_so_lines -return '

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

2648: OPEN duplicate_lines_cur;
2649: FETCH duplicate_lines_cur INTO v_line_count;
2650: CLOSE duplicate_lines_cur;
2651:
2652: --fnd_file.put_line(FND_FILE.LOG, ' Line cnt: '|| v_line_count);
2653: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2654: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2655: G_MODULE_NAME || l_api_name || '.IN',
2656: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

2668: (nvl(v_ont_source_code,'ORDER ENTRY') <> nvl(ltrim(rtrim(pr_new.interface_line_context)),'$$$')
2669: )
2670: then
2671:
2672: --fnd_file.put_line(FND_FILE.LOG, ' int. line att1 = 0 ');
2673: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2674: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2675: G_MODULE_NAME || l_api_name || '.IN',
2676: G_PKG_NAME || ': ' || l_api_name || '().'||'int. line att1 = 0'

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

2838: END IF; /* END IF OF IF NVL(v_line_count,0) <> 1 */
2839:
2840: 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));
2841:
2842: --fnd_file.put_line(FND_FILE.LOG, ' Excise amount: '|| v_excise_amount);
2843: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2844: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2845:
2846: G_MODULE_NAME || l_api_name || '.IN',

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

2851: OPEN complete_flag_cur;
2852: FETCH complete_flag_cur INTO v_once_completed_flag;
2853: CLOSE complete_flag_cur;
2854:
2855: --fnd_file.put_line(FND_FILE.LOG, ' Once complete flag'|| v_once_completed_flag);
2856: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2857: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2858:
2859: G_MODULE_NAME || l_api_name || '.IN',

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

2875: OPEN c_cust_trx_tax_line_amt;
2876: FETCH c_cust_trx_tax_line_amt into v_so_tax_amount;
2877: CLOSE c_cust_trx_tax_line_amt;
2878:
2879: --fnd_file.put_line(FND_FILE.LOG, ' so tax amount: '|| v_so_tax_amount);
2880: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2881: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2882:
2883: G_MODULE_NAME || l_api_name || '.IN',

Line 2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);

2958: EXCEPTION
2959: when le_error then
2960: pv_return_code := jai_constants.unexpected_error;
2961: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message;
2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);
2963: WHEN OTHERS THEN
2964: pv_return_code := jai_constants.unexpected_error;
2965: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900);
2966: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900));

Line 2966: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900));

2962: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || lv_return_message);
2963: WHEN OTHERS THEN
2964: pv_return_code := jai_constants.unexpected_error;
2965: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900);
2966: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ' || substr(sqlerrm,1,1900));
2967:
2968: end process_order;
2969:
2970: procedure process_supplement(

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

3347: OPEN get_exchange_rate;
3348: FETCH get_exchange_rate INTO v_exchange_rate;
3349: CLOSE get_exchange_rate;
3350:
3351: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Exchange rate '|| v_exchange_rate);
3352: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3353: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3354: G_MODULE_NAME || l_api_name || '.IN',
3355: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

3374: CLOSE created_from_cur;
3375:
3376:
3377: IF pr_new.interface_line_attribute4 IS NULL THEN
3378: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line att4 is null');
3379:
3380: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3381: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3382: G_MODULE_NAME || l_api_name || '.IN',

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

3388: CLOSE supplement_lines_check_cnsldt;
3389:
3390:
3391: ELSIF pr_new.interface_line_attribute4 IS NOT NULL THEN
3392: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line att4 is not null');
3393: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3394: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3395: G_MODULE_NAME || l_api_name || '.IN',
3396: G_PKG_NAME || ': ' || l_api_name || '().'||' Interface line att4 is not null '

Line 3404: /*FND_FILE.PUT_LINE(FND_FILE.LOG,

3400: FETCH supplement_lines_check INTO v_exist_flag;
3401: CLOSE supplement_lines_check;
3402: END IF;
3403:
3404: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
3405: ' Supplement lines check exists flag'|| v_exist_flag);*/
3406:
3407: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3408: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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

3474: v_last_update_login ,
3475: ln_legal_entity_id ,
3476: v_created_from --zhiwei
3477: );
3478: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Inside x <> 1: After insert into JAI_AR_TRXS');
3479: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3480: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3481: G_MODULE_NAME || l_api_name || '.IN',
3482: G_PKG_NAME || ': ' || l_api_name || '().'||' Inside x <> 1: After insert into JAI_AR_TRXS '

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

3570: v_bill_to_site_use_id , /*Bug 8371741*/
3571: v_trx_number ,
3572: v_batch_source_id;
3573:
3574: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3575: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id);
3576: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3577: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);*/
3578:

Line 3575: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id);

3571: v_trx_number ,
3572: v_batch_source_id;
3573:
3574: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3575: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id);
3576: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3577: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);*/
3578:
3579: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

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

3572: v_batch_source_id;
3573:
3574: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3575: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id);
3576: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3577: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);*/
3578:
3579: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3580: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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

3573:
3574: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to cust id: '|| v_bill_to_customer_id);
3575: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Bill to site use: '|| v_bill_to_site_use_id);
3576: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Trx number: '|| v_trx_number);
3577: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| v_batch_source_id);*/
3578:
3579: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3580: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3581: G_MODULE_NAME || l_api_name || '.IN',

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

3671: /**************** End of If Loop pr_new.interface_line_attribute1 IS NULL **********/
3672:
3673: IF pr_new.interface_line_attribute4 IS NULL THEN
3674:
3675: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is null');
3676: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3677: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3678: G_MODULE_NAME || l_api_name || '.IN',
3679: G_PKG_NAME || ': ' || l_api_name || '().'||' Int. line att4 is null '

Line 3689: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);

3685: v_excise_diff,
3686: v_assessable_value;
3687: CLOSE supplement_lines_info_cnsldt;
3688:
3689: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3690: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3691: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);*/
3692:
3693: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

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

3686: v_assessable_value;
3687: CLOSE supplement_lines_info_cnsldt;
3688:
3689: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3690: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3691: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);*/
3692:
3693: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3694: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 3691: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);*/

3687: CLOSE supplement_lines_info_cnsldt;
3688:
3689: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3690: FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3691: FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);*/
3692:
3693: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3694: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3695: G_MODULE_NAME || l_api_name || '.IN',

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

3703: OPEN supplement_lines_info_tax_catg;
3704: FETCH supplement_lines_info_tax_catg INTO v_tax_category_id;
3705: CLOSE supplement_lines_info_tax_catg;
3706:
3707: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3708: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3709: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3710: G_MODULE_NAME || l_api_name || '.IN',
3711: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

3713: );
3714: end if;
3715:
3716: ELSIF pr_new.INTERFACE_LINE_ATTRIBUTE4 IS NOT NULL THEN
3717: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att4 is not null');
3718: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3719: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3720: G_MODULE_NAME || l_api_name || '.IN',
3721: G_PKG_NAME || ': ' || l_api_name || '().'||' Int. line att4 is not null'

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

3726: v_tax_amount ,
3727: v_excise_diff ,
3728: v_assessable_value;
3729: CLOSE supplement_lines_info;
3730: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3731: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3732: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3733: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3734: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

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

3727: v_excise_diff ,
3728: v_assessable_value;
3729: CLOSE supplement_lines_info;
3730: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3731: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3732: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3733: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3734: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3735: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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

3728: v_assessable_value;
3729: CLOSE supplement_lines_info;
3730: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3731: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3732: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3733: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3734: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3735: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3736: G_MODULE_NAME || l_api_name || '.IN',

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

3729: CLOSE supplement_lines_info;
3730: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax category: '|| v_tax_category_id);
3731: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount: '|| v_tax_amount);
3732: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Excise diff: '|| v_excise_diff);
3733: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Assessable Value: '||v_assessable_value);
3734: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3735: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3736: G_MODULE_NAME || l_api_name || '.IN',
3737: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

3867: IF NVL(v_excise_diff ,0) > 0 THEN
3868:
3869: IF NVL(v_reg_code,'N') IN ('DOMESTIC_EXCISE','EXPORT_EXCISE') THEN
3870:
3871: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code: '||v_reg_code);
3872: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3873: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3874: G_MODULE_NAME || l_api_name || '.IN',
3875: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 3884: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);

3880: OPEN pref_cur(v_organization_id, v_location_id);
3881: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla;
3882: CLOSE pref_cur;
3883:
3884: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3885: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3886: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);*/
3887:
3888: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

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

3881: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla;
3882: CLOSE pref_cur;
3883:
3884: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3885: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3886: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);*/
3887:
3888: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3889: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 3886: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);*/

3882: CLOSE pref_cur;
3883:
3884: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23A: '|| v_pref_rg23a);
3885: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref RG23c: '||v_pref_rg23c);
3886: FND_FILE.PUT_LINE(FND_FILE.LOG,' Pref. PLA: '||v_pref_pla);*/
3887:
3888: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3889: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3890: G_MODULE_NAME || l_api_name || '.IN',

Line 3902: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);

3898: OPEN rg_bal_cur(v_organization_id, v_location_id);
3899: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;
3900: CLOSE rg_bal_cur;
3901:
3902: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3903: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3904: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);*/
3905: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3906: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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

3899: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance;
3900: CLOSE rg_bal_cur;
3901:
3902: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3903: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3904: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);*/
3905: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3906: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3907: G_MODULE_NAME || l_api_name || '.IN',

Line 3904: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);*/

3900: CLOSE rg_bal_cur;
3901:
3902: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Balance: RG23A:'||v_rg23a_balance);
3903: FND_FILE.PUT_LINE(FND_FILE.LOG,' RG23c: '||v_rg23c_balance);
3904: FND_FILE.PUT_LINE(FND_FILE.LOG,' PLA: '|| v_pla_balance);*/
3905: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3906: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3907: G_MODULE_NAME || l_api_name || '.IN',
3908: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

3915: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);
3916: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;
3917: CLOSE ssi_unit_flag_cur;
3918:
3919: --FND_FILE.PUT_LINE(FND_FILE.LOG,' SSI unit flag'||v_ssi_unit_flag);
3920: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
3921: FND_LOG.STRING(G_LEVEL_PROCEDURE,
3922: G_MODULE_NAME || l_api_name || '.IN',
3923: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

4007: OPEN register_code_meaning_cur(v_reg_code, 'REGISTER_TYPE');
4008: FETCH register_code_meaning_cur INTO v_meaning;
4009: CLOSE register_code_meaning_cur;
4010:
4011: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Meaning'|| v_meaning);
4012: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4013: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4014: G_MODULE_NAME || l_api_name || '.IN',
4015: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

4019: OPEN fin_year_cur(v_organization_id);
4020: FETCH fin_year_cur INTO v_fin_year;
4021: CLOSE fin_year_cur;
4022:
4023: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Fin year '|| v_fin_year);
4024: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4025:
4026: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4027: G_MODULE_NAME || l_api_name || '.IN',

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

4033: OPEN Batch_Source_Name_Cur(v_batch_source_id);
4034: FETCH Batch_Source_Name_Cur INTO v_order_invoice_type;
4035: CLOSE Batch_Source_Name_Cur;
4036:
4037: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Order invoice type: '|| v_order_invoice_type);
4038: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4039:
4040: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4041: G_MODULE_NAME || l_api_name || '.IN',

Line 4051: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);

4047: OPEN Def_Excise_Invoice_Cur(v_organization_id, v_location_id, v_fin_year, v_order_invoice_type, v_meaning);
4048: FETCH Def_Excise_Invoice_Cur INTO v_start_number, v_end_number, v_jump_by, v_prefix;
4049: CLOSE Def_Excise_Invoice_Cur;
4050:
4051: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
4052: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
4053: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
4054: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);*/
4055: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then

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

4048: FETCH Def_Excise_Invoice_Cur INTO v_start_number, v_end_number, v_jump_by, v_prefix;
4049: CLOSE Def_Excise_Invoice_Cur;
4050:
4051: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
4052: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
4053: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
4054: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);*/
4055: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4056:

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

4049: CLOSE Def_Excise_Invoice_Cur;
4050:
4051: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
4052: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
4053: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
4054: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);*/
4055: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4056:
4057: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 4054: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);*/

4050:
4051: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Start number'|| v_start_number);
4052: FND_FILE.PUT_LINE(FND_FILE.LOG,' End number:'|| v_end_number);
4053: FND_FILE.PUT_LINE(FND_FILE.LOG,' jump by: '|| v_jump_by);
4054: FND_FILE.PUT_LINE(FND_FILE.LOG,' prefix : '|| v_prefix);*/
4055: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4056:
4057: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4058: G_MODULE_NAME || l_api_name || '.IN',

Line 4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);

4262: EXCEPTION
4263: when le_error then
4264: pv_return_code := jai_constants.unexpected_error;
4265: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message;
4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);
4267: WHEN OTHERS THEN
4268: pv_return_code := jai_constants.unexpected_error;
4269: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900);
4270: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900));

Line 4270: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900));

4266: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || lv_return_message);
4267: WHEN OTHERS THEN
4268: pv_return_code := jai_constants.unexpected_error;
4269: pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900);
4270: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_SUPPLEMENT ' || substr(sqlerrm,1,1900));
4271:
4272: end process_supplement;
4273:
4274: /*

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

4554: the value of SOB.
4555: */
4556: v_gl_set_of_bks_id := pr_new.set_of_books_id;
4557:
4558: --FND_FILE.PUT_LINE(FND_FILE.LOG,' SOB id '|| v_gl_set_of_bks_id);
4559:
4560: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4561: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4562: G_MODULE_NAME || l_api_name || '.IN',

Line 4591: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );

4587: ||' loc id='||j_location_id
4588: ||' Batch source id='||j_batch_source_id);
4589: end if;
4590:
4591: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
4592: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
4593: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
4594: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);*/
4595:

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

4588: ||' Batch source id='||j_batch_source_id);
4589: end if;
4590:
4591: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
4592: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
4593: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
4594: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);*/
4595:
4596:

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

4589: end if;
4590:
4591: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
4592: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
4593: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
4594: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);*/
4595:
4596:
4597:

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

4590:
4591: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' header info.' );
4592: FND_FILE.PUT_LINE(FND_FILE.LOG, ' org id: '|| j_organization_id);
4593: FND_FILE.PUT_LINE(FND_FILE.LOG, ' loc id: '|| j_location_id);
4594: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Batch source id: '|| j_batch_source_id);*/
4595:
4596:
4597:
4598: jai_cmn_bond_register_pkg.get_register_id(

Line 4622: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);

4618: ||' Interface line attribute1='||pr_new.interface_line_attribute1
4619: ||' Interface line context='||pr_new.interface_line_context);
4620: end if;
4621:
4622: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
4623: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line attribute1 '||pr_new.interface_line_attribute1);
4624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line context '|| pr_new.interface_line_context);*/
4625:
4626: IF ( v_trans_type = 'CM'

Line 4623: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line attribute1 '||pr_new.interface_line_attribute1);

4619: ||' Interface line context='||pr_new.interface_line_context);
4620: end if;
4621:
4622: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
4623: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line attribute1 '||pr_new.interface_line_attribute1);
4624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line context '|| pr_new.interface_line_context);*/
4625:
4626: IF ( v_trans_type = 'CM'
4627: AND pr_new.interface_line_attribute1 = 'SUPPLEMENT CM'

Line 4624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line context '|| pr_new.interface_line_context);*/

4620: end if;
4621:
4622: /*FND_FILE.PUT_LINE(FND_FILE.LOG, ' Transaction type '|| v_trans_type);
4623: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line attribute1 '||pr_new.interface_line_attribute1);
4624: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Interface line context '|| pr_new.interface_line_context);*/
4625:
4626: IF ( v_trans_type = 'CM'
4627: AND pr_new.interface_line_attribute1 = 'SUPPLEMENT CM'
4628: AND pr_new.interface_line_context='INDIA INVOICES'

Line 4677: /*FND_FILE.PUT_LINE(FND_FILE.LOG,

4673: ||' Once completed flag ='||v_once_completed_flag
4674: );
4675: end if;
4676:
4677: /*FND_FILE.PUT_LINE(FND_FILE.LOG,
4678: ' Once completed flag '|| v_once_completed_flag);*/
4679:
4680:
4681: IF NVL(v_once_completed_flag,'N') = 'Y' THEN

Line 4736: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message);

4732: EXCEPTION
4733: WHEN le_error then
4734: Pv_return_code := jai_constants.unexpected_error;
4735: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message;
4736: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || lv_return_message);
4737: WHEN OTHERS THEN
4738: vsqlerrm := SQLERRM;
4739:
4740:

Line 4743: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900));

4739:
4740:
4741: Pv_return_code := jai_constants.unexpected_error;
4742: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900);
4743: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL ' || substr(sqlerrm,1,1900));
4744:
4745: /*lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4746: lv_err_msg := 'EXCEPTION Occured' ;
4747:

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

5122:
5123: l_api_name CONSTANT VARCHAR2(30) := 'process_bill_only_return()';
5124:
5125: begin
5126: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside Procedure process_bill_only_return');
5127: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5128: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5129: G_MODULE_NAME || l_api_name || '.BEGIN',
5130: G_PKG_NAME || ': ' || l_api_name || '()+');

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

5153: ||' Header exists ='||ln_hdr_exists
5154: );
5155: end if;
5156:
5157: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Header exists '|| ln_hdr_exists);
5158:
5159: if nvl(ln_hdr_exists,0) = 0 then
5160: /*
5161: no record exists in the JAI_AR_TRXS table for the customer trx id ,

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

5173: else
5174: ln_inv_orgn_id := pr_new.warehouse_id ;
5175: end if;
5176:
5177: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Inv orgn id: '|| ln_inv_orgn_id);
5178: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5179: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5180: G_MODULE_NAME || l_api_name || '.IN',
5181: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

5185: open c_default_location(ln_inv_orgn_id);
5186: fetch c_default_location into ln_default_locn_id;
5187: close c_default_location;
5188:
5189: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Default location id '|| ln_default_locn_id);
5190: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5191: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5192: G_MODULE_NAME || l_api_name || '.IN',
5193: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 5287: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRXS - Bill only invoice');

5283: 'N' ,
5284: NULL ,
5285: ln_legal_entity_id /* rallamse bug#4448789 */
5286: );
5287: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' After insert into JAI_AR_TRXS - Bill only invoice');
5288: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5289: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5290: G_MODULE_NAME || l_api_name || '.IN',
5291: G_PKG_NAME || ': ' || l_api_name || '().'||' After insert into JAI_AR_TRXS - Bill only invoice'

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

5301:
5302: open c_ont_source_code;
5303: fetch c_ont_source_code into v_ont_source_code;
5304: close c_ont_source_code;
5305: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code: '|| v_ont_source_code);
5306: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5307: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5308: G_MODULE_NAME || l_api_name || '.IN',
5309: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 5316: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code- after trunc: '|| v_ont_source_code);

5312: end if;
5313:
5314: v_ont_source_code := ltrim(rtrim(v_ont_source_code));
5315:
5316: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Ont source code- after trunc: '|| v_ont_source_code);
5317: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5318: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5319: G_MODULE_NAME || l_api_name || '.IN',
5320: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 5328: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att1: '||pr_new.interface_line_attribute11);

5324: /*
5325: return if it is discount line
5326: */
5327: if nvl(pr_new.interface_line_attribute11,'0') <> '0' then
5328: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Int. line att1: '||pr_new.interface_line_attribute11);
5329: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5330: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5331: G_MODULE_NAME || l_api_name || '.IN',
5332: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

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

5337: end if;
5338:
5339: for tax_rec in SO_RMA_TAX_LINES_INFO
5340: Loop
5341: --FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor SO_RMA_TAX_LINES_INFO');
5342: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
5343: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5344: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5345: G_MODULE_NAME || l_api_name || '.IN',

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

5338:
5339: for tax_rec in SO_RMA_TAX_LINES_INFO
5340: Loop
5341: --FND_FILE.PUT_LINE(FND_FILE.LOG,' cursor SO_RMA_TAX_LINES_INFO');
5342: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax type '|| tax_rec.tax_type);
5343: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5344: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5345: G_MODULE_NAME || l_api_name || '.IN',
5346: G_PKG_NAME || ': ' || l_api_name || '().'||' IN cursor SO_RMA_TAX_LINES_INFO:'

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

5348: );
5349: end if;
5350:
5351: if lv_register_code = 'BOND_REG' then
5352: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Register code '|| lv_register_code);
5353: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5354: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5355: G_MODULE_NAME || l_api_name || '.IN',
5356: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'

Line 5666: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');

5662: open c_get_amounts;
5663: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
5664: close c_get_amounts;
5665:
5666: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
5667: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
5668: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);*/
5669: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5670: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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

5663: fetch c_get_amounts into ln_tax_amount, ln_line_amount ;
5664: close c_get_amounts;
5665:
5666: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
5667: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
5668: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);*/
5669: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5670: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5671: G_MODULE_NAME || l_api_name || '.IN',

Line 5668: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);*/

5664: close c_get_amounts;
5665:
5666: /*FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor c_get_amounts');
5667: FND_FILE.PUT_LINE(FND_FILE.LOG,' Tax amount '|| ln_tax_amount);
5668: FND_FILE.PUT_LINE(FND_FILE.LOG,' Line amount '|| ln_line_amount);*/
5669: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5670: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5671: G_MODULE_NAME || l_api_name || '.IN',
5672: G_PKG_NAME || ': ' || l_api_name || '().'||' IN Cursor c_get_amounts:'

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

5791: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO:'
5792: ||' RMA record chk='||v_exist_flag
5793: );
5794: end if;
5795: --fnd_file.put_line(FND_FILE.LOG, ' RMA record chk:'|| v_exist_flag);
5796:
5797: IF NVL(v_exist_flag,0) <> 1 THEN
5798: RETURN;
5799: END IF;

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

5841: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO:'
5842: ||' before billonly return cursor='||ln_bill_return
5843: );
5844: end if;
5845: --fnd_file.put_line(fnd_file.log,' before billonly return cursor '|| ln_bill_return);
5846:
5847: ln_bill_return := 0;
5848: open c_bill_only_invoice(pr_new.customer_trx_line_id, 'R_RMA_FOR_CREDIT_WO_SHIPMENT');
5849: fetch c_bill_only_invoice into ln_bill_return;

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

5855: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO:'
5856: ||' after billonly return cursor='||ln_bill_return
5857: );
5858: end if;
5859: --fnd_file.put_line(fnd_file.log,' after billonly return cursor '|| ln_bill_return);
5860: if ln_bill_return = 1 then
5861: process_bill_only_return; --calling the procedure process_bill_only_return
5862: return;
5863: end if;

Line 6218: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message);

6214: EXCEPTION
6215: WHEN le_error then
6216: Pv_return_code := jai_constants.unexpected_error;
6217: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message;
6218: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || lv_return_message);
6219:
6220: WHEN OTHERS THEN
6221: Pv_return_code := jai_constants.unexpected_error;
6222: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900);

Line 6223: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900));

6219:
6220: WHEN OTHERS THEN
6221: Pv_return_code := jai_constants.unexpected_error;
6222: Pv_return_message := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900);
6223: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_RMACM ' || substr(sqlerrm,1,1900));
6224: END pop_jai_rmacm ;
6225:
6226:
6227:

Line 6698: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message);

6694: EXCEPTION
6695: WHEN le_error then
6696: pv_err_flg := jai_constants.unexpected_error;
6697: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message;
6698: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || lv_return_message);
6699:
6700: WHEN OTHERS THEN
6701: pv_err_flg := jai_constants.unexpected_error;
6702: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900);

Line 6703: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900));

6699:
6700: WHEN OTHERS THEN
6701: pv_err_flg := jai_constants.unexpected_error;
6702: pv_err_msg := 'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900);
6703: fnd_file.put_line(FND_FILE.LOG,'Encountered an error in JAI_AR_IMPORT_POPU_PKG.import_project_taxes ' || substr(sqlerrm,1,1900));
6704:
6705: --Added by Zhiwei for ZX prototype end
6706:
6707: end import_projects_taxes;

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

6773: FND_LOG.STRING(G_LEVEL_PROCEDURE,
6774: G_MODULE_NAME || l_api_name || '.BEGIN',
6775: G_PKG_NAME || ': ' || l_api_name || '()+');
6776: end if;
6777: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Function get_legal_entity_id');
6778:
6779: OPEN cur_legal_entity_id ;
6780: FETCH cur_legal_entity_id INTO ln_legal_entity_id ;
6781: CLOSE cur_legal_entity_id ;

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

6787: ||' Legal Entity Id ='||ln_legal_entity_id
6788: );
6789: end if;
6790:
6791: --FND_FILE.PUT_LINE(FND_FILE.LOG, ' Legal Entity Id: '|| ln_legal_entity_id);
6792: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
6793: FND_LOG.STRING(G_LEVEL_PROCEDURE,
6794: G_MODULE_NAME || l_api_name || '.END',
6795: G_PKG_NAME || ': ' || l_api_name || '()-');