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);
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);
543: ==============================================*/
544:
545: if (l_spec_type in ('R','L')) then
546: /* This is a monitoring Spec VR */
547: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_MON');
548: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'RESOURCE',mont_disp_attr_rec.resources);
549: FND_MESSAGE.SET_TOKEN('RESOURCE', mont_disp_attr_rec.RESOURCES);
550: FND_MESSAGE.SET_TOKEN('RESOURCE_INSTANCE', mont_disp_attr_rec.RESOURCE_INSTANCE_ID);
551: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
545: if (l_spec_type in ('R','L')) then
546: /* This is a monitoring Spec VR */
547: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_MON');
548: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'RESOURCE',mont_disp_attr_rec.resources);
549: FND_MESSAGE.SET_TOKEN('RESOURCE', mont_disp_attr_rec.RESOURCES);
550: FND_MESSAGE.SET_TOKEN('RESOURCE_INSTANCE', mont_disp_attr_rec.RESOURCE_INSTANCE_ID);
551: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
552: FND_MESSAGE.SET_TOKEN('LOCATOR', mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
553:
546: /* This is a monitoring Spec VR */
547: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_MON');
548: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'RESOURCE',mont_disp_attr_rec.resources);
549: FND_MESSAGE.SET_TOKEN('RESOURCE', mont_disp_attr_rec.RESOURCES);
550: FND_MESSAGE.SET_TOKEN('RESOURCE_INSTANCE', mont_disp_attr_rec.RESOURCE_INSTANCE_ID);
551: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
552: FND_MESSAGE.SET_TOKEN('LOCATOR', mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
553:
554:
547: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_MON');
548: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'RESOURCE',mont_disp_attr_rec.resources);
549: FND_MESSAGE.SET_TOKEN('RESOURCE', mont_disp_attr_rec.RESOURCES);
550: FND_MESSAGE.SET_TOKEN('RESOURCE_INSTANCE', mont_disp_attr_rec.RESOURCE_INSTANCE_ID);
551: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
552: FND_MESSAGE.SET_TOKEN('LOCATOR', mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
553:
554:
555: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',mont_disp_attr_rec.SPEC_NAME);
548: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'RESOURCE',mont_disp_attr_rec.resources);
549: FND_MESSAGE.SET_TOKEN('RESOURCE', mont_disp_attr_rec.RESOURCES);
550: FND_MESSAGE.SET_TOKEN('RESOURCE_INSTANCE', mont_disp_attr_rec.RESOURCE_INSTANCE_ID);
551: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
552: FND_MESSAGE.SET_TOKEN('LOCATOR', mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
553:
554:
555: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SPEC_NAME',mont_disp_attr_rec.SPEC_NAME);
556: wf_engine.setitemattrnumber(p_itemtype, p_itemkey,'SPEC_VERS',mont_disp_attr_rec.SPEC_VERS);
571: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'SUBINVENTORY',mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST
572: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
573:
574:
575: FND_MESSAGE.SET_TOKEN('SPEC_NAME', mont_disp_attr_rec.SPEC_NAME);
576: FND_MESSAGE.SET_TOKEN('SPEC_VERS', mont_disp_attr_rec.SPEC_VERS);
577: FND_MESSAGE.SET_TOKEN('SPEC_DESC', mont_disp_attr_rec.SPEC_STATUS_DESC);
578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
572: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST
573:
574:
575: FND_MESSAGE.SET_TOKEN('SPEC_NAME', mont_disp_attr_rec.SPEC_NAME);
576: FND_MESSAGE.SET_TOKEN('SPEC_VERS', mont_disp_attr_rec.SPEC_VERS);
577: FND_MESSAGE.SET_TOKEN('SPEC_DESC', mont_disp_attr_rec.SPEC_STATUS_DESC);
578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
573:
574:
575: FND_MESSAGE.SET_TOKEN('SPEC_NAME', mont_disp_attr_rec.SPEC_NAME);
576: FND_MESSAGE.SET_TOKEN('SPEC_VERS', mont_disp_attr_rec.SPEC_VERS);
577: FND_MESSAGE.SET_TOKEN('SPEC_DESC', mont_disp_attr_rec.SPEC_STATUS_DESC);
578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
574:
575: FND_MESSAGE.SET_TOKEN('SPEC_NAME', mont_disp_attr_rec.SPEC_NAME);
576: FND_MESSAGE.SET_TOKEN('SPEC_VERS', mont_disp_attr_rec.SPEC_VERS);
577: FND_MESSAGE.SET_TOKEN('SPEC_DESC', mont_disp_attr_rec.SPEC_STATUS_DESC);
578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
575: FND_MESSAGE.SET_TOKEN('SPEC_NAME', mont_disp_attr_rec.SPEC_NAME);
576: FND_MESSAGE.SET_TOKEN('SPEC_VERS', mont_disp_attr_rec.SPEC_VERS);
577: FND_MESSAGE.SET_TOKEN('SPEC_DESC', mont_disp_attr_rec.SPEC_STATUS_DESC);
578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
576: FND_MESSAGE.SET_TOKEN('SPEC_VERS', mont_disp_attr_rec.SPEC_VERS);
577: FND_MESSAGE.SET_TOKEN('SPEC_DESC', mont_disp_attr_rec.SPEC_STATUS_DESC);
578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
584: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
577: FND_MESSAGE.SET_TOKEN('SPEC_DESC', mont_disp_attr_rec.SPEC_STATUS_DESC);
578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
584: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
585: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
584: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
585: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
586: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- INVCONV, NSRIVAST
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
584: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
585: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
586: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
587:
580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
584: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
585: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
586: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
587:
588: ELSE
581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
584: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
585: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
586: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
587:
588: ELSE
589: /* This is an Item Spec VR */
582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST
583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
584: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
585: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
586: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
587:
588: ELSE
589: /* This is an Item Spec VR */
590: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_ITEM');
586: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
587:
588: ELSE
589: /* This is an Item Spec VR */
590: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_ITEM');
591: /*=================================================
592: BUG#4912074 - Changed source of cursor data.
593: =================================================*/
594: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_number);
590: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_ITEM');
591: /*=================================================
592: BUG#4912074 - Changed source of cursor data.
593: =================================================*/
594: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_number);
595: FND_MESSAGE.SET_TOKEN('ITEM_DESC', l_item_desc);
596: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
597: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
598: FND_MESSAGE.SET_TOKEN('LOCATOR', l_location);
591: /*=================================================
592: BUG#4912074 - Changed source of cursor data.
593: =================================================*/
594: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_number);
595: FND_MESSAGE.SET_TOKEN('ITEM_DESC', l_item_desc);
596: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
597: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
598: FND_MESSAGE.SET_TOKEN('LOCATOR', l_location);
599:
592: BUG#4912074 - Changed source of cursor data.
593: =================================================*/
594: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_number);
595: FND_MESSAGE.SET_TOKEN('ITEM_DESC', l_item_desc);
596: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
597: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
598: FND_MESSAGE.SET_TOKEN('LOCATOR', l_location);
599:
600:
593: =================================================*/
594: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_number);
595: FND_MESSAGE.SET_TOKEN('ITEM_DESC', l_item_desc);
596: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
597: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
598: FND_MESSAGE.SET_TOKEN('LOCATOR', l_location);
599:
600:
601:
594: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_number);
595: FND_MESSAGE.SET_TOKEN('ITEM_DESC', l_item_desc);
596: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST
597: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', disp_attr_rec.subinventory); -- INVCONV, NSRIVAST
598: FND_MESSAGE.SET_TOKEN('LOCATOR', l_location);
599:
600:
601:
602: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
632: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'OWNER_ORGN_CODE',l_orgn_code);
633: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',l_location);
634:
635:
636: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
637: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
638: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_STATUS_DESC);
639: /*=======================================
640: BUG#4912074 Changed source of data.
633: wf_engine.setitemattrtext(p_itemtype, p_itemkey,'LOCATOR',l_location);
634:
635:
636: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
637: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
638: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_STATUS_DESC);
639: /*=======================================
640: BUG#4912074 Changed source of data.
641: =======================================*/
634:
635:
636: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
637: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
638: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_STATUS_DESC);
639: /*=======================================
640: BUG#4912074 Changed source of data.
641: =======================================*/
642: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', l_lookup_code);
638: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_STATUS_DESC);
639: /*=======================================
640: BUG#4912074 Changed source of data.
641: =======================================*/
642: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', l_lookup_code);
643: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', l_orgn_code);
644: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', l_orgn_name);
645: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
646: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
639: /*=======================================
640: BUG#4912074 Changed source of data.
641: =======================================*/
642: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', l_lookup_code);
643: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', l_orgn_code);
644: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', l_orgn_name);
645: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
646: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
647: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
640: BUG#4912074 Changed source of data.
641: =======================================*/
642: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', l_lookup_code);
643: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', l_orgn_code);
644: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', l_orgn_name);
645: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
646: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
647: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
648: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
641: =======================================*/
642: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', l_lookup_code);
643: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', l_orgn_code);
644: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', l_orgn_name);
645: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
646: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
647: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
648: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
649:
642: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', l_lookup_code);
643: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', l_orgn_code);
644: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', l_orgn_name);
645: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
646: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
647: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
648: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
649:
650: END IF;
643: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', l_orgn_code);
644: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', l_orgn_name);
645: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
646: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
647: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
648: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
649:
650: END IF;
651:
644: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', l_orgn_name);
645: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
646: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
647: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
648: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
649:
650: END IF;
651:
652:
651:
652:
653:
654: /* Set the message attribute, MSG, in the workflow */
655: FND_MESSAGE.SET_TOKEN('MSG', FND_MESSAGE.GET() );
656:
657: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
658:
659: WF_ENGINE.SETITEMATTRNUMBER(itemtype => p_itemtype,itemkey => p_itemkey,