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

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

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

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

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

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

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

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

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

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

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

1257: IF l_product_qty > 0 THEN
1258: l_recipe_qty := l_product_qty;
1259: ELSE
1260: FND_MSG_PUB.INITIALIZE;
1261: FND_MESSAGE.SET_NAME ('GMD', 'GMD_ERR_CALC_ROUT_FACT');
1262: FND_MSG_PUB.add;
1263: x_return_status := 'W';
1264: RETURN 1;
1265: END IF;

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

1538:
1539: IF (l_max_capacity < 0) THEN
1540: /* Set a message in our stack : the capacity conv has not occurred */
1541: x_return_status := 'E';
1542: FND_MESSAGE.SET_NAME('GMD', 'GMD_CANNOT_CONV_CAPACITY_UOM');
1543: FND_MSG_PUB.Add;
1544: END IF; /* when max cap is < 0 */
1545:
1546: /* Get the step qty : */

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

2379: OPEN Cur_formula_own (pFormula_id, pInventory_item_id);
2380: FETCH Cur_formula_own INTO l_formula_no, l_formula_vers, l_organization_code;
2381: IF Cur_formula_own%FOUND THEN
2382: CLOSE Cur_formula_own;
2383: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2384: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2385: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2386: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2387: fnd_msg_pub.ADD;

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

2380: FETCH Cur_formula_own INTO l_formula_no, l_formula_vers, l_organization_code;
2381: IF Cur_formula_own%FOUND THEN
2382: CLOSE Cur_formula_own;
2383: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2384: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2385: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2386: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2387: fnd_msg_pub.ADD;
2388: X_return_status := FND_API.g_ret_sts_error;

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

2381: IF Cur_formula_own%FOUND THEN
2382: CLOSE Cur_formula_own;
2383: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2384: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2385: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2386: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2387: fnd_msg_pub.ADD;
2388: X_return_status := FND_API.g_ret_sts_error;
2389: RAISE VALIDATION_FAIL;

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

2382: CLOSE Cur_formula_own;
2383: FND_MESSAGE.set_name('GMD','GMD_FORM_OWNORG_NO_ACCESS');
2384: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2385: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2386: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2387: fnd_msg_pub.ADD;
2388: X_return_status := FND_API.g_ret_sts_error;
2389: RAISE VALIDATION_FAIL;
2390: END IF;

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

2394: OPEN Cur_formula_own_revision (pFormula_id, pInventory_item_id,pRevision);
2395: FETCH Cur_formula_own_revision INTO l_formula_no, l_formula_vers, l_organization_code;
2396: IF Cur_formula_own_revision%FOUND THEN
2397: CLOSE Cur_formula_own_revision;
2398: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2399: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2400: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2401: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2402: fnd_msg_pub.ADD;

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

2395: FETCH Cur_formula_own_revision INTO l_formula_no, l_formula_vers, l_organization_code;
2396: IF Cur_formula_own_revision%FOUND THEN
2397: CLOSE Cur_formula_own_revision;
2398: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2399: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2400: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2401: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2402: fnd_msg_pub.ADD;
2403: X_return_status := FND_API.g_ret_sts_error;

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

2396: IF Cur_formula_own_revision%FOUND THEN
2397: CLOSE Cur_formula_own_revision;
2398: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2399: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2400: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2401: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2402: fnd_msg_pub.ADD;
2403: X_return_status := FND_API.g_ret_sts_error;
2404: RAISE VALIDATION_FAIL;

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

2397: CLOSE Cur_formula_own_revision;
2398: FND_MESSAGE.set_name('GMD','GMD_FORM_REV_OWNORG_NO_ACCESS');
2399: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2400: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2401: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2402: fnd_msg_pub.ADD;
2403: X_return_status := FND_API.g_ret_sts_error;
2404: RAISE VALIDATION_FAIL;
2405: END IF;

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

2411: OPEN Cur_recipe_own (pFormula_id, pInventory_item_id);
2412: FETCH Cur_recipe_own INTO l_recipe_no, l_recipe_version, l_organization_code;
2413: IF Cur_recipe_own%FOUND THEN
2414: CLOSE Cur_recipe_own;
2415: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2416: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2417: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2418: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2419: fnd_msg_pub.ADD;

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

2412: FETCH Cur_recipe_own INTO l_recipe_no, l_recipe_version, l_organization_code;
2413: IF Cur_recipe_own%FOUND THEN
2414: CLOSE Cur_recipe_own;
2415: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2416: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2417: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2418: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2419: fnd_msg_pub.ADD;
2420: X_return_status := FND_API.g_ret_sts_error;

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

2413: IF Cur_recipe_own%FOUND THEN
2414: CLOSE Cur_recipe_own;
2415: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2416: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2417: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2418: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2419: fnd_msg_pub.ADD;
2420: X_return_status := FND_API.g_ret_sts_error;
2421: RAISE VALIDATION_FAIL;

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

2414: CLOSE Cur_recipe_own;
2415: FND_MESSAGE.set_name('GMD','GMD_OWNER_ORG_NOT_ACCESSIBLE');
2416: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2417: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2418: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2419: fnd_msg_pub.ADD;
2420: X_return_status := FND_API.g_ret_sts_error;
2421: RAISE VALIDATION_FAIL;
2422: END IF;

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

2426: OPEN Cur_recipe_own_revision (pFormula_id, pInventory_item_id,pRevision);
2427: FETCH Cur_recipe_own_revision INTO l_recipe_no, l_recipe_version, l_organization_code;
2428: IF Cur_recipe_own_revision%FOUND THEN
2429: CLOSE Cur_recipe_own_revision;
2430: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2431: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2432: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2433: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2434: fnd_msg_pub.ADD;

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

2427: FETCH Cur_recipe_own_revision INTO l_recipe_no, l_recipe_version, l_organization_code;
2428: IF Cur_recipe_own_revision%FOUND THEN
2429: CLOSE Cur_recipe_own_revision;
2430: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2431: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2432: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2433: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2434: fnd_msg_pub.ADD;
2435: X_return_status := FND_API.g_ret_sts_error;

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

2428: IF Cur_recipe_own_revision%FOUND THEN
2429: CLOSE Cur_recipe_own_revision;
2430: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2431: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2432: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2433: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2434: fnd_msg_pub.ADD;
2435: X_return_status := FND_API.g_ret_sts_error;
2436: RAISE VALIDATION_FAIL;

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

2429: CLOSE Cur_recipe_own_revision;
2430: FND_MESSAGE.set_name('GMD','GMD_REV_OWNORG_NOT_ACCESSIBLE');
2431: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2432: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2433: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2434: fnd_msg_pub.ADD;
2435: X_return_status := FND_API.g_ret_sts_error;
2436: RAISE VALIDATION_FAIL;
2437: END IF;

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

2442: -- Bug 5237126 MK Changed the order of variables.
2443: FETCH Cur_recipe_override INTO l_recipe_no, l_recipe_version, l_organization_code;
2444: IF Cur_recipe_override%FOUND THEN
2445: CLOSE Cur_recipe_override;
2446: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2447: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2448: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2449: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2450: fnd_msg_pub.ADD;

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

2443: FETCH Cur_recipe_override INTO l_recipe_no, l_recipe_version, l_organization_code;
2444: IF Cur_recipe_override%FOUND THEN
2445: CLOSE Cur_recipe_override;
2446: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2447: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2448: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2449: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2450: fnd_msg_pub.ADD;
2451: X_return_status := FND_API.g_ret_sts_error;

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

2444: IF Cur_recipe_override%FOUND THEN
2445: CLOSE Cur_recipe_override;
2446: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2447: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2448: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2449: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2450: fnd_msg_pub.ADD;
2451: X_return_status := FND_API.g_ret_sts_error;
2452: RAISE VALIDATION_FAIL;

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

2445: CLOSE Cur_recipe_override;
2446: FND_MESSAGE.set_name('GMD','GMD_OVERRIDE_ORG_NOT_ACCESSIBL');
2447: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2448: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2449: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2450: fnd_msg_pub.ADD;
2451: X_return_status := FND_API.g_ret_sts_error;
2452: RAISE VALIDATION_FAIL;
2453: END IF;

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

2457: OPEN Cur_recipe_override_revision (pFormula_id, pInventory_item_id, pRevision);
2458: FETCH Cur_recipe_override_revision INTO l_recipe_no, l_recipe_version, l_organization_code;
2459: IF Cur_recipe_override_revision%FOUND THEN
2460: CLOSE Cur_recipe_override_revision;
2461: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2462: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2463: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2464: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2465: fnd_msg_pub.ADD;

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

2458: FETCH Cur_recipe_override_revision INTO l_recipe_no, l_recipe_version, l_organization_code;
2459: IF Cur_recipe_override_revision%FOUND THEN
2460: CLOSE Cur_recipe_override_revision;
2461: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2462: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2463: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2464: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2465: fnd_msg_pub.ADD;
2466: X_return_status := FND_API.g_ret_sts_error;

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

2459: IF Cur_recipe_override_revision%FOUND THEN
2460: CLOSE Cur_recipe_override_revision;
2461: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2462: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2463: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2464: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2465: fnd_msg_pub.ADD;
2466: X_return_status := FND_API.g_ret_sts_error;
2467: RAISE VALIDATION_FAIL;

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

2460: CLOSE Cur_recipe_override_revision;
2461: FND_MESSAGE.set_name('GMD','GMD_REV_OVERORG_NOT_ACCESSIBL');
2462: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2463: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2464: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2465: fnd_msg_pub.ADD;
2466: X_return_status := FND_API.g_ret_sts_error;
2467: RAISE VALIDATION_FAIL;
2468: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2695: ,to_name => NULL);
2696:
2697: IF l_temp_qty < 0
2698: THEN
2699: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2700: fnd_message.set_token('UOM',l_conv_uom);
2701: fnd_msg_pub.ADD;
2702: RAISE CANNOT_CONVERT;
2703: END IF;

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

2696:
2697: IF l_temp_qty < 0
2698: THEN
2699: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2700: fnd_message.set_token('UOM',l_conv_uom);
2701: fnd_msg_pub.ADD;
2702: RAISE CANNOT_CONVERT;
2703: END IF;
2704: ELSE

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

2755: LOOP
2756: IF l_prod_prop_qty > 0 THEN
2757: /* Check whether Percentages have been enterd for all Proportional Products. */
2758: IF temp_prod_tbl1 (i).prod_percent IS NULL THEN
2759: fnd_message.set_name ('GMD', 'GMD_ENTER_PERCENTAGE_YES');
2760: fnd_msg_pub.ADD;
2761: RAISE CANNOT_CONVERT;
2762: END IF;
2763: l_prod_ratio := temp_prod_tbl1 (i).prod_percent / 100;

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

2788:
2789: IF l_temp_qty < 0
2790: THEN
2791: x_return_status := 'Q';
2792: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2793: fnd_message.set_token('UOM',l_conv_uom);
2794: fnd_msg_pub.ADD;
2795: EXIT;
2796: END IF;

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

2789: IF l_temp_qty < 0
2790: THEN
2791: x_return_status := 'Q';
2792: fnd_message.set_name ('GMD', 'GMD_UOM_CONV_ERROR');
2793: fnd_message.set_token('UOM',l_conv_uom);
2794: fnd_msg_pub.ADD;
2795: EXIT;
2796: END IF;
2797: ELSE