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 JAI_AP_TDS_GENERATION_PKG

Line 1240: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_generation_pkg.status_update_chk_validate', 'START'); /* 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';
1244: if lp_org_id is NOT NULL THEN

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

1308:
1309: exception
1310: when others then
1311: p_process_flag := 'E';
1312: P_process_message := 'jai_ap_tds_generation_pkg.status_update_chk_validate :' || sqlerrm;
1313: return;
1314: end status_update_chk_validate;
1315:
1316: /*Modified for Bug 8641199 - End*/

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

1802: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /*2*/
1803:
1804: if p_vendor_id is null then
1805: p_process_flag := 'E';
1806: P_process_message := 'Vendor must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
1807: goto exit_from_procedure;
1808: end if;
1809:
1810: if p_org_tan_num is null then

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

1808: end if;
1809:
1810: if p_org_tan_num is null then
1811: p_process_flag := 'E';
1812: P_process_message := 'Organization TAN number must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
1813: goto exit_from_procedure;
1814: end if;
1815:
1816: if p_vendor_pan_num is null then

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

1814: end if;
1815:
1816: if p_vendor_pan_num is null then
1817: p_process_flag := 'E';
1818: P_process_message := 'Vendor PAN number must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
1819: goto exit_from_procedure;
1820: end if;
1821:
1822: if p_section_type is null then

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

1820: end if;
1821:
1822: if p_section_type is null then
1823: p_process_flag := 'E';
1824: P_process_message := 'Section Type must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
1825: goto exit_from_procedure;
1826: end if;
1827:
1828: if p_section_code is null then

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

1826: end if;
1827:
1828: if p_section_code is null then
1829: p_process_flag := 'E';
1830: P_process_message := 'Section Code must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
1831: goto exit_from_procedure;
1832: end if;
1833:
1834: if p_fin_year is null then

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

1832: end if;
1833:
1834: if p_fin_year is null then
1835: p_process_flag := 'E';
1836: P_process_message := 'Fin Year must be specified as threshold group identifier is null(jai_ap_tds_generation_pkg.maintain_thhold_grps) ';
1837: goto exit_from_procedure;
1838: end if;
1839:
1840: end if; /* Validate the input */

Line 5803: p_process_message := 'Error from jai_ap_tds_generation_pkg.process_threshold_trans :' || sqlerrm;

5799:
5800: exception
5801: when others then
5802: p_process_flag := 'E';
5803: p_process_message := 'Error from jai_ap_tds_generation_pkg.process_threshold_trans :' || sqlerrm;
5804:
5805:
5806: END process_threshold_transition;
5807:

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

6280: ('PREPAYMENT UNAPPLICATION')
6281: THEN
6282: ln_invoice_to_tds_amount := ROUND(ln_invoice_to_tds_amount,g_inr_currency_rounding);
6283: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_tds_amount);
6284: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
6285: /* Bug 7280925. Added by Lakshmi Gopalsami
6286: * we should not round for WCT and ESSI. For those threshold_grp_id
6287: * will be null
6288: */

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

6378: */
6379: IF pv_tds_event = 'PREPAYMENT UNAPPLICATION' THEN --2
6380: IF r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code THEN --3
6381: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount, g_inr_currency_rounding);
6382: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date) THEN
6383: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
6384: END IF;
6385: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
6386: END IF; --3

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

6390: if r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code then
6391: /*START, Bgowrava for Bug#8995604 , Adding below IF statement to round the INR TDS CM invoice to
6392: the TDS rounding factor before converting it to a foreign currency CM*/
6393: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount, g_inr_currency_rounding);
6394: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
6395: and pn_threshold_grp_id is not null THEN
6396: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
6397: END IF;
6398: /*END, Bgowrava for Bug#8995604 */

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

6399: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
6400: ELSE
6401: ln_invoice_to_vendor_amount := round( ln_invoice_to_vendor_amount, g_inr_currency_rounding);
6402: /*START, Bgowrava for Bug#8995604 , Adding below IF statement to round the INR TDS CM invoice to the TDS rounding factor*/
6403: IF trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
6404: and pn_threshold_grp_id is not null THEN
6405: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
6406: END IF;
6407: /*END, Bgowrava for Bug#8995604 */

Line 6415: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)

6411:
6412:
6413: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value before round '||ln_invoice_to_vendor_amount);
6414: /*IF trunc(pd_creation_date) >=
6415: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
6416: and pn_threshold_grp_id is not null
6417: THEN
6418: ln_invoice_to_vendor_amount := get_rnded_value(ln_invoice_to_vendor_amount);
6419: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round per setup - vendor invoice'||ln_invoice_to_vendor_amount);

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

6614: /* Added the below if condition for bug 12965614 */
6615: IF pv_tds_event = 'PREPAYMENT UNAPPLICATION' THEN --2
6616: IF r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code THEN --3
6617: ln_tds_rnded_amt := ROUND(pn_calc_tax_amount , g_inr_currency_rounding);
6618: IF (trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)) THEN --4
6619: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
6620: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
6621: END IF; --4
6622: ln_tds_rnded_amt := ROUND(pn_calc_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);

Line 6619: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;

6615: IF pv_tds_event = 'PREPAYMENT UNAPPLICATION' THEN --2
6616: IF r_ap_invoices_all.invoice_currency_code <> r_gl_sets_of_books.currency_code THEN --3
6617: ln_tds_rnded_amt := ROUND(pn_calc_tax_amount , g_inr_currency_rounding);
6618: IF (trunc(pd_creation_date) >= trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)) THEN --4
6619: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
6620: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
6621: END IF; --4
6622: ln_tds_rnded_amt := ROUND(pn_calc_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);
6623: END IF; --3

Line 6634: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)

6630: --moved this if-endif block from below to here for bug#8995604
6631: ELSE
6632: ln_tds_rnded_amt := ROUND(pn_tax_amount , g_inr_currency_rounding);
6633: IF (trunc(pd_creation_date) >=
6634: trunc(jai_ap_tds_generation_pkg.gd_tds_rounding_effective_date)
6635: /* Bug 7280925. Added by Lakshmi Gopalsami
6636: * we should not round for WCT and ESSI. For those threshold_grp_id
6637: * will be null
6638: */

Line 6641: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;

6637: * will be null
6638: */
6639: and pn_threshold_grp_id is not null )
6640: THEN
6641: ln_tds_rnding_factor := jai_ap_tds_generation_pkg.gn_tds_rounding_factor;
6642: ln_tds_rnded_amt := get_rnded_value(ln_tds_rnded_amt);
6643: fnd_file.put_line(FND_FILE.LOG, ' Bug 7280925 - value after round before insert into trxs'||ln_tds_rnded_amt);
6644: END IF;
6645: ln_tds_rnded_amt := ROUND(pn_tax_amount / r_ap_invoices_all.exchange_rate, g_fcy_currency_rounding);

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

6734:
6735: exception
6736: when others then
6737: p_process_flag := 'E';
6738: p_process_message := 'Error from jai_ap_tds_generation_pkg.generate_tds_invoices :' || sqlerrm;
6739:
6740: end generate_tds_invoices;
6741:
6742: /* *********************************** procedure generate_tds_invoices ********************************** */

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

8178:
8179: exception
8180: when others then
8181: p_process_flag := 'E';
8182: p_process_message := 'Error from jai_ap_tds_generation_pkg.import_and_approve :' || sqlerrm;
8183: end import_and_approve;
8184:
8185: /* *********************************** procedure import_and_approve ********************************** */
8186:

Line 8246: Fnd_File.put_line(Fnd_File.LOG, 'jai_ap_tds_generation_pkg.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 );
8249: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_id=> ' || p_vendor_id);
8250: Fnd_File.put_line(Fnd_File.LOG, 'p_vendor_site_id=> ' || p_vendor_site_id);

Line 8344: p_calling_sequence => 'jai_ap_tds_generation_pkg.approve_tds_invoices'

8340: p_holds_count => ln_holds_count,
8341: p_approval_status => lv_approval_status,
8342: /* Bug 4943949. Added by Lakshmi Gopalsami
8343: p_funds_return_code => lv_funds_ret_code,
8344: p_calling_sequence => 'jai_ap_tds_generation_pkg.approve_tds_invoices'
8345: ) ;
8346: */
8347: BEGIN
8348: IF ap_approval_pkg.batch_approval(

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

8370: END IF ;
8371: EXCEPTION
8372: WHEN OTHERS THEN
8373: retcode := 'E';
8374: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices-> :
8375: during call to batch_approval for TDS invoice' || sqlerrm;
8376: END;
8377:
8378: End if;

Line 8416: p_calling_sequence => 'jai_ap_tds_generation_pkg.approve_tds_invoices'

8412: p_holds_count => ln_holds_count,
8413: p_approval_status => lv_approval_status,
8414: /* Bug 4943949. Added by Lakshmi Gopalsami
8415: p_funds_return_code => lv_funds_ret_code,
8416: p_calling_sequence => 'jai_ap_tds_generation_pkg.approve_tds_invoices'
8417: ) ;
8418: */
8419:
8420: BEGIN

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

8443: END IF ;
8444: EXCEPTION
8445: WHEN OTHERS THEN
8446: retcode := 'E';
8447: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices-> :
8448: during call to batch_approval for TDS invoice' || sqlerrm;
8449: END;
8450:
8451:

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

8459:
8460: exception
8461: when others then
8462: retcode := 2;
8463: errbuf := 'Error from jai_ap_tds_generation_pkg.approve_tds_invoices : ' || sqlerrm;
8464: end approve_tds_invoices;
8465:
8466: /* ********************************* populate_tds_invoice_id **************************************** */
8467:

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

8582:
8583: exception
8584: when others then
8585: p_process_flag := 'E';
8586: p_process_message := 'Error from jai_ap_tds_generation_pkg.populate_tds_invoice_id :' || sqlerrm;
8587: end populate_tds_invoice_id;
8588:
8589: /* ********************************* populate_tds_invoice_id **************************************** */
8590:

Line 8776: 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;

8772: lv_codepath := p_codepath;
8773:
8774: /*START, Added by Bgowrava for Bug#9214036*/
8775: OPEN c_get_rnd_factor (p_org_id,p_accounting_date);
8776: 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;
8777: CLOSE c_get_rnd_factor ;
8778: /*END, Added by Bgowrava for Bug#9214036*/
8779:
8780: -- Harshita for Bug#5131075(5346558)

Line 8834: jai_ap_tds_generation_pkg.process_tds_at_inv_validate

8830: FETCH get_creation_date INTO ld_creation_date;
8831: CLOSE get_creation_date;
8832: /*END, Added by Bgowrava for Bug#9214036*/
8833:
8834: jai_ap_tds_generation_pkg.process_tds_at_inv_validate
8835: (
8836: p_invoice_id => p_invoice_id,
8837: p_vendor_id => p_vendor_id,
8838: p_vendor_site_id => p_vendor_site_id,

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

8942: );
8943:
8944: if nvl(lv_process_flag, 'N') = 'E' then
8945: raise_application_error(-20007,
8946: 'Error - procedure jai_ap_tds_generation_pkg.create_tds_after_holds_release : ' || lv_process_message);
8947: end if;
8948:
8949: else
8950: --Invoke the old regime functionality

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

8964: );
8965:
8966: if nvl(lv_process_flag, 'N') = 'E' then
8967: raise_application_error(-20008,
8968: 'Error - procedure jai_ap_tds_generation_pkg.create_tds_after_holds_release : ' || lv_process_message);
8969: end if;
8970: end if; --Transactions in new regime
8971:
8972: END IF;

Line 9558: --Call jai_ap_tds_generation_pkg.generate_tds_invoices with LN_TAXABLE_AMOUNT, LN_TAX_AMOUNT

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;
9557:
9558: --Call jai_ap_tds_generation_pkg.generate_tds_invoices with LN_TAXABLE_AMOUNT, LN_TAX_AMOUNT
9559: jai_ap_dtc_generation_pkg.generate_rollback_dtc_invoices
9560: ( pn_invoice_id => p_invoice_id ,
9561: -- pn_invoice_distribution_id => p_invoice_distribution_id ,
9562: -- pv_invoice_num_prepay_apply=> lv_prepay_invoice_num ,

Line 9683: Call jai_ap_tds_generation_pkg.generate_tds_invoices with LN_TAXABLE_AMOUNT, LN_TAX_AMOUNT

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;
9682: /*
9683: Call jai_ap_tds_generation_pkg.generate_tds_invoices with LN_TAXABLE_AMOUNT, LN_TAX_AMOUNT
9684: Note: Create Surcharge Rollback TDS Invoice with TDS Event as SURCHARGE_ROLLBACK???
9685: */
9686: /* --Commented by Chong for surcharge rollback issue 2012/10/10
9687: jai_ap_dtc_generation_pkg.generate_dtc_invoices

Line 10239: jai_ap_tds_generation_pkg.import_and_approve(p_invoice_id => p_invoice_id,

10235:
10236: IF ln_threshold_trx_id IS NOT NULL THEN
10237:
10238: /* rollback invoice have been generated, call the program for invoking import and approval */
10239: jai_ap_tds_generation_pkg.import_and_approve(p_invoice_id => p_invoice_id,
10240: p_start_thhold_trx_id => ln_threshold_trx_id,
10241: p_tds_event => 'THRESHOLD ROLLBACK',
10242: p_process_flag => p_process_flag,
10243: p_process_message => P_process_message);

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

11135: ln_tmp_tax_amt := ln_tmp_tax_amt + (10-ln_tds_mod_value);
11136: ELSE -- < 5
11137: ln_tmp_tax_amt := ln_tmp_tax_amt - ln_tds_mod_value;
11138: END IF ;
11139: END IF ; -- jai_ap_tds_generation_pkg.gn_tds_rounding_factor = -1
11140: return (ln_tmp_tax_amt* ln_tds_sign );
11141: END get_rnded_value;
11142: -- End for bug 5722028.
11143: