317: x_return_status := GMO_CONSTANTS_GRP.RETURN_STATUS_SUCCESS;
318: EXCEPTION
319: WHEN OTHERS THEN
320: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
322: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
324: X_MSG_DATA := fnd_message.get;
325: end; ---procedure;
318: EXCEPTION
319: WHEN OTHERS THEN
320: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
322: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
324: X_MSG_DATA := fnd_message.get;
325: end; ---procedure;
326:
319: WHEN OTHERS THEN
320: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
322: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
324: X_MSG_DATA := fnd_message.get;
325: end; ---procedure;
326:
327:
320: X_RETURN_STATUS := GMO_CONSTANTS_GRP.RETURN_STATUS_UNEXP_ERROR;
321: FND_MESSAGE.SET_NAME('GMO','GMO_UNEXPECTED_DB_ERR');
322: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
323: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
324: X_MSG_DATA := fnd_message.get;
325: end; ---procedure;
326:
327:
328:
602: x_return_status := fnd_api.g_ret_sts_error;
603: WHEN OTHERS THEN
604: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
607: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
609: END create_material_reservation;
610: PROCEDURE create_material_reservation (
603: WHEN OTHERS THEN
604: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
607: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
609: END create_material_reservation;
610: PROCEDURE create_material_reservation (
611: p_matl_dtl_rec IN gme_material_details%ROWTYPE
604: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
607: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
609: END create_material_reservation;
610: PROCEDURE create_material_reservation (
611: p_matl_dtl_rec IN gme_material_details%ROWTYPE
612: ,p_resv_qty IN NUMBER DEFAULT NULL