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_AP_TDS_ETDS_PKG dependencies on FND_LOG

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

248: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
249: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
250: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
251:
252: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
253: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
254: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
255: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
256: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

249: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
250: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
251:
252: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
253: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
254: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
255: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
256: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
257: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

250: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
251:
252: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
253: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
254: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
255: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
256: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
257: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
258: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

251:
252: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
253: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
254: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
255: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
256: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
257: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
258: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
259: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_ETDS_PKG.';

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

252: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
253: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
254: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
255: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
256: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
257: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
258: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
259: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_ETDS_PKG.';
260: G_INVOICE_VALIDATE CONSTANT VARCHAR2(40) := 'INVOICE VALIDATE';

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

253: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
254: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
255: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
256: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
257: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
258: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
259: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_ETDS_PKG.';
260: G_INVOICE_VALIDATE CONSTANT VARCHAR2(40) := 'INVOICE VALIDATE';
261: G_PREPAYMENT_APPLICATION CONSTANT VARCHAR2(40) := 'PREPAYMENT APPLICATION';

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

254: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
255: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
256: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
257: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
258: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
259: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_ETDS_PKG.';
260: G_INVOICE_VALIDATE CONSTANT VARCHAR2(40) := 'INVOICE VALIDATE';
261: G_PREPAYMENT_APPLICATION CONSTANT VARCHAR2(40) := 'PREPAYMENT APPLICATION';
262: G_PREPAYMENT_UNAPPLICATION CONSTANT VARCHAR2(40) := 'PREPAYMENT UNAPPLICATION';

Line 1987: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');

1983: -- end 5647248
1984: END populate_include_exclude_list;
1985:
1986: BEGIN
1987: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1988: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_batch_id: '||p_batch_id);
1989: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_tan_num: '||p_org_tan_num);
1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);
1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);

Line 1988: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_batch_id: '||p_batch_id);

1984: END populate_include_exclude_list;
1985:
1986: BEGIN
1987: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1988: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_batch_id: '||p_batch_id);
1989: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_tan_num: '||p_org_tan_num);
1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);
1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);
1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);

Line 1989: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_tan_num: '||p_org_tan_num);

1985:
1986: BEGIN
1987: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1988: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_batch_id: '||p_batch_id);
1989: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_tan_num: '||p_org_tan_num);
1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);
1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);
1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);
1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);

Line 1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);

1986: BEGIN
1987: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1988: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_batch_id: '||p_batch_id);
1989: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_tan_num: '||p_org_tan_num);
1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);
1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);
1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);
1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);
1994: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_include_list: '||p_include_list);

Line 1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);

1987: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1988: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_batch_id: '||p_batch_id);
1989: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_tan_num: '||p_org_tan_num);
1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);
1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);
1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);
1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);
1994: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_include_list: '||p_include_list);
1995: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exclude_list: '||p_exclude_list);

Line 1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);

1988: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_batch_id: '||p_batch_id);
1989: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_tan_num: '||p_org_tan_num);
1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);
1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);
1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);
1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);
1994: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_include_list: '||p_include_list);
1995: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exclude_list: '||p_exclude_list);
1996: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_organization_id: '|| p_organization_id);

Line 1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);

1989: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_tan_num: '||p_org_tan_num);
1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);
1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);
1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);
1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);
1994: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_include_list: '||p_include_list);
1995: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exclude_list: '||p_exclude_list);
1996: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_organization_id: '|| p_organization_id);
1997:

Line 1994: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_include_list: '||p_include_list);

1990: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_id: '||p_tds_vendor_id);
1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);
1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);
1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);
1994: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_include_list: '||p_include_list);
1995: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exclude_list: '||p_exclude_list);
1996: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_organization_id: '|| p_organization_id);
1997:
1998: lv_include.extend(10);

Line 1995: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exclude_list: '||p_exclude_list);

1991: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_vendor_site_id: '||p_tds_vendor_site_id);
1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);
1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);
1994: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_include_list: '||p_include_list);
1995: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exclude_list: '||p_exclude_list);
1996: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_organization_id: '|| p_organization_id);
1997:
1998: lv_include.extend(10);
1999: lv_exclude.extend(10);

Line 1996: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_organization_id: '|| p_organization_id);

1992: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_from_date: '||p_tds_inv_from_date);
1993: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_tds_inv_to_date: '||p_tds_inv_to_date);
1994: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_include_list: '||p_include_list);
1995: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exclude_list: '||p_exclude_list);
1996: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_organization_id: '|| p_organization_id);
1997:
1998: lv_include.extend(10);
1999: lv_exclude.extend(10);
2000: --Date 11-05-2007 by Sacsethi for bug 5647248

Line 2116: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name, 'After insert into JAI_AP_ETDS_T batch_id:' || p_batch_id);

2112: and upper(a.section_code) not in ( lv_exclude(1),lv_exclude(2),lv_exclude(3),lv_exclude(4),lv_exclude(5)
2113: ,lv_exclude(6),lv_exclude(7),lv_exclude(8),lv_exclude(9),lv_exclude(10))))
2114: ;
2115:
2116: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name, 'After insert into JAI_AP_ETDS_T batch_id:' || p_batch_id);
2117: --2). Update payments infomation for paid TDS transactions (inserted from setp 1)
2118: --Update payment status and tds cess, sh tds cess, surcharge amount for paid transacations
2119: FOR dtl IN (select a.rowid row_id
2120: ,a.*

Line 2131: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name, 'in Loop for TDS invoice: ' || dtl.tds_invoice_id);

2127: and a.base_invoice_id = b.invoice_id
2128: and a.tds_invoice_id not in ( -9999, -9997) )
2129: LOOP
2130:
2131: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name, 'in Loop for TDS invoice: ' || dtl.tds_invoice_id);
2132: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name, 'in Loop for TDS tds_check_id: ' || dtl.tds_check_id);
2133:
2134: --added by csahoo for bug#5975168, start
2135: ln_con_for_challan := 1;

Line 2132: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name, 'in Loop for TDS tds_check_id: ' || dtl.tds_check_id);

2128: and a.tds_invoice_id not in ( -9999, -9997) )
2129: LOOP
2130:
2131: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name, 'in Loop for TDS invoice: ' || dtl.tds_invoice_id);
2132: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name, 'in Loop for TDS tds_check_id: ' || dtl.tds_check_id);
2133:
2134: --added by csahoo for bug#5975168, start
2135: ln_con_for_challan := 1;
2136: ln_con_for_deductee := 1;

Line 2216: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,' consider for challan '|| ln_con_for_challan);

2212:
2213: IF ln_check_number IS NULL THEN
2214: ln_con_for_challan := 0;
2215: fnd_file.put_line(FND_FILE.LOG, ' consider for challan '|| ln_con_for_challan);
2216: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,' consider for challan '|| ln_con_for_challan);
2217: GOTO update_now;
2218: END IF ;
2219:
2220: IF v_tds_check_id IS NULL THEN

Line 2222: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,v_challan_err);

2218: END IF ;
2219:
2220: IF v_tds_check_id IS NULL THEN
2221: v_challan_err := 'Payment Information not available for TDS Inv';
2222: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,v_challan_err);
2223: GOTO update_now;
2224: END IF;
2225:
2226: IF v_bank_branch_code IS NULL THEN

Line 2233: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,'v_challan_err: ' || v_challan_err);

2229: v_challan_err := 'Challan Number is not found for TDS Inv';
2230: ELSIF v_challan_date IS NULL THEN
2231: v_challan_err := 'Challan Date is not found for TDS Inv';
2232: END IF;
2233: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,'v_challan_err: ' || v_challan_err);
2234:
2235: v_statement_id := '3d';
2236: OPEN c_base_payment_check_id(dtl.base_invoice_id);
2237: FETCH c_base_payment_check_id INTO v_base_invoice_check_id, v_temp_bank_acc_name, v_base_check_date;

Line 2274: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'lengths - inv_type:' || length(dtl.inv_type)

2270: FND_FILE.put_line(FND_FILE.log, 'lengths - inv_type:'||length(dtl.inv_type)
2271: ||', ch_num:'||length(v_challan_num) ||', bank_brCode:'||length(v_bank_branch_code) ||', ch_err:'
2272: ||', ded_err:'||length(v_deductee_err)
2273: );
2274: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'lengths - inv_type:' || length(dtl.inv_type)
2275: ||', ch_num:'||length(v_challan_num) ||', bank_brCode:'||length(v_bank_branch_code) ||', ch_err:'
2276: ||', ded_err:'||length(v_deductee_err));
2277: END IF ;
2278: END IF;

Line 2398: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');

2394: AND base_taxabale_amount IS NULL;
2395:
2396: --Modified by Xiao Lv for bug#7662155, end
2397:
2398: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2402: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 2401: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

2397:
2398: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
2399: EXCEPTION
2400: WHEN OTHERS THEN
2401: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2402: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2403: ,SQLCODE || ':' || SQLERRM);
2404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2405: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 2404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

2400: WHEN OTHERS THEN
2401: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2402: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2403: ,SQLCODE || ':' || SQLERRM);
2404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2405: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2406: ,'statement->'||v_statement_id
2407: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
2408: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);