DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on RA_INTERFACE_LINES_ALL

Line 1046: type inv_lines_tbl_type is table of ra_interface_lines_all%rowtype index by binary_integer;

1042: ) IS
1043:
1044: l_xfer_tbl xfer_tbl_type;
1045:
1046: type inv_lines_tbl_type is table of ra_interface_lines_all%rowtype index by binary_integer;
1047: type inv_dist_tbl_type is table of ra_interface_distributions_all%rowtype index by pls_integer;
1048: type sales_credits_tbl_type is table of ra_interface_salescredits_all%rowtype index by pls_integer;
1049: type ar_contingency_tbl_type is table of ar_interface_conts_all%rowtype index by pls_integer;
1050:

Line 1975: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_interface_lines_all record.');

1971: END IF;
1972: --vthiruva - Bug 4222231..end
1973:
1974: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1975: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_interface_lines_all record.');
1976: END IF;
1977:
1978: -- -------------------------------------
1979: -- Build Invoice Lines Table

Line 2428: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_interface_lines_all record.');

2424: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := l_xfer_tbl(k).LEGAL_ENTITY_ID; -- for LE Uptake project 08-11-2006
2425:
2426:
2427: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2428: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_interface_lines_all record.');
2429: END IF;
2430: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2431: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').legal_entity_id:' || inv_lines_tbl(hdr_cnt).legal_entity_id);
2432: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').org_id:' || inv_lines_tbl(hdr_cnt).org_id);

Line 2451: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all record.');

2447: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').term_id:' || inv_lines_tbl(hdr_cnt).term_id);
2448: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').unit_selling_price:' || inv_lines_tbl(hdr_cnt).unit_selling_price);
2449: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').unit_standard_price:' || inv_lines_tbl(hdr_cnt).unit_standard_price);
2450: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_lines_tbl('||hdr_cnt||').uom_code:' || inv_lines_tbl(hdr_cnt).uom_code);
2451: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all record.');
2452: END IF;
2453: -- Start Sales Tax Code
2454:
2455: -- -------------------------------------

Line 2463: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_interface_lines_all tax record.');

2459: -- Insert tax record for ivoices and on-account credit memos
2460: IF NVL(l_xfer_tbl(k).TAX_EXEMPT_FLAG, 'S') <> 'E' THEN
2461:
2462: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2463: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_interface_lines_all tax record.');
2464: END IF;
2465: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2466: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing Ra_interface_lines_all tax record.');
2467: END IF;

Line 2466: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing Ra_interface_lines_all tax record.');

2462: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2463: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_interface_lines_all tax record.');
2464: END IF;
2465: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2466: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing Ra_interface_lines_all tax record.');
2467: END IF;
2468: --start| 02-MAR-07 cklee R12 Billing enhancement project |
2469: -- ebtax integration
2470: /*

Line 2540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_interface_lines_all tax record.');

2536: --start| 02-MAR-07 cklee R12 Billing enhancement project |
2537:
2538:
2539: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_interface_lines_all tax record.');
2541: END IF;
2542: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2543: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all tax record.');
2544: END IF;

Line 2543: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all tax record.');

2539: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_interface_lines_all tax record.');
2541: END IF;
2542: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2543: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all tax record.');
2544: END IF;
2545: END IF;
2546:
2547: -- End Sales Tax Code

Line 2992: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into ra_interface_lines_all');

2988: -- Transfer line records to the AR interface
2989: -- ---------------------------------------------
2990:
2991: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2992: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into ra_interface_lines_all');
2993: END IF;
2994: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2995: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into ra_interface_lines_all');
2996: END IF;

Line 2995: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into ra_interface_lines_all');

2991: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2992: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into ra_interface_lines_all');
2993: END IF;
2994: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2995: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into ra_interface_lines_all');
2996: END IF;
2997:
2998: IF inv_lines_tbl.COUNT > 0 THEN
2999: FORALL indx in inv_lines_tbl.first..inv_lines_tbl.LAST

Line 3001: INSERT INTO ra_interface_lines_all

2997:
2998: IF inv_lines_tbl.COUNT > 0 THEN
2999: FORALL indx in inv_lines_tbl.first..inv_lines_tbl.LAST
3000: SAVE EXCEPTIONS
3001: INSERT INTO ra_interface_lines_all
3002: VALUES inv_lines_tbl(indx);
3003: END IF;
3004:
3005: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3006: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into ra_interface_lines_all');

3002: VALUES inv_lines_tbl(indx);
3003: END IF;
3004:
3005: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3006: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into ra_interface_lines_all');
3007: END IF;
3008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3009: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Inserting into ra_interface_lines_all');
3010: END IF;

Line 3009: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Inserting into ra_interface_lines_all');

3005: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3006: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into ra_interface_lines_all');
3007: END IF;
3008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3009: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Inserting into ra_interface_lines_all');
3010: END IF;
3011: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
3012: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
3013: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN