DBA Data[Home] [Help]

APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on WF_CORE

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

212: , x_return_status => api_ret_status
213: , x_message => api_err_mesg );
214:
215: IF api_ret_status <> 'S' THEN
216: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
217: raise APPLICATION_ERROR;
218: END IF;
219:
220: IF (l_debug = 'Y') THEN

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

260: -- Get attributes Required for display
261: open get_disp_Attr;
262: FETCH get_disp_Attr INTO disp_attr_rec;
263: IF get_disp_Attr%NOTFOUND THEN
264: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,FND_MESSAGE.GET_STRING('GMD','GMD_QC_INVALID_SPEC_ID'));
265: raise APPLICATION_ERROR;
266: END IF;
267:
268: IF (l_debug = 'Y') THEN

Line 385: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',

381: aname => 'GMDQSPAP_MESG_CNT',
382: avalue => 1);
383: p_resultout := 'COMPLETE:Y';
384: ELSE
385: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',
386: p_itemtype,p_itemkey,api_err_mesg );
387: raise APPLICATION_ERROR;
388: END IF;
389: END IF;

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

388: END IF;
389: END IF;
390: END IF;
391: EXCEPTION WHEN NO_DATA_FOUND THEN
392: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,'Invalid Spec ID');
393: raise;
394: END IS_APPROVAL_REQ;
395:
396: /**************************************************************************************

Line 417: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)||

413: l_performer VARCHAR2(80) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDQSPAP_CURR_PERFORMER');
414: BEGIN
415: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
416: BEGIN
417: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)||
418: wf_core.newline||l_comment;
419: l_comment := null;
420: EXCEPTION WHEN OTHERS THEN
421: NULL;

Line 418: wf_core.newline||l_comment;

414: BEGIN
415: IF (p_funcmode = 'RUN' AND l_comment IS NOT NULL) THEN
416: BEGIN
417: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(SYSDATE)||
418: wf_core.newline||l_comment;
419: l_comment := null;
420: EXCEPTION WHEN OTHERS THEN
421: NULL;
422: END;

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

488: , p_mode => 'A'
489: , x_return_status => api_ret_status
490: , x_message => api_err_mesg );
491: IF api_ret_status <> 'S' THEN
492: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
493: raise APPLICATION_ERROR;
494: END IF;
495: p_resultout := 'COMPLETE:N';
496: ELSE

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

571: , p_mode => 'S'
572: , x_return_status => api_ret_status
573: , x_message => api_err_mesg );
574: IF api_ret_status <> 'S' THEN
575: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
576: raise APPLICATION_ERROR;
577: END IF;
578: END IF;
579: END NO_RESPONSE;

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

635: , p_mode => 'R'
636: , x_return_status => api_ret_status
637: , x_message => api_err_mesg );
638: IF api_ret_status <> 'S' THEN
639: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );
640: raise APPLICATION_ERROR;
641: END IF;
642: END IF;
643: