DBA Data[Home] [Help]

APPS.OKL_CREATE_DISB_TRANS_PVT dependencies on OKL_CREATE_DISB_TRANS_PVT

Line 1: PACKAGE BODY OKL_CREATE_DISB_TRANS_PVT AS

1: PACKAGE BODY OKL_CREATE_DISB_TRANS_PVT AS
2: /* $Header: OKLRCDTB.pls 120.13 2007/12/11 20:08:56 cklee noship $ */
3:
4: -- Start of wraper code generated automatically by Debug code generator
5: G_MODULE VARCHAR2(40) := 'LEASE.DISBURSEMENTS';

Line 90: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs begin');

86: */
87: BEGIN
88:
89: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
90: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs begin');
91: END IF;
92:
93: -- assgin to OUT always
94: x_tapv_rec := p_tapv_rec;

Line 100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.payment_method_code:' || x_tapv_rec.payment_method_code);

96: p_tapv_rec.payment_method_code = OKL_API.G_MISS_CHAR) THEN
97: x_tapv_rec.payment_method_code := 'CHECK'; -- set default value
98: END IF;
99: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.payment_method_code:' || x_tapv_rec.payment_method_code);
101: END IF;
102:
103: /*
104: -- 1. SET_OF_BOOKS_ID

Line 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);

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;
117: -- 2. IPPT_ID
118: -- cklee 05/04/2004
119: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.IPPT_ID:' || p_tapv_rec.IPPT_ID);

116: END IF;
117: -- 2. IPPT_ID
118: -- cklee 05/04/2004
119: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.IPPT_ID:' || p_tapv_rec.IPPT_ID);
121: END IF;
122: IF (p_tapv_rec.IPPT_ID IS NULL or
123: p_tapv_rec.IPPT_ID = OKL_API.G_MISS_NUM) THEN
124:

Line 133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.IPPT_ID:' || x_tapv_rec.IPPT_ID);

129: x_tapv_rec.IPPT_ID := l_terms_id;
130:
131: END IF;
132: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
133: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.IPPT_ID:' || x_tapv_rec.IPPT_ID);
134: END IF;
135:
136: -- 3. INVOICE_NUMBER
137: /*

Line 175: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.NETTABLE_YN:' || x_tapv_rec.NETTABLE_YN);

171: p_tapv_rec.NETTABLE_YN = OKL_API.G_MISS_CHAR) THEN
172: x_tapv_rec.NETTABLE_YN := 'N';
173: END IF;
174: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
175: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.NETTABLE_YN:' || x_tapv_rec.NETTABLE_YN);
176: END IF;
177:
178: -- 5. PAY_GROUP_LOOKUP_CODE
179: -- cklee 05/04/2004

Line 181: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.PAY_GROUP_LOOKUP_CODE:' || p_tapv_rec.PAY_GROUP_LOOKUP_CODE);

177:
178: -- 5. PAY_GROUP_LOOKUP_CODE
179: -- cklee 05/04/2004
180: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
181: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.PAY_GROUP_LOOKUP_CODE:' || p_tapv_rec.PAY_GROUP_LOOKUP_CODE);
182: END IF;
183:
184: IF (p_tapv_rec.PAY_GROUP_LOOKUP_CODE IS NULL or
185: p_tapv_rec.PAY_GROUP_LOOKUP_CODE = OKL_API.G_MISS_CHAR) THEN

Line 196: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.PAY_GROUP_LOOKUP_CODE:' || x_tapv_rec.PAY_GROUP_LOOKUP_CODE);

192: x_tapv_rec.PAY_GROUP_LOOKUP_CODE := l_pay_group_lookup_code;
193:
194: END IF;
195: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
196: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.PAY_GROUP_LOOKUP_CODE:' || x_tapv_rec.PAY_GROUP_LOOKUP_CODE);
197: END IF;
198:
199: -- 6. vednor id
200: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 201: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.VENDOR_ID:' || p_tapv_rec.VENDOR_ID);

197: END IF;
198:
199: -- 6. vednor id
200: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
201: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: p_tapv_rec.VENDOR_ID:' || p_tapv_rec.VENDOR_ID);
202: END IF;
203: IF (p_tapv_rec.VENDOR_ID is null or
204: p_tapv_rec.VENDOR_ID = OKL_API.G_MISS_NUM) THEN
205:

Line 214: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.VENDOR_ID:' || x_tapv_rec.VENDOR_ID);

210: x_tapv_rec.VENDOR_ID := l_vendor_id;
211:
212: END IF;
213: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
214: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.VENDOR_ID:' || x_tapv_rec.VENDOR_ID);
215: END IF;
216:
217: -- 7. invoice_type
218: -- cklee 05/04/2004

Line 227: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.INVOICE_TYPE:' || x_tapv_rec.INVOICE_TYPE);

223: x_tapv_rec.INVOICE_TYPE := G_STANDARD;
224:
225: END IF;
226: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
227: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.INVOICE_TYPE:' || x_tapv_rec.INVOICE_TYPE);
228: END IF;
229:
230: -- 8. If invoice type is G_STANDARD then invoice amount is positive
231: -- If invoice type is G_CREDIT then the invoice amount is negative.

Line 239: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.AMOUNT:' || x_tapv_rec.AMOUNT);

235: OR(x_tapv_rec.INVOICE_TYPE = G_CREDIT AND x_tapv_rec.AMOUNT > 0))THEN
236: x_tapv_rec.AMOUNT := ((x_tapv_rec.AMOUNT) * (-1));
237: END IF;
238: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
239: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.AMOUNT:' || x_tapv_rec.AMOUNT);
240: END IF;
241:
242: --START:| 11-Dec-07 cklee -- Fixed bug: 6682348 -- stamped request_id when insert |
243: x_tapv_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID;

Line 245: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.REQUEST_ID:' || x_tapv_rec.REQUEST_ID);

241:
242: --START:| 11-Dec-07 cklee -- Fixed bug: 6682348 -- stamped request_id when insert |
243: x_tapv_rec.REQUEST_ID := Fnd_Global.CONC_REQUEST_ID;
244: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
245: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs: x_tapv_rec.REQUEST_ID:' || x_tapv_rec.REQUEST_ID);
246: END IF;
247: --END:| 11-Dec-07 cklee -- Fixed bug: 6682348 -- stamped request_id when insert |
248:
249:

Line 252: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs end');

248:
249:
250:
251: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
252: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.populate_more_attrs end');
253: END IF;
254:
255: RETURN l_return_status;
256: EXCEPTION

Line 451: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: populate_more_attrs raise exception');

447: x_return_status := l_return_status;
448: END IF;
449:
450: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
451: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: populate_more_attrs raise exception');
452: END IF;
453: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
454: END IF;
455: --end:| 11-May-07 cklee -- added defaulted attributes for the following: |

Line 496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence raise exception');

492:
493: OKL_API.Set_Message(p_app_name => G_APP_NAME,
494: p_msg_name => 'OKL_PAY_INV_SEQ_CHECK');
495: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence raise exception');
497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_okl_application_id' || l_okl_application_id);
498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_document_category' || l_document_category);
499: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_tapv_rec.set_of_books_id' || l_tapv_rec.set_of_books_id);
500: END IF;

Line 497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_okl_application_id' || l_okl_application_id);

493: OKL_API.Set_Message(p_app_name => G_APP_NAME,
494: p_msg_name => 'OKL_PAY_INV_SEQ_CHECK');
495: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence raise exception');
497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_okl_application_id' || l_okl_application_id);
498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_document_category' || l_document_category);
499: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_tapv_rec.set_of_books_id' || l_tapv_rec.set_of_books_id);
500: END IF;
501: RAISE OKL_API.G_EXCEPTION_ERROR ;

Line 498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_document_category' || l_document_category);

494: p_msg_name => 'OKL_PAY_INV_SEQ_CHECK');
495: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence raise exception');
497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_okl_application_id' || l_okl_application_id);
498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_document_category' || l_document_category);
499: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_tapv_rec.set_of_books_id' || l_tapv_rec.set_of_books_id);
500: END IF;
501: RAISE OKL_API.G_EXCEPTION_ERROR ;
502:

Line 499: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_tapv_rec.set_of_books_id' || l_tapv_rec.set_of_books_id);

495: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence raise exception');
497: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_okl_application_id' || l_okl_application_id);
498: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_document_category' || l_document_category);
499: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: fnd_seqnum.get_next_sequence: l_tapv_rec.set_of_books_id' || l_tapv_rec.set_of_books_id);
500: END IF;
501: RAISE OKL_API.G_EXCEPTION_ERROR ;
502:
503: END;

Line 535: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_khr_id' || l_khr_id);

531: l_khr_id := l_tplv_tbl(cnt).khr_id;
532: --end:| 11-May-07 cklee -- added defaulted attributes for the following: |
533:
534: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
535: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_khr_id' || l_khr_id);
536: END IF;
537:
538: FOR cur IN l_curr_conv_csr(l_khr_id) LOOP
539: l_currency_code := cur.currency_code;

Line 546: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_code' || l_currency_code);

542: l_currency_conversion_date := cur.currency_conversion_date;
543: l_legal_entity_id := cur.legal_entity_id;
544: END LOOP;
545: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
546: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_code' || l_currency_code);
547: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_type' || l_currency_conversion_type);
548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_rate' || l_currency_conversion_rate);
549: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_date' || l_currency_conversion_date);
550: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_legal_entity_id' || l_legal_entity_id);

Line 547: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_type' || l_currency_conversion_type);

543: l_legal_entity_id := cur.legal_entity_id;
544: END LOOP;
545: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
546: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_code' || l_currency_code);
547: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_type' || l_currency_conversion_type);
548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_rate' || l_currency_conversion_rate);
549: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_date' || l_currency_conversion_date);
550: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_legal_entity_id' || l_legal_entity_id);
551: END IF;

Line 548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_rate' || l_currency_conversion_rate);

544: END LOOP;
545: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
546: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_code' || l_currency_code);
547: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_type' || l_currency_conversion_type);
548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_rate' || l_currency_conversion_rate);
549: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_date' || l_currency_conversion_date);
550: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_legal_entity_id' || l_legal_entity_id);
551: END IF;
552:

Line 549: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_date' || l_currency_conversion_date);

545: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
546: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_code' || l_currency_code);
547: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_type' || l_currency_conversion_type);
548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_rate' || l_currency_conversion_rate);
549: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_date' || l_currency_conversion_date);
550: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_legal_entity_id' || l_legal_entity_id);
551: END IF;
552:
553:

Line 550: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_legal_entity_id' || l_legal_entity_id);

546: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_code' || l_currency_code);
547: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_type' || l_currency_conversion_type);
548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_rate' || l_currency_conversion_rate);
549: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_currency_date' || l_currency_conversion_date);
550: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CREATE_DISB_TRANS_PVT.create_disb_trx: l_legal_entity_id' || l_legal_entity_id);
551: END IF;
552:
553:
554: --start:| 14-Sep-07 cklee -- Restored khr_id back to okl_trx_ap_invs_all_b for the |

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 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);

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
724: l_tapv_rec.amount := OKL_ACCOUNTING_UTIL.round_amount(l_tapv_rec.amount, l_tapv_rec.currency_code);

Line 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);

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

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 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);

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;
737: --Rounding the amount

Line 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);

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;
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);

Line 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);

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

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 1398: END OKL_CREATE_DISB_TRANS_PVT;

1394:
1395: RETURN l_khr_line_amount;
1396: END get_khr_line_amount;
1397:
1398: END OKL_CREATE_DISB_TRANS_PVT;