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_VP_OA_WF dependencies on FND_LOG

Line 249: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.RAISE_OA_EVENT_APPROVAL';

245:
246: l_api_version CONSTANT NUMBER DEFAULT 1.0;
247: l_approval_process fnd_lookups.lookup_code%TYPE;
248: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_pa_FOR_APPROVAL';
249: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.RAISE_OA_EVENT_APPROVAL';
250: l_debug_enabled VARCHAR2(10);
251:
252: BEGIN
253: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 258: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRXXXB.pls call raise_oa_event_approval');

254:
255: l_debug_enabled := okl_debug_pub.check_log_enabled;
256:
257: IF(l_debug_enabled='Y') THEN
258: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRXXXB.pls call raise_oa_event_approval');
259: END IF;
260:
261: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
262: x_return_status := OKL_API.START_ACTIVITY(

Line 283: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

279: ,x_name => l_requester
280: ,x_description => l_name);
281: -- write to log
282: IF(NVL(l_debug_enabled,'N')='Y') THEN
283: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
284: l_module,
285: 'l_get_agent return staus '||x_return_status||' l_requester '||l_requester||' l_name '||l_name
286: );
287: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 324: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

320: ELSIF(NVL(l_approval_process,'NONE') = G_AGRMNT_APPROVAL_WF)THEN
321: -- log here. no action required. for common event parameters, see below
322: -- write to log
323: IF(NVL(l_debug_enabled,'N')='Y') THEN
324: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
325: l_module,
326: 'l_approval_process '||l_approval_process||' raising operating agreement approval event'
327: );
328: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 361: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRXXXB.pls call raise_oa_event_approval');

357:
358: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
359:
360: IF(l_debug_enabled='Y') THEN
361: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRXXXB.pls call raise_oa_event_approval');
362: END IF;
363:
364: EXCEPTION
365: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 447: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.GET_AGRMNT_APPROVER';

443:
444: l_user_id VARCHAR2(200);
445: lv_requestor VARCHAR2(100);
446:
447: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.GET_AGRMNT_APPROVER';
448: l_debug_enabled VARCHAR2(10);
449:
450: BEGIN
451: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug call get_agrmnt_approver');

449:
450: BEGIN
451: l_debug_enabled := okl_debug_pub.check_log_enabled;
452: IF(l_debug_enabled='Y') THEN
453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug call get_agrmnt_approver');
454: END IF;
455:
456: IF(funcmode = 'RUN')THEN
457: l_user_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 491: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug call get_agrmnt_approver');

487: RETURN;
488: END IF; -- funcmode
489:
490: IF(l_debug_enabled='Y') THEN
491: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug call get_agrmnt_approver');
492: END IF;
493:
494: EXCEPTION
495: WHEN OTHERS THEN

Line 509: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.UPDATE_AGRMNT_STATUS';

505: x_return_status VARCHAR2(10);
506: x_msg_data VARCHAR2(1000);
507: x_msg_count NUMBER;
508: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'update_agrmnt_status';
509: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.UPDATE_AGRMNT_STATUS';
510: l_debug_enabled VARCHAR2(10);
511: lv_approval_status VARCHAR2(10);
512: lv_approval_status_ame VARCHAR2(10);
513: lv_agreement_id okc_k_headers_b.id%TYPE;

Line 517: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_agrmnt_status');

513: lv_agreement_id okc_k_headers_b.id%TYPE;
514: BEGIN
515: l_debug_enabled := okl_debug_pub.check_log_enabled;
516: IF(l_debug_enabled='Y') THEN
517: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug update_agrmnt_status');
518: END IF;
519:
520: IF(funcmode = 'RUN')THEN
521: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 543: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

539: ,p_chr_id => lv_agreement_id
540: );
541: -- write to log
542: IF(NVL(l_debug_enabled,'N')='Y') THEN
543: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
544: l_module,
545: 'okl_contract_status_pub.update_contract_status G_ACTIVE_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
546: );
547: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 564: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

560: ,p_chr_id => lv_agreement_id
561: );
562: -- write to log
563: IF(NVL(l_debug_enabled,'N')='Y') THEN
564: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
565: l_module,
566: 'okl_contract_status_pub.update_contract_status G_DECLINED_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
567: );
568: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 588: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug update_agrmnt_status');

584: resultout := 'COMPLETE:';
585: RETURN;
586: END IF; -- funcmode
587: IF(l_debug_enabled='Y') THEN
588: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug update_agrmnt_status');
589: END IF;
590:
591: EXCEPTION
592: WHEN OTHERS THEN

Line 603: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.PROCESS_OA_FOR_AME';

599: ,actid IN NUMBER
600: ,funcmode IN VARCHAR2
601: ,resultout OUT NOCOPY VARCHAR2) IS
602: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'process_oa_for_ame';
603: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_OA_WF.PROCESS_OA_FOR_AME';
604: l_debug_enabled VARCHAR2(10);
605: lv_agreement_id okc_k_headers_b.id%TYPE;
606: BEGIN
607: IF(funcmode = 'RUN')THEN