APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMDQSPEC_APPROVAL_WF_PKG

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 529: lStartStatus_DESC := GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'S');

525: ELSE
526: l_location := NULL;
527: END IF;
528:
529: lStartStatus_DESC := GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'S');
530: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');
531:
532: IF (l_debug = 'Y') THEN
533: gmd_debug.put_line('Setting workflow attributes');

Line 530: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');

526: l_location := NULL;
527: END IF;
528:
529: lStartStatus_DESC := GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'S');
530: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');
531:
532: IF (l_debug = 'Y') THEN
533: gmd_debug.put_line('Setting workflow attributes');
534: END IF;

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