203: x_return_status := GMO_CONSTANTS_GRP.RETURN_STATUS_SUCCESS;
204: EXCEPTION
205: WHEN OTHERS THEN
206: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
207: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
208: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
210: X_MSG_DATA := fnd_message.get;
211: end; ---procedure;
204: EXCEPTION
205: WHEN OTHERS THEN
206: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
207: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
208: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
210: X_MSG_DATA := fnd_message.get;
211: end; ---procedure;
212:
205: WHEN OTHERS THEN
206: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
207: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
208: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
210: X_MSG_DATA := fnd_message.get;
211: end; ---procedure;
212:
213:
206: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
207: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
208: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
209: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
210: X_MSG_DATA := fnd_message.get;
211: end; ---procedure;
212:
213:
214:
488: x_return_status := fnd_api.g_ret_sts_error;
489: WHEN OTHERS THEN
490: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
492: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
493: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
494: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
495: END create_material_reservation;
496: PROCEDURE create_material_reservation (
489: WHEN OTHERS THEN
490: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
492: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
493: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
494: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
495: END create_material_reservation;
496: PROCEDURE create_material_reservation (
497: p_matl_dtl_rec IN gme_material_details%ROWTYPE
490: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
492: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
493: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
494: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
495: END create_material_reservation;
496: PROCEDURE create_material_reservation (
497: p_matl_dtl_rec IN gme_material_details%ROWTYPE
498: ,p_resv_qty IN NUMBER DEFAULT NULL