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_SEC_AGREEMENT_PVT dependencies on OKL_SEC_AGREEMENT_PVT

Line 1: PACKAGE BODY Okl_Sec_Agreement_Pvt AS

1: PACKAGE BODY Okl_Sec_Agreement_Pvt AS
2: /* $Header: OKLRSZAB.pls 120.20.12010000.3 2008/10/01 22:47:29 rkuttiya ship $ */
3: ----------------------------------------------------------------------------
4: -- Global Message Constants
5: ----------------------------------------------------------------------------

Line 2578: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Begin Activating IA');

2574: -- Initialize API status to success
2575: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2576:
2577: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2578: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Begin Activating IA');
2579: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug','p_khr_id:'|| p_khr_id);
2580: END IF;
2581:
2582: /*** Begin API body ****************************************************/

Line 2579: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug','p_khr_id:'|| p_khr_id);

2575: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2576:
2577: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2578: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Begin Activating IA');
2579: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug','p_khr_id:'|| p_khr_id);
2580: END IF;
2581:
2582: /*** Begin API body ****************************************************/
2583: /* process steps

Line 2605: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '1. CREATE a TRANSACTION FOR entire pool BY pol_id: START');

2601: ----------------------------------------------------------------------------
2602: --dbms_output.put_line('1. CREATE a TRANSACTION FOR entire pool BY pol_id');
2603: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction START');
2604: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2605: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '1. CREATE a TRANSACTION FOR entire pool BY pol_id: START');
2606: END IF;
2607: OPEN c_pool;
2608: FETCH c_pool INTO l_pol_id,
2609: l_currency_code,

Line 2615: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);

2611: l_legal_entity_id;
2612: l_row_found := c_pool%FOUND;
2613: CLOSE c_pool;
2614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2615: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2616: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_currency_code :' || l_currency_code);
2617: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_org_id :' || l_org_id);
2618: END IF;
2619:

Line 2616: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_currency_code :' || l_currency_code);

2612: l_row_found := c_pool%FOUND;
2613: CLOSE c_pool;
2614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2615: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2616: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_currency_code :' || l_currency_code);
2617: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_org_id :' || l_org_id);
2618: END IF;
2619:
2620: --dbms_output.put_line('l_pol_id' || l_pol_id);

Line 2617: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_org_id :' || l_org_id);

2613: CLOSE c_pool;
2614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2615: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2616: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_currency_code :' || l_currency_code);
2617: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_org_id :' || l_org_id);
2618: END IF;
2619:
2620: --dbms_output.put_line('l_pol_id' || l_pol_id);
2621: --dbms_output.put_line('l_currency_code'|| l_currency_code);

Line 2636: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');

2632: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_COMPLETE;
2633: --added abhsaxen for Legal Entity Uptake
2634: lp_poxv_rec.LEGAL_ENTITY_ID := l_legal_entity_id;
2635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2636: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');
2637: END IF;
2638:
2639: OKL_POOL_PVT.create_pool_transaction(
2640: p_api_version => p_api_version,

Line 2648: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);

2644: x_msg_data => x_msg_data,
2645: p_poxv_rec => lp_poxv_rec,
2646: x_poxv_rec => lx_poxv_rec);
2647: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2648: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2649: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction x_return_status :' || x_return_status);
2650: END IF;
2651:
2652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2649: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction x_return_status :' || x_return_status);

2645: p_poxv_rec => lp_poxv_rec,
2646: x_poxv_rec => lx_poxv_rec);
2647: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2648: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2649: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction x_return_status :' || x_return_status);
2650: END IF;
2651:
2652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2660: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');

2656: END IF;
2657: END IF;
2658: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction END');
2659: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2660: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');
2661: END IF;
2662:
2663: ----------------------------------------------------------------------------
2664: -- get pox_id after create trx entry

Line 2672: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '2. update pool contents to point to this transaction');

2668: -- loop
2669: --dbms_output.put_line('2. update pool contents to point to this transaction');
2670: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2671: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2672: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '2. update pool contents to point to this transaction');
2673: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_contents: START');
2674: END IF;
2675:
2676: OPEN c_poc;

Line 2673: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_contents: START');

2669: --dbms_output.put_line('2. update pool contents to point to this transaction');
2670: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2671: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2672: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '2. update pool contents to point to this transaction');
2673: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_contents: START');
2674: END IF;
2675:
2676: OPEN c_poc;
2677: LOOP

Line 2683: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);

2679: l_poc_id;
2680: EXIT WHEN c_poc%NOTFOUND;
2681:
2682: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2683: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2684: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2685: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.id :' || lx_poxv_rec.id);
2686: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.TRANSACTION_NUMBER' ||lx_poxv_rec.TRANSACTION_NUMBER);
2687: END IF;

Line 2684: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);

2680: EXIT WHEN c_poc%NOTFOUND;
2681:
2682: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2683: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2684: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2685: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.id :' || lx_poxv_rec.id);
2686: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.TRANSACTION_NUMBER' ||lx_poxv_rec.TRANSACTION_NUMBER);
2687: END IF;
2688:

Line 2685: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.id :' || lx_poxv_rec.id);

2681:
2682: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2683: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2684: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2685: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.id :' || lx_poxv_rec.id);
2686: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.TRANSACTION_NUMBER' ||lx_poxv_rec.TRANSACTION_NUMBER);
2687: END IF;
2688:
2689: lp_pocv_rec.ID := l_poc_id;

Line 2686: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.TRANSACTION_NUMBER' ||lx_poxv_rec.TRANSACTION_NUMBER);

2682: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2683: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2684: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2685: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.id :' || lx_poxv_rec.id);
2686: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'lx_poxv_rec.TRANSACTION_NUMBER' ||lx_poxv_rec.TRANSACTION_NUMBER);
2687: END IF;
2688:
2689: lp_pocv_rec.ID := l_poc_id;
2690: lp_pocv_rec.POL_ID := l_pol_id;

Line 2704: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);

2700: p_pocv_rec => lp_pocv_rec,
2701: x_pocv_rec => lx_pocv_rec);
2702:
2703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2704: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2705: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents x_return_status :' || x_return_status);
2706: END IF;
2707:
2708: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2705: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents x_return_status :' || x_return_status);

2701: x_pocv_rec => lx_pocv_rec);
2702:
2703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2704: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2705: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents x_return_status :' || x_return_status);
2706: END IF;
2707:
2708: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2717: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');

2713:
2714: END LOOP;
2715: CLOSE c_poc;
2716: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2717: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');
2718: END IF;
2719:
2720: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents End');
2721:

Line 2728: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');

2724: ----------------------------------------------------------------------------
2725: --dbms_output.put_line('3. Mark associated contract to securtizated');
2726: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2727: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2728: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2729: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_contract_pub.update_contract_header: START');
2730: END IF;
2731:
2732:

Line 2729: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_contract_pub.update_contract_header: START');

2725: --dbms_output.put_line('3. Mark associated contract to securtizated');
2726: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2727: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2728: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2729: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_contract_pub.update_contract_header: START');
2730: END IF;
2731:
2732:
2733: OPEN c_pool_chr;

Line 2740: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_chr_id :' || l_chr_id);

2736: l_chr_id;
2737: EXIT WHEN c_pool_chr%NOTFOUND;
2738:
2739: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2740: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_chr_id :' || l_chr_id);
2741: END IF;
2742:
2743: lp_chrv_rec.id := l_chr_id;
2744: lp_khrv_rec.id := l_chr_id;

Line 2759: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);

2755: x_chrv_rec => lx_chrv_rec,
2756: x_khrv_rec => lx_khrv_rec);
2757:
2758: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2759: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);
2760: END IF;
2761:
2762: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2771: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header: END');

2767:
2768: END LOOP;
2769: CLOSE c_pool_chr;
2770: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2771: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header: END');
2772: END IF;
2773:
2774: -- gboomina added for Bug 6763287 - Start
2775: ----------------------------------------------------------------------------

Line 2779: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '4 call Streams Generator API to generate streams for income and expense fees: START');

2775: ----------------------------------------------------------------------------
2776: --4 call Streams Generator API to generate streams for income and expense fees
2777: ----------------------------------------------------------------------------
2778: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2779: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '4 call Streams Generator API to generate streams for income and expense fees: START');
2780: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.generate_streams_for_IA');
2781: END IF;
2782: OKL_STREAM_GENERATOR_PVT.generate_streams_for_IA(
2783: p_api_version => p_api_version,

Line 2780: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.generate_streams_for_IA');

2776: --4 call Streams Generator API to generate streams for income and expense fees
2777: ----------------------------------------------------------------------------
2778: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2779: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '4 call Streams Generator API to generate streams for income and expense fees: START');
2780: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.generate_streams_for_IA');
2781: END IF;
2782: OKL_STREAM_GENERATOR_PVT.generate_streams_for_IA(
2783: p_api_version => p_api_version,
2784: p_init_msg_list => p_init_msg_list,

Line 2791: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.generate_streams_for_IA x_return_status :' || x_return_status);

2787: x_msg_count => x_msg_count ,
2788: x_msg_data => x_msg_data );
2789:
2790: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2791: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.generate_streams_for_IA x_return_status :' || x_return_status);
2792: END IF;
2793:
2794: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2800: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '4 call Streams Generator API to generate streams for income and expense fees: END');

2796: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2797: RAISE OKL_API.G_EXCEPTION_ERROR;
2798: END IF;
2799: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2800: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '4 call Streams Generator API to generate streams for income and expense fees: END');
2801: END IF;
2802: -- gboomina added for Bug 6763287 - End
2803: -- added by zrehman for making entry into okl_k_control Bug#6788005 on 07-Feb-2008 start
2804: OKL_BILLING_CONTROLLER_PVT.track_next_bill_date(p_khr_id);

Line 2812: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '5 call Streams Generator API to generate disbursement basis streams.');

2808: --5 call Streams Generator API to generate disbursement basis streams
2809: --
2810: ----------------------------------------------------------------------------
2811: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2812: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '5 call Streams Generator API to generate disbursement basis streams.');
2813: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.create_disb_streams: START');
2814: END IF;
2815:
2816: OKL_STREAM_GENERATOR_PVT.create_disb_streams(

Line 2813: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.create_disb_streams: START');

2809: --
2810: ----------------------------------------------------------------------------
2811: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2812: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '5 call Streams Generator API to generate disbursement basis streams.');
2813: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.create_disb_streams: START');
2814: END IF;
2815:
2816: OKL_STREAM_GENERATOR_PVT.create_disb_streams(
2817: p_api_version => p_api_version,

Line 2824: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_disb_streams x_return_status :' || x_return_status);

2820: x_return_status => x_return_status,
2821: x_msg_count => x_msg_count ,
2822: x_msg_data => x_msg_data );
2823: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2824: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_disb_streams x_return_status :' || x_return_status);
2825: END IF;
2826:
2827: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2828: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2833: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '5 call Streams Generator API to generate disbursement basis streams: END');

2829: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2830: RAISE OKL_API.G_EXCEPTION_ERROR;
2831: END IF;
2832: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2833: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '5 call Streams Generator API to generate disbursement basis streams: END');
2834: END IF;
2835:
2836: ----------------------------------------------------------------------------
2837:

Line 2842: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '6 call Streams Generator API to generate PV Streams of Securitized Streams: START');

2838: --6 call Streams Generator API to generate PV Streams of Securitized Streams
2839: --
2840: ----------------------------------------------------------------------------
2841: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2842: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '6 call Streams Generator API to generate PV Streams of Securitized Streams: START');
2843: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.create_pv_streams');
2844: END IF;
2845:
2846: OKL_STREAM_GENERATOR_PVT.create_pv_streams(

Line 2843: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.create_pv_streams');

2839: --
2840: ----------------------------------------------------------------------------
2841: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2842: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '6 call Streams Generator API to generate PV Streams of Securitized Streams: START');
2843: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_stream_generator_pvt.create_pv_streams');
2844: END IF;
2845:
2846: OKL_STREAM_GENERATOR_PVT.create_pv_streams(
2847: p_api_version => p_api_version,

Line 2854: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);

2850: x_return_status => x_return_status,
2851: x_msg_count => x_msg_count ,
2852: x_msg_data => x_msg_data );
2853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2854: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);
2855: END IF;
2856:
2857: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2858: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2863: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '6 call Streams Generator API to generate PV Streams of Securitized Streams: END');

2859: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2860: RAISE OKL_API.G_EXCEPTION_ERROR;
2861: END IF;
2862: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2863: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '6 call Streams Generator API to generate PV Streams of Securitized Streams: END');
2864: END IF;
2865:
2866:
2867: ----------------------------------------------------------------------------

Line 2873: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: START');

2869: --
2870: ----------------------------------------------------------------------------
2871: --dbms_output.put_line('OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS begin');
2872: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2873: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: START');
2874: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_accrual_sec_pvt.create_streams');
2875: END IF;
2876:
2877:

Line 2874: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_accrual_sec_pvt.create_streams');

2870: ----------------------------------------------------------------------------
2871: --dbms_output.put_line('OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS begin');
2872: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2873: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: START');
2874: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_accrual_sec_pvt.create_streams');
2875: END IF;
2876:
2877:
2878: -- OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS(

Line 2894: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_pv_streams p_khr_id:' || p_khr_id);

2890: x_msg_data => x_msg_data,
2891: p_khr_id => p_khr_id);
2892:
2893: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2894: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_pv_streams p_khr_id:' || p_khr_id);
2895: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);
2896: END IF;
2897:
2898: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2895: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);

2891: p_khr_id => p_khr_id);
2892:
2893: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2894: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_pv_streams p_khr_id:' || p_khr_id);
2895: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);
2896: END IF;
2897:
2898: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2908: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: END');

2904: EXIT WHEN l_okl_sty_csr%FOUND;
2905: END LOOP;
2906: -- mvasudev, end, 10/29/2003
2907: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2908: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: END');
2909: END IF;
2910:
2911: --dbms_output.put_line('OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS end');
2912: ----------------------------------------------------------------------------

Line 2918: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: START');

2914: --
2915: ----------------------------------------------------------------------------
2916: --dbms_output.put_line('Okl_Investor_Billing_Pvt.create_investor_bill begin');
2917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2918: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: START');
2919: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Investor_Billing_Pvt.create_investor_bill');
2920: END IF;
2921:
2922: Okl_Investor_Billing_Pvt.create_investor_bill(

Line 2919: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Investor_Billing_Pvt.create_investor_bill');

2915: ----------------------------------------------------------------------------
2916: --dbms_output.put_line('Okl_Investor_Billing_Pvt.create_investor_bill begin');
2917: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2918: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: START');
2919: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Investor_Billing_Pvt.create_investor_bill');
2920: END IF;
2921:
2922: Okl_Investor_Billing_Pvt.create_investor_bill(
2923: p_api_version => p_api_version,

Line 2931: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill p_khr_id:' || p_khr_id);

2927: x_msg_data => x_msg_data,
2928: p_inv_agr => p_khr_id);
2929:
2930: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2931: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill p_khr_id:' || p_khr_id);
2932: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill x_return_status :' || x_return_status);
2933: END IF;
2934:
2935: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2932: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill x_return_status :' || x_return_status);

2928: p_inv_agr => p_khr_id);
2929:
2930: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2931: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill p_khr_id:' || p_khr_id);
2932: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill x_return_status :' || x_return_status);
2933: END IF;
2934:
2935: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2936: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2942: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: END');

2938: RAISE OKL_API.G_EXCEPTION_ERROR;
2939: END IF;
2940:
2941: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2942: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: END');
2943: END IF;
2944:
2945: --dbms_output.put_line('Okl_Investor_Billing_Pvt.create_investor_bill end');
2946:

Line 2953: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '9 call to the generate_journal_entries: START');

2949: --
2950: ----------------------------------------------------------------------------
2951: --dbms_output.put_line('generate_journal_entries begin');
2952: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2953: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '9 call to the generate_journal_entries: START');
2954: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling generate_journal_entries');
2955: END IF;
2956:
2957: generate_journal_entries(

Line 2954: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling generate_journal_entries');

2950: ----------------------------------------------------------------------------
2951: --dbms_output.put_line('generate_journal_entries begin');
2952: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2953: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '9 call to the generate_journal_entries: START');
2954: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling generate_journal_entries');
2955: END IF;
2956:
2957: generate_journal_entries(
2958: p_api_version => p_api_version,

Line 2967: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill x_return_status :' || x_return_status);

2963: p_contract_id => p_khr_id
2964: ,p_transaction_type => G_TRY_TYPE_INV);
2965:
2966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2967: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill x_return_status :' || x_return_status);
2968: END IF;
2969:
2970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2977: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '9 call to the generate_journal_entries: END');

2973: RAISE OKL_API.G_EXCEPTION_ERROR;
2974: END IF;
2975:
2976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2977: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '9 call to the generate_journal_entries: END');
2978: END IF;
2979:
2980: --dbms_output.put_line('generate_journal_entries end');
2981: ----------------------------------------------------------------------------

Line 2985: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts begin');

2981: ----------------------------------------------------------------------------
2982: --10 call update_sec_agreement_sts to update agreement header, lines
2983: --
2984: ----------------------------------------------------------------------------
2985: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts begin');
2986:
2987: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2988: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: START');
2989: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Sec_Agreement_Pvt.update_sec_agreement_sts');

Line 2988: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: START');

2984: ----------------------------------------------------------------------------
2985: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts begin');
2986:
2987: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2988: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: START');
2989: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Sec_Agreement_Pvt.update_sec_agreement_sts');
2990: END IF;
2991:
2992: Okl_Sec_Agreement_Pvt.update_sec_agreement_sts(

Line 2989: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Sec_Agreement_Pvt.update_sec_agreement_sts');

2985: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts begin');
2986:
2987: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2988: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: START');
2989: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Sec_Agreement_Pvt.update_sec_agreement_sts');
2990: END IF;
2991:
2992: Okl_Sec_Agreement_Pvt.update_sec_agreement_sts(
2993: p_api_version => p_api_version,

Line 2992: Okl_Sec_Agreement_Pvt.update_sec_agreement_sts(

2988: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: START');
2989: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling Okl_Sec_Agreement_Pvt.update_sec_agreement_sts');
2990: END IF;
2991:
2992: Okl_Sec_Agreement_Pvt.update_sec_agreement_sts(
2993: p_api_version => p_api_version,
2994: p_init_msg_list => p_init_msg_list,
2995: x_return_status => x_return_status,
2996: x_msg_count => x_msg_count,

Line 3002: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Sec_Agreement_Pvt.update_sec_agreement_sts x_return_status :' || x_return_status);

2998: p_sec_agreement_status => G_STS_CODE_ACTIVE,
2999: p_sec_agreement_id => p_khr_id);
3000:
3001: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3002: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Okl_Sec_Agreement_Pvt.update_sec_agreement_sts x_return_status :' || x_return_status);
3003: END IF;
3004:
3005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3012: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: END');

3008: RAISE OKL_API.G_EXCEPTION_ERROR;
3009: END IF;
3010:
3011: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3012: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: END');
3013: END IF;
3014: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts end');
3015:
3016: ----------------------------------------------------------------------------

Line 3014: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts end');

3010:
3011: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3012: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '10 call update_sec_agreement_sts to update agreement header, lines: END');
3013: END IF;
3014: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts end');
3015:
3016: ----------------------------------------------------------------------------
3017: --11 update pool header and contents status to active
3018: ----------------------------------------------------------------------------

Line 3020: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: START');

3016: ----------------------------------------------------------------------------
3017: --11 update pool header and contents status to active
3018: ----------------------------------------------------------------------------
3019: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3020: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: START');
3021: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_status_active');
3022: END IF;
3023:
3024: OKL_POOL_PVT.update_pool_status_active(

Line 3021: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_status_active');

3017: --11 update pool header and contents status to active
3018: ----------------------------------------------------------------------------
3019: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3020: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: START');
3021: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling OKL_POOL_PVT.update_pool_status_active');
3022: END IF;
3023:
3024: OKL_POOL_PVT.update_pool_status_active(
3025: p_api_version => p_api_version,

Line 3033: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);

3029: x_msg_data => x_msg_data,
3030: p_pol_id => l_pol_id);
3031:
3032: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3033: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);
3034: END IF;
3035:
3036: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3037: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3043: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: END');

3039: RAISE OKL_API.G_EXCEPTION_ERROR;
3040: END IF;
3041:
3042: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3043: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: END');
3044: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'End of Activating IA, completed Successfully');
3045: END IF;
3046:
3047:

Line 3044: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'End of Activating IA, completed Successfully');

3040: END IF;
3041:
3042: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3043: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '11 update pool header and contents status to active: END');
3044: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'End of Activating IA, completed Successfully');
3045: END IF;
3046:
3047:
3048: /*** End API body ******************************************************/

Line 3167: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement start');

3163: ----------------------------------------------------------------------------
3164: --1. update agreement contract header status
3165: ----------------------------------------------------------------------------
3166: --dbms_output.put_line('1. update agreement contract header status');
3167: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement start');
3168:
3169: lp_secagreement_rec.ID := p_sec_agreement_id;
3170: lp_secagreement_rec.STS_CODE := p_sec_agreement_status;
3171:

Line 3172: Okl_Sec_Agreement_Pvt.update_sec_agreement(

3168:
3169: lp_secagreement_rec.ID := p_sec_agreement_id;
3170: lp_secagreement_rec.STS_CODE := p_sec_agreement_status;
3171:
3172: Okl_Sec_Agreement_Pvt.update_sec_agreement(
3173: p_api_version => p_api_version,
3174: p_init_msg_list => p_init_msg_list,
3175: x_return_status => x_return_status,
3176: x_msg_count => x_msg_count,

Line 3186: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement end');

3182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3183: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3184: RAISE OKL_API.G_EXCEPTION_ERROR;
3185: END IF;
3186: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement end');
3187:
3188: ----------------------------------------------------------------------------
3189: --2. update agreement contract header lines status
3190: -- cascade update all associated line sts_code to active

Line 3533: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Begin Processing Add Request');

3529: -- Initialize API status to success
3530: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3531:
3532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3533: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Begin Processing Add Request');
3534: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug','p_khr_id:'|| p_khr_id);
3535: END IF;
3536:
3537: /*** Begin API body ****************************************************/

Line 3534: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug','p_khr_id:'|| p_khr_id);

3530: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3531:
3532: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3533: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Begin Processing Add Request');
3534: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug','p_khr_id:'|| p_khr_id);
3535: END IF;
3536:
3537: /*** Begin API body ****************************************************/
3538: /* process steps

Line 3555: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '1. Validate the add request.');

3551: ----------------------------------------------------------------------------
3552: --1 Validate the add request
3553: ----------------------------------------------------------------------------
3554: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3555: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '1. Validate the add request.');
3556: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling validate_add_request: START');
3557: END IF;
3558:
3559: --Fetch the pool id from the Investor Agreement Id passed

Line 3556: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling validate_add_request: START');

3552: --1 Validate the add request
3553: ----------------------------------------------------------------------------
3554: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3555: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '1. Validate the add request.');
3556: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling validate_add_request: START');
3557: END IF;
3558:
3559: --Fetch the pool id from the Investor Agreement Id passed
3560: FOR c_pool_rec IN c_pool_csr(p_khr_id)

Line 3598: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'validate_add_request x_return_status :' || x_return_status);

3594: x_msg_data => x_msg_data,
3595: p_chr_id => p_khr_id);
3596:
3597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3598: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'validate_add_request x_return_status :' || x_return_status);
3599: END IF;
3600:
3601: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3602: --Update the status of the Pool Transaction to INCOMPLETE and Halt processing

Line 3629: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '2. Mark associated contract to securtizated.');

3625: ----------------------------------------------------------------------------
3626: --2 Mark associated contract to securitizated
3627: ----------------------------------------------------------------------------
3628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3629: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '2. Mark associated contract to securtizated.');
3630: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_contract_pub.update_contract_header: START');
3631: END IF;
3632:
3633: OPEN c_pool_chr_csr(l_pol_id);

Line 3630: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_contract_pub.update_contract_header: START');

3626: --2 Mark associated contract to securitizated
3627: ----------------------------------------------------------------------------
3628: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3629: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '2. Mark associated contract to securtizated.');
3630: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_contract_pub.update_contract_header: START');
3631: END IF;
3632:
3633: OPEN c_pool_chr_csr(l_pol_id);
3634: LOOP

Line 3639: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'l_chr_id :' || l_chr_id);

3635: FETCH c_pool_chr_csr INTO l_chr_id,l_poc_id;
3636: EXIT WHEN c_pool_chr_csr%NOTFOUND;
3637:
3638: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3639: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'l_chr_id :' || l_chr_id);
3640: END IF;
3641:
3642: lp_chrv_rec.id := l_chr_id;
3643: lp_khrv_rec.id := l_chr_id;

Line 3658: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);

3654: x_chrv_rec => lx_chrv_rec,
3655: x_khrv_rec => lx_khrv_rec);
3656:
3657: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3658: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header x_return_status :' || x_return_status);
3659: END IF;
3660:
3661: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3662: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3670: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header: END');

3666:
3667: END LOOP;
3668: CLOSE c_pool_chr_csr;
3669: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3670: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header: END');
3671: END IF;
3672:
3673:
3674: ----------------------------------------------------------------------------

Line 3680: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '3 call Streams Generator API to generate disbursement basis streams.');

3676: -- 3. call Streams Generator API to generate disbursement basis streams
3677: --
3678: ----------------------------------------------------------------------------
3679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3680: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '3 call Streams Generator API to generate disbursement basis streams.');
3681: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_stream_generator_pvt.create_disb_streams: START');
3682: END IF;
3683:
3684: OKL_STREAM_GENERATOR_PVT.create_disb_streams(

Line 3681: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_stream_generator_pvt.create_disb_streams: START');

3677: --
3678: ----------------------------------------------------------------------------
3679: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3680: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '3 call Streams Generator API to generate disbursement basis streams.');
3681: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_stream_generator_pvt.create_disb_streams: START');
3682: END IF;
3683:
3684: OKL_STREAM_GENERATOR_PVT.create_disb_streams(
3685: p_api_version => p_api_version,

Line 3695: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_disb_streams x_return_status :' || x_return_status);

3691: x_msg_count => x_msg_count ,
3692: x_msg_data => x_msg_data );
3693:
3694: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3695: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_disb_streams x_return_status :' || x_return_status);
3696: END IF;
3697:
3698: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3705: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '3 call Streams Generator API to generate disbursement basis streams: END');

3701: RAISE OKL_API.G_EXCEPTION_ERROR;
3702: END IF;
3703:
3704: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3705: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '3 call Streams Generator API to generate disbursement basis streams: END');
3706: END IF;
3707:
3708: ----------------------------------------------------------------------------
3709:

Line 3714: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '4 call Streams Generator API to generate PV Streams of Securitized Streams: START');

3710: --4 call Streams Generator API to generate PV Streams of Securitized Streams
3711: --
3712: ----------------------------------------------------------------------------
3713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3714: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '4 call Streams Generator API to generate PV Streams of Securitized Streams: START');
3715: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_stream_generator_pvt.create_pv_streams');
3716: END IF;
3717:
3718: OKL_STREAM_GENERATOR_PVT.create_pv_streams(

Line 3715: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_stream_generator_pvt.create_pv_streams');

3711: --
3712: ----------------------------------------------------------------------------
3713: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3714: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '4 call Streams Generator API to generate PV Streams of Securitized Streams: START');
3715: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_stream_generator_pvt.create_pv_streams');
3716: END IF;
3717:
3718: OKL_STREAM_GENERATOR_PVT.create_pv_streams(
3719: p_api_version => p_api_version,

Line 3729: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);

3725: x_msg_count => x_msg_count ,
3726: x_msg_data => x_msg_data );
3727:
3728: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3729: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);
3730: END IF;
3731:
3732: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3733: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3739: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '4 call Streams Generator API to generate PV Streams of Securitized Streams: END');

3735: RAISE OKL_API.G_EXCEPTION_ERROR;
3736: END IF;
3737:
3738: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3739: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '4 call Streams Generator API to generate PV Streams of Securitized Streams: END');
3740: END IF;
3741:
3742:
3743: ----------------------------------------------------------------------------

Line 3748: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: START');

3744: --5 call Accrual API
3745: --
3746: ----------------------------------------------------------------------------
3747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3748: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: START');
3749: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_accrual_sec_pvt.create_streams');
3750: END IF;
3751:
3752:

Line 3749: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_accrual_sec_pvt.create_streams');

3745: --
3746: ----------------------------------------------------------------------------
3747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3748: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: START');
3749: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_accrual_sec_pvt.create_streams');
3750: END IF;
3751:
3752:
3753: -- mvasudev, 10/29/2003

Line 3768: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_pv_streams p_khr_id:' || p_khr_id);

3764: p_khr_id => p_khr_id,
3765: p_mode => 'ACTIVE');
3766:
3767: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3768: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_pv_streams p_khr_id:' || p_khr_id);
3769: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);
3770: END IF;
3771:
3772: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3769: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);

3765: p_mode => 'ACTIVE');
3766:
3767: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3768: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_pv_streams p_khr_id:' || p_khr_id);
3769: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_stream_generator_pvt.create_pv_streams x_return_status :' || x_return_status);
3770: END IF;
3771:
3772: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3782: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: END');

3778: EXIT WHEN l_okl_sty_csr%FOUND;
3779: END LOOP;
3780: -- mvasudev, end, 10/29/2003
3781: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3782: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: END');
3783: END IF;
3784:
3785: ----------------------------------------------------------------------------
3786: --6 call generate_journal_entries

Line 3790: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '6 call to the generate_journal_entries: START');

3786: --6 call generate_journal_entries
3787: --
3788: ----------------------------------------------------------------------------
3789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3790: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '6 call to the generate_journal_entries: START');
3791: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling generate_journal_entries');
3792: END IF;
3793:
3794: generate_journal_entries(

Line 3791: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling generate_journal_entries');

3787: --
3788: ----------------------------------------------------------------------------
3789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3790: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '6 call to the generate_journal_entries: START');
3791: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling generate_journal_entries');
3792: END IF;
3793:
3794: generate_journal_entries(
3795: p_api_version => p_api_version,

Line 3804: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'generate_journal_entries x_return_status :' || x_return_status);

3800: p_contract_id => p_khr_id
3801: ,p_transaction_type => G_TRY_TYPE_INV);
3802:
3803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3804: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'generate_journal_entries x_return_status :' || x_return_status);
3805: END IF;
3806:
3807: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3808: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3814: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '6 call to the generate_journal_entries: END');

3810: RAISE OKL_API.G_EXCEPTION_ERROR;
3811: END IF;
3812:
3813: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3814: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '6 call to the generate_journal_entries: END');
3815: END IF;
3816:
3817: ----------------------------------------------------------------------------
3818: --7 call BPD AR api

Line 3822: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: START');

3818: --7 call BPD AR api
3819: --
3820: ----------------------------------------------------------------------------
3821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3822: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: START');
3823: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling Okl_Investor_Billing_Pvt.create_investor_bill');
3824: END IF;
3825:
3826: Okl_Investor_Billing_Pvt.create_investor_bill(

Line 3823: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling Okl_Investor_Billing_Pvt.create_investor_bill');

3819: --
3820: ----------------------------------------------------------------------------
3821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3822: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: START');
3823: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling Okl_Investor_Billing_Pvt.create_investor_bill');
3824: END IF;
3825:
3826: Okl_Investor_Billing_Pvt.create_investor_bill(
3827: p_api_version => p_api_version,

Line 3835: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill p_khr_id:' || p_khr_id);

3831: x_msg_data => x_msg_data,
3832: p_inv_agr => p_khr_id);
3833:
3834: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3835: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill p_khr_id:' || p_khr_id);
3836: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill x_return_status :' || x_return_status);
3837: END IF;
3838:
3839: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3836: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill x_return_status :' || x_return_status);

3832: p_inv_agr => p_khr_id);
3833:
3834: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3835: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill p_khr_id:' || p_khr_id);
3836: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Investor_Billing_Pvt.create_investor_bill x_return_status :' || x_return_status);
3837: END IF;
3838:
3839: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3840: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3846: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: END');

3842: RAISE OKL_API.G_EXCEPTION_ERROR;
3843: END IF;
3844:
3845: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3846: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: END');
3847: END IF;
3848:
3849: --Update the total stake to include the additional stake
3850: FOR get_inv_stake_rec IN get_inv_stake_csr(p_khr_id)

Line 3853: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');

3849: --Update the total stake to include the additional stake
3850: FOR get_inv_stake_rec IN get_inv_stake_csr(p_khr_id)
3851: LOOP
3852: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3853: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
3854: END IF;
3855:
3856: --Only if an additional stake amount has been captured, then add this stake to the original stake
3857: IF get_inv_stake_rec.additional_stake IS NOT NULL THEN

Line 3875: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Sec_Investor_Pvt.update_investor' || x_return_status);

3871: x_clev_rec => lx_clev_rec,
3872: x_klev_rec => lx_klev_rec);
3873:
3874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3875: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Okl_Sec_Investor_Pvt.update_investor' || x_return_status);
3876: END IF;
3877:
3878: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3879: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3893: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool contents status to active: START');

3889: ----------------------------------------------------------------------------------
3890: --8 update pool contents status to active and pool transactions status to COMPLETE
3891: ----------------------------------------------------------------------------------
3892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3893: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool contents status to active: START');
3894: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');
3895: END IF;
3896:
3897: --Update pool contents to ACTIVE

Line 3894: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');

3890: --8 update pool contents status to active and pool transactions status to COMPLETE
3891: ----------------------------------------------------------------------------------
3892: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3893: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool contents status to active: START');
3894: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');
3895: END IF;
3896:
3897: --Update pool contents to ACTIVE
3898: FOR c_pool_chr_rec IN c_pool_chr_csr(l_pol_id)

Line 3913: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);

3909: p_pocv_rec => lp_pocv_rec,
3910: x_pocv_rec => lx_pocv_rec);
3911:
3912: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3913: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_status_active x_return_status :' || x_return_status);
3914: END IF;
3915:
3916:
3917: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 3926: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');

3922: END LOOP;
3923:
3924:
3925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3926: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');
3927: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');
3928: END IF;
3929:
3930: --Update pool transaction to COMPLETE

Line 3927: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');

3923:
3924:
3925: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3926: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');
3927: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');
3928: END IF;
3929:
3930: --Update pool transaction to COMPLETE
3931: lp_poxv_rec.id := l_pox_id;

Line 3950: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_transaction x_return_status :' || x_return_status);

3946: END IF;
3947:
3948:
3949: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3950: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_POOL_PVT.update_pool_transaction x_return_status :' || x_return_status);
3951: END IF;
3952:
3953: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3960: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Update investor stake');

3956: RAISE OKL_API.G_EXCEPTION_ERROR;
3957: END IF;
3958:
3959: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3960: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Update investor stake');
3961: END IF;
3962:
3963: /*** End API body ******************************************************/
3964:

Line 4072: -- fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.submit_add_khr_request.debug', 'Okl_Sec_Agreement_Pvt.submit_add_khr_request x_return_status :' || x_return_status);

4068: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4069: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4070: RAISE OKL_API.G_EXCEPTION_ERROR;
4071: END IF;
4072: -- fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.submit_add_khr_request.debug', 'Okl_Sec_Agreement_Pvt.submit_add_khr_request x_return_status :' || x_return_status);
4073:
4074: -- read the profile OKL: Investor Add Contracts Approval Process
4075: l_approval_process := fnd_profile.value('OKL_IA_ADD_KHR_APPR_PROCESS');
4076:

Line 4391: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');

4387: --Update the additional stake on removing transaction
4388: FOR get_inv_stake_rec IN get_inv_stake_csr(p_chr_id)
4389: LOOP
4390: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4391: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
4392: END IF;
4393:
4394:
4395: --Remove the additional stake amount

Line 4413: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.cancel_add_request.debug', 'Okl_Sec_Investor_Pvt.update_investor' || x_return_status);

4409: x_clev_rec => lx_clev_rec,
4410: x_klev_rec => lx_klev_rec);
4411:
4412: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4413: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.cancel_add_request.debug', 'Okl_Sec_Investor_Pvt.update_investor' || x_return_status);
4414: END IF;
4415:
4416: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4417: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 4464: END Okl_Sec_Agreement_Pvt;

4460: END cancel_add_request;
4461: /*sosharma end changes*/
4462:
4463:
4464: END Okl_Sec_Agreement_Pvt;