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)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING

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)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
418: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
419: wf_core.newline||l_comment;
420: l_comment := null;
421: EXCEPTION WHEN OTHERS THEN

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

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)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
418: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
419: wf_core.newline||l_comment;
420: l_comment := null;
421: EXCEPTION WHEN OTHERS THEN
422: NULL;

Line 419: wf_core.newline||l_comment;

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)|| replaced by below line for Bug 11874618 - 12.2 TECHNOLOGY PROJECT ONLINE PATCHING
418: l_mesg_comment := l_mesg_comment||wf_core.newline||l_performer||' : '||FND_DATE.DATE_TO_CHARDT(DATEVAL => SYSDATE, CALENDAR_AWARE => 2)||
419: wf_core.newline||l_comment;
420: l_comment := null;
421: EXCEPTION WHEN OTHERS THEN
422: NULL;
423: END;

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

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

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

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

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

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