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 OKL_DEBUG_PUB

Line 5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

1: PACKAGE BODY OKL_ARINTF_PVT AS
2: /* $Header: OKLRAINB.pls 120.122.12020000.2 2013/01/24 11:33:24 venkatho ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.plsql.okl_arintf_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7: -- Start of wraper code generated automatically by Debug code generator
8: L_MODULE VARCHAR2(40) := 'LEASE.RECEIVABLES.BILLING';
9: L_DEBUG_ENABLED VARCHAR2(10);

Line 10: -- L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7: -- Start of wraper code generated automatically by Debug code generator
8: L_MODULE VARCHAR2(40) := 'LEASE.RECEIVABLES.BILLING';
9: L_DEBUG_ENABLED VARCHAR2(10);
10: -- L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
11: L_LEVEL_PROCEDURE NUMBER;
12: IS_DEBUG_PROCEDURE_ON BOOLEAN;
13: -- End of wraper code generated automatically by Debug code generator
14: --start: | 15-FEB-07 cklee R12 Billing enhancement project

Line 307: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in get_cust_config_from_line');

303:
304: EXCEPTION
305: WHEN OTHERS THEN
306: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
307: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in get_cust_config_from_line');
308: END IF;
309:
310: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',

Line 430: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in nullout_rec_method');

426:
427: EXCEPTION
428: WHEN OTHERS THEN
429: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
430: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in nullout_rec_method');
431: END IF;
432:
433: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
434: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',

Line 548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_chr_inv_grp');

544:
545: EXCEPTION
546: WHEN OTHERS THEN
547: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_chr_inv_grp');
549: END IF;
550:
551: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
552: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',

Line 701: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_acct_disb');

697:
698: EXCEPTION
699: WHEN OTHERS THEN
700: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
701: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_acct_disb');
702: END IF;
703:
704: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
705: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',

Line 744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_Customer_Id');

740:
741: EXCEPTION
742: WHEN OTHERS THEN
743: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_Customer_Id');
745: END IF;
746:
747: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
748: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',

Line 1447: okl_debug_pub.logmessage('AUTOINVOICE:Transaction Extension Id: '|| l_entity_id);

1443: x_entity_id => l_entity_id,
1444: x_response => l_response);
1445:
1446: IF (x_return_status = 'S') THEN
1447: okl_debug_pub.logmessage('AUTOINVOICE:Transaction Extension Id: '|| l_entity_id);
1448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1449: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','l_entity_id:'||l_entity_id);
1450: END IF;
1451: x_payment_trxn_extension_id := l_entity_id;

Line 1482: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, SQLERRM);

1478:
1479: WHEN OTHERS THEN
1480: x_return_status := Okl_Api.G_RET_STS_ERROR;
1481: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1482: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, SQLERRM);
1483: END IF;
1484: END get_vendor_auto_bank_dtls;
1485:
1486: ---------------------------------------------------------------------------

Line 1838: okl_debug_pub.logmessage('AUTOINVOICE:Transaction Extension Id: '|| l_entity_id);

1834: x_entity_id => l_entity_id,
1835: x_response => l_response);
1836: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected
1837: IF (x_return_status = 'S') THEN
1838: okl_debug_pub.logmessage('AUTOINVOICE:Transaction Extension Id: '|| l_entity_id);
1839: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1840: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','l_entity_id:'||l_entity_id);
1841: END IF;
1842:

Line 1877: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, SQLERRM);

1873:
1874: WHEN OTHERS THEN
1875: x_return_status := Okl_Api.G_RET_STS_ERROR;
1876: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1877: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, SQLERRM);
1878: END IF;
1879: END get_auto_bank_dtls;
1880:
1881: ---------------------------------------------------------------------------

Line 2500: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

2496: AND hsu.site_use_id = NVL(oli.ship_to_org_id, ohe.ship_to_org_id);
2497:
2498: BEGIN
2499:
2500: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
2501:
2502: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2503: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_arintf_pvt','Begin(+)');
2504: END IF;

Line 2510: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_from '||p_trx_date_from);

2506: -- ------------------------
2507: -- Print Input variables
2508: -- ------------------------
2509: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2510: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_from '||p_trx_date_from);
2511: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_to '||p_trx_date_to);
2512: END IF;
2513: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2514: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','p_trx_date_from:'||p_trx_date_from);

Line 2511: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_to '||p_trx_date_to);

2507: -- Print Input variables
2508: -- ------------------------
2509: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2510: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_from '||p_trx_date_from);
2511: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_to '||p_trx_date_to);
2512: END IF;
2513: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2514: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','p_trx_date_from:'||p_trx_date_from);
2515: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','p_trx_date_to:'||p_trx_date_to);

Line 2595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating Customer header records with BANKRUPT Status as Customer is on Bankrupty for khr_id: '||cust_bankruptcy_rec.khr_id);

2591: AND ixx_id = cust_bankruptcy_rec.customer_id
2592: AND trx_status_code = 'SUBMITTED';
2593:
2594: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating Customer header records with BANKRUPT Status as Customer is on Bankrupty for khr_id: '||cust_bankruptcy_rec.khr_id);
2596: END IF;
2597:
2598: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2599: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating Customer header records with BANKRUPT Status as Customer is on Bankrupty for khr_id: '||cust_bankruptcy_rec.khr_id);

Line 2627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating Vendor header records with BANKRUPT Status as Vendor is on Bankruptcy for khr_id: '||vndr_bankruptcy_rec.khr_id);

2623: AND ixx_id = vndr_bankruptcy_rec.vendor_customer_id
2624: AND trx_status_code = 'SUBMITTED';
2625:
2626: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating Vendor header records with BANKRUPT Status as Vendor is on Bankruptcy for khr_id: '||vndr_bankruptcy_rec.khr_id);
2628: END IF;
2629:
2630: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2631: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating Vendor header records with BANKRUPT Status as Vendor is on Bankruptcy for khr_id: '||vndr_bankruptcy_rec.khr_id);

Line 2672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating records with missing data');

2668: -- ---------------------------------------------------
2669: -- Update rest of the table records with missing data
2670: -- ---------------------------------------------------
2671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating records with missing data');
2673: END IF;
2674:
2675: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2676: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating records with missing data');

Line 2981: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Building AR records');

2977: -- Build ra_interface_salescredits_all
2978: -- Build ar_interface_conts_all
2979:
2980: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2981: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Building AR records');
2982: END IF;
2983:
2984: n := 1; -- rmunjulu R12 Fixes -- initialize n
2985: FOR K IN l_xfer_tbl.FIRST..l_xfer_tbl.LAST LOOP

Line 3025: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_hdr_id);

3021: program_application_id = lx_program_application_id,
3022: program_id = lx_program_id
3023: WHERE ID = l_hdr_id;
3024: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3025: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_hdr_id);
3026: END IF;
3027: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3028: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating header record with id: '||l_hdr_id);
3029: END IF;

Line 3040: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).xsi_id );

3036: l_commit_cnt := l_commit_cnt + 1;
3037:
3038: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3039: --start: | 15-FEB-07 cklee R12 Billing enhancement project
3040: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).xsi_id );
3041: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).tai_id );
3042: --end: | 15-FEB-07 cklee R12 Billing enhancement project
3043: END IF;
3044: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3041: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).tai_id );

3037:
3038: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3039: --start: | 15-FEB-07 cklee R12 Billing enhancement project
3040: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).xsi_id );
3041: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).tai_id );
3042: --end: | 15-FEB-07 cklee R12 Billing enhancement project
3043: END IF;
3044: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3045: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating header record with id: '||l_xfer_tbl(k).tai_id);

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 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 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 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 3800: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_Sales_Credits_all record.');

3796: -- End Sales Tax Code
3797:
3798:
3799: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3800: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_Sales_Credits_all record.');
3801: END IF;
3802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3803: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing Ra_Sales_Credits_all record.');
3804: END IF;

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

3899: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_Sales_Credits_all record.');
3900: END IF;
3901:
3902: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3903: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_Sales_Credits_all record.');
3904: END IF;
3905: -- -------------------------------------
3906: -- Build Contingency table
3907: -- -------------------------------------

Line 3922: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR retrieving ar_contingency_tbl(cont_cnt).INTERFACE_CONTINGENCY_ID: '

3918: FROM DUAL;
3919: EXCEPTION
3920: WHEN OTHERS THEN
3921: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3922: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR retrieving ar_contingency_tbl(cont_cnt).INTERFACE_CONTINGENCY_ID: '
3923: ||sqlerrm);
3924: END IF;
3925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3926: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','ERROR retrieving ar_contingency_tbl(cont_cnt).INTERFACE_CONTINGENCY_ID:'||sqlerrm);

Line 3932: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing ar_contingency record.');

3928: END;
3929: --end bug 5474184
3930:
3931: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3932: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing ar_contingency record.');
3933: END IF;
3934: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3935: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing ar_contingency record.');
3936: END IF;

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

4005: ar_contingency_tbl(cont_cnt).CREATION_DATE := sysdate;
4006: ar_contingency_tbl(cont_cnt).LAST_UPDATED_BY := G_user_id;
4007: ar_contingency_tbl(cont_cnt).LAST_UPDATE_DATE := sysdate;
4008: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4009: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing ar_contingency record.');
4010: END IF;
4011: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4012: --bug 6744584 .. contingency_code is not used anymore.
4013: --fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','ar_contingency_tbl('||cont_cnt||').contingency_code:' || ar_contingency_tbl(cont_cnt).contingency_code);

Line 4055: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing inv_dist record.');

4051: IF l_xfer_tbl(k).AMOUNT <> 0 THEN
4052: --end: | 15-FEB-07 cklee R12 Billing enhancement project
4053:
4054: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4055: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing inv_dist record.');
4056: END IF;
4057:
4058: --start: | 15-FEB-07 cklee R12 Billing enhancement project
4059: IF G_ACC_SYS_OPTION = 'ATS' THEN

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

4136: inv_dist_tbl(n).LAST_UPDATED_BY := G_user_id;
4137: inv_dist_tbl(n).LAST_UPDATE_DATE := sysdate;
4138:
4139: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4140: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing inv_dist record.');
4141: END IF;
4142: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4143: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_dist_tbl('||n||').account_class:' || inv_dist_tbl(n).account_class);
4144: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','inv_dist_tbl('||n||').amount:' || inv_dist_tbl(n).amount);

Line 4266: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating last record with id: '||l_hdr_id);

4262: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4263: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating last record with id: '||l_hdr_id);
4264: END IF;
4265: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4266: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating last record with id: '||l_hdr_id);
4267: END IF;
4268: COMMIT;
4269:
4270: -- -------------------------------------

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 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 4302: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For interface lines, error ' || i || ' occurred during '||

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
4302: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For interface lines, error ' || i || ' occurred during '||
4303: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4304: END IF;
4305:
4306: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4307: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

4303: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4304: END IF;
4305:
4306: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4307: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
4308: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
4309: -- bug 5474184
4310: END IF;
4311: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4329: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into sales_credits');

4325: -- ---------------------------------------------
4326: -- Transfer sales credits records to the AR interface
4327: -- ---------------------------------------------
4328: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4329: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into sales_credits');
4330: END IF;
4331: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4332: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into sales_credits');
4333: END IF;

Line 4344: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For sales credits, error ' || i || ' occurred during '||

4340:
4341: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
4342: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4343: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4344: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For sales credits, error ' || i || ' occurred during '||
4345: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4346: END IF;
4347: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4348: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

Line 4348: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

4344: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For sales credits, error ' || i || ' occurred during '||
4345: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4346: END IF;
4347: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4348: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
4349: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
4350: -- bug 5474184
4351: END IF;
4352: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4370: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into ar_contingency');

4366: -- Transfer contingency records to the AR interface
4367: -- ---------------------------------------------
4368:
4369: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4370: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into ar_contingency');
4371: END IF;
4372: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4373: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into ar_contingency');
4374: END IF;

Line 4387: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For AR contingencies, error ' || i || ' occurred during '||

4383:
4384: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
4385: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4386: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4387: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For AR contingencies, error ' || i || ' occurred during '||
4388: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4389: END IF;
4390:
4391: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4392: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

4388: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4389: END IF;
4390:
4391: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4392: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
4393: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
4394: -- bug 5474184
4395: END IF;
4396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into inv_dist');

4409: -- ----------------------------------------------------------
4410: -- Transfer invoice distribution records to the AR interface
4411: -- ----------------------------------------------------------
4412: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into inv_dist');
4414: END IF;
4415: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4416: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into inv_dist');
4417: END IF;

Line 4428: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For distributions, error ' || i || ' occurred during '||

4424:
4425: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
4426: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4427: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4428: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For distributions, error ' || i || ' occurred during '||
4429: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4430: END IF;
4431:
4432: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 4433: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

4429: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4430: END IF;
4431:
4432: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4433: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
4434: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
4435: -- bug 5474184
4436: END IF;
4437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4453: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error Processing');

4449: END IF;
4450:
4451: if error_tbl.count > 0 then
4452: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4453: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error Processing');
4454: END IF;
4455: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4456: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Error Processing');
4457: END IF;

Line 4466: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** XSI_ID is : '||l_error_xsi_id);

4462: -- UPDATE XSI trx_status_code to 'WORKING'
4463: -- l_error_xsi_id := NULL;
4464: Begin
4465: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4466: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** XSI_ID is : '||l_error_xsi_id);
4467: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** TXD_ID is : '||error_tbl(indx).id);
4468: END IF;
4469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4470: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** TXD_ID is : '||error_tbl(indx).id);

Line 4467: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** TXD_ID is : '||error_tbl(indx).id);

4463: -- l_error_xsi_id := NULL;
4464: Begin
4465: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4466: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** XSI_ID is : '||l_error_xsi_id);
4467: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** TXD_ID is : '||error_tbl(indx).id);
4468: END IF;
4469: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4470: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** TXD_ID is : '||error_tbl(indx).id);
4471: END IF;

Line 4479: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' Exception error_xsi_id: '||l_error_xsi_id);

4475: l_error_txd_id := NULL;
4476: l_error_tai_id := NULL;
4477:
4478: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4479: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** Exception ** error_xsi_id: '||l_error_xsi_id);
4480: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** Exception ** error_txd_id: '||error_tbl(indx).id);
4481: END IF;
4482: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4483: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** Exception ** error_txd_id: '||error_tbl(indx).id);

Line 4480: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' Exception error_txd_id: '||error_tbl(indx).id);

4476: l_error_tai_id := NULL;
4477:
4478: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4479: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** Exception ** error_xsi_id: '||l_error_xsi_id);
4480: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** Exception ** error_txd_id: '||error_tbl(indx).id);
4481: END IF;
4482: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4483: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** Exception ** error_txd_id: '||error_tbl(indx).id);
4484: END IF;

Line 4782: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Exception: For interface lines, error ' || i || ' occurred during '||

4778:
4779: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
4780: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
4781: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4782: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Exception: For interface lines, error ' || i || ' occurred during '||
4783: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4784: END IF;
4785: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4786: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

Line 4786: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

4782: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Exception: For interface lines, error ' || i || ' occurred during '||
4783: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
4784: END IF;
4785: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4786: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
4787: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
4788: -- bug 5474184
4789: END IF;
4790: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 4837: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'INSERT Failed ' || SQLERRM);

4833:
4834: WHEN OTHERS THEN
4835: x_return_status := Okl_Api.G_RET_STS_ERROR;
4836: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4837: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'INSERT Failed ' || SQLERRM);
4838: END IF;
4839: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4840: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','INSERT Failed ' || SQLERRM);
4841: END IF;