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

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

25: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
26: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
27: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
28:
29: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
31: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

26: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
27: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
28:
29: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
31: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

27: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
28:
29: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
31: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

28:
29: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
31: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
36: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_POP_RPST_PKG.';

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

29: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
31: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
36: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_POP_RPST_PKG.';
37: G_INVOICE_VALIDATE CONSTANT VARCHAR2(40) := 'INVOICE VALIDATE';

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

30: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
31: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
36: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_POP_RPST_PKG.';
37: G_INVOICE_VALIDATE CONSTANT VARCHAR2(40) := 'INVOICE VALIDATE';
38: G_PREPAYMENT_APPLICATION CONSTANT VARCHAR2(40) := 'PREPAYMENT APPLICATION';

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

31: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
36: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_POP_RPST_PKG.';
37: G_INVOICE_VALIDATE CONSTANT VARCHAR2(40) := 'INVOICE VALIDATE';
38: G_PREPAYMENT_APPLICATION CONSTANT VARCHAR2(40) := 'PREPAYMENT APPLICATION';
39: G_PREPAYMENT_UNAPPLICATION CONSTANT VARCHAR2(40) := 'PREPAYMENT UNAPPLICATION';

Line 80: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name , 'Get Inovice Type: '|| ln_tds_invoice_type );

76: ELSIF pv_tds_event = G_SURCHARGE_ROLLBACK THEN
77: ln_tds_invoice_type := 'SURCHARGE ROLLBACK';
78: END IF;
79:
80: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name , 'Get Inovice Type: '|| ln_tds_invoice_type );
81: return ln_tds_invoice_type;
82: END get_tds_invoice_type;
83:
84: FUNCTION map_tds_tax_to_ctg(p_tax_id IN NUMBER)RETURN NUMBER

Line 104: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name , 'Mapping tax id: '|| p_tax_id ||' to category: ' || ln_tax_categeory_id);

100: FETCH c_get_category into ln_tax_categeory_id;
101: CLOSE c_get_category;
102: END IF;
103:
104: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name , 'Mapping tax id: '|| p_tax_id ||' to category: ' || ln_tax_categeory_id);
105: RETURN ln_tax_categeory_id;
106:
107: END map_tds_tax_to_ctg;
108:

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

286: ln_inv_distribution_id NUMBER;
287: ln_inv_prepy_distribution_id NUMBER;
288: l_api_name CONSTANT VARCHAR2(50) := 'populate_repository()';
289: BEGIN
290: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
291: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_source_invoice_id: '||pn_source_invoice_id);
292: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_id: '||pn_invoice_id);
293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);
294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);

Line 291: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_source_invoice_id: '||pn_source_invoice_id);

287: ln_inv_prepy_distribution_id NUMBER;
288: l_api_name CONSTANT VARCHAR2(50) := 'populate_repository()';
289: BEGIN
290: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
291: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_source_invoice_id: '||pn_source_invoice_id);
292: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_id: '||pn_invoice_id);
293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);
294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);
295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);

Line 292: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_id: '||pn_invoice_id);

288: l_api_name CONSTANT VARCHAR2(50) := 'populate_repository()';
289: BEGIN
290: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
291: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_source_invoice_id: '||pn_source_invoice_id);
292: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_id: '||pn_invoice_id);
293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);
294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);
295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);
296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);

Line 293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);

289: BEGIN
290: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
291: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_source_invoice_id: '||pn_source_invoice_id);
292: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_id: '||pn_invoice_id);
293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);
294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);
295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);
296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);
297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);

Line 294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);

290: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
291: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_source_invoice_id: '||pn_source_invoice_id);
292: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_id: '||pn_invoice_id);
293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);
294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);
295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);
296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);
297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);
298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);

Line 295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);

291: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_source_invoice_id: '||pn_source_invoice_id);
292: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_id: '||pn_invoice_id);
293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);
294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);
295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);
296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);
297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);
298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);
299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);

Line 296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);

292: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_id: '||pn_invoice_id);
293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);
294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);
295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);
296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);
297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);
298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);
299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);
300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_distribution_id: ' || pn_invoice_distribution_id);

Line 297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);

293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_event: '||pv_event);
294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);
295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);
296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);
297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);
298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);
299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);
300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_distribution_id: ' || pn_invoice_distribution_id);
301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepay_distribution_id: ' || pn_prepay_distribution_id);

Line 298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);

294: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_type: '||pv_section_type);
295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);
296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);
297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);
298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);
299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);
300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_distribution_id: ' || pn_invoice_distribution_id);
301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepay_distribution_id: ' || pn_prepay_distribution_id);
302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'Pn_tax_category_id: ' || Pn_tax_category_id);

Line 299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);

295: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pv_section_code: '||pv_section_code);
296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);
297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);
298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);
299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);
300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_distribution_id: ' || pn_invoice_distribution_id);
301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepay_distribution_id: ' || pn_prepay_distribution_id);
302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'Pn_tax_category_id: ' || Pn_tax_category_id);
303:

Line 300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_distribution_id: ' || pn_invoice_distribution_id);

296: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_grp_id: '||pn_threshold_grp_id);
297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);
298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);
299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);
300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_distribution_id: ' || pn_invoice_distribution_id);
301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepay_distribution_id: ' || pn_prepay_distribution_id);
302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'Pn_tax_category_id: ' || Pn_tax_category_id);
303:
304:

Line 301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepay_distribution_id: ' || pn_prepay_distribution_id);

297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_hdr_id: '||pn_threshold_hdr_id);
298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);
299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);
300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_distribution_id: ' || pn_invoice_distribution_id);
301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepay_distribution_id: ' || pn_prepay_distribution_id);
302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'Pn_tax_category_id: ' || Pn_tax_category_id);
303:
304:
305: /*Surcharge calculate and rollback will split amount, no need populating repository

Line 302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'Pn_tax_category_id: ' || Pn_tax_category_id);

298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_type_id: '||pn_threshold_type_id);
299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_threshold_slab_id: '|| pn_threshold_slab_id);
300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_invoice_distribution_id: ' || pn_invoice_distribution_id);
301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepay_distribution_id: ' || pn_prepay_distribution_id);
302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'Pn_tax_category_id: ' || Pn_tax_category_id);
303:
304:
305: /*Surcharge calculate and rollback will split amount, no need populating repository
306: Already processed in jai_ap_dtc_generation_pkg.threshold_transiton*/

Line 324: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Set info TDS invoice: ' || pn_invoice_id);

320: r_jai_ap_tds_repository.invoice_id := pn_invoice_id;
321: r_jai_ap_tds_repository.REQUIRED_FOR_ETDS := G_N; --Added for bug#16889298
322:
323: IF pn_invoice_id IS NOT NULL AND pn_invoice_id NOT IN (-9999, -9997) THEN
324: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Set info TDS invoice: ' || pn_invoice_id);
325:
326: OPEN c_get_trx_tds_info(pn_invoice_id);
327: FETCH c_get_trx_tds_info into r_c_get_trx_tds_info;
328: CLOSE c_get_trx_tds_info;

Line 342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');

338: r_jai_ap_tds_repository.tax_category_id := r_c_get_trx_tds_info.tax_category_id;
339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');

Line 343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');

339: r_jai_ap_tds_repository.TDS_AUTHORITY_ID := r_c_get_trx_tds_info.tds_authority_vendor_id;
340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');

Line 344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');

340: r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID := r_c_get_trx_tds_info.tds_authority_vendor_site_id;
341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');

Line 345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');

341:
342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');

Line 346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');

342: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: Invoice_number[' || r_jai_ap_tds_repository.Invoice_number || '],');
343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');

Line 347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');

343: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_ACCOUNTING_DATE[' || r_jai_ap_tds_repository.TDS_ACCOUNTING_DATE || '],');
344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');

Line 348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');

344: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INVOICE_TYPE[' || r_jai_ap_tds_repository.TDS_INVOICE_TYPE || '],');
345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');

Line 349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');

345: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: threshold_hdr_id[' || r_jai_ap_tds_repository.threshold_hdr_id || '],');
346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');

Line 350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');

346: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_TYPE_ID[' || r_jai_ap_tds_repository.THRESHOLD_TYPE_ID || '],');
347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');
354:

Line 351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');

347: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: THRESHOLD_SLAB_ID[' || r_jai_ap_tds_repository.THRESHOLD_SLAB_ID || '],');
348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');
354:
355: IF pv_section_type <> G_TDS_SECTION THEN

Line 352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');

348: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_INV_TAX_AMOUNT[' || r_jai_ap_tds_repository.TDS_INV_TAX_AMOUNT || '],');
349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');
354:
355: IF pv_section_type <> G_TDS_SECTION THEN
356: --when section type in WCT or ESSI, get effective rate by WCT/ESSI from tax code

Line 353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');

349: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: SUPPLIER_CM_AMOUNT[' || r_jai_ap_tds_repository.SUPPLIER_CM_AMOUNT || '],');
350: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: BASE_TAX_AMOUNT[' || r_jai_ap_tds_repository.BASE_TAX_AMOUNT || '],');
351: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: tax_category_id[' || r_jai_ap_tds_repository.tax_category_id || '],');
352: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_ID || '],');
353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'TDS info: TDS_AUTHORITY_SITE_ID[' || r_jai_ap_tds_repository.TDS_AUTHORITY_SITE_ID || '],');
354:
355: IF pv_section_type <> G_TDS_SECTION THEN
356: --when section type in WCT or ESSI, get effective rate by WCT/ESSI from tax code
357: --Assume that in given TDS tax category, only one tax in WCT/ESSI type and its precedence always be 0.

Line 387: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Set Source invoice info: ' || pn_source_invoice_id);

383: /*Threshold transition or threshold rollback can'tderive source invoice id*/
384: --ISSUE: for threshold rollback and threshold transition do we need split TDS invoice into each source invoice?
385: --Confirmed. Just use the trigger invoice id for threshold transition and rollback
386: IF pn_source_invoice_id IS NOT NULL THEN
387: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Set Source invoice info: ' || pn_source_invoice_id);
388:
389: OPEN c_get_inv_info(pn_source_invoice_id);
390: FETCH c_get_inv_info into r_c_get_inv_info;
391: CLOSE c_get_inv_info;

Line 433: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,

429:
430:
431: --Process application/unapplication concerning info
432: IF pv_event IN (G_PREPAYMENT_APPLICATION, G_PREPAYMENT_UNAPPLICATION) THEN
433: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,
434: 'Set prepayment application info: ' || pv_event || ' : ' || pn_prepay_distribution_id);
435:
436: --IF pn_invoice_id IS NOT NULL AND pn_invoice_id NOT IN (-9999, -9997) THEN
437: IF r_c_get_trx_tds_info.threshold_trx_id IS NOT NULL THEN

Line 470: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_inv_prepy_distribution_id:' || ln_inv_prepy_distribution_id);

466: END IF;
467:
468: ln_inv_prepy_distribution_id := NVL(ln_inv_prepy_distribution_id, pn_prepay_distribution_id);
469: ln_inv_distribution_id := NVL(ln_inv_distribution_id, pn_invoice_distribution_id);
470: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_inv_prepy_distribution_id:' || ln_inv_prepy_distribution_id);
471: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_inv_distribution_id:' || ln_inv_distribution_id);
472:
473: --derive apply from prepayment invoice info
474: OPEN c_get_apply_fromto_inv(ln_inv_prepy_distribution_id);

Line 471: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_inv_distribution_id:' || ln_inv_distribution_id);

467:
468: ln_inv_prepy_distribution_id := NVL(ln_inv_prepy_distribution_id, pn_prepay_distribution_id);
469: ln_inv_distribution_id := NVL(ln_inv_distribution_id, pn_invoice_distribution_id);
470: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_inv_prepy_distribution_id:' || ln_inv_prepy_distribution_id);
471: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_inv_distribution_id:' || ln_inv_distribution_id);
472:
473: --derive apply from prepayment invoice info
474: OPEN c_get_apply_fromto_inv(ln_inv_prepy_distribution_id);
475: FETCH c_get_apply_fromto_inv INTO r_c_get_apply_fromto_inv;

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

518:
519: --Call procedure to insert one line into repository table.
520: insert_jai_tds_repository(r_jai_ap_tds_repository);
521:
522: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
523: EXCEPTION
524: WHEN OTHERS THEN
525: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
526: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 525: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

521:
522: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
523: EXCEPTION
524: WHEN OTHERS THEN
525: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
526: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
527: ,SQLCODE || ':' || SQLERRM);
528: RAISE;
529: END populate_repository;

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

535: PROCEDURE process_cancellation(pn_source_invoice_id IN NUMBER)
536: IS
537: l_api_name CONSTANT VARCHAR2(50) := 'process_cancellation()';
538: BEGIN
539: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
540:
541: If pn_source_invoice_id is not null then
542: Update jai_ap_tds_repository jatr
543: Set jatr.source_invoice_deleted = G_Y

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

543: Set jatr.source_invoice_deleted = G_Y
544: ,jatr.invoice_deleted = G_Y
545: Where source_invoice_id = pn_source_invoice_id;
546: End if;
547: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
548: EXCEPTION
549: WHEN OTHERS THEN
550: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
551: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 550: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

546: End if;
547: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
548: EXCEPTION
549: WHEN OTHERS THEN
550: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
551: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
552: ,SQLCODE || ':' || SQLERRM);
553: RAISE;
554: END process_cancellation;

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

618: r_jai_ap_tds_repo_lines jai_ap_tds_repo_lines%rowtype;
619:
620: l_api_name CONSTANT VARCHAR2(50) := 'process_surcharge()';
621: BEGIN
622: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
623:
624:
625: IF pv_event = G_SURCHARGE_ROLLBACK THEN
626: --Process Surcharge rollback, mark all surcharge tax code to surcharge_rollback = 'Y'

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

669: END LOOP;
670: END IF;
671:
672:
673: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
674: EXCEPTION
675: WHEN OTHERS THEN
676: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
677: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 676: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

672:
673: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
674: EXCEPTION
675: WHEN OTHERS THEN
676: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
677: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
678: ,SQLCODE || ':' || SQLERRM);
679: RAISE;
680: END process_surcharge;

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

692: )
693: IS
694: l_api_name CONSTANT VARCHAR2(50) := 'populate_challan_info()';
695: BEGIN
696: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
697: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_invoice_id || ': '|| pn_invoice_id);
698: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_challan_no || ': '|| pn_challan_no);
699:
700: IF pn_invoice_id IS NOT NULL THEN

Line 697: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_invoice_id || ': '|| pn_invoice_id);

693: IS
694: l_api_name CONSTANT VARCHAR2(50) := 'populate_challan_info()';
695: BEGIN
696: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
697: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_invoice_id || ': '|| pn_invoice_id);
698: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_challan_no || ': '|| pn_challan_no);
699:
700: IF pn_invoice_id IS NOT NULL THEN
701: --update challan information, and TDS_PAID,REQUIRED_FOR_ETDS as 'Y'

Line 698: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_challan_no || ': '|| pn_challan_no);

694: l_api_name CONSTANT VARCHAR2(50) := 'populate_challan_info()';
695: BEGIN
696: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
697: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_invoice_id || ': '|| pn_invoice_id);
698: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.Parameters', pn_challan_no || ': '|| pn_challan_no);
699:
700: IF pn_invoice_id IS NOT NULL THEN
701: --update challan information, and TDS_PAID,REQUIRED_FOR_ETDS as 'Y'
702: UPDATE jai_ap_tds_repository jatr

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

710: WHERE jatr.invoice_id = pn_invoice_id
711: ;
712: END IF;
713:
714: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
715: EXCEPTION
716: WHEN OTHERS THEN
717: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
718: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 717: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

713:
714: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
715: EXCEPTION
716: WHEN OTHERS THEN
717: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
718: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
719: ,SQLCODE || ':' || SQLERRM);
720: RAISE;
721: END populate_challan_info;

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

903:
904:
905: l_api_name CONSTANT VARCHAR2(50) := 'process_etds_migration()';
906: BEGIN
907: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
908:
909: --Derive tds regime ID and code from regime setup
910: OPEN c_get_tax_regime_info(G_TDS);
911: FETCH c_get_tax_regime_info INTO r_c_get_tax_regime_info;

Line 2052: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax_type: ' ||r_c_get_taxes_info.tax_type || ' tax_id: ' || r_c_get_taxes_info.tax_id);

2048: AND jcta.tax_id = jctcl.tax_id
2049: AND jcta.tax_type IN (G_TDS, G_TDS_EDUCATION_CESS, G_TDS_EDUCATION_CESS, G_TDS_SURCHARGE)
2050: )
2051: LOOP
2052: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax_type: ' ||r_c_get_taxes_info.tax_type || ' tax_id: ' || r_c_get_taxes_info.tax_id);
2053:
2054: r_jai_ap_tds_repo_lines := NULL;
2055: r_jai_ap_tds_repo_lines.invoice_id := r_tds_rpsty_rec.INVOICE_ID;
2056: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;

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

2069: END IF;
2070:
2071: END LOOP;
2072:
2073: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2077: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 2076: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

2072:
2073: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2077: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2078: ,SQLCODE || ':' || SQLERRM);
2079: RAISE;
2080: END process_etds_migration;

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

2113: r_c_get_taxes_info c_get_taxes_info%rowtype;
2114: r_jai_ap_tds_repo_lines jai_ap_tds_repo_lines%rowtype;
2115: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_tds_repository()';
2116: BEGIN
2117: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
2118:
2119:
2120: INSERT INTO jai_ap_tds_repository
2121: (TDS_REPOSITORY_ID

Line 2257: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Process eTDS repository line population');

2253: ,pr_jai_ap_tds_repository.LAST_UPDATE_LOGIN
2254: ,pr_jai_ap_tds_repository.LAST_UPDATED_BY
2255: );
2256:
2257: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Process eTDS repository line population');
2258:
2259: IF pr_jai_ap_tds_repository.INVOICE_ID IS NOT NULL THEN
2260: --If TDS invoice created, populate repository lines for each tax id
2261: --(assume each tax type only exists one tax code)

Line 2264: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax_type ' ||rec_tax.tax_type || ' tax_id: ' || rec_tax.tax_id);

2260: --If TDS invoice created, populate repository lines for each tax id
2261: --(assume each tax type only exists one tax code)
2262: FOR rec_tax IN c_get_invoice_line_info(pr_jai_ap_tds_repository.INVOICE_ID)
2263: LOOP
2264: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax_type ' ||rec_tax.tax_type || ' tax_id: ' || rec_tax.tax_id);
2265:
2266: OPEN c_get_taxes_info(p_tax_type => rec_tax.tax_type
2267: ,p_tax_id => rec_tax.tax_id
2268: );

Line 2273: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@1');

2269: FETCH c_get_taxes_info INTO r_c_get_taxes_info;
2270: CLOSE c_get_taxes_info;
2271:
2272: r_jai_ap_tds_repo_lines := NULL;
2273: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@1');
2274: r_jai_ap_tds_repo_lines.invoice_id := pr_jai_ap_tds_repository.INVOICE_ID;
2275: r_jai_ap_tds_repo_lines.tax_id := r_c_get_taxes_info.tax_id;
2276: r_jai_ap_tds_repo_lines.tax_name := r_c_get_taxes_info.tax_name;
2277: r_jai_ap_tds_repo_lines.tax_type := r_c_get_taxes_info.tax_type;

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

2286: END LOOP;
2287:
2288: END IF;
2289:
2290: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2294: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 2293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

2289:
2290: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2294: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2295: ,SQLCODE || ':' || SQLERRM);
2296: RAISE;
2297: END insert_jai_tds_repository;

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

2303: PROCEDURE insert_jai_ap_tds_repo_lines(pr_jai_ap_tds_repo_lines IN jai_ap_tds_repo_lines%rowtype)
2304: IS
2305: l_api_name CONSTANT VARCHAR2(50) := 'insert_jai_ap_tds_repo_lines()';
2306: BEGIN
2307: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.BEGIN', G_PKG_NAME || ': '|| l_api_name || '()+');
2308:
2309: INSERT INTO jai_ap_tds_repo_lines
2310: (INVOICE_ID
2311: ,TAX_ID

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

2332: ,pr_jai_ap_tds_repo_lines.LAST_UPDATE_LOGIN
2333: ,pr_jai_ap_tds_repo_lines.LAST_UPDATED_BY
2334: );
2335:
2336: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
2337: EXCEPTION
2338: WHEN OTHERS THEN
2339: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2340: ,G_MODULE_NAME||l_api_name||'. Other_Exception'

Line 2339: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE

2335:
2336: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME || '.' || l_api_name ||'.END', G_PKG_NAME || ': '|| l_api_name || '()-');
2337: EXCEPTION
2338: WHEN OTHERS THEN
2339: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2340: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2341: ,SQLCODE || ':' || SQLERRM);
2342: RAISE;
2343: END insert_jai_ap_tds_repo_lines;