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_COMMON_VAL dependencies on FND_MESSAGE

Line 448: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_STATUS_CODE');

444: OPEN Status_cur(Status_code);
445: FETCH Status_cur INTO l_status_code, l_meaning, l_description;
446: IF (Status_cur%NOTFOUND) THEN
447: x_return_status := 'E';
448: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_STATUS_CODE');
449: FND_MSG_PUB.Add;
450: Else
451: x_return_status := 'S';
452: Meaning := l_meaning;

Line 675: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_CLS');

671: IF (Rout_hdr_cur%NOTFOUND) THEN
672: l_routing_class := NULL;
673: /* TPL cannot be calculated */
674: x_return_status := 'E';
675: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_CLS');
676: FND_MSG_PUB.Add;
677: END IF;
678: CLOSE Rout_hdr_cur;
679: IF (l_debug = 'Y') THEN

Line 688: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_UOM');

684: FETCH Rout_cls_cur INTO l_routing_uom;
685: IF (Rout_cls_cur%NOTFOUND) THEN
686: l_routing_uom := NULL;
687: x_return_status := 'E';
688: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_UOM');
689: FND_MSG_PUB.Add;
690: END IF;
691: CLOSE Rout_cls_cur;
692: IF (l_debug = 'Y') THEN

Line 713: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_UOM');

709: ,to_name => NULL);
710:
711: IF (NVL(l_routing_qty,0) < 0) THEN
712: x_return_status := 'E';
713: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_WO_ROUT_UOM');
714: FND_MSG_PUB.Add;
715: END IF;
716:
717: OPEN process_loss_cur(l_routing_class,l_routing_qty);

Line 723: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');

719: IF (process_loss_cur%NOTFOUND) THEN
720: /* Theo process loss has not been defined. */
721: l_routing_theo_loss := NULL;
722: x_return_status := 'E';
723: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');
724: FND_MSG_PUB.Add;
725: END IF;
726: CLOSE process_loss_cur;
727: IF (l_debug = 'Y') THEN

Line 789: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');

785: open process_loss_cur(l_routing_class,l_recipe_qty);
786: fetch process_loss_cur INTO l_recipe_theo_loss;
787: IF (process_loss_cur%NOTFOUND) THEN
788: x_return_status := 'E';
789: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');
790: FND_MSG_PUB.Add;
791: l_recipe_theo_loss := NULL;
792: l_recipe_pp_loss := NULL;
793: ELSE

Line 884: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');

880: open process_loss_cur(l_routing_class,l_validity_qty);
881: fetch process_loss_cur INTO x_recipe_theo_loss;
882: IF (process_loss_cur%NOTFOUND) THEN
883: x_return_status := 'E';
884: FND_MESSAGE.SET_NAME('GMD', 'GMD_TPL_NOT_DEFINED');
885: FND_MSG_PUB.Add;
886: x_recipe_theo_loss := NULL;
887: x_process_loss := NULL;
888: ELSE

Line 954: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

950: WHEN FND_API.g_exc_error THEN
951: NULL;
952: When Others then
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
955: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
958: P_data => x_msg_data);

Line 955: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

951: NULL;
952: When Others then
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
955: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
958: P_data => x_msg_data);
959: END Calculate_Process_loss;

Line 1073: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');

1069: END IF;
1070:
1071: /* If the x_uom is yet NULL then its an error */
1072: IF (x_uom IS NULL) Then
1073: FND_MESSAGE.SET_NAME('GMD', 'FM_SCALE_BAD_YIELD_TYPE');
1074: FND_MSG_PUB.Add;
1075: x_return_status := 'E';
1076: END IF;
1077:

Line 1125: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CALC_TOQ');

1121: ,to_name => NULL);
1122: IF l_temp_qty < 0 THEN
1123: x_ingredient_qty := NULL;
1124: x_return_status := 'Q';
1125: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CALC_TOQ');
1126: FND_MSG_PUB.Add;
1127: Exit;
1128: ELSE
1129: X_ingredient_qty := X_ingredient_qty + l_temp_qty;

Line 1148: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CALC_TOQ');

1144: ,to_name => NULL);
1145: IF l_temp_qty < 0 THEN
1146: x_product_qty := NULL;
1147: x_return_status := 'Q';
1148: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CALC_TOQ');
1149: FND_MSG_PUB.Add;
1150: Exit;
1151: ELSE
1152: x_product_qty := x_product_qty + l_temp_qty;

Line 1165: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1161: WHEN FND_API.g_exc_error THEN
1162: x_return_status := 'Q';
1163: WHEN Others THEN
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1166: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1167: FND_MSG_PUB.ADD;
1168: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1169: P_data => x_msg_data);

Line 1166: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1162: x_return_status := 'Q';
1163: WHEN Others THEN
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1166: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1167: FND_MSG_PUB.ADD;
1168: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1169: P_data => x_msg_data);
1170:

Line 1260: FND_MESSAGE.SET_NAME ('GMD', 'GMD_ERR_CALC_ROUT_FACT');

1256: /*as the calculate_total_qty routine was passing back the */
1257: /*return status as 'Q' if the ingredient conversions were */
1258: /*not setup, though the product conversions have been setup */
1259: FND_MSG_PUB.INITIALIZE;
1260: FND_MESSAGE.SET_NAME ('GMD', 'GMD_ERR_CALC_ROUT_FACT');
1261: FND_MSG_PUB.add;
1262: x_return_status := 'W';
1263: RETURN 1;
1264: END IF;

Line 1311: FND_MESSAGE.SET_NAME ('GMD', 'GMD_ERR_CALC_ROUT_FACT');

1307: IF l_product_qty > 0 THEN
1308: l_recipe_qty := l_product_qty;
1309: ELSE
1310: FND_MSG_PUB.INITIALIZE;
1311: FND_MESSAGE.SET_NAME ('GMD', 'GMD_ERR_CALC_ROUT_FACT');
1312: FND_MSG_PUB.add;
1313: x_return_status := 'W';
1314: RETURN 1;
1315: END IF;

Line 1593: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CONV_CAPACITY_UOM');

1589:
1590: IF (l_max_capacity < 0) THEN
1591: /* Set a message in our stack : the capacity conv has not occurred */
1592: x_return_status := 'E';
1593: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CONV_CAPACITY_UOM');
1594: FND_MSG_PUB.Add;
1595: END IF; /* when max cap is < 0 */
1596:
1597: /* Get the step qty : */

Line 2441: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');

2437: OPEN Cur_formula_own (pFormula_id, pInventory_item_id);
2438: FETCH Cur_formula_own INTO l_formula_no, l_formula_vers, l_organization_code;
2439: IF Cur_formula_own%FOUND THEN
2440: CLOSE Cur_formula_own;
2441: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2442: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2443: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2444: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2445: fnd_msg_pub.ADD;

Line 2442: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);

2438: FETCH Cur_formula_own INTO l_formula_no, l_formula_vers, l_organization_code;
2439: IF Cur_formula_own%FOUND THEN
2440: CLOSE Cur_formula_own;
2441: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2442: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2443: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2444: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2445: fnd_msg_pub.ADD;
2446: X_return_status := FND_API.g_ret_sts_error;

Line 2443: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);

2439: IF Cur_formula_own%FOUND THEN
2440: CLOSE Cur_formula_own;
2441: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2442: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2443: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2444: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2445: fnd_msg_pub.ADD;
2446: X_return_status := FND_API.g_ret_sts_error;
2447: RAISE VALIDATION_FAIL;

Line 2444: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);

2440: CLOSE Cur_formula_own;
2441: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2442: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2443: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2444: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2445: fnd_msg_pub.ADD;
2446: X_return_status := FND_API.g_ret_sts_error;
2447: RAISE VALIDATION_FAIL;
2448: END IF;

Line 2456: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');

2452: OPEN Cur_formula_own_revision (pFormula_id, pInventory_item_id,pRevision);
2453: FETCH Cur_formula_own_revision INTO l_formula_no, l_formula_vers, l_organization_code;
2454: IF Cur_formula_own_revision%FOUND THEN
2455: CLOSE Cur_formula_own_revision;
2456: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2457: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2458: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2459: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2460: fnd_msg_pub.ADD;

Line 2457: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);

2453: FETCH Cur_formula_own_revision INTO l_formula_no, l_formula_vers, l_organization_code;
2454: IF Cur_formula_own_revision%FOUND THEN
2455: CLOSE Cur_formula_own_revision;
2456: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2457: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2458: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2459: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2460: fnd_msg_pub.ADD;
2461: X_return_status := FND_API.g_ret_sts_error;

Line 2458: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);

2454: IF Cur_formula_own_revision%FOUND THEN
2455: CLOSE Cur_formula_own_revision;
2456: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2457: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2458: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2459: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2460: fnd_msg_pub.ADD;
2461: X_return_status := FND_API.g_ret_sts_error;
2462: RAISE VALIDATION_FAIL;

Line 2459: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);

2455: CLOSE Cur_formula_own_revision;
2456: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2457: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2458: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2459: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2460: fnd_msg_pub.ADD;
2461: X_return_status := FND_API.g_ret_sts_error;
2462: RAISE VALIDATION_FAIL;
2463: END IF;

Line 2473: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');

2469: OPEN Cur_recipe_own (pFormula_id, pInventory_item_id);
2470: FETCH Cur_recipe_own INTO l_recipe_no, l_recipe_version, l_organization_code;
2471: IF Cur_recipe_own%FOUND THEN
2472: CLOSE Cur_recipe_own;
2473: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2474: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2475: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2476: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2477: fnd_msg_pub.ADD;

Line 2474: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);

2470: FETCH Cur_recipe_own INTO l_recipe_no, l_recipe_version, l_organization_code;
2471: IF Cur_recipe_own%FOUND THEN
2472: CLOSE Cur_recipe_own;
2473: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2474: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2475: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2476: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2477: fnd_msg_pub.ADD;
2478: X_return_status := FND_API.g_ret_sts_error;

Line 2475: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);

2471: IF Cur_recipe_own%FOUND THEN
2472: CLOSE Cur_recipe_own;
2473: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2474: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2475: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2476: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2477: fnd_msg_pub.ADD;
2478: X_return_status := FND_API.g_ret_sts_error;
2479: RAISE VALIDATION_FAIL;

Line 2476: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);

2472: CLOSE Cur_recipe_own;
2473: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2474: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2475: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2476: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2477: fnd_msg_pub.ADD;
2478: X_return_status := FND_API.g_ret_sts_error;
2479: RAISE VALIDATION_FAIL;
2480: END IF;

Line 2488: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');

2484: OPEN Cur_recipe_own_revision (pFormula_id, pInventory_item_id,pRevision);
2485: FETCH Cur_recipe_own_revision INTO l_recipe_no, l_recipe_version, l_organization_code;
2486: IF Cur_recipe_own_revision%FOUND THEN
2487: CLOSE Cur_recipe_own_revision;
2488: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2489: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2490: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2491: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2492: fnd_msg_pub.ADD;

Line 2489: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);

2485: FETCH Cur_recipe_own_revision INTO l_recipe_no, l_recipe_version, l_organization_code;
2486: IF Cur_recipe_own_revision%FOUND THEN
2487: CLOSE Cur_recipe_own_revision;
2488: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2489: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2490: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2491: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2492: fnd_msg_pub.ADD;
2493: X_return_status := FND_API.g_ret_sts_error;

Line 2490: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);

2486: IF Cur_recipe_own_revision%FOUND THEN
2487: CLOSE Cur_recipe_own_revision;
2488: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2489: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2490: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2491: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2492: fnd_msg_pub.ADD;
2493: X_return_status := FND_API.g_ret_sts_error;
2494: RAISE VALIDATION_FAIL;

Line 2491: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);

2487: CLOSE Cur_recipe_own_revision;
2488: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2489: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2490: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2491: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2492: fnd_msg_pub.ADD;
2493: X_return_status := FND_API.g_ret_sts_error;
2494: RAISE VALIDATION_FAIL;
2495: END IF;

Line 2504: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');

2500: -- Bug 5237126 MK Changed the order of variables.
2501: FETCH Cur_recipe_override INTO l_recipe_no, l_recipe_version, l_organization_code;
2502: IF Cur_recipe_override%FOUND THEN
2503: CLOSE Cur_recipe_override;
2504: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2505: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2506: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2507: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2508: fnd_msg_pub.ADD;

Line 2505: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);

2501: FETCH Cur_recipe_override INTO l_recipe_no, l_recipe_version, l_organization_code;
2502: IF Cur_recipe_override%FOUND THEN
2503: CLOSE Cur_recipe_override;
2504: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2505: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2506: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2507: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2508: fnd_msg_pub.ADD;
2509: X_return_status := FND_API.g_ret_sts_error;

Line 2506: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);

2502: IF Cur_recipe_override%FOUND THEN
2503: CLOSE Cur_recipe_override;
2504: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2505: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2506: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2507: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2508: fnd_msg_pub.ADD;
2509: X_return_status := FND_API.g_ret_sts_error;
2510: RAISE VALIDATION_FAIL;

Line 2507: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);

2503: CLOSE Cur_recipe_override;
2504: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2505: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2506: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2507: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2508: fnd_msg_pub.ADD;
2509: X_return_status := FND_API.g_ret_sts_error;
2510: RAISE VALIDATION_FAIL;
2511: END IF;

Line 2519: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');

2515: OPEN Cur_recipe_override_revision (pFormula_id, pInventory_item_id, pRevision);
2516: FETCH Cur_recipe_override_revision INTO l_recipe_no, l_recipe_version, l_organization_code;
2517: IF Cur_recipe_override_revision%FOUND THEN
2518: CLOSE Cur_recipe_override_revision;
2519: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2520: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2521: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2522: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2523: fnd_msg_pub.ADD;

Line 2520: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);

2516: FETCH Cur_recipe_override_revision INTO l_recipe_no, l_recipe_version, l_organization_code;
2517: IF Cur_recipe_override_revision%FOUND THEN
2518: CLOSE Cur_recipe_override_revision;
2519: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2520: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2521: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2522: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2523: fnd_msg_pub.ADD;
2524: X_return_status := FND_API.g_ret_sts_error;

Line 2521: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);

2517: IF Cur_recipe_override_revision%FOUND THEN
2518: CLOSE Cur_recipe_override_revision;
2519: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2520: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2521: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2522: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2523: fnd_msg_pub.ADD;
2524: X_return_status := FND_API.g_ret_sts_error;
2525: RAISE VALIDATION_FAIL;

Line 2522: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);

2518: CLOSE Cur_recipe_override_revision;
2519: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2520: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2521: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2522: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2523: fnd_msg_pub.ADD;
2524: X_return_status := FND_API.g_ret_sts_error;
2525: RAISE VALIDATION_FAIL;
2526: END IF;

Line 2533: FND_MESSAGE.set_name('GMD','GMD_VALIDITY_OWNER_ORG_NOT_ACC');

2529: OPEN Cur_recipe_validity (pFormula_id, pInventory_item_id);
2530: FETCH Cur_recipe_validity INTO l_organization_code, l_recipe_no, l_recipe_version;
2531: IF Cur_recipe_validity%FOUND THEN
2532: CLOSE Cur_recipe_validity;
2533: FND_MESSAGE.set_name('GMD','GMD_VALIDITY_OWNER_ORG_NOT_ACC');
2534: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2535: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2536: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2537: fnd_msg_pub.ADD;

Line 2534: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);

2530: FETCH Cur_recipe_validity INTO l_organization_code, l_recipe_no, l_recipe_version;
2531: IF Cur_recipe_validity%FOUND THEN
2532: CLOSE Cur_recipe_validity;
2533: FND_MESSAGE.set_name('GMD','GMD_VALIDITY_OWNER_ORG_NOT_ACC');
2534: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2535: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2536: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2537: fnd_msg_pub.ADD;
2538: X_return_status := FND_API.g_ret_sts_error;

Line 2535: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);

2531: IF Cur_recipe_validity%FOUND THEN
2532: CLOSE Cur_recipe_validity;
2533: FND_MESSAGE.set_name('GMD','GMD_VALIDITY_OWNER_ORG_NOT_ACC');
2534: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2535: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2536: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2537: fnd_msg_pub.ADD;
2538: X_return_status := FND_API.g_ret_sts_error;
2539: RAISE VALIDATION_FAIL;

Line 2536: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);

2532: CLOSE Cur_recipe_validity;
2533: FND_MESSAGE.set_name('GMD','GMD_VALIDITY_OWNER_ORG_NOT_ACC');
2534: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2535: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2536: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2537: fnd_msg_pub.ADD;
2538: X_return_status := FND_API.g_ret_sts_error;
2539: RAISE VALIDATION_FAIL;
2540: END IF;

Line 2548: FND_MESSAGE.set_name('GMD','GMD_REV_VALIDITY_ORG_NOT_ACC');

2544: OPEN Cur_recipe_validity_revision (pFormula_id, pInventory_item_id, pRevision);
2545: FETCH Cur_recipe_validity_revision INTO l_organization_code, l_recipe_no, l_recipe_version;
2546: IF Cur_recipe_validity_revision%FOUND THEN
2547: CLOSE Cur_recipe_validity_revision;
2548: FND_MESSAGE.set_name('GMD','GMD_REV_VALIDITY_ORG_NOT_ACC');
2549: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2550: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2551: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2552: fnd_msg_pub.ADD;

Line 2549: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);

2545: FETCH Cur_recipe_validity_revision INTO l_organization_code, l_recipe_no, l_recipe_version;
2546: IF Cur_recipe_validity_revision%FOUND THEN
2547: CLOSE Cur_recipe_validity_revision;
2548: FND_MESSAGE.set_name('GMD','GMD_REV_VALIDITY_ORG_NOT_ACC');
2549: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2550: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2551: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2552: fnd_msg_pub.ADD;
2553: X_return_status := FND_API.g_ret_sts_error;

Line 2550: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);

2546: IF Cur_recipe_validity_revision%FOUND THEN
2547: CLOSE Cur_recipe_validity_revision;
2548: FND_MESSAGE.set_name('GMD','GMD_REV_VALIDITY_ORG_NOT_ACC');
2549: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2550: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2551: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2552: fnd_msg_pub.ADD;
2553: X_return_status := FND_API.g_ret_sts_error;
2554: RAISE VALIDATION_FAIL;

Line 2551: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);

2547: CLOSE Cur_recipe_validity_revision;
2548: FND_MESSAGE.set_name('GMD','GMD_REV_VALIDITY_ORG_NOT_ACC');
2549: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2550: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2551: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2552: fnd_msg_pub.ADD;
2553: X_return_status := FND_API.g_ret_sts_error;
2554: RAISE VALIDATION_FAIL;
2555: END IF;

Line 2772: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');

2768: ,to_name => NULL);
2769:
2770: IF l_temp_qty < 0
2771: THEN
2772: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2773: fnd_message.set_token('UOM',l_conv_uom);
2774: fnd_msg_pub.ADD;
2775: RAISE CANNOT_CONVERT;
2776: END IF;

Line 2773: fnd_message.set_token('UOM',l_conv_uom);

2769:
2770: IF l_temp_qty < 0
2771: THEN
2772: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2773: fnd_message.set_token('UOM',l_conv_uom);
2774: fnd_msg_pub.ADD;
2775: RAISE CANNOT_CONVERT;
2776: END IF;
2777: ELSE

Line 2832: fnd_message.set_name ('GMD', 'GMD_ENTER_PERCENTAGE_YES');

2828: LOOP
2829: IF l_prod_prop_qty > 0 THEN
2830: /* Check whether Percentages have been enterd for all Proportional Products. */
2831: IF temp_prod_tbl1 (i).prod_percent IS NULL THEN
2832: fnd_message.set_name ('GMD', 'GMD_ENTER_PERCENTAGE_YES');
2833: fnd_msg_pub.ADD;
2834: RAISE CANNOT_CONVERT;
2835: END IF;
2836: l_prod_ratio := temp_prod_tbl1 (i).prod_percent / 100;

Line 2866: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');

2862:
2863: IF l_temp_qty < 0
2864: THEN
2865: x_return_status := 'Q';
2866: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2867: fnd_message.set_token('UOM',l_conv_uom);
2868: fnd_msg_pub.ADD;
2869: EXIT;
2870: END IF;

Line 2867: fnd_message.set_token('UOM',l_conv_uom);

2863: IF l_temp_qty < 0
2864: THEN
2865: x_return_status := 'Q';
2866: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2867: fnd_message.set_token('UOM',l_conv_uom);
2868: fnd_msg_pub.ADD;
2869: EXIT;
2870: END IF;
2871: ELSE