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_WF dependencies on OKL_SEC_AGREEMENT_WF

Line 1: PACKAGE BODY OKL_SEC_AGREEMENT_WF AS

1: PACKAGE BODY OKL_SEC_AGREEMENT_WF AS
2: /* $Header: OKLRZWFB.pls 120.4.12010000.3 2008/10/03 19:22:55 rkuttiya ship $ */
3: ----------------------------------------------------------------------------
4: -- Global Message Constants
5: ----------------------------------------------------------------------------

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 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 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 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 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 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 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 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 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 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 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 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);

Line 853: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||itemkey);

849:
850: wf_engine.SetItemAttrDocument (itemtype => itemtype,
851: itemkey => itemkey,
852: aname => G_WF_ITM_MESSAGE_DOC,
853: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||itemkey);
854:
855: resultout := 'COMPLETE:FOUND';
856: END LOOP;
857: END IF; -- l_user_id

Line 1416: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||l_key);

1412: -- Set the Message Document
1413: wf_engine.SetItemAttrDocument (itemtype => l_item_type,
1414: itemkey => l_key,
1415: aname => G_WF_ITM_MESSAGE_DOC,
1416: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||l_key);
1417:
1418: -- Now, Start the Detail Process
1419: wf_engine.StartProcess(itemtype => l_item_type,
1420: itemkey => l_key);

Line 1482: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||itemkey);

1478: IF (funcmode = 'RUN') THEN
1479: wf_engine.SetItemAttrDocument (itemtype => itemtype,
1480: itemkey => itemkey,
1481: aname => G_WF_ITM_MESSAGE_DOC,
1482: documentid => 'plsql:OKL_SEC_AGREEMENT_WF.pop_approval_doc/'||itemkey);
1483:
1484: resultout := 'COMPLETE:';
1485: RETURN;
1486: END IF;

Line 1508: wf_core.context('OKL_SEC_AGREEMENT_WF' , 'AME_APPROVAL_PROCESS', itemtype, itemkey, actid, funcmode);

1504: END IF;
1505:
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: wf_core.context('OKL_SEC_AGREEMENT_WF' , 'AME_APPROVAL_PROCESS', itemtype, itemkey, actid, funcmode);
1509: RAISE;
1510:
1511: END ame_add_khr_apprv_process;
1512:

Line 1514: END OKL_SEC_AGREEMENT_WF;

1510:
1511: END ame_add_khr_apprv_process;
1512:
1513:
1514: END OKL_SEC_AGREEMENT_WF;
1515: