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 FND_LOG

Line 2594: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2590:
2591: -- Initialize API status to success
2592: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2593:
2594: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2595: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Begin Activating IA');
2596: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug','p_khr_id:'|| p_khr_id);
2597: END IF;
2598:

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

2591: -- Initialize API status to success
2592: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2593:
2594: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2595: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Begin Activating IA');
2596: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug','p_khr_id:'|| p_khr_id);
2597: END IF;
2598:
2599: /*** Begin API body ****************************************************/

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

2592: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2593:
2594: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2595: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Begin Activating IA');
2596: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug','p_khr_id:'|| p_khr_id);
2597: END IF;
2598:
2599: /*** Begin API body ****************************************************/
2600: /* process steps

Line 2621: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2617: --OKL_POOL_TRANSACTION_TYPE
2618: ----------------------------------------------------------------------------
2619: --dbms_output.put_line('1. CREATE a TRANSACTION FOR entire pool BY pol_id');
2620: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction START');
2621: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2622: 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');
2623: END IF;
2624: OPEN c_pool;
2625: FETCH c_pool INTO l_pol_id,

Line 2622: 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');

2618: ----------------------------------------------------------------------------
2619: --dbms_output.put_line('1. CREATE a TRANSACTION FOR entire pool BY pol_id');
2620: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction START');
2621: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2622: 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');
2623: END IF;
2624: OPEN c_pool;
2625: FETCH c_pool INTO l_pol_id,
2626: l_currency_code,

Line 2631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2627: l_org_id,
2628: l_legal_entity_id;
2629: l_row_found := c_pool%FOUND;
2630: CLOSE c_pool;
2631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2632: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2633: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_currency_code :' || l_currency_code);
2634: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_org_id :' || l_org_id);
2635: END IF;

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

2628: l_legal_entity_id;
2629: l_row_found := c_pool%FOUND;
2630: CLOSE c_pool;
2631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2632: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2633: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_currency_code :' || l_currency_code);
2634: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_org_id :' || l_org_id);
2635: END IF;
2636:

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

2629: l_row_found := c_pool%FOUND;
2630: CLOSE c_pool;
2631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2632: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2633: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_currency_code :' || l_currency_code);
2634: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_org_id :' || l_org_id);
2635: END IF;
2636:
2637: --dbms_output.put_line('l_pol_id' || l_pol_id);

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

2630: CLOSE c_pool;
2631: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2632: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2633: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_currency_code :' || l_currency_code);
2634: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_org_id :' || l_org_id);
2635: END IF;
2636:
2637: --dbms_output.put_line('l_pol_id' || l_pol_id);
2638: --dbms_output.put_line('l_currency_code'|| l_currency_code);

Line 2652: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2648: --sosharma 03/12/2007 added to enable status on pool transaction
2649: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_COMPLETE;
2650: --added abhsaxen for Legal Entity Uptake
2651: lp_poxv_rec.LEGAL_ENTITY_ID := l_legal_entity_id;
2652: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2653: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');
2654: END IF;
2655:
2656: OKL_POOL_PVT.create_pool_transaction(

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

2649: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_COMPLETE;
2650: --added abhsaxen for Legal Entity Uptake
2651: lp_poxv_rec.LEGAL_ENTITY_ID := l_legal_entity_id;
2652: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2653: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_pool_pvt.create_pool_transaction');
2654: END IF;
2655:
2656: OKL_POOL_PVT.create_pool_transaction(
2657: p_api_version => p_api_version,

Line 2664: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2660: x_msg_count => x_msg_count,
2661: x_msg_data => x_msg_data,
2662: p_poxv_rec => lp_poxv_rec,
2663: x_poxv_rec => lx_poxv_rec);
2664: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2665: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2666: 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);
2667: END IF;
2668:

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

2661: x_msg_data => x_msg_data,
2662: p_poxv_rec => lp_poxv_rec,
2663: x_poxv_rec => lx_poxv_rec);
2664: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2665: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2666: 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);
2667: END IF;
2668:
2669: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2666: 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);

2662: p_poxv_rec => lp_poxv_rec,
2663: x_poxv_rec => lx_poxv_rec);
2664: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2665: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2666: 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);
2667: END IF;
2668:
2669: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2672: RAISE OKL_API.G_EXCEPTION_ERROR;
2673: END IF;
2674: END IF;
2675: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction END');
2676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2677: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');
2678: END IF;
2679:
2680: ----------------------------------------------------------------------------

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

2673: END IF;
2674: END IF;
2675: --dbms_output.put_line('OKL_POOL_PVT.create_pool_transaction END');
2676: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2677: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.create_pool_transaction: END');
2678: END IF;
2679:
2680: ----------------------------------------------------------------------------
2681: -- get pox_id after create trx entry

Line 2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2684: ----------------------------------------------------------------------------
2685: -- loop
2686: --dbms_output.put_line('2. update pool contents to point to this transaction');
2687: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2689: 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');
2690: 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');
2691: END IF;
2692:

Line 2689: 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');

2685: -- loop
2686: --dbms_output.put_line('2. update pool contents to point to this transaction');
2687: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2689: 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');
2690: 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');
2691: END IF;
2692:
2693: OPEN c_poc;

Line 2690: 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');

2686: --dbms_output.put_line('2. update pool contents to point to this transaction');
2687: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents Start');
2688: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2689: 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');
2690: 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');
2691: END IF;
2692:
2693: OPEN c_poc;
2694: LOOP

Line 2699: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2695: FETCH c_poc INTO
2696: l_poc_id;
2697: EXIT WHEN c_poc%NOTFOUND;
2698:
2699: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2700: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2701: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2702: 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);
2703: 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);

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

2696: l_poc_id;
2697: EXIT WHEN c_poc%NOTFOUND;
2698:
2699: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2700: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2701: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2702: 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);
2703: 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);
2704: END IF;

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

2697: EXIT WHEN c_poc%NOTFOUND;
2698:
2699: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2700: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2701: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2702: 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);
2703: 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);
2704: END IF;
2705:

Line 2702: 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);

2698:
2699: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2700: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2701: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2702: 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);
2703: 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);
2704: END IF;
2705:
2706: lp_pocv_rec.ID := l_poc_id;

Line 2703: 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);

2699: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2700: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_pol_id :' || l_pol_id);
2701: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2702: 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);
2703: 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);
2704: END IF;
2705:
2706: lp_pocv_rec.ID := l_poc_id;
2707: lp_pocv_rec.POL_ID := l_pol_id;

Line 2720: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2716: x_msg_data => x_msg_data,
2717: p_pocv_rec => lp_pocv_rec,
2718: x_pocv_rec => lx_pocv_rec);
2719:
2720: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2721: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2722: 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);
2723: END IF;
2724:

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

2717: p_pocv_rec => lp_pocv_rec,
2718: x_pocv_rec => lx_pocv_rec);
2719:
2720: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2721: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2722: 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);
2723: END IF;
2724:
2725: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2722: 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);

2718: x_pocv_rec => lx_pocv_rec);
2719:
2720: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2721: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_poc_id :' || l_poc_id);
2722: 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);
2723: END IF;
2724:
2725: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2733: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2729: END IF;
2730:
2731: END LOOP;
2732: CLOSE c_poc;
2733: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2734: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');
2735: END IF;
2736:
2737: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents End');

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

2730:
2731: END LOOP;
2732: CLOSE c_poc;
2733: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2734: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'OKL_POOL_PVT.update_pool_contents : END');
2735: END IF;
2736:
2737: --dbms_output.put_line('OKL_POOL_PVT.update_pool_contents End');
2738:

Line 2744: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2740: --3 Mark associated contract to securitizated
2741: ----------------------------------------------------------------------------
2742: --dbms_output.put_line('3. Mark associated contract to securtizated');
2743: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2744: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2745: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2746: 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');
2747: END IF;
2748:

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

2741: ----------------------------------------------------------------------------
2742: --dbms_output.put_line('3. Mark associated contract to securtizated');
2743: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2744: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2745: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2746: 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');
2747: END IF;
2748:
2749:

Line 2746: 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');

2742: --dbms_output.put_line('3. Mark associated contract to securtizated');
2743: --dbms_output.put_line('okl_contract_pub.update_contract_header start');
2744: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2745: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '3. Mark associated contract to securtizated.');
2746: 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');
2747: END IF;
2748:
2749:
2750: OPEN c_pool_chr;

Line 2756: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2752: FETCH c_pool_chr INTO
2753: l_chr_id;
2754: EXIT WHEN c_pool_chr%NOTFOUND;
2755:
2756: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2757: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_chr_id :' || l_chr_id);
2758: END IF;
2759:
2760: lp_chrv_rec.id := l_chr_id;

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

2753: l_chr_id;
2754: EXIT WHEN c_pool_chr%NOTFOUND;
2755:
2756: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2757: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'l_chr_id :' || l_chr_id);
2758: END IF;
2759:
2760: lp_chrv_rec.id := l_chr_id;
2761: lp_khrv_rec.id := l_chr_id;

Line 2775: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2771: p_khrv_rec => lp_khrv_rec,
2772: x_chrv_rec => lx_chrv_rec,
2773: x_khrv_rec => lx_khrv_rec);
2774:
2775: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2776: 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);
2777: END IF;
2778:
2779: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2776: 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);

2772: x_chrv_rec => lx_chrv_rec,
2773: x_khrv_rec => lx_khrv_rec);
2774:
2775: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2776: 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);
2777: END IF;
2778:
2779: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2787: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2783: END IF;
2784:
2785: END LOOP;
2786: CLOSE c_pool_chr;
2787: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2788: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header: END');
2789: END IF;
2790:
2791: -- gboomina added for Bug 6763287 - Start

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

2784:
2785: END LOOP;
2786: CLOSE c_pool_chr;
2787: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2788: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'okl_contract_pub.update_contract_header: END');
2789: END IF;
2790:
2791: -- gboomina added for Bug 6763287 - Start
2792: ----------------------------------------------------------------------------

Line 2795: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2791: -- gboomina added for Bug 6763287 - Start
2792: ----------------------------------------------------------------------------
2793: --4 call Streams Generator API to generate streams for income and expense fees
2794: ----------------------------------------------------------------------------
2795: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2796: 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');
2797: 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');
2798: END IF;
2799: OKL_STREAM_GENERATOR_PVT.generate_streams_for_IA(

Line 2796: 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');

2792: ----------------------------------------------------------------------------
2793: --4 call Streams Generator API to generate streams for income and expense fees
2794: ----------------------------------------------------------------------------
2795: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2796: 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');
2797: 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');
2798: END IF;
2799: OKL_STREAM_GENERATOR_PVT.generate_streams_for_IA(
2800: p_api_version => p_api_version,

Line 2797: 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');

2793: --4 call Streams Generator API to generate streams for income and expense fees
2794: ----------------------------------------------------------------------------
2795: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2796: 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');
2797: 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');
2798: END IF;
2799: OKL_STREAM_GENERATOR_PVT.generate_streams_for_IA(
2800: p_api_version => p_api_version,
2801: p_init_msg_list => p_init_msg_list,

Line 2807: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2803: x_return_status => x_return_status,
2804: x_msg_count => x_msg_count ,
2805: x_msg_data => x_msg_data );
2806:
2807: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2808: 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);
2809: END IF;
2810:
2811: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2808: 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);

2804: x_msg_count => x_msg_count ,
2805: x_msg_data => x_msg_data );
2806:
2807: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2808: 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);
2809: END IF;
2810:
2811: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2816: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2812: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2813: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2814: RAISE OKL_API.G_EXCEPTION_ERROR;
2815: END IF;
2816: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2817: 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');
2818: END IF;
2819: -- gboomina added for Bug 6763287 - End
2820: -- added by zrehman for making entry into okl_k_control Bug#6788005 on 07-Feb-2008 start

Line 2817: 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');

2813: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2814: RAISE OKL_API.G_EXCEPTION_ERROR;
2815: END IF;
2816: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2817: 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');
2818: END IF;
2819: -- gboomina added for Bug 6763287 - End
2820: -- added by zrehman for making entry into okl_k_control Bug#6788005 on 07-Feb-2008 start
2821: OKL_BILLING_CONTROLLER_PVT.track_next_bill_date(p_khr_id);

Line 2828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2824:
2825: --5 call Streams Generator API to generate disbursement basis streams
2826: --
2827: ----------------------------------------------------------------------------
2828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2829: 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.');
2830: 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');
2831: END IF;
2832:

Line 2829: 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.');

2825: --5 call Streams Generator API to generate disbursement basis streams
2826: --
2827: ----------------------------------------------------------------------------
2828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2829: 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.');
2830: 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');
2831: END IF;
2832:
2833: OKL_STREAM_GENERATOR_PVT.create_disb_streams(

Line 2830: 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');

2826: --
2827: ----------------------------------------------------------------------------
2828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2829: 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.');
2830: 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');
2831: END IF;
2832:
2833: OKL_STREAM_GENERATOR_PVT.create_disb_streams(
2834: p_api_version => p_api_version,

Line 2840: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2836: p_agreement_id => p_khr_id,
2837: x_return_status => x_return_status,
2838: x_msg_count => x_msg_count ,
2839: x_msg_data => x_msg_data );
2840: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2841: 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);
2842: END IF;
2843:
2844: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2841: 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);

2837: x_return_status => x_return_status,
2838: x_msg_count => x_msg_count ,
2839: x_msg_data => x_msg_data );
2840: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2841: 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);
2842: END IF;
2843:
2844: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2849: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;
2849: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2850: 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');
2851: END IF;
2852:
2853: ----------------------------------------------------------------------------

Line 2850: 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');

2846: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;
2849: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2850: 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');
2851: END IF;
2852:
2853: ----------------------------------------------------------------------------
2854:

Line 2858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2854:
2855: --6 call Streams Generator API to generate PV Streams of Securitized Streams
2856: --
2857: ----------------------------------------------------------------------------
2858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2859: 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');
2860: 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');
2861: END IF;
2862:

Line 2859: 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');

2855: --6 call Streams Generator API to generate PV Streams of Securitized Streams
2856: --
2857: ----------------------------------------------------------------------------
2858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2859: 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');
2860: 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');
2861: END IF;
2862:
2863: OKL_STREAM_GENERATOR_PVT.create_pv_streams(

Line 2860: 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');

2856: --
2857: ----------------------------------------------------------------------------
2858: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2859: 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');
2860: 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');
2861: END IF;
2862:
2863: OKL_STREAM_GENERATOR_PVT.create_pv_streams(
2864: p_api_version => p_api_version,

Line 2870: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2866: p_agreement_id => p_khr_id,
2867: x_return_status => x_return_status,
2868: x_msg_count => x_msg_count ,
2869: x_msg_data => x_msg_data );
2870: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2871: 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);
2872: END IF;
2873:
2874: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2871: 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);

2867: x_return_status => x_return_status,
2868: x_msg_count => x_msg_count ,
2869: x_msg_data => x_msg_data );
2870: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2871: 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);
2872: END IF;
2873:
2874: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2879: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2875: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2876: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2877: RAISE OKL_API.G_EXCEPTION_ERROR;
2878: END IF;
2879: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2880: 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');
2881: END IF;
2882:
2883:

Line 2880: 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');

2876: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2877: RAISE OKL_API.G_EXCEPTION_ERROR;
2878: END IF;
2879: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2880: 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');
2881: END IF;
2882:
2883:
2884: ----------------------------------------------------------------------------

Line 2889: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2885: --7 call Accrual API
2886: --
2887: ----------------------------------------------------------------------------
2888: --dbms_output.put_line('OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS begin');
2889: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2890: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: START');
2891: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_accrual_sec_pvt.create_streams');
2892: END IF;
2893:

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

2886: --
2887: ----------------------------------------------------------------------------
2888: --dbms_output.put_line('OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS begin');
2889: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2890: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: START');
2891: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_accrual_sec_pvt.create_streams');
2892: END IF;
2893:
2894:

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

2887: ----------------------------------------------------------------------------
2888: --dbms_output.put_line('OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS begin');
2889: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2890: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: START');
2891: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling okl_accrual_sec_pvt.create_streams');
2892: END IF;
2893:
2894:
2895: -- OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS(

Line 2910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2906: x_msg_count => x_msg_count,
2907: x_msg_data => x_msg_data,
2908: p_khr_id => p_khr_id);
2909:
2910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2911: 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);
2912: 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);
2913: END IF;
2914:

Line 2911: 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);

2907: x_msg_data => x_msg_data,
2908: p_khr_id => p_khr_id);
2909:
2910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2911: 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);
2912: 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);
2913: END IF;
2914:
2915: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2912: 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);

2908: p_khr_id => p_khr_id);
2909:
2910: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2911: 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);
2912: 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);
2913: END IF;
2914:
2915: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2920: -- Fixed Bug#3386816, mvasudev
2921: EXIT WHEN l_okl_sty_csr%FOUND;
2922: END LOOP;
2923: -- mvasudev, end, 10/29/2003
2924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2925: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: END');
2926: END IF;
2927:
2928: --dbms_output.put_line('OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS end');

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

2921: EXIT WHEN l_okl_sty_csr%FOUND;
2922: END LOOP;
2923: -- mvasudev, end, 10/29/2003
2924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2925: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '7 call to the Accrual API: END');
2926: END IF;
2927:
2928: --dbms_output.put_line('OKL_SECURITIZE_ACCRUAL_PVT.CREATE_STREAMS end');
2929: ----------------------------------------------------------------------------

Line 2934: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2930: --8 call BPD AR api
2931: --
2932: ----------------------------------------------------------------------------
2933: --dbms_output.put_line('Okl_Investor_Billing_Pvt.create_investor_bill begin');
2934: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2935: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: START');
2936: 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');
2937: END IF;
2938:

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

2931: --
2932: ----------------------------------------------------------------------------
2933: --dbms_output.put_line('Okl_Investor_Billing_Pvt.create_investor_bill begin');
2934: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2935: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: START');
2936: 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');
2937: END IF;
2938:
2939: Okl_Investor_Billing_Pvt.create_investor_bill(

Line 2936: 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');

2932: ----------------------------------------------------------------------------
2933: --dbms_output.put_line('Okl_Investor_Billing_Pvt.create_investor_bill begin');
2934: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2935: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: START');
2936: 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');
2937: END IF;
2938:
2939: Okl_Investor_Billing_Pvt.create_investor_bill(
2940: p_api_version => p_api_version,

Line 2947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2943: x_msg_count => x_msg_count,
2944: x_msg_data => x_msg_data,
2945: p_inv_agr => p_khr_id);
2946:
2947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2948: 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);
2949: 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);
2950: END IF;
2951:

Line 2948: 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);

2944: x_msg_data => x_msg_data,
2945: p_inv_agr => p_khr_id);
2946:
2947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2948: 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);
2949: 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);
2950: END IF;
2951:
2952: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2949: 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);

2945: p_inv_agr => p_khr_id);
2946:
2947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2948: 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);
2949: 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);
2950: END IF;
2951:
2952: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2953: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2958: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2954: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2955: RAISE OKL_API.G_EXCEPTION_ERROR;
2956: END IF;
2957:
2958: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2959: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: END');
2960: END IF;
2961:
2962: --dbms_output.put_line('Okl_Investor_Billing_Pvt.create_investor_bill end');

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

2955: RAISE OKL_API.G_EXCEPTION_ERROR;
2956: END IF;
2957:
2958: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2959: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', '8 call BPD Billing API: END');
2960: END IF;
2961:
2962: --dbms_output.put_line('Okl_Investor_Billing_Pvt.create_investor_bill end');
2963:

Line 2969: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2965: --9 call generate_journal_entries
2966: --
2967: ----------------------------------------------------------------------------
2968: --dbms_output.put_line('generate_journal_entries begin');
2969: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2970: 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');
2971: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling generate_journal_entries');
2972: END IF;
2973:

Line 2970: 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');

2966: --
2967: ----------------------------------------------------------------------------
2968: --dbms_output.put_line('generate_journal_entries begin');
2969: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2970: 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');
2971: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling generate_journal_entries');
2972: END IF;
2973:
2974: generate_journal_entries(

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

2967: ----------------------------------------------------------------------------
2968: --dbms_output.put_line('generate_journal_entries begin');
2969: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2970: 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');
2971: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'Calling generate_journal_entries');
2972: END IF;
2973:
2974: generate_journal_entries(
2975: p_api_version => p_api_version,

Line 2983: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2979: x_msg_data => x_msg_data,
2980: p_contract_id => p_khr_id
2981: ,p_transaction_type => G_TRY_TYPE_INV);
2982:
2983: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2984: 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);
2985: END IF;
2986:
2987: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2984: 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);

2980: p_contract_id => p_khr_id
2981: ,p_transaction_type => G_TRY_TYPE_INV);
2982:
2983: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2984: 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);
2985: END IF;
2986:
2987: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2988: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2993: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

2989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2990: RAISE OKL_API.G_EXCEPTION_ERROR;
2991: END IF;
2992:
2993: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2994: 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');
2995: END IF;
2996:
2997: --dbms_output.put_line('generate_journal_entries end');

Line 2994: 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');

2990: RAISE OKL_API.G_EXCEPTION_ERROR;
2991: END IF;
2992:
2993: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2994: 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');
2995: END IF;
2996:
2997: --dbms_output.put_line('generate_journal_entries end');
2998: ----------------------------------------------------------------------------

Line 3004: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3000: --
3001: ----------------------------------------------------------------------------
3002: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts begin');
3003:
3004: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3005: 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');
3006: 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');
3007: END IF;
3008:

Line 3005: 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');

3001: ----------------------------------------------------------------------------
3002: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts begin');
3003:
3004: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3005: 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');
3006: 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');
3007: END IF;
3008:
3009: Okl_Sec_Agreement_Pvt.update_sec_agreement_sts(

Line 3006: 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');

3002: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts begin');
3003:
3004: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3005: 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');
3006: 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');
3007: END IF;
3008:
3009: Okl_Sec_Agreement_Pvt.update_sec_agreement_sts(
3010: p_api_version => p_api_version,

Line 3018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3014: x_msg_data => x_msg_data,
3015: p_sec_agreement_status => G_STS_CODE_ACTIVE,
3016: p_sec_agreement_id => p_khr_id);
3017:
3018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3019: 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);
3020: END IF;
3021:
3022: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3019: 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);

3015: p_sec_agreement_status => G_STS_CODE_ACTIVE,
3016: p_sec_agreement_id => p_khr_id);
3017:
3018: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3019: 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);
3020: END IF;
3021:
3022: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3023: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3028: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3024: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3025: RAISE OKL_API.G_EXCEPTION_ERROR;
3026: END IF;
3027:
3028: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3029: 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');
3030: END IF;
3031: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts end');
3032:

Line 3029: 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');

3025: RAISE OKL_API.G_EXCEPTION_ERROR;
3026: END IF;
3027:
3028: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3029: 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');
3030: END IF;
3031: --dbms_output.put_line('OKL_SEC_AGREEMENT_PVT.update_sec_agreement_sts end');
3032:
3033: ----------------------------------------------------------------------------

Line 3036: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3032:
3033: ----------------------------------------------------------------------------
3034: --11 update pool header and contents status to active
3035: ----------------------------------------------------------------------------
3036: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3037: 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');
3038: 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');
3039: END IF;
3040:

Line 3037: 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');

3033: ----------------------------------------------------------------------------
3034: --11 update pool header and contents status to active
3035: ----------------------------------------------------------------------------
3036: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3037: 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');
3038: 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');
3039: END IF;
3040:
3041: OKL_POOL_PVT.update_pool_status_active(

Line 3038: 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');

3034: --11 update pool header and contents status to active
3035: ----------------------------------------------------------------------------
3036: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3037: 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');
3038: 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');
3039: END IF;
3040:
3041: OKL_POOL_PVT.update_pool_status_active(
3042: p_api_version => p_api_version,

Line 3049: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3045: x_msg_count => x_msg_count,
3046: x_msg_data => x_msg_data,
3047: p_pol_id => l_pol_id);
3048:
3049: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3050: 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);
3051: END IF;
3052:
3053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3050: 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);

3046: x_msg_data => x_msg_data,
3047: p_pol_id => l_pol_id);
3048:
3049: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3050: 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);
3051: END IF;
3052:
3053: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3054: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3059: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3055: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3056: RAISE OKL_API.G_EXCEPTION_ERROR;
3057: END IF;
3058:
3059: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3060: 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');
3061: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'End of Activating IA, completed Successfully');
3062: END IF;
3063:

Line 3060: 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');

3056: RAISE OKL_API.G_EXCEPTION_ERROR;
3057: END IF;
3058:
3059: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3060: 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');
3061: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'End of Activating IA, completed Successfully');
3062: END IF;
3063:
3064:

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

3057: END IF;
3058:
3059: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3060: 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');
3061: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_sec_agreement.debug', 'End of Activating IA, completed Successfully');
3062: END IF;
3063:
3064:
3065: /*** End API body ******************************************************/

Line 3549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3545:
3546: -- Initialize API status to success
3547: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3548:
3549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3550: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Begin Processing Add Request');
3551: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug','p_khr_id:'|| p_khr_id);
3552: END IF;
3553:

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

3546: -- Initialize API status to success
3547: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3548:
3549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3550: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Begin Processing Add Request');
3551: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug','p_khr_id:'|| p_khr_id);
3552: END IF;
3553:
3554: /*** Begin API body ****************************************************/

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

3547: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3548:
3549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3550: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Begin Processing Add Request');
3551: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug','p_khr_id:'|| p_khr_id);
3552: END IF;
3553:
3554: /*** Begin API body ****************************************************/
3555: /* process steps

Line 3571: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3567:
3568: ----------------------------------------------------------------------------
3569: --1 Validate the add request
3570: ----------------------------------------------------------------------------
3571: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3572: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '1. Validate the add request.');
3573: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling validate_add_request: START');
3574: END IF;
3575:

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

3568: ----------------------------------------------------------------------------
3569: --1 Validate the add request
3570: ----------------------------------------------------------------------------
3571: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3572: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '1. Validate the add request.');
3573: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling validate_add_request: START');
3574: END IF;
3575:
3576: --Fetch the pool id from the Investor Agreement Id passed

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

3569: --1 Validate the add request
3570: ----------------------------------------------------------------------------
3571: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3572: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '1. Validate the add request.');
3573: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling validate_add_request: START');
3574: END IF;
3575:
3576: --Fetch the pool id from the Investor Agreement Id passed
3577: FOR c_pool_rec IN c_pool_csr(p_khr_id)

Line 3614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3610: x_msg_count => x_msg_count,
3611: x_msg_data => x_msg_data,
3612: p_chr_id => p_khr_id);
3613:
3614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3615: 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);
3616: END IF;
3617:
3618: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

Line 3615: 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);

3611: x_msg_data => x_msg_data,
3612: p_chr_id => p_khr_id);
3613:
3614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3615: 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);
3616: END IF;
3617:
3618: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3619: --Update the status of the Pool Transaction to INCOMPLETE and Halt processing

Line 3645: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3641:
3642: ----------------------------------------------------------------------------
3643: --2 Mark associated contract to securitizated
3644: ----------------------------------------------------------------------------
3645: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3646: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '2. Mark associated contract to securtizated.');
3647: 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');
3648: END IF;
3649:

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

3642: ----------------------------------------------------------------------------
3643: --2 Mark associated contract to securitizated
3644: ----------------------------------------------------------------------------
3645: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3646: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '2. Mark associated contract to securtizated.');
3647: 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');
3648: END IF;
3649:
3650: OPEN c_pool_chr_csr(l_pol_id);

Line 3647: 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');

3643: --2 Mark associated contract to securitizated
3644: ----------------------------------------------------------------------------
3645: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3646: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '2. Mark associated contract to securtizated.');
3647: 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');
3648: END IF;
3649:
3650: OPEN c_pool_chr_csr(l_pol_id);
3651: LOOP

Line 3655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3651: LOOP
3652: FETCH c_pool_chr_csr INTO l_chr_id,l_poc_id;
3653: EXIT WHEN c_pool_chr_csr%NOTFOUND;
3654:
3655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3656: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'l_chr_id :' || l_chr_id);
3657: END IF;
3658:
3659: lp_chrv_rec.id := l_chr_id;

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

3652: FETCH c_pool_chr_csr INTO l_chr_id,l_poc_id;
3653: EXIT WHEN c_pool_chr_csr%NOTFOUND;
3654:
3655: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3656: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'l_chr_id :' || l_chr_id);
3657: END IF;
3658:
3659: lp_chrv_rec.id := l_chr_id;
3660: lp_khrv_rec.id := l_chr_id;

Line 3674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3670: p_khrv_rec => lp_khrv_rec,
3671: x_chrv_rec => lx_chrv_rec,
3672: x_khrv_rec => lx_khrv_rec);
3673:
3674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3675: 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);
3676: END IF;
3677:
3678: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3675: 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);

3671: x_chrv_rec => lx_chrv_rec,
3672: x_khrv_rec => lx_khrv_rec);
3673:
3674: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3675: 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);
3676: END IF;
3677:
3678: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3686: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3682: END IF;
3683:
3684: END LOOP;
3685: CLOSE c_pool_chr_csr;
3686: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3687: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header: END');
3688: END IF;
3689:
3690:

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

3683:
3684: END LOOP;
3685: CLOSE c_pool_chr_csr;
3686: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3687: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'okl_contract_pub.update_contract_header: END');
3688: END IF;
3689:
3690:
3691: ----------------------------------------------------------------------------

Line 3696: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3692:
3693: -- 3. call Streams Generator API to generate disbursement basis streams
3694: --
3695: ----------------------------------------------------------------------------
3696: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3697: 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.');
3698: 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');
3699: END IF;
3700:

Line 3697: 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.');

3693: -- 3. call Streams Generator API to generate disbursement basis streams
3694: --
3695: ----------------------------------------------------------------------------
3696: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3697: 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.');
3698: 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');
3699: END IF;
3700:
3701: OKL_STREAM_GENERATOR_PVT.create_disb_streams(

Line 3698: 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');

3694: --
3695: ----------------------------------------------------------------------------
3696: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3697: 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.');
3698: 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');
3699: END IF;
3700:
3701: OKL_STREAM_GENERATOR_PVT.create_disb_streams(
3702: p_api_version => p_api_version,

Line 3711: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3707: x_return_status => x_return_status,
3708: x_msg_count => x_msg_count ,
3709: x_msg_data => x_msg_data );
3710:
3711: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3712: 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);
3713: END IF;
3714:
3715: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3712: 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);

3708: x_msg_count => x_msg_count ,
3709: x_msg_data => x_msg_data );
3710:
3711: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3712: 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);
3713: END IF;
3714:
3715: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3721: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3717: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3718: RAISE OKL_API.G_EXCEPTION_ERROR;
3719: END IF;
3720:
3721: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3722: 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');
3723: END IF;
3724:
3725: ----------------------------------------------------------------------------

Line 3722: 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');

3718: RAISE OKL_API.G_EXCEPTION_ERROR;
3719: END IF;
3720:
3721: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3722: 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');
3723: END IF;
3724:
3725: ----------------------------------------------------------------------------
3726:

Line 3730: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3726:
3727: --4 call Streams Generator API to generate PV Streams of Securitized Streams
3728: --
3729: ----------------------------------------------------------------------------
3730: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3731: 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');
3732: 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');
3733: END IF;
3734:

Line 3731: 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');

3727: --4 call Streams Generator API to generate PV Streams of Securitized Streams
3728: --
3729: ----------------------------------------------------------------------------
3730: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3731: 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');
3732: 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');
3733: END IF;
3734:
3735: OKL_STREAM_GENERATOR_PVT.create_pv_streams(

Line 3732: 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');

3728: --
3729: ----------------------------------------------------------------------------
3730: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3731: 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');
3732: 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');
3733: END IF;
3734:
3735: OKL_STREAM_GENERATOR_PVT.create_pv_streams(
3736: p_api_version => p_api_version,

Line 3745: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3741: x_return_status => x_return_status,
3742: x_msg_count => x_msg_count ,
3743: x_msg_data => x_msg_data );
3744:
3745: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3746: 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);
3747: END IF;
3748:
3749: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3746: 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);

3742: x_msg_count => x_msg_count ,
3743: x_msg_data => x_msg_data );
3744:
3745: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3746: 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);
3747: END IF;
3748:
3749: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3755: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3751: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3752: RAISE OKL_API.G_EXCEPTION_ERROR;
3753: END IF;
3754:
3755: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3756: 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');
3757: END IF;
3758:
3759:

Line 3756: 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');

3752: RAISE OKL_API.G_EXCEPTION_ERROR;
3753: END IF;
3754:
3755: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3756: 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');
3757: END IF;
3758:
3759:
3760: ----------------------------------------------------------------------------

Line 3764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3760: ----------------------------------------------------------------------------
3761: --5 call Accrual API
3762: --
3763: ----------------------------------------------------------------------------
3764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3765: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: START');
3766: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_accrual_sec_pvt.create_streams');
3767: END IF;
3768:

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

3761: --5 call Accrual API
3762: --
3763: ----------------------------------------------------------------------------
3764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3765: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: START');
3766: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_accrual_sec_pvt.create_streams');
3767: END IF;
3768:
3769:

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

3762: --
3763: ----------------------------------------------------------------------------
3764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3765: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: START');
3766: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling okl_accrual_sec_pvt.create_streams');
3767: END IF;
3768:
3769:
3770: -- mvasudev, 10/29/2003

Line 3784: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3780: x_msg_data => x_msg_data,
3781: p_khr_id => p_khr_id,
3782: p_mode => 'ACTIVE');
3783:
3784: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3785: 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);
3786: 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);
3787: END IF;
3788:

Line 3785: 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);

3781: p_khr_id => p_khr_id,
3782: p_mode => 'ACTIVE');
3783:
3784: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3785: 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);
3786: 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);
3787: END IF;
3788:
3789: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3786: 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);

3782: p_mode => 'ACTIVE');
3783:
3784: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3785: 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);
3786: 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);
3787: END IF;
3788:
3789: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3790: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3798: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3794: -- Fixed Bug#3386816, mvasudev
3795: EXIT WHEN l_okl_sty_csr%FOUND;
3796: END LOOP;
3797: -- mvasudev, end, 10/29/2003
3798: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3799: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: END');
3800: END IF;
3801:
3802: ----------------------------------------------------------------------------

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

3795: EXIT WHEN l_okl_sty_csr%FOUND;
3796: END LOOP;
3797: -- mvasudev, end, 10/29/2003
3798: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3799: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '5 call to the Accrual API: END');
3800: END IF;
3801:
3802: ----------------------------------------------------------------------------
3803: --6 call generate_journal_entries

Line 3806: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3802: ----------------------------------------------------------------------------
3803: --6 call generate_journal_entries
3804: --
3805: ----------------------------------------------------------------------------
3806: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3807: 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');
3808: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling generate_journal_entries');
3809: END IF;
3810:

Line 3807: 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');

3803: --6 call generate_journal_entries
3804: --
3805: ----------------------------------------------------------------------------
3806: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3807: 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');
3808: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling generate_journal_entries');
3809: END IF;
3810:
3811: generate_journal_entries(

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

3804: --
3805: ----------------------------------------------------------------------------
3806: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3807: 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');
3808: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling generate_journal_entries');
3809: END IF;
3810:
3811: generate_journal_entries(
3812: p_api_version => p_api_version,

Line 3820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3816: x_msg_data => x_msg_data,
3817: p_contract_id => p_khr_id
3818: ,p_transaction_type => G_TRY_TYPE_INV);
3819:
3820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3821: 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);
3822: END IF;
3823:
3824: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3821: 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);

3817: p_contract_id => p_khr_id
3818: ,p_transaction_type => G_TRY_TYPE_INV);
3819:
3820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3821: 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);
3822: END IF;
3823:
3824: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3830: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3826: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3827: RAISE OKL_API.G_EXCEPTION_ERROR;
3828: END IF;
3829:
3830: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3831: 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');
3832: END IF;
3833:
3834: ----------------------------------------------------------------------------

Line 3831: 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');

3827: RAISE OKL_API.G_EXCEPTION_ERROR;
3828: END IF;
3829:
3830: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3831: 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');
3832: END IF;
3833:
3834: ----------------------------------------------------------------------------
3835: --7 call BPD AR api

Line 3838: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3834: ----------------------------------------------------------------------------
3835: --7 call BPD AR api
3836: --
3837: ----------------------------------------------------------------------------
3838: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3839: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: START');
3840: 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');
3841: END IF;
3842:

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

3835: --7 call BPD AR api
3836: --
3837: ----------------------------------------------------------------------------
3838: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3839: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: START');
3840: 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');
3841: END IF;
3842:
3843: Okl_Investor_Billing_Pvt.create_investor_bill(

Line 3840: 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');

3836: --
3837: ----------------------------------------------------------------------------
3838: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3839: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: START');
3840: 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');
3841: END IF;
3842:
3843: Okl_Investor_Billing_Pvt.create_investor_bill(
3844: p_api_version => p_api_version,

Line 3851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3847: x_msg_count => x_msg_count,
3848: x_msg_data => x_msg_data,
3849: p_inv_agr => p_khr_id);
3850:
3851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3852: 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);
3853: 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);
3854: END IF;
3855:

Line 3852: 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);

3848: x_msg_data => x_msg_data,
3849: p_inv_agr => p_khr_id);
3850:
3851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3852: 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);
3853: 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);
3854: END IF;
3855:
3856: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3853: 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);

3849: p_inv_agr => p_khr_id);
3850:
3851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3852: 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);
3853: 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);
3854: END IF;
3855:
3856: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3857: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3862: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3858: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3859: RAISE OKL_API.G_EXCEPTION_ERROR;
3860: END IF;
3861:
3862: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3863: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: END');
3864: END IF;
3865:
3866: --Update the total stake to include the additional stake

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

3859: RAISE OKL_API.G_EXCEPTION_ERROR;
3860: END IF;
3861:
3862: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3863: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '7 call BPD Billing API: END');
3864: END IF;
3865:
3866: --Update the total stake to include the additional stake
3867: FOR get_inv_stake_rec IN get_inv_stake_csr(p_khr_id)

Line 3869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3865:
3866: --Update the total stake to include the additional stake
3867: FOR get_inv_stake_rec IN get_inv_stake_csr(p_khr_id)
3868: LOOP
3869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3870: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
3871: END IF;
3872:
3873: --Only if an additional stake amount has been captured, then add this stake to the original stake

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

3866: --Update the total stake to include the additional stake
3867: FOR get_inv_stake_rec IN get_inv_stake_csr(p_khr_id)
3868: LOOP
3869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3870: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
3871: END IF;
3872:
3873: --Only if an additional stake amount has been captured, then add this stake to the original stake
3874: IF get_inv_stake_rec.additional_stake IS NOT NULL THEN

Line 3891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3887: p_klev_rec => l_klev_rec,
3888: x_clev_rec => lx_clev_rec,
3889: x_klev_rec => lx_klev_rec);
3890:
3891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3892: 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);
3893: END IF;
3894:
3895: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3892: 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);

3888: x_clev_rec => lx_clev_rec,
3889: x_klev_rec => lx_klev_rec);
3890:
3891: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3892: 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);
3893: END IF;
3894:
3895: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3896: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3905:
3906: ----------------------------------------------------------------------------------
3907: --8 update pool contents status to active and pool transactions status to COMPLETE
3908: ----------------------------------------------------------------------------------
3909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3910: 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');
3911: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');
3912: END IF;
3913:

Line 3910: 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');

3906: ----------------------------------------------------------------------------------
3907: --8 update pool contents status to active and pool transactions status to COMPLETE
3908: ----------------------------------------------------------------------------------
3909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3910: 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');
3911: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');
3912: END IF;
3913:
3914: --Update pool contents to ACTIVE

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

3907: --8 update pool contents status to active and pool transactions status to COMPLETE
3908: ----------------------------------------------------------------------------------
3909: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3910: 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');
3911: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_contents');
3912: END IF;
3913:
3914: --Update pool contents to ACTIVE
3915: FOR c_pool_chr_rec IN c_pool_chr_csr(l_pol_id)

Line 3929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3925: x_msg_data => x_msg_data,
3926: p_pocv_rec => lp_pocv_rec,
3927: x_pocv_rec => lx_pocv_rec);
3928:
3929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3930: 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);
3931: END IF;
3932:
3933:

Line 3930: 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);

3926: p_pocv_rec => lp_pocv_rec,
3927: x_pocv_rec => lx_pocv_rec);
3928:
3929: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3930: 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);
3931: END IF;
3932:
3933:
3934: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 3942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3938: END IF;
3939: END LOOP;
3940:
3941:
3942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3943: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');
3944: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');
3945: END IF;
3946:

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

3939: END LOOP;
3940:
3941:
3942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3943: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');
3944: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');
3945: END IF;
3946:
3947: --Update pool transaction to COMPLETE

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

3940:
3941:
3942: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3943: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', '8 update pool transaction to Complete: START');
3944: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Calling OKL_POOL_PVT.update_pool_transaction');
3945: END IF;
3946:
3947: --Update pool transaction to COMPLETE
3948: lp_poxv_rec.id := l_pox_id;

Line 3966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3962: RAISE OKL_API.G_EXCEPTION_ERROR;
3963: END IF;
3964:
3965:
3966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3967: 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);
3968: END IF;
3969:
3970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3967: 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);

3963: END IF;
3964:
3965:
3966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3967: 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);
3968: END IF;
3969:
3970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

3972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3973: RAISE OKL_API.G_EXCEPTION_ERROR;
3974: END IF;
3975:
3976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3977: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Update investor stake');
3978: END IF;
3979:
3980: /*** End API body ******************************************************/

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

3973: RAISE OKL_API.G_EXCEPTION_ERROR;
3974: END IF;
3975:
3976: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3977: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'Update investor stake');
3978: END IF;
3979:
3980: /*** End API body ******************************************************/
3981:

Line 4094: -- 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);

4090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4091: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4092: RAISE OKL_API.G_EXCEPTION_ERROR;
4093: END IF;
4094: -- 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);
4095:
4096: -- read the profile OKL: Investor Add Contracts Approval Process
4097: l_approval_process := fnd_profile.value('OKL_IA_ADD_KHR_APPR_PROCESS');
4098:

Line 4418: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4414:
4415: --Update the additional stake on removing transaction
4416: FOR get_inv_stake_rec IN get_inv_stake_csr(p_chr_id)
4417: LOOP
4418: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4419: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
4420: END IF;
4421:
4422:

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

4415: --Update the additional stake on removing transaction
4416: FOR get_inv_stake_rec IN get_inv_stake_csr(p_chr_id)
4417: LOOP
4418: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4419: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_pvt.activate_add_request.debug', 'OKL_CONTRACT_PUB.update_contract_line');
4420: END IF;
4421:
4422:
4423: --Remove the additional stake amount

Line 4440: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

4436: p_klev_rec => l_klev_rec,
4437: x_clev_rec => lx_clev_rec,
4438: x_klev_rec => lx_klev_rec);
4439:
4440: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4441: 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);
4442: END IF;
4443:
4444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4441: 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);

4437: x_clev_rec => lx_clev_rec,
4438: x_klev_rec => lx_klev_rec);
4439:
4440: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4441: 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);
4442: END IF;
4443:
4444: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4445: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;