DBA Data[Home] [Help]

APPS.OKL_VP_PA_WF dependencies on FND_LOG

Line 251: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.RAISE_PA_EVENT_APPROVAL';

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

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

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

Line 285: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

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

Line 326: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 448: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.GET_AGRMNT_APPROVER';

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

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

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

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

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

Line 510: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.UPDATE_AGRMNT_STATUS';

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

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

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

Line 544: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

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

Line 565: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 604: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_PA_WF.PROCESS_PA_FOR_AME';

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