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

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)||
703: wf_core.newline||l_comment;
704: l_comment := null;
705: EXCEPTION WHEN OTHERS THEN
706: NULL;

Line 703: wf_core.newline||l_comment;

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)||
703: wf_core.newline||l_comment;
704: l_comment := null;
705: EXCEPTION WHEN OTHERS THEN
706: NULL;
707: END;

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

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

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

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

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

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