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.79.12010000.15 2009/02/10 12:02:46 nikshah 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 429: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in nullout_rec_method');

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

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

529:
530: EXCEPTION
531: WHEN OTHERS THEN
532: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
533: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_chr_inv_grp');
534: END IF;
535:
536: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
537: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',

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

668:
669: EXCEPTION
670: WHEN OTHERS THEN
671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_acct_disb');
673: END IF;
674:
675: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
676: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',

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

711:
712: EXCEPTION
713: WHEN OTHERS THEN
714: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
715: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Failure in Get_Customer_Id');
716: END IF;
717:
718: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
719: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'okl_arintf_pvt',

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

983:
984:
985: -- The values are based on FND_API. S, E, U (Success, Error, Unexpected
986: IF (x_return_status = 'S') THEN
987: okl_debug_pub.logmessage('AUTOINVOICE:Transaction Extension Id: '|| l_entity_id);
988: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
989: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','l_entity_id:'||l_entity_id);
990: END IF;
991:

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

1022:
1023: WHEN OTHERS THEN
1024: x_return_status := Okl_Api.G_RET_STS_ERROR;
1025: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1026: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, SQLERRM);
1027: END IF;
1028: END get_auto_bank_dtls;
1029:
1030: ---------------------------------------------------------------------------

Line 1487: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

1483: where contract_number = p_contract_number;
1484: -- gboomina added for bug 7513216 - end
1485: BEGIN
1486:
1487: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
1488:
1489: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'okl_arintf_pvt','Begin(+)');
1491: END IF;

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

1493: -- ------------------------
1494: -- Print Input variables
1495: -- ------------------------
1496: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_from '||p_trx_date_from);
1498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_to '||p_trx_date_to);
1499: END IF;
1500: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1501: 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 1498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_to '||p_trx_date_to);

1494: -- Print Input variables
1495: -- ------------------------
1496: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_from '||p_trx_date_from);
1498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date_to '||p_trx_date_to);
1499: END IF;
1500: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1501: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','p_trx_date_from:'||p_trx_date_from);
1502: 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 1587: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating records with missing data');

1583: -- ---------------------------------------------------
1584: -- Update rest of the table records with missing data
1585: -- ---------------------------------------------------
1586: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1587: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating records with missing data');
1588: END IF;
1589:
1590: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1591: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating records with missing data');

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

1866: -- Build ra_interface_salescredits_all
1867: -- Build ar_interface_conts_all
1868:
1869: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1870: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Building AR records');
1871: END IF;
1872:
1873: n := 1; -- rmunjulu R12 Fixes -- initialize n
1874: FOR K IN l_xfer_tbl.FIRST..l_xfer_tbl.LAST LOOP

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

1893: program_application_id = lx_program_application_id,
1894: program_id = lx_program_id
1895: WHERE ID = l_hdr_id;
1896: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1897: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_hdr_id);
1898: END IF;
1899: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1900: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating header record with id: '||l_hdr_id);
1901: END IF;

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

1908: l_commit_cnt := l_commit_cnt + 1;
1909:
1910: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1911: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1912: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).xsi_id );
1913: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).tai_id );
1914: --end: | 15-FEB-07 cklee R12 Billing enhancement project
1915: END IF;
1916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

1909:
1910: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1911: --start: | 15-FEB-07 cklee R12 Billing enhancement project
1912: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).xsi_id );
1913: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating header record with id: '||l_xfer_tbl(k).tai_id );
1914: --end: | 15-FEB-07 cklee R12 Billing enhancement project
1915: END IF;
1916: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1917: 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 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 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 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 2551: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_Sales_Credits_all record.');

2547: -- End Sales Tax Code
2548:
2549:
2550: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2551: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing Ra_Sales_Credits_all record.');
2552: END IF;
2553: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2554: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing Ra_Sales_Credits_all record.');
2555: END IF;

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

2650: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Done Preparing Ra_Sales_Credits_all record.');
2651: END IF;
2652:
2653: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2654: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing Ra_Sales_Credits_all record.');
2655: END IF;
2656: -- -------------------------------------
2657: -- Build Contingency table
2658: -- -------------------------------------

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

2669: FROM DUAL;
2670: EXCEPTION
2671: WHEN OTHERS THEN
2672: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR retrieving ar_contingency_tbl(cont_cnt).INTERFACE_CONTINGENCY_ID: '
2674: ||sqlerrm);
2675: END IF;
2676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2677: 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 2683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing ar_contingency record.');

2679: END;
2680: --end bug 5474184
2681:
2682: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing ar_contingency record.');
2684: END IF;
2685: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2686: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Preparing ar_contingency record.');
2687: END IF;

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

2756: ar_contingency_tbl(cont_cnt).CREATION_DATE := sysdate;
2757: ar_contingency_tbl(cont_cnt).LAST_UPDATED_BY := G_user_id;
2758: ar_contingency_tbl(cont_cnt).LAST_UPDATE_DATE := sysdate;
2759: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2760: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing ar_contingency record.');
2761: END IF;
2762: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2763: --bug 6744584 .. contingency_code is not used anymore.
2764: --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 2806: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing inv_dist record.');

2802: IF l_xfer_tbl(k).AMOUNT <> 0 THEN
2803: --end: | 15-FEB-07 cklee R12 Billing enhancement project
2804:
2805: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2806: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Preparing inv_dist record.');
2807: END IF;
2808:
2809: --start: | 15-FEB-07 cklee R12 Billing enhancement project
2810: IF G_ACC_SYS_OPTION = 'ATS' THEN

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

2885: inv_dist_tbl(n).LAST_UPDATED_BY := G_user_id;
2886: inv_dist_tbl(n).LAST_UPDATE_DATE := sysdate;
2887:
2888: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2889: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done Preparing inv_dist record.');
2890: END IF;
2891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2892: 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);
2893: 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 2978: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating last record with id: '||l_hdr_id);

2974: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2975: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Updating last record with id: '||l_hdr_id);
2976: END IF;
2977: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2978: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Updating last record with id: '||l_hdr_id);
2979: END IF;
2980: COMMIT;
2981:
2982: -- -------------------------------------

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

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
3014: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For interface lines, error ' || i || ' occurred during '||
3015: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3016: END IF;
3017:
3018: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

3015: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3016: END IF;
3017:
3018: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3019: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
3020: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
3021: -- bug 5474184
3022: END IF;
3023: 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,'Inserting into sales_credits');

3037: -- ---------------------------------------------
3038: -- Transfer sales credits records to the AR interface
3039: -- ---------------------------------------------
3040: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3041: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into sales_credits');
3042: END IF;
3043: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3044: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into sales_credits');
3045: END IF;

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

3052:
3053: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
3054: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
3055: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3056: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For sales credits, error ' || i || ' occurred during '||
3057: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3058: END IF;
3059: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3060: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

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

3056: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For sales credits, error ' || i || ' occurred during '||
3057: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3058: END IF;
3059: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3060: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
3061: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
3062: -- bug 5474184
3063: END IF;
3064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3078: -- Transfer contingency records to the AR interface
3079: -- ---------------------------------------------
3080:
3081: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3082: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into ar_contingency');
3083: END IF;
3084: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3085: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into ar_contingency');
3086: END IF;

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

3095:
3096: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
3097: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
3098: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3099: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For AR contingencies, error ' || i || ' occurred during '||
3100: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3101: END IF;
3102:
3103: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

3100: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3101: END IF;
3102:
3103: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3104: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
3105: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
3106: -- bug 5474184
3107: END IF;
3108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3121: -- ----------------------------------------------------------
3122: -- Transfer invoice distribution records to the AR interface
3123: -- ----------------------------------------------------------
3124: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3125: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inserting into inv_dist');
3126: END IF;
3127: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3128: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Inserting into inv_dist');
3129: END IF;

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

3136:
3137: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
3138: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
3139: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3140: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'For distributions, error ' || i || ' occurred during '||
3141: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3142: END IF;
3143:
3144: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

3141: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3142: END IF;
3143:
3144: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3145: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
3146: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
3147: -- bug 5474184
3148: END IF;
3149: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3161: END IF;
3162:
3163: if error_tbl.count > 0 then
3164: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3165: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error Processing');
3166: END IF;
3167: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3168: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','Error Processing');
3169: END IF;

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

3174: -- UPDATE XSI trx_status_code to 'WORKING'
3175: -- l_error_xsi_id := NULL;
3176: Begin
3177: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3178: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** XSI_ID is : '||l_error_xsi_id);
3179: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** TXD_ID is : '||error_tbl(indx).id);
3180: END IF;
3181: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3182: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** TXD_ID is : '||error_tbl(indx).id);

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

3175: -- l_error_xsi_id := NULL;
3176: Begin
3177: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3178: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** XSI_ID is : '||l_error_xsi_id);
3179: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** TXD_ID is : '||error_tbl(indx).id);
3180: END IF;
3181: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3182: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** TXD_ID is : '||error_tbl(indx).id);
3183: END IF;

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

3187: l_error_txd_id := NULL;
3188: l_error_tai_id := NULL;
3189:
3190: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3191: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** Exception ** error_xsi_id: '||l_error_xsi_id);
3192: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** Exception ** error_txd_id: '||error_tbl(indx).id);
3193: END IF;
3194: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3195: 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 3192: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' Exception error_txd_id: '||error_tbl(indx).id);

3188: l_error_tai_id := NULL;
3189:
3190: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3191: -- OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** Exception ** error_xsi_id: '||l_error_xsi_id);
3192: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'** Exception ** error_txd_id: '||error_tbl(indx).id);
3193: END IF;
3194: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3195: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','** Exception ** error_txd_id: '||error_tbl(indx).id);
3196: END IF;

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

3376:
3377: IF SQL%BULK_EXCEPTIONS.COUNT > 0 THEN
3378: FOR i IN 1..SQL%BULK_EXCEPTIONS.COUNT LOOP
3379: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3380: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Exception: For interface lines, error ' || i || ' occurred during '||
3381: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3382: END IF;
3383: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3384: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||

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

3380: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Exception: For interface lines, error ' || i || ' occurred during '||
3381: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
3382: END IF;
3383: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3384: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Oracle error is ' ||
3385: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
3386: -- bug 5474184
3387: END IF;
3388: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

3431:
3432: WHEN OTHERS THEN
3433: x_return_status := Okl_Api.G_RET_STS_ERROR;
3434: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3435: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'INSERT Failed ' || SQLERRM);
3436: END IF;
3437: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3438: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_arintf_pvt.get_rec_feeder.debug','INSERT Failed ' || SQLERRM);
3439: END IF;