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_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_GENERATION_PKG

Line 1: PACKAGE BODY jai_ap_tds_generation_pkg

1: PACKAGE BODY jai_ap_tds_generation_pkg
2: /* $Header: jai_ap_tds_gen.plb 120.77.12020000.14 2013/03/12 12:04:51 mmurtuza ship $ */
3: AS
4: /* ----------------------------------------------------------------------------
5: FILENAME : jai_ap_tds_gen.plb

Line 712: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.status_update_chk_validate', 'START'); /* 1 */

708: l_po_encum_flag VARCHAR2(1);
709:
710: begin
711:
712: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.status_update_chk_validate', 'START'); /* 1 */
713:
714: get_org_id(p_invoice_id, lp_org_id);
715: l_po_encum_flag := 'N';
716: if lp_org_id is NOT NULL THEN

Line 782: P_process_message := 'jai_ap_tds_generation_pkg.status_update_chk_validate :' || sqlerrm;

778:
779: exception
780: when others then
781: p_process_flag := 'E';
782: P_process_message := 'jai_ap_tds_generation_pkg.status_update_chk_validate :' || sqlerrm;
783: return;
784: end status_update_chk_validate;
785:
786: /*Modified for Bug 8641199 - End*/

Line 1145: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.process_tds_at_inv_validate', 'START'); /* 1 */

1141:
1142:
1143: begin
1144:
1145: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.process_tds_at_inv_validate', 'START'); /* 1 */
1146: open c_check_if_exists(p_invoice_id);
1147: fetch c_check_if_exists into ln_count;
1148: close c_check_if_exists;
1149:

Line 1372: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

1368: * Rounding to 10 is applicable per invoice
1369: * and not on each distribution
1370:
1371: IF trunc(p_creation_date) >=
1372: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1373: ln_tmp_tds_amt := get_rnded_value(ln_tmp_tds_amt);
1374: END IF;
1375: */
1376: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 value of tax_amount before update'||ln_tax_amount);

Line 1555: jai_ap_tds_generation_pkg.maintain_thhold_grps

1551: p_codepath := jai_general_pkg.plot_codepath(19.1, p_codepath); /* 19.1 */
1552:
1553: fnd_file.put_line(FND_FILE.LOG, '19.1 Call maintain thhold grps ');
1554:
1555: jai_ap_tds_generation_pkg.maintain_thhold_grps
1556: (
1557: p_threshold_grp_id => ln_threshold_grp_id,
1558: p_vendor_id => p_vendor_id,
1559: p_org_tan_num => lv_tan_no,

Line 1583: jai_ap_tds_generation_pkg.maintain_thhold_grps

1579: else
1580:
1581: p_codepath := jai_general_pkg.plot_codepath(19.2, p_codepath); /* 19.2 */
1582:
1583: jai_ap_tds_generation_pkg.maintain_thhold_grps
1584: (
1585: p_threshold_grp_id => ln_threshold_grp_id,
1586: p_trx_invoice_amount => cur_rec_section.invoice_amount,
1587: p_tds_event => 'INVOICE VALIDATE',

Line 1646: jai_ap_tds_generation_pkg.generate_tds_invoices

1642: fnd_file.put_line(FND_FILE.LOG, '20. Call generate tds invoices' );
1643:
1644: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - tax amount while calling generate tds invoices '|| cur_rec.tax_amount);
1645:
1646: jai_ap_tds_generation_pkg.generate_tds_invoices
1647: (
1648: pn_invoice_id => p_invoice_id ,
1649: pn_threshold_hdr_id => ln_threshold_hdr_id ,
1650: pn_taxable_amount => cur_rec.taxable_amount ,

Line 1687: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

1683: /* Bug 7280925. Added by Lakshmi Gopalsami -- can be removed
1684: * Need to round the value before calling maintain_thhold_grps
1685:
1686: IF trunc(p_creation_date) >=
1687: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
1688: ln_tmp_tds_amt := get_rnded_value(cur_rec.tax_amount);
1689: END IF;
1690: */
1691:

Line 1701: jai_ap_tds_generation_pkg.maintain_thhold_grps

1697: * changed from ln_tmp_tds_amt to ln_tax_amount
1698: */
1699: p_codepath := jai_general_pkg.plot_codepath(23, p_codepath); /* 23 */
1700:
1701: jai_ap_tds_generation_pkg.maintain_thhold_grps
1702: (
1703: p_threshold_grp_id => ln_threshold_grp_id,
1704: p_trx_tax_paid => ln_tds_tax_amount,
1705: p_tds_event => 'INVOICE VALIDATE', --Added by Bgowrava for Bug#8254510

Line 1817: jai_ap_tds_generation_pkg.generate_tds_invoices

1813: fnd_file.put_line(FND_FILE.LOG, '31 Call generate tds invoices ');
1814:
1815: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - WCT Tax amt '||cur_non_tds_rec.tax_amount);
1816:
1817: jai_ap_tds_generation_pkg.generate_tds_invoices
1818: (
1819: pn_invoice_id => p_invoice_id ,
1820: pn_threshold_hdr_id => ln_threshold_hdr_id ,
1821: pn_taxable_amount => cur_non_tds_rec.taxable_amount ,

Line 1914: P_process_message := 'jai_ap_tds_generation_pkg.process_tds_at_inv_validate :' || sqlerrm;

1910: exception
1911: when others then
1912: /*Added below by Bgowrava for Bug#8716477 */
1913: p_process_flag := 'E';
1914: P_process_message := 'jai_ap_tds_generation_pkg.process_tds_at_inv_validate :' || sqlerrm;
1915: return;
1916: end process_tds_at_inv_validate;
1917: /* ************************************* process_tds_at_inv_validate ************************************ */
1918:

Line 2317: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)

2313: ('PREPAYMENT UNAPPLICATION')
2314: THEN
2315: ln_invoice_to_tds_amount := ROUND(ln_invoice_to_tds_amount,g_inr_currency_rounding);
2316: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);
2317: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
2318: /* Bug 7280925. Added by Lakshmi Gopalsami
2319: * we should not round for WCT and ESSI. For those threshold_grp_id
2320: * will be null
2321: */

Line 2413: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

2409: */
2410: IF pv_tds_event = 'PREPAYMENT UNAPPLICATION' THEN --2
2411: IF r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code THEN --3
2412: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount, g_inr_currency_rounding);
2413: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
2414: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
2415: END IF;
2416: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
2417: END IF; --3

Line 2425: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)

2421: if r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code then
2422: /*START, Bgowrava for Bug#8995604 , Adding below IF statement to round the INR TDS CM invoice to
2423: the TDS rounding factor before converting it to a foreign currency CM*/
2424: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount, g_inr_currency_rounding);
2425: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
2426: and pn_threshold_grp_id is not null THEN
2427: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
2428: END IF;
2429: /*END, Bgowrava for Bug#8995604 */

Line 2434: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)

2430: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
2431: ELSE
2432: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount, g_inr_currency_rounding);
2433: /*START, Bgowrava for Bug#8995604 , Adding below IF statement to round the INR TDS CM invoice to the TDS rounding factor*/
2434: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
2435: and pn_threshold_grp_id is not null THEN
2436: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
2437: END IF;
2438: /*END, Bgowrava for Bug#8995604 */

Line 2446: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)

2442:
2443:
2444: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_vendor_amount);
2445: /*IF trunc(pd_creation_date) >=
2446: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
2447: and pn_threshold_grp_id is not null
2448: THEN
2449: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
2450: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup - vendor invoice'||ln_invoice_to_vendor_amount);

Line 2636: IF (trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)) THEN --4

2632: /* Added the below if condition for bug 12965614 */
2633: IF pv_tds_event = 'PREPAYMENT UNAPPLICATION' THEN --2
2634: IF r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code THEN --3
2635: ln_tds_rnded_amt := ROUND(pn_calc_tax_amount , g_inr_currency_rounding);
2636: IF (trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)) THEN --4
2637: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
2638: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
2639: END IF; --4
2640: ln_tds_rnded_amt := ROUND(pn_calc_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);

Line 2637: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;

2633: IF pv_tds_event = 'PREPAYMENT UNAPPLICATION' THEN --2
2634: IF r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code THEN --3
2635: ln_tds_rnded_amt := ROUND(pn_calc_tax_amount , g_inr_currency_rounding);
2636: IF (trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)) THEN --4
2637: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
2638: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
2639: END IF; --4
2640: ln_tds_rnded_amt := ROUND(pn_calc_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
2641: END IF; --3

Line 2652: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)

2648: --moved this if-endif block from below to here for bug#8995604
2649: ELSE
2650: ln_tds_rnded_amt := ROUND(pn_tax_amount , g_inr_currency_rounding);
2651: IF (trunc(pd_creation_date) >=
2652: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
2653: /* Bug 7280925. Added by Lakshmi Gopalsami
2654: * we should not round for WCT and ESSI. For those threshold_grp_id
2655: * will be null
2656: */

Line 2659: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;

2655: * will be null
2656: */
2657: and pn_threshold_grp_id is not null )
2658: THEN
2659: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
2660: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
2661: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
2662: END IF;
2663: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);

Line 2753: p_process_message := 'Error from jai_ap_tds_generation_pkg.generate_tds_invoices :' || sqlerrm;

2749:
2750: exception
2751: when others then
2752: p_process_flag := 'E';
2753: p_process_message := 'Error from jai_ap_tds_generation_pkg.generate_tds_invoices :' || sqlerrm;
2754:
2755: end generate_tds_invoices;
2756:
2757: /* *********************************** procedure generate_tds_invoices ********************************** */

Line 3009: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

3005: ROUND(r_jai_ap_tds_thhold_grps.total_invoice_amount * (r_ja_in_tax_codes.tax_rate/100),
3006: g_inr_currency_rounding);
3007:
3008: IF trunc(sysdate) >=
3009: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
3010: ln_thhold_transition_tax_amt := get_rnded_value(ln_thhold_transition_tax_amt);
3011: END IF;
3012:
3013: ln_thhold_transition_tax_amt := ln_thhold_transition_tax_amt - r_jai_ap_tds_thhold_grps.total_tax_paid;*/ --Commented by Bgowrava for Bug#8254510

Line 3084: IF trunc(sysdate) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

3080: end loop;
3081:
3082: ln_thhold_transition_tax_amt := ROUND(ln_thhold_total_tax_amt, g_inr_currency_rounding);
3083:
3084: IF trunc(sysdate) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
3085: ln_thhold_transition_tax_amt := get_rnded_value(ln_thhold_transition_tax_amt);
3086: END IF;
3087: /* END, Bgowrava for Bug#8254510*/
3088: --END IF; /*ln_rollback_available = 1*/ /* Commented Bug 13561970*/

Line 3110: jai_ap_tds_generation_pkg.generate_tds_invoices

3106: END IF;
3107: END IF; --Added by amandali for Bug#9562876
3108: /* END, by Bgowrava for Bug#8459564 */
3109:
3110: jai_ap_tds_generation_pkg.generate_tds_invoices
3111: (
3112: pn_invoice_id => p_invoice_id ,
3113: pn_threshold_hdr_id => ln_threshold_hdr_id , /*amandali for bug 11671779*/
3114: pn_taxable_amount => ln_taxable_amount , --Modified by Bgowrava for Bug#8459564

Line 3223: jai_ap_tds_generation_pkg.generate_tds_invoices

3219: ln_thhold_total_sur_amt := ln_thhold_total_sur_amt + ln_trx_surcharge_amount;
3220: end if;
3221: end loop;
3222:
3223: jai_ap_tds_generation_pkg.generate_tds_invoices
3224: (
3225: pn_invoice_id => p_invoice_id ,
3226: pn_threshold_hdr_id => ln_threshold_hdr_id ,
3227: pn_taxable_amount => ln_sur_applicable_amt,

Line 3272: p_process_message := 'Error from jai_ap_tds_generation_pkg.process_threshold_transition :' || sqlerrm;

3268:
3269: exception
3270: when others then
3271: p_process_flag := 'E';
3272: p_process_message := 'Error from jai_ap_tds_generation_pkg.process_threshold_transition :' || sqlerrm;
3273: end process_threshold_transition;
3274:
3275: /* *********************************** procedure import_and_approve ********************************** */
3276:

Line 3413: p_process_message := 'Error from jai_ap_tds_generation_pkg.import_and_approve :' || sqlerrm;

3409:
3410: exception
3411: when others then
3412: p_process_flag := 'E';
3413: p_process_message := 'Error from jai_ap_tds_generation_pkg.import_and_approve :' || sqlerrm;
3414: end import_and_approve;
3415:
3416: /* *********************************** procedure import_and_approve ********************************** */
3417:

Line 3476: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');

3472:
3473: begin
3474:
3475: /* Check for the status of the import request */
3476: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.approve_tds_invoices');
3477: Fnd_File.put_line(Fnd_File.LOG, 'p_parent_request_id =>' || p_parent_request_id);
3478: Fnd_File.put_line(Fnd_File.LOG, 'p_invoice_id=> ' || p_invoice_id );
3479: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
3480: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);

Line 3572: p_calling_sequence => 'jai_ap_tds_generation_pkg.approve_tds_invoices'

3568: p_holds_count => ln_holds_count,
3569: p_approval_status => lv_approval_status,
3570: /* Bug 4943949. Added by Lakshmi Gopalsami
3571: p_funds_return_code => lv_funds_ret_code,
3572: p_calling_sequence => 'jai_ap_tds_generation_pkg.approve_tds_invoices'
3573: ) ;
3574: */
3575: BEGIN
3576: IF ap_approval_pkg.batch_approval(

Line 3602: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices-> :

3598: END IF ;
3599: EXCEPTION
3600: WHEN OTHERS THEN
3601: retcode := 'E';
3602: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices-> :
3603: during call to batch_approval for TDS invoice' || sqlerrm;
3604: END;
3605:
3606: End if;

Line 3644: p_calling_sequence => 'jai_ap_tds_generation_pkg.approve_tds_invoices'

3640: p_holds_count => ln_holds_count,
3641: p_approval_status => lv_approval_status,
3642: /* Bug 4943949. Added by Lakshmi Gopalsami
3643: p_funds_return_code => lv_funds_ret_code,
3644: p_calling_sequence => 'jai_ap_tds_generation_pkg.approve_tds_invoices'
3645: ) ;
3646: */
3647:
3648: BEGIN

Line 3675: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices-> :

3671: END IF ;
3672: EXCEPTION
3673: WHEN OTHERS THEN
3674: retcode := 'E';
3675: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices-> :
3676: during call to batch_approval for TDS invoice' || sqlerrm;
3677: END;
3678:
3679:

Line 3691: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices : ' || sqlerrm;

3687:
3688: exception
3689: when others then
3690: retcode := 2;
3691: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices : ' || sqlerrm;
3692: end approve_tds_invoices;
3693:
3694: /* ********************************* populate_tds_invoice_id **************************************** */
3695:

Line 3768: p_process_message := 'Error from jai_ap_tds_generation_pkg.populate_tds_invoice_id :' || sqlerrm;

3764:
3765: exception
3766: when others then
3767: p_process_flag := 'E';
3768: p_process_message := 'Error from jai_ap_tds_generation_pkg.populate_tds_invoice_id :' || sqlerrm;
3769: end populate_tds_invoice_id;
3770:
3771: /* ********************************* populate_tds_invoice_id **************************************** */
3772:

Line 3865: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.maintain_thhold_grps', 'START'); /* 1 */

3861:
3862:
3863: begin
3864:
3865: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.maintain_thhold_grps', 'START'); /* 1 */
3866:
3867:
3868: /* Validate the input */
3869: ln_threshold_grp_id := nvl(p_threshold_grp_id, 0);

Line 3877: P_process_message := 'Vendor must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';

3873: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /*2*/
3874:
3875: if p_vendor_id is null then
3876: p_process_flag := 'E';
3877: P_process_message := 'Vendor must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
3878: goto exit_from_procedure;
3879: end if;
3880:
3881: if p_org_tan_num is null then

Line 3883: P_process_message := 'Organization TAN number must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';

3879: end if;
3880:
3881: if p_org_tan_num is null then
3882: p_process_flag := 'E';
3883: P_process_message := 'Organization TAN number must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
3884: goto exit_from_procedure;
3885: end if;
3886:
3887: if p_vendor_pan_num is null then

Line 3889: P_process_message := 'Vendor PAN number must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';

3885: end if;
3886:
3887: if p_vendor_pan_num is null then
3888: p_process_flag := 'E';
3889: P_process_message := 'Vendor PAN number must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
3890: goto exit_from_procedure;
3891: end if;
3892:
3893: if p_section_type is null then

Line 3895: P_process_message := 'Section Type must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';

3891: end if;
3892:
3893: if p_section_type is null then
3894: p_process_flag := 'E';
3895: P_process_message := 'Section Type must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
3896: goto exit_from_procedure;
3897: end if;
3898:
3899: if p_section_code is null then

Line 3901: P_process_message := 'Section Code must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';

3897: end if;
3898:
3899: if p_section_code is null then
3900: p_process_flag := 'E';
3901: P_process_message := 'Section Code must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
3902: goto exit_from_procedure;
3903: end if;
3904:
3905: if p_fin_year is null then

Line 3907: P_process_message := 'Fin Year must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';

3903: end if;
3904:
3905: if p_fin_year is null then
3906: p_process_flag := 'E';
3907: P_process_message := 'Fin Year must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
3908: goto exit_from_procedure;
3909: end if;
3910:
3911: end if; /* Validate the input */

Line 4014: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

4010: IF p_tds_event NOT IN
4011: -- Bug 7280925. Commented by Lakshmi Gopalsami ('INVOICE CANCEL',
4012: ('PREPAYMENT UNAPPLICATION') THEN
4013: IF trunc(p_creation_date) >=
4014: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
4015: ln_tmp_tds_amt := get_rnded_value(ln_tmp_tds_amt);
4016: END IF;
4017: END IF;
4018: -- End if ;

Line 4147: p_process_message := 'Error from jai_ap_tds_generation_pkg.maintain_thhold_grps :' || sqlerrm;

4143: exception
4144: when others then
4145: fnd_file.put_line(FND_FILE.LOG,' Error in maintain thhold grps '|| substr(SQLERRM,1,200));
4146: p_process_flag := 'E';
4147: p_process_message := 'Error from jai_ap_tds_generation_pkg.maintain_thhold_grps :' || sqlerrm;
4148: end maintain_thhold_grps;
4149:
4150: /* ******************************** maintain_thhold_grps ******************************************* */
4151: /* ******************************** insert_tds_thhold_trxs ******************************************* */

Line 4334: FETCH c_get_rnd_factor into JAI_AP_TDS_GENERATION_pkg.gn_tds_rounding_factor, JAI_AP_TDS_GENERATION_pkg.gd_tds_rounding_effective_date;

4330: lv_codepath := p_codepath;
4331:
4332: /*START, Added by Bgowrava for Bug#9214036*/
4333: OPEN c_get_rnd_factor (p_org_id,p_accounting_date);
4334: FETCH c_get_rnd_factor into JAI_AP_TDS_GENERATION_pkg.gn_tds_rounding_factor, JAI_AP_TDS_GENERATION_pkg.gd_tds_rounding_effective_date;
4335: CLOSE c_get_rnd_factor ;
4336: /*END, Added by Bgowrava for Bug#9214036*/
4337:
4338: -- Harshita for Bug#5131075(5346558)

Line 4392: jai_ap_tds_generation_pkg.process_tds_at_inv_validate

4388: FETCH get_creation_date INTO ld_creation_date;
4389: CLOSE get_creation_date;
4390: /*END, Added by Bgowrava for Bug#9214036*/
4391:
4392: jai_ap_tds_generation_pkg.process_tds_at_inv_validate
4393: (
4394: p_invoice_id => p_invoice_id,
4395: p_vendor_id => p_vendor_id,
4396: p_vendor_site_id => p_vendor_site_id,

Line 4504: 'Error - procedure jai_ap_tds_generation_pkg.create_tds_after_holds_release : ' || lv_process_message);

4500: );
4501:
4502: if nvl(lv_process_flag, 'N') = 'E' then
4503: raise_application_error(-20007,
4504: 'Error - procedure jai_ap_tds_generation_pkg.create_tds_after_holds_release : ' || lv_process_message);
4505: end if;
4506:
4507: else
4508: --Invoke the old regime functionality

Line 4526: 'Error - procedure jai_ap_tds_generation_pkg.create_tds_after_holds_release : ' || lv_process_message);

4522: );
4523:
4524: if nvl(lv_process_flag, 'N') = 'E' then
4525: raise_application_error(-20008,
4526: 'Error - procedure jai_ap_tds_generation_pkg.create_tds_after_holds_release : ' || lv_process_message);
4527: end if;
4528: end if; --Transactions in new regime
4529:
4530: END IF;

Line 5000: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN

4996: ln_effective_tds_amt := ROUND(ln_effective_invoice_amt * (r_threshold_slab.tax_rate/100), g_inr_currency_rounding);
4997: END IF;
4998:
4999: IF trunc(sysdate) >=
5000: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
5001: ln_effective_tds_amt := get_rnded_value(ln_effective_tds_amt);
5002: END IF;
5003:
5004: /*Bug 5721614. Used the non-rounded value for calculation*/

Line 5014: jai_ap_tds_generation_pkg.generate_tds_invoices

5010: --There is an excess TDS payment/deduction. So need to create RTN invoice for the TDS Authority and SI for Vendor for ln_diff_tds_amount
5011:
5012: lv_tds_event := 'THRESHOLD ROLLBACK( from slab id - '||p_before_threshold_slab_id||' to slab id - '||p_after_threshold_slab_id||')';
5013:
5014: jai_ap_tds_generation_pkg.generate_tds_invoices
5015: (
5016: pn_invoice_id => p_invoice_id ,
5017: /* Bug 5751783. Changed null to calculated value for taxable amount.
5018: * This value is not rounded as we are performing one more rounding in

Line 5044: jai_ap_tds_generation_pkg.import_and_approve

5040: goto exit_from_procedure;
5041: end if;
5042:
5043: IF ln_threshold_trx_id IS NOT NULL THEN
5044: jai_ap_tds_generation_pkg.import_and_approve
5045: (
5046: p_invoice_id => p_invoice_id,
5047: p_start_thhold_trx_id => ln_threshold_trx_id,
5048: p_tds_event => lv_tds_event,

Line 5103: IF jai_ap_tds_generation_pkg.gn_tds_rounding_factor = -1 then

5099: BEGIN
5100: ln_tds_sign := sign(p_tax_amount);
5101: ln_tmp_tax_amt := abs(p_tax_amount);
5102:
5103: IF jai_ap_tds_generation_pkg.gn_tds_rounding_factor = -1 then
5104: ln_tds_mod_value := 0;
5105: ln_tds_mod_value := MOD(ROUND(ln_tmp_tax_amt,
5106: g_inr_currency_rounding),10);
5107: IF ln_tds_mod_value >= 5 THEN

Line 5112: END IF ; -- jai_ap_tds_generation_pkg.gn_tds_rounding_factor = -1

5108: ln_tmp_tax_amt := ln_tmp_tax_amt + (10-ln_tds_mod_value);
5109: ELSE -- < 5
5110: ln_tmp_tax_amt := ln_tmp_tax_amt - ln_tds_mod_value;
5111: END IF ;
5112: END IF ; -- jai_ap_tds_generation_pkg.gn_tds_rounding_factor = -1
5113: return (ln_tmp_tax_amt* ln_tds_sign );
5114: END get_rnded_value;
5115: -- End for bug 5722028.
5116:

Line 5118: END jai_ap_tds_generation_pkg;

5114: END get_rnded_value;
5115: -- End for bug 5722028.
5116:
5117:
5118: END jai_ap_tds_generation_pkg;