DBA Data[Home] [Help]

APPS.OKL_CREATE_DISB_TRANS_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 112: x_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id;--l_set_of_books_id;

108: */
109:
110: IF (p_tapv_rec.SET_OF_BOOKS_ID is null or
111: p_tapv_rec.SET_OF_BOOKS_ID = OKL_API.G_MISS_NUM) THEN
112: x_tapv_rec.SET_OF_BOOKS_ID := OKL_ACCOUNTING_UTIL.get_set_of_books_id;--l_set_of_books_id;
113: END IF;
114: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
115: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.SET_OF_BOOKS_ID:' || x_tapv_rec.SET_OF_BOOKS_ID);
116: END IF;

Line 150: sobid => OKL_ACCOUNTING_UTIL.get_set_of_books_id,--l_set_of_books_id,

146: BEGIN
147: x_tapv_rec.invoice_number := fnd_seqnum.get_next_sequence
148: (appid => l_okl_application_id,
149: cat_code => l_document_category,
150: sobid => OKL_ACCOUNTING_UTIL.get_set_of_books_id,--l_set_of_books_id,
151: met_code => 'A',
152: trx_date => SYSDATE,
153: dbseqnm => lx_dbseqnm,
154: dbseqid => lx_dbseqid);

Line 577: IF (l_tapv_rec.currency_code = okl_accounting_util.get_func_curr_code) THEN

573: END IF;
574:
575: --Handle Currency Conversion Rate
576: IF l_tapv_rec.currency_conversion_type = 'User' THEN
577: IF (l_tapv_rec.currency_code = okl_accounting_util.get_func_curr_code) THEN
578: l_tapv_rec.currency_conversion_rate := 1;
579: ELSE
580: IF NVL(l_tapv_rec.currency_conversion_rate,okl_api.g_miss_num) = okl_api.g_miss_num THEN
581: l_tapv_rec.currency_conversion_rate := l_currency_conversion_rate;

Line 719: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: before OKL_ACCOUNTING_UTIL.round_amount');

715:
716: END IF;
717:
718: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
719: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: before OKL_ACCOUNTING_UTIL.round_amount');
720: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tapv_rec.amount' || l_tapv_rec.amount);
721: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tapv_rec.currency_code' || l_tapv_rec.currency_code);
722: END IF;
723: --Rounding the amount

Line 724: l_tapv_rec.amount := OKL_ACCOUNTING_UTIL.round_amount(l_tapv_rec.amount, l_tapv_rec.currency_code);

720: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tapv_rec.amount' || l_tapv_rec.amount);
721: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tapv_rec.currency_code' || l_tapv_rec.currency_code);
722: END IF;
723: --Rounding the amount
724: l_tapv_rec.amount := OKL_ACCOUNTING_UTIL.round_amount(l_tapv_rec.amount, l_tapv_rec.currency_code);
725: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
726: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: after OKL_ACCOUNTING_UTIL.round_amount');
727: END IF;
728: --start: 5/18/2007 cklee added rounding logc for line's amount

Line 726: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: after OKL_ACCOUNTING_UTIL.round_amount');

722: END IF;
723: --Rounding the amount
724: l_tapv_rec.amount := OKL_ACCOUNTING_UTIL.round_amount(l_tapv_rec.amount, l_tapv_rec.currency_code);
725: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
726: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: after OKL_ACCOUNTING_UTIL.round_amount');
727: END IF;
728: --start: 5/18/2007 cklee added rounding logc for line's amount
729: cnt := l_tplv_tbl.FIRST;
730: LOOP

Line 732: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: before OKL_ACCOUNTING_UTIL.round_amount');

728: --start: 5/18/2007 cklee added rounding logc for line's amount
729: cnt := l_tplv_tbl.FIRST;
730: LOOP
731: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
732: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: before OKL_ACCOUNTING_UTIL.round_amount');
733: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tplv_tbl(cnt)' || cnt);
734: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tplv_tbl(cnt).amount' || l_tplv_tbl(cnt).amount);
735: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tapv_rec.currency_code' || l_tapv_rec.currency_code);
736: END IF;

Line 738: l_tplv_tbl(cnt).amount := OKL_ACCOUNTING_UTIL.round_amount(l_tplv_tbl(cnt).amount, l_tapv_rec.currency_code);

734: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tplv_tbl(cnt).amount' || l_tplv_tbl(cnt).amount);
735: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_tapv_rec.currency_code' || l_tapv_rec.currency_code);
736: END IF;
737: --Rounding the amount
738: l_tplv_tbl(cnt).amount := OKL_ACCOUNTING_UTIL.round_amount(l_tplv_tbl(cnt).amount, l_tapv_rec.currency_code);
739: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
740: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: after OKL_ACCOUNTING_UTIL.round_amount');
741: END IF;
742: EXIT WHEN cnt = l_tplv_tbl.LAST;

Line 740: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: after OKL_ACCOUNTING_UTIL.round_amount');

736: END IF;
737: --Rounding the amount
738: l_tplv_tbl(cnt).amount := OKL_ACCOUNTING_UTIL.round_amount(l_tplv_tbl(cnt).amount, l_tapv_rec.currency_code);
739: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
740: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: after OKL_ACCOUNTING_UTIL.round_amount');
741: END IF;
742: EXIT WHEN cnt = l_tplv_tbl.LAST;
743: cnt := l_tplv_tbl.NEXT(cnt);
744: END LOOP;

Line 990: IF (l_dist_info_rec.currency_code = okl_accounting_util.get_func_curr_code) THEN

986: END IF;
987:
988:
989: IF (l_dist_info_rec.currency_conversion_type = 'User') THEN
990: IF (l_dist_info_rec.currency_code = okl_accounting_util.get_func_curr_code) THEN
991: l_dist_info_rec.currency_conversion_rate := 1;
992: ELSE
993: IF (NVL(l_tapv_rec.currency_conversion_rate, okl_api.g_miss_num) = okl_api.g_miss_num) THEN
994: l_dist_info_rec.currency_conversion_rate := l_currency_conversion_rate;

Line 1000: l_dist_info_rec.currency_conversion_rate := okl_accounting_util.get_curr_con_rate

996: l_dist_info_rec.currency_conversion_rate := l_tapv_rec.currency_conversion_rate;
997: END IF;
998: END IF;
999: ELSIF (l_dist_info_rec.currency_conversion_type = 'Spot' OR l_dist_info_rec.currency_conversion_type = 'Corporate') THEN
1000: l_dist_info_rec.currency_conversion_rate := okl_accounting_util.get_curr_con_rate
1001: (p_from_curr_code => l_dist_info_rec.currency_code,
1002: p_to_curr_code => okl_accounting_util.get_func_curr_code,
1003: p_con_date => l_dist_info_rec.currency_conversion_date,
1004: p_con_type => l_dist_info_rec.currency_conversion_type);

Line 1002: p_to_curr_code => okl_accounting_util.get_func_curr_code,

998: END IF;
999: ELSIF (l_dist_info_rec.currency_conversion_type = 'Spot' OR l_dist_info_rec.currency_conversion_type = 'Corporate') THEN
1000: l_dist_info_rec.currency_conversion_rate := okl_accounting_util.get_curr_con_rate
1001: (p_from_curr_code => l_dist_info_rec.currency_code,
1002: p_to_curr_code => okl_accounting_util.get_func_curr_code,
1003: p_con_date => l_dist_info_rec.currency_conversion_date,
1004: p_con_type => l_dist_info_rec.currency_conversion_type);
1005: END IF;
1006:

Line 1165: IF (l_dist_info_tbl(cnt).currency_code = okl_accounting_util.get_func_curr_code) THEN

1161: l_dist_info_tbl(cnt).currency_conversion_date := l_currency_conversion_date;
1162: END IF;
1163:
1164: IF (l_dist_info_tbl(cnt).currency_conversion_type = 'User') THEN
1165: IF (l_dist_info_tbl(cnt).currency_code = okl_accounting_util.get_func_curr_code) THEN
1166: l_dist_info_tbl(cnt).currency_conversion_rate := 1;
1167: ELSE
1168: IF (NVL(l_tapv_rec.currency_conversion_rate, okl_api.g_miss_num) = okl_api.g_miss_num) THEN
1169: l_dist_info_tbl(cnt).currency_conversion_rate := l_currency_conversion_rate;

Line 1175: l_dist_info_tbl(cnt).currency_conversion_rate := okl_accounting_util.get_curr_con_rate

1171: l_dist_info_tbl(cnt).currency_conversion_rate := l_tapv_rec.currency_conversion_rate;
1172: END IF;
1173: END IF;
1174: ELSIF (l_dist_info_tbl(cnt).currency_conversion_type = 'Spot' OR l_dist_info_tbl(cnt).currency_conversion_type = 'Corporate') THEN
1175: l_dist_info_tbl(cnt).currency_conversion_rate := okl_accounting_util.get_curr_con_rate
1176: (p_from_curr_code => l_dist_info_tbl(cnt).currency_code,
1177: p_to_curr_code => okl_accounting_util.get_func_curr_code,
1178: p_con_date => l_dist_info_tbl(cnt).currency_conversion_date,
1179: p_con_type => l_dist_info_tbl(cnt).currency_conversion_type);

Line 1177: p_to_curr_code => okl_accounting_util.get_func_curr_code,

1173: END IF;
1174: ELSIF (l_dist_info_tbl(cnt).currency_conversion_type = 'Spot' OR l_dist_info_tbl(cnt).currency_conversion_type = 'Corporate') THEN
1175: l_dist_info_tbl(cnt).currency_conversion_rate := okl_accounting_util.get_curr_con_rate
1176: (p_from_curr_code => l_dist_info_tbl(cnt).currency_code,
1177: p_to_curr_code => okl_accounting_util.get_func_curr_code,
1178: p_con_date => l_dist_info_tbl(cnt).currency_conversion_date,
1179: p_con_type => l_dist_info_tbl(cnt).currency_conversion_type);
1180: END IF;
1181: