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

Line 1: PACKAGE BODY jai_ap_tds_prepayments_pkg AS

1: PACKAGE BODY jai_ap_tds_prepayments_pkg AS
2: /* $Header: jai_ap_tds_ppay.plb 120.20.12020000.7 2013/04/08 09:14:53 amandali ship $ */
3:
4: /* ----------------------------------------------------------------------------
5: FILENAME : jai_ap_tds_prepayemnts_pkg_b.sql

Line 257: from jai_ap_tds_prepayments

253: is
254: /*Bug 5751783 - Start*/
255: cursor c_get_prepay_apply(cp_invoice_id number, cp_inv_dist_id number) is
256: select tds_threshold_trx_id_apply, count(1)
257: from jai_ap_tds_prepayments
258: where invoice_id = cp_invoice_id
259: and invoice_distribution_id_prepay = cp_inv_dist_id
260: and tds_applicable_flag='Y' /* Bug 14657086 */
261: group by tds_threshold_trx_id_apply;

Line 279: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '============jai_ap_tds_prepayemnts_pkg.process_prepayment=======');

275: /*Bug 5751783 - End*/
276: begin
277:
278: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_prepayment', 'START'); /* 1 */
279: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '============jai_ap_tds_prepayemnts_pkg.process_prepayment=======');
280: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id'||p_invoice_id ||'p_invoice_distribution_id :'||p_invoice_distribution_id );
281: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_distribution_id: '||p_prepay_distribution_id ||'p_parent_reversal_id: '||p_parent_reversal_id);
282: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_prepay_amount: '||p_prepay_amount);
283: if p_prepay_amount < 0 then

Line 280: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id'||p_invoice_id ||'p_invoice_distribution_id :'||p_invoice_distribution_id );

276: begin
277:
278: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_prepayment', 'START'); /* 1 */
279: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '============jai_ap_tds_prepayemnts_pkg.process_prepayment=======');
280: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id'||p_invoice_id ||'p_invoice_distribution_id :'||p_invoice_distribution_id );
281: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_distribution_id: '||p_prepay_distribution_id ||'p_parent_reversal_id: '||p_parent_reversal_id);
282: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_prepay_amount: '||p_prepay_amount);
283: if p_prepay_amount < 0 then
284:

Line 281: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_distribution_id: '||p_prepay_distribution_id ||'p_parent_reversal_id: '||p_parent_reversal_id);

277:
278: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_prepayment', 'START'); /* 1 */
279: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '============jai_ap_tds_prepayemnts_pkg.process_prepayment=======');
280: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id'||p_invoice_id ||'p_invoice_distribution_id :'||p_invoice_distribution_id );
281: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_distribution_id: '||p_prepay_distribution_id ||'p_parent_reversal_id: '||p_parent_reversal_id);
282: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_prepay_amount: '||p_prepay_amount);
283: if p_prepay_amount < 0 then
284:
285: /* Event is APPLY of prepayment */

Line 282: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_prepay_amount: '||p_prepay_amount);

278: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_prepayment', 'START'); /* 1 */
279: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '============jai_ap_tds_prepayemnts_pkg.process_prepayment=======');
280: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id'||p_invoice_id ||'p_invoice_distribution_id :'||p_invoice_distribution_id );
281: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_distribution_id: '||p_prepay_distribution_id ||'p_parent_reversal_id: '||p_parent_reversal_id);
282: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_prepay_amount: '||p_prepay_amount);
283: if p_prepay_amount < 0 then
284:
285: /* Event is APPLY of prepayment */
286:

Line 287: jai_ap_tds_prepayments_pkg.allocate_prepayment

283: if p_prepay_amount < 0 then
284:
285: /* Event is APPLY of prepayment */
286:
287: jai_ap_tds_prepayments_pkg.allocate_prepayment
288: (
289: p_invoice_id => p_invoice_id ,
290: p_invoice_distribution_id => p_invoice_distribution_id ,
291: p_prepay_amount => p_prepay_amount ,

Line 301: jai_ap_tds_prepayments_pkg.populate_section_tax

297: if p_process_flag = 'E' then
298: goto exit_from_procedure;
299: end if;
300:
301: jai_ap_tds_prepayments_pkg.populate_section_tax
302: (
303: p_invoice_id => p_invoice_id ,
304: p_invoice_distribution_id => p_invoice_distribution_id ,
305: p_prepay_distribution_id => p_prepay_distribution_id ,

Line 316: jai_ap_tds_prepayments_pkg.process_tds_invoices

312: goto exit_from_procedure;
313: end if;
314:
315:
316: jai_ap_tds_prepayments_pkg.process_tds_invoices
317: (
318: p_event => p_event , --Added for Bug 8431516
319: p_invoice_id => p_invoice_id ,
320: p_invoice_distribution_id => p_invoice_distribution_id ,

Line 368: jai_ap_tds_prepayments_pkg.process_unapply

364: goto exit_from_procedure;
365: end if;
366:
367:
368: jai_ap_tds_prepayments_pkg.process_unapply
369: (
370: p_event => p_event , --Added for Bug 8431516
371: p_invoice_id => p_invoice_id ,
372: p_invoice_distribution_id => p_invoice_distribution_id ,

Line 455: from jai_ap_tds_prepayments

451: sum( decode(wct_applicable_flag , 'Y', wct_application_amount, 0) ) wct_amount_orig,
452: sum( decode(essi_applicable_flag, 'Y', application_amount, 0) ) essi_taxable_basis,
453: sum( decode(essi_applicable_flag, 'Y', calc_essi_appln_amt, 0) ) essi_amount,
454: sum( decode(essi_applicable_flag, 'Y', essi_application_amount, 0) ) essi_amount_orig
455: from jai_ap_tds_prepayments
456: where invoice_id = p_invoice_id
457: and invoice_distribution_id_prepay = p_invoice_distribution_id;
458:
459: /* bug 12965614. Added by Avanija

Line 477: from jai_ap_tds_prepayments

473: sum(decode(wct_applicable_flag , 'Y', wct_application_amount, 0)) wct_amount_orig,
474: sum(decode(essi_applicable_flag, 'Y', application_amount, 0)) essi_taxable_basis,
475: sum(decode(essi_applicable_flag, 'Y', calc_essi_appln_amt, 0)) essi_amount,
476: sum(decode(essi_applicable_flag , 'Y', essi_application_amount, 0)) essi_amount_orig
477: from jai_ap_tds_prepayments
478: where invoice_id = p_invoice_id
479: and invoice_distribution_id_prepay = p_invoice_distribution_id
480: and tds_threshold_grp_id is not null
481: and nvl(unapply_flag, 'N') <> 'Y' -- Bug 6363056

Line 488: from jai_ap_tds_prepayments

484: tds_threshold_trx_id_apply; /*Bug 9132694 - Added Group By clause to sum the tax amounts and create a single RTN reversal entry on unapplication*/
485:
486: cursor c_wct_details_apply(p_invoice_id number, p_invoice_distribution_id number) is
487: select wct_threshold_trx_id_apply, invoice_distribution_id -- Bug 6363056
488: from jai_ap_tds_prepayments
489: where invoice_id = p_invoice_id
490: and invoice_distribution_id_prepay = p_invoice_distribution_id
491: and wct_threshold_trx_id_apply is not null;
492:

Line 495: from jai_ap_tds_prepayments

491: and wct_threshold_trx_id_apply is not null;
492:
493: cursor c_essi_details_apply(p_invoice_id number, p_invoice_distribution_id number) is
494: select essi_threshold_trx_id_apply, invoice_distribution_id -- Bug 6363056
495: from jai_ap_tds_prepayments
496: where invoice_id = p_invoice_id
497: and invoice_distribution_id_prepay = p_invoice_distribution_id
498: and essi_threshold_trx_id_apply is not null;
499:

Line 507: from jai_ap_tds_prepayments

503: where set_of_books_id = cp_set_of_books_id;
504:
505: cursor c_get_tds_tax_id(p_invoice_id number, p_prepay_distribution_id number) is
506: select tds_tax_id_prepay
507: from jai_ap_tds_prepayments
508: where invoice_id = p_invoice_id
509: and invoice_distribution_id_prepay = p_prepay_distribution_id
510: and tds_tax_id_prepay is not null
511: and tds_applicable_flag = 'Y';

Line 515: from jai_ap_tds_prepayments

511: and tds_applicable_flag = 'Y';
512:
513: cursor c_get_wct_tax_id(p_invoice_id number, p_prepay_distribution_id number) is
514: select wct_tax_id_prepay
515: from jai_ap_tds_prepayments
516: where invoice_id = p_invoice_id
517: and invoice_distribution_id_prepay = p_prepay_distribution_id
518: and wct_tax_id_prepay is not null
519: and wct_applicable_flag = 'Y';

Line 523: from jai_ap_tds_prepayments

519: and wct_applicable_flag = 'Y';
520:
521: cursor c_get_essi_tax_id(p_invoice_id number, p_prepay_distribution_id number) is
522: select essi_tax_id_prepay
523: from jai_ap_tds_prepayments
524: where invoice_id = p_invoice_id
525: and invoice_distribution_id_prepay = p_prepay_distribution_id
526: and essi_tax_id_prepay is not null
527: and essi_applicable_flag = 'Y';

Line 721: update jai_ap_tds_prepayments

717: goto exit_from_procedure;
718: END IF;
719: END IF; /*if p_event = 'INSERT' then*/
720:
721: update jai_ap_tds_prepayments
722: set tds_threshold_trx_id_unapply = ln_threshold_trx_id_tds
723: where invoice_id = p_invoice_id
724: and invoice_distribution_id_prepay = p_parent_distribution_id
725: and tds_threshold_trx_id_apply is not null

Line 735: update jai_ap_tds_prepayments

731:
732: end if; /* r_tds_details_apply.tds_threshold_trx_id_apply is not null */
733:
734: /* update the unapply flag for invoice distribution */
735: update jai_ap_tds_prepayments
736: set unapply_flag = 'Y'
737: where invoice_id = p_invoice_id
738: and invoice_distribution_id_prepay = p_parent_distribution_id;
739:

Line 854: update jai_ap_tds_prepayments

850: if p_process_flag = 'E' then
851: goto exit_from_procedure;
852: end if;
853:
854: update jai_ap_tds_prepayments
855: set wct_threshold_trx_id_unapply = ln_threshold_trx_id_wct
856: where invoice_id = p_invoice_id
857: and invoice_distribution_id_prepay = p_parent_distribution_id
858: and wct_threshold_trx_id_apply is not null

Line 931: update jai_ap_tds_prepayments

927: if p_process_flag = 'E' then
928: goto exit_from_procedure;
929: end if;
930:
931: update jai_ap_tds_prepayments
932: set essi_threshold_trx_id_unapply = ln_threshold_trx_id_essi
933: where invoice_id = p_invoice_id
934: and invoice_distribution_id_prepay = p_parent_distribution_id
935: and essi_threshold_trx_id_apply is not null

Line 952: update jai_ap_tds_prepayments

948: end if;
949: /* Unapply ESSI */
950:
951: /* update the unapply flag for all */
952: update jai_ap_tds_prepayments
953: set unapply_flag = 'Y'
954: where invoice_id = p_invoice_id
955: and invoice_distribution_id_prepay = p_parent_distribution_id;
956:

Line 1016: from jai_ap_tds_prepayments

1012: --and amount > 0; --Added by bgowrava for bug#9214036 /* Commented for bug 15848719 */
1013:
1014: cursor c_get_amount_already_applied(p_invoice_distribution_id number) is
1015: select sum(application_amount)
1016: from jai_ap_tds_prepayments
1017: where invoice_distribution_id = p_invoice_distribution_id
1018: and nvl(unapply_flag, 'N') <> 'Y';
1019:
1020: /*START, Added by bgowrava for bug#9214036*/

Line 1040: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.allocate_prepayment=============');

1036:
1037: begin
1038:
1039: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.allocate_prepayment', 'START'); /* 1 */
1040: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.allocate_prepayment=============');
1041: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id:'||p_invoice_id );
1042: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_distribution_id:'||p_invoice_distribution_id );
1043: ln_remaining_prepayment_amount := abs(p_prepay_amount); /* Apply amount is negative */
1044: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_remaining_prepayment_amount:'||ln_remaining_prepayment_amount );

Line 1041: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id:'||p_invoice_id );

1037: begin
1038:
1039: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.allocate_prepayment', 'START'); /* 1 */
1040: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.allocate_prepayment=============');
1041: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id:'||p_invoice_id );
1042: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_distribution_id:'||p_invoice_distribution_id );
1043: ln_remaining_prepayment_amount := abs(p_prepay_amount); /* Apply amount is negative */
1044: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_remaining_prepayment_amount:'||ln_remaining_prepayment_amount );
1045: /* Loop through to get the taxable basis for each line in jai_ap_tds_inv_taxes */

Line 1042: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_distribution_id:'||p_invoice_distribution_id );

1038:
1039: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.allocate_prepayment', 'START'); /* 1 */
1040: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.allocate_prepayment=============');
1041: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id:'||p_invoice_id );
1042: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_distribution_id:'||p_invoice_distribution_id );
1043: ln_remaining_prepayment_amount := abs(p_prepay_amount); /* Apply amount is negative */
1044: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_remaining_prepayment_amount:'||ln_remaining_prepayment_amount );
1045: /* Loop through to get the taxable basis for each line in jai_ap_tds_inv_taxes */
1046: /* It is ok to loop through section_type = 'TDS_SECTION as considering any one section type

Line 1044: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_remaining_prepayment_amount:'||ln_remaining_prepayment_amount );

1040: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.allocate_prepayment=============');
1041: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_id:'||p_invoice_id );
1042: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'p_invoice_distribution_id:'||p_invoice_distribution_id );
1043: ln_remaining_prepayment_amount := abs(p_prepay_amount); /* Apply amount is negative */
1044: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_remaining_prepayment_amount:'||ln_remaining_prepayment_amount );
1045: /* Loop through to get the taxable basis for each line in jai_ap_tds_inv_taxes */
1046: /* It is ok to loop through section_type = 'TDS_SECTION as considering any one section type
1047: is ok and tds section will always be there */
1048:

Line 1052: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'cur_si_distributions_rec.invoice_distribution_id:'||cur_si_distributions_rec.invoice_distribution_id );

1048:
1049: -- Bug 4754213. Added by Lakshmi Gopalsami
1050: for cur_si_distributions_rec in c_jai_ap_tds_inv_taxes(p_invoice_id, p_invoice_distribution_id) /*Bug 9494469 - Removed parameter cp_section_type*/
1051: loop
1052: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'cur_si_distributions_rec.invoice_distribution_id:'||cur_si_distributions_rec.invoice_distribution_id );
1053: lv_reversal_flag := get_reversal_flag(cur_si_distributions_rec.invoice_distribution_id); /*Bug 8431516*/
1054: if lv_reversal_flag = 'N' then /*Bug 8431516*/
1055:
1056: ln_already_applied_amount:= 0;

Line 1065: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_already_applied_amount:'||ln_already_applied_amount );

1061: fetch c_get_amount_already_applied into ln_already_applied_amount;
1062: close c_get_amount_already_applied;
1063:
1064: ln_already_applied_amount := nvl(ln_already_applied_amount, 0);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_already_applied_amount:'||ln_already_applied_amount );
1066: /*START, Added by bgowrava for bug#9214036*/
1067: /* open c_get_effective_available_amt(cur_si_distributions_rec.invoice_id, cur_si_distributions_rec.invoice_line_number);
1068: fetch c_get_effective_available_amt into ln_less_amount;
1069: close c_get_effective_available_amt;

Line 1072: --jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_less_amount:'||ln_less_amount );

1068: fetch c_get_effective_available_amt into ln_less_amount;
1069: close c_get_effective_available_amt;
1070: ln_less_amount := nvl(ln_less_amount, 0); */ /* Commented for bug 15848719 */
1071: /*END, Added by bgowrava for bug#9214036*/
1072: --jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_less_amount:'||ln_less_amount );
1073: if cur_si_distributions_rec.amount>0 then /* Added for bug 15848719 */
1074: ln_effective_available_amount := cur_si_distributions_rec.amount - ln_already_applied_amount; /*- abs(ln_less_amount); - Commented for bug 15848719 */ --Added abs(ln_less_amount) by Bgowrava for Bug#9214036
1075: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_effective_available_amount:'||ln_effective_available_amount );
1076: ln_application_amount := least(ln_remaining_prepayment_amount, ln_effective_available_amount);

Line 1075: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_effective_available_amount:'||ln_effective_available_amount );

1071: /*END, Added by bgowrava for bug#9214036*/
1072: --jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_less_amount:'||ln_less_amount );
1073: if cur_si_distributions_rec.amount>0 then /* Added for bug 15848719 */
1074: ln_effective_available_amount := cur_si_distributions_rec.amount - ln_already_applied_amount; /*- abs(ln_less_amount); - Commented for bug 15848719 */ --Added abs(ln_less_amount) by Bgowrava for Bug#9214036
1075: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_effective_available_amount:'||ln_effective_available_amount );
1076: ln_application_amount := least(ln_remaining_prepayment_amount, ln_effective_available_amount);
1077: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_application_amount:'||ln_application_amount );
1078: end if; /* Added for bug 15848719 */
1079: if ln_application_amount > 0 then

Line 1077: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_application_amount:'||ln_application_amount );

1073: if cur_si_distributions_rec.amount>0 then /* Added for bug 15848719 */
1074: ln_effective_available_amount := cur_si_distributions_rec.amount - ln_already_applied_amount; /*- abs(ln_less_amount); - Commented for bug 15848719 */ --Added abs(ln_less_amount) by Bgowrava for Bug#9214036
1075: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_effective_available_amount:'||ln_effective_available_amount );
1076: ln_application_amount := least(ln_remaining_prepayment_amount, ln_effective_available_amount);
1077: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_application_amount:'||ln_application_amount );
1078: end if; /* Added for bug 15848719 */
1079: if ln_application_amount > 0 then
1080:
1081: /* Insert into jai_ap_tds_prepayments */

Line 1081: /* Insert into jai_ap_tds_prepayments */

1077: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_application_amount:'||ln_application_amount );
1078: end if; /* Added for bug 15848719 */
1079: if ln_application_amount > 0 then
1080:
1081: /* Insert into jai_ap_tds_prepayments */
1082: insert into jai_ap_tds_prepayments
1083: (
1084: tds_prepayment_id ,
1085: invoice_id ,

Line 1082: insert into jai_ap_tds_prepayments

1078: end if; /* Added for bug 15848719 */
1079: if ln_application_amount > 0 then
1080:
1081: /* Insert into jai_ap_tds_prepayments */
1082: insert into jai_ap_tds_prepayments
1083: (
1084: tds_prepayment_id ,
1085: invoice_id ,
1086: invoice_distribution_id_prepay ,

Line 1097: jai_ap_tds_prepayments_s.nextval ,

1093: last_update_login
1094: )
1095: values
1096: (
1097: jai_ap_tds_prepayments_s.nextval ,
1098: p_invoice_id ,
1099: p_invoice_distribution_id ,
1100: cur_si_distributions_rec.invoice_distribution_id ,
1101: ln_application_amount ,

Line 1165: cursor c_jai_ap_tds_prepayments(p_invoice_id number, p_invoice_distribution_id number) is

1161: where invoice_id = p_invoice_id
1162: and invoice_distribution_id = p_invoice_distribution_id;
1163:
1164:
1165: cursor c_jai_ap_tds_prepayments(p_invoice_id number, p_invoice_distribution_id number) is
1166: select tds_prepayment_id,
1167: invoice_distribution_id
1168: from jai_ap_tds_prepayments
1169: where invoice_id = p_invoice_id

Line 1168: from jai_ap_tds_prepayments

1164:
1165: cursor c_jai_ap_tds_prepayments(p_invoice_id number, p_invoice_distribution_id number) is
1166: select tds_prepayment_id,
1167: invoice_distribution_id
1168: from jai_ap_tds_prepayments
1169: where invoice_id = p_invoice_id
1170: and invoice_distribution_id_prepay = p_invoice_distribution_id;
1171:
1172:

Line 1196: lv_tds_section_code_prepay jai_ap_tds_prepayments.tds_section_code_prepay%type;

1192:
1193: lv_applicable_flag varchar2(1);
1194: lv_is_si_validated_flag varchar2(1);
1195:
1196: lv_tds_section_code_prepay jai_ap_tds_prepayments.tds_section_code_prepay%type;
1197: ln_tds_tax_id_prepay jai_ap_tds_prepayments.tds_tax_id_prepay%type;
1198: ln_wct_tax_id_prepay jai_ap_tds_prepayments.wct_tax_id_prepay%type;
1199: ln_essi_tax_id_prepay jai_ap_tds_prepayments.essi_tax_id_prepay%type;
1200: lv_application_basis jai_ap_tds_prepayments.application_basis%type;

Line 1197: ln_tds_tax_id_prepay jai_ap_tds_prepayments.tds_tax_id_prepay%type;

1193: lv_applicable_flag varchar2(1);
1194: lv_is_si_validated_flag varchar2(1);
1195:
1196: lv_tds_section_code_prepay jai_ap_tds_prepayments.tds_section_code_prepay%type;
1197: ln_tds_tax_id_prepay jai_ap_tds_prepayments.tds_tax_id_prepay%type;
1198: ln_wct_tax_id_prepay jai_ap_tds_prepayments.wct_tax_id_prepay%type;
1199: ln_essi_tax_id_prepay jai_ap_tds_prepayments.essi_tax_id_prepay%type;
1200: lv_application_basis jai_ap_tds_prepayments.application_basis%type;
1201:

Line 1198: ln_wct_tax_id_prepay jai_ap_tds_prepayments.wct_tax_id_prepay%type;

1194: lv_is_si_validated_flag varchar2(1);
1195:
1196: lv_tds_section_code_prepay jai_ap_tds_prepayments.tds_section_code_prepay%type;
1197: ln_tds_tax_id_prepay jai_ap_tds_prepayments.tds_tax_id_prepay%type;
1198: ln_wct_tax_id_prepay jai_ap_tds_prepayments.wct_tax_id_prepay%type;
1199: ln_essi_tax_id_prepay jai_ap_tds_prepayments.essi_tax_id_prepay%type;
1200: lv_application_basis jai_ap_tds_prepayments.application_basis%type;
1201:
1202:

Line 1199: ln_essi_tax_id_prepay jai_ap_tds_prepayments.essi_tax_id_prepay%type;

1195:
1196: lv_tds_section_code_prepay jai_ap_tds_prepayments.tds_section_code_prepay%type;
1197: ln_tds_tax_id_prepay jai_ap_tds_prepayments.tds_tax_id_prepay%type;
1198: ln_wct_tax_id_prepay jai_ap_tds_prepayments.wct_tax_id_prepay%type;
1199: ln_essi_tax_id_prepay jai_ap_tds_prepayments.essi_tax_id_prepay%type;
1200: lv_application_basis jai_ap_tds_prepayments.application_basis%type;
1201:
1202:
1203: lv_tds_section_code_other jai_ap_tds_prepayments.tds_section_code_other%type;

Line 1200: lv_application_basis jai_ap_tds_prepayments.application_basis%type;

1196: lv_tds_section_code_prepay jai_ap_tds_prepayments.tds_section_code_prepay%type;
1197: ln_tds_tax_id_prepay jai_ap_tds_prepayments.tds_tax_id_prepay%type;
1198: ln_wct_tax_id_prepay jai_ap_tds_prepayments.wct_tax_id_prepay%type;
1199: ln_essi_tax_id_prepay jai_ap_tds_prepayments.essi_tax_id_prepay%type;
1200: lv_application_basis jai_ap_tds_prepayments.application_basis%type;
1201:
1202:
1203: lv_tds_section_code_other jai_ap_tds_prepayments.tds_section_code_other%type;
1204: ln_tds_tax_id_other jai_ap_tds_prepayments.tds_tax_id_other%type;

Line 1203: lv_tds_section_code_other jai_ap_tds_prepayments.tds_section_code_other%type;

1199: ln_essi_tax_id_prepay jai_ap_tds_prepayments.essi_tax_id_prepay%type;
1200: lv_application_basis jai_ap_tds_prepayments.application_basis%type;
1201:
1202:
1203: lv_tds_section_code_other jai_ap_tds_prepayments.tds_section_code_other%type;
1204: ln_tds_tax_id_other jai_ap_tds_prepayments.tds_tax_id_other%type;
1205: lv_tds_applicable_flag jai_ap_tds_prepayments.tds_applicable_flag%type;
1206: ln_wct_tax_id_other jai_ap_tds_prepayments.wct_tax_id_other%type;
1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;

Line 1204: ln_tds_tax_id_other jai_ap_tds_prepayments.tds_tax_id_other%type;

1200: lv_application_basis jai_ap_tds_prepayments.application_basis%type;
1201:
1202:
1203: lv_tds_section_code_other jai_ap_tds_prepayments.tds_section_code_other%type;
1204: ln_tds_tax_id_other jai_ap_tds_prepayments.tds_tax_id_other%type;
1205: lv_tds_applicable_flag jai_ap_tds_prepayments.tds_applicable_flag%type;
1206: ln_wct_tax_id_other jai_ap_tds_prepayments.wct_tax_id_other%type;
1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;
1208: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;

Line 1205: lv_tds_applicable_flag jai_ap_tds_prepayments.tds_applicable_flag%type;

1201:
1202:
1203: lv_tds_section_code_other jai_ap_tds_prepayments.tds_section_code_other%type;
1204: ln_tds_tax_id_other jai_ap_tds_prepayments.tds_tax_id_other%type;
1205: lv_tds_applicable_flag jai_ap_tds_prepayments.tds_applicable_flag%type;
1206: ln_wct_tax_id_other jai_ap_tds_prepayments.wct_tax_id_other%type;
1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;
1208: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;
1209: lv_essi_applicable_flag jai_ap_tds_prepayments.essi_applicable_flag%type;

Line 1206: ln_wct_tax_id_other jai_ap_tds_prepayments.wct_tax_id_other%type;

1202:
1203: lv_tds_section_code_other jai_ap_tds_prepayments.tds_section_code_other%type;
1204: ln_tds_tax_id_other jai_ap_tds_prepayments.tds_tax_id_other%type;
1205: lv_tds_applicable_flag jai_ap_tds_prepayments.tds_applicable_flag%type;
1206: ln_wct_tax_id_other jai_ap_tds_prepayments.wct_tax_id_other%type;
1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;
1208: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;
1209: lv_essi_applicable_flag jai_ap_tds_prepayments.essi_applicable_flag%type;
1210:

Line 1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;

1203: lv_tds_section_code_other jai_ap_tds_prepayments.tds_section_code_other%type;
1204: ln_tds_tax_id_other jai_ap_tds_prepayments.tds_tax_id_other%type;
1205: lv_tds_applicable_flag jai_ap_tds_prepayments.tds_applicable_flag%type;
1206: ln_wct_tax_id_other jai_ap_tds_prepayments.wct_tax_id_other%type;
1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;
1208: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;
1209: lv_essi_applicable_flag jai_ap_tds_prepayments.essi_applicable_flag%type;
1210:
1211: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483

Line 1208: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;

1204: ln_tds_tax_id_other jai_ap_tds_prepayments.tds_tax_id_other%type;
1205: lv_tds_applicable_flag jai_ap_tds_prepayments.tds_applicable_flag%type;
1206: ln_wct_tax_id_other jai_ap_tds_prepayments.wct_tax_id_other%type;
1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;
1208: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;
1209: lv_essi_applicable_flag jai_ap_tds_prepayments.essi_applicable_flag%type;
1210:
1211: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1212:

Line 1209: lv_essi_applicable_flag jai_ap_tds_prepayments.essi_applicable_flag%type;

1205: lv_tds_applicable_flag jai_ap_tds_prepayments.tds_applicable_flag%type;
1206: ln_wct_tax_id_other jai_ap_tds_prepayments.wct_tax_id_other%type;
1207: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;
1208: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;
1209: lv_essi_applicable_flag jai_ap_tds_prepayments.essi_applicable_flag%type;
1210:
1211: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1212:
1213:

Line 1219: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','==========jai_ap_tds_prepayemnts_pkg.populate_section_tax===========');

1215:
1216: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.populate_section_tax', 'START'); /* 1 */
1217:
1218: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1219: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','==========jai_ap_tds_prepayemnts_pkg.populate_section_tax===========');
1220: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id: '||pre_pay_inv_id);
1221: /*
1222: open c_get_tds_application_basis(p_invoice_id);
1223: fetch c_get_tds_application_basis into lv_is_si_validated_flag;

Line 1220: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id: '||pre_pay_inv_id);

1216: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.populate_section_tax', 'START'); /* 1 */
1217:
1218: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1219: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','==========jai_ap_tds_prepayemnts_pkg.populate_section_tax===========');
1220: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id: '||pre_pay_inv_id);
1221: /*
1222: open c_get_tds_application_basis(p_invoice_id);
1223: fetch c_get_tds_application_basis into lv_is_si_validated_flag;
1224: close c_get_tds_application_basis;

Line 1246: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','lv_pp_thhold_trx_id: '||lv_pp_thhold_trx_id);

1242: -- Get the tds_threshold_trx_id of the prepay invoice.
1243: OPEN get_threshold_trx_id (pre_pay_inv_id,p_prepay_distribution_id );
1244: FETCH get_threshold_trx_id INTO lv_pp_thhold_trx_id ;
1245: CLOSE get_threshold_trx_id;
1246: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','lv_pp_thhold_trx_id: '||lv_pp_thhold_trx_id);
1247: -- Get the threshold_trx_id of the standard invoice.
1248: SELECT max(nvl(threshold_trx_id, 0))
1249: INTO lv_si_thhold_trx_id
1250: FROM jai_ap_tds_inv_taxes

Line 1252: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_si_thhold_trx_id: '||lv_si_thhold_trx_id);

1248: SELECT max(nvl(threshold_trx_id, 0))
1249: INTO lv_si_thhold_trx_id
1250: FROM jai_ap_tds_inv_taxes
1251: WHERE invoice_id = p_invoice_id ;
1252: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_si_thhold_trx_id: '||lv_si_thhold_trx_id);
1253: IF (lv_si_thhold_trx_id > NVL (lv_pp_thhold_trx_id,0 )) THEN
1254: lv_application_basis := 'STANDARD INVOICE';
1255: ELSIF ( NVL (lv_pp_thhold_trx_id,0 ) <> 0 ) THEN
1256: lv_application_basis := 'PREPAYMENT';

Line 1259: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','lv_application_basis: '||lv_application_basis);

1255: ELSIF ( NVL (lv_pp_thhold_trx_id,0 ) <> 0 ) THEN
1256: lv_application_basis := 'PREPAYMENT';
1257: END IF ;
1258: /*Bug 5751783 - End*/
1259: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','lv_application_basis: '||lv_application_basis);
1260: /* Get the details of the taxes of all sections that was applicable on the distribution line as in the Prepayment */
1261: for cur_rec_pp_tax_details in c_get_tax_details_pp_inv_dist(pre_pay_inv_id,p_prepay_distribution_id) loop -- Added parameter pre_pay_inv_id by Jia for FP bug6929483
1262: -- Bug 4754213. Added by Lakshmi Gopalsami
1263: if cur_rec_pp_tax_details.section_type = 'TDS_SECTION' then

Line 1277: for cur_rec_pp_allocations in c_jai_ap_tds_prepayments(p_invoice_id, p_invoice_distribution_id) loop

1273:
1274:
1275: /* Loop and get all the distribution is that has been been allocated for this prepayment and
1276: get the tax details that is applicable on the allocated line */
1277: for cur_rec_pp_allocations in c_jai_ap_tds_prepayments(p_invoice_id, p_invoice_distribution_id) loop
1278:
1279: for cur_rec in c_get_tax_details_si_inv_dist(p_invoice_id, cur_rec_pp_allocations.invoice_distribution_id) loop
1280: -- Bug 4754213. Added by Lakshmi Gopalsami
1281: if cur_rec.section_type = 'TDS_SECTION' then

Line 1335: /* Update jai_ap_tds_prepayments */

1331:
1332: end loop; /* Cur rec */
1333:
1334:
1335: /* Update jai_ap_tds_prepayments */
1336: update jai_ap_tds_prepayments
1337: set application_basis = lv_application_basis ,
1338: tds_section_code_prepay = lv_tds_section_code_prepay ,
1339: tds_section_code_other = lv_tds_section_code_other ,

Line 1336: update jai_ap_tds_prepayments

1332: end loop; /* Cur rec */
1333:
1334:
1335: /* Update jai_ap_tds_prepayments */
1336: update jai_ap_tds_prepayments
1337: set application_basis = lv_application_basis ,
1338: tds_section_code_prepay = lv_tds_section_code_prepay ,
1339: tds_section_code_other = lv_tds_section_code_other ,
1340: tds_tax_id_prepay = ln_tds_tax_id_prepay ,

Line 1394: cursor c_jai_ap_tds_prepayments(p_invoice_id number, p_invoice_distribution_id number) is

1390: select currency_code
1391: from gl_sets_of_books
1392: where set_of_books_id = cp_set_of_books_id;
1393:
1394: cursor c_jai_ap_tds_prepayments(p_invoice_id number, p_invoice_distribution_id number) is
1395: select tds_prepayment_id,
1396: application_amount,
1397: application_basis,
1398: /*

Line 1416: from jai_ap_tds_prepayments

1412: */
1413: tds_applicable_flag, tds_tax_id_other, tds_tax_id_prepay,
1414: wct_applicable_flag, wct_tax_id_other, wct_tax_id_prepay,
1415: essi_applicable_flag, essi_tax_id_other, essi_tax_id_prepay
1416: from jai_ap_tds_prepayments
1417: where invoice_id = p_invoice_id
1418: and invoice_distribution_id_prepay = p_invoice_distribution_id;
1419:
1420:

Line 1465: from jai_ap_tds_prepayments

1461: sum( decode(wct_applicable_flag, 'Y', application_amount*p_exchange_rate, 0) ) wct_taxable_basis,
1462: sum( decode(wct_applicable_flag, 'Y', wct_application_amount, 0) ) wct_amount,
1463: sum( decode(essi_applicable_flag, 'Y', application_amount*p_exchange_rate, 0) ) essi_taxable_basis,
1464: sum( decode(essi_applicable_flag, 'Y', essi_application_amount, 0) ) essi_amount
1465: from jai_ap_tds_prepayments
1466: where invoice_id = p_invoice_id
1467: and invoice_distribution_id_prepay = p_invoice_distribution_id;
1468:
1469: /* Bug 4522507. Added by Lakshmi Gopalsami */

Line 1481: from jai_ap_tds_prepayments jatp

1477:
1478: /*Bug 6363056 - Replaced p_invoice_distribution_id with p_item_distribution_id*/
1479: cursor c_get_amt_tds_inv_generated_si(p_invoice_id number, p_item_distribution_id number) is
1480: select sum(calc_tds_appln_amt) , sum(application_amount)
1481: from jai_ap_tds_prepayments jatp
1482: where invoice_id = p_invoice_id
1483: and invoice_distribution_id_prepay = p_invoice_distribution_id
1484: /*Bug 6363056. Added invoice_distribution_id condition also*/
1485: and invoice_distribution_id = p_item_distribution_id

Line 1521: from jai_ap_tds_prepayments

1517:
1518: cursor c_get_tax_sec_det(p_invoice_id number, p_invoice_distribution_id number)
1519: is
1520: select tds_section_code_other, tds_tax_id_other, application_amount, invoice_distribution_id
1521: from jai_ap_tds_prepayments
1522: where invoice_id = p_invoice_id
1523: and invoice_distribution_id_prepay = p_invoice_distribution_id;
1524:
1525: ln_si_thgrp_id number;

Line 1555: FROM jai_ap_tds_prepayments

1551: /* Bug 14183670 -Start */
1552: cursor c_applied_amount(p_invoice_id number)
1553: is
1554: SELECT nvl(SUM(application_amount), 0)
1555: FROM jai_ap_tds_prepayments
1556: WHERE invoice_id = p_invoice_id
1557: AND tds_threshold_trx_id_unapply IS NULL;
1558: ln_application_amount number;
1559: /* Bug 14183670 -end*/

Line 1584: lv_application_basis jai_ap_tds_prepayments.application_basis%type;

1580: lb_result boolean;
1581: ln_req_id number;
1582: ln_pp_section_tax_id number;
1583: ln_threshold_grp_audit_id number;
1584: lv_application_basis jai_ap_tds_prepayments.application_basis%type;
1585: /* Bug 4522507. Added by Lakshmi Gopalsami */
1586: ln_threshold_trx_id_prepay jai_ap_tds_inv_taxes.threshold_trx_id%type;
1587: ln_amt_tds_inv_generated_si number;
1588: --Added the below 6 variables by Sanjikum for Bug#5131075(4718907)

Line 1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;

1607: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1612: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1613: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1614: /*Bug 6363056 - End*/
1615: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483

Line 1628: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.process_tds_invoices=============');

1624:
1625: begin
1626:
1627: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_tds_invoices', 'START'); /* 1 */
1628: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.process_tds_invoices=============');
1629: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_id :'||p_invoice_id);
1630: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_distribution_id :'||p_invoice_distribution_id);
1631: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_prepay_distribution_id :'||p_prepay_distribution_id);
1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);

Line 1629: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_id :'||p_invoice_id);

1625: begin
1626:
1627: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_tds_invoices', 'START'); /* 1 */
1628: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.process_tds_invoices=============');
1629: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_id :'||p_invoice_id);
1630: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_distribution_id :'||p_invoice_distribution_id);
1631: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_prepay_distribution_id :'||p_prepay_distribution_id);
1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);
1633: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483

Line 1630: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_distribution_id :'||p_invoice_distribution_id);

1626:
1627: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_tds_invoices', 'START'); /* 1 */
1628: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.process_tds_invoices=============');
1629: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_id :'||p_invoice_id);
1630: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_distribution_id :'||p_invoice_distribution_id);
1631: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_prepay_distribution_id :'||p_prepay_distribution_id);
1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);
1633: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1634: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id :'||pre_pay_inv_id);

Line 1631: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_prepay_distribution_id :'||p_prepay_distribution_id);

1627: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_tds_invoices', 'START'); /* 1 */
1628: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.process_tds_invoices=============');
1629: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_id :'||p_invoice_id);
1630: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_distribution_id :'||p_invoice_distribution_id);
1631: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_prepay_distribution_id :'||p_prepay_distribution_id);
1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);
1633: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1634: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id :'||pre_pay_inv_id);
1635: open c_gl_sets_of_books(p_set_of_books_id);

Line 1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);

1628: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', '=============jai_ap_tds_prepayemnts_pkg.process_tds_invoices=============');
1629: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_id :'||p_invoice_id);
1630: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_distribution_id :'||p_invoice_distribution_id);
1631: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_prepay_distribution_id :'||p_prepay_distribution_id);
1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);
1633: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1634: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id :'||pre_pay_inv_id);
1635: open c_gl_sets_of_books(p_set_of_books_id);
1636: fetch c_gl_sets_of_books into r_gl_sets_of_books;

Line 1634: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id :'||pre_pay_inv_id);

1630: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_invoice_distribution_id :'||p_invoice_distribution_id);
1631: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' p_prepay_distribution_id :'||p_prepay_distribution_id);
1632: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_prepay_amount :'||p_prepay_amount);
1633: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1634: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' pre_pay_inv_id :'||pre_pay_inv_id);
1635: open c_gl_sets_of_books(p_set_of_books_id);
1636: fetch c_gl_sets_of_books into r_gl_sets_of_books;
1637: close c_gl_sets_of_books;
1638:

Line 1650: for cur_rec in c_jai_ap_tds_prepayments(p_invoice_id, p_invoice_distribution_id)

1646:
1647: ln_prepayment_amount := -1 * p_prepay_amount * ln_exchange_rate;
1648:
1649: /* update the tax amount for the prepayements */
1650: for cur_rec in c_jai_ap_tds_prepayments(p_invoice_id, p_invoice_distribution_id)
1651: loop
1652:
1653: if lv_application_basis is null then
1654: lv_application_basis := cur_rec.application_basis;

Line 1656: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','lv_application_basis :'||lv_application_basis);

1652:
1653: if lv_application_basis is null then
1654: lv_application_basis := cur_rec.application_basis;
1655: end if;
1656: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','lv_application_basis :'||lv_application_basis);
1657: /* TDS application amount */
1658: if cur_rec.tds_tax_id_other is not null AND
1659: cur_rec.tds_tax_id_prepay IS NOT NULL AND -- Bug 6363056
1660: cur_rec.tds_applicable_flag = 'Y' -- Bug 6363056

Line 1662: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','Inside if');

1658: if cur_rec.tds_tax_id_other is not null AND
1659: cur_rec.tds_tax_id_prepay IS NOT NULL AND -- Bug 6363056
1660: cur_rec.tds_applicable_flag = 'Y' -- Bug 6363056
1661: THEN
1662: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','Inside if');
1663: r_ja_in_tax_codes := null;
1664: open c_ja_in_tax_codes(cur_rec.tds_tax_id_other); -- Bug 6363056
1665: fetch c_ja_in_tax_codes into r_ja_in_tax_codes;
1666: close c_ja_in_tax_codes;

Line 1671: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_tax_rate_basis :'||ln_tax_rate_basis);

1667:
1668: ln_tax_rate_basis := r_ja_in_tax_codes.tax_rate; -- bug 6363056
1669: ln_si_tax_id := cur_rec.tds_tax_id_other; -- bug 6363056
1670:
1671: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_tax_rate_basis :'||ln_tax_rate_basis);
1672: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_si_tax_id :'||ln_si_tax_id);
1673: /* Bug 5722028. Addd by CSahoo
1674: * Need to round the value as per the setup.
1675: */

Line 1672: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_si_tax_id :'||ln_si_tax_id);

1668: ln_tax_rate_basis := r_ja_in_tax_codes.tax_rate; -- bug 6363056
1669: ln_si_tax_id := cur_rec.tds_tax_id_other; -- bug 6363056
1670:
1671: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_tax_rate_basis :'||ln_tax_rate_basis);
1672: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_si_tax_id :'||ln_si_tax_id);
1673: /* Bug 5722028. Addd by CSahoo
1674: * Need to round the value as per the setup.
1675: */
1676: ln_tds_tmp_amt := 0;

Line 1693: update jai_ap_tds_prepayments

1689: END IF;
1690: -- End for bug 5722028
1691:
1692:
1693: update jai_ap_tds_prepayments
1694: set tds_application_amount = ln_tds_tmp_amt, -- Bug 5722028
1695: /*Bug 5751783. Added the update for non-rounded value also*/
1696: calc_tds_appln_amt = cur_rec.application_amount * ln_exchange_rate * (ln_tax_rate_basis/100)
1697: where tds_prepayment_id = cur_rec.tds_prepayment_id;

Line 1753: update jai_ap_tds_prepayments

1749: END IF;
1750: */
1751: -- End for bug 5722028
1752:
1753: update jai_ap_tds_prepayments
1754: set wct_application_amount = ln_tds_tmp_amt, -- Bug 5722028
1755: /*Bug 5751783. Added the update for non-rounded value also*/
1756: calc_wct_appln_amt = cur_rec.application_amount * ln_exchange_rate * (ln_tax_rate_basis/100)
1757: where tds_prepayment_id = cur_rec.tds_prepayment_id;

Line 1811: update jai_ap_tds_prepayments

1807: END IF;
1808: */
1809: -- End for bug 5722028
1810:
1811: update jai_ap_tds_prepayments
1812: set essi_application_amount = ln_tds_tmp_amt, --Bug 5722028
1813: /*Bug 5751783. Added the update for non-rounded value also*/
1814: calc_essi_appln_amt = cur_rec.application_amount * ln_exchange_rate * (ln_tax_rate_basis/100)
1815: where tds_prepayment_id = cur_rec.tds_prepayment_id;

Line 1842: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_taxable_amount :'||ln_taxable_amount);

1838: ln_application_mode := NULL;
1839: OPEN c_taxable_amount(p_invoice_id);
1840: FETCH c_taxable_amount INTO ln_taxable_amount;
1841: CLOSE c_taxable_amount;
1842: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_taxable_amount :'||ln_taxable_amount);
1843: IF ln_taxable_amount > 0 THEN
1844: OPEN c_available_amount(p_invoice_id, p_exchange_rate);
1845: FETCH c_available_amount INTO ln_available_amount;
1846: CLOSE c_available_amount;

Line 1863: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_amount :'||ln_application_amount);

1859: ELSE
1860: ln_application_mode := 'A';
1861: END IF;
1862: /*Bug 12671504 - End*/
1863: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_amount :'||ln_application_amount);
1864: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_available_amount :'||ln_available_amount);
1865: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_mode :'||ln_application_mode);
1866: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','r_get_tax_sec_det.application_amount :'||r_get_tax_sec_det.application_amount);
1867: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);

Line 1864: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_available_amount :'||ln_available_amount);

1860: ln_application_mode := 'A';
1861: END IF;
1862: /*Bug 12671504 - End*/
1863: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_amount :'||ln_application_amount);
1864: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_available_amount :'||ln_available_amount);
1865: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_mode :'||ln_application_mode);
1866: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','r_get_tax_sec_det.application_amount :'||r_get_tax_sec_det.application_amount);
1867: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);
1868: if r_get_tax_sec_det.application_amount > 0

Line 1865: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_mode :'||ln_application_mode);

1861: END IF;
1862: /*Bug 12671504 - End*/
1863: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_amount :'||ln_application_amount);
1864: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_available_amount :'||ln_available_amount);
1865: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_mode :'||ln_application_mode);
1866: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','r_get_tax_sec_det.application_amount :'||r_get_tax_sec_det.application_amount);
1867: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);
1868: if r_get_tax_sec_det.application_amount > 0
1869: and (r_get_tax_sec_det.tds_section_code_other is not null or r_get_tax_sec_det.tds_tax_id_other is not null)

Line 1866: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','r_get_tax_sec_det.application_amount :'||r_get_tax_sec_det.application_amount);

1862: /*Bug 12671504 - End*/
1863: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_amount :'||ln_application_amount);
1864: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_available_amount :'||ln_available_amount);
1865: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_mode :'||ln_application_mode);
1866: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','r_get_tax_sec_det.application_amount :'||r_get_tax_sec_det.application_amount);
1867: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);
1868: if r_get_tax_sec_det.application_amount > 0
1869: and (r_get_tax_sec_det.tds_section_code_other is not null or r_get_tax_sec_det.tds_tax_id_other is not null)
1870: and r_get_total_prepayment_tax.tds_amount = 0

Line 1867: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);

1863: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_amount :'||ln_application_amount);
1864: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_available_amount :'||ln_available_amount);
1865: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_application_mode :'||ln_application_mode);
1866: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','r_get_tax_sec_det.application_amount :'||r_get_tax_sec_det.application_amount);
1867: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);
1868: if r_get_tax_sec_det.application_amount > 0
1869: and (r_get_tax_sec_det.tds_section_code_other is not null or r_get_tax_sec_det.tds_tax_id_other is not null)
1870: and r_get_total_prepayment_tax.tds_amount = 0
1871: and ln_application_mode = 'A'

Line 1908: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_pp_thhold_grp_id :'||ln_pp_thhold_grp_id);

1904: ----------------------------------------------------------------------
1905: -- Added parameter pre_pay_inv_id by Jia for FP bug6929483,End
1906: fetch c_get_prepayment_thgroup into ln_pp_thhold_grp_id, ln_prepay_tax_id, ln_threshold_trx_id_prepay;
1907: close c_get_prepayment_thgroup;
1908: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_pp_thhold_grp_id :'||ln_pp_thhold_grp_id);
1909: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_prepay_tax_id :'||ln_prepay_tax_id);
1910: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_threshold_trx_id_prepay :'||ln_threshold_trx_id_prepay);
1911: IF ln_pp_thhold_grp_id IS NULL
1912: AND (r_get_total_prepayment_tax.tds_amount > 0 OR

Line 1909: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_prepay_tax_id :'||ln_prepay_tax_id);

1905: -- Added parameter pre_pay_inv_id by Jia for FP bug6929483,End
1906: fetch c_get_prepayment_thgroup into ln_pp_thhold_grp_id, ln_prepay_tax_id, ln_threshold_trx_id_prepay;
1907: close c_get_prepayment_thgroup;
1908: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_pp_thhold_grp_id :'||ln_pp_thhold_grp_id);
1909: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_prepay_tax_id :'||ln_prepay_tax_id);
1910: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_threshold_trx_id_prepay :'||ln_threshold_trx_id_prepay);
1911: IF ln_pp_thhold_grp_id IS NULL
1912: AND (r_get_total_prepayment_tax.tds_amount > 0 OR
1913: r_get_total_prepayment_tax.wct_amount > 0 OR

Line 1910: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_threshold_trx_id_prepay :'||ln_threshold_trx_id_prepay);

1906: fetch c_get_prepayment_thgroup into ln_pp_thhold_grp_id, ln_prepay_tax_id, ln_threshold_trx_id_prepay;
1907: close c_get_prepayment_thgroup;
1908: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_pp_thhold_grp_id :'||ln_pp_thhold_grp_id);
1909: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_prepay_tax_id :'||ln_prepay_tax_id);
1910: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_threshold_trx_id_prepay :'||ln_threshold_trx_id_prepay);
1911: IF ln_pp_thhold_grp_id IS NULL
1912: AND (r_get_total_prepayment_tax.tds_amount > 0 OR
1913: r_get_total_prepayment_tax.wct_amount > 0 OR
1914: r_get_total_prepayment_tax.essi_amount > 0) THEN

Line 1929: jai_ap_tds_prepayments jatp

1925: jatp.tds_prepayment_id tds_prepayment_id,
1926: jatp.application_amount tds_taxable_basis,
1927: jatp.invoice_distribution_id tax_dist
1928: FROM jai_ap_tds_thhold_trxs jattt,
1929: jai_ap_tds_prepayments jatp
1930: WHERE jattt.invoice_id = jatp.invoice_id
1931: AND jattt.tds_event = 'INVOICE VALIDATE'
1932: AND jatp.tds_applicable_flag ='Y'
1933: AND invoice_distribution_id_prepay = p_invoice_distribution_id

Line 1961: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_threshold_grp_id :'||ln_threshold_grp_id);

1957: END IF ;
1958: END IF ;
1959:
1960: ln_threshold_grp_id := ln_temp_threshold_grp_id;
1961: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_threshold_grp_id :'||ln_threshold_grp_id);
1962: --Call to procedure - get_tds_threshold_slab, Store the current Threshold slab and type before PP application
1963: jai_ap_tds_generation_pkg.get_tds_threshold_slab(
1964: p_prepay_distribution_id => p_prepay_distribution_id,
1965: p_threshold_grp_id => ln_temp_threshold_grp_id,

Line 1976: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);

1972:
1973: IF p_process_flag = 'E' THEN
1974: goto exit_from_procedure;
1975: END IF;
1976: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' r_get_total_prepayment_tax.tds_amount :'||r_get_total_prepayment_tax.tds_amount);
1977: if r_get_total_prepayment_tax.tds_amount > 0 THEN
1978: /* update the threshold with the tds amount that will be impacted because of this application */
1979: jai_ap_tds_generation_pkg.maintain_thhold_grps
1980: (

Line 1999: update jai_ap_tds_prepayments

1995: END IF;
1996:
1997: -- Update each distribution with the threshold grp id as
1998: -- it may vary depending on the date and the group.
1999: update jai_ap_tds_prepayments
2000: set tds_threshold_grp_id = ln_threshold_grp_id
2001: where tds_prepayment_id = get_si_det.tds_prepayment_id; -- Bug 6363056
2002:
2003: /* TDS invoice was generated against the Prepayment,

Line 2013: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_invoice_id :' || p_invoice_id);

2009: */
2010: open c_get_amt_tds_inv_generated_si(p_invoice_id, get_si_det.tax_dist);
2011: fetch c_get_amt_tds_inv_generated_si INTO ln_amt_tds_inv_generated_si, ln_tds_application_amt;
2012: close c_get_amt_tds_inv_generated_si;
2013: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_invoice_id :' || p_invoice_id);
2014: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','get_si_det.tax_dist :' || get_si_det.tax_dist);
2015: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_amt_tds_inv_generated_si :' || ln_amt_tds_inv_generated_si);
2016: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tds_application_amt :' || ln_tds_application_amt);
2017: /*Bug 8431516 - Start*/

Line 2014: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','get_si_det.tax_dist :' || get_si_det.tax_dist);

2010: open c_get_amt_tds_inv_generated_si(p_invoice_id, get_si_det.tax_dist);
2011: fetch c_get_amt_tds_inv_generated_si INTO ln_amt_tds_inv_generated_si, ln_tds_application_amt;
2012: close c_get_amt_tds_inv_generated_si;
2013: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_invoice_id :' || p_invoice_id);
2014: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','get_si_det.tax_dist :' || get_si_det.tax_dist);
2015: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_amt_tds_inv_generated_si :' || ln_amt_tds_inv_generated_si);
2016: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tds_application_amt :' || ln_tds_application_amt);
2017: /*Bug 8431516 - Start*/
2018: ln_tot_tds_amt := ln_tot_tds_amt + ln_amt_tds_inv_generated_si;

Line 2015: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_amt_tds_inv_generated_si :' || ln_amt_tds_inv_generated_si);

2011: fetch c_get_amt_tds_inv_generated_si INTO ln_amt_tds_inv_generated_si, ln_tds_application_amt;
2012: close c_get_amt_tds_inv_generated_si;
2013: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_invoice_id :' || p_invoice_id);
2014: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','get_si_det.tax_dist :' || get_si_det.tax_dist);
2015: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_amt_tds_inv_generated_si :' || ln_amt_tds_inv_generated_si);
2016: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tds_application_amt :' || ln_tds_application_amt);
2017: /*Bug 8431516 - Start*/
2018: ln_tot_tds_amt := ln_tot_tds_amt + ln_amt_tds_inv_generated_si;
2019: ln_tot_appln_amt := ln_tot_appln_amt + ln_tds_application_amt;

Line 2016: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tds_application_amt :' || ln_tds_application_amt);

2012: close c_get_amt_tds_inv_generated_si;
2013: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','p_invoice_id :' || p_invoice_id);
2014: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','get_si_det.tax_dist :' || get_si_det.tax_dist);
2015: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_amt_tds_inv_generated_si :' || ln_amt_tds_inv_generated_si);
2016: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tds_application_amt :' || ln_tds_application_amt);
2017: /*Bug 8431516 - Start*/
2018: ln_tot_tds_amt := ln_tot_tds_amt + ln_amt_tds_inv_generated_si;
2019: ln_tot_appln_amt := ln_tot_appln_amt + ln_tds_application_amt;
2020: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_tds_amt :' || ln_tot_tds_amt);

Line 2020: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_tds_amt :' || ln_tot_tds_amt);

2016: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tds_application_amt :' || ln_tds_application_amt);
2017: /*Bug 8431516 - Start*/
2018: ln_tot_tds_amt := ln_tot_tds_amt + ln_amt_tds_inv_generated_si;
2019: ln_tot_appln_amt := ln_tot_appln_amt + ln_tds_application_amt;
2020: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_tds_amt :' || ln_tot_tds_amt);
2021: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_appln_amt :' || ln_tot_appln_amt);
2022: if p_event = 'INSERT' then
2023: update jai_ap_tds_prepayments
2024: set tds_threshold_trx_id_apply = -999

Line 2021: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_appln_amt :' || ln_tot_appln_amt);

2017: /*Bug 8431516 - Start*/
2018: ln_tot_tds_amt := ln_tot_tds_amt + ln_amt_tds_inv_generated_si;
2019: ln_tot_appln_amt := ln_tot_appln_amt + ln_tds_application_amt;
2020: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_tds_amt :' || ln_tot_tds_amt);
2021: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_appln_amt :' || ln_tot_appln_amt);
2022: if p_event = 'INSERT' then
2023: update jai_ap_tds_prepayments
2024: set tds_threshold_trx_id_apply = -999
2025: where tds_prepayment_id = get_si_det.tds_prepayment_id; --Bug 6031679

Line 2023: update jai_ap_tds_prepayments

2019: ln_tot_appln_amt := ln_tot_appln_amt + ln_tds_application_amt;
2020: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_tds_amt :' || ln_tot_tds_amt);
2021: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg','ln_tot_appln_amt :' || ln_tot_appln_amt);
2022: if p_event = 'INSERT' then
2023: update jai_ap_tds_prepayments
2024: set tds_threshold_trx_id_apply = -999
2025: where tds_prepayment_id = get_si_det.tds_prepayment_id; --Bug 6031679
2026: end if;
2027: /*Bug 8431516 - End*/

Line 2028: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_amt_tds_inv_generated_si :'||ln_amt_tds_inv_generated_si);

2024: set tds_threshold_trx_id_apply = -999
2025: where tds_prepayment_id = get_si_det.tds_prepayment_id; --Bug 6031679
2026: end if;
2027: /*Bug 8431516 - End*/
2028: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_amt_tds_inv_generated_si :'||ln_amt_tds_inv_generated_si);
2029: IF ln_amt_tds_inv_generated_si > 0 THEN
2030: IF lv_application_basis = 'STANDARD INVOICE' THEN
2031: /* get the standard invoice number */
2032: OPEN c_si_ap_invoices_all(p_invoice_id);

Line 2049: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_invoice_num_prepay_apply :'||lv_invoice_num_prepay_apply);

2045: /*Bug 8606302 - End*/
2046: END IF ; /* lv_application_basis*/
2047: end if; /* if ln_amt_tds_inv_generated_si > 0 then */
2048: end if ;
2049: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_invoice_num_prepay_apply :'||lv_invoice_num_prepay_apply);
2050: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_parent_invoice_id :'||ln_parent_invoice_id);
2051: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' get_tds_threshold_slab :p_prepay_distribution_id :'||p_prepay_distribution_id);
2052:
2053: --Call to procedure - get_tds_threshold_slab. Store the current Threshold slab and type After PP application

Line 2050: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_parent_invoice_id :'||ln_parent_invoice_id);

2046: END IF ; /* lv_application_basis*/
2047: end if; /* if ln_amt_tds_inv_generated_si > 0 then */
2048: end if ;
2049: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_invoice_num_prepay_apply :'||lv_invoice_num_prepay_apply);
2050: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_parent_invoice_id :'||ln_parent_invoice_id);
2051: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' get_tds_threshold_slab :p_prepay_distribution_id :'||p_prepay_distribution_id);
2052:
2053: --Call to procedure - get_tds_threshold_slab. Store the current Threshold slab and type After PP application
2054: jai_ap_tds_generation_pkg.get_tds_threshold_slab(

Line 2051: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' get_tds_threshold_slab :p_prepay_distribution_id :'||p_prepay_distribution_id);

2047: end if; /* if ln_amt_tds_inv_generated_si > 0 then */
2048: end if ;
2049: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_invoice_num_prepay_apply :'||lv_invoice_num_prepay_apply);
2050: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_parent_invoice_id :'||ln_parent_invoice_id);
2051: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' get_tds_threshold_slab :p_prepay_distribution_id :'||p_prepay_distribution_id);
2052:
2053: --Call to procedure - get_tds_threshold_slab. Store the current Threshold slab and type After PP application
2054: jai_ap_tds_generation_pkg.get_tds_threshold_slab(
2055: p_prepay_distribution_id => p_prepay_distribution_id,

Line 2063: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_grp_id :'||ln_temp_threshold_grp_id);

2059: p_threshold_type => lv_after_threshold_type,
2060: p_process_flag => p_process_flag,
2061: p_process_message => p_process_message,
2062: p_codepath => p_codepath);
2063: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_grp_id :'||ln_temp_threshold_grp_id);
2064: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_hdr_id :'||ln_temp_threshold_hdr_id);
2065: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_after_threshold_slab_id :'||ln_after_threshold_slab_id);
2066: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_after_threshold_type :'||lv_after_threshold_type);
2067: IF p_process_flag = 'E' THEN

Line 2064: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_hdr_id :'||ln_temp_threshold_hdr_id);

2060: p_process_flag => p_process_flag,
2061: p_process_message => p_process_message,
2062: p_codepath => p_codepath);
2063: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_grp_id :'||ln_temp_threshold_grp_id);
2064: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_hdr_id :'||ln_temp_threshold_hdr_id);
2065: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_after_threshold_slab_id :'||ln_after_threshold_slab_id);
2066: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_after_threshold_type :'||lv_after_threshold_type);
2067: IF p_process_flag = 'E' THEN
2068: goto exit_from_procedure;

Line 2065: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_after_threshold_slab_id :'||ln_after_threshold_slab_id);

2061: p_process_message => p_process_message,
2062: p_codepath => p_codepath);
2063: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_grp_id :'||ln_temp_threshold_grp_id);
2064: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_hdr_id :'||ln_temp_threshold_hdr_id);
2065: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_after_threshold_slab_id :'||ln_after_threshold_slab_id);
2066: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_after_threshold_type :'||lv_after_threshold_type);
2067: IF p_process_flag = 'E' THEN
2068: goto exit_from_procedure;
2069: END IF;

Line 2066: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_after_threshold_type :'||lv_after_threshold_type);

2062: p_codepath => p_codepath);
2063: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_grp_id :'||ln_temp_threshold_grp_id);
2064: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_temp_threshold_hdr_id :'||ln_temp_threshold_hdr_id);
2065: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' ln_after_threshold_slab_id :'||ln_after_threshold_slab_id);
2066: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg',' lv_after_threshold_type :'||lv_after_threshold_type);
2067: IF p_process_flag = 'E' THEN
2068: goto exit_from_procedure;
2069: END IF;
2070:

Line 2098: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of dist id '|| p_invoice_distribution_id);

2094: fnd_file.put_line(FND_FILE.log, ' value of dist id '|| p_invoice_distribution_id);
2095: fnd_file.put_line(FND_FILE.log, ' value of prepay dist id '|| p_prepay_distribution_id);
2096: fnd_file.put_line(FND_FILE.log, ' value of invoice id '|| ln_parent_invoice_id);
2097: fnd_file.put_line(FND_FILE.log, ' value of invoice num '||lv_invoice_num_prepay_apply);
2098: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of dist id '|| p_invoice_distribution_id);
2099: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of prepay dist id '|| p_prepay_distribution_id);
2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice id '|| ln_parent_invoice_id);
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice num '||lv_invoice_num_prepay_apply);
2102:

Line 2099: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of prepay dist id '|| p_prepay_distribution_id);

2095: fnd_file.put_line(FND_FILE.log, ' value of prepay dist id '|| p_prepay_distribution_id);
2096: fnd_file.put_line(FND_FILE.log, ' value of invoice id '|| ln_parent_invoice_id);
2097: fnd_file.put_line(FND_FILE.log, ' value of invoice num '||lv_invoice_num_prepay_apply);
2098: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of dist id '|| p_invoice_distribution_id);
2099: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of prepay dist id '|| p_prepay_distribution_id);
2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice id '|| ln_parent_invoice_id);
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice num '||lv_invoice_num_prepay_apply);
2102:
2103: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before threshold type '||lv_threshold_type);

Line 2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice id '|| ln_parent_invoice_id);

2096: fnd_file.put_line(FND_FILE.log, ' value of invoice id '|| ln_parent_invoice_id);
2097: fnd_file.put_line(FND_FILE.log, ' value of invoice num '||lv_invoice_num_prepay_apply);
2098: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of dist id '|| p_invoice_distribution_id);
2099: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of prepay dist id '|| p_prepay_distribution_id);
2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice id '|| ln_parent_invoice_id);
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice num '||lv_invoice_num_prepay_apply);
2102:
2103: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before threshold type '||lv_threshold_type);
2104: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after threshold type '||lv_after_threshold_type);

Line 2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice num '||lv_invoice_num_prepay_apply);

2097: fnd_file.put_line(FND_FILE.log, ' value of invoice num '||lv_invoice_num_prepay_apply);
2098: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of dist id '|| p_invoice_distribution_id);
2099: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of prepay dist id '|| p_prepay_distribution_id);
2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice id '|| ln_parent_invoice_id);
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice num '||lv_invoice_num_prepay_apply);
2102:
2103: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before threshold type '||lv_threshold_type);
2104: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after threshold type '||lv_after_threshold_type);
2105: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before slab '||ln_threshold_slab_id);

Line 2103: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before threshold type '||lv_threshold_type);

2099: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of prepay dist id '|| p_prepay_distribution_id);
2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice id '|| ln_parent_invoice_id);
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice num '||lv_invoice_num_prepay_apply);
2102:
2103: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before threshold type '||lv_threshold_type);
2104: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after threshold type '||lv_after_threshold_type);
2105: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before slab '||ln_threshold_slab_id);
2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after slab '||ln_after_threshold_slab_id);
2107: if p_event = 'INSERT' then /*Bug 8431516*/

Line 2104: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after threshold type '||lv_after_threshold_type);

2100: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice id '|| ln_parent_invoice_id);
2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice num '||lv_invoice_num_prepay_apply);
2102:
2103: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before threshold type '||lv_threshold_type);
2104: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after threshold type '||lv_after_threshold_type);
2105: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before slab '||ln_threshold_slab_id);
2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after slab '||ln_after_threshold_slab_id);
2107: if p_event = 'INSERT' then /*Bug 8431516*/
2108: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' ln_tot_appln_amt:'||ln_tot_appln_amt);

Line 2105: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before slab '||ln_threshold_slab_id);

2101: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of invoice num '||lv_invoice_num_prepay_apply);
2102:
2103: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before threshold type '||lv_threshold_type);
2104: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after threshold type '||lv_after_threshold_type);
2105: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before slab '||ln_threshold_slab_id);
2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after slab '||ln_after_threshold_slab_id);
2107: if p_event = 'INSERT' then /*Bug 8431516*/
2108: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' ln_tot_appln_amt:'||ln_tot_appln_amt);
2109: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_threshold_grp_id:'||ln_threshold_grp_id);

Line 2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after slab '||ln_after_threshold_slab_id);

2102:
2103: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before threshold type '||lv_threshold_type);
2104: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after threshold type '||lv_after_threshold_type);
2105: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before slab '||ln_threshold_slab_id);
2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after slab '||ln_after_threshold_slab_id);
2107: if p_event = 'INSERT' then /*Bug 8431516*/
2108: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' ln_tot_appln_amt:'||ln_tot_appln_amt);
2109: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_threshold_grp_id:'||ln_threshold_grp_id);
2110: /*Bug 5751783. Changed from invoice_id to ln_parent_invoice_id*/

Line 2108: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' ln_tot_appln_amt:'||ln_tot_appln_amt);

2104: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after threshold type '||lv_after_threshold_type);
2105: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before slab '||ln_threshold_slab_id);
2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after slab '||ln_after_threshold_slab_id);
2107: if p_event = 'INSERT' then /*Bug 8431516*/
2108: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' ln_tot_appln_amt:'||ln_tot_appln_amt);
2109: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_threshold_grp_id:'||ln_threshold_grp_id);
2110: /*Bug 5751783. Changed from invoice_id to ln_parent_invoice_id*/
2111: jai_ap_tds_generation_pkg.generate_tds_invoices
2112: (

Line 2109: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_threshold_grp_id:'||ln_threshold_grp_id);

2105: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of before slab '||ln_threshold_slab_id);
2106: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' value of after slab '||ln_after_threshold_slab_id);
2107: if p_event = 'INSERT' then /*Bug 8431516*/
2108: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', ' ln_tot_appln_amt:'||ln_tot_appln_amt);
2109: jai_cmn_utils_pkg.write_fnd_log_msg('jai_ap_tds_prepayments_pkg', 'ln_threshold_grp_id:'||ln_threshold_grp_id);
2110: /*Bug 5751783. Changed from invoice_id to ln_parent_invoice_id*/
2111: jai_ap_tds_generation_pkg.generate_tds_invoices
2112: (
2113: pn_invoice_id => ln_parent_invoice_id,

Line 2160: /* Update jai_ap_tds_prepayments with threshold_trx_id_apply*/

2156: IF p_process_flag = 'E' THEN
2157: GOTO exit_from_procedure;
2158: END IF;
2159:
2160: /* Update jai_ap_tds_prepayments with threshold_trx_id_apply*/
2161: -- Update each distribution with the threshold grp id as
2162: -- it may vary depending on the date and the group.
2163: -- changed invoice_distribution_id_prepay to invoice_distribution_id.
2164: update jai_ap_tds_prepayments

Line 2164: update jai_ap_tds_prepayments

2160: /* Update jai_ap_tds_prepayments with threshold_trx_id_apply*/
2161: -- Update each distribution with the threshold grp id as
2162: -- it may vary depending on the date and the group.
2163: -- changed invoice_distribution_id_prepay to invoice_distribution_id.
2164: update jai_ap_tds_prepayments
2165: set tds_threshold_trx_id_apply = ln_threshold_trx_id_tds
2166: where tds_threshold_trx_id_apply = -999
2167: and invoice_id = p_invoice_id
2168: and invoice_distribution_id_prepay = p_invoice_distribution_id; /*Bug 6363056*/

Line 2254: update jai_ap_tds_prepayments

2250: if p_process_flag = 'E' then
2251: goto exit_from_procedure;
2252: end if;
2253:
2254: update jai_ap_tds_prepayments
2255: set wct_threshold_trx_id_apply = ln_threshold_trx_id_wct
2256: where invoice_id = p_invoice_id
2257: and invoice_distribution_id_prepay = p_invoice_distribution_id
2258: and wct_applicable_flag = 'Y';

Line 2313: update jai_ap_tds_prepayments

2309: if p_process_flag = 'E' then
2310: goto exit_from_procedure;
2311: end if;
2312:
2313: update jai_ap_tds_prepayments
2314: set essi_threshold_trx_id_apply = ln_threshold_trx_id_essi
2315: where invoice_id = p_invoice_id
2316: and invoice_distribution_id_prepay = p_invoice_distribution_id
2317: and essi_applicable_flag = 'Y';

Line 2619: end jai_ap_tds_prepayments_pkg;

2615: end process_old_transaction;
2616:
2617: /* **************************************** process_old_transaction **************************************** */
2618:
2619: end jai_ap_tds_prepayments_pkg;