79: EXCEPTION
80: WHEN NO_LAB_TYPE THEN
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_LAB_TYPE_PARM');
83: FND_MSG_PUB.ADD;
84: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
85: P_data => x_msg_data);
86: WHEN NO_ATTRIB_DATA THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
80: WHEN NO_LAB_TYPE THEN
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_LAB_TYPE_PARM');
83: FND_MSG_PUB.ADD;
84: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
85: P_data => x_msg_data);
86: WHEN NO_ATTRIB_DATA THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: FND_MESSAGE.SET_NAME('GMD', 'LM_NO_ATTRIB_DATA');
85: P_data => x_msg_data);
86: WHEN NO_ATTRIB_DATA THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: FND_MESSAGE.SET_NAME('GMD', 'LM_NO_ATTRIB_DATA');
89: FND_MSG_PUB.ADD;
90: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
91: P_data => x_msg_data);
92: END load_ingred_tp;
93:
86: WHEN NO_ATTRIB_DATA THEN
87: x_return_status := FND_API.G_RET_STS_ERROR;
88: FND_MESSAGE.SET_NAME('GMD', 'LM_NO_ATTRIB_DATA');
89: FND_MSG_PUB.ADD;
90: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
91: P_data => x_msg_data);
92: END load_ingred_tp;
93:
94: /*======================================================================
231: EXCEPTION
232: WHEN NO_LAB_TYPE THEN
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_LAB_TYPE_PARM');
235: FND_MSG_PUB.ADD;
236: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
237: P_data => x_msg_data);
238: WHEN NO_ATTRIB_DATA THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
232: WHEN NO_LAB_TYPE THEN
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_LAB_TYPE_PARM');
235: FND_MSG_PUB.ADD;
236: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
237: P_data => x_msg_data);
238: WHEN NO_ATTRIB_DATA THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MESSAGE.SET_NAME('GMD', 'LM_NO_ATTRIB_DATA');
237: P_data => x_msg_data);
238: WHEN NO_ATTRIB_DATA THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MESSAGE.SET_NAME('GMD', 'LM_NO_ATTRIB_DATA');
241: FND_MSG_PUB.ADD;
242: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
243: P_data => x_msg_data);
244: WHEN UOM_CONV_ERR THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
238: WHEN NO_ATTRIB_DATA THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: FND_MESSAGE.SET_NAME('GMD', 'LM_NO_ATTRIB_DATA');
241: FND_MSG_PUB.ADD;
242: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
243: P_data => x_msg_data);
244: WHEN UOM_CONV_ERR THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
242: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
243: P_data => x_msg_data);
244: WHEN UOM_CONV_ERR THEN
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: FND_MSG_PUB.COUNT_AND_GET(P_count => x_msg_count,
247: P_data => x_msg_data);
248: END load_prod_tp;
249:
250: /*======================================================================
483: WHEN OTHERS THEN
484: IF (dbms_sql.is_open(X_cur)) THEN
485: dbms_sql.close_cursor(X_cur);
486: END IF;
487: fnd_msg_pub.add_exc_msg ('GMD_TECH_PARAMS', 'CALCULATE_EXPR');
488: END;
489: END LOOP;
490: END calculate_expr;
491:
597: WHEN NO_UOM_CONV THEN
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_UOMCV');
600: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
601: FND_MSG_PUB.ADD;
602: WHEN BAD_SYS_UOM THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_SYSTEM_UOMS');
605: FND_MSG_PUB.ADD;
601: FND_MSG_PUB.ADD;
602: WHEN BAD_SYS_UOM THEN
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_SYSTEM_UOMS');
605: FND_MSG_PUB.ADD;
606: END convert_uoms;
607:
608: /*======================================================================
609: -- PROCEDURE :
836: WHEN NO_UOM_CONV THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_UOMCV');
839: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
840: FND_MSG_PUB.ADD;
841: END rollup_cost_and_units;
842:
843: /*======================================================================
844: -- PROCEDURE :
911: WHEN NO_UOM_CONV THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_UOMCV');
914: FND_MESSAGE.SET_TOKEN('ITEM_NO', X_item_no);
915: FND_MSG_PUB.ADD;
916: END rollup_equiv_wt;
917:
918:
919: /*======================================================================
1023:
1024: EXCEPTION
1025: WHEN NO_LAB_TYPE THEN
1026: FND_MESSAGE.SET_NAME('GMD', 'LM_BAD_LAB_TYPE_PARM');
1027: FND_MSG_PUB.ADD;
1028: RETURN -1;
1029:
1030: WHEN NO_ATTRIB_DATA THEN
1031: FND_MESSAGE.SET_NAME('GMD', 'LM_NO_ATTRIB_DATA');
1028: RETURN -1;
1029:
1030: WHEN NO_ATTRIB_DATA THEN
1031: FND_MESSAGE.SET_NAME('GMD', 'LM_NO_ATTRIB_DATA');
1032: FND_MSG_PUB.ADD;
1033: RETURN 0;
1034:
1035: WHEN OTHERS THEN
1036: RETURN -1;