DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on FND_MESSAGE

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 547: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_VR_MON');

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

Line 549: FND_MESSAGE.SET_TOKEN('RESOURCE', mont_disp_attr_rec.RESOURCES);

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:

Line 550: FND_MESSAGE.SET_TOKEN('RESOURCE_INSTANCE', mont_disp_attr_rec.RESOURCE_INSTANCE_ID);

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:

Line 551: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', mont_disp_attr_rec.SUBINV); -- INVCONV, NSRIVAST

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

Line 552: FND_MESSAGE.SET_TOKEN('LOCATOR', mont_disp_attr_rec.LOC); -- INVCONV, NSRIVAST

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

Line 575: FND_MESSAGE.SET_TOKEN('SPEC_NAME', mont_disp_attr_rec.SPEC_NAME);

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

Line 576: FND_MESSAGE.SET_TOKEN('SPEC_VERS', mont_disp_attr_rec.SPEC_VERS);

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

Line 577: FND_MESSAGE.SET_TOKEN('SPEC_DESC', mont_disp_attr_rec.SPEC_STATUS_DESC);

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

Line 578: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', mont_disp_attr_rec.MEANING);

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

Line 579: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGN_CODE); -- 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);

Line 580: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGN_NAME); -- INVCONV, NSRIVAST

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

Line 581: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', mont_disp_attr_rec.ORGANIZATION_CODE); -- INVCONV, NSRIVAST

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

Line 582: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', mont_disp_attr_rec.ORGANIZATION_NAME ); -- INVCONV, NSRIVAST

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

Line 583: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);

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:

Line 584: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);

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

Line 585: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);

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 */

Line 586: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);

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

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

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

Line 595: FND_MESSAGE.SET_TOKEN('ITEM_DESC', l_item_desc);

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:

Line 596: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE); -- INVCONV, NSRIVAST

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:

Line 597: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', disp_attr_rec.subinventory); -- INVCONV, NSRIVAST

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:

Line 598: FND_MESSAGE.SET_TOKEN('LOCATOR', l_location);

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,

Line 636: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);

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.

Line 637: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);

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: =======================================*/

Line 638: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_STATUS_DESC);

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

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

Line 643: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', l_orgn_code);

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

Line 644: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', l_orgn_name);

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

Line 645: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);

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:

Line 646: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);

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;

Line 647: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);

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:

Line 648: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);

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:

Line 655: FND_MESSAGE.SET_TOKEN('MSG', FND_MESSAGE.GET() );

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,