[Home] [Help]
136: ln_prepay_apply_trx_id number;
137: /*Bug 5751783 - End*/
138: begin
139:
140: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_prepayment', 'START'); /* 1 */
141: if p_prepay_amount < 0 then
142:
143: /* Event is APPLY of prepayment */
144: /* Comment out the jai_ap_tds_prepayments_pkg.allocate_prepayment with new procedure
289: end if;
290:
291:
292: << exit_from_procedure >>
293: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 100 */
294: return;
295:
296: exception
297: when others then
508: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Chong.Lei for bug#13787158
509: l_api_name CONSTANT VARCHAR2(50) := 'process_unapply()';
510: begin
511: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
512: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */
513: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Chong.Lei for bug#13787158
514:
515: open c_gl_sets_of_books(p_set_of_books_id);
516: fetch c_gl_sets_of_books into r_gl_sets_of_books;
517: close c_gl_sets_of_books;
518:
519: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
520: /* Foreign currency invoice */
521: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
522: ln_exchange_rate := p_exchange_rate;
523: end if;
524:
525: ln_exchange_rate := nvl(ln_exchange_rate, 1);
1014:
1015: end if;
1016:
1017: << exit_from_procedure >>
1018: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 100 */
1019: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
1020: return;
1021:
1022: exception
1072: lv_reversal_flag varchar2(1); \*Bug 8431516*\
1073:
1074: begin
1075:
1076: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.allocate_prepayment', 'START'); \* 1 *\
1077:
1078: ln_remaining_prepayment_amount := abs(p_prepay_amount); \* Apply amount is negative *\
1079:
1080: \* Loop through to get the taxable basis for each line in jai_ap_tds_inv_taxes *\
1152: end loop; \* cur_si_distributions_rec in c_jai_ap_tds_inv_taxes *\
1153:
1154:
1155: << exit_from_procedure >>
1156: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); \* 100 *\
1157: return;
1158:
1159: exception
1160: when others then
1244:
1245:
1246: begin
1247:
1248: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.populate_section_tax', 'START'); \* 1 *\
1249:
1250: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1251:
1252: \*
1368: end loop; \* cur_rec_pp_allocations *\
1369:
1370:
1371: << exit_from_procedure >>
1372: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); \* 100 *\
1373: return;
1374:
1375: exception
1376: when others then
1631:
1632:
1633: begin
1634:
1635: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_tds_invoices', 'START'); \* 1 *\
1636:
1637: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id); -- Added by Jia for FP bug6929483
1638:
1639: open c_gl_sets_of_books(p_set_of_books_id);
1641: close c_gl_sets_of_books;
1642:
1643: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
1644: \* Foreign currency invoice *\
1645: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); \* 6.1 *\
1646: ln_exchange_rate := p_exchange_rate;
1647: end if;
1648:
1649: ln_exchange_rate := nvl(ln_exchange_rate, 1);
2309:
2310: end if;
2311:
2312: << exit_from_procedure >>
2313: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); \* 100 *\
2314: return;
2315:
2316: exception
2317: when others then
3241:
3242: begin
3243: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
3244:
3245: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_tds_prepayemnts_pkg.generate_rtn', 'START'); /* 1 */
3246:
3247: get_prepay_invoice_id(p_prepay_distribution_id,pre_pay_inv_id);
3248:
3249: open c_gl_sets_of_books(p_set_of_books_id);
3251: close c_gl_sets_of_books;
3252:
3253: if r_gl_sets_of_books.currency_code <> p_invoice_currency_code then
3254: /* Foreign currency invoice */
3255: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
3256: ln_exchange_rate := p_exchange_rate;
3257: end if;
3258:
3259: ln_exchange_rate := nvl(ln_exchange_rate, 1);
4032:
4033: end if;
4034:
4035: << exit_from_procedure >>
4036: p_codepath := jai_general_pkg.plot_codepath(100, p_codepath, null, 'END'); /* 100 */
4037: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.END', G_PKG_NAME || ': '||l_api_name||'()-');
4038:
4039: return;
4040: