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 341: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

603: RAISE status_update_failure;
604: END IF;
605: CLOSE validate_To_status;
606: ELSE
607: FND_MESSAGE.SET_NAME ('GMD', 'GMD_STS_SAME');
608: FND_MESSAGE.SET_TOKEN ('NAME', P_entity_name);
609: FND_MSG_PUB.ADD;
610: RETURN;
611: END IF;

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

604: END IF;
605: CLOSE validate_To_status;
606: ELSE
607: FND_MESSAGE.SET_NAME ('GMD', 'GMD_STS_SAME');
608: FND_MESSAGE.SET_TOKEN ('NAME', P_entity_name);
609: FND_MSG_PUB.ADD;
610: RETURN;
611: END IF;
612:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

882: -- Commit your changes
883: Commit;
884: END IF;
885: IF (x_return_status = 'P') THEN
886: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');
887:
888: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
889: fnd_message.set_token('OBJECT_NAME',l_entity_no );
890: fnd_message.set_token('OBJECT_VERSION',l_entity_version);

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

884: END IF;
885: IF (x_return_status = 'P') THEN
886: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');
887:
888: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
889: fnd_message.set_token('OBJECT_NAME',l_entity_no );
890: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
891: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
892: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );

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

885: IF (x_return_status = 'P') THEN
886: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');
887:
888: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
889: fnd_message.set_token('OBJECT_NAME',l_entity_no );
890: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
891: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
892: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
893: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );

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

886: fnd_message.set_name('GMD','GMD_CONC_PEND_STATUS');
887:
888: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
889: fnd_message.set_token('OBJECT_NAME',l_entity_no );
890: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
891: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
892: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
893: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
894: END IF;

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

887:
888: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
889: fnd_message.set_token('OBJECT_NAME',l_entity_no );
890: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
891: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
892: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
893: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
894: END IF;
895:

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

888: fnd_message.set_token('OBJECT_TYPE',l_entity_name );
889: fnd_message.set_token('OBJECT_NAME',l_entity_no );
890: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
891: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
892: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
893: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
894: END IF;
895:
896: ELSE

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

889: fnd_message.set_token('OBJECT_NAME',l_entity_no );
890: fnd_message.set_token('OBJECT_VERSION',l_entity_version);
891: fnd_message.set_token('FROM_STATUS',get_status_meaning(l_from_status) );
892: fnd_message.set_token('TO_STATUS',get_status_meaning(P_to_status) );
893: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
894: END IF;
895:
896: ELSE
897: x_return_status := FND_API.G_RET_STS_ERROR;