DBA Data[Home] [Help]

APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on FND_MESSAGE

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

328: /* Depending on whether the Spec is for an item or monitor, fill out the
329: tokenized message and set it in the workflow */
330: if (disp_attr_rec.SPEC_TYPE = 'M') THEN
331: /* This is a monitoring Spec */
332: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_MON');
333: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
334: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Monitoring');
335: FND_MESSAGE.SET_TOKEN('OVERLAY', disp_attr_rec.OVERLAY_IND);
336: FND_MESSAGE.SET_TOKEN('BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);

Line 333: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);

329: tokenized message and set it in the workflow */
330: if (disp_attr_rec.SPEC_TYPE = 'M') THEN
331: /* This is a monitoring Spec */
332: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_MON');
333: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
334: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Monitoring');
335: FND_MESSAGE.SET_TOKEN('OVERLAY', disp_attr_rec.OVERLAY_IND);
336: FND_MESSAGE.SET_TOKEN('BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
337: ELSE

Line 334: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Monitoring');

330: if (disp_attr_rec.SPEC_TYPE = 'M') THEN
331: /* This is a monitoring Spec */
332: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_MON');
333: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
334: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Monitoring');
335: FND_MESSAGE.SET_TOKEN('OVERLAY', disp_attr_rec.OVERLAY_IND);
336: FND_MESSAGE.SET_TOKEN('BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
337: ELSE
338: /* This is an Item Spec */

Line 335: FND_MESSAGE.SET_TOKEN('OVERLAY', disp_attr_rec.OVERLAY_IND);

331: /* This is a monitoring Spec */
332: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_MON');
333: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
334: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Monitoring');
335: FND_MESSAGE.SET_TOKEN('OVERLAY', disp_attr_rec.OVERLAY_IND);
336: FND_MESSAGE.SET_TOKEN('BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
337: ELSE
338: /* This is an Item Spec */
339: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_ITEM');

Line 336: FND_MESSAGE.SET_TOKEN('BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);

332: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_MON');
333: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
334: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Monitoring');
335: FND_MESSAGE.SET_TOKEN('OVERLAY', disp_attr_rec.OVERLAY_IND);
336: FND_MESSAGE.SET_TOKEN('BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
337: ELSE
338: /* This is an Item Spec */
339: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_ITEM');
340: --FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.ITEM_NO);

Line 339: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_ITEM');

335: FND_MESSAGE.SET_TOKEN('OVERLAY', disp_attr_rec.OVERLAY_IND);
336: FND_MESSAGE.SET_TOKEN('BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
337: ELSE
338: /* This is an Item Spec */
339: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_ITEM');
340: --FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.ITEM_NO);
341: --FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.ITEM_DESC1);
342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);

Line 340: --FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.ITEM_NO);

336: FND_MESSAGE.SET_TOKEN('BASE_SPEC', disp_attr_rec.BASE_SPEC_ID);
337: ELSE
338: /* This is an Item Spec */
339: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_ITEM');
340: --FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.ITEM_NO);
341: --FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.ITEM_DESC1);
342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);
344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);

Line 341: --FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.ITEM_DESC1);

337: ELSE
338: /* This is an Item Spec */
339: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_ITEM');
340: --FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.ITEM_NO);
341: --FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.ITEM_DESC1);
342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);
344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);
345: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE);

Line 342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);

338: /* This is an Item Spec */
339: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_ITEM');
340: --FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.ITEM_NO);
341: --FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.ITEM_DESC1);
342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);
344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);
345: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE);
346: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);

Line 343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);

339: FND_MESSAGE.SET_NAME('GMD','GMD_SPEC_APPROVAL_ITEM');
340: --FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.ITEM_NO);
341: --FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.ITEM_DESC1);
342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);
344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);
345: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE);
346: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
347: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Item');

Line 344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);

340: --FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.ITEM_NO);
341: --FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.ITEM_DESC1);
342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);
344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);
345: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE);
346: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
347: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Item');
348: END IF;

Line 345: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE);

341: --FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.ITEM_DESC1);
342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);
344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);
345: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE);
346: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
347: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Item');
348: END IF;
349:

Line 346: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);

342: --FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE);
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);
344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);
345: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE);
346: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
347: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Item');
348: END IF;
349:
350: /* These are the common attributes in both messages */

Line 347: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Item');

343: FND_MESSAGE.SET_TOKEN('ITEM_NO', disp_attr_rec.CONCATENATED_SEGMENTS);
344: FND_MESSAGE.SET_TOKEN('ITEM_DESC', disp_attr_rec.DESCRIPTION);
345: FND_MESSAGE.SET_TOKEN('GRADE', disp_attr_rec.GRADE_CODE);
346: --FND_MESSAGE.SET_TOKEN('SPEC_TYPE', disp_attr_rec.SPEC_TYPE);
347: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Item');
348: END IF;
349:
350: /* These are the common attributes in both messages */
351: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);

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

347: FND_MESSAGE.SET_TOKEN('SPEC_TYPE', 'Item');
348: END IF;
349:
350: /* These are the common attributes in both messages */
351: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
352: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
353: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_DESC);
354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);
355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);

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

348: END IF;
349:
350: /* These are the common attributes in both messages */
351: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
352: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
353: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_DESC);
354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);
355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);
356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);

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

349:
350: /* These are the common attributes in both messages */
351: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
352: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
353: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_DESC);
354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);
355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);
356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);
357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST

Line 354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);

350: /* These are the common attributes in both messages */
351: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
352: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
353: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_DESC);
354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);
355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);
356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);
357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST
358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST

Line 355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);

351: FND_MESSAGE.SET_TOKEN('SPEC_NAME', disp_attr_rec.SPEC_NAME);
352: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
353: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_DESC);
354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);
355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);
356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);
357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST
358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST
359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);

Line 356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);

352: FND_MESSAGE.SET_TOKEN('SPEC_VERS', disp_attr_rec.SPEC_VERS);
353: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_DESC);
354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);
355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);
356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);
357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST
358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST
359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);
360: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);

Line 357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST

353: FND_MESSAGE.SET_TOKEN('SPEC_DESC', disp_attr_rec.SPEC_DESC);
354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);
355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);
356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);
357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST
358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST
359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);
360: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
361: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);

Line 358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST

354: FND_MESSAGE.SET_TOKEN('SPEC_STATUS', disp_attr_rec.MEANING);
355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);
356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);
357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST
358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST
359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);
360: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
361: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
362: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);

Line 359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);

355: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.OWNER_ORGN_CODE);
356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);
357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST
358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST
359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);
360: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
361: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
362: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
363: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);

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

356: --FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGN_NAME);
357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST
358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST
359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);
360: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
361: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
362: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
363: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
364:

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

357: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_CODE', disp_attr_rec.ORGANIZATION_CODE); --INVCONV, NSRIVAST
358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST
359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);
360: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
361: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
362: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
363: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
364:
365:

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

358: FND_MESSAGE.SET_TOKEN('OWNER_ORGN_NAME', disp_attr_rec.ORGANIZATION_NAME); --INVCONV, NSRIVAST
359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);
360: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
361: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
362: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
363: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
364:
365:
366: /* Set the message attribute, MSG, in the workflow */

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

359: FND_MESSAGE.SET_TOKEN('OWNER_NAME', l_owner);
360: FND_MESSAGE.SET_TOKEN('REQUESTER', l_requester);
361: FND_MESSAGE.SET_TOKEN('START_STATUS_DESC', lStartStatus_DESC);
362: FND_MESSAGE.SET_TOKEN('TARGET_STATUS_DESC', lTargetStatus_DESC);
363: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
364:
365:
366: /* Set the message attribute, MSG, in the workflow */
367: -- FND_MESSAGE.SET_TOKEN('GMDQSPAP_MSG', FND_MESSAGE.GET() );

Line 367: -- FND_MESSAGE.SET_TOKEN('GMDQSPAP_MSG', FND_MESSAGE.GET() );

363: FND_MESSAGE.SET_TOKEN('APPROVER', l_userName);
364:
365:
366: /* Set the message attribute, MSG, in the workflow */
367: -- FND_MESSAGE.SET_TOKEN('GMDQSPAP_MSG', FND_MESSAGE.GET() );
368:
369:
370: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'GMDQSPAP_MSG', FND_MESSAGE.GET());
371:

Line 370: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'GMDQSPAP_MSG', FND_MESSAGE.GET());

366: /* Set the message attribute, MSG, in the workflow */
367: -- FND_MESSAGE.SET_TOKEN('GMDQSPAP_MSG', FND_MESSAGE.GET() );
368:
369:
370: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'GMDQSPAP_MSG', FND_MESSAGE.GET());
371:
372: l_wf_timeout := (l_wf_timeout * 24 * 60) / 4 ; -- Converting days into minutes
373:
374: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,