DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on WF_CORE

Line 401: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

397: , x_return_status => api_ret_status
398: , x_message => api_err_mesg );
399:
400: IF api_ret_status <> 'S' THEN
401: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
402: raise APPLICATION_ERROR;
403: END IF;
404:
405: p_resultout := 'COMPLETE:N';

Line 457: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,FND_MESSAGE.GET_STRING('GMD','GMD_QC_INVALID_SPEC_VR_ID for Monitoring'));

453: /* This is a monitoring Spec VR */
454: open get_mont_disp_Attr;
455: FETCH get_mont_disp_Attr INTO mont_disp_attr_rec;
456: IF get_mont_disp_Attr%NOTFOUND THEN
457: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,FND_MESSAGE.GET_STRING('GMD','GMD_QC_INVALID_SPEC_VR_ID for Monitoring'));
458: raise APPLICATION_ERROR;
459: END IF;
460:
461: l_requester := GET_FND_USER_NAME(mont_disp_attr_rec.LAST_UPDATED_BY);

Line 468: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,FND_MESSAGE.GET_STRING('GMD','GMD_QC_INVALID_SPEC_VR_ID'));

464: /* This is an item spec VR */
465: open get_disp_Attr;
466: FETCH get_disp_Attr INTO disp_attr_rec;
467: IF get_disp_Attr%NOTFOUND THEN
468: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,FND_MESSAGE.GET_STRING('GMD','GMD_QC_INVALID_SPEC_VR_ID'));
469: raise APPLICATION_ERROR;
470: END IF;
471:
472: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);

Line 672: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

668: gmd_debug.put_line('Finished workflow attributes');
669: END IF;
670:
671: ELSE
672: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
673: raise APPLICATION_ERROR;
674: END IF;
675: END IF;
676: END IF;

Line 678: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'Invalid Spec ID');

674: END IF;
675: END IF;
676: END IF;
677: EXCEPTION WHEN NO_DATA_FOUND THEN
678: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'Invalid Spec ID');
679: raise;
680: END IS_APPROVAL_REQ;
681:
682:

Line 702: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING

698: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSVRS_CURR_PERFORMER');
699: BEGIN
700: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
701: BEGIN
702: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
703: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
704: wf_core.newline||l_comment;
705: l_comment := null;
706: EXCEPTION WHEN OTHERS THEN

Line 703: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||

699: BEGIN
700: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
701: BEGIN
702: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
703: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
704: wf_core.newline||l_comment;
705: l_comment := null;
706: EXCEPTION WHEN OTHERS THEN
707: NULL;

Line 704: wf_core.newline||l_comment;

700: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
701: BEGIN
702: --l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
703: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
704: wf_core.newline||l_comment;
705: l_comment := null;
706: EXCEPTION WHEN OTHERS THEN
707: NULL;
708: END;

Line 777: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

773: , p_mode => 'A'
774: , x_return_status => api_ret_status
775: , x_message => api_err_mesg );
776: IF api_ret_status <> 'S' THEN
777: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
778: raise APPLICATION_ERROR;
779: END IF;
780: p_resultout := 'COMPLETE:N';
781: ELSE

Line 868: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

864: , p_mode => 'S'
865: , x_return_status => api_ret_status
866: , x_message => api_err_mesg );
867: IF api_ret_status <> 'S' THEN
868: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
869: raise APPLICATION_ERROR;
870: END IF;
871: END IF;
872: END NO_RESPONSE;

Line 932: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

928: , p_mode => 'R'
929: , x_return_status => api_ret_status
930: , x_message => api_err_mesg );
931: IF api_ret_status <> 'S' THEN
932: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
933: raise APPLICATION_ERROR;
934: END IF;
935: END IF;
936: