DBA Data[Home] [Help]

APPS.OKL_CREATE_DISB_TRANS_PVT dependencies on FND_SEQNUM

Line 147: x_tapv_rec.invoice_number := fnd_seqnum.get_next_sequence

143: --
144: -- display specific application error if 'OKL Lease Pay Invoices' has not been setup or setup incorrectly
145: --
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',

Line 467: l_tapv_rec.invoice_number := fnd_seqnum.get_next_sequence

463:
464: l_okl_application_id := nvl(l_application_id,540);
465:
466: IF (NVL(l_tapv_rec.invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
467: l_tapv_rec.invoice_number := fnd_seqnum.get_next_sequence
468: (appid => l_okl_application_id,
469: cat_code => l_document_category,
470: sobid => l_tapv_rec.set_of_books_id, -- | 28-Sep-07 cklee -- Fixed bug:6457524 set_of_book_id is missing issue |
471: met_code => 'A',

Line 480: l_tapv_rec.vendor_invoice_number := fnd_seqnum.get_next_sequence

476: l_tapv_rec.vendor_invoice_number := l_tapv_rec.invoice_number;
477: END IF;
478: ELSE
479: IF (NVL(l_tapv_rec.vendor_invoice_number,okl_api.g_miss_char) = okl_api.g_miss_char) THEN
480: l_tapv_rec.vendor_invoice_number := fnd_seqnum.get_next_sequence
481: (appid => l_okl_application_id,
482: cat_code => l_document_category,
483: sobid => l_tapv_rec.set_of_books_id,
484: met_code => 'A',

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;