eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_STATUS_PUB dependencies on FND_MESSAGE

Line 49: FND_MESSAGE.SET_NAME('GMD','GMD_ATTACH_RESOURCES');

45: x_o_res_act_cnt := x_o_res_act_cnt + 1;
46: X_activity := x_activity||oprn_rec.activity||', ';
47: END LOOP;
48: IF (x_o_res_act_cnt > 0) THEN
49: FND_MESSAGE.SET_NAME('GMD','GMD_ATTACH_RESOURCES');
50: FND_MESSAGE.SET_TOKEN('ACTIVITY',x_activity);
51: FND_MSG_PUB.ADD;
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: END IF;

Line 50: FND_MESSAGE.SET_TOKEN('ACTIVITY',x_activity);

46: X_activity := x_activity||oprn_rec.activity||', ';
47: END LOOP;
48: IF (x_o_res_act_cnt > 0) THEN
49: FND_MESSAGE.SET_NAME('GMD','GMD_ATTACH_RESOURCES');
50: FND_MESSAGE.SET_TOKEN('ACTIVITY',x_activity);
51: FND_MSG_PUB.ADD;
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: END IF;
54: END validate_operation;

Line 337: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

333: /* Get the TO status type and description */
334: OPEN get_To_status_details(P_to_status);
335: FETCH get_To_status_details INTO l_to_status_type, l_to_status_desc;
336: IF get_To_status_details%NOTFOUND THEN
337: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
338: FND_MESSAGE.SET_TOKEN ('MISSING', FND_MESSAGE.GET);
339: FND_MSG_PUB.ADD;
340: x_return_status := FND_API.g_ret_sts_error;
341: CLOSE get_To_status_details;

Line 338: FND_MESSAGE.SET_TOKEN ('MISSING', FND_MESSAGE.GET);

334: OPEN get_To_status_details(P_to_status);
335: FETCH get_To_status_details INTO l_to_status_type, l_to_status_desc;
336: IF get_To_status_details%NOTFOUND THEN
337: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
338: FND_MESSAGE.SET_TOKEN ('MISSING', FND_MESSAGE.GET);
339: FND_MSG_PUB.ADD;
340: x_return_status := FND_API.g_ret_sts_error;
341: CLOSE get_To_status_details;
342: RAISE status_update_failure;

Line 356: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');

352: ,p_entity_version);
353: FETCH get_curr_recipe_status INTO l_entity_id, l_entity_no,
354: l_entity_version, l_from_status;
355: IF get_curr_recipe_status%NOTFOUND THEN
356: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
357: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
358: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
359: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
360: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

Line 357: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);

353: FETCH get_curr_recipe_status INTO l_entity_id, l_entity_no,
354: l_entity_version, l_from_status;
355: IF get_curr_recipe_status%NOTFOUND THEN
356: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
357: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
358: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
359: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
360: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
361: FND_MSG_PUB.ADD;

Line 358: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);

354: l_entity_version, l_from_status;
355: IF get_curr_recipe_status%NOTFOUND THEN
356: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
357: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
358: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
359: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
360: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
361: FND_MSG_PUB.ADD;
362: x_return_status := FND_API.g_ret_sts_error;

Line 359: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);

355: IF get_curr_recipe_status%NOTFOUND THEN
356: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
357: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
358: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
359: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
360: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
361: FND_MSG_PUB.ADD;
362: x_return_status := FND_API.g_ret_sts_error;
363: CLOSE get_curr_recipe_status;

Line 360: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

356: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
357: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
358: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
359: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
360: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
361: FND_MSG_PUB.ADD;
362: x_return_status := FND_API.g_ret_sts_error;
363: CLOSE get_curr_recipe_status;
364: RAISE status_update_failure;

Line 375: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');

371: ,p_entity_version);
372: FETCH get_curr_formula_status INTO l_entity_id, l_entity_no,
373: l_entity_version, l_from_status;
374: IF get_curr_formula_status%NOTFOUND THEN
375: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
376: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
377: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
378: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
379: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

Line 376: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);

372: FETCH get_curr_formula_status INTO l_entity_id, l_entity_no,
373: l_entity_version, l_from_status;
374: IF get_curr_formula_status%NOTFOUND THEN
375: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
376: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
377: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
378: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
379: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
380: FND_MSG_PUB.ADD;

Line 377: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);

373: l_entity_version, l_from_status;
374: IF get_curr_formula_status%NOTFOUND THEN
375: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
376: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
377: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
378: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
379: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
380: FND_MSG_PUB.ADD;
381: x_return_status := FND_API.g_ret_sts_error;

Line 378: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);

374: IF get_curr_formula_status%NOTFOUND THEN
375: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
376: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
377: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
378: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
379: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
380: FND_MSG_PUB.ADD;
381: x_return_status := FND_API.g_ret_sts_error;
382: CLOSE get_curr_formula_status;

Line 379: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

375: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
376: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
377: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
378: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
379: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
380: FND_MSG_PUB.ADD;
381: x_return_status := FND_API.g_ret_sts_error;
382: CLOSE get_curr_formula_status;
383: RAISE status_update_failure;

Line 404: FND_MESSAGE.SET_NAME('GMD','GMD_TOTAL_OUTPUT_ZERO');

400: gmd_debug.put_line('TOQ value is '||l_toq);
401: END IF;
402:
403: IF (l_toq = 0) THEN
404: FND_MESSAGE.SET_NAME('GMD','GMD_TOTAL_OUTPUT_ZERO');
405: FND_MSG_PUB.ADD;
406: x_return_status := FND_API.g_ret_sts_error;
407: RAISE status_update_failure;
408: END IF;

Line 417: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXPR_ITEMS_FOUND');

413: OPEN Cur_experimental_items(p_entity_id);
414: FETCH Cur_experimental_items INTO l_expr_items_found;
415: CLOSE Cur_experimental_items;
416: IF l_expr_items_found > 0 THEN
417: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXPR_ITEMS_FOUND');
418: FND_MSG_PUB.ADD;
419: x_return_status := FND_API.g_ret_sts_error;
420: RAISE status_update_failure;
421: END IF;

Line 434: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');

430: ,p_entity_version);
431: FETCH get_curr_routing_status INTO l_entity_id, l_entity_no,
432: l_entity_version, l_from_status;
433: IF get_curr_routing_status%NOTFOUND THEN
434: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
435: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
436: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
437: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
438: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

Line 435: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);

431: FETCH get_curr_routing_status INTO l_entity_id, l_entity_no,
432: l_entity_version, l_from_status;
433: IF get_curr_routing_status%NOTFOUND THEN
434: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
435: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
436: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
437: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
438: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
439: FND_MSG_PUB.ADD;

Line 436: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);

432: l_entity_version, l_from_status;
433: IF get_curr_routing_status%NOTFOUND THEN
434: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
435: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
436: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
437: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
438: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
439: FND_MSG_PUB.ADD;
440: x_return_status := FND_API.g_ret_sts_error;

Line 437: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);

433: IF get_curr_routing_status%NOTFOUND THEN
434: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
435: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
436: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
437: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
438: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
439: FND_MSG_PUB.ADD;
440: x_return_status := FND_API.g_ret_sts_error;
441: CLOSE get_curr_routing_status;

Line 438: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

434: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
435: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
436: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
437: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
438: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
439: FND_MSG_PUB.ADD;
440: x_return_status := FND_API.g_ret_sts_error;
441: CLOSE get_curr_routing_status;
442: RAISE status_update_failure;

Line 453: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');

449: ,p_entity_version);
450: FETCH get_curr_operation_status INTO l_entity_id, l_entity_no,
451: l_entity_version, l_from_status;
452: IF get_curr_operation_status%NOTFOUND THEN
453: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
454: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
455: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
456: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
457: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

Line 454: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);

450: FETCH get_curr_operation_status INTO l_entity_id, l_entity_no,
451: l_entity_version, l_from_status;
452: IF get_curr_operation_status%NOTFOUND THEN
453: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
454: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
455: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
456: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
457: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
458: FND_MSG_PUB.ADD;

Line 455: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);

451: l_entity_version, l_from_status;
452: IF get_curr_operation_status%NOTFOUND THEN
453: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
454: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
455: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
456: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
457: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
458: FND_MSG_PUB.ADD;
459: x_return_status := FND_API.g_ret_sts_error;

Line 456: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);

452: IF get_curr_operation_status%NOTFOUND THEN
453: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
454: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
455: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
456: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
457: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
458: FND_MSG_PUB.ADD;
459: x_return_status := FND_API.g_ret_sts_error;
460: CLOSE get_curr_operation_status;

Line 457: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

453: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
454: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
455: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
456: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
457: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
458: FND_MSG_PUB.ADD;
459: x_return_status := FND_API.g_ret_sts_error;
460: CLOSE get_curr_operation_status;
461: RAISE status_update_failure;

Line 486: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

482: OPEN get_curr_vr_status(p_entity_id);
483: -- Bug 53487418 added l_recipe_use
484: FETCH get_curr_vr_status INTO l_entity_id, l_from_status, l_recipe_use;
485: IF get_curr_vr_status%NOTFOUND THEN
486: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
487: FND_MESSAGE.SET_TOKEN ('MISSING','P_ENTITY_ID');
488: FND_MSG_PUB.ADD;
489: x_return_status := FND_API.g_ret_sts_error;
490: CLOSE get_curr_vr_status;

Line 487: FND_MESSAGE.SET_TOKEN ('MISSING','P_ENTITY_ID');

483: -- Bug 53487418 added l_recipe_use
484: FETCH get_curr_vr_status INTO l_entity_id, l_from_status, l_recipe_use;
485: IF get_curr_vr_status%NOTFOUND THEN
486: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
487: FND_MESSAGE.SET_TOKEN ('MISSING','P_ENTITY_ID');
488: FND_MSG_PUB.ADD;
489: x_return_status := FND_API.g_ret_sts_error;
490: CLOSE get_curr_vr_status;
491: RAISE status_update_failure;

Line 553: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');

549: ,p_entity_version);
550: FETCH get_curr_subst_status INTO l_entity_id, l_entity_no,
551: l_entity_version, l_from_status;
552: IF get_curr_subst_status%NOTFOUND THEN
553: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
554: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
555: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
556: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
557: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

Line 554: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);

550: FETCH get_curr_subst_status INTO l_entity_id, l_entity_no,
551: l_entity_version, l_from_status;
552: IF get_curr_subst_status%NOTFOUND THEN
553: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
554: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
555: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
556: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
557: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
558: FND_MSG_PUB.ADD;

Line 555: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);

551: l_entity_version, l_from_status;
552: IF get_curr_subst_status%NOTFOUND THEN
553: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
554: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
555: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
556: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
557: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
558: FND_MSG_PUB.ADD;
559: x_return_status := FND_API.g_ret_sts_error;

Line 556: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);

552: IF get_curr_subst_status%NOTFOUND THEN
553: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
554: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
555: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
556: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
557: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
558: FND_MSG_PUB.ADD;
559: x_return_status := FND_API.g_ret_sts_error;
560: CLOSE get_curr_subst_status;

Line 557: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);

553: FND_MESSAGE.SET_NAME ('GMD', 'GMD_MISSING');
554: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
555: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
556: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
557: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
558: FND_MSG_PUB.ADD;
559: x_return_status := FND_API.g_ret_sts_error;
560: CLOSE get_curr_subst_status;
561: RAISE status_update_failure;

Line 565: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNKNOWN_ENTITY');

561: RAISE status_update_failure;
562: END IF;
563: CLOSE get_curr_subst_status;
564: ELSE -- not able to recognize the entity name
565: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNKNOWN_ENTITY');
566: FND_MESSAGE.SET_TOKEN('ENTITY_NAME', P_entity_name);
567: FND_MSG_PUB.ADD;
568: x_return_status := FND_API.g_ret_sts_error;
569: RAISE status_update_failure;

Line 566: FND_MESSAGE.SET_TOKEN('ENTITY_NAME', P_entity_name);

562: END IF;
563: CLOSE get_curr_subst_status;
564: ELSE -- not able to recognize the entity name
565: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNKNOWN_ENTITY');
566: FND_MESSAGE.SET_TOKEN('ENTITY_NAME', P_entity_name);
567: FND_MSG_PUB.ADD;
568: x_return_status := FND_API.g_ret_sts_error;
569: RAISE status_update_failure;
570: END IF;

Line 594: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_TARGET_STATUS');

590: IF (P_to_status <> l_from_status) THEN
591: OPEN validate_To_status(P_to_status ,l_from_status);
592: FETCH validate_To_status INTO l_from_status_type, l_from_status_desc, l_target_status;
593: IF validate_To_status%NOTFOUND THEN
594: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_TARGET_STATUS');
595: FND_MESSAGE.SET_TOKEN ('TO_STATUS', l_to_status_desc);
596: FND_MSG_PUB.ADD;
597: x_return_status := FND_API.g_ret_sts_error;
598: CLOSE validate_To_status;

Line 595: FND_MESSAGE.SET_TOKEN ('TO_STATUS', l_to_status_desc);

591: OPEN validate_To_status(P_to_status ,l_from_status);
592: FETCH validate_To_status INTO l_from_status_type, l_from_status_desc, l_target_status;
593: IF validate_To_status%NOTFOUND THEN
594: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_TARGET_STATUS');
595: FND_MESSAGE.SET_TOKEN ('TO_STATUS', l_to_status_desc);
596: FND_MSG_PUB.ADD;
597: x_return_status := FND_API.g_ret_sts_error;
598: CLOSE validate_To_status;
599: RAISE status_update_failure;

Line 603: FND_MESSAGE.SET_NAME ('GMD', 'GMD_STS_SAME');

599: RAISE status_update_failure;
600: END IF;
601: CLOSE validate_To_status;
602: ELSE
603: FND_MESSAGE.SET_NAME ('GMD', 'GMD_STS_SAME');
604: FND_MESSAGE.SET_TOKEN ('NAME', P_entity_name);
605: FND_MSG_PUB.ADD;
606: RETURN;
607: END IF;

Line 604: FND_MESSAGE.SET_TOKEN ('NAME', P_entity_name);

600: END IF;
601: CLOSE validate_To_status;
602: ELSE
603: FND_MESSAGE.SET_NAME ('GMD', 'GMD_STS_SAME');
604: FND_MESSAGE.SET_TOKEN ('NAME', P_entity_name);
605: FND_MSG_PUB.ADD;
606: RETURN;
607: END IF;
608:

Line 633: FND_MESSAGE.SET_NAME('GMD',l_mesg_text);

629: 'VALIDITY','GMD_VR_BTCH_DEP') INTO l_mesg_text
630: FROM sys.dual;
631:
632: IF l_entity_name IN ('FORMULA','OPERATION','ROUTING') THEN
633: FND_MESSAGE.SET_NAME('GMD',l_mesg_text);
634: FND_MSG_PUB.ADD;
635: x_return_status := FND_API.g_ret_sts_error;
636: RAISE status_update_failure;
637: ELSIF l_entity_name IN ('RECIPE','VALIDITY') THEN

Line 639: FND_MESSAGE.SET_NAME('GMD',l_mesg_text);

635: x_return_status := FND_API.g_ret_sts_error;
636: RAISE status_update_failure;
637: ELSIF l_entity_name IN ('RECIPE','VALIDITY') THEN
638: IF NOT P_ignore_flag THEN
639: FND_MESSAGE.SET_NAME('GMD',l_mesg_text);
640: FND_MSG_PUB.ADD;
641: x_return_status := FND_API.g_ret_sts_error;
642: RAISE status_update_failure;
643: END IF; -- p_ignore_flag is false

Line 674: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');

670: * least one operation which is not approved. The function
671: * returns TRUE if entity does not have dependents (formula,
672: * operation) or if to_status does not require the check
673: * (frozen, on-hold, obsolete, some version of New). */
674: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');
675: FND_MSG_PUB.ADD;
676: x_return_status := FND_API.g_ret_sts_error;
677: RAISE status_update_failure;
678: ELSE

Line 714: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');

710: /*status change of the validity rules then the user has to */
711: /*do them manually */
712: IF GMD_ERES_UTILS.check_recipe_validity_eres (p_recipe_id => l_entity_id
713: ,p_to_status => P_to_status) THEN
714: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');
715: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
716: FND_MSG_PUB.ADD;
717: x_return_status := FND_API.g_ret_sts_error;
718: RAISE status_update_failure;

Line 715: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);

711: /*do them manually */
712: IF GMD_ERES_UTILS.check_recipe_validity_eres (p_recipe_id => l_entity_id
713: ,p_to_status => P_to_status) THEN
714: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');
715: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
716: FND_MSG_PUB.ADD;
717: x_return_status := FND_API.g_ret_sts_error;
718: RAISE status_update_failure;
719: END IF;

Line 746: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_VR_STATUS');

742: WHERE recipe_id = l_entity_id
743: AND to_number(validity_rule_status) < to_number('1000') ;
744: END IF;
745: ELSE
746: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_VR_STATUS');
747: FND_MESSAGE.SET_TOKEN('TO_STATUS',P_to_status);
748: FND_MSG_PUB.ADD;
749: x_return_status := FND_API.g_ret_sts_error;
750: RAISE status_update_failure;

Line 747: FND_MESSAGE.SET_TOKEN('TO_STATUS',P_to_status);

743: AND to_number(validity_rule_status) < to_number('1000') ;
744: END IF;
745: ELSE
746: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_VR_STATUS');
747: FND_MESSAGE.SET_TOKEN('TO_STATUS',P_to_status);
748: FND_MSG_PUB.ADD;
749: x_return_status := FND_API.g_ret_sts_error;
750: RAISE status_update_failure;
751: END IF; /* if feedback is OK */

Line 880: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');

876: -- Commit your changes
877: Commit;
878:
879: IF (x_return_status = 'P') THEN
880: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');
881:
882: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
883: fnd_message.set_token('OBJECT_NAME',l_entity_no );
884: fnd_message.set_token('OBJECT_VERSION',l_entity_version);

Line 882: fnd_message.set_token('OBJECT_TYPE',l_entity_name );

878:
879: IF (x_return_status = 'P') THEN
880: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');
881:
882: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
883: fnd_message.set_token('OBJECT_NAME',l_entity_no );
884: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
885: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
886: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );

Line 883: fnd_message.set_token('OBJECT_NAME',l_entity_no );

879: IF (x_return_status = 'P') THEN
880: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');
881:
882: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
883: fnd_message.set_token('OBJECT_NAME',l_entity_no );
884: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
885: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
886: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
887: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );

Line 884: fnd_message.set_token('OBJECT_VERSION',l_entity_version);

880: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');
881:
882: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
883: fnd_message.set_token('OBJECT_NAME',l_entity_no );
884: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
885: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
886: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
887: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
888: END IF;

Line 885: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );

881:
882: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
883: fnd_message.set_token('OBJECT_NAME',l_entity_no );
884: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
885: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
886: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
887: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
888: END IF;
889:

Line 886: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );

882: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
883: fnd_message.set_token('OBJECT_NAME',l_entity_no );
884: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
885: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
886: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
887: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
888: END IF;
889:
890: ELSE

Line 887: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );

883: fnd_message.set_token('OBJECT_NAME',l_entity_no );
884: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
885: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
886: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
887: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
888: END IF;
889:
890: ELSE
891: x_return_status := FND_API.G_RET_STS_ERROR;