DBA Data[Home] [Help]

APPS.OKL_SEC_AGREEMENT_WF dependencies on FND_LOG

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

180: --Set the Pool Transaction Id for the update call
181: lp_poxv_rec.ID := l_pool_trans_id;
182: lp_poxv_rec.TRANSACTION_STATUS := l_pool_trx_status;
183: lp_poxv_rec.pol_id := l_pool_id;
184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
185: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'Before Pool Transaction update call ');
186: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.TRANSACTION_STATUS ' || lp_poxv_rec.TRANSACTION_STATUS);
187: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.ID ' || lp_poxv_rec.ID);
188: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.pol_id ' || lp_poxv_rec.pol_ID);

Line 185: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'Before Pool Transaction update call ');

181: lp_poxv_rec.ID := l_pool_trans_id;
182: lp_poxv_rec.TRANSACTION_STATUS := l_pool_trx_status;
183: lp_poxv_rec.pol_id := l_pool_id;
184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
185: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'Before Pool Transaction update call ');
186: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.TRANSACTION_STATUS ' || lp_poxv_rec.TRANSACTION_STATUS);
187: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.ID ' || lp_poxv_rec.ID);
188: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.pol_id ' || lp_poxv_rec.pol_ID);
189: END IF;

Line 186: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.TRANSACTION_STATUS ' || lp_poxv_rec.TRANSACTION_STATUS);

182: lp_poxv_rec.TRANSACTION_STATUS := l_pool_trx_status;
183: lp_poxv_rec.pol_id := l_pool_id;
184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
185: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'Before Pool Transaction update call ');
186: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.TRANSACTION_STATUS ' || lp_poxv_rec.TRANSACTION_STATUS);
187: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.ID ' || lp_poxv_rec.ID);
188: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.pol_id ' || lp_poxv_rec.pol_ID);
189: END IF;
190:

Line 187: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.ID ' || lp_poxv_rec.ID);

183: lp_poxv_rec.pol_id := l_pool_id;
184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
185: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'Before Pool Transaction update call ');
186: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.TRANSACTION_STATUS ' || lp_poxv_rec.TRANSACTION_STATUS);
187: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.ID ' || lp_poxv_rec.ID);
188: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.pol_id ' || lp_poxv_rec.pol_ID);
189: END IF;
190:
191: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,

Line 188: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.pol_id ' || lp_poxv_rec.pol_ID);

184: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
185: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'Before Pool Transaction update call ');
186: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.TRANSACTION_STATUS ' || lp_poxv_rec.TRANSACTION_STATUS);
187: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.ID ' || lp_poxv_rec.ID);
188: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'lp_poxv_rec.pol_id ' || lp_poxv_rec.pol_ID);
189: END IF;
190:
191: OKL_POOL_PVT.update_pool_transaction(p_api_version => p_api_version,
192: p_init_msg_list => p_init_msg_list,

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

195: x_msg_data => x_msg_data,
196: p_poxv_rec => lp_poxv_rec,
197: x_poxv_rec => lx_poxv_rec);
198:
199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
200: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'After Pool Transaction update call x_return_status ' || x_return_status);
201: END IF;
202:
203: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 200: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'After Pool Transaction update call x_return_status ' || x_return_status);

196: p_poxv_rec => lp_poxv_rec,
197: x_poxv_rec => lx_poxv_rec);
198:
199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
200: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.l_change_add_req_status', 'After Pool Transaction update call x_return_status ' || x_return_status);
201: END IF;
202:
203: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
204: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
372: RAISE OKL_API.G_EXCEPTION_ERROR;
373: END IF;
374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
375: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'Begin Add Contract Approval Processing');
376: END IF;
377: -- Create Internal Transaction
378: -- Get the user id, Item key

Line 375: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'Begin Add Contract Approval Processing');

371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
372: RAISE OKL_API.G_EXCEPTION_ERROR;
373: END IF;
374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
375: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'Begin Add Contract Approval Processing');
376: END IF;
377: -- Create Internal Transaction
378: -- Get the user id, Item key
379: l_requester_id := FND_GLOBAL.USER_ID;

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

387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
388: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
389: RAISE OKL_API.G_EXCEPTION_ERROR;
390: END IF;
391: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
392: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After l_get_agent l_requester : ' || l_requester);
393: END IF;
394: FOR l_wf_item_key_rec IN l_wf_item_key_csr
395: LOOP

Line 392: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After l_get_agent l_requester : ' || l_requester);

388: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
389: RAISE OKL_API.G_EXCEPTION_ERROR;
390: END IF;
391: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
392: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After l_get_agent l_requester : ' || l_requester);
393: END IF;
394: FOR l_wf_item_key_rec IN l_wf_item_key_csr
395: LOOP
396: l_key := l_wf_item_key_rec.item_key;

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

395: LOOP
396: l_key := l_wf_item_key_rec.item_key;
397: END LOOP;
398:
399: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
400: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_wf_item_key_csr returned l_key : ' || l_key);
401: END IF;
402:
403: -- Get the Investor Agreement Number

Line 400: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_wf_item_key_csr returned l_key : ' || l_key);

396: l_key := l_wf_item_key_rec.item_key;
397: END LOOP;
398:
399: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
400: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_wf_item_key_csr returned l_key : ' || l_key);
401: END IF;
402:
403: -- Get the Investor Agreement Number
404: OPEN c_fetch_ia_number_csr(l_agreement_id);

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

410: p_token1_value => 'OKC_K_HEADERS_V.ID');
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413: CLOSE c_fetch_ia_number_csr;
414: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
415: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event','After c_fetch_ia_number_csr l_agreement_num : ' || l_agreement_num);
416: END IF;
417: --Get Pool Number
418: OPEN c_fetch_pool_number_csr(p_pool_id);

Line 415: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event','After c_fetch_ia_number_csr l_agreement_num : ' || l_agreement_num);

411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413: CLOSE c_fetch_ia_number_csr;
414: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
415: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event','After c_fetch_ia_number_csr l_agreement_num : ' || l_agreement_num);
416: END IF;
417: --Get Pool Number
418: OPEN c_fetch_pool_number_csr(p_pool_id);
419: FETCH c_fetch_pool_number_csr into l_pool_number;

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

424: p_token1_value => 'OKL_POOLS.NUMBER');
425: RAISE OKL_API.G_EXCEPTION_ERROR;
426: END IF;
427: CLOSE c_fetch_pool_number_csr ;
428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
429: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'c_fetch_pool_number_csr returned l_pool_number : ' || l_pool_number);
430: END IF;
431:
432: l_approval_option := fnd_profile.value(G_IA_ADD_KHR_APPROVAL_PROCESS);

Line 429: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'c_fetch_pool_number_csr returned l_pool_number : ' || l_pool_number);

425: RAISE OKL_API.G_EXCEPTION_ERROR;
426: END IF;
427: CLOSE c_fetch_pool_number_csr ;
428: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
429: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'c_fetch_pool_number_csr returned l_pool_number : ' || l_pool_number);
430: END IF;
431:
432: l_approval_option := fnd_profile.value(G_IA_ADD_KHR_APPROVAL_PROCESS);
433:

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

430: END IF;
431:
432: l_approval_option := fnd_profile.value(G_IA_ADD_KHR_APPROVAL_PROCESS);
433:
434: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
435: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'The Profile Option for Sending Workflow is set as ' || l_approval_option);
436: END IF;
437:
438: IF l_approval_option = G_IA_ADD_KHR_APPROVAL_AME THEN

Line 435: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'The Profile Option for Sending Workflow is set as ' || l_approval_option);

431:
432: l_approval_option := fnd_profile.value(G_IA_ADD_KHR_APPROVAL_PROCESS);
433:
434: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
435: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'The Profile Option for Sending Workflow is set as ' || l_approval_option);
436: END IF;
437:
438: IF l_approval_option = G_IA_ADD_KHR_APPROVAL_AME THEN
439: -- Get the Application ID

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

446: p_token1_value => 'Application id');
447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: END IF;
449: CLOSE c_get_app_id_csr;
450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
451: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After Get the Application ID c_get_app_id_csr l_application_id : ' || l_application_id);
452: END IF;
453:
454: -- Get the Transaction Type ID

Line 451: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After Get the Application ID c_get_app_id_csr l_application_id : ' || l_application_id);

447: RAISE OKL_API.G_EXCEPTION_ERROR;
448: END IF;
449: CLOSE c_get_app_id_csr;
450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
451: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After Get the Application ID c_get_app_id_csr l_application_id : ' || l_application_id);
452: END IF;
453:
454: -- Get the Transaction Type ID
455: OPEN c_get_trx_type_csr(G_TRANS_APP_NAME);

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

463: RAISE OKL_API.G_EXCEPTION_ERROR;
464: END IF;
465: CLOSE c_get_trx_type_csr;
466:
467: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
468: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After c_get_trx_type_csr ');
469: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_type_id : ' || l_trans_type_id);
470: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_appl_id : ' || l_trans_appl_id);
471: END IF;

Line 468: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After c_get_trx_type_csr ');

464: END IF;
465: CLOSE c_get_trx_type_csr;
466:
467: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
468: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After c_get_trx_type_csr ');
469: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_type_id : ' || l_trans_type_id);
470: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_appl_id : ' || l_trans_appl_id);
471: END IF;
472:

Line 469: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_type_id : ' || l_trans_type_id);

465: CLOSE c_get_trx_type_csr;
466:
467: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
468: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After c_get_trx_type_csr ');
469: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_type_id : ' || l_trans_type_id);
470: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_appl_id : ' || l_trans_appl_id);
471: END IF;
472:
473: IF l_application_id = l_trans_appl_id THEN

Line 470: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_appl_id : ' || l_trans_appl_id);

466:
467: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
468: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'After c_get_trx_type_csr ');
469: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_type_id : ' || l_trans_type_id);
470: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_trans_appl_id : ' || l_trans_appl_id);
471: END IF;
472:
473: IF l_application_id = l_trans_appl_id THEN
474: l_event_name := G_EVENT_APPROVE_AME;

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

487: p_msg_name => G_INVALID_APP);
488: RAISE OKL_API.G_EXCEPTION_ERROR;
489: END IF; -- l_application_id
490: ELSIF l_approval_option = G_IA_ADD_CONTRACTS_APPRV_WF THEN
491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
492: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_approval_option ' || l_approval_option);
493: END IF;
494: l_event_name := G_EVENT_APPROVE_WF;
495:

Line 492: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_approval_option ' || l_approval_option);

488: RAISE OKL_API.G_EXCEPTION_ERROR;
489: END IF; -- l_application_id
490: ELSIF l_approval_option = G_IA_ADD_CONTRACTS_APPRV_WF THEN
491: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
492: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'l_approval_option ' || l_approval_option);
493: END IF;
494: l_event_name := G_EVENT_APPROVE_WF;
495:
496: wf_event.AddParameterToList(G_WF_ITM_INVESTOR_AGRMNT_ID,p_agreement_id,l_parameter_list);

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

510: p_event_key => l_key,
511: p_parameters => l_parameter_list);
512: l_parameter_list.DELETE;
513:
514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
515: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'Worklow Intiated and Approval Sent');
516: END IF;
517:
518: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 515: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'Worklow Intiated and Approval Sent');

511: p_parameters => l_parameter_list);
512: l_parameter_list.DELETE;
513:
514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
515: fnd_log.STRING(fnd_log.level_statement,'okl.plsql.okl_sec_agreement_wf.raise_add_khr_approval_event', 'Worklow Intiated and Approval Sent');
516: END IF;
517:
518: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
519: x_msg_data => x_msg_data);