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.OKL_ARINTF_PVT dependencies on RA_INTERFACE_LINES

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

1893: ) IS
1894:
1895: l_xfer_tbl xfer_tbl_type;
1896:
1897: type inv_lines_tbl_type is table of ra_interface_lines_all%rowtype index by binary_integer;
1898: type inv_dist_tbl_type is table of ra_interface_distributions_all%rowtype index by pls_integer;
1899: type sales_credits_tbl_type is table of ra_interface_salescredits_all%rowtype index by pls_integer;
1900: type ar_contingency_tbl_type is table of ar_interface_conts_all%rowtype index by pls_integer;
1901:

Line 2975: -- Build ra_interface_lines_rec

2971: ar_contingency_tbl.delete;
2972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2973: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','finished deleting pl/sql tables');
2974: END IF;
2975: -- Build ra_interface_lines_rec
2976: -- Build ra_interface_distributions_rec
2977: -- Build ra_interface_salescredits_all
2978: -- Build ar_interface_conts_all
2979:

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

3099: END IF;
3100: --vthiruva - Bug 4222231..end
3101:
3102: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3103: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_interface_lines_all record.');
3104: END IF;
3105:
3106: -- -------------------------------------
3107: -- Build Invoice Lines Table

Line 3111: -- deleted from ra_interface_lines in case of errors

3107: -- Build Invoice Lines Table
3108: -- -------------------------------------
3109: inv_lines_tbl(hdr_cnt).WAREHOUSE_ID := l_xfer_tbl(k).ware_house_id;
3110: --Bug# 13340410: Setting org_id upfront so that record can be
3111: -- deleted from ra_interface_lines in case of errors
3112: inv_lines_tbl(hdr_cnt).ORG_ID := l_xfer_tbl(k).ORG_ID;
3113:
3114: IF (l_xfer_tbl(k).rev_rec_basis = 'CASH_RECEIPT') THEN
3115: --Added if clause by bkatraga for bug 5616268

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

3608: inv_lines_tbl(hdr_cnt).LEGAL_ENTITY_ID := l_xfer_tbl(k).LEGAL_ENTITY_ID; -- for LE Uptake project 08-11-2006
3609:
3610:
3611: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_interface_lines_all record.');
3613: END IF;
3614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3615: 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);
3616: 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 3635: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all record.');

3631: 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);
3632: 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);
3633: 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);
3634: 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);
3635: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all record.');
3636: END IF;
3637: -- Start Sales Tax Code
3638:
3639: -- -------------------------------------

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

3643: -- Insert tax record for ivoices and on-account credit memos
3644: IF NVL(l_xfer_tbl(k).TAX_EXEMPT_FLAG, 'S') <> 'E' THEN
3645:
3646: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3647: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_interface_lines_all tax record.');
3648: END IF;
3649: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3650: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing Ra_interface_lines_all tax record.');
3651: END IF;

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

3646: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3647: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_interface_lines_all tax record.');
3648: END IF;
3649: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3650: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing Ra_interface_lines_all tax record.');
3651: END IF;
3652: --start| 02-MAR-07 cklee R12 Billing enhancement project |
3653: -- ebtax integration
3654: /*

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

3785: --start| 02-MAR-07 cklee R12 Billing enhancement project |
3786:
3787:
3788: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3789: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_interface_lines_all tax record.');
3790: END IF;
3791: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3792: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all tax record.');
3793: END IF;

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

3788: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3789: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_interface_lines_all tax record.');
3790: END IF;
3791: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3792: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_interface_lines_all tax record.');
3793: END IF;
3794: END IF;
3795:
3796: -- End Sales Tax Code

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

4276: -- Transfer line records to the AR interface
4277: -- ---------------------------------------------
4278:
4279: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4280: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into ra_interface_lines_all');
4281: END IF;
4282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4283: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into ra_interface_lines_all');
4284: END IF;

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

4279: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4280: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into ra_interface_lines_all');
4281: END IF;
4282: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4283: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into ra_interface_lines_all');
4284: END IF;
4285:
4286: IF inv_lines_tbl.COUNT > 0 THEN
4287: FORALL indx in inv_lines_tbl.first..inv_lines_tbl.LAST

Line 4289: INSERT INTO ra_interface_lines_all

4285:
4286: IF inv_lines_tbl.COUNT > 0 THEN
4287: FORALL indx in inv_lines_tbl.first..inv_lines_tbl.LAST
4288: SAVE EXCEPTIONS
4289: INSERT INTO ra_interface_lines_all
4290: VALUES inv_lines_tbl(indx);
4291: END IF;
4292:
4293: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

4290: VALUES inv_lines_tbl(indx);
4291: END IF;
4292:
4293: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4294: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into ra_interface_lines_all');
4295: END IF;
4296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4297: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Inserting into ra_interface_lines_all');
4298: END IF;

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

4293: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4294: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Inserting into ra_interface_lines_all');
4295: END IF;
4296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4297: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Inserting into ra_interface_lines_all');
4298: END IF;
4299: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
4300: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4301: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4526: delete from ra_interface_lines

4522:
4523: -- ---------------------------
4524: -- delete records from lines
4525: -- ---------------------------
4526: delete from ra_interface_lines
4527: --start: | 15-FEB-07 cklee R12 Billing enhancement project
4528: -- where interface_line_attribute10 = to_char(SUBSTR (error_tbl(indx).id,1, 20))
4529: -- and interface_line_attribute11 = to_char(SUBSTR(error_tbl(indx).id,21));
4530: where interface_line_attribute14 = to_char(error_tbl(indx).id);

Line 4584: DELETE FROM RA_INTERFACE_LINES

4580: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4581: AND TAI.ID = TIL.TAI_ID
4582: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));
4583:
4584: DELETE FROM RA_INTERFACE_LINES
4585: WHERE interface_line_attribute14 IN
4586: (SELECT TLD.ID
4587: FROM OKL_TXD_AR_LN_DTLS_B TLD
4588: , OKL_TXL_AR_INV_LNS_B TIL