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

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

44: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
45: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
46: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
47:
48: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
52: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

45: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
46: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
47:
48: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
52: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
53: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

46: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
47:
48: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
52: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
53: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
54: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

47:
48: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
52: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
53: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
54: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_GENERATION_PKG.';

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

48: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
49: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
52: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
53: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
54: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_GENERATION_PKG.';
56: G_CALL_FROM_ROLLBACK CONSTANT VARCHAR2(40) := 'PROCESS_THRESHOLD_ROLLBACK'; --Added by Chong for Bug#13802244 2012/09/17

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

49: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
52: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
53: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
54: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_GENERATION_PKG.';
56: G_CALL_FROM_ROLLBACK CONSTANT VARCHAR2(40) := 'PROCESS_THRESHOLD_ROLLBACK'; --Added by Chong for Bug#13802244 2012/09/17
57: G_VENDOR_SITE_DEF_SEC_CODE CONSTANT VARCHAR2(40) := 'Vendor Site Default Section Code'; --Added by Chong for Bug#13802244 2012/09/17

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

50: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
52: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
53: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
54: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
55: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_GENERATION_PKG.';
56: G_CALL_FROM_ROLLBACK CONSTANT VARCHAR2(40) := 'PROCESS_THRESHOLD_ROLLBACK'; --Added by Chong for Bug#13802244 2012/09/17
57: G_VENDOR_SITE_DEF_SEC_CODE CONSTANT VARCHAR2(40) := 'Vendor Site Default Section Code'; --Added by Chong for Bug#13802244 2012/09/17
58: G_NTL_ACC_SEC_MAP CONSTANT VARCHAR2(40) := 'Natural Account - Section Code Mapping'; --Added by Chong for Bug#13802244 2012/09/17

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

490: l_api_name CONSTANT VARCHAR2(50) := 'get_invoice_tax_not_deducted()';
491:
492: BEGIN
493:
494: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
495:
496: lv_sql :=
497: 'SELECT INVOICE_ID, SUM (AMOUNT) ,ACTUAL_SECTION_CODE, TAX_CATEGORY_ID
498: FROM JAI_AP_TDS_INV_TAXES JATIT

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

603:
604: open l_tab for lv_sql;
605:
606:
607: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
608:
609: return l_tab;
610:
611: END get_invoice_tax_not_deducted;

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

628: l_api_name CONSTANT VARCHAR2(50) := 'get_invoice_unpaid()';
629:
630: BEGIN
631:
632: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
633:
634: lv_sql :=
635: 'SELECT INVOICE_ID, SUM (AMOUNT), ACTUAL_SECTION_CODE, TAX_CATEGORY_ID
636: FROM

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

712:
713:
714: open l_tab for lv_sql;
715:
716: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
717:
718: return l_tab;
719:
720: END get_invoice_unpaid;

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

749: l_api_name CONSTANT VARCHAR2(50) := 'get_prepay_unapplied()';
750:
751: BEGIN
752:
753: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
754:
755: --Updated by Chong.Lei for bug#13787158 begin
756: -----------------------------------------------------------------------------------------------------
757: /* lv_sql := 'SELECT JATIT.INVOICE_ID, SUM (nvl(AIDA.PREPAY_AMOUNT_REMAINING,aida.amount)) AMOUNT, JATIT.ACTUAL_SECTION_CODE, JATIT.TAX_CATEGORY_ID

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

876:
877:
878: open l_tab for lv_sql;
879:
880: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
881:
882: return l_tab;
883: END get_prepay_unapplied;
884:

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

1008: l_api_name CONSTANT VARCHAR2(50) := 'get_prepay_invoice_amt_new()';
1009:
1010: BEGIN
1011:
1012: -- jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1013:
1014: BEGIN
1015: pn_prepay_amt := 0;
1016: for r_get_dist_prepay in c_get_dist_prepay(pn_invoice_id)

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

1054: EXCEPTION
1055: WHEN NO_DATA_FOUND THEN
1056: pn_prepay_amt:=0;
1057: END;
1058: -- jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
1059:
1060: END get_prepay_invoice_amt_new;
1061: --------------------------------------------------------------------------------------
1062: --Added by zhiwei for Bug#13359892 DTC enhancement on 2011123 end

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

1125: l_api_name CONSTANT VARCHAR2(50) := 'get_prepay_appln_amt()';
1126:
1127: BEGIN
1128: BEGIN
1129: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1130:
1131: pn_apply_amt := 0;
1132: --Added by Xiao Lv for Bug#8513550, related 11i bug#8439276, begin
1133: if pn_curr_inv_flag = 'Y' then

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

1159: EXCEPTION
1160: WHEN NO_DATA_FOUND THEN
1161: pn_apply_amt:=0;
1162: END;
1163: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
1164: END get_prepay_appln_amt;
1165: --Added by Xiao Lv for bug#8345080 on 13-Jan-10, end
1166:
1167: /*Added for Bug 8641199 - Start*/

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

1235: l_po_encum_flag VARCHAR2(1);
1236: l_api_name CONSTANT VARCHAR2(50) := 'status_update_chk_validate()';
1237:
1238: begin
1239: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1240: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.status_update_chk_validate', 'START'); /* 1 */
1241:
1242: get_org_id(p_invoice_id, lp_org_id);
1243: l_po_encum_flag := 'N';

Line 1302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);

1298:
1299: end if;
1300:
1301: fnd_file.put_line(FND_FILE.LOG, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);
1302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);
1303:
1304: << exit_from_procedure >>
1305: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath, null, 'END'); /* 7 */
1306: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');

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

1302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'Status_update_chk_validate - Status of parent invoice '|| p_is_invoice_validated);
1303:
1304: << exit_from_procedure >>
1305: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath, null, 'END'); /* 7 */
1306: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
1307: return;
1308:
1309: exception
1310: when others then

Line 1637: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Exception threshold heaer id: ' || ln_threshold_hdr_id);

1633: if nvl(lv_valid_flg, 'N') = 'N' then
1634: ln_threshold_hdr_id := null; --If no effective threshold type, use normal threshold setup
1635: end if;
1636: end if;
1637: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Exception threshold heaer id: ' || ln_threshold_hdr_id);
1638: -------------------------------------------------------------
1639: --added by Chong for bug#16580553 20130402 End
1640:
1641: if nvl(ln_threshold_hdr_id,0) = 0 then

Line 1661: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'threshold heaer id: ' || ln_threshold_hdr_id);

1657:
1658:
1659: end if;
1660:
1661: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'threshold heaer id: ' || ln_threshold_hdr_id);
1662:
1663: xn_hdr_id := ln_threshold_hdr_id;
1664:
1665: --return

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

1788: l_api_name CONSTANT VARCHAR2(50) := 'maintain_thhold_grps()';
1789:
1790: begin
1791:
1792: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
1793: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_dtc_generation_pkg.maintain_thhold_grps', 'START'); /* 1 */
1794:
1795:
1796: /* Validate the input */

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

2088: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2089: <>
2090:
2091: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 1 */
2092: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
2093:
2094: return;
2095:
2096: exception

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

2193: l_api_name CONSTANT VARCHAR2(50) := 'populate_repository()';
2194:
2195: begin
2196:
2197: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
2198: ln_org_id := mo_global.get_current_org_id();
2199:
2200: ld_from_date := fnd_date.canonical_to_date(pd_from_date);
2201: ld_to_date := fnd_date.canonical_to_date(pd_to_date);

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

2376:
2377: end loop;
2378:
2379: END LOOP;
2380: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
2381:
2382: end populate_repository;
2383: --Commented by Chong for eDTC bug#16414088 on 20130118 End */
2384:

Line 3197: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

3193: --Added by Zhiwei Hou on 20120113 end
3194:
3195: --Added by Zhiwei Hou on 20120203 begin
3196: -------------------------------------------------------------------
3197: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
3198: ln_proc_level NUMBER := FND_LOG.level_procedure;
3199: lv_proc_name VARCHAR2 (100) := 'process_dtc_at_inv_validate';
3200: -- cursor to get information (Operating Unit ID, Legal Entity ID, Ledger ID)from ap invoices
3201: cursor c_get_inv_info(cn_invoice_id number)

Line 3198: ln_proc_level NUMBER := FND_LOG.level_procedure;

3194:
3195: --Added by Zhiwei Hou on 20120203 begin
3196: -------------------------------------------------------------------
3197: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
3198: ln_proc_level NUMBER := FND_LOG.level_procedure;
3199: lv_proc_name VARCHAR2 (100) := 'process_dtc_at_inv_validate';
3200: -- cursor to get information (Operating Unit ID, Legal Entity ID, Ledger ID)from ap invoices
3201: cursor c_get_inv_info(cn_invoice_id number)
3202: is

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

3219: lv_valid_flg VARCHAR2(1); --Added by Chong fof bug#16580553
3220: l_api_name CONSTANT VARCHAR2(50) := 'process_dtc_at_inv_validate()';
3221: BEGIN
3222:
3223: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
3224: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
3225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_id: '||p_vendor_id);
3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);
3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);

Line 3224: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);

3220: l_api_name CONSTANT VARCHAR2(50) := 'process_dtc_at_inv_validate()';
3221: BEGIN
3222:
3223: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
3224: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
3225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_id: '||p_vendor_id);
3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);
3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);
3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);

Line 3225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_id: '||p_vendor_id);

3221: BEGIN
3222:
3223: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
3224: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
3225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_id: '||p_vendor_id);
3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);
3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);
3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);
3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);

Line 3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);

3222:
3223: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
3224: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
3225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_id: '||p_vendor_id);
3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);
3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);
3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);
3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);
3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);

Line 3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);

3223: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
3224: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
3225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_id: '||p_vendor_id);
3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);
3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);
3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);
3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);
3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);
3231: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_id: '||p_org_id);

Line 3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);

3224: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
3225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_id: '||p_vendor_id);
3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);
3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);
3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);
3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);
3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);
3231: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_id: '||p_org_id);
3232: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '|| p_call_from);

Line 3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);

3225: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_id: '||p_vendor_id);
3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);
3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);
3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);
3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);
3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);
3231: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_id: '||p_org_id);
3232: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '|| p_call_from);
3233: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_creation_date: ' || p_creation_date);

Line 3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);

3226: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_vendor_site_id: '||p_vendor_site_id);
3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);
3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);
3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);
3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);
3231: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_id: '||p_org_id);
3232: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '|| p_call_from);
3233: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_creation_date: ' || p_creation_date);
3234: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_dtc_generation_pkg.process_dtc_at_inv_validate', 'START'); /* 1 */

Line 3231: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_id: '||p_org_id);

3227: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_accounting_date: '||p_accounting_date);
3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);
3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);
3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);
3231: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_id: '||p_org_id);
3232: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '|| p_call_from);
3233: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_creation_date: ' || p_creation_date);
3234: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_dtc_generation_pkg.process_dtc_at_inv_validate', 'START'); /* 1 */
3235:

Line 3232: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '|| p_call_from);

3228: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_currency_code: '||p_invoice_currency_code);
3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);
3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);
3231: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_id: '||p_org_id);
3232: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '|| p_call_from);
3233: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_creation_date: ' || p_creation_date);
3234: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_dtc_generation_pkg.process_dtc_at_inv_validate', 'START'); /* 1 */
3235:
3236: --Added by Chong for Bug#13802244 2012/09/17 Start

Line 3233: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_creation_date: ' || p_creation_date);

3229: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_exchange_rate: '||p_exchange_rate);
3230: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_set_of_books_id: '||p_set_of_books_id);
3231: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_org_id: '||p_org_id);
3232: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_call_from: '|| p_call_from);
3233: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_creation_date: ' || p_creation_date);
3234: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_dtc_generation_pkg.process_dtc_at_inv_validate', 'START'); /* 1 */
3235:
3236: --Added by Chong for Bug#13802244 2012/09/17 Start
3237: ---------------------------------------------------------------------------------

Line 3254: FND_LOG.STRING ( ln_proc_level

3250:
3251:
3252: IF ( ln_proc_level >= ln_dbg_level)
3253: THEN
3254: FND_LOG.STRING ( ln_proc_level
3255: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3256: , 'Check for tax count ' || ln_count
3257: );
3258: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 3280: FND_LOG.STRING ( ln_proc_level

3276:
3277: IF ( ln_proc_level >= ln_dbg_level)
3278: THEN
3279:
3280: FND_LOG.STRING ( ln_proc_level
3281: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3282: , 'Check for processed already ' || ln_cnt_already_processed
3283: );
3284: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 3353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_process_message);

3349: ln_rounding_factor := get_taxable_rounding(p_invoice_id);
3350: IF ln_rounding_factor IS NULL THEN
3351: p_process_flag := 'E';
3352: p_process_message := 'Rounding Rule for Tax Basis is not defined for the entered GL Period. Invoice:' || p_invoice_id;
3353: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_process_message);
3354: goto exit_from_procedure;
3355: END IF;
3356:
3357: ln_tax_rounding_factor := get_tax_rounding(p_invoice_id);

Line 3361: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_process_message);

3357: ln_tax_rounding_factor := get_tax_rounding(p_invoice_id);
3358: IF ln_tax_rounding_factor IS NULL THEN
3359: p_process_flag := 'E';
3360: p_process_message := 'Rounding Rule for Tax is not defined for the entered GL Period. Invoice:' || p_invoice_id;
3361: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_process_message);
3362: goto exit_from_procedure;
3363: END IF;
3364: ---------------------------------------------------------------------------
3365: --Added by Chong for bug#15939571 20121210 End

Line 3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_cnt_matched_lines: ' || ln_cnt_matched_lines);

3402: --When get count > 0, means AP invoice containing matched invoice lines
3403: open c_check_is_matched;
3404: fetch c_check_is_matched into ln_cnt_matched_lines;
3405: close c_check_is_matched;
3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_cnt_matched_lines: ' || ln_cnt_matched_lines);
3407:
3408: if ln_cnt_matched_lines > 0 then
3409: --PO/receipt Match AP invoice
3410: lv_default_option := G_VENDOR_SITE_DEF_SEC_CODE;

Line 3480: FND_LOG.STRING ( ln_proc_level

3476:
3477: IF ( ln_proc_level >= ln_dbg_level)
3478: THEN
3479:
3480: FND_LOG.STRING ( ln_proc_level
3481: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3482: , '20 Process flag ' || p_process_flag
3483: );
3484: FND_LOG.STRING ( ln_proc_level

Line 3484: FND_LOG.STRING ( ln_proc_level

3480: FND_LOG.STRING ( ln_proc_level
3481: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3482: , '20 Process flag ' || p_process_flag
3483: );
3484: FND_LOG.STRING ( ln_proc_level
3485: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3486: , '20 Process message ' || p_process_message
3487: );
3488: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 3510: FND_LOG.STRING ( ln_proc_level

3506: if p_process_flag = 'E' then
3507: IF ( ln_proc_level >= ln_dbg_level)
3508: THEN
3509:
3510: FND_LOG.STRING ( ln_proc_level
3511: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3512: , '21 Process flag ' || p_process_flag
3513: );
3514: FND_LOG.STRING ( ln_proc_level

Line 3514: FND_LOG.STRING ( ln_proc_level

3510: FND_LOG.STRING ( ln_proc_level
3511: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3512: , '21 Process flag ' || p_process_flag
3513: );
3514: FND_LOG.STRING ( ln_proc_level
3515: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3516: , '21 Process message ' || p_process_message
3517: );
3518: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 3558: FND_LOG.STRING ( ln_proc_level

3554: if p_process_flag = 'E' then
3555: IF ( ln_proc_level >= ln_dbg_level)
3556: THEN
3557:
3558: FND_LOG.STRING ( ln_proc_level
3559: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3560: , '22 Process flag ' || p_process_flag
3561: );
3562: FND_LOG.STRING ( ln_proc_level

Line 3562: FND_LOG.STRING ( ln_proc_level

3558: FND_LOG.STRING ( ln_proc_level
3559: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3560: , '22 Process flag ' || p_process_flag
3561: );
3562: FND_LOG.STRING ( ln_proc_level
3563: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3564: , '22 Process message ' || p_process_message
3565: );
3566: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 3587: FND_LOG.STRING ( ln_proc_level

3583: if p_process_flag = 'E' then
3584: IF ( ln_proc_level >= ln_dbg_level)
3585: THEN
3586:
3587: FND_LOG.STRING ( ln_proc_level
3588: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3589: , '23 Process flag ' || p_process_flag
3590: );
3591: FND_LOG.STRING ( ln_proc_level

Line 3591: FND_LOG.STRING ( ln_proc_level

3587: FND_LOG.STRING ( ln_proc_level
3588: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3589: , '23 Process flag ' || p_process_flag
3590: );
3591: FND_LOG.STRING ( ln_proc_level
3592: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3593: , '23 Process message ' || p_process_message
3594: );
3595: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 3636: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Exception threshold heaer id: ' || ln_threshold_hdr_id);

3632: if nvl(lv_valid_flg, 'N') = 'N' then
3633: ln_threshold_hdr_id := null; --If no effective threshold type, use normal threshold setup
3634: end if;
3635: end if;
3636: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Exception threshold heaer id: ' || ln_threshold_hdr_id);
3637: -------------------------------------------------------------
3638: --added by Chong for bug#16580553 20130402 End
3639:
3640: if nvl(ln_threshold_hdr_id,0) = 0 then

Line 3667: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'threshold heaer id: ' || ln_threshold_hdr_id);

3663: end if;
3664:
3665: end if;
3666:
3667: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'threshold heaer id: ' || ln_threshold_hdr_id);
3668:
3669:
3670:
3671: ln_check_slab_exists := NULL;

Line 3954: FND_LOG.STRING ( ln_proc_level

3950:
3951: IF ( ln_proc_level >= ln_dbg_level)
3952: THEN
3953:
3954: FND_LOG.STRING ( ln_proc_level
3955: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3956: , ' 8. TDS Vendor type ' || lv_vendor_type_lookup_code
3957: );
3958:

Line 3975: FND_LOG.STRING ( ln_proc_level

3971:
3972: IF ( ln_proc_level >= ln_dbg_level)
3973: THEN
3974:
3975: FND_LOG.STRING ( ln_proc_level
3976: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3977: , ' 8.1 Pan number-> ' || lv_pan_no
3978: );
3979: FND_LOG.STRING ( ln_proc_level

Line 3979: FND_LOG.STRING ( ln_proc_level

3975: FND_LOG.STRING ( ln_proc_level
3976: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3977: , ' 8.1 Pan number-> ' || lv_pan_no
3978: );
3979: FND_LOG.STRING ( ln_proc_level
3980: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
3981: , ' 8.1 Tan number-> ' || lv_tan_no
3982: );
3983: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 3998: FND_LOG.STRING ( ln_proc_level

3994:
3995: IF ( ln_proc_level >= ln_dbg_level)
3996: THEN
3997:
3998: FND_LOG.STRING ( ln_proc_level
3999: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4000: , ' 8.2 Fin Year -> ' || ln_fin_year
4001: );
4002:

Line 4022: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Process section: '||r_section_cod.SECTION_CODE);

4018: nvl(PPAY_AMT(r_section_cod.SECTION_CODE),0)
4019: )
4020: LOOP
4021:
4022: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Process section: '||r_section_cod.SECTION_CODE);
4023: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
4024: ln_threshold_grp_id := 0;
4025:
4026: --Added by Zhiwei Hou on 20120109 begin

Line 4144: FND_LOG.STRING ( ln_proc_level

4140:
4141: IF ( ln_proc_level >= ln_dbg_level)
4142: THEN
4143:
4144: FND_LOG.STRING ( ln_proc_level
4145: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4146: , ' 19.1 Process flag -> ' || p_process_flag
4147: );
4148: FND_LOG.STRING ( ln_proc_level

Line 4148: FND_LOG.STRING ( ln_proc_level

4144: FND_LOG.STRING ( ln_proc_level
4145: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4146: , ' 19.1 Process flag -> ' || p_process_flag
4147: );
4148: FND_LOG.STRING ( ln_proc_level
4149: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4150: , ' 19.1 Process message -> ' || p_process_message
4151: );
4152: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4175: FND_LOG.STRING ( ln_proc_level

4171: );
4172: IF ( ln_proc_level >= ln_dbg_level)
4173: THEN
4174:
4175: FND_LOG.STRING ( ln_proc_level
4176: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4177: , ' 19.2 Process flag -> ' || p_process_flag
4178: );
4179: FND_LOG.STRING ( ln_proc_level

Line 4179: FND_LOG.STRING ( ln_proc_level

4175: FND_LOG.STRING ( ln_proc_level
4176: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4177: , ' 19.2 Process flag -> ' || p_process_flag
4178: );
4179: FND_LOG.STRING ( ln_proc_level
4180: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4181: , ' 19.2 Process message -> ' || p_process_message
4182: );
4183: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4208: FND_LOG.STRING ( ln_proc_level

4204:
4205: IF ( ln_proc_level >= ln_dbg_level)
4206: THEN
4207:
4208: FND_LOG.STRING ( ln_proc_level
4209: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4210: , ' 9 Threshold hdr id -> ' || ln_threshold_hdr_id
4211: );
4212:

Line 4267: FND_LOG.STRING ( ln_proc_level

4263:
4264: IF ( ln_proc_level >= ln_dbg_level)
4265: THEN
4266:
4267: FND_LOG.STRING ( ln_proc_level
4268: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4269: , '11. Threshold grp id ->' || ln_threshold_grp_id
4270: );
4271:

Line 4300: FND_LOG.STRING ( ln_proc_level

4296: end if;*/
4297: IF ( ln_proc_level >= ln_dbg_level)
4298: THEN
4299:
4300: FND_LOG.STRING ( ln_proc_level
4301: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4302: , '12. Total invoice amount -> ' || ln_total_invoice_amount
4303: );
4304:

Line 4353: FND_LOG.STRING ( ln_proc_level

4349:
4350: IF ( ln_proc_level >= ln_dbg_level)
4351: THEN
4352:
4353: FND_LOG.STRING ( ln_proc_level
4354: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4355: , '15. Threshold slab id before ' || ln_threshold_slab_id_before
4356: );
4357:

Line 4417: FND_LOG.STRING ( ln_proc_level

4413: ln_threshold_slab_id_after := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
4414: IF ( ln_proc_level >= ln_dbg_level)
4415: THEN
4416:
4417: FND_LOG.STRING ( ln_proc_level
4418: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4419: , '15. Threshold slab id after ' || ln_threshold_slab_id_after
4420: );
4421:

Line 4438: FND_LOG.STRING ( ln_proc_level

4434: end if; /* if ln_threshold_slab_id_after <> 0 */
4435: IF ( ln_proc_level >= ln_dbg_level)
4436: THEN
4437:
4438: FND_LOG.STRING ( ln_proc_level
4439: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4440: , '19. Generate invoices -> ' || lv_generate_all_invoices
4441: );
4442:

Line 4473: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '19.1. ln_threshold_slab_id_single: ' || ln_threshold_slab_id_single);

4469: end if;
4470:
4471:
4472: ln_threshold_slab_id_single := nvl(r_jai_ap_tds_thhold_slabs.threshold_slab_id, 0);
4473: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '19.1. ln_threshold_slab_id_single: ' || ln_threshold_slab_id_single);
4474: end if;
4475:
4476: --====================================================
4477: /* Loop and generate invoices */

Line 4531: FND_LOG.STRING ( ln_proc_level

4527:
4528: IF ( ln_proc_level >= ln_dbg_level)
4529: THEN
4530:
4531: FND_LOG.STRING ( ln_proc_level
4532: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4533: , '20. Call generate tds invoices' || ''
4534: );
4535: FND_LOG.STRING ( ln_proc_level

Line 4535: FND_LOG.STRING ( ln_proc_level

4531: FND_LOG.STRING ( ln_proc_level
4532: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4533: , '20. Call generate tds invoices' || ''
4534: );
4535: FND_LOG.STRING ( ln_proc_level
4536: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4537: , ' Tax amount while calling generate tds invoices ' || cur_rec.tax_amount
4538: );
4539: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4572: FND_LOG.STRING ( ln_proc_level

4568: if p_process_flag = 'E' then
4569: IF ( ln_proc_level >= ln_dbg_level)
4570: THEN
4571:
4572: FND_LOG.STRING ( ln_proc_level
4573: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4574: , '20 Process flag ' || p_process_flag
4575: );
4576: FND_LOG.STRING ( ln_proc_level

Line 4576: FND_LOG.STRING ( ln_proc_level

4572: FND_LOG.STRING ( ln_proc_level
4573: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4574: , '20 Process flag ' || p_process_flag
4575: );
4576: FND_LOG.STRING ( ln_proc_level
4577: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4578: , '20 Process message ' || p_process_message
4579: );
4580: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4597: FND_LOG.STRING ( ln_proc_level

4593:
4594: IF ( ln_proc_level >= ln_dbg_level)
4595: THEN
4596:
4597: FND_LOG.STRING ( ln_proc_level
4598: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4599: , ' 22. start thhold trx id ' || ln_start_threshold_trx_id
4600: );
4601:

Line 4626: FND_LOG.STRING ( ln_proc_level

4622: );
4623: IF ( ln_proc_level >= ln_dbg_level)
4624: THEN
4625:
4626: FND_LOG.STRING ( ln_proc_level
4627: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4628: , '23 Process flag ' || p_process_flag
4629: );
4630: FND_LOG.STRING ( ln_proc_level

Line 4630: FND_LOG.STRING ( ln_proc_level

4626: FND_LOG.STRING ( ln_proc_level
4627: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4628: , '23 Process flag ' || p_process_flag
4629: );
4630: FND_LOG.STRING ( ln_proc_level
4631: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4632: , '23 Process message ' || p_process_message
4633: );
4634: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4675: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_trx_id: ' || ln_threshold_trx_id);

4671: --Added by Chong for bug#16414088 eTDS ER Start
4672: ----------------------------------------------------------------------
4673: --Hook code add here after the loop of call generate_dtc_invoices
4674: IF ln_threshold_trx_id IS NULL THEN -- no TDS generated
4675: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_trx_id: ' || ln_threshold_trx_id);
4676: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'cur_rec_section.actual_section_code: ' || cur_rec_section.actual_section_code);
4677: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_grp_id: ' || ln_threshold_grp_id);
4678: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_hdr_id: ' || ln_threshold_hdr_id);
4679:

Line 4676: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'cur_rec_section.actual_section_code: ' || cur_rec_section.actual_section_code);

4672: ----------------------------------------------------------------------
4673: --Hook code add here after the loop of call generate_dtc_invoices
4674: IF ln_threshold_trx_id IS NULL THEN -- no TDS generated
4675: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_trx_id: ' || ln_threshold_trx_id);
4676: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'cur_rec_section.actual_section_code: ' || cur_rec_section.actual_section_code);
4677: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_grp_id: ' || ln_threshold_grp_id);
4678: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_hdr_id: ' || ln_threshold_hdr_id);
4679:
4680: --Added for bug#16889298 for 0% rate 20130531 Start

Line 4677: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_grp_id: ' || ln_threshold_grp_id);

4673: --Hook code add here after the loop of call generate_dtc_invoices
4674: IF ln_threshold_trx_id IS NULL THEN -- no TDS generated
4675: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_trx_id: ' || ln_threshold_trx_id);
4676: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'cur_rec_section.actual_section_code: ' || cur_rec_section.actual_section_code);
4677: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_grp_id: ' || ln_threshold_grp_id);
4678: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_hdr_id: ' || ln_threshold_hdr_id);
4679:
4680: --Added for bug#16889298 for 0% rate 20130531 Start
4681: --------------------------------------------------------------------------

Line 4678: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_hdr_id: ' || ln_threshold_hdr_id);

4674: IF ln_threshold_trx_id IS NULL THEN -- no TDS generated
4675: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_trx_id: ' || ln_threshold_trx_id);
4676: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'cur_rec_section.actual_section_code: ' || cur_rec_section.actual_section_code);
4677: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_grp_id: ' || ln_threshold_grp_id);
4678: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_threshold_hdr_id: ' || ln_threshold_hdr_id);
4679:
4680: --Added for bug#16889298 for 0% rate 20130531 Start
4681: --------------------------------------------------------------------------
4682: OPEN c_is_zero_rate_section(cur_rec_section.actual_section_code);

Line 4742: FND_LOG.STRING ( ln_proc_level

4738:
4739: IF ( ln_proc_level >= ln_dbg_level)
4740: THEN
4741:
4742: FND_LOG.STRING ( ln_proc_level
4743: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4744: , '26. Call process transition ' || ''
4745: );
4746: FND_LOG.STRING ( ln_proc_level

Line 4746: FND_LOG.STRING ( ln_proc_level

4742: FND_LOG.STRING ( ln_proc_level
4743: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4744: , '26. Call process transition ' || ''
4745: );
4746: FND_LOG.STRING ( ln_proc_level
4747: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4748: , '26. Event is ' || lv_slab_transition_tds_event
4749: );
4750: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4817: FND_LOG.STRING ( ln_proc_level

4813:
4814: IF ( ln_proc_level >= ln_dbg_level)
4815: THEN
4816:
4817: FND_LOG.STRING ( ln_proc_level
4818: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4819: , '27 Process flag ' || p_process_flag
4820: );
4821: FND_LOG.STRING ( ln_proc_level

Line 4821: FND_LOG.STRING ( ln_proc_level

4817: FND_LOG.STRING ( ln_proc_level
4818: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4819: , '27 Process flag ' || p_process_flag
4820: );
4821: FND_LOG.STRING ( ln_proc_level
4822: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4823: , '27 Process message ' || p_process_message
4824: );
4825: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4902: FND_LOG.STRING ( ln_proc_level

4898:
4899: IF ( ln_proc_level >= ln_dbg_level)
4900: THEN
4901:
4902: FND_LOG.STRING ( ln_proc_level
4903: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4904: , '31 Call generate tds invoices ' || ''
4905: );
4906: FND_LOG.STRING ( ln_proc_level

Line 4906: FND_LOG.STRING ( ln_proc_level

4902: FND_LOG.STRING ( ln_proc_level
4903: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4904: , '31 Call generate tds invoices ' || ''
4905: );
4906: FND_LOG.STRING ( ln_proc_level
4907: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4908: , ' WCT Tax amt ' || cur_non_tds_rec.tax_amount
4909: );
4910: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4973: FND_LOG.STRING ( ln_proc_level

4969: if p_process_flag = 'E' then
4970: IF ( ln_proc_level >= ln_dbg_level)
4971: THEN
4972:
4973: FND_LOG.STRING ( ln_proc_level
4974: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4975: , '31 Process flag ' || p_process_flag
4976: );
4977: FND_LOG.STRING ( ln_proc_level

Line 4977: FND_LOG.STRING ( ln_proc_level

4973: FND_LOG.STRING ( ln_proc_level
4974: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4975: , '31 Process flag ' || p_process_flag
4976: );
4977: FND_LOG.STRING ( ln_proc_level
4978: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4979: , '31 Process message ' || p_process_message
4980: );
4981: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 4998: FND_LOG.STRING ( ln_proc_level

4994: end if;
4995: IF ( ln_proc_level >= ln_dbg_level)
4996: THEN
4997:
4998: FND_LOG.STRING ( ln_proc_level
4999: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5000: , '34. Start thhold trx id ' || ln_start_threshold_trx_id
5001: );
5002:

Line 5028: FND_LOG.STRING ( ln_proc_level

5024: /* If the process is called from batch do not fire import request */
5025: IF ( ln_proc_level >= ln_dbg_level)
5026: THEN
5027:
5028: FND_LOG.STRING ( ln_proc_level
5029: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5030: , '35. called from ' || p_call_from
5031: );
5032:

Line 5045: FND_LOG.STRING ( ln_proc_level

5041: IF ln_start_threshold_trx_id is not null THEN
5042: IF ( ln_proc_level >= ln_dbg_level)
5043: THEN
5044:
5045: FND_LOG.STRING ( ln_proc_level
5046: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5047: , '36 start thhold trx id ' || ln_start_threshold_trx_id
5048: );
5049:

Line 5065: FND_LOG.STRING ( ln_proc_level

5061: );
5062: IF ( ln_proc_level >= ln_dbg_level)
5063: THEN
5064:
5065: FND_LOG.STRING ( ln_proc_level
5066: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5067: , '37 Process flag ' || p_process_flag
5068: );
5069: FND_LOG.STRING ( ln_proc_level

Line 5069: FND_LOG.STRING ( ln_proc_level

5065: FND_LOG.STRING ( ln_proc_level
5066: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5067: , '37 Process flag ' || p_process_flag
5068: );
5069: FND_LOG.STRING ( ln_proc_level
5070: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5071: , '37 Process message ' || p_process_message
5072: );
5073: END IF; --( ln_proc_level >= ln_dbg_level) ;

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

5085: END IF; /* p_call_from <> 'BATCH' then */
5086:
5087: <>
5088: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath); /* 100 */
5089: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
5090: return;
5091:
5092: exception
5093: when others then

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

5293: --Add by Zhiwei Hou on 20120114 end
5294: l_api_name CONSTANT VARCHAR2(50) := 'process_threshold_transition()';
5295: BEGIN
5296:
5297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
5298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: ' ||p_threshold_grp_id);
5299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_slab_id: ' ||p_threshold_slab_id);
5300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: ' ||p_invoice_id);
5301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepayment_inovice_id: ' ||pn_prepayment_inovice_id);

Line 5298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: ' ||p_threshold_grp_id);

5294: l_api_name CONSTANT VARCHAR2(50) := 'process_threshold_transition()';
5295: BEGIN
5296:
5297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
5298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: ' ||p_threshold_grp_id);
5299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_slab_id: ' ||p_threshold_slab_id);
5300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: ' ||p_invoice_id);
5301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepayment_inovice_id: ' ||pn_prepayment_inovice_id);
5302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_unapply_amount: ' ||pn_unapply_amount);

Line 5299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_slab_id: ' ||p_threshold_slab_id);

5295: BEGIN
5296:
5297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
5298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: ' ||p_threshold_grp_id);
5299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_slab_id: ' ||p_threshold_slab_id);
5300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: ' ||p_invoice_id);
5301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepayment_inovice_id: ' ||pn_prepayment_inovice_id);
5302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_unapply_amount: ' ||pn_unapply_amount);
5303: open get_section_info(p_threshold_grp_id);

Line 5300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: ' ||p_invoice_id);

5296:
5297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
5298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: ' ||p_threshold_grp_id);
5299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_slab_id: ' ||p_threshold_slab_id);
5300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: ' ||p_invoice_id);
5301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepayment_inovice_id: ' ||pn_prepayment_inovice_id);
5302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_unapply_amount: ' ||pn_unapply_amount);
5303: open get_section_info(p_threshold_grp_id);
5304: fetch get_section_info into lv_section_type,lv_section_code;

Line 5301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepayment_inovice_id: ' ||pn_prepayment_inovice_id);

5297: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
5298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: ' ||p_threshold_grp_id);
5299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_slab_id: ' ||p_threshold_slab_id);
5300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: ' ||p_invoice_id);
5301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepayment_inovice_id: ' ||pn_prepayment_inovice_id);
5302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_unapply_amount: ' ||pn_unapply_amount);
5303: open get_section_info(p_threshold_grp_id);
5304: fetch get_section_info into lv_section_type,lv_section_code;
5305: close get_section_info;

Line 5302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_unapply_amount: ' ||pn_unapply_amount);

5298: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: ' ||p_threshold_grp_id);
5299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_slab_id: ' ||p_threshold_slab_id);
5300: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: ' ||p_invoice_id);
5301: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_prepayment_inovice_id: ' ||pn_prepayment_inovice_id);
5302: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name||'.Parameters', 'pn_unapply_amount: ' ||pn_unapply_amount);
5303: open get_section_info(p_threshold_grp_id);
5304: fetch get_section_info into lv_section_type,lv_section_code;
5305: close get_section_info;
5306:

Line 5313: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name,

5309: open get_tax_category(p_threshold_slab_id);
5310: fetch get_tax_category into ln_tax_category_id, ln_threshold_hdr_id; --Added threshold hdr ID by Chong for bug#16414088
5311: close get_tax_category;
5312:
5313: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name,
5314: 'Threshold transition tax catetory id: ' || ln_tax_category_id);
5315:
5316:
5317:

Line 5374: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_process_message);

5370: ---------------------------------------------------------------------------
5371: IF ln_rounding_factor IS NULL THEN
5372: p_process_flag := 'E';
5373: p_process_message := 'Rounding Rule for Tax Basis is not defined for the entered GL Period. Invoice:' || TRAN_TAB(i).INVOICE_ID;
5374: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_process_message);
5375: goto exit_from_procedure;
5376: END IF;
5377:
5378: ln_tax_rounding_factor := get_tax_rounding(TRAN_TAB(i).INVOICE_ID);

Line 5382: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_process_message);

5378: ln_tax_rounding_factor := get_tax_rounding(TRAN_TAB(i).INVOICE_ID);
5379: IF ln_tax_rounding_factor IS NULL THEN
5380: p_process_flag := 'E';
5381: p_process_message := 'Rounding Rule for Tax is not defined for the entered GL Period. Invoice:' || TRAN_TAB(i).INVOICE_ID;
5382: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name, p_process_message);
5383: goto exit_from_procedure;
5384: END IF;
5385: ---------------------------------------------------------------------------
5386: --Added by Chong for bug#15939571 20121210 End

Line 5689: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name,

5685:
5686: FOR rec_surcharge in chk_surcharge_tax(LN_TAX_CATEGORY_ID)
5687: LOOP
5688:
5689: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name,
5690: 'Surcharge tax id:' || rec_surcharge.tax_id || ' Surcharge tax rate: ' || rec_surcharge.tax_rate);
5691:
5692:
5693: if rec_surcharge.tax_rate > 0 then

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

5793: END LOOP;
5794:
5795:
5796: <>
5797: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
5798: return;
5799:
5800: exception
5801: when others then

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

6003: l_api_name CONSTANT VARCHAR2(50) := 'generate_tds_invoices()';
6004:
6005: begin
6006:
6007: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
6008: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
6009: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);

Line 6008: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);

6004:
6005: begin
6006:
6007: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
6008: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
6009: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);
6012: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);

Line 6009: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);

6005: begin
6006:
6007: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
6008: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
6009: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);
6012: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
6013: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_hdr_id: ' || pn_threshold_hdr_id);

Line 6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);

6006:
6007: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
6008: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
6009: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);
6012: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
6013: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_hdr_id: ' || pn_threshold_hdr_id);
6014: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_grp_id: ' || pn_threshold_grp_id);

Line 6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);

6007: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
6008: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
6009: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);
6012: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
6013: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_hdr_id: ' || pn_threshold_hdr_id);
6014: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_grp_id: ' || pn_threshold_grp_id);
6015:

Line 6012: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);

6008: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
6009: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);
6012: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
6013: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_hdr_id: ' || pn_threshold_hdr_id);
6014: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_grp_id: ' || pn_threshold_grp_id);
6015:
6016: lv_source := 'INDIA TDS'; /* --:= 'TDS'; --Ramanand for bug#4388958 */

Line 6013: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_hdr_id: ' || pn_threshold_hdr_id);

6009: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);
6012: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
6013: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_hdr_id: ' || pn_threshold_hdr_id);
6014: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_grp_id: ' || pn_threshold_grp_id);
6015:
6016: lv_source := 'INDIA TDS'; /* --:= 'TDS'; --Ramanand for bug#4388958 */
6017: lv_invoice_to_tds_line_type := 'ITEM';

Line 6014: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_grp_id: ' || pn_threshold_grp_id);

6010: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
6011: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_id: ' || pn_tax_id);
6012: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
6013: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_hdr_id: ' || pn_threshold_hdr_id);
6014: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_threshold_grp_id: ' || pn_threshold_grp_id);
6015:
6016: lv_source := 'INDIA TDS'; /* --:= 'TDS'; --Ramanand for bug#4388958 */
6017: lv_invoice_to_tds_line_type := 'ITEM';
6018: lv_invoice_to_vendor_line_type := 'ITEM';

Line 6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);

6548: fnd_file.put_line(FND_FILE.LOG, 'stformtype '||r_ja_in_tax_codes.stform_type);
6549: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
6550: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
6551:
6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);
6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);
6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);
6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);

Line 6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);

6549: fnd_file.put_line(FND_FILE.LOG, 'org id '|| r_ap_invoices_all.org_id);
6550: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
6551:
6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);
6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);
6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);
6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);

Line 6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);

6550: fnd_file.put_line(FND_FILE.LOG, 'src att'||lv_source_attribute);
6551:
6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);
6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);
6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);
6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);
6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);

Line 6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);

6551:
6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);
6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);
6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);
6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);
6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);
6559: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'stformtype '||r_ja_in_tax_codes.stform_type);

Line 6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);

6552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_invoice_amount: ' || ln_invoice_amount);
6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);
6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);
6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);
6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);
6559: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'stformtype '||r_ja_in_tax_codes.stform_type);
6560: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'org id '|| r_ap_invoices_all.org_id);

Line 6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);

6553: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'invoice to tds inv num'|| lv_invoice_to_tds_num);
6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);
6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);
6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);
6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);
6559: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'stformtype '||r_ja_in_tax_codes.stform_type);
6560: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'org id '|| r_ap_invoices_all.org_id);
6561: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'src att'||lv_source_attribute);

Line 6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);

6554: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'vendor num' ||lv_invoice_to_vendor_num);
6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);
6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);
6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);
6559: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'stformtype '||r_ja_in_tax_codes.stform_type);
6560: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'org id '|| r_ap_invoices_all.org_id);
6561: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'src att'||lv_source_attribute);
6562:

Line 6559: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'stformtype '||r_ja_in_tax_codes.stform_type);

6555: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax id '||pn_tax_id);
6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);
6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);
6559: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'stformtype '||r_ja_in_tax_codes.stform_type);
6560: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'org id '|| r_ap_invoices_all.org_id);
6561: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'src att'||lv_source_attribute);
6562:
6563: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019

Line 6560: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'org id '|| r_ap_invoices_all.org_id);

6556: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tax rate'|| r_ja_in_tax_codes.tax_rate);
6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);
6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);
6559: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'stformtype '||r_ja_in_tax_codes.stform_type);
6560: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'org id '|| r_ap_invoices_all.org_id);
6561: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'src att'||lv_source_attribute);
6562:
6563: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
6564: insert into JAI_AP_TDS_INVOICES

Line 6561: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'src att'||lv_source_attribute);

6557: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'tds amt'||ln_invoice_to_tds_amount);
6558: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'sec code '||r_ja_in_tax_codes.section_code);
6559: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'stformtype '||r_ja_in_tax_codes.stform_type);
6560: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'org id '|| r_ap_invoices_all.org_id);
6561: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'src att'||lv_source_attribute);
6562:
6563: IF NVL(ln_invoice_amount,0) <> 0 THEN --Added the condition by bgowrava for Bug#4549019
6564: insert into JAI_AP_TDS_INVOICES
6565: (TDS_INVOICE_ID,

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

6728: )
6729: returning threshold_trx_id into pn_threshold_trx_id;
6730:
6731: <>
6732: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
6733: return;
6734:
6735: exception
6736: when others then

Line 7053: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

7049: ---------------------------------------------
7050: --Added by Zhiwei Hou on 20120113 end
7051: --Added by Zhiwei Hou on 20120203 begin
7052: -------------------------------------------------------------------
7053: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
7054: ln_proc_level NUMBER := FND_LOG.level_procedure;
7055: lv_proc_name VARCHAR2 (100) := 'generate_dtc_invoices';
7056: -------------------------------------------------------------------
7057: --Added by Zhiwei Hou on 20120203 end

Line 7054: ln_proc_level NUMBER := FND_LOG.level_procedure;

7050: --Added by Zhiwei Hou on 20120113 end
7051: --Added by Zhiwei Hou on 20120203 begin
7052: -------------------------------------------------------------------
7053: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
7054: ln_proc_level NUMBER := FND_LOG.level_procedure;
7055: lv_proc_name VARCHAR2 (100) := 'generate_dtc_invoices';
7056: -------------------------------------------------------------------
7057: --Added by Zhiwei Hou on 20120203 end
7058: l_api_name CONSTANT VARCHAR2(50) := 'generate_dtc_invoices()';

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

7057: --Added by Zhiwei Hou on 20120203 end
7058: l_api_name CONSTANT VARCHAR2(50) := 'generate_dtc_invoices()';
7059: begin
7060:
7061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
7062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
7063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);

Line 7062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);

7058: l_api_name CONSTANT VARCHAR2(50) := 'generate_dtc_invoices()';
7059: begin
7060:
7061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
7062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
7063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);
7066: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_type: ' || pv_section_type);

Line 7063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);

7059: begin
7060:
7061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
7062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
7063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);
7066: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_type: ' || pv_section_type);
7067: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_code: ' || pv_section_code);

Line 7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);

7060:
7061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
7062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
7063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);
7066: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_type: ' || pv_section_type);
7067: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_code: ' || pv_section_code);
7068: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);

Line 7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);

7061: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
7062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
7063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);
7066: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_type: ' || pv_section_type);
7067: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_code: ' || pv_section_code);
7068: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
7069: lv_source := 'INDIA TDS'; /* --:= 'TDS'; --Ramanand for bug#4388958 */

Line 7066: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_type: ' || pv_section_type);

7062: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_invoice_id: ' || pn_invoice_id);
7063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);
7066: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_type: ' || pv_section_type);
7067: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_code: ' || pv_section_code);
7068: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
7069: lv_source := 'INDIA TDS'; /* --:= 'TDS'; --Ramanand for bug#4388958 */
7070: lv_invoice_to_tds_line_type := 'ITEM';

Line 7067: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_code: ' || pv_section_code);

7063: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_taxable_amount: ' || pn_taxable_amount);
7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);
7066: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_type: ' || pv_section_type);
7067: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_code: ' || pv_section_code);
7068: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
7069: lv_source := 'INDIA TDS'; /* --:= 'TDS'; --Ramanand for bug#4388958 */
7070: lv_invoice_to_tds_line_type := 'ITEM';
7071: lv_invoice_to_vendor_line_type := 'ITEM';

Line 7068: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);

7064: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_amount: ' || pn_tax_amount);
7065: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pn_tax_category_id: ' || pn_tax_category_id);
7066: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_type: ' || pv_section_type);
7067: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_section_code: ' || pv_section_code);
7068: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameter', 'pv_tds_event: ' || pv_tds_event);
7069: lv_source := 'INDIA TDS'; /* --:= 'TDS'; --Ramanand for bug#4388958 */
7070: lv_invoice_to_tds_line_type := 'ITEM';
7071: lv_invoice_to_vendor_line_type := 'ITEM';
7072: lv_this_procedure := 'jaiap.generate_dtc_invoice';

Line 7303: FND_LOG.STRING ( ln_proc_level

7299: ln_invoice_to_tds_amount := get_rnded_value(ln_invoice_to_tds_amount);
7300: IF ( ln_proc_level >= ln_dbg_level)
7301: THEN
7302:
7303: FND_LOG.STRING ( ln_proc_level
7304: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7305: , 'value after round per setup TDS auth inv' || ln_invoice_to_tds_amount
7306: );
7307:

Line 7358: FND_LOG.STRING ( ln_proc_level

7354: END IF;
7355: IF ( ln_proc_level >= ln_dbg_level)
7356: THEN
7357:
7358: FND_LOG.STRING ( ln_proc_level
7359: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7360: , 'value before round ' || ln_invoice_to_vendor_amount
7361: );
7362:

Line 7374: FND_LOG.STRING ( ln_proc_level

7370:
7371: IF ( ln_proc_level >= ln_dbg_level)
7372: THEN
7373:
7374: FND_LOG.STRING ( ln_proc_level
7375: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7376: , ' CALL utils for inserting interface lines' || ''
7377: );
7378:

Line 7692: FND_LOG.STRING ( ln_proc_level

7688: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
7689: IF ( ln_proc_level >= ln_dbg_level)
7690: THEN
7691:
7692: FND_LOG.STRING ( ln_proc_level
7693: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7694: , 'pn_taxable_amount ' || pn_taxable_amount
7695: );
7696: FND_LOG.STRING ( ln_proc_level

Line 7696: FND_LOG.STRING ( ln_proc_level

7692: FND_LOG.STRING ( ln_proc_level
7693: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7694: , 'pn_taxable_amount ' || pn_taxable_amount
7695: );
7696: FND_LOG.STRING ( ln_proc_level
7697: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7698: , ' invoice amount ' || ln_invoice_amount
7699: );
7700: END IF; --( ln_proc_level >= ln_dbg_level) ;

Line 7721: FND_LOG.STRING ( ln_proc_level

7717:
7718: IF ( ln_proc_level >= ln_dbg_level)
7719: THEN
7720:
7721: FND_LOG.STRING ( ln_proc_level
7722: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7723: , ' invoice id ' || pn_invoice_id
7724: );
7725: FND_LOG.STRING ( ln_proc_level

Line 7725: FND_LOG.STRING ( ln_proc_level

7721: FND_LOG.STRING ( ln_proc_level
7722: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7723: , ' invoice id ' || pn_invoice_id
7724: );
7725: FND_LOG.STRING ( ln_proc_level
7726: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7727: , ' invoice amount ' || ln_invoice_amount
7728: );
7729: FND_LOG.STRING ( ln_proc_level

Line 7729: FND_LOG.STRING ( ln_proc_level

7725: FND_LOG.STRING ( ln_proc_level
7726: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7727: , ' invoice amount ' || ln_invoice_amount
7728: );
7729: FND_LOG.STRING ( ln_proc_level
7730: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7731: , ' invoice to tds inv num ' || lv_invoice_to_tds_num
7732: );
7733: FND_LOG.STRING ( ln_proc_level

Line 7733: FND_LOG.STRING ( ln_proc_level

7729: FND_LOG.STRING ( ln_proc_level
7730: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7731: , ' invoice to tds inv num ' || lv_invoice_to_tds_num
7732: );
7733: FND_LOG.STRING ( ln_proc_level
7734: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7735: , ' vendor num ' || lv_invoice_to_vendor_num
7736: );
7737: FND_LOG.STRING ( ln_proc_level

Line 7737: FND_LOG.STRING ( ln_proc_level

7733: FND_LOG.STRING ( ln_proc_level
7734: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7735: , ' vendor num ' || lv_invoice_to_vendor_num
7736: );
7737: FND_LOG.STRING ( ln_proc_level
7738: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7739: , ' tax category id ' || pn_tax_category_id
7740: );
7741: FND_LOG.STRING ( ln_proc_level

Line 7741: FND_LOG.STRING ( ln_proc_level

7737: FND_LOG.STRING ( ln_proc_level
7738: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7739: , ' tax category id ' || pn_tax_category_id
7740: );
7741: FND_LOG.STRING ( ln_proc_level
7742: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7743: , ' tds amt ' || ln_invoice_to_tds_amount
7744: );
7745: FND_LOG.STRING ( ln_proc_level

Line 7745: FND_LOG.STRING ( ln_proc_level

7741: FND_LOG.STRING ( ln_proc_level
7742: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7743: , ' tds amt ' || ln_invoice_to_tds_amount
7744: );
7745: FND_LOG.STRING ( ln_proc_level
7746: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
7747: , ' sec code ' || pv_section_code
7748: );
7749:

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

7934: )
7935: returning threshold_trx_id into pn_threshold_trx_id;
7936:
7937: <>
7938: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
7939: return;
7940:
7941: exception
7942: when others then

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

8000: ln_report_request_id NUMBER;
8001: /*Added for bug#15915537 TDS Performance ER on 26-Nov-2012 by Qimeng begin*/
8002:
8003: begin
8004: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8005: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'p_tds_event='||p_tds_event);
8006: fnd_file.put_line (fnd_file.log, 'p_tds_event='||p_tds_event);
8007: --Added by Sanjikum for Bug#5131075(4722011)
8008: IF p_tds_event = 'PREPAYMENT APPLICATION' OR p_tds_event = 'PREPAYMENT UNAPPLICATION' THEN

Line 8005: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'p_tds_event='||p_tds_event);

8001: /*Added for bug#15915537 TDS Performance ER on 26-Nov-2012 by Qimeng begin*/
8002:
8003: begin
8004: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8005: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name, 'p_tds_event='||p_tds_event);
8006: fnd_file.put_line (fnd_file.log, 'p_tds_event='||p_tds_event);
8007: --Added by Sanjikum for Bug#5131075(4722011)
8008: IF p_tds_event = 'PREPAYMENT APPLICATION' OR p_tds_event = 'PREPAYMENT UNAPPLICATION' THEN
8009: lv_group_id := to_char(p_invoice_id)||p_tds_event;

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

8172: /*Added for bug#15915537 TDS Performance ER on 26-Nov-2012 by Qimeng end*/
8173:
8174:
8175: <>
8176: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
8177: return;
8178:
8179: exception
8180: when others then

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

8240: ln_holds_count1 NUMBER;
8241: l_api_name CONSTANT VARCHAR2(50) := 'approve_tds_invoices()';
8242:
8243: begin
8244: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8245: /* Check for the status of the import request */
8246: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
8247: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
8248: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );

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

8453: end loop;
8454:
8455:
8456: <>
8457: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
8458: return;
8459:
8460: exception
8461: when others then

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

8511: ln_invoice_id ap_invoices_all.invoice_id%type;
8512: l_api_name CONSTANT VARCHAR2(50) := 'populate_tds_invoice_id()';
8513:
8514: begin
8515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8516: open c_check_inv_to_tds_authority(p_invoice_num, p_vendor_id, p_vendor_site_id);
8517: --fetch c_check_inv_to_tds_authority into ln_threshold_trx_id, ln_invoice_id; --Commented by Chong for bug#16414088 eTDS ER
8518: fetch c_check_inv_to_tds_authority into r_check_inv_to_tds; --Added by Chong for bug#16414088 eTDS ER
8519: close c_check_inv_to_tds_authority;

Line 8552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name,

8548: );
8549: END IF;
8550: EXCEPTION
8551: WHEN OTHERS THEN
8552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_ERROR, G_MODULE_NAME||l_api_name,
8553: 'Failed populating TDS repository for TDS invoice: ' || p_invoice_id );
8554: ROLLBACK TO Populdated_tds_invoice_id;
8555: END;
8556: ---------------------------------------------------------------------------------------

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

8576: end if; /* TDS invoice to TDS authority */
8577:
8578:
8579: <>
8580: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
8581: return;
8582:
8583: exception
8584: when others then

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

8617: )
8618: is
8619: l_api_name CONSTANT VARCHAR2(50) := 'insert_tds_thhold_trxs()';
8620: begin
8621: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
8622: fnd_file.put_line(FND_FILE.LOG, ' Insert -> insert_tds_thhold_trxs ');
8623:
8624: insert into jai_ap_tds_thhold_trxs
8625: (

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

8684: fnd_global.login_id
8685: );
8686:
8687: fnd_file.put_line(FND_FILE.LOG, ' Done Insert -> insert_tds_thhold_trxs ');
8688: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
8689: end insert_tds_thhold_trxs;
8690:
8691: /* ******************************** create_tds_after_holds_rel ******************************************* */
8692:

Line 9141: ln_proc_level NUMBER := FND_LOG.level_procedure;

9137: lv_natural_account_segment VARCHAR2(100);
9138: lv_natural_account jai_ap_tds_thhold_account.natural_account_value%TYPE;
9139: r_CCID NUMBER;
9140: lv_proc_name VARCHAR2 (100) := 'get_tds_threshold_slab';
9141: ln_proc_level NUMBER := FND_LOG.level_procedure;
9142: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
9143: l_api_name CONSTANT VARCHAR2(50) := 'get_tds_threshold_slab()';
9144:
9145: BEGIN

Line 9142: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

9138: lv_natural_account jai_ap_tds_thhold_account.natural_account_value%TYPE;
9139: r_CCID NUMBER;
9140: lv_proc_name VARCHAR2 (100) := 'get_tds_threshold_slab';
9141: ln_proc_level NUMBER := FND_LOG.level_procedure;
9142: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
9143: l_api_name CONSTANT VARCHAR2(50) := 'get_tds_threshold_slab()';
9144:
9145: BEGIN
9146: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');

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

9142: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
9143: l_api_name CONSTANT VARCHAR2(50) := 'get_tds_threshold_slab()';
9144:
9145: BEGIN
9146: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
9147:
9148: IF p_threshold_grp_id IS NULL THEN
9149: OPEN c_get_threshold_grp_id(p_prepay_distribution_id);
9150: FETCH c_get_threshold_grp_id

Line 9276: FND_LOG.STRING ( ln_proc_level

9272: --Fnd_File.put_line(Fnd_File.LOG, 'p_threshold_type:[' || p_threshold_type || ']');
9273: --Fnd_File.put_line(Fnd_File.LOG, '**** END of procedure jai_ap_dtc_cancellation_pkg.get_tds_threshold_slab ****');
9274: IF ( ln_proc_level >= ln_dbg_level)
9275: THEN
9276: FND_LOG.STRING ( ln_proc_level
9277: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
9278: , 'p_threshold_slab_id:[' || p_threshold_slab_id || ']'
9279: );
9280: END IF; --( ln_proc_level >= ln_dbg_level)

Line 9283: FND_LOG.STRING ( ln_proc_level

9279: );
9280: END IF; --( ln_proc_level >= ln_dbg_level)
9281: IF ( ln_proc_level >= ln_dbg_level)
9282: THEN
9283: FND_LOG.STRING ( ln_proc_level
9284: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
9285: , 'p_threshold_type:[' || p_threshold_type || ']'
9286: );
9287: END IF; --( ln_proc_level >= ln_dbg_level)

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

9284: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
9285: , 'p_threshold_type:[' || p_threshold_type || ']'
9286: );
9287: END IF; --( ln_proc_level >= ln_dbg_level)
9288: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
9289: EXCEPTION
9290: WHEN OTHERS THEN
9291: p_process_flag := 'E';
9292: p_process_message := SUBSTR(SQLERRM, 1, 200);

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

9509: ln_threshold_hdr_id NUMBER;
9510: l_api_name CONSTANT VARCHAR2(50) := 'process_threshold_rollback()';
9511:
9512: BEGIN
9513: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
9514: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
9515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_before_threshold_slab_id: '||p_before_threshold_slab_id);
9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);
9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);

Line 9514: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);

9510: l_api_name CONSTANT VARCHAR2(50) := 'process_threshold_rollback()';
9511:
9512: BEGIN
9513: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
9514: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
9515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_before_threshold_slab_id: '||p_before_threshold_slab_id);
9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);
9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);
9518: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_distribution_id: '||p_invoice_distribution_id);

Line 9515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_before_threshold_slab_id: '||p_before_threshold_slab_id);

9511:
9512: BEGIN
9513: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
9514: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
9515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_before_threshold_slab_id: '||p_before_threshold_slab_id);
9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);
9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);
9518: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_distribution_id: '||p_invoice_distribution_id);
9519: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_prepay_distribution_id: '||p_prepay_distribution_id);

Line 9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);

9512: BEGIN
9513: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
9514: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
9515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_before_threshold_slab_id: '||p_before_threshold_slab_id);
9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);
9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);
9518: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_distribution_id: '||p_invoice_distribution_id);
9519: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_prepay_distribution_id: '||p_prepay_distribution_id);
9520: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_called_from: '||p_called_from);

Line 9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);

9513: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
9514: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
9515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_before_threshold_slab_id: '||p_before_threshold_slab_id);
9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);
9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);
9518: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_distribution_id: '||p_invoice_distribution_id);
9519: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_prepay_distribution_id: '||p_prepay_distribution_id);
9520: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_called_from: '||p_called_from);
9521:

Line 9518: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_distribution_id: '||p_invoice_distribution_id);

9514: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_id: '||p_invoice_id);
9515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_before_threshold_slab_id: '||p_before_threshold_slab_id);
9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);
9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);
9518: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_distribution_id: '||p_invoice_distribution_id);
9519: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_prepay_distribution_id: '||p_prepay_distribution_id);
9520: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_called_from: '||p_called_from);
9521:
9522: /*--Commented by Chong for bug#16414088 Derive section info by threshold group.

Line 9519: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_prepay_distribution_id: '||p_prepay_distribution_id);

9515: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_before_threshold_slab_id: '||p_before_threshold_slab_id);
9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);
9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);
9518: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_distribution_id: '||p_invoice_distribution_id);
9519: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_prepay_distribution_id: '||p_prepay_distribution_id);
9520: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_called_from: '||p_called_from);
9521:
9522: /*--Commented by Chong for bug#16414088 Derive section info by threshold group.
9523: IF p_invoice_distribution_id IS NOT NULL THEN

Line 9520: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_called_from: '||p_called_from);

9516: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_after_threshold_slab_id: '||p_after_threshold_slab_id);
9517: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_threshold_grp_id: '||p_threshold_grp_id);
9518: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_invoice_distribution_id: '||p_invoice_distribution_id);
9519: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_prepay_distribution_id: '||p_prepay_distribution_id);
9520: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.Parameters', 'p_called_from: '||p_called_from);
9521:
9522: /*--Commented by Chong for bug#16414088 Derive section info by threshold group.
9523: IF p_invoice_distribution_id IS NOT NULL THEN
9524: --when call from prepayment apply, distribution_id will not be null

Line 9552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Rollback TDS event: '||lv_tds_event);

9548:
9549:
9550:
9551: lv_tds_event := 'THRESHOLD ROLLBACK( from slab id - '||p_before_threshold_slab_id||' to slab id - '||p_after_threshold_slab_id||')';
9552: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Rollback TDS event: '||lv_tds_event);
9553:
9554: OPEN c_get_tax_amount_without_event(p_threshold_grp_id);
9555: FETCH c_get_tax_amount_without_event INTO ln_taxable_amount, ln_tax_amount;
9556: CLOSE c_get_tax_amount_without_event;

Line 9677: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Rollback TDS event: '||lv_tds_event);

9673: --Check if the Tax Category Attached to p_before_threshold_slab_id has Surcharge Taxes and p_after_threshold_slab_id does not have Surcharge taxes
9674:
9675: IF p_called_from = 'PREPAY' THEN
9676:
9677: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Rollback TDS event: '||lv_tds_event);
9678:
9679: OPEN c_get_tax_amount(G_SURCHARGE_CALCULATE,p_threshold_grp_id);
9680: FETCH c_get_tax_amount INTO ln_taxable_amount, ln_tax_amount;
9681: CLOSE c_get_tax_amount;

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

10244: END IF;
10245:
10246: <>
10247: lv_codepath := jai_general_pkg.plot_codepath(100,lv_codepath,NULL,'END'); /* 100 */
10248: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
10249:
10250: /* IF lv_process_flag = 'E' THEN
10251: raise_application_error(-20012, lv_process_message);
10252: END IF;*/

Line 10476: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

10472:
10473: ln_amt_for_each number;
10474: ln_tax_amt_for_each number;
10475:
10476: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
10477: ln_proc_level NUMBER := FND_LOG.level_procedure;
10478: lv_proc_name VARCHAR2 (100) := 'generate_rollback_dtc_invoices';
10479: l_api_name CONSTANT VARCHAR2(50) := 'generate_rollback_dtc_invoices()';
10480:

Line 10477: ln_proc_level NUMBER := FND_LOG.level_procedure;

10473: ln_amt_for_each number;
10474: ln_tax_amt_for_each number;
10475:
10476: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
10477: ln_proc_level NUMBER := FND_LOG.level_procedure;
10478: lv_proc_name VARCHAR2 (100) := 'generate_rollback_dtc_invoices';
10479: l_api_name CONSTANT VARCHAR2(50) := 'generate_rollback_dtc_invoices()';
10480:
10481: begin

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

10479: l_api_name CONSTANT VARCHAR2(50) := 'generate_rollback_dtc_invoices()';
10480:
10481: begin
10482:
10483: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
10484: lv_source := 'INDIA TDS'; /* --:= 'TDS'; --Ramanand for bug#4388958 */
10485: lv_invoice_to_tds_line_type := 'ITEM';
10486: lv_invoice_to_vendor_line_type := 'ITEM';
10487: lv_this_procedure := 'jaiap.generate_dtc_invoice';

Line 10621: FND_LOG.STRING ( ln_proc_level

10617: ln_invoice_to_tds_amount := get_rnded_value(ln_invoice_to_tds_amount);
10618: IF ( ln_proc_level >= ln_dbg_level)
10619: THEN
10620:
10621: FND_LOG.STRING ( ln_proc_level
10622: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
10623: , 'value after round per setup TDS auth inv' || ln_invoice_to_tds_amount
10624: );
10625:

Line 10669: FND_LOG.STRING ( ln_proc_level

10665: END IF;
10666: IF ( ln_proc_level >= ln_dbg_level)
10667: THEN
10668:
10669: FND_LOG.STRING ( ln_proc_level
10670: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
10671: , 'value before round ' || ln_invoice_to_vendor_amount
10672: );
10673:

Line 10685: FND_LOG.STRING ( ln_proc_level

10681:
10682: IF ( ln_proc_level >= ln_dbg_level)
10683: THEN
10684:
10685: FND_LOG.STRING ( ln_proc_level
10686: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
10687: , ' CALL utils for inserting interface lines' || ''
10688: );
10689:

Line 10839: FND_LOG.STRING ( ln_proc_level

10835:
10836: IF ( ln_proc_level >= ln_dbg_level)
10837: THEN
10838:
10839: FND_LOG.STRING ( ln_proc_level
10840: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
10841: , 'value before round ' || ln_invoice_to_vendor_amount
10842: );
10843:

Line 10850: FND_LOG.STRING ( ln_proc_level

10846:
10847: IF ( ln_proc_level >= ln_dbg_level)
10848: THEN
10849:
10850: FND_LOG.STRING ( ln_proc_level
10851: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
10852: , ' CALL utils for inserting interface lines' || ''
10853: );
10854:

Line 10982: FND_LOG.STRING ( ln_proc_level

10978: --fnd_file.put_line(FND_FILE.LOG, ' invoice amount'|| ln_invoice_amount);
10979: IF ( ln_proc_level >= ln_dbg_level)
10980: THEN
10981:
10982: FND_LOG.STRING ( ln_proc_level
10983: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
10984: , 'pn_taxable_amount ' || pn_taxable_amount
10985: );
10986: FND_LOG.STRING ( ln_proc_level

Line 10986: FND_LOG.STRING ( ln_proc_level

10982: FND_LOG.STRING ( ln_proc_level
10983: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
10984: , 'pn_taxable_amount ' || pn_taxable_amount
10985: );
10986: FND_LOG.STRING ( ln_proc_level
10987: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
10988: , 'ln_vendor_inv_sum_amount ' || ln_vendor_inv_sum_amount
10989: );
10990: END IF; --( ln_proc_level >= ln_dbg_level) ;

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

11105: )
11106: returning threshold_trx_id into pn_threshold_trx_id;
11107:
11108: <>
11109: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
11110: return;
11111:
11112: exception
11113: when others then