DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_TRX_MSGS_PUB

Line 418: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;

414: WHERE TMG.trx_id = p_trx_id
415: AND TMG.tmg_run IS NULL;
416:
417: l_last_run NUMBER;
418: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
419: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
420:
421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
422:

Line 419: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;

415: AND TMG.tmg_run IS NULL;
416:
417: l_last_run NUMBER;
418: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
419: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
420:
421: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
422:
423: l_api_version CONSTANT NUMBER := 1;

Line 467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');

463: -- Update the TMG_RUN of OKL_TRX_MSGS with l_last_run+1 for the TRX_ID with null TMG_RUN
464: IF (lp_tmgv_tbl.COUNT > 0) THEN
465:
466: IF (is_debug_statement_on) THEN
467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');
468: END IF;
469: OKL_TRX_MSGS_PUB.update_trx_msgs (
470: p_api_version => l_api_version,
471: p_init_msg_list => OKL_API.G_FALSE,

Line 469: OKL_TRX_MSGS_PUB.update_trx_msgs (

465:
466: IF (is_debug_statement_on) THEN
467: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');
468: END IF;
469: OKL_TRX_MSGS_PUB.update_trx_msgs (
470: p_api_version => l_api_version,
471: p_init_msg_list => OKL_API.G_FALSE,
472: x_return_status => l_return_status,
473: x_msg_count => l_msg_count,

Line 478: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_MSGS_PUB.update_trx_msgs , return status: ' || l_return_status);

474: x_msg_data => l_msg_data,
475: p_tmgv_tbl => lp_tmgv_tbl,
476: x_tmgv_tbl => lx_tmgv_tbl);
477: IF (is_debug_statement_on) THEN
478: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_MSGS_PUB.update_trx_msgs , return status: ' || l_return_status);
479: END IF;
480:
481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;