472:
473: IF l_application_id = l_trans_appl_id THEN
474: l_event_name := G_EVENT_APPROVE_AME;
475:
476: wf_event.AddParameterToList(G_WF_ITM_INVESTOR_AGRMNT_ID,p_agreement_id,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
473: IF l_application_id = l_trans_appl_id THEN
474: l_event_name := G_EVENT_APPROVE_AME;
475:
476: wf_event.AddParameterToList(G_WF_ITM_INVESTOR_AGRMNT_ID,p_agreement_id,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
474: l_event_name := G_EVENT_APPROVE_AME;
475:
476: wf_event.AddParameterToList(G_WF_ITM_INVESTOR_AGRMNT_ID,p_agreement_id,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
475:
476: wf_event.AddParameterToList(G_WF_ITM_INVESTOR_AGRMNT_ID,p_agreement_id,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
483: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
476: wf_event.AddParameterToList(G_WF_ITM_INVESTOR_AGRMNT_ID,p_agreement_id,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
483: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
484: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
477: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
478: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
483: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
484: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
485: ELSE
478: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
479: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
483: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
484: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
485: ELSE
486: OKL_API.set_message(p_app_name => G_APP_NAME,
479: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
483: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
484: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
485: ELSE
486: OKL_API.set_message(p_app_name => G_APP_NAME,
487: p_msg_name => G_INVALID_APP);
480: wf_event.AddParameterToList(G_WF_ITM_APPLICATION_ID,l_application_id,l_parameter_list);
481: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
482: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
483: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
484: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
485: ELSE
486: OKL_API.set_message(p_app_name => G_APP_NAME,
487: p_msg_name => G_INVALID_APP);
488: RAISE OKL_API.G_EXCEPTION_ERROR;
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);
497: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
498: wf_event.AddParameterToList(G_WF_ITM_POOL_ID,l_pool_id,l_parameter_list);
499: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
500: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
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);
497: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
498: wf_event.AddParameterToList(G_WF_ITM_POOL_ID,l_pool_id,l_parameter_list);
499: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
500: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
501: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
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);
497: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
498: wf_event.AddParameterToList(G_WF_ITM_POOL_ID,l_pool_id,l_parameter_list);
499: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
500: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
501: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
502: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
495:
496: wf_event.AddParameterToList(G_WF_ITM_INVESTOR_AGRMNT_ID,p_agreement_id,l_parameter_list);
497: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
498: wf_event.AddParameterToList(G_WF_ITM_POOL_ID,l_pool_id,l_parameter_list);
499: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
500: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
501: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
502: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
503: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
496: wf_event.AddParameterToList(G_WF_ITM_INVESTOR_AGRMNT_ID,p_agreement_id,l_parameter_list);
497: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
498: wf_event.AddParameterToList(G_WF_ITM_POOL_ID,l_pool_id,l_parameter_list);
499: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
500: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
501: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
502: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
503: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
504: ELSE
497: wf_event.AddParameterToList(G_WF_ITM_INV_AGRMNT_NUMBER,l_agreement_num,l_parameter_list);
498: wf_event.AddParameterToList(G_WF_ITM_POOL_ID,l_pool_id,l_parameter_list);
499: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
500: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
501: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
502: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
503: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
504: ELSE
505: RAISE OKL_API.G_EXCEPTION_ERROR;
498: wf_event.AddParameterToList(G_WF_ITM_POOL_ID,l_pool_id,l_parameter_list);
499: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
500: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
501: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
502: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
503: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
504: ELSE
505: RAISE OKL_API.G_EXCEPTION_ERROR;
506: END IF; -- l_approval_option
499: wf_event.AddParameterToList(G_WF_ITM_POOL_NUMBER,l_pool_number,l_parameter_list);
500: wf_event.AddParameterToList(G_WF_ITM_POOL_TRANSACTION_ID,l_pool_trans_id,l_parameter_list);
501: wf_event.AddParameterToList(G_WF_ITM_REQUESTER,l_requester,l_parameter_list);
502: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
503: wf_event.AddParameterToList(G_WF_ITM_ORG_ID, mo_global.get_current_org_id ,l_parameter_list);
504: ELSE
505: RAISE OKL_API.G_EXCEPTION_ERROR;
506: END IF; -- l_approval_option
507:
505: RAISE OKL_API.G_EXCEPTION_ERROR;
506: END IF; -- l_approval_option
507:
508: -- Raise Event
509: wf_event.RAISE(p_event_name => l_event_name,
510: p_event_key => l_key,
511: p_parameters => l_parameter_list);
512: l_parameter_list.DELETE;
513: