1749: END IF;
1750:
1751: --By product type validation
1752: IF (X_formula_dtl.line_type = 2) THEN
1753: Xreturn := FND_API.g_ret_sts_success;
1754: IF X_formula_dtl.by_product_type IS NOT NULL THEN
1755: --The value for by_product_type is only applicable for byproducts
1756: IF (X_formula_dtl.line_type <> 2) THEN
1757: RAISE inv_line_type;
1921: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', X_formula_dtl.formula_vers);
1922: FND_MSG_PUB.ADD;
1923:
1924: when inv_line_type THEN
1925: Xreturn := FND_API.g_ret_sts_error;
1926: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_LINE_BYPROD_TYP');
1927: FND_MSG_PUB.ADD;
1928: when inv_byprod_type THEN
1929: Xreturn := FND_API.g_ret_sts_error;
1925: Xreturn := FND_API.g_ret_sts_error;
1926: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_LINE_BYPROD_TYP');
1927: FND_MSG_PUB.ADD;
1928: when inv_byprod_type THEN
1929: Xreturn := FND_API.g_ret_sts_error;
1930: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_BYPROD_TYPE');
1931: FND_MSG_PUB.ADD;
1932:
1933: when check_type_exception then
1966: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_REVISION');
1967: FND_MSG_PUB.ADD;
1968: -- Bug 5350197
1969: when check_serial_exception then
1970: Xreturn := FND_API.g_ret_sts_error;
1971: FND_MESSAGE.SET_NAME('GMD', 'GMD_SERIAL_NOT_ALLOWED');
1972: FND_MSG_PUB.ADD;
1973:
1974: when check_no_revision_exception then
2063: END IF;
2064:
2065: --By product type validation
2066: IF (X_formula_dtl.line_type = 2) THEN
2067: Xreturn := FND_API.g_ret_sts_success;
2068: IF X_formula_dtl.by_product_type IS NOT NULL THEN
2069: --The value for by_product_type is only applicable for byproducts
2070: IF (X_formula_dtl.line_type <> 2) THEN
2071: RAISE inv_line_type;
2203: FND_MESSAGE.SET_TOKEN('FORMULA_VERS', X_formula_dtl.formula_vers);
2204: FND_MSG_PUB.ADD;
2205:
2206: when inv_line_type THEN
2207: Xreturn := FND_API.g_ret_sts_error;
2208: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_LINE_BYPROD_TYP');
2209: FND_MSG_PUB.ADD;
2210: when inv_byprod_type THEN
2211: Xreturn := FND_API.g_ret_sts_error;
2207: Xreturn := FND_API.g_ret_sts_error;
2208: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_LINE_BYPROD_TYP');
2209: FND_MSG_PUB.ADD;
2210: when inv_byprod_type THEN
2211: Xreturn := FND_API.g_ret_sts_error;
2212: FND_MESSAGE.SET_NAME('GMD', 'GMD_INV_BYPROD_TYPE');
2213: FND_MSG_PUB.ADD;
2214:
2215: when check_type_exception then