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

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

40: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
41: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
42: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
43:
44: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
45: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
47: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

41: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
42: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
43:
44: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
45: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
47: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

42: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
43:
44: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
45: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
47: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
50: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

43:
44: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
45: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
47: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
50: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
51: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.';

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

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

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

45: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
47: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
50: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
51: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.';
52:
53: PROCEDURE get_prepay_invoice_id

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

46: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
47: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
50: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
51: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.';
52:
53: PROCEDURE get_prepay_invoice_id
54: (

Line 260: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.PROCESS_PREPAYMENT', '1.2 process_unapply ');

256: P_process_message := 'Error - Cannot Unapply prepayment as it was Applied before Validating the Standard invoice';
257: goto exit_from_procedure;
258: end if;
259:
260: jai_cmn_utils_pkg.WRITE_FND_LOG_MSG('JAI.PLSQL.JAI_AP_DTC_PREPAYMENTS_PKG.PROCESS_PREPAYMENT', '1.2 process_unapply ');
261:
262: jai_ap_dtc_prepayments_pkg.process_unapply
263: (
264: p_event => p_event , --Added for Bug 8431516

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

507: --Added by Wenqiong for bug13359892 end
508: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Chong.Lei for bug#13787158
509: l_api_name CONSTANT VARCHAR2(50) := 'process_unapply()';
510: begin
511: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
512: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */
513: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Chong.Lei for bug#13787158
514:
515: open c_gl_sets_of_books(p_set_of_books_id);

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

540: --if r_get_total_prepayment_tax.tds_amount > 0 then
541: if r_get_total_prepayment_tax.tds_taxable_basis > 0 then
542: -------------------------------------------------------------------------------------------------
543: --Modified by ChongLei for bug13787158 end
544: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
545: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_parent_distribution_id: '||p_parent_distribution_id);
546: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_exchange_rate: '||ln_exchange_rate);
547:
548: OPEN c_tds_details_apply(p_invoice_id, p_parent_distribution_id, ln_exchange_rate);

Line 545: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_parent_distribution_id: '||p_parent_distribution_id);

541: if r_get_total_prepayment_tax.tds_taxable_basis > 0 then
542: -------------------------------------------------------------------------------------------------
543: --Modified by ChongLei for bug13787158 end
544: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
545: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_parent_distribution_id: '||p_parent_distribution_id);
546: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_exchange_rate: '||ln_exchange_rate);
547:
548: OPEN c_tds_details_apply(p_invoice_id, p_parent_distribution_id, ln_exchange_rate);
549: LOOP

Line 546: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_exchange_rate: '||ln_exchange_rate);

542: -------------------------------------------------------------------------------------------------
543: --Modified by ChongLei for bug13787158 end
544: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
545: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_parent_distribution_id: '||p_parent_distribution_id);
546: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_exchange_rate: '||ln_exchange_rate);
547:
548: OPEN c_tds_details_apply(p_invoice_id, p_parent_distribution_id, ln_exchange_rate);
549: LOOP
550: FETCH c_tds_details_apply INTO r_tds_details_apply;

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

1015: end if;
1016:
1017: << exit_from_procedure >>
1018: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 100 */
1019: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
1020: return;
1021:
1022: exception
1023: when others then

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

2700: l_api_name CONSTANT VARCHAR2(50) := 'allocate_prepay_section()';
2701:
2702:
2703: BEGIN
2704: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
2705: ln_remaining_prepayment_amount := abs(p_prepay_amount);
2706:
2707: get_prepay_invoice_id(p_prepay_distribution_id,ln_prepay_invoice_id);
2708: get_prepay_invoice_gl_date(p_prepay_distribution_id,ld_prepay_gl_date);

Line 2790: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Loop1 ln_application_amount:' || ln_application_amount);

2786: ELSIF cur_si_distributions_rec.tds_section_code = lv_ppay_tds_section_code THEN
2787: lv_tds_applicable := 'Y';
2788: END IF;
2789:
2790: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Loop1 ln_application_amount:' || ln_application_amount);
2791:
2792: if ln_application_amount > 0 AND nvl(lv_tds_applicable,'N') = 'Y' then
2793: insert into jai_ap_tds_prepayments
2794: (

Line 2886: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Loop2 ln_application_amount:' || ln_application_amount);

2882: ELSIF cur_si_distributions_rec.tds_section_code = lv_ppay_tds_section_code THEN
2883: lv_tds_applicable := 'Y';
2884: END IF;
2885:
2886: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'Loop2 ln_application_amount:' || ln_application_amount);
2887: if ln_application_amount > 0 AND nvl(lv_tds_applicable,'N') = 'Y' then
2888: insert into jai_ap_tds_prepayments
2889: (
2890: tds_prepayment_id ,

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

2928:
2929: END IF;
2930: END LOOP; /* cur_si_distributions_rec in c_jai_ap_tds_inv_taxes */
2931:
2932: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
2933: IF ln_remaining_prepayment_amount > 0 THEN
2934: p_process_flag := 'E';
2935: p_process_message := 'Cannot Apply Prepayment across TDS Section Codes';
2936:

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

3239: lv_section_code JAI_AP_TDS_INV_TAXES.actual_section_code%TYPE;
3240: l_api_name CONSTANT VARCHAR2(50) := 'generate_rtn()';
3241:
3242: begin
3243: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
3244:
3245: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_tds_prepayemnts_pkg.generate_rtn', 'START'); /* 1 */
3246:
3247: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id);

Line 3402: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.application_amount: '||r_get_tax_sec_det.application_amount);

3398: open c_get_tax_sec_det(p_invoice_id, p_invoice_distribution_id);
3399: fetch c_get_tax_sec_det into r_get_tax_sec_det;
3400: close c_get_tax_sec_det;
3401:
3402: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.application_amount: '||r_get_tax_sec_det.application_amount);
3403: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.tds_section_code_other: '||r_get_tax_sec_det.tds_section_code_other);
3404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3405: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);

Line 3403: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.tds_section_code_other: '||r_get_tax_sec_det.tds_section_code_other);

3399: fetch c_get_tax_sec_det into r_get_tax_sec_det;
3400: close c_get_tax_sec_det;
3401:
3402: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.application_amount: '||r_get_tax_sec_det.application_amount);
3403: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.tds_section_code_other: '||r_get_tax_sec_det.tds_section_code_other);
3404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3405: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
3407: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_distribution_id: '||p_invoice_distribution_id);

Line 3404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);

3400: close c_get_tax_sec_det;
3401:
3402: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.application_amount: '||r_get_tax_sec_det.application_amount);
3403: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.tds_section_code_other: '||r_get_tax_sec_det.tds_section_code_other);
3404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3405: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
3407: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_distribution_id: '||p_invoice_distribution_id);
3408: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_prepay_distribution_id: '||p_prepay_distribution_id);

Line 3405: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);

3401:
3402: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.application_amount: '||r_get_tax_sec_det.application_amount);
3403: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.tds_section_code_other: '||r_get_tax_sec_det.tds_section_code_other);
3404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3405: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
3407: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_distribution_id: '||p_invoice_distribution_id);
3408: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_prepay_distribution_id: '||p_prepay_distribution_id);
3409:

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

3402: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.application_amount: '||r_get_tax_sec_det.application_amount);
3403: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.tds_section_code_other: '||r_get_tax_sec_det.tds_section_code_other);
3404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3405: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
3407: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_distribution_id: '||p_invoice_distribution_id);
3408: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_prepay_distribution_id: '||p_prepay_distribution_id);
3409:
3410: if r_get_tax_sec_det.application_amount > 0

Line 3407: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_distribution_id: '||p_invoice_distribution_id);

3403: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_tax_sec_det.tds_section_code_other: '||r_get_tax_sec_det.tds_section_code_other);
3404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3405: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
3407: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_distribution_id: '||p_invoice_distribution_id);
3408: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_prepay_distribution_id: '||p_prepay_distribution_id);
3409:
3410: if r_get_tax_sec_det.application_amount > 0
3411: and (r_get_tax_sec_det.tds_section_code_other is not NULL)

Line 3408: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_prepay_distribution_id: '||p_prepay_distribution_id);

3404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3405: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3406: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_id: '||p_invoice_id);
3407: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_invoice_distribution_id: '||p_invoice_distribution_id);
3408: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'p_prepay_distribution_id: '||p_prepay_distribution_id);
3409:
3410: if r_get_tax_sec_det.application_amount > 0
3411: and (r_get_tax_sec_det.tds_section_code_other is not NULL)
3412: --and r_get_total_prepayment_tax.tds_amount = 0 --Commented by Chong for bug#13802244 2012/09/19

Line 3453: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);

3449: p_codepath => p_codepath
3450: );
3451: end if; --r_get_tax_sec_det.application_amount > 0
3452:
3453: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3454: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3455:
3456: if r_get_total_prepayment_tax.tds_amount > 0 AND ln_application_mode = 'A' then
3457:

Line 3454: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);

3450: );
3451: end if; --r_get_tax_sec_det.application_amount > 0
3452:
3453: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'r_get_total_prepayment_tax.tds_amount: '||r_get_total_prepayment_tax.tds_amount);
3454: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3455:
3456: if r_get_total_prepayment_tax.tds_amount > 0 AND ln_application_mode = 'A' then
3457:
3458: /*

Line 3479: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);

3475: OPEN c_get_thgrp_det(ln_pp_thhold_grp_id);
3476: FETCH c_get_thgrp_det INTO r_pp_jai_ap_tds_thhold_grps;
3477: CLOSE c_get_thgrp_det;
3478:
3479: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'ln_application_mode: '||ln_application_mode);
3480: FOR get_si_det IN (SELECT jattt.*,
3481: jatp.tds_prepayment_id tds_prepayment_id,
3482: jatp.application_amount * nvl(p_exchange_rate,1) tds_taxable_basis,
3483: jatp.invoice_distribution_id tax_dist

Line 3505: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'in loop : '||get_si_det.threshold_grp_id);

3501: AND jattt.tds_section_code IS NOT NULL --Added By Chong, Only pick up TDS section records in trx table 20130330
3502: )
3503: LOOP
3504:
3505: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'in loop : '||get_si_det.threshold_grp_id);
3506:
3507: ln_temp_threshold_grp_id := get_si_det.threshold_grp_id;
3508:
3509: IF NVL (ln_pp_thhold_grp_id, 0) <> 0 AND

Line 3636: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'in loop ln_tot_tds_amt: '|| ln_tot_tds_amt);

3632: CLOSE c_get_section_code;
3633: --Added by Wenqiong for bug13787605
3634:
3635:
3636: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'in loop ln_tot_tds_amt: '|| ln_tot_tds_amt);
3637:
3638: IF ln_tot_tds_amt > 0 THEN
3639: IF lv_application_basis = 'STANDARD' THEN
3640: /* get the standard invoice number */

Line 3670: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@@@in loop generate_dtc_invoices lv_invoice_num_prepay_apply: '|| lv_invoice_num_prepay_apply);

3666: ln_tot_tds_amt := round(ln_tot_tds_amt,jai_ap_dtc_generation_pkg.get_tax_rounding(ln_parent_invoice_id));
3667:
3668: if p_event = 'INSERT' then
3669:
3670: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, '@@@in loop generate_dtc_invoices lv_invoice_num_prepay_apply: '|| lv_invoice_num_prepay_apply);
3671:
3672: jai_ap_dtc_generation_pkg.generate_dtc_invoices
3673: (
3674: pn_invoice_id => ln_parent_invoice_id ,

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

4033: end if;
4034:
4035: << exit_from_procedure >>
4036: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 100 */
4037: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
4038:
4039: return;
4040:
4041: exception

Line 4113: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||'.get_tax_category', 'cn_distribution_id: '|| cn_distribution_id || ' ln_tax_category_id' || ln_tax_category_id );

4109: OPEN get_tax_category;
4110: FETCH get_tax_category INTO ln_tax_category_id;
4111: CLOSE get_tax_category;
4112:
4113: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||'.get_tax_category', 'cn_distribution_id: '|| cn_distribution_id || ' ln_tax_category_id' || ln_tax_category_id );
4114:
4115: RETURN ln_tax_category_id;
4116: END get_tax_category;
4117: