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_CREATE_STREAMS_PVT dependencies on OKL_DEBUG_PUB

Line 5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

1: PACKAGE BODY OKL_CREATE_STREAMS_PVT AS
2: /* $Header: OKLRCSMB.pls 120.38.12020000.2 2012/08/07 11:32:15 bkatraga ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7: -- Start of wraper code generated automatically by Debug code generator
8: L_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_create_streams_pvt'; -- 'LEASE.STREAMS';
9: L_DEBUG_ENABLED VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 9: L_DEBUG_ENABLED VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7: -- Start of wraper code generated automatically by Debug code generator
8: L_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_create_streams_pvt'; -- 'LEASE.STREAMS';
9: L_DEBUG_ENABLED VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
10: L_LEVEL_PROCEDURE NUMBER;
11: IS_DEBUG_PROCEDURE_ON BOOLEAN;
12: -- End of wraper code generated automatically by Debug code generator
13:

Line 756: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

752: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Lines_Pub.insert_sif_lines
753: IF(L_DEBUG_ENABLED='Y') THEN
754: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
755:
756: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
757: END IF;
758: IF(IS_DEBUG_PROCEDURE_ON) THEN
759: BEGIN
760: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

Line 760: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

756: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
757: END IF;
758: IF(IS_DEBUG_PROCEDURE_ON) THEN
759: BEGIN
760: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');
761: END;
762: END IF;
763: Okl_Sif_Lines_Pub.insert_sif_lines(
764: p_api_version => p_api_version

Line 774: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

770: ,p_silv_rec => lp_silv_rec
771: ,x_silv_rec => lx_silv_rec);
772: IF(IS_DEBUG_PROCEDURE_ON) THEN
773: BEGIN
774: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');
775: END;
776: END IF;
777: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Lines_Pub.insert_sif_lines
778: IF l_return_status = G_RET_STS_ERROR THEN

Line 1532: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

1528: --Bug 4738011 - End of Changes
1529: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Lines_Pub.insert_sif_lines
1530: IF(L_DEBUG_ENABLED='Y') THEN
1531: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1532: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1533: END IF;
1534: IF(IS_DEBUG_PROCEDURE_ON) THEN
1535: BEGIN
1536: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

Line 1536: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

1532: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1533: END IF;
1534: IF(IS_DEBUG_PROCEDURE_ON) THEN
1535: BEGIN
1536: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');
1537: END;
1538: END IF;
1539: Okl_Sif_Lines_Pub.insert_sif_lines(
1540: p_api_version => p_api_version

Line 1549: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');

1545: ,p_silv_rec => lp_silv_rec
1546: ,x_silv_rec => lx_silv_rec);
1547: IF(IS_DEBUG_PROCEDURE_ON) THEN
1548: BEGIN
1549: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Lines_Pub.insert_sif_lines ');
1550: END;
1551: END IF;
1552: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Lines_Pub.insert_sif_lines
1553: IF l_return_status = G_RET_STS_ERROR THEN

Line 2544: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside procedure create_streams_lease_book');

2540: END pending_request_exists;
2541: BEGIN
2542: --Added by kthiruva for Logging Purposes
2543: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2544: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside procedure create_streams_lease_book');
2545: END IF;
2546: l_return_status := G_RET_STS_SUCCESS;
2547: initialize;
2548:

Line 2558: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to pending_request_exists, the return status is :'||l_return_status);

2554: ,p_purpose_code => p_csm_lease_header.purpose_code
2555: ,x_return_status => l_return_status);
2556: --Added by kthiruva
2557: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2558: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to pending_request_exists, the return status is :'||l_return_status);
2559: END IF;
2560: IF l_return_status = G_RET_STS_ERROR THEN
2561: RAISE G_EXCEPTION_ERROR;
2562: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 2575: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to assign_header_details');

2571: RAISE G_EXCEPTION_ERROR;
2572: ELSE
2573: --Added by kthiruva for Debugging
2574: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2575: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to assign_header_details');
2576: END IF;
2577: /* assign Transaction Header Data */
2578: lp_sifv_rec := assign_header_details( p_lease_header_rec => p_csm_lease_header
2579: ,x_return_status => l_return_status

Line 2582: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_header_details, the return status is :'||l_return_status);

2578: lp_sifv_rec := assign_header_details( p_lease_header_rec => p_csm_lease_header
2579: ,x_return_status => l_return_status
2580: );
2581: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2582: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_header_details, the return status is :'||l_return_status);
2583: END IF;
2584: IF l_return_status = G_RET_STS_ERROR THEN
2585: RAISE G_EXCEPTION_ERROR;
2586: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 2594: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

2590:
2591: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
2592: IF(L_DEBUG_ENABLED='Y') THEN
2593: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
2594: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2595: END IF;
2596: IF(IS_DEBUG_PROCEDURE_ON) THEN
2597: BEGIN
2598: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line 2598: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

2594: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
2595: END IF;
2596: IF(IS_DEBUG_PROCEDURE_ON) THEN
2597: BEGIN
2598: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2599: END;
2600: END IF;
2601:
2602: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

Line 2612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces, return status is:'||l_return_status);

2608: ,p_sifv_rec => lp_sifv_rec
2609: ,x_sifv_rec => lx_sifv_rec);
2610: --Added by kthiruva for Debugging
2611: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces, return status is:'||l_return_status);
2613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The transaction number of the request is :'||lx_sifv_rec.transaction_number);
2614: END IF;
2615:
2616: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The transaction number of the request is :'||lx_sifv_rec.transaction_number);

2609: ,x_sifv_rec => lx_sifv_rec);
2610: --Added by kthiruva for Debugging
2611: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces, return status is:'||l_return_status);
2613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The transaction number of the request is :'||lx_sifv_rec.transaction_number);
2614: END IF;
2615:
2616: IF(IS_DEBUG_PROCEDURE_ON) THEN
2617: BEGIN

Line 2618: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

2614: END IF;
2615:
2616: IF(IS_DEBUG_PROCEDURE_ON) THEN
2617: BEGIN
2618: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
2619: END;
2620: END IF;
2621:
2622: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

Line 2643: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_asset_lines, the return status is :'||l_return_status);

2639: x_msg_count => x_msg_count,
2640: x_msg_data => x_msg_data);
2641: --Added by kthiruva for Debugging
2642: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2643: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_asset_lines, the return status is :'||l_return_status);
2644: END IF;
2645:
2646: IF l_return_status = G_RET_STS_ERROR THEN
2647: RAISE G_EXCEPTION_ERROR;

Line 2673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_finance_fee_for_lease, the return status is :'||l_return_status);

2669: x_msg_count => x_msg_count,
2670: x_msg_data => x_msg_data);
2671: --Added by kthiruva for Debugging
2672: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_finance_fee_for_lease, the return status is :'||l_return_status);
2674: END IF;
2675:
2676:
2677: IF l_return_status = G_RET_STS_ERROR THEN

Line 2694: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_rent_details, the return status is :'||l_return_status);

2690: x_return_status => l_return_status
2691: );
2692: --Added by kthiruva for Debugging
2693: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2694: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_rent_details, the return status is :'||l_return_status);
2695: END IF;
2696:
2697: IF l_return_status = G_RET_STS_ERROR THEN
2698: RAISE G_EXCEPTION_ERROR;

Line 2708: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2704: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2705: IF(IS_DEBUG_PROCEDURE_ON) THEN
2706:
2707: BEGIN
2708: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2709: END;
2710: END IF;
2711:
2712:

Line 2723: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);

2719: ,p_sfev_tbl => lp_sfev_rent_tbl
2720: ,x_sfev_tbl => lx_sfev_rent_tbl);
2721: --Added by kthiruva for Debugging
2722: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2723: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
2724: END IF;
2725:
2726: IF(IS_DEBUG_PROCEDURE_ON) THEN
2727: BEGIN

Line 2728: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2724: END IF;
2725:
2726: IF(IS_DEBUG_PROCEDURE_ON) THEN
2727: BEGIN
2728: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2729: END;
2730: END IF;
2731:
2732: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

Line 2767: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_one_off_fees, the return status is :'||l_return_status);

2763: x_return_status => l_return_status
2764: );
2765: --Added by kthiruva for Debugging
2766: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2767: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_one_off_fees, the return status is :'||l_return_status);
2768: END IF;
2769:
2770:
2771: IF l_return_status = G_RET_STS_ERROR THEN

Line 2781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2777:
2778: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2779: IF(IS_DEBUG_PROCEDURE_ON) THEN
2780: BEGIN
2781: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2782: END;
2783: END IF;
2784:
2785: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 2796: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);

2792: ,p_sfev_tbl => lp_sfev_one_off_tbl
2793: ,x_sfev_tbl => lx_sfev_one_off_tbl);
2794: --Added by kthiruva for Debugging
2795: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2796: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
2797: END IF;
2798:
2799:
2800:

Line 2803: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2799:
2800:
2801: IF(IS_DEBUG_PROCEDURE_ON) THEN
2802: BEGIN
2803: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2804: END;
2805: END IF;
2806: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2807: IF l_return_status = G_RET_STS_ERROR THEN

Line 2823: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_periodic_expenses, the return status is :'||l_return_status);

2819: x_return_status => l_return_status
2820: );
2821: --Added by kthiruva for Debugging
2822: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2823: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_periodic_expenses, the return status is :'||l_return_status);
2824: END IF;
2825:
2826:
2827: IF l_return_status = G_RET_STS_ERROR THEN

Line 2836: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2832: END IF;
2833: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2834: IF(IS_DEBUG_PROCEDURE_ON) THEN
2835: BEGIN
2836: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2837: END;
2838: END IF;
2839:
2840: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 2851: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);

2847: ,p_sfev_tbl => lp_sfev_periodic_tbl
2848: ,x_sfev_tbl => lx_sfev_periodic_tbl);
2849: --Added by kthiruva for Debugging
2850: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2851: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees, the return status is :'||l_return_status);
2852: END IF;
2853:
2854:
2855: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2857: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

2853:
2854:
2855: IF(IS_DEBUG_PROCEDURE_ON) THEN
2856: BEGIN
2857: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
2858: END;
2859: END IF;
2860: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
2861: IF l_return_status = G_RET_STS_ERROR THEN

Line 2876: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_yield_details, the return status is :'||l_return_status);

2872:
2873: );
2874: --Added by kthiruva for Debugging
2875: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2876: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_yield_details, the return status is :'||l_return_status);
2877: END IF;
2878:
2879: IF l_return_status = G_RET_STS_ERROR THEN
2880: RAISE G_EXCEPTION_ERROR;

Line 2889: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

2885: -- Insert Yield Data corresponding to this Transaction
2886: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
2887: IF(IS_DEBUG_PROCEDURE_ON) THEN
2888: BEGIN
2889: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
2890: END;
2891: END IF;
2892: Okl_Sif_Yields_Pub.insert_sif_yields(
2893: p_api_version => p_api_version

Line 2903: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Yields_Pub.insert_sif_yields, the return status is :'||l_return_status);

2899:
2900: ,x_siyv_tbl => lx_siyv_tbl);
2901: --Added by kthiruva for Debugging
2902: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2903: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Yields_Pub.insert_sif_yields, the return status is :'||l_return_status);
2904: END IF;
2905:
2906:
2907: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 2909: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

2905:
2906:
2907: IF(IS_DEBUG_PROCEDURE_ON) THEN
2908: BEGIN
2909: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
2910: END;
2911: END IF;
2912:
2913: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields

Line 2929: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_stream_types, the return status is :'||l_return_status);

2925: ,x_return_status => l_return_status
2926: );
2927: --Added by kthiruva for Debugging
2928: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2929: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_stream_types, the return status is :'||l_return_status);
2930: END IF;
2931:
2932:
2933: IF l_return_status = G_RET_STS_ERROR THEN

Line 2943: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

2939: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
2940: IF(IS_DEBUG_PROCEDURE_ON) THEN
2941: BEGIN
2942:
2943: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
2944: END;
2945: END IF;
2946:
2947: Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(

Line 2958: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Stream_Types_Pub.insert_sif_stream_types, the return status is :'||l_return_status);

2954: ,p_sitv_tbl => lp_sitv_tbl
2955: ,x_sitv_tbl => lx_sitv_tbl);
2956: --Added by kthiruva for Debugging
2957: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2958: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Stream_Types_Pub.insert_sif_stream_types, the return status is :'||l_return_status);
2959: END IF;
2960:
2961:
2962:

Line 2965: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

2961:
2962:
2963: IF(IS_DEBUG_PROCEDURE_ON) THEN
2964: BEGIN
2965: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
2966: END;
2967: END IF;
2968: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
2969: IF l_return_status = G_RET_STS_ERROR THEN

Line 2979: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');

2975:
2976: IF(IS_DEBUG_PROCEDURE_ON) THEN
2977: BEGIN
2978:
2979: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');
2980: END;
2981: END IF;
2982:
2983:

Line 2996: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Update_Pricing_Param, the return status is :'||l_return_status);

2992: ,x_msg_data => x_msg_data
2993: );
2994: --Added by kthiruva for Debugging
2995: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2996: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Update_Pricing_Param, the return status is :'||l_return_status);
2997: END IF;
2998:
2999: IF(IS_DEBUG_PROCEDURE_ON) THEN
3000: BEGIN

Line 3001: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');

2997: END IF;
2998:
2999: IF(IS_DEBUG_PROCEDURE_ON) THEN
3000: BEGIN
3001: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');
3002: END;
3003: END IF;
3004: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
3005: IF l_return_status = G_RET_STS_ERROR THEN

Line 3016: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The value of p_skip_prc_engine is :'||p_skip_prc_engine);

3012:
3013: IF p_skip_prc_engine <> G_TRUE THEN
3014: --Added by kthiruva for Debugging
3015: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3016: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The value of p_skip_prc_engine is :'||p_skip_prc_engine);
3017: END IF;
3018: Invoke_Pricing_Engine(
3019: p_api_version => p_api_version,
3020: p_init_msg_list => p_init_msg_list,

Line 3028: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Invoke_Pricing_Engine, the return status is :'||l_return_status);

3024: x_msg_count => x_msg_count,
3025: x_msg_data => x_msg_data);
3026: --Added by kthiruva for Debugging
3027: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3028: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Invoke_Pricing_Engine, the return status is :'||l_return_status);
3029: END IF;
3030:
3031: IF l_return_status = G_RET_STS_ERROR THEN
3032: RAISE G_EXCEPTION_ERROR;

Line 3187: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside the call to create_Streams_loan_book');

3183: END pending_request_exists;
3184: BEGIN
3185: --Added by kthiruva for Debug Logging
3186: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3187: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside the call to create_Streams_loan_book');
3188: END IF;
3189:
3190: l_return_status := G_RET_STS_SUCCESS;
3191: initialize;

Line 3200: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to pending_request_exists,return status is :'||l_return_status);

3196: ,p_purpose_code => p_csm_loan_header.purpose_code
3197: ,x_return_status => l_return_status);
3198: --Added by kthiruva for Debug Logging
3199: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3200: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to pending_request_exists,return status is :'||l_return_status);
3201: END IF;
3202: IF l_return_status = G_RET_STS_ERROR THEN
3203: RAISE G_EXCEPTION_ERROR;
3204: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 3222: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_header_details,return status is :'||l_return_status);

3218:
3219: );
3220: --Added by kthiruva for Debug Logging
3221: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3222: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_header_details,return status is :'||l_return_status);
3223: END IF;
3224: IF l_return_status = G_RET_STS_ERROR THEN
3225: RAISE G_EXCEPTION_ERROR;
3226: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN

Line 3234: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

3230: -- Insert Transaction Header Data
3231: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
3232: IF(L_DEBUG_ENABLED='Y') THEN
3233: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3234: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3235: END IF;
3236: IF(IS_DEBUG_PROCEDURE_ON) THEN
3237: BEGIN
3238: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line 3238: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

3234: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3235: END IF;
3236: IF(IS_DEBUG_PROCEDURE_ON) THEN
3237: BEGIN
3238: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
3239: END;
3240: END IF;
3241: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
3242: p_api_version => p_api_version

Line 3251: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces,return status is :'||l_return_status);

3247: ,p_sifv_rec => lp_sifv_rec
3248: ,x_sifv_rec => lx_sifv_rec);
3249: --Added by kthiruva for Debug Logging
3250: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3251: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Stream_Interfaces_Pub.insert_stream_interfaces,return status is :'||l_return_status);
3252: END IF;
3253:
3254: IF(IS_DEBUG_PROCEDURE_ON) THEN
3255: BEGIN

Line 3256: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

3252: END IF;
3253:
3254: IF(IS_DEBUG_PROCEDURE_ON) THEN
3255: BEGIN
3256: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
3257: END;
3258:
3259: END IF;
3260: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces

Line 3290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_finance_fee_for_loan,return status is :'||l_return_status);

3286: x_msg_count => x_msg_count,
3287: x_msg_data => x_msg_data);
3288: --Added by kthiruva for Debug Logging
3289: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3290: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_finance_fee_for_loan,return status is :'||l_return_status);
3291: END IF;
3292:
3293: IF l_return_status = G_RET_STS_ERROR THEN
3294: RAISE G_EXCEPTION_ERROR;

Line 3313: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_loan_lines,return status is :'||l_return_status);

3309: x_msg_count => x_msg_count,
3310: x_msg_data => x_msg_data);
3311: --Added by kthiruva for Debug Logging
3312: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3313: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to insert_loan_lines,return status is :'||l_return_status);
3314: END IF;
3315:
3316: IF l_return_status = G_RET_STS_ERROR THEN
3317: RAISE G_EXCEPTION_ERROR;

Line 3330: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_loan_levels,return status is :'||l_return_status);

3326: x_return_status => l_return_status
3327: );
3328: --Added by kthiruva for Debug Logging
3329: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3330: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_loan_levels,return status is :'||l_return_status);
3331: END IF;
3332:
3333: IF l_return_status = G_RET_STS_ERROR THEN
3334:

Line 3343: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3339: -- Insert Loan Levels
3340: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3341: IF(IS_DEBUG_PROCEDURE_ON) THEN
3342: BEGIN
3343: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3344: END;
3345:
3346: END IF;
3347:

Line 3359: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);

3355: ,p_sfev_tbl => lp_sfev_loan_levels_tbl
3356: ,x_sfev_tbl => lx_sfev_loan_levels_tbl);
3357: --Added by kthiruva for Debug Logging
3358: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3359: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
3360: END IF;
3361:
3362: IF(IS_DEBUG_PROCEDURE_ON) THEN
3363: BEGIN

Line 3364: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3360: END IF;
3361:
3362: IF(IS_DEBUG_PROCEDURE_ON) THEN
3363: BEGIN
3364: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3365: END;
3366: END IF;
3367: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3368: IF l_return_status = G_RET_STS_ERROR THEN

Line 3383: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_one_off_fees,return status is :'||l_return_status);

3379:
3380: );
3381: --Added by kthiruva for Debug Logging
3382: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3383: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_one_off_fees,return status is :'||l_return_status);
3384: END IF;
3385:
3386: IF l_return_status = G_RET_STS_ERROR THEN
3387: RAISE G_EXCEPTION_ERROR;

Line 3394: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3390: END IF;
3391: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3392: IF(IS_DEBUG_PROCEDURE_ON) THEN
3393: BEGIN
3394: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3395:
3396: END;
3397: END IF;
3398: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 3408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);

3404: ,p_sfev_tbl => lp_sfev_one_off_tbl
3405: ,x_sfev_tbl => lx_sfev_one_off_tbl);
3406: --Added by kthiruva for Debug Logging
3407: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
3409: END IF;
3410:
3411:
3412: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 3414: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3410:
3411:
3412: IF(IS_DEBUG_PROCEDURE_ON) THEN
3413: BEGIN
3414: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3415: END;
3416: END IF;
3417:
3418: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

Line 3434: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_periodic_expenses,return status is :'||l_return_status);

3430: x_return_status => l_return_status
3431: );
3432: --Added by kthiruva for Debug Logging
3433: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3434: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_periodic_expenses,return status is :'||l_return_status);
3435: END IF;
3436:
3437: IF l_return_status = G_RET_STS_ERROR THEN
3438: RAISE G_EXCEPTION_ERROR;

Line 3445: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3441: END IF;
3442: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3443: IF(IS_DEBUG_PROCEDURE_ON) THEN
3444: BEGIN
3445: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3446: END;
3447: END IF;
3448: Okl_Sif_Fees_Pub.insert_sif_fees(
3449: p_api_version => p_api_version

Line 3458: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);

3454: ,p_sfev_tbl => lp_sfev_periodic_expenses_tbl
3455: ,x_sfev_tbl => lx_sfev_periodic_expenses_tbl);
3456: --Added by kthiruva for Debug Logging
3457: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3458: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Fees_Pub.insert_sif_fees,return status is :'||l_return_status);
3459: END IF;
3460:
3461:
3462: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 3465: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

3461:
3462: IF(IS_DEBUG_PROCEDURE_ON) THEN
3463: BEGIN
3464:
3465: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
3466: END;
3467: END IF;
3468: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
3469: IF l_return_status = G_RET_STS_ERROR THEN

Line 3513: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_yield_details,return status is :'||l_return_status);

3509: ,x_return_status => l_return_status
3510: );
3511: --Added by kthiruva for Debug Logging
3512: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3513: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_yield_details,return status is :'||l_return_status);
3514: END IF;
3515:
3516: IF l_return_status = G_RET_STS_ERROR THEN
3517: RAISE G_EXCEPTION_ERROR;

Line 3526: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

3522:
3523: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
3524: IF(IS_DEBUG_PROCEDURE_ON) THEN
3525: BEGIN
3526: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
3527: END;
3528: END IF;
3529: Okl_Sif_Yields_Pub.insert_sif_yields(
3530: p_api_version => p_api_version

Line 3539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Yields_Pub.insert_sif_yields,return status is :'||l_return_status);

3535: ,p_siyv_tbl => lp_siyv_tbl
3536: ,x_siyv_tbl => lx_siyv_tbl);
3537: --Added by kthiruva for Debug Logging
3538: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Yields_Pub.insert_sif_yields,return status is :'||l_return_status);
3540: END IF;
3541:
3542: IF(IS_DEBUG_PROCEDURE_ON) THEN
3543: BEGIN

Line 3545: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

3541:
3542: IF(IS_DEBUG_PROCEDURE_ON) THEN
3543: BEGIN
3544:
3545: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
3546:
3547: END;
3548: END IF;
3549: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields

Line 3564: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_stream_types,return status is :'||l_return_status);

3560: x_return_status => l_return_status
3561: );
3562: --Added by kthiruva for Debug Logging
3563: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3564: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to assign_stream_types,return status is :'||l_return_status);
3565: END IF;
3566:
3567: IF l_return_status = G_RET_STS_ERROR THEN
3568: RAISE G_EXCEPTION_ERROR;

Line 3576: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

3572: -- Insert StreamTypes corresponding to this Transaction
3573: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
3574: IF(IS_DEBUG_PROCEDURE_ON) THEN
3575: BEGIN
3576: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
3577: END;
3578: END IF;
3579: Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(
3580: p_api_version => p_api_version

Line 3590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Stream_Types_Pub.insert_sif_stream_types,return status is :'||l_return_status);

3586: ,p_sitv_tbl => lp_sitv_tbl
3587: ,x_sitv_tbl => lx_sitv_tbl);
3588: --Added by kthiruva for Debug Logging
3589: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Sif_Stream_Types_Pub.insert_sif_stream_types,return status is :'||l_return_status);
3591: END IF;
3592:
3593:
3594: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 3596: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

3592:
3593:
3594: IF(IS_DEBUG_PROCEDURE_ON) THEN
3595: BEGIN
3596: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
3597: END;
3598: END IF;
3599: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
3600:

Line 3611: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');

3607:
3608: IF(IS_DEBUG_PROCEDURE_ON) THEN
3609: BEGIN
3610:
3611: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');
3612: END;
3613: END IF;
3614:
3615:

Line 3628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Update_Pricing_Param,return status is :'||l_return_status);

3624: ,x_msg_data => x_msg_data
3625: );
3626: --Added by kthiruva for Debug Logging
3627: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Update_Pricing_Param,return status is :'||l_return_status);
3629: END IF;
3630:
3631: IF(IS_DEBUG_PROCEDURE_ON) THEN
3632: BEGIN

Line 3633: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');

3629: END IF;
3630:
3631: IF(IS_DEBUG_PROCEDURE_ON) THEN
3632: BEGIN
3633: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');
3634: END;
3635: END IF;
3636: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
3637: IF l_return_status = G_RET_STS_ERROR THEN

Line 3646: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The value of p_skip_prc_engine is '||p_skip_prc_engine);

3642:
3643: IF p_skip_prc_engine <> G_TRUE THEN
3644: --Added by kthiruva for Debug Logging
3645: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3646: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The value of p_skip_prc_engine is '||p_skip_prc_engine);
3647: END IF;
3648: Invoke_Pricing_Engine(
3649:
3650: p_api_version => p_api_version,

Line 3659: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Invoke_Pricing_Engine,return status is :'||l_return_status);

3655: x_msg_count => x_msg_count,
3656: x_msg_data => x_msg_data);
3657: --Added by kthiruva for Debug Logging
3658: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3659: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Invoke_Pricing_Engine,return status is :'||l_return_status);
3660: END IF;
3661:
3662: IF l_return_status = G_RET_STS_ERROR THEN
3663: RAISE G_EXCEPTION_ERROR;

Line 3724: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

3720: --srsreeni Bug5996152 end
3721: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3722: IF(L_DEBUG_ENABLED='Y') THEN
3723: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
3724: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3725: END IF;
3726: IF(IS_DEBUG_PROCEDURE_ON) THEN
3727: BEGIN
3728: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

Line 3728: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

3724: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
3725: END IF;
3726: IF(IS_DEBUG_PROCEDURE_ON) THEN
3727: BEGIN
3728: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3729: END;
3730: END IF;
3731:
3732: Okl_Stream_Interfaces_Pub.update_stream_interfaces(

Line 3744: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

3740: ,x_sifv_rec => lx_sifv_rec);
3741:
3742: IF(IS_DEBUG_PROCEDURE_ON) THEN
3743: BEGIN
3744: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3745: END;
3746: END IF;
3747: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3748: IF l_return_status = G_RET_STS_ERROR THEN

Line 3759: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Invoke_Pricing_Engine_Pub.generate_streams_st ');

3755: -- Call STTA Invocation API
3756: -- Start of wraper code generated automatically by Debug code generator for Okl_Invoke_Pricing_Engine_Pub.generate_streams_st
3757: IF(IS_DEBUG_PROCEDURE_ON) THEN
3758: BEGIN
3759: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Invoke_Pricing_Engine_Pub.generate_streams_st ');
3760: END;
3761: END IF;
3762:
3763: Okl_Invoke_Pricing_Engine_Pub.generate_streams_st(

Line 3776: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Invoke_Pricing_Engine_Pub.generate_streams_st ');

3772: x_msg_data => x_msg_data);
3773:
3774: IF(IS_DEBUG_PROCEDURE_ON) THEN
3775: BEGIN
3776: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Invoke_Pricing_Engine_Pub.generate_streams_st ');
3777: END;
3778: END IF;
3779: -- End of wraper code generated automatically by Debug code generator for Okl_Invoke_Pricing_Engine_Pub.generate_streams_st
3780: IF l_return_status = G_RET_STS_ERROR THEN

Line 3792: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

3788: lp_sifv_rec.sis_code := G_SIS_PROCESSING_REQUEST;
3789: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3790: IF(IS_DEBUG_PROCEDURE_ON) THEN
3791: BEGIN
3792: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3793: END;
3794: END IF;
3795:
3796: Okl_Stream_Interfaces_Pub.update_stream_interfaces(

Line 3808: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');

3804: ,x_sifv_rec => lx_sifv_rec);
3805:
3806: IF(IS_DEBUG_PROCEDURE_ON) THEN
3807: BEGIN
3808: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.update_stream_interfaces ');
3809: END;
3810: END IF;
3811: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.update_stream_interfaces
3812: IF l_return_status = G_RET_STS_ERROR THEN

Line 4045: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

4041: -- Insert Transaction Header Data
4042: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4043: IF(L_DEBUG_ENABLED='Y') THEN
4044: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
4045: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4046: END IF;
4047: IF(IS_DEBUG_PROCEDURE_ON) THEN
4048: BEGIN
4049: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line 4049: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

4045: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4046: END IF;
4047: IF(IS_DEBUG_PROCEDURE_ON) THEN
4048: BEGIN
4049: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4050: END;
4051: END IF;
4052: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(
4053: p_api_version => p_api_version

Line 4063: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

4059:
4060: ,x_sifv_rec => lx_sifv_rec);
4061: IF(IS_DEBUG_PROCEDURE_ON) THEN
4062: BEGIN
4063: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4064: END;
4065: END IF;
4066: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4067: IF l_return_status = G_RET_STS_ERROR THEN

Line 4108: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4104: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4105:
4106: IF(IS_DEBUG_PROCEDURE_ON) THEN
4107: BEGIN
4108: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4109: END;
4110: END IF;
4111:
4112: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 4122: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4118: ,p_sfev_tbl => lp_sfev_rent_tbl
4119: ,x_sfev_tbl => lx_sfev_rent_tbl);
4120: IF(IS_DEBUG_PROCEDURE_ON) THEN
4121: BEGIN
4122: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4123: END;
4124: END IF;
4125: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4126: IF l_return_status = G_RET_STS_ERROR THEN

Line 4148: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4144:
4145: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4146: IF(IS_DEBUG_PROCEDURE_ON) THEN
4147: BEGIN
4148: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4149: END;
4150: END IF;
4151: Okl_Sif_Fees_Pub.insert_sif_fees(
4152: p_api_version => p_api_version

Line 4161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4157: ,p_sfev_tbl => lp_sfev_one_off_tbl
4158: ,x_sfev_tbl => lx_sfev_one_off_tbl);
4159: IF(IS_DEBUG_PROCEDURE_ON) THEN
4160: BEGIN
4161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4162: END;
4163: END IF;
4164: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4165: IF l_return_status = G_RET_STS_ERROR THEN

Line 4187: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4183: END IF;
4184: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4185: IF(IS_DEBUG_PROCEDURE_ON) THEN
4186: BEGIN
4187: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4188: END;
4189: END IF;
4190: Okl_Sif_Fees_Pub.insert_sif_fees(
4191: p_api_version => p_api_version

Line 4201: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4197: ,p_sfev_tbl => lp_sfev_periodic_tbl
4198: ,x_sfev_tbl => lx_sfev_periodic_tbl);
4199: IF(IS_DEBUG_PROCEDURE_ON) THEN
4200: BEGIN
4201: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4202:
4203: END;
4204: END IF;
4205: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

Line 4228: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

4224: -- Insert Yield Data corresponding to this Transaction
4225: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4226: IF(IS_DEBUG_PROCEDURE_ON) THEN
4227: BEGIN
4228: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4229: END;
4230: END IF;
4231: Okl_Sif_Yields_Pub.insert_sif_yields(
4232: p_api_version => p_api_version

Line 4241: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

4237: ,p_siyv_tbl => lp_siyv_tbl
4238: ,x_siyv_tbl => lx_siyv_tbl);
4239: IF(IS_DEBUG_PROCEDURE_ON) THEN
4240: BEGIN
4241: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4242: END;
4243:
4244: END IF;
4245: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields

Line 4268: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

4264: -- Insert StreamTypes corresponding to this Transaction
4265: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
4266: IF(IS_DEBUG_PROCEDURE_ON) THEN
4267: BEGIN
4268: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
4269: END;
4270: END IF;
4271: Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(
4272:

Line 4283: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

4279:
4280: ,x_sitv_tbl => lx_sitv_tbl);
4281: IF(IS_DEBUG_PROCEDURE_ON) THEN
4282: BEGIN
4283: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
4284: END;
4285: END IF;
4286: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
4287: IF l_return_status = G_RET_STS_ERROR THEN

Line 4297: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');

4293:
4294: IF(IS_DEBUG_PROCEDURE_ON) THEN
4295: BEGIN
4296:
4297: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');
4298: END;
4299: END IF;
4300:
4301:

Line 4314: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');

4310: ,x_msg_data => x_msg_data
4311: );
4312: IF(IS_DEBUG_PROCEDURE_ON) THEN
4313: BEGIN
4314: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');
4315: END;
4316: END IF;
4317: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
4318: IF l_return_status = G_RET_STS_ERROR THEN

Line 4530: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

4526: -- Insert Transaction Header Data
4527: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4528: IF(L_DEBUG_ENABLED='Y') THEN
4529: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
4530: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4531: END IF;
4532: IF(IS_DEBUG_PROCEDURE_ON) THEN
4533: BEGIN
4534: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

Line 4534: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

4530: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
4531: END IF;
4532: IF(IS_DEBUG_PROCEDURE_ON) THEN
4533: BEGIN
4534: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4535: END;
4536: END IF;
4537:
4538: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

Line 4551: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

4547: ,x_sifv_rec => lx_sifv_rec);
4548:
4549: IF(IS_DEBUG_PROCEDURE_ON) THEN
4550: BEGIN
4551: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
4552: END;
4553: END IF;
4554: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
4555: IF l_return_status = G_RET_STS_ERROR THEN

Line 4627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4623: -- Insert Loan Levels
4624: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4625: IF(IS_DEBUG_PROCEDURE_ON) THEN
4626: BEGIN
4627: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4628: END;
4629: END IF;
4630:
4631: --Added by kthiruva for populating the method to be used by the Balance Tag

Line 4658: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4654: ,x_sfev_tbl => lx_sfev_loan_levels_tbl);
4655:
4656: IF(IS_DEBUG_PROCEDURE_ON) THEN
4657: BEGIN
4658: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4659: END;
4660: END IF;
4661: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4662: IF l_return_status = G_RET_STS_ERROR THEN

Line 4683: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4679: END IF;
4680: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4681: IF(IS_DEBUG_PROCEDURE_ON) THEN
4682: BEGIN
4683: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4684: END;
4685: END IF;
4686: Okl_Sif_Fees_Pub.insert_sif_fees(
4687: p_api_version => p_api_version

Line 4698: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4694: ,x_sfev_tbl => lx_sfev_one_off_tbl);
4695:
4696: IF(IS_DEBUG_PROCEDURE_ON) THEN
4697: BEGIN
4698: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4699: END;
4700: END IF;
4701: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4702: IF l_return_status = G_RET_STS_ERROR THEN

Line 4724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4720: END IF;
4721: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4722: IF(IS_DEBUG_PROCEDURE_ON) THEN
4723: BEGIN
4724: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4725: END;
4726: END IF;
4727: Okl_Sif_Fees_Pub.insert_sif_fees(
4728: p_api_version => p_api_version

Line 4738: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

4734: ,p_sfev_tbl => lp_sfev_periodic_expenses_tbl
4735: ,x_sfev_tbl => lx_sfev_periodic_expenses_tbl);
4736: IF(IS_DEBUG_PROCEDURE_ON) THEN
4737: BEGIN
4738: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
4739: END;
4740: END IF;
4741: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
4742: IF l_return_status = G_RET_STS_ERROR THEN

Line 4764: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

4760: -- Insert Yield Data corresponding to this Transaction
4761: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4762: IF(IS_DEBUG_PROCEDURE_ON) THEN
4763: BEGIN
4764: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4765: END;
4766: END IF;
4767: Okl_Sif_Yields_Pub.insert_sif_yields(
4768: p_api_version => p_api_version

Line 4778: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

4774: ,p_siyv_tbl => lp_siyv_tbl
4775: ,x_siyv_tbl => lx_siyv_tbl);
4776: IF(IS_DEBUG_PROCEDURE_ON) THEN
4777: BEGIN
4778: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
4779: END;
4780: END IF;
4781: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
4782: IF l_return_status = G_RET_STS_ERROR THEN

Line 4805: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

4801:
4802: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
4803: IF(IS_DEBUG_PROCEDURE_ON) THEN
4804: BEGIN
4805: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
4806:
4807: END;
4808: END IF;
4809: Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(

Line 4820: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

4816: ,p_sitv_tbl => lp_sitv_tbl
4817: ,x_sitv_tbl => lx_sitv_tbl);
4818: IF(IS_DEBUG_PROCEDURE_ON) THEN
4819: BEGIN
4820: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
4821: END;
4822: END IF;
4823: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
4824: IF l_return_status = G_RET_STS_ERROR THEN

Line 4833: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');

4829: END IF;
4830: IF(IS_DEBUG_PROCEDURE_ON) THEN
4831: BEGIN
4832:
4833: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Update_Pricing_Param ');
4834: END;
4835: END IF;
4836:
4837:

Line 4850: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');

4846: ,x_msg_data => x_msg_data
4847: );
4848: IF(IS_DEBUG_PROCEDURE_ON) THEN
4849: BEGIN
4850: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Update_Pricing_Param ');
4851: END;
4852: END IF;
4853: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
4854: IF l_return_status = G_RET_STS_ERROR THEN

Line 5021: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

5017:
5018: -- Start of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
5019: IF(L_DEBUG_ENABLED='Y') THEN
5020: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
5021: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
5022: END IF;
5023: IF(IS_DEBUG_PROCEDURE_ON) THEN
5024: BEGIN
5025:

Line 5026: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

5022: END IF;
5023: IF(IS_DEBUG_PROCEDURE_ON) THEN
5024: BEGIN
5025:
5026: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
5027: END;
5028: END IF;
5029:
5030: Okl_Stream_Interfaces_Pub.insert_stream_interfaces(

Line 5041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');

5037: ,p_sifv_rec => lp_sifv_rec
5038: ,x_sifv_rec => lx_sifv_rec);
5039: IF(IS_DEBUG_PROCEDURE_ON) THEN
5040: BEGIN
5041: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Stream_Interfaces_Pub.insert_stream_interfaces ');
5042: END;
5043: END IF;
5044: -- End of wraper code generated automatically by Debug code generator for Okl_Stream_Interfaces_Pub.insert_stream_interfaces
5045: IF l_return_status = G_RET_STS_ERROR THEN

Line 5114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5110: -- Insert Rent Details
5111: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5112: IF(IS_DEBUG_PROCEDURE_ON) THEN
5113: BEGIN
5114: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5115: END;
5116: END IF;
5117:
5118: Okl_Sif_Fees_Pub.insert_sif_fees(

Line 5128: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5124: ,p_sfev_tbl => lp_sfev_rent_tbl
5125: ,x_sfev_tbl => lx_sfev_rent_tbl);
5126: IF(IS_DEBUG_PROCEDURE_ON) THEN
5127: BEGIN
5128: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5129: END;
5130:
5131: END IF;
5132: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees

Line 5155: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5151:
5152: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5153: IF(IS_DEBUG_PROCEDURE_ON) THEN
5154: BEGIN
5155: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5156: END;
5157: END IF;
5158: Okl_Sif_Fees_Pub.insert_sif_fees(
5159: p_api_version => p_api_version

Line 5168: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5164: ,p_sfev_tbl => lp_sfev_one_off_tbl
5165: ,x_sfev_tbl => lx_sfev_one_off_tbl);
5166: IF(IS_DEBUG_PROCEDURE_ON) THEN
5167: BEGIN
5168: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5169: END;
5170: END IF;
5171: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5172: IF l_return_status = G_RET_STS_ERROR THEN

Line 5195: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5191: END IF;
5192: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5193: IF(IS_DEBUG_PROCEDURE_ON) THEN
5194: BEGIN
5195: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5196: END;
5197: END IF;
5198: Okl_Sif_Fees_Pub.insert_sif_fees(
5199: p_api_version => p_api_version

Line 5209: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');

5205: ,x_sfev_tbl => lx_sfev_periodic_tbl);
5206: IF(IS_DEBUG_PROCEDURE_ON) THEN
5207: BEGIN
5208:
5209: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Fees_Pub.insert_sif_fees ');
5210: END;
5211: END IF;
5212: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Fees_Pub.insert_sif_fees
5213: IF l_return_status = G_RET_STS_ERROR THEN

Line 5235: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

5231: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
5232:
5233: IF(IS_DEBUG_PROCEDURE_ON) THEN
5234: BEGIN
5235: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
5236: END;
5237: END IF;
5238: Okl_Sif_Yields_Pub.insert_sif_yields(
5239:

Line 5249: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');

5245: ,p_siyv_tbl => lp_siyv_tbl
5246: ,x_siyv_tbl => lx_siyv_tbl);
5247: IF(IS_DEBUG_PROCEDURE_ON) THEN
5248: BEGIN
5249: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Yields_Pub.insert_sif_yields ');
5250: END;
5251: END IF;
5252: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Yields_Pub.insert_sif_yields
5253: IF l_return_status = G_RET_STS_ERROR THEN

Line 5275: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

5271: -- Insert StreamTypes corresponding to this Transaction
5272: -- Start of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
5273: IF(IS_DEBUG_PROCEDURE_ON) THEN
5274: BEGIN
5275: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
5276: END;
5277: END IF;
5278: Okl_Sif_Stream_Types_Pub.insert_sif_stream_types(
5279: p_api_version => p_api_version

Line 5291: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');

5287:
5288:
5289:
5290: BEGIN
5291: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRCSMB.pls call Okl_Sif_Stream_Types_Pub.insert_sif_stream_types ');
5292: END;
5293: END IF;
5294: -- End of wraper code generated automatically by Debug code generator for Okl_Sif_Stream_Types_Pub.insert_sif_stream_types
5295: IF l_return_status = G_RET_STS_ERROR THEN