eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on FND_LOG

Line 500: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,p_proc_name || p_message || 'S' );

496: p_message IN VARCHAR2) IS
497: Begin
498:
499: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
500: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,p_proc_name || p_message || 'S' );
501:
502: END IF;
503: End;
504: --------------------------------------------------------------------------

Line 517: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

513: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'get_first_sel_date';
514:
515: BEGIN
516: IF (G_DEBUG_ENABLED = 'Y') THEN
517: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
518: END IF;
519:
520: x_return_status := OKL_API.G_RET_STS_SUCCESS;
521: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 522: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );

518: END IF;
519:
520: x_return_status := OKL_API.G_RET_STS_SUCCESS;
521: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
522: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );
523: END IF;
524: IF p_advance_or_arrears = 'ADVANCE' THEN
525: l_date := TRUNC(p_start_date);
526: ELSIF p_advance_or_arrears = 'ARREARS' THEN

Line 538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'end' );

534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
535: END IF;
536:
537: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'end' );
539: END IF;
540: EXCEPTION
541:
542: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 575: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

571:
572:
573: BEGIN
574: IF (G_DEBUG_ENABLED = 'Y') THEN
575: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
576: END IF;
577:
578: x_return_status := OKL_API.G_RET_STS_SUCCESS;
579: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 580: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );

576: END IF;
577:
578: x_return_status := OKL_API.G_RET_STS_SUCCESS;
579: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
580: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );
581: END IF;
582: IF p_frequency = 'M' THEN
583: l_months := 1;
584: ELSIF p_frequency = 'Q' THEN

Line 608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'end' );

604:
605: END IF;
606:
607: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'end' );
609: END IF;
610: EXCEPTION
611:
612: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 669: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

665: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'get_stream_elements';
666:
667: BEGIN
668: IF (G_DEBUG_ENABLED = 'Y') THEN
669: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
670: END IF;
671: x_return_status := OKL_API.G_RET_STS_SUCCESS ;
672: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );

Line 673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );

669: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
670: END IF;
671: x_return_status := OKL_API.G_RET_STS_SUCCESS ;
672: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );
674: END IF;
675: l_months_factor := get_months_factor( p_frequency => p_frequency,
676: x_return_status => x_return_status);
677:

Line 721: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'creating elements: ' || to_char(l_element_count) );

717:
718: l_element_count := p_periods;
719:
720: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
721: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'creating elements: ' || to_char(l_element_count) );
722: END IF;
723: FOR i IN 1 .. l_element_count LOOP
724:
725: x_selv_tbl(i).amount := l_amount;

Line 742: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'end' );

738: End If;
739:
740:
741: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
742: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'end' );
743:
744: END IF;
745: EXCEPTION
746:

Line 785: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

781:
782:
783: BEGIN
784: IF (G_DEBUG_ENABLED = 'Y') THEN
785: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
786: END IF;
787: x_return_status := OKL_API.G_RET_STS_SUCCESS;
788: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
789: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );

Line 789: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );

785: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
786: END IF;
787: x_return_status := OKL_API.G_RET_STS_SUCCESS;
788: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
789: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );
790: END IF;
791: SELECT okl_sif_seq.nextval INTO l_transaction_number FROM DUAL;
792:
793: -- NOTE: UV for Streams inquiry (OKL_ASSET_STREAMS_UV) assumes a denormalized use of KHR_ID

Line 816: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'end' );

812: x_stmv_rec := l_stmv_rec;
813: --x_return_status := G_RET_STS_SUCCESS;
814:
815: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
816: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'end' );
817: END IF;
818: EXCEPTION
819:
820: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1062: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1058:
1059:
1060: BEGIN
1061: IF (G_DEBUG_ENABLED = 'Y') THEN
1062: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1063: END IF;
1064:
1065: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1066: -- Call start_activity to create savepoint, check compatibility

Line 1082: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );

1078: END IF;
1079:
1080:
1081: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1082: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'begin' );
1083: END IF;
1084: OPEN c_hdr;
1085: FETCH c_hdr INTO l_hdr;
1086: CLOSE c_hdr;

Line 1110: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || ' generating streams - begin');

1106: -- STEP 1: Spread cash INFLOW
1107: ---------------------------------------------
1108:
1109: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1110: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || ' generating streams - begin');
1111:
1112: END IF;
1113: get_stream_header(p_khr_id => p_khr_id,
1114: p_kle_id => p_kle_id,

Line 1145: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'created header' );

1141:
1142: l_stmv_rec_rent := lx_stmv_rec;
1143:
1144: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1145: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'created header' );
1146: END IF;
1147: x_payment_count := 0;
1148: l_ele_count := 0;
1149: FOR i IN p_payment_tbl.FIRST..p_payment_tbl.LAST

Line 1175: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'start date ' || p_payment_tbl(i).start_date );

1171: l_adv_arr := 'ADVANCE';
1172: End If;
1173:
1174: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1175: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'start date ' || p_payment_tbl(i).start_date );
1176: END IF;
1177: get_stream_elements( p_start_date => p_payment_tbl(i).start_date,
1178: p_periods => p_payment_tbl(i).periods,
1179: p_frequency => p_payment_tbl(i).frequency,

Line 1202: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'created elements ' || to_char(l_selv_tbl.COUNT) );

1198: RAISE OKL_API.G_EXCEPTION_ERROR;
1199: END IF;
1200:
1201: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1202: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'created elements ' || to_char(l_selv_tbl.COUNT) );
1203: END IF;
1204: FOR j in 1..l_selv_tbl.COUNT
1205: LOOP
1206: l_ele_count := l_ele_count + 1;

Line 1227: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'start date ' || l_selv_tbl(1).stream_element_date );

1223:
1224: End If;
1225:
1226: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1227: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'start date ' || l_selv_tbl(1).stream_element_date );
1228: END IF;
1229: okl_streams_pub.create_stream_elements(
1230: p_api_version => p_api_version,
1231: p_init_msg_list => p_init_msg_list,

Line 1245: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'created elements ' || to_char(l_ele_count) );

1241: RAISE OKL_API.G_EXCEPTION_ERROR;
1242: END IF;
1243:
1244: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1245: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || 'created elements ' || to_char(l_ele_count) );
1246: END IF;
1247: If l_selv_tbl_rent.COUNT = 0 then
1248: l_selv_tbl_rent := lx_selv_tbl;
1249: Else

Line 1269: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || ' payment count ' || to_char(x_payment_count) );

1265: lx_selv_tbl.delete;
1266:
1267: x_payment_count := x_payment_count + 1;
1268: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1269: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || ' payment count ' || to_char(x_payment_count) );
1270:
1271: END IF;
1272: END LOOP;
1273:

Line 1275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || ' done ' );

1271: END IF;
1272: END LOOP;
1273:
1274: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_prog_name || ' done ' );
1276:
1277: END IF;
1278: l_sty_name := NULL;
1279: l_sty_id := NULL;

Line 1370: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1366: l_pv number;
1367: l_cash_flow_tbl okl_stream_generator_pvt.cash_flow_tbl;
1368: Begin
1369: IF (G_DEBUG_ENABLED = 'Y') THEN
1370: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1371: END IF;
1372:
1373: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1374: -- Call start_activity to create savepoint, check compatibility

Line 1432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || ' frequency ' || p_payment_tbl(1).frequency );

1428: LOOP
1429:
1430: l_pv := 0;
1431: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || ' frequency ' || p_payment_tbl(1).frequency );
1433: END IF;
1434: OKL_STREAM_GENERATOR_PVT.get_present_value(p_api_version => p_api_version,
1435: p_init_msg_list => p_init_msg_list,
1436: p_amount_date => l_selv_tbl_rent(i).stream_element_date,

Line 1454: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || ' amount ' || to_char(l_npv) );

1450: END IF;
1451:
1452: l_npv := l_npv + l_pv;
1453: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1454: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE, l_api_name || ' amount ' || to_char(l_npv) );
1455:
1456: END IF;
1457: END LOOP;
1458: x_npv := l_npv;

Line 5496: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_PROCESS_PVT.REBOOK_SYNCHRONIZE';

5492: lx_pydv_rec okl_pyd_pvt.ppydv_rec_type;
5493:
5494: -- sjalasut, added local variables to support logging. added as part of
5495: -- subsidy pools enhancement
5496: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_PROCESS_PVT.REBOOK_SYNCHRONIZE';
5497: l_debug_enabled VARCHAR2(10);
5498: is_debug_statement_on BOOLEAN;
5499:
5500: --Bug# 4558486

Line 5536: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

5532:
5533: -- check if debug is enabled
5534: l_debug_enabled := okl_debug_pub.check_log_enabled;
5535: -- check for logging on STATEMENT level
5536: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
5537:
5538: --------------------------------------
5539: --start of input parameter validations
5540: --------------------------------------

Line 5593: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

5589: * subsidy pools enhancement. START
5590: */
5591: -- write to log
5592: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
5593: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
5594: l_module,
5595: 'invoking OKL_SUBSIDY_POOL_AUTH_TRX_PVT.create_pool_trx_khr_rbk'||
5596: ' p_rbk_chr_id '||p_rbk_chr_id||' p_orig_chr_id '||p_orig_chr_id
5597: );

Line 5610: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

5606: ,p_orig_chr_id => p_orig_chr_id
5607: );
5608: -- write to log
5609: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
5610: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
5611: l_module,
5612: 'OKL_SUBSIDY_POOL_AUTH_TRX_PVT.create_pool_trx_khr_rbk returned with status '||x_return_status||
5613: ' x_msg_data '||x_msg_data
5614: );