DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_TRX_MSGS_PUB

Line 396: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;

392: WHERE TMG.trx_id = p_trx_id
393: AND TMG.tmg_run IS NULL;
394:
395: l_last_run NUMBER;
396: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
397: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
398:
399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
400:

Line 397: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;

393: AND TMG.tmg_run IS NULL;
394:
395: l_last_run NUMBER;
396: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
397: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
398:
399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
400:
401: l_api_version CONSTANT NUMBER := 1;

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

441: -- Update the TMG_RUN of OKL_TRX_MSGS with l_last_run+1 for the TRX_ID with null TMG_RUN
442: IF (lp_tmgv_tbl.COUNT > 0) THEN
443:
444: IF (is_debug_statement_on) THEN
445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');
446: END IF;
447: OKL_TRX_MSGS_PUB.update_trx_msgs (
448: p_api_version => l_api_version,
449: p_init_msg_list => OKL_API.G_FALSE,

Line 447: OKL_TRX_MSGS_PUB.update_trx_msgs (

443:
444: IF (is_debug_statement_on) THEN
445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');
446: END IF;
447: OKL_TRX_MSGS_PUB.update_trx_msgs (
448: p_api_version => l_api_version,
449: p_init_msg_list => OKL_API.G_FALSE,
450: x_return_status => l_return_status,
451: x_msg_count => l_msg_count,

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

452: x_msg_data => l_msg_data,
453: p_tmgv_tbl => lp_tmgv_tbl,
454: x_tmgv_tbl => lx_tmgv_tbl);
455: IF (is_debug_statement_on) THEN
456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_MSGS_PUB.update_trx_msgs , return status: ' || l_return_status);
457: END IF;
458:
459: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;