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_LOG

Line 5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY JAI_AR_IMPORT_POPU_PKG AS
2: /* $Header: jai_ar_import_popu.plb 120.7.12020000.1 2013/03/12 07:16:31 appldev noship $ */
3:
4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

2: /* $Header: jai_ar_import_popu.plb 120.7.12020000.1 2013/03/12 07:16:31 appldev noship $ */
3:
4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

3:
4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

4:
5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_POPU_PKG.';

Line 9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

5: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_POPU_PKG.';
13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AR_IMPORT_POPU_PKG';

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_POPU_PKG.';
13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AR_IMPORT_POPU_PKG';
14:

Line 11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AR_IMPORT_POPU_PKG.';
13: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AR_IMPORT_POPU_PKG';
14:
15:

Line 551: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 || '()+');
554: end if;
555:

Line 575: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
578: ||' Header exists ='||ln_hdr_exists
579: );

Line 601: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
604: ||' Inv orgn id ='||ln_inv_orgn_id
605: );

Line 613: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
616: ||' Default location id ='||ln_default_locn_id
617: );

Line 717: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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'
720: );
721: end if;

Line 735: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
738: ||' Ont source code ='||v_ont_source_code
739: );

Line 745: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
748: ||' Ont source code- after trunc ='||v_ont_source_code
749: );

Line 757: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
760: ||' Int. line att1 ='||pr_new.interface_line_attribute11
761: );

Line 771: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 :'
774: ||' Tax type ='|| tax_rec.tax_type
775: );

Line 781: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 :'
784: ||' Register code ='|| v_register_code
785: );

Line 1127: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 :'
1130: ||' Tax amount ='|| ln_tax_amount
1131: ||';Line amount ='|| ln_line_amount

Line 1139: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 :'
1142: ||' VAT Invoice Number ='|| lv_vat_invoice_no
1143: );

Line 1203: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1199: );
1200: end if;
1201:
1202: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1203: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1204: G_MODULE_NAME || l_api_name || '.END',
1205: G_PKG_NAME || ': ' || l_api_name || '()-');
1206: end if;
1207:

Line 1265: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1261:
1262: pv_return_code := jai_constants.successful ;
1263:
1264: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1265: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1266: G_MODULE_NAME || l_api_name || '.BEGIN',
1267: G_PKG_NAME || ': ' || l_api_name || '()+');
1268: end if;
1269:

Line 1273: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1276: ||' ATO: v_item_type ='||v_item_type
1277: );

Line 1287: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1290: ||' Item type ='||v_item_type
1291: );

Line 1309: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1312: ||' Config line id ='||v_config_line_id
1313: );

Line 1326: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1329: ||' Tax Type ='||v_tax_type
1330: );

Line 1337: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 '
1340: );
1341: end if;

Line 1403: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 '
1406: );
1407: end if;

Line 1412: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1415: ||' Tax amount ='||v_tax_amount
1416: );

Line 1484: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
1486: G_PKG_NAME || ': ' || l_api_name || '().'||' Else - After insert into JAI_AR_TRX_TAX_LINES '
1487: );
1488: end if;

Line 1492: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1495: ||' Tax amount ='||v_tax_amount
1496: );

Line 1515: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1518: ||' Excise invoice number ='||v_ex_inv_no
1519: ||' ;Pmt reg ='||v_pmt_reg

Line 1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1540: ||' ATO: 1. v_organization_id ='||v_organization_id
1541: ||' ;v_location_id ='||v_location_id

Line 1551: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1554: ||' ATO: 2. v_organization_id ='||v_organization_id
1555: ||' ;v_location_id ='||v_location_id

Line 1622: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
1624: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
1625: ||' Created from ='||v_created_from
1626: ||' ;Trx number ='||v_trx_number

Line 1645: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1648: ||' Org id ='||v_organization_id
1649: ||' ;Loc id ='||v_location_id

Line 1661: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1664: ||' ATO- Org id ='||v_organization_id
1665: ||' ;ATO- Loc id ='||v_location_id

Line 1726: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1722: 'Y',
1723: ln_legal_entity_id
1724: );
1725: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1726: FND_LOG.STRING(G_LEVEL_PROCEDURE,
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;

Line 1843: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1846: ||' Inserted jai_ar_trx_lines for TRX LINE ID ='||v_customer_trx_line_id
1847: ||' ;Trx id ='||v_header_id

Line 1858: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
1861: ||' Ato tax amount =' ||v_ato_tax_amount
1862: ||' ;Ato tot amount ='||v_ato_total_amount

Line 1875: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1871: end if; -- end if for IF NVL(pr_new.Interface_line_attribute11,'0') ='0'
1872: end if;
1873:
1874: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1875: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1876: G_MODULE_NAME || l_api_name || '.END',
1877: G_PKG_NAME || ': ' || l_api_name || '()-');
1878: end if;
1879:

Line 1885: FND_LOG.STRING(G_LEVEL_PROCEDURE,

1881:
1882: begin
1883:
1884: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
1885: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1886: G_MODULE_NAME || l_api_name || '.BEGIN',
1887: G_PKG_NAME || ': ' || l_api_name || '()+');
1888: end if;
1889:

Line 1965: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
1967: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
1968: ||' v_organization_id =' ||v_organization_id
1969: ||' v_location_id =' ||v_location_id

Line 1981: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
1983: G_PKG_NAME || ': ' || l_api_name || '().'||'From Cursor so_picking_hdr_info_1:'
1984: ||' v_organization_id =' ||v_organization_id
1985: ||' v_location_id =' ||v_location_id

Line 2006: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
2008: G_PKG_NAME || ': ' || l_api_name || '().'||' ATO Header Info:'
2009: ||' v_organization_id =' ||v_organization_id
2010: ||' v_location_id =' ||v_location_id

Line 2028: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
2030: G_PKG_NAME || ': ' || l_api_name || '().'||' From Cursor c_so_picking_hdr_info_ns:'
2031: ||' v_organization_id =' ||v_organization_id
2032: ||' v_location_id =' ||v_location_id

Line 2630: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 '
2633: );
2634: end if;

Line 2654: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
2657: ||' Line cnt ='||v_line_count
2658: );

Line 2674: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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'
2677:
2678: );

Line 2844: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
2847: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
2848: ||' Excise amount ='||v_excise_amount

Line 2857: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
2860: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
2861: ||' Once complete flag ='||v_once_completed_flag

Line 2881: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
2884: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
2885: ||' so tax amount ='||v_so_tax_amount

Line 2954: FND_LOG.STRING(G_LEVEL_PROCEDURE,

2950: ---------------------------------------------------------
2951: --Added by Zhiwei for JAI Trigger elimination end
2952:
2953: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
2954: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2955: G_MODULE_NAME || l_api_name || '.END',
2956: G_PKG_NAME || ': ' || l_api_name || '()-');
2957: end if;
2958: EXCEPTION

Line 3353: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
3356: ||' Exchange rate ='||v_exchange_rate
3357: );

Line 3381: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
3383: G_PKG_NAME || ': ' || l_api_name || '().'||' Interface line att4 is null '
3384: );
3385: end if;

Line 3394: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 '
3397: );
3398: end if;

Line 3408: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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,
3409: G_MODULE_NAME || l_api_name || '.IN',
3410: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
3411: ||' Supplement lines check exists flag ='||v_exist_flag
3412: );

Line 3480: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 '
3483: );
3484: end if;

Line 3580: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
3582: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
3583: ||' Bill to cust id ='||v_bill_to_customer_id
3584: ||' Bill to site id ='||v_bill_to_site_use_id

Line 3677: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 '
3680: );
3681: end if;

Line 3694: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
3696: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
3697: ||' Tax amount ='||v_tax_amount
3698: ||' Excise diff ='||v_excise_diff

Line 3709: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
3712: ||' Tax category ='||v_tax_category_id
3713: );

Line 3719: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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'
3722: );
3723: end if;

Line 3735: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
3738: ||' Tax category =' ||v_tax_category_id
3739: ||' Tax amount =' ||v_tax_amount

Line 3873: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
3876: ||' Register code =' ||v_reg_code
3877: );

Line 3889: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
3891: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
3892: ||' Pref RG23A =' ||v_pref_rg23a
3893: ||' Pref RG23c =' ||v_pref_rg23c

Line 3906: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
3909: ||' Balance RG23A =' ||v_rg23a_balance
3910: ||' Balance RG23c =' ||v_rg23c_balance

Line 3921: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
3924: ||' SSI unit flag =' ||v_ssi_unit_flag
3925: );

Line 4013: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
4016: ||' Meaning =' ||v_meaning
4017: );

Line 4026: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
4028: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
4029: ||' Fin year =' ||v_fin_year
4030: );

Line 4040: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
4042: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
4043: ||' Order invoice type =' ||v_order_invoice_type
4044: );

Line 4057: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
4059: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
4060: ||' Start number =' ||v_start_number
4061: ||' End number =' ||v_end_number

Line 4538: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4534:
4535: /****************************** Validation 1 ********************************/
4536:
4537: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4538: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4539: G_MODULE_NAME || l_api_name || '.BEGIN',
4540: G_PKG_NAME || ': ' || l_api_name || '()+');
4541: end if;
4542:

Line 4544: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4540: G_PKG_NAME || ': ' || l_api_name || '()+');
4541: end if;
4542:
4543: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4544: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4545: G_MODULE_NAME || l_api_name || '.IN',
4546: G_PKG_NAME || ': ' || l_api_name || '().'||'Org id:'||v_org_id);
4547: end if;
4548:

Line 4561: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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',
4563: G_PKG_NAME || ': ' || l_api_name || '().'||'SOB id:'||v_gl_set_of_bks_id);
4564: end if;
4565:

Line 4583: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4579: CLOSE get_header_info_cur;
4580:
4581:
4582: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4583: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4584: G_MODULE_NAME || l_api_name || '.IN',
4585: G_PKG_NAME || ': ' || l_api_name || '().'||'HEADER INFO:'
4586: ||' org id='||j_organization_id
4587: ||' loc id='||j_location_id

Line 4614: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4610: CLOSE transaction_type_cur;
4611:
4612:
4613: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4614: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4615: G_MODULE_NAME || l_api_name || '.IN',
4616: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
4617: ||' Transaction type ='||v_trans_type
4618: ||' Interface line attribute1='||pr_new.interface_line_attribute1

Line 4670: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4666: CLOSE once_complete_flag_cur;
4667:
4668:
4669: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4670: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4671: G_MODULE_NAME || l_api_name || '.IN',
4672: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
4673: ||' Once completed flag ='||v_once_completed_flag
4674: );

Line 4728: FND_LOG.STRING(G_LEVEL_PROCEDURE,

4724: END IF;
4725:
4726: END IF;
4727: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
4728: FND_LOG.STRING(G_LEVEL_PROCEDURE,
4729: G_MODULE_NAME || l_api_name || '.END',
4730: G_PKG_NAME || ': ' || l_api_name || '()-');
4731: end if;
4732: EXCEPTION

Line 5128: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 || '()+');
5131: end if;
5132: ln_hdr_exists := 0;

Line 5150: FND_LOG.STRING(G_LEVEL_PROCEDURE,

5146: fetch c_check_hdr_exists into ln_hdr_exists;
5147: close c_check_hdr_exists;
5148:
5149: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5150: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5151: G_MODULE_NAME || l_api_name || '.IN',
5152: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
5153: ||' Header exists ='||ln_hdr_exists
5154: );

Line 5179: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
5182: ||' Inv orgn id ='||ln_inv_orgn_id
5183: );

Line 5191: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
5194: ||' Default location id ='||ln_default_locn_id
5195: );

Line 5289: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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'
5292: );
5293: end if;

Line 5307: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
5310: ||' Ont source code ='||v_ont_source_code
5311: );

Line 5318: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
5321: ||' Ont source code- after trunc ='||v_ont_source_code
5322: );

Line 5330: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
5333: ||' Int. line att1 ='||pr_new.interface_line_attribute11
5334: );

Line 5344: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
5347: ||' Tax type ='||tax_rec.tax_type
5348: );

Line 5354: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
5357: ||' Register code ='||lv_register_code
5358: );

Line 5670: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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:'
5673: ||' Tax amount ='||ln_tax_amount
5674: ||' Line amount ='||ln_line_amount

Line 5734: FND_LOG.STRING(G_LEVEL_PROCEDURE,

5730: );
5731: end if;
5732:
5733: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5734: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5735: G_MODULE_NAME || l_api_name || '.END',
5736: G_PKG_NAME || ': ' || l_api_name || '()-');
5737: end if;
5738:

Line 5748: FND_LOG.STRING(G_LEVEL_PROCEDURE,

5744: BEGIN
5745:
5746:
5747: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5748: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5749: G_MODULE_NAME || l_api_name || '.BEGIN',
5750: G_PKG_NAME || ': ' || l_api_name || '()+');
5751: end if;
5752:

Line 5789: FND_LOG.STRING(G_LEVEL_PROCEDURE,

5785: FETCH SO_RMA_RECORD_CHECK INTO v_exist_flag;
5786: CLOSE SO_RMA_RECORD_CHECK;
5787:
5788: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5789: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5790: G_MODULE_NAME || l_api_name || '.IN',
5791: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO:'
5792: ||' RMA record chk='||v_exist_flag
5793: );

Line 5839: FND_LOG.STRING(G_LEVEL_PROCEDURE,

5835:
5836: END IF; --NVL(ln_non_ship_flag,0) <> 1
5837:
5838: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5839: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5840: G_MODULE_NAME || l_api_name || '.IN',
5841: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO:'
5842: ||' before billonly return cursor='||ln_bill_return
5843: );

Line 5853: FND_LOG.STRING(G_LEVEL_PROCEDURE,

5849: fetch c_bill_only_invoice into ln_bill_return;
5850: close c_bill_only_invoice;
5851:
5852: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
5853: FND_LOG.STRING(G_LEVEL_PROCEDURE,
5854: G_MODULE_NAME || l_api_name || '.IN',
5855: G_PKG_NAME || ': ' || l_api_name || '().'||' PARAMS INFO:'
5856: ||' after billonly return cursor='||ln_bill_return
5857: );

Line 6209: FND_LOG.STRING(G_LEVEL_PROCEDURE,

6205: end if;
6206: ---------------------------------------------------------
6207: --Added by Zhiwei for JAI Trigger elimination end
6208: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
6209: FND_LOG.STRING(G_LEVEL_PROCEDURE,
6210: G_MODULE_NAME || l_api_name || '.END',
6211: G_PKG_NAME || ': ' || l_api_name || '()-');
6212: end if;
6213:

Line 6366: FND_LOG.STRING(G_LEVEL_PROCEDURE,

6362:
6363: begin
6364:
6365: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
6366: FND_LOG.STRING(G_LEVEL_PROCEDURE,
6367: G_MODULE_NAME || l_api_name || '.BEGIN',
6368: G_PKG_NAME || ': ' || l_api_name || '()+');
6369: end if;
6370:

Line 6688: FND_LOG.STRING(G_LEVEL_PROCEDURE,

6684:
6685: end if;
6686:
6687: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
6688: FND_LOG.STRING(G_LEVEL_PROCEDURE,
6689: G_MODULE_NAME || l_api_name || '.END',
6690: G_PKG_NAME || ': ' || l_api_name || '()-');
6691: end if;
6692:

Line 6773: FND_LOG.STRING(G_LEVEL_PROCEDURE,

6769: BEGIN
6770:
6771: --pv_return_code := jai_constants.successful ;
6772: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
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');

Line 6784: FND_LOG.STRING(G_LEVEL_PROCEDURE,

6780: FETCH cur_legal_entity_id INTO ln_legal_entity_id ;
6781: CLOSE cur_legal_entity_id ;
6782:
6783: if (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) then
6784: FND_LOG.STRING(G_LEVEL_PROCEDURE,
6785: G_MODULE_NAME || l_api_name || '.IN',
6786: G_PKG_NAME || ': ' || l_api_name || '().'||'PARAMS INFO:'
6787: ||' Legal Entity Id ='||ln_legal_entity_id
6788: );

Line 6793: FND_LOG.STRING(G_LEVEL_PROCEDURE,

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 || '()-');
6796: end if;
6797: RETURN ln_legal_entity_id ;