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_CMN_UTILS_PKG

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 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 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 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 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 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 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 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 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,